course_request_accepted.php 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * A list containig the accepted 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. $delete_course_request = isset($_GET['delete_course_request']) ? intval($_GET['delete_course_request']) : '';
  20. $message = isset($_GET['message']) ? trim(Security::remove_XSS(stripslashes(urldecode($_GET['message'])))) : '';
  21. $is_error_message = !empty($_GET['is_error_message']);
  22. if ($course_validation_feature) {
  23. /**
  24. * Deletion of a course request.
  25. */
  26. if (!empty($delete_course_request)) {
  27. $course_request_code = CourseRequestManager::get_course_request_code($delete_course_request);
  28. $result = CourseRequestManager::delete_course_request($delete_course_request);
  29. if ($result) {
  30. $message = sprintf(get_lang('CourseRequestDeleted'), $course_request_code);
  31. $is_error_message = false;
  32. } else {
  33. $message = sprintf(get_lang('CourseRequestDeletionFailed'), $course_request_code);
  34. $is_error_message = true;
  35. }
  36. } elseif (isset($_POST['action'])) {
  37. /**
  38. * Form actions: delete.
  39. */
  40. switch ($_POST['action']) {
  41. // Delete selected courses
  42. case 'delete_course_requests':
  43. $course_requests = $_POST['course_request'];
  44. if (is_array($_POST['course_request']) && !empty($_POST['course_request'])) {
  45. $success = true;
  46. foreach ($_POST['course_request'] as $index => $course_request_id) {
  47. $success &= CourseRequestManager::delete_course_request($course_request_id);
  48. }
  49. $message = $success ? get_lang('SelectedCourseRequestsDeleted') : get_lang('SomeCourseRequestsNotDeleted');
  50. $is_error_message = !$success;
  51. }
  52. break;
  53. }
  54. }
  55. } else {
  56. $link_to_setting = api_get_path(WEB_CODE_PATH).'admin/settings.php?category=Platform#course_validation';
  57. $message = sprintf(
  58. get_lang('PleaseActivateCourseValidationFeature'),
  59. sprintf('<strong><a href="%s">%s</a></strong>', $link_to_setting, get_lang('EnableCourseValidation'))
  60. );
  61. $is_error_message = true;
  62. }
  63. /**
  64. * Get the number of courses which will be displayed.
  65. */
  66. function get_number_of_requests()
  67. {
  68. return CourseRequestManager::count_course_requests(COURSE_REQUEST_ACCEPTED);
  69. }
  70. /**
  71. * Get course data to display
  72. */
  73. function get_request_data($from, $number_of_items, $column, $direction)
  74. {
  75. $keyword = isset($_GET['keyword']) ? Database::escape_string(trim($_GET['keyword'])) : null;
  76. $course_request_table = Database::get_main_table(TABLE_MAIN_COURSE_REQUEST);
  77. $from = intval($from);
  78. $number_of_items = intval($number_of_items);
  79. $column = intval($column);
  80. $direction = !in_array(strtolower(trim($direction)), ['asc', 'desc']) ? 'asc' : $direction;
  81. $sql = "SELECT
  82. id AS col0,
  83. code AS col1,
  84. title AS col2,
  85. category_code AS col3,
  86. tutor_name AS col4,
  87. request_date AS col5,
  88. id AS col6
  89. FROM $course_request_table
  90. WHERE status = ".COURSE_REQUEST_ACCEPTED;
  91. if ($keyword != '') {
  92. $sql .= " AND (
  93. title LIKE '%".$keyword."%' OR
  94. code LIKE '%".$keyword."%' OR
  95. visual_code LIKE '%".$keyword."%'
  96. )";
  97. }
  98. $sql .= " ORDER BY col$column $direction ";
  99. $sql .= " LIMIT $from,$number_of_items";
  100. $res = Database :: query($sql);
  101. $course_requests = array();
  102. while ($course_request = Database :: fetch_row($res)) {
  103. $course_request[5] = api_get_local_time($course_request[5]);
  104. $course_requests[] = $course_request;
  105. }
  106. return $course_requests;
  107. }
  108. /**
  109. * Actions in the list: edit, accept, delete.
  110. */
  111. function modify_filter($id)
  112. {
  113. $code = CourseRequestManager::get_course_request_code($id);
  114. $result = '<a href="course_request_edit.php?id='.$id.'&caller=1">'.
  115. Display::return_icon('edit.png', get_lang('Edit'), array('style' => 'vertical-align: middle;')).'</a>'.
  116. '&nbsp;<a href="?delete_course_request='.$id.'">'.
  117. Display::return_icon(
  118. 'delete.png',
  119. get_lang('DeleteThisCourseRequest'),
  120. array(
  121. 'style' => 'vertical-align: middle;',
  122. 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeDeleted'), $code), ENT_QUOTES)).'\')) return false;',
  123. )
  124. ).
  125. '</a>';
  126. return $result;
  127. }
  128. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  129. $interbreadcrumb[] = array('url' => 'course_list.php', 'name' => get_lang('CourseList'));
  130. $tool_name = get_lang('AcceptedCourseRequests');
  131. // Display confirmation or error message.
  132. if (!empty($message)) {
  133. if ($is_error_message) {
  134. Display::addFlash(Display::return_message($message, 'error', false));
  135. } else {
  136. Display::addFlash(Display::return_message($message, 'normal', false));
  137. }
  138. }
  139. Display :: display_header($tool_name);
  140. if (!$course_validation_feature) {
  141. Display :: display_footer();
  142. exit;
  143. }
  144. // Create a simple search-box.
  145. $form = new FormValidator('search_simple', 'get', '', '', 'width=200px', false);
  146. $renderer = $form->defaultRenderer();
  147. $renderer->setCustomElementTemplate('<span>{element}</span> ');
  148. $form->addElement('text', 'keyword', get_lang('Keyword'));
  149. $form->addButtonSearch(get_lang('Search'));
  150. // The action bar.
  151. echo '<div style="float: right; margin-top: 5px; margin-right: 5px;">';
  152. echo ' <a href="course_request_review.php">'.
  153. Display::return_icon('course_request_pending.png', get_lang('ReviewCourseRequests')).get_lang('ReviewCourseRequests').'</a>';
  154. echo ' <a href="course_request_rejected.php">'.
  155. Display::return_icon('course_request_rejected.gif', get_lang('RejectedCourseRequests')).get_lang('RejectedCourseRequests').'</a>';
  156. echo '</div>';
  157. echo '<div class="actions">';
  158. $form->display();
  159. echo '</div>';
  160. // Create a sortable table with the course data.
  161. $table = new SortableTable('course_requests_accepted', 'get_number_of_requests', 'get_request_data', 5, 20, 'DESC');
  162. $table->set_header(0, '', false);
  163. $table->set_header(1, get_lang('Code'));
  164. $table->set_header(2, get_lang('Title'));
  165. $table->set_header(3, get_lang('Category'));
  166. $table->set_header(4, get_lang('Teacher'));
  167. $table->set_header(5, get_lang('CourseRequestDate'));
  168. $table->set_header(6, '', false);
  169. $table->set_column_filter(6, 'modify_filter');
  170. $table->set_form_actions(array('delete_course_requests' => get_lang('DeleteCourseRequests')), 'course_request');
  171. $table->display();
  172. /* FOOTER */
  173. Display :: display_footer();