neiyou_user_web/app/Console/Commands/UserExpireAutoWarning.php

<?php

namespace App\Console\Commands;

use App\Components\Helpers;
use Illuminate\Console\Command;
use App\Http\Models\User;
use App\Mail\userExpireWarning;
use App\Mail\userExpireWarningToday;
use Mail;
use Log;

class UserExpireAutoWarning extends Command
{
    protected $signature = 'userExpireAutoWarning';
    protected $description = '用户临近到期自动发邮件提醒';
    protected static $systemConfig;

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

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

        // 用户临近到期自动发邮件提醒
        if (self::$systemConfig['expire_warning']) {
            $this->userExpireWarning();
        }

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

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

    private function userExpireWarning()
    {
        // 只取SSR没被禁用的用户，其他不用管
        $userList = User::query()->where('enable', 1)->get();
        foreach ($userList as $user) {
            // 用户名不是邮箱的跳过
            if (false === filter_var($user->username, FILTER_VALIDATE_EMAIL)) {
                continue;
            }

            // 计算剩余可用时间
            $lastCanUseDays = ceil(round(strtotime($user->expire_time) - strtotime(date('Y-m-d H:i:s'))) / 3600 / 24);
            if ($lastCanUseDays == 0) {
                $title = '账号过期提醒';
                $content = '您的账号将于今天晚上【24:00】过期。';

                $logId = Helpers::addEmailLog($user->username, $title, $content);
                Mail::to($user->username)->send(new userExpireWarningToday($logId));
            } elseif ($lastCanUseDays > 0 && $lastCanUseDays <= self::$systemConfig['expire_days']) {
                $title = '账号过期提醒';
                $content = '您的账号还剩' . $lastCanUseDays . '天即将过期。';

                $logId = Helpers::addEmailLog($user->username, $title, $content);
                Mail::to($user->username)->send(new userExpireWarning($logId, $lastCanUseDays));
            }
        }
    }
}