public function generate_payslip($empid, $start_date, $end_date, $payslip_type = 'Semi-Monthly')
 {
     $data['employee'] = $this->retrieveEmployeeInfo($empid);
     if ($payslip_type == 'Semi-Monthly') {
         $divisor = 2;
     } else {
         $divisor = 4;
     }
     $data['cutoffsalary'] = $data['employee']->salary / $divisor;
     $data['perdaysalary'] = $data['employee']->salary * 12 / 261;
     $data['perhoursalary'] = $data['perdaysalary'] / 8;
     $data['attendance'] = $this->getAttendance($empid, $start_date, $end_date);
     $data['allowances'] = $this->computeAllowances(Allowance_model::view_allowances(), $data['cutoffsalary'], $divisor);
     $data['total'] = $this->retrieveTotalHours($empid, $start_date, $end_date);
     $data['total_absent'] = $this->totalAbsent($data['attendance']);
     $data['total_overtime'] = $data['total']->overtime * ($data['perhoursalary'] * 1.25);
     $data['total_tardiness'] = $data['total']->tardiness * ($data['perhoursalary'] * 1.25);
     $data['total_leaves'] = $this->totalLeaves($data['attendance']) * $data['perdaysalary'];
     $data['total_absent_amount'] = $data['total_absent'] * $data['perdaysalary'];
     $data['total_allowance'] = $this->totalAmount($data['allowances']);
     $data['gross_income'] = $data['cutoffsalary'] + $data['total_overtime'] + $data['total_leaves'] - $data['total_absent_amount'] - $data['total_tardiness'];
     $data['taxes'] = $this->computeTaxes(Taxes_model::compute_taxes($data['cutoffsalary']), $data['cutoffsalary'], $divisor);
     $data['total_tax'] = $this->totalAmount($data['taxes']);
     $data['net_income'] = $data['gross_income'] + $data['total_allowance'] - $data['total_tax'];
     $records = array("attendance" => $data['attendance'], "allowances" => $data['allowances'], "taxes" => $data['taxes'], "employee" => $data['employee'], "cutoffsalary" => $data['cutoffsalary'], "perdaysalary" => $data['perdaysalary'], "total" => $data['total'], "total_absent" => $data['total_absent'], "total_overtime" => $data['total_overtime'], "total_tardiness" => $data['total_tardiness'], "total_absent_amount" => $data['total_absent_amount'], "total_allowance" => $data['total_allowance'], "total_tax" => $data['total_tax'], "net_income" => $data['net_income'], "gross_income" => $data['gross_income']);
     return $records;
 }
