From a8bddf65438ac58787c5b4abee5da145a2d9d2ab Mon Sep 17 00:00:00 2001
From: wu <731351411@qq.com>
Date: 星期二, 28 十月 2025 09:44:27 +0800
Subject: [PATCH] 增加新切割保存方法、前端显示防错位、切割钢化排产防重复、根据标签切换接口

---
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java |  145 ++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 134 insertions(+), 11 deletions(-)

diff --git a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java
index 964898a..f6c14db 100644
--- a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java
+++ b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java
@@ -1,13 +1,17 @@
 package com.mes.pp.service.impl;
 
+import cn.smallbun.screw.core.util.CollectionUtils;
 import com.baomidou.dynamic.datasource.annotation.DS;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.github.yulichang.base.MPJBaseServiceImpl;
+import com.mes.engineerScheduling.entity.EngineerScheduling;
+import com.mes.engineerScheduling.service.EngineerSchedulingService;
 import com.mes.engineering.entity.Engineering;
 import com.mes.engineering.service.EngineeringService;
 import com.mes.pp.entity.OptimizeProject;
+import com.mes.pp.entity.dto.ProgressDTO;
 import com.mes.pp.entity.request.OptimizeRequest;
 import com.mes.pp.mapper.OptimizeProjectMapper;
 import com.mes.pp.service.OptimizeProjectService;
@@ -15,8 +19,14 @@
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
+import java.time.LocalDateTime;
+import java.util.ArrayList;
+import java.util.HashSet;
 import java.util.List;
