| | |
| | | if (StringUtils.isNotBlank(splrBatch)) { |
| | | locItemQueryWrapper.and(w -> w.eq(LocItem::getBatch, splrBatch).or().isNull(LocItem::getBatch)); |
| | | } |
| | | // 含 F.在库 与 R.出库预约(拣料出库未确认前可再下发,使用剩余可用) |
| | | String applySql = "EXISTS (SELECT 1 FROM man_loc ml WHERE ml.use_status IN ('" + LocStsType.LOC_STS_TYPE_F.type + "','" + LocStsType.LOC_STS_TYPE_R.type + "') AND ml.id = man_loc_item.loc_id)"; |
| | | // 含 F.在库 与 R.出库预约(拣料出库未确认前可再下发,使用剩余可用) “LocStsType.LOC_STS_TYPE_R.type用于出库拣料过程中追加相同物料出库单” |
| | | String applySql = "EXISTS (SELECT 1 FROM man_loc ml WHERE ml.use_status IN ('" + LocStsType.LOC_STS_TYPE_F.type /*+ "','" + LocStsType.LOC_STS_TYPE_R.type*/ + "') AND ml.id = man_loc_item.loc_id)"; |
| | | locItemQueryWrapper.apply(applySql); |
| | | LocItemService locItemService = SpringUtils.getBean(LocItemService.class); |
| | | List<LocItem> locItems = locItemService.list(locItemQueryWrapper); |
| | |
| | | } else { |
| | | locItemQueryWrapper.orderByAsc(LocItem::getCreateTime); |
| | | } |
| | | // 含 F.在库 与 R.出库预约(拣料出库未确认前可再下发,使用剩余可用) |
| | | String applySqlR = "EXISTS (SELECT 1 FROM man_loc ml WHERE ml.use_status IN ('" + LocStsType.LOC_STS_TYPE_F.type + "','" + LocStsType.LOC_STS_TYPE_R.type + "') AND ml.id = man_loc_item.loc_id)"; |
| | | // 含 F.在库 与 R.出库预约(拣料出库未确认前可再下发,使用剩余可用) “LocStsType.LOC_STS_TYPE_R.type用于出库拣料过程中追加相同物料出库单” |
| | | String applySqlR = "EXISTS (SELECT 1 FROM man_loc ml WHERE ml.use_status IN ('" + LocStsType.LOC_STS_TYPE_F.type /*+ "','" + LocStsType.LOC_STS_TYPE_R.type*/ + "') AND ml.id = man_loc_item.loc_id)"; |
| | | locItemQueryWrapper.apply(applySqlR); |
| | | LocItemService locItemService = SpringUtils.getBean(LocItemService.class); |
| | | List<LocItem> locItems = locItemService.list(locItemQueryWrapper); |