public function confirm_remove() { if (!isset($_SESSION['UserID'])) { redirect('Login/logout'); } //Create new user and load its data $user = new User_model(); if (!$user->loadPropertiesFromPrimaryKey($_SESSION['UserID'])) { redirect('Login/logout'); } if (!$user->isProgramChair()) { redirect('Mainpage'); } $tcourse = $this->input->post("transferCourseID"); $t_course = new Student_transfer_course_model(); $norm_course = new Course_model(); //explode this, then load the data from pimary key, then load course from primary, then add equilvilent course $str_array = explode(",", $tcourse); $t_course->loadPropertiesFromPrimaryKey(intval($str_array[0])); $norm_course->loadPropertiesFromPrimaryKey(intval($str_array[1])); $t_course->removeEquivilentCourse($norm_course); redirect('Transfer_controller/viewIdMapping'); }
public function delete() { $user = new User_model(); if (!$user->loadPropertiesFromPrimaryKey($_SESSION['UserID'])) { redirect('Login/logout'); } if (!$user->isProgramChair()) { redirect('Login/logout'); } if (!$this->uri->segment(3)) { redirect('Coursemanager/index'); } $course = new Course_model(); if (!$course->loadPropertiesFromPrimaryKey($this->uri->segment(3))) { redirect('Coursemanager/index'); } $course->delete(); redirect('Coursemanager/index/' . $course->getCourseName()); }
/** * Summary of getAllCourses * Get all of the courses saved in the database * * @param string $courseName A filter to only select courses with the specified course name, leave null for no filter * @return An array of all the course models represented in the database */ public static function getAllCourses($courseName = null) { $db = get_instance()->db; $db->select('CourseID'); if ($courseName != null) { $db->where('CourseName', $courseName); } $db->order_by('CourseName, CourseNumber', 'asc'); $results = $db->get('Courses'); $data_arr = array(); foreach ($results->result_array() as $row) { $course = new Course_model(); if ($course->loadPropertiesFromPrimaryKey($row['CourseID'])) { array_push($data_arr, $course); } } return $data_arr; }
public function getAllEquivilentCourses() { $models = array(); if ($this->studentTransferCourseID != null) { $this->db->select('EquivilentCourseID'); $this->db->from('StudentTransferCourseEquivilentCourses'); $this->db->where('StudentTransferCourseID', $this->studentTransferCourseID); $results = $this->db->get(); if ($results->num_rows() > 0) { foreach ($results->result_array() as $row) { $model = new Course_model(); if ($model->loadPropertiesFromPrimaryKey($row['EquivilentCourseID'])) { array_push($models, $model); } } } } return $models; }