XSLT:XML列表,级别为XML,具有递归节点



我的输入是一个公司的XML组织结构,包含多个部门和子部门。标签level中给出了组织结构中子部门的级别。

输出还应该是具有多个部门的XML。但是现在子部门应该在递归节点中。部门列表和子部门列表都由一个或多个部门(或零个)组成,部门在"详细信息"下有子部门列表。

我使用的工具只知道XSLT1.0,所以我希望在这个版本中可以解决。

输入示例(仅1个部门):

<?xml version="1.0" encoding="UTF-8"?>
<Z_HR_HRM_SYNC_DEPARTMENTS>
    <IT_ORG>
        <item>
            <ORGEH>50013998</ORGEH>
            <ORGEH_PARENT>50000025</ORGEH_PARENT>
            <TITLE>Title 50013998</TITLE>
            <SUB_DEP>
                <item>
                    <LEVEL>1</LEVEL>
                    <ORGEH>50014000</ORGEH>
                    <ORGEH_PARENT>50013998</ORGEH_PARENT>
                    <TITLE>Title 50014000</TITLE>
                </item>
                <item>
                    <LEVEL>1</LEVEL>
                    <ORGEH>50000849</ORGEH>
                    <ORGEH_PARENT>50013998</ORGEH_PARENT>
                    <TITLE>Title 50000849</TITLE>
                </item>
                <item>
                    <LEVEL>2</LEVEL>
                    <ORGEH>50017825</ORGEH>
                    <ORGEH_PARENT>50000849</ORGEH_PARENT>
                    <TITLE>Title 50017825</TITLE>
                </item>
                <item>
                    <LEVEL>2</LEVEL>
                    <ORGEH>50001684</ORGEH>
                    <ORGEH_PARENT>50000849</ORGEH_PARENT>
                    <TITLE>Title 50001684</TITLE>
                </item>
                <item>
                    <LEVEL>2</LEVEL>
                    <ORGEH>50012716</ORGEH>
                    <ORGEH_PARENT>50000849</ORGEH_PARENT>
                    <TITLE>Title 50012716</TITLE>
                </item>
                <item>
                    <LEVEL>3</LEVEL>
                    <ORGEH>50001709</ORGEH>
                    <ORGEH_PARENT>50012716</ORGEH_PARENT>
                    <TITLE>Title 50001709</TITLE>
                </item>
                <item>
                    <LEVEL>2</LEVEL>
                    <ORGEH>50012713</ORGEH>
                    <ORGEH_PARENT>50000849</ORGEH_PARENT>
                    <TITLE>Title 50012713</TITLE>
                </item>
                <item>
                    <LEVEL>2</LEVEL>
                    <ORGEH>50001694</ORGEH>
                    <ORGEH_PARENT>50000849</ORGEH_PARENT>
                    <TITLE>Title 50001694</TITLE>
                </item>
                <item>
                    <LEVEL>3</LEVEL>
                    <ORGEH>50010284</ORGEH>
                    <ORGEH_PARENT>50001694</ORGEH_PARENT>
                    <TITLE>Title 50010284</TITLE>
                </item>
                <item>
                    <LEVEL>3</LEVEL>
                    <ORGEH>50001695</ORGEH>
                    <ORGEH_PARENT>50001694</ORGEH_PARENT>
                    <TITLE>Title 50001695</TITLE>
                </item>
                <item>
                    <LEVEL>4</LEVEL>
                    <ORGEH>50001697</ORGEH>
                    <ORGEH_PARENT>50001695</ORGEH_PARENT>
                    <TITLE>Title 50001697</TITLE>
                </item>
            </SUB_DEP>
        </item>
    </IT_ORG>
</Z_HR_HRM_SYNC_DEPARTMENTS>

相应的手工输出:

