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

ContactRepository

@Repository
interface ContactRepository : JpaRepository<Contact, String> (source)

Functions

Link copied to clipboard
abstract fun count(): Long
abstract fun <S : Contact> count(example: Example<S>): Long
Link copied to clipboard
@Query(value = "SELECT COUNT(c) FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL")
abstract fun countByTenantId(tenantId: String): Long
Link copied to clipboard
@Query(value = "SELECT COUNT(c) FROM Contact c JOIN c.tags t WHERE c.tenantId = :tenantId AND t.id = :tagId AND c.deletedAt IS NULL")
abstract fun countByTenantIdAndTagsId(tenantId: String, tagId: String): Long
Link copied to clipboard
abstract fun delete(entity: Contact)
Link copied to clipboard
abstract fun deleteAll()
abstract fun deleteAll(entities: MutableIterable<Contact>)
Link copied to clipboard
abstract fun deleteAllById(ids: MutableIterable<String>)
Link copied to clipboard
Link copied to clipboard
abstract fun deleteAllInBatch()
abstract fun deleteAllInBatch(entities: MutableIterable<Contact>)
Link copied to clipboard
abstract fun deleteById(id: String)
Link copied to clipboard
open fun deleteInBatch(entities: MutableIterable<Contact>)
Link copied to clipboard
abstract fun <S : Contact> exists(example: Example<S>): Boolean
Link copied to clipboard
abstract fun existsById(id: String): Boolean
Link copied to clipboard
abstract override fun <S : Contact> findAll(example: Example<S>): MutableList<S>
abstract override fun <S : Contact> findAll(example: Example<S>, sort: Sort): MutableList<S>
abstract override fun findAll(): MutableList<Contact>
abstract override fun findAll(sort: Sort): MutableList<Contact>
abstract fun findAll(pageable: Pageable): Page<Contact>
abstract fun <S : Contact> findAll(example: Example<S>, pageable: Pageable): Page<S>
Link copied to clipboard
abstract override fun findAllById(ids: MutableIterable<String>): MutableList<Contact>
Link copied to clipboard
abstract fun <S : Contact, R : Any> findBy(example: Example<S>, queryFunction: Function<FluentQuery.FetchableFluentQuery<S>, R>): R
Link copied to clipboard
abstract fun findById(id: String): Optional<Contact>
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL")
abstract fun findByTenantId(tenantId: String, pageable: Pageable): Page<Contact>
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL AND LOWER(c.name) LIKE LOWER(CONCAT('%', :name, '%'))")
abstract fun findByTenantIdAndNameContaining(tenantId: String, name: String): List<Contact>
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c JOIN c.tags t WHERE c.tenantId = :tenantId AND t.id = :tagId AND c.deletedAt IS NULL")
abstract fun findByTenantIdAndTagsId(tenantId: String, tagId: String): List<Contact>
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.waId = :waId AND c.deletedAt IS NULL")
abstract fun findByTenantIdAndWaId(tenantId: String, waId: String): Optional<Contact>
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.waId = :waId")
abstract fun findByTenantIdAndWaIdIncludingDeleted(tenantId: String, waId: String): Optional<Contact>
Link copied to clipboard
abstract fun <S : Contact> findOne(example: Example<S>): Optional<S>
Link copied to clipboard
abstract fun flush()
Link copied to clipboard
abstract fun getById(id: String): Contact
Link copied to clipboard
abstract fun getOne(id: String): Contact
Link copied to clipboard
abstract fun getReferenceById(id: String): Contact
Link copied to clipboard
abstract fun <S : Contact> save(entity: S): S
Link copied to clipboard
abstract override fun <S : Contact> saveAll(entities: MutableIterable<S>): MutableList<S>
Link copied to clipboard
abstract fun <S : Contact> saveAllAndFlush(entities: MutableIterable<S>): MutableList<S>
Link copied to clipboard
abstract fun <S : Contact> saveAndFlush(entity: S): S
Link copied to clipboard
@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL AND (LOWER(c.name) LIKE LOWER(CONCAT('%', :query, '%')) OR c.waId LIKE CONCAT('%', :query, '%'))")
abstract fun search(tenantId: String, query: String, pageable: Pageable): Page<Contact>