load_search.php 34 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082
  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. $htmlHeadXtra[] = '<script>
  9. $(document).ready(function() {
  10. $("#filiere").on("click", function() {
  11. $("#filiere_panel").toggle();
  12. return false;
  13. });
  14. $("#dispo").on("click", function() {
  15. $("#dispo_panel").toggle();
  16. return false;
  17. });
  18. $("#dispo_pendant").on("click", function() {
  19. $("#dispo_pendant_panel").toggle();
  20. return false;
  21. });
  22. $("#niveau").on("click", function() {
  23. $("#niveau_panel").toggle();
  24. return false;
  25. });
  26. $("#methode").on("click", function() {
  27. $("#methode_panel").toggle();
  28. return false;
  29. });
  30. $("#themes").on("click", function() {
  31. $("#themes_panel").toggle();
  32. return false;
  33. });
  34. $("#objectifs").on("click", function() {
  35. $("#objectifs_panel").toggle();
  36. return false;
  37. });
  38. });
  39. </script>';
  40. api_block_anonymous_users();
  41. $allowToSee = api_is_drh() || api_is_student_boss() || api_is_platform_admin();
  42. if ($allowToSee === false) {
  43. api_not_allowed(true);
  44. }
  45. $userId = api_get_user_id();
  46. $userInfo = api_get_user_info();
  47. $userToLoad = isset($_GET['user_id']) ? $_GET['user_id'] : '';
  48. $userToLoadInfo = [];
  49. if ($userToLoad) {
  50. $userToLoadInfo = api_get_user_info($userToLoad);
  51. }
  52. $action = isset($_GET['action']) ? $_GET['action'] : '';
  53. switch ($action) {
  54. case 'subscribe_user':
  55. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  56. SessionManager::subscribeUsersToSession(
  57. $sessionId,
  58. [$userToLoad],
  59. SESSION_VISIBLE_READ_ONLY,
  60. false
  61. );
  62. Display::addFlash(Display::return_message(get_lang('UserAdded')));
  63. header("Location: ".api_get_self().'?user_id='.$userToLoad.'#session-table');
  64. exit;
  65. break;
  66. case 'unsubscribe_user':
  67. $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
  68. SessionManager::unsubscribe_user_from_session($sessionId, $userToLoad);
  69. Display::addFlash(Display::return_message(get_lang('Unsubscribed')));
  70. header("Location: ".api_get_self().'?user_id='.$userToLoad.'#session-table');
  71. break;
  72. }
  73. $em = Database::getManager();
  74. $formSearch = new FormValidator('load', 'get', api_get_self());
  75. $formSearch->addHeader(get_lang('LoadDiagnosis'));
  76. if (!empty($userInfo)) {
  77. $users = [];
  78. switch ($userInfo['status']) {
  79. case DRH:
  80. $users = UserManager::get_users_followed_by_drh($userId);
  81. break;
  82. case STUDENT_BOSS:
  83. $users = UserManager::getUsersFollowedByStudentBoss($userId);
  84. break;
  85. }
  86. if (!empty($users)) {
  87. $userList = [];
  88. foreach ($users as $user) {
  89. $userList[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
  90. }
  91. $formSearch->addSelect('user_id', get_lang('User'), $userList);
  92. }
  93. }
  94. if ($userToLoad) {
  95. $formSearch->setDefaults(['user_id' => $userToLoad]);
  96. }
  97. $formSearch->addButtonSearch(get_lang('ShowDiagnostic'), 'save');
  98. $form = new FormValidator('search', 'post', api_get_self().'?user_id='.$userToLoad.'#session-table');
  99. $form->addHeader(get_lang('Diagnosis'));
  100. $form->addHidden('user_id', $userToLoad);
  101. /** @var ExtraFieldSavedSearch $saved */
  102. $search = [
  103. 'user' => $userToLoad,
  104. ];
  105. $items = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findBy($search);
  106. if (empty($items)) {
  107. Display::addFlash(Display::return_message('NoData'));
  108. }
  109. $defaults = [];
  110. $tagsData = [];
  111. if (!empty($items)) {
  112. /** @var ExtraFieldSavedSearch $item */
  113. foreach ($items as $item) {
  114. $variable = 'extra_'.$item->getField()->getVariable();
  115. if ($item->getField()->getFieldType() == ExtraField::FIELD_TYPE_TAG) {
  116. $tagsData[$variable] = $item->getValue();
  117. }
  118. $defaults[$variable] = $item->getValue();
  119. }
  120. }
  121. $extraField = new ExtraField('session');
  122. $extraFieldValue = new ExtraFieldValue('session');
  123. $theme = 'theme_fr';
  124. if ($userToLoadInfo) {
  125. $lang = $userToLoadInfo['language'];
  126. switch ($lang) {
  127. case 'french2':
  128. case 'french':
  129. $theme = 'theme_fr';
  130. break;
  131. case 'german2':
  132. case 'german':
  133. $theme = 'theme_de';
  134. break;
  135. }
  136. }
  137. $extraFieldUser = new ExtraField('user');
  138. $userForm = new FormValidator('user_form', 'post', api_get_self());
  139. $jqueryExtra = '';
  140. $userForm->addHtml('<div class="panel-group" id="search_extrafield" role="tablist" aria-multiselectable="true">');
  141. $userForm->addHtml('<div class="panel panel-default">');
  142. $userForm->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseOne" aria-expanded="true" aria-controls="collapseOne">'.get_lang('Filiere').'</a></div>');
  143. $userForm->addHtml('<div id="collapseOne" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">');
  144. $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('FiliereExplanation').'</p>');
  145. $fieldsToShow = [
  146. 'statusocial',
  147. 'filiere_user',
  148. 'filiereprecision',
  149. 'filiere_want_stage',
  150. ];
  151. $forceShowFields = true;
  152. $filter = false;
  153. $extra = $extraFieldUser->addElements(
  154. $userForm,
  155. $userToLoad,
  156. [],
  157. $filter,
  158. true,
  159. $fieldsToShow,
  160. $fieldsToShow,
  161. [],
  162. [],
  163. false,
  164. $forceShowFields, //$forceShowFields = false
  165. [],
  166. [],
  167. $fieldsToShow
  168. );
  169. $userForm->addHtml('</div></div></div>');
  170. $userForm->addHtml('<div class="panel panel-default">');
  171. $userForm->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseThree" aria-expanded="true" aria-controls="collapseThree">'.get_lang('DisponibilitePendantMonStage').'</a></div>');
  172. $userForm->addHtml('<div id="collapseThree" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingThree">');
  173. $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('DisponibilitePendantMonStageExplanation').'</p>');
  174. $fieldsToShow = [
  175. 'datedebutstage',
  176. 'datefinstage',
  177. 'deja_sur_place',
  178. 'poursuiteapprentissagestage',
  179. 'heures_disponibilite_par_semaine_stage',
  180. ];
  181. $extra = $extraFieldUser->addElements(
  182. $userForm,
  183. $userToLoad,
  184. [],
  185. $filter,
  186. true,
  187. $fieldsToShow,
  188. $fieldsToShow,
  189. [],
  190. [],
  191. false,
  192. $forceShowFields, //$forceShowFields = false
  193. [],
  194. [],
  195. $fieldsToShow
  196. );
  197. $userForm->addHtml('</div></div></div>');
  198. $userForm->addHtml('<div class="panel panel-default">');
  199. $userForm->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseSix" aria-expanded="true" aria-controls="collapseSix">'.get_lang('ObjectifsApprentissage').'</a></div>');
  200. $userForm->addHtml('<div id="collapseSix" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingSix">');
  201. $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('ObjectifsApprentissageExplanation').'</p>');
  202. $fieldsToShow = [
  203. 'objectif_apprentissage',
  204. ];
  205. $extra = $extraFieldUser->addElements(
  206. $userForm,
  207. $userToLoad,
  208. [],
  209. $filter,
  210. false,
  211. $fieldsToShow,
  212. $fieldsToShow,
  213. $defaults,
  214. [],
  215. false,
  216. $forceShowFields,//$forceShowFields = false
  217. [],
  218. [],
  219. $fieldsToShow
  220. );
  221. $userForm->addHtml('</div></div></div>');
  222. $userForm->addHtml('<div class="panel panel-default">');
  223. $userForm->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseSeven" aria-expanded="true" aria-controls="collapseSeven">'.get_lang('MethodeTravail').'</a></div>');
  224. $userForm->addHtml('<div id="collapseSeven" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingSeven">');
  225. $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('MethodeTravailExplanation').'</p>');
  226. $fieldsToShow = [
  227. 'methode_de_travaille',
  228. 'accompagnement',
  229. ];
  230. $extra = $extraFieldUser->addElements(
  231. $userForm,
  232. $userToLoad,
  233. [],
  234. $filter,
  235. true,
  236. $fieldsToShow,
  237. $fieldsToShow,
  238. [],
  239. [],
  240. false,
  241. $forceShowFields, //$forceShowFields = false
  242. [],
  243. [],
  244. $fieldsToShow
  245. );
  246. $userForm->addHtml('</div></div></div>');
  247. $form->addHtml('<div class="panel panel-default">');
  248. $form->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">'.get_lang('DisponibiliteAvant').'</a></div>');
  249. $form->addHtml('<div id="collapseTwo" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingTwo">');
  250. $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('DisponibiliteAvantExplanation').'</p>');
  251. // Session fields
  252. $showOnlyThisFields = [
  253. 'access_start_date',
  254. 'access_end_date',
  255. ];
  256. $extra = $extraField->addElements(
  257. $form,
  258. '',
  259. [],
  260. false, //filter
  261. true,
  262. $showOnlyThisFields,
  263. $showOnlyThisFields,
  264. $defaults,
  265. [],
  266. false, //$orderDependingDefaults
  267. true, // force
  268. [], // $separateExtraMultipleSelect
  269. []
  270. );
  271. $fieldsToShow = [
  272. 'heures_disponibilite_par_semaine',
  273. 'moment_de_disponibilite',
  274. ];
  275. $extra = $extraFieldUser->addElements(
  276. $form,
  277. $userToLoad,
  278. [],
  279. $filter,
  280. true,
  281. $fieldsToShow,
  282. $fieldsToShow,
  283. [],
  284. [],
  285. false,
  286. $forceShowFields //$forceShowFields = false
  287. );
  288. $form->addHtml('</div></div></div>');
  289. $form->addHtml('<div class="panel panel-default">');
  290. $form->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseFour" aria-expanded="true" aria-controls="collapseFour">'.get_lang('ThemesObjectifs').'</a></div>');
  291. $form->addHtml('<div id="collapseFour" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingFour">');
  292. $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('ThemesObjectifsExplanation').'</p>');
  293. $showOnlyThisFields = [
  294. 'domaine',
  295. 'filiere',
  296. $theme,
  297. ];
  298. $extra = $extraField->addElements(
  299. $form,
  300. '',
  301. [],
  302. false, //filter
  303. true,
  304. $showOnlyThisFields,
  305. $showOnlyThisFields,
  306. $defaults,
  307. [],
  308. false, //$orderDependingDefaults
  309. true, // force
  310. ['domaine' => 3, $theme => 5], // $separateExtraMultipleSelect
  311. [
  312. 'domaine' => [
  313. get_lang('Domaine').' 1',
  314. get_lang('Domaine').' 2',
  315. get_lang('Domaine').' 3',
  316. ],
  317. $theme => [
  318. get_lang('ThemeField').' 1',
  319. get_lang('ThemeField').' 2',
  320. get_lang('ThemeField').' 3',
  321. get_lang('ThemeField').' 4',
  322. get_lang('ThemeField').' 5',
  323. ],
  324. ],
  325. [],
  326. true
  327. );
  328. $form->addHtml('</div></div></div>');
  329. $form->addHtml('<div class="panel panel-default">');
  330. $form->addHtml('<div class="panel-heading"><a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseFive" aria-expanded="true" aria-controls="collapseFive">'.get_lang('NiveauLangue').'</a></div>');
  331. $form->addHtml('<div id="collapseFive" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingFive">');
  332. $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('NiveauLangueExplanation').'</p>');
  333. $showOnlyThisFields = [
  334. 'ecouter',
  335. 'lire',
  336. 'participer_a_une_conversation',
  337. 's_exprimer_oralement_en_continu',
  338. 'ecrire',
  339. ];
  340. $extra = $extraField->addElements(
  341. $form,
  342. '',
  343. [],
  344. false, //filter
  345. true,
  346. $showOnlyThisFields,
  347. $showOnlyThisFields,
  348. $defaults,
  349. [],
  350. false, //$orderDependingDefaults
  351. true, // force
  352. ['domaine' => 3, $theme => 5], // $separateExtraMultipleSelect
  353. [
  354. 'domaine' => [
  355. get_lang('Domaine').' 1',
  356. get_lang('Domaine').' 2',
  357. get_lang('Domaine').' 3',
  358. ],
  359. $theme => [
  360. get_lang('Theme').' 1',
  361. get_lang('Theme').' 2',
  362. get_lang('Theme').' 3',
  363. get_lang('Theme').' 4',
  364. get_lang('Theme').' 5',
  365. ],
  366. ]
  367. );
  368. $form->addHtml('</div></div></div>');
  369. // Enviroment
  370. $userForm->addHtml('<div class="panel panel-default">');
  371. $userForm->addHtml(
  372. '<div class="panel-heading">
  373. <a role="button" data-toggle="collapse" data-parent="#search_extrafield" href="#collapseEight" aria-expanded="true" aria-controls="collapseEight">'.
  374. get_lang('MonEnvironnementDeTravail').'</a></div>');
  375. $userForm->addHtml('<div id="collapseEight" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingEight">');
  376. $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('MonEnvironnementDeTravailExplanation').'</p>');
  377. $fieldsToShow = [
  378. 'outil_de_travail_ordinateur',
  379. 'outil_de_travail_ordinateur_so',
  380. 'outil_de_travail_tablette',
  381. 'outil_de_travail_tablette_so',
  382. 'outil_de_travail_smartphone',
  383. 'outil_de_travail_smartphone_so',
  384. ];
  385. $userForm->addLabel(null, get_lang('MonEnvironnementDeTravailExplanationIntro1'));
  386. $extra = $extraFieldUser->addElements(
  387. $userForm,
  388. $userToLoad,
  389. [],
  390. $filter,
  391. true,
  392. $fieldsToShow,
  393. $fieldsToShow,
  394. [],
  395. [],
  396. false,
  397. $forceShowFields
  398. );
  399. $userForm->addLabel(null, get_lang('MonEnvironnementDeTravailExplanationIntro2'));
  400. $jqueryExtra .= $extra['jquery_ready_content'];
  401. $fieldsToShow = [
  402. 'browser_platforme',
  403. 'browser_platforme_autre',
  404. 'browser_platforme_version',
  405. ];
  406. $extra = $extraFieldUser->addElements(
  407. $userForm,
  408. $userToLoad,
  409. [],
  410. $filter,
  411. true,
  412. $fieldsToShow,
  413. $fieldsToShow,
  414. [],
  415. [],
  416. false,
  417. $forceShowFields, //$forceShowFields = false
  418. [],
  419. [],
  420. $fieldsToShow
  421. );
  422. $jqueryExtra .= $extra['jquery_ready_content'];
  423. $userForm->addHtml('<p class="text-info">'.get_lang('MonEnvironnementDeTravailRenvoiFAQ').'</p>');
  424. $userForm->addButtonSave(get_lang('Save'), 'submit_partial[collapseEight]');
  425. $userForm->addHtml('</div></div></div>');
  426. $form->addButtonSave(get_lang('SaveDiagnosticChanges'), 'save');
  427. $form->addButtonSearch(get_lang('SearchSessions'), 'search');
  428. $extraFieldsToFilter = $extraField->get_all(['variable = ?' => 'temps_de_travail']);
  429. $extraFieldToSearch = [];
  430. if (!empty($extraFieldsToFilter)) {
  431. foreach ($extraFieldsToFilter as $filter) {
  432. $extraFieldToSearch[] = $filter['id'];
  433. }
  434. }
  435. $extraFieldListToString = implode(',', $extraFieldToSearch);
  436. $result = SessionManager::getGridColumns('simple', $extraFieldsToFilter);
  437. $columns = $result['columns'];
  438. $column_model = $result['column_model'];
  439. $form->setDefaults($defaults);
  440. /** @var HTML_QuickForm_select $element */
  441. $domaine1 = $form->getElementByName('extra_domaine[0]');
  442. $domaine2 = $form->getElementByName('extra_domaine[1]');
  443. $domaine3 = $form->getElementByName('extra_domaine[2]');
  444. $userForm->setDefaults($defaults);
  445. $domainList = array_merge(
  446. is_object($domaine1) && !empty($domaine1->getValue()) ? $domaine1->getValue() : [],
  447. is_object($domaine3) && !empty($domaine3->getValue()) ? $domaine3->getValue() : [],
  448. is_object($domaine2) && !empty($domaine2->getValue()) ? $domaine2->getValue() : []
  449. );
  450. $themeList = [];
  451. $extraField = new ExtraField('session');
  452. $resultOptions = $extraField->searchOptionsFromTags('extra_domaine', 'extra_'.$theme, $domainList);
  453. if ($resultOptions) {
  454. $resultOptions = array_column($resultOptions, 'tag', 'id');
  455. $resultOptions = array_filter($resultOptions);
  456. for ($i = 0; $i < 5; $i++) {
  457. /** @var HTML_QuickForm_select $theme */
  458. $themeElement = $form->getElementByName('extra_'.$theme.'['.$i.']');
  459. foreach ($resultOptions as $key => $value) {
  460. $themeElement->addOption($value, $value);
  461. }
  462. }
  463. }
  464. $filterToSend = '';
  465. if ($formSearch->validate()) {
  466. $formSearchParams = $formSearch->getSubmitValues();
  467. }
  468. // Search filter
  469. $filters = [];
  470. foreach ($defaults as $key => $value) {
  471. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  472. continue;
  473. }
  474. if (!empty($value)) {
  475. $filters[$key] = $value;
  476. }
  477. }
  478. $filterToSend = [];
  479. if (!empty($filters)) {
  480. $filterToSend = ['groupOp' => 'AND'];
  481. if ($filters) {
  482. $count = 1;
  483. $countExtraField = 1;
  484. foreach ($result['column_model'] as $column) {
  485. if ($count > 5) {
  486. if (isset($filters[$column['name']])) {
  487. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  488. $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
  489. }
  490. $countExtraField++;
  491. }
  492. $count++;
  493. }
  494. }
  495. }
  496. $params = [];
  497. if ($form->validate()) {
  498. $params = $form->getSubmitValues();
  499. $save = false;
  500. $search = false;
  501. if (isset($params['search'])) {
  502. unset($params['search']);
  503. $search = true;
  504. }
  505. if (isset($params['save'])) {
  506. $save = true;
  507. unset($params['save']);
  508. }
  509. $form->setDefaults($params);
  510. $filters = [];
  511. // Search
  512. if ($search) {
  513. // Parse params.
  514. foreach ($params as $key => $value) {
  515. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  516. continue;
  517. }
  518. if (!empty($value)) {
  519. $filters[$key] = $value;
  520. }
  521. }
  522. $filterToSend = [];
  523. if (!empty($filters)) {
  524. $filterToSend = ['groupOp' => 'AND'];
  525. if ($filters) {
  526. $count = 1;
  527. $countExtraField = 1;
  528. foreach ($result['column_model'] as $column) {
  529. if ($count > 5) {
  530. if (isset($filters[$column['name']])) {
  531. $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
  532. $filterToSend['rules'][] = [
  533. 'field' => $column['name'],
  534. 'op' => 'cn',
  535. 'data' => $filters[$column['name']],
  536. ];
  537. }
  538. $countExtraField++;
  539. }
  540. $count++;
  541. }
  542. }
  543. }
  544. }
  545. if ($save) {
  546. $userData = $params;
  547. // Update extra_heures_disponibilite_par_semaine
  548. $extraFieldValue = new ExtraFieldValue('user');
  549. $userDataToSave = [
  550. 'item_id' => $userToLoad,
  551. 'extra_heures_disponibilite_par_semaine' => isset($userData['extra_heures_disponibilite_par_semaine']) ? $userData['extra_heures_disponibilite_par_semaine'] : '',
  552. ];
  553. $extraFieldValue->saveFieldValues($userDataToSave, true, false, ['heures_disponibilite_par_semaine']);
  554. // Save session search
  555. /** @var \Chamilo\UserBundle\Entity\User $user */
  556. $user = $em->getRepository('ChamiloUserBundle:User')->find($userToLoad);
  557. $extraFieldValueSession = new ExtraFieldValue('session');
  558. $sessionFields = [
  559. 'extra_access_start_date',
  560. 'extra_access_end_date',
  561. 'extra_filiere',
  562. 'extra_domaine',
  563. 'extra_domaine[0]',
  564. 'extra_domaine[1]',
  565. 'extra_domaine[3]',
  566. 'extra_temps_de_travail',
  567. //'extra_competenceniveau',
  568. 'extra_'.$theme,
  569. 'extra_ecouter',
  570. 'extra_lire',
  571. 'extra_participer_a_une_conversation',
  572. 'extra_s_exprimer_oralement_en_continu',
  573. 'extra_ecrire',
  574. ];
  575. foreach ($userData as $key => $value) {
  576. $found = strpos($key, '__persist__');
  577. if ($found === false) {
  578. continue;
  579. }
  580. }
  581. if (isset($userData['extra_filiere_want_stage']) &&
  582. isset($userData['extra_filiere_want_stage']['extra_filiere_want_stage'])
  583. ) {
  584. $wantStage = $userData['extra_filiere_want_stage']['extra_filiere_want_stage'];
  585. if ($wantStage === 'yes') {
  586. if (isset($userData['extra_filiere_user'])) {
  587. $userData['extra_filiere'] = [];
  588. $userData['extra_filiere']['extra_filiere'] = $userData['extra_filiere_user']['extra_filiere_user'];
  589. }
  590. }
  591. }
  592. // save in ExtraFieldSavedSearch.
  593. foreach ($userData as $key => $value) {
  594. if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
  595. continue;
  596. }
  597. if (!in_array($key, $sessionFields)) {
  598. continue;
  599. }
  600. $field_variable = substr($key, 6);
  601. $extraFieldInfo = $extraFieldValueSession
  602. ->getExtraField()
  603. ->get_handler_field_info_by_field_variable($field_variable);
  604. if (!$extraFieldInfo) {
  605. continue;
  606. }
  607. $extraFieldObj = $em->getRepository('ChamiloCoreBundle:ExtraField')->find($extraFieldInfo['id']);
  608. $search = [
  609. 'field' => $extraFieldObj,
  610. 'user' => $user,
  611. ];
  612. /** @var ExtraFieldSavedSearch $saved */
  613. $saved = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findOneBy($search);
  614. if ($saved) {
  615. $saved
  616. ->setField($extraFieldObj)
  617. ->setUser($user)
  618. ->setValue($value)
  619. ;
  620. $em->merge($saved);
  621. } else {
  622. $saved = new ExtraFieldSavedSearch();
  623. $saved
  624. ->setField($extraFieldObj)
  625. ->setUser($user)
  626. ->setValue($value)
  627. ;
  628. $em->persist($saved);
  629. }
  630. $em->flush();
  631. }
  632. Display::addFlash(Display::return_message(get_lang('Saved'), 'success'));
  633. header('Location: '.api_get_self().'?user_id='.$userToLoad);
  634. exit;
  635. }
  636. }
  637. $view = $form->returnForm();
  638. $jsTag = '';
  639. if (!empty($tagsData)) {
  640. foreach ($tagsData as $extraField => $tags) {
  641. foreach ($tags as $tag) {
  642. $tag = api_htmlentities($tag);
  643. // $jsTag .= "$('#$extraField')[0].addItem('$tag', '$tag');";
  644. }
  645. }
  646. }
  647. $htmlHeadXtra[] = '<script>
  648. $(function() {
  649. '.$jqueryExtra.'
  650. '.$jsTag.'
  651. });
  652. </script>';
  653. if (!empty($filterToSend)) {
  654. // Get start and end date from ExtraFieldSavedSearch
  655. $defaultExtraStartDate = isset($defaults['extra_access_start_date']) ? $defaults['extra_access_start_date'] : '';
  656. $defaultExtraEndDate = isset($defaults['extra_access_end_date']) ? $defaults['extra_access_end_date'] : '';
  657. $userStartDate = isset($params['extra_access_start_date']) ? $params['extra_access_start_date'] : $defaultExtraStartDate;
  658. $userEndDate = isset($params['extra_access_end_date']) ? $params['extra_access_end_date'] : $defaultExtraEndDate;
  659. // Minus 3 days
  660. $date = new DateTime($userStartDate);
  661. $date->sub(new DateInterval('P3D'));
  662. $userStartDateMinus = $date->format('Y-m-d h:i:s');
  663. // Plus 2 days
  664. $date = new DateTime($userEndDate);
  665. $date->add(new DateInterval('P2D'));
  666. $userEndDatePlus = $date->format('Y-m-d h:i:s');
  667. // Ofaj fix
  668. $userStartDateMinus = api_get_utc_datetime(substr($userStartDateMinus, 0, 11).'00:00:00');
  669. $userEndDatePlus = api_get_utc_datetime(substr($userEndDatePlus, 0, 11).'23:59:59');
  670. // Special OFAJ date logic
  671. if ($userEndDate == '') {
  672. $sql = " AND (
  673. (s.access_start_date >= '$userStartDateMinus') OR
  674. ((s.access_start_date = '' OR s.access_start_date IS NULL) AND (s.access_end_date = '' OR s.access_end_date IS NULL))
  675. )";
  676. } else {
  677. $sql = " AND (
  678. (s.access_start_date >= '$userStartDateMinus' AND s.access_end_date < '$userEndDatePlus') OR
  679. (s.access_start_date >= '$userStartDateMinus' AND (s.access_end_date = '' OR s.access_end_date IS NULL)) OR
  680. ((s.access_start_date = '' OR s.access_start_date IS NULL) AND (s.access_end_date = '' OR s.access_end_date IS NULL))
  681. )";
  682. }
  683. $deleteFiliere = false;
  684. $extraFieldOptions = new ExtraFieldOption('session');
  685. $extraFieldSession = new ExtraField('session');
  686. // Special filters
  687. // see https://task.beeznest.com/issues/10849#change-81902
  688. foreach ($filterToSend['rules'] as &$filterItem) {
  689. if (isset($filterItem['field'])) {
  690. switch ($filterItem['field']) {
  691. case 'extra_ecouter':
  692. case 'extra_lire':
  693. case 'extra_participer_a_une_conversation':
  694. case 'extra_s_exprimer_oralement_en_continu':
  695. case 'extra_ecrire':
  696. $selectedValue = '';
  697. $fieldExtra = str_replace('extra_', '', $filterItem['field']);
  698. $extraFieldSessionData = $extraFieldSession->get_handler_field_info_by_field_variable($fieldExtra);
  699. if (is_array($filterItem['data'])) {
  700. $myOrder = [];
  701. foreach ($filterItem['data'] as $option) {
  702. foreach ($extraFieldSessionData['options'] as $optionValue) {
  703. if ($option == $optionValue['option_value']) {
  704. $myOrder[$optionValue['option_order']] = $optionValue['option_value'];
  705. }
  706. }
  707. }
  708. if (!empty($myOrder)) {
  709. // Taking last from list
  710. $selectedValue = end($myOrder);
  711. }
  712. } else {
  713. $selectedValue = $filterItem['data'];
  714. }
  715. $newOptions = array_column(
  716. $extraFieldSessionData['options'],
  717. 'option_value',
  718. 'option_order'
  719. );
  720. $searchOptions = [];
  721. for ($i = 1; $i < count($newOptions); $i++) {
  722. if ($selectedValue == $newOptions[$i]) {
  723. if (isset($newOptions[$i - 1])) {
  724. $searchOptions[] = $newOptions[$i - 1];
  725. }
  726. if (isset($newOptions[$i])) {
  727. $searchOptions[] = $newOptions[$i];
  728. }
  729. if (isset($newOptions[$i + 1])) {
  730. $searchOptions[] = $newOptions[$i + 1];
  731. }
  732. break;
  733. }
  734. }
  735. $filterItem['data'] = $searchOptions;
  736. break;
  737. case 'extra_domaine':
  738. // Special condition see:
  739. // https://task.beeznest.com/issues/10849#note-218
  740. // Remove filiere
  741. $list = [
  742. 'vie-quotidienne',
  743. //'competente-dans-mon-domaine-de-specialite',
  744. 'arrivee-sur-mon-poste-de-travail',
  745. ];
  746. $deleteFiliere = false;
  747. if (is_array($filterItem['data'])) {
  748. $myOrder = [];
  749. foreach ($filterItem['data'] as $option) {
  750. if (in_array($option, $list)) {
  751. $deleteFiliere = true;
  752. break;
  753. }
  754. }
  755. } else {
  756. if (in_array($filterItem['data'], $list)) {
  757. $deleteFiliere = true;
  758. }
  759. }
  760. break;
  761. }
  762. }
  763. if ($deleteFiliere) {
  764. foreach ($filterToSend['rules'] as &$filterItem) {
  765. if (isset($filterItem['field']) && $filterItem['field'] == 'extra_filiere') {
  766. $filterItem = [];
  767. }
  768. }
  769. }
  770. }
  771. if ($userStartDate && !empty($userStartDate)) {
  772. $filterToSend['custom_dates'] = $sql;
  773. }
  774. $filterToSend = json_encode($filterToSend);
  775. $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;
  776. } else {
  777. $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';
  778. }
  779. // Autowidth
  780. $extra_params['autowidth'] = 'true';
  781. // height auto
  782. $extra_params['height'] = 'auto';
  783. $extra_params['postData'] = [
  784. 'filters' => [
  785. "groupOp" => "AND",
  786. "rules" => $result['rules'],
  787. ],
  788. ];
  789. $sessionByUserList = SessionManager::get_sessions_by_user($userToLoad, true, true);
  790. $sessionUserList = [];
  791. if (!empty($sessionByUserList)) {
  792. foreach ($sessionByUserList as $sessionByUser) {
  793. $sessionUserList[] = (string) $sessionByUser['session_id'];
  794. }
  795. }
  796. $action_links = 'function action_formatter(cellvalue, options, rowObject) {
  797. var sessionList = '.json_encode($sessionUserList).';
  798. var id = options.rowId.toString();
  799. if (sessionList.indexOf(id) == -1) {
  800. return \'<a href="'.api_get_self().'?action=subscribe_user&user_id='.$userToLoad.'&session_id=\'+id+\'">'.Display::return_icon('add.png', addslashes(get_lang('Subscribe')), '', ICON_SIZE_SMALL).'</a>'.'\';
  801. } else {
  802. return \'<a href="'.api_get_self().'?action=unsubscribe_user&user_id='.$userToLoad.'&session_id=\'+id+\'">'.Display::return_icon('delete.png', addslashes(get_lang('Delete')), '', ICON_SIZE_SMALL).'</a>'.'\';
  803. }
  804. }';
  805. $htmlHeadXtra[] = api_get_jqgrid_js();
  806. $griJs = Display::grid_js(
  807. 'sessions',
  808. $url,
  809. $columns,
  810. $column_model,
  811. $extra_params,
  812. [],
  813. $action_links,
  814. true
  815. );
  816. $grid = '<div id="session-table" class="table-responsive">';
  817. $grid .= Display::grid_html('sessions');
  818. $grid .= '</div>';
  819. $htmlHeadXtra[] = '<style>
  820. .control-label {
  821. width: 25% !important;
  822. }
  823. </style>';
  824. $htmlHeadXtra[] = '<script>
  825. $(document).ready(function() {
  826. var blocks = [
  827. "#collapseOne",
  828. "#collapseTwo",
  829. "#collapseThree",
  830. "#collapseFour",
  831. "#collapseFive",
  832. "#collapseSix",
  833. "#collapseSeven",
  834. "#collapseEight"
  835. ];
  836. $.each(blocks, function( index, value ) {
  837. $(value).collapse("hide");
  838. });
  839. });
  840. </script>';
  841. $tpl = new Template(get_lang('Diagnosis'));
  842. if (empty($items)) {
  843. $view = '';
  844. $grid = '';
  845. $griJs = '';
  846. }
  847. $tpl->assign('form', $view);
  848. $tpl->assign('form_search', $formSearch->returnForm().$userForm->returnForm());
  849. $table = new HTML_Table(['class' => 'data_table']);
  850. $column = 0;
  851. $row = 0;
  852. $total = '0';
  853. $sumHours = '0';
  854. $numHours = '0';
  855. $field = 'heures_disponibilite_par_semaine';
  856. $extraField = new ExtraFieldValue('user');
  857. $data = $extraField->get_values_by_handler_and_field_variable($userToLoad, $field);
  858. $availableHoursPerWeek = 0;
  859. function dateDiffInWeeks($date1, $date2)
  860. {
  861. if ($date1 > $date2) {
  862. return dateDiffInWeeks($date2, $date1);
  863. }
  864. $first = new \DateTime($date1);
  865. $second = new \DateTime($date2);
  866. return floor($first->diff($second)->days / 7);
  867. }
  868. if ($data) {
  869. $availableHoursPerWeek = $data['value'];
  870. $numberWeeks = 0;
  871. if ($form->validate()) {
  872. $formData = $form->getSubmitValues();
  873. if (isset($formData['extra_access_start_date']) && isset($formData['extra_access_end_date'])) {
  874. $startDate = $formData['extra_access_start_date'];
  875. $endDate = $formData['extra_access_end_date'];
  876. $numberWeeks = dateDiffInWeeks($startDate, $endDate);
  877. }
  878. } else {
  879. if ($defaults) {
  880. if (isset($defaults['extra_access_start_date']) && isset($defaults['extra_access_end_date'])) {
  881. $startDate = $defaults['extra_access_start_date'];
  882. $endDate = $defaults['extra_access_end_date'];
  883. $numberWeeks = dateDiffInWeeks($startDate, $endDate);
  884. }
  885. }
  886. }
  887. $total = $numberWeeks * $availableHoursPerWeek;
  888. $sessions = SessionManager::getSessionsFollowedByUser($userToLoad);
  889. if ($sessions) {
  890. $sessionFieldValue = new ExtraFieldValue('session');
  891. foreach ($sessions as $session) {
  892. $sessionId = $session['id'];
  893. $data = $sessionFieldValue->get_values_by_handler_and_field_variable(
  894. $sessionId,
  895. 'temps_de_travail'
  896. );
  897. if ($data) {
  898. $sumHours += $data['value'];
  899. }
  900. }
  901. }
  902. }
  903. $numHours = $total - $sumHours;
  904. $headers = [
  905. get_lang('TotalAvailableHours') => $total,
  906. get_lang('SumHoursSessionsSubscribed') => $sumHours,
  907. get_lang('CountHoursAvailable') => $numHours,
  908. ];
  909. foreach ($headers as $header => $value) {
  910. $table->setCellContents($row, 0, $header);
  911. $table->updateCellAttributes($row, 0, 'width="250px"');
  912. $table->setCellContents($row, 1, $value);
  913. $row++;
  914. }
  915. $button = '';
  916. if ($userToLoad) {
  917. $button = Display::url(
  918. get_lang('OfajEndOfLearnPath'),
  919. api_get_path(WEB_CODE_PATH).'messages/new_message.php?prefill=ofaj&send_to_user='.$userToLoad,
  920. ['class' => 'btn btn-default']
  921. );
  922. $button .= '<br /><br />';
  923. }
  924. $userReportButton = Display::url(
  925. get_lang('DiagnosticValidateLearningPath'),
  926. api_get_path(WEB_CODE_PATH).'mySpace/myStudents.php?student='.$userToLoad,
  927. ['class' => 'btn btn-primary']
  928. );
  929. $tpl->assign('grid', $grid.$button.$table->toHtml().$userReportButton);
  930. $tpl->assign('grid_js', $griJs);
  931. $content = $tpl->fetch('default/user_portal/search_extra_field.tpl');
  932. $tpl->assign('content', $content);
  933. $tpl->display_one_col_template();