From 3a975df5b368bc68ee7a81d34920b209f2ff607b Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期一, 26 五月 2025 16:12:08 +0800
Subject: [PATCH] 提交
---
河北望美项目/MES_11/src/main/java/com/northglass/repository/PatternTaskBufferDao.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git "a/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/java/com/northglass/repository/PatternTaskBufferDao.java" "b/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/java/com/northglass/repository/PatternTaskBufferDao.java"
index de84b32..8593d47 100644
--- "a/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/java/com/northglass/repository/PatternTaskBufferDao.java"
+++ "b/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/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);
}
--
Gitblit v1.8.0