xslt，具有特定值的逐节点(每行名称相同的多个节点)(关键问题)

Question

我有一个如下所示的xml。

<?xml version="1.0" encoding="UTF-8"?>
<Invoice xsi:schemaLocation="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2 http://docs.oasis-open.org/ubl/os-UBL-2.1/xsd/maindoc/UBL-Invoice-2.1.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2">
    <cac:InvoiceLine>
        <cbc:ID></cbc:ID>
        <cbc:LineExtensionAmount currencyID="EUR">93.46</cbc:LineExtensionAmount>
        <cac:Item>
            <cac:AdditionalItemProperty>
                <cbc:Name>Total Hours</cbc:Name>
                <cbc:Value>43</cbc:Value>
            </cac:AdditionalItemProperty>
            <cac:AdditionalItemProperty>
                <cbc:Name>naamKandidaat</cbc:Name>
                <cbc:Value>Kees Netelvrees</cbc:Value>
            </cac:AdditionalItemProperty>
        </cac:Item>
    </cac:InvoiceLine>
    <cac:InvoiceLine>
        <cbc:ID></cbc:ID>
        <cbc:LineExtensionAmount currencyID="EUR">2.77</cbc:LineExtensionAmount>
        <cac:Item>
            <cac:AdditionalItemProperty>
                <cbc:Name>Total Hours</cbc:Name>
                <cbc:Value>43</cbc:Value>
            </cac:AdditionalItemProperty>
             <cac:AdditionalItemProperty>
                **<cbc:Name>naamKandidaat</cbc:Name>**
                <cbc:Value>Jaap Aap</cbc:Value>
            </cac:AdditionalItemProperty>
        </cac:Item>
    </cac:InvoiceLine>
    <cac:InvoiceLine>
        <cbc:ID></cbc:ID>
        <cbc:LineExtensionAmount currencyID="EUR">100.00</cbc:LineExtensionAmount>
        <cac:Item>
            <cac:AdditionalItemProperty>
                <cbc:Name>Total Hours</cbc:Name>
                <cbc:Value>43</cbc:Value>
            </cac:AdditionalItemProperty>
             <cac:AdditionalItemProperty>
                **<cbc:Name>naamKandidaat</cbc:Name>**
                <cbc:Value>Jaap Aap</cbc:Value>
            </cac:AdditionalItemProperty>
        </cac:Item>
    </cac:InvoiceLine>
</Invoice>

我需要把cac:InvoiceLine/cac:Item/cac:AdditionalItemProperty/cbc:Value组织成InvoiceLine/cac:Item/cac:AdditionalItemProperty/cbc:Name**=naamKandidaat**.其目的是在cac:InvoiceLine中求和节点，其中cbc:Name是相同的。问题是我不知道如何创建密钥

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:ccts="urn:un:unece:uncefact:documentation:2" xmlns:qdt="urn:oasis:names:specification:ubl:schema:xsd:QualifiedDatatypes-2" xmlns:udt="urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2" xmlns:default="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2" exclude-result-prefixes="cac cbc ccts qdt udt default">
    <xsl:output method="xml" encoding="utf-8" indent="yes"/>
    
    <xsl:key name="PerAdditionalItemProperty" match="cac:InvoiceLine" use="cac:Item/cac:AdditionalItemProperty/cbc:Value"/>

    <xsl:template match="/">
        <PurchaseInvoices_version_1.0>
            <xsl:for-each select="default:Invoice">
                <PurchaseInvoice>
                    <xsl:for-each select="cac:InvoiceLine[generate-id(.)=generate-id(key('PerAdditionalItemProperty',cac:Item/cac:AdditionalItemProperty/cbc:Value)[1])]">
                        <xsl:for-each select="key('PerAdditionalItemProperty',cac:Item/cac:AdditionalItemProperty/cbc:Value)">
                            <xsl:if test="position()=1">
                                <Line>
                                    <Item><xsl:value-of select="cac:Item/cac:AdditionalItemProperty/cbc:Value"/></Item>
                                    <LineAmount><xsl:value-of select="format-number(sum(key('PerAdditionalItemProperty',cac:Item/cac:AdditionalItemProperty/cbc:Value)/cbc:LineExtensionAmount[number(.) = number(.)]),'#.##')"/></LineAmount>
                                </Line>
                            </xsl:if>
                        </xsl:for-each>
                    </xsl:for-each>
                </PurchaseInvoice>
            </xsl:for-each>
        </PurchaseInvoices_version_1.0>
    </xsl:template>
</xsl:stylesheet> 

我期望的输出是：

<?xml version="1.0" encoding="utf-8"?>
<PurchaseInvoices_version_1.0>
   <PurchaseInvoice>
      <Line>
         <Item>Kees Netelvrees</Item>
         <LineAmount>93.46</LineAmount>
      </Line>
      <Line>
         <Item>Jaap Aap</Item>
         <LineAmount>102.77</LineAmount>
      </Line>
   </PurchaseInvoice>
</PurchaseInvoices_version_1.0

Answer 1

只需将条件放入键表达式：

<xsl:stylesheet
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"
    xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"
    version="1.0">
  
  <xsl:output indent="yes"/>
  
  <xsl:key name="group" match="cac:InvoiceLine" use="cac:Item/cac:AdditionalItemProperty[cbc:Name = 'naamKandidaat']/cbc:Value"/>


  <xsl:template match="cac:InvoiceLine[generate-id() = generate-id(key('group', cac:Item/cac:AdditionalItemProperty[cbc:Name = 'naamKandidaat']/cbc:Value)[1])]">
    <Line>
      <Item>
        <xsl:value-of select="cac:Item/cac:AdditionalItemProperty[cbc:Name = 'naamKandidaat']/cbc:Value"/>
      </Item>
      <LineAmount>
        <xsl:value-of select="sum(key('group', cac:Item/cac:AdditionalItemProperty[cbc:Name = 'naamKandidaat']/cbc:Value)/cbc:LineExtensionAmount)"/>
      </LineAmount>
    </Line>
  </xsl:template>
  
  <xsl:template match="cac:InvoiceLine[not(generate-id() = generate-id(key('group', cac:Item/cac:AdditionalItemProperty[cbc:Name = 'naamKandidaat']/cbc:Value)[1]))]"/>

  
  <xsl:template match="/">
    <PurchaseInvoices_version_1.0>
      <PurchaseInvoice>
        <xsl:apply-templates/>
      </PurchaseInvoice>
    </PurchaseInvoices_version_1.0>
  </xsl:template>

</xsl:stylesheet>