package com.panzhihua.common.model.vos.community;
|
|
import java.io.Serializable;
|
import java.util.List;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.google.common.collect.Lists;
|
import com.panzhihua.common.model.helper.encrypt.EncryptDecryptClass;
|
import com.panzhihua.common.model.helper.encrypt.EncryptDecryptField;
|
|
import lombok.Data;
|
|
/**
|
* @description: 批量导入重精人员
|
* @author: txb
|
*/
|
@Data
|
@EncryptDecryptClass
|
public class ComMngPopulationMajorExcelVO implements Serializable {
|
|
@ExcelProperty(value = "序号", index = 0)
|
private String serialNumber;
|
|
@ExcelProperty(value = "姓名", index = 1)
|
private String name;
|
|
@ExcelProperty(value = "身份证号码", index = 2)
|
@EncryptDecryptField
|
private String cardNo;
|
|
@ExcelProperty(value = "街/路/巷", index = 3)
|
private String road;
|
|
@ExcelProperty(value = "小区号", index = 4)
|
private String doorNo;
|
|
@ExcelProperty(value = "楼排号", index = 5)
|
private String floor;
|
|
@ExcelProperty(value = "单元号", index = 6)
|
private String unitNo;
|
|
@ExcelProperty(value = "户室（房间号）", index = 7)
|
private String houseNo;
|
|
@ExcelProperty(value = "是否租住", index = 8)
|
private Integer isRent;
|
|
@ExcelProperty(value = "房屋状态(1.自住 2.租住 3.其他)", index = 9)
|
private Integer houseStatus;
|
|
@ExcelProperty(value = "房屋用途(1.住宅 2.公寓 3.宿舍 4.仓库 5.其他）", index = 10)
|
private Integer housePurpose;
|
|
@ExcelProperty(value = "管控状态(1.常规 2.关注 3.管控)", index = 11)
|
private Integer controlStatus;
|
|
@ExcelProperty(value = "外地/本地（1.本地 2.外地）", index = 12)
|
private Integer outOrLocal;
|
|
@ExcelProperty(value = "户口所在地", index = 13)
|
private String censusRegister;
|
|
@ExcelProperty(value = "文化程度(1.小学 2.初中 3.高中 4.中专 5.大专 6.本科 7.硕士 8.博士 9.其他)", index = 14)
|
private Integer cultureLevel;
|
|
@ExcelProperty(value = "经济状况", index = 15)
|
private String economicCondition;
|
|
@ExcelProperty(value = "人员类型", index = 16)
|
private String personType;
|
|
@ExcelProperty(value = "家庭情况", index = 17)
|
private String familySituation;
|
|
@ExcelProperty(value = "监护人姓名", index = 18)
|
private String custodyPerson;
|
|
@ExcelProperty(value = "与监护人关系", index = 19)
|
private String custodyRelation;
|
|
@ExcelProperty(value = "监护人公民身份号码", index = 20)
|
private String custodyCardNo;
|
|
@ExcelProperty(value = "监护人联系方式", index = 21)
|
private String custodyPersonPhone;
|
|
@ExcelProperty(value = "监护人居住详址", index = 22)
|
private String custodyAddress;
|
|
@ExcelProperty(value = "帮扶人姓名", index = 23)
|
private String helpPerson;
|
|
@ExcelProperty(value = "帮扶人联系方式", index = 24)
|
private String helpPersonPhone;
|
|
@ExcelProperty(value = "帮扶手段", index = 25)
|
private String helpMethod;
|
|
@ExcelProperty(value = "帮扶情况", index = 26)
|
private String helpSituation;
|
|
@ExcelProperty(value = "是否违法犯罪（1.是 0.否）", index = 27)
|
private Integer isCrime;
|
|
@ExcelProperty(value = "违法犯罪情况", index = 28)
|
private String crimeSutiation;
|
|
/**
|
* 去重字段，使用（姓名+身份证号+街路巷+小区号+楼牌号+单元号+户室）组合字段进行MD5加密实现去重
|
*/
|
private String distinctPass;
|
|
/**
|
* 年龄
|
*/
|
private Integer age;
|
|
/**
|
* 性别（1.男 2.女）
|
*/
|
private Integer sex;
|
|
/**
|
* 出生年月日
|
*/
|
private String birthday;
|
|
/**
|
* 扩展字段用逗号隔开
|
*/
|
private List<String> userTagStr = Lists.newArrayList();
|
|
private Long houseId;
|
|
/**
|
* 地址
|
*/
|
private String address;
|
}
|
