| | |
|---|
| | | queryWrapper.in(!longs.isEmpty(),"group_id", longs); |
|---|
| | | // 出库选物料：按库位状态筛选（仅展示在该库位状态下有有效库存的物料，与 listStockByMatnrIds 口径一致：排除已删明细与已删库位） |
|---|
| | | if (locUseStatus != null && StringUtils.isNotBlank(locUseStatus.toString())) { |
|---|
| | | String useStatus = locUseStatus.toString().replace("'", "''"); |
|---|
| | | queryWrapper.apply("EXISTS (SELECT 1 FROM man_loc_item li INNER JOIN man_loc l ON li.loc_id = l.id AND l.deleted = 0 WHERE li.matnr_id = man_matnr.id AND li.deleted = 0 AND l.use_status = '" + useStatus + "')"); |
|---|
| | | queryWrapper.apply( |
|---|
| | | "EXISTS (SELECT 1 FROM man_loc_item li INNER JOIN man_loc l ON li.loc_id = l.id AND l.deleted = 0 WHERE li.matnr_id = man_matnr.id AND li.deleted = 0 AND l.use_status = {0})", |
|---|
| | | locUseStatus.toString().trim()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | FieldsUtils.setFieldsFilters(queryWrapper,pageParam,Matnr.class); |
|---|
