| | |
| | | public List<LoadGlassInfo> selectTemperingGlass(GlassInfo glassInfo) { |
| | | List<LoadGlassInfo> glassInfos = null; |
| | | glassInfos = glassInfoMapper.selectJoinList(LoadGlassInfo.class, new MPJQueryWrapper<GlassInfo>() |
| | | .select("IFNULL(b.status, 0) AS state,engineer_id,tempering_layout_id,width,height,tempering_feed_sequence,x_coordinate,y_coordinate,angle,t.glass_id,t.flow_card_id") |
| | | .leftJoin("(SELECT glass_id, MAX(status) AS status FROM damage GROUP BY glass_id) b\n" + |
| | | .select("IFNULL(b.state, 0) AS state,engineer_id,tempering_layout_id,width,height,tempering_feed_sequence,x_coordinate,y_coordinate,angle,t.glass_id,t.flow_card_id") |
| | | .leftJoin("(SELECT glass_id, MAX(type) AS state FROM damage GROUP BY glass_id) b\n" + |
| | | "ON t.glass_id = b.glass_id") |
| | | .eq("engineer_id", glassInfo.getEngineerId()) |
| | | .eq("tempering_layout_id", glassInfo.getTemperingLayoutId())); |
| | |
| | | |
| | | @ApiOperation("//钢化破损拿走放回") |
| | | @PostMapping("/updateTemperingState") //钢化后显示出炉的版图信息 |
| | | public Result <Integer> updateTemperingState(@RequestBody DamageRequest damage) { |
| | | public Result<List<LoadGlassInfo>> updateTemperingState(@RequestBody DamageRequest damage) { |
| | | TemperingGlassInfo temperingGlassInfo=new TemperingGlassInfo(); |
| | | temperingGlassInfo.setState(damage.getState()); |
| | | temperingGlassInfo.setGlassId(damage.getGlassId()); |
| | |
| | | damageService.autoSubmitReport(damage.getGlassId(), damage.getLine() |
| | | , damage.getWorkingProcedure(), "钢化炉", damage.getState()); |
| | | } |
| | | return Result.build(200, "破损成功", result); |
| | | GlassInfo glassInfo = new GlassInfo(); |
| | | glassInfo.setEngineerId(damage.getEngineerId()); |
| | | glassInfo.setTemperingLayoutId(damage.getTemperingLayoutId()); |
| | | List<LoadGlassInfo> glass = temperingGlassInfoService.selectTemperingGlass(glassInfo); |
| | | return Result.build(200, "破损成功", glass); |
| | | } |
| | | |
| | | @ApiOperation("//查询当前工程号所有的炉号") |
| | |
| | | * 状态:8破损 9拿走 |
| | | */ |
| | | private Integer state; |
| | | /** |
| | | * 工程号 |
| | | */ |
| | | private String engineerId; |
| | | /** |
| | | * 钢化版图id |
| | | */ |
| | | private Integer temperingLayoutId; |
| | | } |