From ac4341ea6b66ae02427d39d35f41d42d78b2eb2e Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 14 二月 2025 10:08:32 +0800
Subject: [PATCH] #

---
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java |   64 +++++++++++++++++++++++++++++++-
 1 files changed, 62 insertions(+), 2 deletions(-)

diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java
index d7f845a..436a0cc 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java
@@ -5,7 +5,9 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.zy.asrs.framework.common.Cools;
 import com.zy.asrs.framework.common.R;
+import com.zy.asrs.framework.exception.CoolException;
 import com.zy.asrs.wms.asrs.entity.*;
+import com.zy.asrs.wms.asrs.entity.template.WaitPakinTemplate;
 import com.zy.asrs.wms.asrs.service.*;
 import com.zy.asrs.wms.common.annotation.OperationLog;
 import com.zy.asrs.wms.common.domain.BaseParam;
@@ -15,8 +17,8 @@
 import com.zy.asrs.wms.utils.ExcelUtil;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.security.access.prepost.PreAuthorize;
-import org.springframework.transaction.annotation.Transactional;
 import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
 
 import javax.servlet.http.HttpServletResponse;
 import java.util.*;
@@ -27,6 +29,10 @@
 
     @Autowired
     private WaitPakinService waitPakinService;
+    @Autowired
+    private OrderService orderService;
+    @Autowired
+    private OrderDetlService orderDetlService;
 
     @PreAuthorize("hasAuthority('asrs:waitPakin:list')")
     @PostMapping("/waitPakin/page")
@@ -119,7 +125,61 @@
     @PreAuthorize("hasAuthority('asrs:waitPakin:list')")
     @PostMapping("/waitPakin/export")
     public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
-        ExcelUtil.build(ExcelUtil.create(waitPakinService.list(), WaitPakin.class), response);
+        BaseParam baseParam = buildParam(map, BaseParam.class);
+        PageParam<WaitPakin, BaseParam> pageParam = new PageParam<>(baseParam, WaitPakin.class);
+        List<WaitPakin> data = waitPakinService.list(pageParam.buildWrapper(true));
+
+        ExcelUtil.build(ExcelUtil.create(data, WaitPakin.class), response);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:waitPakin:list')")
+    @PostMapping("/waitPakin/exportTemplate")
+    public void exportTemplate(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+        ArrayList<WaitPakinTemplate> list = new ArrayList<>();
+        ExcelUtil.build(ExcelUtil.create(list, WaitPakinTemplate.class), response);
+    }
+
+    @PostMapping("/waitPakin/upload")
+    public R upload(@RequestParam("file") MultipartFile file) {
+        List<WaitPakinTemplate> list = ExcelUtil.parseExcelFile(file, WaitPakinTemplate.class);
+        for (WaitPakinTemplate waitPakinTemplate : list) {
+            Order order = orderService.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNo, waitPakinTemplate.getOrderNo()).eq(Order::getStatus, 1));
+            if (order == null) {
+                throw new CoolException("璁㈠崟涓嶅瓨鍦�");
+            }
+
+            LambdaQueryWrapper<OrderDetl> wrapper = new LambdaQueryWrapper<OrderDetl>().eq(OrderDetl::getOrderId, order.getId());
+            if (!Cools.isEmpty(waitPakinTemplate.getBatch())) {
+                wrapper.eq(OrderDetl::getBatch, waitPakinTemplate.getBatch());
+            }
+            List<OrderDetl> orderDetls = orderDetlService.list(wrapper);
+            if (orderDetls.isEmpty()) {
+                throw new CoolException("璁㈠崟鏄庣粏涓嶅瓨鍦�");
+            }
+
+            OrderDetl orderDetl = null;
+            for (OrderDetl detl : orderDetls) {
+                Mat mat = detl.getMat$();
+                if (mat.getMatnr().equals(waitPakinTemplate.getMatnr())) {
+                    orderDetl = detl;
+                }
+            }
+
+            if (orderDetl == null) {
+                throw new CoolException("璁㈠崟鏄庣粏涓嶅瓨鍦�");
+            }
+
+            WaitPakin waitPakin = new WaitPakin();
+            waitPakin.setOrderId(order.getId());
+            waitPakin.setOrderNo(order.getOrderNo());
+            waitPakin.setAnfme(waitPakinTemplate.getAnfme());
+            waitPakin.setBarcode(waitPakinTemplate.getBarcode());
+            waitPakin.setDetlId(orderDetl.getId());
+            waitPakin.setMatnr(orderDetl.getMat$().getMatnr());
+            waitPakin.setBatch(orderDetl.getBatch());
+            waitPakinService.comb(waitPakin);
+        }
+        return R.ok();
     }
 
 }

--
Gitblit v1.9.1