package com.northglass.repository;

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;

public interface GalssTaskDao extends JpaRepository<GalssTask, Long>{

	/*@Query("select min(t.patternTask.rank) from GalssTask t where t.workProcedure='测量' and t.workState='待识别' and t.patternTask.groups=?1 order by t.patternTask.rank")
    public Long findBypatternTask(Long groups);
	
	@Query("select t from GalssTask t where t.patternTask.groups=?1 and t.patternTask.rank=?2 order by t.patternTask.rank")
    public List<GalssTask> findBypatternTask(Long groups,Long rank);*/
	
	@Query("select t from GalssTask t where t.workProcedure='测量' and t.patternTask.groups=?1")
    public List<GalssTask> findByprocedure(Long groups);
	
	@Query("select t from GalssTask t where t.workProcedure='理片' and (t.workState='出库中' or t.workState='进库中' or t.workState='等待中' or t.workState='已出库' or t.workState='直通') and t.patternTask.groups=?1 ")
    public List<GalssTask> findByproceduretask(Long groups);
	
	@Query("select count(t) from GalssTask t where t.workProcedure='理片'  and t.patternTask.groups=?1 ")
    public int finlipian(Long groups);
	
	@Query("select count(t) from GalssTask t where t.workProcedure='理片'  and t.engineeringId=?1 ")
    public int finlipian2(String engineeringId);
	
	@Query("select t from GalssTask t where t.workProcedure='下片' and t.workState=?1 and t.patternTask.groups=?2")
    public List<GalssTask> findByCounttask(String state,Long groups);
	
	@Query("select t from GalssTask t where t.workProcedure='测量' and t.workState='待识别' and t.patternTask.groups=?1 order by t.patternTask.id,t.engineeringId")
    public List<GalssTask> findByidentify1(Long groups);
	
	@Query("select t from GalssTask t where t.workProcedure='测量' and t.workState='待识别' and t.patternTask.groups=?1 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))) order by t.patternTask.id,t.engineeringId")
    public List<GalssTask> findByidentify2(Long groups,Double minwidth,Double maxwidth,Double minheigth,Double maxheigth);
	
	@Query("select t from GalssTask t where t.workProcedure='测量' and t.workState='待识别' ")
    public List<GalssTask> findByidentify();
	
	@Query("select t from GalssTask t where t.workProcedure='磨边' and t.workState='已完成' and  t.patternTask.groups=?1")
    public List<GalssTask> findTopTenFinshByGaoliweiMachine(Long groups);
	
	@Query("select t from GalssTask t where t.workProcedure='磨边' and (t.workState='正在工作' or t.workState='等待中') and  t.patternTask.groups=?1 order by outRank ")
    public List<GalssTask> findInWorkgaoliwei(Long groups);
	
	@Query("select t from GalssTask t where t.workProcedure='复合' and t.workState='复合失败' and t.patternTask.groups=?1")
    public List<GalssTask> findIncompound(Long groups);
	
	@Query("select t from GalssTask t where t.typeId=?1 and t.processcardId=?2 and t.patternTask.groups=?3")
    public List<GalssTask> findbyTypeId(Long id,String processcardId,Long groups);
	
	@Query("select t from GalssTask t where t.patternTask.id=?1")
    public List<GalssTask> findpattern(Long id);
	
	@Query("select t from GalssTask t where t.patternTask.id=?1 and t.workState='待识别' and t.workProcedure='测量'")
    public List<GalssTask> findpattern1(Long id);
	
	@Query("select t from GalssTask t where t.typeId=?1 ")
    public List<GalssTask> findbyTypeId1(Long id);
	
	@Query("select t.dropFrame from GalssTask t where t.patternTask.groups=?1 and t.patternTask.rawFile.state='已领取' group by dropFrame ")
    public List<GalssTask> findDroplist(Long groups);
	
	@Query("select t from GalssTask t where t.dropFrame=?1 and t.patternTask.rawFile.state='已领取' and t.patternTask.groups=?2")
    public List<GalssTask> findDropframeList(String dropframe,Long groups);
	
	@Query("select t from GalssTask t where t.slicecageRank=?1 and t.patternTask.groups=?2")
    public List<GalssTask> findslicecagerank(Long slicecagerank,Long groups);
	
	@Query("select t from GalssTask t where t.slicecageRank=?1 and t.patternTask.groups=?2")
    public List<GalssTask> findslicecagerank2(Long slicecageid,Long groups);
	
	
	@Query("select count(t) from GalssTask t where t.dropFrame=?1 and t.patternTask.rawFile.state='已领取' and t.patternTask.groups=?2")
    public int finddropframecount(String dropframe,Long groups);
	
	
	@Query("select t from GalssTask t where t.patternTask.groups=?1 order by dropFrame")
    public List<GalssTask> findbygroups(Long line);
	
	@Query("select t from GalssTask t where t.patternTask.groups=?1 and t.workProcedure<>'测量' and t.workState<>'已进库' and t.workState<>'进库中' and t.workState<>'出库中' and t.workState<>'破损' and t.workState<>'已完成'  and t.outRank<>0 order by outRank desc")
    public List<GalssTask> findbygalsssum(Long line);
	
	@Query("select t from GalssTask t where t.patternTask.groups=?1 and t.workState='破损' order by dropFrame")
    public List<GalssTask> findbydamagedgroups(Long line);
	
	@Query("select t from GalssTask t where t.engineeringId=?1 ")
    public List<GalssTask> findbyengineering(String engineering);
	
	@Modifying
    @Query("delete from GalssTask t where t.engineeringId=?1")
	public void deleteGlassTask(String engineering);
	
	@Query("select count(t) from GalssTask t where t.workProcedure='下片' and t.workState='已完成' and t.patternTask.groups=?1 ")
    public int findByfindcount(Long line);
	
	@Query("select count(t) from GalssTask t where t.patternTask.groups=?1 ")
    public int findBysum(Long line);
	
	@Query("select count(t) from GalssTask t where t.workProcedure='测量' and t.workState='待识别' and t.patternTask.groups=?1 ")
    public int findBycount(Long line);
	
	@Query("select max(t.typeId) from GalssTask t where t.patternTask.id=?1")
    public int finmaxtypeid(Long id);
	
}