From 8f30811c233b02eb692107c03befaef8a55ca45a Mon Sep 17 00:00:00 2001
From: “mitao” <“2763622819@qq.com”>
Date: 星期三, 25 三月 2026 17:31:13 +0800
Subject: [PATCH] feat:报告导出
---
admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 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
new file mode 100644
index 0000000..91445be
--- /dev/null
+++ b/admin-server/src/main/java/com/estate/expert/admin/domain/exam/record/RecordRepository.java
@@ -0,0 +1,29 @@
+package com.estate.expert.admin.domain.exam.record;
+
+import com.estate.expert.admin.domain.common.EntityBaseRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
+
+import java.util.List;
+
+public interface RecordRepository extends EntityBaseRepository<Record> {
+
+ @Query("select r.problem.id, count(r) from Record r " +
+ "where r.deleted = false " +
+ "and r.device is null " +
+ "and r.problem is not null " +
+ "and r.problem.id in :problemIds " +
+ "and r.checkTask.id in :taskIds " +
+ "group by r.problem.id")
+ List<Object[]> countSystemChecksByTaskIdsAndProblemIds(@Param("taskIds") List<Integer> taskIds,
+ @Param("problemIds") List<Integer> problemIds);
+
+ @Query(value = "select r.device_id, r.problem_id, count(*) " +
+ "from record r " +
+ "where r.deleted = false " +
+ "and r.device_id is not null " +
+ "and r.problem_id is not null " +
+ "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);
+}
--
Gitblit v1.7.1