chat_whoisonline.php 5.4 KB

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