Пример #1
0
 function search_curriculum_subjects($curriculum_id = false, $sem_id = false, $yearlevel_id = false, $searchkey)
 {
     $CI =& get_instance();
     $CI->load->model("Curriculum_Subject_Model");
     $curriculum_subjects = array();
     $curriculumsubjectinfo = new Curriculum_Subject_Model();
     $subjectinfo = new Subject_Model();
     $query = false;
     if ($searchkey && $curriculum_id) {
         $where = array($curriculumsubjectinfo->table_name . ".curriculum_id" => $curriculum_id);
         $like_array = array(array($subjectinfo->table_name . ".subject_code" => $searchkey), array($subjectinfo->table_name . ".subject_description" => $searchkey));
         if ($sem_id) {
             $where[$curriculumsubjectinfo->table_name . ".sem_id"] = $sem_id;
         }
         if ($yearlevel_id) {
             $where[$curriculumsubjectinfo->table_name . ".yearlevel_id"] = $yearlevel_id;
         }
         $found_already = array();
         foreach ($like_array as $likei => $like) {
             $query = $CI->db->select("*")->from($curriculumsubjectinfo->table_name)->where($where)->like($like)->join($subjectinfo->table_name, $subjectinfo->table_name . ".subject_id = " . $curriculumsubjectinfo->table_name . ".subject_id")->get();
             if ($query && $query->num_rows() > 0) {
                 foreach ($query->result() as $rwi => $rw) {
                     if (!isset($found_already[$rw->curriculum_subject_id])) {
                         $found_already[$rw->curriculum_subject_id] = true;
                         $curriculumsubjectinfo = new Curriculum_Subject_Model();
                         $curriculumsubjectinfo->setCurriculumsubjectid($rw->curriculum_subject_id);
                         $curriculumsubjectinfo->setCurriculumid($rw->curriculum_id);
                         $curriculumsubjectinfo->setSubjectid($rw->subject_id);
                         $curriculumsubjectinfo->setYearlevelid($rw->yearlevel_id);
                         $curriculumsubjectinfo->setSemid($rw->sem_id);
                         $curriculumsubjectinfo->setUnit($rw->unit);
                         $curriculumsubjectinfo->setCreatedon($rw->created_on);
                         $curriculumsubjectinfo->setLastupdate($rw->last_update);
                         $curriculum_subjects[] = $curriculumsubjectinfo;
                     }
                 }
             }
         }
     }
     return $curriculum_subjects;
 }
Пример #2
0
 function add_subject($sem_id, $yearlevel_id, $subject_id, $unit, $default_type = false)
 {
     $new_curriculum_subject_id = false;
     if ($this->curriculum_id && $sem_id && $yearlevel_id && $subject_id && $unit) {
         $data = array("curriculum_id" => $this->curriculum_id, "sem_id" => $sem_id, "yearlevel_id" => $yearlevel_id, "subject_id" => $subject_id, "unit" => $unit);
         $curriculum_subject_info = new Curriculum_Subject_Model($data);
         if ($new_curriculum_subject_id = $curriculum_subject_info->save_as_new()) {
             if ($default_type) {
                 $default_class_type = get_a_class_type(true);
                 if ($default_class_type) {
                     $new_curriculum_subject_type = array("curriculum_subject_id" => $new_curriculum_subject_id, "class_type_id" => $default_class_type->getClasstypeid(), "unit" => $data["unit"]);
                     $curriculum_subject_type = new Curriculum_Subject_Type_Model($new_curriculum_subject_type);
                     $curriculum_subject_type->saveasnew();
                 }
             }
             return $new_curriculum_subject_id;
         }
     }
     return false;
 }