/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $this->authorize(new Permissions()); $prmList = Modules::select('modules.*', 'permissions.*')->leftJoin('permissions', 'permissions.id_mdl', '=', 'modules.id')->where('permissions.id_rl', $id)->get(); $Item = Roles::select('roles.*', 'u1.email as created_by', 'u2.email as updated_by', 'u1.id as created_by_id')->join('users as u1', 'u1.id', '=', 'roles.created_by')->leftjoin('users as u2', 'u2.id', '=', 'roles.updated_by')->where('roles.id', $id)->first(); $this->authorize($Item); return view('admin.roles.show')->with('Item', $Item)->with('prmList', $prmList); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $this->authorize(new Permissions()); //$Item = Modules::find($id); $Item = Modules::select('modules.*', 'mn.mn_name as mdl_menu', 'mn.mn_description', 'm1.mdl_name as mdl_p_name', 'u1.email as created_by', 'u2.email as updated_by', 'u1.id as created_by_id')->leftjoin('modules as m1', 'm1.id', '=', 'modules.mdl_parent')->join('users as u1', 'u1.id', '=', 'modules.created_by')->leftjoin('users as u2', 'u2.id', '=', 'modules.updated_by')->join('menus as mn', 'mn.id', '=', 'modules.mdl_menu')->where('modules.id', $id)->first(); $this->authorize('showRecord', $Item); //validate if user viewing is the creator of the item. return view('admin.modules.show')->with('Item', $Item); }