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.GalssTaskStock;

public interface GalssTaskStockDao extends JpaRepository<GalssTaskStock, Long>{

	
	
	@Query("select t.processcardId from GalssTaskStock t group by t.processcardId ")
    public List<GalssTaskStock> findDroplist();
	
	@Query("select t from GalssTaskStock t where t.processcardId=?1 order by t.finshTime")
    public List<GalssTaskStock> findDropframeList(String dropframe);
	
	@Query("select count(t) from GalssTaskStock t where t.processcardId=?1 order by t.finshTime")
    public int finddropframecount(String dropframe);
	
	@Query("select t from GalssTaskStock t where t.workState='已完成' and t.workProcedure='下片' order by t.finshTime")
    public List<GalssTaskStock> findallkucun4();
	
	@Query("select t from GalssTaskStock t where t.workState='已完成' and t.workProcedure='下片' and t.finshTime>=?1 and t.finshTime<=?2 order by t.finshTime")
    public List<GalssTaskStock> findallkucun(Date date1,Date date2);
	
	@Query("select t from GalssTaskStock t where t.workState='已完成' and t.workProcedure='下片' and t.finshTime>=?1 and t.finshTime<=?2 and t.processcardId=?3 and t.engineeringId=?4 order by t.finshTime")
    public List<GalssTaskStock> findallkucun1(Date date1,Date date2,String processcardid,String engineeringid);
	
	@Query("select t from GalssTaskStock t where t.workState='已完成' and t.workProcedure='下片' and t.finshTime>=?1 and t.finshTime<=?2 and t.processcardId=?3 order by t.finshTime")
    public List<GalssTaskStock> findallkucun2(Date date1,Date date2,String processcardid);
	
	@Query("select t from GalssTaskStock t where t.workState='已完成' and t.workProcedure='下片' and t.finshTime>=?1 and t.finshTime<=?2 and t.engineeringId=?3 order by t.finshTime")
    public List<GalssTaskStock> findallkucun3(Date date1,Date date2,String engineeringid);
	
	
	
}