Package com.v1rex.liftnexus.forklift.repository

Interface ForkliftRepository

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

  • Method Summary

    Modifier and Type
    Method
    Description
    boolean
    existsByFleetNumber(String fleetNumber)
     
    List<Forklift>
    findAll()
     
    org.springframework.data.domain.Page<Forklift>
    findAll(org.springframework.data.domain.Pageable pageable)
     
    List<Forklift>
    findAllForPlanning()
     
    org.springframework.data.domain.Page<Forklift>
    findByForkliftType_MaxCapacityKgGreaterThanEqual(Integer minCapacity, org.springframework.data.domain.Pageable pageable)
     
    Optional<Forklift>
    findById(Long id)
     
    org.springframework.data.domain.Page<Forklift>
    findByStatus(OperationalStatus status, org.springframework.data.domain.Pageable pageable)
     

    Methods inherited from interface org.springframework.data.repository.CrudRepository

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, 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

    findAllById, saveAll

    Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

    findAll

    Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

    count, exists, findAll, findBy, findOne

  • Method Details

    • existsByFleetNumber

      boolean existsByFleetNumber(String fleetNumber)

    • findById

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin"}) Optional<Forklift> findById(Long id)
      Specified by:
      findById in interface org.springframework.data.repository.CrudRepository<Forklift,Long>

    • findAll

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin"}) org.springframework.data.domain.Page<Forklift> findAll(org.springframework.data.domain.Pageable pageable)
      Specified by:
      findAll in interface org.springframework.data.repository.PagingAndSortingRepository<Forklift,Long>

    • findAll

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin"}) List<Forklift> findAll()
      Specified by:
      findAll in interface org.springframework.data.repository.CrudRepository<Forklift,Long>
      Specified by:
      findAll in interface org.springframework.data.repository.ListCrudRepository<Forklift,Long>

    • findByStatus

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin"}) org.springframework.data.domain.Page<Forklift> findByStatus(OperationalStatus status, org.springframework.data.domain.Pageable pageable)

    • findByForkliftType_MaxCapacityKgGreaterThanEqual

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin"}) @Query(" SELECT f FROM Forklift f\n JOIN f.forkliftType ft\n WHERE ft.maxCapacityKg >= :minCapacity\n") org.springframework.data.domain.Page<Forklift> findByForkliftType_MaxCapacityKgGreaterThanEqual(@Param("minCapacity") Integer minCapacity, org.springframework.data.domain.Pageable pageable)

    • findAllForPlanning

      @EntityGraph(attributePaths={"forkliftType","currentStorageBin","transportOrders","transportOrders.targetLoadUnit","transportOrders.sourceBin","transportOrders.targetBin"}) @Query("SELECT DISTINCT f FROM Forklift f") List<Forklift> findAllForPlanning()