add_courses_to_session_functions.lib.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Definition of the AddCourseToSession class
  5. * @package chamilo.library
  6. */
  7. /**
  8. * Init
  9. */
  10. require_once dirname(__FILE__).'/xajax/xajax.inc.php';
  11. //require_once (api_get_path(SYS_CODE_PATH).'admin/add_courses_to_session.php');
  12. /**
  13. * AddCourseToSession class
  14. */
  15. class AddCourseToSession {
  16. /**
  17. * Searches a course, given a search string and a type of search box
  18. * @param string Search string
  19. * @param string Type of search box ('single' or anything else)
  20. * @return string XajaxResponse
  21. * @assert () !== null
  22. * @assert ('abc', 'single') !== null
  23. * @assert ('abc', 'multiple') !== null
  24. */
  25. public function search_courses($needle,$type) {
  26. global $tbl_course, $tbl_session_rel_course, $id_session;
  27. $xajax_response = new XajaxResponse();
  28. $return = '';
  29. if(!empty($needle) && !empty($type)) {
  30. // xajax send utf8 datas... datas in db can be non-utf8 datas
  31. $charset = api_get_system_encoding();
  32. $needle = api_convert_encoding($needle, $charset, 'utf-8');
  33. $cond_course_code = '';
  34. if (!empty($id_session)) {
  35. $id_session = Database::escape_string($id_session);
  36. // check course_code from session_rel_course table
  37. $sql = 'SELECT course_code FROM '.$tbl_session_rel_course.' WHERE id_session ="'.(int)$id_session.'"';
  38. $res = Database::query($sql);
  39. $course_codes = '';
  40. if (Database::num_rows($res) > 0) {
  41. while ($row = Database::fetch_row($res)) {
  42. $course_codes .= '\''.$row[0].'\',';
  43. }
  44. $course_codes = substr($course_codes,0,(strlen($course_codes)-1));
  45. $cond_course_code = ' AND course.code NOT IN('.$course_codes.') ';
  46. }
  47. }
  48. if ($type=='single') {
  49. // search users where username or firstname or lastname begins likes $needle
  50. $sql = 'SELECT course.code, course.visual_code, course.title, session_rel_course.id_session
  51. FROM '.$tbl_course.' course
  52. LEFT JOIN '.$tbl_session_rel_course.' session_rel_course
  53. ON course.code = session_rel_course.course_code
  54. AND session_rel_course.id_session = '.intval($id_session).'
  55. WHERE course.visual_code LIKE "'.$needle.'%"
  56. OR course.title LIKE "'.$needle.'%"';
  57. } else {
  58. $sql = 'SELECT course.code, course.visual_code, course.title
  59. FROM '.$tbl_course.' course
  60. WHERE course.visual_code LIKE "'.$needle.'%" '.$cond_course_code.' ORDER BY course.code ';
  61. }
  62. global $_configuration;
  63. if ($_configuration['multiple_access_urls']) {
  64. $tbl_course_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  65. $access_url_id = api_get_current_access_url_id();
  66. if ($access_url_id != -1){
  67. if ($type=='single') {
  68. $sql = 'SELECT course.code, course.visual_code, course.title, session_rel_course.id_session
  69. FROM '.$tbl_course.' course
  70. LEFT JOIN '.$tbl_session_rel_course.' session_rel_course
  71. ON course.code = session_rel_course.course_code
  72. AND session_rel_course.id_session = '.intval($id_session).'
  73. INNER JOIN '.$tbl_course_rel_access_url.' url_course ON (url_course.course_code=course.code)
  74. WHERE access_url_id = '.$access_url_id.' AND (course.visual_code LIKE "'.$needle.'%"
  75. OR course.title LIKE "'.$needle.'%" )';
  76. } else {
  77. $sql = 'SELECT course.code, course.visual_code, course.title
  78. FROM '.$tbl_course.' course, '.$tbl_course_rel_access_url.' url_course
  79. WHERE url_course.course_code=course.code AND access_url_id = '.$access_url_id.'
  80. AND course.visual_code LIKE "'.$needle.'%" '.$cond_course_code.' ORDER BY course.code ';
  81. }
  82. }
  83. }
  84. $rs = Database::query($sql);
  85. $course_list = array();
  86. if ($type=='single') {
  87. while($course = Database :: fetch_array($rs)) {
  88. $course_list[] = $course['code'];
  89. $course_title=str_replace("'","\'",$course_title);
  90. $return .= '<a href="javascript: void(0);" onclick="javascript: add_course_to_session(\''.$course['code'].'\',\''.$course_title.' ('.$course['visual_code'].')'.'\')">'.$course['title'].' ('.$course['visual_code'].')</a><br />';
  91. }
  92. $xajax_response -> addAssign('ajax_list_courses_single','innerHTML',api_utf8_encode($return));
  93. } else {
  94. $return .= '<select id="origin" name="NoSessionCoursesList[]" multiple="multiple" size="20" style="width:340px;">';
  95. while($course = Database :: fetch_array($rs)) {
  96. $course_list[] = $course['code'];
  97. $course_title=str_replace("'","\'",$course_title);
  98. $return .= '<option value="'.$course['code'].'" title="'.htmlspecialchars($course['title'].' ('.$course['visual_code'].')',ENT_QUOTES).'">'.$course['title'].' ('.$course['visual_code'].')</option>';
  99. }
  100. $return .= '</select>';
  101. $xajax_response -> addAssign('ajax_list_courses_multiple','innerHTML',api_utf8_encode($return));
  102. }
  103. }
  104. $_SESSION['course_list'] = $course_list;
  105. return $xajax_response;
  106. }
  107. }