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));
|
}
|
|
}
|
