<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<xsl:script><![CDATA[
	var isOddrow = false;

	function checkRow() 
	{
		isOddrow = !isOddrow;
		if (isOddrow == true) 
			return "oddrow";
		else
			return "evenrow";
	}
	
	function totalCost(node)
	{
		var sum = 0;
		var nodeList;
		nodeList = node.selectNodes("DVD");
		for (var i=0; i< nodeList.length; i++)
		{
			sum += parseFloat(nodeList.item(i).getAttribute('totalPrice'));
		}

		return formatNumber(sum, "$0.00");		
	}
	
	function averageCost(node)
	{
		var sum = 0;
		var nodeList;
		nodeList = node.selectNodes("DVD");
		for (var i=0; i< nodeList.length; i++)
		{
			sum += parseFloat(nodeList.item(i).getAttribute('totalPrice'));
		}

		return formatNumber(sum / nodeList.length, "$0.00");		
	}
]]></xsl:script>

<xsl:template match="/">
	<xsl:apply-templates select="DVDDATA/DVDLIST"/>
</xsl:template>

<xsl:template match="DVDDATA/DVDLIST">
	<TABLE border="0">
	<TR class="columntitle">
	<TD onClick="sort('@title')">Title</TD>
	<TD onClick="sort('date(@purchaseDate)')">Purchase Date</TD>
	<TD onClick="sort('@vendor')">Vendor</TD>
	<TD onClick="sort('number(@totalPrice)')">Total Price</TD>		
	</TR>
	<xsl:for-each select="DVD" order-by="@title">
		<TR valign="top">
		<xsl:attribute name="class"><xsl:eval>checkRow()</xsl:eval></xsl:attribute>
		<TD><xsl:value-of select="@title"/></TD>
		<TD><xsl:value-of select="@purchaseDate"/></TD>
		<TD><xsl:value-of select="@vendor"/></TD>						
		<TD><xsl:apply-templates select="@totalPrice"/></TD>
		</TR>
	</xsl:for-each>
	
	<TR bgcolor="#F1F1E0">
	<TD colspan="3"><B>Total amount paid....</B></TD>
	<TD><B><xsl:eval>totalCost(this)</xsl:eval></B></TD>
	</TR>
	<TR bgcolor="#F1F1E0">
	<TD colspan="3"><B>Average price paid....</B></TD>
	<TD><B><xsl:eval>averageCost(this)</xsl:eval></B></TD>
	</TR>
	</TABLE>
</xsl:template>

<xsl:template match="@totalPrice">
	<xsl:eval>formatNumber(this.nodeTypedValue, "$0.00")</xsl:eval>
</xsl:template>

</xsl:stylesheet>
