UserDailyDataFlow.php 2.1 KB

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