XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
benny benSubject: old "sum of price times quantity" problem
Author: benny ben
Date: 08 Apr 2006 12:45 PM
Input xml file
<item>
<sub-item>
<qty>1</qty>
<price>2</price>
</sub-item>
<sub-item>
<qty>2</qty>
<price>3</price>
</sub-item>
</item>
<item>
<sub-item>
<qty>3</qty>
<price>4</price>
</sub-item>
</item>

Expected output total =1*2+2*3+3*4

I need to use XSLT 1.0 and I can calculate the subtotal for each item by using the recrusive template but how can I calculate the total for all items? Do I need to write 2 recrusive template?

regards,
Benny

Postnext
Minollo I.Subject: old 'sum of price times quantity' problem
Author: Minollo I.
Date: 08 Apr 2006 11:19 PM
Something like this?

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<total>
<xsl:call-template name="getTotal">
<xsl:with-param name="subItems" select="//sub-item"/>
<xsl:with-param name="index" select="1"/>
</xsl:call-template>
</total>
</xsl:template>

<xsl:template name="getTotal">
<xsl:param name="subItems"/>
<xsl:param name="index"/>
<xsl:param name="total" select="0"/>
<xsl:choose>
<xsl:when test="$subItems[$index]">
<xsl:call-template name="getTotal">
<xsl:with-param name="subItems" select="$subItems"/>
<xsl:with-param name="index" select="$index + 1"/>
<xsl:with-param name="total" select="$total + $subItems[$index]/qty * $subItems[$index]/price"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$total"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet>

Postnext
benny benSubject: old 'sum of price times quantity' problem
Author: benny ben
Date: 11 Apr 2006 01:47 AM
Thanks.
1 more question: Will this method has performance overhead than the one using "position() >1" when there is only 2 level of document?

regards,
Benny

Posttop
Minollo I.Subject: old 'sum of price times quantity' problem
Author: Minollo I.
Date: 11 Apr 2006 11:21 AM
Not sure I understand the question; the method above may have a performance cost caused by the //sub-item search; if you have a large document, you may want to constrain that search a bit, making the path as explicit as you can... But that's not necessarily true if your XSLT processor is integrated with some form of repository that provides indexing on elements...

Minollo

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.