diff options
| author | nsfisis <nsfisis@gmail.com> | 2026-02-15 16:45:35 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2026-02-15 16:45:35 +0900 |
| commit | cea7703ac440c38636ce2abd5baab35a23d05843 (patch) | |
| tree | 38de7bdf13a6b4b006319ee7800206eab9e35215 /src/server/repositories/card.ts | |
| parent | 65fcf4111bc64267624b4e348bb704d006de5327 (diff) | |
| download | kioku-cea7703ac440c38636ce2abd5baab35a23d05843.tar.gz kioku-cea7703ac440c38636ce2abd5baab35a23d05843.tar.zst kioku-cea7703ac440c38636ce2abd5baab35a23d05843.zip | |
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>
Diffstat (limited to 'src/server/repositories/card.ts')
| -rw-r--r-- | src/server/repositories/card.ts | 14 |
1 files changed, 14 insertions, 0 deletions
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, |