index.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. use ChamiloSession as Session;
  4. /**
  5. * @package chamilo.glossary
  6. * @author Christian Fasanando, initial version
  7. * @author Bas Wijnen import/export to CSV
  8. */
  9. require_once __DIR__.'/../inc/global.inc.php';
  10. $current_course_tool = TOOL_GLOSSARY;
  11. // The section (tabs).
  12. $this_section = SECTION_COURSES;
  13. // Notification for unauthorized people.
  14. api_protect_course_script(true);
  15. // Additional javascripts.
  16. $htmlHeadXtra[] = GlossaryManager::javascript_glossary();
  17. $htmlHeadXtra[] = '<script>
  18. function setFocus(){
  19. $("#glossary_title").focus();
  20. }
  21. $(document).ready(function () {
  22. setFocus();
  23. });
  24. </script>';
  25. // Tracking
  26. Event::event_access_tool(TOOL_GLOSSARY);
  27. function sorter($item1, $item2) {
  28. if ($item1[2] == $item2[2]) {
  29. return 0;
  30. }
  31. return $item1[2] < $item2[2] ? -1 : 1;
  32. }
  33. // Displaying the header
  34. $action = isset($_GET['action']) ? $_GET['action'] : '';
  35. $currentUrl = api_get_self().'?'.api_get_cidreq();
  36. $interbreadcrumb[] = array('url' => 'index.php?'.api_get_cidreq(), 'name' => get_lang('Glossary'));
  37. $content = '';
  38. $tool_name = '';
  39. switch ($action) {
  40. case 'addglossary':
  41. if (!api_is_allowed_to_edit(null, true)) {
  42. api_not_allowed(true);
  43. }
  44. $tool_name = get_lang('Add');
  45. $form = new FormValidator(
  46. 'glossary',
  47. 'post',
  48. api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&'.api_get_cidreq()
  49. );
  50. // Setting the form elements
  51. $form->addElement('header', get_lang('TermAddNew'));
  52. if (api_get_configuration_value('save_titles_as_html')) {
  53. $form->addHtmlEditor(
  54. 'name',
  55. get_lang('TermName'),
  56. false,
  57. false,
  58. ['ToolbarSet' => 'Minimal']
  59. );
  60. } else {
  61. $form->addElement('text', 'name', get_lang('TermName'), array('id' => 'glossary_title'));
  62. }
  63. $form->addElement(
  64. 'html_editor',
  65. 'description',
  66. get_lang('TermDefinition'),
  67. null,
  68. array('ToolbarSet' => 'Glossary', 'Height' => '300')
  69. );
  70. $form->addButtonCreate(get_lang('TermAddButton'), 'SubmitGlossary');
  71. // setting the rules
  72. $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
  73. // The validation or display
  74. if ($form->validate()) {
  75. $check = Security::check_token('post');
  76. if ($check) {
  77. $values = $form->exportValues();
  78. GlossaryManager::save_glossary($values);
  79. }
  80. Security::clear_token();
  81. header('Location: '.$currentUrl);
  82. exit;
  83. } else {
  84. $token = Security::get_token();
  85. $form->addElement('hidden', 'sec_token');
  86. $form->setConstants(array('sec_token' => $token));
  87. $content = $form->returnForm();
  88. }
  89. break;
  90. case 'edit_glossary':
  91. if (!api_is_allowed_to_edit(null, true)) {
  92. api_not_allowed(true);
  93. }
  94. $tool_name = get_lang('Edit');
  95. if (is_numeric($_GET['glossary_id'])) {
  96. // initiate the object
  97. $form = new FormValidator(
  98. 'glossary',
  99. 'post',
  100. api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&glossary_id='.intval($_GET['glossary_id']).'&'.api_get_cidreq()
  101. );
  102. // Setting the form elements
  103. $form->addElement('header', get_lang('TermEdit'));
  104. $form->addElement('hidden', 'glossary_id');
  105. $form->addElement('text', 'name', get_lang('TermName'));
  106. if (api_get_configuration_value('save_titles_as_html')) {
  107. $form->addHtmlEditor(
  108. 'name',
  109. get_lang('TermName'),
  110. false,
  111. false,
  112. ['ToolbarSet' => 'Minimal']
  113. );
  114. } else {
  115. $form->addElement('text', 'name', get_lang('TermName'), array('id' => 'glossary_title'));
  116. }
  117. $form->addElement(
  118. 'html_editor',
  119. 'description',
  120. get_lang('TermDefinition'),
  121. null,
  122. array('ToolbarSet' => 'Glossary', 'Height' => '300')
  123. );
  124. // setting the defaults
  125. $glossary_data = GlossaryManager::get_glossary_information($_GET['glossary_id']);
  126. // Date treatment for timezones
  127. if (!empty($glossary_data['insert_date'])) {
  128. $glossary_data['insert_date'] = Display::dateToStringAgoAndLongDate($glossary_data['insert_date']);
  129. } else {
  130. $glossary_data['insert_date'] = '';
  131. }
  132. if (!empty($glossary_data['update_date'])) {
  133. $glossary_data['update_date'] = Display::dateToStringAgoAndLongDate($glossary_data['update_date']);
  134. } else {
  135. $glossary_data['update_date'] = '';
  136. }
  137. $form->addLabel(get_lang('CreationDate'), $glossary_data['insert_date']);
  138. $form->addLabel(get_lang('UpdateDate'), $glossary_data['update_date']);
  139. $form->addButtonUpdate(get_lang('TermUpdateButton'), 'SubmitGlossary');
  140. $form->setDefaults($glossary_data);
  141. // setting the rules
  142. $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
  143. // The validation or display
  144. if ($form->validate()) {
  145. $check = Security::check_token('post');
  146. if ($check) {
  147. $values = $form->exportValues();
  148. GlossaryManager::update_glossary($values);
  149. }
  150. Security::clear_token();
  151. header('Location: '.$currentUrl);
  152. exit;
  153. } else {
  154. $token = Security::get_token();
  155. $form->addElement('hidden', 'sec_token');
  156. $form->setConstants(array('sec_token' => $token));
  157. $content = $form->returnForm();
  158. }
  159. }
  160. break;
  161. case 'delete_glossary':
  162. if (!api_is_allowed_to_edit(null, true)) {
  163. api_not_allowed(true);
  164. }
  165. GlossaryManager::delete_glossary($_GET['glossary_id']);
  166. Security::clear_token();
  167. header('Location: '.$currentUrl);
  168. exit;
  169. break;
  170. case 'moveup':
  171. //GlossaryManager::move_glossary('up',$_GET['glossary_id']); //actions not available
  172. GlossaryManager::display_glossary();
  173. break;
  174. case 'movedown':
  175. //GlossaryManager::move_glossary('down',$_GET['glossary_id']); //actions not available
  176. GlossaryManager::display_glossary();
  177. break;
  178. case 'import':
  179. if (!api_is_allowed_to_edit(null, true)) {
  180. api_not_allowed(true);
  181. }
  182. $tool_name = get_lang('ImportGlossary');
  183. $form = new FormValidator(
  184. 'glossary',
  185. 'post',
  186. api_get_self().'?action=import&'.api_get_cidreq()
  187. );
  188. $form->addElement('header', '', get_lang('ImportGlossary'));
  189. $form->addElement('file', 'file', get_lang('ImportCSVFileLocation'));
  190. $form->addElement('checkbox', 'replace', null, get_lang('DeleteAllGlossaryTerms'));
  191. $form->addElement('checkbox', 'update', null, get_lang('UpdateExistingGlossaryTerms'));
  192. $form->addButtonImport(get_lang('Import'), 'SubmitImport');
  193. $content = $form->returnForm();
  194. $content .= get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')';
  195. $content .= '<pre>
  196. <strong>term</strong>;<strong>definition</strong>;
  197. "Hello";"Hola";
  198. "Goodbye";"Adiós";
  199. </pre>';
  200. if ($form->validate()) {
  201. $termsDeleted = [];
  202. //this is a bad idea //jm
  203. if (isset($_POST['replace']) && $_POST['replace']) {
  204. foreach (GlossaryManager::get_glossary_terms() as $term) {
  205. if (!GlossaryManager::delete_glossary($term['id'], false)) {
  206. Display::addFlash(
  207. Display::return_message(get_lang("CannotDeleteGlossary").':'.$term['id'], 'error')
  208. );
  209. } else {
  210. $termsDeleted[] = $term['name'];
  211. }
  212. }
  213. }
  214. $updateTerms = isset($_POST['update']) && $_POST['update'] ? true : false;
  215. $data = Import::csv_reader($_FILES['file']['tmp_name']);
  216. $goodList = [];
  217. $updatedList = [];
  218. $addedList = [];
  219. $badList = [];
  220. $doubles = [];
  221. $added = [];
  222. $termsPerKey = [];
  223. if ($data) {
  224. $termsToAdd = [];
  225. foreach ($data as $item) {
  226. $items = [
  227. 'name' => $item['term'],
  228. 'description' => $item['definition']
  229. ];
  230. $termsToAdd[] = $items;
  231. $termsPerKey[$item['term']] = $items;
  232. }
  233. if (empty($termsToAdd)) {
  234. Display::addFlash(
  235. Display::return_message(get_lang('NothingToAdd'), 'warning')
  236. );
  237. header('Location: '.$currentUrl);
  238. exit;
  239. }
  240. $repeatItems = array_count_values(array_column($termsToAdd, 'name'));
  241. foreach ($repeatItems as $item => $count) {
  242. if ($count > 1) {
  243. $doubles[] = $item;
  244. }
  245. }
  246. $uniqueTerms = array_unique(array_keys($repeatItems));
  247. foreach ($uniqueTerms as $itemTerm) {
  248. $item = $termsPerKey[$itemTerm];
  249. if ($updateTerms) {
  250. $glossaryInfo = GlossaryManager::get_glossary_term_by_glossary_name($item['name']);
  251. if (!empty($glossaryInfo)) {
  252. $glossaryInfo['description'] = $item['description'];
  253. GlossaryManager::update_glossary($glossaryInfo, false);
  254. $updatedList[] = $item['name'];
  255. } else {
  256. $result = GlossaryManager::save_glossary($item, false);
  257. if ($result) {
  258. $addedList[] = $item['name'];
  259. } else {
  260. $badList[] = $item['name'];
  261. }
  262. }
  263. } else {
  264. $result = GlossaryManager::save_glossary($item, false);
  265. if ($result) {
  266. $addedList[] = $item['name'];
  267. } else {
  268. $badList[] = $item['name'];
  269. }
  270. }
  271. }
  272. }
  273. if (count($termsDeleted) > 0) {
  274. Display::addFlash(
  275. Display::return_message(get_lang("TermDeleted").': '.implode(', ', $termsDeleted))
  276. );
  277. }
  278. if (count($updatedList) > 0) {
  279. Display::addFlash(
  280. Display::return_message(get_lang("TermsUpdated").': '.implode(', ', $updatedList))
  281. );
  282. }
  283. if (count($addedList) > 0) {
  284. Display::addFlash(
  285. Display::return_message(get_lang("TermsAdded").': '.implode(', ', $addedList))
  286. );
  287. }
  288. if (count($badList) > 0) {
  289. Display::addFlash(
  290. Display::return_message(
  291. get_lang("GlossaryTermAlreadyExists").': '.implode(', ', $badList),
  292. 'error'
  293. )
  294. );
  295. }
  296. if (count($doubles) > 0) {
  297. Display::addFlash(
  298. Display::return_message(
  299. get_lang("TermsDuplicatedInFile").': '.implode(', ', $doubles),
  300. 'warning'
  301. )
  302. );
  303. }
  304. header('Location: '.$currentUrl);
  305. exit;
  306. }
  307. break;
  308. case 'export':
  309. if (!api_is_allowed_to_edit(null, true)) {
  310. api_not_allowed(true);
  311. }
  312. $data = GlossaryManager::get_glossary_data(
  313. 0,
  314. GlossaryManager::get_number_glossary_terms(api_get_session_id()),
  315. 0,
  316. 'ASC'
  317. );
  318. usort($data, "sorter");
  319. $list = array();
  320. $list[] = array('term', 'definition');
  321. foreach ($data as $line) {
  322. $list[] = array($line[0], $line[1]);
  323. }
  324. $filename = 'glossary_course_'.api_get_course_id();
  325. Export::arrayToCsv($list, $filename);
  326. break;
  327. case 'export_to_pdf':
  328. GlossaryManager::export_to_pdf();
  329. break;
  330. case 'changeview':
  331. if (in_array($_GET['view'], array('list', 'table'))) {
  332. Session::write('glossary_view', $_GET['view']);
  333. } else {
  334. $view = Session::read('glossary_view');
  335. if (empty($view)) {
  336. Session::write('glossary_view', 'table');
  337. }
  338. }
  339. header('Location: '.$currentUrl);
  340. exit;
  341. break;
  342. case 'export_documents':
  343. GlossaryManager::movePdfToDocuments();
  344. break;
  345. default:
  346. $tool_name = get_lang('List');
  347. $content = GlossaryManager::display_glossary();
  348. break;
  349. }
  350. Display::display_header($tool_name);
  351. // Tool introduction
  352. Display::display_introduction_section(TOOL_GLOSSARY);
  353. echo $content;
  354. Display::display_footer();