chamilo /
chamilo-lms
| @@ 82-121 (lines=40) @@ | ||
| 79 | /** |
|
| 80 | * Get course data to display |
|
| 81 | */ |
|
| 82 | function get_request_data($from, $number_of_items, $column, $direction) |
|
| 83 | { |
|
| 84 | $keyword = isset($_GET['keyword']) ? Database::escape_string(trim($_GET['keyword'])) : null; |
|
| 85 | $course_request_table = Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST); |
|
| 86 | ||
| 87 | $from = intval($from); |
|
| 88 | $number_of_items = intval($number_of_items); |
|
| 89 | $column = intval($column); |
|
| 90 | $direction = !in_array(strtolower(trim($direction)), ['asc','desc']) ? 'asc' : $direction; |
|
| 91 | ||
| 92 | $sql = "SELECT |
|
| 93 | id AS col0, |
|
| 94 | code AS col1, |
|
| 95 | title AS col2, |
|
| 96 | category_code AS col3, |
|
| 97 | tutor_name AS col4, |
|
| 98 | request_date AS col5, |
|
| 99 | id AS col6 |
|
| 100 | FROM $course_request_table |
|
| 101 | WHERE status = ".COURSE_REQUEST_ACCEPTED; |
|
| 102 | ||
| 103 | if ($keyword != '') { |
|
| 104 | $sql .= " AND ( |
|
| 105 | title LIKE '%".$keyword."%' OR |
|
| 106 | code LIKE '%".$keyword."%' OR |
|
| 107 | visual_code LIKE '%".$keyword."%' |
|
| 108 | )"; |
|
| 109 | } |
|
| 110 | $sql .= " ORDER BY col$column $direction "; |
|
| 111 | $sql .= " LIMIT $from,$number_of_items"; |
|
| 112 | $res = Database :: query($sql); |
|
| 113 | ||
| 114 | $course_requests = array(); |
|
| 115 | while ($course_request = Database :: fetch_row($res)) { |
|
| 116 | $course_request[5] = api_get_local_time($course_request[5]); |
|
| 117 | $course_requests[] = $course_request; |
|
| 118 | } |
|
| 119 | ||
| 120 | return $course_requests; |
|
| 121 | } |
|
| 122 | ||
| 123 | /** |
|
| 124 | * Actions in the list: edit, accept, delete. |
|
| @@ 109-148 (lines=40) @@ | ||
| 106 | /** |
|
| 107 | * Get course data to display |
|
| 108 | */ |
|
| 109 | function get_request_data($from, $number_of_items, $column, $direction) |
|
| 110 | { |
|
| 111 | $keyword = isset($_GET['keyword']) ? Database::escape_string(trim($_GET['keyword'])) : ''; |
|
| 112 | $course_request_table = Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST); |
|
| 113 | ||
| 114 | $from = intval($from); |
|
| 115 | $number_of_items = intval($number_of_items); |
|
| 116 | $column = intval($column); |
|
| 117 | $direction = !in_array(strtolower(trim($direction)), ['asc','desc']) ? 'asc' : $direction; |
|
| 118 | ||
| 119 | $sql = "SELECT |
|
| 120 | id AS col0, |
|
| 121 | code AS col1, |
|
| 122 | title AS col2, |
|
| 123 | category_code AS col3, |
|
| 124 | tutor_name AS col4, |
|
| 125 | request_date AS col5, |
|
| 126 | id AS col6 |
|
| 127 | FROM $course_request_table |
|
| 128 | WHERE status = ".COURSE_REQUEST_REJECTED; |
|
| 129 | ||
| 130 | if ($keyword != '') { |
|
| 131 | $sql .= " AND ( |
|
| 132 | title LIKE '%".$keyword."%' OR |
|
| 133 | code LIKE '%".$keyword."%' OR |
|
| 134 | visual_code LIKE '%".$keyword."%' |
|
| 135 | )"; |
|
| 136 | } |
|
| 137 | $sql .= " ORDER BY col$column $direction "; |
|
| 138 | $sql .= " LIMIT $from,$number_of_items"; |
|
| 139 | $res = Database :: query($sql); |
|
| 140 | ||
| 141 | $course_requests = array(); |
|
| 142 | while ($course_request = Database :: fetch_row($res)) { |
|
| 143 | $course_request[5] = api_get_local_time($course_request[5]); |
|
| 144 | $course_requests[] = $course_request; |
|
| 145 | } |
|
| 146 | ||
| 147 | return $course_requests; |
|
| 148 | } |
|
| 149 | ||
| 150 | /** |
|
| 151 | * Actions in the list: edit, accept, delete, request additional information. |
|
