chat_whoisonline.php 5.3 KB

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