package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.User;
import com.bofeng.entity.UserOpen;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;


@Mapper
@Repository
public interface UserOpenMapper extends BaseMapper<UserOpen> {

    int deleteByUserId(@Param("userId") Long userId);

    User getUserByHigherId(Long higherId);

    UserOpen selectByUserId(@Param("userId") Long userId);

    UserOpen selectByOpenId(@Param("openId") String openId);

    List<UserOpen> getAllUser();

    @Select(
            "select user_id as userId, open_id as openId, nick_name as nickName from sys_user_open limit #{start}, #{count}"
    )
    List<UserOpen> getOpenUser(@Param("start") Long start, @Param("count") Long count);

    List<UserOpen> getUsersByUptownId(@Param("uptownId") Long uptownId);
}