Loheide-eu-mitarbeiterplatt.../app/Support/Permissions/Audiences.php
Friederich Loheide 1877a0922f
Some checks failed
CI / PHP 8.3 / mariadb:10.6 (pull_request) Successful in 3m45s
CI / PHP 8.4 / mariadb:10.6 (pull_request) Successful in 3m39s
CI / PHP 8.3 / mariadb:11.4 (pull_request) Successful in 4m25s
CI / PHP 8.4 / mariadb:11.4 (pull_request) Successful in 4m21s
CI / PHP 8.4 / mysql:8.0 (pull_request) Failing after 6m49s
CI / PHP 8.3 / mysql:8.0 (pull_request) Failing after 6m59s
CI / PHP 8.4 / mysql:8.4 (pull_request) Failing after 6m21s
CI / PHP 8.3 / mysql:8.4 (pull_request) Failing after 6m30s
CI / Build-Artefakte aktuell (pull_request) Successful in 1m10s
Rollen ausschließen: bei Inhalten (Zielgruppen) und für ganze Module
Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-09-26 19:30:11 +00:00

142 lines
5.8 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
namespace App\Support\Permissions;
use App\Models\Audience;
use App\Models\User;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Query\Builder as QueryBuilder;
/**
* Zielgruppen: Ein Objekt ohne Regeln sehen alle. Mit Regeln sieht es, wer
* mindestens eine erfüllt (Rolle, Abteilung oder Standort). Ausgeschlossene Rollen
* („exclude_role“) sehen es nie. Die Prüfung ist eine indizierte SQL-Bedingung –
* auch bei tausenden Personen schnell.
*/
class Audiences
{
/**
* Schränkt eine Abfrage auf Objekte ein, die die Person sehen darf.
*
* @param Builder<Model> $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<int|string>, department?: list<string>, location?: list<string>, exclude_role?: list<int|string>} $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<string>, department: list<string>, location: list<string>, exclude_role: list<string>}
*/
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<int, array{role: list<string>, department: list<string>, location: list<string>, exclude_role: list<string>}> 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<int|string>, department?: list<string>, location?: list<string>, exclude_role?: list<int|string>}|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));
}
}
}