From f5b4f189e460480a96acf3d1864344d8d5d92695 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期三, 07 五月 2025 10:18:57 +0800
Subject: [PATCH] PO单模板优化 ASN单模板优化

---
 rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/AsnOrderController.java |   75 +++++++++++++++++++++++++++++++++----
 1 files changed, 66 insertions(+), 9 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..d3c112c 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
@@ -1,10 +1,15 @@
 package com.vincent.rsf.server.manager.controller;
 
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.vincent.rsf.framework.common.Cools;
 import com.vincent.rsf.framework.common.R;
 import com.vincent.rsf.framework.exception.CoolException;
+import com.vincent.rsf.server.manager.enums.OrderType;
+import com.vincent.rsf.server.manager.enums.OrderWorkType;
 import com.vincent.rsf.server.common.utils.ExcelUtil;
 import com.vincent.rsf.server.common.annotation.OperationLog;
 import com.vincent.rsf.server.common.domain.BaseParam;
@@ -13,6 +18,10 @@
 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.AsnOrderItem;
+import com.vincent.rsf.server.manager.entity.excel.AsnOrderTemplate;
+import com.vincent.rsf.server.manager.enums.AsnExceStatus;
+import com.vincent.rsf.server.manager.service.AsnOrderItemService;
 import com.vincent.rsf.server.manager.service.AsnOrderService;
 import com.vincent.rsf.server.system.constant.SerialRuleCode;
 import com.vincent.rsf.server.system.controller.BaseController;
@@ -21,10 +30,9 @@
 import io.swagger.annotations.ApiOperation;
 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.mail.Multipart;
 import javax.servlet.http.HttpServletResponse;
 import java.util.*;
 
@@ -34,13 +42,18 @@
 
     @Autowired
     private AsnOrderService asnOrderService;
+    @Autowired
+    private AsnOrderItemService asnOrderItemService;
 
     @PreAuthorize("hasAuthority('manager:asnOrder:list')")
     @PostMapping("/asnOrder/page")
     public R page(@RequestBody Map<String, Object> map) {
         BaseParam baseParam = buildParam(map, BaseParam.class);
         PageParam<AsnOrder, BaseParam> pageParam = new PageParam<>(baseParam, AsnOrder.class);
-        return R.ok().add(asnOrderService.page(pageParam, pageParam.buildWrapper(true)));
+        QueryWrapper<AsnOrder> queryWrapper = pageParam.buildWrapper(true);
+        List<String> asList = Arrays.asList(OrderType.ORDER_OUT.type);
+        queryWrapper.notIn("type", asList);
+        return R.ok().add(asnOrderService.page(pageParam, queryWrapper));
     }
 
     @PreAuthorize("hasAuthority('manager:asnOrder:list')")
@@ -95,11 +108,20 @@
     @PreAuthorize("hasAuthority('manager:asnOrder:remove')")
     @OperationLog("Delete ASN鍗曟嵁")
     @PostMapping("/asnOrder/remove/{ids}")
+    @Transactional(rollbackFor = Exception.class)
     public R remove(@PathVariable Long[] ids) {
-        if (!asnOrderService.removeByIds(Arrays.asList(ids))) {
-            return R.error("Delete Fail");
+        if (!asnOrderService.remove(new LambdaQueryWrapper<AsnOrder>().in(AsnOrder::getId, Arrays.asList(ids)).eq(AsnOrder::getExceStatus, AsnExceStatus.ASN_EXCE_STATUS_UN_EXCE.val))) {
+            return R.error("浠诲姟涓崟鎹笉鍙垹闄わ紒锛�");
         }
-        return R.ok("Delete Success").add(ids);
+        for (Long id : ids) {
+            List<AsnOrderItem> list = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>().eq(AsnOrderItem::getAsnId, id));
+            if (!list.isEmpty()) {
+                if (!asnOrderItemService.remove(new LambdaQueryWrapper<AsnOrderItem>().in(AsnOrderItem::getAsnId, ids))) {
+                    throw new CoolException("Details Delete Fail");
+                }
+            }
+        }
+        return R.ok("鍒犻櫎鎴愬姛锛侊紒").add(ids);
     }
 
     @PreAuthorize("hasAuthority('manager:asnOrder:list')")
@@ -121,11 +143,46 @@
     @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"))) {
+            List<Long> ids = JSONArray.parseArray(JSONObject.toJSONString(map.get("ids")), Long.class);
+            if (!ids.isEmpty()) {
+                orders = asnOrderService.list(new LambdaQueryWrapper<AsnOrder>().in(AsnOrder::getId, ids));
+            } else {
+                orders = asnOrderService.list(new LambdaQueryWrapper<>());
+            }
+        } else {
+            orders = asnOrderService.list();
+        }
+        List<AsnOrderTemplate> orderTemplates = new ArrayList<>();
+        for (AsnOrder order : orders) {
+            List<AsnOrderItem> orderItems = asnOrderItemService.list(new LambdaQueryWrapper<AsnOrderItem>().eq(AsnOrderItem::getAsnId, order.getId()));
+            for (AsnOrderItem item : orderItems) {
+                if (Objects.isNull(item)) {
+                    continue;
+                }
+                AsnOrderTemplate template = new AsnOrderTemplate();
+                template.setCode(order.getCode())
+                        .setType(OrderType.getValType(order.getType()))
+                        .setWkType(OrderWorkType.getWorkDesc(order.getWkType()))
+                        .setAnfme(item.getAnfme() + "")
+                        .setMaktx(item.getMaktx())
+                        .setMemo(item.getMemo())
+                        .setMatnrCode(item.getMatnrCode())
+                        .setPoCode(item.getPoCode())
+                        .setSplrName(item.getSplrName())
+                        .setPlatItemId(item.getPlatItemId())
+                        .setSplrBatch(item.getSplrBatch())
+                        .setSplrCode(item.getSplrCode());
+                orderTemplates.add(template);
+            }
+        }
+        ExcelUtil.build(ExcelUtil.create(orderTemplates, AsnOrderTemplate.class), response);
     }
 
     /**
      * 璐ㄦ涓婃姤
+     *
      * @param orders
      * @return
      */
@@ -146,7 +203,7 @@
     @PostMapping("/asnOrder/matnr/list")
     @ApiOperation("鐗╂枡鑾峰彇璁㈠崟")
     @PreAuthorize("hasAuthority('manager:asnOrder:list')")
-    public R getListByMatnr(@RequestBody Map<String, String> params){
+    public R getListByMatnr(@RequestBody Map<String, String> params) {
         if (Objects.isNull(params)) {
             return R.error("鏌ヨ鏉′欢涓嶈兘涓虹┖锛侊紒");
         }
@@ -159,7 +216,7 @@
     @PreAuthorize("hasAuthority('manager:asnOrder:save')")
     public R orderAndItem(@RequestBody AsnOrderAndItemsParams params) throws Exception {
         if (Objects.isNull(params)) {
-           return R.error("鍙傛暟涓嶈兘涓虹┖锛侊紒");
+            return R.error("鍙傛暟涓嶈兘涓虹┖锛侊紒");
         }
         return asnOrderService.saveOrderAndItems(params, getLoginUserId());
     }

--
Gitblit v1.9.1