gaoluyang
3 天以前 d39e4f7d839167c16425086dfa2f8747bccfdff9
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/dal/mysql/approval/HrmResignationApplicationMapper.java
@@ -7,6 +7,9 @@
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
 *
@@ -40,4 +43,15 @@
                .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));
    }
}