From ba94ceae1315174798ae1967ef62268c6d16cd5b Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期一, 06 十月 2025 22:07:06 +0800
Subject: [PATCH] feat: 评审与活动相关改动 - backend(GraphQL): Activity schema 增加 updateActivityState(id, state)；实现 resolver/service 仅更新 state=2 作为逻辑删除 - backend(GraphQL): region.graphqls 新增 Query leafRegions - backend(GraphQL): player.graphqls 的 projectReviewApplications 增加可选参数 regionId - backend(Service): listProjectReviewApplications 绑定 regionId 参数，修复 QueryParameterException - frontend(web): 新增 api/activity.js 的 updateActivityState 并接入 activity-list 删除逻辑 - frontend(web): review-list.vue 权限仅校验登录，移除角色限制；查询参数修正为 name/regionId - frontend(web): 删除未引用的 ActivityList.vue - frontend(web): projectReviewNew.js GraphQL 查询增加 name 参数
---
backend/src/main/java/com/rongyichuang/judge/repository/JudgeRepository.java | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/judge/repository/JudgeRepository.java b/backend/src/main/java/com/rongyichuang/judge/repository/JudgeRepository.java
index cb0e643..64c6153 100644
--- a/backend/src/main/java/com/rongyichuang/judge/repository/JudgeRepository.java
+++ b/backend/src/main/java/com/rongyichuang/judge/repository/JudgeRepository.java
@@ -8,6 +8,7 @@
import org.springframework.stereotype.Repository;
import java.util.List;
+import java.util.Optional;
@Repository
public interface JudgeRepository extends JpaRepository<Judge, Long>, JpaSpecificationExecutor<Judge> {
@@ -16,4 +17,20 @@
List<Judge> findByNameContaining(@Param("name") String name);
boolean existsByPhone(String phone);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛ID鏌ユ壘璇勫
+ */
+ Optional<Judge> findByUserId(Long userId);
+
+ /**
+ * 妫�鏌ヨ瘎濮旀槸鍚﹀弬涓庢寚瀹氭椿鍔紙妫�鏌ユ槸鍚︽湁浠讳綍闃舵鐨勬潈闄愶級
+ */
+ @Query("SELECT COUNT(aj) > 0 FROM ActivityJudge aj WHERE aj.judgeId = :judgeId AND aj.activityId = :activityId")
+ boolean existsByIdAndActivityId(@Param("judgeId") Long judgeId, @Param("activityId") Long activityId);
+
+ /**
+ * 鏍规嵁鐘舵�佺粺璁¤瘎濮旀暟閲�
+ */
+ long countByState(Integer state);
}
\ No newline at end of file
--
Gitblit v1.8.0