, 2010 * Centro de Supercomputacion de Galicia (CESGA) * * @author Ivan Tcholakov (technical adaptation for Chamilo 1.8.8), 2010 */ $cidReset = true; require_once __DIR__.'/../inc/global.inc.php'; $this_section = SECTION_PLATFORM_ADMIN; api_protect_admin_script(); // The delete action should be deactivated in this page. // Better reject the target request, after that you can delete it. // see DELETE_ACTION_ENABLED constant in main_api.lib.php // A check whether the course validation feature is enabled. $course_validation_feature = api_get_setting('course_validation') == 'true'; // Filltering passed to this page parameters. $accept_course_request = isset($_GET['accept_course_request']) ? intval($_GET['accept_course_request']) : ''; $reject_course_request = isset($_GET['reject_course_request']) ? intval($_GET['reject_course_request']) : ''; $request_info = isset($_GET['request_info']) ? intval($_GET['request_info']) : ''; $delete_course_request = isset($_GET['delete_course_request']) ? intval($_GET['delete_course_request']) : ''; $message = isset($_GET['message']) ? trim(Security::remove_XSS(stripslashes(urldecode($_GET['message'])))) : ''; $is_error_message = isset($_GET['is_error_message']) ? !empty($_GET['is_error_message']) : ''; $keyword = isset($_GET['keyword']) ? Database::escape_string(trim($_GET['keyword'])) : ''; if ($course_validation_feature) { /** * Course acceptance and creation. */ if (!empty($accept_course_request)) { $course_request_code = CourseRequestManager::get_course_request_code($accept_course_request); $course_id = CourseRequestManager::accept_course_request($accept_course_request); if ($course_id) { $course_code = CourseManager::get_course_code_from_course_id($course_id); $message = sprintf(get_lang('CourseRequestAccepted'), $course_request_code, $course_code); $is_error_message = false; } else { $message = sprintf(get_lang('CourseRequestAcceptanceFailed'), $course_request_code); $is_error_message = true; } } elseif (!empty($reject_course_request)) { /** * Course rejection */ $course_request_code = CourseRequestManager::get_course_request_code($reject_course_request); $result = CourseRequestManager::reject_course_request($reject_course_request); if ($result) { $message = sprintf(get_lang('CourseRequestRejected'), $course_request_code); $is_error_message = false; } else { $message = sprintf(get_lang('CourseRequestRejectionFailed'), $course_request_code); $is_error_message = true; } } elseif (!empty($request_info)) { /** * Sending to the teacher a request for additional information about the proposed course. */ $course_request_code = CourseRequestManager::get_course_request_code($request_info); $result = CourseRequestManager::ask_for_additional_info($request_info); if ($result) { $message = sprintf(get_lang('CourseRequestInfoAsked'), $course_request_code); $is_error_message = false; } else { $message = sprintf(get_lang('CourseRequestInfoFailed'), $course_request_code); $is_error_message = true; } } elseif (!empty($delete_course_request)) { /** * Deletion of a course request. */ $course_request_code = CourseRequestManager::get_course_request_code($delete_course_request); $result = CourseRequestManager::delete_course_request($delete_course_request); if ($result) { $message = sprintf(get_lang('CourseRequestDeleted'), $course_request_code); $is_error_message = false; } else { $message = sprintf(get_lang('CourseRequestDeletionFailed'), $course_request_code); $is_error_message = true; } } elseif (DELETE_ACTION_ENABLED && isset($_POST['action'])) { /** * Form actions: delete. */ switch ($_POST['action']) { // Delete selected courses case 'delete_course_requests': $course_requests = $_POST['course_request']; if (is_array($_POST['course_request']) && !empty($_POST['course_request'])) { $success = true; foreach ($_POST['course_request'] as $index => $course_request_id) { $success &= CourseRequestManager::delete_course_request($course_request_id); } $message = $success ? get_lang('SelectedCourseRequestsDeleted') : get_lang('SomeCourseRequestsNotDeleted'); $is_error_message = !$success; } break; } } } else { $link_to_setting = api_get_path(WEB_CODE_PATH).'admin/settings.php?category=Platform#course_validation'; $message = sprintf(get_lang('PleaseActivateCourseValidationFeature'), sprintf('%s', $link_to_setting, get_lang('EnableCourseValidation'))); $is_error_message = true; } /** * Get the number of courses which will be displayed. */ function get_number_of_requests() { return CourseRequestManager::count_course_requests(COURSE_REQUEST_PENDING); } /** * Get course data to display */ function get_request_data($from, $number_of_items, $column, $direction) { global $keyword; $course_request_table = Database::get_main_table(TABLE_MAIN_COURSE_REQUEST); if (DELETE_ACTION_ENABLED) { $sql = "SELECT id AS col0, code AS col1, title AS col2, category_code AS col3, tutor_name AS col4, request_date AS col5, id AS col6 FROM $course_request_table WHERE status = ".COURSE_REQUEST_PENDING; } else { $sql = "SELECT code AS col0, title AS col1, category_code AS col2, tutor_name AS col3, request_date AS col4, id AS col5 FROM $course_request_table WHERE status = ".COURSE_REQUEST_PENDING; } if ($keyword != '') { $sql .= " AND (title LIKE '%".$keyword."%' OR code LIKE '%".$keyword."%' OR visual_code LIKE '%".$keyword."%')"; } $sql .= " ORDER BY col$column $direction "; $sql .= " LIMIT $from,$number_of_items"; $res = Database::query($sql); $course_requests = array(); while ($course_request = Database::fetch_row($res)) { if (DELETE_ACTION_ENABLED) { $course_request[5] = api_get_local_time($course_request[5]); } else { $course_request[4] = api_get_local_time($course_request[4]); } $course_requests[] = $course_request; } return $course_requests; } /** * Enlace a la ficha del profesor */ function email_filter($teacher) { $sql = "SELECT user_id FROM ".Database::get_main_table(TABLE_MAIN_COURSE_REQUEST)." WHERE tutor_name LIKE '".$teacher."'"; $res = Database::query($sql); $info = Database::fetch_array($res); return ''.$teacher.''; } /** * Actions in the list: edit, accept, reject, request additional information. */ function modify_filter($id) { $code = CourseRequestManager::get_course_request_code($id); $result = ''.Display::return_icon('edit.png', get_lang('Edit'), array('style' => 'vertical-align: middle;')).''. ' '.Display::return_icon('accept.png', get_lang('AcceptThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ANewCourseWillBeCreated'), $code), ENT_QUOTES)).'\')) return false;'), 16).''. ' '.Display::return_icon('error.png', get_lang('RejectThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeRejected'), $code), ENT_QUOTES)).'\')) return false;'), 16).''; if (!CourseRequestManager::additional_info_asked($id)) { $result .= ' '.Display::return_icon('request_info.gif', get_lang('AskAdditionalInfo'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('AdditionalInfoWillBeAsked'), $code), ENT_QUOTES)).'\')) return false;')).''; } if (DELETE_ACTION_ENABLED) { $result .= ' '.Display::return_icon('delete.png', get_lang('DeleteThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeDeleted'), $code), ENT_QUOTES)).'\')) return false;')).''; } return $result; } $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array('url' => 'course_list.php', 'name' => get_lang('CourseList')); $tool_name = get_lang('ReviewCourseRequests'); Display :: display_header($tool_name); // Display confirmation or error message. if (!empty($message)) { if ($is_error_message) { Display::addFlash(Display::return_message($message, 'error', false)); } else { Display::addFlash(Display::return_message($message, 'normal', false)); } } if (!$course_validation_feature) { Display :: display_footer(); exit; } // Create a simple search-box. $form = new FormValidator('search_simple', 'get', '', '', 'width=200px', false); $renderer = $form->defaultRenderer(); $renderer->setCustomElementTemplate('{element} '); $form->addElement('text', 'keyword', get_lang('Keyword')); $form->addButtonSearch(get_lang('Search')); // The action bar. echo '
'; //echo ''.Display::return_icon('courses.gif', get_lang('CourseList')).get_lang('CourseList').''; echo ' '.Display::return_icon('course_request_accepted.gif', get_lang('AcceptedCourseRequests')).get_lang('AcceptedCourseRequests').''; echo ' '.Display::return_icon('course_request_rejected.gif', get_lang('RejectedCourseRequests')).get_lang('RejectedCourseRequests').''; echo '
'; echo '
'; $form->display(); echo '
'; // Create a sortable table with the course data. $offet = DELETE_ACTION_ENABLED ? 1 : 0; $table = new SortableTable('course_requests_review', 'get_number_of_requests', 'get_request_data', 4 + $offet, 20, 'DESC'); //$table->set_additional_parameters($parameters); if (DELETE_ACTION_ENABLED) { $table->set_header(0, '', false); } $table->set_header(0 + $offet, get_lang('Code')); $table->set_header(1 + $offet, get_lang('Title')); $table->set_header(2 + $offet, get_lang('Category')); $table->set_header(3 + $offet, get_lang('Teacher')); $table->set_header(4 + $offet, get_lang('CourseRequestDate')); $table->set_header(5 + $offet, '', false); $table->set_column_filter(3 + $offet, 'email_filter'); $table->set_column_filter(5 + $offet, 'modify_filter'); if (DELETE_ACTION_ENABLED) { $table->set_form_actions(array('delete_course_requests' => get_lang('DeleteCourseRequests')), 'course_request'); } $table->display(); Display :: display_footer();