| | |
|---|
| | | |
|---|
| | | //工位显示 |
|---|
| | | @Override |
|---|
| | | public List<Map<String, Object>> getTotalGlassDimensionsByWorkstation() { |
|---|
| | | public List<Map<String, Object>> getTotalGlassDimensionsByWorkstation(int start,int end) { |
|---|
| | | 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"); |
|---|
| | | .groupBy("t.workstation_id", "t.flow_card_id") |
|---|
| | | .orderByAsc("t.workstation_id").between("t.workstation_id", start, end) |
|---|
| | | |
|---|
| | | ; |
|---|
| | | |
|---|
| | | List<DownWorkstionAndDownGlassinfo> workstationList = downWorkstationMapper.selectJoinList(DownWorkstionAndDownGlassinfo.class, queryWrapper); |
|---|
| | | // List<DownWorkstionAndDownGlassinfo> workstationList = null; |
|---|
