From 32e151c9022eb8b00a76bfff8ac66bbccee9b6b9 Mon Sep 17 00:00:00 2001
From: qlsxk <qlsxk@qq.com>
Date: 星期五, 26 九月 2025 14:11:12 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/common/service/CommonService.java |  732 ++++++++++++++++----------------------------------------
 1 files changed, 212 insertions(+), 520 deletions(-)

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 98226ab..e1761f0 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -1,26 +1,22 @@
 package com.zy.common.service;
 
-import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
-import com.baomidou.mybatisplus.mapper.Wrapper;
-import com.core.common.Arith;
 import com.core.common.Cools;
 import com.core.exception.CoolException;
 import com.zy.asrs.entity.*;
+import com.zy.asrs.entity.result.FindLocNoAttributeVo;
 import com.zy.asrs.service.*;
 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 io.swagger.models.auth.In;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
-import java.util.ArrayList;
+import java.util.Collections;
 import java.util.List;
 
 /**
@@ -90,405 +86,248 @@
         return workNo;
     }
 
+
     /**
      * 妫�绱㈠簱浣嶅彿
      *
-     * @param whsType     绫诲瀷 1:鍙屾繁寮忚揣鏋�
-     * @param staDescId   璺緞宸ヤ綔绫诲瀷
-     * @param sourceStaNo 婧愮珯
-     * @param matNos      鍟嗗搧缂栧彿闆嗗悎
+     * @param staDescId            璺緞ID
+     * @param sourceStaNo          婧愮珯
+     * @param findLocNoAttributeVo 灞炴��
+     * @param locTypeDto           绫诲瀷
      * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
      */
     @Transactional
