morty Posts - Answer Overflow

Topics

morty

•Created by morty on 5/21/2025 in #❓┊help

How to query/chart on a fiscal year? Calendar/data dimension table?

This might not be exactly Filament related but I'm working with a Filament app so I'll ask here. I need to chart some trends based on a fiscal year of Jul 1 - June 30. I'm wondering what the best way to go about this would be? Should I build a calendar/data dimension table in the database or would you just use Carbon to limit your queries dynamically?

4 replies

•Created by morty on 5/16/2025 in #❓┊help

Do I have to authorize manually in the `->action()` method as well?

I have the following code to change the status on a record:

Tables\Actions\Action::make('changeStatus')
    ->authorize(fn (WorkOrder $record): bool => static::canEdit($record))
    ->form([
        Forms\Components\Select::make('status')
            ->options(fn (string $operation) => WorkOrderStatus::options($operation))
            ->enum(WorkOrderStatus::class)
            ->required(),
    ])
    ->action(function (array $data, WorkOrder $record): void {
        // do I need to authorize here as well?
        
        $record->status = $data['status'];
        $record->save();
    })
    ->after(fn () => Notification::make()->success()->title('Saved')->send())

Tables\Actions\Action::make('changeStatus')
    ->authorize(fn (WorkOrder $record): bool => static::canEdit($record))
    ->form([
        Forms\Components\Select::make('status')
            ->options(fn (string $operation) => WorkOrderStatus::options($operation))
            ->enum(WorkOrderStatus::class)
            ->required(),
    ])
    ->action(function (array $data, WorkOrder $record): void {
        // do I need to authorize here as well?
        
        $record->status = $data['status'];
        $record->save();
    })
    ->after(fn () => Notification::make()->success()->title('Saved')->send())

Do I have to authorize inside the action method on top of the ->authorize() method on the action itself?

6 replies

•Created by morty on 5/15/2025 in #❓┊help

Table action buttons are showing when not authorized but only when a modal is shown.

No description

3 replies

•Created by morty on 4/23/2025 in #❓┊help

Global search query is pulling in trashed models

My global search queries don't seem to be applying the soft delete scope. Is this intentional? For example, here is one of the queries. The Part model has the soft delete trait.

select top 50 * from [maintenance].[parts] where ([maintenance].[parts].[name] like '%#40%' or [maintenance].[parts].[number] like '%#40%')

select top 50 * from [maintenance].[parts] where ([maintenance].[parts].[name] like '%#40%' or [maintenance].[parts].[number] like '%#40%')

14 replies

•Created by morty on 4/16/2025 in #❓┊help

How can I fill a field on the edit form that isn't saved to the database?

On a create form, I have a 3-tiered dependent dropdown. For example: On a Person model I might have the following Country -> State/Province -> City In the database on the persons table I'm only saving the city_id since I can always look up the state and country via the city. I have this working on the create form but when someone clicks to edit the form, how can I fill in the country_id and state_province_id since these don't exist from the data? My code:

Forms\Components\Select::make('country_id')
    ->label('Country')
    ->live()
    ->relationship('country', 'name')
    ->searchable()
    ->preload()
    ->afterStateUpdated(function (Forms\Set $set): void {
        $set('state_province_id', null);
        $set('city_id', null);
    })
    ->dehydrated(false),

Forms\Components\Select::make('state_province_id')
    ->label('State/Province')
    ->live()
    ->disabled(fn (Forms\Get $get): bool => ! filled($get('country_id')))
    ->relationship('stateProvince', 'name')
    ->searchable()
    ->preload()
    ->afterStateUpdated(function (Forms\Set $set): void {
        $set('city_id', null);
    })
    ->dehydrated(false),

