| Line 179... |
Line 179... |
| 179 |
<method>none</method>
|
179 |
<method>none</method>
|
| 180 |
<schema_name/>
|
180 |
<schema_name/>
|
| 181 |
</partitioning>
|
181 |
</partitioning>
|
| 182 |
<connection>transactionDC_Prod</connection>
|
182 |
<connection>transactionDC_Prod</connection>
|
| 183 |
<sql>SELECT SQL_NO_CACHE o.id 'order_id', o.customer_id, o.customer_pincode,
|
183 |
<sql>SELECT SQL_NO_CACHE o.id 'order_id', o.customer_id, o.customer_pincode,
|
| 184 |
o.status 'order_status', o.total_amount, o.pickupStoreId,
|
184 |
o.status 'order_status', o.total_amount, ps.hotspotId as pickupStoreId,
|
| 185 |
datediff(o.created_timestamp, '20101231') as date_id, hour(o.created_timestamp) as order_hour,
|
185 |
datediff(o.created_timestamp, '20101231') as date_id, hour(o.created_timestamp) as order_hour,
|
| 186 |
o.transaction_id, l.item_id, l.quantity,
|
186 |
o.transaction_id, l.item_id, l.quantity,
|
| 187 |
case when unit_price<250 then 0 when unit_price<500 then 1 when unit_price<1000 then 2 when unit_price<2000 then 3 when unit_price < 5000 then 4 when unit_price < 10000 then 5 when unit_price < 15000 then 6 when unit_price <20000 then 7 when unit_price < 50000 then 8 else 9 end as price_range,
|
187 |
case when unit_price<250 then 0 when unit_price<500 then 1 when unit_price<1000 then 2 when unit_price<2000 then 3 when unit_price < 5000 then 4 when unit_price < 10000 then 5 when unit_price < 15000 then 6 when unit_price <20000 then 7 when unit_price < 50000 then 8 else 9 end as price_range,
|
| 188 |
l.transfer_price, p.gatewayId,
|
188 |
l.transfer_price, p.gatewayId,
|
| 189 |
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',
|
189 |
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',
|
| Line 201... |
Line 201... |
| 201 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
201 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| 202 |
left join transaction t on (o.transaction_id = t.id)
|
202 |
left join transaction t on (o.transaction_id = t.id)
|
| 203 |
left join user.tracklog tl on (tl.data like concat(convert(p.id, char), '%'))
|
203 |
left join user.tracklog tl on (tl.data like concat(convert(p.id, char), '%'))
|
| 204 |
left join user.user u on (u.id = o.customer_id)
|
204 |
left join user.user u on (u.id = o.customer_id)
|
| 205 |
left join user.affiliate aff on (tl.affiliate_id = aff.id)
|
205 |
left join user.affiliate aff on (tl.affiliate_id = aff.id)
|
| - |
|
206 |
left join logistics.pickupstore ps on (o.pickupStoreId = ps.id)
|
| 206 |
group by order_id</sql>
|
207 |
group by order_id</sql>
|
| 207 |
<limit>0</limit>
|
208 |
<limit>0</limit>
|
| 208 |
<lookup/>
|
209 |
<lookup/>
|
| 209 |
<execute_each_row>N</execute_each_row>
|
210 |
<execute_each_row>N</execute_each_row>
|
| 210 |
<variables_active>N</variables_active>
|
211 |
<variables_active>N</variables_active>
|