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();
}