FuzzyFilter

FuzzyFilter.php

<?php

namespace Spatie\Mailcoach\Http\App\Queries\Filters;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Arr;
use Illuminate\Support\Str;
use Spatie\QueryBuilder\Filters\Filter;

class FuzzyFilter implements Filter
{
    /** @var string[] */
    protected array $fields;

    public function __construct(string ...$fields)
    {
        $this->fields = $fields;
    }

    public function __invoke(Builder $query, $values, string $property): Builder
    {
        $values = Arr::wrap($values);

        $query->where(function (Builder $query) use ($values) {
            $this
                ->addDirectFields($query, $values)
                ->addRelationShipFields($query, $values);
        });

        return $query;
    }

    public function addDirectFields(Builder $query, $values)
    {
        collect($this->fields)
            ->reject(fn (string $field) => Str::contains($field, '.'))
            ->each(function (string $field) use ($query, $values) {
                foreach ($values as $value) {
                    $query->orWhere($field, 'LIKE', "%{$value}%");
                }
            });

        return $this;
    }

    public function addRelationShipFields(Builder $query, $values)
    {
        collect($this->fields)
            ->filter(fn (string $field) => Str::contains($field, '.'))
            ->each(function (string $field) use ($query, $values) {
                foreach ($values as $value) {
                    [$relation, $field] = explode('.', $field);

                    $query->orWhereHas($relation, function (Builder $query) use ($field, $value) {
                        $query->where($field, 'LIKE', "%{$value}%");
                    });
                }
            });

        return $this;
    }
}

AllowedFilter::custom('keywords', new FuzzyFilter('name', 'description_1', 'company.name')),

Fixed:

public function addRelationShipFields(Builder $query, $values)
{
    collect($this->fields)
        ->filter(fn (string $field) => Str::contains($field, '.'))
        ->each(function (string $field) use ($query, $values) {
            foreach ($values as $value) {
                [$relation, $column] = explode('.', $field);

                $query->orWhereHas($relation, function (Builder $query) use ($column, $value) {
                    $query->where($column, 'LIKE', "%{$value}%");
                });
            }
        });

    return $this;
}