java-insagent-pc/src/main/java/com/ydtech/modules/protocol/service/impl/PtlAgreementServiceImpl.java

package com.ydtech.modules.protocol.service.impl;

import cn.hutool.core.date.DateUtil;
import com.alibaba.fastjson.JSONArray;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ydtech.config.DictEnumConfig;
import com.ydtech.constants.enums.dict.DictionaryData;
import com.ydtech.constants.enums.dict.DictionaryManagement;
import com.ydtech.constants.enums.dict.agreement.AgreementType;
import com.ydtech.core.page.HttpResult;
import com.ydtech.core.page.PageResult;
import com.ydtech.exception.SystemException;
import com.ydtech.modules.esm.model.EsmInsCompany;
import com.ydtech.modules.esm.service.EsmInsCompanyService;
import com.ydtech.modules.order.service.InsCrawlerOrderService;
import com.ydtech.modules.protocol.constants.HistoryStatusConstants;
import com.ydtech.modules.protocol.dao.PtlAgreementMapper;
import com.ydtech.modules.protocol.entity.constants.PtlApiType;
import com.ydtech.modules.protocol.entity.dto.PtlAgreementAttributionDto;
import com.ydtech.modules.protocol.entity.dto.PtlAgreementDto;
import com.ydtech.modules.protocol.entity.dto.PtlAgreementInsCompanyDto;
import com.ydtech.modules.protocol.entity.dto.PtlAgreementSaveDto;
import com.ydtech.modules.protocol.entity.dto.history.PtlAgreementUndwrtRulesHistory;
import com.ydtech.modules.protocol.entity.po.*;
import com.ydtech.modules.protocol.entity.vo.*;
import com.ydtech.modules.protocol.service.*;
import com.ydtech.modules.protocol.utils.AssertionUtils;
import com.ydtech.modules.protocols.entity.po.PtlAgreementProductCostsNew;
import com.ydtech.modules.protocols.service.PtlAgreementProductCostsNewService;
import com.ydtech.utils.idgen.IdGenerate;
import org.apache.commons.lang3.ObjectUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Lazy;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.*;
import java.util.stream.Collectors;


/**
 * @author wenks
 * @description 针对表【ptl_agreement(协议信息表)】的数据库操作Service实现
 * @createDate 2023-06-05 17:59:52
 */
@Service
public class PtlAgreementServiceImpl extends ServiceImpl<PtlAgreementMapper, PtlAgreement> implements PtlAgreementService {

    private final PtlAgreementProductCostsService ptlAgreementProductCostsService;

    private final PtlAgreementAttributionService ptlAgreementAttributionService;

    private final PtlAgreementDeptService ptlAgreementDeptService;

    private final EsmInsCompanyService esmInsCompanyService;

    private final InsCrawlerOrderService insCrawlerOrderController;

    private final PtlAgreementService proxyObject;

    private final PtlAgreementHistoryService ptlAgreementHistoryService;

    private final PtlNonCarInsuranceProductService ptlNonCarInsuranceProductService;

    private final PtlAgreementNonCarProductCostsService ptlAgreementNonCarProductCostsService;

    private final PtlAgreementUndwrtRulesService ptlAgreementUndwrtRulesService;

    private final PtlAgreementProductCostsHistoryService ptlAgreementProductCostsHistoryService;

    private final PtlAgreementUndwrtRulesHistoryService ptlAgreementUndwrtRulesHistoryService;

    private final PtlAgreementAttributionHistoryService ptlAgreementAttributionHistoryService;

    @Autowired
    private  PtlAgreementDeptHistoryService ptlAgreementDeptHistoryService;


    public PtlAgreementServiceImpl(PtlAgreementProductCostsService ptlAgreementProductCostsService,
                                   PtlAgreementAttributionService ptlAgreementAttributionService, PtlAgreementDeptService ptlAgreementDeptService,
                                   EsmInsCompanyService esmInsCompanyService, PtlAgreementNonCarProductCostsService ptlAgreementNonCarProductCostsService,
                                   @Lazy InsCrawlerOrderService insCrawlerOrderController, @Lazy PtlAgreementService proxyObject,PtlNonCarInsuranceProductService ptlNonCarInsuranceProductService,@Lazy PtlAgreementUndwrtRulesService ptlAgreementUndwrtRulesService,
                                   PtlAgreementHistoryService ptlAgreementHistoryService,PtlAgreementProductCostsHistoryService ptlAgreementProductCostsHistoryService,
                                   PtlAgreementUndwrtRulesHistoryService ptlAgreementUndwrtRulesHistoryService,PtlAgreementAttributionHistoryService ptlAgreementAttributionHistoryService) {
        this.ptlAgreementProductCostsService = ptlAgreementProductCostsService;
        this.ptlAgreementAttributionService = ptlAgreementAttributionService;
        this.ptlAgreementDeptService = ptlAgreementDeptService;
        this.esmInsCompanyService = esmInsCompanyService;
        this.ptlAgreementNonCarProductCostsService = ptlAgreementNonCarProductCostsService;
        this.insCrawlerOrderController = insCrawlerOrderController;
        this.proxyObject = proxyObject;
        this.ptlNonCarInsuranceProductService=ptlNonCarInsuranceProductService;
        this.ptlAgreementUndwrtRulesService=ptlAgreementUndwrtRulesService;
        this.ptlAgreementHistoryService = ptlAgreementHistoryService;
        this.ptlAgreementProductCostsHistoryService = ptlAgreementProductCostsHistoryService;
        this.ptlAgreementUndwrtRulesHistoryService = ptlAgreementUndwrtRulesHistoryService;
        this.ptlAgreementAttributionHistoryService=ptlAgreementAttributionHistoryService;
    }


