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; }