From 62036cc09bbe5346868b98fcc373910b55da08b9 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期五, 06 十二月 2024 14:04:49 +0800 Subject: [PATCH] bug修改 --- business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java | 319 ++++++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 289 insertions(+), 30 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 39d69d4..c9b5b18 100644 --- a/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java +++ b/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java @@ -1,35 +1,57 @@ package com.ycl.service.impl; +import cn.hutool.core.collection.CollUtil; +import cn.hutool.core.util.ObjectUtil; +import cn.hutool.core.util.ZipUtil; +import com.alibaba.excel.EasyExcel; +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.service.impl.ServiceImpl; import com.ycl.common.base.Result; +import com.ycl.common.config.SysConfig; +import com.ycl.common.constant.Constants; import com.ycl.common.enums.business.FileTypeEnum; +import com.ycl.common.enums.business.ImportanceTypeEnum; +import com.ycl.common.enums.business.ProjectCategoryEnum; +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.common.utils.StringUtils; +import com.ycl.common.utils.bean.BeanUtils; +import com.ycl.common.utils.excel.OutputExcelUtils; +import com.ycl.domain.entity.*; +import com.ycl.domain.excel.ProjectExcelTemplate; import com.ycl.domain.form.DocumentInfoForm; import com.ycl.domain.form.ProjectInfoForm; +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.mapper.*; import com.ycl.service.FileService; import com.ycl.service.ProjectInfoService; import lombok.RequiredArgsConstructor; -import org.springframework.beans.BeanUtils; +import org.apache.commons.codec.Charsets; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.Assert; -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import javax.servlet.ServletOutputStream; +import javax.servlet.http.HttpServletResponse; +import java.io.FileOutputStream; +import java.io.IOException; +import java.math.BigDecimal; +import java.math.RoundingMode; +import java.net.URLEncoder; +import java.nio.charset.StandardCharsets; +import java.nio.file.Files; +import java.nio.file.StandardCopyOption; +import java.text.SimpleDateFormat; +import java.util.*; import java.util.stream.Collectors; +import java.util.zip.ZipOutputStream; /** * 椤圭洰绠$悊鍩虹淇℃伅琛� 鏈嶅姟瀹炵幇绫� @@ -42,6 +64,10 @@ public class ProjectInfoServiceImpl extends ServiceImpl<ProjectInfoMapper, ProjectInfo> implements ProjectInfoService { private final ProjectInfoMapper projectInfoMapper; + private final ProjectInvestmentFundingMapper investmentFundingMapper; + private final ProjectInvestmentInfoMapper investmentInfoMapper; + private final ProjectInvestmentPolicyComplianceMapper policyMapper; + private final ProjectUnitRegistrationInfoMapper unitRegistrationInfoMapper; private final FileService fileService; private final FileMapper fileMapper; @@ -110,7 +136,6 @@ * @return */ @Override - //TODO:寰呭畬鍠� public Result remove(List<String> ids) { baseMapper.deleteBatchIds(ids); return Result.ok("鍒犻櫎鎴愬姛"); @@ -123,8 +148,18 @@ * @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)); + + 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("鍒犻櫎鎴愬姛"); } @@ -143,27 +178,53 @@ if (query.getProjectEndTime() != null) { query.setProjectEndTime(DateUtils.getDayEnd(query.getProjectEndTime())); } + String projectCategory = query.getProjectCategory(); + //瀹炴柦闃舵鏈変袱涓�兼斁鍦╯ql澶勭悊 + if (ProjectCategoryEnum.RESERVE.getType().equals(projectCategory)) { + query.setProjectStatus(ProjectCategoryEnum.RESERVE.getStatus()); + query.setReserveOrPrevious(ProjectCategoryEnum.RESERVE.getCode()); + } else if (ProjectCategoryEnum.PREVIOUS.getType().equals(projectCategory)) { + query.setProjectStatus(ProjectCategoryEnum.PREVIOUS.getStatus()); + query.setReserveOrPrevious(ProjectCategoryEnum.PREVIOUS.getCode()); + } else if (ProjectCategoryEnum.FINISH.getType().equals(projectCategory)) { + query.setProjectStatus(ProjectCategoryEnum.FINISH.getStatus()); + } else if (ProjectCategoryEnum.EXCEPTION.getType().equals(projectCategory)) { + //TODO + //鍏堟煡鍑哄紓甯告祦绋嬫垨鑰呭紓甯歌繘搴︽垨鑰呭紓甯歌鍒掔殑projectId鍜屽紓甯哥绫� + //閫氳繃projectId鏌ュ嚭椤圭洰鏁版嵁 + //琛ュ厖鐩稿簲鐨勫紓甯告暟鎹紙寮傚父绉嶇被銆佸紓甯告祦绋嬭妭鐐圭瓑锛� + List<ProjectVO> list = new ArrayList<>(); + return Result.ok().data(list).total(0); + } + IPage<ProjectInfoVO> page = PageUtil.getPage(query, ProjectInfoVO.class); baseMapper.getPage(page, query); List<ProjectInfoVO> records = page.getRecords(); List<ProjectVO> list = new ArrayList<>(); records.forEach(vo -> { - ProjectInfoVO.transform(vo); - vo.setProjectColorCode("green"); + ProjectInfoVO.transform(vo); + vo.setProjectColorCode("green"); ProjectVO projectVO = new ProjectVO(); - copyToProjectVO(vo,projectVO); + copyToProjectVO(vo, projectVO); + //缈昏瘧椤圭洰闃舵 + String phase = ProjectCategoryEnum.getPhaseByProjectStatus(projectVO.getProjectStatus(), projectVO.getProcessId() != null); + projectVO.setProjectPhase(phase); list.add(projectVO); }); return Result.ok().data(list).total(page.getTotal()); } - private void copyToProjectVO(ProjectInfoVO vo,ProjectVO projectVO) { + private void copyToProjectVO(ProjectInfoVO vo, ProjectVO projectVO) { //蹇界暐null鍊肩殑澶嶅埗 CopyUtils.copyNoNullProperties(vo, projectVO); - if(vo.getProjectInvestmentFunding()!=null) CopyUtils.copyNoNullProperties(vo.getProjectInvestmentFunding(),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.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); } /** @@ -209,17 +270,80 @@ // {"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(); + 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.getProjectStatus(), item.getProcessId() != null))) { + reserve.add(item); + } else if (ProjectCategoryEnum.PREVIOUS.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectStatus(), item.getProcessId() != null))) { + previous.add(item); + } else if (ProjectCategoryEnum.IMPLEMENT.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectStatus(), item.getProcessId() != null))) { + implement.add(item); + } else if (ProjectCategoryEnum.FINISH.getDesc().equals(ProjectCategoryEnum.getPhaseByProjectStatus(item.getProjectStatus(), item.getProcessId() != null))) { + finish.add(item); + } + + if (ImportanceTypeEnum.PROVINCIAL_KEY.getType().equals(item.getImportanceType())) { + province.add(item); + } else if (ImportanceTypeEnum.SUINING_KEY.getType().equals(item.getImportanceType())) { + city.add(item); + } else if (ImportanceTypeEnum.SHEHONG_KEY.getType().equals(item.getImportanceType())) { + county.add(item); + } else if (ImportanceTypeEnum.NORMAL.getType().equals(item.getImportanceType())) { + 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("100000000"), 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("100000000"), 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("100000000"), 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("100000000"), 2, RoundingMode.HALF_UP).toString(), "绔�")); + indexCountVO.setProPhaseCountVO(proPhaseCountVO); + + List<IndexImpTypeCountVO> impTypeCountVO = new ArrayList<>(); + 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("100000000"), 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("100000000"), 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("100000000"), 2, RoundingMode.HALF_UP).toString(), "甯�")); + + 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("100000000"), 2, RoundingMode.HALF_UP).toString(), "鐪�")); + indexCountVO.setImpTypeCountVO(impTypeCountVO); return indexCountVO; @@ -260,4 +384,139 @@ fileService.saveBatch(fileList); return Result.ok(); } + + @Override + public Result getManagerFlag(Integer recordId) { + ProjectInfo projectInfo = baseMapper.selectById(recordId); + // 鍒ゆ柇褰撳墠鐢ㄦ埛id鏄惁鍦ㄤ富绠″垪琛ㄤ腑 + String competentDepartment = projectInfo.getCompetentDepartment(); + List<String> list = Arrays.asList(competentDepartment.split(",")); + // 鑾峰緱褰撳墠鐢ㄦ埛id + Long userId = SecurityUtils.getUserId(); + if (list.contains(userId.toString())) { + return Result.ok().data(true); + } else { + 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.getProjectStatus(), item.getProcessId() != null)); + 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); + } + } + } } -- Gitblit v1.8.0