public function approvepayment()
{
$payment = DB::table('payment_recieved')->where('id', '=', Input::get('paymentid'))->first();
if ($this->create_bank_transaction($payment->bank_account_no, $payment->date_recieved, $payment->amount_recieved, 'Payment recieved for P.F Contribution for the period ' . $payment->contribution_period, 1, $payment->payment_method, $payment->bankers_id, $payment->cheque_no, 'N/A')) {
$affectedRows = UploadHistory::where('Contribution_Period', '=', $payment->contribution_period)->update(array('Payment_Amount' => $payment->amount_recieved, 'Updated_By' => Auth::user()->get_user_id(), 'Updated_At' => date('Y-m-d')));
if ($affectedRows > 0) {
$affected = Payments::where('Id', '=', $payment->id)->update(array('status' => 1, 'Updated_By' => Auth::user()->get_user_id(), 'Updated_At' => date('Y-m-d')));
if ($affected > 0) {
$ini = array('OK' => 'OK');
return Response::json($ini);
} else {
$ini = array('No Data' => 'Payment was not set active, please try again');
return Response::json($ini);
}
} else {
$ini = array('No Data' => 'Amount paid was not updated for the specified period');
return Response::json($ini);
}
} else {
$ini = array('No Data' => 'Payment was not saved.');
return Response::json($ini);
}
}
public function editContribution()
{
$rules = array('contributionid' => 'required', 'contributionperiod' => 'required', 'staffid' => 'required', 'employeecontribution' => 'required', 'employercontribution' => 'required');
$validation = Validator::make(Input::all(), $rules);
if ($validation->fails()) {
return redirect('/ViewContributions')->with('error_message', $validation->errors()->first())->withInput();
}
$affectedRows = Contributions::where('Id', Input::get('contributionid'))->update(array('Employee_Contribution' => Input::get('employeecontribution'), 'Employer_Contribution' => Input::get('employercontribution'), 'Updated_By' => Auth::user()->get_user_id(), 'Updated_At' => date('Y-m-d')));
if ($affectedRows > 0) {
$results = DB::table('contributions')->join('staff_info', 'contributions.staff_id', '=', 'staff_info.staff_id')->select('contributions.Id', 'staff_info.Staff_Id', 'contributions.Contribution_Date', 'staff_info.Other_Names', 'staff_info.Surname', 'contributions.Employee_Contribution', 'contributions.Employer_Contribution', 'contributions.Status')->where('contributions.Contribution_Period', [Input::get('contributionperiod')])->get();
$employer_contribution = DB::table('contributions')->where('contributions.Contribution_Period', [Input::get('contributionperiod')])->sum('Employer_Contribution');
$employee_contribution = DB::table('contributions')->where('contributions.Contribution_Period', [Input::get('contributionperiod')])->sum('Employee_Contribution');
$approved = UploadHistory::where('Contribution_Period', '=', Input::get('contributionperiod'))->update(array('Updated_By' => Auth::user()->get_user_id(), 'Updated_At' => date('Y-m-d'), 'Total_Contributions_Amount' => $employer_contribution + $employee_contribution));
return View::make('Operations.contributions')->with('conts', $results)->with('cont_period', Input::get('contributionperiod'));
} else {
//Say something
}
}