From f8bdc51fe4c57a250fb1240056d767883b7d6739 Mon Sep 17 00:00:00 2001 From: zyx <zyx123456> Date: 星期二, 12 十二月 2023 16:49:17 +0800 Subject: [PATCH] Merge branch 'tzskasrs-1' of http://47.97.1.152:5880/r/zy-asrs into tzskasrs-1 --- src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java | 72 +++++++++++++++++++++++++++--------- 1 files changed, 54 insertions(+), 18 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..a471d65 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,33 +120,51 @@ 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); if("F".equals(agvBasDevpDto.getLocSts()) || "R".equals(agvBasDevpDto.getLocSts())){ - AgvWaitPakin agvWaitPakin = agvWaitPakinService.selectOne(new EntityWrapper<AgvWaitPakin>() + //AgvWaitPakin agvWaitPakin = agvWaitPakinService.selectOne(new EntityWrapper<AgvWaitPakin>().eq("supp_code", agvBasDevpDto.getBarcode())); + List<AgvWaitPakin> agvWaitPakinList = agvWaitPakinService.selectList(new EntityWrapper<AgvWaitPakin>() .eq("supp_code", agvBasDevpDto.getBarcode())); - agvBasDevpDto.setAgvWaitPakin(agvWaitPakin); + agvBasDevpDto.setAgvWaitPakins(agvWaitPakinList); - if(Cools.isEmpty(agvWaitPakin)){ - AgvWrkDetl agvWrkDetl = agvWrkDetlService.selectOne(new EntityWrapper<AgvWrkDetl>(). - eq("wrk_no",agvWrkMast.getWrkNo())); + if(Cools.isEmpty(agvWaitPakinList)){ + //AgvWrkDetl agvWrkDetl = agvWrkDetlService.selectOne(new EntityWrapper<AgvWrkDetl>().eq("wrk_no",agvWrkMast.getWrkNo())); + List<AgvWrkDetl> agvWrkDetlList = agvWrkDetlService.selectList(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", agvWrkMast.getWrkNo())); + //agv绔欑偣鍙鍖栫鐞嗕腑鐨勭粨浣欐暟閲忔樉绀� - agvWrkDetl.setVolume(0.0); - if(agvWrkMast.getIoType() == 103){ - AgvLocDetl agvLocDetl = agvLocDetlService.selectByLocNo(agvWrkMast.getSourceLocNo()); - agvWrkDetl.setVolume(agvLocDetl.getAnfme() - agvWrkDetl.getAnfme()); + for(AgvWrkDetl agvWrkDetl : agvWrkDetlList){ + agvWrkDetl.setVolume(0.0); + AgvLocDetl agvLocDetl = agvLocDetlService.selectByMatnrAndBatchAndCsocodeAndisoCode(agvWrkMast.getSourceLocNo(), agvWrkDetl.getMatnr(), agvWrkDetl.getBatch(), agvWrkDetl.getThreeCode(), agvWrkDetl.getDeadTime()); + if(agvWrkMast.getIoType() == 103){ + //AgvLocDetl agvLocDetl = agvLocDetlService.selectByLocNo(agvWrkMast.getSourceLocNo()); + //AgvLocDetl agvLocDetl = agvLocDetlService.selectByMatnrAndBatchAndCsocodeAndisoCode(agvWrkMast.getSourceLocNo(), agvWrkDetl.getMatnr(), agvWrkDetl.getBatch(), agvWrkDetl.getThreeCode(), agvWrkDetl.getDeadTime()); + agvWrkDetl.setVolume(agvLocDetl.getAnfme() - agvWrkDetl.getAnfme()); + } + if(agvWrkMast.getIoType() == 53){ + //AgvLocDetl agvLocDetl = agvLocDetlService.selectByLocNo(agvWrkMast.getLocNo()); + agvWrkDetl.setVolume(agvLocDetl.getAnfme()); + //agvWrkDetl.setAnfme(agvLocDetl.getAnfme() - agvWrkDetl.getAnfme()); + } } - if(agvWrkMast.getIoType() == 53){ - AgvLocDetl agvLocDetl = agvLocDetlService.selectByLocNo(agvWrkMast.getLocNo()); - agvWrkDetl.setVolume(agvLocDetl.getAnfme()); - //agvWrkDetl.setAnfme(agvLocDetl.getAnfme() - agvWrkDetl.getAnfme()); - } - agvBasDevpDto.setAgvWrkDetl(agvWrkDetl); + + agvBasDevpDto.setAgvWrkDetls(agvWrkDetlList); } } @@ -206,4 +227,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