neiyou_user_web/app/Console/Commands/UserTrafficAutoWarning.php

<?php

namespace App\Console\Commands;

use App\Components\Helpers;
use Illuminate\Console\Command;
use App\Http\Models\User;
use App\Mail\userTrafficWarning;
use Mail;
use Log;

class UserTrafficAutoWarning extends Command
{
    protected $signature = 'userTrafficAutoWarning';
    protected $description = '用户流量超过警告阈值自动发邮件提醒';
    protected static $systemConfig;

    public function __construct()
    {
        parent::__construct();
        self::$systemConfig = Helpers::systemConfig();
    }

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

        // 用户流量超过警告阈值自动发邮件提醒
        if (self::$systemConfig['traffic_warning']) {
            $this->userTrafficWarning();
        }

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

        Log::info('执行定时任务【' . $this->description . '】，耗时' . $jobUsedTime . '秒');
    }

    // 用户流量超过警告阈值自动发邮件提醒
    private function userTrafficWarning()
    {
        $userList = User::query()->where('status', '>=', 0)->where('enable', 1)->where('transfer_enable', '>', 0)->get();
        foreach ($userList as $user) {
            // 用户名不是邮箱的跳过
            if (false === filter_var($user->username, FILTER_VALIDATE_EMAIL)) {
                continue;
            }

            $usedPercent = round(($user->d + $user->u) / $user->transfer_enable, 2) * 100; // 已使用流量百分比
            if ($usedPercent >= self::$systemConfig['traffic_warning_percent']) {
                $title = '流量提醒';
                $content = '流量已使用：' . $usedPercent . '%，请保持关注。';

                $logId = Helpers::addEmailLog($user->username, $title, $content);
                Mail::to($user->username)->send(new userTrafficWarning($logId, $usedPercent));
            }
        }
    }
}