package com.northglass.repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.GalssTaskDetails;
|
import com.northglass.entity.PatternTask;
|
import com.northglass.entity.PatternTaskBuffer;
|
|
public interface PatternTaskBufferDao extends JpaRepository<PatternTaskBuffer, Long>{
|
|
/*@Query("select t from RawPackage t where t.fileName = '052-123' and t.fileUrl = '1' and t.state = '已下发' and t.operator = '1' and t.createTime = '2021-09-22 13:22:18' and t.receiveTime = '2021-09-22 13:22:21' ")
|
public List<RawPackage> findMachineDispose();*/
|
@Query("select t from PatternTaskBuffer t where t.engineeringId = ?1 ")
|
public List<PatternTaskBuffer> findgetEnd(String fileName);
|
|
|
@Query("select count(t) from PatternTaskBuffer t where t.engineeringId = ?1 ")
|
public int findbypattertaskcount(String fileName);
|
|
|
@Query(nativeQuery=true,value="select raw_width,raw_height,raw_thickness,color,count(*) as shuliang,rank from gmms_pattern_task_buffer t where t.engineering_id =?1 group by raw_width,raw_height,raw_thickness,color")
|
public List<Object[]> findIdGroupBy(String fileName);
|
}
|
