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.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.*;
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.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;
import com.by4cloud.platformx.flow.task.dto.ProcessInstanceParamDto;
import com.deepoove.poi.XWPFTemplate;
import com.deepoove.poi.config.Configure;
import com.deepoove.poi.data.RowRenderData;
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;
import java.math.BigDecimal;
import java.math.RoundingMode;
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 {

	private final ContractSubjectMatterMapper contractSubjectMatterMapper;
	private final ContractPaymentScheduleMapper contractPaymentScheduleMapper;
	private final ContractPaymentScheduleProcessMapper contractPaymentScheduleProcessMapper;
	private final PaymentConfirmMapper paymentConfirmMapper;
	private final CurrentOverdueMapper currentOverdueMapper;
	private final BusinessCustomerMapper businessCustomerMapper;
	private final MeterReadRecordMapper meterReadRecordMapper;
	private final ContractExecDateMapper contractExecDateMapper;
	private final RemoteFlowProcessService remoteFlowProcessService;
	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());
		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.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 (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
			addDTO.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);
				//水电类必须有初次表号
				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);
				}
				if (contractPaymentScheduleAddDTO.getStageName().equals("质保金")) {
					contract.setWarrantyScheduleId(schedule.getId());
					baseMapper.updateById(contract);
				}
			});

		}


		return R.ok();
	}

	@Override
	public R edit(ContractUpdateDTO updateDTO) {
		Contract entity = baseMapper.selectById(updateDTO.getId());
		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.setBillingStatus("1");
		contract.setErpPushFlag("0");
		contract.setPaidAmount(new BigDecimal("0"));
		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 (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.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");
					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);
				}
				if (contractPaymentScheduleAddDTO.getStageName().equals("质保金")) {
					contract.setWarrantyScheduleId(schedule.getId());
					baseMapper.updateById(contract);
				}
			});

		}

		return R.ok();
	}

	@Override
	public ContractDetailVo detail(Long id) {
		Contract contract = baseMapper.selectById(id);
		ContractDetailVo detailVo = BeanUtil.copyProperties(contract, ContractDetailVo.class);
		List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId, id));
		detailVo.setContractSubjectMatter(subjectMatterList);
		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)) {
			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);

		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();
	}

	public void takeEffect(Long id) {
		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")) {
			handleWaterHouseCycle(contract,subjectMatterList);
			return;
		}
		//资金明细
		savePaymentConfirm(contract);

		//合同推送子公司
		pushSubCompany(contract,subjectMatterList);

		//合同中心推送
