course_request_accepted.php 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  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. /* INIT SECTION */
  13. // Language files that need to be included.
  14. $language_file = array('admin', 'create_course');
  15. $cidReset = true;
  16. require '../inc/global.inc.php';
  17. $this_section = SECTION_PLATFORM_ADMIN;
  18. api_protect_admin_script();
  19. require_once api_get_path(LIBRARY_PATH).'add_course.lib.inc.php';
  20. require_once api_get_path(CONFIGURATION_PATH).'course_info.conf.php';
  21. require_once api_get_path(LIBRARY_PATH).'course.lib.php';
  22. require_once api_get_path(LIBRARY_PATH).'course_request.lib.php';
  23. require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  24. require_once api_get_path(LIBRARY_PATH).'sortabletable.class.php';
  25. // Including a configuration file.
  26. require api_get_path(CONFIGURATION_PATH).'add_course.conf.php';
  27. // Include additional libraries
  28. require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
  29. // Filltering passed to this page parameters.
  30. $delete_course_request = intval($_GET['delete_course_request']);
  31. $message = trim(Security::remove_XSS(stripslashes(urldecode($_GET['message']))));
  32. $is_error_message = !empty($_GET['is_error_message']);
  33. /**
  34. * Deletion of a course request.
  35. */
  36. if (!empty($delete_course_request)) {
  37. $course_request_code = CourseRequestManager::get_course_request_code($delete_course_request);
  38. $result = CourseRequestManager::delete_course_request($delete_course_request);
  39. if ($result) {
  40. $message = sprintf(get_lang('CourseRequestDeleted'), $course_request_code);
  41. $is_error_message = false;
  42. } else {
  43. $message = sprintf(get_lang('CourseRequestDeletionFailed'), $course_request_code);
  44. $is_error_message = true;
  45. }
  46. }
  47. /**
  48. * Get the number of courses which will be displayed.
  49. */
  50. function get_number_of_courses() {
  51. return CourseRequestManager::count_course_requests(COURSE_REQUEST_ACCEPTED);
  52. }
  53. /**
  54. * Get course data to display
  55. */
  56. function get_course_data($from, $number_of_items, $column, $direction) {
  57. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST);
  58. $users_table = Database :: get_main_table(TABLE_MAIN_USER);
  59. $course_users_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  60. $sql = "SELECT code AS col0,
  61. title AS col1,
  62. category_code AS col2,
  63. tutor_name AS col3,
  64. request_date AS col4,
  65. id AS col5
  66. FROM $course_table WHERE status = ".COURSE_REQUEST_ACCEPTED;
  67. $sql .= " ORDER BY col$column $direction ";
  68. $sql .= " LIMIT $from,$number_of_items";
  69. $res = Database :: query($sql);
  70. $courses = array();
  71. while ($course = Database :: fetch_row($res)) {
  72. $courses[] = $course;
  73. }
  74. return $courses;
  75. }
  76. /**
  77. * Actions in the list: edit, accept, delete.
  78. */
  79. function modify_filter($id) {
  80. $code = CourseRequestManager::get_course_request_code($id);
  81. $result = '<a href="editar_curso.php?id='.$id.'">'.Display::return_icon('edit.gif', get_lang('Edit'), array('style' => 'vertical-align: middle;')).'</a>'.
  82. '&nbsp;<a href="?delete_course_request='.$id.'">'.Display::return_icon('delete.gif', get_lang('DeleteThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeDeleted'), $code), ENT_QUOTES)).'\')) return false;')).'</a>';
  83. return $result;
  84. }
  85. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  86. $tool_name = get_lang('AcceptedCourseRequests');
  87. Display :: display_header($tool_name);
  88. // Display confirmation or error message.
  89. if (!empty($message)) {
  90. if ($is_error_message) {
  91. Display::display_error_message($message);
  92. } else {
  93. Display::display_normal_message($message);
  94. }
  95. }
  96. // The action bar.
  97. echo '<div class="actions">';
  98. echo '<a href="course_list.php">'.Display::return_icon('courses.gif', get_lang('CourseList')).get_lang('CourseList').'</a>';
  99. echo '<a href="course_request_review.php">'.Display::return_icon('course_request_pending.png', get_lang('ReviewCourseRequests')).get_lang('ReviewCourseRequests').'</a>';
  100. echo '<a href="course_request_rejected.php">'.Display::return_icon('course_request_rejected.gif', get_lang('RejectedCourseRequests')).get_lang('RejectedCourseRequests').'</a>';
  101. echo '</div>';
  102. // Create a sortable table with the course data
  103. $table = new SortableTable('courses', 'get_number_of_courses', 'get_course_data', 2);
  104. $table->set_additional_parameters($parameters);
  105. //$table->set_header(0, '', false);
  106. $table->set_header(0, get_lang('Code'));
  107. $table->set_header(1, get_lang('Title'));
  108. $table->set_header(2, get_lang('Category'));
  109. //$table->set_header(3, get_lang('Teacher'), false);
  110. //$table->set_header(4, get_lang('CourseRequestDate'), false);
  111. $table->set_header(3, get_lang('Teacher'));
  112. $table->set_header(4, get_lang('CourseRequestDate'));
  113. $table->set_header(5, '', false);
  114. $table->set_column_filter(5, 'modify_filter');
  115. //$table->set_form_actions(array('delete_courses' => get_lang('DeleteCourse')), 'course');
  116. $table->display();
  117. /* FOOTER */
  118. Display :: display_footer();