From abde38d6baba3b50df5e39daba87a93c372e0675 Mon Sep 17 00:00:00 2001
From: gonglilong <328255720@qq.com>
Date: Fri, 13 Sep 2024 19:03:13 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/jtdev' into jtdev

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java |  365 +++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 334 insertions(+), 31 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 8b43a80..275f281 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
@@ -10,21 +10,18 @@
 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 java.math.BigDecimal;
-import java.math.MathContext;
 import java.math.RoundingMode;
 import java.util.*;
 import java.util.function.Function;
@@ -52,18 +49,100 @@
 	private SgGxStepMapper sgGxStepMapper;
 
 	@Override
-	public IPage<SgProjectInfoDO> queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO) {
-		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));
+	public Object queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO) {
+		List<String> sgCodeS = getSgCodeByUser();
+		searchDTO.setSgCodeS(sgCodeS);
+		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()));
+				});
+			}
+			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()));
+				});
+			}
 			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 page.setRecords(sgProjectInfoDOS);
+			return sgProjectInfoDOS;
+		}
+
 	}
 
+	/**
+	 * 获取用户姓名
+	 * @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;
+	}
+
+	/**
+	 * 获取当前用户的工程编码
+	 */
+	public List<String> getSgCodeByUser(){
+		Long userId = AuthUtil.getUserId();
+		String sgCode =  sgProjectInfoMapper.getSgCodeByUser(userId.toString());
+		if (StringUtils.isNotBlank(sgCode)){
+			List<String> list = List.of(sgCode.split(","));
+			return list;
+		}
+		return null;
+	}
 	/**
 	 * 获取项目及项目下设备及设备下工序进度
 	 * @param searchDTO
@@ -131,7 +210,7 @@
 						SgDeviceDO sgDeviceDO = new SgDeviceDO();
 						sgDeviceDO.setId(dId);
 						sgDeviceDO.setDeviceName(deList.get(0).getDeviceName());
-						List<SgGxStepDO> stepDOS = deList.stream().filter(s->s.getReportStatus()==null || s.getReportStatus()!=4).map(s -> SgGxStepDO.builder().id(s.getStepId()).gxStepNum(s.getGxStepNum()).gxStepName(s.getGxStepName()).deviceId(s.getDId()).approvalStatus(s.getReportStatus()).build()).collect(Collectors.toList());
+						List<SgGxStepDO> stepDOS = deList.stream().filter(s -> s.getReportStatus() == null || (s.getReportStatus() != 4 && !(s.getReportStatus() == 3 && s.getResubmit() != 0))).map(s -> SgGxStepDO.builder().id(s.getStepId()).gxStepNum(s.getGxStepNum()).gxStepName(s.getGxStepName()).deviceId(s.getDId()).approvalStatus(s.getReportStatus()).build()).collect(Collectors.toList());
 						List<SgGxStepDO> stepOver = stepDOS.stream().filter(s -> s.getApprovalStatus() != null && s.getApprovalStatus() == 2).collect(Collectors.toList());
 						BigDecimal stepSize = BigDecimal.valueOf(stepDOS.size());
 						BigDecimal stepOverSize = BigDecimal.ZERO;
@@ -210,31 +289,38 @@
 	@Override
 	public IPage<SgProjectInfoVO> progressPage(IPage<SgProjectInfoVO> page, ProjectSearchDTO 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) {
+		List<String> sgCodeS = getSgCodeByUser();
+		searchDTO.setSgCodeS(sgCodeS);
 		return sgProjectInfoMapper.queryPageList(null,searchDTO);
 	}
 
@@ -264,22 +350,146 @@
 	public List<SgStatisProVO> getsgStatisticsList(String code) {
 		AttAdBase ywxtAdDetail = iAttAdBaseService.getYwxtAdDetail(code);
 		List<SgStatisProVO> sgStatisProVOS;
-
-
 		//片区
 		if (ywxtAdDetail == null) {
 			sgStatisProVOS = sgProjectInfoMapper.getsgStatisticsZero(code);
+			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);
+			sgStatisProVOS = getSgStatisProVOS(sgStatisProVOS);
+			setDeviceTypes(sgStatisProVOS);
 			updateProjectProgress(sgStatisProVOS, ywxtAdDetail.getPAdCode(), ywxtAdDetail.getPAdName(), "0");
 		} else {//区县
 			sgStatisProVOS = sgProjectInfoMapper.getsgStatisticsList(code);
+			setDeviceTypes(sgStatisProVOS);
 			updateProjectProgress(sgStatisProVOS, ywxtAdDetail.getAdCode(), ywxtAdDetail.getAdName(), "3");
 		}
 		return sgStatisProVOS;
+	}
+
+	/**
+	 * 统计施工进度
+	 * @param 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) {
+				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;
+	}
+
+	/**
+	 * 统计设备类型开工率
+	 */
+	private 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)){
+					Map<String, SgStatisDeviceVO> map = deviceVOS.stream().collect(Collectors.toMap(SgStatisDeviceVO::getPType, Function.identity()));
+					//表面变形
+					SgStatisDeviceVO sg108 = map.get("sg108");
+					if (Objects.nonNull(sg108)){
+						Integer deviceCount = sg108.getDeviceCount();
+						Integer deviceStart = sg108.getDeviceStart();
+						sgOperatingRateVO.setSurfaceNum(deviceCount);
+						if (deviceCount != 0){
+							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
+							sgOperatingRateVO.setSeepageProgress(getBigDecimalPercent(divide));
+						}else {
+							sgOperatingRateVO.setSeepageProgress("0");
+						}
+					}
+					//视频
+					SgStatisDeviceVO sg104 = map.get("sg104");
+					if (Objects.nonNull(sg104)){
+						Integer deviceCount = sg104.getDeviceCount();
+						Integer deviceStart = sg104.getDeviceStart();
+						sgOperatingRateVO.setVideoNum(deviceCount);
+						if (deviceCount != 0){
+							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
+							sgOperatingRateVO.setVideoProgress(getBigDecimalPercent(divide));
+						}else {
+							sgOperatingRateVO.setVideoProgress("0");
+						}
+					}
+					//渗压
+					SgStatisDeviceVO sg101 = map.get("sg101");
+					if (Objects.nonNull(sg101)){
+						Integer deviceCount = sg101.getDeviceCount();
+						Integer deviceStart = sg101.getDeviceStart();
+						sgOperatingRateVO.setTransNum(deviceCount);
+						if (deviceCount != 0){
+							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
+							sgOperatingRateVO.setTransProgress(getBigDecimalPercent(divide));
+						}else {
+							sgOperatingRateVO.setTransProgress("0");
+						}
+					}
+					//渗流
+					SgStatisDeviceVO sg102 = map.get("sg102");
+					if (Objects.nonNull(sg102)){
+						Integer deviceCount = sg102.getDeviceCount();
+						Integer deviceStart = sg102.getDeviceStart();
+						sgOperatingRateVO.setSeepageNum(deviceCount);
+						if (deviceCount != 0){
+							BigDecimal divide = BigDecimal.valueOf(deviceStart).divide(BigDecimal.valueOf(deviceCount), 2, BigDecimal.ROUND_UP);
+							sgOperatingRateVO.setSeepageProgress(getBigDecimalPercent(divide));
+						}else {
+							sgOperatingRateVO.setSeepageProgress("0");
+						}
+					}
+					}
+					result.put(proIds,sgOperatingRateVO);
+				}
+			}
+		}
+		return result;
 	}
 
 	private void updateProjectProgress(List<SgStatisProVO> sgStatisProVOS, String pcode, String pname, String adGrad) {
@@ -372,7 +582,7 @@
 		BigDecimal percentage = bigDecimal.multiply(new BigDecimal("100"));
 		// 如果不需要保留小数位,可以设置一个scale为0
 		BigDecimal percentageRounded = percentage.setScale(0, RoundingMode.HALF_UP);
-		return percentageRounded+"%";
+		return percentageRounded.toString();
 	}
 
 	@Override
@@ -380,7 +590,7 @@
 		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());
@@ -402,8 +612,15 @@
 		QueryWrapper<SgProgressReportDO> queryWrapper = new QueryWrapper<>();
 		queryWrapper.eq("gx_step_id", stepIdForNull)
 			.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());
@@ -424,4 +641,90 @@
 
 	}
 
+
+	@Override
+	public List<SgProjectTreeVO> projectTree(ProjectSearchDTO dto) {
+		List<String> sgCodeS = getSgCodeByUser();
+		dto.setSgCodeS(sgCodeS);
+		List<SgProjectTreeVO> list = 	sgProjectInfoMapper.projectTree(dto);
+		if (CollectionUtils.isNotEmpty(list)){
+			// 按省、片区、市、县、乡镇分组
+			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);
+				}
+				return tree;
+		}
+		return new ArrayList<>();
+	}
+
 }

--
Gitblit v1.9.3