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

     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)
-    for r in result:
+#     for r in result:
+#         row += 1
+#         column = 0
+#         for data in r :
+#             print data
+#             print type(data)
+#             if data.strip() =='2015/09/29':
+#                 worksheet.write(row,column)
+#             worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
+#             column += 1
+    d = datetime(2015, 3, 7)
+    i=1
+    a= datetime.today()
+    todayDate = a.strftime('%Y/%m/%d')
+    while(True):
         row += 1
         column = 0
+        predefinedDate = d+timedelta(days=i)
+        predefinedDate =  predefinedDate.strftime('%Y/%m/%d')
-        for data in r :
+        print predefinedDate
-            worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
+        worksheet.write(row, column, predefinedDate)
+        i=i+1
+        if todayDate==predefinedDate:
-            column += 1
+            break
     row = 0
     cursor.execute(dnruSql)
     result = cursor.fetchall()
     for r in result:
     populateSaholicMonthWiseMap1()
     generateDailyReport()
     generateWeeklyReport()
     generateMonthlyReport()
     sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com"], "", TMP_FILE, SUBJECT)
+    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
 def to_x_date(java_timestamp):
     try:
         date = datetime.fromtimestamp(java_timestamp / 1e3)
     except:

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/ActivityReport.py – Rev 17116 → 17125