Connection Error

{error}

\n );\n }\n\n if (isLoading) {\n return (\n

Loading leaderboard...

\n );\n }\n\n // Filter to only show chores with data\n const displayChores = leaderboard;\n\n return (\n

\n {/* Header */}\n

💩 Shitty: Leaderboard

\n\n {/* Main Content - Flex grow to fill remaining space */}\n

\n {/* Removed title and last updated from here */}\n

\n\n {displayChores.length === 0\n ? (\n

No activity this week

Time to get started!

\n )\n : (\n

\n {displayChores.map(({ chore, contributions, totalCount }) => (\n \n ))}\n

\n )}\n

\n\n {/* Footer */}\n \n

\n );\n}\n\nfunction ChoreModule({ chore, contributions, totalCount }: {\n chore: Chore;\n contributions: Array<{ person: string; count: number }>;\n totalCount: number;\n}) {\n // Helper function to get place emoji\n const getPlaceEmoji = (index: number) => {\n switch (index) {\n case 0: return \"🥇\"; // First place\n case 1: return \"🥈\"; // Second place\n default: return \"\"; // No emoji for 3rd place and beyond\n }\n };\n\n return (\n

\n {/* Module Header - Guitar Pedal Style */}\n

{chore.icon}

{chore.name}

\n {chore.id !== \"untended\" && (\n

\n {totalCount} {totalCount === 1 ? 'time' : 'times'} this week\n

\n )}\n

\n\n {/* Module Body - Flex grow to fill available space */}\n

\n {contributions.length > 0 ? (\n

\n {contributions.map(({ person, count }, index) => (\n \n

\n {person}\n ({count})\n

\n {getPlaceEmoji(index)}\n

\n ))}\n

\n ) : (\n

No activity this week

\n )}\n

\n\n {/* Module Footer - Connection Points */}\n

\n \n );\n}\n\n// Client-side rendering\nfunction client() {\n const rootElement = document.getElementById(\"root\");\n if (rootElement) {\n createRoot(rootElement).render();\n } else {\n console.error(\"Root element not found!\");\n }\n}\n\n// Server-side handler\nasync function serverHandler(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const url = new URL(request.url);\n const pathParts = url.pathname.split(\"/\").filter(p => p.trim() !== \"\");\n\n // API endpoints - proxy to the main Shitty database\n if (pathParts[0] === \"api\" && pathParts.length >= 2) {\n const syncId = pathParts[1];\n const apiResource = pathParts.length > 2 ? pathParts[2] : null;\n\n // Helper to create demo data\n function createDemoData() {\n const now = Date.now();\n const oneWeekAgo = now - (7 * 24 * 60 * 60 * 1000);\n\n const chores = [\n { id: \"dishes\", name: \"Dishes\", icon: \"🍽️\" },\n { id: \"trash\", name: \"Trash\", icon: \"🗑️\" },\n { id: \"laundry\", name: \"Laundry\", icon: \"👕\" },\n { id: \"vacuum\", name: \"Vacuum\", icon: \"🧹\" },\n { id: \"bathroom\", name: \"Bathroom\", icon: \"🚿\" },\n { id: \"kitchen\", name: \"Kitchen\", icon: \"🍳\" },\n { id: \"plants\", name: \"Water Plants\", icon: \"🪴\" },\n { id: \"groceries\", name: \"Groceries\", icon: \"🛒\" },\n ];\n\n const people = [\"Alice\", \"Bob\", \"Charlie\", \"Dana\"];\n const tending_log = [];\n\n // Generate realistic activity over the past week\n for (let i = 0; i < 45; i++) {\n const timestamp = oneWeekAgo + Math.random() * (7 * 24 * 60 * 60 * 1000);\n const person = people[Math.floor(Math.random() * people.length)];\n const chore = chores[Math.floor(Math.random() * (chores.length - 2))]; // Skip last 2 chores to make them \"untended\"\n\n tending_log.push({\n id: `demo_${i}`,\n timestamp: Math.floor(timestamp),\n person,\n chore_id: chore.id,\n notes: null,\n });\n }\n\n return {\n caretakers: people,\n tending_log,\n last_tended_timestamp: Math.max(...tending_log.map(t => t.timestamp)),\n last_caretaker: tending_log[tending_log.length - 1]?.person || null,\n chores,\n };\n }\n\n // Helper to get instance data from the main shitty database\n async function getInstanceData(currentSyncId: string) {\n // Return demo data for demo instance\n if (currentSyncId === \"demo\") {\n return createDemoData();\n }\n\n let result = await sqlite.execute(\n `SELECT caretakers, tending_log, last_tended_timestamp, last_caretaker, chores FROM shitty_instances WHERE sync_id = ?`,\n [currentSyncId],\n );\n if (result.rows.length === 0) {\n return null; // Instance doesn't exist\n }\n const row = result.rows[0] as {\n caretakers: string;\n tending_log: string;\n last_tended_timestamp: number | null;\n chores: string;\n last_caretaker: string | null;\n };\n \n return {\n caretakers: JSON.parse(row.caretakers || \"[]\"),\n tending_log: JSON.parse(row.tending_log || \"[]\"),\n last_tended_timestamp: row.last_tended_timestamp,\n last_caretaker: row.last_caretaker,\n chores: JSON.parse(row.chores || \"[]\"),\n };\n }\n\n // Only allow GET requests for read-only access\n if (request.method !== \"GET\") {\n return new Response(JSON.stringify({ error: \"Only GET requests allowed\" }), {\n status: 405,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const instanceData = await getInstanceData(syncId);\n if (!instanceData) {\n return new Response(JSON.stringify({ error: \"Instance not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Chores endpoint\n if (apiResource === \"chores\") {\n return new Response(JSON.stringify(instanceData.chores), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n // History endpoint\n else if (apiResource === \"history\") {\n const sortedHistory = [...instanceData.tending_log].sort((a, b) => b.timestamp - a.timestamp);\n return new Response(JSON.stringify(sortedHistory), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n return new Response(JSON.stringify({ error: \"API endpoint not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Serve HTML for all other routes\n return new Response(\n `\n \n \n \n \n \n Shitty Leaderboard - Modular Dashboard\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n \"cache-control\": \"no-cache, no-store, must-revalidate\",\n \"pragma\": \"no-cache\",\n \"expires\": \"0\",\n },\n },\n );\n}\n\n// Auto-run client code when in browser\nif (typeof document !== \"undefined\") {\n if (document.readyState === \"loading\") {\n document.addEventListener(\"DOMContentLoaded\", client);\n } else {\n client();\n }\n}\n\nexport default serverHandler;","deleted","label",[99],"permalink","https://www.val.town/x/jonbo/shitty-leaderboard/code/index.ts","extension","actionData","errors"]