select(['id', 'name']) ->withCount('permissions') ->when($search, fn ($q) => $q->where('name', 'like', "%{$search}%")) ->orderBy($sort, $direction) ->paginate($perPage); } public function store(array $data): Role { return DB::transaction(function () use ($data) { $role = SpatieRole::create(['name' => $data['name']]); $role->syncPermissions($data['permissions']); return $role; }); } public function update(Role $role, array $data): Role { DB::transaction(function () use ($role, $data) { $role->update(['name' => $data['name']]); $role->syncPermissions($data['permissions']); }); return $role->fresh('permissions'); } public function destroy(Role $role): bool { return $role->delete(); } public function getPermissionsByModule(): array { return Permission::all() ->groupBy(fn ($p) => explode('.', $p->name)[0]) ->map(fn ($group) => $group->pluck('name')->map(fn ($name) => explode('.', $name, 2)[1])->values()->toArray()) ->toArray(); } public function getForEmployee(): Collection { $query = SpatieRole::where('name', '!=', Role::DEVELOPER->value); $user = auth()->user(); if (self::hasAnyRole([Role::ADMIN_TOKO, Role::DIREKTUR])) { $query->where('name', '!=', Role::ADMIN_BAHAN_BAKU->value); } if (! self::hasAnyRole([Role::DEVELOPER, Role::OWNER, Role::DIREKTUR, Role::ADMIN_TOKO])) { $userRoles = $user->roles->pluck('name'); $query->whereIn('name', $userRoles); } return $query->get(['id', 'name']); } }