xslt - 如何使用 Apache Camel 在 XSLT 中为每个组申请
问题描述
我正在尝试在 Apache Camel XSLT 中使用 group by，但是当使用带有 sytlesheet 版本 2.0 的 for-each-group 时出现异常“javax.xml.transform.TransformerException：xsl:for-each 上不允许使用“select”属性-组元素！”。下面是我更新的代码。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" />
<xsl:template match="/">
<MESSAGES>
<xsl:for-each-group
select="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent"
group-by="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId">
<COMMANDSTATUS>
<xsl:attribute name="ID">SHIPPED</xsl:attribute>
<xsl:attribute name="DESCRIPTION">Goods Shipped</xsl:attribute>
<ORDER>
<xsl:attribute name="O_ID"><xsl:value-of
select='distinct-values(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId)' /></xsl:attribute>
<xsl:choose>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource = 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">https://www.fedex.com/apps/fedextrack/?tracknumbers=<xsl:value-of
select='distinct-values(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber)' /></xsl:attribute>
</xsl:when>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource != 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">http://wwwapps.<xsl:value-of
select='distinct-values(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingCarrier)' />.com/WebTracking/track?track=yes&trackNums=<xsl:value-of
select='distinct-values(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber)' /></xsl:attribute>
</xsl:when>
</xsl:choose>
<xsl:for-each
select="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent">
<ORDER_LINE>
<xsl:attribute name="OL_ID"><xsl:value-of
select='OrderLineId' /></xsl:attribute>
<xsl:choose>
<xsl:when test="substring(ItemId, 0, 6) = '88-00'">
<xsl:attribute name="SKU"><xsl:value-of
select='substring(ItemId, 6)' /></xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="SKU"><xsl:value-of
select='ItemId' /></xsl:attribute>
</xsl:otherwise>
</xsl:choose>
<xsl:attribute name="QUANTITY"><xsl:value-of
select='distinct-values(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderStatusDetails/OrderStatusDetail/Qty)' /></xsl:attribute>
</ORDER_LINE>
</xsl:for-each>
</ORDER>
</COMMANDSTATUS>
</xsl:for-each-group>
</MESSAGES>
</xsl:template>
</xsl:stylesheet>
输入 XML：
<?xml version="1.0" encoding="utf-8"?>
<OrderStatusUpdate fileType="Order Status Update" fileStartTime="2021-10-13 06:20:18 " fileEndTime=" 2021-10-13 07:35:26">
<MessageHeader>
<Standard>eBay_Enterprise</Standard>
<HeaderVersion>EWS_eb2c_1.1</HeaderVersion>
<VersionReleaseNumber>EWS_eb2c_1.1</VersionReleaseNumber>
<SourceData>
<SourceId>OMS</SourceId>
<SourceType>OrderManagementSystem</SourceType>
</SourceData>
<DestinationData>
<DestinationId>EE_OrderRTStatusXML</DestinationId>
<DestinationType>MAILBOX</DestinationType>
</DestinationData>
<EventType>OrderStatus</EventType>
<MessageData>
<MessageId>20211013073625</MessageId>
<CorrelationId>0</CorrelationId>
</MessageData>
<CreateDateAndTime>2021-10-13 07:36:25</CreateDateAndTime>
</MessageHeader>
<OrderStatusEvents>
<OrderStatusEvent>
<StoreCode>R21_US</StoreCode>
<OrderId>101425120920</OrderId>
<ExternalOrderId/>
<WebOrderId>002010003694706_1</WebOrderId>
<OrderSource type=""/>
<OrderLineId>1</OrderLineId>
<OriginalOrderId/>
<OriginalWebOrderId/>
<OriginalOrderLineId/>
<ItemId>88-0028547859</ItemId>
<OrderStatusDetails>
<OrderStatusDetail>
<OrderStatusEventTimeStamp>2021-10-13 07:20:23</OrderStatusEventTimeStamp>
<StatusName>Fulfilled and Invoiced</StatusName>
<ReturnReason/>
<Qty>1</Qty>
<CancelReason/>
<CancelReasonText/>
</OrderStatusDetail>
</OrderStatusDetails>
<OrderShipmentDetails>
<OrderShipmentDetail>
<ShippingCarrier>UPS</ShippingCarrier>
<ShippingServiceLevel>PBX01</ShippingServiceLevel>
<ShippingTrackingNumber>1ZEW3567YW46706215</ShippingTrackingNumber>
<ShippingTimestamp>2021-10-13 07:12:00</ShippingTimestamp>
</OrderShipmentDetail>
</OrderShipmentDetails>
</OrderStatusEvent>
<OrderStatusEvent>
<StoreCode>R21_US</StoreCode>
<OrderId>101425120920</OrderId>
<ExternalOrderId/>
<WebOrderId>002010003694706_1</WebOrderId>
<OrderSource type=""/>
<OrderLineId>3</OrderLineId>
<OriginalOrderId/>
<OriginalWebOrderId/>
<OriginalOrderLineId/>
<ItemId>88-0028461473</ItemId>
<OrderStatusDetails>
<OrderStatusDetail>
<OrderStatusEventTimeStamp>2021-10-13 07:20:23</OrderStatusEventTimeStamp>
<StatusName>Fulfilled and Invoiced</StatusName>
<ReturnReason/>
<Qty>1</Qty>
<CancelReason/>
<CancelReasonText/>
</OrderStatusDetail>
</OrderStatusDetails>
<OrderShipmentDetails>
<OrderShipmentDetail>
<ShippingCarrier>UPS</ShippingCarrier>
<ShippingServiceLevel>PBX01</ShippingServiceLevel>
<ShippingTrackingNumber>1ZEW3567YW46706215</ShippingTrackingNumber>
<ShippingTimestamp>2021-10-13 07:12:00</ShippingTimestamp>
</OrderShipmentDetail>
</OrderShipmentDetails>
</OrderStatusEvent>
<OrderStatusEvent>
<StoreCode>R21_US</StoreCode>
<OrderId>101425254810</OrderId>
<ExternalOrderId/>
<WebOrderId>002010003698153_1</WebOrderId>
<OrderSource type=""/>
<OrderLineId>1</OrderLineId>
<OriginalOrderId/>
<OriginalWebOrderId/>
<OriginalOrderLineId/>
<ItemId>88-0028353647</ItemId>
<OrderStatusDetails>
<OrderStatusDetail>
<OrderStatusEventTimeStamp>2021-10-13 06:40:15</OrderStatusEventTimeStamp>
<StatusName>Fulfilled and Invoiced</StatusName>
<ReturnReason/>
<Qty>1</Qty>
<CancelReason/>
<CancelReasonText/>
</OrderStatusDetail>
</OrderStatusDetails>
<OrderShipmentDetails>
<OrderShipmentDetail>
<ShippingCarrier>UPS</ShippingCarrier>
<ShippingServiceLevel>PBX03</ShippingServiceLevel>
<ShippingTrackingNumber>1ZEW3571YW13958113</ShippingTrackingNumber>
<ShippingTimestamp>2021-10-13 06:30:00</ShippingTimestamp>
</OrderShipmentDetail>
</OrderShipmentDetails>
</OrderStatusEvent>
<OrderStatusEvent>
<StoreCode>R21_US</StoreCode>
<OrderId>101425254810</OrderId>
<ExternalOrderId/>
<WebOrderId>002010003698153_1</WebOrderId>
<OrderSource type=""/>
<OrderLineId>2</OrderLineId>
<OriginalOrderId/>
<OriginalWebOrderId/>
<OriginalOrderLineId/>
<ItemId>88-0028635431</ItemId>
<OrderStatusDetails>
<OrderStatusDetail>
<OrderStatusEventTimeStamp>2021-10-13 06:40:15</OrderStatusEventTimeStamp>
<StatusName>Fulfilled and Invoiced</StatusName>
<ReturnReason/>
<Qty>1</Qty>
<CancelReason/>
<CancelReasonText/>
</OrderStatusDetail>
</OrderStatusDetails>
<OrderShipmentDetails>
<OrderShipmentDetail>
<ShippingCarrier>UPS</ShippingCarrier>
<ShippingServiceLevel>PBX03</ShippingServiceLevel>
<ShippingTrackingNumber>1ZEW3571YW13958113</ShippingTrackingNumber>
<ShippingTimestamp>2021-10-13 06:30:00</ShippingTimestamp>
</OrderShipmentDetail>
</OrderShipmentDetails>
</OrderStatusEvent>
</OrderStatusEvents>
</OrderStatusUpdate>
预期的 XML：
<?xml version='1.0' encoding='UTF-8'?>
<MESSAGES>
<COMMANDSTATUS ID="SHIPPED" DESCRIPTION="Goods Shipped">
<ORDER O_ID="002010003694706_1" TRACKING_URL="http://wwwapps.UPS.com/WebTracking/track?track=yes&trackNums=1ZEW3567YW46706215">
<ORDER_LINE OL_ID="1" SKU="28547859" QUANTITY="1"/>
<ORDER_LINE OL_ID="3" SKU="28461473" QUANTITY="1"/>
</ORDER>
</COMMANDSTATUS>
<COMMANDSTATUS ID="SHIPPED" DESCRIPTION="Goods Shipped">
<ORDER O_ID="002010003698153_1" TRACKING_URL="http://wwwapps.UPS.com/WebTracking/track?track=yes&trackNums=1ZEW3571YW13958113">
<ORDER_LINE OL_ID="1" SKU="28353647" QUANTITY="1"/>
<ORDER_LINE OL_ID="2" SKU="28635431" QUANTITY="1"/>
</ORDER>
</COMMANDSTATUS>
</MESSAGES>
我也尝试了 1.0 版本，但没有通过，下面是相同的代码。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" />
<xsl:key name="webOrderId"
match="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent"
use="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId" />
<xsl:variable name="uppercase"
select="'ABCDEFGHIJKLMNOPQRSTUVWXYZ'" />
<xsl:variable name="lowercase"
select="'abcdefghijklmnopqrstuvwxyz'" />
<xsl:template match="/">
<MESSAGES>
<xsl:for-each
select="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent[count(. | key('webOrderId', /OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId)[1]) = 1]">
<xsl:for-each select="key('webOrderId', /OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId)">
<COMMANDSTATUS>
<xsl:attribute name="ID">SHIPPED</xsl:attribute>
<xsl:attribute name="DESCRIPTION">Goods Shipped</xsl:attribute>
<ORDER>
<xsl:choose>
<xsl:when
test="substring(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId, 0, 6) = '00201'">
<xsl:attribute name="O_ID"><xsl:value-of
select='substring(/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId, 6)' /></xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="O_ID"><xsl:value-of
select='/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId' /></xsl:attribute>
</xsl:otherwise>
</xsl:choose>
<xsl:choose>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource = 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">https://www.fedex.com/apps/fedextrack/?tracknumbers=<xsl:value-of
select='/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber' /></xsl:attribute>
</xsl:when>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource != 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">http://wwwapps.<xsl:value-of
select='/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingCarrier' />.com/WebTracking/track?track=yes&trackNums=<xsl:value-of
select='/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber' /></xsl:attribute>
</xsl:when>
</xsl:choose>
<xsl:for-each
select="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent">
<ORDER_LINE>
<xsl:attribute name="OL_ID"><xsl:value-of
select='OrderLineId' /></xsl:attribute>
<xsl:choose>
<xsl:when test="substring(ItemId, 0, 6) = '88-00'">
<xsl:attribute name="SKU"><xsl:value-of
select='substring(ItemId, 6)' /></xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="SKU"><xsl:value-of
select='ItemId' /></xsl:attribute>
</xsl:otherwise>
</xsl:choose>
<xsl:attribute name="QUANTITY"><xsl:value-of
select='/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderStatusDetails/OrderStatusDetail/Qty' /></xsl:attribute>
</ORDER_LINE>
</xsl:for-each>
</ORDER>
</COMMANDSTATUS>
</xsl:for-each>
</xsl:for-each>
</MESSAGES>
</xsl:template>
</xsl:stylesheet>
以下是使用上述代码收到的输出，这是预期之外的。
<?xml version="1.0" encoding="UTF-8"?>
<MESSAGES>
<COMMANDSTATUS ID="SHIPPED" DESCRIPTION="Goods Shipped">
<ORDER O_ID="002010003694706_1 002010003698153_1"
TRACKING_URL="http://wwwapps.UPS.com/WebTracking/track?track=yes&trackNums=1ZEW3567YW46706215 1ZEW3571YW13958113">
<ORDER_LINE OL_ID="1" SKU="28547859" QUANTITY="1"/>
<ORDER_LINE OL_ID="3" SKU="28461473" QUANTITY="1"/>
<ORDER_LINE OL_ID="1" SKU="28353647" QUANTITY="1"/>
<ORDER_LINE OL_ID="2" SKU="28635431" QUANTITY="1"/>
</ORDER>
</COMMANDSTATUS>
<COMMANDSTATUS ID="SHIPPED" DESCRIPTION="Goods Shipped">
<ORDER O_ID="002010003694706_1 002010003698153_1"
TRACKING_URL="http://wwwapps.UPS.com/WebTracking/track?track=yes&trackNums=1ZEW3567YW46706215 1ZEW3571YW13958113">
<ORDER_LINE OL_ID="1" SKU="28547859" QUANTITY="1"/>
<ORDER_LINE OL_ID="3" SKU="28461473" QUANTITY="1"/>
<ORDER_LINE OL_ID="1" SKU="28353647" QUANTITY="1"/>
<ORDER_LINE OL_ID="2" SKU="28635431" QUANTITY="1"/>
</ORDER>
</COMMANDSTATUS>
</MESSAGES>
解决方案
这是适用于我的用例的 XSLT 代码。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" />
<xsl:template match="/">
<MESSAGES>
<xsl:for-each-group
select="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent"
group-by="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/WebOrderId">
<COMMANDSTATUS>
<xsl:attribute name="ID">SHIPPED</xsl:attribute>
<xsl:attribute name="DESCRIPTION">Goods Shipped</xsl:attribute>
<ORDER>
<xsl:choose>
<xsl:when
test="substring(current-grouping-key(), 0, 6) = '00201'">
<xsl:attribute name="O_ID"><xsl:value-of
select='substring(current-grouping-key(), 6)' /></xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="O_ID"><xsl:value-of
select='current-grouping-key()' /></xsl:attribute>
</xsl:otherwise>
</xsl:choose>
<xsl:for-each
select="current-group()[WebOrderId = current-grouping-key()]">
<xsl:choose>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource = 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">https://www.fedex.com/apps/fedextrack/?tracknumbers=<xsl:value-of
select='./OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber' /></xsl:attribute>
</xsl:when>
<xsl:when
test="/OrderStatusUpdate/OrderStatusEvents/OrderStatusEvent/OrderSource != 'STORE-ORDER'">
<xsl:attribute name="TRACKING_URL">http://wwwapps.<xsl:value-of
select='./OrderShipmentDetails/OrderShipmentDetail/ShippingCarrier' />.com/WebTracking/track?track=yes&trackNums=<xsl:value-of
select='./OrderShipmentDetails/OrderShipmentDetail/ShippingTrackingNumber' /></xsl:attribute>
</xsl:when>
</xsl:choose>
</xsl:for-each>
<xsl:for-each
select="current-group()[WebOrderId = current-grouping-key()]">
<ORDER_LINE>
<xsl:attribute name="OL_ID"><xsl:value-of
select='OrderLineId' /></xsl:attribute>
<xsl:choose>
<xsl:when test="substring(ItemId, 0, 6) = '88-00'">
<xsl:attribute name="SKU"><xsl:value-of
select='substring(ItemId, 6)' /></xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="SKU"><xsl:value-of
select='ItemId' /></xsl:attribute>
</xsl:otherwise>
</xsl:choose>
<xsl:attribute name="QUANTITY"><xsl:value-of
select='./OrderStatusDetails/OrderStatusDetail/Qty' /></xsl:attribute>
</ORDER_LINE>
</xsl:for-each>
</ORDER>
</COMMANDSTATUS>
</xsl:for-each-group>
</MESSAGES>
</xsl:template>
</xsl:stylesheet>
谢谢！
推荐阅读
- javascript - javascript将数组作为值添加到对象
- java - Aws Lambda -“errorMessage”：“没有名为 'entityManagerFactory' 的 bean 可用”
- python - 尝试修复 TypeError：freqRolls() 缺少 1 个必需的位置参数：'sides' python
- performance - 更快的迭代
- angular - ionic3 谷歌地图未显示在导航堆栈中
- c# - 坚持如何为 NumberList 创建 DeleteBelow/Above 和 CountBelow/Above 方法
- python - 为什么地理编码器（1.38.1）输出无？
- mysql - MySQL ---从多个表中选择的显式内部连接
- python - 如果随机游走在随机初始化值的范围内，则停止条件
- python - 创建一个函数 generateString(char, val)，它返回一个字符串，其中 val 个 char 字符连接在一起