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);
|
|
|
|
}
|
