package cn.iocoder.yudao.module.ums.dal.mysql.member;

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.ums.controller.admin.member.vo.UmsMemberPageReqVO;
import cn.iocoder.yudao.module.ums.dal.dataobject.member.UmsMemberDO;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UmsMemberMapper extends BaseMapperX<UmsMemberDO> {

    default UmsMemberDO selectByNo(String no) {
        return selectOne(UmsMemberDO::getNo, no);
    }

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

    default PageResult<UmsMemberDO> selectPage(UmsMemberPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<UmsMemberDO>()
                .likeIfPresent(UmsMemberDO::getNo, reqVO.getNo())
                .likeIfPresent(UmsMemberDO::getName, reqVO.getName())
                .eqIfPresent(UmsMemberDO::getMemberType, reqVO.getMemberType())
                .eqIfPresent(UmsMemberDO::getMemberGrade, reqVO.getMemberGrade())
                .eqIfPresent(UmsMemberDO::getStatus, reqVO.getStatus())
                .eqIfPresent(UmsMemberDO::getRegionCode, reqVO.getRegionCode())
                .eqIfPresent(UmsMemberDO::getIndustry, reqVO.getIndustry())
                .betweenIfPresent(UmsMemberDO::getJoinDate, reqVO.getJoinDate())
                .orderByDesc(UmsMemberDO::getId));
    }

}