course.lib.php 60 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676
  1. <?php
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2004-2005 Dokeos S.A.
  6. Copyright (c) 2001 Universite catholique de Louvain (UCL)
  7. Copyright (c) Roan Embrechts, Vrije Universiteit Brussel
  8. Copyright (c) Bart Mollet, Hogeschool Gent
  9. Copyright (c) Yannick Warnier, Dokeos S.A.
  10. For a full list of contributors, see "credits.txt".
  11. The full license can be read in "license.txt".
  12. This program is free software; you can redistribute it and/or
  13. modify it under the terms of the GNU General Public License
  14. as published by the Free Software Foundation; either version 2
  15. of the License, or (at your option) any later version.
  16. See the GNU General Public License for more details.
  17. Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
  18. Mail: info@dokeos.com
  19. ==============================================================================
  20. */
  21. /**
  22. ==============================================================================
  23. * This is the course library for Dokeos.
  24. *
  25. * All main course functions should be placed here.
  26. * Many functions of this library deal with providing support for
  27. * virtual/linked/combined courses (this was already used in several universities
  28. * but not available in standard Dokeos).
  29. *
  30. * The implementation changed, initially a course was a real course
  31. * if target_course_code was 0 , this was changed to NULL.
  32. * There are probably some places left with the wrong code.
  33. *
  34. * @package dokeos.library
  35. ==============================================================================
  36. */
  37. /*
  38. ==============================================================================
  39. DOCUMENTATION
  40. (list not up to date, you can auto generate documentation with phpDocumentor)
  41. CourseManager::get_real_course_code_select_html($element_name, $has_size=true, $only_current_user_courses=true)
  42. CourseManager::check_parameter($parameter, $error_message)
  43. CourseManager::check_parameter_or_fail($parameter, $error_message)
  44. CourseManager::is_existing_course_code($wanted_course_code)
  45. CourseManager::get_real_course_list()
  46. CourseManager::get_virtual_course_list()
  47. GENERAL COURSE FUNCTIONS
  48. CourseManager::get_access_settings($course_code)
  49. CourseManager::set_course_tool_visibility($tool_table_id, $visibility)
  50. CourseManager::get_user_in_course_status($user_id, $course_code)
  51. CourseManager::add_user_to_course($user_id, $course_code)
  52. CourseManager::get_virtual_course_info($real_course_code)
  53. CourseManager::is_virtual_course_from_visual_code($visual_code)
  54. CourseManager::is_virtual_course_from_system_code($system_code)
  55. CourseManager::get_virtual_courses_linked_to_real_course($real_course_code)
  56. CourseManager::get_list_of_virtual_courses_for_specific_user_and_real_course($user_id, $real_course_code)
  57. CourseManager::has_virtual_courses_from_code($real_course_code, $user_id)
  58. CourseManager::get_target_of_linked_course($virtual_course_code)
  59. TITLE AND CODE FUNCTIONS
  60. CourseManager::determine_course_title_from_course_info($user_id, $course_info)
  61. CourseManager::create_combined_name($user_is_registered_in_real_course, $real_course_name, $virtual_course_list)
  62. CourseManager::create_combined_code($user_is_registered_in_real_course, $real_course_code, $virtual_course_list)
  63. USER FUNCTIONS
  64. CourseManager::get_real_course_list_of_user_as_course_admin($user_id)
  65. CourseManager::get_course_list_of_user_as_course_admin($user_id)
  66. CourseManager::is_user_subscribed_in_course($user_id, $course_code)
  67. CourseManager::is_user_subscribed_in_real_or_linked_course($user_id, $course_code)
  68. CourseManager::get_user_list_from_course_code($course_code)
  69. CourseManager::get_real_and_linked_user_list($course_code);
  70. GROUP FUNCTIONS
  71. CourseManager::get_group_list_of_course($course_code)
  72. CREATION FUNCTIONS
  73. CourseManager::attempt_create_virtual_course($real_course_code, $course_title, $wanted_course_code, $course_language, $course_category)
  74. ==============================================================================
  75. */
  76. /*
  77. ==============================================================================
  78. INIT SECTION
  79. ==============================================================================
  80. */
  81. /*
  82. -----------------------------------------------------------
  83. Configuration files
  84. -----------------------------------------------------------
  85. */
  86. include_once (api_get_path(CONFIGURATION_PATH).'add_course.conf.php');
  87. /*
  88. -----------------------------------------------------------
  89. Libraries
  90. we assume main_api is also included...
  91. -----------------------------------------------------------
  92. */
  93. include_once (api_get_path(LIBRARY_PATH).'database.lib.php');
  94. include_once (api_get_path(LIBRARY_PATH).'add_course.lib.inc.php');
  95. /*
  96. -----------------------------------------------------------
  97. Constants
  98. -----------------------------------------------------------
  99. */
  100. //LOGIC: course visibility and registration settings
  101. /*
  102. COURSE VISIBILITY
  103. MAPPING OLD SETTINGS TO NEW SETTINGS
  104. -----------------------
  105. NOT_VISIBLE_NO_SUBSCRIPTION_ALLOWED
  106. --> COURSE_VISIBILITY_REGISTERED, SUBSCRIBE_NOT_ALLOWED
  107. NOT_VISIBLE_SUBSCRIPTION_ALLOWED
  108. --> COURSE_VISIBILITY_REGISTERED, SUBSCRIBE_ALLOWED
  109. VISIBLE_SUBSCRIPTION_ALLOWED
  110. --> COURSE_VISIBILITY_OPEN_PLATFORM, SUBSCRIBE_ALLOWED
  111. VISIBLE_NO_SUBSCRIPTION_ALLOWED
  112. --> COURSE_VISIBILITY_OPEN_PLATFORM, SUBSCRIBE_NOT_ALLOWED
  113. */
  114. //OLD SETTINGS
  115. define("NOT_VISIBLE_NO_SUBSCRIPTION_ALLOWED", 0);
  116. define("NOT_VISIBLE_SUBSCRIPTION_ALLOWED", 1);
  117. define("VISIBLE_SUBSCRIPTION_ALLOWED", 2);
  118. define("VISIBLE_NO_SUBSCRIPTION_ALLOWED", 3);
  119. //NEW SETTINGS
  120. //these are now defined in the main_api.lib.php
  121. /*
  122. COURSE_VISIBILITY_CLOSED
  123. COURSE_VISIBILITY_REGISTERED
  124. COURSE_VISIBILITY_OPEN_PLATFORM
  125. COURSE_VISIBILITY_OPEN_WORLD
  126. SUBSCRIBE_ALLOWED
  127. SUBSCRIBE_NOT_ALLOWED
  128. UNSUBSCRIBE_ALLOWED
  129. UNSUBSCRIBE_NOT_ALLOWED
  130. */
  131. /*
  132. -----------------------------------------------------------
  133. Variables
  134. -----------------------------------------------------------
  135. */
  136. $TABLECOURSE = Database :: get_main_table(TABLE_MAIN_COURSE);
  137. $TABLECOURSDOMAIN = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  138. $TABLEUSER = Database :: get_main_table(TABLE_MAIN_USER);
  139. $TABLECOURSUSER = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  140. $TABLEANNOUNCEMENTS = "announcement";
  141. $coursesRepositories = $_configuration['root_sys'];
  142. /*
  143. ==============================================================================
  144. CourseManager CLASS
  145. ==============================================================================
  146. */
  147. /**
  148. * @package dokeos.library
  149. */
  150. class CourseManager
  151. {
  152. /**
  153. * Returns all the information of a given coursecode
  154. * @param string $course_code, the course code
  155. * @return an array with all the fields of the course table
  156. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
  157. */
  158. function get_course_information($course_code)
  159. {
  160. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  161. $sql="SELECT * FROM ".$course_table." WHERE code='".$course_code."'";
  162. $sql_result = api_sql_query($sql, __FILE__, __LINE__);
  163. $result = mysql_fetch_array($sql_result);
  164. return $result;
  165. }
  166. /**
  167. * Returns the access settings of the course:
  168. * which visibility;
  169. * wether subscribing is allowed;
  170. * wether unsubscribing is allowed.
  171. *
  172. * @param string $course_code, the course code
  173. * @todo for more consistency: use course_info call from database API
  174. * @return an array with int fields "visibility", "subscribe", "unsubscribe"
  175. */
  176. function get_access_settings($course_code)
  177. {
  178. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  179. $sql = "SELECT `visibility`, `subscribe`, `unsubscribe` from ".$course_table." where `code` = '".$course_code."'";
  180. $sql_result = api_sql_query($sql, __FILE__, __LINE__);
  181. $result = mysql_fetch_array($sql_result);
  182. return $result;
  183. }
  184. /**
  185. * Returns the status of a user in a course, which is COURSEMANAGER or STUDENT.
  186. *
  187. * @return int the status of the user in that course
  188. */
  189. function get_user_in_course_status($user_id, $course_code)
  190. {
  191. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  192. $sql_query = "SELECT * FROM $course_user_table WHERE `course_code` = '$course_code' AND `user_id` = '$user_id'";
  193. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  194. $result = mysql_fetch_array($sql_result);
  195. return $result["status"];
  196. }
  197. /**
  198. * Unsubscribe one or more users from a course
  199. * @param int|array $user_id
  200. * @param string $course_code
  201. */
  202. function unsubscribe_user($user_id, $course_code)
  203. {
  204. if(!is_array($user_id))
  205. {
  206. $user_id = array($user_id);
  207. }
  208. if(count($user_id) == 0)
  209. {
  210. return;
  211. }
  212. $user_ids = implode(',', $user_id);
  213. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  214. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  215. // Unsubscribe user from all groups in the course
  216. $sql = "SELECT * FROM $table_course WHERE code = '".$course_code."'";
  217. $res = api_sql_query($sql, __FILE__, __LINE__);
  218. $course = mysql_fetch_object($res);
  219. $table_group = Database :: get_course_table(TABLE_GROUP_USER, $course->db_name);
  220. $sql = "DELETE FROM $table_group WHERE user_id IN (".$user_ids.")";
  221. api_sql_query($sql, __FILE__, __LINE__);
  222. // Unsubscribe user from all blogs in the course
  223. $table_blog_user = Database::get_course_table(TABLE_BLOGS_REL_USER, $course->db_name);
  224. $sql = "DELETE FROM ".$table_blog_user." WHERE user_id IN (".$user_ids.")";
  225. api_sql_query($sql,__FILE__,__LINE__);
  226. $table_blogtask_user = Database::get_course_table(TABLE_BLOGS_TASKS_REL_USER, $course->db_name);
  227. $sql = "DELETE FROM ".$table_blogtask_user." WHERE user_id IN (".$user_ids.")";
  228. api_sql_query($sql,__FILE__,__LINE__);
  229. // Unsubscribe user from the course
  230. $sql = "DELETE FROM $table_course_user WHERE user_id IN (".$user_ids.") AND course_code = '".$course_code."'";
  231. api_sql_query($sql, __FILE__, __LINE__);
  232. }
  233. /**
  234. * Subscribe a user to a course. No checks are performed here to see if
  235. * course subscription is allowed.
  236. * @see add_user_to_course
  237. */
  238. function subscribe_user($user_id, $course_code, $status = STUDENT)
  239. {
  240. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  241. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  242. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  243. $location_table = Database :: get_main_table(MAIN_LOCATION_TABLE);
  244. $user_role_table = Database :: get_main_table(MAIN_USER_ROLE_TABLE);
  245. $status = ($status == STUDENT || $status == COURSEMANAGER) ? $status : STUDENT;
  246. $role_id = ($status == COURSEMANAGER) ? COURSE_ADMIN : NORMAL_COURSE_MEMBER;
  247. if (empty ($user_id) || empty ($course_code))
  248. {
  249. return false;
  250. }
  251. else
  252. {
  253. // previously check if the user are already registered on the platform
  254. $handle = api_sql_query("SELECT status FROM ".$user_table."
  255. WHERE `user_id` = '$user_id' ");
  256. if (mysql_num_rows($handle) == 0)
  257. {
  258. return false; // the user isn't registered to the platform
  259. }
  260. else
  261. {
  262. //check if user isn't already subscribed to the course
  263. $handle = api_sql_query("SELECT * FROM ".$course_user_table."
  264. WHERE `user_id` = '$user_id'
  265. AND `course_code` ='$course_code'");
  266. if (mysql_num_rows($handle) > 0)
  267. {
  268. return false; // the user is already subscribed to the course
  269. }
  270. else
  271. {
  272. $course_sort = CourseManager :: userCourseSort($user_id,$course_code);
  273. $add_course_user_entry_sql = "INSERT INTO ".$course_user_table."
  274. SET `course_code` = '$course_code',
  275. `user_id` = '$user_id',
  276. `status` = '".$status."',
  277. `sort` = '". ($course_sort)."'";
  278. $result = api_sql_query($add_course_user_entry_sql);
  279. if ($result)
  280. {
  281. return true;
  282. }
  283. else
  284. {
  285. return false;
  286. }
  287. }
  288. }
  289. }
  290. }
  291. /**
  292. * Subscribe a user $user_id to a course $course_code.
  293. * @author Hugues Peeters
  294. * @author Roan Embrechts
  295. *
  296. * @param int $user_id the id of the user
  297. * @param string $course_code the course code
  298. * @param string $status (optional) The user's status in the course
  299. *
  300. * @return boolean true if subscription succeeds, boolean false otherwise.
  301. * @todo script has ugly ifelseifelseifelseif structure, improve
  302. */
  303. function add_user_to_course($user_id, $course_code, $status = STUDENT)
  304. {
  305. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  306. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  307. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  308. $status = ($status == STUDENT || $status == COURSEMANAGER) ? $status : STUDENT;
  309. if (empty($user_id) || empty ($course_code))
  310. {
  311. return false;
  312. }
  313. else
  314. {
  315. // previously check if the user are already registered on the platform
  316. $handle = api_sql_query("SELECT status FROM ".$user_table."
  317. WHERE `user_id` = '$user_id' ");
  318. if (mysql_num_rows($handle) == 0)
  319. {
  320. return false; // the user isn't registered to the platform
  321. }
  322. else
  323. {
  324. //check if user isn't already subscribed to the course
  325. $handle = api_sql_query("SELECT * FROM ".$course_user_table."
  326. WHERE `user_id` = '$user_id'
  327. AND `course_code` ='$course_code'");
  328. if (mysql_num_rows($handle) > 0)
  329. {
  330. return false; // the user is already subscribed to the course
  331. }
  332. else
  333. {
  334. // previously check if subscription is allowed for this course
  335. $handle = api_sql_query("SELECT code, visibility FROM ".$course_table."
  336. WHERE `code` = '$course_code'
  337. AND `subscribe` = '".SUBSCRIBE_NOT_ALLOWED."'");
  338. if (mysql_num_rows($handle) > 0)
  339. {
  340. return false; // subscription not allowed for this course
  341. }
  342. else
  343. {
  344. $max_sort = api_max_sort_value('0', $user_id);
  345. $add_course_user_entry_sql = "INSERT INTO ".$course_user_table."
  346. SET `course_code` = '$course_code',
  347. `user_id` = '$user_id',
  348. `status` = '".$status."',
  349. `sort` = '". ($max_sort +1)."'";
  350. $result=api_sql_query($add_course_user_entry_sql);
  351. if ($result)
  352. {
  353. return true;
  354. }
  355. else
  356. {
  357. return false;
  358. }
  359. }
  360. }
  361. }
  362. }
  363. }
  364. /**
  365. * This code creates a select form element to let the user
  366. * choose a real course to link to.
  367. *
  368. * A good non-display library should not use echo statements, but just return text/html
  369. * so users of the library can choose when to display.
  370. *
  371. * We display the course code, but internally store the course id.
  372. *
  373. * @param boolean $has_size, true the select tag gets a size element, false it stays a dropdownmenu
  374. * @param boolean $only_current_user_courses, true only the real courses of which the
  375. * current user is course admin are displayed, false all real courses are shown.
  376. * @param string $element_name the name of the select element
  377. * @return a string containing html code for a form select element.
  378. * @deprecated Function not in use
  379. */
  380. function get_real_course_code_select_html($element_name, $has_size = true, $only_current_user_courses = true, $user_id)
  381. {
  382. if ($only_current_user_courses == true)
  383. {
  384. $real_course_list = CourseManager :: get_real_course_list_of_user_as_course_admin($user_id);
  385. }
  386. else
  387. {
  388. $real_course_list = CourseManager :: get_real_course_list();
  389. }
  390. if ($has_size == true)
  391. {
  392. $size_element = "size=\"".SELECT_BOX_SIZE."\"";
  393. }
  394. else
  395. {
  396. $size_element = "";
  397. }
  398. $html_code = "<select name=\"$element_name\" $size_element >\n";
  399. foreach ($real_course_list as $real_course)
  400. {
  401. $course_code = $real_course["code"];
  402. $html_code .= "<option value=\"".$course_code."\">";
  403. $html_code .= $course_code;
  404. $html_code .= "</option>\n";
  405. }
  406. $html_code .= "</select>\n";
  407. return $html_code;
  408. }
  409. /**
  410. * Checks wether a parameter exists.
  411. * If it doesn't, the function displays an error message.
  412. *
  413. * @return true if parameter is set and not empty, false otherwise
  414. * @todo move function to better place, main_api ?
  415. */
  416. function check_parameter($parameter, $error_message)
  417. {
  418. if (!isset ($parameter) || empty ($parameter))
  419. {
  420. Display :: display_normal_message($error_message);
  421. return false;
  422. }
  423. return true;
  424. }
  425. /**
  426. * Lets the script die when a parameter check fails.
  427. * @todo move function to better place, main_api ?
  428. */
  429. function check_parameter_or_fail($parameter, $error_message)
  430. {
  431. if (!CourseManager :: check_parameter($parameter, $error_message))
  432. die();
  433. }
  434. /**
  435. * @return true if there already are one or more courses
  436. * with the same code OR visual_code (visualcode), false otherwise
  437. */
  438. function is_existing_course_code($wanted_course_code)
  439. {
  440. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  441. $sql_query = "SELECT COUNT(*) as number FROM ".$course_table."WHERE `code` = '$wanted_course_code' OR `visual_code` = '$wanted_course_code' ";
  442. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  443. $result = mysql_fetch_array($sql_result);
  444. if ($result["number"] > 0)
  445. {
  446. return true;
  447. }
  448. else
  449. {
  450. return false;
  451. }
  452. }
  453. /**
  454. * @return an array with the course info of all real courses on the platform
  455. */
  456. function get_real_course_list()
  457. {
  458. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  459. $sql_query = "SELECT * FROM $course_table WHERE `target_course_code` IS NULL";
  460. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  461. while ($result = mysql_fetch_array($sql_result))
  462. {
  463. $real_course_list[] = $result;
  464. }
  465. return $real_course_list;
  466. }
  467. /**
  468. * @return an array with the course info of all virtual courses on the platform
  469. */
  470. function get_virtual_course_list()
  471. {
  472. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  473. $sql_query = "SELECT * FROM $course_table WHERE `target_course_code` IS NOT NULL";
  474. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  475. while ($result = mysql_fetch_array($sql_result))
  476. {
  477. $virtual_course_list[] = $result;
  478. }
  479. return $virtual_course_list;
  480. }
  481. /**
  482. * @return an array with the course info of the real courses of which
  483. * the current user is course admin
  484. */
  485. function get_real_course_list_of_user_as_course_admin($user_id)
  486. {
  487. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  488. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  489. $sql_query = " SELECT *
  490. FROM $course_table course
  491. LEFT JOIN $course_user_table course_user
  492. ON course.`code` = course_user.`course_code`
  493. WHERE course.`target_course_code` IS NULL
  494. AND course_user.`user_id` = '$user_id'
  495. AND course_user.`status` = '1'";
  496. //api_display_debug_info($sql_query);
  497. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  498. while ($result = mysql_fetch_array($sql_result))
  499. {
  500. $result_array[] = $result;
  501. }
  502. return $result_array;
  503. }
  504. /**
  505. * @return an array with the course info of all the courses (real and virtual) of which
  506. * the current user is course admin
  507. */
  508. function get_course_list_of_user_as_course_admin($user_id)
  509. {
  510. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  511. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  512. $sql_query = " SELECT *
  513. FROM $course_table course
  514. LEFT JOIN $course_user_table course_user
  515. ON course.`code` = course_user.`course_code`
  516. WHERE course_user.`user_id` = '$user_id'
  517. AND course_user.`status` = '1'";
  518. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  519. while ($result = mysql_fetch_array($sql_result))
  520. {
  521. $result_array[] = $result;
  522. }
  523. return $result_array;
  524. }
  525. /**
  526. * Find out for which courses the user is registered and determine a visual course code and course title from that.
  527. * Takes virtual courses into account
  528. *
  529. * Default case: the name and code stay what they are.
  530. *
  531. * Scenarios:
  532. * - User is registered in real course and virtual courses; name / code become a mix of all
  533. * - User is registered in real course only: name stays that of real course
  534. * - User is registered in virtual course only: name becomes that of virtual course
  535. * - user is not registered to any of the real/virtual courses: name stays that of real course
  536. * (I'm not sure about the last case, but this seems not too bad)
  537. *
  538. * @author Roan Embrechts
  539. * @param $user_id, the id of the user
  540. * @param $course_info, an array with course info that you get using Database::get_course_info($course_system_code);
  541. * @return an array with indices
  542. * $return_result["title"] - the course title of the combined courses
  543. * $return_result["code"] - the course code of the combined courses
  544. */
  545. function determine_course_title_from_course_info($user_id, $course_info)
  546. {
  547. $real_course_id = $course_info['system_code'];
  548. $real_course_info = Database :: get_course_info($real_course_id);
  549. $real_course_name = $real_course_info["title"];
  550. $real_course_visual_code = $real_course_info["visual_code"];
  551. $real_course_real_code = $course_info['system_code'];
  552. //is the user registered in the real course?
  553. $table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  554. $sql_query = "SELECT * FROM $table WHERE `user_id` = '$user_id' AND `course_code` = '$real_course_real_code'";
  555. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  556. $result = mysql_fetch_array($sql_result);
  557. if (!isset ($result) || empty ($result))
  558. {
  559. $user_is_registered_in_real_course = false;
  560. }
  561. else
  562. {
  563. $user_is_registered_in_real_course = true;
  564. }
  565. //get a list of virtual courses linked to the current real course
  566. //and to which the current user is subscribed
  567. $user_subscribed_virtual_course_list = CourseManager :: get_list_of_virtual_courses_for_specific_user_and_real_course($user_id, $real_course_id);
  568. if (count($user_subscribed_virtual_course_list) > 0)
  569. {
  570. $virtual_courses_exist = true;
  571. }
  572. else
  573. {
  574. $virtual_courses_exist = false;
  575. }
  576. //now determine course code and name
  577. if ($user_is_registered_in_real_course && $virtual_courses_exist)
  578. {
  579. $course_info["name"] = CourseManager :: create_combined_name($user_is_registered_in_real_course, $real_course_name, $user_subscribed_virtual_course_list);
  580. $course_info['official_code'] = CourseManager :: create_combined_code($user_is_registered_in_real_course, $real_course_visual_code, $user_subscribed_virtual_course_list);
  581. }
  582. else
  583. if ($user_is_registered_in_real_course)
  584. {
  585. //course name remains real course name
  586. $course_info["name"] = $real_course_name;
  587. $course_info['official_code'] = $real_course_visual_code;
  588. }
  589. else
  590. if ($virtual_courses_exist)
  591. {
  592. $course_info["name"] = CourseManager :: create_combined_name($user_is_registered_in_real_course, $real_course_name, $user_subscribed_virtual_course_list);
  593. $course_info['official_code'] = CourseManager :: create_combined_code($user_is_registered_in_real_course, $real_course_visual_code, $user_subscribed_virtual_course_list);
  594. }
  595. else
  596. {
  597. //course name remains real course name
  598. $course_info["name"] = $real_course_name;
  599. $course_info['official_code'] = $real_course_visual_code;
  600. }
  601. $return_result["title"] = $course_info["name"];
  602. $return_result["code"] = $course_info['official_code'];
  603. return $return_result;
  604. }
  605. /**
  606. * Create a course title based on all real and virtual courses the user is registered in.
  607. * @param boolean $user_is_registered_in_real_course
  608. * @param string $real_course_name, the title of the real course
  609. * @param array $virtual_course_list, the list of virtual courses
  610. */
  611. function create_combined_name($user_is_registered_in_real_course, $real_course_name, $virtual_course_list)
  612. {
  613. if ($user_is_registered_in_real_course || count($virtual_course_list) > 1)
  614. {
  615. $complete_course_name_before = get_lang("CombinedCourse")." "; //from course_home lang file
  616. }
  617. if ($user_is_registered_in_real_course)
  618. {
  619. //add real name to result
  620. $complete_course_name[] = $real_course_name;
  621. }
  622. //add course titles of all virtual courses to the list
  623. foreach ($virtual_course_list as $current_course)
  624. {
  625. $complete_course_name[] = $current_course["title"];
  626. }
  627. $complete_course_name = $complete_course_name_before.implode(' &amp; ', $complete_course_name);
  628. return $complete_course_name;
  629. }
  630. /**
  631. * Create a course code based on all real and virtual courses the user is registered in.
  632. */
  633. function create_combined_code($user_is_registered_in_real_course, $real_course_code, $virtual_course_list)
  634. {
  635. $complete_course_code .= "";
  636. if ($user_is_registered_in_real_course)
  637. {
  638. //add real name to result
  639. $complete_course_code[] = $real_course_code;
  640. }
  641. //add course titles of all virtual courses to the list
  642. foreach ($virtual_course_list as $current_course)
  643. {
  644. $complete_course_code[] = $current_course["visual_code"];
  645. }
  646. $complete_course_code = implode(' &amp; ', $complete_course_code);
  647. return $complete_course_code;
  648. }
  649. /**
  650. * Return course info array of virtual course
  651. *
  652. * Note this is different from getting information about a real course!
  653. *
  654. * @param $real_course_code, the id of the real course which the virtual course is linked to
  655. */
  656. function get_virtual_course_info($real_course_code)
  657. {
  658. $table = Database :: get_main_table(TABLE_MAIN_COURSE);
  659. $sql_query = "SELECT * FROM $table WHERE `target_course_code` = '$real_course_code'";
  660. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  661. $result = array ();
  662. while ($virtual_course = mysql_fetch_array($sql_result))
  663. {
  664. $result[] = $virtual_course;
  665. }
  666. return $result;
  667. }
  668. /**
  669. * @param string $system_code, the system code of the course
  670. * @return true if the course is a virtual course, false otherwise
  671. */
  672. function is_virtual_course_from_system_code($system_code)
  673. {
  674. $table = Database :: get_main_table(TABLE_MAIN_COURSE);
  675. $sql_query = "SELECT * FROM $table WHERE `code` = '$system_code'";
  676. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  677. $result = mysql_fetch_array($sql_result);
  678. $target_number = $result["target_course_code"];
  679. if ($target_number == NULL)
  680. {
  681. return false; //this is not a virtual course
  682. }
  683. else
  684. {
  685. return true; //this is a virtual course
  686. }
  687. }
  688. /**
  689. * What's annoying is that you can't overload functions in PHP.
  690. * @return true if the course is a virtual course, false otherwise
  691. */
  692. function is_virtual_course_from_visual_code($visual_code)
  693. {
  694. $table = Database :: get_main_table(TABLE_MAIN_COURSE);
  695. $sql_query = "SELECT * FROM $table WHERE `visual_code` = '$visual_code'";
  696. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  697. $result = mysql_fetch_array($sql_result);
  698. $target_number = $result["target_course_code"];
  699. if ($target_number == NULL)
  700. {
  701. return false; //this is not a virtual course
  702. }
  703. else
  704. {
  705. return true; //this is a virtual course
  706. }
  707. }
  708. /**
  709. * @return true if the real course has virtual courses that the user is subscribed to, false otherwise
  710. */
  711. function has_virtual_courses_from_code($real_course_code, $user_id)
  712. {
  713. $user_subscribed_virtual_course_list = CourseManager :: get_list_of_virtual_courses_for_specific_user_and_real_course($user_id, $real_course_code);
  714. $number_of_virtual_courses = count($user_subscribed_virtual_course_list);
  715. if (count($user_subscribed_virtual_course_list) > 0)
  716. {
  717. return true;
  718. }
  719. else
  720. {
  721. return false;
  722. }
  723. }
  724. /**
  725. * Return an array of arrays, listing course info of all virtual course
  726. * linked to the real course ID $real_course_code
  727. *
  728. * @param $real_course_code, the id of the real course which the virtual courses are linked to
  729. */
  730. function get_virtual_courses_linked_to_real_course($real_course_code)
  731. {
  732. $table = Database :: get_main_table(TABLE_MAIN_COURSE);
  733. $sql_query = "SELECT * FROM $table WHERE `target_course_code` = '$real_course_code'";
  734. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  735. $result_array = array ();
  736. while ($result = mysql_fetch_array($sql_result))
  737. {
  738. $result_array[] = $result;
  739. }
  740. return $result_array;
  741. }
  742. /**
  743. * This function returns the course code of the real course
  744. * to which a virtual course is linked.
  745. *
  746. * @param the course code of the virtual course
  747. * @return the course code of the real course
  748. */
  749. function get_target_of_linked_course($virtual_course_code)
  750. {
  751. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  752. //get info about the virtual course
  753. $sql_query = "SELECT * FROM $course_table WHERE `code` = '$virtual_course_code'";
  754. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  755. $result = mysql_fetch_array($sql_result);
  756. $target_course_code = $result["target_course_code"];
  757. return $target_course_code;
  758. }
  759. /*
  760. ==============================================================================
  761. USER FUNCTIONS
  762. ==============================================================================
  763. */
  764. /**
  765. * Return course info array of virtual course
  766. *
  767. * @param $user_id, the id (int) of the user
  768. * @param $course_info, array with info about the course (comes from course table)
  769. *
  770. * @return true if the user is registered in the course, false otherwise
  771. */
  772. function is_user_subscribed_in_course($user_id, $course_code, $in_a_session=false)
  773. {
  774. $user_id = intval($user_id);
  775. $course_code = addslashes($course_code);
  776. $table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  777. $sql_query = "SELECT * FROM $table WHERE `user_id` = '$user_id' AND `course_code` = '$course_code'";
  778. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  779. $result = mysql_fetch_array($sql_result);
  780. if (!isset ($result) || empty ($result))
  781. {
  782. if($in_a_session)
  783. {
  784. $sql = 'SELECT 1 FROM '.Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER).'
  785. WHERE id_user = '.$user_id.' AND course_code="'.$course_code.'"';
  786. $rs = api_sql_query($sql, __FILE__, __LINE__);
  787. if(mysql_num_rows($rs)>0)
  788. {
  789. return true;
  790. }
  791. else{
  792. $sql = 'SELECT 1 FROM '.Database :: get_main_table(TABLE_MAIN_SESSION_COURSE).'
  793. WHERE id_coach = '.$user_id.' AND course_code="'.$course_code.'"';
  794. $rs = api_sql_query($sql, __FILE__, __LINE__);
  795. if(mysql_num_rows($rs)>0)
  796. {
  797. return true;
  798. }
  799. }
  800. }
  801. else
  802. return false; //user is not registered in course
  803. }
  804. else
  805. {
  806. return true; //user is registered in course
  807. }
  808. }
  809. /**
  810. * Is the user a teacher in the given course?
  811. *
  812. * @param $user_id, the id (int) of the user
  813. * @param $course_code, the course code
  814. *
  815. * @return true if the user is a teacher in the course, false otherwise
  816. */
  817. function is_course_teacher($user_id,$course_code)
  818. {
  819. $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  820. $sql_query='SELECT status FROM '.$tbl_course_user.' WHERE course_code="'.$course_code.'" and user_id="'.$user_id.'"';
  821. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  822. if(Database::num_rows($sql_result)>0)
  823. {
  824. $status=mysql_result($sql_result,0,'status');
  825. if($status==1) return true; else return false;
  826. }
  827. return false;
  828. }
  829. /**
  830. * Is the user subscribed in the real course or linked courses?
  831. *
  832. * @param $user_id, the id (int) of the user
  833. * @param $course_info, array with info about the course (comes from course table, see database lib)
  834. *
  835. * @return true if the user is registered in the real course or linked courses, false otherwise
  836. */
  837. function is_user_subscribed_in_real_or_linked_course($user_id, $course_code, $session_id='')
  838. {
  839. if($session_id==''){
  840. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  841. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  842. $sql_query = " SELECT *
  843. FROM $course_table course
  844. LEFT JOIN $course_user_table course_user
  845. ON course.`code` = course_user.`course_code`
  846. WHERE course_user.`user_id` = '$user_id' AND ( course.`code` = '$course_code' OR `target_course_code` = '$course_code') ";
  847. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  848. $result = mysql_fetch_array($sql_result);
  849. if (!isset ($result) || empty ($result))
  850. {
  851. return false; //user is not registered in course
  852. }
  853. else
  854. {
  855. return true; //user is registered in course
  856. }
  857. }
  858. else {
  859. // is he subscribed to the course of the session ?
  860. // Database Table Definitions
  861. $tbl_sessions = Database::get_main_table(TABLE_MAIN_SESSION);
  862. $tbl_sessions_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  863. $tbl_session_course_user= Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  864. //users
  865. $sql = "SELECT id_user
  866. FROM $tbl_session_course_user
  867. WHERE id_session='".$_SESSION['id_session']."'
  868. AND id_user='$user_id'";
  869. $result = api_sql_query($sql,__FILE__,__LINE__);
  870. if(mysql_num_rows($result))
  871. return true;
  872. // is it a course coach ?
  873. $sql = "SELECT id_coach
  874. FROM $tbl_sessions_course AS session_course
  875. WHERE id_session='".$_SESSION['id_session']."'
  876. AND id_coach = '$user_id'
  877. AND course_code='$course_code'";
  878. $result = api_sql_query($sql,__FILE__,__LINE__);
  879. if(mysql_num_rows($result))
  880. return true;
  881. // is it a session coach ?
  882. $sql = "SELECT id_coach
  883. FROM $tbl_sessions AS session
  884. WHERE session.id='".$_SESSION['id_session']."'
  885. AND id_coach='$user_id'";
  886. $result = api_sql_query($sql,__FILE__,__LINE__);
  887. if(mysql_num_rows($result))
  888. return true;
  889. return false;
  890. }
  891. }
  892. /**
  893. * Return user info array of all users registered in the specified real or virtual course
  894. * This only returns the users that are registered in this actual course, not linked courses.
  895. *
  896. * @param string $course_code
  897. * @return array with user info
  898. */
  899. function get_user_list_from_course_code($course_code, $with_session=true, $session_id=0){
  900. $session_id = intval($session_id);
  901. $a_users = array();
  902. $table_users = Database :: get_main_table(TABLE_MAIN_USER);
  903. // users subscribed to the course through a session
  904. if(api_get_setting('use_session_mode')=='true' && $with_session){
  905. $table_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  906. $sql_query = "SELECT session_course_user.*, user.user_id FROM $table_session_course_user as session_course_user, $table_users as user WHERE `course_code` = '$course_code' AND session_course_user.id_user = user.user_id ";
  907. if($session_id!=0)
  908. $sql_query .= ' AND id_session = '.$session_id;
  909. $sql_query.=' ORDER BY user.lastname';
  910. $rs = api_sql_query($sql_query, __FILE__, __LINE__);
  911. while($user = mysql_fetch_array($rs))
  912. {
  913. $user_infos = Database :: get_user_info_from_id($user['id_user']);
  914. $user_infos["status"] = $user["status"];
  915. $user_infos["role"] = $user["role"];
  916. $user_infos["tutor_id"] = $user["tutor_id"];
  917. $a_users[$user['id_user']] = $user_infos;
  918. }
  919. }
  920. if($session_id == 0){
  921. // users directly subscribed to the course
  922. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  923. $sql_query = "SELECT course_user.user_id, user.user_id, course_user.status, course_user.role, course_user.tutor_id " .
  924. "FROM $table_course_user as course_user, $table_users as user WHERE `course_code` = '$course_code' AND course_user.user_id = user.user_id ORDER BY user.lastname";
  925. $rs = api_sql_query($sql_query, __FILE__, __LINE__);
  926. while($user = mysql_fetch_array($rs))
  927. {
  928. $user_infos = Database :: get_user_info_from_id($user['user_id']);
  929. $user_infos["status"] = $user["status"];
  930. $user_infos["role"] = $user["role"];
  931. $user_infos["tutor_id"] = $user["tutor_id"];
  932. $a_users[$user['user_id']] = $user_infos;
  933. }
  934. }
  935. return $a_users;
  936. }
  937. function get_coach_list_from_course_code($course_code,$session_id){
  938. $table_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  939. $table_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  940. $a_users=array();
  941. //We get the coach for the given course in a given session
  942. $sql = 'SELECT id_coach FROM '.$table_session_course.' WHERE id_session="'.$session_id.'" AND course_code="'.$course_code.'"';
  943. $rs = api_sql_query($sql, __FILE__, __LINE__);
  944. while($user = mysql_fetch_array($rs))
  945. {
  946. $user_infos = Database :: get_user_info_from_id($user['id_coach']);
  947. $user_infos["status"] = $user["status"];
  948. $user_infos["role"] = $user["role"];
  949. $user_infos["tutor_id"] = $user["tutor_id"];
  950. $user_infos['email'] = $user['email'];
  951. $a_users[$user['id_coach']] = $user_infos;
  952. }
  953. //We get the session coach
  954. $sql = 'SELECT id_coach FROM '.$table_session.' WHERE id="'.$session_id.'"';
  955. $rs = api_sql_query($sql, __FILE__, __LINE__);
  956. $user_infos=array();
  957. $session_id_coach = mysql_result($rs,0,'id_coach');
  958. $user_infos = Database :: get_user_info_from_id($session_id_coach);
  959. $user_infos["status"] = $user["status"];
  960. $user_infos["role"] = $user["role"];
  961. $user_infos["tutor_id"] = $user["tutor_id"];
  962. $user_infos['email'] = $user['email'];
  963. $a_users[$session_id_coach] = $user_infos;
  964. return $a_users;
  965. }
  966. /**
  967. * Return user info array of all users registered in the specified real or virtual course
  968. * This only returns the users that are registered in this actual course, not linked courses.
  969. *
  970. * @param string $course_code
  971. * @param boolean $full list to true if we want sessions students too
  972. * @return array with user id
  973. */
  974. function get_student_list_from_course_code($course_code, $with_session=false, $session_id=0)
  975. {
  976. $a_students = array();
  977. $session_id = intval($session_id);
  978. if($session_id == 0)
  979. {
  980. // students directly subscribed to the course
  981. $table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  982. $sql_query = "SELECT * FROM $table WHERE `course_code` = '$course_code' AND `status` = 5";
  983. $rs = api_sql_query($sql_query, __FILE__, __LINE__);
  984. while($student = mysql_fetch_array($rs))
  985. {
  986. $a_students[$student['user_id']] = $student;
  987. }
  988. }
  989. // students subscribed to the course through a session
  990. if(api_get_setting('use_session_mode')=='true' && $with_session)
  991. {
  992. $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  993. $sql_query = "SELECT * FROM $table WHERE `course_code` = '$course_code'";
  994. if($session_id!=0)
  995. $sql_query .= ' AND id_session = '.$session_id;
  996. $rs = api_sql_query($sql_query, __FILE__, __LINE__);
  997. while($student = mysql_fetch_array($rs))
  998. {
  999. $a_students[$student['id_user']] = $student;
  1000. }
  1001. }
  1002. return $a_students;
  1003. }
  1004. /**
  1005. * Return user info array of all teacher-users registered in the specified real or virtual course
  1006. * This only returns the users that are registered in this actual course, not linked courses.
  1007. *
  1008. * @param string $course_code
  1009. * @return array with user id
  1010. */
  1011. function get_teacher_list_from_course_code($course_code)
  1012. {
  1013. $a_teachers = array();
  1014. // teachers directly subscribed to the course
  1015. $t_cu = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  1016. $t_u = Database :: get_main_table(TABLE_MAIN_USER);
  1017. $sql_query = "SELECT u.user_id, u.lastname, u.firstname, u.email, u.username, u.status " .
  1018. "FROM $t_cu cu, $t_u u " .
  1019. "WHERE cu.course_code = '$course_code' " .
  1020. "AND cu.status = 1 " .
  1021. "AND cu.user_id = u.user_id";
  1022. $rs = api_sql_query($sql_query, __FILE__, __LINE__);
  1023. while($teacher = mysql_fetch_array($rs))
  1024. {
  1025. $a_students[$teacher['user_id']] = $teacher;
  1026. }
  1027. return $a_students;
  1028. }
  1029. /**
  1030. * Return user info array of all users registered in the specified course
  1031. * this includes the users of the course itsel and the users of all linked courses.
  1032. *
  1033. * @param array $course_info
  1034. * @return array with user info
  1035. */
  1036. function get_real_and_linked_user_list($course_code, $with_sessions = true, $session_id=0)
  1037. {
  1038. //get list of virtual courses
  1039. $virtual_course_list = CourseManager :: get_virtual_courses_linked_to_real_course($course_code);
  1040. //get users from real course
  1041. $user_list = CourseManager :: get_user_list_from_course_code($course_code, $with_sessions, $session_id);
  1042. foreach ($user_list as $this_user)
  1043. {
  1044. $complete_user_list[] = $this_user;
  1045. }
  1046. //get users from linked courses
  1047. foreach ($virtual_course_list as $this_course)
  1048. {
  1049. $course_code = $this_course["code"];
  1050. $user_list = CourseManager :: get_user_list_from_course_code($course_code, $with_sessions, $session_id);
  1051. foreach ($user_list as $this_user)
  1052. {
  1053. $complete_user_list[] = $this_user;
  1054. }
  1055. }
  1056. return $complete_user_list;
  1057. }
  1058. /**
  1059. * Return an array of arrays, listing course info of all courses in the list
  1060. * linked to the real course $real_course_code, to which the user $user_id is subscribed.
  1061. *
  1062. * @param $user_id, the id (int) of the user
  1063. * @param $real_course_code, the id (char) of the real course
  1064. *
  1065. * @return array of course info arrays
  1066. */
  1067. function get_list_of_virtual_courses_for_specific_user_and_real_course($user_id, $real_course_code)
  1068. {
  1069. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  1070. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  1071. $sql_query = " SELECT *
  1072. FROM $course_table course
  1073. LEFT JOIN $course_user_table course_user
  1074. ON course.`code` = course_user.`course_code`
  1075. WHERE course.`target_course_code` = '$real_course_code' AND course_user.`user_id` = '$user_id'";
  1076. $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
  1077. while ($result = mysql_fetch_array($sql_result))
  1078. {
  1079. $result_array[] = $result;
  1080. }
  1081. return $result_array;
  1082. }
  1083. /*
  1084. ==============================================================================
  1085. GROUP FUNCTIONS
  1086. ==============================================================================
  1087. */
  1088. function get_group_list_of_course($course_code)
  1089. {
  1090. $course_info = Database :: get_course_info($course_code);
  1091. $database_name = $course_info['db_name'];
  1092. $group_table = Database :: get_course_table(TABLE_GROUP, $database_name);
  1093. $group_user_table = Database :: get_course_table(TABLE_GROUP_USER, $database_name);
  1094. $sql = "SELECT g.id, g.name, COUNT(gu.id) userNb
  1095. FROM $group_table AS g LEFT JOIN $group_user_table gu
  1096. ON g.id = gu.group_id
  1097. GROUP BY g.id
  1098. ORDER BY g.name";
  1099. $result = api_sql_query($sql, __FILE__, __LINE__) or die(mysql_error());
  1100. while ($group_data = mysql_fetch_array($result))
  1101. {
  1102. $group_list[$group_data['id']] = $group_data;
  1103. }
  1104. return $group_list;
  1105. }
  1106. /**
  1107. * Checks all parameters needed to create a virtual course.
  1108. * If they are all set, the virtual course creation procedure is called.
  1109. *
  1110. * Call this function instead of create_virtual_course
  1111. */
  1112. function attempt_create_virtual_course($real_course_code, $course_title, $wanted_course_code, $course_language, $course_category)
  1113. {
  1114. //better: create parameter list, check the entire list, when false display errormessage
  1115. CourseManager :: check_parameter_or_fail($real_course_code, "Unspecified parameter: real course id.");
  1116. CourseManager :: check_parameter_or_fail($course_title, "Unspecified parameter: course title.");
  1117. CourseManager :: check_parameter_or_fail($wanted_course_code, "Unspecified parameter: wanted course code.");
  1118. CourseManager :: check_parameter_or_fail($course_language, "Unspecified parameter: course language.");
  1119. CourseManager :: check_parameter_or_fail($course_category, "Unspecified parameter: course category.");
  1120. $creation_success = CourseManager :: create_virtual_course($real_course_code, $course_title, $wanted_course_code, $course_language, $course_category);
  1121. return $creation_success;
  1122. }
  1123. /**
  1124. * This function creates a virtual course.
  1125. * It assumes all parameters have been checked and are not empty.
  1126. * It checks wether a course with the $wanted_course_code already exists.
  1127. *
  1128. * Users of this library should consider this function private,
  1129. * please call attempt_create_virtual_course instead of this one.
  1130. *
  1131. * NOTE:
  1132. * The virtual course 'owner' id (the first course admin) is set to the CURRENT user id.
  1133. * @return true if the course creation succeeded, false otherwise
  1134. * @todo research: expiration date of a course
  1135. */
  1136. function create_virtual_course($real_course_code, $course_title, $wanted_course_code, $course_language, $course_category)
  1137. {
  1138. global $firstExpirationDelay;
  1139. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  1140. $user_id = api_get_user_id();
  1141. $real_course_info = Database :: get_course_info($real_course_code);
  1142. $real_course_code = $real_course_info["system_code"];
  1143. //check: virtual course creation fails if another course has the same
  1144. //code, real or fake.
  1145. if (CourseManager :: is_existing_course_code($wanted_course_code))
  1146. {
  1147. Display :: display_error_message($wanted_course_code." - ".get_lang("CourseCodeAlreadyExists"));
  1148. return false;
  1149. }
  1150. //add data to course table, course_rel_user
  1151. $course_sys_code = $wanted_course_code;
  1152. $course_screen_code = $wanted_course_code;
  1153. $course_repository = $real_course_info["directory"];
  1154. $course_db_name = $real_course_info["db_name"];
  1155. $responsible_teacher = $real_course_info["tutor_name"];
  1156. $faculty_shortname = $course_category;
  1157. // $course_title = $course_title;
  1158. // $course_language = $course_language;
  1159. $teacher_id = $user_id;
  1160. //HACK ----------------------------------------------------------------
  1161. $expiration_date = time() + $firstExpirationDelay;
  1162. //END HACK ------------------------------------------------------------
  1163. register_course($course_sys_code, $course_screen_code, $course_repository, $course_db_name, $responsible_teacher, $faculty_shortname, $course_title, $course_language, $teacher_id, $expiration_date);
  1164. //above was the normal course creation table update call,
  1165. //now one more thing: fill in the target_course_code field
  1166. $sql_query = "UPDATE $course_table SET `target_course_code` = '$real_course_code' WHERE `code` = '$course_sys_code' LIMIT 1 ";
  1167. api_sql_query($sql_query, __FILE__, __LINE__);
  1168. return true;
  1169. }
  1170. /**
  1171. * Delete a course
  1172. * This function deletes a whole course-area from the platform. When the
  1173. * given course is a virtual course, the database and directory will not be
  1174. * deleted.
  1175. * When the given course is a real course, also all virtual courses refering
  1176. * to the given course will be deleted.
  1177. * Considering the fact that we remove all traces of the course in the main
  1178. * database, it makes sense to remove all tracking as well (if stats databases exist)
  1179. * so that a new course created with this code would not use the remains of an older
  1180. * course.
  1181. *
  1182. * @param string $code The code of the course to delete
  1183. * @todo When deleting a virtual course: unsubscribe users from that virtual
  1184. * course from the groups in the real course if they are not subscribed in
  1185. * that real course.
  1186. * @todo Remove globals
  1187. */
  1188. function delete_course($code)
  1189. {
  1190. global $_configuration;
  1191. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  1192. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  1193. $table_course_class = Database :: get_main_table(TABLE_MAIN_COURSE_CLASS);
  1194. $user_role_table = Database :: get_main_table(MAIN_USER_ROLE_TABLE);
  1195. $location_table = Database::get_main_table(MAIN_LOCATION_TABLE);
  1196. $role_right_location_table = Database::get_main_table(MAIN_ROLE_RIGHT_LOCATION_TABLE);
  1197. $table_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  1198. $table_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  1199. $table_course_survey = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY);
  1200. $table_course_survey_question = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION);
  1201. $table_course_survey_question_option = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION);
  1202. $stats = false;
  1203. if(Database::get_statistic_database() != ''){
  1204. $stats = true;
  1205. $table_stats_hotpots = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_HOTPOTATOES);
  1206. $table_stats_attempt = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
  1207. $table_stats_exercises = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
  1208. $table_stats_access = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ACCESS);
  1209. $table_stats_lastaccess = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);
  1210. $table_stats_course_access = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
  1211. $table_stats_online = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
  1212. $table_stats_default = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_DEFAULT);
  1213. $table_stats_downloads = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);
  1214. $table_stats_links = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LINKS);
  1215. $table_stats_uploads = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_UPLOADS);
  1216. }
  1217. $sql = "SELECT * FROM $table_course WHERE code='".$code."'";
  1218. $res = api_sql_query($sql, __FILE__, __LINE__);
  1219. if (Database::num_rows($res) == 0)
  1220. {
  1221. return;
  1222. }
  1223. $this_course = Database::fetch_array($res);
  1224. $db_name = $this_course['db_name'];
  1225. CourseManager :: create_database_dump($code);
  1226. if (!CourseManager :: is_virtual_course_from_system_code($code))
  1227. {
  1228. // If this is not a virtual course, look for virtual courses that depend on this one, if any
  1229. $virtual_courses = CourseManager :: get_virtual_courses_linked_to_real_course($code);
  1230. foreach ($virtual_courses as $index => $virtual_course)
  1231. {
  1232. // Unsubscribe all classes from the virtual course
  1233. $sql = "DELETE FROM $table_course_class WHERE course_code='".$virtual_course['code']."'";
  1234. api_sql_query($sql, __FILE__, __LINE__);
  1235. // Unsubscribe all users from the virtual course
  1236. $sql = "DELETE FROM $table_course_user WHERE course_code='".$virtual_course['code']."'";
  1237. api_sql_query($sql, __FILE__, __LINE__);
  1238. // Delete the course from the sessions tables
  1239. $sql = "DELETE FROM $table_session_course WHERE course_code='".$virtual_course['code']."'";
  1240. api_sql_query($sql,__FILE__,__LINE__);
  1241. $sql = "DELETE FROM $table_session_course_user WHERE course_code='".$virtual_course['code']."'";
  1242. api_sql_query($sql,__FILE__,__LINE__);
  1243. // Delete the course from the survey tables
  1244. $sql = "DELETE FROM $table_course_survey WHERE course_code='".$virtual_course['code']."'";
  1245. api_sql_query($sql,__FILE__,__LINE__);
  1246. $sql = "DELETE FROM $table_course_survey_user WHERE db_name='".$virtual_course['db_name']."'";
  1247. api_sql_query($sql,__FILE__,__LINE__);
  1248. $sql = "DELETE FROM $table_course_survey_reminder WHERE db_name='".$virtual_course['db_name']."'";
  1249. api_sql_query($sql,__FILE__,__LINE__);
  1250. // Delete the course from the stats tables
  1251. if($stats)
  1252. {
  1253. $sql = "DELETE FROM $table_stats_hotpots WHERE exe_cours_id = '".$virtual_course['code']."'";
  1254. api_sql_query($sql,__FILE__,__LINE__);
  1255. $sql = "DELETE FROM $table_stats_attempt WHERE course_code = '".$virtual_course['code']."'";
  1256. api_sql_query($sql,__FILE__,__LINE__);
  1257. $sql = "DELETE FROM $table_stats_exercises WHERE exe_cours_id = '".$virtual_course['code']."'";
  1258. api_sql_query($sql,__FILE__,__LINE__);
  1259. $sql = "DELETE FROM $table_stats_access WHERE access_cours_code = '".$virtual_course['code']."'";
  1260. api_sql_query($sql,__FILE__,__LINE__);
  1261. $sql = "DELETE FROM $table_stats_lastaccess WHERE access_cours_code = '".$virtual_course['code']."'";
  1262. api_sql_query($sql,__FILE__,__LINE__);
  1263. $sql = "DELETE FROM $table_stats_course_access WHERE course_code = '".$virtual_course['code']."'";
  1264. api_sql_query($sql,__FILE__,__LINE__);
  1265. $sql = "DELETE FROM $table_stats_online WHERE course = '".$virtual_course['code']."'";
  1266. api_sql_query($sql,__FILE__,__LINE__);
  1267. $sql = "DELETE FROM $table_stats_default WHERE default_cours_code = '".$virtual_course['code']."'";
  1268. api_sql_query($sql,__FILE__,__LINE__);
  1269. $sql = "DELETE FROM $table_stats_downloads WHERE down_cours_id = '".$virtual_course['code']."'";
  1270. api_sql_query($sql,__FILE__,__LINE__);
  1271. $sql = "DELETE FROM $table_stats_links WHERE links_cours_id = '".$virtual_course['code']."'";
  1272. api_sql_query($sql,__FILE__,__LINE__);
  1273. $sql = "DELETE FROM $table_stats_uploads WHERE upload_cours_id = '".$virtual_course['code']."'";
  1274. api_sql_query($sql,__FILE__,__LINE__);
  1275. }
  1276. // Delete the course from the course table
  1277. $sql = "DELETE FROM $table_course WHERE code='".$virtual_course['code']."'";
  1278. api_sql_query($sql, __FILE__, __LINE__);
  1279. }
  1280. $sql = "SELECT * FROM $table_course WHERE code='".$code."'";
  1281. $res = api_sql_query($sql, __FILE__, __LINE__);
  1282. $course = Database::fetch_array($res);
  1283. if (!$_configuration['single_database'])
  1284. {
  1285. $sql = "DROP DATABASE IF EXISTS ".$course['db_name'];
  1286. api_sql_query($sql, __FILE__, __LINE__);
  1287. }
  1288. else
  1289. {
  1290. //TODO Clean the following code as currently it would probably delete another course
  1291. //similarly named, by mistake...
  1292. $db_pattern = $_configuration['table_prefix'].$course['db_name'].$_configuration['db_glue'];
  1293. $sql = "SHOW TABLES LIKE '$db_pattern%'";
  1294. $result = api_sql_query($sql, __FILE__, __LINE__);
  1295. while (list ($courseTable) = Database::fetch_array($result))
  1296. {
  1297. api_sql_query("DROP TABLE `$courseTable`", __FILE__, __LINE__);
  1298. }
  1299. }
  1300. $course_dir = api_get_path(SYS_COURSE_PATH).$course['directory'];
  1301. $garbage_dir = api_get_path(GARBAGE_PATH).$course['directory'].'_'.time();
  1302. rename($course_dir, $garbage_dir);
  1303. }
  1304. // Unsubscribe all classes from the course
  1305. $sql = "DELETE FROM $table_course_class WHERE course_code='".$code."'";
  1306. api_sql_query($sql, __FILE__, __LINE__);
  1307. // Unsubscribe all users from the course
  1308. $sql = "DELETE FROM $table_course_user WHERE course_code='".$code."'";
  1309. api_sql_query($sql, __FILE__, __LINE__);
  1310. // Delete the course from the sessions tables
  1311. $sql = "DELETE FROM $table_session_course WHERE course_code='".$code."'";
  1312. api_sql_query($sql,__FILE__,__LINE__);
  1313. $sql = "DELETE FROM $table_session_course_user WHERE course_code='".$code."'";
  1314. api_sql_query($sql,__FILE__,__LINE__);
  1315. $sql='SELECT survey_id FROM '.$table_course_survey.' WHERE course_code="'.$code.'"';
  1316. $result_surveys=api_sql_query($sql);
  1317. while($surveys=mysql_fetch_array($result_surveys)){
  1318. $survey_id=$surveys[0];
  1319. $sql='DELETE FROM '.$table_course_survey_question.' WHERE survey_id="'.$survey_id.'"';
  1320. api_sql_query($sql,__FILE__,__LINE__);
  1321. $sql='DELETE FROM '.$table_course_survey_question_option.' WHERE survey_id="'.$survey_id.'"';
  1322. api_sql_query($sql,__FILE__,__LINE__);
  1323. $sql='DELETE FROM '.$table_course_survey.' WHERE survey_id="'.$survey_id.'"';
  1324. api_sql_query($sql,__FILE__,__LINE__);
  1325. }
  1326. // Delete the course from the stats tables
  1327. if($stats)
  1328. {
  1329. $sql = "DELETE FROM $table_stats_hotpots WHERE exe_cours_id = '".$code."'";
  1330. api_sql_query($sql,__FILE__,__LINE__);
  1331. $sql = "DELETE FROM $table_stats_attempt WHERE course_code = '".$code."'";
  1332. api_sql_query($sql,__FILE__,__LINE__);
  1333. $sql = "DELETE FROM $table_stats_exercises WHERE exe_cours_id = '".$code."'";
  1334. api_sql_query($sql,__FILE__,__LINE__);
  1335. $sql = "DELETE FROM $table_stats_access WHERE access_cours_code = '".$code."'";
  1336. api_sql_query($sql,__FILE__,__LINE__);
  1337. $sql = "DELETE FROM $table_stats_lastaccess WHERE access_cours_code = '".$code."'";
  1338. api_sql_query($sql,__FILE__,__LINE__);
  1339. $sql = "DELETE FROM $table_stats_course_access WHERE course_code = '".$code."'";
  1340. api_sql_query($sql,__FILE__,__LINE__);
  1341. $sql = "DELETE FROM $table_stats_online WHERE course = '".$code."'";
  1342. api_sql_query($sql,__FILE__,__LINE__);
  1343. $sql = "DELETE FROM $table_stats_default WHERE default_cours_code = '".$code."'";
  1344. api_sql_query($sql,__FILE__,__LINE__);
  1345. $sql = "DELETE FROM $table_stats_downloads WHERE down_cours_id = '".$code."'";
  1346. api_sql_query($sql,__FILE__,__LINE__);
  1347. $sql = "DELETE FROM $table_stats_links WHERE links_cours_id = '".$code."'";
  1348. api_sql_query($sql,__FILE__,__LINE__);
  1349. $sql = "DELETE FROM $table_stats_uploads WHERE upload_cours_id = '".$code."'";
  1350. api_sql_query($sql,__FILE__,__LINE__);
  1351. }
  1352. // Delete the course from the database
  1353. $sql = "DELETE FROM $table_course WHERE code='".$code."'";
  1354. api_sql_query($sql, __FILE__, __LINE__);
  1355. }
  1356. /**
  1357. * Creates a file called mysql_dump.sql in the course folder
  1358. * @param $course_code The code of the course
  1359. * @todo Implementation for single database
  1360. */
  1361. function create_database_dump($course_code)
  1362. {
  1363. global $_configuration;
  1364. if ($_configuration['single_database'])
  1365. {
  1366. return;
  1367. }
  1368. $sql_dump = '';
  1369. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  1370. $sql = "SELECT * FROM $table_course WHERE code = '$course_code'";
  1371. $res = api_sql_query($sql, __FILE__, __LINE__);
  1372. $course = Database::fetch_array($res);
  1373. $sql = "SHOW TABLES FROM ".$course['db_name'];
  1374. $res = api_sql_query($sql, __FILE__, __LINE__);
  1375. while ($table = Database::fetch_array($res))
  1376. {
  1377. $sql = "SELECT * FROM `".$course['db_name']."`.`".$table[0]."`";
  1378. $res3 = api_sql_query($sql, __FILE__, __LINE__);
  1379. while ($row = Database::fetch_array($res3))
  1380. {
  1381. foreach ($row as $key => $value)
  1382. {
  1383. $row[$key] = $key."='".addslashes($row[$key])."'";
  1384. }
  1385. $sql_dump .= "\nINSERT INTO $table[0] SET ".implode(', ', $row).';';
  1386. }
  1387. }
  1388. $file_name = api_get_path(SYS_COURSE_PATH).$course['directory'].'/mysql_dump.sql';
  1389. $handle = fopen($file_name, 'a+');
  1390. if($handle!==false){
  1391. fwrite($handle, $sql_dump);
  1392. fclose($handle);
  1393. }else{
  1394. //TODO trigger exception in a try-catch
  1395. }
  1396. }
  1397. function userCourseSort($user_id,$course_code){
  1398. $TABLECOURSE = Database :: get_main_table(TABLE_MAIN_COURSE);
  1399. $TABLECOURSUSER = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  1400. $sql = 'SELECT title FROM '.$TABLECOURSE.' WHERE code="'.$course_code.'"';
  1401. $result = api_sql_query($sql, __FILE__, __LINE__);
  1402. $course_title = mysql_result($result,0,0);
  1403. $sql = 'SELECT course.code as code, course.title as title, cu.sort as sort FROM '.$TABLECOURSUSER.' as cu, '.$TABLECOURSE.' as course
  1404. WHERE course.code = cu.course_code
  1405. AND user_id = "'.$user_id.'"
  1406. AND user_course_cat=0 ORDER BY cu.sort';
  1407. $result = api_sql_query($sql, __FILE__, __LINE__);
  1408. $s_course_title_precedent = '';
  1409. $counter = 0;
  1410. $b_find_course = false;
  1411. $i_course_sort = 1;
  1412. while($courses=mysql_fetch_array($result)){
  1413. if($s_course_title_precedent == ''){
  1414. $s_course_title_precedent = $courses['title'];
  1415. }
  1416. if(strcasecmp($s_course_title_precedent,$course_title)<0){
  1417. $b_find_course = true;
  1418. $i_course_sort = $courses['sort'];
  1419. $s_course_code = $courses['code'];
  1420. if($counter == 0){
  1421. $sql = 'UPDATE '.$TABLECOURSUSER.' SET sort = sort+1 WHERE user_id= "'.$user_id.'" AND user_course_cat="0" AND sort > "'.$i_course_sort.'"';
  1422. $i_course_sort++;
  1423. }
  1424. else{
  1425. $sql = 'UPDATE '.$TABLECOURSUSER.' SET sort = sort+1 WHERE user_id= "'.$user_id.'" AND user_course_cat="0" AND sort >= "'.$i_course_sort.'"';
  1426. }
  1427. api_sql_query($sql, __FILE__, __LINE__);
  1428. break;
  1429. }
  1430. else{
  1431. $s_course_title_precedent = $courses['title'];
  1432. }
  1433. $counter++;
  1434. }
  1435. //We must register the course in the beginning of the list
  1436. if(mysql_num_rows($result)>0 && !$b_find_course){
  1437. $sql_max = 'SELECT min(sort) as min_sort FROM '.$TABLECOURSUSER.' WHERE user_id="'.$user_id.'" AND user_course_cat="0"';
  1438. $result_min_sort=api_sql_query($sql_max);
  1439. $i_course_sort = mysql_result($result_min_sort,0,0);
  1440. $sql = 'UPDATE '.$TABLECOURSUSER.' SET sort = sort+1 WHERE user_id= "'.$user_id.'" AND user_course_cat="0"';
  1441. api_sql_query($sql);
  1442. }
  1443. return $i_course_sort;
  1444. }
  1445. /**
  1446. * create recursively all categories as option of the select passed in paramater.
  1447. *
  1448. * @param object $select_element the quickform select where the options will be added
  1449. * @param string $category_selected_code the option value to select by default (used mainly for edition of courses)
  1450. * @param string $parent_code the parent category of the categories added (default=null for root category)
  1451. * @param string $padding the indent param (you shouldn't indicate something here)
  1452. */
  1453. function select_and_sort_categories($select_element, $category_selected_code="", $parent_code=null , $padding="")
  1454. {
  1455. $table_course_category = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  1456. $sql = "SELECT code, name, auth_course_child, auth_cat_child
  1457. FROM ".$table_course_category."
  1458. WHERE parent_id ".(is_null($parent_code) ? "IS NULL" : "='".Database::escape_string($parent_code)."'")."
  1459. ORDER BY code";
  1460. $res = api_sql_query($sql, __FILE__, __LINE__);
  1461. $new_padding = $padding.str_repeat('-',3);
  1462. while ($cat = Database::fetch_array($res))
  1463. {
  1464. $params = $cat['auth_course_child'] == 'TRUE' ? '' : 'disabled';
  1465. $params .= ($cat['code'] == $category_selected_code) ? ' selected' : '';
  1466. $select_element->addOption($padding.'('.$cat['code'].') '.$cat['name'], $cat['code'], $params);
  1467. if($cat['auth_cat_child'])
  1468. {
  1469. CourseManager::select_and_sort_categories($select_element, $cat['code'], $category_selected_code, $new_padding);
  1470. }
  1471. }
  1472. }
  1473. } //end class CourseManager
  1474. ?>