Subversion Repositories SmartDukaan

        for data in r :

        for data in r :

            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, int(data) if type(data) is float else data, date_format if type(data) is date else default_format)

            column += 1

            column += 1

    workbook.save(TMP_FILE)

    workbook.save(TMP_FILE)

def generateWeeklyReport():

def generateWeeklyReport():

    weekSql = WEEK_QUERY

    weekSql = WEEK_QUERY

    wnruSql = WNRU_QUERY

    wnruSql = WNRU_QUERY

    fileMsg = MIMEBase('application', 'vnd.ms-excel')

    fileMsg = MIMEBase('application', 'vnd.ms-excel')

    fileMsg.set_payload(file(TMP_FILE).read())

    fileMsg.set_payload(file(TMP_FILE).read())

    encoders.encode_base64(fileMsg)

    encoders.encode_base64(fileMsg)

    fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)

    fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)

    msg.attach(fileMsg)

    msg.attach(fileMsg)

    mailServer.login(SENDER, PASSWORD)

    mailServer.login(SENDER, PASSWORD)

    mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())

    mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())

def main():

def main():

    #date = raw_input('Enter a date name: ')

    #date = raw_input('Enter a date name: ')