[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_240":241,"_242":243},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_107":89,"_26":52,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":24,"_124":-5,"_125":-5,"_126":127},"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",10,"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/db.users.ts","latestPath","fileId","edfc2c4c-18ff-11f1-8102-42dde27851f2","name","db.users.ts","fileType","script","content","import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport type { UserInfo } from \"../Shared/types.ts\";\nimport { USERS_TABLE } from \"../Shared/config.ts\";\n\nexport async function initializeUsersTable(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n email TEXT PRIMARY KEY,\n username TEXT,\n profileImageUrl TEXT\n )`);\n}\n\nexport async function upsertUser(\n email: string,\n username: string | null,\n profileImageUrl: string | null,\n): Promise {\n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (email, username, profileImageUrl)\n VALUES (?, ?, ?)\n ON CONFLICT(email) DO UPDATE SET\n username = excluded.username,\n profileImageUrl = excluded.profileImageUrl`,\n [email, username, profileImageUrl],\n );\n}\n\nexport async function getUser(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT email, username, profileImageUrl\n FROM ${USERS_TABLE}\n WHERE email = ?`,\n [email],\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const [rowEmail, rowUsername, rowProfileImageUrl] = result.rows[0] as [\n string,\n string | null,\n string | null,\n ];\n\n return {\n email: rowEmail,\n username: rowUsername,\n profileImageUrl: rowProfileImageUrl,\n };\n}\n","createdAt",["D",1772762291189],"branchVersion","branchId","29ce2866-18ff-11f1-861f-42dde27851f2","id","29cdb7be-18ff-11f1-861f-42dde27851f2","shift-todos",["D",1772761962222],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","1601447d-3c17-4580-a190-f6b82a1eb8e2","pinnedFileId","ee0e3dce-18ff-11f1-a486-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","8789b31e-4477-4b2d-ae0d-cc5f2132061a","tursoName","29cdb7be18ff11f1861f42dde27851f2","tursoHostname","29cdb7be18ff11f1861f42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789513858534],"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",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","arfan","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3WWZ5Sm91SWx1eXRNRTZDazIwbnFiUVV4WiJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":235,"_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":236,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":237,"_83":238,"_85":239,"_87":24},"tree",[163,169,172],"files",[163,164,165,166,167,168,169,170,171,172],"counts",{"_153":62,"_154":144,"_155":62,"_156":157,"_158":159},"contents",[128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":151,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":152},{"_42":141,"_31":142,"_29":143,"_134":-5,"_40":41,"_39":144,"_136":58,"_37":145,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":146},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":137,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_26":140},"edb1c06c-18ff-11f1-a1f2-42dde27851f2","Shared","edb1c102-18ff-11f1-a1f2-42dde27851f2","parentId",3,"latest",["D",1772762290846],"directory","label",[132],"ed695d9a-18ff-11f1-ab0b-42dde27851f2","FRONTEND","ed695e6c-18ff-11f1-ab0b-42dde27851f2",1,["D",1772762290390],[142],"ed93625c-18ff-11f1-bce8-42dde27851f2","BACKEND","ed936306-18ff-11f1-bce8-42dde27851f2",2,["D",1772762290646],[148],"pulls","branches","forks","envVars",{"_160":62,"_162":62},"connections",{"_160":62,"_161":62},"count","unfilledCount","emptyCount",{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":232,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_174":233,"_26":234},{"_42":224,"_31":225,"_29":226,"_134":149,"_40":41,"_39":227,"_136":58,"_37":228,"_13":62,"_33":34,"_35":229,"_23":24,"_139":-5,"_174":230,"_26":231},{"_42":216,"_31":217,"_29":218,"_134":149,"_40":41,"_39":219,"_136":58,"_37":220,"_13":62,"_33":34,"_35":221,"_23":24,"_139":-5,"_174":222,"_26":223},{"_42":212,"_31":32,"_29":30,"_134":149,"_40":41,"_39":14,"_136":58,"_37":213,"_13":62,"_33":34,"_35":36,"_23":24,"_139":-5,"_174":214,"_26":215},{"_42":204,"_31":205,"_29":206,"_134":149,"_40":41,"_39":207,"_136":58,"_37":208,"_13":62,"_33":34,"_35":209,"_23":24,"_139":-5,"_174":210,"_26":211},{"_42":196,"_31":197,"_29":198,"_134":149,"_40":41,"_39":199,"_136":58,"_37":200,"_13":62,"_33":34,"_35":201,"_23":24,"_139":-5,"_174":202,"_26":203},{"_42":141,"_31":142,"_29":143,"_134":-5,"_40":41,"_39":144,"_136":58,"_37":193,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_174":194,"_26":195},{"_42":185,"_31":186,"_29":187,"_134":143,"_40":41,"_39":188,"_136":58,"_37":189,"_13":62,"_33":20,"_35":190,"_23":24,"_139":-5,"_174":191,"_26":192},{"_42":177,"_31":178,"_29":179,"_134":143,"_40":41,"_39":180,"_136":58,"_37":181,"_13":62,"_33":34,"_35":182,"_23":24,"_139":-5,"_174":183,"_26":184},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":173,"_13":62,"_33":138,"_35":-5,"_23":24,"_139":-5,"_174":175,"_26":176},["D",1772762290846],"children",[],[132],"edd64342-18ff-11f1-bce8-42dde27851f2","script.ts","edd643ec-18ff-11f1-bce8-42dde27851f2",5,["D",1772762291106],"import { APP_NAME, VERSION } from \"../Shared/config.ts\";\nimport type {\n ActiveShiftPayload,\n AppStatePayload,\n ShiftHistoryEntry,\n ShiftTask,\n TemplateItem,\n UserInfo,\n} from \"../Shared/types.ts\";\n\ntype ViewName = \"home\" | \"history\" | \"templates\";\n\nconst authSection = requireElement(\"auth-section\");\nconst loginView = requireElement(\"login-view\");\nconst homeView = requireElement(\"home-view\");\nconst historyView = requireElement(\"history-view\");\nconst templatesView = requireElement(\"templates-view\");\nconst viewNav = requireElement(\"view-nav\");\nconst toast = requireElement(\"toast\");\n\nlet currentUser: UserInfo | null = null;\nlet appState: AppStatePayload | null = null;\nlet currentView: ViewName = \"home\";\nlet toastTimeout: number | null = null;\n\nfunction requireElement(id: string): T {\n const element = document.getElementById(id);\n if (!element) {\n throw new Error(`Missing required element #${id}`);\n }\n return element as T;\n}\n\nfunction escapeHtml(text: string | null | undefined): string {\n if (!text) return \"\";\n const div = document.createElement(\"div\");\n div.textContent = text;\n return div.innerHTML;\n}\n\nfunction showToast(message: string): void {\n toast.textContent = message;\n toast.classList.add(\"visible\");\n if (toastTimeout) {\n window.clearTimeout(toastTimeout);\n }\n toastTimeout = window.setTimeout(() => {\n toast.classList.remove(\"visible\");\n }, 2200);\n}\n\nfunction formatDateTime(iso: string | null): string {\n if (!iso) return \"In progress\";\n return new Date(iso).toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n}\n\nfunction formatClock(iso: string | null): string {\n if (!iso) return \"Not done yet\";\n return new Date(iso).toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n}\n\nfunction groupTasks(tasks: ShiftTask[]): Map {\n const grouped = new Map();\n for (const task of tasks) {\n const existing = grouped.get(task.section) ?? [];\n existing.push(task);\n grouped.set(task.section, existing);\n }\n return grouped;\n}\n\nasync function api(path: string, init?: RequestInit): Promise {\n const response = await fetch(path, init);\n if (response.status === 401) {\n currentUser = null;\n appState = null;\n render();\n throw new Error(\"Authentication required\");\n }\n\n if (!response.ok) {\n const data = await response.json().catch(() => ({}));\n throw new Error(String(data.error ?? \"Request failed\"));\n }\n\n return response.json() as Promise;\n}\n\nasync function fetchUser(): Promise {\n currentUser = await api(\"/auth/me\").catch(() => ({\n email: null,\n username: null,\n profileImageUrl: null,\n }));\n}\n\nasync function fetchState(): Promise {\n if (!currentUser?.email) {\n appState = null;\n return;\n }\n appState = await api(\"/api/state\");\n}\n\nasync function initialize(): Promise {\n await fetchUser();\n if (currentUser?.email) {\n await fetchState();\n }\n render();\n}\n\nfunction renderAuth(): void {\n if (currentUser?.email) {\n const displayName = currentUser.username || currentUser.email;\n authSection.innerHTML = `\n Signed in as ${escapeHtml(displayName)}\n v${VERSION}\n Logout\n `;\n viewNav.classList.remove(\"hidden\");\n loginView.classList.add(\"hidden\");\n return;\n }\n\n authSection.innerHTML = `${APP_NAME} keeps each shift private to your login.`;\n viewNav.classList.add(\"hidden\");\n loginView.classList.remove(\"hidden\");\n}\n\nfunction renderNav(): void {\n viewNav.querySelectorAll(\"button\").forEach((button) => {\n button.classList.toggle(\"active\", button.dataset.view === currentView);\n });\n}\n\nfunction renderHome(): void {\n homeView.classList.toggle(\"hidden\", currentView !== \"home\" || !currentUser?.email);\n\n if (!currentUser?.email || !appState) {\n homeView.innerHTML = \"\";\n return;\n }\n\n const activeShift = appState.activeShift;\n if (!activeShift) {\n homeView.innerHTML = `\n

