$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;