From 1b9936ba920d65df09ab8dba79c6252568ee26e4 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 26 三月 2025 12:16:02 +0800
Subject: [PATCH] 任务统计bug

---
 business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java |  872 +++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 807 insertions(+), 65 deletions(-)

diff --git a/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java b/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
index 05a25e8..9f8f43a 100644
--- a/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
+++ b/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
@@ -1,30 +1,75 @@
 package com.ycl.service.impl;
 
+import cn.hutool.core.io.IORuntimeException;
+import cn.hutool.core.util.CharsetUtil;
+import cn.hutool.core.util.ObjectUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.hutool.core.util.ZipUtil;
+import com.alibaba.excel.EasyExcel;
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
+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.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
+import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ycl.common.base.Result;
-import com.ycl.common.enums.business.FileTypeEnum;
+import com.ycl.common.config.SysConfig;
+import com.ycl.common.constant.Constants;
+import com.ycl.common.core.domain.BaseEntity;
+import com.ycl.common.core.domain.entity.SysDictData;
+import com.ycl.common.enums.YesOrNo;
+import com.ycl.common.enums.business.*;
+import com.ycl.common.exception.base.BaseException;
+import com.ycl.common.utils.CopyUtils;
+import com.ycl.common.utils.DateUtils;
 import com.ycl.common.utils.SecurityUtils;
-import com.ycl.domain.entity.File;
-import com.ycl.domain.entity.ProjectInfo;
-import com.ycl.domain.form.DocumentInfoForm;
-import com.ycl.domain.form.ProjectInfoForm;
+import com.ycl.common.utils.StringUtils;
+import com.ycl.common.utils.bean.BeanUtils;
+import com.ycl.common.utils.excel.OutputExcelUtils;
+import com.ycl.common.utils.file.FileUploadUtils;
+import com.ycl.common.utils.file.FileUtils;
+import com.ycl.common.utils.poi.ExcelUtil;
+import com.ycl.constant.ProjectConstant;
+import com.ycl.domain.entity.*;
+import com.ycl.domain.excel.ProjectExcelTemplate;
+import com.ycl.domain.form.*;
+import com.ycl.domain.query.ProjectExportQuery;
 import com.ycl.domain.query.ProjectInfoQuery;
 import com.ycl.domain.vo.*;
 import com.ycl.framework.utils.PageUtil;
-import com.ycl.mapper.FileMapper;
-import com.ycl.mapper.ProjectInfoMapper;
-import com.ycl.service.FileService;
-import com.ycl.service.ProjectInfoService;
+import com.ycl.listener.excel.ProjectImportListener;
+import com.ycl.mapper.*;
+import com.ycl.service.*;
+import com.ycl.system.mapper.SysDeptMapper;
+import com.ycl.system.service.ISysDeptService;
+import com.ycl.system.service.ISysDictDataService;
 import lombok.RequiredArgsConstructor;
-import org.springframework.beans.BeanUtils;
+import org.apache.commons.codec.Charsets;
+import org.springframework.aop.framework.AopContext;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.Assert;
+import org.springframework.util.CollectionUtils;
+import org.springframework.web.multipart.MultipartFile;
 
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.FileInputStream;
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.net.URLEncoder;
+import java.nio.file.Files;
+import java.nio.file.Path;
+import java.nio.file.StandardCopyOption;
+import java.time.Year;
 import java.util.*;
 import java.util.stream.Collectors;
+import java.util.stream.Stream;
 
 /**
  * 椤圭洰绠$悊鍩虹淇℃伅琛� 鏈嶅姟瀹炵幇绫�
@@ -37,8 +82,24 @@
 public class ProjectInfoServiceImpl extends ServiceImpl<ProjectInfoMapper, ProjectInfo> implements ProjectInfoService {
 
     private final ProjectInfoMapper projectInfoMapper;
+    private final ProjectInfoWinUnitService projectInfoWinUnitService;
+    private final ProjectInfoYearPlanService projectInfoYearPlanService;
+    private final ProjectInvestmentFundingMapper investmentFundingMapper;
+    private final ProjectInvestmentInfoMapper investmentInfoMapper;
+    private final ProjectInvestmentPolicyComplianceMapper policyMapper;
+    private final ProjectUnitRegistrationInfoMapper unitRegistrationInfoMapper;
     private final FileService fileService;
     private final FileMapper fileMapper;
+    private final PlanMapper planMapper;
+    private final ProjectInvestmentInfoServiceImpl projectInvestmentInfoServiceImpl;
+    private final ProjectInvestmentFundingServiceImpl projectInvestmentFundingServiceImpl;
+    private final ProjectInvestmentPolicyComplianceServiceImpl projectInvestmentPolicyComplianceServiceImpl;
+    private final ProjectUnitRegistrationInfoServiceImpl projectUnitRegistrationInfoServiceImpl;
+    private final SysDeptMapper sysDeptMapper;
+    private final ISysDictDataService dictDataService;
+    private final ProcessLogService processLogService;
+
+
     /**
      * 娣诲姞
      *
@@ -46,22 +107,79 @@
      * @return
      */
     @Override
-    @Transactional(rollbackFor = Exception.class)
     public Result add(ProjectInfoForm form) {
         //娣诲姞鍩烘湰淇℃伅
         ProjectInfo entity = ProjectInfoForm.getEntityByForm(form, null);
         Long userId = SecurityUtils.getUserId();
         entity.setCreateBy(userId);
         entity.setUpdateBy(userId);
+        //濡傛灉鏄偍澶囬」鐩�(鏈紑宸ラ」鐩�)涓嶉渶瑕佸鏍�
+        if (ProjectConstant.COMMIT.equals(entity.getUsedStatus()) && ProjectStatusEnum.PENDDING.getType().equals(entity.getProjectStatus())) {
+            entity.setUsedStatus(ProjectConstant.PASS);
+        }
+        if(!checkProjectNameAndIdIsUnique(entity,null)){
+            throw new RuntimeException("椤圭洰閲嶅锛岄」鐩悕绉般�侀」鐩爜宸插瓨鍦�");
+        }
         baseMapper.insert(entity);
-        //娣诲姞鏂囦欢
-        List<File> fileList = form.getFileList();
-        fileList.forEach(item->{
-            item.setBusId(entity.getId());
-            item.setType(FileTypeEnum.PROJECT_INFO);
-        });
-        fileService.saveBatch(fileList);
+        addPlan(entity.getId()); //娣诲姞璁″垝琛�
+        //娣诲姞椤圭洰涓爣鍗曚綅
+        List<ProjectInfoWinUnit> projectInfoWinUnits = new ArrayList<>();
+        for (ProjectInfoWinUnitForm winUnitForm : form.getWinUnitList()) {
+            ProjectInfoWinUnit projectInfoWinUnit = ProjectInfoWinUnitForm.getEntityByForm(winUnitForm, null);
+            projectInfoWinUnit.setId(null);
+            projectInfoWinUnit.setProjectInfoId(entity.getId());
+            projectInfoWinUnits.add(projectInfoWinUnit);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoWinUnits)) {
+            projectInfoWinUnitService.saveBatch(projectInfoWinUnits);
+        }
+        //娣诲姞骞村害鎶曡祫璁″垝
+        List<ProjectInfoYearPlan> projectInfoYearPlans = new ArrayList<>();
+        for (ProjectInfoYearPlanForm yearPlanForm : form.getYearPlanList()) {
+            ProjectInfoYearPlan yearPlan = ProjectInfoYearPlanForm.getEntityByForm(yearPlanForm, null);
+            yearPlan.setId(null);
+            yearPlan.setProjectInfoId(entity.getId());
+            projectInfoYearPlans.add(yearPlan);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoYearPlans)) {
+            projectInfoYearPlanService.saveBatch(projectInfoYearPlans);
+        }
         return Result.ok("娣诲姞鎴愬姛").data(entity.getId());
