F
Filament•3mo ago
Trauma Zombie

How to refresh select options after hitting Create another?

Hi guys, I have two relation managers on one resource, one has form with select that uses relationship with modified query. The other one has also select but has options method because I wanted to group options inside select. Problem is, when user create new relation and hit Create and create another, that use case with relationship will refresh query in select, but in options it is not refreshed. Can you help me? I can give you code. I just need to exclude option already selected.
1 Reply
Trauma Zombie
Trauma ZombieOP•3mo ago
Forms\Components\Select::make('material_id')
    ->label('Material')
    ->options(
        Material::query()
            ->with('category')
            ->whereDoesntHave('orderMaterials', function (Builder $query): void {
                $query->where('order_id', $this->getOwnerRecord()->getKey());
            })
            ->orderBy('position')
            ->get()
            ->groupBy(fn (Material $material): string => $material->category->title)
            ->sortBy(fn ($group, $key): int => $group->first()->category->position ?? PHP_INT_MAX)
            ->mapWithKeys(function ($items, $categoryTitle): array {
                return [$categoryTitle => $items->pluck('title', 'id')->toArray()];
            })
            ->toArray(),
    )
    ->searchable()
    ->required()
    ->exists('materials', 'id'),
Forms\Components\Select::make('material_id')
    ->label('Material')
    ->options(
        Material::query()
            ->with('category')
            ->whereDoesntHave('orderMaterials', function (Builder $query): void {
                $query->where('order_id', $this->getOwnerRecord()->getKey());
            })
            ->orderBy('position')
            ->get()
            ->groupBy(fn (Material $material): string => $material->category->title)
            ->sortBy(fn ($group, $key): int => $group->first()->category->position ?? PHP_INT_MAX)
            ->mapWithKeys(function ($items, $categoryTitle): array {
                return [$categoryTitle => $items->pluck('title', 'id')->toArray()];
            })
            ->toArray(),
    )
    ->searchable()
    ->required()
    ->exists('materials', 'id'),
Forms\Components\Select::make('work_id')
    ->label('Work')
    ->relationship(
        'work',
        'title',
        function (Builder $query): void {
            $query->whereDoesntHave('orderWorks', function (Builder $query): void {
                $query->where('order_id', $this->getOwnerRecord()->getKey());
            });
        },
    )
    ->preload()
    ->searchable()
    ->required()
    ->exists('works', 'id'),
Forms\Components\Select::make('work_id')
    ->label('Work')
    ->relationship(
        'work',
        'title',
        function (Builder $query): void {
            $query->whereDoesntHave('orderWorks', function (Builder $query): void {
                $query->where('order_id', $this->getOwnerRecord()->getKey());
            });
        },
    )
    ->preload()
    ->searchable()
    ->required()
    ->exists('works', 'id'),
This one works just fine. After hitting create another query is run again, so selected option is excluded.

Did you find this page helpful?