    @Override
    public List<PtlAgreementInsCompanyDto> getAgreementCompany(String deptId) {
        LocalDate localDate = LocalDate.now();
        List<PtlAgreementInsCompanyDto> agreementCompany = baseMapper.getAgreementCompany(localDate, deptId);

        for (PtlAgreementInsCompanyDto ptlAgreementInsCompanyDto : agreementCompany) {
            List<PtlAgreementDto> agreement = ptlAgreementInsCompanyDto.getAgreement();
            for (PtlAgreementDto ptlAgreementDto : agreement) {
                if (ptlAgreementDto.getProductsCode() != null && !ptlAgreementDto.getProductsCode().equals("")) {
                    String[] split = ptlAgreementDto.getProductsCode().split(",");
                    ptlAgreementDto.setProductsCodes(split);
                }
            }
        }

        List<String> agreementIdList = agreementCompany.stream()
                .flatMap(x -> x.getAgreement().stream().map(PtlAgreementDto::getId))
                .collect(Collectors.toList());

        /*Map<String, List<String>> licenseNoList = ptlAgreementUndwrtRulesService.getByLicenseNo(agreementIdList);

        agreementCompany.forEach(
                x -> x.getAgreement().forEach(a -> a.setLicenseNo(licenseNoList.get(a.getId())))
        );*/

        return agreementCompany;
    }

    @Override
    public PtlAgreementInsCompanyDto getAgreementCompany(String deptId,String companyId) {
        LocalDate localDate = LocalDate.now();
        PtlAgreementInsCompanyDto agreementCompany = baseMapper.getAgreementCompanyByCompanyId(localDate, deptId,companyId);
        return agreementCompany;
    }

    @Override
    public PtlAgreement ifExistsById(String agreementId) {
        PtlAgreement ptlAgreement = getById(agreementId);
        if (ObjectUtils.isEmpty(ptlAgreement)) {
            throw new SystemException("协议id 不存在");
        }
        return ptlAgreement;
    }

