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