registerFunction('search_courses'); // setting the section (for the tabs) $this_section = SECTION_PLATFORM_ADMIN; // Access restrictions api_protect_admin_script(true); // setting breadcrumbs $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array('url' => 'user_list.php','name' => get_lang('UserList')); // Database Table Definitions $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); $tbl_course_rel_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $tbl_course_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); // initializing variables $user_id = intval($_GET['user']); $user_info = api_get_user_info($user_id); $user_anonymous = api_get_anonymous_id(); $current_user_id = api_get_user_id(); // setting the name of the tool if (UserManager::is_admin($user_id)) { $tool_name= get_lang('AssignCoursesToPlatformAdministrator'); } else if ($user_info['status'] == SESSIONADMIN) { $tool_name= get_lang('AssignCoursesToSessionsAdministrator'); } else { $tool_name= get_lang('AssignCoursesToHumanResourcesManager'); } $add_type = 'multiple'; if(isset($_GET['add_type']) && $_GET['add_type']!='') { $add_type = Security::remove_XSS($_REQUEST['add_type']); } if (!api_is_platform_admin()) { api_not_allowed(true); } function search_courses($needle, $type) { global $_configuration, $tbl_course, $tbl_course_rel_access_url,$user_id; $xajax_response = new XajaxResponse(); $return = ''; if (!empty($needle) && !empty($type)) { // xajax send utf8 datas... datas in db can be non-utf8 datas $charset = api_get_system_encoding(); $needle = api_convert_encoding($needle, $charset, 'utf-8'); $needle = Database::escape_string($needle); $assigned_courses_to_hrm = CourseManager::get_courses_followed_by_drh($user_id); $assigned_courses_code = array_keys($assigned_courses_to_hrm); foreach ($assigned_courses_code as &$value) { $value = "'".$value."'"; } $without_assigned_courses = ''; if (count($assigned_courses_code) > 0) { $without_assigned_courses = " AND c.code NOT IN(".implode(',',$assigned_courses_code).")"; } if ($_configuration['multiple_access_urls']) { $sql = "SELECT c.code, c.title FROM $tbl_course c LEFT JOIN $tbl_course_rel_access_url a ON (a.course_code = c.code) WHERE c.code LIKE '$needle%' $without_assigned_courses AND access_url_id = ".api_get_current_access_url_id().""; } else { $sql = "SELECT c.code, c.title FROM $tbl_course c WHERE c.code LIKE '$needle%' $without_assigned_courses "; } $rs = Database::query($sql); $return .= ''; $xajax_response -> addAssign('ajax_list_courses_multiple','innerHTML',api_utf8_encode($return)); } return $xajax_response; } $xajax->processRequests(); $htmlHeadXtra[] = $xajax->getJavascript('../inc/lib/xajax/'); $htmlHeadXtra[] = ' '; $formSent=0; $errorMsg = $firstLetterCourse = ''; $UserList = array(); $msg = ''; if (isset($_POST['formSent']) && intval($_POST['formSent']) == 1) { $courses_list = $_POST['CoursesList']; $affected_rows = CourseManager::suscribe_courses_to_hr_manager($user_id,$courses_list); if ($affected_rows) { $msg = get_lang('AssignedCoursesHaveBeenUpdatedSuccessfully'); } } // display header Display::display_header($tool_name); // actions echo '
'; echo Display::page_header(sprintf(get_lang('AssignCoursesToX'), api_get_person_name($user_info['firstname'], $user_info['lastname']))); $assigned_courses_to_hrm = CourseManager::get_courses_followed_by_drh($user_id); $assigned_courses_code = array_keys($assigned_courses_to_hrm); foreach ($assigned_courses_code as &$value) { $value = "'".$value."'"; } $without_assigned_courses = ''; if (count($assigned_courses_code) > 0) { $without_assigned_courses = " AND c.code NOT IN(".implode(',',$assigned_courses_code).")"; } $needle = '%'; $firstLetter = null; if (isset($_POST['firstLetterCourse'])) { $firstLetter = $_POST['firstLetterCourse']; $needle = Database::escape_string($firstLetter.'%'); } if (api_is_multiple_url_enabled()) { $sql = " SELECT c.code, c.title FROM $tbl_course c LEFT JOIN $tbl_course_rel_access_url a ON (a.course_code = c.code) WHERE c.code LIKE '$needle' $without_assigned_courses AND access_url_id = ".api_get_current_access_url_id()." ORDER BY c.title"; } else { $sql= " SELECT c.code, c.title FROM $tbl_course c WHERE c.code LIKE '$needle' $without_assigned_courses ORDER BY c.title"; } $result = Database::query($sql); ?>