From 718f604deb342b0bee6c588bb44e22ced3371fb8 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期六, 26 六月 2021 11:20:51 +0800
Subject: [PATCH] 1.删除sap的2天前的日志
---
src/main/java/com/slcf/filter/UpdateThread.java | 2 ++
src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java | 5 +++++
src/main/java/com/slcf/dao/SapRequestLogDao.java | 3 +++
src/main/java/com/slcf/service/SapRequestLogService.java | 2 ++
src/main/resources/mapper/SapRequestLogMapper.xml | 8 +++++++-
5 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/slcf/dao/SapRequestLogDao.java b/src/main/java/com/slcf/dao/SapRequestLogDao.java
index caa7521..bb3e69b 100644
--- a/src/main/java/com/slcf/dao/SapRequestLogDao.java
+++ b/src/main/java/com/slcf/dao/SapRequestLogDao.java
@@ -16,4 +16,7 @@
// 鏂板sap璇锋眰鏃ュ織
public Integer addSapLog(@Param("matnr") String matnr, @Param("request") String request, @Param("response") String response, @Param("create_time") Date create_time, @Param("type") Integer type, @Param("remark") String remark);
+
+ // 鍒犻櫎sap鐨�2澶╁墠鐨勬棩蹇楀唴瀹�
+ public Integer clearSapLog();
}
diff --git a/src/main/java/com/slcf/filter/UpdateThread.java b/src/main/java/com/slcf/filter/UpdateThread.java
index 0aa93d5..6debabb 100644
--- a/src/main/java/com/slcf/filter/UpdateThread.java
+++ b/src/main/java/com/slcf/filter/UpdateThread.java
@@ -76,6 +76,8 @@
updateWaitPakInData(); // 鍏ュ簱
sendPickPrintCmd(); // 鎵撳嵃
updateWaitPakOutData(); // 鍑哄簱
+ // 娓呯┖2澶╁墠鐨勬棩蹇�
+ sapRequestLogService.clearSapLog();
// updateWaitCheckData();
Thread.sleep(5000);
} catch (InterruptedException e) {
diff --git a/src/main/java/com/slcf/service/SapRequestLogService.java b/src/main/java/com/slcf/service/SapRequestLogService.java
index a43a20e..952e2d7 100644
--- a/src/main/java/com/slcf/service/SapRequestLogService.java
+++ b/src/main/java/com/slcf/service/SapRequestLogService.java
@@ -13,4 +13,6 @@
public List<SapRequestLogBean> querySapLog(String condition);
public Integer addSapLog(SapRequestLogBean param);
+
+ public Integer clearSapLog();
}
diff --git a/src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java b/src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java
index 9197bc8..fb34107 100644
--- a/src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java
+++ b/src/main/java/com/slcf/service/impl/SapRequestLogServiceImpl.java
@@ -33,4 +33,9 @@
Integer result = sapRequestLogDao.addSapLog(param.getMatnr(), param.getRequest(), param.getResponse(), param.getCreate_time(), param.getType(), param.getRemark());
return result;
}
+
+ public Integer clearSapLog() {
+ Integer result = sapRequestLogDao.clearSapLog();
+ return result;
+ }
}
diff --git a/src/main/resources/mapper/SapRequestLogMapper.xml b/src/main/resources/mapper/SapRequestLogMapper.xml
index f0669c0..0daeae2 100644
--- a/src/main/resources/mapper/SapRequestLogMapper.xml
+++ b/src/main/resources/mapper/SapRequestLogMapper.xml
@@ -14,6 +14,7 @@
<result column="type" property="type"></result>
</resultMap>
+<!-- 鏌ヨsap鏃ュ織 -->
<select id="querySapLog" resultMap="BaseResult">
SELECT * FROM sap_request_log
where 1 = 1
@@ -29,9 +30,14 @@
ORDER BY create_time desc
</select>
+<!-- 鎻掑叆sap鏃ュ織 -->
<insert id="addSapLog">
INSERT INTO sap_request_log(matnr, request, response, create_time, type, remark) VALUES (#{matnr}, #{request}, #{response}, #{create_time}, #{type}, #{remark})
</insert>
-
+<!-- 鍒犻櫎sap鐨�2澶╁墠鐨勬棩蹇楀唴瀹� -->
+<delete id="clearSapLog">
+ delete from sap_request_log where DateDiff(dd,create_time,getdate()) > 2
+</delete>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1