Subversion Repositories SmartDukaan

    for r in result:

    for r in result:

        agentLoginList.append(str(r[0]))

        agentLoginList.append(str(r[0]))

    conn.close()

    conn.close()

        datesql=FRESH_QUERY_LOGIN_TIME

        datesql=FRESH_QUERY_LOGIN_TIME

        conn = getDbConnection()

        conn = getDbConnection()

        cursor = conn.cursor()

        cursor = conn.cursor()

        cursor.execute(datesql)

        cursor.execute(datesql)

        result = cursor.fetchall()

        result = cursor.fetchall()

    averageLoginTime=0

    averageLoginTime=0

    loginTime=0

    loginTime=0

    for r in result:

    for r in result:

        loginTime+=r[1].seconds

        loginTime+=r[1].seconds

        agentLoginList.append(str(r[0]))

        agentLoginList.append(str(r[0]))

        averageLoginTime=loginTime/len(list(set(agentLoginList)))

        averageLoginTime=loginTime/len(list(set(agentLoginList)))

        hours=averageLoginTime/3600

        hours=averageLoginTime/3600

        minutesLeft=(averageLoginTime%3600)/60

        minutesLeft=(averageLoginTime%3600)/60

        worksheet.write(14,1,len(list(set(agentLoginList))),center_alignment)

        worksheet.write(14,1,len(list(set(agentLoginList))),center_alignment)

        worksheet.write(15,1,str(hours) + ':'+ str(minutesLeft),center_alignment)   

        worksheet.write(15,1,str(hours) + ':'+ str(minutesLeft),center_alignment)