💧

Water Logged!

—

added to your daily intake

\n Go to Dashboard\n

\n \n \n\n",[121,111],"67b02acdf17404c9dd0f9324ae03466bc7589a2892b113853e1cf837ce607733","frontend","3835aeae-4fe3-11f1-a66e-ee650bb23af1","fe9c11d0-4fdb-11f1-ab7d-ee650bb23af1","019e27dc-78af-7579-998f-2de58cdded4f",97,["D",1778797274417],"\n\n \n \n \n Pill Logged\n \n \n \n

\n \n \n \n

Success!

Your pill intake has been logged.

\n Go to Dashboard\n

\n \n",[121,111],"c11c67a1a5696d4cc3986ffb0bfddcd7518fb23eee847729048ae5f2b435abb8","frontend/index.tsx",{"_32":142,"_13":134,"_82":143,"_84":124,"_85":33,"_86":116,"_87":26,"_34":144,"_40":145,"_90":138,"_92":146,"_65":48,"_94":-5,"_95":-7,"_75":147,"_97":148},{"_32":133,"_13":134,"_82":135,"_84":113,"_85":57,"_86":56,"_87":26,"_34":136,"_40":137,"_90":138,"_92":139,"_65":48,"_94":-5,"_95":-7,"_75":140,"_97":141},"c11435f4-7dcb-40e3-a339-ba9f90590f78","index.tsx","019f7461-6ee4-74b9-881f-d020075e4cf0",["D",1784465181334],20,"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nconst WATER_CONFIG = {\n DAILY_TARGET_ML: 2000,\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n RESET_HOUR_UTC: 5,\n};\n\ninterface WaterLog {\n id: number;\n timestamp: number;\n milliliters: number;\n source: string;\n}\n\ninterface TodayData {\n totalToday: number;\n target: number;\n percentage: number;\n logs: WaterLog[];\n resetHour: number;\n}\n\ninterface NFCDevice {\n id: string;\n token: string;\n milliliters: number;\n name: string;\n createdAt: number;\n}\n\ninterface HistoryEntry {\n date: string;\n total: number;\n percentage: number;\n}\n\nfunction App() {\n const [isAuthenticated, setIsAuthenticated] = useState(false);\n const [loading, setLoading] = useState(true);\n const [todayData, setTodayData] = useState(null);\n const [nfcDevices, setNfcDevices] = useState([]);\n const [activeTab, setActiveTab] = useState<\"today\" | \"history\" | \"nfc\">(\"today\");\n const [toast, setToast] = useState<{ message: string; type: \"success\" | \"error\" } | null>(null);\n const [customMl, setCustomMl] = useState(\"\");\n const [history, setHistory] = useState([]);\n const [newNfcName, setNewNfcName] = useState(\"\");\n const [newNfcMl, setNewNfcMl] = useState(\"500\");\n const [createdTapUrl, setCreatedTapUrl] = useState(null);\n const [editingDeviceId, setEditingDeviceId] = useState(null);\n const [editMl, setEditMl] = useState(\"\");\n\n const [email, setEmail] = useState(\"\");\n const [signInStatus, setSignInStatus] = useState<\"idle\" | \"sending\" | \"sent\" | \"error\">(\"idle\");\n\n // Check authentication\n useEffect(() => {\n const checkAuth = async () => {\n try {\n const res = await fetch(\"/api/auth/get-session\");\n const data = await res.json();\n setIsAuthenticated(!!data.session);\n if (data.session) {\n await loadTodayData();\n await loadNfcDevices();\n await loadHistory();\n }\n } catch (err) {\n console.error(\"Auth check failed:\", err);\n } finally {\n setLoading(false);\n }\n };\n checkAuth();\n }, []);\n\n const loadTodayData = async () => {\n try {\n const res = await fetch(\"/api/water/today\");\n if (res.ok) {\n const data = await res.json();\n setTodayData(data);\n }\n } catch (err) {\n console.error(\"Failed to load today data:\", err);\n }\n };\n\n const loadNfcDevices = async () => {\n try {\n const res = await fetch(\"/api/nfc/devices\");\n if (res.ok) {\n const data = await res.json();\n setNfcDevices(data.devices);\n }\n } catch (err) {\n console.error(\"Failed to load NFC devices:\", err);\n }\n };\n\n const loadHistory = async () => {\n try {\n const res = await fetch(\"/api/water/history?days=7\");\n if (res.ok) {\n const data = await res.json();\n setHistory(data.history || []);\n }\n } catch (err) {\n console.error(\"Failed to load history:\", err);\n }\n };\n\n const handleQuickAdd = async (ml: number) => {\n try {\n const res = await fetch(\"/api/water/log\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ milliliters: ml, source: \"manual\" }),\n });\n\n if (res.ok) {\n showToast(`Added ${ml}ml of water!`, \"success\");\n await loadTodayData();\n await loadHistory();\n setCustomMl(\"\");\n }\n } catch (err) {\n showToast(\"Failed to log water\", \"error\");\n }\n };\n\n const handleCustomAdd = async () => {\n const ml = parseInt(customMl);\n if (!ml || ml < 1) {\n showToast(\"Please enter a valid amount\", \"error\");\n return;\n }\n await handleQuickAdd(ml);\n };\n\n const handleDeleteLog = async (id: number) => {\n try {\n const res = await fetch(`/api/water/${id}`, { method: \"DELETE\" });\n if (res.ok) {\n showToast(\"Log deleted\", \"success\");\n await loadTodayData();\n await loadHistory();\n }\n } catch (err) {\n showToast(\"Failed to delete log\", \"error\");\n }\n };\n\n const handleCreateNfc = async () => {\n const ml = parseInt(newNfcMl);\n if (!ml || ml < 1) {\n showToast(\"Enter a valid amount\", \"error\");\n return;\n }\n try {\n const res = await fetch(\"/api/nfc/device\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: newNfcName || undefined, milliliters: ml }),\n });\n if (res.ok) {\n const data = await res.json();\n setCreatedTapUrl(data.tapUrl);\n setNewNfcName(\"\");\n setNewNfcMl(\"500\");\n await loadNfcDevices();\n showToast(\"NFC device created! Copy the link below.\", \"success\");\n }\n } catch (err) {\n showToast(\"Failed to create NFC device\", \"error\");\n }\n };\n\n const handleUpdateDeviceMl = async (id: string) => {\n const ml = parseInt(editMl);\n if (!ml || ml < 1) {\n showToast(\"Enter a valid amount\", \"error\");\n return;\n }\n try {\n const res = await fetch(`/api/nfc/device/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ milliliters: ml }),\n });\n if (res.ok) {\n setEditingDeviceId(null);\n await loadNfcDevices();\n showToast(\"Amount updated\", \"success\");\n }\n } catch (err) {\n showToast(\"Failed to update\", \"error\");\n }\n };\n\n const handleDeleteDevice = async (id: string) => {\n try {\n const res = await fetch(`/api/nfc/device/${id}`, { method: \"DELETE\" });\n if (res.ok) {\n showToast(\"Device deleted\", \"success\");\n await loadNfcDevices();\n }\n } catch (err) {\n showToast(\"Failed to delete device\", \"error\");\n }\n };\n\n const showToast = (message: string, type: \"success\" | \"error\") => {\n setToast({ message, type });\n setTimeout(() => setToast(null), 3000);\n };\n\n if (loading) {\n return (\n

\n );\n }\n\n if (!isAuthenticated) {\n return (\n

💧 Water Tracker

\n {signInStatus === \"sent\" ? (\n

📬 Check your email

\n We sent a sign-in link to {email}.\n

\n ) : (\n {\n e.preventDefault();\n setSignInStatus(\"sending\");\n const { error } = await authClient.signIn.magicLink({\n email,\n callbackURL: \"/\",\n });\n if (error) {\n setSignInStatus(\"error\");\n } else {\n setSignInStatus(\"sent\");\n }\n }}\n className=\"space-y-3\"\n >\n setEmail(e.target.value)}\n placeholder=\"you@example.com\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={signInStatus === \"sending\"}\n />\n \n {signInStatus === \"sending\" ? \"Sending…\" : \"Send magic link\"}\n \n {signInStatus === \"error\" && (\n

Failed to send magic link. Try again.

\n )}\n \n )}\n

\n );\n }\n\n const percentage = todayData?.percentage || 0;\n const total = todayData?.totalToday || 0;\n const target = todayData?.target || WATER_CONFIG.DAILY_TARGET_ML;\n\n return (\n

\n {/* Header */}\n

💧 Water Tracker

\n authClient.signOut().then(() => location.reload())}\n className=\"text-sm text-gray-600 hover:text-gray-900\"\n >\n Sign out\n \n

