SHOW:
|
|
- or go back to the newest paste.
| 1 | - | <!DOCTYPE xsl:stylesheet[ <!ENTITY nl "
"> ]> |
| 1 | + | <!DOCTYPE xsl:stylesheet[ |
| 2 | <!ENTITY nl "
"> | |
| 3 | ]> | |
| 4 | - | <xsl:import href="System\Snippets" /> |
| 4 | + | |
| 5 | - | |
| 5 | + | |
| 6 | - | <xsl:output method="text" encoding="utf-8" /> |
| 6 | + | <xsl:import href="System\Snippets" /> |
| 7 | ||
| 8 | - | <!-- Start of template --> |
| 8 | + | <xsl:output method="text" encoding="utf-8" /> |
| 9 | - | <xsl:template match="/"><xsl:apply-templates /></xsl:template> |
| 9 | + | |
| 10 | - | <xsl:template match="ShipWorks"> |
| 10 | + | <!-- Start of template --> |
| 11 | - | |
| 11 | + | <xsl:template match="/"> |
| 12 | - | <xsl:text>"OrderID","OrderDate","ShippingTotal","OrderTotal","TaxTotal","DiscountTotal","Status","ServiceUsed","ShipDate","TrackingNumber","ItemQTY","ItemName","ItemCode","ItemSKU","ItemTotal","ItemDescription","ShipAddressName","ShipAddressCompany","ShipAddress1","ShipAddress2","ShipAddress3","ShipAddressCity","ShipAddressState","ShipAddressPostalCode","ShipAddressCountryCode","ShipAddressPhoneNumber","ShipAddressEmail","BillAddressName","BillAddressCompany","BillAddress1","BillAddress2","BillAddress3","BillAddressCity","BillAddressState","BillAddressPostalCode","BillAddressCountryCode","BillAddressPhoneNumber","BillAddressEmail"&nl;</xsl:text> |
| 12 | + | <xsl:apply-templates /> |
| 13 | - | |
| 13 | + | </xsl:template> |
| 14 | - | <xsl:for-each select="Customer/Order/Item"> |
| 14 | + | <xsl:template match="ShipWorks"> |
| 15 | - | |
| 15 | + | |
| 16 | - | <xsl:variable name="ship" select="../Address[@type='ship']" /> |
| 16 | + | <xsl:text>"StoreName","Note", "OrderID","OrderNumber","OrderDate","ShippingTotal","OrderTotal","TaxTotal","DiscountTotal","Status","ServiceUsed","ShipDate","TrackingNumber","ItemQTY","ItemName","ItemCode","ItemSKU","ItemTotal","ItemDescription","UnitCost","UnitPrice","ShipAddressName","ShipAddressCompany","ShipAddress1","ShipAddress2","ShipAddress3","ShipAddressCity","ShipAddressState","ShipAddressPostalCode","ShipAddressCountryCode","ShipAddressPhoneNumber","ShipAddressEmail","BillAddressName","BillAddressCompany","BillAddress1","BillAddress2","BillAddress3","BillAddressCity","BillAddressState","BillAddressPostalCode","BillAddressCountryCode","BillAddressPhoneNumber","BillAddressEmail"&nl;</xsl:text> |
| 17 | - | <xsl:variable name="bill" select="../Address[@type='bill']" /> |
| 17 | + | |
| 18 | - | |
| 18 | + | <xsl:text>"</xsl:text> |
| 19 | - | <!-- order id / date --> |
| 19 | + | <xsl:value-of select="Store/StoreName" /> |
| 20 | - | |
| 20 | + | <xsl:text>",</xsl:text> |
| 21 | - | <xsl:text>"</xsl:text><xsl:call-template name="OrderNumber"><xsl:with-param name="order" select=".." /></xsl:call-template><xsl:text>",</xsl:text> |
| 21 | + | |
| 22 | - | <xsl:text>"</xsl:text><xsl:value-of select="sw:ToShortDate(../Date)" /><xsl:text>",</xsl:text> |
| 22 | + | <xsl:for-each select="Customer/Order/Item"> |
| 23 | - | <xsl:text>"</xsl:text><xsl:value-of select="format-number(//Order/Charge[Type='SHIPPING']/Amount, '#,##0.00')" /><xsl:text>",</xsl:text> |
| 23 | + | |
| 24 | - | |
| 24 | + | <xsl:variable name="ship" select="../Address[@type='ship']" /> |
| 25 | - | <xsl:text>"</xsl:text><xsl:value-of select="../Total" /><xsl:text>",</xsl:text> |
| 25 | + | <xsl:variable name="bill" select="../Address[@type='bill']" /> |
| 26 | - | <xsl:text>"</xsl:text><xsl:value-of select="format-number(//Order/Charge[Type='TAX']/Amount, '#,##0.00')" /><xsl:text>",</xsl:text> |
| 26 | + | |
| 27 | - | <xsl:text>"</xsl:text><xsl:value-of select="format-number(//Order/Charge[Type='COUPON']/Amount, '#,##0.00')" /><xsl:text>",</xsl:text> |
| 27 | + | <!-- order id / date --> |
| 28 | - | |
| 28 | + | <xsl:text>"</xsl:text> |
| 29 | <xsl:value-of select="//Order/Note/Text" /> | |
| 30 | - | <xsl:for-each select="//Shipment[Status = 'Processed']"> |
| 30 | + | <xsl:text>",</xsl:text> |
| 31 | - | |
| 31 | + | |
| 32 | - | <xsl:variable name="order" select=".." /> |
| 32 | + | <xsl:text>"</xsl:text> |
| 33 | - | |
| 33 | + | <xsl:value-of select="//Order/Number" /> |
| 34 | - | <xsl:value-of select="$order/Status" /><xsl:text>,</xsl:text> |
| 34 | + | <xsl:text>",</xsl:text> |
| 35 | - | <xsl:value-of select="ServiceUsed" /><xsl:text>,</xsl:text> |
| 35 | + | <xsl:text>"</xsl:text> |
| 36 | - | <xsl:value-of select="ShippedDate" /><xsl:text>,</xsl:text> |
| 36 | + | <xsl:call-template name="OrderNumber"> |
| 37 | - | <xsl:value-of select="TrackingNumber" /><xsl:text>,</xsl:text> |
| 37 | + | <xsl:with-param name="order" select=".." /> |
| 38 | - | |
| 38 | + | </xsl:call-template> |
| 39 | <xsl:text>",</xsl:text> | |
| 40 | - | |
| 40 | + | |
| 41 | - | <!-- line item info --> |
| 41 | + | <xsl:text>"</xsl:text> |
| 42 | - | |
| 42 | + | <xsl:value-of select="sw:ToShortDate(../Date)" /> |
| 43 | - | <xsl:text>"</xsl:text><xsl:value-of select="Quantity" /><xsl:text>",</xsl:text> |
| 43 | + | <xsl:text>",</xsl:text> |
| 44 | - | <xsl:text>"</xsl:text><xsl:value-of select="Name" /><xsl:text>",</xsl:text> |
| 44 | + | <xsl:text>"</xsl:text> |
| 45 | - | <xsl:text>"</xsl:text><xsl:value-of select="Code" /><xsl:text>",</xsl:text> |
| 45 | + | <xsl:value-of select="format-number(//Order/Charge[Type='SHIPPING']/Amount, '#,##0.00')" /> |
| 46 | - | <xsl:text>"</xsl:text><xsl:value-of select="SKU" /><xsl:text>",</xsl:text> |
| 46 | + | <xsl:text>",</xsl:text> |
| 47 | - | <xsl:text>"</xsl:text><xsl:value-of select="Total" /><xsl:text>",</xsl:text> |
| 47 | + | |
| 48 | - | <xsl:text>"</xsl:text><xsl:value-of select="Description" /><xsl:text>",</xsl:text> |
| 48 | + | <xsl:text>"</xsl:text> |
| 49 | - | <!-- shipping address info --> |
| 49 | + | <xsl:value-of select="../Total" /> |
| 50 | - | |
| 50 | + | <xsl:text>",</xsl:text> |
| 51 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/FirstName" /><xsl:text> </xsl:text><xsl:value-of select="$ship/LastName" /><xsl:text>",</xsl:text> |
| 51 | + | <xsl:text>"</xsl:text> |
| 52 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Company" /><xsl:text>",</xsl:text> |
| 52 | + | <xsl:value-of select="format-number(//Order/Charge[Type='TAX']/Amount, '#,##0.00')" /> |
| 53 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Line1" /><xsl:text>",</xsl:text> |
| 53 | + | <xsl:text>",</xsl:text> |
| 54 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Line2" /><xsl:text>",</xsl:text> |
| 54 | + | <xsl:text>"</xsl:text> |
| 55 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Line3" /><xsl:text>",</xsl:text> |
| 55 | + | <xsl:value-of select="format-number(//Order/Charge[Type='COUPON']/Amount, '#,##0.00')" /> |
| 56 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/City" /><xsl:text>",</xsl:text> |
| 56 | + | <xsl:text>",</xsl:text> |
| 57 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/StateCode" /><xsl:text>",</xsl:text> |
| 57 | + | |
| 58 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/PostalCode" /><xsl:text>",</xsl:text> |
| 58 | + | |
| 59 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/CountryCode" /><xsl:text>",</xsl:text> |
| 59 | + | |
| 60 | - | |
| 60 | + | |
| 61 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Phone" /><xsl:text>",</xsl:text> |
| 61 | + | <xsl:choose> |
| 62 | - | <xsl:text>"</xsl:text><xsl:value-of select="$ship/Email" /><xsl:text>"</xsl:text> |
| 62 | + | <xsl:when test="person"> |
| 63 | - | |
| 63 | + | <xsl:for-each select="//Shipment[Status = 'Processed']"> |
| 64 | - | <!-- billing address info --> |
| 64 | + | |
| 65 | - | |
| 65 | + | <xsl:variable name="order" select=".." /> |
| 66 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/FirstName" /><xsl:text> </xsl:text><xsl:value-of select="$bill/LastName" /><xsl:text>",</xsl:text> |
| 66 | + | |
| 67 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Company" /><xsl:text>",</xsl:text> |
| 67 | + | <xsl:value-of select="$order/Status" /> |
| 68 | - | |
| 68 | + | <xsl:text>,</xsl:text> |
| 69 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Line1" /><xsl:text>",</xsl:text> |
| 69 | + | <xsl:value-of select="ServiceUsed" /> |
| 70 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Line2" /><xsl:text>",</xsl:text> |
| 70 | + | <xsl:text>,</xsl:text> |
| 71 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Line3" /><xsl:text>",</xsl:text> |
| 71 | + | <xsl:value-of select="ShippedDate" /> |
| 72 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/City" /><xsl:text>",</xsl:text> |
| 72 | + | <xsl:text>,</xsl:text> |
| 73 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/StateCode" /><xsl:text>",</xsl:text> |
| 73 | + | <xsl:value-of select="TrackingNumber" /> |
| 74 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/PostalCode" /><xsl:text>",</xsl:text> |
| 74 | + | <xsl:text>,</xsl:text> |
| 75 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/CountryCode" /><xsl:text>",</xsl:text> |
| 75 | + | |
| 76 | - | |
| 76 | + | </xsl:for-each> |
| 77 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Phone" /><xsl:text>",</xsl:text> |
| 77 | + | </xsl:when> |
| 78 | - | <xsl:text>"</xsl:text><xsl:value-of select="$bill/Email" /><xsl:text>"</xsl:text> |
| 78 | + | <xsl:otherwise> |
| 79 | - | |
| 79 | + | <div style="font-size:18pt"> |
| 80 | - | <xsl:text>&nl;</xsl:text> |
| 80 | + | <xsl:text>Not Shipped,"","","",</xsl:text> |
| 81 | - | |
| 81 | + | </div> |
| 82 | - | <xsl:text></xsl:text> |
| 82 | + | </xsl:otherwise> |
| 83 | - | |
| 83 | + | </xsl:choose> |
| 84 | - | </xsl:for-each> |
| 84 | + | |
| 85 | - | |
| 85 | + | <!-- line item info --> |
| 86 | ||
| 87 | <xsl:text>"</xsl:text> | |
| 88 | <xsl:value-of select="Quantity" /> | |
| 89 | <xsl:text>",</xsl:text> | |
| 90 | <xsl:text>"</xsl:text> | |
| 91 | <xsl:value-of select="Name" /> | |
| 92 | <xsl:text>",</xsl:text> | |
| 93 | <xsl:text>"</xsl:text> | |
| 94 | <xsl:value-of select="Code" /> | |
| 95 | <xsl:text>",</xsl:text> | |
| 96 | <xsl:text>"</xsl:text> | |
| 97 | <xsl:value-of select="SKU" /> | |
| 98 | <xsl:text>",</xsl:text> | |
| 99 | <xsl:text>"</xsl:text> | |
| 100 | <xsl:value-of select="Total" /> | |
| 101 | <xsl:text>",</xsl:text> | |
| 102 | <xsl:text>"</xsl:text> | |
| 103 | <xsl:value-of select="Description" /> | |
| 104 | <xsl:text>",</xsl:text> | |
| 105 | <xsl:text>"</xsl:text> | |
| 106 | <xsl:value-of select="UnitCost" /> | |
| 107 | <xsl:text>",</xsl:text> | |
| 108 | <xsl:text>"</xsl:text> | |
| 109 | <xsl:value-of select="UnitPriceWithOptions" /> | |
| 110 | <xsl:text>",</xsl:text> | |
| 111 | ||
| 112 | <!-- shipping address info --> | |
| 113 | ||
| 114 | <xsl:text>"</xsl:text> | |
| 115 | <xsl:value-of select="$ship/FirstName" /> | |
| 116 | <xsl:text> </xsl:text> | |
| 117 | <xsl:value-of select="$ship/LastName" /> | |
| 118 | <xsl:text>",</xsl:text> | |
| 119 | <xsl:text>"</xsl:text> | |
| 120 | <xsl:value-of select="$ship/Company" /> | |
| 121 | <xsl:text>",</xsl:text> | |
| 122 | <xsl:text>"</xsl:text> | |
| 123 | <xsl:value-of select="$ship/Line1" /> | |
| 124 | <xsl:text>",</xsl:text> | |
| 125 | <xsl:text>"</xsl:text> | |
| 126 | <xsl:value-of select="$ship/Line2" /> | |
| 127 | <xsl:text>",</xsl:text> | |
| 128 | <xsl:text>"</xsl:text> | |
| 129 | <xsl:value-of select="$ship/Line3" /> | |
| 130 | <xsl:text>",</xsl:text> | |
| 131 | <xsl:text>"</xsl:text> | |
| 132 | <xsl:value-of select="$ship/City" /> | |
| 133 | <xsl:text>",</xsl:text> | |
| 134 | <xsl:text>"</xsl:text> | |
| 135 | <xsl:value-of select="$ship/StateCode" /> | |
| 136 | <xsl:text>",</xsl:text> | |
| 137 | <xsl:text>"</xsl:text> | |
| 138 | <xsl:value-of select="$ship/PostalCode" /> | |
| 139 | <xsl:text>",</xsl:text> | |
| 140 | <xsl:text>"</xsl:text> | |
| 141 | <xsl:value-of select="$ship/CountryCode" /> | |
| 142 | <xsl:text>",</xsl:text> | |
| 143 | ||
| 144 | <xsl:text>"</xsl:text> | |
| 145 | <xsl:value-of select="$ship/Phone" /> | |
| 146 | <xsl:text>",</xsl:text> | |
| 147 | <xsl:text>"</xsl:text> | |
| 148 | <xsl:value-of select="$ship/Email" /> | |
| 149 | <xsl:text>",</xsl:text> | |
| 150 | ||
| 151 | <!-- billing address info --> | |
| 152 | ||
| 153 | <xsl:text>"</xsl:text> | |
| 154 | <xsl:value-of select="$bill/FirstName" /> | |
| 155 | <xsl:text> </xsl:text> | |
| 156 | <xsl:value-of select="$bill/LastName" /> | |
| 157 | <xsl:text>",</xsl:text> | |
| 158 | <xsl:text>"</xsl:text> | |
| 159 | <xsl:value-of select="$bill/Company" /> | |
| 160 | <xsl:text>",</xsl:text> | |
| 161 | ||
| 162 | <xsl:text>"</xsl:text> | |
| 163 | <xsl:value-of select="$bill/Line1" /> | |
| 164 | <xsl:text>",</xsl:text> | |
| 165 | <xsl:text>"</xsl:text> | |
| 166 | <xsl:value-of select="$bill/Line2" /> | |
| 167 | <xsl:text>",</xsl:text> | |
| 168 | <xsl:text>"</xsl:text> | |
| 169 | <xsl:value-of select="$bill/Line3" /> | |
| 170 | <xsl:text>",</xsl:text> | |
| 171 | <xsl:text>"</xsl:text> | |
| 172 | <xsl:value-of select="$bill/City" /> | |
| 173 | <xsl:text>",</xsl:text> | |
| 174 | <xsl:text>"</xsl:text> | |
| 175 | <xsl:value-of select="$bill/StateCode" /> | |
| 176 | <xsl:text>",</xsl:text> | |
| 177 | <xsl:text>"</xsl:text> | |
| 178 | <xsl:value-of select="$bill/PostalCode" /> | |
| 179 | <xsl:text>",</xsl:text> | |
| 180 | <xsl:text>"</xsl:text> | |
| 181 | <xsl:value-of select="$bill/CountryCode" /> | |
| 182 | <xsl:text>",</xsl:text> | |
| 183 | ||
| 184 | <xsl:text>"</xsl:text> | |
| 185 | <xsl:value-of select="$bill/Phone" /> | |
| 186 | <xsl:text>",</xsl:text> | |
| 187 | <xsl:text>"</xsl:text> | |
| 188 | <xsl:value-of select="$bill/Email" /> | |
| 189 | <xsl:text>"</xsl:text> | |
| 190 | ||
| 191 | <xsl:text>&nl;</xsl:text> | |
| 192 | ||
| 193 | <xsl:text></xsl:text> | |
| 194 | </xsl:for-each> | |
| 195 | </xsl:template> | |
| 196 | </xsl:stylesheet> |