package cn.iocoder.yudao.module.hrm.dal.mysql.attendance;
|
|
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.attendance.vo.HrmAttendanceRulePageReqVO;
|
import cn.iocoder.yudao.module.hrm.dal.dataobject.attendance.HrmAttendanceRuleDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* 考勤规则配置 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface HrmAttendanceRuleMapper extends BaseMapperX<HrmAttendanceRuleDO> {
|
|
default PageResult<HrmAttendanceRuleDO> selectPage(HrmAttendanceRulePageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<HrmAttendanceRuleDO>()
|
.likeIfPresent(HrmAttendanceRuleDO::getName, reqVO.getName())
|
.eqIfPresent(HrmAttendanceRuleDO::getDeptId, reqVO.getDeptId())
|
.eqIfPresent(HrmAttendanceRuleDO::getStatus, reqVO.getStatus())
|
.orderByDesc(HrmAttendanceRuleDO::getId));
|
}
|
|
default List<HrmAttendanceRuleDO> selectListByStatus(Integer status) {
|
return selectList(new LambdaQueryWrapperX<HrmAttendanceRuleDO>()
|
.eqIfPresent(HrmAttendanceRuleDO::getStatus, status)
|
.orderByAsc(HrmAttendanceRuleDO::getName));
|
}
|
|
default List<HrmAttendanceRuleDO> selectListByDeptId(Long deptId) {
|
return selectList(new LambdaQueryWrapperX<HrmAttendanceRuleDO>()
|
.eq(HrmAttendanceRuleDO::getDeptId, deptId)
|
.orderByAsc(HrmAttendanceRuleDO::getName));
|
}
|
|
/**
|
* 查询部门下已启用的规则，最新创建的排在前面
|
*
|
* 同一部门存在多条启用规则时，以最新创建的一条为当前生效规则
|
*/
|
default List<HrmAttendanceRuleDO> selectEnabledListByDeptId(Long deptId) {
|
return selectList(new LambdaQueryWrapperX<HrmAttendanceRuleDO>()
|
.eq(HrmAttendanceRuleDO::getDeptId, deptId)
|
.eq(HrmAttendanceRuleDO::getStatus, 0)
|
.orderByDesc(HrmAttendanceRuleDO::getId));
|
}
|
|
}
|
