alias('du')->with('grade') ->field('du.*, user.nickName, user.avatarUrl') ->join('user', 'user.user_id = du.user_id') ->where('du.is_delete', '=', 0) ->order(['du.create_time' => 'desc']); // 查询条件 if (!empty($data['nick_name'])) { $model = $model->where('user.nickName|du.real_name|du.mobile', 'like', '%' . $data['nick_name'] . '%'); } // 获取列表数据 $list = $model->paginate($data); return $list; } /** * 编辑用户 * @param $data * @return bool */ public function edit($data) { // 开启事务 $this->startTrans(); try { $this->save($data); $this->commit(); return true; } catch (\Exception $e) { $this->error = $e->getMessage(); $this->rollback(); return false; } } /** * 删除 * @return mixed */ public function setDelete() { // 标记当前记录为已删除 return $this->save([ 'is_delete' => 1 ]); } }