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


}