Subversion Repositories SmartDukaan

Rev

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

Rev 14452 Rev 14453
Line 37... Line 37...
37 
    boldStyle.font = f
 37 
    boldStyle.font = f
38 
    column = 0
 38 
    column = 0
39 
    row = 0
 39 
    row = 0
40
40
41 
    worksheet.write(row, 0, 'Order Id', boldStyle)
 41 
    worksheet.write(row, 0, 'Order Id', boldStyle)
- 
 
 42 
    worksheet.write(row, 1, 'User Id', boldStyle)
42 
    worksheet.write(row, 1, 'Merchant Order Id', boldStyle)
 43 
    worksheet.write(row, 2, 'Merchant Order Id', boldStyle)
43 
    worksheet.write(row, 2, 'Product Title', boldStyle)
 44 
    worksheet.write(row, 3, 'Product Title', boldStyle)
44 
    worksheet.write(row, 3, 'Price', boldStyle)
 45 
    worksheet.write(row, 4, 'Price', boldStyle)
45 
    worksheet.write(row, 4, 'Quantity', boldStyle)
 46 
    worksheet.write(row, 5, 'Quantity', boldStyle)
- 
 
 47 
    worksheet.write(row, 6, 'Status', boldStyle)
46 
    worksheet.write(row, 5, 'Status', boldStyle)
 48 
    worksheet.write(row, 7, 'Status', boldStyle)
47 
    worksheet.write(row, 6, 'Cashback Status', boldStyle)
 49 
    worksheet.write(row, 8, 'Cashback Status', boldStyle)
48 
    worksheet.write(row, 7, 'Our CashBack', boldStyle)
 50 
    worksheet.write(row, 9, 'Our CashBack', boldStyle)
49 
    worksheet.write(row, 8, 'Sale Date', boldStyle)
 51 
    worksheet.write(row, 10, 'Sale Date', boldStyle)
50 
    worksheet.write(row, 9, 'SubtagId', boldStyle)
 52 
    worksheet.write(row, 11, 'SubtagId', boldStyle)
51 
    worksheet.write(row, 10, 'Ad Id', boldStyle)
 53 
    worksheet.write(row, 12, 'Ad Id', boldStyle)
52 
    worksheet.write(row, 11, 'Affiliate PayOut', boldStyle)
 54 
    worksheet.write(row, 13, 'Affiliate PayOut', boldStyle)
53 
    worksheet.write(row, 12, 'Affiliate Sale Amount', boldStyle)
 55 
    worksheet.write(row, 14, 'Affiliate Sale Amount', boldStyle)
54 
    worksheet.write(row, 13, 'Affiliate Sale Date', boldStyle)
 56 
    worksheet.write(row, 15, 'Affiliate Sale Date', boldStyle)
55
57
56 
    for row1 in curs:
 58 
    for row1 in curs:
57 
        orderId = row1[0]
 59 
        orderId = row1[0]
58 
        order = db.merchantOrder.find_one({"orderId":orderId})
 60 
        order = db.merchantOrder.find_one({"orderId":orderId})
59 
        if order is None:
 61 
        if order is None:
Line 65... Line 67...
65 
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
 67 
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
66 
 
 68 
 
67 
        for subOrder in order['subOrders']:
69 
        for subOrder in order['subOrders']:
68 
            row += 1
 70 
            row += 1
69 
            worksheet.write(row, 0, orderId)
 71 
            worksheet.write(row, 0, orderId)
- 
 
 72 
            worksheet.write(row, 1, row1[1])
70 
            worksheet.write(row, 1, order['merchantOrderId'])
 73 
            worksheet.write(row, 2, order['merchantOrderId'])
71 
            worksheet.write(row, 2, subOrder['productTitle'])
 74 
            worksheet.write(row, 3, subOrder['productTitle'])
72 
            worksheet.write(row, 3, subOrder['amountPaid'])
 75 
            worksheet.write(row, 4, subOrder['amountPaid'])
73 
            worksheet.write(row, 4, subOrder['quantity'])
 76 
            worksheet.write(row, 5, subOrder['quantity'])
74 
            worksheet.write(row, 5, subOrder['status'])
 77 
            worksheet.write(row, 6, subOrder['status'])
- 
 
 78 
            worksheet.write(row, 7, subOrder['detailedStatus'])
75 
            worksheet.write(row, 6, subOrder['cashBackStatus'])
 79 
            worksheet.write(row, 8, subOrder['cashBackStatus'])
76 
            worksheet.write(row, 7, subOrder['cashBackAmount'])
 80 
            worksheet.write(row, 9, subOrder['cashBackAmount'])
77 
            worksheet.write(row, 8, subOrder['placedOn'])
 81 
            worksheet.write(row, 10, subOrder['placedOn'])
78 
            worksheet.write(row, 9, order['subTagId'])
 82 
            worksheet.write(row, 11, order['subTagId'])
79 
            if len(aff)>0:
 83 
            if len(aff)>0:
80 
                worksheet.write(row, 10, aff[0]['adId'])
 84 
                worksheet.write(row, 12, aff[0]['adId'])
81 
                worksheet.write(row, 11, aff[0]['payOut'])
 85 
                worksheet.write(row, 13, aff[0]['payOut'])
82 
                worksheet.write(row, 12, aff[0]['saleAmount'])
 86 
                worksheet.write(row, 14, aff[0]['saleAmount'])
83 
                worksheet.write(row, 13, aff[0]['saleDate'])
 87 
                worksheet.write(row, 15, aff[0]['saleDate'])
84 
        workbook.save("snapdealreco.xls")
 88 
        workbook.save("snapdealreco.xls")
85
89
86 
def sendmail(email, message, title):
 90 
def sendmail(email, message, title):
87 
    if email == "":
 91 
    if email == "":
88 
        return
 92 
        return