From bec2f0453d651e8b567ba14c596eca452526a2bd Mon Sep 17 00:00:00 2001
From: 16639036659 <577530412@qq.com>
Date: 星期一, 31 十月 2022 16:15:15 +0800
Subject: [PATCH] 返回隐患信息

---
 src/main/resources/mybatis/doublePrevention/PreventRiskControlMeasureMapper.xml                         |    1 
 src/main/java/com/ruoyi/project/tr/hiddenDangerCheck/controller/DangerReportController.java             |   29 ++++++++++++++
 src/main/java/com/ruoyi/doublePrevention/service/impl/RiskServiceImpl.java                              |    9 ++++
 src/main/resources/mybatis/doublePrevention/PreventRiskDangerInfoMapper.xml                             |    6 +++
 src/main/java/com/ruoyi/doublePrevention/service/baseService/impl/PreventRiskDangerInfoServiceImpl.java |    9 ++++
 src/main/java/com/ruoyi/doublePrevention/repository/PreventRiskDangerInfoRepository.java                |    4 ++
 src/main/java/com/ruoyi/doublePrevention/service/RiskService.java                                       |    9 ++--
 src/main/java/com/ruoyi/doublePrevention/service/baseService/PreventRiskDangerInfoService.java          |    4 ++
 8 files changed, 64 insertions(+), 7 deletions(-)

diff --git a/src/main/java/com/ruoyi/doublePrevention/repository/PreventRiskDangerInfoRepository.java b/src/main/java/com/ruoyi/doublePrevention/repository/PreventRiskDangerInfoRepository.java
index 5ec9b00..c0cd6c5 100644
--- a/src/main/java/com/ruoyi/doublePrevention/repository/PreventRiskDangerInfoRepository.java
+++ b/src/main/java/com/ruoyi/doublePrevention/repository/PreventRiskDangerInfoRepository.java
@@ -43,4 +43,8 @@
      * 修改上报的数据的姿态
      */
     PreventRiskDangerInfo updateDangerInfoReportStatus(HandlerReportParam handlerReportParam);
+    /**
+     * 查询隐患附属表信息
+     */
+    PreventRiskDangerInfo getByHiddenDangerId(Long id);
 }
diff --git a/src/main/java/com/ruoyi/doublePrevention/service/RiskService.java b/src/main/java/com/ruoyi/doublePrevention/service/RiskService.java
index ccc7fd5..9b4b203 100644
--- a/src/main/java/com/ruoyi/doublePrevention/service/RiskService.java
+++ b/src/main/java/com/ruoyi/doublePrevention/service/RiskService.java
@@ -1,9 +1,6 @@
 package com.ruoyi.doublePrevention.service;
 
-import com.ruoyi.doublePrevention.entity.PreventRiskCheckUnit;
-import com.ruoyi.doublePrevention.entity.PreventRiskControlMeasure;
-import com.ruoyi.doublePrevention.entity.PreventRiskEvent;
-import com.ruoyi.doublePrevention.entity.PreventRiskJobAndMeasure;
+import com.ruoyi.doublePrevention.entity.*;
 import com.ruoyi.doublePrevention.entity.dto.req.*;
 import com.ruoyi.doublePrevention.entity.dto.resp.*;
 import com.ruoyi.doublePrevention.repository.param.PreventPointAndMeasureParams;
@@ -176,4 +173,8 @@
      * 查询管控措施信息
      */
     PreventRiskControlMeasure getRiskControlMeasureInfo(Long checkPointId);
+    /**
+     * 查询隐患附属表信息
+     */
+    PreventRiskDangerInfo getDangerInfoById(Long id);
 }
diff --git a/src/main/java/com/ruoyi/doublePrevention/service/baseService/PreventRiskDangerInfoService.java b/src/main/java/com/ruoyi/doublePrevention/service/baseService/PreventRiskDangerInfoService.java
index 8377d9b..1014307 100644
--- a/src/main/java/com/ruoyi/doublePrevention/service/baseService/PreventRiskDangerInfoService.java
+++ b/src/main/java/com/ruoyi/doublePrevention/service/baseService/PreventRiskDangerInfoService.java
@@ -43,4 +43,8 @@
      * 修改上报的数据的姿态
      */
     PreventRiskDangerInfo updateDangerInfoReportStatus(HandlerReportParam handlerReportParam);
