transaction(function () { // 标记用户记录为已删除 return $this->save([ 'is_delete' => 1 ]); }); } /** * 获取报名用户列表 */ public function getList($params = [], $is_page = true, $limit = false) { // 构建查询规则 $model = $this->alias('auser') ->field('auser.*, user.nickName, user.avatarUrl') ->join('user', 'user.user_id = auser.user_id') ->with(['activity'=>['branch'],'branch']) ->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 (!empty($params['pay_status'])) { if ($params['pay_status']>0){ $model = $model->where('auser.pay_status', '=', $params['pay_status']); } } if (isset($params['status'])) { if ($params['status']>-1) { $model = $model->where('auser.status', '=', $params['status']); } } // 如果不分页 if (!$is_page) { if ($limit) { $model = $model->limit($limit); } return $model->select(); } // 获取列表数据 return $model->paginate($params); } }