\n\n {/* Toast */}\n {toast && (\n \n {toast.message}\n

\n )}\n\n

\n {/* Tabs */}\n

\n setActiveTab(\"today\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"today\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n Today\n \n setActiveTab(\"history\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"history\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n History\n \n setActiveTab(\"nfc\")}\n className={`px-4 py-2 rounded-lg font-medium transition-colors ${\n activeTab === \"nfc\"\n ? \"bg-blue-500 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n NFC Devices\n \n

\n\n {/* Today Tab */}\n {activeTab === \"today\" && (\n

\n {/* Progress Card */}\n

{total}ml

of {target}ml daily goal

\n {percentage < 100 ? \"🥛\" : \"🎉\"}\n

\n\n {/* Progress Bar */}\n

\n {percentage}% complete\n

\n\n {/* Quick Add Buttons */}\n

\n {WATER_CONFIG.QUICK_ADD_AMOUNTS.map((ml) => (\n handleQuickAdd(ml)}\n className=\"bg-blue-500 hover:bg-blue-600 text-white py-3 rounded-lg font-medium transition-colors\"\n >\n +{ml}ml\n \n ))}\n

\n\n {/* Custom Amount */}\n

\n setCustomMl(e.target.value)}\n className=\"flex-1 px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n Add\n \n

💡 1g of water = 1ml — so 500g on the scale is 500ml

\n\n {/* Today's Logs */}\n

Today's Logs

\n {todayData?.logs && todayData.logs.length > 0 ? (\n

\n {todayData.logs.map((log) => (\n \n

\n {log.milliliters}ml\n

\n {new Date(log.timestamp).toLocaleTimeString()} · {log.source}\n

\n handleDeleteLog(log.id)}\n className=\"text-red-500 hover:text-red-700 text-sm font-medium ml-4\"\n >\n Delete\n \n

\n ))}\n

\n ) : (\n

No water logged yet today

\n )}\n

\n \n )}\n\n {/* History Tab */}\n {activeTab === \"history\" && (\n

Last 7 Days

\n {history.length > 0 ? (() => {\n const maxTotal = Math.max(...history.map((d) => d.total), WATER_CONFIG.DAILY_TARGET_ML);\n const chartData = [...history].reverse();\n return (\n

\n {chartData.map((entry, i) => {\n const barHeight = maxTotal > 0 ? (entry.total / maxTotal) * 100 : 0;\n const metGoal = entry.percentage >= 100;\n const dayLabel = new Date(entry.date + \"T00:00:00\").toLocaleDateString(undefined, { weekday: \"short\", day: \"numeric\" });\n return (\n

{entry.total}ml

{dayLabel}

\n );\n })}\n

\n );\n })() : (\n

No history yet

\n )}\n {history.length > 0 && (\n

\n \n \n Below goal\n \n \n \n Goal met\n \n

\n )}\n \n )}\n\n {/* NFC Devices Tab */}\n {activeTab === \"nfc\" && (\n

\n {/* Add New NFC Device */}\n

Add NFC Device

\n Create a tap link to write to your NFC tag. Tapping the tag will log water automatically — no sign-in needed.\n

\n setNewNfcName(e.target.value)}\n placeholder=\"Device name (e.g. Water Bottle)\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n setNewNfcMl(e.target.value)}\n placeholder=\"ml per tap\"\n className=\"flex-1 px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n Create\n \n

\n {createdTapUrl && (\n

📋 Copy this link to your NFC tag:

\n \n {\n navigator.clipboard.writeText(createdTapUrl);\n showToast(\"Link copied!\", \"success\");\n }}\n className=\"bg-blue-500 hover:bg-blue-600 text-white px-4 py-2 rounded-lg text-sm font-medium whitespace-nowrap\"\n >\n Copy\n \n

\n setCreatedTapUrl(null)}\n className=\"mt-2 text-xs text-gray-500 underline\"\n >\n Dismiss\n \n

\n )}\n

\n\n {/* Device List */}\n

Your Devices

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

\n {nfcDevices.map((device) => {\n const tapUrl = `${location.origin}/api/nfc/tap/${device.token}`;\n return (\n

{device.name}

{device.milliliters}ml per tap

\n {/* Copy tap link */}\n

\n \n {\n navigator.clipboard.writeText(tapUrl);\n showToast(\"Link copied!\", \"success\");\n }}\n className=\"bg-gray-200 hover:bg-gray-300 text-gray-700 px-3 py-1.5 rounded text-xs font-medium whitespace-nowrap\"\n >\n Copy\n \n

\n {/* Edit amount */}\n {editingDeviceId === device.id ? (\n

\n setEditMl(e.target.value)}\n placeholder=\"ml\"\n className=\"w-24 px-3 py-1.5 text-sm border border-gray-300 rounded-lg\"\n />\n handleUpdateDeviceMl(device.id)}\n className=\"bg-emerald-500 hover:bg-emerald-600 text-white px-3 py-1.5 rounded-lg text-sm font-medium\"\n >\n Save\n \n setEditingDeviceId(null)}\n className=\"text-gray-500 text-sm px-2\"\n >\n Cancel\n \n

\n ) : (\n

\n {\n setEditingDeviceId(device.id);\n setEditMl(String(device.milliliters));\n }}\n className=\"text-blue-500 hover:text-blue-700 text-sm font-medium\"\n >\n Edit amount\n \n handleDeleteDevice(device.id)}\n className=\"text-red-500 hover:text-red-700 text-sm font-medium\"\n >\n Delete\n \n

\n )}\n

\n );\n })}\n

\n ) : (\n

No NFC devices yet. Create one above!

\n )}\n

\n )}\n \n \n );\n}\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[121,134],"8d9d75b35a03cfdcfdb920e9fa02acca85c87e5580f9f3b8a24f32286ca3a264","27b28e1a-4fc7-11f1-9b2c-ee650bb23af1","019e27dc-78af-7579-998f-2918fa583259",["D",1778785220696],0,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[121,134],"427c45f5341ba32dd31e98a21e648a32637bfca120ebc165e98f9be62706370c","frontend/index.html",{"_32":160,"_13":153,"_82":161,"_84":124,"_85":33,"_86":116,"_87":26,"_34":162,"_40":145,"_90":117,"_92":163,"_65":48,"_94":-5,"_95":-7,"_75":164,"_97":165},{"_32":152,"_13":153,"_82":154,"_84":113,"_85":57,"_86":155,"_87":26,"_34":156,"_40":22,"_90":117,"_92":157,"_65":48,"_94":-5,"_95":-7,"_75":158,"_97":159},"6a8ead63-2143-44b4-a8f2-ad0deb9c066a","index.html","019f7461-6ee4-74b9-881f-cead947034b9",11,["D",1784364783086],"\n\n \n \n \n Water Intake Tracker\n \n \n \n \n \n

