whoisonlinesession.php 4.0 KB

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