isInverse() ? 'filament-query-builder::query-builder.operators.text.equals.label.inverse' : 'filament-query-builder::query-builder.operators.text.equals.label.direct', ); } public function getSummary(): string { return __( $this->isInverse() ? 'filament-query-builder::query-builder.operators.text.equals.summary.inverse' : 'filament-query-builder::query-builder.operators.text.equals.summary.direct', [ 'attribute' => $this->getConstraint()->getAttributeLabel(), 'text' => $this->getStringSetting('text'), ], ); } /** * @return array */ public function getFormSchema(): array { return [ TextInput::make('text') ->label(__('filament-query-builder::query-builder.operators.text.form.text.label')) ->required() ->columnSpanFull(), ]; } public function apply(Builder $query, string $qualifiedColumn): Builder { // Security: skip applying the constraint when the tampered setting is not a scalar string. $text = $this->getStringSetting('text'); if ($text === null) { return $query; } /** @var Connection $databaseConnection */ $databaseConnection = $query->getConnection(); $isPostgres = $databaseConnection->getDriverName() === 'pgsql'; if ($isPostgres) { $parts = explode('.', $qualifiedColumn); if (count($parts) === 3) { [$schema, $table, $column] = $parts; $table = "{$schema}.{$table}"; } else { [$table, $column] = $parts; } if (Str::lower($table) !== $table) { $table = collect(explode('.', $table)) ->map(fn (string $segment): string => "\"{$segment}\"") ->implode('.'); } if (Str::lower($column) !== $column) { $column = "\"{$column}\""; } $qualifiedColumn = new Expression("lower({$table}.{$column}::text)"); $text = Str::lower($text); } return $query->{$this->isInverse() ? 'whereNot' : 'where'}($qualifiedColumn, 'like', $text); } }