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

     wb.save(XLS_F_FILENAME)
 def generateSnapDealReco():
     global i
     curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 3)
     db = client.Dtr
-    notReconciled = {}
     matchedList = []
     workbook = xlwt.Workbook()
     worksheet = workbook.add_sheet("Snapdeal Reconciled")
-    worksheet1 = workbook.add_sheet("Snapdeal Reconciled All")
     worksheet2 = workbook.add_sheet("Snapdeal Orders not reconciled")
-    worksheet3 = workbook.add_sheet("DateWise Sale Summary")
     affNotReconciledSheet = workbook.add_sheet("Snapdeal Aff not reconciled")
+    worksheet3 = workbook.add_sheet("DateWise Sale Summary")
+    worksheet1 = workbook.add_sheet("Snapdeal Reconciled All")
     setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet, worksheet3)
     row = 0
-    anotherrow = 0
     row5=0
     for row1 in curs:
         orderId = row1[0]
         order = db.merchantOrder.find_one({"orderId":orderId})
         if order is None:
         except:
             timestamp1 = int(time.mktime(row1[-4].timetuple()))
             formattedTimestamp = datetime.strftime(utils.fromTimeStamp(timestamp1), "%b %d, %Y, %I:%M %p")
         affs = list(db.snapdealOrderAffiliateInfo1.find({"orderId":order["merchantOrderId"]}))
-        anotherrow += 1
         if len(affs) > 0:
+            for aff in affs:
+                if aff.get("missingOrder"):
+                    aff["missingOrder"] = False
+                    db.snapdealOrderAffiliateInfo1.save(aff)
             matchedList.append(order["merchantOrderId"])
             order['reconciled'] = True
             db.merchantOrder.save(order)
             row += 1
             i=-1
             worksheet.write(row, inc(), order['placedOn'])
             worksheet.write(row, inc(), formattedTimestamp)
             worksheet.write(row, inc(), int(order['paidAmount']))
             k = i
             row -= 1
-            anotherrow -= 1
             for subOrder in order['subOrders']:
                 i = k
+                matched=False
                 row += 1
-                anotherrow += 1
                 for aff in affs:
-                    if subOrder['title']==aff['productCode']:
+                    if subOrder['productTitle']==aff['productCode']:
-                        worksheet.write(row, inc(), aff[0]['saleDate'])
+                        worksheet.write(row, inc(), utils.fromTimeStamp(aff['saleDate']),datetime_format)
-                        worksheet.write(row, inc(), aff[0]['saleAmount'])
+                        worksheet.write(row, inc(), aff['unitPrice'])
-                        worksheet.write(row, inc(), aff[0]['payOut'])
+                        worksheet.write(row, inc(), 0 if not aff.get('payOut') else aff['payOut']/aff.get('quantity'))
+                        matched=True
+                        break
+                if not matched:
+                    inc()
+                    inc()
+                    inc()
-                        worksheet.write(row, inc(), subOrder['productTitle'])
+                worksheet.write(row, inc(), subOrder['productTitle'])
-                        worksheet.write(row, inc(), subOrder['amountPaid'])
+                worksheet.write(row, inc(), subOrder['amountPaid'])
-                        worksheet.write(row, inc(), subOrder['quantity'])
+                worksheet.write(row, inc(), subOrder['quantity'])
-                        worksheet.write(row, inc(), subOrder['status'])
+                worksheet.write(row, inc(), subOrder['status'])
-                        worksheet.write(row, inc(), subOrder['cashBackStatus'])
+                worksheet.write(row, inc(), subOrder['cashBackStatus'])
-                        worksheet.write(row, inc(), subOrder['cashBackAmount'])
+                worksheet.write(row, inc(), subOrder['cashBackAmount'])
         else:
             row5 += 1
             i=-1
             worksheet2.write(row5, inc(), order["orderId"])
                 worksheet2.write(row5, inc(), subOrder['cashBackAmount'])
     last30Days =  date.today() - timedelta(days=30)
     int(time.mktime(last30Days.timetuple()))
     row = 0
