platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/PaymentConfirmServiceImpl.java
@@ -1,32 +1,39 @@
package com.by4cloud.platformx.business.service.impl;
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.date.DatePattern;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.ArrayUtil;
import cn.hutool.core.util.ObjUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.http.HttpUtil;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.by4cloud.platformx.admin.api.entity.SysDept;
import com.by4cloud.platformx.admin.api.feign.RemoteDeptService;
import com.by4cloud.platformx.business.dto.PaymentConfirmAddDTO;
import com.by4cloud.platformx.business.entity.*;
import com.by4cloud.platformx.business.mapper.ContractPaymentScheduleMapper;
import com.by4cloud.platformx.business.mapper.CurrentOverdueMapper;
import com.by4cloud.platformx.business.mapper.HistoryOverdueMapper;
import com.by4cloud.platformx.business.mapper.PaymentConfirmMapper;
import com.by4cloud.platformx.business.mapper.*;
import com.by4cloud.platformx.business.service.BusinessCustomerService;
import com.by4cloud.platformx.business.service.ContractService;
import com.by4cloud.platformx.business.service.PaymentConfirmService;
import com.by4cloud.platformx.business.utils.SignHelper;
import com.by4cloud.platformx.common.core.util.R;
import com.by4cloud.platformx.common.security.util.SecurityUtils;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import java.io.UnsupportedEncodingException;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.security.InvalidKeyException;
import java.security.NoSuchAlgorithmException;
import java.util.*;
import java.util.concurrent.TimeUnit;
/**
 * 收款确认
@@ -34,6 +41,7 @@
 * @author syt
 * @date 2026-04-29 11:33:26
 */
