From 07c572bea979dbd3ee46ec24083cb1bdcc014e3a Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期五, 05 七月 2024 13:56:50 +0800
Subject: [PATCH] 一期找库位方法修改

---
 src/main/java/com/zy/common/service/CommonService.java |  266 ++++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 234 insertions(+), 32 deletions(-)

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 6df78ab..6995422 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -7,6 +7,7 @@
 import com.core.common.Cools;
 import com.core.exception.CoolException;
 import com.zy.asrs.entity.*;
+import com.zy.asrs.mapper.LocMastMapper;
 import com.zy.asrs.service.*;
 import com.zy.asrs.utils.Utils;
 import com.zy.asrs.utils.VersionUtils;
@@ -47,9 +48,12 @@
     @Autowired
     private SlaveProperties slaveProperties;
 
+    @Autowired
+    private LocMastMapper locMastMapper;
+
     /**
      * 鐢熸垚宸ヤ綔鍙�
-     * @param wrkMk 0:鍏ュ嚭搴� ; 1:鍏朵粬
+     * @param wrkMk 0:鍏ュ簱 ; 1:鍑哄簱锛�2鎷i��
      * @return workNo(宸ヤ綔鍙�)
      */
     public int getWorkNo(Integer wrkMk) {
@@ -59,7 +63,7 @@
         }
         int workNo = 0;
         // 鍏ュ嚭搴撶被鍨�
