Augus Posts - Answer Overflow

Augus

•Created by Augus on 9/12/2024 in #❓┊help

Sorting ignores relation condition

Hi, I have been trying to get this to work but im stuck. Basically i got a relation on my record called 'animals' and on the table i need to have several counts of this object with different conditions, like so:

                Tables\Columns\TextColumn::make('active_animals')
                    ->getStateUsing(fn (Family $record): string => $record->animals()->where('active', true)->count())
                    ->sortable(query: function (Builder $query, string $direction): Builder {
                        return $query
                            ->orderBy('animals_count', $direction);
                    })->label('Aantal actieve dieren'),

                Tables\Columns\TextColumn::make('active_animals')
                    ->getStateUsing(fn (Family $record): string => $record->animals()->where('active', true)->count())
                    ->sortable(query: function (Builder $query, string $direction): Builder {
                        return $query
                            ->orderBy('animals_count', $direction);
                    })->label('Aantal actieve dieren'),

Initially i had a custom attribute:

    public function getActiveAnimalsCountAttribute(): string
    {
        return $this->animals()->where('active', true)->count();
    }

    public function getActiveAnimalsCountAttribute(): string
    {
        return $this->animals()->where('active', true)->count();
    }

But i was unable to sort on this. Then i figured maybe im able to push this logic to the database and add a virtual column with the count where active is true. But couldn't find any resource on how to do this. So now i tried the sortable function but somehow when i sort it orders by the actual 'animals_count' (makes sense given the function). But this discards the "where animal is active". Basically now im stuck and have not really an idea how to move forward... Anyone has experience with this of has some ideas?

22 replies

FFilament

•Created by Augus on 7/31/2024 in #❓┊help

Add shared data to Infolist Livewire fields

I am using custom LiveWire components in my Infolist which look like so:

                        InfolistSection::make('RVO')
                            ->schema([
                                Livewire::make(Details::class),
                            ]),
                        InfolistSection::make('RVO Verblijfplaats(en)')
                            ->collapsible()
                            ->collapsed()
                            ->schema([
                                Livewire::make(Locations::class),
                            ]),

                        InfolistSection::make('RVO')
                            ->schema([
                                Livewire::make(Details::class),
                            ]),
                        InfolistSection::make('RVO Verblijfplaats(en)')
                            ->collapsible()
                            ->collapsed()
                            ->schema([
                                Livewire::make(Locations::class),
                            ]),

But both of those components are making an identical call in the mount() function like so:

    public function mount(): void
    {
        $data = (new Animal)->detail($this->record->country_code, $this->record->registration_number)->get();
        $this->locations = $data ? $data['locations'] : false;
    }

    public function mount(): void
    {
        $data = (new Animal)->detail($this->record->country_code, $this->record->registration_number)->get();
        $this->locations = $data ? $data['locations'] : false;
    }

and

    public function mount(): void
    {
        $data = (new Animal)->detail($this->record->country_code, $this->record->registration_number)->get();
        $this->details = $data ? $data['details'] : false;
        $this->translate();
    }

    public function mount(): void
    {
        $data = (new Animal)->detail($this->record->country_code, $this->record->registration_number)->get();
        $this->details = $data ? $data['details'] : false;
        $this->translate();
    }

