Question

我们有一份Xml文件,其中附有Invoices/Invoice/[asst. elements],使用我们所需要的xslt呼吁模板,将InvoiceAmounts与InvoiceNumbers相匹配。

投入xml文档:

    <Invoices>   
     <Invoice>  
      <InvoiceNumber>351510</InvoiceNumber> 
      <InvoiceAmount>137.50</InvoiceAmount> 
     </Invoice>   
     <Invoice>  
      <InvoiceNumber>351510</InvoiceNumber> 
      <InvoiceAmount>362.50</InvoiceAmount> 
     </Invoice>   
     <Invoice>  
      <InvoiceNumber>351511</InvoiceNumber> 
      <InvoiceAmount>239.50</InvoiceAmount> 
     </Invoice>  
    </Invoices>

我发现有一份特定声明,即归还整个文件的发票总金额,但需要过滤该数额,以发票为根据,因为发票文件中可能有一个以上发票,有相同的发票。

总计:

<xsl:value-of select="sum(/*[local-name()= Invoices ]/*[local-name()= Invoice ]/*[local-name()= InvoiceAmount ])" />

根据我的研究,下面的询问应当把结果过滤到一个发票号上,但不是。因此,我们在这一模板中增加了一个参数,即第1页,并安排了以下提问。是否有另一种方式来安排这种选择,只为那些印花=1美元的人 gr一 total? 在尝试了这方面的许多差异之后,仍然无法取得预期结果。是否有办法在选择中增加1美元变量以过滤结果?

<xsl:value-of select="sum(/*[local-name()= Invoices ]/*[local-name()= Invoice ][local-name()= InvoiceAmount  = $p1]/*[local-name()= InvoiceAmount ])" />

预期结果:

<Invoices>
 <Invoice>
  <InvoiceNumber>351510</InvoiceNumber>
  <InvoiceAmount>500.00</InvoiceAmount>
 </Invoice>
 <Invoice>
  <InvoiceNumber>351510</InvoiceNumber>
  <InvoiceAmount>500.00</InvoiceAmount>
 </Invoice>
 <Invoice>
  <InvoiceNumber>351511</InvoiceNumber>
  <InvoiceAmount>239.50</InvoiceAmount>
 </Invoice>
</Invoices>

Thank you for your consideration. Tom

Answer 1

这一风格:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="InvoiceAmount">
        <InvoiceAmount>
            <xsl:value-of 
               select="sum(../../Invoice[InvoiceNumber=
                   current()/parent::*/InvoiceNumber]/InvoiceAmount)"/>
       </InvoiceAmount>
    </xsl:template>
</xsl:stylesheet>

生产:

<Invoices>   
     <Invoice>  
         <InvoiceNumber>351510</InvoiceNumber> 
         <InvoiceAmount>500</InvoiceAmount> 
     </Invoice>   
     <Invoice>  
         <InvoiceNumber>351510</InvoiceNumber> 
         <InvoiceAmount>500</InvoiceAmount> 
     </Invoice>   
     <Invoice>  
         <InvoiceNumber>351511</InvoiceNumber> 
         <InvoiceAmount>239.5</InvoiceAmount> 
     </Invoice>  
</Invoices>

<>说明: 形式化资金留作一项工作。见。

Answer 2

This transformation can be factors of magnitude more efficient than if keys are not used -- especially with big XML documents:

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

 <xsl:key name="kInvAmmtByNumber" match="InvoiceAmount"
  use="../InvoiceNumber"/>

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

 <xsl:template match="InvoiceAmount/text()">
  <xsl:value-of select=
  "sum(key( kInvAmmtByNumber , ../../InvoiceNumber))"/>
 </xsl:template>
</xsl:stylesheet>

when applied on the provided XML document:

<Invoices>
    <Invoice>
        <InvoiceNumber>351510</InvoiceNumber>
        <InvoiceAmount>137.50</InvoiceAmount>
    </Invoice>
    <Invoice>
        <InvoiceNumber>351510</InvoiceNumber>
        <InvoiceAmount>362.50</InvoiceAmount>
    </Invoice>
    <Invoice>
        <InvoiceNumber>351511</InvoiceNumber>
        <InvoiceAmount>239.50</InvoiceAmount>
    </Invoice>
</Invoices>

the wanted, correct result is produced:

<Invoices>
   <Invoice>
      <InvoiceNumber>351510</InvoiceNumber>
      <InvoiceAmount>500</InvoiceAmount>
   </Invoice>
   <Invoice>
      <InvoiceNumber>351510</InvoiceNumber>
      <InvoiceAmount>500</InvoiceAmount>
   </Invoice>
   <Invoice>
      <InvoiceNumber>351511</InvoiceNumber>
      <InvoiceAmount>239.5</InvoiceAmount>
   </Invoice>
</Invoices>

友情链接