package com.panzhihua.common.model.vos.community;

import java.io.Serializable;
import java.util.Date;
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 ComMngPopulationCorrectExcelVO implements Serializable {

    @ExcelProperty(value = "序号", index = 0)
    private String serialNumber;

    @ExcelProperty(value = "姓名", index = 1)
    private String name;

    @ExcelProperty(value = "身份证号码", index = 3)
    @EncryptDecryptField
    private String cardNo;

    @ExcelProperty(value = "民族", index = 2)
    private String nation;

    @ExcelProperty(value = "联系电话", index = 4)
    private String phone;

    @ExcelProperty(value = "是否租住", index = 10)
    private Integer isRent;

    @ExcelProperty(value = "街/路/巷", index = 5)
    private String road;

    @ExcelProperty(value = "小区号", index = 6)
    private String doorNo;

    @ExcelProperty(value = "楼排号", index = 7)
    private String floor;

    @ExcelProperty(value = "单元号", index = 8)
    private String unitNo;

    @ExcelProperty(value = "户室（房间号）", index = 9)
    private String houseNo;

    @ExcelProperty(value = "房屋状态(1.自住 2.租住 3.其他)", index = 11)
    private Integer houseStatus;

    @ExcelProperty(value = "房屋用途(1.住宅 2.公寓 3.宿舍 4.仓库 5.其他）", index = 12)
    private Integer housePurpose;

    @ExcelProperty(value = "管控状态(1.常规 2.关注 3.管控)", index = 13)
    private Integer controlStatus;

    @ExcelProperty(value = "外地/本地（1.本地  2.外地）", index = 14)
    private Integer outOrLocal;

    @ExcelProperty(value = "户口所在地", index = 15)
    private String censusRegister;

    @ExcelProperty(value = "学历", index = 16)
    private String cultureLevel;

    @ExcelProperty(value = "社区矫正人员编号", index = 17)
    private String correctPersonCode;

    @ExcelProperty(value = "原羁押场所", index = 18)
    private String originalCustodyplace;

    @ExcelProperty(value = "矫正类别", index = 19)
    private String correctType;

    @ExcelProperty(value = "案件类别", index = 20)
    private String caseType;

    @ExcelProperty(value = "具体罪名", index = 21)
    private String specificCharge;

    @ExcelProperty(value = "原判刑期", index = 22)
    private String originalTerm;

    @ExcelProperty(value = "原判刑开始日期", index = 23)
    private Date originalTermBegin;

    @ExcelProperty(value = "原判刑结束日期", index = 24)
    private Date originalTermEnd;

    @ExcelProperty(value = "矫正开始时间", index = 25)
    private Date correctBegin;

    @ExcelProperty(value = "矫正结束时间", index = 26)
    private Date correctEnd;

    @ExcelProperty(value = "接收方式", index = 27)
    private String receiveMethod;

    @ExcelProperty(value = "是否累惯犯（1.是 0.否）", index = 28)
    private Integer isRecidivist;

    @ExcelProperty(value = "四史情况", index = 29)
    private String fourHistory;

    @ExcelProperty(value = "三涉情况", index = 30)
    private String threeInvovle;

    @ExcelProperty(value = "是否建立矫正小组（1.是 0.否）", index = 31)
    private Integer isCorrectGroup;

    @ExcelProperty(value = "矫正小组人员组成情况", index = 32)
    private String correctGroupConstitute;

    @ExcelProperty(value = "矫正解除（终止）类型", index = 33)
    private String correctRelieveType;

    @ExcelProperty(value = "是否有脱管（1.是 0.否）", index = 34)
    private Integer isOutControl;

    @ExcelProperty(value = "脱管原因", index = 35)
    private String outControlReason;

    @ExcelProperty(value = "脱管纠正情况", index = 36)
    private String outControlCorrect;

    @ExcelProperty(value = "检察监督脱管情况", index = 37)
    private String inspectOutControl;

    @ExcelProperty(value = "是否有漏管（1.是 0.否）", index = 38)
    private Integer isMissControl;

    @ExcelProperty(value = "漏管原因", index = 39)
    private String missControlReason;

    @ExcelProperty(value = "漏管纠正情况", index = 40)
    private String missControlCorrect;

    @ExcelProperty(value = "检察监督漏管", index = 41)
    private String inspectMissControl;

    @ExcelProperty(value = "奖惩情况", index = 42)
    private String rewardAndPunishiment;

    @ExcelProperty(value = "是否重新犯罪（1.是 0.否）", index = 43)
    private Integer isAgainCrime;

    @ExcelProperty(value = "重新犯罪名称", index = 44)
    private String againCrimeName;

    @ExcelProperty(value = "刑罚变更执行情况", index = 45)
    private String pubishmentChange;

    @ExcelProperty(value = "备注", index = 46)
    private String remark;

    /**
     * 去重字段，使用（姓名+身份证号+街路巷+小区号+楼牌号+单元号+户室）组合字段进行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;
}