[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_183":184,"_185":186},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":36,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":25,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_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":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","http.ts","latestPath","fileId","0fdbc2fa-879b-11f1-8df9-1607ee4eb77e","name","fileType","script","content","","// http.ts — Val Town HTTP trigger. Serves the report page and the .xlsx.\n// URL: https://-.val.run/\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\n\nexport default async function (req: Request): Promise {\n const path = new URL(req.url).pathname;\n\n if (path === \"/AbsenteeVoting.xlsx\") {\n const b = await blob.get(\"xlsx\");\n if (!b) return new Response(\"Not built yet\", { status: 404 });\n return new Response(await b.arrayBuffer(), {\n headers: {\n \"content-type\":\n \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"content-disposition\": 'attachment; filename=\"AbsenteeVoting.xlsx\"',\n \"cache-control\": \"public, max-age=300\",\n },\n });\n }\n\n const b = await blob.get(\"html\");\n if (!b) {\n return new Response(\n \"Report not built yet. Run the cron val once, then reload.\",\n { status: 503, headers: { \"content-type\": \"text/plain\" } },\n );\n }\n return new Response(await b.text(), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"public, max-age=300\",\n },\n });\n}","createdAt",["D",1784923577486],"branchVersion","branchId","0779b895-078a-4517-8c5a-557678c2cd34","id","2fd58d17-59dd-4374-9159-cbb0f4c91ad6","turned-out",["D",1784884388277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","How's the voting turnout going?","imageUrl","4e256467-64f1-4b1d-b7df-84b16185908d","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f935e-8196-7389-8ecc-21e539474e29","tursoName","2fd58d1759dd43749159cbb0f4c91ad6","tursoHostname","2fd58d1759dd43749159cbb0f4c91ad6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",35,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ikaikahussey","handle","displayName","Ikaika Hussey","avatar","https://avatars.githubusercontent.com/u/1045870?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":178,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":179,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":180,"_83":181,"_85":182,"_87":25},"tree",[165,166,167],"files",[165,166,167],"counts",{"_154":62,"_155":156,"_157":62,"_158":159,"_160":161},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":147,"_32":148,"_30":149,"_135":-5,"_41":42,"_40":150,"_137":25,"_38":151,"_13":139,"_33":34,"_35":152,"_24":25,"_141":-5,"_27":153},{"_43":143,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":144,"_13":139,"_33":34,"_35":37,"_24":25,"_141":145,"_27":146},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":25,"_38":138,"_13":139,"_33":34,"_35":140,"_24":25,"_141":-5,"_27":142},"50669b4a-7280-4ec8-ab59-59d6dbd12174","shared.ts","e2ce1412-873f-11f1-b2a0-1607ee4eb77e","parentId",7,"latest",["D",1784923402602],2,"// shared.ts — parsing and output building for the Hawaii absentee report val.\n// Runs on Val Town (Deno). Pure functions; no Val Town APIs imported here.\n\nimport { extractText, getDocumentProxy } from \"npm:unpdf\";\nimport * as XLSX from \"npm:xlsx\";\n\nexport const PAGE_URL =\n \"https://elections.hawaii.gov/resources/absentee-voting-report/\";\nexport const BASE = \"https://elections.hawaii.gov/wp-content/uploads\";\n\n// key -> [sheet/tab name, filename prefix]\nexport const REPORTS: [string, string, string][] = [\n [\"State\", \"Statewide\", \"AbsenteeReconState\"],\n [\"01\", \"Honolulu\", \"AbsenteeReconDP-01\"],\n [\"02\", \"Hawaii County\", \"AbsenteeReconDP-02\"],\n [\"03\", \"Kauai\", \"AbsenteeReconDP-03\"],\n [\"04\", \"Maui\", \"AbsenteeReconDP-04\"],\n];\n\nexport const HEADERS = [\n \"ELECT Sent (a)\",\n \"ELECT Voted (b)\",\n \"ELECT Invalid (c)\",\n \"EV Voted (d)\",\n \"MAIL Sent (e)\",\n \"MAIL Voted (f)\",\n \"MAIL Invalid (g)\",\n \"VOTED (b + d + f)\",\n \"TOTAL (a + d + e)\",\n];\n\nconst DP_RE = /^\\d{2}\\/\\d{2}$/;\nconst NUM_RE = /^[\\d,]+$/;\nconst COUNTY_RE = /^(Hawai.{0,2}i|Maui|Kaua.{0,2}i|Honolulu)$/;\n\nexport type Row = [string, ...number[]]; // label + 9 integers\n\nexport async function pdfToTokens(bytes: Uint8Array): Promise {\n const doc = await getDocumentProxy(bytes);\n const { text } = await extractText(doc, { mergePages: true });\n return text.split(/\\s+/).filter((t) => t.length > 0);\n}\n\nexport function parseTokens(tokens: string[]): Row[] {\n const rows: Row[] = [];\n let i = 0;\n while (i < tokens.length) {\n const t = tokens[i];\n if (DP_RE.test(t) || COUNTY_RE.test(t)) {\n const vals: number[] = [];\n let j = i + 1;\n while (j < tokens.length && vals.length < 9) {\n const v = tokens[j];\n if (NUM_RE.test(v)) {\n vals.push(parseInt(v.replace(/,/g, \"\"), 10));\n j++;\n } else break;\n }\n if (vals.length === 9) {\n rows.push([t, ...vals] as Row);\n i = j;\n continue;\n }\n }\n i++;\n }\n if (rows.length === 0) throw new Error(\"Parsed zero data rows from PDF\");\n for (const r of rows) {\n const [label, a, b, , d, e, f, , voted, total] = r as [\n string,\n number,\n number,\n number,\n number,\n number,\n number,\n number,\n number,\n number,\n ];\n if (voted !== b + d + f || total !== a + d + e) {\n throw new Error(`Row ${label} failed arithmetic check: ${r.join(\",\")}`);\n }\n }\n return rows;\n}\n\nexport type Sheets = { name: string; labelHdr: string; rows: Row[] }[];\n\nexport function buildXlsx(sheets: Sheets, dateStr: string): Uint8Array {\n const wb = XLSX.utils.book_new();\n for (const { name, labelHdr, rows } of sheets) {\n const aoa: (string | number | null)[][] = [];\n aoa.push([\n null,\n \"ELECTRONIC (Email & Fax Combined)\",\n null,\n null,\n \"EARLY VOTING\",\n \"MAIL (SAB & PAB Combined)\",\n null,\n null,\n null,\n null,\n ]);\n aoa.push([labelHdr, ...HEADERS]);\n for (const r of rows) aoa.push([...r]);\n const ws = XLSX.utils.aoa_to_sheet(aoa);\n\n const start = 3; // first data row (1-indexed)\n rows.forEach((_, idx) => {\n const rn = start + idx;\n ws[`I${rn}`] = { t: \"n\", f: `C${rn}+E${rn}+G${rn}` }; // VOTED\n ws[`J${rn}`] = { t: \"n\", f: `B${rn}+E${rn}+F${rn}` }; // TOTAL\n });\n const tr = start + rows.length;\n ws[`A${tr}`] = { t: \"s\", v: \"TOTAL\" };\n for (let c = 0; c < 9; c++) {\n const col = String.fromCharCode(66 + c); // B..J\n ws[`${col}${tr}`] = { t: \"n\", f: `SUM(${col}${start}:${col}${tr - 1})` };\n }\n const note = tr + 2;\n ws[`A${note}`] = {\n t: \"s\",\n v: `Report date ${fmtDate(dateStr)} — Source: Hawaii Office of ` +\n `Elections voting report (${PAGE_URL})`,\n };\n ws[\"!ref\"] = `A1:J${note}`;\n ws[\"!merges\"] = [\n { s: { r: 0, c: 1 }, e: { r: 0, c: 3 } },\n { s: { r: 0, c: 5 }, e: { r: 0, c: 7 } },\n ];\n ws[\"!cols\"] = [{ wch: 14 }, ...Array(9).fill({ wch: 13 })];\n XLSX.utils.book_append_sheet(wb, ws, name);\n }\n return new Uint8Array(\n XLSX.write(wb, { type: \"array\", bookType: \"xlsx\" }) as ArrayBuffer,\n );\n}\n\nexport function fmtDate(d: string): string {\n return `${d.slice(0, 4)}-${d.slice(4, 6)}-${d.slice(6)}`;\n}\n\nexport function buildHtml(sheets: Sheets, dateStr: string): string {\n const nice = fmtDate(dateStr);\n const parts: string[] = [`\n\n\nHawaii Absentee Voting Report — ${nice}\n\n

Hawaii Absentee Voting Report

Report date ${nice} ·\n Download spreadsheet (.xlsx) ·\n Source: Hawaii Office of Elections.\n Unofficial data, subject to change.

`];\n for (const { name, labelHdr, rows } of sheets) {\n parts.push(\n `

${name}

` +\n HEADERS.map((h) => ``).join(\"\") + \"\",\n );\n const totals = new Array(9).fill(0);\n for (const r of rows) {\n const nums = r.slice(1) as number[];\n nums.forEach((v, i) => totals[i] += v);\n parts.push(\n `` +\n nums.map((v) => ``).join(\"\") +\n \"\",\n );\n }\n parts.push(\n `` +\n totals.map((v) => ``).join(\"\") +\n \"

${labelHdr}	${h}
${r[0]}	${v.toLocaleString(\"en-US\")}
TOTAL	${v.toLocaleString(\"en-US\")}

\",\n );\n }\n parts.push(\"\");\n return parts.join(\"\\n\");\n}","label",[133],"43408a61-e0b7-4ff4-855f-59003dfe0baf",["D",1784923577486],"turnedout",[28],"a9a9cdb5-3117-4e08-b9e9-ff04c3df9c0d","cron.ts","c5c538a4-879a-11f1-95c9-1607ee4eb77e",10,["D",1784923479390],"// cron.ts — Val Town CRON trigger. Schedule: 0 14 * * 1-5 (4:00 AM HST weekdays).\n// Fetches the newest report set, parses + verifies, stores outputs in blob storage.\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\nimport {\n BASE,\n buildHtml,\n buildXlsx,\n PAGE_URL,\n parseTokens,\n pdfToTokens,\n REPORTS,\n Sheets,\n} from \"./shared.ts\";\n\nasync function discoverLatest(): Promise {\n // PDFs generate ~3:11 AM HST at predictable URLs; the page's links lag.\n // Probe today (HST) back through 7 days, then fall back to the page.\n const hstNow = new Date(Date.now() - 10 * 3600 * 1000);\n for (let back = 0; back < 8; back++) {\n const d = new Date(hstNow.getTime() - back * 86400 * 1000);\n const ds = d.toISOString().slice(0, 10).replaceAll(\"-\", \"\");\n const r = await fetch(`${BASE}/AbsenteeReconState-${ds}.pdf`);\n if (r.ok) {\n const head = new Uint8Array((await r.arrayBuffer()).slice(0, 5));\n if (new TextDecoder().decode(head) === \"%PDF-\") return ds;\n }\n }\n const html = await (await fetch(PAGE_URL)).text();\n const dates = [...html.matchAll(/AbsenteeReconState-(\\d{8})\\.pdf/g)]\n .map((m) => m[1]);\n if (dates.length === 0) {\n throw new Error(\"No report found by URL probe or page scrape\");\n }\n return dates.sort().at(-1)!;\n}\n\nexport default async function () {\n const latest = await discoverLatest();\n const have =\n (await blob.getJSON(\"meta\") as { report_date?: string } | undefined)\n ?.report_date ?? \"\";\n if (have >= latest) {\n console.log(`Already have report ${have}; nothing to do.`);\n return;\n }\n\n const sheets: Sheets = [];\n for (const [key, name, prefix] of REPORTS) {\n const resp = await fetch(`${BASE}/${prefix}-${latest}.pdf`);\n if (!resp.ok) throw new Error(`Fetch failed for ${prefix}-${latest}.pdf`);\n const rows = parseTokens(\n await pdfToTokens(new Uint8Array(await resp.arrayBuffer())),\n );\n sheets.push({ name, labelHdr: key === \"State\" ? \"County\" : \"D/P\", rows });\n console.log(`${name}: ${rows.length} rows`);\n }\n\n // All five parsed and verified — only now touch storage.\n await blob.set(\"xlsx\", buildXlsx(sheets, latest));\n await blob.set(\"html\", buildHtml(sheets, latest));\n await blob.setJSON(\"meta\", {\n report_date: latest,\n updated: new Date().toISOString(),\n });\n console.log(`Stored report ${latest}.`);\n}",[148],"pulls","branches",1,"forks","envVars",{"_162":62,"_164":62},"connections",{"_162":62,"_163":62},"count","unfilledCount","emptyCount",{"_43":147,"_32":148,"_30":149,"_135":-5,"_41":42,"_40":150,"_137":25,"_38":175,"_13":139,"_33":34,"_35":152,"_24":25,"_141":-5,"_169":176,"_27":177},{"_43":143,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":172,"_13":139,"_33":34,"_35":37,"_24":25,"_141":145,"_169":173,"_27":174},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":25,"_38":168,"_13":139,"_33":34,"_35":140,"_24":25,"_141":-5,"_169":170,"_27":171},["D",1784923402602],"children",[],[133],["D",1784923577486],[],[28],["D",1784923479390],[],[148],["D",1784884388277],["D",1789473046147],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":216,"_217":218,"_219":220,"_221":25,"_222":25,"_223":25,"_224":58,"_225":-5,"_226":-7,"_227":-7,"_228":62,"_229":25,"_230":25,"_231":-5,"_232":25,"_233":25,"_234":25,"_235":-5},"ENV",{"_187":188,"_189":190,"_191":89,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215},"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"]

Diff · v13