Package com.bytedesk.voc.feedback

Interface FeedbackRepository

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

  • Method Summary

    Modifier and Type
    Method
    Description
    org.springframework.data.domain.Page<FeedbackEntity>
    findByAssignedTo(Long assignedTo, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<FeedbackEntity>
    findByStatus(String status, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<FeedbackEntity>
    findByType(String type, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<FeedbackEntity>
    findByUserId(Long userId, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<FeedbackEntity>
    search(String keyword, String type, String status, org.springframework.data.domain.Pageable pageable)
     

    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

    • findByUserId

      org.springframework.data.domain.Page<FeedbackEntity> findByUserId(Long userId, org.springframework.data.domain.Pageable pageable)

    • findByType

      org.springframework.data.domain.Page<FeedbackEntity> findByType(String type, org.springframework.data.domain.Pageable pageable)

    • findByStatus

      org.springframework.data.domain.Page<FeedbackEntity> findByStatus(String status, org.springframework.data.domain.Pageable pageable)

    • findByAssignedTo

      org.springframework.data.domain.Page<FeedbackEntity> findByAssignedTo(Long assignedTo, org.springframework.data.domain.Pageable pageable)

    • search

      @Query("SELECT f FROM FeedbackEntity f WHERE (LOWER(f.content) LIKE LOWER(CONCAT(\'%\', :keyword, \'%\'))) AND (:type IS NULL OR f.type = :type) AND (:status IS NULL OR f.status = :status)") org.springframework.data.domain.Page<FeedbackEntity> search(@Param("keyword") String keyword, @Param("type") String type, @Param("status") String status, org.springframework.data.domain.Pageable pageable)