| Line 67... |
Line 67... |
| 67 |
print order
|
67 |
print order
|
| 68 |
saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%d %B, %Y %I:%M %p").replace(hour=0, minute=0, second=0, microsecond=0).timetuple()))
|
68 |
saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%d %B, %Y %I:%M %p").replace(hour=0, minute=0, second=0, microsecond=0).timetuple()))
|
| 69 |
#saleTime1 = int(time.mktime((datetime.strptime(order['placedOn'], "%b %d, %Y %I:%M %p") + timedelta(seconds=-60)).timetuple()))
|
69 |
#saleTime1 = int(time.mktime((datetime.strptime(order['placedOn'], "%b %d, %Y %I:%M %p") + timedelta(seconds=-60)).timetuple()))
|
| 70 |
|
70 |
|
| 71 |
for subOrder in order['subOrders']:
|
71 |
for subOrder in order['subOrders']:
|
| 72 |
affs = list(db.flipkartOrderAffiliateInfo.find({"subOrders.productCode":subOrder.getProductCode("productCode"), "saleDateInt":saleTime}))
|
72 |
affs = list(db.flipkartOrderAffiliateInfo.find({"subOrders.productCode":subOrder.get("productCode"), "saleDateInt":saleTime}))
|
| 73 |
row += 1
|
73 |
row += 1
|
| 74 |
global i
|
74 |
global i
|
| 75 |
i=-1
|
75 |
i=-1
|
| 76 |
worksheet.write(row, inc(), orderId)
|
76 |
worksheet.write(row, inc(), orderId)
|
| 77 |
worksheet.write(row, inc(), row1[1])
|
77 |
worksheet.write(row, inc(), row1[1])
|