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.baomidou.mybatisplus.annotation.TableField; 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; @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class HouseTenantExcel implements Serializable { private static final long serialVersionUID = 2L; /** * 出租屋ID */ @ExcelProperty(value = "地址编码") @ColumnWidth(25) private String houseCode; /** * 姓名 */ @ExcelProperty(value = "姓名") @ColumnWidth(25) private String name; /** * 联系电话 */ @ExcelProperty(value = "联系电话") @ColumnWidth(25) private String phone; /** * 身份证 */ @ExcelProperty(value = "身份证") @ColumnWidth(25) private String idCard; /** * 户籍 */ @ExcelProperty(value = "户籍") @ColumnWidth(25) private String domicile; /** * 工作单位 */ @ExcelProperty(value = "工作单位") @ColumnWidth(25) private String workUnit; /** * 备注 */ @ExcelProperty(value = "备注") @ColumnWidth(25) private String remark; /** 性别 1: 男 0:女 2: 未知 */ @ColumnWidth(15) @ExcelProperty( value = "性别",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "sex") @ExcelDictItem(type = "sex") private String gender; /** 民族 */ @ColumnWidth(15) @ExcelProperty( value = "民族",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "nationType") @ExcelDictItem(type = "nationType") private String ethnicity; }