Laravel中关联Service时如何限制GroupService的删除操作？

我有一个GroupService模型，与Service模型为一对多关联（一个GroupService对应多个Service）。需求是：当GroupService存在关联的Service记录时，阻止删除操作；无关联记录时允许用户删除。尝试过相关方案但未解决问题。

现有代码 #

GroupService 模型 #

class GroupService extends Model
{
    use HasFactory;
    
    protected $table = 't_grup_layanan';
    protected $guarded = ['id'];
    protected $with = ['business'];

    public function service(){
        return $this->hasMany(Service::class);
    }

    public function business(){
        return $this->belongsTo(Business::class, 'bisnis_id');
    }
    
    // protected static function boot(){
    //     parent::boot();

    //     static::deleting(function($groupservice) {
    //         $relationMethods = ['service'];

    //         foreach ($relationMethods as $relationMethod) {
    //             if ($groupservice->$relationMethod()->count() > 0) {
    //                 return false;
    //             }
    //         }
    //     });
    // }
}

Service 模型 #

class Service extends Model
{
    use HasFactory;

    protected $table = 't_layanan';
    protected $guarded = ['id'];
    protected $with = ['groupservice'];

    public function groupservice(){
        return $this->belongsTo(GroupService::class, 'gruplayanan_id');
    }
}

GroupService 控制器 destroy 方法 #

public function destroy(GroupService $groupservice, $id)
{
    $groupService = GroupService::find(Crypt::decrypt($id));

    if ($groupService->service()->exists())
    {
        abort('Resource cannot be deleted due to existence of related resources.');
    }

    $groupService->delete();

    return redirect('/dashboard/gruplayanan/')->with('danger', 'Data dihapus !');
}

GroupService 迁移文件 #

public function up()
{
    Schema::create('t_grup_layanan', function (Blueprint $table) {
        $table->id();
        $table->foreignId('bisnis_id')->nullable()->index('fk_bisnis_to_group');
        $table->text('deskripsi');
        $table->timestamps();
    });
}

Service 迁移文件 #

public function up()
{
    Schema::create('t_layanan', function (Blueprint $table) {
        $table->id();
        $table->foreignId('gruplayanan_id')->index('fk_grup_to_layanan');
        $table->text('nama');
        $table->text('deskripsi');
        $table->timestamps();
    });
}

public function up()
{
    Schema::table('t_layanan', function (Blueprint $table) {
        $table->foreign('gruplayanan_id', 'fk_grup_to_layanan')->references('id')->on('t_grup_layanan')->onUpdate('CASCADE')->onDelete('CASCADE');
    });
}

问题分析与修复方案 #

1. 迁移文件错误修复 #

Service迁移文件存在两个重复的up()方法，会导致语法错误；同时外键设置onDelete('CASCADE')会让删除GroupService时自动删除关联的Service，完全违背需求。需要合并迁移逻辑并修改外键删除行为：

修改后的Service迁移文件：

public function up()
{
    Schema::create('t_layanan', function (Blueprint $table) {
        $table->id();
        $table->foreignId('gruplayanan_id')->index('fk_grup_to_layanan');
        $table->text('nama');
        $table->text('deskripsi');
        $table->timestamps();

        // 创建表时直接定义外键，删除行为改为RESTRICT
        $table->foreign('gruplayanan_id', 'fk_grup_to_layanan')
              ->references('id')->on('t_grup_layanan')
              ->onUpdate('CASCADE')
              ->onDelete('RESTRICT'); // 阻止删除存在关联子记录的父记录
    });
}

如果已执行过原有迁移，需创建新迁移修改外键：

public function up()
{
    Schema::table('t_layanan', function (Blueprint $table) {
        // 删除原有外键
        $table->dropForeign('fk_grup_to_layanan');
        
        // 重新添加外键并设置RESTRICT删除行为
        $table->foreign('gruplayanan_id', 'fk_grup_to_layanan')
              ->references('id')->on('t_grup_layanan')
              ->onUpdate('CASCADE')
              ->onDelete('RESTRICT');
    });
}

public function down()
{
    Schema::table('t_layanan', function (Blueprint $table) {
        $table->dropForeign('fk_grup_to_layanan');
        
        // 恢复原外键设置（可选）
        $table->foreign('gruplayanan_id', 'fk_grup_to_layanan')
              ->references('id')->on('t_grup_layanan')
              ->onUpdate('CASCADE')
              ->onDelete('CASCADE');
    });
}

2. 控制器方法优化 #

原控制器destroy方法存在参数冗余，且abort未指定正确HTTP状态码。优化后：

public function destroy($id)
{
    $groupService = GroupService::findOrFail(Crypt::decrypt($id));

    // 检查是否存在关联的Service
    if ($groupService->service()->exists()) {
        abort(409, '无法删除该分组，因为存在关联的服务记录。');
    }

    $groupService->delete();

    return redirect('/dashboard/gruplayanan/')->with('danger', '数据已删除！');
}

若使用路由模型绑定，可进一步简化：

// 路由示例：Route::delete('/dashboard/gruplayanan/{groupservice}', [GroupServiceController::class, 'destroy']);
public function destroy(GroupService $groupservice)
{
    // 加密ID解析逻辑可移至路由模型绑定解析器
    if ($groupservice->service()->exists()) {
        abort(409, '无法删除该分组，因为存在关联的服务记录。');
    }

    $groupservice->delete();

    return redirect('/dashboard/gruplayanan/')->with('danger', '数据已删除！');
}

3. 模型事件全局限制（更优雅） #

启用模型中注释的boot方法，通过deleting事件全局拦截删除操作，无论通过何种方式删除都会触发检查：

class GroupService extends Model
{
    use HasFactory;
    
    protected $table = 't_grup_layanan';
    protected $guarded = ['id'];
    protected $with = ['business'];

    public function service(){
        return $this->hasMany(Service::class);
    }

    public function business(){
        return $this->belongsTo(Business::class, 'bisnis_id');
    }
    
    protected static function boot(){
        parent::boot();

        static::deleting(function($groupservice) {
            if ($groupservice->service()->exists()) {
                throw new \Exception('无法删除该分组，因为存在关联的服务记录。');
                // Laravel8及以前可直接返回false阻止删除，推荐用异常
                // return false;
            }
        });
    }
}

此时控制器可简化为：

public function destroy($id)
{
    try {
        $groupService = GroupService::findOrFail(Crypt::decrypt($id));
        $groupService->delete();
        return redirect('/dashboard/gruplayanan/')->with('danger', '数据已删除！');
    } catch (\Exception $e) {
        return redirect()->back()->with('error', $e->getMessage());
    }
}

注意事项 #

• 确保数据库引擎为InnoDB（MyISAM不支持外键约束）
• 使用模型事件时需捕获异常，返回友好提示给用户
• 加密ID的解析逻辑可移至路由模型绑定，让控制器更简洁

内容的提问来源于stack exchange，提问作者ProgrammerWannabe