dstarcev
12/30/2016, 1:11 PMdata class InvitationListItem(
var created: Date = Date(),
var role: DealRole = DealRole.Seller,
var email: String = "",
var phone: String = "",
var inviteeId: Long? = null,
var inviteeName: String = ""
) : Serializable
interface InvitationRepository : JpaRepository<Invitation, UUID> {
@Query("""
select
invitations.created,
invitations.role,
invitations.email,
invitations.phone,
invitations.invitee_id,
users.name as inviteeName
from invitations
left join users
on users.id = invitations.invitee_id
where invitations.status != 'Declined'
and invitations.deal_id = ?1""", nativeQuery = true)
fun getDealInvitations(dealId: Long): List<InvitationListItem>
}