From 35cfaa7259f3d494e7bd03aec5c7e035049ee19b Mon Sep 17 00:00:00 2001
From: yubo <autumnal_wind@yeah.net>
Date: 星期三, 24 九月 2025 19:34:09 +0800
Subject: [PATCH] feat: 新增社保档位提醒功能

---
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/entity/EmpInsurance.java |  237 +++++++++++++++++++++++++++++++++++++----------------------
 1 files changed, 148 insertions(+), 89 deletions(-)

diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/entity/EmpInsurance.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/entity/EmpInsurance.java
index b6370bc..b224015 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/entity/EmpInsurance.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/entity/EmpInsurance.java
@@ -1,114 +1,173 @@
 package cc.mrbird.febs.server.hr.entity;
 
-    import java.util.Date;
-import lombok.Data;
-import com.baomidou.mybatisplus.annotation.IdType;
+import cc.mrbird.febs.common.core.annotation.FieldInfo;
+import cc.mrbird.febs.common.core.converter.TimeConverter;
+import cc.mrbird.febs.common.core.utils.DateDeSerializer;
+import cc.mrbird.febs.common.core.utils.DateSerializer;
+import cc.mrbird.febs.common.core.utils.DateTimeDeserializer;
+import cc.mrbird.febs.common.core.utils.DateTimeSerializer;
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.baomidou.mybatisplus.annotation.TableId;
 import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.Version;
+import com.fasterxml.jackson.databind.annotation.JsonDeserialize;
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.wuwenze.poi.annotation.Excel;
+import com.wuwenze.poi.annotation.ExcelField;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.util.Date;
 
 /**
-*
-* name:EmpInsurance
-* package:cc.mrbird.febs.server.hr.controller
-* description:员工社保申请数据表映射实体
-*
-* @author luoyibo
-* @date 2021-01-24 20:35:33
-* @since JDK1.8
-*/
+ * name:EmpInsurance
+ * package:cc.mrbird.febs.server.hr.controller
+ * description:员工社保申请数据表映射实体
+ *
+ * @author luoyibo
+ * @date 2021-01-31 11:26:23
+ * @since JDK1.8
+ */
 @Data
 @TableName("t_emp_insurance")
