Subversion Repositories SmartDukaan

    loginTime=0

    loginTime=0

    for r in result:

    for r in result:

        converted=r[0]

        converted=r[0]

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

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

    worksheet.write(25,1,totalVerifiedLinkSent-converted,center_alignment)

    worksheet.write(25,1,totalVerifiedLinkSent-converted,center_alignment)

    conn.close()

    conn.close()

    datesql=TOTAL_ACTIVATIONS

    datesql=TOTAL_ACTIVATIONS

    conn = getDbConnection()

    conn = getDbConnection()

                    agentId+=1

                    agentId+=1

                    continue    

                    continue    

                else:

                else:

                    for r in result:

                    for r in result:

                        row = dispositionMap.get(r[0])+26

                        row = dispositionMap.get(r[0])+26

                        if dispositionMap.get(r[0]) == 1 or dispositionMap.get(r[0]) == 2 or dispositionMap.get(r[0]) == 3 or dispositionMap.get(r[0]) == 4:

                        if dispositionMap.get(r[0]) == 1 or dispositionMap.get(r[0]) == 2 or dispositionMap.get(r[0]) == 3 or dispositionMap.get(r[0]) == 4:

                            nonContactableData+=int(r[1])

                            nonContactableData+=int(r[1])

                        else:

                        else:

                            contactableData+=r[1] 

                            contactableData+=r[1] 

                    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(25+22,columnId,r[0],center_alignment)

                        worksheet.write(25+22,columnId,r[0],center_alignment)

                    conn.close()

                    conn.close()

                agentId+=1

                agentId+=1

                columnId+=1

                columnId+=1

    workbook.save(TMP_FILE)    

    workbook.save(TMP_FILE)    

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

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

    generateAgentWiseFreshCallingReport()

    generateAgentWiseFreshCallingReport()

    generateFollowUpCallingReport()

    generateFollowUpCallingReport()

    generateAgentWiseFollowupCallingReport()

    generateAgentWiseFollowupCallingReport()

    generateOnBoardingCallingReport()

    generateOnBoardingCallingReport()

    generateAgentWiseOnboardingCallingReport()

    generateAgentWiseOnboardingCallingReport()

def sendmail(email, message, fileName, title):

def sendmail(email, message, fileName, title):

    if email == "":

    if email == "":

        return

        return

    mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)

    mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)

    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())

if __name__ == '__main__':

if __name__ == '__main__':

    main()

    main()