course_edit.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. /* Initialization section */
  7. // name of the language file that needs to be included
  8. $language_file = 'admin';
  9. $cidReset = true;
  10. require_once '../inc/global.inc.php';
  11. $this_section = SECTION_PLATFORM_ADMIN;
  12. api_protect_admin_script();
  13. require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
  14. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  15. $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  16. $course_code = isset($_GET['course_code']) ? $_GET['course_code'] : $_POST['code'];
  17. $noPHP_SELF = true;
  18. $tool_name = get_lang('ModifyCourseInfo');
  19. $interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  20. $interbreadcrumb[] = array ("url" => "course_list.php", "name" => get_lang('CourseList'));
  21. define('USER_FIELD_TYPE_CHECKBOX', 10);
  22. /* Libraries */
  23. /* MAIN CODE */
  24. // Get all course categories
  25. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  26. //Get the course infos
  27. $sql = "SELECT * FROM $course_table WHERE code='".Database::escape_string($course_code)."'";
  28. $result = Database::query($sql);
  29. if (Database::num_rows($result) != 1) {
  30. header('Location: course_list.php');
  31. exit ();
  32. }
  33. $course = Database::fetch_array($result,'ASSOC');
  34. // Get course teachers
  35. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  36. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  37. $sql = "SELECT user.user_id,lastname,firstname FROM $table_user as user,$table_course_user as course_user WHERE course_user.status='1' AND course_user.user_id=user.user_id AND course_user.course_code='".$course_code."'".$order_clause;
  38. $res = Database::query($sql);
  39. $course_teachers = array();
  40. while ($obj = Database::fetch_object($res)) {
  41. $course_teachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  42. }
  43. // Get all possible teachers without the course teachers
  44. if ($_configuration['multiple_access_urls']) {
  45. $access_url_rel_user_table= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  46. $sql = "SELECT u.user_id,lastname,firstname 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) WHERE url_rel_user.access_url_id=".api_get_current_access_url_id()." AND status=1".$order_clause;
  49. } else {
  50. $sql = "SELECT user_id,lastname,firstname FROM $table_user WHERE status='1'".$order_clause;
  51. }
  52. $res = Database::query($sql);
  53. $teachers = array();
  54. $platform_teachers[0] = '-- '.get_lang('NoManager').' --';
  55. while ($obj = Database::fetch_object($res)) {
  56. if (!array_key_exists($obj->user_id,$course_teachers)) {
  57. $teachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  58. }
  59. if ($course['tutor_name']==$course_teachers[$obj->user_id]) {
  60. $course['tutor_name']=$obj->user_id;
  61. }
  62. //We add in the array platform teachers
  63. $platform_teachers[$obj->user_id] = api_get_person_name($obj->firstname, $obj->lastname);
  64. }
  65. //Case where there is no teacher in the course
  66. if (count($course_teachers)==0) {
  67. $sql='SELECT tutor_name FROM '.$course_table.' WHERE code="'.$course_code.'"';
  68. $res = Database::query($sql);
  69. $tutor_name=Database::result($res,0,0);
  70. $course['tutor_name']=array_search($tutor_name,$platform_teachers);
  71. }
  72. // Build the form
  73. $form = new FormValidator('update_course');
  74. $form->addElement('hidden','code',$course_code);
  75. //title
  76. $form->add_textfield( 'title', get_lang('Title'),true, array ('size' => '60'));
  77. $form->applyFilter('title','html_filter');
  78. $form->applyFilter('title','trim');
  79. // code
  80. $form->add_textfield('visual_code', array(get_lang('CourseCode'), get_lang('OnlyLettersAndNumbers')));
  81. $form->applyFilter('visual_code','strtoupper');
  82. $form->applyFilter('visual_code','html_filter');
  83. //$form->addElement('text', tutor_name', get_lang('CourseTitular'));
  84. //$form->addElement('select', 'tutor_name', get_lang('CourseTitular'), $platform_teachers, array('style'=>'width:350px','id'=>'tutor_name_id', 'class'=>'chzn-select'));
  85. //$form->applyFilter('tutor_name','html_filter');
  86. //$form->addElement('select', 'course_teachers', get_lang('CourseTeachers'), $teachers, 'multiple=multiple size="4" style="width: 150px;"');
  87. $group=array();
  88. $group[] = FormValidator::createElement('select', 'platform_teachers', '', $teachers, ' id="platform_teachers" multiple=multiple size="4" style="width:300px;"');
  89. $group[] = FormValidator::createElement('select', 'course_teachers', '', $course_teachers, ' id="course_teachers" multiple=multiple size="4" style="width:300px;"');
  90. $element_template = <<<EOT
  91. <div class="control-group">
  92. <label>
  93. <!-- BEGIN required --><span class="form_required">*</span> <!-- END required -->{label}
  94. </label>
  95. <div class="controls">
  96. <table cellpadding="0" cellspacing="0">
  97. <tr>
  98. <!-- BEGIN error --><span class="form_error">{error}</span><br /><!-- END error --> <td>{element}</td>
  99. </tr>
  100. </table>
  101. </div>
  102. </div>
  103. EOT;
  104. $renderer = $form->defaultRenderer();
  105. $renderer -> setElementTemplate($element_template, 'group');
  106. $form -> addGroup($group,'group',get_lang('CourseTeachers'),'</td><td width="80" align="center">'.
  107. '<input class="arrowr" style="width:30px;height:30px;padding-right:12px" type="button" onclick="moveItem(document.getElementById(\'platform_teachers\'), document.getElementById(\'course_teachers\'))" ><br><br>' .
  108. '<input class="arrowl" style="width:30px;height:30px;padding-left:13px" type="button" onclick="moveItem(document.getElementById(\'course_teachers\'), document.getElementById(\'platform_teachers\'))" ></td><td>');
  109. $categories_select = $form->addElement('select', 'category_code', get_lang('CourseFaculty'), $categories , array('style'=>'width:350px','id'=>'category_code_id', 'class'=>'chzn-select'));
  110. $categories_select->addOption('-','');
  111. CourseManager::select_and_sort_categories($categories_select);
  112. $form->add_textfield( 'department_name', get_lang('CourseDepartment'), false,array ('size' => '60'));
  113. $form->applyFilter('department_name','html_filter');
  114. $form->applyFilter('department_name','trim');
  115. $form->add_textfield( 'department_url', get_lang('CourseDepartmentURL'),false, array ('size' => '60'));
  116. $form->applyFilter('department_url','html_filter');
  117. $form->applyFilter('department_url','trim');
  118. $form->addElement('select_language', 'course_language', get_lang('CourseLanguage'));
  119. $form->applyFilter('select_language','html_filter');
  120. $group = array();
  121. $group[]= $form->createElement('radio', 'visibility', get_lang("CourseAccess"), get_lang('OpenToTheWorld'), COURSE_VISIBILITY_OPEN_WORLD);
  122. $group[]= $form->createElement('radio', 'visibility', null, get_lang('OpenToThePlatform'), COURSE_VISIBILITY_OPEN_PLATFORM);
  123. $group[]= $form->createElement('radio', 'visibility', null, get_lang('Private'), COURSE_VISIBILITY_REGISTERED);
  124. $group[]= $form->createElement('radio', 'visibility', null, get_lang('CourseVisibilityClosed'), COURSE_VISIBILITY_CLOSED);
  125. $form->addGroup($group,'', get_lang('CourseAccess'), '<br />');
  126. $group = array();
  127. $group[]= $form->createElement('radio', 'subscribe', get_lang('Subscription'), get_lang('Allowed'), 1);
  128. $group[]= $form->createElement('radio', 'subscribe', null, get_lang('Denied'), 0);
  129. $form->addGroup($group,'', get_lang('Subscription'), '<br />');
  130. $group = array();
  131. $group[]= $form->createElement('radio', 'unsubscribe', get_lang('Unsubscription'), get_lang('AllowedToUnsubscribe'), 1);
  132. $group[]= $form->createElement('radio', 'unsubscribe', null, get_lang('NotAllowedToUnsubscribe'), 0);
  133. $form->addGroup($group,'', get_lang('Unsubscription'), '<br />');
  134. $form->addElement('text','disk_quota',array(get_lang('CourseQuota'), null, get_lang('MB')));
  135. $form->addRule('disk_quota', get_lang('ThisFieldIsRequired'),'required');
  136. $form->addRule('disk_quota',get_lang('ThisFieldShouldBeNumeric'),'numeric');
  137. $list_course_extra_field = CourseManager::get_course_extra_field_list($course_code);
  138. //@todo this is wrong
  139. foreach ($list_course_extra_field as $extra_field) {
  140. switch ($extra_field['field_type']) {
  141. /* case USER_FIELD_TYPE_TEXT:
  142. case USER_FIELD_TYPE_TEXTAREA:
  143. case USER_FIELD_TYPE_RADIO: */
  144. case USER_FIELD_TYPE_CHECKBOX:
  145. $checked = (array_key_exists('extra_field_value', $extra_field) && $extra_field['extra_field_value'] == 1)? array('checked'=>'checked'): '';
  146. $form->addElement('hidden', '_extra_'.$extra_field['field_variable'], 0);
  147. $field_display_text=$extra_field['field_display_text'];
  148. //$form->addElement('checkbox', 'extra_'.$extra_field['field_variable'], array(get_lang('SpecialCourse'), get_lang('AllUsersAreAutomaticallyRegistered')) , get_lang($extra_field['field_default_value']), $checked);
  149. $form->addElement('checkbox', 'extra_'.$extra_field['field_variable'], array(null, get_lang('AllUsersAreAutomaticallyRegistered')) , get_lang('SpecialCourse'), $checked);
  150. break;
  151. /* case USER_FIELD_TYPE_SELECT_MULTIPLE:
  152. case USER_FIELD_TYPE_DATE:
  153. case USER_FIELD_TYPE_DATETIME:
  154. case USER_FIELD_TYPE_DOUBLE_SELECT:
  155. case USER_FIELD_TYPE_DIVIDER: */
  156. }
  157. }
  158. $form->addElement('style_submit_button', 'button', get_lang('ModifyCourseInfo'),'onclick="valide()"; class="save"');
  159. // Set some default values
  160. $course_db_name = $course['db_name'];
  161. $course['disk_quota'] = round($course['disk_quota']/1024/1024, 1);
  162. $course['title'] = api_html_entity_decode($course['title'], ENT_QUOTES, $charset);
  163. $form->setDefaults($course);
  164. // Validate form
  165. if ($form->validate()) {
  166. $course = $form->getSubmitValues();
  167. $dbName = $_POST['dbName'];
  168. $course_code = $course['code'];
  169. $visual_code = $course['visual_code'];
  170. $visual_code = generate_course_code($visual_code);
  171. // Check if the visual code is already used by *another* course
  172. $visual_code_is_used = false;
  173. $warn = get_lang('TheFollowingCoursesAlreadyUseThisVisualCode').':';
  174. if (!empty($visual_code)) {
  175. $list = CourseManager::get_courses_info_from_visual_code($visual_code);
  176. foreach ($list as $course_temp) {
  177. if ($course_temp['code'] != $course_code) {
  178. $visual_code_is_used = true;
  179. $warn .= ' '.$course_temp['title'].' ('.$course_temp['code'].'),';
  180. }
  181. }
  182. $warn = substr($warn,0,-1);
  183. }
  184. // an extra field
  185. $extras = array();
  186. foreach ($course as $key => $value) {
  187. if (substr($key,0,6)=='extra_') {
  188. $extras[substr($key,6)] = $value;
  189. }
  190. if (substr($key,0,7)=='_extra_') {
  191. if(!array_key_exists(substr($key,7), $extras)) $extras[substr($key,7)] = $value;
  192. }
  193. }
  194. $tutor_id = $course['tutor_name'];
  195. $tutor_name=$platform_teachers[$tutor_id];
  196. $teachers = $course['group']['course_teachers'];
  197. $title = $course['title'];
  198. $category_code = $course['category_code'];
  199. $department_name = $course['department_name'];
  200. $department_url = $course['department_url'];
  201. $course_language = $course['course_language'];
  202. $course['disk_quota'] = $course['disk_quota']*1024*1024;
  203. $disk_quota = $course['disk_quota'];
  204. $visibility = $course['visibility'];
  205. $subscribe = $course['subscribe'];
  206. $unsubscribe = $course['unsubscribe'];
  207. if (!stristr($department_url, 'http://')) {
  208. $department_url = 'http://'.$department_url;
  209. }
  210. $sql = "UPDATE $course_table SET course_language='".Database::escape_string($course_language)."',
  211. title='".Database::escape_string($title)."',
  212. category_code='".Database::escape_string($category_code)."',
  213. tutor_name='".Database::escape_string($tutor_name)."',
  214. visual_code='".Database::escape_string($visual_code)."',
  215. department_name='".Database::escape_string($department_name)."',
  216. department_url='".Database::escape_string($department_url)."',
  217. disk_quota='".Database::escape_string($disk_quota)."',
  218. visibility = '".Database::escape_string($visibility)."',
  219. subscribe = '".Database::escape_string($subscribe)."',
  220. unsubscribe='".Database::escape_string($unsubscribe)."'
  221. WHERE code='".Database::escape_string($course_code)."'";
  222. Database::query($sql);
  223. //update the extra fields
  224. if (count($extras) > 0) {
  225. foreach ($extras as $key => $value) {
  226. CourseManager::update_course_extra_field_value($course_code, $key, $value);
  227. }
  228. }
  229. //Delete only teacher relations that doesn't match the selected teachers
  230. $cond='';
  231. if (count($teachers)>0) {
  232. foreach($teachers as $key) $cond.=" AND user_id<>'".$key."'";
  233. }
  234. $sql='DELETE FROM '.$course_user_table.' WHERE course_code="'.Database::escape_string($course_code).'" AND status="1"'.$cond;
  235. Database::query($sql);
  236. if (count($teachers)>0) {
  237. foreach ($teachers as $key) {
  238. //We check if the teacher is already subscribed in this course
  239. $sql_select_teacher = 'SELECT 1 FROM '.$course_user_table.' WHERE user_id = "'.$key.'" AND course_code = "'.$course_code.'" ';
  240. $result = Database::query($sql_select_teacher);
  241. if (Database::num_rows($result) == 1) {
  242. $sql = 'UPDATE '.$course_user_table.' SET status = "1" WHERE course_code = "'.$course_code.'" AND user_id = "'.$key.'" ';
  243. } else {
  244. $sql = "INSERT INTO ".$course_user_table . " SET
  245. course_code = '".Database::escape_string($course_code). "',
  246. user_id = '".$key . "',
  247. status = '1',
  248. role = '',
  249. tutor_id='0',
  250. sort='0',
  251. user_course_cat='0'";
  252. }
  253. Database::query($sql);
  254. }
  255. }
  256. $sql = "INSERT IGNORE INTO ".$course_user_table . " SET
  257. course_code = '".Database::escape_string($course_code). "',
  258. user_id = '".$tutor_id . "',
  259. status = '1',
  260. role = '',
  261. tutor_id='0',
  262. sort='0',
  263. user_course_cat='0'";
  264. Database::query($sql);
  265. $course_info = api_get_course_info($course_code);
  266. $course_id = $course_info['real_id'];
  267. $forum_config_table = Database::get_course_table(TOOL_FORUM_CONFIG_TABLE);
  268. $sql = "UPDATE ".$forum_config_table." SET default_lang='".Database::escape_string($course_language)."' WHERE c_id = $course_id ";
  269. if ($visual_code_is_used) {
  270. header('Location: course_list.php?action=show_msg&warn='.urlencode($warn));
  271. } else {
  272. header('Location: course_list.php');
  273. }
  274. exit ();
  275. }
  276. Display::display_header($tool_name);
  277. echo "<script>
  278. function moveItem(origin , destination){
  279. for (var i = 0 ; i<origin.options.length ; i++) {
  280. if (origin.options[i].selected) {
  281. destination.options[destination.length] = new Option(origin.options[i].text,origin.options[i].value);
  282. origin.options[i]=null;
  283. i = i-1;
  284. }
  285. }
  286. destination.selectedIndex = -1;
  287. sortOptions(destination.options);
  288. }
  289. function sortOptions(options) {
  290. newOptions = new Array();
  291. for (i = 0 ; i<options.length ; i++) {
  292. newOptions[i] = options[i];
  293. }
  294. newOptions = newOptions.sort(mysort);
  295. options.length = 0;
  296. for (i = 0 ; i < newOptions.length ; i++) {
  297. options[i] = newOptions[i];
  298. }
  299. }
  300. function mysort(a, b) {
  301. if (a.text.toLowerCase() > b.text.toLowerCase()) {
  302. return 1;
  303. }
  304. if (a.text.toLowerCase() < b.text.toLowerCase()) {
  305. return -1;
  306. }
  307. return 0;
  308. }
  309. function valide() {
  310. var options = document.getElementById('course_teachers').options;
  311. for (i = 0 ; i<options.length ; i++) {
  312. options[i].selected = true;
  313. }
  314. document.update_course.submit();
  315. }
  316. </script>";
  317. //api_display_tool_title($tool_name);
  318. // Display the form
  319. $form->display();
  320. /* FOOTER */
  321. Display :: display_footer();