摘要:<?php namespace app\index\controller; use think\Controller; use app\index\model\Staff as StaffModel;//设置模型类的别名 class Staff2 extends Controller { //软删除:
<?php
namespace app\index\controller;
use think\Controller;
use app\index\model\Staff as StaffModel;//设置模型类的别名
class Staff2 extends Controller
{
//软删除:必须在模型中进行配置
//调用URL举例:http://tp51.io/index.php/index/staff2/softDelete/staff_id/5
public function softDelete()
{
//$this-request: //请求对象
$staff_id = $this->request->param('staff_id') ? : 0;
//将记录$staff_id进行软删除
StaffModel::destroy($staff_id);
}
//恢复指定的已软删除的记录
//调用URL举例:http://tp51.io/index.php/index/staff2/restore/staff_id/5
public function restore()
{
//$this-request: //请求对象
$staff_id = $this->request->param('staff_id') ? : 0;
//将已软删除的记录$staff_id恢复成正常状态
StaffModel::withTrashed()->where('delete_time','>',0)
->where('staff_id',$staff_id)
->data(['delete_time'=>0])
->update();
}
}
?>
批改老师:天蓬老师批改时间:2018-12-16 14:08:49
老师总结:软删除是有一定前提的, 一定要按规则来命名表中的时间字段, 本质上是用更新+查询 来替代删除