Some checks failed
CI / PHP 8.3 / mariadb:10.6 (pull_request) Successful in 1m56s
CI / PHP 8.4 / mariadb:10.6 (pull_request) Successful in 1m56s
CI / PHP 8.3 / mariadb:11.4 (pull_request) Successful in 2m2s
CI / PHP 8.4 / mariadb:11.4 (pull_request) Successful in 2m9s
CI / PHP 8.3 / mysql:8.0 (pull_request) Failing after 2m40s
CI / PHP 8.4 / mysql:8.0 (pull_request) Failing after 2m35s
CI / PHP 8.4 / mysql:8.4 (pull_request) Failing after 2m29s
CI / PHP 8.3 / mysql:8.4 (pull_request) Failing after 2m38s
CI / Build-Artefakte aktuell (pull_request) Successful in 55s
- Seiten-Plugin: Seitenbaum mit Adressen, Seitennavigation, Brotkrumen und optional Hauptnavigation; Sichtbarkeit vererbt sich auf Unterseiten - Pagebuilder (Block-Registry im Kern, Plugins tragen Blöcke bei): Abschnitt, Spalten, Tabs, Akkordeon, Box, Überschrift, Text (TipTap), Zitat, Schaltflächen, Symbolliste, Tabelle, Trennlinie, Abstand, Bild, Galerie, Video (erst nach Klick), Titelbild, Ansprechpartner, Downloads, Unterseiten, Neuigkeiten, Termine; Sichtbarkeit je Block; Bereinigung beim Speichern - Editor im Portal: Ziehen und Ablegen, Autospeichern als Entwurf, Rückgängig, Gerätevorschau, Versionen, Zeitsteuerung, Bearbeitungssperre, Freigabe anfordern - Rechte „inkl. Unterseiten“ werden im Rechte-Cache aufgelöst - Neuigkeiten: Schreiben im Portal, Freigabe-Workflow mit Benachrichtigungen - Bereich „Redaktion“, Benachrichtigungen im Portal - storage/.migrations-fingerprint nicht mehr ausliefern Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
134 lines
5.1 KiB
PHP
134 lines
5.1 KiB
PHP
<?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). 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)
|
||
->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)));
|
||
}
|
||
});
|
||
}
|
||
|
||
public static function allows(string $type, int $id, ?User $user): bool
|
||
{
|
||
$rules = Audience::query()->where('resource_type', $type)->where('resource_id', $id);
|
||
|
||
if (! (clone $rules)->exists()) {
|
||
return true;
|
||
}
|
||
|
||
return $user !== null && $rules->where(fn ($q) => self::matching($q->getQuery(), $user))->exists();
|
||
}
|
||
|
||
/**
|
||
* @param array{role?: list<int|string>, department?: list<string>, location?: list<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>}
|
||
*/
|
||
public static function get(string $type, int $id): array
|
||
{
|
||
$rules = ['role' => [], 'department' => [], 'location' => []];
|
||
|
||
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>}> 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' => []];
|
||
$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>}|null $rules
|
||
*/
|
||
public static function matches(?array $rules, ?User $user): bool
|
||
{
|
||
$rules = array_filter((array) $rules);
|
||
|
||
if ($rules === []) {
|
||
return true;
|
||
}
|
||
|
||
if ($user === null) {
|
||
return false;
|
||
}
|
||
|
||
$roleIds = array_map('strval', $user->permissions()->roleIds);
|
||
|
||
return array_intersect(array_map('strval', $rules['role'] ?? []), $roleIds) !== []
|
||
|| (filled($user->department) && in_array($user->department, $rules['department'] ?? [], true))
|
||
|| (filled($user->location) && in_array($user->location, $rules['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));
|
||
}
|
||
}
|
||
}
|