chat_whoisonline.php 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  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. /**
  10. * Code
  11. */
  12. define('FRAME', 'online');
  13. $language_file = array('chat');
  14. require_once '../inc/global.inc.php';
  15. $course = api_get_course_id();
  16. $group_id = intval($_SESSION['_gid']);
  17. $session_id = intval($_SESSION['id_session']);
  18. $session_condition = api_get_session_condition($session_id);
  19. $group_condition = " AND to_group_id = '$group_id'";
  20. $extra_condition = '';
  21. if (!empty($group_id)) {
  22. $extra_condition = $group_condition;
  23. } else {
  24. $extra_condition = $session_condition;
  25. }
  26. $user_id = api_get_user_id();
  27. if (!empty($course)) {
  28. $showPic = intval($_GET['showPic']);
  29. $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  30. $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  31. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  32. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  33. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  34. $tbl_chat_connected = Database::get_course_table(CHAT_CONNECTED_TABLE);
  35. $query = "SELECT username FROM $tbl_user WHERE user_id='".$user_id."'";
  36. $result = Database::query($query);
  37. list($pseudo_user) = Database::fetch_array($result);
  38. $isAllowed = !(empty($pseudo_user) || !$_cid);
  39. $isMaster = (bool)$is_courseAdmin;
  40. $date_inter = date('Y-m-d H:i:s', time() - 120);
  41. $users = array();
  42. $course_id = api_get_course_int_id();
  43. if (empty($session_id)) {
  44. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri,t3.status
  45. FROM $tbl_user t1, $tbl_chat_connected t2, $tbl_course_user t3
  46. WHERE t2.c_id = $course_id AND
  47. t1.user_id=t2.user_id AND
  48. t3.user_id=t2.user_id AND
  49. t3.relation_type<>".COURSE_RELATION_TYPE_RRHH." AND
  50. t3.course_code = '".$_course['sysCode']."' AND
  51. t2.last_connection>'".$date_inter."' $extra_condition
  52. ORDER BY username";
  53. $result = Database::query($query);
  54. $users = Database::store_result($result);
  55. } else {
  56. // select learners
  57. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri FROM $tbl_user t1, $tbl_chat_connected t2, $tbl_session_course_user t3
  58. WHERE
  59. t2.c_id = $course_id AND
  60. t1.user_id=t2.user_id AND t3.id_user=t2.user_id AND
  61. t3.id_session = '".$session_id."' AND
  62. t3.course_code = '".$_course['sysCode']."' AND t2.last_connection>'".$date_inter."' $extra_condition ORDER BY username";
  63. $result = Database::query($query);
  64. while ($learner = Database::fetch_array($result)) {
  65. $users[$learner['user_id']] = $learner;
  66. }
  67. // select session coach
  68. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session t3
  69. WHERE t2.c_id = $course_id AND
  70. 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";
  71. $result = Database::query($query);
  72. if ($coach = Database::fetch_array($result)) {
  73. $users[$coach['user_id']] = $coach;
  74. }
  75. // select session course coach
  76. $query = "SELECT DISTINCT t1.user_id,username,firstname,lastname,picture_uri
  77. FROM $tbl_user t1,$tbl_chat_connected t2,$tbl_session_course_user t3
  78. WHERE
  79. t2.c_id = $course_id AND
  80. t1.user_id=t2.user_id
  81. AND t3.id_user=t2.user_id AND t3.status=2
  82. AND t3.id_session = '".$session_id."'
  83. AND t3.course_code = '".$_course['sysCode']."'
  84. AND t2.last_connection>'".$date_inter."' $extra_condition ORDER BY username";
  85. $result = Database::query($query);
  86. $course_coaches = array();
  87. while ($coaches = Database::fetch_array($result)) {
  88. //$course_coaches[] = $coaches['user_id'];
  89. $users[$coaches['user_id']] = $coaches;
  90. }
  91. //if ($coach = Database::fetch_array($result))
  92. // $users[$coach['user_id']] = $coach;
  93. }
  94. $user_id = $enreg['user_id'];
  95. require 'header_frame.inc.php';
  96. ?>
  97. <table border="0" cellpadding="0" cellspacing="0" width="100%" class="data_table">
  98. <tr><th colspan="2"><?php echo get_lang('Connected'); ?></th></tr>
  99. <?php
  100. foreach ($users as & $user) {
  101. if (empty($session_id)) {
  102. $status = $user['status'];
  103. } else {
  104. $status = CourseManager::is_course_teacher($user['user_id'], $_SESSION['_course']['id']) ? 1 : 5;
  105. }
  106. $user_image = UserManager::get_user_picture_path_by_id($user['user_id'], 'web', false, true);
  107. $file_url = $user_image['dir'].$user_image['file'];
  108. ?>
  109. <tr>
  110. <td width="1%" valign="top"><img src="<?php echo $file_url;?>" border="0" width="22" alt="" /></td>
  111. <td width="99%"><?php if ($status == 1) echo Display::return_icon('teachers.gif', get_lang('Teacher'), array('height' => '11')).' '; else echo Display::return_icon('students.gif', get_lang('Student'), array('height' => '11')); ?><a <?php if ($status == 1) echo 'class="master"'; ?> name="user_<?php echo $user['user_id']; ?>" href="<?php echo api_get_self(); ?>?<?php echo api_get_cidreq(); ?>&showPic=<?php if ($showPic == $user['user_id']) echo '0'; else echo $user['user_id']; ?>#user_<?php echo $user['user_id']; ?>"><?php echo api_get_person_name($user['firstname'], $user['lastname']); ?></a></td>
  112. </tr>
  113. <?php
  114. if ($showPic == $user['user_id']) { ?>
  115. <tr>
  116. <td colspan="2" align="center"><img src="<?php echo $file_url; ?>" border="0" width="100" alt="" /></td>
  117. </tr>
  118. <?php
  119. }
  120. }
  121. unset($users);
  122. ?>
  123. </table>
  124. <?php
  125. }
  126. require 'footer_frame.inc.php';