XLST:创建多个表
XLST:创建多个表
提问于 2020-03-09 16:06:44
我尝试使用for-each语句为每个元素"bill“创建一个表。XML文档如下所示：
<group>
<name>Casa Miles</name>
<student>
<id>sergio</id>
<name>sergio</name>
<surname>zavota</surname>
<bill>
<product>
<name>sapone piatti</name>
<amount>1</amount>
<prize>3.3</prize>
<participant>
<id>stefano</id>
</participant>
</product>
<product>
<name>bresaola</name>
<amount>1</amount>
<prize>5.5</prize>
<participant>
<id>sergio</id>
</participant>
</product>
<date>2020-02-03</date>
</bill>
</student>
<student>
<id>stefano</id>
<name>stefano</name>
<surname>silvestri</surname>
<bill>
<product>
<name>liquore</name>
<amount>2</amount>
<prize>5.00</prize>
<participant>
<id>stefano</id>
</participant>
</product>
<product>
<name>coniglio</name>
<amount>1</amount>
<prize>4.5</prize>
<participant>
<id>stefano</id>
</participant>
</product>
<date>2020-03-03</date>
</bill>
</student>
</group>我尝试使用Muenchian分组，但没有得到两个表(每个日期/账单一个)，而是只得到一个包含第一个账单日期的表(从XML文档的顶部到下方)和两行，每个账单的第一个产品各占一行，如下图所示。
XSLT文档如下：
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="tableByBillDate" match="bill" use="date" />
<xsl:template match="/">
<html>
<head>
<title>HTML Document</title>
</head>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
caption {
display: table-caption;
text-align: center;
}
</style>
<body>
<h3>Welcome<xsl:value-of select="group/student/name"/></h3>
<h3>Group: <xsl:value-of select="group/name"/> </h3>
<h3>Bills</h3>
<xsl:for-each select="group/student/bill[generate-id() = generate
id(key('tableByBillDate',date)[1])]">
<table>
<caption style="font-weight: bold;">Date: <xsl:value-of select="date"/></caption>
<tr>
<th>Name</th>
<th>Amount</th>
<th>Cost</th>
<th>Total</th>
<th>Participants</th>
</tr>
<xsl:for-each select="key('tableByBillDate',date)">
<xsl:sort select="date" order="descending"/>
<tr>
<td><xsl:value-of select="product/name"/></td>
<td><xsl:value-of select="product/amount"/></td>
<td><xsl:value-of select="product/prize"/></td>
<td>Calculated with Javascript</td>
<td><xsl:value-of select="product/participant"/></td>
</tr>
</xsl:for-each>
</table>
</xsl:for-each>
</body>
</html>
</xsl:template>
</xsl:stylesheet>回答 2
Stack Overflow用户
回答已采纳
发布于 2020-03-09 17:46:40
请找到正确的以下内容：
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:strip-space elements="yes"/>
<xsl:key name="tableByBillDate" match="bill" use="date" />
<xsl:template match="/">
<html>
<head>
<title>HTML Document</title>
</head>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
caption {
display: table-caption;
text-align: center;
}
</style>
<body>
<h3 align="center">Welcome: <xsl:value-of select="group/student/name"/></h3>
<h3 align="center">Group: <xsl:value-of select="group/name"/> </h3>
<h3 align="center">Bills</h3>
<xsl:for-each select="group/student/bill[generate-id()= generate-id(key('tableByBillDate',date)[1])]">
<table>
<caption style="font-weight: bold;">Date: <xsl:value-of select="date"/></caption>
<tr>
<th>Name</th>
<th>Amount</th>
<th>Cost</th>
<th>Total</th>
<th>Participants</th>
</tr>
<xsl:for-each select="key('tableByBillDate',date)">
<xsl:sort select="date" order="descending"/>
<tr>
<td><xsl:value-of select="product/name"/></td>
<td><xsl:value-of select="product/amount"/></td>
<td><xsl:value-of select="product/prize"/></td>
<td>Calculated with Javascript</td>
<td><xsl:value-of select="product/participant"/></td>
</tr>
</xsl:for-each>
</table>
</xsl:for-each>
</body>
</html>
</xsl:template>
</xsl:stylesheet>Stack Overflow用户
发布于 2020-03-09 16:40:49
我还认为您使用的键应该为您提供两个包含示例数据的表，因为您有两个不同的日期；如果您想输出每个表中的所有产品数据，则处理“组”中的所有product：
<?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" indent="yes" version="5" doctype-system="about:legacy-doctype"/>
<xsl:key name="tableByBillDate" match="bill" use="date" />
<xsl:template match="group">
<xsl:apply-templates select="student/bill[generate-id() = generate-id(key('tableByBillDate', date)[1])]">
<xsl:sort select="date"/>
</xsl:apply-templates>
</xsl:template>
<xsl:template match="bill">
<table>
<caption style="font-weight: bold;">Date: <xsl:value-of select="date"/></caption>
<thead>
<tr>
<th>Name</th>
<th>Amount</th>
<th>Cost</th>
<th>Total</th>
<th>Participants</th>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="key('tableByBillDate',date)/product"/>
</tbody>
</table>
</xsl:template>
<xsl:template match="product">
<tr>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="amount"/></td>
<td><xsl:value-of select="prize"/></td>
<td>Calculated with Javascript</td>
<td><xsl:value-of select="participant"/></td>
</tr>
</xsl:template>
<xsl:template match="/">
<html>
<head>
<title>.NET XSLT Fiddle Example</title>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
caption {
display: table-caption;
text-align: center;
}
</style>
</head>
<body>
<xsl:apply-templates/>
</body>
</html>
</xsl:template>
</xsl:stylesheet>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/60596653
复制相关文章
相似问题
腾讯云开发者