So i wanted to create the variable $data in the infolist function but i am unable to access the resource here. Wanted situation:

     public static function infolist(Infolist $infolist): Infolist
    {
        $data = (new Animal)->detail($resource->record->country_code, $resource->record->registration_number)->get();

        return $infolist
            ->schema([

     public static function infolist(Infolist $infolist): Infolist
    {
        $data = (new Animal)->detail($resource->record->country_code, $resource->record->registration_number)->get();

        return $infolist
            ->schema([

And then i would call the Livewire components as followed:

                        InfolistSection::make('RVO')
                            ->schema([
                                Livewire::make(Details::class, ['data' => $data]),
                            ]),

                        InfolistSection::make('RVO')
                            ->schema([
                                Livewire::make(Details::class, ['data' => $data]),
                            ]),

All this would be to not call the same Animal function on one page (since this is an API call to a third party). How would i be able to create an $data variable like above to pass to multiple Livewire fields in my infolist?

25 replies

FFilament

•Created by Augus on 2/24/2024 in #❓┊help

Widget loading slow & showing white background?

2 replies

FFilament

•Created by Augus on 12/10/2023 in #❓┊help

Relationship not saved to Model on Section

In my UserResource i got a Section as followed:

  Section::make('Contactgegevens')
    ->relationship('contact')
    ->schema([...

  Section::make('Contactgegevens')
    ->relationship('contact')
    ->schema([...

This does create a new contact when i fill in the needed fields, but it does not attach that contact to my User. User Model:

    public function contact(): HasOne
    {
        return $this->hasOne(Contact::class, 'id', 'contact_id');
    }

    public function contact(): HasOne
    {
        return $this->hasOne(Contact::class, 'id', 'contact_id');
    }

Contact Model:

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class, 'contact_id', 'id');
    }

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class, 'contact_id', 'id');
    }

My users table has an

contact_id

contact_id

field which should be filled with the created contact. But it isn't. I think the issue is somewhere in my code but for the love of me im not able to see it.

10 replies

FFilament

•Created by Augus on 11/6/2023 in #❓┊help

Live function does not empty radio field

What I am trying to do: I want to have the Radio field 'ubn' be emptied whenever i change the select field 'relation'. Do note that the Radio options are filled with the Select change as seen in the options function of that field. What I did: I tried adding the afterStateUpdated to the select field as shown in the example, this was my best guess. Also tried the dehydrateStateUsing on the Radio field but that would empty it always. My issue: My issue is that although visually the radio is deselected whenever i change the Select field. But the Radio is not deselected on the "backend" as in it will go trough validation and i can still access it via the Get $get. Code:

Select::make('relation')
        ->searchable()
        ->label('Relatie')
        ->live()
        ->required()
        ->options([
            'Uw relaties' => auth()->user()->relations->mapWithKeys(function ($relation) {
                                        return [$relation->id => $relation->full_name];
                             })->toArray(),
            'Leden' => User::with('contact')->get()->pluck('contact.full_name','contact.id')->toArray(),

        ])
        ->afterStateUpdated(fn (Set $set, ?string $state) => $set('ubn', '')),

Radio::make('ubn')
        ->label('UBN')
        ->required()
        ->disabled(empty($this->data['relation']))
        ->options(fn (Get $get ): Collection|array => ! empty($get('relation')) ? Contact::find($get('relation'))->locations()->pluck('name','id')->toArray() : ['#' => 'Selecteer eerst een relatie']
        ),

Select::make('relation')
        ->searchable()
        ->label('Relatie')
        ->live()
        ->required()
        ->options([
            'Uw relaties' => auth()->user()->relations->mapWithKeys(function ($relation) {
                                        return [$relation->id => $relation->full_name];
                             })->toArray(),
            'Leden' => User::with('contact')->get()->pluck('contact.full_name','contact.id')->toArray(),

        ])
        ->afterStateUpdated(fn (Set $set, ?string $state) => $set('ubn', '')),

Radio::make('ubn')
        ->label('UBN')
        ->required()
        ->disabled(empty($this->data['relation']))
        ->options(fn (Get $get ): Collection|array => ! empty($get('relation')) ? Contact::find($get('relation'))->locations()->pluck('name','id')->toArray() : ['#' => 'Selecteer eerst een relatie']
        ),

3 replies

FFilament

•Created by Augus on 9/28/2023 in #❓┊help

Custom error pages

So in the past i used https://v2.filamentphp.com/tricks/custom-laravel-error-pages for my custom error pages and this worked great. But this doesn't work anymore with V3. I have been trying to get started with several filament components (panel:s:page, panels::layout, etc) but they either need an $this or they are missing Livewire. Which all make sense but what would be the best approach to create a proper 404 page inside Filament.

21 replies

FFilament

•Created by Augus on 9/25/2023 in #❓┊help

Select field issues with combination of Live + Disabled.

So i have been playing around whole night to get this to work but im simply not able to. What i want to do is pretty simple though; 1. I want to have the "Location" (UBN) select field to be disabled. 2. User selects a "Contact" (Relatie) in the first select field. 3. When a "Contact" is selected i want to search for all related "Location" objects for that contact and place them in field 2 as options. 3. When options are loaded or when User selected the "Contact" in field #1 i want to enable field #2. 4. User selects "Location" (UBN)

                            Select::make('relation')
                                ->searchable()
                                ->label('Relatie')
                                ->live()
                                ->options(
                                    auth()->user()->relations->mapWithKeys(function ($relation) {
                                        return [$relation->id => $relation->full_name];
                                    })
                                ),
                            Select::make('ubn')
                                ->searchable()
                                ->label('UBN')
                                ->disabled(empty($this->data['relation']))
                                ->options(fn (Get $get
                                ): Collection|array => ! empty($get('relation')) ? Contact::find($get('relation'))->locations()->pluck('ubn',
                                    'id') : ['#' => 'Selecteer eerst een relatie']
                                ),

                            Select::make('relation')
                                ->searchable()
                                ->label('Relatie')
                                ->live()
                                ->options(
                                    auth()->user()->relations->mapWithKeys(function ($relation) {
                                        return [$relation->id => $relation->full_name];
                                    })
                                ),
                            Select::make('ubn')
                                ->searchable()
                                ->label('UBN')
                                ->disabled(empty($this->data['relation']))
                                ->options(fn (Get $get
                                ): Collection|array => ! empty($get('relation')) ? Contact::find($get('relation'))->locations()->pluck('ubn',
                                    'id') : ['#' => 'Selecteer eerst een relatie']
                                ),

Above simply does not load any options for field #2 (UBN) but this is mainly because the ->disabled(empty($this->data['relation'])) cause removing this let's both fields work as expected. But you can imagine that having the second field disabled when there is no option selected in the first field would be more user friendly. Am i doing something wrong or is this simply not possible?

10 replies

FFilament

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

Create 'check' step inside wizard.

How would i approach adding an 'check' step inside a wizard? - The user needs to confirm the data he/she filled in. - I need to be able to call an function based on the form fields to show an error message or primary message on the last step. Is there a confirm step i can use or ideally create a last step within the wizard? I tried this with placeholder fields in a last step but since the function i want to call makes an API call i only want to call this in the end and not on every wizard step (what it's doing now).

4 replies

FFilament

•Created by Augus on 7/29/2023 in #❓┊help

Get SOAP data in Filament

So i got some connections with a really old SOAP client where i wanna show the data (array) in Filament (i don't need to process it or anything just showing). My idea was to create a Model with the data and Hydrate it from the SOAP data, but for the love of me i can't seem to find the proper way to do this. So my question is, is the hydration way a proper path to do this and how would i approach this in Filamentphp (keep in mind for now i only care about showing the data). Or is there a better way to create a Filamentphp Table/list page with this raw array data?

5 replies

FFilament

•Created by Augus on 7/26/2023 in #❓┊help

V3 Tabs set default

Regarding to the Tabs for listing records (https://beta.filamentphp.com/docs/3.x/panels/resources/listing-records) is it possible to set an default tab that's not the first record? And if not how can i make a feature request to get this in?

4 replies

FFilament

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

Is this a bug or intended behaviour? (Select relationship)

So i got the following select field, do note that 'full_name' is an virtual column:

                Forms\Components\Select::make('ram_id')
                    ->label('Ram')
                    ->required()
                    ->relationship(
                        'ram',
                        'full_name',
                        fn(Builder $query) => $query
                            ->where('active', '=', true)
                            ->where('gender', '=', 'M')
                    )
                    ->preload()
                    ->searchable(),

                Forms\Components\Select::make('ram_id')
                    ->label('Ram')
                    ->required()
                    ->relationship(
                        'ram',
                        'full_name',
                        fn(Builder $query) => $query
                            ->where('active', '=', true)
                            ->where('gender', '=', 'M')
                    )
                    ->preload()
                    ->searchable(),

Just to be sure the virtual column:

            $table->string('full_name')->storedAs("country_code || registration_number || ' - ' || name");

            $table->string('full_name')->storedAs("country_code || registration_number || ' - ' || name");

But when i got a Resource where the already select Ram is not active anymore it doesn't show the 'full_name' but the ID of that Ram. I would suspect that it would still show the 'full_name' cause i see no reason why not. I got it fixed myself though by adding the following, but again i think it shouldn't have to:

                    ->getOptionLabelUsing(fn ($value): ?string => Animal::find($value)?->full_name)

                    ->getOptionLabelUsing(fn ($value): ?string => Animal::find($value)?->full_name)

This shows the 'full_name' even though the Ram is not active anymore.

25 replies

FFilament

•Created by Augus on 3/2/2023 in #❓┊help

Issue with search on relation & attribute as select name.

So i got a bit complicated select question:

                Forms\Components\Select::make('ram_id')
                    ->label('Ram')
                    ->relationship('ram', 'select_name')
                    ->required()
                    ->searchable( [ 'animals.country_code', 'animals.registration_number', 'animals.name' ] ),

                Forms\Components\Select::make('ram_id')
                    ->label('Ram')
                    ->relationship('ram', 'select_name')
                    ->required()
                    ->searchable( [ 'animals.country_code', 'animals.registration_number', 'animals.name' ] ),

I want to make an select field which has a relation with the ram relation (hasOne Animal). Where i can search the field based on country_code/registration_number/name. The 'select_name' is an attribute set in the model as followed:

    public function getSelectNameAttribute(): string {
        return $this->country_code . $this->registration_number . ' - ' . $this->name;
    }

    public function getSelectNameAttribute(): string {
        return $this->country_code . $this->registration_number . ' - ' . $this->name;
    }

But with the given code i get the following error, which makes sense but i don't really got a clue on how to solve it.

SQLSTATE[42703]: Undefined column: 7 ERROR: column "select_name" does not exist LINE 1: select "select_name", "id" from "animals" where ("animals"."... ^ (Connection: pgsql, SQL: select "select_name", "id" from "animals" where ("animals"."country_code"::text ilike %nhenk% or "animals"."registration_number"::text ilike %nhenk% or "animals"."name"::text ilike %nhenk%) order by "select_name" asc limit 50)

SQLSTATE[42703]: Undefined column: 7 ERROR: column "select_name" does not exist LINE 1: select "select_name", "id" from "animals" where ("animals"."... ^ (Connection: pgsql, SQL: select "select_name", "id" from "animals" where ("animals"."country_code"::text ilike %nhenk% or "animals"."registration_number"::text ilike %nhenk% or "animals"."name"::text ilike %nhenk%) order by "select_name" asc limit 50)

38 replies

Gaming

Programming