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.GalssTask2;
import com.northglass.entity.GalssTaskDetails;

public interface GalssTaskDao2 extends JpaRepository<GalssTask2, Long>{

	@Query("select t from GalssTask2 t where t.workProcedure='测量' and t.groups=?1")
    public List<GalssTask2> findByprocedure(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='理片' and (t.workState='出库中' or t.workState='进库中' or t.workState='等待中' or t.workState='已出库') and t.groups=?1 ")
    public List<GalssTask2> findByproceduretask(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='下片' and t.workState=?1 and t.groups=?2")
    public List<GalssTask2> findByCounttask(String state,Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='测量' and t.workState='待识别' and t.groups=?1")
    public List<GalssTask2> findByidentify1(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='测量' and t.workState='待识别' ")
    public List<GalssTask2> findByidentify();
	
	@Query("select t from GalssTask2 t where t.workProcedure='磨边' and t.workState='已完成' and  t.groups=?1")
    public List<GalssTask2> findTopTenFinshByGaoliweiMachine(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='磨边' and (t.workState='正在工作' or t.workState='等待中') and  t.groups=?1 order by outRank ")
    public List<GalssTask2> findInWorkgaoliwei(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='钢化前复合' and t.workState='复合失败' and t.groups=?1")
    public List<GalssTask2> findIncompound(Long groups);
	
	@Query("select t from GalssTask2 t where t.workProcedure='钢化后复合' and t.workState='复合失败' and t.groups=?1")
    public List<GalssTask2> findIncompounds(Long groups);
	
	@Query("select t from GalssTask2 t where t.typeId=?1 ")
    public List<GalssTask2> findbyTypeId(Long id);
	
	@Query("select t.dropFrame from GalssTask2 t where t.groups=?1 group by dropFrame ")
    public List<GalssTask2> findDroplist(Long groups);
	
	@Query("select t from GalssTask2 t where t.dropFrame=?1 and t.groups=?2")
    public List<GalssTask2> findDropframeList(String dropframe,Long groups);
	
	@Query("select t from GalssTask2 t where t.slicecageRank=?1 and t.groups=?2")
    public List<GalssTask2> findslicecagerank(Long slicecagerank,Long groups);
	
	@Query("select t from GalssTask2 t where t.slicecageRank=?1 and t.groups=?2")
    public List<GalssTask2> findslicecagerank2(Long slicecageid,Long groups);
	
	
	@Query("select count(t) from GalssTask2 t where t.dropFrame=?1 and t.groups=?2")
    public int finddropframecount(String dropframe,Long groups);
//	钢化后下片完成
	@Query("select t from GalssTask2 t where t.groups=?1 and t.workProcedure='钢化后下片' and t.workState='已完成' and t.processcardId=?2")
    public List<GalssTask2> findbyFinshsum(Long line,String pro);
	
	@Query("select t from GalssTask2 t where t.groups=?1 order by dropFrame")
    public List<GalssTask2> findbygroups(Long line);
	
	@Query("select t from GalssTask2 t where t.groups=?1   and t.orders is not null and (t.workProcedure='钢化上片' or t.workProcedure='钢化前复合' or t.workProcedure='钢化前摆片' or t.workProcedure='钢化') and t.workState<>'破损' order by t.furnace,t.orders")
    public List<GalssTask2> findbygalsssum(Long line);
	
	@Query("select t from GalssTask2 t "
			+ "where t.groups=?1   and t.orders is not null "
			+ "and ((t.workProcedure='钢化' and t.workState<>'等待中' ) "
			+ "or (t.workProcedure='钢化后摆片' ) or (t.workProcedure='钢化后复合') "
			+ "or (t.workProcedure='钢化后下片' and t.workState<>'已完成')) and t.workState<>'破损' "
			+ "order by t.furnace,t.grouporder,t.fineThrowing")
    public List<GalssTask2> findbygalsssums(Long line);
	
	@Query("select t from GalssTask2 t where t.groups=?1 and t.workState='破损' order by dropFrame")
    public List<GalssTask2> findbydamagedgroups(Long line);
	
	@Query("select t from GalssTask2 t where t.engineeringId=?1 ")
    public List<GalssTask2> findbyengineering(String engineering);
	
	@Modifying
    @Query("delete from GalssTask2 t where t.engineeringId=?1")
	public void deleteGlassTask(String engineering);
	
	@Query("select count(t) from GalssTask2 t where t.workProcedure='下片' and t.workState='已完成' and t.groups=?1 ")
    public int findByfindcount(Long line);
	
	@Query("select count(t) from GalssTask2 t where t.groups=?1 ")
    public int findBysum(Long line);
	
	@Query("select count(t) from GalssTask2 t where t.workProcedure='测量' and t.workState='待识别' and t.groups=?1 ")
    public int findBycount(Long line);
	
	@Modifying
	@Query("update GalssTask2 t set t.workState='未优化' where t.workProcedure='钢化上片' and t.workState='等待中' and t.processcardId=?1 ")
	public void findupdatestate(String porid);
	
	@Modifying
    @Query("delete from GalssTask2 t where  t.processcardId =?1 and t.groups=?2")
	public void deleteprocesscardid(String processcardid,long groups);
	
	@Query("select count(t) from GalssTask2 t where t.processcardId=?1 and t.groups=?2")
	public int findGalssWorking(String porid,long groups);
	
	@Query("select count(t) from GalssTask2 t where t.workProcedure='钢化上片' and t.processcardId=?1 and t.groups=?2")
	public int findGalssTask2Working(String porid,long groups);
	
	@Query("select count(t) from GalssTask2 t where ((t.workProcedure='钢化后下片' and t.workState='已完成') or t.workState='破损') and t.processcardId=?1 and t.groups=?2")
	public int findGalssTask2NotFinsh(String porid,long groups);
	
}