Jump to content

xsl grouping issue


dabbu@1234

Recommended Posts

Hi All,

 

I am facing issue while grouping the elements its coming blank with no output. i want to group all the shipments whose location name is same say eg.

shipment PPGNA.00055396 and PPGNA.00055397 group together and PPGNA.00055473 and PPGNA.00055472 separate as they are sharing same location name

below is the xml

 

xml:

 

<?xml version="1.0" encoding="UTF-8"?><notify> <Subject>Consolidated Tender Event Notification</Subject> <Severity>Information</Severity> <Contact ID="to"> <FirstName>FXNL</FirstName> <LastName>TENDER</LastName> <Company>FEDEX NATIONAL (LTL) (FXNL)</Company> <LocationID>FXNL</LocationID> <Phone/> <Fax/> <Role/> </Contact> <contents> <content> <subject>PICKUP</subject> <shipment_gid>PPGNA.00055396</shipment_gid> <i_transaction_no>1693450</i_transaction_no> <tender_record> <bm_refnum>00055396</bm_refnum> <tender_status>PICKUP NOTIFICATION</tender_status> <response_time TZ="America/New_York">2015-06-02 19:19:28</response_time> <number_of_stops>2</number_of_stops> <total_weight IN="LB">9975.0</total_weight> <total_volume IN="CUFT">0.0</total_volume> <total_ship_unit_count>1</total_ship_unit_count> <stops> <stop> <stop_num>2</stop_num> <planned_arrival TZ="America/New_York">2015-05-26 12:00:00</planned_arrival> <planned_departure TZ="America/New_York">2015-05-26 12:29:57</planned_departure> <location_xid>FGL-03520000</location_xid> <location_name>SHL</location_name> <city>SHELBY</city> <province/> <province_code>NC</province_code> <zip_code>28150</zip_code> <country_code>US</country_code> </stop> <stop> <stop_num>1</stop_num> <planned_arrival TZ="America/Chicago">2015-05-21 13:00:00</planned_arrival> <planned_departure TZ="America/Chicago">2015-05-21 13:29:57</planned_departure> <location_xid>FGLSUP-11111113</location_xid> <location_name>MOMENTIVE SPECIALTY CHEMICALS</location_name> <city>BEDFORD PARK</city> <province/> <province_code>IL</province_code> <zip_code>60501</zip_code> <country_code>US</country_code> </stop> </stops> <start_time TZ="America/New_York">2015-05-21 13:00:00</start_time> <end_time TZ="America/Chicago">2015-05-26 12:29:57</end_time> <equipments> <equipment> <equipment_xid>77661</equipment_xid> <equipment_type_xid/> <equipment_type_name/> <equipment_group_xid>28RT_VAN_TEMPCONTROL</equipment_group_xid> <equipment_group_name>28FT_TEMPCONTROL_VAN</equipment_group_name> </equipment> </equipments> <remarks> <remark> <remark_qual_gid>LTL_SOURCE_ADDRESS</remark_qual_gid> <remark_text>8600 WEST 71ST STREET</remark_text> </remark> <remark> <remark_qual_gid>DELIVERY_INSTRUCTIONS_LINE_1</remark_qual_gid> <remark_text>NONE</remark_text> </remark> <remark> <remark_qual_gid>LTL_DEST_ADDRESS</remark_qual_gid> <remark_text>940 WASHBURN SWITCH ROAD</remark_text> </remark> <remark> <remark_qual_gid>LTL_TOTAL_PALLET_COUNT</remark_qual_gid> <remark_text>0</remark_text> </remark> </remarks> </tender_record> <Type>TENDER</Type> </content> <content> <subject>PICKUP</subject> <shipment_gid>PPGNA.00055397</shipment_gid> <i_transaction_no>1693451</i_transaction_no> <tender_record> <bm_refnum>00055397</bm_refnum> <tender_status>PICKUP NOTIFICATION</tender_status> <response_time TZ="America/New_York">2015-06-02 19:19:52</response_time> <number_of_stops>2</number_of_stops> <total_weight IN="LB">9975.0</total_weight> <total_volume IN="CUFT">0.0</total_volume> <total_ship_unit_count>1</total_ship_unit_count> <stops> <stop> <stop_num>1</stop_num> <planned_arrival TZ="America/Chicago">2015-05-21 13:00:00</planned_arrival> <planned_departure TZ="America/Chicago">2015-05-21 13:29:57</planned_departure> <location_xid>FGLSUP-11111113</location_xid> <location_name>MOMENTIVE SPECIALTY CHEMICALS</location_name> <city>BEDFORD PARK</city> <province/> <province_code>IL</province_code> <zip_code>60501</zip_code> <country_code>US</country_code> </stop> <stop> <stop_num>2</stop_num> <planned_arrival TZ="America/New_York">2015-05-26 12:00:00</planned_arrival> <planned_departure TZ="America/New_York">2015-05-26 12:29:57</planned_departure> <location_xid>FGL-03520000</location_xid> <location_name>SHL</location_name> <city>SHELBY</city> <province/> <province_code>NC</province_code> <zip_code>28150</zip_code> <country_code>US</country_code> </stop> </stops> <start_time TZ="America/Chicago">2015-05-21 13:00:00</start_time> <end_time TZ="America/New_York">2015-05-26 12:29:57</end_time> <equipments> <equipment> <equipment_xid>77662</equipment_xid> <equipment_type_xid/> <equipment_type_name/> <equipment_group_xid>28RT_VAN_TEMPCONTROL</equipment_group_xid> <equipment_group_name>28FT_TEMPCONTROL_VAN</equipment_group_name> </equipment> </equipments> <remarks> <remark> <remark_qual_gid>LTL_SOURCE_ADDRESS</remark_qual_gid> <remark_text>8600 WEST 71ST STREET</remark_text> </remark> <remark> <remark_qual_gid>DELIVERY_INSTRUCTIONS_LINE_1</remark_qual_gid> <remark_text>NONE</remark_text> </remark> <remark> <remark_qual_gid>LTL_TOTAL_PALLET_COUNT</remark_qual_gid> <remark_text>0</remark_text> </remark> <remark> <remark_qual_gid>LTL_DEST_ADDRESS</remark_qual_gid> <remark_text>940 WASHBURN SWITCH ROAD</remark_text> </remark> </remarks> </tender_record> <Type>TENDER</Type> </content> <content> <subject>PICKUP</subject> <shipment_gid>PPGNA.00055473</shipment_gid> <i_transaction_no>1693453</i_transaction_no> <tender_record> <bm_refnum>00055473</bm_refnum> <tender_status>PICKUP NOTIFICATION</tender_status> <response_time TZ="America/New_York">2015-06-02 19:21:10</response_time> <number_of_stops>2</number_of_stops> <total_weight IN="LB">8000.0</total_weight> <total_volume IN="CUFT">0.0</total_volume> <total_ship_unit_count>1</total_ship_unit_count> <stops> <stop> <stop_num>1</stop_num> <planned_arrival TZ="America/New_York">2015-05-28 09:22:45</planned_arrival> <planned_departure TZ="America/New_York">2015-05-28 10:22:45</planned_departure> <location_xid>PGL-0306</location_xid> <location_name>WORKS 6 PPG INDUSTRIES INC.</location_name> <city>CARLISLE</city> <province/> <province_code>PA</province_code> <zip_code>17065</zip_code> <country_code>US</country_code> </stop> <stop> <stop_num>2</stop_num> <planned_arrival TZ="America/New_York">2015-06-01 12:00:00</planned_arrival> <planned_departure TZ="America/New_York">2015-06-01 12:00:00</planned_departure> <location_xid>PGLSU-11111121</location_xid> <location_name>MATERIAL SCIENCE</location_name> <city>COLUMBUS</city> <province/> <province_code>OH</province_code> <zip_code>43228</zip_code> <country_code>US</country_code> </stop> </stops> <start_time TZ="America/New_York">2015-05-28 09:22:45</start_time> <end_time TZ="America/New_York">2015-06-01 12:00:00</end_time> <equipments> <equipment> <equipment_xid>77849</equipment_xid> <equipment_type_xid/> <equipment_type_name/> <equipment_group_xid>28CV_VAN</equipment_group_xid> <equipment_group_name>28FT_VAN</equipment_group_name> </equipment> </equipments> <remarks> <remark> <remark_qual_gid>DELIVERY_INSTRUCTIONS_LINE_1</remark_qual_gid> <remark_text>NONE</remark_text> </remark> <remark> <remark_qual_gid>LTL_SOURCE_ADDRESS</remark_qual_gid> <remark_text>400 PARK DRIVE</remark_text> </remark> <remark> <remark_qual_gid>LTL_DEST_ADDRESS</remark_qual_gid> <remark_text>1660 Georgesville Rd</remark_text> </remark> <remark> <remark_qual_gid>LTL_TOTAL_PALLET_COUNT</remark_qual_gid> <remark_text>0</remark_text> </remark> </remarks> </tender_record> <Type>TENDER</Type> </content> <content> <subject>PICKUP</subject> <shipment_gid>PPGNA.00055472</shipment_gid> <i_transaction_no>1693455</i_transaction_no> <tender_record> <bm_refnum>00055472</bm_refnum> <tender_status>PICKUP NOTIFICATION</tender_status> <response_time TZ="America/New_York">2015-06-02 19:21:43</response_time> <number_of_stops>2</number_of_stops> <total_weight IN="LB">8000.0</total_weight> <total_volume IN="CUFT">0.0</total_volume> <total_ship_unit_count>1</total_ship_unit_count> <stops> <stop> <stop_num>1</stop_num> <planned_arrival TZ="America/New_York">2015-05-28 09:20:20</planned_arrival> <planned_departure TZ="America/New_York">2015-05-28 10:20:20</planned_departure> <location_xid>PGL-0306</location_xid> <location_name>WORKS 6 PPG INDUSTRIES INC.</location_name> <city>CARLISLE</city> <province/> <province_code>PA</province_code> <zip_code>17065</zip_code> <country_code>US</country_code> </stop> <stop> <stop_num>2</stop_num> <planned_arrival TZ="America/New_York">2015-06-01 12:00:00</planned_arrival> <planned_departure TZ="America/New_York">2015-06-01 12:00:00</planned_departure> <location_xid>PGLSU-11111121</location_xid> <location_name>MATERIAL SCIENCE</location_name> <city>COLUMBUS</city> <province/> <province_code>OH</province_code> <zip_code>43228</zip_code> <country_code>US</country_code> </stop> </stops> <start_time TZ="America/New_York">2015-05-28 09:20:20</start_time> <end_time TZ="America/New_York">2015-06-01 12:00:00</end_time> <equipments> <equipment> <equipment_xid>77848</equipment_xid> <equipment_type_xid/> <equipment_type_name/> <equipment_group_xid>28CV_VAN</equipment_group_xid> <equipment_group_name>28FT_VAN</equipment_group_name> </equipment> </equipments> <remarks> <remark> <remark_qual_gid>DELIVERY_INSTRUCTIONS_LINE_1</remark_qual_gid> <remark_text>NONE</remark_text> </remark> <remark> <remark_qual_gid>LTL_TOTAL_PALLET_COUNT</remark_qual_gid> <remark_text>0</remark_text> </remark> <remark> <remark_qual_gid>LTL_SOURCE_ADDRESS</remark_qual_gid> <remark_text>400 PARK DRIVE</remark_text> </remark> <remark> <remark_qual_gid>LTL_DEST_ADDRESS</remark_qual_gid> <remark_text>1660 Georgesville Rd</remark_text> </remark> </remarks> </tender_record> <Type>TENDER</Type> </content> </contents> <Locale> <Language>en</Language> <Country>US</Country> <Variant/> </Locale></notify>

 

