From 6e042d7f0e1982cf54deedba6fe4ddfe8353af13 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期四, 27 六月 2024 09:37:11 +0800
Subject: [PATCH] 自动清空agv空库位库存
---
src/main/java/com/zy/asrs/task/ErrorStockScheduler.java | 8 ++++++++
src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java | 12 ++++++++++++
2 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java b/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java
index deb20bf..6961994 100644
--- a/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java
+++ b/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java
@@ -28,6 +28,14 @@
}
}
+ @Scheduled(cron = "0/60 * * * * ? ")
+ private void executeAgv(){
+ ReturnT<String> returnT = errorStockHandler.startAgv();
+ if (!returnT.isSuccess()) {
+ log.error(returnT.getMsg());
+ }
+ }
+
// @Autowired
// private BasErrLogService basErrLogService;
// @Autowired
diff --git a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
index 77cfa9e..8f49780 100644
--- a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
@@ -34,4 +34,16 @@
return SUCCESS;
}
+ public ReturnT<String> startAgv() {
+ try {
+ int update = jdbcTemplate.update("DELETE agv_loc_detl FROM agv_loc_detl JOIN agv_loc_mast ON agv_loc_detl.loc_no = agv_loc_mast.loc_no WHERE agv_loc_mast.loc_sts = 'O'");
+// log.info("(ErrorStockHandler)鍒犻櫎鏉℃暟涓猴紱" + update);
+ } catch (Exception e) {
+ e.printStackTrace();
+ TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+ return FAIL.setMsg(e.getMessage());
+ }
+ return SUCCESS;
+ }
+
}
--
Gitblit v1.9.1