course_request_rejected.php 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * A list containing the rejected course requests
  5. * @package chamilo.admin
  6. * @author José Manuel Abuin Mosquera <chema@cesga.es>, 2010
  7. * @author Bruno Rubio Gayo <brubio@cesga.es>, 2010
  8. * Centro de Supercomputacion de Galicia (CESGA)
  9. *
  10. * @author Ivan Tcholakov <ivantcholakov@gmail.com> (technical adaptation for Chamilo 1.8.8), 2010
  11. */
  12. $cidReset = true;
  13. require_once __DIR__.'/../inc/global.inc.php';
  14. $this_section = SECTION_PLATFORM_ADMIN;
  15. api_protect_admin_script();
  16. // A check whether the course validation feature is enabled.
  17. $course_validation_feature = api_get_setting('course_validation') == 'true';
  18. // Filltering passed to this page parameters.
  19. $accept_course_request = isset($_GET['accept_course_request']) ? intval($_GET['accept_course_request']) : '';
  20. $delete_course_request = isset($_GET['delete_course_request']) ? intval($_GET['delete_course_request']) : '';
  21. $request_info = isset($_GET['request_info']) ? intval($_GET['request_info']) : '';
  22. $message = isset($_GET['message']) ? trim(Security::remove_XSS(stripslashes(urldecode($_GET['message'])))) : '';
  23. $is_error_message = !empty($_GET['is_error_message']);
  24. if ($course_validation_feature) {
  25. /**
  26. * Acceptance and creation of the requested course.
  27. */
  28. if (!empty($accept_course_request)) {
  29. $course_request_code = CourseRequestManager::get_course_request_code($accept_course_request);
  30. $course_id = CourseRequestManager::accept_course_request($accept_course_request);
  31. if ($course_id) {
  32. $course_code = CourseManager::get_course_code_from_course_id($course_id);
  33. $message = sprintf(get_lang('CourseRequestAccepted'), $course_request_code, $course_code);
  34. $is_error_message = false;
  35. } else {
  36. $message = sprintf(get_lang('CourseRequestAcceptanceFailed'), $course_request_code);
  37. $is_error_message = true;
  38. }
  39. } elseif (!empty($request_info)) {
  40. /**
  41. * Sending to the teacher a request for additional information about the proposed course.
  42. */
  43. $course_request_code = CourseRequestManager::get_course_request_code($request_info);
  44. $result = CourseRequestManager::ask_for_additional_info($request_info);
  45. if ($result) {
  46. $message = sprintf(get_lang('CourseRequestInfoAsked'), $course_request_code);
  47. $is_error_message = false;
  48. } else {
  49. $message = sprintf(get_lang('CourseRequestInfoFailed'), $course_request_code);
  50. $is_error_message = true;
  51. }
  52. } elseif (!empty($delete_course_request)) {
  53. /**
  54. * Deletion of a course request.
  55. */
  56. $course_request_code = CourseRequestManager::get_course_request_code($delete_course_request);
  57. $result = CourseRequestManager::delete_course_request($delete_course_request);
  58. if ($result) {
  59. $message = sprintf(get_lang('CourseRequestDeleted'), $course_request_code);
  60. $is_error_message = false;
  61. } else {
  62. $message = sprintf(get_lang('CourseRequestDeletionFailed'), $course_request_code);
  63. $is_error_message = true;
  64. }
  65. } elseif (isset($_POST['action'])) {
  66. /**
  67. * Form actions: delete.
  68. */
  69. switch ($_POST['action']) {
  70. // Delete selected courses
  71. case 'delete_course_requests':
  72. $course_requests = $_POST['course_request'];
  73. if (is_array($_POST['course_request']) && !empty($_POST['course_request'])) {
  74. $success = true;
  75. foreach ($_POST['course_request'] as $index => $course_request_id) {
  76. $success &= CourseRequestManager::delete_course_request($course_request_id);
  77. }
  78. $message = $success ? get_lang('SelectedCourseRequestsDeleted') : get_lang('SomeCourseRequestsNotDeleted');
  79. $is_error_message = !$success;
  80. }
  81. break;
  82. }
  83. }
  84. } else {
  85. $link_to_setting = api_get_path(WEB_CODE_PATH).'admin/settings.php?category=Platform#course_validation';
  86. $message = sprintf(
  87. get_lang('PleaseActivateCourseValidationFeature'),
  88. sprintf('<strong><a href="%s">%s</a></strong>', $link_to_setting, get_lang('EnableCourseValidation'))
  89. );
  90. $is_error_message = true;
  91. }
  92. /**
  93. * Get the number of courses which will be displayed.
  94. */
  95. function get_number_of_requests()
  96. {
  97. return CourseRequestManager::count_course_requests(COURSE_REQUEST_REJECTED);
  98. }
  99. /**
  100. * Get course data to display
  101. */
  102. function get_request_data($from, $number_of_items, $column, $direction)
  103. {
  104. $keyword = isset($_GET['keyword']) ? Database::escape_string(trim($_GET['keyword'])) : '';
  105. $course_request_table = Database::get_main_table(TABLE_MAIN_COURSE_REQUEST);
  106. $from = intval($from);
  107. $number_of_items = intval($number_of_items);
  108. $column = intval($column);
  109. $direction = !in_array(strtolower(trim($direction)), ['asc', 'desc']) ? 'asc' : $direction;
  110. $sql = "SELECT
  111. id AS col0,
  112. code AS col1,
  113. title AS col2,
  114. category_code AS col3,
  115. tutor_name AS col4,
  116. request_date AS col5,
  117. id AS col6
  118. FROM $course_request_table
  119. WHERE status = ".COURSE_REQUEST_REJECTED;
  120. if ($keyword != '') {
  121. $sql .= " AND (
  122. title LIKE '%".$keyword."%' OR
  123. code LIKE '%".$keyword."%' OR
  124. visual_code LIKE '%".$keyword."%'
  125. )";
  126. }
  127. $sql .= " ORDER BY col$column $direction ";
  128. $sql .= " LIMIT $from,$number_of_items";
  129. $res = Database :: query($sql);
  130. $course_requests = array();
  131. while ($course_request = Database :: fetch_row($res)) {
  132. $course_request[5] = api_get_local_time($course_request[5]);
  133. $course_requests[] = $course_request;
  134. }
  135. return $course_requests;
  136. }
  137. /**
  138. * Actions in the list: edit, accept, delete, request additional information.
  139. */
  140. function modify_filter($id)
  141. {
  142. $code = CourseRequestManager::get_course_request_code($id);
  143. $result = '<a href="course_request_edit.php?id='.$id.'&caller=2">'.
  144. Display::return_icon('edit.png', get_lang('Edit'), array('style' => 'vertical-align: middle;')).'</a>'.
  145. '&nbsp;<a href="?accept_course_request='.$id.'">'.
  146. Display::return_icon(
  147. 'accept.png',
  148. get_lang('AcceptThisCourseRequest'),
  149. array(
  150. 'style' => 'vertical-align: middle;',
  151. 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ANewCourseWillBeCreated'), $code), ENT_QUOTES)).'\')) return false;',
  152. )
  153. ).
  154. '</a>';
  155. if (!CourseRequestManager::additional_info_asked($id)) {
  156. $result .= '&nbsp;<a href="?request_info='.$id.'">'.
  157. Display::return_icon(
  158. 'request_info.gif',
  159. get_lang('AskAdditionalInfo'),
  160. array(
  161. 'style' => 'vertical-align: middle;',
  162. 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('AdditionalInfoWillBeAsked'), $code), ENT_QUOTES)).'\')) return false;',
  163. )
  164. ).
  165. '</a>';
  166. }
  167. $result .= '&nbsp;<a href="?delete_course_request='.$id.'">'.
  168. Display::return_icon(
  169. 'delete.png',
  170. get_lang('DeleteThisCourseRequest'),
  171. array(
  172. 'style' => 'vertical-align: middle;',
  173. 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeDeleted'), $code), ENT_QUOTES)).'\')) return false;',
  174. )
  175. ).
  176. '</a>';
  177. return $result;
  178. }
  179. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  180. $interbreadcrumb[] = array('url' => 'course_list.php', 'name' => get_lang('CourseList'));
  181. $tool_name = get_lang('RejectedCourseRequests');
  182. // Display confirmation or error message.
  183. if (!empty($message)) {
  184. if ($is_error_message) {
  185. Display::addFlash(Display::return_message($message, 'error', false));
  186. } else {
  187. Display::addFlash(Display::return_message($message, 'normal', false));
  188. }
  189. }
  190. Display::display_header($tool_name);
  191. if (!$course_validation_feature) {
  192. Display :: display_footer();
  193. exit;
  194. }
  195. // Create a simple search-box.
  196. $form = new FormValidator('search_simple', 'get', '', '', 'width=200px', false);
  197. $renderer = $form->defaultRenderer();
  198. $renderer->setCustomElementTemplate('<span>{element}</span> ');
  199. $form->addElement('text', 'keyword', get_lang('Keyword'));
  200. $form->addButtonSearch(get_lang('Search'));
  201. // The action bar.
  202. echo '<div style="float: right; margin-top: 5px; margin-right: 5px;">';
  203. echo ' <a href="course_request_review.php">'.
  204. Display::return_icon('course_request_pending.png', get_lang('ReviewCourseRequests')).get_lang('ReviewCourseRequests').
  205. '</a>';
  206. echo ' <a href="course_request_accepted.php">'.
  207. Display::return_icon('course_request_accepted.gif', get_lang('AcceptedCourseRequests')).get_lang('AcceptedCourseRequests').
  208. '</a>';
  209. echo '</div>';
  210. echo '<div class="actions">';
  211. $form->display();
  212. echo '</div>';
  213. // Create a sortable table with the course data.
  214. $table = new SortableTable('course_requests_rejected', 'get_number_of_requests', 'get_request_data', 5, 20, 'DESC');
  215. $table->set_header(0, '', false);
  216. $table->set_header(1, get_lang('Code'));
  217. $table->set_header(2, get_lang('Title'));
  218. $table->set_header(3, get_lang('Category'));
  219. $table->set_header(4, get_lang('Teacher'));
  220. $table->set_header(5, get_lang('CourseRequestDate'));
  221. $table->set_header(6, '', false);
  222. $table->set_column_filter(6, 'modify_filter');
  223. $table->set_form_actions(array('delete_course_requests' => get_lang('DeleteCourseRequests')), 'course_request');
  224. $table->display();
  225. Display::display_footer();