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