whoisonlinesession.php 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /**
  4. * Shows who is online in a specific session
  5. * @package chamilo.main
  6. */
  7. /**
  8. * Initialization
  9. */
  10. // name of the language file that needs to be included
  11. $language_file = array ('index', 'chat', 'tracking');
  12. require_once './main/inc/global.inc.php';
  13. api_block_anonymous_users();
  14. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  15. $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  16. if (isset($_REQUEST['session_id'])) {
  17. $session_id = intval($_REQUEST['session_id']);
  18. } else {
  19. $session_id = api_get_session_id();
  20. }
  21. if (empty($session_id)) {
  22. api_not_allowed(true);
  23. }
  24. Display::display_header(get_lang('UserOnlineListSession'));
  25. echo Display::page_header(get_lang('UserOnlineListSession'));
  26. ?>
  27. <br /><br />
  28. <table class="data_table">
  29. <tr>
  30. <th>
  31. <?php echo get_lang('Name'); ?>
  32. </th>
  33. <th>
  34. <?php echo get_lang('InCourse'); ?>
  35. </th>
  36. <th>
  37. <?php echo get_lang('Email'); ?>
  38. </th>
  39. <th>
  40. <?php echo get_lang('Chat'); ?>
  41. </th>
  42. </tr>
  43. <?php
  44. $session_is_coach = array();
  45. if (isset($_user['user_id']) && $_user['user_id'] != '') {
  46. /*$_user['user_id'] = intval($_user['user_id']);
  47. $result = Database::query("SELECT DISTINCT id,
  48. name,
  49. date_start,
  50. date_end
  51. FROM $tbl_session as session
  52. INNER JOIN $tbl_session_course_user as srcru
  53. ON srcru.id_user = ".$_user['user_id']." AND srcru.status=2
  54. AND session.id = srcru.id_session
  55. ORDER BY date_start, date_end, name");
  56. while ($session = Database:: fetch_array($result)) {
  57. $session_is_coach[$session['id']] = $session;
  58. }
  59. $result = Database::query("SELECT DISTINCT id,
  60. name,
  61. date_start,
  62. date_end
  63. FROM $tbl_session as session
  64. WHERE session.id_coach = ".$_user['user_id']."
  65. ORDER BY date_start, date_end, name");
  66. while ($session = Database:: fetch_array($result)) {
  67. $session_is_coach[$session['id']] = $session;
  68. }*/
  69. $session_is_coach = SessionManager::get_sessions_coached_by_user(api_get_user_id());
  70. $students_online = array();
  71. $now = api_get_utc_datetime();
  72. $time_limit = api_get_setting('time_limit_whosonline');
  73. $online_time = time() - $time_limit*60;
  74. $current_date = api_get_utc_datetime($online_time);
  75. foreach ($session_is_coach as $session) {
  76. $sql = "SELECT DISTINCT last_access.access_user_id,
  77. last_access.access_date,
  78. last_access.access_cours_code,
  79. last_access.access_session_id,
  80. ".(api_is_western_name_order() ? "CONCAT(user.firstname,' ',user.lastname)" : "CONCAT(user.lastname,' ',user.firstname)")." as name,
  81. user.email
  82. FROM ".Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LASTACCESS)." AS last_access
  83. INNER JOIN ".Database::get_main_table(TABLE_MAIN_USER)." AS user
  84. ON user.user_id = last_access.access_user_id
  85. WHERE access_session_id='".$session['id']."'
  86. AND access_date >= '$current_date' GROUP BY access_user_id";
  87. $result = Database::query($sql);
  88. while($user_list = Database::fetch_array($result)) {
  89. $students_online[$user_list['access_user_id']] = $user_list;
  90. }
  91. }
  92. if (count($students_online) > 0) {
  93. foreach ($students_online as $student_online) {
  94. echo "<tr><td>";
  95. echo $student_online['name'];
  96. echo "</td><td align='center'>";
  97. echo $student_online['access_cours_code'];
  98. echo "</td><td align='center'>";
  99. if (api_get_setting('show_email_addresses') == 'true') {
  100. if (!empty($student_online['email'])) {
  101. echo $student_online['email'];
  102. } else {
  103. echo get_lang('NoEmail');
  104. }
  105. }
  106. echo " </td>
  107. <td align='center'>
  108. ";
  109. echo '<a target="_blank" class="btn" href="main/chat/chat.php?cidReq='.$student_online['access_cours_code'].'&id_session='.$student_online['access_session_id'].'">
  110. '.get_lang('Chat').'
  111. </a>';
  112. echo " </td>
  113. </tr>
  114. ";
  115. }
  116. } else {
  117. echo ' <tr>
  118. <td colspan="4">
  119. '.get_lang('NoOnlineStudents').'
  120. </td>
  121. </tr>
  122. ';
  123. }
  124. }
  125. ?>
  126. </table>
  127. <?php
  128. Display::display_footer();