Audience Survey

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_472":473,"_474":475},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_107":89,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",31,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/proposal-sql.ts","latestPath","fileId","23b1a836-ab17-11f1-9aa3-1607ee4eb77e","name","proposal-sql.ts","fileType","script","content","import type { Question, QuestionDraft } from \"../shared/types.ts\";\n\nexport const proposalSchema = [\n `CREATE TABLE IF NOT EXISTS question_proposals (\n id TEXT PRIMARY KEY,\n survey_id TEXT NOT NULL,\n proposer_sid TEXT NOT NULL,\n draft_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'approved')),\n approved_question_id TEXT UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n approved_at TEXT\n )`,\n `CREATE INDEX IF NOT EXISTS idx_proposals_survey ON question_proposals(survey_id, status, created_at)`,\n `CREATE TABLE IF NOT EXISTS proposal_votes (\n proposal_id TEXT NOT NULL,\n sid TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1 CHECK (active IN (0, 1)),\n PRIMARY KEY (proposal_id, sid)\n )`,\n];\n\nexport function listProposalsStatement(surveyId: string, sid: string) {\n return {\n sql: `SELECT p.id, p.draft_json, p.status, p.created_at,\n COALESCE(SUM(v.active), 0) AS vote_count,\n COALESCE(MAX(CASE WHEN v.sid = ? THEN v.active ELSE 0 END), 0) AS voted\n FROM question_proposals p LEFT JOIN proposal_votes v ON v.proposal_id = p.id\n WHERE p.survey_id = ? AND p.status = 'pending'\n GROUP BY p.id ORDER BY vote_count DESC, p.created_at ASC, p.id ASC`,\n args: [sid, surveyId],\n };\n}\n\nexport function createProposalStatement(\n surveyId: string,\n sid: string,\n id: string,\n draft: QuestionDraft,\n) {\n return {\n sql:\n `INSERT INTO question_proposals (id, survey_id, proposer_sid, draft_json)\n SELECT ?, id, ?, ? FROM surveys WHERE id = ? AND accepting_responses = 1\n RETURNING id`,\n args: [id, sid, JSON.stringify(draft), surveyId],\n };\n}\n\n/** Setting the desired state, rather than blindly toggling, makes retries safe. */\nexport function voteStatement(\n surveyId: string,\n proposalId: string,\n sid: string,\n voted: boolean,\n) {\n return {\n sql: `INSERT INTO proposal_votes (proposal_id, sid, active)\n SELECT p.id, ?, ? FROM question_proposals p JOIN surveys s ON s.id = p.survey_id\n WHERE p.id = ? AND p.survey_id = ? AND p.status = 'pending' AND s.accepting_responses = 1\n ON CONFLICT(proposal_id, sid) DO UPDATE SET active = excluded.active\n RETURNING active`,\n args: [sid, voted ? 1 : 0, proposalId, surveyId],\n };\n}\n\n/** Claim once, then append only for that claim, in the same write transaction. */\nexport function approvalStatements(\n surveyId: string,\n proposalId: string,\n question: Question,\n) {\n return [\n {\n sql:\n `UPDATE question_proposals SET status = 'approved', approved_question_id = ?, approved_at = datetime('now')\n WHERE id = ? AND survey_id = ? AND status = 'pending'\n AND EXISTS (SELECT 1 FROM surveys WHERE id = ?)\n RETURNING id`,\n args: [question.id, proposalId, surveyId, surveyId],\n },\n {\n sql: `UPDATE surveys\n SET questions_json = json_insert(questions_json, '$[#]',\n json_set(json(?), '$.position', json_array_length(questions_json)))\n WHERE id = ? AND EXISTS (\n SELECT 1 FROM question_proposals\n WHERE id = ? AND survey_id = ? AND approved_question_id = ?\n )`,\n args: [\n JSON.stringify(question),\n surveyId,\n proposalId,\n surveyId,\n question.id,\n ],\n },\n ];\n}\n","createdAt",["D",1788825129328],"branchVersion","branchId","00e09eca-4d1b-4e02-b98f-8565c54b4542","id","ae520107-1d25-47b9-ad83-831e36befb67","presentation-survey",["D",1788585574393],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live talk polling: QR join, ranked choice, demographic facets","imageUrl","0198fc74-a2ac-77df-bbdc-e23a8e395bee","pinnedFileId","01a0700e-6ffa-7369-be27-ef5029df6316","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0198fc74-a2ad-7019-840f-e164a0170dfc","tursoName","ae5201071d2547b9ad83831e36befb67","tursoHostname","ae5201071d2547b9ad83831e36befb67-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789542098478],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",150,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","khxu","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMjFKVFdGYXdiZmFXS0hOajdwWHNBOUlZUE4ifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":467,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":468,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":469,"_83":470,"_85":471,"_87":24},"tree",[197,203,226,229,230,231,232],"files",[197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232],"counts",{"_187":62,"_188":142,"_189":62,"_190":191,"_192":193},"contents",[129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":181,"_31":182,"_29":183,"_138":-5,"_40":41,"_39":184,"_140":58,"_37":185,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_26":186},{"_42":175,"_31":176,"_29":177,"_138":-5,"_40":41,"_39":178,"_140":58,"_37":179,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_26":180},{"_42":169,"_31":170,"_29":171,"_138":-5,"_40":41,"_39":142,"_140":58,"_37":172,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_26":174},{"_42":162,"_31":163,"_29":164,"_138":-5,"_40":41,"_39":165,"_140":58,"_37":166,"_13":62,"_33":20,"_35":167,"_23":24,"_145":-5,"_26":168},{"_42":155,"_31":156,"_29":157,"_138":-5,"_40":41,"_39":158,"_140":24,"_37":159,"_13":62,"_33":20,"_35":160,"_23":24,"_145":-5,"_26":161},{"_42":148,"_31":149,"_29":150,"_138":-5,"_40":41,"_39":151,"_140":24,"_37":152,"_13":62,"_33":20,"_35":153,"_23":24,"_145":-5,"_26":154},{"_42":136,"_31":137,"_29":56,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":141,"_13":142,"_33":143,"_35":144,"_23":24,"_145":146,"_26":147},"82995f54-1e20-4238-9e89-5221fc739fdd","index.ts","parentId",9,"latest",["D",1788586503790],3,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { getCookie, setCookie } from \"npm:hono/cookie\";\nimport QRCode from \"npm:qrcode\";\nimport { buildResults } from \"./backend/aggregate.ts\";\nimport { randomId } from \"./backend/db.ts\";\nimport {\n clearResponses,\n createSurvey,\n deleteSurvey,\n getAllResponses,\n getResponse,\n getSurveyByAdminKey,\n getSurveyBySlug,\n sanitizeAnswers,\n updateSurvey,\n upsertResponse,\n} from \"./backend/surveys.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\n// ---- Frontend shell (client-side routing handles the rest) ----\nconst SHELL_PATHS = [\"/\", \"/new\", \"/s/:slug\", \"/s/:slug/results\", \"/s/:slug/present\", \"/admin/:key\"];\nfor (const p of SHELL_PATHS) app.get(p, (c) => c.html(Root()));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- Respondent identity cookie ----\nconst SID_COOKIE = \"survey_sid\";\nfunction getOrSetSid(c: any): string {\n let sid = getCookie(c, SID_COOKIE);\n if (!sid || !/^[a-z0-9]{24}$/.test(sid)) {\n sid = randomId(24);\n setCookie(c, SID_COOKIE, sid, {\n path: \"/\",\n httpOnly: true,\n sameSite: \"Lax\",\n secure: true,\n maxAge: 60 * 60 * 24 * 365,\n });\n }\n return sid;\n}\n\n// ---- Public API ----\napp.post(\"/api/surveys\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const title = String(body.title ?? \"\").slice(0, 120);\n const { survey, adminKey } = await createSurvey(title);\n return c.json({ slug: survey.slug, adminKey });\n});\n\n// Survey for respondents (strips nothing sensitive: admin key never leaves the DB)\napp.get(\"/api/s/:slug\", async (c) => {\n const survey = await getSurveyBySlug(c.req.param(\"slug\"));\n if (!survey) return c.json({ error: \"Not found\" }, 404);\n const sid = getOrSetSid(c);\n const existing = await getResponse(survey.id, sid);\n return c.json({ survey, existing });\n});\n\napp.post(\"/api/s/:slug/respond\", async (c) => {\n const survey = await getSurveyBySlug(c.req.param(\"slug\"));\n if (!survey) return c.json({ error: \"Not found\" }, 404);\n if (!survey.acceptingResponses) return c.json({ error: \"This survey is closed.\" }, 403);\n const sid = getOrSetSid(c);\n const body = await c.req.json().catch(() => ({}));\n const answers = sanitizeAnswers(survey, body.answers);\n await upsertResponse(survey.id, sid, answers);\n return c.json({ ok: true, answers });\n});\n\napp.get(\"/api/s/:slug/results\", async (c) => {\n const survey = await getSurveyBySlug(c.req.param(\"slug\"));\n if (!survey) return c.json({ error: \"Not found\" }, 404);\n if (!survey.resultsVisible) return c.json({ error: \"Results are not visible yet.\" }, 403);\n const groupBy = survey.audienceFacets ? c.req.query(\"groupBy\") || null : null;\n const responses = await getAllResponses(survey.id);\n const visible = survey.questions.filter((q) => !q.hidden);\n return c.json({\n survey,\n totalResponses: responses.length,\n groupBy,\n groups: buildResults(survey, responses, groupBy, visible),\n });\n});\n\n// QR code (SVG) pointing to the respondent URL\napp.get(\"/api/s/:slug/qr.svg\", async (c) => {\n const url = new URL(c.req.url);\n const target = `${url.origin}/s/${c.req.param(\"slug\")}`;\n const svg = await QRCode.toString(target, { type: \"svg\", margin: 1, width: 512, errorCorrectionLevel: \"M\" });\n return c.body(svg, 200, { \"Content-Type\": \"image/svg+xml\", \"Cache-Control\": \"public, max-age=3600\" });\n});\n\n// ---- Admin API (gated by secret key) ----\nconst admin = new Hono();\nadmin.use(\"*\", async (c, next) => {\n const survey = await getSurveyByAdminKey(c.req.param(\"key\") as string);\n if (!survey) return c.json({ error: \"Invalid admin link\" }, 404);\n c.set(\"survey\" as never, survey as never);\n await next();\n});\n\nadmin.get(\"/\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n const responses = await getAllResponses(survey.id);\n return c.json({ survey, totalResponses: responses.length });\n});\n\nadmin.patch(\"/\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n const body = await c.req.json().catch(() => ({}));\n await updateSurvey(survey.id, body);\n const fresh = await getSurveyBySlug(survey.slug);\n return c.json({ survey: fresh });\n});\n\nadmin.get(\"/results\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n const groupBy = c.req.query(\"groupBy\") || null;\n const responses = await getAllResponses(survey.id);\n const all = c.req.query(\"includeHidden\") === \"1\";\n const visible = all ? survey.questions : survey.questions.filter((q: any) => !q.hidden);\n return c.json({\n survey,\n totalResponses: responses.length,\n groupBy,\n groups: buildResults(survey, responses, groupBy, visible),\n });\n});\n\nadmin.get(\"/export.csv\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n const responses = await getAllResponses(survey.id);\n const esc = (s: unknown) => `\"${String(s ?? \"\").replace(/\"/g, '\"\"')}\"`;\n const header = survey.questions.map((q: any) => esc(q.prompt)).join(\",\");\n const optLabel = (q: any, id: string) => q.options.find((o: any) => o.id === id)?.label ?? id;\n const rows = responses.map((r) =>\n survey.questions.map((q: any) => {\n const v = r[q.id];\n if (Array.isArray(v)) return esc(v.map((x) => optLabel(q, x)).join(\" > \"));\n if (typeof v === \"string\" && q.options.length) return esc(optLabel(q, v));\n return esc(v);\n }).join(\",\")\n );\n return c.body([header, ...rows].join(\"\\n\"), 200, {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=\"${survey.slug}-responses.csv\"`,\n });\n});\n\nadmin.delete(\"/responses\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n await clearResponses(survey.id);\n return c.json({ ok: true });\n});\n\nadmin.delete(\"/\", async (c) => {\n const survey = c.get(\"survey\" as never) as any;\n await deleteSurvey(survey.id);\n return c.json({ ok: true });\n});\n\napp.route(\"/api/admin/:key\", admin);\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label","audience-survey",[137],"bf6f1bf6-91ee-49dd-a5a6-1721c0f3cbaa","deno.json","239ffd84-ab17-11f1-a1f1-1607ee4eb77e",29,["D",1788825129488],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[149],"94206482-ce39-478e-9a50-278ff5a7e7e3","README.md","6bf20ad2-a8ec-11f1-b671-1607ee4eb77e",24,["D",1788586880184],"# 📊 Audience Survey\n\nLive polling for talks. Show a QR code, let the room answer on their phones with **no login**, then reveal results on the projector — with ranked-choice runoffs, word clouds, and breakdowns by who's in the audience.\n\n**[Create a survey](url:index.ts)** · no account needed\n\n## How a talk goes\n\n1. **Create** — hit the homepage, name your survey. You get a **secret admin link** (bookmark it — it's the only way back).\n2. **Build** — add questions. Mark ones like *\"What's your profession?\"* as **Demographic** so you can group everything else by them later.\n3. **Share** — put the fullscreen **join slide** (`/s//present`) on the projector. It shows a big QR code + short URL.\n4. **Collect** — the audience answers one question per screen. Each phone gets a cookie so answers are one-per-device and editable; no accounts.\n5. **Reveal** — flip **Show results to audience**. Open `/s//results` on the projector; it live-updates every 3s. Use **Group by** to split every chart by a demographic question, or click a group chip to isolate it.\n\n## Question types\n\n| Type | Respondent sees | Results visualization |\n| --- | --- | --- |\n| Multiple choice (one / many) | Tappable cards | Colored bar chart; grouped bars when faceted |\n| Scale / rating (e.g. 1–5, 0–10 NPS) | Number grid | Heat-colored histogram + animated mean |\n| **Ranked choice** | Tap-to-rank list with reorder | **Instant-runoff animation** — step through elimination rounds, or switch to Borda points / first choices. Per-group winners when faceted |\n| Word cloud | Single word/phrase | Sized, tilted word cloud |\n| Free text | Textarea | Sticky-note wall |\n| Emoji reaction | Emoji grid | Floating emoji bubbles scaled by count |\n\n## Admin controls\n\n- **Accepting responses** — close the survey when you move on\n- **Show results to audience** — survey-wide reveal toggle\n- **Hide results** (per question) — keeps a question out of the audience view even when results are on\n- **Audience can group results** — let respondents use the facet controls too (off by default, keeps the projector clean)\n- **Focus one question** — projector-sized single-question view for pacing a talk\n- CSV export, clear responses, delete survey\n\n## Architecture\n\n```mermaid\ngraph LR\n subgraph Browser\n Home[/ Home/] --> Admin[\"/admin/:secretKey\"]\n QR[\"/s/:slug/present
QR slide\"] -.scan.-> Respond[\"/s/:slug
one question per screen\"]\n Results[\"/s/:slug/results
live charts + facets\"]\n end\n subgraph \"index.ts (Hono)\"\n API[\"/api/s/:slug/*
cookie sid\"]\n AdminAPI[\"/api/admin/:key/*
SHA-256 key check\"]\n Agg[\"backend/aggregate.ts
IRV · Borda · facets\"]\n end\n Respond --> API --> DB[(SQLite)]\n Results -->|poll 3s| API --> Agg\n Admin --> AdminAPI --> DB\n AdminAPI --> Agg\n```\n\n**Security model:** the admin key is a 28-char random token stored only as a SHA-256 hash. Respondents are identified by an `HttpOnly` cookie; clearing it or switching devices allows a second response (acceptable trade-off for a login-free live poll — a \"welcome back\" banner nudges returning devices to edit instead).\n\n## Files\n\n```\nindex.ts Hono server: shell routes, public + admin API, QR SVG\nbackend/db.ts SQLite schema, hashing, random ids\nbackend/surveys.ts CRUD, response upsert, answer sanitization\nbackend/aggregate.ts per-type aggregation, instant-runoff, facet bucketing\nshared/types.ts Question/answer/result types shared by client & server\nfrontend/\n root.tsx HTML shell\n index.tsx React mount\n lib/api.ts typed fetch helpers\n components/App.tsx path router\n pages/Home.tsx create a survey\n pages/Admin.tsx build · share · results tabs\n pages/Respond.tsx one-question-per-screen flow\n pages/Results.tsx public live results\n pages/Present.tsx fullscreen QR join slide\n components/builder/ QuestionEditor\n components/respond/ QuestionInput (all types, ranked drag/tap)\n components/charts/ Charts (recharts + custom), ResultsView (polling, facets)\n```\n",[156],"9edf8260-4785-4901-86fb-409fe2ca18ea",".vtignore","23990ede-ab17-11f1-9def-1607ee4eb77e",28,["D",1788825129320],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor\n.github\n.gitignore\n**/*_test.ts\ntests\n",[163],"3d8da2dc-c72c-49b4-824a-0d8647503817","shared","b40de0d0-1c08-44ab-bea0-624350d7cf7b",["D",1788586405154],"directory",[170],"0f6bbd75-0daf-4112-b29a-623560ed0730","frontend","01a0700e-6ffa-7369-be27-f3f825983851",2,["D",1788586389500],[176],"96062b4f-f92b-4507-8af4-a9d865f43436","backend","a73fa0d1-3dea-4570-b0fc-54f92da89dd6",4,["D",1788586412989],[182],"pulls","branches","forks","envVars",{"_194":62,"_196":62},"connections",{"_194":62,"_195":62},"count","unfilledCount","emptyCount",{"_42":181,"_31":182,"_29":183,"_138":-5,"_40":41,"_39":184,"_140":58,"_37":464,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":465,"_26":466},{"_42":456,"_31":457,"_29":458,"_138":183,"_40":41,"_39":459,"_140":24,"_37":460,"_13":62,"_33":34,"_35":461,"_23":24,"_145":-5,"_234":462,"_26":463},{"_42":449,"_31":450,"_29":451,"_138":183,"_40":41,"_39":184,"_140":24,"_37":452,"_13":62,"_33":34,"_35":453,"_23":24,"_145":-5,"_234":454,"_26":455},{"_42":441,"_31":442,"_29":443,"_138":183,"_40":41,"_39":444,"_140":58,"_37":445,"_13":62,"_33":34,"_35":446,"_23":24,"_145":-5,"_234":447,"_26":448},{"_42":437,"_31":32,"_29":30,"_138":183,"_40":41,"_39":14,"_140":58,"_37":438,"_13":62,"_33":34,"_35":36,"_23":24,"_145":-5,"_234":439,"_26":440},{"_42":429,"_31":430,"_29":431,"_138":183,"_40":41,"_39":432,"_140":24,"_37":433,"_13":62,"_33":34,"_35":434,"_23":24,"_145":-5,"_234":435,"_26":436},{"_42":175,"_31":176,"_29":177,"_138":-5,"_40":41,"_39":178,"_140":58,"_37":426,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":427,"_26":428},{"_42":422,"_31":364,"_29":358,"_138":177,"_40":41,"_39":178,"_140":58,"_37":423,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":424,"_26":425},{"_42":418,"_31":417,"_29":411,"_138":358,"_40":41,"_39":412,"_140":58,"_37":419,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":420,"_26":421},{"_42":408,"_31":409,"_29":410,"_138":411,"_40":41,"_39":412,"_140":24,"_37":413,"_13":62,"_33":34,"_35":414,"_23":24,"_145":-5,"_234":415,"_26":416},{"_42":404,"_31":395,"_29":389,"_138":358,"_40":41,"_39":399,"_140":58,"_37":405,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":406,"_26":407},{"_42":396,"_31":397,"_29":398,"_138":389,"_40":41,"_39":399,"_140":24,"_37":400,"_13":62,"_33":34,"_35":401,"_23":24,"_145":-5,"_234":402,"_26":403},{"_42":386,"_31":387,"_29":388,"_138":389,"_40":41,"_39":390,"_140":24,"_37":391,"_13":62,"_33":34,"_35":392,"_23":24,"_145":-5,"_234":393,"_26":394},{"_42":379,"_31":380,"_29":381,"_138":358,"_40":41,"_39":382,"_140":58,"_37":383,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":384,"_26":385},{"_42":375,"_31":374,"_29":368,"_138":358,"_40":41,"_39":369,"_140":58,"_37":376,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":377,"_26":378},{"_42":365,"_31":366,"_29":367,"_138":368,"_40":41,"_39":369,"_140":24,"_37":370,"_13":62,"_33":34,"_35":371,"_23":24,"_145":-5,"_234":372,"_26":373},{"_42":355,"_31":356,"_29":357,"_138":358,"_40":41,"_39":359,"_140":24,"_37":360,"_13":269,"_33":34,"_35":361,"_23":24,"_145":-5,"_234":362,"_26":363},{"_42":351,"_31":342,"_29":336,"_138":177,"_40":41,"_39":346,"_140":58,"_37":352,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":353,"_26":354},{"_42":343,"_31":344,"_29":345,"_138":336,"_40":41,"_39":346,"_140":24,"_37":347,"_13":62,"_33":34,"_35":348,"_23":24,"_145":-5,"_234":349,"_26":350},{"_42":333,"_31":334,"_29":335,"_138":336,"_40":41,"_39":337,"_140":58,"_37":338,"_13":62,"_33":34,"_35":339,"_23":24,"_145":-5,"_234":340,"_26":341},{"_42":329,"_31":296,"_29":290,"_138":177,"_40":41,"_39":316,"_140":58,"_37":330,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":331,"_26":332},{"_42":321,"_31":322,"_29":323,"_138":290,"_40":41,"_39":324,"_140":24,"_37":325,"_13":62,"_33":34,"_35":326,"_23":24,"_145":-5,"_234":327,"_26":328},{"_42":313,"_31":314,"_29":315,"_138":290,"_40":41,"_39":316,"_140":24,"_37":317,"_13":62,"_33":34,"_35":318,"_23":24,"_145":-5,"_234":319,"_26":320},{"_42":305,"_31":306,"_29":307,"_138":290,"_40":41,"_39":308,"_140":24,"_37":309,"_13":62,"_33":34,"_35":310,"_23":24,"_145":-5,"_234":311,"_26":312},{"_42":297,"_31":298,"_29":299,"_138":290,"_40":41,"_39":300,"_140":24,"_37":301,"_13":62,"_33":34,"_35":302,"_23":24,"_145":-5,"_234":303,"_26":304},{"_42":287,"_31":288,"_29":289,"_138":290,"_40":41,"_39":291,"_140":24,"_37":292,"_13":62,"_33":34,"_35":293,"_23":24,"_145":-5,"_234":294,"_26":295},{"_42":280,"_31":281,"_29":282,"_138":177,"_40":41,"_39":178,"_140":24,"_37":283,"_13":62,"_33":20,"_35":284,"_23":24,"_145":-5,"_234":285,"_26":286},{"_42":273,"_31":274,"_29":275,"_138":177,"_40":41,"_39":178,"_140":24,"_37":276,"_13":62,"_33":34,"_35":277,"_23":24,"_145":-5,"_234":278,"_26":279},{"_42":264,"_31":265,"_29":266,"_138":177,"_40":41,"_39":267,"_140":24,"_37":268,"_13":269,"_33":34,"_35":270,"_23":24,"_145":-5,"_234":271,"_26":272},{"_42":169,"_31":170,"_29":171,"_138":-5,"_40":41,"_39":142,"_140":58,"_37":261,"_13":62,"_33":173,"_35":-5,"_23":24,"_145":-5,"_234":262,"_26":263},{"_42":253,"_31":254,"_29":255,"_138":171,"_40":41,"_39":256,"_140":24,"_37":257,"_13":62,"_33":34,"_35":258,"_23":24,"_145":-5,"_234":259,"_26":260},{"_42":246,"_31":247,"_29":248,"_138":171,"_40":41,"_39":142,"_140":24,"_37":249,"_13":62,"_33":34,"_35":250,"_23":24,"_145":-5,"_234":251,"_26":252},{"_42":162,"_31":163,"_29":164,"_138":-5,"_40":41,"_39":165,"_140":58,"_37":243,"_13":62,"_33":20,"_35":167,"_23":24,"_145":-5,"_234":244,"_26":245},{"_42":155,"_31":156,"_29":157,"_138":-5,"_40":41,"_39":158,"_140":24,"_37":240,"_13":62,"_33":20,"_35":160,"_23":24,"_145":-5,"_234":241,"_26":242},{"_42":148,"_31":149,"_29":150,"_138":-5,"_40":41,"_39":151,"_140":24,"_37":237,"_13":62,"_33":20,"_35":153,"_23":24,"_145":-5,"_234":238,"_26":239},{"_42":136,"_31":137,"_29":56,"_138":-5,"_40":41,"_39":139,"_140":24,"_37":233,"_13":142,"_33":143,"_35":144,"_23":24,"_145":146,"_234":235,"_26":236},["D",1788586503790],"children",[],[137],["D",1788825129488],[],[149],["D",1788586880184],[],[156],["D",1788825129320],[],[163],"4394ede1-0223-409e-b89b-5f538bba5b2e","types.ts","50d89668-a8eb-11f1-a50d-1607ee4eb77e",["D",1788586405154],"export type QuestionType =\n | \"single_choice\"\n | \"multi_choice\"\n | \"scale\"\n | \"free_text\"\n | \"ranked_choice\"\n | \"word_cloud\"\n | \"emoji_reaction\";\n\nexport interface Option {\n id: string;\n label: string;\n}\n\nexport interface Question {\n id: string;\n position: number;\n type: QuestionType;\n prompt: string;\n options: Option[]; // for choice/ranked/emoji types\n scaleMin?: number; // for scale\n scaleMax?: number;\n isDemographic: boolean;\n required: boolean;\n hidden: boolean; // per-question hide override on results\n}\n\nexport interface Survey {\n id: string;\n slug: string;\n title: string;\n description: string;\n resultsVisible: boolean;\n acceptingResponses: boolean;\n audienceFacets: boolean; // can the audience use group-by on results?\n createdAt: string;\n questions: Question[];\n}\n\n/** Answer values: single -> optionId; multi -> optionId[]; scale -> number;\n * free_text/word_cloud -> string; ranked_choice -> optionId[] (ordered); emoji -> optionId */\nexport type AnswerValue = string | number | string[];\n\nexport type Answers = Record;\n\nexport interface IRVRound {\n round: number;\n tallies: Record;\n eliminated: string | null;\n winner: string | null;\n}\n\nexport interface QuestionAggregate {\n questionId: string;\n type: QuestionType;\n responseCount: number;\n /** For choice/emoji: counts by optionId. */\n counts?: Record;\n /** For scale: counts by value, plus mean. */\n distribution?: Record;\n mean?: number | null;\n /** For text/word cloud. */\n texts?: string[];\n words?: { text: string; value: number }[];\n /** For ranked choice. */\n irv?: IRVRound[];\n borda?: Record;\n firstChoice?: Record;\n}\n\nexport interface FacetGroup {\n key: string; // optionId or scale value, or \"__all__\"\n label: string;\n responseCount: number;\n aggregates: QuestionAggregate[];\n}\n\nexport interface ResultsPayload {\n survey: Survey;\n totalResponses: number;\n groupBy: string | null;\n groups: FacetGroup[];\n}\n\nexport const QUESTION_TYPE_LABELS: Record = {\n single_choice: \"Multiple choice (pick one)\",\n multi_choice: \"Multiple choice (pick many)\",\n scale: \"Scale / rating\",\n free_text: \"Free text\",\n ranked_choice: \"Ranked choice\",\n word_cloud: \"Word cloud (one word/phrase)\",\n emoji_reaction: \"Emoji reaction\",\n};\n\nexport const DEFAULT_EMOJIS = [\"🔥\", \"😍\", \"🤔\", \"😴\", \"😂\", \"🤯\"];\n\nexport function hasOptions(t: QuestionType) {\n return t === \"single_choice\" || t === \"multi_choice\" || t === \"ranked_choice\" || t === \"emoji_reaction\";\n}\n",[],[170,247],"81c89ee1-01e4-408f-901c-f0f84eb19f85","questions.ts","238b317e-ab17-11f1-9453-1607ee4eb77e",27,["D",1788825129313],"import { DEFAULT_EMOJIS, hasOptions, QUESTION_TYPE_LABELS } from \"./types.ts\";\nimport type { Question, QuestionDraft, QuestionType } from \"./types.ts\";\n\nexport const QUESTION_LIMITS = {\n prompt: 500,\n optionLabel: 120,\n options: 20,\n scaleSteps: 21,\n};\n\nexport class QuestionValidationError extends Error {}\n\nexport function newQuestion(type: QuestionType = \"single_choice\"): Question {\n return {\n id: crypto.randomUUID(),\n position: 0,\n type,\n prompt: \"\",\n options: hasOptions(type)\n ? (type === \"emoji_reaction\" ? DEFAULT_EMOJIS : [\"\", \"\"]).map((\n label,\n ) => ({\n id: crypto.randomUUID(),\n label,\n }))\n : [],\n ...(type === \"scale\" ? { scaleMin: 1, scaleMax: 5 } : {}),\n isDemographic: false,\n required: false,\n hidden: false,\n };\n}\n\nfunction record(raw: unknown): Record {\n if (!raw || typeof raw !== \"object\" || Array.isArray(raw)) {\n throw new QuestionValidationError(\"Provide a question object.\");\n }\n return raw as Record;\n}\n\nfunction text(raw: unknown, max: number, label: string): string {\n if (typeof raw !== \"string\" || !raw.trim() || raw.trim().length > max) {\n throw new QuestionValidationError(\n `${label} must contain 1-${max} characters.`,\n );\n }\n return raw.trim();\n}\n\n/** Ignore client IDs and admin flags; every approved question gets fresh identifiers. */\nexport function normalizeDraft(raw: unknown): QuestionDraft {\n const input = record(raw);\n if (\n typeof input.type !== \"string\" ||\n !Object.hasOwn(QUESTION_TYPE_LABELS, input.type)\n ) {\n throw new QuestionValidationError(\"Choose a supported question type.\");\n }\n const type = input.type as QuestionType;\n const draft: QuestionDraft = {\n type,\n prompt: text(input.prompt, QUESTION_LIMITS.prompt, \"Question prompt\"),\n options: [],\n };\n if (hasOptions(type)) {\n if (\n !Array.isArray(input.options) || input.options.length < 2 ||\n input.options.length > QUESTION_LIMITS.options\n ) {\n throw new QuestionValidationError(\n `Provide 2-${QUESTION_LIMITS.options} options.`,\n );\n }\n draft.options = input.options.map((option) => ({\n id: crypto.randomUUID(),\n label: text(record(option).label, QUESTION_LIMITS.optionLabel, \"Option\"),\n }));\n if (\n new Set(draft.options.map((o) => o.label.toLowerCase())).size !==\n draft.options.length\n ) {\n throw new QuestionValidationError(\"Options must have distinct labels.\");\n }\n }\n if (type === \"scale\") {\n const min = input.scaleMin;\n const max = input.scaleMax;\n if (\n typeof min !== \"number\" || typeof max !== \"number\" ||\n !Number.isSafeInteger(min) ||\n !Number.isSafeInteger(max) || min < -100 || max > 100 || min >= max ||\n max - min + 1 > QUESTION_LIMITS.scaleSteps\n ) {\n throw new QuestionValidationError(\n \"Use integer scale bounds from -100 to 100, with 2-21 steps.\",\n );\n }\n draft.scaleMin = min;\n draft.scaleMax = max;\n }\n return draft;\n}\n\nexport function questionFromDraft(draft: QuestionDraft): Question {\n return { ...newQuestion(draft.type), ...draft };\n}\n\nexport function normalizeApprovedQuestion(raw: unknown): Question {\n const input = record(raw);\n const question = questionFromDraft(normalizeDraft(raw));\n for (const key of [\"required\", \"hidden\", \"isDemographic\"] as const) {\n if (input[key] !== undefined && typeof input[key] !== \"boolean\") {\n throw new QuestionValidationError(`${key} must be a boolean.`);\n }\n question[key] = input[key] === true;\n }\n const canFacet = [\"single_choice\", \"multi_choice\", \"scale\", \"emoji_reaction\"]\n .includes(question.type);\n question.isDemographic = canFacet && question.isDemographic;\n return question;\n}\n",[],[170,254],["D",1788586405154],[227,228],[170],"2057c8c3-ff48-41a2-9bd4-d9b046d93a08","root.tsx","01a0700e-6ffb-769f-9a4d-f2d83060ed96",10,["D",1788586515184],1,"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport function Root() {\n return (\n <>\n {raw(\"\")}\n \n \n \n \n Audience Survey\n

Diff · v31