Re: [xsl] complicated xslt question

Please try the below 1.0 stylesheet:

<?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" />

  <xsl:template match="/stats">
    <html>
      <head>
        <title/>
      </head>
      <body>
        <xsl:for-each select="month">
          <table>
            <tr>
              <td>
                <xsl:value-of select="@name" />
              </td>
            </tr>
            <tr>
              <td/>
              <xsl:for-each select="site[1]/@*[starts-with(name(),'v')]">
                <td>
                  <xsl:value-of select="name()" />
                </td>
              </xsl:for-each>
            </tr>
            <xsl:for-each select="site">
              <tr>
                <td>
                  <xsl:value-of select="concat('site',@id)" />
                </td>
                <xsl:for-each select="@*[starts-with(name(),'v')]">
                  <td>
                    <xsl:value-of select="." />
                  </td>
                </xsl:for-each>
              </tr>
            </xsl:for-each>
            <tr>
              <td>sum</td>
              <xsl:for-each select="site[1]/@*[starts-with(name(),'v')]">
                <td>
                  <xsl:value-of select="sum(../../site/@*[name() =
name(current())])" />
                </td>
              </xsl:for-each>
            </tr>
          </table>
        </xsl:for-each>
        <table>
          <tr>
            <td>SUMMARY</td>
          </tr>
          <xsl:for-each select="month[1]/site[1]/@*[starts-with(name(),'v')]">
            <tr>
              <td>
                <xsl:value-of select="concat(name(),'_max')" />
              </td>
              <td>
                <xsl:call-template name="max">
                  <xsl:with-param name="months" select="../../../month" />
                  <xsl:with-param name="v" select="name()" />
                </xsl:call-template>
              </td>
            </tr>
          </xsl:for-each>
        </table>
      </body>
    </html>
  </xsl:template>

  <xsl:template name="max">
    <xsl:param name="months" />
    <xsl:param name="v" />

    <xsl:for-each select="$months">
      <xsl:sort select="sum(site/@*[name() = $v])" data-type="number"
order="descending" />
      <xsl:if test="position() = 1">
        <xsl:value-of select="sum(site/@*[name() = $v])" />
      </xsl:if>
    </xsl:for-each>
  </xsl:template>

</xsl:stylesheet>

I have tried to make the code generic, in a way that it doesn't assume
fixed no is <month> tags, <site> tags or vn attributes.

On 4/27/08, mike.shestakov@xxxxxxxxx wrote:
> Hi!
>  I'm trying to write XSL for a statistics page. (see XML below)
>  Each site has four values to analyse: v1, v2, v3 and v4.
>
>  The result of the transformation should be a set of tables for each
>  month and one summarizing table.
>  First I need  to calculate sum of each value. For example for March it
>  is v1_sum=100+100.
>  Next I need to find maximum value among summarized values of v1. This
>  is v1_max=max(200,330)=330
>  Here is an example:
>
>
>  March
>     | v1  v2  v3  v4
>  -----------------------
>  site1 | 100 200 300 400
>  site2 | 100 200 300 400
>  -----------------------
>  sum   | 200 400 600 800
>
>
>  April
>     | v1  v2  v3  v4
>  -----------------------
>  site1 | 110 210 310 410
>  site2 | 110 210 310 410
>  site2 | 110 210 310 410
>  -----------------------
>  sum   | 330 630 930 1230
>
>
>  SUMMARY
>  -----------------------
>  v1_max | 330
>  v2_max | 630
>  v3_max | 930
>  v4_max | 1230
>
>
>
>  I know how to find maximum among v1 values.
>  <xsl:variable name="v1_max">
>       <xsl:for-each select="month/@v1">
>               <xsl:sort data-type="number" order="descending"/>
>               <xsl:if test="position()=1"><xsl:value-of select="."/></xsl:if>
>       </xsl:for-each>
>  </xsl:variable>
>
>  But in the case described I need to find the max in the set of values
>  that has to be built first. Does anyone have any suggestions how to do
>  that?
>  Thanks!
>
>  XML
>  *****************
>  <?xml version="1.0" encoding="UTF-8"?>
>  <stats>
>       <month name="March, 2008">
>               <site id="1" v1="100" v2="200" v3="300" v4="400"/>
>               <site id="2" v1="100" v2="200" v3="300" v4="400"/>
>       </month>
>       <month name="April, 2008">
>               <site id="1" v1="110" v2="210" v3="310" v4="410"/>
>               <site id="2" v1="110" v2="210" v3="310" v4="410"/>
>               <site id="3" v1="110" v2="210" v3="310" v4="410"/>
>       </month>
>  </stats>


-- 
Regards,
Mukul Gandhi
<- Previous	Index	Next ->
[xsl] complicated xslt question, Михаил Шестаков	Thread	Re: [xsl] complicated xslt question, Florent Georges
Re: [xsl] Comparison of XSD, NVDL, , XSL-List Owner	Date	Re: [xsl] complicated xslt question, Florent Georges
	Month
<-prev [Thread] next->	<-prev [Date] next->
Month Index \| List Home