-    public StartupDto getLocNo4(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, int times) {
-        StartupDto startupDto = new StartupDto();
-        if (sourceStaNo == 101 || sourceStaNo == 103) {
-            whsType = 1;
-        } else if (sourceStaNo == 105 || sourceStaNo == 107) {
-            whsType = 2;
-        } else {
-            throw new CoolException("绔欑偣鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
+    public StartupDto getLocNo(Integer staDescId, Integer sourceStaNo, FindLocNoAttributeVo findLocNoAttributeVo, LocTypeDto locTypeDto, String barcode) {
+        StartupDto startupDto = null;
+        StringBuilder builder = new StringBuilder();
+        try {
+            startupDto = searchLocNoByCrnNo(staDescId, sourceStaNo, findLocNoAttributeVo, locTypeDto);
+        } catch (Exception e) {
+            builder.append(e.getMessage()).append(",");
         }
 
-        RowLastno rowLastno = rowLastnoService.selectById(whsType);
-        if (Cools.isEmpty(rowLastno)) {
-            throw new CoolException("1鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
+        if(startupDto == null) {
+            builder.append("鎵句笉鍒扮┖搴撲綅");
+            throw new CoolException(builder.toString());
         }
 
-        // ===============>>>> 寮�濮嬫墽琛�
-        int curRow = rowLastno.getCurrentRow();
-        int sRow = rowLastno.getsRow();
-        int eRow = rowLastno.geteRow();
-        int crn_qty = rowLastno.getCrnQty();
-        int rowCount = eRow - sRow + 1;
-        // 鐩爣鍫嗗灈鏈哄彿
-        int crnNo = 0;
-        // 鐩爣搴撲綅
-        LocMast locMast = null;
-
-        // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
-        if (!Cools.isEmpty(matNos)) {
-            List<String> locNos = locDetlService.getSameDetlToday(matNos.get(0), sRow, eRow);
-            for (String locNo : locNos) {
-                if (Utils.isShallowLoc(slaveProperties, locNo)) {
-                    continue;
-                }
-                String shallowLocNo = Utils.getShallowLoc(slaveProperties, locNo);
-                // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
-                LocMast shallowLoc = locMastService.selectById(shallowLocNo);
-                if (shallowLoc != null && shallowLoc.getLocSts().equals("O")) {
-                    if (VersionUtils.locMoveCheckLocType(shallowLoc, locTypeDto)) {
-                        if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) {
-                            locMast = shallowLoc;
-                            crnNo = locMast.getCrnNo();
-                            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) {
-                    if (Utils.isShallowLoc(slaveProperties, loc.getLocNo())) {
-                        continue;
-                    }
-                    String shallowLocNo = Utils.getShallowLoc(slaveProperties, loc.getLocNo());
-                    // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
-                    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();
-                            break;
-                        }
-                    }
-                }
-            }
-        }
-
-        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-        if (null == locMast) {
-            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("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-                }
-                Integer crnNo1 = shelves.get(curRow);
-                crnNo1 = crnNo1 + divides * 1;
-                if (basCrnpService.checkSiteError(crnNo1, true)) {
-                    crnNo = crnNo1;
-                    curRow = curRow + divides * 4;
-                    break;
-                }
-            }
-        }
-
-        if (crnNo == 0) {
-            throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
-        }
-        // 鑾峰彇鐩爣绔�
-        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
-                .eq("type_no", staDescId)
-                .eq("stn_no", sourceStaNo)
-                .eq("crn_no", crnNo);
-        StaDesc staDesc = staDescService.selectOne(wrapper);
-        if (Cools.isEmpty(staDesc)) {
-            log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
-            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
-        }
-        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
-        if (!staNo.getAutoing().equals("Y")) {
-            throw new CoolException("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
-        }
-
-        // 鏇存柊搴撲綅鎺掑彿
-        rowLastno.setCurrentRow(curRow);
-        rowLastnoService.updateById(rowLastno);
-
-        // 寮�濮嬫煡鎵惧簱浣� ==============================>>
-
-        // 1.褰撴绱㈠簱鎺掍负娴呭簱浣嶆帓鏃讹紝浼樺厛瀵绘壘褰撳墠搴撴帓鐨勬繁搴撲綅鎺�
-        if (locMast == null) {
-            if (Utils.isShallowLoc(slaveProperties, curRow)) {
-                Integer deepRow = Utils.getDeepRow(slaveProperties, curRow);
-                locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1());
-                // todo:luxiaotao 濡傛灉鐢ㄦ祬鎺掓壘鍒扮殑娣卞簱浣嶏紝閭d箞鍒欓渶瑕佸垽鏂繖涓繁搴撲綅瀵瑰簲鐨勬祬搴撲綅鏄惁鏈夎揣锛團銆乆銆丏锛�
-                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
-                if (!locMastService.checkEmptyCount(locMast)) {
-                    locMast = null;
-                }
-            }
-            if (Cools.isEmpty(locMast)) {
-                locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1());
-                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
-                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;
-                    }
-                }
-                // 鐩爣搴撲綅 ===>> 娣卞簱浣嶏紝 鍒欐牎楠屽叾娴呭簱浣嶆槸鍚︿负 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;
-                    }
-                }
-            }
-        }
-
-        // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
-        if (Cools.isEmpty(locMast)) {
-            // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
-            if (times < rowCount) {
-                times = times + 1;
-                return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times);
-            }
-
-            // 杞昏揣鐗╂壘杞诲簱浣嶄负绌烘椂锛屽彲浠ュ幓鎵鹃噸搴撲綅浠�
-            if (locTypeDto.getLocType1() == 1) {
-                locTypeDto.setLocType1((short) 2);
-                return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times);
-            }
-            log.error("绯荤粺娌℃湁绌哄簱浣嶏紒锛侊紒 灏哄瑙勬牸锛� {}锛� 杞娆℃暟锛歿}", JSON.toJSONString(locTypeDto), times);
-            throw new CoolException("娌℃湁绌哄簱浣�");
-        }
-        String locNo = locMast.getLocNo();
-
-        // 鐢熸垚宸ヤ綔鍙�
-        int workNo = getWorkNo(0);
-        // 杩斿洖dto
-        startupDto.setWorkNo(workNo);
-        startupDto.setCrnNo(crnNo);
-        startupDto.setSourceStaNo(sourceStaNo);
-        startupDto.setStaNo(staNo.getDevNo());
-        startupDto.setLocNo(locNo);
         return startupDto;
     }
 
