/** * Run the database seeds. * * @return void */ public function run() { /** * ADMIN ROLES * */ $createUser = new PermissionRole(); $createUser->role_id = '1'; $createUser->permission_id = '1'; $createUser->timestamps = false; $createUser->save(); $updateUser = new PermissionRole(); $updateUser->role_id = '1'; $updateUser->permission_id = '2'; $updateUser->timestamps = false; $updateUser->save(); $deleteUser = new PermissionRole(); $deleteUser->role_id = '1'; $deleteUser->permission_id = '3'; $deleteUser->timestamps = false; $deleteUser->save(); $createClient = new PermissionRole(); $createClient->role_id = '1'; $createClient->permission_id = '4'; $createClient->timestamps = false; $createClient->save(); $updateClient = new PermissionRole(); $updateClient->role_id = '1'; $updateClient->permission_id = '5'; $updateClient->timestamps = false; $updateClient->save(); $deleteClient = new PermissionRole(); $deleteClient->role_id = '1'; $deleteClient->permission_id = '6'; $deleteClient->timestamps = false; $deleteClient->save(); $createTask = new PermissionRole(); $createTask->role_id = '1'; $createTask->permission_id = '7'; $createTask->timestamps = false; $createTask->save(); $updateTask = new PermissionRole(); $updateTask->role_id = '1'; $updateTask->permission_id = '8'; $updateTask->timestamps = false; $updateTask->save(); $createLead = new PermissionRole(); $createLead->role_id = '1'; $createLead->permission_id = '9'; $createLead->timestamps = false; $createLead->save(); $updateLead = new PermissionRole(); $updateLead->role_id = '1'; $updateLead->permission_id = '10'; $updateLead->timestamps = false; $updateLead->save(); }
protected function create($values) { $data = []; foreach ($this->structure as $i => $key) { $data[$key] = $values[$i]; } PermissionRole::create($data); }
public function lastUpdated() { $query = PermissionRole::orderBy('updated_at', 'DESC')->first(); if ($query) { return $query->updated_at->format('Y-m-d H:i:s'); } return date("Y-m-d H:i:s"); }
public function getPermissionRole() { $query = \App\Models\PermissionRole::query()->where('role_id', $this->id)->get(); $results = []; foreach ($query as $key => $val) { $results[$key] = $val->permission->slug_view; } return $results; }
public function run() { DB::table('permission_role')->truncate(); $permission_role = []; $permissions = Permission::get(); $role = Role::find(1); foreach ($permissions as $key => $value) { $permission_role[] = ['permission_id' => $value->id, 'role_id' => $role->id, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]; } PermissionRole::insert($permission_role); }
/** * Update the specified PermissionRole in storage. * * @param int $id * @param Request $request * * @return Response */ public function bulkUpdate(Request $request) { $input = $request->all(); $role_id = isset($input['role_id']) ? $input['role_id'] : false; if (isset($input['is_create']) && $input['is_create']) { if (sizeof(Role::$rules) > 0) { $this->validateRequest($request, Role::$rules); } $input = $request->all(); $role = $this->roleRepository->create($input); $role_id = $role->id; } if (!isset($input['data']) || !$role_id) { $this->throwRecordNotFoundException("PermissionRole not found", ERROR_CODE_RECORD_NOT_FOUND); } foreach ($input['data'] as $key => $data) { $permissionRole = PermissionRole::where('role_id', $role_id)->where('permission_id', $data['permission_id'])->first(); /* ** If empty and it's true, Insert new permission */ if (!$permissionRole && $data['value'] == true) { $permission['role_id'] = $role_id; $permission['permission_id'] = $data['permission_id']; $this->permissionRoleRepository->create($permission); continue; } /* ** If exist and it's false, Delete the permission */ if ($permissionRole && $data['value'] == false) { $this->permissionRoleRepository->delete($permissionRole->id); } } $current_permission = PermissionRole::where('role_id', $role_id)->get(); $meta = array('total' => count($current_permission), 'count' => count($current_permission), 'offset' => 0, 'last_updated' => $this->permissionRoleRepository->lastUpdated(), 'status' => "PermissionRole updated successfully.", 'error' => 'Success'); return Response::json(ResponseManager::makeResult($current_permission->toArray(), $meta), 201); }