Interface DocumentRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<Document,Long>, org.springframework.data.jpa.repository.JpaRepository<Document,Long>, org.springframework.data.repository.ListCrudRepository<Document,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<Document,Long>, org.springframework.data.repository.PagingAndSortingRepository<Document,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Document>, org.springframework.data.repository.Repository<Document,Long>
public interface DocumentRepository extends org.springframework.data.jpa.repository.JpaRepository<Document,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    List<Document>
    findAllBySigners(User user)
     
    List<Document>
    findAllSignedByUser(User user)
     
    List<Document>
    findAllSignedByUserSigning(User user)
     
    String
    findUrlByFilename(String filename)
     

    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

    • findAllBySigners

      List<Document> findAllBySigners(User user)

    • findAllSignedByUser

      @Query("SELECT d FROM Document d WHERE d.applicant = :user AND d.signedCount = d.requestCount") List<Document> findAllSignedByUser(User user)

    • findAllSignedByUserSigning

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

    • findUrlByFilename

      @Query("SELECT d.url FROM Document d WHERE d.url LIKE CONCAT('%', :filename)") String findUrlByFilename(String filename)