From 52df965c9cbaa015520b4379393a0041eb9ae8da Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 23 二月 2024 18:46:36 +0800
Subject: [PATCH] 代码提交

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java         |   34 +++-
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java |   30 +---
 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundflowrule.java                          |   44 +++++-
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/EthicalReviewVO.java                           |    2 
 ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml                       |    3 
 ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml                 |  115 ++++++++++++-------
 ruoyi-project/src/main/resources/mapper/project/ServiceFundflowruleMapper.xml                          |    5 
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java                  |   40 +++++-
 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundflowruleServiceImpl.java         |   41 +++---
 ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml                     |    7 
 ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml                        |    1 
 ruoyi-project/src/main/resources/mapper/project/ServiceDonatecompletioninfoMapper.xml                  |    3 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/MedicalEvaluationVO.java                       |    2 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationCompletionVO.java                      |    6 +
 ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml                 |    3 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationWitnessVO.java                         |    3 
 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/RelativeConfirmationVO.java                    |    2 
 17 files changed, 225 insertions(+), 116 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
index 4b3a805..c2e4a72 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java
@@ -1,29 +1,21 @@
 package com.ruoyi.web.controller.project;
 
-import java.util.Arrays;
-import java.util.List;
-
-import com.ruoyi.common.annotation.NotRepeatCommit;
-import com.ruoyi.project.domain.vo.EthicalReviewVO;
-import org.springframework.security.access.prepost.PreAuthorize;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.PutMapping;
-import org.springframework.web.bind.annotation.DeleteMapping;
-import org.springframework.web.bind.annotation.PathVariable;
-import org.springframework.web.bind.annotation.RequestBody;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
 import com.ruoyi.common.annotation.Log;
+import com.ruoyi.common.annotation.NotRepeatCommit;
 import com.ruoyi.common.annotation.RepeatSubmit;
 import com.ruoyi.common.core.controller.BaseController;
 import com.ruoyi.common.core.domain.AjaxResult;
