【商業版】 v2.0 自動刪除歷史日志修復-CRMEB社區

【商業版】 v2.0 自動刪除歷史日志修復

管理

編輯

刪除

在AutoDeleteLogTask類中
將

@Autowired

private ScheduleJobService scheduleJobService;
修改為

@Autowired

private ScheduleJobLogService scheduleJobLogService;

將
scheduleJobService.autoDeleteLog();
修改為
scheduleJobLogService.autoDeleteLog();

在ScheduleJobService類添加方法

/**

自動刪除日志

void autoDeleteLog();
在ScheduleJobServiceImpl類添加

/**

自動刪除日志

@Override

public void autoDeleteLog() {

String beforeDate = DateUtil.offsetDay(new Date(), -9).toString("yyyy-MM-dd");

UpdateWrapper wrapper = Wrappers.update();

wrapper.lt("create_time", beforeDate);

dao.delete(wrapper);

}

示例圖如下：

attachmentId-11101

attachmentId-11102

attachmentId-11103

訂單任務表（帶數據）sql：

-- Table structure for eb_schedule_job

DROP TABLE IF EXISTS eb_schedule_job?;

CREATE TABLE eb_schedule_job? (

?job_id? int(11) NOT NULL AUTO_INCREMENT COMMENT '任務id',

?bean_name? varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'spring bean名稱',

?method_name? varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法名',

?params? varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '參數',

?cron_expression? varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'cron表達式',

?status? tinyint(4) NULL DEFAULT NULL COMMENT '任務狀態 0：正常 1：暫停',

?remark? varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '備注',

?is_delte? tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否刪除',

?create_time? timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間',

PRIMARY KEY (job_id?) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定時任務' ROW_FORMAT = Dynamic;

-- Records of eb_schedule_job

INSERT INTO eb_schedule_job? VALUES (1, 'BargainStopChangeTask', 'bargainStopChange', '', '0 0 0 */1 * ?', 0, '砍價活動結束狀態變化', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (2, 'BrokerageFrozenTask', 'brokerageFrozen', '', '0 0 */1 * * ?', 0, '傭金凍結期解凍處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (3, 'CouponOverdueTask', 'couponOverdue', '', '0 */1 * * * ?', 0, '優惠券過期處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (4, 'IntegralFrozenTask', 'integralFrozen', '', '0 */1 * * * ?', 0, '積分凍結期解凍處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (5, 'OrderAutoCancelTask', 'autoCancel', '', '0 */1 * * * ?', 0, '系統自動取消未支付訂單', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (6, 'OrderAutoCompleteTask', 'autoComplete', '', '0 0 */1 * * ?', 0, '訂單自動完成處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (7, 'OrderCancelTask', 'userCancel', '', '0 */1 * * * ?', 0, '用戶取消訂單處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (8, 'OrderCompleteTask', 'orderComplete', '', '0 */1 * * * ?', 0, '用戶訂單完成處理', 0, '2021-12-01 10:55:06');

INSERT INTO eb_schedule_job? VALUES (9, 'OrderPaySuccessTask', 'orderPayAfter', '', '0 */1 * * * ?', 0, '訂單支付成功后置處理', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (10, 'OrderReceiptTask', 'orderReceipt', '', '0 */1 * * * ?', 0, '用戶確認收貨后置處理', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (11, 'OrderRefundTask', 'orderRefund', '', '0 */1 * * * ?', 0, '訂單退款處理', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (12, 'AutoUpdateCatTask', 'autoUpdateCat', '', '0 0 1 * * ?', 0, '自動更新自定義交易組件類目', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (13, 'PinkStatusChangeTask', 'pinkStatusChage', '', '0 */1 * * * ?', 0, '拼團狀態變化處理', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (14, 'ProductStockTask', 'stockOperation', '', '0 */1 * * * ?', 0, '操作商品庫存', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (15, 'StatisticsTask', 'statistics', '', '0 0 0 */1 * ?', 0, '統計定時任務', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (16, 'AsyncWeChatProgramTempMessage', 'init', '', '0 */1 * * * ?', 0, '小程序消費隊列消費', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (17, 'AsyncWeChatPublicTempMessage', 'init', '', '0 */1 * * * ?', 0, '公眾號消費隊列消費', 0, '2021-12-01 10:55:07');

INSERT INTO eb_schedule_job? VALUES (18, 'AutoDeleteLogTask', 'autoDeleteLog', '', '0 0 0 */1 * ?', 0, '自動刪除不需要的歷史日志', 0, '2022-01-05 15:03:18');

附件的后綴可改為.sql