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