ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java
@@ -156,10 +156,16 @@ list = list.stream().filter(obj -> obj.getDonorname().contains(spFinancialExpensesIn.getDonorname())).collect(Collectors.toList()); } //通过金额过滤 if (spFinancialExpensesIn.getMoney() != null) { list = list.stream().filter(reimbursementOut -> new BigDecimal(reimbursementOut.getPretaxcost()).compareTo(new BigDecimal(spFinancialExpensesIn.getMoney())) == 0).collect(Collectors.toList()); } Collections.sort(list, new Comparator<SpFinancialExpensesFundOut>() { @Override public int compare(SpFinancialExpensesFundOut o1, SpFinancialExpensesFundOut o2) { return o2.getCreateTime().compareTo(o1.getCreateTime()); return o1.getCreateTime().compareTo(o2.getCreateTime()); } }); return getCustomDataTable(list, pageNum, pageSize); @@ -1108,10 +1114,18 @@ bz += f.getDepositbank() == null ? "" : f.getDepositbank() + ": "; bz += f.getBankcardno() == null ? "" : f.getBankcardno() + ","; bz += "金额 : " + f.getAmount() + "元"; bz += System.lineSeparator(); bz += "<w:br/>"; } if (serviceFund.getApplytype().equals("4")) { i = i + 1; bz += f.getBeneficiaryname() == null ? "(" + i + ")" : "(" + i + ")" + f.getBeneficiaryname() + ","; bz += f.getDepositbank() == null ? "" : f.getDepositbank() + ": "; bz += f.getBankcardno() == null ? "" : f.getBankcardno() + ","; bz += "金额 : " + f.getAmount() + "元"; bz += "<w:br/>"; } String fyxm = f.getItemname() == null ? "" : f.getItemname(); String fyxm = ""; fyxm += f.getItemname() == null ? "" : f.getItemname(); fyxm += f.getAmount() + "元"; map.put("FYXM", fyxm); @@ -1127,7 +1141,7 @@ // dataMap.put("JEDS", convert(serviceFund.getAmountrequested()) + "整"); //备注里放的是经办人的银行卡信息 dataMap.put("BXBZ", serviceFund.getApplytype().equals("3") ? bz : infoByUserNo == null ? "" : infoByUserNo.getBranchbankname() + " " + infoByUserNo.getBankcardno()); dataMap.put("BXBZ", serviceFund.getApplytype().equals("3") || serviceFund.getApplytype().equals("4") ? bz : infoByUserNo == null ? "" : infoByUserNo.getBranchbankname() + " " + infoByUserNo.getBankcardno()); dataMap.put("YZ", serviceFund.getPresident() == null ? "" : serviceFund.getPresident()); dataMap.put("CWFYZ", serviceFund.getFinvicepresident() == null ? "" : serviceFund.getFinvicepresident()); dataMap.put("YWFYZ", serviceFund.getBusvicepresident() == null ? "" : serviceFund.getBusvicepresident()); ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementController.java
@@ -156,10 +156,15 @@ } //startPage(); List<SpFinancialExpensesReimbursementOut> list = serviceReimbursementService.getListBypower(loginUser.getUsername(), 1, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE); //根据经办人筛选 if (StringUtils.isNotBlank(spFinancialExpensesIn.getUsername())) { list = list.stream().filter(reimbursementOut -> reimbursementOut.getUsername().contains(spFinancialExpensesIn.getUsername())).collect(Collectors.toList()); // 按name字段过滤 } //根据金额筛选 if (spFinancialExpensesIn.getMoney() != null) { list = list.stream().filter(reimbursementOut -> new BigDecimal(reimbursementOut.getAmountrequested()) == new BigDecimal(spFinancialExpensesIn.getMoney())).collect(Collectors.toList()); } //根据创建时间排序 Collections.sort(list, new Comparator<SpFinancialExpensesReimbursementOut>() { @Override public int compare(SpFinancialExpensesReimbursementOut o1, SpFinancialExpensesReimbursementOut o2) { @@ -711,6 +716,7 @@ Map dataMap = new HashMap(); getData(dataMap, id); String filePath = getClass().getResource("/template/").getPath(); log.info("下载地址是啥???{}", filePath); System.out.println(filePath); //设置模本装置方法和路径,FreeMarker支持多种模板装载方法。可以重servlet,classpath,数据库教程装载, configuration.setDirectoryForTemplateLoading(new File(filePath)); @@ -723,7 +729,7 @@ e.printStackTrace(); } String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis()); String name = "差旅费报销申请单_" + dataMap.get("XM") + "_" + newTime; String name = "差旅费报销申请单_" + dataMap.get("JSR") + "_" + newTime; //输出文档路径及名称 File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc"); ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementdetailController.java
@@ -133,6 +133,27 @@ @PostMapping("/reimbursementdetailEdit") //@RepeatSubmit public AjaxResult edit(@RequestBody ServiceReimbursementdetailVO serviceReimbursementdetailVO) { if (serviceReimbursementdetailVO.getTrafficexpense() == null) { serviceReimbursementdetailVO.setTrafficexpense(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getCityfee() == null) { serviceReimbursementdetailVO.setCityfee(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getHotelexpense() == null) { serviceReimbursementdetailVO.setHotelexpense(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getFoodexpenses() == null) { serviceReimbursementdetailVO.setFoodexpenses(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getFoodallowance() == null) { serviceReimbursementdetailVO.setFoodallowance(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getOtherexpense() == null) { serviceReimbursementdetailVO.setOtherexpense(new BigDecimal(0)); } if (serviceReimbursementdetailVO.getOtherfeeamount() == null) { serviceReimbursementdetailVO.setOtherfeeamount(new BigDecimal(0)); } ServiceReimbursementdetail serviceReimbursementdetail = DtoConversionUtils.sourceToTarget(serviceReimbursementdetailVO, ServiceReimbursementdetail.class); if (!CollectionUtils.isEmpty(serviceReimbursementdetailVO.getAnnexfilesList())) { //对前端传过来的数组,进行JSON序列化,并赋值给Annexfiles ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementdetailVO.java
@@ -126,7 +126,7 @@ private Long attachcount; /** * 杂费 * 公杂费补助 */ @ApiModelProperty("杂费") @Excel(name = "杂费") @@ -217,6 +217,7 @@ @Excel(name = "所属街道(镇)名称") private String traveltownname; @ApiModelProperty("其它费用") private BigDecimal otherfeeamount; private String otherfeedesc; ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/SpFinancialExpensesIn.java
@@ -63,4 +63,10 @@ @ApiModelProperty("捐献者姓名") private String donorname; /** * 金额 */ @ApiModelProperty("金额") private Double money; } ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceDonatebaseinfoServiceImpl.java
@@ -4,6 +4,7 @@ import java.util.Date; import java.util.List; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.ruoyi.common.core.domain.entity.SysRole; import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.utils.DateUtils; @@ -18,8 +19,10 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import java.util.ArrayList; import java.util.Map; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.project.domain.ServiceDonatebaseinfo; import com.ruoyi.project.mapper.BaseOrganizationMapper; @@ -27,13 +30,12 @@ /** * 捐献基础Service业务层处理 * * * @author ruoyi * @date 2021-11-13 */ @Service public class ServiceDonatebaseinfoServiceImpl extends ServiceImpl<ServiceDonatebaseinfoMapper, ServiceDonatebaseinfo> implements IServiceDonatebaseinfoService { public class ServiceDonatebaseinfoServiceImpl extends ServiceImpl<ServiceDonatebaseinfoMapper, ServiceDonatebaseinfo> implements IServiceDonatebaseinfoService { @Autowired BaseOrganizationMapper baseOrganizationMapper; @@ -48,40 +50,39 @@ ServiceDonationwitnessMapper serviceDonationwitnessMapper; /** * 查询捐献基础列表 * * * @param serviceDonatebaseinfo 捐献基础 * @return 捐献基础 */ @Override public List<ServiceDonatebaseinfo> queryList(ServiceDonatebaseinfo serviceDonatebaseinfo) { LambdaQueryWrapper<ServiceDonatebaseinfo> wrappers = Wrappers.lambdaQuery(); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getName())){ wrappers.like(ServiceDonatebaseinfo::getName ,serviceDonatebaseinfo.getName()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getName())) { wrappers.like(ServiceDonatebaseinfo::getName, serviceDonatebaseinfo.getName()); } if (StringUtils.isNotBlank(serviceDonatebaseinfo.getIdcardno())){ wrappers.like(ServiceDonatebaseinfo::getIdcardno ,serviceDonatebaseinfo.getIdcardno()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getIdcardno())) { wrappers.like(ServiceDonatebaseinfo::getIdcardno, serviceDonatebaseinfo.getIdcardno()); } if (StringUtils.isNotBlank(serviceDonatebaseinfo.getResidenceprovince())){ wrappers.eq(ServiceDonatebaseinfo::getResidenceprovince ,serviceDonatebaseinfo.getResidenceprovince()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getResidenceprovince())) { wrappers.eq(ServiceDonatebaseinfo::getResidenceprovince, serviceDonatebaseinfo.getResidenceprovince()); } if (serviceDonatebaseinfo.getRecordstate() != null){ wrappers.eq(ServiceDonatebaseinfo::getRecordstate ,serviceDonatebaseinfo.getRecordstate()); if (serviceDonatebaseinfo.getRecordstate() != null) { wrappers.eq(ServiceDonatebaseinfo::getRecordstate, serviceDonatebaseinfo.getRecordstate()); } if (StringUtils.isNotBlank(serviceDonatebaseinfo.getTreatmenthospitalname())){ wrappers.like(ServiceDonatebaseinfo::getTreatmenthospitalname ,serviceDonatebaseinfo.getTreatmenthospitalname()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getTreatmenthospitalname())) { wrappers.like(ServiceDonatebaseinfo::getTreatmenthospitalname, serviceDonatebaseinfo.getTreatmenthospitalname()); } if (StringUtils.isNotBlank(serviceDonatebaseinfo.getDonorno())){ wrappers.eq(ServiceDonatebaseinfo::getDonorno ,serviceDonatebaseinfo.getDonorno()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getDonorno())) { wrappers.eq(ServiceDonatebaseinfo::getDonorno, serviceDonatebaseinfo.getDonorno()); } if (StringUtils.isNotBlank(serviceDonatebaseinfo.getReportername())){ wrappers.like(ServiceDonatebaseinfo::getReportername ,serviceDonatebaseinfo.getReportername()); if (StringUtils.isNotBlank(serviceDonatebaseinfo.getReportername())) { wrappers.like(ServiceDonatebaseinfo::getReportername, serviceDonatebaseinfo.getReportername()); } Map<String, Object> params = serviceDonatebaseinfo.getParams(); if (params.get("beginReporttime") != null && params.get("endReporttime") != null) { wrappers.between(ServiceDonatebaseinfo::getReporttime ,params.get("beginReporttime"),params.get("endReporttime")); wrappers.between(ServiceDonatebaseinfo::getReporttime, params.get("beginReporttime"), params.get("endReporttime")); } return this.list(wrappers); } @@ -95,7 +96,9 @@ //发现医院 C1C2AF1N1 String hospitalNo = serviceDonatebaseinfo.getTreatmenthospitalno(); BaseOrganization baseOrganization = baseOrganizationMapper.getOrganizationByNumber(hospitalNo); donateNumber += baseOrganization.getOrganizationid(); if (ObjectUtils.isNotEmpty(baseOrganization)) { donateNumber += baseOrganization.getOrganizationid(); } //工作人员 H1H2H3 donateNumber += serviceDonatebaseinfo.getReporterno(); @@ -133,29 +136,25 @@ public String updateS1S2S3S4(Long id) { String oldDonateNumber = serviceDonatebaseinfoMapper.getDonateNumberById(id); List <ServiceDonationwitness> list = serviceDonationwitnessMapper.getWitnessList(); List<ServiceDonationwitness> list = serviceDonationwitnessMapper.getWitnessList(); int completeDonation = list.size(); String number = ""; if(completeDonation < 10){ if (completeDonation < 10) { number = "000" + completeDonation; } else if(completeDonation >= 10 && completeDonation < 100){ } else if (completeDonation >= 10 && completeDonation < 100) { number = "00" + completeDonation; } else if(completeDonation >= 100 && completeDonation < 1000){ } else if (completeDonation >= 100 && completeDonation < 1000) { number = "0" + completeDonation; } else { } else { number = "" + completeDonation; } int last = oldDonateNumber.lastIndexOf("*"); if(last == -1){ if (last == -1) { return oldDonateNumber; } else { } else { StringBuilder newDonateNumber = new StringBuilder(oldDonateNumber); newDonateNumber.replace(last - 3, last + 1, number); @@ -170,21 +169,21 @@ public List<ServiceDonatebaseinfo> selectServiceDonatebaseinfoList(ServiceDonatebaseinfo serviceDonatebaseinfo) { SysUser user = SecurityUtils.getLoginUser().getUser(); List <SysRole> l = user.getRoles(); List<SysRole> l = user.getRoles(); int b = 0; for(SysRole r : l){ if(r.getRoleId().longValue() == 3){ for (SysRole r : l) { if (r.getRoleId().longValue() == 3) { b = 1; } if(r.getRoleId().longValue() == 13){ if (r.getRoleId().longValue() == 13) { b = 2; } } if(b == 1){ if (b == 1) { serviceDonatebaseinfo.setCreateBy(user.getUserName()); } if(b == 2){ if (b == 2) { serviceDonatebaseinfo.setDeptid(user.getDeptId()); } return serviceDonatebaseinfoMapper.selectServiceDonatebaseinfoList(serviceDonatebaseinfo); @@ -193,14 +192,14 @@ @Override public List<ServiceDonatebaseinfo> listForSearch(ServiceDonatebaseinfo serviceDonatebaseinfo) { SysUser user = SecurityUtils.getLoginUser().getUser(); List <SysRole> l = user.getRoles(); List<SysRole> l = user.getRoles(); Boolean b = false; for(SysRole r : l){ if(r.getRoleId().longValue() == 3){ for (SysRole r : l) { if (r.getRoleId().longValue() == 3) { b = true; } } if(b){ if (b) { serviceDonatebaseinfo.setCreateBy(user.getUserName()); }