function setFocus(){ $("#glossary_title").focus(); } $(document).ready(function () { setFocus(); }); '; // Tracking Event::event_access_tool(TOOL_GLOSSARY); function sorter($item1, $item2) { if ($item1[2] == $item2[2]) { return 0; } return $item1[2] < $item2[2] ? -1 : 1; } // Displaying the header $action = isset($_GET['action']) ? $_GET['action'] : ''; $currentUrl = api_get_self().'?'.api_get_cidreq(); $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('Glossary')); $content = ''; $tool_name = ''; switch ($action) { case 'addglossary': if (!api_is_allowed_to_edit(null, true)) { api_not_allowed(true); } $tool_name = get_lang('Add'); $form = new FormValidator( 'glossary', 'post', api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&'.api_get_cidreq() ); // Setting the form elements $form->addElement('header', get_lang('TermAddNew')); $form->addElement( 'text', 'name', get_lang('TermName'), array('id' => 'glossary_title') ); $form->addElement( 'html_editor', 'description', get_lang('TermDefinition'), null, array('ToolbarSet' => 'Glossary', 'Height' => '300') ); $form->addButtonCreate(get_lang('TermAddButton'), 'SubmitGlossary'); // setting the rules $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required'); // The validation or display if ($form->validate()) { $check = Security::check_token('post'); if ($check) { $values = $form->exportValues(); GlossaryManager::save_glossary($values); } Security::clear_token(); header('Location: '.$currentUrl); exit; } else { $token = Security::get_token(); $form->addElement('hidden', 'sec_token'); $form->setConstants(array('sec_token' => $token)); $content = $form->returnForm(); } break; case 'edit_glossary': if (!api_is_allowed_to_edit(null, true)) { api_not_allowed(true); } $tool_name = get_lang('Edit'); if (is_numeric($_GET['glossary_id'])) { // initiate the object $form = new FormValidator( 'glossary', 'post', api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&glossary_id='.intval($_GET['glossary_id']).'&'.api_get_cidreq() ); // Setting the form elements $form->addElement('header', get_lang('TermEdit')); $form->addElement('hidden', 'glossary_id'); $form->addElement('text', 'name', get_lang('TermName')); $form->addElement( 'html_editor', 'description', get_lang('TermDefinition'), null, array('ToolbarSet' => 'Glossary', 'Height' => '300') ); // setting the defaults $glossary_data = GlossaryManager::get_glossary_information($_GET['glossary_id']); // Date treatment for timezones if (!empty($glossary_data['insert_date'])) { $glossary_data['insert_date'] = Display::dateToStringAgoAndLongDate($glossary_data['insert_date']); } else { $glossary_data['insert_date'] = ''; } if (!empty($glossary_data['update_date'])) { $glossary_data['update_date'] = Display::dateToStringAgoAndLongDate($glossary_data['update_date']); } else { $glossary_data['update_date'] = ''; } $form->addLabel(get_lang('CreationDate'), $glossary_data['insert_date']); $form->addLabel(get_lang('UpdateDate'), $glossary_data['update_date']); $form->addButtonUpdate(get_lang('TermUpdateButton'), 'SubmitGlossary'); $form->setDefaults($glossary_data); // setting the rules $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required'); // The validation or display if ($form->validate()) { $check = Security::check_token('post'); if ($check) { $values = $form->exportValues(); GlossaryManager::update_glossary($values); } Security::clear_token(); header('Location: '.$currentUrl); exit; } else { $token = Security::get_token(); $form->addElement('hidden', 'sec_token'); $form->setConstants(array('sec_token' => $token)); $content = $form->returnForm(); } } break; case 'delete_glossary': if (!api_is_allowed_to_edit(null, true)) { api_not_allowed(true); } GlossaryManager::delete_glossary($_GET['glossary_id']); Security::clear_token(); header('Location: '.$currentUrl); exit; break; case 'moveup': //GlossaryManager::move_glossary('up',$_GET['glossary_id']); //actions not available GlossaryManager::display_glossary(); break; case 'movedown': //GlossaryManager::move_glossary('down',$_GET['glossary_id']); //actions not available GlossaryManager::display_glossary(); break; case 'import': if (!api_is_allowed_to_edit(null, true)) { api_not_allowed(true); } $tool_name = get_lang('ImportGlossary'); $form = new FormValidator( 'glossary', 'post', api_get_self().'?action=import&'.api_get_cidreq() ); $form->addElement('header', '', get_lang('ImportGlossary')); $form->addElement('file', 'file', get_lang('ImportCSVFileLocation')); $form->addElement('checkbox', 'replace', null, get_lang('DeleteAllGlossaryTerms')); $form->addElement('checkbox', 'update', null, get_lang('UpdateExistingGlossaryTerms')); $form->addButtonImport(get_lang('Import'), 'SubmitImport'); $content = $form->returnForm(); $content .= get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')'; $content .= '
                term;definition;
                "Hello";"Hola";
                "Goodbye";"AdiĆ³s";
        
