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]); } } } } }