XSL 1.0 每个复合键的 muenchian sum to sum 数量属性字段

Question

我最近在这里发布了一个类似的要求问题，但现在我需要对带有属性的 xml 进行分组/求和。我想根据文章和状态属性对所有数量属性值求和。

输入 xml 为：

<?xml version="1.0" encoding="UTF-8"?>
<StockAdjustments xmlns="http://vsystems.com/WS/StockAdjustments">
    <StockAdjustment Article="36282" Client="AJA" Status="" Unit="ST" Quantity="-25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="QUARANTAINE" Unit="ST" Quantity="25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="" Unit="ST" Quantity="-25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="QUARANTAINE" Unit="ST" Quantity="25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="" Unit="ST" Quantity="-25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="QUARANTAINE" Unit="ST" Quantity="25" ReasonCode="OVERIG" Batch="" HostLocation="C" />
</StockAdjustments>

请求的输出为：

<?xml version="1.0" encoding="UTF-8"?>
<StockAdjustments xmlns="http://vsystems.com/WS/StockAdjustments">
    <StockAdjustment Article="36282" Client="AJA" Status="" Unit="ST" Quantity="-75" ReasonCode="OVERIG" Batch="" HostLocation="C" />
    <StockAdjustment Article="36282" Client="AJA" Status="QUARANTAINE" Unit="ST" Quantity="75" ReasonCode="OVERIG" Batch="" HostLocation="C" />
</StockAdjustments>

我创建的 xsl（尚未工作）：

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:iws="http://vsystems.com/WS/StockAdjustments"
exclude-result-prefixes="iws">
<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:strip-space elements="*"/>

<xsl:key name="k1" match="/iws:StockAdjustment" use="concat(@Article, '|', @Status)"/>

<xsl:template match="/iws:StockAdjustments">
<xsl:copy> 
22
        <xsl:for-each select="/iws:StockAdjustment[generate-id()=generate-id(key('k1', concat(@Article,'|',@Status))[1])]">
            <xsl:copy>
                <xsl:copy-of select="@Article"/>
                <QTY_EXPE>
                    <xsl:value-of select="sum(key('k1', concat(@Article,'|',@Status))/@Quantity)" />
                </QTY_EXPE>
            </xsl:copy>
        </xsl:for-each>
    </xsl:copy>
</xsl:template>
</xsl:stylesheet>

xsl 1.0 （SAP PO）

Answer 1

您误用了/符号。试试这样：

XSLT 1.0

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:iws="http://vsystems.com/WS/StockAdjustments"
exclude-result-prefixes="iws">
<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:strip-space elements="*"/>
<xsl:key name="k1" match="iws:StockAdjustment" use="concat(@Article, '|', @Status)"/>
<xsl:template match="/iws:StockAdjustments">
    <xsl:copy> 
        <xsl:for-each select="iws:StockAdjustment[generate-id()=generate-id(key('k1', concat(@Article,'|',@Status))[1])]">
            <xsl:copy>
                <xsl:copy-of select="@Article"/>
                <QTY_EXPE>
                    <xsl:value-of select="sum(key('k1', concat(@Article,'|',@Status))/@Quantity)" />
                </QTY_EXPE>
            </xsl:copy>
        </xsl:for-each>
    </xsl:copy>
</xsl:template>
</xsl:stylesheet>

---

结果不是你发布的内容，但我接受了你的尝试。无论如何，总和是正确的。

Answer 2

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
    version="1.0" xmlns:mn="http://vsystems.com/WS/StockAdjustments">
    <xsl:strip-space elements="*"/>
    <xsl:output indent="yes" />
    <xsl:template match="mn:StockAdjustments">
      <xsl:copy>
          <xsl:apply-templates/>
      </xsl:copy>
    </xsl:template>
    <xsl:template match="mn:StockAdjustment[@Status = ''][1]">
        <xsl:copy> 
            <xsl:if test="@Article">
                <xsl:attribute name="Article">
                    <xsl:value-of select="@Article"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Client">
                <xsl:attribute name="Client">
                    <xsl:value-of select="@Client"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Status">
                <xsl:attribute name="Status">
                    <xsl:value-of select="@Status"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Unit">
                <xsl:attribute name="Unit">
                    <xsl:value-of select="@Unit"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Status = ''">
                <xsl:attribute name="Quantity">
                    <xsl:value-of select="sum(//mn:StockAdjustment[@Status = '']/@Quantity)"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@ReasonCode">
                <xsl:attribute name="ReasonCode">
                    <xsl:value-of select="@ReasonCode"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Batch">
                <xsl:attribute name="Batch">
                    <xsl:value-of select="@Batch"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@HostLocation">
                <xsl:attribute name="HostLocation">
                    <xsl:value-of select="@HostLocation"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:apply-templates/>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="mn:StockAdjustment[@Status = 'QUARANTAINE'][1]">
        <xsl:copy>
            <xsl:if test="@Article">
                <xsl:attribute name="Article">
                    <xsl:value-of select="@Article"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Client">
                <xsl:attribute name="Client">
                    <xsl:value-of select="@Client"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Status">
                <xsl:attribute name="Status">
                    <xsl:value-of select="@Status"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Unit">
                <xsl:attribute name="Unit">
                    <xsl:value-of select="@Unit"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Status = 'QUARANTAINE'">
                <xsl:attribute name="Quantity">
                    <xsl:value-of select="sum(//mn:StockAdjustment[@Status = 'QUARANTAINE']/@Quantity)"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@ReasonCode">
                <xsl:attribute name="ReasonCode">
                    <xsl:value-of select="@ReasonCode"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@Batch">
                <xsl:attribute name="Batch">
                    <xsl:value-of select="@Batch"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:if test="@HostLocation">
                <xsl:attribute name="HostLocation">
                    <xsl:value-of select="@HostLocation"/>
                </xsl:attribute>
            </xsl:if>
            <xsl:apply-templates/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet> 
please check if it is suitable for you.