From cea7703ac440c38636ce2abd5baab35a23d05843 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sun, 15 Feb 2026 16:45:35 +0900
Subject: feat(deck): display new card count on deck detail page

Add newCardCount alongside Total and Due stats in the deck detail view,
queried from cards with state=New via a new countNewCards repository method.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
---
 src/server/repositories/card.test.ts |  1 +
 src/server/repositories/card.ts      | 14 ++++++++++++++
 src/server/repositories/types.ts     |  1 +
 3 files changed, 16 insertions(+)

(limited to 'src/server/repositories')

diff --git a/src/server/repositories/card.test.ts b/src/server/repositories/card.test.ts
index b492fd7..b959709 100644
--- a/src/server/repositories/card.test.ts
+++ b/src/server/repositories/card.test.ts
@@ -112,6 +112,7 @@ function createMockCardRepo(): CardRepository {
 		softDeleteByNoteId: vi.fn(),
 		findDueCards: vi.fn(),
 		countDueCards: vi.fn(),
+		countNewCards: vi.fn(),
 		findDueCardsWithNoteData: vi.fn(),
 		findDueCardsForStudy: vi.fn(),
 		updateFSRSFields: vi.fn(),
diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts
index 0f1ef79..223050a 100644
--- a/src/server/repositories/card.ts
+++ b/src/server/repositories/card.ts
@@ -216,6 +216,20 @@ export const cardRepository: CardRepository = {
 		return result[0]?.count ?? 0;
 	},
 
+	async countNewCards(deckId: string): Promise<number> {
+		const result = await db
+			.select({ count: sql<number>`count(*)::int` })
+			.from(cards)
+			.where(
+				and(
+					eq(cards.deckId, deckId),
+					isNull(cards.deletedAt),
+					eq(cards.state, CardState.New),
+				),
+			);
+		return result[0]?.count ?? 0;
+	},
+
 	async findDueCardsWithNoteData(
 		deckId: string,
 		now: Date,
diff --git a/src/server/repositories/types.ts b/src/server/repositories/types.ts
index 71cb811..b70b247 100644
--- a/src/server/repositories/types.ts
+++ b/src/server/repositories/types.ts
@@ -145,6 +145,7 @@ export interface CardRepository {
 	softDeleteByNoteId(noteId: string): Promise<boolean>;
 	findDueCards(deckId: string, now: Date): Promise<Card[]>;
 	countDueCards(deckId: string, now: Date): Promise<number>;
+	countNewCards(deckId: string): Promise<number>;
 	findDueCardsWithNoteData(
 		deckId: string,
 		now: Date,
-- 
cgit v1.3-1-g0d28