public function save_payslip()
{
$data = array();
$data['employees'] = View_job_history::all();
$data['payslip'] = array();
if ($this->form_validation->run()) {
$post = $this->input->post();
$data['record'] = $this->attendance_model->generate_payslip($post['cboEmployee'], $post['txtStartDate'], $post['txtEndDate']);
$data['post'] = array("cboEmployee" => $post['cboEmployee'], "txtPayrollDate" => $post['txtPayrollDate'], "txtStartDate" => $post['txtStartDate'], "txtEndDate" => $post['txtEndDate']);
if (isset($post['btnGenerate']) and $post['hidID'] != null) {
$insert_payslip = array('emp_id' => $post['hidID'], 'payslip_date' => $post['hidPayDate'], 'start_date' => $post['hidPayStart'], 'end_date' => $post['hidPayEnd'], 'monthly_rate' => $data['record']['employee']->salary, 'basic_salary' => $data['record']['employee']->salary / 2, 'total_overtime' => $data['record']['total_overtime'], 'total_tardiness' => $data['record']['total_tardiness'], 'days_absent' => $data['record']['total_absent'], 'total_absent_amount' => $data['record']['total_absent_amount'], 'total_allowances' => $data['record']['total_allowance'], 'total_taxes' => $data['record']['total_tax'], 'gross_pay' => $data['record']['gross_income'], 'net_pay' => $data['record']['net_income'], "allowances" => $data['record']['allowances'], "taxes" => $data['record']['taxes'], 'remarks' => "");
$this->attendance_model->insert_payslip($insert_payslip);
$this->session->set_userdata('added', 1);
}
} else {
$data['record'] = array("attendance" => array(), "allowances" => array(), "taxes" => array(), "employee" => array(), "cutoffsalary" => 0, "perdaysalary" => 0, "total" => array(), "total_absent" => 0, "total_overtime" => 0, 'total_tardiness' => 0, "total_absent_amount" => 0, "total_allowance" => 0, "total_tax" => 0, "net_income" => 0, "gross_income" => 0);
}
/*
$data = array();
$data['payslip'] = array();
$data['record'] = array(
"attendance"=>array(),
"allowances"=>array(),
"taxes"=>array(),
"employee"=>array(),
"cutoffsalary"=>0,
"perdaysalary"=>0,
"total"=>array(),
"total_absent"=>0,
"total_overtime"=>0,
'total_tardiness'=>0,
"total_absent_amount"=>0,
"total_allowance"=>0,
"total_tax"=>0,
"net_income"=>0,
"gross_income"=>0);
$data['employees'] = $this->attendance_model->view_employees();
$post = $this->input->post();
if($post){
//$data['payslip'] = $this->attendance_model->retrievePayslipDates($post['cboDate']);
//$data['record'] = $this->attendance_model->generate_payslip(1, '2015-06-01', '2015-06-15');
$data['record'] = $this->attendance_model->generate_payslip($post['cboEmployee'], $post['txtStartDate'], $post['txtEndDate']);
//$data['post'] = $post;
/*$data['post'] = array(
"cboEmployee"=>1,
"txtPayrollDate"=>'2015-06-20',
"txtStartDate"=>'2015-06-01',
"txtEndDate"=>'2015-06-15');/
$data['post'] = array(
"cboEmployee"=>$post['cboEmployee'],
"txtPayrollDate"=>'2015-06-20',
"txtStartDate"=>$post['txtStartDate'],
"txtEndDate"=>$post['txtEndDate']);
if($this->input->get('generate')){
$insert_payslip = array(
'emp_id'=>$post['hidID'],
'payslip_date'=>$post['hidPayDate'],
'start_date'=>$post['hidPayStart'],
'end_date'=>$post['hidPayEnd'],
'monthly_rate'=>$data['record']['employee']->salary,
'basic_salary'=>$data['record']['employee']->salary/2,
'total_overtime'=>$data['record']['total_overtime'],
'total_tardiness'=>$data['record']['total_tardiness'],
'days_absent'=>$data['record']['total_absent'],
'total_absent_amount'=>$data['record']['total_absent_amount'],
'total_allowances'=>$data['record']['total_allowance'],
'total_taxes'=>$data['record']['total_tax'],
'gross_pay'=>$data['record']['gross_income'],
'net_pay'=>$data['record']['net_income'],
"allowances"=>$data['record']['allowances'],
"taxes"=>$data['record']['taxes'],
'remarks'=>"");
$this->attendance_model->insert_payslip($insert_payslip);
}
}*/
$data['pageTitle'] = 'Generate Payslip - MSInc.';
$data['content'] = 'payroll/generate_payslip';
$this->load->view($this->master_layout, $data);
$this->display_notif();
}
public function view_details()
{
$id = $this->input->get('emp_id');
$data['departments'] = Departments_model::all();
$data['job_titles'] = Job_titles_model::all();
$data['employment_type'] = Employment_type_model::all();
$data['countryy'] = Countries::all();
$data['user_level'] = View_user_level::all();
$data['record'] = Dependent_model::find('all', array('conditions' => "employee_id='{$id}'"));
//get dependents by id
$data['info'] = Emp_info_model::find($id);
//Tab 1a - Personal Tab
$data['gov_id'] = Gov_id_model::find($id);
//Tab 1b - Gov ID Tab
$data['address'] = View_emp_address::find($id);
//Tab 2a - Contact Tab
$data['contact'] = Emp_contact_model::find($id);
//Tab 2b - Contact Tab
$data['contactP'] = Emp_contact_person::find($id);
//Tab 2c - Contact Tab
$data['school'] = Emp_school_model::find($id);
//Tab 3 - School Tab
$data['job_hist'] = Job_history_model::find('all', array('conditions' => "employee_id ='{$id}'"));
//Tab 4 - Job History Tab
$data['emp'] = View_job_history::find($id);
//Tab 5 - Employment Tab
$data['leaves'] = View_leaves_left::find('all', array('conditions' => "employee_id ='{$id}'"));
//Tab 6 - Leaves Tab
$data['asset'] = View_assigned_assets_model::find('all', array('conditions' => "emp_id ='{$id}'"));
//Tab 7 - Asset Tab
$data['project'] = View_project_workers::find('all', array('conditions' => "emp_id ='{$id}'"));
//Tab 8 - Project Tab
$data['account'] = View_users_model::find_by_employee_id($id);
//Tab 9 - Users Tab
$data['pageTitle'] = 'Employee Details - MSInc.';
$data['content'] = 'employee/employee_details';
$this->load->view($this->master_layout, $data);
$this->display_notif();
}
