Employee Badge Designer

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_364":365,"_366":367},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_273":-5,"_20":274,"_22":275,"_276":277,"_278":279,"_26":280,"_24":281,"_282":-5,"_283":-5,"_284":54,"_285":286,"_287":45,"_288":-5,"_289":-5,"_290":291},"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","zeppomedio","name","badge-designer","branchName","main","version","path","backend/badges.ts","project",{"_33":215,"_13":14,"_46":216,"_217":-5,"_218":54,"_219":220,"_221":220,"_222":223,"_224":-5,"_225":226,"_227":65,"_228":45,"_229":-5,"_230":-5,"_231":48,"_232":233,"_234":235,"_236":237,"_238":239,"_240":-5,"_241":242,"_243":242,"_244":245,"_246":245,"_247":245,"_248":242,"_249":242,"_250":251,"_252":253,"_254":255,"_256":54},"tree",[58,59,60,61,62],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"contents",[],"upstream","pull","ahead","behind","envVars","id","f99dbc58-f5fe-44c0-bce5-72d385ab2a10","badges.ts","fileId","20e09380-a660-11f1-bfc1-1607ee4eb77e","parentId","06ce028f-5a38-4acd-9a22-97e82cd46940","branchId","e7c3af8d-498f-46f9-87e1-9baad6e49d01","branchVersion",4,"latest",true,"createdAt",["D",1788306722299],0,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Badge } from \"../shared/types.ts\";\n\nconst TABLE = \"badges_v1\";\n\nlet ready: Promise | undefined;\nfunction init() {\n ready ??= sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n data TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n );\n return ready;\n}\n\nexport async function listBadges(): Promise {\n await init();\n const { rows } = await sqlite.execute(\n `SELECT data, updated_at FROM ${TABLE} ORDER BY updated_at DESC LIMIT 200`,\n );\n return rows.map((r) => ({\n ...(JSON.parse(String(r.data)) as Badge),\n updatedAt: String(r.updated_at),\n }));\n}\n\nexport async function saveBadge(badge: Badge): Promise {\n await init();\n const updatedAt = new Date().toISOString();\n const record = { ...badge, updatedAt };\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (id, data, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET data = excluded.data, updated_at = excluded.updated_at`,\n args: [badge.id, JSON.stringify(record), updatedAt],\n });\n return record;\n}\n\nexport async function deleteBadge(id: string): Promise {\n await init();\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n}\n","deleted",false,"label",[57,35],"backend",{"_33":198,"_13":57,"_36":39,"_38":-5,"_40":41,"_42":199,"_44":45,"_46":200,"_17":48,"_49":88,"_51":-5,"_53":54,"_55":-5,"_72":201,"_18":202},{"_33":99,"_13":100,"_36":101,"_38":-5,"_40":41,"_42":68,"_44":45,"_46":102,"_17":48,"_49":88,"_51":-5,"_53":54,"_55":-5,"_72":103,"_18":104},{"_33":83,"_13":84,"_36":85,"_38":-5,"_40":41,"_42":86,"_44":45,"_46":87,"_17":48,"_49":88,"_51":-5,"_53":54,"_55":-5,"_72":89,"_18":90},{"_33":75,"_13":76,"_36":77,"_38":-5,"_40":41,"_42":78,"_44":45,"_46":79,"_17":68,"_49":24,"_51":80,"_53":54,"_55":-5,"_72":81,"_18":82},{"_33":63,"_13":64,"_36":65,"_38":-5,"_40":41,"_42":66,"_44":45,"_46":67,"_17":68,"_49":69,"_51":70,"_53":54,"_55":71,"_72":73,"_18":74},"04510882-c9af-4c2a-a0b2-f02d2aad22c5","index.ts","01a05f61-b1a0-7277-97f9-082a47933a03",5,["D",1788306726981],1,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { deleteBadge, listBadges, saveBadge } from \"./backend/badges.ts\";\nimport { handleUpload, serveImage } from \"./backend/uploads.ts\";\nimport type { Badge } from \"./shared/types.ts\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// --- Image uploads (photos & company logos) ---\napp.post(\"/api/upload\", (c) => handleUpload(c.req.raw));\napp.get(\"/img/:file\", (c) => serveImage(c.req.param(\"file\")));\n\n// --- Saved badge roster ---\napp.get(\"/api/badges\", async (c) => c.json(await listBadges()));\napp.post(\"/api/badges\", async (c) => c.json(await saveBadge(await c.req.json() as Badge)));\napp.delete(\"/api/badges/:id\", async (c) => {\n await deleteBadge(c.req.param(\"id\"));\n return c.json({ ok: true });\n});\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","employee-badge-designer","children",[],[64],"9aa7f2e5-fd3b-4da8-8c22-019c102e5c1a","README.md","01a05f61-b1a0-7277-97f9-0502990a07f0",19,["D",1788306995302],"# Employee Badge Designer\n\nDesign employee ID badges in the browser — upload a headshot and your company\nlogo, pick a layout and colors, then print on standard CR80 card stock or export\na PNG.\n\n**[Open the designer](url:index.ts)**\n\n## What it does\n\n- **Image uploads** — drag-and-drop (or click) a photo and a company logo. Both\n are downscaled in the browser with a canvas before upload, then stored as\n blobs and served from `/img/:file` with immutable caching.\n- **Three layouts** — Classic (header bar + round photo), Modern (full-bleed\n color panel), Minimal (type-led). Each renders in portrait or landscape.\n- **Custom colors** — six presets plus accent / card / text color pickers.\n- **True-to-life sizing** — cards are laid out at 2.125in × 3.375in (CR80), so\n printing at 100% gives a badge that fits a standard holder.\n- **Roster** — save badges to SQLite, reload them for editing, and print the\n whole roster as one sheet.\n- **PNG export** — renders the preview at 4× with `html-to-image`.\n\n## Architecture\n\n```mermaid\ngraph TD\n Browser[\"Browser (React SPA)\"] -->|\"GET /\"| Hono[\"index.ts (Hono)\"]\n Hono --> Root[\"frontend/root.tsx
HTML shell + print CSS\"]\n Browser -->|\"POST /api/upload\"| Uploads[\"backend/uploads.ts\"]\n Uploads --> Blob[(\"std/blob\")]\n Browser -->|\"GET /img/:file\"| Uploads\n Browser -->|\"GET/POST/DELETE /api/badges\"| Badges[\"backend/badges.ts\"]\n Badges --> SQLite[(\"std/sqlite\")]\n```\n\n## Files\n\n```\nindex.ts ← Hono server: pages, upload + roster APIs\nbackend/\n uploads.ts ← image upload to blob storage, /img/:file serving\n badges.ts ← saved-badge CRUD in SQLite\nshared/\n types.ts ← Badge shape, templates, presets, card sizing\nfrontend/\n root.tsx ← HTML shell (Twind + the @media print rules)\n index.tsx ← React entrypoint\n lib/images.ts ← canvas downscaling + upload helper\n components/\n App.tsx ← layout, save/print/export actions\n Controls.tsx ← the design form\n BadgeCard.tsx ← the badge itself (3 templates × 2 orientations)\n ImageUpload.tsx ← drag-and-drop upload widget\n Roster.tsx ← saved badge list\n```\n\n## Printing notes\n\nPrint rules live in `frontend/root.tsx` as the app's only stylesheet — `@page`\nmargins and print-only visibility can't be expressed as utility classes. When\nprinting, enable **Background graphics** in the browser's print dialog so accent\ncolors render, and print at 100% scale (no \"fit to page\") for accurate card\ndimensions.\n\n## Storage\n\nPhotos and logos are blobs; on the free plan all blobs share a 10MB budget,\nwhich is why uploads are downscaled to a 640px (photo) / 480px (logo) long edge\nfirst. Removing a badge from the roster does not delete its uploaded images.\n",[],[76],"ab4ebd2d-3530-49ed-9158-dbf808ad414f","shared","84acc09e-36cd-4d8a-a32d-077651075311",2,["D",1788306708883],"directory",[91],[84],{"_33":92,"_13":93,"_36":94,"_38":85,"_40":41,"_42":86,"_44":45,"_46":95,"_17":48,"_49":50,"_51":96,"_53":54,"_55":-5,"_72":97,"_18":98},"b4507ec7-f4f5-407b-96fe-69591557d865","types.ts","18d6001c-a660-11f1-9db0-1607ee4eb77e",["D",1788306708883],"export type Orientation = \"portrait\" | \"landscape\";\nexport type TemplateId = \"classic\" | \"modern\" | \"minimal\";\n\nexport interface Badge {\n id: string;\n name: string;\n title: string;\n department: string;\n employeeId: string;\n company: string;\n footer: string;\n /** URL path to the uploaded photo, e.g. \"/img/abc.jpg\" */\n photoUrl: string | null;\n /** URL path to the uploaded company logo */\n logoUrl: string | null;\n accent: string;\n bg: string;\n text: string;\n orientation: Orientation;\n template: TemplateId;\n showBarcode: boolean;\n updatedAt?: string;\n}\n\nexport const TEMPLATES: { id: TemplateId; label: string; hint: string }[] = [\n { id: \"classic\", label: \"Classic\", hint: \"Header bar + round photo\" },\n { id: \"modern\", label: \"Modern\", hint: \"Full-bleed color panel\" },\n { id: \"minimal\", label: \"Minimal\", hint: \"Type-led, thin accent rule\" },\n];\n\nexport const PRESETS: { label: string; accent: string; bg: string; text: string }[] = [\n { label: \"Midnight\", accent: \"#1e3a8a\", bg: \"#ffffff\", text: \"#0f172a\" },\n { label: \"Forest\", accent: \"#166534\", bg: \"#ffffff\", text: \"#14532d\" },\n { label: \"Ember\", accent: \"#c2410c\", bg: \"#fffbf7\", text: \"#431407\" },\n { label: \"Grape\", accent: \"#6d28d9\", bg: \"#ffffff\", text: \"#2e1065\" },\n { label: \"Slate\", accent: \"#334155\", bg: \"#f8fafc\", text: \"#0f172a\" },\n { label: \"Rose\", accent: \"#be123c\", bg: \"#ffffff\", text: \"#4c0519\" },\n];\n\nexport function newBadge(): Badge {\n return {\n id: crypto.randomUUID(),\n name: \"Ada Lovelace\",\n title: \"Principal Engineer\",\n department: \"Analytical Engines\",\n employeeId: \"EMP-00815\",\n company: \"Babbage & Co.\",\n footer: \"If found, please return to reception\",\n photoUrl: null,\n logoUrl: null,\n accent: \"#1e3a8a\",\n bg: \"#ffffff\",\n text: \"#0f172a\",\n orientation: \"portrait\",\n template: \"classic\",\n showBarcode: true,\n };\n}\n\n/** CR80 card size in inches — the standard ID badge stock. */\nexport function cardSize(orientation: Orientation) {\n return orientation === \"portrait\"\n ? { width: \"2.125in\", height: \"3.375in\" }\n : { width: \"3.375in\", height: \"2.125in\" };\n}\n",[],[84,93],"1a9ffae7-9716-4157-8805-e57223af3d05","frontend","01a05f61-b1a0-7277-97f8-ff5e3824e08d",["D",1788306633045],[105,106,107,108,109],[100],{"_33":147,"_13":148,"_36":149,"_38":101,"_40":41,"_42":68,"_44":45,"_46":150,"_17":48,"_49":88,"_51":-5,"_53":54,"_55":-5,"_72":151,"_18":152},{"_33":132,"_13":133,"_36":134,"_38":101,"_40":41,"_42":135,"_44":45,"_46":136,"_17":48,"_49":88,"_51":-5,"_53":54,"_55":-5,"_72":137,"_18":138},{"_33":125,"_13":126,"_36":127,"_38":101,"_40":41,"_42":68,"_44":45,"_46":128,"_17":48,"_49":24,"_51":129,"_53":54,"_55":-5,"_72":130,"_18":131},{"_33":118,"_13":119,"_36":120,"_38":101,"_40":41,"_42":68,"_44":45,"_46":121,"_17":48,"_49":50,"_51":122,"_53":54,"_55":-5,"_72":123,"_18":124},{"_33":110,"_13":111,"_36":112,"_38":101,"_40":41,"_42":113,"_44":45,"_46":114,"_17":68,"_49":50,"_51":115,"_53":54,"_55":-5,"_72":116,"_18":117},"97c3eb01-606f-4e28-a111-391be2c62340","root.tsx","01a05f61-b1a0-7277-97f8-f8423793edb6",12,["D",1788306917482],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// Print rules can't be expressed as utility classes (@page, print-only layout),\n// so they live here as the one small stylesheet in the app.\nconst printCss = `\n@page { margin: 12mm; }\n.screen-hidden { display: none; }\n@media print {\n body { background: #fff !important; }\n .no-print, .print-hidden { display: none !important; }\n .screen-hidden { display: flex !important; flex-wrap: wrap; align-items: flex-start; gap: 6mm; }\n .preview-box { width: auto !important; height: auto !important; }\n .preview-scale { transform: none !important; }\n .badge-card {\n box-shadow: none !important;\n outline: 1px dashed #cbd5e1;\n outline-offset: 2px;\n break-inside: avoid;\n }\n}\n`;\n\nexport function Root() {\n return (\n <>\n {raw(\"\")}\n \n \n \n \n Employee Badge Designer\n