-        if (wrkLastno.getWrkMk() == 0) {
+        if (wrkLastno.getWrkMk() == 0 || wrkLastno.getWrkMk() == 1 || wrkLastno.getWrkMk() == 2) {
             workNo = wrkLastno.getWrkNo();
             int sNo = wrkLastno.getSNo();
             int eNo = wrkLastno.getENo();
@@ -105,12 +109,19 @@
     public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, boolean emptyMk, List<String> matNos, LocTypeDto locTypeDto, LocTypeDto oldLocType, int times) {
         StartupDto startupDto = new StartupDto();
         // 鐢熸垚宸ヤ綔鍙�
+        int crnNo = 0;
+        if (sourceStaNo < 200) {
+            whsType = 1;
+            crnNo=1;
+        } else if (sourceStaNo < 300) {
+            whsType = 2;
+            crnNo=2;
+        }else {
+            whsType = 3;
+            crnNo=3;
+        }
+
         int workNo = getWorkNo(0);
-//        if (locTypeDto.getLocType3() == 1) { // 杞昏揣淇″彿
-//            whsType = 2;    // 5 - 12 杞讳粨
-//        } else if (locTypeDto.getLocType3() == 2) { // 閲嶈揣淇″彿
-//            whsType = 1;    // 1 - 4 閲嶄粨
-//        }
         RowLastno rowLastno = rowLastnoService.selectById(whsType);
         if (Cools.isEmpty(rowLastno)) {
             throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
@@ -121,12 +132,12 @@
         int crn_qty = rowLastno.getCrnQty();     // 鍫嗗灈鏈烘暟閲忥紙宸烽亾鏁伴噺锛�
         int rowCount = eRow - sRow + 1;          // 搴撴帓鎬绘暟
         // 鐩爣鍫嗗灈鏈哄彿
-        int crnNo = 0;
+//        int crnNo = 0;
         // 鐩爣搴撲綅
         LocMast locMast = null;
 
         // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
-        if (!Cools.isEmpty(matNos)) {
+        if (!Cools.isEmpty(matNos) && sourceStaNo < 200) {
             List<String> locNos = locDetlService.getSameDetlToday(matNos.get(0), sRow, eRow);
             for (String locNo : locNos) {
                 if (Utils.isShallowLoc(slaveProperties, locNo)) {
@@ -153,7 +164,14 @@
         }
         // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
         if (emptyMk) {
-            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow));
+//            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow));
+            List<LocMast> locMasts = null;
+            if(crnNo==1) {
+                locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").eq("row1", 1));
+            } else {
+                locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow));
+            }
+
             if (locMasts.size() > 0) {
                 for (LocMast loc : locMasts) {
                     if (Utils.isShallowLoc(slaveProperties, loc.getLocNo())) {
@@ -180,35 +198,41 @@
         // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
         if (null == locMast) {
             Shelves shelves = new Shelves(rowCount, crn_qty);
-            // 閲嶅簱浣� 1 - 4鎺�
             if (whsType == 1) {
-                for (int i = 0; i < shelves.group; i ++) {
-                    curRow = shelves.start(curRow);
-                    if (curRow < 0) {
-                        throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-                    }
-                    Integer crnNo1 = shelves.getCrnNo(curRow);
-                    if (basCrnpService.checkSiteError(crnNo1, true)) {
-                        crnNo = crnNo1;
-                        break;
-                    }
+                curRow = curRow + 1;
+                if (curRow > eRow) {
+                    curRow = sRow;
                 }
-//                // 杞诲簱浣� 5 - 12鎺�
-//            } else {
-//                curRow = curRow - 4;
+                crnNo = whsType;
+                basCrnpService.checkSiteStatus(crnNo, true);
 //                for (int i = 0; i < shelves.group; i ++) {
 //                    curRow = shelves.start(curRow);
 //                    if (curRow < 0) {
 //                        throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
 //                    }
 //                    Integer crnNo1 = shelves.getCrnNo(curRow);
-//                    if (basCrnpService.checkSiteError(crnNo1 + 1, true)) {
-//                        // 鍋忕Щ閲忚ˉ鍋�
-//                        curRow = curRow + 4;
-//                        crnNo = crnNo1 + 1;
+//                    if (basCrnpService.checkSiteError(crnNo1, true)) {
+//                        crnNo = crnNo1;
+//                        if (curRow == 3 || curRow == 4) {
+//                            curRow = 3;
+//                        }
 //                        break;
 //                    }
 //                }
+            } else if (whsType == 2) {
+                if (curRow == sRow) {
+                    curRow = eRow;
+                } else {
+                    curRow = sRow;
+                }
+                basCrnpService.checkSiteStatus(crnNo, true);
+            }else {
+                if (curRow == sRow) {
+                    curRow = eRow;
+                } else {
+                    curRow = sRow;
+                }
+                basCrnpService.checkSiteStatus(crnNo, true);
             }
         }
 
@@ -241,15 +265,38 @@
         // 1.褰撴绱㈠簱鎺掍负娴呭簱浣嶆帓鏃讹紝浼樺厛瀵绘壘褰撳墠搴撴帓鐨勬繁搴撲綅鎺�
         if (locMast == null) {
             if (Utils.isShallowLoc(slaveProperties, curRow)) {
-                Integer deepRow = Utils.getDeepRow(slaveProperties, curRow);
-                locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                Integer deepRow = 0;
+                if(curRow == 2) {
+                    deepRow = Utils.getDeepRow(slaveProperties, curRow);
+                } else {
+                    deepRow = curRow;
+                }
+
+                if(emptyMk){
+                    locMast = locMastService.queryFreeLocMastIncludeFirst(deepRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                    if (Cools.isEmpty(locMast)){
+                        locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                    }
+                } else {
+                    locMast = locMastService.queryFreeLocMastExceptFirst(deepRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                }
+
+//                locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
                 // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
                 if (!locMastService.checkEmptyCount(locMast)) {
                     locMast = null;
                 }
             }
             if (Cools.isEmpty(locMast)) {
-                locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                if(emptyMk){
+                    locMast = locMastService.queryFreeLocMastIncludeFirst(curRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                    if (Cools.isEmpty(locMast)){
+                        locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                    }
+                } else {
+                    locMast = locMastService.queryFreeLocMastExceptFirst(curRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
+                }
+//                locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1(), locTypeDto.getLocType2(), locTypeDto.getLocType3());
                 // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
                 if (!locMastService.checkEmptyCount(locMast)) {
                     locMast = null;
@@ -426,6 +473,7 @@
 //        startupDto.setLocNo(locNo);
 //        return startupDto;
 //    }
+//鍑烘繁搴撲綅鎵樼洏
 
     public static void main(String[] args) {
         System.out.println(Arith.remainder(1, 4));
@@ -461,4 +509,158 @@
         }
     }
 
-}
\ No newline at end of file
+    public StartupDto emptyIngetLocNo(Integer devpNo) {
+        int crnNo = 0;
+
+        if (devpNo == 304) {
+            crnNo = 3;
+        } else if(devpNo == 204) {
+            crnNo = 2;
+        } else if(devpNo == 104) {
+            crnNo = 1;
+        }
+
+        // 鐩爣搴撲綅
+        LocMast locMast = locMastMapper.queryEmptyLocNoByStaNo(crnNo);
+
+        if (locMast == null) {
+            throw new CoolException("娌℃湁绌哄簱浣�");
+        }
+
+        // 鑾峰彇鐩爣绔�
+        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                .eq("type_no", 10)
+                .eq("stn_no", devpNo)
+                .eq("crn_no", crnNo);
+        StaDesc staDesc = staDescService.selectOne(wrapper);
+        if (Cools.isEmpty(staDesc)) {
+            log.error("鍏ュ簱璺緞涓嶅瓨鍦�, staDescId={}, sourceStaNo={}, crnNo={}", 10, devpNo, crnNo);
+            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+        }
+
+        // 妫�娴嬬洰鏍囩珯
+        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
+        if (!staNo.getAutoing().equals("Y")) {
+            throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+        }
+
+        basCrnpService.checkSiteStatus(crnNo, true);
+
+        // 杩斿洖dto
+        StartupDto startupDto = new StartupDto();
+        startupDto.setWorkNo(getWorkNo(0));
+        startupDto.setCrnNo(crnNo);
+        startupDto.setSourceStaNo(devpNo);
+        startupDto.setStaNo(devpNo);
+        startupDto.setLocNo(locMast.getLocNo());
+        return startupDto;
+    }
+
+    public StartupDto getLocNoBy304(String type) {
+
+        int row;
+        int devpNo = 304;
+        int crnNo = 3;
+        if (type.equals("1")) {
+            row =  7;
+        } else if (type.equals("2")) {
+            row = 6;
+        } else {
+            throw new CoolException("304鐗╂枡绫诲埆璇嗗埆閿欒锛�" + type);
+        }
+
+        // 鐩爣搴撲綅
+        LocMast locMast = locMastMapper.queryLocByBarCode(row);
+        if (locMast == null) {
+            throw new CoolException("304鍏ュ簱娌℃湁绌哄簱浣�");
+        }
+
+        // 鑾峰彇鐩爣绔�
+        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                .eq("type_no", 1)
+                .eq("stn_no", devpNo)
+                .eq("crn_no", crnNo);
+        StaDesc staDesc = staDescService.selectOne(wrapper);
+        if (Cools.isEmpty(staDesc)) {
+            log.error("鍏ュ簱璺緞涓嶅瓨鍦�, staDescId={}, sourceStaNo={}, crnNo={}", 1, devpNo, crnNo);
+            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+        }
+
+        // 妫�娴嬬洰鏍囩珯
+        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
+        if (!staNo.getAutoing().equals("Y")) {
+            throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+        }
+
+        basCrnpService.checkSiteStatus(crnNo, true);
+
+        // 杩斿洖dto
+        StartupDto startupDto = new StartupDto();
+        startupDto.setWorkNo(getWorkNo(0));
+        startupDto.setCrnNo(crnNo);
+        startupDto.setSourceStaNo(devpNo);
+        startupDto.setStaNo(devpNo);
+        startupDto.setLocNo(locMast.getLocNo());
+        return startupDto;
+    }
+
+    /**
+     * 涓�鏈熷鎵惧簱浣�
+     * 1-6灞� 鏉$爜1鎴栬��2寮�澶�
+     * 7-11灞� 鏉$爜8寮�澶�
+     * @param ioType 1.鍏ュ簱
+     * @param devpNo 鍏ュ簱绔欑偣
+     * @param barcode 鏉$爜
+     * @return 搴撲綅淇℃伅
+     */
+    public StartupDto getLocNoNew(int ioType, Integer devpNo, String barcode) {
+        char type = barcode.charAt(0);
+        int flag = 0;
+        if (type == '1' || type == '2') {
+            flag = 1;
+        } else if( type == '8') {
+            flag = 2;
+        }
+        if (flag == 0) {
+            throw new CoolException("鏉$爜鏈夎锛�" + barcode);
+        }
+
+        // 鐩爣搴撲綅
+        LocMast locMast = locMastMapper.queryLocByBarCodeNew(devpNo,flag);
+        if (locMast == null) {
+            throw new CoolException("鍏ュ簱娌℃湁绌哄簱浣�");
+        }
+
+        // 鍫嗗灈鏈哄彿
+        Integer crnNo = locMast.getCrnNo();
+
+        // 鑾峰彇鐩爣绔�
+        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                .eq("type_no", ioType)
+                .eq("stn_no", devpNo)
+                .eq("crn_no", crnNo);
+        StaDesc staDesc = staDescService.selectOne(wrapper);
+        if (Cools.isEmpty(staDesc)) {
+            log.error("鍏ュ簱璺緞涓嶅瓨鍦�, staDescId={}, sourceStaNo={}, crnNo={}", 1, devpNo, crnNo);
+            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+        }
+
+        // 妫�娴嬬洰鏍囩珯
+        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
+        if (!staNo.getAutoing().equals("Y")) {
+            throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+        }
+
+        basCrnpService.checkSiteStatus(crnNo, true);
+
+        // 杩斿洖dto
+        StartupDto startupDto = new StartupDto();
+        startupDto.setWorkNo(getWorkNo(0));
+        startupDto.setCrnNo(crnNo);
+        startupDto.setSourceStaNo(devpNo);
+        startupDto.setStaNo(devpNo);
+        startupDto.setLocNo(locMast.getLocNo());
+        return startupDto;
+
+    }
+}

--
Gitblit v1.9.1