load_search.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403
  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. $userToLoadInfo = [];
  17. if ($userToLoad) {
  18. $userToLoadInfo = api_get_user_info($userToLoad);
  19. }
  20. $action = isset($_GET['action']) ? $_GET['action'] : '';
  21. switch ($action) {
  22. case 'subscribe_user':
  23. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  24. SessionManager::suscribe_users_to_session($sessionId, [$userToLoad], SESSION_VISIBLE_READ_ONLY, false);
  25. Display::addFlash(Display::return_message(get_lang('UserAdded')));
  26. header("Location: ".api_get_self().'?user_id='.$userToLoad);
  27. exit;
  28. break;
  29. case 'unsubscribe_user':
  30. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  31. SessionManager::unsubscribe_user_from_session($sessionId, $userToLoad);
  32. Display::addFlash(Display::return_message(get_lang('Unsubscribed')));
  33. header("Location: ".api_get_self().'?user_id='.$userToLoad);
  34. break;
  35. }
  36. $em = Database::getManager();
  37. $formSearch = new FormValidator('load', 'get', api_get_self());
  38. $formSearch->addHeader(get_lang('LoadDiagnosis'));
  39. if (!empty($userInfo)) {
  40. $users = [];
  41. switch ($userInfo['status']) {
  42. case DRH:
  43. $users = UserManager::get_users_followed_by_drh($userId);
  44. break;
  45. case STUDENT_BOSS:
  46. $users = UserManager::getUsersFollowedByStudentBoss($userId);
  47. break;
  48. }
  49. if (!empty($users)) {
  50. $userList = [];
  51. foreach ($users as $user) {
  52. $userList[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
  53. }
  54. $formSearch->addSelect('user_id', get_lang('User'), $userList);
  55. }
  56. }
  57. if ($userToLoad) {
  58. $formSearch->setDefaults(['user_id' => $userToLoad]);
  59. }
  60. $formSearch->addButtonSearch(get_lang('Search'), 'save');
  61. $form = new FormValidator('search', 'post', api_get_self().'?user_id='.$userToLoad);
  62. $form->addHeader(get_lang('Diagnosis'));
  63. $form->addHidden('user_id', $userToLoad);
  64. /** @var ExtraFieldSavedSearch $saved */
  65. $search = [
  66. 'user' => $userToLoad
  67. ];
  68. $items = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findBy($search);
  69. if (empty($items)) {
  70. Display::addFlash(Display::return_message('NoData'));
  71. }
  72. $defaults = [];
  73. $tagsData = [];
  74. if (!empty($items)) {
  75. /** @var ExtraFieldSavedSearch $item */
  76. foreach ($items as $item) {
  77. $variable = 'extra_'.$item->getField()->getVariable();
  78. if ($item->getField()->getFieldType() == ExtraField::FIELD_TYPE_TAG) {
  79. $tagsData[$variable] = $item->getValue();
  80. }
  81. $defaults[$variable] = $item->getValue();
  82. }
  83. }
  84. $extraField = new ExtraField('session');
  85. $extraFieldValue = new ExtraFieldValue('session');
  86. $theme = 'theme_fr';
  87. if ($userToLoadInfo) {
  88. $lang = $userToLoadInfo['language'];
  89. switch ($lang) {
  90. case 'french2':
  91. case 'french':
  92. $theme = 'theme_fr';
  93. break;
  94. case 'german2':
  95. case 'german':
  96. $theme = 'theme_de';
  97. break;
  98. }
  99. }
  100. // Session fields
  101. $showOnlyThisFields = [
  102. 'access_start_date',
  103. 'access_end_date',
  104. //'heures_disponibilite_par_semaine', this is only for user
  105. 'domaine',
  106. 'filiere',
  107. $theme,
  108. 'ecouter',
  109. 'lire',
  110. 'participer_a_une_conversation',
  111. 's_exprimer_oralement_en_continu',
  112. 'ecrire'
  113. ];
  114. //$showOnlyThisFields = [];
  115. $extra = $extraField->addElements(
  116. $form,
  117. '',
  118. [],
  119. false, //filter
  120. true,
  121. $showOnlyThisFields,
  122. $showOnlyThisFields,
  123. $defaults,
  124. [],
  125. false,
  126. true // force
  127. );
  128. $form->addButtonSearch(get_lang('Search'), 'save');
  129. $extraFieldsToFilter = $extraField->get_all(array('variable = ?' => 'temps-de-travail'));
  130. $extraFieldToSearch = array();
  131. if (!empty($extraFieldsToFilter)) {
  132. foreach ($extraFieldsToFilter as $filter) {
  133. $extraFieldToSearch[] = $filter['id'];
  134. }
  135. }
  136. $extraFieldListToString = implode(',', $extraFieldToSearch);
  137. $result = SessionManager::getGridColumns('simple', $extraFieldsToFilter);
  138. $columns = $result['columns'];
  139. $column_model = $result['column_model'];
  140. $form->setDefaults($defaults);
  141. $filterToSend = '';
  142. if ($formSearch->validate()) {
  143. $formSearchParams = $formSearch->getSubmitValues();
  144. $filters = [];
  145. foreach ($defaults as $key => $value) {
  146. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  147. continue;
  148. }
  149. if (!empty($value)) {
  150. $filters[$key] = $value;
  151. }
  152. }
  153. $filterToSend = [];
  154. if (!empty($filters)) {
  155. $filterToSend = ['groupOp' => 'AND'];
  156. if ($filters) {
  157. $count = 1;
  158. $countExtraField = 1;
  159. foreach ($result['column_model'] as $column) {
  160. if ($count > 5) {
  161. if (isset($filters[$column['name']])) {
  162. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  163. $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
  164. }
  165. $countExtraField++;
  166. }
  167. $count++;
  168. }
  169. }
  170. }
  171. }
  172. if ($form->validate()) {
  173. $params = $form->getSubmitValues();
  174. if (isset($params['save'])) {
  175. unset($params['save']);
  176. }
  177. $form->setDefaults($params);
  178. // Search
  179. $filters = [];
  180. // Parse params.
  181. foreach ($params as $key => $value) {
  182. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  183. continue;
  184. }
  185. if (!empty($value)) {
  186. $filters[$key] = $value;
  187. }
  188. }
  189. $filterToSend = [];
  190. if (!empty($filters)) {
  191. $filterToSend = ['groupOp' => 'AND'];
  192. if ($filters) {
  193. $count = 1;
  194. $countExtraField = 1;
  195. foreach ($result['column_model'] as $column) {
  196. if ($count > 5) {
  197. if (isset($filters[$column['name']])) {
  198. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  199. $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
  200. }
  201. $countExtraField++;
  202. }
  203. $count++;
  204. }
  205. }
  206. }
  207. }
  208. $view = $form->returnForm();
  209. $jsTag = '';
  210. if (!empty($tagsData)) {
  211. foreach ($tagsData as $extraField => $tags) {
  212. foreach ($tags as $tag) {
  213. $tag = api_htmlentities($tag);
  214. // $jsTag .= "$('#$extraField')[0].addItem('$tag', '$tag');";
  215. }
  216. }
  217. }
  218. $htmlHeadXtra[] ='<script>
  219. $(function() {
  220. '.$extra['jquery_ready_content'].'
  221. '.$jsTag.'
  222. });
  223. </script>';
  224. if (!empty($filterToSend)) {
  225. $filterToSend = json_encode($filterToSend);
  226. $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;
  227. } else {
  228. $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';
  229. }
  230. // Autowidth
  231. $extra_params['autowidth'] = 'true';
  232. // height auto
  233. $extra_params['height'] = 'auto';
  234. $extra_params['postData'] = array(
  235. 'filters' => array(
  236. "groupOp" => "AND",
  237. "rules" => $result['rules']
  238. )
  239. );
  240. $sessionByUserList = SessionManager::get_sessions_by_user($userToLoad, true, true);
  241. $sessionUserList = array();
  242. if (!empty($sessionByUserList)) {
  243. foreach ($sessionByUserList as $sessionByUser) {
  244. $sessionUserList[] = $sessionByUser['session_id'];
  245. }
  246. }
  247. $action_links = 'function action_formatter(cellvalue, options, rowObject) {
  248. var sessionList = '.json_encode($sessionUserList).';
  249. if ($.inArray(options.rowId, sessionList) == -1) {
  250. 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>'.'\';
  251. } else {
  252. 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>'.'\';
  253. }
  254. }';
  255. $htmlHeadXtra[] = api_get_jqgrid_js();
  256. $griJs = Display::grid_js('sessions', $url, $columns, $column_model, $extra_params, array(), $action_links, true);
  257. $grid = '<div id="session-table" class="table-responsive">';
  258. $grid .= Display::grid_html('sessions');
  259. $grid .= '</div>';
  260. $tpl = new Template(get_lang('Diagnosis'));
  261. if (empty($items)) {
  262. $view = '';
  263. $grid = '';
  264. $griJs = '';
  265. }
  266. $tpl->assign('form', $view);
  267. $tpl->assign('form_search', $formSearch->returnForm());
  268. $table = new HTML_Table(array('class' => 'data_table'));
  269. $column = 0;
  270. $row = 0;
  271. $total = '0';
  272. $sumHours = '0';
  273. $numHours = '0';
  274. $field = 'heures_disponibilite_par_semaine';
  275. $extraField = new ExtraFieldValue('user');
  276. $data = $extraField->get_values_by_handler_and_field_variable($userToLoad, $field);
  277. $availableHoursPerWeek = 0;
  278. function dateDiffInWeeks($date1, $date2)
  279. {
  280. if ($date1 > $date2) {
  281. return dateDiffInWeeks($date2, $date1);
  282. }
  283. $first = new \DateTime($date1);
  284. $second = new \DateTime($date2);
  285. return floor($first->diff($second)->days / 7);
  286. }
  287. if ($data) {
  288. $availableHoursPerWeek = $data['value'];
  289. $numberWeeks = 0;
  290. if ($form->validate()) {
  291. $formData = $form->getSubmitValues();
  292. if (isset($formData['extra_access_start_date']) && isset($formData['extra_access_end_date'])) {
  293. $startDate = $formData['extra_access_start_date'];
  294. $endDate = $formData['extra_access_end_date'];
  295. $numberWeeks = dateDiffInWeeks($startDate, $endDate);
  296. }
  297. } else {
  298. if ($defaults) {
  299. if (isset($defaults['extra_access_start_date']) && isset($defaults['extra_access_end_date'])) {
  300. $startDate = $defaults['extra_access_start_date'];
  301. $endDate = $defaults['extra_access_end_date'];
  302. $numberWeeks = dateDiffInWeeks($startDate, $endDate);
  303. }
  304. }
  305. }
  306. $total = $numberWeeks * $availableHoursPerWeek;
  307. $sessions = SessionManager::getSessionsFollowedByUser($userToLoad);
  308. if ($sessions) {
  309. $sessionFieldValue = new ExtraFieldValue('session');
  310. foreach ($sessions as $session) {
  311. $sessionId = $session['id'];
  312. $data = $sessionFieldValue->get_values_by_handler_and_field_variable($sessionId, 'temps-de-travail');
  313. if ($data) {
  314. $sumHours += $data['value'];
  315. }
  316. }
  317. }
  318. }
  319. $numHours = $total - $sumHours;
  320. $headers = array(
  321. "Total d'heures disponibles" => $total,
  322. 'Sommes des heures de sessions inscrites' => $sumHours,
  323. "Nombre d'heures encore disponible" => $numHours
  324. );
  325. foreach ($headers as $header => $value) {
  326. $table->setCellContents($row, 0, $header);
  327. $table->updateCellAttributes($row, 0, 'width="250px"');
  328. $table->setCellContents($row, 1, $value);
  329. $row++;
  330. }
  331. $button = '';
  332. if ($userToLoad) {
  333. $button = Display::url(
  334. get_lang('OfajEndOfLearnPath'),
  335. api_get_path(WEB_CODE_PATH).'messages/new_message.php?prefill=ofaj&send_to_user='.$userToLoad,
  336. ['class' => 'btn btn-default']
  337. );
  338. $button .= '<br /><br />';
  339. }
  340. $tpl->assign('grid', $grid.$button.$table->toHtml());
  341. $tpl->assign('grid_js', $griJs);
  342. $content = $tpl->fetch('default/user_portal/search_extra_field.tpl');
  343. $tpl->assign('content', $content);
  344. $tpl->display_one_col_template();