Sorting the element with in the sorting element

[saran3b2]

Hi all,

If u know the solution please suggest me. I need these urgent.

production.xml

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="xsl/vinoth-new.xsl"?>
<report>
    <production>
        <etype>Break</etype>
        <user>thiyagu</user>
        <date>3/5/2008</date>
        <book>Traning</book>
        <file>Programming</file>
        <status>WIP</status>
        <task>RND</task>
        <starttime>11:24:23 PM</starttime>
        <endtime>11:46:21 PM</endtime>
        <totaltime> 22</totaltime>
        <updateto/>
        <comment>Tea Break</comment>
    </production>
    <production>
        <etype>Break</etype>
        <user>saravanan</user>
        <date>3/5/2008</date>
        <book>Traning</book>
        <file>Programming</file>
        <status>WIP</status>
        <task>RND</task>
        <starttime>11:24:23 PM</starttime>
        <endtime>11:46:21 PM</endtime>
        <totaltime>5</totaltime>
        <updateto/>
        <comment>Tea Break</comment>
    </production>
    <production>
        <etype>Job</etype>
        <user>sai</user>
        <date>3/6/2008</date>
        <book>aw</book>
        <file>`af</file>
        <status>ar </status>
        <task>Template</task>
        <starttime>2:23:58 PM</starttime>
        <endtime>2:24:05 PM</endtime>
        <totaltime> 1</totaltime>
        <updateto>awd </updateto>
        <comment>ef</comment>
    </production>
    <production>
        <etype>job</etype>
        <user>saravanan</user>
        <date>3/5/2008</date>
        <book>Traning</book>
        <file>Programming</file>
        <status>WIP</status>
        <task>RND</task>
        <starttime>01:46:21 PM</starttime>
        <endtime>02:46:21 PM</endtime>
        <totaltime>2</totaltime>
        <updateto/>
        <comment>QC pending</comment>
    </production>
    <production>
        <etype>Job</etype>
        <user>kapil</user>
        <date>3/6/2008</date>
        <book>dcadcad</book>
        <file>adcadc</file>
        <status>OVER</status>
        <task>XML</task>
        <starttime>2:19:02 AM</starttime>
        <endtime>2:19:19 PM</endtime>
        <totaltime> 0</totaltime>
        <updateto>adcadcac</updateto>
        <comment>adcadca</comment>
    </production>
    <production>
        <etype>Job</etype>
        <user>ksaravanan</user>
        <date>3/6/2008</date>
        <book>aw</book>
        <file>`af</file>
        <status>ar</status>
        <task>Template</task>
        <starttime>2:23:58 PM</starttime>
        <endtime>2:24:05 PM</endtime>
        <totaltime> 1</totaltime>
        <updateto>awd</updateto>
        <comment>ef</comment>
    </production>
    <production>
        <etype>Job</etype>
        <user>vinoth</user>
        <date>3/6/2008</date>
        <book>meiners</book>
        <file>chapter4</file>
        <status>qc</status>
        <task>XML</task>
        <starttime>6:52:44 PM</starttime>
        <endtime>6:53:36 PM</endtime>
        <totaltime> 1</totaltime>
        <updateto>add</updateto>
        <comment>xfb </comment>
    </production>
    <production>
        <etype>Break</etype>
        <user>vinoth</user>
        <date>3/6/2008</date>
        <book>meiners</book>
        <file>chapter4</file>
        <status>qc</status>
        <task>XML</task>
        <starttime>6:52:44 PM</starttime>
        <endtime>6:53:36 PM</endtime>
        <totaltime> 1</totaltime>
        <updateto>add</updateto>
        <comment>xfb </comment>
    </production>
</report>
 

I want to display these element as

sort with date
sort with task with in date
sort user with in task
sort etype with in user





now my xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" 
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output method="html" encoding="ISO-8859-1" doctype-public="-//W3C//DTD HTML 4.0 Transitional//EN"/>
<xsl:variable name="report" select="//production"/>
<!-- Define keys used to group elements -->
<xsl:key name="keyDate" match="production" use="date" />
<xsl:key name="keyUser" match="production" use="user" />
<xsl:key name="keyTask" match="production" use="task" />
<xsl:key name="keyEtype" match="production" use="etype" />
 
<xsl:template match="/">
 <html>
  <head>
   <title>Cengage Production Report</title>
  </head>
  <body>
