| | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.concurrent.locks.Lock; |
| | | import java.util.concurrent.locks.LockSupport; |
| | | |
| | | import com.alibaba.fastjson.JSON; |
| | | import com.alibaba.fastjson.JSONArray; |
| | |
| | | import com.ruoyi.project.service.IServiceFunddetailService; |
| | | import com.ruoyi.project.service.IServiceFunddetailSharedService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.apache.commons.lang3.ObjectUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Component; |
| | | import org.springframework.stereotype.Service; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | |
| | | if (serviceFund.getUploadtime() != null) { |
| | | wrappers.eq(ServiceFund::getUploadtime, serviceFund.getUploadtime()); |
| | | } |
| | | if (serviceFund.getFlowlevel() != null) { |
| | | wrappers.eq(ServiceFund::getFlowlevel, serviceFund.getFlowlevel()); |
| | | } |
| | | return this.list(wrappers); |
| | | } |
| | | |
| | |
| | | ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class); |
| | | serviceFundShared.setSerfunid(serviceFundShared.getId()); |
| | | serviceFundShared.setId(null); |
| | | log.info("数据都插进去了吗? {}", serviceFundShared); |
| | | sharedService.save(serviceFundShared); |
| | | |
| | | //fundId为主表的ID |
| | |
| | | //数据发送给财务 |
| | | uploadOAFileAndUpdateDb(serviceFunddetailShareds.get(i)); |
| | | } |
| | | boolean result = detailSharedService.saveBatch(serviceFunddetailShareds); |
| | | boolean result = false; |
| | | for (ServiceFunddetailShared serviceFunddetailShared : serviceFunddetailShareds) { |
| | | if (ObjectUtils.isNotEmpty(serviceFunddetailShared)) { |
| | | result = detailSharedService.save(serviceFunddetailShared); |
| | | } else { |
| | | log.info("serviceFunddetailShared为空了!!!"); |
| | | } |
| | | } |
| | | return result; |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<SpFinancialExpensesFundOut> getListBypower(String PAUSERNO, Integer PAFUNDTYPE, String PAAPPLICANT, String PAAPPLICATIONBEGTIME, String PAAPPLICATIONENDTIME, String PADEPARTMENT, Integer CHECKFLAG, Integer APPLYTYPE) { |
| | | return serviceFundMapper.getListBypower(PAUSERNO, PAFUNDTYPE, PAAPPLICANT, PAAPPLICATIONBEGTIME, PAAPPLICATIONENDTIME, PADEPARTMENT, CHECKFLAG, APPLYTYPE); |
| | | public List<SpFinancialExpensesFundOut> getListBypower(String PAUSERNO, Integer PAFUNDTYPE, String PAAPPLICANT, String PAAPPLICATIONBEGTIME, String PAAPPLICATIONENDTIME, String PADEPARTMENT, Integer CHECKFLAG, Integer APPLYTYPE, Integer CHECKSTATUS, String donorname) { |
| | | return serviceFundMapper.getListBypower(PAUSERNO, PAFUNDTYPE, PAAPPLICANT, PAAPPLICATIONBEGTIME, PAAPPLICATIONENDTIME, PADEPARTMENT, CHECKFLAG, APPLYTYPE, CHECKSTATUS, donorname); |
| | | } |
| | | |
| | | @Override |
| | |
| | | @Transactional |
| | | public Long addOrUpdateNew(ServiceFundVO serviceFundVO) { |
| | | Long id = null; |
| | | if (serviceFundVO.getId() == null) { |
| | | save(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } else { |
| | | updateById(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } |
| | | //将数据保存到fund表 |
| | | id = saveFund(serviceFundVO); |
| | | |
| | | List<ServiceFunddetailVO> serviceFunddetails = serviceFundVO.getServiceFunddetails(); |
| | | if (CollectionUtils.isEmpty(serviceFunddetails)) { |
| | | System.out.println("serviceFunddetails为空喽"); |
| | | return null; |
| | | } |
| | | // 用于记录税前、税后的总和 |
| | | double taxBefore = 0.0; |
| | | double taxAfter = 0.0; |
| | | |
| | | // 保存详情数据 |
| | | for (ServiceFunddetailVO serviceFunddetailVO : serviceFunddetails) { |
| | | serviceFunddetailVO.setFundid(id); |
| | | //將附件转成json |
| | | if (!CollectionUtils.isEmpty(serviceFunddetailVO.getAnnexfilesList())) { |
| | | serviceFunddetailVO.setAnnexfiles(JSON.toJSONString(serviceFunddetailVO.getAnnexfilesList())); |
| | | } |
| | | if (serviceFunddetailVO.getTaxedamount() != null && serviceFunddetailVO.getAmount() != null && serviceFunddetailVO.getTaxedamount() != 0.0 && serviceFunddetailVO.getAmount() != 0.0) { |
| | | // 税前税后都不为空 |
| | | ServiceFunddetail serviceFunddetail = DtoConversionUtils.sourceToTarget(serviceFunddetailVO, ServiceFunddetail.class); |
| | | if (serviceFunddetailVO.getId() == null) { |
| | | serviceFunddetailService.save(serviceFunddetail); |
| | | } else { |
| | | serviceFunddetailService.updateById(serviceFunddetail); |
| | | } |
| | | //计算税金 |
| | | if (serviceFunddetail.getAmount() != null) { |
| | | taxBefore = taxBefore + serviceFunddetail.getAmount(); |
| | | } |
| | | if (serviceFunddetail.getTaxedamount() != null) { |
| | | taxAfter = taxAfter + serviceFunddetail.getTaxedamount(); |
| | | } |
| | | continue; |
| | | } else if (serviceFunddetailVO.getTaxedamount() != null && serviceFunddetailVO.getTaxedamount() != 0.0) { |
| | | // 税后求税前,如果是专家费申请 或 伦理专家费申请 才会计算税前税后 |
| | | if (StringUtils.isNotEmpty(serviceFundVO.getApplytype()) && serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) { |
| | | Double taxationBefore = Double.valueOf(TaxtUtils.getTaxationBefore(BigDecimal.valueOf(serviceFunddetailVO.getTaxedamount()))); |
| | | // 税金 |
| | | String taxation = TaxtUtils.getTaxation(BigDecimal.valueOf(taxationBefore)); |
| | | serviceFunddetailVO.setAmount(Double.valueOf(taxationBefore)); |
| | | serviceFunddetailVO.setTaxamount(Double.parseDouble(taxation)); |
| | | } |
| | | } else if (serviceFunddetailVO.getAmount() != null && serviceFunddetailVO.getAmount() != 0.0) { |
| | | // 税前求税后,如果是专家费申请 或 伦理专家费申请 才会计算税前税后 |
| | | if (StringUtils.isNotEmpty(serviceFundVO.getApplytype()) && serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) { |
| | | double tax = Double.parseDouble(TaxtUtils.getTaxation(BigDecimal.valueOf(serviceFunddetailVO.getAmount()))); |
| | | BigDecimal taxAfterMoney = BigDecimal.valueOf(serviceFunddetailVO.getAmount()).subtract(BigDecimal.valueOf(tax)); |
| | | serviceFunddetailVO.setTaxamount(tax); |
| | | serviceFunddetailVO.setTaxedamount(taxAfterMoney.doubleValue()); |
| | | } |
| | | if (!CollectionUtils.isEmpty(serviceFunddetailVO.getInvoicefilesList())) { |
| | | serviceFunddetailVO.setInvoicefiles(JSON.toJSONString(serviceFunddetailVO.getInvoicefilesList())); |
| | | } |
| | | |
| | | //根据id判断是新增还是修改 |
| | | ServiceFunddetail serviceFunddetail = DtoConversionUtils.sourceToTarget(serviceFunddetailVO, ServiceFunddetail.class); |
| | | |
| | | if (serviceFunddetailVO.getId() == null) { |
| | | serviceFunddetailService.save(serviceFunddetail); |
| | | } else { |
| | | serviceFunddetailService.updateById(serviceFunddetail); |
| | | } |
| | | // if (serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) { |
| | | //如果是专家费申请 或 伦理专家费申请 才会计算税前税后 |
| | | if (serviceFunddetail.getAmount() != null) { |
| | | taxBefore = taxBefore + serviceFunddetail.getAmount(); |
| | | } |
| | | if (serviceFunddetail.getTaxedamount() != null) { |
| | | taxAfter = taxAfter + serviceFunddetail.getTaxedamount(); |
| | | } |
| | | } |
| | | //将税前、税后金额更新到fund表中 |
| | | serviceFundVO.setPretaxcost(taxBefore); |
| | | serviceFundVO.setTaxedcost(taxAfter); |
| | | updateById(serviceFundVO); |
| | | |
| | | return id; |
| | | } |
| | | |
| | | @Override |
| | | public Map<String, Long> performance(ServiceFundVO serviceFundVO) { |
| | | Long id = null; |
| | | //将数据保存到fund表 |
| | | id = saveFund(serviceFundVO); |
| | | |
| | | List<ServiceFunddetailVO> serviceFunddetails = serviceFundVO.getServiceFunddetails(); |
| | | if (CollectionUtils.isEmpty(serviceFunddetails)) { |
| | | System.out.println("serviceFunddetails为空喽"); |
| | | return null; |
| | | } |
| | | |
| | | //总税前 |
| | | Double pretaxcosts = 0.00; |
| | | //总税后 |
| | | Double taxedcosts = 0.00; |
| | | for (ServiceFunddetailVO serviceFunddetailVO : serviceFunddetails) { |
| | | serviceFunddetailVO.setFundid(id); |
| | | |
| | | ServiceFunddetail serviceFunddetail = DtoConversionUtils.sourceToTarget(serviceFunddetailVO, ServiceFunddetail.class); |
| | | Map<String, Double> performance = serviceFunddetailService.performance(serviceFunddetail); |
| | | if (!performance.isEmpty()) { |
| | | Double amount = performance.get("amount"); |
| | | Double taxedamount = performance.get("taxedamount"); |
| | | pretaxcosts = pretaxcosts + amount; |
| | | taxedcosts = taxedcosts + taxedamount; |
| | | } |
| | | serviceFundVO.setPretaxcost(pretaxcosts); |
| | | serviceFundVO.setTaxedcost(taxedcosts); |
| | | updateById(serviceFundVO); |
| | | } |
| | | Map map = new HashMap(); |
| | | map.put("fundId", id); |
| | | return map; |
| | | } |
| | | |
| | | |
| | | int uploadOAFileAndUpdateDb(ServiceFunddetailShared remShare) { |
| | | //上传OA文件 |
| | |
| | | String filePath = RuoYiConfig.getUploadPath(); |
| | | String strFUrl = "http://129.88.242.39:8899/seeyon/rest/attachment?token=" + strRes; |
| | | List<RbDetailFile> parseArray2 = new ArrayList<>(); |
| | | List<RbDetailFile> invoicefilesList = new ArrayList<>(); |
| | | |
| | | //普通附件 |
| | | List<RbDetailFile> parseArray = JSON.parseArray(remShare.getAnnexfiles(), RbDetailFile.class); |
| | | log.info("parseArray的值 : {}",parseArray); |
| | | for (int i = 0; i < parseArray.size(); i++) { |
| | | RbDetailFile rbDetailFile = parseArray.get(i); |
| | | log.info("filePath的修改:{}", filePath); |
| | | String url = rbDetailFile.getUrl(); |
| | | //file用的是绝对位置 |
| | | String substring = url.substring(url.indexOf("/profile/upload") + "/profile/upload".length()); |
| | | // String strFile = rbDetailFile.getUrl().replace(filePath, "/profile/upload"); |
| | | System.out.println("fund服务的filePath + substring: " + filePath + substring); |
| | | File filetest = new File(filePath + substring); |
| | | //发票附件 |
| | | List<RbDetailFile> invoicefilesArray = JSON.parseArray(remShare.getInvoicefiles(), RbDetailFile.class); |
| | | log.info("parseArray的值 : {}, invoicefilesArray的值 : {},", parseArray, invoicefilesArray); |
| | | |
| | | try { |
| | | String struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); |
| | | log.info("第三方传回的数据: {}", struploadResult); |
| | | if (StringUtils.isEmpty(struploadResult)) { |
| | | log.info("HttpClientKit.sendPostWithFile 请求为空了 filetest:{}, strFUrl:{} ", filetest, strFUrl); |
| | | return 0; |
| | | } |
| | | //获取fileid |
| | | JSONObject jsonR = JSONObject.parseObject(struploadResult); |
| | | JSONArray jsonArr = jsonR.getJSONArray("atts"); |
| | | log.info("第三方传回的数据获取的atts : {}", jsonArr); |
| | | for (int j = 0; j < jsonArr.size(); j++) { |
| | | JSONObject jsonRet = jsonArr.getJSONObject(j); |
| | | rbDetailFile.setFileid(jsonRet.get("fileUrl").toString()); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | parseArray2.add(rbDetailFile); |
| | | } |
| | | remShare.setAnnexfiles(JSON.toJSONString(parseArray2)); |
| | | log.info("ServiceReimbursementdetailShared 是否加上了fileid : {}", remShare); |
| | | //普通附件 |
| | | uploadFile(filePath, strFUrl, parseArray2, parseArray, remShare, "1"); |
| | | |
| | | //发票附件 |
| | | uploadFile(filePath, strFUrl, invoicefilesList, invoicefilesArray, remShare, "2"); |
| | | return 0; |
| | | } |
| | | |
| | | |
| | | private Integer uploadFile(String filePath, String strFUrl, List<RbDetailFile> parseArray2, List<RbDetailFile> parseArray, ServiceFunddetailShared remShare, String flag) { |
| | | if (!CollectionUtils.isEmpty(parseArray)) { |
| | | for (int i = 0; i < parseArray.size(); i++) { |
| | | RbDetailFile rbDetailFile = parseArray.get(i); |
| | | log.info("filePath的修改:{}", filePath); |
| | | String url = rbDetailFile.getUrl(); |
| | | //file用的是绝对位置 |
| | | String substring = url.substring(url.indexOf("/profile/upload") + "/profile/upload".length()); |
| | | // String strFile = rbDetailFile.getUrl().replace(filePath, "/profile/upload"); |
| | | System.out.println("fund服务的filePath + substring: " + filePath + substring); |
| | | File filetest = new File(filePath + substring); |
| | | |
| | | try { |
| | | String struploadResult = HttpClientKit.sendPostWithFile(filetest, strFUrl); |
| | | log.info("第三方传回的数据: {}", struploadResult); |
| | | if (StringUtils.isEmpty(struploadResult)) { |
| | | log.error("HttpClientKit.sendPostWithFile 请求为空了 filetest:{}, strFUrl:{} ", filetest, strFUrl); |
| | | return 0; |
| | | } |
| | | //获取fileid |
| | | JSONObject jsonR = JSONObject.parseObject(struploadResult); |
| | | JSONArray jsonArr = jsonR.getJSONArray("atts"); |
| | | log.info("第三方传回的数据获取的atts : {}", jsonArr); |
| | | for (int j = 0; j < jsonArr.size(); j++) { |
| | | JSONObject jsonRet = jsonArr.getJSONObject(j); |
| | | rbDetailFile.setFileid(jsonRet.get("fileUrl").toString()); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | parseArray2.add(rbDetailFile); |
| | | } |
| | | if (flag.equals("1")) { |
| | | //如果flag为1,则是普通 |
| | | remShare.setAnnexfiles(JSON.toJSONString(parseArray2)); |
| | | } else if (flag.equals("2")) { |
| | | //如果flag为2,则是发票 |
| | | remShare.setInvoicefiles(JSON.toJSONString(parseArray2)); |
| | | } |
| | | log.info("ServiceReimbursementdetailShared 是否加上了fileid : {}", remShare); |
| | | } |
| | | return 0; |
| | | } |
| | | |
| | | // int uploadOAFileAndUpdateDb(ServiceFundShared remShare) { |
| | | // //上传OA文件 |
| | |
| | | // return 0; |
| | | // } |
| | | |
| | | public long saveFund(ServiceFundVO serviceFundVO) { |
| | | Long id = null; |
| | | //将数据保存到fund表 |
| | | if (ObjectUtils.isNotEmpty(serviceFundVO) && serviceFundVO.getId() == null) { |
| | | serviceFundVO.setCheckstatus(serviceFundVO.getCheckstatus() == null ? 1 : 2); |
| | | save(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } else { |
| | | updateById(serviceFundVO); |
| | | id = serviceFundVO.getId(); |
| | | } |
| | | return id; |
| | | } |
| | | |
| | | } |