Interface DocumentApprovalRepository

All Superinterfaces:

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

public interface DocumentApprovalRepository
extends org.springframework.data.jpa.repository.JpaRepository<DocumentApproval,Long>

Method Summary

Modifier and Type	Method	Description
void	deleteAllByDocument(Document document)
List<DocumentApproval>	findAllSignedByUserSigning(User user)
DocumentApproval	findByDocumentIdAndUserId(Long documentId, Long userId)
DocumentApproval	findByFilename(String filename)
List<DocumentApproval>	findBySerialNumber(String serial)

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

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

findByDocumentIdAndUserId

DocumentApproval findByDocumentIdAndUserId(Long documentId,
 Long userId)

findAllSignedByUserSigning

@Query("SELECT da FROM DocumentApproval da WHERE da.user = :user AND da.document.signedCount = da.document.requestCount")
List<DocumentApproval> findAllSignedByUserSigning(User user)

deleteAllByDocument

void deleteAllByDocument(Document document)

findBySerialNumber

@Query("SELECT da FROM DocumentApproval da WHERE da.serialNumber = :serial")
List<DocumentApproval> findBySerialNumber(String serial)

findByFilename

@Query("SELECT da FROM DocumentApproval da WHERE da.signedDocument LIKE CONCAT('%', :filename)")
DocumentApproval findByFilename(String filename)