package com.ruoyi.admin.importExcel;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
|
import lombok.Data;
|
import org.apache.poi.ss.usermodel.IndexedColors;
|
|
import java.io.Serializable;
|
|
/**
|
* 导入模板
|
*/
|
@Data
|
public class FrozenBuckleImportDTO implements Serializable {
|
@ExcelProperty(value = "*站点名称")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String siteName;
|
|
@ExcelProperty(value = "*服务信息")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String serveName;
|
|
@ExcelProperty(value = "*预约姓名")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String reservationName;
|
@ExcelProperty(value = "*预约电话")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String reservationPhone;
|
@ExcelProperty(value = "省份(四川省)")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11)
|
private String province;
|
@ExcelProperty(value = "市(成都市)")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11)
|
private String city;
|
@ExcelProperty(value = "区(武侯区)")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11)
|
private String area;
|
@ExcelProperty(value = "*详细地址")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String reservationAddress;
|
@ExcelProperty(value = "*上门时间(2024-02-28)")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11,color = 10)
|
private String time;
|
@ExcelProperty(value = "服务人员")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11)
|
private String serverName;
|
@ExcelProperty(value = "备注")
|
@HeadFontStyle(fontName = "黑体", fontHeightInPoints = 11)
|
private String reservationRemark;
|
|
private Integer siteId;
|
private Integer serverId;
|
private Integer serveId;
|
private Double longitude;
|
private Double latitude;
|
private String provinceCode;
|
private String cityCode;
|
private String areaCode;
|
private String serverPhone;
|
}
|
