作为xsl页脚的行计数

Question

我有一个xml，我将对其应用xsl转换为以管道分隔的文件。我能够得到输出，但我也需要在文件结束时记录计数。请帮助。

XSL:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:wd="urn:com.workday/bsvc"
exclude-result-prefixes="xs"
version="2.0">
<xsl:output method="text" omit-xml-declaration="yes" indent="yes"/>    

<xsl:template match="/">
<xsl:variable name="delimeter" select="'|'"/>
<xsl:variable name="lineFeed" select="'&#xa;'"/>

<xsl:text>Headers</xsl:text>
<xsl:value-of select="$lineFeed"/>

<!--<xsl:for-each select="wd:Report_Data/wd:Report_Entry">-->
<xsl:for-each-group select="wd:Report_Data/wd:Report_Entry" group-by="wd:Worker_group/wd:Employee_ID"> 

<!-- HDRCOM - Print Company Details -->
<text>HDRCOM</text>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Worker_group/wd:Company_Name"/>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Worker_group/wd:Company_Address"/>
<xsl:value-of select="$lineFeed"/>            

<!-- HDRBIO (Employee Information) -->
<text>HDRBIO</text>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Worker_group/wd:Full_Legal_Name"/>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Worker_group/wd:Employee_ID"/>
<xsl:value-of select="$delimeter"/>                

<!-- TAXES (Repeat the seqment for each type of Tax) -->
<xsl:for-each select="current-group()">
<xsl:choose>
<xsl:when test="wd:Pay_Component_Category = 'Employee Paid Taxes'">
<text>TAXES</text>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Pay_Component"/>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:Amount"/>
<xsl:value-of select="$delimeter"/>

<xsl:value-of select="wd:YTD_Amount"/>
<xsl:value-of select="$lineFeed"/>
</xsl:when>
</xsl:choose>
</xsl:for-each>            

<!--</xsl:for-each>-->
</xsl:for-each-group>                       
</xsl:template>
</xsl:stylesheet>

输出如下:

HDRCOM ABC | | XYZ

HDRBIO安德鲁| | 12345年

赋税|Fed预扣缴A| 0.00| 0.00

赋税|Fed预扣缴B| 1.95| 4.40

税金|Fed预扣缴C| 8.37| 18.83

HDRCOM ABC | | XYZ

约翰HDRBIO | | 16543年

赋税|Fed预扣缴A| 1.00| 1.00

赋税|Fed预扣缴B| 2.65| 4.40

TLR| 09 ----->我需要这个。打印的总行数。

输入:

