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