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);
}
