Package sk.iway.iwcm.dmail.jpa

Interface EmailsRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<EmailsEntity,Long>, DomainIdRepository<EmailsEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<EmailsEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<EmailsEntity>, org.springframework.data.repository.PagingAndSortingRepository<EmailsEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<EmailsEntity>, org.springframework.data.repository.Repository<EmailsEntity,Long>

@Repository
public interface EmailsRepository
extends DomainIdRepository<EmailsEntity,Long>

Method Summary

Modifier and Type	Method	Description
void	deleteByCampainIdAndDomainId(Long campainId, Integer domainId)
void	deleteByCampainIdAndDomainIdWhereRecipientUserIsSet(Integer campainId, Integer domainId)
void	deleteCampainEmail(Long campainId, List<Integer> userIds, Integer domainId)
org.springframework.data.domain.Page<EmailsEntity>	findAllByCampainIdAndDomainId(Long campaingId, Integer domainId, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<EmailsEntity>	findAllByCampainIdAndDomainIdAndSeenDateIsNotNull(Long campaingId, Integer domainId, org.springframework.data.domain.Pageable pageable)
List<EmailsEntity>	findAllByCampainIdAndDomainIdOrderByIdDesc(Long campaingId, Integer domainId)
List<String>	getAllCampainEmails(Long campainId, Integer domainId)
Integer	getNumberOfCampaingEmails(Long campainId, Integer domainId)
Integer	getNumberOfSentEmails(Long campainId, Integer domainId)
void	updateCampaingEmails(Integer createdByUserId, String url, String subject, String senderName, String senderEmail, String replyTo, String ccEmail, String bccEmail, Date sendAt, String attachments, Long campaignId, Long oldCampaignId, Integer domainId)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface sk.iway.iwcm.system.datatable.spring.DomainIdRepository

findAllByDomainId, findAllByDomainId, findFirstByIdAndDomainId

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

deleteCampainEmail

@Transactional
@Modifying
@Query("DELETE FROM EmailsEntity WHERE campainId = :campainId AND recipientUserId IN :userIds AND domainId = :domainId")
void deleteCampainEmail(@Param("campainId")
 Long campainId,
 @Param("userIds")
 List<Integer> userIds,
 @Param("domainId")
 Integer domainId)

getAllCampainEmails

@Query("SELECT ee.recipientEmail FROM EmailsEntity ee WHERE ee.campainId = :campainId AND ee.domainId = :domainId")
List<String> getAllCampainEmails(@Param("campainId")
 Long campainId,
 @Param("domainId")
 Integer domainId)

findAllByCampainIdAndDomainId

org.springframework.data.domain.Page<EmailsEntity> findAllByCampainIdAndDomainId(Long campaingId,
 Integer domainId,
 org.springframework.data.domain.Pageable pageable)

findAllByCampainIdAndDomainIdOrderByIdDesc

List<EmailsEntity> findAllByCampainIdAndDomainIdOrderByIdDesc(Long campaingId,
 Integer domainId)

findAllByCampainIdAndDomainIdAndSeenDateIsNotNull

org.springframework.data.domain.Page<EmailsEntity> findAllByCampainIdAndDomainIdAndSeenDateIsNotNull(Long campaingId,
 Integer domainId,
 org.springframework.data.domain.Pageable pageable)

updateCampaingEmails

@Transactional
@Modifying
@Query("UPDATE EmailsEntity SET createdByUserId=:createdByUserId, url=:url, subject=:subject, senderName=:senderName, senderEmail=:senderEmail, replyTo=:replyTo, ccEmail=:ccEmail, bccEmail=:bccEmail, sendAt=:sendAt, attachments=:attachments, campainId=:campaignId WHERE campainId = :oldCampaignId AND domainId = :domainId")
void updateCampaingEmails(@Param("createdByUserId")
 Integer createdByUserId,
 @Param("url")
 String url,
 @Param("subject")
 String subject,
 @Param("senderName")
 String senderName,
 @Param("senderEmail")
 String senderEmail,
 @Param("replyTo")
 String replyTo,
 @Param("ccEmail")
 String ccEmail,
 @Param("bccEmail")
 String bccEmail,
 @Param("sendAt")
 Date sendAt,
 @Param("attachments")
 String attachments,
 @Param("campaignId")
 Long campaignId,
 @Param("oldCampaignId")
 Long oldCampaignId,
 @Param("domainId")
 Integer domainId)

getNumberOfCampaingEmails

@Query("SELECT COUNT(ee.id) FROM EmailsEntity ee WHERE ee.campainId = :campainId AND ee.domainId = :domainId")
Integer getNumberOfCampaingEmails(@Param("campainId")
 Long campainId,
 @Param("domainId")
 Integer domainId)

getNumberOfSentEmails

@Query("SELECT COUNT(ee.id) FROM EmailsEntity ee WHERE ee.sentDate IS NOT NULL AND ee.campainId = :campainId AND ee.domainId = :domainId")
Integer getNumberOfSentEmails(@Param("campainId")
 Long campainId,
 @Param("domainId")
 Integer domainId)

deleteByCampainIdAndDomainId

@Transactional
@Modifying
void deleteByCampainIdAndDomainId(Long campainId,
 Integer domainId)

deleteByCampainIdAndDomainIdWhereRecipientUserIsSet

@Transactional
@Modifying
@Query("DELETE FROM EmailsEntity ee WHERE ee.campainId = :campainId AND ee.recipientUserId != -1 AND ee.domainId = :domainId")
void deleteByCampainIdAndDomainIdWhereRecipientUserIsSet(@Param("campainId")
 Integer campainId,
 @Param("domainId")
 Integer domainId)