Userfollow.php 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. /**
  6. * 关注
  7. */
  8. class Userfollow extends Api
  9. {
  10. protected $noNeedLogin = [];
  11. protected $noNeedRight = ['*'];
  12. //我的关注列表
  13. public function my_follow_list(){
  14. $user_id = input('user_id',0);
  15. if(empty($user_id)){
  16. $user_id = $this->auth->id;
  17. }
  18. //列表
  19. $list = Db::name('user_follow')
  20. ->alias('follow')
  21. ->join('user','follow.follow_uid = user.id','LEFT')
  22. ->field('user.id,user.username,user.nickname,user.avatar,user.birthday,user.gender')
  23. ->where('follow.uid',$user_id)->order('follow.id desc')->group('follow.follow_uid')->autopage()->select();
  24. $list = list_domain_image($list,['avatar']);
  25. $list = list_birthday_age($list);
  26. //我的关注uids
  27. $my_follow_uids = $this->my_follow_uids();
  28. if(!empty($list)){
  29. foreach($list as $key => &$val){
  30. //是否关注
  31. $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
  32. }
  33. }
  34. $this->success('success',$list);
  35. }
  36. //我的粉丝列表
  37. public function my_fans_list(){
  38. $user_id = input('user_id',0);
  39. if(empty($user_id)){
  40. $user_id = $this->auth->id;
  41. }
  42. //列表
  43. $list = Db::name('user_follow')
  44. ->alias('follow')
  45. ->join('user','follow.uid = user.id','LEFT')
  46. ->field('user.id,user.username,user.nickname,user.avatar,user.birthday,user.gender')
  47. ->where('follow.follow_uid',$user_id)
  48. ->group('follow.uid')
  49. ->order('follow.id desc')->autopage()->select();
  50. $list = list_domain_image($list,['avatar']);
  51. $list = list_birthday_age($list);
  52. //我的关注uids
  53. $my_follow_uids = $this->my_follow_uids();
  54. if(!empty($list)){
  55. foreach($list as $key => &$val){
  56. //是否关注
  57. $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
  58. }
  59. }
  60. $this->success('success',$list);
  61. }
  62. //我的好友,有亲密度就算是好友
  63. public function my_friend_list(){
  64. //亲密度列表
  65. $intimacy = Db::name('user_intimacy')->alias('ui')
  66. ->field(['ui.id','ui.uid','ui.other_uid','ui.value','ui.level','
  67. u.nickname as u_nickname','u.avatar as u_avatar','ua.requesttime as ua_requesttime','
  68. ou.nickname as ou_nickname','ou.avatar as ou_avatar','oua.requesttime as oua_requesttime'])
  69. ->join('user u' ,'ui.uid = u.id','LEFT')
  70. ->join('user_active ua' ,'ui.uid = ua.user_id','LEFT')
  71. ->join('user ou' ,'ui.other_uid = ou.id','LEFT')
  72. ->join('user_active oua','ui.other_uid = oua.user_id','LEFT')
  73. ->where('(ui.uid = '.$this->auth->id.') or (ui.other_uid = '.$this->auth->id.')')
  74. ->where('ui.value','gt','0.1')
  75. ->order('ui.value desc, ui.id desc')->select();
  76. // dump($intimacy);
  77. $result = [];
  78. if(!empty($intimacy)){
  79. foreach($intimacy as $key => $val){
  80. $newval = [];
  81. if($val['uid'] == $this->auth->id){
  82. $newval = [
  83. 'id' => $val['other_uid'],
  84. 'nickname' => $val['ou_nickname'],
  85. 'avatar' => $val['ou_avatar'],
  86. 'requesttime' => $val['oua_requesttime'],
  87. 'intimacy' => $val['value'],
  88. 'requesttime_text' => get_last_time($val['oua_requesttime']),
  89. ];
  90. }else{
  91. $newval = [
  92. 'id' => $val['uid'],
  93. 'nickname' => $val['u_nickname'],
  94. 'avatar' => $val['u_avatar'],
  95. 'requesttime' => $val['ua_requesttime'],
  96. 'intimacy' => $val['value'],
  97. 'requesttime_text' => get_last_time($val['ua_requesttime']),
  98. ];
  99. }
  100. $result[] = $newval;
  101. }
  102. }
  103. $this->success(1,$result);
  104. }
  105. //关注某人
  106. public function follow_one(){
  107. $follow_uid = input('follow_uid',0);
  108. if(!$follow_uid){
  109. $this->error(__('Invalid parameters'));
  110. }
  111. $checkuser = Db::name('user')->find($follow_uid);
  112. if(empty($checkuser)){
  113. $this->error('此用户不存在');
  114. }
  115. if($follow_uid == $this->auth->id){
  116. $this->error('不能关注自己');
  117. }
  118. $map = [
  119. 'uid' => $this->auth->id,
  120. 'follow_uid' => $follow_uid,
  121. ];
  122. $check = Db::name('user_follow')->where($map)->find();
  123. if($check){
  124. //取关
  125. $rs = Db::name('user_follow')->where($map)->delete();
  126. $this->success('操作成功');
  127. }
  128. $id = Db::name('user_follow')->insertGetId($map);
  129. $this->success('操作成功',$id);
  130. }
  131. //取关某人
  132. public function un_follow_one(){
  133. $follow_uid = input('follow_uid',0);
  134. if(!$follow_uid){
  135. $this->error(__('Invalid parameters'));
  136. }
  137. $checkuser = Db::name('user')->find($follow_uid);
  138. if(empty($checkuser)){
  139. $this->error('此用户不存在');
  140. }
  141. $map = [
  142. 'uid' => $this->auth->id,
  143. 'follow_uid' => $follow_uid,
  144. ];
  145. //不检查,全删
  146. $rs = Db::name('user_follow')->where($map)->delete();
  147. $this->success('操作成功');
  148. }
  149. //我的关注uids
  150. private function my_follow_uids(){
  151. $list = Db::name('user_follow')->where('uid',$this->auth->id)->column('follow_uid');
  152. $list = array_flip($list);
  153. $list = array_flip($list);
  154. return $list;
  155. }
  156. //我的粉丝uids
  157. private function my_fans_uids(){
  158. $list = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  159. $list = array_flip($list);
  160. $list = array_flip($list);
  161. return $list;
  162. }
  163. }