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

import java.io.Serializable;

import com.alibaba.excel.annotation.ExcelProperty;
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 ComMngPopulationLowSecurityMistakeExcelVO 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 phone;

    @ExcelProperty(value = "地区", index = 4)
    private String region;

    @ExcelProperty(value = "家庭编码", index = 5)
    private String familyCode;

    @ExcelProperty(value = "组名称", index = 6)
    private String groupName;

    @ExcelProperty(value = "分类救助类别", index = 7)
    private String classifiedRescueCategory;

    @ExcelProperty(value = "申请日期", index = 8)
    private String applyDate;

    @ExcelProperty(value = "户主姓名", index = 9)
    private String houseHolderName;

    @ExcelProperty(value = "户主身份证", index = 10)
    private String houseHolderCardNo;

    @ExcelProperty(value = "户主编码", index = 11)
    private String houseHolderCode;

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

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

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

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

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

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

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

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

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

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

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

    @ExcelProperty(value = "居住地邮编", index = 23)
    private String residencePostalCode;

    @ExcelProperty(value = "救助证号", index = 24)
    private String salvageCertificateNo;

    @ExcelProperty(value = "保障人口数", index = 25)
    private String guaranteedPopulationNumber;

    @ExcelProperty(value = "家庭人口数", index = 26)
    private String familyPopulationNumber;

    @ExcelProperty(value = "开户人", index = 27)
    private String accountPerson;

    @ExcelProperty(value = "开户银行", index = 28)
    private String accountBank;

    @ExcelProperty(value = "开户人身份证号", index = 29)
    private String accountCardNo;

    @ExcelProperty(value = "银行账号", index = 30)
    private String bankAccount;

    @ExcelProperty(value = "供养机构", index = 31)
    private String supportInstitutions;

    @ExcelProperty(value = "资金发放方式", index = 32)
    private String distributionMethod;

    @ExcelProperty(value = "保障金额", index = 33)
    private String guaranteedAmount;

    @ExcelProperty(value = "调剂金额", index = 34)
    private String reallocationAmount;

    @ExcelProperty(value = "差额救助金额", index = 35)
    private String differenceReliefAmount;

    @ExcelProperty(value = "分类施保金额", index = 36)
    private String classifiedInsuredAmount;

    @ExcelProperty(value = "家庭月总收入", index = 37)
    private String totalMonthlyFamilyIncome;

    @ExcelProperty(value = "家庭月均收入", index = 38)
    private String averageMonthlyFamilyIncome;

    @ExcelProperty(value = "家庭月支出", index = 39)
    private String totalMonthlyFamilyExpenditure;

    @ExcelProperty(value = "经度", index = 40)
    private String lng;

    @ExcelProperty(value = "纬度", index = 41)
    private String lat;

    @ExcelProperty(value = "始发年月", index = 42)
    private String originateDate;

    @ExcelProperty(value = "护理费", index = 43)
    private String nursingFee;

    @ExcelProperty(value = "申请理由", index = 44)
    private String applyReason;

    @ExcelProperty(value = "审核意见", index = 45)
    private String reviewComment;

    @ExcelProperty(value = "错误信息", index = 46)
    private String mistake;
}