/** * Returns an array of objects of type CourseDescription corresponding to * a specific course, without session ids (session id = 0) * * @param int $course_id * * @return array Array of CourseDescriptions */ public static function get_descriptions($course_id) { // Get course code $course_info = api_get_course_info_by_id($course_id); if (!empty($course_info)) { $course_id = $course_info['real_id']; } else { return array(); } $t_course_desc = Database::get_course_table(TABLE_COURSE_DESCRIPTION); $sql = "SELECT * FROM {$t_course_desc}\n WHERE c_id = {$course_id} AND session_id = '0'"; $sql_result = Database::query($sql); $results = array(); while ($row = Database::fetch_array($sql_result)) { $desc_tmp = new CourseDescription(); $desc_tmp->set_id($row['id']); $desc_tmp->set_title($row['title']); $desc_tmp->set_content($row['content']); $desc_tmp->set_session_id($row['session_id']); $desc_tmp->set_description_type($row['description_type']); $desc_tmp->set_progress($row['progress']); $results[] = $desc_tmp; } return $results; }
/** * It's used for destroy a course description, * render to listing view * @param int $id description type */ public function destroy($id) { $course_description = new CourseDescription(); $session_id = api_get_session_id(); $course_description->set_session_id($session_id); if (!empty($id)) { $course_description->set_id($id); $course_description->delete(); Display::addFlash(Display::return_message(get_lang('CourseDescriptionDeleted'))); } $this->listing(false); }
/** * It's used for destroy a course description, * render to listing view * @param int description type */ public function destroy($id) { $course_description = new CourseDescription(); $session_id = api_get_session_id(); $course_description->set_session_id($session_id); if (!empty($id)) { $course_description->set_id($id); $affected_rows = $course_description->delete(); } if ($affected_rows) { $message['destroy'] = true; } $this->listing(false, $message); }