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 cn.hutool.core.collection.CollUtil;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.time.LocalDateTime;
|
import java.util.ArrayList;
|
import java.util.Collection;
|
import java.util.List;
|
|
/**
|
* 请假申请 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface HrmLeaveApplicationMapper extends BaseMapperX<HrmLeaveApplicationDO> {
|
|
default PageResult<HrmLeaveApplicationDO> selectPage(HrmLeaveApplicationPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<HrmLeaveApplicationDO>()
|
.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<HrmLeaveApplicationDO> selectApprovedListByUserIdAndTimeRange(Long userId, LocalDateTime startTime, LocalDateTime endTime) {
|
return selectList(new LambdaQueryWrapperX<HrmLeaveApplicationDO>()
|
.eq(HrmLeaveApplicationDO::getUserId, userId)
|
.eq(HrmLeaveApplicationDO::getStatus, HrmAuditStatusEnum.APPROVE.getStatus())
|
.ge(HrmLeaveApplicationDO::getStartTime, startTime)
|
.le(HrmLeaveApplicationDO::getEndTime, endTime));
|
}
|
|
/**
|
* 批量查询多个员工在指定时间范围内已审批通过的请假记录（用于按日区间的考勤统计）
|
*
|
* @param userIds 员工ID集合（系统用户ID）
|
* @param startTime 开始时间
|
* @param endTime 结束时间
|
* @return 请假记录列表
|
*/
|
default List<HrmLeaveApplicationDO> selectApprovedListByUserIdsAndTimeRange(Collection<Long> userIds,
|
LocalDateTime startTime, LocalDateTime endTime) {
|
if (CollUtil.isEmpty(userIds)) {
|
return new ArrayList<>();
|
}
|
return selectList(new LambdaQueryWrapperX<HrmLeaveApplicationDO>()
|
.in(HrmLeaveApplicationDO::getUserId, userIds)
|
.eq(HrmLeaveApplicationDO::getStatus, HrmAuditStatusEnum.APPROVE.getStatus())
|
.le(HrmLeaveApplicationDO::getStartTime, endTime)
|
.ge(HrmLeaveApplicationDO::getEndTime, startTime));
|
}
|
|
}
|