Ready to roll

No active shift

\n Start a shift to pull in the default checklist, add custom tasks, and keep notes as you go.\n

\n \n

\n `;\n\n const startShiftBtn = document.getElementById(\"start-shift-btn\");\n startShiftBtn?.addEventListener(\"click\", async () => {\n const payload = await api(\"/api/shifts/start\", { method: \"POST\" });\n appState = {\n ...(appState as AppStatePayload),\n activeShift: payload,\n };\n await fetchState();\n showToast(\"Shift started\");\n render();\n });\n return;\n }\n\n const progress = activeShift.shift.totalCount\n ? Math.round((activeShift.shift.completedCount / activeShift.shift.totalCount) * 100)\n : 0;\n\n const groupedTasks = groupTasks(activeShift.tasks);\n const sectionsMarkup = [...groupedTasks.entries()].map(([section, tasks]) => `\n

${escapeHtml(section)}

\n ${tasks.filter((task) => task.completed).length}/${tasks.length}\n

\n ${tasks.map((task) => `\n \n \n

${escapeHtml(task.label)}

${task.source === \"custom\" ? \"Custom task\" : \"Template task\"} · ${escapeHtml(formatClock(task.completedAt))}

\n ${task.completed ? \"Done\" : \"Open\"}\n \n `).join(\"\")}\n

\n `).join(\"\");\n\n homeView.innerHTML = `\n

Active shift

${escapeHtml(formatDateTime(activeShift.shift.startedAt))}

\n \n

\n\n

\n ${activeShift.shift.completedCount}/${activeShift.shift.totalCount}\n tasks done\n

\n ${progress}%\n completed\n

\n ${[...groupedTasks.keys()].length}\n sections\n

\n\n

Custom add

Add a task mid-shift

\n \n

\n\n

Shift notes

What happened?

\n \n

\n\n

Checklist

Work the board

\n ${sectionsMarkup}\n

\n `;\n\n homeView.querySelectorAll('input[type=\"checkbox\"][data-task-id]').forEach((checkbox) => {\n checkbox.addEventListener(\"change\", async () => {\n const taskId = Number(checkbox.dataset.taskId);\n await api(\"/api/tasks/\" + taskId, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ completed: checkbox.checked }),\n });\n await fetchState();\n showToast(checkbox.checked ? \"Task completed\" : \"Task reopened\");\n render();\n });\n });\n\n const customTaskForm = document.getElementById(\"custom-task-form\") as HTMLFormElement | null;\n customTaskForm?.addEventListener(\"submit\", async (event) => {\n event.preventDefault();\n const formData = new FormData(customTaskForm);\n await api(\"/api/shifts/\" + activeShift.shift.id + \"/tasks\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n section: String(formData.get(\"section\") ?? \"\"),\n label: String(formData.get(\"label\") ?? \"\"),\n }),\n });\n customTaskForm.reset();\n await fetchState();\n showToast(\"Custom task added\");\n render();\n });\n\n const notesForm = document.getElementById(\"notes-form\") as HTMLFormElement | null;\n notesForm?.addEventListener(\"submit\", async (event) => {\n event.preventDefault();\n const formData = new FormData(notesForm);\n await api(\"/api/shifts/\" + activeShift.shift.id + \"/notes\", {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ notes: String(formData.get(\"notes\") ?? \"\") }),\n });\n await fetchState();\n showToast(\"Notes saved\");\n render();\n });\n\n const endShiftBtn = document.getElementById(\"end-shift-btn\");\n endShiftBtn?.addEventListener(\"click\", async () => {\n await api(\"/api/shifts/\" + activeShift.shift.id + \"/end\", { method: \"POST\" });\n await fetchState();\n showToast(\"Shift ended\");\n render();\n });\n}\n\nfunction renderHistoryCard(shift: ShiftHistoryEntry): string {\n const doneTasks = shift.tasks.filter((task) => task.completed);\n return `\n

Completed shift

${escapeHtml(formatDateTime(shift.startedAt))}

\n ${shift.completedCount}/${shift.totalCount}\n

\n Ended ${escapeHtml(formatDateTime(shift.endedAt))}\n

\n ${shift.notes\n ? `

${escapeHtml(shift.notes)}

`\n : \"\"}\n

\n ${doneTasks.length\n ? doneTasks.slice(0, 4).map((task) => escapeHtml(task.label)).join(\" · \")\n : \"No tasks were completed in this shift.\"}\n

\n `;\n}\n\nfunction renderHistory(): void {\n historyView.classList.toggle(\"hidden\", currentView !== \"history\" || !currentUser?.email);\n\n if (!currentUser?.email || !appState) {\n historyView.innerHTML = \"\";\n return;\n }\n\n historyView.innerHTML = `\n

Shift archive

History

\n ${\n appState.history.length\n ? appState.history.map(renderHistoryCard).join(\"\")\n : '

No completed shifts yet. Finish your first one to build history.

'\n }\n

\n `;\n}\n\nfunction renderTemplates(): void {\n templatesView.classList.toggle(\"hidden\", currentView !== \"templates\" || !currentUser?.email);\n\n if (!currentUser?.email || !appState) {\n templatesView.innerHTML = \"\";\n return;\n }\n\n const groupedTemplates = new Map();\n for (const item of appState.templates) {\n const existing = groupedTemplates.get(item.section) ?? [];\n existing.push(item);\n groupedTemplates.set(item.section, existing);\n }\n\n templatesView.innerHTML = `\n

Reusable list

Templates

\n Default checklist items are baked in. Add your own recurring tasks here so new shifts start closer to reality.\n

\n \n

\n\n

Current template library

What a shift starts with

\n ${[...groupedTemplates.entries()].map(([section, items]) => `\n

${escapeHtml(section)}

\n ${items.length} items\n

\n ${items.map((item) => `\n

\n \n

${escapeHtml(item.label)}

${item.source === \"default\" ? \"Default\" : \"Your template\"}

\n ${item.source}\n

\n `).join(\"\")}\n

\n `;\n\n const templateForm = document.getElementById(\"template-form\") as HTMLFormElement | null;\n templateForm?.addEventListener(\"submit\", async (event) => {\n event.preventDefault();\n const formData = new FormData(templateForm);\n await api(\"/api/templates\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n section: String(formData.get(\"section\") ?? \"\"),\n label: String(formData.get(\"label\") ?? \"\"),\n }),\n });\n templateForm.reset();\n await fetchState();\n showToast(\"Template item added\");\n render();\n });\n}\n\nfunction render(): void {\n document.title = `${APP_NAME} v${VERSION}`;\n renderAuth();\n renderNav();\n renderHome();\n renderHistory();\n renderTemplates();\n}\n\nviewNav.querySelectorAll(\"button\").forEach((button) => {\n button.addEventListener(\"click\", () => {\n currentView = (button.dataset.view as ViewName) || \"home\";\n render();\n });\n});\n\ninitialize().catch((error) => {\n console.error(error);\n showToast(\"Could not load app\");\n});\n",[],[142,178],"edcffd3e-18ff-11f1-9347-42dde27851f2","index.html","edcffdfc-18ff-11f1-9347-42dde27851f2",4,["D",1772762291068],"\n\n \n \n \n Shift Todo\n \n \n \n \n \n \n

Shift flow

Shift Todo

\n Turn a messy paper checklist into a pocket shift board with live progress,\n quick notes, and reusable templates.\n

\n\n

\n Loading account…\n

\n\n \n

\n\n

\n \n\n

\n\n

\n \n \n\n",[],[142,186],["D",1772762290390],[170,171],[142],"edf50b74-18ff-11f1-b29f-42dde27851f2","routes.shifts_api.ts","edf50c46-18ff-11f1-b29f-42dde27851f2",9,["D",1772762291290],"import { Hono } from \"npm:hono@4.11.5\";\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport {\n addShiftTask,\n endShift,\n getActiveShift,\n getShiftHistory,\n initializeShiftsTables,\n startShift,\n toggleTask,\n updateShiftNotes,\n} from \"./db.shifts.ts\";\nimport {\n addUserTemplateItem,\n getTemplateItems,\n initializeTemplatesTable,\n} from \"./db.templates.ts\";\nimport { upsertUser } from \"./db.users.ts\";\n\nconst app = new Hono();\n\nasync function requireUser(c: Parameters[1] extends (...args: infer A) => any ? A[0] : never) {\n const session = await getOAuthUserData(c.req.raw);\n const email = session?.user?.email;\n if (!email) {\n return null;\n }\n\n await upsertUser(\n email,\n session?.user?.username ?? null,\n session?.user?.profileImageUrl ?? null,\n );\n\n return { email };\n}\n\nasync function buildAppState(email: string) {\n const [activeShift, history, templates] = await Promise.all([\n getActiveShift(email),\n getShiftHistory(email),\n getTemplateItems(email),\n ]);\n\n return { activeShift, history, templates };\n}\n\napp.get(\"/state\", async (c) => {\n await initializeTemplatesTable();\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n return c.json(await buildAppState(user.email));\n});\n\napp.post(\"/shifts/start\", async (c) => {\n await initializeTemplatesTable();\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const templateItems = await getTemplateItems(user.email);\n const activeShift = await startShift(user.email, templateItems);\n return c.json(activeShift);\n});\n\napp.post(\"/shifts/:id/end\", async (c) => {\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const shiftId = Number(c.req.param(\"id\"));\n await endShift(shiftId);\n return c.json(await buildAppState(user.email));\n});\n\napp.patch(\"/shifts/:id/notes\", async (c) => {\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const shiftId = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await updateShiftNotes(shiftId, String(body.notes ?? \"\"));\n return c.json({ ok: true });\n});\n\napp.post(\"/shifts/:id/tasks\", async (c) => {\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const shiftId = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n const section = String(body.section ?? \"\").trim();\n const label = String(body.label ?? \"\").trim();\n\n if (!section || !label) {\n return c.json({ error: \"Section and label are required\" }, 400);\n }\n\n const task = await addShiftTask(shiftId, section, label);\n return c.json(task);\n});\n\napp.patch(\"/tasks/:id\", async (c) => {\n await initializeShiftsTables();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const taskId = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await toggleTask(taskId, Boolean(body.completed));\n return c.json({ ok: true });\n});\n\napp.get(\"/templates\", async (c) => {\n await initializeTemplatesTable();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n return c.json(await getTemplateItems(user.email));\n});\n\napp.post(\"/templates\", async (c) => {\n await initializeTemplatesTable();\n const user = await requireUser(c);\n if (!user) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const body = await c.req.json();\n const section = String(body.section ?? \"\").trim();\n const label = String(body.label ?? \"\").trim();\n\n if (!section || !label) {\n return c.json({ error: \"Section and label are required\" }, 400);\n }\n\n const template = await addUserTemplateItem(user.email, section, label);\n return c.json(template);\n});\n\nexport default app;\n",[],[148,197],"ede1c4e2-18ff-11f1-971a-42dde27851f2","routes.auth.ts","ede1c596-18ff-11f1-971a-42dde27851f2",6,["D",1772762291183],"import { Hono } from \"npm:hono@4.11.5\";\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport type { UserInfo } from \"../Shared/types.ts\";\n\nconst app = new Hono();\n\napp.get(\"/me\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n const user: UserInfo = {\n email: session?.user?.email ?? null,\n username: session?.user?.username ?? null,\n profileImageUrl: session?.user?.profileImageUrl ?? null,\n };\n return c.json(user);\n});\n\nexport default app;\n",[],[148,205],"edfc2b48-18ff-11f1-8102-42dde27851f2",["D",1772762291189],[],[148,32],"ede902fc-18ff-11f1-8b03-42dde27851f2","db.templates.ts","ede903ba-18ff-11f1-8b03-42dde27851f2",7,["D",1772762291193],"import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport {\n DEFAULT_TEMPLATE_ITEMS,\n USER_TEMPLATES_TABLE,\n} from \"../Shared/config.ts\";\nimport type { TemplateItem } from \"../Shared/types.ts\";\n\nexport async function initializeTemplatesTable(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USER_TEMPLATES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL,\n section TEXT NOT NULL,\n label TEXT NOT NULL,\n position INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport async function getTemplateItems(email: string): Promise {\n const defaultItems: TemplateItem[] = DEFAULT_TEMPLATE_ITEMS.map((item, index) => ({\n id: `default-${index + 1}`,\n section: item.section,\n label: item.label,\n source: \"default\",\n position: item.position,\n }));\n\n const result = await sqlite.execute(\n `SELECT id, section, label, position\n FROM ${USER_TEMPLATES_TABLE}\n WHERE email = ?\n ORDER BY section ASC, position ASC, id ASC`,\n [email],\n );\n\n const customItems = result.rows.map((row) => {\n const [id, section, label, position] = row as [\n number,\n string,\n string,\n number,\n ];\n return {\n id,\n section,\n label,\n source: \"custom\" as const,\n position,\n };\n });\n\n return [...defaultItems, ...customItems];\n}\n\nexport async function addUserTemplateItem(\n email: string,\n section: string,\n label: string,\n): Promise {\n const trimmedSection = section.trim();\n const trimmedLabel = label.trim();\n const positionResult = await sqlite.execute(\n `SELECT COALESCE(MAX(position), 0) + 10\n FROM ${USER_TEMPLATES_TABLE}\n WHERE email = ? AND section = ?`,\n [email, trimmedSection],\n );\n const [nextPosition] = positionResult.rows[0] as [number];\n\n const insertResult = await sqlite.execute(\n `INSERT INTO ${USER_TEMPLATES_TABLE} (email, section, label, position)\n VALUES (?, ?, ?, ?)\n RETURNING id, section, label, position`,\n [email, trimmedSection, trimmedLabel, nextPosition],\n );\n\n const [id, savedSection, savedLabel, savedPosition] = insertResult.rows[0] as [\n number,\n string,\n string,\n number,\n ];\n\n return {\n id,\n section: savedSection,\n label: savedLabel,\n source: \"custom\",\n position: savedPosition,\n };\n}\n",[],[148,217],"edeea86a-18ff-11f1-971a-42dde27851f2","db.shifts.ts","edeea914-18ff-11f1-971a-42dde27851f2",8,["D",1772762291253],"import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport {\n SHIFTS_TABLE,\n SHIFT_TASKS_TABLE,\n} from \"../Shared/config.ts\";\nimport type {\n ActiveShiftPayload,\n Shift,\n ShiftHistoryEntry,\n ShiftTask,\n TemplateItem,\n} from \"../Shared/types.ts\";\n\ntype ShiftRow = [\n number,\n string,\n string | null,\n \"active\" | \"completed\",\n string,\n number,\n number,\n];\n\ntype ShiftTaskRow = [\n number,\n number,\n string,\n string,\n \"default\" | \"custom\",\n number,\n string | null,\n number,\n];\n\nfunction mapShiftRow(row: ShiftRow): Shift {\n const [\n id,\n startedAt,\n endedAt,\n status,\n notes,\n completedCount,\n totalCount,\n ] = row;\n\n return {\n id,\n startedAt,\n endedAt,\n status,\n notes,\n completedCount,\n totalCount,\n };\n}\n\nfunction mapTaskRow(row: ShiftTaskRow): ShiftTask {\n const [\n id,\n shiftId,\n section,\n label,\n source,\n completed,\n completedAt,\n position,\n ] = row;\n\n return {\n id,\n shiftId,\n section,\n label,\n source,\n completed: Boolean(completed),\n completedAt,\n position,\n };\n}\n\nexport async function initializeShiftsTables(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SHIFTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL,\n started_at TEXT NOT NULL,\n ended_at TEXT,\n status TEXT NOT NULL DEFAULT 'active',\n notes TEXT NOT NULL DEFAULT ''\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SHIFT_TASKS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n shift_id INTEGER NOT NULL,\n section TEXT NOT NULL,\n label TEXT NOT NULL,\n source TEXT NOT NULL,\n completed INTEGER NOT NULL DEFAULT 0,\n completed_at TEXT,\n position INTEGER NOT NULL DEFAULT 0\n )`);\n}\n\nasync function getShiftTasks(shiftId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, shift_id, section, label, source, completed, completed_at, position\n FROM ${SHIFT_TASKS_TABLE}\n WHERE shift_id = ?\n ORDER BY section ASC, position ASC, id ASC`,\n [shiftId],\n );\n\n return result.rows.map((row) => mapTaskRow(row as ShiftTaskRow));\n}\n\nexport async function getActiveShift(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT\n s.id,\n s.started_at,\n s.ended_at,\n s.status,\n s.notes,\n COALESCE(SUM(CASE WHEN t.completed = 1 THEN 1 ELSE 0 END), 0) AS completed_count,\n COUNT(t.id) AS total_count\n FROM ${SHIFTS_TABLE} s\n LEFT JOIN ${SHIFT_TASKS_TABLE} t ON t.shift_id = s.id\n WHERE s.email = ? AND s.status = 'active'\n GROUP BY s.id\n ORDER BY s.started_at DESC\n LIMIT 1`,\n [email],\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const shift = mapShiftRow(result.rows[0] as ShiftRow);\n const tasks = await getShiftTasks(shift.id);\n return { shift, tasks };\n}\n\nexport async function startShift(\n email: string,\n templateItems: TemplateItem[],\n): Promise {\n const existingShift = await getActiveShift(email);\n if (existingShift) {\n return existingShift;\n }\n\n const startedAt = new Date().toISOString();\n const shiftResult = await sqlite.execute(\n `INSERT INTO ${SHIFTS_TABLE} (email, started_at, status, notes)\n VALUES (?, ?, 'active', '')\n RETURNING id, started_at, ended_at, status, notes, 0, 0`,\n [email, startedAt],\n );\n\n const shift = mapShiftRow(shiftResult.rows[0] as ShiftRow);\n\n for (const item of templateItems) {\n await sqlite.execute(\n `INSERT INTO ${SHIFT_TASKS_TABLE} (shift_id, section, label, source, completed, completed_at, position)\n VALUES (?, ?, ?, ?, 0, NULL, ?)`,\n [shift.id, item.section, item.label, item.source, item.position],\n );\n }\n\n const tasks = await getShiftTasks(shift.id);\n return {\n shift: { ...shift, totalCount: tasks.length },\n tasks,\n };\n}\n\nexport async function addShiftTask(\n shiftId: number,\n section: string,\n label: string,\n): Promise {\n const positionResult = await sqlite.execute(\n `SELECT COALESCE(MAX(position), 0) + 10\n FROM ${SHIFT_TASKS_TABLE}\n WHERE shift_id = ? AND section = ?`,\n [shiftId, section],\n );\n const [nextPosition] = positionResult.rows[0] as [number];\n\n const insertResult = await sqlite.execute(\n `INSERT INTO ${SHIFT_TASKS_TABLE} (shift_id, section, label, source, completed, completed_at, position)\n VALUES (?, ?, ?, 'custom', 0, NULL, ?)\n RETURNING id, shift_id, section, label, source, completed, completed_at, position`,\n [shiftId, section.trim(), label.trim(), nextPosition],\n );\n\n return mapTaskRow(insertResult.rows[0] as ShiftTaskRow);\n}\n\nexport async function toggleTask(taskId: number, completed: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${SHIFT_TASKS_TABLE}\n SET completed = ?, completed_at = ?\n WHERE id = ?`,\n [completed ? 1 : 0, completed ? new Date().toISOString() : null, taskId],\n );\n}\n\nexport async function updateShiftNotes(shiftId: number, notes: string): Promise {\n await sqlite.execute(\n `UPDATE ${SHIFTS_TABLE}\n SET notes = ?\n WHERE id = ?`,\n [notes, shiftId],\n );\n}\n\nexport async function endShift(shiftId: number): Promise {\n await sqlite.execute(\n `UPDATE ${SHIFTS_TABLE}\n SET status = 'completed', ended_at = ?\n WHERE id = ?`,\n [new Date().toISOString(), shiftId],\n );\n}\n\nexport async function getShiftHistory(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT\n s.id,\n s.started_at,\n s.ended_at,\n s.status,\n s.notes,\n COALESCE(SUM(CASE WHEN t.completed = 1 THEN 1 ELSE 0 END), 0) AS completed_count,\n COUNT(t.id) AS total_count\n FROM ${SHIFTS_TABLE} s\n LEFT JOIN ${SHIFT_TASKS_TABLE} t ON t.shift_id = s.id\n WHERE s.email = ? AND s.status = 'completed'\n GROUP BY s.id\n ORDER BY s.started_at DESC\n LIMIT 20`,\n [email],\n );\n\n const history: ShiftHistoryEntry[] = [];\n for (const row of result.rows) {\n const shift = mapShiftRow(row as ShiftRow);\n const tasks = await getShiftTasks(shift.id);\n history.push({ ...shift, tasks });\n }\n\n return history;\n}\n",[],[148,225],["D",1772762290646],[164,165,166,167,168],[148],["D",1772761962222],["D",1789513858534],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_125":273,"_274":275,"_276":277,"_278":24,"_279":24,"_280":24,"_281":58,"_282":-5,"_283":-7,"_284":-7,"_285":62,"_286":24,"_287":24,"_288":-5,"_289":24,"_290":24,"_291":24,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":89,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272},"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"]

No active shift

${escapeHtml(section)}

${escapeHtml(formatDateTime(activeShift.shift.startedAt))}

Add a task mid-shift

What happened?

Work the board

${escapeHtml(formatDateTime(shift.startedAt))}

History

Templates

What a shift starts with

${escapeHtml(section)}

Login required

Diff · v10