private function getGroups() { if ($this->user()->can('add_areas')) { $query = Group::query()->where('county_id', config('app.county')); } else { $query = $this->user()->trainerGroups(); } $query->join('areas', 'area_id', '=', 'areas.id')->leftJoin('area_categories', 'category_id', '=', 'area_categories.id'); return $query->get(['area_groups.id', 'area_groups.name', 'category_id', 'areas.name as area_name', 'area_categories.name as category_name']); }
private function getGroups($queryOnly = false) { if ($this->user()->can('add_areas')) { $query = Group::query(); } else { $query = $this->user()->trainerGroups(); } if ($queryOnly) { return $query; } return $query->get(['id', 'name', 'area_id', 'category_id']); }