| Line 193... |
Line 193... |
| 193 |
case when datediff(t.session_start_time, u.source_start_time) > 30 then 0 when datediff(t.session_start_time, u.source_start_time) > 15 then 1
|
193 |
case when datediff(t.session_start_time, u.source_start_time) > 30 then 0 when datediff(t.session_start_time, u.source_start_time) > 15 then 1
|
| 194 |
when datediff(t.session_start_time, u.source_start_time) > 7 then 2 when datediff(t.session_start_time, u.source_start_time) > 2 then 3
|
194 |
when datediff(t.session_start_time, u.source_start_time) > 7 then 2 when datediff(t.session_start_time, u.source_start_time) > 2 then 3
|
| 195 |
when datediff(t.session_start_time, u.source_start_time) > 1 then 4 else 5 end as days_to_purchase, aff.name aff_name,
|
195 |
when datediff(t.session_start_time, u.source_start_time) > 1 then 4 else 5 end as days_to_purchase, aff.name aff_name,
|
| 196 |
case when o.originalOrderId is null then datediff(o.created_timestamp, '20101231')
|
196 |
case when o.originalOrderId is null then datediff(o.created_timestamp, '20101231')
|
| 197 |
else datediff((select created_timestamp from `order` where id = o.originalOrderId), '20101231') end as booking_date_id ,
|
197 |
else datediff((select created_timestamp from `order` where id = o.originalOrderId), '20101231') end as booking_date_id ,
|
| 198 |
o.otg as otg,
|
198 |
case when o.otg = 1 then 1 else 0 end as otg,
|
| 199 |
o.insurer, o.insuranceAmount
|
199 |
o.insurer, o.insuranceAmount
|
| 200 |
FROM `order` o
|
200 |
FROM `order` o
|
| 201 |
left join lineitem l on(o.id = l.order_id )
|
201 |
left join lineitem l on(o.id = l.order_id )
|
| 202 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId and p.id=(select max(id) from payment.payment where merchantTxnId = o.transaction_id))
|
202 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId and p.id=(select max(id) from payment.payment where merchantTxnId = o.transaction_id))
|
| 203 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
203 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| Line 310... |
Line 310... |
| 310 |
<precision>-2</precision>
|
310 |
<precision>-2</precision>
|
| 311 |
</field> <field> <name>booking_date_id</name>
|
311 |
</field> <field> <name>booking_date_id</name>
|
| 312 |
<rename/>
|
312 |
<rename/>
|
| 313 |
<length>-2</length>
|
313 |
<length>-2</length>
|
| 314 |
<precision>-2</precision>
|
314 |
<precision>-2</precision>
|
| - |
|
315 |
</field> <field> <name>nlc</name>
|
| - |
|
316 |
<rename/>
|
| - |
|
317 |
<length>-2</length>
|
| - |
|
318 |
<precision>-2</precision>
|
| - |
|
319 |
</field> <field> <name>otg</name>
|
| - |
|
320 |
<rename/>
|
| - |
|
321 |
<length>-2</length>
|
| - |
|
322 |
<precision>-2</precision>
|
| - |
|
323 |
</field> <field> <name>insurer</name>
|
| - |
|
324 |
<rename/>
|
| - |
|
325 |
<length>-2</length>
|
| - |
|
326 |
<precision>-2</precision>
|
| - |
|
327 |
</field> <field> <name>insuranceAmount</name>
|
| - |
|
328 |
<rename/>
|
| - |
|
329 |
<length>-2</length>
|
| - |
|
330 |
<precision>-2</precision>
|
| 315 |
</field> <select_unspecified>N</select_unspecified>
|
331 |
</field> <select_unspecified>N</select_unspecified>
|
| 316 |
</fields> <cluster_schema/>
|
332 |
</fields> <cluster_schema/>
|
| 317 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
333 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 318 |
<xloc>369</xloc>
|
334 |
<xloc>369</xloc>
|
| 319 |
<yloc>162</yloc>
|
335 |
<yloc>162</yloc>
|
| Line 330... |
Line 346... |
| 330 |
<partitioning>
|
346 |
<partitioning>
|
| 331 |
<method>none</method>
|
347 |
<method>none</method>
|
| 332 |
<schema_name/>
|
348 |
<schema_name/>
|
| 333 |
</partitioning>
|
349 |
</partitioning>
|
| 334 |
<connection>salesDC_DW</connection>
|
350 |
<connection>salesDC_DW</connection>
|
| 335 |
<schema/>
|
351 |
<schema>sales</schema>
|
| 336 |
<table>sales</table>
|
352 |
<table>sales</table>
|
| 337 |
<commit>1000</commit>
|
353 |
<commit>1000</commit>
|
| 338 |
<truncate>Y</truncate>
|
354 |
<truncate>Y</truncate>
|
| 339 |
<ignore_errors>N</ignore_errors>
|
355 |
<ignore_errors>N</ignore_errors>
|
| 340 |
<use_batch>Y</use_batch>
|
356 |
<use_batch>Y</use_batch>
|
| Line 431... |
Line 447... |
| 431 |
</field>
|
447 |
</field>
|
| 432 |
<field>
|
448 |
<field>
|
| 433 |
<column_name>pickupStoreId</column_name>
|
449 |
<column_name>pickupStoreId</column_name>
|
| 434 |
<stream_name>pickupStoreId</stream_name>
|
450 |
<stream_name>pickupStoreId</stream_name>
|
| 435 |
</field>
|
451 |
</field>
|
| - |
|
452 |
<field>
|
| - |
|
453 |
<column_name>nlc</column_name>
|
| - |
|
454 |
<stream_name>nlc</stream_name>
|
| - |
|
455 |
</field>
|
| - |
|
456 |
<field>
|
| - |
|
457 |
<column_name>otg</column_name>
|
| - |
|
458 |
<stream_name>otg</stream_name>
|
| - |
|
459 |
</field>
|
| - |
|
460 |
<field>
|
| - |
|
461 |
<column_name>insurer</column_name>
|
| - |
|
462 |
<stream_name>insurer</stream_name>
|
| - |
|
463 |
</field>
|
| - |
|
464 |
<field>
|
| - |
|
465 |
<column_name>insuranceAmount</column_name>
|
| - |
|
466 |
<stream_name>insuranceAmount</stream_name>
|
| - |
|
467 |
</field>
|
| 436 |
</fields>
|
468 |
</fields>
|
| 437 |
<cluster_schema/>
|
469 |
<cluster_schema/>
|
| 438 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
470 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 439 |
<xloc>631</xloc>
|
471 |
<xloc>631</xloc>
|
| 440 |
<yloc>162</yloc>
|
472 |
<yloc>162</yloc>
|