feat:抵抹账条件新增付款金额小于开票金额，红票审核拒绝后蓝票可重新开红票

shiyunteng

2026-06-10 6b969ca247b98e5a793e61ec5b0d89f4fccb3318

 platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractServiceImpl.java

@@ -8,19 +8,23 @@
import cn.hutool.core.util.ObjUtil;
import cn.hutool.core.util.StrUtil;
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.feign.RemoteDeptService;
import com.by4cloud.platformx.business.api.feign.RemoteFlowProcessService;
import com.by4cloud.platformx.business.constant.FlowNameEnum;
import com.by4cloud.platformx.business.dto.ContracQueryDTO;
import com.by4cloud.platformx.business.dto.ContractAddDTO;
import com.by4cloud.platformx.business.dto.ContractUpdateDTO;
import com.by4cloud.platformx.business.dto.DelayOutApprovalDTO;
import com.by4cloud.platformx.business.entity.*;
import com.by4cloud.platformx.business.mapper.*;
import com.by4cloud.platformx.business.service.ContractService;
import com.by4cloud.platformx.business.utils.ContractNumberGenerator;
import com.by4cloud.platformx.business.vo.ContractDetailVo;
import com.by4cloud.platformx.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;
@@ -29,13 +33,13 @@
import com.deepoove.poi.plugin.table.LoopRowTableRenderPolicy;
import jakarta.servlet.http.HttpServletResponse;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.io.ClassPathResource;
import org.springframework.stereotype.Service;

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;
@@ -58,11 +62,9 @@
   private final MeterReadRecordMapper meterReadRecordMapper;
   private final ContractExecDateMapper contractExecDateMapper;
   private final RemoteFlowProcessService remoteFlowProcessService;
   private final ContractTemplateMapper contractTemplateMapper;
   private final ProductMapper productMapper;
   private final RemoteDeptService remoteDeptService;

   @Value("${file.local.base-path}")
   private String basePath;
   private final ContractDelayOutMapper contractDelayOutMapper;

   @Override
   public R add(ContractAddDTO addDTO) {
@@ -73,8 +75,12 @@
      contract.setPaidAmount(new BigDecimal("0"));
      contract.setBillingStatus("0");
      contract.setErpPushFlag("0");
      List<Contract> contracts;
      contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));

      if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && (
            StrUtil.equals(addDTO.getContractCategory(), "ymjgkcpmm")||StrUtil.equals(addDTO.getContractCategory(), "ymjgypmm"))) {
         contract.setExpirationDate(DateUtil.offsetDay(contract.getSignDate(),contract.getDeliveryCycle()));
      }
      List<Contract> contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
      while (ArrayUtil.isNotEmpty(contracts.toArray())) {
         contract.setContractNo(ContractNumberGenerator.generateContractNumber());
         contracts = baseMapper.selectList(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo, contract.getContractNo()));
@@ -101,6 +107,12 @@
               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);
            }
         });

@@ -143,9 +155,6 @@

      }

      if (StrUtil.isNotEmpty(addDTO.getContractCategory()) && StrUtil.equals(addDTO.getContractCategory(), "water_house")) {

      }

      return R.ok();
   }
@@ -179,6 +188,19 @@
            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);
            }
         });
      }

@@ -222,6 +244,10 @@
      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());
      }
      return detailVo;
   }

