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",[18,79],"edcffd3e-18ff-11f1-9347-42dde27851f2",["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",[18,65],"pulls","branches","forks","envVars",{"_182":26,"_184":26},"connections",{"_182":26,"_183":26},"count","unfilledCount","emptyCount",{"_34":282,"_13":249,"_63":243,"_44":-5,"_36":37,"_158":283,"_160":24,"_38":284,"_40":26,"_66":82,"_162":-5,"_67":30,"_163":-5,"_205":285,"_17":286},{"_34":274,"_13":275,"_63":276,"_44":243,"_36":37,"_158":277,"_160":24,"_38":278,"_40":26,"_66":80,"_162":279,"_67":30,"_163":-5,"_205":280,"_17":281},{"_34":266,"_13":267,"_63":268,"_44":243,"_36":37,"_158":269,"_160":24,"_38":270,"_40":26,"_66":80,"_162":271,"_67":30,"_163":-5,"_205":272,"_17":273},{"_34":258,"_13":259,"_63":260,"_44":243,"_36":37,"_158":261,"_160":24,"_38":262,"_40":26,"_66":80,"_162":263,"_67":30,"_163":-5,"_205":264,"_17":265},{"_34":250,"_13":251,"_63":252,"_44":243,"_36":37,"_158":253,"_160":24,"_38":254,"_40":26,"_66":80,"_162":255,"_67":30,"_163":-5,"_205":256,"_17":257},{"_34":240,"_13":241,"_63":242,"_44":243,"_36":37,"_158":244,"_160":24,"_38":245,"_40":26,"_66":80,"_162":246,"_67":30,"_163":-5,"_205":247,"_17":248},{"_34":157,"_13":18,"_63":81,"_44":-5,"_36":37,"_158":159,"_160":24,"_38":237,"_40":26,"_66":82,"_162":-5,"_67":30,"_163":-5,"_205":238,"_17":239},{"_34":171,"_13":65,"_63":64,"_44":81,"_36":37,"_158":41,"_160":24,"_38":234,"_40":26,"_66":21,"_162":173,"_67":30,"_163":-5,"_205":235,"_17":236},{"_34":167,"_13":79,"_63":78,"_44":81,"_36":37,"_158":73,"_160":24,"_38":231,"_40":26,"_66":80,"_162":169,"_67":30,"_163":-5,"_205":232,"_17":233},{"_34":226,"_13":217,"_63":211,"_44":-5,"_36":37,"_158":227,"_160":24,"_38":228,"_40":26,"_66":82,"_162":-5,"_67":30,"_163":-5,"_205":229,"_17":230},{"_34":218,"_13":219,"_63":220,"_44":211,"_36":37,"_158":221,"_160":24,"_38":222,"_40":26,"_66":80,"_162":223,"_67":30,"_163":-5,"_205":224,"_17":225},{"_34":208,"_13":209,"_63":210,"_44":211,"_36":37,"_158":212,"_160":24,"_38":213,"_40":26,"_66":80,"_162":214,"_67":30,"_163":-5,"_205":215,"_17":216},{"_34":198,"_13":199,"_63":95,"_44":-5,"_36":37,"_158":200,"_160":24,"_38":201,"_40":26,"_66":202,"_162":203,"_67":30,"_163":204,"_205":206,"_17":207},"ee0e3d06-18ff-11f1-a486-42dde27851f2","app.http.ts",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",[],[199],"ee02a27a-18ff-11f1-a486-42dde27851f2","types.ts","ee02a338-18ff-11f1-a486-42dde27851f2","edb1c102-18ff-11f1-a1f2-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",[],[217,209],"Shared","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",[],[217,219],"edb1c06c-18ff-11f1-a1f2-42dde27851f2",3,["D",1772762290846],[195,196],[217],["D",1772762291106],[],[18,79],["D",1772762291068],[],[18,65],["D",1772762290390],[192,193],[18],"edf50b74-18ff-11f1-b29f-42dde27851f2","routes.shifts_api.ts","edf50c46-18ff-11f1-b29f-42dde27851f2","ed936306-18ff-11f1-bce8-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",[],[249,241],"BACKEND","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",[],[249,251],"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",[],[249,259],"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",[],[249,267],"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",[],[249,275],"ed93625c-18ff-11f1-bce8-42dde27851f2",2,["D",1772762290646],[186,187,188,189,190],[249],["D",1772761962222],["D",1789513858534],{"_11":12,"_135":70},{"_11":12,"_131":-5,"_69":70,"_31":68,"_132":133,"_134":30},{"_40":122,"_13":16,"_34":37,"_123":84,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":-5,"_129":14,"_130":12},"ctx",{"_53":-5,"_154":325,"_326":327,"_328":329,"_330":30,"_331":30,"_332":30,"_333":24,"_334":-5,"_335":-7,"_336":-7,"_337":26,"_338":30,"_339":30,"_340":-5,"_341":30,"_342":30,"_343":30,"_344":-5},"ENV",{"_296":297,"_298":299,"_300":16,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324},"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

History · FRONTEND