User.php 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304
  1. <?php
  2. namespace App\Models;
  3. use App\Casts\data_rate;
  4. use App\Casts\money;
  5. use App\Observers\UserObserver;
  6. use App\Utils\Avatar;
  7. use App\Utils\Helpers;
  8. use Hash;
  9. use Hashids\Hashids;
  10. use Illuminate\Database\Eloquent\Attributes\ObservedBy;
  11. use Illuminate\Database\Eloquent\Builder;
  12. use Illuminate\Database\Eloquent\Factories\HasFactory;
  13. use Illuminate\Database\Eloquent\Relations\BelongsTo;
  14. use Illuminate\Database\Eloquent\Relations\BelongsToMany;
  15. use Illuminate\Database\Eloquent\Relations\HasMany;
  16. use Illuminate\Database\Eloquent\Relations\HasManyThrough;
  17. use Illuminate\Database\Eloquent\Relations\HasOne;
  18. use Illuminate\Foundation\Auth\User as Authenticatable;
  19. use Illuminate\Notifications\Notifiable;
  20. use Kyslik\ColumnSortable\Sortable;
  21. use Laravel\Sanctum\HasApiTokens;
  22. use Spatie\Permission\Traits\HasRoles;
  23. /**
  24. * 用户信息.
  25. */
  26. #[ObservedBy([UserObserver::class])]
  27. class User extends Authenticatable
  28. {
  29. use HasApiTokens, HasFactory, HasRoles, Notifiable, Sortable;
  30. public array $sortable = ['id', 'credit', 'port', 't', 'expired_at'];
  31. protected $table = 'user';
  32. protected $casts = ['credit' => money::class, 'speed_limit' => data_rate::class, 'expired_at' => 'date:Y-m-d', 'reset_time' => 'date:Y-m-d', 'ban_time' => 'date:Y-m-d'];
  33. protected $guarded = [];
  34. public function routeNotificationForMail($notification): string
  35. {
  36. return $this->username;
  37. }
  38. public function onlineIpLogs(): HasMany
  39. {
  40. return $this->hasMany(NodeOnlineIp::class);
  41. }
  42. public function payments(): HasMany
  43. {
  44. return $this->hasMany(Payment::class);
  45. }
  46. public function commissionSettlements(): HasMany
  47. {
  48. return $this->hasMany(ReferralApply::class);
  49. }
  50. public function commissionLogs(): HasMany
  51. {
  52. return $this->hasMany(ReferralLog::class, 'inviter_id');
  53. }
  54. public function ruleLogs(): HasMany
  55. {
  56. return $this->hasMany(RuleLog::class);
  57. }
  58. public function tickets(): HasMany
  59. {
  60. return $this->hasMany(Ticket::class);
  61. }
  62. public function ticketReplies(): HasMany
  63. {
  64. return $this->hasMany(TicketReply::class);
  65. }
  66. public function banedLogs(): HasMany
  67. {
  68. return $this->hasMany(UserBanedLog::class);
  69. }
  70. public function creditLogs(): HasMany
  71. {
  72. return $this->hasMany(UserCreditLog::class);
  73. }
  74. public function dailyDataFlows(): HasMany
  75. {
  76. return $this->hasMany(UserDailyDataFlow::class);
  77. }
  78. public function dataFlowLogs(): HasMany
  79. {
  80. return $this->hasMany(UserDataFlowLog::class);
  81. }
  82. public function dataModifyLogs(): HasMany
  83. {
  84. return $this->hasMany(UserDataModifyLog::class);
  85. }
  86. public function hourlyDataFlows(): HasMany
  87. {
  88. return $this->HasMany(UserHourlyDataFlow::class);
  89. }
  90. public function loginLogs(): HasMany
  91. {
  92. return $this->HasMany(UserLoginLog::class);
  93. }
  94. public function subscribe(): HasOne
  95. {
  96. return $this->hasOne(UserSubscribe::class);
  97. }
  98. public function subscribeLogs(): HasManyThrough
  99. {
  100. return $this->hasManyThrough(UserSubscribeLog::class, UserSubscribe::class);
  101. }
  102. public function verify(): HasMany
  103. {
  104. return $this->hasMany(Verify::class);
  105. }
  106. public function inviter(): BelongsTo
  107. {
  108. return $this->belongsTo(__CLASS__);
  109. }
  110. public function invites(): HasMany
  111. {
  112. return $this->hasMany(Invite::class, 'inviter_id');
  113. }
  114. public function invitees(): HasMany
  115. {
  116. return $this->hasMany(__CLASS__, 'inviter_id');
  117. }
  118. public function userGroup(): BelongsTo
  119. {
  120. return $this->belongsTo(UserGroup::class);
  121. }
  122. public function orders(): HasMany
  123. {
  124. return $this->hasMany(Order::class);
  125. }
  126. public function paidOrders(): hasMany
  127. {
  128. return $this->hasMany(Order::class)->where('status', 2)->whereNotNull('goods_id')->where('is_expire', 0)->where('amount', '>', 0);
  129. }
  130. public function scopeActiveUser(Builder $query): Builder
  131. {
  132. return $query->where('status', '<>', -1)->whereEnable(1);
  133. }
  134. public function scopeBannedUser(Builder $query): Builder
  135. {
  136. return $query->where('status', '<>', -1)->whereEnable(0);
  137. }
  138. public function getExpirationDateAttribute(): ?string
  139. {
  140. return $this->attributes['expired_at'];
  141. }
  142. public function getResetDateAttribute(): ?string
  143. {
  144. return $this->attributes['reset_time'];
  145. }
  146. public function getTelegramUserIdAttribute(): ?string
  147. {
  148. $telegram = $this->userAuths()->whereType('telegram')->first();
  149. return $telegram->identifier ?? null;
  150. }
  151. public function userAuths(): HasMany
  152. {
  153. return $this->hasMany(UserOauth::class);
  154. }
  155. public function getCreditTagAttribute(): string
  156. {
  157. return Helpers::getPriceTag($this->credit);
  158. }
  159. public function getTransferEnableFormattedAttribute(): string
  160. {
  161. return formatBytes($this->attributes['transfer_enable']);
  162. }
  163. public function getExpirationStatusAttribute(): int
  164. {
  165. $today = date('Y-m-d');
  166. $nextMonth = date('Y-m-d', strtotime('next month'));
  167. if ($this->expiration_date < $today) {
  168. $status = 0; // 已过期
  169. } elseif ($this->expiration_date === $today) {
  170. $status = 1; // 今日过期
  171. } elseif ($this->expiration_date <= $nextMonth) {
  172. $status = 2; // 一个月内过期
  173. }
  174. return $status ?? 3;
  175. }
  176. public function getSubUrlAttribute(): string
  177. {
  178. return route('sub', $this->subscribe->code);
  179. }
  180. public function getInviteCodeAttribute(): string
  181. {
  182. $uid = $this->id;
  183. $affSalt = sysConfig('aff_salt');
  184. return empty($affSalt) ? $uid : (new Hashids($affSalt, 8))->encode($uid);
  185. }
  186. public function getInviteUrlAttribute(): string
  187. {
  188. return sysConfig('website_url').route('register', ['aff' => $this->invite_code], false);
  189. }
  190. public function getUsedTrafficAttribute(): int
  191. {
  192. return $this->d + $this->u;
  193. }
  194. public function getUnusedTrafficAttribute(): int
  195. {
  196. return max($this->transfer_enable - $this->d - $this->u, 0);
  197. }
  198. public function getAvatarAttribute(): string
  199. {
  200. return session()->remember('avatar_url_'.$this->id, function () {
  201. if ($this->qq) {
  202. return Avatar::getQQAvatar($this->qq);
  203. }
  204. if (str(str($this->username)->lower())->endsWith('@qq.com')) {
  205. return Avatar::getQQAvatar($this->username);
  206. }
  207. return Avatar::getRandomAvatar($this->username);
  208. });
  209. }
  210. public function getLevelNameAttribute(): string
  211. {
  212. return Level::where('level', $this->level)->value('name');
  213. }
  214. public function setPasswordAttribute(string $password): string
  215. {
  216. return $this->attributes['password'] = Hash::make($password);
  217. }
  218. public function nodes(?int $userLevel = null, ?int $userGroupId = null): Node|Builder|BelongsToMany
  219. {
  220. if ($userGroupId === null && $this->user_group_id) { // 使用默认的用户分组
  221. $query = $this->userGroup->nodes();
  222. } elseif ($userGroupId) { // 使用给的用户分组
  223. $query = UserGroup::findOrFail($userGroupId)->nodes();
  224. } else { // 无用户分组
  225. $query = Node::query();
  226. }
  227. return $query->whereStatus(1)->where('level', '<=', $userLevel ?? $this->level ?? 0);
  228. }
  229. public function updateCredit(float $credit): bool
  230. {
  231. $this->credit += $credit;
  232. return $this->credit >= 0 && $this->save();
  233. }
  234. public function incrementData(int $data): bool
  235. { // 添加用户流量
  236. $this->transfer_enable += $data;
  237. return $this->save();
  238. }
  239. public function routeNotificationForTelegram()
  240. {
  241. return $this->telegram_user_id;
  242. }
  243. }