Subversion Repositories SmartDukaan

Rev

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

Rev 16213 Rev 16238
Line 408... Line 408...
408
 
408
 
409
    workbook.save(XLS_FILENAME)
409
    workbook.save(XLS_FILENAME)
410
    
410
    
411
def generateShopcluesReco():
411
def generateShopcluesReco():
412
    global i
412
    global i
413
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 3)
413
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 5)
414
    db = client.Dtr
414
    db = client.Dtr
415
    notReconciled = {}
415
    notReconciled = {}
416
    matchedList = []
416
    matchedList = []
417
    workbook = xlwt.Workbook()
417
    workbook = xlwt.Workbook()
418
    worksheet = workbook.add_sheet("Shopclues Reconciled")
418
    worksheet = workbook.add_sheet("Shopclues Reconciled")
Line 473... Line 473...
473
            worksheet1.write(anotherrow, i, datetime.strftime(fromTimeStamp(aff[0]['transactionTime']), "%d %b %Y %I:%M %p"))
473
            worksheet1.write(anotherrow, i, datetime.strftime(fromTimeStamp(aff[0]['transactionTime']), "%d %b %Y %I:%M %p"))
474
            worksheet.write(row, inc(), aff[0]['transactionValue'])
474
            worksheet.write(row, inc(), aff[0]['transactionValue'])
475
            worksheet1.write(anotherrow, i, aff[0]['transactionValue'])
475
            worksheet1.write(anotherrow, i, aff[0]['transactionValue'])
476
            worksheet.write(row, inc(), aff[0]['payOut'])
476
            worksheet.write(row, inc(), aff[0]['payOut'])
477
            worksheet1.write(anotherrow, i, aff[0]['payOut'])
477
            worksheet1.write(anotherrow, i, aff[0]['payOut'])
478
            worksheet.write(row, inc(), aff[0]['ip'])
478
            worksheet.write(row, inc(), "NA")
479
            worksheet1.write(anotherrow, i, aff[0]['ip'])
479
            worksheet1.write(anotherrow, i, "NA")
480
            k = i
480
            k = i
481
            row -= 1
481
            row -= 1
482
            anotherrow -= 1
482
            anotherrow -= 1
483
            for subOrder in order['subOrders']:
483
            for subOrder in order['subOrders']:
484
                i = k
484
                i = k