infocours.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Code to display the course settings form (for the course admin)
  5. * and activate the changes.
  6. *
  7. * See ./inc/conf/course_info.conf.php for settings
  8. * @todo Move $canBeEmpty from course_info.conf.php to config-settings
  9. * @todo Take those config settings into account in this script
  10. * @author Patrick Cool <patrick.cool@UGent.be>
  11. * @author Roan Embrechts, refactoring
  12. * and improved course visibility|subscribe|unsubscribe options
  13. * @package chamilo.course_info
  14. */
  15. /* INIT SECTION */
  16. // Language files that need to be included
  17. $language_file = array('create_course', 'course_info', 'admin');
  18. require_once '../inc/global.inc.php';
  19. $this_section = SECTION_COURSES;
  20. $nameTools = get_lang('ModifInfo');
  21. /* Libraries */
  22. require_once api_get_path(INCLUDE_PATH).'conf/course_info.conf.php';
  23. require_once api_get_path(LIBRARY_PATH).'pdf.lib.php';
  24. /* Constants and variables */
  25. define('MODULE_HELP_NAME', 'Settings');
  26. define('COURSE_CHANGE_PROPERTIES', 'COURSE_CHANGE_PROPERTIES');
  27. $TABLECOURSE = Database :: get_main_table(TABLE_MAIN_COURSE);
  28. $TABLEFACULTY = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  29. $TABLELANGUAGES = Database :: get_main_table(TABLE_MAIN_LANGUAGE);
  30. $currentCourseRepository = $_course['path'];
  31. $is_allowedToEdit = $is_courseAdmin || $is_platformAdmin;
  32. $course_code = $_course['sysCode'];
  33. $course_access_settings = CourseManager :: get_access_settings($course_code);
  34. //LOGIC FUNCTIONS
  35. function is_settings_editable() {
  36. return $GLOBALS['course_info_is_editable'];
  37. }
  38. /* MAIN CODE */
  39. if (!$is_allowedToEdit) {
  40. api_not_allowed(true);
  41. }
  42. $show_delete_watermark_text_message = false;
  43. if (api_get_setting('pdf_export_watermark_by_course') == 'true') {
  44. if (isset($_GET['delete_watermark'])) {
  45. PDF::delete_watermark($course_code);
  46. $show_delete_watermark_text_message = true;
  47. }
  48. }
  49. $table_course_category = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  50. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  51. $tbl_admin = Database :: get_main_table(TABLE_MAIN_ADMIN);
  52. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  53. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  54. // Get all course categories
  55. $sql = "SELECT code,name FROM ".$table_course_category." WHERE auth_course_child ='TRUE' OR code = '".Database::escape_string($_course['categoryCode'])."' ORDER BY tree_pos";
  56. $res = Database::query($sql);
  57. $s_select_course_tutor_name = "SELECT tutor_name FROM $tbl_course WHERE code='$course_code'";
  58. $q_tutor = Database::query($s_select_course_tutor_name);
  59. $s_tutor = Database::result($q_tutor, 0, 'tutor_name');
  60. $target_name = api_sort_by_first_name() ? 'firstname' : 'lastname';
  61. $s_sql_course_titular = "SELECT DISTINCT username, lastname, firstname FROM $tbl_user as user, $tbl_course_user as course_rel_user WHERE (course_rel_user.status='1') AND user.user_id=course_rel_user.user_id AND course_code='".$course_code."' ORDER BY ".$target_name." ASC";
  62. $q_result_titulars = Database::query($s_sql_course_titular);
  63. if (Database::num_rows($q_result_titulars) == 0) {
  64. $sql = "SELECT username, lastname, firstname FROM $tbl_user as user, $tbl_admin as admin WHERE admin.user_id=user.user_id ORDER BY ".$target_name." ASC";
  65. $q_result_titulars = Database::query($sql);
  66. }
  67. $a_profs[0] = '-- '.get_lang('NoManager').' --';
  68. while ($a_titulars = Database::fetch_array($q_result_titulars)) {
  69. $s_username = $a_titulars['username'];
  70. $s_lastname = $a_titulars['lastname'];
  71. $s_firstname = $a_titulars['firstname'];
  72. if (api_get_person_name($s_firstname, $s_lastname) == $s_tutor) {
  73. $s_selected_tutor = api_get_person_name($s_firstname, $s_lastname);
  74. }
  75. $s_disabled_select_titular = '';
  76. if (!$is_courseAdmin) {
  77. $s_disabled_select_titular = 'disabled=disabled';
  78. }
  79. $a_profs[api_get_person_name($s_firstname, $s_lastname)] = api_get_person_name($s_lastname, $s_firstname).' ('.$s_username.')';
  80. }
  81. $categories[''] = '-';
  82. while ($cat = Database::fetch_array($res)) {
  83. $categories[$cat['code']] = '('.$cat['code'].') '.$cat['name'];
  84. ksort($categories);
  85. }
  86. $linebreak = '<div class="row"><div class="label"></div><div class="formw" style="border-bottom:1px dashed grey"></div></div>';
  87. // Build the form
  88. $form = new FormValidator('update_course');
  89. // COURSE SETTINGS
  90. $form->addElement('html', '<div><h3>'.Display::return_icon('settings.png', Security::remove_XSS(get_lang('CourseSettings')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('CourseSettings')).'</h3><div>');
  91. $image_html = '';
  92. // Sending image
  93. if ($form->validate() && is_settings_editable()) {
  94. // update course picture
  95. $picture = $_FILES['picture'];
  96. if (!empty($picture['name'])) {
  97. $picture_uri = CourseManager::update_course_picture($course_code, $picture['name'], $picture['tmp_name']);
  98. }
  99. }
  100. // Display course picture
  101. $course_path = api_get_path(SYS_COURSE_PATH).$currentCourseRepository; // course path
  102. if (file_exists($course_path.'/course-pic85x85.png')) {
  103. $course_web_path = api_get_path(WEB_COURSE_PATH).$currentCourseRepository; // course web path
  104. $course_medium_image = $course_web_path.'/course-pic85x85.png?'.rand(1,1000); // redimensioned image 85x85
  105. $image_html = '<div class="row"><div class="formw"><img src="'.$course_medium_image.'" /></div></div>';
  106. }
  107. $form->addElement('html', $image_html);
  108. $form->add_textfield('title', get_lang('Title'), true, array('size' => '60'));
  109. //$form->applyFilter('title', 'html_filter');
  110. $form->applyFilter('title', 'trim');
  111. //$form->add_textfield('tutor_name', get_lang('Professors'), true, array ('size' => '60'));
  112. //the teacher doesn't need to change the trainer only the admin can do that
  113. /*
  114. $prof = &$form->addElement('select', 'tutor_name', get_lang('Teacher'), $a_profs, array('style'=>'width:350px', 'class'=>'chzn-select', 'id'=>'tutor_name'));
  115. $form->applyFilter('tutor_name', 'html_filter');
  116. $prof -> setSelected($s_selected_tutor);
  117. * /
  118. /*$visual_code=$form->addElement('text', 'visual_code', get_lang('Code'));
  119. $visual_code->freeze();
  120. $form->applyFilter('visual_code', 'strtoupper');*/
  121. $form->addElement('select', 'category_code', get_lang('Fac'), $categories, array('style'=>'width:350px', 'class'=>'chzn-select', 'id'=>'category_code'));
  122. $form->addElement('select_language', 'course_language', array(get_lang('Ln'), get_lang('TipLang')));
  123. $form->add_textfield('department_name', get_lang('Department'), false, array('size' => '60'));
  124. $form->applyFilter('department_name', 'trim');
  125. $form->add_textfield('department_url', get_lang('DepartmentUrl'), false, array('size' => '60'));
  126. //$form->addRule('tutor_name', get_lang('ThisFieldIsRequired'), 'required');
  127. // Picture
  128. $form->addElement('file', 'picture', get_lang('AddPicture'));
  129. $allowed_picture_types = array ('jpg', 'jpeg', 'png', 'gif');
  130. $form->addRule('picture', get_lang('OnlyImagesAllowed').' ('.implode(',', $allowed_picture_types).')', 'filetype', $allowed_picture_types);
  131. if (api_get_setting('pdf_export_watermark_by_course') == 'true') {
  132. $url = PDF::get_watermark($course_code);
  133. $form->add_textfield('pdf_export_watermark_text', get_lang('PDFExportWatermarkTextTitle'), false, array('size' => '60'));
  134. $form->addElement('file', 'pdf_export_watermark_path', get_lang('AddWaterMark'));
  135. if ($url != false) {
  136. $delete_url = '<a href="?delete_watermark">'.Display::return_icon('delete.png',get_lang('DelImage')).'</a>';
  137. $form->addElement('html', '<div class="row"><div class="formw"><a href="'.$url.'">'.$url.' '.$delete_url.'</a></div></div>');
  138. }
  139. $form->addRule('pdf_export_watermark_path', get_lang('OnlyImagesAllowed').' ('.implode(',', $allowed_picture_types).')', 'filetype', $allowed_picture_types);
  140. }
  141. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  142. $form->addElement('html', '</div></div>');
  143. // COURSE ACCESS
  144. $form->addElement('html', '<div> <h3>'.Display::return_icon('course.png', Security::remove_XSS(get_lang('CourseAccess')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('CourseAccess')).'</h3><div>');
  145. $group = array();
  146. $group[]= $form->createElement('radio', 'visibility', get_lang("CourseAccess"), get_lang('OpenToTheWorld'), COURSE_VISIBILITY_OPEN_WORLD);
  147. $group[]= $form->createElement('radio', 'visibility', null, get_lang('OpenToThePlatform'), COURSE_VISIBILITY_OPEN_PLATFORM);
  148. $group[]= $form->createElement('radio', 'visibility', null, get_lang('Private'), COURSE_VISIBILITY_REGISTERED);
  149. $group[]= $form->createElement('radio', 'visibility', null, get_lang('CourseVisibilityClosed'), COURSE_VISIBILITY_CLOSED);
  150. $form->addGroup($group, '', array(get_lang("CourseAccess"), get_lang("CourseAccessConfigTip")), '');
  151. $group = array();
  152. $group[]=$form->createElement('radio', 'subscribe', get_lang('Subscription'), get_lang('Allowed'), 1);
  153. $group[]=$form->createElement('radio', 'subscribe', null, get_lang('Denied'), 0);
  154. $form->addGroup($group, '', array(get_lang("Subscription")), '');
  155. $group = array();
  156. $group[]=$form->createElement('radio', 'unsubscribe', get_lang('Unsubscription'), get_lang('AllowedToUnsubscribe'), 1);
  157. $group[]=$form->createElement('radio', 'unsubscribe', null, get_lang('NotAllowedToUnsubscribe'), 0);
  158. $form->addGroup($group, '', array(get_lang("Unsubscription")), '');
  159. $form->add_textfield('course_registration_password', get_lang('CourseRegistrationPassword'), false, array('size' => '60'));
  160. $form->addElement('checkbox', 'activate_legal', array(null, get_lang('ShowALegalNoticeWhenEnteringTheCourse')), get_lang('ActivateLegal'));
  161. $form->addElement('textarea', 'legal', get_lang('CourseLegalAgreement'), array('cols'=>75, 'rows' => 10));
  162. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  163. $form->addElement('html', '</div></div>');
  164. // EMAIL NOTIFICATIONS
  165. $form->addElement('html', '<div> <h3>'.Display::return_icon('mail.png', Security::remove_XSS(get_lang('EmailNotifications')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('EmailNotifications')).'</h3><div>');
  166. $group = array();
  167. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', get_lang('NewUserEmailAlert'), get_lang('NewUserEmailAlertEnable'), 1);
  168. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', null, get_lang('NewUserEmailAlertToTeacharAndTutor'), 2);
  169. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', null, get_lang('NewUserEmailAlertDisable'), 0);
  170. $form->addGroup($group, '', array(get_lang("NewUserEmailAlert")), '');
  171. $group = array();
  172. $group[]=$form->createElement('radio', 'email_alert_students_on_new_homework', get_lang('NewHomeworkEmailAlert'), get_lang('NewHomeworkEmailAlertEnable'), 1);
  173. $group[]=$form->createElement('radio', 'email_alert_students_on_new_homework', null, get_lang('NewHomeworkEmailAlertDisable'), 0);
  174. $form->addGroup($group, '', array(get_lang("NewHomeworkEmailAlert")), '');
  175. $group = array();
  176. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_doc', get_lang('WorkEmailAlert'), get_lang('WorkEmailAlertActivate'), 1);
  177. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_doc', null, get_lang('WorkEmailAlertDeactivate'), 0);
  178. $form->addGroup($group, '', array(get_lang("WorkEmailAlert")), '');
  179. $group = array();
  180. $group[]=$form->createElement('radio', 'email_alert_on_new_doc_dropbox', get_lang('DropboxEmailAlert'), get_lang('DropboxEmailAlertActivate'), 1);
  181. $group[]=$form->createElement('radio', 'email_alert_on_new_doc_dropbox', null, get_lang('DropboxEmailAlertDeactivate'), 0);
  182. $form->addGroup($group, '', array(get_lang("DropboxEmailAlert")), '');
  183. $group = array();
  184. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_quiz', get_lang('QuizEmailAlert'), get_lang('QuizEmailAlertActivate'), 1);
  185. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_quiz', null, get_lang('QuizEmailAlertDeactivate'), 0);
  186. $form->addGroup($group, '', array(get_lang("QuizEmailAlert")), '');
  187. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  188. $form->addElement('html', '</div></div>');
  189. // Gradebook SETTINGS
  190. $form->addElement('html', '<div><h3>'.Display::return_icon('gradebook.png', Security::remove_XSS(get_lang('Gradebook')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('Gradebook')).'</h3><div>');
  191. $group = array();
  192. $models = api_get_settings_options('grading_model');
  193. if (!empty($models )) {
  194. foreach ($models as $option) {
  195. $grading_parsed = api_grading_model_functions($option['value'], 'decorate');
  196. $element = $form->createElement('radio', 'course_grading_model', '', $option['display_text'].': '.$grading_parsed, $option['id']);
  197. $group[] = $element;
  198. }
  199. }
  200. $element = $form->createElement('radio', 'course_grading_model', '', get_lang('None'), 0);
  201. $group[] = $element;
  202. $form->addGroup($group, '', array(get_lang('GradingModelTitle')), '', 'li', false);
  203. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  204. $form->addElement('html', '</div></div>');
  205. // USER RIGHTS
  206. $form->addElement('html', '<div> <h3>'.Display::return_icon('user.png', Security::remove_XSS(get_lang('UserRights')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('UserRights')).'</h3><div>');
  207. $group = array();
  208. $group[]=$form->createElement('radio', 'allow_user_edit_agenda', get_lang('AllowUserEditAgenda'), get_lang('AllowUserEditAgendaActivate'), 1);
  209. $group[]=$form->createElement('radio', 'allow_user_edit_agenda', null, get_lang('AllowUserEditAgendaDeactivate'), 0);
  210. $form->addGroup($group, '', array(get_lang("AllowUserEditAgenda")), '');
  211. $group = array();
  212. $group[]=$form->createElement('radio', 'allow_user_edit_announcement', get_lang('AllowUserEditAnnouncement'), get_lang('AllowUserEditAnnouncementActivate'), 1);
  213. $group[]=$form->createElement('radio', 'allow_user_edit_announcement', null, get_lang('AllowUserEditAnnouncementDeactivate'), 0);
  214. $form->addGroup($group, '', array(get_lang("AllowUserEditAnnouncement")), '');
  215. $group = array();
  216. $group[]=$form->createElement('radio', 'allow_user_image_forum', get_lang('AllowUserImageForum'), get_lang('AllowUserImageForumActivate'), 1);
  217. $group[]=$form->createElement('radio', 'allow_user_image_forum', null, get_lang('AllowUserImageForumDeactivate'), 0);
  218. $form->addGroup($group, '', array(get_lang("AllowUserImageForum")), '');
  219. $group = array();
  220. $group[]=$form->createElement('radio', 'allow_user_view_user_list', get_lang('AllowUserViewUserList'), get_lang('AllowUserViewUserListActivate'), 1);
  221. $group[]=$form->createElement('radio', 'allow_user_view_user_list', null, get_lang('AllowUserViewUserListDeactivate'), 0);
  222. $form->addGroup($group, '', array(get_lang("AllowUserViewUserList")), '');
  223. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  224. $form->addElement('html', '</div></div>');
  225. // CHAT SETTINGS
  226. $form->addElement('html', '<div><h3>'.Display::return_icon('chat.png', Security::remove_XSS(get_lang('ConfigChat')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('ConfigChat')).'</h3><div>');
  227. $group = array();
  228. $group[]=$form->createElement('radio', 'allow_open_chat_window', get_lang('AllowOpenchatWindow'), get_lang('AllowOpenChatWindowActivate'), 1);
  229. $group[]=$form->createElement('radio', 'allow_open_chat_window', null, get_lang('AllowOpenChatWindowDeactivate'), 0);
  230. $form->addGroup($group, '', array(get_lang("AllowOpenchatWindow")), '');
  231. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  232. $form->addElement('html', '</div></div>');
  233. // LEARNING PATH
  234. $form->addElement('html', '<div><h3>'.Display::return_icon('scorms.png', get_lang('ConfigLearnpath'),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('ConfigLearnpath')).'</h3><div>');
  235. //Auto launch LP
  236. $group = array();
  237. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', get_lang('LPAutoLaunch'), get_lang('RedirectToALearningPath'), 1);
  238. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', get_lang('LPAutoLaunch'), get_lang('RedirectToTheLearningPathList'), 2);
  239. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', null, get_lang('Deactivate'), 0);
  240. $form->addGroup($group, '', array(get_lang("LPAutoLaunch")), '');
  241. if (api_get_setting('allow_course_theme') == 'true') {
  242. // Allow theme into Learning path
  243. $group = array();
  244. $group[]=$form->createElement('radio', 'allow_learning_path_theme', get_lang('AllowLearningPathTheme'), get_lang('AllowLearningPathThemeAllow'), 1);
  245. $group[]=$form->createElement('radio', 'allow_learning_path_theme', null, get_lang('AllowLearningPathThemeDisallow'), 0);
  246. $form->addGroup($group, '', array(get_lang("AllowLearningPathTheme")), '');
  247. $group = array();
  248. $group[]=$form->createElement('select_theme', 'course_theme', null, array('class'=>' ', 'id'=>'course_theme_id'));
  249. $form->addGroup($group, '', array(get_lang("Stylesheets")), '');
  250. }
  251. if (is_settings_editable()) {
  252. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  253. } else {
  254. // Is it allowed to edit the course settings?
  255. if (!is_settings_editable())
  256. $disabled_output = "disabled";
  257. $form->freeze();
  258. }
  259. $form->addElement('html', '</div></div>');
  260. // THEMATIC ADVANCE SETTINGS
  261. $form->addElement('html', '<div><h3>'.Display::return_icon('course_progress.png', Security::remove_XSS(get_lang('ThematicAdvanceConfiguration')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('ThematicAdvanceConfiguration')).'</h3><div>');
  262. $group = array();
  263. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', get_lang('InfoAboutAdvanceInsideHomeCourse'), get_lang('DisplayAboutLastDoneAdvance'), 1);
  264. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DisplayAboutNextAdvanceNotDone'), 2);
  265. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DisplayAboutNextAdvanceNotDoneAndLastDoneAdvance'), 3);
  266. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DoNotDisplayAnyAdvance'), 0);
  267. $form->addGroup($group, '', array(get_lang("InfoAboutAdvanceInsideHomeCourse")), '');
  268. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  269. $form->addElement('html', '</div></div>');
  270. // Get all the course information
  271. $all_course_information = CourseManager::get_course_information($_course['sysCode']);
  272. // Set the default values of the form
  273. $values['title'] = $_course['name'];
  274. //$values['visual_code'] = $_course['official_code'];
  275. $values['category_code'] = $_course['categoryCode'];
  276. //$values['tutor_name'] = $_course['titular'];
  277. $values['course_language'] = $_course['language'];
  278. $values['department_name'] = $_course['extLink']['name'];
  279. $values['department_url'] = $_course['extLink']['url'];
  280. $values['visibility'] = $_course['visibility'];
  281. $values['subscribe'] = $course_access_settings['subscribe'];
  282. $values['unsubscribe'] = $course_access_settings['unsubscribe'];
  283. $values['course_registration_password'] = $all_course_information['registration_code'];
  284. $values['legal'] = $all_course_information['legal'];
  285. $values['activate_legal'] = $all_course_information['activate_legal'];
  286. // Get send_mail_setting (auth)from table
  287. $values['email_alert_to_teacher_on_new_user_in_course']= api_get_course_setting('email_alert_to_teacher_on_new_user_in_course');
  288. // Get send_mail_setting (work)from table
  289. $values['email_alert_manager_on_new_doc'] = api_get_course_setting('email_alert_manager_on_new_doc');
  290. // Get send_mail_setting (dropbox) from table
  291. $values['email_alert_on_new_doc_dropbox'] = api_get_course_setting('email_alert_on_new_doc_dropbox');
  292. // Get send_mail_setting (work)from table
  293. $values['email_alert_manager_on_new_quiz'] = api_get_course_setting('email_alert_manager_on_new_quiz');
  294. // Get allow_user_edit_agenda from table
  295. $values['allow_user_edit_agenda'] = api_get_course_setting('allow_user_edit_agenda');
  296. // Get allow_user_edit_announcement from table
  297. $values['allow_user_edit_announcement'] = api_get_course_setting('allow_user_edit_announcement');
  298. // Get allow_user_image_forum from table
  299. $values['allow_user_image_forum'] = api_get_course_setting('allow_user_image_forum');
  300. // Get allow_open_chat_window from table
  301. $values['allow_open_chat_window'] = api_get_course_setting('allow_open_chat_window');
  302. // Get course_theme from table
  303. $values['course_theme'] = api_get_course_setting('course_theme');
  304. // Get allow_learning_path_theme from table
  305. $values['allow_learning_path_theme'] = api_get_course_setting('allow_learning_path_theme');
  306. //Get allow show user list
  307. $values['allow_user_view_user_list'] = api_get_course_setting('allow_user_view_user_list');
  308. //Get allow show user list
  309. $values['display_info_advance_inside_homecourse'] = api_get_course_setting('display_info_advance_inside_homecourse');
  310. $values['email_alert_students_on_new_homework'] = api_get_course_setting('email_alert_students_on_new_homework');
  311. $values['enable_lp_auto_launch'] = api_get_course_setting('enable_lp_auto_launch');
  312. $values['pdf_export_watermark_text'] = api_get_course_setting('pdf_export_watermark_text');
  313. $values['course_grading_model'] = api_get_course_setting('course_grading_model');
  314. $form->setDefaults($values);
  315. // Validate form
  316. if ($form->validate() && is_settings_editable()) {
  317. $update_values = $form->exportValues();
  318. /*
  319. // update course picture
  320. $picture = $_FILES['picture'];
  321. if (!empty($picture['name'])) {
  322. $picture_uri = CourseManager::update_course_picture($course_code, $picture['name'], $picture['tmp_name']);
  323. }*/
  324. $pdf_export_watermark_path = $_FILES['pdf_export_watermark_path'];
  325. if (!empty($pdf_export_watermark_path['name'])) {
  326. $pdf_export_watermark_path_result = PDF::upload_watermark($pdf_export_watermark_path['name'], $pdf_export_watermark_path['tmp_name'], $course_code);
  327. unset($update_values['pdf_export_watermark_path']);
  328. }
  329. //Variables that will be saved in the TABLE_MAIN_COURSE table
  330. $update_in_course_table = array('title', 'course_language','category_code','department_name', 'department_url','visibility',
  331. 'subscribe', 'unsubscribe','tutor_name','course_registration_password', 'legal', 'activate_legal');
  332. foreach ($update_values as $index =>$value) {
  333. $update_values[$index] = Database::escape_string($value);
  334. }
  335. unset($value);
  336. //visual_code = '".$update_values['visual_code']."',
  337. //tutor_name = '".$update_values['tutor_name']."',
  338. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  339. $sql = "UPDATE $table_course SET
  340. title = '".$update_values['title']."',
  341. course_language = '".$update_values['course_language']."',
  342. category_code = '".$update_values['category_code']."',
  343. department_name = '".$update_values['department_name']."',
  344. department_url = '".$update_values['department_url']."',
  345. visibility = '".$update_values['visibility']."',
  346. subscribe = '".$update_values['subscribe']."',
  347. unsubscribe = '".$update_values['unsubscribe']."',
  348. legal = '".$update_values['legal']."',
  349. activate_legal = '".$update_values['activate_legal']."',
  350. registration_code = '".$update_values['course_registration_password']."'
  351. WHERE code = '".$course_code."'";
  352. Database::query($sql);
  353. // Update course_settings table - this assumes those records exist, otherwise triggers an error
  354. $table_course_setting = Database::get_course_table(TABLE_COURSE_SETTING);
  355. foreach($update_values as $key =>$value) {
  356. //We do not update variables that were already saved in the TABLE_MAIN_COURSE table
  357. if (!in_array($key, $update_in_course_table)) {
  358. Database::update($table_course_setting, array('value' => $update_values[$key]), array('variable = ? AND c_id = ?' => array($key, api_get_course_int_id()), true));
  359. }
  360. }
  361. $cidReset = true;
  362. $cidReq = $course_code;
  363. require '../inc/local.inc.php';
  364. header('Location: infocours.php?action=show_message&cidReq='.$course_code);
  365. exit;
  366. }
  367. /* Header */
  368. Display :: display_header($nameTools, MODULE_HELP_NAME);
  369. if ($show_delete_watermark_text_message) {
  370. Display :: display_normal_message(get_lang('FileDeleted'));
  371. }
  372. //api_display_tool_title($nameTools);
  373. if (isset($_GET['action']) && $_GET['action'] == 'show_message') {
  374. Display :: display_normal_message(get_lang('ModifDone'));
  375. }
  376. echo '<script>
  377. $(function() {
  378. $("#course_settings").accordion({
  379. autoHeight: false,
  380. header: "div> h3"
  381. });
  382. });
  383. </script>';
  384. // Display the form
  385. echo '<div id="course_settings">';
  386. $form->display();
  387. echo '</div>';
  388. Display::display_footer();