\n \n \n \n\n",[121,153],"780652afa750e4201a676bedad3d69744d56c8482f748c6c4795e1e940b96042","27b283ca-4fc7-11f1-9b2c-ee650bb23af1","019e27dc-78af-7579-998f-26e4840b304b",["D",1778785220696],"\n\n \n \n \n Better Auth Starter\n \n \n \n \n

\n \n \n \n",[121,153],"950256814050d59c7c25c87202496aeb3a150d3cf4deee1f3e9f10c25d039f3a","backend/schema.ts",{"_32":179,"_13":170,"_82":180,"_84":181,"_85":33,"_86":182,"_87":26,"_34":183,"_40":116,"_90":138,"_92":184,"_65":48,"_94":-5,"_95":-7,"_75":185,"_97":186},{"_32":169,"_13":170,"_82":171,"_84":172,"_85":57,"_86":173,"_87":26,"_34":174,"_40":116,"_90":138,"_92":175,"_65":48,"_94":-5,"_95":-7,"_75":176,"_97":177},"0bfc9a92-b5c7-41c8-8938-f5a2c3bfe4d7","schema.ts","019f7461-6ee4-74b9-881f-b2f15ed8bf7f","019f7461-6ee4-74b9-881f-b70bb89663dc",3,["D",1784364130522],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { DB_TABLES } from \"../config/constants.ts\";\n\n// Better Auth's standard SQLite schema for core auth + magic link.\n// Magic link uses the `verification` table — no extra plugin tables needed.\n//\n// We run this on startup so the template works with zero setup.\n// Better Auth manages all reads/writes via Kysely; we just ensure the tables exist.\nexport async function ensureSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS user (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n emailVerified INTEGER NOT NULL DEFAULT 0,\n image TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS session (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n expiresAt INTEGER NOT NULL,\n ipAddress TEXT,\n userAgent TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS account (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n accountId TEXT NOT NULL,\n providerId TEXT NOT NULL,\n accessToken TEXT,\n refreshToken TEXT,\n accessTokenExpiresAt INTEGER,\n refreshTokenExpiresAt INTEGER,\n scope TEXT,\n idToken TEXT,\n password TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS verification (\n id TEXT PRIMARY KEY,\n identifier TEXT NOT NULL,\n value TEXT NOT NULL,\n expiresAt INTEGER NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n // Water intake logs\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.WATER_LOGS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n timestamp INTEGER NOT NULL,\n milliliters INTEGER NOT NULL,\n source TEXT NOT NULL DEFAULT 'manual',\n createdAt INTEGER NOT NULL\n )`,\n // NFC device registration (stores ml amount per device)\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.NFC_DEVICES} (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n milliliters INTEGER NOT NULL DEFAULT 500,\n name TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n // NFC tokens for one-time tap registration\n `CREATE TABLE IF NOT EXISTS ${DB_TABLES.NFC_TOKENS} (\n token TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n createdAt INTEGER NOT NULL\n )`,\n ]);\n}\n",[178,170],"2a960d9b2fc1e150a44d6a2fc2702fe583be35f612af3bd41b6e303305f9a414","backend","8f03fa02-4fc9-11f1-aa6c-ee650bb23af1","019e27dc-78ae-75ec-8c7c-b02e616122d4","019e27dc-78ae-75ec-8c7c-b4a1298ab03b",6,["D",1778786253148],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Better Auth's standard SQLite schema for core auth + magic link.\n// Magic link uses the `verification` table — no extra plugin tables needed.\n//\n// We run this on startup so the template works with zero setup.\n// Better Auth manages all reads/writes via Kysely; we just ensure the tables exist.\nexport async function ensureSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS user (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n emailVerified INTEGER NOT NULL DEFAULT 0,\n image TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS session (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n expiresAt INTEGER NOT NULL,\n ipAddress TEXT,\n userAgent TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS account (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n accountId TEXT NOT NULL,\n providerId TEXT NOT NULL,\n accessToken TEXT,\n refreshToken TEXT,\n accessTokenExpiresAt INTEGER,\n refreshTokenExpiresAt INTEGER,\n scope TEXT,\n idToken TEXT,\n password TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS verification (\n id TEXT PRIMARY KEY,\n identifier TEXT NOT NULL,\n value TEXT NOT NULL,\n expiresAt INTEGER NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS pill_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n timestamp INTEGER NOT NULL,\n dose INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS nfc_tokens (\n token TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n createdAt INTEGER NOT NULL\n )`,\n ]);\n}",[178,170],"d51749d9cad18de910f169df1e907722a51d7726c1a2c4a314fa98895a81a625","README.md",{"_32":197,"_13":187,"_82":198,"_84":-5,"_85":33,"_86":116,"_87":48,"_34":199,"_40":145,"_90":117,"_92":200,"_65":48,"_94":-5,"_95":-7,"_75":201,"_97":202},{"_32":190,"_13":187,"_82":191,"_84":-5,"_85":57,"_86":192,"_87":26,"_34":193,"_40":116,"_90":117,"_92":194,"_65":48,"_94":-5,"_95":-7,"_75":195,"_97":196},"4e09f6e7-fb9f-471d-b2c7-5f56ddebe291","019f7461-6ee4-74b9-881f-dcc6c26efd2c",8,["D",1784364219802],"# 💧 Water Intake Tracker\n\nA modern web app to track your daily water intake with a 2L daily goal. Features manual logging, NFC device registration for quick taps, and automatic daily reset at 5 AM UTC.\n\n## Features\n\n- ✅ **Daily Goal Tracking** - Visual progress bar towards 2L daily target\n- 📱 **Quick Add Buttons** - Log common amounts (250ml, 500ml, 750ml, 1L) with one tap\n- 🎯 **Custom Amount** - Add any custom amount you drank\n- 🏷️ **Water Log History** - View all today's entries with timestamps\n- 📴 **NFC Integration** - Register NFC devices/tags that auto-log water on tap\n- 🔄 **Daily Reset** - Automatic reset at 5 AM UTC each day\n- 🔐 **Authentication** - Magic link sign-in via Better Auth\n- 📊 **Stats** - Track your water intake over time\n\n## Architecture\n\n```\n├── config/\n│ └── constants.ts # All configuration constants in one place\n├── backend/\n│ ├── schema.ts # SQLite schema with water & NFC tables\n│ ├── water-utils.ts # Utility functions for water tracking\n│ └── auth.ts # Better Auth configuration\n├── frontend/\n│ ├── index.html # Main HTML template\n│ └── index.tsx # React app with tab-based UI\n└── index.ts # Hono API server with all endpoints\n```\n\n## Configuration\n\nAll constants are defined in `config/constants.ts`:\n\n```typescript\nexport const WATER_CONFIG = {\n DAILY_TARGET_ML: 2000, // Change daily goal here (in ml)\n RESET_HOUR_UTC: 5, // Change reset time here (UTC)\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n MIN_ML_PER_TAP: 100, // Minimum per NFC tap\n MAX_ML_PER_TAP: 1000, // Maximum per NFC tap\n DEFAULT_ML_PER_TAP: 500, // Default amount for new NFC devices\n};\n```\n\n## API Endpoints\n\n### Water Tracking\n\n- `POST /api/water/log` - Log water intake\n ```json\n { \"milliliters\": 500, \"source\": \"manual\" }\n ```\n\n- `GET /api/water/today` - Get today's intake and logs\n- `GET /api/water/history?days=7` - Get intake history\n- `DELETE /api/water/:id` - Delete a log entry\n\n### NFC Devices\n\n- `POST /api/nfc/register` - Start NFC device registration (returns registration URL)\n- `POST /api/nfc/device` - Complete NFC device registration\n- `GET /api/nfc/devices` - Get user's registered NFC devices\n- `PATCH /api/nfc/device/:id` - Update device settings\n- `DELETE /api/nfc/device/:id` - Delete a device\n- `GET /api/nfc/tap/:token` - NFC tap endpoint (logs water automatically)\n\n## How NFC Works\n\n1. **Register Device**\n - Click \"Start Registration\" in NFC Devices tab\n - A QR code is generated with a registration URL\n - Share/scan the QR with your NFC device/app\n\n2. **Complete Registration**\n - When the device scans the link, you specify the water amount (default 500ml)\n - Device is saved and ready to use\n\n3. **Log Water**\n - Each tap of the registered NFC device logs water automatically\n - Shows success page with logged amount\n\n## Database Schema\n\n### water_logs\n- `id` - Auto-increment primary key\n- `userId` - User who logged the water\n- `timestamp` - When water was logged\n- `milliliters` - Amount of water (in ml)\n- `source` - \"manual\" or \"nfc\"\n- `createdAt` - Record creation time\n\n### nfc_devices\n- `id` - Device UUID\n- `userId` - Owner of the device\n- `token` - Unique tap token\n- `milliliters` - Amount logged per tap\n- `name` - Device name\n- `createdAt` - When registered\n- `updatedAt` - Last update time\n\n### nfc_tokens\n- `token` - Registration token (UUID)\n- `userId` - User registering the device\n- `createdAt` - Token creation time\n\n## Daily Reset\n\nThe app automatically treats the day as starting at **5 AM UTC** and ending at the next 5 AM UTC. This is calculated server-side in `getTodayStartTime()` so it works regardless of user timezone.\n\nTo change the reset time, edit `RESET_HOUR_UTC` in `config/constants.ts`.\n\n## Usage\n\n1. Sign in with magic link\n2. Click quick-add buttons or enter custom amount\n3. Watch your progress bar fill up\n4. Optionally register NFC devices for one-tap logging\n5. Check history anytime\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript)\n- **Database**: SQLite with Val Town blob storage\n- **Frontend**: React with Twind CSS\n- **Auth**: Better Auth with magic links\n- **Runtime**: Deno on Val Town\n",[187],"c59e6fcac5701d0bda3bdfabf7c1574f8ccf68e5271c08c34c41845ae4a29ab8","27b29324-4fc7-11f1-9b2c-ee650bb23af1","019e27dc-78af-7579-998f-3071548ef2e9",["D",1778785220696],"# Better Auth Starter\n\nMagic-link authentication for Val Town, powered by\n[Better Auth](https://better-auth.com). Click **Remix** and you have a working\nauth-protected app — no setup required.\n\nIt uses [Val Town SQLite](https://docs.val.town/std/sqlite/) for the user/session\ndatabase and [Val Town Email](https://docs.val.town/std/email/) to send the\nmagic links. **Sending magic links to anyone other than yourself requires\n[Val Town Pro](https://www.val.town/pricing).**\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Browser -->|\"/api/auth/*\"| BA[\"Better Auth
handler\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|useSession| Client[\"auth-client.ts\"]\n Client -->|fetch| BA\n BA -->|reads/writes| SQLite[(\"std/sqlite\")]\n BA -->|sends magic link| Email[\"std/email\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono entrypoint; mounts Better Auth at /api/auth/*\nbackend/\n auth.ts ← Better Auth instance (server)\n schema.ts ← Creates the user/session/account/verification tables\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n lib/\n auth-client.ts ← Better Auth React client (useSession, signIn, signOut)\n components/\n App.tsx ← Root: shows or based on session\n SignIn.tsx ← Email form that calls signIn.magicLink\n Dashboard.tsx ← Signed-in view with sign-out button\n```\n\n## How auth works\n\n1. User enters their email and submits the form. The client calls\n `authClient.signIn.magicLink({ email })`, which `POST`s to\n `/api/auth/sign-in/magic-link`.\n2. Better Auth generates a token, stores it in the `verification` table, and\n calls our `sendMagicLink` callback in `backend/auth.ts`. The callback uses\n `std/email` to send the link.\n3. User clicks the link, which opens\n `/api/auth/magic-link/verify?token=…`. Better Auth validates the token,\n creates a row in `session`, sets a secure cookie, and redirects to `/`.\n4. Back in React, `useSession()` re-fetches `/api/auth/get-session`, the user\n object becomes available, and `` renders ``.\n\n## Adding more auth methods\n\nBetter Auth has a rich\n[plugin ecosystem](https://better-auth.com/docs/plugins). Common next steps:\n\n- **Email + password** — flip `emailAndPassword.enabled` to `true` in\n `backend/auth.ts`. No plugin needed.\n- **Social login (Google, GitHub, …)** — add `socialProviders` to your auth\n config and store the client IDs/secrets as env vars. See the\n [social providers docs](https://better-auth.com/docs/concepts/social-providers).\n- **Passkeys, 2FA, organizations** — add the relevant plugin on the server and\n the matching client plugin in `frontend/lib/auth-client.ts`.\n\nAfter enabling new methods, you may need new database columns. See the\n[database concepts](https://better-auth.com/docs/concepts/database) page — for\nSQLite you'll add the columns directly to `backend/schema.ts`.\n\n## Production checklist\n\n- [ ] Set the **`BETTER_AUTH_SECRET`** env var to a long random string\n (`openssl rand -base64 32`). Without it, sessions are signed with a\n val-derived default that's predictable.\n- [ ] Narrow `baseURL.allowedHosts` in `backend/auth.ts` to the exact hosts\n you serve from (e.g. `[\"myapp.com\", \"*.web.val.run\"]`).\n- [ ] Make sure your Val Town account is on\n [Pro](https://www.val.town/pricing) so emails can be sent to addresses\n other than your own.\n\n## Notes\n\n- The session cookie defaults to 7 days and refreshes itself.\n- Magic-link tokens expire after 5 minutes and are single-use by default.\n- Better Auth uses Kysely under the hood — Val Town's `std/sqlite` is already\n an `@libsql/client` Client, so we hand it straight to `LibsqlDialect`.\n Zero database setup.\n",[187],"6bd093c107075d2cf18435c18e7dd8a408b29fd8000fe9160a6ce9f7d3cb70d3",{"_75":223,"_77":-7,"_79":224},{"_75":217,"_77":-7,"_79":218},{"_75":206,"_77":-7,"_79":207},"config/constants.ts",{"_32":208,"_13":209,"_82":210,"_84":211,"_85":57,"_86":212,"_87":26,"_34":213,"_40":145,"_90":138,"_92":214,"_65":48,"_94":-5,"_95":-7,"_75":215,"_97":216},"87984f4a-7924-4ece-b136-58389137b02d","constants.ts","8d4135a2-8284-11f1-974b-1607ee4eb77e","1b54eaa7-101b-4278-9f64-0c227dfbb344",2,["D",1784364124194],"// Water intake tracking configuration\nexport const WATER_CONFIG = {\n // Daily target in milliliters (2 liters)\n DAILY_TARGET_ML: 2000,\n \n // Time in hours when daily intake resets (5 AM UTC)\n RESET_HOUR_UTC: 5,\n \n // Common water intake amounts (in ml) for quick add buttons\n QUICK_ADD_AMOUNTS: [250, 500, 750, 1000],\n \n // Minimum and maximum ml per NFC tap\n MIN_ML_PER_TAP: 100,\n MAX_ML_PER_TAP: 1000,\n \n // Default amount per NFC tap\n DEFAULT_ML_PER_TAP: 500,\n} as const;\n\n// UI Configuration\nexport const UI_CONFIG = {\n // Colors for progress visualization\n PROGRESS_COLORS: {\n EMPTY: \"#e5e7eb\", // gray-200\n PARTIAL: \"#3b82f6\", // blue-500\n FULL: \"#10b981\", // emerald-500\n OVER: \"#8b5cf6\", // violet-500\n },\n \n // Toast/notification durations (in ms)\n TOAST_DURATION: 3000,\n} as const;\n\n// Database table names\nexport const DB_TABLES = {\n USER: \"user\",\n SESSION: \"session\",\n ACCOUNT: \"account\",\n VERIFICATION: \"verification\",\n WATER_LOGS: \"water_logs\",\n NFC_TOKENS: \"nfc_tokens\",\n NFC_DEVICES: \"nfc_devices\",\n} as const;\n",[217,209],"8e164bd0251ee8256a2c501ad60d303dfcb722f5467c2e110e30383b9c5ada1f","config",{"_32":219,"_13":217,"_82":211,"_84":-5,"_85":57,"_86":212,"_87":26,"_34":220,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_95":-7,"_75":222,"_97":-5},"923e0a26-76cd-4e0c-942a-5ed9cb2fc009",["D",1784364124194],"directory",[217],"backend/water-utils.ts",{"_32":225,"_13":226,"_82":227,"_84":172,"_85":57,"_86":22,"_87":26,"_34":228,"_40":145,"_90":138,"_92":229,"_65":48,"_94":-5,"_95":-7,"_75":230,"_97":231},"1e7f8849-6668-44c0-8578-60014cfbac62","water-utils.ts","95283716-8284-11f1-887b-1607ee4eb77e",["D",1784364137484],"import { WATER_CONFIG } from \"../config/constants.ts\";\n\n/**\n * Get today's start time based on the reset hour (5 AM UTC)\n */\nexport function getTodayStartTime(): number {\n const now = new Date();\n const todayStart = new Date(now);\n todayStart.setUTCHours(WATER_CONFIG.RESET_HOUR_UTC, 0, 0, 0);\n\n // If we haven't reached 5 AM yet today, yesterday's 5 AM is the start\n if (todayStart.getTime() > now.getTime()) {\n todayStart.setUTCDate(todayStart.getUTCDate() - 1);\n }\n\n return todayStart.getTime();\n}\n\n/**\n * Get the end of today (tomorrow's reset time)\n */\nexport function getTodayEndTime(): number {\n return getTodayStartTime() + 24 * 60 * 60 * 1000;\n}\n\n/**\n * Check if a timestamp is in today's cycle\n */\nexport function isToday(timestamp: number): boolean {\n const start = getTodayStartTime();\n const end = getTodayEndTime();\n return timestamp >= start && timestamp < end;\n}\n\n/**\n * Format milliliters nicely (e.g., 500ml, 1.5L)\n */\nexport function formatWater(milliliters: number): string {\n if (milliliters >= 1000) {\n return `${(milliliters / 1000).toFixed(1)}L`;\n }\n return `${milliliters}ml`;\n}\n\n/**\n * Get color for progress bar based on percentage\n */\nexport function getProgressColor(percentage: number): string {\n if (percentage <= 0) return \"#e5e7eb\"; // empty - gray\n if (percentage < 100) return \"#3b82f6\"; // partial - blue\n if (percentage === 100) return \"#10b981\"; // full - emerald\n return \"#8b5cf6\"; // over - violet\n}\n\n/**\n * Calculate percentage of daily target\n */\nexport function getProgressPercentage(current: number): number {\n return Math.round((current / WATER_CONFIG.DAILY_TARGET_ML) * 100);\n}\n",[178,226],"4352f0f062a26db2a86479588b93a172a5698ba2bcb96a1b4f4c84ed71ec405a",["D",1784363970193],"legacyEnvVars","httpPrivacy","description","Pill tracking with nfc","imageUrl","userId","4916c367-34d7-4626-831b-3f6757372618","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","05a2eeb66ece4e729c1d51525ad38d73","tursoHostname","05a2eeb66ece4e729c1d51525ad38d73-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525843977],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_272":268},"org",{"_11":12,"_266":-5,"_267":268,"_238":239,"_269":270,"_271":48},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yZXNwSGpZcU1ETG1xcW5YSDlBamxBdnYzb0oifQ","tier","pro","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":58,"_13":14,"_34":435,"_46":-5,"_233":48,"_49":50,"_234":50,"_235":236,"_237":-5,"_238":239,"_240":83,"_241":26,"_242":-5,"_243":-5,"_244":145,"_52":53,"_245":246,"_247":248,"_249":436,"_251":-5,"_252":253,"_254":253,"_255":256,"_257":256,"_258":256,"_259":253,"_260":253,"_261":437,"_263":438,"_265":439,"_47":48},"tree",[333,339,341,350,351,352],"files",[333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352],"counts",{"_323":145,"_324":116,"_325":116,"_326":327,"_328":329},"contents",[299,300,301,302,303,304],"upstreamProject",{"_32":39,"_13":55,"_235":236,"_237":-5,"_49":50,"_261":298},"upstreamBranch",{"_32":33,"_34":296,"_36":297,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":12,"_52":53,"_54":55},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1778785220696],["D",1788465404496],{"_11":12,"_272":268},{"_32":320,"_13":178,"_82":172,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":321,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_75":322},{"_32":219,"_13":217,"_82":211,"_84":-5,"_85":57,"_86":212,"_87":26,"_34":318,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_75":319},{"_32":315,"_13":121,"_82":113,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":316,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_75":317},{"_32":190,"_13":187,"_82":191,"_84":-5,"_85":57,"_86":192,"_87":26,"_34":313,"_40":116,"_90":117,"_92":194,"_65":48,"_94":-5,"_75":314},{"_32":81,"_13":76,"_82":83,"_84":-5,"_85":57,"_86":20,"_87":26,"_34":311,"_40":89,"_90":91,"_92":93,"_65":48,"_94":-5,"_75":312},{"_32":305,"_13":306,"_82":307,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":308,"_40":145,"_90":91,"_92":309,"_65":48,"_94":-5,"_75":310},"5a08602f-2e13-4a60-8f0f-02a2f48fc753","public-index.ts","019f7461-6ee4-74b9-881f-e64708a88cea",["D",1784363970193],"import { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono<{}>();\n\n// Public NFC endpoint\napp.get(\"/api/pill/track/:token\", async (c) => {\n const token = c.req.param(\"token\");\n\n const result = await sqlite.execute(\n \"SELECT userId FROM nfc_tokens WHERE token = ?\",\n [token],\n );\n\n if (result.rows.length === 0) {\n return c.html(\"

