package cn.iocoder.yudao.module.hrm.dal.mysql.employee;

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.employee.vo.HrmEmployeePageReqVO;
import cn.iocoder.yudao.module.hrm.dal.dataobject.employee.HrmEmployeeDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 员工信息 Mapper
 *
 * @author 芋道源码
 */
@Mapper
public interface HrmEmployeeMapper extends BaseMapperX<HrmEmployeeDO> {

    default HrmEmployeeDO selectByPhone(String phone) {
        return selectOne(HrmEmployeeDO::getPhone, phone);
    }

    default HrmEmployeeDO selectByEmployeeNo(String employeeNo) {
        return selectOne(HrmEmployeeDO::getEmployeeNo, employeeNo);
    }

    default HrmEmployeeDO selectByUserId(Long userId) {
        return selectOne(HrmEmployeeDO::getUserId, userId);
    }

    default List<HrmEmployeeDO> selectByDeptId(Long deptId) {
        return selectList(HrmEmployeeDO::getDeptId, deptId);
    }

    default List<HrmEmployeeDO> selectByEmployeeStatus(Integer employeeStatus) {
        return selectList(HrmEmployeeDO::getEmployeeStatus, employeeStatus);
    }

    default PageResult<HrmEmployeeDO> selectPage(HrmEmployeePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<HrmEmployeeDO>()
                .likeIfPresent(HrmEmployeeDO::getEmployeeNo, reqVO.getEmployeeNo())
                .likeIfPresent(HrmEmployeeDO::getName, reqVO.getName())
                .eqIfPresent(HrmEmployeeDO::getDeptId, reqVO.getDeptId())
                .eqIfPresent(HrmEmployeeDO::getEmployeeStatus, reqVO.getEmployeeStatus())
                .orderByDesc(HrmEmployeeDO::getId));
    }

    default List<HrmEmployeeDO> selectListByStatus(Integer employeeStatus) {
        return selectList(new LambdaQueryWrapperX<HrmEmployeeDO>()
                .eqIfPresent(HrmEmployeeDO::getEmployeeStatus, employeeStatus)
                .orderByAsc(HrmEmployeeDO::getName));
    }

}