对xslt中的局部区域值求和

我有一个用户和小时的XML根

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="test_task_2.xsl"?> 
<root>
<users>
<user id="1" department="1">
<name>John Dow</name>
<phone>+7 (111) 111-11-11</phone>
<email>test1@test.test</email>
</user>
<user id="2" department="1">
<name>Stan Smith</name>
<phone>+7 (111) 111-11-22</phone>
<email>test2@test.test</email>
</user>
<user id="3" department="2">
<name>Homer Simpson</name>
<phone>+7 (111) 111-11-33</phone>
<email>test3@test.test</email>
</user>
<user id="4" department="3">
<name>Glen Quagmire</name>
<phone>+7 (111) 111-11-44</phone>
<email>test4@test.test</email>
</user>
<user id="5" department="2">
<name>Peter Griffin</name>
<phone>+7 (111) 111-11-55</phone>
<email>test5@test.test</email>
</user>
</users>
<hours>
<hour user="1" hours="10" />
<hour user="4" hours="8" />
<hour user="2" hours="7" />
<hour user="5" hours="5" />
<hour user="5" hours="13" />
<hour user="4" hours="11" />
<hour user="2" hours="2" />
<hour user="3" hours="3" />
<hour user="4" hours="1" />
<hour user="2" hours="1" />
<hour user="3" hours="6" />
<hour user="1" hours="9" />
</hours>
</root>

，我需要把它想象成一个表

<表类>id名称手机邮件小时和tbody><<tr>1约翰陶氏+ 7 (111) 111-11-11test1@test.test19

使用键解析交叉引用:

XSLT 1.0

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="hour" match="hour" use="@user" />
<xsl:template match="/root">
<html>
<body>
<label>departments</label>
<table border="1">
<tr bgcolor="#cccccc">
<th>id</th>
<th>name</th>
<th>phone</th>
<th>email</th>
<th>sum of hours</th>
</tr>
<xsl:for-each select="users/user">
<tr>
<td>
<xsl:value-of select="@id"/>
</td>
<td>
<xsl:value-of select="name"/>
</td>
<td><xsl:value-of select="phone"/>
</td>
<td>
<xsl:value-of select="email"/>
</td>
<td>
<xsl:value-of select="sum(key('hour', @id)/@hours)"/>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

相关内容

最新更新

热门标签：