[{"_1":2,"_318":-5,"_319":-5},"loaderData",{"_3":4,"_93":94,"_273":274},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2f1b7933526c99d174f6c4b9fb9d1854a177ff5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":45,"_100":101,"_102":103,"_104":105,"_155":156,"_247":248,"_249":250,"_261":262,"_263":264,"_267":-5,"_268":-5,"_269":22,"_270":22,"_271":272},"handle","trevormunoz","name","lakeland-timesheet","branchName","path","db/schema.ts","version",9,"project",{"_106":107,"_97":98,"_108":109,"_110":-5,"_111":22,"_112":113,"_114":74,"_115":-5,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":-5,"_124":-5,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":134,"_137":138,"_142":143,"_154":22},"id","5c0c02e4-130a-11f1-9411-42dde27851f2","createdAt",["D",1772107064004],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","7ec577df-7957-4760-a4d3-81e05cef3345","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","48ae43c1-9cce-4f57-9abb-f1491d51acfb","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_135":136},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWm5xQUFoY280MXptMVB2Tk9ad0ptV3gyNWUifQ","org",{"_95":96,"_139":136,"_14":116,"_140":141},"avatar","tier","free","branch",{"_102":144,"_97":45,"_106":145,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},168,"5c0c68ec-130a-11f1-9411-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[157,195,203,220,228,238],{"_106":158,"_97":159,"_160":161,"_162":-5,"_163":145,"_164":165,"_166":167,"_108":168,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":175,"_100":194},"9e9b1bb2-130b-11f1-a4f6-42dde27851f2","db","fileId","9e9b1c5c-130b-11f1-a4f6-42dde27851f2","parentId","branchId","branchVersion",2,"latest",true,["D",1772107605164],"fileType","directory","content","deleted","label","children",[176,185],{"_106":177,"_97":178,"_160":179,"_162":161,"_163":145,"_164":103,"_166":22,"_108":180,"_102":33,"_169":181,"_171":182,"_172":22,"_173":-5,"_174":183,"_100":184},"9ee5d01c-130b-11f1-aee3-42dde27851f2","queries.test.ts","9ee5d0e4-130b-11f1-aee3-42dde27851f2",["D",1772107605582],"script","import { describe, it, expect, beforeEach } from \"vitest\";\nimport type { Database } from \"./types\";\nimport { createTestDb } from \"./test-helpers\";\nimport { migrate } from \"./schema\";\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\";\nimport type { TimeEntryInput } from \"./queries\";\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",[],[159,178],{"_106":186,"_97":187,"_160":188,"_162":161,"_163":145,"_164":189,"_166":22,"_108":190,"_102":33,"_169":181,"_171":191,"_172":22,"_173":-5,"_174":192,"_100":193},"9edb25c2-130b-11f1-bab2-42dde27851f2","schema.ts","9edb2680-130b-11f1-bab2-42dde27851f2",8,["D",1772107605546],"import type { Database } from \"./types\";\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",[],[159,187],[159],{"_106":196,"_97":197,"_160":198,"_162":-5,"_163":145,"_164":199,"_166":167,"_108":200,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":201,"_100":202},"9eba3b46-130b-11f1-8d22-42dde27851f2","handlers","9eba3bfa-130b-11f1-8d22-42dde27851f2",4,["D",1772107605369],[],[197],{"_106":204,"_97":205,"_160":206,"_162":-5,"_163":145,"_164":207,"_166":167,"_108":208,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":209,"_100":219},"9e8bb942-130b-11f1-a4f6-42dde27851f2","lib","9e8bba00-130b-11f1-a4f6-42dde27851f2",1,["D",1772107605064],[210],{"_106":211,"_97":212,"_160":213,"_162":206,"_163":145,"_164":214,"_166":22,"_108":215,"_102":33,"_169":181,"_171":216,"_172":22,"_173":-5,"_174":217,"_100":218},"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",[],[205,212],[205],{"_106":221,"_97":222,"_160":223,"_162":-5,"_163":145,"_164":224,"_166":167,"_108":225,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":226,"_100":227},"9ead4e86-130b-11f1-8d22-42dde27851f2","slack","9ead4f62-130b-11f1-8d22-42dde27851f2",3,["D",1772107605282],[],[222],{"_106":229,"_97":230,"_160":231,"_162":-5,"_163":145,"_164":232,"_166":22,"_108":233,"_102":33,"_169":234,"_171":235,"_172":22,"_173":-5,"_174":236,"_100":237},"9ed436c2-130b-11f1-8f11-42dde27851f2","cron.ts","9ed4376c-130b-11f1-8f11-42dde27851f2",7,["D",1772107605504],"interval","// src/cron.ts\nimport { getConfig } from \"./db/queries\";\nimport { getInternsWithoutEntries } from \"./handlers/reminder\";\nimport { getWeekBounds, todayInTimezone } from \"./lib/format\";\nimport { createSlackClient } from \"./slack/api\";\nimport { migrate } from \"./db/schema\";\nimport type { Database } from \"./db/types\";\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",[],[230],{"_106":239,"_97":240,"_160":241,"_162":-5,"_163":145,"_164":242,"_166":22,"_108":243,"_102":33,"_169":181,"_171":244,"_172":22,"_173":-5,"_174":245,"_100":246},"9ecb7e06-130b-11f1-8d22-42dde27851f2","main.ts","9ecb8054-130b-11f1-8d22-42dde27851f2",5,["D",1772107605480],"// src/main.ts\nimport { verifySlackSignature } from \"./slack/verify\";\nimport { createSlackClient, type SlackClient } from \"./slack/api\";\nimport { buildLogtimeModal, buildConfirmationBlocks, buildRecentEntriesBlocks } from \"./slack/modals\";\nimport { parseAdminCommand } from \"./handlers/admin\";\nimport { formatReport, parseReportArgs } from \"./handlers/report\";\nimport { migrate } from \"./db/schema\";\nimport * as queries from \"./db/queries\";\nimport { formatDuration, todayInTimezone } from \"./lib/format\";\nimport type { Database } from \"./db/types\";\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\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 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 = 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 await queries.softDeleteTimeEntry(database, Number(entryId));\n if (channel) {\n await getSlack().postEphemeral(channel, user.id, \"Entry deleted.\");\n }\n } else if (actionType === \"edit\") {\n const entry = await queries.getTimeEntryById(database, Number(entryId));\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 = 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",[],[240],"files",[157,176,185,195,203,210,220,228,238],"counts",{"_251":33,"_252":207,"_253":33,"_254":255,"_258":259},"pulls","branches","forks","envVars",{"_256":224,"_257":33},"count","emptyCount","connections",{"_256":33,"_260":33},"unfilledCount","contents",[],"file",{"_106":186,"_97":187,"_160":188,"_162":161,"_163":145,"_164":189,"_166":22,"_108":265,"_102":33,"_169":181,"_171":191,"_172":22,"_173":-5,"_100":266},["D",1772107605546],[159,187],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_95":96,"_97":98,"_99":45,"_102":103,"_100":101,"_104":275,"_155":280,"_247":308,"_263":309,"_261":311,"_312":-5,"_313":-5,"_314":-5,"_315":-5,"_316":317,"_254":-5},{"_106":107,"_97":98,"_108":276,"_110":-5,"_111":22,"_112":113,"_114":74,"_115":-5,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":-5,"_124":-5,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":277,"_137":278,"_142":279,"_154":22},["D",1772107064004],{"_95":96,"_135":136},{"_95":96,"_139":136,"_14":116,"_140":141},{"_102":144,"_97":45,"_106":145,"_146":107,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},[281,290,293,299,302,305],{"_106":158,"_97":159,"_160":161,"_162":-5,"_163":145,"_164":165,"_166":167,"_108":168,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":282,"_100":289},[283,286],{"_106":177,"_97":178,"_160":179,"_162":161,"_163":145,"_164":103,"_166":22,"_108":180,"_102":33,"_169":181,"_171":182,"_172":22,"_173":-5,"_174":284,"_100":285},[],[159,178],{"_106":186,"_97":187,"_160":188,"_162":161,"_163":145,"_164":189,"_166":22,"_108":190,"_102":33,"_169":181,"_171":191,"_172":22,"_173":-5,"_174":287,"_100":288},[],[159,187],[159],{"_106":196,"_97":197,"_160":198,"_162":-5,"_163":145,"_164":199,"_166":167,"_108":200,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":291,"_100":292},[],[197],{"_106":204,"_97":205,"_160":206,"_162":-5,"_163":145,"_164":207,"_166":167,"_108":208,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":294,"_100":298},[295],{"_106":211,"_97":212,"_160":213,"_162":206,"_163":145,"_164":214,"_166":22,"_108":215,"_102":33,"_169":181,"_171":216,"_172":22,"_173":-5,"_174":296,"_100":297},[],[205,212],[205],{"_106":221,"_97":222,"_160":223,"_162":-5,"_163":145,"_164":224,"_166":167,"_108":225,"_102":33,"_169":170,"_171":-5,"_172":22,"_173":-5,"_174":300,"_100":301},[],[222],{"_106":229,"_97":230,"_160":231,"_162":-5,"_163":145,"_164":232,"_166":22,"_108":233,"_102":33,"_169":234,"_171":235,"_172":22,"_173":-5,"_174":303,"_100":304},[],[230],{"_106":239,"_97":240,"_160":241,"_162":-5,"_163":145,"_164":242,"_166":22,"_108":243,"_102":33,"_169":181,"_171":244,"_172":22,"_173":-5,"_174":306,"_100":307},[],[240],[281,283,286,290,293,295,299,302,305],{"_106":186,"_97":187,"_160":188,"_162":161,"_163":145,"_164":189,"_166":22,"_108":265,"_102":33,"_169":181,"_171":191,"_172":22,"_173":-5,"_100":310},[159,187],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]