时间戳

首页 > 解决方案 > 使用匹配特定选择器的 XSL 对 XML 进行排序并保持 XML 相同

xml - 使用匹配特定选择器的 XSL 对 XML 进行排序并保持 XML 相同

问题描述

我正在尝试使用XSLT 1.0. 除了顺序/顺序之外，我不需要对转换后的 XML 进行任何更改。

我创建了一个精简版的 XML，如下所示：

<?xml version="1.0" encoding="UTF-8"?>
<mpcconfiguration>
   <lineitem id="0">
      <seriesdesc>series1</seriesdesc>
      <modeldesc>model1</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">3</property>
         </option>
      </category>
      <category id="Category1">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">777</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="1">
      <seriesdesc>series2</seriesdesc>
      <modeldesc>model2</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">1</property>
         </option>
      </category>
      <category id="Category2">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">999</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="2">
      <seriesdesc>series3</seriesdesc>
      <modeldesc>model3</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">2</property>
         </option>
      </category>
      <category id="Category3">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">555</property>
         </option>
      </category>
   </lineitem>
</mpcconfiguration>

以下是需要关注的重要方面：

  1. 根元素将始终是mpcconfiguration.
  2. 我需要<lineitem>在mpcconfiguration.
  3. 排序序列应该由/mpcconfiguration/lineitem/category@id=Mstr_Information/option@id=Mstr_Information/property@id=Mstr_ModelSortOrder（该伪代码用简单的英语表示：“按 who is 的值排序，<property>其父id级Mstr_ModelSortOrder是<option>带有 id的，其父级Mstr_Information是<category>带有 idMstr_Information的父级是 a <lineitem>”）
  4. 请注意<property具有 555、777 和 999 等值的元素。出于排序目的，可以忽略这些元素，因为它们的祖先与我在 #3 中描述的模式不匹配。所有这些数据仍然必须在转换后的 XML 中，但这些与排序无关。
  5. 只有一个<property id="Mstr_ModelSortOrder">XXX</property>人<lineitem>的祖先与上面#3 中描述的模式相匹配。

如果我正在尝试解决的 XSL 行为正确，则这是所需/转换后的 XML：

<?xml version="1.0" encoding="UTF-8"?>
<mpcconfiguration>
   <lineitem id="1">
      <seriesdesc>series2</seriesdesc>
      <modeldesc>model2</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">1</property>
         </option>
      </category>
      <category id="Category2">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">999</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="2">
      <seriesdesc>series3</seriesdesc>
      <modeldesc>model3</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">2</property>
         </option>
      </category>
      <category id="Category3">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">555</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="0">
      <seriesdesc>series1</seriesdesc>
      <modeldesc>model1</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">3</property>
         </option>
      </category>
      <category id="Category1">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">777</property>
         </option>
      </category>
   </lineitem>
</mpcconfiguration>

请注意，这 2 个 xml 示例是相同的，只是<lineitem>节点的顺序不同，按以下方式排序：

<property id="Mstr_ModelSortOrder">1</property>
<property id="Mstr_ModelSortOrder">2</property>
<property id="Mstr_ModelSortOrder">3</property>

这是我对 xsl 的微弱尝试，尽管它不正确：

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
   <xsl:output method="xml" encoding="utf-8" indent="no" />
   <xsl:template match="/">
      <xsl:copy-of select="*" />
   </xsl:template>
   
   <xsl:template match="mpcconfiguration">
    <xsl:copy>
        <xsl:apply-templates select="//mpcconfiguration/category/option/property">
            <xsl:sort select="@id"/>
        </xsl:apply-templates>
    </xsl:copy>
   </xsl:template>
   
</xsl:stylesheet>

我知道上面有相当多的 XML 和 XSL，但总结非常简单：按XML对所有<lineitem>节点进行排序，只要该属性在 XML 树中具有正确的祖先。Mstr_ModelSortOrder<property>

标签： xmlxsltxslt-1.0

解决方案

此 XSLT 1.0 转换执行您所描述的操作

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

   <xsl:template match="node() | @*">
      <xsl:copy>
        <xsl:apply-templates select="node() | @*" />
      </xsl:copy>
   </xsl:template>
   
   <xsl:template match="mpcconfiguration">
      <xsl:copy>
        <xsl:apply-templates select="@*" />
        <xsl:apply-templates select="lineitem">
          <xsl:sort select="category[@id='Mstr_Information']/option[@id='Mstr_Information']/property[@id='Mstr_ModelSortOrder']" data-type="number" />
        </xsl:apply-templates>
      </xsl:copy>
   </xsl:template>
 </xsl:stylesheet>

输出：

<?xml version="1.0" encoding="utf-8"?>
<mpcconfiguration>
   <lineitem id="1">
      <seriesdesc>series2</seriesdesc>
      <modeldesc>model2</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">1</property>
         </option>
      </category>
      <category id="Category2">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">999</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="2">
      <seriesdesc>series3</seriesdesc>
      <modeldesc>model3</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">2</property>
         </option>
      </category>
      <category id="Category3">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">555</property>
         </option>
      </category>
   </lineitem>
   <lineitem id="0">
      <seriesdesc>series1</seriesdesc>
      <modeldesc>model1</modeldesc>
      <labels>
         <label id="ExtPrice">Extended Price</label>
      </labels>
      <category id="Mstr_Information">
         <description>Model Information</description>
         <option id="Mstr_Information">
            <description>descr1</description>
            <unitprice>0</unitprice>
            <property id="ExtPrice">0</property>
            <property id="Mstr_ModelSortOrder">3</property>
         </option>
      </category>
      <category id="Category1">
         <description>a cool category</description>
         <option id="option123">
            <description>a cool option</description>
            <unitprice>0</unitprice>
            <property id="Mstr_ModelSortOrder">777</property>
         </option>
      </category>
   </lineitem>
</mpcconfiguration>

模板 #1 是身份模板。它匹配任何不匹配更具体模板的节点，并将其逐字复制到输出中。

Template #2 is the only template that is more specific - it only matches <mpcconfiguration>, copies it, and invokes matching templates for any attribute nodes @* (there happen to be none in your input sample) and for any <lineitem> children, sorted by their respective <property id="Mstr_ModelSortOrder">. The only matching template for those nodes is the identity template, which does its job and copies them as they are.

<xsl:strip-space elements="*" /> is for convenience, it achieves pretty output with <xsl:output indent="yes" />.

A shorter version assumes that <mpcconfiguration> is the top-level element, and copies the <lineitem> children using <xsl:for-each>:

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

   <xsl:template match="/mpcconfiguration">
      <xsl:copy>
        <xsl:for-each select="lineitem">
          <xsl:sort select="category[@id='Mstr_Information']/option[@id='Mstr_Information']/property[@id='Mstr_ModelSortOrder']" data-type="number" />
          <xsl:copy-of select="." />
        </xsl:for-each>
      </xsl:copy>
   </xsl:template>
   
</xsl:stylesheet>

推荐阅读