| Line 301... |
Line 301... |
| 301 |
affNotReconciledSheet.write(row, inc(), 'Sale Date', boldStyle)
|
301 |
affNotReconciledSheet.write(row, inc(), 'Sale Date', boldStyle)
|
| 302 |
affNotReconciledSheet.write(row, inc(), 'Sale Amount', boldStyle)
|
302 |
affNotReconciledSheet.write(row, inc(), 'Sale Amount', boldStyle)
|
| 303 |
affNotReconciledSheet.write(row, inc(), 'Pay Out', boldStyle)
|
303 |
affNotReconciledSheet.write(row, inc(), 'Pay Out', boldStyle)
|
| 304 |
affNotReconciledSheet.write(row, inc(), 'Status', boldStyle)
|
304 |
affNotReconciledSheet.write(row, inc(), 'Status', boldStyle)
|
| 305 |
db = client.Dtr
|
305 |
db = client.Dtr
|
| - |
|
306 |
last30Days = date.today() - timedelta(days=30)
|
| - |
|
307 |
int(time.mktime(last30Days.timetuple()))
|
| 306 |
for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False}}):
|
308 |
for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False}, "saleTime":{"$gt":int(time.mktime(last30Days.timetuple()))}} ):
|
| 307 |
row += 1
|
309 |
row += 1
|
| 308 |
i=-1
|
310 |
i=-1
|
| 309 |
affNotReconciledSheet.write(row, inc(), offer.get("adId"))
|
311 |
affNotReconciledSheet.write(row, inc(), offer.get("adId"))
|
| 310 |
affNotReconciledSheet.write(row, inc(), offer.get("subTagId"))
|
312 |
affNotReconciledSheet.write(row, inc(), offer.get("subTagId"))
|
| 311 |
affNotReconciledSheet.write(row, inc(), offer.get("saleDate"))
|
313 |
affNotReconciledSheet.write(row, inc(), offer.get("saleDate"))
|