platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractServiceImpl.java
@@ -1,28 +1,38 @@
package com.by4cloud.platformx.business.service.impl;
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.convert.Convert;
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.HttpRequest;
import cn.hutool.http.HttpResponse;
import cn.hutool.http.HttpUtil;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelReader;
import com.alibaba.excel.read.metadata.ReadSheet;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.by4cloud.platformx.admin.api.entity.SysDept;
import com.by4cloud.platformx.admin.api.entity.SysDictItem;
import com.by4cloud.platformx.admin.api.feign.RemoteDeptService;
import com.by4cloud.platformx.admin.api.feign.RemoteDictService;
import com.by4cloud.platformx.business.api.feign.RemoteFlowProcessService;
import com.by4cloud.platformx.business.constant.FlowNameEnum;
import com.by4cloud.platformx.business.dto.ContracQueryDTO;
import com.by4cloud.platformx.business.dto.ContractAddDTO;
import com.by4cloud.platformx.business.dto.ContractUpdateDTO;
import com.by4cloud.platformx.business.dto.DelayOutApprovalDTO;
import com.by4cloud.platformx.business.dto.*;
import com.by4cloud.platformx.business.entity.*;
import com.by4cloud.platformx.business.mapper.*;
import com.by4cloud.platformx.business.service.ContractPaymentScheduleProcessService;
import com.by4cloud.platformx.business.service.ContractService;
import com.by4cloud.platformx.business.utils.ContractNumberGenerator;
import com.by4cloud.platformx.business.vo.ContractDetailVo;
import com.by4cloud.platformx.business.utils.BatchInsertListener;
import com.by4cloud.platformx.business.utils.ItemGeneratorUtil;
import com.by4cloud.platformx.business.utils.NetworkFileToBase64;
import com.by4cloud.platformx.business.vo.*;
import com.by4cloud.platformx.common.core.util.R;
import com.by4cloud.platformx.common.data.datascope.DataScope;
import com.by4cloud.platformx.common.security.util.SecurityUtils;
@@ -33,8 +43,13 @@
import com.deepoove.poi.plugin.table.LoopRowTableRenderPolicy;
import jakarta.servlet.http.HttpServletResponse;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.io.ClassPathResource;
import org.springframework.data.redis.core.StringRedisTemplate;
import org.springframework.security.core.parameters.P;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import java.io.IOException;
import java.io.OutputStream;
@@ -43,12 +58,16 @@
import java.util.*;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.concurrent.atomic.AtomicReference;
import java.util.stream.Collectors;
;
/**
 * @author cd
 * @description
 * @date 2026/4/29 14:07
 **/
@Slf4j
@Service
@RequiredArgsConstructor
public class ContractServiceImpl extends ServiceImpl<ContractMapper, Contract> implements ContractService {
@@ -65,33 +84,156 @@
   private final ProductMapper productMapper;
   private final RemoteDeptService remoteDeptService;
   private final ContractDelayOutMapper contractDelayOutMapper;
   private final ErpRequestRecordMapper erpRequestRecordMapper;
   private final PaymentSlipMapper paymentSlipMapper;
   private final ContractInvoiceMapper contractInvoiceMapper;
   private final StringRedisTemplate redisTemplate;
   private final ContractOutBoundMapper contractOutBoundMapper;
   private final RemoteDictService remoteDictService;
   private final ContractPaymentScheduleProcessService processService;
   private final ContractSubjectMatterChangeMapper changeMapper;
   private final ContractApprovalMapper contractApprovalMapper;
   @Value("${erp.ymj}")
   private String ymjErp;
   @Value("${erp.smj}")
   private String smjErp;
   @Value("${erp.smjsc}")
   private String smjscErp;
   @Value("${erp.smjzt}")
   private String smjztErp;
   @Value("${erp.sgb}")
   private String sgbErp;
   @Value("${erp.jxc}")
   private String jxcErp;
   @Value("${erp.tfgs}")
   private String tfgsErp;
   @Value("${dept.smj}")
   private String smj;
   @Value("${dept.smjsc}")
   private String smjsc;
   @Value("${dept.smjzt}")
   private String smjzt;
   @Value("${dept.smjhw}")
   private String smjhw;
   @Value("${dept.sgb}")
   private String sgb;
   @Value("${dept.jxc}")
   private String jxc;
   @Value("${dept.tfgs}")
   private String tfgs;
   @Value("${dept.ymj}")
   private String ymj;
   @Value("${tmp.smj}")
   private String tempSMJ;
   @Value("${tmp.sgb}")
   private String tempSGB;
   @Value("${tmp.jxc}")
   private String tempJXC;
   @Value("${tmp.tfgs}")
   private String tempTFGS;
   @Value("${tmp.ymj}")
   private String tempYMJ;
   @Override
   public R add(ContractAddDTO addDTO) {
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      contract.setContractNo(ContractNumberGenerator.generateContractNumber());
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("0");
      contract.setErpPushFlag("0");
      if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && (
            StrUtil.equals(addDTO.getContractCategory(), "ymjgkcpmm")||StrUtil.equals(addDTO.getContractCategory(), "ymjgypmm"))) {
         contract.setExpirationDate(DateUtil.offsetDay(contract.getSignDate(),contract.getDeliveryCycle()));
      if (StrUtil.isEmpty(addDTO.getPartyA())) {
         BusinessCustomer bc = businessCustomerMapper.selectById(addDTO.getPartyAId());
         if (ObjUtil.isNotNull(bc)) {
            contract.setPartyA(bc.getCompanyName());
         }
         if (!StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb) && StrUtil.isEmpty(bc.getErpCompanyCode())
               && StrUtil.isEmpty(bc.getCreditCode())) {
            return R.failed("请完善客户ERP编码或组织机构代码");
         }
      }
      List<Contract> contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
      while (ArrayUtil.isNotEmpty(contracts.toArray())) {
         contract.setContractNo(ContractNumberGenerator.generateContractNumber());
         contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("1");
      contract.setBillingAmout(new BigDecimal("0"));
      contract.setErpPushFlag("0");
      contract.setNickName(SecurityUtils.getUser().getNickname());
      if (ObjUtil.isNotNull(addDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(addDTO.getSignDate(), addDTO.getDeliveryCycle()));
      }
      if (StrUtil.equals(addDTO.getContractCategory(), "water_house")) {
         if (!addDTO.getContractSubjectMatter().stream().allMatch(item -> StrUtil.equals(item.getMaterialCode(), "water_bill") ||
               StrUtil.equals(item.getMaterialCode(), "house_rental") || StrUtil.equals(item.getMaterialCode(), "electricity_bill"))) {
            return R.failed("请新增水/电代缴房屋租赁合同!");
         }
      } else {
         if (addDTO.getContractSubjectMatter().stream().anyMatch(item -> StrUtil.equals(item.getMaterialCode(), "water_bill") ||
               StrUtil.equals(item.getMaterialCode(), "house_rental") || StrUtil.equals(item.getMaterialCode(), "electricity_bill"))) {
            return R.failed("水电代缴、房屋租赁产品只能在水/电代缴房屋租赁合同!");
         }
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         Optional<ContractSubjectMatterAddDTO> maxDateObj = addDTO.getContractSubjectMatter().stream()
               .filter(item -> item.getPlannedDeliveryDate() != null) // 过滤掉日期为空的项,避免 NullPointerException
               .max(Comparator.comparing(ContractSubjectMatterAddDTO::getPlannedDeliveryDate));
         if (maxDateObj.isPresent()) {
            contract.setExpirationDate(maxDateObj.get().getPlannedDeliveryDate());
         }
      }
      if (CollUtil.isEmpty(addDTO.getContractSubjectMatter())) {
         return R.failed("标的物不能为空");
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         contract.setContractNo(generateSMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         contract.setContractNo(generateGYBContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         contract.setContractNo(generateYMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         contract.setContractNo(generateTFContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         contract.setContractNo(generateJXCContractNo());
      }
      if (StrUtil.isNotEmpty(contract.getContractCategory()) && (StrUtil.equals(contract.getContractCategory(), "ymjjgcl")
            || StrUtil.equals(contract.getContractCategory(), "ymjgypmm") || StrUtil.equals(contract.getContractCategory(), "ymjgkcpmm")
            || StrUtil.equals(contract.getContractCategory(), "ymjcg") || StrUtil.equals(contract.getContractCategory(), "tfgsgypmm")
            || StrUtil.equals(contract.getContractCategory(), "smjgypmm") || StrUtil.equals(contract.getContractCategory(), "jxcxsht"))
      ) {
         contract.setContractName(contract.getContractName() + contract.getContractNo());
      }
      baseMapper.insert(contract);
      if (ArrayUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
      if (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
         addDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            subjectMatter.setContractName(contract.getContractName());
            subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
@@ -99,7 +241,7 @@
            //水电类必须有初次表号
            if (StrUtil.isNotEmpty(contractSubjectMatterAddDTO.getMeterReadCode()) &&
                  ObjUtil.isNotNull(contractSubjectMatterAddDTO.getMeterReadNum())) {
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class,"id");
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class, "id");
               record.setContractId(contract.getId());
               record.setMatterId(subjectMatter.getId());
               record.setContractName(contract.getContractName());
@@ -109,16 +251,16 @@
               meterReadRecordMapper.insert(record);
            }
            if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && StrUtil.equals(addDTO.getContractCategory(), "ymjcg")
            &&ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate())&&ObjUtil.isNotNull(contract.getExpirationDate())
               &&DateUtil.compare(contract.getExpirationDate(),subjectMatter.getPlannedDeliveryDate())>0) {
                  contract.setExpirationDate(subjectMatter.getPlannedDeliveryDate());
                  baseMapper.updateById(contract);
                  && ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate()) && ObjUtil.isNotNull(contract.getExpirationDate())
                  && DateUtil.compare(contract.getExpirationDate(), subjectMatter.getPlannedDeliveryDate()) > 0) {
               contract.setExpirationDate(subjectMatter.getPlannedDeliveryDate());
               baseMapper.updateById(contract);
            }
         });
      }
      if (ArrayUtil.isNotEmpty(addDTO.getContractPaymentSchedule())) {
      if (CollUtil.isNotEmpty(addDTO.getContractPaymentSchedule())) {
         AtomicInteger index = new AtomicInteger(1);
         addDTO.getContractPaymentSchedule().stream().forEach(contractPaymentScheduleAddDTO -> {
            int currentIndex = index.getAndIncrement();
@@ -151,6 +293,10 @@
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("质保金")) {
               contract.setWarrantyScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         });
      }
@@ -165,34 +311,82 @@
      if (!StrUtil.equals(entity.getContractStatus() + "", "0")) {
         return R.failed("当前状态无法修改合同");
      }
      if (StrUtil.isEmpty(updateDTO.getPartyA())) {
         BusinessCustomer bc = businessCustomerMapper.selectById(updateDTO.getPartyAId());
         if (ObjUtil.isNotNull(bc)) {
            updateDTO.setPartyA(bc.getCompanyName());
         }
         if (StrUtil.isEmpty(bc.getErpCompanyCode()) || StrUtil.isEmpty(bc.getRegisterName()) ||
               StrUtil.isEmpty(bc.getBankName()) || StrUtil.isEmpty(bc.getBankAccount())) {
            return R.failed("请完善改客户数据后再添加合同");
         }
      }
      Contract contract = BeanUtil.copyProperties(updateDTO, Contract.class);
      contract.setContractNo(ContractNumberGenerator.generateContractNumber());
      contract.setBillingStatus("0");
      contract.setBillingStatus("1");
      contract.setErpPushFlag("0");
      contract.setPaidAmount(new BigDecimal("0"));
      List<Contract> contracts;
      contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
      while (ArrayUtil.isNotEmpty(contracts.toArray())) {
         contract.setContractNo(ContractNumberGenerator.generateContractNumber());
         contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
      contract.setBillingAmout(new BigDecimal("0"));
      contract.setNickName(SecurityUtils.getUser().getNickname());
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         contract.setContractNo(generateSMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         contract.setContractNo(generateGYBContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         contract.setContractNo(generateYMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         contract.setContractNo(generateTFContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         contract.setContractNo(generateJXCContractNo());
      }
      if (ObjUtil.isNotNull(updateDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(updateDTO.getSignDate(), updateDTO.getDeliveryCycle()));
      }
      if (StrUtil.equals(updateDTO.getContractCategory(), "water_house")) {
         if (!updateDTO.getContractSubjectMatter().stream().allMatch(item -> StrUtil.equals(item.getMaterialCode(), "water_bill") ||
               StrUtil.equals(item.getMaterialCode(), "house_rental") || StrUtil.equals(item.getMaterialCode(), "electricity_bill"))) {
            return R.failed("请新增水/电代缴房屋租赁合同!");
         }
      } else {
         if (updateDTO.getContractSubjectMatter().stream().anyMatch(item -> StrUtil.equals(item.getMaterialCode(), " ") ||
               StrUtil.equals(item.getMaterialCode(), "house_rental") || StrUtil.equals(item.getMaterialCode(), "electricity_bill"))) {
            return R.failed("水电代缴、房屋租赁产品只能在水/电代缴房屋租赁合同!");
         }
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         Optional<ContractSubjectMatterAddDTO> maxDateObj = updateDTO.getContractSubjectMatter().stream()
               .filter(item -> item.getPlannedDeliveryDate() != null) // 过滤掉日期为空的项,避免 NullPointerException
               .max(Comparator.comparing(ContractSubjectMatterAddDTO::getPlannedDeliveryDate));
         if (maxDateObj.isPresent()) {
            contract.setExpirationDate(maxDateObj.get().getPlannedDeliveryDate());
         }
      }
      baseMapper.updateById(contract);
      if (ArrayUtil.isNotEmpty(updateDTO.getContractSubjectMatter())) {
      if (CollUtil.isNotEmpty(updateDTO.getContractSubjectMatter())) {
         contractSubjectMatterMapper.delete(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId, contract.getId()));
         updateDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            subjectMatter.setContractName(contract.getContractName());
            subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
            contractSubjectMatterMapper.insert(subjectMatter);
            //水电类必须有初次表号
            if (StrUtil.isNotEmpty(contractSubjectMatterAddDTO.getMeterReadCode()) &&
                  ObjUtil.isNotNull(contractSubjectMatterAddDTO.getMeterReadNum())) {
               meterReadRecordMapper.delete(Wrappers.<MeterReadRecord>lambdaQuery().eq(MeterReadRecord::getContractId, contract.getId()));
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class,"id");
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class, "id");
               record.setContractId(contract.getId());
               record.setMatterId(subjectMatter.getId());
               record.setContractName(contract.getContractName());
@@ -204,7 +398,7 @@
         });
      }
      if (ArrayUtil.isNotEmpty(updateDTO.getContractPaymentSchedule())) {
      if (CollUtil.isNotEmpty(updateDTO.getContractPaymentSchedule())) {
         contractPaymentScheduleMapper.delete(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()));
         AtomicInteger index = new AtomicInteger(1);
@@ -229,6 +423,10 @@
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("质保金")) {
               contract.setWarrantyScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         });
      }
@@ -245,24 +443,197 @@
      List<ContractPaymentSchedule> paymentScheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()));
      detailVo.setContractPaymentSchedule(paymentScheduleList);
      BusinessCustomer a = businessCustomerMapper.selectById(contract.getPartyAId());
      if (ObjUtil.isNotNull(a)){
      if (ObjUtil.isNotNull(a)) {
         detailVo.setPartyAOrgCode(a.getCreditCode());
      }
      List<ContractOutBound> outBoundList = contractOutBoundMapper.selectList(Wrappers.<ContractOutBound>lambdaQuery()
            .eq(ContractOutBound::getContractId, id).orderByAsc(ContractOutBound::getOutBoundTime));
      if (CollUtil.isNotEmpty(outBoundList)) {
         detailVo.setContractOutBound(outBoundList);
      }
      List<ContractInvoice> invoiceList = contractInvoiceMapper.selectList(Wrappers.<ContractInvoice>lambdaQuery()
            .eq(ContractInvoice::getContractId, id).orderByAsc(ContractInvoice::getCreateTime));
      if (CollUtil.isNotEmpty(invoiceList)) {
         detailVo.setContractInvoice(invoiceList);
      }
      List<PaymentSlip> slipList = paymentSlipMapper.selectList(Wrappers.<PaymentSlip>lambdaQuery()
            .eq(PaymentSlip::getContractId, id).orderByAsc(PaymentSlip::getPaymentTime));
      if (CollUtil.isNotEmpty(slipList)) {
         detailVo.setPaymentSlip(slipList);
      }
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      ContractInvoiceBipVo bipVo = new ContractInvoiceBipVo();
      bipVo.setDjrq(DateUtil.today());
      R<SysDept> r = remoteDeptService.getById(contract.getPartyBId());
      if (r.isOk()) {
         bipVo.setKpzz(r.getData().getBipCode());
      }
      if (ObjUtil.isNotNull(customer)) {
         detailVo.setInvoiceType(customer.getInvoiceType());
         bipVo.setYwzz(r.getData().getBipCode());
      }
      R<SysDept> rDept = remoteDeptService.getById(SecurityUtils.getUser().getDeptId());
      if (rDept.isOk()) {
         bipVo.setBm(rDept.getData().getOrgCode());
         bipVo.setHsdy(rDept.getData().getOrgCode());
      }
      bipVo.setYwy(SecurityUtils.getUser().getNickname());
      bipVo.setPzzdr(SecurityUtils.getUser().getNickname());
      bipVo.setJylx("ZBYXGLXT");
      bipVo.setWldxlx("1");
      bipVo.setKh(customer.getCreditCode());
      bipVo.setBz("人民币");
      bipVo.setFjzs("1");
      bipVo.setSfzy("是");
      bipVo.setSfnbwl("是");
      bipVo.setSfjyjs("否");
      bipVo.setDjfx("1");
      detailVo.setBipVo(bipVo);
      return detailVo;
   }
   @Override
   public R startApproval(Long id) {
      Contract contract = baseMapper.selectById(id);
      //启动流程
      ProcessInstanceParamDto dto = new ProcessInstanceParamDto();
      Map<String, Object> map = BeanUtil.beanToMap(contract);
      dto.setParamMap(map);
      dto.setFlowName(FlowNameEnum.合同审批.name());
      R r1 = remoteFlowProcessService.startProcessInstance(dto);
      if (r1.getCode() == 1) {
         return R.failed("流程启动失败");
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      if (ObjUtil.isNull(customer)){
         return R.failed("客户查询异常");
      }
      R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
      if (!r.isOk()){
         return R.failed("信息查询异常");
      }
      SysDept comp = r.getData();
      //简易合同无法继续后续操作
      if (StrUtil.equals(contract.getContractCategory(), "simple")) {
         return R.failed("请补充标的物和收款阶段后再进行操作!");
      }
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery().
            eq(ContractSubjectMatter::getContractId,contract.getId()));
      //合同中心审核
      JSONObject requestApply = new JSONObject();
      requestApply.put("fd_selectionmethod", contract.getSelectionMethod());
      requestApply.put("fd_isrelated", contract.getIsRelated());
      requestApply.put("fd_bizId", contract.getId());
      requestApply.put("fd_remark", contract.getRemark());
      requestApply.put("fd_MainContent", "");
      requestApply.put("fd_settlementType", "00");
      requestApply.put("fd_applyType", "外销");
      if (CollUtil.isNotEmpty(subjectMatterList)) {
         requestApply.put("fd_contractSubject ", subjectMatterList.stream().map(item -> item.getMaterialName()).collect(Collectors.joining(",")));
      }
      requestApply.put("fd_docNumber", contract.getContractNo());
//      requestApply.put("fd_templateId", "19e39bb6c1edadbdb162c434274a8a18");
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         requestApply.put("fd_templateId", tempSMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         requestApply.put("fd_templateId", tempSGB);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         requestApply.put("fd_templateId", tempYMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         requestApply.put("fd_templateId", tempTFGS);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         requestApply.put("fd_templateId", tempJXC);
      }
      requestApply.put("fd_name", contract.getContractName());
      requestApply.put("fd_signDate", DateUtil.formatDate(contract.getSignDate()));
      requestApply.put("fd_endDate", DateUtil.formatDate(contract.getExpirationDate()));
      requestApply.put("fd_contractCreater", SecurityUtils.getUser().getNickname());
      requestApply.put("fd_currency", "人民币");
      requestApply.put("fd_ContractAmount", contract.getAmount());
      requestApply.put("fd_finAmount", contract.getAmount().divide(new BigDecimal("113"), 2, RoundingMode.HALF_UP)
            .multiply(new BigDecimal("87")));
      requestApply.put("fd_docStatus", "10");
      requestApply.put("fd_taxRates", 13);
      requestApply.put("fd_customerName", contract.getPartyA());
      requestApply.put("fd_systemSource", "非煤销售系统");
      requestApply.put("fd_type", "00");
      requestApply.put("fd_baozhangren", comp.getBaozhangren());
      requestApply.put("fd_summary",contract.getSummary());
      JSONArray signList = new JSONArray();
      JSONObject j = new JSONObject();
      j.put("fd_standing","甲");
      j.put("fd_Iden",customer.getCreditCode());
      j.put("fd_signMain","2");
      signList.add(j);
      JSONObject y = new JSONObject();
      y.put("fd_standing","乙");
      y.put("fd_Iden",comp.getOrgCode());
      y.put("fd_signMain","1");
      signList.add(y);
      requestApply.put("fd_signList", signList);
      if (StrUtil.isNotBlank(contract.getAttachmentUrl())) {
         JSONArray attList = new JSONArray();
         JSONObject att = new JSONObject();
         att.put("fd_attNum", "1");
         att.put("fd_attName", contract.getAttachmentName());
         att.put("fd_attType", contract.getAttachmentName().substring(contract.getAttachmentName().lastIndexOf('.')+1));
         att.put("fd_attQuality", "00");
         att.put("fd_attcontent", NetworkFileToBase64.convertNetworkFileToBase64("https://zbjt.res.jzeg.cn/api" + contract.getAttachmentUrl()));
         attList.add(att);
         requestApply.put("attList", attList);
      }
      if (CollUtil.isNotEmpty(subjectMatterList)){
         JSONArray materialList = new JSONArray();
         subjectMatterList.stream().forEach(subjectMatter->{
            JSONObject material = new JSONObject();
            material.put("fd_materiaCode", subjectMatter.getMaterialCode());
            material.put("fd_materiaName", subjectMatter.getMaterialInternalName());
            material.put("fd_specification", StrUtil.isNotBlank(subjectMatter.getSpecification())?subjectMatter.getSpecification():"");
            material.put("fd_figureNumber", "");
            material.put("fd_measureUnit", subjectMatter.getUnit());
            material.put("fd_number", subjectMatter.getQuantity());
            material.put("fd_price", subjectMatter.getUnitPrice());
            Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode,subjectMatter.getMaterialCode()).last("limit 1"));
            if (ObjUtil.isNotNull(product)){
               material.put("fd_rate", product.getTaxRate().toString());
            }
            material.put("fd_amount", subjectMatter.getUnitPrice().multiply(subjectMatter.getQuantity()));
            material.put("fd_requirements", "");
            material.put("fd_standard", "");
            material.put("fd_factory", "");
            material.put("fd_Deadlines", ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate())?subjectMatter.getPlannedDeliveryDate():"");
            material.put("fd_delivery", "");
            material.put("fd_des", "");
            materialList.add(material);
         });
         requestApply.put("materialList", materialList);
      }
      log.info("合同中心合同起草接口入参:{}", requestApply.toJSONString());
      String respApply = HttpUtil.post("https://oa.res.jzeg.cn/ekp/api/km-agreement/kmAgreementWebService/addSupplyContractApply", requestApply.toJSONString());
      log.info("合同中心合同起草接口回参:{}", respApply);
      JSONObject applyResp = JSONObject.parseObject(respApply);
      if (!applyResp.getString("code").equals("00")){
         return R.failed("合同中心推送审核失败,原因为:{}",applyResp.getString("msg"));
      }
      //启动流程-系统自带审批流
