From 309b5eb17c510c781daec96bbfef3b693f3a4d7e Mon Sep 17 00:00:00 2001
From: “mitao” <“2763622819@qq.com”>
Date: 星期三, 25 三月 2026 17:29:52 +0800
Subject: [PATCH] feat:报告导出

---
 admin-server/src/main/java/com/estate/expert/admin/domain/exam/task/check/CheckTaskRepository.java |   12 +++++++++++-
 1 files changed, 11 insertions(+), 1 deletions(-)

diff --git a/admin-server/src/main/java/com/estate/expert/admin/domain/exam/task/check/CheckTaskRepository.java b/admin-server/src/main/java/com/estate/expert/admin/domain/exam/task/check/CheckTaskRepository.java
index 58bee29..df12fe0 100644
--- a/admin-server/src/main/java/com/estate/expert/admin/domain/exam/task/check/CheckTaskRepository.java
+++ b/admin-server/src/main/java/com/estate/expert/admin/domain/exam/task/check/CheckTaskRepository.java
@@ -1,7 +1,9 @@
 package com.estate.expert.admin.domain.exam.task.check;
 
 import com.estate.expert.admin.domain.common.EntityBaseRepository;
+import com.estate.expert.admin.domain.plan.PlanState;
 import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
 
 import java.util.List;
 
@@ -56,4 +58,12 @@
     List<CheckTask> findAllByPlanIdAndDeleted(Integer planId, boolean deleted);
 
     CheckTask getFirstByPlanIdAndProjectIdAndDeleted(Integer planId, Integer projectId, boolean deleted);
-}
\ No newline at end of file
+
+    @Query("select t.id from CheckTask t " +
+            "where t.deleted = false " +
+            "and t.project.id = :projectId " +
+            "and t.plan.deleted = false " +
+            "and t.plan.state = :planState")
+    List<Integer> listTaskIdsByProjectAndPlanState(@Param("projectId") Integer projectId,
+                                                   @Param("planState") PlanState planState);
+}

--
Gitblit v1.7.1