From 8e9f2f6925530be0e9f63d0a7205a98f8e6dae47 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期二, 24 五月 2022 13:03:47 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/service/impl/ApiLogServiceImpl.java | 5 +++++
src/main/java/com/zy/asrs/mapper/ApiLogMapper.java | 2 ++
src/main/java/com/zy/asrs/service/ApiLogService.java | 2 ++
src/main/java/com/zy/asrs/task/OrderSyncScheduler.java | 12 ++++++++++++
src/main/resources/mapper/ApiLogMapper.xml | 6 ++++++
5 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ApiLogMapper.java b/src/main/java/com/zy/asrs/mapper/ApiLogMapper.java
index 7f9c418..a520922 100644
--- a/src/main/java/com/zy/asrs/mapper/ApiLogMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ApiLogMapper.java
@@ -9,4 +9,6 @@
@Repository
public interface ApiLogMapper extends BaseMapper<ApiLog> {
+ int clearWeekBefore();
+
}
diff --git a/src/main/java/com/zy/asrs/service/ApiLogService.java b/src/main/java/com/zy/asrs/service/ApiLogService.java
index aa01c8f..43e45d5 100644
--- a/src/main/java/com/zy/asrs/service/ApiLogService.java
+++ b/src/main/java/com/zy/asrs/service/ApiLogService.java
@@ -7,4 +7,6 @@
void save(String namespace, String url, String appkey, String ip, String request, String response, boolean success);
+ boolean clearWeekBefore();
+
}
diff --git a/src/main/java/com/zy/asrs/service/impl/ApiLogServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/ApiLogServiceImpl.java
index 607eeba..30a725f 100644
--- a/src/main/java/com/zy/asrs/service/impl/ApiLogServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/ApiLogServiceImpl.java
@@ -43,4 +43,9 @@
log.error("鎺ュ彛璋冪敤鏃ュ織淇濆瓨澶辫触锛�");
}
}
+
+ @Override
+ public boolean clearWeekBefore() {
+ return this.baseMapper.clearWeekBefore() > 0;
+ }
}
diff --git a/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java b/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
index 4631099..c09acce 100644
--- a/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
+++ b/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.zy.asrs.entity.Order;
+import com.zy.asrs.service.ApiLogService;
import com.zy.asrs.service.OrderService;
import com.zy.asrs.task.core.ReturnT;
import com.zy.asrs.task.handler.OrderSyncHandler;
@@ -24,6 +25,17 @@
private OrderSyncHandler orderSyncHandler;
@Autowired
private OrderService orderService;
+ @Autowired
+ private ApiLogService apiLogService;
+
+ @Scheduled(cron = "0 0 1 * * ? ")
+ public void clearApiLog(){
+ try {
+ apiLogService.clearWeekBefore();
+ } catch (Exception e) {
+ log.error("绗笁鏂规帴鍙ｆ棩蹇楄嚜鍔ㄦ竻闄ゅけ璐ワ紙鑼冨洿锛氫竴鍛ㄤ箣鍓�", e);
+ }
+ }
@Scheduled(cron = "0/5 * * * * ? ")
@Async("orderThreadPool")
diff --git a/src/main/resources/mapper/ApiLogMapper.xml b/src/main/resources/mapper/ApiLogMapper.xml
index ce84aac..44ed714 100644
--- a/src/main/resources/mapper/ApiLogMapper.xml
+++ b/src/main/resources/mapper/ApiLogMapper.xml
@@ -22,4 +22,10 @@
</resultMap>
+ <delete id="clearWeekBefore">
+ delete from man_api_log
+ where 1=1
+ and datediff(week,create_time,getdate()) >= 1
+ </delete>
+
</mapper>
--
Gitblit v1.9.1