| Line 1057... |
Line 1057... |
| 1057 |
totalCallDuration= r[0]
|
1057 |
totalCallDuration= r[0]
|
| 1058 |
averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
|
1058 |
averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
|
| 1059 |
hours=averageCallDuration/3600
|
1059 |
hours=averageCallDuration/3600
|
| 1060 |
minutesLeft=(averageCallDuration%3600)/60
|
1060 |
minutesLeft=(averageCallDuration%3600)/60
|
| 1061 |
worksheet.write(14,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
|
1061 |
worksheet.write(14,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
|
| 1062 |
workbook.save(TMP_FILE)
|
1062 |
workbook.save(TMP_FILE)
|
| 1063 |
|
1063 |
|
| 1064 |
#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
1064 |
#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
| 1065 |
|
1065 |
|
| 1066 |
|
1066 |
|
| 1067 |
def generateAgentWiseOnboardingCallingReport():
|
1067 |
def generateAgentWiseOnboardingCallingReport():
|
| Line 1117... |
Line 1117... |
| 1117 |
nonContactableData=0
|
1117 |
nonContactableData=0
|
| 1118 |
if cursor.rowcount ==0:
|
1118 |
if cursor.rowcount ==0:
|
| 1119 |
agentId+=1
|
1119 |
agentId+=1
|
| 1120 |
continue
|
1120 |
continue
|
| 1121 |
else:
|
1121 |
else:
|
| 1122 |
|
- |
|
| 1123 |
for r in result:
|
1122 |
for r in result:
|
| 1124 |
row = onBoardingDispositionMap.get(r[0])+26
|
1123 |
row = onBoardingDispositionMap.get(r[0])+26
|
| 1125 |
if onBoardingDispositionMap.get(r[0]) == 1 or onBoardingDispositionMap.get(r[0]) == 2 or onBoardingDispositionMap.get(r[0]) == 3 or followUpDispositionMap.get(r[0]) == 4:
|
1124 |
if onBoardingDispositionMap.get(r[0]) == 1 or onBoardingDispositionMap.get(r[0]) == 2 or onBoardingDispositionMap.get(r[0]) == 3 or followUpDispositionMap.get(r[0]) == 4:
|
| 1126 |
nonContactableData+=int(r[1])
|
1125 |
nonContactableData+=int(r[1])
|
| 1127 |
else:
|
1126 |
else:
|
| Line 1220... |
Line 1219... |
| 1220 |
generateAgentWiseFreshCallingReport()
|
1219 |
generateAgentWiseFreshCallingReport()
|
| 1221 |
generateFollowUpCallingReport()
|
1220 |
generateFollowUpCallingReport()
|
| 1222 |
generateAgentWiseFollowupCallingReport()
|
1221 |
generateAgentWiseFollowupCallingReport()
|
| 1223 |
generateOnBoardingCallingReport()
|
1222 |
generateOnBoardingCallingReport()
|
| 1224 |
generateAgentWiseOnboardingCallingReport()
|
1223 |
generateAgentWiseOnboardingCallingReport()
|
| 1225 |
sendmail(["manas.kapoor@shop2020.in","amit.sirohi@shop2020.in","rajneesh.arora@saholic.com","ritesh.chauhan@shop2020.in", "shailesh.kumar@shop2020.in"], "", TMP_FILE, SUBJECT)
|
1224 |
#sendmail(["manas.kapoor@shop2020.in","amit.sirohi@shop2020.in","rajneesh.arora@saholic.com","ritesh.chauhan@shop2020.in", "shailesh.kumar@shop2020.in"], "", TMP_FILE, SUBJECT)
|
| 1226 |
#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
1225 |
sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
| 1227 |
|
1226 |
|
| 1228 |
def sendmail(email, message, fileName, title):
|
1227 |
def sendmail(email, message, fileName, title):
|
| 1229 |
if email == "":
|
1228 |
if email == "":
|
| 1230 |
return
|
1229 |
return
|
| 1231 |
mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
|
1230 |
mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
|
| Line 1247... |
Line 1246... |
| 1247 |
fileMsg.set_payload(file(TMP_FILE).read())
|
1246 |
fileMsg.set_payload(file(TMP_FILE).read())
|
| 1248 |
encoders.encode_base64(fileMsg)
|
1247 |
encoders.encode_base64(fileMsg)
|
| 1249 |
fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
|
1248 |
fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
|
| 1250 |
msg.attach(fileMsg)
|
1249 |
msg.attach(fileMsg)
|
| 1251 |
|
1250 |
|
| 1252 |
MAILTO = ['manas.kapoor@saholic.com','amit.sirohi@shop2020.in','rajneesh.arora@saholic.com', 'ritesh.chauhan@shop2020.in', 'shailesh.kumar@shop2020.in']
|
1251 |
#MAILTO = ['manas.kapoor@saholic.com','amit.sirohi@shop2020.in','rajneesh.arora@saholic.com', 'ritesh.chauhan@shop2020.in', 'shailesh.kumar@shop2020.in']
|
| 1253 |
#MAILTO = ['manas.kapoor@saholic.com']
|
1252 |
MAILTO = ['manas.kapoor@saholic.com']
|
| 1254 |
mailServer.login(SENDER, PASSWORD)
|
1253 |
mailServer.login(SENDER, PASSWORD)
|
| 1255 |
mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
|
1254 |
mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
|
| 1256 |
|
1255 |
|
| 1257 |
if __name__ == '__main__':
|
1256 |
if __name__ == '__main__':
|
| 1258 |
main()
|
1257 |
main()
|