Userfollow.php 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  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. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  23. ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
  24. ->where('follow.uid',$user_id)->order('follow.id desc')->group('follow.follow_uid')->autopage()->select();
  25. $list = list_domain_image($list,['avatar']);
  26. $list = list_birthday_age($list);
  27. //我的关注uids
  28. $my_follow_uids = $this->my_follow_uids();
  29. if(!empty($list)){
  30. foreach($list as $key => &$val){
  31. //用户vip
  32. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  33. unset($val['vip_endtime']);
  34. //是否关注
  35. $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
  36. }
  37. }
  38. $this->success('success',$list);
  39. }
  40. //我的粉丝列表
  41. public function my_fans_list(){
  42. $user_id = input('user_id',0);
  43. if(empty($user_id)){
  44. $user_id = $this->auth->id;
  45. }
  46. //列表
  47. $list = Db::name('user_follow')
  48. ->alias('follow')
  49. ->join('user','follow.uid = user.id','LEFT')
  50. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  51. ->field('user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
  52. ->where('follow.follow_uid',$user_id)
  53. ->group('follow.uid')
  54. ->order('follow.id desc')->autopage()->select();
  55. $list = list_domain_image($list,['avatar']);
  56. $list = list_birthday_age($list);
  57. //我的关注uids
  58. $my_follow_uids = $this->my_follow_uids();
  59. if(!empty($list)){
  60. foreach($list as $key => &$val){
  61. //用户vip
  62. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  63. unset($val['vip_endtime']);
  64. //是否关注
  65. $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
  66. }
  67. }
  68. $this->success('success',$list);
  69. }
  70. //我的好友,拿粉丝列表改的
  71. public function my_friend_list(){
  72. //我的关注uids
  73. $my_follow_uids = $this->my_follow_uids();
  74. //我的粉丝uids
  75. $my_fans_uids = $this->my_fans_uids();
  76. //合集就是朋友
  77. $friend_ids = array_intersect($my_follow_uids,$my_fans_uids);
  78. //dump($friend_ids);
  79. //好友列表
  80. $list = Db::name('user')->alias('user')
  81. ->field('user.id,user.nickname,user.avatar,a.requesttime')
  82. ->join('user_active a','user.id = a.user_id','LEFT')
  83. ->where('user.id','IN',$friend_ids)->autopage()->order('user.id asc')->select();
  84. if(empty($list)){
  85. $this->success(1,[]);
  86. }
  87. //dump($list);
  88. $list_ids = implode(',',array_column($list,'id'));
  89. //dump($list_ids);
  90. //亲密度列表
  91. $intimacy = Db::name('user_intimacy')->where('(uid = '.$this->auth->id.' and other_uid in ('.$list_ids.')) or (uid in ('.$list_ids.') and other_uid = '.$this->auth->id.')')->select();
  92. //dump($intimacy);
  93. foreach($list as $key => &$val){
  94. $val['intimacy'] = 0;
  95. $val['requesttime_text'] = get_last_time($val['requesttime']);
  96. foreach($intimacy as $k => $v){
  97. if($v['uid'] == $this->auth->id && $v['other_uid'] == $val['id']){
  98. $val['intimacy'] = $v['value'];
  99. }
  100. if($v['uid'] == $val['id'] && $v['other_uid'] == $this->auth->id){
  101. $val['intimacy'] = $v['value'];
  102. }
  103. }
  104. }
  105. $this->success(1,$list);
  106. }
  107. //好友待审核列表。
  108. public function newfriend_list(){
  109. //我的关注uids
  110. $my_follow_uids = $this->my_follow_uids();
  111. // dump($my_follow_uids);
  112. $list = Db::name('message')->alias('msg')
  113. ->join('user user','user.id = msg.infotype_id','LEFT')
  114. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  115. ->field('msg.id as msg_id,user.id,user.username,user.nickname,user.avatar,user.bio,user.birthday,user.gender,user.attribute,uw.vip_endtime')
  116. ->where(['msg.infotype'=>'newfriend','msg.user_id'=>$this->auth->id,'msg.audit_status'=>0])
  117. ->where('msg.infotype_id','NOT IN',$my_follow_uids)
  118. ->order('msg.id desc')->autopage()->select();
  119. $list = list_domain_image($list,['avatar']);
  120. $list = list_birthday_age($list);
  121. if(!empty($list)){
  122. foreach($list as $key => &$val){
  123. //用户vip
  124. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  125. unset($val['vip_endtime']);
  126. //是否关注
  127. $val['is_follow'] = in_array($val['id'],$my_follow_uids) ? 1 : 0;
  128. }
  129. }
  130. $this->success('success',$list);
  131. }
  132. //拒绝好友请求
  133. public function refuse_newfriend(){
  134. $id = input('msg_id',0);
  135. $msg_info = Db::name('message')->where('id',$id)->find();
  136. Db::name('message')->where('id',$id)->update(['audit_status'=>1]);
  137. //拒绝给个消息
  138. if($msg_info['infotype'] == 'newfriend' && !empty($msg_info['infotype_id'])){
  139. $msg_id = \app\common\model\Message::addMessage($msg_info['infotype_id'],'好友申请被拒绝',$this->auth->nickname.'拒绝了您的好友请求');
  140. }
  141. $this->success('已拒绝');
  142. }
  143. //关注某人
  144. public function follow_one(){
  145. $follow_uid = input('follow_uid',0);
  146. $msg_id = input('msg_id',0);
  147. if(!$follow_uid){
  148. $this->error(__('Invalid parameters'));
  149. }
  150. $checkuser = Db::name('user')->find($follow_uid);
  151. if(empty($checkuser)){
  152. $this->error('此用户不存在');
  153. }
  154. if($follow_uid == $this->auth->id){
  155. $this->error('不能关注自己');
  156. }
  157. $map = [
  158. 'uid' => $this->auth->id,
  159. 'follow_uid' => $follow_uid,
  160. ];
  161. $check = Db::name('user_follow')->where($map)->find();
  162. if($check){
  163. //取关
  164. $rs = Db::name('user_follow')->where($map)->delete();
  165. $this->success('操作成功');
  166. }
  167. Db::startTrans();
  168. $id = Db::name('user_follow')->insertGetId($map);
  169. if(!$id){
  170. Db::rollback();
  171. $this->error('关注失败');
  172. }
  173. //被关注人如果没有关注我,发一条消息,让他加好友,也就是让他回关
  174. $map2 = [
  175. 'uid' => $follow_uid,
  176. 'follow_uid' => $this->auth->id,
  177. ];
  178. $check = Db::name('user_follow')->where($map2)->find();
  179. if(empty($check)){
  180. //防止重复刷关注,先删掉以前的,再加新的
  181. Db::name('message')
  182. ->where('user_id',$follow_uid)
  183. ->where('infotype','newfriend')
  184. ->where('infotype_id',$this->auth->id)
  185. ->delete();
  186. $message = [
  187. 'user_id' => $follow_uid,
  188. 'title' => '好友请求',
  189. 'content' => '有人关注了你,回关TA成为好友',
  190. 'createtime' => time(),
  191. 'status' => 0,
  192. 'infotype' => 'newfriend',//关注,请求好友
  193. 'infotype_id' => $this->auth->id,
  194. ];
  195. Db::name('message')->insertGetId($message);
  196. }
  197. //我从好友审核列表过来的,我又回关了
  198. if(!empty($msg_id)){
  199. Db::name('message')->where('id',$id)->update(['audit_status'=>1]);
  200. $msg_id = \app\common\model\Message::addMessage($follow_uid,'好友申请已通过',$this->auth->nickname.'同意了您的好友请求');
  201. }
  202. Db::commit();
  203. $this->success('操作成功',$id);
  204. }
  205. //取关某人
  206. public function un_follow_one(){
  207. $follow_uid = input('follow_uid',0);
  208. if(!$follow_uid){
  209. $this->error(__('Invalid parameters'));
  210. }
  211. $checkuser = Db::name('user')->find($follow_uid);
  212. if(empty($checkuser)){
  213. $this->error('此用户不存在');
  214. }
  215. $map = [
  216. 'uid' => $this->auth->id,
  217. 'follow_uid' => $follow_uid,
  218. ];
  219. //不检查,全删
  220. $rs = Db::name('user_follow')->where($map)->delete();
  221. $this->success('操作成功');
  222. }
  223. //我的关注uids
  224. private function my_follow_uids(){
  225. $list = Db::name('user_follow')->where('uid',$this->auth->id)->column('follow_uid');
  226. $list = array_flip($list);
  227. $list = array_flip($list);
  228. return $list;
  229. }
  230. //我的粉丝uids
  231. private function my_fans_uids(){
  232. $list = Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  233. $list = array_flip($list);
  234. $list = array_flip($list);
  235. return $list;
  236. }
  237. }