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



    hours=averageLoginTime/3600
    minutesLeft=(averageLoginTime%3600)/60
    worksheet.write(17,1,len(list(set(agentLoginList))))
    worksheet.write(18,1,str(hours) + ':'+ str(minutesLeft))   
    worksheet.write(19,1,totalDispositions)
    print 'list' + str(agentLoginList)
    print 'Avg' + str(totalDispositions/float(len(list(set(agentLoginList)))))
    print 'list' + str(list(set(agentLoginList)))
    worksheet.write(20,1,totalDispositions/float(len(list(set(agentLoginList)))))
    conn.close()
    datesql=FRESH_QUERY_DURATION

    workbook.save(TMP_FILE)          
 
 
        
def main():
 
    generateFreshCallingReport()
    generateAgentWiseFreshCallingReport()
    generateFollowUpCallingReport()
    generateAgentWiseFollowupCallingReport()
    generateOnBoardingCallingReport()

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15397 → 15398

Rev 15397		Rev 15398
Line 260...		Line 260...
260	`hours=averageLoginTime/3600`	260	`hours=averageLoginTime/3600`
261	`minutesLeft=(averageLoginTime%3600)/60`	261	`minutesLeft=(averageLoginTime%3600)/60`
262	`worksheet.write(17,1,len(list(set(agentLoginList))))`	262	`worksheet.write(17,1,len(list(set(agentLoginList))))`
263	`worksheet.write(18,1,str(hours) + ':'+ str(minutesLeft))`	263	`worksheet.write(18,1,str(hours) + ':'+ str(minutesLeft))`
264	`worksheet.write(19,1,totalDispositions)`	264	`worksheet.write(19,1,totalDispositions)`
-		265	`print 'list' + str(agentLoginList)`
265	`print 'Avg' + str(totalDispositions/float(len(list(set(agentLoginList)))))`	266	`print 'Avg' + str(totalDispositions/float(len(list(set(agentLoginList)))))`
266	`print 'list' + str(list(set(agentLoginList)))`	267	`print 'list' + str(list(set(agentLoginList)))`
267	`worksheet.write(20,1,totalDispositions/float(len(list(set(agentLoginList)))))`	268	`worksheet.write(20,1,totalDispositions/float(len(list(set(agentLoginList)))))`
268	`conn.close()`	269	`conn.close()`
269	`datesql=FRESH_QUERY_DURATION`	270	`datesql=FRESH_QUERY_DURATION`
Line 873...		Line 874...
873	`workbook.save(TMP_FILE)`	874	`workbook.save(TMP_FILE)`
874		875
875		876
876		877
877	`def main():`	878	`def main():`
878		-
879	`generateFreshCallingReport()`	879	`generateFreshCallingReport()`
880	`generateAgentWiseFreshCallingReport()`	880	`generateAgentWiseFreshCallingReport()`
881	`generateFollowUpCallingReport()`	881	`generateFollowUpCallingReport()`
882	`generateAgentWiseFollowupCallingReport()`	882	`generateAgentWiseFollowupCallingReport()`
883	`generateOnBoardingCallingReport()`	883	`generateOnBoardingCallingReport()`