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.Modifying;
import org.springframework.data.jpa.repository.Query;

import com.northglass.entity.GalssTask;
import com.northglass.entity.GalssTaskDetails;
import com.northglass.entity.GalssTaskHollow;
import com.northglass.entity.GalssTaskShelf;
import com.northglass.entity.GalssTaskSlicecage;
import com.northglass.entity.GalssTaskShelf;

public interface GalssTaskSlicecageDao extends JpaRepository<GalssTaskSlicecage, Long>{

	
	
	@Query("select t.processcardId from GalssTaskSlicecage t group by t.processcardId ")
    public List<GalssTaskSlicecage> findDroplist();
	

	@Query(nativeQuery=true,value="select * from gmms_galss_task_slicecage where processcard_id like CONCAT('%',?1,'%');")
	 public List<GalssTaskSlicecage> findbyprocesscardid(String processcardid);
	
	@Modifying
    @Query("delete from GalssTaskSlicecage t where  t.processcardId like CONCAT('%',?1,'%')")
	public void deleteprocesscardid(String processcardid);
	
	@Query("select t from GalssTaskSlicecage t where t.typeId=?1 ")
    public List<GalssTaskSlicecage> findbyTypeId(Long id);
	
	@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片' and (t.workState='出库中' or t.workState='进库中' or t.workState='等待中' or t.workState='已出库' )  ")
    public List<GalssTaskSlicecage> findByproceduretask();
	
	@Query("select t from GalssTaskSlicecage t where t.slicecageRank=?1 ")
    public List<GalssTaskSlicecage> findslicecagerank(Long slicecagerank);
	
	@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片笼上片' and t.workState='已完成'  and (((t.width<=?3 and t.width>=?2) and (t.height<=?5 and t.height>=?4)) or ((t.width<=?5 and t.width>=?4) and (t.height<=?3 and t.height>=?2)))")
    public List<GalssTaskSlicecage> findByidentify2(Long groups,Double minwidth,Double maxwidth,Double minheigth,Double maxheigth);
	
	@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片笼上片' and t.workState='已完成'")
    public List<GalssTaskSlicecage> findByidentify1();
	
}