| | |
| | | package com.ruoyi.web.controller.project; |
| | | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | 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; |
| | |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | 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; |
| | |
| | | import freemarker.template.TemplateException; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.lang.StringUtils; |
| | | import org.apache.ibatis.annotations.Options; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | |
| | | |
| | | import java.io.*; |
| | | import java.math.BigDecimal; |
| | | import java.text.DecimalFormat; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | | import java.util.regex.Pattern; |
| | | import java.util.stream.Collectors; |
| | | |
| | | |
| | |
| | | * @author ruoyi |
| | | * @date 2022-01-24 |
| | | */ |
| | | @Slf4j |
| | | @Api("报销申请") |
| | | @RestController |
| | | @RequestMapping("/project/reimbursement") |
| | |
| | | private IServiceReimbursementService serviceReimbursementService; |
| | | |
| | | @Autowired |
| | | private IServiceReimbursementpayeeService reimbursementpayeeService; |
| | | private IServiceReimbursementSharedService serviceReimbursementSharedService; |
| | | |
| | | @Autowired |
| | | private IServiceReimbursementSharedService serviceReimbursementServiceShare; |
| | | private IServiceReimbursementpayeeService reimbursementpayeeService; |
| | | |
| | | @Autowired |
| | | private IServiceReimbursementdetailService serviceReimbursementdetailService; |
| | |
| | | |
| | | @Autowired |
| | | private IServiceFundflowService serviceFundflowService; |
| | | |
| | | @Autowired |
| | | private IServiceFundService serviceFundService; |
| | | |
| | | @Autowired |
| | | private IBaseOnlyvalueService baseOnlyvalueService; |
| | | |
| | | @Autowired |
| | | private ISysPostService postService; |
| | |
| | | public TableDataInfo list(ServiceReimbursement serviceReimbursement) { |
| | | SysUser user = SecurityUtils.getLoginUser().getUser(); |
| | | serviceReimbursement.setCreateBy(user.getUserName()); |
| | | serviceReimbursement.setUsername(user.getNickName()); |
| | | startPage(); |
| | | List<ServiceReimbursement> list = serviceReimbursementService.queryList(serviceReimbursement); |
| | | return getDataTable(list); |
| | |
| | | String APPLICATIONENDTIME = spFinancialExpensesIn.getAPPLICATIONENDTIME(); |
| | | Integer CHECKFLAG = spFinancialExpensesIn.getCHECKFLAG(); |
| | | Integer APPLYTYPE = spFinancialExpensesIn.getAPPLYTYPE(); |
| | | Integer checkstatus = spFinancialExpensesIn.getCheckstatus(); |
| | | Integer pageNum = spFinancialExpensesIn.getPageNum(); |
| | | Integer pageSize = spFinancialExpensesIn.getPageSize(); |
| | | String donorname = spFinancialExpensesIn.getDonorname(); |
| | | |
| | | if (pageNum == null) { |
| | | pageNum = 1; |
| | |
| | | APPLICATIONENDTIME = ""; |
| | | } |
| | | //startPage(); |
| | | List<SpFinancialExpensesReimbursementOut> list = serviceReimbursementService.getListBypower(loginUser.getUsername(), 1, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE); |
| | | List<SpFinancialExpensesReimbursementOut> list = serviceReimbursementService.getListBypower(loginUser.getUsername(), 1, APPLICANT, APPLICATIONBEGTIME, APPLICATIONENDTIME, loginUser.getDeptId().toString(), CHECKFLAG, APPLYTYPE, checkstatus, donorname); |
| | | //根据经办人筛选 |
| | | 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()).compareTo(new BigDecimal(spFinancialExpensesIn.getMoney())) == 0).collect(Collectors.toList()); |
| | | |
| | | } |
| | | //根据创建时间排序 |
| | | Collections.sort(list, new Comparator<SpFinancialExpensesReimbursementOut>() { |
| | | @Override |
| | | public int compare(SpFinancialExpensesReimbursementOut o1, SpFinancialExpensesReimbursementOut o2) { |
| | | return o2.getCreateTime().compareTo(o1.getCreateTime()); |
| | | return o1.getCreateTime().compareTo(o2.getCreateTime()); |
| | | } |
| | | }); |
| | | return getCustomDataTable(list, pageNum, pageSize); |
| | |
| | | @RepeatSubmit |
| | | @Options(useGeneratedKeys = true, keyProperty = "id") |
| | | public AjaxResult add(@RequestBody ServiceReimbursement serviceReimbursement) { |
| | | |
| | | boolean b = serviceReimbursementService.save(serviceReimbursement); |
| | | // if (b) { |
| | | // addReiSharedDatd(serviceReimbursement, 1); |
| | | // } |
| | | Long id = serviceReimbursement.getId(); |
| | | return AjaxResult.success(id); |
| | | if (!Objects.isNull(serviceReimbursement)) { |
| | | serviceReimbursement.setCreateTime(new Date()); |
| | | serviceReimbursement.setCheckstatus(serviceReimbursement.getCheckstatus() == null ? 1 : serviceReimbursement.getCheckstatus()); |
| | | boolean b = serviceReimbursementService.save(serviceReimbursement); |
| | | Long id = serviceReimbursement.getId(); |
| | | return AjaxResult.success(id); |
| | | } |
| | | return error(); |
| | | } |
| | | |
| | | // public int addReiSharedDatd(ServiceReimbursement serviceReimbursement, int nType) { |
| | | // //remShare = ; |
| | | // ServiceReimbursementShared remShare = new ServiceReimbursementShared(); |
| | | // if (nType == 1) { |
| | | // // remShare = new ServiceReimbursementShared(); |
| | | // remShare.setReimid(serviceReimbursement.getId()); |
| | | // } else //modify |
| | | // { |
| | | // List<ServiceReimbursementShared> remlist = serviceReimbursementServiceShare.getRemShareInfoByRemId(serviceReimbursement.getId()); |
| | | // if (!CollectionUtils.isEmpty(remlist)) remShare = remlist.get(0); |
| | | // } |
| | | // |
| | | // remShare.setUserno(serviceReimbursement.getUserno()); |
| | | // remShare.setUsername(serviceReimbursement.getUsername()); |
| | | // remShare.setTravelers(serviceReimbursement.getTravelers()); |
| | | // remShare.setIdcardtype(serviceReimbursement.getIdcardtype()); |
| | | // remShare.setIdcardno(serviceReimbursement.getIdcardno()); |
| | | // remShare.setPhone(serviceReimbursement.getPhone()); |
| | | // remShare.setDepositbank(serviceReimbursement.getDepositbank()); |
| | | // remShare.setBankcardno(serviceReimbursement.getBankcardno()); |
| | | // remShare.setBranchbankname(serviceReimbursement.getBranchbankname()); |
| | | // remShare.setAnnexbankcard(serviceReimbursement.getAnnexbankcard()); |
| | | // remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); |
| | | // //remShare.setAnnexfiles(serviceReimbursement.getAnnexfiles()); |
| | | // // remShare.setAmountrequested(BigDecimal.valueOf(serviceReimbursement.getAmountrequested())); |
| | | // |
| | | // Double nTemp = serviceReimbursement.getAmountrequested(); |
| | | // if (nTemp == null) nTemp = 0d; |
| | | // remShare.setAmountrequested(BigDecimal.valueOf(nTemp)); |
| | | // |
| | | // nTemp = serviceReimbursement.getPrepaidamount(); |
| | | // if (nTemp == null) nTemp = 0.0; |
| | | // remShare.setPrepaidamount(BigDecimal.valueOf(nTemp)); |
| | | // |
| | | // remShare.setInvoicecount(serviceReimbursement.getInvoicecount()); |
| | | // remShare.setAttachcount(serviceReimbursement.getAttachcount()); |
| | | // remShare.setManagerno(serviceReimbursement.getManagerno()); |
| | | // remShare.setManagername(serviceReimbursement.getManagername()); |
| | | // remShare.setDeptmentno(serviceReimbursement.getDeptmentno()); |
| | | // remShare.setDeptmentname(serviceReimbursement.getDeptmentname()); |
| | | // remShare.setOpochecker(serviceReimbursement.getOpochecker()); |
| | | // remShare.setFinvicepresident(serviceReimbursement.getFinvicepresident()); |
| | | // remShare.setBusvicepresident(serviceReimbursement.getBusvicepresident()); |
| | | // remShare.setOfficedirector(serviceReimbursement.getOfficedirector()); |
| | | // remShare.setFinancedirector(serviceReimbursement.getFinancedirector()); |
| | | // remShare.setFinancechecher(serviceReimbursement.getFinancechecher()); |
| | | // remShare.setInfoid(serviceReimbursement.getInfoid()); |
| | | // remShare.setDonorno(serviceReimbursement.getDonorno()); |
| | | // |
| | | // remShare.setDonorname(serviceReimbursement.getDonorname()); |
| | | // remShare.setReason(serviceReimbursement.getReason()); |
| | | // remShare.setRecordstatus(serviceReimbursement.getRecordstatus()); |
| | | // remShare.setUploadflag(serviceReimbursement.getUploadflag()); |
| | | // remShare.setUploadtime(serviceReimbursement.getUploadtime()); |
| | | // |
| | | // nTemp = serviceReimbursement.getTotalamount(); |
| | | // if (nTemp == null) nTemp = 0.0; |
| | | // remShare.setTotalamount(BigDecimal.valueOf(nTemp)); |
| | | // |
| | | // remShare.setBigstrmoney(serviceReimbursement.getBigstrmoney()); |
| | | // remShare.setFlowlevel(serviceReimbursement.getFlowlevel()); |
| | | // remShare.setCosttype(serviceReimbursement.getCosttype()); |
| | | // remShare.setCosttypename(serviceReimbursement.getCosttypename()); |
| | | // remShare.setFileurl(serviceReimbursement.getAnnexfiles()); |
| | | // remShare.setDonorbank(serviceReimbursement.getDonorbank()); |
| | | // remShare.setDonorbankcard(serviceReimbursement.getDonorbankcard()); |
| | | // remShare.setDonorremark(serviceReimbursement.getDonorremark()); |
| | | // |
| | | // nTemp = serviceReimbursement.getDonoramount(); |
| | | // if (nTemp == null) nTemp = 0.0; |
| | | // remShare.setDonoramount(nTemp); |
| | | // remShare.setDonorrelatives(serviceReimbursement.getDonorrelatives()); |
| | | // //remShare.setOaid(serviceReimbursement.getOaid()); |
| | | // //remShare.setDonorno(serviceReimbursement.getDonorno()); |
| | | // |
| | | // boolean bRet = false; |
| | | // if (nType == 1) { |
| | | // bRet = serviceReimbursementServiceShare.save(remShare); |
| | | // } else { |
| | | // //remShare.setId(serviceReimbursement.); |
| | | // bRet = serviceReimbursementServiceShare.updateById(remShare); |
| | | // } |
| | | // |
| | | // //if(!bRet) return -1; |
| | | // String strMutfileUrl = remShare.getFileurl(); |
| | | // //有附件时才调用第三方进行上传 |
| | | // if (strMutfileUrl == null) return 0; |
| | | // if (strMutfileUrl.isEmpty()) return 0; |
| | | // |
| | | // try { |
| | | // uploadOAFileAndUpdateDb(remShare); |
| | | // } catch (Exception e) { |
| | | // logger.error("调用第三方接口出错!"); |
| | | // e.printStackTrace(); |
| | | // } |
| | | // |
| | | // //此处保存成功后要上传OA,保存返回值 |
| | | // |
| | | // return 0; |
| | | // } |
| | | |
| | | |
| | | // int uploadOAFileAndUpdateDb(ServiceReimbursementShared remShare) { |
| | | // //上传OA文件 |
| | | // //String strUrl = "http://129.88.242.39:8899/seeyon/rest/token?userName=opo&password=127814f8-84e8-4304-84a5-a71573567efd&loginName=demo3"; |
| | | // String strUrl = "http://129.88.242.39:8899/seeyon/rest/token"; |
| | | // //String strUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/token"; |
| | | // //上传文件成功后,去更新相关的数据库 |
| | | // |
| | | // |
| | | // Map<String, Object> map = new HashMap<String, Object>(); |
| | | // map.put("userName", "opo"); |
| | | // map.put("password", "4126407a-9821-4874-be41-6568abd6dbe5"); |
| | | // map.put("loginName", "demo3"); |
| | | // |
| | | // JSONObject jsonObj = new JSONObject(map); |
| | | // |
| | | // System.out.println("uploadOAFileAndUpdateDb + jsonObject" + jsonObj.toString() + "\r\n" + jsonObj.toJSONString()); |
| | | // String strRes = HttpClientKit.postOpr(strUrl, jsonObj.toString());// |
| | | // //String strRes = HttpClientKit.postMsg(strUrl,jsonObj);//得到返回的token? |
| | | // |
| | | // JSONObject json1 = JSONObject.parseObject(strRes); |
| | | // strRes = json1.get("id").toString(); |
| | | // |
| | | // ///if(strRes.isEmpty() || "" == strRes) return -1;// 为空代表失败 |
| | | // |
| | | // //下面需求调用文件的接口,调用成功返回后,得到filename和fileid 用这二个值去更新数据 |
| | | // |
| | | // String filePath = RuoYiConfig.getUploadPath(); |
| | | // String strMutfileUrl = remShare.getFileurl();//可能存在多个地址,以,分开 |
| | | // |
| | | // String strFUrl = "http://129.88.242.39:8899/seeyon/rest/attachment?token=" + strRes; |
| | | // //String strFUrl = "http://slb.hospitalstar.com:8899/seeyon/rest/attachment?token="+strRes; |
| | | // //strFUrl = String.format(strFUrl, strRes); |
| | | // |
| | | // /*File test = null; |
| | | // File file = new File("E:\\YYJQ\\OPO\\WEB\\Upload\\upload\\2023\\02\\17"); |
| | | // if (file.exists() && file.isDirectory()) { |
| | | // // 获取所有盲盒文件夹 |
| | | // File[] ones = file.listFiles(); |
| | | // for (File one : ones) { |
| | | // test = one; |
| | | // } |
| | | // }*/ |
| | | // |
| | | // String filename = ""; |
| | | // String fileid = ""; |
| | | // |
| | | // String[] urlArray = strMutfileUrl.split(","); |
| | | // for (int i = 0; i < urlArray.length; i++) { |
| | | // String strOneFileName = urlArray[i]; |
| | | // String strTemp = strOneFileName.substring(15); |
| | | // String strFile = filePath + strTemp; |
| | | // //FileUploadUtils.getAbsoluteFile(filePath,strOneFileName); |
| | | // String struploadResult = ""; |
| | | // File filetest = new File(strFile); |
| | | // try { |
| | | // struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); |
| | | // } catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | // |
| | | // |
| | | // /*CloseableHttpClient httpClient = HttpClients.createDefault(); |
| | | // //创建post方法连接实例,在post方法中传入待连接地址 |
| | | // HttpPost httpPost = new HttpPost(strFUrl); |
| | | // CloseableHttpResponse response = null; |
| | | // |
| | | // String struploadResult = ""; |
| | | // try { |
| | | // //设置请求参数(类似html页面中name属性) |
| | | // MultipartEntityBuilder entity = MultipartEntityBuilder.create(); |
| | | // //entity.setMode(HttpMultipartMode.BROWSER_COMPATIBLE); |
| | | // entity.setCharset(Charset.forName("UTF-8")); |
| | | // |
| | | // byte[] fileBytes = Files.readAllBytes(Paths.get(strFile)); |
| | | // if (fileBytes != null) { |
| | | // //内容类型,用于定义网络文件的类型和网页的编码,决定文件接收方将以什么形式、什么编码读取这个文件 |
| | | // ContentType OCTEC_STREAM = ContentType.create("application/octet-stream", Charset.forName("UTF-8")); |
| | | // //添加文件 |
| | | // entity.addBinaryBody("file", fileBytes, OCTEC_STREAM, strTemp); |
| | | // } |
| | | // |
| | | // httpPost.setEntity(entity.build()); |
| | | // //发起请求,并返回请求响应 |
| | | // response = httpClient.execute(httpPost); |
| | | // struploadResult = EntityUtils.toString(response.getEntity(), "utf-8"); |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // e.printStackTrace(); |
| | | // }*/ |
| | | // |
| | | // //String strFRes = HttpClientKit.postMsg(strFUrl,jsonFObj); |
| | | // if (struploadResult == null) return 0; |
| | | // if (struploadResult.isEmpty()) return 0; |
| | | // |
| | | // JSONObject jsonR = JSONObject.parseObject(struploadResult); |
| | | // |
| | | // JSONArray jsonArr = jsonR.getJSONArray("atts"); |
| | | // for (int j = 0; j < jsonArr.size(); j++) { |
| | | // JSONObject jsonRet = jsonArr.getJSONObject(j); |
| | | // String name1 = jsonRet.get("filename").toString(); |
| | | // String id1 = jsonRet.get("fileUrl").toString(); |
| | | // filename += name1; |
| | | // fileid += id1; |
| | | // if (i != urlArray.length - 1) { |
| | | // filename += ","; |
| | | // fileid += ","; |
| | | // } |
| | | // } |
| | | // |
| | | // } |
| | | // |
| | | //// long nId = remShare.getId(); |
| | | //// remShare.setId(nId); |
| | | //// remShare.setFilename(filename); |
| | | //// remShare.setFileid(fileid); |
| | | //// boolean bRet = serviceReimbursementServiceShare.updateById(remShare); |
| | | //// if (!bRet) return -1; |
| | | // |
| | | // return 0; |
| | | // } |
| | | |
| | | /** |
| | | * 差旅费上报 |
| | |
| | | @PostMapping("/travelexpensereport") |
| | | public AjaxResult travelexpensereport(@RequestBody CheckFundVO checkFundVO) { |
| | | ServiceReimbursement serviceReimbursement = serviceReimbursementService.getById(checkFundVO.getFundid()); |
| | | serviceReimbursement.setApplyTime(new Date()); |
| | | //如果等于100,说明已经走到医院财务那边了;财务那边取数据是从分享表取,所以,这里直接往分享表里添加数据就行了; |
| | | if (!Objects.isNull(serviceReimbursement) && serviceReimbursement.getBackflowlevel() != null) { |
| | | if (serviceReimbursement.getBackflowlevel() == 100 || serviceReimbursement.getBackflowlevel() == 199) { |
| | | // if (serviceReimbursement.getBackflowlevel() == 199) { |
| | | //将退回阶段设置成100 |
| | | serviceReimbursement.setBackflowlevel(100L); |
| | | //退回再提交,需要再到出纳那里 |
| | | serviceReimbursement.setFlowlevel(1L); |
| | | serviceReimbursement.setRecordstatus(2); |
| | | serviceReimbursementService.updateById(serviceReimbursement); |
| | | |
| | | //将修改的上报数据 新增一条 |
| | | // serviceReimbursementService.addSharedData(checkFundVO.getFundid()); |
| | | |
| | | return success(); |
| | | } else if (serviceReimbursement.getBackflowlevel() == 2) { |
| | | //聂科退回的,也需要走出纳那里 |
| | | serviceReimbursement.setFlowlevel(1L); |
| | | serviceReimbursement.setRecordstatus(2); |
| | | serviceReimbursementService.updateById(serviceReimbursement); |
| | | return success(); |
| | | } |
| | | } |
| | | if (serviceReimbursement != null) { |
| | | Integer TotalLevel = 0; |
| | | LoginUser loginUser = getLoginUser(); |
| | |
| | | List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId()); |
| | | |
| | | if (!postids.contains(2)) { |
| | | serviceReimbursement.setFlowlevel(1L); |
| | | serviceReimbursement.setRecordstatus(2); |
| | | if (serviceReimbursement.getBackflowlevel() != null) { |
| | | serviceReimbursement.setFlowlevel(serviceReimbursement.getBackflowlevel()); |
| | | } else { |
| | | serviceReimbursement.setBackflowlevel(1L); |
| | | serviceReimbursement.setFlowlevel(1L); |
| | | } |
| | | } else { |
| | | serviceReimbursement.setFlowlevel(0L); |
| | | serviceReimbursement.setRecordstatus(0); |
| | | if (serviceReimbursement.getBackflowlevel() != null) { |
| | | serviceReimbursement.setFlowlevel(serviceReimbursement.getBackflowlevel()); |
| | | } else { |
| | | serviceReimbursement.setFlowlevel(0L); |
| | | serviceReimbursement.setBackflowlevel(0L); |
| | | } |
| | | |
| | | } |
| | | |
| | | if (!postids.contains(2)) { |
| | | if (!postids.contains(2) && (serviceReimbursement.getBackflowlevel() == null || serviceReimbursement.getBackflowlevel() == 0)) { |
| | | ServiceFundflow serviceFundflow = new ServiceFundflow(); |
| | | serviceFundflow.setFundid(serviceReimbursement.getId()); |
| | | serviceFundflow.setCheckuserno(user.getUserName()); |
| | |
| | | @Log(title = "审核费用", businessType = BusinessType.OTHER) |
| | | @PostMapping("/checkfund") |
| | | public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) { |
| | | log.info("审核费用的入参 : {}", checkFundVO); |
| | | ServiceReimbursement serviceReimbursement = serviceReimbursementService.getById(checkFundVO.getFundid()); |
| | | log.info("审核费用的serviceReimbursementService.getById返参 : {}", serviceReimbursement); |
| | | if (serviceReimbursement != null) { |
| | | Integer totalLevel = 0; |
| | | LoginUser loginUser = getLoginUser(); |
| | |
| | | serviceFundflowrule.setApplytype("0"); |
| | | serviceFundflowrule.setCheckuserno(loginUser.getUsername()); |
| | | List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule); |
| | | |
| | | log.info("审核费用的serviceFundflowruleService.queryList返参 : {}", serviceFundflowrules.size()); |
| | | if (serviceFundflowrules == null || serviceFundflowrules.stream().count() == 0) { |
| | | return AjaxResult.error(HttpStatus.ERROR, "当前人员无此记录审核权限"); |
| | | } |
| | |
| | | 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; |
| | |
| | | //99 取消 |
| | | RecordStatus = 99; |
| | | } else { |
| | | |
| | | if (totalLevel == FlowLevel + 1) { |
| | | RecordStatus = 99; |
| | | } else { |
| | | RecordStatus = (FlowLevel + 1) * 2; |
| | | } |
| | | } |
| | | |
| | | if (serviceReimbursement.getFlowlevel() == 1 && serviceReimbursement.getBackflowlevel() == 100) { |
| | | log.info("出差补贴被 财务退回再提交,出纳再次审批,之后提交到财务:{}", serviceReimbursement.getId()); |
| | | //说明是财务退回再提交的.需要出纳再看一遍,没问题之后,往分享表里新增 |
| | | serviceReimbursementService.addSharedData(serviceReimbursement.getId()); |
| | | serviceReimbursement.setFlowlevel(100L); |
| | | serviceReimbursement.setRecordstatus(99); |
| | | boolean b = serviceReimbursementService.updateById(serviceReimbursement); |
| | | log.info("是否修改成功:{}", b); |
| | | |
| | | //保存审批流程表 |
| | | ServiceFundflow serviceFundflow = new ServiceFundflow(); |
| | | SysUser user = loginUser.getUser(); |
| | | serviceFundflow.setFundid(serviceReimbursement.getId()); |
| | | serviceFundflow.setCheckuserno(user.getUserName()); |
| | | serviceFundflow.setCheckusername(user.getNickName()); |
| | | serviceFundflow.setFundtype(1); |
| | | serviceFundflow.setApplytype("0"); |
| | | serviceFundflow.setFlowconclusion(CheckFlag); |
| | | serviceFundflow.setFlowcontent("通过"); |
| | | serviceFundflow.setFlowlevel(OriginalFlowLevel + 1); |
| | | Boolean aBoolean = serviceFundflowService.save(serviceFundflow); |
| | | return AjaxResult.success(); |
| | | } |
| | | |
| | | FlowLevel = FlowLevel + 1; |
| | | serviceReimbursement.setBackflowlevel(Long.valueOf(FlowLevel)); |
| | | } else { |
| | | CheckFlag = 2; |
| | | RecordStatus = (FlowLevel + 1) * 2 - 1; |
| | | FlowLevel = (FlowLevel - 1); |
| | | if (FlowLevel < 0) { |
| | | |
| | | if (CheckFlag == 2) { |
| | | //应医院要求如果出现退回,直接退到发起者 |
| | | FlowLevel = 0; |
| | | RecordStatus = -1; |
| | | } else { |
| | | //下面是原来的写法,一级一级的往下退,医院现在不要这样搞了,下面这段代码先保留,等医院回心转意,再给放开 |
| | | 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()); |
| | |
| | | serviceFundflow.setFundtype(1); |
| | | serviceFundflow.setApplytype("0"); |
| | | serviceFundflow.setFlowconclusion(CheckFlag); |
| | | serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent()); |
| | | if (StringUtils.isNotBlank(checkFundVO.getFlowcontent())) { |
| | | serviceFundflow.setFlowcontent(checkFundVO.getFlowcontent()); |
| | | } else { |
| | | serviceFundflow.setFlowcontent(checkFundVO.getFlowconclusion() == 1 ? "通过" : "不通过"); |
| | | } |
| | | serviceFundflow.setFlowlevel(OriginalFlowLevel + 1); |
| | | serviceFundflowService.save(serviceFundflow); |
| | | |
| | | List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId()); |
| | | |
| | | if (!postids.contains(2)) { |
| | | log.info("postService.selectPostListByUserId : {}", postids.size()); |
| | | if (!postids.contains(2) && !postids.contains(6) && (serviceReimbursement.getBackflowlevel() == null || serviceReimbursement.getBackflowlevel() == 0)) { |
| | | if (CheckFlag == 2 && OriginalFlowLevel == 1) { |
| | | ServiceFundflow serviceFundflowAuto = new ServiceFundflow(); |
| | | serviceFundflowAuto.setFundid(serviceReimbursement.getId()); |
| | |
| | | serviceFundflowAuto.setFlowcontent("非专职人员二级审核拒绝后直接退回到修改状态"); |
| | | serviceFundflowAuto.setFlowlevel(1); |
| | | serviceFundflowService.save(serviceFundflowAuto); |
| | | |
| | | serviceReimbursement.setRecordstatus(1); |
| | | } |
| | | |
| | | } |
| | | //001审批通过之后,就需要把“办公室主任”的名字填上 |
| | | if (checkFundVO.getFlowconclusion() == 1 && user.getUserName().equals("001")) { |
| | | serviceReimbursement.setOfficedirector(user.getNickName()); |
| | | } |
| | | |
| | | serviceReimbursementService.updateById(serviceReimbursement); |
| | |
| | | serviceSystemmessage.setIsread(0); |
| | | serviceSystemmessage.setMessagetype(1); |
| | | serviceSystemmessage.setRelevantno(serviceReimbursement.getId()); |
| | | log.info("CheckFlag的值 : {}", CheckFlag); |
| | | if (CheckFlag == 1) { |
| | | //通过 |
| | | serviceSystemmessage.setMessagetitle("" + (OriginalFlowLevel + 1) + "级审核通过"); |
| | | serviceSystemmessage.setMessagecontent("您" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(serviceReimbursement.getCreateTime()) + "提交的关于捐献案例【" + serviceReimbursement.getDonorname() + "】的差旅费申请已通过" + (OriginalFlowLevel + 1) + "级审核"); |
| | | log.info("totalLevel的值 : {}, OriginalFlowLevel的值:{}", totalLevel, OriginalFlowLevel); |
| | | if (totalLevel == OriginalFlowLevel + 1) { |
| | | //所有数据新增到备份表 |
| | | serviceReimbursementService.addSharedData(checkFundVO.getFundid()); |
| | |
| | | @ApiOperation("修改报销申请") |
| | | //@PreAuthorize("@ss.hasPermi('project:reimbursement:edit')") |
| | | @Log(title = "报销申请", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | @PostMapping("/reimbursementEdit") |
| | | @RepeatSubmit |
| | | public AjaxResult edit(@RequestBody ServiceReimbursement serviceReimbursement) { |
| | | boolean b = serviceReimbursementService.updateById(serviceReimbursement); |
| | |
| | | */ |
| | | @ApiOperation("删除报销申请") |
| | | //@PreAuthorize("@ss.hasPermi('project:reimbursement:remove')") |
| | | @Log(title = "报销申请", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | @Log(title = "报销申请") |
| | | @GetMapping("/remove/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) { |
| | | return toAjax(serviceReimbursementService.removeByIds(Arrays.asList(ids))); |
| | | } |
| | |
| | | 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)); |
| | |
| | | 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"); |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | ServiceReimbursementEo serviceReimbursementEo = new ServiceReimbursementEo(); |
| | | serviceReimbursementEo.setId(id); |
| | | List<ServiceReimbursementEo> rdInfoByItem = serviceReimbursementService.getRDInfoByItem(serviceReimbursementEo); |
| | | log.info("rdInfoByItem是否为空 :{}", CollectionUtils.isEmpty(rdInfoByItem) ? null : rdInfoByItem.size()); |
| | | for (int i = 0; i < rdInfoByItem.size(); i++) { |
| | | ServiceReimbursementEo serviceReimbursementEo1 = rdInfoByItem.get(i); |
| | | String codeByInfo = PersonType.getCodeByInfo(serviceReimbursementEo1.getPersontype()); |
| | | serviceReimbursementEo1.setPersontype(codeByInfo); |
| | | } |
| | | //获取报销支付信息 |
| | | List<ServiceReimbursementpayee> reimbursementpayeeInfo = reimbursementpayeeService.getReimbursementpayeeInfo(serviceReimbursementEo); |
| | | |
| | | log.info("reimbursementpayeeInfo是否为空 :{}", CollectionUtils.isEmpty(reimbursementpayeeInfo) ? null : reimbursementpayeeInfo.size()); |
| | | Map<String, List<ServiceReimbursementEo>> listMap = rdInfoByItem.stream().collect(Collectors.groupingBy(ServiceReimbursementEo::getPersontype)); |
| | | List<Map<String, BigDecimal>> list = new ArrayList<>(); |
| | | StringBuffer FYXM1 = new StringBuffer(); |
| | |
| | | BigDecimal keyOneMoney = new BigDecimal(0.00); |
| | | BigDecimal keyTwoMoney = new BigDecimal(0.00); |
| | | for (ServiceReimbursementEo serviceReimbursementEo1 : values) { |
| | | otherMoney = otherMoney.add(serviceReimbursementEo1.getTrafficexpense()).add(serviceReimbursementEo1.getHotelexpense()).add(serviceReimbursementEo1.getFoodexpenses()).add(serviceReimbursementEo1.getFoodallowance()).add(serviceReimbursementEo1.getOtherexpense()).add(serviceReimbursementEo1.getOtherfeeamount()); |
| | | otherMoney = otherMoney.add(serviceReimbursementEo1.getTrafficexpense()).add(serviceReimbursementEo1.getHotelexpense()).add(serviceReimbursementEo1.getCityfee()).add(serviceReimbursementEo1.getFoodexpenses()).add(serviceReimbursementEo1.getFoodallowance()).add(serviceReimbursementEo1.getOtherexpense()).add(serviceReimbursementEo1.getOtherfeeamount()); |
| | | } |
| | | map.put(key, otherMoney); |
| | | list.add(map); |
| | | // 不为专家或家属 |
| | | if (!key.equals("3") && !key.equals("4")) { |
| | | //将上一次的清空 |
| | | FYXM1.delete(0, FYXM1.length()); |
| | | //再新增 |
| | | otherMoneyall = otherMoneyall.add(otherMoney); |
| | | FYXM1.append("OPO工作人员" + ":" + otherMoneyall + " "); |
| | | } else { |
| | | if (flag == 0) { |
| | | key1 = key; |
| | | flag = 1; |
| | | } |
| | | if (key1 == key) { |
| | | FYXM2.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | // 不为专家或家属,key有可能是数字,有可能是汉字 |
| | | Pattern pattern = Pattern.compile("^[-\\+]?[\\d]*$"); |
| | | boolean matches = pattern.matcher(key).matches(); |
| | | if (matches) { |
| | | if (!key.equals("3") && !key.equals("4")) { |
| | | //将上一次的清空 |
| | | FYXM1.delete(0, FYXM1.length()); |
| | | //再新增 |
| | | otherMoneyall = otherMoneyall.add(otherMoney); |
| | | FYXM1.append("OP0 工作人员报销差旅费" + ":" + otherMoneyall + " "); |
| | | } else { |
| | | FYXM3.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | if (flag == 0) { |
| | | key1 = key; |
| | | flag = 1; |
| | | } |
| | | if (key1 == key) { |
| | | if (key.equals("3")) { |
| | | // FYXM2.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | FYXM2.append("专家报销差旅费 :" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } else { |
| | | FYXM2.append("家属报销差旅费及误工费用 : " + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } |
| | | } else { |
| | | if (key.equals("3")) { |
| | | // FYXM2.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | FYXM3.append("专家报销差旅费 :" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } else { |
| | | FYXM3.append("家属报销差旅费及误工费用 : " + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } |
| | | } |
| | | } |
| | | } else { |
| | | if (!key.equals("专家") && !key.equals("家属")) { |
| | | //将上一次的清空 |
| | | FYXM1.delete(0, FYXM1.length()); |
| | | //再新增 |
| | | otherMoneyall = otherMoneyall.add(otherMoney); |
| | | FYXM1.append("OP0 工作人员报销差旅费" + ":" + otherMoneyall + " "); |
| | | } else { |
| | | if (flag == 0) { |
| | | key1 = key; |
| | | flag = 1; |
| | | } |
| | | if (key1 == key) { |
| | | if (key.equals("专家")) { |
| | | // FYXM2.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | FYXM2.append("专家报销差旅费 :" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } else { |
| | | FYXM2.append("家属报销差旅费及误工费用 : " + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } |
| | | } else { |
| | | if (key.equals("专家")) { |
| | | // FYXM2.append(PersonType.getInfoByCode(key) + ":" + otherMoney); |
| | | FYXM3.append("专家报销差旅费 :" + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } else { |
| | | FYXM3.append("家属报销差旅费及误工费用 : " + otherMoney); |
| | | allMoney = allMoney.add(otherMoney); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | String date = formatter.format(dt); |
| | | String time = date.substring(0, 10); |
| | | |
| | | dataMap.put("ZB", rdInfoByItem.get(0).getDeptmentname() == null ? "" : rdInfoByItem.get(0).getDeptmentname()); |
| | | dataMap.put("XZBH", rdInfoByItem.get(0).getBh() == null ? "" : rdInfoByItem.get(0).getBh()); |
| | | dataMap.put("TBYYMMDD", time); |
| | | dataMap.put("BXDFJ", rdInfoByItem.get(0).getAttachcount() == null ? " " : "" + rdInfoByItem.get(0).getAttachcount()); |
| | | dataMap.put("JXZXM", rdInfoByItem.get(0).getDonorname() == null ? "" : rdInfoByItem.get(0).getDonorname()); |
| | |
| | | } |
| | | dataMap.put("BXBZ", remark); |
| | | |
| | | dataMap.put("ZXFZR", StringUtils.isEmpty(rdInfoByItem.get(0).getOpochecker()) ? "" : rdInfoByItem.get(0).getOpochecker()); |
| | | // |
| | | dataMap.put("CWFYZ", StringUtils.isEmpty(rdInfoByItem.get(0).getFinvicepresident()) ? "" : rdInfoByItem.get(0).getFinvicepresident()); |
| | | dataMap.put("YWFYZ", StringUtils.isEmpty(rdInfoByItem.get(0).getBusvicepresident()) ? "" : rdInfoByItem.get(0).getBusvicepresident()); |
| | | dataMap.put("BGSZR", StringUtils.isEmpty(rdInfoByItem.get(0).getOfficedirector()) ? "" : rdInfoByItem.get(0).getOfficedirector()); |
| | | dataMap.put("CWBZR", StringUtils.isEmpty(rdInfoByItem.get(0).getFinancedirector()) ? "" : rdInfoByItem.get(0).getFinancedirector()); |
| | | dataMap.put("CWSH", StringUtils.isEmpty(rdInfoByItem.get(0).getFinancechecher()) ? "" : rdInfoByItem.get(0).getFinancechecher()); |
| | | |
| | | |
| | | dataMap.put("YYMMDD", time); |
| | | |