SSDN - Summarizing chiled nodes problem

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Ori Tsarfati

Subject: Summarizing chiled nodes problem
Author: Ori Tsarfati
Date: 04 Jan 2005 03:09 AM

this is my XML structure:
..
<o OrderID="10643">
<od ProductID="28" UnitPrice="45.6000" Quantity="15"/>
<od ProductID="39" UnitPrice="18.0000" Quantity="21"/>
<od ProductID="46" UnitPrice="12.0000" Quantity="2"/>
</o>
<o OrderID="10692">
<od ProductID="63" UnitPrice="43.9000" Quantity="20"/>
<od ProductID="50" UnitPrice="12.0000" Quantity="6"/>
</o>
..
this is my XSL:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:template match="/">
<table border="1" bgcolor="red">
<xsl:for-each select="//o">
<tr>
<td>
Order ID =
<xsl:value-of select="@OrderID"/>
</td>
<td>
total Quantity =
<xsl:value-of select="sum(child::node()/@Quantity)"/>
</td>
<td>
total order value =
<xsl:value-of select="sum(child::node()/@Quantity*child::node()/@UnitPrice)"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

the result is:
<table>
<tr>
<td>Order ID = 10643</td>
<td>total Quantity = 38</td> - right result (15+21+2)=38
<td>total order value = 684</td> - wrong result! should be ((45.6*15)+(18*21)+(12*2))=(684+378+24)=1086

</tr>
<tr>
<td>Order ID = 10692</td>
<td>total Quantity = 26</td> - right result
<td>total order value = 878</td> - wrong result!
</tr>
</table>

the problem is that the "sum(child::node()/@Quantity)" on a single node works fine, but
the "sum(child::node()/@Quantity*child::node()/@UnitPrice)" gives only the multiply result of the first node and doesn't summarize the other nodes!
any idea way?
10x in adv.
Ori

Ivan Pedruzzi

Subject: Summarizing chiled nodes problem
Author: Ivan Pedruzzi
Date: 05 Jan 2005 12:20 AM

You could use a recursive template

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:template match="/">
<html>
<table border="1">
<xsl:for-each select="//o">
<tr>
<td>Order ID = <xsl:value-of select="@OrderID"/></td>
<td>total Quantity = <xsl:value-of select="sum(od/@Quantity)"/></td>
<td>total order value =
<xsl:call-template name="tot">
<xsl:with-param name="source" select="*[1]"/>
</xsl:call-template>
</td>
</tr>
</xsl:for-each>
</table>
</html>
</xsl:template>

<xsl:template name="tot">
<xsl:param name="tot" select="0"/>
<xsl:param name="source"/>
<xsl:for-each select="$source[1]">
<xsl:choose>
<xsl:when test="following-sibling::*[1]">
<xsl:call-template name="tot">
<xsl:with-param name="tot" select="$tot + (@Quantity * @UnitPrice)"/>
<xsl:with-param name="source" select="following-sibling::*[1]"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$tot+ (@Quantity * @UnitPrice)"/>
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Ori Tsarfati

Subject: Summarizing chiled nodes problem
Author: Ori Tsarfati
Date: 06 Jan 2005 04:30 AM

it looks like we r missing the point, i don't belive that "sum(@xxx*@yyy)" is imposible!
writing this tamplate instead, is the last step, i'm sure that there is a simple way.
any way 10x for the efforts.
Ori.

Ori Tsarfati

Subject: Summarizing chiled nodes problem
Author: Ori Tsarfati
Date: 06 Jan 2005 05:44 AM

Well there is an elegant solution to this problem and it looks like this:
first of all u should add a namespace to the stylesheet header:
xmlns:exsl="urn:schemas-microsoft-com:xslt"
extension-element-prefixes="exsl"

then u can use this part:
<xsl:variable name="subTotals">
<xsl:for-each select="//od[../@OrderID=current()/@OrderID]">
<number>
<xsl:value-of select="@Quantity* @UnitPrice"/>
</number>
</xsl:for-each>
</xsl:variable>


<xsl:value-of select="sum(exsl:node-set($subTotals)/number)"/>

the right xsl will be:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format"
xmlns:exsl="urn:schemas-microsoft-com:xslt"
extension-element-prefixes="exsl">
<xsl:template match="/">
<table border="1" bgcolor="red">
<xsl:for-each select="//o">
<tr>
<td>
Order ID =
<xsl:value-of select="@OrderID"/>
</td>
<td>
total Quantity =
<xsl:value-of select="sum(child::node()/@Quantity)"/>
</td>
<td>
total order value =
<xsl:variable name="subTotals">
<xsl:for-each select="child::node()/@Quantity">
<number>
<xsl:value-of select="@Quantity* @UnitPrice"/>
</number>
</xsl:for-each>
</xsl:variable>

<xsl:value-of select="sum(exsl:node-set($subTotals)/number)"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

take a look at the original article, it is recomended:
http://www.xml.com/pub/a/2003/07/16/nodeset.html?page=last&x-maxdepth=0

Ivan Pedruzzi

Subject: Summarizing chiled nodes problem
Author: Ivan Pedruzzi
Date: 06 Jan 2005 11:00 AM

Hi Ori,

Thank you for the follow up.

I am not sure which meter we are using for elegancy here.

It interesting to note that the solution based on a recursive
template runs without any changes on any XSLT 1.0 implementations,
no extension or processor specific code is required.

Another interesting point: the second solution uses RTF to store
the partial result that could be a performance hit depending on
document size and shape.

Ivan
Hope this helps

Topic Page 1 2 3 4 5 6 7 8 9

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.