-    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
+    for offer in db.snapdealOrderAffiliateInfo1.find({"missingOrder":True,
-                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
-                                                                 "$lt":int(time.mktime(date.today().timetuple()))}}, timeout=False ):
-        subTagId = offer.get("subTagId")
-        saleTime = offer.get("saleTime")
-        orders = getOrdersByTag(subTagId, 3)
-        for order in orders:
-            if notReconciled.has_key(order[0]):
-                (roww, column, paidAmount, timestamp1, oSubTagId) = notReconciled[order[0]]
-                if paidAmount==int(offer.get("saleAmount")) and timestamp1 <= saleTime and timestamp1 + 120 >= saleTime:
-                    i = column
-                    worksheet1.write(roww, inc(), offer.get("saleDate"))
-                    worksheet1.write(roww, inc(), offer.get("saleAmount"))
-                    worksheet1.write(roww, inc(), offer.get("payOut"))
-                    del notReconciled[order[0]]
-                    print "found match for user", order[1]
-                    db.snapdealOrderAffiliateInfo.update({"adId":offer.get("adId")}, {"$set":{"reconciled":True, "orderId":order[0]}}, multi=True)
-                    db.merchantOrder.update({"orderId":order[0]}, {"$set":{"reconciled":True, "adId":offer.get("adId")}}, multi=True)
-                    break
-    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
-                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
+                                                     "saleDate":{"$gte":int(time.mktime(last30Days.timetuple())),
                                                                  "$lt":int(time.mktime(date.today().timetuple()))}} ):
         row += 1
         i=-1
-        affNotReconciledSheet.write(row, inc(), offer.get("adId"))
         affNotReconciledSheet.write(row, inc(), offer.get("subTagId"))
-        affNotReconciledSheet.write(row, inc(), offer.get("saleDate"))
+        affNotReconciledSheet.write(row, inc(), offer.get("orderId"))
+        affNotReconciledSheet.write(row, inc(), utils.fromTimeStamp(offer.get("saleDate")), datetime_format)
         affNotReconciledSheet.write(row, inc(), offer.get("saleAmount"))
+        affNotReconciledSheet.write(row, inc(), offer.get("productCode"))
+        affNotReconciledSheet.write(row, inc(), offer.get("quantity"))
         affNotReconciledSheet.write(row, inc(), offer.get("payOut"))
