package com.ydtech.modules.inv.utils;

import com.alibaba.excel.annotation.ExcelProperty;
import com.ydtech.modules.admin.dao.KztDataPermissionMapper;
import com.ydtech.modules.admin.dao.SysUserDeptRelationshipMapper;
import com.ydtech.modules.admin.utils.SpringContextUtil;
import com.ydtech.modules.esm.model.EsmInsCompany;
import com.ydtech.modules.esm.service.EsmInsCompanyService;
import com.ydtech.modules.fnc.entity.InsPlyIncome;
import com.ydtech.modules.inv.model.excel.*;
import com.ydtech.modules.protocol.entity.po.PtlAgreement;
import com.ydtech.modules.protocol.service.PtlAgreementService;
import io.swagger.annotations.ApiModelProperty;
import org.apache.commons.lang3.StringUtils;
import org.springframework.context.ApplicationContext;

import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.Map;

/**
 *  @version
 *  @author: hxl
 *  @Date: 2024/9/21 14:38
 *  @Description: 验证数据
 */
public class CheckInsPlyComeUtils {


    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:41
     *  @Description:  验证签单日期
     */
    public static String  checkSignDate(String data,String msg){
        String errorMsg =null;
        if(StringUtils.isBlank(data)  ||  !isValidDate(data,"yyyy-MM-dd HH:mm:ss") ){
            errorMsg = msg+"不能为空或格式错误，格式为yyyy-MM-dd HH:mm:ss";
        }
        return errorMsg;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:51
     *  @Description:  验证时间格式
     */
    public static boolean isValidDate(String date, String format) {
        try {
            DateFormat dateFormat = new SimpleDateFormat(format);
            dateFormat.setLenient(false);
            dateFormat.parse(date);
            return true;
        } catch (ParseException e) {
            return false;
        }
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:41
     *  @Description:  验证非空
     */
    public static  String  checkIsNull(String data,String msg){
        String errorMsg =null;
        if(StringUtils.isBlank(data) ){
            errorMsg=msg+"不能为空";
        }
        return errorMsg;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:41
     *  @Description:  验证非空以及数据
     */
    public static String  isNumeric(String data,String msg) {
        String errorMsg =null;
        if(StringUtils.isBlank(data) || msg.matches("-?\\d+(\\.\\d+)?") ){
            errorMsg=msg+"不能为空或者格式错误，必须为数字";
        }
        return errorMsg;
    }

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:41
     *  @Description:  验证保险公司
     */
    public static  Map<String,String>  checkCompanyName(String data,String msg) {
        ApplicationContext applicationContext = SpringContextUtil.getApplicationContext();
        EsmInsCompanyService esmInsCompanyService = applicationContext.getBean(EsmInsCompanyService.class);
        EsmInsCompany insCompany = esmInsCompanyService.findInsCompanyByNameOrNamesimple(data);
        String errorMsg =null;
        String id ="";
        if(StringUtils.isBlank(data) || insCompany==null ){
            errorMsg=msg+"不能为空或者格式错误，未查询到"+msg+"名称，请填写全称";
        }else{
            id =insCompany==null?"":insCompany.getId();
        }
        Map<String,String> map =new HashMap<String,String>();
        map.put("msg",errorMsg);
        map.put("id",id);
        return map;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 14:41
     *  @Description:  验证协议名称
     */
    public static Map<String,Object> checkAgreeName(String data, String msg,String type) {
        ApplicationContext applicationContext = SpringContextUtil.getApplicationContext();
        PtlAgreementService ptlAgreementService = applicationContext.getBean(PtlAgreementService.class);
        //由于协议名称确定不了唯一，通过协议编号确认唯一  add  by  hxl  2024-10-12 14:36
        PtlAgreement ptlAgreement = ptlAgreementService.getById(data);
        //PtlAgreement ptlAgreement = ptlAgreementService.getByAgreementTitle(data);
        String errorMsg =null;
        if(StringUtils.isBlank(data) || ptlAgreement==null ){
            errorMsg=msg+"不能为空或者格式错误，未查询到"+msg+"名称，请填写协议编号";
        }else {
            // 2 私有  1 平台
            if(!type.equals(ptlAgreement.getAgreementType())){
                errorMsg=msg+"协议类型错误";
            }
        }
        Map<String,Object> map =new HashMap<String,Object>();
        map.put("msg",errorMsg);
        map.put("id",ptlAgreement);
        return map;
    }

    public static String checkRiskcode(String data, String msg) {
        Map<String,String> map =new HashMap<String,String>();
        map.put("单交","0330");
        map.put("单商","034001");
        map.put("单三","034002");
        map.put("交三","0330034002");
        map.put("交商","0330034001");
        String errorMsg =null;
        if(StringUtils.isBlank(data) || map.get(data)==null ){
            errorMsg=msg+"不能为空或者格式错误，未查询到"+msg+"名称，请填写正确的险种名称";
        }
        return errorMsg;
    }

    public static Map<String,String> checkAddType(String data, String msg) {
        Map<String,String> map =new HashMap<String,String>();
        map.put("退保","1");
        map.put("批改","2");
        map.put("虚增","3");
        map.put("其他","4");
        String errorMsg =null;
        String id ="";
        if(StringUtils.isBlank(data) || map.get(data)==null ){
            errorMsg=msg+"不能为空或者格式错误，未查询到"+msg+"名称，请填写正确的类型";
        }else{
            id = map.get(data)==null?"": map.get(data);
        }
        map.put("msg",errorMsg);
        map.put("id",id);
        return map;
    }

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 15:40
     *  @Description:
     */
    public static Map<String,Object> checkDataDto1(AddTypeCXSXFExcel dto) {

        Map<String,Object>  map =new HashMap<String,Object>();
        String errorMsg ="";
        if(checkSignDate(dto.getSignDate(), "签单时间")!=null){
            errorMsg+=checkSignDate(dto.getSignDate(), "签单时间")+"; ";
        }
        if(checkIsNull(dto.getLicenseno(), "车牌号")!=null){
            errorMsg+=checkIsNull(dto.getSignDate(), "车牌号")+"; ";
        }
        String companyId =null;
        Map<String, String> companyMap = checkCompanyName(dto.getCompanyName(), "保险公司");
        if(companyMap!=null && companyMap.get("msg")!=null){
            errorMsg+=companyMap.get("msg").toString()+"; ";
        }else if(companyMap.get("msg")==null){
            companyId = companyMap.get("id").toString();
        }
        String partnerCompaniesId =null;
        Map<String, String> companySubMap = checkCompanyName(dto.getPartnerCompaniesName(), "保司机构");
        if(companySubMap!=null && companySubMap.get("msg")!=null){
            errorMsg+=companySubMap+"; ";
        }else if( companySubMap.get("msg")==null){
            partnerCompaniesId = companySubMap.get("id");
        }
        if(checkRiskcode(dto.getRiskcode(), "险种")!=null){
            errorMsg+=checkRiskcode(dto.getSignDate(), "险种")+"; ";
        }
        String agreeId=null;
        String agreeDeptId =null;
        PtlAgreement ptl= null;
        Map<String, Object> agreeMap = checkAgreeName(dto.getAgreementName(), "协议选择", "2");
        if(agreeMap!=null && agreeMap.get("msg")!=null){
            errorMsg+=agreeMap.get("msg").toString()+"; ";
        }else if(agreeMap.get("msg")==null){
            ptl =((PtlAgreement)agreeMap.get("id"));
            agreeId = ((PtlAgreement)agreeMap.get("id")).getId().toString();
            agreeDeptId = ((PtlAgreement)agreeMap.get("id")).getDeptId().toString();
        }
        if(checkIsNull(dto.getInsuredName(), "被保险人")!=null){
            errorMsg+=checkIsNull(dto.getInsuredName(), "被保险人")+"; ";
        }
        if(checkIsNull(dto.getPolicyno(), "交强保单号")!=null){
            errorMsg+=checkIsNull(dto.getPolicyno(), "交强保单号")+"; ";
        }
        if(checkIsNull(dto.getSyPolicyno(), "商业保单号")!=null){
            errorMsg+=checkIsNull(dto.getSyPolicyno(), "商业保单号")+"; ";
        }
        if(isNumeric(dto.getJqPremium(), "交强险保费")!=null){
            errorMsg+=isNumeric(dto.getJqPremium(), "交强险保费")+"; ";
        }
        if(isNumeric(dto.getSyPremium(), "商业险保费")!=null){
            errorMsg+=isNumeric(dto.getSyPremium(), "商业险保费")+"; ";
        }
        if(isNumeric(dto.getTaxamount(), "车船税")!=null){
            errorMsg+=isNumeric(dto.getTaxamount(), "车船税")+"; ";
        }
        if(isNumeric(dto.getJqSuperviseCostsProportion(), "交强手续费比例")!=null){
            errorMsg+=isNumeric(dto.getJqSuperviseCostsProportion(), "交强手续费比例")+"; ";
        }
        if(isNumeric(dto.getSySuperviseCostsProportion(), "商业手续费比例")!=null){
            errorMsg+=isNumeric(dto.getSySuperviseCostsProportion(), "商业手续费比例")+"; ";
        }
        if(isNumeric(dto.getCommissionFeevalue(), "手续费金额")!=null){
            errorMsg+=isNumeric(dto.getCommissionFeevalue(), "手续费金额")+"; ";
        }
        String addTypeId =null;
        Map<String, String> addTypeMap = checkAddType(dto.getAddType(), "类型");
        if(addTypeMap!=null && addTypeMap.get("msg")!=null){
            errorMsg+=addTypeMap.get("msg").toString()+"; ";
        }else if(addTypeMap.get("msg")==null){
            addTypeId = addTypeMap.get("id").toString();
        }
        //添加验证协议id 和保险公司id和保司机构id匹配  add  by  hxl  2024-10-12
        if(companyId!=null  &&  partnerCompaniesId !=null && ptl!=null ){
            if(!ptl.getInsuranceCompanyId().equals(companyId) || !ptl.getPartnerCompaniesId().equals(partnerCompaniesId)){
                errorMsg+="协议选择和保险公司和保司机构名称不一致，请确认;";
            }
        }
        map.put("msg",errorMsg);
        if(StringUtils.isBlank(errorMsg)){
            InsPlyIncome  insPlyIncome =new InsPlyIncome(dto.getSignDate(),dto.getLicenseno(),companyId,dto.getCompanyName(),partnerCompaniesId,dto.getPartnerCompaniesName(),
                    dto.getRiskcode(),agreeId,agreeDeptId,dto.getInsuredName(),dto.getPolicyno(),dto.getSyPolicyno(),dto.getJqPremium(),dto.getSyPremium(),
                    dto.getTaxamount(),dto.getJqSuperviseCostsProportion(),dto.getSySuperviseCostsProportion(),dto.getCommissionFeevalue(),addTypeId);
            map.put("dto",insPlyIncome);
        }
        return map;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 16:49
     *  @Description:  车险跟单
     */
    public static Map<String, Object> checkDataDto2(AddTypeCXGDExcel dto) {


        Map<String,Object>  map =new HashMap<String,Object>();
        String errorMsg ="";
        if(checkSignDate(dto.getSignDate(), "签单时间")!=null){
            errorMsg+=checkSignDate(dto.getSignDate(), "签单时间")+"; ";
        }
        if(checkIsNull(dto.getLicenseno(), "车牌号")!=null){
            errorMsg+=checkIsNull(dto.getSignDate(), "车牌号")+"; ";
        }
        String companyId =null;
        Map<String, String> companyMap = checkCompanyName(dto.getCompanyName(), "保险公司");
        if(companyMap!=null && companyMap.get("msg")!=null){
            errorMsg+=companyMap.get("msg").toString()+"; ";
        }else if(companyMap.get("msg")==null){
            companyId = companyMap.get("id").toString();
        }
        String partnerCompaniesId =null;
        Map<String, String> companySubMap = checkCompanyName(dto.getPartnerCompaniesName(), "保司机构");
        if(companySubMap!=null && companySubMap.get("msg")!=null){
            errorMsg+=companySubMap+"; ";
        }else if( companySubMap.get("msg")==null){
            partnerCompaniesId = companySubMap.get("id");
        }
        if(checkRiskcode(dto.getRiskcode(), "险种")!=null){
            errorMsg+=checkRiskcode(dto.getSignDate(), "险种")+"; ";
        }
        String agreeId=null;
        String agreeDeptId =null;
        PtlAgreement ptl= null;
        Map<String, Object> agreeMap = checkAgreeName(dto.getAgreementName(), "协议选择", "2");
        if(agreeMap!=null && agreeMap.get("msg")!=null){
            errorMsg+=agreeMap.get("msg").toString()+"; ";
        }else if(agreeMap.get("msg")==null){
            ptl =((PtlAgreement)agreeMap.get("id"));
            agreeId = ((PtlAgreement)agreeMap.get("id")).getId().toString();
            agreeDeptId = ((PtlAgreement)agreeMap.get("id")).getDeptId().toString();
        }
        if(checkIsNull(dto.getInsuredName(), "被保险人")!=null){
            errorMsg+=checkIsNull(dto.getInsuredName(), "被保险人")+"; ";
        }
        if(checkIsNull(dto.getPolicyno(), "交强保单号")!=null){
            errorMsg+=checkIsNull(dto.getPolicyno(), "交强保单号")+"; ";
        }
        if(checkIsNull(dto.getSyPolicyno(), "商业保单号")!=null){
            errorMsg+=checkIsNull(dto.getSyPolicyno(), "商业保单号")+"; ";
        }
        if(isNumeric(dto.getJqPremium(), "交强险保费")!=null){
            errorMsg+=isNumeric(dto.getJqPremium(), "交强险保费")+"; ";
        }
        if(isNumeric(dto.getSyPremium(), "商业险保费")!=null){
            errorMsg+=isNumeric(dto.getSyPremium(), "商业险保费")+"; ";
        }
        if(isNumeric(dto.getTaxamount(), "车船税")!=null){
            errorMsg+=isNumeric(dto.getTaxamount(), "车船税")+"; ";
        }
        if(isNumeric(dto.getJqOtherCostsProportion(), "交强跟单比例")!=null){
            errorMsg+=isNumeric(dto.getJqOtherCostsProportion(), "交强跟单比例")+"; ";
        }
        if(isNumeric(dto.getSyOtherCostsProportion(), "商业跟单比例")!=null){
            errorMsg+=isNumeric(dto.getSyOtherCostsProportion(), "商业跟单比例")+"; ";
        }
        if(isNumeric(dto.getOtherFeevalue(), "跟单费金额")!=null){
            errorMsg+=isNumeric(dto.getOtherFeevalue(), "跟单费金额")+"; ";
        }
        String addTypeId =null;
        Map<String, String> addTypeMap = checkAddType(dto.getAddType(), "类型");
        if(addTypeMap!=null && addTypeMap.get("msg")!=null){
            errorMsg+=addTypeMap.get("msg").toString()+"; ";
        }else if(addTypeMap.get("msg")==null){
            addTypeId = addTypeMap.get("id").toString();
        }
        //添加验证协议id 和保险公司id和保司机构id匹配  add  by  hxl  2024-10-12
        if(companyId!=null  &&  partnerCompaniesId !=null && ptl!=null ){
            if(!ptl.getInsuranceCompanyId().equals(companyId) || !ptl.getPartnerCompaniesId().equals(partnerCompaniesId)){
                errorMsg+="协议选择和保险公司和保司机构名称不一致，请确认;";
            }
        }
        map.put("msg",errorMsg);
        if(StringUtils.isBlank(errorMsg)){
            InsPlyIncome  insPlyIncome =new InsPlyIncome(dto.getSignDate(),dto.getLicenseno(),companyId,dto.getCompanyName(),partnerCompaniesId,dto.getPartnerCompaniesName(),
                    dto.getRiskcode(),agreeId,agreeDeptId,dto.getInsuredName(),dto.getPolicyno(),dto.getSyPolicyno(),dto.getJqPremium(),dto.getSyPremium(),
                    dto.getTaxamount(),dto.getJqOtherCostsProportion(),dto.getSyOtherCostsProportion(),dto.getOtherFeevalue(),addTypeId,null);
            map.put("dto",insPlyIncome);
        }
        return map;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 16:50
     *  @Description: 非车手续费
     */
    public static Map<String, Object> checkDataDto3(AddTypeFCSXFExcel dto) {

        Map<String,Object>  map =new HashMap<String,Object>();
        String errorMsg ="";
        if(checkSignDate(dto.getSignDate(), "签单时间")!=null){
            errorMsg+=checkSignDate(dto.getSignDate(), "签单时间")+"; ";
        }
        if(checkIsNull(dto.getLicenseno(), "车牌号")!=null){
            errorMsg+=checkIsNull(dto.getSignDate(), "车牌号")+"; ";
        }
        String companyId =null;
        Map<String, String> companyMap = checkCompanyName(dto.getCompanyName(), "保险公司");
        if(companyMap!=null && companyMap.get("msg")!=null){
            errorMsg+=companyMap.get("msg").toString()+"; ";
        }else if(companyMap.get("msg")==null){
            companyId = companyMap.get("id").toString();
        }
        String partnerCompaniesId =null;
        Map<String, String> companySubMap = checkCompanyName(dto.getPartnerCompaniesName(), "保司机构");
        if(companySubMap!=null && companySubMap.get("msg")!=null){
            errorMsg+=companySubMap+"; ";
        }else if( companySubMap.get("msg")==null){
            partnerCompaniesId = companySubMap.get("id");
        }
        if(checkRiskcode(dto.getRiskcode(), "险种")!=null){
            errorMsg+=checkRiskcode(dto.getSignDate(), "险种")+"; ";
        }
        String agreeId=null;
        String agreeDeptId =null;
        PtlAgreement ptl= null;
        Map<String, Object> agreeMap = checkAgreeName(dto.getAgreementName(), "协议选择", "2");
        if(agreeMap!=null && agreeMap.get("msg")!=null){
            errorMsg+=agreeMap.get("msg").toString()+"; ";
        }else if(agreeMap.get("msg")==null){
            ptl =((PtlAgreement)agreeMap.get("id"));
            agreeId = ((PtlAgreement)agreeMap.get("id")).getId().toString();
            agreeDeptId = ((PtlAgreement)agreeMap.get("id")).getDeptId().toString();
        }
        if(checkIsNull(dto.getInsuredName(), "被保险人")!=null){
            errorMsg+=checkIsNull(dto.getInsuredName(), "被保险人")+"; ";
        }
        if(checkIsNull(dto.getNoPolicyno(), "非车保单号")!=null){
            errorMsg+=checkIsNull(dto.getNoPolicyno(), "非车保单号")+"; ";
        }
        if(isNumeric(dto.getNoPremium(), "非车保费")!=null){
            errorMsg+=isNumeric(dto.getNoPremium(), "非车保费")+"; ";
        }
        if(isNumeric(dto.getNoSuperviseCostsProportion(), "非车手续费比例")!=null){
            errorMsg+=isNumeric(dto.getNoSuperviseCostsProportion(), "非车手续费比例")+"; ";
        }
        if(isNumeric(dto.getNoSuperviseCostsPremiums(), "手续费金额")!=null){
            errorMsg+=isNumeric(dto.getNoSuperviseCostsPremiums(), "手续费金额")+"; ";
        }
        String addTypeId =null;
        Map<String, String> addTypeMap = checkAddType(dto.getAddType(), "类型");
        if(addTypeMap!=null && addTypeMap.get("msg")!=null){
            errorMsg+=addTypeMap.get("msg").toString()+"; ";
        }else if(addTypeMap.get("msg")==null){
            addTypeId = addTypeMap.get("id").toString();
        }
        //添加验证协议id 和保险公司id和保司机构id匹配  add  by  hxl  2024-10-12
        if(companyId!=null  &&  partnerCompaniesId !=null && ptl!=null ){
            if(!ptl.getInsuranceCompanyId().equals(companyId) || !ptl.getPartnerCompaniesId().equals(partnerCompaniesId)){
                errorMsg+="协议选择和保险公司和保司机构名称不一致，请确认;";
            }
        }
        map.put("msg",errorMsg);
        if(StringUtils.isBlank(errorMsg)){
            InsPlyIncome  insPlyIncome =new InsPlyIncome(dto.getSignDate(),dto.getLicenseno(),companyId,dto.getCompanyName(),partnerCompaniesId,dto.getPartnerCompaniesName(),
                    dto.getRiskcode(),agreeId,agreeDeptId,dto.getInsuredName(),dto.getNoPolicyno(),dto.getNoPremium(),dto.getNoSuperviseCostsProportion(),null,
                    dto.getNoSuperviseCostsPremiums(),addTypeId);
            map.put("dto",insPlyIncome);
        }
        return map;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 16:50
     *  @Description: 非车跟单
     */
    public static Map<String, Object> checkDataDto4(AddTypeFCGDExcel dto) {
        Map<String,Object>  map =new HashMap<String,Object>();
        String errorMsg ="";
        if(checkSignDate(dto.getSignDate(), "签单时间")!=null){
            errorMsg+=checkSignDate(dto.getSignDate(), "签单时间")+"; ";
        }
        if(checkIsNull(dto.getLicenseno(), "车牌号")!=null){
            errorMsg+=checkIsNull(dto.getSignDate(), "车牌号")+"; ";
        }
        String companyId =null;
        Map<String, String> companyMap = checkCompanyName(dto.getCompanyName(), "保险公司");
        if(companyMap!=null && companyMap.get("msg")!=null){
            errorMsg+=companyMap.get("msg").toString()+"; ";
        }else if(companyMap.get("msg")==null){
            companyId = companyMap.get("id").toString();
        }
        String partnerCompaniesId =null;
        Map<String, String> companySubMap = checkCompanyName(dto.getPartnerCompaniesName(), "保司机构");
        if(companySubMap!=null && companySubMap.get("msg")!=null){
            errorMsg+=companySubMap+"; ";
        }else if( companySubMap.get("msg")==null){
            partnerCompaniesId = companySubMap.get("id");
        }
        if(checkRiskcode(dto.getRiskcode(), "险种")!=null){
            errorMsg+=checkRiskcode(dto.getSignDate(), "险种")+"; ";
        }
        String agreeId=null;
        String agreeDeptId =null;
        PtlAgreement ptl= null;
        Map<String, Object> agreeMap = checkAgreeName(dto.getAgreementName(), "协议选择", "2");
        if(agreeMap!=null && agreeMap.get("msg")!=null){
            errorMsg+=agreeMap.get("msg").toString()+"; ";
        }else if(agreeMap.get("msg")==null){
            ptl =((PtlAgreement)agreeMap.get("id"));
            agreeId = ((PtlAgreement)agreeMap.get("id")).getId().toString();
            agreeDeptId = ((PtlAgreement)agreeMap.get("id")).getDeptId().toString();
        }
        if(checkIsNull(dto.getInsuredName(), "被保险人")!=null){
            errorMsg+=checkIsNull(dto.getInsuredName(), "被保险人")+"; ";
        }
        if(checkIsNull(dto.getNoPolicyno(), "非车保单号")!=null){
            errorMsg+=checkIsNull(dto.getNoPolicyno(), "非车保单号")+"; ";
        }
        if(checkIsNull(dto.getNoPremium(), "非车保费")!=null){
            errorMsg+=checkIsNull(dto.getNoPremium(), "非车保费")+"; ";
        }
        if(isNumeric(dto.getNoOtherCostsProportion(), "非车跟单费比例")!=null){
            errorMsg+=isNumeric(dto.getNoOtherCostsProportion(), "非车跟单费比例")+"; ";
        }
        if(isNumeric(dto.getNoOtherCostsPremium(), "跟单费金额")!=null){
            errorMsg+=isNumeric(dto.getNoOtherCostsPremium(), "跟单费金额")+"; ";
        }
        String addTypeId =null;
        Map<String, String> addTypeMap = checkAddType(dto.getAddType(), "类型");
        if(addTypeMap!=null && addTypeMap.get("msg")!=null){
            errorMsg+=addTypeMap.get("msg").toString()+"; ";
        }else if(addTypeMap.get("msg")==null){
            addTypeId = addTypeMap.get("id").toString();
        }
        //添加验证协议id 和保险公司id和保司机构id匹配  add  by  hxl  2024-10-12
        if(companyId!=null  &&  partnerCompaniesId !=null && ptl!=null ){
            if(!ptl.getInsuranceCompanyId().equals(companyId) || !ptl.getPartnerCompaniesId().equals(partnerCompaniesId)){
                errorMsg+="协议选择和保险公司和保司机构名称不一致，请确认;";
            }
        }
        map.put("msg",errorMsg);
        if(StringUtils.isBlank(errorMsg)){
            InsPlyIncome  insPlyIncome =new InsPlyIncome(dto.getSignDate(),dto.getLicenseno(),companyId,dto.getCompanyName(),partnerCompaniesId,dto.getPartnerCompaniesName(),
                    dto.getRiskcode(),agreeId,agreeDeptId,dto.getInsuredName(),dto.getNoPolicyno(),dto.getNoPremium(),dto.getNoOtherCostsProportion(),dto.getNoOtherCostsPremium(),addTypeId);
            map.put("dto",insPlyIncome);
        }
        return map;
    }
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/21 16:50
     *  @Description:  平台结算
     */
    public static Map<String, Object> checkDataDto5(AddTypePTJSExcel dto) {

        Map<String,Object>  map =new HashMap<String,Object>();
        String errorMsg ="";
        if(checkSignDate(dto.getSignDate(), "签单时间")!=null){
            errorMsg+=checkSignDate(dto.getSignDate(), "签单时间")+"; ";
        }
        if(checkIsNull(dto.getLicenseno(), "车牌号")!=null){
            errorMsg+=checkIsNull(dto.getSignDate(), "车牌号")+"; ";
        }
        String companyId =null;
        Map<String, String> companyMap = checkCompanyName(dto.getCompanyName(), "保险公司");
        if(companyMap!=null && companyMap.get("msg")!=null){
            errorMsg+=companyMap.get("msg").toString()+"; ";
        }else if(companyMap.get("msg")==null){
            companyId = companyMap.get("id").toString();
        }
        String partnerCompaniesId =null;
        Map<String, String> companySubMap = checkCompanyName(dto.getPartnerCompaniesName(), "保司机构");
        if(companySubMap!=null && companySubMap.get("msg")!=null){
            errorMsg+=companySubMap+"; ";
        }else if( companySubMap.get("msg")==null){
            partnerCompaniesId = companySubMap.get("id");
        }
        if(checkRiskcode(dto.getRiskcode(), "险种")!=null){
            errorMsg+=checkRiskcode(dto.getSignDate(), "险种")+"; ";
        }
        String agreeId=null;
        String agreeDeptId =null;
        PtlAgreement ptl= null;
        Map<String, Object> agreeMap = checkAgreeName(dto.getAgreementName(), "协议选择", "1");
        if(agreeMap!=null && agreeMap.get("msg")!=null){
            errorMsg+=agreeMap.get("msg").toString()+"; ";
        }else if(agreeMap.get("msg")==null){
            ptl =((PtlAgreement)agreeMap.get("id"));
            agreeId = ((PtlAgreement)agreeMap.get("id")).getId().toString();
            agreeDeptId = ((PtlAgreement)agreeMap.get("id")).getDeptId().toString();
        }
        if(checkIsNull(dto.getInsuredName(), "被保险人")!=null){
            errorMsg+=checkIsNull(dto.getInsuredName(), "被保险人")+"; ";
        }
        if(checkIsNull(dto.getPolicyno(), "交强保单号")!=null){
            errorMsg+=checkIsNull(dto.getPolicyno(), "交强保单号")+"; ";
        }
        if(checkIsNull(dto.getSyPolicyno(), "商业保单号")!=null){
            errorMsg+=checkIsNull(dto.getSyPolicyno(), "商业保单号")+"; ";
        }
        if(checkIsNull(dto.getNoPolicyno(), "非车保单号")!=null){
            errorMsg+=checkIsNull(dto.getNoPolicyno(), "非车保单号")+"; ";
        }
        if(isNumeric(dto.getJqPremium(), "交强险保费")!=null){
            errorMsg+=isNumeric(dto.getJqPremium(), "交强险保费")+"; ";
        }
        if(isNumeric(dto.getSyPremium(), "商业险保费")!=null){
            errorMsg+=isNumeric(dto.getSyPremium(), "商业险保费")+"; ";
        }
        if(isNumeric(dto.getTaxamount(), "车船税")!=null){
            errorMsg+=isNumeric(dto.getTaxamount(), "车船税")+"; ";
        }
        if(isNumeric(dto.getNoPremium(), "非车保费")!=null){
            errorMsg+=isNumeric(dto.getNoPremium(), "非车保费")+"; ";
        }

        if(isNumeric(dto.getJqReceivableProportion(), "交强应收比例")!=null){
            errorMsg+=isNumeric(dto.getJqReceivableProportion(), "交强应收比例")+"; ";
        }
        if(isNumeric(dto.getSyReceivableProportion(), "商业应收比例")!=null){
            errorMsg+=isNumeric(dto.getSyReceivableProportion(), "商业应收比例")+"; ";
        }
        if(isNumeric(dto.getNoReceivableProportion(), "非车应收比例")!=null){
            errorMsg+=isNumeric(dto.getNoReceivableProportion(), "非车应收比例")+"; ";
        }

        if(isNumeric(dto.getReceivableAmount(), "应收金额")!=null){
            errorMsg+=isNumeric(dto.getReceivableAmount(), "应收金额")+"; ";
        }
        String addTypeId =null;
        Map<String, String> addTypeMap = checkAddType(dto.getAddType(), "类型");
        if(addTypeMap!=null && addTypeMap.get("msg")!=null){
            errorMsg+=addTypeMap.get("msg").toString()+"; ";
        }else if(addTypeMap.get("msg")==null){
            addTypeId = addTypeMap.get("id").toString();
        }
        //添加验证协议id 和保险公司id和保司机构id匹配  add  by  hxl  2024-10-12
        if(companyId!=null  &&  partnerCompaniesId !=null && ptl!=null ){
            if(!ptl.getInsuranceCompanyId().equals(companyId) || !ptl.getPartnerCompaniesId().equals(partnerCompaniesId)){
                errorMsg+="协议选择和保险公司和保司机构名称不一致，请确认;";
            }
        }
        map.put("msg",errorMsg);
        if(StringUtils.isBlank(errorMsg)){
            InsPlyIncome  insPlyIncome =new InsPlyIncome(dto.getSignDate(),dto.getLicenseno(),companyId,dto.getCompanyName(),partnerCompaniesId,dto.getPartnerCompaniesName(),
                    dto.getRiskcode(),agreeId,agreeDeptId,dto.getInsuredName(),dto.getPolicyno(),dto.getSyPolicyno(),dto.getJqPremium(),dto.getSyPremium(),
                    dto.getTaxamount(),dto.getNoPolicyno(),dto.getNoPremium(),dto.getJqReceivableProportion(),dto.getSyReceivableProportion(),dto.getNoReceivableProportion(),dto.getReceivableAmount(),addTypeId);
            map.put("dto",insPlyIncome);
        }
        return map;
    }
}