'; $export = isset($_GET['export']) ? $_GET['export'] : false; $sessionId = isset($_GET['id_session']) ? (int) $_GET['id_session'] : 0; $origin = api_get_origin(); $course_code = isset($_GET['course']) ? Security::remove_XSS($_GET['course']) : ''; $courseInfo = api_get_course_info($course_code); $student_id = isset($_GET['student']) ? (int) $_GET['student'] : 0; $coachId = isset($_GET['id_coach']) ? (int) $_GET['id_coach'] : 0; $details = isset($_GET['details']) ? Security::remove_XSS($_GET['details']) : ''; $currentUrl = api_get_self().'?student='.$student_id.'&course='.$course_code.'&id_session='.$sessionId .'&origin='.$origin.'&details='.$details; $allowMessages = api_get_configuration_value('private_messages_about_user'); if (empty($student_id)) { api_not_allowed(true); } // user info $user_info = api_get_user_info($student_id); if (empty($user_info)) { api_not_allowed(true); } $allowToQualify = api_is_allowed_to_edit(null, true) || api_is_course_tutor() || api_is_session_admin() || api_is_drh() || api_is_student_boss(); $allowedToTrackUser = true; if (!api_is_session_admin() && !api_is_drh() && !api_is_student_boss() && !api_is_platform_admin() ) { if (empty($sessionId)) { $isTeacher = false; // Check if is current teacher if set if (!empty($courseInfo)) { $isTeacher = CourseManager::is_course_teacher( api_get_user_id(), $courseInfo['code'] ); } if (!api_is_course_admin() && $isTeacher == false) { if (!empty($courseInfo)) { // Check if the user is tutor of the course $userCourseStatus = CourseManager::get_tutor_in_course_status( api_get_user_id(), $courseInfo['real_id'] ); if ($userCourseStatus != 1) { $allowedToTrackUser = false; } } } } else { $coach = api_is_coach($sessionId, $courseInfo['real_id']); if (!$coach) { $allowedToTrackUser = false; } } } if (!$allowedToTrackUser) { api_not_allowed(true); } if (api_is_student()) { api_not_allowed(true); } if ($export) { ob_start(); } $csv_content = []; $from_myspace = false; $this_section = SECTION_COURSES; if (isset($_GET['from']) && $_GET['from'] === 'myspace') { $from_myspace = true; $this_section = SECTION_TRACKING; } $nameTools = get_lang('StudentDetails'); $em = Database::getManager(); if (!empty($details)) { if ($origin === 'user_course') { if (empty($cidReq)) { $interbreadcrumb[] = [ 'url' => api_get_path(WEB_COURSE_PATH).$courseInfo['directory'], 'name' => $courseInfo['title'], ]; } $interbreadcrumb[] = [ 'url' => '../user/user.php?cidReq='.$course_code, 'name' => get_lang('Users'), ]; } else { if ($origin === 'tracking_course') { $interbreadcrumb[] = [ 'url' => '../tracking/courseLog.php?cidReq='.$course_code.'&id_session='.api_get_session_id(), 'name' => get_lang('Tracking'), ]; } else { if ($origin === 'resume_session') { $interbreadcrumb[] = [ 'url' => "../session/session_list.php", 'name' => get_lang('SessionList'), ]; $interbreadcrumb[] = [ 'url' => '../session/resume_session.php?id_session='.$sessionId, 'name' => get_lang('SessionOverview'), ]; } else { $interbreadcrumb[] = [ 'url' => api_is_student_boss() ? '#' : 'index.php', 'name' => get_lang('MySpace'), ]; if (!empty($coachId)) { $interbreadcrumb[] = [ 'url' => 'student.php?id_coach='.$coachId, 'name' => get_lang('CoachStudents'), ]; $interbreadcrumb[] = [ 'url' => 'myStudents.php?student='.$student_id.'&id_coach='.$coachId, 'name' => get_lang('StudentDetails'), ]; } else { $interbreadcrumb[] = [ 'url' => 'student.php', 'name' => get_lang('MyStudents'), ]; $interbreadcrumb[] = [ 'url' => 'myStudents.php?student='.$student_id, 'name' => get_lang('StudentDetails'), ]; } } } } $nameTools = get_lang('DetailsStudentInCourse'); } else { if ($origin === 'resume_session') { $interbreadcrumb[] = [ 'url' => '../session/session_list.php', 'name' => get_lang('SessionList'), ]; if (!empty($sessionId)) { $interbreadcrumb[] = [ 'url' => '../session/resume_session.php?id_session='.$sessionId, 'name' => get_lang('SessionOverview'), ]; } } elseif ($origin === 'teacher_details') { $this_section = SECTION_TRACKING; $interbreadcrumb[] = ['url' => 'index.php', 'name' => get_lang('MySpace')]; $interbreadcrumb[] = ['url' => 'teachers.php', 'name' => get_lang('Teachers')]; $nameTools = $user_info['complete_name']; } else { $interbreadcrumb[] = [ 'url' => api_is_student_boss() ? '#' : 'index.php', 'name' => get_lang('MySpace'), ]; if (!empty($coachId)) { if ($sessionId) { $interbreadcrumb[] = [ 'url' => 'student.php?id_coach='.$coachId.'&id_session='.$sessionId, 'name' => get_lang('CoachStudents'), ]; } else { $interbreadcrumb[] = [ 'url' => 'student.php?id_coach='.$coachId, 'name' => get_lang('CoachStudents'), ]; } } else { $interbreadcrumb[] = [ 'url' => 'student.php', 'name' => get_lang('MyStudents'), ]; } } } // Database Table Definitions $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $tbl_stats_exercices = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES); $user_id = isset($_GET['user_id']) && !empty($_GET['user_id']) ? (int) $_GET['user_id'] : api_get_user_id(); $action = isset($_GET['action']) ? $_GET['action'] : ''; switch ($action) { case 'export_to_pdf': $sessionToExport = $sId = isset($_GET['session_to_export']) ? (int) $_GET['session_to_export'] : 0; $sessionInfo = api_get_session_info($sessionToExport); if (empty($sessionInfo)) { api_not_allowed(true); } $courses = Tracking::get_courses_list_from_session($sessionToExport); $timeSpent = 0; $numberVisits = 0; $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS); $progress = 0; foreach ($courses as $course) { $courseId = $course['c_id']; $timeSpent += Tracking::get_time_spent_on_the_course($student_id, $courseId, $sessionToExport); $sql = 'SELECT DISTINCT count(course_access_id) as count FROM '.$table.' WHERE user_id = '.$student_id.' AND c_id = '.$courseId.' AND session_id = '.$sessionToExport.' ORDER BY login_course_date ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $numberVisits += $row['count']; $progress += Tracking::get_avg_student_progress($student_id, $course['code'], [], $sessionToExport); } $average = round($progress / count($courses), 1); $average = empty($average) ? '0%' : $average.'%'; $first = Tracking::get_first_connection_date($student_id); $last = Tracking::get_last_connection_date($student_id); $attendance = new Attendance(); $table = new HTML_Table(['class' => 'data_table']); $column = 0; $row = 0; $headers = [ get_lang('TimeSpent'), get_lang('NumberOfVisits'), get_lang('GlobalProgress'), get_lang('FirstLogin'), get_lang('LastConnexionDate'), ]; foreach ($headers as $header) { $table->setHeaderContents($row, $column, $header); $column++; } $table->setCellContents(1, 0, api_time_to_hms($timeSpent)); $table->setCellContents(1, 1, $numberVisits); $table->setCellContents(1, 2, $average); $table->setCellContents(1, 3, $first); $table->setCellContents(1, 4, $last); $courseTable = ''; if (!empty($courses)) { $courseTable .= ''; $courseTable .= ''; $courseTable .= ''; $courseTable .= ''; $courseTable .= ''; $totalCourseTime = 0; $totalAttendance = [0, 0]; $totalScore = 0; $totalProgress = 0; $gradeBookTotal = [0, 0]; $totalEvaluations = '0/0 (0%)'; $totalCourses = count($courses); $scoreDisplay = ScoreDisplay::instance(); foreach ($courses as $course) { $courseId = $course['c_id']; $courseInfoItem = api_get_course_info_by_id($courseId); $courseId = $courseInfoItem['real_id']; $courseCodeItem = $courseInfoItem['code']; $isSubscribed = CourseManager::is_user_subscribed_in_course( $student_id, $courseCodeItem, true, $sId ); if ($isSubscribed) { $timeInSeconds = Tracking::get_time_spent_on_the_course( $user_info['user_id'], $courseId, $sessionToExport ); $totalCourseTime += $timeInSeconds; $time_spent_on_course = api_time_to_hms($timeInSeconds); $progress = Tracking::get_avg_student_progress( $user_info['user_id'], $courseCodeItem, [], $sId ); $totalProgress += $progress; $bestScore = Tracking::get_avg_student_score( $user_info['user_id'], $courseCodeItem, [], $sId, false, false, true ); if (is_numeric($bestScore)) { $totalScore += $bestScore; } $progress = empty($progress) ? '0%' : $progress.'%'; $score = empty($bestScore) ? '0%' : $bestScore.'%'; $courseTable .= ''; $courseTable .= ''; } } $totalAttendanceFormatted = $scoreDisplay->display_score($totalAttendance); $totalScoreFormatted = $scoreDisplay->display_score([$totalScore / $totalCourses, 100], SCORE_AVERAGE); $totalProgressFormatted = $scoreDisplay->display_score( [$totalProgress / $totalCourses, 100], SCORE_AVERAGE ); $totalEvaluations = $scoreDisplay->display_score($gradeBookTotal); $totalTimeFormatted = api_time_to_hms($totalCourseTime); $courseTable .= ' '; $courseTable .= '
'.get_lang('FormationUnit').' '.get_lang('ConnectionTime').' '.get_lang('Progress').' '.get_lang('Score').'
'. $courseInfoItem['title'].' '.$time_spent_on_course.' '.$progress.' '.$score.'
'.get_lang('Total').' '.$totalTimeFormatted.' '.$totalProgressFormatted.' '.$totalScoreFormatted.'
'; } $studentInfo = api_get_user_info($student_id); $tpl = new Template('', false, false, false, true, false, false); $tpl->assign('title', get_lang('AttestationOfAttendance')); $tpl->assign('session_title', $sessionInfo['name']); $tpl->assign('student', $studentInfo['complete_name']); $tpl->assign('table_progress', $table->toHtml()); $tpl->assign('subtitle', sprintf( get_lang('InSessionXYouHadTheFollowingResults'), $sessionInfo['name'] )); $tpl->assign('table_course', $courseTable); $content = $tpl->fetch($tpl->get_template('my_space/pdf_export_student.tpl')); $params = [ 'pdf_title' => get_lang('Resume'), 'session_info' => $sessionInfo, 'course_info' => '', 'pdf_date' => '', 'student_info' => $studentInfo, 'show_grade_generated_date' => true, 'show_real_course_teachers' => false, 'show_teacher_as_myself' => false, 'orientation' => 'P', ]; $pdf = new PDF('A4', $params['orientation'], $params); try { $pdf->setBackground($tpl->theme); @$pdf->content_to_pdf( $content, '', '', null, 'D', false, null, false, true, false ); } catch (MpdfException $e) { error_log($e); } exit; break; case 'export_one_session_row': $sessionToExport = isset($_GET['session_to_export']) ? (int) $_GET['session_to_export'] : 0; $exportList = Session::read('export_course_list'); if (isset($exportList[$sessionToExport])) { $dataToExport = $exportList[$sessionToExport]; $title = ''; if (!empty($sessionToExport)) { $sessionInfo = api_get_session_info($sessionToExport); $title .= '_'.$sessionInfo['name']; } $fileName = 'report'.$title.'_'.$user_info['complete_name']; switch ($export) { case 'csv': Export::arrayToCsv($dataToExport, $fileName); break; case 'xls': Export::arrayToXls($dataToExport, $fileName); break; } } else { api_not_allowed(true); } break; case 'send_message': if ($allowMessages === true) { $subject = isset($_POST['subject']) ? $_POST['subject'] : ''; $message = isset($_POST['message']) ? $_POST['message'] : ''; $currentUserInfo = api_get_user_info(); MessageManager::sendMessageAboutUser( $user_info, $currentUserInfo, $subject, $message ); // Send also message to all student bosses $bossList = UserManager::getStudentBossList($student_id); if (!empty($bossList)) { $url = api_get_path(WEB_CODE_PATH).'mySpace/myStudents.php?student='.$student_id; $link = Display::url($url, $url); foreach ($bossList as $boss) { MessageManager::send_message_simple( $boss['boss_id'], sprintf(get_lang('BossAlertMsgSentToUserXTitle'), $user_info['complete_name']), sprintf( get_lang('BossAlertUserXSentMessageToUserYWithLinkZ'), $currentUserInfo['complete_name'], $user_info['complete_name'], $link ) ); } } Display::addFlash(Display::return_message(get_lang('MessageSent'))); header('Location: '.$currentUrl); exit; } break; case 'generate_certificate': // Delete old certificate $myCertificate = GradebookUtils::get_certificate_by_user_id( 0, $student_id ); if ($myCertificate) { $certificate = new Certificate($myCertificate['id'], $student_id); $certificate->delete(true); } // Create new one $certificate = new Certificate(0, $student_id); $certificate->generatePdfFromCustomCertificate(); exit; break; case 'send_legal': $isBoss = UserManager::userIsBossOfStudent(api_get_user_id(), $student_id); // @ofaj if ($isBoss || api_is_platform_admin()) { LegalManager::sendLegal($student_id); /* $currentUserInfo = api_get_user_info(); $subject = get_lang('SendLegalSubject'); $linkLegal = api_get_path(WEB_PATH)."courses/FORUMDAIDE/index.php"; $content = sprintf( get_lang('SendTermsDescriptionToUrlX'), $user_info['complete_name'], "".$linkLegal."", $currentUserInfo['complete_name'] ); MessageManager::send_message_simple($student_id, $subject, $content); Display::addFlash(Display::return_message(get_lang('Sent'))); */ } break; case 'delete_legal': $isBoss = UserManager::userIsBossOfStudent(api_get_user_id(), $student_id); if ($isBoss || api_is_platform_admin()) { $extraFieldValue = new ExtraFieldValue('user'); $value = $extraFieldValue->get_values_by_handler_and_field_variable( $student_id, 'legal_accept' ); $result = $extraFieldValue->delete($value['id']); if ($result) { Display::addFlash(Display::return_message(get_lang('Deleted'))); } } break; case 'reset_lp': $lp_id = isset($_GET['lp_id']) ? (int) $_GET['lp_id'] : ''; $check = true; if (!empty($lp_id) && !empty($student_id) && api_is_allowed_to_edit() && Security::check_token('get') ) { Event::delete_student_lp_events( $student_id, $lp_id, $courseInfo, $sessionId ); // @todo delete the stats.track_e_exercises records. // First implement this http://support.chamilo.org/issues/1334 Display::addFlash(Display::return_message(get_lang('LPWasReset'), 'success')); Security::clear_token(); } break; default: break; } $courses_in_session = []; // See #4676 $drh_can_access_all_courses = false; if (api_is_drh() || api_is_platform_admin() || api_is_student_boss()) { $drh_can_access_all_courses = true; } $courses = CourseManager::get_course_list_of_user_as_course_admin(api_get_user_id()); $courses_in_session_by_coach = []; $sessions_coached_by_user = Tracking::get_sessions_coached_by_user(api_get_user_id()); // RRHH or session admin if (api_is_session_admin() || api_is_drh()) { $courses = CourseManager::get_courses_followed_by_drh(api_get_user_id()); if (!empty($courses)) { $courses = array_column($courses, 'real_id'); } $session_by_session_admin = SessionManager::get_sessions_followed_by_drh(api_get_user_id()); if (!empty($session_by_session_admin)) { foreach ($session_by_session_admin as $session_coached_by_user) { $courses_followed_by_coach = Tracking::get_courses_list_from_session( $session_coached_by_user['id'] ); $courses_in_session_by_coach[$session_coached_by_user['id']] = $courses_followed_by_coach; } } } // Teacher or admin if (!empty($sessions_coached_by_user)) { foreach ($sessions_coached_by_user as $session_coached_by_user) { $sid = (int) $session_coached_by_user['id']; $courses_followed_by_coach = Tracking::get_courses_followed_by_coach(api_get_user_id(), $sid); $courses_in_session_by_coach[$sid] = $courses_followed_by_coach; } } $sql = "SELECT c_id FROM $tbl_course_user WHERE relation_type <> ".COURSE_RELATION_TYPE_RRHH." AND user_id = ".$student_id; $rs = Database::query($sql); while ($row = Database::fetch_array($rs)) { if ($drh_can_access_all_courses) { $courses_in_session[0][] = $row['c_id']; } else { if (isset($courses[$row['c_id']])) { $courses_in_session[0][] = $row['c_id']; } } } // Get the list of sessions where the user is subscribed as student $sql = 'SELECT session_id, c_id FROM '.Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER).' WHERE user_id='.$student_id; $rs = Database::query($sql); $tmp_sessions = []; while ($row = Database::fetch_array($rs, 'ASSOC')) { $tmp_sessions[] = $row['session_id']; if ($drh_can_access_all_courses) { if (in_array($row['session_id'], $tmp_sessions)) { $courses_in_session[$row['session_id']][] = $row['c_id']; } } else { if (isset($courses_in_session_by_coach[$row['session_id']])) { if (in_array($row['session_id'], $tmp_sessions)) { $courses_in_session[$row['session_id']][] = $row['c_id']; } } } } $isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh( api_get_user_id(), $courseInfo ); if (api_is_drh() && !api_is_platform_admin()) { if (!empty($student_id)) { if (api_drh_can_access_all_session_content()) { } else { if (!$isDrhOfCourse) { if (api_is_drh() && !UserManager::is_user_followed_by_drh($student_id, api_get_user_id()) ) { api_not_allowed(true); } } } } } $pluginCalendar = api_get_plugin_setting('learning_calendar', 'enabled') === 'true'; if ($pluginCalendar) { $plugin = LearningCalendarPlugin::create(); $plugin->setJavaScript($htmlHeadXtra); } Display::display_header($nameTools); $token = Security::get_token(); // Actions bar echo '
'; echo '' .Display::return_icon('back.png', get_lang('Back'), '', ICON_SIZE_MEDIUM).''; echo '' .Display::return_icon('printer.png', get_lang('Print'), '', ICON_SIZE_MEDIUM).''; echo '' .Display::return_icon('export_csv.png', get_lang('ExportAsCSV'), '', ICON_SIZE_MEDIUM).' '; echo '' .Display::return_icon('export_excel.png', get_lang('ExportAsXLS'), '', ICON_SIZE_MEDIUM).' '; echo Display::url( Display::return_icon('export.png', get_lang('Export'), '', ICON_SIZE_MEDIUM), api_get_path(WEB_CODE_PATH).'mySpace/access_details_session.php?user_id='.$student_id ); if (!empty($user_info['email'])) { $send_mail = ''. Display::return_icon('mail_send.png', get_lang('SendMail'), '', ICON_SIZE_MEDIUM).''; } else { $send_mail = Display::return_icon('mail_send_na.png', get_lang('SendMail'), '', ICON_SIZE_MEDIUM); } echo $send_mail; if (!empty($student_id) && !empty($course_code)) { // Only show link to connection details if course and student were defined in the URL echo '' .Display::return_icon('statistics.png', get_lang('AccessDetails'), '', ICON_SIZE_MEDIUM) .''; } $notebookTeacherEnable = api_get_plugin_setting('notebookteacher', 'enable_plugin_notebookteacher') === 'true'; if ($notebookTeacherEnable && !empty($student_id) && !empty($course_code)) { // link notebookteacher $optionsLink = 'student_id='.$student_id.'&origin='.$origin.'&cidReq='.$course_code.'&id_session='.$sessionId; echo '' .Display::return_icon('notebookteacher.png', get_lang('Notebook'), '', ICON_SIZE_MEDIUM) .''; } if (api_can_login_as($student_id)) { echo '' .Display::return_icon('login_as.png', get_lang('LoginAs'), null, ICON_SIZE_MEDIUM).'  '; } if (Skill::isAllowed($student_id, false)) { echo Display::url( Display::return_icon( 'skill-badges.png', get_lang('AssignSkill'), null, ICON_SIZE_MEDIUM ), api_get_path(WEB_CODE_PATH).'badge/assign.php?'.http_build_query(['user' => $student_id]) ); } $permissions = StudentFollowUpPlugin::getPermissions( $student_id, api_get_user_id() ); $isAllow = $permissions['is_allow']; if ($isAllow) { echo Display::url( Display::return_icon( 'blog.png', get_lang('Blog'), null, ICON_SIZE_MEDIUM ), api_get_path(WEB_PLUGIN_PATH).'studentfollowup/posts.php?student_id='.$student_id ); } echo '
'; // is the user online ? $online = get_lang('No'); if (user_is_online($student_id)) { $online = get_lang('Yes'); } // get average of score and average of progress by student $avg_student_progress = $avg_student_score = 0; if (empty($sessionId)) { $isSubscribedToCourse = CourseManager::is_user_subscribed_in_course($user_info['user_id'], $course_code); } else { $isSubscribedToCourse = CourseManager::is_user_subscribed_in_course( $user_info['user_id'], $course_code, true, $sessionId ); } if ($isSubscribedToCourse) { $avg_student_progress = Tracking::get_avg_student_progress( $user_info['user_id'], $course_code, [], $sessionId ); // the score inside the Reporting table $avg_student_score = Tracking::get_avg_student_score( $user_info['user_id'], $course_code, [], $sessionId ); } $avg_student_progress = round($avg_student_progress, 2); $time_spent_on_the_course = 0; if (!empty($courseInfo)) { $time_spent_on_the_course = api_time_to_hms( Tracking::get_time_spent_on_the_course( $user_info['user_id'], $courseInfo['real_id'], $sessionId ) ); } // get information about connections on the platform by student $first_connection_date = Tracking::get_first_connection_date($user_info['user_id']); if ($first_connection_date == '') { $first_connection_date = get_lang('NoConnexion'); } $last_connection_date = Tracking::get_last_connection_date( $user_info['user_id'], true ); if ($last_connection_date == '') { $last_connection_date = get_lang('NoConnexion'); } // cvs information $csv_content[] = [ get_lang('Information'), ]; $csv_content[] = [ get_lang('Name'), get_lang('Email'), get_lang('Tel'), ]; $csv_content[] = [ $user_info['complete_name'], $user_info['email'], $user_info['phone'], ]; $csv_content[] = []; // csv tracking $csv_content[] = [ get_lang('Tracking'), ]; $csv_content[] = [ get_lang('FirstLoginInPlatform'), get_lang('LatestLoginInPlatform'), get_lang('TimeSpentInTheCourse'), get_lang('Progress'), get_lang('Score'), ]; $csv_content[] = [ strip_tags($first_connection_date), strip_tags($last_connection_date), $time_spent_on_the_course, $avg_student_progress.'%', $avg_student_score, ]; $coachs_name = ''; $session_name = ''; $table_title = Display::return_icon('user.png', get_lang('User')).$user_info['complete_name']; echo Display::page_subheader($table_title); $userPicture = UserManager::getUserPicture($user_info['user_id'], USER_IMAGE_SIZE_BIG); $userGroupManager = new UserGroup(); $userGroups = $userGroupManager->getNameListByUser( $user_info['user_id'], UserGroup::NORMAL_CLASS ); ?>
'; echo ''; $startDate = UserManager::get_extra_user_data_by_field( $user_info['user_id'], 'datedebutstage' ); $endDate = UserManager::get_extra_user_data_by_field( $user_info['user_id'], 'datefinstage' ); $extraField = new ExtraField('user'); $extraFieldInfoStart = $extraField->get_handler_field_info_by_field_variable( 'datedebutstage' ); $extraFieldInfoEnd = $extraField->get_handler_field_info_by_field_variable( 'datefinstage' ); echo ''; echo ''; /** @var ExtraFieldSavedSearch $saved */ $search = [ 'user' => $student_id, ]; $items = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findBy($search); $listVariables = [ 'ecouter', 'lire', 'ecrire', 's_exprimer_oralement_en_continu', 'participer_a_une_conversation', ]; $extraField = new ExtraField('session'); if ($items) { /** @var ExtraFieldSavedSearch $item */ foreach ($items as $item) { $variable = $item->getField()->getVariable(); if (in_array($variable, $listVariables)) { $extraFieldInfo = $extraField->get_handler_field_info_by_field_variable($variable); if ($extraFieldInfo) { echo ''; } } } } // Display timezone if the user selected one and if the admin allows the use of user's timezone $timezone = null; $timezone_user = UserManager::get_extra_user_data_by_field( $user_info['user_id'], 'timezone' ); $use_users_timezone = api_get_setting('use_users_timezone', 'timezones'); if ($timezone_user['timezone'] != null && $use_users_timezone == 'true' ) { $timezone = $timezone_user['timezone']; } if ($timezone !== null) { ?>
'.$user_info['email'].'' : get_lang('NoEmail'); ?>
$student_id, 'course' => $course_code, 'origin' => $origin, 'cidReq' => $course_code, 'id_session' => $sessionId, ] ), ['class' => 'btn btn-default'] ); ?>
'; echo get_lang('StudentBoss').' : '; foreach ($bossList as $boss) { $bossInfo = api_get_user_info($boss['boss_id']); if ($bossInfo) { echo $bossInfo['complete_name_with_username'].'
'; } } echo '
'; echo get_lang('Language').' : '; $languageId = api_get_language_id($user_info['language']); if ($languageId) { $languageInfo = api_get_language_info($languageId); echo $languageInfo['original_name']; } echo '
'; echo $extraFieldInfoStart['display_text'].' : '; if (isset($startDate['datedebutstage'])) { echo $startDate['datedebutstage']; } echo '
'; echo $extraFieldInfoEnd['display_text'].' : '; if (isset($endDate['datefinstage'])) { echo $endDate['datefinstage']; } echo '
'; $options = $extraFieldInfo['options']; $optionValues = array_column($options, 'display_text', 'option_value'); //var_dump($optionValues); echo $extraFieldInfo['display_text'].' : '; $answers = $item->getValue(); $list = []; if (is_array($answers)) { foreach ($answers as $answer) { $list[] = $optionValues[$answer]; } } else { foreach ($options as $option) { $answers = trim($answers, '.'); $answers = str_replace('-', '_', $answers); if ($option['option_value'] != api_underscore_to_camel_case($answers)) { continue; } $list[] = $option['display_text']; } } echo '
  • '; echo implode('
  • ', $list); echo '
