From e609c7adf42ef6eea053ff33a8e59abaf0767df6 Mon Sep 17 00:00:00 2001 From: zhangc <zc@123> Date: 星期五, 17 一月 2025 08:54:52 +0800 Subject: [PATCH] 1 --- src/main/java/com/zy/asrs/task/OrderLogScheduler.java | 2 +- src/main/java/com/zy/asrs/task/OverYearLogScheduler.java | 10 +++++++++- src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java | 15 +++++++++++++++ 3 files changed, 25 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java index 6311642..61c9047 100644 --- a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java +++ b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java @@ -23,7 +23,7 @@ // private boolean isERP; // //@Scheduled(cron = "0/10 * * * * ? ") - @Scheduled(fixedDelay = 10000) + @Scheduled(fixedDelay = 600000) private void execute(){ List<Order> orders = orderService.selectToBeHistoryOrder(); if (orders.isEmpty()) { diff --git a/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java b/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java index 39652b4..79e42a0 100644 --- a/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java +++ b/src/main/java/com/zy/asrs/task/OverYearLogScheduler.java @@ -20,11 +20,19 @@ private OverYearLogHandler overYearLogHandler; @Scheduled(cron = "0/1 * * * * ? ") - private void execute(){ + private void execute() { ReturnT<String> returnT = overYearLogHandler.start(); if (!returnT.isSuccess()) { log.error(returnT.getMsg()); } } + + @Scheduled(cron = "* * 1 * * ? ") + private void executeOrderLog() { + ReturnT<String> returnT = overYearLogHandler.start2(); + if (!returnT.isSuccess()) { + log.error(returnT.getMsg()); + } + } } diff --git a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java index 62b7596..3c099df 100644 --- a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java @@ -34,4 +34,19 @@ return SUCCESS; } + @Transactional + public ReturnT<String> start2() { + try { + // 鍒犻櫎鍗婂勾浠ヤ笂鐨勫巻鍙叉。 + jdbcTemplate.update("delete from man_order_log where dateadd(day,366,create_time) <= getdate();"); + jdbcTemplate.update("delete from man_order_detl_log where dateadd(day,366,create_time) <= getdate();"); + + } catch (Exception e) { + e.printStackTrace(); + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg(e.getMessage()); + } + return SUCCESS; + } + } -- Gitblit v1.9.1