-public class EmpInsurance {
+@Excel("员工社保申请")
+public class EmpInsurance implements Serializable {
 
-        /**
-        * 社保Id
-        */
-            @TableId(value = "insuranceId", type = IdType.AUTO)
-            private Long insuranceId;
+    private static final long serialVersionUID = 208703298339870887L;
+    //@FieldInfo(name = "insuranceId", type = "bigint", explain = "社保Id")
+    @TableId(value = "insuranceId")
+    private Long insuranceId = 0L;
 
-        /**
-        * 员工Id
-        */
-            @TableField("empId")
-            private Long empId;
+    //@FieldInfo(name = "empId", type = "bigint", explain = "员工Id")
+    @TableField("empId")
+    private Long empId = 0L;
 
-        /**
-        * 申请日期
-        */
-            @TableField("applayDate")
-            private Date applayDate;
+    @FieldInfo(name = "empNumb", type = "varchar", explain = "编号")
+    @TableField("empNumb")
+    @ExcelField(value = "编号")
+    private String empNumb = "";
 
-        /**
-        * 申请人
-        */
-            @TableField("proposer")
-            private String proposer;
+    @FieldInfo(name = "allDeptName", type = "bit", explain = "部门(护卫点)")
+    @ExcelField(value = "部门(护卫点)")
+    @TableField(exist = false)
+    private String allDeptName = "";
 
-        /**
-        * 社保档位
-        */
-            @TableField("insuranceGaers")
-            private String insuranceGaers;
+    @FieldInfo(name = "jobName", type = "varchar", explain = "岗位名称")
+    @TableField("jobName")
+    @ExcelField(value = "岗位")
+    private String jobName = "";
 
-        /**
-        * 是否已报告 0-未报告 1-已报告
-        */
-            @TableField("reportStatus")
-            private Integer reportStatus;
+    @FieldInfo(name = "empName", type = "varchar", explain = "姓名")
+    @TableField("empName")
+    @ExcelField(value = "姓名")
+    private String empName = "";
 
-        /**
-        * 申请状态 0-未申请 1-已申请
-        */
-            @TableField("applayStatus")
-            private Integer applayStatus;
+    @FieldInfo(name = "certificateNumb", type = "varchar", explain = "身份证号码")
+    @TableField("certificateNumb")
+    @ExcelField(value = "身份证号码")
+    private String certificateNumb = "";
 
-        /**
-        * 审核人
-        */
-            @TableField("auditor")
-            private String auditor;
+    @FieldInfo(name = "applayDate", type = "date", explain = "申请日期")
+    @TableField("applayDate")
+    @JsonSerialize(using = DateSerializer.class)
+    @JsonDeserialize(using = DateDeSerializer.class)
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @ExcelField(value = "社保申请日期", writeConverter = TimeConverter.class)
+    private Date applayDate;
 
-        /**
-        * 记录创建时间
-        */
-            @TableField("createTime")
-            private Date createTime;
+    @FieldInfo(name = "proposer", type = "varchar", explain = "申请人")
+    @TableField("proposer")
+    @ExcelField(value = "申请人")
+    private String proposer = "";
 
-        /**
-        * 记录创建人
-        */
-            @TableField("creator")
-            private String creator;
+    @FieldInfo(name = "insuranceGaers", type = "varchar", explain = "社保档位")
+    @TableField("insuranceGaers")
+    private String insuranceGaers = "";
 
-        /**
-        * 记录最后更新时间
-        */
-            @TableField("modifyTime")
-            private Date modifyTime;
+    @ExcelField(value = "社保档位")
+    @TableField(exist = false)
+    private String insuranceGaersName = "";
 
-        /**
-        * 记录最后更新人
-        */
-            @TableField("modifier")
-            private String modifier;
+    @FieldInfo(name = "reportStatus", type = "bit", explain = "是否已报告1-未报告 2-已报告")
+    @TableField("reportStatus")
+    @ExcelField(value = "是否已报告", writeConverterExp = "1=未报告,2=已报告")
+    private Integer reportStatus = 0;
 
-        /**
-        * 记录删除标志。0-未删除 1-已删除,默认0
-        */
-            @TableField("delFlag")
-            private Integer delFlag;
+    @FieldInfo(name = "applayStatus", type = "bit", explain = "申请状态 1-未申请 2-已申请")
+    @TableField("applayStatus")
+    @ExcelField(value = "状态", writeConverterExp = "1=未申请,2=已申请")
+    private Integer applayStatus = 0;
 
-        /**
-        * 记录版本号,用来进行乐观锁控制
-        */
-            @TableField("version")
-            private Integer version;
+    @FieldInfo(name = "auditor", type = "varchar", explain = "审核人")
+    @TableField("auditor")
+    @ExcelField(value = "审核人")
+    private String auditor = "";
 
-        /**
-        * 备注
-        */
-            @TableField("remark")
-            private String remark;
+    @FieldInfo(name = "remark", type = "varchar", explain = "备注")
+    @TableField("remark")
+    @ExcelField(value = "备注")
+    private String remark = "";
 
-}
\ No newline at end of file
+    @FieldInfo(name = "empStatus", type = "varchar", explain = "员工状态")
+    @TableField("empStatus")
+//    @ExcelField(value = "员工状态",writeConverterExp = "0=在职,1=离职,2=退休" )
+    private String empStatus = "";
+
+    @FieldInfo(name = "sex", type = "varchar", explain = "性别码")
+    @TableField("sex")
+//    @ExcelField(value = "性别", writeConverterExp = "1=男,2=女")
+    private String sex = "";
+
+    //@FieldInfo(name = "deptId", type = "bigint", explain = "部门Id")
+    @TableField("deptId")
+    private Long deptId = 0L;
+
+    @FieldInfo(name = "deptName", type = "varchar", explain = "部门(护卫点)")
+    @TableField("deptName")
+    private String deptName = "";
+
+    //@FieldInfo(name = "JobId", type = "bigint", explain = "岗位Id")
+    @TableField("JobId")
+    private Long jobId = 0L;
+
+    @TableField(exist = false)
+    private String reportStatusName ;
+
+    @TableField(exist = false)
+    private String applayStatusName ;
+
+    //@FieldInfo(name = "createTime", type = "datetime", explain = "记录创建时间")
+    @TableField("createTime")
+    @JsonSerialize(using = DateTimeSerializer.class)
+    @JsonDeserialize(using = DateTimeDeserializer.class)
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private Date createTime;
+
+    //@FieldInfo(name = "creator", type = "varchar", explain = "记录创建人")
+    @TableField("creator")
+    private String creator = "";
+
+    //@FieldInfo(name = "modifyTime", type = "datetime", explain = "记录最后更新时间")
+    @TableField("modifyTime")
+    @JsonSerialize(using = DateTimeSerializer.class)
+    @JsonDeserialize(using = DateTimeDeserializer.class)
+    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+    private Date modifyTime;
+
+    //@FieldInfo(name = "modifier", type = "varchar", explain = "记录最后更新人")
+    @TableField("modifier")
+    private String modifier = "";
+
+    //@FieldInfo(name = "delFlag", type = "bit", explain = "记录删除标志。0-未删除 1-已删除,默认0")
+    @TableField("delFlag")
+    private Integer delFlag = 0;
+
+    //@FieldInfo(name = "version", type = "int", explain = "记录版本号,用来进行乐观锁控制")
+    @TableField("version")
+    // @Version
+    private Integer version = 0;
+
+    @TableField(exist = false)
+    private String applayDateStr;
+}

--
Gitblit v1.8.0