Package org.openwms.wms.inventory

Interface ProductRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<Product,Long>, org.springframework.data.jpa.repository.JpaRepository<Product,Long>, org.springframework.data.repository.ListCrudRepository<Product,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<Product,Long>, org.springframework.data.repository.PagingAndSortingRepository<Product,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Product>, org.springframework.data.repository.Repository<Product,Long>
public interface ProductRepository extends org.springframework.data.jpa.repository.JpaRepository<Product,Long>
A ProductRepository.
Author:
Heiko Scherrer

  • Method Summary Link icon

    Modifier and Type
    Method
    Description
    List<Product>
    findByLabel(String label)
     
    Optional<Product>
    findBypKey(String pKey)
     
    Optional<Product>
    findBySku(String sku)
     
    int
    productInUseByLU(Product product)
     
    int
    productInUseByPU(Product product)
     
    int
    productInUseByUomRelation(Product product)
     

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

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

    Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository Link icon

    deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

    Methods inherited from interface org.springframework.data.repository.ListCrudRepository Link icon

    findAll, findAllById, saveAll

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

    findAll

    Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository Link icon

    findAll

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

    count, exists, findAll, findBy, findOne

  • Method Details Link icon

    • findBypKey Link icon

      Optional<Product> findBypKey(String pKey)

    • findBySku Link icon

      Optional<Product> findBySku(String sku)

    • findByLabel Link icon

      List<Product> findByLabel(String label)

    • productInUseByPU Link icon

      @Query(" select count(pu)\n from PackagingUnit pu\n where pu.product = :product\n") int productInUseByPU(@Param("product") Product product)

    • productInUseByLU Link icon

      @Query(" select count(lu)\n from LoadUnit lu\n where lu.product = :product\n") int productInUseByLU(@Param("product") Product product)

    • productInUseByUomRelation Link icon

      @Query(" select count(ur)\n from UomRelation ur\n where ur.product = :product\n") int productInUseByUomRelation(@Param("product") Product product)