|
EARNINGS
|
|
|
|
DEDUCTIONS
|
|
|
|
'.$this->lang->line('xin_payroll_gross_salary').'
|
|
'.number_format($bs, 2, '.', ',').'
|
';
if($count_loan > 0):
$tbl .= ''.$this->lang->line('xin_employee_set_loan_deductions').'';
endif;
$tbl .= ' |
|
';
if($count_loan > 0):
foreach($loan->result() as $r_loan) {
$loan_de_amount += $r_loan->loan_amount;
}
$tbl .= '('.number_format($loan_de_amount, 2, '.', ',').')';
else:
$loan_de_amount = 0;
endif;
$tbl .= '
|
| ';
if($count_allowances > 0):
$tbl .= ''.$this->lang->line('xin_employee_set_allowances').'';
endif;
$tbl .= '
|
|
';
if($count_allowances > 0):
foreach($allowances->result() as $r_allowances) {
$allowances_amount += $r_allowances->allowance_amount;
}
$tbl .= '('.number_format($allowances_amount, 2, '.', ',').')';
else:
$allowances_amount = 0;
endif;
$tbl .= ' |
';
if($count_statutory_deductions > 0):
$tbl .= ''.$this->lang->line('xin_employee_set_statutory_deductions').'';
endif;
$tbl .= ' |
|
';
if($count_statutory_deductions > 0):
foreach($statutory_deductions->result() as $r_statutory_deductions) {
//$sta_salary = $allowances_amount + $bs;
$st_amount = $r_statutory_deductions->deduction_amount;
$statutory_deduction_amount += $r_statutory_deductions->deduction_amount;
}
$tbl .= '('.number_format($statutory_deduction_amount, 2, '.', ',').')';
else:
$statutory_deduction_amount = 0;
endif;
$tbl .= '
|
| ';
if($count_commissions > 0):
$tbl .= ''.$this->lang->line('xin_hr_commissions').'';
endif;
$tbl .= ' |
|
';
if($count_commissions > 0):
foreach($commissions->result() as $r_commissions) {
$commissions_amount += $r_commissions->commission_amount;
}
$tbl .= '('.number_format($commissions_amount, 2, '.', ',').')';
else:
$commissions_amount = 0;
endif;
$tbl .= ' |
';
$tbl .= ' |
|
';
$tbl .= '
|
| ';
if($count_other_payments > 0):
$tbl .= ''.$this->lang->line('xin_employee_set_other_payment').'';
endif;
$tbl .= ' |
|
';
if($count_other_payments > 0):
foreach($other_payments->result() as $r_other_payments) {
$other_payments_amount += $r_other_payments->payments_amount;
}
$tbl .= '('.number_format($other_payments_amount, 2, '.', ',').')';
else:
$other_payments_amount = 0;
endif;
$tbl .= ' |
';
$tbl .= ' |
|
';
$tbl .= '
|
| ';
if($count_overtime > 0):
$tbl .= ''.$this->lang->line('dashboard_overtime').'';
endif;
$tbl .= ' |
|
';
if($count_overtime > 0):
foreach($overtime->result() as $r_overtime) {
$overtime_total = $r_overtime->overtime_hours * $r_overtime->overtime_rate;
$overtime_amount += $overtime_total;
}
$tbl .= '('.number_format($overtime_amount, 2, '.', ',').')';
else:
$overtime_amount = 0;
endif;
$tbl .= ' |
';
$tbl .= ' |
|
';
$tbl .= '
|
| ';
$tbl .= '
|
|
';
$i=1;
$total_earning = $bs + $allowances_amount + $overtime_amount + $commissions_amount + $other_payments_amount;
$total_deduction = $loan_de_amount + $statutory_deduction_amount;
$total_net_salary = $total_earning - $total_deduction;
$tbl .= ' |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL EARNING
|
|
'.number_format($total_earning, 2, '.', ',').'
|
TOTAL DEDUCTIONS
|
|
'.number_format($total_deduction, 2, '.', ',').'
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL NETT SALARY
|
'.number_format($total_net_salary, 2, '.', ',').'
|
|
|
|
|
|
|
|
|
|
';
$pdf->writeHTML($tbl, true, false, false, false, '');
// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$fname = strtolower($fname);
$pay_month = strtolower(date("F Y", strtotime($payment[0]->salary_month)));
//Close and output PDF document
ob_start();
$pdf->Output('payslip_'.$fname.'_'.$pay_month.'.pdf', 'I');
ob_end_flush();
//$pdf->Output('payslip_'.$fname.'_'.$pay_month.'.pdf', 'D');
}
// get company > employees
public function get_employees() {
$data['title'] = $this->Xin_model->site_title();
$id = $this->uri->segment(4);
$data = array(
'company_id' => $id
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view("admin/payroll/get_employees", $data);
} else {
redirect('admin/');
}
// Datatables Variables
$draw = intval($this->input->get("draw"));
$start = intval($this->input->get("start"));
$length = intval($this->input->get("length"));
}
// make payment info by id
public function make_payment_view()
{
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
$data['title'] = $this->Xin_model->site_title();
$id = $this->input->get('pay_id');
// $data['all_countries'] = $this->xin_model->get_countries();
$result = $this->Payroll_model->read_make_payment_information($id);
// get addd by > template
$user = $this->Xin_model->read_user_info($result[0]->employee_id);
// get designation
$designation = $this->Designation_model->read_designation_information($user[0]->designation_id);
if(!is_null($designation)){
$designation_name = $designation[0]->designation_name;
} else {
$designation_name = '--';
}
// department
$department = $this->Department_model->read_department_information($user[0]->department_id);
if(!is_null($department)){
$department_name = $department[0]->department_name;
} else {
$department_name = '--';
}
$data = array(
'first_name' => $user[0]->first_name,
'last_name' => $user[0]->last_name,
'employee_id' => $user[0]->employee_id,
'department_name' => $department_name,
'designation_name' => $designation_name,
'date_of_joining' => $user[0]->date_of_joining,
'profile_picture' => $user[0]->profile_picture,
'gender' => $user[0]->gender,
'monthly_grade_id' => $user[0]->monthly_grade_id,
'hourly_grade_id' => $user[0]->hourly_grade_id,
'basic_salary' => $result[0]->basic_salary,
'payment_date' => $result[0]->payment_date,
'payment_method' => $result[0]->payment_method,
'overtime_rate' => $result[0]->overtime_rate,
'hourly_rate' => $result[0]->hourly_rate,
'total_hours_work' => $result[0]->total_hours_work,
'is_payment' => $result[0]->is_payment,
'is_advance_salary_deduct' => $result[0]->is_advance_salary_deduct,
'advance_salary_amount' => $result[0]->advance_salary_amount,
'house_rent_allowance' => $result[0]->house_rent_allowance,
'medical_allowance' => $result[0]->medical_allowance,
'travelling_allowance' => $result[0]->travelling_allowance,
'dearness_allowance' => $result[0]->dearness_allowance,
'provident_fund' => $result[0]->provident_fund,
'security_deposit' => $result[0]->security_deposit,
'tax_deduction' => $result[0]->tax_deduction,
'gross_salary' => $result[0]->gross_salary,
'total_allowances' => $result[0]->total_allowances,
'total_deductions' => $result[0]->total_deductions,
'net_salary' => $result[0]->net_salary,
'payment_amount' => $result[0]->payment_amount,
'comments' => $result[0]->comments,
);
$session = $this->session->userdata('username');
if(!empty($session)){
$this->load->view('admin/payroll/dialog_payslip', $data);
} else {
redirect('admin/');
}
}
public function payslip_delete() {
$session = $this->session->userdata('username');
if(empty($session)){
redirect('admin/');
}
/* Define return | here result is used to return user data and error for error message */
$Return = array('result'=>'', 'error'=>'', 'csrf_hash'=>'');
$id = $this->uri->segment(4);
$Return['csrf_hash'] = $this->security->get_csrf_hash();
$result = $this->Payroll_model->delete_record($id);
if(isset($id)) {
$this->Payroll_model->delete_payslip_allowances_items($id);
$this->Payroll_model->delete_payslip_commissions_items($id);
$this->Payroll_model->delete_payslip_other_payment_items($id);
$this->Payroll_model->delete_payslip_statutory_deductions_items($id);
$this->Payroll_model->delete_payslip_overtime_items($id);
$this->Payroll_model->delete_payslip_loan_items($id);
$Return['result'] = $this->lang->line('xin_hr_payslip_deleted');
} else {
$Return['error'] = $this->lang->line('xin_error_msg');
}
$this->output($Return);
}
}