usergroup.lib.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This class provides methods for the UserGroup management.
  5. * Include/require it in your code to use its features.
  6. * @package chamilo.library
  7. */
  8. require_once 'model.lib.php';
  9. require_once api_get_path(LIBRARY_PATH).'sessionmanager.lib.php';
  10. class UserGroup extends Model {
  11. var $columns = array('id', 'name','description');
  12. public function __construct() {
  13. $this->table = Database::get_main_table(TABLE_USERGROUP);
  14. $this->usergroup_rel_user_table = Database::get_main_table(TABLE_USERGROUP_REL_USER);
  15. $this->usergroup_rel_course_table = Database::get_main_table(TABLE_USERGROUP_REL_COURSE);
  16. $this->usergroup_rel_session_table = Database::get_main_table(TABLE_USERGROUP_REL_SESSION);
  17. }
  18. /**
  19. * Displays the title + grid
  20. */
  21. function display() {
  22. // action links
  23. echo '<div class="actions">';
  24. echo '<a href="../admin/index.php">'.Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('PlatformAdmin'),'','32').'</a>';
  25. //echo '<a href="career_dashboard.php">'.Display::return_icon('back.png',get_lang('Back')).get_lang('Back').'</a>';
  26. echo '<a href="'.api_get_self().'?action=add">'.Display::return_icon('new_class.png',get_lang('langAddClasses'),'','32').'</a>';
  27. echo '</div>';
  28. echo Display::grid_html('usergroups');
  29. }
  30. /**
  31. * Gets a list of course ids by user group
  32. * @param int user group id
  33. * @return array
  34. */
  35. public function get_courses_by_usergroup($id) {
  36. $results = Database::select('course_id',$this->usergroup_rel_course_table, array('where'=>array('usergroup_id = ?'=>$id)));
  37. $array = array();
  38. if (!empty($results)) {
  39. foreach($results as $row) {
  40. $array[]= $row['course_id'];
  41. }
  42. }
  43. return $array;
  44. }
  45. /**
  46. * Gets a list of session ids by user group
  47. * @param int user group id
  48. * @return array
  49. */
  50. public function get_sessions_by_usergroup($id) {
  51. $results = Database::select('session_id',$this->usergroup_rel_session_table, array('where'=>array('usergroup_id = ?'=>$id)));
  52. $array = array();
  53. if (!empty($results)) {
  54. foreach($results as $row) {
  55. $array[]= $row['session_id'];
  56. }
  57. }
  58. return $array;
  59. }
  60. /**
  61. * Gets a list of user ids by user group
  62. * @param int user group id
  63. * @return array with a list of user ids
  64. */
  65. public function get_users_by_usergroup($id) {
  66. $results = Database::select('user_id',$this->usergroup_rel_user_table, array('where'=>array('usergroup_id = ?'=>$id)));
  67. $array = array();
  68. if (!empty($results)) {
  69. foreach($results as $row) {
  70. $array[]= $row['user_id'];
  71. }
  72. }
  73. return $array;
  74. }
  75. /**
  76. * Gets the usergroup id list by user id
  77. * @param int user id
  78. */
  79. public function get_usergroup_by_user($id) {
  80. $results = Database::select('usergroup_id',$this->usergroup_rel_user_table, array('where'=>array('user_id = ?'=>$id)));
  81. $array = array();
  82. if (!empty($results)) {
  83. foreach($results as $row) {
  84. $array[]= $row['usergroup_id'];
  85. }
  86. }
  87. return $array;
  88. }
  89. /**
  90. * Subscribes sessions to a group (also adding the members of the group in the session and course)
  91. * @param int usergroup id
  92. * @param array list of session ids
  93. */
  94. function subscribe_sessions_to_usergroup($usergroup_id, $list) {
  95. require_once api_get_path(LIBRARY_PATH).'sessionmanager.lib.php';
  96. $current_list = self::get_sessions_by_usergroup($usergroup_id);
  97. $user_list = self::get_users_by_usergroup($usergroup_id);
  98. $delete_items = $new_items = array();
  99. if (!empty($list)) {
  100. foreach ($list as $session_id) {
  101. if (!in_array($session_id, $current_list)) {
  102. $new_items[] = $session_id;
  103. }
  104. }
  105. }
  106. if (!empty($current_list)) {
  107. foreach($current_list as $session_id) {
  108. if (!in_array($session_id, $list)) {
  109. $delete_items[] = $session_id;
  110. }
  111. }
  112. }
  113. //Deleting items
  114. if (!empty($delete_items)) {
  115. foreach($delete_items as $session_id) {
  116. if (!empty($user_list)) {
  117. foreach($user_list as $user_id) {
  118. SessionManager::unsubscribe_user_from_session($session_id, $user_id);
  119. /*foreach ($course_list as $course_data) {
  120. foreach($user_list as $user_id) {
  121. CourseManager::subscribe_user($user_id, $course_data['code'], $session_id);
  122. }
  123. }*/
  124. }
  125. }
  126. Database::delete($this->usergroup_rel_session_table, array('usergroup_id = ? AND session_id = ?'=>array($usergroup_id, $session_id)));
  127. }
  128. }
  129. //Addding new relationships
  130. if (!empty($new_items)) {
  131. foreach($new_items as $session_id) {
  132. $params = array('session_id'=>$session_id, 'usergroup_id'=>$usergroup_id);
  133. Database::insert($this->usergroup_rel_session_table, $params);
  134. if (!empty($user_list)) {
  135. SessionManager::suscribe_users_to_session($session_id, $user_list);
  136. }
  137. /*
  138. $course_list = SessionManager::get_course_list_by_session_id($id);
  139. foreach ($course_list as $course_data) {
  140. foreach($user_list as $user_id) {
  141. CourseManager::subscribe_user($user_id, $course_data['code'], $id);
  142. }
  143. }*/
  144. }
  145. }
  146. }
  147. /**
  148. * Subscribes courses to a group (also adding the members of the group in the course)
  149. * @param int usergroup id
  150. * @param array list of course ids
  151. */
  152. function subscribe_courses_to_usergroup($usergroup_id, $list) {
  153. require_once api_get_path(LIBRARY_PATH).'course.lib.php';
  154. $current_list = self::get_courses_by_usergroup($usergroup_id);
  155. $user_list = self::get_users_by_usergroup($usergroup_id);
  156. $delete_items = $new_items = array();
  157. if (!empty($list)) {
  158. foreach ($list as $id) {
  159. if (!in_array($id, $current_list)) {
  160. $new_items[] = $id;
  161. }
  162. }
  163. }
  164. if (!empty($current_list)) {
  165. foreach($current_list as $id) {
  166. if (!in_array($id, $list)) {
  167. $delete_items[] = $id;
  168. }
  169. }
  170. }
  171. //Deleting items
  172. if (!empty($delete_items)) {
  173. foreach($delete_items as $course_id) {
  174. $course_info = api_get_course_info_by_id($course_id);
  175. if (!empty($user_list)) {
  176. foreach($user_list as $user_id) {
  177. CourseManager::unsubscribe_user($user_id, $course_info['code']);
  178. }
  179. }
  180. Database::delete($this->usergroup_rel_course_table, array('usergroup_id = ? AND course_id = ?'=>array($usergroup_id, $course_id)));
  181. }
  182. }
  183. //Addding new relationships
  184. if (!empty($new_items)) {
  185. foreach($new_items as $course_id) {
  186. $course_info = api_get_course_info_by_id($course_id);
  187. if (!empty($user_list)) {
  188. foreach($user_list as $user_id) {
  189. CourseManager::subscribe_user($user_id, $course_info['code']);
  190. }
  191. }
  192. $params = array('course_id'=>$course_id, 'usergroup_id'=>$usergroup_id);
  193. Database::insert($this->usergroup_rel_course_table, $params);
  194. }
  195. }
  196. }
  197. /**
  198. * Subscribes users to a group
  199. * @param int usergroup id
  200. * @param array list of user ids
  201. */
  202. function subscribe_users_to_usergroup($usergroup_id, $list) {
  203. $current_list = self::get_users_by_usergroup($usergroup_id);
  204. $course_list = self::get_courses_by_usergroup($usergroup_id);
  205. $session_list = self::get_sessions_by_usergroup($usergroup_id);
  206. $delete_items = $new_items = array();
  207. if (!empty($list)) {
  208. foreach ($list as $user_id) {
  209. if (!in_array($user_id, $current_list)) {
  210. $new_items[] = $user_id;
  211. }
  212. }
  213. }
  214. if (!empty($current_list)) {
  215. foreach($current_list as $user_id) {
  216. if (!in_array($user_id, $list)) {
  217. $delete_items[] = $user_id;
  218. }
  219. }
  220. }
  221. //Deleting items
  222. if (!empty($delete_items)) {
  223. foreach($delete_items as $user_id) {
  224. //Removing courses
  225. if (!empty($course_list)) {
  226. foreach($course_list as $course_id) {
  227. $course_info = api_get_course_info_by_id($course_id);
  228. CourseManager::unsubscribe_user($user_id, $course_info['code']);
  229. }
  230. }
  231. //Removing sessions
  232. if (!empty($session_list)) {
  233. foreach($session_list as $session_id) {
  234. SessionManager::unsubscribe_user_from_session($session_id, $user_id);
  235. }
  236. }
  237. Database::delete($this->usergroup_rel_user_table, array('usergroup_id = ? AND user_id = ?'=>array($usergroup_id, $user_id)));
  238. }
  239. }
  240. //Addding new relationships
  241. if (!empty($new_items)) {
  242. //Adding sessions
  243. if (!empty($session_list)) {
  244. foreach($session_list as $session_id) {
  245. SessionManager::suscribe_users_to_session($session_id, $new_items);
  246. }
  247. }
  248. foreach($new_items as $user_id) {
  249. //Adding courses
  250. if (!empty($course_list)) {
  251. foreach($course_list as $course_id) {
  252. $course_info = api_get_course_info_by_id($course_id);
  253. CourseManager::subscribe_user($user_id, $course_info['code']);
  254. }
  255. }
  256. $params = array('user_id'=>$user_id, 'usergroup_id'=>$usergroup_id);
  257. Database::insert($this->usergroup_rel_user_table, $params);
  258. }
  259. }
  260. }
  261. }