getConstraint()->isMultiple() ? ( $this->isInverse() ? 'filament-query-builder::query-builder.operators.relationship.is_related_to.label.multiple.inverse' : 'filament-query-builder::query-builder.operators.relationship.is_related_to.label.multiple.direct' ) : ( $this->isInverse() ? 'filament-query-builder::query-builder.operators.relationship.is_related_to.label.single.inverse' : 'filament-query-builder::query-builder.operators.relationship.is_related_to.label.single.direct' ), ); } public function getSummary(): string { $constraint = $this->getConstraint(); $values = $this->getValueSetting(); $relationshipQuery = $this->getRelationshipQuery(); $values = $relationshipQuery ->when( $this->getRelationship() instanceof BelongsToThrough, fn (Builder $query) => $query->distinct(), ) ->whereKey($values) ->pluck($relationshipQuery->qualifyColumn($this->getTitleAttribute())) ->join(glue: __('filament-query-builder::query-builder.operators.relationship.is_related_to.summary.values_glue.0'), finalGlue: __('filament-query-builder::query-builder.operators.relationship.is_related_to.summary.values_glue.final')); return __( $this->getConstraint()->isMultiple() ? ( $this->isInverse() ? 'filament-query-builder::query-builder.operators.relationship.is_related_to.summary.multiple.inverse' : 'filament-query-builder::query-builder.operators.relationship.is_related_to.summary.multiple.direct' ) : ( $this->isInverse() ? 'filament-query-builder::query-builder.operators.relationship.is_related_to.summary.single.inverse' : 'filament-query-builder::query-builder.operators.relationship.is_related_to.summary.single.direct' ), [ 'relationship' => $constraint->getAttributeLabel(), 'values' => $values, ], ); } /** * @return array */ public function getFormSchema(): array { $constraint = $this->getConstraint(); $field = Select::make($constraint->isMultiple() ? 'values' : 'value') ->label(__($constraint->isMultiple() ? 'filament-query-builder::query-builder.operators.relationship.is_related_to.form.values.label' : 'filament-query-builder::query-builder.operators.relationship.is_related_to.form.value.label')) ->multiple($this->isMultiple()) ->searchable($this->isSearchable()) ->preload($this->isPreloaded()) ->native($this->isNative()) ->optionsLimit($this->getOptionsLimit()) ->required() ->model($constraint->getModel()) ->relationship( $constraint->getRelationshipName(), $this->getTitleAttribute(), $this->modifyRelationshipQueryUsing, ) ->forceSearchCaseInsensitive($this->isSearchForcedCaseInsensitive()) ->dehydrated() ->columnSpanFull(); if ($this->getOptionLabelUsing) { $field->getOptionLabelUsing($this->getOptionLabelUsing); } if ($this->getOptionLabelsUsing) { $field->getOptionLabelsUsing($this->getOptionLabelsUsing); } if ($this->getOptionLabelFromRecordUsing) { $field->getOptionLabelFromRecordUsing($this->getOptionLabelFromRecordUsing); } if ($this->getSearchResultsUsing) { $field->getSearchResultsUsing($this->getSearchResultsUsing); } return [$field]; } public function titleAttribute(string | Closure | null $attribute): static { $this->titleAttribute = $attribute; return $this; } public function modifyRelationshipQueryUsing(?Closure $modifyQueryUsing = null): static { $this->modifyRelationshipQueryUsing = $modifyQueryUsing; return $this; } public function getOptionLabelUsing(?Closure $callback): static { $this->getOptionLabelUsing = $callback; return $this; } public function getOptionLabelsUsing(?Closure $callback): static { $this->getOptionLabelsUsing = $callback; return $this; } public function getSearchResultsUsing(?Closure $callback): static { $this->getSearchResultsUsing = $callback; return $this; } public function apply(Builder $query, string $qualifiedColumn): Builder { $constraint = $this->getConstraint(); $value = $this->getValueSetting(); // Security: nothing valid remains to filter by after discarding tampered values. if (($value === null) || ($value === [])) { return $query; } return $query->{$this->isInverse() ? 'whereDoesntHave' : 'whereHas'}( $constraint->getRelationshipName(), function (Builder $query) use ($value): Builder { if ($this->modifyRelationshipQueryUsing) { $query = $this->evaluate($this->modifyRelationshipQueryUsing, [ 'query' => $query, ]) ?? $query; } return $query->whereKey($value); }, ); } protected function getValueSetting(): mixed { $value = $this->getSettings()[$this->getConstraint()->isMultiple() ? 'values' : 'value'] ?? null; // Security: settings arrive from the request payload and can be tampered with. The value // may be a scalar key or a list of scalar keys, depending on whether the operator is // `multiple()`, but any other shape (e.g. a nested array) would reach `whereKey()` // binding and crash the request. Fail closed by discarding non-scalar values. if (is_array($value)) { return array_values(array_filter($value, is_scalar(...))); } return is_scalar($value) ? $value : null; } public function getConstraint(): ?RelationshipConstraint { $constraint = parent::getConstraint(); if (! $constraint) { return null; } if (! ($constraint instanceof RelationshipConstraint)) { throw new LogicException('Is operator can only be used with relationship constraints.'); } return $constraint; } public function forceSearchCaseInsensitive(bool | Closure | null $condition = true): static { $this->isSearchForcedCaseInsensitive = $condition; return $this; } public function isSearchForcedCaseInsensitive(): ?bool { return $this->evaluate($this->isSearchForcedCaseInsensitive); } public function getModifyRelationshipQueryUsing(): ?Closure { return $this->modifyRelationshipQueryUsing; } public function getRelationship(): Relation | Builder { $constraint = $this->getConstraint(); $record = app($constraint->getModel()); $relationship = null; foreach (explode('.', $constraint->getRelationshipName()) as $nestedRelationshipName) { if ($record->hasAttribute($nestedRelationshipName)) { $relationship = null; break; } if (! $record->isRelation($nestedRelationshipName)) { $relationship = null; break; } $relationship = $record->{$nestedRelationshipName}(); $record = $relationship->getRelated(); } return $relationship; } public function getRelationshipQuery(): ?Builder { $relationship = Relation::noConstraints(fn () => $this->getRelationship()); $relationshipQuery = app(RelationshipJoiner::class)->prepareQueryForNoConstraints($relationship); if ($this->getModifyRelationshipQueryUsing()) { $relationshipQuery = $this->evaluate($this->modifyRelationshipQueryUsing, [ 'query' => $relationshipQuery, ]) ?? $relationshipQuery; } if (empty($relationshipQuery->getQuery()->orders)) { $relationshipQuery->orderBy($relationshipQuery->qualifyColumn($this->getTitleAttribute())); } return $relationshipQuery; } public function getTitleAttribute(): ?string { return $this->evaluate($this->titleAttribute); } public function multiple(bool | Closure $condition = true): static { $this->isMultiple = $condition; return $this; } public function isMultiple(): bool { return (bool) $this->evaluate($this->isMultiple); } public function searchable(bool | Closure $condition = true): static { $this->isSearchable = $condition; return $this; } public function isSearchable(): bool { return (bool) $this->evaluate($this->isSearchable); } public function optionsLimit(int | Closure $limit): static { $this->optionsLimit = $limit; return $this; } public function getOptionsLimit(): int { return $this->evaluate($this->optionsLimit); } public function native(bool | Closure $condition = true): static { $this->isNative = $condition; return $this; } public function isNative(): bool { return (bool) $this->evaluate($this->isNative); } public function getOptionLabelFromRecordUsing(?Closure $callback): static { $this->getOptionLabelFromRecordUsing = $callback; return $this; } public function preload(bool | Closure $condition = true): static { $this->isPreloaded = $condition; return $this; } public function isPreloaded(): bool { return (bool) $this->evaluate($this->isPreloaded); } }