course_edit.php 17 KB

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