2020-11-23

java jpa 表联合查询 分页

@Query(value = "select new com.squid.service.dto.MyFriendDTO(uil.createdTime as inviteTime,ui.nickname as name,ui.grade as grade) from UserInviteLog as uil left join UserInfo as ui on uil.userId = ui.id where uil.inviteUserId = :userId and ui.grade > :grade",
            countQuery = "select count(uil.id) from UserInviteLog as uil left join UserInfo as ui on uil.userId = ui.id where uil.inviteUserId = :userId and ui.grade > :grade")
    Page<MyFriendDTO> findElitedByInviteUserId(@Param("userId")Long userId, @Param("grade")Integer grade, Pageable pageable);