QuettaCode API/com.quettacode.flow.crm.repository/GroupRepository

GroupRepository

@Repository

interface GroupRepository : JpaRepository<ContactGroup, String> (source)

Repositório para operações de Grupos de Contatos. Grupos são usados para agrupar contatos para envio de campanhas em massa.

Functions

abstract fun count(): Long

abstract fun <S : ContactGroup> count(example: Example<S>): Long

countContactsByGroupId

@Query(value = "SELECT COUNT(c) FROM ContactGroup g JOIN g.contacts c WHERE g.id = :groupId")

abstract fun countContactsByGroupId(groupId: String): Long

abstract fun delete(entity: ContactGroup)

abstract fun deleteAll()

abstract fun deleteAll(entities: MutableIterable<ContactGroup>)

abstract fun deleteAllById(ids: MutableIterable<String>)

deleteAllByIdInBatch

abstract fun deleteAllByIdInBatch(ids: MutableIterable<String>)

deleteAllInBatch

abstract fun deleteAllInBatch()

abstract fun deleteAllInBatch(entities: MutableIterable<ContactGroup>)

abstract fun deleteById(id: String)

open fun ~~deleteInBatch~~(entities: MutableIterable<ContactGroup>)

abstract fun <S : ContactGroup> exists(example: Example<S>): Boolean

abstract fun existsById(id: String): Boolean

existsByTenantIdAndNameAndDeletedAtIsNull

abstract fun existsByTenantIdAndNameAndDeletedAtIsNull(tenantId: String, name: String): Boolean

abstract override fun <S : ContactGroup> findAll(example: Example<S>): MutableList<S>

abstract override fun <S : ContactGroup> findAll(example: Example<S>, sort: Sort): MutableList<S>

abstract override fun findAll(): MutableList<ContactGroup>

abstract override fun findAll(sort: Sort): MutableList<ContactGroup>

abstract fun findAll(pageable: Pageable): Page<ContactGroup>

abstract fun <S : ContactGroup> findAll(example: Example<S>, pageable: Pageable): Page<S>

abstract override fun findAllById(ids: MutableIterable<String>): MutableList<ContactGroup>

abstract fun <S : ContactGroup, R : Any> findBy(example: Example<S>, queryFunction: Function<FluentQuery.FetchableFluentQuery<S>, R>): R

abstract fun findById(id: String): Optional<ContactGroup>

findByIdAndTenantIdAndDeletedAtIsNull

abstract fun findByIdAndTenantIdAndDeletedAtIsNull(id: String, tenantId: String): ContactGroup?

findByIdWithContacts

@Query(value = "SELECT DISTINCT g FROM ContactGroup g LEFT JOIN FETCH g.contacts WHERE g.id = :id AND g.tenantId = :tenantId AND g.deletedAt IS NULL")

abstract fun findByIdWithContacts(id: String, tenantId: String): ContactGroup?

findByTenantIdAndDeletedAtIsNullOrderByCreatedAtDesc

abstract fun findByTenantIdAndDeletedAtIsNullOrderByCreatedAtDesc(tenantId: String): List<ContactGroup>

findByTenantIdAndTagIdAndDeletedAtIsNull

abstract fun findByTenantIdAndTagIdAndDeletedAtIsNull(tenantId: String, tagId: String): List<ContactGroup>

findGroupsByContactId

@Query(value = "SELECT g FROM ContactGroup g JOIN g.contacts c WHERE c.id = :contactId AND g.deletedAt IS NULL")

abstract fun findGroupsByContactId(contactId: String): List<ContactGroup>

abstract fun <S : ContactGroup> findOne(example: Example<S>): Optional<S>

abstract fun flush()

abstract fun ~~getById~~(id: String): ContactGroup

abstract fun ~~getOne~~(id: String): ContactGroup

getReferenceById

abstract fun getReferenceById(id: String): ContactGroup

abstract fun <S : ContactGroup> save(entity: S): S

abstract override fun <S : ContactGroup> saveAll(entities: MutableIterable<S>): MutableList<S>

saveAllAndFlush

abstract fun <S : ContactGroup> saveAllAndFlush(entities: MutableIterable<S>): MutableList<S>

abstract fun <S : ContactGroup> saveAndFlush(entity: S): S