| | |
| | | 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 java.util.concurrent.locks.Lock; |
| | | import java.util.concurrent.locks.LockSupport; |
| | | import java.util.stream.Collectors; |
| | | |
| | | import com.alibaba.fastjson.JSON; |
| | | 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.exception.base.BaseException; |
| | | import com.ruoyi.common.utils.ChineseUtils; |
| | | import com.ruoyi.common.utils.HttpClientKit; |
| | | import com.ruoyi.common.utils.bean.DtoConversionUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | |
| | | 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; |
| | |
| | | |
| | | List<ServiceFunddetailVO> serviceFunddetails = serviceFundVO.getServiceFunddetails(); |
| | | if (CollectionUtils.isEmpty(serviceFunddetails)) { |
| | | System.out.println("serviceFunddetails为空喽"); |
| | | return null; |
| | | throw new BaseException("serviceFunddetails为空喽"); |
| | | } |
| | | // 保存详情数据 |
| | | for (ServiceFunddetailVO serviceFunddetailVO : serviceFunddetails) { |
| | | if (StringUtils.isEmpty(serviceFunddetailVO.getIdcardno())) { |
| | | throw new BaseException("请检查身份证号,身份证号为空了,姓名:" + serviceFunddetailVO.getBeneficiaryname()); |
| | | } |
| | | if (StringUtils.isEmpty(serviceFunddetailVO.getTitle()) || ChineseUtils.isChinese(serviceFunddetailVO.getTitle())) { |
| | | throw new BaseException("请检查职称是否为空(或不是中文),姓名:" + serviceFunddetailVO.getBeneficiaryname() + " 职称:" + serviceFunddetailVO.getTitle()); |
| | | } |
| | | if (StringUtils.isEmpty(serviceFunddetailVO.getBankcardno())) { |
| | | throw new BaseException("请检查银行卡号是否为空,姓名:" + serviceFunddetailVO.getBeneficiaryname()); |
| | | } |
| | | serviceFunddetailVO.setFundid(id); |
| | | //將附件转成json |
| | | if (!CollectionUtils.isEmpty(serviceFunddetailVO.getAnnexfilesList())) { |
| | |
| | | totalTaxVO.setIsTaxAfter(0); |
| | | } |
| | | List<ServiceFunddetail> serviceFunddetails = serviceFunddetailMapper.totlaTax(totalTaxVO.getFundids()); |
| | | if (CollectionUtils.isEmpty(serviceFunddetails)) { |
| | | throw new BaseException("查询的详情数据为空"); |
| | | } |
| | | |
| | | //用于返回excel |
| | | List<ServiceFunddetailExcel> serviceFunddetailList = new ArrayList<>(); |
| | |
| | | //打印算过税之后的,合计excel |
| | | util.exportExcel(serviceFunddetailList, "合计个税(税后)"); |
| | | } else { |
| | | a : for (ServiceFunddetail serviceFunddetail : serviceFunddetails) { |
| | | a: |
| | | for (ServiceFunddetail serviceFunddetail : serviceFunddetails) { |
| | | ServiceFunddetailExcel sfeBefore = new ServiceFunddetailExcel(); |
| | | ServiceFunddetailExcel sfeAfter = new ServiceFunddetailExcel(); |
| | | |
| | |
| | | |
| | | |
| | | for (ServiceFunddetail serviceFunddetail2 : serviceFunddetails) { |
| | | if (serviceFunddetail.getBeneficiaryname().trim().equals(serviceFunddetail2.getBeneficiaryname().trim()) && !(serviceFunddetail2.getServicesscopename().trim().equals("税后"))) { |
| | | if (StringUtils.isEmpty(serviceFunddetail2.getServicesscopename())) { |
| | | throw new BaseException("服务说明为空,请检查后再计算"); |
| | | } |
| | | if (serviceFunddetail.getBeneficiaryname().equals(serviceFunddetail2.getBeneficiaryname()) && !(serviceFunddetail2.getServicesscopename().equals("税后"))) { |
| | | //累计税前 |
| | | sfeBefore.setIdcardno(serviceFunddetail2.getIdcardno()); |
| | | sfeBefore.setBankcardno(serviceFunddetail2.getBankcardno()); |
| | |
| | | } |
| | | sfeBefore.setTaxedamount(null); |
| | | |
| | | } else if (serviceFunddetail.getBeneficiaryname().trim().equals(serviceFunddetail2.getBeneficiaryname().trim()) && serviceFunddetail2.getServicesscopename().trim().equals("税后")) { |
| | | } else if (serviceFunddetail.getBeneficiaryname().equals(serviceFunddetail2.getBeneficiaryname()) && serviceFunddetail2.getServicesscopename().equals("税后")) { |
| | | //累计税后 |
| | | sfeAfter.setIdcardno(serviceFunddetail2.getIdcardno()); |
| | | sfeAfter.setBankcardno(serviceFunddetail2.getBankcardno()); |