walkChina/src/main/java/com/izouma/walkchina/repo/UserFriendRepository.java

package com.izouma.walkchina.repo;

import com.izouma.walkchina.domain.UserFriend;
import com.izouma.walkchina.domain.UserFriendKey;
import com.izouma.walkchina.dto.MyFriend;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.Date;
import java.util.List;

public interface UserFriendRepository extends JpaRepository<UserFriend, UserFriendKey> {

    @Query("select new com.izouma.walkchina.dto.MyFriend(uf.friendId, u.nickname, u.avatar, u.totalSteps) from UserFriend uf " +
            "join UserInfo u on uf.friendId = u.id join WalkData w on uf.friendId = w.userId " +
            "where uf.userId = ?1 and w.date = ?2")
    List<MyFriend> findMyFriend(Long userId, Date date);
}