From db6a13645ba212dee0ef46548cc3468d30b76873 Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期一, 24 五月 2021 21:29:05 +0800
Subject: [PATCH] feat(定时更新基本信息表的部门名称与全称):
---
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java | 7 ++++++-
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java | 2 ++
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java | 7 +++++++
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java | 5 +++++
4 files changed, 20 insertions(+), 1 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 4d9d1b4..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
@@ -213,6 +213,11 @@
" 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
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
index 70a8da8..7853f4b 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/IEmpBaseInfoService.java
@@ -204,4 +204,6 @@
List<EmpBaseInfo> listAll(QueryWrapper<EmpBaseInfo> wrapper);
boolean updateSeniority();
+
+ boolean updateDeptName();
}
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
index ccdb128..18af1a3 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpBaseInfoServiceImpl.java
@@ -1384,4 +1384,9 @@
public boolean updateSeniority() {
return empBaseInfoMapper.updateSeniority()>0;
}
+
+ @Override
+ public boolean updateDeptName() {
+ return empBaseInfoMapper.updateDeptName()>0;
+ }
}
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java
index 8afbcfe..58ced15 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java
@@ -38,8 +38,15 @@
log.info("每天凌晨1点计算一次工龄");
empBaseInfoService.updateSeniority();
}
+
+ @Scheduled(cron = "0 0 2 * * ?")
+ public void updateDeptName(){
+ log.info("每天凌晨2点更新部门名称和全称");
+ empBaseInfoService.updateDeptName();
+ }
@Override
public void run(String... args) throws Exception {
calculateSeniority();
+ updateDeptName();
}
}
--
Gitblit v1.8.0