package com.doumee.dao.business;
|
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import com.doumee.dao.admin.response.MemberInfoDTO;
|
import com.doumee.dao.business.model.Member;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @author 江蹄蹄
|
* @date 2023/11/30 15:33
|
*/
|
public interface MemberMapper extends BaseMapper<Member> {
|
|
|
@Select(" select m.* , c.name as companyName , d.name as roleName, " +
|
" (select count(0) from member_card mc where mc.MEMBER_ID=m.id and mc.ISDELETED=0) as memberCardCount " +
|
" from member m " +
|
" left join company c on m.COMPANY_ID=c.id "+
|
" left join device_role d on d.id=m.ROLE_ID "+
|
" ${ew.customSqlSegment} ")
|
IPage<MemberInfoDTO> getPage(IPage<MemberInfoDTO> page, @Param(Constants.WRAPPER) Wrapper wrapper);
|
|
|
}
|
