<?php
|
|
namespace app\shop\model\plus\regactivity;
|
|
use app\common\model\plus\regactivity\User as UserModel;
|
|
/**
|
* 用户模型
|
* Class User
|
* @package app\shop\model\plus\team
|
*/
|
class User extends UserModel
|
{
|
/**
|
* 获取报名用户列表
|
*/
|
public function getList($search, $limit = 20, $activity_id = "")
|
{
|
// 构建查询规则
|
$model = $this->alias('reg')
|
->field('reg.*, user.nickName, user.avatarUrl')
|
->join('user', 'user.user_id = reg.user_id')
|
->where('reg.is_delete', '=', 0)
|
->order(['reg.create_time' => 'desc']);
|
// 查询条件
|
if (!empty($search)) {
|
$model = $model->where('user.nickName|reg.user_name|reg.mobile', 'like', '%' . $search . '%');
|
}
|
if (!empty($activity_id)) {
|
$model = $model->where('reg.activity_id', '=', $activity_id);
|
}
|
// 获取列表数据
|
$list = $model->paginate($limit);
|
return $list;
|
}
|
|
/**
|
* 删除报名用户
|
* @return mixed
|
*/
|
public function setDelete()
|
{
|
return $this->transaction(function () {
|
// 标记用户记录为已删除
|
return $this->save([
|
'is_delete' => 1
|
]);
|
});
|
}
|
|
|
}
|
