function up()
{
$lgu_code = Setting::getField('lgu_code');
if ($lgu_code == '') {
if ($this->db->table_exists('pds_work_experience')) {
$this->db->where('govt_service', 1);
$this->db->order_by('id');
$q = $this->db->get('pds_work_experience');
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $row) {
$s = new Service_record();
$s->employee_id = $row['employee_id'];
$s->date_from = $row['inclusive_date_from'];
$s->date_to = $row['inclusive_date_to'];
$s->designation = $row['position'];
$s->status = $row['status'];
$s->salary = $row['monthly_salary'];
$s->office_entity = $row['company'];
$s->save();
}
}
}
}
}
function service_record($employee_id = '')
{
$data['page_name'] = '<b>Personal Data Sheet</b>';
$data['section_name'] = '<b>Personal Information</b>';
$data['focus_field'] = 'date_from';
$data['msg'] = '';
$e = new Employee_m();
$data['employee'] = $e->get_by_id($employee_id);
if (Input::get('op')) {
$date_from = Input::get('date_from');
$date_to = Input::get('date_to');
$designation = Input::get('designation');
$status = Input::get('status');
$salary = Input::get('salary');
$office_entity = Input::get('office_entity');
$lwop = Input::get('lwop');
$branch = Input::get('branch');
$remarks = Input::get('remarks');
$separation_date = Input::get('separation_date');
$separation_cause = Input::get('separation_cause');
$service = new Service_record();
$service->get_by_employee_id($employee_id);
$service->delete_all();
$i = 0;
foreach ($date_from as $work_date) {
if ($work_date != "") {
$service = new Service_record();
$service->employee_id = $employee_id;
$service->date_from = $date_from[$i];
$service->date_to = $date_to[$i];
$service->designation = $designation[$i];
$service->status = $status[$i];
$service->salary = $salary[$i];
$service->office_entity = $office_entity[$i];
$service->lwop = $lwop[$i];
$service->branch = $branch[$i];
$service->remarks = $remarks[$i];
$service->separation_date = $separation_date[$i];
$service->separation_cause = $separation_cause[$i];
$service->save();
}
$i++;
}
$data['msg'] = 'Service Record has been saved!';
}
// Service Record====================================================
$service = new Service_record();
//$service->order_by('date_from');
//http://stackoverflow.com/questions/7482594/weird-backticks-behaviour-in-active-record-in-code-igniter-2-0-3
$service->select('id, employee_id, date_from, date_to, designation, status, salary, office_entity, branch, remarks, lwop, separation_date, separation_cause, STR_TO_DATE(date_from,"%m/%d/%Y") as nice_date', false);
$service->order_by("nice_date");
$data['services'] = $service->get_by_employee_id($employee_id);
if ($employee_id == '') {
// Meaning get the service record that does not exists
$data['services'] = $service->get_by_employee_id(9999999999999);
}
$data['selected'] = $e->office_id;
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['employee_id'] = $employee_id;
$data['main_content'] = 'service_record';
return View::make('includes/template', $data);
}
function service_record($employee_id = '')
{
$data['page_name'] = '<b>Personal Data Sheet</b>';
$data['section_name'] = '<b>Personal Information</b>';
$data['focus_field'] = 'date_from';
$data['msg'] = '';
$e = new Employee_m();
$data['employee'] = $e->get_by_id($employee_id);
if (Input::get('op')) {
$date_from = Input::get('date_from');
$date_to = Input::get('date_to');
$designation = Input::get('designation');
$status = Input::get('status');
$salary = Input::get('salary');
$office_entity = Input::get('office_entity');
$lwop = Input::get('lwop');
$separation_date = Input::get('separation_date');
$separation_cause = Input::get('separation_cause');
$service = new Service_record();
$service->get_by_employee_id($employee_id);
$service->delete_all();
$i = 0;
foreach ($date_from as $work_date) {
if ($work_date != "") {
$service = new Service_record();
$service->employee_id = $employee_id;
$service->date_from = $date_from[$i];
$service->date_to = $date_to[$i];
$service->designation = $designation[$i];
$service->status = $status[$i];
$service->salary = $salary[$i];
$service->office_entity = $office_entity[$i];
$service->lwop = $lwop[$i];
$service->separation_date = $separation_date[$i];
$service->separation_cause = $separation_cause[$i];
$service->save();
}
$i++;
}
$data['msg'] = 'Service Record has been saved!';
}
// Service Record====================================================
$service = new Service_record();
$service->order_by('date_from');
$data['services'] = $service->get_by_employee_id($employee_id);
if ($employee_id == '') {
// Meaning get the service record that does not exists
$data['services'] = $service->get_by_employee_id(9999999999999);
}
$data['selected'] = $e->office_id;
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['employee_id'] = $employee_id;
$data['main_content'] = 'service_record';
return View::make('includes/template', $data);
}
