feat(challenge): allow recalculate submission count for teams

GZTimeWalker · GZTimeWalker · commit c63ef1893629 · 2025-09-04T01:16:02.000+08:00
diff --git a/src/GZCTF/Repositories/GameChallengeRepository.cs b/src/GZCTF/Repositories/GameChallengeRepository.cs
@@ -117,7 +117,7 @@ public async Task<bool> RecalculateAcceptedCount(Game game, CancellationToken to
                 .GroupBy(i => i.ChallengeId)
                 .Select(g => new { ChallengeId = g.Key, Count = g.Count() });
 
-            await Context.GameChallenges.IgnoreAutoIncludes()
+            await Context.GameChallenges.AsNoTracking().IgnoreAutoIncludes()
                 .Where(c => query.Any(r => r.ChallengeId == c.Id))
                 .ExecuteUpdateAsync(
                     setter =>
@@ -126,8 +126,24 @@ await Context.GameChallenges.IgnoreAutoIncludes()
                             c => query.First(r => r.ChallengeId == c.Id).Count),
                     token);
 
-            await cacheHelper.FlushScoreboardCache(game.Id, token);
+            var attempts = Context.Submissions.AsNoTracking()
+                .IgnoreAutoIncludes()
+                .Where(s => s.GameId == game.Id)
+                .GroupBy(s => new { s.ChallengeId, s.ParticipationId })
+                .Select(g => new { g.Key.ChallengeId, g.Key.ParticipationId, Count = g.Count() });
+
+            await Context.GameInstances.AsNoTracking().IgnoreAutoIncludes()
+                .Where(i => attempts.Any(a => 
+                    a.ChallengeId == i.ChallengeId && a.ParticipationId == i.ParticipationId))
+                .ExecuteUpdateAsync(
+                    setter => setter.SetProperty(
+                        i => i.SubmissionCount,
+                        i => attempts.First(a =>
+                            a.ChallengeId == i.ChallengeId && a.ParticipationId == i.ParticipationId).Count),
+                    token);
+
             await trans.CommitAsync(token);
+            await cacheHelper.FlushScoreboardCache(game.Id, token);
         }
         catch
         {
