Files
Nazim KriandClaude Sonnet 5 c3a0a7b765 Add member accounts, follow-based leaderboard, and dedicated Postgres
Members register via email+password (scrypt) or Google OAuth — same
signed-cookie + scrypt pattern as LokiLab (lib/auth.ts, member-password.ts,
member-auth.ts, google-oauth.ts), own AUTH_SECRET and own OAuth client,
own dedicated Postgres database (lokiloto-db on Coolify), fully isolated
from LokiLab's own DB and auth.

Leaderboard tracks who follows Loki's picks most accurately — members
star a pick from the results panel (FollowButton), resolution reuses
LokiLab's own lastDraw.won, no money or pooled play involved anywhere.
Leaderboard page renders a horizontal bar chart (recharts) plus a ranked
list.

Profile page: public nickname (required to appear on the leaderboard),
list of followed picks. Header now carries nav + a user menu (avatar
dropdown when signed in, "Connexion" button otherwise).

Dockerfile runs prisma migrate deploy at container start via
docker-entrypoint.sh, same pattern as LokiLab.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-10-30 09:02:26 -04:00

71 lines
2.4 KiB
TypeScript

import 'server-only'
import { prisma } from './db'
import { getArmyFeed } from './lokilab-feed'
export async function followPick(userId: string, lotteryId: string, country: string, targetDrawDate: string) {
await prisma.followedPick.upsert({
where: { userId_lotteryId_targetDrawDate: { userId, lotteryId, targetDrawDate } },
update: {},
create: { userId, lotteryId, country, targetDrawDate },
})
}
export async function unfollowPick(userId: string, lotteryId: string, targetDrawDate: string) {
await prisma.followedPick.deleteMany({ where: { userId, lotteryId, targetDrawDate } })
}
export async function listFollowedPicks(userId: string) {
return prisma.followedPick.findMany({ where: { userId }, orderBy: { createdAt: 'desc' } })
}
export interface MemberStanding {
userId: string
displayName: string
avatarUrl: string | null
followed: number
wins: number
winRate: number
}
/**
* Leaderboard = who follows Loki's picks most accurately, not who won money.
* Resolution reuses LokiLab's own lastDraw.won per lottery/date rather than
* re-deriving win logic here — a follow only counts once the matching
* lottery/date pair shows up as LokiLab's most recent resolved draw.
*/
export async function leaderboard(limit = 20): Promise<MemberStanding[]> {
const feed = await getArmyFeed()
const resolvedByKey = new Map<string, boolean>()
for (const l of feed.lotteries) {
if (l.lastDraw?.pick) resolvedByKey.set(`${l.id}:${l.lastDraw.date}`, l.lastDraw.won ?? false)
}
const follows = await prisma.followedPick.findMany({
include: { user: { select: { id: true, name: true, publicNickname: true, avatarUrl: true } } },
})
const byUser = new Map<string, MemberStanding>()
for (const f of follows) {
const key = `${f.lotteryId}:${f.targetDrawDate}`
if (!resolvedByKey.has(key)) continue
const won = resolvedByKey.get(key)!
const entry =
byUser.get(f.userId) ??
({
userId: f.userId,
displayName: f.user.publicNickname || f.user.name,
avatarUrl: f.user.avatarUrl,
followed: 0,
wins: 0,
winRate: 0,
} satisfies MemberStanding)
entry.followed++
if (won) entry.wins++
byUser.set(f.userId, entry)
}
const standings = [...byUser.values()].map((s) => ({ ...s, winRate: s.followed > 0 ? s.wins / s.followed : 0 }))
standings.sort((a, b) => b.winRate - a.winRate || b.followed - a.followed)
return standings.slice(0, limit)
}