View difference between Paste ID: rA59Abma and b8C0Cdm2
SHOW: | | - or go back to the newest paste.
1-
<!DOCTYPE xsl:stylesheet[ <!ENTITY nl "&#xd;&#xa;"> ]>
1+
<!DOCTYPE xsl:stylesheet[
2
  <!ENTITY nl "&#xd;&#xa;">
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>