@Slf4j
@Service
@RequiredArgsConstructor
public class PaymentConfirmServiceImpl extends ServiceImpl<PaymentConfirmMapper, PaymentConfirm> implements PaymentConfirmService {
@@ -43,109 +51,608 @@
   private final ContractPaymentScheduleMapper contractPaymentScheduleMapper;
   private final CurrentOverdueMapper currentOverdueMapper;
   private final HistoryOverdueMapper historyOverdueMapper;
   private final PaymentSlipMapper paymentSlipMapper;
   private final BipRequestRecordMapper bipRequestRecordMapper;
   private final RemoteDeptService remoteDeptService;
   private final RedisTemplate redisTemplate;
   @Value("${bip.url}")
   private String url;
   @Value("${bip.codes}")
   private String codes;
   @Value("${bip.appKey}")
   private String appKey;
   @Value("${bip.appSecret}")
   private String appSecret;
   @Override
   public R add(PaymentConfirmAddDTO addDTO) {
      Contract contract = contractService.getOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo,addDTO.getContractNo()));
      if(ObjUtil.isNull(contract)){
         return R.failed("合同查询失败,请检查合同编号");
      if (StrUtil.isNotBlank(addDTO.getContractNo())) {
         Contract contract = contractService.getOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, addDTO.getContractNo()));
         BusinessCustomer customer = businessCustomerService.getOne(Wrappers.<BusinessCustomer>lambdaQuery()
               .eq(StrUtil.isNotBlank(addDTO.getBusGuestName()), BusinessCustomer::getCompanyName, addDTO.getBusGuestName())
               .eq(StrUtil.isNotBlank(addDTO.getBusGuestId()), BusinessCustomer::getId, addDTO.getBusGuestId()));
         if (ObjUtil.isNull(customer)) {
            return R.failed("客商查询失败,请检查客商");
         }
         PaymentConfirm lastConfirm = baseMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
               .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
         BigDecimal lastTotal = new BigDecimal("0");
         if (ObjUtil.isNotNull(lastConfirm)) {
            lastTotal = lastConfirm.getTotalAmount();
         }
         //转入
         if (StrUtil.equals(addDTO.getInOrOut(), "1")) {
            BigDecimal newtotal = addDTO.getTransationAmount().add(lastTotal);
            PaymentConfirm entity = new PaymentConfirm();
            entity.setContractId(contract.getId());
            entity.setContractName(contract.getContractName());
            entity.setContractNo(addDTO.getContractNo());
            if (ObjUtil.isNotNull(lastConfirm)) {
               entity.setScheduleId(lastConfirm.getScheduleId());
               entity.setScheduleName(lastConfirm.getScheduleName());
            }
            entity.setBusGuestId(customer.getId());
            entity.setBusGuestName(customer.getCompanyName());
            entity.setBusinessType("客户付款");
            if (newtotal.compareTo(new BigDecimal("0")) > 0) {
               entity.setTransationAmount(addDTO.getTransationAmount());
               entity.setAdvanceAmount(newtotal);
               entity.setTotalAmount(newtotal);
               entity.setConfirmTime(new Date());
               baseMapper.insert(entity);
            } else if (newtotal.compareTo(new BigDecimal("0")) == 0) {
               entity.setTransationAmount(addDTO.getTransationAmount());
               entity.setTotalAmount(newtotal);
               entity.setConfirmTime(new Date());
               baseMapper.insert(entity);
            } else {
               entity.setTransationAmount(addDTO.getTransationAmount());
               entity.setReceivableAmount(newtotal.multiply(new BigDecimal("-1")));
               entity.setTotalAmount(newtotal);
               entity.setConfirmTime(new Date());
               baseMapper.insert(entity);
            }
            //更新付款阶段付款
            List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
                  .eq(ContractPaymentSchedule::getContractId, contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus, 2)
                  .orderByAsc(ContractPaymentSchedule::getCreateTime));
            if (ArrayUtil.isNotEmpty(scheduleList.toArray())) {
               BigDecimal remain = addDTO.getTransationAmount();
               for (ContractPaymentSchedule schedule : scheduleList) {
                  BigDecimal lastRemain = remain;
                  remain = remain.subtract(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount() :
                        schedule.getPlannedAmount().subtract(schedule.getActualAmount()));
                  if (remain.compareTo(new BigDecimal("0")) >= 0) {
                     schedule.setActualAmount(schedule.getPlannedAmount());
                     schedule.setPaymentDate(addDTO.getConfirmTime());
                     schedule.setPaymentStatus(2);
                     contractPaymentScheduleMapper.updateById(schedule);
                     //查询是否有当前逾期
                     CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                           .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                     if (ObjUtil.isNotNull(currentOverdue)) {
                        //新增逾期历史
                        HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                        historyOverdue.setPaymentTime(addDTO.getConfirmTime());
                        historyOverdue.setCompId(schedule.getCompId());
                        historyOverdueMapper.insert(historyOverdue);
                        //删除当前逾期
                        currentOverdueMapper.deleteById(currentOverdue);
                     }
                  } else {
                     schedule.setActualAmount(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount().add(remain) :
                           schedule.getActualAmount().add(lastRemain));
                     schedule.setPaymentDate(addDTO.getConfirmTime());
                     schedule.setPaymentStatus(1);
                     contractPaymentScheduleMapper.updateById(schedule);
                     //查询是否有当前逾期
                     CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                           .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                     if (ObjUtil.isNotNull(currentOverdue)) {
                        //新增逾期历史
                        HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                        historyOverdue.setReceivableAmount(lastRemain);
                        historyOverdue.setPaymentTime(addDTO.getConfirmTime());
                        historyOverdue.setCompId(schedule.getCompId());
                        historyOverdueMapper.insert(historyOverdue);
                        //查询历史已付逾期金额
                        List<HistoryOverdue> historyOverdueList = historyOverdueMapper.selectList(Wrappers.<HistoryOverdue>lambdaQuery().eq(HistoryOverdue::getScheduleId, currentOverdue.getScheduleId()));
                        BigDecimal hisTotal = historyOverdueList.stream().map(item -> item.getReceivableAmount()).reduce(BigDecimal.ZERO, BigDecimal::add);
                        //更新当前逾期
                        currentOverdue.setReceivableAmount(schedule.getPlannedAmount().subtract(hisTotal));
                        currentOverdueMapper.updateById(currentOverdue);
                     }
                     break;
                  }
               }
            }
            //更新合同已付款
            BigDecimal paid = new BigDecimal("0");
            if (ObjUtil.isNotNull(contract.getPaidAmount())) {
               paid = contract.getPaidAmount();
            }
            paid = paid.add(addDTO.getTransationAmount());
            contract.setPaidAmount(paid);
            if (paid.compareTo(contract.getAmount()) > 0) {
               contract.setPaidAmount(contract.getAmount());
            }
            contractService.updateById(contract);
         }
         //转出
         if (StrUtil.equals(addDTO.getInOrOut(), "2")) {
            PaymentConfirm entity = new PaymentConfirm();
            entity.setContractId(contract.getId());
            entity.setContractName(contract.getContractName());
            entity.setContractNo(addDTO.getContractNo());
            entity.setBusGuestId(customer.getId());
            entity.setBusGuestName(customer.getCompanyName());
            entity.setBusinessType("");
            entity.setTransationAmount(addDTO.getTransationAmount());
            BigDecimal newtotal = addDTO.getTransationAmount().multiply(new BigDecimal("-1")).add(lastConfirm.getTotalAmount());
            if (newtotal.compareTo(new BigDecimal("0")) > 0) {
               entity.setAdvanceAmount(newtotal);
               entity.setTotalAmount(newtotal);
            } else if (newtotal.compareTo(new BigDecimal("0")) == 0) {
               entity.setTotalAmount(newtotal);
            } else {
               return R.failed("当前客户余额为" + lastConfirm.getTotalAmount() + "不足以满足当前发生金额,无法操作");
            }
            entity.setConfirmTime(new Date());
            baseMapper.insert(entity);
         }
         // 查询所有付款阶段是否都付款完成
         List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()));
         if (ArrayUtil.isNotEmpty(scheduleList.toArray())) {
            if (scheduleList.stream().allMatch(item -> Objects.equals(item.getPaymentStatus(), 2))) {
               contract.setContractStatus(3);
               contractService.updateById(contract);
            }
            ;
         }
      }else {
         List<Contract> customerContractList = contractService.list(Wrappers.<Contract>lambdaQuery().eq(Contract::getPartyAId, addDTO.getBusGuestId())
               .eq(Contract::getPartyBId,SecurityUtils.getUser().getCompId()).orderByAsc(Contract::getCreateTime).apply(" amount != paid_amount"));
         if (ArrayUtil.isEmpty(customerContractList.toArray())) {
            return R.failed("为查询到未付款合同");
         }
         BusinessCustomer customer = businessCustomerService.getOne(Wrappers.<BusinessCustomer>lambdaQuery()
               .eq(StrUtil.isNotBlank(addDTO.getBusGuestName()), BusinessCustomer::getCompanyName, addDTO.getBusGuestName())
               .eq(ObjUtil.isNotNull(addDTO.getBusGuestId()), BusinessCustomer::getId, addDTO.getBusGuestId())
               .last("limit 1"));
         if (ObjUtil.isNull(customer)) {
            return  R.failed("客商查询失败");
         }
         BigDecimal transtionAmount = addDTO.getTransationAmount();
         //剩余付款
         BigDecimal transtionRemainAmount = transtionAmount;
         //收到付款的合同
         List<Contract> payContractList = new ArrayList<>();
         //付款完成的合同
         List<Contract> payCompleteContractList = new ArrayList<>();
         //付款未完成的合同
         List<Contract> payNoCompleteContractList = new ArrayList<>();
         //有预付款的合同
         List<Contract> advanceContractList = new ArrayList<>();
         //付款时间
         Date payDate = addDTO.getConfirmTime();
         for (Contract contract : customerContractList) {
            PaymentConfirm lastConfirm = baseMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
                  .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
            BigDecimal lastTotal = new BigDecimal("0");
            if (ObjUtil.isNotNull(lastConfirm)) {
               lastTotal = lastConfirm.getTotalAmount();
            }
            //合同最近明细总额为0 或 > 0 情况下
            if (lastTotal.compareTo(new BigDecimal("0")) >= 0) {
               log.info("当前合同号:{},明细总额无应收款", contract.getContractNo());
               advanceContractList.add(contract);
               continue;
            }
            transtionRemainAmount = transtionRemainAmount.add(lastTotal);
            PaymentConfirm entity = new PaymentConfirm();
            entity.setContractId(contract.getId());
            entity.setContractName(contract.getContractName());
            entity.setContractNo(contract.getContractNo());
            if (ObjUtil.isNotNull(lastConfirm)) {
               entity.setScheduleId(lastConfirm.getScheduleId());
               entity.setScheduleName(lastConfirm.getScheduleName());
            }
            entity.setBusGuestId(customer.getId());
            entity.setBusGuestName(customer.getCompanyName());
            entity.setBusinessType("客户付款");
            if (transtionRemainAmount.compareTo(new BigDecimal("0")) > 0) {
               entity.setTransationAmount(lastTotal.multiply(new BigDecimal("-1")));
               entity.setTotalAmount(new BigDecimal("0"));
               entity.setConfirmTime(payDate);
               baseMapper.insert(entity);
               payContractList.add(contract);
            } else if (transtionRemainAmount.compareTo(new BigDecimal("0")) == 0) {
               entity.setTransationAmount(lastTotal.multiply(new BigDecimal("-1")));
               entity.setTotalAmount(new BigDecimal("0"));
               entity.setConfirmTime(payDate);
               baseMapper.insert(entity);
               payContractList.add(contract);
               break;
            } else {
               entity.setTransationAmount(transtionRemainAmount.subtract(lastTotal));
               entity.setTotalAmount(transtionAmount);
               entity.setConfirmTime(payDate);
               baseMapper.insert(entity);
               payContractList.add(contract);
               break;
            }
         }
         payContractList.stream().forEach(contract -> {
            //更新付款阶段付款
            List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
                  .eq(ContractPaymentSchedule::getContractId, contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus, 2)
                  .orderByAsc(ContractPaymentSchedule::getCreateTime));
            if (ArrayUtil.isNotEmpty(scheduleList.toArray())) {
               BigDecimal remain = transtionAmount;
               for (ContractPaymentSchedule schedule : scheduleList) {
                  BigDecimal lastRemain = remain;
                  remain = lastRemain.subtract(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount() :
                        schedule.getPlannedAmount().subtract(schedule.getActualAmount()));
                  if (remain.compareTo(new BigDecimal("0")) >= 0) {
                     schedule.setActualAmount(schedule.getPlannedAmount());
                     schedule.setPaymentDate(payDate);
                     schedule.setPaymentStatus(2);
                     contractPaymentScheduleMapper.updateById(schedule);
                     //查询是否有当前逾期
                     CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                           .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                     if (ObjUtil.isNotNull(currentOverdue)) {
                        //新增逾期历史
                        HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                        historyOverdue.setPaymentTime(payDate);
                        historyOverdue.setCompId(schedule.getCompId());
                        historyOverdueMapper.insert(historyOverdue);
                        //删除当前逾期
                        currentOverdueMapper.deleteById(currentOverdue);
                     }
                  } else {
                     schedule.setActualAmount(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount().add(remain) :
                           schedule.getActualAmount().add(lastRemain));
                     schedule.setPaymentDate(payDate);
                     schedule.setPaymentStatus(1);
                     contractPaymentScheduleMapper.updateById(schedule);
                     //查询是否有当前逾期
                     CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                           .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                     if (ObjUtil.isNotNull(currentOverdue)) {
                        //新增逾期历史
                        HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                        historyOverdue.setReceivableAmount(lastRemain);
                        historyOverdue.setPaymentTime(payDate);
                        historyOverdue.setCompId(schedule.getCompId());
                        historyOverdueMapper.insert(historyOverdue);
                        //查询历史已付逾期金额
                        List<HistoryOverdue> historyOverdueList = historyOverdueMapper.selectList(Wrappers.<HistoryOverdue>lambdaQuery().eq(HistoryOverdue::getScheduleId, currentOverdue.getScheduleId()));
                        BigDecimal hisTotal = historyOverdueList.stream().map(item -> item.getReceivableAmount()).reduce(BigDecimal.ZERO, BigDecimal::add);
                        //更新当前逾期
                        currentOverdue.setReceivableAmount(schedule.getPlannedAmount().subtract(hisTotal));
                        currentOverdueMapper.updateById(currentOverdue);
                     }
                     break;
                  }
               }
            }
            //合同所有付款阶段
            List<ContractPaymentSchedule> payComScheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
                  .eq(ContractPaymentSchedule::getContractId, contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus, 0)
                  );
            if (ArrayUtil.isNotEmpty(payComScheduleList.toArray())){
               BigDecimal payTotal = payComScheduleList.stream().map(item->StrUtil.equals(item.getPaymentStatus() + "", "0") ? item.getPlannedAmount() :
                     item.getActualAmount()).reduce(BigDecimal.ZERO,BigDecimal::add);
               contract.setPaidAmount(payTotal);
               if (payComScheduleList.stream().allMatch(item -> Objects.equals(item.getPaymentStatus(), 2))) {
                  contract.setContractStatus(3);
               }
               contractService.updateById(contract);
               if (contract.getAmount().compareTo(contract.getPaidAmount()) == 0) {
                  payCompleteContractList.add(contract);
               }
               //付款 且 付款未全付
               if (contract.getAmount().compareTo(contract.getPaidAmount()) > 0) {
                  payNoCompleteContractList.add(contract);
               }
            }
         });
         //客户预付有剩余 且 有预付款的合同
         if (transtionRemainAmount.compareTo(new BigDecimal("0")) > 0) {
            if (ArrayUtil.isNotEmpty(payNoCompleteContractList.toArray())){
               //余额 放到付款未完成合同 预收
               Contract lastContract = payNoCompleteContractList.get(0);
               //保存明细
               saveNewPaymentConfirm(customer,null,lastContract,transtionRemainAmount,payDate);
            }
            if (ArrayUtil.isEmpty(payNoCompleteContractList.toArray())&&ArrayUtil.isNotEmpty(advanceContractList.toArray())){
               //客户预付有剩余 没有预付款的合同
               Contract lastContract = advanceContractList.get(0);
               //保存明细
               saveNewPaymentConfirm(customer,null,lastContract,transtionRemainAmount,payDate);
            }
            if (ArrayUtil.isEmpty(payNoCompleteContractList.toArray())&&ArrayUtil.isEmpty(advanceContractList.toArray())
                  &&ArrayUtil.isNotEmpty(payCompleteContractList.toArray())) {
               //客户预付有剩余 没有预付款的合同
               Contract lastContract = payCompleteContractList.get(payCompleteContractList.size() - 1);
               //保存明细
               saveNewPaymentConfirm(customer,null,lastContract,transtionRemainAmount,payDate);
            }
         }
      }
      return R.ok();
   }
   @Override
   public R syncPaymentRecepit() {
      String accessToken = "";
      if (redisTemplate.hasKey("BIP_TOKEN")) {
         accessToken = (String) redisTemplate.opsForValue().get("BIP_TOKEN");
      } else {
         getAccessToken(accessToken);
      }
      if (StrUtil.isEmpty(accessToken)) {
         return R.failed("获取token失败");
      }
      String[] bipCodeArr = codes.split(",");
      for (String bipCode : bipCodeArr) {
         //入参
         JSONObject params = genParams(bipCode);
         String finalAccessToken = accessToken;
         new Thread(() -> {
            try {
               Thread.sleep(500);
            } catch (InterruptedException e) {
               throw new RuntimeException(e);
            }
            log.info("SK_CX Request:", params.toJSONString());
            String result = HttpUtil.post(url + "/yonbip/EFI/collection/list?access_token=" + finalAccessToken, params.toJSONString());
            log.info("SK_CX Response:{}", result);
            //保存请求记录
            saveBipRequestRecord(params, result);
            JSONObject resultJson = JSONObject.parseObject(result);
            if (resultJson.containsKey("code") && resultJson.getString("code").equals("200")) {
               handleAndSave(bipCode, resultJson);
            }
         }).start();
      }
      return R.ok();
   }
   private JSONObject genParams(String bipCode){
      JSONObject params = new JSONObject();
      params.put("pageIndex", 1);
      params.put("pageSize", 999);
      params.put("open_billDate_begin", DateUtil.offsetDay(new Date(), -1) + " 00:00:00");
      params.put("open_billDate_begin", DateUtil.today() + " 00:00:00");
      //单据状态已审批
      params.put("verifyState", new String[]{"2"});
      //往来对象客户
      params.put("objectType", new String[]{"1"});
      //单位
      JSONObject simpleMap = new JSONObject();
      simpleMap.put("financeOrg.code", bipCode);
      params.put("simple", simpleMap);
      return params;
   }
   private void getAccessToken(String accessToken) {
      long timestamp = System.currentTimeMillis();
      Map<String, Object> paramMap = new HashMap<>();
      paramMap.put("appKey", appKey);
      paramMap.put("timestamp", timestamp);
      String signature = null;
      try {
         signature = SignHelper.sign(paramMap, appSecret);
      } catch (NoSuchAlgorithmException e) {
         throw new RuntimeException(e);
      } catch (UnsupportedEncodingException e) {
         throw new RuntimeException(e);
      } catch (InvalidKeyException e) {
         throw new RuntimeException(e);
      }
      String getTokenResult = HttpUtil.get(url + "/iuap-api-auth/open-auth/selfAppAuth/getAccessToken?appKey=" + appKey + "&timestamp=" + timestamp
            + "&signature=" + signature);
      log.info("Get access_token Response:", getTokenResult);
      JSONObject tokenJson = JSONObject.parseObject(getTokenResult);
      if (!tokenJson.containsKey("code") || !tokenJson.getString("code").equals("200")) {
         log.error("Get access_token ERROR");
         return;
      }
      if (ObjUtil.isNull(tokenJson.get("data")) || ObjUtil.isNull(JSONObject.parseObject(tokenJson.getString("data")))) {
         log.error("access_token value exception");
         return;
      }
      accessToken = JSONObject.parseObject(tokenJson.getString("data")).getString("access_token");
      log.info("access_token value:", accessToken);
      redisTemplate.opsForValue().set("BIP_TOKEN", accessToken, tokenJson.getIntValue("expire") - 10, TimeUnit.SECONDS);
   }
   private void saveBipRequestRecord(JSONObject params, String result) {
      BipRequestRecord record = new BipRequestRecord();
      record.setInterfaceName("<XSJZ_SK_CX_001>-收款单查询接口");
      record.setRequestParams(params.toJSONString());
      record.setResponseParams(result);
      record.setResponseCode(JSONObject.parseObject(result).getString("code"));
      bipRequestRecordMapper.insert(record);
   }
   private void handleAndSave(String bipCode, JSONObject resultJson) {
      R<SysDept> r = remoteDeptService.selectDeptByBipCode(bipCode);
      if (!r.isOk()) {
         log.error("bipcode查询单位失败");
         return;
      }
      SysDept dept = r.getData();
      JSONObject dataJson = JSONObject.parseObject(resultJson.getString("data"));
      if (ObjUtil.isNull(dataJson)) {
         log.error("返回结果中data解析失败");
         return;
      }
      JSONArray recordList = JSONArray.parseArray(resultJson.getString("recordList"));
      if (ArrayUtil.isEmpty(recordList.toArray())) {
         log.error("返回结果中recordList为空");
         return;
      }
      log.info("==================开始处理收款单信息===================");
      recordList.stream().forEach(record -> {
         savePaymentConfirm((JSONObject) record, dept);
      });
      log.info("==================结束处理收款单信息===================");
   }
   private void savePaymentConfirm(JSONObject record, SysDept dept) {
      List<Contract> contractList = contractService.list(Wrappers.<Contract>lambdaQuery().eq(Contract::getPartyA, record.getString("bodyItemCustomerName"))
            .eq(Contract::getPartyBId, dept.getDeptId()).orderByAsc(Contract::getCreateTime));
      if (ArrayUtil.isEmpty(contractList.toArray())) {
         log.error("付款单id:{},甲方:{},乙方:{},无相关合同", record.getString("id"), record.getString("bodyItemCustomerName"), dept.getName());
         return;
      }
      BusinessCustomer customer = businessCustomerService.getOne(Wrappers.<BusinessCustomer>lambdaQuery()
            .eq(StrUtil.isNotBlank(addDTO.getBusGuestName()),BusinessCustomer::getCompanyName,addDTO.getBusGuestName())
            .eq(StrUtil.isNotBlank(addDTO.getBusGuestId()),BusinessCustomer::getId,addDTO.getBusGuestId()));
      if(ObjUtil.isNull(customer)){
         return R.failed("客商查询失败,请检查客商");
            .eq(StrUtil.isNotBlank(record.getString("bodyItemCustomerName")), BusinessCustomer::getCompanyName, record.getString("bodyItemCustomerName"))
      );
      if (ObjUtil.isNull(customer)) {
         log.error("付款单id:{},客商查询失败,请检查客商", record.getString("id"));
         return;
      }
      PaymentConfirm lastConfirm = baseMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId,contract.getId())
            .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
      BigDecimal lastTotal = new BigDecimal("0");
      if(ObjUtil.isNotNull(lastConfirm)){
         lastTotal = lastConfirm.getTotalAmount();
      if (ObjUtil.isNull(record.getBigDecimal("bodyItemOriTaxExcludedAmount"))) {
         log.error("付款单id:{},付款单无税金额,异常", record.getString("id"));
         return;
      }
      //保存付款单
      Boolean codeFlag = savePaymentSlip(customer,record);
      if (codeFlag){
         log.error("付款单id:{},付款单已存在");
         return;
      }
      BigDecimal transtionAmount = record.getBigDecimal("bodyItemOriTaxExcludedAmount");
      //剩余付款
      BigDecimal transtionRemainAmount = transtionAmount;
      //收到付款的合同
      List<Contract> payContractList = new ArrayList<>();
      //付款完成的合同
      List<Contract> payCompleteContractList = new ArrayList<>();
      //付款未完成的合同
      List<Contract> payNoCompleteContractList = new ArrayList<>();
      //有预付款的合同
      List<Contract> advanceContractList = new ArrayList<>();
      //付款时间
      Date payDate = DateUtil.parse(record.getString("billDate"), DatePattern.NORM_DATETIME_FORMAT);
      for (Contract contract : contractList) {
         PaymentConfirm lastConfirm = baseMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
               .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
         BigDecimal lastTotal = new BigDecimal("0");
         if (ObjUtil.isNotNull(lastConfirm)) {
            lastTotal = lastConfirm.getTotalAmount();
         }
      //转入
      if (StrUtil.equals(addDTO.getInOrOut(),"1")){
         BigDecimal newtotal = addDTO.getTransationAmount().add(lastTotal);
         //合同最近明细总额为0 或 > 0 情况下
         if (lastTotal.compareTo(new BigDecimal("0")) >= 0) {
            log.info("当前合同号:{},明细总额无应收款", contract.getContractNo());
            advanceContractList.add(contract);
            continue;
         }
         transtionRemainAmount = transtionRemainAmount.add(lastTotal);
         PaymentConfirm entity = new PaymentConfirm();
         entity.setContractId(contract.getId());
         entity.setContractName(contract.getContractName());
         entity.setContractNo(addDTO.getContractNo());
         if(ObjUtil.isNotNull(lastConfirm)){
         entity.setContractNo(contract.getContractNo());
         if (ObjUtil.isNotNull(lastConfirm)) {
            entity.setScheduleId(lastConfirm.getScheduleId());
            entity.setScheduleName(lastConfirm.getScheduleName());
         }
         entity.setBusGuestId(customer.getId());
         entity.setBusGuestName(customer.getCompanyName());
         entity.setBusinessType("客户付款");
         if (newtotal.compareTo(new BigDecimal("0"))>0){
            entity.setTransationAmount(addDTO.getTransationAmount());
            entity.setAdvanceAmount(newtotal);
            entity.setTotalAmount(newtotal);
            entity.setConfirmTime(new Date());
         entity.setIsBip(1);
         entity.setPaymentCode(record.getString("code"));
         entity.setPayType(record.get("bodyItemSettleModeName") != null ? record.getString("bodyItemSettleModeName").contains("承兑汇票") ? 1 : 0 : null);
         entity.setBipId(record.getString("id"));
         if (transtionRemainAmount.compareTo(new BigDecimal("0")) > 0) {
            entity.setTransationAmount(lastTotal.multiply(new BigDecimal("-1")));
            entity.setTotalAmount(new BigDecimal("0"));
            entity.setConfirmTime(payDate);
            baseMapper.insert(entity);
         }else if (newtotal.compareTo(new BigDecimal("0"))==0){
            entity.setTransationAmount(addDTO.getTransationAmount());
            entity.setTotalAmount(newtotal);
            entity.setConfirmTime(new Date());
         } else if (transtionRemainAmount.compareTo(new BigDecimal("0")) == 0) {
            entity.setTransationAmount(lastTotal.multiply(new BigDecimal("-1")));
            entity.setTotalAmount(new BigDecimal("0"));
            entity.setConfirmTime(payDate);
            baseMapper.insert(entity);
         }else {
            entity.setTransationAmount(addDTO.getTransationAmount());
            entity.setReceivableAmount(newtotal.multiply(new BigDecimal("-1")));
            entity.setTotalAmount(newtotal);
            entity.setConfirmTime(new Date());
            break;
         } else {
            entity.setTransationAmount(transtionRemainAmount.subtract(lastTotal));
            entity.setTotalAmount(transtionAmount);
            entity.setConfirmTime(payDate);
            baseMapper.insert(entity);
            break;
         }
      }
      payContractList.stream().forEach(contract -> {
         //更新付款阶段付款
         List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
               .eq(ContractPaymentSchedule::getContractId,contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus,2)
               .eq(ContractPaymentSchedule::getContractId, contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus, 2)
               .orderByAsc(ContractPaymentSchedule::getCreateTime));
         if (ArrayUtil.isNotEmpty(scheduleList.toArray())){
            BigDecimal remain = addDTO.getTransationAmount();
            for (ContractPaymentSchedule schedule:scheduleList) {
         if (ArrayUtil.isNotEmpty(scheduleList.toArray())) {
            BigDecimal remain = transtionAmount;
            for (ContractPaymentSchedule schedule : scheduleList) {
               BigDecimal lastRemain = remain;
               remain = remain.subtract(StrUtil.equals(schedule.getPaymentStatus()+"","0")?schedule.getPlannedAmount():
               remain = remain.subtract(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount() :
                     schedule.getPlannedAmount().subtract(schedule.getActualAmount()));
               if (remain.compareTo(new BigDecimal("0"))>=0){
               if (remain.compareTo(new BigDecimal("0")) >= 0) {
                  schedule.setActualAmount(schedule.getPlannedAmount());
                  schedule.setPaymentDate(addDTO.getConfirmTime());
                  schedule.setPaymentDate(payDate);
                  schedule.setPaymentStatus(2);
                  contractPaymentScheduleMapper.updateById(schedule);
                  //查询是否有当前逾期
                  CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId,schedule.getId())
                        .eq(CurrentOverdue::getContractId,schedule.getContractId()).last("limit 1"));
                  if (ObjUtil.isNotNull(currentOverdue)){
                  CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                        .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                  if (ObjUtil.isNotNull(currentOverdue)) {
                     //新增逾期历史
                     HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue,HistoryOverdue.class,"id");
                     historyOverdue.setPaymentTime(addDTO.getConfirmTime());
                     HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                     historyOverdue.setPaymentTime(payDate);
                     historyOverdue.setCompId(schedule.getCompId());
                     historyOverdueMapper.insert(historyOverdue);
                     //删除当前逾期
                     currentOverdueMapper.deleteById(currentOverdue);
                  }
               }else {
                  schedule.setActualAmount(StrUtil.equals(schedule.getPaymentStatus()+"","0")?schedule.getPlannedAmount().add(remain):
               } else {
                  schedule.setActualAmount(StrUtil.equals(schedule.getPaymentStatus() + "", "0") ? schedule.getPlannedAmount().add(remain) :
                        schedule.getActualAmount().add(lastRemain));
                  schedule.setPaymentDate(addDTO.getConfirmTime());
                  schedule.setPaymentDate(payDate);
                  schedule.setPaymentStatus(1);
                  contractPaymentScheduleMapper.updateById(schedule);
                  //查询是否有当前逾期
                  CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId,schedule.getId())
                        .eq(CurrentOverdue::getContractId,schedule.getContractId()).last("limit 1"));
                  if (ObjUtil.isNotNull(currentOverdue)){
                  CurrentOverdue currentOverdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getScheduleId, schedule.getId())
                        .eq(CurrentOverdue::getContractId, schedule.getContractId()).last("limit 1"));
                  if (ObjUtil.isNotNull(currentOverdue)) {
                     //新增逾期历史
                     HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue,HistoryOverdue.class,"id");
                     HistoryOverdue historyOverdue = BeanUtil.copyProperties(currentOverdue, HistoryOverdue.class, "id");
                     historyOverdue.setReceivableAmount(lastRemain);
                     historyOverdue.setPaymentTime(addDTO.getConfirmTime());
                     historyOverdue.setPaymentTime(payDate);
                     historyOverdue.setCompId(schedule.getCompId());
                     historyOverdueMapper.insert(historyOverdue);
                     //查询历史已付逾期金额
                     List<HistoryOverdue> historyOverdueList = historyOverdueMapper.selectList(Wrappers.<HistoryOverdue>lambdaQuery().eq(HistoryOverdue::getScheduleId,currentOverdue.getScheduleId()));
                     BigDecimal hisTotal = historyOverdueList.stream().map(item->item.getReceivableAmount()).reduce(BigDecimal.ZERO,BigDecimal::add);
                     List<HistoryOverdue> historyOverdueList = historyOverdueMapper.selectList(Wrappers.<HistoryOverdue>lambdaQuery().eq(HistoryOverdue::getScheduleId, currentOverdue.getScheduleId()));
                     BigDecimal hisTotal = historyOverdueList.stream().map(item -> item.getReceivableAmount()).reduce(BigDecimal.ZERO, BigDecimal::add);
                     //更新当前逾期
                     currentOverdue.setReceivableAmount(schedule.getPlannedAmount().subtract(hisTotal));
                     currentOverdueMapper.updateById(currentOverdue);
@@ -154,70 +661,107 @@
               }
            }
         }
         //更新合同已付款
         BigDecimal paid = new BigDecimal("0");
         if (ObjUtil.isNotNull(contract.getPaidAmount())){
            paid = contract.getPaidAmount();
         }
         paid = paid.add(addDTO.getTransationAmount());
         contract.setPaidAmount(paid);
         if (paid.compareTo(contract.getAmount())>0){
            contract.setPaidAmount(contract.getAmount());
         }
         contractService.updateById(contract);
      }
      //转出
      if (StrUtil.equals(addDTO.getInOrOut(),"2")){
         PaymentConfirm entity = new PaymentConfirm();
         entity.setContractId(contract.getId());
         entity.setContractName(contract.getContractName());
         entity.setContractNo(addDTO.getContractNo());
         entity.setBusGuestId(customer.getId());
         entity.setBusGuestName(customer.getCompanyName());
         entity.setBusinessType("");
         entity.setTransationAmount(addDTO.getTransationAmount());
         BigDecimal newtotal = addDTO.getTransationAmount().multiply(new BigDecimal("-1")).add(lastConfirm.getTotalAmount());
         if (newtotal.compareTo(new BigDecimal("0"))>0){
            entity.setAdvanceAmount(newtotal);
            entity.setTotalAmount(newtotal);
         }else if (newtotal.compareTo(new BigDecimal("0"))==0){
            entity.setTotalAmount(newtotal);
         }else {
            return R.failed("当前客户余额为"+lastConfirm.getTotalAmount()+"不足以满足当前发生金额,无法操作");
         }
         entity.setConfirmTime(new Date());
         baseMapper.insert(entity);
      }
      // 查询所有付款阶段是否都付款完成
      List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId,contract.getId()));
      if (ArrayUtil.isNotEmpty(scheduleList.toArray())){
         if (scheduleList.stream().allMatch(item -> Objects.equals(item.getPaymentStatus(), 2))){
            contract.setContractStatus(3);
         //合同所有付款阶段
         List<ContractPaymentSchedule> payComScheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
               .eq(ContractPaymentSchedule::getContractId, contract.getId()).ne(ContractPaymentSchedule::getPaymentStatus, 0)
         );
         if (ArrayUtil.isNotEmpty(payComScheduleList.toArray())){
            BigDecimal payTotal = payComScheduleList.stream().map(item->StrUtil.equals(item.getPaymentStatus() + "", "0") ? item.getPlannedAmount() :
                  item.getActualAmount()).reduce(BigDecimal.ZERO,BigDecimal::add);
            contract.setPaidAmount(payTotal);
            if (payComScheduleList.stream().allMatch(item -> Objects.equals(item.getPaymentStatus(), 2))) {
               contract.setContractStatus(3);
            }
            contractService.updateById(contract);
         };
            if (contract.getAmount().compareTo(contract.getPaidAmount()) == 0) {
               payCompleteContractList.add(contract);
            }
            //付款 且 付款未全付
            if (contract.getAmount().compareTo(contract.getPaidAmount()) > 0) {
               payNoCompleteContractList.add(contract);
            }
         }
      });
      //客户预付有剩余 且 有预付款的合同
      if (transtionRemainAmount.compareTo(new BigDecimal("0")) > 0) {
         if (ArrayUtil.isNotEmpty(payNoCompleteContractList.toArray())){
            //余额 放到付款未完成合同 预收
            Contract lastContract = payNoCompleteContractList.get(payNoCompleteContractList.size() - 1);
            //保存明细
            saveNewPaymentConfirm(customer,record,lastContract,transtionRemainAmount,payDate);
         }
         if (ArrayUtil.isEmpty(payNoCompleteContractList.toArray())&&ArrayUtil.isNotEmpty(advanceContractList.toArray())){
            //客户预付有剩余 没有预付款的合同
            Contract lastContract = payNoCompleteContractList.get(payNoCompleteContractList.size() - 1);
            //保存明细
            saveNewPaymentConfirm(customer,record,lastContract,transtionRemainAmount,payDate);
         }
         if (ArrayUtil.isEmpty(payNoCompleteContractList.toArray())&&ArrayUtil.isEmpty(advanceContractList.toArray())
               &&ArrayUtil.isNotEmpty(payCompleteContractList.toArray())) {
            //客户预付有剩余 没有预付款的合同
            Contract lastContract = payCompleteContractList.get(payCompleteContractList.size() - 1);
            //保存明细
            saveNewPaymentConfirm(customer,record,lastContract,transtionRemainAmount,payDate);
         }
      }
      return R.ok();
   }
   @Override
   public R syncPaymentRecepit() {
   private Boolean savePaymentSlip(BusinessCustomer customer, JSONObject record) {
      PaymentSlip slip = new PaymentSlip();
      slip.setBusGuestId(customer.getId());
      slip.setBusGuestName(customer.getCompanyName());
      slip.setPaymentTime(ObjUtil.isNotNull(record.get("billDate"))?
            DateUtil.parse(record.getString("billDate"), DatePattern.NORM_DATETIME_FORMAT):new Date());
      slip.setPaymentAmount(ObjUtil.isNotNull(record.get("bodyItemOriTaxExcludedAmount"))?record.getBigDecimal("bodyItemOriTaxExcludedAmount"):new BigDecimal("0"));
      slip.setPayType(ObjUtil.isNotNull(record.get("bodyItemSettleModeName"))?record.getString("bodyItemSettleModeName"):"");
      if (ObjUtil.isNotNull(record.get("code"))){
         slip.setPaymentNumber(record.getString("code"));
         PaymentSlip paymentSlip = paymentSlipMapper.selectOne(Wrappers.<PaymentSlip>lambdaQuery().eq(PaymentSlip::getPaymentNumber,slip.getPaymentNumber()));
         if (ObjUtil.isNull(paymentSlip)) {
            paymentSlipMapper.insert(slip);
            return false;
         }
      }
      return true;
   }
      JSONObject params = new JSONObject();
      params.put("pageIndex", 1);
      params.put("pageSize", 999);
      params.put("open_billDate_begin", DateUtil.offsetDay(new Date(),-1) + " 00:00:00");
      params.put("open_billDate_begin", DateUtil.today() + " 00:00:00");
      //单据状态已审批
      params.put("verifyState", new String[]{"2"});
      //往来对象客户
      params.put("objectType", new String[]{"1"});
      //单位
//      JSONObject simpleMap = new JSONObject();
//      simpleMap.put("financeOrg.code", bipCode);
//      params.put("simple", simpleMap);
      HttpUtil.post(url+"/yonbip/EFI/collection/list",params.toJSONString());
   public void saveNewPaymentConfirm(BusinessCustomer customer,JSONObject record,Contract contract,BigDecimal transtionRemainAmount
      ,Date payDate){
      PaymentConfirm entity = new PaymentConfirm();
      entity.setContractId(contract.getId());
      entity.setContractName(contract.getContractName());
      entity.setContractNo(contract.getContractNo());
      PaymentConfirm lastConfirm = baseMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
            .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
      BigDecimal lastTotal = new BigDecimal("0");
      if (ObjUtil.isNotNull(lastConfirm)) {
         lastTotal = lastConfirm.getTotalAmount();
      }
      return null;
      if (ObjUtil.isNotNull(lastConfirm)) {
         entity.setScheduleId(lastConfirm.getScheduleId());
         entity.setScheduleName(lastConfirm.getScheduleName());
      }
      entity.setBusGuestId(customer.getId());
      entity.setBusGuestName(customer.getCompanyName());
      entity.setBusinessType("客户付款");
      if (ObjUtil.isNotNull(record)){
         entity.setIsBip(1);
         entity.setPaymentCode(record.getString("code"));
         entity.setPayType(record.get("bodyItemSettleModeName") != null ? record.getString("bodyItemSettleModeName").contains("承兑汇票") ? 1 : 0 : null);
         entity.setBipId(record.getString("id"));
      }
      entity.setConfirmTime(payDate);
      entity.setTransationAmount(transtionRemainAmount);
      entity.setTotalAmount(transtionRemainAmount.add(lastTotal));
      if (entity.getTotalAmount().compareTo(new BigDecimal("0"))>0){
         entity.setAdvanceAmount(entity.getTotalAmount());
      }else if (entity.getTotalAmount().compareTo(new BigDecimal("0"))<0){
         entity.setReceivableAmount(entity.getTotalAmount().multiply(new BigDecimal("-1")));
      }
      baseMapper.insert(entity);
   }
}