/** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $query = Permission::select('*'); return $this->applyScopes($query); }
/** * Display given permissions to role. * * @return void */ public function getGiveRolePermissions() { $roles = Role::select('id', 'name', 'label')->get(); $permissions = Permission::select('id', 'name', 'label')->get(); return view('admin.permissions.role-give-permissions', compact('roles', 'permissions')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { if (Gate::denies('userrole.update')) { return view(config('app.template') . '.error.403'); } $role = Role::with('permissions')->find($id); if (!$role) { return view(config('app.template') . '.error.404'); } $data = ['role' => $role, 'permissions' => Permission::select(['permissions.*', DB::raw('SUBSTRING(`name`, 1, LOCATE(".", `name`)-1)AS `key`')])->get()]; return view(config('app.template') . '.role.update', $data); }
public function anyPermisionSettings(){ $roles = Role::orderBy('main','name')->get()->toArray(); $permissions = Permission::select('permissions.*') ->addSelect(\DB::raw('right(`name`,length(`name`)-instr(`name`,"-")) as controller')) ->orderBy('controller','id') ->get() ->toArray(); return view('setting.list-permission',[ "roles" => $roles, "permissions" => $permissions ]); }
/** * Display given permissions to role. * * @return void */ public function getUserRolePermissions() { $roles = Role::select('id', 'name', 'label')->get(); $permissions = Permission::select('id', 'name', 'label')->get(); return \View::make('admin.permissions.role-assign-permissions', ['roles' => $roles, 'permissions' => $permissions, 'title' => 'assign']); }
/** * Show a list of all the languages posts formatted for Datatables. * * @return Datatables JSON */ public function data() { $users = Permission::select(array('id', 'name', 'display_name', 'description')); return Datatables::of($users)->add_column('actions', '<a href="{{{ URL::to(\'admin/permission/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" >{{ trans("admin/modal.edit") }}</a> <a href="{{{ URL::to(\'admin/permission/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe">{{ trans("admin/modal.delete") }}</a>')->make(); }
/** * 寫入登入時間及IP 位址 * * @param \Illuminate\Contracts\Auth\Authenticatable $user * @return void */ public function updateUserInfo(UserContract $user) { // 寫入登入IP & 時間 $user->ip_address = Request::ip(); $user->last_login = Carbon::now(); $user->save(); // 寫入可用權限以供nav 選單使用 $role = json_decode($user->role->permissions); if (in_array('all', $role)) { $permissions = Permission::select('slug')->where('status', true)->get()->toArray(); // dd($permissions); } else { $permissions = Permission::select('slug')->whereIn('slug', $role)->where('status', true)->get()->toArray(); } // dd($role); foreach ($permissions as $value) { $permission[] = $value['slug']; } // dd($permission); session(['permissions' => $permission]); // dd(session('permissions')); }