From 96fc6c344e23e0180881b87aa2291a2fc19e4ab8 Mon Sep 17 00:00:00 2001
From: tqs <56479841@qq.com>
Date: 星期五, 14 四月 2023 12:55:20 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/common/service/CommonService.java |  378 ++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 310 insertions(+), 68 deletions(-)

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index ad7ff8b..aaba5de 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -10,6 +10,7 @@
 import com.zy.asrs.utils.Utils;
 import com.zy.asrs.utils.VersionUtils;
 import com.zy.common.model.LocTypeDto;
+import com.zy.common.model.Shelves;
 import com.zy.common.model.StartupDto;
 import com.zy.common.properties.SlaveProperties;
 import lombok.extern.slf4j.Slf4j;
@@ -54,6 +55,10 @@
     private LocDetlService locDetlService;
     @Autowired
     private SlaveProperties slaveProperties;
+    @Autowired
+    private MatService matService;
+    @Autowired
+    private LocRuleService locRuleService;
 
     /**
      * 鐢熸垚宸ヤ綔鍙�
@@ -110,16 +115,27 @@
      */
     public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, LocTypeDto oldLocType, int times) {
         StartupDto startupDto = new StartupDto();
+        int start;
+        int end;
+        Integer theCrnNo = null;
         switch (sourceStaNo) {
             case 103:
                 whsType = 1;
+                start = 1;
+                end = 14;
+//                if (null != wrkMastService.selectPakoutOfStaNo(104)) {
+//                    start = 8;
+//                    theCrnNo = 2;
+//                }
                 break;
-            case 111:
-            case 211:
+            case 203:
                 whsType = 2;
-                break;
-            case 208:
-                whsType = 3;
+                start = 8;
+                end = 21;
+//                if (null != wrkMastService.selectPakoutOfStaNo(204)) {
+//                    end = 14;
+//                    theCrnNo = 2;
+//                }
                 break;
             default:
                 throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
@@ -140,38 +156,32 @@
         // 鐩爣搴撲綅
         LocMast locMast = null;
 
-        // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
+        boolean inoutEveryday = false;
         if (!Cools.isEmpty(matNos)) {
-            List<String> locNos = locDetlService.getSameDetl(matNos.get(0), sRow, eRow);
-            for (String locNo : locNos) {
-                List<String> groupLoc = Utils.getGroupLoc(locNo);
-                locMast = locMastService.findOutMost(groupLoc);
-                if (null != locMast) {
-                    // 娴呭簱浣嶇鍚堝昂瀵告娴�
-                    if (VersionUtils.locMoveCheckLocType(locMast, locTypeDto)) {
-                        // 娴呭簱浣嶅搴斿爢鍨涙満蹇呴』鍙敤涓旀棤寮傚父
-                        if (basCrnpService.checkSiteError(locMast.getCrnNo(), true)) {
-                            crnNo = locMast.getCrnNo();
-                            break;
-                        }
-                    }
+            for (String matNo : matNos) {
+                Mat mat = matService.selectByMatnr(matNo);
+                if (mat.getInoutEveryday() != null && mat.getInoutEveryday()) {
+                    inoutEveryday = true;
+                    break;
                 }
             }
         }
 
-        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
-        if (staDescId == 10) {
-            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow));
-            if (locMasts.size() > 0) {
-                for (LocMast loc : locMasts) {
-                    List<String> groupLoc = Utils.getGroupLoc(loc.getLocNo());
-                    locMast = locMastService.findOutMost(groupLoc);
-                    if (null != locMast) {
-                        // 娴呭簱浣嶇鍚堝昂瀵告娴�
-                        if (VersionUtils.locMoveCheckLocType(locMast, locTypeDto)) {
-                            // 娴呭簱浣嶅搴斿爢鍨涙満蹇呴』鍙敤涓旀棤寮傚父
-                            if (basCrnpService.checkSiteError(locMast.getCrnNo(), true)) {
-                                crnNo = locMast.getCrnNo();
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
+        if (!Cools.isEmpty(matNos) && matNos.size() == 1) {
+            List<String> locNos = locDetlService.getSameDetl(matNos.get(0), start, end);
+            for (String locNo : locNos) {
+                List<String> groupLoc = Utils.getGroupLoc(locNo);
+                LocMast locMast0 = locMastService.findOutMost(groupLoc);
+                if (null != locMast0) {
+                    // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                    if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) {
+                        // 娴呭簱浣嶅搴斿爢鍨涙満蹇呴』鍙敤涓旀棤寮傚父
+                        if (basCrnpService.checkSiteError(locMast0.getCrnNo(), true)) {
+                            // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
+                            if (locMastService.checkEmptyCount(locMast0, 10)) {
+                                crnNo = locMast0.getCrnNo();
+                                locMast = locMast0;
                                 break;
                             }
                         }
@@ -180,41 +190,132 @@
             }
         }
 
-        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-        if (null == locMast) {
-            switch (whsType) {
-                case 1:
-                    if (curRow == 1) {
-                        curRow = 7;
-                    } else if (curRow == 7) {
-                        curRow = 1;
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
+        if (staDescId == 10) {
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("loc_sts", "D").ge("row1", start).le("row1", end));
+            if (locMasts.size() > 0) {
+                for (LocMast loc : locMasts) {
+                    List<String> groupLoc = Utils.getGroupLoc(loc.getLocNo());
+                    LocMast locMast0 = locMastService.findOutMost(groupLoc);
+                    if (null != locMast0) {
+                        // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                        if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) {
+                            // 娴呭簱浣嶅搴斿爢鍨涙満蹇呴』鍙敤涓旀棤寮傚父
+                            if (basCrnpService.checkSiteError(locMast0.getCrnNo(), true)) {
+                                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
+                                if (locMastService.checkEmptyCount(locMast0, 10)) {
+                                    crnNo = locMast0.getCrnNo();
+                                    locMast = locMast0;
+                                    break;
+                                }
+                            }
+                        }
                     }
-                    crnNo = 1;
-                    break;
-                case 2:
-                    if (curRow == 8) {
-                        curRow = 14;
-                    } else if (curRow == 14) {
-                        curRow = 8;
-                    }
-                    crnNo = 2;
-                    break;
-                case 3:
-                    if (curRow == 15) {
-                        curRow = 21;
-                    } else if (curRow == 21) {
-                        curRow = 15;
-                    }
-                    crnNo = 3;
-                    break;
-                default:
-                    throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+                }
             }
         }
 
-        if (!basCrnpService.checkSiteError(crnNo, true)) {
-            throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
+        // 搴撳尯閿佸畾
+        if (Cools.isEmpty(locMast)) {
+            LocRule locRule = locRuleService.find(Cools.isEmpty(matNos) ? null : matNos.get(0), null, start, end);
+            if (!Cools.isEmpty(locRule)) {
+                List<LocMast> locMasts = locMastService.queryFreeLocMast2(locTypeDto.getLocType1()
+                        , locRule.getRowBeg(), locRule.getRowEnd(), locRule.getBayBeg(), locRule.getBayEnd(), locRule.getLevBeg(), locRule.getLevEnd());
+                for (LocMast one : locMasts) {
+                    List<String> groupLoc = Utils.getGroupLoc(one.getLocNo());
+                    LocMast locMast0 = locMastService.findOutMost(groupLoc);
+                    if (null != locMast0) {
+                        // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                        if (VersionUtils.locMoveCheckLocType(locMast0, locTypeDto)) {
+                            // 娴呭簱浣嶅搴斿爢鍨涙満蹇呴』鍙敤涓旀棤寮傚父
+                            if (basCrnpService.checkSiteError(locMast0.getCrnNo(), true)) {
+                                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
+                                if (locMastService.checkEmptyCount(locMast0, 10)) {
+                                    crnNo = locMast0.getCrnNo();
+                                    locMast = locMast0;
+                                    break;
+                                }
+                            }
+                        }
+                    }
+                }
+            }
         }
+
+        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
+        int currentRow = 1;
+        if (null == locMast) {
+            Shelves shelves = new Shelves(rowCount, crn_qty);
+            for (int i = 0; i < shelves.group; i ++) {
+                if (i > 0) {
+                    curRow = currentRow;
+                }
+                curRow = shelves.start(curRow);
+                if (curRow < 0) {
+                    throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+                }
+                currentRow = curRow;
+                int crnNo1 = shelves.get(curRow);
+                if (whsType == 1) {
+                    switch (curRow) {
+                        case 1:
+                            curRow = 1;
+                            if (null != theCrnNo) {
+                                curRow = 8;
+                                crnNo1 = crnNo1 + 1;
+                            }
+                            break;
+                        case 2:
+                            curRow = 7;
+                            if (null != theCrnNo) {
+                                curRow = 14;
+                                crnNo1 = crnNo1 + 1;
+                            }
+                            break;
+                        case 3:
+                            curRow = 8;
+                            break;
+                        case 4:
+                            curRow = 14;
+                            break;
+                        default:
+                            throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+                    }
+                } else {
+                    switch (curRow) {
+                        case 1:
+                            curRow = 8;
+                            break;
+                        case 2:
+                            curRow = 14;
+                            break;
+                        case 3:
+                            curRow = 15;
+                            if (null != theCrnNo) {
+                                curRow = 8;
+                                crnNo1 = crnNo1 - 1;
+                            }
+                            break;
+                        case 4:
+                            curRow = 21;
+                            if (null != theCrnNo) {
+                                curRow = 14;
+                                crnNo1 = crnNo1 - 1;
+                            }
+                            break;
+                        default:
+                            throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+                    }
+                    crnNo1 = crnNo1 + 1;
+                }
+                if (basCrnpService.checkSiteError(crnNo1, true)) {
+                    crnNo = crnNo1;
+                    break;
+                }
+            }
+        }
+
         if (crnNo == 0) {
             throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
         }
@@ -236,23 +337,140 @@
         }
 
         // 鏇存柊搴撲綅鎺掑彿
-        rowLastno.setCurrentRow(curRow);
+        rowLastno.setCurrentRow(currentRow);
         rowLastnoService.updateById(rowLastno);
 
         // 寮�濮嬫煡鎵惧簱浣� ==============================>>
 
         // 1.褰撴绱㈠簱鎺掍负娴呭簱浣嶆帓鏃讹紝浼樺厛瀵绘壘褰撳墠搴撴帓鐨勬繁搴撲綅鎺�
+        // 楂樹綆棰戠鎺с�佸簱浣嶇粍鍏ㄩ儴涓篛
         if (locMast == null) {
             List<Integer> rows = Utils.getGroupLoc(curRow);
+            List<LocMast> locMasts = locMastService.queryFreeLocMast0(rows, rows.size(), locTypeDto.getLocType1(), inoutEveryday);
+            if (!Cools.isEmpty(locMasts)) {
+                Integer innermostRow = Utils.getInnermostRow(locMasts.get(0).getLocNo());
+                for (LocMast one : locMasts) {
+                    if (one.getRow1().equals(innermostRow)) {
+                        locMast = one;
+                        break;
+                    }
+                }
+            }
 
-            locMast = locMastService.queryFreeLocMast(null, rows, locTypeDto.getLocType1());
             // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
-//            if (!locMastService.checkEmptyCount(locMast)) {
-//                locMast = null;
-//            }
+            if (!locMastService.checkEmptyCount(locMast, 10)) { locMast = null; }
         }
 
-        // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
+        // 2.1 楂樹綆棰戠鎺с�佸簱浣嶇粍鏃犻渶鍏ㄩ儴涓篛锛屾壘鍒板簱浣嶅搴旀繁搴撲綅涓嶈兘涓篜 R
+        if (Cools.isEmpty(locMast)) {
+            int sign = curRow;
+            while (sign != 0 && Cools.isEmpty(locMast)) {
+                List<LocMast> locMasts = locMastService.queryFreeLocMastEnd1(sign, locTypeDto.getLocType1(), inoutEveryday);
+                for (LocMast loc : locMasts) {
+                    // 鍚屽簱浣嶇粍瀵瑰簲鍏堕挶搴撲綅鏄惁涓� O.绌哄簱浣�
+                    boolean success = true;
+                    // 娴呭簱浣�
+                    List<String> outerLocList = Utils.getGroupOuterLoc(loc.getLocNo());
+                    for (String outerLocNo : outerLocList) {
+                        LocMast outerLoc = locMastService.selectById(outerLocNo);
+                        if (Cools.isEmpty(outerLoc)) {
+                            continue;
+                        }
+                        if (!outerLoc.getLocSts().equals("O")) {
+                            success = false; break;
+                        }
+                    }
+                    // 娣卞簱浣嶅垽鏂�
+                    List<String> insideLocList = Utils.getGroupInsideLoc(loc.getLocNo());
+                    for (String insideLocNo : insideLocList) {
+                        LocMast insideLoc = locMastService.selectById(insideLocNo);
+                        if (Cools.isEmpty(insideLoc)) {
+                            continue;
+                        }
+                        if (insideLoc.getLocSts().equals("R")
+                                || insideLoc.getLocSts().equals("P")
+                                || insideLoc.getLocSts().equals("Q")
+                                || insideLoc.getLocSts().equals("S")) {
+                            success = false; break;
+                        }
+                    }
+                    // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
+                    if (!locMastService.checkEmptyCount(loc, 10)) {
+                        success = false;
+                    }
+                    if (success) {
+                        locMast = loc;
+                        break;
+                    }
+                }
+                sign = getCurRow(sign);
+            }
+        }
+
+        // 2.鏃犲簱浣嶆椂锛屾棤瑙嗗尯鍩熼攣瀹氾紝閲嶆柊鏌ユ壘搴撲綅
+        if (Cools.isEmpty(locMast)) {
+            int sign = curRow;
+            while (sign != 0 && Cools.isEmpty(locMast)) {
+                List<LocMast> locMasts = locMastService.queryFreeLocMastEnd(sign, locTypeDto.getLocType1());
+                for (LocMast loc : locMasts) {
+                    // 鍚屽簱浣嶇粍瀵瑰簲鍏堕挶搴撲綅鏄惁涓� O.绌哄簱浣�
+                    boolean success = true;
+                    // 娴呭簱浣�
+                    List<String> outerLocList = Utils.getGroupOuterLoc(loc.getLocNo());
+                    for (String outerLocNo : outerLocList) {
+                        LocMast outerLoc = locMastService.selectById(outerLocNo);
+                        if (Cools.isEmpty(outerLoc)) {
+                            continue;
+                        }
+                        if (!outerLoc.getLocSts().equals("O")) {
+                            success = false; break;
+                        }
+                    }
+                    // 娣卞簱浣�
+                    List<String> insideLocList = Utils.getGroupInsideLoc(loc.getLocNo());
+                    for (String insideLocNo : insideLocList) {
+                        LocMast insideLoc = locMastService.selectById(insideLocNo);
+                        if (Cools.isEmpty(insideLoc)) {
+                            continue;
+                        }
+                        if (insideLoc.getLocSts().equals("R")
+                                || insideLoc.getLocSts().equals("P")
+                                || insideLoc.getLocSts().equals("Q")
+                                || insideLoc.getLocSts().equals("S")) {
+                            success = false; break;
+                        }
+                    }
+                    // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
+                    if (!locMastService.checkEmptyCount(loc, 10)) {
+                        success = false;
+                    }
+                    if (success) {
+                        locMast = loc;
+                        break;
+                    }
+                }
+                sign = getCurRow(sign);
+            }
+        }
+
+        //2023-4-13 ADD锛� 鎵惧埌鐨勫簱浣嶃�佷互鍙婂叾娴呭簱浣嶏紝濡傛灉鍦ㄥ伐浣滄。鏈夌Щ搴撲换鍔★紝鍒欒烦杩�
+        List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>()
+                .eq("io_type", 11));
+        for (WrkMast wrkMast : wrkMasts){
+            if (wrkMast.getSourceLocNo().equals(locMast.getLocNo())){
+                locMast = null;
+                break;
+            }
+            List<String> outerLocList = Utils.getGroupOuterLoc(locMast.getLocNo());
+            for (String outerLocNo : outerLocList) {
+                if (locMast.getLocNo().equals(outerLocNo)){
+                    locMast = null;
+                    break;
+                }
+            }
+        }
+
+        // 3.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
         if (Cools.isEmpty(locMast)) {
             // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
             if (times < rowCount) {
@@ -294,4 +512,28 @@
         }
     }
 
+    public int getCurRow(int curRow){
+        switch (curRow){
+            case 1:
+            case 2:
+            case 8:
+            case 9:
+            case 10:
+            case 15:
+            case 16:
+            case 17:
+                return curRow+1;
+            case 5:
+            case 6:
+            case 7:
+            case 13:
+            case 14:
+            case 20:
+            case 21:
+                return curRow-1;
+            default:
+                return 0;
+        }
+    }
+
 }

--
Gitblit v1.9.1