[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","TPM","name","MITAA26-Registration","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":12,"_53":-5,"_54":55,"_56":-5,"_57":42,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/TPM/MITAA26-Registration/code/main.ts","extension","id","6350e165-8081-451e-be79-7e67228b333c","fileId","fc415822-a879-11f1-afec-1607ee4eb77e","parentId","branchId","2f1c570f-2cc9-4aa2-a410-f404a8ab6548","branchVersion",2,"latest",true,"createdAt",["D",1788537742207],"version",1,"fileType","script","content","/**\n * MITAA check-in — photo of the nametag checks the person in.\n *\n * Usher taps the camera button, photographs one or more badges, and the app\n * reads the names, matches them against the participant list and marks them\n * attended. Confident matches commit with no further taps. Anything unclear\n * falls back to a picker, and there is always a type-to-search escape hatch.\n *\n * Setup\n * 1. Create the val, paste this in as main.ts.\n * 2. Env vars: ANTHROPIC_API_KEY (vision)\n * ADMIN_KEY (any long random string)\n * 3. Open /admin?k=ADMIN_KEY and paste the participants tab as TSV.\n * 4. Give each usher /?s=their-name\n *\n * Check-ins live in Val Town SQLite, not in Google Sheets. Nothing on the\n * critical path talks to Google, so the desk keeps working if Google is slow.\n * Export CSV afterwards and paste it back into the Sheet.\n */\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst MODEL = \"claude-sonnet-4-6\";\n\n/** Auto-commit only above this score, and only if the runner-up is clearly behind. */\nconst AUTO_MIN = 0.86;\nconst AUTO_GAP = 0.14;\n\nconst HONORIFICS = [\n \"TAN SRI\",\n \"PUAN SRI\",\n \"DATO SERI\",\n \"DATUK SERI\",\n \"DATIN SERI\",\n \"DATO\",\n \"DATUK\",\n \"DATIN\",\n \"TOH PUAN\",\n \"PROF DR\",\n \"PROF\",\n \"DR\",\n \"MR\",\n \"MRS\",\n \"MS\",\n \"MDM\",\n \"MADAM\",\n \"ENCIK\",\n \"EN\",\n \"PUAN\",\n \"PN\",\n \"IR\",\n \"AR\",\n];\n\n// ---------------------------------------------------------------- schema\n\nasync function init() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS mitaa_people (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sheet_row INTEGER,\n name TEXT NOT NULL,\n norm TEXT NOT NULL,\n email TEXT,\n org TEXT,\n ptype TEXT,\n status TEXT DEFAULT '',\n checked_at TEXT,\n checked_by TEXT\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS mitaa_audit (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts TEXT, person_id INTEGER, name TEXT,\n action TEXT, staff TEXT, prev TEXT, note TEXT\n )`);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS mitaa_norm_idx ON mitaa_people(norm)`,\n );\n}\n\n// ---------------------------------------------------------------- matching\n\n/** Strip honorifics, punctuation and case so \"DATO SERI DR. AMY LIM\" ≈ \"Amy Lim\". */\nfunction normalise(raw: string): string {\n let s = (raw || \"\").toUpperCase();\n s = s.replace(/\\bA\\s*\\/\\s*[LP]\\b/g, \" \\u0001 \"); // protect A/L, A/P\n s = s.replace(/[^A-Z0-9\\u0001 ]+/g, \" \");\n s = s.replace(/\\s+/g, \" \").trim();\n let changed = true;\n while (changed) {\n changed = false;\n for (const h of HONORIFICS) {\n if (s === h) continue;\n if (s.startsWith(h + \" \")) {\n s = s.slice(h.length + 1);\n changed = true;\n break;\n }\n }\n }\n return s.replace(/\\u0001/g, \"A/L\").replace(/\\s+/g, \" \").trim();\n}\n\nfunction tokens(s: string): string[] {\n return s.split(\" \").filter(Boolean);\n}\n\n/**\n * 0–1 similarity. Rewards full token containment, which is what actually\n * happens here: badges carry honorifics or drop a middle name.\n */\nfunction score(a: string, b: string): number {\n if (!a || !b) return 0;\n if (a === b) return 1;\n const A = tokens(a), B = tokens(b);\n const setA = new Set(A), setB = new Set(B);\n let shared = 0;\n for (const t of setA) if (setB.has(t)) shared++;\n const small = Math.min(setA.size, setB.size);\n const large = Math.max(setA.size, setB.size);\n if (shared === 0) return charSim(a, b) * 0.55;\n // every token of the shorter name present in the longer one\n if (shared === small) {\n return small === large ? 1 : 0.82 + 0.12 * (small / large);\n }\n return (shared / large) * 0.8;\n}\n\n/** Cheap fallback for OCR slips: shared bigram ratio. */\nfunction charSim(a: string, b: string): number {\n const grams = (s: string) => {\n const g = new Set();\n const t = s.replace(/ /g, \"\");\n for (let i = 0; i < t.length - 1; i++) g.add(t.slice(i, i + 2));\n return g;\n };\n const ga = grams(a), gb = grams(b);\n if (!ga.size || !gb.size) return 0;\n let shared = 0;\n for (const g of ga) if (gb.has(g)) shared++;\n return (2 * shared) / (ga.size + gb.size);\n}\n\ntype Person = {\n id: number;\n sheet_row: number;\n name: string;\n norm: string;\n email: string;\n org: string;\n ptype: string;\n status: string;\n checked_at: string;\n checked_by: string;\n};\n\nasync function allPeople(): Promise {\n const r = await sqlite.execute(\n `SELECT id, sheet_row, name, norm, email, org, ptype, status, checked_at, checked_by\n FROM mitaa_people`,\n );\n return r.rows.map((row: any) => ({\n id: row[0],\n sheet_row: row[1],\n name: row[2],\n norm: row[3],\n email: row[4] || \"\",\n org: row[5] || \"\",\n ptype: row[6] || \"\",\n status: row[7] || \"\",\n checked_at: row[8] || \"\",\n checked_by: row[9] || \"\",\n }));\n}\n\nfunction rank(readName: string, people: Person[]) {\n const n = normalise(readName);\n return people\n .map((p) => ({ p, s: score(n, p.norm) }))\n .sort((x, y) => y.s - x.s)\n .slice(0, 5);\n}\n\n// ---------------------------------------------------------------- vision\n\nasync function readBadges(dataUrl: string): Promise {\n const key = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!key) throw new Error(\"ANTHROPIC_API_KEY is not set on this val\");\n const m = dataUrl.match(/^data:(image\\/[a-z+]+);base64,(.+)$/);\n if (!m) throw new Error(\"Photo was not readable\");\n\n const res = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"content-type\": \"application/json\",\n \"x-api-key\": key,\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: MODEL,\n max_tokens: 500,\n messages: [{\n role: \"user\",\n content: [\n {\n type: \"image\",\n source: { type: \"base64\", media_type: m[1], data: m[2] },\n },\n {\n type: \"text\",\n text:\n \"These are engraved metal name badges. Read the personal name on \" +\n \"each badge — the name in the inset panel, not the association name \" +\n \"in the logo. Include any honorific exactly as engraved. Ignore \" +\n \"badges that are blurred, cut off at the edge, or unreadable through \" +\n \"glare rather than guessing. Reply with only a JSON array of strings, \" +\n 'e.g. [\"CHONG MEI MEI\",\"DATO SERI DR AMY LIM\"]. Reply [] if none are legible.',\n },\n ],\n }],\n }),\n });\n\n if (!res.ok) throw new Error(`Vision call failed (${res.status})`);\n const data = await res.json();\n const text = (data.content || [])\n .filter((c: any) => c.type === \"text\").map((c: any) => c.text).join(\"\");\n const arr = text.match(/\\[[\\s\\S]*\\]/);\n if (!arr) return [];\n try {\n const parsed = JSON.parse(arr[0]);\n return Array.isArray(parsed)\n ? parsed.filter((x) => typeof x === \"string\" && x.trim()).slice(0, 12)\n : [];\n } catch {\n return [];\n }\n}\n\n// ---------------------------------------------------------------- actions\n\nasync function commit(p: Person, staff: string, note: string) {\n const now = new Date().toISOString();\n await sqlite.execute({\n sql:\n `UPDATE mitaa_people SET status='Checked In', checked_at=?, checked_by=?\n WHERE id=?`,\n args: [now, staff, p.id],\n });\n await sqlite.execute({\n sql: `INSERT INTO mitaa_audit (ts,person_id,name,action,staff,prev,note)\n VALUES (?,?,?,?,?,?,?)`,\n args: [now, p.id, p.name, \"check-in\", staff, p.status || \"\", note],\n });\n}\n\nasync function undo(id: number, staff: string) {\n const people = await allPeople();\n const p = people.find((x) => x.id === id);\n if (!p) return;\n await sqlite.execute({\n sql: `UPDATE mitaa_people SET status='', checked_at=NULL, checked_by=NULL\n WHERE id=?`,\n args: [id],\n });\n await sqlite.execute({\n sql: `INSERT INTO mitaa_audit (ts,person_id,name,action,staff,prev,note)\n VALUES (?,?,?,?,?,?,?)`,\n args: [new Date().toISOString(), id, p.name, \"undo\", staff, p.status, \"\"],\n });\n}\n\nasync function counts() {\n const r = await sqlite.execute(\n `SELECT COUNT(*), SUM(CASE WHEN status='Checked In' THEN 1 ELSE 0 END)\n FROM mitaa_people`,\n );\n return {\n total: Number(r.rows[0][0] || 0),\n inCount: Number(r.rows[0][1] || 0),\n };\n}\n\nconst esc = (s: string) =>\n String(s ?? \"\").replace(\n /[&<>\"']/g,\n (\n c,\n ) => ({\n \"&\": \"&\",\n \"<\": \"<\",\n \">\": \">\",\n '\"': \""\",\n \"'\": \"'\",\n }[c]!),\n );\n\n// ---------------------------------------------------------------- server\n\nexport default async function (req: Request): Promise {\n await init();\n const url = new URL(req.url);\n const path = url.pathname;\n const adminKey = Deno.env.get(\"ADMIN_KEY\") || \"\";\n const isAdmin = adminKey && url.searchParams.get(\"k\") === adminKey;\n const json = (o: unknown, status = 200) =>\n new Response(JSON.stringify(o), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n\n // ---- usher screen\n if (path === \"/\") {\n const staff = url.searchParams.get(\"s\") || \"\";\n return new Response(usherPage(staff), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (path === \"/counts\") return json(await counts());\n\n // ---- photo in, decisions out\n if (path === \"/scan\" && req.method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n const staff = String(body.staff || \"\").slice(0, 40) || \"unknown\";\n if (!body.image) return json({ error: \"No photo received\" }, 400);\n\n let names: string[];\n try {\n names = await readBadges(String(body.image));\n } catch (e) {\n return json({ error: (e as Error).message }, 502);\n }\n if (!names.length) {\n return json({\n results: [],\n error:\n \"No badge name was legible. Try again closer, or search by name.\",\n });\n }\n\n const people = await allPeople();\n const results = [];\n for (const readName of names) {\n const top = rank(readName, people);\n const best = top[0];\n const second = top[1];\n if (!best || best.s < 0.45) {\n results.push({ read: readName, state: \"nomatch\", options: [] });\n continue;\n }\n const clear = best.s >= AUTO_MIN &&\n (!second || best.s - second.s >= AUTO_GAP);\n if (clear) {\n if (best.p.status === \"Checked In\") {\n results.push({\n read: readName,\n state: \"already\",\n person: slim(best.p),\n at: best.p.checked_at,\n by: best.p.checked_by,\n });\n } else {\n await commit(best.p, staff, `photo:${readName}`);\n results.push({ read: readName, state: \"in\", person: slim(best.p) });\n }\n } else {\n results.push({\n read: readName,\n state: \"choose\",\n options: top.filter((t) => t.s >= 0.4).map((t) => ({\n ...slim(t.p),\n score: Math.round(t.s * 100),\n already: t.p.status === \"Checked In\",\n })),\n });\n }\n }\n return json({ results, ...(await counts()) });\n }\n\n // ---- manual pick / search result / walk-in confirm\n if (path === \"/confirm\" && req.method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n const staff = String(body.staff || \"\").slice(0, 40) || \"unknown\";\n const people = await allPeople();\n const p = people.find((x) => x.id === Number(body.id));\n if (!p) return json({ error: \"Not found\" }, 404);\n if (p.status === \"Checked In\") {\n return json({\n state: \"already\",\n person: slim(p),\n at: p.checked_at,\n by: p.checked_by,\n ...(await counts()),\n });\n }\n await commit(p, staff, String(body.note || \"manual\"));\n return json({ state: \"in\", person: slim(p), ...(await counts()) });\n }\n\n if (path === \"/undo\" && req.method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n await undo(Number(body.id), String(body.staff || \"unknown\").slice(0, 40));\n return json({ ok: true, ...(await counts()) });\n }\n\n // ---- always-available fallback\n if (path === \"/search\") {\n const q = normalise(url.searchParams.get(\"q\") || \"\");\n if (q.length < 2) return json({ items: [] });\n const people = await allPeople();\n const items = people\n .map((p) => ({\n p,\n s: p.norm.includes(q) ? 0.9 : score(q, p.norm),\n }))\n .filter((x) => x.s >= 0.45)\n .sort((a, b) => b.s - a.s)\n .slice(0, 8)\n .map((x) => ({ ...slim(x.p), already: x.p.status === \"Checked In\" }));\n return json({ items });\n }\n\n if (path === \"/recent\") {\n const staff = url.searchParams.get(\"s\") || \"\";\n const r = await sqlite.execute({\n sql: `SELECT person_id, name, ts FROM mitaa_audit\n WHERE action='check-in' AND staff=? ORDER BY id DESC LIMIT 8`,\n args: [staff],\n });\n return json({\n items: r.rows.map((x: any) => ({ id: x[0], name: x[1], ts: x[2] })),\n });\n }\n\n // ---- admin\n if (path === \"/admin\") {\n if (!isAdmin) return new Response(\"Not found\", { status: 404 });\n const c = await counts();\n return new Response(adminPage(c.total, c.inCount, adminKey), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (path === \"/admin/seed\" && req.method === \"POST\") {\n if (!isAdmin) return json({ error: \"no\" }, 404);\n const body = await req.json().catch(() => ({}));\n const rows = String(body.tsv || \"\").split(\"\\n\").map((l) => l.split(\"\\t\"));\n let n = 0, startRow = 2;\n if (rows.length && /full\\s*name/i.test(rows[0][0] || \"\")) rows.shift();\n if (!body.keep) {\n await sqlite.execute(`DELETE FROM mitaa_people`);\n }\n for (const cols of rows) {\n const name = (cols[0] || \"\").trim();\n if (!name) {\n startRow++;\n continue;\n }\n await sqlite.execute({\n sql:\n `INSERT INTO mitaa_people (sheet_row,name,norm,email,org,ptype,status)\n VALUES (?,?,?,?,?,?,'')`,\n args: [\n startRow++,\n name,\n normalise(name),\n (cols[1] || \"\").trim(),\n (cols[2] || \"\").trim(),\n (cols[8] || \"\").trim(),\n ],\n });\n n++;\n }\n return json({ loaded: n });\n }\n\n if (path === \"/admin/export\") {\n if (!isAdmin) return json({ error: \"no\" }, 404);\n const people = await allPeople();\n const head =\n \"Sheet Row,Full Name,Organisation,Attendance Status,Check-In Time,Checked-In By\\n\";\n const q = (s: string) => `\"${String(s ?? \"\").replace(/\"/g, '\"\"')}\"`;\n const body = people.map((p) =>\n [\n p.sheet_row,\n q(p.name),\n q(p.org),\n q(p.status),\n q(p.checked_at),\n q(p.checked_by),\n ].join(\",\")\n ).join(\"\\n\");\n return new Response(head + body, {\n headers: {\n \"content-type\": \"text/csv; charset=utf-8\",\n \"content-disposition\": 'attachment; filename=\"mitaa-checkin.csv\"',\n },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n\nfunction slim(p: Person) {\n return {\n id: p.id,\n name: p.name,\n org: p.org,\n email: p.email,\n row: p.sheet_row,\n };\n}\n\n// ---------------------------------------------------------------- usher UI\n\nfunction usherPage(staff: string) {\n return `\n\n\nMITAA check-in\n\n

\n \n – / – in\n

Photograph a nametag to check someone in. You can fit several badges in one shot.

\n \n \n \n

\n`;\n}\n\n// ---------------------------------------------------------------- admin UI\n\nfunction adminPage(total: number, inCount: number, k: string) {\n return `\n\nMITAA check-in — setup\n\n

MITAA check-in

${inCount} / ${total} checked in

Paste the participants tab here — column order as in the Sheet\n(Full Name, Email, Organisation, …). The header row is skipped automatically.\nLoading replaces the list, so do it before the event, not during.

\n\n

\n \n Download CSV\n

\n`;\n}","deleted",false,"label",[14],"78747156-c584-48cf-bc3c-f66a7e264965",["D",1788537730087],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","30738f3a-c3ec-41e1-82a2-11d17e8d7690","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a066fb-791e-721f-8efe-297b4810c575","tursoName","78747156c58448cfbc3cf66a7e264965","tursoHostname","78747156c58448cfbc3cf66a7e264965-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_54":55,"_101":102,"_103":42},"branch",{"_35":87,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned",4,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","puimun-teoh","avatar","https://avatars.githubusercontent.com/u/97607755?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_80":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":61,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]