Subversion Repositories SmartDukaan

Rev

Rev 15396 | Rev 15398 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15396 Rev 15397
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 'Avg' + str(totalDispositions/len(list(set(agentLoginList))))
 265 
    print 'Avg' + str(totalDispositions/float(len(list(set(agentLoginList)))))
266 
    print 'list' + str(list(set(agentLoginList)))
 266 
    print 'list' + str(list(set(agentLoginList)))
267 
    worksheet.write(20,1,totalDispositions/len(list(set(agentLoginList))))
 267 
    worksheet.write(20,1,totalDispositions/float(len(list(set(agentLoginList)))))
268 
    conn.close()
 268 
    conn.close()
269 
    datesql=FRESH_QUERY_DURATION
 269 
    datesql=FRESH_QUERY_DURATION
270 
    conn = getDbConnection()
 270 
    conn = getDbConnection()
271
271
272 
    cursor = conn.cursor()
 272 
    cursor = conn.cursor()
Line 873... Line 873...
873 
    workbook.save(TMP_FILE)
873 
    workbook.save(TMP_FILE)
874 
 
 874 
 
875 
 
 875 
 
876
876
877 
def main():
 877 
def main():
- 
 
 878
878 
    generateFreshCallingReport()
 879 
    generateFreshCallingReport()
879 
    generateAgentWiseFreshCallingReport()
 880 
    generateAgentWiseFreshCallingReport()
880 
    generateFollowUpCallingReport()
 881 
    generateFollowUpCallingReport()
881 
    generateAgentWiseFollowupCallingReport()
 882 
    generateAgentWiseFollowupCallingReport()
882 
    generateOnBoardingCallingReport()
 883 
    generateOnBoardingCallingReport()