package com.ydtech.modules.ins.vo; import cn.afterturn.easypoi.excel.annotation.Excel; import cn.afterturn.easypoi.excel.annotation.ExcelEntity; import cn.afterturn.easypoi.excel.annotation.ExcelTarget; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.NoArgsConstructor; import java.text.DecimalFormat; import java.util.Date; @Data public class InsCmainExcelVO { /** * 保单号 */ @Excel(name = "保单号") private String policyno; /** * 保险公司编码 */ @Excel(name = "保险公司编码") private String inscompany; /** * 保险公司名称 */ @Excel(name = "保险公司名称") private String inscompanyName; /** * 险种编码 */ @Excel(name = "险种编码") private String riskcode; /** * 险种名称 */ @Excel(name = "险种名称") private String riskname; /** * 起保日期 */ @Excel(name = "起保日期") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") private Date startdate; /** * 终保日期 */ @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @Excel(name = "终保日期") private Date enddate; /** * 核保日期 */ @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @Excel(name = "核保日期") private Date operatedate; /** * 归属业务员编码 */ @Excel(name = "归属业务员编码") private String handlercode; /** * 归属业务员名称 */ @Excel(name = "归属业务员名称") private String handlername; /** * 保费 */ @Excel(name = "保费") private Double sumpremium; /** * 保险金额 */ @Excel(name = "保险金额") private Double sumamount; /** * 保费(不含税) */ @Excel(name = "保费(不含税)") private Double notaxpremium; /** * 手续费比例 */ @Excel(name = "手续费比例") private Double commissionrate; /** * 手续费金额 */ @Excel(name = "手续费金额") private Double commission; /** * 缴费方式 */ @Excel(name = "缴费方式") private String jffs; /** * 保费是否代收(0否,1是)默认0否 */ @Excel(name = "保费是否代收(0否,1是)") private String sfds; /** * 非车/车 0非车,1车 */ @Excel(name = "车/非车(0非车,1车)") private String carflag; @Excel(name = "车牌号") @ApiModelProperty(value = "车牌号") private String licenseNo; @Excel(name = "车架号") @ApiModelProperty(value = "车架号") private String frameNo; @Excel(name = "发动机号") @ApiModelProperty(value = "发动机号") private String engineNo; @Excel(name = "车辆型号") @ApiModelProperty(value = "车辆型号") private String carTypeNo; @Excel(name = "折扣系数") @ApiModelProperty(value = "折扣系数") private String zkxs; // @Excel(name = "投保人代码") @ApiModelProperty(value = "投保人代码") private String applicode; @Excel(name = "投保人名称") @ApiModelProperty(value = "投保人名称") private String appliname; @Excel(name = "投保人身份证号") @ApiModelProperty(value = "投保人身份证号") private String applicertno; @Excel(name = "投保人联系方式") @ApiModelProperty(value = "投保人联系方式") private String applimobile; @Excel(name = "投保人联系地址") @ApiModelProperty(value = "投保人联系地址") private String appliaddress; // @Excel(name = "被保人代码") @ApiModelProperty(value = "被保人代码") private String insuredcode; @Excel(name = "被保人名称") @ApiModelProperty(value = "被保人名称") private String insuredname; @Excel(name = "被保人身份证号") @ApiModelProperty(value = "被保人身份证号") private String insuredcertno; @Excel(name = "被保人联系方式") @ApiModelProperty(value = "被保人联系方式") private String insuredmobile; @Excel(name = "被保人联系地址") @ApiModelProperty(value = "被保人联系地址") private String insuredaddress; @ApiModelProperty(value = "缴费日期") @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss") private Date paydate; }