From 5127f46eedeede5cbfeae7a4908ddac11d332494 Mon Sep 17 00:00:00 2001
From: 野心家 <1051256694@qq.com>
Date: 星期三, 11 六月 2025 17:20:11 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/wz-JiAo-wms' into wz-JiAo-wms

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

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index c67ed78..e3f1e21 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -1,23 +1,30 @@
 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.service.*;
-import com.zy.common.model.Shelves;
+import com.zy.asrs.utils.Utils;
+import com.zy.asrs.utils.VersionUtils;
+import com.zy.common.model.LocTypeDto;
 import com.zy.common.model.StartupDto;
+import com.zy.common.properties.SlaveProperties;
+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.List;
+import java.util.concurrent.atomic.AtomicReference;
 
 /**
  * 璐ф灦鏍稿績鍔熻兘
  * Created by vincent on 2020/6/11
  */
+@Slf4j
 @Service
 public class CommonService {
 
@@ -28,6 +35,8 @@
     @Autowired
     private RowLastnoService rowLastnoService;
     @Autowired
+    private RowLastnoTypeService rowLastnoTypeService;
+    @Autowired
     private BasCrnpService basCrnpService;
     @Autowired
     private StaDescService staDescService;
@@ -37,10 +46,15 @@
     private LocMastService locMastService;
     @Autowired
     private LocDetlService locDetlService;
+    @Autowired
+    private SlaveProperties slaveProperties;
+    @Autowired
+    private WrkDetlService wrkDetlService;
 
     /**
      * 鐢熸垚宸ヤ綔鍙�
-     * @param wrkMk 0:鍏ュ嚭搴� ; 1:鍏朵粬
+     *
+     * @param wrkMk
      * @return workNo(宸ヤ綔鍙�)
      */
     public int getWorkNo(Integer wrkMk) {
@@ -48,179 +62,656 @@
         if (Cools.isEmpty(wrkLastno)) {
             throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
         }
-        int workNo = 0;
-        // 鍏ュ嚭搴撶被鍨�
-        if (wrkLastno.getWrkMk() == 0) {
-            workNo = wrkLastno.getWrkNo();
-            int sNo = wrkLastno.getSNo();
-            int eNo = wrkLastno.getENo();
 
-            workNo = workNo>=eNo ? sNo : workNo+1;
-
-            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);
+        int workNo = wrkLastno.getWrkNo();
+        int sNo = wrkLastno.getSNo();
+        int eNo = wrkLastno.getENo();
+        workNo = workNo >= eNo ? sNo : workNo + 1;
+        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) {
             throw new CoolException("鐢熸垚宸ヤ綔鍙峰け璐ワ紝璇疯仈绯荤鐞嗗憳");
         } else {
-            if (wrkMastService.selectById(workNo)!=null) {
+            if (wrkMastService.selectById(workNo) != null) {
                 throw new CoolException("鐢熸垚宸ヤ綔鍙�" + workNo + "鍦ㄥ伐浣滄。涓凡瀛樺湪");
             }
         }
         return workNo;
     }
 
-    /**
-     * 妫�绱㈠簱浣嶅彿
-     * @param whsType 绫诲瀷 1:鍙屾繁寮忚揣鏋�
-     * @param staDescId 璺緞ID
-     * @param sourceStaNo 婧愮珯
-     * @param matNos 鐗╂枡鍙烽泦鍚�
-     * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
-     */
-    public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos) {
-        if (sourceStaNo == 3) {
-            whsType = 1;
-        } else if (sourceStaNo == 7) {
-            whsType = 2;
-        } else {
-            throw new CoolException("鏃犳晥鍏ュ簱绔�");
-        }
+    //鎷嗙洏鏈哄绌烘澘鎵爜锛岄┍鍔ㄦ墭鐩樺悜鐮佸灈浣嶏紝涓嶅叆搴�
+    @Transactional
+    public StartupDto getScanBarcodeEmptyBoard() {
         StartupDto startupDto = new StartupDto();
-        RowLastno rowLastno = rowLastnoService.selectById(whsType);
-        if (Cools.isEmpty(rowLastno)) {
-            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
+        Integer staNo = 0;
+        if (wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("io_type", 201).eq("staNo", 216)) < 2) {
+            staNo = 216;
         }
-        if (whsType == 1 || whsType == 2){
-            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;
-
-            // 鍚屼竴澶╁悓瑙勬牸璐х墿闈犺繎鎽嗘硶瑙勫垯 todo:luxiaotao
-//            if (!Cools.isEmpty(matNos)) {
-//                List<String> locNos = locDetlService.getSameDetlToday(matNos.get(0));
-//                for (String locNo : locNos) {
-//                    // 鑾峰彇鎺�
-//                    int row = Integer.parseInt(locNo.substring(0, 2));
-//                    // 鍒ゆ柇鏄惁涓烘繁搴撲綅
-//                    double remainder = Arith.remainder(row, rowCount / crn_qty);
-//                    int targetRow;
-//                    if (remainder == 1) {
-//                        // 寰楀埌褰撳墠搴撲綅鐨勫鍥村簱浣�
-//                        targetRow =  row + 1;
-//                    } else if (remainder == 0) {
-//                        // 寰楀埌褰撳墠搴撲綅鐨勫唴鍥村簱浣�
-//                        targetRow =  row - 1;
-//                    } else {
-//                        continue;
-//                    }
-//                    String targetLocNo = zerofill(String.valueOf(targetRow), 2)+locNo.substring(2);
-//                    // 妫�娴嬬洰鏍囧簱浣嶆槸鍚︿负绌哄簱浣�
-//                    LocMast targetLocMast = locMastService.selectById(targetLocNo);
-//                    if (targetLocMast != null && targetLocMast.getLocSts().equals("O")) {
-//                        locMast = targetLocMast;
-//                        crnNo = locMast.getCrnNo();
-//                        break;
-//                    }
-//                }
-//            }
-
-            // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-            if (null == locMast) {
-                // 鑾峰彇鐩爣绔欐墍鍦ㄨ揣鏋舵帓鍙�  todo:luxiaotao
-                if (curRow == sRow) {
-                    curRow = eRow;
-                } else {
-                    curRow = sRow;
-                }
-                crnNo = whsType;
-//                Shelves shelves = new Shelves(rowCount, crn_qty);
-//                curRow = shelves.start(curRow);
-//                if (curRow < 0) {
-//                    throw new CoolException("妫�绱㈠簱浣嶅け璐ワ紝璇疯仈绯荤鐞嗗憳");
-//                }
-//                for (List<Integer> node : shelves.nodes){
-//                    if (node.contains(curRow)) {
-//                        crnNo = shelves.nodes.indexOf(node) + 1;
-//                        break;
-//                    }
-//                }
-            }
-
-            basCrnpService.checkSiteStatus(crnNo);
-            // 鑾峰彇鐩爣绔�
-            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)) {
-                throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
-            }
-            BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
-            int inQty = staNo.getInQty()==null?0:staNo.getInQty();
-            if (staNo.getAutoing().equals("Y") && inQty<2) {
-                // 鏌ユ壘搴撲綅
-                if (locMast == null) {
-                    locMast = locMastService.queryFreeLocMast(curRow);
-                }
-                if (Cools.isEmpty(locMast)) {
-                    throw new CoolException("娌℃湁绌哄簱浣�");
-                }
-                String locNo = locMast.getLocNo();
-
-                // 鏇存柊搴撲綅鎺掑彿
-                rowLastno.setCurrentRow(curRow);
-                rowLastnoService.updateById(rowLastno);
-
-                // 杩斿洖dto
-                startupDto.setCrnNo(crnNo);
-                startupDto.setSourceStaNo(sourceStaNo);
-                startupDto.setStaNo(staNo.getDevNo());
-                startupDto.setLocNo(locNo);
-            } else {
-                throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
-            }
-        } else {
-            throw new CoolException(rowLastno.getWhsType()+"鍙峰簱浣嶆帓鍙峰垎閰嶈鍒欎笉鍙敤");
+        if (wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("io_type", 201).eq("staNo", 220)) < 2) {
+            staNo = 220;
         }