//      ProcessInstanceParamDto dto = new ProcessInstanceParamDto();
//      Map<String, Object> map = BeanUtil.beanToMap(contract);
//      dto.setParamMap(map);
//      dto.setFlowName(FlowNameEnum.合同审批.name());
//      R r1 = remoteFlowProcessService.startProcessInstance(dto);
//      if (r1.getCode() == 1) {
//         return R.failed("流程启动失败");
//      }
      //工业泵不用审核 直接通过
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         contract.setContractStatus(2);
         baseMapper.updateById(contract);
         return R.ok();
      }
      contract.setContractStatus(1);
      baseMapper.updateById(contract);
      return R.ok();
@@ -272,284 +643,541 @@
      Contract contract = baseMapper.selectById(id);
      contract.setContractStatus(2);
      baseMapper.updateById(contract);
      //水电房租 执行日
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, id));
      if (StrUtil.isNotEmpty(contract.getContractCategory()) && StrUtil.equals(contract.getContractCategory(), "water_house")) {
         List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
               .eq(ContractSubjectMatter::getContractId,id));
         handleWaterHouseCycle(contract,subjectMatterList);
         return;
      }
      //资金明细
      savePaymentConfirm(contract);
         if (ArrayUtil.isNotEmpty(subjectMatterList.toArray())) {
            for (ContractSubjectMatter contractSubjectMatter: subjectMatterList)  {
               if (StrUtil.equals(contract.getExecFrequency(), "1")) {
                  Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfWeek(contract.getEffectiveDate()),
                        DateUtil.endOfWeek(contract.getExpirationDate()), true)+1;
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getEffectiveDate()), contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetWeek(execDate0, i);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     if (DateUtil.isIn(execDatei,contract.getEffectiveDate(),contract.getExpirationDate())) {
                        contractExecDateMapper.insert(execDate);
                     }
                  }
               }
               if (StrUtil.equals(contract.getExecFrequency(), "2")) {
                  Long weeksTrue = DateUtil.betweenMonth(DateUtil.beginOfMonth(contract.getEffectiveDate()),
                        DateUtil.endOfMonth(contract.getExpirationDate()), true)+1;
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfMonth(contract.getEffectiveDate()), contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetMonth(execDate0, i);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     if (DateUtil.isIn(execDatei,contract.getEffectiveDate(),contract.getExpirationDate())) {
                        contractExecDateMapper.insert(execDate);
                     }
                  }
               }
               if (StrUtil.equals(contract.getExecFrequency(), "3")) {
                  Long weeksTrue = (DateUtil.betweenMonth(DateUtil.beginOfQuarter(contract.getEffectiveDate()),
                        DateUtil.endOfQuarter(contract.getExpirationDate()), true)+1)/3;
      //合同推送子公司
      pushSubCompany(contract,subjectMatterList);
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfQuarter(contract.getEffectiveDate()), contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetMonth(execDate0, i*3);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     if (DateUtil.isIn(execDatei,contract.getEffectiveDate(),contract.getExpirationDate())) {
                        contractExecDateMapper.insert(execDate);
                     }
                  }
               }
               if (StrUtil.equals(contract.getExecFrequency(), "4")) {
                  Date startDate = contract.getEffectiveDate();
                  Date endDate = contract.getExpirationDate();
                  Integer startMonth = DateUtil.month(contract.getEffectiveDate());
                  Integer endMonth = DateUtil.month(contract.getExpirationDate());
                  if (1<=startMonth&&startMonth<=6){
                     startDate = DateUtil.beginOfYear(startDate);
                  }
                  if (7<=startMonth&&startMonth<=12){
                     startDate = DateUtil.offsetMonth(DateUtil.beginOfYear(startDate),6);
                  }
                  if (1<=endMonth&&endMonth<=6){
                     endDate = DateUtil.offsetMonth(DateUtil.endOfYear(endDate),-6);
                  }
                  if (7<=endMonth&&endMonth<=12){
                     endDate = DateUtil.endOfYear(endDate);
                  }
                  Long weeksTrue = (DateUtil.betweenMonth(startDate,endDate, true)+1)/6;
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(startDate, contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetMonth(execDate0, i*6);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     if (DateUtil.isIn(execDatei,contract.getEffectiveDate(),contract.getExpirationDate())) {
                        contractExecDateMapper.insert(execDate);
                     }
                  }
               }
               if (StrUtil.equals(contract.getExecFrequency(), "5")) {
                  Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfYear(contract.getEffectiveDate()),
                        DateUtil.endOfYear(contract.getExpirationDate()), true)+1;
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfYear(contract.getEffectiveDate()), contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetWeek(execDate0, i);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     if (DateUtil.isIn(execDatei,contract.getEffectiveDate(),contract.getExpirationDate())) {
                        contractExecDateMapper.insert(execDate);
                     }
                  }
               }
      //合同中心推送
//      pusnContractCenter(contract,subjectMatterList);
            }
         }
      } else {
         ContractPaymentSchedule fitstSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId())
               .orderByAsc(ContractPaymentSchedule::getCreateTime).last("limit 1"));
         if (fitstSchedule.getStageName().equals("合同签订")) {
            //新增应收
            savePaymentConfirm(contract, fitstSchedule);
      contract.setNextScheduleName("发货前");
      baseMapper.updateById(contract);
   }
            //新增合同履约记录
            ContractPaymentScheduleProcess process = new ContractPaymentScheduleProcess();
            process.setContractId(contract.getId());
            process.setContractName(contract.getContractName());
            process.setScheduleId(fitstSchedule.getId());
            process.setScheduleName(fitstSchedule.getStageName());
            process.setProcessDate(contract.getSignDate());
            contractPaymentScheduleProcessMapper.insert(process);