//		pusnContractCenter(contract,subjectMatterList);

		contract.setNextScheduleName("发货前");
		baseMapper.updateById(contract);
	}

	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);
					}
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}).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();
			}
		}).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 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 (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;

					//循环日期
					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);
						}
					}
				}

			}
		}
	}

	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
	public R genCurrentOverdue() {
		List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery()
				.lt(ContractPaymentSchedule::getEffectiveEndDate, DateUtil.today())
				.ne(ContractPaymentSchedule::getPaymentStatus, "2")
				.ne(ContractPaymentSchedule::getPaymentStatus, 3));
		if (CollUtil.isNotEmpty(scheduleList)) {
			scheduleList.stream().forEach(contractPaymentSchedule -> {
				Contract contract = baseMapper.selectById(contractPaymentSchedule.getContractId());
				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);
						}
					}
				}
			});
		}
		return R.ok();
	}

	@Override
	public R refuseApproval(Long id) {
		Contract contract = baseMapper.selectById(id);
		contract.setContractStatus(0);
		baseMapper.updateById(contract);
		return R.ok();
	}

	@Override
	public R copyNewContract(Long id) {
		Contract oldContract = baseMapper.selectById(id);
		Contract newContract = BeanUtil.copyProperties(oldContract, Contract.class, "id", "createTime");
		newContract.setOutBoundAmout(new BigDecimal("0"));
		newContract.setPaidAmount(new BigDecimal("0"));
		newContract.setBillingStatus("1");
		newContract.setErpPushFlag("0");
		newContract.setContractStatus(0);
		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));
		subjectMatterList.stream().forEach(contractSubjectMatter -> {
			ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatter, ContractSubjectMatter.class, "id", "createTime");
			subjectMatter.setContractId(newContract.getId());
			subjectMatter.setDeliveryStatus(0);
			subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
			subjectMatter.setRemainingQuantity(new BigDecimal("0"));
			contractSubjectMatterMapper.insert(subjectMatter);
		});
		List<ContractPaymentSchedule> scheduleList = contractPaymentScheduleMapper.selectList(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, id));
		scheduleList.stream().forEach(contractPaymentSchedule -> {
			ContractPaymentSchedule schedule = BeanUtil.copyProperties(contractPaymentSchedule, ContractPaymentSchedule.class, "id", "createTime");
			schedule.setContractId(newContract.getId());
			schedule.setPaymentStatus(0);
			schedule.setActualAmount(new BigDecimal("0"));
			schedule.setEffectiveDate(null);
			schedule.setEffectiveEndDate(null);
			contractPaymentScheduleMapper.insert(schedule);
		});
		return R.ok();
	}

	@Override
	public void exportContractYMJJGCLWord(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("no", no);
			item.put("materialName", contractSubjectMatter.getMaterialName());
			item.put("guige", contractSubjectMatter.getSpecification());
			item.put("unit", contractSubjectMatter.getUnit());
			item.put("quantity", contractSubjectMatter.getQuantity());
			item.put("danzhong", contractSubjectMatter.getSingleWight());
			item.put("zongzhong", contractSubjectMatter.getTotalWight());
			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", contract.getPartyA());
		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("companyName", 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/ymj/ymjjgclht.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 genCycleReceiced() {
		List<ContractExecDate> execDateList = contractExecDateMapper.selectList(Wrappers.<ContractExecDate>lambdaQuery()
				.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()
						.eq(ContractSubjectMatter::getContractId, contractExecDate.getContractId())
						.eq(ContractSubjectMatter::getId, contractExecDate.getMatterId()));
				//生成抄表单
				if (StrUtil.isNotEmpty(subjectMatter.getMeterReadCode()) &&
						ObjUtil.isNotNull(subjectMatter.getMeterReadNum())) {
					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 {
					//创建收款节点
					//查询上次收款节点
					ContractPaymentSchedule lastSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery()
							.eq(ContractPaymentSchedule::getContractId, contract.getId())
							.orderByDesc(ContractPaymentSchedule::getCreateTime).last("limit 1"));
					ContractPaymentSchedule schedule = new ContractPaymentSchedule();
					schedule.setStageName("房租租赁缴费");
					schedule.setContractId(contract.getId());
					schedule.setContractName(contract.getContractName());
					schedule.setPlannedAmount(subjectMatter.getUnitPrice().multiply(subjectMatter.getQuantity()));
					schedule.setEffectiveEndDate(contractExecDate.getExecDate());
					schedule.setStageOrder(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();
					confirm.setBusinessType("房屋租赁应收");
					confirm.setBusGuestId(contract.getPartyAId());
					confirm.setBusGuestName(contract.getPartyA());
					confirm.setContractId(contract.getId());
					confirm.setContractName(contract.getContractName());
					confirm.setContractNo(contract.getContractNo());
					confirm.setScheduleId(schedule.getId());
					confirm.setScheduleName(schedule.getStageName());
					confirm.setConfirmTime(contractExecDate.getExecDate());
					confirm.setTransationAmount(subjectMatter.getUnitPrice().multiply(subjectMatter.getQuantity()));
					confirm.setTotalAmount(confirm.getTransationAmount().multiply(new BigDecimal("-1")));
					PaymentConfirm lastConfirm = paymentConfirmMapper.selectOne(Wrappers.<PaymentConfirm>lambdaQuery().eq(PaymentConfirm::getContractId, contract.getId())
							.orderByDesc(PaymentConfirm::getCreateTime).last("limit 1"));
					if (ObjUtil.isNotNull(lastConfirm)) {
						BigDecimal total = lastConfirm.getTotalAmount().add(confirm.getTotalAmount());
						if (total.compareTo(new BigDecimal("0")) > 0) {
							confirm.setAdvanceAmount(total);
							confirm.setTotalAmount(total);
						} else if (total.compareTo(new BigDecimal("0")) == 0) {
							confirm.setTotalAmount(total);
						} else {
							confirm.setReceivableAmount(total.multiply(new BigDecimal("-1")));
							confirm.setTotalAmount(total);
						}
						confirm.setCompId(contract.getCompId());
						paymentConfirmMapper.insert(confirm);
					} else {
						confirm.setReceivableAmount(confirm.getTransationAmount());
						confirm.setTotalAmount(confirm.getReceivableAmount().multiply(new BigDecimal("-1")));
						confirm.setCompId(contract.getCompId());
						paymentConfirmMapper.insert(confirm);
					}
				}
				contractExecDate.setGenFlag("1");
				contractExecDateMapper.updateById(contractExecDate);
				contract.setBillingStatus("2");
				baseMapper.updateById(contract);
			});
		}
		return R.ok();
	}

	@Override
	public void exportContractYMJGYPMMWord(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("no", no);
			item.put("materialName", contractSubjectMatter.getMaterialName());
			item.put("guige", contractSubjectMatter.getSpecification());
			item.put("unit", contractSubjectMatter.getUnit());
			item.put("quantity", contractSubjectMatter.getQuantity());
			item.put("danzhong", contractSubjectMatter.getSingleWight());
			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());
			}
			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/ymj/ymjgypmmht.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 exportContractYMJGKCPMMWord(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()));
		map.put("deliveryCycle", contract.getDeliveryCycle());
		//标的物
		List<Map<String, Object>> items = new ArrayList<>();
		AtomicReference<Integer> no = new AtomicReference<>(0);
		subjectMatterList.stream().forEach(contractSubjectMatter -> {
			Map<String, Object> item = new HashMap<>();
			item.put("no", no);
			item.put("materialName", contractSubjectMatter.getMaterialName());
			item.put("guige", contractSubjectMatter.getSpecification());
			item.put("unit", contractSubjectMatter.getUnit());
			item.put("quantity", contractSubjectMatter.getQuantity());
			item.put("danzhong", contractSubjectMatter.getSingleWight());
			item.put("zongzhong", contractSubjectMatter.getTotalWight());
			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/ymj/ymjgkcpmmht.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 exportContractYMJCGWord(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()));
		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"));
			Map<String, Object> item = new HashMap<>();
			item.put("no", no);
			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("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())))
					.setScale(2, RoundingMode.HALF_UP));
			item.put("deliveryDate", DateUtil.formatDate(contractSubjectMatter.getPlannedDeliveryDate()));
			item.put("remarks", contractSubjectMatter.getRemarks());
			map.put("taxRate", product.getTaxRate());
			items.add(item);
			no.updateAndGet(v -> v + 1);
		});

		//付款
		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("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("zbjbl", contractPaymentSchedule.getPaymentRatio());
				map.put("zbjje", contractPaymentSchedule.getPlannedAmount());
				map.put("zbjjr", contractPaymentSchedule.getAgreedDays());
			}
		});
		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/ymj/ymjcght.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 delayOutApproval(DelayOutApprovalDTO dto) {
		Contract contract = baseMapper.selectById(dto.getContractId());
		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("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);
		paramDto.setFlowName(FlowNameEnum.延期出货审批.name());
		R r1 = remoteFlowProcessService.startProcessInstance(paramDto);
		if (r1.getCode() == 1) {
			return R.failed("流程启动失败");
		}
		contractDelayOutMapper.insert(delayOut);
		return R.ok();
	}

	@Override
	public Page pageScope(Page page, ContracQueryDTO queryDTO) {
		return baseMapper.pageScope(page, queryDTO, DataScope.of("comp_id"));
	}

	@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);
	}
}