提交

廖井涛

2025-05-26 3a975df5b368bc68ee7a81d34920b209f2ff607b

 河北望美项目/MES_11/src/main/java/com/northglass/repository/PatternTaskBufferDao.java

@@ -1,10 +1,12 @@
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;

@@ -18,4 +20,8 @@
   
   @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);
}