From 8d491a439cd84ec8667e140a853040e591107fdf Mon Sep 17 00:00:00 2001
From: shenyijian <1178253012@qq.com>
Date: Mon, 23 Sep 2024 18:20:04 +0800
Subject: [PATCH] 湖北水库:审批流程问题整改

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java |  400 ++++++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 350 insertions(+), 50 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
index 5405251..bf264d3 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
@@ -7,26 +7,22 @@
 import cn.gistack.sm.sg.mapper.SgGxStepMapper;
 import cn.gistack.sm.sg.mapper.SgProgressReportMapper;
 import cn.gistack.sm.sg.mapper.SgProjectInfoMapper;
+import cn.gistack.sm.sg.service.SgProgressReportService;
 import cn.gistack.sm.sg.service.SgProjectInfoService;
 import cn.gistack.sm.sjztmd.entity.AttAdBase;
 import cn.gistack.sm.sjztmd.service.IAttAdBaseService;
-import cn.hutool.core.lang.copier.Copier;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
 import com.baomidou.mybatisplus.core.toolkit.StringUtils;
-import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import org.jetbrains.annotations.NotNull;
 import org.springblade.core.secure.utils.AuthUtil;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
-import org.springframework.util.StopWatch;
 
-import javax.security.auth.login.LoginContext;
 import java.math.BigDecimal;
-import java.math.MathContext;
 import java.math.RoundingMode;
 import java.util.*;
 import java.util.function.Function;
@@ -53,19 +49,105 @@
 	@Autowired
 	private SgGxStepMapper sgGxStepMapper;
 
+	@Autowired
+	private SgProgressReportServiceImpl sgProgressReportService;
+
 	@Override
-	public IPage<SgProjectInfoDO> queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO) {
+	public Object queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO) {
 		List<String> sgCodeS = getSgCodeByUser();
 		searchDTO.setSgCodeS(sgCodeS);
-		List<SgProjectInfoDO> sgProjectInfoDOS = baseMapper.queryPageList(page,searchDTO);
-		List<SgProjectInfoDO> projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject(searchDTO));
-		if (CollectionUtils.isNotEmpty(projectProgress)){
-			Map<Long, String> progressMap = projectProgress.stream().filter(s->s.getProjectProgress()!=null).collect(Collectors.toMap(SgProjectInfoDO::getId, SgProjectInfoDO::getProjectProgress));
+		setAdCode(searchDTO);
+		Boolean isPage = searchDTO.getIsPage();
+		if (isPage==null) isPage = true;
+		if (isPage ){
+			List<SgProjectInfoDO> sgProjectInfoDOS = baseMapper.queryPageList(page,searchDTO);
+			List<SgProjectInfoDO> projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject(searchDTO));
+			if (CollectionUtils.isNotEmpty(projectProgress)){
+				Map<Long, String> progressMap = projectProgress.stream().filter(s->s.getProjectProgress()!=null).collect(Collectors.toMap(SgProjectInfoDO::getId, SgProjectInfoDO::getProjectProgress));
+				sgProjectInfoDOS.forEach(s->{
+					s.setProjectProgress(progressMap.get(s.getId()));
+//					setPercentage(s);
+				});
+			}
+			return page.setRecords(sgProjectInfoDOS);
+		}else {
+			List<SgAllDeptOrUser> allDepts = sgProjectInfoMapper.queryDept();
+			Map<Long, String> deptMap = allDepts.stream().collect(Collectors.toMap(SgAllDeptOrUser::getId, SgAllDeptOrUser::getName));
+			List<SgAllDeptOrUser> allUser = sgProjectInfoMapper.queryUser();
+			Map<Long, String> userMap = allUser.stream().collect(Collectors.toMap(SgAllDeptOrUser::getId, SgAllDeptOrUser::getName));
+			List<SgProjectInfoDO> sgProjectInfoDOS = baseMapper.queryPageList(null,searchDTO);
+			List<SgProjectInfoDO> projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject(searchDTO));
+			if (CollectionUtils.isNotEmpty(projectProgress)){
+				Map<Long, String> progressMap = projectProgress.stream().filter(s->s.getProjectProgress()!=null).collect(Collectors.toMap(SgProjectInfoDO::getId, SgProjectInfoDO::getProjectProgress));
+				sgProjectInfoDOS.forEach(s->{
+					s.setProjectProgress(progressMap.get(s.getId()));
+//					setPercentage(s);
+				});
+			}
 			sgProjectInfoDOS.forEach(s->{
-				s.setProjectProgress(progressMap.get(s.getId()));
+				//土建
+				if (StringUtils.isNotBlank(s.getConstructionUnit())){
+					s.setConstructionUnit(deptMap.get(Long.valueOf(s.getConstructionUnit())));
+				}
+				s.setConstructionPerson(getUserNames(userMap, s.getConstructionPerson()));
+
+				//设备
+				if (StringUtils.isNotBlank(s.getSelfUnit())){
+					s.setSelfUnit(deptMap.get(Long.valueOf(s.getSelfUnit())));
+				}
+				s.setSelfPerson(getUserNames(userMap, s.getSelfPerson()));
+
+				//设计
+				if (StringUtils.isNotBlank(s.getDesignUnit())){
+					s.setDesignUnit(deptMap.get(Long.valueOf(s.getDesignUnit())));
+				}
+				s.setDesignPerson(getUserNames(userMap, s.getDesignPerson()));
+
+				//监理
+				if (StringUtils.isNotBlank(s.getControlUnit())){
+					s.setControlUnit(deptMap.get(Long.valueOf(s.getControlUnit())));
+				}
+				s.setControlPerson(getUserNames(userMap, s.getControlPerson()));
+
+				//检测
+				if (StringUtils.isNotBlank(s.getAcceptanceUnit())){
+					s.setAcceptanceUnit(deptMap.get(Long.valueOf(s.getAcceptanceUnit())));
+				}
+				s.setAcceptancePerson(getUserNames(userMap, s.getAcceptancePerson()));
 			});
