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.FieldFill; import com.baomidou.mybatisplus.annotation.TableField; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springblade.common.excel.ExcelDictConverter; import org.springblade.common.excel.ExcelDictItem; import java.io.Serializable; import java.util.Date; @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class ExportHouseTenantExcel implements Serializable { private static final long serialVersionUID = 2L; /** * 出租屋ID */ @ExcelProperty(value = "房屋地址") @ColumnWidth(25) private String addressName; /** * 出租屋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; /** 性别 */ @ExcelProperty(value = "性别",converter = ExcelDictConverter.class) @ExcelDictItem(type = "sex") @ColumnWidth(25) private Integer gender; /** 民族 */ @ExcelProperty(value = "民族",converter = ExcelDictConverter.class) @ExcelDictItem(type = "nationType") private Integer ethnicity; /** 创建时间 */ @ExcelProperty(value = "创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date createTime; }