From c46f9c28f8d40d2a4efcc7ef6e528661d97a4be0 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期二, 14 二月 2023 13:48:18 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/common/service/CommonService.java |  366 +++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 305 insertions(+), 61 deletions(-)

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 0989bf9..296bbbd 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -55,6 +55,10 @@
     private LocDetlService locDetlService;
     @Autowired
     private SlaveProperties slaveProperties;
+    @Autowired
+    private MatService matService;
+    @Autowired
+    private LocRuleService locRuleService;
 
     /**
      * 鐢熸垚宸ヤ綔鍙�
@@ -68,25 +72,23 @@
         }
         int workNo = 0;
         // 鍏ュ嚭搴撶被鍨�
-        if (wrkLastno.getWrkMk() == 0) {
-            workNo = wrkLastno.getWrkNo();
-            int sNo = wrkLastno.getSNo();
-            int eNo = wrkLastno.getENo();
+        workNo = wrkLastno.getWrkNo();
+        int sNo = wrkLastno.getSNo();
+        int eNo = wrkLastno.getENo();
 
-            workNo = workNo>=eNo ? sNo : workNo+1;
+        workNo = workNo>=eNo ? sNo : workNo+1;
 
-            while (true) {
-                WrkMast wrkMast = wrkMastService.selectById(workNo);
-                if (null != wrkMast) {
-                    workNo = workNo>=eNo ? sNo : workNo+1;
-                } else {
-                    break;
-                }
+        while (true) {
+            WrkMast wrkMast = wrkMastService.selectById(workNo);
+            if (null != wrkMast) {
+                workNo = workNo>=eNo ? sNo : workNo+1;
+            } else {
+                break;
             }
-            if (workNo > 0){
-                wrkLastno.setWrkNo(workNo);
-                wrkLastnoService.updateById(wrkLastno);
-            }
+        }
+        if (workNo > 0){
+            wrkLastno.setWrkNo(workNo);
+            wrkLastnoService.updateById(wrkLastno);
         }
         if (workNo == 0) {
             throw new CoolException("鐢熸垚宸ヤ綔鍙峰け璐ワ紝璇疯仈绯荤鐞嗗憳");
@@ -113,7 +115,31 @@
      */
     public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, LocTypeDto oldLocType, int times) {
         StartupDto startupDto = new StartupDto();
-        whsType = 1;
+        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 203:
+                whsType = 2;
+                start = 8;
+                end = 21;
+//                if (null != wrkMastService.selectPakoutOfStaNo(204)) {
+//                    end = 14;
+//                    theCrnNo = 2;
+//                }
+                break;
+            default:
+                throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
+        }
         // 鐢熸垚宸ヤ綔鍙�
         int workNo = getWorkNo(0);
         RowLastno rowLastno = rowLastnoService.selectById(whsType);
@@ -130,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;
                             }
                         }
@@ -170,15 +190,125 @@
             }
         }
 
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
+        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;
+                                }
+                            }
+                        }
+                    }
+                }
+            }
+        }
+
+        // 搴撳尯閿佸畾
+        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("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
                 }
-                Integer crnNo1 = shelves.get(curRow);
+                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;
@@ -207,33 +337,123 @@
         }
 
         // 鏇存柊搴撲綅鎺掑彿
-        rowLastno.setCurrentRow(curRow);
+        rowLastno.setCurrentRow(currentRow);
         rowLastnoService.updateById(rowLastno);
 
         // 寮�濮嬫煡鎵惧簱浣� ==============================>>
 
         // 1.褰撴绱㈠簱鎺掍负娴呭簱浣嶆帓鏃讹紝浼樺厛瀵绘壘褰撳墠搴撴帓鐨勬繁搴撲綅鎺�
+        // 楂樹綆棰戠鎺с�佸簱浣嶇粍鍏ㄩ儴涓篛
         if (locMast == null) {
-            List<Integer> rows;
-            switch (curRow) {
-                case 1:
-                    rows = FIRST_GROUP_ROW_LIST;
-                    break;
-                case 2:
-                    rows = SECOND_GROUP_ROW_LIST;
-                    break;
-                default:
-                    throw new CoolException("鍏ュ簱閫昏緫鏁呴殰銆�" + curRow + "銆�");
+            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(curRow, 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);
+            }
+        }
+
+        // 3.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
         if (Cools.isEmpty(locMast)) {
             // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
             if (times < rowCount) {
@@ -275,4 +495,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