package org.springblade.modules.house.excel; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import com.alibaba.excel.annotation.write.style.ContentRowHeight; import com.alibaba.excel.annotation.write.style.HeadRowHeight; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springblade.common.excel.ExcelDictConverter; import org.springblade.common.excel.ExcelDictItem; import org.springblade.common.excel.ExcelDictItemLabel; import java.io.Serializable; import java.util.Date; /** * UserExcel * * @author Chill */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class HouseHoldExcel implements Serializable { private static final long serialVersionUID = 2L; /** * 门牌地址编码 */ @ColumnWidth(25) @ExcelProperty( "门牌地址编码") private String houseCode; /** 姓名 */ @ColumnWidth(15) @ExcelProperty( "姓名") private String name; /** 手机号 */ @ColumnWidth(15) @ExcelProperty( "手机号") private String phoneNumber; /** 小区名称 */ @ColumnWidth(15) @ExcelProperty( "小区名称") private String aoiName; /** 角色 */ @ColumnWidth(15) @ExcelProperty( value = "角色",converter = ExcelDictConverter.class) @ExcelDictItem(type = "roleType") private String roleType; /** 与角色关系(业主,父子,其他) */ @ColumnWidth(15) @ExcelProperty( value = "与角色关系",converter = ExcelDictConverter.class) @ExcelDictItem(type = "roleRelation") private String relationship; /** 是否主要联系人 1:是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "是否主要联系人",converter = ExcelDictConverter.class) @ExcelDictItem(type = "primaryContactType") private String isPrimaryContact; /** 居住状态 1: 是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "居住状态",converter = ExcelDictConverter.class) @ExcelDictItem(type = "residentialStatusType") private String residentialStatus; /** 性别 1: 男 0:女 2: 未知 */ @ColumnWidth(15) @ExcelProperty( value = "性别",converter = ExcelDictConverter.class) @ExcelDictItem(type = "sex") private String gender; /** 生日 */ @ColumnWidth(15) @ExcelProperty( "生日") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date birthday; /** 身份证 */ @ColumnWidth(15) @ExcelProperty( "身份证") private String idCard; /** 港澳台通行证 */ @ColumnWidth(15) @ExcelProperty( "港澳台通行证") private String hkmtPass; /** 护照 */ @ColumnWidth(15) @ExcelProperty( "护照") private String passport; /** 民族 */ @ColumnWidth(15) @ExcelProperty( value = "民族",converter = ExcelDictConverter.class) @ExcelDictItem(type = "nationType") private String ethnicity; /** 学历 */ @ColumnWidth(15) @ExcelProperty( value = "学历",converter = ExcelDictConverter.class) @ExcelDictItem(type = "educationType") private String education; /** 户籍登记地 */ @ColumnWidth(15) @ExcelProperty( "户籍登记地") private String hukouRegistration; /** 工作状态 */ @ColumnWidth(15) @ExcelProperty( value = "工作状态",converter = ExcelDictConverter.class) @ExcelDictItem(type = "workStatusType") private String workStatus; /** 工作单位 */ @ColumnWidth(15) @ExcelProperty( "工作单位") private String employer; /** 婚姻状态 */ @ColumnWidth(15) @ExcelProperty( value = "婚姻状态",converter = ExcelDictConverter.class) @ExcelDictItem(type = "marriageStatusType") private String maritalStatus; /** 车牌号 */ @ColumnWidth(15) @ExcelProperty( "车牌号") private String cardNumber; /** 其他联系方式 */ @ColumnWidth(15) @ExcelProperty( "其他联系方式") private String otherContact; /** 现居住地址 */ @ColumnWidth(15) @ExcelProperty( "现居住地址") private String currentAddress; /** 残疾证 */ @ColumnWidth(15) @ExcelProperty( "残疾证") private String disabilityCert; /** 是否党员 1:党员 2:群众 */ @ColumnWidth(15) @ExcelProperty( value = "是否党员",converter = ExcelDictConverter.class) @ExcelDictItem(type = "partyEmberType") private String partyEmber; /** 备注 */ @ColumnWidth(15) @ExcelProperty( "备注") private String remark; }