Subversion Repositories SmartDukaan

Rev

Rev 17169 | Rev 17234 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 17169 Rev 17199
Line 53... Line 53...
53 
i = -1
 53 
i = -1
54 
 
 54 
 
55 
datetime_format = xlwt.XFStyle()
 55 
datetime_format = xlwt.XFStyle()
56 
datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'
 56 
datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'
57 
categoryMap = {3:"Mobiles", 5:"Tablets"}
 57 
categoryMap = {3:"Mobiles", 5:"Tablets"}
- 
 
 58 
 
- 
 
 59 
curDate = date.today()
- 
 
 60 
cutOffMonth = (datetime.now().month + 10)%12
- 
 
 61 
cutOffYear = curDate.year - (0 if curDate.month-2 > 0 else 1)
- 
 
 62 
cutOff = datetime(cutOffYear, cutOffMonth, 1)
- 
 
 63 
 
- 
 
 64 
 
58 
def generateFlipkartReco():
 65 
def generateFlipkartReco():
59 
    global i
 66 
    global i
60 
    i = -1
 67 
    i = -1
61 
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 2)
 68 
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 2)
62 
    db = client.Dtr
 69 
    db = client.Dtr
Line 854... Line 861...
854 
    sh1 = workbook.add_sheet("All Orders")
 861 
    sh1 = workbook.add_sheet("All Orders")
855 
    sh2 = workbook.add_sheet("Flipkart Orders")
 862 
    sh2 = workbook.add_sheet("Flipkart Orders")
856 
    worksheet = workbook.add_sheet("All Users")
 863 
    worksheet = workbook.add_sheet("All Users")
857
864
858 
    db=client.Dtr
 865 
    db=client.Dtr
859 
    prevDate = date.today() - timedelta(days=31)
 866 
    prevDate = cutOff
860 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
 867 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
861 
    row = 0
 868 
    row = 0
862 
    i=-1
 869 
    i=-1
863 
    worksheet.write(row, inc(), 'User Id', boldStyle)
 870 
    worksheet.write(row, inc(), 'User Id', boldStyle)
864 
    worksheet.write(row, inc(), 'User name', boldStyle)
 871 
    worksheet.write(row, inc(), 'User name', boldStyle)