From eeebc22772cbf7dc03ed4bc6f734e6de9f5c3e75 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 06 八月 2025 10:55:56 +0800
Subject: [PATCH] art: 订单BOM、物料工序 后端代码修改、优化

---
 src/main/java/org/jeecg/modules/pms/service/impl/PmsMaterialProcessServiceImpl.java |   73 +++++++++++++++++++++++++++---------
 1 files changed, 55 insertions(+), 18 deletions(-)

diff --git a/src/main/java/org/jeecg/modules/pms/service/impl/PmsMaterialProcessServiceImpl.java b/src/main/java/org/jeecg/modules/pms/service/impl/PmsMaterialProcessServiceImpl.java
index 3629fc2..dfc6bee 100644
--- a/src/main/java/org/jeecg/modules/pms/service/impl/PmsMaterialProcessServiceImpl.java
+++ b/src/main/java/org/jeecg/modules/pms/service/impl/PmsMaterialProcessServiceImpl.java
@@ -1,43 +1,80 @@
 package org.jeecg.modules.pms.service.impl;
 
+import cn.hutool.core.collection.CollectionUtil;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import org.apache.commons.lang.StringUtils;
+import org.apache.commons.lang3.StringUtils;
+import org.jeecg.modules.mes.entity.MesProductionOrder;
 import org.jeecg.modules.pms.entity.PmsMaterialProcess;
 import org.jeecg.modules.pms.mapper.PmsMaterialProcessMapper;
 import org.jeecg.modules.pms.service.IPmsMaterialProcessService;
+import org.jeecg.modules.sap.dto.OrderProcessDTO;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
-import javax.servlet.http.HttpServletRequest;
-import java.util.HashMap;
+import java.util.List;
 import java.util.Map;
+import java.util.stream.Collectors;
 
 /**
  * @Description: 鐗╂枡宸ュ簭
  * @Author: jeecg-boot
- * @Date:   2025-07-01
+ * @Date: 2025-07-01
  * @Version: V1.0
  */
 @Service
 public class PmsMaterialProcessServiceImpl extends ServiceImpl<PmsMaterialProcessMapper, PmsMaterialProcess> implements IPmsMaterialProcessService {
 
     @Override
-    public IPage<Map<String, Object>> getpmsMaterialProcessListData(Integer pageNo, Integer pageSize, HttpServletRequest req) {
-        IPage<Map> pageData = new Page<Map>(pageNo, pageSize);
-        Map<String, String> paramMap = new HashMap<String, String>();
-        Map<String, String[]> parameterMap = req.getParameterMap();
-        if (null != parameterMap) {
-            if (parameterMap.containsKey("materialNumber") && StringUtils.isNotBlank(parameterMap.get("materialNumber")[0])) {
-                paramMap.put("materialNumber", parameterMap.get("materialNumber")[0]);
-            }
-            if (parameterMap.containsKey("materialName") && StringUtils.isNotBlank(parameterMap.get("materialName")[0])) {
-                paramMap.put("materialName", parameterMap.get("materialName")[0].trim());
-            }
-            if (parameterMap.containsKey("batchNumber") && StringUtils.isNotBlank(parameterMap.get("batchNumber")[0])) {
-                paramMap.put("batchNumber", parameterMap.get("batchNumber")[0].trim());
+    @Transactional(rollbackFor = Exception.class)
+    public boolean saveOrUpdateOrderProcess(Map<String, MesProductionOrder> orderMap, List<OrderProcessDTO> orderProcessDTOList) {
+        for (Map.Entry<String, MesProductionOrder> entry : orderMap.entrySet()) {
+            MesProductionOrder order = entry.getValue();
+            //鍒犻櫎鍘熸湁鐨勬暟鎹�
+            this.removeByOrderId(order.getId());
+            //閲嶆柊鏂板宸ュ簭淇℃伅
+            List<OrderProcessDTO> collect = orderProcessDTOList.stream().filter(orderProcessDTO -> entry.getKey().equals(orderProcessDTO.getAUFNR())).collect(Collectors.toList());
+            if (CollectionUtil.isNotEmpty(collect)) {
+                List<PmsMaterialProcess> list = collect.stream().map(orderBomDTO -> new PmsMaterialProcess(order.getId(), order.getMaterialName(), orderBomDTO)).collect(Collectors.toList());
+                super.saveBatch(list);
             }
         }
-        return super.getBaseMapper().getpmsMaterialProcessListData(pageData, paramMap);
+        return true;
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public void removeByOrderId(String orderId) {
+        LambdaQueryWrapper<PmsMaterialProcess> queryWrapper = new LambdaQueryWrapper<>();
+        queryWrapper.eq(PmsMaterialProcess::getOrderId, orderId);
+        super.remove(queryWrapper);
+    }
+
+    @Override
+    public IPage<PmsMaterialProcess> queryPageList(Page<PmsMaterialProcess> page, PmsMaterialProcess query) {
+        QueryWrapper<PmsMaterialProcess> queryWrapper = new QueryWrapper<>();
+        queryWrapper.orderByDesc("pbm.create_time");
+        if (query != null) {
+            //鐗╂枡缂栫爜 妯$硦鏌ヨ
+            if (org.apache.commons.lang3.StringUtils.isNotBlank(query.getMaterialNumber())) {
+                queryWrapper.like("pbm.material_number", query.getMaterialNumber());
+            }
+            //鐗╂枡鍚嶇О 妯$硦鏌ヨ
+            if (org.apache.commons.lang3.StringUtils.isNotBlank(query.getMaterialName())) {
+                queryWrapper.like("pbm.material_name", query.getMaterialName());
+            }
+            //宸ュ簭鍙� 妯$硦鏌ヨ
+            if (StringUtils.isNotBlank(query.getProcessCode())) {
+                queryWrapper.like("pbm.process_code", query.getProcessCode());
+            }
+            //璁㈠崟鍙� 妯$硦鏌ヨ
+            if (StringUtils.isNotBlank(query.getOrderCode())) {
+                queryWrapper.like("po.order_code", query.getOrderCode());
+            }
+        }
+        return this.getBaseMapper().queryPageList(page, queryWrapper);
     }
 }

--
Gitblit v1.9.3