-
     /**
      * 妫�绱㈠簱浣嶅彿
      *
-     * @param whsType     绫诲瀷 1:鍙屾繁寮忚揣鏋�
-     * @param staDescId   璺緞宸ヤ綔绫诲瀷
-     * @param sourceStaNo 婧愮珯
-     * @param matNos      鍟嗗搧缂栧彿闆嗗悎
+     * @param staDescId            璺緞ID
+     * @param sourceStaNo          婧愮珯
+     * @param findLocNoAttributeVo 灞炴��
+     * @param locTypeDto           绫诲瀷
      * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
      */
     @Transactional
-    public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos, LocTypeDto locTypeDto, int times) {
-//        whsType = getWhsType(sourceStaNo, times);
+    public StartupDto searchLocNoByCrnNo(Integer staDescId, Integer sourceStaNo, FindLocNoAttributeVo findLocNoAttributeVo, LocTypeDto locTypeDto) {
+        LocMast locMast = null;
+        if (staDescId == 10) {
+            //鎼滅储绌烘墭鐩�
+            locMast = searchEmptyPallet(locTypeDto);
+        }else {
+            //婊℃墭鐩�
+            locMast = searchMaxPallet(findLocNoAttributeVo, locTypeDto);
+        }
+
+        if(locMast == null) {
+            throw new CoolException("鎵句笉鍒扮鍚堝昂瀵哥殑绌哄簱浣�");
+        }
+
         StartupDto startupDto = new StartupDto();
 
-//        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;
+//        // 鑾峰彇鐩爣绔�
+//        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>().eq("type_no", staDescId).eq("stn_no", sourceStaNo).eq("crn_no", locMast.getCrnNo());
+//        StaDesc staDesc = staDescService.selectOne(wrapper);
+//        if (Cools.isEmpty(staDesc)) {
+//            log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
+//            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+//        } else {
+//            BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
+//            if (!staNo.getAutoing().equals("Y")) {
+//                log.error("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
+//                throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+//            }
+//            startupDto.setStaNo(staNo.getDevNo());
 //        }
-
-        if (sourceStaNo == 101 || sourceStaNo == 103) {
-            whsType = 1;
-        } else if (sourceStaNo == 105 || sourceStaNo == 107) {
-            whsType = 2;
-        } else {
-            throw new CoolException("绔欑偣鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
-        }
-
-        RowLastno rowLastno = rowLastnoService.selectById(whsType);
-        if (Cools.isEmpty(rowLastno)) {
-            throw new CoolException("1鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
-        }
-
-        // ===============>>>> 寮�濮嬫墽琛�
-        int curRow = rowLastno.getCurrentRow();
-        int sRow = rowLastno.getsRow();
-        int eRow = rowLastno.geteRow();
-        int crn_qty = rowLastno.getCrnQty();
-        int rowCount = eRow - sRow + 1;
-        // 鐩爣鍫嗗灈鏈哄彿
-        int crnNo = 0;
-        // 鐩爣搴撲綅
-        LocMast locMast = null;
-
-        // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
-        if (!Cools.isEmpty(matNos)) {
-            List<String> locNos = locDetlService.getSameDetlToday(matNos.get(0), sRow, eRow);
-            for (String locNo : locNos) {
-                if (Utils.isShallowLoc(slaveProperties, locNo)) {
-                    continue;
-                }
-                String shallowLocNo = Utils.getShallowLoc(slaveProperties, locNo);
-                // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
-                LocMast shallowLoc = locMastService.selectById(shallowLocNo);
-                if (shallowLoc != null && shallowLoc.getLocSts().equals("O")) {
-                    if (VersionUtils.locMoveCheckLocType(shallowLoc, locTypeDto)) {
-                        if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) {
-                            locMast = shallowLoc;
-                            crnNo = locMast.getCrnNo();
-                            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) {
-                    if (Utils.isShallowLoc(slaveProperties, loc.getLocNo())) {
-                        continue;
-                    }
-                    String shallowLocNo = Utils.getShallowLoc(slaveProperties, loc.getLocNo());
-                    // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
-                    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();
-                            break;
-                        }
-                    }
-                }
-            }
-        }
-
-        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-        if (null == locMast) {
-            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("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-                }
-                Integer crnNo1 = shelves.get(curRow);
-                crnNo1 = crnNo1 + divides * 1;
-                if (basCrnpService.checkSiteError(crnNo1, true)) {
-                    crnNo = crnNo1;
-                    curRow = curRow + divides * 4;
-                    break;
-                }
-            }
-        }
-
-        if (crnNo == 0) {
-            throw new CoolException("娌℃湁鍙敤鐨勫爢鍨涙満");
-        }
-        // 鑾峰彇鐩爣绔�
-        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
-                .eq("type_no", staDescId)
-                .eq("stn_no", sourceStaNo)
-                .eq("crn_no", crnNo);
-        StaDesc staDesc = staDescService.selectOne(wrapper);
-        if (Cools.isEmpty(staDesc)) {
-            log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
-            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
-        }
-        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
-        if (!staNo.getAutoing().equals("Y")) {
-            throw new CoolException("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
-        }
-
-        // 鏇存柊搴撲綅鎺掑彿
-        rowLastno.setCurrentRow(curRow);
-        rowLastnoService.updateById(rowLastno);
-
-        // 寮�濮嬫煡鎵惧簱浣� ==============================>>
-
-        // 1.褰撴绱㈠簱鎺掍负娴呭簱浣嶆帓鏃讹紝浼樺厛瀵绘壘褰撳墠搴撴帓鐨勬繁搴撲綅鎺�
-        if (locMast == null) {
-            if (Utils.isShallowLoc(slaveProperties, curRow)) {
-                Integer deepRow = Utils.getDeepRow(slaveProperties, curRow);
-                locMast = locMastService.queryFreeLocMast(deepRow, locTypeDto.getLocType1());
-                // todo:luxiaotao 濡傛灉鐢ㄦ祬鎺掓壘鍒扮殑娣卞簱浣嶏紝閭d箞鍒欓渶瑕佸垽鏂繖涓繁搴撲綅瀵瑰簲鐨勬祬搴撲綅鏄惁鏈夎揣锛團銆乆銆丏锛�
-                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
-                if (!locMastService.checkEmptyCount(locMast)) {
-                    locMast = null;
-                }
-            }
-            if (Cools.isEmpty(locMast)) {
-                locMast = locMastService.queryFreeLocMast(curRow, locTypeDto.getLocType1());
-                // 鍥犲簱浣嶇Щ杞�侀渶棰勭暀绌哄簱浣�
-                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;
-                    }
-                }
-                // 鐩爣搴撲綅 ===>> 娣卞簱浣嶏紝 鍒欐牎楠屽叾娴呭簱浣嶆槸鍚︿负 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;
-                    }
-                }
-            }
-        }
-
-        // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
-        if (Cools.isEmpty(locMast)) {
-            // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
-            if (times < rowCount) {
-                times = times + 1;
-                return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times);
-            }
-
-            // 杞昏揣鐗╂壘杞诲簱浣嶄负绌烘椂锛屽彲浠ュ幓鎵鹃噸搴撲綅浠�
-            if (locTypeDto.getLocType1() == 1) {
-                locTypeDto.setLocType1((short) 2);
-                return getLocNo(1, staDescId, sourceStaNo, matNos, locTypeDto, times);
-            }
-            log.error("绯荤粺娌℃湁绌哄簱浣嶏紒锛侊紒 灏哄瑙勬牸锛� {}锛� 杞娆℃暟锛歿}", JSON.toJSONString(locTypeDto), times);
-            throw new CoolException("娌℃湁绌哄簱浣�");
-        }
         String locNo = locMast.getLocNo();
