From d5d0d1c7a84b996b9bbcebfaf2c2c95f1a5a3678 Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期五, 11 十月 2024 08:39:15 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java | 65 +++++++++++++++----------------- 1 files changed, 31 insertions(+), 34 deletions(-) diff --git a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java index 1091b84..b7f6d9b 100644 --- a/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java +++ b/hangzhoumesParent/moduleService/CacheVerticalGlassModule/src/main/java/com/mes/bigstorage/service/impl/BigStorageCageServiceImpl.java @@ -18,6 +18,7 @@ import com.mes.temperingglass.service.TemperingGlassInfoService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import javax.annotation.Resource; @@ -48,6 +49,9 @@ @Resource private GlassInfoService glassInfoService; + + @Value("${mes.glassGap}") + private Integer glassGap; //杩涚墖閫昏緫 @Override @@ -217,15 +221,13 @@ LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper = new LambdaQueryWrapper(); bigStorageCageDetailsWrapper .eq(BigStorageCageDetails::getSlot, slot) - .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN) - .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_ARTIFICIAL); + .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN_ALL); List<BigStorageCageDetails> bigStorageCageDetailsList = bigStorageCageDetailsMapper.selectList(bigStorageCageDetailsWrapper); for (BigStorageCageDetails bigStorageCageDetails : bigStorageCageDetailsList ) { - double widths = bigStorageCageDetails.getWidth(); - double gap = bigStorageCageDetails.getGap(); - width -= widths + gap; + double widths = Math.max(bigStorageCageDetails.getWidth(),bigStorageCageDetails.getHeight()) ; + width = width - widths - glassGap; } //淇敼鏍煎瓙鍓╀綑瀹藉害 BigStorageCage bigStorageCage = new BigStorageCage(); @@ -237,49 +239,34 @@ //鏌ヨ澶х悊鐗囦俊鎭紝鍓嶇灞曠ず鐢� @Override - public List<BigStorageCage> querybigStorageCageDetail(int deviceId) { - LambdaQueryWrapper<BigStorageCage> bigStorageCageWrapper = new LambdaQueryWrapper<>(); - LambdaQueryWrapper<BigStorageCageDetails> bigStorageCageDetailsWrapper = new LambdaQueryWrapper<>(); - bigStorageCageDetailsWrapper - .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_IN) - .or() - .eq(BigStorageCageDetails::getState, Const.GLASS_STATE_ARTIFICIAL); - if (deviceId != 0) { - bigStorageCageWrapper.eq(BigStorageCage::getDeviceId, deviceId); - bigStorageCageDetailsWrapper.eq(BigStorageCageDetails::getDeviceId, deviceId); - } - - List<BigStorageCage> bigStorageCages = bigStorageCageMapper.selectList(bigStorageCageWrapper); - log.info("1銆佽幏鍙栧ぇ鐞嗙墖绗间俊鎭畬鎴愶紝鑾峰彇鍒扮殑鏁版嵁{}", bigStorageCages.size()); - - List<BigStorageCageDetails> bigStorageCageDetailsList = bigStorageCageDetailsMapper.selectList(bigStorageCageDetailsWrapper); - - Map<Integer, List<BigStorageCageDetails>> listMap = bigStorageCageDetailsList.stream().collect(Collectors.groupingBy(BigStorageCageDetails::getSlot)); - for (BigStorageCage bigStorageCage : bigStorageCages) { - List<BigStorageCageDetails> bigStorageCageDetails = listMap.get(bigStorageCage.getSlot()); - bigStorageCage.setBigStorageCageDetails(bigStorageCageDetails); - } - return bigStorageCages; + public List<BigStorageCage> querybigStorageCageDetailAll() { + MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(); + wrapper.selectAll(BigStorageCage.class).selectCollection(BigStorageCageDetails.class, BigStorageCage::getBigStorageCageDetails) + .leftJoin(BigStorageCageDetails.class, on -> on.eq(BigStorageCageDetails::getSlot, BigStorageCage::getSlot) + .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL,Const.GLASS_STATE_OUT_ING)) + .orderByAsc(BigStorageCage::getDeviceId) + .orderByAsc(BigStorageCage::getSlot); + return bigStorageCageMapper.selectJoinList(BigStorageCage.class, wrapper); } //鏌ヨ澶х悊鐗囦俊鎭紝鍓嶇灞曠ず鐢� @Override - public List<BigStorageCage> querybigStorageCageDetail() { + public Map<Integer, List<BigStorageCage>> querybigStorageCageDetail() { MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(); wrapper.selectAll(BigStorageCage.class).selectCollection(BigStorageCageDetails.class, BigStorageCage::getBigStorageCageDetails) .leftJoin(BigStorageCageDetails.class, on -> on.eq(BigStorageCageDetails::getSlot, BigStorageCage::getSlot) - .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL)) - .eq(BigStorageCage::getEnableState, Const.SLOT_ON); - - return bigStorageCageMapper.selectJoinList(BigStorageCage.class, wrapper); + .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL,Const.GLASS_STATE_OUT_ING)); + List<BigStorageCage> bigStorageCages = bigStorageCageMapper.selectJoinList(BigStorageCage.class, wrapper); + Map<Integer, List<BigStorageCage>> listMap = bigStorageCages.stream().collect(Collectors.groupingBy(item -> item.getDeviceId())); + return listMap; } //绗煎瓙浣跨敤鎯呭喌锛岀晫闈㈠睍绀虹敤 @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,COUNT(device_id) - 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); @@ -296,4 +283,14 @@ bigStorageCageWrapper.eq(BigStorageCage::getSlot, slot); baseMapper.update(bigStorageCage, bigStorageCageWrapper); } + + @Override + public List<Integer> queryFreeDeviceByUsed(double thickness) { + return baseMapper.queryFreeDeviceByUsed(thickness); + } + +// @Override +// public List<Integer> queryFreeDeviceByNotUsed(double thickness) { +// return baseMapper.queryFreeDeviceByNotUsed(thickness); +// } } -- Gitblit v1.8.0