计划任务的执行时间和频率放到数据库中，实现自动化

<?php

namespace App\Console;

use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;

class Kernel extends ConsoleKernel
{
    protected function schedule(Schedule $schedule)
    {
        // $schedule->command('inspire')->hourly();
        $schedule->call(function(){
           $now = \Carbon\Carbon::now();
           $nowStr = $now->toDateTimeString();
           \App\Models\AutoSendReport::where('开始日期', '<=', $nowStr)
            ->where('结束日期', '>=', $nowStr)
            ->get()
            ->map(function($plan)use($now){
                $shouldSend = false;
                switch ($plan->频率) {
                    case '每天':
                        // 每天上午 10 点发送
                        $shouldSend = true;
                        break;

                    case '每周':
                        // 每周一发送
                        $shouldSend = $now->isMonday();
                        break;

                    case '每月':
                        // 每月第一天发送
                        $shouldSend = $now->day == 1;
                        break;
                }
                if($shouldSend){
                    \Mail::to($plan['收件人邮箱'], $plan['收件人姓名'])->send(new \Illuminate\Mail\Mailable());
                }
            });
        })
        ->timezone('Asia/Shanghai')
        // 每天上午 10 点执行一次
        ->dailyAt('10:00');
    }
}Copy