From 951b46befc5b4ec669f882bebd934d64897059f9 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期五, 01 八月 2025 12:58:29 +0800 Subject: [PATCH] 调拔单功能优化 --- rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/TransferServiceImpl.java | 17 +++++++++-------- 1 files changed, 9 insertions(+), 8 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/TransferServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/TransferServiceImpl.java index 0720676..1711af0 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/TransferServiceImpl.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/TransferServiceImpl.java @@ -348,21 +348,22 @@ @Override public IPage<LocItem> getLocsItems(OrgLocParams params, Long loginUserId) { List<Loc> locs = locService.list(new LambdaQueryWrapper<Loc>() + .eq(Loc::getUseStatus, LocStsType.LOC_STS_TYPE_F.type) .eq(!Objects.isNull(params.getOrgAreaId()), Loc::getAreaId, params.getOrgAreaId())); - - Page<LocItem> page = new Page<>(params.getCurrent(), params.getPageSize()); - QueryWrapper<LocItem> wrapper = new QueryWrapper<>(); - wrapper.select("id, matnr_id, maktx, matnr_code, SUM(anfme) anfme, SUM(work_qty) work_qty, SUM(qty) qty, batch, unit, fields_index, model, spec, loc_id ") - .lambda() - .eq(StringUtils.isNotBlank(params.getMatnrCode()), LocItem::getMatnrCode, params.getMatnrCode()) - .like(StringUtils.isNotBlank(params.getMaktx()), LocItem::getMaktx, params.getMaktx()); if (!locs.isEmpty()) { + Page<LocItem> page = new Page<>(params.getCurrent(), params.getPageSize()); + QueryWrapper<LocItem> wrapper = new QueryWrapper<>(); + wrapper.select("id, matnr_id, maktx, matnr_code, SUM(anfme) anfme, SUM(work_qty) work_qty, SUM(qty) qty, batch, unit, fields_index, model, spec, loc_id, loc_code ") + .lambda() + .eq(StringUtils.isNotBlank(params.getMatnrCode()), LocItem::getMatnrCode, params.getMatnrCode()) + .like(StringUtils.isNotBlank(params.getMaktx()), LocItem::getMaktx, params.getMaktx()); Set<Long> locIds = locs.stream().map(Loc::getId).collect(Collectors.toSet()); wrapper.lambda().in(LocItem::getLocId, locIds) .groupBy(LocItem::getBatch, LocItem::getFieldsIndex, LocItem::getMatnrCode); return locItemService.page(page, wrapper); } else { - return locItemService.page(page, wrapper); + IPage<LocItem> page = new Page<>(params.getCurrent(), params.getPageSize()); + return page; } } } -- Gitblit v1.9.1