AutoStatisticsNodeHourlyTraffic.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\Node;
  4. use App\Models\NodeHourlyDataFlow;
  5. use App\Models\UserDataFlowLog;
  6. use Illuminate\Console\Command;
  7. use Log;
  8. class AutoStatisticsNodeHourlyTraffic extends Command
  9. {
  10. protected $signature = 'autoStatisticsNodeHourlyTraffic';
  11. protected $description = '自动统计节点每小时流量';
  12. public function handle(): void
  13. {
  14. $jobStartTime = microtime(true);
  15. foreach (Node::whereStatus(1)->orderBy('id')->get() as $node) {
  16. $this->statisticsByNode($node->id);
  17. }
  18. $jobEndTime = microtime(true);
  19. $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
  20. Log::info('---【'.$this->description.'】完成---,耗时'.$jobUsedTime.'秒');
  21. }
  22. private function statisticsByNode($node_id): void
  23. {
  24. $query = UserDataFlowLog::whereNodeId($node_id)->whereBetween('log_time', [strtotime("-1 hour"), time()]);
  25. $u = $query->sum('u');
  26. $d = $query->sum('d');
  27. $total = $u + $d;
  28. if ($total) { // 有数据才记录
  29. $obj = new NodeHourlyDataFlow();
  30. $obj->node_id = $node_id;
  31. $obj->u = $u;
  32. $obj->d = $d;
  33. $obj->total = $total;
  34. $obj->traffic = flowAutoShow($total);
  35. $obj->save();
  36. }
  37. }
  38. }