java-insagent-pc/src/main/java/com/ydtech/modules/ins/model/InsOrdersExcel.java

package com.ydtech.modules.ins.model;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import lombok.Data;

/**
 * @author jianlong
 * @date 2023-12-28 16:14
 */
@Data
public class InsOrdersExcel {

    @ExcelProperty(value = "保险公司名称")
    private String insCompany;

    @ExcelProperty(value = "工号")
    private String userId;

    @ExcelProperty(value = "用户名")
    private String userName;

    @ExcelProperty(value = "订单号")
    private String orderNo;

    @ExcelProperty(value = "车牌")
    private String licenseNo;

    @ExcelProperty(value = "车架号")
    private String fraMeno;

    @ExcelIgnore
    private JSONObject carInfo;

    @ExcelProperty(value = "车型")
    private String modelcName;

    @ExcelProperty(value = "座位数")
    private String seatCount;

    @ExcelProperty(value = "核定载质量")
    private String limitLoad;

    @ExcelProperty(value = "是否过户")
    private String transferFlag;

    @ExcelProperty(value = "商业险是否过户")
    private String transferFlagBi;

    @ExcelProperty(value = "行驶证注册日期")
    private String registerDate;

    @ExcelProperty(value = "发证日期")
    private String issueDate;

    @ExcelIgnore
    private JSONObject ownerInfo;

    @ExcelProperty(value = "车主姓名")
    private String ownerName;

    @ExcelProperty(value = "车主身份证号")
    private String ownerIdentifyNumber;

    @ExcelProperty(value = "车主年龄")
    private String ownerAge;

    @ExcelProperty(value = "车主手机号")
    private String ownerMobile;

    @ExcelIgnore
    private JSONObject applyInfo;

    @ExcelProperty(value = "投保人姓名")
    private String applyName;

    @ExcelProperty(value = "投保人身份证号")
    private String applyIdentifyNumber;

    @ExcelProperty(value = "投保人年龄")
    private String applyAge;

    @ExcelProperty(value = "投保人手机号")
    private String applyMobile;

    @ExcelIgnore
    private JSONObject insureInfo;

    @ExcelProperty(value = "被保险人姓名")
    private String insureName;

    @ExcelProperty(value = "被保险人身份证号")
    private String insureIdentifyNumber;

    @ExcelProperty(value = "被保险人年龄")
    private String insureAge;

    @ExcelProperty(value = "被保险人手机号")
    private String insureMobile;

    @ExcelProperty(value = "车辆用途")
    private String vehicleUse;

    @ExcelProperty(value = "使用性质")
    private String carNature;

    @ExcelIgnore
    private JSONArray kindInfo;

    @ExcelProperty(value = "机动车损失险")
    private String damage;

    @ExcelProperty(value = "第三责任险")
    private String third;

    @ExcelProperty(value = "乘客责任险")
    private String sit;

    @ExcelProperty(value = "司机责任险")
    private String driver;

    @ExcelProperty(value = "交强险费用")
    private String jqpRemIum;

    @ExcelProperty(value = "交强险保单号")
    private String jqPolicyno;

    @ExcelProperty(value = "商业险费用")
    private String sypRemIum;

    @ExcelProperty(value = "商业险保单号")
    private String syPolicyno;

    @ExcelProperty(value = "驾意险费用")
    private String jypRemIum;

    @ExcelProperty(value = "驾意险保单号")
    private String jyPolicyno;

    @ExcelProperty(value = "车船税费用")
    private String taxaMount;

    @ExcelProperty(value = "交强险起期")
    private String jqStartDate;

    @ExcelProperty(value = "交强险止期")
    private String jqEndDate;

    @ExcelProperty(value = "商业险起期")
    private String syStartDate;

    @ExcelProperty(value = "商业险止期")
    private String syEndDate;

    @ExcelProperty(value = "评分")
    private String score;

    @ExcelProperty(value = "交强类型评分")
    private String jqScore;

    @ExcelProperty(value = "商业类型评分")
    private String syScore;

    @ExcelProperty(value = "交强赔付率")
    private String jqLossRation;

    @ExcelProperty(value = "商业赔付率")
    private String syLossRation;

    @ExcelProperty(value = "支付时间")
    private String payDate;

    @ExcelProperty(value = "签单时间")
    private String signingTime;

    @ExcelIgnore
    private JSONArray crossInsurance;

}