| .. | .. |
|---|
| 15 | 15 | @Transactional( propagation = Propagation.REQUIRED ) |
|---|
| 16 | 16 | public interface RegDocumentRepository extends JpaRepository<RegDocument, Long> { |
|---|
| 17 | 17 | |
|---|
| 18 | | - @Query("SELECT d FROM RegDocument d WHERE d.fileHash = :fileHash and d.fileName = :fileName") |
|---|
| 19 | | - RegDocument findOneByHashAndName(@Param("fileHash") String fileHash, @Param("fileName") String fileName); |
|---|
| 18 | + @Query("SELECT d FROM RegDocument d WHERE d.fileHash = :fileHash and d.fileName = :fileName and d.createdBy = :userName") |
|---|
| 19 | + RegDocument findOneByHashAndName(@Param("fileHash") String fileHash, @Param("fileName") String fileName, @Param("userName") String userName); |
|---|
| 20 | 20 | |
|---|
| 21 | 21 | @Query("SELECT d FROM RegDocument d WHERE CURRENT_DATE > d.dueDate") |
|---|
| 22 | 22 | List<RegDocument> findAllRegDocumentExpired(); |
|---|
| 23 | + |
|---|
| 24 | + @Query("SELECT d FROM RegDocument d WHERE d.customKey = :customKey") |
|---|
| 25 | + RegDocument findOneByCustomKey(@Param("customKey") String customKey); |
|---|
| 23 | 26 | } |
|---|