Index.php 5.5 KB

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