public function all($params) { $params['order'] = isset($params['order']) ? $params['order'] : ['last_name|ASC', 'first_name|ASC']; $users = Person::select("people.*"); $users = parent::execute($users, $params); return $users; }
public function create($id = null) { if (Auth::user()->can('create-user')) { $data['title'] = "Create User"; $data['user'] = new User(); $data['user']->person_id = $id; $people = Person::select("people.*"); $people->leftJoin('users', 'users.person_id', '=', 'people.id'); $people->whereNull('users.id'); $people->orderBy('people.last_name'); $data['people'] = $people->get(); return view('users/create', $data); } else { return redirect()->back()->withErrors(['Access denied to users create page']); } }