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