Benjamin Comments - Answer Overflow

Benjamin

Posts Comments

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

Here is an exemple @khairulazmi_

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

It was better, but still too slow as my exports are including a lot of table. I ended up using FastExcel (https://github.com/rap2hpoutre/fast-excel) with Laravel Query Builder and it's way faster/easier to maintain. I could give you a code snippet if you want to see how I implemented it.

16 replies

FFilament

•Created by Benjamin on 2/25/2025 in #❓┊help

Array of actions on a custom page - Not possible ?

When I click, the action is loading for a few seconds, then it stops and nothing happen.

7 replies

FFilament

•Created by Benjamin on 2/25/2025 in #❓┊help

Array of actions on a custom page - Not possible ?

I tried and it's not working either (I think it's not required if the page lives in a Filament panel).

7 replies

FFilament

•Created by Benjamin on 2/25/2025 in #❓┊help

Array of actions on a custom page - Not possible ?

<?php

use App\Filament\Pages\Exports;

/** @var Exports $this */
?>

<x-filament-panels::page>

    <div class="grid grid-cols-12 gap-12">
        <?php foreach ($this->actions() as $title => $actions) { ?>
            <x-filament::section class="col-span-4">
                <x-slot name="heading">
                    <?= $title ?>
                </x-slot>

                <div class="flex flex-col gap-4">
                    <?php foreach ($actions as $action) { ?>
                        {{ $action }}
                    <?php } ?>
                </div>
            </x-filament::section>
        <?php } ?>
    </div>

</x-filament-panels::page>

<?php

use App\Filament\Pages\Exports;

/** @var Exports $this */
?>

<x-filament-panels::page>

    <div class="grid grid-cols-12 gap-12">
        <?php foreach ($this->actions() as $title => $actions) { ?>
            <x-filament::section class="col-span-4">
                <x-slot name="heading">
                    <?= $title ?>
                </x-slot>

                <div class="flex flex-col gap-4">
                    <?php foreach ($actions as $action) { ?>
                        {{ $action }}
                    <?php } ?>
                </div>
            </x-filament::section>
        <?php } ?>
    </div>

</x-filament-panels::page>

7 replies

FFilament

•Created by Fatboii on 2/6/2025 in #❓┊help

Web push notifications

Thanks a lot for your feedback ! I'm gonna implement it in a few weeks (or months, Idk yet), I'll tell you at that time how I managed to do or 🙂 @Fatboii

6 replies

FFilament

•Created by Fatboii on 2/6/2025 in #❓┊help

Web push notifications

Maybe this exemple @Fatboii :

use App\Models\User;
use Filament\Notifications\Notification;
 
public function toDatabase(User $notifiable): array
{
    return Notification::make()
        ->title('Saved successfully')
        ->getDatabaseMessage();
}

use App\Models\User;
use Filament\Notifications\Notification;
 
public function toDatabase(User $notifiable): array
{
    return Notification::make()
        ->title('Saved successfully')
        ->getDatabaseMessage();
}

6 replies

FFilament

•Created by Fatboii on 2/6/2025 in #❓┊help

Web push notifications

Same question here. I'm wondering if there it could be possible to use a Notification class (https://laravel.com/docs/11.x/notifications) and then a toFilament() method that return a Filament Notification (https://filamentphp.com/docs/3.x/notifications/database-notifications#sending-database-notifications). Did you find a way to do this @Fatboii ?

6 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

I'll try it next week and give you a feedback, thanks !

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

It's working but not sure this is optimal. I added this method in my ListMissions page :

protected function getHeaderActions(): array
{
    return [
        Actions\CreateAction::make(),
        ExportAction::make()->exports([
            MissionExport::make()
                ->modifyQueryUsing(fn (HasTable $livewire) => $livewire->getFilteredTableQuery()
                    ->with([
                        'collaborator',
                        'coordinator',
                        'days',
                        'group',
                        'groupLabel',
                        'institution.canton',
                        'latestConfirmation',
                        'proposals',
                        'trainingLevels',
                    ])
                    ->withCount(['proposals', 'workedDays'])
                    ->toBase()
                    ->orderBy('missions.id', 'desc')),
        ]),
        // Actions\Action::make('export-test')
        //     ->action(fn () => dump($this->getFilteredTableQuery()->count())),
        // Actions\ActionGroup::make([
        //     MissionHoursCheckExportAction::action(),
        // ])
        //     ->label('Exports')
        //     ->icon('heroicon-m-arrow-up-on-square')
        //     ->outlined()
        //     ->color('info')
        //     ->button(),
    ];
}

protected function getHeaderActions(): array
{
    return [
        Actions\CreateAction::make(),
        ExportAction::make()->exports([
            MissionExport::make()
                ->modifyQueryUsing(fn (HasTable $livewire) => $livewire->getFilteredTableQuery()
                    ->with([
                        'collaborator',
                        'coordinator',
                        'days',
                        'group',
                        'groupLabel',
                        'institution.canton',
                        'latestConfirmation',
                        'proposals',
                        'trainingLevels',
                    ])
                    ->withCount(['proposals', 'workedDays'])
                    ->toBase()
                    ->orderBy('missions.id', 'desc')),
        ]),
        // Actions\Action::make('export-test')
        //     ->action(fn () => dump($this->getFilteredTableQuery()->count())),
        // Actions\ActionGroup::make([
        //     MissionHoursCheckExportAction::action(),
        // ])
        //     ->label('Exports')
        //     ->icon('heroicon-m-arrow-up-on-square')
        //     ->outlined()
        //     ->color('info')
        //     ->button(),
    ];
}

