From ce5f8a87bb5d411bae67c39b269d879677bb98da Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期日, 08 十一月 2026 19:29:25 +0800
Subject: [PATCH] feat(hrm): 请假导入、加班代申请、批量排班与考勤应出勤重算
---
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmEmployeeScheduleMapper.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmEmployeeScheduleMapper.java b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmEmployeeScheduleMapper.java
index 53b9b00..2c81eb6 100644
--- a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmEmployeeScheduleMapper.java
+++ b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/attendance/HrmEmployeeScheduleMapper.java
@@ -4,6 +4,9 @@
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.hrm.dal.dataobject.attendance.HrmEmployeeScheduleDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
import java.time.LocalDate;
import java.util.Collection;
@@ -23,6 +26,24 @@
.eq(HrmEmployeeScheduleDO::getDate, date));
}
+ /**
+ * 鏌ヨ鍛樺伐鏌愬ぉ鐨勬帓鐝紝鍖呭惈宸茶閫昏緫鍒犻櫎鐨勮銆�
+ *
+ * 琛ㄤ笂鍞竴閿� uk_employee_date(employee_id, date) 涓嶅惈 deleted 鍒楋紝
+ * 閫昏緫鍒犻櫎鍚庣殑鏃ц浠嶇劧鍗犵敤鍞竴閿紱閲嶆柊鎺掔彮鍓嶅繀椤诲厛鏌ュ埌瀹冨苟鈥滃娲烩�濓紝鍚﹀垯鎻掑叆浼氭挒閿鑷存暣鎵瑰洖婊氥��
+ */
+ @Select("SELECT * FROM hrm_employee_schedule WHERE employee_id = #{employeeId} AND date = #{date} LIMIT 1")
+ HrmEmployeeScheduleDO selectByEmployeeIdAndDateIncludeDeleted(@Param("employeeId") Long employeeId,
+ @Param("date") LocalDate date);
+
+ /**
+ * 澶嶆椿宸查�昏緫鍒犻櫎鐨勬帓鐝骞惰鐩栫彮娆′俊鎭��
+ */
+ @Update("UPDATE hrm_employee_schedule SET deleted = 0, shift_id = #{shiftId}, remark = #{remark}, "
+ + "updater = #{updater}, update_time = NOW() WHERE id = #{id}")
+ int reviveById(@Param("id") Long id, @Param("shiftId") Long shiftId,
+ @Param("remark") String remark, @Param("updater") String updater);
+
default List<HrmEmployeeScheduleDO> selectListByPeriod(LocalDate startDate, LocalDate endDate) {
return selectList(new LambdaQueryWrapperX<HrmEmployeeScheduleDO>()
.between(HrmEmployeeScheduleDO::getDate, startDate, endDate)
--
Gitblit v1.9.3