Subversion Repositories SmartDukaan

Rev

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

Rev 17116 Rev 17125
Line 331... Line 331...
331
    worksheet.write(row, 5, 'DTO', boldStyle)
331
    worksheet.write(row, 5, 'DTO', boldStyle)
332
    worksheet.write(row, 6, 'DVOL', boldStyle)   
332
    worksheet.write(row, 6, 'DVOL', boldStyle)   
333
    worksheet.write(row, 7, 'DTV', boldStyle)
333
    worksheet.write(row, 7, 'DTV', boldStyle)
334
    worksheet.write(row, 8, 'DOWNVOL', boldStyle)
334
    worksheet.write(row, 8, 'DOWNVOL', boldStyle)
335
    worksheet.write(row, 9, 'DOWNVAL', boldStyle)
335
    worksheet.write(row, 9, 'DOWNVAL', boldStyle)
336
    for r in result:
336
#     for r in result:
-
 
337
#         row += 1
-
 
338
#         column = 0
-
 
339
#         for data in r :
-
 
340
#             print data
-
 
341
#             print type(data)
-
 
342
#             if data.strip() =='2015/09/29':
-
 
343
#                 worksheet.write(row,column)
-
 
344
#             worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
-
 
345
#             column += 1
-
 
346
 
-
 
347
    d = datetime(2015, 3, 7)
-
 
348
    i=1 
-
 
349
    a= datetime.today()
-
 
350
    todayDate = a.strftime('%Y/%m/%d')    
-
 
351
    while(True):
337
        row += 1
352
        row += 1
338
        column = 0
353
        column = 0
-
 
354
        predefinedDate = d+timedelta(days=i)
-
 
355
        predefinedDate =  predefinedDate.strftime('%Y/%m/%d')
339
        for data in r :
356
        print predefinedDate
340
            worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
357
        worksheet.write(row, column, predefinedDate)
-
 
358
        i=i+1
-
 
359
        if todayDate==predefinedDate:
341
            column += 1
360
            break
342
 
361
 
343
    row = 0
362
    row = 0
344
    cursor.execute(dnruSql)
363
    cursor.execute(dnruSql)
345
    result = cursor.fetchall()
364
    result = cursor.fetchall()
346
    for r in result:
365
    for r in result:
Line 1006... Line 1025...
1006
    populateSaholicMonthWiseMap1()
1025
    populateSaholicMonthWiseMap1()
1007
    generateDailyReport()
1026
    generateDailyReport()
1008
    generateWeeklyReport()
1027
    generateWeeklyReport()
1009
    generateMonthlyReport()
1028
    generateMonthlyReport()
1010
    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com"], "", TMP_FILE, SUBJECT)
1029
    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com"], "", TMP_FILE, SUBJECT)
-
 
1030
    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
1011
    
1031
    
1012
def to_x_date(java_timestamp):
1032
def to_x_date(java_timestamp):
1013
    try:
1033
    try:
1014
        date = datetime.fromtimestamp(java_timestamp / 1e3)       
1034
        date = datetime.fromtimestamp(java_timestamp / 1e3)       
1015
    except:
1035
    except: