session_course_user_list.php 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. /**
  7. * Code
  8. */
  9. $language_file = array('admin', 'registration');
  10. $cidReset = true;
  11. require_once '../inc/global.inc.php';
  12. $id_session = intval($_GET['id_session']);
  13. SessionManager::protect_session_edit($id_session);
  14. if (empty($id_session)) {
  15. api_not_allowed(true);
  16. }
  17. $course_info = api_get_course_info($_GET['course_code']);
  18. if (empty($course_info)) {
  19. api_not_allowed(true);
  20. }
  21. $course_code = $course_info['code'];
  22. $page = intval($_GET['page']);
  23. $action = $_REQUEST['action'];
  24. $default_sort = api_sort_by_first_name() ? 'firstname':'lastname';
  25. $sort = in_array($_GET['sort'], array('lastname','firstname','username')) ? $_GET['sort'] : $default_sort;
  26. $idChecked = (is_array($_GET['idChecked']) ? $_GET['idChecked'] : (is_array($_POST['idChecked']) ? $_POST['idChecked'] : null));
  27. $direction = isset($_GET['direction']) && in_array($_GET['direction'], array('desc','asc')) ? $_GET['direction'] : 'desc';
  28. if (is_array($idChecked)) {
  29. $my_temp = array();
  30. foreach ($idChecked as $id){
  31. $my_temp[]= intval($id);// forcing the intval
  32. }
  33. $idChecked = $my_temp;
  34. }
  35. $session_info = SessionManager::fetch($id_session);
  36. $courses = SessionManager::get_course_list_by_session_id($id_session);
  37. if (!isset($courses[$course_info['real_id']])) {
  38. header('Location: session_course_list.php?id_session='.$id_session);
  39. exit();
  40. }
  41. switch ($action) {
  42. case 'delete':
  43. SessionManager::unsubscribe_user_from_course_session($id_session, $idChecked, $course_code);
  44. header('Location: '.api_get_self().'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
  45. exit;
  46. break;
  47. case 'add':
  48. SessionManager::subscribe_users_to_session_course($idChecked, $id_session, $course_code);
  49. header('Location: '.api_get_self().'?id_session='.$id_session.'&course_code='.urlencode($course_code).'&sort='.$sort);
  50. exit;
  51. break;
  52. }
  53. $limit = 20;
  54. $from = $page * $limit;
  55. $is_western_name_order = api_is_western_name_order();
  56. $Users = SessionManager::get_users_in_course_session($course_code, $id_session, $sort, $direction, $from, $limit);
  57. /*
  58. $sql = "SELECT DISTINCT u.user_id,".($is_western_name_order ? 'u.firstname, u.lastname' : 'u.lastname, u.firstname').", u.username, scru.id_user as is_subscribed
  59. FROM $tbl_session_rel_user s INNER JOIN $tbl_user u ON (u.user_id=s.id_user)
  60. LEFT JOIN $tbl_session_rel_course_rel_user scru ON (u.user_id=scru.id_user AND scru.course_code = '".$course_code."' )
  61. WHERE s.id_session='$id_session'
  62. ORDER BY $sort $direction LIMIT $from,".($limit+1);
  63. */
  64. if ($direction == 'desc') {
  65. $direction = 'asc';
  66. } else {
  67. $direction = 'desc';
  68. }
  69. $nbr_results = sizeof($Users);
  70. $tool_name = get_lang('Session').': '.$session_info['name'].' - '.get_lang('Course').': '.$course_info['title'];
  71. $interbreadcrumb[] = array("url" => "index.php","name" => get_lang('Sessions'));
  72. $interbreadcrumb[] = array("url" => "session_list.php","name" => get_lang('SessionList'));
  73. $interbreadcrumb[] = array('url' => "resume_session.php?id_session=".$id_session,"name" => get_lang('SessionOverview'));
  74. Display::display_header($tool_name);
  75. echo Display::page_header($tool_name);
  76. ?>
  77. <form method="post" action="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=<?php echo $sort; ?>" onsubmit="javascript:if(!confirm('<?php echo get_lang('ConfirmYourChoice'); ?>')) return false;">
  78. <div align="right">
  79. <?php
  80. if($page) {
  81. ?>
  82. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page-1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Previous');?></a>
  83. <?php
  84. } else {
  85. echo get_lang('Previous');
  86. }
  87. ?>
  88. |
  89. <?php
  90. if ($nbr_results > $limit) {
  91. ?>
  92. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page+1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Next');?></a>
  93. <?php
  94. } else {
  95. echo get_lang('Next');
  96. }
  97. ?>
  98. </div>
  99. <br />
  100. <table class="data_table" width="100%">
  101. <tr>
  102. <th>&nbsp;</th>
  103. <?php if ($is_western_name_order) { ?>
  104. <th><a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=firstname&direction=<?php echo urlencode($direction); ?>"><?php echo get_lang('FirstName');?></a></th>
  105. <th><a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=lastname&direction=<?php echo urlencode($direction); ?>"><?php echo get_lang('LastName');?></a></th>
  106. <?php } else { ?>
  107. <th><a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=lastname&direction=<?php echo urlencode($direction); ?>"><?php echo get_lang('LastName');?></a></th>
  108. <th><a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=firstname&direction=<?php echo urlencode($direction); ?>"><?php echo get_lang('FirstName');?></a></th>
  109. <?php } ?>
  110. <th><a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=username&direction=<?php echo urlencode($direction); ?>"><?php echo get_lang('Login');?></a></th>
  111. <th><?php echo get_lang('Actions');?></th>
  112. </tr>
  113. <?php
  114. $i=0;
  115. if (!empty($Users)) {
  116. foreach ($Users as $key=>$enreg) {
  117. if ($key == $limit) {
  118. break;
  119. }
  120. ?>
  121. <tr class="<?php echo $i?'row_odd':'row_even'; ?>">
  122. <td><input type="checkbox" name="idChecked[]" value="<?php echo $enreg['user_id']; ?>"></td>
  123. <?php if ($is_western_name_order) { ?>
  124. <td><?php echo api_htmlentities($enreg['firstname'],ENT_QUOTES,$charset); ?></td>
  125. <td><?php echo api_htmlentities($enreg['lastname'],ENT_QUOTES,$charset); ?></td>
  126. <?php } else { ?>
  127. <td><?php echo api_htmlentities($enreg['lastname'],ENT_QUOTES,$charset); ?></td>
  128. <td><?php echo api_htmlentities($enreg['firstname'],ENT_QUOTES,$charset); ?></td>
  129. <?php } ?>
  130. <td><?php echo api_htmlentities($enreg['username'],ENT_QUOTES,$charset); ?></td>
  131. <td>
  132. <?php if ($enreg['is_subscribed']) { ?>
  133. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=<?php echo $sort; ?>&action=delete&idChecked[]=<?php echo $enreg['user_id']; ?>" onclick="javascript:if(!confirm('<?php echo get_lang('ConfirmYourChoice'); ?>')) return false;">
  134. <?php Display::display_icon('delete.png', get_lang('Delete')); ?>
  135. </a>
  136. <?php } else { ?>
  137. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&sort=<?php echo $sort; ?>&action=add&idChecked[]=<?php echo $enreg['user_id']; ?>" onclick="javascript:if(!confirm('<?php echo get_lang('ConfirmYourChoice'); ?>')) return false;">
  138. <?php Display::display_icon('add.png', get_lang('Add'), array(), ICON_SIZE_SMALL); ?>
  139. </a>
  140. <?php } ?>
  141. </td>
  142. </tr>
  143. <?php
  144. $i=$i ? 0 : 1;
  145. }
  146. }
  147. unset($Users);
  148. ?>
  149. </table>
  150. <br />
  151. <div align="left">
  152. <?php
  153. if($page) {
  154. ?>
  155. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page-1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Previous'); ?></a>
  156. <?php
  157. } else {
  158. echo get_lang('Previous');
  159. }
  160. ?>
  161. |
  162. <?php
  163. if($nbr_results > $limit) {
  164. ?>
  165. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page+1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Next'); ?></a>
  166. <?php
  167. } else {
  168. echo get_lang('Next');
  169. }
  170. ?>
  171. </div>
  172. <br />
  173. <select name="action">
  174. <option value="delete"><?php echo get_lang('UnsubscribeSelectedUsersFromSession');?></option>
  175. <option value="add"><?php echo get_lang('AddUsers');?></option>
  176. </select>
  177. <button class="save" type="submit"> <?php echo get_lang('Ok'); ?></button>
  178. </form>
  179. <?php
  180. Display::display_footer();