public function forms() { $exitPass = ExitPass::where('status', '!=', 3)->get(); $leaveForm = Leaves::where('status', '!=', 3)->get(); $changeSchedule = Change::where('status', '!=', 3)->get(); $oas = Overtime::where('status', '!=', 3)->get(); return count($exitPass) + count($leaveForm) + count($changeSchedule) + count($oas); }
public function editExit(array $data, $id) { $dateUpdate = date("Y-m-d H:i:s"); $dateFrom = $data['dateFrom']; $dateTo = $data['dateTo']; // echo $newDate; $newFormatdateFrom = date('Y-m-d H:i:s', strtotime($dateFrom)); $newFormatdateTo = date('Y-m-d H:i:s', strtotime($dateTo)); $newFormattimeFrom = date('H:i:s', strtotime($dateFrom)); $newFormattimeTo = date('H:i:s', strtotime($dateTo)); if ($newFormattimeTo - $newFormattimeFrom > 5) { return "You are execeeded from your maximum hours to Exit!"; } else { return ExitPass::where('id', $id)->update(array('date_from' => $newFormatdateFrom, 'date_to' => $newFormatdateTo, 'purpose' => $data['textPurpose'], 'permission_id1' => $data['supervisor'], 'permission_id2' => $data['projectManager'], 'permission_id3' => $data['HR'], 'permission_id4' => $data['companyRep'], 'updated_at' => $dateUpdate)); } }