基于多分组加终止的门坎和

Question

我想使用一些xslt获得一个更好的below.Please文件，XMLXSLT1.0提供了很多对.Thanks的支持。

<!-- entry xml -->
    <Pallets>
    <Pallet>
    <PalletNumber>2</PalletNumber>
    <Product>1</Product>
    <Quantity>2</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>2</PalletNumber>
    <Product>1</Product>
    <Quantity>4</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>2</PalletNumber>
    <Product>2</Product>
    <Quantity>1</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>3</PalletNumber>
    <Product>1</Product>
    <Quantity>2</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>4</PalletNumber>
    <Product>2</Product>
    <Quantity>2</Quantity>
    </Pallet></Pallets>

我需要总结每个托盘号码和产品的数量(见下面的第一个节点)，根据.Also第一次出现在xml.Results中的第一次出现，需要在掌上数字值的右边部分使用xml.Results序列号：

<?xml version="1.0" encoding="UTF-8"?>

<!-- upgraded xml --> 
    <Pallets><Pallet>
    <PalletNumber>2_1</PalletNumber>
    <Product>1</Product>
    <Quantity>6</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>2_2</PalletNumber>
    <Product>2</Product>
    <Quantity>1</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>3_1</PalletNumber>
    <Product>1</Product>
    <Quantity>2</Quantity>
    </Pallet>
    <Pallet>
    <PalletNumber>4_1</PalletNumber>
    <Product>2</Product>
    <Quantity>2</Quantity>
    </Pallet></Pallets>

Answer 1

不能100%确定新PalletNumber的逻辑是正确的(这里是凌晨3:00 )，但是下面的XSLT1.0用给定的输入返回所需的输出.

XML输入

<Pallets>
    <Pallet>
        <PalletNumber>2</PalletNumber>
        <Product>1</Product>
        <Quantity>2</Quantity>
    </Pallet>
    <Pallet>
        <PalletNumber>2</PalletNumber>
        <Product>1</Product>
        <Quantity>4</Quantity>
    </Pallet>
    <Pallet>
        <PalletNumber>2</PalletNumber>
        <Product>2</Product>
        <Quantity>1</Quantity>
    </Pallet>
    <Pallet>
        <PalletNumber>3</PalletNumber>
        <Product>1</Product>
        <Quantity>2</Quantity>
    </Pallet>
    <Pallet>
        <PalletNumber>4</PalletNumber>
        <Product>2</Product>
        <Quantity>2</Quantity>
    </Pallet>
</Pallets>

XSLT1.0

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output indent="yes"/>
    <xsl:strip-space elements="*"/>

    <xsl:key name="kPalletProduct" match="Pallet" use="concat(PalletNumber,'-',Product)"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="Pallets">
        <xsl:copy>
            <xsl:for-each select="Pallet[generate-id()=generate-id(key('kPalletProduct',concat(PalletNumber,'-',Product))[1])]">
                <xsl:copy>
                    <PalletNumber>
                        <xsl:value-of select="concat(PalletNumber,'_',count(preceding::Pallet[PalletNumber=current()/PalletNumber and not(Product=current()/Product)][1])+1)"/>
                    </PalletNumber>
                    <Product>
                        <xsl:value-of select="Product"/>
                    </Product>
                    <Quantity>
                        <xsl:value-of select="sum(key('kPalletProduct',concat(PalletNumber,'-',Product))/Quantity)"/>
                    </Quantity>
                </xsl:copy>
            </xsl:for-each>
        </xsl:copy>
    </xsl:template>

</xsl:stylesheet>

输出

<Pallets>
   <Pallet>
      <PalletNumber>2_1</PalletNumber>
      <Product>1</Product>
      <Quantity>6</Quantity>
   </Pallet>
   <Pallet>
      <PalletNumber>2_2</PalletNumber>
      <Product>2</Product>
      <Quantity>1</Quantity>
   </Pallet>
   <Pallet>
      <PalletNumber>3_1</PalletNumber>
      <Product>1</Product>
      <Quantity>2</Quantity>
   </Pallet>
   <Pallet>
      <PalletNumber>4_1</PalletNumber>
      <Product>2</Product>
      <Quantity>2</Quantity>
   </Pallet>
</Pallets>