From f68071dd4e77fde82663cd451a174025292a7a32 Mon Sep 17 00:00:00 2001
From: skyouc <creaycat@gmail.com>
Date: 星期四, 27 十一月 2025 13:55:17 +0800
Subject: [PATCH] 过滤拣货入库明细上传

---
 rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReportMsgServiceImpl.java |  342 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 335 insertions(+), 7 deletions(-)

diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReportMsgServiceImpl.java b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReportMsgServiceImpl.java
index 1a4515f..56a5de0 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReportMsgServiceImpl.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/api/service/impl/ReportMsgServiceImpl.java
@@ -12,6 +12,7 @@
 import com.vincent.rsf.framework.common.R;
 import com.vincent.rsf.framework.exception.CoolException;
 import com.vincent.rsf.server.api.config.RemotesInfoProperties;
+import com.vincent.rsf.server.api.controller.erp.params.ReportDataParam;
 import com.vincent.rsf.server.api.controller.erp.params.ReportParams;
 import com.vincent.rsf.server.api.entity.CommonResponse;
 import com.vincent.rsf.server.api.entity.constant.RcsConstant;
@@ -19,13 +20,16 @@
 import com.vincent.rsf.server.api.entity.params.ErpInspectItem;
 import com.vincent.rsf.server.api.entity.params.ErpInspectParams;
 import com.vincent.rsf.server.api.service.ReportMsgService;
-import com.vincent.rsf.server.manager.entity.WkOrder;
-import com.vincent.rsf.server.manager.entity.WkOrderItem;
-import com.vincent.rsf.server.manager.entity.Purchase;
-import com.vincent.rsf.server.manager.service.AsnOrderItemService;
-import com.vincent.rsf.server.manager.service.AsnOrderService;
-import com.vincent.rsf.server.manager.service.PurchaseService;
+import com.vincent.rsf.server.common.utils.FieldsUtils;
+import com.vincent.rsf.server.manager.entity.*;
+import com.vincent.rsf.server.manager.enums.OrderReportStatus;
+import com.vincent.rsf.server.manager.enums.OrderType;
+import com.vincent.rsf.server.manager.enums.OrderWorkType;
+import com.vincent.rsf.server.manager.service.*;
+import com.vincent.rsf.server.system.entity.User;
+import com.vincent.rsf.server.system.service.UserService;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.http.HttpEntity;
@@ -66,6 +70,12 @@
     private AsnOrderItemService asnOrderItemService;
     @Autowired
     private RemotesInfoProperties.RcsApi rcsApi;
