Uservisit.php 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. /**
  6. * 访问足迹
  7. */
  8. class Uservisit extends Api
  9. {
  10. protected $noNeedLogin = [];
  11. protected $noNeedRight = ['*'];
  12. //我的访问列表
  13. public function my_visit_list(){
  14. $list = Db::name('user_visit')
  15. ->alias('visit')
  16. ->join('user','visit.to_uid = user.id','LEFT')
  17. ->field('user.id,user.username,user.nickname,user.avatar,user.bio,visit.updatetime')
  18. ->where('visit.uid',$this->auth->id)->order('visit.updatetime desc')->autopage()->select();
  19. $list = list_domain_image($list,['avatar']);
  20. foreach($list as $key => &$val){
  21. //时间
  22. $val['createtime_text'] = get_last_time($val['updatetime']);
  23. unset($val['updatetime']);
  24. }
  25. $this->success('success',$list);
  26. }
  27. //访问我的人列表,消除无痕
  28. public function visit_me_list(){
  29. $list = Db::name('user_visit')
  30. ->alias('visit')
  31. ->join('user','visit.uid = user.id','LEFT')
  32. ->join('user_power power','visit.uid = power.user_id','LEFT')
  33. ->field('user.id,user.username,user.nickname,user.avatar,user.bio,visit.updatetime')
  34. ->where('visit.to_uid',$this->auth->id)
  35. ->where('power.wuhen',0)
  36. ->order('visit.updatetime desc')->autopage()->select();
  37. $list = list_domain_image($list,['avatar']);
  38. foreach($list as $key => &$val){
  39. //时间
  40. $val['createtime_text'] = get_last_time($val['updatetime']);
  41. unset($val['updatetime']);
  42. }
  43. $number = Db::name('user_visit')->alias('visit')
  44. ->join('user_power power','visit.uid = power.user_id','LEFT')
  45. ->where('visit.to_uid',$this->auth->id)
  46. ->where('power.wuhen',0)
  47. ->count();
  48. $result = [
  49. 'list' => $list,
  50. 'number' => $number
  51. ];
  52. $this->success('success',$result);
  53. }
  54. //查看某人
  55. public function visit_one(){
  56. //放到usercenter/getuserinfo里了
  57. }
  58. }