package com.ruoyi.project.service.impl; import java.math.BigDecimal; import java.time.LocalDate; import java.time.temporal.TemporalAdjusters; import java.util.Date; import java.util.List; import com.ruoyi.common.tax.TaxtUtils; import com.ruoyi.project.domain.*; import com.ruoyi.project.domain.vo.TaxMoneyVO; import com.ruoyi.project.domain.vo.TaxedMoneyVO; import com.ruoyi.project.mapper.ServiceFundMapper; import org.apache.commons.collections4.CollectionUtils; 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.mapper.ServiceFunddetailMapper; import com.ruoyi.project.service.IServiceFunddetailService; /** * 费用申请明细Service业务层处理 * * @author ruoyi * @date 2022-01-25 */ @Service public class ServiceFunddetailServiceImpl extends ServiceImpl implements IServiceFunddetailService { @Autowired ServiceFunddetailMapper serviceFunddetailMapper; @Autowired ServiceFundMapper serviceFundMapper; /** * 查询费用申请明细列表 * * @param serviceFunddetail 费用申请明细 * @return 费用申请明细 */ @Override public List queryList(ServiceFunddetail serviceFunddetail) { LambdaQueryWrapper wrappers = Wrappers.lambdaQuery(); if (StringUtils.isNotBlank(serviceFunddetail.getBeneficiaryname())) { wrappers.like(ServiceFunddetail::getBeneficiaryname, serviceFunddetail.getBeneficiaryname()); } if (StringUtils.isNotBlank(serviceFunddetail.getUnitname())) { wrappers.like(ServiceFunddetail::getUnitname, serviceFunddetail.getUnitname()); } if (StringUtils.isNotBlank(serviceFunddetail.getApplytype())) { wrappers.eq(ServiceFunddetail::getApplytype, serviceFunddetail.getApplytype()); } if (StringUtils.isNotBlank(serviceFunddetail.getItemname())) { wrappers.like(ServiceFunddetail::getItemname, serviceFunddetail.getItemname()); } if (StringUtils.isNotBlank(serviceFunddetail.getItemtype())) { wrappers.eq(ServiceFunddetail::getItemtype, serviceFunddetail.getItemtype()); } if (StringUtils.isNotBlank(serviceFunddetail.getRecordstatus())) { wrappers.eq(ServiceFunddetail::getRecordstatus, serviceFunddetail.getRecordstatus()); } if (StringUtils.isNotBlank(serviceFunddetail.getCreateBy())) { wrappers.eq(ServiceFunddetail::getCreateBy, serviceFunddetail.getCreateBy()); } if (serviceFunddetail.getCreateTime() != null) { wrappers.eq(ServiceFunddetail::getCreateTime, serviceFunddetail.getCreateTime()); } if (StringUtils.isNotBlank(serviceFunddetail.getUploadflag())) { wrappers.eq(ServiceFunddetail::getUploadflag, serviceFunddetail.getUploadflag()); } if (serviceFunddetail.getUploadtime() != null) { wrappers.eq(ServiceFunddetail::getUploadtime, serviceFunddetail.getUploadtime()); } return this.list(wrappers); } @Override public List getDataBybeneficiaryNo(FunddetailReqVo funddetailReqVo) { if (StringUtils.isEmpty(funddetailReqVo.getStarttime())) { // 获取当月第一天日期 funddetailReqVo.setStarttime(LocalDate.now().with(TemporalAdjusters.firstDayOfMonth()).toString()); } if (StringUtils.isEmpty(funddetailReqVo.getEndtime())) { // 获取当月最后一天日期 funddetailReqVo.setEndtime(LocalDate.now().with(TemporalAdjusters.lastDayOfMonth()).toString()); } List dataBybeneficiaryNo = serviceFunddetailMapper.getDataBybeneficiaryNo(funddetailReqVo); return dataBybeneficiaryNo; } /** * 根据受益人编号获取税费金额 * * @param taxMoneyVo * @return */ @Override public Double getTaxByBeneFiciaryNo(TaxMoneyVO taxMoneyVo) { Double sum = 0.00; Double totalScore = 0.00; List taxationByBeneFiciaryNo = serviceFunddetailMapper.getTaxBeforeByBeneFiciaryNo(taxMoneyVo); if (CollectionUtils.isNotEmpty(taxationByBeneFiciaryNo)) { //计算申请金额总和,不包括当前传进来的 sum = taxationByBeneFiciaryNo.stream().mapToDouble(ServiceFunddetail::getAmount).sum(); //不加本次薪酬的个税 totalScore = taxationByBeneFiciaryNo.stream().mapToDouble(ServiceFunddetail::getTaxamount).sum(); } sum = sum + new Double(taxMoneyVo.getMoney()); //加上本次薪酬的总个税 String taxation = TaxtUtils.getTaxation(new BigDecimal(sum)); Double tax = Double.valueOf(taxation) - totalScore; return tax; } /** * 根据税后工资,算出税前工资 * * @param taxMoneyVo * @return */ @Override public TaxedMoneyVO getTaxBeforeByAfterMoney(TaxMoneyVO taxMoneyVo) { TaxedMoneyVO taxedMoneyVO = new TaxedMoneyVO(); Double sum = 0.00; Double totalScore = 0.00; List taxationByBeneFiciaryNo = serviceFunddetailMapper.getTaxBeforeByBeneFiciaryNo(taxMoneyVo); if (CollectionUtils.isNotEmpty(taxationByBeneFiciaryNo)) { //计算出税后总金额(不包含本次) sum = taxationByBeneFiciaryNo.stream().mapToDouble(ServiceFunddetail::getTaxedamount).sum(); //求出之前的总的个税 totalScore = taxationByBeneFiciaryNo.stream().mapToDouble(ServiceFunddetail::getTaxamount).sum(); } //计算出总的税后薪酬(包含本次) sum = sum + Double.valueOf(taxMoneyVo.getMoney()); //税前总金额 String taxationBefore = TaxtUtils.getTaxationBefore(new BigDecimal(sum)); //总个税 BigDecimal tax = new BigDecimal(taxationBefore).subtract(new BigDecimal(sum)); //本次的税前金额 String nowTaxMoney = TaxtUtils.getTaxationBefore(new BigDecimal(taxMoneyVo.getMoney())); //本次的税费 BigDecimal subtract = new BigDecimal(nowTaxMoney).subtract(new BigDecimal(taxMoneyVo.getMoney())); taxedMoneyVO.setAllTax(tax.toString()); taxedMoneyVO.setAllTaxbeforeMoney(taxationBefore); taxedMoneyVO.setAllAaxAfterMoney(sum.toString()); taxedMoneyVO.setNowTaxBeforeMoney(nowTaxMoney); taxedMoneyVO.setNowTax(subtract.toString()); return taxedMoneyVO; } @Override public List getAllDetailsByFDIDLW(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDLW(id); } @Override public List getAllDetailsByFDIDSH(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDSH(id); } @Override public List getAllDetailsByFDIDSS(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDSS(id); } @Override public List getAllDetailsByFDIDYX(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDYX(id); } @Override public List getAllDetailsByFDIDHZ(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDHZ(id); } @Override public List getAllDetailsByFDIDLWF(Long id) { return serviceFunddetailMapper.getAllDetailsByFDIDLWF(id); } @Override public List selectServiceFunddetailList(ServiceFunddetail serviceFunddetail) { return serviceFunddetailMapper.selectServiceFunddetailList(serviceFunddetail); } @Override public int deleteDetail(Long id) { ServiceFunddetail serviceFunddetail = serviceFunddetailMapper.selectById(id); Long fundid = serviceFunddetail.getFundid(); ServiceFund serviceFund = serviceFundMapper.selectById(fundid); Double pretax = serviceFund.getPretaxcost(); Double aftertax = serviceFund.getTaxedcost(); pretax = pretax - serviceFunddetail.getAmount(); aftertax = aftertax - serviceFunddetail.getTaxedamount(); Double amount = pretax + aftertax; serviceFund.setPretaxcost(pretax); serviceFund.setTaxedcost(aftertax); serviceFund.setAmountrequested(amount); int updateAmount = serviceFundMapper.updateById(serviceFund); return serviceFunddetailMapper.deleteById(id); } }