From 4b33796be3887c81fa40fba2f55dce4489cff041 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期三, 01 四月 2026 14:55:32 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/estate_expert

---
 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