-import com.ruoyi.common.enums.BusinessType;
-import com.ruoyi.project.domain.ServiceEthicalreviewopinions;
-import com.ruoyi.project.service.IServiceEthicalreviewopinionsService;
-import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.common.core.page.TableDataInfo;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.project.domain.ServiceEthicalreviewopinions;
+import com.ruoyi.project.domain.vo.EthicalReviewVO;
+import com.ruoyi.project.service.IServiceEthicalreviewopinionsService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.Arrays;
+import java.util.List;
 
 /**
  * 浼︾悊瀹℃煡涓撳鎰忚Controller
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
index baa29cf..08cc619 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
@@ -10,6 +10,7 @@
 import com.ruoyi.common.constant.HttpStatus;
 import com.ruoyi.common.core.controller.BaseController;
 import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.core.domain.entity.SysDept;
 import com.ruoyi.common.core.domain.entity.SysUser;
 import com.ruoyi.common.core.domain.model.LoginUser;
 import com.ruoyi.common.core.page.TableDataInfo;
@@ -25,6 +26,7 @@
 import com.ruoyi.project.domain.vo.*;
 import com.ruoyi.project.mapper.ServiceFunddetailMapper;
 import com.ruoyi.project.service.*;
+import com.ruoyi.system.service.ISysDeptService;
 import com.ruoyi.system.service.ISysPostService;
 import freemarker.template.Configuration;
 import freemarker.template.Template;
@@ -100,6 +102,9 @@
 
     @Autowired
     private TransactionDefinition transactionDefinition;
+
+    @Autowired
+    private ISysDeptService sysDeptService;
 
     public ServiceFundController() {
         configuration = new Configuration();
@@ -527,11 +532,11 @@
                 }
                 FlowLevel = FlowLevel + 1;
 
-                if (serviceFund.getFlowlevel() == 1 && serviceFund.getBackflowlevel() == 100) {
+                if (serviceFund.getFlowlevel() == Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1) && serviceFund.getBackflowlevel() == 100) {
                     log.info("璐㈠姟閫�鍥炲啀鎻愪氦锛屽嚭绾冲啀娆″鎵癸紝涔嬪悗鎻愪氦鍒拌储鍔�");
                     //璇存槑鏄储鍔¢��鍥炲啀鎻愪氦鐨�.闇�瑕佸嚭绾冲啀鐪嬩竴閬嶏紝娌¢棶棰樹箣鍚庯紝寰�鍒嗕韩琛ㄩ噷鏂板
 //                    serviceFundService.addFundSharedInfo(serviceFund.getId());
-                    serviceFund.setFlowlevel(3L);
+                    serviceFund.setFlowlevel(serviceFundflowrules.get(0).getTotallevel().longValue());
                     serviceFund.setFlowlevel(100L);
                     serviceFund.setRecordstatus(99);
                     serviceFundService.updateById(serviceFund);
@@ -648,6 +653,23 @@
         if (CollectionUtils.isEmpty(infoByInfoIdList)) {
             return toAjax(false);
         }
+
+        Long flowLavel = null;
+
+        LoginUser loginUser = getLoginUser();
+//        SysUser user = loginUser.getUser();
+//        //鏌ヨ褰撳墠鐢ㄦ埛鐨勭粍闀�
+//        SysDept sysDept = new SysDept();
+//        sysDept.setDeptId(loginUser.getDeptId());
+//        List<SysDept> sysDepts = sysDeptService.selectDeptList(sysDept);
+
+        //鏌ヨ蹇呭浜�
+        ServiceFundflowrule serviceFundflowrule = new ServiceFundflowrule();
+        serviceFundflowrule.setApplytype(serviceFund.getApplytype());
+        serviceFundflowrule.setMustAudite(1);
+        List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule);
+        log.info("fund蹇呭浜虹殑绛夌骇涓猴細{}", serviceFundflowrules.get(0).getFlowlevel());
+
         for (ServiceFund sf : infoByInfoIdList) {
             sf.setApplyTime(new Date());
             //濡傛灉绛変簬100锛岃鏄庡凡缁忚蛋鍒板尰闄㈣储鍔¢偅杈逛簡锛涜储鍔¢偅杈瑰彇鏁版嵁鏄粠鍒嗕韩琛ㄥ彇锛屾墍浠ワ紝杩欓噷鐩存帴寰�鍒嗕韩琛ㄩ噷娣诲姞鏁版嵁灏辫浜�
@@ -656,7 +678,7 @@
                 sf.setBackflowlevel(100);
 
                 //閫�鍥炲啀鎻愪氦锛岄渶瑕佸啀鍒板嚭绾抽偅閲�
-                sf.setFlowlevel(1L);
+                sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 sf.setRecordstatus(0);
                 serviceFundService.updateById(sf);
 
@@ -667,27 +689,25 @@
             } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 100) {
                 //璐㈠姟閫�鍥炵殑鏁版嵁鍐嶆彁浜わ紝鍒板嚭绾抽偅閲屾病鏈夎繃锛屽啀閫�鍥烇紝瀵艰嚧backflowlevel鏄�100,
                 //閫�鍥炲啀鎻愪氦锛岄渶瑕佸啀鍒板嚭绾抽偅閲�
-                sf.setFlowlevel(1L);
+                sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 sf.setRecordstatus(2);
                 serviceFundService.updateById(sf);
-            } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 2) {
+            } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() >= serviceFundflowrules.get(0).getFlowlevel()) {
                 //鑱傜閫�鍥炵殑锛屼篃闇�瑕佸厛鍒板嚭绾抽偅閲�
-                sf.setFlowlevel(1L);
+                sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 sf.setRecordstatus(2);
                 serviceFundService.updateById(sf);
             } else {
 
                 Integer TotalLevel = 0;
-                LoginUser loginUser = getLoginUser();
-                SysUser user = loginUser.getUser();
                 List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId());
                 if (!postids.contains(2)) {
                     serviceFund.setRecordstatus(2);
                     if (serviceFund.getBackflowlevel() != null) {
                         serviceFund.setFlowlevel(serviceFund.getBackflowlevel().longValue());
                     } else {
-                        serviceFund.setBackflowlevel(1);
-                        serviceFund.setFlowlevel(1L);
+                        serviceFund.setBackflowlevel(serviceFundflowrules.get(0).getFlowlevel() - 1);
+                        serviceFund.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                     }
                 } else {
                     serviceFund.setRecordstatus(0);
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java
index dff0ba6..19cb29c 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java
@@ -7,6 +7,7 @@
 import com.ruoyi.common.constant.HttpStatus;
 import com.ruoyi.common.core.controller.BaseController;
 import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.core.domain.entity.SysDept;
 import com.ruoyi.common.core.domain.entity.SysUser;
 import com.ruoyi.common.core.domain.model.LoginUser;
 import com.ruoyi.common.core.page.TableDataInfo;
@@ -21,6 +22,7 @@
 import com.ruoyi.project.domain.vo.SpFinancialExpensesIn;
 import com.ruoyi.project.domain.vo.SpFinancialExpensesReimbursementOut;
 import com.ruoyi.project.service.*;
+import com.ruoyi.system.service.ISysDeptService;
 import com.ruoyi.system.service.ISysPostService;
 import com.ruoyi.web.controller.enums.PersonType;
 import freemarker.template.Configuration;
@@ -73,7 +75,7 @@
     private IServiceFundflowService serviceFundflowService;
 
     @Autowired
-    private IServiceFundService serviceFundService;
+    private ISysDeptService sysDeptService;
 
     @Autowired
     private IBaseOnlyvalueService baseOnlyvalueService;
@@ -244,14 +246,25 @@
     public AjaxResult travelexpensereport(@RequestBody CheckFundVO checkFundVO) {
         ServiceReimbursement serviceReimbursement = serviceReimbursementService.getById(checkFundVO.getFundid());
         serviceReimbursement.setApplyTime(new Date());
+        Long flowLavel = null;
+
+        LoginUser loginUser = getLoginUser();
+        SysUser user = loginUser.getUser();
+
+        //鏌ヨ蹇呭浜�
+        ServiceFundflowrule serviceFundflowrule = new ServiceFundflowrule();
+        serviceFundflowrule.setApplytype("0");
+        serviceFundflowrule.setMustAudite(1);
+        List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule);
+        log.info("reimbursement蹇呭浜虹殑绛夌骇涓猴細{}", serviceFundflowrules.get(0).getFlowlevel());
+
         //濡傛灉绛変簬100锛岃鏄庡凡缁忚蛋鍒板尰闄㈣储鍔¢偅杈逛簡锛涜储鍔¢偅杈瑰彇鏁版嵁鏄粠鍒嗕韩琛ㄥ彇锛屾墍浠ワ紝杩欓噷鐩存帴寰�鍒嗕韩琛ㄩ噷娣诲姞鏁版嵁灏辫浜�;
         if (!Objects.isNull(serviceReimbursement) && serviceReimbursement.getBackflowlevel() != null) {
             if (serviceReimbursement.getBackflowlevel() == 100 || serviceReimbursement.getBackflowlevel() == 199) {
-//            if (serviceReimbursement.getBackflowlevel() == 199) {
                 //灏嗛��鍥為樁娈佃缃垚100
                 serviceReimbursement.setBackflowlevel(100L);
                 //閫�鍥炲啀鎻愪氦锛岄渶瑕佸啀鍒板嚭绾抽偅閲�
-                serviceReimbursement.setFlowlevel(1L);
+                serviceReimbursement.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 serviceReimbursement.setRecordstatus(2);
                 serviceReimbursementService.updateById(serviceReimbursement);
 
@@ -259,9 +272,9 @@
 //                serviceReimbursementService.addSharedData(checkFundVO.getFundid());
 
                 return success();
-            } else if (serviceReimbursement.getBackflowlevel() == 2) {
+            } else if (serviceReimbursement.getBackflowlevel() >= Long.valueOf(serviceFundflowrules.get(0).getFlowlevel())) {
                 //鑱傜閫�鍥炵殑锛屼篃闇�瑕佽蛋鍑虹撼閭i噷
-                serviceReimbursement.setFlowlevel(1L);
+                serviceReimbursement.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 serviceReimbursement.setRecordstatus(2);
                 serviceReimbursementService.updateById(serviceReimbursement);
                 return success();
@@ -269,8 +282,6 @@
         }
         if (serviceReimbursement != null) {
             Integer TotalLevel = 0;
-            LoginUser loginUser = getLoginUser();
-            SysUser user = loginUser.getUser();
             List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId());
 
             if (!postids.contains(2)) {
@@ -278,8 +289,8 @@
                 if (serviceReimbursement.getBackflowlevel() != null) {
                     serviceReimbursement.setFlowlevel(serviceReimbursement.getBackflowlevel());
                 } else {
-                    serviceReimbursement.setBackflowlevel(1L);
-                    serviceReimbursement.setFlowlevel(1L);
+                    serviceReimbursement.setBackflowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
+                    serviceReimbursement.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1));
                 }
             } else {
                 serviceReimbursement.setRecordstatus(0);
@@ -301,7 +312,8 @@
                 serviceFundflow.setApplytype("0");
                 serviceFundflow.setFlowconclusion(1);
                 serviceFundflow.setFlowcontent("闈炰笓鑱屼汉鍛樼洿鎺ヨ繘鍏ヤ簩绾у鏍�");
-                serviceFundflow.setFlowlevel(1);
+
+                serviceFundflow.setFlowlevel(serviceFundflowrules.get(0).getFlowlevel() - 1);
                 serviceFundflowService.save(serviceFundflow);
             }
 
@@ -372,7 +384,7 @@
                     //璇存槑鏄储鍔¢��鍥炲啀鎻愪氦鐨�.闇�瑕佸嚭绾冲啀鐪嬩竴閬嶏紝娌¢棶棰樹箣鍚庯紝寰�鍒嗕韩琛ㄩ噷鏂板
 //                    serviceReimbursementService.addSharedData(serviceReimbursement.getId());
 
-                    serviceReimbursement.setFlowlevel(3L);
+                    serviceReimbursement.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getTotallevel()));
                     serviceReimbursement.setFlowlevel(100L);
                     serviceReimbursement.setRecordstatus(99);
                     boolean b = serviceReimbursementService.updateById(serviceReimbursement);
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundflowrule.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundflowrule.java
index 357b696..a0870bb 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundflowrule.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundflowrule.java
@@ -10,56 +10,78 @@
 
 /**
  * 璧勯噾瀹℃壒瑙勫垯瀵硅薄 service_fundflowrule
- * 
+ *
  * @author ruoyi
  * @date 2022-04-27
  */
 @Data
 @ApiModel("璧勯噾瀹℃壒瑙勫垯")
