Subversion Repositories SmartDukaan

Rev

Rev 2585 | Rev 2834 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2585 Rev 2597
Line 218... Line 218...
218
           <schema_name/>
218
           <schema_name/>
219
           </partitioning>
219
           </partitioning>
220
    <connection>transactionDC_Prod</connection>
220
    <connection>transactionDC_Prod</connection>
221
    <sql>SELECT  o.id &apos;order_id&apos;, o.customer_id, o.customer_pincode, 
221
    <sql>SELECT  o.id &apos;order_id&apos;, o.customer_id, o.customer_pincode, 
222
o.status &apos;order_status&apos;, o.total_amount, 
222
o.status &apos;order_status&apos;, o.total_amount, 
223
date(o.created_timestamp) as order_date, o.transaction_id, l.item_id, 
223
date(o.created_timestamp) as order_date, hour(o.created_timestamp) as order_hour,
224
l.quantity, l.unit_price, l.transfer_price, p.gatewayId, pa.value &apos;payment_method&apos;  
224
o.transaction_id, l.item_id, l.quantity, l.unit_price, l.transfer_price, p.gatewayId, 
-
 
225
pa.value &apos;payment_method&apos;  
225
FROM `order` o 
226
FROM `order` o 
226
left join lineitem l on(o.id = l.order_id ) 
227
left join lineitem l on(o.id = l.order_id ) 
227
left join payment.payment p on (o.transaction_id = p.merchantTxnId) 
228
left join payment.payment p on (o.transaction_id = p.merchantTxnId) 
228
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = &apos;payMethod&apos;)
229
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = &apos;payMethod&apos;)
229
group by order_id</sql>
230
group by order_id</sql>
Line 249... Line 250...
249
         <partitioning>
250
         <partitioning>
250
           <method>none</method>
251
           <method>none</method>
251
           <schema_name/>
252
           <schema_name/>
252
           </partitioning>
253
           </partitioning>
253
    <fields>      <field>        <name>order_id</name>
254
    <fields>      <field>        <name>order_id</name>
254
        <rename/>
255
        <rename>order_id</rename>
255
        <length>-2</length>
256
        <length>-2</length>
256
        <precision>-2</precision>
257
        <precision>-2</precision>
257
      </field>      <field>        <name>transaction_id</name>
258
      </field>      <field>        <name>transaction_id</name>
258
        <rename/>
259
        <rename>transaction_id</rename>
259
        <length>-2</length>
260
        <length>-2</length>
260
        <precision>-2</precision>
261
        <precision>-2</precision>
261
      </field>      <field>        <name>customer_id</name>
262
      </field>      <field>        <name>customer_id</name>
262
        <rename/>
263
        <rename>customer_id</rename>
263
        <length>-2</length>
264
        <length>-2</length>
264
        <precision>-2</precision>
265
        <precision>-2</precision>
265
      </field>      <field>        <name>customer_pincode</name>
266
      </field>      <field>        <name>customer_pincode</name>
266
        <rename>pincode</rename>
267
        <rename>pincode</rename>
267
        <length>-2</length>
268
        <length>-2</length>
268
        <precision>-2</precision>
269
        <precision>-2</precision>
269
      </field>      <field>        <name>date_id</name>
270
      </field>      <field>        <name>date_id</name>
270
        <rename/>
271
        <rename>date_id</rename>
271
        <length>-2</length>
272
        <length>-2</length>
272
        <precision>-2</precision>
273
        <precision>-2</precision>
273
      </field>      <field>        <name>item_id</name>
274
      </field>      <field>        <name>item_id</name>
274
        <rename/>
275
        <rename>item_id</rename>
275
        <length>-2</length>
276
        <length>-2</length>
276
        <precision>-2</precision>
277
        <precision>-2</precision>
277
      </field>      <field>        <name>quantity</name>
278
      </field>      <field>        <name>quantity</name>
278
        <rename/>
279
        <rename>quantity</rename>
279
        <length>-2</length>
280
        <length>-2</length>
280
        <precision>-2</precision>
281
        <precision>-2</precision>
281
      </field>      <field>        <name>unit_price</name>
282
      </field>      <field>        <name>unit_price</name>
282
        <rename/>
283
        <rename>unit_price</rename>
283
        <length>-2</length>
284
        <length>-2</length>
284
        <precision>-2</precision>
285
        <precision>-2</precision>
285
      </field>      <field>        <name>order_status</name>
286
      </field>      <field>        <name>order_status</name>
286
        <rename>status</rename>
287
        <rename>status</rename>
287
        <length>-2</length>
288
        <length>-2</length>
288
        <precision>-2</precision>
289
        <precision>-2</precision>
289
      </field>      <field>        <name>total_amount</name>
290
      </field>      <field>        <name>total_amount</name>
290
        <rename/>
291
        <rename>total_amount</rename>
291
        <length>-2</length>
292
        <length>-2</length>
292
        <precision>-2</precision>
293
        <precision>-2</precision>
293
      </field>      <field>        <name>transfer_price</name>
294
      </field>      <field>        <name>transfer_price</name>
294
        <rename/>
295
        <rename>transfer_price</rename>
295
        <length>-2</length>
296
        <length>-2</length>
296
        <precision>-2</precision>
297
        <precision>-2</precision>
297
      </field>      <field>        <name>gatewayId</name>
298
      </field>      <field>        <name>gatewayId</name>
298
        <rename/>
299
        <rename>gatewayId</rename>
299
        <length>-2</length>
300
        <length>-2</length>
300
        <precision>-2</precision>
301
        <precision>-2</precision>
301
      </field>      <field>        <name>payment_method</name>
302
      </field>      <field>        <name>payment_method</name>
-
 
303
        <rename>payment_method</rename>
302
        <rename/>
304
        <length>-2</length>
-
 
305
        <precision>-2</precision>
-
 
306
      </field>      <field>        <name>order_hour</name>
-
 
307
        <rename>order_hour</rename>
303
        <length>-2</length>
308
        <length>-2</length>
304
        <precision>-2</precision>
309
        <precision>-2</precision>
305
      </field>        <select_unspecified>N</select_unspecified>
310
      </field>        <select_unspecified>N</select_unspecified>
306
    </fields>     <cluster_schema/>
311
    </fields>     <cluster_schema/>
307
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
312
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>