package org.springblade.modules.exam.excel; import com.alibaba.excel.annotation.ExcelIgnore; 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; /** * ExamPaymentExcel * @author zhongrj * @since 2021-10-19 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class ExportExamScoreExcel implements Serializable { private static final long serialVersionUID = 1L; @ColumnWidth(30) @ExcelProperty("考试名称") private String examName; @ColumnWidth(15) @ExcelProperty("姓名") private String securityName; @ColumnWidth(20) @ExcelProperty("身份证号码") private String idCardNo; @ColumnWidth(20) @ExcelProperty("准考证号") private String candidateNo; @ColumnWidth(25) @ExcelProperty("企业名称") @ExcelIgnore private String companyName; @ColumnWidth(25) @ExcelProperty("从业单位") private String unitName; @ColumnWidth(20) @ExcelProperty("考试开始时间") private String examTime; @ColumnWidth(20) @ExcelProperty("考试结束时间") private String examEndTime; @ColumnWidth(15) @ExcelProperty("理论成绩") private Integer theoryGrade; @ColumnWidth(15) @ExcelProperty("实操成绩") private String learnGrade; @ColumnWidth(15) @ExcelProperty("是否合格") private String qualified; @ColumnWidth(20) @ExcelProperty("保安员证编号") private String securityNumber; /** * 婚姻状态 */ @ExcelProperty(value = "婚姻状态*(未婚/已婚/离异/丧偶)",converter = ExcelDictConverter.class) @ExcelDictItem(type = "marriageStatusType") private String marriageStatus; /** * 报考等级 */ @ExcelProperty(value = "报考等级(初级/中级/高级/特级)",converter = ExcelDictConverter.class) @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; }