Userfollow.php 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  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','u.is_active as u_is_active',/*'ua.requesttime as ua_requesttime',*/
  68. 'ou.nickname as ou_nickname','ou.avatar as ou_avatar','ou.is_active as ou_is_active '/*,'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. 'is_active' => $val['ou_is_active'],
  88. 'intimacy' => $val['value'],
  89. // 'requesttime_text' => get_last_time($val['oua_requesttime']),
  90. ];
  91. }else{
  92. $newval = [
  93. 'id' => $val['uid'],
  94. 'nickname' => $val['u_nickname'],
  95. 'avatar' => $val['u_avatar'],
  96. // 'requesttime' => $val['ua_requesttime'],
  97. 'is_active' => $val['u_is_active'],
  98. 'intimacy' => $val['value'],
  99. // 'requesttime_text' => get_last_time($val['ua_requesttime']),
  100. ];
  101. }
  102. $result[] = $newval;
  103. }
  104. }
  105. $this->success(1,$result);
  106. }
  107. //关注某人
  108. public function follow_one(){
  109. $follow_uid = input('follow_uid',0);
  110. if(!$follow_uid){
  111. $this->error(__('Invalid parameters'));
  112. }
  113. $checkuser = Db::name('user')->find($follow_uid);
  114. if(empty($checkuser)){
  115. $this->error('此用户不存在');
  116. }
  117. if($follow_uid == $this->auth->id){
  118. $this->error('不能关注自己');
  119. }
  120. $map = [
  121. 'uid' => $this->auth->id,
  122. 'follow_uid' => $follow_uid,
  123. ];
  124. $check = Db::name('user_follow')->where($map)->find();
  125. if($check){
  126. //取关
  127. $rs = Db::name('user_follow')->where($map)->delete();
  128. $this->success('操作成功');
  129. }
  130. $id = Db::name('user_follow')->insertGetId($map);
  131. $this->success('操作成功',$id);
  132. }
  133. //取关某人
  134. public function un_follow_one(){
  135. $follow_uid = input('follow_uid',0);
  136. if(!$follow_uid){
  137. $this->error(__('Invalid parameters'));
  138. }
  139. $checkuser = Db::name('user')->find($follow_uid);
  140. if(empty($checkuser)){
  141. $this->error('此用户不存在');
  142. }
  143. $map = [
  144. 'uid' => $this->auth->id,
  145. 'follow_uid' => $follow_uid,
  146. ];
  147. //不检查,全删
  148. $rs = Db::name('user_follow')->where($map)->delete();
  149. $this->success('操作成功');
  150. }
  151. //我的关注uids
  152. private function my_follow_uids(){
  153. $list = Db::name('user_follow')->where('uid',$this->auth->id)->column('follow_uid');
  154. $list = array_flip($list);
  155. $list = array_flip($list);
  156. return $list;
  157. }
  158. //我的粉丝uids
  159. private function my_fans_uids(){
  160. $list = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  161. $list = array_flip($list);
  162. $list = array_flip($list);
  163. return $list;
  164. }
  165. }