From f48878cdae5652be9e8f1145eda84d2ca9ca0544 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期二, 07 一月 2025 13:52:05 +0800
Subject: [PATCH] 优化订单同步逻辑及环境配置

---
 src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java |  367 +++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 335 insertions(+), 32 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
index 57250ad..2a91852 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
@@ -26,28 +26,17 @@
     }
 
     public void initLocFloor1() {
-        //1妤� 13鎺� 86鍒� 12灞�
-        List<AgvLocMast> agvLocMastList = getLocMastList(1,13,1,86,1,12,1);
-        this.insertBatch(agvLocMastList);
+        this.insertBatch(getLocMastList(1, 22, 1, 39, 2, 2, 1));
     }
 
 
+    public void initLocFloor2() {
+        //2妤� 1-25鎺� 1-33鍒� 1灞�
+        this.insertBatch(getLocMastList(1, 25, 1, 33, 1, 1, 2));
+    }
     public void initLocFloor3() {
-        //3妤� 1-33鎺� 1-14鍒� 8灞�
-        this.insertBatch(getLocMastList(1, 33, 1, 14, 1, 8, 3));
-
-        //3妤� 1-27鎺� 15-34鍒� 8灞�
-        this.insertBatch(getLocMastList(1, 27, 15, 34, 1, 8, 3));
-
-        //3妤� 1-25鎺� 35-46鍒� 8灞�
-        this.insertBatch(getLocMastList(1, 25, 35, 46, 1, 8, 3));
-
-        //3妤� 3-25鎺� 47-60鍒� 8灞�
-        this.insertBatch(getLocMastList(3, 25, 47, 60, 1, 8, 3));
-
-        //3妤� 4-25鎺� 61-70鍒� 8灞�
-        this.insertBatch(getLocMastList(4, 25, 61, 70, 1, 8, 3));
-
+        //2妤� 1-25鎺� 1-33鍒� 1灞�
+        this.insertBatch(getLocMastList(1, 26, 1, 34, 1, 1, 3));
     }
 
     //鏍规嵁鎺掑垪灞傝幏鍙朅GV搴撲綅鍒楄〃
