/** * Display linked records of the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // get all -- USERS -- with this specific role id $role = Role::find($id); $heading = 'User Management - Show ' . ucfirst($role->name) . 's'; return view('admin.users', ['users' => $role->users()->get(), 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); }
/** * Display linked records of the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // get all -- USERS -- with this specific instrument id $instrument = Instrument::find($id); if ($instrument) { $heading = 'User Management - Users playing ' . ucfirst($instrument->name); return view('admin.users', ['users' => $instrument->users()->get(), 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); } $message = 'Error! Instrument with ID "' . $id . '" not found'; return \Redirect::route($this->view_idx)->with(['status' => $message]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { // show only active users // TODO: this currently produces duplicates... if ($request->has('active')) { $user1 = Role::find(4)->users()->get(); $users = Role::find(5)->users()->get(); foreach ($user1 as $value) { $users->prepend($value); } $heading = 'Show Active Users'; return view($this->view_all, ['users' => $users, 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); } // get all users in the requested order (default by id) $users = User::orderBy(isset($request->orderby) ? $request->orderby : 'id', isset($request->order) ? $request->order : 'asc'); $heading = 'User Management'; // check if user selected a filter if ($request->has('filterby') && $request->has('filtervalue') && $request->filtervalue != 'all') { if ($request->filterby == 'role') { // get all -- USERS -- with this specific role id $role = Role::find($request->filtervalue); $users = $role->users(); $heading = 'User Management - Show ' . ucfirst($role->name) . 's'; } else { if ($request->filterby == 'instrument') { // get all -- USERS -- with this specific instrument id $instrument = Instrument::find($request->filtervalue); $users = $instrument->users(); $heading = 'User Management - Show users playing ' . ucfirst($instrument->name); } else { $users = $users->where($request->filterby, $request->filtervalue); } } } return view($this->view_all, ['users' => $users->get(), 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); }