自动化立体仓库 - WMS系统
zyx
2023-11-15 d73aea22606a34be4d704c130f1a8444af58f5a8
src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
@@ -100,7 +100,8 @@
                    .eq("station_code", stationCode)
                    .like("dev_no", "0" + i + "@");
            if("CS-305".equals(stationCode) || "CS-306".equals(stationCode) || "CS-307".equals(stationCode)){
            List<String> list = this.selectCacheShelvesStationCodeByFloor(3);
            if(list.contains(stationCode)){
                wrapper.orderBy("dev_no",false);
            }
@@ -206,4 +207,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();
    }
}