From 2f16c2e5a23587005e9ad5651f1807e618d999b4 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 06 十一月 2026 09:53:06 +0800
Subject: [PATCH] fix(hrm): 考勤记录支持员工姓名搜索,并全量核对两个模块的所有搜索条件
---
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmAttendanceRecordMapper.java | 15 +++++++++++++++
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/service/attendance/HrmAttendanceRecordServiceImpl.java | 15 ++++++++++++++-
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/attendance/vo/HrmAttendanceRecordPageReqVO.java | 3 +++
3 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/attendance/vo/HrmAttendanceRecordPageReqVO.java b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/attendance/vo/HrmAttendanceRecordPageReqVO.java
index 68078d2..99e886b 100644
--- a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/attendance/vo/HrmAttendanceRecordPageReqVO.java
+++ b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/attendance/vo/HrmAttendanceRecordPageReqVO.java
@@ -17,6 +17,9 @@
@Schema(description = "鍛樺伐ID", example = "1")
private Long userId;
+ @Schema(description = "鍛樺伐濮撳悕锛堟ā绯婂尮閰嶏級", example = "浠讳紵")
+ private String userName;
+
@Schema(description = "閮ㄩ棬ID", example = "1")
private Long deptId;
diff --git a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmAttendanceRecordMapper.java b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmAttendanceRecordMapper.java
index 9345162..91dccb8 100644
--- a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmAttendanceRecordMapper.java
+++ b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmAttendanceRecordMapper.java
@@ -32,6 +32,21 @@
.orderByDesc(HrmAttendanceRecordDO::getDate));
}
+/**
+ * 鍒嗛〉鏌ヨ锛堟敮鎸佹寜鍛樺伐ID闆嗗悎杩囨护锛岀敤浜庛�屽憳宸ュ鍚嶃�嶆ā绯婃悳绱級
+ */
+ default PageResult<HrmAttendanceRecordDO> selectPage(HrmAttendanceRecordPageReqVO reqVO, Collection<Long> userIds) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<HrmAttendanceRecordDO>()
+ .eqIfPresent(HrmAttendanceRecordDO::getUserId, reqVO.getUserId())
+ .inIfPresent(HrmAttendanceRecordDO::getUserId, userIds)
+ .eqIfPresent(HrmAttendanceRecordDO::getDeptId, reqVO.getDeptId())
+ .geIfPresent(HrmAttendanceRecordDO::getDate, reqVO.getStartDate())
+ .leIfPresent(HrmAttendanceRecordDO::getDate, reqVO.getEndDate())
+ .eqIfPresent(HrmAttendanceRecordDO::getClockInType, reqVO.getClockInType())
+ .eqIfPresent(HrmAttendanceRecordDO::getClockOutType, reqVO.getClockOutType())
+ .orderByDesc(HrmAttendanceRecordDO::getDate));
+ }
+
default HrmAttendanceRecordDO selectByUserIdAndDate(Long userId, LocalDate date) {
return selectOne(new LambdaQueryWrapperX<HrmAttendanceRecordDO>()
.eq(HrmAttendanceRecordDO::getUserId, userId)
diff --git a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/service/attendance/HrmAttendanceRecordServiceImpl.java b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/service/attendance/HrmAttendanceRecordServiceImpl.java
index 219195d..c5bd2c8 100644
--- a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/service/attendance/HrmAttendanceRecordServiceImpl.java
+++ b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/service/attendance/HrmAttendanceRecordServiceImpl.java
@@ -34,6 +34,8 @@
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.List;
+import java.util.stream.Collectors;
+import java.util.Set;
import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
import static cn.iocoder.yudao.module.hrm.enums.ErrorCodeConstants.*;
@@ -60,7 +62,18 @@
@Override
public PageResult<HrmAttendanceRecordDO> getAttendanceRecordPage(HrmAttendanceRecordPageReqVO pageReqVO) {
- return attendanceRecordMapper.selectPage(pageReqVO);
+ // 鍛樺伐濮撳悕妯$硦鎼滅储锛氬厛鎸夊鍚嶆煡鍑哄憳宸D闆嗗悎锛屽啀鎸夐泦鍚堣繃婊�
+ // 锛坔rm_attendance_record.user_id 瀛樼殑鏄� hrm_employee.id锛�
+ Set<Long> nameMatchedIds = null;
+ if (StrUtil.isNotBlank(pageReqVO.getUserName())) {
+ List<HrmEmployeeDO> matched = employeeService.getEmployeeListByNameLike(pageReqVO.getUserName().trim());
+ nameMatchedIds = matched.stream().map(HrmEmployeeDO::getId).collect(Collectors.toSet());
+ if (nameMatchedIds.isEmpty()) {
+ // 濮撳悕鎼滀笉鍒颁汉鏃剁洿鎺ヨ繑鍥炵┖锛岄伩鍏嶉��鍖栨垚鏌ュ叏閮�
+ return PageResult.empty();
+ }
+ }
+ return attendanceRecordMapper.selectPage(pageReqVO, nameMatchedIds);
}
@Override
--
Gitblit v1.9.3