load_search.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. use Chamilo\CoreBundle\Entity\ExtraFieldSavedSearch;
  4. $cidReset = true;
  5. require_once 'main/inc/global.inc.php';
  6. $htmlHeadXtra[] = '<link href="'. api_get_path(WEB_PATH) .'web/assets/cropper/dist/cropper.min.css" rel="stylesheet">';
  7. $htmlHeadXtra[] = '<script src="'. api_get_path(WEB_PATH) .'web/assets/cropper/dist/cropper.min.js"></script>';
  8. api_block_anonymous_users();
  9. $allowToSee = api_is_drh() || api_is_student_boss() || api_is_platform_admin();
  10. if ($allowToSee === false) {
  11. api_not_allowed(true);
  12. }
  13. $userId = api_get_user_id();
  14. $userInfo = api_get_user_info();
  15. $userToLoad = isset($_GET['user_id']) ? $_GET['user_id'] : '';
  16. $action = isset($_GET['action']) ? $_GET['action'] : '';
  17. switch ($action) {
  18. case 'subscribe_user':
  19. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  20. SessionManager::suscribe_users_to_session($sessionId, [$userToLoad], SESSION_VISIBLE_READ_ONLY, false);
  21. Display::addFlash(Display::return_message(get_lang('UserAdded')));
  22. header("Location: ".api_get_self().'?user_id='.$userToLoad);
  23. exit;
  24. break;
  25. case 'unsubscribe_user':
  26. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  27. SessionManager::unsubscribe_user_from_session($sessionId, $userToLoad);
  28. Display::addFlash(Display::return_message(get_lang('Unsubscribed')));
  29. header("Location: ".api_get_self().'?user_id='.$userToLoad);
  30. break;
  31. }
  32. $em = Database::getManager();
  33. $formSearch = new FormValidator('load', 'get', api_get_self());
  34. $formSearch->addHeader(get_lang('LoadDiagnosis'));
  35. if (!empty($userInfo)) {
  36. $users = [];
  37. switch ($userInfo['status']) {
  38. case DRH:
  39. $users = UserManager::get_users_followed_by_drh($userId);
  40. break;
  41. case STUDENT_BOSS:
  42. $users = UserManager::getUsersFollowedByStudentBoss($userId);
  43. break;
  44. }
  45. if (!empty($users)) {
  46. $userList = [];
  47. foreach ($users as $user) {
  48. $userList[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
  49. }
  50. $formSearch->addSelect('user_id', get_lang('User'), $userList);
  51. }
  52. }
  53. if ($userToLoad) {
  54. $formSearch->setDefaults(['user_id' => $userToLoad]);
  55. }
  56. $formSearch->addButtonSearch(get_lang('Search'), 'save');
  57. $form = new FormValidator('search', 'post', api_get_self().'?user_id='.$userToLoad);
  58. $form->addHeader(get_lang('Diagnosis'));
  59. $form->addHidden('user_id', $userToLoad);
  60. /** @var ExtraFieldSavedSearch $saved */
  61. $search = [
  62. 'user' => $userToLoad
  63. ];
  64. $items = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findBy($search);
  65. if (empty($items)) {
  66. Display::addFlash(Display::return_message('NoData'));
  67. }
  68. $defaults = [];
  69. $tagsData = [];
  70. if (!empty($items)) {
  71. /** @var ExtraFieldSavedSearch $item */
  72. foreach ($items as $item) {
  73. $variable = 'extra_'.$item->getField()->getVariable();
  74. if ($item->getField()->getFieldType() == ExtraField::FIELD_TYPE_TAG) {
  75. $tagsData[$variable] = $item->getValue();
  76. }
  77. $defaults[$variable] = $item->getValue();
  78. }
  79. }
  80. $extraField = new ExtraField('session');
  81. $extraFieldValue = new ExtraFieldValue('session');
  82. $extra = $extraField->addElements(
  83. $form,
  84. '',
  85. [],
  86. true,
  87. true,
  88. [],
  89. [],
  90. $defaults,
  91. [],
  92. true
  93. );
  94. $form->addButtonSearch(get_lang('Search'), 'save');
  95. $extraFieldsToFilter = $extraField->get_all(array('variable = ?' => 'temps-de-travail'));
  96. $extraFieldToSearch = array();
  97. if (!empty($extraFieldsToFilter)) {
  98. foreach ($extraFieldsToFilter as $filter) {
  99. $extraFieldToSearch[] = $filter['id'];
  100. }
  101. }
  102. $extraFieldListToString = implode(',', $extraFieldToSearch);
  103. $result = SessionManager::getGridColumns('simple', $extraFieldsToFilter);
  104. $columns = $result['columns'];
  105. $column_model = $result['column_model'];
  106. $form->setDefaults($defaults);
  107. $filterToSend = '';
  108. if ($formSearch->validate()) {
  109. $formSearchParams = $formSearch->getSubmitValues();
  110. $filters = [];
  111. foreach ($defaults as $key => $value) {
  112. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  113. continue;
  114. }
  115. if (!empty($value)) {
  116. $filters[$key] = $value;
  117. }
  118. }
  119. $filterToSend = [];
  120. if (!empty($filters)) {
  121. $filterToSend = ['groupOp' => 'AND'];
  122. if ($filters) {
  123. $count = 1;
  124. $countExtraField = 1;
  125. foreach ($result['column_model'] as $column) {
  126. if ($count > 5) {
  127. if (isset($filters[$column['name']])) {
  128. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  129. $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
  130. }
  131. $countExtraField++;
  132. }
  133. $count++;
  134. }
  135. }
  136. }
  137. }
  138. if ($form->validate()) {
  139. $params = $form->getSubmitValues();
  140. if (isset($params['save'])) {
  141. unset($params['save']);
  142. }
  143. $form->setDefaults($params);
  144. // Search
  145. $filters = [];
  146. // Parse params.
  147. foreach ($params as $key => $value) {
  148. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  149. continue;
  150. }
  151. if (!empty($value)) {
  152. $filters[$key] = $value;
  153. }
  154. }
  155. $filterToSend = [];
  156. if (!empty($filters)) {
  157. $filterToSend = ['groupOp' => 'AND'];
  158. if ($filters) {
  159. $count = 1;
  160. $countExtraField = 1;
  161. foreach ($result['column_model'] as $column) {
  162. if ($count > 5) {
  163. if (isset($filters[$column['name']])) {
  164. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  165. $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
  166. }
  167. $countExtraField++;
  168. }
  169. $count++;
  170. }
  171. }
  172. }
  173. }
  174. $view = $form->returnForm();
  175. $jsTag = '';
  176. if (!empty($tagsData)) {
  177. foreach ($tagsData as $extraField => $tags) {
  178. foreach ($tags as $tag) {
  179. $tag = api_htmlentities($tag);
  180. // $jsTag .= "$('#$extraField')[0].addItem('$tag', '$tag');";
  181. }
  182. }
  183. }
  184. $htmlHeadXtra[] ='<script>
  185. $(function() {
  186. '.$extra['jquery_ready_content'].'
  187. '.$jsTag.'
  188. });
  189. </script>';
  190. if (!empty($filterToSend)) {
  191. $filterToSend = json_encode($filterToSend);
  192. $url = api_get_path(WEB_AJAX_PATH).'model.ajax.php?a=get_sessions&_search=true&load_extra_field='.$extraFieldListToString.'&_force_search=true&rows=20&page=1&sidx=&sord=asc&filters2='.$filterToSend;
  193. } else {
  194. $url = api_get_path(WEB_AJAX_PATH).'model.ajax.php?a=get_sessions&_search=true&load_extra_field='.$extraFieldListToString.'&_force_search=true&rows=20&page=1&sidx=&sord=asc';
  195. }
  196. // Autowidth
  197. $extra_params['autowidth'] = 'true';
  198. // height auto
  199. $extra_params['height'] = 'auto';
  200. $extra_params['postData'] = array(
  201. 'filters' => array(
  202. "groupOp" => "AND",
  203. "rules" => $result['rules']
  204. )
  205. );
  206. $sessionByUserList = SessionManager::get_sessions_by_user($userToLoad, true, true);
  207. $sessionUserList = array();
  208. if (!empty($sessionByUserList)) {
  209. foreach ($sessionByUserList as $sessionByUser) {
  210. $sessionUserList[] = $sessionByUser['session_id'];
  211. }
  212. }
  213. $action_links = 'function action_formatter(cellvalue, options, rowObject) {
  214. var sessionList = '.json_encode($sessionUserList).';
  215. if ($.inArray(options.rowId, sessionList) == -1) {
  216. return \'<a href="'.api_get_self().'?action=subscribe_user&user_id='.$userToLoad.'&session_id=\'+options.rowId+\'">'.Display::return_icon('add.png', addslashes(get_lang('Subscribe')),'',ICON_SIZE_SMALL).'</a>'.'\';
  217. } else {
  218. return \'<a href="'.api_get_self().'?action=unsubscribe_user&user_id='.$userToLoad.'&session_id=\'+options.rowId+\'">'.Display::return_icon('delete.png', addslashes(get_lang('Delete')),'',ICON_SIZE_SMALL).'</a>'.'\';
  219. }
  220. }';
  221. $htmlHeadXtra[] = api_get_jqgrid_js();
  222. $griJs = Display::grid_js('sessions', $url, $columns, $column_model, $extra_params, array(), $action_links, true);
  223. $grid = '<div id="session-table" class="table-responsive">';
  224. $grid .= Display::grid_html('sessions');
  225. $grid .= '</div>';
  226. $tpl = new Template(get_lang('Diagnosis'));
  227. if (empty($items)) {
  228. $view = '';
  229. $grid = '';
  230. $griJs = '';
  231. }
  232. $tpl->assign('form', $view);
  233. $tpl->assign('form_search', $formSearch->returnForm());
  234. $table = new HTML_Table(array('class' => 'data_table'));
  235. $column = 0;
  236. $row = 0;
  237. $total = '0';
  238. $sumHours = '0';
  239. $numHours = '0';
  240. $field = 'heures_disponibilite_par_semaine';
  241. $extraField = new ExtraFieldValue('user');
  242. $data = $extraField->get_values_by_handler_and_field_variable($userToLoad, $field);
  243. $availableHoursPerWeek = 0;
  244. function dateDiffInWeeks($date1, $date2)
  245. {
  246. if ($date1 > $date2) {
  247. return dateDiffInWeeks($date2, $date1);
  248. }
  249. $first = new \DateTime($date1);
  250. $second = new \DateTime($date2);
  251. return floor($first->diff($second)->days / 7);
  252. }
  253. if ($data) {
  254. $availableHoursPerWeek = $data['value'];
  255. $numberWeeks = 0;
  256. if ($form->validate()) {
  257. $formData = $form->getSubmitValues();
  258. if (isset($formData['extra_access_start_date']) && isset($formData['extra_access_end_date'])) {
  259. $startDate = $formData['extra_access_start_date'];
  260. $endDate = $formData['extra_access_end_date'];
  261. $numberWeeks = dateDiffInWeeks($startDate, $endDate);
  262. }
  263. }
  264. $total = $numberWeeks * $availableHoursPerWeek;
  265. $sessions = SessionManager::getSessionsFollowedByUser($userToLoad);
  266. if ($sessions) {
  267. $sessionFieldValue = new ExtraFieldValue('session');
  268. foreach ($sessions as $session) {
  269. $sessionId = $session['id'];
  270. $data = $sessionFieldValue->get_values_by_handler_and_field_variable($sessionId, 'temps-de-travail');
  271. if ($data) {
  272. $sumHours += $data['value'];
  273. }
  274. }
  275. }
  276. }
  277. $numHours = $total - $sumHours;
  278. $headers = array(
  279. "Total d'heures disponibles" => $total,
  280. 'Sommes des heures de sessions inscrites' => $sumHours,
  281. "Nombre d'heures encore disponible" => $numHours
  282. );
  283. foreach ($headers as $header => $value) {
  284. $table->setCellContents($row, 0, $header);
  285. $table->updateCellAttributes($row, 0, 'width="250px"');
  286. $table->setCellContents($row, 1, $value);
  287. $row++;
  288. }
  289. $button = '';
  290. if ($userToLoad) {
  291. $button = Display::url(
  292. get_lang('OfajEndOfLearnPath'),
  293. api_get_path(WEB_CODE_PATH).'messages/new_message.php?prefill=ofaj&send_to_user='.$userToLoad,
  294. ['class' => 'btn btn-default']
  295. );
  296. $button .= '<br /><br />';
  297. }
  298. $tpl->assign('grid', $grid.$button.$table->toHtml());
  299. $tpl->assign('grid_js', $griJs);
  300. $content = $tpl->fetch('default/user_portal/search_extra_field.tpl');
  301. $tpl->assign('content', $content);
  302. $tpl->display_one_col_template();