platformx-business-finance-biz/src/main/java/com/by4cloud/platformx/business/service/impl/ContractServiceImpl.java
@@ -29,12 +29,14 @@
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.service.ContractSubjectMatterService;
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.excel.vo.ErrorMessage;
import com.by4cloud.platformx.common.security.util.SecurityUtils;
import com.by4cloud.platformx.flow.task.dto.ProcessInstanceParamDto;
import com.deepoove.poi.XWPFTemplate;
@@ -93,6 +95,8 @@
   private final ContractPaymentScheduleProcessService processService;
   private final ContractSubjectMatterChangeMapper changeMapper;
   private final ContractApprovalMapper contractApprovalMapper;
   private final TaxCodeMapper taxCodeMapper;
   private final ContractSubjectMatterService contractSubjectMatterService;
   @Value("${erp.ymj}")
   private String ymjErp;
@@ -157,8 +161,10 @@
   @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.equals(smjsc,SecurityUtils.getUser().getCompId()+"")&&!StrUtil.equals(smjzt,SecurityUtils.getUser().getCompId()+"")) {
         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)) {
@@ -789,7 +795,7 @@
            }
            if ((StrUtil.equals(contract.getPartyBId() + "", smj) ||
                  StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) && StrUtil.isNotEmpty(smjErp)) {
                  StrUtil.equals(contract.getPartyBId() + "", smjhw)) && StrUtil.isNotEmpty(smjErp)) {
               request.put("customerCode", customer.getErpCompanyCode());
               request.put("currencyId", "RMB");
               request.put("signDate", DateUtil.format(contract.getSignDate(), DatePattern.NORM_DATETIME_PATTERN));
@@ -1174,6 +1180,7 @@
            return;
         }
         currentConfim.setTotalAmount(currentConfim.getTransationAmount().multiply(new BigDecimal("-1")));
         currentConfim.setCompId(contract.getCompId());
         paymentConfirmMapper.insert(currentConfim);
         processService.handleBeforeRemain(currentConfim,contract);
      }
@@ -1914,6 +1921,10 @@
      if (CollUtil.isEmpty(addDTO.getContractSubjectMatter())) {
         return R.failed("请添加标的物");
      }
      if (addDTO.getContractSubjectMatter().stream().anyMatch(contractSubjectMatterAddDTO -> StrUtil.isBlank(contractSubjectMatterAddDTO.getDataId())&&
            StrUtil.isBlank(contractSubjectMatterAddDTO.getMaterialCode()))){
         return R.failed("标的物的dataId和materialCode不能同时为空");
      }
      if (CollUtil.isEmpty(addDTO.getContractPaymentSchedule())) {
         return R.failed("请添加付款阶段或付款阶段缺少");
      }
@@ -1968,23 +1979,18 @@
         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()+"");
               }
            Product product = productMapper.selectOne(Wrappers.<Product>lambdaQuery().eq(Product::getErpCode,subjectMatter.getMaterialCode())
                  .last("limit 1"));
            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);
@@ -2059,6 +2065,10 @@
      if (CollUtil.isEmpty(updateDTO.getContractSubjectMatter())) {
         return R.failed("请添加标的物");
      }
      if (updateDTO.getContractSubjectMatter().stream().anyMatch(contractSubjectMatterAddDTO -> StrUtil.isBlank(contractSubjectMatterAddDTO.getDataId())&&
            StrUtil.isBlank(contractSubjectMatterAddDTO.getMaterialCode()))){
         return R.failed("标的物的dataId和materialCode不能同时为空");
      }
      if (CollUtil.isEmpty(updateDTO.getContractPaymentSchedule())) {
         return R.failed("请添加付款阶段或付款阶段缺少");
      }
@@ -2076,6 +2086,7 @@
      }
      Contract contract = BeanUtil.copyProperties(updateDTO, Contract.class);
      contract.setId(contractOld.getId());
      contract.setContractNo(contractOld.getContractNo());
      if (ObjUtil.isNotNull(updateDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(updateDTO.getSignDate(), updateDTO.getDeliveryCycle()));
      }
@@ -2281,6 +2292,15 @@
      // 5. 拼接返回
      return "ZB-GYB-" + dateStr + seqStr;
   }
   public String generateBranchContractNo(String mainNo) {
      String key = mainNo;
      Long sequence = redisTemplate.opsForValue().increment(key, 1);
      // 4. 格式化序列号,不足6位前补0
      String seqStr = String.format("%04d", sequence);
      // 5. 拼接返回
      return mainNo +"-"+ seqStr;
   }
   @Override
