From 2c456094bdf1cc7e1bab5e0dbee00bb1f2743488 Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期一, 17 七月 2023 13:50:12 +0800 Subject: [PATCH] 1、审批顺序:审批时,从一级到五级逐级审批,回退时,由审批人员指定回退级别,如从五级审批退回到经办人(需要重新修改材料的人员处),每一级可以看到回退的信息;修改完成后,直接从经办人处到达五级审批或退回的审批人。被退回的信息修改完成后,直接从经办人到达五级审批或退回的审批人处,那么其他层级的审批人虽然不需要审批,但要能够看到重新修改后的信息。 说明: (1)差旅费报销主表:service_reimbursement 标识字段:FlowLevel(当前审核级别 处于哪个阶段 0:申请;1:一级审核;2:二级审核;3:三级审核等; 4:四级审核等; 5:五级审核等);RecordStatus(记录状态 详见字典sys_travelexpensestatus) (2)费用报销主表:service_fund 标识字段:FlowLevel(当前审核级别 处于哪个阶段 0:申请;1:一级审核;2:二级审核;3:三级审核等; 4:四级审核等; 5:五级审核等);RecordStatus(记录状态 详见字典sys_travelexpensestatus) (3)审批流程设置表:service_fundflowrule (4)审批流程记录表:service_fundflow --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java | 46 + ruoyi-project/src/main/java/com/ruoyi/project/service/impl/DingTalkServiceImpl.java | 162 ++++++ ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementSharedMapper.java | 11 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundShared.java | 5 ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementMapper.xml | 8 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/DingTalkController.java | 56 ++ ruoyi-quartz/pom.xml | 6 ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementSharedMapper.xml | 279 +++++++---- ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DingTalkReqVo.java | 51 ++ ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundServiceImpl.java | 1 ruoyi-project/pom.xml | 21 ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml | 4 ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementSharedService.java | 17 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementShared.java | 3 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java | 39 + ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementServiceImpl.java | 4 ruoyi-admin/src/main/resources/application.yml | 4 ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFundSharedMapper.java | 2 ruoyi-project/src/main/resources/mapper/project/ServiceFundSharedMapper.xml | 7 ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml | 1 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementSharedServiceImpl.java | 192 ++++--- ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java | 116 ++++ ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFund.java | 6 ruoyi-project/src/main/resources/mapper/project/ServiceFundMapper.xml | 191 ++++-- ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursement.java | 150 ++++- ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java | 5 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundSharedServiceImpl.java | 16 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java | 5 ruoyi-project/src/main/java/com/ruoyi/project/service/DingTalkService.java | 18 ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFundSharedService.java | 15 30 files changed, 1,099 insertions(+), 342 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/DingTalkController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/DingTalkController.java new file mode 100644 index 0000000..a9d40b8 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/DingTalkController.java @@ -0,0 +1,56 @@ +package com.ruoyi.web.controller.project; + +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.project.domain.vo.DingTalkReqVo; +import com.ruoyi.project.service.DingTalkService; +import com.taobao.api.ApiException; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; +import org.springframework.context.annotation.PropertySource; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +/** + * 閽夐拤鎺ュ彛 + * + * @author liusheng + * @date 2023-05-15 + */ +@Api(description = "閽夐拤鎺ュ彛") +@RestController +@RequestMapping("/smartor/dingtalk") +@PropertySource(value = {"classpath:application-druid.yml"}) +public class DingTalkController extends BaseController { + + @Value("${dingAppid}") + private String dingAppid; + + @Value("${dingAppSecret}") + private String dingAppSecret; + + @Autowired + private DingTalkService dingTalkService; + + /** + * 鍙戦�侀拤閽夋秷鎭� + * + * @param dingTalkReqVo 鍙戦�佸唴瀹� + * @throws ApiException + */ + @ApiOperation("鍙戦�侀拤閽夋秷鎭�") + @PostMapping("/sendNotification") + public AjaxResult sendNotification(@RequestBody DingTalkReqVo dingTalkReqVo) { + Boolean aBoolean = dingTalkService.sendNotification(dingTalkReqVo); + if (aBoolean) { + return success(); + } + return error(); + } + +} + 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 ac64e1f..4ff99cf 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 @@ -450,7 +450,7 @@ @Log(title = "瀹℃牳璐圭敤", businessType = BusinessType.OTHER) @PostMapping("/checkfund") public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) { - logger.info("serviceFundController---checkFund鐨勫叆鍙傚�糲heckFundVO :{}",checkFundVO); + logger.info("serviceFundController---checkFund鐨勫叆鍙傚�糲heckFundVO :{}", checkFundVO); ServiceFund serviceFund = serviceFundService.getById(checkFundVO.getFundid()); if (serviceFund != null) { Integer TotalLevel = 0; @@ -459,7 +459,7 @@ serviceFundflowrule.setFundtype(2); serviceFundflowrule.setApplytype(serviceFund.getApplytype()); serviceFundflowrule.setCheckuserno(loginUser.getUsername()); - logger.info("serviceFundController---checkFund---queryList鐨勫叆鍙傚�約erviceFundflowrule:{}",serviceFundflowrule); + logger.info("serviceFundController---checkFund---queryList鐨勫叆鍙傚�約erviceFundflowrule:{}", serviceFundflowrule); List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule); @@ -493,10 +493,15 @@ FlowLevel = FlowLevel + 1; } else { CheckFlag = 2; - RecordStatus = (FlowLevel + 1) * 2 - 1; - FlowLevel = (FlowLevel - 1); - if (FlowLevel < 0) { + if (CheckFlag == 2) { + //搴斿尰闄㈣姹傚鏋滃嚭鐜伴��鍥烇紝鐩存帴閫�鍒板彂璧疯�� FlowLevel = 0; + } else { + RecordStatus = (FlowLevel + 1) * 2 - 1; + FlowLevel = (FlowLevel - 1); + if (FlowLevel < 0) { + FlowLevel = 0; + } } } @@ -550,7 +555,7 @@ columnMap.put("fundID", checkFundVO.getFundid()); //鑾峰彇璇︽儏鏁版嵁 List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.selectByMap(columnMap); - logger.info("serviceFundController---checkFund鐨勮繑鍥炲�約erviceFunddetails :{}",serviceFunddetails); + logger.info("serviceFundController---checkFund鐨勮繑鍥炲�約erviceFunddetails :{}", serviceFunddetails); List<ServiceFunddetailShared> serviceFunddetailShareds = DtoConversionUtils.sourceToTarget(serviceFunddetails, ServiceFunddetailShared.class); for (int i = 0; i < serviceFunddetails.size(); i++) { serviceFunddetailShareds.get(i).setFundid(serviceFundShared.getId()); @@ -589,11 +594,29 @@ @PutMapping @RepeatSubmit public AjaxResult edit(@RequestBody ServiceFund serviceFund) { - boolean bret = serviceFundService.updateById(serviceFund); + List<ServiceFund> infoByInfoIdList = serviceFundService.getInfoByInfoId(serviceFund.getId()); + for (ServiceFund sf : infoByInfoIdList) { + //濡傛灉绛変簬100锛岃鏄庡凡缁忚蛋鍒板尰闄㈣储鍔¢偅杈逛簡锛涜储鍔¢偅杈瑰彇鏁版嵁鏄粠鍒嗕韩琛ㄥ彇锛屾墍浠ワ紝杩欓噷鐩存帴寰�鍒嗕韩琛ㄩ噷娣诲姞鏁版嵁灏辫浜� + if (sf.getBackflowlevel() == 100 || sf.getBackflowlevel() == 199) { + ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class); + serviceFundShared.setId(null); + serviceFundShared.setDel_flag(0); + fundSharedService.save(serviceFundShared); + + //灏唂und琛ㄧ殑瀹℃牳鐘舵�佹敼鎴�100 + sf.setBackflowlevel(100); + serviceFundService.updateById(sf); + return success(); + } else { + boolean bret = serviceFundService.updateById(serviceFund); // if (bret) { // addReiSharedDatd(serviceFund, 2); // } - return toAjax(bret); + return toAjax(bret); + } + } + + return toAjax(false); } /** 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 af24cf9..534ed5e 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 @@ -2,6 +2,8 @@ import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.common.annotation.Log; import com.ruoyi.common.annotation.RepeatSubmit; import com.ruoyi.common.config.RuoYiConfig; @@ -15,6 +17,7 @@ import com.ruoyi.common.exception.ServiceException; import com.ruoyi.common.utils.HttpClientKit; import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.bean.DtoConversionUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.project.domain.*; import com.ruoyi.project.domain.dto.ServiceReimbursementDto; @@ -29,6 +32,7 @@ import freemarker.template.TemplateException; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import org.apache.commons.lang.ObjectUtils; import org.apache.commons.lang.StringUtils; import org.apache.ibatis.annotations.Options; import org.springframework.beans.factory.annotation.Autowired; @@ -57,10 +61,10 @@ private IServiceReimbursementService serviceReimbursementService; @Autowired - private IServiceReimbursementpayeeService reimbursementpayeeService; + private IServiceReimbursementSharedService serviceReimbursementSharedService; @Autowired - private IServiceReimbursementSharedService serviceReimbursementServiceShare; + private IServiceReimbursementpayeeService reimbursementpayeeService; @Autowired private IServiceReimbursementdetailService serviceReimbursementdetailService; @@ -70,6 +74,9 @@ @Autowired private IServiceFundflowService serviceFundflowService; + + @Autowired + private IServiceFundService serviceFundService; @Autowired private ISysPostService postService; @@ -437,6 +444,7 @@ // return 0; // } + /** * 宸梾璐逛笂鎶� */ @@ -445,6 +453,20 @@ @PostMapping("/travelexpensereport") public AjaxResult travelexpensereport(@RequestBody CheckFundVO checkFundVO) { ServiceReimbursement serviceReimbursement = serviceReimbursementService.getById(checkFundVO.getFundid()); + //濡傛灉绛変簬100锛岃鏄庡凡缁忚蛋鍒板尰闄㈣储鍔¢偅杈逛簡锛涜储鍔¢偅杈瑰彇鏁版嵁鏄粠鍒嗕韩琛ㄥ彇锛屾墍浠ワ紝杩欓噷鐩存帴寰�鍒嗕韩琛ㄩ噷娣诲姞鏁版嵁灏辫浜� + if (serviceReimbursement.getBackflowlevel() == 100 || serviceReimbursement.getBackflowlevel() == 199) { + + //灏嗕慨鏀圭殑涓婃姤鏁版嵁 鏂板涓�鏉� + ServiceReimbursementShared serviceReimbursementShared = DtoConversionUtils.sourceToTarget(serviceReimbursement, ServiceReimbursementShared.class); + serviceReimbursementShared.setId(null); + serviceReimbursementShared.setDelFlag(0L); + serviceReimbursementSharedService.save(serviceReimbursementShared); + + //灏嗛��鍥為樁娈佃缃垚100 + serviceReimbursement.setBackflowlevel(100L); + serviceReimbursementService.updateById(serviceReimbursement); + return success(); + } if (serviceReimbursement != null) { Integer TotalLevel = 0; LoginUser loginUser = getLoginUser(); @@ -453,10 +475,12 @@ if (!postids.contains(2)) { serviceReimbursement.setFlowlevel(1L); + serviceReimbursement.setBackflowlevel(1L); serviceReimbursement.setRecordstatus(2); } else { serviceReimbursement.setFlowlevel(0L); serviceReimbursement.setRecordstatus(0); + serviceReimbursement.setBackflowlevel(0L); } if (!postids.contains(2)) { @@ -489,6 +513,7 @@ @PostMapping("/checkfund") public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) { ServiceReimbursement serviceReimbursement = serviceReimbursementService.getById(checkFundVO.getFundid()); + if (serviceReimbursement != null) { Integer totalLevel = 0; LoginUser loginUser = getLoginUser(); @@ -514,6 +539,9 @@ Integer CheckFlag = 0; Integer RecordStatus = serviceReimbursement.getRecordstatus(); Integer FlowLevel = Integer.valueOf(serviceReimbursement.getFlowlevel().toString()); + if (Objects.isNull(serviceReimbursement.getBackflowlevel()) && !Objects.isNull(serviceReimbursement.getFlowlevel())) { + serviceReimbursement.setBackflowlevel(Long.valueOf(FlowLevel.toString())); + } Integer OriginalFlowLevel = FlowLevel; if (checkFundVO.getFlowconclusion() == 1) { CheckFlag = 1; @@ -530,16 +558,22 @@ FlowLevel = FlowLevel + 1; } else { CheckFlag = 2; - RecordStatus = (FlowLevel + 1) * 2 - 1; - FlowLevel = (FlowLevel - 1); - if (FlowLevel < 0) { + + if (CheckFlag == 2) { + //搴斿尰闄㈣姹傚鏋滃嚭鐜伴��鍥烇紝鐩存帴閫�鍒板彂璧疯�� FlowLevel = 0; + } else { + //涓嬮潰鏄師鏉ョ殑鍐欐硶锛屼竴绾т竴绾х殑寰�涓嬮��锛屽尰闄㈢幇鍦ㄤ笉瑕佽繖鏍锋悶浜嗭紝涓嬮潰杩欐浠g爜鍏堜繚鐣欙紝绛夊尰闄㈠洖蹇冭浆鎰忥紝鍐嶇粰鏀惧紑 + RecordStatus = (FlowLevel + 1) * 2 - 1; + FlowLevel = (FlowLevel - 1); + if (FlowLevel < 0) { + FlowLevel = 0; + } } } serviceReimbursement.setRecordstatus(RecordStatus); serviceReimbursement.setFlowlevel(Long.valueOf(FlowLevel.toString())); - ServiceFundflow serviceFundflow = new ServiceFundflow(); SysUser user = loginUser.getUser(); serviceFundflow.setFundid(serviceReimbursement.getId()); diff --git a/ruoyi-admin/src/main/resources/application.yml b/ruoyi-admin/src/main/resources/application.yml index d64eb23..2f5501a 100644 --- a/ruoyi-admin/src/main/resources/application.yml +++ b/ruoyi-admin/src/main/resources/application.yml @@ -140,3 +140,7 @@ excludes: /system/notice # 鍖归厤閾炬帴 urlPatterns: /system/*,/monitor/*,/tool/* + +#閽夐拤鐨勫瘑閽� +dingAppid: dingn8iip5ubj7clrrsv +dingAppSecret: qlEK8D3oOVwGPOTiBQIBYTqQVlAfy9S_qQizEQFjJdSScwemWFryg4gbneu-NqWD diff --git a/ruoyi-project/pom.xml b/ruoyi-project/pom.xml index c33bc74..820fe03 100644 --- a/ruoyi-project/pom.xml +++ b/ruoyi-project/pom.xml @@ -27,6 +27,27 @@ <groupId>com.ruoyi</groupId> <artifactId>ruoyi-system</artifactId> </dependency> + <dependency> + <groupId>org.projectlombok</groupId> + <artifactId>lombok</artifactId> + <version>1.18.26</version> + </dependency> + <dependency> + <groupId>com.squareup.okhttp3</groupId> + <artifactId>okhttp</artifactId> + <version>4.10.0</version> + </dependency> + <dependency> + <groupId>com.aliyun</groupId> + <artifactId>alibaba-dingtalk-service-sdk</artifactId> + <version>2.0.0</version> + </dependency> + <!-- 闃块噷JSON瑙f瀽鍣� --> + <dependency> + <groupId>com.alibaba.fastjson2</groupId> + <artifactId>fastjson2</artifactId> + <version>2.0.25</version> + </dependency> </dependencies> </project> \ No newline at end of file diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFund.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFund.java index 60503db..7d2a7c7 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFund.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFund.java @@ -205,6 +205,12 @@ @ApiModelProperty("褰撳墠瀹℃牳绾у埆") private int flowlevel; + /** + * 澶勪簬鍝釜闃舵 0锛氱敵璇凤紱1锛氫竴绾у鏍革紱2锛氫簩绾у鏍革紱3锛氫笁绾у鏍哥瓑 100锛氬尰闄㈣储鍔� 199:鍖婚櫌椹冲洖 + */ + @ApiModelProperty("閫�鍥炲鏍哥骇鍒�") + private int backflowlevel; + /** 绋庡墠閲戦 */ @ApiModelProperty("绋庡墠閲戦") @Excel(name = "绋庡墠閲戦") diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundShared.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundShared.java index 3bd7e20..06fd6fd 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundShared.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFundShared.java @@ -256,5 +256,10 @@ @Excel(name = "璁板綍鐘舵��") private long serfunid; + + @ApiModelProperty("璐㈠姟椹冲洖淇℃伅锛氬鍚�+' '+鏃堕棿+' '+鎰忚") + @Excel(name = "璐㈠姟椹冲洖淇℃伅锛氬鍚�+' '+鏃堕棿+' '+鎰忚") + private String cxrjyj; + } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursement.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursement.java index 5e998e3..4c0ed0d 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursement.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursement.java @@ -13,163 +13,222 @@ /** * 鎶ラ攢鐢宠瀵硅薄 service_reimbursement - * + * * @author ruoyi * @date 2022-01-24 */ @Data @ApiModel("鎶ラ攢鐢宠") -public class ServiceReimbursement extends BaseEntity -{ +public class ServiceReimbursement 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; - /** 鎶ラ攢浜虹紪鍙� */ + /** + * 鎶ラ攢浜虹紪鍙� + */ @ApiModelProperty("鎶ラ攢浜虹紪鍙�") @Excel(name = "鎶ラ攢浜虹紪鍙�") private String userno; - /** 鎶ラ攢浜哄鍚� */ + /** + * 鎶ラ攢浜哄鍚� + */ @ApiModelProperty("鎶ラ攢浜哄鍚�") @Excel(name = "鎶ラ攢浜哄鍚�") private String username; - /** 璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType */ + /** + * 璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType + */ @ApiModelProperty("璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType") @Excel(name = "璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType") private String idcardtype; - /** 璇佷欢鍙风爜 */ + /** + * 璇佷欢鍙风爜 + */ @ApiModelProperty("璇佷欢鍙风爜") @Excel(name = "璇佷欢鍙风爜") private String idcardno; - /** 鑱旂郴鐢佃瘽 */ + /** + * 鑱旂郴鐢佃瘽 + */ @ApiModelProperty("鑱旂郴鐢佃瘽") @Excel(name = "鑱旂郴鐢佃瘽") private String phone; - /** 寮�鎴烽摱琛� */ + /** + * 寮�鎴烽摱琛� + */ @ApiModelProperty("寮�鎴烽摱琛�") @Excel(name = "寮�鎴烽摱琛�") private String depositbank; - /** 鍗″彿 */ + /** + * 鍗″彿 + */ @ApiModelProperty("鍗″彿") @Excel(name = "鍗″彿") private String bankcardno; - /** 鍒嗚鍚嶇О */ + /** + * 鍒嗚鍚嶇О + */ @ApiModelProperty("鍒嗚鍚嶇О") @Excel(name = "鍒嗚鍚嶇О") private String branchbankname; - /** 閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑 */ + /** + * 閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑 + */ @ApiModelProperty("閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") @Excel(name = "閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") private String annexbankcard; - /** 闄勪欢璺緞 澶氫釜鐢�;鍒嗗紑 */ + /** + * 闄勪欢璺緞 澶氫釜鐢�;鍒嗗紑 + */ @ApiModelProperty("闄勪欢璺緞 澶氫釜鐢�;鍒嗗紑") @Excel(name = "闄勪欢璺緞 澶氫釜鐢�;鍒嗗紑") private String annexfiles; - /** 鐢宠閲戦 */ + /** + * 鐢宠閲戦 + */ @ApiModelProperty("鐢宠閲戦") @Excel(name = "鐢宠閲戦") private Double amountrequested; - /** 棰勬敮璐圭敤 */ + /** + * 棰勬敮璐圭敤 + */ @ApiModelProperty("棰勬敮璐圭敤") @Excel(name = "棰勬敮璐圭敤") private Double prepaidamount; - /** 鍙戠エ寮犳暟 */ + /** + * 鍙戠エ寮犳暟 + */ @ApiModelProperty("鍙戠エ寮犳暟") @Excel(name = "鍙戠エ寮犳暟") private Long invoicecount; - /** 闄勪欢鏁� */ + /** + * 闄勪欢鏁� + */ @ApiModelProperty("闄勪欢鏁�") @Excel(name = "闄勪欢鏁�") private Long attachcount; - /** 閮ㄩ棬涓荤宸ュ彿 */ + /** + * 閮ㄩ棬涓荤宸ュ彿 + */ @ApiModelProperty("閮ㄩ棬涓荤宸ュ彿") @Excel(name = "閮ㄩ棬涓荤宸ュ彿") private String managerno; - /** 閮ㄩ棬涓荤鍚嶅瓧 */ + /** + * 閮ㄩ棬涓荤鍚嶅瓧 + */ @ApiModelProperty("閮ㄩ棬涓荤鍚嶅瓧") @Excel(name = "閮ㄩ棬涓荤鍚嶅瓧") private String managername; - /** 閮ㄩ棬缂栧彿 */ + /** + * 閮ㄩ棬缂栧彿 + */ @ApiModelProperty("閮ㄩ棬缂栧彿") @Excel(name = "閮ㄩ棬缂栧彿") private String deptmentno; - /** 閮ㄩ棬鍚嶇О */ + /** + * 閮ㄩ棬鍚嶇О + */ @ApiModelProperty("閮ㄩ棬鍚嶇О") @Excel(name = "閮ㄩ棬鍚嶇О") private String deptmentname; - /** 涓績绛惧瓧 */ + /** + * 涓績绛惧瓧 + */ @ApiModelProperty("涓績绛惧瓧") @Excel(name = "涓績绛惧瓧") private String opochecker; - /** 璐㈠姟鍓櫌闀跨瀛� */ + /** + * 璐㈠姟鍓櫌闀跨瀛� + */ @ApiModelProperty("璐㈠姟鍓櫌闀跨瀛�") @Excel(name = "璐㈠姟鍓櫌闀跨瀛�") private String finvicepresident; - /** 涓氬姟鍓櫌闀跨瀛� */ + /** + * 涓氬姟鍓櫌闀跨瀛� + */ @ApiModelProperty("涓氬姟鍓櫌闀跨瀛�") @Excel(name = "涓氬姟鍓櫌闀跨瀛�") private String busvicepresident; - /** 鍔炲叕瀹や富浠荤瀛� */ + /** + * 鍔炲叕瀹や富浠荤瀛� + */ @ApiModelProperty("鍔炲叕瀹や富浠荤瀛�") @Excel(name = "鍔炲叕瀹や富浠荤瀛�") private String officedirector; - /** 璐㈠姟瀹や富浠荤瀛� */ + /** + * 璐㈠姟瀹や富浠荤瀛� + */ @ApiModelProperty("璐㈠姟瀹や富浠荤瀛�") @Excel(name = "璐㈠姟瀹や富浠荤瀛�") private String financedirector; - /** 璐㈠姟瀹℃牳 */ + /** + * 璐㈠姟瀹℃牳 + */ @ApiModelProperty("璐㈠姟瀹℃牳") @Excel(name = "璐㈠姟瀹℃牳") private String financechecher; - /** 鍏宠仈service_donatebaseinfo琛ㄧ殑ID */ + /** + * 鍏宠仈service_donatebaseinfo琛ㄧ殑ID + */ @ApiModelProperty("鍏宠仈service_donatebaseinfo琛ㄧ殑ID") @Excel(name = "鍏宠仈service_donatebaseinfo琛ㄧ殑ID") private Long infoid; - /** 鎹愮尞鑰呯紪鍙� */ + /** + * 鎹愮尞鑰呯紪鍙� + */ @ApiModelProperty("鎹愮尞鑰呯紪鍙�") @Excel(name = "鎹愮尞鑰呯紪鍙�") private String donorno; - /** 璁板綍鐘舵�� */ + /** + * 璁板綍鐘舵�� + */ @ApiModelProperty("璁板綍鐘舵��") @Excel(name = "璁板綍鐘舵��") private Integer recordstatus; - /** 涓婁紶鏍囧織 */ + /** + * 涓婁紶鏍囧織 + */ @ApiModelProperty("涓婁紶鏍囧織") @Excel(name = "涓婁紶鏍囧織") private String uploadflag; - /** 涓婁紶鏃堕棿 */ + /** + * 涓婁紶鏃堕棿 + */ @ApiModelProperty("涓婁紶鏃堕棿") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @Excel(name = "涓婁紶鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") @@ -191,22 +250,35 @@ @ApiModelProperty("鎬婚噾棰濈殑澶у啓") private String bigstrmoney; - /** 闄勪欢鍦板潃锛宎dd by yangjb 20221124 */ + /** + * 闄勪欢鍦板潃锛宎dd by yangjb 20221124 + */ @ApiModelProperty("闄勪欢鍦板潃") private String fileurl; private String remark; - /** 褰撳墠瀹℃牳绾у埆 澶勪簬鍝釜闃舵 0锛氱敵璇凤紱1锛氫竴绾у鏍革紱2锛氫簩绾у鏍革紱3锛氫笁绾у鏍哥瓑 */ + /** + * 褰撳墠瀹℃牳绾у埆 澶勪簬鍝釜闃舵 0锛氱敵璇凤紱1锛氫竴绾у鏍革紱2锛氫簩绾у鏍革紱3锛氫笁绾у鏍哥瓑 + */ @ApiModelProperty("褰撳墠瀹℃牳绾у埆") private Long flowlevel; + /** + * 99:瀹℃壒椹冲洖 100锛氫笂浼犲尰闄� 199锛氬尰闄㈤┏鍥� + */ + @ApiModelProperty("閫�鍥炴椂鐨勫鏍哥骇鍒�") + private Long backflowlevel; - /** 璐圭敤褰掑睘锛�0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞� */ + /** + * 璐圭敤褰掑睘锛�0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞� + */ @ApiModelProperty("璐圭敤褰掑睘") private String costtype; - /** 璐圭敤褰掑睘鎻忚堪 */ + /** + * 璐圭敤褰掑睘鎻忚堪 + */ @ApiModelProperty("璐圭敤褰掑睘鎻忚堪") private String costtypename; @@ -229,6 +301,10 @@ @ApiModelProperty("鐢宠鏃堕棿") private Date createTime; + + @ApiModelProperty("鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�") + private Integer delFlag; + // @ApiModelProperty("寮�濮嬫椂闂�") // private Date starttime; // diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementShared.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementShared.java index b73c2db..a1b4d20 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementShared.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementShared.java @@ -262,6 +262,9 @@ @ApiModelProperty("鎹愮尞瀹跺睘浜烘暟") private Integer donorrelatives; + @ApiModelProperty("璐㈠姟绯荤粺椹冲洖淇℃伅锛氬鍚�+' '+鏃堕棿+' '+鎰忚") + private String cxrjyj; + @Override public String toString() { return "ServiceReimbursementShared{" + diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java index b06dba2..1f215fa 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java @@ -59,6 +59,11 @@ @Excel(name = "寮�鎴烽摱琛�") private String bankname; + /** 鍒犻櫎 */ + @ApiModelProperty("鍒犻櫎") + @Excel(name = "鍒犻櫎") + private Integer delFlag; + /** 澶囨敞 */ @ApiModelProperty("澶囨敞") @Excel(name = "澶囨敞") diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DingTalkReqVo.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DingTalkReqVo.java new file mode 100644 index 0000000..1b2afdd --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/DingTalkReqVo.java @@ -0,0 +1,51 @@ +package com.ruoyi.project.domain.vo; + +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.List; +import java.util.Map; +import java.util.concurrent.ConcurrentHashMap; + +/** + * 閽夐拤娑堟伅鍙戦�� + * + * @author ls + * @date 2023-07-14 + */ +@Data +@ApiModel(value = "DingTalkReqVo", description = "閽夐拤娑堟伅鍙戦��") +public class DingTalkReqVo extends BaseEntity { + + /** + * 鍙戦�佸唴瀹� + */ + @ApiModelProperty(value = "鍙戦�佸唴瀹�") + private List<ConcurrentHashMap<String, String>> contents; + + /** + * 鐢ㄦ埛閽夐拤鍙� + */ + @ApiModelProperty(value = "鐢ㄦ埛鎵嬫満鍙�") + private String number; + + /** + * 閮ㄩ棬ID + */ + @ApiModelProperty(value = "閮ㄩ棬ID") + private Long deptId; + + /** + * 鍙戦�佹秷鎭殑鏍囬 + */ + @ApiModelProperty(value = "鍙戦�佹秷鎭殑鏍囬") + private String title; + + /** + * 璺宠浆url + */ + @ApiModelProperty(value = "璺宠浆url") + private String url; +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFundSharedMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFundSharedMapper.java index 6f79e78..5c5d5aa 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFundSharedMapper.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFundSharedMapper.java @@ -24,4 +24,6 @@ public List<ServiceFundShared> selectServiceFundSharedList(ServiceFundShared serviceFundShared); List<ServiceFundShared> getFundShareInfoById(Long fundid); + + Boolean delfundsharedInfoById(Long fundId); } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java index 4ab866a..5f5e1ab 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailMapper.java @@ -46,4 +46,7 @@ public List<ServiceFunddetail> getDataBybeneficiaryNo(FunddetailReqVo funddetailReqVo); List<ServiceFunddetail> getTaxBeforeByBeneFiciaryNo(TaxMoneyVO taxMoneyV); -} + + + + } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementSharedMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementSharedMapper.java index 50ae48c..7d3d11e 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementSharedMapper.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementSharedMapper.java @@ -1,19 +1,20 @@ package com.ruoyi.project.mapper; + import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.project.domain.ServiceReimbursementShared; +import org.apache.ibatis.annotations.Mapper; import java.util.List; - /** * 鎶ラ攢鐢宠Mapper鎺ュ彛 - * + * * @author ruoyi * @date 2023-01-10 */ -public interface ServiceReimbursementSharedMapper extends BaseMapper<ServiceReimbursementShared> -{ +@Mapper +public interface ServiceReimbursementSharedMapper extends BaseMapper<ServiceReimbursementShared> { /** * 鏌ヨ鎶ラ攢鐢宠鍒楄〃 * @@ -23,4 +24,6 @@ public List<ServiceReimbursementShared> selectServiceReimbursementSharedList(ServiceReimbursementShared serviceReimbursementShared); List<ServiceReimbursementShared> getRemShareInfoByRemId(Long RemId); + + Boolean delResharedInfoById(Long id); } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/DingTalkService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/DingTalkService.java new file mode 100644 index 0000000..02e099f --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/DingTalkService.java @@ -0,0 +1,18 @@ +package com.ruoyi.project.service; + +import com.ruoyi.project.domain.vo.DingTalkReqVo; + +/** + * 瀹f暀鍒嗙被Service鎺ュ彛 + * + * @author smartor + * @date 2023-03-04 + */ +public interface DingTalkService { + /** + * 鍙戦�侀拤閽夋秷鎭� + * + * @param dingTalkReqVo + */ + Boolean sendNotification(DingTalkReqVo dingTalkReqVo); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFundSharedService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFundSharedService.java index fec5cf7..71ab174 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFundSharedService.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFundSharedService.java @@ -2,24 +2,29 @@ import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.project.domain.ServiceFundShared; +import com.ruoyi.project.domain.ServiceReimbursementShared; import java.util.List; /** * 璐圭敤鐢宠涓籗ervice鎺ュ彛 - * + * * @author ruoyi * @date 2023-03-27 */ -public interface IServiceFundSharedService extends IService<ServiceFundShared> -{ +public interface IServiceFundSharedService extends IService<ServiceFundShared> { /** * 鏌ヨ璐圭敤鐢宠涓诲垪琛� - * + * * @param serviceFundShared 璐圭敤鐢宠涓� * @return 璐圭敤鐢宠涓婚泦鍚� */ - public List<ServiceFundShared> queryList(ServiceFundShared serviceFundShared); + List<ServiceFundShared> queryList(ServiceFundShared serviceFundShared); + + List<ServiceFundShared> queryFundShareList(); + List<ServiceFundShared> getFundShareInfoById(Long fundid); + + Boolean delfundsharedInfoById(Long fundId); } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementSharedService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementSharedService.java index fed44c8..ca14a0c 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementSharedService.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementSharedService.java @@ -7,19 +7,28 @@ /** * 鎶ラ攢鐢宠Service鎺ュ彛 - * + * * @author ruoyi * @date 2023-01-10 */ -public interface IServiceReimbursementSharedService extends IService<ServiceReimbursementShared> -{ +public interface IServiceReimbursementSharedService extends IService<ServiceReimbursementShared> { /** * 鏌ヨ鎶ラ攢鐢宠鍒楄〃 - * + * * @param serviceReimbursementShared 鎶ラ攢鐢宠 * @return 鎶ラ攢鐢宠闆嗗悎 */ public List<ServiceReimbursementShared> queryList(ServiceReimbursementShared serviceReimbursementShared); + List<ServiceReimbursementShared> getRemShareInfoByRemId(Long remeid); + + /** + * 鏌ヨ琚��鍥炵殑锛屽苟涓旀病鏈夊垹闄ょ殑鏁版嵁 + * + * @return + */ + List<ServiceReimbursementShared> queryReShareList(); + + Boolean delResharedInfoById(Long remid); } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/DingTalkServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/DingTalkServiceImpl.java new file mode 100644 index 0000000..51d48ef --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/DingTalkServiceImpl.java @@ -0,0 +1,162 @@ +package com.ruoyi.project.service.impl; + +import com.alibaba.fastjson2.JSONArray; +import com.alibaba.fastjson2.JSONObject; +import com.dingtalk.api.DefaultDingTalkClient; +import com.dingtalk.api.DingTalkClient; +import com.dingtalk.api.request.OapiGettokenRequest; +import com.dingtalk.api.request.OapiMessageCorpconversationAsyncsendV2Request; +import com.dingtalk.api.request.OapiUserListidRequest; +import com.dingtalk.api.request.OapiV2UserGetbymobileRequest; +import com.dingtalk.api.response.OapiGettokenResponse; +import com.dingtalk.api.response.OapiMessageCorpconversationAsyncsendV2Response; +import com.dingtalk.api.response.OapiUserListidResponse; +import com.dingtalk.api.response.OapiV2UserGetbymobileResponse; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.project.domain.vo.DingTalkReqVo; +import com.ruoyi.project.service.DingTalkService; +import com.taobao.api.ApiException; +import lombok.extern.log4j.Log4j; +import org.springframework.beans.factory.annotation.Value; +import org.springframework.stereotype.Service; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; +import java.util.concurrent.ConcurrentHashMap; + +/** + * 鏅鸿兘涓績 + * + * @author ls + * @date 2023-05-23 + */ +@Service +@Log4j +public class DingTalkServiceImpl implements DingTalkService { + + + @Value("${dingAppid}") + private String dingAppid; + + @Value("${dingAppSecret}") + private String dingAppSecret; + + @Override + public Boolean sendNotification(DingTalkReqVo dingTalkReqVo) { + String body = null; + List<String> userIdlist = new ArrayList(); + Boolean result = false; + log.info("鍙戦�侀拤閽夐�氱煡"); + + String accessToken = null; + try { + accessToken = getAccessToken(); + } catch (ApiException e) { + e.printStackTrace(); + } + if (StringUtils.isNotEmpty(dingTalkReqVo.getNumber())) { + DingTalkClient clientT = new DefaultDingTalkClient("https://oapi.dingtalk.com/topapi/v2/user/getbymobile"); + OapiV2UserGetbymobileRequest req = new OapiV2UserGetbymobileRequest(); + req.setMobile(dingTalkReqVo.getNumber()); + OapiV2UserGetbymobileResponse rsp = null; + try { + rsp = clientT.execute(req, accessToken); + body = rsp.getBody(); + String jsonObject = JSONObject.parseObject(body).getJSONObject("result").get("userid").toString(); + userIdlist.add(jsonObject); + + } catch (ApiException e) { + e.printStackTrace(); + } + } else { + DingTalkClient client3 = new DefaultDingTalkClient("https://oapi.dingtalk.com/topapi/user/listid"); + + OapiUserListidRequest request2 = new OapiUserListidRequest(); + request2.setDeptId(dingTalkReqVo.getDeptId()); // 璁剧疆瑕佽幏鍙栫殑閮ㄩ棬 ID锛岃繖閲屼互鏍归儴闂ㄤ负渚�675909059L + // 璁剧疆閮ㄩ棬 ID锛屽鏋滆幏鍙栨墍鏈夊憳宸ユ墜鏈哄彿锛屽彲浠ヨ缃负鏍归儴闂ㄧ殑 ID + OapiUserListidResponse response2 = null; + try { + response2 = client3.execute(request2, accessToken); + } catch (ApiException e) { + e.printStackTrace(); + } + body = response2.getBody(); + // 瑙f瀽涓篔SONObject + JSONObject jsonObject = JSONObject.parseObject(body); + // 鎻愬彇鍑篔SONArray + JSONArray jsonArray = new JSONArray(jsonObject.getJSONObject("result").getJSONArray("userid_list")); + // 灏咼SONArray杞负List鍒楄〃 + String str = JSONObject.toJSONString(jsonArray); + userIdlist = JSONObject.parseObject(str, List.class); + } + + + //userid鏁扮粍 + for (String urid : userIdlist) { + DingTalkClient client = new DefaultDingTalkClient("https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2"); + OapiMessageCorpconversationAsyncsendV2Request request = new OapiMessageCorpconversationAsyncsendV2Request(); + request.setUseridList(urid); + request.setAgentId(1779052814L); + request.setToAllUser(false); + + //鍙戦�佸唴瀹瑰鐞� + List<ConcurrentHashMap<String, String>> contents = dingTalkReqVo.getContents(); + ArrayList<OapiMessageCorpconversationAsyncsendV2Request.Form> objects = new ArrayList<>(); + for (int i = 0; i < contents.size(); i++) { + ConcurrentHashMap<String, String> map = contents.get(i); + for (Map.Entry<String, String> entry : map.entrySet()) { + OapiMessageCorpconversationAsyncsendV2Request.Form formSeverityDesc = new OapiMessageCorpconversationAsyncsendV2Request.Form(); + formSeverityDesc.setKey(entry.getKey()); + formSeverityDesc.setValue(entry.getValue()); + objects.add(formSeverityDesc); + } + } + + OapiMessageCorpconversationAsyncsendV2Request.Msg msg = new OapiMessageCorpconversationAsyncsendV2Request.Msg(); + msg.setOa(new OapiMessageCorpconversationAsyncsendV2Request.OA()); + msg.getOa().setMessageUrl(dingTalkReqVo.getUrl()); + msg.getOa().setPcMessageUrl(dingTalkReqVo.getUrl()); + msg.getOa().setHead(new OapiMessageCorpconversationAsyncsendV2Request.Head()); + // msg.getOa().getHead().setText("浣犲湪璇村暐鍛㈢粧椤舵浛鑻涘ず闃挎柉钂傝姮闃挎柉钂傝姮"); + msg.getOa().getHead().setBgcolor("00409eff"); + msg.getOa().setBody(new OapiMessageCorpconversationAsyncsendV2Request.Body()); + msg.getOa().getBody().setTitle(dingTalkReqVo.getTitle()); + // msg.getOa().getBody().setContent("寰呭鐞�:" + "123" + "鏉�"); + + msg.getOa().getBody().setForm(objects); + msg.setMsgtype("oa"); + request.setMsg(msg); + // log.info("鑾峰彇鍙戦�侀�氱煡娑堟伅浣撳拰鑾峰彇鍙戦�侀�氱煡浜哄畬鎴�"); + OapiMessageCorpconversationAsyncsendV2Response response = null; + try { + response = client.execute(request, accessToken); + } catch (ApiException e) { + e.printStackTrace(); + } + + // log.info("娑堟伅浠诲姟ID"+response.getTaskId()); + System.out.println(response.getTaskId()); + + result = response.isSuccess(); + } + return result; + } + + + /** + * 鑾峰彇 access_token + */ + private String getAccessToken() throws ApiException { + DefaultDingTalkClient client = new DefaultDingTalkClient("https://oapi.dingtalk.com/gettoken"); + OapiGettokenRequest request = new OapiGettokenRequest(); + //Appkey + request.setAppkey(dingAppid); + //Appsecret + request.setAppsecret(dingAppSecret); + /*璇锋眰鏂瑰紡*/ + request.setHttpMethod("GET"); + OapiGettokenResponse response = client.execute(request); + return response.getAccessToken(); + } +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundServiceImpl.java index 07c8815..b6b850a 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundServiceImpl.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundServiceImpl.java @@ -643,7 +643,6 @@ return count; } - int uploadOAFileAndUpdateDb(ServiceFundShared remShare) { //涓婁紶OA鏂囦欢 //String strUrl = "http://129.88.242.39:8899/seeyon/rest/token?userName=opo&password=127814f8-84e8-4304-84a5-a71573567efd&loginName=demo3"; diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundSharedServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundSharedServiceImpl.java index 25b35c3..94c632c 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundSharedServiceImpl.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFundSharedServiceImpl.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.project.domain.ServiceFundShared; +import com.ruoyi.project.domain.ServiceReimbursementShared; import com.ruoyi.project.mapper.ServiceFundSharedMapper; import com.ruoyi.project.service.IServiceFundSharedService; import org.springframework.beans.factory.annotation.Autowired; @@ -171,9 +172,24 @@ } @Override + public List<ServiceFundShared> queryFundShareList() { + LambdaQueryWrapper<ServiceFundShared> wrappers = Wrappers.lambdaQuery(); + wrappers.eq(ServiceFundShared::getDel_flag, 0); + wrappers.isNotNull(ServiceFundShared::getCxrjyj); + + return this.list(wrappers); + } + + @Override public List<ServiceFundShared> getFundShareInfoById(Long fundid) { return serviceFundSharedMapper.getFundShareInfoById(fundid); // return null; } + + @Override + public Boolean delfundsharedInfoById(Long fundId) { + return serviceFundSharedMapper.delfundsharedInfoById(fundId); + } + } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementServiceImpl.java index 24e7c38..6da9c5e 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementServiceImpl.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementServiceImpl.java @@ -17,6 +17,7 @@ import com.ruoyi.project.service.IServiceReimbursementdetailSharedService; import com.ruoyi.project.service.IServiceReimbursementpayeeSharedService; import lombok.extern.slf4j.Slf4j; +import org.apache.commons.lang3.ObjectUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; @@ -72,6 +73,9 @@ @Override public List<ServiceReimbursement> queryList(ServiceReimbursement serviceReimbursement) { LambdaQueryWrapper<ServiceReimbursement> wrappers = Wrappers.lambdaQuery(); + if (ObjectUtils.isNotEmpty(serviceReimbursement.getId())) { + wrappers.eq(ServiceReimbursement::getId, serviceReimbursement.getId()); + } if (StringUtils.isNotBlank(serviceReimbursement.getCreateBy())) { wrappers.eq(ServiceReimbursement::getCreateBy, serviceReimbursement.getCreateBy()); } diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementSharedServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementSharedServiceImpl.java index 754b633..a8fb075 100644 --- a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementSharedServiceImpl.java +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementSharedServiceImpl.java @@ -14,13 +14,12 @@ /** * 鎶ラ攢鐢宠Service涓氬姟灞傚鐞� - * + * * @author ruoyi * @date 2023-01-10 */ @Service -public class ServiceReimbursementSharedServiceImpl extends ServiceImpl<ServiceReimbursementSharedMapper, ServiceReimbursementShared> implements IServiceReimbursementSharedService -{ +public class ServiceReimbursementSharedServiceImpl extends ServiceImpl<ServiceReimbursementSharedMapper, ServiceReimbursementShared> implements IServiceReimbursementSharedService { @Autowired @@ -28,144 +27,159 @@ /** * 鏌ヨ鎶ラ攢鐢宠鍒楄〃 - * + * * @param serviceReimbursementShared 鎶ラ攢鐢宠 * @return 鎶ラ攢鐢宠 */ @Override public List<ServiceReimbursementShared> queryList(ServiceReimbursementShared serviceReimbursementShared) { LambdaQueryWrapper<ServiceReimbursementShared> wrappers = Wrappers.lambdaQuery(); - if (StringUtils.isNotBlank(serviceReimbursementShared.getUserno())){ - wrappers.eq(ServiceReimbursementShared::getUserno ,serviceReimbursementShared.getUserno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getUserno())) { + wrappers.eq(ServiceReimbursementShared::getUserno, serviceReimbursementShared.getUserno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getUsername())){ - wrappers.like(ServiceReimbursementShared::getUsername ,serviceReimbursementShared.getUsername()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getUsername())) { + wrappers.like(ServiceReimbursementShared::getUsername, serviceReimbursementShared.getUsername()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getTravelers())){ - wrappers.eq(ServiceReimbursementShared::getTravelers ,serviceReimbursementShared.getTravelers()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getTravelers())) { + wrappers.eq(ServiceReimbursementShared::getTravelers, serviceReimbursementShared.getTravelers()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getIdcardtype())){ - wrappers.eq(ServiceReimbursementShared::getIdcardtype ,serviceReimbursementShared.getIdcardtype()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getIdcardtype())) { + wrappers.eq(ServiceReimbursementShared::getIdcardtype, serviceReimbursementShared.getIdcardtype()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getIdcardno())){ - wrappers.eq(ServiceReimbursementShared::getIdcardno ,serviceReimbursementShared.getIdcardno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getIdcardno())) { + wrappers.eq(ServiceReimbursementShared::getIdcardno, serviceReimbursementShared.getIdcardno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getPhone())){ - wrappers.eq(ServiceReimbursementShared::getPhone ,serviceReimbursementShared.getPhone()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getPhone())) { + wrappers.eq(ServiceReimbursementShared::getPhone, serviceReimbursementShared.getPhone()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getDepositbank())){ - wrappers.eq(ServiceReimbursementShared::getDepositbank ,serviceReimbursementShared.getDepositbank()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getDepositbank())) { + wrappers.eq(ServiceReimbursementShared::getDepositbank, serviceReimbursementShared.getDepositbank()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getBankcardno())){ - wrappers.eq(ServiceReimbursementShared::getBankcardno ,serviceReimbursementShared.getBankcardno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getBankcardno())) { + wrappers.eq(ServiceReimbursementShared::getBankcardno, serviceReimbursementShared.getBankcardno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getBranchbankname())){ - wrappers.like(ServiceReimbursementShared::getBranchbankname ,serviceReimbursementShared.getBranchbankname()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getBranchbankname())) { + wrappers.like(ServiceReimbursementShared::getBranchbankname, serviceReimbursementShared.getBranchbankname()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getAnnexbankcard())){ - wrappers.eq(ServiceReimbursementShared::getAnnexbankcard ,serviceReimbursementShared.getAnnexbankcard()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getAnnexbankcard())) { + wrappers.eq(ServiceReimbursementShared::getAnnexbankcard, serviceReimbursementShared.getAnnexbankcard()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getAnnexfiles())){ - wrappers.eq(ServiceReimbursementShared::getAnnexfiles ,serviceReimbursementShared.getAnnexfiles()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getAnnexfiles())) { + wrappers.eq(ServiceReimbursementShared::getAnnexfiles, serviceReimbursementShared.getAnnexfiles()); } - if (serviceReimbursementShared.getAmountrequested() != null){ - wrappers.eq(ServiceReimbursementShared::getAmountrequested ,serviceReimbursementShared.getAmountrequested()); + if (serviceReimbursementShared.getAmountrequested() != null) { + wrappers.eq(ServiceReimbursementShared::getAmountrequested, serviceReimbursementShared.getAmountrequested()); } - if (serviceReimbursementShared.getPrepaidamount() != null){ - wrappers.eq(ServiceReimbursementShared::getPrepaidamount ,serviceReimbursementShared.getPrepaidamount()); + if (serviceReimbursementShared.getPrepaidamount() != null) { + wrappers.eq(ServiceReimbursementShared::getPrepaidamount, serviceReimbursementShared.getPrepaidamount()); } - if (serviceReimbursementShared.getInvoicecount() != null){ - wrappers.eq(ServiceReimbursementShared::getInvoicecount ,serviceReimbursementShared.getInvoicecount()); + if (serviceReimbursementShared.getInvoicecount() != null) { + wrappers.eq(ServiceReimbursementShared::getInvoicecount, serviceReimbursementShared.getInvoicecount()); } - if (serviceReimbursementShared.getAttachcount() != null){ - wrappers.eq(ServiceReimbursementShared::getAttachcount ,serviceReimbursementShared.getAttachcount()); + if (serviceReimbursementShared.getAttachcount() != null) { + wrappers.eq(ServiceReimbursementShared::getAttachcount, serviceReimbursementShared.getAttachcount()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getManagerno())){ - wrappers.eq(ServiceReimbursementShared::getManagerno ,serviceReimbursementShared.getManagerno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getManagerno())) { + wrappers.eq(ServiceReimbursementShared::getManagerno, serviceReimbursementShared.getManagerno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getManagername())){ - wrappers.like(ServiceReimbursementShared::getManagername ,serviceReimbursementShared.getManagername()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getManagername())) { + wrappers.like(ServiceReimbursementShared::getManagername, serviceReimbursementShared.getManagername()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getDeptmentno())){ - wrappers.eq(ServiceReimbursementShared::getDeptmentno ,serviceReimbursementShared.getDeptmentno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getDeptmentno())) { + wrappers.eq(ServiceReimbursementShared::getDeptmentno, serviceReimbursementShared.getDeptmentno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getDeptmentname())){ - wrappers.like(ServiceReimbursementShared::getDeptmentname ,serviceReimbursementShared.getDeptmentname()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getDeptmentname())) { + wrappers.like(ServiceReimbursementShared::getDeptmentname, serviceReimbursementShared.getDeptmentname()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getOpochecker())){ - wrappers.eq(ServiceReimbursementShared::getOpochecker ,serviceReimbursementShared.getOpochecker()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getOpochecker())) { + wrappers.eq(ServiceReimbursementShared::getOpochecker, serviceReimbursementShared.getOpochecker()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getFinvicepresident())){ - wrappers.eq(ServiceReimbursementShared::getFinvicepresident ,serviceReimbursementShared.getFinvicepresident()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getFinvicepresident())) { + wrappers.eq(ServiceReimbursementShared::getFinvicepresident, serviceReimbursementShared.getFinvicepresident()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getBusvicepresident())){ - wrappers.eq(ServiceReimbursementShared::getBusvicepresident ,serviceReimbursementShared.getBusvicepresident()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getBusvicepresident())) { + wrappers.eq(ServiceReimbursementShared::getBusvicepresident, serviceReimbursementShared.getBusvicepresident()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getOfficedirector())){ - wrappers.eq(ServiceReimbursementShared::getOfficedirector ,serviceReimbursementShared.getOfficedirector()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getOfficedirector())) { + wrappers.eq(ServiceReimbursementShared::getOfficedirector, serviceReimbursementShared.getOfficedirector()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getFinancedirector())){ - wrappers.eq(ServiceReimbursementShared::getFinancedirector ,serviceReimbursementShared.getFinancedirector()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getFinancedirector())) { + wrappers.eq(ServiceReimbursementShared::getFinancedirector, serviceReimbursementShared.getFinancedirector()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getFinancechecher())){ - wrappers.eq(ServiceReimbursementShared::getFinancechecher ,serviceReimbursementShared.getFinancechecher()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getFinancechecher())) { + wrappers.eq(ServiceReimbursementShared::getFinancechecher, serviceReimbursementShared.getFinancechecher()); } - if (serviceReimbursementShared.getInfoid() != null){ - wrappers.eq(ServiceReimbursementShared::getInfoid ,serviceReimbursementShared.getInfoid()); + if (serviceReimbursementShared.getInfoid() != null) { + wrappers.eq(ServiceReimbursementShared::getInfoid, serviceReimbursementShared.getInfoid()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getDonorno())){ - wrappers.eq(ServiceReimbursementShared::getDonorno ,serviceReimbursementShared.getDonorno()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getDonorno())) { + wrappers.eq(ServiceReimbursementShared::getDonorno, serviceReimbursementShared.getDonorno()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getDonorname())){ - wrappers.like(ServiceReimbursementShared::getDonorname ,serviceReimbursementShared.getDonorname()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getDonorname())) { + wrappers.like(ServiceReimbursementShared::getDonorname, serviceReimbursementShared.getDonorname()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getReason())){ - wrappers.eq(ServiceReimbursementShared::getReason ,serviceReimbursementShared.getReason()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getReason())) { + wrappers.eq(ServiceReimbursementShared::getReason, serviceReimbursementShared.getReason()); } - if (serviceReimbursementShared.getRecordstatus() != null){ - wrappers.eq(ServiceReimbursementShared::getRecordstatus ,serviceReimbursementShared.getRecordstatus()); + if (serviceReimbursementShared.getRecordstatus() != null) { + wrappers.eq(ServiceReimbursementShared::getRecordstatus, serviceReimbursementShared.getRecordstatus()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getUploadflag())){ - wrappers.eq(ServiceReimbursementShared::getUploadflag ,serviceReimbursementShared.getUploadflag()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getUploadflag())) { + wrappers.eq(ServiceReimbursementShared::getUploadflag, serviceReimbursementShared.getUploadflag()); } - if (serviceReimbursementShared.getUploadtime() != null){ - wrappers.eq(ServiceReimbursementShared::getUploadtime ,serviceReimbursementShared.getUploadtime()); + if (serviceReimbursementShared.getUploadtime() != null) { + wrappers.eq(ServiceReimbursementShared::getUploadtime, serviceReimbursementShared.getUploadtime()); } - if (serviceReimbursementShared.getTotalamount() != null){ - wrappers.eq(ServiceReimbursementShared::getTotalamount ,serviceReimbursementShared.getTotalamount()); + if (serviceReimbursementShared.getTotalamount() != null) { + wrappers.eq(ServiceReimbursementShared::getTotalamount, serviceReimbursementShared.getTotalamount()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getBigstrmoney())){ - wrappers.eq(ServiceReimbursementShared::getBigstrmoney ,serviceReimbursementShared.getBigstrmoney()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getBigstrmoney())) { + wrappers.eq(ServiceReimbursementShared::getBigstrmoney, serviceReimbursementShared.getBigstrmoney()); } - if (serviceReimbursementShared.getFlowlevel() != null){ - wrappers.eq(ServiceReimbursementShared::getFlowlevel ,serviceReimbursementShared.getFlowlevel()); + if (serviceReimbursementShared.getFlowlevel() != null) { + wrappers.eq(ServiceReimbursementShared::getFlowlevel, serviceReimbursementShared.getFlowlevel()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getCosttype())){ - wrappers.eq(ServiceReimbursementShared::getCosttype ,serviceReimbursementShared.getCosttype()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getCosttype())) { + wrappers.eq(ServiceReimbursementShared::getCosttype, serviceReimbursementShared.getCosttype()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getCosttypename())){ - wrappers.like(ServiceReimbursementShared::getCosttypename ,serviceReimbursementShared.getCosttypename()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getCosttypename())) { + wrappers.like(ServiceReimbursementShared::getCosttypename, serviceReimbursementShared.getCosttypename()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getOaid())){ - wrappers.eq(ServiceReimbursementShared::getOaid ,serviceReimbursementShared.getOaid()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getOaid())) { + wrappers.eq(ServiceReimbursementShared::getOaid, serviceReimbursementShared.getOaid()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getOabdzt())){ - wrappers.eq(ServiceReimbursementShared::getOabdzt ,serviceReimbursementShared.getOabdzt()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getOabdzt())) { + wrappers.eq(ServiceReimbursementShared::getOabdzt, serviceReimbursementShared.getOabdzt()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getFilename())){ - wrappers.like(ServiceReimbursementShared::getFilename ,serviceReimbursementShared.getFilename()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getFilename())) { + wrappers.like(ServiceReimbursementShared::getFilename, serviceReimbursementShared.getFilename()); } - if (StringUtils.isNotBlank(serviceReimbursementShared.getFileid())){ - wrappers.eq(ServiceReimbursementShared::getFileid ,serviceReimbursementShared.getFileid()); + if (StringUtils.isNotBlank(serviceReimbursementShared.getFileid())) { + wrappers.eq(ServiceReimbursementShared::getFileid, serviceReimbursementShared.getFileid()); } + return this.list(wrappers); } @Override - public List<ServiceReimbursementShared> getRemShareInfoByRemId(Long remeid) - { + public List<ServiceReimbursementShared> queryReShareList() { + LambdaQueryWrapper<ServiceReimbursementShared> wrappers = Wrappers.lambdaQuery(); + wrappers.eq(ServiceReimbursementShared::getDelFlag, 0); + wrappers.isNotNull(ServiceReimbursementShared::getCxrjyj); + + return this.list(wrappers); + } + + @Override + public List<ServiceReimbursementShared> getRemShareInfoByRemId(Long remeid) { return serviceReimbursementSharedMapper.getRemShareInfoByRemId(remeid); - // return null; + // return null; + } + + @Override + public Boolean delResharedInfoById(Long id) { + + return serviceReimbursementSharedMapper.delResharedInfoById(id); } } diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFundMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFundMapper.xml index c2d6661..18e4417 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceFundMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFundMapper.xml @@ -1,76 +1,127 @@ <?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.ServiceFundMapper"> - - <resultMap type="ServiceFund" id="ServiceFundResult"> - <result property="id" column="ID" /> - <result property="infoid" column="InfoID" /> - <result property="donorno" column="DonorNo" /> - <result property="donorname" column="DonorName" /> - <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="userno" column="UserNo" /> - <result property="username" column="UserName" /> - <result property="unitname" column="UnitName" /> - <result property="unitno" column="UnitNo" /> - <result property="unituserno" column="UnitUserNo" /> - <result property="phone" column="Phone" /> - <result property="annexbankcard" column="AnnexBankCard" /> - <result property="annexregistform" column="AnnexRegistForm" /> - <result property="amountrequested" column="AmountRequested" /> - <result property="applytype" column="ApplyType" /> - <result property="prepaidamount" column="PrepaidAmount" /> - <result property="invoicecount" column="InvoiceCount" /> - <result property="attachcount" column="AttachCount" /> - <result property="managerno" column="ManagerNo" /> - <result property="managername" column="ManagerName" /> - <result property="deptmentno" column="DeptmentNo" /> - <result property="deptmentname" column="DeptmentName" /> - <result property="opochecker" column="OPOchecker" /> - <result property="finvicepresident" column="FinVicePresident" /> - <result property="busvicepresident" column="BusVicePresident" /> - <result property="officedirector" column="OfficeDirector" /> - <result property="financedirector" column="FinanceDirector" /> - <result property="totalcost" column="TotalCost" /> - <result property="procurementcost" column="ProcurementCost" /> - <result property="expertcost" column="ExpertCost" /> - <result property="ethicscost" column="EthicsCost" /> - <result property="medicalcost" column="MedicalCost" /> - <result property="familycost" column="FamilyCost" /> - <result property="aftercarecost" column="AftercareCost" /> - <result property="remark" column="Remark" /> - <result property="recordstatus" column="RecordStatus" /> - <result property="uploadflag" column="uploadflag" /> - <result property="uploadtime" column="uploadtime" /> - <result property="flowlevel" column="FlowLevel" /> - <result property="pretaxcost" column="PretaxCost" /> - <result property="taxedcost" column="TaxedCost" /> + + <resultMap type="com.ruoyi.project.domain.ServiceFund" id="ServiceFundResult"> + <result property="id" column="ID"/> + <result property="infoid" column="InfoID"/> + <result property="donorno" column="DonorNo"/> + <result property="donorname" column="DonorName"/> + <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="userno" column="UserNo"/> + <result property="username" column="UserName"/> + <result property="unitname" column="UnitName"/> + <result property="unitno" column="UnitNo"/> + <result property="unituserno" column="UnitUserNo"/> + <result property="phone" column="Phone"/> + <result property="annexbankcard" column="AnnexBankCard"/> + <result property="annexregistform" column="AnnexRegistForm"/> + <result property="amountrequested" column="AmountRequested"/> + <result property="applytype" column="ApplyType"/> + <result property="prepaidamount" column="PrepaidAmount"/> + <result property="invoicecount" column="InvoiceCount"/> + <result property="attachcount" column="AttachCount"/> + <result property="managerno" column="ManagerNo"/> + <result property="managername" column="ManagerName"/> + <result property="deptmentno" column="DeptmentNo"/> + <result property="deptmentname" column="DeptmentName"/> + <result property="opochecker" column="OPOchecker"/> + <result property="finvicepresident" column="FinVicePresident"/> + <result property="busvicepresident" column="BusVicePresident"/> + <result property="officedirector" column="OfficeDirector"/> + <result property="financedirector" column="FinanceDirector"/> + <result property="totalcost" column="TotalCost"/> + <result property="procurementcost" column="ProcurementCost"/> + <result property="expertcost" column="ExpertCost"/> + <result property="ethicscost" column="EthicsCost"/> + <result property="medicalcost" column="MedicalCost"/> + <result property="familycost" column="FamilyCost"/> + <result property="aftercarecost" column="AftercareCost"/> + <result property="remark" column="Remark"/> + <result property="recordstatus" column="RecordStatus"/> + <result property="uploadflag" column="uploadflag"/> + <result property="uploadtime" column="uploadtime"/> + <result property="flowlevel" column="FlowLevel"/> + <result property="pretaxcost" column="PretaxCost"/> + <result property="taxedcost" column="TaxedCost"/> + <result property="backflowlevel" column="backFlowLevel"/> + </resultMap> <sql id="selectServiceFundVo"> - select ID, InfoID, DonorNo, DonorName, del_flag, create_by, create_time, update_by, update_time, UserNo, UserName, UnitName, UnitNo, UnitUserNo, PretaxCost, TaxedCost, Phone, AnnexBankCard, AnnexRegistForm, AmountRequested, ApplyType, PrepaidAmount, InvoiceCount, AttachCount, ManagerNo, ManagerName, DeptmentNo, DeptmentName, OPOchecker, FinVicePresident, BusVicePresident, OfficeDirector, FinanceDirector, FinanceChecher, TotalCost, ProcurementCost, ExpertCost, EthicsCost, MedicalCost, FamilyCost, AftercareCost, Remark, RecordStatus, uploadflag, uploadtime,FlowLevel from service_fund + select ID, + InfoID, + DonorNo, + DonorName, + del_flag, + create_by, + create_time, + update_by, + update_time, + UserNo, + UserName, + UnitName, + UnitNo, + UnitUserNo, + PretaxCost, + TaxedCost, + Phone, + AnnexBankCard, + AnnexRegistForm, + AmountRequested, + ApplyType, + PrepaidAmount, + InvoiceCount, + AttachCount, + ManagerNo, + ManagerName, + DeptmentNo, + DeptmentName, + OPOchecker, + FinVicePresident, + BusVicePresident, + OfficeDirector, + FinanceDirector, + FinanceChecher, + TotalCost, + ProcurementCost, + ExpertCost, + EthicsCost, + MedicalCost, + FamilyCost, + AftercareCost, + Remark, + RecordStatus, + uploadflag, + uploadtime, + backflowlevel, + FlowLevel + from service_fund </sql> <select id="selectServiceFundList" parameterType="ServiceFund" resultMap="ServiceFundResult"> <include refid="selectServiceFundVo"/> where del_flag = '0' - <if test="donorno != null and donorno != ''"> and DonorNo = #{donorno}</if> - <if test="userno != null and userno != ''"> and UserNo = #{userno}</if> - <if test="username != null and username != ''"> and UserName like concat('%', #{username}, '%')</if> - <if test="applytype != null and applytype != ''"> and ApplyType = #{applytype}</if> - <if test="deptmentname != null and deptmentname != ''"> and DeptmentName like concat('%', #{deptmentname}, '%')</if> - <if test="recordstatus != null"> and RecordStatus = #{recordstatus}</if> - <if test="uploadflag != null and uploadflag != ''"> and uploadflag = #{uploadflag}</if> - <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if> - <if test="createBy != null and createBy != '' "> and create_by = #{createBy}</if> - <if test="infoid != null "> and InfoID = #{infoid}</if> - <if test="donorno != null and donorno != '' "> and DonorNo = #{donorno}</if> + <if test="donorno != null and donorno != ''">and DonorNo = #{donorno}</if> + <if test="userno != null and userno != ''">and UserNo = #{userno}</if> + <if test="username != null and username != ''">and UserName like concat('%', #{username}, '%')</if> + <if test="applytype != null and applytype != ''">and ApplyType = #{applytype}</if> + <if test="deptmentname != null and deptmentname != ''">and DeptmentName like concat('%', #{deptmentname}, + '%') + </if> + <if test="recordstatus != null">and RecordStatus = #{recordstatus}</if> + <if test="uploadflag != null and uploadflag != ''">and uploadflag = #{uploadflag}</if> + <if test="uploadtime != null ">and uploadtime = #{uploadtime}</if> + <if test="createBy != null and createBy != '' ">and create_by = #{createBy}</if> + <if test="infoid != null ">and InfoID = #{infoid}</if> + <if test="donorno != null and donorno != '' ">and DonorNo = #{donorno}</if> </select> <select id="getInfoByInfoId" resultType="com.ruoyi.project.domain.ServiceFund"> @@ -79,7 +130,8 @@ </select> <select id="getFundId" resultType="java.lang.Long"> - select max(ID) from service_fund + select max(ID) + from service_fund where infoid = #{infoid} </select> <select id="selectVOList" resultType="com.ruoyi.project.domain.vo.FundVO"> @@ -167,18 +219,19 @@ `service_fund`.`ID` = `service_funddetail`.`fundID` ))) <where> - <if test="donorno != null and donorno != ''"> and `service_fund`.`DonorNo` = #{donorno}</if> - <if test="userno != null and userno != ''"> and `service_fund`.`UserNo` = #{userno}</if> - <if test="username != null and username != ''"> and `service_fund`.`UserName` = #{username}</if> - <if test="unitname != null and unitname != ''"> and `service_fund`.`UnitName` = #{unitname}</if> - <if test="create_by != null and create_by != ''"> and `service_fund`.`create_by` = #{create_by}</if> - <if test="create_time != null and create_time != ''"> and `service_fund`.`create_time` = #{create_time}</if> + <if test="donorno != null and donorno != ''">and `service_fund`.`DonorNo` = #{donorno}</if> + <if test="userno != null and userno != ''">and `service_fund`.`UserNo` = #{userno}</if> + <if test="username != null and username != ''">and `service_fund`.`UserName` = #{username}</if> + <if test="unitname != null and unitname != ''">and `service_fund`.`UnitName` = #{unitname}</if> + <if test="create_by != null and create_by != ''">and `service_fund`.`create_by` = #{create_by}</if> + <if test="create_time != null and create_time != ''">and `service_fund`.`create_time` = #{create_time}</if> </where> </select> - <select id="getListBypower" statementType="CALLABLE" resultType="com.ruoyi.project.domain.vo.SpFinancialExpensesFundOut"> + <select id="getListBypower" statementType="CALLABLE" + resultType="com.ruoyi.project.domain.vo.SpFinancialExpensesFundOut"> call SP_FINANCIAL_EXPENSES(#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PAFUNDTYPE,mode=IN,jdbcType=INTEGER},#{PAAPPLICANT,mode=IN,jdbcType=VARCHAR},#{PAAPPLICATIONBEGTIME,mode=IN,jdbcType=VARCHAR},#{PAAPPLICATIONENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPARTMENT,mode=IN,jdbcType=VARCHAR},#{CHECKFLAG,mode=IN,jdbcType=INTEGER},#{APPLYTYPE,mode=IN,jdbcType=INTEGER}) </select> diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFundSharedMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFundSharedMapper.xml index 62028a4..a3a1715 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceFundSharedMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFundSharedMapper.xml @@ -116,5 +116,10 @@ <if test="fileid != null and fileid != ''"> and fileid = #{fileid}</if> </where> </select> - + <update id="delfundsharedInfoById"> + UPDATE service_fund_shared + SET del_flag = 1 + WHERE ID = #{fundId} + and del_flag != 1 + </update> </mapper> \ No newline at end of file diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml index 94e6adc..559137a 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml @@ -235,4 +235,5 @@ where create_time like concat(#{startTime}, '%') and beneficiaryNo=#{beneficiaryNo} </select> + </mapper> \ No newline at end of file diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementMapper.xml index 49a5689..55a9bab 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementMapper.xml @@ -4,7 +4,7 @@ "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.ruoyi.project.mapper.ServiceReimbursementMapper"> - <resultMap type="ServiceReimbursement" id="ServiceReimbursementResult"> + <resultMap type="com.ruoyi.project.domain.ServiceReimbursement" id="ServiceReimbursementResult"> <result property="id" column="ID"/> <result property="delFlag" column="del_flag"/> <result property="createBy" column="create_by"/> @@ -55,6 +55,7 @@ <result property="donorremark" column="donorremark"/> <result property="donoramount" column="donoramount"/> <result property="donorrelatives" column="donorrelatives"/> + <result property="backflowlevel" column="backFlowLevel"/> </resultMap> <sql id="selectServiceReimbursementVo"> @@ -105,11 +106,12 @@ donorbankcard, donorremark, donoramount, - donorrelatives + donorrelatives, + backFlowLevel from service_reimbursement </sql> - <select id="selectServiceReimbursementList" parameterType="ServiceReimbursement" + <select id="selectServiceReimbursementList" parameterType="com.ruoyi.project.domain.ServiceReimbursement" resultMap="ServiceReimbursementResult"> <include refid="selectServiceReimbursementVo"/> <where> diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementSharedMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementSharedMapper.xml index 438d475..437dadd 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementSharedMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementSharedMapper.xml @@ -1,120 +1,193 @@ <?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.ServiceReimbursementSharedMapper"> - - <resultMap type="ServiceReimbursementShared" id="ServiceReimbursementSharedResult"> - <result property="id" column="ID" /> - <result property="delFlag" 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="userno" column="UserNo" /> - <result property="username" column="UserName" /> - <result property="travelers" column="Travelers" /> - <result property="idcardtype" column="IDCardType" /> - <result property="idcardno" column="IDCardNo" /> - <result property="phone" column="Phone" /> - <result property="depositbank" column="DepositBank" /> - <result property="bankcardno" column="BankCardNo" /> - <result property="branchbankname" column="BranchBankName" /> - <result property="annexbankcard" column="AnnexBankCard" /> - <result property="annexfiles" column="AnnexFiles" /> - <result property="amountrequested" column="AmountRequested" /> - <result property="prepaidamount" column="PrepaidAmount" /> - <result property="invoicecount" column="InvoiceCount" /> - <result property="attachcount" column="AttachCount" /> - <result property="managerno" column="ManagerNo" /> - <result property="managername" column="ManagerName" /> - <result property="deptmentno" column="DeptmentNo" /> - <result property="deptmentname" column="DeptmentName" /> - <result property="opochecker" column="OPOchecker" /> - <result property="finvicepresident" column="FinVicePresident" /> - <result property="busvicepresident" column="BusVicePresident" /> - <result property="officedirector" column="OfficeDirector" /> - <result property="financedirector" column="FinanceDirector" /> - <result property="financechecher" column="FinanceChecher" /> - <result property="infoid" column="InfoID" /> - <result property="donorno" column="DonorNo" /> - <result property="donorname" column="DonorName" /> - <result property="reason" column="Reason" /> - <result property="remark" column="remark" /> - <result property="recordstatus" column="RecordStatus" /> - <result property="uploadflag" column="uploadflag" /> - <result property="uploadtime" column="uploadtime" /> - <result property="totalamount" column="totalAmount" /> - <result property="bigstrmoney" column="bigStrMoney" /> - <result property="flowlevel" column="FlowLevel" /> - <result property="costtype" column="costtype" /> - <result property="costtypename" column="costtypename" /> - <result property="oaid" column="oaid" /> - <result property="oabdzt" column="oabdzt" /> - <result property="filename" column="filename" /> - <result property="fileid" column="fileid" /> - <result property="reimid" column="reimid" /> - <result property="donorbank" column="donorbank" /> - <result property="donorbankcard" column="donorbankcard" /> - <result property="donorremark" column="donorremark" /> - <result property="donoramount" column="donoramount" /> - <result property="donorrelatives" column="donorrelatives" /> + + <resultMap type="com.ruoyi.project.domain.ServiceReimbursementShared" id="ServiceReimbursementSharedResult"> + <result property="id" column="ID"/> + <result property="delFlag" 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="userno" column="UserNo"/> + <result property="username" column="UserName"/> + <result property="travelers" column="Travelers"/> + <result property="idcardtype" column="IDCardType"/> + <result property="idcardno" column="IDCardNo"/> + <result property="phone" column="Phone"/> + <result property="depositbank" column="DepositBank"/> + <result property="bankcardno" column="BankCardNo"/> + <result property="branchbankname" column="BranchBankName"/> + <result property="annexbankcard" column="AnnexBankCard"/> + <result property="annexfiles" column="AnnexFiles"/> + <result property="amountrequested" column="AmountRequested"/> + <result property="prepaidamount" column="PrepaidAmount"/> + <result property="invoicecount" column="InvoiceCount"/> + <result property="attachcount" column="AttachCount"/> + <result property="managerno" column="ManagerNo"/> + <result property="managername" column="ManagerName"/> + <result property="deptmentno" column="DeptmentNo"/> + <result property="deptmentname" column="DeptmentName"/> + <result property="opochecker" column="OPOchecker"/> + <result property="finvicepresident" column="FinVicePresident"/> + <result property="busvicepresident" column="BusVicePresident"/> + <result property="officedirector" column="OfficeDirector"/> + <result property="financedirector" column="FinanceDirector"/> + <result property="financechecher" column="FinanceChecher"/> + <result property="infoid" column="InfoID"/> + <result property="donorno" column="DonorNo"/> + <result property="donorname" column="DonorName"/> + <result property="reason" column="Reason"/> + <result property="remark" column="remark"/> + <result property="recordstatus" column="RecordStatus"/> + <result property="uploadflag" column="uploadflag"/> + <result property="uploadtime" column="uploadtime"/> + <result property="totalamount" column="totalAmount"/> + <result property="bigstrmoney" column="bigStrMoney"/> + <result property="flowlevel" column="FlowLevel"/> + <result property="costtype" column="costtype"/> + <result property="costtypename" column="costtypename"/> + <result property="oaid" column="oaid"/> + <result property="oabdzt" column="oabdzt"/> + <result property="filename" column="filename"/> + <result property="fileid" column="fileid"/> + <result property="reimid" column="reimid"/> + <result property="donorbank" column="donorbank"/> + <result property="donorbankcard" column="donorbankcard"/> + <result property="donorremark" column="donorremark"/> + <result property="donoramount" column="donoramount"/> + <result property="donorrelatives" column="donorrelatives"/> </resultMap> <sql id="selectServiceReimbursementSharedVo"> - select ID, del_flag, create_by, create_time, update_by, update_time, UserNo, UserName, Travelers, IDCardType, IDCardNo, Phone, DepositBank, BankCardNo, BranchBankName, AnnexBankCard, AnnexFiles, AmountRequested, PrepaidAmount, InvoiceCount, AttachCount, ManagerNo, ManagerName, DeptmentNo, DeptmentName, OPOchecker, FinVicePresident, BusVicePresident, OfficeDirector, FinanceDirector, FinanceChecher, InfoID, DonorNo, DonorName, Reason, remark, RecordStatus, uploadflag, uploadtime, totalAmount, bigStrMoney, FlowLevel, costtype, costtypename, oaid, oabdzt, filename, fileid,reimid ,donorbank,donorbankcard,donorremark, donoramount,donorrelatives from service_reimbursement_shared + select ID, + del_flag, + create_by, + create_time, + update_by, + update_time, + UserNo, + UserName, + Travelers, + IDCardType, + IDCardNo, + Phone, + DepositBank, + BankCardNo, + BranchBankName, + AnnexBankCard, + AnnexFiles, + AmountRequested, + PrepaidAmount, + InvoiceCount, + AttachCount, + ManagerNo, + ManagerName, + DeptmentNo, + DeptmentName, + OPOchecker, + FinVicePresident, + BusVicePresident, + OfficeDirector, + FinanceDirector, + FinanceChecher, + InfoID, + DonorNo, + DonorName, + Reason, + remark, + RecordStatus, + uploadflag, + uploadtime, + totalAmount, + bigStrMoney, + FlowLevel, + costtype, + costtypename, + oaid, + oabdzt, + filename, + fileid, + reimid, + donorbank, + donorbankcard, + donorremark, + donoramount, + donorrelatives + from service_reimbursement_shared </sql> - <select id="getRemShareInfoByRemId" resultType="com.ruoyi.project.domain.ServiceReimbursementShared" resultMap="ServiceReimbursementSharedResult"> + <select id="getRemShareInfoByRemId" resultType="com.ruoyi.project.domain.ServiceReimbursementShared" + resultMap="ServiceReimbursementSharedResult"> <include refid="selectServiceReimbursementSharedVo"/> - where reimid = #{RemId} + where reimid = #{RemId} and del_flag!=1 </select> - <select id="selectServiceReimbursementSharedList" parameterType="ServiceReimbursementShared" resultMap="ServiceReimbursementSharedResult"> + <select id="selectServiceReimbursementSharedList" parameterType="com.ruoyi.project.domain.ServiceReimbursementShared" + resultMap="ServiceReimbursementSharedResult"> <include refid="selectServiceReimbursementSharedVo"/> <where> - <if test="userno != null and userno != ''"> and UserNo = #{userno}</if> - <if test="username != null and username != ''"> and UserName like concat('%', #{username}, '%')</if> - <if test="travelers != null and travelers != ''"> and Travelers = #{travelers}</if> - <if test="idcardtype != null and idcardtype != ''"> and IDCardType = #{idcardtype}</if> - <if test="idcardno != null and idcardno != ''"> and IDCardNo = #{idcardno}</if> - <if test="phone != null and phone != ''"> and Phone = #{phone}</if> - <if test="depositbank != null and depositbank != ''"> and DepositBank = #{depositbank}</if> - <if test="bankcardno != null and bankcardno != ''"> and BankCardNo = #{bankcardno}</if> - <if test="branchbankname != null and branchbankname != ''"> and BranchBankName like concat('%', #{branchbankname}, '%')</if> - <if test="annexbankcard != null and annexbankcard != ''"> and AnnexBankCard = #{annexbankcard}</if> - <if test="annexfiles != null and annexfiles != ''"> and AnnexFiles = #{annexfiles}</if> - <if test="amountrequested != null "> and AmountRequested = #{amountrequested}</if> - <if test="prepaidamount != null "> and PrepaidAmount = #{prepaidamount}</if> - <if test="invoicecount != null "> and InvoiceCount = #{invoicecount}</if> - <if test="attachcount != null "> and AttachCount = #{attachcount}</if> - <if test="managerno != null and managerno != ''"> and ManagerNo = #{managerno}</if> - <if test="managername != null and managername != ''"> and ManagerName like concat('%', #{managername}, '%')</if> - <if test="deptmentno != null and deptmentno != ''"> and DeptmentNo = #{deptmentno}</if> - <if test="deptmentname != null and deptmentname != ''"> and DeptmentName like concat('%', #{deptmentname}, '%')</if> - <if test="opochecker != null and opochecker != ''"> and OPOchecker = #{opochecker}</if> - <if test="finvicepresident != null and finvicepresident != ''"> and FinVicePresident = #{finvicepresident}</if> - <if test="busvicepresident != null and busvicepresident != ''"> and BusVicePresident = #{busvicepresident}</if> - <if test="officedirector != null and officedirector != ''"> and OfficeDirector = #{officedirector}</if> - <if test="financedirector != null and financedirector != ''"> and FinanceDirector = #{financedirector}</if> - <if test="financechecher != null and financechecher != ''"> and FinanceChecher = #{financechecher}</if> - <if test="infoid != null "> and InfoID = #{infoid}</if> - <if test="donorno != null and donorno != ''"> and DonorNo = #{donorno}</if> - <if test="donorname != null and donorname != ''"> and DonorName like concat('%', #{donorname}, '%')</if> - <if test="reason != null and reason != ''"> and Reason = #{reason}</if> - <if test="recordstatus != null "> and RecordStatus = #{recordstatus}</if> - <if test="uploadflag != null and uploadflag != ''"> and uploadflag = #{uploadflag}</if> - <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if> - <if test="totalamount != null "> and totalAmount = #{totalamount}</if> - <if test="bigstrmoney != null and bigstrmoney != ''"> and bigStrMoney = #{bigstrmoney}</if> - <if test="flowlevel != null "> and FlowLevel = #{flowlevel}</if> - <if test="costtype != null and costtype != ''"> and costtype = #{costtype}</if> - <if test="costtypename != null and costtypename != ''"> and costtypename like concat('%', #{costtypename}, '%')</if> - <if test="oaid != null and oaid != ''"> and oaid = #{oaid}</if> - <if test="oabdzt != null and oabdzt != ''"> and oabdzt = #{oabdzt}</if> - <if test="filename != null and filename != ''"> and filename like concat('%', #{filename}, '%')</if> - <if test="fileid != null and fileid != ''"> and fileid = #{fileid}</if> + <if test="userno != null and userno != ''">and UserNo = #{userno}</if> + <if test="username != null and username != ''">and UserName like concat('%', #{username}, '%')</if> + <if test="travelers != null and travelers != ''">and Travelers = #{travelers}</if> + <if test="idcardtype != null and idcardtype != ''">and IDCardType = #{idcardtype}</if> + <if test="idcardno != null and idcardno != ''">and IDCardNo = #{idcardno}</if> + <if test="phone != null and phone != ''">and Phone = #{phone}</if> + <if test="depositbank != null and depositbank != ''">and DepositBank = #{depositbank}</if> + <if test="bankcardno != null and bankcardno != ''">and BankCardNo = #{bankcardno}</if> + <if test="branchbankname != null and branchbankname != ''">and BranchBankName like concat('%', + #{branchbankname}, '%') + </if> + <if test="annexbankcard != null and annexbankcard != ''">and AnnexBankCard = #{annexbankcard}</if> + <if test="annexfiles != null and annexfiles != ''">and AnnexFiles = #{annexfiles}</if> + <if test="amountrequested != null ">and AmountRequested = #{amountrequested}</if> + <if test="prepaidamount != null ">and PrepaidAmount = #{prepaidamount}</if> + <if test="invoicecount != null ">and InvoiceCount = #{invoicecount}</if> + <if test="attachcount != null ">and AttachCount = #{attachcount}</if> + <if test="managerno != null and managerno != ''">and ManagerNo = #{managerno}</if> + <if test="managername != null and managername != ''">and ManagerName like concat('%', #{managername}, + '%') + </if> + <if test="deptmentno != null and deptmentno != ''">and DeptmentNo = #{deptmentno}</if> + <if test="deptmentname != null and deptmentname != ''">and DeptmentName like concat('%', #{deptmentname}, + '%') + </if> + <if test="opochecker != null and opochecker != ''">and OPOchecker = #{opochecker}</if> + <if test="finvicepresident != null and finvicepresident != ''">and FinVicePresident = #{finvicepresident} + </if> + <if test="busvicepresident != null and busvicepresident != ''">and BusVicePresident = #{busvicepresident} + </if> + <if test="officedirector != null and officedirector != ''">and OfficeDirector = #{officedirector}</if> + <if test="financedirector != null and financedirector != ''">and FinanceDirector = #{financedirector}</if> + <if test="financechecher != null and financechecher != ''">and FinanceChecher = #{financechecher}</if> + <if test="infoid != null ">and InfoID = #{infoid}</if> + <if test="donorno != null and donorno != ''">and DonorNo = #{donorno}</if> + <if test="donorname != null and donorname != ''">and DonorName like concat('%', #{donorname}, '%')</if> + <if test="reason != null and reason != ''">and Reason = #{reason}</if> + <if test="recordstatus != null ">and RecordStatus = #{recordstatus}</if> + <if test="uploadflag != null and uploadflag != ''">and uploadflag = #{uploadflag}</if> + <if test="uploadtime != null ">and uploadtime = #{uploadtime}</if> + <if test="totalamount != null ">and totalAmount = #{totalamount}</if> + <if test="bigstrmoney != null and bigstrmoney != ''">and bigStrMoney = #{bigstrmoney}</if> + <if test="flowlevel != null ">and FlowLevel = #{flowlevel}</if> + <if test="costtype != null and costtype != ''">and costtype = #{costtype}</if> + <if test="costtypename != null and costtypename != ''">and costtypename like concat('%', #{costtypename}, + '%') + </if> + <if test="oaid != null and oaid != ''">and oaid = #{oaid}</if> + <if test="oabdzt != null and oabdzt != ''">and oabdzt = #{oabdzt}</if> + <if test="filename != null and filename != ''">and filename like concat('%', #{filename}, '%')</if> + <if test="fileid != null and fileid != ''">and fileid = #{fileid}</if> </where> </select> + <update id="delResharedInfoById"> + UPDATE service_reimbursement_shared + SET del_flag = 1 + WHERE id = #{id} + and del_flag != 1 + </update> + </mapper> \ No newline at end of file diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml index bf3dcc6..a1e6753 100644 --- a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml @@ -4,7 +4,7 @@ "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.ruoyi.project.mapper.ServiceReimbursementpayeeSharedMapper"> - <resultMap type="ServiceReimbursementpayeeShared" id="ServiceReimbursementpayeeSharedResult"> + <resultMap type="com.ruoyi.project.domain.ServiceReimbursementpayeeShared" id="ServiceReimbursementpayeeSharedResult"> <result property="id" column="id" /> <result property="rpid" column="rpid" /> <result property="rbid" column="rbid" /> @@ -31,7 +31,7 @@ select id, rpid, rbid, orderno, persontype, personname, bankname, bankcardno, amount, phone, familyrelations, paiddate, remark, del_flag, create_by, create_time, update_by, update_time, uploadflag, uploadtime from service_reimbursementpayee_shared </sql> - <select id="selectServiceReimbursementpayeeSharedList" parameterType="ServiceReimbursementpayeeShared" resultMap="ServiceReimbursementpayeeSharedResult"> + <select id="selectServiceReimbursementpayeeSharedList" parameterType="com.ruoyi.project.domain.ServiceReimbursementpayeeShared" resultMap="ServiceReimbursementpayeeSharedResult"> <include refid="selectServiceReimbursementpayeeSharedVo"/> <where> <if test="rpid != null "> and rpid = #{rpid}</if> diff --git a/ruoyi-quartz/pom.xml b/ruoyi-quartz/pom.xml index ccb6922..39dfbf6 100644 --- a/ruoyi-quartz/pom.xml +++ b/ruoyi-quartz/pom.xml @@ -34,6 +34,12 @@ <groupId>com.ruoyi</groupId> <artifactId>ruoyi-common</artifactId> </dependency> + <dependency> + <groupId>com.ruoyi</groupId> + <artifactId>ruoyi-project</artifactId> + <version>3.7.0</version> + <scope>compile</scope> + </dependency> </dependencies> diff --git a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java index 853243b..4c5d042 100644 --- a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java +++ b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/task/RyTask.java @@ -1,28 +1,126 @@ package com.ruoyi.quartz.task; +import com.ruoyi.project.domain.*; +import com.ruoyi.project.domain.vo.DingTalkReqVo; +import com.ruoyi.project.service.*; +import com.ruoyi.project.service.impl.DingTalkServiceImpl; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Component; import com.ruoyi.common.utils.StringUtils; +import java.lang.reflect.Array; +import java.util.*; +import java.util.concurrent.ConcurrentHashMap; + /** * 瀹氭椂浠诲姟璋冨害娴嬭瘯 - * + * * @author ruoyi */ @Component("ryTask") -public class RyTask -{ - public void ryMultipleParams(String s, Boolean b, Long l, Double d, Integer i) - { +public class RyTask { + @Autowired + private DingTalkService dingTalkService; + + @Autowired + private IServiceReimbursementSharedService serviceReimbursementSharedService; + + @Autowired + private IServiceFundSharedService serviceFundSharedService; + + + @Autowired + private IServiceFundService serviceFundService; + + @Autowired + private IServiceReimbursementService serviceReimbursementService; + + @Autowired + private IServiceFundflowService fundflowService; + + public void ryMultipleParams(String s, Boolean b, Long l, Double d, Integer i) { System.out.println(StringUtils.format("鎵ц澶氬弬鏂规硶锛� 瀛楃涓茬被鍨媨}锛屽竷灏旂被鍨媨}锛岄暱鏁村瀷{}锛屾诞鐐瑰瀷{}锛屾暣褰}", s, b, l, d, i)); } - public void ryParams(String params) - { + public void ryParams(String params) { System.out.println("鎵ц鏈夊弬鏂规硶锛�" + params); } - public void ryNoParams() - { + public void ryNoParams() { System.out.println("鎵ц鏃犲弬鏂规硶"); } + + public void checkReportInfo() { + //鏌ュ嚭鎵�鏈夎鍖婚櫌閫�鍥炵殑Fund鏁版嵁 + List<ServiceFundShared> serviceFundShareds = serviceFundSharedService.queryFundShareList(); + for (ServiceFundShared serviceFundShared : serviceFundShareds) { + String[] split = serviceFundShared.getCxrjyj().split("&"); + String phone = serviceFundShared.getPhone(); + //灏嗗垎浜噷鐨勮鏁版嵁鍒犻櫎 + serviceFundSharedService.delfundsharedInfoById(serviceFundShared.getId()); + + ServiceFund serviceFund = new ServiceFund(); + serviceFund.setId(serviceFundShared.getSerfunid()); + List<ServiceFund> serviceFunds = serviceFundService.queryList(serviceFund); + ServiceFund serviceFund1 = serviceFunds.get(0); + serviceFund1.setFlowlevel(0); + serviceFund1.setDel_flag(0); + serviceFund1.setBackflowlevel(199); + serviceFundService.updateById(serviceFund1); + sendMeg(split,phone); + } + + + //鏌ュ嚭鎵�鏈夎鍖婚櫌閫�鍥炵殑Reimbursement鏁版嵁 + List<ServiceReimbursementShared> serviceReimbursementShareds = serviceReimbursementSharedService.queryReShareList(); + for (ServiceReimbursementShared serviceReimbursementShared : serviceReimbursementShareds) { + String phone = serviceReimbursementShared.getPhone(); + String[] split = serviceReimbursementShared.getCxrjyj().split("&"); + + //灏嗗垎浜噷鐨勮鏁版嵁鍒犻櫎 + serviceReimbursementSharedService.delResharedInfoById(serviceReimbursementShared.getId()); + + //灏咶lowlevel 璁剧疆涓�0; + ServiceReimbursement serviceReimbursement = new ServiceReimbursement(); + serviceReimbursement.setId(serviceReimbursementShared.getReimid()); + List<ServiceReimbursement> serviceReimbursementList = serviceReimbursementService.queryList(serviceReimbursement); + ServiceReimbursement serviceReimbursement1 = serviceReimbursementList.get(0); + serviceReimbursement1.setFlowlevel(0L); + serviceReimbursement1.setDelFlag(0); + serviceReimbursement1.setBackflowlevel(199L); + serviceReimbursementService.updateById(serviceReimbursement1); + sendMeg(split,phone); + + } + + } + + public void sendMeg(String[] split,String phone) { + //璁板綍鎿嶄綔璁板綍 + ServiceFundflow serviceFundflow = new ServiceFundflow(); + serviceFundflow.setCreateBy("admin"); + serviceFundflow.setCreateTime(new Date()); + serviceFundflow.setUpdateBy("admin"); + serviceFundflow.setUpdateTime(new Date()); + serviceFundflow.setCheckusername(split[0]); + serviceFundflow.setFlowcontent(split[2]); + serviceFundflow.setFlowconclusion(2); + serviceFundflow.setFundtype(2); + serviceFundflow.setFlowlevel(100); + fundflowService.save(serviceFundflow); + + ArrayList<ConcurrentHashMap<String, String>> contentList = new ArrayList<>(); + ConcurrentHashMap map = new ConcurrentHashMap(); + map.put("瀹℃壒浜�", split[0]); + map.put("瀹℃壒鏃堕棿", split[1]); + map.put("鎰忚", split[2]); + contentList.add(map); + DingTalkReqVo dingTalkReqVo = new DingTalkReqVo(); + dingTalkReqVo.setTitle("璐㈠姟绯荤粺椹冲洖淇℃伅"); + dingTalkReqVo.setNumber("13634195431"); + dingTalkReqVo.setContents(contentList); + dingTalkService.sendNotification(dingTalkReqVo); + } + } -- Gitblit v1.9.3