Package sk.iway.iwcm.components.forms

Interface FormsRepository

All Superinterfaces:

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

@Repository
public interface FormsRepository
extends FormsRepositoryInterface<FormsEntity>

Method Summary

Modifier and Type	Method	Description
Integer	countFormName(String formName, Integer domainId)
void	deleteAllUserSubmitted(String formName, Integer domainId, Long userId)
Integer	getNumberOfSubmitted(String formName, Integer domainId)
void	setUnknownFormType()

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 sk.iway.iwcm.components.forms.FormsRepositoryInterface

countAllByFormNameAndDomainId, deleteByFormNameAndDomainId, findAllByCreateDateIsNull, findAllByCreateDateIsNullAndDomainId, findAllByFormNameAndDomainIdAndCreateDateNotNull, findFirstByFormNameAndDomainIdAndCreateDateIsNullOrderByIdAsc, findTopByFormNameAndDomainIdAndCreateDateNotNullOrderByCreateDateDesc, updateLastExportDate

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

getNumberOfSubmitted

@Query("SELECT COUNT(fe.id) FROM FormsEntity fe WHERE fe.formName = :formName AND fe.domainId = :domainId AND fe.createDate IS NOT NULL")
Integer getNumberOfSubmitted(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

deleteAllUserSubmitted

@Transactional
@Modifying
@Query("DELETE FROM FormsEntity fe WHERE fe.formName = :formName AND fe.domainId = :domainId AND fe.userId = :userId AND fe.createDate IS NOT NULL")
void deleteAllUserSubmitted(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId,
 @Param("userId")
 Long userId)

countFormName

@Query("SELECT COUNT(fe.id) FROM FormsEntity fe WHERE fe.formName = :formName AND fe.domainId = :domainId")
Integer countFormName(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

setUnknownFormType

@Transactional
@Modifying
@Query("UPDATE FormsEntity fe SET fe.formType = \'unknown\' WHERE (fe.formType IS NULL OR fe.formType = \'\') AND fe.createDate IS NULL")
void setUnknownFormType()