| | |
|---|
| | | import com.mes.common.config.Const; |
|---|
| | | import com.mes.glassinfo.entity.GlassInfo; |
|---|
| | | import com.mes.glassinfo.service.GlassInfoService; |
|---|
| | | import com.mes.largenscreen.entity.PieChartVO; |
|---|
| | | import com.mes.temperingglass.entity.TemperingGlassInfo; |
|---|
| | | import com.mes.temperingglass.service.TemperingGlassInfoService; |
|---|
| | | import lombok.extern.slf4j.Slf4j; |
|---|
| | |
|---|
| | | public List<Map<String, Object>> selectBigStorageCageUsage() { |
|---|
| | | QueryWrapper<BigStorageCage> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("device_id,ROUND(1 - SUM(CASE WHEN remain_width = " + slotWidth + " THEN 1 ELSE 0 END) / COUNT(device_id), 2)*100 AS percentage,SUM(CASE WHEN remain_width = " + slotWidth + " THEN 1 ELSE 0 END) AS count") |
|---|
| | | .eq("enable_state", Const.SLOT_ON) |
|---|
| | | .groupBy("device_id"); |
|---|
| | | List<Map<String, Object>> bigStorageCageUsages = baseMapper.selectMaps(wrapper); |
|---|
| | | |
|---|
| | |
|---|
| | | return Boolean.TRUE; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<PieChartVO> queryPieChart() { |
|---|
| | | return baseMapper.queryPieChart(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // @Override |
|---|
| | | // public List<Integer> queryFreeDeviceByNotUsed(double thickness) { |
|---|
| | | // return baseMapper.queryFreeDeviceByNotUsed(thickness); |
|---|
