123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140 |
- <?php
- /*
- * Created on 20 juil. 2006 by Elixir Interactive http://www.elixir-interactive.com
- */
- $langFile = "index";
- include_once("./main/inc/global.inc.php");
- api_block_anonymous_users();
- /*
- -----------------------------------------------------------
- Header
- include the HTTP, HTML headers plus the top banner
- -----------------------------------------------------------
- */
- Display::display_header(get_lang('UserOnlineListSession'));
- ?>
- <br/><br/>
- <table class="data_table" width="60%">
- <tr class="tableName">
- <td colspan="4">
- <strong><?php echo get_lang('UserOnlineListSession'); ?></strong>
- </td>
- </tr>
- <tr>
- <th class="head">
- <?php echo get_lang('Name'); ?>
- </th>
- <th class="head">
- <?php echo get_lang('InCourse'); ?>
- </th>
- <th class="head">
- <?php echo get_lang('Email'); ?>
- </th>
- <th class="head">
- <?php echo get_lang('Chat'); ?>
- </th>
- </tr>
- <?php
- $result = api_sql_query("SELECT DISTINCT id,
- name,
- date_start,
- date_end
- FROM session
- INNER JOIN session_rel_course
- ON session_rel_course.id_coach = $_uid
- ORDER BY date_start, date_end, name",__FILE__,__LINE__);
-
- $sessionIsCoach = api_store_result($result);
-
- $result = api_sql_query("SELECT DISTINCT id,
- name,
- date_start,
- date_end
- FROM session
- WHERE session.id_coach = $_uid
- ORDER BY date_start, date_end, name",__FILE__,__LINE__);
- $sessionIsCoach = array_merge($sessionIsCoach , api_store_result($result));
-
- foreach($sessionIsCoach as $session)
- {
- $sql = "SELECT DISTINCT last_access.access_user_id,
- last_access.access_date,
- last_access.access_cours_code,
- last_access.access_session_id,
- CONCAT(user.lastname,' ',user.firstname) as name,
- user.email
- FROM ".Database::get_statistic_table(STATISTIC_TRACK_E_LASTACCESS_TABLE)." AS last_access
- INNER JOIN ".Database::get_main_table(MAIN_USER_TABLE)." AS user
- ON user.user_id = last_access.access_user_id
- WHERE access_session_id='".$session['id']."'
- AND NOW()-access_date<1000 GROUP BY access_user_id
- ";
-
- $result = api_sql_query($sql,__FILE__,__LINE__);
-
- while($a_userList = mysql_fetch_array($result))
- {
- $a_onlineStudent[$a_userList['access_user_id']] = $a_userList;
- }
- }
-
- if(count($a_onlineStudent)>0)
- {
- foreach($a_onlineStudent as $onlineStudent)
- {
- echo "<tr>
- <td>
- ";
- echo $onlineStudent['name'];
- echo " </td>
- <td align='center'>
- ";
- echo $onlineStudent['access_cours_code'];
- echo " </td>
- <td align='center'>
- ";
- if(!empty($onlineStudent['email']))
- {
- echo $onlineStudent['email'];
- }
- else
- {
- echo get_lang('NoEmail');
- }
- echo " </td>
- <td align='center'>
- ";
- echo '<a href="main/chat/chat.php?cidReq='.$onlineStudent['access_cours_code'].'&id_session='.$onlineStudent['access_session_id'].'"> -> </a>';
- echo " </td>
- </tr>
- ";
- }
- }
- else
- {
- $online = get_lang('NoOnlineStudents');
- }
-
- if(!empty($online))
- {
- echo " <tr>
- <td colspan='4'>
- ".$online."
- </td>
- </tr>
- ";
- }
-
- ?>
- </table>
- <?php
- /*
- ==============================================================================
- FOOTER
- ==============================================================================
- */
- Display::display_footer();
- ?>
|