<?xml version="1.0" encoding="UTF-8"?>
<ns1:BatchSyncDepartments xmlns:ns1="http://schemas.hr-manager.net/remoting/1.0/">
<ns1:request>
    <ns1:DepartmentList>
        <ns1:Department>
            <ns1:Id>
                <ns1:ThirdPartyId>50013998</ns1:ThirdPartyId>
            </ns1:Id>
            <ns1:ParentDepartmentId>
                <ns1:ThirdPartyId>50000025</ns1:ThirdPartyId>
            </ns1:ParentDepartmentId>
            <ns1:Title>Title 50013998</ns1:Title>
            <ns1:Details>
                <ns1:SubDepartmentList>
                    <ns1:Department>
                        <ns1:Id>
                            <ns1:ThirdPartyId>50014000</ns1:ThirdPartyId>
                        </ns1:Id>
                        <ns1:ParentDepartmentId>
                            <ns1:ThirdPartyId>50013998</ns1:ThirdPartyId>
                        </ns1:ParentDepartmentId>
                        <ns1:Title>Title 50014000</ns1:Title>
                        <ns1:Details>
                            <ns1:SubDepartmentList/>
                        </ns1:Details>
                    </ns1:Department>
                    <ns1:Department>
                        <ns1:Id>
                            <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                        </ns1:Id>
                        <ns1:ParentDepartmentId>
                            <ns1:ThirdPartyId>50013998</ns1:ThirdPartyId>
                        </ns1:ParentDepartmentId>
                        <ns1:Title>Title 50000849</ns1:Title>
                        <ns1:Details>
                            <ns1:SubDepartmentList>
                                <ns1:Department>
                                    <ns1:Id>
                                        <ns1:ThirdPartyId>50017825</ns1:ThirdPartyId>
                                    </ns1:Id>
                                    <ns1:ParentDepartmentId>
                                        <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                                    </ns1:ParentDepartmentId>
                                    <ns1:Title>Title 50017825</ns1:Title>
                                    <ns1:Details>
                                        <ns1:SubDepartmentList/>
                                    </ns1:Details>
                                </ns1:Department>
                                <ns1:Department>
                                    <ns1:Id>
                                        <ns1:ThirdPartyId>50001684</ns1:ThirdPartyId>
                                    </ns1:Id>
                                    <ns1:ParentDepartmentId>
                                        <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                                    </ns1:ParentDepartmentId>
                                    <ns1:Title>Title 50001684</ns1:Title>
                                    <ns1:Details>
                                        <ns1:SubDepartmentList/>
                                    </ns1:Details>
                                </ns1:Department>
                                <ns1:Department>
                                    <ns1:Id>
                                        <ns1:ThirdPartyId>50012716</ns1:ThirdPartyId>
                                    </ns1:Id>
                                    <ns1:ParentDepartmentId>
                                        <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                                    </ns1:ParentDepartmentId>
                                    <ns1:Title>Title 50012716</ns1:Title>
                                    <ns1:Details>
                                        <ns1:SubDepartmentList>
                                            <ns1:Department>
                                                <ns1:Id>
                                                    <ns1:ThirdPartyId>50001709</ns1:ThirdPartyId>
                                                </ns1:Id>
                                                <ns1:ParentDepartmentId>
                                                    <ns1:ThirdPartyId>50012716</ns1:ThirdPartyId>
                                                </ns1:ParentDepartmentId>
                                                <ns1:Title>Title 50001709</ns1:Title>
                                                <ns1:Details>
                                                    <ns1:SubDepartmentList/>
                                                </ns1:Details>
                                            </ns1:Department>
                                        </ns1:SubDepartmentList>
                                    </ns1:Details>
                                </ns1:Department>
                                <ns1:Department>
                                    <ns1:Id>
                                        <ns1:ThirdPartyId>50012713</ns1:ThirdPartyId>
                                    </ns1:Id>
                                    <ns1:ParentDepartmentId>
                                        <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                                    </ns1:ParentDepartmentId>
                                    <ns1:Title>Title 50012713</ns1:Title>
                                    <ns1:Details>
                                        <ns1:SubDepartmentList/>
                                    </ns1:Details>
                                </ns1:Department>
                                <ns1:Department>
                                    <ns1:Id>
                                        <ns1:ThirdPartyId>50001694</ns1:ThirdPartyId>
                                    </ns1:Id>
                                    <ns1:ParentDepartmentId>
                                        <ns1:ThirdPartyId>50000849</ns1:ThirdPartyId>
                                    </ns1:ParentDepartmentId>
                                    <ns1:Title>Title 50001694</ns1:Title>
                                    <ns1:Details>
                                        <ns1:SubDepartmentList>
                                            <ns1:Department>
                                                <ns1:Id>
                                                    <ns1:ThirdPartyId>50010284</ns1:ThirdPartyId>
                                                </ns1:Id>
                                                <ns1:ParentDepartmentId>
                                                    <ns1:ThirdPartyId>50001694</ns1:ThirdPartyId>
                                                </ns1:ParentDepartmentId>
                                                <ns1:Title>Title 50010284</ns1:Title>
                                                <ns1:Details>
                                                    <ns1:SubDepartmentList/>
                                                </ns1:Details>
                                            </ns1:Department>
                                            <ns1:Department>
                                                <ns1:Id>
                                                    <ns1:ThirdPartyId>50001695</ns1:ThirdPartyId>
                                                </ns1:Id>
                                                <ns1:ParentDepartmentId>
                                                    <ns1:ThirdPartyId>50001694</ns1:ThirdPartyId>
                                                </ns1:ParentDepartmentId>
                                                <ns1:Title>Title 50001695</ns1:Title>
                                                <ns1:Details>
                                                    <ns1:SubDepartmentList>
                                                        <ns1:Department>
                                                            <ns1:Id>
                                                                <ns1:ThirdPartyId>50001697</ns1:ThirdPartyId>
                                                            </ns1:Id>
                                                            <ns1:ParentDepartmentId>
                                                                <ns1:ThirdPartyId>50001695</ns1:ThirdPartyId>
                                                            </ns1:ParentDepartmentId>
                                                            <ns1:Title>Title 50001697</ns1:Title>
                                                            <ns1:Details>
                                                                <ns1:SubDepartmentList/>
                                                            </ns1:Details>
                                                        </ns1:Department>
                                                    </ns1:SubDepartmentList>
                                                </ns1:Details>
                                            </ns1:Department>
                                        </ns1:SubDepartmentList>
                                    </ns1:Details>
                                </ns1:Department>
                            </ns1:SubDepartmentList>
                        </ns1:Details>
                    </ns1:Department>
                </ns1:SubDepartmentList>
            </ns1:Details>
        </ns1:Department>
    </ns1:DepartmentList>
