Subversion Repositories SmartDukaan

Rev

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

Rev 14462 Rev 14469
Line 126... Line 126...
126 
        if order is None:
 126 
        if order is None:
127 
            continue
 127 
            continue
128 
        print order["subTagId"]
 128 
        print order["subTagId"]
129 
        print order
 129 
        print order
130 
        saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
 130 
        saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
131 
        saleTime1 = int(time.mktime((datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p") + timedelta(seconds=-60)).timetuple()))
 - 
 
132 
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
 131 
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
133 
 
 132 
 
134 
        for subOrder in order['subOrders']:
133 
        for subOrder in order['subOrders']:
135 
            row += 1
 134 
            row += 1
136 
            worksheet.write(row, 0, orderId)
 135 
            worksheet.write(row, 0, orderId)
Line 143... Line 142...
143 
            worksheet.write(row, 7, subOrder['detailedStatus'])
 142 
            worksheet.write(row, 7, subOrder['detailedStatus'])
144 
            worksheet.write(row, 8, subOrder['cashBackStatus'])
 143 
            worksheet.write(row, 8, subOrder['cashBackStatus'])
145 
            worksheet.write(row, 9, subOrder['cashBackAmount'])
 144 
            worksheet.write(row, 9, subOrder['cashBackAmount'])
146 
            worksheet.write(row, 10, subOrder['placedOn'])
 145 
            worksheet.write(row, 10, subOrder['placedOn'])
147 
            worksheet.write(row, 11, order['subTagId'])
 146 
            worksheet.write(row, 11, order['subTagId'])
148 
            if len(aff)>0:
 147 
            if len(aff) and abs(saleTime-aff[0]['saleTime']) < 60:
149 
                worksheet.write(row, 12, aff[0]['adId'])
 148 
                worksheet.write(row, 12, aff[0]['adId'])
150 
                worksheet.write(row, 13, aff[0]['payOut'])
 149 
                worksheet.write(row, 13, aff[0]['payOut'])
151 
                worksheet.write(row, 14, aff[0]['saleAmount'])
 150 
                worksheet.write(row, 14, aff[0]['saleAmount'])
152 
                worksheet.write(row, 15, aff[0]['saleDate'])
 151 
                worksheet.write(row, 15, aff[0]['saleDate'])
153 
        workbook.save(XLS_FILENAME)
 152 
        workbook.save(XLS_FILENAME)