function show_image(image,width,height) { width = parseInt(width) + 20; height = parseInt(height) + 20; window_x = window.open(image,\'windowX\',\'width=\'+ width + \', height=\'+ height + \'\'); } '; if ($export) { ob_start(); } $csv_content = array(); $from_myspace = false; if (isset($_GET['from']) && $_GET['from'] == 'myspace') { $from_myspace = true; $this_section = SECTION_TRACKING; } else { $this_section = SECTION_COURSES; } $nameTools = get_lang('StudentDetails'); $em = Database::getManager(); if (isset($_GET['details'])) { if ($origin === 'user_course') { if (empty($cidReq)) { $interbreadcrumb[] = array( "url" => api_get_path(WEB_COURSE_PATH).$courseInfo['directory'], 'name' => $courseInfo['title'] ); } $interbreadcrumb[] = array( "url" => "../user/user.php?cidReq=".$course_code, "name" => get_lang("Users") ); } else { if ($origin === 'tracking_course') { $interbreadcrumb[] = array( "url" => "../tracking/courseLog.php?cidReq=".$course_code.'&id_session='.api_get_session_id(), "name" => get_lang("Tracking") ); } else { if ($origin === 'resume_session') { $interbreadcrumb[] = array( 'url' => "../session/session_list.php", "name" => get_lang('SessionList') ); $interbreadcrumb[] = array( 'url' => "../session/resume_session.php?id_session=".$sessionId, "name" => get_lang('SessionOverview') ); } else { $interbreadcrumb[] = array( "url" => api_is_student_boss() ? "#" : "index.php", "name" => get_lang('MySpace') ); if (isset($_GET['id_coach']) && intval($_GET['id_coach']) != 0) { $interbreadcrumb[] = array( "url" => "student.php?id_coach=".Security::remove_XSS($_GET['id_coach']), "name" => get_lang("CoachStudents") ); $interbreadcrumb[] = array( "url" => "myStudents.php?student=".$student_id.'&id_coach='.Security::remove_XSS($_GET['id_coach']), "name" => get_lang("StudentDetails") ); } else { $interbreadcrumb[] = array( "url" => "student.php", "name" => get_lang("MyStudents") ); $interbreadcrumb[] = array( "url" => "myStudents.php?student=".$student_id, "name" => get_lang("StudentDetails") ); } } } } $nameTools = get_lang("DetailsStudentInCourse"); } else { if ($origin == 'resume_session') { $interbreadcrumb[] = array( 'url' => "../session/session_list.php", "name" => get_lang('SessionList') ); if (!empty($sessionId)) { $interbreadcrumb[] = array( 'url' => "../session/resume_session.php?id_session=".$sessionId, "name" => get_lang('SessionOverview') ); } } else { $interbreadcrumb[] = array( "url" => api_is_student_boss() ? "#" : "index.php", "name" => get_lang('MySpace') ); if (isset($_GET['id_coach']) && intval($_GET['id_coach']) != 0) { if ($sessionId) { $interbreadcrumb[] = array( "url" => "student.php?id_coach=".Security::remove_XSS($_GET['id_coach'])."&id_session=".$sessionId, "name" => get_lang("CoachStudents") ); } else { $interbreadcrumb[] = array( "url" => "student.php?id_coach=".Security::remove_XSS($_GET['id_coach']), "name" => get_lang("CoachStudents") ); } } else { $interbreadcrumb[] = array( "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); if (isset($_GET['user_id']) && $_GET['user_id'] != "") { $user_id = intval($_GET['user_id']); } else { $user_id = api_get_user_id(); } // Action behaviour $action = isset($_GET['action']) ? $_GET['action'] : ''; switch ($action) { case 'send_legal': $subject = get_lang('SendLegalSubject'); $content = sprintf( get_lang('SendLegalDescriptionToUrlX'), api_get_path(WEB_PATH) ); MessageManager::send_message_simple($student_id, $subject, $content); Display::addFlash(Display::return_message(get_lang('Sent'))); break; case 'delete_legal': $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']) ? intval($_GET['lp_id']) : ''; if (api_is_allowed_to_edit() && !empty($lp_id) && !empty($student_id) ) { 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 $message = Display::return_message( get_lang('LPWasReset'), 'success' ); } break; default: break; } // user info $user_info = api_get_user_info($student_id); $courses_in_session = array(); //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 = array(); $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()); $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 = intval($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 = ".intval($user_info['user_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=' . intval($user_info['user_id']); $rs = Database::query($sql); $tmp_sessions = array(); 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(), api_get_course_info() ); if (api_is_drh() && !api_is_platform_admin()) { if (!empty($student_id)) { if (api_drh_can_access_all_session_content()) { //@todo securize drh with student id /*$users = SessionManager::getAllUsersFromCoursesFromAllSessionFromStatus('drh_all', api_get_user_id()); $userList = array(); foreach ($users as $user) { $userList[] = $user['user_id']; } if (!in_array($student_id, $userList)) { api_not_allowed(true); }*/ } else { if (!($isDrhOfCourse)) { if (api_is_drh() && !UserManager::is_user_followed_by_drh($student_id, api_get_user_id()) ) { api_not_allowed(true); } } } } } Display :: display_header($nameTools); if (isset($message)) { echo $message; } $token = Security::get_token(); if (!empty($student_id)) { // 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).' '; 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).''; } if (api_can_login_as($student_id)) { echo ''. Display::return_icon('login_as.png', get_lang('LoginAs'), null, ICON_SIZE_MEDIUM).'  '; } if (api_is_platform_admin(false, true) || api_is_student_boss()) { 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]) ); } echo '
'; // is the user online ? if (user_is_online($student_id)) { $online = get_lang('Yes'); } else { $online = get_lang('No'); } // get average of score and average of progress by student $avg_student_progress = $avg_student_score = 0; if (CourseManager::is_user_subscribed_in_course($user_info['user_id'], $course_code, true)) { $avg_student_progress = Tracking::get_avg_student_progress( $user_info['user_id'], $course_code, array(), $sessionId ); // the score inside the Reporting table $avg_student_score = Tracking::get_avg_student_score( $user_info['user_id'], $course_code, array(), $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[] = array( get_lang('Information') ); $csv_content[] = array( get_lang('Name'), get_lang('Email'), get_lang('Tel') ); $csv_content[] = array( $user_info['complete_name'], $user_info['email'], $user_info['phone'] ); $csv_content[] = array(); // csv tracking $csv_content[] = array( get_lang('Tracking') ); $csv_content[] = array( get_lang('FirstLoginInPlatform'), get_lang('LatestLoginInPlatform'), get_lang('TimeSpentInTheCourse'), get_lang('Progress'), get_lang('Score') ); $csv_content[] = array( 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'), array(), ICON_SIZE_SMALL ).$user_info['complete_name']; echo Display::page_subheader($table_title); $userPicture = UserManager::getUserPicture($user_info['user_id']); $userGroupManager = new UserGroup(); $userGroups = $userGroupManager->getNameListByUser( $user_info['user_id'], UserGroup::NORMAL_CLASS ); ?>
'.$user_info['email'].''; } else { echo get_lang('NoEmail'); } ?>
get_values_by_handler_and_field_variable($student_id, 'legal_accept'); $icon = Display::return_icon('accept_na.png'); if (isset($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 ''; } } ?>
'absmiddle', 'hspace' => '3px') ); ?>
'absmiddle', 'hspace' => '3px') ); ?>
'; echo get_lang('LegalAccepted').' '.$icon; echo '
$courses) { $session_name = ''; $access_start_date = ''; $access_end_date = ''; $date_session = ''; $title = Display::return_icon( 'course.png', get_lang('Courses'), array(), ICON_SIZE_SMALL ).' '.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'), array(), ICON_SIZE_SMALL).' '.$session_name.($date_session ? ' ('.$date_session.')' : ''); } // Courses echo '

'.$title.'

'; echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; if (!empty($courses)) { foreach ($courses as $courseId) { $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 ); if ($isSubscribed) { $time_spent_on_course = api_time_to_hms( Tracking :: get_time_spent_on_the_course($user_info['user_id'], $courseId, $sId) ); // get average of faults in attendances by student $results_faults_avg = $attendance->get_faults_average_by_course( $student_id, $courseCodeItem, $sId ); 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'].'%)' ; } } else { $attendances_faults_avg = '0/0 (0%)'; } // Get evaluations by student $cats = Category::load( null, null, $courseCodeItem, null, null, $sId ); $scoretotal = array(); 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).' %)'; } $progress = Tracking::get_avg_student_progress( $user_info['user_id'], $courseCodeItem, null, $sId ); $score = Tracking:: get_avg_student_score( $user_info['user_id'], $courseCodeItem, null, $sId ); $progress = empty($progress) ? '0%' : $progress.'%'; $score = empty($score) ? '0%' : $score.'%'; $csv_content[] = array( $session_name, $courseInfoItem['title'], $time_spent_on_course, $progress, $score, $attendances_faults_avg, $scoretotal_display ); echo ''; if (isset($_GET['id_coach']) && intval($_GET['id_coach']) != 0) { echo ''; } else { echo ''; } echo ''; } } } else { echo ""; } 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('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'), array('align' => 'absmiddle', 'hspace' => '3px') ), 'best_score' => get_lang('BestScore'), 'latest_attempt_avg_score' => get_lang('LatestAttemptAverageScore'). Display::return_icon( 'info3.gif', get_lang('AverageIsCalculatedBasedInTheLatestAttempts'), array('align' => 'absmiddle', 'hspace' => '3px') ), 'progress'=> get_lang('Progress'). Display::return_icon( 'info3.gif', get_lang('LPProgressScore'), array('align' => 'absmiddle', 'hspace' => '3px') ), 'last_connection' => get_lang('LastConnexion'). Display::return_icon( 'info3.gif', get_lang('LastTimeTheCourseWasUsed'), array('align' => 'absmiddle', 'hspace' => '3px') ) ]; if ($user_info['status'] != INVITEE) { $csv_content[] = array(); $csv_content[] = array(str_replace(' ', '', $table_title)); $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); // @todo use LearnpathList class if (empty($sessionId)) { $dql = ' SELECT lp FROM ChamiloCourseBundle:CLp lp WHERE (lp.sessionId = 0 OR lp.sessionId IS NULL) AND lp.cId = :course ORDER BY lp.displayOrder ASC '; $query = $em->createQuery($dql); $query->setParameters([ 'course' => $courseInfo['real_id'] ]); } else { $dql = ' SELECT lp FROM ChamiloCourseBundle:CLp lp WHERE (lp.sessionId = :session OR lp.sessionId = 0 OR lp.sessionId IS NULL) AND lp.cId = :course ORDER BY lp.displayOrder ASC '; $query = $em->createQuery($dql); $query->setParameters([ 'session' => $sessionId, 'course' => $courseInfo['real_id'] ]); } $lps = $query->getResult(); if (count($lps) > 0) { echo '
'; echo ''; echo $headers; echo ''; if (api_is_allowed_to_edit()) { echo ''; } echo ''; $i = 0; /** @var CLp $learnpath */ foreach ($lps as $learnpath) { $lp_id = $learnpath->getId(); $lp_name = $learnpath->getName(); $any_result = false; // Get progress in lp $progress = Tracking::get_avg_student_progress( $student_id, $course_code, array($lp_id), $sessionId ); if ($progress === null) { $progress = '0%'; } else { $any_result = true; } // Get time in lp $total_time = Tracking::get_time_spent_in_lp( $student_id, $course_code, array($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, array($lp_id), $sessionId ); // Latest exercise results in a LP $score_latest = Tracking:: get_avg_student_score( $student_id, $course_code, array($lp_id), $sessionId, false, true ); $bestScore = Tracking::get_avg_student_score( $student_id, $course_code, array($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='.$learnpath->getId().'&student_id='.$user_info['user_id'].'&id_session='.$sessionId ); echo Display::tag('td', $link); } if (api_is_allowed_to_edit()) { echo ''; echo ''; } } ?>
'.get_lang('Details').''.get_lang('ResetLP').'
'; if ($any_result === true) { echo ''; echo Display::return_icon( 'clean.png', get_lang('Clean'), '', ICON_SIZE_SMALL ).''; echo ''; } echo '
0) { while ($exercices = Database :: fetch_array($result_exercices)) { $exercise_id = intval($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'); if ($i % 2) { $css_class = 'row_odd'; } else { $css_class = 'row_even'; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $data_exercices[$i][] = $exercices['title']; $data_exercices[$i][] = $score_percentage.'%'; $data_exercices[$i][] = $count_attempts; $csv_content[] = array( $exercices['title'], $lp_name, $score_percentage, $count_attempts ); $i++; } } else { echo ''; } ?>
'absmiddle', 'hspace' => '3px')) ?>
'.$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) { echo ' '.Display::return_icon('quiz.png').' '; } } 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'), array(), ICON_SIZE_SMALL ), $all_attempt_url ); } echo '
'.get_lang('NoExercise').'
$survey['title'], 'done' => $survey_done); $survey_data[] = $data; } if (!empty($survey_list)) { $table = new HTML_Table(array('class' => 'data_table')); $header_names = array(get_lang('Survey'), get_lang('Answered')); $row = 0; $column = 0; foreach ($header_names as $item) { $table->setHeaderContents($row, $column, $item); $column++; } $row = 1; if (!empty($survey_data)) { 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; 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().'
'; // line about other tools ?>