Package sk.iway.iwcm.doc

Interface DocDetailsRepository

All Superinterfaces:

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

@Repository
public interface DocDetailsRepository
extends org.springframework.data.jpa.repository.JpaRepository<DocDetails,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DocDetails>

Method Summary

Modifier and Type	Method	Description
void	deleteByDocIdIn(List<Long> docIds)
org.springframework.data.domain.Page<DocDetails>	findAll(org.springframework.data.domain.Pageable pageable)
List<DocDetails>	findAllByDisableAfterEndTrue()
List<DocDetails>	findAllByGroupId(Integer groupId)
org.springframework.data.domain.Page<DocDetails>	findAllByGroupId(Integer groupId, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<DocDetails>	findAllByGroupIdIn(int[] groupIds, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<DocDetails>	findAllByGroupIdIn(Integer[] groupIds, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<DocDetails>	findAllByOrderByDateCreatedDesc(org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<DocDetails>	findAllByPasswordProtectedLike(String groupId1, String groupId2, String groupId3, String groupId4, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<DocDetails>	findAllByTempId(int tempId, org.springframework.data.domain.Pageable pageable)
List<DocDetails>	findByDataLike(String data)
List<DocDetails>	findByDataLikeAndGroupIdIn(String data, int[] subPagesids)
DocDetails	findById(int docId)
Long	findMaxIdByGroupIdAndTitle(Integer groupId, String title)
List<Integer>	getDistGroupIdsByDataLike(String path1, String path2, String file1, String file2)
Long	getGroupId(int docId)
void	moveToTrash(boolean available, Integer groupId, Integer docId)
void	replaceTemplate(Long templateIdThatWillReplace, Long templateIdToByReplaced)
void	updateAfterUrlReplace(String data, String dataAsc, int docId)
void	updateAvailableAndDisabledAfterEnd(boolean available, boolean disableAfterEnd, Integer docId)
void	updateAvailableStatus(boolean available, Integer docId)
void	updateRedirect(String newExternalLink, String oldExternalLink)
void	updateRedirect(String newExternalLink, String oldExternalLink, int[] subGroupsIds)

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

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

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.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findAll

org.springframework.data.domain.Page<DocDetails> findAll(org.springframework.data.domain.Pageable pageable)

Specified by:

findAll in interface org.springframework.data.repository.PagingAndSortingRepository<DocDetails,Long>

findAllByTempId

org.springframework.data.domain.Page<DocDetails> findAllByTempId(int tempId,
 org.springframework.data.domain.Pageable pageable)

findAllByPasswordProtectedLike

@Query("SELECT d FROM DocDetails d WHERE (d.passwordProtected LIKE :groupId1 OR d.passwordProtected LIKE :groupId2 OR d.passwordProtected LIKE :groupId3 OR d.passwordProtected LIKE :groupId4)")
org.springframework.data.domain.Page<DocDetails> findAllByPasswordProtectedLike(@Param("groupId1")
 String groupId1,
 @Param("groupId2")
 String groupId2,
 @Param("groupId3")
 String groupId3,
 @Param("groupId4")
 String groupId4,
 org.springframework.data.domain.Pageable pageable)

findAllByGroupId

org.springframework.data.domain.Page<DocDetails> findAllByGroupId(Integer groupId,
 org.springframework.data.domain.Pageable pageable)

findAllByGroupIdIn

org.springframework.data.domain.Page<DocDetails> findAllByGroupIdIn(Integer[] groupIds,
 org.springframework.data.domain.Pageable pageable)

findAllByGroupIdIn

org.springframework.data.domain.Page<DocDetails> findAllByGroupIdIn(int[] groupIds,
 org.springframework.data.domain.Pageable pageable)

findAllByGroupId

List<DocDetails> findAllByGroupId(Integer groupId)

findById

DocDetails findById(int docId)

findMaxIdByGroupIdAndTitle

@Query(value="SELECT max(doc_id) FROM documents WHERE group_id = ?1 AND title = ?2",
       nativeQuery=true)
Long findMaxIdByGroupIdAndTitle(Integer groupId,
 String title)

updateRedirect

@Transactional
@Modifying
@Query(value="UPDATE documents SET external_link = ?1 WHERE external_link = ?2",
       nativeQuery=true)
void updateRedirect(String newExternalLink,
 String oldExternalLink)

updateRedirect

@Transactional
@Modifying
@Query("UPDATE DocDetails SET externalLink = :newExternalLink WHERE externalLink = :oldExternalLink AND group_id IN :subGroupsIds")
void updateRedirect(@Param("newExternalLink")
 String newExternalLink,
 @Param("oldExternalLink")
 String oldExternalLink,
 @Param("subGroupsIds")
 int[] subGroupsIds)

findByDataLike

List<DocDetails> findByDataLike(String data)

findByDataLikeAndGroupIdIn

List<DocDetails> findByDataLikeAndGroupIdIn(String data,
 int[] subPagesids)

updateAfterUrlReplace

@Transactional
@Modifying
@Query(value="UPDATE documents SET data = ?1, data_asc = ?2, sync_status = 1 WHERE doc_id = ?3",
       nativeQuery=true)
void updateAfterUrlReplace(String data,
 String dataAsc,
 int docId)

getGroupId

@Query(value="SELECT group_id FROM documents WHERE doc_id = ?1",
       nativeQuery=true)
Long getGroupId(int docId)

replaceTemplate

@Transactional
@Modifying
@Query(value="UPDATE documents SET temp_id=?1 WHERE temp_id=?2",
       nativeQuery=true)
void replaceTemplate(Long templateIdThatWillReplace,
 Long templateIdToByReplaced)

updateAvailableStatus

@Transactional
@Modifying
@Query("UPDATE DocDetails SET available = :available, syncStatus = 1 WHERE id = :docId")
void updateAvailableStatus(@Param("available")
 boolean available,
 @Param("docId")
 Integer docId)

moveToTrash

@Transactional
@Modifying
@Query("UPDATE DocDetails SET available = :available, syncStatus = 1, groupId = :groupId WHERE id = :docId")
void moveToTrash(@Param("available")
 boolean available,
 @Param("groupId")
 Integer groupId,
 @Param("docId")
 Integer docId)

deleteByDocIdIn

@Transactional
@Modifying
@Query("DELETE FROM DocDetails dd WHERE dd.id IN :docIds")
void deleteByDocIdIn(@Param("docIds")
 List<Long> docIds)

findAllByOrderByDateCreatedDesc

org.springframework.data.domain.Page<DocDetails> findAllByOrderByDateCreatedDesc(org.springframework.data.domain.Pageable pageable)

getDistGroupIdsByDataLike

@Query("SELECT DISTINCT(dd.groupId) FROM DocDetails dd WHERE (dd.data LIKE :path1 OR dd.data LIKE :path2) AND (dd.data LIKE :file1 OR dd.data LIKE :file2)")
List<Integer> getDistGroupIdsByDataLike(@Param("path1")
 String path1,
 @Param("path2")
 String path2,
 @Param("file1")
 String file1,
 @Param("file2")
 String file2)

updateAvailableAndDisabledAfterEnd

@Transactional
@Modifying
@Query("UPDATE DocDetails dd SET dd.available = :available, dd.disableAfterEnd = :disableAfterEnd WHERE dd.id = :docId")
void updateAvailableAndDisabledAfterEnd(@Param("available")
 boolean available,
 @Param("disableAfterEnd")
 boolean disableAfterEnd,
 @Param("docId")
 Integer docId)

findAllByDisableAfterEndTrue

List<DocDetails> findAllByDisableAfterEndTrue()