[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_181":182,"_183":184},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_137":-5,"_20":138,"_22":139,"_140":141,"_142":143,"_26":144,"_24":145,"_146":-5,"_147":-5,"_148":52,"_149":150,"_151":43,"_152":-5,"_153":-5,"_154":155},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","tessell","name","design-excellence-awards","branchName","main","version","path","main.tsx","project",{"_33":79,"_13":14,"_44":80,"_81":-5,"_82":52,"_83":84,"_85":84,"_86":87,"_88":-5,"_89":90,"_91":36,"_92":43,"_93":-5,"_94":-5,"_95":75,"_96":97,"_98":99,"_100":101,"_102":103,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":115,"_116":117,"_118":119,"_120":52},"tree",[55,56,57],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","4828b583-b633-4e2e-838c-9c439f60778a","fileId","019ff03d-0fbb-750a-b5e0-7ab2af8c4f1d","parentId","branchId","8c9f5936-3995-415b-9cc6-b8c29344811b","branchVersion",8,"latest",true,"createdAt",["D",1786443156282],1,"fileType","http","content","import { Hono } from \"npm:hono\";\nimport { readFile, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"nominations\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nominee TEXT NOT NULL,\n category TEXT NOT NULL,\n category_name TEXT NOT NULL,\n projects TEXT NOT NULL,\n nominator TEXT,\n scores TEXT NOT NULL,\n evidence TEXT,\n average_score REAL NOT NULL,\n submitted_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))\n)`);\n\n// --- Google Sheets sync (official googleapis.com endpoints only) ---\n// Signs a JWT with the service account key, exchanges it for an access\n// token, and appends one row per nomination. Best-effort: a Sheets\n// failure never blocks saving the nomination to SQLite.\n\nfunction b64url(data: Uint8Array | string): string {\n const bytes = typeof data === \"string\" ? new TextEncoder().encode(data) : data;\n let bin = \"\";\n for (const b of bytes) bin += String.fromCharCode(b);\n return btoa(bin).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n}\n\nexport async function getSheetsToken(sa: any): Promise {\n const now = Math.floor(Date.now() / 1000);\n const header = b64url(JSON.stringify({ alg: \"RS256\", typ: \"JWT\" }));\n const claims = b64url(JSON.stringify({\n iss: sa.client_email,\n scope: \"https://www.googleapis.com/auth/spreadsheets\",\n aud: sa.token_uri,\n iat: now,\n exp: now + 3600,\n }));\n const pem = sa.private_key.replace(/-----(BEGIN|END) PRIVATE KEY-----|\\n/g, \"\");\n const keyBytes = Uint8Array.from(atob(pem), (c) => c.charCodeAt(0));\n const key = await crypto.subtle.importKey(\n \"pkcs8\",\n keyBytes,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n key,\n new TextEncoder().encode(`${header}.${claims}`),\n );\n const jwt = `${header}.${claims}.${b64url(new Uint8Array(sig))}`;\n const res = await fetch(sa.token_uri, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"urn:ietf:params:oauth:grant-type:jwt-bearer\",\n assertion: jwt,\n }),\n });\n if (!res.ok) throw new Error(`token exchange failed: ${res.status}`);\n return (await res.json()).access_token;\n}\n\nexport async function appendToSheet(row: (string | number)[]) {\n const saJson = Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT\");\n const sheetId = Deno.env.get(\"GOOGLE_SHEET_ID\");\n if (!saJson || !sheetId) return;\n const token = await getSheetsToken(JSON.parse(saJson));\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/A1:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ values: [row] }),\n },\n );\n if (!res.ok) throw new Error(`sheets append failed: ${res.status} ${await res.text()}`);\n}\n\nconst app = new Hono();\n\napp.get(\"/\", async (c) => c.html(await readFile(\"/home.html\", import.meta.url)));\napp.get(\"/nominate\", async (c) => c.html(await readFile(\"/nominate.html\", import.meta.url)));\n\napp.post(\"/api/nominations\", async (c) => {\n const b = await c.req.json();\n if (!b.nominee || !b.category || !Array.isArray(b.projects) || !b.projects.length || !b.scores) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (nominee, category, category_name, projects, nominator, scores, evidence, average_score)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n String(b.nominee),\n String(b.category),\n String(b.categoryName ?? \"\"),\n JSON.stringify(b.projects),\n String(b.nominator ?? \"\"),\n JSON.stringify(b.scores),\n String(b.evidence ?? \"\"),\n Number(b.averageScore) || 0,\n ],\n });\n let sheetSynced = true;\n try {\n await appendToSheet([\n new Date().toISOString(),\n String(b.nominee),\n String(b.categoryName ?? b.category),\n (b.projects as string[]).join(\", \"),\n String(b.nominator ?? \"\"),\n Number(b.scores.q1) || \"\",\n Number(b.scores.q2) || \"\",\n Number(b.scores.q3) || \"\",\n Number(b.scores.q4) || \"\",\n Number(b.scores.q5) || \"\",\n Number(b.averageScore) || 0,\n String(b.evidence ?? \"\"),\n ]);\n } catch (e) {\n sheetSynced = false;\n console.error(\"sheets sync failed:\", e);\n }\n return c.json({ ok: true, sheetSynced }, 201);\n});\n\n// Jira TS board search — powers the project typeahead on /nominate.\n// Returns [] (with a reason) when Jira creds are missing or rejected,\n// so the form falls back to free-text input.\napp.get(\"/api/jira-search\", async (c) => {\n const q = (c.req.query(\"q\") ?? \"\").trim();\n const email = Deno.env.get(\"JIRA_EMAIL\");\n const token = Deno.env.get(\"JIRA_TOKEN\");\n const baseUrl = Deno.env.get(\"JIRA_BASE_URL\");\n if (!email || !token || !baseUrl) {\n return c.json({ issues: [], reason: \"jira-not-configured\" });\n }\n if (q.length < 2) return c.json({ issues: [] });\n const jql = `project = TS AND (summary ~ \"${q.replace(/[\"\\\\]/g, \"\")}*\" OR key = \"TS-${q.replace(/\\D/g, \"\") || \"0\"}\") ORDER BY updated DESC`;\n const url = `${baseUrl}/rest/api/3/search/jql?jql=${encodeURIComponent(jql)}&maxResults=8&fields=summary,issuetype,status`;\n const res = await fetch(url, {\n headers: { Authorization: `Basic ${btoa(`${email}:${token}`)}` },\n });\n if (!res.ok) return c.json({ issues: [], reason: `jira-${res.status}` });\n const data = await res.json();\n const issues = (data.issues ?? []).map((i: any) => ({\n key: i.key,\n summary: i.fields?.summary ?? \"\",\n type: i.fields?.issuetype?.name ?? \"\",\n status: i.fields?.status?.name ?? \"\",\n }));\n return c.json({ issues });\n});\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","deleted",false,"label",[19],{"_33":71,"_13":72,"_35":73,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":74,"_17":75,"_47":24,"_49":76,"_51":52,"_53":-5,"_65":77,"_18":78},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":68,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_65":69,"_18":70},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":61,"_42":43,"_44":62,"_17":63,"_47":24,"_49":64,"_51":52,"_53":-5,"_65":66,"_18":67},"cbd32e95-8173-493b-92d9-94fd4f123acd","nominate.html","019ff03d-0fbc-7634-9127-6110f49fb3d3",7,["D",1786443138309],4,"\n\n\n\n\nDesign Excellence Awards — Nomination\n\n\n\n\n\n\n\n

\n\n ← Back to program overview\n\n

\n Design Excellence Awards · Nomination\n

\n\n

Nominate someone whose work raised the bar.

Based on one project or several — score only what you've directly observed this quarter.

Excellence over effort · Impact over visibility · Evidence over opinion

\n\n \n

\n Designer being nominated *\n \n \n

Select or enter the designer's name to continue.

\n\n

\n Category *\n

Pick a category to continue.

\n\n

\n Project(s) this nomination is for *\n

\n \n

Add at least one project.

\n\n

\n Your name\n \n

\n\n

\n \n

\n\n \n \n\n \n \n\n \n \n\n

\n\n\n\n\n","children",[],[59],["D",1786443156282],[],[19],"efb88849-c7ad-45b9-a446-f30abcb0893b","home.html","019ff03d-0fbc-7634-9127-5e161b3f4873",["D",1786441961407],0,"\n\n\n\n\nDesign Excellence Awards\n\n\n\n\n\n\n\n\n

\n\n \n\n

\n \n

Design Excellence Awards

A quarterly program recognizing exceptional contributions across the Design Organization — based on observable behaviors, demonstrated outcomes, and peer feedback. Not popularity. Not tenure.

\n Apply Now →\n Takes about five minutes. Open year-round — the panel decides on the 10th of the quarter's final month.\n

\n\n

\n Excellence over effortImpact over visibilityEvidence over opinionBehaviors over personalityQuality over quantity\n

\n\n

\n Categories\n

Three ways to be recognized

\n CRAFT\n Craft Excellence\n Recognizes exceptional execution quality from concept through implementation.\n

\n INFLUENCE\n Influence & Innovation\n Recognizes individuals whose ideas, critique and innovation improved decisions and outcomes.\n

\n STRATEGY\n Strategic Impact\n Recognizes people who translated business, customer and technical complexity into measurable impact.\n

\n\n

\n Eligibility\n

Who's eligible

Every member of the Design Organization — recognized regardless of discipline or tenure.

\n Product Design\n Visual Design\n Motion Design\n UI Engineering\n Brand\n Content Design\n Design Operations\n

\n\n

\n Process\n

Nominations never close. Decisions happen once a quarter.

\n 01\n

Nominate — anytime

Nominations are open year-round. Anyone across the organization — not just the design team — can nominate a designer, for any category, based on any project(s).

\n 02\n

Panel decides — 10th of the quarter's final month

The panel reviews every nomination submitted that quarter, along with its scores, and decides the winner in each category.

\n 03\n

Winners announced — 1st of the next quarter

Results are shared at the start of the new quarter, alongside the next round of open nominations.

\n\n

\n Before you nominate or review\n

A few ground rules

Review only work you personally observed this quarter.
A nomination can rest on one standout project or several.
Score demonstrated behaviors — not potential.
Leave tenure, personality, and visibility out of it.

\n\n \n\n

\n\n\n\n",[],[72],"d6825f0c-5c7e-47f3-8e4c-26db151d9ebc",["D",1786441907624],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Design Excellence Awards — nominations site with SQLite storage","imageUrl","userId","fd14fddb-7268-407b-95fd-a126833aabf6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019fefd7-ed73-7265-b858-7d1d2e2cbc46","tursoName","d6825f0c5c7e47f38e4c26db151d9ebc","tursoHostname","d6825f0c5c7e47f38e4c26db151d9ebc-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_136":-5},"org",{"_11":12,"_130":131,"_132":-5,"_89":-5,"_133":134,"_135":52},"branch",{"_17":121,"_13":16,"_33":39,"_122":79,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"isOwned",10,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Tessell","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":79,"_13":14,"_44":176,"_81":-5,"_82":52,"_83":84,"_85":84,"_86":87,"_88":-5,"_89":90,"_91":36,"_92":43,"_93":-5,"_94":-5,"_95":75,"_96":97,"_98":99,"_100":101,"_102":177,"_104":-5,"_105":106,"_107":106,"_108":109,"_110":109,"_111":109,"_112":106,"_113":106,"_114":178,"_116":179,"_118":180,"_120":52},[167,168,169],"files",[167,168,169],"counts",{"_157":75,"_158":46,"_159":75,"_32":160,"_161":162},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_18":156},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches","forks",{"_163":165,"_166":75},"connections",{"_163":75,"_164":75},"count","unfilledCount",5,"emptyCount",{"_33":71,"_13":72,"_35":73,"_37":-5,"_38":39,"_40":46,"_42":43,"_44":74,"_17":75,"_47":24,"_49":76,"_51":52,"_53":-5,"_65":174,"_18":175},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":68,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_65":172,"_18":173},{"_33":58,"_13":59,"_35":60,"_37":-5,"_38":39,"_40":61,"_42":43,"_44":62,"_17":63,"_47":24,"_49":64,"_51":52,"_53":-5,"_65":170,"_18":171},[],[59],[],[19],[],[72],["D",1786441907624],["D",1789484509295],{"_11":12,"_136":-5},{"_11":12,"_130":131,"_132":-5,"_89":-5,"_133":134,"_135":52},{"_17":121,"_13":16,"_33":39,"_122":79,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"ctx",{"_114":-5,"_153":214,"_215":216,"_217":218,"_219":52,"_220":52,"_221":52,"_222":43,"_223":-5,"_224":-7,"_225":-7,"_226":75,"_227":52,"_228":52,"_229":-5,"_230":52,"_231":52,"_232":52,"_233":-5},"ENV",{"_185":186,"_187":188,"_189":16,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213},"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"]

Nominate someone whose work raised the bar.

Nomination sent

Design Excellence Awards

Three ways to be recognized

Who's eligible

Nominations never close. Decisions happen once a quarter.

Nominate — anytime

Panel decides — 10th of the quarter's final month

Winners announced — 1st of the next quarter

A few ground rules