| | |
|---|
| | | public List<TemperingGlassInfo> selectOutGlass() { |
|---|
| | | //获取出炉中的玻璃信息 |
|---|
| | | QueryWrapper<TemperingGlassInfo> wrap = new QueryWrapper<>(); |
|---|
| | | wrap.select("Top 1 *").eq("state", 3); |
|---|
| | | wrap.select("Top 1 *").eq("state", 4) |
|---|
| | | .orderByDesc("id"); |
|---|
| | | TemperingGlassInfo glass = temperingMapper.selectOne(wrap); |
|---|
| | | //根据工程号和版图获取数据 |
|---|
| | | if (glass != null) { |
|---|
| | |
|---|
| | | //获取过旋转台最大的钢化版图id |
|---|
| | | QueryWrapper<TemperingGlassInfo> wapper = new QueryWrapper<>(); |
|---|
| | | wapper.select("Top 1 *").eq("state", 4) |
|---|
| | | .orderByDesc("tempering_layout_id,engineer_id"); |
|---|
| | | .orderByDesc("id"); |
|---|
| | | //根据最大的版图id显示钢化后的版图信息 |
|---|
| | | TemperingGlassInfo glassinfo = temperingMapper.selectOne(wapper); |
|---|
| | | if (glassinfo == null) { |
|---|
| | |
|---|
| | | public List<GlassInfo> selectTemperingGlass(GlassInfo glassInfo) { |
|---|
| | | List<GlassInfo> glassInfos = null; |
|---|
| | | glassInfos = glassInfoMapper.selectJoinList(GlassInfo.class, new MPJQueryWrapper<GlassInfo>() |
|---|
| | | .select("IFNULL(b.status, 0) AS status,engineer_id,tempering_layout_id,width,height,tempering_feed_sequence,x_coordinate,y_coordinate,angle,t.glass_id") |
|---|
| | | .select("IFNULL(b.status, 0) AS status,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" + |
|---|
| | | "ON t.glass_id = b.glass_id") |
|---|
| | | .eq("engineer_id", glassInfo.getEngineerId()) |
|---|
