Index.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. use think\Cache;
  6. /**
  7. * 首页接口
  8. */
  9. class Index extends Api
  10. {
  11. protected $noNeedLogin = ['index'];
  12. protected $noNeedRight = ['*'];
  13. public function index(){
  14. echo 'apisuccess';
  15. exit;
  16. }
  17. //精选
  18. public function jingxuan(){
  19. $keyworld = input('keyworld','');
  20. $where = [
  21. 'user.id' => ['neq',$this->auth->id],
  22. 'user.status' => 1,
  23. 'user.gender' => ['neq',$this->auth->gender],
  24. ];
  25. if(!empty($keyworld)){
  26. $where['user.username|nickname'] = ['LILE','%'.$keyworld.'%'];
  27. }
  28. //排除黑名单的
  29. $where_black = [];
  30. $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid');
  31. if(!empty($black_ids)){
  32. $where_black['user.id'] = ['NOTIN',$black_ids];
  33. }
  34. $field = [
  35. 'user.id',
  36. 'user.username',
  37. 'user.nickname',
  38. 'user.avatar',
  39. 'user.idcard_status',
  40. 'user.real_status',
  41. 'user.photo_images',
  42. 'user.gender',
  43. 'user.birthday',
  44. 'user.is_active',
  45. 'user.bio',
  46. 'wallet.vip_endtime',
  47. 'active.requesttime',
  48. ];
  49. $list = Db::name('user')->alias('user')->field($field)
  50. ->join('user_wallet wallet','user.id = wallet.user_id','LEFT')
  51. ->join('user_active active' ,'user.id = active.user_id','LEFT')
  52. ->where($where)
  53. ->where($where_black)
  54. ->order('user.is_active desc,user.id desc')
  55. ->autopage()
  56. ->select();
  57. $list = list_domain_image($list,['avatar','photo_images']);
  58. foreach($list as $key => &$val){
  59. $val['age'] = birthtime_to_age($val['birthday']);
  60. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  61. $val['active_info'] = $this->user_activeinfo($val['id'],$val['requesttime']);
  62. }
  63. $this->success(1,$list);
  64. }
  65. //新人
  66. public function xinren(){
  67. $keyworld = input('keyworld','');
  68. $where = [
  69. 'user.id' => ['neq',$this->auth->id],
  70. 'user.status' => 1,
  71. 'user.gender' => ['neq',$this->auth->gender],
  72. ];
  73. if(!empty($keyworld)){
  74. $where['user.username|nickname'] = ['LILE','%'.$keyworld.'%'];
  75. }
  76. //排除黑名单的
  77. $where_black = [];
  78. $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid');
  79. if(!empty($black_ids)){
  80. $where_black['user.id'] = ['NOTIN',$black_ids];
  81. }
  82. $field = [
  83. 'user.id',
  84. 'user.username',
  85. 'user.nickname',
  86. 'user.avatar',
  87. 'user.idcard_status',
  88. 'user.real_status',
  89. 'user.photo_images',
  90. 'user.gender',
  91. 'user.birthday',
  92. 'user.is_active',
  93. 'user.bio',
  94. 'wallet.vip_endtime',
  95. 'active.requesttime',
  96. ];
  97. $list = Db::name('user')->alias('user')->field($field)
  98. ->join('user_wallet wallet','user.id = wallet.user_id','LEFT')
  99. ->join('user_active active' ,'user.id = active.user_id','LEFT')
  100. ->where($where)
  101. ->where($where_black)
  102. ->order('user.is_active desc,user.id desc')
  103. ->autopage()
  104. ->select();
  105. $list = list_domain_image($list,['avatar','photo_images']);
  106. foreach($list as $key => &$val){
  107. $val['age'] = birthtime_to_age($val['birthday']);
  108. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  109. $val['active_info'] = $this->user_activeinfo($val['id'],$val['requesttime']);
  110. }
  111. $this->success(1,$list);
  112. }
  113. //首页搜索
  114. public function search_user(){
  115. $keyword = input('keyword','');
  116. if(empty($keyword)){
  117. $this->error();
  118. }
  119. $where = [];
  120. if(is_numeric($keyword)){
  121. $where['username'] = intval($keyword);
  122. }else{
  123. $where['nickname'] = ['LIKE','%'.trim($keyword).'%'];
  124. }
  125. $list = Db::name('user')->field('id,username,nickname,gender,avatar')->where($where)->limit(100)->select();
  126. $list = list_domain_image($list,['avatar']);
  127. $this->success(1,$list);
  128. }
  129. }