+    /**
+     * 查询隐患附属表信息
+     */
+    PreventRiskDangerInfo getByHiddenDangerId(Long id);
 }
diff --git a/src/main/java/com/ruoyi/doublePrevention/service/baseService/impl/PreventRiskDangerInfoServiceImpl.java b/src/main/java/com/ruoyi/doublePrevention/service/baseService/impl/PreventRiskDangerInfoServiceImpl.java
index daaa09f..d6f963a 100644
--- a/src/main/java/com/ruoyi/doublePrevention/service/baseService/impl/PreventRiskDangerInfoServiceImpl.java
+++ b/src/main/java/com/ruoyi/doublePrevention/service/baseService/impl/PreventRiskDangerInfoServiceImpl.java
@@ -49,7 +49,13 @@
     public int updateDangerInfoState(PreventRiskDangerInfo dangerInfo) {
         return preventRiskDangerInfoRepository.updateDangerInfoState(dangerInfo);
     }
-
+    /**
+     * 查询隐患附属表信息
+     */
+    @Override
+    public PreventRiskDangerInfo getByHiddenDangerId(Long id) {
+        return  preventRiskDangerInfoRepository.getByHiddenDangerId(id);
+    }
 
     /**
      * @description 统计时间段内所有、死亡、重伤、轻伤的隐患数量
@@ -73,4 +79,5 @@
     public PreventRiskDangerInfo updateDangerInfoReportStatus(HandlerReportParam handlerReportParam) {
         return preventRiskDangerInfoRepository.updateDangerInfoReportStatus(handlerReportParam);
     }
+
 }
diff --git a/src/main/java/com/ruoyi/doublePrevention/service/impl/RiskServiceImpl.java b/src/main/java/com/ruoyi/doublePrevention/service/impl/RiskServiceImpl.java
index 2d97036..f41c0fd 100644
--- a/src/main/java/com/ruoyi/doublePrevention/service/impl/RiskServiceImpl.java
+++ b/src/main/java/com/ruoyi/doublePrevention/service/impl/RiskServiceImpl.java
@@ -1316,7 +1316,14 @@
         return riskControlMeasureService.getPreventRiskControlMeasureById(unitByBaseCheckPointId.getControlMeasureId());
     }
 
-
+    /**
+     * 查询隐患附属表信息
+     */
+    @Override
+    public PreventRiskDangerInfo getDangerInfoById(Long id) {
+        PreventRiskDangerInfo dangerInfobyHiddenDangerId = preventRiskDangerInfoService.getByHiddenDangerId(id);
+        return dangerInfobyHiddenDangerId;
+    }
     //    /**
 //     * 全流程隐患上报-附属表信息插入
 //     * */
diff --git a/src/main/java/com/ruoyi/project/tr/hiddenDangerCheck/controller/DangerReportController.java b/src/main/java/com/ruoyi/project/tr/hiddenDangerCheck/controller/DangerReportController.java
index c132bab..ec626b0 100644
--- a/src/main/java/com/ruoyi/project/tr/hiddenDangerCheck/controller/DangerReportController.java
+++ b/src/main/java/com/ruoyi/project/tr/hiddenDangerCheck/controller/DangerReportController.java
@@ -5,6 +5,7 @@
 import com.ruoyi.common.utils.DateUtils;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.security.ShiroUtils;
+import com.ruoyi.doublePrevention.entity.PreventRiskDangerInfo;
 import com.ruoyi.doublePrevention.service.RiskService;
 import com.ruoyi.framework.aspectj.lang.annotation.Log;
 import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
@@ -19,6 +20,7 @@
 import com.ruoyi.project.tr.hiddenDangerCheckPoint.service.IHiddenDangerCheckPointService;
 import com.ruoyi.project.tr.hiddenTroubleType.domain.HiddenTroubleType;
 import com.ruoyi.project.tr.hiddenTroubleType.service.IHiddenTroubleTypeService;
+import org.apache.commons.lang3.ObjectUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Controller;
 import org.springframework.transaction.annotation.Transactional;
@@ -91,6 +93,7 @@
         hiddenDangerCheckPoint.setJudgeQueryByUserIdList(userIdList);//隐患整改人ID 为登陆账号companyId下的userId的
         startPage();
         List<HiddenDangerCheckPoint> list = hiddenDangerCheckPointService.selectHiddenDangerCheckPointList(hiddenDangerCheckPoint);
