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']);
}
