import { Form, redirect, useLoaderData, useActionData, useNavigation } from 'react-router'; import type { Route } from './+types/admin.sports-seasons.$id.elo-ratings'; import { logger } from '~/lib/logger'; import { findSportsSeasonById } from '~/models/sports-season'; import { findParticipantsBySportsSeasonId } from '~/models/season-participant'; import { getAllParticipantEVsForSeason, batchSaveSourceElos, } from '~/models/participant-expected-value'; import type { SimulatorType } from '~/services/simulations/registry'; import { Button } from '~/components/ui/button'; import { Input } from '~/components/ui/input'; import { Label } from '~/components/ui/label'; import { Textarea } from '~/components/ui/textarea'; import { Card, CardContent, CardDescription, CardHeader, CardTitle, } from '~/components/ui/card'; import { useState } from 'react'; import { Loader2, CheckCircle2, AlertCircle } from 'lucide-react'; import { normalizeName } from '~/lib/fuzzy-match'; import { getSimulatorConfig, supportsProjectedWins, type SimulatorConfig } from '~/services/simulations/simulator-config'; import { eloToProjectedTablePoints, eloToProjectedWins, projectedTablePointsToElo, projectedWinsToElo, } from '~/services/probability-engine'; import { runSportsSeasonSimulation } from '~/services/simulations/runner'; import { getSportsSeasonSimulatorConfig } from '~/models/simulator'; // Simulator types that use worldRanking in addition to sourceElo const RANKING_SIMULATOR_TYPES = new Set(['darts_bracket', 'cs2_major_qualifying_points', 'college_hockey_bracket']); const RANK_ONLY_SIMULATOR_TYPES = new Set(['college_hockey_bracket']); function rankingLabel(simulatorType: string | null | undefined): string { if (simulatorType === 'cs2_major_qualifying_points') return 'HLTV Rank'; if (simulatorType === 'college_hockey_bracket') return 'NPI Rank'; return 'World Rank'; } function configNumber(config: Record | undefined, key: string, fallback: number): number { const value = config?.[key]; return typeof value === 'number' && Number.isFinite(value) ? value : fallback; } async function getProjectionSimulatorConfig( sportsSeasonId: string, simulatorType: SimulatorType ): Promise { const baseConfig = getSimulatorConfig(simulatorType); if (!baseConfig) return null; const runtimeConfig = await getSportsSeasonSimulatorConfig(sportsSeasonId); const config = runtimeConfig?.config; return { ...baseConfig, seasonGames: configNumber(config, 'seasonGames', baseConfig.seasonGames), parityFactor: configNumber(config, 'parityFactor', baseConfig.parityFactor), averageOpponentElo: configNumber(config, 'averageOpponentElo', baseConfig.averageOpponentElo), }; } export function meta({ data }: Route.MetaArgs): Route.MetaDescriptors { return [{ title: `Elo Ratings — ${data?.sportsSeason?.name ?? "Sports Season"} - Brackt Admin` }]; } export async function loader({ params }: Route.LoaderArgs) { const sportsSeasonId = params.id; const sportsSeason = await findSportsSeasonById(sportsSeasonId); if (!sportsSeason) { throw new Response('Sports season not found', { status: 404 }); } const participants = await findParticipantsBySportsSeasonId(sportsSeasonId); const existingEVs = await getAllParticipantEVsForSeason(sportsSeasonId); const existingData: Record = {}; for (const ev of existingEVs) { existingData[ev.participantId] = { elo: ev.sourceElo ?? null, ranking: ev.worldRanking ?? null, }; } const usesRanking = RANKING_SIMULATOR_TYPES.has(sportsSeason.sport?.simulatorType ?? ''); const simulatorConfig = sportsSeason.sport?.simulatorType ? await getProjectionSimulatorConfig(sportsSeasonId, sportsSeason.sport.simulatorType as SimulatorType) : null; const canUseProjectedWins = sportsSeason.sport?.simulatorType ? supportsProjectedWins(sportsSeason.sport.simulatorType as SimulatorType) : false; return { sportsSeason, participants, existingData, usesRanking, simulatorConfig, canUseProjectedWins }; } interface ActionData { success?: boolean; message?: string; } export async function action({ request, params }: Route.ActionArgs) { const sportsSeasonId = params.id; const formData = await request.formData(); const sportsSeason = await findSportsSeasonById(sportsSeasonId); if (!sportsSeason) { return { success: false, message: 'Sports season not found' }; } const participants = await findParticipantsBySportsSeasonId(sportsSeasonId); const simulatorType = sportsSeason.sport?.simulatorType ?? ''; const usesRanking = RANKING_SIMULATOR_TYPES.has(simulatorType); const allowsRankOnly = RANK_ONLY_SIMULATOR_TYPES.has(simulatorType); const rawMode = formData.get('inputMode'); const inputMode = rawMode === 'projectedWins' ? 'projectedWins' : 'elo'; const eloInputs: Array<{ participantId: string; sportsSeasonId: string; sourceElo: number | null; worldRanking?: number | null; projectedWins?: number | null; projectedTablePoints?: number | null; metadata?: Record | null; }> = []; if (inputMode === 'projectedWins' && sportsSeason.sport?.simulatorType) { const config = await getProjectionSimulatorConfig(sportsSeasonId, sportsSeason.sport.simulatorType as SimulatorType); if (!config) { return { success: false, message: 'This sport does not support projection input.' }; } for (const participant of participants) { const winsVal = formData.get(`wins_${participant.id}`) as string; if (winsVal && winsVal.trim() !== '') { const projectedWins = parseFloat(winsVal); const projectionMax = config.projectionInput === 'tablePoints' ? config.seasonGames * 3 : config.seasonGames; if (!isNaN(projectedWins) && projectedWins >= 0 && projectedWins <= projectionMax) { const elo = config.projectionInput === 'tablePoints' ? projectedTablePointsToElo(projectedWins, config.seasonGames, config.parityFactor, config.averageOpponentElo) : projectedWinsToElo(projectedWins, config.seasonGames, config.parityFactor, config.averageOpponentElo); eloInputs.push({ participantId: participant.id, sportsSeasonId, sourceElo: elo, projectedWins: config.projectionInput === 'tablePoints' ? null : projectedWins, projectedTablePoints: config.projectionInput === 'tablePoints' ? projectedWins : null, metadata: { sourceEloMethod: config.projectionInput === 'tablePoints' ? 'projectedTablePoints' : 'projectedWins', }, }); } } } } else { for (const participant of participants) { const eloVal = formData.get(`elo_${participant.id}`) as string; const rankVal = formData.get(`rank_${participant.id}`) as string; const elo = eloVal && eloVal.trim() !== '' ? Number(eloVal) : null; const ranking = rankVal && rankVal.trim() !== '' ? Number(rankVal) : null; const validElo = elo !== null && !isNaN(elo) && elo > 0; const validRanking = ranking !== null && !isNaN(ranking) && ranking > 0; if (validElo || (usesRanking && allowsRankOnly && validRanking)) { if (usesRanking) { eloInputs.push({ participantId: participant.id, sportsSeasonId, sourceElo: validElo ? elo : null, worldRanking: validRanking ? ranking : null, }); } else if (validElo) { eloInputs.push({ participantId: participant.id, sportsSeasonId, sourceElo: elo }); } } } } if (eloInputs.length === 0) { return { success: false, message: inputMode === 'projectedWins' ? 'Please enter projections for at least one participant' : allowsRankOnly ? 'Please enter an Elo rating or NPI rank for at least one participant' : 'Please enter an Elo rating for at least one participant' }; } if (!sportsSeason.sport?.simulatorType) { return { success: false, message: 'This sport has no simulator type configured. Set one on the sport in the admin panel.' }; } if (sportsSeason.simulationStatus === 'running') { return { success: false, message: 'A simulation is already running. Please wait.' }; } try { await batchSaveSourceElos(eloInputs); await runSportsSeasonSimulation(sportsSeasonId); } catch (error) { logger.error('Error running simulation:', error); return { success: false, message: error instanceof Error ? error.message : 'Simulation failed', }; } return redirect(`/admin/sports-seasons/${sportsSeasonId}/expected-values`); } export default function AdminSportsSeasonEloRatings() { const { sportsSeason, participants, existingData, usesRanking, simulatorConfig, canUseProjectedWins } = useLoaderData(); const actionData = useActionData(); const navigation = useNavigation(); const [inputMode, setInputMode] = useState<'elo' | 'projectedWins'>('elo'); const projectionLabel = simulatorConfig?.projectionInput === 'tablePoints' ? 'Projected Points' : 'Projected Wins'; const projectionUnit = simulatorConfig?.projectionInput === 'tablePoints' ? 'points' : 'wins'; const projectionMax = simulatorConfig ? simulatorConfig.projectionInput === 'tablePoints' ? simulatorConfig.seasonGames * 3 : simulatorConfig.seasonGames : 0; const [eloValues, setEloValues] = useState>(() => { const initial: Record = {}; participants.forEach(p => { const d = existingData[p.id]; if (d?.elo !== null && d?.elo !== undefined) initial[p.id] = d.elo.toString(); }); return initial; }); const [rankValues, setRankValues] = useState>(() => { const initial: Record = {}; participants.forEach(p => { const d = existingData[p.id]; if (d?.ranking !== null && d?.ranking !== undefined) initial[p.id] = d.ranking.toString(); }); return initial; }); const [winsValues, setWinsValues] = useState>(() => { const initial: Record = {}; if (simulatorConfig) { participants.forEach(p => { const d = existingData[p.id]; if (d?.elo !== null && d?.elo !== undefined) { initial[p.id] = (simulatorConfig.projectionInput === 'tablePoints' ? eloToProjectedTablePoints(d.elo, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo) : eloToProjectedWins(d.elo, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo) ).toFixed(1); } }); } return initial; }); const [bulkText, setBulkText] = useState(''); const [parseResults, setParseResults] = useState<{ matched: Array<{ participantId: string; name: string; elo: number | null; ranking: number | null; inputName: string }>; unmatched: Array<{ inputName: string; elo: number | null; ranking: number | null }>; } | null>(null); function findParticipantMatch(inputName: string) { const normalizedInput = normalizeName(inputName); const normalized = participants.map(p => ({ p, n: normalizeName(p.name) })); const exact = normalized.find(({ n }) => n === normalizedInput); if (exact) return exact.p; const contains = normalized.find(({ n }) => n.includes(normalizedInput) || normalizedInput.includes(n)); if (contains) return contains.p; const inputWords = normalizedInput.split(' ').filter(w => w.length > 2); const overlap = normalized.find(({ n }) => { const pWords = n.split(' ').filter(w => w.length > 2); const shared = inputWords.filter(w => pWords.includes(w)); return shared.length > 0 && shared.length >= Math.min(inputWords.length, pWords.length) * 0.5; }); return overlap?.p ?? null; } function parseBulkText() { const lines = bulkText.split('\n'); const matched: Array<{ participantId: string; name: string; elo: number | null; ranking: number | null; inputName: string }> = []; const unmatched: Array<{ inputName: string; elo: number | null; ranking: number | null }> = []; const seen = new Set(); for (const line of lines) { const trimmed = line.trim(); if (!trimmed) continue; if (inputMode === 'projectedWins' && simulatorConfig) { const match = /^(.+?)[\s,:\t]+(\d+(?:\.\d+)?)\s*$/.exec(trimmed); if (!match) continue; const inputName = match[1].trim(); const projectedWins = parseFloat(match[2]); if (isNaN(projectedWins) || projectedWins < 0 || projectedWins > projectionMax) continue; const elo = simulatorConfig.projectionInput === 'tablePoints' ? projectedTablePointsToElo(projectedWins, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo) : projectedWinsToElo(projectedWins, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo); const participant = findParticipantMatch(inputName); if (participant && !seen.has(participant.id)) { seen.add(participant.id); matched.push({ participantId: participant.id, name: participant.name, elo, ranking: null, inputName }); } else if (!participant) { unmatched.push({ inputName, elo, ranking: null }); } } else { const match = usesRanking ? /^(.+?)[\s,:\t]+(\d{1,5})(?:[\s,:\t]+(\d{1,3}))?\s*$/.exec(trimmed) : /^(.+?)[\s,:\t]+(\d{3,5})\s*$/.exec(trimmed); if (!match) continue; const inputName = match[1].trim(); const firstNumber = parseInt(match[2], 10); const parsedAsRankOnly = usesRanking && allowsRankOnly && !match[3] && firstNumber < 500; const elo = parsedAsRankOnly ? null : firstNumber; const ranking = parsedAsRankOnly ? firstNumber : usesRanking && match[3] ? parseInt(match[3], 10) : null; const validElo = elo !== null && !isNaN(elo) && elo >= 500 && elo <= 5000; const validRanking = ranking !== null && !isNaN(ranking) && ranking > 0; if (!validElo && !(allowsRankOnly && validRanking)) continue; const participant = findParticipantMatch(inputName); if (participant && !seen.has(participant.id)) { seen.add(participant.id); matched.push({ participantId: participant.id, name: participant.name, elo, ranking, inputName }); } else if (!participant) { unmatched.push({ inputName, elo, ranking }); } } } setParseResults({ matched, unmatched }); } function applyMatches() { if (!parseResults) return; const newElos = { ...eloValues }; const newRanks = { ...rankValues }; const newWins = { ...winsValues }; for (const m of parseResults.matched) { if (m.elo !== null) newElos[m.participantId] = m.elo.toString(); if (m.ranking !== null) newRanks[m.participantId] = m.ranking.toString(); if (inputMode === 'projectedWins' && simulatorConfig && m.elo !== null) { newWins[m.participantId] = (simulatorConfig.projectionInput === 'tablePoints' ? eloToProjectedTablePoints(m.elo, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo) : eloToProjectedWins(m.elo, simulatorConfig.seasonGames, simulatorConfig.parityFactor, simulatorConfig.averageOpponentElo) ).toFixed(1); } } setEloValues(newElos); setRankValues(newRanks); setWinsValues(newWins); setParseResults(null); setBulkText(''); } const isSubmitting = navigation.state === 'submitting'; const simulatorType = sportsSeason.sport?.simulatorType ?? null; const rankLabel = rankingLabel(simulatorType); const allowsRankOnly = RANK_ONLY_SIMULATOR_TYPES.has(simulatorType ?? ''); const participantLabel = simulatorType === 'college_hockey_bracket' ? 'Team' : 'Player'; // When ranking is available, sort by rank ascending, then unranked alphabetically const sortedParticipants = usesRanking ? [...participants].toSorted((a, b) => { const rankA = rankValues[a.id] ? parseInt(rankValues[a.id], 10) : null; const rankB = rankValues[b.id] ? parseInt(rankValues[b.id], 10) : null; if (rankA !== null && rankB !== null) return rankA - rankB; if (rankA !== null) return -1; if (rankB !== null) return 1; return a.name.localeCompare(b.name); }) : participants; return (

Elo Ratings

{sportsSeason.sport.name} — {sportsSeason.name}

{/* Input Mode Toggle */} {canUseProjectedWins && !usesRanking && (
)} {/* Bulk Import */} Bulk Import {inputMode === 'projectedWins' && simulatorConfig ? ( <> Paste projected season {projectionUnit} one per line. Format: Team Name, {simulatorConfig.projectionInput === 'tablePoints' ? '76.5' : '15.6'}. Projections are automatically converted to Elo ratings using {simulatorConfig.seasonGames} total games and parity factor {simulatorConfig.parityFactor}. Names are fuzzy-matched to participants. ) : usesRanking ? ( <> Paste one entry per line. Format:{' '} {allowsRankOnly ? ( <>Use Name, {rankLabel} or Name, Elo, {rankLabel}. Elo is optional when NPI rank is present. ) : ( <>Use Name, Elo, {rankLabel} (ranking is optional — omit it and the simulator will use Elo order for seeding). )}{' '} Names are fuzzy-matched to participants. ) : ( <> Paste Elo ratings one per line. Format: Player Name, 2450. Player names are fuzzy-matched to participants. )}