123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * Sessions edition script
- * @package chamilo.admin
- */
- // name of the language file that needs to be included
- $language_file ='admin';
- $cidReset = true;
- require_once '../inc/global.inc.php';
- // setting the section (for the tabs)
- $this_section = SECTION_PLATFORM_ADMIN;
- $formSent = 0;
- // Database Table Definitions
- $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
- $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
- $id = intval($_GET['id']);
- SessionManager::protect_session_edit($id);
- $infos = SessionManager::fetch($id);
- $id_coach = $infos['id_coach'];
- $tool_name = get_lang('EditSession');
- $interbreadcrumb[] = array('url' => 'index.php',"name" => get_lang('PlatformAdmin'));
- $interbreadcrumb[] = array('url' => "session_list.php","name" => get_lang('SessionList'));
- $interbreadcrumb[] = array('url' => "resume_session.php?id_session=".$id,"name" => get_lang('SessionOverview'));
- list($year_start, $month_start, $day_start) = explode('-', $infos['date_start']);
- list($year_end, $month_end, $day_end) = explode('-', $infos['date_end']);
- $end_year_disabled = $end_month_disabled = $end_day_disabled = '';
- if (isset($_POST['formSent']) && $_POST['formSent']) {
- $formSent = 1;
- }
- $order_clause = 'ORDER BY ';
- $order_clause .= api_sort_by_first_name() ? 'firstname, lastname, username' : 'lastname, firstname, username';
- $sql="SELECT user_id,lastname,firstname,username FROM $tbl_user WHERE status='1'".$order_clause;
- if (api_is_multiple_url_enabled()) {
- $table_access_url_rel_user= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
- $access_url_id = api_get_current_access_url_id();
- if ($access_url_id != -1) {
- $sql="SELECT DISTINCT u.user_id,lastname,firstname,username FROM $tbl_user u INNER JOIN $table_access_url_rel_user url_rel_user ON (url_rel_user.user_id = u.user_id)
- WHERE status='1' AND access_url_id = '$access_url_id' $order_clause";
- }
- }
- $result = Database::query($sql);
- $coaches = Database::store_result($result);
- $thisYear = date('Y');
- $daysOption = array();
- for ($i = 1; $i <= 31; $i++) {
- $day = sprintf("%02d", $i);
- $daysOption[$day] = $day;
- }
- $monthsOption = array();
- for ($i = 1; $i <= 12; $i++) {
- $month = sprintf("%02d", $i);
- $monthsOption[$month] = $month;
- }
- $yearsOption = array();
- for ($i = $thisYear - 5; $i <= ($thisYear + 5); $i++) {
- $yearsOption[$i] = $i;
- }
- $coachesOption = array(
- '' => '----- ' . get_lang('None') . ' -----'
- );
- foreach ($coaches as $coach) {
- $personName = api_get_person_name($coach['firstname'], $coach['lastname']);
- $coachesOption[$coach['user_id']] = "$personName ({$coach['username']})";
- }
- $categoriesList = SessionManager::get_all_session_category();
- $categoriesOption = array(
- '0' => get_lang('None')
- );
- if ($categoriesList != false) {
- foreach ($categoriesList as $categoryItem) {
- $categoriesOption[$categoryItem['id']] = $categoryItem['name'];
- }
- }
- $formAction = api_get_self() . '?';
- $formAction .= http_build_query(array(
- 'page' => Security::remove_XSS($_GET['page']),
- 'id' => $id
- ));
- $form = new FormValidator('edit_session', 'post', $formAction);
- $form->addElement('header', $tool_name);
- $form->addElement('text', 'name', get_lang('SessionName'), array(
- 'class' => 'span4',
- 'maxlength' => 50,
- 'value' => $formSent ? api_htmlentities($name,ENT_QUOTES,$charset) : ''
- ));
- $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
- $form->addRule('name', get_lang('SessionNameAlreadyExists'), 'callback', 'check_session_name');
- $form->addElement('select', 'id_coach', get_lang('CoachName'), $coachesOption, array(
- 'id' => 'coach_username',
- 'class' => 'chzn-select',
- 'style' => 'width:370px;',
- 'title' => get_lang('Choose')
- ));
- $form->addRule('id_coach', get_lang('ThisFieldIsRequired'), 'required');
- $form->addSelect('session_category', get_lang('SessionCategory'), $categoriesOption, array(
- 'id' => 'session_category',
- 'class' => 'chzn-select',
- 'style' => 'width:370px;'
- ));
- $form->addElement('advanced_settings','<a class="btn-show" id="show-options" href="#">'.get_lang('DefineSessionOptions').'</a>');
- if ($infos['nb_days_access_before_beginning'] != 0 || $infos['nb_days_access_after_end'] != 0) {
- $form->addElement('html','<div id="options" style="display:block;">');
- } else {
- $form->addElement('html','<div id="options" style="display:none;">');
- }
- $form->addElement('text', 'nb_days_access_before', array('', '', get_lang('DaysBefore')), array(
- 'style' => 'width: 30px;'
- ));
- $form->addElement('text', 'nb_days_access_after', array('', '', get_lang('DaysAfter')), array(
- 'style' => 'width: 30px;'
- ));
- $form->addElement('html','</div>');
- if ($year_start!="0000") {
- $form->addElement('checkbox', 'start_limit', '', get_lang('DateStartSession'), array(
- 'onchange' => 'disable_starttime(this)',
- 'id' => 'start_limit',
- 'checked' => ''
- ));
- $form->addElement('html','<div id="start_date" style="display:block">');
- } else {
- $form->addElement('checkbox', 'start_limit', '', get_lang('DateStartSession'), array(
- 'onchange' => 'disable_starttime(this)',
- 'id' => 'start_limit'
- ));
- $form->addElement('html','<div id="start_date" style="display:none">');
- }
- $form->addElement('date_picker', 'date_start');
- $form->addElement('html','</div>');
- if ($year_end != "0000") {
- $form->addElement('checkbox', 'end_limit', '', get_lang('DateEndSession'), array(
- 'onchange' => 'disable_endtime(this)',
- 'id' => 'end_limit',
- 'checked' => ''
- ));
- $form->addElement('html','<div id="end_date" style="display:block">');
- } else {
- $form->addElement('checkbox', 'end_limit', '', get_lang('DateEndSession'), array(
- 'onchange' => 'disable_endtime(this)',
- 'id' => 'end_limit'
- ));
- $form->addElement('html','<div id="end_date" style="display:none">');
- }
- $form->addElement('date_picker', 'date_end');
- $visibilityGroup = array();
- $visibilityGroup[] = $form->createElement('advanced_settings', get_lang('SessionVisibility'));
- $visibilityGroup[] = $form->createElement('select', 'session_visibility', null, array(
- SESSION_VISIBLE_READ_ONLY => get_lang('SessionReadOnly'),
- SESSION_VISIBLE => get_lang('SessionAccessible'),
- SESSION_INVISIBLE => api_ucfirst(get_lang('SessionNotAccessible'))
- ), array(
- 'style' => 'width:250px;'
- ));
- $form->addGroup($visibilityGroup, 'visibility_group', null, null, false);
- $form->addElement('html','</div>');
- $form->addElement(
- 'textarea',
- 'description',
- get_lang('Description'),
- array(
- 'class' => 'span4',
- 'rows' => 3
- )
- );
- $chkDescriptionAttributes = array();
- if (!empty($infos['show_description'])) {
- $chkDescriptionAttributes['checked'] = '';
- }
- $form->addElement('checkbox', 'show_description', null, get_lang('ShowDescription'), $chkDescriptionAttributes);
- $duration = empty($infos['duration']) ? null : $infos['duration'];
- $form->addElement(
- 'text',
- 'duration',
- array(
- get_lang('SessionDurationTitle'),
- get_lang('SessionDurationDescription')
- ),
- array(
- 'class' => 'span1',
- 'maxlength' => 50
- )
- );
- //Extra fields
- $extra_field = new ExtraField('session');
- $extra = $extra_field->addElements($form, $id);
- $htmlHeadXtra[] ='
- <script>
- $(function() {
- '.$extra['jquery_ready_content'].'
- });
- </script>';
- $form->addButtonUpdate(get_lang('ModifyThisSession'));
- $formDefaults = array(
- 'id_coach' => $infos['id_coach'],
- 'session_category' => $infos['session_category_id'],
- 'date_start' => $infos['date_start'],
- 'date_end' => $infos['date_end'],
- 'session_visibility' => $infos['visibility'],
- 'description' => $infos['description']
- );
- if ($formSent) {
- $formDefaults['name'] = api_htmlentities($name,ENT_QUOTES,$charset);
- $formDefaults['nb_days_access_before'] = api_htmlentities($nb_days_access_before,ENT_QUOTES,$charset);
- $formDefaults['nb_days_access_after'] = api_htmlentities($nb_days_access_after,ENT_QUOTES,$charset);
- $formDefaults['duration'] = Security::remove_XSS($duration);
- } else {
- $formDefaults['name'] = Security::remove_XSS($infos['name']);
- $formDefaults['nb_days_access_before'] = api_htmlentities($infos['nb_days_access_before_beginning'],ENT_QUOTES,$charset);
- $formDefaults['nb_days_access_after'] = api_htmlentities($infos['nb_days_access_after_end'],ENT_QUOTES,$charset);
- $formDefaults['duration'] = $duration;
- }
- $form->setDefaults($formDefaults);
- if ($form->validate()) {
- $params = $form->getSubmitValues();
- $name = $params['name'];
- $startDate = $params['date_start'];
- $endDate = $params['date_end'];
- $nb_days_acess_before = $params['nb_days_access_before'];
- $nb_days_acess_after = $params['nb_days_access_after'];
- $id_coach = $params['id_coach'];
- $id_session_category = $params['session_category'];
- $id_visibility = $params['session_visibility'];
- $duration = isset($params['duration']) ? $params['duration'] : null;
- $description = $params['description'];
- $showDescription = isset($params['show_description']) ? 1: 0;
- $end_limit = isset($params['end_limit']);
- $start_limit = isset($params['start_limit']);
- if (!$end_limit && !$start_limit) {
- $nolimit = 1;
- } else {
- $nolimit = null;
- }
- $extraFields = array();
- foreach ($params as $key => $value) {
- if (strpos($key, 'extra_') === 0) {
- $extraFields[$key] = $value;
- }
- }
- $return = SessionManager::edit_session(
- $id,
- $name,
- $startDate,
- $endDate,
- $nb_days_acess_before,
- $nb_days_acess_after,
- $nolimit,
- $id_coach,
- $id_session_category,
- $id_visibility,
- $start_limit,
- $end_limit,
- $description,
- $showDescription,
- $duration,
- $extraFields
- );
- if ($return == strval(intval($return))) {
- header('Location: resume_session.php?id_session=' . $return);
- exit();
- }
- }
- // display the header
- Display::display_header($tool_name);
- if (!empty($return)) {
- Display::display_error_message($return,false);
- }
- $form->display();
- ?>
- <script type="text/javascript">
- <?php
- //if($year_start=="0000") echo "setDisable(document.form.nolimit);\r\n";
- ?>
- function setDisable(select) {
- document.forms['edit_session'].elements['session_visibility'].disabled = (select.checked) ? true : false;
- document.forms['edit_session'].elements['session_visibility'].selectedIndex = 0;
- document.forms['edit_session'].elements['start_limit'].disabled = (select.checked) ? true : false;
- document.forms['edit_session'].elements['start_limit'].checked = false;
- document.forms['edit_session'].elements['end_limit'].disabled = (select.checked) ? true : false;
- document.forms['edit_session'].elements['end_limit'].checked = false;
- var end_div = document.getElementById('end_date');
- end_div.style.display = 'none';
- var start_div = document.getElementById('start_date');
- start_div.style.display = 'none';
- }
- function disable_endtime(select) {
- var end_div = document.getElementById('end_date');
- if (end_div.style.display == 'none')
- end_div.style.display = 'block';
- else
- end_div.style.display = 'none';
- emptyDuration();
- }
- function disable_starttime(select) {
- var start_div = document.getElementById('start_date');
- if (start_div.style.display == 'none')
- start_div.style.display = 'block';
- else
- start_div.style.display = 'none';
- emptyDuration();
- }
- function emptyDuration() {
- if ($('#duration').val()) {
- $('#duration').val('');
- }
- }
- $(document).on('ready', function (){
- $('#show-options').on('click', function (e) {
- e.preventDefault();
- var display = $('#options').css('display');
- display === 'block' ? $('#options').slideUp() : $('#options').slideDown() ;
- });
- });
- </script>
- <?php
- Display::display_footer();
|