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