    @Override
    @Transactional
    public HttpResult<Object> saveAgreement(PtlAgreementSaveVo agreement, String userName) {
        PtlAgreementSaveDto agreementSaveDto = agreement.getAgreement();
        PtlAgreementAttributionDto attribution = agreement.getAttribution();
        PtlAgreement ptlAgreement = new PtlAgreement();
        BeanUtils.copyProperties(agreementSaveDto, ptlAgreement);

        EsmInsCompany esmInsCompany = proxyObject.verifyLogin(ptlAgreement, agreementSaveDto, attribution);
//        ptlAgreement.setId(IdGenerate.nextId());
        ptlAgreement.setProductsCode(agreementSaveDto.getProductsCode());
        ptlAgreement.setCreator(userName);
        ptlAgreement.setCreateTime(LocalDateTime.now());
        save(ptlAgreement);
        // 提交  账号信息 授权部门
        proxyObject.saveAssociationInformation(ptlAgreement.getId(), esmInsCompany,agreement);
        // 添加 历史记录表
        //生成批次号
        String batchNo = IdGenerate.nextId();
        //添加授权部门历史信息
        List<String> dept = agreement.getDept();
        List<PtlAgreementDeptHistory> ptlAgreementDeptList = PtlAgreementDeptHistory.toPtlAgreementDeptHistoryList(ptlAgreement.getId(), dept, batchNo);
        ptlAgreementDeptHistoryService.saveBatch(ptlAgreementDeptList);
        PtlAgreementHistory ptlAgreementHistory = new PtlAgreementHistory(batchNo, userName, HistoryStatusConstants.HISTORY_TYPE_ADD, ptlAgreement);
        ptlAgreementHistory.setStartDate(ptlAgreement.getStartDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setEndDate(ptlAgreement.getEndDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setAgreementId(ptlAgreement.getId());
        ptlAgreementHistory.setId(IdGenerate.nextId());
        ptlAgreementHistory.setOperatorType("add");
        ptlAgreementHistoryService.saveAgreementHistory(ptlAgreementHistory);
        PtlAgreementAttributionHistory ptlAgreementAttributionHistory = new PtlAgreementAttributionHistory(batchNo,ptlAgreement.getId(),esmInsCompany.getId(),esmInsCompany.getName(),agreement.getAttribution());
        ptlAgreementAttributionHistory.setId(IdGenerate.nextId());
        if (StringUtils.isNotEmpty(attribution.getTemplateId())) {
            ptlAgreementAttributionHistoryService.save(ptlAgreementAttributionHistory);
        }

        return HttpResult.ok("添加成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> saveAgreementProduct(PtlAgreementProductCosts ptlAgreementProductCosts, String userName) {

        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, ptlAgreementProductCosts.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        // 产品费用
        ptlAgreementProductCostsService.save(ptlAgreementProductCosts);
        // 添加 历史记录表
        PtlAgreementProductCostsHistory history = new PtlAgreementProductCostsHistory(userName, DateUtil.format(new Date(), "yyyy-MM-dd HH:mm:ss"),
                HistoryStatusConstants.HISTORY_TYPE_UPDATE,ptlAgreementProductCosts);
        ptlAgreementProductCostsHistoryService.save(history);
        return HttpResult.ok("添加成功");
    }

    @Override
    public HttpResult<Object> updateAgreementProduct(PtlAgreementProductCosts agreement, String userName) {
        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, agreement.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        // 产品费用
        ptlAgreementProductCostsService.updateById(agreement);
        // 添加 历史记录表
        PtlAgreementProductCostsHistory history = new PtlAgreementProductCostsHistory(userName, DateUtil.format(new Date(), "yyyy-MM-dd HH:mm:ss"),
                HistoryStatusConstants.HISTORY_TYPE_UPDATE,agreement);
        ptlAgreementProductCostsHistoryService.save(history);
        return HttpResult.ok("修改成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> deleteAgreementProduct(String id,String userName) {
        PtlAgreementProductCosts ptlAg=ptlAgreementProductCostsService.getById(id);
        if(ptlAg==null){
            throw new SystemException("协议产品费用不存在");
        }
        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, ptlAg.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        //删除协议
        ptlAgreementProductCostsService.removeById(id);
        PtlAgreementProductCostsHistory history = new PtlAgreementProductCostsHistory(userName, DateUtil.format(new Date(), "yyyy-MM-dd HH:mm:ss"),
                HistoryStatusConstants.HISTORY_TYPE_DELETE,ptlAg);
        ptlAgreementProductCostsHistoryService.save(history);
        return HttpResult.ok("删除成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> saveAgreementNonCarProductCosts(PtlAgreementNonVehicleProductCostsVo agreement, String userName) {
        //同步刷新其他协议非车产品费用信息(有待同步协议时，进行同步)
        if(agreement.getSyncAgreementIds()!=null&&agreement.getSyncAgreementIds().size()>0){
            for(int i=0;i<agreement.getSyncAgreementIds().size();i++){
                String tempAgreementId=agreement.getSyncAgreementIds().get(i);
                PtlAgreement destAgreement= getById(tempAgreementId);
                //根据归属保司，找出本级和上级 所有产品代码
                //先获取相关保险公司列表
                String companyId=destAgreement.getPartnerCompaniesId();
                if(destAgreement.getAssociationCompaniesId()!=null&&!"".equals(destAgreement.getAssociationCompaniesId())){
                    companyId=destAgreement.getAssociationCompaniesId();
                }
                List<String> companyIdList=esmInsCompanyService.getAllRelationCompanyId(companyId);
                //再根据保险公司列表获取所有非车产品列表
                List<PtlNonCarInsuranceProduct> productList=ptlNonCarInsuranceProductService.findProductListByCompangIds(companyIdList);
                List<PtlAgreementNonCarProductCostsSaveVo> finalList=new ArrayList<>();
                //按找出的产品过滤传进来的 费用方案列表
                for(PtlNonCarInsuranceProduct tempProductDto:productList){
                    for(PtlAgreementNonCarProductCostsSaveVo productCostDto:agreement.getNonCarProductCosts()){
                        if(productCostDto.getProductId().equals(tempProductDto.getProductCode())){
                            finalList.add(productCostDto);
                        }
                    }
                }
                ptlAgreementNonCarProductCostsService.synNonCarProductCosts(destAgreement,finalList);
            }
        }

        return HttpResult.ok("添加成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> saveAgreementUndwrtRules(PtlAgreementUndwrtRules ptlAgreementUndwrtRules, String userName) {
        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, ptlAgreementUndwrtRules.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        //添加承保规则
        ptlAgreementUndwrtRulesService.save(ptlAgreementUndwrtRules);
        //添加历史记录
        PtlAgreementUndwrtRulesHistory ptlAgreementUndwrtRulesHistory=new PtlAgreementUndwrtRulesHistory(userName,HistoryStatusConstants.HISTORY_TYPE_ADD,ptlAgreementUndwrtRules);
        ptlAgreementUndwrtRulesHistoryService.save(ptlAgreementUndwrtRulesHistory);
        return HttpResult.ok("添加成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> updateAgreementUndwrtRules(PtlAgreementUndwrtRules ptlAgreementUndwrtRules, String userName) {
        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, ptlAgreementUndwrtRules.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        //添加承保规则
        ptlAgreementUndwrtRulesService.updateById(ptlAgreementUndwrtRules);
        //添加历史记录
        PtlAgreementUndwrtRulesHistory ptlAgreementUndwrtRulesHistory=new PtlAgreementUndwrtRulesHistory(userName,HistoryStatusConstants.HISTORY_TYPE_UPDATE,ptlAgreementUndwrtRules);
        ptlAgreementUndwrtRulesHistoryService.save(ptlAgreementUndwrtRulesHistory);
        return HttpResult.ok("修改成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> deleteAgreementUndwrtRules(String id, String userName) {
        PtlAgreementUndwrtRules ptlAgreementUndwrtRules = ptlAgreementUndwrtRulesService.getOne(new LambdaQueryWrapper<PtlAgreementUndwrtRules>().eq(PtlAgreementUndwrtRules::getId, id));
        if(ptlAgreementUndwrtRules==null){
            throw new SystemException("协议承保规则不存在");
        }
        PtlAgreement ptlAgreement = baseMapper.selectOne(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getId, ptlAgreementUndwrtRules.getAgreementId()));
        if(ptlAgreement==null){
            throw new SystemException("协议不存在");
        }
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        //更新协议信息
        baseMapper.updateById(ptlAgreement);
        //删除承保规则
        ptlAgreementUndwrtRulesService.removeById(id);
        //添加历史记录
        PtlAgreementUndwrtRulesHistory ptlAgreementUndwrtRulesHistory=new PtlAgreementUndwrtRulesHistory(userName,HistoryStatusConstants.HISTORY_TYPE_DELETE,ptlAgreementUndwrtRules);
        ptlAgreementUndwrtRulesHistoryService.save(ptlAgreementUndwrtRulesHistory);
        return HttpResult.ok("删除成功");
    }

    @Override
    public HttpResult<PageResult<PtlAgreement>> pageAgreement(PtlAgreementPageVo ptlAgreementPageVo) {
        int pageNum = ptlAgreementPageVo.getPageNum();
        int pageSize = ptlAgreementPageVo.getPageSize();
        LambdaQueryWrapper<PtlAgreement> wrapper = new LambdaQueryWrapper<>();
        // 获取供应商本级id 及其 下级id
        List<String> lowerId = esmInsCompanyService.getByLowerId(ptlAgreementPageVo.getPartnerCompaniesId());
        // 审核状态
        wrapper.eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getAuditStatus()), PtlAgreement::getAuditStatus, ptlAgreementPageVo.getAuditStatus())
                //是否有效
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getValidStatus()), PtlAgreement::getValidStatus, ptlAgreementPageVo.getValidStatus())
                // 供应商类型
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getCompaniesType()), PtlAgreement::getCompaniesType, ptlAgreementPageVo.getCompaniesType())
                // 协议类型
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getAgreementType()), PtlAgreement::getAgreementType, ptlAgreementPageVo.getAgreementType())
                // 录入人
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getCreator()), PtlAgreement::getCreator, ptlAgreementPageVo.getCreator())
                // 修改人
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getModifiedBy()), PtlAgreement::getModifiedBy, ptlAgreementPageVo.getModifiedBy())
                // 合作公司
                .in(!StringUtils.isEmpty(ptlAgreementPageVo.getPartnerCompaniesId()) && !lowerId.isEmpty(), PtlAgreement::getPartnerCompaniesId, lowerId)
                // 录入时间
                .between(!ObjectUtils.isEmpty(ptlAgreementPageVo.getStartDate()) && !ObjectUtils.isEmpty(ptlAgreementPageVo.getEndDate()), PtlAgreement::getCreateTime, ptlAgreementPageVo.getStartDate(), ptlAgreementPageVo.getEndDate())
                // 修改时间
                .between(!ObjectUtils.isEmpty(ptlAgreementPageVo.getUpdateStarTime()) && !ObjectUtils.isEmpty(ptlAgreementPageVo.getUpdateEndTime()), PtlAgreement::getUpdateTime, ptlAgreementPageVo.getUpdateStarTime(), ptlAgreementPageVo.getUpdateEndTime())
                // 协议起期
                .ge(!ObjectUtils.isEmpty(ptlAgreementPageVo.getAgreementStartDate()), PtlAgreement::getStartDate, ptlAgreementPageVo.getAgreementStartDate())
                // 协议止期
                .le(!ObjectUtils.isEmpty(ptlAgreementPageVo.getAgreementEndDate()), PtlAgreement::getEndDate, ptlAgreementPageVo.getAgreementEndDate());

