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 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; /** * ImportHouseHoldExcel * * @author Chill */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class ImportHouseholdExcel implements Serializable { private static final long serialVersionUID = 2L; /** * 门牌地址编码 */ @ColumnWidth(25) @ExcelProperty( "门牌地址编码*") private String houseCode; /** 姓名 */ @ColumnWidth(15) @ExcelProperty( "姓名*") private String name; /** 性别 1: 男 0:女 2: 未知 */ @ColumnWidth(15) @ExcelProperty( value = "性别",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "sex") @ExcelDictItem(type = "sex") private String gender; /** 手机号 */ @ColumnWidth(15) @ExcelProperty( "手机号*") private String phoneNumber; /** 生日 */ @ColumnWidth(15) @ExcelProperty( "生日") private String birthday; /** 身份证 */ @ColumnWidth(15) @ExcelProperty( "身份证号码") private String idCard; /** 其他联系方式 */ @ColumnWidth(15) @ExcelProperty( "其他联系方式") private String otherContact; /** 与业主关系 */ @ColumnWidth(15) @ExcelProperty( value = "与业主关系*(业主/妻子/丈夫/女儿/儿子/母亲/父亲/.../租户/其他)",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "roleRelation") @ExcelDictItem(type = "roleRelation") private String relationship; /** 是否主要联系人 1:是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "是否主要联系人",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "primaryContactType") @ExcelDictItem(type = "primaryContactType") private String isPrimaryContact; /** 居住状态 1: 是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "居住状态",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "residentialStatusType") @ExcelDictItem(type = "residentialStatusType") private String residentialStatus; /** 民族 */ @ColumnWidth(15) @ExcelProperty( value = "民族",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "nationType") @ExcelDictItem(type = "nationType") private String ethnicity; /** 户籍地址 */ @ColumnWidth(15) @ExcelProperty( "户籍地址") private String hukouRegistration; /** 现居住地址 */ @ColumnWidth(15) @ExcelProperty( "现居住地址") private String currentAddress; /** 是否党员 1:党员 2:群众 */ @ColumnWidth(15) @ExcelProperty( value = "是否党员(党员/群众)",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "partyEmberType") @ExcelDictItem(type = "partyEmberType") private String partyEmber; /** 学历 */ @ColumnWidth(15) @ExcelProperty( value = "学历",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "educationType") @ExcelDictItem(type = "educationType") private String education; /** * 职业类别 */ @ColumnWidth(15) @ExcelProperty( "职业类别") private String occupation; /** 工作单位 */ @ColumnWidth(15) @ExcelProperty( "工作单位") private String employer; /** * 工作单位地址 */ @ExcelProperty( "工作单位地址") private String cmpyRegAddr; /** 工作状态 */ @ColumnWidth(15) @ExcelProperty( value = "工作状态(在职/离职/退休/其他)",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "workStatusType") @ExcelDictItem(type = "workStatusType") private String workStatus; /** 婚姻状态 */ @ColumnWidth(15) @ExcelProperty( value = "婚姻状态(未婚/已婚/离异/丧偶/其他)",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "marriageStatusType") @ExcelDictItem(type = "marriageStatusType") private String maritalStatus; /** * 宗教信仰 */ @ColumnWidth(15) @ExcelProperty( "宗教信仰") private String religiousBelief; /** * 健康状况 业务字典 healthStatus */ @ColumnWidth(15) @ExcelProperty( value = "健康状况(健康/良好/较差)",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "healthStatus") @ExcelDictItem(type = "healthStatus") private String healthStatus; /** * 疾病名称 */ @ColumnWidth(15) @ExcelProperty( "疾病名称") private String diseaseName; /** * 外出去向 */ @ColumnWidth(15) @ExcelProperty( "外出去向") private String goOutWhere; /** * 外出原因 */ @ColumnWidth(15) @ExcelProperty( "外出原因") private String goOutReason; /** * 外出时间 */ @ColumnWidth(15) @ExcelProperty( "外出时间") // @JsonFormat(pattern = "yyyy-MM-dd") private String goOutTime; /** * 外出详址 */ @ExcelProperty( "外出详址") private String goOutAddr; /** 车牌号 */ @ColumnWidth(15) @ExcelProperty( "车牌号") private String cardNumber; /** * 自愿者组织 */ @ColumnWidth(15) @ExcelProperty( "自愿者组织") private String volunteerOrg; /** 备注 */ @ColumnWidth(15) @ExcelProperty( "备注") private String remark; /** 备注 */ @ColumnWidth(15) @ExcelProperty( "标签") private String labelName; }