Invalid or expired token

\", 404);\n }\n\n const userId = result.rows[0].userId;\n\n await sqlite.execute(\n \"INSERT INTO pill_logs (userId, timestamp, dose) VALUES (?, ?, ?)\",\n [userId, Date.now(), 1],\n );\n\n // Redirect to success page\n return c.redirect(\"/success\", 303);\n});\n\n// Success page route\napp.get(\"/success\", () => {\n return serveFile(\"/frontend/success.html\");\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;",[306],["D",1784465027728],[76],["D",1784364219802],[187],"c23acb1e-6c97-496e-a850-6865b3317d86",["D",1784363970193],[121],["D",1784364124194],[217],"7a1a713a-cb84-4008-936d-3760d8860d1c",["D",1784363970193],[178],"pulls","branches","forks","envVars",{"_330":212,"_332":145},"connections",{"_330":145,"_331":145},"count","unfilledCount","emptyCount",{"_32":320,"_13":178,"_82":172,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":432,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_95":433,"_75":434},{"_32":425,"_13":426,"_82":427,"_84":172,"_85":57,"_86":116,"_87":26,"_34":428,"_40":145,"_90":138,"_92":429,"_65":48,"_94":-5,"_95":430,"_75":431},{"_32":418,"_13":419,"_82":420,"_84":172,"_85":57,"_86":116,"_87":26,"_34":421,"_40":145,"_90":138,"_92":422,"_65":48,"_94":-5,"_95":423,"_75":424},{"_32":411,"_13":412,"_82":413,"_84":172,"_85":57,"_86":116,"_87":26,"_34":414,"_40":145,"_90":138,"_92":415,"_65":48,"_94":-5,"_95":416,"_75":417},{"_32":169,"_13":170,"_82":171,"_84":172,"_85":57,"_86":173,"_87":26,"_34":174,"_40":116,"_90":138,"_92":175,"_65":48,"_94":-5,"_95":409,"_75":410},{"_32":225,"_13":226,"_82":227,"_84":172,"_85":57,"_86":22,"_87":26,"_34":228,"_40":145,"_90":138,"_92":229,"_65":48,"_94":-5,"_95":407,"_75":408},{"_32":219,"_13":217,"_82":211,"_84":-5,"_85":57,"_86":212,"_87":26,"_34":220,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_95":405,"_75":406},{"_32":208,"_13":209,"_82":210,"_84":211,"_85":57,"_86":212,"_87":26,"_34":213,"_40":145,"_90":138,"_92":214,"_65":48,"_94":-5,"_95":403,"_75":404},{"_32":315,"_13":121,"_82":113,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":400,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_95":401,"_75":402},{"_32":396,"_13":381,"_82":376,"_84":113,"_85":57,"_86":116,"_87":26,"_34":397,"_40":145,"_90":221,"_92":-5,"_65":48,"_94":-5,"_95":398,"_75":399},{"_32":389,"_13":390,"_82":391,"_84":376,"_85":57,"_86":116,"_87":26,"_34":392,"_40":145,"_90":138,"_92":393,"_65":48,"_94":-5,"_95":394,"_75":395},{"_32":382,"_13":383,"_82":384,"_84":376,"_85":57,"_86":116,"_87":26,"_34":385,"_40":145,"_90":138,"_92":386,"_65":48,"_94":-5,"_95":387,"_75":388},{"_32":373,"_13":374,"_82":375,"_84":376,"_85":57,"_86":116,"_87":26,"_34":377,"_40":145,"_90":138,"_92":378,"_65":48,"_94":-5,"_95":379,"_75":380},{"_32":366,"_13":367,"_82":368,"_84":113,"_85":57,"_86":116,"_87":26,"_34":369,"_40":145,"_90":117,"_92":370,"_65":48,"_94":-5,"_95":371,"_75":372},{"_32":152,"_13":153,"_82":154,"_84":113,"_85":57,"_86":155,"_87":26,"_34":156,"_40":22,"_90":117,"_92":157,"_65":48,"_94":-5,"_95":364,"_75":365},{"_32":133,"_13":134,"_82":135,"_84":113,"_85":57,"_86":56,"_87":26,"_34":136,"_40":137,"_90":138,"_92":139,"_65":48,"_94":-5,"_95":362,"_75":363},{"_32":110,"_13":111,"_82":112,"_84":113,"_85":57,"_86":114,"_87":26,"_34":115,"_40":116,"_90":117,"_92":118,"_65":48,"_94":-5,"_95":360,"_75":361},{"_32":190,"_13":187,"_82":191,"_84":-5,"_85":57,"_86":192,"_87":26,"_34":193,"_40":116,"_90":117,"_92":194,"_65":48,"_94":-5,"_95":358,"_75":359},{"_32":81,"_13":76,"_82":83,"_84":-5,"_85":57,"_86":20,"_87":26,"_34":88,"_40":89,"_90":91,"_92":93,"_65":48,"_94":-5,"_95":356,"_75":357},{"_32":305,"_13":306,"_82":307,"_84":-5,"_85":57,"_86":116,"_87":26,"_34":353,"_40":145,"_90":91,"_92":309,"_65":48,"_94":-5,"_95":354,"_75":355},["D",1784363970193],[],[306],[],[76],[],[187],[],[121,111],[],[121,134],[],[121,153],"77dc03e8-0545-4969-9c06-da01b16e33c5","favicon.svg","019f7461-6ee4-74b9-881f-cb6ca68ec92e",["D",1784363970193],"\n",[],[121,367],"1fcc92ae-1b8a-4983-a875-28451f9d4e88","SignIn.tsx","019f7461-6ee4-74b9-881f-c118079ae17b","019f7461-6ee4-74b9-881f-c6c8ab05dafe",["D",1784363970193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nexport function SignIn() {\n const [email, setEmail] = useState(\"\");\n const [status, setStatus] = useState<\"idle\" | \"sending\" | \"sent\" | \"error\">(\n \"idle\",\n );\n const [errorMsg, setErrorMsg] = useState(\"\");\n\n async function handleSubmit(e: React.FormEvent) {\n e.preventDefault();\n setStatus(\"sending\");\n setErrorMsg(\"\");\n const { error } = await authClient.signIn.magicLink({\n email,\n callbackURL: \"/\",\n });\n if (error) {\n setStatus(\"error\");\n setErrorMsg(error.message ?? \"Failed to send magic link\");\n } else {\n setStatus(\"sent\");\n }\n }\n\n if (status === \"sent\") {\n return (\n

📬 Check your email

\n We sent a sign-in link to {email}.\n

\n );\n }\n\n return (\n

\n \n Email\n setEmail((e.target as HTMLInputElement).value)}\n placeholder=\"you@example.com\"\n class=\"mt-1 block w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500 outline-none\"\n disabled={status === \"sending\"}\n />\n \n \n {status === \"sending\" ? \"Sending…\" : \"Send magic link\"}\n \n {status === \"error\" &&

