hangzhoumesParent/moduleService/CacheGlassModule/src/main/resources/mapper/EdgStorageCageDetailsMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
hangzhoumesParent/moduleService/CacheGlassModule/src/main/resources/mapper/EdgStorageCageDetailsMapper.xml
@@ -74,7 +74,7 @@ </select> <select id="querySlotRemainWidth" resultType="com.mes.edgstoragecage.entity.vo.EdgSlotRemainVO"> select device_id,slot, if(#{cellLength} - sum(GREATEST(width,height)+#{glassGap})< 0 ,0,#{cellLength} - select device_id,slot, if(#{cellLength} - sum(GREATEST(width,height)+#{glassGap}) < 0 ,0,#{cellLength} - sum(GREATEST(width,height)+#{glassGap}) )as remain_width from edg_storage_cage_details where state = 100 group by device_id,slot </select>