123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125 |
- <?php
- $language_file = array ('registration', 'index', 'tracking');
- require_once('../inc/global.inc.php');
-
- function get_connections_to_course($user_id, $course_code) {
- $course_code = Database::escape_string($course_code);
-
- $tbl_track_course = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
-
- $sql = 'SELECT login_course_date, logout_course_date FROM ' . $tbl_track_course . '
- WHERE user_id = ' . intval($user_id) . '
- AND course_code="' . $course_code . '"ORDER BY login_course_date';
-
- $rs = api_sql_query($sql);
- $connections = array();
-
- while ($a_connections = Database::fetch_array($rs)) {
-
- $s_login_date = $a_connections['login_course_date'];
- $s_logout_date = $a_connections['logout_course_date'];
-
- $i_timestamp_login_date = strtotime($s_login_date);
- $i_timestamp_logout_date = strtotime($s_logout_date);
-
- $connections[] = array('login'=>$i_timestamp_login_date, 'logout'=>$i_timestamp_logout_date);
-
- }
-
- return $connections;
- }
-
- function calculHours($seconds)
- {
-
-
- $hours = floor($seconds / 3600);
-
- $min = floor(($seconds - ($hours * 3600)) / 60);
- if ($min < 10)
- $min = '0'.$min;
-
- $sec = $seconds - ($hours * 3600) - ($min * 60);
- if ($sec < 10)
- $sec = '0'.$sec;
- return $hours.get_lang('HourShort').' '.$min.':'.$sec;
- }
- $nameTools= get_lang('AccessDetails');
- Display :: display_header($nameTools);
- $user_id = (int)$_REQUEST['student'];
- $course_code=Database::escape_string($_REQUEST['course']);
- $TBL_USERINFO_DEF = Database :: get_course_table(TABLE_USER_INFO);
- $mainUserInfo = api_get_user_info($user_id, $course_code);
- echo '<strong>',get_lang('User'),': ',$mainUserInfo['firstName'],' ',$mainUserInfo['lastName'],'</strong> <br />';
- $connections = get_connections_to_course($user_id, $course_code);
- echo '<strong>'.get_lang('Course').': ',$course_code,' - ',$_course['name'],'</strong><br />';
- echo '<strong>',get_lang('DateAndTimeOfAccess'),' - ',get_lang('Duration'),'</strong><br />';
- foreach ($connections as $key=>$data)
- {
- echo ' '.date('d-m-Y (H:i:s)',$data['login']).' - '.calculHours($data['logout']-$data['login']).'<br />'."\n";
- }
- Display:: display_footer();
- ?>
|