使用匹配特定選擇器的XSL對XML進行排序并保持XML相同-有解無憂

我正在嘗試使用 .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>

以下是需要重點關注的重要方面：

根元素將始終是mpcconfiguration.
我需要<lineitem>在mpcconfiguration.
排序順序應的值來驅動/mpcconfiguration/lineitem/category@id=Mstr_Information/option@id=Mstr_Information/property@id=Mstr_ModelSortOrder（簡單的英語該偽代碼手段：“排序的值<property>，其id是Mstr_ModelSortOrder，且父是<option>ID為Mstr_Information，其親本是<category>具有IDMstr_Information的父是<lineitem>”）
Notice the <property elements with values such as 555, 777, and 999. Those can be ignored for sort purposes because their ancestors don't match the pattern I described in #3. All that data still has to be in the transformed xml, but those have no bearing on sort.
There will be only one <property id="Mstr_ModelSortOrder">XXX</property> per <lineitem> whose ancestry matches the pattern described in #3 above.

Here is the desired/transformed XML if the XSL I'm trying to work out behaves correctly:

<?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>

Notice that the 2 xml examples are identical except that the <lineitem> nodes are in a different sequence, sorted by:

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

Here is my feeble attempt at the xsl, though it's not correct:

<?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，但總結很簡單：<lineitem>按Mstr_ModelSortOrderxml對所有節點進行排序<property>，只要該屬性在 xml 樹上具有正確的祖先。

提前感謝您的任何幫助。

uj5u.com熱心網友回復：

此 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 是身份模板。它匹配任何不匹配更具體模板的節點，并將其逐字復制到輸出。

模板 #2 是唯一更具體的模板——它只匹配<mpcconfiguration>、復制它，并為任何屬性節點@*（輸入樣本中碰巧沒有）和任何子節點呼叫匹配模板<lineitem>，按其各自的<property id="Mstr_ModelSortOrder">. 這些節點唯一匹配的模板是身份模板，它完成其作業并按原樣復制它們。

<xsl:strip-space elements="*" />為方便起見，它使用<xsl:output indent="yes" />.

較短的版本假定它<mpcconfiguration>是頂級元素，并<lineitem>使用<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>

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/316667.html

標籤：xml xslt xslt-1.0

上一篇：XSLT：動態設定xmlnsuri

下一篇：將XML資料上傳到SQLServer