+
         return getDataTable(list);
     }
 
@@ -107,7 +110,22 @@
         // 第二:1.隐患上报创建人(register_user_id) 或者 2.(判定人(judge_user_id),report_status 不为null )------为本登录帐号userId的
         hiddenDangerCheckPoint.setJudgeQueryByUserId(getSysUser().getUserId());
         List<HiddenDangerCheckPoint> list = hiddenDangerCheckPointService.selectHiddenDangerCheckPointList(hiddenDangerCheckPoint);
-        return getDataTable(list);
+        List<HiddenDangerCheckPoint> resultList = new ArrayList<>();
+
+        for (HiddenDangerCheckPoint dangerCheckPoint : list) {
+            // todo-2022 修改前查询
+            PreventRiskDangerInfo dangerInfo = riskService.getDangerInfoById(dangerCheckPoint.getId());
+            if (ObjectUtils.isNotEmpty(dangerInfo)){
+                dangerCheckPoint.setHazardCode(dangerInfo.getHazardCode());
+                dangerCheckPoint.setDangerSrc(dangerInfo.getDangerSrc());
+                dangerCheckPoint.setDangerReason(dangerInfo.getDangerReason());
+                dangerCheckPoint.setHazardDangerType(dangerInfo.getHazardDangerType());
+                dangerCheckPoint.setDangerResult(dangerInfo.getDangerResult());
+            }
+
+            resultList.add(dangerCheckPoint);
+        }
+        return getDataTable(resultList);
     }
 
     /**
@@ -336,6 +354,15 @@
     @GetMapping("/editDangerReport/{id}")
     public String editDangerReport(@PathVariable("id") Long id, ModelMap mmap) {
         HiddenDangerCheckPoint hdcp = hiddenDangerCheckPointService.selectHiddenDangerCheckPointById(id);
+        // todo-2022 修改前查询
+        PreventRiskDangerInfo dangerInfo = riskService.getDangerInfoById(hdcp.getId());
+
+        hdcp.setHazardCode(dangerInfo.getHazardCode());
+        hdcp.setDangerSrc(dangerInfo.getDangerSrc());
+        hdcp.setDangerReason(dangerInfo.getDangerReason());
+        hdcp.setHazardDangerType(dangerInfo.getHazardDangerType());
+        hdcp.setDangerResult(dangerInfo.getDangerResult());
+
         mmap.put("hiddenDangerCheckPoint", hdcp);
 
         //获取所在公司人员信息
diff --git a/src/main/resources/mybatis/doublePrevention/PreventRiskControlMeasureMapper.xml b/src/main/resources/mybatis/doublePrevention/PreventRiskControlMeasureMapper.xml
index eba3771..fc87371 100644
--- a/src/main/resources/mybatis/doublePrevention/PreventRiskControlMeasureMapper.xml
+++ b/src/main/resources/mybatis/doublePrevention/PreventRiskControlMeasureMapper.xml
@@ -152,6 +152,7 @@
         select * from prevent_risk_control_measure
         where id = #{id} and delete_status = 0
     </select>
+
     <select id="getPreventRiskControlMeasureByControlMeasureCode" resultMap="BaseResultMap">
         select * from prevent_risk_control_measure
         <where>
diff --git a/src/main/resources/mybatis/doublePrevention/PreventRiskDangerInfoMapper.xml b/src/main/resources/mybatis/doublePrevention/PreventRiskDangerInfoMapper.xml
index bc09908..6c4c79e 100644
--- a/src/main/resources/mybatis/doublePrevention/PreventRiskDangerInfoMapper.xml
+++ b/src/main/resources/mybatis/doublePrevention/PreventRiskDangerInfoMapper.xml
@@ -101,6 +101,12 @@
             report_time = #{reportTime}
         where id = #{id}
     </select>
+
+<!--    PreventRiskDangerInfo getByHiddenDangerId(Long id);-->
+    <select id="getByHiddenDangerId" resultMap="BaseResultMap">
+        select * from prevent_risk_danger_info
+        where danger_check_point_id = #{id}
+    </select>
 </mapper>
 
 

--
Gitblit v1.9.2