1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015 |
- <?php
- /* For licensing terms, see /license.txt */
- use Chamilo\CoreBundle\Entity\ExtraFieldSavedSearch;
- $cidReset = true;
- require_once 'main/inc/global.inc.php';
- $htmlHeadXtra[] = '<link href="'.api_get_path(WEB_PATH).'web/assets/cropper/dist/cropper.min.css" rel="stylesheet">';
- $htmlHeadXtra[] = '<script src="'.api_get_path(WEB_PATH).'web/assets/cropper/dist/cropper.min.js"></script>';
- $htmlHeadXtra[] = '<script>
- $(document).ready(function() {
- /*$("#filiere_panel").hide();
- $("#dispo_panel").hide();
- $("#dispo_pendant_panel").hide();
- $("#niveau_panel").hide();
- $("#methode_panel").hide();
- $("#themes_panel").hide();
- $("#objectifs_panel").hide();*/
-
- $("#filiere").on("click", function() {
- $("#filiere_panel").toggle();
- return false;
- });
-
- $("#dispo").on("click", function() {
- $("#dispo_panel").toggle();
- return false;
- });
-
- $("#dispo_pendant").on("click", function() {
- $("#dispo_pendant_panel").toggle();
- return false;
- });
-
- $("#niveau").on("click", function() {
- $("#niveau_panel").toggle();
- return false;
- });
-
- $("#methode").on("click", function() {
- $("#methode_panel").toggle();
- return false;
- });
-
- $("#themes").on("click", function() {
- $("#themes_panel").toggle();
- return false;
- });
-
- $("#objectifs").on("click", function() {
- $("#objectifs_panel").toggle();
- return false;
- });
- });
- </script>';
- api_block_anonymous_users();
- $allowToSee = api_is_drh() || api_is_student_boss() || api_is_platform_admin();
- if ($allowToSee === false) {
- api_not_allowed(true);
- }
- $userId = api_get_user_id();
- $userInfo = api_get_user_info();
- $userToLoad = isset($_GET['user_id']) ? $_GET['user_id'] : '';
- $userToLoadInfo = [];
- if ($userToLoad) {
- $userToLoadInfo = api_get_user_info($userToLoad);
- }
- $action = isset($_GET['action']) ? $_GET['action'] : '';
- switch ($action) {
- case 'subscribe_user':
- $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
- SessionManager::subscribe_users_to_session(
- $sessionId,
- [$userToLoad],
- SESSION_VISIBLE_READ_ONLY,
- false
- );
- Display::addFlash(Display::return_message(get_lang('UserAdded')));
- header("Location: ".api_get_self().'?user_id='.$userToLoad.'#session-table');
- exit;
- break;
- case 'unsubscribe_user':
- $sessionId = isset($_GET['session_id']) ? $_GET['session_id'] : '';
- SessionManager::unsubscribe_user_from_session($sessionId, $userToLoad);
- Display::addFlash(Display::return_message(get_lang('Unsubscribed')));
- header("Location: ".api_get_self().'?user_id='.$userToLoad.'#session-table');
- break;
- }
- $em = Database::getManager();
- $formSearch = new FormValidator('load', 'get', api_get_self());
- $formSearch->addHeader(get_lang('LoadDiagnosis'));
- if (!empty($userInfo)) {
- $users = [];
- switch ($userInfo['status']) {
- case DRH:
- $users = UserManager::get_users_followed_by_drh($userId);
- break;
- case STUDENT_BOSS:
- $users = UserManager::getUsersFollowedByStudentBoss($userId);
- break;
- }
- if (!empty($users)) {
- $userList = [];
- foreach ($users as $user) {
- $userList[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);
- }
- $formSearch->addSelect('user_id', get_lang('User'), $userList);
- }
- }
- if ($userToLoad) {
- $formSearch->setDefaults(['user_id' => $userToLoad]);
- }
- $formSearch->addButtonSearch(get_lang('ShowDiagnostic'), 'save');
- $form = new FormValidator('search', 'post', api_get_self().'?user_id='.$userToLoad.'#session-table');
- $form->addHeader(get_lang('Diagnosis'));
- $form->addHidden('user_id', $userToLoad);
- /** @var ExtraFieldSavedSearch $saved */
- $search = [
- 'user' => $userToLoad,
- ];
- $items = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findBy($search);
- if (empty($items)) {
- Display::addFlash(Display::return_message('NoData'));
- }
- $defaults = [];
- $tagsData = [];
- if (!empty($items)) {
- /** @var ExtraFieldSavedSearch $item */
- foreach ($items as $item) {
- $variable = 'extra_'.$item->getField()->getVariable();
- if ($item->getField()->getFieldType() == ExtraField::FIELD_TYPE_TAG) {
- $tagsData[$variable] = $item->getValue();
- }
- $defaults[$variable] = $item->getValue();
- }
- }
- $extraField = new ExtraField('session');
- $extraFieldValue = new ExtraFieldValue('session');
- $theme = 'theme_fr';
- if ($userToLoadInfo) {
- $lang = $userToLoadInfo['language'];
- switch ($lang) {
- case 'french2':
- case 'french':
- $theme = 'theme_fr';
- break;
- case 'german2':
- case 'german':
- $theme = 'theme_de';
- break;
- }
- }
- $extraFieldUser = new ExtraField('user');
- $userForm = new FormValidator('user_form', 'post', api_get_self());
- $userForm->addHtml('<div class="panel-group" id="search_extrafield" role="tablist" aria-multiselectable="true">');
- $userForm->addHtml('<div class="panel panel-default">');
- $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>');
- $userForm->addHtml('<div id="collapseOne" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">');
- $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('FiliereExplanation').'</p>');
- $fieldsToShow = [
- 'statusocial',
- 'filiere_user',
- 'filiereprecision',
- 'filiere_want_stage',
- ];
- $forceShowFields = true;
- $filter = false;
- $extra = $extraFieldUser->addElements(
- $userForm,
- $userToLoad,
- [],
- $filter,
- true,
- $fieldsToShow,
- $fieldsToShow,
- [],
- [],
- false,
- $forceShowFields, //$forceShowFields = false
- [],
- [],
- $fieldsToShow
- );
- $userForm->addHtml('</div></div></div>');
- $userForm->addHtml('<div class="panel panel-default">');
- $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>');
- $userForm->addHtml('<div id="collapseThree" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingThree">');
- $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('DisponibilitePendantMonStageExplanation').'</p>');
- $fieldsToShow = [
- 'datedebutstage',
- 'datefinstage',
- 'poursuiteapprentissagestage',
- 'heures_disponibilite_par_semaine_stage',
- ];
- $extra = $extraFieldUser->addElements(
- $userForm,
- $userToLoad,
- [],
- $filter,
- true,
- $fieldsToShow,
- $fieldsToShow,
- [],
- [],
- false,
- $forceShowFields, //$forceShowFields = false
- [],
- [],
- $fieldsToShow
- );
- $userForm->addHtml('</div></div></div>');
- $userForm->addHtml('<div class="panel panel-default">');
- $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>');
- $userForm->addHtml('<div id="collapseSix" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingSix">');
- $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('ObjectifsApprentissageExplanation').'</p>');
- $fieldsToShow = [
- 'objectif_apprentissage',
- ];
- $extra = $extraFieldUser->addElements(
- $userForm,
- $userToLoad,
- [],
- $filter,
- false,
- $fieldsToShow,
- $fieldsToShow,
- $defaults,
- [],
- false,
- $forceShowFields,//$forceShowFields = false
- [],
- [],
- $fieldsToShow
- );
- $userForm->addHtml('</div></div></div>');
- $userForm->addHtml('<div class="panel panel-default">');
- $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>');
- $userForm->addHtml('<div id="collapseSeven" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingSeven">');
- $userForm->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('MethodeTravailExplanation').'</p>');
- $fieldsToShow = [
- 'methode_de_travaille',
- 'accompagnement',
- ];
- $extra = $extraFieldUser->addElements(
- $userForm,
- $userToLoad,
- [],
- $filter,
- true,
- $fieldsToShow,
- $fieldsToShow,
- [],
- [],
- false,
- $forceShowFields, //$forceShowFields = false
- [],
- [],
- $fieldsToShow
- );
- $userForm->addHtml('</div></div></div>');
- $form->addHtml('<div class="panel panel-default">');
- $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>');
- $form->addHtml('<div id="collapseTwo" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingTwo">');
- $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('DisponibiliteAvantExplanation').'</p>');
- // Session fields
- $showOnlyThisFields = [
- 'access_start_date',
- 'access_end_date',
- ];
- $extra = $extraField->addElements(
- $form,
- '',
- [],
- false, //filter
- true,
- $showOnlyThisFields,
- $showOnlyThisFields,
- $defaults,
- [],
- false, //$orderDependingDefaults
- true, // force
- [], // $separateExtraMultipleSelect
- []
- );
- $fieldsToShow = [
- 'heures_disponibilite_par_semaine',
- ];
- $extra = $extraFieldUser->addElements(
- $form,
- $userToLoad,
- [],
- $filter,
- true,
- $fieldsToShow,
- $fieldsToShow,
- [],
- [],
- false,
- $forceShowFields //$forceShowFields = false
- );
- $form->addHtml('</div></div></div>');
- $form->addHtml('<div class="panel panel-default">');
- $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>');
- $form->addHtml('<div id="collapseFour" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingFour">');
- $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('ThemesObjectifsExplanation').'</p>');
- $showOnlyThisFields = [
- 'domaine',
- 'filiere',
- $theme,
- ];
- $extra = $extraField->addElements(
- $form,
- '',
- [],
- false, //filter
- true,
- $showOnlyThisFields,
- $showOnlyThisFields,
- $defaults,
- [],
- false, //$orderDependingDefaults
- true, // force
- ['domaine' => 3, $theme => 5], // $separateExtraMultipleSelect
- [
- 'domaine' => [
- get_lang('Domaine').' 1',
- get_lang('Domaine').' 2',
- get_lang('Domaine').' 3',
- ],
- $theme => [
- get_lang('ThemeField').' 1',
- get_lang('ThemeField').' 2',
- get_lang('ThemeField').' 3',
- get_lang('ThemeField').' 4',
- get_lang('ThemeField').' 5',
- ],
- ],
- [],
- true
- );
- $form->addHtml('</div></div></div>');
- $form->addHtml('<div class="panel panel-default">');
- $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>');
- $form->addHtml('<div id="collapseFive" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingFive">');
- $form->addHtml('<div class="panel-body"><p class="text-info">'.get_lang('NiveauLangueExplanation').'</p>');
- $showOnlyThisFields = [
- 'ecouter',
- 'lire',
- 'participer_a_une_conversation',
- 's_exprimer_oralement_en_continu',
- 'ecrire',
- ];
- $extra = $extraField->addElements(
- $form,
- '',
- [],
- false, //filter
- true,
- $showOnlyThisFields,
- $showOnlyThisFields,
- $defaults,
- [],
- false, //$orderDependingDefaults
- true, // force
- ['domaine' => 3, $theme => 5], // $separateExtraMultipleSelect
- [
- 'domaine' => [
- get_lang('Domaine').' 1',
- get_lang('Domaine').' 2',
- get_lang('Domaine').' 3',
- ],
- $theme => [
- get_lang('Theme').' 1',
- get_lang('Theme').' 2',
- get_lang('Theme').' 3',
- get_lang('Theme').' 4',
- get_lang('Theme').' 5',
- ],
- ]
- );
- $form->addHtml('</div></div></div>');
- $form->addButtonSave(get_lang('SaveDiagnosticChanges'), 'save');
- $form->addButtonSearch(get_lang('SearchSessions'), 'search');
- $extraFieldsToFilter = $extraField->get_all(['variable = ?' => 'temps_de_travail']);
- $extraFieldToSearch = [];
- if (!empty($extraFieldsToFilter)) {
- foreach ($extraFieldsToFilter as $filter) {
- $extraFieldToSearch[] = $filter['id'];
- }
- }
- $extraFieldListToString = implode(',', $extraFieldToSearch);
- $result = SessionManager::getGridColumns('simple', $extraFieldsToFilter);
- $columns = $result['columns'];
- $column_model = $result['column_model'];
- $form->setDefaults($defaults);
- /** @var HTML_QuickForm_select $element */
- $domaine1 = $form->getElementByName('extra_domaine[0]');
- $domaine2 = $form->getElementByName('extra_domaine[1]');
- $domaine3 = $form->getElementByName('extra_domaine[2]');
- $userForm->setDefaults($defaults);
- $domainList = array_merge(
- is_object($domaine1) && !empty($domaine1->getValue()) ? $domaine1->getValue() : [],
- is_object($domaine3) && !empty($domaine3->getValue()) ? $domaine3->getValue() : [],
- is_object($domaine2) && !empty($domaine2->getValue()) ? $domaine2->getValue() : []
- );
- $themeList = [];
- $extraField = new ExtraField('session');
- $resultOptions = $extraField->searchOptionsFromTags('extra_domaine', 'extra_'.$theme, $domainList);
- if ($resultOptions) {
- $resultOptions = array_column($resultOptions, 'tag', 'id');
- $resultOptions = array_filter($resultOptions);
- for ($i = 0; $i < 5; $i++) {
- /** @var HTML_QuickForm_select $theme */
- $themeElement = $form->getElementByName('extra_'.$theme.'['.$i.']');
- foreach ($resultOptions as $key => $value) {
- $themeElement->addOption($value, $value);
- }
- }
- }
- $filterToSend = '';
- if ($formSearch->validate()) {
- $formSearchParams = $formSearch->getSubmitValues();
- }
- // Search filter
- $filters = [];
- foreach ($defaults as $key => $value) {
- if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
- continue;
- }
- if (!empty($value)) {
- $filters[$key] = $value;
- }
- }
- $filterToSend = [];
- if (!empty($filters)) {
- $filterToSend = ['groupOp' => 'AND'];
- if ($filters) {
- $count = 1;
- $countExtraField = 1;
- foreach ($result['column_model'] as $column) {
- if ($count > 5) {
- if (isset($filters[$column['name']])) {
- $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
- $filterToSend['rules'][] = ['field' => $column['name'], 'op' => 'cn', 'data' => $filters[$column['name']]];
- }
- $countExtraField++;
- }
- $count++;
- }
- }
- }
- $params = [];
- if ($form->validate()) {
- $params = $form->getSubmitValues();
- $save = false;
- $search = false;
- if (isset($params['search'])) {
- unset($params['search']);
- $search = true;
- }
- if (isset($params['save'])) {
- $save = true;
- unset($params['save']);
- }
- $form->setDefaults($params);
- $filters = [];
- // Search
- if ($search) {
- // Parse params.
- foreach ($params as $key => $value) {
- if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
- continue;
- }
- if (!empty($value)) {
- $filters[$key] = $value;
- }
- }
- $filterToSend = [];
- if (!empty($filters)) {
- $filterToSend = ['groupOp' => 'AND'];
- if ($filters) {
- $count = 1;
- $countExtraField = 1;
- foreach ($result['column_model'] as $column) {
- if ($count > 5) {
- if (isset($filters[$column['name']])) {
- $defaultValues['jqg'.$countExtraField] = $filters[$column['name']];
- $filterToSend['rules'][] = [
- 'field' => $column['name'],
- 'op' => 'cn',
- 'data' => $filters[$column['name']],
- ];
- }
- $countExtraField++;
- }
- $count++;
- }
- }
- }
- }
- if ($save) {
- $userData = $params;
- // Update extra_heures_disponibilite_par_semaine
- $extraFieldValue = new ExtraFieldValue('user');
- $userDataToSave = [
- 'item_id' => $userToLoad,
- 'extra_heures_disponibilite_par_semaine' => isset($userData['extra_heures_disponibilite_par_semaine']) ? $userData['extra_heures_disponibilite_par_semaine'] : '',
- ];
- $extraFieldValue->saveFieldValues($userDataToSave, true, false, ['heures_disponibilite_par_semaine']);
- // Save session search
- /** @var \Chamilo\UserBundle\Entity\User $user */
- $user = $em->getRepository('ChamiloUserBundle:User')->find($userToLoad);
- $extraFieldValueSession = new ExtraFieldValue('session');
- $sessionFields = [
- 'extra_access_start_date',
- 'extra_access_end_date',
- 'extra_filiere',
- 'extra_domaine',
- 'extra_domaine[0]',
- 'extra_domaine[1]',
- 'extra_domaine[3]',
- 'extra_temps_de_travail',
- //'extra_competenceniveau',
- 'extra_'.$theme,
- 'extra_ecouter',
- 'extra_lire',
- 'extra_participer_a_une_conversation',
- 'extra_s_exprimer_oralement_en_continu',
- 'extra_ecrire',
- ];
- foreach ($userData as $key => $value) {
- $found = strpos($key, '__persist__');
- if ($found === false) {
- continue;
- }
- }
- if (isset($userData['extra_filiere_want_stage']) &&
- isset($userData['extra_filiere_want_stage']['extra_filiere_want_stage'])
- ) {
- $wantStage = $userData['extra_filiere_want_stage']['extra_filiere_want_stage'];
- if ($wantStage === 'yes') {
- if (isset($userData['extra_filiere_user'])) {
- $userData['extra_filiere'] = [];
- $userData['extra_filiere']['extra_filiere'] = $userData['extra_filiere_user']['extra_filiere_user'];
- }
- }
- }
- // save in ExtraFieldSavedSearch.
- foreach ($userData as $key => $value) {
- if (substr($key, 0, 6) != 'extra_' && substr($key, 0, 7) != '_extra_') {
- continue;
- }
- if (!in_array($key, $sessionFields)) {
- continue;
- }
- $field_variable = substr($key, 6);
- $extraFieldInfo = $extraFieldValueSession
- ->getExtraField()
- ->get_handler_field_info_by_field_variable($field_variable);
- if (!$extraFieldInfo) {
- continue;
- }
- $extraFieldObj = $em->getRepository('ChamiloCoreBundle:ExtraField')->find($extraFieldInfo['id']);
- $search = [
- 'field' => $extraFieldObj,
- 'user' => $user,
- ];
- /** @var ExtraFieldSavedSearch $saved */
- $saved = $em->getRepository('ChamiloCoreBundle:ExtraFieldSavedSearch')->findOneBy($search);
- if ($saved) {
- $saved
- ->setField($extraFieldObj)
- ->setUser($user)
- ->setValue($value)
- ;
- $em->merge($saved);
- } else {
- $saved = new ExtraFieldSavedSearch();
- $saved
- ->setField($extraFieldObj)
- ->setUser($user)
- ->setValue($value)
- ;
- $em->persist($saved);
- }
- $em->flush();
- }
- Display::addFlash(Display::return_message(get_lang('Saved'), 'success'));
- header('Location: '.api_get_self().'?user_id='.$userToLoad);
- exit;
- }
- }
- $view = $form->returnForm();
- $jsTag = '';
- if (!empty($tagsData)) {
- foreach ($tagsData as $extraField => $tags) {
- foreach ($tags as $tag) {
- $tag = api_htmlentities($tag);
- // $jsTag .= "$('#$extraField')[0].addItem('$tag', '$tag');";
- }
- }
- }
- $htmlHeadXtra[] = '<script>
- $(function() {
- '.$extra['jquery_ready_content'].'
- '.$jsTag.'
- });
- </script>';
- if (!empty($filterToSend)) {
- // Get start and end date from ExtraFieldSavedSearch
- $defaultExtraStartDate = isset($defaults['extra_access_start_date']) ? $defaults['extra_access_start_date'] : '';
- $defaultExtraEndDate = isset($defaults['extra_access_end_date']) ? $defaults['extra_access_end_date'] : '';
- $userStartDate = isset($params['extra_access_start_date']) ? $params['extra_access_start_date'] : $defaultExtraStartDate;
- $userEndDate = isset($params['extra_access_end_date']) ? $params['extra_access_end_date'] : $defaultExtraEndDate;
- // Minus 3 days
- $date = new DateTime($userStartDate);
- $date->sub(new DateInterval('P3D'));
- $userStartDateMinus = $date->format('Y-m-d h:i:s');
- // Plus 2 days
- $date = new DateTime($userEndDate);
- $date->add(new DateInterval('P2D'));
- $userEndDatePlus = $date->format('Y-m-d h:i:s');
- // Ofaj fix
- $userStartDateMinus = api_get_utc_datetime(substr($userStartDateMinus, 0, 11).'00:00:00');
- $userEndDatePlus = api_get_utc_datetime(substr($userEndDatePlus, 0, 11).'23:59:59');
- // Special OFAJ date logic
- if ($userEndDate == '') {
- $sql = " AND (
- (s.access_start_date >= '$userStartDateMinus') OR
- ((s.access_start_date = '' OR s.access_start_date IS NULL) AND (s.access_end_date = '' OR s.access_end_date IS NULL))
- )";
- } else {
- $sql = " AND (
- (s.access_start_date >= '$userStartDateMinus' AND s.access_end_date < '$userEndDatePlus') OR
- (s.access_start_date >= '$userStartDateMinus' AND (s.access_end_date = '' OR s.access_end_date IS NULL)) OR
- ((s.access_start_date = '' OR s.access_start_date IS NULL) AND (s.access_end_date = '' OR s.access_end_date IS NULL))
- )";
- }
- $deleteFiliere = false;
- $extraFieldOptions = new ExtraFieldOption('session');
- $extraFieldSession = new ExtraField('session');
- // Special filters
- // see https://task.beeznest.com/issues/10849#change-81902
- foreach ($filterToSend['rules'] as &$filterItem) {
- if (isset($filterItem['field'])) {
- switch ($filterItem['field']) {
- case 'extra_ecouter':
- case 'extra_lire':
- case 'extra_participer_a_une_conversation':
- case 'extra_s_exprimer_oralement_en_continu':
- case 'extra_ecrire':
- $selectedValue = '';
- $fieldExtra = str_replace('extra_', '', $filterItem['field']);
- $extraFieldSessionData = $extraFieldSession->get_handler_field_info_by_field_variable($fieldExtra);
- if (is_array($filterItem['data'])) {
- $myOrder = [];
- foreach ($filterItem['data'] as $option) {
- foreach ($extraFieldSessionData['options'] as $optionValue) {
- if ($option == $optionValue['option_value']) {
- $myOrder[$optionValue['option_order']] = $optionValue['option_value'];
- }
- }
- }
- if (!empty($myOrder)) {
- // Taking last from list
- $selectedValue = end($myOrder);
- }
- } else {
- $selectedValue = $filterItem['data'];
- }
- $newOptions = array_column(
- $extraFieldSessionData['options'],
- 'option_value',
- 'option_order'
- );
- $searchOptions = [];
- for ($i = 1; $i < count($newOptions); $i++) {
- if ($selectedValue == $newOptions[$i]) {
- if (isset($newOptions[$i - 1])) {
- $searchOptions[] = $newOptions[$i - 1];
- }
- if (isset($newOptions[$i])) {
- $searchOptions[] = $newOptions[$i];
- }
- if (isset($newOptions[$i + 1])) {
- $searchOptions[] = $newOptions[$i + 1];
- }
- break;
- }
- }
- $filterItem['data'] = $searchOptions;
- break;
- case 'extra_domaine':
- // Special condition see:
- // https://task.beeznest.com/issues/10849#note-218
- // Remove filiere
- $list = [
- 'vie-quotidienne',
- //'competente-dans-mon-domaine-de-specialite',
- 'arrivee-sur-mon-poste-de-travail',
- ];
- $deleteFiliere = false;
- if (is_array($filterItem['data'])) {
- $myOrder = [];
- foreach ($filterItem['data'] as $option) {
- if (in_array($option, $list)) {
- $deleteFiliere = true;
- break;
- }
- }
- } else {
- if (in_array($filterItem['data'], $list)) {
- $deleteFiliere = true;
- }
- }
- break;
- }
- }
- if ($deleteFiliere) {
- foreach ($filterToSend['rules'] as &$filterItem) {
- if (isset($filterItem['field']) && $filterItem['field'] == 'extra_filiere') {
- $filterItem = [];
- }
- }
- }
- }
- if ($userStartDate && !empty($userStartDate)) {
- $filterToSend['custom_dates'] = $sql;
- }
- $filterToSend = json_encode($filterToSend);
- $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;
- } else {
- $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';
- }
- // Autowidth
- $extra_params['autowidth'] = 'true';
- // height auto
- $extra_params['height'] = 'auto';
- $extra_params['postData'] = [
- 'filters' => [
- "groupOp" => "AND",
- "rules" => $result['rules'],
- ],
- ];
- $sessionByUserList = SessionManager::get_sessions_by_user($userToLoad, true, true);
- $sessionUserList = [];
- if (!empty($sessionByUserList)) {
- foreach ($sessionByUserList as $sessionByUser) {
- $sessionUserList[] = (string) $sessionByUser['session_id'];
- }
- }
- $action_links = 'function action_formatter(cellvalue, options, rowObject) {
- var sessionList = '.json_encode($sessionUserList).';
- var id = options.rowId.toString();
- if (sessionList.indexOf(id) == -1) {
- 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>'.'\';
- } else {
- 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>'.'\';
- }
- }';
- $htmlHeadXtra[] = api_get_jqgrid_js();
- $griJs = Display::grid_js(
- 'sessions',
- $url,
- $columns,
- $column_model,
- $extra_params,
- [],
- $action_links,
- true
- );
- $grid = '<div id="session-table" class="table-responsive">';
- $grid .= Display::grid_html('sessions');
- $grid .= '</div>';
- $htmlHeadXtra[] = '<style>
- .control-label {
- width: 25% !important;
- }
- </style>';
- $htmlHeadXtra[] = '<script>
- $(document).ready(function() {
- var blocks = [
- "#collapseOne",
- "#collapseTwo",
- "#collapseThree",
- "#collapseFour",
- "#collapseFive",
- "#collapseSix",
- "#collapseSeven"
- ];
-
- $.each(blocks, function( index, value ) {
- $(value).collapse("hide");
- });
- });
- </script>';
- $tpl = new Template(get_lang('Diagnosis'));
- if (empty($items)) {
- $view = '';
- $grid = '';
- $griJs = '';
- }
- $tpl->assign('form', $view);
- $tpl->assign('form_search', $formSearch->returnForm().$userForm->returnForm());
- $table = new HTML_Table(['class' => 'data_table']);
- $column = 0;
- $row = 0;
- $total = '0';
- $sumHours = '0';
- $numHours = '0';
- $field = 'heures_disponibilite_par_semaine';
- $extraField = new ExtraFieldValue('user');
- $data = $extraField->get_values_by_handler_and_field_variable($userToLoad, $field);
- $availableHoursPerWeek = 0;
- function dateDiffInWeeks($date1, $date2)
- {
- if ($date1 > $date2) {
- return dateDiffInWeeks($date2, $date1);
- }
- $first = new \DateTime($date1);
- $second = new \DateTime($date2);
- return floor($first->diff($second)->days / 7);
- }
- if ($data) {
- $availableHoursPerWeek = $data['value'];
- $numberWeeks = 0;
- if ($form->validate()) {
- $formData = $form->getSubmitValues();
- if (isset($formData['extra_access_start_date']) && isset($formData['extra_access_end_date'])) {
- $startDate = $formData['extra_access_start_date'];
- $endDate = $formData['extra_access_end_date'];
- $numberWeeks = dateDiffInWeeks($startDate, $endDate);
- }
- } else {
- if ($defaults) {
- if (isset($defaults['extra_access_start_date']) && isset($defaults['extra_access_end_date'])) {
- $startDate = $defaults['extra_access_start_date'];
- $endDate = $defaults['extra_access_end_date'];
- $numberWeeks = dateDiffInWeeks($startDate, $endDate);
- }
- }
- }
- $total = $numberWeeks * $availableHoursPerWeek;
- $sessions = SessionManager::getSessionsFollowedByUser($userToLoad);
- if ($sessions) {
- $sessionFieldValue = new ExtraFieldValue('session');
- foreach ($sessions as $session) {
- $sessionId = $session['id'];
- $data = $sessionFieldValue->get_values_by_handler_and_field_variable(
- $sessionId,
- 'temps_de_travail'
- );
- if ($data) {
- $sumHours += $data['value'];
- }
- }
- }
- }
- $numHours = $total - $sumHours;
- $headers = [
- get_lang('TotalAvailableHours') => $total,
- get_lang('SumHoursSessionsSubscribed') => $sumHours,
- get_lang('CountHoursAvailable') => $numHours,
- ];
- foreach ($headers as $header => $value) {
- $table->setCellContents($row, 0, $header);
- $table->updateCellAttributes($row, 0, 'width="250px"');
- $table->setCellContents($row, 1, $value);
- $row++;
- }
- $button = '';
- if ($userToLoad) {
- $button = Display::url(
- get_lang('OfajEndOfLearnPath'),
- api_get_path(WEB_CODE_PATH).'messages/new_message.php?prefill=ofaj&send_to_user='.$userToLoad,
- ['class' => 'btn btn-default']
- );
- $button .= '<br /><br />';
- }
- $userReportButton = Display::url(
- get_lang('DiagnosticValidateLearningPath'),
- api_get_path(WEB_CODE_PATH).'mySpace/myStudents.php?student='.$userToLoad,
- ['class' => 'btn btn-primary']
- );
- $tpl->assign('grid', $grid.$button.$table->toHtml().$userReportButton);
- $tpl->assign('grid_js', $griJs);
- $content = $tpl->fetch('default/user_portal/search_extra_field.tpl');
- $tpl->assign('content', $content);
- $tpl->display_one_col_template();
|