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","deleted",false,"label",[19,37],"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",[19,60],"ed695d9a-18ff-11f1-ab0b-42dde27851f2",1,["D",1772762290390],"directory",[19],{"_35":122,"_13":123,"_38":124,"_40":-5,"_42":43,"_44":125,"_46":47,"_48":126,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":127,"_18":128},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":67,"_46":47,"_48":111,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":112,"_18":113},{"_35":86,"_13":87,"_38":88,"_40":-5,"_42":43,"_44":89,"_46":47,"_48":90,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":91,"_18":92},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":50,"_51":80,"_53":81,"_55":56,"_57":82,"_83":84,"_18":85},"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",[],[76],"edb1c06c-18ff-11f1-a1f2-42dde27851f2","Shared","edb1c102-18ff-11f1-a1f2-42dde27851f2",3,["D",1772762290846],[93,94],[87],{"_35":103,"_13":104,"_38":105,"_40":88,"_42":43,"_44":106,"_46":47,"_48":107,"_17":50,"_51":52,"_53":108,"_55":56,"_57":-5,"_83":109,"_18":110},{"_35":95,"_13":96,"_38":97,"_40":88,"_42":43,"_44":98,"_46":47,"_48":99,"_17":50,"_51":52,"_53":100,"_55":56,"_57":-5,"_83":101,"_18":102},"ee02a27a-18ff-11f1-a486-42dde27851f2","types.ts","ee02a338-18ff-11f1-a486-42dde27851f2",11,["D",1772762291396],"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",[],[87,96],"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",[],[87,104],["D",1772762290390],[114,115],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":119,"_17":50,"_51":24,"_53":64,"_55":56,"_57":-5,"_83":120,"_18":121},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":116,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":117,"_18":118},["D",1772762291106],[],[19,37],["D",1772762291068],[],[19,60],"ed93625c-18ff-11f1-bce8-42dde27851f2","BACKEND","ed936306-18ff-11f1-bce8-42dde27851f2",2,["D",1772762290646],[129,130,131,132,133],[123],{"_35":166,"_13":167,"_38":168,"_40":124,"_42":43,"_44":169,"_46":47,"_48":170,"_17":50,"_51":52,"_53":171,"_55":56,"_57":-5,"_83":172,"_18":173},{"_35":158,"_13":159,"_38":160,"_40":124,"_42":43,"_44":161,"_46":47,"_48":162,"_17":50,"_51":52,"_53":163,"_55":56,"_57":-5,"_83":164,"_18":165},{"_35":150,"_13":151,"_38":152,"_40":124,"_42":43,"_44":153,"_46":47,"_48":154,"_17":50,"_51":52,"_53":155,"_55":56,"_57":-5,"_83":156,"_18":157},{"_35":142,"_13":143,"_38":144,"_40":124,"_42":43,"_44":145,"_46":47,"_48":146,"_17":50,"_51":52,"_53":147,"_55":56,"_57":-5,"_83":148,"_18":149},{"_35":134,"_13":135,"_38":136,"_40":124,"_42":43,"_44":137,"_46":47,"_48":138,"_17":50,"_51":52,"_53":139,"_55":56,"_57":-5,"_83":140,"_18":141},"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",[],[123,135],"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",[],[123,143],"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",[],[123,151],"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",[],[123,159],"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",[],[123,167],"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,"_231":227},"org",{"_11":12,"_225":-5,"_226":227,"_184":185,"_228":229,"_230":56},"branch",{"_17":216,"_13":16,"_35":43,"_217":174,"_218":-5,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":14,"_224":12},"isOwned",15,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3WWZ5Sm91SWx1eXRNRTZDazIwbnFiUVV4WiJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":174,"_13":14,"_48":304,"_176":-5,"_177":56,"_178":179,"_180":179,"_181":182,"_183":-5,"_184":185,"_186":77,"_187":47,"_188":-5,"_189":-5,"_190":50,"_191":192,"_193":194,"_195":196,"_197":305,"_199":-5,"_200":201,"_202":201,"_203":204,"_205":204,"_206":204,"_207":201,"_208":201,"_209":306,"_211":307,"_213":308,"_215":56},[265,271,274,277],"files",[265,266,267,268,269,270,271,272,273,274,275,276,277],"counts",{"_256":50,"_257":67,"_258":50,"_32":259,"_260":261},[252,253],{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":67,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":251},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":24,"_53":64,"_55":56,"_57":-5,"_18":255},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":254},[19,37],[19,60],"pulls","branches","forks",{"_262":50,"_264":50},"connections",{"_262":50,"_263":50},"count","unfilledCount","emptyCount",{"_35":122,"_13":123,"_38":124,"_40":-5,"_42":43,"_44":125,"_46":47,"_48":126,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":302,"_18":303},{"_35":166,"_13":167,"_38":168,"_40":124,"_42":43,"_44":169,"_46":47,"_48":170,"_17":50,"_51":52,"_53":171,"_55":56,"_57":-5,"_83":300,"_18":301},{"_35":158,"_13":159,"_38":160,"_40":124,"_42":43,"_44":161,"_46":47,"_48":162,"_17":50,"_51":52,"_53":163,"_55":56,"_57":-5,"_83":298,"_18":299},{"_35":150,"_13":151,"_38":152,"_40":124,"_42":43,"_44":153,"_46":47,"_48":154,"_17":50,"_51":52,"_53":155,"_55":56,"_57":-5,"_83":296,"_18":297},{"_35":142,"_13":143,"_38":144,"_40":124,"_42":43,"_44":145,"_46":47,"_48":146,"_17":50,"_51":52,"_53":147,"_55":56,"_57":-5,"_83":294,"_18":295},{"_35":134,"_13":135,"_38":136,"_40":124,"_42":43,"_44":137,"_46":47,"_48":138,"_17":50,"_51":52,"_53":139,"_55":56,"_57":-5,"_83":292,"_18":293},{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":67,"_46":47,"_48":111,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":290,"_18":291},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":119,"_17":50,"_51":24,"_53":64,"_55":56,"_57":-5,"_83":288,"_18":289},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":116,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":286,"_18":287},{"_35":86,"_13":87,"_38":88,"_40":-5,"_42":43,"_44":89,"_46":47,"_48":90,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":284,"_18":285},{"_35":103,"_13":104,"_38":105,"_40":88,"_42":43,"_44":106,"_46":47,"_48":107,"_17":50,"_51":52,"_53":108,"_55":56,"_57":-5,"_83":282,"_18":283},{"_35":95,"_13":96,"_38":97,"_40":88,"_42":43,"_44":98,"_46":47,"_48":99,"_17":50,"_51":52,"_53":100,"_55":56,"_57":-5,"_83":280,"_18":281},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":50,"_51":80,"_53":81,"_55":56,"_57":82,"_83":278,"_18":279},[],[76],[],[87,96],[],[87,104],[275,276],[87],[],[19,37],[],[19,60],[272,273],[19],[],[123,135],[],[123,143],[],[123,151],[],[123,159],[],[123,167],[266,267,268,269,270],[123],["D",1772761962222],["D",1789513858534],{"_11":12,"_231":227},{"_11":12,"_225":-5,"_226":227,"_184":185,"_228":229,"_230":56},{"_17":216,"_13":16,"_35":43,"_217":174,"_218":-5,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":14,"_224":12},"ctx",{"_209":-5,"_248":342,"_343":344,"_345":346,"_347":56,"_348":56,"_349":56,"_350":47,"_351":-5,"_352":-7,"_353":-7,"_354":50,"_355":56,"_356":56,"_357":-5,"_358":56,"_359":56,"_360":56,"_361":-5},"ENV",{"_313":314,"_315":316,"_317":16,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341},"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