From 8afcc37e0de5aa3ca3cc3f175f180e9339f60424 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期五, 17 四月 2026 15:11:52 +0800
Subject: [PATCH] update
---
admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java b/admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java
index 91445be..be2dcf1 100644
--- a/admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java
+++ b/admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java
@@ -26,4 +26,12 @@
"and r.check_task_id in (:taskIds) " +
"group by r.device_id, r.problem_id", nativeQuery = true)
List<Object[]> countDeviceChecksByTaskIds(@Param("taskIds") List<Integer> taskIds);
+
+ @Query(value = "select r.device_id, count(distinct r.check_task_id) " +
+ "from record r " +
+ "where r.deleted = false " +
+ "and r.device_id is not null " +
+ "and r.check_task_id in (:taskIds) " +
+ "group by r.device_id", nativeQuery = true)
+ List<Object[]> countDeviceCheckTasksByTaskIds(@Param("taskIds") List<Integer> taskIds);
}
--
Gitblit v1.7.1