';
$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 .= '
'.get_lang('FormationUnit').' |
'.get_lang('ConnectionTime').' |
'.get_lang('Progress').' |
'.get_lang('Score').' |
';
$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 .= '
'.
$courseInfoItem['title'].' |
'.$time_spent_on_course.' |
'.$progress.' |
'.$score.' | ';
$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 .= '
'.get_lang('Total').' |
'.$totalTimeFormatted.' |
'.$totalProgressFormatted.' |
'.$totalScoreFormatted.' |
';
$courseTable .= '
';
}
$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
);
?>
|
|
|
|
'.$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 '';
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 ' |
';
$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 $extraFieldInfoStart['display_text'].' : ';
if (isset($startDate['datedebutstage'])) {
echo $startDate['datedebutstage'];
}
echo ' |
';
echo '';
echo $extraFieldInfoEnd['display_text'].' : ';
if (isset($endDate['datefinstage'])) {
echo $endDate['datefinstage'];
}
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 '';
$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 ' |
';
}
}
}
}
// 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) {
?>
|
|
|
|
|
|
|
|
'absmiddle', 'hspace' => '3px']
); ?>
|
|
'absmiddle', 'hspace' => '3px']
); ?>
|
|
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 '
';
echo get_lang('LegalAccepted').' | '.$icon;
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 '
';
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 '
'.get_lang('Course').' |
'.get_lang('Time').' |
'.get_lang('Progress').' |
'.get_lang('Score').' |
'.get_lang('AttendancesFaults').' |
'.get_lang('Evaluations').' |
'.get_lang('Details').' |
';
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 '
'.
$courseInfoItem['title'].' |
'.$time_spent_on_course.' |
'.$progress.' |
'.$score.' |
'.$attendances_faults_avg.' |
'.$scoretotal_display.' | ';
if (!empty($coachId)) {
echo ''
.Display::return_icon('2rightarrow.png', get_lang('Details')).' | ';
} else {
echo ''
.Display::return_icon('2rightarrow.png', get_lang('Details')).' | ';
}
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 '
'.get_lang('Total').' |
'.$totalTimeFormatted.' |
'.$totalProgressFormatted.' |
'.$totalScoreFormatted.' |
'.$totalAttendanceFormatted.' |
'.$totalEvaluations.' |
|
';
$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 "".get_lang('NoCourse')." |
";
}
Session::write('export_course_list', $exportCourseList);
echo '';
echo '
';
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 ''.get_lang('Details').' | ';
if (api_is_allowed_to_edit()) {
echo ''.get_lang('ResetLP').' | ';
}
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 '';
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 ' | ';
echo '
';
}
}
echo '
';
}
}
if ($user_info['status'] != INVITEE) {
echo '
';
echo ''.get_lang('Exercises').' | ';
echo ''.get_lang('LearningPath').' | ';
echo ''.get_lang('AvgCourseScore').' '.
Display::return_icon(
'info3.gif',
get_lang('AverageScore'),
['align' => 'absmiddle', 'hspace' => '3px']
).' | ';
echo ''.get_lang('Attempts').' | ';
echo ''.get_lang('LatestAttempt').' | ';
echo ''.get_lang('AllAttempts').' | ';
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 ''.$exercices['title'].' | ';
echo '';
if (!empty($lp_name)) {
echo $lp_name;
} else {
echo '-';
}
echo ' | ';
echo '';
if ($count_attempts > 0) {
echo $score_percentage.'%';
} else {
echo '-';
$score_percentage = 0;
}
echo ' | ';
echo ''.$count_attempts.' | ';
echo '';
$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 ' | ';
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 ' | ';
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 ''.get_lang('NoExercise').' |
';
}
echo '
';
}
// @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 '
'.get_lang('Tasks').' |
'.get_lang('DocumentNumber').' |
'.get_lang('Note').' |
'.get_lang('HandedOut').' |
'.get_lang('HandOutDateLimit').' |
'.get_lang('ConsideredWorkingTime').' |
';
$workingTime = api_get_configuration_value('considered_working_time');
foreach ($userWorks as $work) {
$work = $work['work'];
foreach ($work->user_results as $key => $results) {
echo '';
echo ''.$work->title.' | ';
$documentNumber = $key + 1;
$url = api_get_path(WEB_CODE_PATH).'work/view.php?cidReq='.$course_code.'&id_session='.$sessionId.'&id='
.$results['id'];
echo '('.$documentNumber.') | ';
$qualification = !empty($results['qualification']) ? $results['qualification'] : '-';
echo ''.$qualification.' | ';
echo ''.$results['formatted_date'].' | ';
$assignment = get_work_assignment_by_id($work->id, $courseInfo['real_id']);
echo '';
if (!empty($assignment['expires_on'])) {
echo api_convert_and_format_date($assignment['expires_on']);
}
echo ' | ';
$fieldValue = new ExtraFieldValue('work');
$resultExtra = $fieldValue->getAllValuesForAnItem(
$work->iid,
true
);
foreach ($resultExtra as $field) {
$field = $field['value'];
if ($workingTime == $field->getField()->getVariable()) {
echo ''.$field->getValue().' | ';
}
}
echo '
';
}
}
echo '
';
echo '
'.get_lang('OtherTools').' |
';
$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,
]; ?>
|
|
|
|
|
|
|
|
|
|
|
|
"$('#compose_message').show();",
'class' => 'btn btn-default',
]
);
$form = new FormValidator(
'messages',
'post',
$currentUrl.'&action=send_message'
);
$form->addHtml('');
$form->addText('subject', get_lang('Subject'));
$form->addHtmlEditor('message', get_lang('Message'));
$form->addButtonSend(get_lang('Send'));
$form->addHidden('sec_token', $token);
$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();