From d5c2c0762ccbb2bb33635f99480d404f1fb10d5a Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期四, 22 二月 2024 18:26:29 +0800 Subject: [PATCH] 修改流程代码提交 --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFundController.java | 526 +++++++++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 405 insertions(+), 121 deletions(-) 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 782e319..baa29cf 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 @@ -1,6 +1,10 @@ package com.ruoyi.web.controller.project; +import com.alibaba.fastjson.JSONObject; +import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.annotation.NotRepeatCommit; import com.ruoyi.common.annotation.RepeatSubmit; import com.ruoyi.common.config.RuoYiConfig; import com.ruoyi.common.constant.HttpStatus; @@ -11,24 +15,37 @@ import com.ruoyi.common.core.page.TableDataInfo; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.common.exception.ServiceException; +import com.ruoyi.common.exception.base.BaseException; +import com.ruoyi.common.tax.TaxtUtils; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.bean.DtoConversionUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.project.domain.*; import com.ruoyi.project.domain.vo.*; import com.ruoyi.project.mapper.ServiceFunddetailMapper; import com.ruoyi.project.service.*; +import com.ruoyi.system.service.ISysPostService; import freemarker.template.Configuration; import freemarker.template.Template; import freemarker.template.TemplateException; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import lombok.extern.slf4j.Slf4j; import org.apache.ibatis.annotations.Options; +import org.apache.poi.ss.formula.functions.T; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.jdbc.datasource.DataSourceTransactionManager; +import org.springframework.transaction.TransactionDefinition; +import org.springframework.transaction.TransactionStatus; +import org.springframework.transaction.annotation.Transactional; +import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import java.io.*; import java.math.BigDecimal; import java.text.SimpleDateFormat; +import java.time.LocalDate; import java.util.*; import java.util.stream.Collectors; @@ -40,6 +57,7 @@ * @author ruoyi * @date 2022-01-24 */ +@Slf4j @Api("璐圭敤鐢宠涓�") @RestController @RequestMapping("/project/fund") @@ -69,8 +87,19 @@ private IServiceSystemmessageService ServiceSystemmessage; @Autowired - private IServiceFundSharedService fundServiceShare; + private IBaseOnlyvalueService baseOnlyvalueService; + @Autowired + private IServiceExternalpersonService externalpersonService; + + @Autowired + private ISysPostService postService; + + @Autowired + private DataSourceTransactionManager transactionManager; + + @Autowired + private TransactionDefinition transactionDefinition; public ServiceFundController() { configuration = new Configuration(); @@ -86,6 +115,8 @@ public TableDataInfo list(ServiceFund serviceFund) { startPage(); //List<ServiceFund> list = serviceFundService.queryList(serviceFund); + SysUser user = SecurityUtils.getLoginUser().getUser(); + serviceFund.setUsername(user.getNickName()); List<ServiceFund> list = serviceFundService.selectServiceFundList(serviceFund); return getDataTable(list); } @@ -113,7 +144,12 @@ Integer APPLYTYPE = spFinancialExpensesIn.getAPPLYTYPE(); Integer pageNum = spFinancialExpensesIn.getPageNum(); Integer pageSize = spFinancialExpensesIn.getPageSize(); + Integer checkstatus = spFinancialExpensesIn.getCheckstatus(); + String donorname = spFinancialExpensesIn.getDonorname(); + if (StringUtils.isEmpty(donorname)) { + donorname = null; + } if (pageNum == null) { pageNum = 1; } @@ -135,11 +171,22 @@ } //startPage(); - List<SpFinancialExpensesFundOut> list = serviceFundService.getListBypower(loginUser.getUsername(), 2, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE); + List<SpFinancialExpensesFundOut> list = serviceFundService.getListBypower(loginUser.getUsername(), 2, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE, checkstatus, donorname); + //閫氳繃鎹愮尞鑰呰繃婊� + if (StringUtils.isNotEmpty(spFinancialExpensesIn.getDonorname())) { + 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); @@ -158,15 +205,11 @@ return AjaxResult.success(serviceFundService.getFundId(infoid)); } - @GetMapping("/addFundSharedInfo/{id}") - public AjaxResult addFundSharedInfo(@PathVariable("id") Long id) { - return AjaxResult.success(serviceFundService.addFundSharedInfo(id)); - } +// @GetMapping("/addFundSharedInfo/{id}") +// public AjaxResult addFundSharedInfo(@PathVariable("id") Long id) { +// return AjaxResult.success(serviceFundService.addFundSharedInfo(id)); +// } - @GetMapping("/getFundDetail/{id}") - public AjaxResult getFundDetail(@PathVariable("id") Long id) { - return AjaxResult.success(serviceFundService.getFundDetail(id)); - } /** * 瀵煎嚭璐圭敤鐢宠涓诲垪琛� @@ -198,7 +241,7 @@ @ApiOperation("鏂板璐圭敤鐢宠涓�") //@PreAuthorize("@ss.hasPermi('project:fund:add')") @Log(title = "璐圭敤鐢宠涓�", businessType = BusinessType.INSERT) - @PostMapping + @PostMapping("/add") @RepeatSubmit @Options(useGeneratedKeys = true, keyProperty = "id") public AjaxResult add(@RequestBody ServiceFund serviceFund) { @@ -426,29 +469,24 @@ */ @ApiOperation("鏂板璐圭敤姹囨��") @Log(title = "鏂板璐圭敤姹囨��", businessType = BusinessType.INSERT) - @PostMapping("/addnew") + @PostMapping("/addOrUpdateNew") @RepeatSubmit @Options(useGeneratedKeys = true, keyProperty = "id") - public AjaxResult addnew(@RequestBody ServiceFundVO serviceFundVO) { - boolean b = serviceFundService.save(serviceFundVO); - Long id = serviceFundVO.getId(); -// if (b) { -// addReiSharedDatd(serviceFundVO, 1); -// } - List<ServiceFunddetail> serviceFunddetails = serviceFundVO.getServiceFunddetails(); - serviceFunddetails.forEach(item -> item.setFundid(id)); - serviceFunddetailService.saveBatch(serviceFunddetails); - return AjaxResult.success(id); + public AjaxResult addOrUpdateNew(@RequestBody ServiceFundVO serviceFundVO) { + + return AjaxResult.success(serviceFundService.addOrUpdateNew(serviceFundVO)); } + /** * 瀹℃牳璐圭敤 */ @ApiOperation("瀹℃牳璐圭敤") - @Log(title = "瀹℃牳璐圭敤", businessType = BusinessType.OTHER) + @RepeatSubmit +// @Log(title = "瀹℃牳璐圭敤", businessType = BusinessType.OTHER) @PostMapping("/checkfund") public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) { - logger.info("serviceFundController---checkFund鐨勫叆鍙傚�糲heckFundVO :{}", checkFundVO); + log.info("serviceFundController---checkFund鐨勫叆鍙傚�糲heckFundVO :{}", checkFundVO); ServiceFund serviceFund = serviceFundService.getById(checkFundVO.getFundid()); if (serviceFund != null) { Integer TotalLevel = 0; @@ -457,8 +495,7 @@ serviceFundflowrule.setFundtype(2); serviceFundflowrule.setApplytype(serviceFund.getApplytype()); serviceFundflowrule.setCheckuserno(loginUser.getUsername()); - logger.info("serviceFundController---checkFund---queryList鐨勫叆鍙傚�約erviceFundflowrule:{}", serviceFundflowrule); - + log.info("serviceFundController---checkFund---queryList鐨勫叆鍙傚�約erviceFundflowrule:{}", serviceFundflowrule); List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule); if (serviceFundflowrules == null || serviceFundflowrules.stream().count() == 0) { @@ -475,7 +512,7 @@ Integer CheckFlag = 0; Integer RecordStatus = serviceFund.getRecordstatus(); - Integer FlowLevel = serviceFund.getFlowlevel(); + Integer FlowLevel = serviceFund.getFlowlevel().intValue(); Integer OriginalFlowLevel = FlowLevel; if (checkFundVO.getFlowconclusion() == 1) { CheckFlag = 1; @@ -489,11 +526,39 @@ } } FlowLevel = FlowLevel + 1; + + if (serviceFund.getFlowlevel() == 1 && serviceFund.getBackflowlevel() == 100) { + log.info("璐㈠姟閫�鍥炲啀鎻愪氦锛屽嚭绾冲啀娆″鎵癸紝涔嬪悗鎻愪氦鍒拌储鍔�"); + //璇存槑鏄储鍔¢��鍥炲啀鎻愪氦鐨�.闇�瑕佸嚭绾冲啀鐪嬩竴閬嶏紝娌¢棶棰樹箣鍚庯紝寰�鍒嗕韩琛ㄩ噷鏂板 +// serviceFundService.addFundSharedInfo(serviceFund.getId()); + serviceFund.setFlowlevel(3L); + serviceFund.setFlowlevel(100L); + serviceFund.setRecordstatus(99); + serviceFundService.updateById(serviceFund); + + //淇濆瓨瀹℃壒娴佺▼琛� + ServiceFundflow serviceFundflow = new ServiceFundflow(); + SysUser user = loginUser.getUser(); + serviceFundflow.setFundid(serviceFund.getId()); + serviceFundflow.setCheckuserno(user.getUserName()); + serviceFundflow.setCheckusername(user.getNickName()); + serviceFundflow.setFundtype(2); + serviceFundflow.setApplytype(serviceFund.getApplytype()); + serviceFundflow.setFlowconclusion(CheckFlag); + serviceFundflow.setFlowcontent("閫氳繃"); + Boolean aBoolean = serviceFundflowService.saveData(serviceFundflow); + return AjaxResult.success(); + } + //璁板綍涓�涓嬶紝涓嬩竴绾х殑瀹℃壒锛屼互渚夸簬涓嬩竴绾ч��鍥炲悗锛屽彂璧疯�呮彁浜ゆ椂锛岃兘鍐嶆彁鍒板綋鍓嶅鎵瑰眰绾� + serviceFund.setBackflowlevel(FlowLevel); } else { CheckFlag = 2; if (CheckFlag == 2) { //搴斿尰闄㈣姹傚鏋滃嚭鐜伴��鍥烇紝鐩存帴閫�鍒板彂璧疯�� FlowLevel = 0; + RecordStatus = -1; + logger.info("serviceFund杩涙潵浜嗗悧锛燂紵锛燂紵锛燂紵 :{},{}", RecordStatus, FlowLevel); + System.out.println("serviceFund杩涙潵浜嗗悧锛燂紵锛燂紵锛燂紵"); } else { RecordStatus = (FlowLevel + 1) * 2 - 1; FlowLevel = (FlowLevel - 1); @@ -504,7 +569,8 @@ } serviceFund.setRecordstatus(RecordStatus); - serviceFund.setFlowlevel(FlowLevel); + serviceFund.setFlowlevel(FlowLevel.longValue()); + // serviceFund.setBackflowlevel(serviceFund.getFlowlevel()); ServiceFundflow serviceFundflow = new ServiceFundflow(); SysUser user = loginUser.getUser(); @@ -514,11 +580,28 @@ serviceFundflow.setFundtype(2); serviceFundflow.setApplytype(serviceFund.getApplytype()); serviceFundflow.setFlowconclusion(CheckFlag); - serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent()); + if (org.apache.commons.lang.StringUtils.isNotBlank(checkFundVO.getFlowcontent())) { + serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent()); + } else { + serviceFundflow.setFlowcontent(checkFundVO.getFlowconclusion() == 1 ? "閫氳繃" : "涓嶉�氳繃"); + } serviceFundflow.setFlowlevel(OriginalFlowLevel + 1); - serviceFundflowService.save(serviceFundflow); - serviceFundService.updateById(serviceFund); + Boolean aBoolean = serviceFundflowService.saveData(serviceFundflow); + log.info("sserviceFund淇濆瓨鐨勭殑鍊兼槸-------- :{}", aBoolean); + + //001瀹℃壒閫氳繃涔嬪悗锛屽氨闇�瑕佹妸鈥滃姙鍏涓讳换鈥濈殑鍚嶅瓧濉笂 + if (checkFundVO.getFlowconclusion() == 1 && user.getUserName().equals("001")) { + serviceFund.setOfficedirector(user.getNickName()); + } + System.out.println("serviceFund鐨勫�兼槸--------:" + serviceFund); + log.info("寮�濮嬫洿鏂扮殑鐨勫�兼槸--------"); + ServiceFund updateServiceFund = new ServiceFund(); + updateServiceFund.setRecordstatus(serviceFund.getRecordstatus()); + updateServiceFund.setFlowlevel(serviceFund.getFlowlevel()); + + Boolean aBoolean1 = serviceFundService.updateById(serviceFund); + log.info("integer鏇存柊鐨勭殑鍊兼槸-------- :{}", aBoolean1); ServiceSystemmessage serviceSystemmessage = new ServiceSystemmessage(); serviceSystemmessage.setFundtype(2); serviceSystemmessage.setApplytype(serviceFund.getApplytype()); @@ -534,41 +617,9 @@ //閫氳繃 serviceSystemmessage.setMessagetitle("" + (OriginalFlowLevel + 1) + "绾у鏍搁�氳繃"); serviceSystemmessage.setMessagecontent("鎮�" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceFund.getCreateTime()) + "鎻愪氦鐨勫叧浜庢崘鐚渚嬨��" + serviceFund.getDonorname() + "銆戠殑璐圭敤鐢宠宸查�氳繃" + (OriginalFlowLevel + 1) + "绾у鏍�"); - if (TotalLevel == OriginalFlowLevel + 1) { - ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class); - serviceFundShared.setId(null); - serviceFundShared.setSerfunid(serviceFund.getId()); - serviceFundShared.setAmountrequested(new BigDecimal(serviceFund.getAmountrequested())); - serviceFundShared.setPrepaidamount(new BigDecimal(serviceFund.getPrepaidamount())); - serviceFundShared.setTotalcost(new BigDecimal(serviceFund.getTotalcost())); - serviceFundShared.setProcurementcost(new BigDecimal(serviceFund.getProcurementcost())); - serviceFundShared.setExpertcost(new BigDecimal(serviceFund.getExpertcost())); - serviceFundShared.setEthicscost(new BigDecimal(serviceFund.getEthicscost())); - serviceFundShared.setMedicalcost(new BigDecimal(serviceFund.getMedicalcost())); - serviceFundShared.setFamilycost(new BigDecimal(serviceFund.getFamilycost())); - serviceFundShared.setAftercarecost(new BigDecimal(serviceFund.getAftercarecost())); - fundSharedService.save(serviceFundShared); - - Map<String, Object> columnMap = new HashMap<>(); - columnMap.put("fundID", checkFundVO.getFundid()); - //鑾峰彇璇︽儏鏁版嵁 - List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.selectByMap(columnMap); - 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()); - serviceFunddetailShareds.get(i).setFdid(serviceFunddetails.get(i).getId()); - serviceFunddetailShareds.get(i).setAmount(new BigDecimal(serviceFunddetails.get(i).getAmount())); - serviceFunddetailShareds.get(i).setPrepaidamount(new BigDecimal(serviceFunddetails.get(i).getPrepaidamount())); - serviceFunddetailShareds.get(i).setTaxamount(new BigDecimal(serviceFunddetails.get(i).getTaxamount())); - serviceFunddetailShareds.get(i).setTaxedamount(new BigDecimal(serviceFunddetails.get(i).getTaxedamount())); - serviceFunddetailShareds.get(i).setQuantity(new BigDecimal(serviceFunddetails.get(i).getQuantity())); - serviceFunddetailShareds.get(i).setPrice(new BigDecimal(serviceFunddetails.get(i).getPrice())); - serviceFunddetailShareds.get(i).setId(null); - } - funddetailSharedService.saveBatch(serviceFunddetailShareds); - - } +// if (TotalLevel == OriginalFlowLevel + 1) { +// serviceFundService.addFundSharedInfo(checkFundVO.getFundid()); +// } } else { //椹冲洖 @@ -584,33 +635,74 @@ /** - * 淇敼璐圭敤鐢宠涓� + * 璐圭敤涓婃姤 */ - @ApiOperation("淇敼璐圭敤鐢宠涓�") - //@PreAuthorize("@ss.hasPermi('project:fund:edit')") - @Log(title = "璐圭敤鐢宠涓�", businessType = BusinessType.UPDATE) - @PutMapping + @ApiOperation("璐圭敤涓婃姤") + @Log(title = "璐圭敤涓婃姤", businessType = BusinessType.UPDATE) + @PostMapping("/fundEdit") @RepeatSubmit - public AjaxResult edit(@RequestBody ServiceFund serviceFund) { - List<ServiceFund> infoByInfoIdList = serviceFundService.getInfoByInfoId(serviceFund.getId()); + public AjaxResult fundEdit(@RequestBody ServiceFund serviceFund) { + log.info("淇敼璐圭敤鐢宠鍏ュ弬:{}", serviceFund); + List<ServiceFund> infoByInfoIdList = serviceFundService.queryInfoById(serviceFund); + log.info("淇敼璐圭敤鐢宠锛岄�氳繃鍏ュ弬鏌ヨ serviceFundService.queryInfoById鏁版嵁涓虹┖,鍏ュ弬:{}", infoByInfoIdList.size()); + if (CollectionUtils.isEmpty(infoByInfoIdList)) { + return toAjax(false); + } for (ServiceFund sf : infoByInfoIdList) { + sf.setApplyTime(new Date()); //濡傛灉绛変簬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); - + if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 199) { //灏唂und琛ㄧ殑瀹℃牳鐘舵�佹敼鎴�100 sf.setBackflowlevel(100); + + //閫�鍥炲啀鎻愪氦锛岄渶瑕佸啀鍒板嚭绾抽偅閲� + sf.setFlowlevel(1L); + sf.setRecordstatus(0); serviceFundService.updateById(sf); + +// //寰�鍒嗕韩琛ㄩ噷鏂板 +// serviceFundService.addFundSharedInfo(serviceFund.getId()); + return success(); + } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 100) { + //璐㈠姟閫�鍥炵殑鏁版嵁鍐嶆彁浜わ紝鍒板嚭绾抽偅閲屾病鏈夎繃锛屽啀閫�鍥烇紝瀵艰嚧backflowlevel鏄�100, + //閫�鍥炲啀鎻愪氦锛岄渶瑕佸啀鍒板嚭绾抽偅閲� + sf.setFlowlevel(1L); + sf.setRecordstatus(2); + serviceFundService.updateById(sf); + } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 2) { + //鑱傜閫�鍥炵殑锛屼篃闇�瑕佸厛鍒板嚭绾抽偅閲� + sf.setFlowlevel(1L); + sf.setRecordstatus(2); + serviceFundService.updateById(sf); } else { - serviceFund.setFlowlevel(sf.getBackflowlevel()); + + Integer TotalLevel = 0; + LoginUser loginUser = getLoginUser(); + SysUser user = loginUser.getUser(); + List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId()); + if (!postids.contains(2)) { + serviceFund.setRecordstatus(2); + if (serviceFund.getBackflowlevel() != null) { + serviceFund.setFlowlevel(serviceFund.getBackflowlevel().longValue()); + } else { + serviceFund.setBackflowlevel(1); + serviceFund.setFlowlevel(1L); + } + } else { + serviceFund.setRecordstatus(0); + if (serviceFund.getBackflowlevel() != null) { + serviceFund.setFlowlevel(serviceFund.getBackflowlevel().longValue()); + } else { + serviceFund.setFlowlevel(0L); + serviceFund.setBackflowlevel(0); + } + + } + // serviceFund.setFlowlevel(sf.getBackflowlevel()); boolean bret = serviceFundService.updateById(serviceFund); -// if (bret) { -// addReiSharedDatd(serviceFund, 2); -// } + log.info("serviceFundService.updateById杩斿弬:{}", bret); + return toAjax(bret); } } @@ -618,13 +710,14 @@ return toAjax(false); } + /** * 鍒犻櫎璐圭敤鐢宠涓� */ @ApiOperation("鍒犻櫎璐圭敤鐢宠涓�") //@PreAuthorize("@ss.hasPermi('project:fund:remove')") @Log(title = "璐圭敤鐢宠涓�", businessType = BusinessType.DELETE) - @DeleteMapping("/{ids}") + @GetMapping("/remove/{ids}") public AjaxResult remove(@PathVariable Long[] ids) { return toAjax(serviceFundService.removeByIds(Arrays.asList(ids))); } @@ -669,6 +762,7 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } @@ -682,16 +776,18 @@ String date = formatter.format(dt); String time = date.substring(0, 10); + dataMap.put("XZBH", serviceFund.getBh() == null ? "" : serviceFund.getBh()); + dataMap.put("ZB", serviceFund.getDeptmentname() == null ? "" : serviceFund.getDeptmentname()); dataMap.put("TBYYMMDD", time); - dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? " " : serviceFund.getAttachcount()); + dataMap.put("BXDFJ", serviceFund.getAttachcount() == null ? " " : serviceFund.getAttachcount()); dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname()); dataMap.put("JSR", serviceFund.getUsername() == null ? "" : serviceFund.getUsername()); // dataMap.put("FYXM1", "鏀粯涓撳璐圭敤锛屽叾涓◣鍓嶉噾棰�" + serviceFund.getPretaxcost() + "鍏冿紝绋庡悗閲戦" + serviceFund.getTaxedcost() + "鍏冦��"); - dataMap.put("FYXM1", "浜轰綋鍣ㄥ畼鎹愮尞涓撳鍔冲姟璐�:" + serviceFund.getTaxedcost() + "鍏� (鍏朵腑绋庡悗璐圭敤鐢变腑蹇冩壙鎷呯◣璐�)銆�"); + dataMap.put("FYXM1", "浜轰綋鍣ㄥ畼鎹愮尞涓撳鍔冲姟璐�:" + serviceFund.getPretaxcost() + "鍏� (鍏朵腑绋庡悗璐圭敤鐢变腑蹇冩壙鎷呯◣璐�)銆�"); dataMap.put("FYXM2", ""); dataMap.put("FYXM3", ""); - dataMap.put("JEXS", serviceFund.getAmountrequested()); - dataMap.put("JEDS", convert(serviceFund.getAmountrequested()) + "鏁�"); + dataMap.put("JEXS", serviceFund.getPretaxcost()); + dataMap.put("JEDS", convert(serviceFund.getPretaxcost()) + "鏁�"); dataMap.put("BXBZ", serviceFund.getRemark() == null ? "" : serviceFund.getRemark()); @@ -741,16 +837,34 @@ List<Double> sqljList = new ArrayList<>(); List<Double> ksljList = new ArrayList<>(); List<Double> shljList = new ArrayList<>(); - Map<String, Optional<ServiceFunddetailAssort>> result = fd.stream().collect(Collectors.groupingBy(ServiceFunddetail::getSubjecttypename, Collectors.mapping(obj -> new ServiceFunddetailAssort(obj.getAmount(), obj.getTaxamount(), obj.getTaxedamount()), Collectors.reducing(ServiceFunddetailAssort::add)))); - result.forEach((FWFL, serviceFunddetailAssort) -> { + + //鏍规嵁鈥濈鐩被鍨嬪悕绉扳�滐紝鏉ヨ绠楃◣鍓嶆�诲拰锛岀◣閲戞�诲拰,绋庡悗鎬诲拰 + Map<String, ServiceFunddetailAssort> funddetailMap = new HashMap<>(); + for (ServiceFunddetail serviceFunddetail : fd) { + boolean b = funddetailMap.containsKey(serviceFunddetail.getSubjecttypename()); + if (b == true) { + ServiceFunddetailAssort serviceFunddetailAssort = funddetailMap.get(serviceFunddetail.getSubjecttypename()); + serviceFunddetailAssort.setKSXJ(serviceFunddetailAssort.getKSXJ() + serviceFunddetail.getTaxamount()); + serviceFunddetailAssort.setSQXJ(serviceFunddetailAssort.getSQXJ() + serviceFunddetail.getAmount()); + serviceFunddetailAssort.setSHXJ(serviceFunddetailAssort.getSHXJ() + serviceFunddetail.getTaxedamount()); + } else { + funddetailMap.put(serviceFunddetail.getSubjecttypename(), new ServiceFunddetailAssort()); + ServiceFunddetailAssort serviceFunddetailAssort = funddetailMap.get(serviceFunddetail.getSubjecttypename()); + serviceFunddetailAssort.setKSXJ(serviceFunddetailAssort.getKSXJ() + serviceFunddetail.getTaxamount()); + serviceFunddetailAssort.setSQXJ(serviceFunddetailAssort.getSQXJ() + serviceFunddetail.getAmount()); + serviceFunddetailAssort.setSHXJ(serviceFunddetailAssort.getSHXJ() + serviceFunddetail.getTaxedamount()); + } + } + + funddetailMap.forEach((FWFL, serviceFunddetailAssort) -> { Map<String, Object> map1 = new HashMap<String, Object>(); map1.put("FWFL", FWFL); - map1.put("SQXJ", serviceFunddetailAssort.get().getSQXJ()); - map1.put("KSXJ", serviceFunddetailAssort.get().getKSXJ()); - map1.put("SHXJ", serviceFunddetailAssort.get().getSHXJ()); - sqljList.add(serviceFunddetailAssort.get().getSQXJ()); - ksljList.add(serviceFunddetailAssort.get().getKSXJ()); - shljList.add(serviceFunddetailAssort.get().getSHXJ()); + map1.put("SQXJ", serviceFunddetailAssort.getSQXJ()); + map1.put("KSXJ", serviceFunddetailAssort.getKSXJ()); + map1.put("SHXJ", serviceFunddetailAssort.getSHXJ()); + sqljList.add(serviceFunddetailAssort.getSQXJ()); + ksljList.add(serviceFunddetailAssort.getKSXJ()); + shljList.add(serviceFunddetailAssort.getSHXJ()); lists.add(map1); }); @@ -771,7 +885,7 @@ dataMap.put("list", newsList); for (int i = 0; i < lists.size(); i++) { Map<String, Object> map = lists.get(i); - map.put("XH", i+1); + map.put("XH", i + 1); } dataMap.put("item", lists); @@ -924,11 +1038,13 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } private void getDataSS(Map dataMap, Long id) { ServiceFund serviceFund = serviceFundService.getById(id); + log.info("閫氳繃id鏌ヨ鏁版嵁鐨勭粨鏋滐細{}", serviceFund); if (serviceFund == null) { throw new ServiceException("涓嬭浇澶辫触锛岀敤鎴蜂俊鎭嚭閿�", HttpStatus.NO_CONTENT); } @@ -971,13 +1087,13 @@ } /** - * 涓嬭浇鎹愮尞鑰呭尰瀛︽垚鏈粺璁¤〃 + * 涓嬭浇鎹愮尞鑰呭尰瀛︺�佸姙鍏�佺哗鏁堟垚鏈粺璁¤〃 */ - @ApiOperation("鎹愮尞鑰呭尰瀛︽垚鏈粺璁¤〃") + @ApiOperation("鎹愮尞鑰呭尰瀛︺�佸姙鍏�佺哗鏁堟垚鏈粺璁¤〃") @GetMapping(value = "/downloadYX/{id}") public Map downloadInfoYX(@PathVariable("id") Long id) throws IOException { Map dataMap = new HashMap(); - getDataYX(dataMap, id); + String dataYX = getDataYX(dataMap, id); String filePath = getClass().getResource("/template/").getPath(); System.out.println(filePath); //璁剧疆妯℃湰瑁呯疆鏂规硶鍜岃矾寰�,FreeMarker鏀寔澶氱妯℃澘瑁呰浇鏂规硶銆傚彲浠ラ噸servlet锛宑lasspath锛屾暟鎹簱鏁欑▼瑁呰浇锛� @@ -986,13 +1102,26 @@ Template t = null; try { //鎹愮尞琛�.ftl涓鸿瑁呰浇鐨勬ā鏉� - t = configuration.getTemplate("鍖诲鎴愭湰璐圭敤鐢宠鍗�.ftl"); + //涓撳鍔冲姟璐圭敵璇� 1 浼︾悊璇勪及鍔冲姟璐圭敵璇� 2 鍖诲鎴愭湰璐圭敤鐢宠 3 鍔炲叕璐圭敤鎶ラ攢鐢宠 4 缁╂晥璐圭敤鎶ラ攢鐢宠 5 + if (dataYX.equals("3")) { + t = configuration.getTemplate("鍖诲鎴愭湰璐圭敤鐢宠鍗�.ftl"); + } else if (dataYX.equals("4")) { + t = configuration.getTemplate("鍔炲叕璐圭敤鐢宠鍗�.ftl"); + } else if (dataYX.equals("5")) { + t = configuration.getTemplate("缁╂晥璐圭敤鐢宠鍗�.ftl"); + } } catch (IOException e) { e.printStackTrace(); } String newTime = String.valueOf(Calendar.getInstance().getTimeInMillis()); - String name = "鍖诲鎴愭湰璐圭敤鐢宠鍗昣" + dataMap.get("XM") + "_" + newTime; - + String name = null; + if (dataYX.equals("3")) { + name = "鍖诲鎴愭湰璐圭敤鐢宠鍗昣" + dataMap.get("XM") + "_" + newTime; + } else if (dataYX.equals("4")) { + name = "鍔炲叕璐圭敤鐢宠鍗昣" + dataMap.get("XM") + "_" + newTime; + } else if (dataYX.equals("5")) { + name = "缁╂晥璐圭敤鐢宠鍗昣" + dataMap.get("XM") + "_" + newTime; + } //杈撳嚭鏂囨。璺緞鍙婂悕绉� File outFile = new File(RuoYiConfig.getProfile() + "/download/wordtemplate/" + name + ".doc"); Writer out = null; @@ -1004,27 +1133,47 @@ e1.printStackTrace(); } try { + t.process(dataMap, out); } catch (TemplateException e) { e.printStackTrace(); } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } - private void getDataYX(Map dataMap, Long id) { + private String getDataYX(Map dataMap, Long id) { ServiceFund serviceFund = serviceFundService.getById(id); + log.info("閫氳繃id鑾峰彇鍖诲銆佸姙鍏�佺哗鏁堟垚鏈殑fund淇℃伅涓猴細{}", serviceFund); if (serviceFund == null) { throw new ServiceException("涓嬭浇澶辫触锛岀敤鎴蜂俊鎭嚭閿�", HttpStatus.NO_CONTENT); } + ServiceExternalperson infoByUserNo = null; + if (StringUtils.isNotBlank(serviceFund.getUserno())) { + infoByUserNo = externalpersonService.getInfoByUserNo(serviceFund.getUserno()); + } List<ServiceFunddetail> fd = serviceFunddetailService.getAllDetailsByFDIDHZ(id); + if (serviceFund.getApplytype().equals("5")) { + //缁╂晥鐨勮鎯呭鏋滃皬浜�3琛岋紝榛樿瑕佺瓑浜�3琛� + if (fd.size() < 3) { + for (int i = 0; i <= 3 - fd.size(); i++) { + ServiceFunddetail serviceFunddetail = new ServiceFunddetail(); + serviceFunddetail.setQuantity(0.00); + serviceFunddetail.setPrice(0.00); + serviceFunddetail.setAmount(0.00); + fd.add(serviceFunddetail); + } + } + } if (fd == null) { throw new ServiceException("涓嬭浇澶辫触锛屾病鏈夊搴斾俊鎭�", HttpStatus.NO_CONTENT); } - Date dt = serviceFund.getCreateTime(); +// Date dt = serviceFund.getCreateTime(); + Date dt = serviceFund.getApplyTime(); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String date = formatter.format(dt); String time = date.substring(0, 10); @@ -1032,31 +1181,101 @@ List<Map<String, Object>> newList = new ArrayList<Map<String, Object>>(); int seqno = 0; + dataMap.put("ZB", serviceFund.getDeptmentname() == null ? "" : serviceFund.getDeptmentname()); + dataMap.put("XZBH", serviceFund.getBh() == null ? "" : serviceFund.getBh()); dataMap.put("TBYYMMDD", time); dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? " " : serviceFund.getAttachcount()); dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname()); dataMap.put("JSR", serviceFund.getUsername() == null ? "" : serviceFund.getUsername()); + dataMap.put("YWZ", serviceFund.getDeptmentname() == null ? "" : serviceFund.getDeptmentname()); + dataMap.put("ZHUZANG", serviceFund.getManagername() == null ? "" : serviceFund.getManagername()); - for (ServiceFunddetail f : fd) { - seqno++; + + if (StringUtils.isEmpty(serviceFund.getRemark())) { + dataMap.put("FYMC", LocalDate.now().getYear() + "骞�" + LocalDate.now().getMonthValue() + "鏈堜汉浣撳櫒瀹樿幏鍙栨湇鍔$鐞嗕腑蹇冨伐浣滀汉鍛樼哗鏁�"); + } else { + dataMap.put("FYMC", serviceFund.getRemark().substring(0, serviceFund.getRemark().length() - 2) + "浜轰綋鍣ㄥ畼鑾峰彇鏈嶅姟绠$悊涓績宸ヤ綔浜哄憳缁╂晥"); + } + String bz = ""; + int i = 0; + if (!serviceFund.getApplytype().equals("5")) { + for (ServiceFunddetail f : fd) { + seqno++; + Map<String, Object> map = new HashMap<String, Object>(); + map.put("seqno", seqno); + + //濡傛灉鏄尰鐤楁垚鏈紝鍒欐妸閾惰鍗″姞涓婃瘡鏉℃槑缁嗙殑鍚庨潰 + if (serviceFund.getApplytype().equals("3")) { + i = i + 1; + bz += f.getBeneficiaryname() == null ? "(" + i + ")" : "(" + i + ")" + f.getBeneficiaryname() + "锛�"; + bz += "閲戦 : " + f.getAmount() + "鍏�" + "锛�"; + bz += f.getDepositbank() == null ? "" : f.getDepositbank() + ": "; + bz += f.getBankcardno() == null ? "" : f.getBankcardno(); + bz += "<w:br/>"; + } + if (serviceFund.getApplytype().equals("4")) { + i = i + 1; + bz += f.getBeneficiaryname() == null ? "(" + i + ")" : "(" + i + ")" + f.getBeneficiaryname() + "锛�"; + bz += "閲戦 : " + f.getAmount() + "鍏�" + "锛�"; + bz += f.getDepositbank() == null ? "" : f.getDepositbank() + ": "; + bz += f.getBankcardno() == null ? "" : f.getBankcardno(); + bz += "<w:br/>"; + } + + + String fyxm = ""; + fyxm += f.getItemname() == null ? "" : f.getItemname(); + fyxm += f.getAmount() + "鍏�"; + if (f.getItemname() == null && f.getAmount() == 0.0) { + fyxm = ""; + } + map.put("FYXM", fyxm); + newList.add(map); + } + } else { Map<String, Object> map = new HashMap<String, Object>(); - map.put("seqno", seqno); + map.put("seqno", 1); String fyxm = ""; - fyxm += f.getItemname() == null ? "" : f.getItemname(); - fyxm += f.getAmount() + "鍏�"; - fyxm += "("; - fyxm += f.getUnitname() == null ? "" : f.getUnitname() + ";"; - fyxm += f.getDepositbank() == null ? "" : f.getDepositbank() + ": "; - fyxm += f.getBankcardno() == null ? "" : f.getBankcardno(); - fyxm += ")"; + if (StringUtils.isEmpty(serviceFund.getRemark())) { + fyxm += LocalDate.now().getYear() + "骞�" + LocalDate.now().getMonthValue() + "鏈堜汉浣撳櫒瀹樿幏鍙栨湇鍔$鐞嗕腑蹇冨伐浣滀汉鍛樼哗鏁�,鍏辫"; + } else { + fyxm += serviceFund.getRemark().substring(0, serviceFund.getRemark().length() - 2) + "浜轰綋鍣ㄥ畼鑾峰彇鏈嶅姟绠$悊涓績宸ヤ綔浜哄憳缁╂晥,鍏辫"; + } + fyxm += serviceFund.getPretaxcost() + "鍏�"; + if (serviceFund.getPretaxcost() == null && serviceFund.getPretaxcost() == 0.0) { + fyxm = ""; + } map.put("FYXM", fyxm); newList.add(map); + Map<String, Object> objectObjectHashMap = new HashMap<>(); + objectObjectHashMap.put("seqno", 2); + objectObjectHashMap.put("FYXM", ""); + newList.add(objectObjectHashMap); + + Map<String, Object> objectObjectHashMap2 = new HashMap<>(); + objectObjectHashMap2.put("seqno", 3); + objectObjectHashMap2.put("FYXM", ""); + newList.add(objectObjectHashMap2); } + + + //鍚堝苟鍗曞厓鏍� + checkList(newList); dataMap.put("items", newList); - dataMap.put("JEXS", serviceFund.getAmountrequested()); - dataMap.put("JEDS", convert(serviceFund.getAmountrequested()) + "鏁�"); - dataMap.put("BXBZ", serviceFund.getRemark() == null ? "" : serviceFund.getRemark()); + dataMap.put("JEXS", serviceFund.getPretaxcost()); + dataMap.put("JEDS", convert(serviceFund.getPretaxcost()) + "鏁�"); +// dataMap.put("JEXS", serviceFund.getAmountrequested()); +// dataMap.put("JEDS", convert(serviceFund.getAmountrequested()) + "鏁�"); + //澶囨敞閲屾斁鐨勬槸缁忓姙浜虹殑閾惰鍗′俊鎭� + + 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()); + dataMap.put("BGSZR", serviceFund.getOfficedirector() == null ? "" : serviceFund.getOfficedirector()); + dataMap.put("CWBZR", serviceFund.getFinancedirector() == null ? "" : serviceFund.getFinancedirector()); + dataMap.put("CWSH", serviceFund.getFinancechecher() == null ? "" : serviceFund.getFinancechecher()); dataMap.put("YYMMDD", time); dataMap.put("XM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname()); @@ -1073,7 +1292,7 @@ count++; map.put("XH", count); map.put("FWNR", f.getItemname() == null ? "" : f.getItemname()); - map.put("DW", f.getUnitname() == null ? "" : f.getUnitname()); + map.put("DW", f.getBeneficiaryname() == null ? "" : f.getBeneficiaryname()); map.put("SL", f.getQuantity() == 0.00 ? "" : f.getQuantity()); map.put("JG", f.getPrice() == 0.00 ? "" : f.getPrice()); @@ -1086,6 +1305,21 @@ dataMap.put("list", newsList); dataMap.put("BYHJ", hj); + dataMap.put("BGSZR2", serviceFund.getOfficedirector() == null ? "" : serviceFund.getOfficedirector()); + dataMap.put("CWBZR2", serviceFund.getFinancedirector() == null ? "" : serviceFund.getFinancedirector()); + dataMap.put("CWSH2", serviceFund.getFinancechecher() == null ? "" : serviceFund.getFinancechecher()); + + return serviceFund.getApplytype(); + } + + public List<Map<String, Object>> checkList(List<Map<String, Object>> list) { + String start = "<w:vMerge w:val='restart'/>"; + String end = "<w:vMerge/>"; + list.get(0).put("start", start); + for (int i = 1; i < list.size(); i++) { + list.get(i).put("end", end); + } + return list; } @@ -1129,6 +1363,7 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } @@ -1197,6 +1432,7 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } @@ -1696,6 +1932,7 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } @@ -1710,6 +1947,7 @@ String date = formatter.format(dt); String time = date.substring(0, 10); + dataMap.put("XZBH", serviceFund.getBh() == null ? "" : serviceFund.getBh()); dataMap.put("YYMMDD", time); dataMap.put("XM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname()); dataMap.put("GZRY", serviceFund.getUsername() == null ? "" : serviceFund.getUsername()); @@ -1783,6 +2021,7 @@ } Map<String, Object> map = new HashMap<>(); map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); + map.put("downloadName", name + ".doc"); return map; } @@ -1796,6 +2035,8 @@ String date = formatter.format(dt); String time = date.substring(0, 10); + dataMap.put("ZB", serviceFund.getDeptmentname() == null ? "" : serviceFund.getDeptmentname()); + dataMap.put("XZBH", serviceFund.getBh() == null ? "" : serviceFund.getBh()); dataMap.put("TBYYMMDD", time); dataMap.put("BXDFJ", serviceFund.getAttachcount() == 0 ? " " : serviceFund.getAttachcount()); dataMap.put("JXZXM", serviceFund.getDonorname() == null ? "" : serviceFund.getDonorname()); @@ -1852,7 +2093,6 @@ dataMap.put("SQZE", String.format("%.2f", sh).toString() + ""); - } @@ -1880,6 +2120,7 @@ /** * 璐圭敤绫诲瀷璁℃暟 */ +// @NotRepeatCommit(key = "param:arg[1]", value = 30000) @ApiOperation("璐圭敤绫诲瀷璁℃暟") @GetMapping(value = "/countItem/{infoid}/{itemid}") public AjaxResult countItem(@PathVariable Long infoid, @PathVariable Long itemid) { @@ -1889,4 +2130,47 @@ } + /** + * 缁╂晥璁$畻 + */ + @ApiOperation("缁╂晥璁$畻") + @Log(title = "缁╂晥璁$畻", businessType = BusinessType.INSERT) + @PostMapping("/performance") + @RepeatSubmit + public AjaxResult performance(@RequestBody ServiceFundVO serviceFundVO) { + + return AjaxResult.success(serviceFundService.performance(serviceFundVO)); + } + + /** + * 鍚堣涓◣ + */ + @NotRepeatCommit(key = "param:arg[1]", value = 30000) + @ApiOperation("鍚堣涓◣") + @Log(title = "鍚堣涓◣", businessType = BusinessType.INSERT) + @PostMapping("/totaltax") + public AjaxResult totaltax(@RequestBody TotalTaxVO totalTaxVO) { + Map<String, List<ServiceFunddetailExcel>> totaltax = serviceFundService.totaltax(totalTaxVO); + if (ObjectUtils.isEmpty(totaltax)) { + throw new BaseException("鍚堣涓◣澶辫触"); + } + + Set<String> strings = totaltax.keySet(); + String key2 = null; + for (String key : strings) { + key2 = key; + } + ExcelUtil<ServiceFunddetailExcel> util = new ExcelUtil<ServiceFunddetailExcel>(ServiceFunddetailExcel.class); + AjaxResult ajaxResult = util.exportExcel(totaltax.get(key2), key2); + String msg = (String) ajaxResult.get("msg"); + + Map dataMap = new HashMap(); + dataMap.put("downloadUrl", "/profile/download/" + msg); + dataMap.put("downloadName", msg); + + return AjaxResult.success(dataMap); + + + } + } -- Gitblit v1.9.3