Subversion Repositories SmartDukaan

    worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)

    worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)

    conn.close()

    conn.close()

    datesql=FRESH_QUERY_LINKS_CONVERTED

    datesql=FRESH_QUERY_LINKS_CONVERTED

    conn = getDbConnection()

    conn = getDbConnection()

    cursor = conn.cursor()

    cursor = conn.cursor()

    cursor.execute(datesql)

    cursor.execute(datesql)

    result = cursor.fetchall()

    result = cursor.fetchall()

    loginTime=0

    loginTime=0

    for r in result:

    for r in result:

        worksheet.write(24,1,r[0],center_alignment)

        worksheet.write(24,1,r[0],center_alignment)

    conn.close()

    conn.close()

    datesql=TOTAL_ACTIVATIONS

    datesql=TOTAL_ACTIVATIONS

    conn = getDbConnection()

    conn = getDbConnection()

    cursor = conn.cursor()

    cursor = conn.cursor()

    cursor.execute(datesql)

    cursor.execute(datesql)

    result = cursor.fetchall()

    result = cursor.fetchall()

    loginTime=0

    loginTime=0

    for r in result:

    for r in result:

        worksheet.write(26,1,r[0],center_alignment)    

        worksheet.write(26,1,r[0],center_alignment)    

    workbook.save(TMP_FILE)

    workbook.save(TMP_FILE)

    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)        

    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)        

    # Create the container (outer) email message.

    # Create the container (outer) email message.

    msg = MIMEMultipart()

    msg = MIMEMultipart()

    msg['Subject'] = title

    msg['Subject'] = title

    msg.preamble = title

    msg.preamble = title

    msg.attach(html_msg)

    msg.attach(html_msg)

    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)