Package com.v1rex.liftnexus.transportorder.repository

Interface TransportOrderRepository

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

  • Method Summary

    Modifier and Type
    Method
    Description
    List<TransportOrder>
    findAllForPlanning()
     
    List<TransportOrder>
    findByAssignedForkliftIsNull()
     
    org.springframework.data.domain.Page<TransportOrder>
    findByStatus(TransportOrderStatus status, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<TransportOrder>
    findByTargetLoadUnit_WeightKgGreaterThan(Integer weight, org.springframework.data.domain.Pageable pageable)
     
    org.springframework.data.domain.Page<TransportOrder>
    searchOrders(TransportOrderStatus status, Integer minWeight, 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

    • findByAssignedForkliftIsNull

      List<TransportOrder> findByAssignedForkliftIsNull()

    • findByStatus

      org.springframework.data.domain.Page<TransportOrder> findByStatus(TransportOrderStatus status, org.springframework.data.domain.Pageable pageable)

    • findByTargetLoadUnit_WeightKgGreaterThan

      org.springframework.data.domain.Page<TransportOrder> findByTargetLoadUnit_WeightKgGreaterThan(Integer weight, org.springframework.data.domain.Pageable pageable)

    • searchOrders

      @Query(" SELECT to FROM TransportOrder to\n JOIN to.targetLoadUnit lu\n WHERE (:status IS NULL OR to.status = :status)\n AND (:minWeight IS NULL OR lu.weightKg >= :minWeight)\n") org.springframework.data.domain.Page<TransportOrder> searchOrders(@Param("status") TransportOrderStatus status, @Param("minWeight") Integer minWeight, org.springframework.data.domain.Pageable pageable)

    • findAllForPlanning

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