grouping date ranges with associated sums

Play the video

Subject: grouping date ranges with associated sums
From: dmitrik@xxxxxxxxxxxxxx
Date: Mon, 29 Nov 2004 12:13:04 -0500 (GMT-05:00)

the following code produces

Trade
ED.TEST total:20 
ED.TESTFX1 total:7840 

what is required to break out the sums into dates ranges, for 
example from today until 1 year - any MinFlowDate which falls within that 
range will be summed, and then to be able to specify another date range
with an associated sum.

tia,
dk


<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="Ed1.xsl"?>
<Portfilio>
	<Trade>
		<TradeId>ED.TEST</TradeId>	
		<Step>
		   <MinFlowDate>11/11/2004</MinFlowDate>
		   <StepCharge_TTBlack>10</StepCharge_TTBlack>
		</Step>
		<Step>
		   <MinFlowDate>11/11/2005</MinFlowDate>
		   <StepCharge_TTBlack>10</StepCharge_TTBlack>
		</Step>
	</Trade>
	<Trade>
		<TradeId>ED.TESTFX1</TradeId>	
		<Step>
		   <MinFlowDate>11/11/2004</MinFlowDate>
		   <StepCharge_TTBlack>10</StepCharge_TTBlack>
		</Step>
		<Step>
		   <MinFlowDate>11/12/2004</MinFlowDate>
		   <StepCharge_TTBlack>60</StepCharge_TTBlack>
		</Step>
		<Step>
		   <MinFlowDate>11/11/2004</MinFlowDate>
		   <StepCharge_TTBlack>1450</StepCharge_TTBlack>
		</Step>
		<Step>
		   <MinFlowDate>11/11/2009</MinFlowDate>
		   <StepCharge_TTBlack>6320</StepCharge_TTBlack>
		</Step>
	</Trade>	
</Portfilio>


<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   version="1.0">

<xsl:output method="html" indent="yes" />

<xsl:template match="/">
   <html>
     <head>
       <title>Portfilio</title>
     </head>
     <body>
       <h1>Trade</h1>
       <xsl:apply-templates />
     </body>
   </html>
</xsl:template>

<xsl:template match="Portfilio">
   <table>
     <tbody>
       <xsl:apply-templates select="Trade" />
     </tbody>
   </table>
</xsl:template>

<xsl:template match="Trade">
   <tr>
     <td><xsl:value-of select="TradeId" /></td>
     <td>
       <xsl:text>total:</xsl:text>
       <xsl:call-template name="addSubtotals">
         <xsl:with-param name="Steps" select="Step" />
       </xsl:call-template>
     </td>
   </tr>
</xsl:template>

<xsl:template name="addSubtotals">
   <xsl:param name="Steps" />
   <xsl:variable name="Step1" select="$Steps[1]" />
   <xsl:variable name="RemainingItems" select="$Steps[position() &gt; 1]" />
   <xsl:variable name="subtotal" select="$Step1/StepCharge_TTBlack" />
   <xsl:choose>
     <xsl:when test="$RemainingItems">
       <xsl:variable name="subtotals">
         <xsl:call-template name="addSubtotals">
           <xsl:with-param name="Steps" select="$RemainingItems" />
         </xsl:call-template>
       </xsl:variable>
       <xsl:value-of select="$subtotal + $subtotals" />
     </xsl:when>
     <xsl:otherwise>
       <xsl:value-of select="$subtotal" />
     </xsl:otherwise>
   </xsl:choose>
</xsl:template>

</xsl:stylesheet>

Current Thread
grouping date ranges with associated sums dmitrik - 29 Nov 2004 17:13:29 -0000 <= David Carlisle - 29 Nov 2004 17:26:54 -0000 dsk - 30 Nov 2004 02:43:51 -0000 David Carlisle - 30 Nov 2004 15:14:34 -0000 <Possible follow-ups> dmitrik - 29 Nov 2004 17:54:27 -0000

<- Previous	Index	Next ->
RE: Add file name+path to pro, Robert Soesemann	Thread	Re: grouping date ranges with, David Carlisle
Re: Preseving character entit, David Carlisle	Date	Re: grouping date ranges with, David Carlisle
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Cast Your Vote

We need your help – Vote for DataDirect XML Products!

Best SOA or XML site

Winners and finalists announced at SOA World Conference in November.

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page