| Line 354... |
Line 354... |
| 354 |
worksheet2.write(row5, inc(), int(order['paidAmount']))
|
354 |
worksheet2.write(row5, inc(), int(order['paidAmount']))
|
| 355 |
row5 -=1
|
355 |
row5 -=1
|
| 356 |
k=i
|
356 |
k=i
|
| 357 |
for subOrder in order['subOrders']:
|
357 |
for subOrder in order['subOrders']:
|
| 358 |
i = k
|
358 |
i = k
|
| 359 |
row2 += 1
|
359 |
row5 += 1
|
| 360 |
worksheet2.write(row5, inc(), subOrder['productTitle'])
|
360 |
worksheet2.write(row5, inc(), subOrder['productTitle'])
|
| 361 |
worksheet2.write(row5, inc(), subOrder['amountPaid'])
|
361 |
worksheet2.write(row5, inc(), subOrder['amountPaid'])
|
| 362 |
worksheet2.write(row5, inc(), subOrder['quantity'])
|
362 |
worksheet2.write(row5, inc(), subOrder['quantity'])
|
| 363 |
worksheet2.write(row5, inc(), subOrder['status'])
|
363 |
worksheet2.write(row5, inc(), subOrder['status'])
|
| 364 |
worksheet2.write(row5, inc(), subOrder['cashBackStatus'])
|
364 |
worksheet2.write(row5, inc(), subOrder['cashBackStatus'])
|
| 365 |
worksheet2.write(row2, inc(), subOrder['cashBackAmount'])
|
365 |
worksheet2.write(row5, inc(), subOrder['cashBackAmount'])
|
| 366 |
|
366 |
|
| 367 |
last30Days = date.today() - timedelta(days=30)
|
367 |
last30Days = date.today() - timedelta(days=30)
|
| 368 |
int(time.mktime(last30Days.timetuple()))
|
368 |
int(time.mktime(last30Days.timetuple()))
|
| 369 |
row = 0
|
369 |
row = 0
|
| 370 |
for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
|
370 |
for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
|
| Line 748... |
Line 748... |
| 748 |
generateSnapDealReco()
|
748 |
generateSnapDealReco()
|
| 749 |
generateFlipkartReco()
|
749 |
generateFlipkartReco()
|
| 750 |
generateAmazonReco(XLS_A_FILENAME)
|
750 |
generateAmazonReco(XLS_A_FILENAME)
|
| 751 |
getUserOrders()
|
751 |
getUserOrders()
|
| 752 |
sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME)
|
752 |
sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME)
|
| - |
|
753 |
#sendmail(["amit.gupta@shop2020.in"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME)
|
| 753 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com"], "", "All DTR Orders", XLS_O_FILENAME)
|
754 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com"], "", "All DTR Orders", XLS_O_FILENAME)
|
| 754 |
|
755 |
|
| 755 |
if __name__ == '__main__':
|
756 |
if __name__ == '__main__':
|
| 756 |
#info = client.Dtr.flipkartOrderAffiliateInfo.find()
|
757 |
#info = client.Dtr.flipkartOrderAffiliateInfo.find()
|
| 757 |
#print info
|
758 |
#print info
|