[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Totalliing

Subject: Totalliing
From: J_Eugene_Bernard/VML/IT/SGCORP/SANMAR@xxxxxxxxxxxxxxx
Date: Wed, 20 Oct 2004 16:06:47 +0530
exothermic sleeves
Hi all,

Please find three files "stkmis5.xml","Stkmis5.htm" and stkmis.xsl 

I want to get a totalled sum for the nodes "Qty" and "Value" when i open 
the stkmis5.htm

any help greately appreciated

Thanks
Eugene


<<Contents of file stkmis5.xml>>

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' 
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' 
xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'>
<rs:data>
<z:row item='3000110'  desc='1 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       93.0000'  rate='        4.39'  value=' 
408.2700'/>
<z:row item='3000210'  desc='1 1/2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      800.0000'  rate='        7.32'  value=' 
5856.0000'/>
<z:row item='3000310'  desc='2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      967.0000'  rate='        8.64'  value=' 
8354.8800'/>
<z:row item='3000410'  desc='2 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      115.0000'  rate='        7.93'  value=' 
911.9500'/>
<z:row item='3000510'  desc='2 1/2 x 3 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      512.0000'  rate='       10.42'  value=' 
5335.0400'/>
<z:row item='3000610'  desc='2 1/2 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      840.0000'  rate='       10.32'  value=' 
8668.8000'/>
<z:row item='3000710'  desc='3 x 4 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     1211.0000'  rate='       15.84'  value=' 
19182.2400'/>
<z:row item='3000810'  desc='3 x 6 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       80.0000'  rate='       20.75'  value=' 
1660.0000'/>
<z:row item='3001010'  desc='4 x 6 OPEN  EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='       96.0000'  rate='       30.27'  value='   2905.9200'/>
<z:row item='3001110'  desc='4 1/2 x 6 OPEN    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      370.0000'  rate='       32.99'  value=' 
12206.3000'/>
<z:row item='3001610'  desc='KLX 86(S) PN  80 X 150 SLEEVE     '  uom='NOS 
 '  qty='       46.0000'  rate='       34.01'  value='   1564.4600'/>
<z:row item='3001710'  desc='KLX 86(S) PN  90 X 150 SLEEVE     '  uom='NOS 
 '  qty='       32.0000'  rate='       42.39'  value='   1356.4800'/>
<z:row item='3001810'  desc='KLX 86(S) PN 100 X 150 SLEEVE     '  uom='NOS 
 '  qty='       12.0000'  rate='       50.23'  value='    602.7600'/>
<z:row item='3001910'  desc='KLX 86(S) PN 125 X 150 SLEEVE     '  uom='NOS 
 '  qty='      141.0000'  rate='       74.30'  value='  10476.3000'/>
<z:row item='3001930'  desc='KLX N200 OPEN SLEEVE     '  uom='NOS  ' qty=' 
     310.0000'  rate='      127.15'  value='  39416.5000'/>
<z:row item='3002510'  desc='5 1/2 X 6 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       10.0000'  rate='       35.88'  value=' 
358.8000'/>
<z:row item='3002610'  desc='5 X 8 OPEN EXOTHERMIC SLEEVES     '  uom='NOS 
 '  qty='        4.0000'  rate='       44.00'  value='    176.0000'/>
<z:row item='3002710'  desc='5 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       52.0000'  rate='       35.97'  value=' 
1870.4400'/>
<z:row item='3002810'  desc='6 X 6 OPEN  EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='      118.0000'  rate='       41.30'  value='   4873.4000'/>
<z:row item='3002910'  desc='8 X 6 OPEN EXOTHERMIC SLEEVES     '  uom='NOS 
 '  qty='       73.0000'  rate='       68.53'  value='   5002.6900'/>
<z:row item='3003010'  desc='7 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       47.0000'  rate='       62.76'  value='   2949.7200'/>
<z:row item='3003110'  desc='9 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       70.0000'  rate='       85.50'  value='   5985.0000'/>
<z:row item='3003210'  desc='6 1/2 X 6 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       97.0000'  rate='       50.89'  value=' 
4936.3300'/>
<z:row item='3003310'  desc='6 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       20.0000'  rate='       66.70'  value=' 
1334.0000'/>
<z:row item='3003410'  desc='3 1/2 x 8 OPEN SLEEVE     '  uom='NOS  ' 
qty='       21.0000'  rate='       33.54'  value='    704.3400'/>
<z:row item='3003510'  desc='6 x 8 OPEN SLEEVE     '  uom='NOS  '  qty='   
  3.0000'  rate='       54.94'  value='    164.8200'/>
<z:row item='3003610'  desc='5 X 4 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='       37.0000'  rate='       22.13'  value='    818.8100'/>
<z:row item='3005210'  desc='11 X 15 OPEN EXOTHERMIC SLEEVE     ' uom='NOS 
 '  qty='       36.0000'  rate='      308.16'  value='  11093.7600'/>
<z:row item='3005310'  desc='11 X 15 OPEN SLEEVE (KALMIN 81 N275)     ' 
uom='NOS  '  qty='        6.0000'  rate='      138.40'  value=' 
830.4000'/>
<z:row item='3005510'  desc='4 X 5 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
'  qty='      202.0000'  rate='       23.11'  value='   4668.2200'/>
<z:row item='3005610'  desc='2 1/2 x 6 OPEN SLEEVE     '  uom='NOS  ' 
qty='      228.0000'  rate='       15.49'  value='   3531.7200'/>
<z:row item='3005710'  desc='5 1/2 X 9 OPEN SLEEVE     '  uom='NOS  ' 
qty='       91.0000'  rate='       37.13'  value='   3378.8300'/>
<z:row item='3005810'  desc='1 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      382.0000'  rate='        7.01'  value=' 
2677.8200'/>
<z:row item='3005910'  desc='2 X 6 OPEN SLEEVE     '  uom='NOS  '  qty='   
 43.0000'  rate='       11.85'  value='    509.5500'/>
<z:row item='3006110'  desc='10 X 15 OPEN EXOTHERMIC SLEEVE     ' uom='NOS 
 '  qty='       11.0000'  rate='      317.81'  value='   3495.9100'/>
<z:row item='3006210'  desc='4 1/2 X 3 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       20.0000'  rate='       15.00'  value=' 
300.0000'/>
<z:row item='3006410'  desc='5 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       11.0000'  rate='       24.54'  value=' 
269.9400'/>
<z:row item='3006610'  desc='3 1/2 X 4 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       28.0000'  rate='       15.05'  value=' 
421.4000'/>
<z:row item='3006710'  desc='4 1/2 X 8 OPEN EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='        2.0000'  rate='       39.88'  value=' 79.7600'/>
<z:row item='3006810'  desc='14 X 6 OPEN EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='        7.0000'  rate='      265.20'  value='   1856.4000'/>
<z:row item='30F3110'  desc='N225 KALMIN 81 (9 X 8) INSULATING SLEEVE  ' 
uom='NOS  '  qty='        1.0000'  rate='      104.63'  value=' 
104.6300'/>
<z:row item='30F3610'  desc='N250 KALMINEX 30 (10 X 8) OPEN EXO SLEEVE  ' 
uom='NOS  '  qty='      318.0000'  rate='      190.46'  value=' 
60566.2800'/>
<z:row item='30F4910'  desc='N180 KALMINEX 30 (7X8) EXOTHERMIC SLEEVE  ' 
uom='NOS  '  qty='      177.0000'  rate='      130.81'  value=' 
23153.3700'/>
<z:row item='30F5010'  desc='N150 KALMINEX 30 (6X8) EXOTHERMIC SLEEVE  ' 
uom='NOS  '  qty='      220.0000'  rate='       98.87'  value=' 
21751.4000'/>
<z:row item='3100110'  desc='1 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       83.0000'  rate='        4.83'  value=' 
400.8900'/>
<z:row item='3100210'  desc='1 1/2 x 3  BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     1676.0000'  rate='        7.33'  value=' 
12285.0800'/>
<z:row item='3100310'  desc='2 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='     2451.0000'  rate='        9.42'  value=' 
23088.4200'/>
<z:row item='3100410'  desc='2 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      391.0000'  rate='        8.71'  value=' 
3405.6100'/>
<z:row item='3100510'  desc='2 1/2 x 3 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      130.0000'  rate='        7.75'  value=' 
1007.5000'/>
<z:row item='3100610'  desc='2 1/2 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      252.0000'  rate='       11.19'  value=' 
2819.8800'/>
<z:row item='3100710'  desc='3 x 4 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       55.0000'  rate='       14.28'  value=' 
785.4000'/>
<z:row item='3100810'  desc='3 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       50.0000'  rate='       19.16'  value=' 
958.0000'/>
<z:row item='3100910'  desc='3 1/2 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       67.0000'  rate='       24.67'  value=' 
1652.8900'/>
<z:row item='3101010'  desc='4 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       28.0000'  rate='       28.42'  value=' 
795.7600'/>
<z:row item='3101110'  desc='4 1/2 x 6 BLIND    EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       21.0000'  rate='       33.68'  value=' 
707.2800'/>
<z:row item='3101410'  desc='KLX 86(S) PN SFP 6/9K SLEEVE     '  uom='NOS 
'  qty='     1200.0000'  rate='       18.83'  value='  22596.0000'/>
<z:row item='3101510'  desc='KLX 86(S) PN SFP 7/10K SLEEVE     '  uom='NOS 
 '  qty='     1100.0000'  rate='       25.41'  value='  27951.0000'/>
<z:row item='3102410'  desc='5 X 6 BLIND EXOTHERMIC SLEEVE     '  uom='NOS 
 '  qty='       73.0000'  rate='       32.72'  value='   2388.5600'/>
<z:row item='3102510'  desc='5 1/2 X 6 BLIND EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='       66.0000'  rate='       36.78'  value=' 
2427.4800'/>
<z:row item='3105610'  desc='2 1/2 X 6 BLIND SLEEVE     '  uom='NOS  ' 
qty='       60.0000'  rate='       15.47'  value='    928.2000'/>
<z:row item='3105810'  desc='1 1/2 X 4 BLIND EXOTHERMIC SLEEVE     ' 
uom='NOS  '  qty='      229.0000'  rate='        7.60'  value=' 
1740.4000'/>
<z:row item='3105910'  desc='2 X 6 BLIND SLEEVE     '  uom='NOS  '  qty='  
   153.0000'  rate='       12.13'  value='   1855.8900'/>
<z:row item='3K00110'  desc='KALPUR ST 90 X 200     '  uom='NOS  '  qty='  
    10.0000'  rate='      565.22'  value='   5652.2000'/>
<z:row item='3K00210'  desc='KALPUR ST 70 X 175     '  uom='NOS  '  qty='  
   204.0000'  rate='      303.47'  value='  61907.8800'/>
<z:row item='3K00310'  desc='KALPAD 10 300 X 300 20     '  uom='NOS  ' 
qty='        8.0000'  rate='      193.60'  value='   1548.8000'/>
<z:row item='3K00410'  desc='KALMIN 70 M PN 70X100     '  uom='NOS  ' 
qty='       50.0000'  rate='       13.60'  value='    680.0000'/>
<z:row item='3K00610'  desc='KALMIN 70 M PN100X150     '  uom='NOS  ' 
qty='       91.0000'  rate='       24.86'  value='   2262.2600'/>
<z:row item='3K00710'  desc='KALPUR ST 50 X 150     '  uom='NOS  '  qty='  
    44.0000'  rate='      167.42'  value='   7366.4800'/>
</rs:data>
</xml>



<< contents of stkmis5.htm>>

<HTML>
<BODY>
<HEAD>
<TITLE> Stores Stock Statement - Scrap</TITLE>
        <SCRIPT LANGUAGE="JavaScript" FOR="window" EVENT="onload">
                showSorted('item','number')
        </SCRIPT>
        <SCRIPT LANGUAGE="JavaScript">
        function showSorted(SortOrder,SortType)
        {
        /* Converted to JavaScript from a code of Trace Wilson at
        http://www.vbxml.com/snippetcentral
        How to pass values into an XSLT stylesheet from ASP */
                var xml = new 
ActiveXObject("Msxml2.FreeThreadedDOMDocument");
                var xsl = new 
ActiveXObject("Msxml2.FreeThreadedDOMDocument");
                xml.async = false;
                xsl.async = false;
                xml.load ("stkmis5.xml");
                xsl.load ("stkmis.xsl");
                var template = new ActiveXObject("Msxml2.XSLTemplate");
                template.stylesheet = xsl;
                var myProc = template.createProcessor();
                myProc.input = xml; //XML_RptFormat.documentElement;
                myProc.addParameter ("SortBy",SortOrder);
                myProc.addParameter ("SortType",SortType);
                myProc.transform;
                RptData.innerHTML = myProc.output; 
        }
        </SCRIPT>
</HEAD>
<a href="x:\stores\stkmis1.htm">Ferro Alloys</a>
<a href="x:\stores\stkmis2.htm">Returns</a>
<a href="x:\stores\stkmis3.htm">Mould Coat</a>
<a href="x:\stores\stkmis.htm">Scrap</a>
<BODY BGCOLOR="#FFFFFF">
<DIV ID="RptData"> </DIV>
</BODY>
</HTML>



<<Contents of stkmis.xsl>>

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
  exclude-result-prefixes="rs z"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:rs="urn:schemas-microsoft-com:rowset"
  xmlns:z="#RowsetSchema">
<xsl:output method="html"/>
<xsl:param name = "SortBy"/>
<xsl:param name = "SortType" select='number'/>
<xsl:template match="/">
<HTML><BODY>
<h4>SANMAR FOUNDRIES LIMITED - STOCK STATUS</h4>
<TABLE border='1' cellspacing="" cellpadding="4">
  <TR bgcolor='#FFFF00'>
                <TD width='75'><A 
HREF="javascript:showSorted('item','text')">Item Code</A></TD>
                <TD width='100'><A 
HREF="javascript:showSorted('desc','text')">Item Description</A></TD>
                <TD width='75'><A 
HREF="javascript:showSorted('uom','number')">UOM</A></TD>
                <TD width='100'><A 
HREF="javascript:showSorted('qty','number')">Quantity</A></TD>
                <TD width='75' ><A 
HREF="javascript:showSorted('rate','number')">Rate</A></TD>
                <TD width='75' ><A 
HREF="javascript:showSorted('value','number')">Value</A></TD>
  </TR>
  <xsl:apply-templates select="xml/rs:data/z:row">
                <xsl:sort select ='@*[name(.) = $SortBy]' 
data-type="{$SortType}"/>
  </xsl:apply-templates>
</TABLE></BODY></HTML>
</xsl:template>

<xsl:template match = "z:row">
        <TR> 
                <TD><xsl:value-of select='@item'/></TD>
                <TD><xsl:value-of select='@desc'/></TD>
                <TD><xsl:value-of select='@uom'/></TD>
                <TD align="right"><xsl:value-of select='@qty'/></TD> 
                <TD align="right"><xsl:value-of select='@rate'/></TD>  
<TD align="right"><xsl:value-of select='@value'/></TD> 
        </TR>
</xsl:template> 
</xsl:stylesheet>

*************************

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

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

Buy Stylus Studio Now

Download The World's Best XML IDE!

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

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.