From b67bf724fc788cb3b86641c7eb7a35cdbc4c7a93 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期二, 06 五月 2025 20:17:25 +0800 Subject: [PATCH] PO单导入功能优化 --- rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java | 18 +++++++++++------- 1 files changed, 11 insertions(+), 7 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java index d0df993..6ad7541 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/MobileServiceImpl.java @@ -447,7 +447,8 @@ */ @Override public R getDeltByCode(Map<String, Object> params) { - String code = params.get("code").toString(); + Object code = params.get("code"); + Object matnrCode = params.get("matnrCode"); String batch = null; if (!Objects.isNull(params.get("batch"))) { batch = params.get("batch").toString(); @@ -455,10 +456,11 @@ //TODO 鍚庣画闇�鏍规嵁绛栫暐閰嶇疆锛岃幏鍙栫粍鎷栨暟鎹�傚锛氭贩瑁咃紝鎸夋壒娆℃贩瑁呯瓑 LambdaQueryWrapper<WarehouseAreasItem> queryWrapper = new QueryWrapper<WarehouseAreasItem>() .select("SUM(anfme) as anfme, track_code, asn_code, id, splr_batch, ispt_result, plat_item_id, batch,unit, stock_unit, qty, work_qty, matnr_code, matnr_id, maktx").lambda() - .eq(StringUtils.isNotBlank(code), WarehouseAreasItem::getTrackCode, code) + .eq(!Objects.isNull(code), WarehouseAreasItem::getTrackCode, code) .eq(StringUtils.isNotBlank(batch), WarehouseAreasItem::getSplrBatch, batch) + .eq(!Objects.isNull(matnrCode), WarehouseAreasItem::getMatnrCode, matnrCode) .groupBy(WarehouseAreasItem::getSplrBatch, WarehouseAreasItem::getAsnId, WarehouseAreasItem::getAreaId, WarehouseAreasItem::getMatnrId); - return R.ok(warehouseAreasItemService.getOne(queryWrapper, false)); + return R.ok(warehouseAreasItemService.list(queryWrapper)); } /** @@ -472,6 +474,11 @@ @Override public WaitPakin mergeItems(WaitPakinParam waitPakin, Long userId) { return waitPakinService.mergeItems(waitPakin, userId); + } + + @Override + public WaitPakin mergeMatnrItems(WaitPakinParam waitPakin, Long userId) { + return waitPakinService.mergeMatnrItems(waitPakin, userId); } /** @@ -860,11 +867,8 @@ } else { List<String> list = pakinItems.stream().map(WaitPakinItem::getTrackCode).collect(Collectors.toList()); LambdaQueryWrapper<WarehouseAreasItem> queryWrapper = new QueryWrapper<WarehouseAreasItem>() - .select("SUM(anfme) as anfme, track_code, asn_code, id, splr_batch, ispt_result, plat_item_id, batch, qty, work_qty, matnr_code, matnr_id, maktx") .lambda() - .in(WarehouseAreasItem::getTrackCode, list) - .groupBy(WarehouseAreasItem::getSplrBatch, - WarehouseAreasItem::getTrackCode); + .in(WarehouseAreasItem::getTrackCode, list); List<WarehouseAreasItem> warehouseAreasItems = warehouseAreasItemService.list(queryWrapper); for (int i = 0; i < warehouseAreasItems.size(); i++) { for (WaitPakinItem pakinItem : pakinItems) { -- Gitblit v1.9.1