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.GalssTask;
|
import com.northglass.entity.GalssTaskDetails;
|
import com.northglass.entity.GalssTaskHollow;
|
import com.northglass.entity.GalssTaskShelf;
|
import com.northglass.entity.GalssTaskSlicecage;
|
import com.northglass.entity.GalssTaskShelf;
|
|
public interface GalssTaskSlicecageDao extends JpaRepository<GalssTaskSlicecage, Long>{
|
|
|
|
@Query("select t.processcardId from GalssTaskSlicecage t group by t.processcardId ")
|
public List<GalssTaskSlicecage> findDroplist();
|
|
|
@Query(nativeQuery=true,value="select * from gmms_galss_task_slicecage where processcard_id like CONCAT('%',?1,'%');")
|
public List<GalssTaskSlicecage> findbyprocesscardid(String processcardid);
|
|
@Modifying
|
@Query("delete from GalssTaskSlicecage t where t.processcardId like CONCAT('%',?1,'%')")
|
public void deleteprocesscardid(String processcardid);
|
|
@Query("select t from GalssTaskSlicecage t where t.typeId=?1 ")
|
public List<GalssTaskSlicecage> findbyTypeId(Long id);
|
|
@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片' and (t.workState='出库中' or t.workState='进库中' or t.workState='等待中' or t.workState='已出库' ) ")
|
public List<GalssTaskSlicecage> findByproceduretask();
|
|
@Query("select t from GalssTaskSlicecage t where t.slicecageRank=?1 ")
|
public List<GalssTaskSlicecage> findslicecagerank(Long slicecagerank);
|
|
@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片笼上片' and t.workState='已完成' 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)))")
|
public List<GalssTaskSlicecage> findByidentify2(Long groups,Double minwidth,Double maxwidth,Double minheigth,Double maxheigth);
|
|
@Query("select t from GalssTaskSlicecage t where t.workProcedure='理片笼上片' and t.workState='已完成'")
|
public List<GalssTaskSlicecage> findByidentify1();
|
|
}
|
