[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_308":309,"_310":311},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_232":-5,"_20":233,"_22":234,"_235":236,"_237":238,"_26":239,"_24":240,"_241":-5,"_242":-5,"_243":56,"_244":245,"_246":47,"_247":-5,"_248":-5,"_249":250},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Crossmint","name","Linear-to-Slack-Reminder","branchName","main","version","path","slack","project",{"_35":178,"_13":14,"_48":179,"_180":-5,"_181":56,"_182":183,"_184":183,"_185":-5,"_186":-5,"_187":188,"_189":80,"_190":47,"_191":47,"_192":-5,"_193":194,"_195":196,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":202,"_203":202,"_204":205,"_206":205,"_207":205,"_208":202,"_209":202,"_210":211,"_212":213,"_214":215,"_216":56},"tree",[72,73,74,75,76,77],"file",{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":68,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_18":71},"contents",[33,34],"upstream","pull","ahead","behind","envVars",{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":58},"id","21dd57b4-62b9-11f0-a5a3-0224a6c84d84","slashCommand.ts","fileId","842d355e-c60d-4200-958c-678463c4ad93","parentId","7f1c8f08-b4f8-43a3-a731-82f3adea16d5","branchId","27583b16-5c0e-11f0-a4dc-0224a6c84d84","branchVersion",47,"latest",true,"createdAt",["D",1752720772499],18,"fileType","script","content","/**\n * Slash Command Handler\n *\n * Handles three commands:\n * - /chase [ticket-id] - Opens modal to configure reminder for a Linear ticket\n * - /status-chaser - Shows all active reminders for the user\n * - /clear-chasers - Clears all existing reminders\n */\n\nimport {\n clearAllReminders,\n getAllRemindersByCreator,\n getRemindersByCreator,\n initDatabase,\n} from \"../backend/database.ts\";\nimport {\n extractTicketId,\n getIssuesWithChaseLabel,\n getLinearTicket,\n removeChaseLabelFromIssue,\n} from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail, openModal } from \"../backend/slackApi.ts\";\nimport { LinearIssue, LinearTicket } 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 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 === \"/chase\") {\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 === \"/status-chaser\") {\n console.log(`/status-chaser 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-chasers\") {\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} → <@${\n assigneeMappings[ticketItem.assignee.email]\n }>`,\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}","deleted",false,"label",[19,37],"cde16a9c-62b8-11f0-ad0b-0224a6c84d84","modalSubmit.ts","b263e099-dd1d-4ad4-b27d-d59729e28716",36,["D",1752720631597],1,"/**\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 { addChaseLabelToIssue, getLinearTicket } 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}",[19,60],"27675b96-5c0e-11f0-a4dc-0224a6c84d84",["D",1751987630741],0,"directory",[19],{"_35":135,"_13":136,"_38":137,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":138,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":139,"_18":140},{"_35":119,"_13":120,"_38":121,"_40":-5,"_42":43,"_44":122,"_46":47,"_48":123,"_17":64,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":124,"_18":125},{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":108,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":109,"_18":110},{"_35":99,"_13":100,"_38":101,"_40":-5,"_42":43,"_44":102,"_46":47,"_48":103,"_17":104,"_51":24,"_53":105,"_55":56,"_57":-5,"_86":106,"_18":107},{"_35":89,"_13":90,"_38":91,"_40":-5,"_42":43,"_44":92,"_46":47,"_48":93,"_17":94,"_51":95,"_53":96,"_55":56,"_57":-5,"_86":97,"_18":98},{"_35":78,"_13":79,"_38":80,"_40":-5,"_42":43,"_44":81,"_46":47,"_48":82,"_17":83,"_51":84,"_53":85,"_55":56,"_57":-5,"_86":87,"_18":88},"e419aaea-62b8-11f0-bffe-0224a6c84d84","main.ts","13d59912-3d8a-4fe5-85cb-b5c9c34eef2b",43,["D",1752720668875],4,"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 handleLinearWebhook from \"./linear/webhookHandler.ts\";\nimport handleModalSubmit from \"./slack/modalSubmit.ts\";\nimport handleSlashCommand from \"./slack/slashCommand.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}","children",[],[79],"514e604c-62b9-11f0-a5a3-0224a6c84d84","cron.ts","a41ae8df-fa7e-41a5-b518-9ef53642aa7d",50,["D",1752720852091],5,"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 = `⚠️ 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 .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 \\`/chase ${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 = `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 = `https://linear.app/issue/${reassignment.ticket.identifier}`;\n const reassignMessage = `🔄 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 /status-chase\n active: allComplete ? 0 : 1,\n });\n console.log(\n ` 💾 Updated reminder (active=${allComplete ? 0 : 1}, ping_count=${reminder.ping_count + 1})`,\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}",[],[90],"7e60a1d0-62b9-11f0-9142-0224a6c84d84","README.md","13342248-0b37-4af5-9daf-1828fe60ba47",52,["D",1752720927710],9,"# 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: **`/chase`**\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: **`/status-chaser`**\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands`\n - Description: \"View your active Linear reminders\"\n - Command: **`/clear-chasers`**\n - **Request URL:** `https://[YOUR-VALTOWN-URL]/slack/commands`\n - Description: \"Clear all active reminders you have set\"\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-chasers\n```\n\n## Testing Your Setup\n\n### Quick Test Mode\n\n1. Edit your `cron.ts` file 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",[],[100],["D",1751987630741],[111,112],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":116,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_86":117,"_18":118},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":113,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_86":114,"_18":115},["D",1752720772499],[],[19,37],["D",1752720631597],[],[19,60],"bce7e2f2-62b8-11f0-b221-0224a6c84d84","linear","bb2f5d28-62b8-11f0-b039-0224a6c84d84",32,["D",1752720603118],[126],[120],{"_35":127,"_13":128,"_38":129,"_40":121,"_42":43,"_44":130,"_46":47,"_48":131,"_17":83,"_51":52,"_53":132,"_55":56,"_57":-5,"_86":133,"_18":134},"968b1b6e-62b9-11f0-a5a3-0224a6c84d84","webhookHandler.ts","c0132b12-62b8-11f0-b221-0224a6c84d84",53,["D",1752720968254],"import {\n createAutoReminder,\n getReminderByTicketId,\n getRemindersByCreator,\n updateReminder,\n} from \"../backend/database.ts\";\nimport { getLinearTicket, removeChaseLabelFromIssue } from \"../backend/linearApi.ts\";\nimport { lookupUserByEmail } from \"../backend/slackApi.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) => label.name.toLowerCase().includes(\"chase\"));\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}",[],[120,128],"2767443a-5c0e-11f0-a4dc-0224a6c84d84","backend","4bbcdb0b-19ae-4a4d-820f-c9ba7e9cd798",["D",1751987630741],[141,142,143,144],[136],{"_35":170,"_13":171,"_38":172,"_40":137,"_42":43,"_44":173,"_46":47,"_48":174,"_17":158,"_51":52,"_53":175,"_55":56,"_57":-5,"_86":176,"_18":177},{"_35":162,"_13":163,"_38":164,"_40":137,"_42":43,"_44":165,"_46":47,"_48":166,"_17":64,"_51":52,"_53":167,"_55":56,"_57":-5,"_86":168,"_18":169},{"_35":153,"_13":154,"_38":155,"_40":137,"_42":43,"_44":156,"_46":47,"_48":157,"_17":158,"_51":52,"_53":159,"_55":56,"_57":-5,"_86":160,"_18":161},{"_35":145,"_13":146,"_38":147,"_40":137,"_42":43,"_44":148,"_46":47,"_48":149,"_17":64,"_51":52,"_53":150,"_55":56,"_57":-5,"_86":151,"_18":152},"b6f7fa12-62b8-11f0-bcd3-0224a6c84d84","types.ts","825a1182-36a9-4815-9fce-8dabbc695b80",30,["D",1752720593162],"// 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}",[],[136,146],"b40624be-62b8-11f0-8a91-0224a6c84d84","slackApi.ts","2a2cafe0-9148-487d-ba32-e6bdeb22d4c6",29,["D",1752720588219],3,"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}",[],[136,154],"9feedae8-62b8-11f0-8940-0224a6c84d84","linearApi.ts","fad2a188-786f-4acf-a882-5edfe4251e6f",26,["D",1752720554513],"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 ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n }\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 ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n }\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 ? {\n email: issue.assignee.email || \"\",\n name: issue.assignee.name || \"\",\n }\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 ? {\n email: child.assignee.email || \"\",\n name: child.assignee.name || \"\",\n }\n : undefined,\n completedAt: child.completedAt,\n })),\n },\n }));\n}",[],[136,163],"9ce2e7d6-62b8-11f0-9142-0224a6c84d84","database.ts","e497ab87-6558-43d9-9275-16318f6e00f7",25,["D",1752720549395],"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}",[],[136,171],"275590c8-5c0e-11f0-a4dc-0224a6c84d84",["D",1751987630741],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","80253444-09af-4df4-a560-c86b38750edf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"orgId","01989fcc-dbe7-7389-a3ad-45c50d401a74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_231":227},"org",{"_11":12,"_225":-5,"_226":227,"_187":-5,"_228":229,"_230":47},"branch",{"_17":130,"_13":16,"_35":43,"_217":178,"_218":-5,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":14,"_224":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/dc2506f3-9fe8-4b41-d79b-eb9074f98200/square512?exp=1789577999&sig=19f4cb303cfaa4faf170b9e24a3ba9a015cc7ca021a87bff5247debe5b7d8d4b","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":178,"_13":14,"_48":304,"_180":-5,"_181":56,"_182":183,"_184":183,"_185":-5,"_186":-5,"_187":188,"_189":80,"_190":47,"_191":47,"_192":-5,"_193":194,"_195":196,"_197":-5,"_198":-5,"_199":-5,"_200":-5,"_201":202,"_203":202,"_204":205,"_206":205,"_207":205,"_208":202,"_209":202,"_210":305,"_212":306,"_214":307,"_216":56},[265,270,272,275,276,277],"files",[265,266,267,268,269,270,271,272,273,274,275,276,277],"counts",{"_256":69,"_257":64,"_258":69,"_32":259,"_260":261},[252,253],{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":68,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_18":251},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_18":255},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":254},[19,37],[19,60],"pulls","branches","forks",{"_262":194,"_264":69},"connections",{"_262":69,"_263":69},"count","unfilledCount","emptyCount",{"_35":135,"_13":136,"_38":137,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":138,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":302,"_18":303},{"_35":170,"_13":171,"_38":172,"_40":137,"_42":43,"_44":173,"_46":47,"_48":174,"_17":158,"_51":52,"_53":175,"_55":56,"_57":-5,"_86":300,"_18":301},{"_35":162,"_13":163,"_38":164,"_40":137,"_42":43,"_44":165,"_46":47,"_48":166,"_17":64,"_51":52,"_53":167,"_55":56,"_57":-5,"_86":298,"_18":299},{"_35":153,"_13":154,"_38":155,"_40":137,"_42":43,"_44":156,"_46":47,"_48":157,"_17":158,"_51":52,"_53":159,"_55":56,"_57":-5,"_86":296,"_18":297},{"_35":145,"_13":146,"_38":147,"_40":137,"_42":43,"_44":148,"_46":47,"_48":149,"_17":64,"_51":52,"_53":150,"_55":56,"_57":-5,"_86":294,"_18":295},{"_35":119,"_13":120,"_38":121,"_40":-5,"_42":43,"_44":122,"_46":47,"_48":123,"_17":64,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":292,"_18":293},{"_35":127,"_13":128,"_38":129,"_40":121,"_42":43,"_44":130,"_46":47,"_48":131,"_17":83,"_51":52,"_53":132,"_55":56,"_57":-5,"_86":290,"_18":291},{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":108,"_17":69,"_51":70,"_53":-5,"_55":56,"_57":-5,"_86":288,"_18":289},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":116,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_86":286,"_18":287},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":113,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_86":284,"_18":285},{"_35":99,"_13":100,"_38":101,"_40":-5,"_42":43,"_44":102,"_46":47,"_48":103,"_17":104,"_51":24,"_53":105,"_55":56,"_57":-5,"_86":282,"_18":283},{"_35":89,"_13":90,"_38":91,"_40":-5,"_42":43,"_44":92,"_46":47,"_48":93,"_17":94,"_51":95,"_53":96,"_55":56,"_57":-5,"_86":280,"_18":281},{"_35":78,"_13":79,"_38":80,"_40":-5,"_42":43,"_44":81,"_46":47,"_48":82,"_17":83,"_51":84,"_53":85,"_55":56,"_57":-5,"_86":278,"_18":279},[],[79],[],[90],[],[100],[],[19,37],[],[19,60],[273,274],[19],[],[120,128],[271],[120],[],[136,146],[],[136,154],[],[136,163],[],[136,171],[266,267,268,269],[136],["D",1751987630741],{"_11":12,"_231":227},{"_11":12,"_225":-5,"_226":227,"_187":-5,"_228":229,"_230":47},{"_17":130,"_13":16,"_35":43,"_217":178,"_218":-5,"_219":-5,"_220":-5,"_221":-5,"_222":-5,"_223":14,"_224":12},"ctx",{"_210":-5,"_248":341,"_342":343,"_344":345,"_346":56,"_347":56,"_348":56,"_349":47,"_350":-5,"_351":-7,"_352":-7,"_353":69,"_354":56,"_355":56,"_356":-5,"_357":56,"_358":56,"_359":56,"_360":-5},"ENV",{"_312":313,"_314":315,"_316":16,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340},"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"]