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")
|
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")
|
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.patternTask.groups=?2")
|
public List<GalssTask> findbyTypeId(Long id,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 group by dropFrame ")
|
public List<GalssTask> findDroplist(Long groups);
|
|
@Query("select t from GalssTask t where t.dropFrame=?1 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.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);
|
|
}
|
