| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<Map<String, Object>> selectTemperingGlass() { |
|---|
| | | QueryWrapper<BigStorageCageDetails> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("engineer_id,tempering_layout_id,count(*) as count") |
|---|
| | | .in("state", Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL) |
|---|
| | | .groupBy("engineer_id,tempering_layout_id") |
|---|
| | | .orderByAsc("engineer_id") |
|---|
| | | .orderByAsc("tempering_layout_id"); |
|---|
| | | List<Map<String, Object>> TemperingGlass = baseMapper.selectMaps(wrapper); |
|---|
| | | return TemperingGlass; |
|---|
| | | List<Map<String, Object>> temperingGlass = baseMapper.selectTemperingGlassCount(); |
|---|
| | | return temperingGlass; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
