| | |
|---|
| | | @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.width>?2 and t.height>?2 and t.patternTask.groups=?1 order by t.patternTask.id,t.engineeringId") |
|---|
| | | public List<GalssTask> findByidentify1(Long groups,double minwidths); |
|---|
| | | |
|---|
| | | @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.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.patternTask.id=?1 and t.width>?2 and t.height>?2 and t.workState='å¾
è¯å«' and t.workProcedure='æµé'") |
|---|
| | | public List<GalssTask> findpattern1(Long id,double minwidths); |
|---|
| | | |
|---|
| | | @Query("select t from GalssTask t where t.patternTask.groups=?1 and t.width>?2 and t.height>?2 and t.patternTask.flag=1 and t.workState='å¾
è¯å«' and t.workProcedure='æµé'") |
|---|
| | | public List<GalssTask> findpattern2(Long id,double minwidths); |
|---|
| | | |
|---|
| | | @Query("select t from GalssTask t where t.typeId=?1 ") |
|---|
| | | public List<GalssTask> findbyTypeId1(Long id); |
|---|
