在 Laravel 中软删除父记录时如何软删除相关记录

发布于08月23日

我有一张发票表，它的 struct 如下

id | name | amount | deleted_at
2    iMac   1500   | NULL

and a payments table with the following structure

id | invoice_id | amount | deleted_at
2    2            1000   | NULL

Invoice Model

class Invoice extends Model {

    use SoftDeletes;

}

以下是删除发票的代码

public function cance(Request $request,$id)
{
    $record = Invoice::findOrFail($id);
    $record->delete();
    return response()->json([
        'success' => 'OK',
    ]);
}

Payments model

class Payment extends Model {

    use SoftDeletes;

}

发票表上的softDelete工作正常，但其相关记录(付款)仍然存在.如何使用softDelete删除它们？

推荐答案

Eloquent不提供自动删除相关对象的功能，因此您需要自己编写一些代码.幸运的是，这很简单.

Eloquent models fire different events in different stages of model's life-cycle like creating, created, deleting, deleted etc. - you can read more about it here: http://laravel.com/docs/5.1/eloquent#events. What you need is a listener that will run when deleted event is fired - this listener should then delete all related objects.

您可以在模型的boot()方法中注册模型侦听器.侦听器应该遍历要删除的发票的所有付款，并且应该逐个删除它们.批量删除在这里不起作用，因为它将绕过模型事件直接执行SQL查询.

This will do the trick:

class MyModel extends Model {
  protected static function boot() {
    parent::boot();

    static::deleted(function ($invoice) {
      $invoice->payments()->delete();
    });
  }
}