From abb9b5c51d8a20be68b64e0c4a9620f6578d2e3a Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期三, 30 四月 2025 09:59:26 +0800
Subject: [PATCH] 手动导入订单和mes下发订单,增加客户名称和备注字段

---
 src/main/java/com/zy/asrs/importexcle/ImportOrderListener.java |    9 ++++++---
 src/main/java/com/zy/asrs/importexcle/ImportOrderDto.java      |    2 +-
 src/main/webapp/static/js/order/order.js                       |    3 ++-
 src/main/java/com/zy/asrs/entity/param/ZwmsOutLocWorkDto.java  |    4 ++++
 src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java    |    7 +++++--
 src/main/webapp/views/order/order.html                         |    5 +++++
 6 files changed, 23 insertions(+), 7 deletions(-)

diff --git a/src/main/java/com/zy/asrs/entity/param/ZwmsOutLocWorkDto.java b/src/main/java/com/zy/asrs/entity/param/ZwmsOutLocWorkDto.java
index dc745f2..964e6dc 100644
--- a/src/main/java/com/zy/asrs/entity/param/ZwmsOutLocWorkDto.java
+++ b/src/main/java/com/zy/asrs/entity/param/ZwmsOutLocWorkDto.java
@@ -16,6 +16,10 @@
 
     private String orderType; // 璁㈠崟绫诲瀷
 
+    private String customerName; // 瀹㈡埛鍚嶇О
+
+    private String memo; // 璁㈠崟澶囨敞
+
     List<String> groups; // 鍖呰缁勫彿鍒楄〃
 
 //    private List<Rolls> matDetails;
diff --git a/src/main/java/com/zy/asrs/importexcle/ImportOrderDto.java b/src/main/java/com/zy/asrs/importexcle/ImportOrderDto.java
index fd0ecf5..eb46ed0 100644
--- a/src/main/java/com/zy/asrs/importexcle/ImportOrderDto.java
+++ b/src/main/java/com/zy/asrs/importexcle/ImportOrderDto.java
@@ -14,7 +14,7 @@
     @ExcelProperty(value = "鍖呰缁勫彿/婧愬簱浣�",index = 0)
     private String column1;
 
-    @ExcelProperty(value = "鍑哄簱鍗曞彿/鍗曟嵁绫诲瀷/鐩爣搴撲綅",index = 1)
+    @ExcelProperty(value = "鍑哄簱鍗曞彿/鍗曟嵁绫诲瀷/瀹㈡埛鍚嶇О/澶囨敞/鐩爣搴撲綅",index = 1)
     private String column2;
 
     @ExcelProperty(value = "鐩爣宸烽亾",index = 2)
diff --git a/src/main/java/com/zy/asrs/importexcle/ImportOrderListener.java b/src/main/java/com/zy/asrs/importexcle/ImportOrderListener.java
index 4fefeb9..3ae6405 100644
--- a/src/main/java/com/zy/asrs/importexcle/ImportOrderListener.java
+++ b/src/main/java/com/zy/asrs/importexcle/ImportOrderListener.java
@@ -4,6 +4,7 @@
 import com.alibaba.excel.event.AnalysisEventListener;
 import com.alibaba.excel.exception.ExcelAnalysisException;
 import com.alibaba.fastjson.JSON;
+import com.core.common.Cools;
 import com.core.common.DateUtils;
 import com.core.common.SnowflakeIdWorker;
 import com.zy.asrs.entity.DocType;
