From 261698358e2b756a61e992bc1651e01b3f45290b Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期四, 23 十月 2025 16:50:27 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/OptimizeProjectServiceImpl.java |   88 +++++++++++++++++++++++++++++++++++---------
 1 files changed, 70 insertions(+), 18 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 202a852..de60a35 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,20 +1,24 @@
 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.baomidou.mybatisplus.core.toolkit.StringUtils;
 import com.github.yulichang.base.MPJBaseServiceImpl;
+import com.mes.engineering.entity.Engineering;
+import com.mes.engineering.service.EngineeringService;
 import com.mes.pp.entity.OptimizeProject;
 import com.mes.pp.entity.request.OptimizeRequest;
 import com.mes.pp.mapper.OptimizeProjectMapper;
 import com.mes.pp.service.OptimizeProjectService;
 import com.mes.uppattenusage.entity.UpPattenUsage;
 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.util.Collections;
+import java.time.LocalDateTime;
 import java.util.List;
 
 /**
@@ -29,39 +33,54 @@
 @DS("pp")
 @Slf4j
 public class OptimizeProjectServiceImpl extends MPJBaseServiceImpl<OptimizeProjectMapper, OptimizeProject> implements OptimizeProjectService {
+    @Autowired
+    private EngineeringService engineeringService;
 
     @Override
     public List<OptimizeProject> listByState(OptimizeRequest optimizeRequest) {
-        //灏嗗弬鏁颁紶鍏ュ埌鏌ヨ绫婚噷,宸ョ▼鍙峰仛闈炵┖鍒ゆ柇妯$硦鏌ヨ
+        //PP琛ㄦ湭寮�濮嬬殑宸ョ▼鍙�
+        // 璁$畻浜屼釜鏈堝墠鐨勬椂闂�
+        LocalDateTime twoMonthAgo = LocalDateTime.now().minusMonths(2);
         LambdaQueryWrapper<OptimizeProject> wrapper = new LambdaQueryWrapper<>();
-        wrapper.eq(OptimizeProject::getState,optimizeRequest.getState())
-                .or(qw -> qw.eq(OptimizeProject::getState, 200))
-                .like(StringUtils.isNotBlank(optimizeRequest.getProjectNo()),OptimizeProject::getProjectNo,optimizeRequest.getProjectNo())
-                //.groupBy(OptimizeProject::getProjectNo)
-        ;
+        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();
+
+
+        for (int i = 0; i < engineerings.size(); i++) {
+            Engineering engineering = engineerings.get(i);
+            OptimizeProject newProject = new OptimizeProject();
+            newProject.setProjectNo(engineering.getEngineerId());
+            newProject.setProjectName(engineering.getEngineerName());
+            // 灏嗘柊鍒涘缓鐨� OptimizeProject 瀵硅薄娣诲姞鍒� glass 鍒楄〃涓�
+            glass.add(newProject);
+        }
         //杩斿洖宸ョ▼淇℃伅
-        return this.list(wrapper);
+        return glass;
     }
 
 
     @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;
     }
@@ -70,9 +89,42 @@
     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
+    public void deleteengineerSchedulingByid(String engineerId, List<Integer> types) {
+        baseMapper.deleteByScheduling(engineerId, types);
+    }
 }

--
Gitblit v1.8.0