Ejemplo n.º 2
0
 public function multiple_payslips()
 {
     //$this->output->enable_profiler(TRUE);
     $this->form_validation->set_rules('txtPayrollDate', 'Pay Date', 'trim|required');
     $this->form_validation->set_rules('txtStartDate', 'Start Date', 'trim|required');
     $this->form_validation->set_rules('txtEndDate', 'End Date', 'trim|required');
     $data = array();
     $data['payslips'] = array();
     if ($this->form_validation->run()) {
         $post = $this->input->post();
         if (isset($post['btnGenerate'])) {
             $employee_count = $post["hidTotalEmp"];
             $data['post'] = array("txtPayrollDate" => $post['txtPayrollDate'], "txtStartDate" => $post['txtStartDate'], "txtEndDate" => $post['txtEndDate']);
             for ($empctr = 1; $empctr <= $employee_count; $empctr++) {
                 $tempAllowance = Attendance_model::computeAllowances(Allowance_model::view_allowances(), $post['hidBasicSalary' . $empctr], 2);
                 $tempTaxes = Attendance_model::computeTaxes(Taxes_model::compute_taxes($post['hidBasicSalary' . $empctr]), $post['hidBasicSalary' . $empctr], 2);
                 $allowances = array();
                 foreach ($tempAllowance as $row) {
                     if ($row->active == 1) {
                         array_push($allowances, array('allowance_id' => $row->allowance_id, 'percentage' => $row->percentage, 'computation' => $row->computation, 'amount' => $row->amount, 'total' => $row->total));
                     }
                 }
                 $taxes = array();
                 foreach ($tempTaxes as $row) {
                     if ($row->active == 1) {
                         if ($row->ranges_active == 1) {
                             array_push($taxes, array('tax_id' => $row->tax_id, 'percentage' => $row->percentage, 'computation' => $row->computation, 'amount' => $row->amount, 'total' => $row->total));
                         } else {
                             array_push($taxes, array('tax_id' => $row->tax_id, 'percentage' => 0, 'computation' => 0, 'amount' => 0, 'total' => $row->total));
                         }
                     }
                 }
                 $insert_payslip = array('emp_id' => $post['hidID' . $empctr], 'payslip_date' => $post['hidPayDate'], 'start_date' => $post['hidPayStart'], 'end_date' => $post['hidPayEnd'], 'monthly_rate' => $post['hidMonthlyRate' . $empctr], 'basic_salary' => $post['hidBasicSalary' . $empctr], 'total_overtime' => $post['hidTotalOvertime' . $empctr], 'total_tardiness' => $post['hidTotalTardiness' . $empctr], 'days_absent' => $post['hidTotalAbsent' . $empctr], 'total_absent_amount' => $post['hidTotalAbsentAmount' . $empctr], 'total_allowances' => $post['hidTotalAllowance' . $empctr], 'total_taxes' => $post['hidTotalTax' . $empctr], 'gross_pay' => $post['hidGrossIncome' . $empctr], 'net_pay' => $post['hidNetIncome' . $empctr], "allowances" => $allowances, "taxes" => $taxes, 'remarks' => "");
                 $this->attendance_model->insert_payslip($insert_payslip);
                 //print_r($insert_payslip);
                 $this->session->set_userdata('added', 1);
             }
         } else {
             $emp_ids = $this->attendance_model->retrieveEmployeesFromCutoff($post['txtStartDate'], $post['txtEndDate']);
             foreach ($emp_ids as $id) {
                 //$data['payslip'] = $this->attendance_model->retrievePayslipDates($post['cboDate']);
                 $data['record'] = $this->attendance_model->generate_payslip($id->emp_id, $post['txtStartDate'], $post['txtEndDate']);
                 //$data['post'] = $post;
                 $data['post'] = array("txtPayrollDate" => $post['txtPayrollDate'], "txtStartDate" => $post['txtStartDate'], "txtEndDate" => $post['txtEndDate']);
                 /*if(isset($post['btnGenerate'])){
                 			$insert_payslip = array(
                 				'emp_id'=>$id->emp_id,
                 				'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);
                 		}*/
                 array_push($data['payslips'], $data['record']);
             }
         }
     } 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);
     }
     /*
     		$post = $this->input->post();
     		if($post){
     			$emp_ids = $this->attendance_model->retrieveEmployeesFromCutoff('2015-06-01', '2015-06-15');
     			foreach($emp_ids as $id){
     				//$data['payslip'] = $this->attendance_model->retrievePayslipDates($post['cboDate']);
     				$data['record'] = $this->attendance_model->generate_payslip($id->emp_id, '2015-06-01', '2015-06-15');
     				//$data['post'] = $post;
     				$data['post'] = array(
     					"cboEmployee"=>1,
     					"txtPayrollDate"=>'2015-06-20',
     					"txtStartDate"=>'2015-06-01',
     					"txtEndDate"=>'2015-06-15');
     				if(isset($post('btnGenerate'))){
     					$insert_payslip = array(
     						'emp_id'=>$id->emp_id,
     						'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);
     				}
     				array_push($data['payslips'], $data['record']);
     			}
     		}*/
     $data['pageTitle'] = 'Add Multiple Payslips - MSInc.';
     $data['content'] = 'payroll/multiple_payslips';
     $this->load->view($this->master_layout, $data);
     $this->display_notif();
 }