package com.doumee.dao.business;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.doumee.dao.business.model.ShopFollow;
import com.doumee.dao.web.dto.MemberDTO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author 江蹄蹄
 * @date 2023/03/21 15:48
 */
public interface ShopFollowMapper extends BaseMapper<ShopFollow> {


        @Select("(SELECT sf.OBJ_ID AS id,m.NICKNAME,m.IMGURL,m.INFO,sf.OBJ_TYPE AS TYPE FROM shop_follow sf LEFT JOIN member m ON sf.OBJ_ID = m.ID AND sf.OBJ_TYPE = 1\n" +
                "WHERE sf.MEMBER_ID = 1  AND m.NICKNAME LIKE '%#{nikeName}%'\n" +
                ") UNION (SELECT sf.OBJ_ID AS id,s.name AS NICKNAME,s.IMGURL,s.INFO,sf.OBJ_TYPE AS TYPE FROM shop_follow sf LEFT JOIN shop s ON sf.OBJ_ID = s.ID AND sf.OBJ_TYPE = 0\n" +
                "WHERE sf.MEMBER_ID = 1  AND s.name LIKE '%#{nikeName}%'" +
                ")")
        IPage<MemberDTO> getFollowMemberAndShop(IPage page,@Param("nikeName") String nikeName);

}