neiyou_user_web/app/Console/Commands/DailyJob.php

<?php

namespace App\Console\Commands;

use App\Components\Helpers;
use App\Models\Order;
use App\Models\Ticket;
use App\Models\User;
use App\Services\OrderService;
use Illuminate\Console\Command;
use Log;

class DailyJob extends Command
{
    protected $signature = 'dailyJob';
    protected $description = '每日任务';

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

        // 过期用户处理
        $this->expireUser();

        // 关闭超过72小时未处理的工单
        $this->closeTickets();

        // 重置用户流量
        if (sysConfig('reset_traffic')) {
            $this->resetUserTraffic();
        }

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

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

    private function expireUser(): void
    {
        // 过期用户处理
        $isBanStatus = sysConfig('is_ban_status');
        User::activeUser()
            ->where('expired_at', '<', date('Y-m-d H:i:s'))
            ->chunk(100, function ($userList) use ($isBanStatus) {
                foreach ($userList as $user) {
                    if ($isBanStatus) {
                        $user->update([
                            'u'               => 0,
                            'd'               => 0,
                            'transfer_enable' => 0,
                            'enable'          => 0,
                            'level'           => 0,
                            'reset_time'      => null,
                            'ban_time'        => null,
                            'status'          => -1,
                        ]);

                        Helpers::addUserBanLog($user->id, 0, '【禁止登录，清空账户】-账号已过期');

                        // 废除其名下邀请码
                        $user->invites()->whereStatus(0)->update(['status' => 2]);

                        // 写入用户流量变动记录
                        Helpers::addUserTrafficModifyLog($user->id, null, $user->transfer_enable, 0, '[定时任务]账号已过期(禁止登录，清空账户)');
                    } else {
                        $user->update([
                            'u'               => 0,
                            'd'               => 0,
                            'transfer_enable' => 0,
                            'enable'          => 0,
                            'level'           => 0,
                            'reset_time'      => null,
                            'ban_time'        => null,
                        ]);

                        Helpers::addUserBanLog($user->id, 0, '【封禁代理，清空账户】-账号已过期');

                        // 写入用户流量变动记录
                        Helpers::addUserTrafficModifyLog($user->id, null, $user->transfer_enable, 0, '[定时任务]账号已过期(封禁代理，清空账户)');
                    }
                }
            });
    }

    // 关闭超过72小时未处理的工单
    private function closeTickets(): void
    {
        foreach (Ticket::where('updated_at', '<=', date('Y-m-d', strtotime('-3 days')))->whereStatus(1)->get() as $ticket) {
            if ($ticket->close()) {
                //$ticket->user->notify(new TicketClosed($ticket->id, $ticket->title, route('replyTicket', ['id' => $ticket->id]), __('You have not responded this ticket in :num hours, System has auto closed your ticket.', ['num' => '72'])));
            }
        }
    }

    // 重置用户流量
    private function resetUserTraffic(): void
    {
        User::where('status', '<>', -1)
            ->where('expired_at', '>', date('Y-m-d H:i:s'))
            ->where('reset_time', '<=', date('Y-m-d H:i:s'))
            ->chunk(100, function ($userList) {
                foreach ($userList as $user) {
                    // 跳过没有重置日期的账号
                    if (!$user->reset_time) {
                        continue;
                    }

                    // 取出用户正在使用的套餐
                    $order = Order::userActivePlan($user->id)->first();

                    // 无订单用户跳过
                    if (!$order) {
                        continue;
                    }

                    // 过期生效中的加油包
                    Order::userActivePackage($user->id)->update(['is_expire' => 1]);

                    $oldData = $user->transfer_enable;
                    // 重置流量与重置日期
                    $ret = $user->update((new OrderService($order))->resetTimeAndData($user->expired_at));
                    if ($ret) {
                        // 可用流量变动日志
                        Helpers::addUserTrafficModifyLog($order->user_id, $order->id, $oldData, $user->transfer_enable, '【流量重置】重置可用流量');
                        // 单独输出每个用户的重置日志
                        Log::info('【流量重置】用户[ID：'.$user->id.'  昵称： '.$user->username.'  邮箱： '.$user->email.'] 流量重置为 '.flowAutoShow($user->transfer_enable).'. 重置日期为 '.($user->reset_time ?: '【无】'));
                    } else {
                        Log::warning('【流量重置失败】用户[ID：'.$user->id.'  昵称： '.$user->username.'  邮箱： '.$user->email.']');
                    }
                }
            });
    }
}