function education($employee_id = '') { $data['page_name'] = '<b>Personal Data Sheet</b>'; $data['section_name'] = '<b>Personal Information</b>'; $data['focus_field'] = 'elem_school'; $data['msg'] = ''; $e = new Employee_m(); $data['employee'] = $e->get_by_id($employee_id); $e = new Education(); if (Input::get('op')) { // EDUCATIONAL BACKGROUND============================================ // ELEMENTARY if (Input::get('elem_school') != "") { $e = new Education(); $e->where('level', 1); $e->where('employee_id', $employee_id)->get(); $e->delete_all(); $e->employee_id = $employee_id; $e->level = 1; $e->school_name = Input::get('elem_school'); $e->degree_course = Input::get('elem_degree'); $e->year_graduated = Input::get('elem_grad'); $e->highest_grade = Input::get('elem_units'); $e->attend_from = Input::get('elem_date1'); $e->attend_to = Input::get('elem_date2'); $e->scholarship = Input::get('elem_scho'); $e->save(); } // HIGHSCHOOL if (Input::get('sec_school') != "") { $e = new Education(); $e->where('level', 2); $e->where('employee_id', $employee_id)->get(); $e->delete_all(); $e->employee_id = $employee_id; $e->level = 2; $e->school_name = Input::get('sec_school'); $e->degree_course = Input::get('sec_degree'); $e->year_graduated = Input::get('sec_grad'); $e->highest_grade = Input::get('sec_units'); $e->attend_from = Input::get('sec_date1'); $e->attend_to = Input::get('sec_date2'); $e->scholarship = Input::get('sec_scho'); $e->save(); } // VOC if (Input::get('voc_school') != "") { $e = new Education(); $e->where('level', 3); $e->where('employee_id', $employee_id)->get(); $e->delete_all(); $e->employee_id = $employee_id; $e->level = 3; $e->school_name = Input::get('voc_school'); $e->degree_course = Input::get('voc_degree'); $e->year_graduated = Input::get('voc_grad'); $e->highest_grade = Input::get('voc_units'); $e->attend_from = Input::get('voc_date1'); $e->attend_to = Input::get('voc_date2'); $e->scholarship = Input::get('voc_scho'); $e->save(); } // COLLEGE if (Input::get('col_school') != "") { $e = new Education(); $e->where('level', 4); $e->where('employee_id', $employee_id)->get(); $e->delete_all(); $e->employee_id = $employee_id; $e->level = 4; $e->school_name = Input::get('col_school'); $e->degree_course = Input::get('col_degree'); $e->year_graduated = Input::get('col_grad'); $e->highest_grade = Input::get('col_units'); $e->attend_from = Input::get('col_date1'); $e->attend_to = Input::get('col_date2'); $e->scholarship = Input::get('col_scho'); $e->save(); } // GRAD SCHOOL if (Input::get('grad_school') != "") { $e = new Education(); $e->where('level', 5); $e->where('employee_id', $employee_id)->get(); $e->delete_all(); $e->employee_id = $employee_id; $e->level = 5; $e->school_name = Input::get('grad_school'); $e->degree_course = Input::get('grad_degree'); $e->year_graduated = Input::get('grad_grad'); $e->highest_grade = Input::get('grad_units'); $e->attend_from = Input::get('grad_date1'); $e->attend_to = Input::get('grad_date2'); $e->scholarship = Input::get('grad_scho'); $e->save(); } $data['msg'] = 'Educational Background has been saved!'; } // Educational Background====================================== $e = new Education(); $data['educs1'] = $e->get_single_educ($employee_id, $level = 1); $data['educs2'] = $e->get_single_educ($employee_id, $level = 2); $data['educs3'] = $e->get_single_educ($employee_id, $level = 3); $data['educs4'] = $e->get_single_educ($employee_id, $level = 4); $data['educs5'] = $e->get_single_educ($employee_id, $level = 5); $e = new Employee_m(); $e->get_by_id($employee_id); $data['selected'] = $e->office_id; //Use for office listbox $data['options'] = $this->options->office_options(); $data['employee_id'] = $employee_id; $data['main_content'] = 'education'; return View::make('includes/template', $data); }