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

                 'product_availability':9,
                 'return_replacement':10,
                 'product_quality_issue':11,
                 'delayed_delivery':12,
                 'other_complaint':13,
-                'not_dealing_accessories':14
+                'not_dealing_accessories':14,
+                'scheme_not_clear':15
+              }
 # FRESH_QUERY="""
 # select call_disposition,count(1) from
 # (select * from (select * from callhistory where date(created)=date(now())
 # and call_type ='fresh' order by created desc)
 select agent_id,TIMEDIFF(logoutTime,loginTime) from agentlogintimings where role='accs_cart' and date(created)=date(now() - interval 1 day);
 """
 ACCS_CART_DISPOSITION_DESCRIPTION="""
 select user_id,call_disposition,disposition_description,disposition_comments
 from callhistorycrm where call_disposition not in ('ringing_no_answer','not_reachable','switch_off','call_later')
-and date(created)=date(now() - interval 1 day)"""
+and date(created)=date(now() - interval 1 day) and project_id=1"""
 ACCS_CART_PRODUCT_PRICING="""
 select user_id,call_disposition,product_input,pricing_input from productpricinginputs where
-date(created)=date(now() - interval 1 day) and product_input not like '';
+date(created)=date(now() - interval 1 day) and product_input not like '' and project_id=1;
 """
 ACCS_TAB_QUERY="""
 select call_disposition,count(1) from
 (select * from (select * from callhistorycrm where date(created)=date(now() - interval 1 day)
     worksheet.write(10,column, 'Return or replacement pending', newStyle)
     worksheet.write(11,column, 'Product Quality issue', newStyle)
     worksheet.write(12,column, 'Delayed delivery', newStyle)
     worksheet.write(13,column, 'Other complaint with Profitmandi', newStyle)
     worksheet.write(14,column, 'Not Dealing in Accessories/Not Interested', newStyle)
+    worksheet.write(15,column, 'Scheme Not Clear to the user', newStyle)
-    worksheet.write(15,column, 'Contactable Data (%)', newStyle)
+    worksheet.write(16,column, 'Contactable Data (%)', newStyle)
-    worksheet.write(16,column, 'Non Contactable Data (%)', newStyle)
+    worksheet.write(17,column, 'Non Contactable Data (%)', newStyle)
-    worksheet.write(17,column, 'Agents Logged In', style)
+    worksheet.write(18,column, 'Agents Logged In', style)
-    worksheet.write(18,column, 'Average Login Time (In Hrs)', style)
+    worksheet.write(19,column, 'Average Login Time (In Hrs)', style)
-    worksheet.write(19,column, 'Total Dialed Out', style)
+    worksheet.write(20,column, 'Total Dialed Out', style)
-    worksheet.write(20,column, 'Average Dialed Out per agent', style)
+    worksheet.write(21,column, 'Average Dialed Out per agent', style)
     contactableData=0
     nonContactableData=0
     for r in result:
         row = accsDispositionOrdersMap.get(r[0])
         if accsDispositionOrdersMap.get(r[0]) == 2 or accsDispositionOrdersMap.get(r[0]) == 3 or accsDispositionOrdersMap.get(r[0]) == 4:
     global ACCS_ORDER_TOTAL
     global ACCS_ORDER_SUCCESSFUL
     ACCS_ORDER_TOTAL = totalDispositions
     ACCS_ORDER_SUCCESSFUL=contactableData
     if totalDispositions > 0:
-        worksheet.write(15,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
+        worksheet.write(16,1,round((contactableData/float(totalDispositions))*100,2),center_alignment)
-        worksheet.write(16,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
+        worksheet.write(17,1,round((nonContactableData/float(totalDispositions))*100,2),center_alignment)
     conn.close()
     datesql=ACCS_ORDER_AGENTS_CALLED_COUNT
     conn = getDbConnection()
         for r in result:
             loginTime+=r[1].seconds
         averageLoginTime=loginTime/len(list(set(agentLoginList)))
         hours=averageLoginTime/3600
         minutesLeft=(averageLoginTime%3600)/60
-        worksheet.write(17,1,len(list(set(agentLoginList))),center_alignment)
+        worksheet.write(18,1,len(list(set(agentLoginList))),center_alignment)
-        worksheet.write(18,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
+        worksheet.write(19,1,str(hours) + ':'+ str(minutesLeft),center_alignment)
-        worksheet.write(19,1,totalDispositions,center_alignment)
+        worksheet.write(20,1,totalDispositions,center_alignment)
-        worksheet.write(20,1,totalDispositions/float(len(list(set(agentLoginList)))),center_alignment)
+        worksheet.write(21,1,totalDispositions/float(len(list(set(agentLoginList)))),center_alignment)
         conn.close()
     worksheet.write(0,5, 'User Id', style)
     worksheet.write(0,6, 'Call Disposition', style)
         for data in r:
             worksheet.write(row,column,data)
             column+=1
     conn.close()
-    worksheet.write(22,0, 'User Id', style)
+    worksheet.write(23,0, 'User Id', style)
-    worksheet.write(22,1, 'Call Disposition', style)
+    worksheet.write(23,1, 'Call Disposition', style)
-    worksheet.write(22,2, 'Product Inputs', style)
+    worksheet.write(23,2, 'Product Inputs', style)
-    worksheet.write(22,3, 'Pricing Inputs', style)
+    worksheet.write(23,3, 'Pricing Inputs', style)
     datesql = ACCS_ORDER_PRODUCT_PRICING
     conn = getDbConnection()
     cursor = conn.cursor()
     cursor.execute(datesql)
     result = cursor.fetchall()
-    row=20
+    row=23
     for r in result:
         row=row+1
         column =0
         for data in r:
             worksheet.write(row,column,data)

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 19160 → 19551