From e50df1e195336c91da9cc74168e7a7bfeb037f93 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期四, 28 十二月 2023 08:39:13 +0800
Subject: [PATCH] #

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

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 1986fe9..66813da 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -1,5 +1,6 @@
 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;
@@ -7,10 +8,16 @@
 import com.core.exception.CoolException;
 import com.zy.asrs.entity.*;
 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.model.enums.WorkNoType;
+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;
 
@@ -18,6 +25,7 @@
  * 璐ф灦鏍稿績鍔熻兘
  * Created by vincent on 2020/6/11
  */
+@Slf4j
 @Service
 public class CommonService {
 
@@ -37,30 +45,18 @@
     private LocMastService locMastService;
     @Autowired
     private LocDetlService locDetlService;
+    @Autowired
+    private SlaveProperties slaveProperties;
 
     /**
      * 鐢熸垚宸ヤ綔鍙�
-     * @param wrkMk 0:鍏ュ簱 1 - 3000 ; 1:鎷f枡/骞舵澘/鐩樼偣 3001 - 6000 ; 2: 鍑哄簱 6001 -9000 ; 3:鍏朵粬 9001 -9999
+     * @param wrkMk
      * @return workNo(宸ヤ綔鍙�)
      */
     public int getWorkNo(Integer wrkMk) {
         WrkLastno wrkLastno = wrkLastnoService.selectById(wrkMk);
         if (Cools.isEmpty(wrkLastno)) {
             throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
-        }
-
-        // 绫诲瀷
-        switch (wrkMk) {
-            case 0:     // 鍏ュ簱 1 - 3000
-                break;
-            case 1:     // 鎷f枡/骞舵澘/鐩樼偣 3001 - 6000
-                break;
-            case 2:     // 鍑哄簱 6001 -9000
-                break;
-            case 3:     // 鍏朵粬 9001 -9999
-                break;
-            default:
-                break;
         }
 
         int workNo = wrkLastno.getWrkNo();
@@ -94,112 +90,196 @@
     /**
      * 妫�绱㈠簱浣嶅彿
      * @param whsType 绫诲瀷 1:鍙屾繁寮忚揣鏋�
-     * @param staDescId 璺緞ID
+     * @param staDescId 璺緞宸ヤ綔绫诲瀷
      * @param sourceStaNo 婧愮珯
-     * @param matNos 鐗╂枡鍙烽泦鍚�
+
      * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿
      */
-    public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos) {
+    @Transactional
+    public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch, String grade, Integer moveCrnNo, LocTypeDto locTypeDto, int times) {
+        // 鐩爣搴撲綅
+        LocMast locMast = null;
+
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
+        locMast = getLocNoStep4(staDescId, locTypeDto, sourceStaNo);
+        if (locMast != null) {
+            //鎵惧埌搴撲綅锛岃繑鍥瀌to
+            return getLocNoStep6(staDescId, sourceStaNo, locMast);//杩斿洖dto
+        }
+
+        //搴撲綅瑙勫垯
+//        locMast = getLocNoStepRule(matnr, locTypeDto);
+//        if (locMast != null) {
+//            //鎵惧埌搴撲綅锛岃繑鍥瀌to
+//            return getLocNoStep6(staDescId, sourceStaNo, locMast);//杩斿洖dto
+//        }
+
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 鐩稿悓璁㈠崟鍙�, 鍚屽ぉ鍚岃鏍肩墿鏂�
+        locMast = getLocNoStep3(staDescId, matnr, batch, grade, locTypeDto,sourceStaNo);
+        if (locMast != null) {
+            //鎵惧埌搴撲綅锛岃繑鍥瀌to
+            return getLocNoStep6(staDescId, sourceStaNo, locMast);//杩斿洖dto
+        }
+
+        //鎼滅储鏁翠釜绌哄簱浣嶇粍
+        locMast = getLocNoStepSingle(locTypeDto,sourceStaNo);
+        if (locMast != null) {
+            //鎵惧埌搴撲綅锛岃繑鍥瀌to
+            return getLocNoStep6(staDescId, sourceStaNo, locMast);//杩斿洖dto
+        }
+
+        //鎵句笉鍒板簱浣嶏紝鎶涘嚭寮傚父
+        throw new CoolException("娌℃湁绌哄簱浣�");
+
+    }
+
+    // 鎼滅储鍗曞搧(鏁翠釜搴撲綅缁�)
+    private LocMast getLocNoStepSingle(LocTypeDto locTypeDto,Integer sourceStaNo) {
+        LocMast locMast = null;
+        StaDesc staDesc = staDescService.selectOne(new EntityWrapper<StaDesc>().eq("type_no", 1).eq("stn_no", sourceStaNo));
+        //鍗曞搧
+        List<LocMast> locMasts = locMastService.selectAreaEmpty(locTypeDto.getLocType1(),staDesc.getCrnNo());//鎼滅储璐х墿
+
+        for (LocMast mast : locMasts) {
+            List<String> groupLoc = Utils.getGroupLocNo(mast.getLocNo(), true);
+            if (!locMastService.checkAllLocEmpty(groupLoc)) {
+                continue;
+            }
+
+            LocMast tmp = null;
+            for (String loc : groupLoc) {
+                LocMast locMast1 = locMastService.selectByLoc(loc);
+                if (locMast1 == null) {
+                    continue;
+                }
+
+                if (!locMast1.getLocSts().equals("O")) {
+                    continue;
+                }
+
+                tmp = locMast1;
+                break;
+            }
+
+            //棰勭暀绌哄簱浣�
+            if (tmp != null && locMastService.checkEmptyCount(mast, 10)) {
+                locMast = tmp;
+                break;
+            }
+        }
+
+        return locMast;
+    }
+    // 闈犺繎鎽嗘斁瑙勫垯 --- 鐩稿悓璁㈠崟鍙�, 鍚屽ぉ鍚岃鏍肩墿鏂�
+    private LocMast getLocNoStep3(Integer staDescId, String matnr, String batch, String grade, LocTypeDto locTypeDto,Integer sourceStaNo) {
+        LocMast locMast = null;
+        StaDesc staDesc = staDescService.selectOne(new EntityWrapper<StaDesc>().eq("type_no", 1).eq("stn_no", sourceStaNo));
+        if (staDescId == 1) {
+            //鍏堝垽鏂伐浣滄。锛屾煡鎵句富妗OType=1锛� wrkSts < 10鐨勫伐浣滄槑缁嗭紝鏂欏彿鐩稿悓鐨勬槑缁嗗簱浣�
+            List<WrkMast> wrkMasts = wrkMastService.selectSameMatnrs(matnr, batch, grade);
+            for (WrkMast wrkMast : wrkMasts) {
+                LocMast locMast0 = locMastService.findNearloc(wrkMast.getLocNo());
+                if (null != locMast0) {
+                    if (!staDesc.getCrnNo().equals(locMast0.getCrnNo())){
+                        continue;
+                    }
+                    // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                    if (VersionUtils.checkLocType(locMast0, locTypeDto)) {
+                        locMast = locMast0;
+                    }
+                }
+            }
+            if (Cools.isEmpty(locMast)) {
+                //鍐嶅垽鏂簱瀛樻槑缁嗘。锛屾枡鍙风浉鍚岀殑鏄庣粏搴撲綅
+                List<String> locNos = locDetlService.getSameDetl(matnr, batch, grade);
+                for (String locNo : locNos) {
+                    LocMast locMast0 = locMastService.findNearloc(locNo);
+                    if (null != locMast0) {
+                        if (!staDesc.getCrnNo().equals(locMast0.getCrnNo())){
+                            continue;
+                        }
+                        // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                        if (VersionUtils.checkLocType(locMast0, locTypeDto)) {
+                            locMast = locMast0;
+                            break;
+                        }
+                    }
+                }
+            }
+        }
+
+        return locMast;
+    }
+
+
+    //杩斿洖dto
+    private StartupDto getLocNoStep6(Integer staDescId, Integer sourceStaNo, LocMast locMast) {
         StartupDto startupDto = new StartupDto();
+        // 鑾峰彇鐩爣绔�
+        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("鍏ュ簱璺緞涓嶅瓨鍦�, staDescId={}, sourceStaNo={}", staDescId, sourceStaNo);
+            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+        }
+
+        // 妫�娴嬬洰鏍囩珯
+        BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn());
+        if (!staNo.getAutoing().equals("Y")) {
+            throw new CoolException("鐩爣绔�" + staDesc.getCrnStn() + "涓嶅彲鐢�");
+        }
+
         // 鐢熸垚宸ヤ綔鍙�
