123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367 |
- <?php
- /* For licensing terms, see /dokeos_license.txt */
- // name of the language file that needs to be included
- $language_file = array('registration', 'tracking', 'exercice', 'admin');
- $cidReset = true;
- require_once '../inc/global.inc.php';
- require_once api_get_path(LIBRARY_PATH).'tracking.lib.php';
- require_once api_get_path(LIBRARY_PATH).'course.lib.php';
- require_once api_get_path(LIBRARY_PATH).'usermanager.lib.php';
- require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpath.class.php';
- $this_section = SECTION_TRACKING;
- $nameTools = get_lang('MyProgress');
- api_block_anonymous_users();
- Display :: display_header($nameTools);
- // Database table definitions
- $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
- $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
- $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
- $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
- $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
- $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $tbl_stats_lastaccess = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);
- $tbl_stats_exercices = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
- $tbl_course_lp_view = Database :: get_course_table(TABLE_LP_VIEW);
- $tbl_course_lp_view_item = Database :: get_course_table(TABLE_LP_ITEM_VIEW);
- $tbl_course_lp = Database :: get_course_table(TABLE_LP_MAIN);
- $tbl_course_lp_item = Database :: get_course_table(TABLE_LP_ITEM);
- $tbl_course_quiz = Database :: get_course_table(TABLE_QUIZ_TEST);
- // get course list
- $sql = 'SELECT course_code FROM '.$tbl_course_user.' WHERE user_id='.intval($_user['user_id']);
- $rs = Database::query($sql, __FILE__, __LINE__);
- $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, __FILE__, __LINE__);
- while($row = Database :: fetch_array($rs)) {
- $courses[$row['course_code']] = CourseManager::get_course_information($row['course_code']);
- }
- echo '<div class="actions-title" >';
- echo $nameTools;
- echo '</div>';
- $now = date('Y-m-d');
- ?>
- <table class="data_table" width="100%">
- <tr class="tableName">
- <td colspan="6">
- <strong><?php echo get_lang('MyCourses'); ?></strong>
- </td>
- </tr>
- <tr>
- <th><?php echo get_lang('Course'); ?></th>
- <th><?php echo get_lang('Time'); ?></th>
- <th><?php echo get_lang('Progress'); ?></th>
- <th><?php echo get_lang('Score'); Display :: display_icon('info3.gif', get_lang('ScormAndLPTestTotalAverage'), array ('align' => 'absmiddle', 'hspace' => '3px')); ?></th>
- <th><?php echo get_lang('LastConnexion'); ?></th>
- <th><?php echo get_lang('Details'); ?></th>
- </tr>
- <?php
- $i = 0;
- foreach ($courses as $enreg) {
- $weighting = 0;
- $last_connection = Tracking :: get_last_connection_date_on_the_course($_user['user_id'], $enreg['code']);
- $progress = Tracking :: get_avg_student_progress($_user['user_id'], $enreg['code']);
- $total_time_login = Tracking :: get_time_spent_on_the_course($_user['user_id'], $enreg['code']);
- $time = api_time_to_hms($total_time_login);
- $percentage_score = Tracking :: get_average_test_scorm_and_lp ($_user['user_id'], $enreg['code']);
- ?>
- <tr class='<?php echo $i?'row_odd':'row_even'; ?>'>
- <td>
- <?php echo api_html_entity_decode($enreg['title'], ENT_QUOTES, api_get_system_encoding()); ?>
- </td>
- <td align='center'>
- <?php echo $time; ?>
- </td>
- <td align='center'>
- <?php echo $progress.'%'; ?>
- </td>
- <td align='center'>
- <?php
- if (!is_null($percentage_score)) {
- echo $percentage_score.'%';
- } else {
- echo '0%';
- }
- ?>
- </td>
- <td align='center' >
- <?php echo $last_connection; ?>
- </td>
- <td align='center'>
- <?php
- if ($enreg['code'] == $_GET['course']) {
- echo '<a href="#">';
- Display::display_icon('2rightarrow_na.gif', get_lang('Details'));
- } else {
- echo '<a href="'.api_get_self().'?course='.$enreg['code'].'">';
- Display::display_icon('2rightarrow.gif', get_lang('Details'));
- }
- echo '</a>';
- ?>
- </td>
- </tr>
- <?php
- $i = $i ? 0 : 1;
- }
- ?>
- </table>
- <br /><br />
- <?php
- /*
- * **********************************************************************************************
- *
- * Details for one course
- *
- * **********************************************************************************************
- */
- if (isset($_GET['course'])) {
- $course = Database::escape_string($_GET['course']);
- $course_info = CourseManager::get_course_information($course);
- //get coach and session_name if there is one and if session_mode is activated
- if (api_get_setting('use_session_mode') == 'true') {
- $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
- $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
- $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
- $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $sql = 'SELECT id_session
- FROM '.$tbl_session_course_user.' session_course_user
- WHERE session_course_user.id_user = '.intval($_user['user_id']).'
- AND session_course_user.course_code = "'.Database::escape_string($course).'"
- ORDER BY id_session DESC';
- $rs = Database::query($sql, __FILE__, __LINE__);
- $row = Database::fetch_array($rs);
- if (!empty($row[0])) {
- $session_id = intval($row[0]);
- }
- //$session_id = intval(Database::result($rs, 0, 0));
- if ($session_id > 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, __FILE__, __LINE__);
- $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, __FILE__, __LINE__);
- $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 : '');
- ?>
- <table class="data_table" width="100%">
- <tr class="tableName">
- <td colspan="4">
- <strong><?php echo $tableTitle; ?></strong>
- </td>
- </tr>
- <tr>
- <th class="head" style="color:#000"><?php echo get_lang('Learnpath'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('Time'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('Progress'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('LastConnexion'); ?></th>
- </tr>
- <?php
- $sql_learnpath = "SELECT lp.name,lp.id FROM ".$course_info['db_name'].".".$tbl_course_lp." AS lp";
- $result_learnpath = Database::query($sql_learnpath, __FILE__, __LINE__);
- if (Database::num_rows($result_learnpath) > 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, __FILE__, __LINE__);
- $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, __FILE__, __LINE__);
- $total_time = Database::result($rs, 0, 0);
- echo "<tr>
- <td>
- ";
- echo stripslashes($learnpath['name']);
- echo " </td>
- <td align='center'>
- ";
- echo api_time_to_hms($total_time);
- echo " </td>
- <td align='center'>
- ";
- echo $progress;
- echo " </td>
- <td align='center' width=180px >
- ";
- if ($start_time != '') {
- echo $last_connection;
- } else {
- echo '-';
- }
- echo " </td>
- </tr>
- ";
- }
- } else {
- echo " <tr>
- <td colspan='4'>
- ".get_lang('NoLearnpath')."
- </td>
- </tr>
- ";
- }
- ?>
- <tr>
- <th class="head" style="color:#000"><?php echo get_lang('Exercices'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('Score'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('Attempts'); ?></th>
- <th class="head" style="color:#000"><?php echo get_lang('Details'); ?></th>
- </tr>
- <?php
- $sql = 'SELECT visibility FROM '.$course_info['db_name'].'.'.TABLE_TOOL_LIST.' WHERE name="quiz"';
- $result_visibility_tests = Database::query($sql, __FILE__, __LINE__);
- if (Database::result($result_visibility_tests, 0, 'visibility') == 1) {
- $sql_exercices = " SELECT quiz.title,id, results_disabled
- FROM ".$course_info['db_name'].".".$tbl_course_quiz." AS quiz
- WHERE active='1'";
- $result_exercices = Database::query($sql_exercices, __FILE__, __LINE__);
- if (Database::num_rows($result_exercices) > 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 , __FILE__, __LINE__);
- $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, __FILE__, __LINE__);
- $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 '<tr>
- <td>';
- echo $exercices['title'];
- echo '</td>';
- if ($exercices['results_disabled'] == 0) {
- echo '<td align="center">';
- if ($essais['essais'] > 0) {
- echo $percentage_score.'%';
- } else {
- echo '/';
- }
- echo '</td>';
- echo '<td align="center">';
- echo $essais['essais'];
- echo '</td>
- <td align="center" width="25">';
- if ($essais['essais'] > 0) {
- echo '<a href="../exercice/exercise_show.php?origin=myprogress&id='.$exe_id.'&cidReq='.$course_info['code'].'&id_session='.Security::remove_XSS($_GET['id_session']).'"> '.Display::return_icon('quiz.gif', get_lang('Quiz')).' </a>';
- }
- echo '</td>';
- } else {
- // we show or not the results if the teacher wants to
- echo '<td align="center">';
- echo get_lang('CantShowResults');
- echo '</td>';
- echo '<td align="center">';
- echo ' -- ';
- echo '</td>
- <td align="center" width="25">';
- echo ' -- ';
- echo '</td>';
- }
- echo '</tr>';
- }
- } else {
- echo '<tr><td colspan="4">'.get_lang('NoEx').'</td></tr>';
- }
- } else {
- echo '<tr><td colspan="4">'.get_lang('NoEx').'</td></tr>';
- }
- ?>
- </table>
- <?php
- }
- Display :: display_footer();
|