From f7dd80d1383f406ba46c417a7c9a95181db94d1a Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期二, 16 四月 2024 21:56:36 +0800
Subject: [PATCH] fix: 问题修复 1.数据统计模块中查看合同出错
---
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java
index 90648eb..3ec7dd9 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java
@@ -207,7 +207,17 @@
@SqlParser(filter=true)
IPage<EmpBaseInfo> clbaseInfoList(@Param("page")Page<EmpBaseInfo> page,@Param("index") String index,@Param("btime") String btime,@Param("etime") String etime,@Param("name") String name,@Param("manOld") String manOld,@Param("womanOld") String womanOld,@Param("list") List<String> lists);
-
-
+ @Update("<script> " +
+ " UPDATE t_emp_baseinfo SET seniority = CONCAT(FLOOR(TimeStampDiff(MONTH, entryDate, NOW()) / 12), '年',MOD(TimeStampDiff(MONTH, entryDate, NOW()),12),'月'),\n" +
+ " modifyTime = NOW() \n" +
+ " WHERE empStatus =0; \n" +
+ "</script>")
+ int updateSeniority();
+ @Update("<script> " +
+ " update t_emp_baseinfo set deptName=(select DEPT_NAME from t_dept where DEPT_ID=deptId), \n" +
+ " allDeptName=(select allDeptName from t_dept where DEPT_ID=deptId), \n" +
+ " modifyTime=now(); \n" +
+ "</script>")
+ int updateDeptName();
}
\ No newline at end of file
--
Gitblit v1.8.0