UserTrafficDaily.php 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Builder;
  4. use Illuminate\Database\Eloquent\Model;
  5. use Illuminate\Database\Eloquent\Relations\HasOne;
  6. /**
  7. * 用户每日流量统计
  8. *
  9. * @property int $id
  10. * @property int $user_id 用户ID
  11. * @property int $node_id 节点ID,0表示统计全部节点
  12. * @property int $u 上传流量
  13. * @property int $d 下载流量
  14. * @property int $total 总流量
  15. * @property string|null $traffic 总流量(带单位)
  16. * @property \Illuminate\Support\Carbon|null $created_at 创建时间
  17. * @property \Illuminate\Support\Carbon|null $updated_at 最后更新时间
  18. * @property-read \App\Models\SsNode|null $node
  19. * @method static Builder|UserTrafficDaily newModelQuery()
  20. * @method static Builder|UserTrafficDaily newQuery()
  21. * @method static Builder|UserTrafficDaily query()
  22. * @method static Builder|UserTrafficDaily userDaily($uid)
  23. * @method static Builder|UserTrafficDaily whereCreatedAt($value)
  24. * @method static Builder|UserTrafficDaily whereD($value)
  25. * @method static Builder|UserTrafficDaily whereId($value)
  26. * @method static Builder|UserTrafficDaily whereNodeId($value)
  27. * @method static Builder|UserTrafficDaily whereTotal($value)
  28. * @method static Builder|UserTrafficDaily whereTraffic($value)
  29. * @method static Builder|UserTrafficDaily whereU($value)
  30. * @method static Builder|UserTrafficDaily whereUpdatedAt($value)
  31. * @method static Builder|UserTrafficDaily whereUserId($value)
  32. * @mixin \Eloquent
  33. */
  34. class UserTrafficDaily extends Model {
  35. protected $table = 'user_traffic_daily';
  36. public function node(): HasOne {
  37. return $this->hasOne(SsNode::class, 'id', 'node_id');
  38. }
  39. // 用户每天使用总流量
  40. public function scopeUserDaily($query, $uid) {
  41. return $query->whereUserId($uid)->whereNodeId(0);
  42. }
  43. }