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 <= #{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 <= #{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 <= #{endtime}
+ select count(*)
+ from service_donateflowchart
+ where `service_donateflowchart`.`FlowName` = '浼︾悊瀹℃煡'
+ and create_time >= #{starttime}
+ and create_time <= #{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 <= #{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