From 402ff1aeac9bb33e6d8ff04913cbf1b0364df2a6 Mon Sep 17 00:00:00 2001
From: shenyijian <1178253012@qq.com>
Date: Tue, 18 Jun 2024 13:55:03 +0800
Subject: [PATCH] 湖北水库:施工:APP项目统计、项目进度列表

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProgressReportServiceImpl.java |   70 +++++++++++++++++++----------------
 1 files changed, 38 insertions(+), 32 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProgressReportServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProgressReportServiceImpl.java
index fad2468..0c21022 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProgressReportServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProgressReportServiceImpl.java
@@ -4,6 +4,7 @@
 import cn.gistack.sm.sg.DTO.ApprovalDTO;
 import cn.gistack.sm.sg.DTO.ProjectSearchDTO;
 import cn.gistack.sm.sg.VO.SgProgressReportVO;
+import cn.gistack.sm.sg.VO.SgStepReportVO;
 import cn.gistack.sm.sg.mapper.*;
 import cn.gistack.sm.sg.service.SgProgressReportService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -69,9 +70,10 @@
 		Long gxStepId = sgProgressReportDO.getGxStepId();
 		List<SgGxStepDO> list = sgGxStepMapper.selectByGxInfoId(gxDeviceId);
 		SgGxStepDO sgGxStepDO = sgGxStepMapper.selectById(gxStepId);