+			return sgProjectInfoDOS;
 		}
-		return page.setRecords(sgProjectInfoDOS);
+
+	}
+
+	/**
+	 * 设置百分号
+	 * @param s
+	 */
+	private void setPercentage(SgProjectInfoDO s) {
+		s.setSurfaceProgress(StringUtils.isNotBlank(s.getSurfaceProgress()) ?null:s.getSurfaceProgress()+"%");
+		s.setVideoProgress(StringUtils.isNotBlank(s.getVideoProgress())?null:s.getVideoProgress()+"%");
+		s.setTransProgress(StringUtils.isNotBlank(s.getTransProgress())?null:s.getTransProgress()+"%");
+		s.setSeepageProgress(StringUtils.isNotBlank(s.getSeepageProgress())?null:s.getSeepageProgress()+"%");
+		s.setProjectAddress(StringUtils.isNotBlank(s.getProjectProgress())?null:s.getProjectProgress()+"%");
+	}
+
+	/**
+	 * 获取用户姓名
+	 * @param userMap
+	 * @return
+	 */
+	private  String getUserNames(Map<Long, String> userMap,String person ) {
+		String userNames = "";
+		if (StringUtils.isNotBlank(person)){
+			// 使用Stream API来处理分割和映射
+			 userNames = Arrays.stream(person.split(",")) // 将字符串按逗号分割成数组,并转为Stream
+				.map(Long::valueOf) // 将每个字符串元素转换为Long
+				.map(userMap::get) // 使用userMap将Long映射为对应的用户名
+				.collect(Collectors.joining(",")); // 使用逗号将用户名拼接成一个字符串
+			return userNames;
+		}
+		return userNames;
 	}
 
 	/**
@@ -225,33 +307,57 @@
 	 */
 	@Override
 	public IPage<SgProjectInfoVO> progressPage(IPage<SgProjectInfoVO> page, ProjectSearchDTO searchDTO) {
+//		setDeptId(searchDTO);
 		List<SgProjectInfoVO> list = new ArrayList<>();
-			if(!searchDTO.getAdCode().isEmpty()){
+			if(StringUtils.isNotBlank(searchDTO.getAdCode())){
 				list =	sgProjectInfoMapper.progressList1(page, searchDTO);
 			}else {
 				list = sgProjectInfoMapper.progressList(page, searchDTO);
 			}
 
-		List<Long> ids = list.stream().map(SgProjectInfoVO::getId).collect(Collectors.toList());
-		searchDTO.setProjectIds(ids);
-		List<SgProjectInfoDO> projectProgress = new ArrayList<>();
-		if(!searchDTO.getAdCode().isEmpty()){
-			projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject1(searchDTO));
-		}else {
-			projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject(searchDTO));
-		}
+//		List<Long> ids = list.stream().map(SgProjectInfoVO::getId).collect(Collectors.toList());
+//		searchDTO.setProjectIds(ids);
+//		List<SgProjectInfoDO> projectProgress = new ArrayList<>();
+//		if(StringUtils.isNotBlank(searchDTO.getAdCode())){
+//			projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject1(searchDTO));
+//		}else {
+//			projectProgress = getProjectProgress(sgProjectInfoMapper.queryStepByProject(searchDTO));
+//		}
 
