neiyou_user_web/app/Console/Commands/UserTrafficAutoWarning.php

<?php

namespace App\Console\Commands;

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

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

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

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

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

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

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

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

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