1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- <?php
- namespace App\Console\Commands;
- use App\Components\Helpers;
- use Illuminate\Console\Command;
- use App\Http\Models\Order;
- use App\Http\Models\User;
- 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]);
- }
- }
- }
- }
- }
|