-		if (CollectionUtils.isNotEmpty(projectProgress)){
-		Map<Long, String> progressMap = projectProgress.stream().filter(s->s!=null && s.getProjectProgress() !=null).collect(Collectors.toMap(SgProjectInfoDO::getId, SgProjectInfoDO::getProjectProgress));
+//		if (CollectionUtils.isNotEmpty(projectProgress)){
+		//Map<Long, String> progressMap = projectProgress.stream().filter(s->s!=null && s.getProjectProgress() !=null).collect(Collectors.toMap(SgProjectInfoDO::getId, SgProjectInfoDO::getProjectProgress));
 		list.forEach(s->{
-			s.setProjectProgress(progressMap.get(s.getId()));
-		});}
+			if (StringUtils.isNotBlank(s.getProjectProgress())){
+				s.setProjectProgress(s.getProjectProgress()+"%");
+			}else {
+				s.setProjectProgress("0%");
+			}
+		});
+//		}
 		return page.setRecords(list);
 	}
 
 	@Override
 	public List<SgProjectInfoDO> listAll(ProjectSearchDTO searchDTO) {
-		return sgProjectInfoMapper.queryPageList(null,searchDTO);
+		List<String> sgCodeS = getSgCodeByUser();
+		searchDTO.setSgCodeS(sgCodeS);
+		setDeptId(searchDTO);
+		List<SgProjectInfoDO> list = sgProjectInfoMapper.queryPageList(null, searchDTO);
+		return list;
+	}
+
+	/**
+	 * setDeptId
+	 * @param searchDTO
+	 */
+	private  void setDeptId(ProjectSearchDTO searchDTO) {
+		String deptId = AuthUtil.getDeptId();
+		boolean b = Objects.nonNull(searchDTO.getIsUnit()) && searchDTO.getIsUnit() == 1;
+		if (!deptId.equals("420000000000")){
+			if (!b){
+				searchDTO.setDeptId(deptId);
+			}
+		}
 	}
 
 	/**
@@ -280,35 +386,84 @@
 	public List<SgStatisProVO> getsgStatisticsList(String code) {
 		AttAdBase ywxtAdDetail = iAttAdBaseService.getYwxtAdDetail(code);
 		List<SgStatisProVO> sgStatisProVOS;
-
-
 		//片区
 		if (ywxtAdDetail == null) {
 			sgStatisProVOS = sgProjectInfoMapper.getsgStatisticsZero(code);
-			getDeviceTypes(sgStatisProVOS);
+			setDeviceTypes(sgStatisProVOS);
 //			String getname = sgProjectInfoMapper.getname(code);
 			String getname = code;
 			updateProjectProgress(sgStatisProVOS, code, getname, "2");
 		} else if (ywxtAdDetail.getAdGrad().equals("1")) {//默认
 			sgStatisProVOS = sgProjectInfoMapper.getsgStatisticsOne(code);
-			getDeviceTypes(sgStatisProVOS);
+			sgStatisProVOS = getSgStatisProVOS(sgStatisProVOS);
+			setDeviceTypes(sgStatisProVOS);
 			updateProjectProgress(sgStatisProVOS, ywxtAdDetail.getPAdCode(), ywxtAdDetail.getPAdName(), "0");
 		} else {//区县
 			sgStatisProVOS = sgProjectInfoMapper.getsgStatisticsList(code);
-			getDeviceTypes(sgStatisProVOS);
+			setDeviceTypes(sgStatisProVOS);
 			updateProjectProgress(sgStatisProVOS, ywxtAdDetail.getAdCode(), ywxtAdDetail.getAdName(), "3");
 		}
 		return sgStatisProVOS;
 	}
 
 	/**
-	 * 统计设备类型开工率
+	 * 统计施工进度
 	 * @param sgStatisProVOS
 	 */
