/** * Is a specific user on site non-attendee list (Compliance table) * * @return record */ public function isUserOnCompliance($user_id, $date = '') { if (!$date) { $date = Carbon::today()->format('Y-m-d'); } $oncomply = SiteCompliance::where('site_id', $this->id)->where('user_id', $user_id)->whereDate('date', '=', $date)->first(); return $oncomply ? $oncomply->id : 0; }