alias('auser') ->field('auser.*, user.nickName, user.avatarUrl') ->join('user', 'user.user_id = auser.user_id') ->where('auser.is_delete', '=', 0) ->order(['auser.create_time' => 'desc']); // 查询条件 if (!empty($params['keyword'])) { $model = $model->where('user.nickName|auser.real_name|auser.mobile', 'like', '%' . $params['keyword'] . '%'); } if (!empty($params['activity_id'])) { $model = $model->where('auser.activity_id', '=', $params['activity_id']); } // 签到状态 if (isset($params['is_verify']) && $params['is_verify'] > -1) { $model = $model->where('auser.is_verify', '=', $params['is_verify']); } // 如果不分页 if (!$is_page) { return $model->select(); } // 获取列表数据 return $model->paginate($params); } /** * 删除报名用户 * @return mixed */ public function setDelete() { return $this->transaction(function () { // 标记用户记录为已删除 return $this->save([ 'is_delete' => 1 ]); }); } }