<center>****************************************</center>
  <center><font size="6" color="brown">PreMedia Global P. Ltd.</font>
  </center>
<center>****************************************</center>
 
<center><font size="4" color="blue">Cengage Production Report</font></center><br/>
 
 
 
    <table width="80%" frame="box" border="2" align="center">
    <tbody>
<xsl:apply-templates/>
    </tbody>
    </table>
 
  </body>
 </html>
</xsl:template>
 
 
<xsl:template match="report" name="ShowproductionsInTeam">
 
<xsl:for-each select="$report">
 
 
<xsl:sort select="date" order="ascending"/>
 
 
<xsl:for-each select="$report[generate-id(.) = generate-id(key('keyTask', task)[1])]">
<xsl:sort select="task" order="ascending"/>
</xsl:for-each>
 
 
 
<xsl:variable name="date" select="date"/>
 
<xsl:if test="generate-id(.)=generate-id($report[date=$date])">
 
<tr>
    <td width="10%" colspan="8" align="center"><font size="5" color="Green">Date: <xsl:value-of select="date"/></font></td>
</tr>
</xsl:if>
 
<xsl:for-each select="$report[generate-id(.) = generate-id(key('keyDate', date)[1])]">
<xsl:sort select="task" order="ascending"/>
</xsl:for-each>
 
<xsl:variable name="task" select="task"/>
<xsl:if test="generate-id(.)=generate-id($report[task=$task]) or generate-id(.)=generate-id($report[date=$date])">
<tr  bgcolor="#9e7bff">
    <td width="10%" colspan="8"><h3><xsl:value-of select="task"/></h3></td>
</tr>
</xsl:if>
 
 <xsl:for-each select="$report[generate-id(.) = generate-id(key('keyDate', date)[1])]">
<xsl:sort select="user" order="ascending"/>
</xsl:for-each>
 
<xsl:variable name="user" select="user"/>
<xsl:if test="generate-id(.)=generate-id($report[user=$user]) or generate-id(.)=generate-id($report[date=$date])">
<tr  bgcolor="#dddddd">
    <td width="10%" colspan="8"><font color="blue" size="4"><xsl:value-of select="user"/></font></td>
</tr>
</xsl:if>
 
 <xsl:for-each select="$report[generate-id(.) = generate-id(key('keyUser', user)[1])]">
<xsl:sort select="etype" order="ascending"/>
</xsl:for-each>
 
<xsl:variable name="etype" select="etype"/>
<xsl:if test="generate-id(.)=generate-id($report[etype=$etype]) or generate-id(.)=generate-id($report[user=$user])">
 <tr>
            <th width="10%">Book</th>
            <th width="10%">File</th>
            <th width="10%">Status</th>
            <th width="10%">Start Time</th>
            <th width="10%">End Time</th>
            <th width="10%">Total time</th>
            <th width="10%">Updated To</th>
            <th width="10%">Comment</th>
</tr> 
</xsl:if>            
 
<tr>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="book" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="file" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="status" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="starttime" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="endtime" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="totaltime" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="updateto" /></td>
            <td width="10%" bgcolor="#dddddd"><xsl:value-of select="comment" /></td>            
</tr>
 
 
<xsl:variable name="totaltime" select="totaltime"/>
<xsl:if test="generate-id(.)=generate-id($report[user=$user]) ">
<tr>
    <th colspan="8" align="right"><font color="blue">Total time:   <xsl:value-of select="sum($report[user=$user]/totaltime)" /> minutes</font></th>
</tr>
</xsl:if>
 
 
 
</xsl:for-each>
 
</xsl:template>
 
</xsl:stylesheet>
 

Advance thanks for ur help

[MarkoKlacar]

Hi,

Could you re-post using code tags, otherwise it's difficult to say what row needs attention.

Thanks

[jkmyoung]

I think the word for it is subsort.

In this case you simply need an additional <xsl:sort/> element

But to be honest, I'm really not sure what you're trying to do.. the xsl is quite messy. things like
<xsl:for-each select="$report[generate-id(.) = generate-id(key('keyTask', task)[1])]">
<xsl:sort select="task" order="ascending"/>
</xsl:for-each>

do absolutely nothing, and shouldn't be in the code.

[saran3b2]

Hi MarkoKlacar,

