/* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.dispatcher.excel; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.format.DateTimeFormat; 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; import java.util.Date; /** * @author zhongrj * @since 2021-08-23 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class DispatcherUnitExcel implements Serializable { private static final long serialVersionUID = 1L; // @ColumnWidth(25) @ExcelProperty("企业名称*") private String deptName; // @ColumnWidth(25) @ExcelProperty("派遣单位名称*") private String name; @ExcelProperty("派遣单位地址*") private String address; @ExcelProperty("经度") private String longitude; @ExcelProperty("纬度") private String latitude; @ExcelProperty("派遣单位所属辖区") private String jurisdiction; @ExcelProperty(value = "派遣单位类型*",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "dispatcherUnitType") @ExcelDictItem(type = "dispatcherUnitType") private String district; @ExcelProperty(value = "派遣单位行业*",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "dispatchProfession") @ExcelDictItem(type = "dispatchProfession") private String profession; // @ColumnWidth(20) @ExcelProperty("派遣单位联系人*") private String linkman; // @ColumnWidth(20) @ExcelProperty("派遣单位联系电话*") private String phone; // @ColumnWidth(20) @ExcelProperty("合同开始时间*") @DateTimeFormat("yyyy/MM/dd") private Date startTime; // @ColumnWidth(20) @ExcelProperty("合同结束时间*") @DateTimeFormat("yyyy/MM/dd") private Date endTime; // @ColumnWidth(20) @ExcelProperty("保安服务类型") private String serveType; // @ColumnWidth(20) @ExcelProperty("负责人*") private String securityLinkman; // @ColumnWidth(20) @ExcelProperty("负责人联系电话*") private String cell; // @ColumnWidth(20) @ExcelProperty("派遣保安员数*") private Integer num; }