-public class ServiceFundflowrule extends BaseEntity
-{
+public class ServiceFundflowrule extends BaseEntity {
     private static final long serialVersionUID = 1L;
 
-    /** $column.columnComment */
+    /**
+     * $column.columnComment
+     */
     @ApiModelProperty("$column.columnComment")
     //鏁版嵁搴撹嚜澧炴敼鎴怈TableId(type = IdType.AUTO)
     @TableId(type = IdType.AUTO)
     private Long id;
 
-    /** 璧勯噾绫诲埆 瑙佸瓧鍏竤ys_ConsolationType */
+    /**
+     * 璧勯噾绫诲埆 瑙佸瓧鍏竤ys_ConsolationType
+     */
     @ApiModelProperty("璧勯噾绫诲埆 瑙佸瓧鍏竤ys_ConsolationType")
     @Excel(name = "璧勯噾绫诲埆 瑙佸瓧鍏竤ys_ConsolationType")
     private String applytype;
 
-    /** 瀹℃牳浜虹紪鍙� */
+    /**
+     * 瀹℃牳浜虹紪鍙�
+     */
     @ApiModelProperty("瀹℃牳浜虹紪鍙�")
     @Excel(name = "瀹℃牳浜虹紪鍙�")
     private String checkuserno;
 
-    /** 瀹℃牳浜哄鍚� */
+    /**
+     * 瀹℃牳浜哄鍚�
+     */
     @ApiModelProperty("瀹℃牳浜哄鍚�")
     @Excel(name = "瀹℃牳浜哄鍚�")
     private String checkusername;
 
-    /** 鏄惁瑕侀獙璇侀儴闂紝鍙鏍稿悓閮ㄩ棬鐨� */
+    /**
+     * 鏄惁瑕侀獙璇侀儴闂紝鍙鏍稿悓閮ㄩ棬鐨�
+     */
     @ApiModelProperty("鏄惁瑕侀獙璇侀儴闂紝鍙鏍稿悓閮ㄩ棬鐨�")
     @Excel(name = "鏄惁瑕侀獙璇侀儴闂紝鍙鏍稿悓閮ㄩ棬鐨�")
     private Integer verificationdept;
 
-    /** 褰撳墠瀹℃牳绾у埆 */
+    /**
+     * 褰撳墠瀹℃牳绾у埆
+     */
     @ApiModelProperty("褰撳墠瀹℃牳绾у埆")
     @Excel(name = "褰撳墠瀹℃牳绾у埆")
     private Integer flowlevel;
 
-    /** 鎬诲鏍哥骇鍒� */
+    /**
+     * 鎬诲鏍哥骇鍒�
+     */
     @ApiModelProperty("鎬诲鏍哥骇鍒�")
     @Excel(name = "鎬诲鏍哥骇鍒�")
     private Integer totallevel;
 
-    /** 璐圭敤绫诲埆  1锛氬樊鏃呰垂妯″潡  2锛氳垂鐢ㄧ敵璇锋ā鍧� */
+    /**
+     * 璐圭敤绫诲埆  1锛氬樊鏃呰垂妯″潡  2锛氳垂鐢ㄧ敵璇锋ā鍧�
+     */
     @ApiModelProperty("璐圭敤绫诲埆  1锛氬樊鏃呰垂妯″潡  2锛氳垂鐢ㄧ敵璇锋ā鍧�")
     @Excel(name = "璐圭敤绫诲埆  1锛氬樊鏃呰垂妯″潡  2锛氳垂鐢ㄧ敵璇锋ā鍧�")
     private Integer fundtype;
 
+    /**
+     * 鏄惁涓哄繀瀹′汉   0锛氬惁     1锛氭槸
+     */
+    @ApiModelProperty("鏄惁涓哄繀瀹′汉   0锛氬惁     1锛氭槸")
+    @Excel(name = "鏄惁涓哄繀瀹′汉   0锛氬惁     1锛氭槸")
+    private Integer mustAudite;
+
 }
 
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationCompletionVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationCompletionVO.java
index 76c86b4..8faa482 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationCompletionVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationCompletionVO.java
@@ -3,6 +3,8 @@
 
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ruoyi.common.annotation.Excel;
+import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 import org.springframework.format.annotation.DateTimeFormat;
 
@@ -82,4 +84,8 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
     private Date endtime;
     private String city;
+    private Integer workflow;
+
+    @ApiModelProperty("缁堟妗堜緥锛�0寮�鍚紝1缁堟    榛樿鍊硷細0")
+    private Integer terminationCase;
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationWitnessVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationWitnessVO.java
index eb6fb0c..288b2df 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationWitnessVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DonationWitnessVO.java
@@ -102,6 +102,7 @@
     @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
     private Date endtime;
-
     private String city;
+    private Integer workflow;
+    private Integer terminationCase;
 }
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 5758003..6e60c6e 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
@@ -85,4 +85,6 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
     private Date endtime;
     private String city;
