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.math.BigDecimal; 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 = {"男", "女"}) private String sex; @Excel(name = "籍贯", sort = 4) private String nativePlace; @Excel(name = "岗位", sort = 5, prompt = "请填写系统中已存在的岗位名称") private String postName; @Excel(name = "部门", sort = 6, prompt = "请填写系统中已存在的部门名称") private String deptName; @Excel(name = "现住址", sort = 7) private String adress; @Excel(name = "第一学历", sort = 8) private String firstStudy; @Excel(name = "专业", sort = 9) private String profession; @Excel(name = "年龄", sort = 11) private String age; @Excel(name = "联系电话", cellType = Excel.ColumnType.STRING, sort = 12) private String phone; @Excel(name = "紧急联系人", sort = 13) private String emergencyContact; @Excel(name = "紧急联系人联系电话", cellType = Excel.ColumnType.STRING, sort = 14) private String emergencyContactPhone; @Excel(name = "合同年限", sort = 15) private String contractTerm; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "合同开始日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 16) private Date contractStartTime; @JsonFormat(pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") @Excel(name = "合同结束日期", width = 30, dateFormat = "yyyy-MM-dd", sort = 17) private Date contractEndTime; }