WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/affiliatereco.py



        orderId = row1[0]
        order = db.merchantOrder.find_one({"orderId":orderId})
        if order is None:
            continue
        print order["subTagId"]
 
        saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))
 
        for subOrder in order['subOrders']:
            i=-1 

            worksheet.write(row, inc(), subOrder['detailedStatus'])
            worksheet.write(row, inc(), subOrder['cashBackStatus'])
            worksheet.write(row, inc(), subOrder['cashBackAmount'])
            worksheet.write(row, inc(), subOrder['placedOn'])
            worksheet.write(row, inc(), order['subTagId'])
            
            if len(aff) and saleTime -aff[0]['saleTime'] < 60 and saleTime -aff[0]['saleTime'] > 0:
                print saleTime -aff[0]['saleTime'] 
                worksheet.write(row, inc(), aff[0]['adId'])
                worksheet.write(row, inc(), aff[0]['payOut'])
                worksheet.write(row, inc(), aff[0]['saleAmount'])
                worksheet.write(row, inc(), aff[0]['saleDate'])

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/affiliatereco.py – Rev 14477 → 14478

Rev 14477		Rev 14478
Line 128...		Line 128...
128	`orderId = row1[0]`	128	`orderId = row1[0]`
129	`order = db.merchantOrder.find_one({"orderId":orderId})`	129	`order = db.merchantOrder.find_one({"orderId":orderId})`
130	`if order is None:`	130	`if order is None:`
131	`continue`	131	`continue`
132	`print order["subTagId"]`	132	`print order["subTagId"]`
133	`print order`	-
134	`saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))`	133	`saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))`
135	`aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))`	134	`aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))`
136		135
137	`for subOrder in order['subOrders']:`	136	`for subOrder in order['subOrders']:`
138	`i=-1`	137	`i=-1`
Line 148...		Line 147...
148	`worksheet.write(row, inc(), subOrder['detailedStatus'])`	147	`worksheet.write(row, inc(), subOrder['detailedStatus'])`
149	`worksheet.write(row, inc(), subOrder['cashBackStatus'])`	148	`worksheet.write(row, inc(), subOrder['cashBackStatus'])`
150	`worksheet.write(row, inc(), subOrder['cashBackAmount'])`	149	`worksheet.write(row, inc(), subOrder['cashBackAmount'])`
151	`worksheet.write(row, inc(), subOrder['placedOn'])`	150	`worksheet.write(row, inc(), subOrder['placedOn'])`
152	`worksheet.write(row, inc(), order['subTagId'])`	151	`worksheet.write(row, inc(), order['subTagId'])`
-		152
153	`if len(aff) and abs(saleTime-aff[0]['saleTime']) < 60:`	153	`if len(aff) and saleTime -aff[0]['saleTime'] < 60 and saleTime -aff[0]['saleTime'] > 0:`
154	`print saleTime -aff[0]['saleTime']`	154	`print saleTime -aff[0]['saleTime']`
155	`worksheet.write(row, inc(), aff[0]['adId'])`	155	`worksheet.write(row, inc(), aff[0]['adId'])`
156	`worksheet.write(row, inc(), aff[0]['payOut'])`	156	`worksheet.write(row, inc(), aff[0]['payOut'])`
157	`worksheet.write(row, inc(), aff[0]['saleAmount'])`	157	`worksheet.write(row, inc(), aff[0]['saleAmount'])`
158	`worksheet.write(row, inc(), aff[0]['saleDate'])`	158	`worksheet.write(row, inc(), aff[0]['saleDate'])`