Subversion Repositories SmartDukaan

Rev

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

Rev 15418 Rev 15437
Line 307... Line 307...
307 
    worksheet.write(26,column, 'Total activations', style)
 307 
    worksheet.write(26,column, 'Total activations', style)
308 
    contactableData=0
 308 
    contactableData=0
309 
    nonContactableData=0
 309 
    nonContactableData=0
310
310
311 
    for r in result:
 311 
    for r in result:
- 
 
 312 
        if dispositionMap.get(r[0]) == 9:
- 
 
 313 
            totalVerifiedLinkSent=int(r[1])
312 
        row = dispositionMap.get(r[0])+1
 314 
        row = dispositionMap.get(r[0])+1
313 
        if dispositionMap.get(r[0]) == 1 or dispositionMap.get(r[0]) == 2 or dispositionMap.get(r[0]) == 3 or dispositionMap.get(r[0]) == 4:
 315 
        if dispositionMap.get(r[0]) == 1 or dispositionMap.get(r[0]) == 2 or dispositionMap.get(r[0]) == 3 or dispositionMap.get(r[0]) == 4:
314 
            nonContactableData+=int(r[1])
 316 
            nonContactableData+=int(r[1])
315 
        else:
 317 
        else:
316 
            contactableData+=r[1]
318 
            contactableData+=r[1]
Line 407... Line 409...
407 
    cursor = conn.cursor()
 409 
    cursor = conn.cursor()
408 
    cursor.execute(datesql)
 410 
    cursor.execute(datesql)
409 
    result = cursor.fetchall()
 411 
    result = cursor.fetchall()
410 
    loginTime=0
 412 
    loginTime=0
411 
    for r in result:
 413 
    for r in result:
- 
 
 414 
        converted=r[0]
412 
        worksheet.write(24,1,r[0],center_alignment)
 415 
        worksheet.write(24,1,r[0],center_alignment)
- 
 
 416 
    worksheet.write(25,1,totalVerifiedLinkSent-converted,center_alignment)
413
417 
    totalVerifiedLinkSent
414 
    conn.close()
 418 
    conn.close()
415 
    datesql=FRESH_QUERY_LINKS_NOT_CONVERTED
 - 
 
416 
    conn = getDbConnection()
 - 
 
417
419
418 
    cursor = conn.cursor()
 - 
 
419 
    cursor.execute(datesql)
 - 
 
420 
    result = cursor.fetchall()
 - 
 
421 
    loginTime=0
 - 
 
422 
    for r in result:
 - 
 
423 
        worksheet.write(25,1,r[0],center_alignment)
 - 
 
424
- 
 
425 
    conn.close()
 - 
 
426 
    datesql=TOTAL_ACTIVATIONS
 420 
    datesql=TOTAL_ACTIVATIONS
427 
    conn = getDbConnection()
 421 
    conn = getDbConnection()
428
422
429 
    cursor = conn.cursor()
 423 
    cursor = conn.cursor()
430 
    cursor.execute(datesql)
 424 
    cursor.execute(datesql)
Line 1200... Line 1194...
1200 
    generateAgentWiseFreshCallingReport()
 1194 
    generateAgentWiseFreshCallingReport()
1201 
    generateFollowUpCallingReport()
 1195 
    generateFollowUpCallingReport()
1202 
    generateAgentWiseFollowupCallingReport()
 1196 
    generateAgentWiseFollowupCallingReport()
1203 
    generateOnBoardingCallingReport()
 1197 
    generateOnBoardingCallingReport()
1204 
    generateAgentWiseOnboardingCallingReport()
 1198 
    generateAgentWiseOnboardingCallingReport()
1205 
    sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
 1199 
    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
1206
1200
1207 
def sendmail(email, message, fileName, title):
 1201 
def sendmail(email, message, fileName, title):
1208 
    if email == "":
 1202 
    if email == "":
1209 
        return
 1203 
        return
1210 
    mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
 1204 
    mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)