| Line 71... |
Line 71... |
| 71 |
select ow.*, u.username, crm1.order_count, u.referrer, aua.city,aua.state,aua.pincode from order_view ow
|
71 |
select ow.*, u.username, crm1.order_count, u.referrer, aua.city,aua.state,aua.pincode from order_view ow
|
| 72 |
left join users u on u.id = ow.user_id
|
72 |
left join users u on u.id = ow.user_id
|
| 73 |
left join (select user_id, count(*) as order_count from order_view where status in ('ORDER_CREATED','DETAIL_CREATED') group by user_id)as crm1 on ow.user_id = crm1.user_id
|
73 |
left join (select user_id, count(*) as order_count from order_view where status in ('ORDER_CREATED','DETAIL_CREATED') group by user_id)as crm1 on ow.user_id = crm1.user_id
|
| 74 |
left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
|
74 |
left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
|
| 75 |
where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
|
75 |
where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
|
| 76 |
''',)
|
76 |
''')
|
| 77 |
|
77 |
|
| 78 |
query = """INSERT INTO allorder
|
78 |
query = """INSERT INTO allorder
|
| 79 |
(user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode, merchant_suborder_id,cashback_status,cashback_amount)
|
79 |
(user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode, merchant_suborder_id,cashback_status,cashback_amount)
|
| 80 |
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
|
80 |
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
|
| 81 |
"""
|
81 |
"""
|
| Line 128... |
Line 128... |
| 128 |
city = result[10]
|
128 |
city = result[10]
|
| 129 |
state = result[11]
|
129 |
state = result[11]
|
| 130 |
pincode = result[12]
|
130 |
pincode = result[12]
|
| 131 |
|
131 |
|
| 132 |
print user_id
|
132 |
print user_id
|
| 133 |
values = (user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode,merchant_suborder_id,cashback_status,cashback_amount)
|
133 |
cur.execute(query,user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode,merchant_suborder_id,cashback_status,cashback_amount)
|
| 134 |
cur.execute(query,values)
|
- |
|
| 135 |
con.commit()
|
134 |
con.commit()
|
| 136 |
except _mysql.Error, e:
|
135 |
except _mysql.Error, e:
|
| 137 |
|
136 |
|
| 138 |
print "Error %d: %s" % (e.args[0], e.args[1])
|
137 |
print "Error %d: %s" % (e.args[0], e.args[1])
|
| 139 |
sys.exit(1)
|
138 |
sys.exit(1)
|