| | |
|---|
| | | 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()) |
|---|
