wotroe Posts - Answer Overflow

wotroe

•Created by wotroe on 9/12/2023 in #❓┊help

Opening edit modal from a different resource (simple modal resources)

Hi, I was wondering whether it's possible to create an action in a resource to open an edit modal from a different resource. Let's say I have two models, a Dog model and a DogOwner model. I have a resource for both of them. In an ideal scenario, I'd like to have an 'Edit Dog Owner' button in the Dog resource, preferably without using relation managers for the sake of simplicity. Is this possible?

4 replies

FFilament

•Created by wotroe on 8/17/2023 in #❓┊help

Hide column in relationmanager based on parent model

I've Ctrl+F'ed through the server in the hopes that I could find a solution, but unfortunately couldn't find a result that solved my issue. I'm trying to hide a column in a RelationManager if the parent record has a specific import_type, but I couldn't figure out how to pull this off since the table method is static, and the getOwnerRecord isn't. Any suggestions? Thanks in advance!

Tables\Columns\TextColumn::make('total_quantity')
                    ->suffix(' points')
                    ->hidden($this->getOwnerRecord()->import_type->hasCustomUnitPricing())
                    ->formatStateUsing(fn(?string $state): string => (double) $state)
                    ->sortable(),

Tables\Columns\TextColumn::make('total_quantity')
                    ->suffix(' points')
                    ->hidden($this->getOwnerRecord()->import_type->hasCustomUnitPricing())
                    ->formatStateUsing(fn(?string $state): string => (double) $state)
                    ->sortable(),

This was what I had in mind, but this unfortunately doesn't work since I can't use $this in a static function.

4 replies

FFilament

•Created by wotroe on 8/10/2023 in #❓┊help

Using ->having on a query when using a TernaryFilter

I'm trying to filter my Filament table using a ->having query with Filament, but the having query doesn't appear to do anything. This is my filter:

TernaryFilter::make('minimum_invoice_amount')
                    ->placeholder('All invoices')
                    ->trueLabel('Invoiceable amount above € 5')
                    ->falseLabel('Invoiceable amount below € 5')
                    ->queries(
                        true: fn (Builder $query) => $query->having('total_price_excl_vat', '>=', 5),
                        false: fn (Builder $query) => $query->having('total_price_excl_vat', '<=', 5),
                        blank: fn (Builder $query) => $query,
                    )

TernaryFilter::make('minimum_invoice_amount')
                    ->placeholder('All invoices')
                    ->trueLabel('Invoiceable amount above € 5')
                    ->falseLabel('Invoiceable amount below € 5')
                    ->queries(
                        true: fn (Builder $query) => $query->having('total_price_excl_vat', '>=', 5),
                        false: fn (Builder $query) => $query->having('total_price_excl_vat', '<=', 5),
                        blank: fn (Builder $query) => $query,
                    )

And my table query:

        return parent::getTableQuery()
            ->selectRaw('invoices.*, hostbill_clients.id as hostbill_client_id, SUM(unit_price*quantity) as total_price_excl_vat')
            ->join('invoice_lines', 'invoice_lines.invoice_id', '=', 'invoices.id')
            ->join('external_customers', 'external_customers.id', '=', 'invoices.external_customer_id')
            ->leftJoin('hostbill_clients', 'hostbill_clients.id', '=', 'external_customers.hostbill_client_id')
            ->groupBy('invoices.id');

        return parent::getTableQuery()
            ->selectRaw('invoices.*, hostbill_clients.id as hostbill_client_id, SUM(unit_price*quantity) as total_price_excl_vat')
            ->join('invoice_lines', 'invoice_lines.invoice_id', '=', 'invoices.id')
            ->join('external_customers', 'external_customers.id', '=', 'invoices.external_customer_id')
            ->leftJoin('hostbill_clients', 'hostbill_clients.id', '=', 'external_customers.hostbill_client_id')
            ->groupBy('invoices.id');

The filters themselves work fine, I tested it with the following:

->queries(
    true: fn (Builder $query) => $query->whereRaw('1=2')->having('total_price_excl_vat', '>=', 5),
    false: fn (Builder $query) => $query->whereRaw('1=1')->having('total_price_excl_vat', '<=', 5),
    blank: fn (Builder $query) => $query->whereRaw('1=1'),
)

->queries(
    true: fn (Builder $query) => $query->whereRaw('1=2')->having('total_price_excl_vat', '>=', 5),
    false: fn (Builder $query) => $query->whereRaw('1=1')->having('total_price_excl_vat', '<=', 5),
    blank: fn (Builder $query) => $query->whereRaw('1=1'),
)

In that case, the 'true' option gave no results, but the bottom two did. Removing the whereRaw line from all filters makes them all return the full table. It appears that the having statement gets ignored? I get no errors, but changing the filters doesn't do anything. Manually adding the filter to my table query does work. Does anyone know how I could fix this?

7 replies

FFilament

•Created by wotroe on 8/3/2023 in #❓┊help

Filling in hasMany relationship from Filament form

19 replies

Gaming

Programming