<?xml version='1.0' encoding='UTF-8'?>
<wd:Report_Data xmlns:wd="urn:com.workday/bsvc">
<wd:Report_Entry>
<wd:Worker_group>
<wd:Company_Name>ABC</wd:Company_Name>
<wd:Company_Address>XYZ</wd:Company_Address>
<wd:Full_Legal_Name>Andrew</wd:Full_Legal_Name>
<wd:Employee_ID>12345</wd:Employee_ID>
</wd:Worker_group>
<wd:Pay_Component>Fed Withholdng A</wd:Pay_Component>
<wd:Amount>0</wd:Amount>
<wd:YTD_Amount>0</wd:YTD_Amount>
<wd:Pay_Component_Category>Employee Paid Taxes</wd:Pay_Component_Category>
</wd:Report_Entry>
<wd:Report_Entry>
<wd:Worker_group>
<wd:Company_Name>ABC</wd:Company_Name>
<wd:Company_Address>XYZ</wd:Company_Address>
<wd:Full_Legal_Name>Andrew</wd:Full_Legal_Name>
<wd:Employee_ID>12345</wd:Employee_ID>
</wd:Worker_group>
<wd:Pay_Component>Fed Withholdng B</wd:Pay_Component>
<wd:Amount>1.95</wd:Amount>
<wd:YTD_Amount>4.40</wd:YTD_Amount>
<wd:Pay_Component_Category>Employee Paid Taxes</wd:Pay_Component_Category>
</wd:Report_Entry>
<wd:Report_Entry>
<wd:Worker_group>
<wd:Company_Name>ABC</wd:Company_Name>
<wd:Company_Address>XYZ</wd:Company_Address>
<wd:Full_Legal_Name>Andrew</wd:Full_Legal_Name>
<wd:Employee_ID>12345</wd:Employee_ID>
</wd:Worker_group>
<wd:Pay_Component>Fed Withholdng C</wd:Pay_Component>
<wd:Amount>8.37</wd:Amount>
<wd:YTD_Amount>18.83</wd:YTD_Amount>
<wd:Pay_Component_Category>Employee Paid Taxes</wd:Pay_Component_Category>
</wd:Report_Entry>
<wd:Report_Entry>
<wd:Worker_group>
<wd:Company_Name>ABC</wd:Company_Name>
<wd:Company_Address>XYZ</wd:Company_Address>
<wd:Full_Legal_Name>John</wd:Full_Legal_Name>
<wd:Employee_ID>16543</wd:Employee_ID>
</wd:Worker_group>
<wd:Pay_Component>Fed Withholdng A</wd:Pay_Component>
<wd:Amount>1</wd:Amount>
<wd:YTD_Amount>1</wd:YTD_Amount>
<wd:Pay_Component_Category>Employee Paid Taxes</wd:Pay_Component_Category>
</wd:Report_Entry>
<wd:Report_Entry>
<wd:Worker_group>
<wd:Company_Name>ABC</wd:Company_Name>
<wd:Company_Address>XYZ</wd:Company_Address>
<wd:Full_Legal_Name>John</wd:Full_Legal_Name>
<wd:Employee_ID>16543</wd:Employee_ID>
</wd:Worker_group>
<wd:Pay_Component>Fed Withholdng B</wd:Pay_Component>
<wd:Amount>2.65</wd:Amount>
<wd:YTD_Amount>4.40</wd:YTD_Amount>
<wd:Pay_Component_Category>Employee Paid Taxes</wd:Pay_Component_Category>
</wd:Report_Entry>
</wd:Report_Data>

Answer 1

一种简单的方法是捕获作为字符串变量生成的文本记录，然后计算它包含的换行字符的出现次数。

<xsl:variable name="record">
<!-- insert your record-generation code here -->
</xsl:variable>
<!-- output the body of the record -->
<xsl:sequence select="$record"/>
<!-- compute the line count -->
<xsl:variable name="lines" select="count(tokenize($record, 'n')) + 1"/>
<!-- finally output the $lines information -->

如果需要的话，可以使用format-number()函数用前导零来格式化行数。https://www.w3.org/TR/xslt20/function-format-number

Answer 2

我建议你这样试试:

XSLT 2.0

<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xpath-default-namespace="urn:com.workday/bsvc">
<xsl:output method="text"/>    

<xsl:template match="/Report_Data">
<xsl:variable name="items" select="Report_Entry[Pay_Component_Category = 'Employee Paid Taxes']" />
<xsl:for-each-group select="$items" group-by="Worker_group/Employee_ID"> 
<!-- HDRCOM - Print Company Details -->
<xsl:value-of select="'HDRCOM', Worker_group/Company_Name, Worker_group/Company_Address" separator="|"/>
<xsl:text>&#10;</xsl:text>
<!-- HDRBIO (Employee Information) -->
<xsl:value-of select="'HDRBIO', Worker_group/Full_Legal_Name, Worker_group/Employee_ID" separator="|"/>
<xsl:text>&#10;</xsl:text>
<!-- TAXES (Repeat the seqment for each type of Tax) -->        
<xsl:for-each select="current-group()">
<xsl:value-of select="'TAXES', Pay_Component, Amount, YTD_Amount" separator="|"/>
<xsl:text>&#10;</xsl:text>
</xsl:for-each>            
</xsl:for-each-group> 
<!-- count lines -->
<xsl:value-of select="'TLR', count($items) + 2*count(distinct-values($items/Worker_group/Employee_ID))" separator="|"/>                    
</xsl:template>
</xsl:stylesheet>

注意我的逻辑和你的有区别:我的方法不会为一个空的组创建头文件。