java-insagent-pc/src/main/java/com/ydtech/modules/ins/vo/InsCmainExcelVO.java

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;


}