package com.ruoyi.staff.dto; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.framework.aspectj.lang.annotation.Excel; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; @Data public class StaffOnJobImportDto { @Excel(name = "员工编号", cellType = Excel.ColumnType.STRING, sort = 1) private String staffNo; @Excel(name = "姓名", sort = 2) private String staffName; @Excel(name = "性别", sort = 3, combo = {"male", "female"}) private String sex; @Excel(name = "民族", sort = 4) private String nation; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "出生日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 5) private Date birthDate; @Excel(name = "身份证号", cellType = Excel.ColumnType.STRING, sort = 6) private String identityCard; @Excel(name = "现住址", sort = 7) private String adress; @Excel(name = "联系电话", cellType = Excel.ColumnType.STRING, sort = 8) private String phone; @Excel(name = "紧急联系人电话", cellType = Excel.ColumnType.STRING, sort = 9) private String emergencyContactPhone; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "入职日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 10) private Date entryDate; @Excel(name = "岗位", sort = 11, prompt = "Fill enabled post name") private String postName; @Excel(name = "部门", sort = 12, prompt = "Fill enabled department name") private String deptName; @Excel(name = "合同年限", sort = 13) private String contractTerm; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "合同开始日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 14) private Date contractStartTime; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "合同结束日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 15) private Date contractEndTime; }