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