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