and xsl used

 

<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:template match="notify"> <html> <body bgcolor="ffffff" vlink="gray" link="#0000cd" marginwidth="10" marginheight="10" leftmargin="10" topmargin="10"> <table width="658" cellpadding="2"> <tr> <td colspan="2"> <img alt="" src=""/> </td> </tr> <tr> <td colspan="2" style="vertical-align: top; font-family: Verdana, Arial, Helvetica; font-size: 16px; "> <xsl:value-of select="Contact[@ID=to]/Company"/> </td> </tr> <tr> <td colspan="2" style="vertical-align: top; font-family: Verdana, Arial, Helvetica; font-size: 28px; font-weight: bold; color: #000000;"> Oracle Transportation Management<br/> Consolidated Pickup Notification </td> </tr> <tr> <td style="vertical-align: top; font-family: Verdana, Arial, Helvetica; font-size: 12px; font-weight: bold;"> Please see below for a listing of Shipments due for Pickup, or that have been cancelled. </td> </tr> <tr> <td></td> </tr> </table> <xsl:for-each select="contents/content"> <table width="658" cellpadding="3" style="border-spacing: 4px 0px;"> <xsl:choose> <xsl:when test="subject='PICKUP_CANCEL'"> <tr> <td style="color:#E26B0A; font-size: 16px; font-family: Verdana, Arial, Helvetica; font-style:italic; font-weight: bold;" colspan="5"> Pickup Cancel </td> </tr> <tr style="background-color:#fabf8f; font-weight:bold; vertical-align: bottom; font-family: Verdana, Arial, Helvetica; font-size: 12px; "> <td>Shipment ID</td> <td>Start Time</td> <td>Total Weight</td> <td>Total Volume</td> <td>Pallet Count</td> </tr> <tr style="background-color:#fde9d9; font-family: Verdana, Arial, Helvetica; font-size: 12px; "> <td><xsl:value-of select="shipment_gid"/></td> <td><xsl:value-of select="tender_record/start_time"/></td> <td><xsl:value-of select="tender_record/total_weight"/></td> <td><xsl:value-of select="tender_record/total_volume"/></td> <td><xsl:value-of select="tender_record/remarks/remark[remark_qual_gid=LTL_TOTAL_PALLET_COUNT]/remark_text"/></td> </tr> </xsl:when> <xsl:otherwise> <tr> <td style="color:#366092; font-size: 16px; font-family: Verdana, Arial, Helvetica; font-style:italic; font-weight: bold;" colspan="5"> Pickup </td> </tr> <tr style="background-color:#538dd5; font-weight:bold; vertical-align: bottom; font-family: Verdana, Arial, Helvetica; font-size: 12px; "> <td>Shipment ID</td> <td>Start Time</td> <td>Total Weight</td> <td>Total Volume</td> <td>Pallet Count</td> </tr> <tr style="background-color:#c5d9f1; font-family: Verdana, Arial, Helvetica; font-size: 12px; "> <td><xsl:value-of select="shipment_gid"/></td> <td><xsl:value-of select="tender_record/start_time"/></td> <td><xsl:value-of select="tender_record/total_weight"/></td> <td><xsl:value-of select="tender_record/total_volume"/></td> <td><xsl:value-of select="tender_record/remarks/remark[remark_qual_gid=LTL_TOTAL_PALLET_COUNT]/remark_text"/></td> </tr> </xsl:otherwise> </xsl:choose> <tr> <td></td> </tr> <tr> <td colspan="5" style="background-color:#bfbfbf; font-family: Verdana, Arial, Helvetica; font-size: 12px; "> Special Instructions: <xsl:value-of select ="tender_record/remarks/remark[remark_qual_gid=DELIVERY_INSTRUCTIONS_LINE_1]/remark_text"/> </td> </tr> <tr> <td></td> </tr> <tr style="background-color:#f2f2f2;"> <td colspan="5"> <table width="658" cellpadding="0" style="vertical-align: top; font-family: Verdana, Arial, Helvetica; font-size: 12px;"> <tr> <td> <span style="font-weight: bold">Pickup</span><br/> <xsl:value-of select="tender_record/stops/stop[stop_num=1]/location_name"/><br/> <xsl:value-of select="tender_record/remarks/remark[remark_qual_gid=LTL_SOURCE_ADDRESS]/remark_text"/><br/> <xsl:value-of select="tender_record/stops/stop[stop_num=1]/city"/><xsl:text>, </xsl:text> <xsl:value-of select="tender_record/stops/stop[stop_num=1]/province_code"/><xsl:text> </xsl:text> <xsl:value-of select="tender_record/stops/stop[stop_num=1]/zip_code"/><xsl:text> </xsl:text> <xsl:val

Edited by dabbu@1234
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...