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",[],[68,115],"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",[],[68,123],["D",1772762290646],[133,134,135,136,137],[74],{"_36":170,"_13":171,"_39":172,"_41":75,"_42":43,"_44":173,"_46":47,"_48":174,"_17":50,"_51":97,"_53":175,"_55":56,"_57":-5,"_84":176,"_18":177},{"_36":162,"_13":163,"_39":164,"_41":75,"_42":43,"_44":165,"_46":47,"_48":166,"_17":50,"_51":97,"_53":167,"_55":56,"_57":-5,"_84":168,"_18":169},{"_36":154,"_13":155,"_39":156,"_41":75,"_42":43,"_44":157,"_46":47,"_48":158,"_17":50,"_51":97,"_53":159,"_55":56,"_57":-5,"_84":160,"_18":161},{"_36":146,"_13":147,"_39":148,"_41":75,"_42":43,"_44":149,"_46":47,"_48":150,"_17":50,"_51":97,"_53":151,"_55":56,"_57":-5,"_84":152,"_18":153},{"_36":138,"_13":139,"_39":140,"_41":75,"_42":43,"_44":141,"_46":47,"_48":142,"_17":50,"_51":97,"_53":143,"_55":56,"_57":-5,"_84":144,"_18":145},"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",[],[74,139],"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",[],[74,147],"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",[],[74,155],"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",[],[74,163],"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",[],[74,171],"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,"_234":230},"org",{"_11":12,"_228":-5,"_229":230,"_187":188,"_231":232,"_233":56},"branch",{"_17":219,"_13":16,"_36":43,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":12},"isOwned",15,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3WWZ5Sm91SWx1eXRNRTZDazIwbnFiUVV4WiJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":178,"_13":14,"_48":309,"_180":-5,"_181":56,"_182":183,"_184":183,"_185":19,"_186":-5,"_187":188,"_189":40,"_190":47,"_191":-5,"_192":-5,"_193":50,"_194":195,"_196":197,"_198":199,"_200":310,"_202":-5,"_203":204,"_205":204,"_206":207,"_208":207,"_209":207,"_210":204,"_211":204,"_212":311,"_214":312,"_216":313,"_218":56},[270,276,279,282],"files",[270,271,272,273,274,275,276,277,278,279,280,281,282],"counts",{"_261":50,"_262":70,"_263":50,"_31":264,"_265":266},[253,254,255,256],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_36":73,"_13":74,"_39":75,"_41":-5,"_42":43,"_44":76,"_46":47,"_48":77,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_18":260},{"_36":67,"_13":68,"_39":69,"_41":-5,"_42":43,"_44":70,"_46":47,"_48":71,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_18":259},{"_36":60,"_13":61,"_39":62,"_41":-5,"_42":43,"_44":63,"_46":47,"_48":64,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_18":258},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_18":257},[38],[61],[68],[74],"pulls","branches","forks",{"_267":50,"_269":50},"connections",{"_267":50,"_268":50},"count","unfilledCount","emptyCount",{"_36":73,"_13":74,"_39":75,"_41":-5,"_42":43,"_44":76,"_46":47,"_48":130,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_84":307,"_18":308},{"_36":170,"_13":171,"_39":172,"_41":75,"_42":43,"_44":173,"_46":47,"_48":174,"_17":50,"_51":97,"_53":175,"_55":56,"_57":-5,"_84":305,"_18":306},{"_36":162,"_13":163,"_39":164,"_41":75,"_42":43,"_44":165,"_46":47,"_48":166,"_17":50,"_51":97,"_53":167,"_55":56,"_57":-5,"_84":303,"_18":304},{"_36":154,"_13":155,"_39":156,"_41":75,"_42":43,"_44":157,"_46":47,"_48":158,"_17":50,"_51":97,"_53":159,"_55":56,"_57":-5,"_84":301,"_18":302},{"_36":146,"_13":147,"_39":148,"_41":75,"_42":43,"_44":149,"_46":47,"_48":150,"_17":50,"_51":97,"_53":151,"_55":56,"_57":-5,"_84":299,"_18":300},{"_36":138,"_13":139,"_39":140,"_41":75,"_42":43,"_44":141,"_46":47,"_48":142,"_17":50,"_51":97,"_53":143,"_55":56,"_57":-5,"_84":297,"_18":298},{"_36":67,"_13":68,"_39":69,"_41":-5,"_42":43,"_44":70,"_46":47,"_48":109,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_84":295,"_18":296},{"_36":122,"_13":123,"_39":124,"_41":69,"_42":43,"_44":125,"_46":47,"_48":126,"_17":50,"_51":24,"_53":127,"_55":56,"_57":-5,"_84":293,"_18":294},{"_36":114,"_13":115,"_39":116,"_41":69,"_42":43,"_44":117,"_46":47,"_48":118,"_17":50,"_51":97,"_53":119,"_55":56,"_57":-5,"_84":291,"_18":292},{"_36":60,"_13":61,"_39":62,"_41":-5,"_42":43,"_44":63,"_46":47,"_48":87,"_17":50,"_51":65,"_53":-5,"_55":56,"_57":-5,"_84":289,"_18":290},{"_36":101,"_13":102,"_39":103,"_41":62,"_42":43,"_44":104,"_46":47,"_48":105,"_17":50,"_51":97,"_53":106,"_55":56,"_57":-5,"_84":287,"_18":288},{"_36":92,"_13":93,"_39":94,"_41":62,"_42":43,"_44":95,"_46":47,"_48":96,"_17":50,"_51":97,"_53":98,"_55":56,"_57":-5,"_84":285,"_18":286},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":83,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_84":283,"_18":284},[],[38],[],[61,93],[],[61,102],[280,281],[61],[],[68,115],[],[68,123],[277,278],[68],[],[74,139],[],[74,147],[],[74,155],[],[74,163],[],[74,171],[271,272,273,274,275],[74],["D",1772761962222],["D",1789513858534],{"_11":12,"_234":230},{"_11":12,"_228":-5,"_229":230,"_187":188,"_231":232,"_233":56},{"_17":219,"_13":16,"_36":43,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":12},"ctx",{"_212":-5,"_250":347,"_348":349,"_350":351,"_352":56,"_353":56,"_354":56,"_355":47,"_356":-5,"_357":-7,"_358":-7,"_359":50,"_360":56,"_361":56,"_362":-5,"_363":56,"_364":56,"_365":56,"_366":-5},"ENV",{"_318":319,"_320":321,"_322":16,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346},"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

Code