'.COURSE_RELATION_TYPE_RRHH.' '; $rs = Database::query($sql); $courses = array(); while($row = Database :: fetch_array($rs)) { $courses[$row['course_code']] = CourseManager::get_course_information($row['course_code']); } // get the list of sessions where the user is subscribed as student $sql = 'SELECT DISTINCT course_code FROM '.Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER).' WHERE id_user='.intval($_user['user_id']); $rs = Database::query($sql); while($row = Database :: fetch_array($rs)) { $courses[$row['course_code']] = CourseManager::get_course_information($row['course_code']); } echo '
'; echo $nameTools; echo '
'; $now = date('Y-m-d'); ?> '>
'absmiddle', 'hspace' => '3px')); ?>
'; Display::display_icon('2rightarrow_na.gif', get_lang('Details')); } else { echo ''; Display::display_icon('2rightarrow.gif', get_lang('Details')); } echo ''; ?>


0) { // get session name and coach of the session $sql = 'SELECT name, id_coach FROM '.$tbl_session.' WHERE id='.$session_id; $rs = Database::query($sql); $session_name = Database::result($rs, 0, 'name'); $session_coach_id = intval(Database::result($rs, 0, 'id_coach')); $sql = 'SELECT id_user FROM ' . $tbl_session_course_user . ' WHERE id_session=' . $session_id . ' AND course_code = "' . Database :: escape_string($course) . '" AND status=2'; $rs = Database::query($sql); $course_coachs = array(); while ($row_coachs = Database::fetch_array($rs)) { $course_coachs[] = $row_coachs['id_user']; } if (!empty($course_coachs)) { $info_tutor_name = array(); foreach ($course_coachs as $course_coach) { $coach_infos = UserManager :: get_user_info_by_id($course_coach); $info_tutor_name[] = api_get_person_name($coach_infos['firstname'], $coach_infos['lastname']); } $course_info['tutor_name'] = implode(",",$info_tutor_name); } else if($session_coach_id != 0) { $coach_info = UserManager :: get_user_info_by_id($session_coach_id); $course_info['tutor_name'] = api_get_person_name($coach_info['firstname'], $coach_info['lastname']); } } } // end if (api_get_setting('use_session_mode') == 'true') $tableTitle = $course_info['title'].' | '.get_lang('Coach').' : '.$course_info['tutor_name'].((!empty($session_name)) ? ' | '.get_lang('Session').' : '.$session_name : ''); ?> 0) { while($learnpath = Database::fetch_array($result_learnpath)) { $progress = learnpath :: get_db_progress($learnpath['id'], $_user['user_id'], '%', $course_info['db_name']); // calculates last connection time $sql = 'SELECT MAX(start_time) FROM '.$course_info['db_name'].'.'.$tbl_course_lp_view_item.' AS item_view INNER JOIN '.$course_info['db_name'].'.'.$tbl_course_lp_view.' AS view ON item_view.lp_view_id = view.id AND view.lp_id = '.$learnpath['id'].' AND view.user_id = '.$_user['user_id']; $rs = Database::query($sql); $start_time = Database::result($rs, 0, 0); // calculates time $sql = 'SELECT SUM(total_time) FROM '.$course_info['db_name'].'.'.$tbl_course_lp_view_item.' AS item_view INNER JOIN '.$course_info['db_name'].'.'.$tbl_course_lp_view.' AS view ON item_view.lp_view_id = view.id AND view.lp_id = '.$learnpath['id'].' AND view.user_id = '.$_user['user_id']; $rs = Database::query($sql); $total_time = Database::result($rs, 0, 0); echo " "; } } else { echo " "; } ?> 0) { while ($exercices = Database::fetch_array($result_exercices)) { $sql_essais = " SELECT COUNT(ex.exe_id) as essais FROM $tbl_stats_exercices AS ex WHERE ex.exe_user_id='".$_user['user_id']."' AND ex.exe_cours_id = '".$course_info['code']."' AND ex.exe_exo_id = ".$exercices['id']." AND orig_lp_id = 0 AND orig_lp_item_id = 0 " ; $result_essais = Database::query($sql_essais); $essais = Database::fetch_array($result_essais); $sql_score = "SELECT exe_id , exe_result,exe_weighting FROM $tbl_stats_exercices WHERE exe_user_id = ".$_user['user_id']." AND exe_cours_id = '".$course_info['code']."' AND exe_exo_id = ".$exercices['id']." AND orig_lp_id = 0 AND orig_lp_item_id = 0 ORDER BY exe_date DESC LIMIT 1"; $result_score = Database::query($sql_score); $score = 0; while($current_score = Database::fetch_array($result_score)) { $score = $score + $current_score['exe_result']; $weighting = $weighting + $current_score['exe_weighting']; $exe_id = $current_score['exe_id']; } if ($weighting > 0) { // i.e 10.50% $percentage_score = round(($score * 100) / $weighting, 2); } else { $percentage_score = 0; } $weighting = 0; echo ''; if ($exercices['results_disabled'] == 0) { echo ''; echo ''; } else { // we show or not the results if the teacher wants to echo ''; echo ''; } echo ''; } } else { echo ''; } } else { echo ''; } ?>
"; echo stripslashes($learnpath['name']); echo " "; echo api_time_to_hms($total_time); echo " "; echo $progress; echo " "; if ($start_time != '') { echo $last_connection; } else { echo '-'; } echo "
".get_lang('NoLearnpath')."
'; echo $exercices['title']; echo ''; if ($essais['essais'] > 0) { echo $percentage_score.'%'; } else { echo '/'; } echo ''; echo $essais['essais']; echo ' '; if ($essais['essais'] > 0) { echo ' '.Display::return_icon('quiz.gif', get_lang('Quiz')).' '; } echo ''; echo get_lang('CantShowResults'); echo ''; echo ' -- '; echo ' '; echo ' -- '; echo '
'.get_lang('NoEx').'
'.get_lang('NoEx').'