Userfollow.php 9.4 KB

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