[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_147":148,"_149":150},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_86":-7,"_87":81,"_29":-7,"_88":-5,"_15":89,"_90":91,"_92":93,"_94":95,"_96":97,"_98":-5,"_99":-5,"_100":-5,"_101":38,"_102":103,"_104":38,"_105":-5,"_106":-5,"_107":108},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","bfvrexpert","name","safety-monthly-alert","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":38,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59,"_60":59,"_61":62,"_63":62,"_64":62,"_65":59,"_66":59,"_67":68,"_69":70,"_71":72,"_73":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","25274b64-5129-11f1-bc32-ee650bb23af1","createdAt",["D",1778937258403],"updatedAt",["D",1779298559534],"main","projectId","2526a394-5129-11f1-bc32-ee650bb23af1","version",10,"forkedBranchId","forkedBranchVersion","lockfileKey","1780322424139-esm.town_v_bfvrexpert_safety-monthly-alert@10-main","deletedAt",["D",1778937258398],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","userId","3d74bb3a-ee97-4377-8346-1b82d2e6d97d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d944b-53b0-7736-82ea-29d8e70d35eb","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_85":81},"org",{"_11":12,"_79":-5,"_80":81,"_44":45,"_82":83,"_84":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_74":-5,"_75":-5,"_76":-5,"_77":14,"_78":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","","tier","pro","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_20":28,"_13":14,"_22":143,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":38,"_48":-5,"_49":-5,"_50":51,"_52":53,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":59,"_60":59,"_61":62,"_63":62,"_64":62,"_65":59,"_66":59,"_67":144,"_69":145,"_71":146,"_73":38},"tree",[138],"files",[138],"counts",{"_128":51,"_17":129,"_130":51,"_131":132,"_133":134},"contents",[109],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":110,"_13":111,"_112":113,"_114":-5,"_115":21,"_116":30,"_117":118,"_22":119,"_29":120,"_121":122,"_123":124,"_125":38,"_126":-5,"_87":127},"5d6b6e6e-5472-11f1-95b9-ee650bb23af1","main.ts","fileId","25297092-5129-11f1-bc32-ee650bb23af1","parentId","branchId","branchVersion","latest",true,["D",1779298559534],9,"fileType","interval","content","// ─────────────────────────────────────────────────────────────\n// VAL: safety-monthly-alert (Scheduled / Cron val)\n//\n// Runs on the 1st of each month. Lists every property whose\n// 6-month \"nextDate\" has already passed — i.e., is overdue for\n// a new inspection. Posts the list to #br-safety-inspections.\n// An overdue property will keep showing up every month until\n// it's inspected (which resets nextDate to inspDate + 6 months).\n//\n// Cron schedule in Val Town: 0 14 1 * *\n// → 14:00 UTC on the 1st = 9:00 AM Louisville (CDT) / 10:00 AM (CST)\n// ─────────────────────────────────────────────────────────────\n\nconst FIREBASE_URL =\n \"https://safety-inspection-checklist-default-rtdb.firebaseio.com\";\nconst FIREBASE_PATH = \"safety-inspection-v2\";\nconst SLACK_WEBHOOK =\n \"https://hooks.slack.com/services/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\";\nconst CHECKLIST_URL =\n \"https://bfvrexpert--93692dbe512811f1b49dee650bb23af1.web.val.run\";\n\nconst PROPERTIES = [\n { id: \"park\", name: \"Park Place Lodge\", floors: 2, beds: 9 },\n { id: \"prl\", name: \"Persimmon Ridge Lodge\", floors: 3, beds: 7 },\n { id: \"oak\", name: \"The Oak Barrel Lodge\", floors: 2, beds: 6 },\n { id: \"manor\", name: \"Louisville Country Manor\", floors: 3, beds: 7 },\n { id: \"louisx\", name: \"The Louis X — Hotel Buyout\", floors: 3, beds: 8 },\n { id: \"lavish\", name: \"The Norton Commons Lavish\", floors: 3, beds: 4 },\n { id: \"luxe\", name: \"The Norton Commons Luxe\", floors: 3, beds: 4 },\n { id: \"spirit\", name: \"The Kentucky Spirit Retreat\", floors: 3, beds: 3 },\n { id: \"ferndale\", name: \"Bourbon Trail Central\", floors: 1, beds: 3 },\n {\n id: \"sleepy\",\n name: \"Harris House — Creekside Retreat\",\n floors: 2,\n beds: 5,\n },\n { id: \"hannah\", name: \"Farmhouse Hannah\", floors: 3, beds: 3 },\n { id: \"shelby74\", name: \"Bourbon House 2\", floors: 3, beds: 4 },\n { id: \"shelby76\", name: \"Bourbon House 3\", floors: 2, beds: 5 },\n {\n id: \"welling\",\n name: \"Bourbon House 4 — The Wellingmoor\",\n floors: 1,\n beds: 3,\n },\n { id: \"booker\", name: \"11004 Booker Rd\", floors: 3, beds: 3 },\n { id: \"cres1\", name: \"210 Crescent Ct #1\", floors: 1, beds: 3 },\n { id: \"cres2\", name: \"210 Crescent Ct #2\", floors: 1, beds: 3 },\n { id: \"lagrange\", name: \"Lagrange Loft\", floors: 1, beds: 1 },\n { id: \"bards\", name: \"1829 Bardstown Rd\", floors: 1, beds: 2 },\n { id: \"douglass\", name: \"1894 Douglass Blvd\", floors: 1, beds: 2 },\n { id: \"lyric\", name: \"The Lyric 185\", floors: 1, beds: 3 },\n { id: \"cottage\", name: \"On the Rocks Cottage\", floors: 3, beds: 1 },\n { id: \"lawrenceburg\", name: \"Storybook Stone Home\", floors: 3, beds: 5 },\n { id: \"bourbon\", name: \"1203 Bourbon Ave\", floors: 2, beds: 5 },\n { id: \"lx22\", name: \"Suite 22 — Entertainment Suite\", floors: 1, beds: 1 },\n {\n id: \"lx23\",\n name: \"Suite 23 — Thunder Over Louisville\",\n floors: 1,\n beds: 1,\n },\n { id: \"lx24\", name: \"Suite 24 — Louisville Slugger\", floors: 1, beds: 1 },\n { id: \"lx25\", name: \"Suite 25 — Kentucky Oaks\", floors: 1, beds: 1 },\n { id: \"lx32\", name: \"Suite 32 — The Bourbon Suite\", floors: 1, beds: 1 },\n { id: \"lx33\", name: \"Suite 33 — Thomas Edison\", floors: 1, beds: 1 },\n { id: \"lx34\", name: \"Suite 34 — Muhammad Ali\", floors: 1, beds: 1 },\n { id: \"lx35\", name: \"Suite 35 — Kentucky Derby\", floors: 1, beds: 1 },\n];\n\nasync function fbGet(path: string): Promise {\n const r = await fetch(`${FIREBASE_URL}/${path}.json`);\n if (!r.ok) return null;\n return r.json();\n}\n\nfunction buildTaskIdsFor(pid: string, floors: number, beds: number): string[] {\n const ids: string[] = [];\n // Smoke & CO: per bedroom + per floor\n for (let b = 1; b <= beds; b++) ids.push(`${pid}-sm-br${b}`);\n for (let f = 1; f <= floors; f++) ids.push(`${pid}-sm-hall${f}`);\n // Extinguishers: per floor + kitchen\n for (let f = 1; f <= floors; f++) ids.push(`${pid}-ext-fl${f}`);\n ids.push(`${pid}-ext-kit`);\n // First aid: per floor\n for (let f = 1; f <= floors; f++) ids.push(`${pid}-fa-fl${f}`);\n // Escape plans: per floor\n for (let f = 1; f <= floors; f++) ids.push(`${pid}-esc-fl${f}`);\n // General safety\n [\n \"exits\",\n \"lights\",\n \"gas\",\n \"gfci\",\n \"stairs\",\n \"trip\",\n \"outdoor\",\n \"lockbox\",\n \"numbers\",\n \"pool\",\n \"grill\",\n ]\n .forEach((s) => ids.push(`${pid}-gen-${s}`));\n // Owner communication\n ids.push(`${pid}-own-dryer`);\n return ids;\n}\n\nfunction daysBetween(a: number, b: number): number {\n return Math.floor((b - a) / 86400000);\n}\n\n// Returns the list of detector IDs at a property — must mirror the\n// IDs used in safety-checklist's detectorIdsFor.\nfunction detectorIdsFor(\n pid: string,\n floors: number,\n beds: number,\n): Array<{ id: string; label: string }> {\n const ids: Array<{ id: string; label: string }> = [];\n for (let b = 1; b <= beds; b++) {\n ids.push({ id: `${pid}-sm-br${b}`, label: `Bedroom ${b}` });\n }\n for (let f = 1; f <= floors; f++) {\n ids.push({ id: `${pid}-sm-hall${f}`, label: `Floor ${f} hall` });\n }\n return ids;\n}\n\nexport default async function () {\n const state = await fbGet(FIREBASE_PATH);\n if (!state) {\n console.log(\"No Firebase state found, skipping monthly alert\");\n return;\n }\n\n // ─── 1. Safety inspections overdue (6-month cadence) ───\n const overdueInspections: Array<\n { name: string; status: string; currentDone: number; currentTotal: number }\n > = [];\n const now = Date.now();\n\n for (const p of PROPERTIES) {\n const meta = state[`_meta_${p.id}`] || {};\n const ids = buildTaskIdsFor(p.id, p.floors, p.beds);\n const currentDone = ids.filter((id) => state[id]?.checked).length;\n const currentTotal = ids.length;\n\n let isOverdue = false;\n let status = \"\";\n\n if (!meta.nextDate) {\n isOverdue = true;\n status = \"Never inspected\";\n } else {\n const nextMs = new Date(meta.nextDate + \"T12:00:00\").getTime();\n if (nextMs < now) {\n const daysOver = daysBetween(nextMs, now);\n const dueStr = new Date(meta.nextDate + \"T12:00:00\")\n .toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n status = `Was due ${dueStr} · ${daysOver} day${\n daysOver === 1 ? \"\" : \"s\"\n } overdue`;\n isOverdue = true;\n }\n }\n\n if (isOverdue) {\n overdueInspections.push({\n name: p.name,\n status,\n currentDone,\n currentTotal,\n });\n }\n }\n\n // ─── 2. Detector tests overdue (30-day cadence) ───\n // ─── 3. Batteries due for replacement (annual) ───\n // ─── 4. Detector units due for replacement (5-year) ───\n const overdueTests: Array<\n { propName: string; detectorLabel: string; ageDays: number | null }\n > = [];\n const overdueBatteries: Array<\n { propName: string; detectorLabel: string; ageDays: number | null }\n > = [];\n const overdueUnits: Array<\n { propName: string; detectorLabel: string; ageDays: number | null }\n > = [];\n\n for (const p of PROPERTIES) {\n const detectors = detectorIdsFor(p.id, p.floors, p.beds);\n for (const d of detectors) {\n const data = state[\"_dtest_\" + d.id] || {};\n // Test (30 days)\n const testedAge = data.tested\n ? Math.floor(\n (now - new Date(data.tested + \"T12:00:00\").getTime()) / 86400000,\n )\n : null;\n if (testedAge === null || testedAge > 30) {\n overdueTests.push({\n propName: p.name,\n detectorLabel: d.label,\n ageDays: testedAge,\n });\n }\n // Battery (365 days)\n const batteryAge = data.battery\n ? Math.floor(\n (now - new Date(data.battery + \"T12:00:00\").getTime()) / 86400000,\n )\n : null;\n if (batteryAge === null || batteryAge > 365) {\n overdueBatteries.push({\n propName: p.name,\n detectorLabel: d.label,\n ageDays: batteryAge,\n });\n }\n // Unit (5 years = 1825 days)\n const unitAge = data.unit\n ? Math.floor(\n (now - new Date(data.unit + \"T12:00:00\").getTime()) / 86400000,\n )\n : null;\n if (unitAge === null || unitAge > 1825) {\n overdueUnits.push({\n propName: p.name,\n detectorLabel: d.label,\n ageDays: unitAge,\n });\n }\n }\n }\n\n const today = new Date().toLocaleDateString(\"en-US\", {\n month: \"long\",\n day: \"numeric\",\n year: \"numeric\",\n });\n const anyOverdue = overdueInspections.length + overdueTests.length +\n overdueBatteries.length + overdueUnits.length;\n\n if (anyOverdue === 0) {\n // All-clear post — keeps the team aware the system is running\n await fetch(SLACK_WEBHOOK, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n text: `🟢 *Safety Inspections — Monthly Check (${today})*`,\n blocks: [\n {\n type: \"header\",\n text: {\n type: \"plain_text\",\n text: `🟢 Safety Inspections — Monthly Check`,\n },\n },\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text:\n `All ${PROPERTIES.length} properties are current on their 6-month inspection schedule, and all smoke/CO detectors are tested and within their replacement cadence. ✅`,\n },\n },\n {\n type: \"context\",\n elements: [{ type: \"mrkdwn\", text: `Checked ${today}` }],\n },\n ],\n }),\n });\n return;\n }\n\n // Helper to format age strings\n const ageStr = (days: number | null, missingLabel: string): string => {\n if (days === null) return missingLabel;\n if (days < 30) return `${days}d ago`;\n if (days < 365) return `${Math.floor(days / 30)}mo ago`;\n return `${Math.floor(days / 365)}y ago`;\n };\n\n // Build Slack blocks — one combined post with up to four sections\n const blocks: any[] = [\n {\n type: \"header\",\n text: { type: \"plain_text\", text: `🔴 Safety Monthly Check — ${today}` },\n },\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `Items needing attention across the portfolio:`,\n },\n },\n ];\n\n // Section 1: Safety inspections overdue\n if (overdueInspections.length > 0) {\n blocks.push({ type: \"divider\" });\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text:\n `*🛡️ Safety Inspections Overdue (6-month cadence) — ${overdueInspections.length}*`,\n },\n });\n const lines = overdueInspections.map((s, i) =>\n `${i + 1}. *${s.name}* — ${s.status}${\n s.currentDone > 0\n ? ` _(in progress: ${s.currentDone}/${s.currentTotal})_`\n : \"\"\n }`\n );\n const chunkSize = 15;\n for (let i = 0; i < lines.length; i += chunkSize) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: lines.slice(i, i + chunkSize).join(\"\\n\"),\n },\n });\n }\n }\n\n // Section 2: Detector tests overdue (group by property for readability)\n if (overdueTests.length > 0) {\n blocks.push({ type: \"divider\" });\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `*🚨 Detector Tests Overdue (monthly) — ${overdueTests.length}*`,\n },\n });\n const byProp: Record = {};\n for (const t of overdueTests) {\n if (!byProp[t.propName]) byProp[t.propName] = [];\n byProp[t.propName].push(\n `${t.detectorLabel} (${ageStr(t.ageDays, \"never tested\")})`,\n );\n }\n const lines = Object.entries(byProp).map(([prop, dets]) =>\n `• *${prop}* — ${dets.length} detector${dets.length > 1 ? \"s\" : \"\"}: ${\n dets.join(\", \")\n }`\n );\n const chunkSize = 10;\n for (let i = 0; i < lines.length; i += chunkSize) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: lines.slice(i, i + chunkSize).join(\"\\n\"),\n },\n });\n }\n }\n\n // Section 3: Batteries due for replacement\n if (overdueBatteries.length > 0) {\n blocks.push({ type: \"divider\" });\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text:\n `*🔋 Batteries Due for Replacement (annual / 10-yr lithium-ion) — ${overdueBatteries.length}*`,\n },\n });\n const byProp: Record = {};\n for (const t of overdueBatteries) {\n if (!byProp[t.propName]) byProp[t.propName] = [];\n byProp[t.propName].push(\n `${t.detectorLabel} (${ageStr(t.ageDays, \"no record\")})`,\n );\n }\n const lines = Object.entries(byProp).map(([prop, dets]) =>\n `• *${prop}* — ${dets.length} detector${dets.length > 1 ? \"s\" : \"\"}: ${\n dets.join(\", \")\n }`\n );\n const chunkSize = 10;\n for (let i = 0; i < lines.length; i += chunkSize) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: lines.slice(i, i + chunkSize).join(\"\\n\"),\n },\n });\n }\n }\n\n // Section 4: Detector units due for replacement\n if (overdueUnits.length > 0) {\n blocks.push({ type: \"divider\" });\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text:\n `*🔄 Detector Units Due for Replacement (every 5 years) — ${overdueUnits.length}*`,\n },\n });\n const byProp: Record = {};\n for (const t of overdueUnits) {\n if (!byProp[t.propName]) byProp[t.propName] = [];\n byProp[t.propName].push(\n `${t.detectorLabel} (${ageStr(t.ageDays, \"no record\")})`,\n );\n }\n const lines = Object.entries(byProp).map(([prop, dets]) =>\n `• *${prop}* — ${dets.length} detector${dets.length > 1 ? \"s\" : \"\"}: ${\n dets.join(\", \")\n }`\n );\n const chunkSize = 10;\n for (let i = 0; i < lines.length; i += chunkSize) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: lines.slice(i, i + chunkSize).join(\"\\n\"),\n },\n });\n }\n }\n\n blocks.push({ type: \"divider\" });\n blocks.push({\n type: \"actions\",\n elements: [\n {\n type: \"button\",\n text: { type: \"plain_text\", text: \"🛠 Open Safety Checklist\" },\n url: CHECKLIST_URL,\n style: \"primary\",\n },\n ],\n });\n\n await fetch(SLACK_WEBHOOK, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n text: `🔴 Safety Monthly Check — ${anyOverdue} items need attention`,\n blocks,\n }),\n });\n\n console.log(\n `Monthly alert sent: ${overdueInspections.length} inspections, ${overdueTests.length} tests, ${overdueBatteries.length} batteries, ${overdueUnits.length} units`,\n );\n}","deleted","label",[111],"pulls",1,"forks","envVars",{"_135":51,"_137":51},"connections",{"_135":51,"_136":51},"count","unfilledCount","emptyCount",{"_20":110,"_13":111,"_112":113,"_114":-5,"_115":21,"_116":30,"_117":118,"_22":139,"_29":120,"_121":122,"_123":124,"_125":38,"_126":-5,"_140":141,"_87":142},["D",1779298559534],"children",[],[111],["D",1778937258398],{"_11":12,"_85":81},{"_11":12,"_79":-5,"_80":81,"_44":45,"_82":83,"_84":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_74":-5,"_75":-5,"_76":-5,"_77":14,"_78":12},"ctx",{"_67":-5,"_106":180,"_181":182,"_183":184,"_185":38,"_186":38,"_187":38,"_188":118,"_189":-5,"_190":-7,"_191":-7,"_192":51,"_193":38,"_194":38,"_195":-5,"_196":38,"_197":38,"_198":38,"_199":-5},"ENV",{"_151":152,"_153":154,"_155":26,"_156":157,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179},"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"]

Branches1

Branches
1