index.php 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.glossary
  5. * @author Christian Fasanando, initial version
  6. * @author Bas Wijnen import/export to CSV
  7. */
  8. // The language file that needs to be included.
  9. $language_file = array('glossary', 'admin');
  10. // Including the global initialization file.
  11. require_once '../inc/global.inc.php';
  12. require_once api_get_path(LIBRARY_PATH).'export.lib.inc.php';
  13. $current_course_tool = TOOL_GLOSSARY;
  14. // The section (tabs).
  15. $this_section = SECTION_COURSES;
  16. // Notification for unauthorized people.
  17. api_protect_course_script(true);
  18. // Additional javascripts.
  19. $htmlHeadXtra[] = GlossaryManager::javascript_glossary();
  20. $htmlHeadXtra[] = '<script>
  21. function setFocus(){
  22. $("#glossary_title").focus();
  23. }
  24. $(document).ready(function () {
  25. setFocus();
  26. });
  27. </script>';
  28. // setting the tool constants
  29. $tool = TOOL_GLOSSARY;
  30. // Tracking
  31. event_access_tool(TOOL_GLOSSARY);
  32. function sorter($item1, $item2) {
  33. if ($item1[2] == $item2[2])
  34. return 0;
  35. return $item1[2] < $item2[2] ? -1 : 1;
  36. }
  37. // Displaying the header
  38. $action = isset($_GET['action']) ? $_GET['action'] : null;
  39. $tool = 'GlossaryManagement';
  40. $interbreadcrumb[] = array ("url"=>"index.php", "name"=> get_lang('Glossary'));
  41. if (!empty($action)) {
  42. }
  43. switch ($action) {
  44. case 'addglossary':
  45. $tool_name = get_lang('Add');
  46. break;
  47. case 'edit_glossary':
  48. $tool_name = get_lang('Edit');
  49. break;
  50. case 'import':
  51. $tool_name = get_lang('ImportGlossary');
  52. break;
  53. case 'changeview':
  54. $tool_name = get_lang('List');
  55. break;
  56. }
  57. if (isset($_GET['action']) && $_GET['action'] == 'export') {
  58. $data = GlossaryManager::get_glossary_data(0, GlossaryManager::get_number_glossary_terms (api_get_session_id()), 0, 'ASC');
  59. usort($data, "sorter");
  60. $list = array();
  61. $list[] = array('term','definition');
  62. foreach($data as $line) {
  63. $list[] = array ($line[0], $line[1]);
  64. }
  65. $filename = 'glossary_course_'.api_get_course_id();
  66. Export::export_table_csv_utf8($list, $filename);
  67. }
  68. if (isset($_GET['action']) && $_GET['action'] == 'export_to_pdf') {
  69. GlossaryManager::export_to_pdf();
  70. }
  71. Display::display_header($tool_name);
  72. // Tool introduction
  73. Display::display_introduction_section(TOOL_GLOSSARY);
  74. if (isset($_GET['action']) && $_GET['action'] == 'changeview' AND in_array($_GET['view'],array('list','table'))) {
  75. $_SESSION['glossary_view'] = $_GET['view'];
  76. } else {
  77. if (!isset($_SESSION['glossary_view'])) {
  78. $_SESSION['glossary_view'] = 'table';//Default option
  79. }
  80. }
  81. if (api_is_allowed_to_edit(null, true)) {
  82. switch ($action) {
  83. case 'addglossary':
  84. $form = new FormValidator('glossary','post', api_get_self().'?action='.Security::remove_XSS($_GET['action']));
  85. // settting the form elements
  86. $form->addElement('header', '', get_lang('TermAddNew'));
  87. $form->addElement('text', 'glossary_title', get_lang('TermName'), array('size'=>'80', 'id'=>'glossary_title'));
  88. //$form->applyFilter('glossary_title', 'html_filter');
  89. $form->addElement('html_editor', 'glossary_comment', get_lang('TermDefinition'), null, array('ToolbarSet' => 'Glossary', 'Width' => '90%', 'Height' => '300'));
  90. $form->addElement('style_submit_button', 'SubmitGlossary', get_lang('TermAddButton'), 'class="save"');
  91. // setting the rules
  92. $form->addRule('glossary_title',get_lang('ThisFieldIsRequired'), 'required');
  93. // The validation or display
  94. if ($form->validate()) {
  95. $check = Security::check_token('post');
  96. if ($check) {
  97. $values = $form->exportValues();
  98. GlossaryManager::save_glossary($values);
  99. }
  100. Security::clear_token();
  101. GlossaryManager::display_glossary();
  102. } else {
  103. $token = Security::get_token();
  104. $form->addElement('hidden','sec_token');
  105. $form->setConstants(array('sec_token' => $token));
  106. $form->display();
  107. }
  108. break;
  109. case 'edit_glossary':
  110. if (is_numeric($_GET['glossary_id'])) {
  111. // initiate the object
  112. $form = new FormValidator('glossary','post', api_get_self().'?action='.Security::remove_XSS($_GET['action']).'&glossary_id='.Security::remove_XSS($_GET['glossary_id']));
  113. // settting the form elements
  114. $form->addElement('header', '', get_lang('TermEdit'));
  115. $form->addElement('hidden', 'glossary_id');
  116. $form->addElement('text', 'glossary_title', get_lang('TermName'),array('size'=>'80'));
  117. //$form->applyFilter('glossary_title', 'html_filter');
  118. $form->addElement('html_editor', 'glossary_comment', get_lang('TermDefinition'), null, array('ToolbarSet' => 'Glossary', 'Width' => '90%', 'Height' => '300'));
  119. $element = $form->addElement('text', 'insert_date', get_lang('CreationDate'),array('size'=>'100'));
  120. $element ->freeze();
  121. $element = $form->addElement('text', 'update_date', get_lang('UpdateDate'),array('size'=>'100'));
  122. $element ->freeze();
  123. $form->addElement('style_submit_button', 'SubmitGlossary', get_lang('TermUpdateButton'), 'class="save"');
  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']) && $glossary_data['insert_date'] != '0000-00-00 00:00:00:') {
  128. $glossary_data['insert_date'] = api_get_local_time($glossary_data['insert_date']);
  129. } else {
  130. $glossary_data['insert_date'] = '';
  131. }
  132. if (!empty($glossary_data['update_date']) && $glossary_data['update_date'] != '0000-00-00 00:00:00:') {
  133. $glossary_data['update_date'] = api_get_local_time($glossary_data['update_date']);
  134. } else {
  135. $glossary_data['update_date'] = '';
  136. }
  137. $form->setDefaults($glossary_data);
  138. // setting the rules
  139. $form->addRule('glossary_title', get_lang('ThisFieldIsRequired'), 'required');
  140. // The validation or display
  141. if ($form->validate()) {
  142. $check = Security::check_token('post');
  143. if ($check) {
  144. $values = $form->exportValues();
  145. GlossaryManager::update_glossary($values);
  146. }
  147. Security::clear_token();
  148. GlossaryManager::display_glossary();
  149. } else {
  150. $token = Security::get_token();
  151. $form->addElement('hidden', 'sec_token');
  152. $form->setConstants(array('sec_token' => $token));
  153. $form->display();
  154. }
  155. }
  156. break;
  157. case 'delete_glossary':
  158. GlossaryManager::delete_glossary($_GET['glossary_id']);
  159. GlossaryManager::display_glossary();
  160. break;
  161. case 'moveup':
  162. //GlossaryManager::move_glossary('up',$_GET['glossary_id']); //actions not available
  163. GlossaryManager::display_glossary();
  164. break;
  165. case 'movedown':
  166. //GlossaryManager::move_glossary('down',$_GET['glossary_id']); //actions not available
  167. GlossaryManager::display_glossary();
  168. break;
  169. case 'import':
  170. $form = new FormValidator('glossary','post', api_get_self().'?action=import');
  171. $form->addElement('header', '', get_lang('ImportGlossary'));
  172. $form->addElement('file', 'file', get_lang('ImportCSVFileLocation'));
  173. $form->addElement('checkbox', 'replace', null, get_lang('DeleteAllGlossaryTerms'));
  174. $form->addElement('style_submit_button', 'SubmitImport', get_lang('Import'), 'class="save"');
  175. $form->display();
  176. echo get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')';
  177. echo '<pre>
  178. <strong>term</strong>;<strong>definition</strong>;
  179. "Hello";"Hola";
  180. "Good";"Bueno";</pre>';
  181. if ($form->validate()) {
  182. //this is a bad idea //jm
  183. if (isset($_POST['replace']) && $_POST['replace']) {
  184. foreach (GlossaryManager::get_glossary_terms() as $term) {
  185. if (!GlossaryManager::delete_glossary($term['id'], false)) {
  186. Display::display_error_message (get_lang ("CannotDeleteGlossary") . ':' . $term['id']);
  187. }
  188. }
  189. }
  190. //$data = Import::csv_to_array($_FILES['file']['tmp_name']);
  191. $data = Import::csv_reader($_FILES['file']['tmp_name']);
  192. $good = 0;
  193. $bad = 0;
  194. foreach ($data as $item) {
  195. if (GlossaryManager::save_glossary(array('glossary_title' => $item['term'], 'glossary_comment' => $item['definition']), false))
  196. $good++;
  197. else
  198. $bad++;
  199. }
  200. Display::display_confirmation_message (get_lang ("TermsImported") . ':' . $good);
  201. if ($bad)
  202. Display::display_error_message (get_lang ("TermsNotImported") . ':' . $bad);
  203. GlossaryManager::display_glossary();
  204. }
  205. break;
  206. default:
  207. GlossaryManager::display_glossary();
  208. break;
  209. }
  210. } else {
  211. GlossaryManager::display_glossary();
  212. }
  213. // Footer
  214. Display::display_footer();