mandant-crm/backend/app/Modules/Client/Actions/GetClientAction.php

<?php

namespace App\Modules\Client\Actions;

use App\Modules\Client\Models\Client;
use Illuminate\Database\Eloquent\Collection;

final class GetClientAction
{
    public function list(): Collection
    {
        return Client::query()
            ->withCount('historyEntries')
            ->withMax('historyEntries', 'created_at')
            ->orderBy('name')
            ->get();
    }

    public function find(int $id): Client
    {
        return Client::with('customFieldValues.author')->findOrFail($id);
    }
}