$update = array('paternity_leave' => '');
DB::table('employee_summary')->where('employee_id', $employeeId)->whereBetween('daydate', $leaveDateArr)->update($update);
//Leave Without Pay
} elseif ('leave without Pay' === strtolower($leave->nature_of_leave)) {
$update = array('leave_without_pay' => '');
DB::table('employee_summary')->where('employee_id', $employeeId)->whereBetween('daydate', $leaveDateArr)->update($update);
}
}
}
}
return Redirect::route('adminHumanResource');
} else {
//Mulitple check
//Code here
foreach ($data["check"] as $check) {
$leave = Leave::whereIn('id', $data["check"])->first();
$employeeId = $leave->employee_id;
$leaveSetting = DB::table('leave_setting')->where('employee_id', $employeeId)->get();
$data["action"] = (int) $data["action"];
if ($data["action"] === 1 && -1 === (int) $leave->status || $data["action"] === 1 && 0 === (int) $leave->status) {
//Aprroved
if (0 !== (int) $leaveSetting[0]->leave_credits) {
$leaveBalance = $leaveSetting[0]->leave_balance -= 1;
DB::table('leave_setting')->where('employee_id', $employeeId)->update(array('leave_balance' => $leaveBalance));
DB::table('leave')->where('id', $leave->id)->update(array('status' => 1));
}
}
if ($data["action"] === 0 && -1 === (int) $leave->status) {
//Denied
if ($leaveSetting[0]->leave_balance <= (int) $leaveSetting[0]->leave_credits) {
/*$leaveBalance = $leaveSetting[0]->leave_balance;