//         //当前为合同最后阶段
//         PaymentConfirm newConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId,contract.getId())
//               .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
//         if (ObjUtil.isNotNull(newConfirm)&&newConfirm.getTotalAmount().compareTo(new BigDecimal("0"))>=0){
//            //有预付且超过应收 关闭合同状态
//            contract.setContractStatus(3);
//            baseMapper.updateById(contract);
//         }
         } else if (fitstSchedule.getStageName().equals("发货前")) {
            //更新合同下个阶段
            contract.setNextScheduleName("无");
            baseMapper.updateById(contract);
         } else if (fitstSchedule.getStageName().equals("货到签收")) {
            //更新合同下个阶段
            contract.setNextScheduleName("货到签收");
            baseMapper.updateById(contract);
         } else if (fitstSchedule.getStageName().equals("调试完成或验收")) {
            //更新合同下个阶段
            contract.setNextScheduleName("调试完成或验收");
            baseMapper.updateById(contract);
         } else {
            //新增应收
            savePaymentConfirm(contract, fitstSchedule);
         }
         //查询是否有后续阶段
         List<ContractPaymentSchedule> afterSchedule = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
               .eq(ContractPaymentSchedule::getContractId, fitstSchedule.getContractId())
               .gt(ContractPaymentSchedule::getStageOrder, fitstSchedule.getStageOrder())
               .orderByAsc(ContractPaymentSchedule::getCreateTime));
         if (ArrayUtil.isNotEmpty(afterSchedule.toArray()) && afterSchedule.size() == 1) {
            //最后阶段生效时间
            ContractPaymentSchedule endSchedule = afterSchedule.get(0);
            if (StrUtil.equals(endSchedule.getStageName(), "质保金")) {
//            endSchedule.setEffectiveEndDate(DateUtil.offsetDay(new Date(),endSchedule.getAgreedDays()));
//            contractPaymentScheduleMapper.updateById(endSchedule);
               //最后阶段应收
               PaymentConfirm newConfim = new PaymentConfirm();
               newConfim.setBusinessType(endSchedule.getStageName() + "应收");
               newConfim.setBusGuestId(contract.getPartyAId());
               newConfim.setBusGuestName(contract.getPartyA());
               newConfim.setContractId(contract.getId());
               newConfim.setContractName(contract.getContractName());
               newConfim.setContractNo(contract.getContractNo());
               newConfim.setScheduleId(endSchedule.getId());
               newConfim.setScheduleName(endSchedule.getStageName());
               newConfim.setConfirmTime(new Date());
               newConfim.setTransationAmount(endSchedule.getPlannedAmount());
               newConfim.setReceivableAmount(endSchedule.getPlannedAmount());
               PaymentConfirm lastNewConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
                     .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
               BigDecimal lastNewTotal = new BigDecimal("0");
               if (ObjUtil.isNotNull(lastNewConfirm)) {
                  lastNewTotal = lastNewConfirm.getTotalAmount();
               }
               newConfim.setTotalAmount(lastNewTotal.subtract(newConfim.getReceivableAmount()));
               if (endSchedule.getPaymentRatio().compareTo(new BigDecimal("0")) > 0) {
                  paymentConfirmMapper.insert(newConfim);
   private void pusnContractCenter(Contract contract,List<ContractSubjectMatter> subjectMatterList) {
      new Thread(() -> {
         try {
            JSONObject requestApply = new JSONObject();
            requestApply.put("fd_selectionmethod", "公开招标");
            requestApply.put("fd_isrelated", "是");
            requestApply.put("fd_bizId", contract.getId());
            requestApply.put("fd_remark", contract.getRemark());
            requestApply.put("fd_MainContent", "");
            requestApply.put("fd_settlementType", "00");
            requestApply.put("fd_applyType", "外销");
            requestApply.put("fd_contractSubject ", subjectMatterList.stream().map(item -> item.getMaterialName()).collect(Collectors.joining(",")));
            requestApply.put("fd_docNumber", contract.getContractNo());
            requestApply.put("fd_templateId", "19e39bb6c1edadbdb162c434274a8a18");
            requestApply.put("fd_name", contract.getContractName());
            requestApply.put("fd_signDate", DateUtil.formatDate(contract.getSignDate()));
            requestApply.put("fd_endDate", DateUtil.formatDate(contract.getExpirationDate()));
            requestApply.put("fd_contractCreater", contract.getNickName());
            requestApply.put("fd_currency", "人民币");
            requestApply.put("fd_ContractAmount", contract.getAmount());
            requestApply.put("fd_finAmount", contract.getAmount().divide(new BigDecimal("113"), 2, RoundingMode.HALF_UP)
                  .multiply(new BigDecimal("87")));
            requestApply.put("fd_docStatus", "20");
            requestApply.put("fd_taxRates", 13);
            requestApply.put("fd_customerName", contract.getPartyA());
            requestApply.put("fd_systemSource", "非煤销售系统");
            requestApply.put("fd_type", "00");
            log.info("合同中心合同起草接口入参:{}", requestApply.toJSONString());
            String respApply = HttpUtil.post("https://oatest.res.jzeg.cn/ekp/api/km-agreement/kmAgreementWebService/addSupplyContractApply", requestApply.toJSONString());
            log.info("合同中心合同起草接口回参:{}", respApply);
            JSONObject applyResp = JSONObject.parseObject(respApply);
            if (applyResp.getString("code").equals("00")) {
               JSONObject request = new JSONObject();
               request.put("fd_docNumber", contract.getContractNo());
               request.put("fd_singer", contract.getNickName());
               request.put("fd_signTime", DateUtil.formatDate(contract.getSignDate()));
               request.put("fd_linkPerson", "");
               request.put("fd_linkPhone", "");
               request.put("fd_address", contract.getSignPlace());
               request.put("fd_receivedTime", DateUtil.format(contract.getCreateTime(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("fd_receivedNum", 1);
               request.put("fd_effedate", DateUtil.formatDate(contract.getSignDate()));
               request.put("fd_enddate", DateUtil.formatDate(contract.getExpirationDate()));
               request.put("fd_reviewerNo", SecurityUtils.getUser().getNickname());
               request.put("fd_docStatus", "20");
               request.put("fd_templateId", "19e39bb6c1edadbdb162c434274a8a18");
               request.put("fd_attName", contract.getAttachmentName());
               request.put("fd_attcontent", NetworkFileToBase64.convertNetworkFileToBase64("https://zbjt.res.jzeg.cn/api" + contract.getAttachmentUrl()));
               log.info("合同中心同步合同接口入参:{}", request.toJSONString());
               String resp = HttpUtil.post("https://oatest.res.jzeg.cn/ekp/api/km-agreement/kmAgreementWebService/addContractReview", request.toJSONString());
               log.info("合同中心同步合同接口回参:{}", resp);
               JSONObject respJson = JSONObject.parseObject(resp);
               if (respJson.getString("code").equals("00")) {
                  contract.setCenterPushFlag("1");
                  baseMapper.updateById(contract);
               }
            }
            //更新合同下个阶段
            contract.setNextScheduleName(endSchedule.getStageName());
            baseMapper.updateById(contract);
         } catch (Exception e) {
            e.printStackTrace();
         }
         if (ArrayUtil.isNotEmpty(afterSchedule.toArray()) && afterSchedule.size() > 1) {
            //第一阶段生效时间
//         fitstSchedule.setEffectiveEndDate(DateUtil.offsetDay(contract.getSignDate(),fitstSchedule.getAgreedDays()));
//         contractPaymentScheduleMapper.updateById(fitstSchedule);
            //更新合同下个阶段
            contract.setNextScheduleName(afterSchedule.get(0).getStageName());
            baseMapper.updateById(contract);
      }).start();
   }
   private void pushSubCompany(Contract contract,List<ContractSubjectMatter> subjectMatterList) {
      //erp推送
      new Thread(() -> {
         try {
            Thread.sleep(500);
            JSONObject request = new JSONObject();
            BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
            request.put("contractNo", contract.getContractNo());
            request.put("partyA", contract.getPartyA());
            request.put("partyACode", customer.getErpCompanyCode());
            if (StrUtil.equals(contract.getPartyBId() + "", ymj) && StrUtil.isNotEmpty(ymjErp)) {
               request.put("customerCode", customer.getErpCompanyCode());
               request.put("currencyId", "RMB");
               request.put("signDate", DateUtil.format(contract.getSignDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("dateDeliver", DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("moneySum", contract.getAmount());
               request.put("signManner", "面签");
               request.put("salesman", "");
               if (CollUtil.isNotEmpty(subjectMatterList)) {
                  JSONArray subjectMatter = new JSONArray();
                  subjectMatterList.stream().forEach(contractSubjectMatter -> {
                     JSONObject subjectMatterItem = new JSONObject();
                     subjectMatterItem.put("itemNo", contractSubjectMatter.getMaterialCode());
                     subjectMatterItem.put("salePrice", contractSubjectMatter.getUnitPrice());
                     subjectMatterItem.put("qtyRequired", contractSubjectMatter.getQuantity());
                     subjectMatterItem.put("money", contractSubjectMatter.getQuantity().multiply(contractSubjectMatter.getUnitPrice()));
                     Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getCompId, contract.getCompId())
                           .eq(Product::getErpCode, contractSubjectMatter.getMaterialCode()));
                     if (ObjUtil.isNotNull(product)) {
                        subjectMatterItem.put("taxRate", new BigDecimal(product.getTaxRate()).divide(new BigDecimal("100")));
                     }
                     subjectMatterItem.put("dateDeliver", ObjUtil.isNotNull(contractSubjectMatter.getPlannedDeliveryDate()) ?
                           DateUtil.format(contractSubjectMatter.getPlannedDeliveryDate(), DatePattern.NORM_DATETIME_PATTERN) :
                           DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
                     subjectMatter.add(subjectMatterItem);
                  });
                  request.put("details", subjectMatter);
               }
               String token = "";
               if (redisTemplate.hasKey("YMJ_ERP_TOKEN")) {
                  token = (String) redisTemplate.opsForValue().get("YMJ_ERP_TOKEN");
               } else {
                  token = getYmjErpToken();
               }
               if (StrUtil.isEmpty(token)){
                  log.error("一煤机登录获取token失败");
                  return;
               }
               log.info("一煤机合同推送erp入参:{}", request.toJSONString());
               HttpResponse response = HttpRequest.post(ymjErp + "/api/contract-staging/v1/receive")
                     .header("token", token)       // 添加认证头
                     .header("Content-Type", "application/json")         // 设置内容类型
                     .body(request.toJSONString())                        // 设置请求体
                     .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
               log.info("一煤机合同推送erp回参:{}", response.body());
               //保存请求记录
               saveErpRequestRecord("ymj", request.toJSONString(), response.body());
               //更新合同erp推送标识
               contract.setErpPushFlag("1");
               baseMapper.updateById(contract);
            }
            if ((StrUtil.equals(contract.getPartyBId() + "", smj) ||
                  StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) && StrUtil.isNotEmpty(smjErp)) {
               request.put("customerCode", customer.getErpCompanyCode());
               request.put("currencyId", "RMB");
               request.put("signDate", DateUtil.format(contract.getSignDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("dateDeliver", DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("moneySum", contract.getAmount());
               request.put("signManner", "面签");
               request.put("salesman", "");
               request.put("tenantId", "tenant1");
               if (CollUtil.isNotEmpty(subjectMatterList)) {
                  JSONArray subjectMatter = new JSONArray();
                  subjectMatterList.stream().forEach(contractSubjectMatter -> {
                     JSONObject subjectMatterItem = new JSONObject();
                     subjectMatterItem.put("itemNo", contractSubjectMatter.getMaterialCode());
                     subjectMatterItem.put("salePrice", contractSubjectMatter.getUnitPrice());
                     subjectMatterItem.put("qtyRequired", contractSubjectMatter.getQuantity());
                     subjectMatterItem.put("money", contractSubjectMatter.getQuantity().multiply(contractSubjectMatter.getUnitPrice()));
                     Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getCompId, contract.getCompId())
                           .eq(Product::getErpCode, contractSubjectMatter.getMaterialCode()));
                     if (ObjUtil.isNotNull(product)) {
                        subjectMatterItem.put("taxRate", new BigDecimal(product.getTaxRate()).divide(new BigDecimal("100")));
                     }
                     subjectMatterItem.put("dateDeliver", ObjUtil.isNotNull(contractSubjectMatter.getPlannedDeliveryDate()) ?
                           DateUtil.format(contractSubjectMatter.getPlannedDeliveryDate(), DatePattern.NORM_DATETIME_PATTERN) :
                           DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
                     subjectMatter.add(subjectMatterItem);
                  });
                  request.put("details", subjectMatter);
               }
               String token = "";
               if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
                  token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
               } else {
                  token = getErpToken();
               }
               if (StrUtil.isEmpty(token)){
                  log.error("石煤机登录获取token失败");
                  return;
               }
               log.info("石煤机合同推送erp入参:{}", request.toJSONString());
               HttpResponse response = HttpRequest.post(smjErp + "/api/contract/v1/createWithDetails?tenantId=tenant1")
                     .header("token", token)       // 添加认证头
                     .header("Content-Type", "application/json")         // 设置内容类型
                     .body(request.toJSONString())                        // 设置请求体
                     .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
               log.info("石煤机合同推送erp回参:{}", response.body());
               //保存请求记录
               saveErpRequestRecord("smj", request.toJSONString(), response.body());
               //更新合同erp推送标识
               contract.setErpPushFlag("1");
               baseMapper.updateById(contract);
            }
            if (StrUtil.equals(contract.getPartyBId() + "", smjsc) && StrUtil.isNotEmpty(smjscErp)) {
               request.put("customerCode", customer.getErpCompanyCode());
               request.put("currencyId", "RMB");
               request.put("signDate", DateUtil.format(contract.getSignDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("dateDeliver", DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("moneySum", contract.getAmount());
               request.put("signManner", "面签");
               request.put("salesman", "");
               request.put("tenantId", "tenant2");
               if (CollUtil.isNotEmpty(subjectMatterList)) {
                  JSONArray subjectMatter = new JSONArray();
                  subjectMatterList.stream().forEach(contractSubjectMatter -> {
                     JSONObject subjectMatterItem = new JSONObject();
                     subjectMatterItem.put("itemNo", contractSubjectMatter.getMaterialCode());
                     subjectMatterItem.put("salePrice", contractSubjectMatter.getUnitPrice());
                     subjectMatterItem.put("qtyRequired", contractSubjectMatter.getQuantity());
                     subjectMatterItem.put("money", contractSubjectMatter.getQuantity().multiply(contractSubjectMatter.getUnitPrice()));
                     Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getCompId, contract.getCompId())
                           .eq(Product::getErpCode, contractSubjectMatter.getMaterialCode()));
                     if (ObjUtil.isNotNull(product)) {
                        subjectMatterItem.put("taxRate", new BigDecimal(product.getTaxRate()).divide(new BigDecimal("100")));
                     }
                     subjectMatterItem.put("dateDeliver", ObjUtil.isNotNull(contractSubjectMatter.getPlannedDeliveryDate()) ?
                           DateUtil.format(contractSubjectMatter.getPlannedDeliveryDate(), DatePattern.NORM_DATETIME_PATTERN) :
                           DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
                     subjectMatter.add(subjectMatterItem);
                  });
                  request.put("details", subjectMatter);
               }
               String token = "";
               if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
                  token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
               } else {
                  token = getErpToken();
               }
               if (StrUtil.isEmpty(token)){
                  log.error("石煤机登录获取token失败");
                  return;
               }
               log.info("石煤机随车分公司合同推送erp入参:{}", request.toJSONString());
               HttpResponse response = HttpRequest.post(smjErp + "/api/contract/v1/createWithDetails?tenantId=tenant2")
                     .header("token", token)       // 添加认证头
                     .header("Content-Type", "application/json")         // 设置内容类型
                     .body(request.toJSONString())                        // 设置请求体
                     .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
               log.info("石煤机随车分公司合同推送erp回参:{}", response.body());
               //保存请求记录
               saveErpRequestRecord("smj", request.toJSONString(), response.body());
               //更新合同erp推送标识
               contract.setErpPushFlag("1");
               baseMapper.updateById(contract);
            }
            if (StrUtil.equals(contract.getPartyBId() + "", smjzt) && StrUtil.isNotEmpty(smjztErp)) {
               request.put("customerCode", customer.getErpCompanyCode());
               request.put("currencyId", "RMB");
               request.put("signDate", DateUtil.format(contract.getSignDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("dateDeliver", DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
               request.put("moneySum", contract.getAmount());
               request.put("signManner", "面签");
               request.put("salesman", "");
               request.put("tenantId", "tenant3");
               if (CollUtil.isNotEmpty(subjectMatterList)) {
                  JSONArray subjectMatter = new JSONArray();
                  subjectMatterList.stream().forEach(contractSubjectMatter -> {
                     JSONObject subjectMatterItem = new JSONObject();
                     subjectMatterItem.put("itemNo", contractSubjectMatter.getMaterialCode());
                     subjectMatterItem.put("salePrice", contractSubjectMatter.getUnitPrice());
                     subjectMatterItem.put("qtyRequired", contractSubjectMatter.getQuantity());
                     subjectMatterItem.put("money", contractSubjectMatter.getQuantity().multiply(contractSubjectMatter.getUnitPrice()));
                     Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getCompId, contract.getCompId())
                           .eq(Product::getErpCode, contractSubjectMatter.getMaterialCode()));
                     if (ObjUtil.isNotNull(product)) {
                        subjectMatterItem.put("taxRate", new BigDecimal(product.getTaxRate()).divide(new BigDecimal("100")));
                     }
                     subjectMatterItem.put("dateDeliver", ObjUtil.isNotNull(contractSubjectMatter.getPlannedDeliveryDate()) ?
                           DateUtil.format(contractSubjectMatter.getPlannedDeliveryDate(), DatePattern.NORM_DATETIME_PATTERN) :
                           DateUtil.format(contract.getExpirationDate(), DatePattern.NORM_DATETIME_PATTERN));
                     subjectMatter.add(subjectMatterItem);
                  });
                  request.put("details", subjectMatter);
               }
               String token = "";
               if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
                  token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
               } else {
                  token = getErpToken();
               }
               if (StrUtil.isEmpty(token)){
                  log.error("石煤机登录获取token失败");
                  return;
               }
               log.info("石煤机钻探分公司合同推送erp入参:{}", request.toJSONString());
               HttpResponse response = HttpRequest.post(smjztErp + "/api/contract/v1/createWithDetails?tenantId=tenant3")
                     .header("token", token)       // 添加认证头
                     .header("Content-Type", "application/json")         // 设置内容类型
                     .body(request.toJSONString())                        // 设置请求体
                     .execute();                                         // 执行请求.post(ymjErp,request.toJSONString());
               log.info("石煤机钻探分公司合同推送erp回参:{}", response.body());
               //保存请求记录
               saveErpRequestRecord("smj", request.toJSONString(), response.body());
               //更新合同erp推送标识
               contract.setErpPushFlag("1");
               baseMapper.updateById(contract);
            }
            if (StrUtil.equals(contract.getPartyBId() + "", jxc) && StrUtil.isNotEmpty(jxcErp)) {
               log.info("机械厂合同推送erp入参:{}", request.toJSONString());
               String result = HttpUtil.post(jxcErp, request.toJSONString());
               log.info("机械厂合同推送erp回参:{}", result);
               //保存请求记录
               saveErpRequestRecord("jxc", request.toJSONString(), result);
               //更新合同erp推送标识
               contract.setErpPushFlag("1");
               baseMapper.updateById(contract);
            }
            if (StrUtil.equals(contract.getPartyBId() + "", tfgs) && StrUtil.isNotEmpty(tfgsErp)) {
               //通方公司通过系统录入
            }
         } catch (Exception e) {
            e.printStackTrace();
         }
         //只有当前合同签字阶段
//      if(ArrayUtil.isEmpty(afterSchedule.toArray())){
//         fitstSchedule.setEffectiveEndDate(DateUtil.offsetDay(contract.getSignDate(),fitstSchedule.getAgreedDays()));
//         contractPaymentScheduleMapper.updateById(fitstSchedule);
//      }
      }).start();
   }
   private String getErpToken() {
      JSONObject loginJson = new JSONObject();
      loginJson.put("username", "admin");
      loginJson.put("password", "Zimafold@2026");
      log.info("石煤机产品获取token入参:{}", loginJson.toJSONString());
      String loginResp = HttpUtil.post(smjErp + "/api/account/v1/login", loginJson.toJSONString());
      log.info("石煤机产品获取token回参:{}", loginResp);
      JSONObject respJson = JSONObject.parseObject(loginResp);
      if (respJson.getInteger("code") == 0) {
         JSONObject dataJson = JSONObject.parseObject(respJson.getString("data"));
         redisTemplate.opsForValue().set("SMJ_ERP_TOKEN",dataJson.getString("token"));
         log.info("石煤机erp token为:{}",dataJson.getString("token"));
         return dataJson.getString("token");
      }
      return "";
   }
   private String getYmjErpToken(){
      JSONObject loginJson = new JSONObject();
      loginJson.put("username", "admin");
      loginJson.put("password", "admin123");
      log.info("一煤机合同推送获取token入参:{}", loginJson.toJSONString());
      String loginResp = HttpUtil.post(ymjErp + "/api/account/v1/login", loginJson.toJSONString());
      log.info("一煤机合同推送获取token回参:{}", loginResp);
      JSONObject respJson = JSONObject.parseObject(loginResp);
      if (respJson.getInteger("code") == 0) {
         JSONObject dataJson = JSONObject.parseObject(respJson.getString("data"));
         redisTemplate.opsForValue().set("YMJ_ERP_TOKEN",dataJson.getString("token"));
         log.info("一煤机erp token为:{}",dataJson.getString("token"));
         return dataJson.getString("token");
      }
      return "";
   }
   private void saveScheduleProcess(Contract contract,ContractPaymentSchedule schedule) {
      //新增合同履约记录
      ContractPaymentScheduleProcess process = new ContractPaymentScheduleProcess();
      process.setContractId(contract.getId());
      process.setContractName(contract.getContractName());
      process.setScheduleId(schedule.getId());
      process.setScheduleName(schedule.getStageName());
      process.setProcessDate(contract.getSignDate());
      ContractPaymentScheduleProcess lastProcess = contractPaymentScheduleProcessMapper.selectOne(Wrappers.<ContractPaymentScheduleProcess>lambdaQuery()
            .eq(ContractPaymentScheduleProcess::getContractId, schedule.getContractId())
            .eq(ContractPaymentScheduleProcess::getScheduleId, schedule.getId()).last("limit 1"));
      if (ObjUtil.isNull(lastProcess)) {
         contractPaymentScheduleProcessMapper.insert(process);
      }
   }
   private void savePaymentConfirm(Contract contract, ContractPaymentSchedule schedule) {
      PaymentConfirm paymentConfirm = new PaymentConfirm();
      paymentConfirm.setBusinessType(schedule.getStageName() + "应收");
      paymentConfirm.setBusGuestId(contract.getPartyAId());
      paymentConfirm.setBusGuestName(contract.getPartyA());
      paymentConfirm.setContractId(contract.getId());
      paymentConfirm.setContractName(contract.getContractName());
      paymentConfirm.setContractNo(contract.getContractNo());
      paymentConfirm.setScheduleId(schedule.getId());
      paymentConfirm.setScheduleName(schedule.getStageName());
      paymentConfirm.setConfirmTime(new Date());
      paymentConfirm.setTransationAmount(schedule.getPlannedAmount());
      paymentConfirm.setReceivableAmount(schedule.getPlannedAmount());
      paymentConfirm.setTotalAmount(schedule.getPlannedAmount().multiply(new BigDecimal("-1")));
      PaymentConfirm lastNewConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
            .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
      BigDecimal lastNewTotal = new BigDecimal("0");
      if (ObjUtil.isNotNull(lastNewConfirm)) {
         lastNewTotal = lastNewConfirm.getTotalAmount();
      }
      paymentConfirm.setTotalAmount(lastNewTotal.subtract(paymentConfirm.getReceivableAmount()));
      if (schedule.getPaymentRatio().compareTo(new BigDecimal("0")) > 0) {
         paymentConfirmMapper.insert(paymentConfirm);
      }
      //客户付款完成合同
      List<Contract> customerCompleteContractList = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getPartyAId, contract.getPartyAId())
            .eq(Contract::getPartyBId, SecurityUtils.getUser().getCompId()).apply(" amount = paid_amount"));
      if (ArrayUtil.isNotEmpty(customerCompleteContractList)) {
         List<BigDecimal> outAmountList = new ArrayList<>();
         for (Contract completeContract : customerCompleteContractList
         ) {
            PaymentConfirm contractLastConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, completeContract.getId())
                  .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
            //查询客户付款完成合同中最后明细金额 有预收转入当前合同
            if (contractLastConfirm.getTotalAmount().compareTo(new BigDecimal("0")) > 0) {
               //新增完成付款合同 资金转出
               PaymentConfirm outConfirm = BeanUtil.copyProperties(contractLastConfirm, PaymentConfirm.class, "id", "transationAmount",
                     "advanceAmount", "receivableAmount", "overdueAmount", "totalAmount");
               outConfirm.setBusinessType("资金转出");
               outConfirm.setConfirmTime(new Date());
               outConfirm.setTransationAmount(contractLastConfirm.getTotalAmount());
               outConfirm.setTotalAmount(new BigDecimal("0"));
               paymentConfirmMapper.insert(outConfirm);
               outAmountList.add(outConfirm.getTransationAmount());
   private void handleWaterHouseCycle(Contract contract, List<ContractSubjectMatter> subjectMatterList) {
      if (CollUtil.isNotEmpty(subjectMatterList)) {
         for (ContractSubjectMatter contractSubjectMatter : subjectMatterList) {
            if (StrUtil.equals(contract.getExecFrequency(), "1")) {
               Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfWeek(contract.getEffectiveDate()),
                     DateUtil.endOfWeek(contract.getExpirationDate()), true) + 1;
               //循环日期
               Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getEffectiveDate()), contract.getExecDay());
               for (int i = 0; i < weeksTrue.intValue(); i++) {
                  Date execDatei = DateUtil.offsetWeek(execDate0, i);
                  ContractExecDate execDate = new ContractExecDate();
                  execDate.setContractId(contract.getId());
                  execDate.setMatterId(contractSubjectMatter.getId());
                  execDate.setExecDate(execDatei);
                  execDate.setGenFlag("0");
                  if (DateUtil.isIn(execDatei, contract.getEffectiveDate(), contract.getExpirationDate())) {
                     contractExecDateMapper.insert(execDate);
                  }
               }
            }
         }
         if (ArrayUtil.isNotEmpty(outAmountList.toArray())) {
            BigDecimal currentInSum = outAmountList.stream().reduce(BigDecimal.ZERO, BigDecimal::add);
            //新增当前合同 资金转入
            PaymentConfirm inConfirm = BeanUtil.copyProperties(paymentConfirm, PaymentConfirm.class, "id", "transationAmount",
                  "advanceAmount", "receivableAmount", "overdueAmount", "totalAmount");
            inConfirm.setBusinessType("资金转入");
            inConfirm.setConfirmTime(new Date());
            inConfirm.setTransationAmount(currentInSum);
            inConfirm.setTotalAmount(paymentConfirm.getTotalAmount().add(currentInSum));
            //更新当前阶段实际收款 和 收款状态
            schedule.setActualAmount(inConfirm.getTransationAmount());
            schedule.setPaymentStatus(2);
            if (inConfirm.getTotalAmount().compareTo(new BigDecimal("0")) > 0) {
               inConfirm.setAdvanceAmount(inConfirm.getTotalAmount());
            } else if (inConfirm.getTotalAmount().compareTo(new BigDecimal("0")) < 0) {
               inConfirm.setReceivableAmount(inConfirm.getTotalAmount().multiply(new BigDecimal("-1")));
               schedule.setActualAmount(currentInSum);
               schedule.setPaymentStatus(1);
            if (StrUtil.equals(contract.getExecFrequency(), "2")) {
               Long weeksTrue = DateUtil.betweenMonth(DateUtil.beginOfMonth(contract.getEffectiveDate()),
                     DateUtil.endOfMonth(contract.getExpirationDate()), true) + 1;
               //循环日期
               Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfMonth(contract.getEffectiveDate()), contract.getExecDay());
               for (int i = 0; i < weeksTrue.intValue(); i++) {
                  Date execDatei = DateUtil.offsetMonth(execDate0, i);
                  ContractExecDate execDate = new ContractExecDate();
                  execDate.setContractId(contract.getId());
                  execDate.setMatterId(contractSubjectMatter.getId());
                  execDate.setExecDate(execDatei);
                  execDate.setGenFlag("0");
                  if (DateUtil.isIn(execDatei, contract.getEffectiveDate(), contract.getExpirationDate())) {
                     contractExecDateMapper.insert(execDate);
                  }
               }
            }
            paymentConfirmMapper.insert(inConfirm);
            //更新当前阶段实际收款 和 收款状态
            contractPaymentScheduleMapper.updateById(schedule);
            if (StrUtil.equals(contract.getExecFrequency(), "3")) {
               Long weeksTrue = (DateUtil.betweenMonth(DateUtil.beginOfQuarter(contract.getEffectiveDate()),
                     DateUtil.endOfQuarter(contract.getExpirationDate()), true) + 1) / 3;
               //循环日期
               Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfQuarter(contract.getEffectiveDate()), contract.getExecDay());
               for (int i = 0; i < weeksTrue.intValue(); i++) {
                  Date execDatei = DateUtil.offsetMonth(execDate0, i * 3);
                  ContractExecDate execDate = new ContractExecDate();
                  execDate.setContractId(contract.getId());
                  execDate.setMatterId(contractSubjectMatter.getId());
                  execDate.setExecDate(execDatei);
                  execDate.setGenFlag("0");
                  if (DateUtil.isIn(execDatei, contract.getEffectiveDate(), contract.getExpirationDate())) {
                     contractExecDateMapper.insert(execDate);
                  }
               }
            }
            if (StrUtil.equals(contract.getExecFrequency(), "4")) {
               Date startDate = contract.getEffectiveDate();
               Date endDate = contract.getExpirationDate();
               Integer startMonth = DateUtil.month(contract.getEffectiveDate());
               Integer endMonth = DateUtil.month(contract.getExpirationDate());
               if (1 <= startMonth && startMonth <= 6) {
                  startDate = DateUtil.beginOfYear(startDate);
               }
               if (7 <= startMonth && startMonth <= 12) {
                  startDate = DateUtil.offsetMonth(DateUtil.beginOfYear(startDate), 6);
               }
               if (1 <= endMonth && endMonth <= 6) {
                  endDate = DateUtil.offsetMonth(DateUtil.endOfYear(endDate), -6);
               }
               if (7 <= endMonth && endMonth <= 12) {
                  endDate = DateUtil.endOfYear(endDate);
               }
               Long weeksTrue = (DateUtil.betweenMonth(startDate, endDate, true) + 1) / 6;
               //循环日期
               Date execDate0 = DateUtil.offsetDay(startDate, contract.getExecDay());
               for (int i = 0; i < weeksTrue.intValue(); i++) {
                  Date execDatei = DateUtil.offsetMonth(execDate0, i * 6);
                  ContractExecDate execDate = new ContractExecDate();
                  execDate.setContractId(contract.getId());
                  execDate.setMatterId(contractSubjectMatter.getId());
                  execDate.setExecDate(execDatei);
                  execDate.setGenFlag("0");
                  if (DateUtil.isIn(execDatei, contract.getEffectiveDate(), contract.getExpirationDate())) {
                     contractExecDateMapper.insert(execDate);
                  }
               }
            }
            if (StrUtil.equals(contract.getExecFrequency(), "5")) {
               Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfYear(contract.getEffectiveDate()),
                     DateUtil.endOfYear(contract.getExpirationDate()), true) + 1;
               //循环日期
               Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfYear(contract.getEffectiveDate()), contract.getExecDay());
               for (int i = 0; i < weeksTrue.intValue(); i++) {
                  Date execDatei = DateUtil.offsetWeek(execDate0, i);
                  ContractExecDate execDate = new ContractExecDate();
                  execDate.setContractId(contract.getId());
                  execDate.setMatterId(contractSubjectMatter.getId());
                  execDate.setExecDate(execDatei);
                  execDate.setGenFlag("0");
                  if (DateUtil.isIn(execDatei, contract.getEffectiveDate(), contract.getExpirationDate())) {
                     contractExecDateMapper.insert(execDate);
                  }
               }
            }
         }
      } else {
         paymentConfirmMapper.insert(paymentConfirm);
      }
   }
   private void saveErpRequestRecord(String ymj, String toJSONString, String result) {
      ErpRequestRecord record = new ErpRequestRecord();
      record.setErpName(ymj);
      record.setRequestParams(toJSONString);
      record.setResponseParams(result);
      erpRequestRecordMapper.insert(record);
   }
   private void savePaymentConfirm(Contract contract) {
      ContractPaymentSchedule fitstSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery()
            .eq(ContractPaymentSchedule::getContractId, contract.getId())
            .eq(ContractPaymentSchedule::getStageName,"合同签订")
            .last("limit 1"));
      fitstSchedule.setEffectiveEndDate(DateUtil.offsetDay(contract.getSignDate(),fitstSchedule.getAgreedDays()));
      contractPaymentScheduleMapper.updateById(fitstSchedule);
      //报错履约记录
      saveScheduleProcess(contract,fitstSchedule);
      //保存资金明细
      if (fitstSchedule.getPaymentRatio().compareTo(new BigDecimal("0"))>0) {
         //新增应收
         PaymentConfirm currentConfim = new PaymentConfirm();
         currentConfim.setBusinessType(fitstSchedule.getStageName() + "应收");
         currentConfim.setBusGuestId(contract.getPartyAId());
         currentConfim.setBusGuestName(contract.getPartyA());
         currentConfim.setContractId(contract.getId());
         currentConfim.setContractName(contract.getContractName());
         currentConfim.setContractNo(contract.getContractNo());
         currentConfim.setScheduleId(fitstSchedule.getId());
         currentConfim.setScheduleName(fitstSchedule.getStageName());
         currentConfim.setConfirmTime(contract.getSignDate());
         currentConfim.setTransationAmount(fitstSchedule.getPlannedAmount());
         currentConfim.setReceivableAmount(fitstSchedule.getPlannedAmount());
         PaymentConfirm lastConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
               .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
         if (ObjUtil.isNotNull(lastConfirm)) {
            currentConfim.setTotalAmount(lastConfirm.getTotalAmount().subtract(currentConfim.getTransationAmount()));
            if (contract.getContractNo().startsWith("ZB-")) {
               paymentConfirmMapper.insert(currentConfim);
            }
            return;
         }
         currentConfim.setTotalAmount(currentConfim.getTransationAmount().multiply(new BigDecimal("-1")));
         paymentConfirmMapper.insert(currentConfim);
         processService.handleBeforeRemain(currentConfim,contract);
      }
   }
   @Override
@@ -558,57 +1186,61 @@
            .lt(ContractPaymentSchedule::getEffectiveEndDate, DateUtil.today())
            .ne(ContractPaymentSchedule::getPaymentStatus, "2")
            .ne(ContractPaymentSchedule::getPaymentStatus, 3));
      if (ArrayUtil.isNotEmpty(scheduleList.toArray())) {
      if (CollUtil.isNotEmpty(scheduleList)) {
         scheduleList.stream().forEach(contractPaymentSchedule -> {
            Contract contract = baseMapper.selectById(contractPaymentSchedule.getContractId());
            //应收超期
            PaymentConfirm overdueConfirm = new PaymentConfirm();
            overdueConfirm.setBusinessType("应收超期");
            overdueConfirm.setBusGuestId(contract.getPartyAId());
            overdueConfirm.setBusGuestName(contract.getPartyA());
            overdueConfirm.setContractId(contract.getId());
            overdueConfirm.setContractName(contract.getContractName());
            overdueConfirm.setContractNo(contract.getContractNo());
            overdueConfirm.setConfirmTime(new Date());
            overdueConfirm.setScheduleId(contractPaymentSchedule.getId());
            overdueConfirm.setScheduleName(contractPaymentSchedule.getStageName());
            PaymentConfirm newLastConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
                  .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
            overdueConfirm.setTransationAmount(StrUtil.equals(contractPaymentSchedule.getPaymentStatus() + "", "0") ?
                  contractPaymentSchedule.getPlannedAmount() :
                  contractPaymentSchedule.getPlannedAmount().subtract(contractPaymentSchedule.getActualAmount()));
            overdueConfirm.setReceivableAmount(newLastConfirm.getTotalAmount().multiply(new BigDecimal("-1")));
            overdueConfirm.setOverdueAmount(overdueConfirm.getTransationAmount());
            overdueConfirm.setTotalAmount(newLastConfirm.getTotalAmount());
            overdueConfirm.setCompId(contract.getCompId());
            //判断当前阶段是否已生成上阶段应收超期
            PaymentConfirm oiverdueConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getScheduleId, contractPaymentSchedule.getId())
                  .eq(PaymentConfirm::getBusinessType, "应收超期"));
            if (ObjUtil.isNull(oiverdueConfirm) && overdueConfirm.getTransationAmount().compareTo(new BigDecimal("0")) > 0) {
               paymentConfirmMapper.insert(overdueConfirm);
            }
            //当前逾期
            CurrentOverdue currentOverdue = new CurrentOverdue();
            currentOverdue.setBusGuestId(contract.getPartyAId());
            currentOverdue.setBusGuestName(contract.getPartyA());
            currentOverdue.setContractId(contractPaymentSchedule.getContractId());
            currentOverdue.setContractName(contractPaymentSchedule.getContractName());
            currentOverdue.setScheduleId(contractPaymentSchedule.getId());
            currentOverdue.setScheduleName(contractPaymentSchedule.getStageName());
            currentOverdue.setCompId(contract.getCompId());
            currentOverdue.setContractExpirTime(contractPaymentSchedule.getEffectiveEndDate());
            currentOverdue.setReceivableAmount(StrUtil.equals(contractPaymentSchedule.getPaymentStatus() + "", "0") ?
                  contractPaymentSchedule.getPlannedAmount() : contractPaymentSchedule.getPlannedAmount().subtract(contractPaymentSchedule.getActualAmount()));
            currentOverdue.setOverdueDuration(BigDecimal.valueOf(DateUtil.betweenDay(contractPaymentSchedule.getEffectiveEndDate(), new Date(), true)));
            CurrentOverdue overdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getContractId, currentOverdue.getContractId())
                  .eq(CurrentOverdue::getScheduleId, currentOverdue.getScheduleId()).last("limit 1"));
            if (ObjUtil.isNull(overdue)) {
               if (currentOverdue.getReceivableAmount().compareTo(new BigDecimal("0")) > 0) {
                  currentOverdueMapper.insert(currentOverdue);
            if (ObjUtil.isNotNull(contract)) {
               //应收超期
               PaymentConfirm overdueConfirm = new PaymentConfirm();
               overdueConfirm.setBusinessType("应收超期");
               overdueConfirm.setBusGuestId(contract.getPartyAId());
               overdueConfirm.setBusGuestName(contract.getPartyA());
               overdueConfirm.setContractId(contract.getId());
               overdueConfirm.setContractName(contract.getContractName());
               overdueConfirm.setContractNo(contract.getContractNo());
               overdueConfirm.setConfirmTime(new Date());
               overdueConfirm.setScheduleId(contractPaymentSchedule.getId());
               overdueConfirm.setScheduleName(contractPaymentSchedule.getStageName());
               PaymentConfirm newLastConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
                     .orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
               if (ObjUtil.isNotNull(newLastConfirm)) {
                  overdueConfirm.setTransationAmount(StrUtil.equals(contractPaymentSchedule.getPaymentStatus() + "", "0") ?
                        contractPaymentSchedule.getPlannedAmount() :
                        contractPaymentSchedule.getPlannedAmount().subtract(contractPaymentSchedule.getActualAmount()));
                  overdueConfirm.setReceivableAmount(newLastConfirm.getTotalAmount().multiply(new BigDecimal("-1")));
                  overdueConfirm.setOverdueAmount(overdueConfirm.getTransationAmount());
                  overdueConfirm.setTotalAmount(newLastConfirm.getTotalAmount());
                  overdueConfirm.setCompId(contract.getCompId());
                  //判断当前阶段是否已生成上阶段应收超期
                  PaymentConfirm oiverdueConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getScheduleId, contractPaymentSchedule.getId())
                        .eq(PaymentConfirm::getBusinessType, "应收超期"));
                  if (ObjUtil.isNull(oiverdueConfirm) && overdueConfirm.getTransationAmount().compareTo(new BigDecimal("0")) > 0) {
                     paymentConfirmMapper.insert(overdueConfirm);
                  }
                  //当前逾期
                  CurrentOverdue currentOverdue = new CurrentOverdue();
                  currentOverdue.setBusGuestId(contract.getPartyAId());
                  currentOverdue.setBusGuestName(contract.getPartyA());
                  currentOverdue.setContractId(contractPaymentSchedule.getContractId());
                  currentOverdue.setContractName(contractPaymentSchedule.getContractName());
                  currentOverdue.setScheduleId(contractPaymentSchedule.getId());
                  currentOverdue.setScheduleName(contractPaymentSchedule.getStageName());
                  currentOverdue.setCompId(contract.getCompId());
                  currentOverdue.setContractExpirTime(contractPaymentSchedule.getEffectiveEndDate());
                  currentOverdue.setReceivableAmount(StrUtil.equals(contractPaymentSchedule.getPaymentStatus() + "", "0") ?
                        contractPaymentSchedule.getPlannedAmount() : contractPaymentSchedule.getPlannedAmount().subtract(contractPaymentSchedule.getActualAmount()));
                  currentOverdue.setOverdueDuration(BigDecimal.valueOf(DateUtil.betweenDay(contractPaymentSchedule.getEffectiveEndDate(), new Date(), true)));
                  CurrentOverdue overdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getContractId, currentOverdue.getContractId())
                        .eq(CurrentOverdue::getScheduleId, currentOverdue.getScheduleId()).last("limit 1"));
                  if (ObjUtil.isNull(overdue)) {
                     if (currentOverdue.getReceivableAmount().compareTo(new BigDecimal("0")) > 0) {
                        currentOverdueMapper.insert(currentOverdue);
                     }
                  } else {
                     overdue.setOverdueDuration(BigDecimal.valueOf(DateUtil.betweenDay(contractPaymentSchedule.getEffectiveEndDate(), new Date(), true)));
                     currentOverdueMapper.updateById(overdue);
                  }
               }
            } else {
               overdue.setOverdueDuration(BigDecimal.valueOf(DateUtil.betweenDay(contractPaymentSchedule.getEffectiveEndDate(), new Date(), true)));
               currentOverdueMapper.updateById(overdue);
            }
         });
      }