-        affNotReconciledSheet.write(row, inc(), offer.get("conversionStatus"))
-        affNotReconciledSheet.write(row, inc(), offer.get("ip"))
     mailBodyTemplate="""
         <html>
             <body>
             <table cellspacing="0" border="1" style="text-align:right">
     worksheet.write(row, inc(), 'Dtr Sale Date', boldStyle)
     worksheet.write(row, inc(), 'Sale Amount', boldStyle)
     worksheet.write(row, inc(), 'Aff Sale Date', boldStyle)
     worksheet.write(row, inc(), 'Aff Sale Amt', boldStyle)
     worksheet.write(row, inc(), 'Aff PayOut', boldStyle)
-    worksheet.write(row, inc(), 'IP', boldStyle)
-    worksheet.write(row, inc(), 'Aff Status', boldStyle)
     worksheet.write(row, inc(), 'Product Title', boldStyle)
     worksheet.write(row, inc(), 'Price', boldStyle)
     worksheet.write(row, inc(), 'Quantity', boldStyle)
     worksheet.write(row, inc(), 'Status', boldStyle)
     worksheet.write(row, inc(), 'Cashback Status', boldStyle)
     worksheet.write(row, inc(), 'CashBack', boldStyle)
-    i = -1
-    worksheet1.write(row, inc(), 'Order Id', boldStyle)
-    worksheet1.write(row, inc(), 'User Id', boldStyle)
-    worksheet1.write(row, inc(), 'Username', boldStyle)
-    worksheet1.write(row, inc(), 'Version Code', boldStyle)
-    worksheet1.write(row, inc(), 'Device', boldStyle)
-    worksheet1.write(row, inc(), 'Merchant Order Id', boldStyle)
-    worksheet1.write(row, inc(), 'SubtagId', boldStyle)
-    worksheet1.write(row, inc(), 'Sale Date', boldStyle)
-    worksheet1.write(row, inc(), 'Dtr Sale Date', boldStyle)
-    worksheet1.write(row, inc(), 'Sale Amount', boldStyle)
-    worksheet1.write(row, inc(), 'Aff Sale Date', boldStyle)
-    worksheet1.write(row, inc(), 'Aff Sale Amt', boldStyle)
-    worksheet1.write(row, inc(), 'Aff PayOut', boldStyle)
-    worksheet1.write(row, inc(), 'IP', boldStyle)
-    worksheet1.write(row, inc(), 'Aff Status', boldStyle)
-    worksheet1.write(row, inc(), 'Product Title', boldStyle)
-    worksheet1.write(row, inc(), 'Price', boldStyle)
-    worksheet1.write(row, inc(), 'Quantity', boldStyle)
-    worksheet1.write(row, inc(), 'Status', boldStyle)
-    worksheet1.write(row, inc(), 'Cashback Status', boldStyle)
-    worksheet1.write(row, inc(), 'CashBack', boldStyle)
     i = -1
     worksheet2.write(row, inc(), 'Order Id', boldStyle)
     worksheet2.write(row, inc(), 'User Id', boldStyle)
     worksheet2.write(row, inc(), 'Username', boldStyle)
     worksheet2.write(row, inc(), 'Status', boldStyle)
     worksheet2.write(row, inc(), 'Cashback Status', boldStyle)
     worksheet2.write(row, inc(), 'CashBack', boldStyle)
     i =-1
-    affNotReconciledSheet.write(row, inc(), 'AdId', boldStyle)
+    affNotReconciledSheet.write(row, inc(), 'Sub Tag Id', boldStyle)
-    affNotReconciledSheet.write(row, inc(), 'subTagId', boldStyle)
+    affNotReconciledSheet.write(row, inc(), 'Order Id', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'Sale Date', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'Sale Amount', boldStyle)
+    affNotReconciledSheet.write(row, inc(), 'Product', boldStyle)
+    affNotReconciledSheet.write(row, inc(), 'Quantity', boldStyle)
     affNotReconciledSheet.write(row, inc(), 'Pay Out', boldStyle)
-    affNotReconciledSheet.write(row, inc(), 'Status', boldStyle)
-    affNotReconciledSheet.write(row, inc(), 'IP', boldStyle)
     if worksheet3:
         i =-1
         worksheet3.write(row, inc(), 'Date', boldStyle)
         worksheet3.write(row, inc(), 'Sale Amount', boldStyle)
     global i
     i = 0
     sheet.write(0, inc(), )
 def main():
     message = generateSnapDealReco()
-    generateFlipkartReco()
+    #generateFlipkartReco()
-    generateShopcluesReco()
+    #generateShopcluesReco()
-    generateAmazonReco(XLS_A_FILENAME)
+    #generateAmazonReco(XLS_A_FILENAME)
-    message1 = getdata.summaryByBrandAndStore()
+    #message1 = getdata.summaryByBrandAndStore()
-    getUserOrders()
+    #getUserOrders()
-    #getdata.sendmail(["naman.kumar@shop2020.in"], message1, "Summary by brand and store")
+    sendmail(["amit.gupta@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME)
-    #sendmail(["naman.kumar@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
     #sendmail(["naman.kumar@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
-    sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "manish.sharma@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
+    #sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "manish.sharma@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
-    sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com","manish.sharma@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
+    #sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com","manish.sharma@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
     #sendmail(["amit.gupta@shop2020.in"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
 def main3():
     db = client.Dtr
     #main()
     for key,valmap in  datemap.iteritems():
         valmap['_id'] = key
         db.flSaleSnapshot.save(valmap)
 if __name__ == '__main__':
-    getdata.addToAllOrders(date.today()-timedelta(days=30))
+    #getdata.addToAllOrders(date.today()-timedelta(days=30))
-    main2()
+    #main2()
     main()

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/affiliatereco.py – Rev 17167 → 17168