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

                     loginTime=0
                     for r in result:
                         #worksheet.write(25+22,columnId,r[0],center_alignment)
                         converted=r[0]
                         worksheet.write(25+22,columnId,r[0],center_alignment)
+                    if totalVerifiedLinkSent==0:
+                        worksheet.write(25+23,columnId,0,center_alignment)
+                    else:
-                    worksheet.write(25+23,columnId,totalVerifiedLinkSent-converted,center_alignment)
+                        worksheet.write(25+23,columnId,totalVerifiedLinkSent-converted,center_alignment)
                     conn.close()
 #                     datesql=AGENT_FRESH_QUERY_LINKS_NOT_CONVERTED%(agentId)
 #                     conn = getDbConnection()
+#
 #                     cursor = conn.cursor()
     boldStyle.font = f
     column = 0
     row = 0
     currentList=[]
+    if len(result)==0:
-    worksheet.write(0,0,'Call Disposition Type',style)
+        print 'No Data'
-    worksheet.write(0,1,'Count',style)
+        pass
-    worksheet.write(1, column, 'Call Later', newStyle)
+    else:
-    worksheet.write(2,column, 'Ringing No Answer', newStyle)
+        worksheet.write(0,0,'Call Disposition Type',style)
-    worksheet.write(3,column, 'Not Reachable', newStyle)
+        worksheet.write(0,1,'Count',style)
-    worksheet.write(4,column, 'Switched Off', newStyle)
+        worksheet.write(1, column, 'Call Later', newStyle)
-    worksheet.write(5,column, 'Successful', newStyle)
+        worksheet.write(2,column, 'Ringing No Answer', newStyle)
-    worksheet.write(6,column, 'Contactable Data', newStyle)
+        worksheet.write(3,column, 'Not Reachable', newStyle)
-    worksheet.write(7,column, 'Non Contactable Data', newStyle)
+        worksheet.write(4,column, 'Switched Off', newStyle)
-    worksheet.write(8,column, 'Agents Logged In', style)
+        worksheet.write(5,column, 'Successful', newStyle)
-    worksheet.write(9,column, 'Average Login Time (In Hrs)', style)
+        worksheet.write(6,column, 'Contactable Data', newStyle)
-    worksheet.write(10,column, 'Total Dialed Out', style)
+        worksheet.write(7,column, 'Non Contactable Data', newStyle)
-    worksheet.write(11,column, 'Average Dialed Out per agent', style)
+        worksheet.write(8,column, 'Agents Logged In', style)
-    worksheet.write(12,column, 'Average Call Duration (In Hrs)', style)
+        worksheet.write(9,column, 'Average Login Time (In Hrs)', style)
-    worksheet.write(13,column, 'Average Handling Time (In Hrs)', style)
+        worksheet.write(10,column, 'Total Dialed Out', style)
-    worksheet.write(14,column, 'Average Idle Time (In Hrs)', style)
+        worksheet.write(11,column, 'Average Dialed Out per agent', style)
+        worksheet.write(12,column, 'Average Call Duration (In Hrs)', style)
-    contactableData=0
+        worksheet.write(13,column, 'Average Handling Time (In Hrs)', style)
-    nonContactableData=0
+        worksheet.write(14,column, 'Average Idle Time (In Hrs)', style)
-    totalDispositions=0
-    for r in result:
+        contactableData=0
-        row = onBoardingDispositionMap.get(r[0])+1
+        nonContactableData=0
-        if onBoardingDispositionMap.get(r[0]) == 1 or onBoardingDispositionMap.get(r[0]) == 2 or onBoardingDispositionMap.get(r[0]) == 3:
+        totalDispositions=0
-            nonContactableData+=int(r[1])
+        for r in result:
-        else:
+            row = onBoardingDispositionMap.get(r[0])+1
-            contactableData+=r[1]
+            if onBoardingDispositionMap.get(r[0]) == 1 or onBoardingDispositionMap.get(r[0]) == 2 or onBoardingDispositionMap.get(r[0]) == 3:
-        currentList.append(str(row))
+                nonContactableData+=int(r[1])
-        column = 1
+            else:
-        worksheet.write(row, column, r[1],center_alignment)
+                contactableData+=r[1]
+            currentList.append(str(row))
-    remainingList = list(set(onBoardingList) - set(currentList))
+            column = 1
+            worksheet.write(row, column, r[1],center_alignment)
-    for i,val in enumerate(remainingList):
-        row = int(val)
+        remainingList = list(set(onBoardingList) - set(currentList))
-        column = 1
-        worksheet.write(row, column, 0,center_alignment)
+        for i,val in enumerate(remainingList):
-    totalDispositions=contactableData+nonContactableData
+            row = int(val)
-    worksheet.write(6,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
+            column = 1
-    worksheet.write(7,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
+            worksheet.write(row, column, 0,center_alignment)
+        totalDispositions=contactableData+nonContactableData
+        worksheet.write(6,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
-    conn.close()
+        worksheet.write(7,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
-    datesql=ONBOARDING_QUERY_LOGIN_TIME
-    conn = getDbConnection()
+        conn.close()
-    cursor = conn.cursor()
+        datesql=ONBOARDING_QUERY_LOGIN_TIME
-    cursor.execute(datesql)
+        conn = getDbConnection()
-    result = cursor.fetchall()
-    agentLoginList=[]
+        cursor = conn.cursor()
-    averageLoginTime=0
+        cursor.execute(datesql)
-    loginTime=0
+        result = cursor.fetchall()
-    for r in result:
+        agentLoginList=[]
-        loginTime+=r[1].seconds
+        averageLoginTime=0
-        agentLoginList.append(str(r[0]))
+        loginTime=0
-    averageLoginTime=loginTime/len(list(set(agentLoginList)))
+        for r in result:
-    hours=averageLoginTime/3600
+            loginTime+=r[1].seconds
-    minutesLeft=(averageLoginTime%3600)/60
+            agentLoginList.append(str(r[0]))
-    worksheet.write(8,1,len(list(set(agentLoginList))),center_alignment)
+        averageLoginTime=loginTime/len(list(set(agentLoginList)))
-    worksheet.write(9,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
+        hours=averageLoginTime/3600
-    worksheet.write(10,1,totalDispositions,center_alignment)
+        minutesLeft=(averageLoginTime%3600)/60
-    worksheet.write(11,1,(contactableData+nonContactableData)/len(list(set(agentLoginList))),center_alignment)
+        worksheet.write(8,1,len(list(set(agentLoginList))),center_alignment)
-    conn.close()
+        worksheet.write(9,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
-    datesql=ONBOARDING_QUERY_DURATION
+        worksheet.write(10,1,totalDispositions,center_alignment)
-    conn = getDbConnection()
+        worksheet.write(11,1,(contactableData+nonContactableData)/len(list(set(agentLoginList))),center_alignment)
+        conn.close()
-    cursor = conn.cursor()
+        datesql=ONBOARDING_QUERY_DURATION
-    cursor.execute(datesql)
+        conn = getDbConnection()
-    result = cursor.fetchall()
-    for r in result:
+        cursor = conn.cursor()
-        totalCallDuration= r[0]
+        cursor.execute(datesql)
-    averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
+        result = cursor.fetchall()
-    hours=averageCallDuration/3600
+        for r in result:
-    minutesLeft=(averageCallDuration%3600)/60
+            totalCallDuration= r[0]
-    worksheet.write(12,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+        averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
+        hours=averageCallDuration/3600
-    conn.close()
+        minutesLeft=(averageCallDuration%3600)/60
-    datesql=ONBOARDING_QUERY_AHT
+        worksheet.write(12,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
-    conn = getDbConnection()
+        conn.close()
-    cursor = conn.cursor()
+        datesql=ONBOARDING_QUERY_AHT
-    cursor.execute(datesql)
+        conn = getDbConnection()
-    result = cursor.fetchall()
-    for r in result:
+        cursor = conn.cursor()
-        totalCallDuration= r[0]
+        cursor.execute(datesql)
-    averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
+        result = cursor.fetchall()
-    hours=averageCallDuration/3600
+        for r in result:
-    minutesLeft=(averageCallDuration%3600)/60
+            totalCallDuration= r[0]
-    worksheet.write(13,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+        averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
-    conn.close()
+        hours=averageCallDuration/3600
-    datesql=ONBOARDING_QUERY_AIT
+        minutesLeft=(averageCallDuration%3600)/60
-    conn = getDbConnection()
+        worksheet.write(13,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+        conn.close()
-    cursor = conn.cursor()
+        datesql=ONBOARDING_QUERY_AIT
-    cursor.execute(datesql)
+        conn = getDbConnection()
-    result = cursor.fetchall()
-    for r in result:
+        cursor = conn.cursor()
-        totalCallDuration= r[0]
+        cursor.execute(datesql)
-    averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
+        result = cursor.fetchall()
-    hours=averageCallDuration/3600
+        for r in result:
-    minutesLeft=(averageCallDuration%3600)/60
+            totalCallDuration= r[0]
-    worksheet.write(14,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+        averageCallDuration=totalCallDuration/len(list(set(agentLoginList)))
-    workbook.save(TMP_FILE)
+        hours=averageCallDuration/3600
+        minutesLeft=(averageCallDuration%3600)/60
+        worksheet.write(14,1,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)
+        workbook.save(TMP_FILE)
     #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
 def generateAgentWiseOnboardingCallingReport():

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15506 → 15513