From 828b592b5f8e31204f93bcc2ea0c5866bdc0dcf0 Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期三, 06 十二月 2023 20:18:44 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/tzskasrs-1' into tzskasrs-1

---
 src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java |   35 ++++++++++++++++++++++++++++++++---
 1 files changed, 32 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
index 40200f9..310b62a 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
@@ -100,8 +100,11 @@
                     .eq("station_code", stationCode)
                     .like("dev_no", "0" + i + "@");
 
-            if("CS-305".equals(stationCode) || "CS-306".equals(stationCode) || "CS-307".equals(stationCode)){
-                wrapper.orderBy("dev_no",false);
+            List<String> list = this.selectCacheShelvesStationCodeByFloor(3);
+            if(list.contains(stationCode)){
+                if(Cools.eq(stationCode,"CS-305") || Cools.eq(stationCode,"CS-306") || Cools.eq(stationCode,"CS-307")){
+                    wrapper.orderBy("dev_no",false);
+                }
             }
 
             List<AgvBasDevp> agvBasDevpList = this.selectList(wrapper);
@@ -117,9 +120,20 @@
                     return agvBasDevpDto;
                 }
 
-                AgvWrkMast agvWrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>()
+                List<AgvWrkMast> agvWrkMasts = agvWrkMastService.selectList(new EntityWrapper<AgvWrkMast>()
                         .eq("loc_no", agvBasDevpDto.getDevNo())
                         .or().eq("source_loc_no",agvBasDevpDto.getDevNo()));
+
+                AgvWrkMast agvWrkMast = null;
+                for (AgvWrkMast wrkMast : agvWrkMasts){
+                    if(Cools.isEmpty(agvWrkMast)){
+                        agvWrkMast = wrkMast;
+                    }else {
+                        if(agvWrkMast.getWrkSts() < wrkMast.getWrkSts()){
+                            agvWrkMast = wrkMast;
+                        }
+                    }
+                }
 
                 agvBasDevpDto.setAgvWrkMast(agvWrkMast);
 
@@ -206,4 +220,19 @@
         return this.selectList(new EntityWrapper<AgvBasDevp>().eq("cache_shelves","N"));
     }
 
+    @Override
+    public List<String> selectCacheShelvesStationCodeByFloor(int floor) {
+        //Object o = this.selectList(new EntityWrapper<AgvBasDevp>().setSqlSelect("station_code").eq("floor",floor).eq("cache_shelves","Y").groupBy("station_code"));
+        return this.baseMapper.selectCacheShelvesStationCodeByFloor(floor);
+    }
+
+    public List<Map<String,Object>> selectDevNoAndNumBystationCode(String stationCode){
+        return this.baseMapper.selectDevNoAndNumBystationCode(stationCode);
+    }
+
+    @Override
+    public List<String> selectAllStationCode() {
+        return this.baseMapper.selectAllStationCode();
+    }
+
 }

--
Gitblit v1.9.1