+    private Integer workflow;
+    private Integer terminationCase;
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/MedicalEvaluationVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/MedicalEvaluationVO.java
index d1d496d..df6f97c 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/MedicalEvaluationVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/MedicalEvaluationVO.java
@@ -78,4 +78,6 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
     private Date endtime;
     private String city;
+    private Integer workflow;
+    private Integer terminationCase;
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/RelativeConfirmationVO.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/RelativeConfirmationVO.java
index 869ec70..e210c1b 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/RelativeConfirmationVO.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/RelativeConfirmationVO.java
@@ -104,4 +104,6 @@
     private String city;
     private String operatorno;
     private String operatorname;
+    private Integer workflow;
+    private Integer terminationCase;
 }
diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundflowruleServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundflowruleServiceImpl.java
index e4def0b..1fa0a61 100644
--- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundflowruleServiceImpl.java
+++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundflowruleServiceImpl.java
@@ -1,13 +1,16 @@
 package com.ruoyi.project.service.impl;
 
 import java.util.List;
+
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+
 import java.util.ArrayList;
 import java.util.Map;
+
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.project.mapper.ServiceFundflowruleMapper;
 import com.ruoyi.project.domain.ServiceFundflowrule;
@@ -15,44 +18,46 @@
 
 /**
  * 璧勯噾瀹℃壒瑙勫垯Service涓氬姟灞傚鐞�
- * 
+ *
  * @author ruoyi
  * @date 2022-04-27
  */
 @Service
