package com.northglass.repository;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.constants.StateConstants.ManufactureBatchState;
|
import com.northglass.entity.ManufactureBatch;
|
|
public interface ManufactureBatchDao extends JpaRepository<ManufactureBatch, Long> {
|
|
@Query("select t from ManufactureBatch t where t.state='" + ManufactureBatchState.IN_WORK + "'")
|
public ManufactureBatch findInWorkManufactureBatch();
|
|
@Query("select t from ManufactureBatch t where t.state='" + ManufactureBatchState.WAITING + "'")
|
public ManufactureBatch findWaitingManufactureBatch();
|
|
@Query("select t from ManufactureBatch t where t.state='" + ManufactureBatchState.IN_ADD + "'")
|
public ManufactureBatch findADDManufactureBatch();
|
|
@Query("select t from ManufactureBatch t where t.state='" + ManufactureBatchState.IN_WAITING + "'")
|
public ManufactureBatch findInWaitingManufactureBatch();
|
|
@Query("select t from ManufactureBatch t where t.state='" + ManufactureBatchState.WAITING + "' or t.state='" + ManufactureBatchState.IN_WORK + "'")
|
public ManufactureBatch findWaitingOrInWorkManufactureBatch();
|
|
@Query("select t from ManufactureBatch t where t.number= ?1 ")
|
public ManufactureBatch findByBatch(String number);
|
}
|