-
         // 鐢熸垚宸ヤ綔鍙�
         int workNo = getWorkNo(0);
         // 杩斿洖dto
         startupDto.setWorkNo(workNo);
-        startupDto.setCrnNo(crnNo);
+        startupDto.setCrnNo(locMast.getCrnNo());
         startupDto.setSourceStaNo(sourceStaNo);
-        startupDto.setStaNo(staNo.getDevNo());
         startupDto.setLocNo(locNo);
         return startupDto;
     }
 
+    //鎼滅储婊℃墭鐩樺簱浣�
+    public LocMast searchMaxPallet(FindLocNoAttributeVo findLocNoAttributeVo, LocTypeDto locTypeDto) {
+        LocMast targetLocMast = null;
+        List<String> locNos = locDetlService.getSameDetlList(findLocNoAttributeVo.getMatnr());
+        for (String locNo : locNos) {
+            //鑾峰彇閫氶亾缁�
+            List<Integer> locRowGroupDesc = Utils.getLocRowGroupDesc(slaveProperties, Utils.getRow(locNo));
+            for (Integer row : locRowGroupDesc) {
+                String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                LocMast deepLoc = locMastService.selectById(deepLocNo);
+                if (deepLoc == null) {
+                    continue;
+                }
+
+                if (deepLoc.getLocSts().equals("F")) {
+                    continue;
+                } else if (deepLoc.getLocSts().equals("O")) {
+                    targetLocMast = deepLoc;
+                    break;
+                }else {
+                    break;
+                }
+            }
+
+        }
+
+        if(targetLocMast == null) {
+            //鐩歌繎鐗╂枡鍖归厤澶辫触锛屾悳绱㈠彲鐢ㄧ┖搴撲綅缁�
+
+            //鑾峰彇璁惧妤煎眰
+            List<Integer> levList = basCrnpService.getLevList();
+            Collections.shuffle(levList);
+
+            for (Integer lev : levList) {
+                List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("loc_sts", "O")
+                        .eq("lev1", lev)
+                        .orderBy("bay1", true));
+                for (LocMast locMast : locMasts) {
+                    String locNo = locMast.getLocNo();
+                    //鑾峰彇閫氶亾缁�
+                    List<Integer> locRowGroupDesc = Utils.getLocRowGroupDesc(slaveProperties, Utils.getRow(locNo));
+
+                    boolean flag = true;
+                    for (Integer row : locRowGroupDesc) {
+                        String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                        LocMast deepLoc = locMastService.selectById(deepLocNo);
+                        if (deepLoc == null) {
+                            continue;
+                        }
+
+                        if (!deepLoc.getLocSts().equals("O")) {
+                            flag = false;
+                            break;
+                        }
+                    }
+
+                    if (flag) {
+                        for (Integer row : locRowGroupDesc) {
+                            String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                            LocMast deepLoc = locMastService.selectById(deepLocNo);
+                            if (deepLoc == null) {
+                                continue;
+                            }
+
+                            targetLocMast = deepLoc;
+                            break;
+                        }
+                        break;
+                    }
+                }
+
+                if (targetLocMast != null) {
+                    break;
+                }
+            }
+
+        }
+        return targetLocMast;
+    }
+
+    //鎼滅储绌烘墭鐩樺簱浣�
+    public LocMast searchEmptyPallet(LocTypeDto locTypeDto) {
+        LocMast targetLocMast = null;
+
+        List<LocMast> locMastsD = locMastService.selectList(new EntityWrapper<LocMast>()
+                .eq("loc_sts", "D"));
+        for (LocMast locMast : locMastsD) {
+            String locNo = locMast.getLocNo();
+            //鑾峰彇閫氶亾缁�
+            List<Integer> locRowGroupDesc = Utils.getLocRowGroupDesc(slaveProperties, Utils.getRow(locNo));
+            for (Integer row : locRowGroupDesc) {
+                String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                LocMast deepLoc = locMastService.selectById(deepLocNo);
+                if (deepLoc == null) {
+                    continue;
+                }
+
+                if (deepLoc.getLocSts().equals("F")) {
+                    continue;
+                } else if (deepLoc.getLocSts().equals("O")) {
+                    targetLocMast = deepLoc;
+                    break;
+                }else {
+                    break;
+                }
+            }
+
+        }
+
+        if(targetLocMast == null) {
+
+            //鑾峰彇璁惧妤煎眰
+            List<Integer> levList = basCrnpService.getLevList();
+            Collections.shuffle(levList);
+
+            for (Integer lev : levList) {
+                //鐩歌繎鐗╂枡鍖归厤澶辫触锛屾悳绱㈠彲鐢ㄧ┖搴撲綅缁�
+                List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("loc_sts", "O")
+                        .eq("lev1", lev)
+                        .orderBy("bay1", true));
+                for (LocMast locMast : locMasts) {
+                    String locNo = locMast.getLocNo();
+                    //鑾峰彇閫氶亾缁�
+                    List<Integer> locRowGroupDesc = Utils.getLocRowGroupDesc(slaveProperties, Utils.getRow(locNo));
+
+                    boolean flag = true;
+                    for (Integer row : locRowGroupDesc) {
+                        String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                        LocMast deepLoc = locMastService.selectById(deepLocNo);
+                        if (deepLoc == null) {
+                            continue;
+                        }
+
+                        if (!deepLoc.getLocSts().equals("O")) {
+                            flag = false;
+                            break;
+                        }
+                    }
+
+                    if (flag) {
+                        for (Integer row : locRowGroupDesc) {
+                            String deepLocNo = Utils.getLocNo(row, Utils.getBay(locNo), Utils.getLev(locNo));
+                            LocMast deepLoc = locMastService.selectById(deepLocNo);
+                            if (deepLoc == null) {
+                                continue;
+                            }
+
+                            targetLocMast = deepLoc;
+                            break;
+                        }
+                        break;
+                    }
+                }
+
+                if (targetLocMast != null) {
+                    break;
+                }
+            }
+        }
+        return targetLocMast;
+    }
 
     public static String zerofill(String msg, Integer count) {
         if (msg.length() == count) {
@@ -502,153 +341,6 @@
             }
             return msgBuilder.toString();
         }