Forms\Components\Select::make('city_id')
    ->label('City')
    ->relationship('city', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->exists(City::class, 'id'),

Forms\Components\Select::make('country_id')
    ->label('Country')
    ->live()
    ->relationship('country', 'name')
    ->searchable()
    ->preload()
    ->afterStateUpdated(function (Forms\Set $set): void {
        $set('state_province_id', null);
        $set('city_id', null);
    })
    ->dehydrated(false),

Forms\Components\Select::make('state_province_id')
    ->label('State/Province')
    ->live()
    ->disabled(fn (Forms\Get $get): bool => ! filled($get('country_id')))
    ->relationship('stateProvince', 'name')
    ->searchable()
    ->preload()
    ->afterStateUpdated(function (Forms\Set $set): void {
        $set('city_id', null);
    })
    ->dehydrated(false),

Forms\Components\Select::make('city_id')
    ->label('City')
    ->relationship('city', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->exists(City::class, 'id'),

9 replies

•Created by morty on 4/15/2025 in #❓┊help

Should I be using `Filament::user()` instead of `Auth::user()`?

I see the documentation uses the former sometimes and I'm not sure if I should be using that instead of Auth::user().

4 replies

•Created by morty on 4/11/2025 in #❓┊help

How come we need to disable the SoftDeletingScope::class on the resource but not on relation manager

I'm starting to implement soft deletes across my models and while the documentation says we need to add ->withoutGlobalScope(SoftDeletingScope::class) to the resource, why then do I not need to add this to the relation manager class via the ->modifyQueryUsing() method?

10 replies

•Created by morty on 3/12/2025 in #❓┊help

Is it possible to pass the parent record to the gate of a relation manager?

I have a Work Orders resource and on the edit page of each is a relation manager for Work Order Notes. I have policies for both models. I only want to allow a work order note to be created on work orders that the logged in user owns. The problem is that Filament checks a create method on the WorkOrderNotePolicy that doesn't pass in anything other than the user. Eg.

class WorkOrderNotePolicy
{
    public function create(User $user): bool
    {
        //
    }
}

class WorkOrderNotePolicy
{
    public function create(User $user): bool
    {
        //
    }
}

Is there a way that I can pass in the parent/owner record to this method on the policy?

6 replies

•Created by morty on 3/5/2025 in #❓┊help

Has anyone successfully parsed the rich editor/trix field from the raw data in the database?

I have an application that has used the trix editor for a while. I need to migrate this data to a new application that also uses the trix editor for the same field but the difference in this new application is that it doesn't allow file uploads in the field like the old application did. Wondering what the best way would be to rip those files out of the body of that field and upload them properly for the record. Anyone have any experience here?

7 replies

•Created by morty on 3/3/2025 in #❓┊help

How can I aggregate a field on a pivot table with TextColumn->sum()?

My code:

TextColumn::make('locations_sum_available_quantity')
    ->label('Inventory')
    ->sum('locations', 'inventories.available_quantity')
    ->badge()
    ->alignCenter()
    ->sortable(),

TextColumn::make('locations_sum_available_quantity')
    ->label('Inventory')
    ->sum('locations', 'inventories.available_quantity')
    ->badge()
    ->alignCenter()
    ->sortable(),

I can't seem to get this to work. Is it possible to aggregate a field on the pivot table?

3 replies

•Created by morty on 2/27/2025 in #❓┊help

Is there a way in Filament to calculate a field on the client side without Livewire? AlpineJS?

No description

12 replies

•Created by morty on 2/27/2025 in #❓┊help

When would you ever not want `isImportant` on the `configureUsing` method?

Related: https://discord.com/channels/883083792112300104/1344421288919302215 I had to fix some configuration that I was doing in a service provider and needed to set the isImportant flag to true. Can anyone tell me why I wouldn't want to always set this to true? I'm not understanding why this is even a thing? Thanks.

1 replies

•Created by morty on 2/26/2025 in #❓┊help

Can't seem to globally change the AttachAction modal width?

I have a service provider where I'm configuring defaults for many components. One component I'm trying to configure is the Filament\Tables\Actions\AttachAction modalWidth. I'm doing the following:

        Tables\Actions\AttachAction::configureUsing(function (Tables\Actions\AttachAction $component): void {
            $component->modalWidth(MaxWidth::Medium);
        });

        Tables\Actions\AttachAction::configureUsing(function (Tables\Actions\AttachAction $component): void {
            $component->modalWidth(MaxWidth::Medium);
        });

This does not seem to be working though. Any ideas why? It seems both the AttachAction and the AssociateAction are setting the modal width in their setUp method and I thought I could override this in the configureUsing should I not be able to?

3 replies

•Created by morty on 2/12/2025 in #❓┊help

Confused about form grid columns and column span.

No description

3 replies

•Created by morty on 2/12/2025 in #❓┊help

How can I position these stat widgets on the dashboard?

No description

5 replies

•Created by morty on 2/11/2025 in #❓┊help

Spatie Media Library Plugin black screen on upload of some files

No description

8 replies

•Created by morty on 2/5/2025 in #❓┊help

Is there a way to allow Split (table layout) to work on all breakpoints?

For example, even if I do ->from('2xl') then it still only works on all BUT 2xl. I want it to work on all and never switch to the traditional layout.

4 replies

•Created by morty on 1/22/2025 in #❓┊help

Is it possible to remove images/files from storage when removed in the rich editor field?

n/t

1 replies

•Created by morty on 1/21/2025 in #❓┊help

Is there a way to evaluate this immediately without returning a closure?

I want to return an array here but I also need to check the operation of the form if it's in create or edit. I don't want to return a closure because it's slower due to querying the database when the user focuses the field. I'd rather load these on page load which returning an array would do.

Forms\Components\Select::make('priority')->options(fn (string $operation) => WorkOrderStatus::options($operation))

Forms\Components\Select::make('priority')->options(fn (string $operation) => WorkOrderStatus::options($operation))

4 replies

•Created by morty on 1/9/2025 in #❓┊help

Dependent select without parent being saved to the database

No description

6 replies