From bf05d91fca1de52d144a4fc5c4cc89481d040aa9 Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期一, 18 五月 2026 11:27:05 +0800
Subject: [PATCH] 新增InfoID获取伦理审查发起详细信息挡口,获取捐献工作流新增7个状态字段数据

---
 ruoyi-common/src/main/java/com/ruoyi/common/utils/StringUtils.java                                     |    4 ++++
 ruoyi-common/src/main/java/com/ruoyi/common/utils/DateUtils.java                                       |    6 +++++-
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java                           |    4 ++++
 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java       |   16 ++++++++++------
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/WorkFlowVO.java                                |    2 +-
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java |   16 ++++++++++++++++
 ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml                 |    3 ++-
 7 files changed, 42 insertions(+), 9 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java
index 573b808..25237de 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java
@@ -100,6 +100,22 @@
     }
 
     /**
+     * 鑾峰彇浼︾悊瀹℃煡鍙戣捣璇︾粏淇℃伅
+     */
+    @ApiOperation("InfoID鑾峰彇浼︾悊瀹℃煡鍙戣捣璇︾粏淇℃伅")
+    @GetMapping(value = "/getInfoID")
+    public AjaxResult getInfoId(Long InfoId) {
+        QueryWrapper<ServiceEthicalreviewinitiate> ethicalreviewinitiateQueryWrapper=new QueryWrapper<>();
+        ethicalreviewinitiateQueryWrapper.eq("InfoId",InfoId);
+        ServiceEthicalreviewinitiate serviceEthicalreviewinitiate= serviceEthicalreviewinitiateService.getOne(ethicalreviewinitiateQueryWrapper);
+        QueryWrapper<ServiceEthicalreviewopinions> ethicalreviewopinionsWrapper=new QueryWrapper<>();
+        ethicalreviewopinionsWrapper.eq("nitiate_Id",serviceEthicalreviewinitiate.getId());
+        List<ServiceEthicalreviewopinions>  ethicalreviewopinionsList= serviceEthicalreviewopinionsService.list(ethicalreviewopinionsWrapper);
+        serviceEthicalreviewinitiate.setEthicalreviewopinionsList(ethicalreviewopinionsList);
+        return AjaxResult.success(serviceEthicalreviewinitiate);
+    }
+
+    /**
      * 鏂板浼︾悊瀹℃煡鍙戣捣
      */
     @ApiOperation("鏂板浼︾悊瀹℃煡鍙戣捣")
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/DateUtils.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/DateUtils.java
index 536cb3c..4e083cc 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/DateUtils.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/DateUtils.java
@@ -70,7 +70,11 @@
 
     public static final String parseDateToStr(final String format, final Date date)
     {
-        return new SimpleDateFormat(format).format(date);
+        if(date==null){
+            return "";
+        }else {
+            return new SimpleDateFormat(format).format(date);
+        }
     }
 
     public static final Date dateTime(final String format, final String ts)
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/StringUtils.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/StringUtils.java
index 4ca2bfc..06a1a31 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/StringUtils.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/StringUtils.java
@@ -531,4 +531,8 @@
     {
         return (T) obj;
     }
+
+    public static String nullTo1(Object s){
+        return s==null?"1":s.toString();
+    }
 }
\ No newline at end of file
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java
index 72973e5..8f71754 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java
@@ -640,4 +640,8 @@
     @Excel(name = "涓撳绫诲瀷")
     private String expertType;
 
+    @ApiModelProperty("浼︾悊瀹℃煡闄勪欢")
+    @Excel(name = "浼︾悊瀹℃煡闄勪欢")
+    private String  filePatch;
+
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/WorkFlowVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/WorkFlowVO.java
index 8a36398..664cb9e 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/WorkFlowVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/WorkFlowVO.java
@@ -39,7 +39,7 @@
      * 灏佽鍣ㄥ畼鍒嗛厤
      */
     @ApiModelProperty("灏佽鍣ㄥ畼鍒嗛厤")
