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.DropFrame;
import com.northglass.entity.DropFrame2;

public interface DropFrameDao2 extends JpaRepository<DropFrame2, Long>{

	@Query("select t from DropFrame2 t where  t.groups=?1")
    public List<DropFrame2> findBystop(Long groups);
	
	@Query("select t from DropFrame2 t where  t.groups=?3 and t.stops=?1 and t.noodles<>?2")
    public DropFrame2 findnoodles(int stops,String noodles,Long groups);
	
	@Query("select t from DropFrame2 t where  t.groups=?3 and t.stops<>?1 and t.noodles<>?2")
    public DropFrame2 findnoodles2(int stops,String noodles,Long groups);
	
	@Query("select t from DropFrame2 t where  t.groups=?1")
    public List<DropFrame2> findBygroupsfalg(Long groups);
}