-    }
-
-    /**
-     * 鏍规嵁鍏ュ簱绔欒幏鍙栧簱浣嶆帓鍙峰垎閰�
-     */
-    private Integer getWhsType(Integer sourceStaNo, int times) {
-        if (times >= 16) {
-            return 4;
-        }
-        switch (sourceStaNo) {
-            case 173:
-            case 176:
-            case 180:
-            case 185:
-                return 1;
-            case 189:
-            case 194:
-            case 198:
-            case 202:
-                return 2;
-            case 206:
-//            case 211:
-//            case 215:
-//            case 219:
-//            case 223:
-            case 227:
-                return 3;
-            case 305:
-            case 303:
-            case 301:
-                return 4;
-            default:
-                throw new CoolException("鏍规嵁鍏ュ簱绔欒幏鍙栧簱浣嶆帓鍙峰垎閰嶅け璐ワ紝鍏ュ簱绔欙細" + sourceStaNo);
-        }
-    }
-
-    /**
-     * @param waitPakin 缁勬墭鐨勭墿鏂�
-     * @param arr       淇濆瓨椤哄簭灞�
-     * @param d         涓嬫爣
-     * @param locType   鐗╂枡鏄惁涓虹壒娈婄墿鏂�
-     * @param locType1  1.婊℃墭  2.绌烘墭
-     * @return
-     */
-    public LocMast getLocNo2(WaitPakin waitPakin, Integer[] arr, Integer d, Integer locType, Integer locType1) {
-        LocMast locMast = null;
-        //涓�.鏌ヨ鍏ュ簱璐х墿鏄惁鏄壒娈婃憜鏀捐揣鐗�
-        if (locType == 2) {
-            //鏌ユ壘灞傛爣璁扮殑
-            LocMast locMast1 = locMastService.selectOne(new EntityWrapper<LocMast>()
-                    .eq("lev1", arr[d])
-                    .eq("loc_sts", "O")
-                    .eq("loc_type1", 2)
-                    .eq("loc_attribute", 1));
-            if (!Cools.isEmpty(locMast1)) {
-                locMast = locMast1;
-            }
-        } else {
-            List<LocMast> locMasts = new ArrayList<>();
-            //浜�.绌烘爤鏉挎憜鏀捐鍒�
-            //1.璇ュ眰鐩稿悓绌烘爤鏉�
-            //2.鑾峰緱locAttribute搴撲綅灞炴�т负1鐨勬墍鏈夊簱浣�
-            //3.鏌ョ湅缁勯噷鏄惁杩樻湁绌轰綅
-            if (locType1 == 2) {
-                locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
-                        .eq("lev1", arr[d])
-                        .eq("loc_sts", "D")
-                        .eq("loc_type1", 1)
-                        .eq("loc_attribute", 1));
-                if (!Cools.isEmpty(locMasts)) {
-                    for (LocMast locMast1 : locMasts) {
-                        //4.鏌ョ湅璇ョ粍鏄惁鏈夐绾﹀叆搴撳拰棰勭害鍑哄簱鐨勫簱浣嶏紝鏈夌殑璇濈洿鎺ヨ烦杩囪缁�
-                        List<LocMast> locMasts2 = locMastService.selectList(new EntityWrapper<LocMast>()
-                                .eq("group1", locMast1.getGroup1())
-                                .in("loc_sts", "P", "Q", "R", "S"));
-                        if (!Cools.isEmpty(locMasts2)) {
-                            continue;
-                        }
-                        //5.鎵惧嚭鍚屼竴缁勭殑绌哄簱浣�
-                        //6.瀵规繁娴呭簱浣嶈繘琛屾帓搴�
-                        List<LocMast> locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
-                                .eq("group1", locMast1.getGroup1())
-                                .eq("loc_sts", "O")
-                                .orderBy("locAttribute"));
-                        if (Cools.isEmpty(locMasts1)) {
-                            continue;
-                        }
-                        //7.鏌ョ湅
-                        locMast = locMasts1.get(0);
-                    }
-                }
-            } else {
-                //涓�.姝e父璐х墿鍏ュ簱
-                //1.璇ュ眰鐩稿悓鐗╂枡鎽嗘斁
-                //2.鑾峰緱locAttribute搴撲綅灞炴�т负1鐨勬墍鏈夊簱浣�
-                //3.鏌ョ湅缁勯噷鏄惁杩樻湁绌轰綅
-                locMasts = locMastService.querySame(waitPakin.getMatnr(), arr[d]);
-                if (!Cools.isEmpty(locMasts)) {
-                    for (LocMast locMast1 : locMasts) {
-                        //4.鏌ョ湅璇ョ粍鏄惁鏈夐绾﹀叆搴撳拰棰勭害鍑哄簱鐨勫簱浣嶏紝鏈夌殑璇濈洿鎺ヨ烦杩囪缁�
-                        List<LocMast> locMasts2 = locMastService.selectList(new EntityWrapper<LocMast>()
-                                .eq("group1", locMast1.getGroup1())
-                                .in("loc_sts", "P", "Q", "R", "S"));
-                        if (!Cools.isEmpty(locMasts2)) {
-                            continue;
-                        }
-                        //5.鎵惧嚭鍚屼竴缁勭殑绌哄簱浣�
-                        //6.瀵规繁娴呭簱浣嶈繘琛屾帓搴�
-                        List<LocMast> locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
-                                .eq("group1", locMast1.getGroup1())
-                                .eq("loc_sts", "O")
-                                .orderBy("locAttribute"));
-                        if (Cools.isEmpty(locMasts1)) {
-                            continue;
-                        }
-                        //7.鏌ョ湅
-                        locMast = locMasts1.get(0);
-                    }
-                }
-
-            }
-            //鍥�.娌℃湁鐩稿悓鐗╂枡锛岃繘琛屾甯告壘搴�
-            if (Cools.isEmpty(locMast)) {
-                //鏌ユ壘璇ュ眰鎵�鏈夌┖鐨�"loc_attribute",1
-                List<LocMast> locMastList = locMastService.selectList(new EntityWrapper<LocMast>()
-                        .eq("lev1", arr[d])
-                        .eq("loc_sts", "O")
-                        .eq("loc_type1", 1)
-                        .eq("loc_attribute", 1)
-                        .orderBy("row1", false)
-                        .orderBy("bay1", false));
-                if (!Cools.isEmpty(locMastList)) {
-                    locMast = locMastList.get(0);
-                }
-            }
-            //璇ュ眰娌℃湁鎵惧埌搴撲綅鏃惰繘鍏ラ�掑綊鎹㈠眰鎵惧簱浣�
-            if (Cools.isEmpty(locMast)) {
-                if (d > 6) {
-                    throw new CoolException("娌℃湁绌哄簱浣�");
-                }
-                if (d == 6 && locType == 2) {
-                    return getLocNo2(waitPakin, arr, 0, 1, locType1);
-                }
-                return getLocNo2(waitPakin, arr, d++, locType, locType1);
-            }
-        }
-        return locMast;
     }
 
 }

--
Gitblit v1.9.1