@@ -2707,6 +2727,8 @@
      if (applyResp.getString("code").equals("00")) {
         contract.setCenterPushFlag("1");
         baseMapper.updateById(contract);
         //应收
         takeEffect(contract.getId());
         return R.ok();
      }
      log.error("工业泵推送——推送合同中心审核失败,原因为:{}",applyResp.getString("msg"));
@@ -2774,12 +2796,29 @@
               errList.add(map);
               continue;
            }
            BusinessCustomer bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery()
                  .eq(BusinessCustomer::getErpCompanyCode, contractExceVO.getBcErpCode()));
            BusinessCustomer bc = null;
            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)){
               List<String> smjList = new ArrayList<>();
               smjList.add(smj);
               smjList.add(smjsc);
               smjList.add(smjzt);
               smjList.add(smjhw);
               bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery()
                     .eq(BusinessCustomer::getCompanyName, contractExceVO.getBcErpCode())
                     .in(BusinessCustomer::getCompId, smjList)
                     .last("limit 1"));
            }else {
               bc = businessCustomerMapper.selectOne(Wrappers.<BusinessCustomer>lambdaQuery()
                     .eq(BusinessCustomer::getCompanyName, contractExceVO.getBcErpCode())
                     .eq(BusinessCustomer::getCompId,SecurityUtils.getUser().getCompId())
                     .last("limit 1"));
            }
            if (ObjUtil.isNull(bc)) {
               Map<String, String> map = new HashMap<String, String>();
               map.put("lineNum", "第" + (i + 1) + "行");
               map.put("errors", "客户erp编码不存在");
               map.put("errors", "客户名称不存在");
               errList.add(map);
               continue;
            }
@@ -2859,11 +2898,15 @@
            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)) {
               log.info("合同编号:{},标的物个数:{}",contract.getContractNo(),resultMatter.size());
               for (ContractSubjectMatterExceVO subMatEx : resultMatter
               ) {
                  if (StrUtil.isBlank(subMatEx.getDataId())&&StrUtil.isBlank(subMatEx.getMaterialCode())){
                     log.error("合同编号:{},标的物:{}标的物dataId和materialCode同时为空",contract.getContractNo(),subMatEx.getMaterialName());
                     continue;
                  }
                  ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(subMatEx, ContractSubjectMatter.class);
                  subjectMatter.setContractId(contract.getId());
                  subjectMatter.setDeliveredQuantity(StrUtil.isBlank(subMatEx.getDeliveredQuantity())
@@ -2873,25 +2916,13 @@
                        : 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);
//                     }
//                  }
                  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)) {
                     if (StrUtil.isBlank(subMatEx.getMaterialCode())) {
                        handleProduct(subMatEx.getMaterialCode());
                     }
                  }
               }
            }
