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.entity.LoadRack;
|
import com.northglass.entity.Machines;
|
|
public interface LoadRackDao extends JpaRepository<LoadRack, Long>{
|
|
@Query("select r from LoadRack r where r.machines.id=?1 and r.typeFalg=0")
|
public List<LoadRack> findRack(Long id);
|
|
@Query("select r from LoadRack r where r.shelfTask.id =?1")
|
public LoadRack findBytaskId(Long id);
|
|
@Query("select r from LoadRack r where r.number =?1")
|
public LoadRack findBynuber(String number);
|
|
@Query("select t from LoadRack t where t.groups = ?1")
|
public List<LoadRack> findLoadMachineRacksByLoadMachineId(Long groups);
|
|
@Query("select t from LoadRack t where t.typeFalg = 1")
|
public List<LoadRack> findBytypefalg();
|
}
|
