course_edit.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. $cidReset = true;
  7. require_once '../inc/global.inc.php';
  8. $this_section = SECTION_PLATFORM_ADMIN;
  9. api_protect_admin_script();
  10. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  11. $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  12. $courseId = isset($_GET['id']) ? $_GET['id'] : null;
  13. if (empty($courseId)) {
  14. api_not_allowed(true);
  15. }
  16. $courseInfo = api_get_course_info_by_id($courseId);
  17. if (empty($courseInfo)) {
  18. api_not_allowed(true);
  19. }
  20. $tool_name = get_lang('ModifyCourseInfo');
  21. $interbreadcrumb[] = array("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  22. $interbreadcrumb[] = array("url" => "course_list.php", "name" => get_lang('CourseList'));
  23. // Get all course categories
  24. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  25. $course_code = $courseInfo['code'];
  26. $courseId = $courseInfo['real_id'];
  27. // Get course teachers
  28. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  29. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  30. $sql = "SELECT user.user_id,lastname,firstname
  31. FROM $table_user as user,$table_course_user as course_user
  32. WHERE
  33. course_user.status='1' AND
  34. course_user.user_id=user.user_id AND
  35. course_user.c_id ='" . $courseId . "'" .
  36. $order_clause;
  37. $res = Database::query($sql);
  38. $course_teachers = array();
  39. while ($obj = Database::fetch_object($res)) {
  40. $course_teachers[] = $obj->user_id;
  41. }
  42. // Get all possible teachers without the course teachers
  43. if (api_is_multiple_url_enabled()) {
  44. $access_url_rel_user_table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  45. $sql = "SELECT u.user_id,lastname,firstname
  46. FROM $table_user as u
  47. INNER JOIN $access_url_rel_user_table url_rel_user
  48. ON (u.user_id=url_rel_user.user_id)
  49. WHERE
  50. url_rel_user.access_url_id=" . api_get_current_access_url_id() . " AND
  51. status=1" . $order_clause;
  52. } else {
  53. $sql = "SELECT user_id, lastname, firstname
  54. FROM $table_user WHERE status='1'" . $order_clause;
  55. }
  56. $courseInfo['tutor_name'] = null;
  57. $res = Database::query($sql);
  58. $teachers = array();
  59. $allTeachers = array();
  60. $platform_teachers[0] = '-- ' . get_lang('NoManager') . ' --';
  61. while ($obj = Database::fetch_object($res)) {
  62. $allTeachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  63. if (!array_key_exists($obj->user_id, $course_teachers)) {
  64. $teachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  65. }
  66. if (isset($course_teachers[$obj->user_id]) &&
  67. $courseInfo['tutor_name'] == $course_teachers[$obj->user_id]
  68. ) {
  69. $courseInfo['tutor_name'] = $obj->user_id;
  70. }
  71. // We add in the array platform teachers
  72. $platform_teachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  73. }
  74. // Case where there is no teacher in the course
  75. if (count($course_teachers) == 0) {
  76. $sql = 'SELECT tutor_name FROM ' . $course_table . ' WHERE code="' . $course_code . '"';
  77. $res = Database::query($sql);
  78. $tutor_name = Database::result($res, 0, 0);
  79. $courseInfo['tutor_name'] = array_search($tutor_name, $platform_teachers);
  80. }
  81. // Build the form
  82. $form = new FormValidator('update_course', 'post', api_get_self().'?id='.$courseId);
  83. $form->addElement('header', get_lang('Course') . ' #' . $courseInfo['real_id'] . ' ' . $course_code);
  84. $form->addElement('hidden', 'code', $course_code);
  85. //title
  86. $form->addText('title', get_lang('Title'), true, array('class' => 'span6'));
  87. $form->applyFilter('title', 'html_filter');
  88. $form->applyFilter('title', 'trim');
  89. // Code
  90. $element = $form->addElement('text', 'real_code', array(get_lang('CourseCode'), get_lang('ThisValueCantBeChanged')));
  91. $element->freeze();
  92. // Visual code
  93. $form->addText('visual_code', array(get_lang('VisualCode'), get_lang('OnlyLettersAndNumbers'), get_lang('ThisValueIsUsedInTheCourseURL')), true, array('class' => 'span4'));
  94. $form->applyFilter('visual_code', 'strtoupper');
  95. $form->applyFilter('visual_code', 'html_filter');
  96. $form->addElement('advmultiselect', 'course_teachers', get_lang('CourseTeachers'), $allTeachers);
  97. $courseInfo['course_teachers'] = $course_teachers;
  98. if (array_key_exists('add_teachers_to_sessions_courses', $courseInfo)) {
  99. $form->addElement('checkbox', 'add_teachers_to_sessions_courses', null, get_lang('TeachersWillBeAddedAsCoachInAllCourseSessions'));
  100. }
  101. $coursesInSession = SessionManager::get_session_by_course($courseInfo['real_id']);
  102. if (!empty($coursesInSession)) {
  103. foreach ($coursesInSession as $session) {
  104. $sessionId = $session['id'];
  105. $coaches = SessionManager::getCoachesByCourseSession($sessionId, $courseInfo['real_id']);
  106. $teachers = $allTeachers;
  107. $sessionTeachers = array();
  108. foreach ($coaches as $coachId) {
  109. $userInfo = api_get_user_info($coachId);
  110. $sessionTeachers[] = $coachId;
  111. if (isset($teachers[$coachId])) {
  112. unset($teachers[$coachId]);
  113. }
  114. }
  115. $groupName = 'session_coaches[' . $sessionId . ']';
  116. $platformTeacherId = 'platform_teachers_by_session_' . $sessionId;
  117. $coachId = 'coaches_by_session_' . $sessionId;
  118. $platformTeacherName = 'platform_teachers_by_session';
  119. $coachName = 'coaches_by_session';
  120. $sessionUrl = api_get_path(WEB_CODE_PATH) . 'admin/resume_session.php?id_session=' . $sessionId;
  121. $form->addElement(
  122. 'advmultiselect',
  123. $groupName,
  124. Display::url(
  125. $session['name'], $sessionUrl, array('target' => '_blank')
  126. ) . ' - ' . get_lang('Coaches'),
  127. $allTeachers
  128. );
  129. $courseInfo[$groupName] = $sessionTeachers;
  130. }
  131. }
  132. // Category code
  133. $url = api_get_path(WEB_AJAX_PATH) . 'course.ajax.php?a=search_category';
  134. $categoryList = array();
  135. if (!empty($course['category_code'])) {
  136. $data = getCategory($course['category_code']);
  137. $categoryList[] = array('id' => $data['code'], 'text' => $data['name']);
  138. }
  139. $form->addElement('select_ajax', 'category_code', get_lang('CourseFaculty'), null, array('url' => $url, 'defaults' => $categoryList));
  140. $form->addText('department_name', get_lang('CourseDepartment'), false, array('size' => '60'));
  141. $form->applyFilter('department_name', 'html_filter');
  142. $form->applyFilter('department_name', 'trim');
  143. $form->addText('department_url', get_lang('CourseDepartmentURL'), false, array('size' => '60'));
  144. $form->applyFilter('department_url', 'html_filter');
  145. $form->applyFilter('department_url', 'trim');
  146. $form->addElement('select_language', 'course_language', get_lang('CourseLanguage'));
  147. $form->applyFilter('select_language', 'html_filter');
  148. $group = array();
  149. $group[]= $form->createElement('radio', 'visibility', get_lang("CourseAccess"), get_lang('OpenToTheWorld'), COURSE_VISIBILITY_OPEN_WORLD);
  150. $group[]= $form->createElement('radio', 'visibility', null, get_lang('OpenToThePlatform'), COURSE_VISIBILITY_OPEN_PLATFORM);
  151. $group[]= $form->createElement('radio', 'visibility', null, get_lang('Private'), COURSE_VISIBILITY_REGISTERED);
  152. $group[]= $form->createElement('radio', 'visibility', null, get_lang('CourseVisibilityClosed'), COURSE_VISIBILITY_CLOSED);
  153. $group[]= $form->createElement('radio', 'visibility', null, get_lang('CourseVisibilityHidden'), COURSE_VISIBILITY_HIDDEN);
  154. $form->addGroup($group, '', get_lang('CourseAccess'), '<br />');
  155. $group = array();
  156. $group[] = $form->createElement('radio', 'subscribe', get_lang('Subscription'), get_lang('Allowed'), 1);
  157. $group[] = $form->createElement('radio', 'subscribe', null, get_lang('Denied'), 0);
  158. $form->addGroup($group, '', get_lang('Subscription'), '<br />');
  159. $group = array();
  160. $group[] = $form->createElement('radio', 'unsubscribe', get_lang('Unsubscription'), get_lang('AllowedToUnsubscribe'), 1);
  161. $group[] = $form->createElement('radio', 'unsubscribe', null, get_lang('NotAllowedToUnsubscribe'), 0);
  162. $form->addGroup($group, '', get_lang('Unsubscription'), '<br />');
  163. $form->addElement('text', 'disk_quota', array(get_lang('CourseQuota'), null, get_lang('MB')));
  164. $form->addRule('disk_quota', get_lang('ThisFieldIsRequired'), 'required');
  165. $form->addRule('disk_quota', get_lang('ThisFieldShouldBeNumeric'), 'numeric');
  166. $specialCourseField = new ExtraField('course');
  167. $specialCourseFieldInfo = $specialCourseField->get_handler_field_info_by_field_variable('special_course');
  168. if (!empty($specialCourseFieldInfo)) {
  169. $specialCourseValue = new ExtraFieldValue('course');
  170. $specialCourseValueInfo = $specialCourseValue->get_values_by_handler_and_field_variable(
  171. $course_code,
  172. 'special_course'
  173. );
  174. $specialCourseAttributes = array();
  175. if (!empty($specialCourseValueInfo) && $specialCourseValueInfo['value'] == 1) {
  176. $specialCourseAttributes['checked'] = '';
  177. }
  178. $form->addElement(
  179. 'checkbox',
  180. 'extra_special_course',
  181. array(
  182. null,
  183. get_lang('AllUsersAreAutomaticallyRegistered')
  184. ),
  185. get_lang('SpecialCourse'),
  186. $specialCourseAttributes
  187. );
  188. }
  189. //Extra fields
  190. $extra_field = new ExtraField('course');
  191. $extra = $extra_field->addElements($form, $courseId, ['special_course']);
  192. $htmlHeadXtra[] = '
  193. <script>
  194. $(function() {
  195. ' . $extra['jquery_ready_content'] . '
  196. });
  197. </script>';
  198. $form->addButton('submit', get_lang('ModifyCourseInfo'), 'pencil', 'primary');
  199. // Set some default values
  200. $courseInfo['disk_quota'] = round(DocumentManager::get_course_quota($courseInfo['code']) / 1024 / 1024, 1);
  201. $courseInfo['real_code'] = $courseInfo['code'];
  202. $courseInfo['add_teachers_to_sessions_courses'] = isset($courseInfo['add_teachers_to_sessions_courses']) ? $courseInfo['add_teachers_to_sessions_courses'] : 0;
  203. $form->setDefaults($courseInfo);
  204. // Validate form
  205. if ($form->validate()) {
  206. $course = $form->getSubmitValues();
  207. $visibility = $course['visibility'];
  208. global $_configuration;
  209. $urlId = api_get_current_access_url_id();
  210. if (isset($_configuration[$urlId]) &&
  211. isset($_configuration[$urlId]['hosting_limit_active_courses']) &&
  212. $_configuration[$urlId]['hosting_limit_active_courses'] > 0
  213. ) {
  214. // Check if
  215. if ($courseInfo['visibility'] == COURSE_VISIBILITY_HIDDEN &&
  216. $visibility != $courseInfo['visibility']
  217. ) {
  218. $num = CourseManager::countActiveCourses($urlId);
  219. if ($num >= $_configuration[$urlId]['hosting_limit_active_courses']) {
  220. api_warn_hosting_contact('hosting_limit_active_courses');
  221. api_set_failure(get_lang('PortalActiveCoursesLimitReached'));
  222. header('Location: course_list.php?action=show_msg&warn=' . urlencode(get_lang('PortalActiveCoursesLimitReached')));
  223. exit;
  224. }
  225. }
  226. }
  227. $visual_code = $course['visual_code'];
  228. $visual_code = CourseManager::generate_course_code($visual_code);
  229. // Check if the visual code is already used by *another* course
  230. $visual_code_is_used = false;
  231. $warn = get_lang('TheFollowingCoursesAlreadyUseThisVisualCode');
  232. if (!empty($visual_code)) {
  233. $list = CourseManager::get_courses_info_from_visual_code($visual_code);
  234. foreach ($list as $course_temp) {
  235. if ($course_temp['code'] != $course_code) {
  236. $visual_code_is_used = true;
  237. $warn .= ' ' . $course_temp['title'] . ' (' . $course_temp['code'] . '),';
  238. }
  239. }
  240. $warn = substr($warn, 0, -1);
  241. }
  242. $teachers = $course['course_teachers'];
  243. $title = $course['title'];
  244. $category_code = $course['category_code'];
  245. $department_name = $course['department_name'];
  246. $department_url = $course['department_url'];
  247. $course_language = $course['course_language'];
  248. $course['disk_quota'] = $course['disk_quota'] * 1024 * 1024;
  249. $disk_quota = $course['disk_quota'];
  250. $subscribe = $course['subscribe'];
  251. $unsubscribe = $course['unsubscribe'];
  252. $course['course_code'] = $course_code;
  253. if (!stristr($department_url, 'http://')) {
  254. $department_url = 'http://' . $department_url;
  255. }
  256. $sql = "UPDATE $course_table SET
  257. course_language='" . Database::escape_string($course_language) . "',
  258. title='" . Database::escape_string($title) . "',
  259. category_code='" . Database::escape_string($category_code) . "',
  260. visual_code='" . Database::escape_string($visual_code) . "',
  261. department_name='" . Database::escape_string($department_name) . "',
  262. department_url='" . Database::escape_string($department_url) . "',
  263. disk_quota='" . Database::escape_string($disk_quota) . "',
  264. visibility = '" . Database::escape_string($visibility) . "',
  265. subscribe = '" . Database::escape_string($subscribe) . "',
  266. unsubscribe='" . Database::escape_string($unsubscribe) . "'
  267. WHERE id = $courseId ";
  268. Database::query($sql);
  269. // update the extra fields
  270. $courseFieldValue = new ExtraFieldValue('course');
  271. $courseFieldValue->saveFieldValues($course);
  272. $addTeacherToSessionCourses = isset($course['add_teachers_to_sessions_courses']) && !empty($course['add_teachers_to_sessions_courses']) ? 1 : 0;
  273. // Updating teachers
  274. if ($addTeacherToSessionCourses) {
  275. // Updating session coaches
  276. $sessionCoaches = $course['session_coaches'];
  277. if (!empty($sessionCoaches)) {
  278. foreach ($sessionCoaches as $sessionId => $teacherInfo) {
  279. $coachesToSubscribe = $teacherInfo['coaches_by_session'];
  280. SessionManager::updateCoaches($sessionId, $courseId, $coachesToSubscribe, true);
  281. }
  282. }
  283. CourseManager::updateTeachers($courseId, $teachers, false, true, false);
  284. } else {
  285. // Normal behaviour
  286. CourseManager::updateTeachers($courseId, $teachers, true, false);
  287. // Updating session coaches
  288. $sessionCoaches = $course['session_coaches'];
  289. if (!empty($sessionCoaches)) {
  290. foreach ($sessionCoaches as $sessionId => $coachesToSubscribe) {
  291. //$coachesToSubscribe = isset($teacherInfo['coaches_by_session']) ? $teacherInfo['coaches_by_session'] : null;
  292. if (!empty($coachesToSubscribe)) {
  293. SessionManager::updateCoaches(
  294. $sessionId,
  295. $courseId,
  296. $coachesToSubscribe,
  297. true
  298. );
  299. }
  300. }
  301. }
  302. }
  303. // No need to register me as a teacher.
  304. /*
  305. $sql = "INSERT IGNORE INTO " . $course_user_table . " SET
  306. c_id = " . $courseInfo['real_id'] . ",
  307. user_id = '" . $tutor_id . "',
  308. status = '1',
  309. is_tutor ='0',
  310. sort = '0',
  311. user_course_cat='0'";
  312. Database::query($sql);
  313. */
  314. if (array_key_exists('add_teachers_to_sessions_courses', $courseInfo)) {
  315. $sql = "UPDATE $course_table SET
  316. add_teachers_to_sessions_courses = '$addTeacherToSessionCourses'
  317. WHERE id = " . $courseInfo['real_id'];
  318. Database::query($sql);
  319. }
  320. $course_id = $courseInfo['real_id'];
  321. /* $forum_config_table = Database::get_course_table(TOOL_FORUM_CONFIG_TABLE);
  322. $sql = "UPDATE ".$forum_config_table." SET default_lang='".Database::escape_string($course_language)."' WHERE c_id = $course_id "; */
  323. Display::addFlash(Display::return_message(get_lang('ItemUpdated')));
  324. if ($visual_code_is_used) {
  325. header('Location: course_list.php?action=show_msg&warn=' . urlencode($warn));
  326. } else {
  327. header('Location: course_list.php');
  328. }
  329. exit;
  330. }
  331. Display::display_header($tool_name);
  332. echo '<div class="actions">';
  333. echo Display::url(Display::return_icon('back.png', get_lang('Back')), api_get_path(WEB_CODE_PATH).'admin/course_list.php');
  334. echo Display::url(Display::return_icon('course_home.png', get_lang('CourseHome')), $courseInfo['course_public_url'], array('target' => '_blank'));
  335. echo '</div>';
  336. echo "<script>
  337. function moveItem(origin , destination) {
  338. for (var i = 0 ; i<origin.options.length ; i++) {
  339. if (origin.options[i].selected) {
  340. destination.options[destination.length] = new Option(origin.options[i].text,origin.options[i].value);
  341. origin.options[i]=null;
  342. i = i-1;
  343. }
  344. }
  345. destination.selectedIndex = -1;
  346. sortOptions(destination.options);
  347. }
  348. function sortOptions(options) {
  349. newOptions = new Array();
  350. for (i = 0 ; i<options.length ; i++) {
  351. newOptions[i] = options[i];
  352. }
  353. newOptions = newOptions.sort(mysort);
  354. options.length = 0;
  355. for (i = 0 ; i < newOptions.length ; i++) {
  356. options[i] = newOptions[i];
  357. }
  358. }
  359. function mysort(a, b) {
  360. if (a.text.toLowerCase() > b.text.toLowerCase()) {
  361. return 1;
  362. }
  363. if (a.text.toLowerCase() < b.text.toLowerCase()) {
  364. return -1;
  365. }
  366. return 0;
  367. }
  368. function valide() {
  369. // Checking all multiple
  370. $('select').filter(function() {
  371. if ($(this).attr('multiple')) {
  372. $(this).find('option').each(function() {
  373. $(this).attr('selected', true);
  374. });
  375. }
  376. });
  377. //document.update_course.submit();
  378. }
  379. </script>";
  380. // Display the form
  381. $form->display();
  382. Display :: display_footer();