['neq',$this->auth->id], 'user.status' => 1, 'user.gender' => ['neq',$this->auth->gender], ]; if(!empty($keyworld)){ $where['user.username|nickname'] = ['LILE','%'.$keyworld.'%']; } //排除黑名单的 $where_black = []; $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid'); if(!empty($black_ids)){ $where_black['user.id'] = ['NOTIN',$black_ids]; } $field = [ 'user.id', 'user.username', 'user.nickname', 'user.avatar', 'user.idcard_status', 'user.real_status', 'user.photo_images', 'user.gender', 'user.birthday', 'user.is_active', 'user.bio', 'wallet.vip_endtime', 'active.requesttime', ]; $list = Db::name('user')->alias('user')->field($field) ->join('user_wallet wallet','user.id = wallet.user_id','LEFT') ->join('user_active active' ,'user.id = active.user_id','LEFT') ->where($where) ->where($where_black) ->order('user.is_active desc,user.id desc') ->autopage() ->select(); $list = list_domain_image($list,['avatar','photo_images']); foreach($list as $key => &$val){ $val['age'] = birthtime_to_age($val['birthday']); $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0; $val['active_info'] = $this->user_activeinfo($val['id'],$val['requesttime']); } $this->success(1,$list); } //新人 public function xinren(){ $keyworld = input('keyworld',''); $where = [ 'user.id' => ['neq',$this->auth->id], 'user.status' => 1, 'user.gender' => ['neq',$this->auth->gender], ]; if(!empty($keyworld)){ $where['user.username|nickname'] = ['LILE','%'.$keyworld.'%']; } //排除黑名单的 $where_black = []; $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid'); if(!empty($black_ids)){ $where_black['user.id'] = ['NOTIN',$black_ids]; } $field = [ 'user.id', 'user.username', 'user.nickname', 'user.avatar', 'user.idcard_status', 'user.real_status', 'user.photo_images', 'user.gender', 'user.birthday', 'user.is_active', 'user.bio', 'wallet.vip_endtime', 'active.requesttime', ]; $list = Db::name('user')->alias('user')->field($field) ->join('user_wallet wallet','user.id = wallet.user_id','LEFT') ->join('user_active active' ,'user.id = active.user_id','LEFT') ->where($where) ->where($where_black) ->order('user.is_active desc,user.id desc') ->autopage() ->select(); $list = list_domain_image($list,['avatar','photo_images']); foreach($list as $key => &$val){ $val['age'] = birthtime_to_age($val['birthday']); $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0; $val['active_info'] = $this->user_activeinfo($val['id'],$val['requesttime']); } $this->success(1,$list); } //首页搜索 public function search_user(){ $keyword = input('keyword',''); if(empty($keyword)){ $this->error(); } $where = []; if(is_numeric($keyword)){ $where['username'] = intval($keyword); }else{ $where['nickname'] = ['LIKE','%'.trim($keyword).'%']; } $list = Db::name('user')->field('id,username,nickname,gender,avatar')->where($where)->limit(100)->select(); $list = list_domain_image($list,['avatar']); $this->success(1,$list); } }