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