infocours.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489
  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 and improved course visibility|subscribe|unsubscribe options
  12. * @author Julio Montoya <gugli100@gmail.com> Jquery support + lots of fixes
  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', 'gradebook', 'document');
  18. require_once '../inc/global.inc.php';
  19. $current_course_tool = TOOL_COURSE_SETTING;
  20. $this_section = SECTION_COURSES;
  21. $nameTools = get_lang('ModifInfo');
  22. /* Libraries */
  23. require_once api_get_path(LIBRARY_PATH).'pdf.lib.php';
  24. require_once api_get_path(LIBRARY_PATH).'fileDisplay.lib.php';
  25. api_protect_course_script(true);
  26. api_block_anonymous_users();
  27. /* Constants and variables */
  28. define('MODULE_HELP_NAME', 'Settings');
  29. define('COURSE_CHANGE_PROPERTIES', 'COURSE_CHANGE_PROPERTIES');
  30. $currentCourseRepository = $_course['path'];
  31. $is_allowedToEdit = $is_courseAdmin || $is_platformAdmin;
  32. $course_code = api_get_course_id();
  33. $course_access_settings = CourseManager :: get_access_settings($course_code);
  34. //LOGIC FUNCTIONS
  35. function is_settings_editable() {
  36. return isset($GLOBALS['course_info_is_editable']) && $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('class' => 'span6'));
  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('class' => 'span5'));
  124. $form->applyFilter('department_name', 'trim');
  125. $form->add_textfield('department_url', get_lang('DepartmentUrl'), false, array('class' => 'span5'));
  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. $group = array();
  142. $group[]=$form->createElement('select_theme', 'course_theme', null, array('class'=>' ', 'id'=>'course_theme_id'));
  143. $form->addGroup($group, '', array(get_lang("Stylesheets")), '');
  144. $form->addElement('label', get_lang('DocumentQuota'), format_file_size(DocumentManager::get_course_quota()));
  145. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  146. $form->addElement('html', '</div></div>');
  147. // COURSE ACCESS
  148. $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>');
  149. $group = array();
  150. $group[]= $form->createElement('radio', 'visibility', get_lang("CourseAccess"), get_lang('OpenToTheWorld'), COURSE_VISIBILITY_OPEN_WORLD);
  151. $group[]= $form->createElement('radio', 'visibility', null, get_lang('OpenToThePlatform'), COURSE_VISIBILITY_OPEN_PLATFORM);
  152. $group[]= $form->createElement('radio', 'visibility', null, get_lang('Private'), COURSE_VISIBILITY_REGISTERED);
  153. $group[]= $form->createElement('radio', 'visibility', null, get_lang('CourseVisibilityClosed'), COURSE_VISIBILITY_CLOSED);
  154. $form->addGroup($group, '', array(get_lang("CourseAccess"), get_lang("CourseAccessConfigTip")), '');
  155. $url = api_get_path(WEB_CODE_PATH)."auth/inscription.php?c=$course_code&e=1";
  156. $url = Display::url($url, $url);
  157. $form->addElement('label', get_lang('DirectLink'), sprintf(get_lang('CourseSettingsRegisterDirectLink'), $url));
  158. $group = array();
  159. $group[]=$form->createElement('radio', 'subscribe', get_lang('Subscription'), get_lang('Allowed'), 1);
  160. $group[]=$form->createElement('radio', 'subscribe', null, get_lang('Denied'), 0);
  161. $form->addGroup($group, '', array(get_lang("Subscription")), '');
  162. $group = array();
  163. $group[]=$form->createElement('radio', 'unsubscribe', get_lang('Unsubscription'), get_lang('AllowedToUnsubscribe'), 1);
  164. $group[]=$form->createElement('radio', 'unsubscribe', null, get_lang('NotAllowedToUnsubscribe'), 0);
  165. $form->addGroup($group, '', array(get_lang("Unsubscription")), '');
  166. $form->add_textfield('course_registration_password', get_lang('CourseRegistrationPassword'), false, array('size' => '60'));
  167. $form->addElement('checkbox', 'activate_legal', array(null, get_lang('ShowALegalNoticeWhenEnteringTheCourse')), get_lang('ActivateLegal'));
  168. $form->addElement('textarea', 'legal', get_lang('CourseLegalAgreement'), array('class'=>'span6', 'rows' => 8));
  169. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  170. $form->addElement('html', '</div></div>');
  171. // EMAIL NOTIFICATIONS
  172. $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>');
  173. $group = array();
  174. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', get_lang('NewUserEmailAlert'), get_lang('NewUserEmailAlertEnable'), 1);
  175. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', null, get_lang('NewUserEmailAlertToTeacharAndTutor'), 2);
  176. $group[]=$form->createElement('radio', 'email_alert_to_teacher_on_new_user_in_course', null, get_lang('NewUserEmailAlertDisable'), 0);
  177. $form->addGroup($group, '', array(get_lang("NewUserEmailAlert")), '');
  178. $group = array();
  179. $group[]=$form->createElement('radio', 'email_alert_students_on_new_homework', get_lang('NewHomeworkEmailAlert'), get_lang('NewHomeworkEmailAlertEnable'), 1);
  180. $group[]=$form->createElement('radio', 'email_alert_students_on_new_homework', null, get_lang('NewHomeworkEmailAlertDisable'), 0);
  181. $form->addGroup($group, '', array(get_lang("NewHomeworkEmailAlert")), '');
  182. $group = array();
  183. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_doc', get_lang('WorkEmailAlert'), get_lang('WorkEmailAlertActivate'), 1);
  184. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_doc', null, get_lang('WorkEmailAlertDeactivate'), 0);
  185. $form->addGroup($group, '', array(get_lang("WorkEmailAlert")), '');
  186. $group = array();
  187. $group[]=$form->createElement('radio', 'email_alert_on_new_doc_dropbox', get_lang('DropboxEmailAlert'), get_lang('DropboxEmailAlertActivate'), 1);
  188. $group[]=$form->createElement('radio', 'email_alert_on_new_doc_dropbox', null, get_lang('DropboxEmailAlertDeactivate'), 0);
  189. $form->addGroup($group, '', array(get_lang("DropboxEmailAlert")), '');
  190. $group = array();
  191. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_quiz', get_lang('QuizEmailAlert'), get_lang('QuizEmailAlertActivate'), 1);
  192. $group[]=$form->createElement('radio', 'email_alert_manager_on_new_quiz', null, get_lang('QuizEmailAlertDeactivate'), 0);
  193. $form->addGroup($group, '', array(get_lang("QuizEmailAlert")), '');
  194. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  195. $form->addElement('html', '</div></div>');
  196. // USER RIGHTS
  197. $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>');
  198. $group = array();
  199. $group[]=$form->createElement('radio', 'allow_user_edit_agenda', get_lang('AllowUserEditAgenda'), get_lang('AllowUserEditAgendaActivate'), 1);
  200. $group[]=$form->createElement('radio', 'allow_user_edit_agenda', null, get_lang('AllowUserEditAgendaDeactivate'), 0);
  201. $form->addGroup($group, '', array(get_lang("AllowUserEditAgenda")), '');
  202. $group = array();
  203. $group[]=$form->createElement('radio', 'allow_user_edit_announcement', get_lang('AllowUserEditAnnouncement'), get_lang('AllowUserEditAnnouncementActivate'), 1);
  204. $group[]=$form->createElement('radio', 'allow_user_edit_announcement', null, get_lang('AllowUserEditAnnouncementDeactivate'), 0);
  205. $form->addGroup($group, '', array(get_lang("AllowUserEditAnnouncement")), '');
  206. $group = array();
  207. $group[]=$form->createElement('radio', 'allow_user_image_forum', get_lang('AllowUserImageForum'), get_lang('AllowUserImageForumActivate'), 1);
  208. $group[]=$form->createElement('radio', 'allow_user_image_forum', null, get_lang('AllowUserImageForumDeactivate'), 0);
  209. $form->addGroup($group, '', array(get_lang("AllowUserImageForum")), '');
  210. $group = array();
  211. $group[]=$form->createElement('radio', 'allow_user_view_user_list', get_lang('AllowUserViewUserList'), get_lang('AllowUserViewUserListActivate'), 1);
  212. $group[]=$form->createElement('radio', 'allow_user_view_user_list', null, get_lang('AllowUserViewUserListDeactivate'), 0);
  213. $form->addGroup($group, '', array(get_lang("AllowUserViewUserList")), '');
  214. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  215. $form->addElement('html', '</div></div>');
  216. // CHAT SETTINGS
  217. $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>');
  218. $group = array();
  219. $group[]=$form->createElement('radio', 'allow_open_chat_window', get_lang('AllowOpenchatWindow'), get_lang('AllowOpenChatWindowActivate'), 1);
  220. $group[]=$form->createElement('radio', 'allow_open_chat_window', null, get_lang('AllowOpenChatWindowDeactivate'), 0);
  221. $form->addGroup($group, '', array(get_lang("AllowOpenchatWindow")), '');
  222. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  223. $form->addElement('html', '</div></div>');
  224. // LEARNING PATH
  225. $form->addElement('html', '<div><h3>'.Display::return_icon('scorms.png', get_lang('ConfigLearnpath'),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('ConfigLearnpath')).'</h3><div>');
  226. //Auto launch LP
  227. $group = array();
  228. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', get_lang('LPAutoLaunch'), get_lang('RedirectToALearningPath'), 1);
  229. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', get_lang('LPAutoLaunch'), get_lang('RedirectToTheLearningPathList'), 2);
  230. $group[]=$form->createElement('radio', 'enable_lp_auto_launch', null, get_lang('Deactivate'), 0);
  231. $form->addGroup($group, '', array(get_lang("LPAutoLaunch")), '');
  232. if (api_get_setting('allow_course_theme') == 'true') {
  233. // Allow theme into Learning path
  234. $group = array();
  235. $group[]=$form->createElement('radio', 'allow_learning_path_theme', get_lang('AllowLearningPathTheme'), get_lang('AllowLearningPathThemeAllow'), 1);
  236. $group[]=$form->createElement('radio', 'allow_learning_path_theme', null, get_lang('AllowLearningPathThemeDisallow'), 0);
  237. $form->addGroup($group, '', array(get_lang("AllowLearningPathTheme")), '');
  238. }
  239. if (is_settings_editable()) {
  240. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  241. } else {
  242. // Is it allowed to edit the course settings?
  243. if (!is_settings_editable()) {
  244. $disabled_output = "disabled";
  245. }
  246. $form->freeze();
  247. }
  248. $form->addElement('html', '</div></div>');
  249. // THEMATIC ADVANCE SETTINGS
  250. $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>');
  251. $group = array();
  252. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', get_lang('InfoAboutAdvanceInsideHomeCourse'), get_lang('DisplayAboutLastDoneAdvance'), 1);
  253. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DisplayAboutNextAdvanceNotDone'), 2);
  254. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DisplayAboutNextAdvanceNotDoneAndLastDoneAdvance'), 3);
  255. $group[]=$form->createElement('radio', 'display_info_advance_inside_homecourse', null, get_lang('DoNotDisplayAnyAdvance'), 0);
  256. $form->addGroup($group, '', array(get_lang("InfoAboutAdvanceInsideHomeCourse")), '');
  257. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  258. $form->addElement('html', '</div></div>');
  259. // Certificate settings
  260. if (api_get_setting('allow_public_certificates')=='true') {
  261. $form->addElement('html', '<div><h3>'.Display::return_icon('certificate.png', Security::remove_XSS(get_lang('Certificates')),'',ICON_SIZE_SMALL).' '.Security::remove_XSS(get_lang('Certificates')).'</h3><div>');
  262. $group = array();
  263. $group[]=$form->createElement('radio', 'allow_public_certificates', get_lang('AllowPublicCertificates'), get_lang('Yes'), 1);
  264. $group[]=$form->createElement('radio', 'allow_public_certificates', null, get_lang('No'), 0);
  265. $form->addGroup($group, '', array(get_lang("AllowPublicCertificates")), '');
  266. $form->addElement('style_submit_button', null, get_lang('SaveSettings'), 'class="save"');
  267. $form->addElement('html', '</div></div>');
  268. }
  269. // Plugin course settings
  270. $app_plugin = new AppPlugin();
  271. $app_plugin->add_course_settings_form($form);
  272. // Get all the course information
  273. $all_course_information = CourseManager::get_course_information($_course['sysCode']);
  274. // Set the default values of the form
  275. $values = array();
  276. $values['title'] = $_course['name'];
  277. //$values['visual_code'] = $_course['official_code'];
  278. $values['category_code'] = $_course['categoryCode'];
  279. //$values['tutor_name'] = $_course['titular'];
  280. $values['course_language'] = $_course['language'];
  281. $values['department_name'] = $_course['extLink']['name'];
  282. $values['department_url'] = $_course['extLink']['url'];
  283. $values['visibility'] = $_course['visibility'];
  284. $values['subscribe'] = $course_access_settings['subscribe'];
  285. $values['unsubscribe'] = $course_access_settings['unsubscribe'];
  286. $values['course_registration_password'] = $all_course_information['registration_code'];
  287. $values['legal'] = $all_course_information['legal'];
  288. $values['activate_legal'] = $all_course_information['activate_legal'];
  289. // Get send_mail_setting (auth)from table
  290. $values['email_alert_to_teacher_on_new_user_in_course']= api_get_course_setting('email_alert_to_teacher_on_new_user_in_course');
  291. // Get send_mail_setting (work)from table
  292. $values['email_alert_manager_on_new_doc'] = api_get_course_setting('email_alert_manager_on_new_doc');
  293. // Get send_mail_setting (dropbox) from table
  294. $values['email_alert_on_new_doc_dropbox'] = api_get_course_setting('email_alert_on_new_doc_dropbox');
  295. // Get send_mail_setting (work)from table
  296. $values['email_alert_manager_on_new_quiz'] = api_get_course_setting('email_alert_manager_on_new_quiz');
  297. // Get allow_user_edit_agenda from table
  298. $values['allow_user_edit_agenda'] = api_get_course_setting('allow_user_edit_agenda');
  299. // Get allow_user_edit_announcement from table
  300. $values['allow_user_edit_announcement'] = api_get_course_setting('allow_user_edit_announcement');
  301. // Get allow_user_image_forum from table
  302. $values['allow_user_image_forum'] = api_get_course_setting('allow_user_image_forum');
  303. // Get allow_open_chat_window from table
  304. $values['allow_open_chat_window'] = api_get_course_setting('allow_open_chat_window');
  305. // Get course_theme from table
  306. $values['course_theme'] = api_get_course_setting('course_theme');
  307. // Get allow_learning_path_theme from table
  308. $values['allow_learning_path_theme'] = api_get_course_setting('allow_learning_path_theme');
  309. //Get allow show user list
  310. $values['allow_user_view_user_list'] = api_get_course_setting('allow_user_view_user_list');
  311. //Get allow show user list
  312. $values['display_info_advance_inside_homecourse'] = api_get_course_setting('display_info_advance_inside_homecourse');
  313. $values['email_alert_students_on_new_homework'] = api_get_course_setting('email_alert_students_on_new_homework');
  314. $values['enable_lp_auto_launch'] = api_get_course_setting('enable_lp_auto_launch');
  315. $values['pdf_export_watermark_text'] = api_get_course_setting('pdf_export_watermark_text');
  316. $values['allow_public_certificates'] = api_get_course_setting('allow_public_certificates');
  317. $app_plugin->set_course_settings_defaults($values);
  318. $form->setDefaults($values);
  319. // Validate form
  320. if ($form->validate() && is_settings_editable()) {
  321. $update_values = $form->exportValues();
  322. $pdf_export_watermark_path = $_FILES['pdf_export_watermark_path'];
  323. if (!empty($pdf_export_watermark_path['name'])) {
  324. $pdf_export_watermark_path_result = PDF::upload_watermark($pdf_export_watermark_path['name'], $pdf_export_watermark_path['tmp_name'], $course_code);
  325. unset($update_values['pdf_export_watermark_path']);
  326. }
  327. //Variables that will be saved in the TABLE_MAIN_COURSE table
  328. $update_in_course_table = array('title', 'course_language','category_code','department_name', 'department_url','visibility',
  329. 'subscribe', 'unsubscribe','tutor_name','course_registration_password', 'legal', 'activate_legal');
  330. foreach ($update_values as $index =>$value) {
  331. $update_values[$index] = Database::escape_string($value);
  332. }
  333. unset($value);
  334. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  335. $sql = "UPDATE $table_course SET
  336. title = '".$update_values['title']."',
  337. course_language = '".$update_values['course_language']."',
  338. category_code = '".$update_values['category_code']."',
  339. department_name = '".$update_values['department_name']."',
  340. department_url = '".$update_values['department_url']."',
  341. visibility = '".$update_values['visibility']."',
  342. subscribe = '".$update_values['subscribe']."',
  343. unsubscribe = '".$update_values['unsubscribe']."',
  344. legal = '".$update_values['legal']."',
  345. activate_legal = '".$update_values['activate_legal']."',
  346. registration_code = '".$update_values['course_registration_password']."'
  347. WHERE code = '".$course_code."'";
  348. Database::query($sql);
  349. // Update course_settings table - this assumes those records exist, otherwise triggers an error
  350. $table_course_setting = Database::get_course_table(TABLE_COURSE_SETTING);
  351. foreach ($update_values as $key =>$value) {
  352. //We do not update variables that were already saved in the TABLE_MAIN_COURSE table
  353. if (!in_array($key, $update_in_course_table)) {
  354. Database::update($table_course_setting, array('value' => $update_values[$key]), array('variable = ? AND c_id = ?' => array($key, api_get_course_int_id())));
  355. }
  356. }
  357. $app_plugin->save_course_settings($update_values);
  358. $cidReset = true;
  359. $cidReq = $course_code;
  360. require '../inc/local.inc.php';
  361. header('Location: infocours.php?action=show_message&cidReq='.$course_code);
  362. exit;
  363. }
  364. /* Header */
  365. Display :: display_header($nameTools, MODULE_HELP_NAME);
  366. if ($show_delete_watermark_text_message) {
  367. Display :: display_normal_message(get_lang('FileDeleted'));
  368. }
  369. //api_display_tool_title($nameTools);
  370. if (isset($_GET['action']) && $_GET['action'] == 'show_message') {
  371. Display :: display_normal_message(get_lang('ModifDone'));
  372. }
  373. echo '<script>
  374. $(function() {
  375. $("#course_settings").accordion({
  376. autoHeight: false,
  377. header: "div > h3"
  378. });
  379. });
  380. </script>';
  381. // Display the form
  382. echo '<div id="course_settings">';
  383. $form->display();
  384. echo '</div>';
  385. Display::display_footer();