+
+        startupDto.setStaNo(staNo);
         return startupDto;
     }
 
-    public static void main(String[] args) {
-        System.out.println(Arith.remainder(1, 4));
-        System.out.println("0200201".substring(0, 2));
-        String locNo = "0800201";
-        int row = Integer.parseInt(locNo.substring(0, 2));
-        double remainder = Arith.remainder(row, 4);
-        int targetRow;
-        if (remainder == 1) {
-            // 寰楀埌褰撳墠搴撲綅鐨勫鍥村簱浣�
-            targetRow =  row + 1;
-        } else if (remainder == 0) {
-            // 寰楀埌褰撳墠搴撲綅鐨勫唴鍥村簱浣�
-            targetRow =  row - 1;
-        } else {
-            return;
+    /**
+     * 妫�绱㈠簱浣嶅彿
+     *
+     * @param staDescId   璺緞ID
+     * @param sourceStaNo 婧愮珯
+     * @param matnr       鐗╂枡鍙烽泦鍚�
+     * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
+     */
+    @Transactional
+    public StartupDto getLocNo(Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, LocTypeDto locTypeDto) {
+        try {
+            Integer whsType = Utils.GetWhsType(sourceStaNo);
+            RowLastno rowLastno = rowLastnoService.selectById(whsType);
+            RowLastnoType rowLastnoType = rowLastnoTypeService.selectById(rowLastno.getTypeId());
+            /**
+             * 搴撳瀷 1: 鏍囧噯鍫嗗灈鏈哄簱  2: 骞冲簱  3: 绌挎鏉�  4: 鍥涘悜杞�  5: AGV  0: 鏈煡
+             */
+            switch (rowLastnoType.getType()) {
+                case 4:
+                    return getLocNoRun4(whsType, staDescId, sourceStaNo, matnr, batch, grade, 4, locTypeDto, 0);
+            }
+
+        } catch (Exception e) {
+            log.error("绔欑偣={} 鏈煡璇㈠埌瀵瑰簲鐨勮鍒�", sourceStaNo);
         }
-        String zerofill = zerofill(String.valueOf(targetRow), 2)+locNo.substring(2);
-        System.out.println(zerofill);
+        return null;
+    }
+
+    /**
+     * 妫�绱㈠簱浣嶅彿
+     *
+     * @param whsType     绫诲瀷 1:鍙屾繁寮忚揣鏋�
+     * @param staDescId   璺緞ID
+     * @param sourceStaNo 婧愮珯
+     * @param matnr       鐗╂枡鍙烽泦鍚�
+     * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
+     */
+    @Transactional
+    public StartupDto getLocNoRun(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times) {
+        if (Cools.isEmpty(matnr)) {  //鐗╂枡鍙�
+            matnr = "";
+        }
+        if (Cools.isEmpty(batch)) {  //鎵规
+            batch = "";
+        }
+        if (Cools.isEmpty(grade)) {  //澶囩敤
+            grade = "";
+        }
+
+        // 鍒濆鍖栧弬鏁�
+        int crnNo = 0;      //鍫嗗灈鏈哄彿
+        int nearRow = 0;    //鏈�娴呭簱浣嶆帓
+        int curRow = 0;     //鏈�娣卞簱浣嶆帓
+        int rowCount = 0;   //杞杞
+        LocMast locMast = null;     // 鐩爣搴撲綅
+
+        StartupDto startupDto = new StartupDto();
+        RowLastno rowLastno = rowLastnoService.selectById(whsType);
+        if (Cools.isEmpty(rowLastno)) {
+            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===>搴撲綅瑙勫垯鏈煡");
+        }
+        RowLastnoType rowLastnoType = rowLastnoTypeService.selectById(rowLastno.getTypeId());
+        if (Cools.isEmpty(rowLastnoType)) {
+            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===銆嬪簱浣嶈鍒欑被鍨嬫湭鐭�");
+        }
+        int sRow = rowLastno.getsRow();
+        int eRow = rowLastno.geteRow();
+        int crnNumber = rowLastno.getCrnQty();
+
+
+        // ===============>>>> 寮�濮嬫墽琛�
+        curRow = rowLastno.getCurrentRow();
+
+        if (!Cools.isEmpty(moveCrnNo) && moveCrnNo != 0) {
+            crnNumber = moveCrnNo;
+            if (times == 0) {
+                curRow = moveCrnNo * 4 - 1;
+            } else {
+                curRow = moveCrnNo * 4 - 2;
+            }
+        }
+
+        //姝ょ▼搴忕敤浜庝紭鍖栧爢鍨涙満寮傚父鏃剁殑杩愯鏃堕棿
+        for (int i = times; i < crnNumber * 2; i++) {
+            int[] locNecessaryParameters = Utils.LocNecessaryParameters(rowLastno, curRow, crnNumber);
+            curRow = locNecessaryParameters[1];
+            crnNo = locNecessaryParameters[2];
+            if (basCrnpService.checkSiteError(crnNo, true)) {
+                rowCount = locNecessaryParameters[0];
+                nearRow = locNecessaryParameters[3];
+                List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("row1", nearRow).eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue()));
+                int crnCountO = wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("crn_no", crnNo).le("io_type", 100));
+                if (locMasts.size() - crnCountO <= 2) {
+                    times++;
+                    continue;
+                }
+                break;
+            } else {
+                times++;
+            }
+        }
+        if (nearRow == 0) {
+            throw new CoolException("鏃犲彲鐢ㄥ爢鍨涙満");
+        }
+
+        boolean signRule1 = false;
+        boolean signRule2 = false;
+
+
+        if (Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+            // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂� //鍒嗙鐗�
+            if (!Cools.isEmpty(matnr) && staDescId == 1) {
+                signRule1 = true;
+            }
+            // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂� //浜掗�氱増
+            if (!Cools.isEmpty(matnr) && staDescId == 1) {
+                signRule2 = true;
+            }
+
+            if (!Cools.isEmpty(matnr) && (staDescId == 11 || staDescId == 111)) {
+                signRule1 = true;
+            }
+        }
+
+        if (signRule1) {
+            if (nearRow != curRow) {
+                List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("row1", nearRow).eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue()));
+                for (LocMast locMast1 : locMasts) {
+                    //鑾峰彇宸烽亾
+//                    List<String> groupOutsideLocCrn = Utils.getGroupOutLocCrn(curRow,nearRow,locMast1.getLocNo(), curRow>nearRow);
+//                    LocMast locMastGro = locMastService.selectById(wrkMast.getLocNo());
+                    //鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娴呴潪绌哄簱浣�
+                    LocMast locMastF = locMastService.selectLocByLocStsPakInF(curRow, nearRow, locMast1, rowLastnoType.getType().longValue());
+                    if (!Cools.isEmpty(locMastF) && locMastF.getLocSts().equals("F")) {
+                        LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", locMastF.getLocNo()));
+                        if (!Cools.isEmpty(locDetl) && matnr.equals(locDetl.getMatnr())
+                                && batch.equals(batch.isEmpty() ? "" : locDetl.getBatch())
+                                && grade.equals(grade.isEmpty() ? "" : locDetl.getBrand())) {
+                            //鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娣辩┖搴撲綅
+                            locMast = locMastService.selectLocByLocStsPakInO(curRow, nearRow, locMast1, rowLastnoType.getType().longValue());
+                            break;
+                        }
+                    }
+                }
+            }
+        } else if (signRule2) {
+            List<String> locNos = locDetlService.getSameDetlToday(matnr, 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.locMoveCheckLocTypeComplete(shallowLoc, locTypeDto)) {
+                        if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) {
+                            locMast = shallowLoc;
+                            crnNo = locMast.getCrnNo();
+                            break;
+                        }
+                    }
+                }
+            }
+        }
+
+//        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭  //鍒嗙鐗�
+//        if (staDescId == 10 && Utils.BooleanWhsTypeStaIoType(whsType)) {
+//            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("row1", nearRow).eq("loc_sts", "O"));
+//            for (LocMast locMast1:locMasts){
+//                if (VersionUtils.locMoveCheckLocTypeComplete(locMast1, locTypeDto)) {
+//                    continue;
+//                }
+//                String shallowLoc = Utils.getDeepLoc(slaveProperties,locMast1.getLocNo());
+//                LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no",shallowLoc));
+//                if (!Cools.isEmpty(locMast2) && locMast2.getLocSts().equals("D")){
+//                    locMast = locMast1;
+//                    break;
+//                }
+//            }
+//        }
+
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭 //浜掗�氱増
+        if (staDescId == 10 && Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("loc_sts", "D").ge("row1", sRow).le("row1", eRow).eq("whs_type", rowLastnoType.getType().longValue()));
+            if (!locMasts.isEmpty()) {
+                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 (VersionUtils.locMoveCheckLocTypeComplete(shallowLoc, locTypeDto)) {
+                            if (basCrnpService.checkSiteError(shallowLoc.getCrnNo(), true)) {
+                                locMast = shallowLoc;
+                                crnNo = locMast.getCrnNo();
+                                break;
+                            }
+                        }
+                    }
+                }
+            }
+        }
+
+        Wrapper<StaDesc> wrapper = null;
+        StaDesc staDesc = null;
+        BasDevp staNo = null;
+
+        if (Utils.BooleanWhsTypeSta(rowLastno, staDescId)) {
+            // 鑾峰彇鐩爣绔�
+            wrapper = new EntityWrapper<StaDesc>()
+                    .eq("type_no", staDescId)
+                    .eq("stn_no", sourceStaNo)
+                    .eq("crn_no", crnNo);
+            staDesc = staDescService.selectOne(wrapper);
+            if (Cools.isEmpty(staDesc)) {
+                log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
+//                throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+                crnNo = 0;
+            } else {
+                staNo = basDevpService.selectById(staDesc.getCrnStn());
+                if (!staNo.getAutoing().equals("Y")) {
+                    log.error("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
+//                throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+                    crnNo = 0;
+                }
+                startupDto.setStaNo(staNo.getDevNo());
+            }
+            // 鏇存柊搴撲綅鎺掑彿
+            if (Cools.isEmpty(locMast)) {
+                rowLastno.setCurrentRow(curRow);
+                rowLastnoService.updateById(rowLastno);
+            }
+        }
+
+        // 寮�濮嬫煡鎵惧簱浣� ==============================>>
+
+        // 1.鎸夎鍒欐煡鎵惧簱浣�
+        if (Cools.isEmpty(locMast) && crnNo != 0) {
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("row1", nearRow)
+                    .eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue())
+                    .orderBy("lev1", true).orderBy("bay1", true));
+            for (LocMast locMast1 : locMasts) {
+                if (!VersionUtils.locMoveCheckLocTypeComplete(locMast1, locTypeDto)) {
+                    continue;
+                }
+                if (Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+                    String shallowLoc = Utils.getDeepLoc(slaveProperties, locMast1.getLocNo());
+                    LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                            .eq("loc_no", shallowLoc).eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue()));
+                    if (!Cools.isEmpty(locMast2)) {
+                        locMast = locMast2;
+                        break;
+                    }
+                } else {
+                    if (!Cools.isEmpty(locMast1)) {
+                        locMast = locMast1;
+                        break;
+                    }
+                }
+            }
+
+            if (Cools.isEmpty(locMast) && Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+                for (LocMast locMast1 : locMasts) {
+                    if (!VersionUtils.locMoveCheckLocTypeComplete(locMast1, locTypeDto)) {
+                        continue;
+                    }
+                    if (Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+                        String shallowLoc = Utils.getDeepLoc(slaveProperties, locMast1.getLocNo());
+                        LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                                .eq("loc_no", shallowLoc).eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue()));
+                        if (!Cools.isEmpty(locMast2)) {
+                            locMast = locMast2;
+                            break;
+                        } else {
+                            locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                                    .eq("loc_no", shallowLoc).eq("loc_sts", "F").eq("whs_type", rowLastnoType.getType().longValue()));
+                            if (!Cools.isEmpty(locMast2)) {
+                                locMast = locMast1;
+                                break;
+                            } else {
+                                locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                                        .eq("loc_no", shallowLoc).eq("loc_sts", "D").eq("whs_type", rowLastnoType.getType().longValue()));
+                                if (!Cools.isEmpty(locMast2)) {
+                                    locMast = locMast1;
+                                    break;
+                                }
+                            }
+                        }
+                    } else {
+                        if (!Cools.isEmpty(locMast1)) {
+                            locMast = locMast1;
+                            break;
+                        }
+                    }
+                }
+            }
+        }
+
+        if (!Cools.isEmpty(locMast) && !basCrnpService.checkSiteError(crnNo, true)) {
+            locMast = null;
+        }
+
+        // 閫掑綊鏌ヨ
+        if (Cools.isEmpty(locMast) || !locMast.getLocSts().equals("O")) {
+            // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
+            if (times < rowCount * 2) {
+                times = times + 1;
+                return getLocNoRun(whsType, staDescId, sourceStaNo, matnr, batch, grade, moveCrnNo, locTypeDto, times);
+            }
+//            // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣�
+//            if (locTypeDto.getLocType1() < 2) {
+//                int i = locTypeDto.getLocType1() + 1;
+//                locTypeDto.setLocType1((short)i);
+//                return getLocNo(1, staDescId, sourceStaNo, matnr,batch,grade, locTypeDto, 0);
+//            }
+            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.setLocNo(locNo);
+        return startupDto;
+    }
+
+    public StartupDto getLocNoRun4(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times) {
+        int rowCount = 0;   //杞杞
+        int crnNo = 0;
+        LocMast locMast = null;     // 鐩爣搴撲綅
+        StartupDto startupDto = new StartupDto();
+
+
+        if (!Cools.isEmpty(matnr) && staDescId != 10) {
+            int lev = 0;
+//            List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("matnr", matnr));
+//            if (!Cools.isEmpty(locDetls)){
+//                for (LocDetl locDetl : locDetls){
+//                    if (locMast != null){
+//                        break;
+//                    }
+//                    LocMast locMast1 = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", locDetl.getLocNo()));
+//                    if (Cools.isEmpty(locMast1)) {
+//                        continue;
+//                    }
+//                    if (locMast1.getLev1() != lev && locMast1.getLev1() !=3) {
+//                        List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+//                                .eq("lev1", locMast1.getLev1())
+//                                .orderBy("bay1",false));
+//                        if (Cools.isEmpty(locMasts)){
+//                            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===銆嬪簱浣嶆湭鐭�");
+//                        }
+//                        for (LocMast locMast2 : locMasts) {
+//                            if (locMast2.getLocSts().equals("O") ) {
+//                                if (locMast == null){
+//                                    locMast = locMast2;
+//                                }
+//                            }else if (locMast2.getLocSts().equals("F")){
+//                                locMast = null;
+//                            }
+//                        }
+//                    }
+//                }
+//                if(Cools.isEmpty(locMast)){
+//                    List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+//                            .eq("lev1", 1)
+//                            .orderBy("bay1",false));
+//                    for (LocMast locMast2 : locMasts) {
+//                        if (locMast2.getLocSts().equals("O") ) {
+//                            if (locMast == null){
+//                                locMast = locMast2;
+//                            }
+//                        }else if (locMast2.getLocSts().equals("F")){
+//                            locMast = null;
+//                        }
+//                    }
+//                }
+//                if(Cools.isEmpty(locMast)){
+//                    List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+//                            .eq("lev1", 2)
+//                            .orderBy("bay1",false));
+//                    for (LocMast locMast2 : locMasts) {
+//                        if (locMast2.getLocSts().equals("O") ) {
+//                            if (locMast == null){
+//                                locMast = locMast2;
+//                            }
+//                        }else if (locMast2.getLocSts().equals("F")){
+//                            locMast = null;
+//                        }
+//                    }
+//                }
+//            }else {
+            for (int i = 1; i <= 2; i++) {
+                if (locMast != null) {
+                    break;
+                }
+//                List<LocMast> locMastsF = locMastService.selectList(new EntityWrapper<LocMast>()
+//                        .eq("lev1", i)
+//                        .eq("loc_sts", "F"));
+//                if (!Cools.isEmpty(locMastsF)) {
+//                    continue;
+//                }
+                List<LocMast> locMastsR = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("lev1", i)
+                        .eq("loc_sts", "R"));
+                if (!Cools.isEmpty(locMastsR)) {
+                    WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("loc_no", locMastsR.get(0).getLocNo()));
+                    if (Cools.isEmpty(wrkMast)) {
+                        continue;
+                    }
+                    List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
+                    if (!wrkDetls.get(0).getMatnr().equals(matnr)) {
+                        continue;
+                    }
+                }
+                List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                        .eq("lev1", i)
+                        .orderBy("bay1", false));
+                if (Cools.isEmpty(locMasts)) {
+                    throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===銆嬪簱浣嶆湭鐭�");
+                }
+                for (LocMast locmast3 : locMasts) {
+                    if (locmast3.getLocSts().equals("O")) {
+                        if (locMast == null) {
+                            locMast = locmast3;
+                        }
+                    } else if (locmast3.getLocSts().equals("F")) {
+                        locMast = null;
+                    }
+                }
+            }
+//            }
+        } else {
+            //绌烘澘鍏ュ簱
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("lev1", 3)
+                    .orderBy("bay1", true));
+            if (Cools.isEmpty(locMasts)) {
+                throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===銆嬪簱浣嶆湭鐭�");
+            }
+            for (LocMast locmast : locMasts) {
+                if (locmast.getLocSts().equals("O")) {
+                    if (locMast == null) {
+                        locMast = locmast;
+                    }
+                } else if (locmast.getLocSts().equals("D")) {
+                    locMast = null;
+                }
+            }
+        }
+
+
+        // 閫掑綊鏌ヨ
+        if (Cools.isEmpty(locMast) || !locMast.getLocSts().equals("O")) {
+            // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
+            if (times < rowCount * 2) {
+                times = times + 1;
+                return getLocNoRun4(whsType, staDescId, sourceStaNo, matnr, batch, grade, moveCrnNo, 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(1);
+        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 = "";
+        }
+        if (Cools.isEmpty(batch)) {  //鎵规
+            batch = "";
+        }
+        if (Cools.isEmpty(grade)) {  //澶囩敤
+            grade = "";
+        }
+
+        // 鍒濆鍖栧弬鏁�
+        int crnNo = 0;      //鍫嗗灈鏈哄彿
+        int nearRow = 0;    //鏈�娴呭簱浣嶆帓
+        int curRow = 0;     //鏈�娣卞簱浣嶆帓
+        int rowCount = 0;   //杞杞
+        LocMast locMast = null;     // 鐩爣搴撲綅
+
+        StartupDto startupDto = new StartupDto();
+        RowLastno rowLastno = rowLastnoService.selectById(whsType);
+        if (Cools.isEmpty(rowLastno)) {
+            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===>搴撲綅瑙勫垯鏈煡");
+        }
+        RowLastnoType rowLastnoType = rowLastnoTypeService.selectById(rowLastno.getTypeId());
+        if (Cools.isEmpty(rowLastnoType)) {
+            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�===銆嬪簱浣嶈鍒欑被鍨嬫湭鐭�");
+        }
+        int sRow = rowLastno.getsRow();
+        int eRow = rowLastno.geteRow();
+        int crnNumber = eRow - sRow + 1;
+
+        // ===============>>>> 寮�濮嬫墽琛�
+        curRow = rowLastno.getCurrentRow();
+
+        if (!Cools.isEmpty(moveCrnNo) && moveCrnNo != 0) {
+            crnNumber = moveCrnNo;
+        }
+
+        //姝ょ▼搴忕敤浜庝紭鍖栧爢鍨涙満寮傚父鏃剁殑杩愯鏃堕棿
+        int[] locNecessaryParameters = Utils.LocNecessaryParameters(rowLastno, curRow, crnNumber);
+        curRow = locNecessaryParameters[1];
+        crnNo = locNecessaryParameters[2];
+        rowCount = locNecessaryParameters[0];
+        nearRow = locNecessaryParameters[3];
+
+        Wrapper<StaDesc> wrapper = null;
+        StaDesc staDesc = null;
+        BasDevp staNo = null;
+
+        if (Utils.BooleanWhsTypeSta(rowLastno, staDescId)) {
+            // 鑾峰彇鐩爣绔�
+            wrapper = new EntityWrapper<StaDesc>()
+                    .eq("type_no", staDescId)
+                    .eq("stn_no", sourceStaNo)
+                    .eq("crn_no", crnNo);
+            staDesc = staDescService.selectOne(wrapper);
+            if (Cools.isEmpty(staDesc)) {
+                log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo);
+//                throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+                crnNo = 0;
+            } else {
+                staNo = basDevpService.selectById(staDesc.getCrnStn());
+                if (!staNo.getAutoing().equals("Y")) {
+                    log.error("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
+//                throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�");
+                    crnNo = 0;
+                }
+                startupDto.setStaNo(staNo.getDevNo());
+            }
+        }
+
+        // 鏇存柊搴撲綅鎺掑彿
+        if (Utils.BooleanWhsTypeSta(rowLastno, staDescId) && Cools.isEmpty(locMast)) {
+            rowLastno.setCurrentRow(curRow);
+            rowLastnoService.updateById(rowLastno);
+        }
+
+        // 寮�濮嬫煡鎵惧簱浣� ==============================>>
+
+        // 1.鎸夎鍒欐煡鎵惧簱浣�
+        if (Cools.isEmpty(locMast) && crnNo != 0) {
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("row1", nearRow)
+                    .eq("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue())
+                    .orderBy("lev1", true).orderBy("bay1", true));//鏈�娴呭簱浣�
+            for (LocMast locMast1 : locMasts) {
+                if (!VersionUtils.locMoveCheckLocTypeComplete(locMast1, locTypeDto)) {
+                    continue;
+                }
+                if (Utils.BooleanWhsTypeStaIoType(rowLastno)) {
+                    //鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娣辩┖搴撲綅
+                    LocMast locMast2 = locMastService.selectLocByLocStsPakInO(curRow, nearRow, locMast1, rowLastnoType.getType().longValue());
+                    if (!Cools.isEmpty(locMast2) && locMast2.getBay1() == curRow) {
+                        locMast = locMast2;
+                        break;
+                    }
+                }
+            }
+        }
+
+        // 閫掑綊鏌ヨ
+        if (Cools.isEmpty(locMast) || !locMast.getLocSts().equals("O")) {
+            // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊
+            if (times < rowCount * 2) {
+                times = times + 1;
+                return getLocNoRun5(whsType, staDescId, sourceStaNo, matnr, batch, grade, moveCrnNo, 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.setLocNo(locNo);
+        return startupDto;
     }
 
     public static String zerofill(String msg, Integer count) {
@@ -230,11 +721,11 @@
             return msg.substring(0, 16);
         } else {
             StringBuilder msgBuilder = new StringBuilder(msg);
-            for(int i = 0; i < count - msg.length(); ++i) {
+            for (int i = 0; i < count - msg.length(); ++i) {
                 msgBuilder.insert(0, "0");
             }
             return msgBuilder.toString();
         }
     }
 
-}
\ No newline at end of file
+}

--
Gitblit v1.9.1