usergroup.lib.php 12 KB

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