[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_382":383,"_384":385},"routes/_app.x.$handle.$name",{"_96":95,"_32":46,"_104":86,"_27":54,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",41,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","handlers/report.test.ts","latestPath","fileId","9f39052a-130b-11f1-8acc-42dde27851f2","name","report.test.ts","fileType","script","content","import { describe, it, expect } from \"vitest\";\nimport { formatReport, parseReportArgs } from \"./report\";\nimport type { ReportRow } from \"../db/queries\";\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","import { describe, it, expect } from \"vitest\";\nimport { formatReport, parseReportArgs } from \"./report.ts\";\nimport type { ReportRow } from \"../db/queries.ts.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","createdAt",["D",1772108747512],"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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":56,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"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",{"_44":45,"_32":46,"_39":378,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":379,"_80":380,"_82":381,"_84":25},"tree",[186,193,200,203,209,210],"files",[186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210],"counts",{"_176":157,"_177":62,"_178":157,"_179":180,"_181":182},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_44":171,"_32":172,"_30":173,"_135":-5,"_42":43,"_41":139,"_137":121,"_39":174,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":175},{"_44":165,"_32":166,"_30":167,"_135":-5,"_42":43,"_41":168,"_137":121,"_39":169,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":170},{"_44":160,"_32":161,"_30":162,"_135":-5,"_42":43,"_41":62,"_137":121,"_39":163,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":164},{"_44":152,"_32":153,"_30":154,"_135":-5,"_42":43,"_41":155,"_137":121,"_39":156,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_27":159},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":147,"_137":121,"_39":148,"_13":62,"_34":149,"_36":150,"_24":25,"_142":-5,"_27":151},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":25,"_39":138,"_13":139,"_34":140,"_36":141,"_24":25,"_142":-5,"_27":143},"473a6f96-130e-11f1-8e1e-42dde27851f2","main.ts","9ecb8054-130b-11f1-8d22-42dde27851f2","parentId",29,"latest",["D",1772108747014],2,"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 provides SQLite via this import\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 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 \"/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 } 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 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 = 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 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 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_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 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 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","label",[133],"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",[145],"9ead4e86-130b-11f1-8d22-42dde27851f2","slack","9ead4f62-130b-11f1-8d22-42dde27851f2",3,["D",1772107605282],0,"directory",[153],"9e8bb942-130b-11f1-a4f6-42dde27851f2","lib","9e8bba00-130b-11f1-a4f6-42dde27851f2",["D",1772107605064],[161],"9eba3b46-130b-11f1-8d22-42dde27851f2","handlers","9eba3bfa-130b-11f1-8d22-42dde27851f2",4,["D",1772107605369],[166],"9e9b1bb2-130b-11f1-a4f6-42dde27851f2","db","9e9b1c5c-130b-11f1-a4f6-42dde27851f2",["D",1772107605164],[172],"pulls","branches","forks","envVars",{"_183":155,"_185":157},"connections",{"_183":157,"_184":157},"count","unfilledCount","emptyCount",{"_44":171,"_32":172,"_30":173,"_135":-5,"_42":43,"_41":139,"_137":121,"_39":375,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_212":376,"_27":377},{"_44":367,"_32":368,"_30":369,"_135":173,"_42":43,"_41":370,"_137":121,"_39":371,"_13":62,"_34":35,"_36":372,"_24":25,"_142":-5,"_212":373,"_27":374},{"_44":359,"_32":360,"_30":361,"_135":173,"_42":43,"_41":362,"_137":121,"_39":363,"_13":62,"_34":35,"_36":364,"_24":25,"_142":-5,"_212":365,"_27":366},{"_44":351,"_32":352,"_30":353,"_135":173,"_42":43,"_41":354,"_137":121,"_39":355,"_13":62,"_34":35,"_36":356,"_24":25,"_142":-5,"_212":357,"_27":358},{"_44":343,"_32":344,"_30":345,"_135":173,"_42":43,"_41":346,"_137":121,"_39":347,"_13":62,"_34":35,"_36":348,"_24":25,"_142":-5,"_212":349,"_27":350},{"_44":335,"_32":336,"_30":337,"_135":173,"_42":43,"_41":338,"_137":25,"_39":339,"_13":62,"_34":35,"_36":340,"_24":25,"_142":-5,"_212":341,"_27":342},{"_44":327,"_32":328,"_30":329,"_135":173,"_42":43,"_41":330,"_137":121,"_39":331,"_13":157,"_34":35,"_36":332,"_24":25,"_142":-5,"_212":333,"_27":334},{"_44":165,"_32":166,"_30":167,"_135":-5,"_42":43,"_41":168,"_137":121,"_39":324,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_212":325,"_27":326},{"_44":316,"_32":317,"_30":318,"_135":167,"_42":43,"_41":319,"_137":121,"_39":320,"_13":62,"_34":35,"_36":321,"_24":25,"_142":-5,"_212":322,"_27":323},{"_44":308,"_32":309,"_30":310,"_135":167,"_42":43,"_41":311,"_137":25,"_39":312,"_13":157,"_34":35,"_36":313,"_24":25,"_142":-5,"_212":314,"_27":315},{"_44":300,"_32":301,"_30":302,"_135":167,"_42":43,"_41":303,"_137":25,"_39":304,"_13":157,"_34":35,"_36":305,"_24":25,"_142":-5,"_212":306,"_27":307},{"_44":292,"_32":293,"_30":294,"_135":167,"_42":43,"_41":295,"_137":25,"_39":296,"_13":62,"_34":35,"_36":297,"_24":25,"_142":-5,"_212":298,"_27":299},{"_44":288,"_32":33,"_30":31,"_135":167,"_42":43,"_41":14,"_137":25,"_39":289,"_13":62,"_34":35,"_36":38,"_24":25,"_142":-5,"_212":290,"_27":291},{"_44":280,"_32":281,"_30":282,"_135":167,"_42":43,"_41":283,"_137":25,"_39":284,"_13":62,"_34":35,"_36":285,"_24":25,"_142":-5,"_212":286,"_27":287},{"_44":160,"_32":161,"_30":162,"_135":-5,"_42":43,"_41":62,"_137":121,"_39":277,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_212":278,"_27":279},{"_44":269,"_32":270,"_30":271,"_135":162,"_42":43,"_41":272,"_137":25,"_39":273,"_13":62,"_34":35,"_36":274,"_24":25,"_142":-5,"_212":275,"_27":276},{"_44":261,"_32":262,"_30":263,"_135":162,"_42":43,"_41":264,"_137":25,"_39":265,"_13":157,"_34":35,"_36":266,"_24":25,"_142":-5,"_212":267,"_27":268},{"_44":152,"_32":153,"_30":154,"_135":-5,"_42":43,"_41":155,"_137":121,"_39":258,"_13":157,"_34":158,"_36":-5,"_24":25,"_142":-5,"_212":259,"_27":260},{"_44":250,"_32":251,"_30":252,"_135":154,"_42":43,"_41":253,"_137":25,"_39":254,"_13":157,"_34":35,"_36":255,"_24":25,"_142":-5,"_212":256,"_27":257},{"_44":242,"_32":243,"_30":244,"_135":154,"_42":43,"_41":245,"_137":25,"_39":246,"_13":62,"_34":35,"_36":247,"_24":25,"_142":-5,"_212":248,"_27":249},{"_44":234,"_32":235,"_30":236,"_135":154,"_42":43,"_41":237,"_137":25,"_39":238,"_13":62,"_34":35,"_36":239,"_24":25,"_142":-5,"_212":240,"_27":241},{"_44":226,"_32":227,"_30":228,"_135":154,"_42":43,"_41":229,"_137":121,"_39":230,"_13":62,"_34":35,"_36":231,"_24":25,"_142":-5,"_212":232,"_27":233},{"_44":218,"_32":219,"_30":220,"_135":154,"_42":43,"_41":221,"_137":121,"_39":222,"_13":157,"_34":35,"_36":223,"_24":25,"_142":-5,"_212":224,"_27":225},{"_44":144,"_32":145,"_30":146,"_135":-5,"_42":43,"_41":147,"_137":121,"_39":215,"_13":62,"_34":149,"_36":150,"_24":25,"_142":-5,"_212":216,"_27":217},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":25,"_39":211,"_13":139,"_34":140,"_36":141,"_24":25,"_142":-5,"_212":213,"_27":214},["D",1772108747014],"children",[],[133],["D",1772108746979],[],[145],"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",[],[153,219],"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",[],[153,227],"4751572e-130e-11f1-8e1e-42dde27851f2","modals.ts","9f08bdb6-130b-11f1-8d22-42dde27851f2",33,["D",1772108747204],"import type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts.ts\";\nimport { formatDuration, getLast7Days } from \"../lib/format.ts.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\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",[],[153,235],"4758d562-130e-11f1-ae00-42dde27851f2","modals.test.ts","9f19dac4-130b-11f1-aa87-42dde27851f2",34,["D",1772108747256],"import { describe, it, expect } from \"vitest\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./modals.ts\";\nimport type { Project, Grant, TaskType, TimeEntry } from \"../db/queries.ts.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",[],[153,243],"9f0e24ea-130b-11f1-8e57-42dde27851f2","api.ts","9f0e25c6-130b-11f1-8e57-42dde27851f2",15,["D",1772107605904],"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 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",[],[153,251],["D",1772107605282],[204,205,206,207,208],[153],"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",[],[161,262],"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",[],[161,270],["D",1772107605064],[201,202],[161],"4774cca4-130e-11f1-8e1e-42dde27851f2","report.ts","9f2180d0-130b-11f1-bab2-42dde27851f2",38,["D",1772108747399],"import type { ReportRow } from \"../db/queries.ts.ts\";\nimport { formatDuration, formatDateRange, getWeekBounds } from \"../lib/format.ts.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",[],[166,281],"4785b924-130e-11f1-8e1e-42dde27851f2",["D",1772108747512],[],[166,33],"476d3cd2-130e-11f1-a4a1-42dde27851f2","reminder.ts","9f1deff6-130b-11f1-8acc-42dde27851f2",37,["D",1772108747314],"import type { Database } from \"../db/types.ts.ts\";\nimport type { Intern } from \"../db/queries.ts.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",[],[166,293],"9f2ae896-130b-11f1-aa87-42dde27851f2","reminder.test.ts","9f2ae922-130b-11f1-aa87-42dde27851f2",21,["D",1772107606106],"import { describe, it, expect, beforeEach } from \"vitest\";\nimport { createTestDb } from \"../db/test-helpers\";\nimport { migrate } from \"../db/schema\";\nimport { addIntern, addTaskType, createTimeEntry } from \"../db/queries\";\nimport { getInternsWithoutEntries } from \"./reminder\";\nimport type { Database } from \"../db/types\";\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",[],[166,301],"9f302540-130b-11f1-bab2-42dde27851f2","admin.ts","9f3025f4-130b-11f1-bab2-42dde27851f2",22,["D",1772107606143],"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\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 {\n action: \"error\",\n entity: null,\n args: [\"Unrecognized command. Try: add, remove, list, intern, reminder\"],\n };\n}\n",[],[166,309],"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",[],[166,317],["D",1772107605369],[194,195,196,197,198,199],[166],"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",[],[172,328],"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",[],[172,336],"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",[],[172,344],"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",[],[172,352],"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",[],[172,360],"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",[],[172,368],["D",1772107605164],[187,188,189,190,191,192],[172],["D",1772107064004],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":56,"_100":101,"_102":25},{"_13":85,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"ctx",{"_78":-5,"_123":415,"_416":417,"_418":419,"_420":25,"_421":25,"_422":25,"_423":121,"_424":-5,"_425":-7,"_426":-7,"_427":157,"_428":25,"_429":25,"_430":-5,"_431":25,"_432":25,"_433":25,"_434":-5},"ENV",{"_386":387,"_388":389,"_390":86,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414},"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 · v41