+    }
+
+    /**
+     * 鍒ゆ柇椤圭洰鍚嶅拰椤圭洰鐮佹槸鍚﹀敮涓�
+     * @param entity from true 鏉ヨ嚜add() false 鏉ヨ嚜edit()
+     * @return
+     */
+    public boolean  checkProjectNameAndIdIsUnique(ProjectInfo entity,Long updateId){
+        LambdaQueryWrapper<ProjectInfo> queryWrapper = new LambdaQueryWrapper<>();
+        if (updateId == null) {
+            List<ProjectInfo> list = new LambdaQueryChainWrapper<>(baseMapper)
+                    .eq(ProjectInfo::getProjectName, entity.getProjectName())
+                    .eq(ProjectInfo::getProjectCode, entity.getProjectCode())
+                    .list();
+            return list == null || list.isEmpty();
+        } else {
+            List<ProjectInfo> list = new LambdaQueryChainWrapper<>(baseMapper)
+                    .eq(ProjectInfo::getProjectName, entity.getProjectName())
+                    .eq(ProjectInfo::getProjectCode, entity.getProjectCode())
+                    .ne(ProjectInfo::getId, updateId)
+                    .list();
+            return list == null || list.isEmpty();
+        }
+
+    }
+
+    public void addPlan(Long projectInfoId) {
+        Plan plan = new Plan();
+        plan.setProjectInfoId(projectInfoId);
+        plan.setReportStatus(1);
+        plan.setMonthStatus(1);
+        plan.setSeasonStatus(1);
+        plan.setYearStatus(1);
+        plan.setDeleted(0);
+        planMapper.insert(plan);
     }
 
     /**
@@ -71,29 +189,87 @@
      * @return
      */
     @Override
-    @Transactional(rollbackFor = Exception.class)
     public Result update(ProjectInfoForm form) {
         ProjectInfo entity = baseMapper.selectById(form.getId());
+
         // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
         Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
-        ProjectInfoForm.getEntityByForm(form,entity);
+        ProjectInfoForm.getEntityByForm(form, entity);
         Long userId = SecurityUtils.getUserId();
         entity.setUpdateBy(userId);
+        //濡傛灉鏄偍澶囬」鐩�(鏈紑宸ラ」鐩�)涓嶉渶瑕佸鏍�
+        if (ProjectConstant.COMMIT.equals(entity.getUsedStatus()) && ProjectStatusEnum.PENDDING.getType().equals(entity.getProjectStatus())) {
+            entity.setUsedStatus(ProjectConstant.PASS);
+        }
+        // 绠$悊鍛樹慨鏀圭殑鐩存帴閫氳繃
+        if (SecurityUtils.isAdmin(SecurityUtils.getUserId())) {
+            entity.setUsedStatus(ProjectConstant.PASS);
+        }
+        if(!checkProjectNameAndIdIsUnique(entity,form.getId())){
+            throw new RuntimeException("椤圭洰閲嶅锛岄」鐩悕绉般�侀」鐩爜宸插瓨鍦�");
+        }
         //鏇存柊椤圭洰淇℃伅
         baseMapper.updateById(entity);
-        List<File> fileList = form.getFileList();
-        fileList.forEach(item->{
-            item.setBusId(entity.getId());
-            item.setType(FileTypeEnum.PROJECT_INFO);
-        });
-        //鍒犻櫎鍘熸湁鏂囦欢
-        QueryWrapper<File> fileQueryWrapper = new QueryWrapper<>();
-        fileQueryWrapper.eq("type",FileTypeEnum.PROJECT_INFO.getType());
-        fileQueryWrapper.eq("bus_id",entity.getId());
-        fileMapper.delete(fileQueryWrapper);
-        //鏇挎崲鎴愮幇鏈�
-        fileService.saveBatch(fileList);
+        //淇敼椤圭洰涓爣鍗曚綅
+        //鍒犻櫎鍘熸暟鎹�
+        new LambdaUpdateChainWrapper<>(projectInfoWinUnitService.getBaseMapper())
+                .eq(ProjectInfoWinUnit::getProjectInfoId, entity.getId())
+                .remove();
+        //娣诲姞椤圭洰涓爣鍗曚綅
+        List<ProjectInfoWinUnit> projectInfoWinUnits = new ArrayList<>();
+        for (ProjectInfoWinUnitForm winUnitForm : form.getWinUnitList()) {
+            ProjectInfoWinUnit projectInfoWinUnit = ProjectInfoWinUnitForm.getEntityByForm(winUnitForm, null);
+            projectInfoWinUnit.setId(null);
+            projectInfoWinUnit.setProjectInfoId(entity.getId());
+            projectInfoWinUnits.add(projectInfoWinUnit);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoWinUnits)) {
+            projectInfoWinUnitService.saveBatch(projectInfoWinUnits);
+        }
+
+        //淇敼骞村害鎶曡祫璁″垝
+        //鍒犻櫎鍘熸暟鎹�
+        new LambdaUpdateChainWrapper<>(projectInfoYearPlanService.getBaseMapper())
+                .eq(ProjectInfoYearPlan::getProjectInfoId, entity.getId())
+                .remove();
+        //娣诲姞骞村害鎶曡祫璁″垝
+        List<ProjectInfoYearPlan> projectInfoYearPlans = new ArrayList<>();
+        for (ProjectInfoYearPlanForm yearPlanForm : form.getYearPlanList()) {
+            ProjectInfoYearPlan yearPlan = ProjectInfoYearPlanForm.getEntityByForm(yearPlanForm, null);
+            yearPlan.setId(null);
+            yearPlan.setProjectInfoId(entity.getId());
+            projectInfoYearPlans.add(yearPlan);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoYearPlans)) {
+            projectInfoYearPlanService.saveBatch(projectInfoYearPlans);
+        }
         return Result.ok("淇敼鎴愬姛");
