Package es.kukenan.smartfi.microservice.smartficore.repository

Interface AdvanceMovementRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<AdvanceMovement,String>, org.springframework.data.jpa.repository.JpaRepository<AdvanceMovement,String>, org.springframework.data.repository.PagingAndSortingRepository<AdvanceMovement,String>, org.springframework.data.repository.query.QueryByExampleExecutor<AdvanceMovement>, org.springframework.data.repository.Repository<AdvanceMovement,String>
@Repository public interface AdvanceMovementRepository extends org.springframework.data.jpa.repository.JpaRepository<AdvanceMovement,String>
Repository for queries for Account Product.

  • Method Summary

    Modifier and Type
    Method
    Description
    Optional<List<AdvanceMovement>>
    findAllByUserId(String userId)
    Select registers by name.
    Optional<List<AdvanceMovement>>
    findAllByUserIdAndLoanProduct(String userId, String advanceProduct)
    Select registers by user id.
    Optional<AdvanceMovement>
    findByUserId(String userId)
    Select registers by name.

    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, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

    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

    • findAllByUserId

      @Query("SELECT lm FROM AdvanceMovement lm WHERE lm.userId.id = :userId") Optional<List<AdvanceMovement>> findAllByUserId(@Param("userId") String userId)
      Select registers by name.
      Parameters:
      userId - user identifier.
      Returns:
      list of account products by user object from database

    • findByUserId

      @Query("SELECT lm FROM AdvanceMovement lm WHERE lm.userId.id = :userId") Optional<AdvanceMovement> findByUserId(@Param("userId") String userId)
      Select registers by name.
      Parameters:
      userId - user identifier.
      Returns:
      list of account products by user object from database

    • findAllByUserIdAndLoanProduct

      @Query("SELECT lm FROM AdvanceMovement lm WHERE lm.userId.id = :userId AND lm.advanceProduct.id = :advanceProduct") Optional<List<AdvanceMovement>> findAllByUserIdAndLoanProduct(@Param("userId") String userId, @Param("advanceProduct") String advanceProduct)
      Select registers by user id.
      Parameters:
      userId - name for backoffice.
      advanceProduct - associated product
      Returns:
      new list product movement object from database