Subversion Repositories SmartDukaan

Rev

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

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