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>