/* * 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.accreditation.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 java.io.Serializable; import java.util.Date; /** * ExamPaymentExcel * @author zhongrj * @since 2021-10-29 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(30) public class ExportSecurityBookPaperExcel implements Serializable { private static final long serialVersionUID = 1L; @ColumnWidth(15) @ExcelProperty("姓名") private String realName; @ColumnWidth(20) @ExcelProperty("身份证号码") private String idCardNo; @ColumnWidth(35) @ExcelProperty("企业名称") private String deptName; @ColumnWidth(20) @ExcelProperty("保安证编号") private String securityNumber; /** * 申请人姓名 */ @ColumnWidth(20) @ExcelProperty("申请人") private String applyName; /** * 申请人单位 */ @ColumnWidth(20) @ExcelProperty("申请人单位") private String applyUnit; @ColumnWidth(20) @ExcelProperty("申请人时间") @DateTimeFormat("yyyy-MM-dd HH:mm:ss") private Date createTime; /** * 审核状态 1:待审核 2:审核通过 3:审核不通过 */ @ColumnWidth(15) @ExcelProperty("审核状态") private String auditStatus; /** * 审核时间 */ @DateTimeFormat("yyyy-MM-dd HH:mm:ss") @ColumnWidth(20) @ExcelProperty("审核时间") private Date auditTime; /** * 审核详情 */ @ColumnWidth(20) @ExcelProperty("审核详情") private String auditDetail; /** * 是否制证 */ @ColumnWidth(10) @ExcelProperty("是否制证") private String userType; }