-public class ServiceFundflowruleServiceImpl extends ServiceImpl<ServiceFundflowruleMapper, ServiceFundflowrule> implements IServiceFundflowruleService 
-{
+public class ServiceFundflowruleServiceImpl extends ServiceImpl<ServiceFundflowruleMapper, ServiceFundflowrule> implements IServiceFundflowruleService {
 
 
     /**
      * 鏌ヨ璧勯噾瀹℃壒瑙勫垯鍒楄〃
-     * 
+     *
      * @param serviceFundflowrule 璧勯噾瀹℃壒瑙勫垯
      * @return 璧勯噾瀹℃壒瑙勫垯
      */
     @Override
     public List<ServiceFundflowrule> queryList(ServiceFundflowrule serviceFundflowrule) {
         LambdaQueryWrapper<ServiceFundflowrule> wrappers = Wrappers.lambdaQuery();
-        if (StringUtils.isNotBlank(serviceFundflowrule.getApplytype())){
-            wrappers.eq(ServiceFundflowrule::getApplytype ,serviceFundflowrule.getApplytype());
+        if (StringUtils.isNotBlank(serviceFundflowrule.getApplytype())) {
+            wrappers.eq(ServiceFundflowrule::getApplytype, serviceFundflowrule.getApplytype());
         }
-        if (StringUtils.isNotBlank(serviceFundflowrule.getCheckuserno())){
-            wrappers.eq(ServiceFundflowrule::getCheckuserno ,serviceFundflowrule.getCheckuserno());
+        if (StringUtils.isNotBlank(serviceFundflowrule.getCheckuserno())) {
+            wrappers.eq(ServiceFundflowrule::getCheckuserno, serviceFundflowrule.getCheckuserno());
         }
-        if (StringUtils.isNotBlank(serviceFundflowrule.getCheckusername())){
-            wrappers.like(ServiceFundflowrule::getCheckusername ,serviceFundflowrule.getCheckusername());
+        if (StringUtils.isNotBlank(serviceFundflowrule.getCheckusername())) {
+            wrappers.like(ServiceFundflowrule::getCheckusername, serviceFundflowrule.getCheckusername());
         }
-        if (serviceFundflowrule.getVerificationdept() != null){
-            wrappers.eq(ServiceFundflowrule::getVerificationdept ,serviceFundflowrule.getVerificationdept());
+        if (serviceFundflowrule.getVerificationdept() != null) {
+            wrappers.eq(ServiceFundflowrule::getVerificationdept, serviceFundflowrule.getVerificationdept());
         }
-        if (serviceFundflowrule.getFlowlevel() != null){
-            wrappers.eq(ServiceFundflowrule::getFlowlevel ,serviceFundflowrule.getFlowlevel());
+        if (serviceFundflowrule.getFlowlevel() != null) {
+            wrappers.eq(ServiceFundflowrule::getFlowlevel, serviceFundflowrule.getFlowlevel());
         }
-        if (serviceFundflowrule.getTotallevel() != null){
-            wrappers.eq(ServiceFundflowrule::getTotallevel ,serviceFundflowrule.getTotallevel());
+        if (serviceFundflowrule.getTotallevel() != null) {
+            wrappers.eq(ServiceFundflowrule::getTotallevel, serviceFundflowrule.getTotallevel());
         }
-        if (serviceFundflowrule.getFundtype() != null){
-            wrappers.eq(ServiceFundflowrule::getFundtype ,serviceFundflowrule.getFundtype());
+        if (serviceFundflowrule.getFundtype() != null) {
+            wrappers.eq(ServiceFundflowrule::getFundtype, serviceFundflowrule.getFundtype());
+        }
+        if (serviceFundflowrule.getMustAudite() != null) {
+            wrappers.eq(ServiceFundflowrule::getMustAudite, serviceFundflowrule.getMustAudite());
         }
         return this.list(wrappers);
     }
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
index aebc9b9..d7f4e90 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatebaseinfoMapper.xml
@@ -214,6 +214,7 @@
             <if test="businessarea != null ">and businessarea = #{businessarea}</if>
             <if test="donatetime != null ">and donatetime = #{donatetime}</if>
             <if test="donateno != null ">and donateno = #{donateno}</if>
+            <if test="workflow != null ">and workflow = #{workflow}</if>
         </where>
 
         order by ReportTime desc
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatecompletioninfoMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatecompletioninfoMapper.xml
index 99f98dd..c113b15 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonatecompletioninfoMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonatecompletioninfoMapper.xml
@@ -73,6 +73,8 @@
         `service_donatebaseinfo`.`RegisterCountyCode` AS `RegisterCountyCode`,
         `service_donatebaseinfo`.`RegisterCountyName` AS `RegisterCountyName`,
         `service_donatebaseinfo`.`create_by` AS `basecreateby`,
+        `service_donatebaseinfo`.`workflow` AS `workflow`,
+        `service_donatebaseinfo`.`termination_case` AS `terminationCase`,
         `service_donatecompletioninfo`.`ID` AS `dcID`,
         `service_donatecompletioninfo`.`InfoID` AS `InfoID`,
         `service_donatecompletioninfo`.`DonorNo` AS `dcDonorNo`,
@@ -117,6 +119,7 @@
             <if test="reporterno != null  and reporterno != ''"> and `service_donatebaseinfo`.ReporterNo = #{reporterno}</if>
             <if test="city != null and city != ''"> and `base_organization`.`City` = #{city}</if>
             <if test="id != null "> and `service_donatebaseinfo`.`ID` = #{id}</if>
+            <if test="workflow != null "> and `service_donatebaseinfo`.`workflow` = #{workflow}</if>
     </where>
 
         order by `service_donatecompletioninfo`.`create_time` desc
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
index 03fbb1b..d0b28e3 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceDonationwitnessMapper.xml
@@ -119,6 +119,8 @@
         `service_donatebaseinfo`.`ReporterPhone` AS `ReporterPhone`,
         `service_donatebaseinfo`.`ReportTime` AS `ReportTime`,
         `service_donatebaseinfo`.`create_by` AS `basecreateby`,
+        `service_donatebaseinfo`.`workflow` AS `workflow`,
+        `service_donatebaseinfo`.`termination_case` AS `terminationCase`,
         `service_donationwitness`.`ID` AS `dwID`,
         `service_donationwitness`.`InfoID` AS `InfoID`,
         `service_donationwitness`.`DonorNo` AS `dwDonorNo`,
@@ -185,6 +187,7 @@
                 #{reporterno}
             </if>
             <if test="city != null and city != ''">and `base_organization`.`City` = #{city}</if>
+            <if test="workflow != null "> and `service_donatebaseinfo`.`workflow` = #{workflow}</if>
         </where>
 
         order by `service_donationwitness`.`create_time` desc
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
index 3b4070d..c13d8e5 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceEthicalreviewopinionsMapper.xml
@@ -1,41 +1,57 @@
 <?xml version="1.0" encoding="UTF-8" ?>
 <!DOCTYPE mapper
-PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.ruoyi.project.mapper.ServiceEthicalreviewopinionsMapper">
-    
+
     <resultMap type="com.ruoyi.project.domain.ServiceEthicalreviewopinions" id="ServiceEthicalreviewopinionsResult">
-        <result property="id"    column="ID"    />
-        <result property="del_flag"    column="del_flag"    />
-        <result property="createBy"    column="create_by"    />
-        <result property="createTime"    column="create_time"    />
-        <result property="updateBy"    column="update_by"    />
-        <result property="updateTime"    column="update_time"    />
-        <result property="infoid"    column="InfoID"    />
-        <result property="donorno"    column="DonorNo"    />
-        <result property="expertopinion"    column="ExpertOpinion"    />
-        <result property="expertconclusion"    column="ExpertConclusion"    />
-        <result property="expertname"    column="ExpertName"    />
-        <result property="conclusiontime"    column="ConclusionTime"    />
-        <result property="conclusionannex"    column="ConclusionAnnex"    />
-        <result property="conclusionorder"    column="ConclusionOrder"    />
+        <result property="id" column="ID"/>
+        <result property="del_flag" column="del_flag"/>
+        <result property="createBy" column="create_by"/>
+        <result property="createTime" column="create_time"/>
+        <result property="updateBy" column="update_by"/>
+        <result property="updateTime" column="update_time"/>
+        <result property="infoid" column="InfoID"/>
+        <result property="donorno" column="DonorNo"/>
+        <result property="expertopinion" column="ExpertOpinion"/>
+        <result property="expertconclusion" column="ExpertConclusion"/>
+        <result property="expertname" column="ExpertName"/>
+        <result property="conclusiontime" column="ConclusionTime"/>
+        <result property="conclusionannex" column="ConclusionAnnex"/>
+        <result property="conclusionorder" column="ConclusionOrder"/>
     </resultMap>
 
     <sql id="selectServiceEthicalreviewopinionsVo">
-        select ID, del_flag, create_by, create_time, update_by, update_time, InfoID, DonorNo, ExpertOpinion, ExpertConclusion, ExpertName, ConclusionTime, ConclusionAnnex, ConclusionOrder from service_ethicalreviewopinions
+        select ID,
+               del_flag,
+               create_by,
+               create_time,
+               update_by,
+               update_time,
+               InfoID,
+               DonorNo,
+               ExpertOpinion,
+               ExpertConclusion,
+               ExpertName,
+               ConclusionTime,
+               ConclusionAnnex,
+               ConclusionOrder
+        from service_ethicalreviewopinions
     </sql>
 
-    <select id="selectServiceEthicalreviewopinionsList" parameterType="com.ruoyi.project.domain.ServiceEthicalreviewopinions" resultMap="ServiceEthicalreviewopinionsResult">
+    <select id="selectServiceEthicalreviewopinionsList"
+            parameterType="com.ruoyi.project.domain.ServiceEthicalreviewopinions"
+            resultMap="ServiceEthicalreviewopinionsResult">
         <include refid="selectServiceEthicalreviewopinionsVo"/>
         <where>
-            <if test="infoid != null "> and InfoID = #{infoid}</if>
-            <if test="donorno != null  and donorno != ''"> and DonorNo = #{donorno}</if>
-            <if test="expertopinion != null  and expertopinion != ''"> and ExpertOpinion = #{expertopinion}</if>
-            <if test="expertconclusion != null "> and ExpertConclusion = #{expertconclusion}</if>
-            <if test="expertname != null  and expertname != ''"> and ExpertName like concat('%', #{expertname}, '%')</if>
-            <if test="conclusiontime != null "> and ConclusionTime = #{conclusiontime}</if>
-            <if test="conclusionannex != null  and conclusionannex != ''"> and ConclusionAnnex = #{conclusionannex}</if>
-            <if test="conclusionorder != null "> and ConclusionOrder = #{conclusionorder}</if>
+            <if test="infoid != null ">and InfoID = #{infoid}</if>
+            <if test="donorno != null  and donorno != ''">and DonorNo = #{donorno}</if>
+            <if test="expertopinion != null  and expertopinion != ''">and ExpertOpinion = #{expertopinion}</if>
+            <if test="expertconclusion != null ">and ExpertConclusion = #{expertconclusion}</if>
+            <if test="expertname != null  and expertname != ''">and ExpertName like concat('%', #{expertname}, '%')</if>
+            <if test="conclusiontime != null ">and ConclusionTime = #{conclusiontime}</if>
+            <if test="conclusionannex != null  and conclusionannex != ''">and ConclusionAnnex = #{conclusionannex}</if>
+            <if test="conclusionorder != null ">and ConclusionOrder = #{conclusionorder}</if>
         </where>
     </select>
     <select id="selectVOList" resultType="com.ruoyi.project.domain.vo.EthicalReviewVO">
@@ -77,6 +93,8 @@
         `service_donatebaseinfo`.`DiseaseType` AS `DiseaseType`,
         `service_donatebaseinfo`.`PatientState` AS `PatientState`,
         `service_donatebaseinfo`.`create_by` AS `basecreateby`,
+        `service_donatebaseinfo`.`workflow` AS `workflow;`,
+        `service_donatebaseinfo`.`termination_case` AS `terminationCase;`,
         `service_donateflowchart`.`ID` AS `fcID`,
         `service_donateflowchart`.`InfoID` AS `InfoID`,
         `service_donateflowchart`.`DonorNo` AS `fcDonorNo`,
@@ -94,29 +112,42 @@
         `service_donatebaseinfo`
         LEFT JOIN `service_donateflowchart` ON
         `service_donatebaseinfo`.`ID` = `service_donateflowchart`.`InfoID`
-        AND  `service_donateflowchart`.`FlowName` = '浼︾悊瀹℃煡'
+        AND `service_donateflowchart`.`FlowName` = '浼︾悊瀹℃煡'
         LEFT JOIN `base_organization` ON
         `base_organization`.`OrganizationID` = `service_donatebaseinfo`.`TreatmentHospitalNo`
         <where>
-            <if test="donorno != null  and donorno != ''"> and `service_donatebaseinfo`.`DonorNo` = #{donorno}</if>
-            <if test="name != null  and name != ''"> and `service_donatebaseinfo`.`Name` like concat('%', #{name}, '%')</if>
-            <if test="idcardno != null  and idcardno != ''"> and `service_donatebaseinfo`.`IDCardNo` = #{idcardno}</if>
-            <if test="treatmenthospitalno != null  and treatmenthospitalno != ''"> and `service_donatebaseinfo`.`TreatmentHospitalNo` = #{treatmenthospitalno}</if>
-            <if test="recordstate != null  and recordstate != ''"> and `service_donatebaseinfo`.`RecordState` = #{recordstate}</if>
-            <if test="basecreateby != null  and basecreateby != ''"> and `service_donatebaseinfo`.`create_by` = #{basecreateby}</if>
-            <if test="starttime != null "> and `service_donateflowchart`.create_time >= #{starttime} </if>
-            <if test="endtime != null ">  and `service_donateflowchart`.create_time &lt;= #{endtime}</if>
-            <if test="reporterno != null  and reporterno != ''"> and `service_donatebaseinfo`.ReporterNo = #{reporterno}</if>
-            <if test="city != null and city != ''"> and `base_organization`.`City` = #{city}</if>
-            <if test="fcid != null ">  and `service_donateflowchart`.`ID` = #{fcid}</if>
+            <if test="donorno != null  and donorno != ''">and `service_donatebaseinfo`.`DonorNo` = #{donorno}</if>
+            <if test="name != null  and name != ''">and `service_donatebaseinfo`.`Name` like concat('%', #{name}, '%')
+            </if>
+            <if test="idcardno != null  and idcardno != ''">and `service_donatebaseinfo`.`IDCardNo` = #{idcardno}</if>
+            <if test="treatmenthospitalno != null  and treatmenthospitalno != ''">and
+                `service_donatebaseinfo`.`TreatmentHospitalNo` = #{treatmenthospitalno}
+            </if>
+            <if test="recordstate != null  and recordstate != ''">and `service_donatebaseinfo`.`RecordState` =
+                #{recordstate}
+            </if>
+            <if test="basecreateby != null  and basecreateby != ''">and `service_donatebaseinfo`.`create_by` =
+                #{basecreateby}
+            </if>
+            <if test="starttime != null ">and `service_donateflowchart`.create_time >= #{starttime}</if>
+            <if test="endtime != null ">and `service_donateflowchart`.create_time &lt;= #{endtime}</if>
+            <if test="reporterno != null  and reporterno != ''">and `service_donatebaseinfo`.ReporterNo =
+                #{reporterno}
+            </if>
+            <if test="city != null and city != ''">and `base_organization`.`City` = #{city}</if>
+            <if test="fcid != null ">and `service_donateflowchart`.`ID` = #{fcid}</if>
+            <if test="workflow != null "> and `service_donatebaseinfo`.`workflow` = #{workflow}</if>
         </where>
 
-        order by  `service_donateflowchart`.`create_time` desc
+        order by `service_donateflowchart`.`create_time` desc
 
     </select>
     <select id="countNumber" resultType="java.lang.Integer">
-        select count(*) from service_donateflowchart where `service_donateflowchart`.`FlowName` = '浼︾悊瀹℃煡'
-        and create_time >= #{starttime} and create_time &lt;= #{endtime}
+        select count(*)
+        from service_donateflowchart
+        where `service_donateflowchart`.`FlowName` = '浼︾悊瀹℃煡'
+          and create_time >= #{starttime}
+          and create_time &lt;= #{endtime}
     </select>
 
 </mapper>
\ No newline at end of file
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFundflowruleMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFundflowruleMapper.xml
index 19a3442..9c13e63 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceFundflowruleMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFundflowruleMapper.xml
@@ -4,7 +4,7 @@
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.ruoyi.project.mapper.ServiceFundflowruleMapper">
     
-    <resultMap type="ServiceFundflowrule" id="ServiceFundflowruleResult">
+    <resultMap type="com.ruoyi.project.domain.ServiceFundflowrule" id="ServiceFundflowruleResult">
         <result property="id"    column="ID"    />
         <result property="applytype"    column="ApplyType"    />
         <result property="checkuserno"    column="CheckUserNo"    />
@@ -13,13 +13,14 @@
         <result property="flowlevel"    column="FlowLevel"    />
         <result property="totallevel"    column="TotalLevel"    />
         <result property="fundtype"    column="FundType"    />
+        <result property="mustAudite"    column="must_audite"    />
     </resultMap>
 
     <sql id="selectServiceFundflowruleVo">
         select ID, ApplyType, CheckUserNo, CheckUserName, VerificationDept, FlowLevel, TotalLevel, FundType from service_fundflowrule
     </sql>
 
-    <select id="selectServiceFundflowruleList" parameterType="ServiceFundflowrule" resultMap="ServiceFundflowruleResult">
+    <select id="selectServiceFundflowruleList" parameterType="com.ruoyi.project.domain.ServiceFundflowrule" resultMap="ServiceFundflowruleResult">
         <include refid="selectServiceFundflowruleVo"/>
         <where>
             <if test="applytype != null  and applytype != ''"> and ApplyType = #{applytype}</if>
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
index f60027e..d0b44d5 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceMedicalevaluationMapper.xml
@@ -23,7 +23,7 @@
         <result property="coreteamassesstime"    column="CoreTeamAssessTime"    />
         <result property="coreteamassessconclusion"    column="CoreTeamAssessConclusion"    />
         <result property="assessannex"    column="AssessAnnex"    />
-        <result property="delFlag"    column="del_flag"    />
+        <result property="del_flag"    column="del_flag"    />
         <result property="createBy"    column="create_by"    />
         <result property="createTime"    column="create_time"    />
         <result property="updateBy"    column="update_by"    />
@@ -34,7 +34,7 @@
         select ID, InfoID, DonorNo, IllnessOverview, DiagnosisName, HospitalAssessContent, HospitalAssessDoctor, HospitalAssessTime, HospitalAssessConclusion, ProvincialAssessContent, ProvincialAssessDoctor, ProvincialAssessTime, ProvincialAssessConclusion, CoreTeamAssessContent, CoreTeamAssessDoctor, CoreTeamAssessTime, CoreTeamAssessConclusion, AssessAnnex, del_flag, create_by, create_time, update_by, update_time from service_medicalevaluation
     </sql>
 
-    <select id="selectServiceMedicalevaluationList" parameterType="ServiceMedicalevaluation" resultMap="ServiceMedicalevaluationResult">
+    <select id="selectServiceMedicalevaluationList" parameterType="com.ruoyi.project.domain.ServiceMedicalevaluation" resultMap="ServiceMedicalevaluationResult">
         <include refid="selectServiceMedicalevaluationVo"/>
         <where>
             <if test="donorno != null  and donorno != ''"> and DonorNo = #{donorno}</if>
@@ -69,6 +69,8 @@
         `service_donatebaseinfo`.`ReporterNo` AS `ReporterNo`,
         `service_donatebaseinfo`.`ReportTime` AS `ReportTime`,
         `service_donatebaseinfo`.`create_by` AS `basecreateby`,
+        `service_donatebaseinfo`.`workflow` AS `workflow`,
+        `service_donatebaseinfo`.`termination_case` AS `terminationCase`,
         `service_medicalevaluation`.`ID` AS `meID`,
         `service_medicalevaluation`.`HospitalAssessContent` AS `HospitalAssessContent`,
         `service_medicalevaluation`.`HospitalAssessConclusion` AS `HospitalAssessConclusion`,
@@ -112,6 +114,7 @@
             <if test="endtime != null ">  and `service_medicalevaluation`.CoreTeamAssessTime &lt;= #{endtime}</if>
             <if test="reporterno != null  and reporterno != ''"> and `service_donatebaseinfo`.ReporterNo = #{reporterno}</if>
             <if test="city != null and city != ''"> and `base_organization`.`City` = #{city}</if>
+            <if test="workflow != null "> and `service_donatebaseinfo`.`workflow` = #{workflow}</if>
     </where>
 
         order by `service_medicalevaluation`.`create_time` desc,
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
index 08c0fb8..0211b64 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceRelativesconfirmationMapper.xml
@@ -104,6 +104,8 @@
         `service_donatebaseinfo`.`TreatmentHospitalName` AS `TreatmentHospitalName`,
         `service_donatebaseinfo`.`TreatmentDeptName` AS `TreatmentDeptName`,
         `service_donatebaseinfo`.`create_by` AS `basecreateby`,
+        `service_donatebaseinfo`.`workflow` AS `workflow`,
+        `service_donatebaseinfo`.`termination_case` AS `terminationCase`,
         `service_relativesconfirmation`.`ID` AS `rcID`,
         `service_relativesconfirmation`.`InfoID` AS `InfoID`,
         `service_relativesconfirmation`.`DonorNo` AS `rcDonroNo`,
@@ -169,6 +171,7 @@
             <if test="residenceprovince != null and residenceprovince != ''"> and `service_relativesconfirmation`.`ResidenceProvince` = #{residenceprovince}</if>
             <if test="residencecity != null and residencecity != ''"> and `service_relativesconfirmation`.`ResidenceCity` = #{residencecity}</if>
             <if test="residencetown != null and residencetown != ''"> and `service_relativesconfirmation`.`ResidenceTown` = #{residencetown}</if>
+            <if test="workflow != null "> and `service_donatebaseinfo`.`workflow` = #{workflow}</if>
 
     </where>
 

--
Gitblit v1.9.3