compare
My xml contains the reords of an employee shift and it's task. so it might be possible that one employee in one has to do many task. so my xml contains the reords as:
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>324</idTaskNo>
<strNameJob>C-DE</strNameJob>
<idTaskNo1>324</idTaskNo1>
<TaskStart>2007-01-05T02:30:00+05:30</TaskStart>
<TaskEnd>2007-01-05T04:15:00+05:30</TaskEnd>
<TaskName>C-DE5824</TaskName>
#000000
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: C-DE Task:C-DE5824 STA: STD: 03:45 AcOP: DE AcType: 320 Dest: TFS
PaxMax: 174 PaxBkd: 176</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>292</idTaskNo>
<strNameJob>BO</strNameJob>
<idTaskNo1>292</idTaskNo1>
<TaskStart>2007-01-05T04:15:00+05:30</TaskStart>
<TaskEnd>2007-01-05T04:55:00+05:30</TaskEnd>
<TaskName>DE5824</TaskName>
#000000
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: BO Task:DE5824 STA: STD: 03:45 AcOP: DE AcType: 320 Dest: TFS PaxMax:
174 PaxBkd: 176</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>296</idTaskNo>
<strNameJob>BO</strNameJob>
<idTaskNo1>296</idTaskNo1>
<TaskStart>2007-01-05T06:25:00+05:30</TaskStart>
<TaskEnd>2007-01-05T06:55:00+05:30</TaskEnd>
<TaskName>C91680</TaskName>
#000000
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: BO Task:C91680 STA: STD: 05:55 AcOP: C9 AcType: D38 Dest: ZRH PaxMax: 33 PaxBkd: 20</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>428</idTaskNo>
<strNameJob>CKI-F</strNameJob>
<idTaskNo1>428</idTaskNo1>
<TaskStart>2007-01-05T07:00:00+05:30</TaskStart>
<TaskEnd>2007-01-05T08:15:00+05:30</TaskEnd>
<TaskName>CKI-F</TaskName>
#000000
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>RoutineJob:CKI-F Task:CKI-F Start: 07:00 End: 08:15</ToolTip>
</Detail>
</NewDataSet>
xslt is:
<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="distinctShift" match="NewDataSet/Detail" use="./idShiftNo"/>
<xsl:template match="/">
<table>
<xsl:for-each select="NewDataSet/Detail[generate-id() = generate-id(key('distinctShift', ./idShiftNo)[1])]">
<tr>
<td>
<xsl:value-of select="idShiftNo"/>
</td>
<td>
<xsl:value-of select="ShiftName"/>
</td>
<td>
<xsl:for-each select="/NewDataSet/Detail[idShiftNo = current()/idShiftNo]">
<xsl:if test="position() != 1">,</xsl:if>
<xsl:value-of select="idTaskNo"/>
</xsl:for-each>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
The problem is that as i have to show this on a chart then there it shows as
but i wan't to show it like
72 Biswal, Antje shiftstarttime shiftendtime task1 task2
m able to show it like that one problem is there i wan't to compare the current TaskStart to the previous TaskStart.
How m able to do that???
Help m in this .
|