index.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381
  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 '../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. $form->addElement(
  53. 'text',
  54. 'name',
  55. get_lang('TermName'),
  56. array('id' => 'glossary_title')
  57. );
  58. $form->addElement(
  59. 'html_editor',
  60. 'description',
  61. get_lang('TermDefinition'),
  62. null,
  63. array('ToolbarSet' => 'Glossary', 'Height' => '300')
  64. );
  65. $form->addButtonCreate(get_lang('TermAddButton'), 'SubmitGlossary');
  66. // setting the rules
  67. $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
  68. // The validation or display
  69. if ($form->validate()) {
  70. $check = Security::check_token('post');
  71. if ($check) {
  72. $values = $form->exportValues();
  73. GlossaryManager::save_glossary($values);
  74. }
  75. Security::clear_token();
  76. header('Location: '.$currentUrl);
  77. exit;
  78. } else {
  79. $token = Security::get_token();
  80. $form->addElement('hidden', 'sec_token');
  81. $form->setConstants(array('sec_token' => $token));
  82. $content = $form->returnForm();
  83. }
  84. break;
  85. case 'edit_glossary':
  86. if (!api_is_allowed_to_edit(null, true)) {
  87. api_not_allowed(true);
  88. }
  89. $tool_name = get_lang('Edit');
  90. if (is_numeric($_GET['glossary_id'])) {
  91. // initiate the object
  92. $form = new FormValidator(
  93. 'glossary',
  94. 'post',
  95. api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&glossary_id='.intval($_GET['glossary_id']).'&'.api_get_cidreq()
  96. );
  97. // Setting the form elements
  98. $form->addElement('header', get_lang('TermEdit'));
  99. $form->addElement('hidden', 'glossary_id');
  100. $form->addElement('text', 'name', get_lang('TermName'));
  101. $form->addElement(
  102. 'html_editor',
  103. 'description',
  104. get_lang('TermDefinition'),
  105. null,
  106. array('ToolbarSet' => 'Glossary', 'Height' => '300')
  107. );
  108. // setting the defaults
  109. $glossary_data = GlossaryManager::get_glossary_information($_GET['glossary_id']);
  110. // Date treatment for timezones
  111. if (!empty($glossary_data['insert_date'])) {
  112. $glossary_data['insert_date'] = Display::tip(
  113. date_to_str_ago($glossary_data['insert_date']),
  114. api_get_local_time($glossary_data['insert_date'])
  115. );
  116. } else {
  117. $glossary_data['insert_date'] = '';
  118. }
  119. if (!empty($glossary_data['update_date'])) {
  120. $glossary_data['update_date'] = Display::tip(
  121. date_to_str_ago($glossary_data['update_date']),
  122. api_get_local_time($glossary_data['update_date'])
  123. );
  124. } else {
  125. $glossary_data['update_date'] = '';
  126. }
  127. $form->addLabel(get_lang('CreationDate'), $glossary_data['insert_date']);
  128. $form->addLabel(get_lang('UpdateDate'), $glossary_data['update_date']);
  129. $form->addButtonUpdate(get_lang('TermUpdateButton'), 'SubmitGlossary');
  130. $form->setDefaults($glossary_data);
  131. // setting the rules
  132. $form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
  133. // The validation or display
  134. if ($form->validate()) {
  135. $check = Security::check_token('post');
  136. if ($check) {
  137. $values = $form->exportValues();
  138. GlossaryManager::update_glossary($values);
  139. }
  140. Security::clear_token();
  141. header('Location: '.$currentUrl);
  142. exit;
  143. } else {
  144. $token = Security::get_token();
  145. $form->addElement('hidden', 'sec_token');
  146. $form->setConstants(array('sec_token' => $token));
  147. $content = $form->returnForm();
  148. }
  149. }
  150. break;
  151. case 'delete_glossary':
  152. if (!api_is_allowed_to_edit(null, true)) {
  153. api_not_allowed(true);
  154. }
  155. GlossaryManager::delete_glossary($_GET['glossary_id']);
  156. Security::clear_token();
  157. header('Location: '.$currentUrl);
  158. exit;
  159. break;
  160. case 'moveup':
  161. //GlossaryManager::move_glossary('up',$_GET['glossary_id']); //actions not available
  162. GlossaryManager::display_glossary();
  163. break;
  164. case 'movedown':
  165. //GlossaryManager::move_glossary('down',$_GET['glossary_id']); //actions not available
  166. GlossaryManager::display_glossary();
  167. break;
  168. case 'import':
  169. if (!api_is_allowed_to_edit(null, true)) {
  170. api_not_allowed(true);
  171. }
  172. $tool_name = get_lang('ImportGlossary');
  173. $form = new FormValidator(
  174. 'glossary',
  175. 'post',
  176. api_get_self().'?action=import&'.api_get_cidreq()
  177. );
  178. $form->addElement('header', '', get_lang('ImportGlossary'));
  179. $form->addElement('file', 'file', get_lang('ImportCSVFileLocation'));
  180. $form->addElement('checkbox', 'replace', null, get_lang('DeleteAllGlossaryTerms'));
  181. $form->addElement('checkbox', 'update', null, get_lang('UpdateExistingGlossaryTerms'));
  182. $form->addButtonImport(get_lang('Import'), 'SubmitImport');
  183. $content = $form->returnForm();
  184. $content .= get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')';
  185. $content .= '<pre>
  186. <strong>term</strong>;<strong>definition</strong>;
  187. "Hello";"Hola";
  188. "Goodbye";"Adiós";
  189. </pre>';
  190. if ($form->validate()) {
  191. $termsDeleted = [];
  192. //this is a bad idea //jm
  193. if (isset($_POST['replace']) && $_POST['replace']) {
  194. foreach (GlossaryManager::get_glossary_terms() as $term) {
  195. if (!GlossaryManager::delete_glossary($term['id'], false)) {
  196. Display::addFlash(
  197. Display::return_message(get_lang("CannotDeleteGlossary") . ':' . $term['id'], 'error')
  198. );
  199. } else {
  200. $termsDeleted[] = $term['name'];
  201. }
  202. }
  203. }
  204. $updateTerms = isset($_POST['update']) && $_POST['update'] ? true : false;
  205. $data = Import::csv_reader($_FILES['file']['tmp_name']);
  206. $goodList = [];
  207. $updatedList = [];
  208. $addedList = [];
  209. $badList = [];
  210. $doubles = [];
  211. $added = [];
  212. $termsPerKey = [];
  213. if ($data) {
  214. $termsToAdd = [];
  215. foreach ($data as $item) {
  216. $items = [
  217. 'name' => $item['term'],
  218. 'description' => $item['definition']
  219. ];
  220. $termsToAdd[] = $items;
  221. $termsPerKey[$item['term']] = $items;
  222. }
  223. if (empty($termsToAdd)) {
  224. Display::addFlash(
  225. Display::return_message(get_lang('NothingToAdd'), 'warning')
  226. );
  227. header('Location: '.$currentUrl);
  228. exit;
  229. }
  230. $repeatItems = array_count_values(array_column($termsToAdd, 'name'));
  231. foreach ($repeatItems as $item => $count) {
  232. if ($count > 1) {
  233. $doubles[] = $item;
  234. }
  235. }
  236. $uniqueTerms = array_unique(array_keys($repeatItems));
  237. foreach ($uniqueTerms as $itemTerm) {
  238. $item = $termsPerKey[$itemTerm];
  239. if ($updateTerms) {
  240. $glossaryInfo = GlossaryManager::get_glossary_term_by_glossary_name($item['name']);
  241. if (!empty($glossaryInfo)) {
  242. $glossaryInfo['description'] = $item['description'];
  243. GlossaryManager::update_glossary($glossaryInfo, false);
  244. $updatedList[] = $item['name'];
  245. } else {
  246. $result = GlossaryManager::save_glossary($item, false);
  247. if ($result) {
  248. $addedList[] = $item['name'];
  249. } else {
  250. $badList[] = $item['name'];
  251. }
  252. }
  253. } else {
  254. $result = GlossaryManager::save_glossary($item, false);
  255. if ($result) {
  256. $addedList[] = $item['name'];
  257. } else {
  258. $badList[] = $item['name'];
  259. }
  260. }
  261. }
  262. }
  263. if (count($termsDeleted) > 0) {
  264. Display::addFlash(
  265. Display::return_message(get_lang("TermDeleted").': '.implode(', ', $termsDeleted))
  266. );
  267. }
  268. if (count($updatedList) > 0) {
  269. Display::addFlash(
  270. Display::return_message(get_lang("TermsUpdated").': '.implode(', ', $updatedList))
  271. );
  272. }
  273. if (count($addedList) > 0) {
  274. Display::addFlash(
  275. Display::return_message(get_lang("TermsAdded").': '.implode(', ', $addedList))
  276. );
  277. }
  278. if (count($badList) > 0) {
  279. Display::addFlash(
  280. Display::return_message(get_lang("GlossaryTermAlreadyExists").': ' . implode(', ', $badList), 'error')
  281. );
  282. }
  283. if (count($doubles) > 0) {
  284. Display::addFlash(
  285. Display::return_message(get_lang("TermsDuplicatedInFile").': '.implode(', ', $doubles), 'warning')
  286. );
  287. }
  288. header('Location: '.$currentUrl);
  289. exit;
  290. }
  291. break;
  292. case 'export':
  293. if (!api_is_allowed_to_edit(null, true)) {
  294. api_not_allowed(true);
  295. }
  296. $data = GlossaryManager::get_glossary_data(
  297. 0,
  298. GlossaryManager::get_number_glossary_terms(api_get_session_id()),
  299. 0,
  300. 'ASC'
  301. );
  302. usort($data, "sorter");
  303. $list = array();
  304. $list[] = array('term','definition');
  305. foreach ($data as $line) {
  306. $list[] = array ($line[0], $line[1]);
  307. }
  308. $filename = 'glossary_course_'.api_get_course_id();
  309. Export::arrayToCsv($list, $filename);
  310. break;
  311. case 'export_to_pdf':
  312. GlossaryManager::export_to_pdf();
  313. break;
  314. case 'changeview':
  315. if (in_array($_GET['view'], array('list','table'))) {
  316. Session::write('glossary_view', $_GET['view']);
  317. } else {
  318. $view = Session::read('glossary_view');
  319. if (empty($view)) {
  320. Session::write('glossary_view', 'table');
  321. }
  322. }
  323. header('Location: '.$currentUrl);
  324. exit;
  325. break;
  326. default:
  327. $tool_name = get_lang('List');
  328. $content = GlossaryManager::display_glossary();
  329. break;
  330. }
  331. Display::display_header($tool_name);
  332. // Tool introduction
  333. Display::display_introduction_section(TOOL_GLOSSARY);
  334. echo $content;
  335. Display::display_footer();