Subversion Repositories SmartDukaan

Rev

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

Rev 14772 Rev 14805
Line 371... Line 371...
371
        for data in r :
371
        for data in r :
372
            worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
372
            worksheet.write(row, column, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)
373
            column += 1
373
            column += 1
374
 
374
 
375
    workbook.save(TMP_FILE)
375
    workbook.save(TMP_FILE)
376
    sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
376
    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com"], "", TMP_FILE, SUBJECT)
377
 
377
 
378
 
378
 
379
def generateWeeklyReport():
379
def generateWeeklyReport():
380
    weekSql = WEEK_QUERY
380
    weekSql = WEEK_QUERY
381
    wnruSql = WNRU_QUERY
381
    wnruSql = WNRU_QUERY
Line 489... Line 489...
489
    fileMsg = MIMEBase('application', 'vnd.ms-excel')
489
    fileMsg = MIMEBase('application', 'vnd.ms-excel')
490
    fileMsg.set_payload(file(TMP_FILE).read())
490
    fileMsg.set_payload(file(TMP_FILE).read())
491
    encoders.encode_base64(fileMsg)
491
    encoders.encode_base64(fileMsg)
492
    fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
492
    fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
493
    msg.attach(fileMsg)
493
    msg.attach(fileMsg)
494
 
494
    
495
    email.append('manas.kapoor@shop2020.in')
495
    MAILTO = ['manas.kapoor@saholic.com','rajneesh.arora@saholic.com']
496
    MAILTO = email 
-
 
497
    mailServer.login(SENDER, PASSWORD)
496
    mailServer.login(SENDER, PASSWORD)
498
    mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
497
    mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
499
 
498
 
500
def main():
499
def main():
501
    #date = raw_input('Enter a date name: ')
500
    #date = raw_input('Enter a date name: ')