package cn.iocoder.yudao.module.hrm.dal.mysql.approval; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.hrm.controller.admin.approval.vo.HrmLeaveApplicationPageReqVO; import cn.iocoder.yudao.module.hrm.dal.dataobject.approval.HrmLeaveApplicationDO; import cn.iocoder.yudao.module.hrm.enums.HrmAuditStatusEnum; import org.apache.ibatis.annotations.Mapper; import java.time.LocalDateTime; import java.util.List; /** * 请假申请 Mapper * * @author 超级管理员 */ @Mapper public interface HrmLeaveApplicationMapper extends BaseMapperX { default PageResult selectPage(HrmLeaveApplicationPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(HrmLeaveApplicationDO::getNo, reqVO.getNo()) .eqIfPresent(HrmLeaveApplicationDO::getUserId, reqVO.getUserId()) .eqIfPresent(HrmLeaveApplicationDO::getDeptId, reqVO.getDeptId()) .eqIfPresent(HrmLeaveApplicationDO::getLeaveType, reqVO.getLeaveType()) .eqIfPresent(HrmLeaveApplicationDO::getStatus, reqVO.getStatus()) .betweenIfPresent(HrmLeaveApplicationDO::getCreateTime, reqVO.getCreateTime()) .orderByDesc(HrmLeaveApplicationDO::getId)); } default HrmLeaveApplicationDO selectByNo(String no) { return selectOne(HrmLeaveApplicationDO::getNo, no); } default HrmLeaveApplicationDO selectByProcessInstanceId(String processInstanceId) { return selectOne(HrmLeaveApplicationDO::getProcessInstanceId, processInstanceId); } /** * 查询员工在指定时间范围内已审批通过的请假记录 * * @param userId 员工ID(系统用户ID) * @param startTime 开始时间 * @param endTime 结束时间 * @return 请假记录列表 */ default List selectApprovedListByUserIdAndTimeRange(Long userId, LocalDateTime startTime, LocalDateTime endTime) { return selectList(new LambdaQueryWrapperX() .eq(HrmLeaveApplicationDO::getUserId, userId) .eq(HrmLeaveApplicationDO::getStatus, HrmAuditStatusEnum.APPROVE.getStatus()) .ge(HrmLeaveApplicationDO::getStartTime, startTime) .le(HrmLeaveApplicationDO::getEndTime, endTime)); } /** * 查询与指定时间范围有交集的审批通过请假记录(可限定申请人) * * 请假开始早于范围起点、结束晚于范围终点也算交集,因此用 start <= 范围终点 且 end >= 范围起点。 * * @param startTime 范围开始时间 * @param endTime 范围结束时间 * @param userIds 申请人ID集合,为空表示不限 * @return 请假记录列表 */ default List selectApprovedListByTimeRange(LocalDateTime startTime, LocalDateTime endTime, java.util.Collection userIds) { LambdaQueryWrapperX query = new LambdaQueryWrapperX() .inIfPresent(HrmLeaveApplicationDO::getUserId, userIds); query.eq(HrmLeaveApplicationDO::getStatus, HrmAuditStatusEnum.APPROVE.getStatus()) .le(HrmLeaveApplicationDO::getStartTime, endTime) .ge(HrmLeaveApplicationDO::getEndTime, startTime) .orderByAsc(HrmLeaveApplicationDO::getStartTime); return selectList(query); } }