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