From 84be23571d0e52f28abe52371939ce551e998760 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sun, 15 Feb 2026 17:36:13 +0900 Subject: feat(deck): add progress bar showing review/total ratio on deck list Add totalCardCount and reviewCardCount to deck API responses and display a progress bar on the home page for each deck with cards. Co-Authored-By: Claude Opus 4.6 --- src/server/repositories/card.ts | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'src/server/repositories/card.ts') diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts index 223050a..a2b0972 100644 --- a/src/server/repositories/card.ts +++ b/src/server/repositories/card.ts @@ -230,6 +230,28 @@ export const cardRepository: CardRepository = { return result[0]?.count ?? 0; }, + async countTotalCards(deckId: string): Promise { + const result = await db + .select({ count: sql`count(*)::int` }) + .from(cards) + .where(and(eq(cards.deckId, deckId), isNull(cards.deletedAt))); + return result[0]?.count ?? 0; + }, + + async countReviewStateCards(deckId: string): Promise { + const result = await db + .select({ count: sql`count(*)::int` }) + .from(cards) + .where( + and( + eq(cards.deckId, deckId), + isNull(cards.deletedAt), + eq(cards.state, CardState.Review), + ), + ); + return result[0]?.count ?? 0; + }, + async findDueCardsWithNoteData( deckId: string, now: Date, -- cgit v1.3-1-g0d28