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