| Line 72... |
Line 72... |
| 72 |
left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
|
72 |
left join (select * from (select * from all_user_addresses order by source) s group by user_id)aua on aua.user_id=u.id
|
| 73 |
where (lower(u.referrer) not like %s or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED') and ow.created >= %s and ow.created < %s;
|
73 |
where (lower(u.referrer) not like %s or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED') and ow.created >= %s and ow.created < %s;
|
| 74 |
''', start_date, end_date, 'emp%', start_date, end_date, )
|
74 |
''', start_date, end_date, 'emp%', start_date, end_date, )
|
| 75 |
|
75 |
|
| 76 |
query = """INSERT INTO allorder
|
76 |
query = """INSERT INTO allorder
|
| 77 |
(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,quantity)
|
77 |
(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,quantity, reconciled, affstatus)
|
| 78 |
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, %s)
|
78 |
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, %s, %s, %s)
|
| 79 |
"""
|
79 |
"""
|
| 80 |
for result in results:
|
80 |
for result in results:
|
| 81 |
morder = db.merchantOrder.find_one({"orderId":result[0]})
|
81 |
morder = db.merchantOrder.find_one({"orderId":result[0]})
|
| 82 |
if morder is not None:
|
82 |
if morder is not None:
|
| - |
|
83 |
reconciled=morder.get("reconciled")
|
| 83 |
subOrders = morder.get("subOrders")
|
84 |
subOrders = morder.get("subOrders")
|
| 84 |
if subOrders is not None:
|
85 |
if subOrders is not None:
|
| 85 |
for subOrder in subOrders:
|
86 |
for subOrder in subOrders:
|
| 86 |
user_id = result[1]
|
87 |
user_id = result[1]
|
| 87 |
user_name= result[7]
|
88 |
user_name= result[7]
|
| Line 107... |
Line 108... |
| 107 |
category = skuData.get("category")
|
108 |
category = skuData.get("category")
|
| 108 |
deal_rank = subOrder.get("dealRank")
|
109 |
deal_rank = subOrder.get("dealRank")
|
| 109 |
max_nlc = subOrder.get("maxNlc")
|
110 |
max_nlc = subOrder.get("maxNlc")
|
| 110 |
min_nlc = subOrder.get("minNlc")
|
111 |
min_nlc = subOrder.get("minNlc")
|
| 111 |
dp = subOrder.get("db")
|
112 |
dp = subOrder.get("db")
|
| - |
|
113 |
affStatus = subOrder.get('affStatus')
|
| 112 |
item_status = utils.statusMap.get(subOrder.get("itemStatus"))
|
114 |
item_status = utils.statusMap.get(subOrder.get("itemStatus"))
|
| 113 |
else:
|
115 |
else:
|
| 114 |
catalog_id = 'None'
|
116 |
catalog_id = 'None'
|
| 115 |
brand= 'None'
|
117 |
brand= 'None'
|
| 116 |
model = 'None'
|
118 |
model = 'None'
|
| Line 126... |
Line 128... |
| 126 |
city = result[10]
|
128 |
city = result[10]
|
| 127 |
state = result[11]
|
129 |
state = result[11]
|
| 128 |
pincode = result[12]
|
130 |
pincode = result[12]
|
| 129 |
|
131 |
|
| 130 |
print user_id
|
132 |
print user_id
|
| 131 |
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, quantity)
|
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, quantity, reconciled, affStatus)
|
| 132 |
cur.execute(query,values)
|
134 |
cur.execute(query,values)
|
| 133 |
con.commit()
|
135 |
con.commit()
|
| 134 |
except _mysql.Error, e:
|
136 |
except _mysql.Error, e:
|
| 135 |
print "Error %d: %s" % (e.args[0], e.args[1])
|
137 |
print "Error %d: %s" % (e.args[0], e.args[1])
|
| 136 |
sys.exit(1)
|
138 |
sys.exit(1)
|