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.math.BigDecimal; import java.util.Date; /** * HouseExcel * * @author Chill */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class HouseAndHoldExcel implements Serializable { private static final long serialVersionUID = 2L; /** 门牌地址编码 */ @ExcelProperty( "地址编码") private String houseCode; /** 房屋名称 */ @ExcelProperty( "详细地址") private String houseName; /** 小区 */ @ExcelProperty( "小区") private String districtName; /** 幢 */ @ExcelProperty( "幢") private String building; /** 单元 */ @ExcelProperty( "单元") private String unit; /** 楼层 */ @ExcelProperty( "楼层") private String floor; /** 室 */ @ExcelProperty( "室") private String room; /** 面积 */ @ExcelProperty( "面积") private BigDecimal area; /** 物业单价 */ @ExcelProperty( "物业单价") private BigDecimal propertyPrice; /** 服务到期 */ @ExcelProperty( "服务到期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date serviceDue; /** 备注 */ @ExcelProperty( "备注") private String remark; /** 姓名 */ @ColumnWidth(15) @ExcelProperty( "姓名") private String name; /** 手机号 */ @ColumnWidth(15) @ExcelProperty( "手机号") private String phoneNumber; /** 角色 */ @ColumnWidth(15) @ExcelProperty( value = "角色",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "roleType") private String roleType; /** 与角色关系(业主,父子,其他) */ @ColumnWidth(15) @ExcelProperty( value = "与角色关系",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "roleRelation") private String relationship; /** 主要联系人 1:是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "主要联系人",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "primaryContactType") private String isPrimaryContact; /** 居住状态 1: 是 0:否 */ @ColumnWidth(15) @ExcelProperty( value = "居住状态",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "residentialStatusType") private String residentialStatus; /** 身份证 */ @ColumnWidth(15) @ExcelProperty( "身份证") private String idCard; /** 港澳台通行证 */ @ColumnWidth(15) @ExcelProperty( "港澳台通行证") private String hkmtPass; /** 护照 */ @ColumnWidth(15) @ExcelProperty( "护照") private String passport; /** 民族 */ @ColumnWidth(15) @ExcelProperty( value = "民族",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "nationType") private String ethnicity; /** 学历 */ @ColumnWidth(15) @ExcelProperty( value = "学历",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "educationType") private String education; /** 户籍登记地 */ @ColumnWidth(15) @ExcelProperty( "户籍登记地") private String hukouRegistration; /** 工作状态 */ @ColumnWidth(15) @ExcelProperty( value = "工作状态",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "workStatusType") private String workStatus; /** 工作单位 */ @ColumnWidth(15) @ExcelProperty( "工作单位") private String employer; /** 婚姻状态 */ @ColumnWidth(15) @ExcelProperty( value = "婚姻状态",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "marriageStatusType") private String maritalStatus; /** 车牌号 */ @ColumnWidth(15) @ExcelProperty( "车牌号") private String cardNumber; // /** 其他联系方式 */ // @ColumnWidth(15) // @ExcelProperty( "其他联系方式") // private String otherContact; // // /** 现居住地址 */ // @ColumnWidth(15) // @ExcelProperty( "现居住地址") // private String currentAddress; // // /** 残疾证 */ // @ColumnWidth(15) // @ExcelProperty( "残疾证") // private String disabilityCert; // // /** 是否党员 1:党员 2:群众 */ // @ColumnWidth(15) // @ExcelProperty( value = "是否党员",converter = ExcelDictConverter.class) // @ExcelDictItemLabel(type = "partyEmberType") // private Integer partyEmber; /** 备注 */ @ColumnWidth(15) @ExcelProperty( "备注") private String remarks; }