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 Integer buildingNo;

	/** 图片URLS */
	@ExcelProperty( "图片URLS")
	private String imageUrls;

	/** 创建人 */
	@ExcelProperty( "创建人")
	private String createUser;

	/** 创建时间 */
	@ExcelProperty( "创建时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private Date createTime;

	/** 更新人 */
	@ExcelProperty( "更新人")
	private String updateUser;

	/** 更新时间 */
	@ExcelProperty( "更新时间")
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private Date updateTime;

	/** 备注 */
	@ExcelProperty( "备注")
	private String remark;


}