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;
|
|
}
|
