From 608fb6f9529ce51291ef682638a5efc7dd51ac63 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期二, 18 十一月 2025 08:21:08 +0800
Subject: [PATCH] 1.完善找库位 2.新增erp订单删除后,wms订单跟着删除功能 3.新增订单完成后,上报erp,erp报错后显现在出货单中 4.新增一键查询到异常完成订单 5.对销售单据和其他单据进行区分出库 6.对中间表订单状态进行完善 7.新增锁单功能 8.新增任务查询维护加上订单号

---
 src/main/java/com/zy/common/service/CommonService.java |  165 +++++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 112 insertions(+), 53 deletions(-)

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 844b22e..4d70aee 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -97,13 +97,36 @@
      */
     @Transactional
     public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, int times) {
-        whsType = getWhsType(sourceStaNo, times);
+//        whsType = getWhsType(sourceStaNo, times);
         StartupDto startupDto = new StartupDto();
-        // 鐢熸垚宸ヤ綔鍙�
-        int workNo = getWorkNo(0);
+
+//        if (sourceStaNo < 200){
+//            whsType = 1;
+//        } else if (sourceStaNo > 199 && sourceStaNo < 300){
+//            whsType = 2;
+//        } else if (sourceStaNo > 299 && sourceStaNo < 400){
+//            whsType = 3;
+//        } else if (sourceStaNo > 399){
+//            whsType = 4;
+//        }
+        // 鐩爣鍫嗗灈鏈哄彿
+        int crnNo = 0;
+        if (sourceStaNo ==102) {
+            whsType = 3;
+            crnNo = 3;
+        }else if (sourceStaNo ==104) {
+            whsType = 2;
+            crnNo = 2;
+        }else if(sourceStaNo ==106) {
+            whsType = 1;
+            crnNo = 1;
+        }else
+            throw new CoolException("绔欑偣鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
+
+
         RowLastno rowLastno = rowLastnoService.selectById(whsType);
         if (Cools.isEmpty(rowLastno)) {
-            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
+            throw new CoolException("1鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
         }
 
         // ===============>>>> 寮�濮嬫墽琛�
@@ -112,8 +135,7 @@
         int eRow = rowLastno.geteRow();
         int crn_qty = rowLastno.getCrnQty();
         int rowCount = eRow - sRow + 1;
-        // 鐩爣鍫嗗灈鏈哄彿
-        int crnNo = 0;
+
         // 鐩爣搴撲綅
         LocMast locMast = null;
 
@@ -151,6 +173,9 @@
                     // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
                     LocMast shallowLoc = locMastService.selectById(shallowLocNo);
                     if (shallowLoc != null && shallowLoc.getLocSts().equals("O")) {
+                        if (shallowLoc.getLocType1()<locTypeDto.getLocType1()){
+                            continue;
+                        }
                         if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) {
                             locMast = shallowLoc;
                             crnNo = locMast.getCrnNo();
@@ -161,42 +186,35 @@
             }
         }
 
-        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-        if (null == locMast) {
-            Shelves shelves = new Shelves(rowCount, crn_qty);
-            if (whsType != 4) {
-                int divides = (int) Arith.divides(1, curRow - 1, 16);
-                curRow = (int) Arith.remainder(curRow, 16);
-                for (int i = 0; i < shelves.group; i ++) {
-                    curRow = shelves.start(curRow);
-                    if (curRow < 0) {
-                        throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-                    }
-                    Integer crnNo1 = shelves.get(curRow);
-                    crnNo1 = crnNo1 + divides*4;
-                    if (basCrnpService.checkSiteError(crnNo1, true)) {
-                        crnNo = crnNo1;
-                        break;
-                    }
-                }
-            } else {
-                for (int i = 0; i < shelves.group; i ++) {
-                    curRow = shelves.start(curRow);
-                    if (curRow < 0) {
-                        throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-                    }
-                    Integer crnNo1 = shelves.get(curRow);
-                    if (basCrnpService.checkSiteError(crnNo1, true)) {
-                        crnNo = crnNo1;
-                        break;
-                    }
-                }
-            }
-        }
-
-        if (crnNo == 0) {
-            throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
-        }
+//        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
+//        if (null == locMast) {
+//            if(crnNo>1) {
+//                curRow = curRow -2;
+//            }
+//            Shelves shelves = new Shelves(rowCount, crn_qty);
+//            int divides = (int) Arith.divides(1, curRow - 1, 4);
+//            curRow = (int) Arith.remainder(curRow, 4);
+//            if (curRow == 0) {
+//                curRow = 4;
+//            }
+//            for (int i = 0; i < shelves.group; i ++) {
+//                curRow = shelves.start(curRow);
+//                if (curRow < 0) {
+//                    throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+//                }
+//                if (basCrnpService.checkSiteError(crnNo, true)) {
+//                    curRow = curRow + divides*4;
+//                    break;
+//                }
+//            }
+//            if(crnNo>1) {
+//                curRow = curRow +2;
+//            }
+//        }
+//
+//        if (crnNo == 0) {
+//            throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
+//        }
         // 鑾峰彇鐩爣绔�
         Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
                 .eq("type_no", staDescId)
@@ -210,6 +228,27 @@
         BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
         if (!staNo.getAutoing().equals("Y")) {
             throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+        }
+        if(curRow==1){
+            curRow=2;
+        }else if(curRow==2){
+            curRow=1;
+        }else if(curRow==3){
+            curRow=6;
+        }else if(curRow==6){
+            curRow=3;
+        }else if(curRow==7){
+            curRow=10;
+        }else if(curRow==10){
+            curRow=7;
+        }else if(curRow==4){
+            curRow=5;
+        }else if(curRow==5){
+            curRow=4;
+        }else if(curRow==8){
+            curRow=9;
+        }else if(curRow==9){
+            curRow=8;
         }
         // 鏇存柊搴撲綅鎺掑彿
         rowLastno.setCurrentRow(curRow);
@@ -234,18 +273,20 @@
                 if (!locMastService.checkEmptyCount(locMast)) {
                     locMast = null;
                 }
-                // 鐩爣搴撲綅 ===>> 娴呭簱浣嶏紝 鍒欐牎楠屽叾娣卞簱浣嶆槸鍚︿负 F D X
-                if (null != locMast && Utils.isShallowLoc(slaveProperties, locMast.getLocNo())) {
-                    LocMast deepLoc = locMastService.selectById(Utils.getDeepLoc(slaveProperties, locMast.getLocNo()));
-                    if (!deepLoc.getLocSts().equals("F") && !deepLoc.getLocSts().equals("D") && !deepLoc.getLocSts().equals("X")) {
-                        locMast = null;
+                if(curRow >2){
+                    // 鐩爣搴撲綅 ===>> 娴呭簱浣嶏紝 鍒欐牎楠屽叾娣卞簱浣嶆槸鍚︿负 F D X
+                    if (null != locMast && Utils.isShallowLoc(slaveProperties, locMast.getLocNo())) {
+                        LocMast deepLoc = locMastService.selectById(Utils.getDeepLoc(slaveProperties, locMast.getLocNo()));
+                        if (!deepLoc.getLocSts().equals("F") && !deepLoc.getLocSts().equals("D") && !deepLoc.getLocSts().equals("X")) {
+                            locMast = null;
+                        }
                     }
-                }
-                // 鐩爣搴撲綅 ===>> 娣卞簱浣嶏紝 鍒欐牎楠屽叾娴呭簱浣嶆槸鍚︿负 O
-                if (null != locMast && Utils.isDeepLoc(slaveProperties, locMast.getLocNo())) {
-                    LocMast shallowLoc = locMastService.selectById(Utils.getShallowLoc(slaveProperties, locMast.getLocNo()));
-                    if (!shallowLoc.getLocSts().equals("O")) {
-                        locMast = null;
+                    // 鐩爣搴撲綅 ===>> 娣卞簱浣嶏紝 鍒欐牎楠屽叾娴呭簱浣嶆槸鍚︿负 O
+                    if (null != locMast && Utils.isDeepLoc(slaveProperties, locMast.getLocNo())) {
+                        LocMast shallowLoc = locMastService.selectById(Utils.getShallowLoc(slaveProperties, locMast.getLocNo()));
+                        if (!shallowLoc.getLocSts().equals("O")) {
+                            locMast = null;
+                        }
                     }
                 }
             }
@@ -257,6 +298,18 @@
             if (times < rowCount) {
                 times = times + 1;
                 return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times);
+            }else if (times == rowCount) {
+
+                LocMast locMast1 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("crn_no", crnNo)
+                        .eq("loc_sts", "O")
+                        .orderBy("lev1"));
+                if(Cools.isEmpty(locMast1)){
+                    throw new CoolException("鍫嗗灈鏈�="+crnNo+"娌℃湁绌哄簱浣�");
+                }
+                if(!locMastService.checkEmptyCount(locMast1)){
+                    throw new CoolException("鍫嗗灈鏈�="+crnNo+"娌℃湁绌哄簱浣�");
+                }
             }
 
             // 杞昏揣鐗╂壘杞诲簱浣嶄负绌烘椂锛屽彲浠ュ幓鎵鹃噸搴撲綅浠�
@@ -269,6 +322,8 @@
         }
         String locNo = locMast.getLocNo();
 
+        // 鐢熸垚宸ヤ綔鍙�
+        int workNo = getWorkNo(0);
         // 杩斿洖dto
         startupDto.setWorkNo(workNo);
         startupDto.setCrnNo(crnNo);
@@ -318,6 +373,10 @@
 //            case 223:
             case 227:
                 return 3;
+            case 305:
+            case 303:
+            case 301:
+                return 4;
             default:
                 throw new CoolException("鏍规嵁鍏ュ簱绔欒幏鍙栧簱浣嶆帓鍙峰垎閰嶅け璐ワ紝鍏ュ簱绔欙細" + sourceStaNo);
         }

--
Gitblit v1.9.1