Package org.openwms.common.location.impl

Interface LocationRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Location,Long>, org.springframework.data.jpa.repository.JpaRepository<Location,Long>, org.springframework.data.repository.ListCrudRepository<Location,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<Location,Long>, org.springframework.data.repository.PagingAndSortingRepository<Location,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Location>, org.springframework.data.repository.Repository<Location,Long>

public interface LocationRepository
extends org.springframework.data.jpa.repository.JpaRepository<Location,Long>

A LocationRepository adds particular functionality regarding Location entity classes.

Author:

Heiko Scherrer

Method Summary

Modifier and Type	Method	Description
boolean	doesTUonLocationExists(Long pk)
boolean	doesTUonLocationExists(Collection<String> pKeys)
Optional<Location>	findByErpCode(String erpCode)
List<Location>	findByLocationGroup_Name(String locationGroupName)
List<Location>	findByLocationGroup_Name(List<String> locationGroupNames)
Optional<Location>	findByLocationId(LocationPK locationId)
List<Location>	findByLocationIdContaining(LocationPK locationPK)
Optional<Location>	findBypKey(String persistentKey)
Optional<Location>	findByPlcCode(String plcCode)

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

findBypKey

Optional<Location> findBypKey(String persistentKey)

findByLocationId

Optional<Location> findByLocationId(LocationPK locationId)

findByLocationGroup_Name

@Query("select l from Location l where l.locationGroup.name in :locationGroupNames")
List<Location> findByLocationGroup_Name(@Param("locationGroupNames")
 List<String> locationGroupNames)

findByLocationGroup_Name

@Query("select l from Location l where l.locationGroup.name like :locationGroupName")
List<Location> findByLocationGroup_Name(@Param("locationGroupName")
 String locationGroupName)

findByPlcCode

Optional<Location> findByPlcCode(String plcCode)

findByErpCode

Optional<Location> findByErpCode(String erpCode)

doesTUonLocationExists

@Query("    select count(tu)>0\n      from TransportUnit tu\n     where tu.actualLocation.pk = :pk\n")
boolean doesTUonLocationExists(Long pk)

doesTUonLocationExists

@Query("    select count(tu)>0\n      from TransportUnit tu\n     where tu.actualLocation.pKey in (:pKeys)\n")
boolean doesTUonLocationExists(@Param("pKeys")
 Collection<String> pKeys)

findByLocationIdContaining

@Query("select l from Location l where l.locationId.area like :#{#locationPK.area} and l.locationId.aisle like :#{#locationPK.aisle} and l.locationId.x like :#{#locationPK.x} and l.locationId.y like :#{#locationPK.y} and l.locationId.z like :#{#locationPK.z} ")
List<Location> findByLocationIdContaining(@Param("locationPK")
 LocationPK locationPK)