@@ -2954,6 +2985,154 @@
      return R.ok();
   }
   private void handleProduct(String productCode) {
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
         List<String> smjList = new ArrayList<>();
         smjList.add(smj);
         smjList.add(smjhw);
         Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
               .eq(Product::getErpCode, productCode)
               .in(Product::getCompId, smjList)
               .last("limit 1"));
         if (ObjUtil.isNull(one)) {
            JSONObject object = contractSubjectMatterService.syncProductBySMJ("tenant1", productCode);
            if (ObjUtil.isNotNull(object)) {
               Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getProductName, object.getString("itemClassName"))
                     .eq(Product::getCompId, "2089995177814495234")
                     .last("limit 1")
               );
               if (ObjUtil.isNull(productClass)) {
                  log.info("产品分类:{}不存在", object.getString("itemClassName"));
                  productClass = new Product();
                  productClass.setProductName(object.getString("itemClassName"));
                  productClass.setErpCode(object.getString("itemClassName"));
                  productClass.setParentId(0L);
                  productClass.setCompId(2089995177814495234L);
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)) {
                     productClass.setTaxClass(taxCode.getSphwjc());
                     productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
                  }
                  productMapper.insert(productClass);
                  log.info("产品分类:{}新增成功", object.getString("itemClassName"));
               }
               log.info("产品:{}不存在", object.getString("itemNo"));
               Product productNew = new Product();
               productNew.setProductName(object.getString("note"));
               productNew.setErpCode(object.getString("itemNo"));
               productNew.setProductType(object.getString("grade"));
               productNew.setUnitName(object.getString("unitName"));
               productNew.setCompId(2089995177814495234L);
               productNew.setParentId(productClass.getId());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)) {
                  productClass.setTaxClass(taxCode.getSphwjc());
                  productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
               }
               productMapper.insert(productNew);
               log.info("产品:{}新增成功", object.getString("itemNo"));
            }
         }
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc)) {
         Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
               .eq(Product::getErpCode, productCode)
               .eq(Product::getCompId, smjsc)
               .last("limit 1"));
         if (ObjUtil.isNull(one)) {
            JSONObject object = contractSubjectMatterService.syncProductBySMJ("tenant2", productCode);
            if (ObjUtil.isNotNull(object)) {
               Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getProductName, object.getString("itemClassName"))
                     .eq(Product::getCompId, "2089996921978040321")
                     .last("limit 1")
               );
               if (ObjUtil.isNull(productClass)) {
                  log.info("产品分类:{}不存在", object.getString("itemClassName"));
                  productClass = new Product();
                  productClass.setProductName(object.getString("itemClassName"));
                  productClass.setErpCode(object.getString("itemClassName"));
                  productClass.setParentId(0L);
                  productClass.setCompId(2089996921978040321L);
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)) {
                     productClass.setTaxClass(taxCode.getSphwjc());
                     productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
                  }
                  productMapper.insert(productClass);
                  log.info("产品分类:{}新增成功", object.getString("itemClassName"));
               }
               log.info("产品:{}不存在", object.getString("itemNo"));
               Product productNew = new Product();
               productNew.setProductName(object.getString("note"));
               productNew.setErpCode(object.getString("itemNo"));
               productNew.setProductType(object.getString("grade"));
               productNew.setUnitName(object.getString("unitName"));
               productNew.setCompId(2089996921978040321L);
               productNew.setParentId(productClass.getId());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)) {
                  productClass.setTaxClass(taxCode.getSphwjc());
                  productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
               }
               productMapper.insert(productNew);
               log.info("产品:{}新增成功", object.getString("itemNo"));
            }
         }
      }
      if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)) {
         Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
               .eq(Product::getErpCode, productCode)
               .eq(Product::getCompId, smjzt)
               .last("limit 1"));
         if (ObjUtil.isNull(one)) {
            JSONObject object = contractSubjectMatterService.syncProductBySMJ("tenant3", productCode);
            if (ObjUtil.isNotNull(object)) {
               Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
                     .eq(Product::getProductName, object.getString("itemClassName"))
                     .eq(Product::getCompId, "2089997578009128962")
                     .last("limit 1")
               );
               if (ObjUtil.isNull(productClass)) {
                  log.info("产品分类:{}不存在", object.getString("itemClassName"));
                  productClass = new Product();
                  productClass.setProductName(object.getString("itemClassName"));
                  productClass.setErpCode(object.getString("itemClassName"));
                  productClass.setParentId(0L);
                  productClass.setCompId(2089997578009128962L);
                  TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
                  if (ObjUtil.isNotNull(taxCode)) {
                     productClass.setTaxClass(taxCode.getSphwjc());
                     productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
                  }
                  productMapper.insert(productClass);
                  log.info("产品分类:{}新增成功", object.getString("itemClassName"));
               }
               log.info("产品:{}不存在", object.getString("itemNo"));
               Product productNew = new Product();
               productNew.setProductName(object.getString("note"));
               productNew.setErpCode(object.getString("itemNo"));
               productNew.setProductType(object.getString("grade"));
               productNew.setUnitName(object.getString("unitName"));
               productNew.setCompId(2089997578009128962L);
               productNew.setParentId(productClass.getId());
               TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
               if (ObjUtil.isNotNull(taxCode)) {
                  productClass.setTaxClass(taxCode.getSphwjc());
                  productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
               }
               productMapper.insert(productNew);
               log.info("产品:{}新增成功", object.getString("itemNo"));
            }
         }
      }
   }
   @Override
   public R subjectChange(ContractSubjectChangeDTO changeDTO) {
@@ -3009,10 +3188,10 @@
   @Override
   public R syncContractStatus(SyncContractStatusDTO dto) {
      log.info("合同审批结果同步,合同编号:{},审批结果:{}",dto.getContractNumber(),dto.getStatus());
      if (StrUtil.isBlank(dto.getFd_bizId())){
         return R.failed("数据ID不能为空");
      }
      log.info("合同审批结果同步,合同数据ID:{},审批结果:{}",dto.getFd_bizId(),dto.getStatus());
      if (StrUtil.isBlank(dto.getStatus())){
         return R.failed("审批状态不能为空");
      }
@@ -3023,20 +3202,29 @@
         return R.failed("审批时间不能为空");
      }
      Contract contract = baseMapper.selectById(dto.getFd_bizId());
      if(ObjUtil.isNull(contract)){
      if (ObjUtil.isNull(contract)) {
         return R.failed("数据ID异常");
      }
      if (StrUtil.equals(dto.getStatus(),"1")){
         takeEffect(contract.getId());
      if (StrUtil.equals(dto.getStatus(), "1")) {
         new Thread(() -> {
            takeEffect(contract.getId());
            saveContractApproval(contract,dto);
         }).start();
      }
      if (StrUtil.equals(dto.getStatus(),"2")){
         refuseApproval(contract.getId());
      if (StrUtil.equals(dto.getStatus(), "2")) {
         new Thread(() -> {
            refuseApproval(contract.getId());
            saveContractApproval(contract,dto);
         }).start();
      }
      if (StrUtil.equals(dto.getStatus(),"3")||StrUtil.equals(dto.getStatus(),"4")){
         contract.setContractStatus(3);
         baseMapper.updateById(contract);
      if (StrUtil.equals(dto.getStatus(), "3") || StrUtil.equals(dto.getStatus(), "4")) {
         new Thread(() -> {
            contract.setContractStatus(3);
            baseMapper.updateById(contract);
            saveContractApproval(contract,dto);
         }).start();
      }
      saveContractApproval(contract,dto);
      return R.ok();
   }
@@ -3063,6 +3251,8 @@
      contract.setReviewerNo(attDTO.getReviewerNo());
      contract.setLinkPerson(attDTO.getLinkPerson());
      contract.setLinkPhone(attDTO.getLinkPhone());
      contract.setLastAttachmentName(attDTO.getLastAttachmentName());
      contract.setLastAttachmentUrl(attDTO.getLastAttachmentUrl());
      Long betweenDay = DateUtil.betweenDay(attDTO.getExpirationDate(),attDTO.getSignDate(),true);
      contract.setDeliveryCycle(betweenDay.intValue());
      baseMapper.updateById(contract);
@@ -3103,9 +3293,6 @@
      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"));
@@ -3241,6 +3428,11 @@
   @Override
   public R addContractHis(ContractAddDTO addDTO) {
      Contract contract1 = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo,addDTO.getContractNo())
            .last("limit 1"));
      if (ObjUtil.isNotNull(contract1)){
         return R.failed("合同编号已存在");
      }
      Contract contract = BeanUtil.copyProperties(addDTO, Contract.class);
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
@@ -3383,4 +3575,428 @@
      objVo.setLinkPartyC(selectVoList);
      return R.ok(objVo);
   }
   @Override
   public List<ContractExportExceVO> export(ContracQueryDTO queryDTO) {
      return baseMapper.export(queryDTO, DataScope.of("comp_id"));
   }
   @Override
   public R addContractHisNoCenter(ContractAddDTO addDTO) {
      Contract contract1 = baseMapper.selectOne(Wrappers.<Contract>lambdaQuery().eq(Contract::getContractNo,addDTO.getContractNo())
            .last("limit 1"));
      if (ObjUtil.isNotNull(contract1)){
         return R.failed("合同编号已存在");
      }
      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("0");
      contract.setContractStatus(0);
      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 updContractHisNoCenter(ContractUpdateDTO updateDTO) {
      Contract contract = BeanUtil.copyProperties(updateDTO, Contract.class);
      contract.setPartyBId(SecurityUtils.getUser().getCompId());
      contract.setPartyB(SecurityUtils.getUser().getCompName());
      contract.setBillingStatus("1");
      contract.setErpPushFlag("1");
      contract.setCenterPushFlag("0");
      contract.setContractStatus(0);
      contract.setNickName(SecurityUtils.getUser().getNickname());
      contract.setContractCategory("his_no_center");
      contract.setNextScheduleName("发货前");
      if (ObjUtil.isNotNull(updateDTO.getDeliveryCycle())) {
         contract.setExpirationDate(DateUtil.offsetDay(updateDTO.getSignDate(), updateDTO.getDeliveryCycle()));
      }
      if (CollUtil.isEmpty(updateDTO.getContractSubjectMatter())) {
         return R.failed("标的物不能为空");
      }
      baseMapper.insert(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(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(updateDTO.getContractPaymentSchedule())) {
         contractPaymentScheduleMapper.delete(Wrappers.<ContractPaymentSchedule>lambdaQuery().eq(ContractPaymentSchedule::getContractId, contract.getId()));
         for (int j = 0; j < updateDTO.getContractPaymentSchedule().size(); j++) {
            ContractPaymentSchedule schedule = new ContractPaymentSchedule();
            schedule.setStageName(updateDTO.getContractPaymentSchedule().get(j).getStageName());
            schedule.setContractId(contract.getId());
            schedule.setPaymentRatio(updateDTO.getContractPaymentSchedule().get(j).getPaymentRatio());
            schedule.setAgreedDays(updateDTO.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 (updateDTO.getContractPaymentSchedule().get(j).getStageName().equals("货到签收")) {
               contract.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (updateDTO.getContractPaymentSchedule().get(j).getStageName().equals("调试完成或验收")) {
               contract.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(contract);
            }
            if (updateDTO.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 addContractNoSgb(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 (addDTO.getContractSubjectMatter().stream().anyMatch(contractSubjectMatterAddDTO -> StrUtil.isBlank(contractSubjectMatterAddDTO.getDataId())&&
            StrUtil.isBlank(contractSubjectMatterAddDTO.getMaterialCode()))){
         return R.failed("标的物的dataId和materialCode不能同时为空");
      }
      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.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());
            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);
            }
         });
      }
      //推送合同中心
      return R.ok(contract.getContractNo());
   }
   @Override
   public R addContractOrder(ContractOrderAddDTO addDTO) {
      Contract main = baseMapper.selectById(addDTO.getParentId());
      Contract branch = BeanUtil.copyProperties(main,Contract.class,"id");
      branch.setPartyAId(addDTO.getPartyAId());
      branch.setPartyA(addDTO.getPartyA());
      branch.setAttachmentUrl(addDTO.getAttachmentUrl());
      branch.setAttachmentName(addDTO.getAttachmentName());
      branch.setRemark(addDTO.getRemark());
      branch.setParentId(addDTO.getParentId());
      branch.setContractNo(generateBranchContractNo(main.getContractNo()));
      baseMapper.insert(branch);
      if (CollUtil.isNotEmpty(addDTO.getContractSubjectMatter())) {
         addDTO.getContractSubjectMatter().stream().forEach(contractSubjectMatterAddDTO -> {
            ContractSubjectMatter subjectMatter = BeanUtil.copyProperties(contractSubjectMatterAddDTO, ContractSubjectMatter.class);
            subjectMatter.setContractId(branch.getId());
            subjectMatter.setLineNo(ItemGeneratorUtil.nextId());
            subjectMatter.setDeliveredQuantity(new BigDecimal("0"));
            subjectMatter.setDeliveryStatus(0);
            subjectMatter.setTotalAmount(contractSubjectMatterAddDTO.getQuantity().multiply(contractSubjectMatterAddDTO.getUnitPrice()));
            contractSubjectMatterMapper.insert(subjectMatter);
         });
         branch.setAmount(addDTO.getContractSubjectMatter().stream().map(item -> item.getUnitPrice().multiply(item.getQuantity()))
               // 累加所有金额,设置初始值为0
               .reduce(BigDecimal.ZERO, BigDecimal::add));
         baseMapper.updateById(branch);
      }
      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(branch.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(branch.getId());
            schedule.setContractName(branch.getContractName());
            schedule.setPlannedAmount(branch.getAmount().multiply(schedule.getPaymentRatio().divide(new BigDecimal("100"))));
            schedule.setStageOrder(currentIndex);
            contractPaymentScheduleMapper.insert(schedule);
            if (contractPaymentScheduleAddDTO.getStageName().equals("货到签收")) {
               branch.setArrivalScheduleId(schedule.getId());
               baseMapper.updateById(branch);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("调试完成或验收")) {
               branch.setAcceptScheduleId(schedule.getId());
               baseMapper.updateById(branch);
            }
            if (contractPaymentScheduleAddDTO.getStageName().equals("质保金")) {
               branch.setWarrantyScheduleId(schedule.getId());
               baseMapper.updateById(branch);
            }
         });
      }
      return R.ok();
   }
}