integer('person') ? User::query()->active()->find($request->integer('person')) : null; // Oberste Ebene: aktive Personen ohne (aktive) Vorgesetzte, die selbst ein Team haben. $roots = $this->nodes(User::query()->active() ->where(fn (Builder $q) => $q->whereNull('manager_id')->orWhereDoesntHave('manager', fn (Builder $m) => $m->where('is_active', true))) ->whereHas('reports', fn (Builder $r) => $r->where('is_active', true))); // Weg von oben zur gewählten Person, samt Team jeder Ebene. $path = []; $teams = []; if ($focus) { $current = $focus; for ($i = 0; $current && $i < 30; $i++) { array_unshift($path, $current->id); $current = $current->manager_id ? User::query()->active()->find($current->manager_id) : null; } foreach ($path as $id) { $teams[$id] = $this->nodes(User::query()->active()->where('manager_id', $id)); } // Wer oben im Weg steht, aber (z. B. ohne Team) nicht in der obersten Ebene ist, dazunehmen. if (! $roots->contains('id', $path[0])) { $roots = $roots->push(...$this->nodes(User::query()->whereKey($path[0])))->values(); } } elseif ($roots->count() === 1) { // Nur eine Spitze (z. B. die Geschäftsführung): erste Ebene gleich zeigen. $path = [$roots[0]['id']]; $teams[$path[0]] = $this->nodes(User::query()->active()->where('manager_id', $path[0])); } return Inertia::render('People/Organigram', [ 'roots' => $roots, 'path' => $path, 'teams' => (object) $teams, 'focus' => $focus?->id, 'unassigned' => User::query()->active()->whereNull('manager_id')->whereDoesntHave('reports')->count(), ]); } public function team(User $user): JsonResponse { abort_unless($user->is_active, 404); return response()->json(['team' => $this->nodes(User::query()->active()->where('manager_id', $user->id))]); } /** * @param Builder $query * @return Collection> */ private function nodes(Builder $query): Collection { return $query->withCount(['reports' => fn (Builder $r) => $r->where('is_active', true)]) ->orderBy('last_name')->orderBy('first_name') ->limit(500) ->get() ->map(fn (User $u) => [ 'id' => $u->id, 'name' => $u->name, 'initials' => $u->initials, 'job_title' => $u->job_title, 'department' => $u->department, 'avatar_url' => $u->avatarUrl(96), 'reports' => $u->reports_count, ]); } }