get_users()

Complexity

Conditions	12
Paths	100

Size

Total Lines	117
Code Lines	78

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
function get_users($from, $number_of_items, $column, $direction)
{
    $consideredWorkingTime = api_get_configuration_value('considered_working_time');

    $courseId = api_get_course_int_id();
    $courseCode = api_get_course_id();
    $sessionId = api_get_session_id();
    $webCodePath = api_get_path(WEB_CODE_PATH);

    $lastConnectionDate = null;
    $is_western_name_order = api_is_western_name_order();
    $limit = null;
    $from = (int) $from;
    $number_of_items = (int) $number_of_items;
    $limit = 'LIMIT '.$from.','.$number_of_items;

    $students = CourseManager::get_user_list_from_course_code(
        $courseCode,
        $sessionId,
        $limit,
        null,
        null,
        false
    );
    $url = $webCodePath.'mySpace/myStudents.php';

    $workList = getWorkListTeacher(0, 100, null, null, null);

    $totalCourseWorkTime = 0;
    $workTimeList = [];
    foreach ($workList as $work) {
        $fieldValue = new ExtraFieldValue('work');
        $resultExtra = $fieldValue->getAllValuesForAnItem(
            $work['id'],
            true
        );

        foreach ($resultExtra as $field) {
            $field = $field['value'];
            if ($consideredWorkingTime == $field->getField()->getVariable()) {
                $time = $field->getValue();
                $parsed = date_parse($time);
                $workTimeList[$work['id']] = $parsed['hour'] * 3600 + $parsed['minute'] * 60 + $parsed['second'];

                break;
            }
        }
    }

    $all_datas = [];
    foreach ($students as $studentData) {
        $studentId = $studentData['user_id'];
        $studentData = api_get_user_info($studentId);
        $urlDetails = $url."?student=$studentId";
        $row = [];
        if ($is_western_name_order) {
            $first = Display::url($studentData['firstname'], $urlDetails);
            $last = Display::url($studentData['lastname'], $urlDetails);
        } else {
            $first = Display::url($studentData['lastname'], $urlDetails);
            $last = Display::url($studentData['firstname'], $urlDetails);
        }

        $row[] = $first;
        $row[] = $last;

        $timeInSeconds = Tracking::get_time_spent_on_the_course(
            $studentId,
            $courseId,
            $sessionId
        );

        $row[] = api_time_to_hms($timeInSeconds);

        $userWorkTime = 0;
        foreach ($workList as $work) {
            $userWorks = get_work_user_list(
                0,
                100,
                null,
                null,
                $work['id'],
                null,
                $studentId,
                false,
                $courseId,
                $sessionId
            );

            if ($userWorks) {
                foreach ($userWorks as $work) {
                    $userWorkTime += $workTimeList[$work['parent_id']];
                }
            }
        }

        $row[] = api_time_to_hms($userWorkTime);
        $status = '';
        if ($userWorkTime && $timeInSeconds) {
            if ($userWorkTime > $timeInSeconds) {
                $status = Display::label('TimeToFix', 'warning');
            } else {
                $status = Display::label('Ok', 'success');
            }
        }

        $row[] = $status;
        /*$detailsLink = Display::url(
            Display::return_icon('2rightarrow.png', get_lang('Details').' '.$studentData['username']),
            $urlDetails,
            ['id' => 'details_'.$studentData['username']]
        );
        $row[] = $detailsLink;*/
        $all_datas[] = $row;
    }

    return $all_datas;
}