package com.northglass.repository;
|
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.constants.StateConstants.ShelfRankState;
|
import com.northglass.entity.RawPackage;
|
|
|
public interface RawPackageDao extends JpaRepository<RawPackage, Long> {
|
|
|
@Query("select distinct r.manufacturer from RawPackage r where r.manufacturer != ''")
|
public List<String> findManufacturers();
|
|
@Query("select distinct r.manufacturer from RawPackage r where r.manufacturer=?1")
|
public List<RawPackage> findByManufacturer(String manufacturer);
|
|
@Query("select r from RawPackage r where r.state = '" + ShelfRankState.FREE + "'")
|
public List<RawPackage> findFreeRawPackage();
|
|
@Query("select r from RawPackage r where r.state = '" + ShelfRankState.IN_WORK + "'")
|
public List<RawPackage> findInWorkRawPackage();
|
|
@Query("select r from RawPackage r where r.rawPackageTxt.id=?1")
|
public List<RawPackage> findByRawPackageTxtId(Long id);
|
}
|
