Support nested realtion multiple filters (one whereHas for several filters)

[sidigi]

The idea: Make some filters grouped by scope.

Example with one relation and many filters in it (it is one whereHas method for query instead many)

use Spatie\QueryBuilder\QueryBuilder;
use App\Models\Particpant;

QueryBuilderfor(Participant::query())->allowedFilters([
            AllowedFilter::exact('id'),
            AllowedFilter::exact('user_id'),

            ...resolve(NestedRelationScopeFilter::class)(
                $this->getEloquentBuilder(),
                'sharedProfiles',
                AllowedFilter::exact('shared_profile_id', 'id'),
                AllowedFilter::exact('shared_for_participant_id', 'participant_id'),
                AllowedFilter::callback('shared_approve', function (Builder $query, $value) {
                    $query->where((new SharedProfile())->getTable().'.is_approved', $value);
                }),
            ),
        ]);

<?php

namespace Support\Http\Queries\Builder;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Spatie\QueryBuilder\AllowedFilter;
use Spatie\QueryBuilder\QueryBuilder;

class NestedRelationScopeFilter
{
    public function __construct(protected Request $request)
    {
    }

    /** @return array<int, AllowedFilter> */
    public function __invoke(Builder $query, string $relation, mixed ...$filters): array
    {
        if ($this->isEmptyFiltersInRequest($filters)) {
            return [];
        }

        $query->whereHas($relation, function ($query) use ($filters) {
            collect($filters)->each(function ($filter) use ($query) {
                $filter->filter(QueryBuilder::for($query), $this->request->filters($filter->getName()));
            });
        });

        return $this->makeEmptyAllowedFilters($filters);
    }

    protected function makeEmptyAllowedFilters(array $filters = []): array
    {
        return collect($filters)->map(fn ($item) => AllowedFilter::callback($item->getName(), function () {
        }))->toArray();
    }

    protected function isEmptyFiltersInRequest(array $filters = []): bool
    {
        return collect($filters)->map(fn ($filter) => $this->request->filters($filter->getName()))->filter()->isEmpty();
    }
}