Package sk.iway.iwcm.components.multistep_form.jpa

Interface FormItemsRepository

All Superinterfaces:

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

@Repository
public interface FormItemsRepository
extends DomainIdRepository<FormItemEntity,Long>

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object>

Method Summary

Modifier and Type	Method	Description
Integer	countByFormNameAndStepIdAndSortPriorityAndIdNot(String formName, Long stepId, Integer sortPriority, Integer id)
Optional<Integer>	countItemsByIdAndItemFormId(String formName, Long id, String itemFormId, Integer domainId)
int	countItemsThatHasType(String formName, Integer domainId, List<String> fieldTypes)
void	deleteAllByFormNameAndDomainId(String formName, Integer domainId)
void	deleteAllByFormNameAndStepIdAndDomainId(String formName, Long stepId, Integer domainId)
void	deleteAllByStepIdAndDomainId(Long stepId, Integer domainId)
List<FormItemEntity>	findAllByFormNameAndDomainId(String formName, Integer domainId)
List<FormItemEntity>	findAllByFormNameAndIdInAndDomainId(String formName, List<Long> ids, Integer domainId)
List<FormItemEntity>	findAllByFormNameAndStepIdInAndDomainId(String formName, List<Integer> stepIds, Integer domainId)
FormItemEntity	findFirstByFormNameAndItemFormIdAndDomainIdOrderBySortPriorityAsc(String formName, String itemFormId, Integer domainId)
List<FormItemEntity>	findItemsToDuplicate(String formName, Long stepId, Integer domainId)
List<FormItemEntity>	getAllStepItems(Long stepId, Integer domainId)
List<String>	getItemFormIds(String formName, String fieldType, Integer domainId)
int	incrementErrorCountByItemFormIds(String formName, Integer domainId, List<String> itemFormIds)

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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

count, count, delete, delete, exists, exists, findAll, findAll, findAll, findAll, findAll, findBy, findBy, findOne, findOne, update

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

findAll, findAllById, saveAll

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

findAll

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

deleteAllByStepIdAndDomainId

@Transactional
@Modifying
void deleteAllByStepIdAndDomainId(Long stepId,
 Integer domainId)

getAllStepItems

@Query("SELECT fie FROM FormItemEntity fie WHERE fie.stepId = :stepId AND fie.domainId = :domainId ORDER BY fie.sortPriority ASC")
List<FormItemEntity> getAllStepItems(@Param("stepId")
 Long stepId,
 @Param("domainId")
 Integer domainId)

getItemFormIds

@Query("SELECT fie.itemFormId FROM FormItemEntity fie WHERE fie.formName = :formName AND fie.fieldType = :fieldType AND fie.domainId = :domainId")
List<String> getItemFormIds(@Param("formName")
 String formName,
 @Param("fieldType")
 String fieldType,
 @Param("domainId")
 Integer domainId)

countItemsThatHasType

@Query("SELECT count(fie.id) FROM FormItemEntity fie WHERE fie.formName = :formName AND fie.domainId = :domainId AND fie.fieldType IN :fieldTypes")
int countItemsThatHasType(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId,
 @Param("fieldTypes")
 List<String> fieldTypes)

deleteAllByFormNameAndStepIdAndDomainId

@Transactional
@Modifying
void deleteAllByFormNameAndStepIdAndDomainId(String formName,
 Long stepId,
 Integer domainId)

deleteAllByFormNameAndDomainId

@Transactional
@Modifying
void deleteAllByFormNameAndDomainId(String formName,
 Integer domainId)

findItemsToDuplicate

@Query("SELECT fie FROM FormItemEntity fie WHERE fie.formName = :formName AND fie.stepId = :stepId AND fie.domainId = :domainId")
List<FormItemEntity> findItemsToDuplicate(@Param("formName")
 String formName,
 @Param("stepId")
 Long stepId,
 @Param("domainId")
 Integer domainId)

findAllByFormNameAndDomainId

List<FormItemEntity> findAllByFormNameAndDomainId(String formName,
 Integer domainId)

findFirstByFormNameAndItemFormIdAndDomainIdOrderBySortPriorityAsc

FormItemEntity findFirstByFormNameAndItemFormIdAndDomainIdOrderBySortPriorityAsc(String formName,
 String itemFormId,
 Integer domainId)

incrementErrorCountByItemFormIds

@Transactional
@Modifying
@Query("UPDATE FormItemEntity fie SET fie.errorCount = COALESCE(fie.errorCount, 0) + 1 WHERE fie.formName = :formName AND fie.domainId = :domainId AND fie.itemFormId IN :itemFormIds")
int incrementErrorCountByItemFormIds(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId,
 @Param("itemFormIds")
 List<String> itemFormIds)

countByFormNameAndStepIdAndSortPriorityAndIdNot

Integer countByFormNameAndStepIdAndSortPriorityAndIdNot(String formName,
 Long stepId,
 Integer sortPriority,
 Integer id)

findAllByFormNameAndStepIdInAndDomainId

List<FormItemEntity> findAllByFormNameAndStepIdInAndDomainId(String formName,
 List<Integer> stepIds,
 Integer domainId)

countItemsByIdAndItemFormId

@Query("SELECT COUNT(fie.id) FROM FormItemEntity fie WHERE fie.formName = :formName AND fie.id = :id AND fie.itemFormId = :itemFormId AND fie.domainId = :domainId")
Optional<Integer> countItemsByIdAndItemFormId(@Param("formName")
 String formName,
 @Param("id")
 Long id,
 @Param("itemFormId")
 String itemFormId,
 @Param("domainId")
 Integer domainId)

findAllByFormNameAndIdInAndDomainId

List<FormItemEntity> findAllByFormNameAndIdInAndDomainId(String formName,
 List<Long> ids,
 Integer domainId)