| | |
|---|
| | | //工位显示 |
|---|
| | | @Override |
|---|
| | | public List<Map<String, Object>> getTotalGlassDimensionsByWorkstation() { |
|---|
| | | MPJQueryWrapper<DownWorkstionAndDownGlassinfo> queryWrapper = new MPJQueryWrapper<>(); |
|---|
| | | MPJQueryWrapper<DownWorkstation> queryWrapper = new MPJQueryWrapper<>(); |
|---|
| | | queryWrapper.select("t.workstation_id", "t.flow_card_id", "COALESCE(SUM(b.width), 0) AS totalwidth", "COALESCE(SUM(b.height), 0) AS totalheight") |
|---|
| | | .leftJoin("down_glass_info b on t.flow_card_id = b.flow_card_id") |
|---|
| | | .groupBy("t.workstation_id", "t.flow_card_id"); |
|---|
