[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_1003":1004,"_1005":1006},"routes/_app.x.$handle.$name",{"_93":92,"_31":43,"_101":83,"_26":51,"_13":14,"_102":-5,"_11":103,"_104":105,"_106":107,"_108":109,"_110":111,"_20":-5,"_112":-5,"_113":-5,"_114":24,"_115":116,"_117":118,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",137,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path",".git/hooks/prepare-commit-msg.sample","latestPath","fileId","5a290fa0-132b-11f1-8fb2-42dde27851f2","name","prepare-commit-msg.sample","fileType","content","#!/bin/sh\n#\n# An example hook script to prepare the commit log message.\n# Called by \"git commit\" with the name of the file that has the\n# commit message, followed by the description of the commit\n# message's source. The hook's purpose is to edit the commit\n# message file. If the hook fails with a non-zero status,\n# the commit is aborted.\n#\n# To enable this hook, rename this file to \"prepare-commit-msg\".\n\n# This hook includes three examples. The first one removes the\n# \"# Please enter the commit message...\" help message.\n#\n# The second includes the output of \"git diff --name-status -r\"\n# into the message, just before the \"git status\" output. It is\n# commented because it doesn't cope with --amend or with squashed\n# commits.\n#\n# The third example adds a Signed-off-by line to the message, that can\n# still be edited. This is rarely a good idea.\n\nCOMMIT_MSG_FILE=$1\nCOMMIT_SOURCE=$2\nSHA1=$3\n\n/usr/bin/perl -i.bak -ne 'print unless(m/^. Please enter the commit message/..m/^#$/)' \"$COMMIT_MSG_FILE\"\n\n# case \"$COMMIT_SOURCE,$SHA1\" in\n# ,|template,)\n# /usr/bin/perl -i.bak -pe '\n# print \"\\n\" . `git diff --cached --name-status -r`\n# \t if /^#/ && $first++ == 0' \"$COMMIT_MSG_FILE\" ;;\n# *) ;;\n# esac\n\n# SOB=$(git var GIT_COMMITTER_IDENT | sed -n 's/^\$.*>\$.*$/Signed-off-by: \\1/p')\n# git interpret-trailers --in-place --trailer \"$SOB\" \"$COMMIT_MSG_FILE\"\n# if test -z \"$COMMIT_SOURCE\"\n# then\n# /usr/bin/perl -i.bak -pe 'print \"\\n\" if !$first_line++' \"$COMMIT_MSG_FILE\"\n# fi\n","createdAt",["D",1772121234231],"branchVersion","branchId","5c0c68ec-130a-11f1-9411-42dde27851f2","id","5c0c02e4-130a-11f1-9411-42dde27851f2","lakeland-timesheet",["D",1772107064004],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ec577df-7957-4760-a4d3-81e05cef3345","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","48ae43c1-9cce-4f57-9abb-f1491d51acfb","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"isOwned",178,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","trevormunoz","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWm5xQUFoY280MXptMVB2Tk9ad0ptV3gyNWUifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_31":43,"_36":999,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":1000,"_77":1001,"_79":1002,"_81":24},"tree",[239,303,310,314,321,324,330,331,332,333,334,335,336],"files",[239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336],"counts",{"_229":143,"_230":59,"_231":143,"_232":233,"_234":235},"contents",[123,124,125,126,127,128,129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_41":223,"_31":224,"_29":225,"_139":-5,"_39":40,"_38":226,"_141":118,"_36":227,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":228},{"_41":217,"_31":218,"_29":219,"_139":-5,"_39":40,"_38":220,"_141":118,"_36":221,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":222},{"_41":211,"_31":212,"_29":213,"_139":-5,"_39":40,"_38":214,"_141":118,"_36":215,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":216},{"_41":205,"_31":206,"_29":207,"_139":-5,"_39":40,"_38":208,"_141":118,"_36":209,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":210},{"_41":200,"_31":201,"_29":202,"_139":-5,"_39":40,"_38":59,"_141":118,"_36":203,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":204},{"_41":193,"_31":194,"_29":195,"_139":-5,"_39":40,"_38":196,"_141":118,"_36":197,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_26":199},{"_41":186,"_31":187,"_29":188,"_139":-5,"_39":40,"_38":189,"_141":118,"_36":190,"_13":143,"_33":20,"_34":191,"_23":24,"_146":-5,"_26":192},{"_41":179,"_31":180,"_29":181,"_139":-5,"_39":40,"_38":182,"_141":24,"_36":183,"_13":143,"_33":20,"_34":184,"_23":24,"_146":-5,"_26":185},{"_41":171,"_31":172,"_29":173,"_139":-5,"_39":40,"_38":174,"_141":118,"_36":175,"_13":59,"_33":176,"_34":177,"_23":24,"_146":-5,"_26":178},{"_41":162,"_31":163,"_29":164,"_139":-5,"_39":40,"_38":165,"_141":24,"_36":166,"_13":167,"_33":168,"_34":169,"_23":24,"_146":-5,"_26":170},{"_41":155,"_31":156,"_29":157,"_139":-5,"_39":40,"_38":158,"_141":118,"_36":159,"_13":143,"_33":20,"_34":160,"_23":24,"_146":-5,"_26":161},{"_41":148,"_31":149,"_29":150,"_139":-5,"_39":40,"_38":151,"_141":118,"_36":152,"_13":143,"_33":20,"_34":153,"_23":24,"_146":-5,"_26":154},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":118,"_36":142,"_13":143,"_33":144,"_34":145,"_23":24,"_146":-5,"_26":147},"59ae7fb0-132b-11f1-b163-42dde27851f2","valtown.d.ts","59ae8082-132b-11f1-b163-42dde27851f2","parentId",116,"latest",["D",1772121233422],0,"script","// Type declarations for Val Town runtime modules\ndeclare module \"https://esm.town/v/std/sqlite\" {\n interface SqliteResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n }\n interface SqliteClient {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n }\n export const sqlite: SqliteClient;\n}\n","label",[137],"59bed89c-132b-11f1-b93a-42dde27851f2","tsconfig.json","59bed93c-132b-11f1-b93a-42dde27851f2",119,["D",1772121233531],"{\n \"compilerOptions\": {\n \"target\": \"ES2022\",\n \"module\": \"ES2022\",\n \"moduleResolution\": \"bundler\",\n \"strict\": true,\n \"esModuleInterop\": true,\n \"allowImportingTsExtensions\": true,\n \"noEmit\": true,\n \"forceConsistentCasingInFileNames\": true,\n \"skipLibCheck\": true\n },\n \"include\": [\"**/*.ts\"],\n \"exclude\": [\"node_modules\"]\n}\n",[149],"59b9adea-132b-11f1-b163-42dde27851f2","package.json","59b9ae9e-132b-11f1-b163-42dde27851f2",118,["D",1772121233484],"{\n \"name\": \"lakeland-timesheet\",\n \"version\": \"1.0.0\",\n \"private\": true,\n \"scripts\": {\n \"test\": \"vitest\",\n \"test:run\": \"vitest run\",\n \"check\": \"tsc --noEmit\"\n },\n \"devDependencies\": {\n \"@libsql/client\": \"^0.17.0\",\n \"typescript\": \"^5.9.3\",\n \"vitest\": \"^4.0.18\"\n }\n}\n",[156],"4da44708-1327-11f1-8e31-42dde27851f2","main.ts","9ecb8054-130b-11f1-8d22-42dde27851f2",65,["D",1772119495232],11,"http","// src/main.ts\nimport { verifySlackSignature } from \"./slack/verify.ts\";\nimport { createSlackClient, type SlackClient } from \"./slack/api.ts\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./slack/modals.ts\";\nimport { parseAdminCommand } from \"./handlers/admin.ts\";\nimport { formatReport, parseReportArgs } from \"./handlers/report.ts\";\nimport { migrate } from \"./db/schema.ts\";\nimport * as queries from \"./db/queries.ts\";\nimport { formatDuration, todayInTimezone } from \"./lib/format.ts\";\nimport type { Database } from \"./db/types.ts\";\n\n// Val Town runtime globals\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\n// Environment variables:\n// SLACK_BOT_TOKEN - Slack bot OAuth token\n// SLACK_SIGNING_SECRET - Slack request signing secret\n// ADMIN_USER_IDS - Comma-separated Slack user IDs allowed to use /timesheet-admin\nconst ADMIN_USER_IDS = new Set(\n (Deno.env.get(\"ADMIN_USER_IDS\") ?? \"\").split(\",\").filter(Boolean)\n);\n\nlet db: Database;\nlet slack: SlackClient;\nlet migrated = false;\n\nasync function getDb(): Promise {\n if (!db) {\n // Val Town's sqlite.execute takes (sql, args) not {sql, args}\n // Wrap it to match our Database interface\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n db = {\n execute(query: { sql: string; args?: unknown[] }) {\n console.log(\">>> DB execute:\", query.sql, \"args:\", JSON.stringify(query.args));\n return sqlite.execute({ sql: query.sql, args: query.args ?? [] });\n },\n batch(queries: Array) {\n return sqlite.batch(\n queries.map((q) => (typeof q === \"string\" ? q : { sql: q.sql, args: q.args ?? [] }))\n );\n },\n };\n }\n if (!migrated) {\n await migrate(db);\n migrated = true;\n }\n return db;\n}\n\nfunction getSlack(): SlackClient {\n if (!slack) {\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) throw new Error(\"SLACK_BOT_TOKEN not set\");\n slack = createSlackClient(token);\n }\n return slack;\n}\n\nexport default async function handler(req: Request): Promise {\n console.log(\">>> REQUEST RECEIVED:\", req.method, req.url);\n console.log(\">>> Headers:\", JSON.stringify(Object.fromEntries(req.headers.entries())));\n\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const body = await req.text();\n const timestamp = req.headers.get(\"x-slack-request-timestamp\") ?? \"\";\n const signature = req.headers.get(\"x-slack-signature\") ?? \"\";\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\");\n if (!signingSecret) {\n console.error(\"SLACK_SIGNING_SECRET not configured\");\n return new Response(\"Server misconfiguration\", { status: 500 });\n }\n\n const valid = await verifySlackSignature(body, timestamp, signature, signingSecret);\n if (!valid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n const contentType = req.headers.get(\"content-type\") ?? \"\";\n\n try {\n if (contentType.includes(\"application/x-www-form-urlencoded\")) {\n const params = new URLSearchParams(body);\n const payload = params.get(\"payload\");\n\n if (payload) {\n return handleInteraction(JSON.parse(payload));\n }\n\n const command = params.get(\"command\");\n const text = params.get(\"text\") ?? \"\";\n const triggerId = params.get(\"trigger_id\") ?? \"\";\n const userId = params.get(\"user_id\") ?? \"\";\n const userName = params.get(\"user_name\") ?? \"\";\n const channelId = params.get(\"channel_id\") ?? \"\";\n\n switch (command) {\n case \"/logtime\":\n return handleLogtime(text, triggerId, userId, userName, channelId);\n case \"/timesheet\":\n return handleTimesheet(text, userId, channelId);\n case \"/admin-timesheet\":\n return handleAdmin(text, userId, channelId);\n default:\n return new Response(\"Unknown command\", { status: 200 });\n }\n }\n\n return new Response(\"\", { status: 200 });\n } catch (error) {\n console.error(\"Handler error:\", error);\n // Return 200 so Slack doesn't retry\n return new Response(JSON.stringify({\n response_type: \"ephemeral\",\n text: \"Something went wrong. Please try again or contact an admin.\",\n }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n}\n\nasync function handleLogtime(\n text: string, triggerId: string, userId: string, userName: string, channelId: string\n): Promise {\n const database = await getDb();\n\n if (text.trim() === \"list\") {\n const entries = await queries.getRecentEntries(database, userId, 5);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const grants = await queries.getActiveGrants(database);\n const enriched = entries.map((entry) => {\n const taskType = taskTypes.find((t) => t.id === entry.taskTypeId);\n const grant = entry.grantId ? grants.find((g) => g.id === entry.grantId) : null;\n return { ...entry, taskTypeName: taskType?.name ?? \"Unknown\", grantCode: grant?.code ?? null };\n });\n\n const blocks = buildRecentEntriesBlocks(enriched);\n await getSlack().postEphemeral(channelId, userId, \"Your recent entries:\", blocks);\n return new Response(\"\", { status: 200 });\n }\n\n const taskTypes = await queries.getActiveTaskTypes(database);\n\n if (taskTypes.length === 0) {\n await getSlack().postEphemeral(channelId, userId,\n \"No task types configured yet. Ask an admin to run: /timesheet-admin add task \\\"Task Name\\\"\");\n return new Response(\"\", { status: 200 });\n }\n\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n\n // Look up user's last project/grant selections as defaults\n const lastProjectStr = await queries.getConfig(database, `user:${userId}:last_project_id`);\n const lastGrantStr = await queries.getConfig(database, `user:${userId}:last_grant_id`);\n const userDefaults = (lastProjectStr || lastGrantStr) ? {\n projectId: lastProjectStr ? Number(lastProjectStr) : null,\n grantId: lastGrantStr ? Number(lastGrantStr) : null,\n } : undefined;\n\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, undefined, userDefaults);\n await getSlack().openModal(triggerId, modal);\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleTimesheet(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const today = todayInTimezone();\n const args = parseReportArgs(text, today);\n\n const data = await queries.getReportData(database, args.startDate, args.endDate, args.userId);\n const report = formatReport(data, args.startDate, args.endDate);\n\n await getSlack().postEphemeral(channelId, userId, report);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleAdmin(text: string, userId: string, channelId: string): Promise {\n if (!ADMIN_USER_IDS.has(userId)) {\n await getSlack().postEphemeral(channelId, userId, \"You don't have permission to use this command.\");\n return new Response(\"\", { status: 200 });\n }\n\n const database = await getDb();\n console.log(\">>> Admin raw text:\", JSON.stringify(text));\n console.log(\">>> Admin text chars:\", [...text].map(c => c.charCodeAt(0)));\n const cmd = parseAdminCommand(text);\n console.log(\">>> Admin parsed:\", JSON.stringify(cmd));\n let response = \"\";\n\n switch (cmd.action) {\n case \"add\":\n if (cmd.entity === \"project\") {\n await queries.addProject(database, cmd.args[0]);\n response = `Added project: ${cmd.args[0]}`;\n } else if (cmd.entity === \"grant\") {\n await queries.addGrant(database, cmd.args[0], cmd.args[1]);\n response = `Added grant: ${cmd.args[0]} (${cmd.args[1]})`;\n } else if (cmd.entity === \"task\") {\n await queries.addTaskType(database, cmd.args[0]);\n response = `Added task type: ${cmd.args[0]}`;\n } else if (cmd.entity === \"intern\") {\n await queries.addIntern(database, cmd.args[0], cmd.args[1]);\n response = `Registered intern: @${cmd.args[1]}`;\n }\n break;\n case \"remove\":\n if (cmd.entity === \"project\") await queries.deactivateProject(database, cmd.args[0]);\n else if (cmd.entity === \"grant\") await queries.deactivateGrant(database, cmd.args[0]);\n else if (cmd.entity === \"task\") await queries.deactivateTaskType(database, cmd.args[0]);\n else if (cmd.entity === \"intern\") await queries.removeIntern(database, cmd.args[0]);\n response = `Removed ${cmd.entity}: ${cmd.args[0]}`;\n break;\n case \"list\": {\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const interns = await queries.getInterns(database);\n response = [\n `*Projects:* ${projects.map((p) => p.name).join(\", \") || \"none\"}`,\n `*Grants:* ${grants.map((g) => `${g.code} (${g.name})`).join(\", \") || \"none\"}`,\n `*Task Types:* ${taskTypes.map((t) => t.name).join(\", \") || \"none\"}`,\n `*Interns:* ${interns.map((i) => `@${i.slackUsername}`).join(\", \") || \"none\"}`,\n ].join(\"\\n\");\n break;\n }\n case \"reminder\": {\n const VALID_REMINDER_SETTINGS = new Set([\"on\", \"off\", \"day\", \"time\"]);\n if (!VALID_REMINDER_SETTINGS.has(cmd.entity)) {\n response = `Invalid reminder setting. Use: on, off, day, or time`;\n break;\n }\n if (cmd.entity === \"on\" || cmd.entity === \"off\") {\n await queries.setConfig(database, \"reminder_enabled\", cmd.entity === \"on\" ? \"true\" : \"false\");\n response = `Reminders ${cmd.entity}`;\n } else {\n await queries.setConfig(database, `reminder_${cmd.entity}`, cmd.args[0]);\n response = `Reminder ${cmd.entity} set to: ${cmd.args[0]}`;\n }\n break;\n }\n case \"error\":\n response = cmd.args[0];\n break;\n }\n\n await getSlack().postEphemeral(channelId, userId, response);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleInteraction(payload: Record): Promise {\n const type = payload.type as string;\n const database = await getDb();\n\n if (type === \"view_submission\") {\n const view = payload.view as Record;\n const callbackId = view.callback_id as string;\n const values = view.state as { values: Record> };\n const user = payload.user as { id: string; username: string };\n\n const date = values.values.date_block.date_select.selected_date!;\n const minutes = Number(values.values.time_block.time_select.selected_option!.value);\n const taskTypeId = Number(values.values.task_block.task_select.selected_option!.value);\n const projectId = values.values.project_block?.project_select?.selected_option?.value\n ? Number(values.values.project_block.project_select.selected_option.value) : null;\n const grantId = values.values.grant_block?.grant_select?.selected_option?.value\n ? Number(values.values.grant_block.grant_select.selected_option.value) : null;\n const comment = values.values.comment_block.comment_input.value || null;\n\n if (callbackId === \"edit_time_entry\") {\n const meta = JSON.parse(view.private_metadata as string);\n const existing = await queries.getTimeEntryById(database, meta.entryId);\n if (!existing || existing.slackUserId !== user.id) {\n return new Response(JSON.stringify({\n response_action: \"errors\",\n errors: { date_block: \"Entry not found or not yours.\" },\n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n await queries.updateTimeEntry(database, meta.entryId, { date, minutes, taskTypeId, projectId, grantId, comment });\n } else {\n await queries.createTimeEntry(database, {\n slackUserId: user.id, slackUsername: user.username,\n date, minutes, taskTypeId, projectId, grantId, comment,\n });\n }\n\n // Remember user's project/grant selections for next time\n if (projectId) await queries.setConfig(database, `user:${user.id}:last_project_id`, String(projectId));\n if (grantId) await queries.setConfig(database, `user:${user.id}:last_grant_id`, String(grantId));\n\n return new Response(JSON.stringify({ response_action: \"clear\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (type === \"block_actions\") {\n const actions = payload.actions as Array<{ action_id: string; value: string }>;\n const action = actions[0];\n const user = payload.user as { id: string; username: string };\n const channel = (payload.channel as { id: string })?.id;\n\n if (action.action_id === \"delete_entry\") {\n const entryId = Number(action.value);\n const entry = await queries.getTimeEntryById(database, entryId);\n if (entry && entry.slackUserId === user.id) {\n await queries.softDeleteTimeEntry(database, entryId);\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry not found or not yours.\");\n }\n } else if (action.action_id === \"edit_entry\") {\n const entry = await queries.getTimeEntryById(database, Number(action.value));\n if (entry && entry.slackUserId === user.id) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n\n // Handle overflow menu actions (from recent entries list)\n if (action.action_id.startsWith(\"entry_overflow_\")) {\n const [actionType, entryId] = action.value?.split(\":\") ?? [];\n if (actionType === \"delete\") {\n const entry = await queries.getTimeEntryById(database, Number(entryId));\n if (entry && entry.slackUserId === user.id) {\n await queries.softDeleteTimeEntry(database, Number(entryId));\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry not found or not yours.\");\n }\n } else if (actionType === \"edit\") {\n const entry = await queries.getTimeEntryById(database, Number(entryId));\n if (entry && entry.slackUserId === user.id) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = todayInTimezone();\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n",[163],"472ee950-130e-11f1-a952-42dde27851f2","cron.ts","9ed4376c-130b-11f1-8f11-42dde27851f2",27,["D",1772108746979],"interval","// src/cron.ts\nimport { getConfig } from \"./db/queries.ts\";\nimport { getInternsWithoutEntries } from \"./handlers/reminder.ts\";\nimport { getWeekBounds, todayInTimezone } from \"./lib/format.ts\";\nimport { createSlackClient } from \"./slack/api.ts\";\nimport { migrate } from \"./db/schema.ts\";\nimport type { Database } from \"./db/types.ts\";\n\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nexport default async function reminder() {\n // Val Town provides SQLite via this import\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n const db: Database = sqlite;\n await migrate(db);\n\n const enabled = await getConfig(db, \"reminder_enabled\");\n if (enabled === \"false\") return;\n\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) return;\n const slack = createSlackClient(token);\n\n const today = todayInTimezone();\n const { start, end } = getWeekBounds(today);\n const missing = await getInternsWithoutEntries(db, start, end);\n\n for (const intern of missing) {\n try {\n await slack.sendDm(\n intern.slackUserId,\n `Hey! You haven't logged any time this week. Use /logtime to log your hours before end of day.`\n );\n } catch (error) {\n console.error(`Failed to send reminder to ${intern.slackUsername}:`, error);\n }\n }\n}\n",[172],"d9075a24-131d-11f1-8e84-42dde27851f2",".gitignore","d9075cd6-131d-11f1-8e84-42dde27851f2",50,["D",1772115434124],".env\n.vt/\n",[180],"d9114d04-131d-11f1-99f1-42dde27851f2",".env.example","d9114dfe-131d-11f1-99f1-42dde27851f2",51,["D",1772115434189],"# Slack App Credentials — get these from https://api.slack.com/apps\n# Bot User OAuth Token (OAuth & Permissions → Install to Workspace)\nSLACK_BOT_TOKEN=xoxb-your-token-here\n\n# Signing Secret (Basic Information → App Credentials)\nSLACK_SIGNING_SECRET=your-signing-secret-here\n\n# Comma-separated Slack user IDs allowed to use /admin-timesheet\n# Find your ID: Slack profile → \"...\" → Copy member ID\nADMIN_USER_IDS=U0000000000\n",[187],"9ead4e86-130b-11f1-8d22-42dde27851f2","slack","9ead4f62-130b-11f1-8d22-42dde27851f2",3,["D",1772107605282],"directory",[194],"9e8bb942-130b-11f1-a4f6-42dde27851f2","lib","9e8bba00-130b-11f1-a4f6-42dde27851f2",["D",1772107605064],[201],"9eba3b46-130b-11f1-8d22-42dde27851f2","handlers","9eba3bfa-130b-11f1-8d22-42dde27851f2",4,["D",1772107605369],[206],"569b8d22-132b-11f1-8fb2-42dde27851f2","docs","569b8e1c-132b-11f1-8fb2-42dde27851f2",67,["D",1772121228268],[212],"9e9b1bb2-130b-11f1-a4f6-42dde27851f2","db","9e9b1c5c-130b-11f1-a4f6-42dde27851f2",2,["D",1772107605164],[218],"56abeb72-132b-11f1-af4c-42dde27851f2",".git","56abec58-132b-11f1-af4c-42dde27851f2",68,["D",1772121228376],[224],"pulls","branches","forks","envVars",{"_236":196,"_238":143},"connections",{"_236":143,"_237":143},"count","unfilledCount","emptyCount",{"_41":223,"_31":224,"_29":225,"_139":-5,"_39":40,"_38":226,"_141":118,"_36":996,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":997,"_26":998},{"_41":991,"_31":946,"_29":940,"_139":225,"_39":40,"_38":992,"_141":118,"_36":993,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":994,"_26":995},{"_41":983,"_31":984,"_29":985,"_139":940,"_39":40,"_38":986,"_141":118,"_36":987,"_13":143,"_33":20,"_34":988,"_23":24,"_146":-5,"_338":989,"_26":990},{"_41":975,"_31":976,"_29":977,"_139":940,"_39":40,"_38":978,"_141":118,"_36":979,"_13":143,"_33":20,"_34":980,"_23":24,"_146":-5,"_338":981,"_26":982},{"_41":967,"_31":968,"_29":969,"_139":940,"_39":40,"_38":970,"_141":118,"_36":971,"_13":143,"_33":20,"_34":972,"_23":24,"_146":-5,"_338":973,"_26":974},{"_41":959,"_31":960,"_29":961,"_139":940,"_39":40,"_38":962,"_141":118,"_36":963,"_13":143,"_33":20,"_34":964,"_23":24,"_146":-5,"_338":965,"_26":966},{"_41":951,"_31":952,"_29":953,"_139":940,"_39":40,"_38":954,"_141":118,"_36":955,"_13":143,"_33":20,"_34":956,"_23":24,"_146":-5,"_338":957,"_26":958},{"_41":947,"_31":32,"_29":30,"_139":940,"_39":40,"_38":14,"_141":118,"_36":948,"_13":143,"_33":20,"_34":35,"_23":24,"_146":-5,"_338":949,"_26":950},{"_41":937,"_31":938,"_29":939,"_139":940,"_39":40,"_38":941,"_141":118,"_36":942,"_13":143,"_33":20,"_34":943,"_23":24,"_146":-5,"_338":944,"_26":945},{"_41":932,"_31":604,"_29":926,"_139":225,"_39":40,"_38":933,"_141":118,"_36":934,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":935,"_26":936},{"_41":923,"_31":924,"_29":925,"_139":926,"_39":40,"_38":927,"_141":118,"_36":928,"_13":143,"_33":20,"_34":929,"_23":24,"_146":-5,"_338":930,"_26":931},{"_41":918,"_31":899,"_29":893,"_139":225,"_39":40,"_38":919,"_141":118,"_36":920,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":921,"_26":922},{"_41":913,"_31":581,"_29":908,"_139":893,"_39":40,"_38":914,"_141":118,"_36":915,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":916,"_26":917},{"_41":907,"_31":583,"_29":902,"_139":908,"_39":40,"_38":909,"_141":118,"_36":910,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":911,"_26":912},{"_41":900,"_31":83,"_29":901,"_139":902,"_39":40,"_38":903,"_141":118,"_36":904,"_13":143,"_33":20,"_34":896,"_23":24,"_146":-5,"_338":905,"_26":906},{"_41":891,"_31":566,"_29":892,"_139":893,"_39":40,"_38":894,"_141":118,"_36":895,"_13":143,"_33":20,"_34":896,"_23":24,"_146":-5,"_338":897,"_26":898},{"_41":886,"_31":602,"_29":597,"_139":225,"_39":40,"_38":887,"_141":118,"_36":888,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":889,"_26":890},{"_41":879,"_31":880,"_29":881,"_139":597,"_39":40,"_38":882,"_141":118,"_36":883,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":884,"_26":885},{"_41":872,"_31":873,"_29":874,"_139":597,"_39":40,"_38":875,"_141":118,"_36":876,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":877,"_26":878},{"_41":865,"_31":866,"_29":867,"_139":597,"_39":40,"_38":868,"_141":118,"_36":869,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":870,"_26":871},{"_41":858,"_31":859,"_29":860,"_139":597,"_39":40,"_38":861,"_141":118,"_36":862,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":863,"_26":864},{"_41":851,"_31":852,"_29":853,"_139":597,"_39":40,"_38":854,"_141":118,"_36":855,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":856,"_26":857},{"_41":844,"_31":845,"_29":846,"_139":597,"_39":40,"_38":847,"_141":118,"_36":848,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":849,"_26":850},{"_41":839,"_31":838,"_29":832,"_139":597,"_39":40,"_38":840,"_141":118,"_36":841,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":842,"_26":843},{"_41":829,"_31":830,"_29":831,"_139":832,"_39":40,"_38":833,"_141":118,"_36":834,"_13":143,"_33":20,"_34":835,"_23":24,"_146":-5,"_338":836,"_26":837},{"_41":822,"_31":823,"_29":824,"_139":597,"_39":40,"_38":825,"_141":118,"_36":826,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":827,"_26":828},{"_41":817,"_31":816,"_29":810,"_139":597,"_39":40,"_38":818,"_141":118,"_36":819,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":820,"_26":821},{"_41":807,"_31":808,"_29":809,"_139":810,"_39":40,"_38":811,"_141":118,"_36":812,"_13":143,"_33":20,"_34":813,"_23":24,"_146":-5,"_338":814,"_26":815},{"_41":800,"_31":801,"_29":802,"_139":597,"_39":40,"_38":803,"_141":118,"_36":804,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":805,"_26":806},{"_41":793,"_31":794,"_29":795,"_139":597,"_39":40,"_38":796,"_141":118,"_36":797,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":798,"_26":799},{"_41":786,"_31":787,"_29":788,"_139":597,"_39":40,"_38":789,"_141":118,"_36":790,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":791,"_26":792},{"_41":779,"_31":780,"_29":781,"_139":597,"_39":40,"_38":782,"_141":118,"_36":783,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":784,"_26":785},{"_41":772,"_31":773,"_29":774,"_139":597,"_39":40,"_38":775,"_141":118,"_36":776,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":777,"_26":778},{"_41":765,"_31":766,"_29":767,"_139":597,"_39":40,"_38":768,"_141":118,"_36":769,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":770,"_26":771},{"_41":758,"_31":759,"_29":760,"_139":597,"_39":40,"_38":761,"_141":118,"_36":762,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":763,"_26":764},{"_41":751,"_31":752,"_29":753,"_139":597,"_39":40,"_38":754,"_141":118,"_36":755,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":756,"_26":757},{"_41":746,"_31":745,"_29":739,"_139":597,"_39":40,"_38":747,"_141":118,"_36":748,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":749,"_26":750},{"_41":736,"_31":737,"_29":738,"_139":739,"_39":40,"_38":740,"_141":118,"_36":741,"_13":143,"_33":20,"_34":742,"_23":24,"_146":-5,"_338":743,"_26":744},{"_41":729,"_31":730,"_29":731,"_139":597,"_39":40,"_38":732,"_141":118,"_36":733,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":734,"_26":735},{"_41":722,"_31":723,"_29":724,"_139":597,"_39":40,"_38":725,"_141":118,"_36":726,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":727,"_26":728},{"_41":717,"_31":716,"_29":710,"_139":597,"_39":40,"_38":718,"_141":118,"_36":719,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":720,"_26":721},{"_41":707,"_31":708,"_29":709,"_139":710,"_39":40,"_38":711,"_141":118,"_36":712,"_13":143,"_33":20,"_34":713,"_23":24,"_146":-5,"_338":714,"_26":715},{"_41":700,"_31":701,"_29":702,"_139":597,"_39":40,"_38":703,"_141":118,"_36":704,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":705,"_26":706},{"_41":693,"_31":694,"_29":695,"_139":597,"_39":40,"_38":696,"_141":118,"_36":697,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":698,"_26":699},{"_41":686,"_31":687,"_29":688,"_139":597,"_39":40,"_38":689,"_141":118,"_36":690,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":691,"_26":692},{"_41":679,"_31":680,"_29":681,"_139":597,"_39":40,"_38":682,"_141":118,"_36":683,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":684,"_26":685},{"_41":672,"_31":673,"_29":674,"_139":597,"_39":40,"_38":675,"_141":118,"_36":676,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":677,"_26":678},{"_41":665,"_31":666,"_29":667,"_139":597,"_39":40,"_38":668,"_141":118,"_36":669,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":670,"_26":671},{"_41":658,"_31":659,"_29":660,"_139":597,"_39":40,"_38":661,"_141":118,"_36":662,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":663,"_26":664},{"_41":651,"_31":652,"_29":653,"_139":597,"_39":40,"_38":654,"_141":118,"_36":655,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":656,"_26":657},{"_41":644,"_31":645,"_29":646,"_139":597,"_39":40,"_38":647,"_141":118,"_36":648,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":649,"_26":650},{"_41":638,"_31":218,"_29":639,"_139":597,"_39":40,"_38":640,"_141":118,"_36":641,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":642,"_26":643},{"_41":631,"_31":632,"_29":633,"_139":597,"_39":40,"_38":634,"_141":118,"_36":635,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":636,"_26":637},{"_41":624,"_31":625,"_29":626,"_139":597,"_39":40,"_38":627,"_141":118,"_36":628,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":629,"_26":630},{"_41":617,"_31":618,"_29":619,"_139":597,"_39":40,"_38":620,"_141":118,"_36":621,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":622,"_26":623},{"_41":610,"_31":611,"_29":612,"_139":597,"_39":40,"_38":613,"_141":118,"_36":614,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":615,"_26":616},{"_41":603,"_31":604,"_29":605,"_139":597,"_39":40,"_38":606,"_141":118,"_36":607,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":608,"_26":609},{"_41":594,"_31":595,"_29":596,"_139":597,"_39":40,"_38":598,"_141":118,"_36":599,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":600,"_26":601},{"_41":589,"_31":581,"_29":576,"_139":225,"_39":40,"_38":590,"_141":118,"_36":591,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":592,"_26":593},{"_41":582,"_31":583,"_29":584,"_139":576,"_39":40,"_38":585,"_141":118,"_36":586,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":587,"_26":588},{"_41":573,"_31":574,"_29":575,"_139":576,"_39":40,"_38":577,"_141":118,"_36":578,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":579,"_26":580},{"_41":565,"_31":566,"_29":567,"_139":225,"_39":40,"_38":568,"_141":118,"_36":569,"_13":143,"_33":20,"_34":570,"_23":24,"_146":-5,"_338":571,"_26":572},{"_41":557,"_31":558,"_29":559,"_139":225,"_39":40,"_38":560,"_141":118,"_36":561,"_13":143,"_33":20,"_34":562,"_23":24,"_146":-5,"_338":563,"_26":564},{"_41":550,"_31":50,"_29":551,"_139":225,"_39":40,"_38":552,"_141":118,"_36":553,"_13":143,"_33":20,"_34":554,"_23":24,"_146":-5,"_338":555,"_26":556},{"_41":217,"_31":218,"_29":219,"_139":-5,"_39":40,"_38":220,"_141":118,"_36":547,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":548,"_26":549},{"_41":539,"_31":540,"_29":541,"_139":219,"_39":40,"_38":542,"_141":118,"_36":543,"_13":59,"_33":144,"_34":544,"_23":24,"_146":-5,"_338":545,"_26":546},{"_41":531,"_31":532,"_29":533,"_139":219,"_39":40,"_38":534,"_141":118,"_36":535,"_13":59,"_33":144,"_34":536,"_23":24,"_146":-5,"_338":537,"_26":538},{"_41":523,"_31":524,"_29":525,"_139":219,"_39":40,"_38":526,"_141":118,"_36":527,"_13":59,"_33":144,"_34":528,"_23":24,"_146":-5,"_338":529,"_26":530},{"_41":515,"_31":516,"_29":517,"_139":219,"_39":40,"_38":518,"_141":118,"_36":519,"_13":59,"_33":144,"_34":520,"_23":24,"_146":-5,"_338":521,"_26":522},{"_41":507,"_31":508,"_29":509,"_139":219,"_39":40,"_38":510,"_141":24,"_36":511,"_13":59,"_33":144,"_34":512,"_23":24,"_146":-5,"_338":513,"_26":514},{"_41":499,"_31":500,"_29":501,"_139":219,"_39":40,"_38":502,"_141":118,"_36":503,"_13":143,"_33":144,"_34":504,"_23":24,"_146":-5,"_338":505,"_26":506},{"_41":211,"_31":212,"_29":213,"_139":-5,"_39":40,"_38":214,"_141":118,"_36":496,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":497,"_26":498},{"_41":491,"_31":482,"_29":476,"_139":213,"_39":40,"_38":492,"_141":118,"_36":493,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":494,"_26":495},{"_41":483,"_31":484,"_29":485,"_139":476,"_39":40,"_38":486,"_141":118,"_36":487,"_13":143,"_33":20,"_34":488,"_23":24,"_146":-5,"_338":489,"_26":490},{"_41":473,"_31":474,"_29":475,"_139":476,"_39":40,"_38":477,"_141":118,"_36":478,"_13":143,"_33":20,"_34":479,"_23":24,"_146":-5,"_338":480,"_26":481},{"_41":205,"_31":206,"_29":207,"_139":-5,"_39":40,"_38":208,"_141":118,"_36":470,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":471,"_26":472},{"_41":462,"_31":463,"_29":464,"_139":207,"_39":40,"_38":465,"_141":118,"_36":466,"_13":59,"_33":144,"_34":467,"_23":24,"_146":-5,"_338":468,"_26":469},{"_41":454,"_31":455,"_29":456,"_139":207,"_39":40,"_38":457,"_141":118,"_36":458,"_13":59,"_33":144,"_34":459,"_23":24,"_146":-5,"_338":460,"_26":461},{"_41":446,"_31":447,"_29":448,"_139":207,"_39":40,"_38":449,"_141":118,"_36":450,"_13":220,"_33":144,"_34":451,"_23":24,"_146":-5,"_338":452,"_26":453},{"_41":438,"_31":439,"_29":440,"_139":207,"_39":40,"_38":441,"_141":118,"_36":442,"_13":220,"_33":144,"_34":443,"_23":24,"_146":-5,"_338":444,"_26":445},{"_41":430,"_31":431,"_29":432,"_139":207,"_39":40,"_38":433,"_141":118,"_36":434,"_13":220,"_33":144,"_34":435,"_23":24,"_146":-5,"_338":436,"_26":437},{"_41":422,"_31":423,"_29":424,"_139":207,"_39":40,"_38":425,"_141":118,"_36":426,"_13":220,"_33":144,"_34":427,"_23":24,"_146":-5,"_338":428,"_26":429},{"_41":200,"_31":201,"_29":202,"_139":-5,"_39":40,"_38":59,"_141":118,"_36":419,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":420,"_26":421},{"_41":411,"_31":412,"_29":413,"_139":202,"_39":40,"_38":414,"_141":24,"_36":415,"_13":59,"_33":144,"_34":416,"_23":24,"_146":-5,"_338":417,"_26":418},{"_41":403,"_31":404,"_29":405,"_139":202,"_39":40,"_38":406,"_141":24,"_36":407,"_13":143,"_33":144,"_34":408,"_23":24,"_146":-5,"_338":409,"_26":410},{"_41":193,"_31":194,"_29":195,"_139":-5,"_39":40,"_38":196,"_141":118,"_36":400,"_13":143,"_33":198,"_34":-5,"_23":24,"_146":-5,"_338":401,"_26":402},{"_41":392,"_31":393,"_29":394,"_139":195,"_39":40,"_38":395,"_141":24,"_36":396,"_13":59,"_33":144,"_34":397,"_23":24,"_146":-5,"_338":398,"_26":399},{"_41":384,"_31":385,"_29":386,"_139":195,"_39":40,"_38":387,"_141":118,"_36":388,"_13":220,"_33":144,"_34":389,"_23":24,"_146":-5,"_338":390,"_26":391},{"_41":375,"_31":376,"_29":377,"_139":195,"_39":40,"_38":378,"_141":24,"_36":379,"_13":380,"_33":144,"_34":381,"_23":24,"_146":-5,"_338":382,"_26":383},{"_41":367,"_31":368,"_29":369,"_139":195,"_39":40,"_38":370,"_141":118,"_36":371,"_13":59,"_33":144,"_34":372,"_23":24,"_146":-5,"_338":373,"_26":374},{"_41":359,"_31":360,"_29":361,"_139":195,"_39":40,"_38":362,"_141":118,"_36":363,"_13":143,"_33":144,"_34":364,"_23":24,"_146":-5,"_338":365,"_26":366},{"_41":186,"_31":187,"_29":188,"_139":-5,"_39":40,"_38":189,"_141":118,"_36":356,"_13":143,"_33":20,"_34":191,"_23":24,"_146":-5,"_338":357,"_26":358},{"_41":179,"_31":180,"_29":181,"_139":-5,"_39":40,"_38":182,"_141":24,"_36":353,"_13":143,"_33":20,"_34":184,"_23":24,"_146":-5,"_338":354,"_26":355},{"_41":171,"_31":172,"_29":173,"_139":-5,"_39":40,"_38":174,"_141":118,"_36":350,"_13":59,"_33":176,"_34":177,"_23":24,"_146":-5,"_338":351,"_26":352},{"_41":162,"_31":163,"_29":164,"_139":-5,"_39":40,"_38":165,"_141":24,"_36":347,"_13":167,"_33":168,"_34":169,"_23":24,"_146":-5,"_338":348,"_26":349},{"_41":155,"_31":156,"_29":157,"_139":-5,"_39":40,"_38":158,"_141":118,"_36":344,"_13":143,"_33":20,"_34":160,"_23":24,"_146":-5,"_338":345,"_26":346},{"_41":148,"_31":149,"_29":150,"_139":-5,"_39":40,"_38":151,"_141":118,"_36":341,"_13":143,"_33":20,"_34":153,"_23":24,"_146":-5,"_338":342,"_26":343},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":118,"_36":337,"_13":143,"_33":144,"_34":145,"_23":24,"_146":-5,"_338":339,"_26":340},["D",1772121233422],"children",[],[137],["D",1772121233531],[],[149],["D",1772121233484],[],[156],["D",1772119495232],[],[163],["D",1772108746979],[],[172],["D",1772115434124],[],[180],["D",1772115434189],[],[187],"9f123e86-130b-11f1-bab2-42dde27851f2","verify.ts","9f123fe4-130b-11f1-bab2-42dde27851f2",16,["D",1772107605833],"export async function verifySlackSignature(\n body: string,\n timestamp: string,\n signature: string,\n signingSecret: string\n): Promise {\n // Reject stale requests (>5 minutes)\n const now = Math.floor(Date.now() / 1000);\n if (Math.abs(now - Number(timestamp)) > 300) {\n return false;\n }\n\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(signingSecret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const baseString = `v0:${timestamp}:${body}`;\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(baseString));\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const expected = `v0=${hex}`;\n\n // Constant-time comparison\n if (expected.length !== signature.length) return false;\n let mismatch = 0;\n for (let i = 0; i < expected.length; i++) {\n mismatch |= expected.charCodeAt(i) ^ signature.charCodeAt(i);\n }\n return mismatch === 0;\n}\n",[],[194,360],"4760902c-130e-11f1-a952-42dde27851f2","verify.test.ts","9f263710-130b-11f1-8f11-42dde27851f2",35,["D",1772108747272],"import { describe, it, expect } from \"vitest\";\nimport { verifySlackSignature } from \"./verify.ts\";\n\nconst SIGNING_SECRET = \"test_secret_12345\";\n\ndescribe(\"verifySlackSignature\", () => {\n it(\"returns true for valid signature\", async () => {\n const timestamp = Math.floor(Date.now() / 1000).toString();\n const body = \"token=xyzz0WbapA4vBCDEFaYZlElrm&command=%2Flogtime\";\n\n // Compute expected signature\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(SIGNING_SECRET),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n const sig = await crypto.subtle.sign(\n \"HMAC\",\n key,\n encoder.encode(`v0:${timestamp}:${body}`)\n );\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const signature = `v0=${hex}`;\n\n const result = await verifySlackSignature(\n body,\n timestamp,\n signature,\n SIGNING_SECRET\n );\n expect(result).toBe(true);\n });\n\n it(\"returns false for invalid signature\", async () => {\n const result = await verifySlackSignature(\n \"body\",\n String(Math.floor(Date.now() / 1000)),\n \"v0=invalid\",\n SIGNING_SECRET\n );\n expect(result).toBe(false);\n });\n\n it(\"returns false for stale timestamp (>5 min)\", async () => {\n const staleTimestamp = (Math.floor(Date.now() / 1000) - 600).toString();\n const result = await verifySlackSignature(\n \"body\",\n staleTimestamp,\n \"v0=anything\",\n SIGNING_SECRET\n );\n expect(result).toBe(false);\n });\n});\n",[],[194,368],"4da7e3fe-1327-11f1-b368-42dde27851f2","modals.ts","9f08bdb6-130b-11f1-8d22-42dde27851f2",66,["D",1772119495245],7,"import type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts\";\nimport { formatDuration } from \"../lib/format.ts\";\n\ninterface ModalView {\n type: \"modal\";\n callback_id: string;\n title: { type: \"plain_text\"; text: string };\n submit?: { type: \"plain_text\"; text: string };\n blocks: unknown[];\n private_metadata?: string;\n}\n\ninterface EditPrefill {\n id: number;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\ninterface UserDefaults {\n projectId: number | null;\n grantId: number | null;\n}\n\nexport function buildLogtimeModal(\n taskTypes: TaskType[],\n projects: Project[],\n grants: Grant[],\n today: string,\n prefill?: EditPrefill,\n defaults?: UserDefaults\n): ModalView {\n const timeOptions = [];\n for (let h = 0; h <= 12; h++) {\n for (const m of [0, 15, 30, 45]) {\n const total = h * 60 + m;\n if (total === 0) continue;\n timeOptions.push({\n text: { type: \"plain_text\", text: formatDuration(total) },\n value: String(total),\n });\n }\n }\n\n return {\n type: \"modal\",\n callback_id: prefill ? \"edit_time_entry\" : \"log_time_entry\",\n title: { type: \"plain_text\", text: \"Log Time\" },\n submit: { type: \"plain_text\", text: \"Submit\" },\n private_metadata: prefill ? JSON.stringify({ entryId: prefill.id }) : undefined,\n blocks: [\n {\n type: \"input\",\n block_id: \"date_block\",\n label: { type: \"plain_text\", text: \"Date\" },\n element: {\n type: \"datepicker\",\n action_id: \"date_select\",\n initial_date: prefill?.date ?? today,\n placeholder: { type: \"plain_text\", text: \"Choose a date\" },\n },\n },\n {\n type: \"input\",\n block_id: \"time_block\",\n label: { type: \"plain_text\", text: \"Time Worked\" },\n element: {\n type: \"static_select\",\n action_id: \"time_select\",\n options: timeOptions,\n placeholder: { type: \"plain_text\", text: \"Select duration\" },\n ...(prefill?.minutes ? { initial_option: timeOptions.find((o) => o.value === String(prefill.minutes)) } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"task_block\",\n label: { type: \"plain_text\", text: \"Task\" },\n element: {\n type: \"static_select\",\n action_id: \"task_select\",\n options: taskTypes.map((t) => ({ text: { type: \"plain_text\", text: t.name }, value: String(t.id) })),\n ...(prefill?.taskTypeId ? { initial_option: { text: { type: \"plain_text\", text: taskTypes.find((t) => t.id === prefill.taskTypeId)?.name ?? \"\" }, value: String(prefill.taskTypeId) } } : {}),\n },\n },\n ...(projects.length > 0 ? [(() => {\n const selectedProjectId = prefill?.projectId ?? defaults?.projectId;\n const selectedProject = selectedProjectId ? projects.find((p) => p.id === selectedProjectId) : null;\n return {\n type: \"input\",\n block_id: \"project_block\",\n label: { type: \"plain_text\", text: \"Project\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"project_select\",\n options: projects.map((p) => ({ text: { type: \"plain_text\", text: p.name }, value: String(p.id) })),\n ...(selectedProject ? { initial_option: { text: { type: \"plain_text\", text: selectedProject.name }, value: String(selectedProject.id) } } : {}),\n },\n };\n })()] : []),\n ...(grants.length > 0 ? [(() => {\n const selectedGrantId = prefill?.grantId ?? defaults?.grantId;\n const selectedGrant = selectedGrantId ? grants.find((g) => g.id === selectedGrantId) : null;\n return {\n type: \"input\",\n block_id: \"grant_block\",\n label: { type: \"plain_text\", text: \"Grant\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"grant_select\",\n options: grants.map((g) => ({ text: { type: \"plain_text\", text: `${g.code} — ${g.name}` }, value: String(g.id) })),\n ...(selectedGrant ? { initial_option: { text: { type: \"plain_text\", text: `${selectedGrant.code} — ${selectedGrant.name}` }, value: String(selectedGrant.id) } } : {}),\n },\n };\n })()] : []),\n {\n type: \"input\",\n block_id: \"comment_block\",\n label: { type: \"plain_text\", text: \"Comment\" },\n optional: true,\n element: {\n type: \"plain_text_input\",\n action_id: \"comment_input\",\n multiline: true,\n placeholder: { type: \"plain_text\", text: \"What did you work on?\" },\n ...(prefill?.comment ? { initial_value: prefill.comment } : {}),\n },\n },\n ],\n };\n}\n\nexport function buildConfirmationBlocks(\n entryId: number,\n duration: string,\n taskName: string,\n dateDisplay: string,\n grantCode: string | null\n): unknown[] {\n const grantSuffix = grantCode ? ` (${grantCode})` : \"\";\n return [\n {\n type: \"section\",\n text: { type: \"mrkdwn\", text: `Logged *${duration}* of *${taskName}* on ${dateDisplay}${grantSuffix}` },\n },\n {\n type: \"actions\",\n elements: [\n { type: \"button\", text: { type: \"plain_text\", text: \"Edit\" }, action_id: \"edit_entry\", value: String(entryId) },\n { type: \"button\", text: { type: \"plain_text\", text: \"Delete\" }, action_id: \"delete_entry\", value: String(entryId), style: \"danger\" },\n ],\n },\n ];\n}\n\nexport function buildRecentEntriesBlocks(\n entries: Array\n): unknown[] {\n if (entries.length === 0) {\n return [{ type: \"section\", text: { type: \"mrkdwn\", text: \"No recent entries found.\" } }];\n }\n\n const blocks: unknown[] = [\n { type: \"section\", text: { type: \"mrkdwn\", text: \"*Your recent entries:*\" } },\n ];\n\n for (const entry of entries) {\n const grant = entry.grantCode ? ` (${entry.grantCode})` : \"\";\n blocks.push({\n type: \"section\",\n text: { type: \"mrkdwn\", text: `${entry.date} — ${formatDuration(entry.minutes)} ${entry.taskTypeName}${grant}` },\n accessory: {\n type: \"overflow\",\n action_id: `entry_overflow_${entry.id}`,\n options: [\n { text: { type: \"plain_text\", text: \"Edit\" }, value: `edit:${entry.id}` },\n { text: { type: \"plain_text\", text: \"Delete\" }, value: `delete:${entry.id}` },\n ],\n },\n });\n }\n\n return blocks;\n}\n",[],[194,376],"98895470-130e-11f1-ba19-42dde27851f2","modals.test.ts","9f19dac4-130b-11f1-aa87-42dde27851f2",45,["D",1772108882814],"import { describe, it, expect } from \"vitest\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./modals.ts\";\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts\";\n\ndescribe(\"buildLogtimeModal\", () => {\n const taskTypes: TaskType[] = [{ id: 1, name: \"Transcription\" }, { id: 2, name: \"Metadata Editing\" }];\n const projects: Project[] = [{ id: 1, name: \"Lakeland\" }];\n const grants: Grant[] = [{ id: 1, code: \"NEH-PW-290261\", name: \"NEH\" }];\n\n it(\"builds a valid Block Kit modal with all dropdowns\", () => {\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\");\n\n expect(modal.type).toBe(\"modal\");\n expect(modal.title.text).toBe(\"Log Time\");\n expect(modal.submit!.text).toBe(\"Submit\");\n // Should have blocks for: date, time, task, project, grant, comment\n expect(modal.blocks.length).toBeGreaterThanOrEqual(6);\n });\n\n it(\"builds modal pre-filled for editing\", () => {\n const existing = {\n id: 42,\n date: \"2026-02-25\",\n minutes: 90,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Test\",\n };\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\", existing);\n\n // private_metadata should contain the entry ID for update\n expect(modal.private_metadata).toContain(\"42\");\n });\n});\n\ndescribe(\"buildConfirmationBlocks\", () => {\n it(\"builds confirmation message with edit/delete buttons\", () => {\n const blocks = buildConfirmationBlocks(42, \"1h\", \"Transcription\", \"Feb 26\", \"NEH-PW-290261\");\n\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"edit\");\n expect(text).toContain(\"delete\");\n });\n});\n\ndescribe(\"buildRecentEntriesBlocks\", () => {\n it(\"builds blocks for recent entries with edit/delete buttons\", () => {\n const entries: Array = [\n {\n id: 1, slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-26\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n createdAt: \"2026-02-26T10:00:00\", taskTypeName: \"Transcription\", grantCode: null,\n },\n ];\n\n const blocks = buildRecentEntriesBlocks(entries);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"1h\");\n });\n\n it(\"shows message when no entries\", () => {\n const blocks = buildRecentEntriesBlocks([]);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"No recent entries\");\n });\n});\n",[],[194,385],"8591f1c8-1323-11f1-ae64-42dde27851f2","api.ts","9f0e25c6-130b-11f1-8e57-42dde27851f2",57,["D",1772117871080],"export interface SlackClient {\n openModal(triggerId: string, view: unknown): Promise;\n postEphemeral(channel: string, userId: string, text: string, blocks?: unknown[]): Promise;\n sendDm(userId: string, text: string): Promise;\n}\n\nexport function createSlackClient(botToken: string): SlackClient {\n async function slackApi(method: string, body: unknown): Promise {\n const response = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(body),\n });\n const data = await response.json();\n if (!data.ok) {\n console.error(`Slack API error (${method}):`, JSON.stringify(data));\n throw new Error(`Slack API error (${method}): ${data.error}`);\n }\n return data;\n }\n\n return {\n async openModal(triggerId, view) {\n await slackApi(\"views.open\", { trigger_id: triggerId, view });\n },\n async postEphemeral(channel, userId, text, blocks) {\n await slackApi(\"chat.postEphemeral\", { channel, user: userId, text, blocks });\n },\n async sendDm(userId, text) {\n const conv = (await slackApi(\"conversations.open\", { users: userId })) as { channel: { id: string } };\n await slackApi(\"chat.postMessage\", { channel: conv.channel.id, text });\n },\n };\n}\n",[],[194,393],["D",1772107605282],[325,326,327,328,329],[194],"9ed083ba-130b-11f1-8e57-42dde27851f2","format.ts","9ed0848c-130b-11f1-8e57-42dde27851f2",6,["D",1772107605513],"export function todayInTimezone(tz: string = \"America/New_York\"): string {\n return new Intl.DateTimeFormat(\"en-CA\", { timeZone: tz }).format(new Date());\n // en-CA locale gives YYYY-MM-DD format\n}\n\nexport function formatDuration(minutes: number): string {\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hours === 0) return `${mins}m`;\n if (mins === 0) return `${hours}h`;\n return `${hours}h ${mins}m`;\n}\n\nconst MONTHS = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\n\nexport function formatDateRange(start: string, end: string): string {\n const s = new Date(start + \"T00:00:00\");\n const e = new Date(end + \"T00:00:00\");\n return `${MONTHS[s.getMonth()]} ${s.getDate()} \\u2013 ${MONTHS[e.getMonth()]} ${e.getDate()}, ${e.getFullYear()}`;\n}\n\nexport function getWeekBounds(dateStr: string): { start: string; end: string } {\n const date = new Date(dateStr + \"T00:00:00\");\n const day = date.getDay(); // 0=Sun, 1=Mon...\n const diffToMonday = day === 0 ? -6 : 1 - day;\n const monday = new Date(date);\n monday.setDate(date.getDate() + diffToMonday);\n const sunday = new Date(monday);\n sunday.setDate(monday.getDate() + 6);\n return {\n start: monday.toISOString().slice(0, 10),\n end: sunday.toISOString().slice(0, 10),\n };\n}\n\nexport function getLast7Days(fromDate: string): string[] {\n const days: string[] = [];\n const date = new Date(fromDate + \"T00:00:00\");\n for (let i = 0; i < 7; i++) {\n const d = new Date(date);\n d.setDate(date.getDate() - i);\n days.push(d.toISOString().slice(0, 10));\n }\n return days;\n}\n",[],[201,404],"47499caa-130e-11f1-bb59-42dde27851f2","format.test.ts","9f33d7bc-130b-11f1-882b-42dde27851f2",32,["D",1772108746989],"import { describe, it, expect } from \"vitest\";\nimport { formatDuration, formatDateRange, getWeekBounds, getLast7Days, todayInTimezone } from \"./format.ts\";\n\ndescribe(\"todayInTimezone\", () => {\n it(\"returns a valid ISO date string\", () => {\n const today = todayInTimezone(\"America/New_York\");\n expect(today).toMatch(/^\\d{4}-\\d{2}-\\d{2}$/);\n });\n});\n\ndescribe(\"formatDuration\", () => {\n it(\"formats minutes as hours and minutes\", () => {\n expect(formatDuration(60)).toBe(\"1h\");\n expect(formatDuration(90)).toBe(\"1h 30m\");\n expect(formatDuration(15)).toBe(\"15m\");\n expect(formatDuration(480)).toBe(\"8h\");\n expect(formatDuration(0)).toBe(\"0m\");\n });\n});\n\ndescribe(\"formatDateRange\", () => {\n it(\"formats a date range for display\", () => {\n expect(formatDateRange(\"2026-02-24\", \"2026-02-28\")).toBe(\"Feb 24 – Feb 28, 2026\");\n });\n\n it(\"handles cross-month ranges\", () => {\n expect(formatDateRange(\"2026-01-28\", \"2026-02-03\")).toBe(\"Jan 28 – Feb 3, 2026\");\n });\n});\n\ndescribe(\"getWeekBounds\", () => {\n it(\"returns Monday–Sunday for a given date\", () => {\n // Feb 26 2026 is a Thursday\n const { start, end } = getWeekBounds(\"2026-02-26\");\n expect(start).toBe(\"2026-02-23\"); // Monday\n expect(end).toBe(\"2026-03-01\"); // Sunday\n });\n});\n\ndescribe(\"getLast7Days\", () => {\n it(\"returns last 7 days in descending order\", () => {\n const days = getLast7Days(\"2026-02-26\");\n expect(days).toHaveLength(7);\n expect(days[0]).toBe(\"2026-02-26\");\n expect(days[6]).toBe(\"2026-02-20\");\n });\n});\n",[],[201,412],["D",1772107605064],[322,323],[201],"982461a0-130e-11f1-adc1-42dde27851f2","report.ts","9f2180d0-130b-11f1-bab2-42dde27851f2",43,["D",1772108882809],"import type { ReportRow } from \"../db/queries.ts\";\nimport { formatDuration, formatDateRange, getWeekBounds } from \"../lib/format.ts\";\n\nexport interface ReportArgs {\n userId: string | null;\n startDate: string;\n endDate: string;\n}\n\nexport function parseReportArgs(text: string, today: string): ReportArgs {\n const trimmed = text.trim();\n let userId: string | null = null;\n\n // Extract user mention\n let remaining = trimmed;\n const userMatch = remaining.match(/<@(\\w+)\\|[^>]+>/);\n if (userMatch) {\n userId = userMatch[1];\n remaining = remaining.replace(userMatch[0], \"\").trim();\n }\n\n // Extract dates\n const dateMatch = remaining.match(/(\\d{4}-\\d{2}-\\d{2})\\s+(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n return { userId, startDate: dateMatch[1], endDate: dateMatch[2] };\n }\n\n // Default: current week\n const { start, end } = getWeekBounds(today);\n return { userId, startDate: start, endDate: end };\n}\n\nexport function formatReport(data: ReportRow[], startDate: string, endDate: string): string {\n const header = `*Timesheet Report: ${formatDateRange(startDate, endDate)}*\\n`;\n\n if (data.length === 0) {\n return header + \"\\nNo time entries found for this period.\";\n }\n\n // Group by user\n const byUser = new Map();\n for (const row of data) {\n if (!byUser.has(row.slackUserId)) {\n byUser.set(row.slackUserId, { username: row.slackUsername, rows: [], total: 0 });\n }\n const user = byUser.get(row.slackUserId)!;\n user.rows.push(row);\n user.total += row.totalMinutes;\n }\n\n let grandTotal = 0;\n const lines: string[] = [header];\n\n for (const [, user] of byUser) {\n grandTotal += user.total;\n lines.push(`*@${user.username}* — ${formatDuration(user.total)}`);\n for (const row of user.rows) {\n const grant = row.grantCode ? ` (${row.grantCode})` : \"\";\n lines.push(` ${row.taskTypeName} ${formatDuration(row.totalMinutes)}${grant}`);\n }\n lines.push(\"\");\n }\n\n lines.push(`*Total: ${formatDuration(grandTotal)} across ${byUser.size} intern${byUser.size === 1 ? \"\" : \"s\"}*`);\n\n return lines.join(\"\\n\");\n}\n",[],[206,423],"98934dea-130e-11f1-adc1-42dde27851f2","report.test.ts","9f39052a-130b-11f1-8acc-42dde27851f2",46,["D",1772108882901],"import { describe, it, expect } from \"vitest\";\nimport { formatReport, parseReportArgs } from \"./report.ts\";\nimport type { ReportRow } from \"../db/queries.ts\";\n\ndescribe(\"formatReport\", () => {\n it(\"formats a multi-user report\", () => {\n const data: ReportRow[] = [\n { slackUserId: \"U456\", slackUsername: \"james\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 480 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Metadata Editing\", grantCode: null, totalMinutes: 360 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 720 },\n ];\n\n const output = formatReport(data, \"2026-02-24\", \"2026-02-28\");\n\n expect(output).toContain(\"Feb 24 – Feb 28, 2026\");\n expect(output).toContain(\"james\");\n expect(output).toContain(\"maria\");\n expect(output).toContain(\"8h\"); // james total\n expect(output).toContain(\"18h\"); // maria total\n expect(output).toContain(\"26h\"); // grand total\n expect(output).toContain(\"NEH-PW-290261\");\n });\n\n it(\"handles empty data\", () => {\n const output = formatReport([], \"2026-02-24\", \"2026-02-28\");\n expect(output).toContain(\"No time entries\");\n });\n});\n\ndescribe(\"parseReportArgs\", () => {\n it(\"defaults to current week, all users\", () => {\n const result = parseReportArgs(\"\", \"2026-02-26\");\n expect(result.userId).toBeNull();\n expect(result.startDate).toBe(\"2026-02-23\"); // Monday\n expect(result.endDate).toBe(\"2026-03-01\"); // Sunday\n });\n\n it(\"parses user mention\", () => {\n const result = parseReportArgs(\"<@U123|maria>\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n });\n\n it(\"parses date range\", () => {\n const result = parseReportArgs(\"2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n\n it(\"parses user + date range\", () => {\n const result = parseReportArgs(\"<@U123|maria> 2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n});\n",[],[206,431],"98ea8844-130e-11f1-89cd-42dde27851f2","reminder.ts","9f1deff6-130b-11f1-8acc-42dde27851f2",47,["D",1772108882817],"import type { Database } from \"../db/types.ts\";\nimport type { Intern } from \"../db/queries.ts\";\n\nexport async function getInternsWithoutEntries(\n db: Database,\n startDate: string,\n endDate: string\n): Promise {\n const result = await db.execute({\n sql: `SELECT i.slack_user_id, i.slack_username\n FROM interns i\n WHERE i.slack_user_id NOT IN (\n SELECT DISTINCT te.slack_user_id FROM time_entries te\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL\n )\n ORDER BY i.slack_username`,\n args: [startDate, endDate],\n });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n",[],[206,439],"9837f044-130e-11f1-a0d0-42dde27851f2","reminder.test.ts","9f2ae922-130b-11f1-aa87-42dde27851f2",44,["D",1772108882845],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"../db/test-helpers.ts\";\nimport { migrate } from \"../db/schema.ts\";\nimport { addIntern, addTaskType, createTimeEntry } from \"../db/queries.ts\";\nimport { getInternsWithoutEntries } from \"./reminder.ts\";\nimport type { Database } from \"../db/types.ts\";\n\ndescribe(\"getInternsWithoutEntries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n });\n\n it(\"returns interns who have not logged time in the date range\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(1);\n expect(missing[0].slackUserId).toBe(\"U456\");\n });\n\n it(\"returns all interns when nobody logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(2);\n });\n\n it(\"returns empty when all interns logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(0);\n });\n});\n",[],[206,447],"d63358a4-1320-11f1-96f1-42dde27851f2","admin.ts","9f3025f4-130b-11f1-bab2-42dde27851f2",54,["D",1772116717865],"export interface AdminCommand {\n action: string;\n entity: string | null;\n args: string[];\n}\n\nexport function parseAdminCommand(text: string): AdminCommand {\n const trimmed = text.trim();\n\n // \"list\"\n if (trimmed === \"list\") {\n return { action: \"list\", entity: null, args: [] };\n }\n\n // \"reminder day friday\" / \"reminder off\" / \"reminder on\" / \"reminder time 15:00\"\n const reminderMatch = trimmed.match(/^reminder\\s+(\\S+)(?:\\s+(.+))?$/);\n if (reminderMatch) {\n const subcommand = reminderMatch[1];\n const value = reminderMatch[2];\n return { action: \"reminder\", entity: subcommand, args: value ? [value] : [] };\n }\n\n // \"intern add <@U123|maria>\" / \"intern remove <@U123|maria>\"\n const internMatch = trimmed.match(/^intern\\s+(add|remove)\\s+<@(\\w+)\\|([^>]+)>/);\n if (internMatch) {\n return { action: internMatch[1], entity: \"intern\", args: [internMatch[2], internMatch[3]] };\n }\n\n // \"add project \"Name\"\" / \"remove task \"Name\"\"\n const crudMatch = trimmed.match(/^(add|remove)\\s+(project|grant|task)\\s+(.+)$/);\n if (crudMatch) {\n const action = crudMatch[1];\n const entity = crudMatch[2];\n const rawArgs = crudMatch[3];\n\n // Extract quoted strings (handle straight and smart/curly quotes from Slack)\n const normalized = rawArgs.replace(/[\\u201c\\u201d\\u2018\\u2019]/g, '\"');\n const quoted = [...normalized.matchAll(/\"([^\"]+)\"/g)].map((m) => m[1]);\n if (quoted.length > 0) {\n return { action, entity, args: quoted };\n }\n return { action, entity, args: [rawArgs.trim()] };\n }\n\n return {\n action: \"error\",\n entity: null,\n args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"],\n };\n}\n",[],[206,455],"4779535a-130e-11f1-bb59-42dde27851f2","admin.test.ts","9f4014c8-130b-11f1-aa87-42dde27851f2",39,["D",1772108747466],"import { describe, it, expect } from \"vitest\";\nimport { parseAdminCommand } from \"./admin.ts\";\n\ndescribe(\"parseAdminCommand\", () => {\n it(\"parses add project\", () => {\n expect(parseAdminCommand('add project \"Community Oral Histories\"'))\n .toEqual({ action: \"add\", entity: \"project\", args: [\"Community Oral Histories\"] });\n });\n\n it(\"parses add grant with code and name\", () => {\n expect(parseAdminCommand('add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"'))\n .toEqual({ action: \"add\", entity: \"grant\", args: [\"NEH-PW-290261\", \"NEH Preservation & Access\"] });\n });\n\n it(\"parses add task\", () => {\n expect(parseAdminCommand('add task \"Scanning\"'))\n .toEqual({ action: \"add\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses remove task\", () => {\n expect(parseAdminCommand('remove task \"Scanning\"'))\n .toEqual({ action: \"remove\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses list\", () => {\n expect(parseAdminCommand(\"list\"))\n .toEqual({ action: \"list\", entity: null, args: [] });\n });\n\n it(\"parses intern add with user mention\", () => {\n expect(parseAdminCommand(\"intern add <@U123|maria>\"))\n .toEqual({ action: \"add\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses intern remove\", () => {\n expect(parseAdminCommand(\"intern remove <@U123|maria>\"))\n .toEqual({ action: \"remove\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses reminder config\", () => {\n expect(parseAdminCommand(\"reminder day friday\"))\n .toEqual({ action: \"reminder\", entity: \"day\", args: [\"friday\"] });\n expect(parseAdminCommand(\"reminder off\"))\n .toEqual({ action: \"reminder\", entity: \"off\", args: [] });\n });\n\n it(\"returns error for unrecognized commands\", () => {\n expect(parseAdminCommand(\"do something weird\"))\n .toEqual({ action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] });\n });\n});\n",[],[206,463],["D",1772107605369],[315,316,317,318,319,320],[206],"59c789d8-132b-11f1-8f1f-42dde27851f2","2026-02-26-timesheet-implementation.md","59c78a8c-132b-11f1-8f1f-42dde27851f2","56b8b096-132b-11f1-8e0b-42dde27851f2",121,["D",1772121233546],"# Lakeland Timesheet Implementation Plan\n\n> **For Claude:** REQUIRED SUB-SKILL: Use superpowers:executing-plans to implement this plan task-by-task.\n\n**Goal:** Build a Slack timesheet app on Val Town for interns to log hours and managers to run reports.\n\n**Architecture:** Single HTTP val as request router + cron val for weekly reminders. Pure TypeScript business logic tested locally with Vitest; Val Town SQLite for persistence; Slack Block Kit for UI.\n\n**Tech Stack:** Val Town (HTTP + cron vals), TypeScript, Vitest, Val Town SQLite (`@libsql/client`), Slack Block Kit, `vt` CLI for local dev.\n\n**TDD approach:** All business logic is pure functions — tested locally with Vitest. Platform boundaries (SQLite, Slack API) are injected as dependencies so tests use in-memory fakes.\n\n---\n\n## Development Environment\n\n**Val Town CLI (`vt`):**\n```bash\ndeno install -grAf jsr:@valtown/vt\nvt # authenticate with API key from val.town/settings/api\n```\n\n**Val Town MCP (for Claude Code):**\n```bash\nclaude mcp add --transport http val-town https://api.val.town/v3/mcp\n```\n\n**Local testing:** Vitest runs against pure business logic. No Val Town runtime needed for tests.\n\n---\n\n## Task 1: Project Scaffold & Tooling\n\n**Files:**\n- Create: `package.json`\n- Create: `tsconfig.json`\n- Create: `vitest.config.ts`\n- Create: `.gitignore`\n- Create: `src/db/types.ts`\n\n**Step 1: Initialize npm project**\n\n```bash\ncd /Users/trevormunoz/Code/lakeland-timesheet\nnpm init -y\n```\n\n**Step 2: Install dev dependencies**\n\n```bash\nnpm install -D vitest typescript @libsql/client\n```\n\nNote: `@libsql/client` is both a dev dependency (for types in tests) and the runtime import on Val Town. Val Town provides it at `https://esm.town/v/std/sqlite`.\n\n**Step 3: Create tsconfig.json**\n\n```json\n{\n \"compilerOptions\": {\n \"target\": \"ES2022\",\n \"module\": \"ES2022\",\n \"moduleResolution\": \"bundler\",\n \"strict\": true,\n \"esModuleInterop\": true,\n \"outDir\": \"dist\",\n \"rootDir\": \"src\",\n \"declaration\": true,\n \"sourceMap\": true,\n \"forceConsistentCasingInFileNames\": true,\n \"skipLibCheck\": true\n },\n \"include\": [\"src/**/*\"],\n \"exclude\": [\"node_modules\", \"dist\"]\n}\n```\n\n**Step 4: Create vitest.config.ts**\n\n```typescript\nimport { defineConfig } from \"vitest/config\";\n\nexport default defineConfig({\n test: {\n include: [\"src/**/*.test.ts\"],\n },\n});\n```\n\n**Step 5: Create .gitignore**\n\n```\nnode_modules/\ndist/\n.env\n```\n\n**Step 6: Create the database abstraction type**\n\nThis is the key to testability. All database operations go through this interface — Val Town SQLite in production, an in-memory fake in tests.\n\n```typescript\n// src/db/types.ts\nexport interface DbResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n}\n\nexport interface Database {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n}\n```\n\n**Step 7: Add test script to package.json**\n\nAdd to scripts: `\"test\": \"vitest\", \"test:run\": \"vitest run\"`\n\n**Step 8: Commit**\n\n```bash\ngit add package.json tsconfig.json vitest.config.ts .gitignore src/db/types.ts\ngit commit -m \"chore: project scaffold with Vitest and database abstraction\"\n```\n\n---\n\n## Task 2: Database Schema & Migration\n\n**Files:**\n- Create: `src/db/schema.ts`\n- Create: `src/db/schema.test.ts`\n- Create: `src/db/test-helpers.ts`\n\n**Step 1: Create the test helper — in-memory SQLite fake**\n\n```typescript\n// src/db/test-helpers.ts\nimport { Database as LibSqlDatabase, createClient } from \"@libsql/client\";\nimport type { Database, DbResult } from \"./types.js\";\n\n/**\n * Creates an in-memory SQLite database for testing.\n * Uses @libsql/client with file::memory: URL.\n */\nexport async function createTestDb(): Promise {\n const client = createClient({ url: \"file::memory:\" });\n return {\n async execute(query) {\n const result = await client.execute(query);\n return {\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n };\n },\n async batch(queries) {\n const results = await client.batch(\n queries.map((q) => (typeof q === \"string\" ? q : q))\n );\n return results.map((result) => ({\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n }));\n },\n };\n}\n```\n\n**Step 2: Write the failing test**\n\n```typescript\n// src/db/schema.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.js\";\nimport { migrate } from \"./schema.js\";\nimport type { Database } from \"./types.js\";\n\ndescribe(\"schema migration\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n });\n\n it(\"creates all required tables\", async () => {\n await migrate(db);\n\n const result = await db.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table' ORDER BY name\",\n });\n const tables = result.rows.map((r) => r[0]);\n\n expect(tables).toContain(\"projects\");\n expect(tables).toContain(\"grants\");\n expect(tables).toContain(\"task_types\");\n expect(tables).toContain(\"time_entries\");\n expect(tables).toContain(\"interns\");\n expect(tables).toContain(\"config\");\n });\n\n it(\"is idempotent — running twice does not error\", async () => {\n await migrate(db);\n await expect(migrate(db)).resolves.not.toThrow();\n });\n});\n```\n\n**Step 3: Run test to verify it fails**\n\nRun: `npx vitest run src/db/schema.test.ts`\nExpected: FAIL — `migrate` is not exported from `./schema.js`\n\n**Step 4: Implement schema.ts**\n\n```typescript\n// src/db/schema.ts\nimport type { Database } from \"./types.js\";\n\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n];\n\nexport async function migrate(db: Database): Promise {\n await db.batch(SCHEMA);\n}\n```\n\n**Step 5: Run test to verify it passes**\n\nRun: `npx vitest run src/db/schema.test.ts`\nExpected: PASS (2 tests)\n\n**Step 6: Commit**\n\n```bash\ngit add src/db/\ngit commit -m \"feat(db): schema migration with all tables\"\n```\n\n---\n\n## Task 3: Database Queries — Lookup Table CRUD\n\n**Files:**\n- Create: `src/db/queries.ts`\n- Create: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests for lookup CRUD**\n\n```typescript\n// src/db/queries.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.js\";\nimport { migrate } from \"./schema.js\";\nimport {\n addProject,\n addGrant,\n addTaskType,\n getActiveProjects,\n getActiveGrants,\n getActiveTaskTypes,\n deactivateProject,\n deactivateGrant,\n deactivateTaskType,\n} from \"./queries.js\";\nimport type { Database } from \"./types.js\";\n\ndescribe(\"lookup table CRUD\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n describe(\"projects\", () => {\n it(\"adds and retrieves active projects\", async () => {\n await addProject(db, \"Lakeland Digital Archive\");\n await addProject(db, \"Community Oral Histories\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(2);\n expect(projects[0].name).toBe(\"Community Oral Histories\");\n expect(projects[1].name).toBe(\"Lakeland Digital Archive\");\n });\n\n it(\"deactivates a project without deleting it\", async () => {\n await addProject(db, \"Old Project\");\n await deactivateProject(db, \"Old Project\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(0);\n });\n });\n\n describe(\"grants\", () => {\n it(\"adds and retrieves active grants\", async () => {\n await addGrant(db, \"NEH-PW-290261\", \"NEH Preservation & Access\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(1);\n expect(grants[0].code).toBe(\"NEH-PW-290261\");\n expect(grants[0].name).toBe(\"NEH Preservation & Access\");\n });\n\n it(\"deactivates a grant\", async () => {\n await addGrant(db, \"NEH-PW-290261\", \"NEH Preservation\");\n await deactivateGrant(db, \"NEH-PW-290261\");\n\n expect(await getActiveGrants(db)).toHaveLength(0);\n });\n });\n\n describe(\"task types\", () => {\n it(\"adds and retrieves active task types\", async () => {\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(2);\n });\n\n it(\"deactivates a task type\", async () => {\n await addTaskType(db, \"Scanning\");\n await deactivateTaskType(db, \"Scanning\");\n\n expect(await getActiveTaskTypes(db)).toHaveLength(0);\n });\n });\n});\n```\n\n**Step 2: Run test to verify it fails**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: FAIL — functions not exported\n\n**Step 3: Implement lookup CRUD in queries.ts**\n\n```typescript\n// src/db/queries.ts\nimport type { Database } from \"./types.js\";\n\n// --- Lookup types ---\n\nexport interface Project {\n id: number;\n name: string;\n}\n\nexport interface Grant {\n id: number;\n code: string;\n name: string;\n}\n\nexport interface TaskType {\n id: number;\n name: string;\n}\n\n// --- Projects ---\n\nexport async function addProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO projects (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveProjects(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM projects WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, name: r[1] as string }));\n}\n\nexport async function deactivateProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"UPDATE projects SET active = 0 WHERE name = ?\", args: [name] });\n}\n\n// --- Grants ---\n\nexport async function addGrant(db: Database, code: string, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO grants (code, name) VALUES (?, ?)\", args: [code, name] });\n}\n\nexport async function getActiveGrants(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, code, name FROM grants WHERE active = 1 ORDER BY code\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, code: r[1] as string, name: r[2] as string }));\n}\n\nexport async function deactivateGrant(db: Database, code: string): Promise {\n await db.execute({ sql: \"UPDATE grants SET active = 0 WHERE code = ?\", args: [code] });\n}\n\n// --- Task Types ---\n\nexport async function addTaskType(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO task_types (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveTaskTypes(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM task_types WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((r) => ({ id: r[0] as number, name: r[1] as string }));\n}\n\nexport async function deactivateTaskType(db: Database, name: string): Promise {\n await db.execute({ sql: \"UPDATE task_types SET active = 0 WHERE name = ?\", args: [name] });\n}\n```\n\n**Step 4: Run test to verify it passes**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (6 tests)\n\n**Step 5: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): lookup table CRUD for projects, grants, task types\"\n```\n\n---\n\n## Task 4: Database Queries — Time Entries\n\n**Files:**\n- Modify: `src/db/queries.ts`\n- Modify: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests for time entry operations**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing imports ...\n createTimeEntry,\n updateTimeEntry,\n softDeleteTimeEntry,\n getRecentEntries,\n getTimeEntryById,\n} from \"./queries.js\";\n\ndescribe(\"time entries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addProject(db, \"Lakeland\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"creates a time entry and retrieves it\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Worked on interviews\",\n });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry).not.toBeNull();\n expect(entry!.minutes).toBe(60);\n expect(entry!.slackUsername).toBe(\"maria\");\n expect(entry!.comment).toBe(\"Worked on interviews\");\n });\n\n it(\"creates entry with optional fields null\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 30,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.projectId).toBeNull();\n expect(entry!.grantId).toBeNull();\n });\n\n it(\"updates an existing entry\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n await updateTimeEntry(db, id, { minutes: 90, comment: \"Updated\" });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.minutes).toBe(90);\n expect(entry!.comment).toBe(\"Updated\");\n });\n\n it(\"soft-deletes an entry\", async () => {\n const id = await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n\n await softDeleteTimeEntry(db, id);\n\n const recent = await getRecentEntries(db, \"U123\", 5);\n expect(recent).toHaveLength(0);\n });\n\n it(\"retrieves recent entries excluding deleted\", async () => {\n for (let i = 0; i < 7; i++) {\n await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"maria\",\n date: `2026-02-${20 + i}`,\n minutes: 60,\n taskTypeId: 1,\n projectId: null,\n grantId: null,\n comment: null,\n });\n }\n\n const recent = await getRecentEntries(db, \"U123\", 5);\n expect(recent).toHaveLength(5);\n // Most recent first\n expect(recent[0].date).toBe(\"2026-02-26\");\n });\n});\n```\n\n**Step 2: Run test to verify it fails**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: FAIL — new functions not exported\n\n**Step 3: Add time entry operations to queries.ts**\n\nAdd to `src/db/queries.ts`:\n\n```typescript\n// --- Time Entry types ---\n\nexport interface TimeEntryInput {\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport interface TimeEntry {\n id: number;\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n createdAt: string;\n}\n\n// --- Time Entries ---\n\nexport async function createTimeEntry(db: Database, input: TimeEntryInput): Promise {\n const result = await db.execute({\n sql: `INSERT INTO time_entries (slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [input.slackUserId, input.slackUsername, input.date, input.minutes, input.taskTypeId, input.projectId, input.grantId, input.comment],\n });\n return Number(result.lastInsertRowid);\n}\n\nexport async function getTimeEntryById(db: Database, id: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE id = ? AND deleted_at IS NULL`,\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const r = result.rows[0];\n return {\n id: r[0] as number,\n slackUserId: r[1] as string,\n slackUsername: r[2] as string,\n date: r[3] as string,\n minutes: r[4] as number,\n taskTypeId: r[5] as number,\n projectId: r[6] as number | null,\n grantId: r[7] as number | null,\n comment: r[8] as string | null,\n createdAt: r[9] as string,\n };\n}\n\nexport async function updateTimeEntry(\n db: Database,\n id: number,\n updates: Partial>\n): Promise {\n const setClauses: string[] = [];\n const args: unknown[] = [];\n\n for (const [key, value] of Object.entries(updates)) {\n const columnMap: Record = {\n date: \"date\",\n minutes: \"minutes\",\n taskTypeId: \"task_type_id\",\n projectId: \"project_id\",\n grantId: \"grant_id\",\n comment: \"comment\",\n };\n const col = columnMap[key];\n if (col) {\n setClauses.push(`${col} = ?`);\n args.push(value);\n }\n }\n\n setClauses.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await db.execute({\n sql: `UPDATE time_entries SET ${setClauses.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\nexport async function softDeleteTimeEntry(db: Database, id: number): Promise {\n await db.execute({\n sql: \"UPDATE time_entries SET deleted_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function getRecentEntries(db: Database, slackUserId: string, limit: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE slack_user_id = ? AND deleted_at IS NULL\n ORDER BY date DESC, created_at DESC LIMIT ?`,\n args: [slackUserId, limit],\n });\n return result.rows.map((r) => ({\n id: r[0] as number,\n slackUserId: r[1] as string,\n slackUsername: r[2] as string,\n date: r[3] as string,\n minutes: r[4] as number,\n taskTypeId: r[5] as number,\n projectId: r[6] as number | null,\n grantId: r[7] as number | null,\n comment: r[8] as string | null,\n createdAt: r[9] as string,\n }));\n}\n```\n\n**Step 4: Run test to verify it passes**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (all tests)\n\n**Step 5: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): time entry CRUD with soft delete\"\n```\n\n---\n\n## Task 5: Database Queries — Intern Management & Config\n\n**Files:**\n- Modify: `src/db/queries.ts`\n- Modify: `src/db/queries.test.ts`\n\n**Step 1: Write failing tests**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing imports ...\n addIntern,\n removeIntern,\n getInterns,\n setConfig,\n getConfig,\n} from \"./queries.js\";\n\ndescribe(\"intern management\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"adds and lists interns\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(2);\n });\n\n it(\"removes an intern\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await removeIntern(db, \"U123\");\n\n expect(await getInterns(db)).toHaveLength(0);\n });\n});\n\ndescribe(\"config\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"sets and gets config values\", async () => {\n await setConfig(db, \"reminder_day\", \"friday\");\n expect(await getConfig(db, \"reminder_day\")).toBe(\"friday\");\n });\n\n it(\"upserts config on conflict\", async () => {\n await setConfig(db, \"reminder_day\", \"friday\");\n await setConfig(db, \"reminder_day\", \"thursday\");\n expect(await getConfig(db, \"reminder_day\")).toBe(\"thursday\");\n });\n\n it(\"returns null for missing keys\", async () => {\n expect(await getConfig(db, \"nonexistent\")).toBeNull();\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\nAdd to `src/db/queries.ts`:\n\n```typescript\n// --- Intern types ---\n\nexport interface Intern {\n slackUserId: string;\n slackUsername: string;\n}\n\n// --- Interns ---\n\nexport async function addIntern(db: Database, slackUserId: string, slackUsername: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO interns (slack_user_id, slack_username) VALUES (?, ?)\",\n args: [slackUserId, slackUsername],\n });\n}\n\nexport async function removeIntern(db: Database, slackUserId: string): Promise {\n await db.execute({ sql: \"DELETE FROM interns WHERE slack_user_id = ?\", args: [slackUserId] });\n}\n\nexport async function getInterns(db: Database): Promise {\n const result = await db.execute({ sql: \"SELECT slack_user_id, slack_username FROM interns ORDER BY slack_username\" });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n\n// --- Config ---\n\nexport async function setConfig(db: Database, key: string, value: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO config (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\nexport async function getConfig(db: Database, key: string): Promise {\n const result = await db.execute({ sql: \"SELECT value FROM config WHERE key = ?\", args: [key] });\n return result.rows.length > 0 ? (result.rows[0][0] as string) : null;\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/db/queries.test.ts`\nExpected: PASS (all tests)\n\n**Step 4: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts\ngit commit -m \"feat(db): intern management and config key-value store\"\n```\n\n---\n\n## Task 6: Duration & Date Formatting\n\n**Files:**\n- Create: `src/lib/format.ts`\n- Create: `src/lib/format.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/lib/format.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { formatDuration, formatDateRange, getWeekBounds, getLast7Days } from \"./format.js\";\n\ndescribe(\"formatDuration\", () => {\n it(\"formats minutes as hours and minutes\", () => {\n expect(formatDuration(60)).toBe(\"1h\");\n expect(formatDuration(90)).toBe(\"1h 30m\");\n expect(formatDuration(15)).toBe(\"15m\");\n expect(formatDuration(480)).toBe(\"8h\");\n expect(formatDuration(0)).toBe(\"0m\");\n });\n});\n\ndescribe(\"formatDateRange\", () => {\n it(\"formats a date range for display\", () => {\n expect(formatDateRange(\"2026-02-24\", \"2026-02-28\")).toBe(\"Feb 24 – Feb 28, 2026\");\n });\n\n it(\"handles cross-month ranges\", () => {\n expect(formatDateRange(\"2026-01-28\", \"2026-02-03\")).toBe(\"Jan 28 – Feb 3, 2026\");\n });\n});\n\ndescribe(\"getWeekBounds\", () => {\n it(\"returns Monday–Sunday for a given date\", () => {\n // Feb 26 2026 is a Thursday\n const { start, end } = getWeekBounds(\"2026-02-26\");\n expect(start).toBe(\"2026-02-23\"); // Monday\n expect(end).toBe(\"2026-03-01\"); // Sunday\n });\n});\n\ndescribe(\"getLast7Days\", () => {\n it(\"returns last 7 days in descending order\", () => {\n const days = getLast7Days(\"2026-02-26\");\n expect(days).toHaveLength(7);\n expect(days[0]).toBe(\"2026-02-26\");\n expect(days[6]).toBe(\"2026-02-20\");\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\n```typescript\n// src/lib/format.ts\n\nexport function formatDuration(minutes: number): string {\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n if (hours === 0) return `${mins}m`;\n if (mins === 0) return `${hours}h`;\n return `${hours}h ${mins}m`;\n}\n\nconst MONTHS = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\n\nexport function formatDateRange(start: string, end: string): string {\n const s = new Date(start + \"T00:00:00\");\n const e = new Date(end + \"T00:00:00\");\n return `${MONTHS[s.getMonth()]} ${s.getDate()} – ${MONTHS[e.getMonth()]} ${e.getDate()}, ${e.getFullYear()}`;\n}\n\nexport function getWeekBounds(dateStr: string): { start: string; end: string } {\n const date = new Date(dateStr + \"T00:00:00\");\n const day = date.getDay(); // 0=Sun, 1=Mon...\n const diffToMonday = day === 0 ? -6 : 1 - day;\n const monday = new Date(date);\n monday.setDate(date.getDate() + diffToMonday);\n const sunday = new Date(monday);\n sunday.setDate(monday.getDate() + 6);\n return {\n start: monday.toISOString().slice(0, 10),\n end: sunday.toISOString().slice(0, 10),\n };\n}\n\nexport function getLast7Days(fromDate: string): string[] {\n const days: string[] = [];\n const date = new Date(fromDate + \"T00:00:00\");\n for (let i = 0; i < 7; i++) {\n const d = new Date(date);\n d.setDate(date.getDate() - i);\n days.push(d.toISOString().slice(0, 10));\n }\n return days;\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/lib/format.test.ts`\nExpected: PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/lib/\ngit commit -m \"feat(lib): duration and date formatting utilities\"\n```\n\n---\n\n## Task 7: Admin Command Parser\n\n**Files:**\n- Create: `src/handlers/admin.ts`\n- Create: `src/handlers/admin.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/handlers/admin.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { parseAdminCommand } from \"./admin.js\";\n\ndescribe(\"parseAdminCommand\", () => {\n it(\"parses add project\", () => {\n expect(parseAdminCommand('add project \"Community Oral Histories\"'))\n .toEqual({ action: \"add\", entity: \"project\", args: [\"Community Oral Histories\"] });\n });\n\n it(\"parses add grant with code and name\", () => {\n expect(parseAdminCommand('add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"'))\n .toEqual({ action: \"add\", entity: \"grant\", args: [\"NEH-PW-290261\", \"NEH Preservation & Access\"] });\n });\n\n it(\"parses add task\", () => {\n expect(parseAdminCommand('add task \"Scanning\"'))\n .toEqual({ action: \"add\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses remove task\", () => {\n expect(parseAdminCommand('remove task \"Scanning\"'))\n .toEqual({ action: \"remove\", entity: \"task\", args: [\"Scanning\"] });\n });\n\n it(\"parses list\", () => {\n expect(parseAdminCommand(\"list\"))\n .toEqual({ action: \"list\", entity: null, args: [] });\n });\n\n it(\"parses intern add with user mention\", () => {\n expect(parseAdminCommand(\"intern add <@U123|maria>\"))\n .toEqual({ action: \"add\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses intern remove\", () => {\n expect(parseAdminCommand(\"intern remove <@U123|maria>\"))\n .toEqual({ action: \"remove\", entity: \"intern\", args: [\"U123\", \"maria\"] });\n });\n\n it(\"parses reminder config\", () => {\n expect(parseAdminCommand(\"reminder day friday\"))\n .toEqual({ action: \"reminder\", entity: \"day\", args: [\"friday\"] });\n expect(parseAdminCommand(\"reminder off\"))\n .toEqual({ action: \"reminder\", entity: \"off\", args: [] });\n });\n\n it(\"returns error for unrecognized commands\", () => {\n expect(parseAdminCommand(\"do something weird\"))\n .toEqual({ action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] });\n });\n});\n```\n\n**Step 2: Run to verify failure, implement, run to verify pass**\n\n```typescript\n// src/handlers/admin.ts\n\nexport interface AdminCommand {\n action: string;\n entity: string | null;\n args: string[];\n}\n\nexport function parseAdminCommand(text: string): AdminCommand {\n const trimmed = text.trim();\n\n // \"list\"\n if (trimmed === \"list\") {\n return { action: \"list\", entity: null, args: [] };\n }\n\n // \"reminder day friday\" / \"reminder off\" / \"reminder on\" / \"reminder time 15:00\"\n const reminderMatch = trimmed.match(/^reminder\\s+(\\S+)(?:\\s+(.+))?$/);\n if (reminderMatch) {\n const subcommand = reminderMatch[1];\n const value = reminderMatch[2];\n return { action: \"reminder\", entity: subcommand, args: value ? [value] : [] };\n }\n\n // \"intern add <@U123|maria>\" / \"intern remove <@U123|maria>\"\n const internMatch = trimmed.match(/^intern\\s+(add|remove)\\s+<@(\\w+)\\|([^>]+)>/);\n if (internMatch) {\n return { action: internMatch[1], entity: \"intern\", args: [internMatch[2], internMatch[3]] };\n }\n\n // \"add project \"Name\"\" / \"remove task \"Name\"\"\n const crudMatch = trimmed.match(/^(add|remove)\\s+(project|grant|task)\\s+(.+)$/);\n if (crudMatch) {\n const action = crudMatch[1];\n const entity = crudMatch[2];\n const rawArgs = crudMatch[3];\n\n // Extract quoted strings\n const quoted = [...rawArgs.matchAll(/\"([^\"]+)\"/g)].map((m) => m[1]);\n if (quoted.length > 0) {\n return { action, entity, args: quoted };\n }\n return { action, entity, args: [rawArgs.trim()] };\n }\n\n return { action: \"error\", entity: null, args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"] };\n}\n```\n\n**Step 3: Run tests**\n\nRun: `npx vitest run src/handlers/admin.test.ts`\nExpected: PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/handlers/\ngit commit -m \"feat(handlers): admin command parser for timesheet-admin\"\n```\n\n---\n\n## Task 8: Report Generation\n\n**Files:**\n- Create: `src/handlers/report.ts`\n- Create: `src/handlers/report.test.ts`\n- Modify: `src/db/queries.ts` (add report query)\n\n**Step 1: Write failing test for report query**\n\nAdd to `src/db/queries.test.ts`:\n\n```typescript\nimport {\n // ... existing ...\n getReportData,\n} from \"./queries.js\";\n\ndescribe(\"report query\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"aggregates hours by user, task, and grant for a date range\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 120, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-25\",\n minutes: 60, taskTypeId: 2, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-25\",\n minutes: 90, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", null);\n expect(data).toHaveLength(3);\n expect(data[0].slackUsername).toBe(\"james\");\n expect(data[0].totalMinutes).toBe(90);\n });\n\n it(\"filters by user when specified\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", \"U123\");\n expect(data).toHaveLength(1);\n expect(data[0].slackUsername).toBe(\"maria\");\n });\n});\n```\n\n**Step 2: Add report query to queries.ts**\n\n```typescript\n// Add to src/db/queries.ts\n\nexport interface ReportRow {\n slackUserId: string;\n slackUsername: string;\n taskTypeName: string;\n grantCode: string | null;\n totalMinutes: number;\n}\n\nexport async function getReportData(\n db: Database,\n startDate: string,\n endDate: string,\n slackUserId: string | null\n): Promise {\n const args: unknown[] = [startDate, endDate];\n let userFilter = \"\";\n if (slackUserId) {\n userFilter = \"AND te.slack_user_id = ?\";\n args.push(slackUserId);\n }\n\n const result = await db.execute({\n sql: `SELECT te.slack_user_id, te.slack_username, tt.name as task_type_name,\n g.code as grant_code, SUM(te.minutes) as total_minutes\n FROM time_entries te\n JOIN task_types tt ON te.task_type_id = tt.id\n LEFT JOIN grants g ON te.grant_id = g.id\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL ${userFilter}\n GROUP BY te.slack_user_id, te.slack_username, tt.name, g.code\n ORDER BY te.slack_username, tt.name`,\n args,\n });\n\n return result.rows.map((r) => ({\n slackUserId: r[0] as string,\n slackUsername: r[1] as string,\n taskTypeName: r[2] as string,\n grantCode: r[3] as string | null,\n totalMinutes: r[4] as number,\n }));\n}\n```\n\n**Step 3: Write failing test for report formatting**\n\n```typescript\n// src/handlers/report.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { formatReport } from \"./report.js\";\nimport type { ReportRow } from \"../db/queries.js\";\n\ndescribe(\"formatReport\", () => {\n it(\"formats a multi-user report\", () => {\n const data: ReportRow[] = [\n { slackUserId: \"U456\", slackUsername: \"james\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 480 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Metadata Editing\", grantCode: null, totalMinutes: 360 },\n { slackUserId: \"U123\", slackUsername: \"maria\", taskTypeName: \"Transcription\", grantCode: \"NEH-PW-290261\", totalMinutes: 720 },\n ];\n\n const output = formatReport(data, \"2026-02-24\", \"2026-02-28\");\n\n expect(output).toContain(\"Feb 24 – Feb 28, 2026\");\n expect(output).toContain(\"james\");\n expect(output).toContain(\"maria\");\n expect(output).toContain(\"8h\"); // james total\n expect(output).toContain(\"18h\"); // maria total\n expect(output).toContain(\"26h\"); // grand total\n expect(output).toContain(\"NEH-PW-290261\");\n });\n\n it(\"handles empty data\", () => {\n const output = formatReport([], \"2026-02-24\", \"2026-02-28\");\n expect(output).toContain(\"No time entries\");\n });\n});\n```\n\n**Step 4: Implement report formatter**\n\n```typescript\n// src/handlers/report.ts\nimport type { ReportRow } from \"../db/queries.js\";\nimport { formatDuration, formatDateRange } from \"../lib/format.js\";\n\nexport function formatReport(data: ReportRow[], startDate: string, endDate: string): string {\n const header = `*Timesheet Report: ${formatDateRange(startDate, endDate)}*\\n`;\n\n if (data.length === 0) {\n return header + \"\\nNo time entries found for this period.\";\n }\n\n // Group by user\n const byUser = new Map();\n for (const row of data) {\n if (!byUser.has(row.slackUserId)) {\n byUser.set(row.slackUserId, { username: row.slackUsername, rows: [], total: 0 });\n }\n const user = byUser.get(row.slackUserId)!;\n user.rows.push(row);\n user.total += row.totalMinutes;\n }\n\n let grandTotal = 0;\n const lines: string[] = [header];\n\n for (const [, user] of byUser) {\n grandTotal += user.total;\n lines.push(`*@${user.username}* — ${formatDuration(user.total)}`);\n for (const row of user.rows) {\n const grant = row.grantCode ? ` (${row.grantCode})` : \"\";\n lines.push(` ${row.taskTypeName} ${formatDuration(row.totalMinutes)}${grant}`);\n }\n lines.push(\"\");\n }\n\n lines.push(`*Total: ${formatDuration(grandTotal)} across ${byUser.size} intern${byUser.size === 1 ? \"\" : \"s\"}*`);\n\n return lines.join(\"\\n\");\n}\n```\n\n**Step 5: Run all tests**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n**Step 6: Commit**\n\n```bash\ngit add src/db/queries.ts src/db/queries.test.ts src/handlers/report.ts src/handlers/report.test.ts\ngit commit -m \"feat(reports): report data query and text formatter\"\n```\n\n---\n\n## Task 9: Report Command Argument Parser\n\n**Files:**\n- Modify: `src/handlers/report.ts`\n- Modify: `src/handlers/report.test.ts`\n\n**Step 1: Write failing tests for argument parsing**\n\nAdd to `src/handlers/report.test.ts`:\n\n```typescript\nimport { parseReportArgs } from \"./report.js\";\n\ndescribe(\"parseReportArgs\", () => {\n it(\"defaults to current week, all users\", () => {\n const result = parseReportArgs(\"\", \"2026-02-26\");\n expect(result.userId).toBeNull();\n expect(result.startDate).toBe(\"2026-02-23\"); // Monday\n expect(result.endDate).toBe(\"2026-03-01\"); // Sunday\n });\n\n it(\"parses user mention\", () => {\n const result = parseReportArgs(\"<@U123|maria>\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n });\n\n it(\"parses date range\", () => {\n const result = parseReportArgs(\"2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n\n it(\"parses user + date range\", () => {\n const result = parseReportArgs(\"<@U123|maria> 2026-02-01 2026-02-28\", \"2026-02-26\");\n expect(result.userId).toBe(\"U123\");\n expect(result.startDate).toBe(\"2026-02-01\");\n expect(result.endDate).toBe(\"2026-02-28\");\n });\n});\n```\n\n**Step 2: Implement parser, run tests, commit**\n\n```typescript\n// Add to src/handlers/report.ts\nimport { getWeekBounds } from \"../lib/format.js\";\n\nexport interface ReportArgs {\n userId: string | null;\n startDate: string;\n endDate: string;\n}\n\nexport function parseReportArgs(text: string, today: string): ReportArgs {\n const trimmed = text.trim();\n let userId: string | null = null;\n\n // Extract user mention\n let remaining = trimmed;\n const userMatch = remaining.match(/<@(\\w+)\\|[^>]+>/);\n if (userMatch) {\n userId = userMatch[1];\n remaining = remaining.replace(userMatch[0], \"\").trim();\n }\n\n // Extract dates\n const dateMatch = remaining.match(/(\\d{4}-\\d{2}-\\d{2})\\s+(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n return { userId, startDate: dateMatch[1], endDate: dateMatch[2] };\n }\n\n // Default: current week\n const { start, end } = getWeekBounds(today);\n return { userId, startDate: start, endDate: end };\n}\n```\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/handlers/report.ts src/handlers/report.test.ts\ngit commit -m \"feat(reports): argument parser for /timesheet command\"\n```\n\n---\n\n## Task 10: Slack Signature Verification\n\n**Files:**\n- Create: `src/slack/verify.ts`\n- Create: `src/slack/verify.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/slack/verify.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { verifySlackSignature } from \"./verify.js\";\n\nconst SIGNING_SECRET = \"test_secret_12345\";\n\ndescribe(\"verifySlackSignature\", () => {\n it(\"returns true for valid signature\", async () => {\n const timestamp = Math.floor(Date.now() / 1000).toString();\n const body = \"token=xyzz0WbapA4vBCDEFaYZlElrm&command=%2Flogtime\";\n\n // Compute expected signature\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\", encoder.encode(SIGNING_SECRET), { name: \"HMAC\", hash: \"SHA-256\" }, false, [\"sign\"]\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(`v0:${timestamp}:${body}`));\n const hex = Array.from(new Uint8Array(sig)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n const signature = `v0=${hex}`;\n\n const result = await verifySlackSignature(body, timestamp, signature, SIGNING_SECRET);\n expect(result).toBe(true);\n });\n\n it(\"returns false for invalid signature\", async () => {\n const result = await verifySlackSignature(\"body\", \"12345\", \"v0=invalid\", SIGNING_SECRET);\n expect(result).toBe(false);\n });\n\n it(\"returns false for stale timestamp (>5 min)\", async () => {\n const staleTimestamp = (Math.floor(Date.now() / 1000) - 600).toString();\n const result = await verifySlackSignature(\"body\", staleTimestamp, \"v0=anything\", SIGNING_SECRET);\n expect(result).toBe(false);\n });\n});\n```\n\n**Step 2: Implement**\n\n```typescript\n// src/slack/verify.ts\n\nexport async function verifySlackSignature(\n body: string,\n timestamp: string,\n signature: string,\n signingSecret: string\n): Promise {\n // Reject stale requests (>5 minutes)\n const now = Math.floor(Date.now() / 1000);\n if (Math.abs(now - Number(timestamp)) > 300) {\n return false;\n }\n\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(signingSecret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const baseString = `v0:${timestamp}:${body}`;\n const sig = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(baseString));\n const hex = Array.from(new Uint8Array(sig))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n const expected = `v0=${hex}`;\n\n // Constant-time comparison\n if (expected.length !== signature.length) return false;\n let mismatch = 0;\n for (let i = 0; i < expected.length; i++) {\n mismatch |= expected.charCodeAt(i) ^ signature.charCodeAt(i);\n }\n return mismatch === 0;\n}\n```\n\n**Step 3: Run tests, commit**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/slack/\ngit commit -m \"feat(slack): request signature verification with replay protection\"\n```\n\n---\n\n## Task 11: Block Kit Modal Builder\n\n**Files:**\n- Create: `src/slack/modals.ts`\n- Create: `src/slack/modals.test.ts`\n\n**Step 1: Write failing tests**\n\n```typescript\n// src/slack/modals.test.ts\nimport { describe, it, expect } from \"vitest\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./modals.js\";\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.js\";\n\ndescribe(\"buildLogtimeModal\", () => {\n const taskTypes: TaskType[] = [{ id: 1, name: \"Transcription\" }, { id: 2, name: \"Metadata Editing\" }];\n const projects: Project[] = [{ id: 1, name: \"Lakeland\" }];\n const grants: Grant[] = [{ id: 1, code: \"NEH-PW-290261\", name: \"NEH\" }];\n\n it(\"builds a valid Block Kit modal with all dropdowns\", () => {\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\");\n\n expect(modal.type).toBe(\"modal\");\n expect(modal.title.text).toBe(\"Log Time\");\n expect(modal.submit!.text).toBe(\"Submit\");\n // Should have blocks for: date, time, task, project, grant, comment\n expect(modal.blocks.length).toBeGreaterThanOrEqual(6);\n });\n\n it(\"builds modal pre-filled for editing\", () => {\n const existing = {\n id: 42,\n date: \"2026-02-25\",\n minutes: 90,\n taskTypeId: 1,\n projectId: 1,\n grantId: 1,\n comment: \"Test\",\n };\n const modal = buildLogtimeModal(taskTypes, projects, grants, \"2026-02-26\", existing);\n\n // private_metadata should contain the entry ID for update\n expect(modal.private_metadata).toContain(\"42\");\n });\n});\n\ndescribe(\"buildConfirmationBlocks\", () => {\n it(\"builds confirmation message with edit/delete buttons\", () => {\n const blocks = buildConfirmationBlocks(42, \"1h\", \"Transcription\", \"Feb 26\", \"NEH-PW-290261\");\n\n // Should contain text and action buttons\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"edit\");\n expect(text).toContain(\"delete\");\n });\n});\n\ndescribe(\"buildRecentEntriesBlocks\", () => {\n it(\"builds blocks for recent entries with edit/delete buttons\", () => {\n const entries: Array = [\n {\n id: 1, slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-26\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n createdAt: \"2026-02-26T10:00:00\", taskTypeName: \"Transcription\", grantCode: null,\n },\n ];\n\n const blocks = buildRecentEntriesBlocks(entries);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"Transcription\");\n expect(text).toContain(\"1h\");\n });\n\n it(\"shows message when no entries\", () => {\n const blocks = buildRecentEntriesBlocks([]);\n const text = JSON.stringify(blocks);\n expect(text).toContain(\"No recent entries\");\n });\n});\n```\n\n**Step 2: Implement modals.ts**\n\nThis is the largest file — Block Kit JSON is verbose. The implementation builds Slack Block Kit view objects as plain objects (no SDK dependency).\n\n```typescript\n// src/slack/modals.ts\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.js\";\nimport { formatDuration, getLast7Days } from \"../lib/format.js\";\n\ninterface ModalView {\n type: \"modal\";\n callback_id: string;\n title: { type: \"plain_text\"; text: string };\n submit?: { type: \"plain_text\"; text: string };\n blocks: unknown[];\n private_metadata?: string;\n}\n\ninterface EditPrefill {\n id: number;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport function buildLogtimeModal(\n taskTypes: TaskType[],\n projects: Project[],\n grants: Grant[],\n today: string,\n prefill?: EditPrefill\n): ModalView {\n const days = getLast7Days(today);\n const timeOptions = [];\n for (let m = 15; m <= 480; m += 15) {\n timeOptions.push({ text: { type: \"plain_text\", text: formatDuration(m) }, value: String(m) });\n }\n\n return {\n type: \"modal\",\n callback_id: prefill ? \"edit_time_entry\" : \"log_time_entry\",\n title: { type: \"plain_text\", text: \"Log Time\" },\n submit: { type: \"plain_text\", text: \"Submit\" },\n private_metadata: prefill ? JSON.stringify({ entryId: prefill.id }) : undefined,\n blocks: [\n {\n type: \"input\",\n block_id: \"date_block\",\n label: { type: \"plain_text\", text: \"Date\" },\n element: {\n type: \"static_select\",\n action_id: \"date_select\",\n options: days.map((d) => ({ text: { type: \"plain_text\", text: d }, value: d })),\n ...(prefill?.date ? { initial_option: { text: { type: \"plain_text\", text: prefill.date }, value: prefill.date } } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"time_block\",\n label: { type: \"plain_text\", text: \"Time Worked\" },\n element: {\n type: \"static_select\",\n action_id: \"time_select\",\n options: timeOptions,\n ...(prefill?.minutes ? { initial_option: timeOptions.find((o) => o.value === String(prefill.minutes)) } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"task_block\",\n label: { type: \"plain_text\", text: \"Task\" },\n element: {\n type: \"static_select\",\n action_id: \"task_select\",\n options: taskTypes.map((t) => ({ text: { type: \"plain_text\", text: t.name }, value: String(t.id) })),\n ...(prefill?.taskTypeId ? { initial_option: { text: { type: \"plain_text\", text: taskTypes.find((t) => t.id === prefill.taskTypeId)?.name ?? \"\" }, value: String(prefill.taskTypeId) } } : {}),\n },\n },\n {\n type: \"input\",\n block_id: \"project_block\",\n label: { type: \"plain_text\", text: \"Project\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"project_select\",\n options: projects.map((p) => ({ text: { type: \"plain_text\", text: p.name }, value: String(p.id) })),\n },\n },\n {\n type: \"input\",\n block_id: \"grant_block\",\n label: { type: \"plain_text\", text: \"Grant\" },\n optional: true,\n element: {\n type: \"static_select\",\n action_id: \"grant_select\",\n options: grants.map((g) => ({ text: { type: \"plain_text\", text: `${g.code} — ${g.name}` }, value: String(g.id) })),\n },\n },\n {\n type: \"input\",\n block_id: \"comment_block\",\n label: { type: \"plain_text\", text: \"Comment\" },\n optional: true,\n element: { type: \"plain_text_input\", action_id: \"comment_input\", multiline: true },\n },\n ],\n };\n}\n\nexport function buildConfirmationBlocks(\n entryId: number,\n duration: string,\n taskName: string,\n dateDisplay: string,\n grantCode: string | null\n): unknown[] {\n const grantSuffix = grantCode ? ` (${grantCode})` : \"\";\n return [\n {\n type: \"section\",\n text: { type: \"mrkdwn\", text: `Logged *${duration}* of *${taskName}* on ${dateDisplay}${grantSuffix}` },\n },\n {\n type: \"actions\",\n elements: [\n { type: \"button\", text: { type: \"plain_text\", text: \"Edit\" }, action_id: \"edit_entry\", value: String(entryId) },\n { type: \"button\", text: { type: \"plain_text\", text: \"Delete\" }, action_id: \"delete_entry\", value: String(entryId), style: \"danger\" },\n ],\n },\n ];\n}\n\nexport function buildRecentEntriesBlocks(\n entries: Array\n): unknown[] {\n if (entries.length === 0) {\n return [{ type: \"section\", text: { type: \"mrkdwn\", text: \"No recent entries found.\" } }];\n }\n\n const blocks: unknown[] = [\n { type: \"section\", text: { type: \"mrkdwn\", text: \"*Your recent entries:*\" } },\n ];\n\n for (const entry of entries) {\n const grant = entry.grantCode ? ` (${entry.grantCode})` : \"\";\n blocks.push({\n type: \"section\",\n text: { type: \"mrkdwn\", text: `${entry.date} — ${formatDuration(entry.minutes)} ${entry.taskTypeName}${grant}` },\n accessory: {\n type: \"overflow\",\n action_id: `entry_overflow_${entry.id}`,\n options: [\n { text: { type: \"plain_text\", text: \"Edit\" }, value: `edit:${entry.id}` },\n { text: { type: \"plain_text\", text: \"Delete\" }, value: `delete:${entry.id}` },\n ],\n },\n });\n }\n\n return blocks;\n}\n```\n\n**Step 3: Run all tests**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n**Step 4: Commit**\n\n```bash\ngit add src/slack/modals.ts src/slack/modals.test.ts\ngit commit -m \"feat(slack): Block Kit modal builder for time entry and confirmations\"\n```\n\n---\n\n## Task 12: Slack API Client\n\n**Files:**\n- Create: `src/slack/api.ts`\n\nThis is thin glue — no tests needed for HTTP calls. Tested via integration in Task 14.\n\n**Step 1: Implement**\n\n```typescript\n// src/slack/api.ts\n\nexport interface SlackClient {\n openModal(triggerId: string, view: unknown): Promise;\n postEphemeral(channel: string, userId: string, text: string, blocks?: unknown[]): Promise;\n sendDm(userId: string, text: string): Promise;\n}\n\nexport function createSlackClient(botToken: string): SlackClient {\n async function slackApi(method: string, body: unknown): Promise {\n const response = await fetch(`https://slack.com/api/${method}`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${botToken}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(body),\n });\n const data = await response.json();\n if (!data.ok) {\n throw new Error(`Slack API error (${method}): ${data.error}`);\n }\n return data;\n }\n\n return {\n async openModal(triggerId, view) {\n await slackApi(\"views.open\", { trigger_id: triggerId, view });\n },\n async postEphemeral(channel, userId, text, blocks) {\n await slackApi(\"chat.postEphemeral\", { channel, user: userId, text, blocks });\n },\n async sendDm(userId, text) {\n // Open DM channel, then send\n const conv = (await slackApi(\"conversations.open\", { users: userId })) as { channel: { id: string } };\n await slackApi(\"chat.postMessage\", { channel: conv.channel.id, text });\n },\n };\n}\n```\n\n**Step 2: Commit**\n\n```bash\ngit add src/slack/api.ts\ngit commit -m \"feat(slack): API client for modals, ephemeral messages, and DMs\"\n```\n\n---\n\n## Task 13: HTTP Router (main.ts)\n\n**Files:**\n- Create: `src/main.ts`\n\nThis wires everything together. It's the Val Town HTTP val entry point. Tested manually against Slack (Task 15).\n\n**Step 1: Implement the router**\n\n```typescript\n// src/main.ts\nimport { verifySlackSignature } from \"./slack/verify.js\";\nimport { createSlackClient, type SlackClient } from \"./slack/api.js\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./slack/modals.js\";\nimport { parseAdminCommand } from \"./handlers/admin.js\";\nimport { formatReport, parseReportArgs } from \"./handlers/report.js\";\nimport { migrate } from \"./db/schema.js\";\nimport * as queries from \"./db/queries.js\";\nimport { formatDuration } from \"./lib/format.js\";\nimport type { Database } from \"./db/types.js\";\n\n// Val Town provides these — injected at runtime\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nlet db: Database;\nlet slack: SlackClient;\nlet migrated = false;\n\nasync function getDb(): Promise {\n if (!db) {\n // Dynamic import for Val Town runtime\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n db = sqlite;\n }\n if (!migrated) {\n await migrate(db);\n migrated = true;\n }\n return db;\n}\n\nfunction getSlack(): SlackClient {\n if (!slack) {\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) throw new Error(\"SLACK_BOT_TOKEN not set\");\n slack = createSlackClient(token);\n }\n return slack;\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const body = await req.text();\n const timestamp = req.headers.get(\"x-slack-request-timestamp\") ?? \"\";\n const signature = req.headers.get(\"x-slack-signature\") ?? \"\";\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\") ?? \"\";\n\n const valid = await verifySlackSignature(body, timestamp, signature, signingSecret);\n if (!valid) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n // Slack sends either URL-encoded (slash commands) or JSON (interactions)\n const contentType = req.headers.get(\"content-type\") ?? \"\";\n\n if (contentType.includes(\"application/x-www-form-urlencoded\")) {\n const params = new URLSearchParams(body);\n const payload = params.get(\"payload\");\n\n if (payload) {\n // Interaction payload (modal submission, button click)\n return handleInteraction(JSON.parse(payload));\n }\n\n // Slash command\n const command = params.get(\"command\");\n const text = params.get(\"text\") ?? \"\";\n const triggerId = params.get(\"trigger_id\") ?? \"\";\n const userId = params.get(\"user_id\") ?? \"\";\n const userName = params.get(\"user_name\") ?? \"\";\n const channelId = params.get(\"channel_id\") ?? \"\";\n\n switch (command) {\n case \"/logtime\":\n return handleLogtime(text, triggerId, userId, userName, channelId);\n case \"/timesheet\":\n return handleTimesheet(text, userId, channelId);\n case \"/timesheet-admin\":\n return handleAdmin(text, userId, channelId);\n default:\n return new Response(\"Unknown command\", { status: 200 });\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleLogtime(\n text: string, triggerId: string, userId: string, userName: string, channelId: string\n): Promise {\n const database = await getDb();\n\n if (text.trim() === \"list\") {\n const entries = await queries.getRecentEntries(database, userId, 5);\n // Enrich with task type names and grant codes\n const enriched = [];\n for (const entry of entries) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const grants = await queries.getActiveGrants(database);\n const taskType = taskTypes.find((t) => t.id === entry.taskTypeId);\n const grant = entry.grantId ? grants.find((g) => g.id === entry.grantId) : null;\n enriched.push({ ...entry, taskTypeName: taskType?.name ?? \"Unknown\", grantCode: grant?.code ?? null });\n }\n\n const blocks = buildRecentEntriesBlocks(enriched);\n await getSlack().postEphemeral(channelId, userId, \"Your recent entries:\", blocks);\n return new Response(\"\", { status: 200 });\n }\n\n // Open the modal\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = new Date().toISOString().slice(0, 10);\n\n const modal = buildLogtimeModal(taskTypes, projects, grants, today);\n await getSlack().openModal(triggerId, modal);\n\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleTimesheet(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const today = new Date().toISOString().slice(0, 10);\n const args = parseReportArgs(text, today);\n\n const data = await queries.getReportData(database, args.startDate, args.endDate, args.userId);\n const report = formatReport(data, args.startDate, args.endDate);\n\n await getSlack().postEphemeral(channelId, userId, report);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleAdmin(text: string, userId: string, channelId: string): Promise {\n const database = await getDb();\n const cmd = parseAdminCommand(text);\n let response = \"\";\n\n switch (cmd.action) {\n case \"add\":\n if (cmd.entity === \"project\") {\n await queries.addProject(database, cmd.args[0]);\n response = `Added project: ${cmd.args[0]}`;\n } else if (cmd.entity === \"grant\") {\n await queries.addGrant(database, cmd.args[0], cmd.args[1]);\n response = `Added grant: ${cmd.args[0]} (${cmd.args[1]})`;\n } else if (cmd.entity === \"task\") {\n await queries.addTaskType(database, cmd.args[0]);\n response = `Added task type: ${cmd.args[0]}`;\n } else if (cmd.entity === \"intern\") {\n await queries.addIntern(database, cmd.args[0], cmd.args[1]);\n response = `Registered intern: @${cmd.args[1]}`;\n }\n break;\n case \"remove\":\n if (cmd.entity === \"project\") await queries.deactivateProject(database, cmd.args[0]);\n else if (cmd.entity === \"grant\") await queries.deactivateGrant(database, cmd.args[0]);\n else if (cmd.entity === \"task\") await queries.deactivateTaskType(database, cmd.args[0]);\n else if (cmd.entity === \"intern\") await queries.removeIntern(database, cmd.args[0]);\n response = `Removed ${cmd.entity}: ${cmd.args[0]}`;\n break;\n case \"list\": {\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const taskTypes = await queries.getActiveTaskTypes(database);\n const interns = await queries.getInterns(database);\n response = [\n `*Projects:* ${projects.map((p) => p.name).join(\", \") || \"none\"}`,\n `*Grants:* ${grants.map((g) => `${g.code} (${g.name})`).join(\", \") || \"none\"}`,\n `*Task Types:* ${taskTypes.map((t) => t.name).join(\", \") || \"none\"}`,\n `*Interns:* ${interns.map((i) => `@${i.slackUsername}`).join(\", \") || \"none\"}`,\n ].join(\"\\n\");\n break;\n }\n case \"reminder\":\n if (cmd.entity === \"on\" || cmd.entity === \"off\") {\n await queries.setConfig(database, \"reminder_enabled\", cmd.entity === \"on\" ? \"true\" : \"false\");\n response = `Reminders ${cmd.entity}`;\n } else if (cmd.entity === \"day\" || cmd.entity === \"time\") {\n await queries.setConfig(database, `reminder_${cmd.entity}`, cmd.args[0]);\n response = `Reminder ${cmd.entity} set to: ${cmd.args[0]}`;\n }\n break;\n case \"error\":\n response = cmd.args[0];\n break;\n }\n\n await getSlack().postEphemeral(channelId, userId, response);\n return new Response(\"\", { status: 200 });\n}\n\nasync function handleInteraction(payload: Record): Promise {\n const type = payload.type as string;\n const database = await getDb();\n\n if (type === \"view_submission\") {\n const view = payload.view as Record;\n const callbackId = view.callback_id as string;\n const values = view.state as { values: Record> };\n const user = payload.user as { id: string; username: string };\n\n const date = values.values.date_block.date_select.selected_option!.value;\n const minutes = Number(values.values.time_block.time_select.selected_option!.value);\n const taskTypeId = Number(values.values.task_block.task_select.selected_option!.value);\n const projectId = values.values.project_block.project_select.selected_option?.value\n ? Number(values.values.project_block.project_select.selected_option.value) : null;\n const grantId = values.values.grant_block.grant_select.selected_option?.value\n ? Number(values.values.grant_block.grant_select.selected_option.value) : null;\n const comment = values.values.comment_block.comment_input.value || null;\n\n if (callbackId === \"edit_time_entry\") {\n const meta = JSON.parse(view.private_metadata as string);\n await queries.updateTimeEntry(database, meta.entryId, { date, minutes, taskTypeId, projectId, grantId, comment });\n } else {\n await queries.createTimeEntry(database, {\n slackUserId: user.id, slackUsername: user.username,\n date, minutes, taskTypeId, projectId, grantId, comment,\n });\n }\n\n return new Response(JSON.stringify({ response_action: \"clear\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (type === \"block_actions\") {\n const actions = payload.actions as Array<{ action_id: string; value: string }>;\n const action = actions[0];\n const user = payload.user as { id: string; username: string };\n const channel = (payload.channel as { id: string })?.id;\n\n if (action.action_id === \"delete_entry\") {\n await queries.softDeleteTimeEntry(database, Number(action.value));\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (action.action_id === \"edit_entry\") {\n const entry = await queries.getTimeEntryById(database, Number(action.value));\n if (entry) {\n const taskTypes = await queries.getActiveTaskTypes(database);\n const projects = await queries.getActiveProjects(database);\n const grants = await queries.getActiveGrants(database);\n const today = new Date().toISOString().slice(0, 10);\n const triggerId = (payload as Record).trigger_id;\n const modal = buildLogtimeModal(taskTypes, projects, grants, today, {\n id: entry.id, date: entry.date, minutes: entry.minutes,\n taskTypeId: entry.taskTypeId, projectId: entry.projectId, grantId: entry.grantId, comment: entry.comment,\n });\n await getSlack().openModal(triggerId, modal);\n }\n }\n }\n\n return new Response(\"\", { status: 200 });\n}\n```\n\n**Step 2: Commit**\n\n```bash\ngit add src/main.ts\ngit commit -m \"feat: HTTP router wiring all handlers together\"\n```\n\n---\n\n## Task 14: Weekly Reminder Cron\n\n**Files:**\n- Create: `src/cron.ts`\n- Create: `src/handlers/reminder.ts`\n- Create: `src/handlers/reminder.test.ts`\n\n**Step 1: Write failing test for reminder logic**\n\n```typescript\n// src/handlers/reminder.test.ts\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"../db/test-helpers.js\";\nimport { migrate } from \"../db/schema.js\";\nimport { addIntern, addTaskType, createTimeEntry } from \"../db/queries.js\";\nimport { getInternsWithoutEntries } from \"./reminder.js\";\nimport type { Database } from \"../db/types.js\";\n\ndescribe(\"getInternsWithoutEntries\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n });\n\n it(\"returns interns who have not logged time in the date range\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n // Only maria logs time\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(1);\n expect(missing[0].slackUserId).toBe(\"U456\");\n });\n\n it(\"returns all interns when nobody logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await addIntern(db, \"U456\", \"james\");\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(2);\n });\n\n it(\"returns empty when all interns logged time\", async () => {\n await addIntern(db, \"U123\", \"maria\");\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const missing = await getInternsWithoutEntries(db, \"2026-02-23\", \"2026-03-01\");\n expect(missing).toHaveLength(0);\n });\n});\n```\n\n**Step 2: Implement reminder logic**\n\n```typescript\n// src/handlers/reminder.ts\nimport type { Database } from \"../db/types.js\";\nimport type { Intern } from \"../db/queries.js\";\n\nexport async function getInternsWithoutEntries(\n db: Database,\n startDate: string,\n endDate: string\n): Promise {\n const result = await db.execute({\n sql: `SELECT i.slack_user_id, i.slack_username\n FROM interns i\n WHERE i.slack_user_id NOT IN (\n SELECT DISTINCT te.slack_user_id FROM time_entries te\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL\n )\n ORDER BY i.slack_username`,\n args: [startDate, endDate],\n });\n return result.rows.map((r) => ({ slackUserId: r[0] as string, slackUsername: r[1] as string }));\n}\n```\n\n**Step 3: Implement cron.ts (Val Town cron val)**\n\n```typescript\n// src/cron.ts\nimport { getConfig, getInterns } from \"./db/queries.js\";\nimport { getInternsWithoutEntries } from \"./handlers/reminder.js\";\nimport { getWeekBounds } from \"./lib/format.js\";\nimport { createSlackClient } from \"./slack/api.js\";\nimport { migrate } from \"./db/schema.js\";\nimport type { Database } from \"./db/types.js\";\n\ndeclare const Deno: { env: { get(key: string): string | undefined } };\n\nexport default async function reminder() {\n // Dynamic import for Val Town runtime\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n const db: Database = sqlite;\n await migrate(db);\n\n const enabled = await getConfig(db, \"reminder_enabled\");\n if (enabled === \"false\") return;\n\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (!token) return;\n const slack = createSlackClient(token);\n\n const today = new Date().toISOString().slice(0, 10);\n const { start, end } = getWeekBounds(today);\n const missing = await getInternsWithoutEntries(db, start, end);\n\n for (const intern of missing) {\n await slack.sendDm(\n intern.slackUserId,\n `Hey! You haven't logged any time this week. Use /logtime to log your hours before end of day.`\n );\n }\n}\n```\n\n**Step 4: Run tests, commit**\n\nRun: `npx vitest run`\nExpected: ALL PASS\n\n```bash\ngit add src/handlers/reminder.ts src/handlers/reminder.test.ts src/cron.ts\ngit commit -m \"feat(cron): weekly reminder for interns without time entries\"\n```\n\n---\n\n## Task 15: Val Town Deployment & Slack App Setup\n\n**This task is manual — no TDD. It's configuration and integration testing.**\n\n**Step 1: Install Val Town CLI**\n\n```bash\ndeno install -grAf jsr:@valtown/vt\nvt # authenticate\n```\n\n**Step 2: Create Val Town project**\n\n```bash\ncd /Users/trevormunoz/Code/lakeland-timesheet\nvt create lakeland-timesheet\n# Or if project already exists:\n# vt clone /lakeland-timesheet\n```\n\n**Step 3: Push code to Val Town**\n\n```bash\nvt push\n```\n\n**Step 4: Create Slack App at api.slack.com/apps**\n\n1. Create new app → \"From scratch\"\n2. Name: \"Lakeland Timesheet\"\n3. Select your workspace\n\n**Step 5: Configure OAuth scopes**\n\nBot Token Scopes: `commands`, `chat:write`, `users:read`, `im:write`\n\n**Step 6: Register slash commands**\n\nAll three point to your Val Town HTTP URL:\n- `/logtime` — \"Log time worked\"\n- `/timesheet` — \"Run a timesheet report\"\n- `/timesheet-admin` — \"Manage timesheet configuration\"\n\n**Step 7: Enable interactivity**\n\nRequest URL: same Val Town HTTP URL\n\n**Step 8: Install to workspace**\n\nCopy the Bot User OAuth Token (`xoxb-...`)\n\n**Step 9: Set Val Town environment variables**\n\nIn Val Town project settings:\n- `SLACK_BOT_TOKEN` = `xoxb-...`\n- `SLACK_SIGNING_SECRET` = (from Slack app Basic Information page)\n\n**Step 10: Set up cron val**\n\nIn Val Town, set `cron.ts` to run on schedule: `0 20 * * 5` (Friday 8pm UTC = 3pm ET)\n\n**Step 11: Seed initial data**\n\nIn Slack:\n```\n/timesheet-admin add task \"Transcription\"\n/timesheet-admin add task \"Metadata Editing\"\n/timesheet-admin add task \"Oral History\"\n/timesheet-admin add project \"Lakeland Digital Archive\"\n/timesheet-admin add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"\n/timesheet-admin reminder on\n```\n\n**Step 12: Smoke test**\n\n1. `/logtime` → verify modal opens with all dropdowns populated\n2. Submit an entry → verify confirmation with Edit/Delete buttons\n3. `/logtime list` → verify recent entries appear\n4. Edit an entry → verify modal pre-fills\n5. Delete an entry → verify it disappears from list\n6. `/timesheet` → verify report shows your entry\n7. `/timesheet-admin list` → verify all config displays\n\n**Step 13: Commit any deployment adjustments**\n\n```bash\ngit add -A && git commit -m \"chore: deployment configuration adjustments\"\n```\n\n---\n\n## Summary\n\n| Task | What | Tests |\n|------|------|-------|\n| 1 | Project scaffold, Vitest, DB abstraction | — |\n| 2 | Schema migration | 2 tests |\n| 3 | Lookup table CRUD | 6 tests |\n| 4 | Time entry CRUD | 5 tests |\n| 5 | Intern management + config | 5 tests |\n| 6 | Duration/date formatting | ~8 tests |\n| 7 | Admin command parser | 9 tests |\n| 8 | Report query + formatter | 4 tests |\n| 9 | Report argument parser | 4 tests |\n| 10 | Slack signature verification | 3 tests |\n| 11 | Block Kit modal builder | 4 tests |\n| 12 | Slack API client (thin glue) | — |\n| 13 | HTTP router (main.ts) | — |\n| 14 | Weekly reminder cron | 3 tests |\n| 15 | Deployment + Slack app setup | Manual smoke test |\n\n**Total: ~53 automated tests, 15 tasks, ~15 commits**\n",[],[212,482,474],"plans","59b4a7aa-132b-11f1-b93a-42dde27851f2","2026-02-26-timesheet-app-design.md","59b4a872-132b-11f1-b93a-42dde27851f2",117,["D",1772121233427],"# Lakeland Timesheet — Slack App Design\n\n## Overview\n\nA Slack app for interns working on Lakeland Digital Archive projects to log their hours in 15-minute increments, with optional project/grant/task categorization. Managers and interns can run reports of hours worked over configurable time periods.\n\n**Platform:** Val Town (HTTP val + cron val)\n**Storage:** Val Town built-in SQLite (Turso)\n**Team size:** 4–10 interns across multiple projects/grants\n\n## Data Model\n\n### Lookup Tables (managed via `/timesheet-admin`)\n\n```sql\nCREATE TABLE projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n);\n\nCREATE TABLE grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n);\n\nCREATE TABLE task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n);\n```\n\n### Core Tables\n\n```sql\nCREATE TABLE time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n);\n\nCREATE TABLE interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n\nCREATE TABLE config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n);\n```\n\n### Design Decisions\n\n- `slack_user_id` is the stable identity key; `slack_username` is cached for display and refreshed on each interaction.\n- `minutes` stored as integer (multiples of 15). The 15-minute increment constraint is enforced in the modal UI, not the database.\n- `project_id` and `grant_id` are nullable — an intern may log general work. `task_type_id` is required.\n- Soft deletes via `deleted_at` on time entries and `active` flag on lookup tables — preserves audit trail for grant reporting.\n- `interns` table defines who receives weekly reminders and scopes the default report population.\n- `config` table stores reminder settings (day, time, enabled).\n\n## Interaction Flows\n\n### `/logtime` — Log Time Entry\n\n1. Intern types `/logtime`.\n2. Slack POSTs to the Val Town HTTP endpoint with a `trigger_id`.\n3. App calls `views.open` with a Block Kit modal:\n - **Date** — dropdown of last 7 days, defaults to today\n - **Time** — dropdown of 15-minute increments from 15m to 8h\n - **Task** — required dropdown (Transcription, Metadata Editing, Oral History, etc.)\n - **Project** — optional dropdown\n - **Grant** — optional dropdown\n - **Comment** — optional free-form text input\n4. Intern submits. Slack POSTs `view_submission` to the same endpoint.\n5. App saves to SQLite, responds with ephemeral confirmation:\n `\"Logged 1h of Transcription on Feb 26 (NEH-PW-290261) [Edit] [Delete]\"`\n\n### `/logtime list` — View Recent Entries\n\nShows the intern's last 5 entries with Edit and Delete buttons on each.\n\n### Edit/Delete\n\n- **Edit** button reopens the modal pre-filled with the entry's values. Submission updates the row.\n- **Delete** button shows a confirmation dialog, then soft-deletes (`deleted_at` set).\n\n### `/timesheet` — Run Reports\n\n```\n/timesheet → This week, all registered interns\n/timesheet @intern → This week, specific intern\n/timesheet 2026-02-01 2026-02-28 → Custom date range, all interns\n/timesheet @intern 2026-02-01 2026-02-28 → Custom range, specific intern\n```\n\nOutput as ephemeral message:\n\n```\nTimesheet Report: Feb 24 – Feb 28, 2026\n\n@Maria — 20h\n Transcription 12h (NEH-PW-290261)\n Metadata Editing 6h (Mellon-41500)\n Oral History 2h\n\n@James — 15h 30m\n Transcription 8h (NEH-PW-290261)\n Metadata Editing 7h 30m\n\nTotal: 35h 30m across 2 interns\n```\n\nDefault period is the current week (Monday–Sunday). Report groups by intern, then by task type, with grant shown where applicable.\n\n### `/timesheet-admin` — Manage Configuration\n\n```\n/timesheet-admin add project \"Community Oral Histories\"\n/timesheet-admin add grant \"NEH-PW-290261\" \"NEH Preservation & Access\"\n/timesheet-admin add task \"Scanning\"\n/timesheet-admin remove task \"Scanning\"\n/timesheet-admin list\n\n/timesheet-admin intern add @maria\n/timesheet-admin intern remove @james\n\n/timesheet-admin reminder day friday\n/timesheet-admin reminder time 15:00\n/timesheet-admin reminder off\n/timesheet-admin reminder on\n```\n\nText-based rather than modal — config changes are infrequent and a simple syntax is faster.\n\n### Weekly Reminder (Cron)\n\nA separate Val Town cron val runs at the configured day/time (default: Friday 3:00 PM ET).\n\n1. Query registered interns with no `time_entries` for the current week.\n2. DM each via Slack: \"You haven't logged any time this week. Use /logtime to log your hours.\"\n\nConfigurable via `/timesheet-admin reminder` commands. Can be toggled on/off.\n\n## Architecture\n\n### Request Flow\n\n```\nSlack Platform\n |\n | POST (slash commands, interactions)\n v\nMain HTTP Val (request router)\n |\n ├── Verify Slack signature (HMAC-SHA256)\n ├── Parse payload type\n └── Route to handler:\n ├── command=/logtime → open modal / list entries\n ├── command=/timesheet → generate report\n ├── command=/timesheet-admin → CRUD lookup tables\n └── type=view_submission → save/update time entry\n └── type=block_actions → edit/delete button clicks\n\nSQLite (Val Town built-in)\n\nCron Val (weekly reminder)\n └── Queries same SQLite, sends DMs via Slack API\n```\n\n### Code Organization\n\n```\nlakeland-timesheet/\n├── main.ts # HTTP handler + router\n├── cron.ts # Weekly reminder cron val\n├── slack/\n│ ├── verify.ts # Request signature verification\n│ ├── modals.ts # Block Kit modal definitions\n│ └── api.ts # Slack Web API calls\n├── handlers/\n│ ├── logtime.ts # Open modal, list entries\n│ ├── submission.ts # Modal submission → save/update entry\n│ ├── report.ts # Report generation + formatting\n│ └── admin.ts # Admin CRUD for lookup tables + config\n├── db/\n│ ├── schema.ts # CREATE TABLE statements + migration\n│ └── queries.ts # Parameterized SQL queries\n└── lib/\n └── format.ts # Duration formatting, date helpers\n```\n\n### Slack App Configuration\n\n**OAuth Scopes (Bot Token):**\n\n| Scope | Purpose |\n|-------|---------|\n| `commands` | Register slash commands |\n| `chat:write` | Ephemeral confirmations and reports |\n| `users:read` | Resolve @mentions in report arguments |\n| `im:write` | DM interns for weekly reminders |\n\n**Slash Commands** — all three point to the same Val Town HTTP endpoint URL. The router distinguishes by the `command` field.\n\n**Interactivity Request URL** — same endpoint. Receives `view_submission` and `block_actions` payloads.\n\n**Environment Variables (Val Town Secrets):**\n- `SLACK_BOT_TOKEN` — xoxb-... from OAuth install\n- `SLACK_SIGNING_SECRET` — for request signature verification\n\n### Key Constraints\n\n- **3-second rule:** Slack requires acknowledgement within 3 seconds. `/logtime` calls `views.open` and returns 200 immediately. `/timesheet` may need to acknowledge first and post the report as a follow-up via `response_url` if generation takes too long.\n- **Val Town cron is UTC-based.** The reminder schedule must account for ET (UTC-5 or UTC-4 depending on DST).\n- **10MB SQLite on free tier.** Thousands of timesheet entries fit easily — this is not a constraint at this scale.\n\n## Future Features (post-v1)\n\n- Inline slash command parsing (`/logtime 1h transcription`) for power users\n- CSV export (`/timesheet export 2026-02`) for grant reporting\n- App Home tab with persistent view of recent entries and weekly totals\n",[],[212,482,484],"56b8af88-132b-11f1-8e0b-42dde27851f2",69,["D",1772121228458],[312,313],[212,482],["D",1772121228268],[311],[212],"9ef9bbae-130b-11f1-8d22-42dde27851f2","types.ts","9ef9bc9e-130b-11f1-8d22-42dde27851f2",12,["D",1772107605783],"export interface DbResult {\n columns: string[];\n rows: unknown[][];\n rowsAffected: number;\n lastInsertRowid: bigint | number;\n}\n\nexport interface Database {\n execute(query: { sql: string; args?: unknown[] }): Promise;\n batch(queries: Array): Promise;\n}\n",[],[218,500],"47453c00-130e-11f1-9855-42dde27851f2","test-helpers.ts","9ef4db84-130b-11f1-8f11-42dde27851f2",31,["D",1772108747126],"import { createClient } from \"@libsql/client\";\nimport type { Database } from \"./types.ts\";\n\n/**\n * Creates an in-memory SQLite database for testing.\n * Uses @libsql/client with file::memory: URL.\n */\nexport async function createTestDb(): Promise {\n const client = createClient({ url: \"file::memory:\" });\n return {\n async execute(query) {\n const result = await client.execute(query);\n return {\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n };\n },\n async batch(queries) {\n const results = await client.batch(\n queries.map((q) => (typeof q === \"string\" ? q : q))\n );\n return results.map((result) => ({\n columns: result.columns,\n rows: result.rows.map((r) => Object.values(r)),\n rowsAffected: result.rowsAffected,\n lastInsertRowid: result.lastInsertRowid ?? 0,\n }));\n },\n };\n}\n",[],[218,508],"476555e4-130e-11f1-9770-42dde27851f2","schema.ts","9edb2680-130b-11f1-bab2-42dde27851f2",36,["D",1772108746988],"import type { Database } from \"./types.ts\";\n\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS grants (\n id INTEGER PRIMARY KEY,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS task_types (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL UNIQUE,\n active INTEGER NOT NULL DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS time_entries (\n id INTEGER PRIMARY KEY,\n slack_user_id TEXT NOT NULL,\n slack_username TEXT NOT NULL,\n date TEXT NOT NULL,\n minutes INTEGER NOT NULL,\n project_id INTEGER REFERENCES projects(id),\n grant_id INTEGER REFERENCES grants(id),\n task_type_id INTEGER NOT NULL REFERENCES task_types(id),\n comment TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now')),\n deleted_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS interns (\n slack_user_id TEXT PRIMARY KEY,\n slack_username TEXT NOT NULL,\n added_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS config (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n];\n\nexport async function migrate(db: Database): Promise {\n await db.batch(SCHEMA);\n}\n",[],[218,516],"4740380e-130e-11f1-8d42-42dde27851f2","schema.test.ts","9efeb7da-130b-11f1-8e57-42dde27851f2",30,["D",1772108747083],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"./test-helpers.ts\";\nimport { migrate } from \"./schema.ts\";\nimport type { Database } from \"./types.ts\";\n\ndescribe(\"schema migration\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n });\n\n it(\"creates all required tables\", async () => {\n await migrate(db);\n\n const result = await db.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table' ORDER BY name\",\n });\n const tables = result.rows.map((r) => r[0]);\n\n expect(tables).toContain(\"projects\");\n expect(tables).toContain(\"grants\");\n expect(tables).toContain(\"task_types\");\n expect(tables).toContain(\"time_entries\");\n expect(tables).toContain(\"interns\");\n expect(tables).toContain(\"config\");\n });\n\n it(\"is idempotent — running twice does not error\", async () => {\n await migrate(db);\n await expect(migrate(db)).resolves.not.toThrow();\n });\n});\n",[],[218,524],"477f0552-130e-11f1-abac-42dde27851f2","queries.ts","9eebf1f4-130b-11f1-bab2-42dde27851f2",40,["D",1772108747167],"import type { Database } from \"./types.ts\";\n\n// --- Lookup table types ---\n\nexport interface Project {\n id: number;\n name: string;\n}\n\nexport interface Grant {\n id: number;\n code: string;\n name: string;\n}\n\nexport interface TaskType {\n id: number;\n name: string;\n}\n\n// --- Project CRUD ---\n\nexport async function addProject(db: Database, name: string): Promise {\n await db.execute({ sql: \"INSERT INTO projects (name) VALUES (?)\", args: [name] });\n}\n\nexport async function getActiveProjects(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM projects WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n name: row[1] as string,\n }));\n}\n\nexport async function deactivateProject(db: Database, name: string): Promise {\n await db.execute({\n sql: \"UPDATE projects SET active = 0 WHERE name = ?\",\n args: [name],\n });\n}\n\n// --- Grant CRUD ---\n\nexport async function addGrant(db: Database, code: string, name: string): Promise {\n await db.execute({\n sql: \"INSERT INTO grants (code, name) VALUES (?, ?)\",\n args: [code, name],\n });\n}\n\nexport async function getActiveGrants(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, code, name FROM grants WHERE active = 1 ORDER BY code\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n code: row[1] as string,\n name: row[2] as string,\n }));\n}\n\nexport async function deactivateGrant(db: Database, code: string): Promise {\n await db.execute({\n sql: \"UPDATE grants SET active = 0 WHERE code = ?\",\n args: [code],\n });\n}\n\n// --- TaskType CRUD ---\n\nexport async function addTaskType(db: Database, name: string): Promise {\n await db.execute({\n sql: \"INSERT INTO task_types (name) VALUES (?)\",\n args: [name],\n });\n}\n\nexport async function getActiveTaskTypes(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT id, name FROM task_types WHERE active = 1 ORDER BY name\",\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n name: row[1] as string,\n }));\n}\n\nexport async function deactivateTaskType(db: Database, name: string): Promise {\n await db.execute({\n sql: \"UPDATE task_types SET active = 0 WHERE name = ?\",\n args: [name],\n });\n}\n\n// --- Time entry types ---\n\nexport interface TimeEntryInput {\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n}\n\nexport interface TimeEntry {\n id: number;\n slackUserId: string;\n slackUsername: string;\n date: string;\n minutes: number;\n taskTypeId: number;\n projectId: number | null;\n grantId: number | null;\n comment: string | null;\n createdAt: string;\n}\n\n// --- Time entry CRUD ---\n\nexport async function createTimeEntry(db: Database, input: TimeEntryInput): Promise {\n const result = await db.execute({\n sql: `INSERT INTO time_entries (slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n input.slackUserId,\n input.slackUsername,\n input.date,\n input.minutes,\n input.taskTypeId,\n input.projectId,\n input.grantId,\n input.comment,\n ],\n });\n return Number(result.lastInsertRowid);\n}\n\nexport async function getTimeEntryById(db: Database, id: number): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries WHERE id = ? AND deleted_at IS NULL`,\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row[0] as number,\n slackUserId: row[1] as string,\n slackUsername: row[2] as string,\n date: row[3] as string,\n minutes: row[4] as number,\n taskTypeId: row[5] as number,\n projectId: row[6] as number | null,\n grantId: row[7] as number | null,\n comment: row[8] as string | null,\n createdAt: row[9] as string,\n };\n}\n\nexport async function updateTimeEntry(\n db: Database,\n id: number,\n updates: Partial>\n): Promise {\n const setClauses: string[] = [];\n const args: unknown[] = [];\n\n const columnMap: Record = {\n minutes: \"minutes\",\n taskTypeId: \"task_type_id\",\n projectId: \"project_id\",\n grantId: \"grant_id\",\n comment: \"comment\",\n date: \"date\",\n };\n\n for (const [key, value] of Object.entries(updates)) {\n const column = columnMap[key];\n if (column) {\n setClauses.push(`${column} = ?`);\n args.push(value);\n }\n }\n\n if (setClauses.length === 0) return;\n\n setClauses.push(\"updated_at = datetime('now')\");\n args.push(id);\n\n await db.execute({\n sql: `UPDATE time_entries SET ${setClauses.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\nexport async function softDeleteTimeEntry(db: Database, id: number): Promise {\n await db.execute({\n sql: \"UPDATE time_entries SET deleted_at = datetime('now') WHERE id = ?\",\n args: [id],\n });\n}\n\nexport async function getRecentEntries(\n db: Database,\n slackUserId: string,\n limit: number\n): Promise {\n const result = await db.execute({\n sql: `SELECT id, slack_user_id, slack_username, date, minutes, task_type_id, project_id, grant_id, comment, created_at\n FROM time_entries\n WHERE slack_user_id = ? AND deleted_at IS NULL\n ORDER BY date DESC, created_at DESC\n LIMIT ?`,\n args: [slackUserId, limit],\n });\n return result.rows.map((row) => ({\n id: row[0] as number,\n slackUserId: row[1] as string,\n slackUsername: row[2] as string,\n date: row[3] as string,\n minutes: row[4] as number,\n taskTypeId: row[5] as number,\n projectId: row[6] as number | null,\n grantId: row[7] as number | null,\n comment: row[8] as string | null,\n createdAt: row[9] as string,\n }));\n}\n\n// --- Intern types ---\n\nexport interface Intern {\n slackUserId: string;\n slackUsername: string;\n}\n\n// --- Intern management ---\n\nexport async function addIntern(\n db: Database,\n slackUserId: string,\n slackUsername: string\n): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO interns (slack_user_id, slack_username) VALUES (?, ?)\",\n args: [slackUserId, slackUsername],\n });\n}\n\nexport async function removeIntern(db: Database, slackUserId: string): Promise {\n await db.execute({\n sql: \"DELETE FROM interns WHERE slack_user_id = ?\",\n args: [slackUserId],\n });\n}\n\nexport async function getInterns(db: Database): Promise {\n const result = await db.execute({\n sql: \"SELECT slack_user_id, slack_username FROM interns ORDER BY slack_username\",\n });\n return result.rows.map((row) => ({\n slackUserId: row[0] as string,\n slackUsername: row[1] as string,\n }));\n}\n\n// --- Report queries ---\n\nexport interface ReportRow {\n slackUserId: string;\n slackUsername: string;\n taskTypeName: string;\n grantCode: string | null;\n totalMinutes: number;\n}\n\nexport async function getReportData(\n db: Database,\n startDate: string,\n endDate: string,\n slackUserId: string | null\n): Promise {\n const args: unknown[] = [startDate, endDate];\n let userFilter = \"\";\n if (slackUserId) {\n userFilter = \"AND te.slack_user_id = ?\";\n args.push(slackUserId);\n }\n\n const result = await db.execute({\n sql: `SELECT te.slack_user_id, te.slack_username, tt.name as task_type_name,\n g.code as grant_code, SUM(te.minutes) as total_minutes\n FROM time_entries te\n JOIN task_types tt ON te.task_type_id = tt.id\n LEFT JOIN grants g ON te.grant_id = g.id\n WHERE te.date >= ? AND te.date <= ? AND te.deleted_at IS NULL ${userFilter}\n GROUP BY te.slack_user_id, te.slack_username, tt.name, g.code\n ORDER BY te.slack_username, tt.name`,\n args,\n });\n\n return result.rows.map((r) => ({\n slackUserId: r[0] as string,\n slackUsername: r[1] as string,\n taskTypeName: r[2] as string,\n grantCode: r[3] as string | null,\n totalMinutes: r[4] as number,\n }));\n}\n\n// --- Config key-value store ---\n\nexport async function setConfig(db: Database, key: string, value: string): Promise {\n await db.execute({\n sql: \"INSERT OR REPLACE INTO config (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\nexport async function getConfig(db: Database, key: string): Promise {\n const result = await db.execute({\n sql: \"SELECT value FROM config WHERE key = ?\",\n args: [key],\n });\n if (result.rows.length === 0) return null;\n return result.rows[0][0] as string;\n}\n",[],[218,532],"4733f76a-130e-11f1-8d42-42dde27851f2","queries.test.ts","9ee5d0e4-130b-11f1-aee3-42dde27851f2",28,["D",1772108747000],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport type { Database } from \"./types.ts\";\nimport { createTestDb } from \"./test-helpers.ts\";\nimport { migrate } from \"./schema.ts\";\nimport {\n addProject,\n getActiveProjects,\n deactivateProject,\n addGrant,\n getActiveGrants,\n deactivateGrant,\n addTaskType,\n getActiveTaskTypes,\n deactivateTaskType,\n createTimeEntry,\n getTimeEntryById,\n updateTimeEntry,\n softDeleteTimeEntry,\n getRecentEntries,\n addIntern,\n removeIntern,\n getInterns,\n setConfig,\n getConfig,\n getReportData,\n} from \"./queries.ts\";\nimport type { TimeEntryInput } from \"./queries.ts\";\n\ndescribe(\"Lookup table CRUD\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n // --- Projects ---\n\n it(\"adds and retrieves active projects\", async () => {\n await addProject(db, \"Lakeland Archive\");\n await addProject(db, \"Timesheet App\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(2);\n expect(projects[0].name).toBe(\"Lakeland Archive\");\n expect(projects[1].name).toBe(\"Timesheet App\");\n });\n\n it(\"deactivates a project without deleting it\", async () => {\n await addProject(db, \"Old Project\");\n await deactivateProject(db, \"Old Project\");\n\n const projects = await getActiveProjects(db);\n expect(projects).toHaveLength(0);\n });\n\n // --- Grants ---\n\n it(\"adds and retrieves active grants\", async () => {\n await addGrant(db, \"NEH-123\", \"NEH Digital Humanities\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(1);\n expect(grants[0].code).toBe(\"NEH-123\");\n expect(grants[0].name).toBe(\"NEH Digital Humanities\");\n });\n\n it(\"deactivates a grant\", async () => {\n await addGrant(db, \"NEH-123\", \"NEH Digital Humanities\");\n await deactivateGrant(db, \"NEH-123\");\n\n const grants = await getActiveGrants(db);\n expect(grants).toHaveLength(0);\n });\n\n // --- Task Types ---\n\n it(\"adds and retrieves active task types\", async () => {\n await addTaskType(db, \"Development\");\n await addTaskType(db, \"Research\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(2);\n });\n\n it(\"deactivates a task type\", async () => {\n await addTaskType(db, \"Development\");\n await deactivateTaskType(db, \"Development\");\n\n const types = await getActiveTaskTypes(db);\n expect(types).toHaveLength(0);\n });\n});\n\ndescribe(\"Time entry CRUD\", () => {\n let db: Database;\n let taskTypeId: number;\n let projectId: number;\n let grantId: number;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Development\");\n const types = await getActiveTaskTypes(db);\n taskTypeId = types[0].id;\n await addProject(db, \"Test Project\");\n const projects = await getActiveProjects(db);\n projectId = projects[0].id;\n await addGrant(db, \"G-001\", \"Test Grant\");\n const grants = await getActiveGrants(db);\n grantId = grants[0].id;\n });\n\n it(\"creates entry and retrieves it\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 120,\n taskTypeId,\n projectId,\n grantId,\n comment: \"Worked on feature X\",\n };\n const id = await createTimeEntry(db, input);\n const entry = await getTimeEntryById(db, id);\n\n expect(entry).not.toBeNull();\n expect(entry!.minutes).toBe(120);\n expect(entry!.slackUsername).toBe(\"alice\");\n expect(entry!.comment).toBe(\"Worked on feature X\");\n });\n\n it(\"creates entry with optional fields null\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n };\n const id = await createTimeEntry(db, input);\n const entry = await getTimeEntryById(db, id);\n\n expect(entry).not.toBeNull();\n expect(entry!.projectId).toBeNull();\n expect(entry!.grantId).toBeNull();\n expect(entry!.comment).toBeNull();\n });\n\n it(\"updates an existing entry\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: \"initial\",\n };\n const id = await createTimeEntry(db, input);\n await updateTimeEntry(db, id, { minutes: 90, comment: \"updated\" });\n\n const entry = await getTimeEntryById(db, id);\n expect(entry!.minutes).toBe(90);\n expect(entry!.comment).toBe(\"updated\");\n });\n\n it(\"soft-deletes and excludes from getRecentEntries\", async () => {\n const input: TimeEntryInput = {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: \"2026-02-26\",\n minutes: 60,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n };\n const id = await createTimeEntry(db, input);\n await softDeleteTimeEntry(db, id);\n\n const entries = await getRecentEntries(db, \"U123\", 10);\n expect(entries).toHaveLength(0);\n\n const entry = await getTimeEntryById(db, id);\n expect(entry).toBeNull();\n });\n\n it(\"retrieves recent entries limited and ordered\", async () => {\n for (let i = 1; i <= 5; i++) {\n await createTimeEntry(db, {\n slackUserId: \"U123\",\n slackUsername: \"alice\",\n date: `2026-02-0${i}`,\n minutes: i * 30,\n taskTypeId,\n projectId: null,\n grantId: null,\n comment: null,\n });\n }\n // soft-delete the last one\n await softDeleteTimeEntry(db, 5);\n\n const entries = await getRecentEntries(db, \"U123\", 3);\n expect(entries).toHaveLength(3);\n // most recent first\n expect(entries[0].date).toBe(\"2026-02-04\");\n expect(entries[1].date).toBe(\"2026-02-03\");\n expect(entries[2].date).toBe(\"2026-02-02\");\n });\n});\n\ndescribe(\"Intern management\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"adds and lists interns\", async () => {\n await addIntern(db, \"U001\", \"alice\");\n await addIntern(db, \"U002\", \"bob\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(2);\n // ordered by username\n expect(interns[0].slackUsername).toBe(\"alice\");\n expect(interns[1].slackUsername).toBe(\"bob\");\n });\n\n it(\"removes an intern\", async () => {\n await addIntern(db, \"U001\", \"alice\");\n await removeIntern(db, \"U001\");\n\n const interns = await getInterns(db);\n expect(interns).toHaveLength(0);\n });\n});\n\ndescribe(\"Config key-value store\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n });\n\n it(\"sets and gets config values\", async () => {\n await setConfig(db, \"reminder_channel\", \"C12345\");\n const value = await getConfig(db, \"reminder_channel\");\n expect(value).toBe(\"C12345\");\n });\n\n it(\"upserts config on conflict\", async () => {\n await setConfig(db, \"reminder_channel\", \"C12345\");\n await setConfig(db, \"reminder_channel\", \"C99999\");\n\n const value = await getConfig(db, \"reminder_channel\");\n expect(value).toBe(\"C99999\");\n });\n\n it(\"returns null for missing config keys\", async () => {\n const value = await getConfig(db, \"nonexistent\");\n expect(value).toBeNull();\n });\n});\n\ndescribe(\"report query\", () => {\n let db: Database;\n\n beforeEach(async () => {\n db = await createTestDb();\n await migrate(db);\n await addTaskType(db, \"Transcription\");\n await addTaskType(db, \"Metadata Editing\");\n await addGrant(db, \"NEH-PW-290261\", \"NEH\");\n });\n\n it(\"aggregates hours by user, task, and grant for a date range\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 120, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-25\",\n minutes: 60, taskTypeId: 2, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-25\",\n minutes: 90, taskTypeId: 1, projectId: null, grantId: 1, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", null);\n expect(data).toHaveLength(3);\n // Ordered by username then task name\n expect(data[0].slackUsername).toBe(\"james\");\n expect(data[0].totalMinutes).toBe(90);\n });\n\n it(\"filters by user when specified\", async () => {\n await createTimeEntry(db, {\n slackUserId: \"U123\", slackUsername: \"maria\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n await createTimeEntry(db, {\n slackUserId: \"U456\", slackUsername: \"james\", date: \"2026-02-24\",\n minutes: 60, taskTypeId: 1, projectId: null, grantId: null, comment: null,\n });\n\n const data = await getReportData(db, \"2026-02-24\", \"2026-02-28\", \"U123\");\n expect(data).toHaveLength(1);\n expect(data[0].slackUsername).toBe(\"maria\");\n });\n});\n",[],[218,540],["D",1772107605164],[304,305,306,307,308,309],[218],"59f7a53c-132b-11f1-9db5-42dde27851f2","59f7a5dc-132b-11f1-9db5-42dde27851f2",129,["D",1772121233903],"Unnamed repository; edit this file 'description' to name the repository.\n",[],[224,50],"59c26d40-132b-11f1-b163-42dde27851f2","config","59c26dd6-132b-11f1-b163-42dde27851f2",120,["D",1772121233554],"[core]\n\trepositoryformatversion = 0\n\tfilemode = true\n\tbare = false\n\tlogallrefupdates = true\n\tignorecase = true\n\tprecomposeunicode = true\n",[],[224,558],"59e2b8f2-132b-11f1-9db5-42dde27851f2","HEAD","59e2b9e2-132b-11f1-9db5-42dde27851f2",126,["D",1772121233753],"ref: refs/heads/main\n",[],[224,566],"598ddd46-132b-11f1-af4c-42dde27851f2","tags","598dddfa-132b-11f1-af4c-42dde27851f2","5711f980-132b-11f1-b163-42dde27851f2",114,["D",1772121233213],[],[224,581,574],"refs","597d9eae-132b-11f1-b93a-42dde27851f2","heads","597d9f80-132b-11f1-b93a-42dde27851f2",113,["D",1772121233103],[],[224,581,583],"5711f886-132b-11f1-b163-42dde27851f2",74,["D",1772121229041],[298,299],[224,581],"57f68d66-132b-11f1-a19c-42dde27851f2","pack","57f68e06-132b-11f1-a19c-42dde27851f2","56c7750e-132b-11f1-8b48-42dde27851f2",88,["D",1772121230540],[],[224,602,595],"objects","5840b10c-132b-11f1-8fb2-42dde27851f2","info","5840b1ac-132b-11f1-8fb2-42dde27851f2",93,["D",1772121231030],[],[224,602,604],"5915b23a-132b-11f1-b163-42dde27851f2","f6","5915b2d0-132b-11f1-b163-42dde27851f2",106,["D",1772121232423],[],[224,602,611],"57ac915c-132b-11f1-b163-42dde27851f2","eb","57ac9210-132b-11f1-b163-42dde27851f2",84,["D",1772121230053],[],[224,602,618],"58f61588-132b-11f1-b163-42dde27851f2","ea","58f6163c-132b-11f1-b163-42dde27851f2",104,["D",1772121232194],[],[224,602,625],"57c0057a-132b-11f1-b93a-42dde27851f2","e4","57c0064c-132b-11f1-b93a-42dde27851f2",85,["D",1772121230165],[],[224,602,632],"589ec364-132b-11f1-8fb2-42dde27851f2","589ec47c-132b-11f1-8fb2-42dde27851f2",99,["D",1772121231646],[],[224,602,218],"5796ce4e-132b-11f1-b93a-42dde27851f2","d8","5796cef8-132b-11f1-b93a-42dde27851f2",83,["D",1772121229913],[],[224,602,645],"586fdb3a-132b-11f1-b163-42dde27851f2","d3","586fdbee-132b-11f1-b163-42dde27851f2",96,["D",1772121231331],[],[224,602,652],"5906a7a4-132b-11f1-8e0b-42dde27851f2","c5","5906a844-132b-11f1-8e0b-42dde27851f2",105,["D",1772121232322],[],[224,602,659],"58e315aa-132b-11f1-b6c9-42dde27851f2","c3","58e31654-132b-11f1-b6c9-42dde27851f2",103,["D",1772121232090],[],[224,602,666],"57d4253c-132b-11f1-b163-42dde27851f2","c1","57d425f0-132b-11f1-b163-42dde27851f2",86,["D",1772121230315],[],[224,602,673],"589296d4-132b-11f1-b163-42dde27851f2","b1","589297c4-132b-11f1-b163-42dde27851f2",98,["D",1772121231562],[],[224,602,680],"58c18da4-132b-11f1-8fb2-42dde27851f2","b0","58c18e76-132b-11f1-8fb2-42dde27851f2",101,["D",1772121231874],[],[224,602,687],"58b21e3c-132b-11f1-954f-42dde27851f2","a8","58b21f22-132b-11f1-954f-42dde27851f2",100,["D",1772121231769],[],[224,602,694],"58836d8a-132b-11f1-8e0b-42dde27851f2","a7","58836e8e-132b-11f1-8e0b-42dde27851f2",97,["D",1772121231463],[],[224,602,701],"59dfea14-132b-11f1-8f1f-42dde27851f2","4a05f7473970bb341c58a869b8d994a8ab287b","59dfead2-132b-11f1-8f1f-42dde27851f2","58d4d8aa-132b-11f1-954f-42dde27851f2",125,["D",1772121233670],"x\u0001Ւ�n�0\u0010�{�S\f|��TN\u000e�(M�\"�\u0004\b�6?��\u0007�Y5,(�!Wu\fC�^��\u000b�7��p?�ֶ��هw�][��A:\u0012L�Z��\u0013�vM�5\u000f\u001cjm��G�l��'�j��W2\r.γ� \tv�\u0011,j�i?_�bǗ��l�Z.3,q��<��2�[j��۝b��X\u0007&��,��ɓ�<\u001e\u001b�/h��\u001a\\*<��UFoi3�F��de͸�c��װ��qz�%v\u0019 ��aG\\��;tNWX�b\u0017�� tĝ3�\u0003\u0018��dǔ�v��ؚ\"\u001c�Ns�\u0010\u001b��r&\t6�\u0014�pfQ� ��Z�Љ��x?\t�\u001a��C7^�V��\u0015��ė�\u0017I.\u000bݑ\u000f�b��4�M�{��Q-<�\u001aO��F\u001d��긺��#8�\u001f�\u0003�Z�|I�\u0014�C��\u0006�~��;��}�1\u000e\u001cs\u001c�MH\u0012��%��p�[�ŸlB\u001cp��\u001f�dF�",[],[224,602,716,708],"a1","58d4d800-132b-11f1-954f-42dde27851f2",102,["D",1772121231997],[280],[224,602,716],"57887efc-132b-11f1-af4c-42dde27851f2","9c","57887fba-132b-11f1-af4c-42dde27851f2",82,["D",1772121229822],[],[224,602,723],"575c6010-132b-11f1-8089-42dde27851f2","9b","575c60e2-132b-11f1-8089-42dde27851f2",79,["D",1772121229533],[],[224,602,730],"59cccbc8-132b-11f1-8b48-42dde27851f2","fdceae0689483bd1542e8f56c67442447a655b","59ccccb8-132b-11f1-8b48-42dde27851f2","585030b4-132b-11f1-b163-42dde27851f2",122,["D",1772121233623],"x\u0001]R�j�@\u0010̳�bȓ\fFI\u001fBA�]�Z�\u0002G\u000e�C(�8'i�\u001e�N�݊8\u0018�{�:��\u0007qڙ�ٝSZT)�^^��rWi\u0006��\b\u0007L\u0004�T\u0018�\u0011O�*q\u001e\u0004\u0017yz�P\u0013�9��X1i�\u001f��&-O|��0o*�S�2��՚\u0007��#�N�{@��\u001f�\f��a��NF�=j��H*A�;;�4t�6^��8XbV)��d�1�x\u0015��E@{�j&�q��K\u0011�q\u0011M��K��\u0014\"{�Ԇ�F��^A��\u001a��\u0001��[�&\u0006\u0003�\u0001\u001e~G󨧴��̖�\u0013�5?��x��\u0013��\u001f�5aY҆ژ,�ס5��Ƅ�\b��=��FM�[��`�\u000b$��i�Ӡs��'�\u001c?��vp�?��\u0001��&��v��;Y;�8��oM\\��M?�ի\tJ��}=�h\f��&�{�s��Ы�5�9��'�\\\u001d��\u0003[\u0007kq��\u0001m��\u0016",[],[224,602,745,737],"91","58502ff6-132b-11f1-b163-42dde27851f2",94,["D",1772121231128],[276],[224,602,745],"5945fc6a-132b-11f1-8089-42dde27851f2","8d","5945fd28-132b-11f1-8089-42dde27851f2",109,["D",1772121232742],[],[224,602,752],"5804efaa-132b-11f1-8fb2-42dde27851f2","89","5804f086-132b-11f1-8fb2-42dde27851f2",89,["D",1772121230638],[],[224,602,759],"58342572-132b-11f1-b163-42dde27851f2","6e","5834263a-132b-11f1-b163-42dde27851f2",92,["D",1772121230945],[],[224,602,766],"58600624-132b-11f1-b93a-42dde27851f2","65","586006e2-132b-11f1-b93a-42dde27851f2",95,["D",1772121231232],[],[224,602,773],"5723ed34-132b-11f1-8089-42dde27851f2","59","5723ee1a-132b-11f1-8089-42dde27851f2",75,["D",1772121229144],[],[224,602,780],"574dd806-132b-11f1-8b48-42dde27851f2","57","574dd8c4-132b-11f1-8b48-42dde27851f2",78,["D",1772121229434],[],[224,602,787],"573e69e8-132b-11f1-8089-42dde27851f2","50","573e6aba-132b-11f1-8089-42dde27851f2",77,["D",1772121229337],[],[224,602,794],"5933f92a-132b-11f1-b163-42dde27851f2","48","5933f9c0-132b-11f1-b163-42dde27851f2",108,["D",1772121232621],[],[224,602,801],"59d0566c-132b-11f1-b6c9-42dde27851f2","26b701f07d511c4f1a8e160f25e4adcf5c8137","59d0572a-132b-11f1-b6c9-42dde27851f2","57306fd2-132b-11f1-af4c-42dde27851f2",123,["D",1772121233612],"x\u0001�U�n�@\u0010圯\u0018�&�\u001bH\u0010��BE�*�\u0004��8l�cw��\r��\u0012��:��\u0010bl\"%��޼��]dv\u0001�ӓ�Ot��a\r\n]Lz�\u0011h\u001f\u0001�Xb��\u0011\u0012�9��8\u001f5�KI\u000e/U��[��Ҩ&v�L��S�8~TÎ�^��`<��\u0017�\u001e\u0001�V\u0011\u000e�R�$��\u0005�@�j��4>j�\b�\n��\u0003�'��vޒF'�&\u0013�\n��W�\u000b�� c��9\u0003�\u0018̇�s&?n%HJ�\u0019|>��\u0005\u001e'�\u001c~�kII\u001a\u000f��Al\u0015B0��\u001c\u0007\u0015�\u0001\u0011ﮮ�o>\u001d�O��Of\u0002�3�\u0010:��\fe�S��ct\u0003k-�YO]�.M��]��۠:C\u0002�\u000f�4F�tX�*��\u0006�D�ܮ\u0010\u0006�l��\u0016��iO�p�\u0019�q_+E\u0019�9�\u0015\\=�Ȳ��\r��#��\u0003]��A\u001e@��-�\u0005��l��W.I�\u000b�)��\u0001aκ�\u0001�\u001fE�%�YBӒ�\u000e�X0��\\5�솧v��\u000f�\f��b�ck\u0012��S�\u0017��n��\u0004fhT��\u0015J�r�s5\u0018�$\u0019N\u001b�\u001aښ��g\t}A�\u0001\u0012Y��!�mj�OT�Ty9��^)\u000b��x��=jRݚKޖO;�H��E�\u0014>\u0012�/<�\u0011�7�\"\b��/��p�o�>�\fq��7��h�",[],[224,602,816,808],"3e","57306f0a-132b-11f1-af4c-42dde27851f2",76,["D",1772121229245],[266],[224,602,816],"581438b6-132b-11f1-b163-42dde27851f2","2f","5814397e-132b-11f1-b163-42dde27851f2",90,["D",1772121230735],[],[224,602,823],"59d80286-132b-11f1-ad1d-42dde27851f2","c5d78c8f686dc02b926ad52c78cb0e899f1ab9","59d80362-132b-11f1-ad1d-42dde27851f2","5951c7c0-132b-11f1-af4c-42dde27851f2",124,["D",1772121233687],"x\u0001u�MK�0\u0010�=�W�\u001c��Q��T(�\u0001�MD�t\\�MfBf�\u000b��d��*x��d\u001e��T_\\�\u001f}Vum,��\u000e�}Pd\u0012sU�8\u0003\u001d�\n4�M�؞��9��\u0001�]*��cJ4g��hD[�\u001a\u0013,:�۝p ��7\u001c��\u0007��z�~�@��y !�=�\u0011�q��J(yH�Q�b��\\�n�P�\u001e\u0018d��\u0006��\u001d�z!��,i��Ks��l��9Q1/;\u0002�\u001fB<��8\u0019W��\u000b�0l_",[],[224,602,838,830],"2e","5951c716-132b-11f1-af4c-42dde27851f2",110,["D",1772121232820],[263],[224,602,838],"5924024a-132b-11f1-8e0b-42dde27851f2","2c","59240326-132b-11f1-8e0b-42dde27851f2",107,["D",1772121232516],[],[224,602,845],"595d7c1e-132b-11f1-b6c9-42dde27851f2","22","595d7cc8-132b-11f1-b6c9-42dde27851f2",111,["D",1772121232893],[],[224,602,852],"57e3a6d8-132b-11f1-b93a-42dde27851f2","20","57e3a782-132b-11f1-b93a-42dde27851f2",87,["D",1772121230417],[],[224,602,859],"577a4aee-132b-11f1-b6c9-42dde27851f2","0e","577a4bc0-132b-11f1-b6c9-42dde27851f2",81,["D",1772121229726],[],[224,602,866],"576b12a4-132b-11f1-b163-42dde27851f2","0b","576b134e-132b-11f1-b163-42dde27851f2",80,["D",1772121229626],[],[224,602,873],"582407a0-132b-11f1-b93a-42dde27851f2","00","58240872-132b-11f1-b93a-42dde27851f2",91,["D",1772121230837],[],[224,602,880],"56c7743c-132b-11f1-8b48-42dde27851f2",70,["D",1772121228555],[256,257,258,259,260,261,262,264,265,267,268,269,270,271,272,273,274,275,277,278,279,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296],[224,602],"59ecbadc-132b-11f1-8f1f-42dde27851f2","59ecbbae-132b-11f1-8f1f-42dde27851f2","56f0524e-132b-11f1-8b48-42dde27851f2",127,["D",1772121233793],"0000000000000000000000000000000000000000 c39dde5a80ec35d034aa6ff9d5ed4e5a1e5e97e5 Trevor Muñoz 1772120776 -0500\tcommit (initial): feat(timesheet): consolidate repos and add public share command\n",[],[224,899,566],"logs","5a2246ac-132b-11f1-ad1d-42dde27851f2","5a22474c-132b-11f1-ad1d-42dde27851f2","599e79f8-132b-11f1-8fb2-42dde27851f2",136,["D",1772121233841],[],[224,899,581,583,83],"599e7926-132b-11f1-8fb2-42dde27851f2","596f06aa-132b-11f1-954f-42dde27851f2",115,["D",1772121233320],[253],[224,899,581,583],"596f05ce-132b-11f1-954f-42dde27851f2",112,["D",1772121233009],[252],[224,899,581],"56f05168-132b-11f1-8b48-42dde27851f2",72,["D",1772121228821],[251,254],[224,899],"59f06c18-132b-11f1-b6c9-42dde27851f2","exclude","59f06cf4-132b-11f1-b6c9-42dde27851f2","56dafa66-132b-11f1-8e0b-42dde27851f2",128,["D",1772121233764],"# git ls-files --others --exclude-from=.git/info/exclude\n# Lines that start with '#' are comments.\n# For a project mostly in C, the following would be a good set of\n# exclude patterns (uncomment them if you want to use them):\n# *.[oa]\n# *~\n",[],[224,604,924],"56daf994-132b-11f1-8e0b-42dde27851f2",71,["D",1772121228678],[249],[224,604],"5a08970c-132b-11f1-8b48-42dde27851f2","sendemail-validate.sample","5a0897b6-132b-11f1-8b48-42dde27851f2","57012ab0-132b-11f1-b6c9-42dde27851f2",132,["D",1772121234014],"#!/bin/sh\n\n# An example hook script to validate a patch (and/or patch series) before\n# sending it via email.\n#\n# The hook should exit with non-zero status after issuing an appropriate\n# message if it wants to prevent the email(s) from being sent.\n#\n# To enable this hook, rename this file to \"sendemail-validate\".\n#\n# By default, it will only check that the patch(es) can be applied on top of\n# the default upstream branch without conflicts in a secondary worktree. After\n# validation (successful or not) of the last patch of a series, the worktree\n# will be deleted.\n#\n# The following config variables can be set to change the default remote and\n# remote ref that are used to apply the patches against:\n#\n# sendemail.validateRemote (default: origin)\n# sendemail.validateRemoteRef (default: HEAD)\n#\n# Replace the TODO placeholders with appropriate checks according to your\n# needs.\n\nvalidate_cover_letter () {\n\tfile=\"$1\"\n\t# TODO: Replace with appropriate checks (e.g. spell checking).\n\ttrue\n}\n\nvalidate_patch () {\n\tfile=\"$1\"\n\t# Ensure that the patch applies without conflicts.\n\tgit am -3 \"$file\" || return\n\t# TODO: Replace with appropriate checks for this patch\n\t# (e.g. checkpatch.pl).\n\ttrue\n}\n\nvalidate_series () {\n\t# TODO: Replace with appropriate checks for the whole series\n\t# (e.g. quick build, coding style checks, etc.).\n\ttrue\n}\n\n# main -------------------------------------------------------------------------\n\nif test \"$GIT_SENDEMAIL_FILE_COUNTER\" = 1\nthen\n\tremote=$(git config --default origin --get sendemail.validateRemote) &&\n\tref=$(git config --default HEAD --get sendemail.validateRemoteRef) &&\n\tworktree=$(mktemp --tmpdir -d sendemail-validate.XXXXXXX) &&\n\tgit worktree add -fd --checkout \"$worktree\" \"refs/remotes/$remote/$ref\" &&\n\tgit config --replace-all sendemail.validateWorktree \"$worktree\"\nelse\n\tworktree=$(git config --get sendemail.validateWorktree)\nfi || {\n\techo \"sendemail-validate: error: failed to prepare worktree\" >&2\n\texit 1\n}\n\nunset GIT_DIR GIT_WORK_TREE\ncd \"$worktree\" &&\n\nif grep -q \"^diff --git \" \"$1\"\nthen\n\tvalidate_patch \"$1\"\nelse\n\tvalidate_cover_letter \"$1\"\nfi &&\n\nif test \"$GIT_SENDEMAIL_FILE_COUNTER\" = \"$GIT_SENDEMAIL_FILE_TOTAL\"\nthen\n\tgit config --unset-all sendemail.validateWorktree &&\n\ttrap 'git worktree remove -ff \"$worktree\"' EXIT &&\n\tvalidate_series\nfi\n",[],[224,946,938],"hooks","5a290ee2-132b-11f1-8fb2-42dde27851f2",["D",1772121234231],[],[224,946,32],"5a1e37d8-132b-11f1-8ea8-42dde27851f2","pre-receive.sample","5a1e38dc-132b-11f1-8ea8-42dde27851f2",135,["D",1772121234158],"#!/bin/sh\n#\n# An example hook script to make use of push options.\n# The example simply echoes all push options that start with 'echoback='\n# and rejects all pushes when the \"reject\" push option is used.\n#\n# To enable this hook, rename this file to \"pre-receive\".\n\nif test -n \"$GIT_PUSH_OPTION_COUNT\"\nthen\n\ti=0\n\twhile test \"$i\" -lt \"$GIT_PUSH_OPTION_COUNT\"\n\tdo\n\t\teval \"value=\\$GIT_PUSH_OPTION_$i\"\n\t\tcase \"$value\" in\n\t\techoback=*)\n\t\t\techo \"echo from the pre-receive-hook: ${value#*=}\" >&2\n\t\t\t;;\n\t\treject)\n\t\t\texit 1\n\t\tesac\n\t\ti=$((i + 1))\n\tdone\nfi\n",[],[224,946,952],"5a023eb6-132b-11f1-b6c9-42dde27851f2","pre-rebase.sample","5a023f88-132b-11f1-b6c9-42dde27851f2",131,["D",1772121233973],"#!/bin/sh\n#\n# Copyright (c) 2006, 2008 Junio C Hamano\n#\n# The \"pre-rebase\" hook is run just before \"git rebase\" starts doing\n# its job, and can prevent the command from running by exiting with\n# non-zero status.\n#\n# The hook is called with the following parameters:\n#\n# $1 -- the upstream the series was forked from.\n# $2 -- the branch being rebased (or empty when rebasing the current branch).\n#\n# This sample shows how to prevent topic branches that are already\n# merged to 'next' branch from getting rebased, because allowing it\n# would result in rebasing already published history.\n\npublish=next\nbasebranch=\"$1\"\nif test \"$#\" = 2\nthen\n\ttopic=\"refs/heads/$2\"\nelse\n\ttopic=`git symbolic-ref HEAD` ||\n\texit 0 ;# we do not interrupt rebasing detached HEAD\nfi\n\ncase \"$topic\" in\nrefs/heads/??/*)\n\t;;\n*)\n\texit 0 ;# we do not interrupt others.\n\t;;\nesac\n\n# Now we are dealing with a topic branch being rebased\n# on top of master. Is it OK to rebase it?\n\n# Does the topic really exist?\ngit show-ref -q \"$topic\" || {\n\techo >&2 \"No such branch $topic\"\n\texit 1\n}\n\n# Is topic fully merged to master?\nnot_in_master=`git rev-list --pretty=oneline ^master \"$topic\"`\nif test -z \"$not_in_master\"\nthen\n\techo >&2 \"$topic is fully merged to master; better remove it.\"\n\texit 1 ;# we could allow it, but there is no point.\nfi\n\n# Is topic ever merged to next? If so you should not be rebasing it.\nonly_next_1=`git rev-list ^master \"^$topic\" ${publish} | sort`\nonly_next_2=`git rev-list ^master ${publish} | sort`\nif test \"$only_next_1\" = \"$only_next_2\"\nthen\n\tnot_in_topic=`git rev-list \"^$topic\" master`\n\tif test -z \"$not_in_topic\"\n\tthen\n\t\techo >&2 \"$topic is already up to date with master\"\n\t\texit 1 ;# we could allow it, but there is no point.\n\telse\n\t\texit 0\n\tfi\nelse\n\tnot_in_next=`git rev-list --pretty=oneline ^${publish} \"$topic\"`\n\t/usr/bin/perl -e '\n\t\tmy $topic = $ARGV[0];\n\t\tmy $msg = \"* $topic has commits already merged to public branch:\\n\";\n\t\tmy (%not_in_next) = map {\n\t\t\t/^([0-9a-f]+) /;\n\t\t\t($1 => 1);\n\t\t} split(/\\n/, $ARGV[1]);\n\t\tfor my $elem (map {\n\t\t\t\t/^([0-9a-f]+) (.*)$/;\n\t\t\t\t[$1 => $2];\n\t\t\t} split(/\\n/, $ARGV[2])) {\n\t\t\tif (!exists $not_in_next{$elem->[0]}) {\n\t\t\t\tif ($msg) {\n\t\t\t\t\tprint STDERR $msg;\n\t\t\t\t\tundef $msg;\n\t\t\t\t}\n\t\t\t\tprint STDERR \" $elem->[1]\\n\";\n\t\t\t}\n\t\t}\n\t' \"$topic\" \"$not_in_next\" \"$not_in_master\"\n\texit 1\nfi\n\n<<\\DOC_END\n\nThis sample hook safeguards topic branches that have been\npublished from being rewound.\n\nThe workflow assumed here is:\n\n * Once a topic branch forks from \"master\", \"master\" is never\n merged into it again (either directly or indirectly).\n\n * Once a topic branch is fully cooked and merged into \"master\",\n it is deleted. If you need to build on top of it to correct\n earlier mistakes, a new topic branch is created by forking at\n the tip of the \"master\". This is not strictly necessary, but\n it makes it easier to keep your history simple.\n\n * Whenever you need to test or publish your changes to topic\n branches, merge them into \"next\" branch.\n\nThe script, being an example, hardcodes the publish branch name\nto be \"next\", but it is trivial to make it configurable via\n$GIT_DIR/config mechanism.\n\nWith this workflow, you would want to know:\n\n(1) ... if a topic branch has ever been merged to \"next\". Young\n topic branches can have stupid mistakes you would rather\n clean up before publishing, and things that have not been\n merged into other branches can be easily rebased without\n affecting other people. But once it is published, you would\n not want to rewind it.\n\n(2) ... if a topic branch has been fully merged to \"master\".\n Then you can delete it. More importantly, you should not\n build on top of it -- other people may already want to\n change things related to the topic as patches against your\n \"master\", so if you need further changes, it is better to\n fork the topic (perhaps with the same name) afresh from the\n tip of \"master\".\n\nLet's look at this example:\n\n\t\t o---o---o---o---o---o---o---o---o---o \"next\"\n\t\t / / / /\n\t\t / a---a---b A / /\n\t\t/ / / /\n\t / / c---c---c---c B /\n\t / / / \\ /\n\t / / / b---b C \\ /\n\t / / / / \\ /\n ---o---o---o---o---o---o---o---o---o---o---o \"master\"\n\n\nA, B and C are topic branches.\n\n * A has one fix since it was merged up to \"next\".\n\n * B has finished. It has been fully merged up to \"master\" and \"next\",\n and is ready to be deleted.\n\n * C has not merged to \"next\" at all.\n\nWe would want to allow C to be rebased, refuse A, and encourage\nB to be deleted.\n\nTo compute (1):\n\n\tgit rev-list ^master ^topic next\n\tgit rev-list ^master next\n\n\tif these match, topic has not merged in next at all.\n\nTo compute (2):\n\n\tgit rev-list master..topic\n\n\tif this is empty, it is fully merged to \"master\".\n\nDOC_END\n",[],[224,946,960],"5a0f980e-132b-11f1-8ea8-42dde27851f2","pre-commit.sample","5a0f98fe-132b-11f1-8ea8-42dde27851f2",133,["D",1772121234048],"#!/bin/sh\n#\n# An example hook script to verify what is about to be committed.\n# Called by \"git commit\" with no arguments. The hook should\n# exit with non-zero status after issuing an appropriate message if\n# it wants to stop the commit.\n#\n# To enable this hook, rename this file to \"pre-commit\".\n\nif git rev-parse --verify HEAD >/dev/null 2>&1\nthen\n\tagainst=HEAD\nelse\n\t# Initial commit: diff against an empty tree object\n\tagainst=$(git hash-object -t tree /dev/null)\nfi\n\n# If you want to allow non-ASCII filenames set this variable to true.\nallownonascii=$(git config --type=bool hooks.allownonascii)\n\n# Redirect output to stderr.\nexec 1>&2\n\n# Cross platform projects tend to avoid non-ASCII filenames; prevent\n# them from being added to the repository. We exploit the fact that the\n# printable range starts at the space character and ends with tilde.\nif [ \"$allownonascii\" != \"true\" ] &&\n\t# Note that the use of brackets around a tr range is ok here, (it's\n\t# even required, for portability to Solaris 10's /usr/bin/tr), since\n\t# the square bracket bytes happen to fall in the designated range.\n\ttest $(git diff-index --cached --name-only --diff-filter=A -z $against |\n\t LC_ALL=C tr -d '[ -~]\\0' | wc -c) != 0\nthen\n\tcat <<\\EOF\nError: Attempt to add a non-ASCII file name.\n\nThis can cause problems if you want to work with people on other platforms.\n\nTo be portable it is advisable to rename the file.\n\nIf you know what you are doing you can disable this check using:\n\n git config hooks.allownonascii true\nEOF\n\texit 1\nfi\n\n# If there are whitespace errors, print the offending file names and fail.\nexec git diff-index --check --cached $against --\n",[],[224,946,968],"59fc36ec-132b-11f1-8ea8-42dde27851f2","commit-msg.sample","59fc37dc-132b-11f1-8ea8-42dde27851f2",130,["D",1772121233922],"#!/bin/sh\n#\n# An example hook script to check the commit log message.\n# Called by \"git commit\" with one argument, the name of the file\n# that has the commit message. The hook should exit with non-zero\n# status after issuing an appropriate message if it wants to stop the\n# commit. The hook is allowed to edit the commit message file.\n#\n# To enable this hook, rename this file to \"commit-msg\".\n\n# Uncomment the below to add a Signed-off-by line to the message.\n# Doing this in a hook is a bad idea in general, but the prepare-commit-msg\n# hook is more suited to it.\n#\n# SOB=$(git var GIT_AUTHOR_IDENT | sed -n 's/^\$.*>\$.*$/Signed-off-by: \\1/p')\n# grep -qs \"^$SOB\" \"$1\" || echo \"$SOB\" >> \"$1\"\n\n# This example catches duplicate Signed-off-by lines.\n\ntest \"\" = \"$(grep '^Signed-off-by: ' \"$1\" |\n\t sort | uniq -c | sed -e '/^[ \t]*1[ \t]/d')\" || {\n\techo >&2 Duplicate Signed-off-by lines.\n\texit 1\n}\n",[],[224,946,976],"5a163632-132b-11f1-8e0b-42dde27851f2","applypatch-msg.sample","5a1636e6-132b-11f1-8e0b-42dde27851f2",134,["D",1772121234067],"#!/bin/sh\n#\n# An example hook script to check the commit log message taken by\n# applypatch from an e-mail message.\n#\n# The hook should exit with non-zero status after issuing an\n# appropriate message if it wants to stop the commit. The hook is\n# allowed to edit the commit message file.\n#\n# To enable this hook, rename this file to \"applypatch-msg\".\n\n. git-sh-setup\ncommitmsg=\"$(git rev-parse --git-path hooks/commit-msg)\"\ntest -x \"$commitmsg\" && exec \"$commitmsg\" ${1+\"$@\"}\n:\n",[],[224,946,984],"570129de-132b-11f1-b6c9-42dde27851f2",73,["D",1772121228932],[241,242,243,244,245,246,247],[224,946],["D",1772121228376],[240,248,250,255,297,300,301,302],[224],["D",1772107064004],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"ctx",{"_75":-5,"_120":1036,"_1037":1038,"_1039":1040,"_1041":24,"_1042":24,"_1043":24,"_1044":118,"_1045":-5,"_1046":-7,"_1047":-7,"_1048":143,"_1049":24,"_1050":24,"_1051":-5,"_1052":24,"_1053":24,"_1054":24,"_1055":-5},"ENV",{"_1007":1008,"_1009":1010,"_1011":83,"_1012":1013,"_1014":1015,"_1016":1017,"_1018":1019,"_1020":1021,"_1022":1023,"_1024":1025,"_1026":1027,"_1028":1029,"_1030":1031,"_1032":1033,"_1034":1035},"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"]

Diff · v137