From e78b9a8617ec78c9ccd0fc4dc635f494644e33a2 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期四, 10 四月 2025 13:52:15 +0800 Subject: [PATCH] 导出模板修改 --- rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java | 9 ++++++++- rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java | 15 +++++++++++---- rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderServiceImpl.java | 14 +++++++++----- rsf-server/src/main/resources/mapper/manager/AsnOrderItemMapper.xml | 1 + 4 files changed, 29 insertions(+), 10 deletions(-) diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java index 2e9e296..b6458c5 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java @@ -13,6 +13,7 @@ import com.vincent.rsf.server.manager.controller.params.AsnOrderAndItemsParams; import com.vincent.rsf.server.manager.controller.params.BatchUpdateParam; import com.vincent.rsf.server.manager.entity.AsnOrder; +import com.vincent.rsf.server.manager.entity.Matnr; import com.vincent.rsf.server.manager.service.AsnOrderService; import com.vincent.rsf.server.system.constant.SerialRuleCode; import com.vincent.rsf.server.system.controller.BaseController; @@ -121,7 +122,13 @@ @PostMapping("/asnOrder/export") @ApiOperation("瀵煎嚭") public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { - ExcelUtil.build(ExcelUtil.create(asnOrderService.list(), AsnOrder.class), response); + List<AsnOrder> orders = new ArrayList<>(); + if (!Objects.isNull(map.get("ids"))) { + orders = asnOrderService.list(new LambdaQueryWrapper<AsnOrder>().in(AsnOrder::getId, map.get("ids")).eq(AsnOrder::getStatus, 1)); + } else { + orders = asnOrderService.list(new LambdaQueryWrapper<AsnOrder>().last("limit 1")); + } + ExcelUtil.build(ExcelUtil.create(orders, AsnOrder.class), response); } /** diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java index c04887e..267ca22 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderItemController.java @@ -118,10 +118,17 @@ @PostMapping("/asnOrderItem/export") @ApiOperation("瀵煎嚭鏀惰揣閫氱煡鍗曟槑缁�") public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { - AsnOrderTemplate template = ExcelUtil.mockData(AsnOrderTemplate.class); - List<AsnOrderTemplate> list = new ArrayList<>(); - list.add(template); - ExcelUtil.build(ExcelUtil.create(list, AsnOrderTemplate.class, true), response); +// AsnOrderTemplate template = ExcelUtil.mockData(AsnOrderTemplate.class); +// List<AsnOrderTemplate> list = new ArrayList<>(); +// list.add(template); + List<AsnOrderItem> orderItems = new ArrayList<>(); + if (!Objects.isNull(map.get("ids"))) { + orderItems = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>().in(AsnOrderItem::getId, map.get("ids")).eq(AsnOrderItem::getStatus, 1)); + } else { + orderItems = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>().last("limit 1")); + } + + ExcelUtil.build(ExcelUtil.create(orderItems, AsnOrderItem.class, true), response); } diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderServiceImpl.java index b2ee5fa..6c91462 100644 --- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderServiceImpl.java +++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/service/impl/AsnOrderServiceImpl.java @@ -238,11 +238,6 @@ if (Objects.isNull(order)) { throw new CoolException("鍗曟嵁涓嶅瓨鍦紒锛�"); } - order.setExceStatus(Short.parseShort(AsnExceStatus.ASN_EXCE_STATUS_TASK_CLOSE.val)); - - if (!this.updateById(order)) { - throw new CoolException("鍗曟嵁鍏抽棴澶辫触锛侊紒"); - } try { operateOrderLogs(order); } catch (Exception e) { @@ -263,6 +258,15 @@ if (Objects.isNull(asrder) || Objects.isNull(asrder.getId())) { throw new CoolException("鍙傛暟涓嶈兘涓虹┖锛侊紒"); } + asrder.setExceStatus(Short.parseShort(AsnExceStatus.ASN_EXCE_STATUS_TASK_CLOSE.val)); + + if (!this.updateById(asrder)) { + throw new CoolException("鍗曟嵁鍏抽棴澶辫触锛侊紒"); + } + List<AsnOrderItem> orderItems = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>().eq(AsnOrderItem::getAsnId, asrder.getId())); + if (orderItems.isEmpty()) { + throw new CoolException("鏀惰揣鏄庣粏涓虹┖锛侊紒"); + } if (Objects.isNull(asrder.getAnfme()) || asrder.getAnfme().compareTo(0.00) == 0) { throw new CoolException("鏀惰揣鏁伴噺涓嶈兘涓洪浂锛侊紒"); } diff --git a/rsf-server/src/main/resources/mapper/manager/AsnOrderItemMapper.xml b/rsf-server/src/main/resources/mapper/manager/AsnOrderItemMapper.xml index 15f722f..aa6bbcf 100644 --- a/rsf-server/src/main/resources/mapper/manager/AsnOrderItemMapper.xml +++ b/rsf-server/src/main/resources/mapper/manager/AsnOrderItemMapper.xml @@ -18,6 +18,7 @@ stock_unit, pur_qty, pur_unit, + prod_time, qty, splr_code, splr_batch, -- Gitblit v1.9.1