'.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 '
|
|
|
|
|
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 "
";
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 " |
";
}
} else {
echo "
".get_lang('NoLearnpath')."
|
";
}
?>
|
|
|
|
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 '
';
echo $exercices['title'];
echo ' | ';
if ($exercices['results_disabled'] == 0) {
echo '';
if ($essais['essais'] > 0) {
echo $percentage_score.'%';
} else {
echo '/';
}
echo ' | ';
echo '';
echo $essais['essais'];
echo ' |
';
if ($essais['essais'] > 0) {
echo ' '.Display::return_icon('quiz.gif', get_lang('Quiz')).' ';
}
echo ' | ';
} else {
// we show or not the results if the teacher wants to
echo '';
echo get_lang('CantShowResults');
echo ' | ';
echo '';
echo ' -- ';
echo ' |
';
echo ' -- ';
echo ' | ';
}
echo '
';
}
} else {
echo ''.get_lang('NoEx').' |
';
}
} else {
echo ''.get_lang('NoEx').' |
';
}
?>