package com.northglass.repository;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.northglass.entity.GalssTaskDetails;
import com.northglass.entity.ShelfTask;
import com.northglass.entity.Slicecage;

public interface SlicecageDao extends JpaRepository<Slicecage, Long>{

	@Query("select t from Slicecage t where t.gourp=?1 ")
    public List<Slicecage> findfall(Long groups);
	
	@Query("select count(t) from Slicecage t where t.gourp=?1 and t.state='使用中' ")
    public int findfall2(Long groups);
	
	@Query("select t from Slicecage t where t.id=?1 ")
    public Slicecage findById(long id);
	
	@Query(nativeQuery=true,value="select count(*) from gmms_slicecage s left join gmms_galss_task gt on gt.processcard_id=s.processcard_id where engineering_id=?1 and s.state='使用中';")
	public int findfall3(String engineeringid);
}