-		LambdaQueryChainWrapper<SgProgressReportDO> wrapper = new LambdaQueryChainWrapper<>(sgProgressReportMapper)
-			.eq(SgProgressReportDO::getGxStepId, gxStepId).eq(SgProgressReportDO::getGxDeviceId,gxDeviceId);
-		if ( sgProgressReportMapper.selectOne(wrapper)!=null){
+		QueryWrapper<SgProgressReportDO> wrapper = new QueryWrapper<>();
+		wrapper.eq("gx_step_id", gxStepId).eq("gx_device_id",gxDeviceId);
+		List<SgProgressReportDO> sgProgressReportDOS = sgProgressReportMapper.selectList(wrapper);
+		if ( sgProgressReportDOS!=null && sgProgressReportDOS.size()>0){
 			throw new ServiceException("此工序已存在审批!");
 		}
 		for (SgGxStepDO gxStepDO : list) {
@@ -92,7 +94,7 @@
 		List<SgGxConfigDO> sgGxConfigDOS = new LambdaQueryChainWrapper<>(sgGxConfigMapper)
 			.eq(SgGxConfigDO::getGxDeviceType, deviceType).eq(SgGxConfigDO::getGxStepId, gxStepId).list();
 		List<String> roIds = sgGxConfigDOS.stream().map(SgGxConfigDO::getRoleId).collect(Collectors.toList());
-		List<SgProjectPersonConfigDO> personConfigDOS = new LambdaQueryChainWrapper<>(sgProjectPersonConfigMapper).in(SgProjectPersonConfigDO::getRoldId, roIds).list();
+		List<SgProjectPersonConfigDO> personConfigDOS = new LambdaQueryChainWrapper<>(sgProjectPersonConfigMapper).eq(SgProjectPersonConfigDO::getProgramId,sgProgressReportDO.getProframId()).in(SgProjectPersonConfigDO::getRoldId, roIds).list();
 		Map<Long, Long> userMap = personConfigDOS.stream().collect(Collectors.toMap(SgProjectPersonConfigDO::getRoldId, SgProjectPersonConfigDO::getUserId));
 		Date now = DateUtil.now();
 		sgReportUserMapper.insert(SgReportUserDO.builder().reportId(sgProgressReportDO.getId()).userId(sgProgressReportDO.getReportUser()).approvalContent("提交审批").approvalStatus(0).approvalOrder(0).approvalTime(now).build());
@@ -122,6 +124,8 @@
 		SgProgressReportVO sgProgressReportVO = sgProgressReportMapper.queryById(id);
 		List<SgReportUserDO> list = new LambdaQueryChainWrapper<>(sgReportUserMapper).eq(SgReportUserDO::getReportId, id).orderByAsc(SgReportUserDO::getApprovalTime).list();
 		sgProgressReportVO.setSgReportUserDOS(list);
+		List<SgStepReportVO> sgStepReportVOS = sgProgressReportMapper.selectByDeviceId(sgProgressReportVO.getGxDeviceId());
+		sgProgressReportVO.setSgStepReportVOS(sgStepReportVOS);
 		return sgProgressReportVO;
 	}
 
@@ -196,44 +200,46 @@
 	public void  setProgramAndDeviceStatus(){
 		//查询所有的项目
 		List<SgProjectInfoDO> sgProjectInfoDOS = sgProjectInfoMapper.selectList(null);
+		if(sgProjectInfoDOS!=null&& !sgProjectInfoDOS.isEmpty()) {
+			for (SgProjectInfoDO project : sgProjectInfoDOS) {
+				QueryWrapper<SgDeviceDO> queryWrapper = new QueryWrapper<>();
+				queryWrapper.eq("program_id", project.getId());
+				//所有设备
+				List<SgDeviceDO> sgDeviceDOS = sgDeviceMapper.selectList(queryWrapper);
+				//项目下完成的设备数
+				int deviceFinishCount = 0;
+				if(!sgProjectInfoDOS.isEmpty()) {
+					for (SgDeviceDO sgDeviceDO : sgDeviceDOS) {
 
-		for (SgProjectInfoDO project: sgProjectInfoDOS){
-			QueryWrapper<SgDeviceDO> queryWrapper = new QueryWrapper<>();
-			queryWrapper.eq("program_id",project.getId());
-			//所有设备
-			List<SgDeviceDO> sgDeviceDOS = sgDeviceMapper.selectList(queryWrapper);
-			//项目下完成的设备数
-			int deviceFinishCount=0;
-			for (SgDeviceDO sgDeviceDO: sgDeviceDOS){
+						//设备的工序
+						List<SgDeviceGxStepDO> sgDeviceGxStepDOs = sgGxStepMapper.getDeviceGXList(sgDeviceDO.getId());
 
-				//设备的工序
-				List<SgDeviceGxStepDO> sgDeviceGxStepDOs = sgGxStepMapper.getDeviceGXList(sgDeviceDO.getId());
+						if (sgDeviceGxStepDOs != null) {
+							int countStatus = 0;
+							for (SgDeviceGxStepDO sgDeviceGxStepDO : sgDeviceGxStepDOs) {
+								countStatus = +sgDeviceGxStepDO.getStatus();
 
-				if(sgDeviceGxStepDOs!=null){
-					int countStatus=0;
-					for (SgDeviceGxStepDO sgDeviceGxStepDO: sgDeviceGxStepDOs){
-						countStatus=+sgDeviceGxStepDO.getStatus();
+							}
+							int size = sgDeviceGxStepDOs.size();
+							if (countStatus != 0 && (size * 2) / countStatus == 1) {
+								//如果设备下全部工序审核完成
+								sgDeviceDO.setStatus(2);
+								sgDeviceMapper.updateById(sgDeviceDO);
+								deviceFinishCount++;
+							}
 
+
+						}
 					}
-					int size = sgDeviceGxStepDOs.size();
-					if(countStatus!=0&&(size*2)/countStatus==1){
-						//如果设备下全部工序审核完成
-						sgDeviceDO.setStatus(2);
-						sgDeviceMapper.updateById(sgDeviceDO);
-						deviceFinishCount++;
+					if (deviceFinishCount == sgDeviceDOS.size()) {
+						//如果项目下的设备下全部完成
+						project.setStatus(2);
+						sgProjectInfoMapper.updateById(project);
 					}
-
-
 				}
-			}
 
-			if(deviceFinishCount==sgDeviceDOS.size()){
-				//如果项目下的设备下全部完成
-				project.setStatus(2);
-				sgProjectInfoMapper.updateById(project);
 			}
 		}
-
 
 	}
 

--
Gitblit v1.9.3