[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_300":301,"_302":303},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_227":-5,"_20":228,"_22":229,"_230":231,"_232":233,"_26":234,"_24":235,"_236":-5,"_237":-5,"_238":53,"_239":240,"_241":45,"_242":-5,"_243":-5,"_244":245},"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","arfan","name","shift-todos","branchName","main","version","path","FRONTEND/index.html","project",{"_33":169,"_13":14,"_46":170,"_171":-5,"_172":53,"_173":174,"_175":174,"_176":177,"_178":-5,"_179":180,"_181":63,"_182":45,"_183":-5,"_184":-5,"_185":48,"_186":187,"_188":189,"_190":191,"_192":193,"_194":-5,"_195":196,"_197":196,"_198":199,"_200":199,"_201":199,"_202":196,"_203":196,"_204":205,"_206":207,"_208":209,"_210":53},"tree",[57,58,59,60],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":55},"contents",[],"upstream","pull","ahead","behind","envVars","id","edcffd3e-18ff-11f1-9347-42dde27851f2","index.html","fileId","edcffdfc-18ff-11f1-9347-42dde27851f2","parentId","ed695e6c-18ff-11f1-ab0b-42dde27851f2","branchId","29ce2866-18ff-11f1-861f-42dde27851f2","branchVersion",4,"latest",true,"createdAt",["D",1772762291068],0,"fileType","content","\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","deleted",false,"label",[56,35],"FRONTEND",{"_33":117,"_13":118,"_36":119,"_38":-5,"_40":41,"_42":120,"_44":45,"_46":121,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":122,"_18":123},{"_33":99,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":100,"_44":45,"_46":101,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":102,"_18":103},{"_33":72,"_13":73,"_36":74,"_38":-5,"_40":41,"_42":75,"_44":45,"_46":76,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":78,"_18":79},{"_33":61,"_13":62,"_36":63,"_38":-5,"_40":41,"_42":64,"_44":45,"_46":65,"_17":48,"_49":66,"_50":67,"_52":53,"_54":68,"_69":70,"_18":71},"ee0e3d06-18ff-11f1-a486-42dde27851f2","app.http.ts","ee0e3dce-18ff-11f1-a486-42dde27851f2",13,["D",1772762291473],"http","import { Hono } from \"npm:hono@4.11.5\";\nimport { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport authRoutes from \"./BACKEND/routes.auth.ts\";\nimport shiftsApi from \"./BACKEND/routes.shifts_api.ts\";\nimport { initializeShiftsTables } from \"./BACKEND/db.shifts.ts\";\nimport { initializeTemplatesTable } from \"./BACKEND/db.templates.ts\";\nimport { initializeUsersTable } from \"./BACKEND/db.users.ts\";\n\nawait initializeUsersTable();\nawait initializeTemplatesTable();\nawait initializeShiftsTables();\n\nconst app = new Hono();\n\napp.get(\"/\", async (c) => {\n const url = new URL(\"./FRONTEND/index.html\", import.meta.url);\n const response = await fetch(url);\n const html = await response.text();\n return c.html(html);\n});\n\napp.get(\"/FRONTEND/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/Shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\napp.route(\"/api\", shiftsApi);\napp.route(\"/auth\", authRoutes);\n\napp.onError((err: Error) => {\n throw err;\n});\n\nexport default oauthMiddleware(app.fetch);\n","arfan-shift-todos","children",[],[62],"edb1c06c-18ff-11f1-a1f2-42dde27851f2","Shared","edb1c102-18ff-11f1-a1f2-42dde27851f2",3,["D",1772762290846],"directory",[80,81],[73],{"_33":91,"_13":92,"_36":93,"_38":74,"_40":41,"_42":94,"_44":45,"_46":95,"_17":48,"_49":87,"_50":96,"_52":53,"_54":-5,"_69":97,"_18":98},{"_33":82,"_13":83,"_36":84,"_38":74,"_40":41,"_42":85,"_44":45,"_46":86,"_17":48,"_49":87,"_50":88,"_52":53,"_54":-5,"_69":89,"_18":90},"ee02a27a-18ff-11f1-a486-42dde27851f2","types.ts","ee02a338-18ff-11f1-a486-42dde27851f2",11,["D",1772762291396],"script","export interface UserInfo {\n email: string | null;\n username: string | null;\n profileImageUrl: string | null;\n}\n\nexport interface TemplateItem {\n id: number | string;\n section: string;\n label: string;\n source: \"default\" | \"custom\";\n position: number;\n}\n\nexport interface ShiftTask {\n id: number;\n shiftId: number;\n section: string;\n label: string;\n source: \"default\" | \"custom\";\n completed: boolean;\n completedAt: string | null;\n position: number;\n}\n\nexport interface Shift {\n id: number;\n startedAt: string;\n endedAt: string | null;\n status: \"active\" | \"completed\";\n notes: string;\n completedCount: number;\n totalCount: number;\n}\n\nexport interface ActiveShiftPayload {\n shift: Shift;\n tasks: ShiftTask[];\n}\n\nexport interface ShiftHistoryEntry extends Shift {\n tasks: ShiftTask[];\n}\n\nexport interface AppStatePayload {\n activeShift: ActiveShiftPayload | null;\n history: ShiftHistoryEntry[];\n templates: TemplateItem[];\n}\n",[],[73,83],"ee085648-18ff-11f1-8318-42dde27851f2","config.ts","ee0856f2-18ff-11f1-8318-42dde27851f2",12,["D",1772762291399],"export const APP_NAME = \"Shift Todo\";\nexport const VERSION = \"0.1.0\";\n\nexport const USERS_TABLE = \"shift_todo_users_v1\";\nexport const USER_TEMPLATES_TABLE = \"shift_todo_user_templates_v1\";\nexport const SHIFTS_TABLE = \"shift_todo_shifts_v1\";\nexport const SHIFT_TASKS_TABLE = \"shift_todo_shift_tasks_v1\";\n\nexport const DEFAULT_TEMPLATE_ITEMS = [\n { section: \"Restrooms\", label: \"Men's restroom\", position: 10 },\n { section: \"Restrooms\", label: \"Women's restroom\", position: 20 },\n { section: \"Outside\", label: \"Outside trash\", position: 30 },\n { section: \"Store\", label: \"Front door trash\", position: 40 },\n { section: \"Store\", label: \"Bag ice\", position: 50 },\n { section: \"Store\", label: \"Sweep store\", position: 60 },\n { section: \"Store\", label: \"Mop store\", position: 70 },\n { section: \"Dining\", label: \"Sweep dining\", position: 80 },\n { section: \"Dining\", label: \"Mop dining\", position: 90 },\n { section: \"Coffee\", label: \"Clean coffee station\", position: 100 },\n { section: \"Kitchen\", label: \"Inside trash\", position: 110 },\n { section: \"Kitchen\", label: \"Sweep kitchen\", position: 120 },\n { section: \"Kitchen\", label: \"Mop kitchen\", position: 130 },\n { section: \"Stock\", label: \"Stock coolers\", position: 140 },\n] as const;\n",[],[73,92],"ed695d9a-18ff-11f1-ab0b-42dde27851f2",1,["D",1772762290390],[104,105],[56],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":114,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_69":115,"_18":116},{"_33":106,"_13":107,"_36":108,"_38":39,"_40":41,"_42":109,"_44":45,"_46":110,"_17":48,"_49":87,"_50":111,"_52":53,"_54":-5,"_69":112,"_18":113},"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",[],[56,107],["D",1772762291068],[],[56,35],"ed93625c-18ff-11f1-bce8-42dde27851f2","BACKEND","ed936306-18ff-11f1-bce8-42dde27851f2",2,["D",1772762290646],[124,125,126,127,128],[118],{"_33":161,"_13":162,"_36":163,"_38":119,"_40":41,"_42":164,"_44":45,"_46":165,"_17":48,"_49":87,"_50":166,"_52":53,"_54":-5,"_69":167,"_18":168},{"_33":153,"_13":154,"_36":155,"_38":119,"_40":41,"_42":156,"_44":45,"_46":157,"_17":48,"_49":87,"_50":158,"_52":53,"_54":-5,"_69":159,"_18":160},{"_33":145,"_13":146,"_36":147,"_38":119,"_40":41,"_42":148,"_44":45,"_46":149,"_17":48,"_49":87,"_50":150,"_52":53,"_54":-5,"_69":151,"_18":152},{"_33":137,"_13":138,"_36":139,"_38":119,"_40":41,"_42":140,"_44":45,"_46":141,"_17":48,"_49":87,"_50":142,"_52":53,"_54":-5,"_69":143,"_18":144},{"_33":129,"_13":130,"_36":131,"_38":119,"_40":41,"_42":132,"_44":45,"_46":133,"_17":48,"_49":87,"_50":134,"_52":53,"_54":-5,"_69":135,"_18":136},"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",[],[118,130],"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",[],[118,138],"edfc2b48-18ff-11f1-8102-42dde27851f2","db.users.ts","edfc2c4c-18ff-11f1-8102-42dde27851f2",10,["D",1772762291189],"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",[],[118,146],"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",[],[118,154],"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",[],[118,162],"29cdb7be-18ff-11f1-861f-42dde27851f2",["D",1772761962222],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","1601447d-3c17-4580-a190-f6b82a1eb8e2","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_226":222},"org",{"_11":12,"_220":-5,"_221":222,"_179":180,"_223":224,"_225":53},"branch",{"_17":211,"_13":16,"_33":41,"_212":169,"_213":-5,"_214":-5,"_215":-5,"_216":-5,"_217":-5,"_218":14,"_219":12},"isOwned",15,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3WWZ5Sm91SWx1eXRNRTZDazIwbnFiUVV4WiJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":169,"_13":14,"_46":295,"_171":-5,"_172":53,"_173":174,"_175":174,"_176":177,"_178":-5,"_179":180,"_181":63,"_182":45,"_183":-5,"_184":-5,"_185":48,"_186":187,"_188":189,"_190":191,"_192":296,"_194":-5,"_195":196,"_197":196,"_198":199,"_200":199,"_201":199,"_202":196,"_203":196,"_204":297,"_206":298,"_208":299,"_210":53},[256,262,265,268],"files",[256,257,258,259,260,261,262,263,264,265,266,267,268],"counts",{"_247":48,"_248":100,"_249":48,"_32":250,"_251":252},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":246},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[56,35],"pulls","branches","forks",{"_253":48,"_255":48},"connections",{"_253":48,"_254":48},"count","unfilledCount","emptyCount",{"_33":117,"_13":118,"_36":119,"_38":-5,"_40":41,"_42":120,"_44":45,"_46":121,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":293,"_18":294},{"_33":161,"_13":162,"_36":163,"_38":119,"_40":41,"_42":164,"_44":45,"_46":165,"_17":48,"_49":87,"_50":166,"_52":53,"_54":-5,"_69":291,"_18":292},{"_33":153,"_13":154,"_36":155,"_38":119,"_40":41,"_42":156,"_44":45,"_46":157,"_17":48,"_49":87,"_50":158,"_52":53,"_54":-5,"_69":289,"_18":290},{"_33":145,"_13":146,"_36":147,"_38":119,"_40":41,"_42":148,"_44":45,"_46":149,"_17":48,"_49":87,"_50":150,"_52":53,"_54":-5,"_69":287,"_18":288},{"_33":137,"_13":138,"_36":139,"_38":119,"_40":41,"_42":140,"_44":45,"_46":141,"_17":48,"_49":87,"_50":142,"_52":53,"_54":-5,"_69":285,"_18":286},{"_33":129,"_13":130,"_36":131,"_38":119,"_40":41,"_42":132,"_44":45,"_46":133,"_17":48,"_49":87,"_50":134,"_52":53,"_54":-5,"_69":283,"_18":284},{"_33":99,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":100,"_44":45,"_46":101,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":281,"_18":282},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":114,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_69":279,"_18":280},{"_33":106,"_13":107,"_36":108,"_38":39,"_40":41,"_42":109,"_44":45,"_46":110,"_17":48,"_49":87,"_50":111,"_52":53,"_54":-5,"_69":277,"_18":278},{"_33":72,"_13":73,"_36":74,"_38":-5,"_40":41,"_42":75,"_44":45,"_46":76,"_17":48,"_49":77,"_50":-5,"_52":53,"_54":-5,"_69":275,"_18":276},{"_33":91,"_13":92,"_36":93,"_38":74,"_40":41,"_42":94,"_44":45,"_46":95,"_17":48,"_49":87,"_50":96,"_52":53,"_54":-5,"_69":273,"_18":274},{"_33":82,"_13":83,"_36":84,"_38":74,"_40":41,"_42":85,"_44":45,"_46":86,"_17":48,"_49":87,"_50":88,"_52":53,"_54":-5,"_69":271,"_18":272},{"_33":61,"_13":62,"_36":63,"_38":-5,"_40":41,"_42":64,"_44":45,"_46":65,"_17":48,"_49":66,"_50":67,"_52":53,"_54":68,"_69":269,"_18":270},[],[62],[],[73,83],[],[73,92],[266,267],[73],[],[56,107],[],[56,35],[263,264],[56],[],[118,130],[],[118,138],[],[118,146],[],[118,154],[],[118,162],[257,258,259,260,261],[118],["D",1772761962222],["D",1789513858534],{"_11":12,"_226":222},{"_11":12,"_220":-5,"_221":222,"_179":180,"_223":224,"_225":53},{"_17":211,"_13":16,"_33":41,"_212":169,"_213":-5,"_214":-5,"_215":-5,"_216":-5,"_217":-5,"_218":14,"_219":12},"ctx",{"_204":-5,"_243":333,"_334":335,"_336":337,"_338":53,"_339":53,"_340":53,"_341":45,"_342":-5,"_343":-7,"_344":-7,"_345":48,"_346":53,"_347":53,"_348":-5,"_349":53,"_350":53,"_351":53,"_352":-5},"ENV",{"_304":305,"_306":307,"_308":16,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332},"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"]

Login required

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)}