Display an notification when user is trying to delete a record used has a foreign key

[sardoj]

Hi guys,

When you want to delete a record that is used as a foreign key in another record, a 500 error is displayed.

Would it be possible to display a notification instead?

To do this, you can modify the app/Filament/Actions/DeleteAction.php file as follows:

<?php

namespace Filament\Actions;

use Filament\Actions\Concerns\CanCustomizeProcess;
use Filament\Notifications\Notification;
use Filament\Support\Facades\FilamentIcon;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\QueryException;

class DeleteAction extends Action
{
    use CanCustomizeProcess;

    public static function getDefaultName(): ?string
    {
        return 'delete';
    }

    protected function setUp(): void
    {
        parent::setUp();

        $this->label(__('filament-actions::delete.single.label'));

        $this->modalHeading(fn(): string => __('filament-actions::delete.single.modal.heading', ['label' => $this->getRecordTitle()]));

        $this->modalSubmitActionLabel(__('filament-actions::delete.single.modal.actions.delete.label'));

        $this->successNotificationTitle(__('filament-actions::delete.single.notifications.deleted.title'));

        $this->color('danger');

        $this->groupedIcon(FilamentIcon::resolve('actions::delete-action.grouped') ?? 'heroicon-m-trash');

        $this->requiresConfirmation();

        $this->modalIcon(FilamentIcon::resolve('actions::delete-action.modal') ?? 'heroicon-o-trash');

        $this->keyBindings(['mod+d']);

        $this->hidden(static function (Model $record): bool {
            if (! method_exists($record, 'trashed')) {
                return false;
            }

            return $record->trashed();
        });

        $this->action(function (): void {
            try {
                $result = $this->process(static fn(Model $record) => $record->delete());

                if (! $result) {
                    $this->failure();

                    return;
                }

                $this->success();
            } catch (QueryException $exception) {
                if ($this->isForeignKeyConstraintViolation($exception)) {
                    Notification::make()
                        ->title(__('general.notification.delete.error.title'))
                        ->body(__('general.notification.delete.error.body'))
                        ->danger()
                        ->send();
                } else {
                    throw $exception;
                }
            }
        });
    }

    protected function isForeignKeyConstraintViolation(QueryException $exception): bool
    {
        return $exception->getCode() === '23000'; // Standard SQL code for integrity constraint violations
    }
}