*/ class FiltersExact implements Filter { protected array $relationConstraints = []; public function __construct(protected bool $addRelationConstraint = true) { } /** {@inheritdoc} */ public function __invoke(Builder $query, $value, string $property) { if ($this->addRelationConstraint) { if ($this->isRelationProperty($query, $property)) { $this->withRelationConstraint($query, $value, $property); return; } } if (is_array($value)) { $query->whereIn($query->qualifyColumn($property), $value); return; } $query->where($query->qualifyColumn($property), '=', $value); } protected function isRelationProperty(Builder $query, string $property): bool { if (! Str::contains($property, '.')) { return false; } if (in_array($property, $this->relationConstraints)) { return false; } $firstRelationship = explode('.', $property)[0]; if (! method_exists($query->getModel(), $firstRelationship)) { return false; } return is_a($query->getModel()->{$firstRelationship}(), Relation::class); } protected function withRelationConstraint(Builder $query, mixed $value, string $property): void { [$relation, $property] = collect(explode('.', $property)) ->pipe(fn (Collection $parts) => [ $parts->except(count($parts) - 1)->implode('.'), $parts->last(), ]); $query->whereHas($relation, function (Builder $query) use ($property, $value) { /** @var Builder $query */ $this->relationConstraints[] = $property = $query->qualifyColumn($property); $this->__invoke($query, $value, $property); }); } }