Subversion Repositories SmartDukaan

Rev

Rev 14511 | Rev 14524 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14511 Rev 14512
Line 303... Line 303...
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)
 306 
    last30Days =  date.today() - timedelta(days=30)
307 
    int(time.mktime(last30Days.timetuple()))
 307 
    int(time.mktime(last30Days.timetuple()))
308 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False}, "saleTime":{"$gt":int(time.mktime(last30Days.timetuple()))}} ):
 308 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
- 
 
 309 
                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
- 
 
 310 
                                                                 "$lt":int(time.mktime(date.today().timetuple()))}} ):
309 
        row += 1
 311 
        row += 1
310 
        i=-1
 312 
        i=-1
311 
        affNotReconciledSheet.write(row, inc(), offer.get("adId"))
313 
        affNotReconciledSheet.write(row, inc(), offer.get("adId"))
312 
        affNotReconciledSheet.write(row, inc(), offer.get("subTagId"))
314 
        affNotReconciledSheet.write(row, inc(), offer.get("subTagId"))
313 
        affNotReconciledSheet.write(row, inc(), offer.get("saleDate"))
315 
        affNotReconciledSheet.write(row, inc(), offer.get("saleDate"))