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 agreementId; @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; }