$query * @param string $column Spalte mit der ID des Objekts, dessen Zielgruppe gilt */ public static function constrain(Builder $query, string $type, string $column, ?User $user): void { $query->where(function (Builder $q) use ($type, $column, $user) { $q->whereNotExists(fn (QueryBuilder $sub) => $sub->from('audiences') ->where('audiences.resource_type', $type) ->whereIn('audiences.rule_type', Audience::INCLUDE_TYPES) ->whereColumn('audiences.resource_id', $column)); if ($user) { $q->orWhereExists(fn (QueryBuilder $sub) => $sub->from('audiences') ->where('audiences.resource_type', $type) ->whereColumn('audiences.resource_id', $column) ->where(fn (QueryBuilder $rules) => self::matching($rules, $user))); } }); if ($user) { $query->whereNotExists(fn (QueryBuilder $sub) => $sub->from('audiences') ->where('audiences.resource_type', $type) ->whereColumn('audiences.resource_id', $column) ->where('audiences.rule_type', 'exclude_role') ->whereIn('audiences.rule_value', array_map('strval', $user->permissions()->roleIds) ?: ['-'])); } } public static function allows(string $type, int $id, ?User $user): bool { return self::matches(self::get($type, $id), $user); } /** * @param array{role?: list, department?: list, location?: list, exclude_role?: list} $rules */ public static function sync(string $type, int $id, array $rules): void { Audience::query()->where('resource_type', $type)->where('resource_id', $id)->delete(); foreach (array_keys(Audience::TYPES) as $ruleType) { foreach (array_unique(array_filter((array) ($rules[$ruleType] ?? []), fn ($v) => $v !== null && $v !== '')) as $value) { Audience::query()->create(['resource_type' => $type, 'resource_id' => $id, 'rule_type' => $ruleType, 'rule_value' => (string) $value]); } } } /** * @return array{role: list, department: list, location: list, exclude_role: list} */ public static function get(string $type, int $id): array { $rules = ['role' => [], 'department' => [], 'location' => [], 'exclude_role' => []]; foreach (Audience::query()->where('resource_type', $type)->where('resource_id', $id)->get() as $audience) { $rules[$audience->rule_type][] = $audience->rule_value; } return $rules; } /** * Alle Regeln eines Typs auf einmal – für gecachte Strukturen wie den Seitenbaum. * * @return array, department: list, location: list, exclude_role: list}> ID => Regeln */ public static function allOfType(string $type): array { $result = []; foreach (Audience::query()->where('resource_type', $type)->get(['resource_id', 'rule_type', 'rule_value']) as $audience) { $result[$audience->resource_id] ??= ['role' => [], 'department' => [], 'location' => [], 'exclude_role' => []]; $result[$audience->resource_id][$audience->rule_type][] = $audience->rule_value; } return $result; } /** * Dieselbe Prüfung wie constrain()/allows(), aber in PHP auf bereits geladenen Regeln. * * @param array{role?: list, department?: list, location?: list, exclude_role?: list}|null $rules */ public static function matches(?array $rules, ?User $user): bool { $rules = array_filter((array) $rules); $include = array_intersect_key($rules, array_flip(Audience::INCLUDE_TYPES)); $roleIds = $user ? array_map('strval', $user->permissions()->roleIds) : []; if (array_intersect(array_map('strval', $rules['exclude_role'] ?? []), $roleIds) !== []) { return false; } if ($include === []) { return true; } if ($user === null) { return false; } return array_intersect(array_map('strval', $include['role'] ?? []), $roleIds) !== [] || (filled($user->department) && in_array($user->department, $include['department'] ?? [], true)) || (filled($user->location) && in_array($user->location, $include['location'] ?? [], true)); } private static function matching(QueryBuilder $rules, User $user): void { $roleIds = array_map('strval', $user->permissions()->roleIds); $rules->where(fn (QueryBuilder $q) => $q->where('audiences.rule_type', 'role')->whereIn('audiences.rule_value', $roleIds ?: ['-'])); if (filled($user->department)) { $rules->orWhere(fn (QueryBuilder $q) => $q->where('audiences.rule_type', 'department')->where('audiences.rule_value', $user->department)); } if (filled($user->location)) { $rules->orWhere(fn (QueryBuilder $q) => $q->where('audiences.rule_type', 'location')->where('audiences.rule_value', $user->location)); } } }