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



    cursor = conn.cursor()
    cursor.execute(datesql)
    result = cursor.fetchall()
    loginTime=0
    for r in result:
        if r[0] is not None:
            loginTime+=r[0]
    averageLoginTime=loginTime/len(list(set(agentLoginList)))
    hours=averageLoginTime/3600
    minutesLeft=(averageLoginTime%3600)/60
    worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)
    

Rev 15478	Rev 15481
Line 395...	Line 395...
395	`cursor = conn.cursor()`	395	`cursor = conn.cursor()`
396	`cursor.execute(datesql)`	396	`cursor.execute(datesql)`
397	`result = cursor.fetchall()`	397	`result = cursor.fetchall()`
398	`loginTime=0`	398	`loginTime=0`
399	`for r in result:`	399	`for r in result:`
-		400	`if r[0] is not None:`
400	`loginTime+=r[0]`	401	`loginTime+=r[0]`
401	`averageLoginTime=loginTime/len(list(set(agentLoginList)))`	402	`averageLoginTime=loginTime/len(list(set(agentLoginList)))`
402	`hours=averageLoginTime/3600`	403	`hours=averageLoginTime/3600`
403	`minutesLeft=(averageLoginTime%3600)/60`	404	`minutesLeft=(averageLoginTime%3600)/60`
404	`worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)`	405	`worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)`
405		406

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15478 → 15481