UserFans.php 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | 商城系统 [ 致力于通过产品和服务,帮助商家高效化开拓市场 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2017~2021 https://www.thinkphp.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed 这不是一个自由软件,不允许对程序代码以任何形式任何目的的再发行
  8. // +----------------------------------------------------------------------
  9. // | Author: thinkphp <admin@yiovo.com>
  10. // +----------------------------------------------------------------------
  11. declare (strict_types=1);
  12. namespace app\api\model;
  13. use app\common\model\UserFans as UserFansModel;
  14. /**
  15. * 用户粉丝模型类
  16. * Class UserFans
  17. * @package app\api\model
  18. */
  19. class UserFans extends UserFansModel
  20. {
  21. protected $globalScope = [''];
  22. /**
  23. * 隐藏字段
  24. * @var array
  25. */
  26. protected $hidden = [
  27. 'update_time'
  28. ];
  29. public function getFollowList($userId, array $param = [], int $listRows = 15)
  30. {
  31. $list = $this->alias($this->name)
  32. ->leftJoin('user u','u.user_id='.$this->name.'.user_id')
  33. ->leftJoin('user_info ui','ui.user_id='.$this->name.'.user_id')
  34. ->where([$this->name.'.fans_id'=> $userId, $this->name.'.status'=> 1,'u.status'=>1,'u.is_delete'=>0])
  35. ->field($this->name.'.*,u.nick_name,u.user_type,u.avatar_id,ui.admission_year,ui.school_id')
  36. ->group($this->name.'.user_id')
  37. ->order($this->name.'.update_time desc, '.$this->name.'.id desc')
  38. ->paginate($listRows);
  39. return $this->setListDataFromApi($list, $param);
  40. }
  41. /**
  42. * 设置展示的数据 api模块
  43. * @param $info
  44. * @return mixed
  45. */
  46. private function setListDataFromApi($info, $params=[])
  47. {
  48. return $this->setListData($info, function ($data) use ($params){
  49. // 整理数据 api模块
  50. $this->setDataFromApi($data);
  51. // 隐藏冗余的字段
  52. $this->hidden(array_merge($this->hidden, ['status','avatar_id']));
  53. });
  54. }
  55. /**
  56. * 整理数据 api模块
  57. * @param $info
  58. * @return mixed
  59. */
  60. private function setDataFromApi($info)
  61. {
  62. return $this->setData($info, function ($data) {
  63. // 用户类型
  64. $userType = isset($data['user_type'])? $data['user_type'] : 0;
  65. $schoolId = isset($data['school_id'])? $data['school_id'] : 0;
  66. if($userType == 3){
  67. // 招生学校
  68. $data['school_name'] = $schoolId? School::getSchoolField($schoolId) : '';
  69. }else{
  70. // 生源学校
  71. $data['school_name'] = $schoolId? SourceShool::getSchoolField($schoolId) : '';
  72. }
  73. // 用户头像
  74. $avatarId = isset($data['avatar_id'])? $data['avatar_id'] : 0;
  75. if($avatarId){
  76. $avatarData = UploadFile::detail($avatarId);
  77. $data['avatar_url'] = isset($avatarData['preview_url'])? $avatarData['preview_url'] : '';
  78. }
  79. // 用户类型
  80. $admissionYear = isset($data['admission_year'])? $data['admission_year'] : '';
  81. $data['user_type_text'] = $userType == 3? '招生老师' : ($admissionYear? $admissionYear.'级' : '学生');
  82. });
  83. }
  84. /**
  85. * 获取粉丝用户ID
  86. * @param int $userId
  87. * @return array
  88. */
  89. public static function getFansUid(int $userId)
  90. {
  91. return self::where(['user_id'=> $userId, 'status'=>1])->column('fans_id');
  92. }
  93. /**
  94. * 获取粉丝数
  95. * @param int $userId
  96. * @return array
  97. */
  98. public static function getFansNum(int $userId)
  99. {
  100. return self::where(['user_id'=> $userId, 'status'=>1])->count('fans_id');
  101. }
  102. }