From bbff5bb89738ea3fabb480d3ca3ba13f78e18ced Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期三, 28 一月 2026 17:48:52 +0800
Subject: [PATCH] 新增离职后，对应用户停用
---
src/main/java/com/ruoyi/staff/service/impl/StaffLeaveServiceImpl.java | 11 +++++++++++
doc/20260128_add_unique_to_staff_on_job.sql | 1 +
2 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/doc/20260128_add_unique_to_staff_on_job.sql b/doc/20260128_add_unique_to_staff_on_job.sql
new file mode 100644
index 0000000..16b2221
--- /dev/null
+++ b/doc/20260128_add_unique_to_staff_on_job.sql
@@ -0,0 +1 @@
+ALTER TABLE staff_on_job ADD unique (staff_no);
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/staff/service/impl/StaffLeaveServiceImpl.java b/src/main/java/com/ruoyi/staff/service/impl/StaffLeaveServiceImpl.java
index ac9792c..53604e0 100644
--- a/src/main/java/com/ruoyi/staff/service/impl/StaffLeaveServiceImpl.java
+++ b/src/main/java/com/ruoyi/staff/service/impl/StaffLeaveServiceImpl.java
@@ -5,6 +5,8 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.project.system.domain.SysUser;
+import com.ruoyi.project.system.mapper.SysUserMapper;
import com.ruoyi.staff.dto.StaffLeaveDto;
import com.ruoyi.staff.mapper.StaffLeaveMapper;
import com.ruoyi.staff.mapper.StaffOnJobMapper;
@@ -29,6 +31,9 @@
@Autowired
private StaffOnJobMapper staffOnJobMapper;
+
+ @Autowired
+ private SysUserMapper sysUserMapper;
//鏂板绂昏亴鍒楄〃鍒嗛〉鏌ヨ
@Override
@@ -61,6 +66,12 @@
}
staffLeaveMapper.insert(staffLeave);
+ // 鏇存柊瀵瑰簲鐢ㄦ埛鐘舵�佷负鍋滅敤
+ // 鏍规嵁鍛樺伐缂栧彿鏌ヨ鐢ㄦ埛
+ SysUser sysUser = sysUserMapper.selectUserByUserName(staffOnJob.getStaffNo());
+ sysUser.setStatus("1");
+ sysUserMapper.updateUser(sysUser);
+
// 鏇存柊绂昏亴鐘舵�佷负绂昏亴
staffOnJob.setStaffState(0);
return staffOnJobMapper.updateById(staffOnJob);
--
Gitblit v1.9.3