package org.springblade.modules.system.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 io.swagger.annotations.ApiModelProperty;
|
import lombok.Data;
|
import org.springblade.common.excel.ExcelDictConverter;
|
import org.springblade.common.excel.ExcelDictItem;
|
import org.springblade.common.excel.ExcelDictItemLabel;
|
import org.springframework.format.annotation.DateTimeFormat;
|
|
import java.io.Serializable;
|
import java.util.Date;
|
|
/**
|
* UserExcel
|
*
|
* @author Chill
|
*/
|
@Data
|
@ColumnWidth(25)
|
@HeadRowHeight(20)
|
@ContentRowHeight(18)
|
public class SecurityExcel implements Serializable {
|
private static final long serialVersionUID = 1L;
|
|
@ExcelProperty("企业名称*")
|
@ColumnWidth(30)
|
private String deptId;
|
|
@ColumnWidth(10)
|
@ExcelProperty("姓名*")
|
private String realName;
|
|
@ColumnWidth(15)
|
@ExcelProperty("联系电话*")
|
private String phone;
|
|
@ExcelProperty(value = "性别*(男/女)",converter = ExcelDictConverter.class)
|
@ColumnWidth(10)
|
@ExcelDictItemLabel(type = "sex")
|
@ExcelDictItem(type = "sex")
|
private String sex;
|
|
@ExcelProperty("身份证号*")
|
@ColumnWidth(20)
|
private String cardid;
|
|
@ExcelProperty("民族")
|
@ColumnWidth(10)
|
private String nation;
|
|
@ExcelProperty("从业单位*")
|
@ColumnWidth(20)
|
private String unitName;
|
|
@ExcelProperty("保安员证编号")
|
@ColumnWidth(15)
|
private String securitynumber;
|
|
@ExcelProperty(value = "最高学历*(初中及以下/高中/中技/中专/大专/本科/博士/硕士)",converter = ExcelDictConverter.class)
|
@ColumnWidth(20)
|
@ExcelDictItemLabel(type = "educationType")
|
@ExcelDictItem(type = "educationType")
|
private String education;
|
|
@ExcelProperty("政治面貌*")
|
@ColumnWidth(20)
|
private String politicaloutlook;
|
/**
|
* 婚姻状态
|
*/
|
@ExcelProperty(value = "婚姻状态*(未婚/已婚/离异/丧偶)",converter = ExcelDictConverter.class)
|
@ExcelDictItemLabel(type = "marriageStatusType")
|
@ExcelDictItem(type = "marriageStatusType")
|
private String marriageStatus;
|
/**
|
* 报考等级
|
*/
|
@ExcelProperty(value = "报考等级(初级/中级/高级/特级)",converter = ExcelDictConverter.class)
|
@ExcelDictItemLabel(type = "signLevelType")
|
@ExcelDictItem(type = "signLevelType")
|
private String signLevel;
|
/**
|
* 户籍地址
|
*/
|
@ExcelProperty(value = "户籍地址*")
|
private String permanentResidenceAddress;
|
/**
|
* 居住地址
|
*/
|
@ExcelProperty(value = "居住地址")
|
private String dwellAddress;
|
/**
|
* 家庭主要成员及联系方式
|
*/
|
@ExcelProperty(value = "家庭主要成员及联系方式")
|
private String memberOfFamily;
|
/**
|
* 工作经历
|
*/
|
@ExcelProperty(value = "工作经历")
|
private String workExperience;
|
/**
|
* 教育经历
|
*/
|
@ExcelProperty(value = "教育经历")
|
private String educationExperience;
|
|
/**
|
* 受理公安机关
|
*/
|
@ExcelProperty(value = "受理公安机关")
|
private String acceptancePoliceUnit;
|
|
/**
|
* 受理人
|
*/
|
@ExcelProperty(value = "受理人")
|
private String acceptancePerson;
|
|
/**
|
* 受理时间
|
*/
|
@ExcelProperty(value = "受理时间")
|
private String acceptanceTime;
|
|
|
}
|
