WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/scripts/ActivityReport.py

 dateWiseSaholicOrderMap = {}
 weekWiseSaholicOrderMap = {}
 monthWiseSaholicOrderMap = {}
 orderIds = []
-cutOff = 1425839400
+cutOff = utils.toTimeStamp(date.today()-timedelta(days=90))
 #cutOff = 1425234600
 oneDay = 86400
 monthCutOff = 1425148200
 weekCutOff = 1425839400
 newWeekCutOff = 1425839400
     worksheet.write(row, 5, 'DTO', boldStyle)
     worksheet.write(row, 6, 'DVOL', boldStyle)
     worksheet.write(row, 7, 'DTV', boldStyle)
     worksheet.write(row, 8, 'DOWNVOL', boldStyle)
     worksheet.write(row, 9, 'DOWNVAL', boldStyle)
+    dateMap={}
     for r in result:
         row += 1
         column = 0
         for data in r :
             worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
+            dateMap[str(data)]=row
             column += 1
     row = 0
     cursor.execute(dnruSql)
     result = cursor.fetchall()
     row=0
     z=0
     for x in sorted(dateWiseOrderMap):
-        row += 1
         column = 6
-        d = str(datetime.fromtimestamp(x/1000.0))
+        d = datetime.fromtimestamp(x/1000.0)
+        row = dateMap[datetime.strftime(d,'%Y-%m-%d')]
-        dq=DQ_QUERY%d[:10]
+        dq=DQ_QUERY%str(d)[:10]
         cursor.execute(dq)
         result = cursor.fetchall()
         for r in result:
             quantity= r[0]
             if quantity is None:
         worksheet.write(row,column,(dateWiseOrderMap.get(x).count)+quantity)
         column += 1
     row =0
     for x in sorted(dateWiseOrderMap):
-        row += 1
         column = 7
-        d = str(datetime.fromtimestamp(x/1000.0))
+        d = datetime.fromtimestamp(x/1000.0)
+        row = dateMap[datetime.strftime(d, '%Y-%m-%d')]
-        dq=DV_QUERY%d[:10]
+        dq=DV_QUERY%str(d)[:10]
         cursor.execute(dq)
         result = cursor.fetchall()
         for r in result:
             quantity= r[0]
             if quantity is None:
                 quantity=0
         worksheet.write(row,column,(dateWiseOrderMap.get(x).value)+float(quantity))
-        column += 1
     #For Saholic
-    row=0
     cursor = conn.cursor()
     cursor.execute(datesql)
     result = cursor.fetchall()
     for x in sorted(dateWiseSaholicOrderMap):
-        row=0
-        for r in result:
+        z= to_x_date(x)
-            for data in r :
+        row = dateMap.get(z)
-                row += 1
+        if row:
-                z= to_x_date(x)
-                if str(data).strip() == str(z).strip():
-                    column = 8
+            column = 8
-                    worksheet.write(row,column,dateWiseSaholicOrderMap.get(x).count)
+            worksheet.write(row,column,dateWiseSaholicOrderMap.get(x).count)
-                    column += 1
     for x in sorted(dateWiseSaholicOrderMap):
-        row=0
-        for r in result:
+        z= to_x_date(x)
-            for data in r :
+        row=dateMap.get(z)
-                row += 1
+        if row:
-                z= to_x_date(x)
-                if str(data).strip() == str(z).strip():
-                    column = 9
+                column = 9
-                    worksheet.write(row,column,dateWiseSaholicOrderMap.get(x).value)
+                worksheet.write(row,column,dateWiseSaholicOrderMap.get(x).value)
-                    column += 1
 def generateMonthlyReport():
     monthSql = MONTH_QUERY
     mnruSql = MNRU_QUERY
     fileMsg.set_payload(file(TMP_FILE).read())
     encoders.encode_base64(fileMsg)
     fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
     msg.attach(fileMsg)
-    MAILTO = ['manas.kapoor@saholic.com','rajneesh.arora@saholic.com']
+    MAILTO = ['manas.kapoor@saholic.com','rajneesh.arora@saholic.com', 'amit.gupta@saholic.com']
-    #MAILTO = ['manas.kapoor@saholic.com']
+    #MAILTO = ['amit.gupta@saholic.com']
     mailServer.login(SENDER, PASSWORD)
     mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
 class __Order:
             return None
     return con
 def populateOrderMap():
     global dateWiseOrderMap
-    allOrders = get_mongo_connection().Dtr.merchantOrder.find({'createdOnInt':{"$gte":cutOff},'storeId':{"$in":[1,3,4,5,6]}}).sort([('createdOnInt',pymongo.ASCENDING)])
+    allOrders = get_mongo_connection().Dtr.merchantOrder.find({'createdOnInt':{"$gte":cutOff},'storeId':{"$in":[1,3,4,5,6]}}, {"orderId":1,"createdOnInt":1,"subOrders":1}).sort([('createdOnInt',pymongo.ASCENDING)])
     for orders in allOrders:
         if orders.get('orderId') not in order_ids:
             continue
         cdate = ((to_py_date(orders.get('createdOnInt') * 1000)))
         millisec = to_java_date(datetime(cdate.year, cdate.month, cdate.day))
     populateSaholicWeekWiseMap1()
     populateSaholicMonthWiseMap1()
     generateDailyReport()
     generateWeeklyReport()
     generateMonthlyReport()
-    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com"], "", TMP_FILE, SUBJECT)
+    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com", "amit.gupta@shop2020.in"], "", TMP_FILE, SUBJECT)
     #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
 def to_x_date(java_timestamp):
     try:
         date = datetime.fromtimestamp(java_timestamp / 1e3)

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/ActivityReport.py – Rev 17158 → 17171