300) { break; } } $diff = $jour_agenda - $Total; if ($diff > 0) { $sing = get_lang('retard'); } else { $sing = get_lang('avance'); } $diff = abs($diff); ?>
getAspect()->setView3D(false); $chart->getHeader()->setText("Graphique de suivi"); $chart->getAxes()->getLeft()->setMinimumOffset(10); $chart->getAxes()->getLeft()->setMaximumOffset(10); $chart->getAxes()->getBottom()->setMinimumOffset(10); $chart->getAxes()->getBottom()->setMaximumOffset(10); $line1 = new Line($chart->getChart()); $data = $pt; $line1->addArray($data); foreach ($chart->getSeries() as $serie) { $pointer = $serie->getPointer(); $pointer->setVisible(true); $pointer->getPen()->setVisible(false); $pointer->setHorizSize(2); $pointer->setVertSize(2); $marks = $serie->getMarks(); $marks->setVisible(true); $marks->setArrowLength(5); $marks->getArrow()->setVisible(false); $marks->setTransparent(true); } $x = $_user['user_id']; $line1->getPointer()->setStyle(PointerStyle::$CIRCLE); $chart->getLegend()->setVisible(false); $chart->render("../garbage/$x-image.png"); $rand = rand(); print ''; */ ?>
:
:
:

"; $exe_id = $a_inter['exe_id']; } if ($level == 3) { echo ' '; echo $limit; echo ''; } ?>

".$a_inter['level']." $inter_date $inter_coment

'.get_lang('Course').''; echo ''; echo ''; //on recherche les cours où sont inscrit les user $user_c_id = $_user['user_id']; $sql2 = "SELECT c_id, user_id FROM course_rel_user WHERE user_id = '$user_id'"; $result2 = Database::query($sql2); while ($a_courses = Database::fetch_array($result2)) { $courses_code = $a_courses['c_id']; //on sort le c_id avec le code du cours $sql8 = "SELECT title, code FROM course WHERE id = '$courses_code'"; $result8 = Database::query($sql8); $course_code_id = Database::fetch_array($result8); $c_id = $courses_code; $c_title = $course_code_id['title']; // Francois Belisle Kezber // The Tracking Class still uses the course code rather then the course id. $tracking_c_code = $course_code_id['code']; // time spent on the course $time_spent_on_course = api_time_to_hms(Tracking:: get_time_spent_on_the_course($user_id, $c_id, $session_id)); // firts connection date $sql2 = "SELECT STR_TO_DATE(access_date,'%Y-%m-%d') FROM $tbl_stats_access WHERE access_user_id = '$user_id' AND c_id = '$c_id' ORDER BY access_id ASC LIMIT 0,1"; //Francois Belisle Kezber // mysql fonctions rather then Database:: // conversion to Database:: $rs2 = Database::query($sql2); $num_rows = Database::num_rows($rs2); if ($num_rows > 0) { $rw2 = Database::fetch_array($rs2); $first_connection_date_to_module = $rw2[0]; } //pour trouver la date de fin prévue du module $end_date_module = get_lang('hors_cal'); //on trouve le nombre de jour pour ce module $sql = "SELECT * FROM c_cal_set_module where c_id = '$c_id'"; $res = Database::query($sql); $resulta = Database::fetch_array($res); $nombre_heure = $resulta['minutes']; // on trouve le nombre de minute par jour $sql = "SELECT * FROM c_cal_horaire where c_id = '$c_id_horaire' AND name = '$nom_hor' "; $res = Database::query($sql); $resulta = Database::fetch_array($res); $nombre_minutes = (int) $resulta['num_minute']; //on calcule le nombre de jour par module $nombre_jours_module = 0; if (!empty($nombre_minutes)) { $nombre_jours_module = $nombre_heure * '60' / $nombre_minutes; } //on arrondi $nombre_jours_module = (int) $nombre_jours_module; //on trouve la date de fin de chaque module AND date = date_format('$first_connection_date_to_module','%Y-%m-%d') $sql = "SELECT * FROM c_cal_dates WHERE horaire_name = '$nom_hor' AND c_id = '$c_id_horaire' AND STR_TO_DATE(date,'%Y-%m-%d') >= STR_TO_DATE('$first_connection_date_to_module','%Y-%m-%d') ORDER BY STR_TO_DATE(date, '%Y-%m-%d') asc LIMIT $nombre_jours_module, 18446744073709551615 "; $res = Database::query($sql); //Database::data_seek($res,$nombre_jours_module); $row = Database::fetch_row($res); $end_date_module = $row[1]; //fin de trouver la date de fin prévue du module //progression en % $t_lp = Database:: get_course_table(TABLE_LP_MAIN); $sql_lp = " SELECT lp.name, lp.id FROM $t_lp lp WHERE c_id = '$c_id' ORDER BY lp.display_order"; $rs_lp = Database::query($sql_lp); $i = 0; while ($learnpath = Database:: fetch_array($rs_lp)) { $lp_id = intval($learnpath['id']); $lp_name = $learnpath['name']; $any_result = false; // Get progress in lp // Francois Belisle Kezber // Course Code passed rather then course_id $progress = Tracking::get_avg_student_progress( $user_c_id, /*$c_id*/ $tracking_c_code, [$lp_id], $session_id ); if ($progress === null) { $progress = '0%'; } else { $any_result = true; } // Get time in lp // Francois Belisle Kezber // Course Code passed rather then course_id $total_time = Tracking::get_time_spent_in_lp( $user_c_id, /*$c_id*/ $tracking_c_code, [$lp_id], $session_id ); if (!empty($total_time)) { $any_result = true; } if ($i % 2 == 0) { $css_class = "row_even"; } else { $css_class = "row_odd"; } $i++; if (is_numeric($progress)) { $progress = $progress.'%'; } else { $progress = '-'; } $data_learnpath[/*$i*/ $lp_id][] = $progress.'%'; } $warming = ''; $today = date('Y-m-d'); if (isset($end_date_module) && $end_date_module <= $today and $progress != '100%') { $warming = ' '.get_lang('limite_atteinte').''; } $end_date_module = $end_date_module.$warming; echo ''; echo ''; } echo '
'.get_lang('Course').' '.get_lang('Time').' '.get_lang('FirstConnexion').' '.get_lang('Progress').' '.get_lang('fin_mod_prevue').'
'.$c_title.' '.$time_spent_on_course.' '.$first_connection_date_to_module.' '.$progress.' '.$end_date_module.'
'; ?>

".$a_exam['mod_no']."
".$a_exam['score_ex']."
".$a_exam['score_rep1']."
".$a_exam['score_rep2']."
$coment "; $exe_idd = $a_exam['exe_id']; ?>