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 java.io.Serializable;
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
/**
|
* HouseExcel
|
*
|
* @author Chill
|
*/
|
@Data
|
@ColumnWidth(25)
|
@HeadRowHeight(20)
|
@ContentRowHeight(18)
|
public class HouseExcel implements Serializable {
|
|
private static final long serialVersionUID = 2L;
|
|
/** 门牌地址编码 */
|
@ExcelProperty( "门牌地址编码")
|
private String houseCode;
|
|
/** 小区编码 */
|
@ExcelProperty( "小区编码")
|
private String districtCode;
|
|
/** 小区 */
|
@ExcelProperty( "小区")
|
private String districtName;
|
|
/** 房屋名称 */
|
@ExcelProperty( "房屋名称")
|
private String houseName;
|
|
/** 绑定手机 */
|
@ExcelProperty( "绑定手机")
|
private String phone;
|
|
/** 面积 */
|
@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 Integer floor;
|
|
/** 幢 */
|
@ExcelProperty( "幢")
|
private String building;
|
|
/** 单元 */
|
@ExcelProperty( "单元")
|
private String unit;
|
|
/** 室 */
|
@ExcelProperty( "室")
|
private String room;
|
|
/** 幢编号 */
|
@ExcelProperty( "幢编号")
|
private String buildingNo;
|
|
/** 备注 */
|
@ExcelProperty( "备注")
|
private String remark;
|
|
|
}
|
