function get_all_curriculums() { $curriculums = false; $CI =& get_instance(); $CI->load->model("curriculum_model"); $curriculuminfo = new Curriculum_Model(); $query = $CI->db->select("*")->from($curriculuminfo->table_name)->get(); if ($query && $query->num_rows() > 0) { $curriculums = array(); foreach ($query->result() as $rwi => $rw) { $curriculuminfo = new Curriculum_Model(); $curriculuminfo->setCurriculumid($rw->curriculum_id); $curriculuminfo->setCourseid($rw->course_id); $curriculuminfo->setMajorid($rw->major_id); $curriculuminfo->setCurriculumtypeid($rw->curriculum_type_id); $curriculuminfo->setDescription($rw->description); $curriculuminfo->setYear($rw->year); $curriculuminfo->setSchoolyearstart($rw->schoolyear_start); $curriculuminfo->setCreatedon($rw->created_on); $curriculuminfo->setLastupdate($rw->last_update); $curriculums[] = $curriculuminfo; } } return $curriculums; }
private function createCurriculum() { $return = false; $this->form_validation->set_rules("curriculumType", "Curriculum type", "trim|required|xss_clean"); $this->form_validation->set_rules("curriculumCourse", "Curriculum course", "trim|required|xss_clean"); $this->form_validation->set_rules("curriculumMajor", "Curriculum major", "trim|xss_clean"); $this->form_validation->set_rules("curriculumDescription", "Curriculum description", "trim|xss_clean"); $this->form_validation->set_rules("curriculumYear", "Curriculum year", "trim|xss_clean"); if ($this->form_validation->run() == FALSE) { if (form_error("curriculumType")) { set_has_error("curriculumType", true); set_message("curriculumType", form_error("curriculumType", " ", " ")); } if (form_error("curriculumCourse")) { set_has_error("curriculumCourse", true); set_message("curriculumCourse", form_error("curriculumCourse", " ", " ")); } if (form_error("curriculumMajor")) { set_has_error("curriculumMajor", true); set_message("curriculumMajor", form_error("curriculumMajor", " ", " ")); } if (form_error("curriculumDescription")) { set_has_error("curriculumDescription", true); set_message("curriculumDescription", form_error("curriculumDescription", " ", " ")); } if (form_error("curriculumYear")) { set_has_error("curriculumYear", true); set_message("curriculumYear", form_error("curriculumYear", " ", " ")); } } else { $newcurriculuminfo = new Curriculum_Model(); $ctype = $this->input->post("curriculumType"); $ccourse = $this->input->post("curriculumCourse"); $cmajor = $this->input->post("curriculumMajor"); $cdesc = $this->input->post("curriculumDescription"); $cyear = $this->input->post("curriculumYear"); if ($ctype && is_curriculum_type_exist($ctype)) { $newcurriculuminfo->setCurriculumtypeid($ctype); if ($ccourse && (int) $ccourse > 0 && is_course_exist($ccourse)) { $errorz = 0; $newcurriculuminfo->setCourseid($ccourse); if ($cmajor) { if ((int) $cmajor > 0 && is_major_exist($cmajor)) { $newcurriculuminfo->setMajorid($cmajor); } else { set_has_error("curriculumMajor", true); set_message("curriculumMajor", "Invalid major selected."); } } if ($cdesc) { $newcurriculuminfo->setDescription($cdesc); } if ($cyear) { $ystart = 1970; $now = mdate("%Y", now()); $yend = $now + 10; if ((int) $cyear >= $ystart && (int) $cyear <= $yend) { $newcurriculuminfo->setYear($cyear); } else { $errorz++; set_has_error("curriculumYear", true); set_message("curriculumYear", "Invalid Year."); } } if ($errorz == 0) { $return = $newcurriculuminfo->saveasnew(); } } else { set_has_error("curriculumCourse", true); set_message("curriculumCourse", "Invalid course selected."); } } else { set_has_error("curriculumType", true); set_message("curriculumType", "Invalid type selected."); } } return $return; }