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(20,1,len(list(set(agentLoginList))),center_alignment)
    workbook.save(TMP_FILE)  

                    cursor = conn.cursor()
                    cursor.execute(name_query)
                    result = cursor.fetchall()
                    loginTime=0
                    for r in result:
                        if r[0] is not None:
                            loginTime+=r[0]
                    hours=loginTime/3600
                    minutesLeft=(loginTime%3600)/60
                    worksheet.write(18,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)    
                    conn.close()
                    

Rev 19551	Rev 19861
Line 1296...	Line 1296...
1296	`cursor = conn.cursor()`	1296	`cursor = conn.cursor()`
1297	`cursor.execute(datesql)`	1297	`cursor.execute(datesql)`
1298	`result = cursor.fetchall()`	1298	`result = cursor.fetchall()`
1299	`loginTime=0`	1299	`loginTime=0`
1300	`for r in result:`	1300	`for r in result:`
-		1301	`if r[0] is not None:`
1301	`loginTime+=r[0]`	1302	`loginTime+=r[0]`
1302	`averageLoginTime=loginTime/len(list(set(agentLoginList)))`	1303	`averageLoginTime=loginTime/len(list(set(agentLoginList)))`
1303	`hours=averageLoginTime/3600`	1304	`hours=averageLoginTime/3600`
1304	`minutesLeft=(averageLoginTime%3600)/60`	1305	`minutesLeft=(averageLoginTime%3600)/60`
1305	`worksheet.write(20,1,len(list(set(agentLoginList))),center_alignment)`	1306	`worksheet.write(20,1,len(list(set(agentLoginList))),center_alignment)`
1306	`workbook.save(TMP_FILE)`	1307	`workbook.save(TMP_FILE)`
Line 1448...	Line 1449...
1448	`cursor = conn.cursor()`	1449	`cursor = conn.cursor()`
1449	`cursor.execute(name_query)`	1450	`cursor.execute(name_query)`
1450	`result = cursor.fetchall()`	1451	`result = cursor.fetchall()`
1451	`loginTime=0`	1452	`loginTime=0`
1452	`for r in result:`	1453	`for r in result:`
-		1454	`if r[0] is not None:`
1453	`loginTime+=r[0]`	1455	`loginTime+=r[0]`
1454	`hours=loginTime/3600`	1456	`hours=loginTime/3600`
1455	`minutesLeft=(loginTime%3600)/60`	1457	`minutesLeft=(loginTime%3600)/60`
1456	`worksheet.write(18,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)`	1458	`worksheet.write(18,columnId,str(int(hours))+':'+str(int(minutesLeft)),center_alignment)`
1457	`conn.close()`	1459	`conn.close()`
1458		1460

Subversion Repositories SmartDukaan

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