From 1443d5a84a4df99d9a86ac04c904554e91ae8271 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期日, 12 四月 2026 15:35:06 +0800
Subject: [PATCH] 1.针对7.3接口文档，新增了几个字段需要加入到组托档中，不额外加字段 2.针对7.11接口文档，对outOrder方法进行重写，batchSeq在wrkMast表中新增一个字段放，entryWmsCode、outDoorNo这两个在wrkDetl中找两个字段存放 3.针对7.7接口文档，上报时加上orderId出库单号 4.针对7.9接口文档，wcs会先请求wms，只需要palletId托盘码，errorMsg错误信息；wms转发给加上orderId出库单号转发给ERP 5.针对7.10接口文档，ERP先按照这个文档发给wms，wms再发给wcs，发给wcs这块先不写
---
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