index.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364
  1. <?php // $Id: index.php 22253 2009-07-20 17:03:48Z ivantcholakov $
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /**
  4. ==============================================================================
  5. * This script edits the course description.
  6. * This script is reserved for users with write access on the course.
  7. *
  8. * @author Thomas Depraetere
  9. * @author Hugues Peeters
  10. * @author Christophe Gesché
  11. * @author Olivier brouckaert
  12. * @package dokeos.course_description
  13. ==============================================================================
  14. */
  15. /*
  16. ==============================================================================
  17. INIT SECTION
  18. ==============================================================================
  19. */
  20. // name of the language file that needs to be included
  21. $language_file = array ('course_description', 'pedaSuggest', 'accessibility');
  22. include '../inc/global.inc.php';
  23. $this_section = SECTION_COURSES;
  24. $session_id = api_get_session_id();
  25. include api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  26. include_once api_get_path(LIBRARY_PATH).'WCAG/WCAG_rendering.php';
  27. /*
  28. -----------------------------------------------------------
  29. Header
  30. -----------------------------------------------------------
  31. */
  32. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('CourseProgram'));
  33. $description_type = isset ($_REQUEST['description_type']) ? Security::remove_XSS($_REQUEST['description_type']) : null;
  34. $description_id = isset ($_REQUEST['description_id']) ? Security::remove_XSS($_REQUEST['description_id']) : null;
  35. $action = isset($_GET['action'])?Security::remove_XSS($_GET['action']):'';
  36. $edit = isset($_POST['edit'])?Security::remove_XSS($_POST['edit']):'';
  37. $add = isset($_POST['add'])?Security::remove_XSS($_POST['add']):'';
  38. if(intval($description_type) == 1) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('GeneralDescription'));
  39. if(intval($description_type) == 2) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('Objectives'));
  40. if(intval($description_type) == 3) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('Topics'));
  41. if(intval($description_type) == 4) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('Methodology'));
  42. if(intval($description_type) == 5) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('CourseMaterial'));
  43. if(intval($description_type) == 6) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('HumanAndTechnicalResources'));
  44. if(intval($description_type) == 7) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('Assessment'));
  45. if(intval($description_type) >= 8) $interbreadcrumb[] = array ("url" => "#", "name" => get_lang('NewBloc'));
  46. api_protect_course_script(true);
  47. $nameTools = get_lang('CourseProgram');
  48. Display :: display_header('');
  49. //api_display_tool_title($nameTools);
  50. /*
  51. -----------------------------------------------------------
  52. Constants and variables
  53. -----------------------------------------------------------
  54. */
  55. $nameTools = get_lang(TOOL_COURSE_DESCRIPTION);
  56. /*
  57. -----------------------------------------------------------
  58. Introduction section
  59. -----------------------------------------------------------
  60. */
  61. Display::display_introduction_section(TOOL_COURSE_DESCRIPTION);
  62. $tbl_course_description = Database::get_course_table(TABLE_COURSE_DESCRIPTION);
  63. $show_description_list = true;
  64. $show_peda_suggest = true;
  65. define('ADD_BLOCK', 8);
  66. // Default descriptions
  67. $default_description_titles = array();
  68. $default_description_titles[1]= get_lang('GeneralDescription');
  69. $default_description_titles[2]= get_lang('Objectives');
  70. $default_description_titles[3]= get_lang('Topics');
  71. $default_description_titles[4]= get_lang('Methodology');
  72. $default_description_titles[5]= get_lang('CourseMaterial');
  73. $default_description_titles[6]= get_lang('HumanAndTechnicalResources');
  74. $default_description_titles[7]= get_lang('Assessment');
  75. $default_description_titles[8]= get_lang('Other');
  76. $default_description_icon = array();
  77. $default_description_icon[1]= 'edu_miscellaneous.gif';
  78. $default_description_icon[2]= 'spire.gif';
  79. $default_description_icon[3]= 'kcmdf_big.gif';
  80. $default_description_icon[4]= 'misc.gif';
  81. $default_description_icon[5]= 'laptop.gif';
  82. $default_description_icon[6]= 'personal.gif';
  83. $default_description_icon[7]= 'korganizer.gif';
  84. $default_description_icon[8]= 'ktip.gif';
  85. $question = array();
  86. $question[1]= get_lang('GeneralDescriptionQuestions');
  87. $question[2]= get_lang('ObjectivesQuestions');
  88. $question[3]= get_lang('TopicsQuestions');
  89. $question[4]= get_lang('MethodologyQuestions');
  90. $question[5]= get_lang('CourseMaterialQuestions');
  91. $question[6]= get_lang('HumanAndTechnicalResourcesQuestions');
  92. $question[7]= get_lang('AssessmentQuestions');
  93. $information = array();
  94. $information[1]= get_lang('GeneralDescriptionInformation');
  95. $information[2]= get_lang('ObjectivesInformation');
  96. $information[3]= get_lang('TopicsInformation');
  97. $information[4]= get_lang('MethodologyInformation');
  98. $information[5]= get_lang('CourseMaterialInformation');
  99. $information[6]= get_lang('HumanAndTechnicalResourcesInformation');
  100. $information[7]= get_lang('AssessmentInformation');
  101. $default_description_title_editable = array();
  102. $default_description_title_editable[1] = true;
  103. $default_description_title_editable[2] = true;
  104. $default_description_title_editable[3] = true;
  105. $default_description_title_editable[4] = true;
  106. $default_description_title_editable[5] = true;
  107. $default_description_title_editable[6] = true;
  108. $default_description_title_editable[7] = true;
  109. /*
  110. -----------------------------------------------------------
  111. Tracking
  112. -----------------------------------------------------------
  113. */
  114. event_access_tool(TOOL_COURSE_DESCRIPTION);
  115. /*
  116. ==============================================================================
  117. MAIN CODE
  118. ==============================================================================
  119. */
  120. $condition_session = api_get_session_condition($session_id, false);
  121. $current_session_id = api_get_session_id();
  122. $sql = "SELECT description_type,title FROM $tbl_course_description $condition_session ORDER BY description_type ";
  123. $result = Database::query($sql, __FILE__, __LINE__);
  124. while ($row = Database::fetch_array($result)) {
  125. $default_description_titles[$row['description_type']] = $row['title'];
  126. }
  127. $actions = array('add','delete','edit');
  128. if ((api_is_allowed_to_edit(null,true) && !is_null($description_type)) || in_array($action,$actions)) {
  129. $description_id = intval($description_id);
  130. $description_type = intval($description_type);
  131. // Delete a description block
  132. if ($action == 'delete') {
  133. $sql = "DELETE FROM $tbl_course_description WHERE id='".$description_id."'";
  134. Database::query($sql, __FILE__, __LINE__);
  135. //update item_property (delete)
  136. api_item_property_update(api_get_course_info(), TOOL_COURSE_DESCRIPTION, Database::escape_string($description_id), 'delete', api_get_user_id());
  137. Display :: display_confirmation_message(get_lang('CourseDescriptionDeleted'));
  138. }
  139. // Add or edit a description block
  140. else {
  141. if (!empty($description_type)) {
  142. $sql = "SELECT * FROM $tbl_course_description WHERE description_type='$description_type' AND session_id='$current_session_id'";
  143. $result = Database::query($sql, __FILE__, __LINE__);
  144. if ($description = Database::fetch_array($result)) {
  145. $default_description_titles[$description_type] = $description['title'];
  146. $description_content = $description['content'];
  147. } else {
  148. $current_title = $default_description_titles[$description_type];
  149. }
  150. } else {
  151. $sql = "SELECT MAX(description_type) as MAX FROM $tbl_course_description $condition_session";
  152. $result = Database::query($sql, __FILE__, __LINE__);
  153. $max= Database::fetch_array($result);
  154. $description_type = $max['MAX']+1;
  155. if ($description_type < ADD_BLOCK) {
  156. $description_type=8;
  157. }
  158. }
  159. //Se borro: echo ' <style> .row{} <\style> por que hacia conflicto en apartado personalizado con los estilos propios del formvalidator
  160. // Build the form
  161. $form = new FormValidator('course_description','POST','index.php?'.api_get_cidreq(),'','style="width: 100%;"');
  162. $form->addElement('header', '', $default_description_titles[$description_type]);
  163. $form->addElement('hidden', 'description_type');
  164. if ($action == 'edit' || intval($edit) == 1 ) {
  165. $form->addElement('hidden', 'edit','1');
  166. }
  167. if ($action == 'add' || intval($add) == 1 ) {
  168. $form->addElement('hidden', 'add','1');
  169. }
  170. if (($description_type >= ADD_BLOCK) || $default_description_title_editable[$description_type] || $action == 'add' || intval($edit) == 1) {
  171. $form->add_textfield('title', get_lang('Title'), true, array('size'=>'width: 350px;'));
  172. $form->applyFilter('title','html_filter');
  173. }
  174. if (api_get_setting('wcag_anysurfer_public_pages')=='true') {
  175. WCAG_rendering::prepare_admin_form($description_content, $form);
  176. } else {
  177. $form->add_html_editor('contentDescription', get_lang('Content'), true, false, array('ToolbarSet' => 'TrainingDescription', 'Width' => '100%', 'Height' => '200'));
  178. }
  179. $form->addElement('style_submit_button', null, get_lang('Save'), 'class="save"');
  180. // Set some default values
  181. $default['title'] = $default_description_titles[$description_type];
  182. $default['contentDescription'] = $description_content;
  183. $default['description_id'] = $description_id;
  184. $default['description_type'] = $description_type;
  185. //if ($description_id >= ADD_BLOCK) {
  186. //$default['description_id'] = ADD_BLOCK;
  187. //}
  188. $form->setDefaults($default);
  189. // If form validates: save the description block
  190. if ($form->validate()) {
  191. $description = $form->exportValues();
  192. if (api_get_setting('wcag_anysurfer_public_pages')=='true') {
  193. $content = WCAG_Rendering::prepareXHTML();
  194. } else {
  195. $content = $description['contentDescription'];
  196. }
  197. $title = $description['title'];
  198. if ($description['description_type'] >= ADD_BLOCK) {
  199. if ($description['add']=='1') { //if this element has been submitted for addition
  200. $result = Database::query($sql, __FILE__, __LINE__);
  201. $sql = "INSERT IGNORE INTO $tbl_course_description SET description_type='$description_type', title = '".Database::escape_string(Security::remove_XSS($title,COURSEMANAGERLOWSECURITY))."', content = '".Database::escape_string(Security::remove_XSS($content,COURSEMANAGERLOWSECURITY))."', session_id = '$current_session_id' ";
  202. Database::query($sql, __FILE__, __LINE__);
  203. } else {
  204. $sql = "UPDATE $tbl_course_description SET title = '".Database::escape_string(Security::remove_XSS($title,COURSEMANAGERLOWSECURITY))."', content = '".Database::escape_string(Security::remove_XSS($content,COURSEMANAGERLOWSECURITY))."' WHERE description_type='$description_type' AND session_id = '$current_session_id'";
  205. Database::query($sql, __FILE__, __LINE__);
  206. }
  207. } else {
  208. //if title is not editable, then use default title
  209. if (!$default_description_title_editable[$description_type]) {
  210. $title = $default_description_titles[$description_type];
  211. }
  212. $sql = "DELETE FROM $tbl_course_description WHERE description_type = '".$description_type."' AND session_id = '$current_session_id'";
  213. Database::query($sql, __FILE__, __LINE__);
  214. $sql = "INSERT INTO $tbl_course_description SET description_type = '".$description_type."', title = '".Database::escape_string(Security::remove_XSS($title,COURSEMANAGERLOWSECURITY))."', content = '".Database::escape_string(Security::remove_XSS($content,COURSEMANAGERLOWSECURITY))."', session_id = '$current_session_id' ";
  215. Database::query($sql, __FILE__, __LINE__);
  216. }
  217. $id = Database::insert_id();
  218. if ($id > 0) {
  219. //insert into item_property
  220. api_item_property_update(api_get_course_info(), TOOL_COURSE_DESCRIPTION, $id, 'CourseDescriptionAdded', api_get_user_id());
  221. }
  222. Display :: display_confirmation_message(get_lang('CourseDescriptionUpdated'));
  223. }
  224. // Show the form
  225. else {
  226. // menu top
  227. //***********************************
  228. if (api_is_allowed_to_edit(null,true)) {
  229. $categories = array ();
  230. foreach ($default_description_titles as $id => $title) {
  231. $categories[$id] = $title;
  232. }
  233. $categories[ADD_BLOCK] = get_lang('NewBloc');
  234. $i=1;
  235. echo '<div class="actions">';
  236. ksort($categories);
  237. foreach ($categories as $id => $title) {
  238. if ($i==8) {
  239. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=add">'.Display::return_icon($default_description_icon[$id], $title, array('height'=>'22')).' '.$title.'</a>';
  240. break;
  241. } else {
  242. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&description_type='.$id.'">'.Display::return_icon($default_description_icon[$id], $title, array('height'=>'22')).' '.$title.'</a>&nbsp;&nbsp;';
  243. $i++;
  244. }
  245. }
  246. echo '</div>';
  247. }
  248. //***********************************
  249. if ($show_peda_suggest) {
  250. if (isset ($question[$description_id])) {
  251. $message = '<strong>'.get_lang('QuestionPlan').'</strong><br />';
  252. $message .= $question[$description_id];
  253. Display::display_normal_message($message, false);
  254. }
  255. }
  256. if (api_get_setting('wcag_anysurfer_public_pages')=='true') {
  257. echo (WCAG_Rendering::editor_header());
  258. }
  259. $form->display();
  260. if (api_get_setting('wcag_anysurfer_public_pages')=='true') {
  261. echo (WCAG_Rendering::editor_footer());
  262. }
  263. $show_description_list = false;
  264. }
  265. }
  266. }
  267. // Show the list of all description blocks
  268. if ($show_description_list) {
  269. $sql = "SELECT * FROM $tbl_course_description $condition_session ORDER BY id ";
  270. $result = Database::query($sql, __FILE__, __LINE__);
  271. $descriptions = array();
  272. while ($description = Database::fetch_object($result)) {
  273. $descriptions[$description->description_type] = $description;
  274. //reload titles to ensure we have the last version (after edition)
  275. $default_description_titles[$description->description_type] = $description->title;
  276. }
  277. if (api_is_allowed_to_edit(null,true)) {
  278. $categories = array ();
  279. foreach ($default_description_titles as $id => $title) {
  280. $categories[$id] = $title;
  281. }
  282. $categories[ADD_BLOCK] = get_lang('NewBloc');
  283. $i=1;
  284. echo '<div class="actions" style="margin-bottom:30px">';
  285. ksort($categories);
  286. foreach ($categories as $id => $title) {
  287. if ($i==8) {
  288. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=add">'.Display::return_icon($default_description_icon[$id], $title, array('height'=>'22')).' '.$title.'</a>';
  289. break;
  290. } else {
  291. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&description_type='.$id.'">'.Display::return_icon($default_description_icon[$id], $title, array('height'=>'22')).' '.$title.'</a>&nbsp;&nbsp;';
  292. $i++;
  293. }
  294. }
  295. echo '</div>';
  296. }
  297. if (isset($descriptions) && count($descriptions) > 0) {
  298. foreach ($descriptions as $id => $description) {
  299. echo '<div class="sectiontitle">';
  300. if (api_is_allowed_to_edit(null,true)) {
  301. //delete
  302. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;action=delete&amp;description_id='.$description->id.'" onclick="javascript:if(!confirm(\''.addslashes(api_htmlentities(get_lang('ConfirmYourChoice'),ENT_QUOTES,$charset)).'\')) return false;">';
  303. echo Display::return_icon('delete.gif', get_lang('Delete'), array('style' => 'vertical-align:middle;float:right;'));
  304. echo '</a> ';
  305. //edit
  306. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;action=edit&amp;description_id='.$description->id.'&amp;description_type='.$description->description_type.'">';
  307. echo Display::return_icon('edit.gif', get_lang('Edit'), array('style' => 'vertical-align:middle;float:right; padding-right:4px;'));
  308. echo '</a> ';
  309. }
  310. echo $description->title;
  311. echo '</div>';
  312. echo '<div class="sectioncomment">';
  313. echo text_filter($description->content);
  314. echo '</div>';
  315. }
  316. } else {
  317. echo '<em>'.get_lang('ThisCourseDescriptionIsEmpty').'</em>';
  318. }
  319. }
  320. /*
  321. ==============================================================================
  322. FOOTER
  323. ==============================================================================
  324. */
  325. Display :: display_footer();
  326. ?>