public function deleteCurriculum($curriculumID = NULL) { //get arguments if ($curriculumID == NULL) { $curriculumID = $this->input->post('curriculum'); } $curriculum = new Curriculum_model(); $curriculum->loadPropertiesFromPrimaryKey($curriculumID); $curriculum->delete(); $this->index(); }
public function remove($curriculumID = null) { $user = new User_model(); if (!$user->loadPropertiesFromPrimaryKey($_SESSION['UserID'])) { redirect('Login/logout'); } if (!$user->isStudent()) { redirect('Login/logout'); } $curriculum = new Curriculum_model(); if ($curriculum->loadPropertiesFromPrimaryKey($curriculumID)) { $user->removeCurriculum($curriculum); } redirect('Selectcurriculum/index'); }
/** * Summary of getAllCurriculums * Get all the curriculums stored in the database * * @return array An array of all the curriculum models currently stored in the database */ public static function getAllCurriculums() { $db = get_instance()->db; $data = array(); $db->select('CurriculumID'); $db->from('Curriculums'); $results = $db->get(); foreach ($results->result_array() as $row) { $model = new Curriculum_model(); $model->loadPropertiesFromPrimaryKey($row['CurriculumID']); array_push($data, $model); } return $data; }
/** * Summary of getCurriculums * Get all of the curriculums that this user model is bound to * * @return Array An array containing all of the curriculum models this user is bound to */ public function getCurriculums() { $models = array(); $this->db->select('CurriculumID'); $this->db->from('UserCurriculums'); $this->db->where('UserID', $this->userID); $results = $this->db->get(); if ($results->num_rows() > 0) { foreach ($results->result_array() as $row) { $model = new Curriculum_model(); if ($model->loadPropertiesFromPrimaryKey($row['CurriculumID'])) { array_push($models, $model); } } } return $models; }
private function collectCourseData($curriculumID) { #get list of all curriculumcourseslots for names of courses $curriculum = new Curriculum_model(); $curriculum->loadPropertiesFromPrimaryKey($curriculumID); $currCourseList = $curriculum->getCurriculumCourseSlots(); #Courses list to grab courseIDs from courseName and course Number $course = new Course_model(); $courseList = $course->getAllCourses(); #Create a list of CourseIDs to reference courses $courseIDList = array(); #loop through each currCourseListName and grab the matching courseID's #with matching CourseNames and CourseNumbers foreach ($currCourseList as $currCourse) { $currCourseName = $currCourse->getName(); $nameLength = strlen($currCourseName); $cName = preg_split('%[0-9]%', $currCourseName); $cName = strtoupper($cName[0]); $cNumber = $currCourseName[$nameLength - 3] . $currCourseName[$nameLength - 2] . $currCourseName[$nameLength - 1]; foreach ($courseList as $course) { if ($course->getCourseName() . ' ' . $course->getCourseNumber() == $cName . $cNumber) { array_push($courseIDList, $course->getCourseID()); } } } #now that we have a list of all courseIDs we need to make a list of #courseSectionIDs #first make a list of all courseSections $courseSections = new Course_section_model(); $courseSectionList = $courseSections->getAllCourseSections(); #next make a list to store the courseSectionIDs we need $courseSectionIDList = array(); foreach ($courseIDList as $courseID) { foreach ($courseSectionList as $courseSection) { if ($courseSection->getCourse()->getCourseID() == $courseID) { array_push($courseSectionIDList, $courseSection->getCourseSectionID()); } } } $allCourseData = array(); foreach ($courseSectionIDList as $csID) { $courseData = array('sectionID' => null, 'courseName' => null, 'quarterID' => null, 'quarterName' => null, 'quarterYear' => null, 'sectionNum' => null); $cSection = new Course_section_model(); $cSection->loadPropertiesFromPrimaryKey($csID); $course = $cSection->getCourse(); $cName = $course->getCourseName(); $cNumber = $course->getCourseNumber(); $courseData['quarterID'] = $cSection->getAcademicQuarter()->getAcademicQuarterID(); $courseData['quarterName'] = $cSection->getAcademicQuarter()->getName(); $courseData['quarterYear'] = $cSection->getAcademicQuarter()->getYear(); $courseData['sectionNum'] = $cSection->getSectionName(); $courseData['sectionID'] = $csID; $courseData['courseName'] = $cName . $cNumber; array_push($allCourseData, $courseData); } return $allCourseData; }