+    @Autowired
+    private UserService userService;
+    @Autowired
+    private StockItemService stockItemService;
+    @Autowired
+    private StockService stockService;
 
     /**
      * @author Ryan
@@ -209,7 +219,8 @@
                 if (result.getCode() == 200) {
                     return R.ok().add(result.getData());
                 } else {
-                    throw new CoolException("淇敼澶辫触锛侊紒");
+                    return R.ok(result.getMsg()).add(result.getData());
+//                    throw new CoolException("淇敼澶辫触锛侊紒");
                 }
             } catch (JsonProcessingException e) {
                 throw new CoolException(e.getMessage());
@@ -257,4 +268,321 @@
             }
         }
     }
+
+
+    /**
+     * @author Ryan
+     * @date 2025/10/28
+     * @description: 涓婁紶宸插畬鎴愯鍗曡嚦ERP骞冲彴
+     * @version 1.0
+     */
+    @Override
+    public void reportOrders(WkOrder order) {
+        ReportParams params = new ReportParams();
+        List<WkOrderItem> orderItems = asnOrderItemService.list(new LambdaQueryWrapper<WkOrderItem>().eq(WkOrderItem::getOrderId, order.getId()));
+        if (orderItems.isEmpty()) {
+            throw new CoolException("璁㈡嵁鏄庣粏涓嶅瓨鍦紒锛�");
+        }
+        List<ReportDataParam> reportData = new ArrayList<>();
+        orderItems.forEach(orderItem -> {
+            ReportDataParam param = new ReportDataParam();
+            User user = userService.getById(order.getUpdateBy());
+            String nickName = null;
+            if (!Objects.isNull(user)) {
+                nickName = user.getNickname();
+            }
+                 //鑾峰彇搴撳瓨搴撲綅淇℃伅
+            if (order.getType().equals(OrderType.ORDER_IN.type)) {
+                //鑾峰彇鍏ュ簱搴撲綅淇℃伅
+                //绛涢�夊綋鍓嶅敮涓�瀛楁鎵�鏈夊嚭鍏ュ簱淇℃伅
+                List<StockItem> stockItems = stockItemService.list(new LambdaQueryWrapper<StockItem>()
+                        .eq(StockItem::getFieldsIndex, orderItem.getFieldsIndex()));
+                //鑾峰彇搴撳瓨涓鍗曞簱浣�
+                Set<Long> longSet = stockItems.stream().map(StockItem::getStockId).collect(Collectors.toSet());
+
+                Stock stocks = stockService.getOne(new LambdaQueryWrapper<Stock>()
+                        .in(Stock::getId, longSet)
+                        .eq(Stock::getType, OrderType.ORDER_IN.type)
+                        .eq(Stock::getSourceCode, order.getCode()));
+                if (!Objects.isNull(stocks)) {
+                    param.setZone(stocks.getLocCode());
+                }
+                //鑾峰彇绱㈠紩鍐呭
+                Map<String, String> fields = FieldsUtils.getFields(orderItem.getFieldsIndex());
+                //璁剧疆閫氱敤鍙傛暟
+                param.setWMSNO(order.getCode())
+                        .setPONO(order.getPoCode())
+                        .setOrderNO(order.getPoCode())
+                        .setOrderDate(order.getCreateTime())
+                        .setItemCode(orderItem.getMatnrCode())
+                        .setEditUser(nickName)
+                        .setEditDate(order.getUpdateTime())
+                        .setZone(stocks.getLocCode())
+                        .setGoodsNO(fields.get("crushNo"))
+                        .setMemoDtl(order.getMemo());
+
+                if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_DONE_IN.type)) {
+                    //閲囪喘鍏ュ簱鍗�
+                    params.setOrderType("PO_Instock").setAction("Update");
+                    //鑾峰彇鎸囧畾鏌ヨ瀛楁CrushNo 绁ㄥ彿
+                    param.setInQty(orderItem.getQty());
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE_RETURN.type)) {
+                    //閲囪喘閫�璐�
+                    params.setOrderType("PR_Outstock").setAction("Update");
+                    param.setOutQty(orderItem.getQty());
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_TERANSFER_IN.type)) {
+                    //璋冩嫈鍏ュ簱鍗�
+                    params.setOrderType("Mv_Instock").setAction("Update");
+
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD.type)) {
+                    //鐢熶骇鍏ュ簱鍗�
+//                params.setOrderType("WO_Outstock").setAction("Update");
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE.type)) {
+                    //鐢熶骇閫�鏂�
+                    params.setOrderType("WR_Instock").setAction("Update");
+                    param.setInQty(orderItem.getQty());
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_RETURN_ORDER.type)) {
+                    //鐢熶骇棰嗘枡
+                    params.setOrderType("WO_Outstock").setAction("Update");
+                    param.setOutQty(orderItem.getQty());
+
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD_ADDITION.type)) {
+                    //鐢熶骇琛ユ枡
+                    params.setOrderType("WR_Instock_BL").setAction("Update");
+                    param.setOutQty(orderItem.getQty());
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_FIX_OUT.type)) {
+                    params.setOrderType("WO_Outstock_WR").setAction("Update");
+                    param.setOutQty(orderItem.getQty());
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_IN.type)) {
+                    //鍏跺畠鍏ュ簱鍗�/鎵嬪姩鍏ュ簱鍗�
+                    params.setOrderType("In_Instock").setAction("Update");
+                    param.setInQty(orderItem.getQty());
+
+                } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER.type)) {
+                    //鍏跺畠鍑哄簱鍗�/鎵嬪姩鍑哄簱鍗�
+                    params.setOrderType("Io_Outstock").setAction("Update");
+                    param.setOutQty(orderItem.getQty());
+                }
+                reportData.add(param);
+
+                params.setData(reportData);
+                try {
+                    R reported = uploadReportOrders(params);
+                    if (Integer.valueOf(reported.get("code").toString()) == 200) {
+                        order.setNtyStatus(OrderReportStatus.ORDER_REPORT_STATUS_ALL.val);
+                        asnOrderService.updateById(order);
+                    }
+                } catch (Exception e) {
+                    log.error("<UNK>", e);
+                }
+                try {
+                    //浼戠湢3绉�
+                    Thread.sleep(3000);
+                } catch (InterruptedException e) {
+                    throw new RuntimeException(e);
+                }
+            } else if (order.getType().equals(OrderType.ORDER_OUT.type)){
+                List<StockItem> stockItems = stockItemService.list(new LambdaQueryWrapper<StockItem>().eq(StockItem::getSourceItemId, orderItem.getId()));
+                if (stockItems.isEmpty()) {
+                    return;
+                }
+                Set<Long> stockIds = stockItems.stream().map(StockItem::getStockId).collect(Collectors.toSet());
+                List<Stock> stocks = stockService.listByIds(stockIds);
+                //杩囨护鎷h揣鍏ュ簱鏄庣粏锛岄伩鍏嶄笂鎶�
+                List<Stock> stockList = stocks.stream().filter(stock -> stock.getType().equals(OrderType.ORDER_OUT.type)).collect(Collectors.toList());
+                List<Long> list = stockList.stream().map(Stock::getId).collect(Collectors.toList());
+                List<StockItem> stockItems1 = stockItemService.list(new LambdaQueryWrapper<StockItem>().in(StockItem::getStockId, list));
+                String finalNickName = nickName;
+                stockItems1.forEach(stockItem -> {
+                    List<ReportDataParam> dataParams = new ArrayList<>();
+                    //鑾峰彇绱㈠紩鍐呭
+                    Map<String, String> fields = FieldsUtils.getFields(stockItem.getFieldsIndex());
+                    //璁剧疆閫氱敤鍙傛暟
+                    param.setWMSNO(order.getCode())
+                            .setPONO(order.getPoCode())
+                            .setOrderNO(order.getPoCode())
+                            .setOrderDate(order.getCreateTime())
+                            .setItemCode(stockItem.getMatnrCode())
+                            .setEditUser(finalNickName)
+                            .setEditDate(order.getUpdateTime())
+                            .setGoodsNO(fields.get("crushNo"))
+                            .setMemoDtl(order.getMemo());
+                    if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_DONE_IN.type)) {
+                        //閲囪喘鍏ュ簱鍗�
+                        params.setOrderType("PO_Instock").setAction("Update");
+                        //鑾峰彇鎸囧畾鏌ヨ瀛楁CrushNo 绁ㄥ彿
+                        param.setInQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE_RETURN.type)) {
+                        //閲囪喘閫�璐�
+                        params.setOrderType("PR_Outstock").setAction("Update");
+                        param.setOutQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_TERANSFER_IN.type)) {
+                        //璋冩嫈鍏ュ簱鍗�
+                        params.setOrderType("Mv_Instock").setAction("Update");
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD.type)) {
+                        //鐢熶骇鍏ュ簱鍗�
+//                      params.setOrderType("WO_Outstock").setAction("Update");
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE.type)) {
+                        //鐢熶骇閫�鏂�
+                        params.setOrderType("WR_Instock").setAction("Update");
+                        param.setInQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_RETURN_ORDER.type)) {
+                        //鐢熶骇棰嗘枡
+                        params.setOrderType("WO_Outstock").setAction("Update");
+                        param.setOutQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD_ADDITION.type)) {
+                        //鐢熶骇琛ユ枡
+                        params.setOrderType("WR_Instock_BL").setAction("Update");
+                        param.setOutQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_FIX_OUT.type)) {
+                        params.setOrderType("WO_Outstock_WR").setAction("Update");
+                        param.setOutQty(stockItem.getAnfme());
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_IN.type)) {
+                        //鍏跺畠鍏ュ簱鍗�/鎵嬪姩鍏ュ簱鍗�
+                        params.setOrderType("In_Instock").setAction("Update");
+                        param.setInQty(stockItem.getAnfme());
+
+                    } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER.type)) {
+                        //鍏跺畠鍑哄簱鍗�/鎵嬪姩鍑哄簱鍗�
+                        params.setOrderType("Io_Outstock").setAction("Update");
+                        param.setOutQty(stockItem.getAnfme());
+                    }
+                    dataParams.add(param);
+
+                    params.setData(dataParams);
+                    try {
+                        R reported = uploadReportOrders(params);
+                        if (Integer.valueOf(reported.get("code").toString()) == 200) {
+                            order.setReportOnce(5);
+                            asnOrderService.updateById(order);
+                        }
+                    } catch (Exception e) {
+                        log.error("<UNK>", e);
+                    }
+                    try {
+                        //浼戠湢3绉�
+                        Thread.sleep(3000);
+                    } catch (InterruptedException e) {
+                        throw new RuntimeException(e);
+                    }
+                });
+            }
+        });
+
+    }
+
+    /**
+     * @author Ryan
+     * @date 2025/11/10
+     * @description: 鍏ュ簱浠诲姟鏄庣粏涓婃姤
+     * @version 1.0
+     */
+    @Override
+    public void reportOrderItem(WkOrderItem orderItem) {
+        ReportParams params = new ReportParams();
+        WkOrder order = asnOrderService.getById(orderItem.getOrderId());
+        if (Objects.isNull(order)) {
+            throw new RuntimeException("鍗曟嵁涓嶅瓨鍦ㄦ垨宸插畬鎴愶紒锛�");
+        }
+        List<ReportDataParam> reportData = new ArrayList<>();
+        ReportDataParam param = new ReportDataParam();
+        User user = userService.getById(orderItem.getUpdateBy());
+        String nickName = null;
+        if (!Objects.isNull(user)) {
+            nickName = user.getNickname();
+        }
+        //鑾峰彇鍏ュ簱搴撲綅淇℃伅
+        if (order.getType().equals(OrderType.ORDER_IN.type)) {
+            //绛涢�夊綋鍓嶅敮涓�瀛楁鎵�鏈夊嚭鍏ュ簱淇℃伅
+            List<StockItem> stockItems = stockItemService.list(new LambdaQueryWrapper<StockItem>()
+                    .eq(StockItem::getFieldsIndex, orderItem.getFieldsIndex()));
+            //鑾峰彇搴撳瓨涓鍗曞簱浣�
+            Set<Long> longSet = stockItems.stream().map(StockItem::getStockId).collect(Collectors.toSet());
+            //鑾峰彇搴撳瓨搴撲綅淇℃伅
+            Stock stocks = stockService.getOne(new LambdaQueryWrapper<Stock>()
+                    .in(Stock::getId, longSet)
+                    .eq(Stock::getType, OrderType.ORDER_IN.type)
+                    .eq(Stock::getSourceCode, order.getCode()));
+            if (!Objects.isNull(stocks)) {
+                param.setZone(stocks.getLocCode());
+            }
+        }
+        //鑾峰彇绱㈠紩鍐呭
+        Map<String, String> fields = FieldsUtils.getFields(orderItem.getFieldsIndex());
+
+        //璁剧疆閫氱敤鍙傛暟
+        param.setWMSNO(order.getCode())
+                .setPONO(order.getPoCode())
+                .setOrderNO(order.getPoCode())
+                .setOrderDate(order.getCreateTime())
+                .setItemCode(orderItem.getMatnrCode())
+                .setEditUser(nickName)
+                .setEditDate(order.getUpdateTime())
+                .setGoodsNO(fields.get("crushNo"))
+                .setMemoDtl(order.getMemo());
+
+        if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_DONE_IN.type)) {
+            //閲囪喘鍏ュ簱鍗�
+            params.setOrderType("PO_Instock").setAction("Update");
+            //鑾峰彇鎸囧畾鏌ヨ瀛楁CrushNo 绁ㄥ彿
+            param.setInQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE_RETURN.type)) {
+            //閲囪喘閫�璐�
+            params.setOrderType("PR_Outstock").setAction("Update");
+            param.setOutQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_TERANSFER_IN.type)) {
+            //璋冩嫈鍏ュ簱鍗�
+            params.setOrderType("Mv_Instock").setAction("Update");
+            param.setInQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD.type)) {
+            //鐢熶骇鍏ュ簱鍗�
+//                params.setOrderType("WO_Outstock").setAction("Update");
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PURCHASE.type)) {
+            //鐢熶骇閫�鏂�
+            params.setOrderType("WR_Instock").setAction("Update");
+            param.setInQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_RETURN_ORDER.type)) {
+            //鐢熶骇棰嗘枡
+            params.setOrderType("WO_Outstock").setAction("Update");
+            param.setOutQty(orderItem.getQty());
+
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_PROD_ADDITION.type)) {
+            //鐢熶骇琛ユ枡
+            params.setOrderType("WR_Instock_BL").setAction("Update");
+            param.setOutQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_FIX_OUT.type)) {
+            params.setOrderType("WO_Outstock_WR").setAction("Update");
+            param.setOutQty(orderItem.getQty());
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER_IN.type)) {
+            //鍏跺畠鍏ュ簱鍗�/鎵嬪姩鍏ュ簱鍗�
+            params.setOrderType("In_Instock").setAction("Update");
+            param.setInQty(orderItem.getQty());
+
+        } else if (order.getWkType().equals(OrderWorkType.ORDER_WORK_TYPE_OTHER.type)) {
+            //鍏跺畠鍑哄簱鍗�/鎵嬪姩鍑哄簱鍗�
+            params.setOrderType("Io_Outstock").setAction("Update");
+            param.setOutQty(orderItem.getQty());
+        }
+        reportData.add(param);
+        params.setData(reportData);
+        try {
+            R reported = uploadReportOrders(params);
+            if (Integer.valueOf(reported.get("code").toString()) == 200) {
+                //淇敼璁㈠崟涓婃姤娆℃暟
+                order.setReportOnce(order.getReportOnce() + 1);
+                asnOrderService.updateById(order);
+            }
+        } catch (Exception e) {
+            log.error("<UNK>", e);
+        }
+
+        try {
+            //浼戠湢3绉�
+            Thread.sleep(3000);
+        } catch (InterruptedException e) {
+            throw new RuntimeException(e);
+        }
+    }
+
+
 }

--
Gitblit v1.9.1