| | |
|---|
| | | List<LoadGlassInfo> glassInfos = null; |
|---|
| | | glassInfos = glassInfoMapper.selectJoinList(LoadGlassInfo.class, new MPJQueryWrapper<GlassInfo>() |
|---|
| | | .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") |
|---|
| | | .leftJoin("(SELECT glass_id, type as state FROM damage where type in (8, 9) and status = 1) b\n" + |
|---|
| | | "ON t.glass_id = b.glass_id ") |
|---|
| | | .eq("engineer_id", glassInfo.getEngineerId()) |
|---|
| | | .eq("tempering_layout_id", glassInfo.getTemperingLayoutId())); |
|---|
| | | return glassInfos; |
|---|
