| | |
| | | ], ['order_no' => '注册成功发放会员卡赠送']); |
| | | }*/ |
| | | } |
| | | |
| | | /** |
| | | * 获取用户列表 |
| | | */ |
| | | public static function getList($params, $is_page = true) |
| | | { |
| | | $model = new static(); |
| | | //检索:用户名 |
| | | if (!empty($params['keyword'])) { |
| | | $model = $model->where('user.nickName|user.real_name|user.mobile|user.user_id', 'like', '%' . $params['keyword'] . '%'); |
| | | } |
| | | if (isset($params['reg_source']) && $params['reg_source']) { |
| | | $model = $model->where('user.reg_source', '=', $params['reg_source']); |
| | | } |
| | | if($is_page){ |
| | | // 获取用户列表 |
| | | return $model->alias('user')->with(['grade'])->distinct(true)->field(['user.*','referee.nickName as referee_name,referee.avatarUrl as referee_avatarUrl']) |
| | | ->where('user.is_delete', '=', '0') |
| | | ->join('user_tag tag', 'user.user_id = tag.user_id','left') |
| | | ->join('user referee', 'user.referee_id = referee.user_id','left') |
| | | ->order(['user.create_time' => 'desc']) |
| | | ->hidden(['open_id', 'union_id']) |
| | | ->paginate($params); |
| | | }else{ |
| | | // 获取用户列表 |
| | | return $model->alias('user')->with(['grade']) |
| | | ->where('user.is_delete', '=', '0') |
| | | ->join('user referee', 'user.referee_id = referee.user_id','left') |
| | | ->order(['user.create_time' => 'desc']) |
| | | ->field(['user.user_id,user.nickName,user.real_name,user.grade_id,user.reg_source,user.points,user.balance,user.referee_id,user.mobile,user.create_time','referee.nickName as referee_name']) |
| | | ->select(); |
| | | } |
| | | |
| | | } |
| | | } |