| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<DownStorageCageDetails> CacheOut(int start, int end) { |
|---|
| | | log.info("单片情况根据传入的工位查询符合按照大小出片,并且优先出满架的小片"); |
|---|
| | | return downStorageCageDetailsMapper.selectJoinList( |
|---|
| | | DownStorageCageDetails.class, new MPJQueryWrapper<DownStorageCageDetails>() |
|---|
| | | .select("t.*") |
|---|
| | | .leftJoin("(SELECT t1.* FROM down_storage_cage_details t1 " |
|---|
| | | + "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") |
|---|
| | | .between("t4.workstation_id", start, end) |
|---|
| | | // 根据 racks_number 排序 |
|---|
| | | .orderByDesc("t4.racks_number") |
|---|
| | | |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | // @Override |
|---|
| | | // public List<DownStorageCageDetails> CacheOut(int start, int end) { |
|---|
| | | // log.info("单片情况根据传入的工位查询符合按照大小出片,并且优先出满架的小片"); |
|---|
| | | // return downStorageCageDetailsMapper.selectJoinList( |
|---|
| | | // DownStorageCageDetails.class, new MPJQueryWrapper<DownStorageCageDetails>() |
|---|
| | | // .select("t.*") |
|---|
| | | // .leftJoin("(SELECT t1.* FROM down_storage_cage_details t1 " |
|---|
| | | // + "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") |
|---|
| | | // .between("t4.workstation_id", start, end) |
|---|
| | | // // 根据 racks_number 排序 |
|---|
| | | // .orderByDesc("t4.racks_number") |
|---|
| | | // |
|---|
| | | // ); |
|---|
| | | // } |
|---|
| | | |
|---|
| | | |
|---|
| | | // @Override |
|---|
