Userfollow.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
  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. Db::name('message')->where('id',$id)->update(['status'=>1]);
  137. $this->success('已拒绝');
  138. }
  139. //关注某人
  140. public function follow_one(){
  141. $follow_uid = input('follow_uid',0);
  142. if(!$follow_uid){
  143. $this->error(__('Invalid parameters'));
  144. }
  145. $checkuser = Db::name('user')->find($follow_uid);
  146. if(empty($checkuser)){
  147. $this->error('此用户不存在');
  148. }
  149. if($follow_uid == $this->auth->id){
  150. $this->error('不能关注自己');
  151. }
  152. $map = [
  153. 'uid' => $this->auth->id,
  154. 'follow_uid' => $follow_uid,
  155. ];
  156. $check = Db::name('user_follow')->where($map)->find();
  157. if($check){
  158. //取关
  159. $rs = Db::name('user_follow')->where($map)->delete();
  160. $this->success('操作成功');
  161. }
  162. Db::startTrans();
  163. $id = Db::name('user_follow')->insertGetId($map);
  164. if(!$id){
  165. Db::rollback();
  166. $this->error('关注失败');
  167. }
  168. //被关注人如果没有关注我,发一条消息,让他加好友,也就是让他回关
  169. $map2 = [
  170. 'uid' => $follow_uid,
  171. 'follow_uid' => $this->auth->id,
  172. ];
  173. $check = Db::name('user_follow')->where($map2)->find();
  174. if(empty($check) && $this->user_power($this->auth->id,'yinsi') != 1){
  175. $message = [
  176. 'user_id' => $follow_uid,
  177. 'title' => '好友请求',
  178. 'content' => '有人关注了你,回关TA成为好友',
  179. 'createtime' => time(),
  180. 'status' => 0,
  181. 'infotype' => 'newfriend',//关注,请求好友
  182. 'infotype_id' => $this->auth->id,
  183. ];
  184. Db::name('message')->insertGetId($message);
  185. }
  186. Db::commit();
  187. $this->success('操作成功',$id);
  188. }
  189. //取关某人
  190. public function un_follow_one(){
  191. $follow_uid = input('follow_uid',0);
  192. if(!$follow_uid){
  193. $this->error(__('Invalid parameters'));
  194. }
  195. $checkuser = Db::name('user')->find($follow_uid);
  196. if(empty($checkuser)){
  197. $this->error('此用户不存在');
  198. }
  199. $map = [
  200. 'uid' => $this->auth->id,
  201. 'follow_uid' => $follow_uid,
  202. ];
  203. //不检查,全删
  204. $rs = Db::name('user_follow')->where($map)->delete();
  205. $this->success('操作成功');
  206. }
  207. //我的关注uids
  208. private function my_follow_uids(){
  209. return Db::name('user_follow')->where('uid',$this->auth->id)->column('follow_uid');
  210. }
  211. //我的粉丝uids
  212. private function my_fans_uids(){
  213. return Db::name('user_follow')->where('follow_uid',$this->auth->id)->column('uid');
  214. }
  215. }