+    }
+
+    private void saveUnit(Long id, List<ProjectInfoWinUnitForm> projectInfoWinUnitForm) {
+        List<ProjectInfoWinUnit> projectInfoWinUnits = new ArrayList<>();
+        for (ProjectInfoWinUnitForm winUnitForm : projectInfoWinUnitForm) {
+            ProjectInfoWinUnit projectInfoWinUnit = ProjectInfoWinUnitForm.getEntityByForm(winUnitForm, null);
+            projectInfoWinUnit.setId(null);
+            projectInfoWinUnit.setProjectInfoId(id);
+            projectInfoWinUnits.add(projectInfoWinUnit);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoWinUnits)) {
+            projectInfoWinUnitService.saveBatch(projectInfoWinUnits);
+        }
+    }
+
+    private void saveYearPlan(Long id, List<ProjectInfoYearPlanForm> yearPlanList) {
+        List<ProjectInfoYearPlan> projectInfoYearPlans = new ArrayList<>();
+        for (ProjectInfoYearPlanForm yearPlanForm : yearPlanList) {
+            ProjectInfoYearPlan yearPlan = ProjectInfoYearPlanForm.getEntityByForm(yearPlanForm, null);
+            yearPlan.setId(null);
+            yearPlan.setProjectInfoId(id);
+            projectInfoYearPlans.add(yearPlan);
+        }
+        if (!CollectionUtils.isEmpty(projectInfoYearPlans)) {
+            projectInfoYearPlanService.saveBatch(projectInfoYearPlans);
+        }
     }
 
     /**
@@ -103,7 +279,6 @@
      * @return
      */
     @Override
