WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/crmoutbound.py

 datetime_format = xlwt.XFStyle()
 datetime_format.num_format_str = 'yyyy/mm/dd HH:MM AM/PM'
 default_format = xlwt.XFStyle()
 freshList=['1','2','3','4','5','6','7','8','9','10','11','12','13']
-followUpList=['1','2','3','4','5','6']
+followUpList=['1','2','3','4','5','6','7','8','9','10']
 onBoardingList=['1','2','3','4','5']
 dispositionMap = {  'call_later':0,
                     'ringing_no_answer':1,
                     'not_reachable':2,
                     'switch_off':3,
                     'not_reachable':2,
                     'switch_off':3,
                     'retailer_not_interested':4,
                     'alreadyuser':5,
                     'verified_link_sent':6,
+                    'accessory_retailer':7,
+                    'service_center_retailer':8,
+                    'not_retailer':9,
+                    'recharge_retailer':10
+                }
 onBoardingDispositionMap = {  'call_later':0,
                     'ringing_no_answer':1,
                     'not_reachable':2,
                     'switch_off':3,
     worksheet.write(3,column, 'Not Reachable', newStyle)
     worksheet.write(4,column, 'Switched Off', newStyle)
     worksheet.write(5,column, 'Retailer Not Interested', newStyle)
     worksheet.write(6,column, 'Already Profitmandi user', boldStyle)
     worksheet.write(7,column, 'Verified Link Sent', boldStyle)
+    worksheet.write(8,column, 'Accessory Retailer', newStyle)
+    worksheet.write(9,column, 'Service Center Retailer', newStyle)
+    worksheet.write(10,column, 'Not Retailer', boldStyle)
+    worksheet.write(11,column, 'Recharge Retailer', boldStyle)
-    worksheet.write(8,column, 'Contactable Data (%)', newStyle)
+    worksheet.write(12,column, 'Contactable Data (%)', newStyle)
-    worksheet.write(9,column, 'Non Contactable Data (%)', newStyle)
+    worksheet.write(13,column, 'Non Contactable Data (%)', newStyle)
-    worksheet.write(10,column, 'Agents Logged In', style)
+    worksheet.write(14,column, 'Agents Logged In', style)
-    worksheet.write(11,column, 'Average Login Time (In Hrs)', style)
+    worksheet.write(15,column, 'Average Login Time (In Hrs)', style)
-    worksheet.write(12,column, 'Total Dialed Out', style)
+    worksheet.write(16,column, 'Total Dialed Out', style)
-    worksheet.write(13,column, 'Average Dialed Out per agent', style)
+    worksheet.write(17,column, 'Average Dialed Out per agent', style)
-    worksheet.write(14,column, 'Average Call Duration (In Hrs)', style)
+    worksheet.write(18,column, 'Average Call Duration (In Hrs)', style)
-    worksheet.write(15,column, 'Average Handling Time (In Hrs)', style)
+    worksheet.write(19,column, 'Average Handling Time (In Hrs)', style)
-    worksheet.write(16,column, 'Average Idle Time (In Hrs)', style)
+    worksheet.write(20,column, 'Average Idle Time (In Hrs)', style)
     contactableData=0
     nonContactableData=0
     totalDispositions=0
         row = int(val)
         column = 1
         worksheet.write(row, column, 0,center_alignment)
     totalDispositions=contactableData+nonContactableData
-    worksheet.write(8,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
+    worksheet.write(12,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
-    worksheet.write(9,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
+    worksheet.write(13,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
     conn.close()
     datesql=FOLLOW_UP_QUERY_LOGIN_TIME
     conn = getDbConnection()
         loginTime+=r[1].seconds
         agentLoginList.append(str(r[0]))
     averageLoginTime=loginTime/len(list(set(agentLoginList)))
     hours=averageLoginTime/3600
     minutesLeft=(averageLoginTime%3600)/60
-    worksheet.write(10,1,len(list(set(agentLoginList))),center_alignment)
+    worksheet.write(14,1,len(list(set(agentLoginList))),center_alignment)
-    worksheet.write(11,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
+    worksheet.write(15,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
-    worksheet.write(12,1,totalDispositions,center_alignment)
+    worksheet.write(16,1,totalDispositions,center_alignment)
-    worksheet.write(13,1,(contactableData+nonContactableData)/len(list(set(agentLoginList))),center_alignment)
+    worksheet.write(17,1,(contactableData+nonContactableData)/len(list(set(agentLoginList))),center_alignment)
     conn.close()
     datesql=FOLLOW_UP_QUERY_DURATION
     conn = getDbConnection()
     cursor = conn.cursor()
     for r in result:
         totalCallDuration= r[0]
     averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
     hours=averageCallDuration/3600
     minutesLeft=(averageCallDuration%3600)/60
-    worksheet.write(14,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+    worksheet.write(18,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
     conn.close()
     datesql=FOLLOW_UP_QUERY_AHT
     conn = getDbConnection()
     cursor = conn.cursor()
     for r in result:
         loginTime+=r[0]
     averageLoginTime=loginTime/len(list(set(agentLoginList)))
     hours=averageLoginTime/3600
     minutesLeft=(averageLoginTime%3600)/60
-    worksheet.write(15,1,len(list(set(agentLoginList))),center_alignment)
+    worksheet.write(19,1,len(list(set(agentLoginList))),center_alignment)
     conn.close()
     datesql=FOLLOW_UP_QUERY_AIT
     conn = getDbConnection()
     cursor = conn.cursor()
     for r in result:
         loginTime+=r[0]
     averageLoginTime=loginTime/len(list(set(agentLoginList)))
     hours=averageLoginTime/3600
     minutesLeft=(averageLoginTime%3600)/60
-    worksheet.write(16,1,len(list(set(agentLoginList))),center_alignment)
+    worksheet.write(20,1,len(list(set(agentLoginList))),center_alignment)
     workbook.save(TMP_FILE)
 def generateAgentWiseFollowupCallingReport():
     agentId=3
     worksheet.write(row+3,column-1, 'Not Reachable', newStyle)
     worksheet.write(row+4,column-1, 'Switched Off', newStyle)
     worksheet.write(row+5,column-1, 'Retailer Not Interested', newStyle)
     worksheet.write(row+6,column-1, 'Already Profitmandi user', boldStyle)
     worksheet.write(row+7,column-1, 'Verified Link Sent', boldStyle)
+    worksheet.write(row+8,column-1, 'Accessory Retailer', newStyle)
+    worksheet.write(row+9,column-1, 'Service Center Retailer', newStyle)
+    worksheet.write(row+10,column-1, 'Not retailer', style)
+    worksheet.write(row+11,column-1, 'Recharge Retailer', style)
-    worksheet.write(row+8,column-1, 'Contactable Data (%)', newStyle)
+    worksheet.write(row+12,column-1, 'Contactable Data (%)', newStyle)
-    worksheet.write(row+9,column-1, 'Non Contactable Data (%)', newStyle)
+    worksheet.write(row+13,column-1, 'Non Contactable Data (%)', newStyle)
-    worksheet.write(row+10,column-1, 'Total Dialed Out', style)
+    worksheet.write(row+14,column-1, 'Total Dialed Out', style)
-    worksheet.write(row+11,column-1, 'Login Time (In Hrs)', style)
+    worksheet.write(row+15,column-1, 'Login Time (In Hrs)', style)
-    worksheet.write(row+12,column-1, 'Call Duration (In Hrs)', style)
+    worksheet.write(row+16,column-1, 'Call Duration (In Hrs)', style)
-    worksheet.write(row+13,column-1, 'Handling Time (In Hrs)', style)
+    worksheet.write(row+17,column-1, 'Handling Time (In Hrs)', style)
-    worksheet.write(row+14,column-1, 'Idle Time (In Hrs)', style)
+    worksheet.write(row+18,column-1, 'Idle Time (In Hrs)', style)
     columnId=agentId
     while True:
             if agentId >20 :
                 break
             else:
                     for i,val in enumerate(remainingList):
                         row = int(val)+25
                         column = agentId
                         worksheet.write(row, columnId, 0,center_alignment)
                     totalDialedOut = contactableData+nonContactableData
-                    worksheet.write(25+8,columnId,round((contactableData/float(totalDialedOut))*100,2),center_alignment)
+                    worksheet.write(25+12,columnId,round((contactableData/float(totalDialedOut))*100,2),center_alignment)
-                    worksheet.write(25+9,columnId,round((nonContactableData/float(totalDialedOut))*100,2),center_alignment)
+                    worksheet.write(25+13,columnId,round((nonContactableData/float(totalDialedOut))*100,2),center_alignment)
-                    worksheet.write(25+10,columnId,totalDialedOut,center_alignment)
+                    worksheet.write(25+14,columnId,totalDialedOut,center_alignment)
                     conn.close()
                     name_query=AGENT_NAME_QUERY %(agentId)
                     conn = getDbConnection()
                     column=agentId
                     for r in result:
                         loginTime+=r[0].seconds
                     hours=loginTime/3600
                     minutesLeft=(loginTime%3600)/60
-                    worksheet.write(25+11,columnId,str(hours)+':'+str(minutesLeft),center_alignment)
+                    worksheet.write(25+15,columnId,str(hours)+':'+str(minutesLeft),center_alignment)
                     conn.close()
                     name_query=AGENT_FOLLOW_UP_QUERY_DURATION %(agentId)
                     conn = getDbConnection()
                     column=agentId
                     loginTime=0
                     for r in result:
                         loginTime+=r[0]
                     hours=loginTime/3600
                     minutesLeft=(loginTime%3600)/60
-                    worksheet.write(25+12,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+                    worksheet.write(25+16,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
                     conn.close()
                     name_query=AGENT_FOLLOW_UP_QUERY_AHT %(agentId)
                     conn = getDbConnection()
                     column=agentId
                     loginTime=0
                     for r in result:
                         loginTime+=r[0]
                     hours=loginTime/3600
                     minutesLeft=(loginTime%3600)/60
-                    worksheet.write(25+13,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+                    worksheet.write(25+17,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
                     conn.close()
                     name_query=AGENT_FOLLOW_UP_QUERY_AIT %(agentId)
                     conn = getDbConnection()
                     column=agentId
                     loginTime=0
                     for r in result:
                         loginTime+=r[0]
                     hours=loginTime/3600
                     minutesLeft=(loginTime%3600)/60
-                    worksheet.write(25+14,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+                    worksheet.write(25+18,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
                     conn.close()
                 agentId+=1
                 columnId+=1
     workbook.save(TMP_FILE)

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15407 → 15409