webmasterbeta
New Member
XML:
<lines>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories>
<accessory mandatory="mandatory">
<lineWeeklyRate>100</lineWeeklyRate>
<linePriceMultiplied>500</linePriceMultiplied>
<lineQtyMultiplied>1000</lineQtyMultiplied>
<warnings/>
<itemTexts/>
</accessory>
</accessories>
</line>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories/>
</line>
</lines>
I need to do the following:
For each line I need to summate the lineWeeklyRate of the line and any accessories that belong to that line.
I have tried the following and I know I need to use some sort of for-each or position, because at present the template is called for each line and summates ALL lines and accessories, hence giving the same total on all lines.
<xsl:template name="lineTotalForfait">
<xsl:variable name="mainLine"><xsl:value-of select="format-number(sum(/roots/root/record/header/lines/line/lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:variable name="accessory"><xsl:value-of select="format-number(sum(lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:value-of select="$mainLine + $accessory" />
</xsl:template>
Any ideas?
This is driving me mad and I know it is quite simple.
Kind Regards and Many Thanks in Advance
Chris Booth - UK
<lines>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories>
<accessory mandatory="mandatory">
<lineWeeklyRate>100</lineWeeklyRate>
<linePriceMultiplied>500</linePriceMultiplied>
<lineQtyMultiplied>1000</lineQtyMultiplied>
<warnings/>
<itemTexts/>
</accessory>
</accessories>
</line>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories/>
</line>
</lines>
I need to do the following:
For each line I need to summate the lineWeeklyRate of the line and any accessories that belong to that line.
I have tried the following and I know I need to use some sort of for-each or position, because at present the template is called for each line and summates ALL lines and accessories, hence giving the same total on all lines.
<xsl:template name="lineTotalForfait">
<xsl:variable name="mainLine"><xsl:value-of select="format-number(sum(/roots/root/record/header/lines/line/lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:variable name="accessory"><xsl:value-of select="format-number(sum(lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:value-of select="$mainLine + $accessory" />
</xsl:template>
Any ideas?
This is driving me mad and I know it is quite simple.
Kind Regards and Many Thanks in Advance
Chris Booth - UK