| | |
| | | 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; |
| | | import com.ruoyi.common.core.controller.BaseController; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.domain.entity.SysDept; |
| | | import com.ruoyi.common.core.domain.entity.SysUser; |
| | | import com.ruoyi.common.core.domain.model.LoginUser; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | 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.project.domain.vo.*; |
| | | import com.ruoyi.project.mapper.ServiceFunddetailMapper; |
| | | import com.ruoyi.project.service.*; |
| | | import com.ruoyi.system.service.ISysDeptService; |
| | | import com.ruoyi.system.service.ISysPostService; |
| | | import com.ruoyi.system.service.ISysUserService; |
| | | import freemarker.template.Configuration; |
| | | import freemarker.template.Template; |
| | | import freemarker.template.TemplateException; |
| | |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDate; |
| | | import java.util.*; |
| | | import java.util.concurrent.ConcurrentHashMap; |
| | | import java.util.stream.Collectors; |
| | | |
| | | import static com.ruoyi.web.controller.project.ServiceReimbursementController.convert; |
| | |
| | | |
| | | @Autowired |
| | | private TransactionDefinition transactionDefinition; |
| | | |
| | | @Autowired |
| | | private DingTalkService dingTalkService; |
| | | |
| | | @Autowired |
| | | private ISysUserService sysUserService; |
| | | |
| | | public ServiceFundController() { |
| | | configuration = new Configuration(); |
| | |
| | | @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) { |
| | |
| | | * 审核费用 |
| | | */ |
| | | @ApiOperation("审核费用") |
| | | @RepeatSubmit |
| | | // @Log(title = "审核费用", businessType = BusinessType.OTHER) |
| | | @PostMapping("/checkfund") |
| | | public AjaxResult checkFund(@RequestBody CheckFundVO checkFundVO) { |
| | |
| | | serviceFundflowrule.setApplytype(serviceFund.getApplytype()); |
| | | serviceFundflowrule.setCheckuserno(loginUser.getUsername()); |
| | | log.info("serviceFundController---checkFund---queryList的入参值serviceFundflowrule:{}", serviceFundflowrule); |
| | | |
| | | List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule); |
| | | |
| | | if (serviceFundflowrules == null || serviceFundflowrules.stream().count() == 0) { |
| | |
| | | } |
| | | FlowLevel = FlowLevel + 1; |
| | | |
| | | if (serviceFund.getFlowlevel() == 1 && serviceFund.getBackflowlevel() == 100) { |
| | | if (serviceFund.getFlowlevel() == Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1) && serviceFund.getBackflowlevel() == 100) { |
| | | log.info("财务退回再提交,出纳再次审批,之后提交到财务"); |
| | | //说明是财务退回再提交的.需要出纳再看一遍,没问题之后,往分享表里新增 |
| | | serviceFundService.addFundSharedInfo(serviceFund.getId()); |
| | | serviceFund.setFlowlevel(100L); |
| | | // serviceFundService.addFundSharedInfo(serviceFund.getId()); |
| | | serviceFund.setFlowlevel(serviceFundflowrules.get(0).getTotallevel().longValue()); |
| | | serviceFund.setRecordstatus(99); |
| | | serviceFund.setUploadStates(1); |
| | | serviceFundService.updateById(serviceFund); |
| | | |
| | | //保存审批流程表 |
| | |
| | | FlowLevel = 0; |
| | | } |
| | | } |
| | | |
| | | SysUser sysUser = sysUserService.selectUserByUserName(serviceFund.getUserno()); |
| | | ArrayList<ConcurrentHashMap<String, Object>> contentList = new ArrayList<>(); |
| | | ConcurrentHashMap map = new ConcurrentHashMap(); |
| | | map.put("审批人:", loginUser.getUser().getUserName()); |
| | | map.put("审批时间:", new Date()); |
| | | map.put("意见:", "不通过"); |
| | | if (StringUtils.isNotBlank(checkFundVO.getFlowcontent())) map.put("意见:", checkFundVO.getFlowcontent()); |
| | | contentList.add(map); |
| | | DingTalkReqVo dingTalkReqVo = new DingTalkReqVo(); |
| | | dingTalkReqVo.setTitle("财务系统驳回信息"); |
| | | dingTalkReqVo.setNumber(sysUser.getPhonenumber()); |
| | | dingTalkReqVo.setContents(contentList); |
| | | dingTalkService.sendNotification(dingTalkReqVo); |
| | | } |
| | | |
| | | serviceFund.setRecordstatus(RecordStatus); |
| | |
| | | //001审批通过之后,就需要把“办公室主任”的名字填上 |
| | | if (checkFundVO.getFlowconclusion() == 1 && user.getUserName().equals("001")) { |
| | | serviceFund.setOfficedirector(user.getNickName()); |
| | | serviceFund.setUploadStates(2); |
| | | } |
| | | System.out.println("serviceFund的值是--------:" + serviceFund); |
| | | log.info("开始更新的的值是--------"); |
| | | ServiceFund updateServiceFund = new ServiceFund(); |
| | | updateServiceFund.setRecordstatus(serviceFund.getRecordstatus()); |
| | | updateServiceFund.setFlowlevel(serviceFund.getFlowlevel()); |
| | | // ServiceFund updateServiceFund = new ServiceFund(); |
| | | // updateServiceFund.setRecordstatus(serviceFund.getRecordstatus()); |
| | | // updateServiceFund.setFlowlevel(serviceFund.getFlowlevel()); |
| | | |
| | | Boolean aBoolean1 = serviceFundService.updateById(serviceFund); |
| | | log.info("integer更新的的值是-------- :{}", aBoolean1); |
| | |
| | | //通过 |
| | | 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) { |
| | | serviceFundService.addFundSharedInfo(checkFundVO.getFundid()); |
| | | } |
| | | // if (TotalLevel == OriginalFlowLevel + 1) { |
| | | // serviceFundService.addFundSharedInfo(checkFundVO.getFundid()); |
| | | // } |
| | | |
| | | } else { |
| | | //驳回 |
| | |
| | | @Log(title = "费用上报", businessType = BusinessType.UPDATE) |
| | | @PostMapping("/fundEdit") |
| | | @RepeatSubmit |
| | | public AjaxResult fundEdit(@RequestBody ServiceFund serviceFund) { |
| | | public AjaxResult fundEdit(@RequestBody ServiceFundVO serviceFundVO) { |
| | | ServiceFund serviceFund = DtoConversionUtils.sourceToTarget(serviceFundVO, ServiceFund.class); |
| | | log.info("修改费用申请入参:{}", serviceFund); |
| | | List<ServiceFund> infoByInfoIdList = serviceFundService.queryInfoById(serviceFund); |
| | | log.info("修改费用申请,通过入参查询 serviceFundService.queryInfoById数据为空,入参:{}", infoByInfoIdList.size()); |
| | | if (CollectionUtils.isEmpty(infoByInfoIdList)) { |
| | | return toAjax(false); |
| | | Long id = serviceFundService.addOrUpdateNew(serviceFundVO); |
| | | serviceFund.setId(id); |
| | | } |
| | | |
| | | Long flowLavel = null; |
| | | |
| | | LoginUser loginUser = getLoginUser(); |
| | | |
| | | //查询必审人 |
| | | ServiceFundflowrule serviceFundflowrule = new ServiceFundflowrule(); |
| | | serviceFundflowrule.setApplytype(serviceFund.getApplytype()); |
| | | serviceFundflowrule.setMustAudite(1); |
| | | List<ServiceFundflowrule> serviceFundflowrules = serviceFundflowruleService.queryList(serviceFundflowrule); |
| | | log.info("fund必审人的等级为:{}", serviceFundflowrules.get(0).getFlowlevel()); |
| | | |
| | | for (ServiceFund sf : infoByInfoIdList) { |
| | | sf.setApplyTime(new Date()); |
| | | //如果等于100,说明已经走到医院财务那边了;财务那边取数据是从分享表取,所以,这里直接往分享表里添加数据就行了 |
| | | if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 199) { |
| | | //将fund表的审核状态改成100 |
| | | sf.setBackflowlevel(100); |
| | | |
| | | //退回再提交,需要再到出纳那里 |
| | | sf.setFlowlevel(1L); |
| | | sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1)); |
| | | sf.setRecordstatus(0); |
| | | serviceFundService.updateById(sf); |
| | | |
| | |
| | | } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 100) { |
| | | //财务退回的数据再提交,到出纳那里没有过,再退回,导致backflowlevel是100, |
| | | //退回再提交,需要再到出纳那里 |
| | | sf.setFlowlevel(1L); |
| | | sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1)); |
| | | sf.setRecordstatus(2); |
| | | serviceFundService.updateById(sf); |
| | | } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() == 2) { |
| | | } else if (sf.getBackflowlevel() != null && sf.getBackflowlevel() >= serviceFundflowrules.get(0).getFlowlevel()) { |
| | | //聂科退回的,也需要先到出纳那里 |
| | | sf.setFlowlevel(1L); |
| | | sf.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1)); |
| | | sf.setRecordstatus(2); |
| | | serviceFundService.updateById(sf); |
| | | } else { |
| | | |
| | | Integer TotalLevel = 0; |
| | | LoginUser loginUser = getLoginUser(); |
| | | SysUser user = loginUser.getUser(); |
| | | List<Integer> postids = postService.selectPostListByUserId(loginUser.getUserId()); |
| | | if (!postids.contains(2)) { |
| | | serviceFund.setRecordstatus(2); |
| | | if (serviceFund.getBackflowlevel() != null) { |
| | | serviceFund.setFlowlevel(serviceFund.getBackflowlevel().longValue()); |
| | | } else { |
| | | serviceFund.setBackflowlevel(1); |
| | | serviceFund.setFlowlevel(1L); |
| | | serviceFund.setBackflowlevel(serviceFundflowrules.get(0).getFlowlevel() - 1); |
| | | serviceFund.setFlowlevel(Long.valueOf(serviceFundflowrules.get(0).getFlowlevel() - 1)); |
| | | } |
| | | } else { |
| | | serviceFund.setRecordstatus(0); |
| | |
| | | |
| | | return toAjax(false); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 删除费用申请主 |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | } |
| | | 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); |
| | | } |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | | 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); |
| | | } |
| | |
| | | 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); |
| | |
| | | dataMap.put("YWZ", serviceFund.getDeptmentname() == null ? "" : serviceFund.getDeptmentname()); |
| | | dataMap.put("ZHUZANG", serviceFund.getManagername() == null ? "" : serviceFund.getManagername()); |
| | | |
| | | dataMap.put("FYMC", LocalDate.now().getYear() + "年" + LocalDate.now().getMonthValue() + "月人体器官获取服务管理中心工作人员绩效"); |
| | | |
| | | 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")) { |
| | |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | map.put("seqno", 1); |
| | | String fyxm = ""; |
| | | fyxm += LocalDate.now().getYear() + "年" + LocalDate.now().getMonthValue() + "月人体器官获取服务管理中心工作人员绩效,共计"; |
| | | 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<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("downloadUrl", "/profile/download/wordtemplate/" + name + ".doc"); |
| | | map.put("downloadName", name + ".doc"); |
| | | return map; |
| | | } |
| | | |
| | |
| | | /** |
| | | * 费用类型计数 |
| | | */ |
| | | // @NotRepeatCommit(key = "param:arg[1]", value = 30000) |
| | | @ApiOperation("费用类型计数") |
| | | @GetMapping(value = "/countItem/{infoid}/{itemid}") |
| | | public AjaxResult countItem(@PathVariable Long infoid, @PathVariable Long itemid) { |
| | |
| | | /** |
| | | * 合计个税 |
| | | */ |
| | | @NotRepeatCommit(key = "param:arg[1]", value = 30000) |
| | | @ApiOperation("合计个税") |
| | | @Log(title = "合计个税", businessType = BusinessType.INSERT) |
| | | @PostMapping("/totaltax") |
| | | @RepeatSubmit |
| | | public AjaxResult totaltax(@RequestBody TotalTaxVO totalTaxVO) { |
| | | Boolean totaltax = serviceFundService.totaltax(totalTaxVO); |
| | | if(totaltax){ |
| | | return AjaxResult.success("合计个税成功,请去E:\\OPO\\WEB\\Upload\\download 中查找文件"); |
| | | Map<String, List<ServiceFunddetailExcel>> totaltax = serviceFundService.totaltax(totalTaxVO); |
| | | if (ObjectUtils.isEmpty(totaltax)) { |
| | | throw new BaseException("合计个税失败"); |
| | | } |
| | | |
| | | return AjaxResult.success("合计失败,请稍后重试"); |
| | | 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); |
| | | |
| | | |
| | | } |
| | | |
| | | } |