blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wangfei
2024-08-13 6d5ee2bbf65a6b7bb12a9d84b3aa98c6505d4998 
 hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java


@@ -266,7 +266,7 @@


    @Override


    public List<Map<String, Object>> selectBigStorageCageUsage() {


        QueryWrapper<BigStorageCage> wrapper = new QueryWrapper<>();


        wrapper.select("device_id,ROUND(1 - SUM(CASE WHEN remain_width = 5000 THEN 1 ELSE 0 END) / COUNT(device_id), 2) AS percentage,SUM(CASE WHEN remain_width = 5000 THEN 1 ELSE 0 END) AS count")


        wrapper.select("device_id,ROUND(1 - SUM(CASE WHEN remain_width = 5000 THEN 1 ELSE 0 END) / COUNT(device_id), 2)*100 AS percentage,SUM(CASE WHEN remain_width = 5000 THEN 1 ELSE 0 END) AS count")




                .groupBy("device_id");


        List<Map<String, Object>> bigStorageCageUsages = baseMapper.selectMaps(wrapper);


@@ -289,8 +289,8 @@


        return baseMapper.queryFreeDeviceByUsed(thickness);


    }




    @Override


    public List<Integer> queryFreeDeviceByNotUsed(double thickness) {


        return baseMapper.queryFreeDeviceByNotUsed(thickness);


    }


//    @Override


//    public List<Integer> queryFreeDeviceByNotUsed(double thickness) {


//        return baseMapper.queryFreeDeviceByNotUsed(thickness);


//    }


}