course_edit.php 13 KB

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