Subversion Repositories SmartDukaan

Rev

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

Rev 16956 Rev 16957
Line 426... Line 426...
426
        affNotReconciledSheet.write(row, inc(), offer.get("saleAmount")) 
426
        affNotReconciledSheet.write(row, inc(), offer.get("saleAmount")) 
427
        affNotReconciledSheet.write(row, inc(), offer.get("payOut")) 
427
        affNotReconciledSheet.write(row, inc(), offer.get("payOut")) 
428
        affNotReconciledSheet.write(row, inc(), offer.get("conversionStatus"))
428
        affNotReconciledSheet.write(row, inc(), offer.get("conversionStatus"))
429
        affNotReconciledSheet.write(row, inc(), offer.get("ip"))
429
        affNotReconciledSheet.write(row, inc(), offer.get("ip"))
430
    
430
    
431
    for offer in db.snapdealOrderAffiliateInfo1.find({}):
431
#    for offer in db.snapdealOrderAffiliateInfo1.find({}):
432
        saleTime =  utils.fromTimeStamp(offer.get('saleDate')).strftime("%Y-%m-%d")
432
#        saleTime =  utils.fromTimeStamp(offer.get('saleDate')).strftime("%Y-%m-%d")
433
        obj = datemap.get(saleTime)
433
#        obj = datemap.get(saleTime)
434
        if offer.get("payOut"):
434
#        if offer.get("payOut"):
435
            obj['approvedAmount'] += order["approvedAmount"]
435
#            obj['approvedAmount'] += order["approvedAmount"]
436
        else:
436
#        else:
437
            obj['rejectedAmount'] += order["rejectedAmount"] 
437
#            obj['rejectedAmount'] += order["rejectedAmount"] 
438
    
438
    
439
 
439
 
440
    workbook.save(XLS_FILENAME)
440
    workbook.save(XLS_FILENAME)
441
    
441
    
442
def generateShopcluesReco():
442
def generateShopcluesReco():