From 9c699c554f021930ee3598261f43e6dfd9cccb9c Mon Sep 17 00:00:00 2001
From: lty <876263681@qq.com>
Date: 星期二, 07 一月 2025 08:35:50 +0800
Subject: [PATCH] #拣料盘点优化(仍有回库顺序不同堵塞问题)

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

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 55a2f22..92420c0 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -597,6 +597,157 @@
         return startupDto;
     }
 
+    public StartupDto getLocNoRunPick(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times) {
+        int crnNo = 1;//灏忚溅缂栧彿澶囩敤
+        RowLastno rowLastno = rowLastnoService.selectById(4);
+        LocMast locMast = null;     // 鐩爣搴撲綅
+        StartupDto startupDto = new StartupDto();
+        int curRow = rowLastno.getCurrentRow();
+        int sRow = rowLastno.getsRow();
+        int eRow = rowLastno.geteRow();
+        int nearRow = 8;//鐗规畩鍗曟帓
+        int orbit = 7;//杞ㄩ亾
+        // 鐩镐技宸ヤ綔妗f --- 鍚屽ぉ鍚岃鏍肩墿鏂�
+        if (!Cools.isEmpty(matnr) && (staDescId == 1 || staDescId == 11 || staDescId == 111) ) {
+            //鏌ヨ鐩镐技宸ヤ綔妗f
+            List<WrkMast> wrkMasts = wrkMastService.selectWrkMastWrkDetlMatnrBatch(1, matnr, batch,null, crnNo);
+            for (WrkMast wrkMast:wrkMasts){
+                if (Cools.isEmpty(wrkMast.getLocNo())){
+                    continue;
+                }
+                //鐩爣鎺掍负杞ㄩ亾澶栨帓
+                if (Utils.getRow(wrkMast.getLocNo()) == orbit || Utils.getRow(wrkMast.getLocNo()) == nearRow){
+                    continue;
+                }
+                //鏌ユ壘姝ゅ簱浣嶇殑娴呭簱浣嶆槸鍚︿负绌�
+                int value = Integer.valueOf(wrkMast.getLocNo().substring(0, 2)) + 1;
+                String loc="0"+value+wrkMast.getLocNo().substring(2);
+                LocMast locMast1=locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("loc_no",loc)
+                        .eq("loc_sts","O")
+                        .eq("loc_type1", locTypeDto.getLocType1())
+                );
+                if(Cools.isEmpty(locMast1)){
+                    continue;
+                }
+                locMast=locMast1;
+                break;
+            }
+
+        }
+
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂�
+        if (Cools.isEmpty(locMast)) {
+            List<LocDetl> locNos = locDetlService.getSameDetlToday(matnr, batch,sRow, eRow);
+            for (LocDetl locNo : locNos) {
+                //鐩爣鎺掍负鏈�澶栧眰鎺�
+                if (Utils.getRow(locNo.getLocNo()) == nearRow || Utils.getRow(locNo.getLocNo()) == orbit){
+                    continue;
+                }
+                LocMast locMast2=locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("loc_no",locNo.getLocNo())
+                        .eq("loc_sts","F"));
+                if(Cools.isEmpty(locMast2)){
+                    continue;
+                }
+                int value = Integer.valueOf(locNo.getLocNo().substring(0, 2)) + 1;
+                String loc="0"+value+locNo.getLocNo().substring(2);
+                LocMast locMast1=locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("loc_no",loc)
+                        .eq("loc_sts","O")
+                        .eq("loc_type1", locTypeDto.getLocType1())
+                );
+                if(Cools.isEmpty(locMast1)){
+                    continue;
+                }
+                locMast=locMast1;
+                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;
+                        }
+                    }
+                }
+            }
+        }
+
+        // 鑾峰彇鐩爣绔�
+        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                .eq("type_no", staDescId)
+                .eq("stn_no", sourceStaNo)
+                .eq("crn_no", 1);
+        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.getStnNo());
+        if (!staNo.getAutoing().equals("Y")) {
+            throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+        }
+
+        // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
+        if (null == locMast) {
+            LocMast locMast1 = new LocMast();
+            if(times != 0){
+                locMast1=locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("row1", 1)
+                        .eq("loc_sts","O")
+                        .eq("loc_type1", locTypeDto.getLocType1())
+                        .orderBy("lev1,bay1 ASC"));
+            } else {
+                locMast1=locMastService.selectOne(new EntityWrapper<LocMast>()
+                        .eq("row1", 8)
+                        .eq("loc_sts","O")
+                        .eq("loc_type1", locTypeDto.getLocType1())
+                        .orderBy("lev1,bay1 ASC"));
+            }
+            if(!Cools.isEmpty(locMast1)){
+                locMast=locMast1;
+            }
+        }
+        // 鏇存柊搴撲綅鎺掑彿
+        rowLastno.setCurrentRow(curRow);
+        rowLastnoService.updateById(rowLastno);
+
+        // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
+        if (Cools.isEmpty(locMast)) {
+            times = times - 1;
+            if (times >= 0) {
+                return getLocNoRun4(whsType,staDescId, sourceStaNo, matnr, batch, grade,moveCrnNo,locTypeDto,times);
+            }
+            log.error("绯荤粺娌℃湁绌哄簱浣嶏紒锛侊紒 灏哄瑙勬牸锛� {}锛�", JSON.toJSONString(locTypeDto));
+            throw new CoolException("娌℃湁绌哄簱浣�");
+        }
+        String locNo = locMast.getLocNo();
+        // 杩斿洖鎵惧埌鐨勫簱浣�
+        startupDto.setWorkNo(0);
+        startupDto.setCrnNo(locMast.getCrnNo());
+        startupDto.setSourceStaNo(sourceStaNo);
+        startupDto.setLocNo(locNo);
+
+        return startupDto;
+    }
+
     public StartupDto getLocNoRun5(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times) {
         if (Cools.isEmpty(matnr)) {  //鐗╂枡鍙�
             matnr = "";

--
Gitblit v1.9.1