neiyou_user_web/app/Console/Commands/UserExpireAutoWarning.php

<?php

namespace App\Console\Commands;

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

class UserExpireAutoWarning extends Command
{

    protected $signature = 'userExpireAutoWarning';
    protected $description = '用户临近到期自动发邮件提醒';

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

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

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

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

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

            // 计算剩余可用时间
            $lastCanUseDays = Helpers::daysToNow($user->expired_at);
            if ($lastCanUseDays == 0) {
                $title   = '账号过期提醒';
                $content = '您的账号将于今天晚上【24:00】过期。';

                $logId = Helpers::addNotificationLog(
                    $title,
                    $content,
                    1,
                    $user->email
                );
                Mail::to($user->email)->send(
                    new userExpireWarningToday($logId)
                );
            } elseif ($lastCanUseDays > 0 && $lastCanUseDays <= $expireDays) {
                $title   = '账号过期提醒';
                $content = '您的账号还剩' . $lastCanUseDays . '天即将过期。';

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

}