{errorMsg}

}\n \n );\n}",[],[121,381,374],"components","5ec82147-a1d2-4fcf-b744-8d02b3351754","Dashboard.tsx","019f7461-6ee4-74b9-881f-be99887fb92e",["D",1784363970193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\ntype User = {\n id: string;\n email: string;\n name: string;\n image?: string | null;\n};\n\ntype PillLog = {\n id: number;\n timestamp: number;\n dose: number;\n};\n\nexport function Dashboard({ user }: { user: User }) {\n const [logs, setLogs] = useState([]);\n const [nfcUrl, setNfcUrl] = useState(null);\n const [loading, setLoading] = useState(true);\n const [showLogging, setShowLogging] = useState(false);\n\n const fetchStats = async () => {\n try {\n const res = await fetch(\"/api/pill/stats\");\n const data = await res.json();\n setLogs(data.logs || []);\n } catch (e) {\n console.error(\"Failed to fetch stats\", e);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchStats();\n const interval = setInterval(fetchStats, 60000);\n return () => clearInterval(interval);\n }, []);\n\n const logPill = async (dose: number) => {\n await fetch(\"/api/pill/log\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ dose }),\n });\n fetchStats();\n };\n\n const generateNfcUrl = async () => {\n const res = await fetch(\"/api/pill/nfc-token\", { method: \"POST\" });\n const data = await res.json();\n setNfcUrl(data.url);\n };\n\n const lastPill = logs[0];\n const timeSinceLast = lastPill\n ? Math.floor((Date.now() - lastPill.timestamp) / (1000 * 60))\n : null;\n\n const formatTime = (minutes: number) => {\n const hrs = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hrs === 0) return `${mins}m`;\n return `${hrs}h ${mins}m`;\n };\n\n // Sunrise logic (6 AM)\n const getSunrise = (date: Date) => {\n const s = new Date(date);\n s.setHours(6, 0, 0, 0);\n return s;\n };\n\n const today = new Date();\n const currentSunrise = getSunrise(today);\n if (today < currentSunrise) {\n currentSunrise.setDate(currentSunrise.getDate() - 1);\n }\n const tookToday = logs.some((log) =>\n log.timestamp > currentSunrise.getTime()\n );\n\n // Consolidated History: Today (index 0) + 14 Past Days\n const history = Array.from({ length: 15 }, (_, i) => {\n const s = new Date(currentSunrise);\n s.setDate(s.getDate() - i);\n const nextS = new Date(s);\n nextS.setDate(s.getDate() + 1);\n\n const dayLogs = logs.filter((log) =>\n log.timestamp >= s.getTime() && log.timestamp < nextS.getTime()\n );\n return {\n date: s,\n doses: dayLogs.reduce((acc, log) => acc + log.dose, 0),\n isToday: i === 0,\n };\n });\n\n // Protection Logic - Last 7 Past Days (indices 1 to 7)\n const past7Days = history.slice(1, 8);\n const missedCount = past7Days.filter((d) => d.doses === 0).length;\n const activeDaysCount = past7Days.filter((d) => d.doses > 0).length;\n\n // Double dose catch-up rule\n let hasDoubleDoseCatchup = false;\n const doubleDoseDayIndex = past7Days.findIndex((d) => d.doses >= 2);\n if (doubleDoseDayIndex !== -1) {\n // Check if every day AFTER the most recent double dose has >= 1 dose\n const daysAfterDoubleDose = past7Days.slice(0, doubleDoseDayIndex);\n hasDoubleDoseCatchup = daysAfterDoubleDose.every((d) => d.doses >= 1);\n }\n\n const isVeryHigh = (missedCount <= 1) || hasDoubleDoseCatchup;\n const isHigh = activeDaysCount >= 4;\n\n const veryHighReason = missedCount === 0\n ? \"Perfect Adherence (Past 7 Days)\"\n : missedCount === 1\n ? \"Strong Adherence (6/7 Past Days)\"\n : hasDoubleDoseCatchup\n ? \"Recent Double Dose Catch-up\"\n : null;\n\n const maxCount = Math.max(...history.map((d) => d.doses), 1);\n const chartData = [...history].reverse();\n\n return (\n