-    //TODO:寰呭畬鍠�
     public Result remove(List<String> ids) {
         baseMapper.deleteBatchIds(ids);
         return Result.ok("鍒犻櫎鎴愬姛");
@@ -116,31 +291,107 @@
      * @return
      */
     @Override
-    //TODO:寰呭畬鍠�
-    public Result removeById(String id) {
+    @Transactional(rollbackFor = Exception.class)
+    public Result removeById(Long id) {
+        investmentFundingMapper.delete(new QueryWrapper<ProjectInvestmentFunding>().eq("project_id", id));
+        investmentInfoMapper.delete(new QueryWrapper<ProjectInvestmentInfo>().eq("project_id", id));
+        policyMapper.delete(new QueryWrapper<ProjectInvestmentPolicyCompliance>().eq("project_id", id));
+        unitRegistrationInfoMapper.delete(new QueryWrapper<ProjectUnitRegistrationInfo>().eq("project_id", id));
+        projectInfoWinUnitService.remove(new QueryWrapper<ProjectInfoWinUnit>().eq("project_info_id", id));
+        projectInfoYearPlanService.remove(new QueryWrapper<ProjectInfoYearPlan>().eq("project_info_id", id));
+
+        List<String> types = new ArrayList<>();
+        types.add(FileTypeEnum.PROJECT_INFO.getType());
+        types.add(FileTypeEnum.INVEST_POLICY.getType());
+        types.add(FileTypeEnum.DOCUMENT_INFO.getType());
+        fileMapper.delete(new QueryWrapper<File>().eq("bus_id", id).in("type", types));
         baseMapper.deleteById(id);
         return Result.ok("鍒犻櫎鎴愬姛");
     }
 
     /**
-     * 鍒嗛〉鏌ヨ
+     * 鍒嗛〉鏌ヨ锛孴ODO 椤圭洰涓績鐨勫垎椤典娇鐢ㄥ崟鐙殑鎺ュ彛锛屽幓鎺夊啓姝荤殑閫昏緫鎹㈡垚dept or鏌ヨ
      *
      * @param query
      * @return
      */
     @Override
     public Result page(ProjectInfoQuery query) {
-        IPage<ProjectInfo> page = PageUtil.getPage(query, ProjectInfo.class);
-        baseMapper.getPage(page, query);
-        List<ProjectInfo> records = page.getRecords();
-        List<ProjectInfoVO> list = records.stream()
-                .map(entity -> {
-                    ProjectInfoVO vo = ProjectInfoVO.getVoByEntity(entity, null);
-                    vo.setProjectColorCode("green");
-                    return vo;
-                })
-                .collect(Collectors.toList());
+        if (query.getProjectStartTime() != null) {
+            query.setProjectStartTime(DateUtils.getDayStart(query.getProjectStartTime()));
+        }
+        if (query.getProjectEndTime() != null) {
+            query.setProjectEndTime(DateUtils.getDayEnd(query.getProjectEndTime()));
+        }
+        if (YesOrNo.YES.getCode().equals(query.getCenter())) {
+            query.setProjectPhase("6");
+        }
+        // 寮傚父椤圭洰鏆傛椂杩斿洖绌�
+        if (YesOrNo.YES.getCode().equals(query.getExe())) {
+            return Result.ok().data(new ArrayList<>()).total(0);
+        }
+        Long userId = SecurityUtils.getUserId();
+        String ancestors = sysDeptMapper.selectAncestors(userId);
+        String[] ancestorArr = ancestors.split(",");
+        List<String> ancestorList = Arrays.stream(ancestorArr).collect(Collectors.toList());
+        ancestorList.add(SecurityUtils.getDeptId() + "");
+        if (!CollectionUtils.isEmpty(ancestorList) && ancestorList.contains("101")) {
+            query.setProjectOwnerUnit(SecurityUtils.getDeptId());
+            //涓氫富
+            query.setRole(0);
+        } else if ((!CollectionUtils.isEmpty(ancestorList) && ancestorList.contains("102"))) {
+            query.setCompetentDepartment(SecurityUtils.getDeptId());
+            //瀹℃壒 瀵瑰簲涓荤閮ㄩ棬
+            query.setRole(1);
+        } else if (SecurityUtils.isAdmin(userId)) {
+            query.setRole(3);
+        }
+
+        IPage<ProjectInfoVO> page = PageUtil.getPage(query, ProjectInfoVO.class);
+        baseMapper.getPage(query, page);
+        List<ProjectInfoVO> records = page.getRecords();
+        List<ProjectVO> list = new ArrayList<>();
+        int year = Year.now().getValue();
+        records.forEach(vo -> {
+            ProjectInfoVO.transform(vo);
+            ProjectVO projectVO = new ProjectVO();
+            copyToProjectVO(vo, projectVO);
+            String competentDepartment = vo.getCompetentDepartment();
+            projectVO.setAuditRole(SecurityUtils.isAdmin(SecurityUtils.getUserId()) || (StringUtils.isNotEmpty(competentDepartment) && competentDepartment.equals(SecurityUtils.getDeptId() + "")));
+            // 缈昏瘧椤圭洰闃舵
+            String phase = ProjectCategoryEnum.getPhaseByProjectStatus(projectVO.getProjectPhase());
+            projectVO.setProjectPhase(phase);
+            if (StringUtils.isNotEmpty(projectVO.getProjectSubType())) {
+                // 缈昏瘧椤圭洰瀛愮被鍨�
+                SysDictData dictData = dictDataService.selectDictDataByValue(projectVO.getProjectType(), projectVO.getProjectSubType(), "sys_project_type");
+                if (Objects.nonNull(dictData)) {
+                    projectVO.setProjectSubType(dictData.getDictLabel());
+                }
+            }
+            // 鑾峰彇鏈勾搴︾殑鎶曡祫閲戦
+            List<ProjectInfoYearPlan> yearPlans = new LambdaQueryChainWrapper<>(projectInfoYearPlanService.getBaseMapper())
+                    .eq(ProjectInfoYearPlan::getProjectInfoId, projectVO.getId())
+                    .eq(ProjectInfoYearPlan::getYear, year)
+                    .list();
+            if (! CollectionUtils.isEmpty(yearPlans)) {
+                projectVO.setYearInvestAmount(yearPlans.get(0).getYearTotalMoney());
+            }
+            list.add(projectVO);
+        });
         return Result.ok().data(list).total(page.getTotal());
+    }
+
+    private void copyToProjectVO(ProjectInfoVO vo, ProjectVO projectVO) {
+        //蹇界暐null鍊肩殑澶嶅埗
+        CopyUtils.copyNoNullProperties(vo, projectVO);
+        if (vo.getProjectInvestmentInfo() != null)
+            CopyUtils.copyNoNullProperties(vo.getProjectInvestmentInfo(), projectVO);
+        if (vo.getProjectUnitRegistrationInfo() != null)
+            CopyUtils.copyNoNullProperties(vo.getProjectUnitRegistrationInfo(), projectVO);
+        if (vo.getProjectInvestmentPolicyCompliance() != null)
+            CopyUtils.copyNoNullProperties(vo.getProjectInvestmentPolicyCompliance(), projectVO);
+        if (vo.getProjectInvestmentFunding() != null)
+            CopyUtils.copyNoNullProperties(vo.getProjectInvestmentFunding(), projectVO);
     }
 
     /**
@@ -154,11 +405,30 @@
         ProjectInfo entity = baseMapper.getById(id);
         Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
         ProjectInfoVO vo = ProjectInfoVO.getVoByEntity(entity, null);
+        String competentDepartment = vo.getCompetentDepartment();
+        vo.setAuditRole(SecurityUtils.isAdmin(SecurityUtils.getUserId()) || (StringUtils.isNotEmpty(competentDepartment) && competentDepartment.equals(SecurityUtils.getDeptId() + "")));
         QueryWrapper<File> fileQueryWrapper = new QueryWrapper<>();
-        fileQueryWrapper.eq("type",FileTypeEnum.PROJECT_INFO.getType());
-        fileQueryWrapper.eq("bus_id",vo.getId());
-        List<File> files = fileMapper.selectList(fileQueryWrapper);
-        vo.setFileList(files);
+        fileQueryWrapper.eq("type", FileTypeEnum.PROJECT_INFO.getType());
+        fileQueryWrapper.eq("bus_id", vo.getId());
+
+        //涓爣鍗曚綅
+        List<ProjectInfoWinUnitVO> unitVOS = new ArrayList<>();
+        List<ProjectInfoWinUnit> unitList = projectInfoWinUnitService.list(new QueryWrapper<ProjectInfoWinUnit>().eq("project_info_id", id));
+        for (ProjectInfoWinUnit projectInfoWinUnit : unitList) {
+            ProjectInfoWinUnitVO unitVO = ProjectInfoWinUnitVO.getVoByEntity(projectInfoWinUnit, null);
+            unitVO.setId(null);
+            unitVOS.add(unitVO);
+        }
+        vo.setWinUnitList(unitVOS);
+        //骞村害鎶曡祫璁″垝
+        List<ProjectInfoYearPlanVO> yearPlanVOS = new ArrayList<>();
+        List<ProjectInfoYearPlan> yearPlaList = projectInfoYearPlanService.list(new QueryWrapper<ProjectInfoYearPlan>().eq("project_info_id", id));
+        for (ProjectInfoYearPlan yearPlan : yearPlaList) {
+            ProjectInfoYearPlanVO yearPlanVO = ProjectInfoYearPlanVO.getVoByEntity(yearPlan, null);
+            yearPlanVO.setId(null);
+            yearPlanVOS.add(yearPlanVO);
+        }
+        vo.setYearPlanList(yearPlanVOS);
         return Result.ok().data(vo);
     }
 
@@ -186,19 +456,88 @@
         // {"type":"鐪侀噸鐐归」鐩�","count":0,"amount":"0.00","text":"鐪�"}]}}
         IndexCountVO indexCountVO = new IndexCountVO();
         List<IndexProPhaseCountVO> proPhaseCountVO = new ArrayList<>();
-        proPhaseCountVO.add(new IndexProPhaseCountVO("鍌ㄥ瑙勫垝闃舵", 0, "0.00", "鍌�"));
-        proPhaseCountVO.add(new IndexProPhaseCountVO("椤圭洰鍓嶆湡闃舵", 0, "0.00", "鏂�"));
-        proPhaseCountVO.add(new IndexProPhaseCountVO("瀹炴柦闃舵", 0, "0.00", "寤�"));
-        proPhaseCountVO.add(new IndexProPhaseCountVO("绔e伐鎶曠敤闃舵", 0, "0.00", "绔�"));
-        List<IndexImpTypeCountVO> impTypeCountVO = new ArrayList<>();
-        impTypeCountVO.add(new IndexImpTypeCountVO("涓�鑸」鐩�", 0, "0.00", "鏅�"));
-        impTypeCountVO.add(new IndexImpTypeCountVO("鍘块噸鐐归」鐩�", 0, "0.00", "鍘�"));
-        impTypeCountVO.add(new IndexImpTypeCountVO("甯傞噸鐐归」鐩�", 0, "0.00", "甯�"));
-        impTypeCountVO.add(new IndexImpTypeCountVO("鐪侀噸鐐归」鐩�", 0, "0.00", "鐪�"));
-        indexCountVO.setImpTypeCountVO(impTypeCountVO);
+        List<ProjectVO> projectVOS = baseMapper.homeCount(new BaseEntity());
+        List<ProjectVO> reserve = new ArrayList<>();
+        List<ProjectVO> previous = new ArrayList<>();
+        List<ProjectVO> implement = new ArrayList<>();
+        List<ProjectVO> finish = new ArrayList<>();
+        List<ProjectVO> normal = new ArrayList<>();
+        List<ProjectVO> province = new ArrayList<>();
+        List<ProjectVO> city = new ArrayList<>();
+        List<ProjectVO> county = new ArrayList<>();
+        projectVOS.forEach(item -> {
+            if (ProjectCategoryEnum.RESERVE.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectPhase()))) {
+                reserve.add(item);
+            } else if (ProjectCategoryEnum.PREVIOUS.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectPhase()))) {
+                previous.add(item);
+            } else if (ProjectCategoryEnum.IMPLEMENT.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectPhase()))) {
+                implement.add(item);
+            } else if (ProjectCategoryEnum.FINISH.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectPhase()))) {
+                finish.add(item);
+            }
+
+            if (StringUtils.isBlank(item.getImportanceType())) {
+                normal.add(item);
+                // 浣跨敤contains锛屽洜涓洪噸鐐瑰垎绫诲彲澶氶�夛紝浣跨敤,鍒嗗壊瀛樺偍鐨�
+            } else {
+                if (item.getImportanceType().contains(ImportanceTypeEnum.PROVINCIAL_KEY.getType())) {
+                    province.add(item);
+                }
+                if (item.getImportanceType().contains(ImportanceTypeEnum.SUINING_KEY.getType())) {
+                    city.add(item);
+                }
+                if (item.getImportanceType().contains(ImportanceTypeEnum.SHEHONG_KEY.getType())) {
+                    county.add(item);
+                }
+                if (item.getImportanceType().contains(ImportanceTypeEnum.NORMAL.getType())) {
+                    normal.add(item);
+                }
+            }
+        });
+        //鍗曚綅鍏堥粯璁や负鍏�
+        proPhaseCountVO.add(new IndexProPhaseCountVO("鍌ㄥ瑙勫垝闃舵", reserve.size(), reserve.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "鍌�"));
+
+        proPhaseCountVO.add(new IndexProPhaseCountVO("椤圭洰鍓嶆湡闃舵", previous.size(), previous.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "鏂�"));
+
+        proPhaseCountVO.add(new IndexProPhaseCountVO("瀹炴柦闃舵", implement.size(), implement.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "寤�"));
+
+        proPhaseCountVO.add(new IndexProPhaseCountVO("绔e伐鎶曠敤闃舵", finish.size(), finish.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "绔�"));
+
         indexCountVO.setProPhaseCountVO(proPhaseCountVO);
 
+        List<IndexImpTypeCountVO> impTypeCountVO = new ArrayList<>();
+        impTypeCountVO.add(new IndexImpTypeCountVO("涓�鑸」鐩�", normal.size(), normal.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "鏅�"));
 
+        impTypeCountVO.add(new IndexImpTypeCountVO("鍘块噸鐐归」鐩�", county.size(), county.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "鍘�"));
+
+        impTypeCountVO.add(new IndexImpTypeCountVO("甯傞噸鐐归」鐩�", city.size(), city.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "甯�"));
+
+        impTypeCountVO.add(new IndexImpTypeCountVO("鐪侀噸鐐归」鐩�", province.size(), province.stream().
+                filter(item -> !StringUtils.isEmpty(item.getTotalInvestment()))
+                .map(item -> new BigDecimal(item.getTotalInvestment()).setScale(2, RoundingMode.HALF_UP))
+                .reduce(BigDecimal.ZERO, BigDecimal::add).divide(new BigDecimal("10000"), 2, RoundingMode.HALF_UP).toString(), "鐪�"));
+        indexCountVO.setImpTypeCountVO(impTypeCountVO);
         return indexCountVO;
     }
 
@@ -206,6 +545,12 @@
     public Map<String, Integer> countExceptionProject(IndexDTO indexDTO) {
         Map<String, Integer> map = new HashMap<>();
         map.put("processExceptionProject", 0);
+        // 鏌ヨ鍙戠敓杩囧缂虹殑椤圭洰鏁�
+        List<String> projectIds = new LambdaQueryChainWrapper<>(processLogService.getBaseMapper())
+                .select(ProcessLog::getProjectId)
+                .eq(ProcessLog::getEventType, ProcessLogEventTypeEnum.WAIT)
+                .list().stream().map(ProcessLog::getProjectId).distinct().collect(Collectors.toList());
+        map.put("hasWaitProjectNum", projectIds.size());
         return map;
     }
 
@@ -213,8 +558,8 @@
     public Result docDetail(Integer id) {
         DocumentInfoForm documentInfoForm = new DocumentInfoForm();
         QueryWrapper<File> fileQueryWrapper = new QueryWrapper<>();
-        fileQueryWrapper.eq("type",FileTypeEnum.DOCUMENT_INFO.getType());
-        fileQueryWrapper.eq("bus_id",id);
+        fileQueryWrapper.eq("type", FileTypeEnum.DOCUMENT_INFO.getType());
+        fileQueryWrapper.eq("bus_id", id);
         List<File> files = fileMapper.selectList(fileQueryWrapper);
         documentInfoForm.setFileList(files);
         return Result.ok().data(documentInfoForm);
@@ -223,14 +568,15 @@
     @Override
     public Result addDoc(DocumentInfoForm form) {
         List<File> fileList = form.getFileList();
-        fileList.forEach(item->{
+        fileList.forEach(item -> {
+            item.setId(null);
             item.setBusId(form.getProjectId());
             item.setType(FileTypeEnum.DOCUMENT_INFO);
         });
         //鍒犻櫎鍘熸湁鏂囦欢
         QueryWrapper<File> fileQueryWrapper = new QueryWrapper<>();
-        fileQueryWrapper.eq("type",FileTypeEnum.DOCUMENT_INFO.getType());
-        fileQueryWrapper.eq("bus_id",form.getProjectId());
+        fileQueryWrapper.eq("type", FileTypeEnum.DOCUMENT_INFO.getType());
+        fileQueryWrapper.eq("bus_id", form.getProjectId());
         fileMapper.delete(fileQueryWrapper);
         //鏇挎崲鎴愮幇鏈�
         fileService.saveBatch(fileList);
@@ -242,6 +588,9 @@
         ProjectInfo projectInfo = baseMapper.selectById(recordId);
         // 鍒ゆ柇褰撳墠鐢ㄦ埛id鏄惁鍦ㄤ富绠″垪琛ㄤ腑
         String competentDepartment = projectInfo.getCompetentDepartment();
+        if (StringUtils.isEmpty(competentDepartment)) {
+            return Result.ok().data(false);
+        }
         List<String> list = Arrays.asList(competentDepartment.split(","));
         // 鑾峰緱褰撳墠鐢ㄦ埛id
         Long userId = SecurityUtils.getUserId();
@@ -251,4 +600,397 @@
             return Result.ok().data(false);
         }
     }
+
+    @Override
+    public void export(HttpServletResponse response, ProjectExportQuery query) throws IOException {
+        List<ProjectVO> data = baseMapper.selectProjectDetailByIds(query.getDataIdList());
+        List<ProjectExcelTemplate> excelList = new ArrayList<>();
+        //瀛楀吀浣滅炕璇�
+        data.forEach(item -> {
+            ProjectExcelTemplate excel = new ProjectExcelTemplate();
+            BeanUtils.copyProperties(item, excel);
+            //椤圭洰闃舵
+            excel.setProjectPhase(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectPhase()));
+            excelList.add(excel);
+        });
+        Set<Integer> indexes = OutputExcelUtils.getSelectFields(query.getFieldList(), ProjectExcelTemplate.class);
+        //涓嶉渶瑕侀檮浠�
+        if (!query.getRequireFile()) {
+            try (ServletOutputStream outputStream = response.getOutputStream()) {
+                EasyExcel.write(outputStream, ProjectExcelTemplate.class).includeColumnIndexes(indexes).sheet("椤圭洰鍒楄〃").doWrite(excelList);
+            } catch (Exception e) {
+                log.error(e.getMessage(), e);
+                throw new BaseException("瀵煎嚭澶辫触锛�" + e.getMessage());
+            }
+        } else {
+            //闇�瑕侀檮浠�,瀵煎嚭涓簔ip
+            response.setContentType("application/zip");
+            response.setCharacterEncoding(Charsets.UTF_8.name());
+            String fileName = URLEncoder.encode("椤圭洰鍒楄〃", Charsets.UTF_8);
+            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".zip");
+
+            java.io.File tempDir = null;
+            try {
+                //鏌ュ嚭闄勪欢
+                List<File> projectInfoFiles = fileMapper.selectList(new QueryWrapper<File>()
+                        .in("bus_id", data.stream().map(ProjectVO::getId).collect(Collectors.toList()))
+                        .and(q -> q.eq("type", FileTypeEnum.PROJECT_INFO.getType()).or().eq("type", FileTypeEnum.DOCUMENT_INFO.getType()))
+                );
+                List<File> policyFiles = fileMapper.selectList(new QueryWrapper<File>()
+                        .in("bus_id", data.stream().map(ProjectVO::getPolicyId).collect(Collectors.toList()))
+                        .eq("type", FileTypeEnum.INVEST_POLICY.getType())
+                );
+                projectInfoFiles.addAll(policyFiles);
+                projectInfoFiles.forEach(file -> {
+                    data.forEach(item -> {
+                        if (FileTypeEnum.PROJECT_INFO.equals(file.getType())) {
+                            if (file.getBusId().equals(item.getId())) {
+                                //瀹℃壒璁″垝涔�
+                                item.setApprovalPlan(file.getOriginalName());
+                            }
+                        } else if (FileTypeEnum.DOCUMENT_INFO.equals(file.getType())) {
+                            if (file.getBusId().equals(item.getId())) {
+                                //鐩稿叧鏂囦功
+                                item.setDocuments(file.getOriginalName());
+                            }
+                        } else if (FileTypeEnum.INVEST_POLICY.equals(file.getType())) {
+                            if (file.getBusId().equals(item.getPolicyId())) {
+                                //绗﹀悎浜т笟鏀跨瓥闄勪欢
+                                item.setPolicyComplianceAttachment(file.getOriginalName());
+                            }
+                        }
+                    });
+
+                });
+                // 鍒涘缓涓存椂鐩綍
+                tempDir = Files.createTempDirectory("temp").toFile();
+
+                java.io.File templateDir = new java.io.File(tempDir, "template");
+                if (!templateDir.exists()) {
+                    templateDir.mkdirs();
+                }
+
+                // 鍒涘缓 Excel 鏂囦欢
+                java.io.File excelFile = new java.io.File(templateDir, "excel.xlsx");
+                if (!excelFile.exists()) {
+                    excelFile.createNewFile();
+                }
+
+                // 鍐欏叆 Excel 妯℃澘鏁版嵁
+                try (FileOutputStream fileOutputStream = new FileOutputStream(excelFile, false)) {
+                    EasyExcel.write(fileOutputStream, ProjectExcelTemplate.class).sheet("椤圭洰鍒楄〃").doWrite(excelList);
+                }
+
+                // 鍒涘缓闄勪欢鐩綍
+                java.io.File attachmentDir = new java.io.File(templateDir, "attachment");
+                if (!attachmentDir.exists()) {
+                    attachmentDir.mkdirs();
+                }
+
+                //灏嗛檮浠跺鍒跺鐩綍涓�
+                for (File item : projectInfoFiles) {
+                    String url = item.getUrl();
+                    if (StringUtils.isBlank(url)) continue;
+                    url = url.replaceFirst(Constants.RESOURCE_PREFIX, SysConfig.getProfile());
+                    // 鐩存帴浣跨敤File绫诲鐞嗙郴缁熻矾寰�
+                    java.io.File sourceFile = new java.io.File(url);
+                    if (!sourceFile.exists() || !sourceFile.isFile()) {
+                        // 澶勭悊鏂囦欢涓嶅瓨鍦ㄦ垨涓嶆槸鏂囦欢鐨勬儏鍐�
+                        continue; // 鎴栬�呰褰曟棩蹇椼�佹姏鍑哄紓甯哥瓑
+                    }
+                    // 鐩爣鏂囦欢璺緞锛屼娇鐢╝ttachmentDir浣滀负鐖剁洰褰曪紝骞朵繚鎸佸師鏂囦欢鍚�
+                    java.io.File targetFile = new java.io.File(attachmentDir, sourceFile.getName());
+                    // 澶嶅埗鏂囦欢
+                    try {
+                        Files.copy(sourceFile.toPath(), targetFile.toPath(), StandardCopyOption.REPLACE_EXISTING);
+                    } catch (IOException e) {
+                        log.error(e.getMessage());
+                    }
+                }
+                // 鎵撳寘 ZIP 鏂囦欢
+                java.io.File zipFile = ZipUtil.zip(templateDir);
+                byte[] zipBytes = Files.readAllBytes(zipFile.toPath());
+
+                // 灏� ZIP 鏂囦欢鍐欏叆鍝嶅簲
+                try (ServletOutputStream outputStream = response.getOutputStream()) {
+                    outputStream.write(zipBytes);
+                }
+            } finally {
+                OutputExcelUtils.deleteDirectoryOrFile(tempDir);
+            }
+        }
+    }
+
+    @Override
+    public Result updateUsedStatus(Integer id, Integer usedStatus) {
+        ProjectInfo entity = baseMapper.selectById(id);
+        // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
+        Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+        entity.setUsedStatus(usedStatus);
+        baseMapper.updateById(entity);
+        return Result.ok("鍒犻櫎鎴愬姛");
+    }
+
+    @Transactional
+    @Override
+    public void importProject(MultipartFile file) {
+        java.io.File tempZip = null;
+        java.io.File tempDir = null;
+        try {
+            tempZip = java.io.File.createTempFile("temp", ".zip");
+            try (InputStream inputStream = file.getInputStream()) {
+                Files.copy(inputStream, tempZip.toPath(), StandardCopyOption.REPLACE_EXISTING);
+            }
+
+            tempDir = Files.createTempDirectory("temp-dir").toFile();
+
+            try {
+                ZipUtil.unzip(tempZip, tempDir, CharsetUtil.CHARSET_UTF_8);
+            } catch (IORuntimeException e) {
+                log.error("瑙e帇澶辫触锛屽皾璇曚娇鐢℅BK缂栫爜瑙e帇...");
+                ZipUtil.unzip(tempZip, tempDir, CharsetUtil.CHARSET_GBK);
+            }
+
+            Path path = tempDir.toPath();
+            ProjectImportListener projectImportListener = new ProjectImportListener();
+            //闇�瑕佸瓨鍏ユ暟鎹簱
+            ArrayList<File> attachments = new ArrayList<>();
+            //瀹為檯鐨勬枃浠�
+            List<java.io.File> files = new ArrayList<>();
+            try (Stream<Path> pathStream = Files.walk(path)) {
+                pathStream.forEach(filePath -> {
+                    if (Files.isDirectory(filePath) && filePath.getFileName().toString().equals("attachment")) {
+                        //闄勪欢澶勭悊
+                        try (Stream<Path> stream = Files.walk(filePath)) {
+                            stream.forEach(attachmentPath -> {
+                                if (Files.isRegularFile(attachmentPath)) {
+                                    files.add(attachmentPath.toFile());
+                                }
+                            });
+                        } catch (IOException e) {
+                            log.error(e.getMessage());
+                            throw new RuntimeException(e);
+                        }
+                    } else if (Files.isRegularFile(filePath) && filePath.getFileName().toString().equals("excel.xlsx")) {
+                        //瀵煎叆鏁版嵁澶勭悊
+                        try (FileInputStream fileInputStream = new FileInputStream(filePath.toFile())) {
+                            ExcelUtil.importExcel(fileInputStream, ProjectExcelTemplate.class, projectImportListener);
+                        } catch (IOException e) {
+                            log.error(e.getMessage());
+                            throw new RuntimeException(e);
+                        }
+                    }
+                });
+            }
+            /* 鎶婇檮浠跺瓨鍏ヤ笂浼犺矾寰� */
+            //涓婁紶鏂囦欢璺緞
+            String filePath = SysConfig.getUploadPath();
+            files.forEach(attachmentFile -> {
+                try {
+                    //涓婁紶
+                    String url = FileUploadUtils.uploadIOFile(filePath, attachmentFile);
+                    //瀛樻斁鐨勬枃浠跺悕浼氬姞涓奯鏃堕棿鎴崇殑鍚庣紑
+                    String newName = FileUtils.getName(url);
+                    attachments.add(new File()
+                            .setUrl(url)
+                            .setName(newName)
+                            .setOriginalName(attachmentFile.getName()));
+                } catch (IOException e) {
+                    e.printStackTrace();
+                }
+            });
+
+            Map<String, Long> projectInfoMap = projectImportListener.getProjectInfoMap();
+            Map<String, Long> investmentProjectPolicyComplianceMap = projectImportListener.getInvestmentProjectPolicyComplianceMap();
+            Map<String, Long> documentsMap = projectImportListener.getDocumentsMap();
+            //琛ュ厖type鍜宐usId瀛楁
+            attachments.forEach(attachment -> {
+                String fileName = attachment.getOriginalName();
+                if (ObjectUtil.isNotNull(projectInfoMap.get(fileName))) {
+                    attachment.setBusId(projectInfoMap.get(fileName));
+                    attachment.setType(FileTypeEnum.PROJECT_INFO);
+                } else if (ObjectUtil.isNotNull(investmentProjectPolicyComplianceMap.get(fileName))) {
+                    attachment.setBusId(investmentProjectPolicyComplianceMap.get(fileName));
+                    attachment.setType(FileTypeEnum.INVEST_POLICY);
+                } else if (ObjectUtil.isNotNull(documentsMap.get(fileName))) {
+                    attachment.setBusId(documentsMap.get(fileName));
+                    attachment.setType(FileTypeEnum.DOCUMENT_INFO);
+                }
+            });
+
+            // 娣诲姞椤圭洰闄勪欢鍏宠仈琛�
+            fileService.saveBatch(attachments);
+        } catch (IOException e) {
+            log.error(e.getMessage());
+            throw new RuntimeException(e);
+        } finally {
+            deleteDirectoryOrFile(tempZip);
+            deleteDirectoryOrFile(tempDir);
+        }
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public Result editProject(ProjectForm form) {
+        Long projectId = form.getProjectInfoForm().getId();
+        if (ObjectUtil.isNotNull(form.getProjectInfoForm())) {
+            if (ObjectUtil.isNull(form.getProjectInfoForm().getId())) {
+                //鏂板
+                ProjectInfo entity = ProjectInfoForm.getEntityByForm(form.getProjectInfoForm(), null);
+                Long userId = SecurityUtils.getUserId();
+                entity.setCreateBy(userId);
+                entity.setUpdateBy(userId);
+                //濡傛灉鏄偍澶囬」鐩�(鏈紑宸ラ」鐩�)涓嶉渶瑕佸鏍�
+                if (ProjectCategoryEnum.RESERVE.getType().equals(entity.getProjectPhase())) {
+                    entity.setUsedStatus(ProjectConstant.PASS);
+                }
+                // 绠$悊鍛樹慨鏀圭殑鐩存帴閫氳繃
+                if (SecurityUtils.isAdmin(SecurityUtils.getUserId())) {
+                    entity.setUsedStatus(ProjectConstant.PASS);
+                }
+                if(!checkProjectNameAndIdIsUnique(entity,null)){
+                    throw new RuntimeException("椤圭洰閲嶅锛岄」鐩悕绉般�侀」鐩爜宸插瓨鍦�");
+                }
+                baseMapper.insert(entity);
+                projectId = entity.getId();
+                addPlan(entity.getId()); //娣诲姞璁″垝琛�
+                //娣诲姞椤圭洰涓爣鍗曚綅
+                List<ProjectInfoWinUnit> projectInfoWinUnits = new ArrayList<>();
+                for (ProjectInfoWinUnitForm winUnitForm : form.getProjectInfoForm().getWinUnitList()) {
+                    ProjectInfoWinUnit projectInfoWinUnit = ProjectInfoWinUnitForm.getEntityByForm(winUnitForm, null);
+                    projectInfoWinUnit.setId(null);
+                    projectInfoWinUnit.setProjectInfoId(entity.getId());
+                    projectInfoWinUnits.add(projectInfoWinUnit);
+                }
+                if (!CollectionUtils.isEmpty(projectInfoWinUnits)) {
+                    projectInfoWinUnitService.saveBatch(projectInfoWinUnits);
+                }
+                //娣诲姞骞村害鎶曡祫璁″垝
+                List<ProjectInfoYearPlan> projectInfoYearPlans = new ArrayList<>();
+                for (ProjectInfoYearPlanForm yearPlanForm : form.getProjectInfoForm().getYearPlanList()) {
+                    ProjectInfoYearPlan yearPlan = ProjectInfoYearPlanForm.getEntityByForm(yearPlanForm, null);
+                    yearPlan.setId(null);
+                    yearPlan.setProjectInfoId(entity.getId());
+                    projectInfoYearPlans.add(yearPlan);
+                }
+                if (!CollectionUtils.isEmpty(projectInfoYearPlans)) {
+                    projectInfoYearPlanService.saveBatch(projectInfoYearPlans);
+                }
+            } else {
+                //鏇存柊
+                ProjectInfo entity = baseMapper.selectById(form.getProjectInfoForm().getId());
+
+                // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
+                Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+                ProjectInfoForm.getEntityByForm(form.getProjectInfoForm(), entity);
+                Long userId = SecurityUtils.getUserId();
+                entity.setUpdateBy(userId);
+                //濡傛灉鏄偍澶囬」鐩�(鏈紑宸ラ」鐩�)涓嶉渶瑕佸鏍�
+                if (ProjectCategoryEnum.RESERVE.getType().equals(entity.getProjectPhase())) {
+                    entity.setUsedStatus(ProjectConstant.PASS);
+                }
+                // 绠$悊鍛樹慨鏀圭殑鐩存帴閫氳繃
+                if (SecurityUtils.isAdmin(SecurityUtils.getUserId())) {
+                    entity.setUsedStatus(ProjectConstant.PASS);
+                }
+                if(!checkProjectNameAndIdIsUnique(entity, entity.getId())){
+                    throw new RuntimeException("椤圭洰閲嶅锛岄」鐩悕绉般�侀」鐩爜宸插瓨鍦�");
+                }
+                //鏇存柊椤圭洰淇℃伅
+                baseMapper.updateById(entity);
+                //淇敼椤圭洰涓爣鍗曚綅
+                //鍒犻櫎鍘熸暟鎹�
+                new LambdaUpdateChainWrapper<>(projectInfoWinUnitService.getBaseMapper())
+                        .eq(ProjectInfoWinUnit::getProjectInfoId, entity.getId())
+                        .remove();
+                //娣诲姞椤圭洰涓爣鍗曚綅
+                List<ProjectInfoWinUnit> projectInfoWinUnits = new ArrayList<>();
+                for (ProjectInfoWinUnitForm winUnitForm : form.getProjectInfoForm().getWinUnitList()) {
+                    ProjectInfoWinUnit projectInfoWinUnit = ProjectInfoWinUnitForm.getEntityByForm(winUnitForm, null);
+                    projectInfoWinUnit.setId(null);
+                    projectInfoWinUnit.setProjectInfoId(entity.getId());
+                    projectInfoWinUnits.add(projectInfoWinUnit);
+                }
+                if (!CollectionUtils.isEmpty(projectInfoWinUnits)) {
+                    projectInfoWinUnitService.saveBatch(projectInfoWinUnits);
+                }
+
+                //淇敼骞村害鎶曡祫璁″垝
+                //鍒犻櫎鍘熸暟鎹�
+                new LambdaUpdateChainWrapper<>(projectInfoYearPlanService.getBaseMapper())
+                        .eq(ProjectInfoYearPlan::getProjectInfoId, entity.getId())
+                        .remove();
+                //娣诲姞骞村害鎶曡祫璁″垝
+                List<ProjectInfoYearPlan> projectInfoYearPlans = new ArrayList<>();
+                for (ProjectInfoYearPlanForm yearPlanForm : form.getProjectInfoForm().getYearPlanList()) {
+                    ProjectInfoYearPlan yearPlan = ProjectInfoYearPlanForm.getEntityByForm(yearPlanForm, null);
+                    yearPlan.setId(null);
+                    yearPlan.setProjectInfoId(entity.getId());
+                    projectInfoYearPlans.add(yearPlan);
+                }
+                if (!CollectionUtils.isEmpty(projectInfoYearPlans)) {
+                    projectInfoYearPlanService.saveBatch(projectInfoYearPlans);
+                }
+            }
+
+            // 鏇存柊鍏跺畠椤圭洰淇℃伅琛�
+            if (Objects.nonNull(form.getProjectInvestmentFundingForm())) {
+                if (Objects.nonNull(form.getProjectInvestmentFundingForm().getId())) {
+                    projectInvestmentFundingServiceImpl.update(form.getProjectInvestmentFundingForm());
+                } else {
+                    form.getProjectInvestmentFundingForm().setProjectId(projectId);
+                    projectInvestmentFundingServiceImpl.add(form.getProjectInvestmentFundingForm());
+                }
+            }
+            if (Objects.nonNull(form.getProjectUnitRegistrationInfoForm())) {
+                if (Objects.nonNull(form.getProjectUnitRegistrationInfoForm().getId())) {
+                    projectUnitRegistrationInfoServiceImpl.update(form.getProjectUnitRegistrationInfoForm());
+                } else {
+                    form.getProjectUnitRegistrationInfoForm().setProjectId(projectId);
+                    projectUnitRegistrationInfoServiceImpl.add(form.getProjectUnitRegistrationInfoForm());
+                }
+
+            }
+        }
+        return Result.ok("淇濆瓨鎴愬姛");
+    }
+
+    @Override
+    public Result searchByKey(String wordKey) {
+        Wrapper wrapper = null;
+        if (!StringUtils.isEmpty(wordKey)) {
+            wrapper = Wrappers.<ProjectInfo>lambdaQuery().like(ProjectInfo::getProjectName, wordKey).or().like(ProjectInfo::getProjectCode, wordKey);
+        }
+        List<ProjectInfo> list = baseMapper.selectList(wrapper);
+        return Result.ok().data(list);
+    }
+
+    private static void deleteDirectoryOrFile(java.io.File file) {
+        if (ObjectUtil.isNull(file)) {
+            return;
+        }
+
+        if (file.isDirectory()) {
+            java.io.File[] files = file.listFiles();
+            if (files != null) {
+                for (java.io.File f : files) {
+                    deleteDirectoryOrFile(f);
+                }
+            }
+        }
+        file.delete();
+    }
+
+    /**
+     * 椤圭洰鍚嶇О鏍¢獙閲嶅
+     *
+     * @return
+     */
+    public void checkProjectNameUnique(ProjectInfo projectInfo) {
+        if (StrUtil.isBlank(projectInfo.getProjectName())) {
+            throw new BaseException("椤圭洰鍚嶇О涓嶈兘涓虹┖");
+        }
+        Assert.isTrue(baseMapper.selectCount(Wrappers.<ProjectInfo>lambdaQuery().eq(ProjectInfo::getProjectName, projectInfo.getProjectName())) == 0, "椤圭洰鍚嶇О閲嶅");
+    }
+
 }

--
Gitblit v1.8.0