//        Page<PtlAgreement> ptlAgreementPage = new Page<>(pageNum, pageSize);
        List<PtlAgreement> records = list(wrapper);
//        Page<PtlAgreement> agreementPage = page(ptlAgreementPage, wrapper);
//        List<PtlAgreement> records = agreementPage.getRecords();
        if (ptlAgreementPageVo.getAreaCode() != null && !"".equals(ptlAgreementPageVo.getAreaCode()) && ptlAgreementPageVo.getLevel() != null) {
            String area = ptlAgreementPageVo.getAreaCode();
            String prefix = null;
            Integer sign = 0;
            switch (ptlAgreementPageVo.getLevel()) {
                case "1": { // 省级查询逻辑
                    sign = 7;
                    prefix = area.substring(0, 2);
                    break;
                }
                case "2": {  // 市级查询逻辑
                    sign = 9;
                    prefix = area.substring(0, 4);
                    break;
                }
                case "3": {  // 区县级查询逻辑
                    sign = 11;
                    prefix = area.substring(0, 6);
                    break;
                }
            }

            if (records.size() != 0) {
                List<PtlAgreement> ptlAgreements = new ArrayList<>();
                for (PtlAgreement record : records) {
                    String substring = record.getPartnerCompaniesId().substring(5, sign);
                    if (substring.equals(prefix)) {
                        ptlAgreements.add(record);
                    }
                }
                records.clear();
                records.addAll(ptlAgreements);
            }
        }
        List<PtlAgreement> paginate = paginate(records, pageNum, pageSize);

        PageResult<PtlAgreement> ptlAgreementPageResult = new PageResult<>(pageNum, pageSize, records.size(), paginate);
        return HttpResult.ok(ptlAgreementPageResult);
    }

    @Override
    public HttpResult<List<PtlAgreement>> listAgreement(PtlAgreementPageVo ptlAgreementPageVo){
        LambdaQueryWrapper<PtlAgreement> wrapper = new LambdaQueryWrapper<>();
        // 获取供应商本级id 及其 下级id
        List<String> lowerId = esmInsCompanyService.getByLowerId(ptlAgreementPageVo.getPartnerCompaniesId());
        // 审核状态
        wrapper.eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getAuditStatus()), PtlAgreement::getAuditStatus, ptlAgreementPageVo.getAuditStatus())
                //是否有效
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getValidStatus()), PtlAgreement::getValidStatus, ptlAgreementPageVo.getValidStatus())
                // 供应商类型
                .eq(!ObjectUtils.isEmpty(ptlAgreementPageVo.getCompaniesType()), PtlAgreement::getCompaniesType, ptlAgreementPageVo.getCompaniesType())
                // 合作公司
                .in(!StringUtils.isEmpty(ptlAgreementPageVo.getPartnerCompaniesId()) && !lowerId.isEmpty(), PtlAgreement::getPartnerCompaniesId, lowerId)
                // 录入时间
                .between(!ObjectUtils.isEmpty(ptlAgreementPageVo.getStartDate()) && !ObjectUtils.isEmpty(ptlAgreementPageVo.getEndDate()), PtlAgreement::getCreateTime, ptlAgreementPageVo.getStartDate(), ptlAgreementPageVo.getEndDate());

        List<PtlAgreement> agreementPage = list(wrapper);
        return HttpResult.ok(agreementPage);
    }

    @Override
    public HttpResult<PtlAgreementQueryVo> getByAgreementId(String agreementId) {
        PtlAgreement ptlAgreement = proxyObject.ifExistsById(agreementId);
//        // 获取产品费用
//        List<PltAgreementSchemeSaveDto> schemeQueryDto = ptlAgreementProductCostsService.getByAgreementId(agreementId);
//        // 获取非车险产品费用
//        List<PtlAgreementNonCarProductCosts> nonCarProductCosts = ptlAgreementNonCarProductCostsService.getByAgreementId(agreementId);
//        // 获取承保规则
//        List<PtlAgreementUndwrtRulesSaveDto> underwritingRules = ptlAgreementUndwrtRulesService.getByAgreementId(agreementId);
        //  账号信息查询
        PtlAgreementAttribution ptlAgreementAttribution = ptlAgreementAttributionService.getById(agreementId);
        //2023-08-28 lig 增加  解决前端空对象为null问题，改为返回为空对象
        if (null == ptlAgreementAttribution) {
            ptlAgreementAttribution = new PtlAgreementAttribution();
            ptlAgreementAttribution.setId("");
            ptlAgreementAttribution.setInsCompanyId("");
            ptlAgreementAttribution.setInsCompanyName("");
            ptlAgreementAttribution.setTemplateId("");
            ptlAgreementAttribution.setApiType(1);
            ptlAgreementAttribution.setFields(new JSONArray());
            ptlAgreementAttribution.setUsername("");
            ptlAgreementAttribution.setPassword("");

        }
        // 授权查询
        List<PtlAgreementDept> deptList = ptlAgreementDeptService.getByAgreementId(agreementId);
        PtlAgreementQueryVo ptlAgreementQueryVo = new PtlAgreementQueryVo(ptlAgreement,ptlAgreementAttribution, deptList);
        return HttpResult.ok(ptlAgreementQueryVo);
    }

    @Override
    @Transactional
    public HttpResult<Object> deleteAgreement(String agreementId,String userName) {
        proxyObject.ifExistsById(agreementId);
        HttpResult<PtlAgreementQueryVo> byAgreementId = getByAgreementId(agreementId);

        boolean b = removeById(agreementId);
        AssertionUtils.isSucceed(b, "协议信息删除失败");
        // 关联表删除
        proxyObject.deleteAssociationInformation(agreementId);
        // 添加 历史记录表
        //生成批次号
        String batchNo = IdGenerate.nextId();
        List<PtlAgreementDept> dept = byAgreementId.getData().getDept();
        ArrayList<PtlAgreementDeptHistory> histories = new ArrayList<>();
        for (PtlAgreementDept ptlAgreementDept : dept) {
            PtlAgreementDeptHistory deptHistory = new PtlAgreementDeptHistory();
            deptHistory.setAgreementId(ptlAgreementDept.getAgreementId());
            deptHistory.setDeptId(ptlAgreementDept.getDeptId());
            deptHistory.setBatch(batchNo);
        }
        ptlAgreementDeptHistoryService.saveBatch(histories);
        PtlAgreementHistory ptlAgreementHistory = new PtlAgreementHistory(batchNo, userName, HistoryStatusConstants.HISTORY_TYPE_ADD, byAgreementId.getData().getAgreement());
        ptlAgreementHistory.setStartDate(byAgreementId.getData().getAgreement().getStartDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setEndDate(byAgreementId.getData().getAgreement().getEndDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setAgreementId(ptlAgreementHistory.getId());
        ptlAgreementHistory.setId(IdGenerate.nextId());
        ptlAgreementHistory.setOperatorType("delete");
        ptlAgreementHistoryService.saveAgreementHistory(ptlAgreementHistory);
        PtlAgreementAttributionHistory ptlAgreementAttributionHistory = new PtlAgreementAttributionHistory(batchNo,agreementId,
                byAgreementId.getData().getAgreement().getInsuranceCompanyId(),
                byAgreementId.getData().getAgreement().getInsuranceCompany(),
                byAgreementId.getData().getPtlAgreementAttribution()
        );
        ptlAgreementAttributionHistory.setId(IdGenerate.nextId());
        if (StringUtils.isNotEmpty(ptlAgreementAttributionHistory.getTemplateId())) {
            ptlAgreementAttributionHistoryService.save(ptlAgreementAttributionHistory);
        }
        return HttpResult.ok("删除成功");
    }

    @Override
    @Transactional
    public HttpResult<Object> reviseAgreement(String userName, String agreementId, PtlAgreementSaveVo agreement) {
        PtlAgreementSaveDto agreementSaveDto = agreement.getAgreement();
        PtlAgreementAttributionDto attribution = agreement.getAttribution();
        PtlAgreement ptlAgreement = proxyObject.ifExistsById(agreementId);
        BeanUtils.copyProperties(agreementSaveDto, ptlAgreement);

        EsmInsCompany esmInsCompany = proxyObject.verifyLogin(ptlAgreement, agreementSaveDto, attribution);

        ptlAgreement.setProductsCode(agreementSaveDto.getProductsCode());
        ptlAgreement.setModifiedBy(userName);
        ptlAgreement.setUpdateTime(LocalDateTime.now());
        HttpResult<PtlAgreementQueryVo> byAgreementId = this.getByAgreementId(agreementId);
        // 修改协议
        boolean b = updateById(ptlAgreement);
        AssertionUtils.isSucceed(b, "协议信息修改失败");
        // 关联表都是先删除后添加
        proxyObject.deleteAssociationInformationExcludeCosts(agreementId);
        // 提交 账号信息 授权部门
        proxyObject.saveAssociationInformation(agreementId, esmInsCompany, agreement);

        // 添加 历史记录表
        //生成批次号
        String batchNo = IdGenerate.nextId();
        //添加授权部门历史信息
        List<String> dept = agreement.getDept();
        List<PtlAgreementDeptHistory> ptlAgreementDeptList = PtlAgreementDeptHistory.toPtlAgreementDeptHistoryList(ptlAgreement.getId(), dept, batchNo);
        ptlAgreementDeptHistoryService.saveBatch(ptlAgreementDeptList);
        PtlAgreementHistory ptlAgreementHistory = new PtlAgreementHistory(batchNo, userName, HistoryStatusConstants.HISTORY_TYPE_ADD, ptlAgreement);
        ptlAgreementHistory.setStartDate(ptlAgreement.getStartDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setEndDate(ptlAgreement.getEndDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
        ptlAgreementHistory.setAgreementId(ptlAgreement.getId());
        ptlAgreementHistory.setId(IdGenerate.nextId());
        ptlAgreementHistory.setOperatorType("update");
        ptlAgreementHistoryService.saveAgreementHistory(ptlAgreementHistory);
        PtlAgreementAttributionHistory ptlAgreementAttributionHistory = new PtlAgreementAttributionHistory(batchNo,ptlAgreement.getId(),esmInsCompany.getId(),esmInsCompany.getName(),agreement.getAttribution());
        ptlAgreementAttributionHistory.setId(IdGenerate.nextId());
        if (StringUtils.isNotEmpty(attribution.getTemplateId())) {
            ptlAgreementAttributionHistoryService.save(ptlAgreementAttributionHistory);
        }
        return HttpResult.ok("修改成功");
    }

    @Override
    public void saveAssociationInformation(String agreementId, EsmInsCompany esmInsCompany, PtlAgreementSaveVo agreement) {

        // 账号添加
        PtlAgreementAttributionDto attribution = agreement.getAttribution();
        if (StringUtils.isNotEmpty(attribution.getTemplateId())) {
            ptlAgreementAttributionService.saveAttribution(agreementId, esmInsCompany, agreement.getAttribution());
        }
        // 部门授权
        ptlAgreementDeptService.saveBatchDept(agreementId, agreement.getDept());
    }


    @Override
    public void deleteAssociationInformation(String agreementId) {
        // 删除产品费用
        ptlAgreementProductCostsService.deleteByAgreementId(agreementId);
        // 删除关联信息 删除非车险产品费用  承保规则 账号信息 授权部门
        proxyObject.deleteAssociationInformationExcludeCosts(agreementId);
    }

    @Override
    public void deleteAssociationInformationExcludeCosts(String agreementId) {
        // 删除非车险产品费用
        ptlAgreementNonCarProductCostsService.deleteByAgreementId(agreementId);
        // 删除承保规则
        ptlAgreementUndwrtRulesService.deleteByAgreementId(agreementId);
        // 删除账号信息
        ptlAgreementAttributionService.removeById(agreementId);
        // 删除授权部门
        ptlAgreementDeptService.deleteByAgreementId(agreementId);
    }

    @Override
    public EsmInsCompany verifyLogin(PtlAgreement ptlAgreement, PtlAgreementSaveDto agreementSaveDto, PtlAgreementAttributionDto attribution) {
        EsmInsCompany esmInsCompany;

        // 获取保险公司
        if (AgreementType.AT2.getCode().equals(agreementSaveDto.getAgreementType())) {
            String message = String.format("协议为 %s 保险公司必须传入", AgreementType.AT2.getDesc());
            AssertionUtils.isStringEmpty(agreementSaveDto.getAssociationCompaniesId(), message);
            esmInsCompany = esmInsCompanyService.isExists(agreementSaveDto.getAssociationCompaniesId());
        } else {
            esmInsCompany = esmInsCompanyService.getBySubsidiary(agreementSaveDto.getPartnerCompaniesId());
        }

        // 验证用户名密码 python api 对接需要验证用户名
        if (!ObjectUtils.isEmpty(attribution.getApiType()) && PtlApiType.PTL_API_2.getCode() == attribution.getApiType()) {
            String nameSimple = esmInsCompany.getNamesimple();
            String id = esmInsCompany.getId();
            insCrawlerOrderController.isLogin(attribution, id, nameSimple);
        }

        ptlAgreement.setCompaniesType(esmInsCompany.getType());
        ptlAgreement.setInsuranceCompanyId(esmInsCompany.getId());
        ptlAgreement.setInsuranceCompany(esmInsCompany.getNamesimple());
        // 生成协议id
        ptlAgreement.generateTheProtocolCode();
        return esmInsCompany;
    }

    @Override
    public HttpResult<Object> auditAgreement(String agreementId, PtlAgreementAuditVo ptlAgreementAuditVo) {
        PtlAgreement ptlAgreement = proxyObject.ifExistsById(agreementId);
        ptlAgreement.setAuditStatus(ptlAgreementAuditVo.getAuditStatus());
        ptlAgreement.setAuditContent(ptlAgreementAuditVo.getAuditContent());
        // 修改协议
        boolean b = updateById(ptlAgreement);
        AssertionUtils.isSucceed(b, "协议信息修改失败");
        return HttpResult.ok("修改成功");
    }

    @Override
    public HttpResult<List<PtlAgreementNonCarProductCostsVo>> getNonCarCostsInfo(String agreementId, String companyId){
        List<PtlAgreementNonCarProductCostsVo> result=new ArrayList<>();
        //先根据传过来的保险公司代码，找上下级所有机构层级对应的非车产品列表
        if(companyId!=null&&!"".equals(companyId)){
            //先获取相关保险公司列表
            List<String> companyIdList=esmInsCompanyService.getAllRelationCompanyId(companyId);
            //再根据保险公司列表获取所有非车产品列表
            List<PtlNonCarInsuranceProduct> productList=ptlNonCarInsuranceProductService.findProductListByCompangIds(companyIdList);
            if(productList!=null&&productList.size()>0){
                for(int i=0;i<productList.size();i++){
                    PtlNonCarInsuranceProduct tempProductDto=productList.get(i);
                    PtlAgreementNonCarProductCostsVo costsVo=new PtlAgreementNonCarProductCostsVo();
                    costsVo.setProductId(tempProductDto.getProductCode());
                    costsVo.setProductName(tempProductDto.getProductName());
                    costsVo.setCompanyId(tempProductDto.getCompanyId());
                    EsmInsCompany tempInsCompany=esmInsCompanyService.getById(tempProductDto.getCompanyId());
                    costsVo.setCompanyName(tempInsCompany.getName());
                    costsVo.setRiskCode(tempProductDto.getInsuranceCode());
                    Map<String, DictionaryManagement> m = DictEnumConfig.getDmMap();
                    DictionaryManagement dictionaryManagement=m.get("nonCarInsuranceCode");
                    String riskName="";
                    for(DictionaryData data: dictionaryManagement.getDdList()){
                        if(tempProductDto.getInsuranceCode().equals(data.getDictValue())){
                            riskName=data.getDictTag();
                        }
                    }
                    costsVo.setRiskName(riskName);
                    //然后根据协议ID 查询所有已配置费用的产品进行赋值
                    if(agreementId!=null&&!"".equals(agreementId)){
                        //使用协议ID  产品ID  获取已经配置好的信息
                        PtlAgreementNonCarProductCosts agreementNonCarProductCosts=ptlAgreementNonCarProductCostsService.getNonCarProductCostsInfo(agreementId,tempProductDto.getProductCode());
                        //赋值已配置的费用比例
                        if(agreementNonCarProductCosts!=null){
                            costsVo.setCostsProportion(agreementNonCarProductCosts.getCostsProportion());
                        }
                    }
                    result.add(costsVo);
                }
            }
        }else{
            //如果归属保司没选，则直接返回空列表，相当于没查到对应非车产品信息
        }
        return HttpResult.ok(result);
    }

    @Override
    public HttpResult<List<PtlAgreement>> findRelationAgreement(String companyId){
        List<PtlAgreement> resultList=new ArrayList<>();
        if(companyId!=null&&!"".equals(companyId)) {
            //先获取相关保险公司列表
            List<String> companyIdList = esmInsCompanyService.getAllRelationCompanyId(companyId);
            if(companyIdList!=null&&companyIdList.size()>0){
                for(int i=0;i<companyIdList.size();i++){
                    String tempCom=companyIdList.get(i);
                    LambdaQueryWrapper<PtlAgreement> wrapper = new LambdaQueryWrapper<>();
                    wrapper.eq(PtlAgreement::getValidStatus,"1");
                    wrapper.and(wq1->wq1.eq(PtlAgreement::getPartnerCompaniesId,tempCom).or(wq2->wq2.eq(PtlAgreement::getAssociationCompaniesId,tempCom)));
                    resultList.addAll(list(wrapper));
                }
                for(int j=0;j<resultList.size();j++){
                    PtlAgreement agreement=resultList.get(j);
                    String tempCompanyId=agreement.getAssociationCompaniesId()!=null&&!"".equals(agreement.getAssociationCompaniesId())?agreement.getAssociationCompaniesId():agreement.getPartnerCompaniesId();
                    EsmInsCompany tempCompany= esmInsCompanyService.getById(tempCompanyId);
                    agreement.setInsuranceCompany(tempCompany.getName());
                }
            }
        }
        return HttpResult.ok(resultList);
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/15 18:02
     *  @Description: 查询审核的协议
     */
    public List<PtlAgreement> findCheckAgreementList(PtlAgreement ptlAgreement){
        LambdaQueryWrapper<PtlAgreement> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(PtlAgreement::getValidStatus,"1");
        List<PtlAgreement> list = proxyObject.list(wrapper);
        return list;
    }

//    @Autowired
//    private PtlAgreementProductCostsNewService ptlAgreementProductCostsNewService;
    public List<PtlAgreement> getCurrentAgreementList(String agreementId){
        PtlAgreement ptlAgreement = this.getById(agreementId);
        String insuranceCompanyId = ptlAgreement.getInsuranceCompanyId();
        List<PtlAgreement> ptlAgreements = baseMapper.selectList(new LambdaQueryWrapper<PtlAgreement>().eq(PtlAgreement::getInsuranceCompanyId, insuranceCompanyId));
        return ptlAgreements;
    }

    /**
     * 手动对 QuUserNum 列表进行分页
     *
     * @param ptlAgreements 原始 QuUserNum 数据列表
     * @param pageNum       期望获取的页码（从 1 开始）
     * @param pageSize      每页包含的 QuUserNum 数量
     * @return 对应页码的 QuUserNum 子列表，若输入参数无效则返回空列表
     */
    public List<PtlAgreement> paginate(List<PtlAgreement> ptlAgreements, int pageNum, int pageSize) {
        if (ptlAgreements == null || ptlAgreements.isEmpty() || pageNum < 1 || pageSize < 1) {
            return Collections.emptyList();
        }

        int startIndex = (pageNum - 1) * pageSize;
        int endIndex = Math.min(startIndex + pageSize, ptlAgreements.size());

        return ptlAgreements.subList(startIndex, endIndex);
    }

}