/** * Summary of update * Update existing rows in the database associated with this curriculum model with newly modified information * * @return boolean True if all rows associated with this model were successfully modified in the database, false otherwise */ public function update() { if ($this->curriculumID != null && $this->name != null && $this->curriculumType != null && filter_var($this->curriculumType, FILTER_VALIDATE_INT)) { $arr = array(); foreach ($this->curriculumCourseSlots as $slot) { array_push($arr, $slot->getCurriculumCourseSlotID()); } $data = array('Name' => $this->name, 'CurriculumTypeID' => $this->curriculumType); $this->db->where('CurriculumID', $this->curriculumID); $this->db->update('Curriculums', $data); $results = $this->db->get_where('CurriculumCourseSlots', array('CurriculumID' => $this->curriculumID)); foreach ($results->result_array() as $row) { $courseSlot = new Curriculum_course_slot_model(); if ($courseSlot->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) { if (in_array($courseSlot->getCurriculumCourseSlotID(), $arr)) { $index = array_search($courseSlot->getCurriculumCourseSlotID(), $arr); unset($arr[$index]); foreach ($this->curriculumCourseSlots as $_courseSlot) { if ($_courseSlot->getCurriculumCourseSlotID() == $courseSlot->getCurriculumCourseSlotID()) { $_courseSlot->update(); break; } } } else { $courseSlot->delete(); } } } foreach ($arr as $id) { foreach ($this->curriculumCourseSlots as $slot) { if ($slot->getCurriculumCourseSlotID() == $id) { $slot->create(); break; } } } return true; } return false; }
/** * Summary of getCorequisiteCourseSlots * Get all of the co-requisite curriculum course slots for this course * * @return Array An array containing all the curriculum course slots that are co-requisites to this curriculum course slot */ public function getCorequisiteCourseSlots() { $models = array(); if ($this->curriculumCourseSlotID != null) { $this->db->select('RequisiteCurriculumCourseSlotID'); $this->db->where('CourseRequisiteTypeID', self::COURSE_REQUISITE_COREQUISITE); $this->db->where('CurriculumCourseSlotID', $this->curriculumCourseSlotID); $results = $this->db->get('CurriculumCourseSlotRequisites'); foreach ($results->result_array() as $row) { $model = new Curriculum_course_slot_model(); if ($model->loadPropertiesFromPrimaryKey($row['RequisiteCurriculumCourseSlotID'])) { array_push($models, $model); } } $this->db->select('CurriculumCourseSlotID'); $this->db->where('CourseRequisiteTypeID', self::COURSE_REQUISITE_COREQUISITE); $this->db->where('RequisiteCurriculumCourseSlotID', $this->curriculumCourseSlotID); $results = $this->db->get('CurriculumCourseSlotRequisites'); foreach ($results->result_array() as $row) { $model = new Curriculum_course_slot_model(); if ($model->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) { array_push($models, $model); } } } return $models; }
/** * Summary of getAllCurriculumCourseSlots * Get all of the curriculum course slots that this course is compatible with * * @return Array An array containing curriculum course slot models that are compatible with this course */ public function getAllCurriculumCourseSlots() { $models = array(); if ($this->courseID != null) { $this->db->where("CourseID", $this->courseID); $this->db->select("CurriculumCourseSlotID"); $results = $this->db->get("CurriculumSlotValidCourses"); foreach ($results->result_array() as $row) { $model = new Curriculum_course_slot_model(); if ($model->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) { array_push($models, $model); } } } return $models; }
public function addCourseSection() { $this->checkSec(); $sID = $this->input->post('sID'); $sectionID = $this->input->post('sectionID'); $slotID = $this->input->post('slotID'); $slot = new Curriculum_course_slot_model(); $slot->loadPropertiesFromPrimaryKey($slotID); $section = new Course_section_model(); $grade = $this->input->post('grade'); //Cannot add a grade to a slot if it doesn't meet the minimum grade requirement. if (!isset($grade) || strcmp($grade, $slot->getMinimumGrade()) < 0) { redirect('User/prepareAddCourseSection/' . $slotID); } $student = new User_model(); $student->loadPropertiesFromPrimaryKey($sID); if (!$student->addCourseSection($section, $grade)) { show_error('Failed to add Course section: ' . $section . ' with grade ' . $grade); } redirect('User/prepareAddCourses/' . $sID); }