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