+import java.util.Set;
+import java.util.stream.Collectors;
 
 /**
  * <p>
@@ -32,13 +42,18 @@
 public class OptimizeProjectServiceImpl extends MPJBaseServiceImpl<OptimizeProjectMapper, OptimizeProject> implements OptimizeProjectService {
     @Autowired
     private EngineeringService engineeringService;
+    @Autowired
+    private EngineerSchedulingService engineerSchedulingService;
 
     @Override
     public List<OptimizeProject> listByState(OptimizeRequest optimizeRequest) {
         //PP琛ㄦ湭寮�濮嬬殑宸ョ▼鍙�
+        // 璁$畻浜屼釜鏈堝墠鐨勬椂闂�
+        LocalDateTime twoMonthAgo = LocalDateTime.now().minusMonths(2);
         LambdaQueryWrapper<OptimizeProject> wrapper = new LambdaQueryWrapper<>();
-        wrapper.select(OptimizeProject::getProjectNo)
-                .eq(OptimizeProject::getState, optimizeRequest.getState());
+        wrapper.select(OptimizeProject::getProjectNo, OptimizeProject::getProjectName)
+                .eq(OptimizeProject::getState, optimizeRequest.getState())
+                .ge(OptimizeProject::getCreateTime, twoMonthAgo);
         List<OptimizeProject> glass = this.list(wrapper);
         //鏆傚仠鐨勫伐绋嬪彿
         List<Engineering> engineerings = engineeringService.selectTask();
@@ -48,6 +63,7 @@
             Engineering engineering = engineerings.get(i);
             OptimizeProject newProject = new OptimizeProject();
             newProject.setProjectNo(engineering.getEngineerId());
+            newProject.setProjectName(engineering.getEngineerName());
             // 灏嗘柊鍒涘缓鐨� OptimizeProject 瀵硅薄娣诲姞鍒� glass 鍒楄〃涓�
             glass.add(newProject);
         }
@@ -59,21 +75,21 @@
     @Override
     public void changeTask(String engineeringId, int state) {
         UpdateWrapper<OptimizeProject> wrapper = new UpdateWrapper<>();
-        wrapper.eq("project_no",engineeringId)
-                .set("state",state);
+        wrapper.eq("project_no", engineeringId)
+                .set("state", state);
         boolean updateSuccess = this.update(wrapper);
-        log.info("宸ョ▼琛ㄦ洿鏂扮姸鎬亄}",updateSuccess);
+        log.info("宸ョ▼琛ㄦ洿鏂扮姸鎬亄}", updateSuccess);
 
     }
 
     @Override
     public boolean overTask(UpPattenUsage sequence, int state) {
-        if(sequence.getState()==100){
-            UpdateWrapper<OptimizeProject> wrapper=new  UpdateWrapper<>();
-            wrapper.eq("project_no",sequence.getEngineeringId())
-                    .set("state",state);
+        if (sequence.getState() == 100) {
+            UpdateWrapper<OptimizeProject> wrapper = new UpdateWrapper<>();
+            wrapper.eq("project_no", sequence.getEngineeringId())
+                    .set("state", state);
             boolean updateSuccess = this.update(wrapper);
-            log.info("宸ョ▼瀹屾垚鏇存柊鐘舵�亄}",updateSuccess);
+            log.info("宸ョ▼瀹屾垚鏇存柊鐘舵�亄}", updateSuccess);
         }
         return false;
     }
@@ -82,9 +98,116 @@
     public List<OptimizeProject> getDoingTask() {
         QueryWrapper<OptimizeProject> wrapper = new QueryWrapper<>();
         wrapper.select("project_no,project_name")
-        .eq("state",200);
+                .eq("state", 200);
         return this.list(wrapper);
     }
 
+    @Override
+    public List<OptimizeProject> queryEngineer() {
+        return this.baseMapper.queryEngineer();
+    }
 
+    @Override
+    public List<OptimizeProject> engineerScheduling(OptimizeProject optimizeProject) {
+        return this.baseMapper.engineerScheduling(optimizeProject);
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public List<OptimizeProject> updateEngineerScheduling(Integer type, List<OptimizeProject> projectList) {
+        // 1. 鍒犻櫎瀵瑰簲绫诲瀷鐨勬暟鎹�
+        baseMapper.deleteByType(type);
+        // 2. 璁剧疆鍊�
+        projectList.forEach(project -> {
+            project.setType(type);
+            project.setState(100);
+            project.setId(null); // 娓呴櫎ID
+        });
+        if (CollectionUtils.isNotEmpty(projectList)) {
+            // 3. 鎵归噺鎻掑叆鏂版暟鎹�
+            baseMapper.batchInsert(projectList);
+        }
+
+        return projectList;
+    }
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    @DS("north_glass_mes")
+    public List<OptimizeProject> updateCuttingLayout(Integer type, List<OptimizeProject> projectList) {
+        //鑾峰彇褰撳墠閽㈠寲鎺掔増淇℃伅
+        List<EngineerScheduling> engineerScheduling = engineerSchedulingService.queryByType(3);
+        List<EngineerScheduling> cutting = new ArrayList<>();
+        if(type==1){
+            cutting = engineerSchedulingService.queryByType(2);
+        }else {
+            cutting = engineerSchedulingService.queryByType(1);
+        }
+        //淇濆瓨鏂板閽㈠寲鎺掔増淇℃伅
+        List<EngineerScheduling> newSchedulingList = new ArrayList<>();
+        Set<String> existingProjectNoSet = engineerScheduling.stream()
+                .map(EngineerScheduling::getProjectNo)
+                .collect(Collectors.toSet());
+        // 鑾峰彇褰撳墠鎺掔増鏂板宸ョ▼
+        for (OptimizeProject project : projectList) {
+            String projectNo = project.getProjectNo();
+            // 宸ョ▼鍙烽潪绌猴紝涓斾笉鍦ㄥ凡鏈夐挗鍖栨帓浜ф暟鎹腑
+            if (projectNo != null && !existingProjectNoSet.contains(projectNo)) {
+                EngineerScheduling newEs = new EngineerScheduling();
+                newEs.setProjectNo(projectNo);
+                newEs.setProjectName(project.getProjectName());
+                newEs.setType(3);
+                newEs.setState(100);
+                newSchedulingList.add(newEs);
+            }
+        }
+        //鑾峰彇褰撳墠鎺掔増鍙栨秷宸ョ▼
+        Set<String> cuttingProjectNos = new HashSet<>();
+        for (EngineerScheduling es : cutting) {
+            if (es.getProjectNo() != null) { // 閬垮厤绌烘寚閽�
+                cuttingProjectNos.add(es.getProjectNo());
+            }
+        }
+        engineerScheduling = engineerScheduling.stream()
+                .filter(es -> es.getProjectNo() == null || !cuttingProjectNos.contains(es.getProjectNo()))
+                .collect(Collectors.toList());
+        //1鍙风嚎閽㈠寲鏁版嵁瀵规瘮1鍙风嚎鍒囧壊鏁版嵁
+        Set<String> projectNoSet2 = new HashSet<>();
+        for (OptimizeProject project : projectList) {
+            String projectNo = project.getProjectNo();
+            if (projectNo != null) { // 閬垮厤绌烘寚閽�
+                projectNoSet2.add(projectNo);
+            }
+        }
+        // 2. 绛涢�夊苟鏀堕泦绗﹀悎鏉′欢鐨勫伐绋嬪彿锛圫tring绫诲瀷锛夊埌 List<String>
+        List<String> missingProjectNos = engineerScheduling.stream()
+                .map(EngineerScheduling::getProjectNo) // 鎻愬彇 engineerScheduling 涓殑宸ョ▼鍙�
+                .filter(esProjectNo -> esProjectNo != null // 鎺掗櫎绌哄伐绋嬪彿
+                        && !projectNoSet2.contains(esProjectNo)) // 鎺掗櫎 projectList 涓瓨鍦ㄧ殑宸ョ▼鍙�
+                .collect(Collectors.toList()); // 鏀堕泦缁撴灉鍒� List<String>
+        for (OptimizeProject project : projectList) {
+            project.setType(type);
+            project.setState(100);
+        }
+        //鏂板閽㈠寲鎺掔増鏁版嵁
+        engineerSchedulingService.saveBatch(newSchedulingList);
+        //鏇存柊宸插彇娑堢殑閽㈠寲鎺掔増鐘舵��
+        if(CollectionUtils.isNotEmpty(missingProjectNos)){
+            engineerSchedulingService.updateState(missingProjectNos);
+        }
+        //鍙栨秷褰撳墠绫诲瀷鐨勫伐绋嬫帓浜т俊鎭�
+        engineerSchedulingService.updateByType(type);
+        //淇濆瓨褰撳墠鏂板垏鍓叉帓鐗堟暟鎹�
+        baseMapper.batchInsert(projectList);
+        return projectList;
+    }
+
+    @Override
+    public void deleteengineerSchedulingByid(String engineerId, List<Integer> types) {
+        baseMapper.deleteByScheduling(engineerId, types);
+    }
+
+    @Override
+    public List<ProgressDTO> selectProgress(String engineerId) {
+        return baseMapper.selectProgress(engineerId);
+    }
 }

--
Gitblit v1.8.0