\n \n \n

{tookToday ? \"Took today\" : \"Not yet taken\"}

\n\n {timeSinceLast !== null && (\n

Since last pill

{formatTime(timeSinceLast)}

\n )}\n

\n\n

Protection Status

\n {isVeryHigh\n ? \"🛡️ Very High Protection\"\n : isHigh\n ? \"🛡️ High Protection\"\n : \"⚠️ Low Protection\"}\n {isVeryHigh && veryHighReason && (\n {veryHighReason}\n )}\n

\n {isVeryHigh ? \"✓\" : \"○\"}\n

Very High Protection Standard

\n {missedCount <= 1\n ? `Met: ${7 - missedCount}/7 past days taken`\n : hasDoubleDoseCatchup\n ? \"Met: Double dose followed by perfect adherence\"\n : \"Unmet: Requires ≤ 1 miss in past 7 days\"}\n

\n {isHigh ? \"✓\" : \"○\"}\n

High Protection Standard

\n {activeDaysCount}/7 active past days ({isHigh\n ? \"Met\"\n : \"Requires ≥ 4\"})\n

\n\n

\n setShowLogging(!showLogging)}\n className=\"btn-outline flex items-center justify-between\"\n >\n {showLogging ? \"Hide Logging\" : \"Manual Logging\"}\n {showLogging ? \"▲\" : \"▼\"}\n \n\n {showLogging && (\n

\n \n \n

\n )}\n

\n\n

History (Last 14 Days + Today)

\n {chartData.map((day, i) => (\n

\n \n {day.doses > 0 && {day.doses}\n }\n {day.isToday && day.doses === 0 && (\n ?\n )}\n

\n \n {day.isToday ? \"T\" : day.date.getDate()}\n \n

\n ))}\n

\n\n

\n \n {nfcUrl && (\n

{nfcUrl}

\n navigator.clipboard.writeText(nfcUrl)}\n className=\"text-xs text-blue-500 underline mt-1\"\n >\n Copy URL\n \n

\n )}\n

\n\n

Signed in as {user.email}

\n authClient.signOut().then(() => location.reload())}\n className=\"text-xs text-red-500 underline\"\n >\n Sign out\n \n

\n\n \n \n );\n}",[],[121,381,383],"893c6f36-945d-4afd-9196-e86149935451","App.tsx","019f7461-6ee4-74b9-881f-b93717cadbff",["D",1784363970193],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { SignIn } from \"./SignIn.tsx\";\nimport { Dashboard } from \"./Dashboard.tsx\";\n\nimport { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\nconst authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nexport function App() {\n // Reactive session — updates automatically on sign in / sign out.\n const { data: session, isPending } = authClient.useSession();\n\n return (\n

Pill Tracker

\n Track your daily doses with ease.\n

\n\n {isPending\n ?

Loading…

\n : session?.user\n ? \n : }\n\n

\n View source\n

\n );\n}",[],[121,381,390],"6076284e-2296-4422-93f6-beec64ce481a",["D",1784363970193],[343,344,345],[121,381],["D",1784363970193],[342,346,347,348,349],[121],[],[217,209],[340],[217],[],[178,226],[],[178,170],"ec576171-e7a6-4217-888d-80eca159d8cb","schema-drizzle.ts","019f7461-6ee4-74b9-881f-acfcb46b90fd",["D",1784363970193],"import { integer, sqliteTable, text } from \"npm:drizzle-orm@0.45.2/sqlite-core\";\n\nexport const user = sqliteTable(\"user\", {\n id: text(\"id\").primaryKey(),\n name: text(\"name\").notNull(),\n email: text(\"email\").notNull().unique(),\n // Explicitly mapping the camelCase columns from your SQL\n emailVerified: integer(\"emailVerified\").notNull(),\n image: text(\"image\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n\nexport const session = sqliteTable(\"session\", {\n id: text(\"id\").primaryKey(),\n userId: text(\"userId\").notNull().references(() => user.id, {\n onDelete: \"cascade\",\n }),\n token: text(\"token\").notNull().unique(),\n // Explicitly matching your SQL column name here!\n expiresAt: integer(\"expiresAt\").notNull(),\n ipAddress: text(\"ipAddress\"),\n userAgent: text(\"userAgent\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n\nexport const account = sqliteTable(\"account\", {\n id: text(\"id\").primaryKey(),\n userId: text(\"userId\").notNull().references(() => user.id, {\n onDelete: \"cascade\",\n }),\n accountId: text(\"accountId\").notNull(),\n providerId: text(\"providerId\").notNull(),\n accessToken: text(\"accessToken\"),\n refreshToken: text(\"refreshToken\"),\n accessTokenExpiresAt: integer(\"accessTokenExpiresAt\"),\n refreshTokenExpiresAt: integer(\"refreshTokenExpiresAt\"),\n scope: text(\"scope\"),\n idToken: text(\"idToken\"),\n password: text(\"password\"),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\nexport const verification = sqliteTable(\"verification\", {\n id: text(\"id\").primaryKey(),\n identifier: text(\"identifier\").notNull(),\n value: text(\"value\").notNull(),\n expiresAt: integer(\"expiresAt\").notNull(),\n createdAt: integer(\"createdAt\").notNull(),\n updatedAt: integer(\"updatedAt\").notNull(),\n});\n",[],[178,412],"20e1fdd7-f528-481a-b80e-b651e4254523","drizzle.ts","019f7461-6ee4-74b9-881f-a9fc4aca20f6",["D",1784363970193],"import { drizzle } from \"npm:drizzle-orm@0.45.2/libsql/web\";\nimport { createClient } from \"npm:@libsql/client@0.17.4/web\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Export your clean, edge-safe database instance\nexport const db = drizzle({ client: sqlite });",[],[178,419],"711ebc6a-6d9b-4591-af6b-08aca8d4660c","auth.ts","019f7461-6ee3-75ce-ac8f-6422488024bb",["D",1784363970193],"import { email as sendEmail } from \"https://esm.town/v/std/email\";\nimport { httpEndpoint, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { betterAuth } from \"npm:better-auth@1.6.20\";\nimport { magicLink } from \"npm:better-auth@1.6.20/plugins\";\nimport { drizzleAdapter } from \"npm:@better-auth/drizzle-adapter@1.6.20\";\nimport { db } from \"./drizzle.ts\";\nimport * as authSchema from \"./schema-drizzle.ts\"; // Import the tables above\n\n// Vals can be reached from multiple URLs (the *.web.val.run preview URL,\n// custom domains, branch deploys, etc). Better Auth's dynamic baseURL form\n// derives the URL from each incoming request and validates it against\n// allowedHosts. The fallback is used when running outside an HTTP context\n// (e.g. cron jobs, scripts).\nconst fallback = await httpEndpoint();\n\n// A secret is required to sign session tokens. We default to a per-val auto\n// secret so the template works with zero setup — but for production you should\n// set BETTER_AUTH_SECRET so sessions survive code edits across val versions.\nconst { username, name } = parseVal();\nconst secret = Deno.env.get(\"BETTER_AUTH_SECRET\") ??\n `val-town-default-${username}-${name}`;\n\nconst validEmail = Deno.env.get(\"EMAIL\");\n\n// Val Town's `std/sqlite` is already an `@libsql/client` Client,\n// so we can hand it straight to Better Auth's Kysely libsql dialect.\n// Zero database setup required.\nexport const auth = betterAuth({\n baseURL: {\n // Accept any host so this works on the *.web.val.run preview URL,\n // custom domains, and any future deployment URL. For production you\n // should narrow this to the specific hosts you serve from, e.g.\n // [\"myapp.com\", \"*.web.val.run\"].\n allowedHosts: [\"*.web.val.run\"],\n protocol: \"auto\",\n fallback,\n },\n secret,\n database: drizzleAdapter(db, {\n provider: \"sqlite\",\n schema: authSchema,\n }),\n // Disable email+password — this template is magic link only.\n emailAndPassword: { enabled: false },\n plugins: [\n magicLink({\n sendMagicLink: async ({ email, url }) => {\n await sendEmail({\n subject: \"Your sign-in link\",\n text: `Click to sign in: ${url}\\n\\nThis link expires in 5 minutes.`,\n html: `

Click to sign in:

` +\n `

${url}

` +\n `

This link expires in 5 minutes.

`,\n });\n },\n }),\n ],\n});",[],[178,426],["D",1784363970193],[334,335,336,337,338],[178],["D",1784363970193],["D",1789525843977],{"_11":12,"_272":268},{"_11":12,"_266":-5,"_267":268,"_238":239,"_269":270,"_271":48},{"_40":56,"_13":16,"_32":57,"_38":58,"_42":33,"_43":59,"_60":50,"_61":39,"_62":53,"_54":14,"_51":12},"ctx",{"_261":-5,"_293":473,"_474":475,"_476":477,"_478":48,"_479":48,"_480":48,"_481":26,"_482":-5,"_483":-7,"_484":-7,"_485":145,"_486":48,"_487":48,"_488":-5,"_489":48,"_490":48,"_491":48,"_492":-5},"ENV",{"_444":445,"_446":447,"_448":16,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Compare

Mergewater-intake/mainintopill-tracker/main

README.md+108-74

backend/schema.ts+19-4

frontend/index.html+17-3

frontend/index.tsx+645-5

frontend/success.html+22-31

Hindex.ts+245-22

backend/water-utils.ts+60-0

config

config/constants.ts+43-0