-        int workNo = getWorkNo(WorkNoType.getWorkNoType(staDescId));
+        int workNo = getWorkNo(0);
+        // 杩斿洖dto
         startupDto.setWorkNo(workNo);
-        RowLastno rowLastno = rowLastnoService.selectById(whsType);
-        if (Cools.isEmpty(rowLastno)) {
-            throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�");
-        }
-        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;
-
-            // 濡傛灉娌℃湁鐩歌繎鐗╂枡锛屽垯鎸夎鍒欒疆璇㈣揣鏋�
-            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()+"鍙峰簱浣嶆帓鍙峰垎閰嶈鍒欎笉鍙敤");
-        }
+        startupDto.setSourceStaNo(sourceStaNo);
+        startupDto.setStaNo(staNo.getDevNo());
+        startupDto.setLocNo(locMast.getLocNo());
+        startupDto.setCrnNo(locMast.getCrnNo());
         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;
+    // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
+    private LocMast getLocNoStep4(Integer staDescId, LocTypeDto locTypeDto, Integer sourceStaNo) {
+        LocMast locMast = null;
+        // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭
+        if (staDescId == 10) {
+            // 鑾峰彇鐩爣绔�
+            Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                    .eq("type_no", staDescId)
+                    .eq("stn_no", sourceStaNo);
+            StaDesc staDesc = staDescService.selectOne(wrapper);
+            if (staDesc == null) {
+                throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�");
+            }
+
+            List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+                    .eq("loc_sts", "O")
+                    .eq("crn_no", staDesc.getCrnNo())
+                    .eq("loc_type1",locTypeDto.getLocType1())
+                    .orderBy("lev1,bay1,row1"));
+            if (!locMasts.isEmpty()) {
+                for (LocMast loc : locMasts) {
+                    LocMast locMast0 = locMastService.findNearloc(loc.getLocNo());
+                    // 娴呭簱浣嶇鍚堝昂瀵告娴�
+                    if (VersionUtils.checkLocType(locMast0, locTypeDto)) {
+                        locMast = locMast0;
+                        break;
+                    }
+                }
+            }
+
+            if (locMast == null) {
+                throw new CoolException("缂哄皯绌哄簱浣�");
+            }
         }
-        String zerofill = zerofill(String.valueOf(targetRow), 2)+locNo.substring(2);
-        System.out.println(zerofill);
+        return locMast;
     }
+
 
     public static String zerofill(String msg, Integer count) {
         if (msg.length() == count) {
@@ -215,4 +295,38 @@
         }
     }
 
-}
\ No newline at end of file
+    /**
+     * 鏍规嵁鍏ュ簱绔欒幏鍙栧簱浣嶆帓鍙峰垎閰�
+     */
+    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);
+        }
+    }
+
+}

--
Gitblit v1.9.1