| | |
|---|
| | | DownStorageCageDetails.class, new MPJQueryWrapper<DownStorageCageDetails>() |
|---|
| | | .select("t.*") |
|---|
| | | .leftJoin("(SELECT t1.* FROM down_storage_cage_details t1 " |
|---|
| | | + "JOIN (SELECT flow_card_id, MAX(width) AS max_width FROM glass_info GROUP BY flow_card_id) t " |
|---|
| | | + "ON t1.flow_card_id = t.flow_card_id WHERE t1.width = t.max_width) t3" |
|---|
| | | + "JOIN (SELECT flow_card_id, MAX(width*height) AS max_width FROM glass_info GROUP BY flow_card_id) t " |
|---|
| | | + "ON t1.flow_card_id = t.flow_card_id WHERE t1.width*t1.height = t.max_width) t3" |
|---|
| | | + " ON t.glass_id = t3.glass_id") |
|---|
| | | .leftJoin("down_workstation t4 ON t3.flow_card_id = t4.flow_card_id") |
|---|
| | | .isNull(Boolean.parseBoolean("t.glass_id"), "SELECT glass_id FROM down_glass_info") |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<DownStorageCageDetails> selectCacheEmpty2(){ |
|---|
| | | return downStorageCageMapper.selectJoinList( |
|---|
| | | DownStorageCageDetails.class, new MPJQueryWrapper<DownStorageCage>() |
|---|
| | | .select("escd.glass_id","escd.flow_card_id","escd.width","escd.height") |
|---|
| | | .leftJoin("down_storage_cage_details escd on t.device_id=escd.device_id and t.slot=escd.slot") |
|---|
| | | .isNull("escd.slot") |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
