qimall/console/controllers/ClearCrontabController.php

<?php
/**
 * ClearCrontabController每日清理多余的定时任务数据
 */
namespace console\controllers;

use addons\UserGift\common\enums\GiftEnum;
use addons\UserGift\common\listeners\UserGiftListener;
use common\enums\RabbitMqEnum;
use common\models\common\CrontabTaskExecute;
use common\models\user\UserExtra;
use yii\console\Controller;
use yii\console\ExitCode;

class ClearCrontabController extends Controller
{
    /**
     * 每日凌晨1点清理一个月前的所有定时任务记录
     * 0 0 1 * * * *
     * @Author: lun
     * @DateTime: 2021/11/17 0017 20:38
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return int
     */
    public function actionExecute(){
        try {
            $time = strtotime("-1 month");// 一个月前的时间戳
            CrontabTaskExecute::deleteAll(['and' ,['exec_process' => CrontabTaskExecute::PROCESS_FINISH], ['<=', 'created_at', $time]]);
            echo 'success';
            return ExitCode::OK;
        } catch (\Exception $e) {
            echo $e->getMessage();
             $this->stderr('Error: ' . ExitCode::getReason(ExitCode::UNSPECIFIED_ERROR));
            return ExitCode::UNSPECIFIED_ERROR;
        }
    }
}