package org.springblade.modules.place.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 lombok.Data;
|
import org.springblade.common.excel.ExcelDictConverter;
|
import org.springblade.common.excel.ExcelDictItem;
|
import org.springblade.common.excel.ExcelDictItemLabel;
|
|
import java.io.Serializable;
|
|
/**
|
* HouseExcel
|
*
|
* @author Chill
|
*/
|
@Data
|
@ColumnWidth(25)
|
@HeadRowHeight(20)
|
@ContentRowHeight(18)
|
public class ImportPlaceExcel implements Serializable {
|
|
private static final long serialVersionUID = 2L;
|
|
/** 门牌地址编码 */
|
@ExcelProperty( "门牌地址编码*")
|
private String houseCode;
|
|
/** 地址 */
|
@ColumnWidth(25)
|
@ExcelProperty( "地址")
|
private String location;
|
|
/** 经度 */
|
@ColumnWidth(25)
|
@ExcelProperty( "经度")
|
private String lng;
|
|
/** 纬度 */
|
@ColumnWidth(25)
|
@ExcelProperty( "纬度")
|
private String lat;
|
|
/** 街道名称 */
|
@ExcelProperty( "街道名称")
|
private String streetName;
|
|
/** 社区名称 */
|
@ExcelProperty( "社区名称")
|
private String communityName;
|
|
/** 网格名称 */
|
@ExcelProperty( "网格名称")
|
private String gridName;
|
|
/** 场所名称 */
|
@ColumnWidth(25)
|
@ExcelProperty( "场所名称*")
|
private String placeName;
|
|
/** 场所负责人 */
|
@ColumnWidth(15)
|
@ExcelProperty( "场所负责人")
|
private String principal;
|
|
/** 场所负责人联系电话 */
|
@ColumnWidth(15)
|
@ExcelProperty( "场所负责人联系电话")
|
private String principalPhone;
|
|
/** 场所负责人身份证号 */
|
@ColumnWidth(15)
|
@ExcelProperty( "场所负责人身份证号")
|
private String principalIdCard;
|
|
/** 企业法定代表 */
|
@ColumnWidth(15)
|
@ExcelProperty( "企业法定代表")
|
private String legalPerson;
|
|
/** 法定代表联系电话 */
|
@ColumnWidth(15)
|
@ExcelProperty( "法定代表联系电话")
|
private String legalTel;
|
|
/** 企业法定代表身份证号码 */
|
@ColumnWidth(15)
|
@ExcelProperty( "企业法定代表身份证号码")
|
private String legalIdCard;
|
|
/** 九小场所类型 */
|
@ExcelProperty( value = "九小场所类型",converter = ExcelDictConverter.class)
|
@ExcelDictItem(type = "nineType")
|
@ExcelDictItemLabel(type = "nineType")
|
private String nineType;
|
|
/** 阵地类型 */
|
@ExcelProperty( value = "阵地类型",converter = ExcelDictConverter.class)
|
@ExcelDictItem(type = "frontType")
|
@ExcelDictItemLabel(type = "frontType")
|
private String frontType;
|
|
/** 1：是 2：否 三级消防单位 */
|
@ExcelProperty("三级消防单位(是/否)")
|
private String threeFireProtection;
|
|
/** 无诈类别 */
|
@ExcelProperty(value = "无诈类别", converter = ExcelDictConverter.class)
|
@ExcelDictItem(type = "noExplosionCategory")
|
@ExcelDictItemLabel(type = "noExplosionCategory")
|
private String noExplosionCategory;
|
|
/** 标签分类代码 */
|
@ExcelProperty( "标签分类代码")
|
private String labelCode;
|
|
/** 备注 */
|
@ExcelProperty( "备注")
|
private String remark;
|
|
}
|
