| Line 1... |
Line 1... |
| 1 |
<?xml version="1.0" encoding="UTF-8"?>
|
1 |
<?xml version="1.0" encoding="UTF-8"?>
|
| 2 |
<transformation>
|
2 |
<transformation>
|
| 3 |
<info>
|
3 |
<info>
|
| 4 |
<name>ordersLoader</name>
|
4 |
<name>orderFulfillmentLoader</name>
|
| 5 |
<description/>
|
5 |
<description/>
|
| 6 |
<extended_description/>
|
6 |
<extended_description/>
|
| 7 |
<trans_version/>
|
7 |
<trans_version/>
|
| 8 |
<trans_type>Normal</trans_type>
|
8 |
<trans_type>Normal</trans_type>
|
| - |
|
9 |
<trans_status>0</trans_status>
|
| 9 |
<directory>/</directory>
|
10 |
<directory>/</directory>
|
| 10 |
<parameters>
|
11 |
<parameters>
|
| 11 |
</parameters>
|
12 |
</parameters>
|
| 12 |
<log>
|
13 |
<log>
|
| 13 |
<trans-log-table><connection/>
|
14 |
<trans-log-table><connection/>
|
| Line 191... |
Line 192... |
| 191 |
<method>none</method>
|
192 |
<method>none</method>
|
| 192 |
<schema_name/>
|
193 |
<schema_name/>
|
| 193 |
</partitioning>
|
194 |
</partitioning>
|
| 194 |
<connection>transactionDC_Prod</connection>
|
195 |
<connection>transactionDC_Prod</connection>
|
| 195 |
<sql>select datediff(o.created_timestamp, '20101231') as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
|
196 |
<sql>select datediff(o.created_timestamp, '20101231') as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
|
| - |
|
197 |
case when pa.value is null then case when p.gatewayId = 1 then 2099 when p.gatewayId = 2 then 1099 else null end else pa.value end 'payment_method',
|
| 196 |
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
|
198 |
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
|
| 197 |
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
|
199 |
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
|
| 198 |
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_reason
|
200 |
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_reason
|
| 199 |
from `order` o
|
201 |
from `order` o
|
| 200 |
left join lineitem l on (o.id = l.order_id)
|
202 |
left join lineitem l on (o.id = l.order_id)
|
| - |
|
203 |
left join (select * from payment.payment order by id desc) p on (o.transaction_id = p.merchantTxnId)
|
| - |
|
204 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| 201 |
where o.status not in (0, 1)</sql>
|
205 |
where o.status not in (0, 1)</sql>
|
| 202 |
<limit>0</limit>
|
206 |
<limit>0</limit>
|
| 203 |
<lookup/>
|
207 |
<lookup/>
|
| 204 |
<execute_each_row>N</execute_each_row>
|
208 |
<execute_each_row>N</execute_each_row>
|
| 205 |
<variables_active>N</variables_active>
|
209 |
<variables_active>N</variables_active>
|
| Line 256... |
Line 260... |
| 256 |
<precision>-2</precision>
|
260 |
<precision>-2</precision>
|
| 257 |
</field> <field> <name>delay_reason</name>
|
261 |
</field> <field> <name>delay_reason</name>
|
| 258 |
<rename/>
|
262 |
<rename/>
|
| 259 |
<length>-2</length>
|
263 |
<length>-2</length>
|
| 260 |
<precision>-2</precision>
|
264 |
<precision>-2</precision>
|
| - |
|
265 |
</field> <field> <name>payment_method</name>
|
| - |
|
266 |
<rename/>
|
| - |
|
267 |
<length>-2</length>
|
| - |
|
268 |
<precision>-2</precision>
|
| 261 |
</field> <select_unspecified>N</select_unspecified>
|
269 |
</field> <select_unspecified>N</select_unspecified>
|
| 262 |
</fields> <cluster_schema/>
|
270 |
</fields> <cluster_schema/>
|
| 263 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
271 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 264 |
<xloc>371</xloc>
|
272 |
<xloc>371</xloc>
|
| 265 |
<yloc>160</yloc>
|
273 |
<yloc>160</yloc>
|