Detach Action Removing every record in belongsToMany Pivot record

[webbitske]

Package

Actions

Package Version

v3.2

How can we help you?

When I detach record, all pivots records with same vehicle_make_id gets removed.
What I expect is to remove the specific pivot record. Is it a problem with how I have defined the relationship or do I need to modify the DetachAction. If so how?

Fitments Table

        Schema::create('fitments', function (Blueprint $table) {
            $table->id();
            $table->foreignId('part_id')->nullable()->constrained()->cascadeOnDelete();
            $table->foreignId('vehicle_make_id')->nullable()->constrained()->cascadeOnDelete();
            $table->foreignId('vehicle_model_id')->nullable()->constrained()->cascadeOnDelete();
            $table->foreignId('vehicle_trim_id')->nullable()->constrained()->cascadeOnDelete();
            $table->foreignId('vehicle_year_id')->nullable()->constrained()->cascadeOnDelete();
        });

App\Models\Part

class Part extends Model
  { 
       public function fitments(): BelongsToMany
       {
            return $this->belongsToMany(VehicleMake::class, 'fitments', 'part_id', 'vehicle_make_id')
                    ->withPivot([
                        'vehicle_model_id', 
                        'vehicle_trim_id', 
                        'vehicle_year_id'
                     ]);
       }
  }

App\Filament\Admin\Resources\PartResource\RelationManagers;

class FitmentsRelationManager extends RelationManager
{
    protected static string $relationship = 'fitments';

    public function form(Form $form): Form
    {
        return $form
            ->schema([]);
    }

    public function table(Table $table): Table
    {
        return $table
            ->heading('Vehicle Fitment')
            ->emptyStateHeading('No Compatible Vehicles Set')
            ->emptyStateDescription('Click Add Vehicle button to set fitment for this part')
            ->recordTitleAttribute('id')
            ->columns([
                Tables\Columns\TextColumn::make('name')->label('Make'),
                Tables\Columns\TextColumn::make('vehicle_model_id')->label('Model'),
                Tables\Columns\TextColumn::make('vehicle_trim_id')->label('Trim'),
                Tables\Columns\TextColumn::make('vehicle_year_id')->label('Y.O.M'),
            ])
            ->filters([
                //
            ])
            ->headerActions([
                Tables\Actions\AttachAction::make()
                    ->recordSelectSearchColumns(['name', 'id'])
                    ->label('Add Vehicle')
                    ->recordSelect(fn () => Forms\Components\Select::make('recordId')
                        ->label('Make')
                        ->placeholder('Select Make')
                        ->options(VehicleMake::pluck('name', 'id'))
                        ->live()
                        ->required()
                    )
                    ->disableAttachAnother()
                    ->preloadRecordSelect()
                    ->form(fn (AttachAction $action): array => [
                        $action->getRecordSelect(),
                        Forms\Components\Select::make('vehicle_model_id')
                            ->label('Model')
                            ->placeholder('Select Model')
                            ->options(fn (Get $get): Collection => VehicleModel::query()
                                ->where('vehicle_make_id', $get('recordId'))
                                ->pluck('name', 'id'))
                            ->required()
                            ->visible(function ($get) {
                                return !is_null($get('recordId'));
                            })
                            ->live(),
                        Forms\Components\Select::make('vehicle_trim_id')
                            ->label('Trim')
                            ->placeholder('Select Trim')
                            ->options(fn (Get $get): Collection => VehicleTrim::query()
                                ->where('vehicle_model_id', $get('vehicle_model_id'))
                                ->pluck('name', 'id'))
                            ->required()
                            ->visible(function ($get) {
                                return !is_null($get('vehicle_model_id'));
                            })
                            ->live(),
                        Forms\Components\Select::make('vehicle_year_id')
                            ->label('Y.O.M')
                            ->placeholder('Select Year')
                            ->options(function ($get) {
                                $vehicleTrimId = $get('vehicle_trim_id');
                                if ($vehicleTrimId) {
                                    return VehicleTrim::find($vehicleTrimId)
                                                      ->years()
                                                      ->pluck('vehicle_years.yom', 'vehicle_years.id');
                                }
                                return [];
                            })
                            ->required()
                            ->visible(function ($get) {
                                return !is_null($get('vehicle_trim_id'));
                            }),

                    ]),
            ])
            ->actions([
                Tables\Actions\DetachAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DetachBulkAction::make(),
                ]),
            ]);
    }
}

[wightspace]

@webbitske you ever find out what the issue was for this?

[webbitske]

Hi John, I never found a solution to this issue. I had to take a different approach.

…

On Fri, 10 Jan 2025, 4:01 am John Wight, ***@***.***> wrote: @webbitske <https://github.com/webbitske> you ever find out what the issue was for this? — Reply to this email directly, view it on GitHub <#11052 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAIRIDP4TI6PXWIBMEJI2NT2J4LXJAVCNFSM6AAAAABU5KMTSWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNZZGI3DQNQ> . You are receiving this because you were mentioned.Message ID: ***@***.***>