@@ -627,16 +1259,28 @@
   public R copyNewContract(Long id) {
      Contract oldContract = baseMapper.selectById(id);
      Contract newContract = BeanUtil.copyProperties(oldContract, Contract.class, "id", "createTime");
      newContract.setContractNo(ContractNumberGenerator.generateContractNumber());
      newContract.setOutBoundAmout(new BigDecimal("0"));
      newContract.setPaidAmount(new BigDecimal("0"));
      newContract.setBillingStatus("0");
      newContract.setBillingStatus("1");
      newContract.setErpPushFlag("0");
      newContract.setContractStatus(0);
      List<Contract> contracts;
      contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, newContract.getContractNo()));
      while (ArrayUtil.isNotEmpty(contracts.toArray())) {
         newContract.setContractNo(ContractNumberGenerator.generateContractNumber());
         contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, newContract.getContractNo()));
      newContract.setBillingAmout(new BigDecimal("0"));
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         newContract.setContractNo(generateSMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         newContract.setContractNo(generateGYBContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         newContract.setContractNo(generateYMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         newContract.setContractNo(generateTFContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         newContract.setContractNo(generateJXCContractNo());
      }
      baseMapper.insert(newContract);
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId, id));
@@ -697,7 +1341,7 @@
      map.put("items", items);
      //定制方
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      map.put("companyName", customer.getRegisterName());
      map.put("companyName", contract.getPartyA());
      map.put("legalPerson", customer.getLegalPerson());
      map.put("contactPhone", customer.getContactPhone());
      map.put("bankName", customer.getBankName());
@@ -750,8 +1394,8 @@
   @Override
   public R genCycleReceiced() {
      List<ContractExecDate> execDateList = contractExecDateMapper.selectList(Wrappers.<ContractExecDate>lambdaQuery()
            .le(ContractExecDate::getExecDate, DateUtil.today()).eq(ContractExecDate::getGenFlag,"0"));
      if (ArrayUtil.isNotEmpty(execDateList.toArray())) {
            .le(ContractExecDate::getExecDate, DateUtil.today()).eq(ContractExecDate::getGenFlag, "0"));
      if (CollUtil.isNotEmpty(execDateList)) {
         execDateList.stream().forEach(contractExecDate -> {
            Contract contract = baseMapper.selectById(contractExecDate.getContractId());
            ContractSubjectMatter subjectMatter = contractSubjectMatterMapper.selectOne(Wrappers.<ContractSubjectMatter>lambdaQuery()
@@ -760,16 +1404,17 @@
            //生成抄表单
            if (StrUtil.isNotEmpty(subjectMatter.getMeterReadCode()) &&
                  ObjUtil.isNotNull(subjectMatter.getMeterReadNum())) {
               MeterReadRecord record = BeanUtil.copyProperties(subjectMatter, MeterReadRecord.class, "id","meterReadNum");
               MeterReadRecord record = BeanUtil.copyProperties(subjectMatter, MeterReadRecord.class, "id", "meterReadNum");
               record.setContractName(contract.getContractName());
               record.setMatterId(subjectMatter.getId());
               record.setBusGuestId(contract.getPartyAId());
               record.setBusGuestName(contract.getPartyA());
               meterReadRecordMapper.insert(record);
            }else {
            } else {
               //创建收款节点
               //查询上次收款节点
               ContractPaymentSchedule lastSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery()
                     .eq(ContractPaymentSchedule::getContractId,contract.getId())
                     .eq(ContractPaymentSchedule::getContractId, contract.getId())
                     .orderByDesc(ContractPaymentSchedule::getCreateTime).last("limit 1"));
               ContractPaymentSchedule schedule = new ContractPaymentSchedule();
               schedule.setStageName("房租租赁缴费");
@@ -778,12 +1423,16 @@
               schedule.setPlannedAmount(subjectMatter.getUnitPrice().multiply(subjectMatter.getQuantity()));
               schedule.setEffectiveEndDate(contractExecDate.getExecDate());
               schedule.setStageOrder(1);
               if (ObjUtil.isNotNull(lastSchedule)){
                  schedule.setStageOrder(lastSchedule.getStageOrder()+1);
               if (ObjUtil.isNotNull(lastSchedule)) {
                  schedule.setStageOrder(lastSchedule.getStageOrder() + 1);
               }
               schedule.setPaymentStatus(0);
               schedule.setActualAmount(new BigDecimal("0"));
               schedule.setCompId(contract.getCompId());
               schedule.setSubjectMatterCode(subjectMatter.getMaterialCode());
               schedule.setSubjectMatterName(subjectMatter.getMaterialInternalName());
               schedule.setRemark(DateUtil.formatDate(contractExecDate.getExecDate()) + schedule.getStageName());
               schedule.setInvoiceFlag("0");
               contractPaymentScheduleMapper.insert(schedule);
               //房屋租赁生成应收
               PaymentConfirm confirm = new PaymentConfirm();
@@ -822,6 +1471,8 @@
            }
            contractExecDate.setGenFlag("1");
            contractExecDateMapper.updateById(contractExecDate);
            contract.setBillingStatus("2");
            baseMapper.updateById(contract);
         });
      }
      return R.ok();
@@ -857,8 +1508,8 @@
         item.put("zongzhong", contractSubjectMatter.getTotalWight());
         item.put("unitPrice", contractSubjectMatter.getUnitPrice());
         item.put("price", contractSubjectMatter.getTotalAmount());
         if (no.get().equals(Integer.valueOf(0))){
            item.put("deliveryCycle",contract.getDeliveryCycle());
         if (no.get().equals(Integer.valueOf(0))) {
            item.put("deliveryCycle", contract.getDeliveryCycle());
         }
         items.add(item);
         no.updateAndGet(v -> v + 1);
@@ -931,7 +1582,7 @@
      map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN));
      map.put("total", contract.getAmount());
      map.put("amountWords", Convert.digitToChinese(contract.getAmount()));
      map.put("deliveryCycle",contract.getDeliveryCycle());
      map.put("deliveryCycle", contract.getDeliveryCycle());
      //标的物
      List<Map<String, Object>> items = new ArrayList<>();
      AtomicReference<Integer> no = new AtomicReference<>(0);
@@ -1017,30 +1668,30 @@
      map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN));
      map.put("total", contract.getAmount());
      map.put("amountWords", Convert.digitToChinese(contract.getAmount()));
      map.put("environment",contract.getEnvironment());
      map.put("standard",contract.getStandard());
      map.put("useMonth",contract.getUseMonth());
      map.put("afterShipMonth",contract.getAfterShipMonth());
      map.put("shipMethod",contract.getShipMethod());
      map.put("shipAddress",contract.getShipAddress());
      map.put("packaging",contract.getPackaging());
      map.put("repairPeriod",contract.getRepairPeriod());
      map.put("repairBreachAmount",contract.getRepairBreachAmount());
      map.put("goodsShort",contract.getGoodsShort());
      map.put("goodsShortBreachAmount",contract.getGoodsShortBreachAmount());
      map.put("overdueBreachAmount",contract.getOverdueBreachAmount());
      map.put("terminateContract",contract.getTerminateContract());
      map.put("court",contract.getCourt());
      map.put("contractAttchment",contract.getContractAttchment());
      map.put("invoiceNotice",contract.getInvoiceNotice());
      map.put("city",contract.getCity());
      map.put("region",contract.getRegion());
      map.put("environment", contract.getEnvironment());
      map.put("standard", contract.getStandard());
      map.put("useMonth", contract.getUseMonth());
      map.put("afterShipMonth", contract.getAfterShipMonth());
      map.put("shipMethod", contract.getShipMethod());
      map.put("shipAddress", contract.getShipAddress());
      map.put("packaging", contract.getPackaging());
      map.put("repairPeriod", contract.getRepairPeriod());
      map.put("repairBreachAmount", contract.getRepairBreachAmount());
      map.put("goodsShort", contract.getGoodsShort());
      map.put("goodsShortBreachAmount", contract.getGoodsShortBreachAmount());
      map.put("overdueBreachAmount", contract.getOverdueBreachAmount());
      map.put("terminateContract", contract.getTerminateContract());
      map.put("court", contract.getCourt());
      map.put("contractAttchment", contract.getContractAttchment());
      map.put("invoiceNotice", contract.getInvoiceNotice());
      map.put("city", contract.getCity());
      map.put("region", contract.getRegion());
      //标的物
      List<Map<String, Object>> items = new ArrayList<>();
      AtomicReference<Integer> no = new AtomicReference<>(0);
      subjectMatterList.stream().forEach(contractSubjectMatter -> {
         Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode,contractSubjectMatter.getMaterialCode()).last("limit 1"));
         Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode, contractSubjectMatter.getMaterialCode()).last("limit 1"));
         Map<String, Object> item = new HashMap<>();
         item.put("no", no);
         item.put("materialName", contractSubjectMatter.getMaterialName());