It works, but I can't move the modifyQueryUsing() inside my MissionExport class because I can't access the livewire component inside the setUp method. Maybe a better solution would be to be able to use a callback on the exports() method of the ExportAction, and override the getQuery() default behavior by passing a custom query, maybe as an optional parameter in the make() method of the ExcelExport class ? What do you think @Dennis Koch ?

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

->headerActions([
    Actions\Action::make('export-test')
        ->action(fn (HasTable $livewire) => dump($table->getFilteredTableQuery()->count())),
])

->headerActions([
    Actions\Action::make('export-test')
        ->action(fn (HasTable $livewire) => dump($table->getFilteredTableQuery()->count())),
])

Okay it works like that, I will try to combine that and your Filament Excel package 🧐

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

The searching/filtering could be enough. I'll try this, thanks !

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

Up ☝️

16 replies

FFilament

•Created by Benjamin on 1/20/2025 in #❓┊help

Performance issue with BulkAction : selectedRecords (only IDs, not Eloquent?)

A possibility to fix it without ruling out Eloquent could be to use chunk() ? Maybe it's already the case, idk.

16 replies

FFilament

•Created by Benjamin on 11/28/2024 in #❓┊help

Table filters : column not found, why ?

For example here, why the $query is a neutral Builder (same as doing User::query()) and not the same query of the table that is used to fill the table, in $table->query() ? Does it mean that, for each filter, it makes another SQL query and then filter the table by IDs comparison ?

Tables\Filters\Filter::make('hasMinimumAvailabilityScore')
    ->label('Au moins 10% de disponibilité')
    ->query(fn (Builder $query): Builder => $query->where('availabilityScore', '10')),

Tables\Filters\Filter::make('hasMinimumAvailabilityScore')
    ->label('Au moins 10% de disponibilité')
    ->query(fn (Builder $query): Builder => $query->where('availabilityScore', '10')),

7 replies

FFilament

•Created by Benjamin on 11/28/2024 in #❓┊help

Table filters : column not found, why ?

And I don't need to load the availabilityScore each time I get a user, I only need it for this table so I don't want those data to be load each time I load the user model.

7 replies

FFilament

•Created by Benjamin on 11/28/2024 in #❓┊help

Table filters : column not found, why ?

No, I make a joinSub() and an addSelect() in the $table->query() method. Accessor could work, I thought about it but was concerned about the performance. With an accessor, it will make one additional query to the availabilities table no ?

7 replies

FFilament

•Created by Benjamin on 11/19/2024 in #❓┊help

Why wire:dirty not working with <x-filament::> components ?

The only turn-around I found is this :

<div class="flex justify-center" wire:dirty.class="hidden">
    <x-filament::button wire:click="validateTimeslots">
        {{ __('Confirm') }}
    </x-filament::button>
</div>

<div class="flex justify-center hidden" wire:dirty.class.remove="hidden">
    <x-filament::button disabled>
        {{ __('Confirm') }}
    </x-filament::button>
</div>

<div class="flex justify-center" wire:dirty.class="hidden">
    <x-filament::button wire:click="validateTimeslots">
        {{ __('Confirm') }}
    </x-filament::button>
</div>

<div class="flex justify-center hidden" wire:dirty.class.remove="hidden">
    <x-filament::button disabled>
        {{ __('Confirm') }}
    </x-filament::button>
</div>

3 replies

FFilament

•Created by Benjamin on 10/22/2024 in #❓┊help

Struggling with SelectFilter with relationship() and distinct status (Enum)

I foud similar issues (https://github.com/filamentphp/filament/issues/12948 + https://github.com/filamentphp/filament/issues/10086), and I finally used a custom filter :

Tables\Filters\Filter::make('abacus_status')
    ->indicateUsing(function (array $data): ?string {
        if (!$status = $data['abacus_status']) {
            return null;
        }

        $status = $status instanceof AbacusStatusEnum ? $status : AbacusStatusEnum::from($status);

        return __('Status') . ' Abacus' . ': ' . $status->getLabel();
    })
    ->form([
        Forms\Components\Select::make('abacus_status')
            ->label(__('Status') . ' Abacus')
            ->options(AbacusStatusEnum::class),
    ])
    ->query(function (Builder $query, array $data): Builder {
        if (!$status = $data['abacus_status']) {
            return $query;
        }

        $status = $status instanceof AbacusStatusEnum ? $status : AbacusStatusEnum::from($status);

        return $query->whereAbacusStatus($status);
    }),

Tables\Filters\Filter::make('abacus_status')
    ->indicateUsing(function (array $data): ?string {
        if (!$status = $data['abacus_status']) {
            return null;
        }

        $status = $status instanceof AbacusStatusEnum ? $status : AbacusStatusEnum::from($status);

        return __('Status') . ' Abacus' . ': ' . $status->getLabel();
    })
    ->form([
        Forms\Components\Select::make('abacus_status')
            ->label(__('Status') . ' Abacus')
            ->options(AbacusStatusEnum::class),
    ])
    ->query(function (Builder $query, array $data): Builder {
        if (!$status = $data['abacus_status']) {
            return $query;
        }

        $status = $status instanceof AbacusStatusEnum ? $status : AbacusStatusEnum::from($status);

        return $query->whereAbacusStatus($status);
    }),

3 replies

FFilament

•Created by Gavrisimo on 9/18/2024 in #❓┊help

console error with fresh custom widget

Same here, thanks for the indirect help :p

4 replies

Gaming

Programming