neiyou_user_web/app/Console/Commands/AutoReportNode.php

<?php

namespace App\Console\Commands;

use App\Components\PushNotification;
use App\Models\Node;
use App\Models\NodeDailyDataFlow;
use Illuminate\Console\Command;
use Log;

class AutoReportNode extends Command
{
    protected $signature = 'autoReportNode';
    protected $description = '自动报告节点昨日使用情况';

    public function handle(): void
    {
        $jobStartTime = microtime(true);

        if (sysConfig('node_daily_report')) {
            $nodeList = Node::whereStatus(1)->get();
            if ($nodeList->isNotEmpty()) {
                $msg = "|节点|上行流量|下行流量|合计|\r\n| :------ | :------ | :------ |\r\n";
                foreach ($nodeList as $node) {
                    $log = NodeDailyDataFlow::whereNodeId($node->id)
                        ->whereDate('created_at', date('Y-m-d', strtotime('-1 days')))
                        ->first();

                    if ($log) {
                        $msg .= '|'.$node->name.'|'.flowAutoShow($log->u).'|'.flowAutoShow($log->d).'|'.$log->traffic."\r\n";
                    } else {
                        $msg .= '|'.$node->name.'|'.flowAutoShow(0).'|'.flowAutoShow(0)."|0B\r\n";
                    }
                }

                PushNotification::send('节点昨日使用情况', $msg);
            }
        }

        $jobEndTime = microtime(true);
        $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);

        Log::info('---【'.$this->description.'】完成---，耗时'.$jobUsedTime.'秒');
    }
}