neiyou_user_web/app/Console/Commands/AutoResetUserTraffic.php

<?php

namespace App\Console\Commands;

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

class AutoResetUserTraffic extends Command
{
	protected $signature = 'autoResetUserTraffic';
	protected $description = '自动重置用户可用流量';
	protected static $systemConfig;

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

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

		// 重置用户流量
		if(self::$systemConfig['reset_traffic']){
			$this->resetUserTraffic();
		}

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

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

	// 重置用户流量
	private function resetUserTraffic()
	{
		$userList = User::query()->where('status', '>=', 0)->where('expire_time', '>=', date('Y-m-d'))->get();
		if(!$userList->isEmpty()){
			foreach($userList as $user){
				if(!$user->traffic_reset_day){
					continue;
				}

				// 取出用户购买的有效套餐
				$order = Order::query()
					->with(['user', 'goods'])
					->whereHas('goods', function($q){
						$q->where('type', 2);
					})
					->where('user_id', $user->id)
					->where('is_expire', 0)
					->orderBy('oid', 'desc')
					->first();

				if(!$order){
					continue;
				}

				$month = date('m');
				$today = date('d');
				$last_day = date('t');
				$resetDay = $order->user->traffic_reset_day;
				if($resetDay == $today || ($today == $last_day && $resetDay > $last_day)){
					// 跳过本月，防止异常重置
					if($month == date('m', strtotime($order->expire_at))){
						continue;
					}elseif($month == date('m', strtotime($order->created_at))){
						continue;
					}
					// 重置流量
					User::query()->where('id', $user->id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => $order->goods->traffic*1048576]);
				}
			}
		}
	}
}