@@ -68,13 +69,13 @@
     public void invoke(ImportOrderDto data, AnalysisContext context) {
         log.info("瑙f瀽鍒扮 {} 鏉℃暟鎹�:{}", ++count, JSON.toJSONString(data));
         list.add(data);
-        if (context.getCurrentRowNum() == 3) {
+        if (context.getCurrentRowNum() == 5) {
             String time = DateUtils.convert(new Date(),DateUtils.yyyyMMddHHmmss_F);
-            Order order2 = orderService.selectByNo(list.get(0).getColumn2());
+            Order order2 = orderService.selectByNo(list.get(0).getColumn2()); // 璁㈠崟鍙�
             if(order2 != null) {
                 throw new ExcelAnalysisException("鍗曟嵁宸插瓨鍦紒");
             }
-            DocType docType = docTypeService.selectOrAdd(list.get(1).getColumn2(), Boolean.FALSE);
+            DocType docType = docTypeService.selectOrAdd(list.get(1).getColumn2(), Boolean.FALSE); // 璁㈠崟绫诲瀷
             if (docType == null) {
                 throw new ExcelAnalysisException("鍗曟嵁绫诲瀷閿欒锛�" + list.get(1).getColumn2());
             }
@@ -85,6 +86,8 @@
             order.setOrderNo(orderNo);
             order.setOrderTime(time);
             order.setDocType(docType.getDocId());
+            order.setCstmrName(Cools.isEmpty(list.get(2).getColumn2()) ? "" : list.get(2).getColumn2()); // 瀹㈡埛鍚嶇О
+            order.setMemo(Cools.isEmpty(list.get(3).getColumn2()) ? "" : list.get(3).getColumn2()); // 澶囨敞
             order.setSettle(1L);
             order.setStatus(1);
             order.setCreateBy(userId);
diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
index df5f418..29658dd 100644
--- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
@@ -1393,7 +1393,7 @@
                 null,    // 鍒濆绁ㄦ嵁鍙�
                 null,    // 绁ㄦ嵁鍙�
                 null,    // 瀹㈡埛缂栧彿
-                null,    // 瀹㈡埛
+                param.getCustomerName(),    // 瀹㈡埛
                 null,    // 鑱旂郴鏂瑰紡
                 null,    // 鎿嶄綔浜哄憳
                 null,    // 鍚堣閲戦
@@ -1416,7 +1416,7 @@
                 now,    // 娣诲姞鏃堕棿
                 9527L,    // 淇敼浜哄憳
                 now,    // 淇敼鏃堕棿
-                null    // 澶囨敞
+                param.getMemo()    // 澶囨敞
         );
 
         if (!orderService.insert(order)) {
@@ -1982,6 +1982,9 @@
 
         // 鏍规嵁鎵樼洏鐮佽幏鍙栦换鍔′富妗�
         WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("barcode", barcode));
+        if (wrkMast == null) {
+            return R.parse("璇ユ潯鐮佹棤姝e湪鎵ц浠诲姟锛�" + barcode);
+        }
         // 鏍规嵁浠诲姟涓绘。鑾峰彇宸ヤ綔妗f槑缁�
         List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo()));
         // 鎻愬彇鍖呰缁勫彿
diff --git a/src/main/webapp/static/js/order/order.js b/src/main/webapp/static/js/order/order.js
index 8ff12fe..39429d6 100644
--- a/src/main/webapp/static/js/order/order.js
+++ b/src/main/webapp/static/js/order/order.js
@@ -55,7 +55,8 @@
             {align: 'center', title: '鏄庣粏', toolbar: '#tbLook', minWidth: 160, width: 160},
             {field: 'createTime$', title: '鍒涘缓鏃堕棿', minWidth: 200, width: 200},
             {field: 'settle$', align: 'center', title: '鐘舵��', templet: '#settleTpl',  minWidth: 160, width: 160},
-            {field: 'memo', align: 'center',title: '澶囨敞', hide: true},
+            {field: 'cstmrName', align: 'center',title: '瀹㈡埛鍚嶇О'},
+            {field: 'memo', align: 'center',title: '澶囨敞'},
             {align: 'center', title: '鎿嶄綔', toolbar: '#operate', width: 240}
         ]],
         request: {
diff --git a/src/main/webapp/views/order/order.html b/src/main/webapp/views/order/order.html
index 49cbd8b..4a13f1a 100644
--- a/src/main/webapp/views/order/order.html
+++ b/src/main/webapp/views/order/order.html
@@ -54,6 +54,11 @@
                             <input name="order_no" class="layui-input" type="text" placeholder="杈撳叆鍗曟嵁缂栧彿"/>
                         </div>
                     </div>
+                    <div class="layui-inline">
+                        <div class="layui-input-inline mr0">
+                            <input name="cstmr_name" class="layui-input" type="text" placeholder="璇疯緭鍏ュ鎴峰悕绉�"/>
+                        </div>
+                    </div>
                     <div class="layui-inline" style="width: 300px">
                         <div class="layui-input-inline">
                             <input class="layui-input layui-laydate-range" name="create_time" type="text" placeholder="璧峰鏃堕棿 - 缁堟鏃堕棿" autocomplete="off" style="width: 300px">

--
Gitblit v1.9.1