[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","timothylawrence","name","airBookAppointment","path","warmCallReminder.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":-5,"_53":-5,"_54":55,"_56":57,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/timothylawrence/airBookAppointment/code/warmCallReminder.ts","extension","id","4ee54994-a093-4dc3-adab-a0716ee68c2f","fileId","d1892f6a-8876-11f1-99a8-1607ee4eb77e","parentId","branchId","e3cbae3a-3e5d-43de-9326-7c6a0d258101","branchVersion",63,"latest",true,"createdAt",["D",1785105594601],"version",3,"fileType","interval","content","// AIR — Warm Call Reminder\n// Runs every 30 minutes. Finds any booked call in the Airtable \"Sales Calls\"\n// table whose start time falls ~5 hours from now, and pings Telegram.\n//\n// The window is [now+4h45m, now+5h15m). At a 30-minute cadence those windows\n// tile exactly, so every call fires exactly once — no duplicates, no gaps,\n// and no extra \"Reminded\" checkbox field needed in Airtable.\n//\n// SCHEDULE — cron `*/30 * * * *`. Do not switch this to a delay-based schedule.\n// Two reasons, both learned the hard way on 2026-07-26:\n// 1. It had silently been set to \"every 1 hour\", which does not match the\n// 30-minute window above. Half of every hour was uncovered, so roughly\n// half of all warm calls got no reminder at all and nothing complained.\n// 2. Delay schedules drift. Log timestamps ran 12:23AM -> 3:30PM in one day,\n// about 7 minutes of slip. Drift leaves an uncovered sliver each cycle\n// even at the correct nominal cadence. Cron fires on :00/:30 exactly.\n// If you change HALF_WINDOW_MINUTES, change the cron to match, or the\n// \"tile exactly\" promise above quietly stops being true.\n//\n// Required val.town environment variables:\n// AIRTABLE_TOKEN (already set — used by airBookAppointment)\n// WARMCALL_BOT_TOKEN (the SECOND bot, dedicated to warm-call reminders,\n// so these land in their own Telegram thread and do\n// not mix with the AIR booking alerts)\n// WARMCALL_CHAT_ID (optional — falls back to TELEGRAM_CHAT_ID, since\n// Anders' personal chat id is the same for any bot)\n//\n// Set TEST_MODE=1 in the query string when deployed as an http val to preview\n// what would be sent without actually sending it.\n\nconst BASE_ID = \"appufYpiORDVFQ71x\";\nconst SALES_CALLS = \"tbleWRws0e03altKS\";\n\nconst LEAD_MINUTES = 300; // 5 hours\nconst HALF_WINDOW_MINUTES = 15; // ±15 min → a 30 min window\nconst TZ = \"America/Los_Angeles\";\n\n// Statuses that mean the call is dead — never remind on these.\nconst DEAD_STATUSES = [\"done\", \"completed\", \"complete\", \"cancelled\", \"canceled\", \"no show\", \"lost\", \"closed\"];\n\ntype Rec = { id: string; fields: Record };\n\nfunction fmtWhen(iso: string): string {\n const d = new Date(iso);\n const day = d.toLocaleDateString(\"en-US\", {\n timeZone: TZ, weekday: \"short\", month: \"short\", day: \"numeric\",\n });\n const time = d.toLocaleTimeString(\"en-US\", {\n timeZone: TZ, hour: \"numeric\", minute: \"2-digit\",\n });\n return `${day} at ${time}`;\n}\n\nfunction minutesUntil(iso: string, now: number): number {\n return Math.round((new Date(iso).getTime() - now) / 60000);\n}\n\nfunction esc(s: string): string {\n return String(s).replace(/&/g, \"&\").replace(//g, \">\");\n}\n\n// Pull the most useful chunk of the prep notes: the wedge and the opener.\nfunction prepSnippet(notes: string): string {\n if (!notes) return \"\";\n const markers = [\"THE WEDGE\", \"THE OPENER\", \"OPENER -\"];\n for (const m of markers) {\n const i = notes.indexOf(m);\n if (i !== -1) {\n const chunk = notes.slice(i, i + 420).trim();\n return chunk.length < notes.length - i ? chunk + \"…\" : chunk;\n }\n }\n return notes.slice(0, 420).trim() + (notes.length > 420 ? \"…\" : \"\");\n}\n\nfunction buildMessage(f: Record, mins: number, backup = false): string {\n const biz = f[\"Business\"] || f[\"Call\"] || \"Unknown business\";\n const when = f[\"When\"] ? fmtWhen(f[\"When\"]) : \"time not set\";\n const who = f[\"With\"] || \"\";\n const phone = f[\"Phone\"] || \"\";\n const hrs = (mins / 60).toFixed(1).replace(/\\.0$/, \"\");\n\n const lines = [\n `⏰ Warm call in ~${hrs} hours`,\n ``,\n `${esc(biz)}`,\n `🕐 ${esc(when)}`,\n ];\n if (who) lines.push(`👤 ${esc(who)}`);\n if (phone) lines.push(`📞 ${esc(phone)}`);\n\n const snip = prepSnippet(f[\"Prep Notes\"] || \"\");\n if (snip) {\n lines.push(``, `${esc(snip)}`);\n }\n if (backup) {\n lines.push(``, `(sent via the alerts bot — the warm-call bot token is not working)`);\n }\n return lines.join(\"\\n\");\n}\n\nasync function tokenWorks(token: string): Promise {\n try {\n const r = await fetch(`https://api.telegram.org/bot${token}/getMe`);\n const j = await r.json();\n return !!j.ok;\n } catch {\n return false;\n }\n}\n\nasync function fetchCalls(token: string): Promise {\n const out: Rec[] = [];\n let offset = \"\";\n do {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${SALES_CALLS}?pageSize=100${offset ? `&offset=${offset}` : \"\"}`;\n const r = await fetch(url, { headers: { Authorization: `Bearer ${token}` } });\n if (!r.ok) throw new Error(`Airtable ${r.status}: ${await r.text()}`);\n const j = await r.json();\n out.push(...(j.records || []));\n offset = j.offset || \"\";\n } while (offset);\n return out;\n}\n\nasync function sendTelegram(botToken: string, chatId: string, text: string) {\n const r = await fetch(`https://api.telegram.org/bot${botToken}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: chatId,\n text,\n parse_mode: \"HTML\",\n disable_web_page_preview: true,\n }),\n });\n const body = await r.text();\n if (!r.ok) throw new Error(`Telegram ${r.status}: ${body}`);\n return body;\n}\n\nexport async function run(opts: { dryRun?: boolean; overrideWindow?: boolean } = {}) {\n const airtableToken = Deno.env.get(\"AIRTABLE_TOKEN\");\n // Dedicated warm-call bot, with the alerts bot as a delivery backstop.\n // Original intent was loud failure over silent cross-delivery, but a broken\n // WARMCALL_BOT_TOKEN would mean silently missing a real call — worse. So we\n // fall back and flag it in the message body instead.\n const warmToken = Deno.env.get(\"WARMCALL_BOT_TOKEN\");\n const alertsToken = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const warmOk = warmToken ? await tokenWorks(warmToken) : false;\n const usingBackup = !warmOk && !!alertsToken;\n const botToken = warmOk ? warmToken : alertsToken;\n // Chat id is per-person, not per-bot, so reusing the existing one is fine.\n const chatId = Deno.env.get(\"WARMCALL_CHAT_ID\") || Deno.env.get(\"TELEGRAM_CHAT_ID\");\n\n const missing = [\n !airtableToken && \"AIRTABLE_TOKEN\",\n !botToken && \"WARMCALL_BOT_TOKEN (and no TELEGRAM_BOT_TOKEN to fall back on)\",\n !chatId && \"WARMCALL_CHAT_ID (or TELEGRAM_CHAT_ID)\",\n ].filter(Boolean);\n\n if (missing.length && !opts.dryRun) {\n console.error(`[warmCallReminder] missing env vars: ${missing.join(\", \")}`);\n return { ok: false, missing };\n }\n\n const now = Date.now();\n const lo = now + (LEAD_MINUTES - HALF_WINDOW_MINUTES) * 60000;\n const hi = now + (LEAD_MINUTES + HALF_WINDOW_MINUTES) * 60000;\n\n const records = await fetchCalls(airtableToken!);\n const due: Rec[] = [];\n\n for (const rec of records) {\n const f = rec.fields || {};\n const when = f[\"When\"];\n if (!when) continue;\n\n const status = String(f[\"Status\"] || \"\").toLowerCase();\n if (DEAD_STATUSES.some((d) => status.includes(d))) continue;\n\n const t = new Date(when).getTime();\n if (Number.isNaN(t)) continue;\n\n if (opts.overrideWindow) {\n if (t > now) due.push(rec); // preview: every future call\n } else if (t >= lo && t < hi) {\n due.push(rec);\n }\n }\n\n const results: any[] = [];\n for (const rec of due) {\n const mins = minutesUntil(rec.fields[\"When\"], now);\n const msg = buildMessage(rec.fields, mins, usingBackup);\n if (opts.dryRun) {\n results.push({ id: rec.id, business: rec.fields[\"Business\"], minutesOut: mins, preview: msg });\n } else {\n try {\n await sendTelegram(botToken!, chatId!, msg);\n results.push({ id: rec.id, business: rec.fields[\"Business\"], sent: true });\n console.log(`[warmCallReminder] sent for ${rec.fields[\"Business\"]}`);\n } catch (e) {\n results.push({ id: rec.id, business: rec.fields[\"Business\"], sent: false, error: String(e) });\n console.error(`[warmCallReminder] FAILED ${rec.fields[\"Business\"]}: ${e}`);\n }\n }\n }\n\n return {\n ok: true,\n bot: warmOk ? \"warm-call bot\" : usingBackup ? \"alerts bot (backup)\" : \"none\",\n scanned: records.length,\n windowPT: [new Date(lo).toLocaleString(\"en-US\", { timeZone: TZ }), new Date(hi).toLocaleString(\"en-US\", { timeZone: TZ })],\n matched: due.length,\n results,\n };\n}\n\nexport default async function (): Promise {\n const out = await run();\n console.log(JSON.stringify(out));\n}\n","deleted",false,"label",[14],"a936d0be-71b4-48f7-bc4e-0840cbcb0bc6",["D",1783998470573],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","5a072328-1f44-4d09-b8a0-7919504ab306","pinnedFileId","c081faa4-8712-11f1-ba8b-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e5c50-a8bf-778d-aaf9-5ede2971faa5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_102":98},"org",{"_9":10,"_95":96,"_97":98,"_54":55,"_99":100,"_101":42},"branch",{"_35":85,"_11":86,"_22":28,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":12,"_94":10},"isOwned",67,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Timothy Lawrence","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ-QXv4wwoyobVsfZEjp7nCiQrTDtRRy_t2AK6YRWGNRQQYLLA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":62,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":86,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]