Laravel设置软删除及其恢复系列操作

软删除及其相关实现

• 在模型类中要使用SoftDeletestrait并设置$date属性数组

          <?php
          namespace App\Models;
          use Illuminate\Database\Eloquent\Model;
          use Illuminate\Database\Eloquent\SoftDeletes;
          class Student extends Model
          {
             use SoftDeletes;
             //设置表名
             public $table = 'students';
             //设置主键
             public $primaryKey = 'id';
             protected $dates = ['delete_at'];
          }
      
     

      
     
     

• 数据迁移中软删除字段写法

          <?php
          use Illuminate\Database\Schema\Blueprint;
          use Illuminate\Database\Migrations\Migration;
          class AlterStudentsDeletedAt extends Migration
          {
             /**
           * Run the migrations.
           *
           * @return void
           */
             public function up()
              {
                  Schema::table('students', function (Blueprint $table) {
                     $table->timestamps();
                     $table->softDeletes();
                  });
              }
          }
      
     

      
     
     

• 控制器中使用

          public function destroy(Student $student)
          {
             $student->delete();
             if (!$student->trashed()) {
                 return redirect()->back()->with('danger', '学生信息删除失败，学生ID：'.$student->id);
              }
             return redirect()->route('students.index')->with('success', '学生信息删除成功，学生ID：'.$student->id);
          }
      
     

• 查询结果包含软删除模型

          $students = Student::withTrashed()->get();
          dd($students->toArray());
      
     

• 只要查看被软删除的模型

          $students = Student::onlyTrashed()->get();
          dd($students->toArray());
      
     

• 软删除恢复

          $student = Student::find(6);
          $student->restore();
      
     

• 恢复多个模型

Student::withTrashed()->where('id','>',1)->restore();

• 恢复所有模型

Student::withTrashed()->restore();

     

• 恢复关联查询模型

          $student = Student::find(6);
          $student->history()->restore();
      
     

• 强制删除（丛数据库中删除）

          $student = Student::find(6);
          $student->forceDelete();
      
     

链接：https://www.jianshu.com/p/a48fb2b6adfa