From c47395fe29493062a3f0bc2cf1d02a2946b20b88 Mon Sep 17 00:00:00 2001
From: zyh <zyh@123>
Date: 星期日, 04 一月 2026 08:41:35 +0800
Subject: [PATCH] 修改了判断空库位,查询语句的bug,和摄像头的连接

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

diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index baf4f20..a5bd580 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -170,11 +170,31 @@
             throw new CoolException("鍏ュ簱璇锋眰搴撲綅澶辫触锛氳矾寰勪笉瀛樺湪" + staDescId +"," + sourceStaNo);
         }
 
-        Short locType1 = 1;
-        LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_sts", "O").eq("loc_type1", locType1).orderBy("lev1").orderBy("bay1").orderBy("row1"));
-        if (locMast == null) {
-            log.error("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locType1);
-            throw new CoolException("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locType1);
+        LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>()
+                .eq("loc_sts", "O")
+                .eq("loc_type1", locTypeDto.getLocType1())
+                .eq("loc_type2", locTypeDto.getLocType2())
+                .orderBy("lev1")
+                .orderBy("bay1")
+                .orderBy("row1"));
+        if (locMast == null && locTypeDto.getLocType1() ==1) {
+            LocMast locMast1 = locMastService.selectOne(new EntityWrapper<LocMast>()
+                    .eq("loc_sts", "O")
+                    .eq("loc_type1", locTypeDto.getLocType1() + 1)
+                    .eq("loc_type2", locTypeDto.getLocType2())
+                    .orderBy("lev1")
+                    .orderBy("bay1")
+                    .orderBy("row1"));
+            if (locMast1 == null){
+                log.error("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locTypeDto.getLocType1());
+                throw new CoolException("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locTypeDto.getLocType1());
+            }else {
+                locMast =locMast1;
+            }
+
+        }else if (locMast ==null){
+            log.error("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locTypeDto.getLocType1());
+            throw new CoolException("鍏ュ簱璇锋眰搴撲綅澶辫触锛氭棤搴撲綅" + locTypeDto.getLocType1());
         }
 
         StartupDto startupDto = new StartupDto();

--
Gitblit v1.9.1