chat_whoisonline.php 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Shows the list of connected users
  5. *
  6. * @author Olivier Brouckaert
  7. * @package chamilo.chat
  8. */
  9. define('FRAME', 'online');
  10. require_once '../inc/global.inc.php';
  11. $course = api_get_course_id();
  12. $group_id = api_get_group_id();
  13. $session_id = api_get_session_id();
  14. $user_id = api_get_user_id();
  15. $session_condition = api_get_session_condition($session_id);
  16. $group_condition = " AND to_group_id = '$group_id'";
  17. $extra_condition = '';
  18. if (!empty($group_id)) {
  19. $extra_condition = $group_condition;
  20. } else {
  21. $extra_condition = $session_condition;
  22. }
  23. if (!empty($course)) {
  24. $showPic = isset($_GET['showPic']) ? intval($_GET['showPic']) : null;
  25. $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  26. $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  27. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  28. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  29. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  30. $tbl_chat_connected = Database::get_course_table(TABLE_CHAT_CONNECTED);
  31. $query = "SELECT username FROM $tbl_user WHERE user_id='".$user_id."'";
  32. $result = Database::query($query);
  33. list($pseudo_user) = Database::fetch_array($result);
  34. $isAllowed = !(empty($pseudo_user) || !$_cid);
  35. $isMaster = api_is_course_admin();
  36. $date_inter = date('Y-m-d H:i:s', time() - 120);
  37. $users = array();
  38. $course_id = api_get_course_int_id();
  39. if (empty($session_id)) {
  40. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email,t3.status
  41. FROM $tbl_user t1, $tbl_chat_connected t2, $tbl_course_user t3
  42. WHERE t2.c_id = $course_id AND
  43. t1.user_id=t2.user_id AND
  44. t3.user_id=t2.user_id AND
  45. t3.relation_type<>".COURSE_RELATION_TYPE_RRHH." AND
  46. t3.course_code = '".$_course['sysCode']."' AND
  47. t2.last_connection>'".$date_inter."' $extra_condition
  48. ORDER BY username";
  49. $result = Database::query($query);
  50. $users = Database::store_result($result);
  51. } else {
  52. // select learners
  53. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
  54. FROM $tbl_user t1, $tbl_chat_connected t2, $tbl_session_course_user t3
  55. WHERE
  56. t2.c_id = $course_id AND
  57. t1.user_id=t2.user_id AND t3.id_user=t2.user_id AND
  58. t3.id_session = '".$session_id."' AND
  59. t3.course_code = '".$_course['sysCode']."' AND t2.last_connection>'".$date_inter."' $extra_condition ORDER BY username";
  60. $result = Database::query($query);
  61. while ($learner = Database::fetch_array($result)) {
  62. $users[$learner['user_id']] = $learner;
  63. }
  64. // select session coach
  65. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
  66. FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session t3
  67. WHERE t2.c_id = $course_id AND
  68. t1.user_id=t2.user_id AND t3.id_coach=t2.user_id AND t3.id = '".$session_id."' AND t2.last_connection>'".$date_inter."' $extra_condition ORDER BY username";
  69. $result = Database::query($query);
  70. if ($coach = Database::fetch_array($result)) {
  71. $users[$coach['user_id']] = $coach;
  72. }
  73. // select session course coach
  74. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,email
  75. FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session_course_user t3
  76. WHERE
  77. t2.c_id = $course_id AND
  78. t1.user_id=t2.user_id
  79. AND t3.id_user=t2.user_id AND t3.status=2
  80. AND t3.id_session = '".$session_id."'
  81. AND t3.course_code = '".$_course['sysCode']."'
  82. AND t2.last_connection>'".$date_inter."' $extra_condition ORDER BY username";
  83. $result = Database::query($query);
  84. $course_coaches = array();
  85. while ($coaches = Database::fetch_array($result)) {
  86. $users[$coaches['user_id']] = $coaches;
  87. }
  88. }
  89. require 'header_frame.inc.php';
  90. ?>
  91. <div class="user-connected">
  92. <div id="user-online-scroll" class="user-online">
  93. <div class="title"><?php echo get_lang('Users'); ?> <?php echo get_lang('Connected'); ?></div>
  94. <div class="scrollbar"><div class="track"><div class="thumb"><div class="end"></div></div></div></div>
  95. <div class="viewport"><div id="hidden" class="overview">
  96. <ul class="profile list-group">
  97. <?php
  98. foreach ($users as & $user) {
  99. if (empty($session_id)) {
  100. $status = $user['status'];
  101. } else {
  102. $status = CourseManager::is_course_teacher($user['user_id'], $_SESSION['_course']['id']) ? 1 : 5;
  103. }
  104. $userImage = UserManager::get_user_picture_path_by_id($user['user_id'], 'web', false, true);
  105. if (substr($userImage['file'],0,7) != 'unknown') {
  106. $fileUrl = $userImage['dir'].'medium_'.$userImage['file'];
  107. } else {
  108. $fileUrl = $userImage['dir'].$userImage['file'];
  109. }
  110. $email = $user['email'];
  111. $url_user_profile=api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$user['user_id'].'&';
  112. ?>
  113. <li class="list-group-item">
  114. <img src="<?php echo $fileUrl;?>" border="0" width="50" alt="" class="user-image-chat" />
  115. <div class="user-name">
  116. <a href="<?php echo $url_user_profile; ?>" target="_blank"><?php echo api_get_person_name($user['firstname'], $user['lastname']); ?></a>
  117. <?php
  118. if ($status == 1) {
  119. echo Display::return_icon('teachers.gif', get_lang('Teacher'), array('height' => '18'));
  120. }else{
  121. echo Display::return_icon('students.gif', get_lang('Student'), array('height' => '18'));
  122. }
  123. ?>
  124. </div>
  125. <div class="user-email"><?php echo $user['username']; ?></div>
  126. </li>
  127. <?php
  128. }
  129. unset($users);
  130. ?>
  131. </ul>
  132. </div></div></div></div>
  133. <?php
  134. }
  135. require 'footer_frame.inc.php';