@@ -249,59 +275,112 @@
      if (StrUtil.isNotEmpty(contract.getContractCategory()) && StrUtil.equals(contract.getContractCategory(), "water_house")) {
         List<ContractSubjectMatter> subjectMatterList = contractSubjectMatterMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
               .eq(ContractSubjectMatter::getContractId,id));
         if (ArrayUtil.isNotEmpty(subjectMatterList.toArray())) {
            subjectMatterList.stream().forEach(contractSubjectMatter -> {

               //循环日期
               Date execDate0 = DateUtil.offsetDay(contract.getSignDate(), contract.getExecDay());
               for (int i = 0; i < contract.getExecTimes(); i++) {
                  if (StrUtil.equals(contract.getExecFrequency(), "1")) {
         if (ArrayUtil.isNotEmpty(subjectMatterList.toArray())) {
            for (ContractSubjectMatter contractSubjectMatter: subjectMatterList)  {
               if (StrUtil.equals(contract.getExecFrequency(), "1")) {
                  Long weeksTrue = DateUtil.betweenWeek(DateUtil.beginOfWeek(contract.getEffectiveDate()),
                        DateUtil.endOfWeek(contract.getExpirationDate()), true)+1;
                  //循环日期
                  Date execDate0 = DateUtil.offsetDay(DateUtil.beginOfWeek(contract.getEffectiveDate()), contract.getExecDay());
                  for (int i = 0; i < weeksTrue.intValue(); i++) {
                     Date execDatei = DateUtil.offsetWeek(execDate0, i);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     contractExecDateMapper.insert(execDate);
                  }
                  if (StrUtil.equals(contract.getExecFrequency(), "2")) {
                     Date execDatei = DateUtil.offsetMonth(execDate0, i );
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     contractExecDateMapper.insert(execDate);
                  }
                  if (StrUtil.equals(contract.getExecFrequency(), "3")) {
                     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");
                     contractExecDateMapper.insert(execDate);
                  }
                  if (StrUtil.equals(contract.getExecFrequency(), "4")) {
                     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");
                     contractExecDateMapper.insert(execDate);
                  }
                  if (StrUtil.equals(contract.getExecFrequency(), "5")) {
                     Date execDatei = DateUtil.offsetYear(execDate0, i);
                     ContractExecDate execDate = new ContractExecDate();
                     execDate.setContractId(contract.getId());
                     execDate.setMatterId(contractSubjectMatter.getId());
                     execDate.setExecDate(execDatei);
                     execDate.setGenFlag("0");
                     contractExecDateMapper.insert(execDate);
                     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);
                     }
                  }
               }

            }
         }
      } else {
         ContractPaymentSchedule fitstSchedule = contractPaymentScheduleMapper.selectOne(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId())
@@ -506,7 +585,6 @@
            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) {
               overdueConfirm.setCompId(contractPaymentSchedule.getCompId());
               paymentConfirmMapper.insert(overdueConfirm);
            }
            //当前逾期
@@ -525,7 +603,6 @@
            CurrentOverdue overdue = currentOverdueMapper.selectOne(Wrappers.<CurrentOverdue>lambdaQuery().eq(CurrentOverdue::getContractId, currentOverdue.getContractId())
                  .eq(CurrentOverdue::getScheduleId, currentOverdue.getScheduleId()).last("limit 1"));
            if (ObjUtil.isNull(overdue)) {
               currentOverdue.setCompId(contractPaymentSchedule.getCompId());
               if (currentOverdue.getReceivableAmount().compareTo(new BigDecimal("0")) > 0) {
                  currentOverdueMapper.insert(currentOverdue);
               }
@@ -607,11 +684,11 @@
         Map<String, Object> item = new HashMap<>();
         item.put("no", no);
         item.put("materialName", contractSubjectMatter.getMaterialName());
         item.put("guige", "");
         item.put("unit", "");
         item.put("guige", contractSubjectMatter.getSpecification());
         item.put("unit", contractSubjectMatter.getUnit());
         item.put("quantity", contractSubjectMatter.getQuantity());
         item.put("danzhong", "");
         item.put("zongzhong", "");
         item.put("danzhong", contractSubjectMatter.getSingleWight());
         item.put("zongzhong", contractSubjectMatter.getTotalWight());
         item.put("unitPrice", contractSubjectMatter.getUnitPrice());
         item.put("price", contractSubjectMatter.getTotalAmount());
         items.add(item);
@@ -620,7 +697,7 @@
      map.put("items", items);
      //定制方
      BusinessCustomer customer = businessCustomerMapper.selectById(contract.getPartyAId());
      map.put("companyName", customer.getCompanyName());
      map.put("companyName", customer.getRegisterName());
      map.put("legalPerson", customer.getLegalPerson());
      map.put("contactPhone", customer.getContactPhone());
      map.put("bankName", customer.getBankName());
@@ -646,7 +723,7 @@
      try {
         // 1. 加载模版
         // 假设模版在 resources/templates/template.docx
         ClassPathResource resource = new ClassPathResource("template/ymjjgclht.docx");
         ClassPathResource resource = new ClassPathResource("template/ymj/ymjjgclht.docx");
         // 配置列表策略
         Configure config = Configure.builder()
               .bind("items", new LoopRowTableRenderPolicy()) // 将 items 绑定到行循环策略
@@ -689,6 +766,25 @@
               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());
               contractPaymentScheduleMapper.insert(schedule);
               //房屋租赁生成应收
               PaymentConfirm confirm = new PaymentConfirm();
               confirm.setBusinessType("房屋租赁应收");
@@ -697,6 +793,8 @@
               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")));
@@ -728,4 +826,353 @@
      }
      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("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"));
   }

   public static void main(String[] args) {
      System.out.println(DateUtil.beginOfQuarter(DateUtil.parseDate("2026-06-05")));
      System.out.println(DateUtil.endOfQuarter(DateUtil.parseDate("2026-09-30")));
      System.out.println(DateUtil.betweenMonth(DateUtil.beginOfQuarter(DateUtil.parseDate("2026-06-05")),
            DateUtil.endOfQuarter(DateUtil.parseDate("2026-09-30")),true));
   }
}