package com.ruoyi.project.service.impl;
|
|
import java.io.File;
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.ruoyi.common.config.RuoYiConfig;
|
import com.ruoyi.common.tax.TaxtUtils;
|
import com.ruoyi.common.utils.HttpClientKit;
|
import com.ruoyi.common.utils.bean.DtoConversionUtils;
|
import com.ruoyi.project.domain.*;
|
import com.ruoyi.project.domain.vo.*;
|
import com.ruoyi.project.mapper.*;
|
import com.ruoyi.project.service.IServiceFundSharedService;
|
import com.ruoyi.project.service.IServiceFunddetailService;
|
import com.ruoyi.project.service.IServiceFunddetailSharedService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.project.service.IServiceFundService;
|
import org.springframework.transaction.annotation.Transactional;
|
|
/**
|
* 费用申请主Service业务层处理
|
*
|
* @author ruoyi
|
* @date 2022-01-24
|
*/
|
@Slf4j
|
@Service
|
public class ServiceFundServiceImpl extends ServiceImpl<ServiceFundMapper, ServiceFund> implements IServiceFundService {
|
@Autowired
|
ServiceFundMapper serviceFundMapper;
|
|
@Autowired
|
ServiceFunddetailMapper serviceFunddetailMapper;
|
|
@Autowired
|
BaseExpertfeetypeMapper baseExpertfeetypeMapper;
|
|
@Autowired
|
ServiceReimbursementMapper serviceReimbursementMapper;
|
|
@Autowired
|
IServiceFundSharedService sharedService;
|
|
@Autowired
|
ServiceFundSharedMapper serviceFundSharedMapper;
|
|
@Autowired
|
ServiceFunddetailSharedMapper sharedMapper;
|
|
@Autowired
|
IServiceFunddetailSharedService detailSharedService;
|
|
@Autowired
|
private IServiceFunddetailService serviceFunddetailService;
|
|
|
/**
|
* 查询费用申请主列表(包含删除的)
|
*
|
* @param serviceFund 费用申请主
|
* @return 费用申请主
|
*/
|
@Override
|
public List<ServiceFund> queryList(ServiceFund serviceFund) {
|
LambdaQueryWrapper<ServiceFund> wrappers = Wrappers.lambdaQuery();
|
if (StringUtils.isNotBlank(serviceFund.getDonorno())) {
|
wrappers.eq(ServiceFund::getDonorno, serviceFund.getDonorno());
|
}
|
if (serviceFund.getId() != null) {
|
wrappers.eq(ServiceFund::getId, serviceFund.getId());
|
}
|
if (StringUtils.isNotBlank(serviceFund.getUserno())) {
|
wrappers.eq(ServiceFund::getUserno, serviceFund.getUserno());
|
}
|
if (StringUtils.isNotBlank(serviceFund.getUsername())) {
|
wrappers.like(ServiceFund::getUsername, serviceFund.getUsername());
|
}
|
if (StringUtils.isNotBlank(serviceFund.getApplytype())) {
|
wrappers.eq(ServiceFund::getApplytype, serviceFund.getApplytype());
|
}
|
if (StringUtils.isNotBlank(serviceFund.getDeptmentname())) {
|
wrappers.like(ServiceFund::getDeptmentname, serviceFund.getDeptmentname());
|
}
|
if (serviceFund.getRecordstatus() != null) {
|
wrappers.eq(ServiceFund::getRecordstatus, serviceFund.getRecordstatus());
|
}
|
if (StringUtils.isNotBlank(serviceFund.getUploadflag())) {
|
wrappers.eq(ServiceFund::getUploadflag, serviceFund.getUploadflag());
|
}
|
if (serviceFund.getUploadtime() != null) {
|
wrappers.eq(ServiceFund::getUploadtime, serviceFund.getUploadtime());
|
}
|
return this.list(wrappers);
|
}
|
|
|
@Override
|
public List<ServiceFund> queryInfoById(ServiceFund serviceFund) {
|
LambdaQueryWrapper<ServiceFund> wrappers = Wrappers.lambdaQuery();
|
if (serviceFund.getId() != null) {
|
wrappers.eq(ServiceFund::getId, serviceFund.getId());
|
}
|
|
wrappers.eq(ServiceFund::getDel_flag, "0");
|
return this.list(wrappers);
|
}
|
|
@Override
|
public List<ServiceFund> getInfoByInfoId(Long infoid) {
|
return serviceFundMapper.getInfoByInfoId(infoid);
|
}
|
|
|
@Override
|
public Long getFundId(Long infoid) {
|
return serviceFundMapper.getFundId(infoid);
|
}
|
|
@Override
|
@Transactional
|
public Boolean addFundSharedInfo(Long id) {
|
ServiceFund serviceFund = serviceFundMapper.selectById(id);
|
ServiceFundShared serviceFundShared = DtoConversionUtils.sourceToTarget(serviceFund, ServiceFundShared.class);
|
serviceFundShared.setSerfunid(serviceFundShared.getId());
|
serviceFundShared.setId(null);
|
sharedService.save(serviceFundShared);
|
//数据发送给财务
|
uploadOAFileAndUpdateDb(serviceFundShared);
|
//fundId为主表的ID
|
Map<String, Object> columnMap = new HashMap<>();
|
columnMap.put("fundid", id);
|
List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.selectByMap(columnMap);
|
//将查出的数据放到ServiceFunddetailShared中
|
List<ServiceFunddetailShared> serviceFunddetailShareds = DtoConversionUtils.sourceToTarget(serviceFunddetails, ServiceFunddetailShared.class);
|
for (int i = 0; i < serviceFunddetails.size(); i++) {
|
serviceFunddetailShareds.get(i).setFdid(serviceFunddetailShareds.get(i).getId());
|
//fundID为service_fund_shared表的主键ID
|
serviceFunddetailShareds.get(i).setFundid(serviceFundShared.getId());
|
serviceFunddetailShareds.get(i).setId(null);
|
}
|
boolean result = detailSharedService.saveBatch(serviceFunddetailShareds);
|
return result;
|
}
|
|
@Override
|
public List<ServiceFund> selectServiceFundList(ServiceFund serviceFund) {
|
return serviceFundMapper.selectServiceFundList(serviceFund);
|
}
|
|
@Override
|
public List<ServiceFunddetail> getFundDetail(Long id) {
|
return serviceFunddetailMapper.selectFundDetailListById(id);
|
}
|
|
@Override
|
public List<FundVO> selectVOList(FundVO fundVO) {
|
return serviceFundMapper.selectVOList(fundVO);
|
}
|
|
@Override
|
public List<FundDetailOneVO> showFundDetailOne(ServiceFund serviceFund) {
|
List<FundDetailOneVO> l = new ArrayList<>();
|
FundDetailOneVO f1 = new FundDetailOneVO();
|
f1.setNumber("1");
|
f1.setMessage("获取专家总费用: " + serviceFund.getProcurementcost() + "元; " + "专家费用总金额: " + serviceFund.getExpertcost() + "元; " + "伦理审查费用总金额: " + serviceFund.getEthicscost() + "元");
|
FundDetailOneVO f2 = new FundDetailOneVO();
|
f2.setNumber("2");
|
f2.setMessage("捐献者医学成本总金额: " + serviceFund.getMedicalcost() + "元; " + "捐献者善后成本总金额: " + serviceFund.getAftercarecost() + "元");
|
FundDetailOneVO f3 = new FundDetailOneVO();
|
f3.setNumber("3");
|
f3.setMessage("捐献者家属食宿费总金额: " + serviceFund.getFamilycost() + "元");
|
l.add(f1);
|
l.add(f2);
|
l.add(f3);
|
|
return l;
|
|
}
|
|
@Override
|
public FundDetailTwoVO showFundDetailTwo(Long infoid) {
|
|
FundDetailTwoVO fdvo = new FundDetailTwoVO();
|
List<ServiceFund> serviceFunds = serviceFundMapper.getInfoByInfoId(infoid);
|
|
List<ServiceFunddetail> fd = new ArrayList<>();
|
for (ServiceFund s : serviceFunds) {
|
List<ServiceFunddetail> l = serviceFunddetailMapper.getAllDetailsByFDIDHZ(s.getId());
|
for (ServiceFunddetail df : l) {
|
fd.add(df);
|
}
|
}
|
|
List<ServiceReimbursement> serviceReimbursements1 = serviceReimbursementMapper.getInfoByInfoId(infoid);
|
List<ServiceReimbursement> serviceReimbursements2 = serviceReimbursementMapper.getInfoByInfoIdRelatives(infoid);
|
|
double f1 = 0;
|
double f2 = 0;
|
double f3 = 0;
|
double f4 = 0;
|
double f5 = 0;
|
double f6 = 0;
|
double f7 = 0;
|
double f8 = 0;
|
double f9 = 0;
|
double f10 = 0;
|
double f11 = 0;
|
double f12 = 0;
|
double f13 = 0;
|
double f14 = 0;
|
double f15 = 0;
|
double f16 = 0;
|
double f17 = 0;
|
double f18 = 0;
|
double f19 = 0;
|
double f20 = 0;
|
double f21 = 0;
|
double f22 = 0;
|
double f23 = 0;
|
double f24 = 0;
|
double f25 = 0;
|
double f26 = 0;
|
double f27 = 0;
|
double f28 = 0;
|
double f29 = 0;
|
double f30 = 0;
|
double f31 = 0;
|
double f32 = 0;
|
double f33 = 0;
|
double f34 = 0;
|
double f35 = 0;
|
double f36 = 0;
|
double f37 = 0;
|
double f38 = 0;
|
double f39 = 0;
|
double f40 = 0;
|
double f41 = 0;
|
double f42 = 0;
|
double f43 = 0;
|
double f44 = 0;
|
double f45 = 0;
|
double f46 = 0;
|
double f47 = 0;
|
double f48 = 0;
|
double f49 = 0;
|
double f50 = 0;
|
double f51 = 0;
|
double f52 = 0;
|
double hj = 0;
|
|
double sh1 = 0;
|
double sh2 = 0;
|
double sh3 = 0;
|
double sh4 = 0;
|
double sh5 = 0;
|
double sh6 = 0;
|
double sh7 = 0;
|
double sh8 = 0;
|
double sh9 = 0;
|
double sh10 = 0;
|
double sh11 = 0;
|
double sh12 = 0;
|
double sh13 = 0;
|
double sh14 = 0;
|
double sh15 = 0;
|
double sh16 = 0;
|
double sh17 = 0;
|
double sh18 = 0;
|
double sh19 = 0;
|
double sh20 = 0;
|
double sh21 = 0;
|
double sh22 = 0;
|
double sh23 = 0;
|
double sh24 = 0;
|
double sh25 = 0;
|
double sh26 = 0;
|
double sh27 = 0;
|
double sh28 = 0;
|
double sh29 = 0;
|
double sh30 = 0;
|
double sh31 = 0;
|
double sh32 = 0;
|
double sh33 = 0;
|
double sh34 = 0;
|
double sh35 = 0;
|
double sh36 = 0;
|
double sh37 = 0;
|
double sh38 = 0;
|
double sh39 = 0;
|
double sh40 = 0;
|
double sh41 = 0;
|
double sh42 = 0;
|
double sh43 = 0;
|
double sh44 = 0;
|
double sh45 = 0;
|
double sh46 = 0;
|
double sh47 = 0;
|
double sh48 = 0;
|
double sh49 = 0;
|
double sh50 = 0;
|
double sh51 = 0;
|
double sh52 = 0;
|
double shhj = 0;
|
|
for (ServiceReimbursement sr : serviceReimbursements1) {
|
f28 += sr.getAmountrequested();
|
sh28 += sr.getAmountrequested();
|
}
|
for (ServiceReimbursement sr : serviceReimbursements2) {
|
f51 += sr.getAmountrequested();
|
sh51 += sr.getAmountrequested();
|
}
|
|
for (ServiceFunddetail s : fd) {
|
if (s.getItemid() == 1) {
|
f1 += s.getAmount();
|
sh1 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 2) {
|
f2 += s.getAmount();
|
sh2 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 3) {
|
f3 += s.getAmount();
|
sh3 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 4) {
|
f4 += s.getAmount();
|
sh4 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 5) {
|
f5 += s.getAmount();
|
sh5 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 6) {
|
f6 += s.getAmount();
|
sh6 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 7) {
|
f7 += s.getAmount();
|
sh7 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 8) {
|
f8 += s.getAmount();
|
sh8 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 9) {
|
f9 += s.getAmount();
|
sh9 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 10) {
|
f10 += s.getAmount();
|
sh10 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 11) {
|
f11 += s.getAmount();
|
sh11 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 12) {
|
f12 += s.getAmount();
|
sh12 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 13) {
|
f13 += s.getAmount();
|
sh13 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 14) {
|
f14 += s.getAmount();
|
sh14 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 15) {
|
f15 += s.getAmount();
|
sh15 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 16) {
|
f16 += s.getAmount();
|
sh16 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 17) {
|
f17 += s.getAmount();
|
sh17 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 18) {
|
f18 += s.getAmount();
|
sh18 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 19) {
|
f19 += s.getAmount();
|
sh19 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 20) {
|
f20 += s.getAmount();
|
sh20 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 21) {
|
f21 += s.getAmount();
|
sh21 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 22) {
|
f22 += s.getAmount();
|
sh22 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 23) {
|
f23 += s.getAmount();
|
sh23 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 24) {
|
f24 += s.getAmount();
|
sh24 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 25) {
|
f25 += s.getAmount();
|
sh25 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 26) {
|
f26 += s.getAmount();
|
sh26 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 27) {
|
f27 += s.getAmount();
|
sh27 += s.getTaxedamount();
|
}
|
|
if (s.getItemid() == 29) {
|
f29 += s.getAmount();
|
sh29 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 30) {
|
f30 += s.getAmount();
|
sh30 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 31) {
|
f31 += s.getAmount();
|
sh31 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 32) {
|
f32 += s.getAmount();
|
sh32 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 33) {
|
f33 += s.getAmount();
|
sh33 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 34) {
|
f34 += s.getAmount();
|
sh34 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 35) {
|
f35 += s.getAmount();
|
sh35 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 36) {
|
f36 += s.getAmount();
|
sh36 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 37) {
|
f37 += s.getAmount();
|
sh37 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 38) {
|
f38 += s.getAmount();
|
sh38 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 39) {
|
f39 += s.getAmount();
|
sh39 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 40) {
|
f40 += s.getAmount();
|
sh40 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 41) {
|
f41 += s.getAmount();
|
sh41 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 42) {
|
f42 += s.getAmount();
|
sh42 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 43) {
|
f43 += s.getAmount();
|
sh43 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 44) {
|
f44 += s.getAmount();
|
sh44 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 45) {
|
f45 += s.getAmount();
|
sh45 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 46) {
|
f46 += s.getAmount();
|
sh46 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 47) {
|
f47 += s.getAmount();
|
sh47 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 48) {
|
f48 += s.getAmount();
|
sh48 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 49) {
|
f49 += s.getAmount();
|
sh49 += s.getTaxedamount();
|
}
|
|
if (s.getItemid() == 50) {
|
f50 += s.getAmount();
|
sh50 += s.getTaxedamount();
|
}
|
if (s.getItemid() == 52) {
|
f52 += s.getAmount();
|
sh52 += s.getTaxedamount();
|
}
|
}
|
|
hj = f1 + f2 + f3 + f4 + f5 + f6 + f7 + f8 + f9 + f10 + f11 + f12 + f13 + f14 + f15 + f16 + f17 + f18 + f19 + f20 + f21 + f22 + f23 + f24 + f25 + f26 + f27 + f28 + f29 + f30 + f31 + f32 + f33 + f34 + f35 + f36 + f37 + f38 + f39 + f40 + f41 + f42 + f43 + f44 + f45 + f46 + f47 + f48 + f49 + f50 + f51 + f52;
|
|
shhj = sh1 + sh2 + sh3 + sh4 + sh5 + sh6 + sh7 + sh8 + sh9 + sh10 + sh11 + sh12 + sh13 + sh14 + sh15 + sh16 + sh17 + sh18 + sh19 + sh20 + sh21 + sh22 + sh23 + sh24 + sh25 + sh26 + sh27 + sh28 + sh29 + sh30 + sh31 + sh32 + sh33 + sh34 + sh35 + sh36 + sh37 + sh38 + sh39 + sh40 + sh41 + sh42 + sh43 + sh44 + sh45 + sh46 + sh47 + sh48 + sh49 + sh50 + sh51 + sh52;
|
|
fdvo.setFy1(f1);
|
fdvo.setFy2(f2);
|
fdvo.setFy3(f3);
|
fdvo.setFy4(f4);
|
fdvo.setFy5(f5);
|
fdvo.setFy6(f6);
|
fdvo.setFy7(f7);
|
fdvo.setFy8(f8);
|
fdvo.setFy9(f9);
|
fdvo.setFy10(f10);
|
fdvo.setFy11(f11);
|
fdvo.setFy12(f12);
|
fdvo.setFy13(f13);
|
fdvo.setFy14(f14);
|
fdvo.setFy15(f15);
|
fdvo.setFy16(f16);
|
fdvo.setFy17(f17);
|
fdvo.setFy18(f18);
|
fdvo.setFy19(f19);
|
fdvo.setFy20(f20);
|
fdvo.setFy21(f21);
|
fdvo.setFy22(f22);
|
fdvo.setFy23(f23);
|
fdvo.setFy24(f24);
|
fdvo.setFy25(f25);
|
fdvo.setFy26(f26);
|
fdvo.setFy27(f27);
|
fdvo.setFy28(f28);
|
fdvo.setFy29(f29);
|
fdvo.setFy30(f30);
|
fdvo.setFy31(f31);
|
fdvo.setFy32(f32);
|
fdvo.setFy33(f33);
|
fdvo.setFy34(f34);
|
fdvo.setFy35(f35);
|
fdvo.setFy36(f36);
|
fdvo.setFy37(f37);
|
fdvo.setFy38(f38);
|
fdvo.setFy39(f39);
|
fdvo.setFy40(f40);
|
fdvo.setFy41(f41);
|
fdvo.setFy42(f42);
|
fdvo.setFy43(f43);
|
fdvo.setFy44(f44);
|
fdvo.setFy45(f45);
|
fdvo.setFy46(f46);
|
fdvo.setFy47(f47);
|
fdvo.setFy48(f48);
|
fdvo.setFy49(f49);
|
fdvo.setFy50(f50);
|
fdvo.setFy51(f51);
|
fdvo.setFy52(f52);
|
fdvo.setFyhj(hj);
|
|
fdvo.setSh1(sh1);
|
fdvo.setSh2(sh2);
|
fdvo.setSh3(sh3);
|
fdvo.setSh4(sh4);
|
fdvo.setSh5(sh5);
|
fdvo.setSh6(sh6);
|
fdvo.setSh7(sh7);
|
fdvo.setSh8(sh8);
|
fdvo.setSh9(sh9);
|
fdvo.setSh10(sh10);
|
fdvo.setSh11(sh11);
|
fdvo.setSh12(sh12);
|
fdvo.setSh13(sh13);
|
fdvo.setSh14(sh14);
|
fdvo.setSh15(sh15);
|
fdvo.setSh16(sh16);
|
fdvo.setSh17(sh17);
|
fdvo.setSh18(sh18);
|
fdvo.setSh19(sh19);
|
fdvo.setSh20(sh20);
|
fdvo.setSh21(sh21);
|
fdvo.setSh22(sh22);
|
fdvo.setSh23(sh23);
|
fdvo.setSh24(sh24);
|
fdvo.setSh25(sh25);
|
fdvo.setSh26(sh26);
|
fdvo.setSh27(sh27);
|
fdvo.setSh28(sh28);
|
fdvo.setSh29(sh29);
|
fdvo.setSh30(sh30);
|
fdvo.setSh31(sh31);
|
fdvo.setSh32(sh32);
|
fdvo.setSh33(sh33);
|
fdvo.setSh34(sh34);
|
fdvo.setSh35(sh35);
|
fdvo.setSh36(sh36);
|
fdvo.setSh37(sh37);
|
fdvo.setSh38(sh38);
|
fdvo.setSh39(sh39);
|
fdvo.setSh40(sh40);
|
fdvo.setSh41(sh41);
|
fdvo.setSh42(sh42);
|
fdvo.setSh43(sh43);
|
fdvo.setSh44(sh44);
|
fdvo.setSh45(sh45);
|
fdvo.setSh46(sh46);
|
fdvo.setSh47(sh47);
|
fdvo.setSh48(sh48);
|
fdvo.setSh49(sh49);
|
fdvo.setSh50(sh50);
|
fdvo.setSh51(sh51);
|
fdvo.setSh52(sh52);
|
fdvo.setShhj(shhj);
|
|
return fdvo;
|
}
|
|
@Override
|
public String returnId(Long id) {
|
return id.toString();
|
}
|
|
@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);
|
}
|
|
@Override
|
public int countItem(Long infoid, Long itemid) {
|
List<ServiceFund> serviceFunds = serviceFundMapper.getInfoByInfoId(infoid);
|
|
int count = 0;
|
for (ServiceFund s : serviceFunds) {
|
long fundid = s.getId();
|
int l = serviceFunddetailMapper.countItem(fundid, itemid);
|
count += l;
|
}
|
|
return count;
|
}
|
|
@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();
|
}
|
List<ServiceFunddetail> serviceFunddetails = serviceFundVO.getServiceFunddetails();
|
|
// 用于记录税前、税后的总和
|
double taxBefore = 0.0;
|
double taxAfter = 0.0;
|
|
for (ServiceFunddetail serviceFunddetail : serviceFunddetails) {
|
serviceFunddetail.setFundid(id);
|
if (serviceFunddetail.getTaxedamount() != null && serviceFunddetail.getAmount() != null && serviceFunddetail.getTaxedamount() != 0.0 && serviceFunddetail.getAmount() != 0.0) {
|
// 税前税后都不为空
|
if (serviceFunddetail.getId() == null) {
|
serviceFunddetailService.save(serviceFunddetail);
|
} else {
|
serviceFunddetailService.updateById(serviceFunddetail);
|
}
|
continue;
|
} else if (serviceFunddetail.getTaxedamount() != null && serviceFunddetail.getTaxedamount() != 0.0) {
|
// 税后求税前,如果是专家费申请 或 伦理专家费申请 才会计算税前税后
|
if (StringUtils.isNotEmpty(serviceFundVO.getApplytype()) && serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) {
|
Double taxationBefore = Double.valueOf(TaxtUtils.getTaxationBefore(BigDecimal.valueOf(serviceFunddetail.getTaxedamount())));
|
// 税金
|
String taxation = TaxtUtils.getTaxation(BigDecimal.valueOf(taxationBefore));
|
serviceFunddetail.setAmount(Double.valueOf(taxationBefore));
|
serviceFunddetail.setTaxamount(Double.parseDouble(taxation));
|
}
|
} else if (serviceFunddetail.getAmount() != null && serviceFunddetail.getAmount() != 0.0) {
|
// 税前求税后,如果是专家费申请 或 伦理专家费申请 才会计算税前税后
|
if (StringUtils.isNotEmpty(serviceFundVO.getApplytype()) && serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) {
|
double tax = Double.parseDouble(TaxtUtils.getTaxation(BigDecimal.valueOf(serviceFunddetail.getAmount())));
|
BigDecimal taxAfterMoney = BigDecimal.valueOf(serviceFunddetail.getAmount()).subtract(BigDecimal.valueOf(tax));
|
serviceFunddetail.setTaxamount(tax);
|
serviceFunddetail.setTaxedamount(taxAfterMoney.doubleValue());
|
}
|
}
|
|
//根据id判断是新增还是修改
|
if (serviceFunddetail.getId() == null) {
|
serviceFunddetailService.save(serviceFunddetail);
|
} else {
|
serviceFunddetailService.updateById(serviceFunddetail);
|
}
|
if (serviceFundVO.getApplytype().equals("1") || serviceFundVO.getApplytype().equals("2")) {
|
//如果是专家费申请 或 伦理专家费申请 才会计算税前税后
|
taxBefore = taxBefore + serviceFunddetail.getAmount();
|
taxAfter = taxAfter + serviceFunddetail.getTaxedamount();
|
}
|
}
|
//将税前、税后金额更新到fund表中
|
serviceFundVO.setPretaxcost(taxBefore);
|
serviceFundVO.setTaxedcost(taxAfter);
|
updateById(serviceFundVO);
|
|
return id;
|
}
|
|
int uploadOAFileAndUpdateDb(ServiceFundShared 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.getAnnexbankcard();//可能存在多个地址，以,分开
|
|
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();
|
}
|
|
|
//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 = sharedService.updateById(remShare);
|
if (!bRet) return -1;
|
|
return 0;
|
}
|
|
}
|
