[{"_1":2,"_345":-5,"_346":-5},"loaderData",{"_3":4,"_91":92,"_328":329},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":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","notificationCount",0,"flagDenols","ENV",{"_36":37,"_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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2f607f7b74b4e52529fb75176d403d8b5b284eb1","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":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",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_147":148,"_290":291,"_292":293,"_302":303,"_263":-5,"_322":-5,"_323":-5,"_324":22,"_325":22,"_326":327},"handle","charmaine","name","Linear-to-Slack-Reminder","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_146":22},"id","153cdcde-5128-11f0-80d4-f69ea79377d9","createdAt",["D",1750789304530],"deletedAt","legacyEnvVars","privacy","unlisted","description","Sends scheduled Slack reminders to overdue Linear tickets","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","screenshotVersion","likeCount","2019e55b-c541-4c51-bef0-008eef10ef88","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","org",{"_93":94,"_133":130},"avatar","branch",{"_99":136,"_95":43,"_102":137,"_138":103,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},266,"153d4c32-5128-11f0-80d4-f69ea79377d9","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[149,211,229,257,267,278],{"_102":150,"_95":151,"_152":153,"_154":-5,"_155":137,"_156":157,"_158":159,"_104":160,"_99":161,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":168,"_98":210},"7ec90a74-5128-11f0-8492-f69ea79377d9","backend","fileId","7ca3926e-5128-11f0-8492-f69ea79377d9","parentId","branchId","branchVersion",24,"latest",true,["D",1750789481604],1,"fileType","directory","content","deleted","label","children",[169,180,190,200],{"_102":170,"_95":171,"_152":172,"_154":153,"_155":137,"_156":173,"_158":159,"_104":174,"_99":175,"_162":176,"_164":177,"_165":22,"_166":-5,"_167":178,"_98":179},"0ae9e4bc-62b6-11f0-87fc-0224a6c84d84","database.ts","8c5cb85c-5128-11f0-b4ff-f69ea79377d9",252,["D",1752719445500],17,"script","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Reminder } from \"./types.ts\";\n\nexport async function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS reminders_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ticket_id TEXT NOT NULL,\n ticket_title TEXT NOT NULL,\n interval_days INTEGER NOT NULL,\n last_ping TEXT NOT NULL,\n ping_count INTEGER DEFAULT 0,\n creator_slack_id TEXT NOT NULL,\n assignee_mappings TEXT NOT NULL,\n subticket_status TEXT NOT NULL,\n active INTEGER DEFAULT 1,\n created_at TEXT NOT NULL\n )\n `);\n}\n\nexport async function createReminder(reminder: Omit): Promise {\n const result = await sqlite.execute({\n sql: `\n INSERT INTO reminders_v2 (\n ticket_id, ticket_title, interval_days, last_ping, ping_count,\n creator_slack_id, assignee_mappings, subticket_status, active, created_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `,\n args: [\n reminder.ticket_id,\n reminder.ticket_title,\n reminder.interval_days,\n reminder.last_ping,\n reminder.ping_count,\n reminder.creator_slack_id,\n reminder.assignee_mappings,\n reminder.subticket_status,\n reminder.active,\n reminder.created_at,\n ],\n });\n \n return Number(result.lastInsertRowid);\n}\n\n// Map SQLite row arrays to Reminder objects so it's cleaner to read\nfunction rowToReminder(row: any[]): Reminder {\n return {\n id: row[0],\n ticket_id: row[1],\n ticket_title: row[2],\n interval_days: row[3],\n last_ping: row[4],\n ping_count: row[5],\n creator_slack_id: row[6],\n assignee_mappings: row[7],\n subticket_status: row[8],\n active: row[9],\n created_at: row[10],\n };\n}\n\nexport async function getActiveReminders(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM reminders_v2 WHERE active = 1\");\n return result.rows.map(rowToReminder);\n}\n\nexport async function updateReminder(\n id: number,\n updates: Partial\n): Promise {\n const fields = Object.keys(updates)\n .map(key => `${key} = ?`)\n .join(\", \");\n \n await sqlite.execute({\n sql: `UPDATE reminders_v2 SET ${fields} WHERE id = ?`,\n args: [...Object.values(updates), id],\n });\n}\n\nexport async function getRemindersByCreator(creatorId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE creator_slack_id = ? AND active = 1\",\n args: [creatorId],\n });\n \n return result.rows.map(rowToReminder);\n}\n\nexport async function getAllRemindersByCreator(creatorId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE creator_slack_id = ?\",\n args: [creatorId],\n });\n return result.rows.map(rowToReminder);\n}\n\nexport async function clearAllReminders(): Promise {\n await sqlite.execute(\"UPDATE reminders_v2 SET active = 0\");\n}\n\nexport async function createAutoReminder(reminder: Omit): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM reminders_v2 WHERE ticket_id = ? AND creator_slack_id = ? AND active = 1\",\n args: [reminder.ticket_id, reminder.creator_slack_id],\n });\n \n if (existing.rows.length > 0) {\n return Number(existing.rows[0][0]);\n }\n \n return createReminder(reminder);\n}\n\nexport async function getReminderByTicketId(ticketId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM reminders_v2 WHERE ticket_id = ? AND active = 1\",\n args: [ticketId],\n });\n \n return result.rows.length > 0 ? rowToReminder(result.rows[0]) : null;\n}",[],[151,171],{"_102":181,"_95":182,"_152":183,"_154":153,"_155":137,"_156":184,"_158":159,"_104":185,"_99":186,"_162":176,"_164":187,"_165":22,"_166":-5,"_167":188,"_98":189},"7716b9ea-62b5-11f0-9202-0224a6c84d84","linearApi.ts","9244e000-5128-11f0-a6a5-f69ea79377d9",251,["D",1752719197496],20,"import { LinearClient } from \"https://esm.sh/@linear/sdk@22.0.0\";\nimport { LinearIssue } from \"./types.ts\";\n\nconst linearClient = new LinearClient({\n apiKey: Deno.env.get(\"LINEAR_API_KEY\") ?? (() => {\n throw new Error(\"Missing required env var: LINEAR_API_KEY\");\n })(),\n});\n\nexport async function getLinearTicket(ticketId: string): Promise {\n const query = `\n query IssueWithChildren($id: String!) {\n issue(id: $id) {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n team { id }\n labels {\n nodes {\n id\n name\n }\n }\n children {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n }\n }\n }\n }\n `;\n\n const response: any = await linearClient.client.rawRequest(query, { id: ticketId });\n const issue = response.data.issue;\n\n const linearIssue: LinearIssue = {\n id: issue.id,\n identifier: issue.identifier,\n title: issue.title,\n state: {\n name: issue.state?.name || \"\",\n type: issue.state?.type || \"\",\n },\n assignee: issue.assignee ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n } : undefined,\n completedAt: issue.completedAt,\n team: { id: issue.team.id },\n labels: issue.labels?.nodes || [],\n children: {\n nodes: (issue.children.nodes || []).map((child: any) => ({\n id: child.id,\n identifier: child.identifier,\n title: child.title,\n state: {\n name: child.state?.name || \"\",\n type: child.state?.type || \"\",\n },\n assignee: child.assignee ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n } : undefined,\n completedAt: child.completedAt,\n })),\n },\n };\n\n return linearIssue;\n}\n\nexport function extractTicketId(input: string): string {\n // Handle Linear URLs like https://linear.app/team/issue/TEAM-123\n const urlMatch = input.match(/([A-Z]+-\\d+)/);\n return urlMatch ? urlMatch[1] : input;\n}\n\nexport async function addChaseLabelToIssue(issueId: string): Promise {\n const issue = await getLinearTicket(issueId);\n const hasChaseLabel = issue.labels?.some(label => label.name.toLowerCase().includes(\"chase\"));\n \n if (!hasChaseLabel && issue.team?.id) {\n const labelQuery = `\n query FindChaseLabel($teamId: String!) {\n team(id: $teamId) {\n labels {\n nodes {\n id\n name\n }\n }\n }\n }\n `;\n \n const labelResponse: any = await linearClient.client.rawRequest(labelQuery, { teamId: issue.team.id });\n let chaseLabelId = labelResponse.data.team.labels.nodes.find((label: any) => \n label.name.toLowerCase().includes(\"chase\")\n )?.id;\n \n if (chaseLabelId) {\n const mutation = `\n mutation AddChaseLabel($issueId: String!, $labelId: String!) {\n issueAddLabel(id: $issueId, labelId: $labelId) {\n success\n }\n }\n `;\n \n await linearClient.client.rawRequest(mutation, {\n issueId: issue.id,\n labelId: chaseLabelId\n });\n }\n }\n}\n\nexport async function removeChaseLabelFromIssue(issueId: string): Promise {\n const issue = await getLinearTicket(issueId);\n const chaseLabel = issue.labels?.find(label => label.name.toLowerCase().includes(\"chase\"));\n \n if (chaseLabel) {\n const mutation = `\n mutation RemoveChaseLabel($issueId: String!, $labelId: String!) {\n issueRemoveLabel(id: $issueId, labelId: $labelId) {\n success\n }\n }\n `;\n \n await linearClient.client.rawRequest(mutation, {\n issueId: issue.id,\n labelId: chaseLabel.id\n });\n }\n}\n\nexport async function getIssuesWithChaseLabel(): Promise {\n const query = `\n query IssuesWithChaseLabel {\n issues(\n filter: { labels: { name: { containsIgnoreCase: \"chase\" } } }\n orderBy: updatedAt\n ) {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n team { id }\n labels {\n nodes {\n id\n name\n }\n }\n children {\n nodes {\n id\n identifier\n title\n state { id name type }\n assignee { email name }\n completedAt\n }\n }\n }\n }\n }\n `;\n\n const response: any = await linearClient.client.rawRequest(query);\n return response.data.issues.nodes.map((issue: any) => ({\n id: issue.id,\n identifier: issue.identifier,\n title: issue.title,\n state: {\n name: issue.state?.name || \"\",\n type: issue.state?.type || \"\",\n },\n assignee: issue.assignee ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n } : undefined,\n completedAt: issue.completedAt,\n team: { id: issue.team.id },\n labels: issue.labels?.nodes || [],\n children: {\n nodes: (issue.children.nodes || []).map((child: any) => ({\n id: child.id,\n identifier: child.identifier,\n title: child.title,\n state: {\n name: child.state?.name || \"\",\n type: child.state?.type || \"\",\n },\n assignee: child.assignee ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n } : undefined,\n completedAt: child.completedAt,\n })),\n },\n }));\n}",[],[151,182],{"_102":191,"_95":192,"_152":193,"_154":153,"_155":137,"_156":194,"_158":159,"_104":195,"_99":196,"_162":176,"_164":197,"_165":22,"_166":-5,"_167":198,"_98":199},"db05510e-5bfe-11f0-b881-0224a6c84d84","slackApi.ts","aa83f804-5128-11f0-a00e-f69ea79377d9",184,["D",1751981060275],12,"import { WebClient } from \"https://esm.sh/@slack/web-api@7.0.2\";\nimport { SlackUser } from \"./types.ts\";\n\nexport const slackClient = new WebClient(\n Deno.env.get(\"SLACK_BOT_TOKEN\") ??\n (() => {\n throw new Error(\"Missing SLACK_BOT_TOKEN\");\n })(),\n);\n\nexport async function lookupUserByEmail(\n email: string,\n): Promise {\n try {\n const result = await slackClient.users.lookupByEmail({ email });\n return result.user as SlackUser;\n } catch (error) {\n console.error(`Failed to lookup user by email: ${error}`);\n return null;\n }\n}\n\nexport async function sendDirectMessage(\n userId: string,\n text: string,\n): Promise {\n await slackClient.chat.postMessage({\n channel: userId,\n text: text,\n });\n}\n\nexport async function openModal(\n triggerId: string,\n view: Record,\n): Promise {\n await slackClient.views.open({\n trigger_id: triggerId,\n view: view as any,\n } as any);\n}",[],[151,192],{"_102":201,"_95":202,"_152":203,"_154":153,"_155":137,"_156":204,"_158":159,"_104":205,"_99":206,"_162":176,"_164":207,"_165":22,"_166":-5,"_167":208,"_98":209},"3350ba76-62b5-11f0-abe3-0224a6c84d84","types.ts","b06646fa-5128-11f0-bb02-f69ea79377d9",250,["D",1752719083627],10,"// Shared type definitions for the Linear-Slack Reminder Bot\n\nexport interface LinearTicket {\n id: string;\n identifier: string;\n title: string;\n state: {\n name: string;\n type: string;\n };\n assignee?: {\n email: string;\n name: string;\n };\n completedAt?: string;\n}\n\nexport interface LinearIssue extends LinearTicket {\n children: {\n nodes: LinearTicket[];\n };\n labels?: {\n id: string;\n name: string;\n }[];\n team: {\n id: string;\n };\n}\n\nexport interface SlackUser {\n id: string;\n name: string;\n real_name: string;\n profile: {\n email: string;\n };\n}\n\nexport interface Reminder {\n id?: number;\n ticket_id: string;\n ticket_title: string;\n interval_days: number;\n last_ping: string;\n ping_count: number;\n creator_slack_id: string;\n assignee_mappings: string;\n subticket_status: string; \n active: number; // 1 or 0 boolean\n created_at: string;\n}\n\nexport interface SlackModalPayload {\n type: string;\n user: {\n id: string;\n };\n view: {\n callback_id: string;\n state: {\n values: Record>;\n };\n private_metadata: string;\n };\n}\n\nexport interface SlackCommandPayload {\n command: string;\n text: string;\n trigger_id: string;\n user_id: string;\n}",[],[151,202],[151],{"_102":212,"_95":213,"_152":214,"_154":-5,"_155":137,"_156":215,"_158":159,"_104":216,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":217,"_98":228},"c2194584-624c-11f0-b7fa-0224a6c84d84","linear","c2194624-624c-11f0-b7fa-0224a6c84d84",218,["D",1752674226189],[218],{"_102":219,"_95":220,"_152":221,"_154":214,"_155":137,"_156":222,"_158":159,"_104":223,"_99":224,"_162":176,"_164":225,"_165":22,"_166":-5,"_167":226,"_98":227},"05abdd78-62b8-11f0-a8ae-0224a6c84d84","webhookHandler.ts","c2312aa0-624c-11f0-8d8c-0224a6c84d84",258,["D",1752720295688],13,"import { getLinearTicket, removeChaseLabelFromIssue } from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail } from \"../backend/slackApi.ts\";\nimport { createAutoReminder, updateReminder, getRemindersByCreator, getReminderByTicketId } from \"../backend/database.ts\";\n\nexport default async function handleLinearWebhook(req: Request) {\n const payload = await req.json();\n \n console.log(\"Linear webhook received:\", JSON.stringify(payload, null, 2));\n \n // Handle issue state changes - when ticket is marked as done, remove chase label\n if (payload.action === \"update\" && payload.type === \"Issue\" && payload.updatedFrom?.stateId) {\n const oldStateId = payload.updatedFrom.stateId;\n const newState = payload.data?.state;\n \n // If ticket was moved to completed state, remove chase label\n if (newState?.type === \"completed\") {\n console.log(\"Ticket marked as completed, removing chase label for:\", payload.data.identifier);\n try {\n await removeChaseLabelFromIssue(payload.data.identifier);\n await deactivateReminderForTicket(payload.data.identifier, payload.actor?.email);\n } catch (error) {\n console.error(\"Error removing chase label from completed ticket:\", error);\n }\n }\n }\n\n // Handle issue label updates - when labels are added/removed from issues\n if (payload.action === \"update\" && payload.type === \"Issue\" && payload.updatedFrom?.labelIds) {\n const oldLabelIds = payload.updatedFrom.labelIds || [];\n const newLabelIds = payload.data?.labelIds || [];\n \n // Find current chase label (if any)\n const currentChaseLabel = payload.data?.labels?.find((label: any) => \n label.name.toLowerCase().includes(\"chase\")\n );\n \n // Check if chase label was added\n if (currentChaseLabel && !oldLabelIds.includes(currentChaseLabel.id)) {\n console.log(\"Chase label added, creating reminder for:\", payload.data.identifier);\n await createReminderFromTicket(payload.data.identifier, payload.actor?.email);\n }\n \n // Check if chase label was removed - no current chase label but there was a reminder\n if (!currentChaseLabel && oldLabelIds.length > newLabelIds.length) {\n // Check if there's actually a reminder to deactivate (implies there was a chase label)\n const reminder = await getReminderByTicketId(payload.data.identifier);\n if (reminder) {\n console.log(\"Chase label removed, deactivating reminder for:\", payload.data.identifier);\n await deactivateReminderForTicket(payload.data.identifier, payload.actor?.email);\n }\n }\n }\n \n return new Response(\"OK\", { status: 200 });\n}\n\nasync function createReminderFromTicket(ticketId: string, actorEmail: string) {\n const ticket = await getLinearTicket(ticketId);\n \n const assigneeMappings: Record = {};\n \n if (ticket.children?.nodes?.length) {\n for (const subticket of ticket.children.nodes) {\n if (subticket.assignee?.email) {\n const slackUser = await lookupUserByEmail(subticket.assignee.email);\n if (slackUser) {\n assigneeMappings[subticket.assignee.email] = slackUser.id;\n }\n }\n }\n } else if (ticket.assignee?.email) {\n const slackUser = await lookupUserByEmail(ticket.assignee.email);\n if (slackUser) {\n assigneeMappings[ticket.assignee.email] = slackUser.id;\n }\n }\n \n // Use the actor who added the chase label as the creator\n const creatorSlackUser = await lookupUserByEmail(actorEmail);\n const creatorSlackId = creatorSlackUser?.id || \"linear-webhook\";\n \n console.log(`Creating reminder with data:`, {\n ticket_id: ticket.identifier,\n ticket_title: ticket.title,\n creator_slack_id: creatorSlackId,\n assignee_mappings: JSON.stringify(assigneeMappings),\n active: 1\n });\n \n const reminderId = await createAutoReminder({\n ticket_id: ticket.identifier,\n ticket_title: ticket.title,\n interval_days: 1,\n last_ping: new Date(Date.now() - 24 * 60 * 60 * 1000).toISOString(),\n ping_count: 0,\n creator_slack_id: creatorSlackId,\n assignee_mappings: JSON.stringify(assigneeMappings),\n subticket_status: \"{}\",\n active: 1,\n created_at: new Date().toISOString(),\n });\n \n console.log(`Reminder created with ID: ${reminderId} for creator: ${creatorSlackId}`);\n}\n\nasync function deactivateReminderForTicket(ticketId: string, actorEmail: string) {\n const reminder = await getReminderByTicketId(ticketId);\n \n if (reminder) {\n await updateReminder(reminder.id!, { active: 0 });\n console.log(`Deactivated reminder ${reminder.id} for ticket ${ticketId}`);\n }\n}",[],[213,220],[213],{"_102":230,"_95":231,"_152":232,"_154":-5,"_155":137,"_156":233,"_158":159,"_104":234,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":235,"_98":256},"b0cf70e6-52a2-11f0-b52c-f69ea79377d9","slack","b0cf7244-52a2-11f0-b52c-f69ea79377d9",147,["D",1750951915299],[236,246],{"_102":237,"_95":238,"_152":239,"_154":232,"_155":137,"_156":240,"_158":159,"_104":241,"_99":242,"_162":176,"_164":243,"_165":22,"_166":-5,"_167":244,"_98":245},"cfc4f9ae-625a-11f0-8625-0224a6c84d84","modalSubmit.ts","4de112e4-5128-11f0-8120-f69ea79377d9",246,["D",1752680262038],11,"/**\n * Modal Submit Handler\n * \n * Processes the reminder configuration form when user clicks \"Start Tracking\"\n * Creates a new reminder in the database with the selected options\n */\n\nimport { createReminder, updateReminder } from \"../backend/database.ts\";\nimport { getLinearTicket, addChaseLabelToIssue } from \"../backend/linearApi.ts\";\nimport { SlackModalPayload } from \"../backend/types.ts\";\n\nexport default async function handleModalSubmit(payload: SlackModalPayload) {\n if (payload.view.callback_id !== \"setup_reminder\") {\n return new Response(\"\", { status: 200 });\n }\n\n const userId = payload.user.id;\n const values = payload.view.state.values;\n const metadata = JSON.parse(payload.view.private_metadata);\n \n console.log(\"Modal submit metadata:\", metadata);\n \n // Get the selected interval\n const intervalDays = parseInt(\n values.interval_block.interval_select.selected_option.value\n );\n \n // Update assignee mappings with user selections\n const finalMappings = { ...metadata.assigneeMappings };\n \n Object.keys(values).forEach(blockId => {\n if (blockId.startsWith(\"mapping_\")) {\n const selectedUserId = Object.values(values[blockId])[0].selected_user;\n \n if (blockId.startsWith(\"mapping_unassigned_\")) {\n // For unassigned tickets, use ticket ID as key\n const ticketId = blockId.replace(\"mapping_unassigned_\", \"\");\n finalMappings[`unassigned_${ticketId}`] = selectedUserId;\n } else {\n // For assigned tickets, use email as key\n const email = blockId.replace(\"mapping_\", \"\");\n finalMappings[email] = selectedUserId;\n }\n }\n });\n \n try {\n // Get fresh ticket data to ensure we have current status\n const ticket = await getLinearTicket(metadata.ticketId);\n \n // Build initial subticket status (track completion state)\n const subticketStatus: Record = {};\n \n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets\n ticket.children.nodes.forEach((subticket) => {\n subticketStatus[subticket.id] = subticket.state.type === \"completed\";\n });\n } else {\n // Single ticket\n subticketStatus[ticket.id] = ticket.state.type === \"completed\";\n }\n \n // Only update if editing and existingReminderId is a valid number\n if (metadata.isEditing && metadata.existingReminderId && !isNaN(Number(metadata.existingReminderId))) {\n await updateReminder(Number(metadata.existingReminderId), {\n interval_days: intervalDays,\n assignee_mappings: JSON.stringify(finalMappings),\n subticket_status: JSON.stringify(subticketStatus),\n });\n } else {\n // Create new reminder\n await createReminder({\n ticket_id: metadata.ticketId,\n ticket_title: ticket.title,\n interval_days: intervalDays,\n last_ping: new Date().toISOString(),\n ping_count: 0,\n creator_slack_id: userId,\n assignee_mappings: JSON.stringify(finalMappings),\n subticket_status: JSON.stringify(subticketStatus),\n active: 1,\n created_at: new Date().toISOString(),\n });\n }\n \n // Add chase label to Linear issue\n await addChaseLabelToIssue(metadata.ticketId);\n \n return new Response(\"\", { status: 200 });\n } catch (error) {\n console.error(\"Error creating/updating reminder:\", error);\n return new Response(\"Failed to create/update reminder. Please try again.\", { status: 500 });\n }\n} ",[],[231,238],{"_102":247,"_95":248,"_152":249,"_154":232,"_155":137,"_156":250,"_158":159,"_104":251,"_99":252,"_162":176,"_164":253,"_165":22,"_166":-5,"_167":254,"_98":255},"05a9f5cc-62b7-11f0-aa5f-0224a6c84d84","slashCommand.ts","562ecfea-5128-11f0-999e-f69ea79377d9",256,["D",1752719866156],25,"/**\n * Slash Command Handler\n * \n * Handles three commands:\n * - /track-linear [ticket-id] - Opens modal to configure reminder for a Linear ticket\n * - /track-status - Shows all active reminders for the user\n * - /clear-reminders - Clears all existing reminders\n */\n\nimport { getLinearTicket, extractTicketId, removeChaseLabelFromIssue, getIssuesWithChaseLabel } from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail, openModal } from \"../backend/slackApi.ts\";\nimport { getRemindersByCreator, getAllRemindersByCreator, initDatabase, clearAllReminders } from \"../backend/database.ts\";\nimport { LinearTicket, LinearIssue } from \"../backend/types.ts\";\n\nfunction checkIfTicketComplete(ticket: LinearIssue): boolean {\n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets - check if all sub-tickets are complete\n return ticket.children.nodes.every(subticket => !!subticket.completedAt);\n } else {\n // Single ticket - check if it's complete\n return !!ticket.completedAt;\n }\n}\n\nexport default async function handleSlashCommand(req: Request) {\n \n const formData = await req.formData();\n const command = formData.get(\"command\");\n const text = formData.get(\"text\") as string;\n const triggerId = formData.get(\"trigger_id\") as string;\n const userId = formData.get(\"user_id\") as string;\n\n await initDatabase();\n\n if (command === \"/track-linear\") {\n if (!text) {\n return new Response(\"Please provide a Linear ticket ID or URL\", {\n status: 200,\n });\n }\n\n try {\n const ticketId = extractTicketId(text);\n \n // Check if user already has an active reminder for this ticket\n const existingReminders = await getRemindersByCreator(userId);\n const existingReminder = existingReminders.find(r => r.ticket_id === ticketId);\n \n console.log(\"existingReminder:\", existingReminder);\n console.log(\"ticketId:\", ticketId);\n console.log(\"existingReminders:\", existingReminders.map(r => r.ticket_id));\n \n if (existingReminder) {\n // If ticket already exists, allow editing the existing reminder\n console.log(`User ${userId} is editing existing reminder for ticket ${ticketId}`);\n }\n \n const ticket = await getLinearTicket(ticketId);\n \n // Check if ticket is currently complete in Linear\n const isTicketComplete = checkIfTicketComplete(ticket);\n \n if (isTicketComplete) {\n return new Response(\n \"This ticket is marked as completed, change the status in Linear if you'd like it to be tracked.\",\n { status: 200 }\n );\n }\n \n // Handle both parent tickets with sub-tickets and individual tickets\n let ticketsToTrack: LinearTicket[] = [];\n \n if (ticket.children?.nodes?.length) {\n // This is a parent ticket with sub-tickets\n ticketsToTrack = ticket.children.nodes;\n } else {\n // This is a single ticket, track it directly\n ticketsToTrack = [ticket];\n }\n \n // Try to auto-match assignees\n const assigneeMappings: Record = {};\n const unmatchedAssignees: string[] = [];\n \n // If editing existing reminder, start with current mappings\n if (existingReminder) {\n const currentMappings = JSON.parse(existingReminder.assignee_mappings);\n Object.assign(assigneeMappings, currentMappings);\n }\n \n for (const ticketItem of ticketsToTrack) {\n if (ticketItem.assignee?.email) {\n try {\n const email = ticketItem.assignee.email.trim().toLowerCase();\n const slackUser = await lookupUserByEmail(email);\n console.log(`[Slack Lookup] Linear email: ${email} → Slack user:`, slackUser);\n \n if (slackUser) {\n assigneeMappings[ticketItem.assignee.email] = slackUser.id;\n } else {\n assigneeMappings[ticketItem.assignee.email] = null;\n unmatchedAssignees.push(ticketItem.assignee.email);\n }\n } catch (error) {\n // If lookup fails, mark as unmatched\n console.error(`[Slack Lookup ERROR] Linear email: ${ticketItem.assignee.email}`, error);\n assigneeMappings[ticketItem.assignee.email] = null;\n unmatchedAssignees.push(ticketItem.assignee.email);\n }\n }\n }\n\n // Build the modal\n const modal = buildSetupModal(\n ticket,\n ticketsToTrack,\n assigneeMappings,\n ticketId,\n existingReminder\n );\n \n await openModal(triggerId, modal);\n \n return new Response(\"\", { status: 200 });\n } catch (error) {\n return new Response(\n `Error fetching Linear ticket: ${error.message}`,\n { status: 200 }\n );\n }\n }\n \n if (command === \"/track-status\") {\n console.log(`/track-status called by userId: ${userId}`);\n \n // Get both reminders and Linear chase-labeled issues\n const [reminders, chaseIssues] = await Promise.all([\n getRemindersByCreator(userId),\n getIssuesWithChaseLabel()\n ]);\n \n console.log(`Found ${reminders.length} reminders and ${chaseIssues.length} chase-labeled issues`);\n \n // Validate reminders - check if their Linear tickets still exist\n const validReminders = [];\n for (const reminder of reminders) {\n try {\n await getLinearTicket(reminder.ticket_id);\n validReminders.push(reminder);\n } catch (error) {\n // Ticket doesn't exist anymore, deactivate the reminder\n console.log(`Ticket ${reminder.ticket_id} no longer exists, deactivating reminder`);\n await updateReminder(reminder.id!, { active: 0 });\n }\n }\n \n // Create a combined list, avoiding duplicates\n const trackedTickets = new Map();\n \n // Add valid reminders\n validReminders.forEach(r => {\n const ticketUrl = `https://linear.app/issue/${r.ticket_id}`;\n trackedTickets.set(r.ticket_id, `• <${ticketUrl}|${r.ticket_title}> - Pinging every ${r.interval_days} days`);\n });\n \n // Add chase-labeled issues (only if not already tracked)\n chaseIssues.forEach(issue => {\n if (!trackedTickets.has(issue.identifier)) {\n const ticketUrl = `https://linear.app/issue/${issue.identifier}`;\n trackedTickets.set(issue.identifier, `• <${ticketUrl}|${issue.title}> - Pinging daily`);\n }\n });\n \n if (trackedTickets.size === 0) {\n return new Response(\"You have no active reminders or chase-labeled issues.\", { status: 200 });\n }\n \n const ticketList = Array.from(trackedTickets.values()).join(\"\\n\");\n \n return new Response(\n `Your tracked tickets:\\n${ticketList}`,\n { status: 200 }\n );\n }\n\n if (command === \"/clear-reminders\") {\n const reminders = await getRemindersByCreator(userId);\n \n for (const reminder of reminders) {\n await removeChaseLabelFromIssue(reminder.ticket_id);\n }\n \n await clearAllReminders();\n return new Response(\"All reminders and chase labels have been cleared.\", { status: 200 });\n }\n \n return new Response(\"Unknown command\", { status: 200 });\n}\n\nfunction buildSetupModal(\n ticket: LinearIssue,\n ticketsToTrack: LinearTicket[],\n assigneeMappings: Record,\n ticketId: string,\n existingReminder?: any\n) {\n const isParentTicket = ticket.children?.nodes?.length > 0;\n const ticketCount = ticketsToTrack.length;\n const ticketTypeText = isParentTicket \n ? `This ticket has ${ticketCount} sub-tickets.`\n : `Tracking this individual ticket.`;\n \n const isEditing = !!existingReminder;\n const titleText = isEditing ? \"Edit Reminder\" : \"Set Up Reminder\";\n const submitText = isEditing ? \"Update Tracking\" : \"Start Tracking\";\n\n // Define interval options\n const intervalOptions = [\n { text: { type: \"plain_text\", text: \"Daily\" }, value: \"1\" },\n { text: { type: \"plain_text\", text: \"Every 2 days\" }, value: \"2\" },\n { text: { type: \"plain_text\", text: \"Every 3 days\" }, value: \"3\" },\n { text: { type: \"plain_text\", text: \"Every 5 days\" }, value: \"5\" },\n { text: { type: \"plain_text\", text: \"Weekly\" }, value: \"7\" },\n ];\n\n let initialOption;\n if (isEditing && existingReminder) {\n initialOption = intervalOptions.find(opt => opt.value === existingReminder.interval_days.toString());\n }\n \n const blocks: any[] = [\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `*${isEditing ? 'Editing' : 'Tracking'}: ${ticket.title}*\\n${ticketTypeText}`,\n },\n },\n {\n type: \"input\",\n block_id: \"interval_block\",\n element: {\n type: \"static_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select ping interval\",\n },\n action_id: \"interval_select\",\n options: intervalOptions,\n ...(initialOption ? { initial_option: initialOption } : {}),\n },\n label: {\n type: \"plain_text\",\n text: \"Ping Interval\",\n },\n },\n {\n type: \"divider\",\n },\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: \"*Sub-ticket Assignee Mapping*\",\n },\n },\n ];\n\n // Add mapping fields for each ticket\n ticketsToTrack.forEach((ticketItem: LinearTicket, index: number) => {\n // If ticket has no assignee, we need to let user select someone\n if (!ticketItem.assignee?.email) {\n const unassignedKey = `unassigned_${ticketItem.id}`;\n const currentMapping = assigneeMappings[unassignedKey];\n \n blocks.push({\n type: \"input\",\n block_id: `mapping_${unassignedKey}`,\n element: {\n type: \"users_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select Slack user to notify\",\n },\n action_id: `user_select_${index}`,\n ...(currentMapping ? { initial_user: currentMapping } : {}),\n },\n label: {\n type: \"plain_text\",\n text: `${ticketItem.title} (Unassigned - select someone to notify)`,\n },\n });\n return;\n }\n \n const isMatched = assigneeMappings[ticketItem.assignee.email] !== null;\n \n if (!isMatched) {\n blocks.push({\n type: \"input\",\n block_id: `mapping_${ticketItem.assignee.email}`,\n element: {\n type: \"users_select\",\n placeholder: {\n type: \"plain_text\",\n text: \"Select Slack user\",\n },\n action_id: `user_select_${index}`,\n },\n label: {\n type: \"plain_text\",\n text: `${ticketItem.title} (${ticketItem.assignee.email})`,\n },\n });\n } else {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `✓ *${ticketItem.title}*\\n${ticketItem.assignee.email} → <@${assigneeMappings[ticketItem.assignee.email]}>`,\n },\n });\n }\n });\n\n return {\n type: \"modal\",\n callback_id: \"setup_reminder\",\n title: {\n type: \"plain_text\",\n text: titleText,\n },\n submit: {\n type: \"plain_text\",\n text: submitText,\n },\n close: {\n type: \"plain_text\",\n text: \"Cancel\",\n },\n private_metadata: JSON.stringify({\n ticketId,\n assigneeMappings,\n isEditing,\n existingReminderId: existingReminder?.id,\n }),\n blocks,\n };\n} ",[],[231,248],[231],{"_102":258,"_95":259,"_152":260,"_154":-5,"_155":137,"_156":136,"_158":159,"_104":261,"_99":262,"_162":263,"_164":264,"_165":22,"_166":-5,"_167":265,"_98":266},"cf8092aa-62b9-11f0-8c25-0224a6c84d84","README.md","5e9add36-5128-11f0-8492-f69ea79377d9",["D",1752721063813],38,"file","### This val is under construction! It works but the README is out of date as the spec is evolving to become an HR Onboarding Slack bot\n\n# Linear-Slack Reminder Bot\n\nLinear-Slack Reminder Bot monitors Linear tickets and sends scheduled Slack\nreminders to assignees.\n\nYou may also trigger and use this bot through adding a chase Linear label - the statuses of your Linear tickets with the label will always be synced with the Slack bot.\n\n## Here's what the bot does:\n\n1. **Track a ticket** using `/track-linear [ticket-id]`\n2. **Configure reminders** - Choose how often to ping (daily, every 2 days,\n etc.)\n3. **Automatic notifications** - The bot sends DMs to assignees of incomplete\n tickets\n4. **Escalation** - After 3 reminders, the ticket creator is also notified\n5. **Completion** - When all tasks are done, the creator gets a success\n notification\n\n## Setup Instructions:\n\n### Step 1: Remix this val to your account\n\n1. You'll need the `HTTP Request URL` from `main.ts`. E.g.\n `charmaine-17829713.val.run` for Step 2 below.\n1. You'll need to these environment variables:\n - `SLACK_BOT_TOKEN` - Your Slack bot token (see Step 2 below)\n - `LINEAR_API_KEY` - Your Linear API key (see Step 3 below)\n\n### Step 2: Create and Configure Slack App\n\n1. Go to [api.slack.com/apps](https://api.slack.com/apps) and click **\"Create\n New App\"**\n2. Choose **\"From scratch\"** and name it (e.g., \"Linear Reminder Bot\")\n3. Navigate to **OAuth & Permissions** > **Scopes** > add these **Bot Token\n Scopes**:\n - `chat:write` - To send messages\n - `users:read` - To list workspace users\n - `users:read.email` - To match Linear users by email\n - `commands` - To handle slash commands\n - `im:write` - To send direct messages\n\n4. Scroll up and click **\"Install to [Workspace Name]\"** and authorize the app\n5. Copy the **Bot User OAuth Token** (starts with `xoxb-`)\n6. Set up **Slash Commands** (under \"Slash Commands\" in sidebar):\n - Command: **`/track-linear`**\n - _Note: you can change this command, but you'll also have to change it in\n `slack/slashCommand.ts` in this val_\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands` (You get get\n this via the `main.ts` file)\n - Description: \"Track a Linear ticket for reminders\"\n - Command: **`/track-status`**\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands`\n - Description: \"View your active Linear reminders\"\n\n7. Enable **Interactivity** (under \"Interactivity & Shortcuts\"):\n - Turn ON\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/interactive`\n\n### Step 3: Get Your Linear API Key\n\n1. Open Linear and click your profile picture\n2. Go to **Settings** → **Account** → **Security & access**\n - Direct link: `https://linear.app/YOUR-WORKSPACE/settings/account/security`\n3. Under **\"Personal API keys\"**, click **\"New API key\"**\n4. Name it something memorable (e.g., \"Val Town Slack Reminder Bot\")\n5. Give it full permissions and team access for easiest set up\n6. **Copy the key immediately** - you won't be able to see it again!\n7. Add it to Val Town as the `LINEAR_API_KEY` environment variable\n\n## Usage Guide\n\n### Starting a Reminder\n\n```\n/track-linear VAL-123\n```\n\nor\n\n```\n/track-linear https://linear.app/team/issue/VAL-123\n```\n\nThis will open a modal where you can:\n\n- Select the reminder interval (daily, every 2 days, etc.)\n- Map Linear assignees to Slack users\n- Configure who gets notified for unassigned tickets\n\n### Viewing Active Reminders\n\n```\n/track-status\n```\n\nShows all your active reminders with clickable links to Linear tickets.\n\n### Stopping Reminders\n\nReminders automatically stop when:\n\n- All tracked tickets are marked as complete in Linear\n- The parent ticket is closed (for tickets with sub-tasks)\n\nYou may also manually clear all reminders with\n\n```\n/clear-reminders\n```\n\n## Testing Your Setup\n\n### Quick Test Mode\n\n1. Edit your `cronChecker` val in Val Town\n2. Change `const FORCE_RUN = false` to `true`\n3. Run the cron manually - it will send notifications immediately\n4. Change back to `false` when done testing",[],[259],{"_102":268,"_95":269,"_152":270,"_154":-5,"_155":137,"_156":271,"_158":159,"_104":272,"_99":273,"_162":274,"_164":275,"_165":22,"_166":-5,"_167":276,"_98":277},"9ee4dfba-5c02-11f0-8a7f-0224a6c84d84","cron.ts","b4c5791c-513e-11f0-94c2-f69ea79377d9",190,["D",1751982677388],15,"interval","/**\n * Cron Job - Daily Reminder Checker\n *\n * This file is long, but it's mostly just assembling the notifications and and a lot of logs for debugging.\n *\n * Runs daily to:\n * 1. Check all active reminders\n * 2. Send notifications for overdue tickets\n * 3. Escalate to creators after 3 reminders\n * 4. Celebrate completed tickets\n *\n * Set TESTING = true to test notifications immediately\n */\n\nimport { getActiveReminders, updateReminder } from \"./backend/database.ts\";\nimport { getLinearTicket } from \"./backend/linearApi.ts\";\nimport { sendDirectMessage } from \"./backend/slackApi.ts\";\nimport { LinearTicket, Reminder } from \"./backend/types.ts\";\n\n/**\n * Orchestrates the daily reminder check. This is the main cron entrypoint.\n */\nexport default async function checkReminders() {\n const TESTING = true; // TODO: change this to false to put this into production\n\n const reminders = await getActiveReminders();\n const now = new Date();\n const runTimestamp = now.toISOString();\n\n console.log(`\\n=== CRON RUN STARTED: ${runTimestamp} ===`);\n if (TESTING) {\n console.log(`⚡ TESTING MODE ENABLED - ALL REMINDERS WILL PROCESS ⚡`);\n }\n console.log(`Found ${reminders.length} active reminders to check\\n`);\n\n let totalNotificationsSent = 0;\n let totalRemindersProcessed = 0;\n\n for (const reminder of reminders) {\n if (shouldProcessReminder(reminder, now, TESTING)) {\n const notificationsSent = await processReminder(reminder);\n totalNotificationsSent += notificationsSent;\n totalRemindersProcessed++;\n }\n }\n\n const summary = buildSummary(\n runTimestamp,\n reminders.length,\n totalRemindersProcessed,\n totalNotificationsSent,\n );\n console.log(summary);\n return new Response(summary, { status: 200 });\n}\n\nfunction shouldProcessReminder(\n reminder: Reminder,\n now: Date,\n testingMode: boolean,\n): boolean {\n const lastPing = new Date(reminder.last_ping);\n const daysSinceLastPing = Math.floor(\n (now.getTime() - lastPing.getTime()) / (1000 * 60 * 60 * 24),\n );\n return testingMode || daysSinceLastPing >= reminder.interval_days;\n}\n\nfunction buildSummary(\n runTimestamp: string,\n totalChecked: number,\n processed: number,\n sent: number,\n): string {\n return `\\n=== CRON RUN COMPLETED ===\\n` +\n `Time: ${runTimestamp}\\n` +\n `Total reminders checked: ${totalChecked}\\n` +\n `Reminders processed: ${processed}\\n` +\n `Notifications sent: ${sent}\\n`;\n}\n\nasync function processReminder(reminder: Reminder): Promise {\n console.log(`\\n --- Processing ${reminder.ticket_title} ---`);\n\n // Get ticket data\n const ticket = await getLinearTicket(reminder.ticket_id);\n const assigneeMappings = JSON.parse(reminder.assignee_mappings);\n const currentStatus: Record = {};\n\n // Track reassignments\n const reassignedTickets: Array<\n { ticket: LinearTicket; oldMapping: string | null }\n > = [];\n\n console.log(\n ` Assignee mappings: ${Object.keys(assigneeMappings).length} users`,\n );\n console.log(` Mapping keys: ${Object.keys(assigneeMappings).join(\", \")}`);\n\n let allComplete = true;\n const incompleteTickets: LinearTicket[] = [];\n\n // Check if this is a parent ticket with sub-tickets or a single ticket\n if (ticket.children?.nodes?.length) {\n // Parent ticket with sub-tickets\n console.log(\n ` Type: Parent ticket with ${ticket.children.nodes.length} sub-tickets`,\n );\n for (const subticket of ticket.children.nodes) {\n const isComplete = !!subticket.completedAt;\n console.log(\n ` - Subticket: ${subticket.title} (${subticket.identifier}) completedAt: ${\n subticket.completedAt || \"null\"\n } | isComplete: ${isComplete}`,\n );\n currentStatus[subticket.id] = isComplete;\n\n if (!isComplete) {\n allComplete = false;\n incompleteTickets.push(subticket);\n }\n }\n } else {\n // Single ticket\n console.log(` Type: Single ticket`);\n const isComplete = !!ticket.completedAt;\n console.log(\n ` - Ticket: ${ticket.title} (${ticket.identifier}) completedAt: ${\n ticket.completedAt || \"null\"\n } | isComplete: ${isComplete}`,\n );\n currentStatus[ticket.id] = isComplete;\n\n if (!isComplete) {\n allComplete = false;\n incompleteTickets.push(ticket);\n }\n }\n\n console.log(` Status: ${incompleteTickets.length} incomplete tickets found`);\n\n let notificationsSent = 0;\n const ticketsWithoutMappings: LinearTicket[] = [];\n\n // Send notifications for incomplete tickets\n for (const ticketItem of incompleteTickets) {\n let slackUserId = null;\n\n // Determine who to notify\n // First try case-insensitive email match for current assignee\n if (ticketItem.assignee?.email) {\n const assigneeEmail = ticketItem.assignee.email.toLowerCase();\n const mappingKey = Object.keys(assigneeMappings).find(\n (key) => key.toLowerCase() === assigneeEmail,\n );\n if (mappingKey) {\n slackUserId = assigneeMappings[mappingKey];\n console.log(\n ` 📧 ${ticketItem.title}: Notifying assigned user ${ticketItem.assignee.email} -> ${slackUserId}`,\n );\n } else {\n // Check if this ticket was previously assigned to someone else\n const previousAssigneeKey = Object.keys(assigneeMappings).find((key) =>\n key.startsWith(\"prev_assignee_\") && key.endsWith(`_${ticketItem.id}`)\n );\n if (previousAssigneeKey) {\n const prevEmail = previousAssigneeKey.replace(`prev_assignee_`, \"\")\n .replace(`_${ticketItem.id}`, \"\");\n console.log(\n ` 🔄 ${ticketItem.title}: Detected reassignment from ${prevEmail} to ${ticketItem.assignee.email}`,\n );\n reassignedTickets.push({\n ticket: ticketItem,\n oldMapping: assigneeMappings[previousAssigneeKey],\n });\n }\n }\n }\n\n // If not found, try manual mapping for unassigned tickets\n if (!slackUserId && assigneeMappings[`unassigned_${ticketItem.id}`]) {\n slackUserId = assigneeMappings[`unassigned_${ticketItem.id}`];\n console.log(\n ` 📧 ${ticketItem.title}: Notifying manually selected user -> ${slackUserId}`,\n );\n }\n\n // If no mapping found, track it for later notification to creator\n if (!slackUserId) {\n console.log(\n ` ⚠️ ${ticketItem.title}: No user mapping found, skipping notification`,\n );\n ticketsWithoutMappings.push(ticketItem);\n continue; // Skip this ticket - no notification sent\n }\n\n if (slackUserId) {\n // Build Linear URL for the ticket\n const ticketUrl = `https://linear.app/issue/${ticketItem.identifier}`;\n\n let message =\n `🔔 Reminder: Your ticket <${ticketUrl}|*${ticketItem.title}*> is still open. Please update it in Linear.`;\n\n // If this is the 3rd ping, also notify the creator\n if (reminder.ping_count === 2) {\n message =\n `⚠️ This is your 3rd reminder! <${ticketUrl}|*${ticketItem.title}*> has been incomplete for ${\n reminder.interval_days * 3\n } days. Please prioritize this task.`;\n\n // Also notify the creator\n const parentUrl = `https://linear.app/issue/${ticket.identifier}`;\n await sendDirectMessage(\n reminder.creator_slack_id,\n `⚠️ <@${slackUserId}> has received their 3rd reminder for <${ticketUrl}|*${ticketItem.title}*> in ticket <${parentUrl}|*${ticket.title}*>. The task has been open for ${\n reminder.interval_days * 3\n } days.`,\n );\n }\n\n try {\n await sendDirectMessage(slackUserId, message);\n notificationsSent++;\n console.log(` ✅ Notification sent successfully`);\n } catch (error) {\n console.log(` ❌ Failed to send notification: ${error.message}`);\n }\n }\n }\n\n // Notify creator about tickets that need mapping setup\n if (ticketsWithoutMappings.length > 0) {\n console.log(\n ` ⚠️ Notifying creator about ${ticketsWithoutMappings.length} tickets that need mapping setup`,\n );\n const ticketUrls = ticketsWithoutMappings.map((t) =>\n `• `\n ).join(\"\\n\");\n\n const mappingMessage =\n `⚠️ Some tickets in your reminder \"\" don't have user mappings set up:\\n\\n${ticketUrls}\\n\\nPlease use \\`/track-linear ${ticket.identifier}\\` to update the reminder settings and select who should be notified for these tickets.`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, mappingMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about missing mappings`);\n } catch (error) {\n console.log(\n ` ❌ Failed to notify about missing mappings: ${error.message}`,\n );\n }\n }\n\n // Send completion notifications for newly completed tickets\n if (ticket.children?.nodes?.length) {\n // Parent ticket with subtickets - check each subticket\n for (const subticket of ticket.children.nodes) {\n if (currentStatus[subticket.id]) {\n // Subticket completed (newly or previously)\n if (\n subticket.assignee?.email &&\n assigneeMappings[subticket.assignee.email]\n ) {\n const slackUserId = assigneeMappings[subticket.assignee.email];\n try {\n const subticketUrl =\n `https://linear.app/issue/${subticket.identifier}`;\n await sendDirectMessage(\n slackUserId,\n `✅ Great job! You've completed <${subticketUrl}|*${subticket.title}*>. No more reminders for this task.`,\n );\n notificationsSent++;\n console.log(\n ` 🎉 Sent completion notification for \"${subticket.title}\" to ${slackUserId}`,\n );\n } catch (error) {\n console.log(\n ` ❌ Failed to send completion notification: ${error.message}`,\n );\n }\n }\n }\n }\n } else {\n // Single ticket - check if it's complete\n if (currentStatus[ticket.id]) {\n // Single ticket completed (newly or previously)\n if (\n ticket.assignee?.email && assigneeMappings[ticket.assignee.email]\n ) {\n const slackUserId = assigneeMappings[ticket.assignee.email];\n try {\n const ticketUrl = `https://linear.app/issue/${ticket.identifier}`;\n await sendDirectMessage(\n slackUserId,\n `✅ Great job! You've completed <${ticketUrl}|*${ticket.title}*>. No more reminders for this task.`,\n );\n notificationsSent++;\n console.log(\n ` 🎉 Sent completion notification for single ticket \"${ticket.title}\" to ${slackUserId}`,\n );\n } catch (error) {\n console.log(\n ` ❌ Failed to send completion notification: ${error.message}`,\n );\n }\n }\n }\n }\n\n // Notify creator about any reassignments\n if (reassignedTickets.length > 0) {\n console.log(\n ` 🔄 Notifying creator about ${reassignedTickets.length} reassignments`,\n );\n for (const reassignment of reassignedTickets) {\n const ticketUrl =\n `https://linear.app/issue/${reassignment.ticket.identifier}`;\n const reassignMessage =\n `🔄 Ticket <${ticketUrl}|*${reassignment.ticket.title}*> has been reassigned to ${\n reassignment.ticket.assignee?.email || \"unassigned\"\n }. You may need to update the reminder settings to ensure notifications reach the right person.`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, reassignMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about reassignment`);\n } catch (error) {\n console.log(\n ` ❌ Failed to notify about reassignment: ${error.message}`,\n );\n }\n }\n }\n\n try {\n // Always update last_ping, ping_count and the latest subticket status\n const nowIso = new Date().toISOString();\n await updateReminder(reminder.id!, {\n last_ping: nowIso,\n ping_count: reminder.ping_count + 1,\n subticket_status: JSON.stringify(currentStatus),\n // If everything is complete, mark the reminder as inactive so it no longer shows in /track-status\n active: allComplete ? 0 : 1,\n });\n console.log(\n ` 💾 Updated reminder (active=${allComplete ? 0 : 1}, ping_count=${\n reminder.ping_count + 1\n })`,\n );\n } catch (err) {\n console.log(` ❌ Failed to update reminder record: ${err.message}`);\n }\n\n // If all tickets are complete, notify the creator and deactivate\n if (allComplete) {\n const mainTicketUrl = `https://linear.app/issue/${ticket.identifier}`;\n const completeMessage = ticket.children?.nodes?.length\n ? `🎉 All sub-tickets for <${mainTicketUrl}|*${ticket.title}*> are done! Please review and close the main ticket.`\n : `🎉 The ticket <${mainTicketUrl}|*${ticket.title}*> is complete!`;\n\n try {\n await sendDirectMessage(reminder.creator_slack_id, completeMessage);\n notificationsSent++;\n console.log(` ✅ Notified creator about completion`);\n } catch (error) {\n console.log(` ❌ Failed to notify about completion: ${error.message}`);\n }\n }\n\n return notificationsSent;\n}",[],[269],{"_102":279,"_95":280,"_152":281,"_154":-5,"_155":137,"_156":282,"_158":159,"_104":283,"_99":284,"_162":285,"_164":286,"_165":22,"_166":287,"_167":288,"_98":289},"c23d305c-624c-11f0-a246-0224a6c84d84","main.ts","3d8170c4-5128-11f0-b6a3-f69ea79377d9",223,["D",1752674226360],7,"http","/**\n * Main HTTP endpoint router for the Linear-Slack Reminder Bot\n * \n * This file handles all incoming HTTP requests and routes them to the appropriate handlers:\n * - /slack/commands - Slash commands (/track-linear, /track-status)\n * - /slack/interactive - Interactive components (modal submissions)\n */\n\nimport handleSlashCommand from \"./slack/slashCommand.ts\";\nimport handleModalSubmit from \"./slack/modalSubmit.ts\";\nimport handleLinearWebhook from \"./linear/webhookHandler.ts\";\n\nexport default async function main(req: Request) {\n const url = new URL(req.url);\n \n // Handle slash commands\n if (url.pathname === \"/slack/commands\") {\n return handleSlashCommand(req);\n }\n \n // Handle interactive components (modal submissions)\n if (url.pathname === \"/slack/interactive\") {\n const formData = await req.formData();\n const payload = JSON.parse(formData.get(\"payload\") as string);\n \n if (payload.type === \"view_submission\") {\n return handleModalSubmit(payload);\n }\n }\n \n if (url.pathname === \"/linear/webhook\") {\n return handleLinearWebhook(req);\n }\n \n return new Response(\"Not found\", { status: 404 });\n}","charmaine-linear-to-slack",[],[280],"files",[149,169,180,190,200,211,218,229,236,246,257,267,278],"counts",{"_294":32,"_295":161,"_296":32,"_297":298},"pulls","branches","forks","envVars",{"_299":300,"_301":32},"count",2,"emptyCount","contents",[304,307,310,313,316,319],{"_102":150,"_95":151,"_152":153,"_154":-5,"_155":137,"_156":157,"_158":159,"_104":305,"_99":161,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":306},["D",1750789481604],[151],{"_102":212,"_95":213,"_152":214,"_154":-5,"_155":137,"_156":215,"_158":159,"_104":308,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":309},["D",1752674226189],[213],{"_102":230,"_95":231,"_152":232,"_154":-5,"_155":137,"_156":233,"_158":159,"_104":311,"_99":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_98":312},["D",1750951915299],[231],{"_102":258,"_95":259,"_152":260,"_154":-5,"_155":137,"_156":136,"_158":159,"_104":314,"_99":262,"_162":263,"_164":264,"_165":22,"_166":-5,"_98":315},["D",1752721063813],[259],{"_102":268,"_95":269,"_152":270,"_154":-5,"_155":137,"_156":271,"_158":159,"_104":317,"_99":273,"_162":274,"_164":275,"_165":22,"_166":-5,"_98":318},["D",1751982677388],[269],{"_102":279,"_95":280,"_152":281,"_154":-5,"_155":137,"_156":282,"_158":159,"_104":320,"_99":284,"_162":285,"_164":286,"_165":22,"_166":287,"_98":321},["D",1752674226360],[280],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":330,"_297":335},{"_102":103,"_95":96,"_104":331,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":332,"_131":333,"_134":334,"_146":22},["D",1750789304530],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_99":136,"_95":43,"_102":137,"_138":103,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[336,342],{"_337":338,"_104":339,"_340":-5,"_110":72,"_341":22},"key","LINEAR_API_KEY",["D",1750789836961],"updatedAt","isEmpty",{"_337":343,"_104":344,"_340":-5,"_110":72,"_341":22},"SLACK_BOT_TOKEN",["D",1750789816059],"actionData","errors"]

Key	Description
LINEAR_API_KEY
SLACK_BOT_TOKEN

charmaine

Linear-to-Slack-Reminder

Environment variables