// hide column and display the button to unhide it function foldup(id) { $('#reporting_table .data_table tr td:nth-child(' + (id + 1) + ')').toggleClass('hide'); $('#reporting_table .data_table tr th:nth-child(' + (id + 1) + ')').toggleClass('hide'); $('div#unhideButtons a:nth-child(' + (id + 1) + ')').toggleClass('hide'); } // add the red cross on top of each column function init_hide() { $('#reporting_table .data_table tr th').each( function(index) { $(this).prepend( '
".Display::return_icon( 'visible.png', get_lang('Hide column'), ['align' => 'absmiddle', 'hspace' => '3px'], ICON_SIZE_SMALL )."
' ); } ); } // hide some column at startup // be sure that these columns always exists // see headers = array(); // tab of header texts $(function() { init_hide(); var columnsToHide = ".$columnsToHide."; if (columnsToHide) { columnsToHide.forEach(function(id) { foldup(id); }); } }) "; $htmlHeadXtra[] = $js; // Database table definitions. //@todo remove this calls $TABLETRACK_EXERCISES = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES); $TABLECOURSUSER = Database::get_main_table(TABLE_MAIN_COURSE_USER); $TABLECOURSE = Database::get_main_table(TABLE_MAIN_COURSE); $table_user = Database::get_main_table(TABLE_MAIN_USER); $TABLEQUIZ = Database::get_course_table(TABLE_QUIZ_TEST); // Breadcrumbs. if ($origin === 'resume_session') { $interbreadcrumb[] = [ 'url' => '../admin/index.php', 'name' => get_lang('Administration'), ]; $interbreadcrumb[] = [ 'url' => '../session/session_list.php', 'name' => get_lang('Session list'), ]; $interbreadcrumb[] = [ 'url' => '../session/resume_session.php?id_session='.$sessionId, 'name' => get_lang('Session overview'), ]; } $view = isset($_REQUEST['view']) ? $_REQUEST['view'] : ''; $nameTools = get_lang('Reporting'); $tpl = new Template($nameTools); // Getting all the students of the course if (empty($sessionId)) { // Registered students in a course outside session. $studentList = CourseManager::get_student_list_from_course_code($courseId); } else { // Registered students in session. $studentList = CourseManager::get_student_list_from_course_code($courseId, true, $sessionId); } $nbStudents = count($studentList); $user_ids = array_keys($studentList); $extra_info = []; $userProfileInfo = []; // Getting all the additional information of an additional profile field. if (isset($_GET['additional_profile_field'])) { $user_array = []; foreach ($studentList as $key => $item) { $user_array[] = $key; } foreach ($_GET['additional_profile_field'] as $fieldId) { // Fetching only the user that are loaded NOT ALL user in the portal. $userProfileInfo[$fieldId] = TrackingCourseLog::getAdditionalProfileInformationOfFieldByUser( $fieldId, $user_array ); $extra_info[$fieldId] = UserManager::get_extra_field_information($fieldId); } } Session::write('additional_user_profile_info', $userProfileInfo); Session::write('extra_field_info', $extra_info); Display::display_header($nameTools, 'Tracking'); $actionsLeft = TrackingCourseLog::actionsLeft('users', $sessionId); $actionsRight = '
'; $actionsRight .= ''. Display::return_icon('printer.png', get_lang('Print'), '', ICON_SIZE_MEDIUM).''; $additionalParams = ''; if (isset($_GET['additional_profile_field'])) { foreach ($_GET['additional_profile_field'] as $fieldId) { $additionalParams .= '&additional_profile_field[]='.(int) $fieldId; } } $users_tracking_per_page = ''; if (isset($_GET['users_tracking_per_page'])) { $users_tracking_per_page = '&users_tracking_per_page='.intval($_GET['users_tracking_per_page']); } $actionsRight .= ' '.Display::return_icon('export_csv.png', get_lang('CSV export'), '', ICON_SIZE_MEDIUM).''; $actionsRight .= '
'; // Create a search-box. $form_search = new FormValidator( 'search_simple', 'GET', api_get_path(WEB_CODE_PATH).'tracking/courseLog.php?'.api_get_cidreq(), '', [], FormValidator::LAYOUT_INLINE ); $form_search->addHidden('from', Security::remove_XSS($from)); $form_search->addHidden('session_id', $sessionId); $form_search->addHidden('id_session', $sessionId); $form_search->addElement('text', 'user_keyword'); $form_search->addButtonSearch(get_lang('Search users')); echo Display::toolbarAction( 'toolbar-courselog', [$actionsLeft, $form_search->returnForm(), $actionsRight] ); $course_name = get_lang('Course').' '.$courseInfo['name']; if ($sessionId) { $titleSession = Display::return_icon( 'session.png', get_lang('Session'), [], ICON_SIZE_SMALL ).' '.api_get_session_name($sessionId); $titleCourse = Display::return_icon( 'course.png', get_lang('Course'), [], ICON_SIZE_SMALL ).' '.$course_name; } else { $titleSession = Display::return_icon( 'course.png', get_lang('Course'), [], ICON_SIZE_SMALL ).' '.$courseInfo['name']; } $teacherList = CourseManager::getTeacherListFromCourseCodeToString( $courseInfo['code'], ',', true, true ); $coaches = null; if (!empty($sessionId)) { $coaches = CourseManager::get_coachs_from_course_to_string( $sessionId, $courseInfo['real_id'], ',', true, true ); } $html = ''; if (!empty($teacherList)) { $html .= Display::page_subheader2(get_lang('Trainers')); $html .= $teacherList; } if (!empty($coaches)) { $html .= Display::page_subheader2(get_lang('Coaches')); $html .= $coaches; } $showReporting = api_get_configuration_value('hide_reporting_session_list') === false; if ($showReporting) { $sessionList = SessionManager::get_session_by_course($courseInfo['real_id']); if (!empty($sessionList)) { $html .= Display::page_subheader2(get_lang('Session list')); $icon = Display::return_icon( 'session.png', null, null, ICON_SIZE_TINY ); $html .= ''; } } $trackingColumn = isset($_GET['users_tracking_column']) ? $_GET['users_tracking_column'] : null; $trackingDirection = isset($_GET['users_tracking_direction']) ? $_GET['users_tracking_direction'] : null; // Show the charts part only if there are students subscribed to this course/session if ($nbStudents > 0) { $usersTracking = TrackingCourseLog::get_user_data(null, $nbStudents, $trackingColumn, $trackingDirection, false); $numberStudentsCompletedLP = 0; $averageStudentsTestScore = 0; $scoresDistribution = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]; $userScoreList = []; $listStudentIds = []; $timeStudent = []; $certificateCount = 0; $category = Category::load( null, null, $course_code, null, null, $sessionId ); $hideReports = api_get_configuration_value('hide_course_report_graph'); if ($hideReports === false) { foreach ($usersTracking as $userTracking) { $userInfo = api_get_user_info_from_username($userTracking[3]); if (empty($userInfo)) { continue; } $userId = $userInfo['user_id']; if ($userTracking[5] === '100%') { $numberStudentsCompletedLP++; } $averageStudentTestScore = substr($userTracking[7], 0, -1); $averageStudentsTestScore += $averageStudentTestScore; if ($averageStudentTestScore === '100') { $reducedAverage = 9; } else { $reducedAverage = floor($averageStudentTestScore / 10); } if (isset($scoresDistribution[$reducedAverage])) { $scoresDistribution[$reducedAverage]++; } $scoreStudent = substr($userTracking[5], 0, -1) + substr($userTracking[7], 0, -1); list($hours, $minutes, $seconds) = preg_split('/:/', $userTracking[4]); $minutes = round((3600 * $hours + 60 * $minutes + $seconds) / 60); $certificate = false; if (isset($category[0]) && $category[0]->is_certificate_available($userId)) { $certificate = true; $certificateCount++; } $listStudent = [ 'id' => $userId, 'fullname' => $userInfo['complete_name'], 'score' => floor($scoreStudent / 2), 'total_time' => $minutes, 'avatar' => $userInfo['avatar'], 'certicate' => $certificate, ]; $listStudentIds[] = $userId; $userScoreList[] = $listStudent; } uasort($userScoreList, 'sort_by_order'); $averageStudentsTestScore = round($averageStudentsTestScore / $nbStudents); $colors = ChamiloApi::getColorPalette(true, true, 10); $tpl->assign('chart_colors', json_encode($colors)); $tpl->assign('certificate_count', $certificateCount); $tpl->assign('score_distribution', json_encode($scoresDistribution)); $tpl->assign('json_time_student', json_encode($userScoreList)); $tpl->assign('students_test_score', $averageStudentsTestScore); $tpl->assign('students_completed_lp', $numberStudentsCompletedLP); $tpl->assign('number_students', $nbStudents); $tpl->assign('top_students', $userScoreList); $trackingSummaryLayout = $tpl->get_template('tracking/tracking_course_log.tpl'); $content = $tpl->fetch($trackingSummaryLayout); echo $content; } } $html .= Display::page_subheader2(get_lang('Learners list')); if ($nbStudents > 0) { $getLangXDays = get_lang('%s days'); $form = new FormValidator( 'reminder_form', 'get', api_get_path(WEB_CODE_PATH).'announcements/announcements.php?'.api_get_cidreq(), null, ['style' => 'margin-bottom: 10px'], FormValidator::LAYOUT_INLINE ); $options = [ 2 => sprintf($getLangXDays, 2), 3 => sprintf($getLangXDays, 3), 4 => sprintf($getLangXDays, 4), 5 => sprintf($getLangXDays, 5), 6 => sprintf($getLangXDays, 6), 7 => sprintf($getLangXDays, 7), 15 => sprintf($getLangXDays, 15), 30 => sprintf($getLangXDays, 30), 'never' => get_lang('Never'), ]; $el = $form->addSelect( 'since', Display::returnFontAwesomeIcon('warning').get_lang('Remind learners inactive since'), $options, ['disable_js' => true] ); $el->setSelected(7); $form->addElement('hidden', 'action', 'add'); $form->addElement('hidden', 'remindallinactives', 'true'); $form->addElement('hidden', 'cidReq', $courseInfo['code']); $form->addElement('hidden', 'id_session', api_get_session_id()); $form->addButtonSend(get_lang('Notify')); $extra_field_select = TrackingCourseLog::display_additional_profile_fields(); if (!empty($extra_field_select)) { $html .= $extra_field_select; } $html .= $form->returnForm(); if ($export_csv) { $csv_content = []; //override the SortableTable "per page" limit if CSV $_GET['users_tracking_per_page'] = 1000000; } $table = new SortableTableFromArray( $usersTracking, 1, 20, 'users_tracking' ); $table->total_number_of_items = $nbStudents; $parameters['cidReq'] = isset($_GET['cidReq']) ? Security::remove_XSS($_GET['cidReq']) : ''; $parameters['id_session'] = $sessionId; $parameters['from'] = isset($_GET['myspace']) ? Security::remove_XSS($_GET['myspace']) : null; $table->set_additional_parameters($parameters); $headers = []; // tab of header texts $table->set_header(0, get_lang('Code'), true); $headers['official_code'] = get_lang('Code'); if ($sortByFirstName) { $table->set_header(1, get_lang('First name'), true); $table->set_header(2, get_lang('Last name'), true); $headers['firstname'] = get_lang('First name'); $headers['lastname'] = get_lang('Last name'); } else { $table->set_header(1, get_lang('Last name'), true); $table->set_header(2, get_lang('First name'), true); $headers['lastname'] = get_lang('Last name'); $headers['firstname'] = get_lang('First name'); } $table->set_header(3, get_lang('Login'), false); $headers['login'] = get_lang('Login'); $table->set_header( 4, get_lang('Time').' '. Display::return_icon('info3.gif', get_lang('Time spent in the course'), ['align' => 'absmiddle', 'hspace' => '3px']), false, ['style' => 'width:110px;'] ); $headers['training_time'] = get_lang('Time'); $table->set_header(5, get_lang('Progress').' '. Display::return_icon( 'info3.gif', get_lang('Average progress in courses'), ['align' => 'absmiddle', 'hspace' => '3px'] ), false, ['style' => 'width:110px;'] ); $headers['course_progress'] = get_lang('Progress'); $table->set_header(6, get_lang('Exercise progress').' '. Display::return_icon( 'info3.gif', get_lang('Exercise progressInfo'), ['align' => 'absmiddle', 'hspace' => '3px'] ), false, ['style' => 'width:110px;'] ); $headers['exercise_progress'] = get_lang('Exercise progress'); $table->set_header(7, get_lang('Exercise average').' '. Display::return_icon('info3.gif', get_lang('Exercise averageInfo'), ['align' => 'absmiddle', 'hspace' => '3px']), false, ['style' => 'width:110px;'] ); $headers['exercise_average'] = get_lang('Exercise average'); $table->set_header(8, get_lang('Score').' '. Display::return_icon( 'info3.gif', get_lang('Average of tests in Learning Paths'), ['align' => 'absmiddle', 'hspace' => '3px'] ), false, ['style' => 'width:110px;'] ); $headers['score'] = get_lang('Score'); $table->set_header(9, get_lang('Assignments'), false); $headers['student_publication'] = get_lang('Assignments'); $table->set_header(10, get_lang('Messages'), false); $headers['messages'] = get_lang('Messages'); $table->set_header(11, get_lang('Classes')); $headers['clasess'] = get_lang('Classes'); if (empty($sessionId)) { $table->set_header(12, get_lang('Survey'), false); $headers['survey'] = get_lang('Survey'); $table->set_header(13, get_lang('First access to course'), false); $headers['first_login'] = get_lang('First access to course'); $table->set_header(14, get_lang('Latest access in course'), false); $headers['latest_login'] = get_lang('Latest access in course'); if (isset($_GET['additional_profile_field'])) { $counter = 15; foreach ($_GET['additional_profile_field'] as $fieldId) { $table->set_header($counter, $extra_info[$fieldId]['display_text'], false); $headers[$extra_info[$fieldId]['variable']] = $extra_info[$fieldId]['display_text']; $counter++; } $table->set_header($counter, get_lang('Details'), false); $headers['details'] = get_lang('Details'); } else { $table->set_header(15, get_lang('Details'), false); $headers['details'] = get_lang('Details'); } } else { $table->set_header(12, get_lang('First access to course'), false); $headers['first_login'] = get_lang('First access to course'); $table->set_header(13, get_lang('Latest access in course'), false); $headers['latest_login'] = get_lang('Latest access in course'); if (isset($_GET['additional_profile_field'])) { $counter = 15; foreach ($_GET['additional_profile_field'] as $fieldId) { $table->set_header($counter, $extra_info[$fieldId]['display_text'], false); $headers[$extra_info[$fieldId]['variable']] = $extra_info[$fieldId]['display_text']; $counter++; } } else { $table->set_header(14, get_lang('Details'), false); $headers['Details'] = get_lang('Details'); } } // display buttons to un hide hidden columns $html .= '
'; $index = 0; $getLangDisplayColumn = get_lang('Show column'); foreach ($headers as $header) { $html .= Display::toolbarButton( $header, '#', 'arrow-right', 'default', [ 'title' => htmlentities("$getLangDisplayColumn \"$header\"", ENT_QUOTES), 'class' => 'hide', 'onclick' => "foldup($index); return false;", ] ); $index++; } $html .= '
'; $html .= '
'; $html .= $table->return_table(); $html .= '
'; } else { $html .= Display::return_message(get_lang('No users in course'), 'warning', true); } echo Display::panel($html, $titleSession); // Send the csv file if asked. if ($export_csv) { $csv_headers = []; $csv_headers[] = get_lang('Code'); if ($sortByFirstName) { $csv_headers[] = get_lang('First name'); $csv_headers[] = get_lang('Last name'); } else { $csv_headers[] = get_lang('Last name'); $csv_headers[] = get_lang('First name'); } $csv_headers[] = get_lang('Login'); $csv_headers[] = get_lang('Time'); $csv_headers[] = get_lang('Progress'); $csv_headers[] = get_lang('Exercise progress'); $csv_headers[] = get_lang('Exercise average'); $csv_headers[] = get_lang('Score'); $csv_headers[] = get_lang('Assignments'); $csv_headers[] = get_lang('Messages'); if (empty($sessionId)) { $csv_headers[] = get_lang('Survey'); } $csv_headers[] = get_lang('First access to course'); $csv_headers[] = get_lang('Latest access in course'); if (isset($_GET['additional_profile_field'])) { foreach ($_GET['additional_profile_field'] as $fieldId) { $csv_headers[] = $extra_info[$fieldId]['display_text']; } } ob_end_clean(); $csvContentInSession = Session::read('csv_content'); // Adding headers before the content. array_unshift($csvContentInSession, $csv_headers); if ($sessionId) { $sessionInfo = api_get_session_info($sessionId); $sessionDates = SessionManager::parseSessionDates($sessionInfo); array_unshift($csvContentInSession, [get_lang('Date'), $sessionDates['access']]); array_unshift($csvContentInSession, [get_lang('Session name'), $sessionInfo['name']]); } Export::arrayToCsv($csvContentInSession, 'reporting_student_list'); exit; } Display::display_footer(); function sort_by_order($a, $b) { return $a['score'] <= $b['score']; }