-	private void getDeviceTypes(List<SgStatisProVO> sgStatisProVOS) {
+	private void setDeviceTypes(List<SgStatisProVO> sgStatisProVOS) {
 		if (CollectionUtils.isNotEmpty(sgStatisProVOS)){
+			Map<String, SgOperatingRateVO> deviceTypes = getDeviceTypes(sgStatisProVOS.stream().map(SgStatisProVO::getProIds).collect(Collectors.toList()));
 			for (SgStatisProVO vo : sgStatisProVOS) {
-				String proIds = vo.getProIds();
+				SgOperatingRateVO sVo = deviceTypes.get(vo.getProIds());
+				if (Objects.nonNull(sVo)){
+					vo.setSurfaceNum(sVo.getSurfaceNum());
+					vo.setSurfaceProgress(sVo.getSurfaceProgress());
+					vo.setVideoNum(sVo.getVideoNum());
+					vo.setVideoProgress(sVo.getVideoProgress());
+					vo.setTransNum(sVo.getTransNum());
+					vo.setTransProgress(sVo.getTransProgress());
+					vo.setSeepageNum(sVo.getSeepageNum());
+					vo.setSeepageProgress(sVo.getSeepageProgress());
+				}
+			}
+		}
+	}
+
+	/**
+	 * 标段排序
+	 * @param sgStatisProVOS
+	 * @return
+	 */
+	private  List<SgStatisProVO> getSgStatisProVOS(List<SgStatisProVO> sgStatisProVOS) {
+		sgStatisProVOS = sgStatisProVOS.stream()
+			.sorted(Comparator.comparing(s -> {
+				String scode = s.getCode();
+				if (scode.equals("第一标段")) {
+					return 1;
+				} else if (scode.equals("第二标段")) {
+					return 2;
+				} else if (scode.equals("第三标段")) {
+					return 3;
+				} else if (scode.equals("第四标段")) {
+					return 4;
+				} else if (scode.equals("第五标段")) {
+					return 5;
+				} else {
+					return Integer.MAX_VALUE;
+				}
+			}))
+			.collect(Collectors.toList());
+		return sgStatisProVOS;
+	}
+
+	/**
+	 * 统计设备类型开工率
+	 */
+	public Map<String,SgOperatingRateVO> getDeviceTypes(List<String> projectIds) {
+		Map<String,SgOperatingRateVO> result = new HashMap<>();
+		if (CollectionUtils.isNotEmpty(projectIds)){
+			for (String proIds : projectIds) {
+				SgOperatingRateVO sgOperatingRateVO = new SgOperatingRateVO();
 				if (StringUtils.isNotBlank(proIds)){
 				List<SgStatisDeviceVO> deviceVOS =	sgProjectInfoMapper.getDeviceTypes("("+proIds+")");
 				if(CollectionUtils.isNotEmpty(deviceVOS)){
@@ -318,12 +473,12 @@
 					if (Objects.nonNull(sg108)){
 						Integer deviceCount = sg108.getDeviceCount();
 						Integer deviceStart = sg108.getDeviceStart();
-						vo.setSurfaceNum(deviceCount);
+						sgOperatingRateVO.setSurfaceNum(deviceCount);
 						if (deviceCount != 0){
 							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
-							vo.setSeepageProgress(getBigDecimalPercent(divide));
+							sgOperatingRateVO.setSeepageProgress(getBigDecimalPercent(divide));
 						}else {
-							vo.setSeepageProgress("0%");
+							sgOperatingRateVO.setSeepageProgress("0%");
 						}
 					}
 					//视频
@@ -331,12 +486,12 @@
 					if (Objects.nonNull(sg104)){
 						Integer deviceCount = sg104.getDeviceCount();
 						Integer deviceStart = sg104.getDeviceStart();
-						vo.setVideoNum(deviceCount);
+						sgOperatingRateVO.setVideoNum(deviceCount);
 						if (deviceCount != 0){
 							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
-							vo.setVideoProgress(getBigDecimalPercent(divide));
+							sgOperatingRateVO.setVideoProgress(getBigDecimalPercent(divide));
 						}else {
-							vo.setVideoProgress("0%");
+							sgOperatingRateVO.setVideoProgress("0%");
 						}
 					}
 					//渗压
@@ -344,12 +499,12 @@
 					if (Objects.nonNull(sg101)){
 						Integer deviceCount = sg101.getDeviceCount();
 						Integer deviceStart = sg101.getDeviceStart();
-						vo.setTransNum(deviceCount);
+						sgOperatingRateVO.setTransNum(deviceCount);
 						if (deviceCount != 0){
 							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
-							vo.setTransProgress(getBigDecimalPercent(divide));
+							sgOperatingRateVO.setTransProgress(getBigDecimalPercent(divide));
 						}else {
-							vo.setTransProgress("0%");
+							sgOperatingRateVO.setTransProgress("0%");
 						}
 					}
 					//渗流
@@ -357,18 +512,20 @@
 					if (Objects.nonNull(sg102)){
 						Integer deviceCount = sg102.getDeviceCount();
 						Integer deviceStart = sg102.getDeviceStart();
-						vo.setSeepageNum(deviceCount);
+						sgOperatingRateVO.setSeepageNum(deviceCount);
 						if (deviceCount != 0){
 							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
-							vo.setSeepageProgress(getBigDecimalPercent(divide));
+							sgOperatingRateVO.setSeepageProgress(getBigDecimalPercent(divide));
 						}else {
-							vo.setSeepageProgress("0%");
+							sgOperatingRateVO.setSeepageProgress("0%");
 						}
 					}
 					}
+					result.put(proIds,sgOperatingRateVO);
 				}
 			}
 		}
+		return result;
 	}
 
 	private void updateProjectProgress(List<SgStatisProVO> sgStatisProVOS, String pcode, String pname, String adGrad) {
@@ -386,7 +543,11 @@
 				for (String id : ids) {
 					projectSearchDTO.setProjectId(id);
 					List<SgProjectInfoVO> list = sgProjectInfoMapper.queryStepByProject(projectSearchDTO);
-					getProjectProgress(list).forEach(ss -> bigDecimals.add(ss.getProjectProgressNum()));
+					getProjectProgress(list).forEach(ss->{
+						if (Objects.nonNull(ss.getProjectProgressNum())){
+							bigDecimals.add(ss.getProjectProgressNum());
+						}
+					});
 				}
 
 				BigDecimal reduce = bigDecimals.stream().reduce(BigDecimal.ZERO, BigDecimal::add);
@@ -466,10 +627,12 @@
 
 	@Override
 	public Map<String, Object> projectCount(ProjectSearchDTO searchDTO) {
+		List<String> sgCodeS = getSgCodeByUser();
+		searchDTO.setSgCodeS(sgCodeS);
 		Map<String, Object> map  = new HashMap<>();
 		List<SgProjectInfoVO> progressList = progressList(searchDTO);
 		BigDecimal reduce = progressList.stream().filter(s->s.getProjectProgressNum()!=null).map(SgProjectInfoDO::getProjectProgressNum).reduce(BigDecimal.ZERO, BigDecimal::add);
-		BigDecimal divide = reduce.divide(BigDecimal.valueOf(progressList.size()), 2, RoundingMode.HALF_UP);
+		BigDecimal divide = reduce.divide(BigDecimal.valueOf(progressList.size()==0?1:progressList.size()), 2, RoundingMode.HALF_UP);
 		List<SgProjectInfoDO> pending = progressList.stream().filter(s -> s.getStatus() == 0).collect(Collectors.toList());
 		List<SgProjectInfoDO> progress = progressList.stream().filter(s -> s.getStatus() == 1).collect(Collectors.toList());
 		List<SgProjectInfoDO> over = progressList.stream().filter(s -> s.getStatus() == 2).collect(Collectors.toList());
@@ -490,10 +653,16 @@
 	private  PreAcceVO handleQuery( int stepIdForNull, Long programId) {
 		QueryWrapper<SgProgressReportDO> queryWrapper = new QueryWrapper<>();
 		queryWrapper.eq("gx_step_id", stepIdForNull)
-			.ne("status",3)
 			.eq("profram_id", programId);
-		SgProgressReportDO sgProgressReportDO = sgProgressReportMapper.selectOne(queryWrapper);
+		SgProgressReportDO sgProgressReportDO = null;
 
+		List<SgProgressReportDO> sgProgressReportDOS = sgProgressReportMapper.selectList(queryWrapper);
+		if (CollectionUtils.isNotEmpty(sgProgressReportDOS)) {
+			List<SgProgressReportDO> collect = sgProgressReportDOS.stream().filter(s -> s.getStatus() == null || (s.getStatus() != 4 && !(s.getStatus() == 3 && s.getResubmit() != 0))).collect(Collectors.toList());
+		  if (!collect.isEmpty()){
+			  sgProgressReportDO = collect.get(0);
+		  }
+		}
 		PreAcceVO preAcceVO = new PreAcceVO();
 		if (sgProgressReportDO!= null) {
 			preAcceVO.setId(sgProgressReportDO.getId().toString());
@@ -514,4 +683,135 @@
 
 	}
 
+
+	@Override
+	public List<SgProjectTreeVO> projectTree(ProjectSearchDTO dto) {
+		List<String> sgCodeS = getSgCodeByUser();
+		dto.setSgCodeS(sgCodeS);
+		setAdCode(dto);
+		List<SgProjectTreeVO> list = 	sgProjectInfoMapper.projectTree(dto);
+		if (CollectionUtils.isNotEmpty(list)){
+			list.forEach(x->{
+				if (StringUtils.isBlank(x.getCountyNm())){
+					x.setCountyNm(x.getCityNm());
+				}
+				if (StringUtils.isBlank(x.getTownNm())){
+					x.setTownNm(x.getCountyNm());
+				}
+			});
+			// 按省、片区、市、县、乡镇分组
+			Map<String, Map<String, Map<String, Map<String, Map<String, List<SgProjectTreeVO>>>>>> groupedProjects = list.stream()
+				.collect(
+					Collectors.groupingBy(SgProjectTreeVO::getProvinceNm,
+						Collectors.groupingBy(SgProjectTreeVO::getLot,
+							Collectors.groupingBy(SgProjectTreeVO::getCityNm,
+								Collectors.groupingBy(SgProjectTreeVO::getCountyNm,
+									Collectors.groupingBy(SgProjectTreeVO::getTownNm
+									))))));
+				List<SgProjectTreeVO> tree = new ArrayList<>();
+				for (Map.Entry<String, Map<String, Map<String, Map<String, Map<String, List<SgProjectTreeVO>>>>>> provinceEntry : groupedProjects.entrySet()) {
+					SgProjectTreeVO provinceNode = new SgProjectTreeVO();
+					provinceNode.setProvinceNm(provinceEntry.getKey());
+					provinceNode.setRegionName(provinceEntry.getKey());
+					provinceNode.setId(UUID.randomUUID().toString().replace("-",""));
+					provinceNode.setLevel(1);
+					List<SgProjectTreeVO> provinceChildren = new ArrayList<>();
+					for (Map.Entry<String, Map<String, Map<String, Map<String, List<SgProjectTreeVO>>>>> lotEntry : provinceEntry.getValue().entrySet()) {
+						SgProjectTreeVO lotNode = new SgProjectTreeVO();
+						List<String> lotIds = new ArrayList<>();
+						lotNode.setLot(lotEntry.getKey());
+						lotNode.setRegionName(lotEntry.getKey());
+						lotNode.setId(UUID.randomUUID().toString().replace("-",""));
+						lotNode.setLevel(2);
+						List<SgProjectTreeVO> lotChildren = new ArrayList<>();
+						for (Map.Entry<String, Map<String, Map<String, List<SgProjectTreeVO>>>> cityEntry : lotEntry.getValue().entrySet()) {
+							SgProjectTreeVO cityNode = new SgProjectTreeVO();
+							List<String> cityIds = new ArrayList<>();
+							cityNode.setCityNm(cityEntry.getKey());
+							cityNode.setRegionName(cityEntry.getKey());
+							cityNode.setId(UUID.randomUUID().toString().replace("-",""));
+							cityNode.setLevel(3);
+							List<SgProjectTreeVO> cityChildren = new ArrayList<>();
+							for (Map.Entry<String, Map<String, List<SgProjectTreeVO>>> countyEntry : cityEntry.getValue().entrySet()) {
+								SgProjectTreeVO countyNode = new SgProjectTreeVO();
+								List<String> countyIds = new ArrayList<>();
+								countyNode.setCountyNm(countyEntry.getKey());
+								countyNode.setRegionName(countyEntry.getKey());
+								countyNode.setId(UUID.randomUUID().toString().replace("-",""));
+								countyNode.setLevel(4);
+								List<SgProjectTreeVO> countyChildren = new ArrayList<>();
+								for (Map.Entry<String, List<SgProjectTreeVO>> townEntry : countyEntry.getValue().entrySet()) {
+									SgProjectTreeVO townNode = new SgProjectTreeVO();
+									townNode.setTownNm(townEntry.getKey());
+									townNode.setRegionName(townEntry.getKey());
+									townNode.setChildList(townEntry.getValue());
+									townNode.setChildNum((long) townEntry.getValue().size());
+									townNode.setId(UUID.randomUUID().toString().replace("-",""));
+									townNode.setLevel(5);
+									townNode.setProjectIds(townEntry.getValue().stream().map(SgProjectTreeVO::getId).collect(Collectors.toList()));
+									countyIds.addAll(townNode.getProjectIds());
+									countyChildren.add(townNode);
+								}
+								countyNode.setChildNum(countyChildren.stream().mapToLong(SgProjectTreeVO::getChildNum).sum());
+								countyNode.setChildList(countyChildren);
+								countyNode.setProjectIds(countyIds);
+								cityIds.addAll(countyIds);
+								cityChildren.add(countyNode);
+							}
+							cityNode.setChildNum(cityChildren.stream().mapToLong(SgProjectTreeVO::getChildNum).sum());
+							cityNode.setChildList(cityChildren);
+							cityNode.setProjectIds(cityIds);
+							lotIds.addAll(cityIds);
+							lotChildren.add(cityNode);
+						}
+						lotNode.setChildNum(lotChildren.stream().mapToLong(SgProjectTreeVO::getChildNum).sum());
+						lotNode.setChildList(lotChildren);
+						lotNode.setProjectIds(lotIds);
+						provinceChildren.add(lotNode);
+					}
+					provinceNode.setChildNum(provinceChildren.stream().mapToLong(SgProjectTreeVO::getChildNum).sum());
+					provinceNode.setChildList(provinceChildren);
+					tree.add(provinceNode);
+				}
+			List<SgProjectTreeVO> childList = tree.get(0).getChildList();
+			List<SgProjectTreeVO> collect = childList.stream()
+				.sorted(Comparator.comparing(s -> {
+					String scode = s.getRegionName();
+					if (scode.equals("第一标段")) {
+						return 1;
+					} else if (scode.equals("第二标段")) {
+						return 2;
+					} else if (scode.equals("第三标段")) {
+						return 3;
+					} else if (scode.equals("第四标段")) {
+						return 4;
+					} else if (scode.equals("第五标段")) {
+						return 5;
+					} else {
+						return Integer.MAX_VALUE;
+					}
+				}))
+				.collect(Collectors.toList());
+			tree.get(0).setChildList(collect);
+			return tree;
+
+		}
+		return new ArrayList<>();
+	}
+
+	private void setAdCode(ProjectSearchDTO dto) {
+		String deptId = AuthUtil.getDeptId();
+		Long roleId = sgProgressReportService.getRoleId();
+		if(!roleId.equals(1811657352658042882L)){
+			dto.setAdCode(deptId);
+		}
+	}
+
+	@Override
+	public IPage<ResVO> resList(IPage<ResVO> page, ProjectSearchDTO dto) {
+		List<String> sgCodeByUser = getSgCodeByUser();
+		dto.setSgCodeS(sgCodeByUser);
+		return page.setRecords(baseMapper.resList(page,dto));
+	}
+
 }

--
Gitblit v1.9.3