Index.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
  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.gender',
  42. 'user.birthday',
  43. 'user.is_active',
  44. 'user.bio',
  45. 'user.wealth_level',
  46. 'user.charm_level',
  47. 'wallet.vip_endtime',
  48. 'wealth.image as wealth_image',
  49. 'charm.image as charm_image',
  50. ];
  51. $list = Db::name('user')->alias('user')->field($field)
  52. ->join('user_wallet wallet','user.id = wallet.user_id','LEFT')
  53. ->join('wealth_level wealth','user.wealth_level = wealth.level','LEFT')
  54. ->join('charm_level charm','user.charm_level = charm.level','LEFT')
  55. ->where($where)
  56. ->where($where_black)
  57. ->order('user.is_active desc,user.id desc')
  58. ->autopage()
  59. ->select();
  60. $list = list_domain_image($list,['avatar','photo_images','wealth_image','charm_image']);
  61. foreach($list as $key => &$val){
  62. $val['age'] = birthtime_to_age($val['birthday']);
  63. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  64. }
  65. $this->success(1,$list);
  66. }
  67. //新人
  68. public function xinren(){
  69. $keyworld = input('keyworld','');
  70. $where = [
  71. 'user.id' => ['neq',$this->auth->id],
  72. 'user.status' => 1,
  73. 'user.gender' => ['neq',$this->auth->gender],
  74. ];
  75. if(!empty($keyworld)){
  76. $where['user.username|nickname'] = ['LILE','%'.$keyworld.'%'];
  77. }
  78. //排除黑名单的
  79. $where_black = [];
  80. $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid');
  81. if(!empty($black_ids)){
  82. $where_black['user.id'] = ['NOTIN',$black_ids];
  83. }
  84. $field = [
  85. 'user.id',
  86. 'user.username',
  87. 'user.nickname',
  88. 'user.avatar',
  89. 'user.idcard_status',
  90. 'user.real_status',
  91. 'user.gender',
  92. 'user.birthday',
  93. 'user.is_active',
  94. 'user.bio',
  95. 'user.wealth_level',
  96. 'user.charm_level',
  97. 'wallet.vip_endtime',
  98. 'wealth.image as wealth_image',
  99. 'charm.image as charm_image',
  100. ];
  101. $list = Db::name('user')->alias('user')->field($field)
  102. ->join('user_wallet wallet','user.id = wallet.user_id','LEFT')
  103. ->join('wealth_level wealth','user.wealth_level = wealth.level','LEFT')
  104. ->join('charm_level charm','user.charm_level = charm.level','LEFT')
  105. ->where($where)
  106. ->where($where_black)
  107. ->order('user.is_active desc,user.id desc')
  108. ->autopage()
  109. ->select();
  110. $list = list_domain_image($list,['avatar','photo_images','wealth_image','charm_image']);
  111. foreach($list as $key => &$val){
  112. $val['age'] = birthtime_to_age($val['birthday']);
  113. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  114. }
  115. $this->success(1,$list);
  116. }
  117. //首页搜索
  118. public function search_user(){
  119. $keyword = input('keyword','');
  120. if(empty($keyword)){
  121. $this->error();
  122. }
  123. $where = [];
  124. if(is_numeric($keyword)){
  125. $where['username'] = intval($keyword);
  126. }else{
  127. $where['nickname'] = ['LIKE','%'.trim($keyword).'%'];
  128. }
  129. $list = Db::name('user')->field('id,username,nickname,gender,avatar')->where($where)->limit(100)->select();
  130. $list = list_domain_image($list,['avatar']);
  131. $this->success(1,$list);
  132. }
  133. }