@@ -1051,11 +1702,11 @@
         item.put("priceTax", contractSubjectMatter.getUnitPrice().multiply(contractSubjectMatter.getQuantity()).setScale(2, RoundingMode.HALF_UP));
         item.put("priceNoTax", contractSubjectMatter.getUnitPrice().multiply(contractSubjectMatter.getQuantity())
               .subtract(contractSubjectMatter.getUnitPrice().multiply(contractSubjectMatter.getQuantity())
                     .divide(new BigDecimal("100").add(new BigDecimal(product.getTaxRate())),2, RoundingMode.HALF_UP).multiply(new BigDecimal(product.getTaxRate())))
                     .divide(new BigDecimal("100").add(new BigDecimal(product.getTaxRate())), 2, RoundingMode.HALF_UP).multiply(new BigDecimal(product.getTaxRate())))
               .setScale(2, RoundingMode.HALF_UP));
         item.put("deliveryDate", DateUtil.formatDate(contractSubjectMatter.getPlannedDeliveryDate()));
         item.put("remarks", contractSubjectMatter.getRemarks());
         map.put("taxRate",product.getTaxRate());
         map.put("taxRate", product.getTaxRate());
         items.add(item);
         no.updateAndGet(v -> v + 1);
      });
@@ -1064,24 +1715,24 @@
      List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
            .eq(ContractPaymentSchedule::getContractId, id).orderByAsc(ContractPaymentSchedule::getCreateTime));
      scheduleList.stream().forEach(contractPaymentSchedule -> {
         if (contractPaymentSchedule.getStageName().equals("合同签订")){
            map.put("htqdbl",contractPaymentSchedule.getPaymentRatio());
            map.put("htqdje",contractPaymentSchedule.getPlannedAmount());
            map.put("htqdjr",contractPaymentSchedule.getAgreedDays());
         if (contractPaymentSchedule.getStageName().equals("合同签订")) {
            map.put("htqdbl", contractPaymentSchedule.getPaymentRatio());
            map.put("htqdje", contractPaymentSchedule.getPlannedAmount());
            map.put("htqdjr", contractPaymentSchedule.getAgreedDays());
         }
         if (contractPaymentSchedule.getStageName().equals("发货前")){
            map.put("fhqbl",contractPaymentSchedule.getPaymentRatio());
            map.put("fhqje",contractPaymentSchedule.getPlannedAmount());
         if (contractPaymentSchedule.getStageName().equals("发货前")) {
            map.put("fhqbl", contractPaymentSchedule.getPaymentRatio());
            map.put("fhqje", contractPaymentSchedule.getPlannedAmount());
         }
         if (contractPaymentSchedule.getStageName().equals("调试完成或验收")){
            map.put("ysbl",contractPaymentSchedule.getPaymentRatio());
            map.put("ysje",contractPaymentSchedule.getPlannedAmount());
            map.put("ysjr",contractPaymentSchedule.getAgreedDays());
         if (contractPaymentSchedule.getStageName().equals("调试完成或验收")) {
            map.put("ysbl", contractPaymentSchedule.getPaymentRatio());
            map.put("ysje", contractPaymentSchedule.getPlannedAmount());
            map.put("ysjr", contractPaymentSchedule.getAgreedDays());
         }
         if (contractPaymentSchedule.getStageName().equals("质保金")){
            map.put("zbjbl",contractPaymentSchedule.getPaymentRatio());
            map.put("zbjje",contractPaymentSchedule.getPlannedAmount());
            map.put("zbjjr",contractPaymentSchedule.getAgreedDays());
         if (contractPaymentSchedule.getStageName().equals("质保金")) {
            map.put("zbjbl", contractPaymentSchedule.getPaymentRatio());
            map.put("zbjje", contractPaymentSchedule.getPlannedAmount());
            map.put("zbjjr", contractPaymentSchedule.getAgreedDays());
         }
      });
      map.put("items", items);
@@ -1140,18 +1791,19 @@
   @Override
   public R delayOutApproval(DelayOutApprovalDTO dto) {
      Contract contract = baseMapper.selectById(dto.getContractId());
      ContractDelayOut delayOut = BeanUtil.copyProperties(dto,ContractDelayOut.class);
      ContractDelayOut delayOut = BeanUtil.copyProperties(dto, ContractDelayOut.class);
      delayOut.setApplyTime(new Date());
      delayOut.setApplyName(SecurityUtils.getUser().getUsername());
      delayOut.setDelayStatus("0");
      Map<String,Object> map = new HashMap<>();
      map.put("contractId",contract.getId());
      map.put("contractName",contract.getContractName());
      map.put("partyA",contract.getPartyA());
      map.put("partyB",contract.getPartyB());
      map.put("delayDay",dto.getDelayDay());
      map.put("applyName",SecurityUtils.getUser().getUsername());
      map.put("applyTime",DateUtil.format(delayOut.getApplyTime(),DatePattern.NORM_DATETIME_FORMAT));
      Map<String, Object> map = new HashMap<>();
      map.put("contractId", contract.getId());
      map.put("contractName", contract.getContractName());
      map.put("partyA", contract.getPartyA());
      map.put("partyB", contract.getPartyB());
      map.put("delayDay", dto.getDelayDay());
      map.put("contractNo", contract.getContractNo());
      map.put("applyName", SecurityUtils.getUser().getUsername());
      map.put("applyTime", DateUtil.format(delayOut.getApplyTime(), DatePattern.NORM_DATETIME_FORMAT));
      //启动流程
      ProcessInstanceParamDto paramDto = new ProcessInstanceParamDto();
      paramDto.setParamMap(map);
@@ -1166,13 +1818,1569 @@
   @Override
   public Page pageScope(Page page, ContracQueryDTO queryDTO) {
      return baseMapper.pageScope(page,queryDTO, DataScope.of("comp_id"));
      return baseMapper.pageScope(page, queryDTO, DataScope.of("comp_id"));
   }
   public static void main(String[] args) {
      System.out.println(DateUtil.beginOfQuarter(DateUtil.parseDate("2026-06-05")));
      System.out.println(DateUtil.endOfQuarter(DateUtil.parseDate("2026-09-30")));
      System.out.println(DateUtil.betweenMonth(DateUtil.beginOfQuarter(DateUtil.parseDate("2026-06-05")),
            DateUtil.endOfQuarter(DateUtil.parseDate("2026-09-30")),true));
   @Override
   public void exportContractTFGSGYPMMWord(Long id, HttpServletResponse response) {
      Contract contract = baseMapper.selectById(id);
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, id).orderByAsc(ContractSubjectMatter::getCreateTime));
      Map<String, Object> map = new HashMap<>();
      //合同基本信息
      map.put("partyA", contract.getPartyA());
      map.put("partyB", contract.getPartyB());
      map.put("contractNo", contract.getContractNo());
      map.put("signPlace", contract.getSignPlace());
      map.put("signDate", DateUtil.formatDate(contract.getSignDate()));
      map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN));
      map.put("total", contract.getAmount());
      map.put("amountWords", Convert.digitToChinese(contract.getAmount()));
      //标的物
      List<Map<String, Object>> items = new ArrayList<>();
      List<RowRenderData> dataList = new ArrayList<>();
      AtomicReference<Integer> no = new AtomicReference<>(0);
      subjectMatterList.stream().forEach(contractSubjectMatter -> {
         Map<String, Object> item = new HashMap<>();
         item.put("materialName", contractSubjectMatter.getMaterialName());
         item.put("guige", contractSubjectMatter.getSpecification());
         item.put("unit", contractSubjectMatter.getUnit());
         item.put("quantity", contractSubjectMatter.getQuantity());
         item.put("unitPrice", contractSubjectMatter.getUnitPrice());
         item.put("price", contractSubjectMatter.getTotalAmount());
         items.add(item);
         no.updateAndGet(v -> v + 1);
      });
      map.put("items", items);
      //定制方
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      map.put("companyName", customer.getRegisterName());
      map.put("legalPerson", customer.getLegalPerson());
      map.put("contactPhone", customer.getContactPhone());
      map.put("bankName", customer.getBankName());
      map.put("bankAccount", customer.getBankAccount());
      //承揽方
      R<SysDept> r = remoteDeptService.getById(contract.getPartyBId());
      SysDept dept = r.getData();
      map.put("orgName", dept.getOrgName());
      map.put("legalPerson1", StrUtil.isNotEmpty(dept.getLegalPerson()) ? dept.getLegalPerson() : "");
      map.put("entrustedAgent", StrUtil.isNotEmpty(dept.getLegalPerson()) ? "" : dept.getEntrustedAgent());
      map.put("orgContact", dept.getOrgContact());
      map.put("orgBank", dept.getOrgBank());
      map.put("orgBankAccount", dept.getOrgBankAccount());
      //生成文件名
      Long time = new Date().getTime();
      // 生成的word格式
      String formatSuffix = ".docx";
      // 拼接后的文件名
      String fileName = time + formatSuffix;//文件名  带后缀
      //导出word
      try {
         // 1. 加载模版
         // 假设模版在 resources/templates/template.docx
         ClassPathResource resource = new ClassPathResource("template/tfgs/tfgsgypmmht.docx");
         // 配置列表策略
         Configure config = Configure.builder()
               .bind("items", new LoopRowTableRenderPolicy()) // 将 items 绑定到行循环策略
               .build();
         // 2. 编译并渲染数据
         XWPFTemplate xwpfTemplate = XWPFTemplate.compile(resource.getInputStream(), config).render(map);
         // 3. 设置响应头
         response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
         response.setCharacterEncoding("utf-8");
         response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".docx");
         // 4. 写入输出流
         OutputStream out = response.getOutputStream();
         xwpfTemplate.write(out);
         out.flush();
         out.close();
         xwpfTemplate.close(); // 重要:关闭模版释放资源
      } catch (IOException e) {
         e.printStackTrace();
      }
   }
   @Override
   public R addContractSgb(ContractAddDTO addDTO) {
      Contract contractOld = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getDataId, addDTO.getDataId()).last("limit 1"));
      if (ObjUtil.isNotNull(contractOld)) {
         return R.failed("合同数据ID:{}已存在,不能新增重复数据", addDTO.getDataId());
      }
      if (CollUtil.isEmpty(addDTO.getContractSubjectMatter())) {
         return R.failed("请添加标的物");
      }
      if (CollUtil.isEmpty(addDTO.getContractPaymentSchedule())) {
         return R.failed("请添加付款阶段或付款阶段缺少");
      }
      if (!isValidPaymentStages(addDTO.getContractPaymentSchedule())) {
         return R.failed("付款阶段信息异常");
      }
      if (addDTO.getContractPaymentSchedule().stream().map(item -> item.getPaymentRatio()).reduce(BigDecimal.ZERO, BigDecimal::add)
            .compareTo(new BigDecimal("100.00")) != 0) {
         return R.failed("付款阶段比例异常");
      }
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setErpContractNo(contract.getContractNo());
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      contract.setContractStatus(2);
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("1");
      contract.setErpPushFlag("1");
      contract.setCenterPushFlag("0");
      contract.setBillingAmout(new BigDecimal("0"));
      BusinessCustomer bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery().eq(BusinessCustomer::getErpCompanyCode,
            addDTO.getPartyACode()).last("limit 1"));
      if (ObjUtil.isNull(bc)) {
         return R.failed("erp客户编码不存在");
      }
      contract.setPartyAId(bc.getId());
      contract.setPartyA(bc.getCompanyName());
      if (ObjUtil.isNotNull(addDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(addDTO.getSignDate(), addDTO.getDeliveryCycle()));
      }
      if (ObjUtil.isNotNull(contract.getSignDate()) && ObjUtil.isNotNull(contract.getExpirationDate())) {
         Long bd = DateUtil.betweenDay(contract.getExpirationDate(), contract.getSignDate(), true);
         contract.setDeliveryCycle(bd.intValue());
      }
      contract.setContractNo(generateGYBContractNo());
      if (!StrUtil.equals(addDTO.getContractCategory(), "water_house")) {
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         Optional<ContractSubjectMatterAddDTO> maxDateObj = addDTO.getContractSubjectMatter().stream()
               .filter(item -> item.getPlannedDeliveryDate() != null) // 过滤掉日期为空的项,避免 NullPointerException
               .max(Comparator.comparing(ContractSubjectMatterAddDTO::getPlannedDeliveryDate));
         if (maxDateObj.isPresent()) {
            contract.setExpirationDate(maxDateObj.get().getPlannedDeliveryDate());
         }
      }
      baseMapper.insert(contract);
      if (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
         addDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            if (StrUtil.isNotBlank(subjectMatter.getMaterialCode())){
               Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode,subjectMatter.getMaterialCode())
                     .last("limit 1"));
               if (ObjUtil.isNotNull(product)){
                  subjectMatter.setMaterialInternalName(product.getId()+"");
               }
               if (ObjUtil.isNull(product)){
                  product = new Product();
                  product.setParentId(2101559148831944705L);
                  product.setProductName(subjectMatter.getMaterialInternalName());
                  product.setErpCode(subjectMatter.getMaterialCode());
                  product.setProductType(subjectMatter.getSpecification());
                  product.setTaxCode("1090117040000000000");
                  product.setTaxClass("泵");
                  productMapper.insert(product);
                  subjectMatter.setMaterialInternalName(product.getId()+"");
               }
            }
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
            contractSubjectMatterMapper.insert(subjectMatter);
            //水电类必须有初次表号
            if (StrUtil.isNotEmpty(contractSubjectMatterAddDTO.getMeterReadCode()) &&
                  ObjUtil.isNotNull(contractSubjectMatterAddDTO.getMeterReadNum())) {
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class, "id");
               record.setContractId(contract.getId());
               record.setMatterId(subjectMatter.getId());
               record.setContractName(contract.getContractName());
               record.setBusGuestId(contract.getPartyAId());
               record.setBusGuestName(contract.getPartyA());
               record.setMeterReadTime(new Date());
               meterReadRecordMapper.insert(record);
            }
            if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && StrUtil.equals(addDTO.getContractCategory(), "ymjcg")
                  && ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate()) && ObjUtil.isNotNull(contract.getExpirationDate())
                  && DateUtil.compare(contract.getExpirationDate(), subjectMatter.getPlannedDeliveryDate()) > 0) {
               contract.setExpirationDate(subjectMatter.getPlannedDeliveryDate());
               baseMapper.updateById(contract);
            }
         });
      }
      if (CollUtil.isNotEmpty(addDTO.getContractPaymentSchedule())) {
         AtomicInteger index = new AtomicInteger(1);
         addDTO.getContractPaymentSchedule().stream().forEach(contractPaymentScheduleAddDTO -> {
            int currentIndex = index.getAndIncrement();
            ContractPaymentSchedule schedule = BeanUtil.copyProperties(contractPaymentScheduleAddDTO, ContractPaymentSchedule.class);
            if (contractPaymentScheduleAddDTO.getStageName().equals("合同签订")) {
               schedule.setEffectiveEndDate(DateUtil.offsetDay(contract.getSignDate(), contractPaymentScheduleAddDTO.getAgreedDays()));
            }
            if (ObjUtil.isNotNull(schedule.getEffectiveDate())) {
               if (schedule.getEffectiveDate().before(DateUtil.date())) {
                  schedule.setFulfillmentStatus(1);
               } else {
                  schedule.setFulfillmentStatus(0);
               }
            }
            if (contractPaymentScheduleAddDTO.getPaymentRatio().compareTo(new BigDecimal("0")) > 0) {
               schedule.setPaymentStatus(0);
            } else {
               schedule.setPaymentStatus(3);
            }
            schedule.setContractId(contract.getId());
            schedule.setContractName(contract.getContractName());
            schedule.setPlannedAmount(contract.getAmount().multiply(schedule.getPaymentRatio().divide(new BigDecimal("100"))));
            schedule.setStageOrder(currentIndex);
            contractPaymentScheduleMapper.insert(schedule);
            if (contractPaymentScheduleAddDTO.getStageName().equals("货到签收")) {
               contract.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("调试完成或验收")) {
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         });
      }
      //推送合同中心
//      pushCenter(contract.getId());
      return R.ok(contract.getContractNo());
   }
   @Override
   public R updateContractSgb(ContractUpdateDTO updateDTO) {
      if (CollUtil.isEmpty(updateDTO.getContractSubjectMatter())) {
         return R.failed("请添加标的物");
      }
      if (CollUtil.isEmpty(updateDTO.getContractPaymentSchedule())) {
         return R.failed("请添加付款阶段或付款阶段缺少");
      }
      if (!isValidPaymentStages(updateDTO.getContractPaymentSchedule())) {
         return R.failed("付款阶段信息异常");
      }
      if (updateDTO.getContractPaymentSchedule().stream().map(item -> item.getPaymentRatio()).reduce(BigDecimal.ZERO, BigDecimal::add)
            .compareTo(new BigDecimal("100.00")) != 0) {
         return R.failed("付款阶段比例异常");
      }
      Contract contractOld = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getDataId, updateDTO.getDataId()).last("limit 1"));
      if (ObjUtil.isNull(contractOld)) {
         return R.failed("合同数据ID:{}不存在,请先新增后再修改", updateDTO.getDataId());
      }
      Contract contract = BeanUtil.copyProperties(updateDTO, Contract.class);
      contract.setId(contractOld.getId());
      if (ObjUtil.isNotNull(updateDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(updateDTO.getSignDate(), updateDTO.getDeliveryCycle()));
      }
      if (!StrUtil.equals(updateDTO.getContractCategory(), "water_house")) {
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         Optional<ContractSubjectMatterAddDTO> maxDateObj = updateDTO.getContractSubjectMatter().stream()
               .filter(item -> item.getPlannedDeliveryDate() != null) // 过滤掉日期为空的项,避免 NullPointerException
               .max(Comparator.comparing(ContractSubjectMatterAddDTO::getPlannedDeliveryDate));
         if (maxDateObj.isPresent()) {
            contract.setExpirationDate(maxDateObj.get().getPlannedDeliveryDate());
         }
      }
      baseMapper.updateById(contract);
      if (CollUtil.isNotEmpty(updateDTO.getContractSubjectMatter())) {
         contractSubjectMatterMapper.delete(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId, contract.getId()));
         updateDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            contractSubjectMatterMapper.insert(subjectMatter);
            //水电类必须有初次表号
            if (StrUtil.isNotEmpty(contractSubjectMatterAddDTO.getMeterReadCode()) &&
                  ObjUtil.isNotNull(contractSubjectMatterAddDTO.getMeterReadNum())) {
               meterReadRecordMapper.delete(Wrappers.<MeterReadRecord>lambdaQuery().eq(MeterReadRecord::getContractId, contract.getId()));
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class, "id");
               record.setContractId(contract.getId());
               record.setMatterId(subjectMatter.getId());
               record.setContractName(contract.getContractName());
               record.setBusGuestId(contract.getPartyAId());
               record.setBusGuestName(contract.getPartyA());
               record.setMeterReadTime(new Date());
               meterReadRecordMapper.insert(record);
            }
         });
      }
      if (CollUtil.isNotEmpty(updateDTO.getContractPaymentSchedule())) {
         contractPaymentScheduleMapper.delete(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()));
         AtomicInteger index = new AtomicInteger(1);
         updateDTO.getContractPaymentSchedule().stream().forEach(contractPaymentScheduleAddDTO -> {
            int currentIndex = index.getAndIncrement();
            ContractPaymentSchedule schedule = BeanUtil.copyProperties(contractPaymentScheduleAddDTO, ContractPaymentSchedule.class);
            schedule.setContractId(contract.getId());
            schedule.setContractName(contract.getContractName());
            schedule.setPlannedAmount(contract.getAmount().multiply(schedule.getPaymentRatio().divide(new BigDecimal("100"))));
            schedule.setStageOrder(currentIndex);
            if (contractPaymentScheduleAddDTO.getPaymentRatio().compareTo(new BigDecimal("0")) > 0) {
               schedule.setPaymentStatus(0);
            } else {
               schedule.setPaymentStatus(3);
            }
            contractPaymentScheduleMapper.insert(schedule);
            if (contractPaymentScheduleAddDTO.getStageName().equals("货到签收")) {
               contract.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("调试完成或验收")) {
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         });
      }
      return R.ok();
   }
   // 定义标准的五个阶段
   private static final Set<String> VALID_STAGES = new HashSet<>(Arrays.asList(
         "合同签订",
         "发货前",
         "货到签收",
         "调试完成或验收",
         "质保金"
   ));
   /**
    * 判断付款阶段列表是否符合标准
    *
    * @param scheduleList 付款阶段列表
    * @return true 如果包含且仅包含标准的五个阶段,false 否则
    */
   public static boolean isValidPaymentStages(List<ContractPaymentScheduleAddDTO> scheduleList) {
      if (scheduleList == null || scheduleList.isEmpty()) {
         return false;
      }
      // 1. 提取所有非空的 stageName
      List<String> actualStages = scheduleList.stream()
            .map(ContractPaymentScheduleAddDTO::getStageName)
            .filter(stage -> stage != null && !stage.trim().isEmpty())
            .map(String::trim)
            .collect(Collectors.toList());
      // 2. 基本数量检查:必须正好是5个
      if (actualStages.size() != VALID_STAGES.size()) {
         return false;
      }
      // 3. 内容检查:所有实际阶段都必须在标准集合中
      // 使用 Set 去重后比较,防止列表中有重复阶段但总数凑够5个的情况
      Set<String> actualStageSet = new HashSet<>(actualStages);
      // 检查实际集合大小是否也为5(确保无重复)且包含于标准集合
      return VALID_STAGES.equals(actualStageSet);
   }
   /**
    * 生成格式为: yyyyMMdd + 4位序列号 (例如: 20260629000001)
    */
   public String generateSMJContractNo() {
      // 1. 获取当前日期字符串
      String dateStr = DateUtil.format(new Date(), "yyyyMMdd");
      // 2. 构建 Redis Key,按天隔离,例如: order:no:20260629
      String key = "ZB-SMJ:" + dateStr;
      // 3. Redis 原子递增,设置过期时间为2天(防止Key堆积,同时覆盖跨天边界情况)
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      redisTemplate.expire(key, 1, java.util.concurrent.TimeUnit.DAYS);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return "ZB-SMJ-" + dateStr + seqStr;
   }
   public String generateYMJContractNo() {
      // 1. 获取当前日期字符串
      String dateStr = DateUtil.format(new Date(), "yyyyMMdd");
      // 2. 构建 Redis Key,按天隔离,例如: order:no:20260629
      String key = "ZB-YMJ:" + dateStr;
      // 3. Redis 原子递增,设置过期时间为2天(防止Key堆积,同时覆盖跨天边界情况)
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      redisTemplate.expire(key, 1, java.util.concurrent.TimeUnit.DAYS);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return "ZB-YMJ-" + dateStr + seqStr;
   }
   public String generateJXCContractNo() {
      // 1. 获取当前日期字符串
      String dateStr = DateUtil.format(new Date(), "yyyyMMdd");
      // 2. 构建 Redis Key,按天隔离,例如: order:no:20260629
      String key = "ZB-JXC:" + dateStr;
      // 3. Redis 原子递增,设置过期时间为2天(防止Key堆积,同时覆盖跨天边界情况)
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      redisTemplate.expire(key, 1, java.util.concurrent.TimeUnit.DAYS);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return "ZB-JXC-" + dateStr + seqStr;
   }
   public String generateTFContractNo() {
      // 1. 获取当前日期字符串
      String dateStr = DateUtil.format(new Date(), "yyyyMMdd");
      // 2. 构建 Redis Key,按天隔离,例如: order:no:20260629
      String key = "ZB-TF:" + dateStr;
      // 3. Redis 原子递增,设置过期时间为2天(防止Key堆积,同时覆盖跨天边界情况)
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      redisTemplate.expire(key, 1, java.util.concurrent.TimeUnit.DAYS);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return "ZB-TF-" + dateStr + seqStr;
   }
   public String generateGYBContractNo() {
      // 1. 获取当前日期字符串
      String dateStr = DateUtil.format(new Date(), "yyyyMMdd");
      // 2. 构建 Redis Key,按天隔离,例如: order:no:20260629
      String key = "ZB-GYB:" + dateStr;
      // 3. Redis 原子递增,设置过期时间为2天(防止Key堆积,同时覆盖跨天边界情况)
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      redisTemplate.expire(key, 1, java.util.concurrent.TimeUnit.DAYS);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return "ZB-GYB-" + dateStr + seqStr;
   }
   @Override
   public R abortContractSgb(String dataId) {
      Contract contractOld = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getDataId, dataId).last("limit 1"));
      if (ObjUtil.isNull(contractOld)) {
         return R.failed("合同数据ID:{}不存在,请先新增后再操作", dataId);
      }
      contractOld.setContractStatus(4);
      baseMapper.updateById(contractOld);
      return R.ok();
   }
   @Override
   public R delContractSgb(String dataId) {
      Contract contractOld = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getDataId, dataId).last("limit 1"));
      if (ObjUtil.isNull(contractOld)) {
         return R.failed("合同数据ID:{}不存在,请先新增后再操作", dataId);
      }
      contractPaymentScheduleMapper.delete(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contractOld.getId()));
      contractSubjectMatterMapper.delete(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId, contractOld.getId()));
      paymentConfirmMapper.delete(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contractOld.getId()));
      baseMapper.deleteById(contractOld);
      return R.ok();
   }
   @Override
   public Page fourAssociation(Page page, ContractQueryDTO queryDTO) {
      Page<FourAssociationPageVo> page1 = baseMapper.fourAssociation(page, queryDTO, DataScope.of("comp_id"));
      if (CollUtil.isNotEmpty(page1.getRecords())) {
         page1.getRecords().stream().forEach(fourAssociationPageVo -> {
            List<PaymentSlip> slips = paymentSlipMapper.selectList(Wrappers.<PaymentSlip>lambdaQuery().eq(PaymentSlip::getContractId, fourAssociationPageVo.getId())
                  .orderByAsc(PaymentSlip::getPaymentTime));
            if (CollUtil.isNotEmpty(slips)) {
               fourAssociationPageVo.setSlipVoList(BeanUtil.copyToList(slips, ContractSlipVo.class));
            }
            List<ContractInvoice> invoices = contractInvoiceMapper.selectList(Wrappers.<ContractInvoice>lambdaQuery().eq(ContractInvoice::getContractId, fourAssociationPageVo.getId())
                  .orderByAsc(ContractInvoice::getInvoiceTime));
            if (CollUtil.isNotEmpty(invoices)) {
               fourAssociationPageVo.setInvoiceVoList(BeanUtil.copyToList(invoices, ContractInvoiceVo.class));
            }
            if (fourAssociationPageVo.getAmount().compareTo(fourAssociationPageVo.getPaidAmount()) == 0 &&
                  fourAssociationPageVo.getAmount().compareTo(fourAssociationPageVo.getBillingAmout()) == 0 &&
                  CollUtil.isNotEmpty(slips) && CollUtil.isNotEmpty(invoices)
            ) {
               fourAssociationPageVo.setAssociation("已完成");
            }
         });
      }
      return page1;
   }
   @Override
   public void exportContractSMJGYPMMWord(Long id, HttpServletResponse response) {
      Contract contract = baseMapper.selectById(id);
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, id).orderByAsc(ContractSubjectMatter::getCreateTime));
      Map<String, Object> map = new HashMap<>();
      //合同基本信息
      map.put("partyA", contract.getPartyA());
      map.put("partyB", contract.getPartyB());
      map.put("contractNo", contract.getContractNo());
      map.put("signPlace", contract.getSignPlace());
      map.put("signDate", DateUtil.formatDate(contract.getSignDate()));
      map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN));
      map.put("total", contract.getAmount());
      map.put("totalNoTax", contract.getAmount().divide(new BigDecimal("100").add(new BigDecimal("13")), 2, RoundingMode.HALF_UP)
            .multiply(new BigDecimal("87")));
      map.put("amountWords", Convert.digitToChinese(contract.getAmount()));
      //标的物
      List<Map<String, Object>> items = new ArrayList<>();
      subjectMatterList.stream().forEach(contractSubjectMatter -> {
         Map<String, Object> item = new HashMap<>();
         item.put("materialName", contractSubjectMatter.getMaterialName());
         item.put("guige", contractSubjectMatter.getSpecification());
         item.put("unit", contractSubjectMatter.getUnit());
         item.put("quantity", contractSubjectMatter.getQuantity());
         item.put("unitPrice", contractSubjectMatter.getUnitPrice());
         item.put("price", contractSubjectMatter.getTotalAmount());
         item.put("remarks", contractSubjectMatter.getRemarks());
         items.add(item);
      });
      map.put("items", items);
      //定制方
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      map.put("companyName", customer.getRegisterName());
      map.put("legalPerson", customer.getLegalPerson());
      map.put("contactPhone", customer.getContactPhone());
      map.put("bankName", customer.getBankName());
      map.put("bankAccount", customer.getBankAccount());
      //承揽方
      R<SysDept> r = remoteDeptService.getById(contract.getPartyBId());
      SysDept dept = r.getData();
      map.put("orgName", dept.getOrgName());
      map.put("legalPerson1", StrUtil.isNotEmpty(dept.getLegalPerson()) ? dept.getLegalPerson() : "");
      map.put("entrustedAgent", StrUtil.isNotEmpty(dept.getLegalPerson()) ? "" : dept.getEntrustedAgent());
      map.put("orgContact", dept.getOrgContact());
      map.put("orgBank", dept.getOrgBank());
      map.put("orgBankAccount", dept.getOrgBankAccount());
      //生成文件名
      Long time = new Date().getTime();
      // 生成的word格式
      String formatSuffix = ".docx";
      // 拼接后的文件名
      String fileName = time + formatSuffix;//文件名  带后缀
      //导出word
      try {
         // 1. 加载模版
         // 假设模版在 resources/templates/template.docx
         ClassPathResource resource = new ClassPathResource("template/smj/smjgypmmht.docx");
         // 配置列表策略
         Configure config = Configure.builder()
               .bind("items", new LoopRowTableRenderPolicy()) // 将 items 绑定到行循环策略
               .build();
         // 2. 编译并渲染数据
         XWPFTemplate xwpfTemplate = XWPFTemplate.compile(resource.getInputStream(), config).render(map);
         // 3. 设置响应头
         response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
         response.setCharacterEncoding("utf-8");
         response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".docx");
         // 4. 写入输出流
         OutputStream out = response.getOutputStream();
         xwpfTemplate.write(out);
         out.flush();
         out.close();
         xwpfTemplate.close(); // 重要:关闭模版释放资源
      } catch (IOException e) {
         e.printStackTrace();
      }
   }
   @Override
   public void exportContractJXCXSWord(Long id, HttpServletResponse response) {
      Contract contract = baseMapper.selectById(id);
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, id).orderByAsc(ContractSubjectMatter::getCreateTime));
      List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
            .eq(ContractPaymentSchedule::getContractId, id).orderByAsc(ContractPaymentSchedule::getCreateTime));
      Map<String, Object> map = new HashMap<>();
      //合同基本信息
      map.put("partyA", contract.getPartyA());
      map.put("partyB", contract.getPartyB());
      map.put("contractNo", contract.getContractNo());
      map.put("signPlace", contract.getSignPlace());
      map.put("signDate", DateUtil.formatDate(contract.getSignDate()));
      map.put("signDateYMD", DateUtil.format(contract.getSignDate(), DatePattern.CHINESE_DATE_PATTERN));
      map.put("total", contract.getAmount());
      map.put("amountWords", Convert.digitToChinese(contract.getAmount()));
      //正文
      map.put("standard", contract.getStandard());
      map.put("useMonth", contract.getUseMonth());
      map.put("afterShipMonth", contract.getAfterShipMonth());
      map.put("deliveryCycle", contract.getDeliveryCycle());
      map.put("advancePayment", contract.getAdvancePayment() + "%");
      map.put("inspectDay", contract.getInspectDay());
      map.put("acceptDay", contract.getAcceptDay());
      map.put("delayAcceptDay", contract.getDelayAcceptDay());
      map.put("acceptPassDay", contract.getAcceptPassDay());
      map.put("acceptPassAmount", contract.getAcceptPassAmount() + "%");
      map.put("deliverDay", contract.getDeliverDay());
      map.put("deliverCompleteDay", contract.getDeliverCompleteDay());
      map.put("shipAddress", contract.getShipAddress());
      map.put("htqdr", scheduleList.get(0).getAgreedDays());
      map.put("htqdq", scheduleList.get(0).getPaymentRatio() + "%");
      map.put("fhqq", scheduleList.get(1).getPaymentRatio() + "%");
      map.put("dhhr", scheduleList.get(2).getAgreedDays());
      map.put("dhhq", scheduleList.get(2).getPaymentRatio() + "%");
      map.put("zbjq", scheduleList.get(4).getPaymentRatio() + "%");
      map.put("zbqm", scheduleList.get(4).getAgreedDays());
      map.put("paymentMethod", contract.getPaymentMethod());
      map.put("invoiceNotice", contract.getInvoiceNotice());
      map.put("supplierAgent", contract.getSupplierAgent());
      map.put("supplierAgentIDCard", contract.getSupplierAgentIdCard());
      map.put("buyerAgent", contract.getBuyerAgent());
      map.put("buyerAgentIDCard", contract.getBuyerAgentIdCard());
      map.put("agentAuthority", contract.getAgentAuthority());
      map.put("delayPayAdvancePayment", contract.getDelayPayAdvancePayment() + "%");
      map.put("delayPayAProcessPayment", contract.getDelayPayProcessPayment() + "%");
      map.put("receiveAdvancePaymentMonth", contract.getReceiveAdvancePaymentMonth());
      map.put("noticeSupplierAcceptDay", contract.getNoticeSupplierAcceptDay());
      map.put("overdueDay", contract.getOverdueDay());
      map.put("lossAmount", contract.getLossAmount() + "%");
      map.put("liquidatedDamagesHighSupplier", contract.getLiquidatedDamagesHighSupplier() + "%");
      map.put("overdueDayXf", contract.getOverdueDayXf());
      map.put("lossAmountXf", contract.getLossAmountXf() + "%");
      map.put("liquidatedDamagesHighBuyer", contract.getLiquidatedDamagesHighBuyer() + "%");
      map.put("contractAttchment", contract.getContractAttchment());
      map.put("totalParts", contract.getTotalParts());
      map.put("supplierPart", contract.getSupplierPart());
      map.put("buyerPart", contract.getBuyerPart());
      //标的物
      List<Map<String, Object>> items = new ArrayList<>();
      subjectMatterList.stream().forEach(contractSubjectMatter -> {
         Map<String, Object> item = new HashMap<>();
         item.put("materialName", contractSubjectMatter.getMaterialName());
         item.put("guige", contractSubjectMatter.getSpecification());
         item.put("unit", contractSubjectMatter.getUnit());
         item.put("quantity", contractSubjectMatter.getQuantity());
         item.put("unitPrice", contractSubjectMatter.getUnitPrice());
         item.put("price", contractSubjectMatter.getTotalAmount());
         item.put("remarks", contractSubjectMatter.getRemarks());
         items.add(item);
      });
      map.put("items", items);
      //定制方
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      map.put("companyName", customer.getRegisterName());
      map.put("legalPerson", customer.getLegalPerson());
      map.put("contactPhone", customer.getContactPhone());
      map.put("bankName", customer.getBankName());
      map.put("bankAccount", customer.getBankAccount());
      //承揽方
      R<SysDept> r = remoteDeptService.getById(contract.getPartyBId());
      SysDept dept = r.getData();
      map.put("orgName", dept.getOrgName());
      map.put("legalPerson1", StrUtil.isNotEmpty(dept.getLegalPerson()) ? dept.getLegalPerson() : "");
      map.put("entrustedAgent", StrUtil.isNotEmpty(dept.getLegalPerson()) ? "" : dept.getEntrustedAgent());
      map.put("orgContact", dept.getOrgContact());
      map.put("orgBank", dept.getOrgBank());
      map.put("orgBankAccount", dept.getOrgBankAccount());
      //生成文件名
      Long time = new Date().getTime();
      // 生成的word格式
      String formatSuffix = ".docx";
      // 拼接后的文件名
      String fileName = time + formatSuffix;//文件名  带后缀
      //导出word
      try {
         // 1. 加载模版
         // 假设模版在 resources/templates/template.docx
         ClassPathResource resource = new ClassPathResource("template/jxc/jxcxsht.docx");
         // 配置列表策略
         Configure config = Configure.builder()
               .bind("items", new LoopRowTableRenderPolicy()) // 将 items 绑定到行循环策略
               .build();
         // 2. 编译并渲染数据
         XWPFTemplate xwpfTemplate = XWPFTemplate.compile(resource.getInputStream(), config).render(map);
         // 3. 设置响应头
         response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
         response.setCharacterEncoding("utf-8");
         response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".docx");
         // 4. 写入输出流
         OutputStream out = response.getOutputStream();
         xwpfTemplate.write(out);
         out.flush();
         out.close();
         xwpfTemplate.close(); // 重要:关闭模版释放资源
      } catch (IOException e) {
         e.printStackTrace();
      }
   }
   @Override
   public R addSimple(ContractAddDTO addDTO) {
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      if (StrUtil.isEmpty(addDTO.getPartyA())) {
         BusinessCustomer bc = businessCustomerMapper.selectById(addDTO.getPartyAId());
         if (ObjUtil.isNotNull(bc)) {
            contract.setPartyA(bc.getCompanyName());
         }
      }
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("1");
      contract.setBillingAmout(new BigDecimal("0"));
      contract.setErpPushFlag("0");
      contract.setNickName(SecurityUtils.getUser().getNickname());
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         contract.setContractNo(generateSMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         contract.setContractNo(generateGYBContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         contract.setContractNo(generateYMJContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         contract.setContractNo(generateTFContractNo());
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         contract.setContractNo(generateJXCContractNo());
      }
      baseMapper.insert(contract);
      return R.ok();
   }
   @Override
   public R pushCenter(PushCenterDTO dto) {
      Contract contract = baseMapper.selectById(dto.getId());
      contract.setSelectionMethod(dto.getSelectionMethod());
      contract.setIsRelated(dto.getIsRelated());
      contract.setContractCreater(dto.getContractCreater());
      if(StrUtil.isNotBlank(dto.getAttachmentUrl())) {
         contract.setAttachmentName(dto.getAttachmentName());
         contract.setAttachmentUrl(dto.getAttachmentUrl());
      }
      baseMapper.updateById(contract);
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      if (ObjUtil.isNull(customer)){
         return R.failed("客户查询异常");
      }
      R<SysDept> r = remoteDeptService.getById(SecurityUtils.getUser().getCompId());
      if (!r.isOk()){
         return R.failed("信息查询异常");
      }
      SysDept comp = r.getData();
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, dto.getId()));
      JSONObject requestApply = new JSONObject();
      requestApply.put("fd_selectionmethod", dto.getSelectionMethod());
      requestApply.put("fd_isrelated", dto.getIsRelated());
      requestApply.put("fd_bizId", contract.getId());
      requestApply.put("fd_remark", contract.getRemark());
      requestApply.put("fd_MainContent", "");
      requestApply.put("fd_settlementType", "00");
      requestApply.put("fd_applyType", "外销");
      requestApply.put("fd_contractSubject ", subjectMatterList.stream().map(item -> item.getMaterialName()).collect(Collectors.joining(",")));
      requestApply.put("fd_docNumber", contract.getContractNo());
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         requestApply.put("fd_templateId", tempSMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         requestApply.put("fd_templateId", tempSGB);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         requestApply.put("fd_templateId", tempYMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         requestApply.put("fd_templateId", tempTFGS);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         requestApply.put("fd_templateId", tempJXC);
      }
      requestApply.put("fd_name", contract.getContractName());
      requestApply.put("fd_signDate", DateUtil.formatDate(contract.getSignDate()));
      requestApply.put("fd_endDate", DateUtil.formatDate(contract.getExpirationDate()));
      requestApply.put("fd_contractCreater", StrUtil.isNotEmpty(dto.getContractCreater())?dto.getContractCreater():SecurityUtils.getUser().getNickname());
      requestApply.put("fd_currency", "人民币");
      requestApply.put("fd_ContractAmount", contract.getAmount());
      requestApply.put("fd_finAmount", contract.getAmount().divide(new BigDecimal("113"), 2, RoundingMode.HALF_UP)
            .multiply(new BigDecimal("87")));
      requestApply.put("fd_docStatus", "20");
      requestApply.put("fd_taxRates", 13);
      requestApply.put("fd_customerName", contract.getPartyA());
      requestApply.put("fd_systemSource", "非煤销售系统");
      requestApply.put("fd_type", "00");
      requestApply.put("fd_baozhangren", comp.getBaozhangren());
      requestApply.put("fd_summary",contract.getSummary());
      JSONArray signList = new JSONArray();
      JSONObject j = new JSONObject();
      j.put("fd_standing","甲");
      j.put("fd_Iden",customer.getCreditCode());
      j.put("fd_signMain","2");
      signList.add(j);
      JSONObject y = new JSONObject();
      y.put("fd_standing","乙");
      y.put("fd_Iden",comp.getOrgCode());
      y.put("fd_signMain","1");
      signList.add(y);
      requestApply.put("fd_signList", signList);
      if(StrUtil.isNotBlank(contract.getAttachmentUrl())){
         JSONArray attList = new JSONArray();
         JSONObject att = new JSONObject();
         att.put("fd_attNum","1");
         att.put("fd_attName",contract.getAttachmentName());
         att.put("fd_attQuality","00");
         att.put("fd_attcontent",NetworkFileToBase64.convertNetworkFileToBase64("https://zbjt.res.jzeg.cn/api" + contract.getAttachmentUrl()));
         attList.add(att);
         requestApply.put("attList", att);
      }
      if (CollUtil.isNotEmpty(subjectMatterList)){
         JSONArray materialList = new JSONArray();
         subjectMatterList.stream().forEach(subjectMatter->{
            JSONObject material = new JSONObject();
            material.put("fd_materiaCode", subjectMatter.getMaterialCode());
            material.put("fd_materiaName", subjectMatter.getMaterialInternalName());
            material.put("fd_specification", StrUtil.isNotBlank(subjectMatter.getSpecification())?subjectMatter.getSpecification():"");
            material.put("fd_figureNumber", "");
            material.put("fd_measureUnit", subjectMatter.getUnit());
            material.put("fd_number", subjectMatter.getQuantity());
            material.put("fd_price", subjectMatter.getUnitPrice());
            Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode,subjectMatter.getMaterialCode()).last("limit 1"));
            if (ObjUtil.isNotNull(product)){
               material.put("fd_rate", product.getTaxRate().toString());
            }
            material.put("fd_amount", subjectMatter.getUnitPrice().multiply(subjectMatter.getQuantity()));
            material.put("fd_requirements", "");
            material.put("fd_standard", "");
            material.put("fd_factory", "");
            material.put("fd_Deadlines", ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate())?subjectMatter.getPlannedDeliveryDate():"");
            material.put("fd_delivery", "");
            material.put("fd_des", "");
            materialList.add(material);
         });
         requestApply.put("materialList", materialList);
      }
      log.info("工业泵推送——合同中心合同起草接口入参:{}", requestApply.toJSONString());
      String respApply = HttpUtil.post("https://oa.res.jzeg.cn/ekp/api/km-agreement/kmAgreementWebService/addSupplyContractApply", requestApply.toJSONString());
      log.info("工业泵推送——合同中心合同起草接口回参:{}", respApply);
      JSONObject applyResp = JSONObject.parseObject(respApply);
      if (applyResp.getString("code").equals("00")) {
         contract.setCenterPushFlag("1");
         baseMapper.updateById(contract);
         return R.ok();
      }
      log.error("工业泵推送——推送合同中心审核失败,原因为:{}",applyResp.getString("msg"));
      return R.failed("工业泵推送——推送合同中心审核失败,原因为:{}",applyResp.getString("msg"));
   }
   @Override
   public R importContractMultiSheet(MultipartFile file) {
      // 用于收集所有 Sheet 解析后的最终结果(如果需要统一返回或处理)
      // 注意:如果数据量极大,建议在 Listener 中直接入库,不要全部加载到内存 List 中
      List<ContractExceVO> baseList = new ArrayList<>();
      List<ContractPaymentScheduleExceVO> scheduleList = new ArrayList<>();
      List<ContractSubjectMatterExceVO> matterList = new ArrayList<>();
      try (ExcelReader excelReader = EasyExcel.read(file.getInputStream()).build()) {
         // 1. 构建第一个 Sheet 的读取配置
         ReadSheet sheet0 = EasyExcel.readSheet(0)
               .headRowNumber(1) // 表头行数
               .head(ContractExceVO.class) // 指定实体类
               .registerReadListener(new BatchInsertListener<ContractExceVO>(data -> {
                  baseList.addAll(data);
                  // 建议:在这里直接调用 service 保存,而不是 addTo List,除非数据量很小
                  // contractService.saveBaseInfo(data);
               }))
               .build();
         // 2. 构建第二个 Sheet 的读取配置
         ReadSheet sheet1 = EasyExcel.readSheet(1)
               .headRowNumber(1)
               .head(ContractSubjectMatterExceVO.class)
               .registerReadListener(new BatchInsertListener<ContractSubjectMatterExceVO>(data -> {
                  matterList.addAll(data);
                  // contractService.saveSchedule(data);
               }))
               .build();
         // 3. 构建第三个 Sheet 的读取配置
         ReadSheet sheet2 = EasyExcel.readSheet(2)
               .headRowNumber(1)
               .head(ContractPaymentScheduleExceVO.class) // 注意:这里你原代码写的是 ContractPaymentScheduleExceVO,但变量是 matterList,需确认实体类是否一致
               .registerReadListener(new BatchInsertListener<ContractPaymentScheduleExceVO>(data -> {
                  scheduleList.addAll(data);
                  // contractService.saveMatter(data);
               }))
               .build();
         // 4. 依次执行读取
         // 注意:excelReader.read(sheet) 会复用同一个输入流,所以必须用 try-with-resources 确保流管理正确
         excelReader.read(sheet0);
         excelReader.read(sheet1);
         excelReader.read(sheet2);
         // 后续处理 baseList, scheduleList, matterList
         log.info("主表数据量: " + baseList.size());
         log.info("进度表数据量: " + scheduleList.size());
         log.info("标的物数据量: " + matterList.size());
         List<Map<String, String>> errList = new ArrayList<>();
         for (int i = 0; i < baseList.size(); i++) {
            ContractExceVO contractExceVO = baseList.get(i);
            if (StrUtil.isBlank(contractExceVO.getContractNo())) {
               Map<String, String> map = new HashMap<String, String>();
               map.put("lineNum", "第" + (i + 1) + "行");
               map.put("errors", "合同编号为空");
               errList.add(map);
               continue;
            }
            BusinessCustomer bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery()
                  .eq(BusinessCustomer::getErpCompanyCode, contractExceVO.getBcErpCode()));
            if (ObjUtil.isNull(bc)) {
               Map<String, String> map = new HashMap<String, String>();
               map.put("lineNum", "第" + (i + 1) + "行");
               map.put("errors", "客户erp编码不存在");
               errList.add(map);
               continue;
            }
            R<List<SysDictItem>> rem = remoteDictService.getDictByType("economic_matters");
            if (!rem.isOk()) {
               return R.failed("经济事项字典查询异常");
            }
            List<SysDictItem> itemList = rem.getData();
            for (SysDictItem dictItem : itemList
            ) {
               if (StrUtil.equals(contractExceVO.getEconomicMatters(), dictItem.getLabel())) {
                  contractExceVO.setEconomicMatters(dictItem.getItemValue());
                  break;
               }
            }
            R<List<SysDictItem>> rsa = remoteDictService.getDictByType("supply_attribute");
            if (!rsa.isOk()) {
               return R.failed("供应属性字典查询异常");
            }
            for (SysDictItem dictItem : rsa.getData()
            ) {
               if (StrUtil.equals(contractExceVO.getSupplyAttribute().replace(" ", ""), dictItem.getLabel())) {
                  contractExceVO.setSupplyAttribute(dictItem.getItemValue());
                  break;
               }
            }
            R<List<SysDictItem>> rssa = remoteDictService.getDictByType("server_attribute");
            if (!rssa.isOk()) {
               return R.failed("服务属性字典查询异常");
            }
            for (SysDictItem dictItem : rssa.getData()
            ) {
               if (StrUtil.equals(contractExceVO.getContractAttribute().replace(" ", ""), dictItem.getLabel())) {
                  contractExceVO.setContractAttribute(dictItem.getItemValue());
                  break;
               }
            }
            R<List<SysDictItem>> ris = remoteDictService.getDictByType("industry_sector");
            if (!ris.isOk()) {
               return R.failed("服务属性字典查询异常");
            }
            for (SysDictItem dictItem : ris.getData()
            ) {
               if (StrUtil.equals(contractExceVO.getIndustryCode(), dictItem.getLabel())) {
                  contractExceVO.setIndustryCode(dictItem.getItemValue());
                  break;
               }
            }
            List<Contract> contractList = baseMapper.selectList(Wrappers.<Contract>lambdaQuery()
                  .eq(Contract::getContractNo, contractExceVO.getContractNo()));
            if (CollUtil.isNotEmpty(contractList)) {
               Map<String, String> map = new HashMap<String, String>();
               map.put("lineNum", "第" + (i + 1) + "行");
               map.put("errors", "合同编号已存在");
               errList.add(map);
               continue;
            }
            Contract contract = BeanUtil.copyProperties(contractExceVO, Contract.class);
            if (ObjUtil.isNotNull(contract.getSignDate()) && ObjUtil.isNotNull(contract.getExpirationDate())) {
               Long bd = DateUtil.betweenDay(contract.getExpirationDate(), contract.getSignDate(), true);
               contract.setDeliveryCycle(bd.intValue());
            }
            contract.setPartyA(bc.getCompanyName());
            contract.setPartyAId(bc.getId());
            contract.setPartyB(SecurityUtils.getUser().getCompName());
            contract.setPartyBId(SecurityUtils.getUser().getCompId());
            contract.setContractStatus(2);
            contract.setPaidAmount(ObjUtil.isNotNull(contract.getPaidAmount()) ?
                  contract.getPaidAmount() : new BigDecimal("0"));
            contract.setBillingAmout(ObjUtil.isNotNull(contract.getBillingAmout()) ?
                  contract.getBillingAmout() : new BigDecimal("0"));
            if (contract.getPaidAmount().compareTo(contract.getAmount())==0&&contract.getBillingAmout().compareTo(contract.getAmount())==0){
               contract.setContractStatus(3);
            }
            contract.setBillingStatus("1");
            baseMapper.insert(contract);
            BigDecimal remainAmount = ObjUtil.isNotNull(contract.getPaidAmount()) ? contract.getPaidAmount() : new BigDecimal("0");
            List<ContractSubjectMatterExceVO> resultMatter = matterList.stream().filter(item ->
                  StrUtil.isNotBlank(item.getMaterialCode()) &&
                        StrUtil.equals(item.getContractNo(), contract.getContractNo())).collect(Collectors.toList());
            if (CollUtil.isNotEmpty(resultMatter)) {
               for (ContractSubjectMatterExceVO subMatEx : resultMatter
               ) {
                  ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(subMatEx, ContractSubjectMatter.class);
                  subjectMatter.setContractId(contract.getId());
                  subjectMatter.setDeliveredQuantity(StrUtil.isBlank(subMatEx.getDeliveredQuantity())
                        ? new BigDecimal("0") : new BigDecimal(subMatEx.getDeliveredQuantity()));
                  subjectMatter.setRemainingQuantity(subjectMatter.getQuantity().subtract(subjectMatter.getDeliveredQuantity()));
                  subjectMatter.setDeliveryStatus(subjectMatter.getRemainingQuantity().compareTo(subjectMatter.getQuantity()) == 0 ? 0
                        : subjectMatter.getRemainingQuantity().compareTo(new BigDecimal("0")) > 0 ? 1 : 2);
                  subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
                  contractSubjectMatterMapper.insert(subjectMatter);
//                  if (subjectMatter.getDeliveredQuantity().compareTo(new BigDecimal("0")) > 0) {
//                     //出库单
//                     ContractOutBound outBound = new ContractOutBound();
//                     outBound.setBusGuestId(contract.getPartyAId());
//                     outBound.setBusGuestName(contract.getPartyA());
//                     outBound.setContractId(contract.getId());
//                     outBound.setContractName(contract.getContractName());
//                     outBound.setInvoiceNum(new BigDecimal("0"));
//                     outBound.setInvoiceStatus("0");
//                     outBound.setOutBoundTime(new Date());
//                     outBound.setOutBoundNum(subjectMatter.getDeliveredQuantity());
//                     outBound.setSubjectMatterName(subjectMatter.getMaterialInternalName());
//                     outBound.setSubjectMatterCode(subjectMatter.getMaterialCode());
//                     contractOutBoundMapper.insert(outBound);
//                     if (contract.getBillingAmout().compareTo(new BigDecimal("0")) == 0) {
//                        contract.setBillingStatus("2");
//                        baseMapper.updateById(contract);
//                     }
//                  }
               }
            }
            List<ContractPaymentScheduleExceVO> resultSchedule = scheduleList.stream().filter(item ->
                  StrUtil.equals(item.getContractNo(), contract.getContractNo())).collect(Collectors.toList());
            if (CollUtil.isNotEmpty(resultSchedule)) {
               for (int j = 0; j < resultSchedule.size(); j++) {
                  ContractPaymentSchedule schedule = new ContractPaymentSchedule();
                  schedule.setStageName(resultSchedule.get(j).getStageName());
                  schedule.setContractId(contract.getId());
                  schedule.setPaymentRatio(StrUtil.isBlank(resultSchedule.get(j).getPaymentRatio())
                        ? new BigDecimal("0") : new BigDecimal(resultSchedule.get(j).getPaymentRatio()));
                  schedule.setAgreedDays(StrUtil.isBlank(resultSchedule.get(j).getAgreedDays())
                        ? 0 : Integer.valueOf(resultSchedule.get(j).getAgreedDays()));
                  schedule.setPlannedAmount(contract.getAmount().multiply(schedule.getPaymentRatio())
                        .divide(new BigDecimal("100"), 2, RoundingMode.HALF_UP));
                  schedule.setPaymentStatus(0);
                  schedule.setStageOrder(j + 1);
                  if (remainAmount.compareTo(new BigDecimal("0")) > 0 && schedule.getPlannedAmount().compareTo(new BigDecimal("0")) > 0) {
                     remainAmount = remainAmount.subtract(schedule.getPlannedAmount());
                     if (remainAmount.compareTo(new BigDecimal("0")) >= 0) {
                        schedule.setPaymentStatus(2);
                        schedule.setActualAmount(schedule.getPlannedAmount());
                     }
                     if (remainAmount.compareTo(new BigDecimal("0")) < 0) {
                        schedule.setPaymentStatus(1);
                        schedule.setActualAmount(schedule.getPlannedAmount().add(remainAmount));
                     }
                  }
                  contractPaymentScheduleMapper.insert(schedule);
//                  if (schedule.getStageName().equals("质保金") && contract.getAmount().subtract(ObjUtil.isNotNull(contract.getPaidAmount()) ?
//                        contract.getPaidAmount() : new BigDecimal("0")).compareTo(new BigDecimal("0")) > 0) {
//                     PaymentConfirm confirm = new PaymentConfirm();
//                     confirm.setBusGuestId(contract.getPartyAId());
//                     confirm.setBusGuestName(contract.getPartyA());
//                     confirm.setBusinessType("质保金应收");
//                     confirm.setConfirmTime(new Date());
//                     confirm.setContractId(contract.getId());
//                     confirm.setContractName(contract.getContractName());
//                     confirm.setContractNo(contract.getContractNo());
//                     confirm.setScheduleId(schedule.getId());
//                     confirm.setScheduleName(schedule.getStageName());
//                     confirm.setTransationAmount(contract.getAmount().subtract(ObjUtil.isNotNull(contract.getPaidAmount()) ?
//                           contract.getPaidAmount() : new BigDecimal("0")));
//                     confirm.setReceivableAmount(confirm.getTransationAmount());
//                     confirm.setTotalAmount(confirm.getTransationAmount().multiply(new BigDecimal("-1")));
//                     paymentConfirmMapper.insert(confirm);
//                  }
               }
            }
         }
         if (CollUtil.isNotEmpty(errList)) {
            return R.failed(errList);
         }
      } catch (IOException e) {
         e.printStackTrace();
         return R.failed("文件解析失败: " + e.getMessage());
      }
      return R.ok();
   }
   @Override
   public R subjectChange(ContractSubjectChangeDTO changeDTO) {
      Contract contract = baseMapper.selectById(changeDTO.getId());
      if (ObjUtil.isNull(contract)){
         return R.failed("合同状态异常");
      }
      if (contract.getBillingAmout().compareTo(new BigDecimal("0"))>0){
         return R.failed("合同已开票,不能进行变更");
      }
      if (ObjUtil.isNotNull(contract.getOutBoundAmout())&&contract.getOutBoundAmout().compareTo(new BigDecimal("0"))>0){
         return R.failed("合同标的物已出库,不能进行变更");
      }
      if (CollUtil.isEmpty(changeDTO.getContractSubjectMatter())){
         return R.failed("合同变更后标的物不能为空");
      }
      BigDecimal changeAmount = changeDTO.getContractSubjectMatter().stream().map(subject->subject.getUnitPrice().multiply(subject.getQuantity())).reduce(BigDecimal.ZERO,BigDecimal::add);
      if (contract.getAmount().compareTo(changeAmount)!=0){
         return R.failed("合同变更后标的物总价必须与合同总价一致");
      }
      List<ContractSubjectMatter> beforeList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId,changeDTO.getId()));
      ContractSubjectMatterChange change = new ContractSubjectMatterChange();
      change.setContractId(contract.getId());
      change.setBeforeChange(JSONObject.toJSONString(beforeList));
      change.setAfterChange(JSONObject.toJSONString(changeDTO.getContractSubjectMatter()));
      changeMapper.insert(change);
      contractSubjectMatterMapper.delete(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId,changeDTO.getId()));
      changeDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
         ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
         subjectMatter.setContractId(contract.getId());
         subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
         subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
         subjectMatter.setDeliveryStatus(0);
         subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
         contractSubjectMatterMapper.insert(subjectMatter);
      });
      return R.ok();
   }
   @Override
   public Page subjectChangePage(Page page, ContracQueryDTO queryDTO) {
      return changeMapper.subjectChangePage(page,queryDTO,DataScope.of("comp_id"));
   }
   @Override
   public R subjectChangeAtt(ContractSubjectChangeAttDTO attDTO) {
      ContractSubjectMatterChange change = changeMapper.selectById(attDTO.getId());
      change.setAttachmentName(attDTO.getAttachmentName());
      change.setAttachmentUrl(attDTO.getAttachmentUrl());
      changeMapper.updateById(change);
      return R.ok();
   }
   @Override
   public R syncContractStatus(SyncContractStatusDTO dto) {
      log.info("合同审批结果同步,合同编号:{},审批结果:{}",dto.getContractNumber(),dto.getStatus());
      if (StrUtil.isBlank(dto.getFd_bizId())){
         return R.failed("数据ID不能为空");
      }
      if (StrUtil.isBlank(dto.getStatus())){
         return R.failed("审批状态不能为空");
      }
      if (StrUtil.isBlank(dto.getReturnPerson())){
         return R.failed("审批人不能为空");
      }
      if (StrUtil.isBlank(dto.getReturnDate())){
         return R.failed("审批时间不能为空");
      }
      Contract contract = baseMapper.selectById(dto.getFd_bizId());
      if(ObjUtil.isNull(contract)){
         return R.failed("数据ID异常");
      }
      if (StrUtil.equals(dto.getStatus(),"1")){
         takeEffect(contract.getId());
      }
      if (StrUtil.equals(dto.getStatus(),"2")){
         refuseApproval(contract.getId());
      }
      if (StrUtil.equals(dto.getStatus(),"3")||StrUtil.equals(dto.getStatus(),"4")){
         contract.setContractStatus(3);
         baseMapper.updateById(contract);
      }
      saveContractApproval(contract,dto);
      return R.ok();
   }
   private void saveContractApproval(Contract contract, SyncContractStatusDTO dto) {
      ContractApproval approval = BeanUtil.copyProperties(dto,ContractApproval.class);
      approval.setContractId(contract.getId());
      approval.setReturnDateTime(DateUtil.parseDateTime(dto.getReturnDate()));
      approval.setCompId(contract.getCompId());
      contractApprovalMapper.insert(approval);
   }
   @Override
   public R finallyPdf(ContractFinallyDTO attDTO) {
      Contract contract = baseMapper.selectById(attDTO.getId());
      if (ObjUtil.isNull(contract)){
         return R.failed("合同异常");
      }
      if (!StrUtil.equals(contract.getContractStatus()+"","2")){
         return R.failed("合同异常状态");
      }
      contract.setSignDate(attDTO.getSignDate());
      contract.setExpirationDate(attDTO.getExpirationDate());
      contract.setSinger(attDTO.getSinger());
      contract.setReviewerNo(attDTO.getReviewerNo());
      contract.setLinkPerson(attDTO.getLinkPerson());
      contract.setLinkPhone(attDTO.getLinkPhone());
      Long betweenDay = DateUtil.betweenDay(attDTO.getExpirationDate(),attDTO.getSignDate(),true);
      contract.setDeliveryCycle(betweenDay.intValue());
      baseMapper.updateById(contract);
      JSONObject request = new JSONObject();
      request.put("fd_docNumber", contract.getContractNo());
      request.put("fd_singer", StrUtil.isNotEmpty(attDTO.getSinger())?attDTO.getSinger():SecurityUtils.getUser().getNickname());
      request.put("fd_signTime", DateUtil.formatDate(contract.getSignDate()));
      request.put("fd_linkPerson", StrUtil.isNotEmpty(attDTO.getLinkPerson())?attDTO.getLinkPerson():"");
      request.put("fd_linkPhone", StrUtil.isNotEmpty(attDTO.getLinkPhone())?attDTO.getLinkPhone():"");
      request.put("fd_address", contract.getSignPlace());
      request.put("fd_receivedTime", DateUtil.format(contract.getCreateTime(), DatePattern.NORM_DATETIME_PATTERN));
      request.put("fd_receivedNum", 1);
      request.put("fd_effedate", DateUtil.formatDate(contract.getSignDate()));
      request.put("fd_enddate", DateUtil.formatDate(contract.getExpirationDate()));
      request.put("fd_reviewerNo", StrUtil.isNotEmpty(attDTO.getReviewerNo())?attDTO.getReviewerNo():SecurityUtils.getUser().getNickname());
      request.put("fd_docStatus", "20");
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc) ||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)||
            StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         request.put("fd_templateId", tempSMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb)) {
         request.put("fd_templateId", tempSGB);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
         request.put("fd_templateId", tempYMJ);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs)) {
         request.put("fd_templateId", tempTFGS);
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc)) {
         request.put("fd_templateId", tempJXC);
      }
      request.put("fd_attName", attDTO.getLastAttachmentName());
      request.put("fd_attcontent", NetworkFileToBase64.convertNetworkFileToBase64("https://zbjt.res.jzeg.cn/api" + attDTO.getLastAttachmentUrl()));
      log.info("合同中心同步合同接口入参:{}", request.toJSONString());
      String resp = HttpUtil.post("https://oa.res.jzeg.cn/ekp/api/km-agreement/kmAgreementWebService/addContractReview", request.toJSONString());
      log.info("合同中心同步合同接口回参:{}", resp);
      JSONObject respJson = JSONObject.parseObject(resp);
      if (respJson.getString("code").equals("00")) {
         contract.setLastAttachmentName(attDTO.getLastAttachmentName());
         contract.setLastAttachmentUrl(attDTO.getLastAttachmentUrl());
         baseMapper.updateById(contract);
         return R.ok();
      }
      return R.failed("合同中心最终盖章登记PDF上传失败,原因为:{}",respJson.getString("msg"));
   }
   @Override
   public R addContractSgbHis(ContractAddDTO addDTO) {
      if (CollUtil.isEmpty(addDTO.getContractSubjectMatter())) {
         return R.failed("请添加标的物");
      }
      if (CollUtil.isEmpty(addDTO.getContractPaymentSchedule())) {
         return R.failed("请添加付款阶段或付款阶段缺少");
      }
      if (!isValidPaymentStages(addDTO.getContractPaymentSchedule())) {
         return R.failed("付款阶段信息异常");
      }
      if (addDTO.getContractPaymentSchedule().stream().map(item -> item.getPaymentRatio()).reduce(BigDecimal.ZERO, BigDecimal::add)
            .compareTo(new BigDecimal("100.00")) != 0) {
         return R.failed("付款阶段比例异常");
      }
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setErpContractNo(contract.getContractNo());
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      contract.setContractStatus(2);
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("1");
      contract.setErpPushFlag("1");
      contract.setCenterPushFlag("1");
      contract.setBillingAmout(new BigDecimal("0"));
      BusinessCustomer bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery().eq(BusinessCustomer::getErpCompanyCode,
            addDTO.getPartyACode()).last("limit 1"));
      if (ObjUtil.isNull(bc)) {
         return R.failed("erp客户编码不存在");
      }
      contract.setPartyAId(bc.getId());
      contract.setPartyA(bc.getCompanyName());
      if (ObjUtil.isNotNull(addDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(addDTO.getSignDate(), addDTO.getDeliveryCycle()));
      }
      if (ObjUtil.isNotNull(contract.getSignDate()) && ObjUtil.isNotNull(contract.getExpirationDate())) {
         Long bd = DateUtil.betweenDay(contract.getExpirationDate(), contract.getSignDate(), true);
         contract.setDeliveryCycle(bd.intValue());
      }
      contract.setContractNo(generateGYBContractNo());
      if (!StrUtil.equals(addDTO.getContractCategory(), "water_house")) {
         // 假设 list 是你的 List<ContractSubjectMatterAddDTO>
         Optional<ContractSubjectMatterAddDTO> maxDateObj = addDTO.getContractSubjectMatter().stream()
               .filter(item -> item.getPlannedDeliveryDate() != null) // 过滤掉日期为空的项,避免 NullPointerException
               .max(Comparator.comparing(ContractSubjectMatterAddDTO::getPlannedDeliveryDate));
         if (maxDateObj.isPresent()) {
            contract.setExpirationDate(maxDateObj.get().getPlannedDeliveryDate());
         }
      }
      baseMapper.insert(contract);
      if (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
         addDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
            contractSubjectMatterMapper.insert(subjectMatter);
            //水电类必须有初次表号
            if (StrUtil.isNotEmpty(contractSubjectMatterAddDTO.getMeterReadCode()) &&
                  ObjUtil.isNotNull(contractSubjectMatterAddDTO.getMeterReadNum())) {
               MeterReadRecord record = BeanUtil.copyProperties(contractSubjectMatterAddDTO, MeterReadRecord.class, "id");
               record.setContractId(contract.getId());
               record.setMatterId(subjectMatter.getId());
               record.setContractName(contract.getContractName());
               record.setBusGuestId(contract.getPartyAId());
               record.setBusGuestName(contract.getPartyA());
               record.setMeterReadTime(new Date());
               meterReadRecordMapper.insert(record);
            }
            if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && StrUtil.equals(addDTO.getContractCategory(), "ymjcg")
                  && ObjUtil.isNotNull(subjectMatter.getPlannedDeliveryDate()) && ObjUtil.isNotNull(contract.getExpirationDate())
                  && DateUtil.compare(contract.getExpirationDate(), subjectMatter.getPlannedDeliveryDate()) > 0) {
               contract.setExpirationDate(subjectMatter.getPlannedDeliveryDate());
               baseMapper.updateById(contract);
            }
         });
      }
      if (CollUtil.isNotEmpty(addDTO.getContractPaymentSchedule())) {
         AtomicInteger index = new AtomicInteger(1);
         addDTO.getContractPaymentSchedule().stream().forEach(contractPaymentScheduleAddDTO -> {
            int currentIndex = index.getAndIncrement();
            ContractPaymentSchedule schedule = BeanUtil.copyProperties(contractPaymentScheduleAddDTO, ContractPaymentSchedule.class);
            if (contractPaymentScheduleAddDTO.getStageName().equals("合同签订")) {
               schedule.setEffectiveEndDate(DateUtil.offsetDay(contract.getSignDate(), contractPaymentScheduleAddDTO.getAgreedDays()));
            }
            if (ObjUtil.isNotNull(schedule.getEffectiveDate())) {
               if (schedule.getEffectiveDate().before(DateUtil.date())) {
                  schedule.setFulfillmentStatus(1);
               } else {
                  schedule.setFulfillmentStatus(0);
               }
            }
            if (contractPaymentScheduleAddDTO.getPaymentRatio().compareTo(new BigDecimal("0")) > 0) {
               schedule.setPaymentStatus(0);
            } else {
               schedule.setPaymentStatus(3);
            }
            schedule.setContractId(contract.getId());
            schedule.setContractName(contract.getContractName());
            schedule.setPlannedAmount(contract.getAmount().multiply(schedule.getPaymentRatio().divide(new BigDecimal("100"))));
            schedule.setStageOrder(currentIndex);
            contractPaymentScheduleMapper.insert(schedule);
            if (contractPaymentScheduleAddDTO.getStageName().equals("货到签收")) {
               contract.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("调试完成或验收")) {
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         });
      }
      return R.ok(contract.getContractNo());
   }
   @Override
   public R addContractHis(ContractAddDTO addDTO) {
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      if (StrUtil.isEmpty(addDTO.getPartyA())) {
         BusinessCustomer bc = businessCustomerMapper.selectById(addDTO.getPartyAId());
         if (ObjUtil.isNotNull(bc)) {
            contract.setPartyA(bc.getCompanyName());
         }
         if (!StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb) && StrUtil.isEmpty(bc.getErpCompanyCode())
               && StrUtil.isEmpty(bc.getCreditCode())) {
            return R.failed("请完善客户ERP编码或组织机构代码");
         }
      }
      contract.setBillingStatus("1");
      contract.setErpPushFlag("1");
      contract.setCenterPushFlag("1");
      contract.setContractStatus(2);
      contract.setNickName(SecurityUtils.getUser().getNickname());
      contract.setNextScheduleName("发货前");
      if (ObjUtil.isNotNull(addDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(addDTO.getSignDate(), addDTO.getDeliveryCycle()));
      }
      if (CollUtil.isEmpty(addDTO.getContractSubjectMatter())) {
         return R.failed("标的物不能为空");
      }
      baseMapper.insert(contract);
      if (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
         addDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(contract.getId());
            subjectMatter.setDeliveredQuantity(ObjUtil.isNull(contractSubjectMatterAddDTO.getDeliveredQuantity())
                  ? new BigDecimal("0") : contractSubjectMatterAddDTO.getDeliveredQuantity());
            subjectMatter.setRemainingQuantity(subjectMatter.getQuantity().subtract(subjectMatter.getDeliveredQuantity()));
            subjectMatter.setDeliveryStatus(subjectMatter.getRemainingQuantity().compareTo(subjectMatter.getQuantity()) == 0 ? 0
                  : subjectMatter.getRemainingQuantity().compareTo(new BigDecimal("0")) > 0 ? 1 : 2);
            subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
            contractSubjectMatterMapper.insert(subjectMatter);
         });
         List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
               .eq(ContractSubjectMatter::getContractId,contract.getId()).ne(ContractSubjectMatter::getDeliveryStatus,2));
         if (CollUtil.isEmpty(subjectMatterList)){
            contract.setNextScheduleName("货到签收");
            baseMapper.updateById(contract);
         }
      }
      BigDecimal remainAmount = ObjUtil.isNotNull(contract.getPaidAmount()) ? contract.getPaidAmount() : new BigDecimal("0");
      if (CollUtil.isNotEmpty(addDTO.getContractPaymentSchedule())) {
         for (int j = 0; j < addDTO.getContractPaymentSchedule().size(); j++) {
            ContractPaymentSchedule schedule = new ContractPaymentSchedule();
            schedule.setStageName(addDTO.getContractPaymentSchedule().get(j).getStageName());
            schedule.setContractId(contract.getId());
            schedule.setPaymentRatio(addDTO.getContractPaymentSchedule().get(j).getPaymentRatio());
            schedule.setAgreedDays(addDTO.getContractPaymentSchedule().get(j).getAgreedDays());
            schedule.setPlannedAmount(contract.getAmount().multiply(schedule.getPaymentRatio())
                  .divide(new BigDecimal("100"), 2, RoundingMode.HALF_UP));
            schedule.setPaymentStatus(0);
            schedule.setStageOrder(j + 1);
            if (remainAmount.compareTo(new BigDecimal("0")) > 0 && schedule.getPlannedAmount().compareTo(new BigDecimal("0")) > 0) {
               remainAmount = remainAmount.subtract(schedule.getPlannedAmount());
               if (remainAmount.compareTo(new BigDecimal("0")) >= 0) {
                  schedule.setPaymentStatus(2);
                  schedule.setActualAmount(schedule.getPlannedAmount());
               }
               if (remainAmount.compareTo(new BigDecimal("0")) < 0) {
                  schedule.setPaymentStatus(1);
                  schedule.setActualAmount(schedule.getPlannedAmount().add(remainAmount));
               }
            }
            contractPaymentScheduleMapper.insert(schedule);
            if (addDTO.getContractPaymentSchedule().get(j).getStageName().equals("货到签收")) {
               contract.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (addDTO.getContractPaymentSchedule().get(j).getStageName().equals("调试完成或验收")) {
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (addDTO.getContractPaymentSchedule().get(j).getStageName().equals("质保金")) {
               contract.setWarrantyScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
         }
      }
      if (contract.getPaidAmount().compareTo(contract.getAmount())==0&&contract.getBillingAmout().compareTo(contract.getAmount())==0){
         contract.setContractStatus(3);
         baseMapper.updateById(contract);
      }
      return R.ok();
   }
   @Override
   public R getFinallyInfo(Long id) {
      Contract contract = baseMapper.selectById(id);
      return R.ok(BeanUtil.copyProperties(contract,ContractFinallyVo.class));
   }
   @Override
   public R erpPush(Long id) {
      Contract contract = baseMapper.selectById(id);
      List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
            .eq(ContractSubjectMatter::getContractId, id));
      pushSubCompany(contract,subjectMatterList);
      return R.ok();
   }
   @Override
   public R associationPartyC(ContractAssociationPartyCyDTO associationPartyCyDTO) {
      Contract contract = baseMapper.selectById(associationPartyCyDTO.getId());
      contract.setPartyCId(Long.valueOf(associationPartyCyDTO.getPartyCId()));
      baseMapper.updateById(contract);
      return R.ok();
   }
   @Override
   public R getInvoiceObj(Long id) {
      Contract contract = baseMapper.selectById(id);
      ContractInvoiceObjVo objVo = BeanUtil.copyProperties(contract,ContractInvoiceObjVo.class);
      List<BusinessCustomerSelectVo> selectVoList = new ArrayList<>();
      BusinessCustomer a = businessCustomerMapper.selectById(contract.getPartyAId());
      if (ObjUtil.isNotNull(a)){
         objVo.setPartyA(a.getCompanyName());
         objVo.setPartyAOrgCode(a.getCreditCode());
         objVo.setInvoiceType(StrUtil.isNotBlank(a.getInvoiceType())?a.getInvoiceType():"01");
         BusinessCustomerSelectVo selectVo = BeanUtil.copyProperties(a,BusinessCustomerSelectVo.class);
         selectVoList.add(selectVo);
      }
      if (ObjUtil.isNotNull(contract.getPartyCId())){
         BusinessCustomer c = businessCustomerMapper.selectById(contract.getPartyCId());
         if (ObjUtil.isNotNull(c)){
            BusinessCustomerSelectVo selectVo = BeanUtil.copyProperties(c,BusinessCustomerSelectVo.class);
            selectVoList.add(selectVo);
         }
      }
      objVo.setLinkPartyC(selectVoList);
      return R.ok(objVo);
   }
}