'; echo '
get_values_by_handler_and_field_variable( $student_id, 'legal_accept' ); $icon = Display::return_icon('accept_na.png'); if (isset($value['value']) && !empty($value['value'])) { list($legalId, $legalLanguageId, $legalTime) = explode(':', $value['value']); $icon = Display::return_icon('accept.png').' '.api_get_local_time($legalTime); $icon .= ' '.Display::url( get_lang('DeleteLegal'), api_get_self().'?action=delete_legal&student='.$student_id.'&course='.$course_code, ['class' => 'btn btn-danger btn-xs'] ); } else { $icon .= ' '.Display::url( get_lang('SendLegal'), api_get_self().'?action=send_legal&student='.$student_id.'&course='.$course_code, ['class' => 'btn btn-primary btn-xs'] ); } echo ''; } } $icon = ' '.Display::url( get_lang('Generate'), api_get_self().'?action=generate_certificate&student='.$student_id.'&cidReq='.$course_code.'&course='.$course_code, ['class' => 'btn btn-primary btn-xs'] ); echo ''; ?>
'absmiddle', 'hspace' => '3px'] ); ?>
'absmiddle', 'hspace' => '3px'] ); ?>
'; echo get_lang('LegalAccepted').' '.$icon; echo '
'; echo get_lang('Certificate').' '.$icon; echo '
$courses) { $session_name = ''; $access_start_date = ''; $access_end_date = ''; $date_session = ''; $title = Display::return_icon('course.png', get_lang('Courses')).' '.get_lang('Courses'); $session_info = api_get_session_info($sId); if ($session_info) { $session_name = $session_info['name']; if (!empty($session_info['access_start_date'])) { $access_start_date = api_format_date($session_info['access_start_date'], DATE_FORMAT_SHORT); } if (!empty($session_info['access_end_date'])) { $access_end_date = api_format_date($session_info['access_end_date'], DATE_FORMAT_SHORT); } if (!empty($access_start_date) && !empty($access_end_date)) { $date_session = get_lang('From').' '.$access_start_date.' '.get_lang('Until').' '.$access_end_date; } $title = Display::return_icon('session.png', get_lang('Session')) .' '.$session_name.($date_session ? ' ('.$date_session.')' : ''); } // Courses echo '

'.$title.'

'; echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; $csvRow = [ '', get_lang('Course'), get_lang('Time'), get_lang('Progress'), get_lang('Score'), get_lang('AttendancesFaults'), get_lang('Evaluations'), get_lang('Details'), ]; $exportCourseList[$sId][] = $csvRow; if (!empty($courses)) { $totalCourseTime = 0; $totalAttendance = [0, 0]; $totalScore = 0; $totalProgress = 0; $gradeBookTotal = [0, 0]; $totalEvaluations = '0/0 (0%)'; $totalCourses = count($courses); $scoreDisplay = ScoreDisplay::instance(); foreach ($courses as $courseId) { $courseInfoItem = api_get_course_info_by_id($courseId); $courseId = $courseInfoItem['real_id']; $courseCodeItem = $courseInfoItem['code']; if (empty($session_info)) { $isSubscribed = CourseManager::is_user_subscribed_in_course( $student_id, $courseCodeItem, false ); } else { $isSubscribed = CourseManager::is_user_subscribed_in_course( $student_id, $courseCodeItem, true, $sId ); } if ($isSubscribed) { $timeInSeconds = Tracking::get_time_spent_on_the_course( $user_info['user_id'], $courseId, $sId ); $totalCourseTime += $timeInSeconds; $time_spent_on_course = api_time_to_hms($timeInSeconds); // get average of faults in attendances by student $results_faults_avg = $attendance->get_faults_average_by_course( $student_id, $courseCodeItem, $sId ); $attendances_faults_avg = '0/0 (0%)'; if (!empty($results_faults_avg['total'])) { if (api_is_drh()) { $attendances_faults_avg = '' .$results_faults_avg['faults'].'/'.$results_faults_avg['total'].' (' .$results_faults_avg['porcent'].'%)'; } else { $attendances_faults_avg = $results_faults_avg['faults'].'/' .$results_faults_avg['total'] .' ('.$results_faults_avg['porcent'].'%)'; } $totalAttendance[0] += $results_faults_avg['faults']; $totalAttendance[1] += $results_faults_avg['total']; } // Get evaluations by student $cats = Category::load( null, null, $courseCodeItem, null, null, $sId ); $scoretotal = []; if (isset($cats) && isset($cats[0])) { if (!empty($sId)) { $scoretotal = $cats[0]->calc_score($student_id, null, $courseCodeItem, $sId); } else { $scoretotal = $cats[0]->calc_score($student_id, null, $courseCodeItem); } } $scoretotal_display = '0/0 (0%)'; if (!empty($scoretotal) && !empty($scoretotal[1])) { $scoretotal_display = round($scoretotal[0], 1).'/'. round($scoretotal[1], 1). ' ('.round(($scoretotal[0] / $scoretotal[1]) * 100, 2).' %)'; $gradeBookTotal[0] += $scoretotal[0]; $gradeBookTotal[1] += $scoretotal[1]; } $progress = Tracking::get_avg_student_progress( $user_info['user_id'], $courseCodeItem, [], $sId ); $totalProgress += $progress; $score = Tracking::get_avg_student_score( $user_info['user_id'], $courseCodeItem, [], $sId ); if (is_numeric($score)) { $totalScore += $score; } $progress = empty($progress) ? '0%' : $progress.'%'; $score = empty($score) ? '0%' : $score.'%'; $csvRow = [ $session_name, $courseInfoItem['title'], $time_spent_on_course, $progress, $score, $attendances_faults_avg, $scoretotal_display, ]; $csv_content[] = $csvRow; $exportCourseList[$sId][] = $csvRow; echo ''; if (!empty($coachId)) { echo ''; } else { echo ''; } echo ''; } } $totalAttendanceFormatted = $scoreDisplay->display_score($totalAttendance); $totalScoreFormatted = $scoreDisplay->display_score([$totalScore / $totalCourses, 100], SCORE_AVERAGE); $totalProgressFormatted = $scoreDisplay->display_score( [$totalProgress / $totalCourses, 100], SCORE_AVERAGE ); $totalEvaluations = $scoreDisplay->display_score($gradeBookTotal); $totalTimeFormatted = api_time_to_hms($totalCourseTime); echo ''; $csvRow = [ get_lang('Total'), '', $totalTimeFormatted, $totalProgressFormatted, $totalScoreFormatted, $totalAttendanceFormatted, $totalEvaluations, '', ]; $csv_content[] = $csvRow; $exportCourseList[$sId][] = $csvRow; $sessionAction = Display::url( Display::return_icon('export_csv.png', get_lang('ExportAsCSV'), [], ICON_SIZE_MEDIUM), $currentUrl .'&' .http_build_query( ['action' => 'export_one_session_row', 'export' => 'csv', 'session_to_export' => $sId] ) ); $sessionAction .= Display::url( Display::return_icon('export_excel.png', get_lang('ExportAsXLS'), [], ICON_SIZE_MEDIUM), $currentUrl .'&' .http_build_query( ['action' => 'export_one_session_row', 'export' => 'xls', 'session_to_export' => $sId] ) ); if (!empty($sId)) { $sessionAction .= Display::url( Display::return_icon('pdf.png', get_lang('ExportToPDF'), [], ICON_SIZE_MEDIUM), $currentUrl .'&' .http_build_query( ['action' => 'export_to_pdf', 'session_to_export' => $sId] ) ); } echo $sessionAction; } else { echo ""; } Session::write('export_course_list', $exportCourseList); echo ''; echo '
'.get_lang('Course').' '.get_lang('Time').' '.get_lang('Progress').' '.get_lang('Score').' '.get_lang('AttendancesFaults').' '.get_lang('Evaluations').' '.get_lang('Details').'
'. $courseInfoItem['title'].' '.$time_spent_on_course.' '.$progress.' '.$score.' '.$attendances_faults_avg.' '.$scoretotal_display.'' .Display::return_icon('2rightarrow.png', get_lang('Details')).'' .Display::return_icon('2rightarrow.png', get_lang('Details')).'
'.get_lang('Total').' '.$totalTimeFormatted.' '.$totalProgressFormatted.' '.$totalScoreFormatted.' '.$totalAttendanceFormatted.' '.$totalEvaluations.'
".get_lang('NoCourse')."
'; echo '
'; } } else { $trackingColumns = api_get_configuration_value('tracking_columns'); $columnHeaders = [ 'lp' => get_lang('LearningPath'), 'time' => get_lang('Time'). Display::return_icon( 'info3.gif', get_lang('TotalTimeByCourse'), ['align' => 'absmiddle', 'hspace' => '3px'] ), 'best_score' => get_lang('BestScore'), 'latest_attempt_avg_score' => get_lang('LatestAttemptAverageScore'). Display::return_icon( 'info3.gif', get_lang('AverageIsCalculatedBasedInTheLatestAttempts'), ['align' => 'absmiddle', 'hspace' => '3px'] ), 'progress' => get_lang('Progress'). Display::return_icon( 'info3.gif', get_lang('LPProgressScore'), ['align' => 'absmiddle', 'hspace' => '3px'] ), 'last_connection' => get_lang('LastConnexion'). Display::return_icon( 'info3.gif', get_lang('LastTimeTheCourseWasUsed'), ['align' => 'absmiddle', 'hspace' => '3px'] ), ]; $timeCourse = null; if (Tracking::minimumTimeAvailable($sessionId, $courseInfo['real_id'])) { $timeCourse = Tracking::getCalculateTime($student_id, $courseInfo['real_id'], $sessionId); } if ($user_info['status'] != INVITEE) { $csv_content[] = []; $csv_content[] = [str_replace(' ', '', strip_tags($userInfo['complete_name']))]; $trackingColumns = api_get_configuration_value('tracking_columns'); if (isset($trackingColumns['my_students_lp'])) { foreach ($columnHeaders as $key => $value) { if (!isset($trackingColumns['my_progress_lp'][$key]) || $trackingColumns['my_students_lp'][$key] == false ) { unset($columnHeaders[$key]); } } } $headers = ''; $columnHeadersToExport = []; // csv export headers foreach ($columnHeaders as $key => $columnName) { $columnHeadersToExport[] = strip_tags($columnName); $headers .= Display::tag( 'th', $columnName ); } $csv_content[] = $columnHeadersToExport; $columnHeadersKeys = array_keys($columnHeaders); $categoriesTempList = learnpath::getCategories($courseInfo['real_id']); $categoryTest = new CLpCategory(); $categoryTest->setId(0); $categoryTest->setName(get_lang('WithOutCategory')); $categoryTest->setPosition(0); $categories = [ $categoryTest, ]; if (!empty($categoriesTempList)) { $categories = array_merge($categories, $categoriesTempList); } $userEntity = api_get_user_entity(api_get_user_id()); /** @var CLpCategory $item */ foreach ($categories as $item) { $categoryId = $item->getId(); if (!learnpath::categoryIsVisibleForStudent($item, $userEntity, $courseInfo['real_id'], $sessionId)) { continue; } $list = new LearnpathList( api_get_user_id(), $courseInfo, $sessionId, null, false, $categoryId, false, true ); $flat_list = $list->get_flat_list(); $i = 0; if (count($categories) > 1) { echo Display::page_subheader2($item->getName()); } echo '
'; echo ''; echo $headers; echo ''; if (api_is_allowed_to_edit()) { echo ''; } echo ''; foreach ($flat_list as $learnpath) { $lpIdList[] = $learnpath['iid']; $lp_id = $learnpath['lp_old_id']; $lp_name = $learnpath['lp_name']; $any_result = false; // Get progress in lp $progress = Tracking::get_avg_student_progress( $student_id, $course_code, [$lp_id], $sessionId ); if ($progress === null) { $progress = '0%'; } else { $any_result = true; } // Get time in lp if (!empty($timeCourse)) { $lpTime = isset($timeCourse[TOOL_LEARNPATH]) ? $timeCourse[TOOL_LEARNPATH] : 0; $total_time = isset($lpTime[$lp_id]) ? (int) $lpTime[$lp_id] : 0; } else { $total_time = Tracking::get_time_spent_in_lp( $student_id, $course_code, [$lp_id], $sessionId ); } if (!empty($total_time)) { $any_result = true; } // Get last connection time in lp $start_time = Tracking::get_last_connection_time_in_lp( $student_id, $course_code, $lp_id, $sessionId ); if (!empty($start_time)) { $start_time = api_convert_and_format_date($start_time, DATE_TIME_FORMAT_LONG); } else { $start_time = '-'; } if (!empty($total_time)) { $any_result = true; } // Quiz in lp $score = Tracking::get_avg_student_score( $student_id, $course_code, [$lp_id], $sessionId ); // Latest exercise results in a LP $score_latest = Tracking::get_avg_student_score( $student_id, $course_code, [$lp_id], $sessionId, false, true ); $bestScore = Tracking::get_avg_student_score( $student_id, $course_code, [$lp_id], $sessionId, false, false, true ); if (empty($bestScore)) { $bestScore = ''; } else { $bestScore = $bestScore.'%'; } if ($i % 2 == 0) { $css_class = 'row_even'; } else { $css_class = 'row_odd'; } $i++; if (isset($score_latest) && !is_null($score_latest)) { if (is_numeric($score_latest)) { $score_latest = $score_latest.'%'; } } if (is_numeric($progress)) { $progress = $progress.'%'; } else { $progress = '-'; } echo ''; $contentToExport = []; if (in_array('lp', $columnHeadersKeys)) { $contentToExport[] = api_html_entity_decode( stripslashes($lp_name), ENT_QUOTES, $charset ); echo Display::tag('td', stripslashes($lp_name)); } if (in_array('time', $columnHeadersKeys)) { $contentToExport[] = api_time_to_hms($total_time); echo Display::tag('td', api_time_to_hms($total_time)); } if (in_array('best_score', $columnHeadersKeys)) { $contentToExport[] = $bestScore; echo Display::tag('td', $bestScore); } if (in_array('latest_attempt_avg_score', $columnHeadersKeys)) { $contentToExport[] = $score_latest; echo Display::tag('td', $score_latest); } if (in_array('progress', $columnHeadersKeys)) { $contentToExport[] = $progress; echo Display::tag('td', $progress); } if (in_array('last_connection', $columnHeadersKeys)) { // Do not change with api_convert_and_format_date, because this value came from the lp_item_view table // which implies several other changes not a priority right now $contentToExport[] = $start_time; echo Display::tag('td', $start_time); } $csv_content[] = $contentToExport; if ($any_result === true) { $from = ''; if ($from_myspace) { $from = '&from=myspace'; } $link = Display::url( Display::return_icon('2rightarrow.png', get_lang('Details')), 'lp_tracking.php?cidReq='.$course_code.'&course='.$course_code.$from.'&origin='.$origin .'&lp_id='.$lp_id.'&student_id='.$user_info['user_id'].'&id_session='.$sessionId ); echo Display::tag('td', $link); } if (api_is_allowed_to_edit()) { echo ''; echo ''; } } echo '
'.get_lang('Details').''.get_lang('ResetLP').'
'; if ($any_result === true) { $url = 'myStudents.php?action=reset_lp&sec_token='.$token.'&cidReq='.$course_code.'&course=' .$course_code.'&details='.$details.'&origin='.$origin.'&lp_id='.$lp_id.'&student=' .$user_info['user_id'].'&details=true&id_session='.$sessionId; echo Display::url( Display::return_icon('clean.png', get_lang('Clean')), $url, [ 'onclick' => "javascript:if(!confirm('" .addslashes( api_htmlentities(get_lang('AreYouSureToDelete')) ) ."')) return false;", ] ); } echo '
'; } } if ($user_info['status'] != INVITEE) { echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $csv_content[] = []; $csv_content[] = [ get_lang('Exercises'), get_lang('LearningPath'), get_lang('AvgCourseScore'), get_lang('Attempts'), ]; $t_quiz = Database::get_course_table(TABLE_QUIZ_TEST); $sessionCondition = api_get_session_condition( $sessionId, true, true, 'quiz.session_id' ); $sql = "SELECT quiz.title, id FROM $t_quiz AS quiz WHERE quiz.c_id = ".$courseInfo['real_id']." AND active IN (0, 1) $sessionCondition ORDER BY quiz.title ASC "; $result_exercices = Database::query($sql); $i = 0; if (Database::num_rows($result_exercices) > 0) { while ($exercices = Database::fetch_array($result_exercices)) { $exercise_id = (int) $exercices['id']; $count_attempts = Tracking::count_student_exercise_attempts( $student_id, $courseInfo['real_id'], $exercise_id, 0, 0, $sessionId, 2 ); $score_percentage = Tracking::get_avg_student_exercise_score( $student_id, $course_code, $exercise_id, $sessionId, 1, 0 ); if (!isset($score_percentage) && $count_attempts > 0) { $scores_lp = Tracking::get_avg_student_exercise_score( $student_id, $course_code, $exercise_id, $sessionId, 2, 1 ); $score_percentage = $scores_lp[0]; $lp_name = $scores_lp[1]; } else { $lp_name = '-'; } $lp_name = !empty($lp_name) ? $lp_name : get_lang('NoLearnpath'); $css_class = 'row_even'; if ($i % 2) { $css_class = 'row_odd'; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $data_exercices[$i][] = $exercices['title']; $data_exercices[$i][] = $score_percentage.'%'; $data_exercices[$i][] = $count_attempts; $csv_content[] = [ $exercices['title'], $lp_name, $score_percentage, $count_attempts, ]; $i++; } } else { echo ''; } echo '
'.get_lang('Exercises').''.get_lang('LearningPath').''.get_lang('AvgCourseScore').' '. Display::return_icon( 'info3.gif', get_lang('AverageScore'), ['align' => 'absmiddle', 'hspace' => '3px'] ).''.get_lang('Attempts').''.get_lang('LatestAttempt').''.get_lang('AllAttempts').'
'.$exercices['title'].''; if (!empty($lp_name)) { echo $lp_name; } else { echo '-'; } echo ''; if ($count_attempts > 0) { echo $score_percentage.'%'; } else { echo '-'; $score_percentage = 0; } echo ''.$count_attempts.''; $sql = 'SELECT exe_id FROM '.$tbl_stats_exercices.' WHERE exe_exo_id = "'.$exercise_id.'" AND exe_user_id ="'.$student_id.'" AND c_id = '.$courseInfo['real_id'].' AND session_id = "'.$sessionId.'" AND status = "" ORDER BY exe_date DESC LIMIT 1'; $result_last_attempt = Database::query($sql); if (Database::num_rows($result_last_attempt) > 0) { $id_last_attempt = Database::result($result_last_attempt, 0, 0); if ($count_attempts > 0) { $qualifyLink = ''; if ($allowToQualify) { $qualifyLink = '&action=qualify'; } $attemptLink = '../exercise/exercise_show.php?id='.$id_last_attempt.'&cidReq='.$course_code .'&id_session='.$sessionId.'&session_id='.$sessionId.'&student='.$student_id.'&origin=' .(empty($origin) ? 'tracking' : $origin).$qualifyLink; echo Display::url( Display::return_icon('quiz.png', get_lang('Exercise')), $attemptLink ); } } echo ''; if ($count_attempts > 0) { $all_attempt_url = "../exercise/exercise_report.php?exerciseId=$exercise_id&" ."cidReq=$course_code&filter_by_user=$student_id&id_session=$sessionId"; echo Display::url( Display::return_icon( 'test_results.png', get_lang('AllAttempts'), [], ICON_SIZE_SMALL ), $all_attempt_url ); } echo '
'.get_lang('NoExercise').'
'; } // @when using sessions we do not show the survey list if (empty($sessionId)) { $survey_list = SurveyManager::get_surveys($course_code, $sessionId); if (!empty($survey_list)) { $survey_data = []; foreach ($survey_list as $survey) { $user_list = SurveyManager::get_people_who_filled_survey( $survey['survey_id'], false, $courseInfo['real_id'] ); $survey_done = Display::return_icon( "accept_na.png", get_lang('NoAnswer'), [], ICON_SIZE_SMALL ); if (in_array($student_id, $user_list)) { $survey_done = Display::return_icon( "accept.png", get_lang('Answered'), [], ICON_SIZE_SMALL ); } $data = ['title' => $survey['title'], 'done' => $survey_done]; $survey_data[] = $data; } if (!empty($survey_data)) { $table = new HTML_Table(['class' => 'data_table']); $header_names = [get_lang('Survey'), get_lang('Answered')]; $row = 0; $column = 0; foreach ($header_names as $item) { $table->setHeaderContents($row, $column, $item); $column++; } $row = 1; foreach ($survey_data as $data) { $column = 0; $table->setCellContents($row, $column, $data); $class = 'class="row_odd"'; if ($row % 2) { $class = 'class="row_even"'; } $table->setRowAttributes($row, $class, true); $column++; $row++; } echo $table->toHtml(); } } } require_once '../work/work.lib.php'; $userWorks = getWorkPerUser($student_id, $courseInfo['real_id'], $sessionId); echo '
'; $workingTime = api_get_configuration_value('considered_working_time'); foreach ($userWorks as $work) { $work = $work['work']; foreach ($work->user_results as $key => $results) { echo ''; echo ''; $documentNumber = $key + 1; $url = api_get_path(WEB_CODE_PATH).'work/view.php?cidReq='.$course_code.'&id_session='.$sessionId.'&id=' .$results['id']; echo ''; $qualification = !empty($results['qualification']) ? $results['qualification'] : '-'; echo ''; echo ''; $assignment = get_work_assignment_by_id($work->id, $courseInfo['real_id']); echo ''; $fieldValue = new ExtraFieldValue('work'); $resultExtra = $fieldValue->getAllValuesForAnItem( $work->iid, true ); foreach ($resultExtra as $field) { $field = $field['value']; if ($workingTime == $field->getField()->getVariable()) { echo ''; } } echo ''; } } echo '
'.get_lang('Tasks').' '.get_lang('DocumentNumber').' '.get_lang('Note').' '.get_lang('HandedOut').' '.get_lang('HandOutDateLimit').' '.get_lang('ConsideredWorkingTime').'
'.$work->title.'('.$documentNumber.')'.$qualification.''.$results['formatted_date'].''; if (!empty($assignment['expires_on'])) { echo api_convert_and_format_date($assignment['expires_on']); } echo ''.$field->getValue().'
'; echo '
'; $csv_content[] = []; $nb_assignments = Tracking::count_student_assignments($student_id, $course_code, $sessionId); $messages = Tracking::count_student_messages($student_id, $course_code, $sessionId); $links = Tracking::count_student_visited_links($student_id, $courseInfo['real_id'], $sessionId); $chat_last_connection = Tracking::chat_last_connection($student_id, $courseInfo['real_id'], $sessionId); $documents = Tracking::count_student_downloaded_documents($student_id, $courseInfo['real_id'], $sessionId); $uploaded_documents = Tracking::count_student_uploaded_documents($student_id, $course_code, $sessionId); $csv_content[] = [ get_lang('OtherTools'), ]; $csv_content[] = [ get_lang('Student_publication'), $nb_assignments, ]; $csv_content[] = [ get_lang('Messages'), $messages, ]; $csv_content[] = [ get_lang('LinksDetails'), $links, ]; $csv_content[] = [ get_lang('DocumentsDetails'), $documents, ]; $csv_content[] = [ get_lang('UploadedDocuments'), $uploaded_documents, ]; $csv_content[] = [ get_lang('ChatLastConnection'), $chat_last_connection, ]; ?>
'.get_lang('OtherTools').'
"$('#compose_message').show();", 'class' => 'btn btn-default', ] ); $form = new FormValidator( 'messages', 'post', $currentUrl.'&action=send_message' ); $form->addHtml(''); $form->display(); } $allow = api_get_configuration_value('allow_user_message_tracking'); if ($allow && (api_is_drh() || api_is_platform_admin())) { $users = MessageManager::getUsersThatHadConversationWithUser($student_id); echo Display::page_subheader2(get_lang('MessageTracking')); $table = new HTML_Table(['class' => 'table']); $column = 0; $row = 0; $headers = [ get_lang('User'), ]; foreach ($headers as $header) { $table->setHeaderContents($row, $column, $header); $column++; } $column = 0; $row++; foreach ($users as $userFollowed) { $followedUserId = $userFollowed['user_id']; $url = api_get_path(WEB_CODE_PATH).'tracking/messages.php?from_user='.$student_id.'&to_user='.$followedUserId; $link = Display::url( $userFollowed['complete_name'], $url ); $table->setCellContents($row, $column, $link); $row++; } $table->display(); } if ($pluginCalendar) { echo $plugin->getUserStatsPanel($student_id, $courses_in_session); } if ($export) { ob_end_clean(); switch ($export) { case 'csv': Export::arrayToCsv($csv_content, 'reporting_student'); break; case 'xls': Export::arrayToXls($csv_content, 'reporting_student'); break; } exit; } Display::display_footer();