</ns1:request>
</ns1:BatchSyncDepartments>

我放弃了XSLT的新手,只解决了简单的问题,但现在我陷入了困境:

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

<xsl:template match="Z_HR_HRM_SYNC_DEPARTMENTS">
    <ns1:BatchSyncDepartments xmlns:ns1="http://schemas.hr-manager.net/remoting/1.0/">
        <ns1:request>
            <ns1:DepartmentList>
                <xsl:for-each select="IT_ORG/item">
                    <ns1:Department>
                        <ns1:Id>
                            <ns1:ThirdPartyId>
                                <xsl:value-of select="ORGEH"/>
                            </ns1:ThirdPartyId>
                        </ns1:Id>
                        <ns1:ParentDepartmentId>
                            <ns1:ThirdPartyId>
                                <xsl:value-of select="ORGEH_PARENT"/>
                            </ns1:ThirdPartyId>
                        </ns1:ParentDepartmentId>
                        <ns1:Title>
                            <xsl:value-of select="TITLE"/>
                        </ns1:Title>
                        <ns1:Details>
                            <ns1:SubDepartmentList>
                            </ns1:SubDepartmentList>
                        </ns1:Details>
                    </ns1:Department>
                </xsl:for-each>
            </ns1:DepartmentList>
        </ns1:request>
    </ns1:BatchSyncDepartments>
</xsl:template>
</xsl:stylesheet>

我希望有人能为如何进行提供一些意见。

但是现在子部门应该在递归节点中。

为此,您应该采用递归处理方法:

XSLT 1.0

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:ns1="http://schemas.hr-manager.net/remoting/1.0/">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>
<xsl:key name="child" match="item" use="ORGEH_PARENT" />
<xsl:template match="Z_HR_HRM_SYNC_DEPARTMENTS">
    <ns1:BatchSyncDepartments xmlns:ns1="http://schemas.hr-manager.net/remoting/1.0/">
        <ns1:request>
            <ns1:DepartmentList>
                <xsl:apply-templates select="IT_ORG/item"/>
            </ns1:DepartmentList>
        </ns1:request>
    </ns1:BatchSyncDepartments>  
</xsl:template>             
 <xsl:template match="item">
    <ns1:Department>
        <ns1:Id>
            <ns1:ThirdPartyId>
                <xsl:value-of select="ORGEH"/>
            </ns1:ThirdPartyId>
        </ns1:Id>
        <ns1:ParentDepartmentId>
            <ns1:ThirdPartyId>
                <xsl:value-of select="ORGEH_PARENT"/>
            </ns1:ThirdPartyId>
        </ns1:ParentDepartmentId>
        <ns1:Title>
            <xsl:value-of select="TITLE"/>
        </ns1:Title>
        <ns1:Details>
            <ns1:SubDepartmentList>
                <xsl:apply-templates select="key('child', ORGEH)"/>
            </ns1:SubDepartmentList>
        </ns1:Details>
    </ns1:Department>
</xsl:template>
</xsl:stylesheet>

相关内容

  • 没有找到相关文章

最新更新