neiyou_user_web/app/Console/Commands/ServiceTimer.php

<?php

namespace App\Console\Commands;

use App\Components\Helpers;
use App\Models\Order;
use Illuminate\Console\Command;
use Log;

class ServiceTimer extends Command {
	protected $signature = 'serviceTimer';
	protected $description = '服务计时器';

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

		// 扣减用户到期商品的流量
		$this->decGoodsTraffic();

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

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

	// 扣减用户到期商品的流量
	private function decGoodsTraffic(): void {
		//获取失效的套餐
		$orders = Order::activePlan()->where('expired_at', '<=', date('Y-m-d H:i:s'))->get();
		foreach($orders as $order){
			// 清理全部流量,重置重置日期和等级 TODO 可用流量变动日志加入至UserObserver
			$user = $order->user;
			$user->update([
				'u'               => 0,
				'd'               => 0,
				'transfer_enable' => 0,
				'reset_time'      => null,
				'level'           => 0
			]);
			Helpers::addUserTrafficModifyLog($user->id, $order->id, $user->transfer_enable, 0,
				'[定时任务]用户所购商品到期，扣减商品对应的流量');

			// 过期本订单
			$order->update(['is_expire' => 1]);
		}
	}
}