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.HrmResignationApplicationPageReqVO;
|
import cn.iocoder.yudao.module.hrm.dal.dataobject.approval.HrmResignationApplicationDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.time.LocalDate;
|
import java.util.List;
|
|
/**
|
* 离职申请 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface HrmResignationApplicationMapper extends BaseMapperX<HrmResignationApplicationDO> {
|
|
default PageResult<HrmResignationApplicationDO> selectPage(HrmResignationApplicationPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<HrmResignationApplicationDO>()
|
.likeIfPresent(HrmResignationApplicationDO::getNo, reqVO.getNo())
|
.eqIfPresent(HrmResignationApplicationDO::getUserId, reqVO.getUserId())
|
.eqIfPresent(HrmResignationApplicationDO::getDeptId, reqVO.getDeptId())
|
.eqIfPresent(HrmResignationApplicationDO::getResignationType, reqVO.getResignationType())
|
.eqIfPresent(HrmResignationApplicationDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(HrmResignationApplicationDO::getCreateTime, reqVO.getCreateTime())
|
.orderByDesc(HrmResignationApplicationDO::getId));
|
}
|
|
default HrmResignationApplicationDO selectByNo(String no) {
|
return selectOne(HrmResignationApplicationDO::getNo, no);
|
}
|
|
default HrmResignationApplicationDO selectByProcessInstanceId(String processInstanceId) {
|
return selectOne(HrmResignationApplicationDO::getProcessInstanceId, processInstanceId);
|
}
|
|
default HrmResignationApplicationDO selectByUserIdAndStatusNot(Long userId, Integer status) {
|
return selectOne(new LambdaQueryWrapperX<HrmResignationApplicationDO>()
|
.eq(HrmResignationApplicationDO::getUserId, userId)
|
.ne(HrmResignationApplicationDO::getStatus, status));
|
}
|
|
/**
|
* 查询指定审批状态下，预计离职日期已到且尚未记录实际离职日期的申请
|
*/
|
default List<HrmResignationApplicationDO> selectListByStatusAndExpectedDateLe(Integer status, LocalDate date) {
|
return selectList(new LambdaQueryWrapperX<HrmResignationApplicationDO>()
|
.eq(HrmResignationApplicationDO::getStatus, status)
|
.le(HrmResignationApplicationDO::getExpectedDate, date)
|
.isNull(HrmResignationApplicationDO::getActualDate)
|
.orderByAsc(HrmResignationApplicationDO::getId));
|
}
|
|
}
|
