From 61060637cf0c0910b20eaae6fc4992a723214e40 Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期二, 25 五月 2021 21:57:30 +0800
Subject: [PATCH] feat(部门信息修改时同步更新人员信息表中的部门):
---
febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java | 14 ++++++++++++++
febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DeptServiceImpl.java | 4 ++++
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/task/ScheduledTask.java | 4 ++--
3 files changed, 20 insertions(+), 2 deletions(-)
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 58ced15..f5e24e0 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
@@ -42,11 +42,11 @@
@Scheduled(cron = "0 0 2 * * ?")
public void updateDeptName(){
log.info("每天凌晨2点更新部门名称和全称");
- empBaseInfoService.updateDeptName();
+ // empBaseInfoService.updateDeptName();
}
@Override
public void run(String... args) throws Exception {
calculateSeniority();
- updateDeptName();
+ // updateDeptName();
}
}
diff --git a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
index 98ee69a..91aa35e 100644
--- a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
+++ b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
@@ -15,4 +15,18 @@
" where allDeptName like #{queryParam}" +
"</script>")
public void changeAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam);
+
+ @Update("<script>" +
+ " update t_emp_baseinfo\n" +
+ " set allDeptName = replace(allDeptName, #{fromName}, #{toName})" +
+ " where allDeptName like #{queryParam}" +
+ "</script>")
+ public void updateEmpAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam);
+
+ @Update("<script>" +
+ " update t_emp_baseinfo \n" +
+ " set deptName = #{newDeptName} \n" +
+ " where deptId = #{queryParam} \n" +
+ "</script>")
+ public void updateEmpDeptName(@Param("newDeptName") String newDeptName,@Param("queryParam") String queryParam);
}
\ No newline at end of file
diff --git a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DeptServiceImpl.java b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DeptServiceImpl.java
index 769add2..ed58c79 100644
--- a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DeptServiceImpl.java
+++ b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DeptServiceImpl.java
@@ -108,10 +108,14 @@
}
String oldAllName = dept.getAllDeptName();
String newAllName = createALlDeptName(dept);
+ Long deptId = dept.getDeptId();
+ String newDeptName = dept.getDeptName();
dept.setModifyTime(new Date());
this.baseMapper.updateById(dept);
deptMapper.changeAllDeptName(oldAllName,newAllName,oldAllName + "%");
+ deptMapper.updateEmpAllDeptName(oldAllName,newAllName,oldAllName + "%");
+ deptMapper.updateEmpDeptName(newDeptName,deptId.toString());
}
@Override
--
Gitblit v1.8.0