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

NotificationRepository

@Repository

interface NotificationRepository : JpaRepository<Notification, String> (source)

Repositório para acesso a dados de notificações do sistema. Fornece métodos para listar, marcar como lida e contar notificações.

Functions

abstract fun count(): Long

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

countUnreadByTenantAndUser

@Query(value = " SELECT COUNT(n) FROM Notification n WHERE n.tenantId = :tenantId AND (n.userId IS NULL OR n.userId = :userId) AND n.read = false ")

abstract fun countUnreadByTenantAndUser(tenantId: String, userId: String): Long

abstract fun delete(entity: Notification)

abstract fun deleteAll()

abstract fun deleteAll(entities: MutableIterable<Notification>)

abstract fun deleteAllById(ids: MutableIterable<String>)

deleteAllByIdInBatch

abstract fun deleteAllByIdInBatch(ids: MutableIterable<String>)

deleteAllInBatch

abstract fun deleteAllInBatch()

abstract fun deleteAllInBatch(entities: MutableIterable<Notification>)

abstract fun deleteById(id: String)

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

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

abstract fun existsById(id: String): Boolean

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

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

abstract override fun findAll(): MutableList<Notification>

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

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

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

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

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

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

findByIdAndTenantId

abstract fun findByIdAndTenantId(id: String, tenantId: String): Notification?

findByTenantAndUser

@Query(value = " SELECT n FROM Notification n WHERE n.tenantId = :tenantId AND (n.userId IS NULL OR n.userId = :userId) ORDER BY n.createdAt DESC ")

abstract fun findByTenantAndUser(tenantId: String, userId: String, pageable: Pageable): Page<Notification>

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

findUnreadByTenantAndUser

@Query(value = " SELECT n FROM Notification n WHERE n.tenantId = :tenantId AND (n.userId IS NULL OR n.userId = :userId) AND n.read = false ORDER BY n.createdAt DESC ")

abstract fun findUnreadByTenantAndUser(tenantId: String, userId: String): List<Notification>

abstract fun flush()

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

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

getReferenceById

abstract fun getReferenceById(id: String): Notification

markAllAsReadByTenantAndUser

@Modifying

@Query(value = " UPDATE Notification n SET n.read = true WHERE n.tenantId = :tenantId AND (n.userId IS NULL OR n.userId = :userId) AND n.read = false ")

abstract fun markAllAsReadByTenantAndUser(tenantId: String, userId: String): Int

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

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

saveAllAndFlush

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

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