From 7aba2103c4b3ea72e8e0fd79dc88be0e251c1c33 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期日, 12 四月 2026 16:03:02 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java b/src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java
index 7e4371e..d74cc7e 100644
--- a/src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java
@@ -14,6 +14,16 @@
@Service
public class NotifyLogHandler extends AbstractHandler<String> {
+ private static final String WAIT_PAKIN_ARCHIVE_COLUMNS =
+ "zpallet, anfme, loc_no, matnr, maktx, batch, order_no, specs, model, color, brand, unit, price, sku, units, barcode, " +
+ "origin, manu, manu_date, item_num, safe_qty, weight, man_length, volume, three_code, supp, supp_code, be_batch, dead_time, " +
+ "dead_warn, source, inspect, danger, status, io_status, modi_time, modi_user, appe_time, appe_user, memo, standby1, standby2, " +
+ "standby3, box_type1, box_type2, box_type3";
+
+ private static final String ARCHIVE_FINISHED_WAIT_PAKIN_SQL =
+ "insert into cust_wait_pakin_log (" + WAIT_PAKIN_ARCHIVE_COLUMNS + ") " +
+ "select " + WAIT_PAKIN_ARCHIVE_COLUMNS + " from cust_wait_pakin where io_status = 'F'";
+
@Autowired
private JdbcTemplate jdbcTemplate;
@@ -21,7 +31,7 @@
public ReturnT<String> start() {
try {
// 鍏ュ簱閫氱煡妗ｈ浆鍘嗗彶妗�
- int pakInLog = jdbcTemplate.update("insert into cust_wait_pakin_log select * from cust_wait_pakin where io_status = 'F';");
+ int pakInLog = jdbcTemplate.update(ARCHIVE_FINISHED_WAIT_PAKIN_SQL);
if (pakInLog > 0) {
int pakInDelete = jdbcTemplate.update("delete from cust_wait_pakin where io_status = 'F';");
if (pakInDelete <= 0) {
--
Gitblit v1.9.1