@@ -57,22 +46,16 @@
         for(int row=rowIndex; row<=rowMax; row++) {
             for (int bay = bayIndex; bay <= bayMax; bay++) {
                 for (int lev = levIndex; lev <= levMax; lev++) {
-                    if(row == 8 || row == 9){
-                        if((bay >=8 && bay <=11)
-                                || (bay >= 20 && bay <=23)
-                                || (bay>=37 && bay <=39)
-                                || (bay>=50 && bay <=52)
-                                || (bay>=63 && bay <=64)
-                                || (bay>=79 && bay <=80)){
-                            continue;
-                        }
+
+                    if(!checkLocExistFloor1_2(row,bay)){
+                        continue;
                     }
 
                     AgvLocMast loc = new AgvLocMast();
-                    String locRow = row < 10 ? "-00" + row : "-0" + row;
-                    String locBay = bay < 10 ? "-00" + bay : "-0" + bay;
-                    String locLev = lev < 10 ? "-0" + lev : "-" + lev;
-                    String locNo = "SK" + locRow + locBay + locLev + "@" + floor;
+                    String locRow = row < 10 ? "_00" + row : "_0" + row;
+                    String locBay = bay < 10 ? "_00" + bay : "_0" + bay;
+                    String locLev = lev < 10 ? "_0" + lev : "_" + lev;
+                    String locNo = "YZ" + locRow + locBay + locLev + "F" + floor;
                     loc.setLocNo(locNo);
                     loc.setLocSts("O");
                     loc.setRow1(row);
@@ -82,12 +65,294 @@
                     loc.setModiTime(now);
                     loc.setFirstTime(now);
                     loc.setAppeTime(now);
+                    loc.setLocType1((short)3);
+                    //  loc.setLocType1(initLocMastSts3(row,bay));
                     agvLocMastList.add(loc);
                 }
             }
         }
 
         return  agvLocMastList;
+    }
+
+    private boolean checkLocExistFloor1_2(int row, int bay){
+        if(row == 4 && bay == 19){
+            return false;
+        }
+
+        if(row == 5 && (bay == 3 || bay == 8 || bay == 13 || bay == 18 || bay == 19 || bay == 24 || bay == 29)){
+            return false;
+        }
+
+        if((row == 6 || row == 7) && bay == 39){
+            return false;
+        }
+
+        if((row == 9 || row == 10 || row == 14 || row == 18) && (bay == 3 || bay == 8 || bay == 13 || bay == 14 || bay == 19 || bay == 24 || bay == 29 || bay == 30)){
+            return false;
+        }
+        if ((row == 10 || row == 11) && (bay == 7 || bay == 12 || bay == 23 || bay == 28 )) {
+            return false;
+        }
+        if ((row == 9 || row == 13) && bay == 35 ) {
+            return false;
+        }
+        if(row == 13 && (bay == 18 || bay == 19 || bay == 20)){
+            return false;
+        }
+        if(row == 9 && bay == 18){
+            return false;
+        }
+        if((row == 14 || row == 15) && bay > 37){
+            return false;
+        }
+        if(row >= 16 && bay >= 35){
+            return false;
+        }
+        if((row >= 2 && row <= 21) && bay == 17){
+            return false;
+        }
+
+        if(bay >= 33 && bay <= 34){
+            return false;
+        }
+
+        return true;
+    }
+    private boolean checkLocExistFloor1_1(int row, int bay){
+        if(row <= 2 && bay >= 20){
+            return false;
+        }
+        if ((row == 4 || row == 9 || row == 14 || row == 20 || row == 25 || row == 30) && (bay == 7 || bay == 11 || bay == 12 || bay == 16 )) {
+            return false;
+        }
+        if ((row == 7 || row == 13 || row == 21 || row == 26) && (bay == 12 || bay == 13 )) {
+            return false;
+        }
+        if (row >= 10 && bay == 1) {
+            return false;
+        }
+        if (row == 18 && bay <= 19) {
+            return false;
+        }
+        if (row == 25 && bay == 20) {
+            return false;
+        }
+        if ((row >= 26 && row <=27) && (bay >=18 && bay <= 19)) {
+            return false;
+        }
+        if (row >= 28 && bay == 20) {
+            return false;
+        }
+
+        return true;
+    }
+
+    private boolean checkLocExistFloor2(int row, int bay){
+        if(row <= 4 && bay >= 13){
+            return false;
+        }
+
+        if(row <= 7 && bay >= 25){
+            return false;
+        }
+
+        if(row >= 24 && bay >= 29){
+            return false;
+        }
+
+        if((row != 20 && row != 25) && (bay ==8 || bay ==22)){
+            return  false;
+        }
+
+        if((row == 3 || row == 12 || row == 16 || row == 21) && (bay ==4 || bay ==9 || bay == 14 || bay == 20 || bay == 25 || bay ==30 || bay == 31)){
+            return false;
+        }
+
+        if(row == 21 && bay == 15){
+            return false;
+        }
+
+        if(row == 23 && bay == 29){
+            return false;
+        }
+
+        return true;
+    }
+
+    private short initLocMastSts(int row, int bay){
+
+        if(row <= 11 && bay <= 14){
+            return 1;
+        }
+
+        if(row <= 7){
+            return 1;
+        }
+
+        if(row >= 21){
+            return 3;
+        }
+
+        return 2;
+    }
+    private boolean checkLocExistFloor3(int row, int bay){
+        if(row == 1 && (bay <= 15 || bay >= 30)){
+            return false;
+        }
+
+        if(row <= 6 && bay >= 30){
+            return false;
+        }
+
+        if((row >= 9 && row <= 16) && (bay <= 4 || bay >= 33)){
+            return false;
+        }
+        if(row == 17 && (bay <= 3 || bay >= 33)){
+            return false;
+        }
+
+        if(row <= 21 && row != 7 && row != 8 && bay >= 33){
+            return false;
+        }
+        if((row <= 24 && row != 7 && row != 8) && bay >= 34){
+            return false;
+        }
+        if(row >= 25 && row <= 26 && bay >= 29){
+            return false;
+        }
+
+
+        if((row != 8 && row != 21  && row != 23 && row != 24 && row != 25 && row != 26) && bay == 15){
+            return  false;
+        }
+
+        if((row >= 22 && row != 26 ) && bay == 16){
+            return  false;
+        }
+
+        if (row == 4 && (bay == 3 || bay == 4 || bay == 9 || bay == 14 || bay == 19 || bay == 20 || bay == 25)) {
+            return  false;
+        }
+
+        if ((row == 13 || row == 17) && (bay == 8 || bay == 14 || bay == 19 || bay == 24 )) {
+            return  false;
+        }
+        if (row == 22 && (bay == 4 || bay == 9 || bay == 14 || bay == 20 || bay == 25 )) {
+            return  false;
+        }
+
+        return true;
+    }
+
+    private short initLocMastSts3(int row, int bay){
+
+        if(row <= 8){
+            return 1;
+        }
+
+        if(row <= 17){
+            return 2;
+        }
+
+        if(row <= 18 && bay >= 9){
+            return 2;
+        }
+
+        if(row <= 21){
+            return 4;
+        }
+
+        if(row >= 22){
+            return 3;
+        }
+
+        return 2;
+    }
+
+    private boolean checkLocExist(int row, int bay, int floor){
+        //if(floor == 1 && (row == 2)){
+        //    if((bay >=8 && bay <=11)
+        //            || (bay >= 20 && bay <=23)
+        //            || (bay>=37 && bay <=39)
+        //            || (bay>=50 && bay <=52)
+        //            || (bay>=63 && bay <=64)
+        //            || (bay>=79 && bay <=80)){
+        //        return false;
+        //    }
+        //}
+        if (floor == 1) {
+            if (row == 2 || row == 5 || row == 8 || row == 11
+                    || row == 14 || row == 17 || row == 19 || row == 22 || row == 25
+                    || row == 28 || (row >29 && row <39)|| row == 41|| row == 44) {
+                return false;
+            } else if (row == 1) {
+                if (bay < 19) {
+                    return false;
+                }
+            } else if (row == 3 || row == 4) {
+                if (bay < 19 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 6) {
+                if (bay < 20 || bay == 26 || bay == 30) {
+                    return false;
+                }
+            } else if (row == 7) {
+                if (bay < 4 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 9 || row ==10 ) {
+                if (bay < 4 || bay == 12 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 12) {
+                if (bay < 4) {
+                    return false;
+                }
+            } else if (row == 15 || row == 18 || row == 20 || row == 21 || row == 24 || row == 26 || row == 27 || row == 40) {
+                if (bay == 12 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 16 || row == 23 || row == 39) {
+                if (bay == 3 || bay == 4 || bay == 9 || bay == 12 || bay == 14 || bay == 20 || bay == 25  || bay == 26) {
+                    return false;
+                }
+            } else if (row == 42) {
+                if (bay == 5 || bay == 12 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 43) {
+                if (bay < 6 || bay == 12 || bay == 26) {
+                    return false;
+                }
+            } else if (row == 45) {
+                if (bay < 6) {
+                    return false;
+                }
+            } else {
+                return true;
+            }
+        }
+
+        if(floor == 3){
+            if(row == 1 && bay > 63){
+                return false;
+            }
+            if(row ==  2 && bay > 65){
+                return false;
+            }
+            if(row > 23 && bay == 1){
+                return false;
+            }
+
+            if(bay > 35 && bay < 39){
+                if(row == 4 || row == 5 || row == 10 || row == 11 || row == 17 || row == 18){
+                    return false;
+                }
+            }
+        }
+        return true;
     }
 
     @Override
@@ -100,9 +365,22 @@
         this.baseMapper.updateLocType2(locType2,locRule.getRowBeg(),locRule.getRowEnd(),locRule.getBayBeg(),locRule.getBayEnd(),locRule.getLevBeg(),locRule.getLevEnd(),locRule.getFloor());
     }
 
-    public void updateLocStsByLocNo(String locNo, String locSts) {
+    public void updateLocStsByLocNo(String locNo, String locSts, String barcode,Short containerType) {
         AgvLocMast agvLocMast = this.selectById(locNo);
         agvLocMast.setLocSts(locSts);
+        agvLocMast.setBarcode(barcode);
+        agvLocMast.setLocType2(containerType);
+        agvLocMast.setModiTime(new Date());
+        this.updateById(agvLocMast);
+    }
+    public void updateLocStsByLocNo(String locNo, String locSts, String barcode,Short containerType,String locType,Short locType3) {
+        AgvLocMast agvLocMast = this.selectById(locNo);
+        agvLocMast.setLocSts(locSts);
+        agvLocMast.setBarcode(barcode);
+        agvLocMast.setLocType2(containerType);
+        agvLocMast.setLocType(locType);
+        agvLocMast.setLocType3(locType3);
+        agvLocMast.setModiTime(new Date());
         this.updateById(agvLocMast);
     }
 
@@ -117,4 +395,29 @@
         //return this.agvLocMastMapper.selectLocByLevAndFloor(lev,floor);
     }
 
+    @Override
+    public AgvLocMast selectEmptyZpallet(int type, int floor) {
+
+        return this.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_sts","D").eq("loc_type2",type).eq("floor",floor));
+
+    }
+
+    @Override
+    public AgvLocMast selectEmptyZpalletByLocType1(int type) {
+
+        return this.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_sts","D").eq("loc_type1",type));
+
+    }
+
+    @Override
+    public List<String> queryContainerTypeByLocType1(Short locType1) {
+        return this.baseMapper.queryContainerTypeByLocType1(locType1);
+    }
+
+    @Override
+    public List<AgvLocMast> selectDistinctLocByLevAndFloor(int lev, int floor) {
+
+        return this.agvLocMastMapper.selectDistinctLocByLevAndFloor(lev,floor);
+    }
+
 }

--
Gitblit v1.9.1