| Line 304... |
Line 304... |
| 304 |
worksheet.write(21,column, 'Average Call Duration (In Hrs)', style)
|
304 |
worksheet.write(21,column, 'Average Call Duration (In Hrs)', style)
|
| 305 |
worksheet.write(22,column, 'Average Handling Time (In Hrs)', style)
|
305 |
worksheet.write(22,column, 'Average Handling Time (In Hrs)', style)
|
| 306 |
worksheet.write(23,column, 'Average Idle Time (In Hrs)', style)
|
306 |
worksheet.write(23,column, 'Average Idle Time (In Hrs)', style)
|
| 307 |
worksheet.write(24,column, 'Links Converted', style)
|
307 |
worksheet.write(24,column, 'Links Converted', style)
|
| 308 |
worksheet.write(25,column, 'Link sent yet to be converted', style)
|
308 |
worksheet.write(25,column, 'Link sent yet to be converted', style)
|
| 309 |
worksheet.write(26,column, 'Total activations', style)
|
309 |
worksheet.write(26,column, 'Total activations(Links Converted + Followup)', style)
|
| 310 |
contactableData=0
|
310 |
contactableData=0
|
| 311 |
nonContactableData=0
|
311 |
nonContactableData=0
|
| 312 |
|
312 |
|
| 313 |
for r in result:
|
313 |
for r in result:
|
| 314 |
if dispositionMap.get(r[0]) == 9:
|
314 |
if dispositionMap.get(r[0]) == 9:
|
| Line 1220... |
Line 1220... |
| 1220 |
generateAgentWiseFreshCallingReport()
|
1220 |
generateAgentWiseFreshCallingReport()
|
| 1221 |
generateFollowUpCallingReport()
|
1221 |
generateFollowUpCallingReport()
|
| 1222 |
generateAgentWiseFollowupCallingReport()
|
1222 |
generateAgentWiseFollowupCallingReport()
|
| 1223 |
generateOnBoardingCallingReport()
|
1223 |
generateOnBoardingCallingReport()
|
| 1224 |
generateAgentWiseOnboardingCallingReport()
|
1224 |
generateAgentWiseOnboardingCallingReport()
|
| 1225 |
#sendmail(["amit.sirohi@shop2020.in","rajneesh.arora@saholic.com","ritesh.chauhan@shop2020.in", "shailesh.kumar@shop2020.in","utkarsh@coreoutsourcingservices.com","gupta.varun@coreoutsourcingservices.com","manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
1225 |
sendmail(["amit.sirohi@shop2020.in","rajneesh.arora@saholic.com","ritesh.chauhan@shop2020.in", "shailesh.kumar@shop2020.in","utkarsh@coreoutsourcingservices.com","gupta.varun@coreoutsourcingservices.com","manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
| 1226 |
sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
1226 |
#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
|
| 1227 |
|
1227 |
|
| 1228 |
|
1228 |
|
| 1229 |
|
1229 |
|
| 1230 |
def sendmail(email, message, fileName, title):
|
1230 |
def sendmail(email, message, fileName, title):
|
| 1231 |
if email == "":
|
1231 |
if email == "":
|
| Line 1237... |
Line 1237... |
| 1237 |
|
1237 |
|
| 1238 |
# Create the container (outer) email message.
|
1238 |
# Create the container (outer) email message.
|
| 1239 |
msg = MIMEMultipart()
|
1239 |
msg = MIMEMultipart()
|
| 1240 |
msg['Subject'] = title
|
1240 |
msg['Subject'] = title
|
| 1241 |
msg.preamble = title
|
1241 |
msg.preamble = title
|
| 1242 |
message="Total Activations :" + str(TotalActivations)
|
1242 |
message="Total Activations(Fresh + Followup) :" + str(TotalActivations)
|
| 1243 |
message1="Links Converted :" + str(Converted)
|
1243 |
message1="Links Converted(Fresh) :" + str(Converted)
|
| 1244 |
message2="Total Agents Logged In :" + str(AgentsLoggedIn)
|
1244 |
message2="Total Agents Logged In :" + str(AgentsLoggedIn)
|
| 1245 |
html_msg = MIMEText(message+"<br>"+message1+"<br>"+message2, 'html')
|
1245 |
html_msg = MIMEText(message+"<br>"+message1+"<br>"+message2, 'html')
|
| 1246 |
msg.attach(html_msg)
|
1246 |
msg.attach(html_msg)
|
| 1247 |
|
1247 |
|
| 1248 |
fileMsg = MIMEBase('application', 'vnd.ms-excel')
|
1248 |
fileMsg = MIMEBase('application', 'vnd.ms-excel')
|
| 1249 |
fileMsg.set_payload(file(TMP_FILE).read())
|
1249 |
fileMsg.set_payload(file(TMP_FILE).read())
|
| 1250 |
encoders.encode_base64(fileMsg)
|
1250 |
encoders.encode_base64(fileMsg)
|
| 1251 |
fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
|
1251 |
fileMsg.add_header('Content-Disposition', 'attachment;filename=' + fileName)
|
| 1252 |
msg.attach(fileMsg)
|
1252 |
msg.attach(fileMsg)
|
| 1253 |
|
1253 |
|
| 1254 |
#MAILTO = ['amit.sirohi@shop2020.in','rajneesh.arora@saholic.com', 'ritesh.chauhan@shop2020.in', 'shailesh.kumar@shop2020.in','gupta.varun@coreoutsourcingservices.com','utkarsh@coreoutsourcingservices.com','manas.kapoor@shop2020.in']
|
1254 |
MAILTO = ['amit.sirohi@shop2020.in','rajneesh.arora@saholic.com', 'ritesh.chauhan@shop2020.in', 'shailesh.kumar@shop2020.in','gupta.varun@coreoutsourcingservices.com','utkarsh@coreoutsourcingservices.com','manas.kapoor@shop2020.in']
|
| 1255 |
MAILTO = ['manas.kapoor@saholic.com']
|
1255 |
#MAILTO = ['manas.kapoor@saholic.com']
|
| 1256 |
mailServer.login(SENDER, PASSWORD)
|
1256 |
mailServer.login(SENDER, PASSWORD)
|
| 1257 |
mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
|
1257 |
mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())
|
| 1258 |
|
1258 |
|
| 1259 |
if __name__ == '__main__':
|
1259 |
if __name__ == '__main__':
|
| 1260 |
main()
|
1260 |
main()
|