'; if ($form->validate()) { $termsDeleted = []; //this is a bad idea //jm if (isset($_POST['replace']) && $_POST['replace']) { foreach (GlossaryManager::get_glossary_terms() as $term) { if (!GlossaryManager::delete_glossary($term['id'], false)) { Display::addFlash( Display::return_message(get_lang("CannotDeleteGlossary") . ':' . $term['id'], 'error') ); } else { $termsDeleted[] = $term['name']; } } } $updateTerms = isset($_POST['update']) && $_POST['update'] ? true : false; $data = Import::csv_reader($_FILES['file']['tmp_name']); $goodList = []; $updatedList = []; $addedList = []; $badList = []; $doubles = []; $added = []; $termsPerKey = []; if ($data) { $termsToAdd = []; foreach ($data as $item) { $items = [ 'name' => $item['term'], 'description' => $item['definition'] ]; $termsToAdd[] = $items; $termsPerKey[$item['term']] = $items; } if (empty($termsToAdd)) { Display::addFlash( Display::return_message(get_lang('NothingToAdd'), 'warning') ); header('Location: '.$currentUrl); exit; } $repeatItems = array_count_values(array_column($termsToAdd, 'name')); foreach ($repeatItems as $item => $count) { if ($count > 1) { $doubles[] = $item; } } $uniqueTerms = array_unique(array_keys($repeatItems)); foreach ($uniqueTerms as $itemTerm) { $item = $termsPerKey[$itemTerm]; if ($updateTerms) { $glossaryInfo = GlossaryManager::get_glossary_term_by_glossary_name($item['name']); if (!empty($glossaryInfo)) { $glossaryInfo['description'] = $item['description']; GlossaryManager::update_glossary($glossaryInfo, false); $updatedList[] = $item['name']; } else { $result = GlossaryManager::save_glossary($item, false); if ($result) { $addedList[] = $item['name']; } else { $badList[] = $item['name']; } } } else { $result = GlossaryManager::save_glossary($item, false); if ($result) { $addedList[] = $item['name']; } else { $badList[] = $item['name']; } } } } if (count($termsDeleted) > 0) { Display::addFlash( Display::return_message(get_lang("TermDeleted").': '.implode(', ', $termsDeleted)) ); } if (count($updatedList) > 0) { Display::addFlash( Display::return_message(get_lang("TermsUpdated").': '.implode(', ', $updatedList)) ); } if (count($addedList) > 0) { Display::addFlash( Display::return_message(get_lang("TermsAdded").': '.implode(', ', $addedList)) ); } if (count($badList) > 0) { Display::addFlash( Display::return_message( get_lang("GlossaryTermAlreadyExists").': ' . implode(', ', $badList), 'error' ) ); } if (count($doubles) > 0) { Display::addFlash( Display::return_message( get_lang("TermsDuplicatedInFile").': '.implode(', ', $doubles), 'warning' ) ); } header('Location: '.$currentUrl); exit; } break; case 'export': if (!api_is_allowed_to_edit(null, true)) { api_not_allowed(true); } $data = GlossaryManager::get_glossary_data( 0, GlossaryManager::get_number_glossary_terms(api_get_session_id()), 0, 'ASC' ); usort($data, "sorter"); $list = array(); $list[] = array('term', 'definition'); foreach ($data as $line) { $list[] = array($line[0], $line[1]); } $filename = 'glossary_course_'.api_get_course_id(); Export::arrayToCsv($list, $filename); break; case 'export_to_pdf': GlossaryManager::export_to_pdf(); break; case 'changeview': if (in_array($_GET['view'], array('list','table'))) { Session::write('glossary_view', $_GET['view']); } else { $view = Session::read('glossary_view'); if (empty($view)) { Session::write('glossary_view', 'table'); } } header('Location: '.$currentUrl); exit; break; default: $tool_name = get_lang('List'); $content = GlossaryManager::display_glossary(); break; } Display::display_header($tool_name); // Tool introduction Display::display_introduction_section(TOOL_GLOSSARY); echo $content; Display::display_footer();