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

     worksheet.write(row, 7, 'DTV', boldStyle)
     worksheet.write(row, 8, 'DOWNORD', boldStyle)
     worksheet.write(row, 9, 'DOWNVOL', boldStyle)
     worksheet.write(row, 10, 'DOWNVAL', boldStyle)
     worksheet.write(row, 11, 'DACCSU', boldStyle)
+    worksheet.write(row, 12, 'DACCSCART', boldStyle)
-    worksheet.write(row, 12, 'DACCSB', boldStyle)
+    worksheet.write(row, 13, 'DACCSB', boldStyle)
-    worksheet.write(row, 13, 'DACCSORD', boldStyle)
+    worksheet.write(row, 14, 'DACCSORD', boldStyle)
-    worksheet.write(row, 14, 'DACCSOVOL', boldStyle)
+    worksheet.write(row, 15, 'DACCSOVOL', boldStyle)
-    worksheet.write(row, 15, 'DACCSOVAL', boldStyle)
+    worksheet.write(row, 16, 'DACCSOVAL', boldStyle)
     dateMap={}
     for r in result:
         row += 1
         column = 0
         for data in r :
         worksheet.write(row, column, len(result))
         row=row+1
         if currentDay>breakDate:
             break
+    row = 1
+    column=12
+    breakDate = to_java_date(datetime.now())
+    currentDay = cutOff*1000
+    while True:
+        currentDay = currentDay + 86400000
+        result = get_mongo_connection_new().User.browsinghistories.find({"$and":[{'created':{"$gte":currentDay-86400000}},{'created':{"$lte":currentDay}},{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}]}).distinct('user_id')
+        worksheet.write(row, column, len(result))
+        row=row+1
+        if currentDay>breakDate:
+            break
     row = 0
     cursor.execute(daccsbSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 12
+        column = 13
         row=dateMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(daccstoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 13
+        column = 14
         row=dateMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(daccsoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 14
+        column = 15
         row=dateMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
             column += 1
             worksheet.write(row, column, r[2])
     worksheet.write(row, 7, 'MTV', boldStyle)
     worksheet.write(row, 8, 'MOWNORD', boldStyle)
     worksheet.write(row, 9, 'MOWNVOL', boldStyle)
     worksheet.write(row, 10, 'MOWNVAL', boldStyle)
     worksheet.write(row, 11, 'MACCSU', boldStyle)
+    worksheet.write(row, 12, 'MACCSCART', boldStyle)
-    worksheet.write(row, 12, 'MACCSB', boldStyle)
+    worksheet.write(row, 13, 'MACCSB', boldStyle)
-    worksheet.write(row, 13, 'MACCSORD', boldStyle)
+    worksheet.write(row, 14, 'MACCSORD', boldStyle)
-    worksheet.write(row, 14, 'MACCSOVOL', boldStyle)
+    worksheet.write(row, 15, 'MACCSOVOL', boldStyle)
-    worksheet.write(row, 15, 'MACCSOVAL', boldStyle)
+    worksheet.write(row, 16, 'MACCSOVAL', boldStyle)
     monthMapDb = {}
     for r in result:
         row += 1
         column = 0
         worksheet.write(row,column,len(result))
         row=row+1
         if currentDay>breakDate:
             break
+    row=1
+    column=12
+    breakDate = to_java_date(datetime.now())
+    currentDay = cutOff*1000
+    while True:
+        currentDay = currentDay + (monthMap.get(month_get(currentDay))*86400000)
+        result = get_mongo_connection_new().User.browsinghistories.find({"$and":[{'created':{"$gte":currentDay- (monthMap.get(month_get(currentDay))*86400000)}},{'created':{"$lte":currentDay}},{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}]}).distinct('user_id')
+        currentDay = currentDay+ 86400000
+        worksheet.write(row,column,len(result))
+        row=row+1
+        if currentDay>breakDate:
+            break
     row = 0
     cursor.execute(maccsbSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 12
+        column = 13
         row=monthMapDb.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(maccstoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 13
+        column = 14
         row=monthMapDb.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(maccsoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 14
+        column = 15
         row=monthMapDb.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
             column += 1
             worksheet.write(row, column, r[2])
     worksheet.write(row, 7, 'WTV', boldStyle)
     worksheet.write(row, 8, 'WOWNORD', boldStyle)
     worksheet.write(row, 9, 'WOWNVOL', boldStyle)
     worksheet.write(row, 10, 'WOWNVAL', boldStyle)
     worksheet.write(row, 11, 'WACCSU', boldStyle)
+    worksheet.write(row, 12, 'WACCSCART', boldStyle)
-    worksheet.write(row, 12, 'WACCSB', boldStyle)
+    worksheet.write(row, 13, 'WACCSB', boldStyle)
-    worksheet.write(row, 13, 'WACCSORD', boldStyle)
+    worksheet.write(row, 14, 'WACCSORD', boldStyle)
-    worksheet.write(row, 14, 'WACCSVOL', boldStyle)
+    worksheet.write(row, 15, 'WACCSVOL', boldStyle)
-    worksheet.write(row, 15, 'WACCSVAL', boldStyle)
+    worksheet.write(row, 16, 'WACCSVAL', boldStyle)
     weekMap={}
     for r in result:
         row += 1
         result = get_mongo_connection_new().User.browsinghistories.find({"$and":[{'created':{"$gte":currentDay-(6*86400000)}},{'created':{"$lte":currentDay}},{"url":{"$regex" : "http://api.profittill.com/category/6"}}]}).distinct('user_id')
         worksheet.write(row,column,len(result))
         row=row+1
         if currentDay>breakDate:
             break
+    row=1
+    column=12
+    breakDate = to_java_date(datetime.now())
+    currentDay = to_java_date(last_day(cutOffDate, 'sunday'))
+    while True:
+        currentDay = currentDay + (7*86400000)
+        result = get_mongo_connection_new().User.browsinghistories.find({"$and":[{'created':{"$gte":currentDay-(6*86400000)}},{'created':{"$lte":currentDay}},{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}]}).distinct('user_id')
+        worksheet.write(row,column,len(result))
+        row=row+1
+        if currentDay>breakDate:
+            break
     row = 0
     cursor.execute(waccsbSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 12
+        column = 13
         row=weekMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(waccstoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 13
+        column = 14
         row=weekMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
     row = 0
     cursor.execute(waccsoSql,(cutOffDate))
     result = cursor.fetchall()
     for r in result:
-        column = 14
+        column = 15
         row=weekMap.get(str(r[0]))
         if row:
             worksheet.write(row, column, r[1])
             column += 1
             worksheet.write(row, column, r[2])

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/ActivityReport.py – Rev 18162 → 18201