-    Map<String, String> donateorgansService;
+    Map<String, Object> donateorgansService;
 
 
     /**
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java
index 3605a75..514758d 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java
@@ -304,6 +304,7 @@
         donatebaseinfo.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonatebaseinfo.getCreateTime()));
         donatebaseinfo.put("updatetime", serviceDonatebaseinfo.getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonatebaseinfo.getUpdateTime()) : "");
         donatebaseinfo.put("createperson", null);
+        donatebaseinfo.put("state",StringUtils.nullTo1(serviceDonatebaseinfo.getRecordstate()));
         if (StringUtils.isNotBlank(serviceDonatebaseinfo.getCreateBy())) {
             SysUser sysUser = sysUserMapper.selectUserByUserName(serviceDonatebaseinfo.getCreateBy());
             if (!ObjectUtils.isEmpty(sysUser)) {
@@ -333,6 +334,7 @@
                 medicalevaluation.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceMedicalevaluations.get(0).getCreateTime()));
                 medicalevaluation.put("updatetime", serviceMedicalevaluations.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceMedicalevaluations.get(0).getUpdateTime()) : null);
                 medicalevaluation.put("createperson", null);
+                medicalevaluation.put("state", StringUtils.nullTo1(StringUtils.nullTo1(serviceMedicalevaluations.get(0).getAssessState())));
                 if (StringUtils.isNotBlank(serviceMedicalevaluations.get(0).getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceMedicalevaluations.get(0).getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -365,6 +367,7 @@
                 relativesconfirmation.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceRelativesconfirmations.get(0).getCreateTime()));
                 relativesconfirmation.put("updatetime", serviceRelativesconfirmations.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceRelativesconfirmations.get(0).getUpdateTime()) : "");
                 relativesconfirmation.put("createperson", null);
+                relativesconfirmation.put("state", StringUtils.nullTo1(serviceRelativesconfirmations.get(0).getState()));
                 if (StringUtils.isNotBlank(serviceRelativesconfirmations.get(0).getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceRelativesconfirmations.get(0).getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -397,6 +400,7 @@
                 donateflowcharts.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceEthicalreviewopinionsList.get(0).getCreateTime()));
                 donateflowcharts.put("updatetime", serviceEthicalreviewopinionsList.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceEthicalreviewopinionsList.get(0).getUpdateTime()) : "");
                 donateflowcharts.put("createperson", null);
+                donateflowcharts.put("state", StringUtils.nullTo1(serviceEthicalreviewopinionsList.get(0).getReceiveStatus()));
                 if (StringUtils.isNotBlank(serviceEthicalreviewopinionsList.get(0).getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceEthicalreviewopinionsList.get(0).getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -420,7 +424,7 @@
         map1.setDonateflowcharts(donateflowcharts);
 
         //灏佽鍣ㄥ畼鍒嗛厤
-        Map<String, String> donateorgansService = new HashMap<>();
+        Map<String, Object> donateorgansService = new HashMap<>();
        // if (serviceDonatebaseinfo.getWorkflow() >= 4) {
             ServiceDonateorgan serviceDonateorgan = new ServiceDonateorgan();
             serviceDonateorgan.setInfoid(id);
@@ -429,8 +433,8 @@
             if (!CollectionUtils.isEmpty(serviceDonateorgans)) {
                 donateorgansService.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonateorgans.get(0).getCreateTime()));
                 donateorgansService.put("updatetime", serviceDonateorgans.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonateorgans.get(0).getUpdateTime()) : "");
-
                 donateorgansService.put("createperson", null);
+                donateorgansService.put("state", StringUtils.nullTo1(serviceDonateorgans.get(0).getAllocationstatus()));
                 if (StringUtils.isNotBlank(serviceDonateorgans.get(0).getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceDonateorgans.get(0).getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -460,8 +464,8 @@
             if (!ObjectUtils.isEmpty(serviceDonationwitness)) {
                 donationwitness.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonationwitness.getCreateTime()));
                 donationwitness.put("updatetime", serviceDonationwitness.getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonationwitness.getUpdateTime()) : "");
-
                 donationwitness.put("createperson", null);
+                donationwitness.put("state", StringUtils.nullTo1(serviceDonationwitness.getWitnessState()));
                 if (StringUtils.isNotBlank(serviceDonationwitness.getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceDonationwitness.getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -493,8 +497,8 @@
             if (!CollectionUtils.isEmpty(serviceDonatecompletioninfos)) {
                 donatecompletioninfo.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonatecompletioninfos.get(0).getCreateTime()));
                 donatecompletioninfo.put("updatetime", serviceDonatecompletioninfos.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDonatecompletioninfos.get(0).getUpdateTime()) : "");
-
                 donatecompletioninfo.put("createperson", null);
+                donatecompletioninfo.put("state", StringUtils.nullTo1(serviceDonatecompletioninfos.get(0).getCompleteState()));
                 if (StringUtils.isNotBlank(serviceDonatecompletioninfos.get(0).getCreateBy())) {
                     SysUser sysUser = sysUserMapper.selectUserByUserName(serviceDonatecompletioninfos.get(0).getCreateBy());
                     if (!ObjectUtils.isEmpty(sysUser)) {
@@ -524,8 +528,8 @@
         if(donatemaintenanceEntityList.size()>0){
             donatemaintenance.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", donatemaintenanceEntityList.get(0).getCreateTime()));
             donatemaintenance.put("updatetime", donatemaintenanceEntityList.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", donatemaintenanceEntityList.get(0).getUpdateTime()) : "");
-
             donatemaintenance.put("createperson", null);
+            donatemaintenance.put("state", StringUtils.nullTo1(donatemaintenanceEntityList.get(0).getState()));
             if (StringUtils.isNotBlank(donatemaintenanceEntityList.get(0).getCreateBy())) {
                 SysUser sysUser = sysUserMapper.selectUserByUserName(donatemaintenanceEntityList.get(0).getCreateBy());
                 if (!ObjectUtils.isEmpty(sysUser)) {
@@ -552,8 +556,8 @@
         if(serviceDeathinfoList.size()>0){
             deathinfo.put("createtime", DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", serviceDeathinfoList.get(0).getCreateTime()));
             deathinfo.put("updatetime", serviceDeathinfoList.get(0).getUpdateTime() != null ? DateUtils.parseDateToStr("yyyy-MM-dd HH:mm:ss", donatemaintenanceEntityList.get(0).getUpdateTime()) : "");
-
             deathinfo.put("createperson", null);
+            deathinfo.put("state", StringUtils.nullTo1(serviceDeathinfoList.get(0).getState()));
             if (StringUtils.isNotBlank(serviceDeathinfoList.get(0).getCreateBy())) {
                 SysUser sysUser = sysUserMapper.selectUserByUserName(serviceDeathinfoList.get(0).getCreateBy());
                 if (!ObjectUtils.isEmpty(sysUser)) {
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
index 7a6a1ee..d2bb8ae 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
@@ -141,13 +141,14 @@
         service_ethicalreviewopinions.start_time,
         service_ethicalreviewopinions.end_time,
         service_ethicalreviewopinions.expert_type,
+        c.file_patch,
         service_ethicalreviewopinions.sigin as sigin
         FROM   service_donatebaseinfo
         LEFT JOIN  service_ethicalreviewopinions
         ON service_donatebaseinfo.ID = service_ethicalreviewopinions.InfoID
         LEFT JOIN base_organization ON
         base_organization.OrganizationID = service_donatebaseinfo.TreatmentHospitalNo
-
+        left join service_ethicalreviewinitiate c on c.InfoID=service_donatebaseinfo.id
         <where>
             service_donatebaseinfo.del_flag=0
             and service_ethicalreviewopinions.del_flag=0

--
Gitblit v1.9.3