Thanks 4 ur reply. As per previous mail. I have the (etype, user, book, file, status, task, starttime, endtime, totaltime, updateto, comment) elements. Here i want display these elements in stylesheet by

Date wise then task wise (All are must be ascending order in sub sorting) then user wise like as below mentioned:

Date: 2/5/2008

Task: RND

User: Thiyagu

Then display Book, file, status,.................
------------------------------------------------------------------------------------------

Date: 3/5/2008

Task: QC

User: Thiyagu

Then display Book, file, status,.................
------------------------------------------------------------------------------------------

And finally i want total time for each user by date wise.

I think this may be clear to u. Further any doubt i will like to explain details manner. (My E-mail id: [e-mail])


<report>
<production>
<etype>Break</etype>
<user>thiyagu</user>
<date>2/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>QC</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>Break</etype>
<user>thiyagu</user>
<date>3/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
------ and so on
</report

Hi,

Could you re-post using code tags, otherwise it's difficult to say what row needs attention.

Thanks

[saran3b2]

hi,

please ignore that watch the my reply to MarkoKlacar for clear doubt

I think the word for it is subsort.

In this case you simply need an additional <xsl:sort/> element

But to be honest, I'm really not sure what you're trying to do.. the xsl is quite messy. things like
<xsl:for-each select="$report[generate-id(.) = generate-id(key('keyTask', task)[1])]">
<xsl:sort select="task" order="ascending"/>
</xsl:for-each>

do absolutely nothing, and shouldn't be in the code.

[jkmyoung]

This took awhile:

<xsl:template match="report" name="ShowproductionsInTeam">
    <xsl:for-each select="$report[generate-id(.) = generate-id(key('keyDate', date)[1])]"><!-- Get unique dates -->
    <xsl:sort select="date" order="ascending"/>
        <xsl:variable name="date" select="date"/>
        <!-- output date information -->
        <tr>
            <td width="10%" colspan="8" align="center"><font size="5" color="Green">Date: <xsl:value-of select="date"/></font></td>
        </tr>
        <xsl:for-each select="key('keyDate')[generate-id(.) = generate-id(key('keyTask', concat(date,task))[1])]"> <!-- Get unique tasks within a date -->
        <xsl:sort select="task" order="ascending"/>
            <!-- output task information -->
            <tr  bgcolor="#9e7bff">
                <td width="10%" colspan="8"><h3><xsl:value-of select="task"/></h3></td>
            </tr>
 
            <xsl:for-each select="key('keyTask', concat(date,task))[count(. | key('keyDateTaskUser', concat(date, task,user))[1]) = 1]"><!-- get unique users within a dateTask -->
            <xsl:sort select="user" order="ascending"/>
                <!-- output user information -->
                <tr  bgcolor="#dddddd">
                    <td width="10%" colspan="8"><font color="blue" size="4"><xsl:value-of select="user"/></font></td>
                </tr>
                <xsl:for-each select="key('keyDateTaskUser', concat(date, task,user))[count (. | key('keyDateTaskUserEtype',concat(date, task,user,etype))[1]) = 1]">
                <xsl:sort select="etype" order="ascending"/> <!-- get unique etypes within a date task user. -->
                     <tr>
                        <th width="10%">Book</th>
                        <th width="10%">File</th>
                        <th width="10%">Status</th>
                        <th width="10%">Start Time</th>
                        <th width="10%">End Time</th>
                        <th width="10%">Total time</th>
                        <th width="10%">Updated To</th>
                        <th width="10%">Comment</th>
                    </tr>
                </xsl:for-each>
                <xsl:for-each select="key('keyDateTaskUserEtype',concat(date, task,user,etype))">
                    <tr>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="book" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="file" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="status" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="starttime" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="endtime" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="totaltime" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="updateto" /></td>
                        <td width="10%" bgcolor="#dddddd"><xsl:value-of select="comment" /></td>            
                    </tr>
                </xsl:for-each><!-- etype -->
            <tr><!-- This doesn't work, if a user is in multiple days--> 
                <th colspan="8" align="right"><font color="blue">Total time:   <xsl:value-of select="sum($report[user=$user]/totaltime)" /> minutes</font></th>
            </tr>
            </xsl:for-each><!-- user -->
        </xsl:for-each><!-- task -->
    </xsl:for-each><!-- date -->        
</xsl:template>