Where your leads come from, and what goes back

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_817":818,"_819":820},"routes/_app.x.$handle.$name",{"_98":97,"_32":43,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":47,"_122":123,"_124":25,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":47},"version",1270,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",true,"deletedHere","path","SOURCE-BUNDLE.part37.txt","latestPath","fileId","3b739f62-9823-11f1-be16-1607ee4eb77e","name","fileType","content","THE DOGS SPOT — SOURCE BUNDLE (part 37 of 47)\n\nEVERY source file in this project, engine/ included. Restoring these parts and nothing else gives\nyou a tree that builds, typechecks and runs its own test suite with no network and no val.\n\nengine/ is here as of 14 Aug 2026. It used to be left out because val 1bfa6e81-74e1-4c6c-ab32-118304a4ffff\nholds it, which was true of every engine file except engine/watch.ts: a module the val does not run,\nso it was never deployed, so it lived in one container and nothing else. A reclaim destroyed it.\nscripts/deploy.mjs --check still compares engine/ against the val file by file; that is a second\ncheck on the same files now, not the only copy of them.\n\nRESTORE (needs only node, from an empty folder). Save each part, then run this ON EACH ONE:\n\n node -e 'const fs=require(\"fs\"),p=require(\"path\");const b=fs.readFileSync(process.argv[1],\"utf8\");\n for(const s of b.split(\"\\n=====FILE \").slice(1)){const i=s.indexOf(\" =====\\n\");\n const f=s.slice(0,i),c=s.slice(i+7);fs.mkdirSync(p.dirname(f),{recursive:true});\n fs.writeFileSync(f,c.replace(/\\n$/,\"\"))}' PART.txt\n\nA record named #1, #2, ... is one FILE cut into pieces: concatenate them in order, then\nstrip one trailing newline from the last. scripts/restore.mjs does this for you.\n\nEach part is complete in itself: whole files only, no reassembly, any order.\n\nThen: node scripts/build.mjs (engine/ came out of these parts; nothing to fetch first)\n node scripts/typecheck.mjs\n node tests/run-all.mjs\n node scripts/deploy.mjs --check (pulls nothing, proves the val matches what you restored)\n node tests/negative-controls.mjs (proves the suite above can actually fail)\n\nIN THIS PART (8 of 129 files)\n scripts/exception-report.mjs 29815 bytes 89c482ec4752\n scripts/make-pdfs.mjs 3426 bytes a0bd60e73eb3\n scripts/make-status-pdf.py 5325 bytes f9e2a1c9b495\n scripts/make_pdf.py 5467 bytes e04360bb178c\n scripts/occupancy-evidence.py 6560 bytes 12d3c046affa\n scripts/restore.mjs 11672 bytes 1f2ef1369633\n scripts/transcript_census_wide.py 9146 bytes 09fd4dbd4d57\n scripts/typecheck.mjs 2737 bytes ada69b4e39fb\n\n================================================================================================\n=====FILE scripts/exception-report.mjs =====\n#!/usr/bin/env node\n// THE WEEKLY SQUARE EXCEPTION REPORT. Generator, 11 Aug 2026.\n//\n// WHAT THIS IS. Promised to Kim in writing (handover/REPLY-TO-KIM-11-AUG.txt, \"I want to add a\n// short weekly list of any Square sale that did not reach a customer record\"). Every run reads the\n// Square-to-GoHighLevel bridge's own journal, asks the bridge which payments never reached a\n// contact using the SAME rule the client was already told about, and writes a CSV plus a short\n// summary. Nothing here is scheduled and nothing here writes to a live system: two GETs to the\n// bridge (the journal dump and the Square detail lookup), both read only, and two local files out.\n//\n// WHY IT DOES NOT HAND-COPY THE MATCHING RULE. The rule that decides \"unmatched\" is\n// engine/facts.ts squareBacklog(). Copying its logic into a second file is exactly how Kim ended up\n// with a wrong number in writing once already: on 9 Aug she was told 42 payments / $33,535.99, a\n// figure that only ever read the FIRST attempt at each payment, when the true count, reading every\n// attempt, is 33 / $22,651.99 (engine/facts.ts:64-69). $10,884.00 of backlog that had already\n// cleared was still being reported as owed. So this script imports the real, current\n// squareBacklog() (via build/facts.js, transpiled fresh from engine/facts.ts on every run, never a\n// stale copy) for the numbers Kim sees, and only re-derives the per-payment LIST locally, because\n// squareBacklog() itself returns totals, not rows. That second derivation is then reconciled\n// against the imported function's totals below and the run refuses to ship if they disagree by so\n// much as a cent or a row (see reconcileOrDie). LESSONS.md #8 asks for exactly this standing check\n// once this report exists: \"reconcile any subset against its parent total before it leaves the\n// building.\" This is that check.\n//\n// WHAT COUNTS AS THE WEEKLY LIST. \"Weekly\" describes the CADENCE this is meant to run on, not a\n// seven day filter on the journal. The list is the entire current backlog, same as the number Kim\n// was quoted, because a payment that missed its match three weeks ago and still has not been fixed\n// is exactly the kind of thing that must not \"age out\" of a list whose whole purpose is that\n// nothing sits unnoticed. LESSONS.md #8 is the same lesson from the other direction: a filter\n// boundary that quietly became \"the\" result understated the backlog to 29 / $19,822 once already.\n// No date filtering happens anywhere in this file.\n//\n// USAGE\n// node scripts/exception-report.mjs\n// ENV OVERRIDES\n// BRIDGE_URL default: read from engine/dashboard.ts\n// BRIDGE_ADMIN required for live mode; never stored in source\n// EXCEPTION_REPORT_OUT_DIR default: /mnt/user-data/outputs\n// EXCEPTION_REPORT_DATE default: today, formatted D-Mon e.g. \"11-Aug\"\n// EXCEPTION_REPORT_JOURNAL_FILE offline mode: read journal JSON from this local file, skip the\n// network fetch entirely (used by tests/manual debugging only)\n\nimport { spawnSync } from \"node:child_process\";\nimport { readFileSync, writeFileSync, mkdirSync, existsSync } from \"node:fs\";\nimport { join, dirname, resolve } from \"node:path\";\nimport { fileURLToPath } from \"node:url\";\n\nconst HERE = dirname(fileURLToPath(import.meta.url));\nconst ROOT = resolve(HERE, \"..\"); // /home/claude/restore\n\nfunction shout(msg) {\n console.error(`\\n!!!! ${msg} !!!!\\n`);\n}\nfunction die(msg) {\n shout(msg);\n process.exit(1);\n}\n\n// -------------------------------------------------------------------------------------------\n// STEP 0. Rebuild engine/ -> build/, always, before importing anything from it. Copied straight\n// from tests/run-all.mjs's own \"REBUILD FIRST, ALWAYS\" — the incident that rule guards against\n// (6 Aug: real logic deleted from an engine file, suite run without rebuilding, 270 assertions\n// \"passed\" against stale code) is exactly the failure mode a report script must not repeat, because\n// nobody reviews this output as carefully as a red test suite.\n// -------------------------------------------------------------------------------------------\n{\n const b = spawnSync(\"node\", [join(ROOT, \"scripts\", \"build.mjs\")], { encoding: \"utf8\", timeout: 300_000 });\n if (b.status !== 0) {\n die(`BUILD FAILED. Refusing to generate a report against logic that will not even compile.\\n${(b.stdout ?? \"\") + (b.stderr ?? \"\")}`.trim());\n }\n}\n\nconst { squareBacklog, squareSentence } = await import(join(ROOT, \"build\", \"facts.js\"));\nconst { unmatchedPaymentRows, reconcile, cents, paymentUniverse, journalAmount } = await import(join(ROOT, \"scripts\", \"exception-report-lib.mjs\"));\n\n// -------------------------------------------------------------------------------------------\n// STEP 1. Credentials. Secrets are environment-only because the deployed source is public.\n// -------------------------------------------------------------------------------------------\nconst DASHBOARD_TS = process.env.DASHBOARD_TS_PATH || join(ROOT, \"engine\", \"dashboard.ts\");\nif (!existsSync(DASHBOARD_TS)) die(`cannot find ${DASHBOARD_TS}. Restore it before running this report.`);\nconst dashboardSrc = readFileSync(DASHBOARD_TS, \"utf8\");\n\nfunction readConstFrom(text, name) {\n const m = new RegExp(`const\\\\s+${name}\\\\s*=\\\\s*\"([^\"]+)\"`).exec(text);\n return m ? m[1] : null;\n}\n\nconst admin = process.env.BRIDGE_ADMIN || \"\";\nif (admin.length < 24) {\n die(\"BRIDGE_ADMIN is missing or too short. Set the rotated credential in the environment; source fallbacks are forbidden.\");\n}\n\nconst BRIDGE = process.env.BRIDGE_URL || readConstFrom(dashboardSrc, \"BRIDGE\");\nif (!BRIDGE) die(`could not find a BRIDGE literal in ${DASHBOARD_TS}`);\n\n// -------------------------------------------------------------------------------------------\n// STEP 2. Fetch the journal. READ ONLY: a GET on ?dump=1. Zero rows inspected is a hard failure,\n// never an empty success (LESSONS.md #2) — it almost certainly means the fetch broke, not that\n// nothing happened.\n// -------------------------------------------------------------------------------------------\nlet journal;\nconst journalFileOverride = process.env.EXCEPTION_REPORT_JOURNAL_FILE;\nif (journalFileOverride) {\n console.log(`offline mode: reading journal from ${journalFileOverride} instead of the network`);\n journal = JSON.parse(readFileSync(journalFileOverride, \"utf8\"));\n} else {\n const dumpUrl = `${BRIDGE}?dump=1&admin=${encodeURIComponent(admin)}`;\n let res;\n try {\n res = await fetch(dumpUrl);\n } catch (e) {\n die(`journal fetch threw: ${e.message}`);\n }\n if (!res.ok) die(`journal fetch failed: HTTP ${res.status} from ${BRIDGE}?dump=1`);\n journal = await res.json();\n}\n\nif (!Array.isArray(journal)) die(`journal did not come back as an array (got ${typeof journal}). Cannot inspect anything.`);\nif (journal.length === 0) die(`journal came back with ZERO rows. A report that inspects zero rows is a FAILURE, not an empty success. Not writing anything.`);\n\nconst journalTimestamps = journal.map((r) => r?.ts).filter(Boolean).sort();\nconst spanStart = journalTimestamps[0] ?? \"unknown\";\nconst spanEnd = journalTimestamps[journalTimestamps.length - 1] ?? \"unknown\";\nconsole.log(`Inspected ${journal.length} journal rows, spanning ${spanStart} to ${spanEnd}.`);\nif (journal.length < 100) {\n shout(`only ${journal.length} journal rows read; the brief describes roughly 780. This is not a hard failure (the journal legitimately grows or could be pruned) but it is worth a human's eyes before this ships.`);\n}\n\n// -------------------------------------------------------------------------------------------\n// STEP 3. THE NUMBERS KIM SEES: the real, current squareBacklog(), imported, not retyped.\n// -------------------------------------------------------------------------------------------\nconst backlog = squareBacklog(journal);\nif (!backlog) die(\"squareBacklog(journal) returned null even though the journal is a non-empty array. The reconciliation logic itself has changed shape; stop and look before shipping anything.\");\n\n// -------------------------------------------------------------------------------------------\n// STEP 4. THE LIST: a second, independent derivation of the same rule, so this report can name\n// individual payments (squareBacklog() only returns aggregates). unmatchedPaymentRows(), imported\n// from exception-report-lib.mjs above, mirrors engine/facts.ts squareBacklog() lines 72-98 and\n// carries the same MATCHED-LATER GUARD that closes the $10,884 / 9 payment hole documented there\n// and in tests/exception-report.test.mjs.\n// -------------------------------------------------------------------------------------------\nconst rows = unmatchedPaymentRows(journal);\n\n// -------------------------------------------------------------------------------------------\n// STEP 5. RECONCILE OR DIE. The list built above must add up to exactly what the real\n// squareBacklog() says, in count and in every dollar (reconcile(), same lib import). If it does\n// not, something has drifted between the two derivations and this script refuses to ship a number\n// Kim cannot trust. LESSONS.md #8's standing check — a subset plus its remainder equals the\n// parent total — is inside reconcile() too.\n// -------------------------------------------------------------------------------------------\nfunction reconcileOrDie(rows, backlog) {\n const r = reconcile(rows, backlog);\n if (!r.ok) {\n shout(\"RECONCILIATION FAILED. This report does NOT match engine/facts.ts squareBacklog(). Nothing was written.\");\n for (const p of r.problems) console.error(` - ${p}`);\n process.exit(1);\n }\n console.log(`Reconciled: ${rows.length} payments / $${r.listTotal.toFixed(2)} matches squareBacklog() exactly ` +\n `(${backlog.withTrail} with a trail worth $${backlog.withTrailTotal.toFixed(2)}, ${backlog.noTrail} with none worth $${backlog.noTrailTotal.toFixed(2)}).`);\n return r;\n}\n\nreconcileOrDie(rows, backlog);\n\n// -------------------------------------------------------------------------------------------\n// STEP 6. ENRICH each unmatched payment with Square's own detail via the bridge's read only\n// lookup route (?lookup=, capped at 90 ids per call by the bridge itself; chunked here so this\n// still works the week the backlog exceeds that). A lookup failure downgrades that row rather\n// than aborting the run: the count and total already reconciled above and are the part Kim\n// actually needs not to miss.\n// -------------------------------------------------------------------------------------------\nasync function lookupSquareDetails(ids) {\n const out = new Map();\n const failures = [];\n const CHUNK = 90;\n for (let i = 0; i < ids.length; i += CHUNK) {\n const chunk = ids.slice(i, i + CHUNK);\n const url = `${BRIDGE}?lookup=${chunk.map(encodeURIComponent).join(\",\")}&admin=${encodeURIComponent(admin)}`;\n let res;\n try {\n res = await fetch(url);\n } catch (e) {\n shout(`Square lookup request threw for ${chunk.length} payment(s): ${e.message}`);\n failures.push(...chunk);\n continue;\n }\n if (!res.ok) {\n shout(`Square lookup HTTP ${res.status} for ${chunk.length} payment(s). Those rows will ship without Square detail.`);\n failures.push(...chunk);\n continue;\n }\n const body = await res.json();\n for (const r of body.results ?? []) out.set(r.id, r);\n for (const id of chunk) if (!out.has(id)) failures.push(id);\n }\n return { out, failures };\n}\n\n// THE PARENT TOTAL. [Added 12 Aug 2026.] LESSONS.md #8 says a subset may not leave the building\n// without the population it came out of, and until now this report had none: \"33 unlinked\" was\n// quoted against nothing, which is how three wrong versions of it in a row all looked plausible.\n// paymentUniverse() is the same id parser this file already trusts for the subset, applied to\n// every payment the bridge has ever logged, so the two cannot drift.\n//\n// Every payment is looked up in Square, not just the unmatched ones, because the journal does not\n// always carry an amount: PAY-DUP rows have no amount field at all, and five payments worth\n// $1,410.00 live are reachable only through those rows. A parent total summed from the journal\n// alone would understate the population by that much and the subset would look larger than it is.\nconst universe = paymentUniverse(journal);\nconst { out: lookups, failures: lookupFailures } = await lookupSquareDetails([...universe.payments.keys()].sort());\nconsole.log(`Square lookup: ${universe.payments.size - lookupFailures.length} of ${universe.payments.size} payments enriched` +\n (lookupFailures.length ? `, ${lookupFailures.length} FAILED (${lookupFailures.join(\", \")}).` : \".\"));\n\nconst amountOf = (id) => {\n const s = Number(lookups.get(id)?.amount);\n return Number.isFinite(s) ? s : journalAmount(universe.payments.get(id));\n};\nconst universeTotal = [...universe.payments.keys()].reduce((a, id) => a + amountOf(id), 0);\nconst linkedTotal = universe.linked.reduce((a, id) => a + amountOf(id), 0);\nconst unlinkedTotal = universe.unlinked.reduce((a, id) => a + amountOf(id), 0);\n{\n const p = [];\n if (universe.linked.length + universe.unlinked.length !== universe.payments.size) p.push(`linked ${universe.linked.length} + unlinked ${universe.unlinked.length} does not equal the ${universe.payments.size} payments seen`);\n if (cents(linkedTotal + unlinkedTotal) !== cents(universeTotal)) p.push(`linked $${linkedTotal.toFixed(2)} + unlinked $${unlinkedTotal.toFixed(2)} does not equal $${universeTotal.toFixed(2)}`);\n if (universe.unlinked.length !== backlog.payments) p.push(`paymentUniverse() says ${universe.unlinked.length} unlinked, squareBacklog() says ${backlog.payments}`);\n if (cents(unlinkedTotal) !== cents(backlog.total)) p.push(`the unlinked total from Square is $${unlinkedTotal.toFixed(2)} and squareBacklog() says $${backlog.total.toFixed(2)}`);\n if (p.length) {\n shout(\"THE SUBSET DOES NOT RECONCILE AGAINST ITS POPULATION. Nothing was written.\");\n for (const x of p) console.error(` - ${x}`);\n process.exit(1);\n }\n console.log(`Population: ${universe.payments.size} payments $${universeTotal.toFixed(2)} = ${universe.linked.length} linked $${linkedTotal.toFixed(2)} + ${universe.unlinked.length} unlinked $${unlinkedTotal.toFixed(2)}.`);\n}\n\n// Per-payment lookup errors (Square answered the batch but not this one id, e.g. a 404 on that\n// payment) versus payments never asked about are both surfaced the same way in the CSV.\nlet amountMismatches = 0;\nconst enriched = rows.map((row) => {\n const sq = lookups.get(row.paymentId) ?? null;\n const lookupStatus = !sq ? \"not looked up\" : sq.error ? `Square error ${sq.error}` : \"ok\";\n const cust = sq?.square_customer ?? null;\n // Square's own customer records carry stray whitespace on some names (e.g. \"Jonathan \" /\n // \"Jameson \" with trailing spaces baked in) — collapse runs of whitespace rather than pass a\n // double-spaced name through to a client-facing document.\n const name = [cust?.given_name, cust?.family_name].map((s) => (s ?? \"\").trim()).filter(Boolean).join(\" \").replace(/\\s+/g, \" \").trim()\n || (sq?.cardholder_name ?? \"\").trim()\n || null;\n if (sq?.amount != null && cents(sq.amount) !== cents(row.amount)) {\n amountMismatches++;\n shout(`payment ${row.paymentId}: journal amount $${row.amount.toFixed(2)} does not match Square's own amount $${Number(sq.amount).toFixed(2)}. Row is included with the journal figure (the reconciled one); check this one by hand.`);\n }\n const lineItems = (sq?.line_items ?? [])\n .map((li) => `${li?.name ?? \"item not named\"} x${li?.quantity ?? \"?\"}`)\n .join(\"; \");\n // WHAT SQUARE ACTUALLY HOLDS, which is a different question from row.hasTrail.\n // hasTrail is built from hadEmail/hadPhone/hadCustomerId, and those describe the WEBHOOK PAYLOAD\n // the bridge received, not Square's customer record. Live on 12 Aug 2026 they are backwards for\n // two of the four: the payment the flags call unrecoverable is Caroline Riner and Square holds\n // her name and her phone number, while the payment the flags call recoverable carries a Square\n // customer id whose record is empty. This report is what Kim uses to decide which sales are\n // worth chasing, so the column she reads is derived from Square. row.hasTrail is left untouched\n // because reconcile() checks it against squareBacklog()'s own withTrail/noTrail split.\n const holds = [];\n if (name) holds.push(\"a name\");\n if (cust?.phone_number) holds.push(\"a phone number\");\n if (cust?.email_address) holds.push(\"an email address\");\n const whatSquareHolds = holds.length ? holds.join(\", \").replace(/, ([^,]*)$/, \" and $1\") : \"nothing at all\";\n const flagDisagrees = row.hasTrail !== (holds.length > 0);\n return {\n ...row,\n lookupStatus,\n whatSquareHolds,\n squareCanIdentifyThem: holds.length > 0,\n flagDisagrees,\n squareCreatedAt: sq?.created_at ?? null,\n customerName: name,\n customerEmail: cust?.email_address ?? null,\n customerPhone: cust?.phone_number ?? null,\n cardBrand: sq?.card_brand ?? null,\n cardLast4: sq?.last_4 ?? null,\n paymentStatus: sq?.status ?? null,\n lineItems,\n receiptUrl: sq?.receipt_url ?? null,\n receiptNumber: sq?.receipt_number ?? null,\n orderId: sq?.order_id ?? null,\n squareCustomerId: sq?.customer_id ?? cust?.reference_id ?? null,\n };\n});\nif (amountMismatches) shout(`${amountMismatches} payment(s) have a journal amount that disagrees with Square's own amount. See warnings above.`);\n\n// -------------------------------------------------------------------------------------------\n// THE ORDER A FILE CLAIMS IS THE SOURCE'S ORDER, NEVER OURS.\n//\n// unmatchedPaymentRows() returns its rows sorted by the FIRST TIME OUR OWN JOURNAL SAW each\n// payment, which is the right order for a log and the wrong order for a sentence that says \"in\n// the order the payments arrived\". Live proof, 27 July 2026: Square took $1,000.00 at 17:07:42\n// and $795.00 at 17:07:57, and our journal noticed the $795.00 first. This report printed\n// $795.00 above $1,000.00 and told the reader that was the order they arrived in. Fifteen seconds\n// is harmless; the habit is not, because the same claim is made about lists where the order is\n// the whole point. So the list is re-sorted here by Square's own timestamp, falling back to ours\n// only when Square has nothing to say, and the fallback is counted so the sentence below can say\n// which order it is actually in.\nlet orderedBySquare = true;\nfor (const r of enriched) if (!r.squareCreatedAt) orderedBySquare = false;\nenriched.sort((a, b) =>\n String(a.squareCreatedAt ?? a.firstSeen ?? \"\").localeCompare(String(b.squareCreatedAt ?? b.firstSeen ?? \"\")));\n{\n const p = [];\n for (let i = 1; i < enriched.length; i++) {\n const x = String(enriched[i - 1].squareCreatedAt ?? enriched[i - 1].firstSeen ?? \"\");\n const y = String(enriched[i].squareCreatedAt ?? enriched[i].firstSeen ?? \"\");\n if (x > y) p.push(`rows ${i} and ${i + 1} are out of order`);\n }\n if (p.length) { shout(\"THE LIST IS NOT IN THE ORDER IT CLAIMS. Nothing written.\"); p.forEach((x) => console.error(\" - \" + x)); process.exit(1); }\n console.log(`Order check passed: ${enriched.length} rows, oldest first, by ${orderedBySquare ? \"Square's own timestamp\" : \"Square's own timestamp where it has one and ours where it does not\"}.`);\n}\n\nconst namedCount = enriched.filter((r) => r.customerName).length;\nconsole.log(`Of the ${enriched.length}, ${namedCount} came back from Square with a customer name on file.`);\n\n// -------------------------------------------------------------------------------------------\n// STEP 7. WRITE THE CSV. Plain numbers, no currency symbols or thousands separators, so it opens\n// cleanly as data rather than as text. One row per distinct unmatched payment, oldest first.\n// -------------------------------------------------------------------------------------------\nfunction csvField(v) {\n const s = v === null || v === undefined ? \"\" : String(v);\n return /[\",\\n]/.test(s) ? `\"${s.replace(/\"/g, '\"\"')}\"` : s;\n}\nfunction toCsv(headers, records) {\n const lines = [headers.map(csvField).join(\",\")];\n for (const rec of records) lines.push(headers.map((h) => csvField(rec[h])).join(\",\"));\n return lines.join(\"\\n\") + \"\\n\";\n}\n\nconst CSV_HEADERS = [\n \"payment_id\", \"journal_first_seen\", \"journal_last_seen\", \"journal_row_count\",\n \"amount_usd\", \"what_square_holds\", \"square_can_identify_them\",\n // These three describe the webhook payload the bridge received, NOT Square's records, and they\n // are named so nobody reads them as an answer to \"can this sale be placed\". See the comment on\n // whatSquareHolds above: live, they get it backwards for half this list.\n \"journal_flag_called_it_recoverable\", \"had_email_at_ingest\", \"had_phone_at_ingest\", \"had_square_customer_id_at_ingest\",\n \"square_created_at\", \"customer_name\", \"customer_email\", \"customer_phone\",\n \"card_brand\", \"card_last4\", \"payment_status\", \"line_items\",\n \"receipt_url\", \"receipt_number\", \"order_id\", \"square_customer_id\", \"square_lookup_status\",\n];\nconst csvRecords = enriched.map((r) => ({\n payment_id: r.paymentId,\n journal_first_seen: r.firstSeen,\n journal_last_seen: r.lastSeen,\n journal_row_count: r.journalRowCount,\n amount_usd: r.amount.toFixed(2),\n what_square_holds: r.whatSquareHolds,\n square_can_identify_them: r.squareCanIdentifyThem ? \"yes\" : \"no\",\n journal_flag_called_it_recoverable: r.hasTrail ? \"yes\" : \"no\",\n had_email_at_ingest: r.hadEmailAtIngest ? \"yes\" : \"no\",\n had_phone_at_ingest: r.hadPhoneAtIngest ? \"yes\" : \"no\",\n had_square_customer_id_at_ingest: r.hadCustomerIdAtIngest ? \"yes\" : \"no\",\n square_created_at: r.squareCreatedAt,\n customer_name: r.customerName ?? \"(no name on file)\",\n customer_email: r.customerEmail ?? \"\",\n customer_phone: r.customerPhone ?? \"\",\n card_brand: r.cardBrand ?? \"\",\n card_last4: r.cardLast4 ?? \"\",\n payment_status: r.paymentStatus ?? \"\",\n line_items: r.lineItems || \"\",\n receipt_url: r.receiptUrl ?? \"\",\n receipt_number: r.receiptNumber ?? \"\",\n order_id: r.orderId ?? \"\",\n square_customer_id: r.squareCustomerId ?? \"\",\n square_lookup_status: r.lookupStatus,\n}));\nconst csv = toCsv(CSV_HEADERS, csvRecords);\n\n// -------------------------------------------------------------------------------------------\n// STEP 8. WRITE THE SUMMARY. Client safe: US spelling, no dashes as punctuation (hyphens inside a\n// literal product name or a phone number are the only exception, per HANDOFF.md section 10's\n// voice rule), and the word \"daycare\" never appears (she does not offer it; HANDOFF.md section 6\n// and 10 both call this a factual error, not a preference). Both rules are self checked below and\n// the run fails loudly rather than ship copy that breaks either one.\n// -------------------------------------------------------------------------------------------\nconst money = (n) => `$${n.toLocaleString(\"en-US\", { minimumFractionDigits: 2, maximumFractionDigits: 2 })}`;\n\nfunction fmtDate(iso) {\n if (!iso) return \"date unknown\";\n const d = new Date(iso);\n if (Number.isNaN(d.getTime())) return \"date unknown\";\n const months = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\n return `${d.getUTCDate()} ${months[d.getUTCMonth()]}`;\n}\n\nconst now = new Date();\nconst dateSuffix = process.env.EXCEPTION_REPORT_DATE ||\n `${now.getUTCDate()}-${[\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"][now.getUTCMonth()]}`;\n\n// The last column USED to be \"Recoverable\", read straight off r.hasTrail. That column told Kim\n// that Caroline Riner, whose name and phone number are sitting in Square, could not be placed,\n// and that a sale with no name, no email and no phone anywhere could be. It is derived from\n// Square now. See the whatSquareHolds comment in STEP 6.\nconst mdRows = enriched.map((r) => {\n const contact = r.customerEmail || r.customerPhone || \"none on file\";\n return `| ${fmtDate(r.squareCreatedAt || r.firstSeen)} | ${money(r.amount)} | ${r.customerName ?? \"(no name on file)\"} | ${contact} | ${r.whatSquareHolds} |`;\n});\nconst flagsWrong = enriched.filter((r) => r.flagDisagrees);\n\nconst explainer = squareSentence(backlog); // generated straight from the reconciled numbers above\n\nconst mdParts = [];\nmdParts.push(`# Weekly Square exception report, ${dateSuffix}`);\nmdParts.push(\"\");\nmdParts.push(\"Hi Kim,\");\nmdParts.push(\"\");\nmdParts.push(`This is the short weekly list I promised: every Square sale that has not reached a customer record in your CRM. This run read all ${journal.length} rows in the bridge's payment journal, covering ${fmtDate(spanStart)} to ${fmtDate(spanEnd)}, and asked Square directly for the receipt behind each of the ${backlog.payments} unmatched payments it found.`);\nmdParts.push(\"\");\nmdParts.push(explainer);\nmdParts.push(\"\");\nif (backlog.payments > 0) {\n mdParts.push(`Square could put a name to ${namedCount} of the ${backlog.payments}. The full list, oldest first, in the order Square itself took the money${orderedBySquare ? \"\" : \", except where Square has no time recorded and our own is used instead\"}:`);\n mdParts.push(\"\");\n mdParts.push(\"| Date | Amount | Customer | Contact | What Square holds for them |\");\n mdParts.push(\"|---|---|---|---|---|\");\n mdParts.push(...mdRows);\n mdParts.push(\"\");\n mdParts.push(`That last column comes from Square's own customer records, asked just now, one call per payment. An earlier version of this list built it from a flag the card reader sets at the moment of sale, and that flag turns out to describe the message the till sent rather than what Square keeps, so it was wrong about ${flagsWrong.length} of these ${backlog.payments}.`);\n mdParts.push(\"\");\n mdParts.push(`Card details, the Square receipt link and what was rung up for every row are in the attached CSV, ${`exception-report-${dateSuffix}.csv`}.`);\n} else {\n mdParts.push(\"Nothing to list this week. Every Square payment reached a customer record.\");\n}\nmdParts.push(\"\");\nmdParts.push(`Here is the whole population those ${backlog.payments} came out of, so the figure can be checked against something rather than quoted on its own. The bridge has handled ${universe.payments.size} card sales worth ${money(universeTotal)} since it was switched on. ${universe.linked.length} of them worth ${money(linkedTotal)} reached a customer record, and ${universe.unlinked.length} worth ${money(unlinkedTotal)} did not. Those two add back to ${money(universeTotal)} exactly, and the ${money(unlinkedTotal)} is the same figure your CRM engine's own reconciliation logic produces, computed separately and checked against this list row by row.`);\nmdParts.push(\"\");\nmdParts.push(\"Amir\");\nconst md = mdParts.join(\"\\n\") + \"\\n\";\n\n// SELF CHECK: the two client facing rules, enforced mechanically rather than trusted by eye.\n{\n const problems = [];\n if (/daycare/i.test(md)) problems.push('the word \"daycare\" appears in the summary');\n // Dash as punctuation: an em dash, an en dash, or a hyphen with a space on both sides. Table\n // pipes and the markdown header rule \"|---|\" are excluded; phone numbers (E.164, no spaces\n // around the hyphen) and the file's own hyphenated name are the documented exceptions and do\n // not match this pattern because they carry no surrounding space.\n const proseOnly = md.split(\"\\n\").filter((l) => !l.startsWith(\"|\")).join(\"\\n\");\n if (/—|–/.test(proseOnly)) problems.push(\"an em dash or en dash appears in the summary\");\n if (/\\s-\\s/.test(proseOnly)) problems.push('a hyphen is used as punctuation (surrounded by spaces) in the summary');\n if (problems.length) {\n shout(\"CLIENT-SAFE COPY CHECK FAILED. Not writing the summary.\");\n for (const p of problems) console.error(` - ${p}`);\n process.exit(1);\n }\n console.log(\"Client-safe copy check passed: no dashes as punctuation, no \\\"daycare\\\".\");\n}\n\n// -------------------------------------------------------------------------------------------\n// STEP 9. WRITE THE FILES.\n// -------------------------------------------------------------------------------------------\n// NOT A CLIENT FILE ANY MORE, 12 Aug 2026. This report and the counter sales pack were two\n// documents about the same four payments, sent together, and the second one pointed at a\n// companion CSV that was not even in the send. Duplicate documents about one thing are the exact\n// confusion the client was apologised to for. The internal weekly report stays, because the\n// reconciliation it runs against engine/facts.ts squareBacklog() is worth having; it writes to the\n// repo, and the file the client reads is Counter-sales-with-no-customer.csv, built by\n// scripts/counter-sales-correction.mjs in the same run as everything else she is sent.\nconst OUT_DIR = process.env.EXCEPTION_REPORT_OUT_DIR || join(ROOT, \"reports\");\nif (OUT_DIR === \"/mnt/user-data/outputs\") {\n shout(\"this report is internal and must not be written into the client's folder. Unset EXCEPTION_REPORT_OUT_DIR.\");\n process.exit(1);\n}\nmkdirSync(OUT_DIR, { recursive: true });\nconst csvPath = join(OUT_DIR, `exception-report-${dateSuffix}.csv`);\nconst mdPath = join(OUT_DIR, `exception-report-${dateSuffix}.md`);\nwriteFileSync(csvPath, csv);\nwriteFileSync(mdPath, md);\n\nconsole.log(\"\");\nconsole.log(`Wrote ${csvPath} (${csvRecords.length} data rows)`);\nconsole.log(`Wrote ${mdPath}`);\nconsole.log(\"\");\nconsole.log(`SUMMARY: ${backlog.payments} unmatched payments totaling ${money(backlog.total)} as of ${new Date().toISOString()}.`);\nconsole.log(` ${backlog.withTrail} with a trail worth ${money(backlog.withTrailTotal)}; ${backlog.noTrail} with none worth ${money(backlog.noTrailTotal)}.`);\nconsole.log(` Reconciled against engine/facts.ts squareBacklog() exactly. ${journal.length} journal rows inspected.`);\n\n\n=====FILE scripts/make-pdfs.mjs =====\n// REBUILD THE CLIENT PDFs, end to end, from the live message set.\n//\n// WHY THIS EXISTS. The container was reclaimed twice in two days. The second time, everything\n// restored from the bundle except `handover/TheDogsSpot-First3Weeks.pdf`, and the cross-artifact\n// suite went red because a live fact in the claims registry is that PDF's page count. Binaries are\n// not in the bundle and should not be: they are DERIVED, and a backup of a derived artifact is a\n// backup of the wrong thing.\n//\n// What was actually missing was this file. `scripts/make_pdf.py` reads `/tmp/msgs.json`, in a\n// shape it never documents — an object keyed by track, not the flat array you would naturally\n// write — and that shape lived only in my head. First attempt at regenerating after the reclaim\n// produced `'list' object has no attribute 'get'`.\n//\n// Run: node scripts/make-pdfs.mjs\nimport { writeFileSync, existsSync } from \"node:fs\";\nimport { spawnSync } from \"node:child_process\";\nimport { join, dirname, resolve } from \"node:path\";\nimport { fileURLToPath } from \"node:url\";\n\nconst ROOT = resolve(dirname(fileURLToPath(import.meta.url)), \"..\");\nconst TRACKS = [\"MAIN_SEQUENCE\", \"BRANCH_A\", \"BRANCH_B\", \"SLOW_WEEKLY\", \"SLOW_FORTNIGHTLY\", \"SLOW_MONTHLY_BANK\"];\n\nif (!existsSync(join(ROOT, \"build/engine.js\"))) {\n console.log(\"build/engine.js is missing. Run: node scripts/build.mjs\");\n process.exit(1);\n}\nconst E = await import(join(ROOT, \"build/engine.js\"));\n\n// THE SHAPE make_pdf.py EXPECTS: an object keyed by track name, each value an array of messages.\nconst byTrack = {};\nfor (const k of TRACKS) byTrack[k] = E[k] ?? [];\nconst total = Object.values(byTrack).reduce((a, v) => a + v.length, 0);\nif (!total) { console.log(\"no messages found in build/engine.js: refusing to build an empty PDF\"); process.exit(1); }\nwriteFileSync(\"/tmp/msgs.json\", JSON.stringify(byTrack));\nconsole.log(`${total} messages: ${Object.entries(byTrack).map(([k, v]) => `${k}=${v.length}`).join(\" \")}`);\n\n// The claims registry states these page counts as LIVE facts about the documents Kim was sent, so\n// a rebuild that changes them is a real change and the cross-artifact suite will say so.\nconst EXPECTED = { \"TheDogsSpot-First3Weeks.pdf\": 6, \"TheDogsSpot-AllMessages.pdf\": 14 };\n\nlet bad = 0;\nfor (const [arg, name] of [[\"short\", \"TheDogsSpot-First3Weeks.pdf\"], [null, \"TheDogsSpot-AllMessages.pdf\"]]) {\n const r = spawnSync(\"python3\", [join(ROOT, \"scripts/make_pdf.py\"), ...(arg ? [arg] : [])],\n { encoding: \"utf8\", cwd: ROOT });\n if (r.status !== 0) { console.log(`FAILED ${name}:\\n${(r.stdout + r.stderr).trim().slice(0, 500)}`); bad++; continue; }\n // Page count without a PDF library, the same way the claims registry counts them.\n const buf = (await import(\"node:fs\")).readFileSync(join(ROOT, \"handover\", name)).toString(\"latin1\");\n const pages = (buf.match(/\\/Type\\s*\\/Page[^s]/g) || []).length;\n const want = EXPECTED[name];\n const ok = pages === want;\n if (!ok) bad++;\n console.log(`${ok ? \"ok \" : \"PAGE COUNT CHANGED\"} ${name} ${pages} pages${ok ? \"\" : ` (the message Kim already has says ${want})`}`);\n}\nif (bad) {\n console.log(\"\\nA page count that has moved is not automatically wrong, but Kim was told a number.\");\n console.log(\"Either put the copy back, or update tests/claims-registry.mjs and say so in the next message.\");\n process.exit(1);\n}\nconsole.log(\"\\nboth PDFs rebuilt, page counts match what Kim was told\");\n\n\n\n=====FILE scripts/make-status-pdf.py =====\n\"\"\"Build the client-facing PDFs from a markdown-ish source.\n\nHouse style, matched to scripts/make_pdf.py so Kim's documents look like one family:\nHelvetica, sentence-case headings (never all-caps — she flagged that on 14 Aug), blue\nlabels, grey notes. Tables get thin grey rules and a light header row.\n\nSource format, one block per line-group:\n # Title -> H1 (once, first line)\n > subtitle -> SUB, the grey line under the title\n ## Heading -> H2\n | a | b | c | -> table row (consecutive rows become one table; first is the header)\n - text -> bullet\n ! text -> callout box (the things she must not miss)\n ~ text -> small grey note\n anything else -> body paragraph. **bold** works everywhere.\n\nRun: python3 scripts/make-status-pdf.py SOURCE.md OUT.pdf\n\"\"\"\nimport re, sys\nfrom reportlab.lib.pagesizes import LETTER\nfrom reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle\nfrom reportlab.lib.units import inch\nfrom reportlab.lib import colors\nfrom reportlab.lib.enums import TA_LEFT\nfrom reportlab.platypus import (SimpleDocTemplate, Paragraph, Spacer, HRFlowable,\n Table, TableStyle, KeepTogether)\n\nsrc, out = sys.argv[1], sys.argv[2]\nss = getSampleStyleSheet()\nINK, GREY, BLUE = colors.HexColor('#111111'), colors.HexColor('#5a5a5a'), colors.HexColor('#2a78d6')\nH1 = ParagraphStyle('H1', parent=ss['Title'], fontName='Helvetica-Bold', fontSize=19, leading=23,\n alignment=TA_LEFT, spaceAfter=3, textColor=INK)\nSUB = ParagraphStyle('SUB', parent=ss['Normal'], fontSize=10, leading=14, textColor=GREY, spaceAfter=13)\nH2 = ParagraphStyle('H2', parent=ss['Heading2'], fontName='Helvetica-Bold', fontSize=13, leading=16,\n spaceBefore=15, spaceAfter=5, textColor=INK)\nBODY = ParagraphStyle('BODY', parent=ss['Normal'], fontSize=10, leading=14.5, spaceAfter=6)\nBULL = ParagraphStyle('BULL', parent=BODY, leftIndent=14, bulletIndent=3, spaceAfter=3)\nNOTE = ParagraphStyle('NOTE', parent=ss['Normal'], fontSize=9, leading=12.5, textColor=GREY, spaceAfter=9)\nCELL = ParagraphStyle('CELL', parent=ss['Normal'], fontSize=9, leading=12)\nCELLB = ParagraphStyle('CELLB', parent=CELL, fontName='Helvetica-Bold')\nCALL = ParagraphStyle('CALL', parent=BODY, fontSize=10, leading=14.5, leftIndent=9, rightIndent=9,\n spaceBefore=3, spaceAfter=3)\n\nesc = lambda t: t.replace('&', '&').replace('<', '<').replace('>', '>')\nfmt = lambda t: re.sub(r'\\*\\*(.+?)\\*\\*', r'\\1', esc(t))\n\ndef table(rows):\n head, body = rows[0], rows[1:]\n data = [[Paragraph(fmt(c), CELLB) for c in head]] + \\\n [[Paragraph(fmt(c), CELL) for c in r] for r in body]\n n = len(head)\n w = {2: [2.5, 4.2], 3: [2.0, 1.5, 3.2], 4: [1.7, 1.2, 1.6, 2.2], 5: [1.5, 1.0, 1.2, 1.2, 1.8]}.get(n)\n t = Table(data, colWidths=[x * inch for x in w] if w else None, repeatRows=1, hAlign='LEFT')\n t.setStyle(TableStyle([\n ('BACKGROUND', (0, 0), (-1, 0), colors.HexColor('#f2f5f8')),\n ('LINEBELOW', (0, 0), (-1, 0), 0.7, colors.HexColor('#c8d2dc')),\n ('LINEBELOW', (0, 1), (-1, -2), 0.35, colors.HexColor('#e4e4e4')),\n ('VALIGN', (0, 0), (-1, -1), 'TOP'),\n ('LEFTPADDING', (0, 0), (-1, -1), 6), ('RIGHTPADDING', (0, 0), (-1, -1), 6),\n ('TOPPADDING', (0, 0), (-1, -1), 5), ('BOTTOMPADDING', (0, 0), (-1, -1), 5),\n ]))\n return t\n\nflow, pending, first = [], [], True\ndef flush():\n if pending:\n flow.append(table(pending)); flow.append(Spacer(1, 9)); pending.clear()\n\nfor raw in open(src, encoding='utf-8').read().split('\\n'):\n line = raw.rstrip()\n if line.startswith('|'):\n pending.append([c.strip() for c in line.strip('|').split('|')]); continue\n flush()\n if not line.strip():\n continue\n if line.startswith('# '):\n flow.append(Paragraph(fmt(line[2:]), H1)); first = False\n elif line.startswith('> '):\n flow.append(Paragraph(fmt(line[2:]), SUB))\n flow.append(HRFlowable(width=\"100%\", thickness=0.6, color=colors.HexColor('#dddddd'), spaceAfter=6))\n elif line.startswith('## '):\n flow.append(Paragraph(fmt(line[3:]), H2))\n elif line.startswith('- '):\n flow.append(Paragraph(fmt(line[2:]), BULL, bulletText='•'))\n elif line.startswith('! '):\n box = Table([[Paragraph(fmt(line[2:]), CALL)]], colWidths=[6.7 * inch], hAlign='LEFT')\n box.setStyle(TableStyle([\n ('BACKGROUND', (0, 0), (-1, -1), colors.HexColor('#fdf6e6')),\n ('LINEBEFORE', (0, 0), (0, -1), 2.2, colors.HexColor('#e0a63c')),\n ('LEFTPADDING', (0, 0), (-1, -1), 10), ('RIGHTPADDING', (0, 0), (-1, -1), 10),\n ('TOPPADDING', (0, 0), (-1, -1), 8), ('BOTTOMPADDING', (0, 0), (-1, -1), 8)]))\n flow.append(box); flow.append(Spacer(1, 9))\n elif line.startswith('~ '):\n flow.append(Paragraph(fmt(line[2:]), NOTE))\n else:\n flow.append(Paragraph(fmt(line), BODY))\nflush()\n\nSimpleDocTemplate(out, pagesize=LETTER, leftMargin=0.85 * inch, rightMargin=0.85 * inch,\n topMargin=0.8 * inch, bottomMargin=0.8 * inch,\n title=flow[0].text if flow else out, author='Amir Aizhigitov').build(flow)\n\nfrom pypdf import PdfReader\nprint(f\"ok {out} {len(PdfReader(out).pages)} pages\")\n\n\n=====FILE scripts/make_pdf.py =====\nimport json, re, sys\nfrom reportlab.lib.pagesizes import LETTER\nfrom reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle\nfrom reportlab.lib.units import inch\nfrom reportlab.lib import colors\nfrom reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, HRFlowable, KeepTogether\nfrom reportlab.lib.enums import TA_LEFT\n\nD = json.load(open('/tmp/msgs.json'))\nSHORT = len(sys.argv) > 1 and sys.argv[1] == \"short\"\nss = getSampleStyleSheet()\nH1 = ParagraphStyle('H1', parent=ss['Title'], fontName='Helvetica-Bold', fontSize=19, leading=23, alignment=TA_LEFT, spaceAfter=3, textColor=colors.HexColor('#111111'))\nSUB = ParagraphStyle('SUB', parent=ss['Normal'], fontSize=10, leading=14, textColor=colors.HexColor('#5a5a5a'), spaceAfter=13)\nH2 = ParagraphStyle('H2', parent=ss['Heading2'], fontName='Helvetica-Bold', fontSize=13, leading=16, spaceBefore=15, spaceAfter=5, textColor=colors.HexColor('#111111'))\nLBL = ParagraphStyle('LBL', parent=ss['Normal'], fontName='Helvetica-Bold', fontSize=9, leading=12, textColor=colors.HexColor('#2a78d6'), spaceAfter=1)\nSUBJ= ParagraphStyle('SUBJ', parent=ss['Normal'], fontName='Helvetica-Bold', fontSize=10.5, leading=14, spaceAfter=3)\nBODY= ParagraphStyle('BODY', parent=ss['Normal'], fontSize=10, leading=14.5, spaceAfter=6)\nNOTE= ParagraphStyle('NOTE', parent=ss['Normal'], fontSize=9, leading=12.5, textColor=colors.HexColor('#5a5a5a'), spaceAfter=9)\n\nesc = lambda t: t.replace('&','&').replace('<','<').replace('>','>')\ndef fmt(t):\n t = esc(t)\n t = re.sub(r'\\{\\{STORY:[^}]+\\}\\}\\s*', '', t)\n t = t.replace('{{FIRST_NAME}}', '[their name]')\n return re.sub(r'\\*\\*(.+?)\\*\\*', r'\\1', t)\nday = lambda m: round(m.get('offsetHours', 0) / 24)\n\nflow = [Paragraph(\"The Dogs Spot: the first three weeks\" if SHORT else \"The Dogs Spot: every follow-up message\", H1),\n Paragraph(\"Every word below was read out of the running system, not retyped from a draft, so what you read is exactly what would send. Everything you sent over is in it: the puppy-name placeholder is gone from every message, the American wording is fixed throughout, the service you do not offer is no longer mentioned anywhere, and both of the missed-Pup-Talk messages are now your rewrite rather than mine. The Touch numbers restart at 1 in each part below.\", SUB),\n HRFlowable(width=\"100%\", thickness=0.6, color=colors.HexColor('#dddddd'), spaceAfter=4)]\n\nSEC = [(\"The first 21 days\",\"MAIN_SEQUENCE\",\"Eight messages over three weeks, counted the way you read them: Touch 1 is the first thing a customer receives. Later parts start their own count again.\"),\n (\"If they book a Pup Talk and do not show\",\"BRANCH_A\",\"Two messages. Both are your rewrite, word for word.\"),\n (\"After a Pup Talk that did not turn into a booking\",\"BRANCH_B\",\"Two messages. No pressure in either.\")]\nif not SHORT:\n SEC += [(\"Then weekly for a month\",\"SLOW_WEEKLY\",\"Four messages. No asks on any of them.\"),\n (\"Then every two weeks for six months\",\"SLOW_FORTNIGHTLY\",\"Thirteen messages.\"),\n (\"Then monthly, indefinitely\",\"SLOW_MONTHLY_BANK\",\"Twelve messages, one a month, seasonal where it fits. These repeat each year.\")]\n\nfor title, key, blurb in SEC:\n flow += [Paragraph(title, H2), Paragraph(blurb, NOTE)]\n for i, m in enumerate(D.get(key, []), 1):\n parts = [Paragraph(f\"TOUCH {i} · {'TEXT MESSAGE' if m['channel']=='sms' else 'EMAIL'} · {'day ' + str(day(m)) if key=='MAIN_SEQUENCE' else ('monthly slot ' + str(i) + ' of 12' if key=='SLOW_MONTHLY_BANK' else '+' + str(day(m)) + ' days')}\", LBL)]\n if m.get('subject'): parts.append(Paragraph(\"Subject: \" + fmt(m['subject']), SUBJ))\n for para in [p for p in re.split(r'\\n\\s*\\n', m['bodyTemplate']) if p.strip()]:\n parts.append(Paragraph(fmt(para).replace('\\n','
'), BODY))\n if m['channel'] == 'sms': parts.append(Paragraph(\"Every text ends with: Reply STOP to stop these texts.\", NOTE))\n parts.append(HRFlowable(width=\"100%\", thickness=0.4, color=colors.HexColor('#eeeeee'), spaceAfter=6))\n flow.append(KeepTogether(parts))\n\nif SHORT:\n flow += [Paragraph(\"What happens after these three weeks\", H2),\n Paragraph(\"The slow track picks up: weekly for a month, then every two weeks for six months, then one a month from there on, cycling the same twelve seasonal ones year after year. That is in the companion document if you want it, and nothing about it changed.\", BODY)]\nflow.append(Paragraph(\"The rules that run underneath all of it\", H2))\nfor line in [\"Anyone who replies comes off the track immediately and gets a person instead.\",\n \"Anyone who books comes off the track.\",\n \"Anyone who texts STOP never hears from the system again, on any track.\",\n \"Nothing sends late at night, and no texts on a Sunday.\",\n \"Nothing has sent to anybody yet. The whole thing is in practice mode until you say the word.\"]:\n flow.append(Paragraph(\"• \" + esc(line), BODY))\n\nout = \"handover/TheDogsSpot-First3Weeks.pdf\" if SHORT else \"handover/TheDogsSpot-AllMessages.pdf\"\nSimpleDocTemplate(out, pagesize=LETTER, leftMargin=0.85*inch, rightMargin=0.85*inch, topMargin=0.7*inch, bottomMargin=0.7*inch,\n title=(\"The Dogs Spot: the first three weeks\" if SHORT else \"The Dogs Spot: every follow-up message\"), author=\"Amir Aizhigitov\").build(flow)\nprint(\"built\", out)\n\n\n\n=====FILE scripts/occupancy-evidence.py =====\nfrom reportlab.lib.pagesizes import A4\nfrom reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle\nfrom reportlab.lib.units import mm\nfrom reportlab.lib import colors\nfrom reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle, KeepTogether\n\nOUT = \"/mnt/user-data/outputs/OCCUPANCY-EVIDENCE-10-Aug.pdf\"\nss = getSampleStyleSheet()\nINK = colors.HexColor(\"#14171a\"); MUT = colors.HexColor(\"#5b6570\")\nACC = colors.HexColor(\"#1c5d99\"); RED = colors.HexColor(\"#b3261e\")\n\nH1 = ParagraphStyle(\"H1\", parent=ss[\"Normal\"], fontName=\"Helvetica-Bold\", fontSize=16, leading=19, textColor=INK, spaceAfter=1)\nSUB = ParagraphStyle(\"SUB\", parent=ss[\"Normal\"], fontName=\"Helvetica\", fontSize=9, leading=12, textColor=MUT, spaceAfter=10)\nS = ParagraphStyle(\"S\", parent=ss[\"Normal\"], fontName=\"Helvetica-Bold\", fontSize=11.5, leading=14, textColor=ACC, spaceBefore=11, spaceAfter=4)\nB = ParagraphStyle(\"B\", parent=ss[\"Normal\"], fontName=\"Helvetica\", fontSize=9.2, leading=12.3, textColor=INK, spaceAfter=4)\nLI = ParagraphStyle(\"LI\", parent=B, leftIndent=11, spaceAfter=2.5)\nBIG = ParagraphStyle(\"BIG\", parent=ss[\"Normal\"], fontName=\"Helvetica-Bold\", fontSize=12.5, leading=15, textColor=RED, spaceAfter=5)\nCELL = ParagraphStyle(\"CELL\", parent=ss[\"Normal\"], fontName=\"Helvetica\", fontSize=8.6, leading=11.2, textColor=INK)\nKEY = ParagraphStyle(\"KEY\", parent=CELL, fontName=\"Helvetica-Bold\")\n\nst = []\ndef sec(t): st.append(Paragraph(t, S))\ndef p(t, s=B): st.append(Paragraph(t, s))\ndef bl(items):\n for t in items: st.append(Paragraph(\"•\" + t, LI))\ndef box(rows, widths, head=None):\n data = [[Paragraph(c, KEY if i == 0 else CELL) for i, c in enumerate(r)] for r in rows]\n if head: data = [[Paragraph(h, KEY) for h in head]] + data\n t = Table(data, colWidths=widths)\n style = [(\"FONT\",(0,0),(-1,-1),\"Helvetica\",8.6),(\"VALIGN\",(0,0),(-1,-1),\"TOP\"),\n (\"BOTTOMPADDING\",(0,0),(-1,-1),4),(\"TOPPADDING\",(0,0),(-1,-1),4),\n (\"LINEBELOW\",(0,0),(-1,-2),0.4,colors.HexColor(\"#dfe4e9\"))]\n if head: style += [(\"TEXTCOLOR\",(0,0),(-1,0),MUT),(\"LINEBELOW\",(0,0),(-1,0),0.8,colors.HexColor(\"#b9c2cb\"))]\n t.setStyle(TableStyle(style)); st.append(t)\n\np(\"Occupancy: the two systems, read side by side\", H1)\np(\"Both read on Sunday 9 August 2026 within twenty minutes of each other. Every figure below is a \"\n \"screen reading, not a calculation of mine. Prepared for the 11:00 acceptance meeting.\", SUB)\n\nsec(\"The headline\")\np(\"Kristian's application says 171 dogs are in the building today. Milton's booking portal says 24. \"\n \"The kennel list in Milton's portal totals 50 kennels.\", BIG)\np(\"171 dogs cannot be in a fifty kennel facility. This is not a discrepancy to reconcile, it is \"\n \"a number that cannot be true.\")\n\nsec(\"Side by side\")\nbox([\n [\"In house today\", \"24\", \"171\", \"7.1x over\"],\n [\"Boarding\", \"11\", \"137\", \"12.5x over\"],\n [\"Board and train / boot camp\", \"13\", \"34\", \"2.6x over\"],\n [\"Arriving today\", \"0\", \"not shown\", \"\"],\n [\"Departing today\", \"0\", \"not shown\", \"\"],\n [\"Booked for tomorrow\", \"dogs booked out to 18 Sep\", \"0\", \"wrong the other way\"],\n [\"Peak next 7 days\", \"at least 24, nobody departs before 10 Aug\", \"0\", \"wrong the other way\"],\n [\"Kennel capacity\", \"50 (20 regular, 10 small, 20 special needs)\", \"not shown\", \"\"],\n], [46*mm, 52*mm, 40*mm, 30*mm], head=[\"\", \"Milton's portal\", \"Kristian's app\", \"\"])\np(\"Milton's portal read at 21:29 UK, its own footer showing \\\"Synced 9:29 PM\\\". Kristian's application \"\n \"read at 22:09 UK, twenty minutes later.\", SUB)\n\nsec(\"The excuse that is now closed off\")\np(\"Earlier this evening his dashboard carried a red error: \\\"Last attempt failed: GHL contacts API \"\n \"error 401: Invalid Private Integration token\\\", stamped 1:40 PM. His integration record in the CRM \"\n \"was renamed from APP v2 to APP v3 and updated at 6:48 PM, so the token was reissued.\")\np(\"At 21:09 the same dashboard reads \\\"Last GHL sync: Aug 9, 5:00 PM. Last attempt: success.\\\" And it \"\n \"still says 171. The sync is healthy and the number is still seven times reality. Whatever is wrong \"\n \"is not the connection.\")\n\nsec(\"What is actually wrong, in one sentence\")\np(\"The application counts every stay that was ever opened and never closed. Milton's portal shows the \"\n \"oldest dog in house arrived on 6 July and is not due out until 14 August, and it shows zero arrivals \"\n \"and zero departures today. Kristian's app shows 171 today and 0 tomorrow, which is the exact signature \"\n \"of a system that accumulates historical rows into \\\"today\\\" and has nothing at all in the future.\")\np(\"His own ChangeLog claims the opposite in four places: pickup linked to originating stay, pickup \"\n \"calendars do not create independent occupancy rows, multi day stays preserved through departure, and \"\n \"active stay and dashboard semantics aligned.\")\n\nsec(\"Kim's own examples, confirmed in Milton's portal\")\nbox([\n [\"Gina Wright\", \"Kristian's app returned \\\"No bookings found\\\". Milton's portal has both her dogs: \"\n \"Rudy, 5 Aug to 11 Aug, kennel R-01, Non Graduate, confirmed; and Raven, 5 Aug to 11 Aug, \"\n \"kennel R-03, Graduated, confirmed. Paired drop off and pick up, named kennels, one line each.\"],\n [\"George Fitzgerald\", \"The customer from the Chloe calls. Huey is in kennel R-13, 7 Aug to 10 Aug, \"\n \"confirmed. Chloe asked him whether he was a first time customer.\"],\n], [30*mm, 138*mm])\n\nsec(\"Questions this puts on the table\")\nbl([\n \"The sync now reports success. Why does the dashboard still say 171?\",\n \"How is a number larger than the kennel capacity being displayed at all? What is the upper bound check?\",\n \"Why is tomorrow zero when Milton's portal has dogs booked through to 18 September?\",\n \"The ChangeLog states multi day stays are preserved through departure. Which line of code does that, and \"\n \"when did it last run?\",\n \"Milton's portal knows this correctly today. What does it do that the new application does not?\",\n])\n\nsec(\"The recommendation\")\np(\"Do not accept the occupancy or dashboard items. They are not close. Milton's portal stays the \"\n \"operational source of truth until Kristian's screen matches it every day for a full week, checked \"\n \"daily against the same two readings above. That check takes two minutes a day and it is the only \"\n \"honest gate on switching over.\")\n\nSimpleDocTemplate(OUT, pagesize=A4, leftMargin=18*mm, rightMargin=18*mm, topMargin=15*mm,\n bottomMargin=13*mm, title=\"Occupancy evidence, 9 August 2026\").build(st)\nprint(\"wrote\", OUT)\n\n\n\n=====FILE scripts/restore.mjs =====\n// RESTORE. Rebuild this whole repo from the val, from an empty folder, with one command.\n//\n// WHY THIS EXISTS. The container has now been reclaimed and reverted to an older snapshot four\n// times. Every time, the recovery is the same three steps and every time they are done from\n// memory. On 6 August I did step one wrong: I fetched all nine SOURCE-BUNDLE parts, concatenated\n// them, and split the result on the file marker. Each part carries its own header block, so that\n// header ended up glued onto the end of the previous part's last file. Five suites came back with\n// \"SyntaxError: Unexpected identifier 'DOGS'\" — the bundle's own title text, sitting inside a test\n// file. The bundle's embedded instructions said to run the split PER PART. They were right; I did\n// not read them.\n//\n// So the procedure is a file now, not a memory:\n// 1. EVERY source file comes out of the SOURCE-BUNDLE parts, ONE PART AT A TIME. engine/ is in\n// the bundle since 14 Aug 2026; see the note at the top of scripts/bundle.mjs for what it\n// cost to find out that \"the val holds the engine\" was true of all but one file.\n// 2. the deployed engine files are then re-read from the val itself, through the API (not\n// esm.town, which prepends a pragma comment and breaks every hash), as the authoritative copy\n// of what is actually running. Anything the val does not hold stays as the bundle restored it.\n// 3. the two PDFs are DERIVED and are rebuilt from their recipe, never restored\n//\n// Usage: node scripts/restore.mjs (restores everything)\n// node scripts/restore.mjs --check (restores to a temp dir and diffs, changes nothing)\nimport { writeFileSync, mkdirSync, existsSync, readFileSync } from \"node:fs\";\nimport { spawnSync } from \"node:child_process\";\nimport { join, dirname, resolve } from \"node:path\";\nimport { fileURLToPath } from \"node:url\";\n\nconst ROOT = resolve(dirname(fileURLToPath(import.meta.url)), \"..\");\nconst VAL = \"1bfa6e81-74e1-4c6c-ab32-118304a4ffff\";\nconst TOKEN = process.env.VALTOWN_TOKEN || readTokenFromDeploy();\n// main.ts on the val is puppy_path_v1.1.ts here; every other engine file keeps its name.\nconst RENAMED = { \"main.ts\": \"puppy_path_v1.1.ts\" };\n\nfunction readTokenFromDeploy() {\n try { return (readFileSync(join(ROOT, \"scripts/deploy.mjs\"), \"utf8\").match(/vtwn_[A-Za-z0-9]+/) || [])[0]; }\n catch { return undefined; }\n}\nconst H = { Authorization: `Bearer ${TOKEN}`, \"Cache-Control\": \"no-cache\" };\nconst out = (p) => (CHECK ? join(TMP, p) : join(ROOT, p));\nconst CHECK = process.argv.includes(\"--check\");\nconst TMP = join(ROOT, \".restore-check\");\n\nasync function get(path) {\n const r = await fetch(`https://api.val.town/v2/vals/${VAL}/files/content?path=${encodeURIComponent(path)}`, { headers: H });\n if (!r.ok) throw new Error(`${path}: HTTP ${r.status}`);\n return r.text();\n}\n\nif (!TOKEN) { console.log(\"RESTORE FAILED: no val.town token. Set VALTOWN_TOKEN.\"); process.exit(1); }\n\n/** Every file on the val, PAGED. A one page listing is a cap wearing a different hat. */\nasync function listVal() {\n const all = [];\n for (let offset = 0, guard = 0; guard < 20; guard++, offset += 100) {\n const r = await fetch(`https://api.val.town/v2/vals/${VAL}/files?path=&recursive=true&limit=100&offset=${offset}`, { headers: H });\n if (!r.ok) throw new Error(`listing the val: HTTP ${r.status}`);\n const page = (await r.json()).data ?? [];\n all.push(...page);\n if (page.length < 100) break;\n }\n return all;\n}\n\nconst valFiles = await listVal();\n\nlet files = 0;\nconst pending = new Map();\n// ---- 1. the bundle, ONE PART AT A TIME. This is the step that goes wrong. ------------------\n//\n// HOW MANY PARTS THERE ARE IS ASKED, NEVER COUNTED TO.\n// [was: `for (let i = 1; i <= 20; i++)`, breaking on the first part that 404s. A guess that was\n// right when the bundle was nine parts and quietly wrong from the day it passed twenty. On\n// 14 Aug 2026 the val held 23 parts and this loop read 20 of them, restored a tree missing\n// three parts' worth of files, and printed two cheerful counts underneath it. Then engine/\n// joined the bundle and it became 35. A recovery script that silently restores most of the\n// backup is the same failure as a backup that silently drops a directory, one step later.]\nconst partNo = (p) => Number((/\\.part(\\d+)\\.txt$/.exec(p) ?? [])[1] ?? 1);\nconst partNames = valFiles\n .map((f) => f.path)\n .filter((p) => /^SOURCE-BUNDLE(\\.part\\d+)?\\.txt$/.test(p))\n .sort((a, b) => partNo(a) - partNo(b));\nif (!partNames.length) { console.log(\"RESTORE FAILED: no SOURCE-BUNDLE on the val.\"); process.exit(1); }\n// AND THEY HAVE TO BE CONTIGUOUS. A missing part in the middle is a hole in the backup, and the\n// files in it are gone whether or not anything says so.\n{\n const nums = partNames.map(partNo);\n const holes = [];\n for (let i = 1; i <= Math.max(...nums); i++) if (!nums.includes(i)) holes.push(i);\n if (holes.length) {\n console.log(`RESTORE FAILED: the bundle on the val is missing part(s) ${holes.join(\", \")} of ${Math.max(...nums)}.`);\n console.log(\"Every part carries whole files, so a missing part is a set of files that will not come back.\");\n process.exit(1);\n }\n}\nconsole.log(`the val holds ${partNames.length} bundle part(s); reading every one of them, one at a time`);\nfor (const name of partNames) {\n const body = await get(name);\n for (const chunk of body.split(\"\\n=====FILE \").slice(1)) {\n const j = chunk.indexOf(\" =====\\n\");\n const name = chunk.slice(0, j);\n const content = chunk.slice(j + 7).replace(/\\n$/, \"\");\n // A record named \"#1\", \"#2\", ... is one FILE cut into pieces because it is bigger than\n // a bundle part. They are appended in the order the parts are read, which is the order they\n // were written. negative-controls.mjs passed the val's own 80,000-character per-file ceiling\n // on 6 August and the bundle could not be written at all until this existed.\n const m = /^(.*)#(\\d+)$/.exec(name);\n if (m) { pending.set(m[1], (pending.get(m[1]) ?? \"\") + content); continue; }\n const dest = out(name);\n mkdirSync(dirname(dest), { recursive: true });\n writeFileSync(dest, content);\n files++;\n }\n}\nfor (const [name, content] of pending) {\n const dest = out(name);\n mkdirSync(dirname(dest), { recursive: true });\n writeFileSync(dest, content);\n files++;\n}\nconsole.log(`restored ${files} files from the bundle${pending.size ? ` (${pending.size} rejoined from chunks)` : \"\"}`);\n\n// ---- 2. the engine, from the val itself -----------------------------------------------------\n//\n// SECOND OPINION SINCE 14 AUG 2026, NOT THE ONLY COPY. engine/ is inside the bundle now (see the\n// note at the top of scripts/bundle.mjs), so step 1 has already written every engine file. This\n// step overwrites them with what the val is actually running, which is the more authoritative\n// answer for anything deployed. An engine file the val does NOT hold, because it is a module the\n// val never runs, is left exactly as the bundle restored it. That file is engine/watch.ts, and it\n// being in neither place is what cost a day.\nlet engine = 0;\nfor (const f of valFiles) {\n if (!/\\.(ts|md)$/.test(f.path) || f.path.startsWith(\"SOURCE-BUNDLE\")) continue;\n const dest = out(join(\"engine\", RENAMED[f.path] ?? f.path));\n mkdirSync(dirname(dest), { recursive: true });\n writeFileSync(dest, await get(f.path));\n engine++;\n}\nconsole.log(`restored ${engine} engine files from the val`);\n\n// WHAT IS MISSING MATTERS AS MUCH AS WHAT CAME BACK.\n//\n// On 7 August the container reverted to a snapshot that predated the deposit tracker entirely.\n// This script restored 36 files and 23 engine files and said so cheerfully. What it did not say\n// was that the ENGINE came back at the state it had been deployed at, and TESTS and HANDOVER came\n// back from a bundle written twelve hours earlier — so the code had a day of fixes in it and the\n// suite that proves them did not. That mismatch is invisible in the two counts above, and the\n// first sign of it was six tests failing for reasons that looked like new bugs.\n//\n// The lesson is not \"check harder\". It is REBUNDLE AS SOON AS THE TREE IS GREEN, every time,\n// because the bundle is the only copy of everything that is not the engine. This list is the\n// cheap half: a restore that comes back without a test runner in it is not a restore.\nconst MUST_EXIST = [\n \"tests/run-all.mjs\", \"tests/_harness.mjs\", \"tests/negative-controls.mjs\",\n \"tests/dashboard.test.mjs\", \"tests/holiday-deposits.test.mjs\", \"tests/deposits-collect.test.mjs\",\n \"scripts/build.mjs\", \"scripts/deploy.mjs\", \"scripts/bundle.mjs\", \"scripts/typecheck.mjs\",\n \"handover/DEPOSIT-SPEC.md\",\n // THE ONE THE VAL CANNOT SUPPLY. engine/watch.ts is the early warning monitor, it is not\n // deployed because the val does not run it, and on 12 Aug 2026 that meant it existed in exactly\n // one container. If a restore comes back without it, the bundle is older than the fix and this\n // is the line that says so instead of a test suite failing to import an hour later.\n \"engine/watch.ts\", \"tests/watch.test.mjs\", \"scripts/watch-run.mjs\",\n];\nconst missing = MUST_EXIST.filter((f) => !existsSync(out(f)));\nif (missing.length) {\n console.log(`\\nINCOMPLETE RESTORE — ${missing.length} expected file(s) are not in the bundle:`);\n for (const f of missing) console.log(` ${f}`);\n console.log(\"The bundle on the val is older than the work. Do not trust a green run until this is resolved.\");\n}\n\nif (CHECK) {\n // Every restored file must already match what is on disk. A difference means the disk has work\n // the val has never seen — which is the thing to find out BEFORE the next reclaim, not after.\n const d = spawnSync(\"diff\", [\"-rq\", \"--exclude=.restore-check\", TMP, ROOT], { encoding: \"utf8\" });\n const drift = (d.stdout || \"\").split(\"\\n\").filter((l) => l.startsWith(\"Files \") && l.includes(\"differ\"));\n console.log(drift.length ? `\\n${drift.length} file(s) on disk differ from the val:\\n${drift.join(\"\\n\")}` : \"\\nno drift: every restored file matches what is on disk\");\n process.exit(drift.length ? 1 : 0);\n}\n\n// ---- 3. the derived artifacts, rebuilt rather than restored --------------------------------\n// A FAILED REBUILD HERE IS A FAILED RESTORE. [was: it logged \"PDF rebuild FAILED\" and carried on\n// to print \"Now run: node tests/run-all.mjs\", exit 0. That is how occurrence #2 of the missing\n// First3Weeks.pdf rotted into occurrence #3: the restore said it was done, the operator moved on,\n// and the next person to notice was cross-artifact.test.mjs dying on ENOENT — which kills the\n// runner before its floors, its missing-suite check and its money guards ever run. A restore that\n// cannot reproduce a derived artifact has not restored the tree.]\nif (existsSync(join(ROOT, \"scripts/make-pdfs.mjs\"))) {\n const r = spawnSync(\"node\", [join(ROOT, \"scripts/make-pdfs.mjs\")], { encoding: \"utf8\", cwd: ROOT, timeout: 300_000 });\n if (r.status !== 0) {\n console.log(`PDF rebuild FAILED:\\n${(r.stdout + r.stderr).slice(0, 600)}`);\n console.log(\"\\nThe derived artifacts are not reproducible in this container, so the restore is INCOMPLETE.\");\n console.log(\"cross-artifact.test.mjs reads handover/TheDogsSpot-First3Weeks.pdf and will die on ENOENT\");\n console.log(\"before run-all.mjs reaches a single floor or money guard. Fix this before trusting a green.\");\n process.exit(1);\n }\n console.log(\"rebuilt both PDFs from their recipe\");\n}\n\nconsole.log(\"\\nNow run: node tests/run-all.mjs (it rebuilds engine/ -> build/ itself)\");\nconsole.log(\" node scripts/deploy.mjs --check (should show zero DIFFERS)\");\n\n\n\n=====FILE scripts/transcript_census_wide.py =====\n#!/usr/bin/env python3\n\"\"\"\nWide transcript-coverage census.\nSTRICTLY READ-ONLY: GET requests only.\n\nWalks conversations sorted by recent activity (most recent first),\nfor each conversation collects every TYPE_CALL message, and for each\ncall checks the transcription endpoint and the recording endpoint.\n\nCheckpoints progress to disk continuously so partial results survive\na timeout.\n\"\"\"\nimport json, time, sys, os, re, signal\n\nimport requests\n\nREPO = \"/home/claude/dogsspot\"\nTOK = None\nwith open(os.path.join(REPO, \"tests\", \"aged_audit.py\")) as f:\n txt = f.read()\nm = re.search(r\"pit-[a-f0-9]{8}-[a-f0-9-]*\", txt)\nTOK = m.group(0)\n\nBASE = \"https://services.leadconnectorhq.com\"\nLOC = \"BQHJ19uohldYe3eqA0bl\"\nHDRS_CONV = {\n \"Authorization\": f\"Bearer {TOK}\",\n \"User-Agent\": \"curl/8.5.0\",\n \"Version\": \"2021-04-15\",\n}\n\nSTATE_PATH = os.path.join(REPO, \"logs\", \"transcript-census-wide-state.json\")\nOUT_PATH = os.path.join(REPO, \"logs\", \"transcript-census-wide.json\")\n\nSOFT_DEADLINE_SECONDS = float(sys.argv[1]) if len(sys.argv) > 1 else 500.0\nTARGET_CONVERSATIONS = int(sys.argv[2]) if len(sys.argv) > 2 else 300\n\nSTART = time.time()\n\n\ndef elapsed():\n return time.time() - START\n\n\ndef get(url, params=None, max_retries=4):\n for attempt in range(max_retries):\n try:\n r = requests.get(url, headers=HDRS_CONV, params=params, timeout=30)\n except requests.exceptions.RequestException as e:\n print(f\" ! request exception on {url}: {e}\", flush=True)\n time.sleep(2)\n continue\n if r.status_code == 429:\n print(f\" ! 429 rate-limited on {url}, backing off 5s\", flush=True)\n time.sleep(5)\n continue\n return r\n return r\n\n\ndef load_state():\n if os.path.exists(STATE_PATH):\n with open(STATE_PATH) as f:\n return json.load(f)\n return {\n \"conversations_scanned\": [], # list of {id, contactName, lastMessageDate}\n \"conversations_scanned_ids\": [],\n \"calls\": [], # list of call records\n \"cursor_start_after_date\": None,\n \"conversation_ids_seen\": [],\n \"done_collecting_conversations\": False,\n \"conversations_to_walk\": [], # queue of conversation dicts not yet message-scanned\n \"next_walk_index\": 0,\n \"errors\": [],\n }\n\n\ndef save_state(state):\n tmp = STATE_PATH + \".tmp\"\n with open(tmp, \"w\") as f:\n json.dump(state, f)\n os.replace(tmp, STATE_PATH)\n\n\ndef main():\n state = load_state()\n seen_conv_ids = set(state[\"conversation_ids_seen\"])\n\n # Phase 1: collect conversations sorted by recent activity until we have\n # TARGET_CONVERSATIONS or run out, or hit ~30% of deadline budget.\n collect_deadline = SOFT_DEADLINE_SECONDS * 0.35\n if not state[\"done_collecting_conversations\"]:\n start_after_date = state[\"cursor_start_after_date\"]\n while len(state[\"conversations_to_walk\"]) < TARGET_CONVERSATIONS and elapsed() < collect_deadline:\n params = {\n \"locationId\": LOC,\n \"limit\": 100,\n \"sort\": \"desc\",\n \"sortBy\": \"last_message_date\",\n }\n if start_after_date:\n params[\"startAfterDate\"] = start_after_date\n r = get(f\"{BASE}/conversations/search\", params=params)\n time.sleep(0.3)\n if r is None or r.status_code != 200:\n code = r.status_code if r is not None else \"NO_RESPONSE\"\n print(f\"conversations/search FAILED status={code} body={r.text[:300] if r is not None else ''}\", flush=True)\n state[\"errors\"].append({\"phase\": \"conv_search\", \"status\": code, \"body\": r.text[:300] if r is not None else \"\"})\n break\n data = r.json()\n convs = data.get(\"conversations\", [])\n print(f\"[collect] got {len(convs)} conversations, total queued={len(state['conversations_to_walk'])}, elapsed={elapsed():.0f}s\", flush=True)\n if not convs:\n state[\"done_collecting_conversations\"] = True\n break\n new_count = 0\n for c in convs:\n if c[\"id\"] not in seen_conv_ids:\n seen_conv_ids.add(c[\"id\"])\n state[\"conversations_to_walk\"].append({\n \"id\": c[\"id\"],\n \"contactId\": c.get(\"contactId\"),\n \"contactName\": c.get(\"contactName\") or c.get(\"fullName\"),\n \"lastMessageDate\": c.get(\"lastMessageDate\"),\n \"lastMessageType\": c.get(\"lastMessageType\"),\n })\n new_count += 1\n start_after_date = convs[-1][\"lastMessageDate\"]\n state[\"cursor_start_after_date\"] = start_after_date\n state[\"conversation_ids_seen\"] = list(seen_conv_ids)\n if len(convs) < 100:\n state[\"done_collecting_conversations\"] = True\n break\n save_state(state)\n save_state(state)\n\n print(f\"[collect] DONE collecting: {len(state['conversations_to_walk'])} conversations queued, elapsed={elapsed():.0f}s\", flush=True)\n\n # Phase 2: walk each conversation's messages, find TYPE_CALL, check transcription + recording.\n queue = state[\"conversations_to_walk\"]\n idx = state[\"next_walk_index\"]\n calls = state[\"calls\"]\n scanned = state[\"conversations_scanned\"]\n\n while idx < len(queue) and elapsed() < SOFT_DEADLINE_SECONDS:\n conv = queue[idx]\n conv_id = conv[\"id\"]\n # fetch all messages for this conversation (paginate)\n last_message_id = None\n page_count = 0\n conv_calls_found = 0\n while page_count < 10: # safety cap: 10 pages * 100 = 1000 messages\n params = {\"limit\": 100}\n if last_message_id:\n params[\"lastMessageId\"] = last_message_id\n r = get(f\"{BASE}/conversations/{conv_id}/messages\", params=params)\n time.sleep(0.3)\n page_count += 1\n if r is None or r.status_code != 200:\n code = r.status_code if r is not None else \"NO_RESPONSE\"\n print(f\" ! messages FETCH FAILED conv={conv_id} status={code}\", flush=True)\n state[\"errors\"].append({\"phase\": \"messages\", \"conv\": conv_id, \"status\": code})\n break\n data = r.json()\n mblock = data.get(\"messages\", {})\n msgs = mblock.get(\"messages\", [])\n for msg in msgs:\n if msg.get(\"messageType\") == \"TYPE_CALL\":\n conv_calls_found += 1\n call_id = msg[\"id\"]\n call_record = {\n \"id\": call_id,\n \"conv\": conv_id,\n \"contact\": conv.get(\"contactId\"),\n \"name\": conv.get(\"contactName\"),\n \"at\": msg.get(\"dateAdded\"),\n \"dir\": msg.get(\"direction\"),\n \"status\": (msg.get(\"meta\") or {}).get(\"call\", {}).get(\"status\"),\n \"dur\": (msg.get(\"meta\") or {}).get(\"call\", {}).get(\"duration\"),\n }\n # transcription check\n tr = get(f\"{BASE}/conversations/locations/{LOC}/messages/{call_id}/transcription\")\n time.sleep(0.3)\n call_record[\"transcript\"] = str(tr.status_code) if tr is not None else \"ERR\"\n # recording check\n rec = get(f\"{BASE}/conversations/messages/{call_id}/locations/{LOC}/recording\")\n time.sleep(0.3)\n call_record[\"recording\"] = str(rec.status_code) if rec is not None else \"ERR\"\n calls.append(call_record)\n if not mblock.get(\"nextPage\") or not msgs:\n break\n new_last = mblock.get(\"lastMessageId\")\n if not new_last or new_last == last_message_id:\n break\n last_message_id = new_last\n\n scanned.append({\n \"id\": conv_id,\n \"contactName\": conv.get(\"contactName\"),\n \"lastMessageDate\": conv.get(\"lastMessageDate\"),\n \"calls_found\": conv_calls_found,\n })\n idx += 1\n state[\"next_walk_index\"] = idx\n if idx % 10 == 0:\n print(f\"[walk] {idx}/{len(queue)} conversations scanned, {len(calls)} calls found so far, elapsed={elapsed():.0f}s\", flush=True)\n save_state(state)\n\n save_state(state)\n print(f\"[walk] STOPPED at {idx}/{len(queue)} conversations scanned, {len(calls)} calls found, elapsed={elapsed():.0f}s\", flush=True)\n\n # Write final output summary\n with open(OUT_PATH, \"w\") as f:\n json.dump({\n \"conversations_scanned_count\": len(scanned),\n \"conversations_scanned\": scanned,\n \"calls\": calls,\n \"errors\": state[\"errors\"],\n }, f, indent=1)\n print(f\"Wrote {OUT_PATH}\", flush=True)\n print(f\"DONE_FLAG idx={idx} queue_len={len(queue)} done_collecting={state['done_collecting_conversations']}\", flush=True)\n\n\nif __name__ == \"__main__\":\n main()\n\n\n\n=====FILE scripts/typecheck.mjs =====\n// TYPECHECK. Nothing in this project has ever run one, and on 6 August an adversarial pass found\n// why that matters: `dogCount` was added to the Stay type and two object literals in deposits.ts\n// were never updated. esbuild strips types without checking them, so the build was clean, the\n// suite was green, and the defect was invisible. It happened to be harmless. The next one might\n// not be.\n//\n// It is NOT a plain tsc run: this code targets Deno on val.town, so `Deno`, remote https imports\n// and .ts import specifiers are all correct here and all errors to tsc. Those three classes are\n// filtered by name, and the filter is deliberately narrow — anything else is a real error.\n//\n// Usage: node scripts/typecheck.mjs\nimport { spawnSync } from \"node:child_process\";\nimport { readdirSync, writeFileSync, rmSync } from \"node:fs\";\nimport { join, dirname, resolve } from \"node:path\";\nimport { fileURLToPath } from \"node:url\";\n\nconst ROOT = resolve(dirname(fileURLToPath(import.meta.url)), \"..\");\nconst SHIM = join(ROOT, \"engine\", \"_deno-shim.d.ts\");\n// The three things that are true on val.town and false to tsc.\nconst DENO_ONLY = [\n /Cannot find name 'Deno'/,\n /Cannot find module 'https:\\/\\//,\n /Cannot find module '\\.\\/main\\.ts'/, // run.ts imports the val's entry point by its val name\n];\n\nwriteFileSync(SHIM, \"declare const Deno: { env: { get(k: string): string | undefined } };\\nexport {};\\n\");\ntry {\n const files = readdirSync(join(ROOT, \"engine\")).filter((f) => f.endsWith(\".ts\") && !f.endsWith(\".d.ts\"));\n // A TYPECHECK THAT CHECKS NOTHING IS NOT A TYPECHECK. With engine/ emptied this printed\n // \"0 engine files, 0 real error(s)\" and exited 0 — the exact shape of the zero-scope failure\n // this project keeps finding. scripts/build.mjs has had this guard since the start; this did not.\n if (!files.length) {\n console.log(\"TYPECHECK FAILURE: found 0 .ts files under engine/. A check that checks nothing is not a check.\");\n process.exit(1);\n }\n const r = spawnSync(\"npx\", [\"--yes\", \"tsc\", \"--noEmit\", \"--skipLibCheck\", \"--target\", \"es2022\",\n \"--module\", \"preserve\", \"--moduleResolution\", \"bundler\", \"--allowImportingTsExtensions\",\n ...files.map((f) => join(\"engine\", f))], { encoding: \"utf8\", cwd: ROOT, timeout: 300_000 });\n const lines = `${r.stdout ?? \"\"}${r.stderr ?? \"\"}`.split(\"\\n\").filter((l) => /error TS/.test(l));\n const real = lines.filter((l) => !DENO_ONLY.some((re) => re.test(l)));\n const waived = lines.length - real.length;\n console.log(`typecheck: ${files.length} engine files, ${real.length} real error(s), ${waived} val.town-only waived`);\n if (real.length) { console.log(real.slice(0, 25).join(\"\\n\")); process.exit(1); }\n} finally {\n rmSync(SHIM, { force: true });\n}\n\n\n","createdAt",["D",1789560845026],"branchVersion","branchId","551774fb-a850-4c9d-94a1-d3509ddcf1b0","id","1bfa6e81-74e1-4c6c-ab32-118304a4ffff","dogsspot_puppy_path",["D",1785429259053],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Puppy path nurture engine v1.2 — The Dogs Spot","imageUrl","d26e64e6-cd39-4be1-b5b4-1de11cc555f8","pinnedFileId","ad633fec-8e73-11f1-b800-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f56fd-bd59-724f-8163-80ffcf8235dd","tursoName","1bfa6e8174e14c6cab32118304a4ffff","tursoHostname","1bfa6e8174e14c6cab32118304a4ffff-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519842404],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":47},"branch",{"_13":87,"_32":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",1280,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","amir5","handle","displayName","Amir","avatar","https://lh3.googleusercontent.com/a/ACg8ocILk3bwhcvrzozUWm7gxlKoBm7ZGtsgIkesW3ysOOsJ1rSQuA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_32":43,"_36":812,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":813,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":814,"_82":815,"_84":816,"_86":47},"tree",[595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648],"files",[595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648],"counts",{"_584":61,"_585":242,"_586":61,"_587":588,"_589":590},"contents",[129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":577,"_32":578,"_30":579,"_186":-5,"_39":40,"_38":580,"_188":25,"_36":581,"_13":61,"_33":20,"_34":582,"_24":47,"_193":-5,"_27":583},{"_41":570,"_32":571,"_30":572,"_186":-5,"_39":40,"_38":573,"_188":25,"_36":574,"_13":217,"_33":191,"_34":575,"_24":47,"_193":-5,"_27":576},{"_41":563,"_32":564,"_30":565,"_186":-5,"_39":40,"_38":566,"_188":25,"_36":567,"_13":234,"_33":20,"_34":568,"_24":47,"_193":-5,"_27":569},{"_41":556,"_32":557,"_30":558,"_186":-5,"_39":40,"_38":559,"_188":25,"_36":560,"_13":61,"_33":20,"_34":561,"_24":47,"_193":-5,"_27":562},{"_41":549,"_32":550,"_30":551,"_186":-5,"_39":40,"_38":552,"_188":47,"_36":553,"_13":200,"_33":20,"_34":554,"_24":47,"_193":-5,"_27":555},{"_41":542,"_32":543,"_30":544,"_186":-5,"_39":40,"_38":545,"_188":47,"_36":546,"_13":200,"_33":20,"_34":547,"_24":47,"_193":-5,"_27":548},{"_41":535,"_32":536,"_30":537,"_186":-5,"_39":40,"_38":538,"_188":47,"_36":539,"_13":217,"_33":20,"_34":540,"_24":47,"_193":-5,"_27":541},{"_41":528,"_32":529,"_30":530,"_186":-5,"_39":40,"_38":531,"_188":47,"_36":532,"_13":61,"_33":20,"_34":533,"_24":47,"_193":-5,"_27":534},{"_41":521,"_32":522,"_30":523,"_186":-5,"_39":40,"_38":524,"_188":47,"_36":525,"_13":61,"_33":20,"_34":526,"_24":47,"_193":-5,"_27":527},{"_41":514,"_32":515,"_30":516,"_186":-5,"_39":40,"_38":517,"_188":47,"_36":518,"_13":61,"_33":20,"_34":519,"_24":47,"_193":-5,"_27":520},{"_41":507,"_32":508,"_30":509,"_186":-5,"_39":40,"_38":510,"_188":47,"_36":511,"_13":61,"_33":20,"_34":512,"_24":47,"_193":-5,"_27":513},{"_41":500,"_32":501,"_30":502,"_186":-5,"_39":40,"_38":503,"_188":47,"_36":504,"_13":61,"_33":20,"_34":505,"_24":47,"_193":-5,"_27":506},{"_41":493,"_32":494,"_30":495,"_186":-5,"_39":40,"_38":496,"_188":47,"_36":497,"_13":61,"_33":20,"_34":498,"_24":47,"_193":-5,"_27":499},{"_41":486,"_32":487,"_30":488,"_186":-5,"_39":40,"_38":489,"_188":47,"_36":490,"_13":61,"_33":20,"_34":491,"_24":47,"_193":-5,"_27":492},{"_41":479,"_32":480,"_30":481,"_186":-5,"_39":40,"_38":482,"_188":25,"_36":483,"_13":61,"_33":191,"_34":484,"_24":47,"_193":-5,"_27":485},{"_41":472,"_32":473,"_30":474,"_186":-5,"_39":40,"_38":475,"_188":25,"_36":476,"_13":217,"_33":209,"_34":477,"_24":47,"_193":-5,"_27":478},{"_41":465,"_32":466,"_30":56,"_186":-5,"_39":40,"_38":467,"_188":25,"_36":468,"_13":469,"_33":209,"_34":470,"_24":47,"_193":-5,"_27":471},{"_41":458,"_32":459,"_30":460,"_186":-5,"_39":40,"_38":461,"_188":25,"_36":462,"_13":61,"_33":191,"_34":463,"_24":47,"_193":-5,"_27":464},{"_41":451,"_32":452,"_30":453,"_186":-5,"_39":40,"_38":454,"_188":25,"_36":455,"_13":226,"_33":191,"_34":456,"_24":47,"_193":-5,"_27":457},{"_41":444,"_32":445,"_30":446,"_186":-5,"_39":40,"_38":447,"_188":25,"_36":448,"_13":242,"_33":191,"_34":449,"_24":47,"_193":-5,"_27":450},{"_41":437,"_32":438,"_30":439,"_186":-5,"_39":40,"_38":440,"_188":25,"_36":441,"_13":61,"_33":191,"_34":442,"_24":47,"_193":-5,"_27":443},{"_41":429,"_32":430,"_30":431,"_186":-5,"_39":40,"_38":432,"_188":25,"_36":433,"_13":434,"_33":209,"_34":435,"_24":47,"_193":-5,"_27":436},{"_41":421,"_32":422,"_30":423,"_186":-5,"_39":40,"_38":424,"_188":25,"_36":425,"_13":426,"_33":191,"_34":427,"_24":47,"_193":-5,"_27":428},{"_41":414,"_32":415,"_30":416,"_186":-5,"_39":40,"_38":417,"_188":25,"_36":418,"_13":200,"_33":218,"_34":419,"_24":47,"_193":-5,"_27":420},{"_41":406,"_32":407,"_30":408,"_186":-5,"_39":40,"_38":409,"_188":25,"_36":410,"_13":411,"_33":209,"_34":412,"_24":47,"_193":-5,"_27":413},{"_41":399,"_32":400,"_30":401,"_186":-5,"_39":40,"_38":402,"_188":25,"_36":403,"_13":61,"_33":191,"_34":404,"_24":47,"_193":-5,"_27":405},{"_41":391,"_32":392,"_30":393,"_186":-5,"_39":40,"_38":394,"_188":25,"_36":395,"_13":396,"_33":191,"_34":397,"_24":47,"_193":-5,"_27":398},{"_41":384,"_32":385,"_30":386,"_186":-5,"_39":40,"_38":387,"_188":25,"_36":388,"_13":294,"_33":209,"_34":389,"_24":47,"_193":-5,"_27":390},{"_41":377,"_32":378,"_30":379,"_186":-5,"_39":40,"_38":380,"_188":25,"_36":381,"_13":265,"_33":191,"_34":382,"_24":47,"_193":-5,"_27":383},{"_41":370,"_32":371,"_30":372,"_186":-5,"_39":40,"_38":373,"_188":25,"_36":374,"_13":265,"_33":209,"_34":375,"_24":47,"_193":-5,"_27":376},{"_41":363,"_32":364,"_30":365,"_186":-5,"_39":40,"_38":366,"_188":25,"_36":367,"_13":208,"_33":209,"_34":368,"_24":47,"_193":-5,"_27":369},{"_41":355,"_32":356,"_30":357,"_186":-5,"_39":40,"_38":358,"_188":25,"_36":359,"_13":360,"_33":191,"_34":361,"_24":47,"_193":-5,"_27":362},{"_41":348,"_32":349,"_30":350,"_186":-5,"_39":40,"_38":351,"_188":25,"_36":352,"_13":217,"_33":191,"_34":353,"_24":47,"_193":-5,"_27":354},{"_41":340,"_32":341,"_30":342,"_186":-5,"_39":40,"_38":343,"_188":25,"_36":344,"_13":345,"_33":218,"_34":346,"_24":47,"_193":-5,"_27":347},{"_41":333,"_32":334,"_30":335,"_186":-5,"_39":40,"_38":336,"_188":25,"_36":337,"_13":217,"_33":191,"_34":338,"_24":47,"_193":-5,"_27":339},{"_41":326,"_32":327,"_30":328,"_186":-5,"_39":40,"_38":329,"_188":25,"_36":330,"_13":242,"_33":191,"_34":331,"_24":47,"_193":-5,"_27":332},{"_41":318,"_32":319,"_30":320,"_186":-5,"_39":40,"_38":321,"_188":25,"_36":322,"_13":323,"_33":209,"_34":324,"_24":47,"_193":-5,"_27":325},{"_41":311,"_32":312,"_30":313,"_186":-5,"_39":40,"_38":314,"_188":25,"_36":315,"_13":242,"_33":191,"_34":316,"_24":47,"_193":-5,"_27":317},{"_41":304,"_32":305,"_30":306,"_186":-5,"_39":40,"_38":307,"_188":25,"_36":308,"_13":242,"_33":191,"_34":309,"_24":47,"_193":-5,"_27":310},{"_41":297,"_32":298,"_30":299,"_186":-5,"_39":40,"_38":300,"_188":25,"_36":301,"_13":208,"_33":191,"_34":302,"_24":47,"_193":-5,"_27":303},{"_41":289,"_32":290,"_30":291,"_186":-5,"_39":40,"_38":292,"_188":25,"_36":293,"_13":294,"_33":191,"_34":295,"_24":47,"_193":-5,"_27":296},{"_41":282,"_32":283,"_30":284,"_186":-5,"_39":40,"_38":285,"_188":25,"_36":286,"_13":208,"_33":191,"_34":287,"_24":47,"_193":-5,"_27":288},{"_41":275,"_32":276,"_30":277,"_186":-5,"_39":40,"_38":278,"_188":25,"_36":279,"_13":242,"_33":191,"_34":280,"_24":47,"_193":-5,"_27":281},{"_41":268,"_32":269,"_30":270,"_186":-5,"_39":40,"_38":271,"_188":25,"_36":272,"_13":61,"_33":191,"_34":273,"_24":47,"_193":-5,"_27":274},{"_41":260,"_32":261,"_30":262,"_186":-5,"_39":40,"_38":263,"_188":25,"_36":264,"_13":265,"_33":191,"_34":266,"_24":47,"_193":-5,"_27":267},{"_41":252,"_32":253,"_30":254,"_186":-5,"_39":40,"_38":255,"_188":25,"_36":256,"_13":257,"_33":209,"_34":258,"_24":47,"_193":-5,"_27":259},{"_41":245,"_32":246,"_30":247,"_186":-5,"_39":40,"_38":248,"_188":25,"_36":249,"_13":217,"_33":209,"_34":250,"_24":47,"_193":-5,"_27":251},{"_41":237,"_32":238,"_30":239,"_186":-5,"_39":40,"_38":240,"_188":25,"_36":241,"_13":242,"_33":191,"_34":243,"_24":47,"_193":-5,"_27":244},{"_41":229,"_32":230,"_30":231,"_186":-5,"_39":40,"_38":232,"_188":25,"_36":233,"_13":234,"_33":191,"_34":235,"_24":47,"_193":-5,"_27":236},{"_41":221,"_32":222,"_30":223,"_186":-5,"_39":40,"_38":224,"_188":25,"_36":225,"_13":226,"_33":209,"_34":227,"_24":47,"_193":-5,"_27":228},{"_41":212,"_32":213,"_30":214,"_186":-5,"_39":40,"_38":215,"_188":25,"_36":216,"_13":217,"_33":218,"_34":219,"_24":47,"_193":-5,"_27":220},{"_41":203,"_32":204,"_30":205,"_186":-5,"_39":40,"_38":206,"_188":25,"_36":207,"_13":208,"_33":209,"_34":210,"_24":47,"_193":-5,"_27":211},{"_41":195,"_32":196,"_30":197,"_186":-5,"_39":40,"_38":198,"_188":25,"_36":199,"_13":200,"_33":191,"_34":201,"_24":47,"_193":-5,"_27":202},{"_41":183,"_32":184,"_30":185,"_186":-5,"_39":40,"_38":187,"_188":25,"_36":189,"_13":190,"_33":191,"_34":192,"_24":47,"_193":-5,"_27":194},"07bbc883-3657-42ce-a700-629b0024a8cb","worklog.ts","facd3ee8-9028-11f1-8d98-1607ee4eb77e","parentId",1117,"latest",["D",1786812154376],39,"script","// THE WORK LOG — what changed, what broke, what got fixed. v1.0, 4 Aug 2026.\n//\n// WHY: Kim's dashboard answers \"is it working\" from live data. It cannot answer \"what have you\n// actually been doing\" or \"did something break last week\" from live data, because those are\n// events, not states. This file is the event trail: append-only, plain English, dated.\n//\n// THE RULE: every entry describes something that DEMONSTRABLY happened, with the evidence\n// alongside it. No entry is written for work that was merely intended. If a claim here cannot\n// be checked, it does not go here. Kim reads this; it is the receipts column of the retainer.\n//\n// TWO SOURCES:\n// 1. SEEDED (below): work done by hand, each line traceable to a verification run.\n// 2. AUTOMATIC: the watchdog appends \"broke\"/\"recovered\" pairs to the `tds_worklog` blob, so\n// an outage at 3am and its recovery both appear without anyone remembering to write them.\n\nexport type WorkEntry = {\n at: string; // ISO date (day precision is fine; this is a human timeline)\n // v1.2. A reader noticed that \"Fixed: this page used to state a number nobody measured\" (mine)\n // and \"Fixed: your website was charging half the deposit\" (hers, worth thousands) wore the same\n // label in the same colour, so my errors were hiding among her wins. `mine` is now its own kind\n // and its own word. Her words: \"Separate the two columns and I'll trust the page more, not less.\"\n kind: \"fixed\" | \"built\" | \"found\" | \"broke\" | \"recovered\" | \"changed\" | \"mine\";\n what: string; // one plain sentence, Kim's vocabulary\n evidence?: string; // how it was checked. Optional only for \"broke\" (the alarm IS the evidence)\n};\n\n// Seeded history. Everything below was verified on the date shown; the evidence column names\n// the check. Newest first is handled by the renderer, so this list stays chronological.\nexport const SEEDED: WorkEntry[] = [\n {\n at: \"2026-07-30\",\n kind: \"built\",\n what: \"The puppy follow-up system was built and switched into practice mode, where it does everything except actually send.\",\n evidence: \"It has been running on its own since, writing down every decision it makes. Its first practice run is still on file.\",\n },\n {\n at: \"2026-08-02\",\n kind: \"built\",\n what: \"Candace's welcome email was written and sent so she could start on the phones with the full picture.\",\n evidence: \"Sent 2 August; it is in the sent folder.\",\n },\n {\n at: \"2026-08-02\",\n kind: \"found\",\n what: \"Your website was charging a $250 Bootcamp deposit instead of $500. It was hidden inside the booking form's own settings, which is why nobody could find it.\",\n evidence: \"Fixed and published; the whole live site was then searched for '$250' and it appears nowhere.\",\n },\n {\n at: \"2026-08-02\",\n kind: \"found\",\n what: \"There are 17 Bootcamp bookings on record, from 19 December to 25 July, every one of them taken while the deposit was set to $250. What is not yet known is which of them actually paid one, and that means matching each booking against the payment records.\",\n evidence: \"Counted from your own booking records. An earlier version of this note asked you for a payment permission to finish the job; that was wrong and it is corrected here, because you had already granted it and it has been working since 1 August. Matching the bookings to the payments is work rather than a blocker, and it has not been done yet.\",\n },\n {\n at: \"2026-08-03\",\n kind: \"fixed\",\n what: \"29 people who had texted STOP were never marked do-not-contact in the CRM, so they could still have been messaged.\",\n evidence: \"All 29 marked, then all 29 read back one at a time through the CRM's own records on 4 August. 29 of 29 confirmed, none missed.\",\n },\n {\n at: \"2026-08-03\",\n kind: \"mine\",\n what: \"Three of the people who had texted STOP were on a call list I had already sent to your front desk. That was my mistake. The list was pulled and rebuilt the same day, but whether anyone had already called those three is not something I can see from here, and it is worth asking the desk.\",\n evidence: \"The rebuilt list has every STOP and every gate arrival removed, with a second tab naming exactly who came off it and why. The three names are in that tab, so the desk can be asked about those three specifically.\",\n },\n {\n at: \"2026-08-03\",\n kind: \"changed\",\n what: \"The puppy follow-up messages were updated with your notes: the toy advice now explains the why, and the Pup Talk asks came down from six to four.\",\n evidence: \"The PDF you signed off was generated straight from the live system, not from a draft.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"built\",\n what: \"The slow track you asked for is built: weekly for a month, then every two weeks for six months, then monthly. No sales asks anywhere on it.\",\n evidence: \"29 messages, all written out in the PDF for your sign-off. Nothing sends until you say go.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"mine\",\n what: \"The follow-up system was running slightly older wording than the version you approved. It now runs exactly what you read.\",\n evidence: \"Compared the live wording against the wording you approved, character by character; they now match.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"fixed\",\n what: \"A security review found that text typed by a customer into their own name could end up treated as code inside an email we send, rather than as words. Nobody had done it, and it cannot happen now. Two other holes were found and closed in the same review, one of them in the key that protects the page you are reading.\",\n evidence: \"It came out of an adversarial review alongside two other security findings, and each of the three now has its own automatic check, and those checks are run before anything goes anywhere near your account. For this one that means names holding dollar signs, angle brackets, quotes and stray markup. The old page key was checked afterwards and is dead.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"built\",\n // [was: \"...looks over the whole setup ON A TIMER and raises an alarm...\". Every word about\n // what it checks was verified and still stands. The two words about the timer were not, and\n // on 5 August the timer turned out never to have fired. Kim has read this line. It is\n // corrected here rather than deleted, and the 5 August entry above carries the current state.]\n what: \"A second, separate system now looks over the whole setup and raises an alarm if anything stops working, including if somebody else quietly changes one of your CRM automations.\",\n evidence: \"Run live and watched end to end. It takes a fingerprint of your CRM automations each time it looks, so a change to any one of them shows up as a change rather than as silence. What was NOT checked at the time was whether it starts itself on a schedule. It does not; see 5 August.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"found\",\n what: \"Your CRM still has an old puppy follow-up automation switched on. If our new one went live alongside it, new inquiries would get two sets of messages from you on the same day.\",\n evidence: \"Read all 165 automations in your account. Switching ours on and that one off has to happen together, and it needs your say-so.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"found\",\n what: \"Your CRM records where nearly every inquiry came from, but not in the column it shows you. The column you can see is blank for four out of five people; the record underneath places all of them.\",\n evidence: \"Checked across a full week of inquiries: the column you can see named about one in five of them, the record underneath named every single one. That is where the Facebook and Instagram numbers above come from, and they are recounted every time you open this page.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"mine\",\n what: \"This page used to tell you the follow-up system checks in every 15 minutes. Nobody had ever measured that, and it was not true. It now times itself and reports the rhythm it actually keeps.\",\n evidence: \"The page was saying 'last checked 26 minutes ago' and 'it runs every 15 minutes' at the same time, which cannot both be right. It now measures the gaps between runs and reports what it sees.\",\n },\n {\n at: \"2026-08-01\",\n kind: \"mine\",\n what: \"I sent you a draft of the follow-up messages as though it were the finished thing, and you spent an evening reading the wrong version. That was mine, and the replacement was generated from the live system so it could not happen the same way twice.\",\n evidence: \"Every write-up you have had since is generated from the running system rather than typed, so what you read is what would send.\",\n },\n {\n at: \"2026-08-02\",\n kind: \"mine\",\n what: \"I gave you a missed-calls figure that was too high, because it was counting people arriving at the gate as well as people calling. You spotted it before I did.\",\n evidence: \"Recounted with gate arrivals excluded, and the same exclusion now runs on every list that comes out of here.\",\n },\n {\n at: \"2026-08-03\",\n kind: \"mine\",\n what: \"I told you a list had been deleted and then left the old one sitting in your Drive for a day. Two versions of the same list is exactly the confusion I was trying to save you from.\",\n evidence: \"The old one is in the trash and the folder was checked afterwards; only one version exists.\",\n },\n {\n at: \"2026-08-03\",\n kind: \"mine\",\n what: \"You asked me something at 8:20 that morning and my reply at 8:27 answered everything except that. Answered since.\",\n evidence: \"Both messages re-read against each other so the gap could be found rather than assumed.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"found\",\n what: \"Once it was measured, the follow-up system turned out to be running about hourly and the watchdog slower still, rather than four times an hour as this page used to claim. Nothing is harmed by that, because the messages are scheduled by the day, but it was worth knowing rather than assuming.\",\n evidence: \"Both were watched without being touched, then run by hand to confirm the code itself was healthy. Both ran cleanly. Do not read the rhythm off this line: the health card above measures the gaps between actual runs and prints what it currently observes, which is the only figure either of us should trust.\",\n },\n {\n at: \"2026-08-04\",\n kind: \"mine\",\n what: \"The count of new customers on this page was reading low. It was looking at only the most recent slice of your records, which missed anyone who first got in touch a while ago and only became a customer this week.\",\n evidence: \"The whole Customer list is now read every time rather than the first slice of it, in about a second. For the last seven days that changed the figure from 2 to 5.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"found\",\n what: \"The second system that checks the first one was set to look once a day, not once an hour. It has been changed to hourly. Nothing was broken; it was just looking far less often than the things it watches can go wrong.\",\n evidence: \"Read off its own settings screen: it said once every 1 days, and its last run had been 13 hours earlier. The follow-up system runs on the hour, so a problem starting just after the checker looked could have sat unnoticed until the next day. It now runs hourly, which matches what it is checking. Everything it looks at was still being looked at throughout.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"mine\",\n what: \"This page told you the checker runs itself about every 95 minutes. That came from the times Amir had started it by hand, so it was a real measurement of the wrong thing. I then went further and wrote that its timer was not firing at all. That was wrong twice over: it was firing, and the only reason my new counter showed nothing was that the counter itself was broken.\",\n evidence: \"The two kinds of run are recorded separately now, and both were watched working before this was written: a scheduled run recorded as scheduled, a hand-started one as by hand. The page no longer guesses at causes either. It reports what it has and has not seen and leaves the diagnosing to a person, which is what I should have done before writing that sentence the first time.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"mine\",\n what: \"Two of our systems were describing the same pile of unmatched counter sales with different figures. One said 35 sales worth $23,463.99, the other said 40 worth $28,035.99.\",\n evidence: \"The payment records were counted again from scratch, a third time and by a different method: 40 is correct. The lower figure came from skipping some sales and from subtracting two things that were not the same kind of thing. Both systems now read the same single count, so they cannot disagree again.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"found\",\n what: \"On your missing call transcripts, a correction of ours. This page said earlier that day that transcription had never been switched on. That was wrong: a call from that morning was opened and its full written transcript was watched rendering. Transcription works, at least sometimes, so the real question is which calls are missing theirs.\",\n evidence: \"The wrong version was reasoned from the reading connection, which never carries transcripts, and that gap was mistaken for the transcripts not existing. The corrected question is on the list above: one example from Kim of a call that should have a transcript and does not is the fastest way to pin down the pattern.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"built\",\n what: \"The missing third step is built. Something now works out which of your inquiries is about a puppy, and it runs alongside everything else so you can see what it would do before it does anything.\",\n evidence: \"It has applied nothing and it cannot: the part that decides has no way to change anything in your account, which is checked automatically. Its first run over your most recent contacts is on the question list above, with its own numbers. A full pass over 1,200 of your records is written up separately for Amir to check line by line.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"mine\",\n what: \"My first attempt at spotting a puppy inquiry would have signed up three people who should not have been: a man asking to buy a puppy, a woman rehoming her older dogs, and a dog described as three years and four months old that got read as four months.\",\n evidence: \"Each of those three is now a rule, each rule has a test, and each test has a check that breaks the rule on purpose and demands the test notice. None of them reached anybody, because nothing has been switched on.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"found\",\n what: \"One of your knowledge bases was edited at around half past ten the night before, and nothing was keeping an eye on it. If that was you, everything is fine and this is just us noticing.\",\n evidence: \"The consolidated one, which is what Chloe answers customers from. Nothing on our side touched it. Until the following morning we were watching your 165 automations for changes but not the documents that decide what your business actually says, which was a gap.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"built\",\n what: \"Your knowledge bases are now watched the same way your automations are. If one of them changes, it gets written down with what moved and when, whoever did it.\",\n evidence: \"Running live. It cannot read the wording inside the documents, only that something changed and which one, so it will not police your writing. The part that spots a change is tested on its own, including the case that matters most: a document edited in place, where nothing is added and nothing is removed.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"mine\",\n what: \"The counter I built to prove the checker keeps its own time was itself broken, and it made a healthy system look dead. It recorded nothing for scheduled runs, so the page reported none had happened while they were happening every hour.\",\n evidence: \"Found by opening the running record rather than trusting my own counter: the scheduled runs were there, one line away from where I was looking. Both kinds of run have now been watched being recorded correctly, one of each, before this was written down.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"fixed\",\n what: \"The two contact records for Kristina were merged into one, exactly as you asked. The phone number that survived is the one she actually rang from, the accidental do-not-disturb is off, her Meet and Greet is untouched, and the typo number is gone.\",\n evidence: \"Her inbound call that morning proves which number is real, so that one was kept. The duplicate had also been dropped into the no-sale and tips nurtures, which would have messaged a person who has an appointment booked on Monday; those did not carry over, and one click puts them back if wanted.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"built\",\n what: \"The first two real puppy inquiries are marked and waiting: Walle's owner, whose Pup Talk was that afternoon, and Kristina, who was marked that morning. Nothing sends to either of them while practice mode is on, and the system deliberately stays quiet for anyone with a call still on the calendar.\",\n evidence: \"Both are visible in the count on this page, which reads your records live. The one switch that remains is the practice-mode switch, and that gets thrown deliberately, not quietly.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"changed\",\n what: \"Walle's owner came off the puppy track before it ever sent her anything, and that is the agreed rule working: she booked. Her Free Training Day is on the calendar for Friday morning, her Pup Talk moved to Thursday afternoon, and during those changes the puppy mark came off her record. One inquiry is marked and waiting now, Kristina.\",\n evidence: \"Read live from her record on the evening of 5 August: the Friday booking is on the calendar, the mark is off, and the count on this page reflects whatever is true when you open it. If she should get the puppy messages after her visit anyway, putting the mark back is one click.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"found\",\n what: \"The tag red flag turns out to be wired to a workflow that came with your system: anyone who gets that tag is switched to do-not-disturb. It was put on five people this week, and all five are on do-not-disturb right now, which means nothing will message them.\",\n evidence: \"Each of the five records was opened and read live on the evening of 5 August, and every one shows do-not-disturb on. They are listed by name in the tag report. Taking the tag off does not switch do-not-disturb back off on its own.\",\n },\n {\n at: \"2026-08-07\",\n kind: \"mine\",\n what: \"Two customers could have dropped off your deposit list without anything looking wrong. You have two boarding calendars because a customer can be on either one, and the list is both of them put together. If one calendar failed to answer — a bad connection is enough, and there was no retry — the shorter list was saved over the full one with a fresh timestamp. Anyone who only appears on the calendar that failed was not marked unknown. They were simply gone.\",\n evidence: \"Reproduced end to end before it was fixed: a run reading one of the two calendars dropped a real customer and was still accepted for saving. It now refuses to replace a saved list with one that saw fewer calendars, so the page goes visibly older instead of quietly shorter. A calendar you actually delete still saves normally, and the first run of all still saves even if a calendar is down, because a partial list with a warning on it beats no list.\",\n },\n {\n at: \"2026-08-07\",\n kind: \"mine\",\n what: \"Where two of your bookings sat on the same day, which one the deposit counted against was decided by the order the bookings happened to come back in. Nothing was ever double counted, but a row could move between 'Payment on file' and 'Worth a look' from one hour to the next with nothing changing on your account. The oldest payment now settles the oldest stay, every time.\",\n evidence: \"Found by shuffling the same customer's bookings and payments 841,000 times and comparing the answers. It also fixed a second case: two deposits paid weeks apart, where spending the newer one first left the later stay looking unpaid when it had been paid all along.\",\n },\n {\n at: \"2026-08-07\",\n kind: \"mine\",\n what: \"The deposit page said a missing deposit might have been paid by cash. Your money page lists four ways to pay and cash is not one of them, so that was sending you to look somewhere that does not exist. It names Venmo, Zelle and cheque now, which are the three your card system genuinely cannot see.\",\n evidence: \"Checked against your own money page, which lists Card, Venmo, Zelle and Cheque and nothing else.\",\n },\n {\n at: \"2026-08-08\",\n kind: \"mine\",\n what: \"Friday's report said 120 of your 149 new people had no source recorded and none came from Facebook. That was wrong, and it was wrong because it read the one box in your CRM that is usually empty instead of the ad-tracking record that sits on every one of them. The truth: 117 of the 149 came from Facebook and 10 more from Instagram, and most carry the exact ad that brought them in. A corrected report is owed and coming.\",\n evidence: \"Re-pulled twice on 9 August by two people working separately, from two different doors into your CRM, and the two answers matched to the digit: 117 Facebook, 10 Instagram, none without a tracking record.\",\n },\n {\n at: \"2026-08-08\",\n kind: \"built\",\n what: \"The Friday report went over: what the ads cost, what came in, and where the money side still cannot be answered from your CRM. One line in it was wrong and was corrected the same night, and that correction is the entry above.\",\n evidence: \"Sent on Upwork Friday 11:46 PM with the five page report attached at 12:03. Both are in the thread.\",\n },\n {\n at: \"2026-08-09\",\n kind: \"built\",\n what: \"Facebook finally lets this page read your ad spend. The permission that was missing since the connection was first built is granted, so the advertising card below now shows real dollars from Facebook's own records every time the page loads, instead of saying it is not allowed to look.\",\n evidence: \"Watched working today: the page read $671.72 of spend and 159 started conversations for the last 7 full days, straight from the ad platform, minutes after the permission went on.\",\n },\n {\n at: \"2026-08-09\",\n kind: \"changed\",\n what: \"Your Wednesday answers are in the copy. Message two now opens on the welcome instead of 'I got your message'. Nothing says 'pitch' anymore, it just says what a Pup Talk is. The 'I won't chase you' lines are gone and the 'call any time' lines stay. 'Getting on' reads 'going'. The July and August notes carry the water warning for hot days, and August mentions school going back.\",\n evidence: \"Each change is pinned by its own automated check, so the wording cannot quietly drift back. The two write-ups you have were regenerated from the changed copy today.\",\n },\n {\n at: \"2026-08-09\",\n kind: \"found\",\n what: \"You asked Thursday for two calendars, a Free Training Day pick up and a second Pup Talk calendar for Candace, both by Tuesday. Then Friday evening you and Kristian agreed nothing changes in calendars or workflows until his handover is checked and written down. Those two collide, so the calendars wait for your word rather than being built into a freeze you asked for.\",\n evidence: \"Both are in writing: your Thursday messages on Upwork, and the Friday emails where the freeze was agreed.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"built\",\n what: \"The deposit list keeps itself up to date on its own now. It checked itself at 21:49 that evening with nobody asking it to, and it will do that every hour.\",\n evidence: \"Watched, not assumed. It refreshed by itself at 20:49 and again at 21:49 on 6 August, and the page records which schedule did it so there is no guessing. If a refresh ever fails, the page says how long ago it last managed one and warns you before you act on a name that might be a day old.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"mine\",\n what: \"I had the deposit check charging $50 a stay. Your own money page says $50 per dog, and it was sitting in the handover pack the whole time. Jeffrey Musselwhite has three dogs in over Thanksgiving: that is $150, and one $50 payment would have marked the whole stay settled and taken him off your list.\",\n evidence: \"Fixed and checked against your live account at 20:31 on 6 August. His row now reads $150.00, three dogs at $50. It settles on one payment for the full amount, or on one $50 payment per dog, and on nothing else.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"mine\",\n what: \"The deposit page was telling you a missing deposit might have been paid in cash or over the phone. Your website takes Venmo, Zelle and cheques as well, and none of those reach the card system either. It now names all three, because knowing where else to look is the difference between a ten-second check and a phone call.\",\n evidence: \"Taken from your own money page: card is the only route that matches itself to a customer record automatically. Venmo, Zelle to your email address, and cheques by post all land somewhere this cannot see.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"built\",\n what: \"The holiday deposit check you asked for is on your page. It reads both boarding calendars for Thanksgiving week and 20 December to 2 January, puts one customer's dogs on one line, leaves out your regular weekly bookings and anything cancelled, and shows which stays have a card payment on file. Right now that is two stays, both worth a look.\",\n evidence: \"It ran against your live account at 15:42 on 6 August and the list came back in under three seconds. Jeffrey Musselwhite's three dogs on 25 November show as one stay, not three, and Enzo's standing Friday slot is left out even though it lands inside every holiday window. It will never say somebody has not paid: a deposit handed over in cash or taken on the phone does not reach the card system, so this is a shortlist to look at.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"found\",\n what: \"Your card payments do reach your CRM after all, in two different shapes, and one of them was invisible to me until that morning. Some land as a plain payment line; others land as a till payment matched to a card payment later. I had only been reading the first kind.\",\n evidence: \"Both shapes are sitting on the same customer's record right now with the same $35 on them and two different reference numbers. If somebody's only record had been the second kind, the deposit check would have shown them as having nothing on file. It reads both now, and where the same money appears twice it is counted once rather than doubled.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"mine\",\n what: \"Twice today I had the deposit check guessing which card payment was the deposit, and twice it was wrong in the direction that costs you money. The first version treated any payment between the booking and the stay as the deposit, so a customer's $355 training package marked their $50 as settled. The second only looked at the ten days around the booking, which then missed a real $50 paid eight days later.\",\n evidence: \"It has stopped guessing. A stay is only marked settled by a card payment for exactly $50. Everything else on the account near that stay is listed with its date and amount and left for you to judge, which is the two-second version of what you were doing by hand. A wrong 'worth a look' costs you a glance. A wrong 'settled' costs you fifty dollars and you never find out.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"built\",\n what: \"The deposit list now knows how long a stay actually is, by reading your pick-up calendars as well as your drop-off ones. Jeffrey's three dogs show as 25 to 28 November rather than a single day, and anybody who drops off before a holiday and stays through it now appears at all.\",\n evidence: \"A drop-off booking in your system is a ten minute slot, so on its own it cannot say how long a dog stays. Checked against your live calendars on 6 August: Ghost and Chewy drop off on the 25th and are collected on the 28th, and only the pick-up calendar says so. If a pick-up calendar does not answer, the page says so rather than quietly showing a shorter list.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"mine\",\n what: \"The first time the deposit check ran for real it was about to tell you your card payments had stopped working, on the strength of two customers with nothing on file. Two quiet customers is a normal week, not an outage. I had written the warning to fire whenever nobody at all had a payment, without asking how many people that was.\",\n evidence: \"Caught by watching the first live run at 15:41 on 6 August rather than by reading the code. It now needs at least five customers checked before it will suggest anything is wrong with the payment feed, and the second run at 15:42 gave you the plain list instead of the warning.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"mine\",\n what: \"I told you the customer chased after booking was the only one it had ever happened to. That was wrong, and I said it with more confidence than my checking deserved. Four people were chased after they had already booked, going back to April: Brianna Badger, Janiya Williams, Michelle Burkard and Thomas.\",\n evidence: \"The first answer came from looking at two people with upcoming bookings. The real one comes from every Free Training Day booking you have ever taken, 80 of them across 69 people, each checked against their own messages. Three of the four came to their session anyway. Michelle's first booking was cancelled after her chase and she rebooked five days later, which is an order of events rather than a proven cause.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"found\",\n what: \"Your missing call transcripts, with one thing I got ahead of myself on. No transcript exists on any call older than about three months, and since then almost everything with speech on it has been written down. I told you that was the date transcription got switched on. I cannot actually tell that from here.\",\n evidence: \"207 calls were opened one at a time, everything inside your hundred most recently active conversations, and each was asked directly for its transcript and its recording. Before 11 May: 45 calls, none transcribed, though 38 of them still play their audio. From 11 May: 162 calls, 127 transcribed. Of the 35 without, 31 were nobody answering and 2 failed to connect. In that sample one call was recorded and never written down, on 4 August at 11:09 in the morning. The honest part: the oldest transcript we can find is 87 days old, which is either the day it was switched on or the age at which transcripts get deleted. Those look identical from here. If they expire, you are losing a month of call history every month, so it matters. One query in a week settles it: if the oldest surviving transcript has moved forward, they expire. That check is now on the list.\",\n },\n {\n at: \"2026-08-06\",\n kind: \"built\",\n what: \"While practice mode is on, the parts that actually send a text or an email now refuse anyone except the single test record, and they refuse from a standing start rather than after being told who is safe.\",\n evidence: \"The refusal sits inside the sending functions themselves, so it holds even if something upstream enrolled the wrong person by mistake. It is switched on and running now. There is a test that proves it, and a second check that deletes the guard on purpose and demands that test go red.\",\n },\n {\n at: \"2026-08-05\",\n kind: \"fixed\",\n what: \"A customer who had already booked his Free Training Day got chased by an older funnel to book one, two texts, a voicemail and another text, because that funnel only counts bookings made through its own page and cannot see the calendar. He was taken out of it at half past six that evening.\",\n evidence: \"His record shows no active workflows since the removal, checked after a full page reload. At the time this was written I had checked the two other people with upcoming bookings and found them clean. That was too small a check to carry the sentence it was carrying, and the entry above from 6 August corrects it: four people have been chased after booking, not one. The follow-up system on this page had nothing to do with it: practice mode was on all day and it sent nothing, checked live the same evening.\",\n },\n // THE GO-LIVE. Written 14 Aug 2026, dated to the day it happened. The 5 August entry above,\n // which says nothing sends while practice mode is on, is left exactly as it was: it was true on\n // 5 August and a work log that edits its own past is not a work log. This is its successor.\n {\n at: \"2026-08-11\",\n kind: \"changed\",\n what: \"The puppy follow-up system came out of practice mode and went live on the evening of 11 August, with your written go-ahead that day, and it has been sending to real people ever since. Two people joined it that evening and both have since had the first two messages. The 5 August note saying nothing sends to anybody while practice mode is on was true on 5 August; this is where it stopped being true.\",\n evidence: \"Open your control panel and the banner across the top says the word LIVE where it used to say PRACTICE MODE. It reads that from the system's own record every time the page loads, so it is not a note somebody typed and forgot. Both of those two people joined at 5:25 in the afternoon on 11 August, Georgia time. To see the messages rather than take my word for it, open either of them in Conversations in your CRM: the texts are sitting in the thread with the date and time on each one.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"For three days after it went live, this page kept telling you it had not been switched on. Four things on it said so: the question card asking when we should do the switch-on together, the line under the wording question saying it still does not send, the line under the domain question saying texting can still go live on its own, and the line at the very top saying three questions were holding up go-live. All four were written before 11 August and not one of them was rewritten when the day came. They are corrected now, and what actually happened is the 11 August entry.\",\n evidence: \"The system's own record has read live rather than practice since 11 August, and the last message to each of those two people went out on 12 August, so the page was disagreeing with the machine it was describing for three days in writing to you. The four sentences are named above rather than quietly swapped out, because you should be able to hold what you read earlier in the week against what this page says now. Nothing was sent or held back because of the wording; what it cost you was three days of not being able to trust the page.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"Your control panel could tell you the follow-up system was not running when it was running perfectly. It used to expect a check four times an hour, so any gap past an hour turned the top of that page red and told you to call Amir. The system actually checks about once an hour, and the ordinary gap between checks runs a few minutes either side of that, so the red could appear for a minute or two and clear itself with nothing wrong.\",\n evidence: \"Measured from the system's own list of when it last checked itself, which your control panel already shows: over the most recent 39 gaps the longest was 64 minutes, and four of them ran past the point where the old warning would have fired, for about five minutes in total. It now waits for two checks to be missed before it says anything, and the sentence it prints says once an hour rather than the old wrong number.\",\n },\n // 14 AUGUST, SECOND PASS. Everything below was found by reading the live control panel line by\n // line and holding each sentence against the code that decides it. Four of them were instructions\n // to Kim that would not have worked, and those are the ones that matter: a wrong number on a page\n // is embarrassing, but an instruction that does nothing costs her an afternoon and her trust.\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"The tile on your control panel that counts people the system could not reach told you to fix their details in your CRM. Doing that would have changed nothing. Once the system had given up on somebody, nothing you could do put them back on the follow-up: they were locked out for 60 days no matter what you fixed. The way back in now works, and the tile tells you the three steps in the order that works.\",\n evidence: \"The tile reads zero today, so nobody has been left stuck by this. It was found by reading the enrolment code rather than by waiting for it to bite: the check that decides who may join skipped anybody the system already had a record of, and that record is exactly what it writes when it gives up. Amir has since changed the engine so that fixing the record and re-tagging really does bring somebody back, and there is an automated check that breaks on purpose if that stops being true. The order matters and the tile now says so: put a phone number or an email address on the record first, then take the tag off, because doing it the other way round looks like nothing happened.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"The same tile also told you it never resets. It does reset: the system clears somebody out 60 days after it stopped trying to reach them, and the count comes down then. It now says that instead.\",\n evidence: \"The 60 days is in the housekeeping step the system runs at the end of every check, and there is an automated check that fails if that step is ever removed. What the old sentence was reaching for is still true and still said: unlike the Problems today tile beside it, this one does not go back to zero at midnight.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"The instruction on your control panel for taking one person off every track was wrong in two ways. It said switching on Do Not Disturb takes them off everything, permanently, within about an hour. Your CRM has three Do Not Disturb switches on a contact, not one: a main one, and separate ones for texts and for emails. Only the main one stops everything, and the other two stop just the thing they name, so switching off texts would have left the emails running. The hour was wrong too: the system does not look at somebody again until their next message is due, which can be up to a day.\",\n evidence: \"Your own contact records are the reason this was worth correcting rather than a hypothetical: several of them carry the texts-only switch turned on while the main switch is off, which is the exact combination the old sentence got wrong. Nobody was messaged in the gap, and nobody could have been, because the only moment the system would send to a person is the same moment it re-reads their switches, so this cost you nothing and was still not true. Both points are now spelled out on the page, including which switch is the one that stops everything.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"mine\",\n what: \"Your list of the last things the system did had been taken over by one line repeating. 39 of the 40 rows were the same sentence, once an hour for two days: one person who already has a booking, being passed over again on every check. Everything else the system had done was pushed off the end of the page where you could not see it. Repeats are now folded into a single row that says how many times and over what period, and the page states the sum so you can check nothing was dropped.\",\n evidence: \"You can see this for yourself against what the page looked like on 13 August: the same table now shows the repeat once, with its count, and the note under it says how many rows and how many folded repeats add up to how many entries. Amir has separately stopped the system writing the same line over and over in the first place, so the list fills up with real history from here. The list also now shows times in Georgia time; before this it printed them four hours ahead, so a message sent at five in the afternoon read as nine at night.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"changed\",\n what: \"The shouting is gone from your control panel. Every heading on it was being forced into capitals, and the banner said RUNNING NORMALLY, so you asked us to stop. Headings and labels are in ordinary sentence case now.\",\n evidence: \"It was one line of styling turning all of the headings into capitals rather than anything typed that way, which is why it was consistent and why fixing it fixed all of them at once. The two words spelled FAILED in the middle of a sentence were typed, and those are corrected separately.\",\n },\n {\n at: \"2026-08-14\",\n kind: \"fixed\",\n what: \"Your status page was one failed read away from telling you the follow-up was still in practice mode. It would only have shown while nobody was partway through the sequence, which is why it had not happened yet, and it was the same false sentence you were shown from 11 to 14 August arriving by a different route. The page can now say it does not know, and says that instead of guessing.\",\n evidence: \"It was found by reading the page's own logic rather than by it happening to you: the box that names practice or live was already careful, but the paragraph two lines under it was reading a different record and defaulting to practice when that record did not answer. Both now depend on the same check. There is an automated test that puts the page in exactly that state and demands it say it could not tell, and a second check that removes the fix on purpose and requires the first one to go red.\",\n },\n];\n\nexport function mergeLog(seeded: WorkEntry[], live: WorkEntry[] | null | undefined): WorkEntry[] {\n const all = [...seeded, ...(Array.isArray(live) ? live : [])];\n const seen = new Set();\n const out: WorkEntry[] = [];\n for (const e of all) {\n if (!e || typeof e.at !== \"string\" || typeof e.what !== \"string\" || !e.what.trim()) continue;\n // v1.1 (review #6): dedupe on the FULL sentence. A 60-character prefix collapsed two\n // different outages on the same day into one row, so the second incident never reached Kim.\n const key = `${e.at}|${e.kind}|${e.what}|${e.evidence ?? \"\"}`;\n if (seen.has(key)) continue;\n seen.add(key);\n out.push(e);\n }\n // newest first. Within one day the LATEST-added entry leads, so a broke/recovered pair on the\n // same date reads \"back to normal\" above \"broke\", which is the order a human wants to see.\n return out\n .map((e, i) => ({ e, i }))\n .sort((a, b) => (a.e.at === b.e.at ? b.i - a.i : (b.e.at > a.e.at ? 1 : -1)))\n .map((x) => x.e);\n}\n\nexport const KIND_LABEL: Record = {\n mine: \"My mistake\",\n fixed: \"Fixed\",\n built: \"Built\",\n found: \"Found\",\n broke: \"Broke\",\n recovered: \"Back to normal\",\n changed: \"Changed\",\n};\n","label",[184],"5124a7e0-2efc-42c2-8068-dc5528c65154","watch.ts","ff74119a-9822-11f1-b353-1607ee4eb77e",1230,["D",1787226707632],4,"// THE EARLY WARNING MONITOR. v1.0, 12 Aug 2026. Rebuilt 14 Aug 2026 from tests/watch.test.mjs.\n//\n// WHAT THIS IS FOR. On 19 February 2026 this account's CRM stopped recording payment amounts.\n// Bookings carried on arriving at full volume; the dollars written against them went to zero.\n// Nothing failed, so nothing errored, so nothing alerted, and every count on every page stayed\n// healthy. It ran for five months and cost a five-figure sum before a human happened to look.\n//\n// THE RULE THAT FOLLOWS FROM THAT (LESSONS #12): an absence raises no error, so something has to\n// watch the place where a thing used to be. Volume and value are watched TOGETHER, because either\n// one on its own reads as an ordinary business having an ordinary month.\n//\n// FIVE CHECKS, EACH MEASURED AGAINST THE SOURCE'S OWN HISTORY rather than against a number\n// somebody typed:\n// 1. silenceFindings a source that normally produces records has produced none for\n// longer than its own normal quiet spell.\n// 2. matchRatioFindings payments still arriving, the matched share collapsing against its\n// own recent baseline.\n// 3. revenueChannelFindings activity continuing while the money against it goes to zero. This\n// is the February shape, and it is the reason the file exists.\n// 4. bridgeFindings the Square link erroring now, or its journal no longer growing.\n// 5. backwardsFindings a figure that can only ever grow has gone backwards, which usually\n// means a source was swapped, truncated, or read from somewhere else.\n//\n// THREE DESIGN RULES THIS FILE IS BUILT AROUND, each of them paid for:\n//\n// A CHECK THAT INSPECTED ZERO ITEMS RAISES A FINDING ABOUT ITSELF (LESSONS #2). This project has\n// already shipped an audit that scanned zero files and reported all clear. On a monitor that is\n// worse than useless: \"nothing wrong\" and \"nothing looked at\" render identically on the page, and\n// the second one reads as reassurance. So every check returns the size of what it read, every\n// check that read nothing says so in an urgent finding, and blindSpots() is the backstop that\n// refuses to let a silent zero through.\n//\n// A BASELINE BELOW A MINIMUM POPULATION SAYS \"CANNOT JUDGE\" OUT LOUD (LESSONS #13). Replayed\n// against the real history as it stood on 15 March 2026 the revenue check fired and produced\n// \"47 bookings were recorded, which is the same as usual or more, and the money came to $50.00.\n// Over the 6 periods before it the usual figures were 2 bookings and $550.00.\" The arithmetic was\n// right and the sentence was nonsense, because the baseline was this account's first weeks in the\n// CRM. A sentence that reads as a glitch spends the credibility the real alarm will need, so a\n// thin baseline is declared unjudgeable rather than either accusing or passing.\n//\n// EVERY SENTENCE IS GENERATED FROM THE VALUES IT DESCRIBES (engine/facts.ts, header). Nothing in\n// here types a figure alongside the number it is meant to describe. Change an input and the words\n// move with it, or the two can silently disagree, which is how every wrong claim in this project\n// got out.\n//\n// CLIENT COPY RULES, enforced mechanically by copyProblems() over the generated report: no dashes\n// used as punctuation, and never the name of a service this business does not offer.\n//\n// READ ONLY. Nothing in this file fetches, writes, deploys or schedules anything. It is handed\n// data by scripts/watch-run.mjs and hands back a report.\n\n// ---------------------------------------------------------------------------------------------\n// THE SHAPES\n// ---------------------------------------------------------------------------------------------\n\n/** urgent: look today. attention: look this week. note: the monitor talking about itself. */\nexport type Severity = \"urgent\" | \"attention\" | \"note\";\n\nexport type Finding = {\n check: string; // which check raised it, so the report can group them\n severity: Severity;\n sentence: string; // plain words, generated from `numbers`, safe to send\n numbers: Record; // the figures the sentence was built from\n checkFirst: string; // the first thing to open, in her words not mine\n};\n\nexport type CheckResult = {\n check: string;\n title: string; // how the check is named in the report\n inspected: number; // HOW MUCH IT READ. Zero is a finding, never a pass.\n inspectedLabel: string; // what those items are, for the sentence that reports it\n measured: Record; // the workings, kept so a queried figure can be traced\n findings: Finding[];\n};\n\nexport type WatchReport = {\n generatedAt: string;\n headline: string;\n inspected: number;\n checks: CheckResult[];\n findings: Finding[];\n};\n\nexport type Stream = { name: string; timestamps: unknown; whereToLook?: string };\nexport type RatioPoint = { label?: string; endMs?: number; total: number; matched: number };\nexport type RevenuePeriod = { label?: string; endMs?: number; activity: number; dollars: number };\nexport type Snapshot = { at?: string; counters?: Record };\n\nexport type WatchInput = {\n nowMs?: unknown;\n streams?: unknown;\n ratio?: { subject?: string; points?: unknown } | null;\n revenue?: { subject?: string; periods?: unknown } | null;\n journal?: unknown;\n snapshots?: unknown;\n counterLabels?: Record | null;\n};\n\nconst HOUR = 3_600_000;\n\n// ---------------------------------------------------------------------------------------------\n// THE CONSTANTS, and why each one is the number it is. Every one of these is a judgement about\n// how loud this thing should be, so each is named, exported and testable rather than buried at a\n// call site where nobody can find it to argue with it.\n// ---------------------------------------------------------------------------------------------\n\n/** Below this many records a source has no rhythm worth quoting, and saying so is the honest move. */\nexport const MIN_RECORDS_FOR_RHYTHM = 5;\n\n/**\n * Only the most recent gaps are measured. A source that changes pace has to be able to\n * re-baseline: the payment feed moved from weekly invoicing to daily card takings in June, and a\n * rhythm averaged over all of history would still be judging today against a habit it dropped.\n */\nexport const MAX_GAPS_CONSIDERED = 30;\n\n/**\n * THE QUIET SPELL, not the longest outage. Read against the MAXIMUM gap in history, one bad\n * fortnight silently raises the bar past which any future outage would be reported: the next one\n * has to beat a record before anybody hears about it. The 90th percentile says \"longer than\n * almost every quiet spell this source normally has\" and cannot be dragged by a single hole.\n */\nexport const QUIET_QUANTILE = 0.9;\nexport const QUIET_MULTIPLE = 1.5; // half again past its own worst ordinary silence\nexport const NORMAL_MULTIPLE = 3; // or three times its ordinary gap, whichever is longer\n\n/**\n * THE OVERNIGHT FLOOR. New contact records arrive about every 25 minutes during the day and stop\n * at night. Judged on gaps alone that source is \"silent for twenty times its normal gap\" at 3am\n * every single night, and a report that cries wolf every morning is a report nobody opens on the\n * morning it is right. 26 hours clears a night, a weekend morning and a public holiday opening.\n */\nexport const MIN_EXPECT_HOURS = 26;\n\n/** Twice past the point where it became out of character is today's problem, not this week's. */\nexport const URGENT_MULTIPLE = 2;\n\n/** A collapse is a third of the baseline share gone AND ten points of it in absolute terms. */\nexport const RATIO_RELATIVE_FALL = 0.33;\nexport const RATIO_ABSOLUTE_FALL = 0.1;\n/** Half the baseline share gone is not a wobble, it is a fault, and it is today's problem. */\nexport const RATIO_URGENT_RELATIVE_FALL = 0.5;\n/** A verdict on two payments is not a verdict. Below this the check says so instead. */\nexport const RATIO_MIN_LATEST = 5;\n\n/** Four fifths of the usual money gone. A half is a trading question; this is a plumbing one. */\nexport const REVENUE_DOLLAR_FALL = 0.8;\n/** ...while at least half the usual amount of work still arrived. Both halves, or it is a slow month. */\nexport const REVENUE_ACTIVITY_HELD = 0.5;\n/** LESSONS #13. A baseline of two records a period cannot carry an accusation. */\nexport const REVENUE_MIN_BASELINE_ACTIVITY = 5;\n/** Fewer periods than this and there is no \"usual\" to compare the latest one against. */\nexport const REVENUE_MIN_PERIODS = 4;\n\n/**\n * The bridge is judged on its RECENT rows only. This journal holds 265 failures from three bad\n * days in July that were found and fixed. A check that fires on any error ever recorded is red\n * forever, and a permanently red check is a switched off one.\n */\nexport const BRIDGE_RECENT_ROWS = 100;\nexport const BRIDGE_ERROR_SHARE_URGENT = 0.2;\n\n// ---------------------------------------------------------------------------------------------\n// SAYING THINGS. Every one of these turns a value into words. Nothing below ever types a figure\n// beside the number it describes, which is the whole of engine/facts.ts in one rule.\n// ---------------------------------------------------------------------------------------------\n\nconst MONTH_NAMES = [\"January\", \"February\", \"March\", \"April\", \"May\", \"June\",\n \"July\", \"August\", \"September\", \"October\", \"November\", \"December\"];\n\n/** A duration in words that fit its size: minutes for an hour, hours for a day, days beyond that. */\nexport function sayGap(hours: unknown): string {\n const h = Number(hours);\n if (!Number.isFinite(h)) return \"an unknown length of time\";\n if (h <= 1) return `${Math.round(h * 60)} minutes`;\n if (h < 48) return `${Math.round(h)} hours`;\n const days = Math.round(h / 24);\n if (days < 60) return `${days} days`;\n // Past two months \"97 days\" stops meaning anything to a reader, so the months are said too.\n // Both figures, never the months alone: the day count is the one that can be checked.\n const months = Math.round(days / 30.44);\n return `${days} days, which is about ${months} months`;\n}\n\n/** A date a person can read, in UTC so a replay of a past morning says the same thing every time. */\nexport function sayDate(ms: unknown): string {\n const t = Number(ms);\n if (!Number.isFinite(t)) return \"a date this could not read\";\n const d = new Date(t);\n if (Number.isNaN(d.getTime())) return \"a date this could not read\";\n return `${d.getUTCDate()} ${MONTH_NAMES[d.getUTCMonth()]} ${d.getUTCFullYear()}`;\n}\n\n/** Money, always to the cent and always with its thousands separators. */\nexport function money(n: unknown): string {\n const v = Number(n);\n if (!Number.isFinite(v)) return \"an amount this could not read\";\n const [whole, frac] = Math.abs(v).toFixed(2).split(\".\");\n return `${v < 0 ? \"minus \" : \"\"}$${whole.replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\")}.${frac}`;\n}\n\nconst WORDS = [\"no\", \"one\", \"two\", \"three\", \"four\", \"five\", \"six\", \"seven\", \"eight\", \"nine\", \"ten\"];\nconst countWord = (n: number) => WORDS[n] ?? String(n);\nconst capitalise = (s: string) => s.replace(/^./, (c) => c.toUpperCase());\nconst plural = (n: number, one: string, many: string) => (n === 1 ? one : many);\nconst commas = (n: number) => Number(n ?? 0).toLocaleString(\"en-US\");\nconst percent = (x: number) => `${Math.round(x * 100)}%`;\n\n/** The subject as a bare noun: \"your bookings\" is what she calls them, \"bookings\" is what counts them. */\nconst unitOf = (subject: string) => String(subject ?? \"records\").replace(/^(your|the)\\s+/i, \"\");\n\n// ---------------------------------------------------------------------------------------------\n// THE MEASUREMENT. A rhythm read off the source itself.\n//\n// Everything else in this file rests on this function, so it is worth saying what it deliberately\n// does NOT do. It does not take a threshold. It does not know what kind of source it is looking\n// at. It reads the gaps between the things that actually arrived and reports how long this source\n// normally goes quiet for. A monitor built on typed thresholds is a monitor that is wrong for\n// every source but the one somebody had in mind when they typed it.\n// ---------------------------------------------------------------------------------------------\n\nexport type Rhythm = {\n records: number; // how many readable timestamps went into this\n gapsUsed: number; // how many gaps the figures below were measured from\n normalGapH: number; // the median gap: what \"usually\" means for this source\n quietGapH: number; // its ordinary worst quiet spell, at the 90th percentile\n longestGapH: number; // the worst hole in the history it was given, reported and NOT used\n expectByH: number; // past this it is out of character for this source\n};\n\n/** Every readable timestamp in a list, as milliseconds, oldest first. Unreadable ones are dropped. */\nexport function readTimes(list: unknown): number[] {\n if (!Array.isArray(list)) return [];\n const out: number[] = [];\n for (const v of list) {\n // A number is already milliseconds; anything else has to survive Date.parse to count.\n const t = typeof v === \"number\" ? v : Date.parse(String(v ?? \"\"));\n if (Number.isFinite(t)) out.push(t as number);\n }\n // SORTED, ALWAYS. The live feed comes back newest first, fixtures come back oldest first, and a\n // jittered series is in neither order. Measuring gaps off an unsorted list produces negative\n // gaps and a median that means nothing.\n return out.sort((a, b) => a - b);\n}\n\n/**\n * The rhythm of a source, or null when there is not enough of it to have one.\n *\n * Null is a real answer here, not a failure: it is what makes \"there is not enough history to\n * judge this\" sayable out loud instead of being rounded to either an alarm or an all clear.\n */\nexport function rhythmOf(list: unknown): Rhythm | null {\n const times = readTimes(list);\n if (times.length < MIN_RECORDS_FOR_RHYTHM) return null;\n const allGaps: number[] = [];\n for (let i = 1; i < times.length; i++) allGaps.push((times[i] - times[i - 1]) / HOUR);\n if (!allGaps.length) return null;\n // RECENT HISTORY ONLY, so a source that changes pace re-baselines instead of being judged\n // forever against a habit it has dropped.\n const gaps = allGaps.slice(-MAX_GAPS_CONSIDERED);\n const normalGapH = quantile(gaps, 0.5) as number;\n const quietGapH = quantile(gaps, QUIET_QUANTILE) as number;\n // The longest gap is REPORTED so it can be looked at, and deliberately not used as the\n // yardstick. See QUIET_QUANTILE above for what happens when it is.\n const longestGapH = Math.max(...allGaps);\n const expectByH = Math.max(quietGapH * QUIET_MULTIPLE, normalGapH * NORMAL_MULTIPLE, MIN_EXPECT_HOURS);\n return { records: times.length, gapsUsed: gaps.length, normalGapH, quietGapH, longestGapH, expectByH };\n}\n\n/** The value at a quantile, interpolated. Null on an empty list, never a confident zero. */\nexport function quantile(values: number[], q: number): number | null {\n if (!Array.isArray(values) || !values.length) return null;\n const a = [...values].sort((x, y) => x - y);\n const pos = (a.length - 1) * q;\n const lo = Math.floor(pos);\n const hi = Math.ceil(pos);\n if (lo === hi) return a[lo];\n return a[lo] + (a[hi] - a[lo]) * (pos - lo);\n}\n\n/** urgent once it is twice past the point where it stopped being in character, attention before. */\nconst escalate = (ageH: number, expectByH: number): Severity =>\n (ageH >= expectByH * URGENT_MULTIPLE ? \"urgent\" : \"attention\");\n\n// ---------------------------------------------------------------------------------------------\n// A CHECK THAT READ NOTHING.\n//\n// This is the single most important function in the file, which is why it is this near the top.\n// Every check routes its empty case through it, so there is exactly one place where \"I inspected\n// nothing\" is turned into words, and exactly one place to break in order to prove the whole\n// arrangement still works (tests/negative-controls.mjs does exactly that).\n// ---------------------------------------------------------------------------------------------\nexport function blindCheck(check: string, title: string, inspectedLabel: string, why: string, checkFirst: string): CheckResult {\n return {\n check,\n title,\n inspected: 0,\n inspectedLabel,\n measured: { inspected: 0 },\n // SEVERITY STAYS \"urgent\" AND SIX TESTS HOLD IT THERE (W10, W19, W26, W31, W37, W42). A check\n // that read nothing must never be quiet. What was wrong was not the severity, it was the\n // HEADLINE: it counted blind spots as business problems and said \"two things need you to look at\n // today\" when both were unwired checks. That is fixed in headlineFor and in the section split\n // below, which separate \"a check found a fault\" from \"a check could not look\" WITHOUT making the\n // second one quiet. Relabelling this to \"note\" was tried on 16 Aug and the tests rejected it,\n // correctly: it is the guarantee, not the wording.\n findings: [{ check, severity: \"urgent\", sentence: why, numbers: { inspected: 0 }, checkFirst }],\n };\n}\n\n/**\n * THE BACKSTOP. Any check that inspected nothing and said nothing about it. This should always be\n * empty, because every check above routes its empty case through blindCheck. It is here because\n * \"should always be empty\" is exactly the kind of claim that quietly stops being true, and\n * scripts/watch-run.mjs refuses to write a report while this returns anything.\n */\nexport function blindSpots(checks: unknown): CheckResult[] {\n return (Array.isArray(checks) ? checks : []).filter((c) => c && c.inspected === 0 && (!c.findings || c.findings.length === 0));\n}\n\n/**\n * A finding is blind only when its owning check inspected no evidence. `finding.numbers` is\n * explanatory working supplied by the check and is deliberately not an authority boundary.\n */\nexport function isBlindFindingForChecks(finding: unknown, checks: unknown): finding is Finding {\n if (!finding || typeof finding !== \"object\" || Array.isArray(finding) || !Array.isArray(checks)) return false;\n const ownerName = (finding as { check?: unknown }).check;\n if (typeof ownerName !== \"string\") return false;\n return checks.some((candidate) =>\n !!candidate && typeof candidate === \"object\" && !Array.isArray(candidate) &&\n (candidate as { check?: unknown }).check === ownerName &&\n (candidate as { inspected?: unknown }).inspected === 0);\n}\n\n// ---------------------------------------------------------------------------------------------\n// CHECK 1: SILENCE WHERE THERE SHOULD BE NOISE. This is the 19 February check.\n//\n// A source that normally produces records has produced none for longer than it normally goes\n// quiet. Every source is judged against its own rhythm: the payment feed against the payment\n// feed's habits, the fortnightly form payments against the fortnightly form payments'. Judging\n// them all by one clock is how the fortnightly source becomes a false alarm every fortnight.\n// ---------------------------------------------------------------------------------------------\n\nconst SILENCE = \"silence\";\nconst SILENCE_TITLE = \"Sources that have gone quiet\";\nconst SILENCE_LABEL = \"timestamps\";\n\nexport function silenceFindings(streams: unknown, nowMs: unknown): CheckResult {\n const now = Number(nowMs);\n const list = (Array.isArray(streams) ? streams : []) as Stream[];\n const prepared = list.map((s) => ({\n name: String(s?.name ?? \"a source with no name\"),\n whereToLook: typeof s?.whereToLook === \"string\" ? s.whereToLook : null,\n times: readTimes(s?.timestamps),\n }));\n const inspected = prepared.reduce((a, s) => a + s.times.length, 0);\n\n if (!Number.isFinite(now) || inspected === 0) {\n return blindCheck(SILENCE, SILENCE_TITLE, SILENCE_LABEL,\n `This check read nothing at all, so it cannot tell you whether anything has stopped arriving. ` +\n `A check that inspects nothing is a blind spot, not a clean result, and it is being reported as one.`,\n `Check that the connection to your CRM is still working, then run this again. Until it reads something, ` +\n `treat the sources it was meant to watch as unwatched rather than healthy.`);\n }\n\n const findings: Finding[] = [];\n const perSource: Record[] = [];\n\n for (const s of prepared) {\n const r = rhythmOf(s.times);\n if (r === null) {\n // NOT A SILENT PASS. A source nothing can be measured on is a source nothing is watching,\n // and she should be told that in the same breath as she is told everything else is fine.\n findings.push({\n check: SILENCE,\n severity: \"note\",\n sentence:\n `There is not enough history for ${s.name} to say what normal looks like: ${s.times.length} ` +\n `${plural(s.times.length, \"record\", \"records\")}, where this needs ${MIN_RECORDS_FOR_RHYTHM} before it can ` +\n `measure a rhythm. Nothing is watching this source yet, which is worth knowing rather than reading as a clean result.`,\n numbers: { source: s.name, records: s.times.length, needed: MIN_RECORDS_FOR_RHYTHM },\n checkFirst:\n `Nothing to do today. Once ${MIN_RECORDS_FOR_RHYTHM} records have arrived here this will start ` +\n `watching it on its own, and until then treat it as unwatched.`,\n });\n perSource.push({ source: s.name, records: s.times.length, rhythm: \"not enough history\" });\n continue;\n }\n const lastMs = s.times[s.times.length - 1];\n const ageH = (now - lastMs) / HOUR;\n perSource.push({\n source: s.name,\n records: r.records,\n normalGapH: Math.round(r.normalGapH * 10) / 10,\n quietGapH: Math.round(r.quietGapH * 10) / 10,\n expectByH: Math.round(r.expectByH * 10) / 10,\n quietForHours: Math.round(ageH * 10) / 10,\n });\n if (ageH <= r.expectByH) continue;\n const severity = escalate(ageH, r.expectByH);\n // THE FIRST MOVE. A stream that knows where its own answer lives brings its own sentence:\n // scripts/watch-run.mjs hands the payment feed one, because that is the stream whose silence\n // means what February meant. Everything else gets this, which is the same move generalised.\n const checkFirst = s.whereToLook ??\n `Open the Square app and compare what it has taken since ${sayDate(lastMs)} against what your CRM shows for ` +\n `${s.name}. If Square has money the CRM does not, sales are being rung up in a way that never reaches a customer record.`;\n findings.push({\n check: SILENCE,\n severity,\n sentence:\n `Nothing has come through from ${s.name} for ${sayGap(ageH)}. The last one was on ${sayDate(lastMs)}. ` +\n `Before that this source produced something every ${sayGap(r.normalGapH)} on average, and the longest it ` +\n `normally stays quiet is ${sayGap(r.quietGapH)}, so this is well outside its own habits rather than outside ` +\n `a figure somebody chose.`,\n numbers: {\n source: s.name,\n lastRecordAt: new Date(lastMs).toISOString(),\n quietForHours: Math.round(ageH * 10) / 10,\n normalGapHours: Math.round(r.normalGapH * 10) / 10,\n quietGapHours: Math.round(r.quietGapH * 10) / 10,\n outOfCharacterAfterHours: Math.round(r.expectByH * 10) / 10,\n recordsMeasured: r.records,\n },\n checkFirst,\n });\n }\n\n return {\n check: SILENCE,\n title: SILENCE_TITLE,\n inspected,\n inspectedLabel: SILENCE_LABEL,\n measured: { sources: prepared.length, timestamps: inspected, perSource },\n findings,\n };\n}\n\n// ---------------------------------------------------------------------------------------------\n// CHECK 2: A RATIO COLLAPSE. Payments still arrive; the share of them reaching a customer record\n// falls away against its own recent baseline.\n//\n// THE TRAP THIS CHECK HAS TO AVOID, and the reason W17 exists: nought matched out of nought\n// arriving is not nought percent matching. Calling it a collapse raises a second alarm for one\n// fault and names the wrong cause, sending her to look at the matcher when the payments never\n// arrived at all.\n// ---------------------------------------------------------------------------------------------\n\nconst RATIO = \"match-ratio\";\nconst RATIO_TITLE = \"Payments reaching a customer record\";\nconst RATIO_LABEL = \"payments\";\n\nexport function matchRatioFindings(points: unknown, subject: unknown): CheckResult {\n const what = String(subject ?? \"payments\");\n const list = (Array.isArray(points) ? points : []) as RatioPoint[];\n const clean = list.map((p) => ({\n label: String(p?.label ?? \"a window\"),\n endMs: Number(p?.endMs),\n total: Math.max(0, Number(p?.total) || 0),\n matched: Math.max(0, Number(p?.matched) || 0),\n }));\n const inspected = clean.reduce((a, p) => a + p.total, 0);\n\n if (inspected === 0) {\n return blindCheck(RATIO, RATIO_TITLE, RATIO_LABEL,\n `This check read no ${what} at all, so it cannot tell you whether they are still reaching a customer record. ` +\n `A check that inspects nothing is a blind spot, not a clean result, and it is being reported as one.`,\n `Check that the Square link is still running and still writing to its own log, then run this again.`);\n }\n\n const latest = clean[clean.length - 1];\n const base = clean.slice(0, -1);\n const baseTotal = base.reduce((a, p) => a + p.total, 0);\n const baseMatched = base.reduce((a, p) => a + p.matched, 0);\n const measured: Record = {\n windows: clean.length,\n payments: inspected,\n latestTotal: latest.total,\n latestMatched: latest.matched,\n baselineTotal: baseTotal,\n baselineMatched: baseMatched,\n };\n const result = (findings: Finding[]): CheckResult =>\n ({ check: RATIO, title: RATIO_TITLE, inspected, inspectedLabel: RATIO_LABEL, measured, findings });\n\n if (baseTotal === 0) {\n return result([{\n check: RATIO,\n severity: \"note\",\n sentence:\n `There is no earlier run of ${what} to compare the latest ${commas(latest.total)} against, so this cannot ` +\n `judge whether the share reaching a customer record has moved. It will be able to from the next run on.`,\n numbers: { subject: what, latestTotal: latest.total, baselineTotal: baseTotal, windows: clean.length },\n checkFirst: `Nothing to do today. This needs one more period of history before it can say anything useful here.`,\n }]);\n }\n\n if (latest.total === 0) {\n // AN ABSENCE, DESCRIBED AS AN ABSENCE. Never as a collapse to nought percent.\n return result([{\n check: RATIO,\n severity: \"note\",\n sentence:\n `No ${what} arrived at all in the latest window, so there is nothing to work out a share from. ` +\n `That is a different problem from the ones this check watches for, and the list of sources that have gone ` +\n `quiet is where it will show up.`,\n numbers: { subject: what, latestTotal: 0, baselineTotal: baseTotal, windows: clean.length },\n checkFirst:\n `Look at the sources that have gone quiet, further up. If nothing there names ${what}, open the Square app ` +\n `and check whether any sale has been taken at all in the last week.`,\n }]);\n }\n\n if (latest.total < RATIO_MIN_LATEST) {\n // LESSONS #13, in its other shape. A verdict on two payments is not a verdict.\n return result([{\n check: RATIO,\n severity: \"note\",\n sentence:\n `Only ${commas(latest.total)} ${plural(latest.total, \"payment\", \"payments\")} arrived in the latest window, ` +\n `which is too few to judge a matching rate on. This needs at least ${RATIO_MIN_LATEST} before it will call ` +\n `a fall in the share reaching a customer record, because a wrong alarm here spends the attention a real one will need.`,\n numbers: { subject: what, latestTotal: latest.total, needed: RATIO_MIN_LATEST, baselineTotal: baseTotal },\n checkFirst: `Nothing to do today. This will judge the share again as soon as a normal week's worth of payments has arrived.`,\n }]);\n }\n\n const baseShare = baseMatched / baseTotal;\n const latestShare = latest.matched / latest.total;\n const relativeFall = baseShare > 0 ? (baseShare - latestShare) / baseShare : 0;\n const absoluteFall = baseShare - latestShare;\n const fires = relativeFall >= RATIO_RELATIVE_FALL && absoluteFall >= RATIO_ABSOLUTE_FALL;\n measured.baselineSharePercent = Math.round(baseShare * 100);\n measured.latestSharePercent = Math.round(latestShare * 100);\n if (!fires) return result([]);\n\n const latestUnmatched = latest.total - latest.matched;\n return result([{\n check: RATIO,\n severity: relativeFall >= RATIO_URGENT_RELATIVE_FALL ? \"urgent\" : \"attention\",\n sentence:\n `${capitalise(what)} are still arriving, and the share of them reaching a customer record has fallen from ` +\n `${percent(baseShare)} to ${percent(latestShare)}. In the latest window ${commas(latestUnmatched)} of ` +\n `${commas(latest.total)} reached nobody at all. The money is still being taken; it is the record of who paid it ` +\n `that is going missing.`,\n numbers: {\n subject: what,\n latestTotal: latest.total,\n latestMatched: latest.matched,\n latestUnmatched,\n latestSharePercent: Math.round(latestShare * 100),\n baselineSharePercent: Math.round(baseShare * 100),\n baselineTotal: baseTotal,\n windowsCompared: clean.length,\n },\n checkFirst:\n `Open the Square link's own log and look at the most recent entries for a sale that did not find a customer. ` +\n `The weekly exception report lists every one of them by name and amount, and that is the list to work from.`,\n }]);\n}\n\n// ---------------------------------------------------------------------------------------------\n// CHECK 3: A REVENUE CHANNEL GOING QUIET WHILE THE ACTIVITY CONTINUES. THE FEBRUARY SHAPE.\n//\n// This is the one the whole file exists for. Six ordinary periods of about 45 bookings and about\n// $7,000 taken, then a period in which the same number of bookings arrived and not one dollar was\n// recorded against them. The live account did exactly that: 48 payment records and $7,386.50 in\n// February, then 37 records and $0.00 in March, 21 and $0.00 in April, 18 and $0.00 in May.\n//\n// BOTH HALVES OR NOTHING. Money down and work down together is a slow month, which she can\n// already see out of the window, and raising it would be inventing an alarm about business\n// conditions. Money down while the work held is a plumbing fault, and she cannot see that at all.\n// ---------------------------------------------------------------------------------------------\n\nconst REVENUE = \"revenue-quiet\";\nconst REVENUE_TITLE = \"Money recorded against the work\";\nconst REVENUE_LABEL = \"records of activity\";\n\nexport function revenueChannelFindings(periods: unknown, subject: unknown): CheckResult {\n const what = String(subject ?? \"your bookings\");\n const unit = unitOf(what);\n const list = (Array.isArray(periods) ? periods : []) as RevenuePeriod[];\n const clean = list.map((p) => ({\n label: String(p?.label ?? \"a period\"),\n endMs: Number(p?.endMs),\n activity: Math.max(0, Number(p?.activity) || 0),\n dollars: Math.max(0, Number(p?.dollars) || 0),\n }));\n const inspected = clean.reduce((a, p) => a + p.activity, 0);\n\n if (inspected === 0) {\n return blindCheck(REVENUE, REVENUE_TITLE, REVENUE_LABEL,\n `This check read no record of any work at all, so it cannot tell you whether the money against it is being ` +\n `written down. A check that inspects nothing is a blind spot, not a clean result, and it is being reported as one.`,\n `Check that the connection to your CRM is still working, then run this again. This is the check that would ` +\n `have caught the five month gap, so it reading nothing matters more than most.`);\n }\n\n const latest = clean[clean.length - 1];\n const base = clean.slice(0, -1);\n const measured: Record = {\n periods: clean.length,\n recordsOfActivity: inspected,\n latestActivity: latest.activity,\n latestDollars: latest.dollars,\n };\n const result = (findings: Finding[]): CheckResult =>\n ({ check: REVENUE, title: REVENUE_TITLE, inspected, inspectedLabel: REVENUE_LABEL, measured, findings });\n\n if (clean.length < REVENUE_MIN_PERIODS) {\n return result([{\n check: REVENUE,\n severity: \"note\",\n sentence:\n `There are only ${clean.length} periods of history for ${what}, and this needs ${REVENUE_MIN_PERIODS} before ` +\n `it can say what a normal period looks like. It cannot judge the latest one yet, and guessing would be worse ` +\n `than saying so.`,\n numbers: { subject: what, periods: clean.length, needed: REVENUE_MIN_PERIODS },\n checkFirst: `Nothing to do today. This will start judging as soon as there are ${REVENUE_MIN_PERIODS} periods to read.`,\n }]);\n }\n\n // THE BASELINE IS A MEDIAN, not an average. One freak month with a $4,000 boarding block in it\n // drags an average up and makes every ordinary month afterwards look like a collapse.\n const baseActivity = quantile(base.map((p) => p.activity), 0.5) as number;\n const baseDollars = Math.round((quantile(base.map((p) => p.dollars), 0.5) as number) * 100) / 100;\n measured.usualActivity = Math.round(baseActivity);\n // Keep the exact median as validation evidence. The rounded value is client-facing, but it is\n // not precise enough to prove the 50% activity-held boundary on its own.\n measured.baselineActivity = baseActivity;\n measured.usualDollars = baseDollars;\n\n if (baseActivity < REVENUE_MIN_BASELINE_ACTIVITY) {\n // LESSONS #13, the sentence that reads as a glitch. Right arithmetic, no denominator.\n return result([{\n check: REVENUE,\n severity: \"note\",\n sentence:\n `Over the ${base.length} periods before the latest one, ${what} ran at about ${Math.round(baseActivity)} ` +\n `${unit} a period, which is too little to say what a normal period looks like. This cannot judge the latest ` +\n `period against a baseline that thin, and it would rather tell you so than put a figure in front of you that ` +\n `reads as a glitch.`,\n numbers: {\n subject: what,\n usualActivity: Math.round(baseActivity),\n needed: REVENUE_MIN_BASELINE_ACTIVITY,\n latestActivity: latest.activity,\n latestDollars: latest.dollars,\n periods: clean.length,\n },\n checkFirst:\n `Nothing to do today. Once this channel has run at ${REVENUE_MIN_BASELINE_ACTIVITY} or more records a period ` +\n `for a few periods, this will start judging it properly.`,\n }]);\n }\n\n if (!(baseDollars > 0)) {\n // THE HONEST LIMIT OF THIS CHECK, said out loud rather than left to be discovered. Once every\n // period in view is already at zero there is nothing left to fall from, and silence here would\n // read as a clean bill of health for the exact fault this check was built for.\n return result([{\n check: REVENUE,\n severity: \"note\",\n sentence:\n `Over the ${base.length} periods before the latest one, no money at all was recorded against ${what}, so there ` +\n `is no normal level for this one to have fallen from. This cannot judge whether anything is wrong here: a fault ` +\n `that has run long enough to become the baseline stops looking like a fall. Take this as the monitor saying it ` +\n `is blind on this channel, not as an all clear.`,\n numbers: {\n subject: what,\n usualDollars: baseDollars,\n latestActivity: latest.activity,\n latestDollars: latest.dollars,\n periods: clean.length,\n },\n checkFirst:\n `Open the Square app and total what it has taken over the last few months, then compare that with what your ` +\n `CRM shows for the same months. If Square has money the CRM does not, the two have been disconnected for ` +\n `longer than this report can see.`,\n }]);\n }\n\n const dollarFall = 1 - latest.dollars / baseDollars;\n const activityHeld = latest.activity >= baseActivity * REVENUE_ACTIVITY_HELD;\n measured.dollarFallPercent = Math.round(dollarFall * 100);\n measured.activityHeld = activityHeld;\n\n if (dollarFall < REVENUE_DOLLAR_FALL || !activityHeld) {\n return result([]);\n }\n\n const usualActivity = Math.round(baseActivity);\n const shareOfMoneyMissing = Math.round(dollarFall * 100);\n const heldPhrase = latest.activity >= baseActivity\n ? \"as many as usual or more\"\n : `${Math.round((latest.activity / baseActivity) * 100)}% of the usual number`;\n const sentence =\n `In the latest period ${commas(latest.activity)} ${unit} were recorded, which is ${heldPhrase}, ` +\n `and the money recorded against them came to ${money(latest.dollars)}. ` +\n `Over the ${base.length} periods before it the usual figures were ${commas(usualActivity)} ${unit} and ` +\n `${money(baseDollars)}. The work carried on and ${shareOfMoneyMissing}% of the money that normally comes with it ` +\n `was never written down, which means it is being taken somewhere your CRM never hears about.`;\n\n return result([{\n check: REVENUE,\n severity: \"urgent\",\n sentence,\n numbers: {\n subject: what,\n latestActivity: latest.activity,\n latestDollars: latest.dollars,\n usualActivity,\n usualDollars: baseDollars,\n shareOfMoneyMissing,\n periodsCompared: clean.length,\n },\n checkFirst:\n `Open the Square app and total what it has taken over the same period. If Square shows sales your CRM does not, ` +\n `sales are being rung up in a way that never reaches a customer record, which is exactly what happened after ` +\n `19 February 2026.`,\n }]);\n}\n\n// ---------------------------------------------------------------------------------------------\n// CHECK 4: THE BRIDGE ITSELF. The Square link either erroring right now, or no longer writing\n// anything down at all.\n//\n// TWO FAULTS, TWO SENTENCES. \"It is failing\" and \"it has stopped\" are different problems with\n// different first moves, and collapsing them into one alarm sends her to the wrong place.\n// ---------------------------------------------------------------------------------------------\n\nconst BRIDGE = \"bridge\";\nconst BRIDGE_TITLE = \"The Square link\";\nconst BRIDGE_LABEL = \"journal rows\";\n\nconst isErrorRow = (r: any) =>\n String(r?.kind ?? \"\").toUpperCase() === \"ERROR\" || (typeof r?.error === \"string\" && r.error.length > 0);\n\nexport function bridgeFindings(rows: unknown, nowMs: unknown): CheckResult {\n const now = Number(nowMs);\n const list = Array.isArray(rows) ? rows : [];\n const inspected = list.length;\n\n if (!Number.isFinite(now) || inspected === 0) {\n return blindCheck(BRIDGE, BRIDGE_TITLE, BRIDGE_LABEL,\n `The Square link's own log came back with nothing in it that could be read, so this cannot tell you whether ` +\n `the link is working. A check that inspects nothing is a blind spot, not a clean result, and an unreadable log ` +\n `is the loudest thing in this report rather than the quietest.`,\n `Open the Square link's own page and check it answers at all. If it does and the log is genuinely empty, ` +\n `every sale taken since it last wrote something down is unaccounted for.`);\n }\n\n // Rows with a readable date, oldest first. The rest are counted and reported, never guessed at.\n const stamped = (list as any[])\n .map((r) => ({ row: r, ms: Date.parse(String(r?.ts ?? \"\")) }))\n .filter((x) => Number.isFinite(x.ms))\n .sort((a, b) => a.ms - b.ms);\n\n const measured: Record = {\n rows: inspected,\n rowsWithATimestamp: stamped.length,\n };\n const result = (findings: Finding[]): CheckResult =>\n ({ check: BRIDGE, title: BRIDGE_TITLE, inspected, inspectedLabel: BRIDGE_LABEL, measured, findings });\n\n if (stamped.length === 0) {\n return result([{\n check: BRIDGE,\n severity: \"urgent\",\n sentence:\n `The Square link's log has ${commas(inspected)} ${plural(inspected, \"entry\", \"entries\")} in it and not one of ` +\n `them carries a date this can read. Without dates there is no way to tell a link that stopped last night from ` +\n `one that stopped in March, so this is being raised rather than passed over.`,\n numbers: { rows: inspected, rowsWithATimestamp: 0 },\n checkFirst:\n `Open the Square link's own log and look at the newest few entries. If they carry no time against them, the ` +\n `link is writing in a shape this report cannot read and that needs fixing before any of it can be believed.`,\n }]);\n }\n\n // ONLY THE RECENT ROWS. See BRIDGE_RECENT_ROWS: a check that fires on any error ever recorded is\n // red forever, and 265 failures from three fixed days in July would keep it that way.\n const recent = stamped.slice(-BRIDGE_RECENT_ROWS);\n const recentSet = new Set(recent);\n const errorsInRecentRows = recent.filter((x) => isErrorRow(x.row)).length;\n const errorsBeforeThat = stamped.filter((x) => !recentSet.has(x) && isErrorRow(x.row)).length;\n const errorShare = recent.length ? errorsInRecentRows / recent.length : 0;\n measured.recentRows = recent.length;\n measured.errorsInRecentRows = errorsInRecentRows;\n measured.errorsBeforeThat = errorsBeforeThat;\n\n const findings: Finding[] = [];\n\n if (errorsInRecentRows > 0) {\n findings.push({\n check: BRIDGE,\n severity: errorShare >= BRIDGE_ERROR_SHARE_URGENT ? \"urgent\" : \"attention\",\n sentence:\n `The Square link is failing as it runs. ${commas(errorsInRecentRows)} of its last ${commas(recent.length)} ` +\n `entries are failures, which is ${percent(errorShare)} of them. Every one of those is a sale that reached ` +\n `Square and did not reach a customer record in your CRM.`,\n numbers: {\n errorsInRecentRows,\n recentRows: recent.length,\n errorSharePercent: Math.round(errorShare * 100),\n errorsBeforeThat,\n },\n checkFirst:\n `The weekly exception report lists every sale that did not reach a customer record, by name and amount. ` +\n `Work from that list rather than from the log itself, and send me the report if the same name keeps appearing.`,\n });\n }\n\n const r = rhythmOf(stamped.map((x) => x.ms));\n const lastMs = stamped[stamped.length - 1].ms;\n const ageH = (now - lastMs) / HOUR;\n measured.quietForHours = Math.round(ageH * 10) / 10;\n if (r === null) {\n findings.push({\n check: BRIDGE,\n severity: \"note\",\n sentence:\n `The Square link's log holds only ${commas(stamped.length)} dated ${plural(stamped.length, \"entry\", \"entries\")}, ` +\n `which is too little for this to know how often it normally writes something. It cannot yet tell a quiet link ` +\n `from a stopped one.`,\n numbers: { rowsWithATimestamp: stamped.length, needed: MIN_RECORDS_FOR_RHYTHM },\n checkFirst: `Nothing to do today. This will be able to judge the link once its log has a little more history in it.`,\n });\n } else {\n measured.expectByH = Math.round(r.expectByH * 10) / 10;\n if (ageH > r.expectByH) {\n findings.push({\n check: BRIDGE,\n severity: escalate(ageH, r.expectByH),\n sentence:\n `The Square link has written nothing down for ${sayGap(ageH)}. The last thing it recorded was on ` +\n `${sayDate(lastMs)}. It normally writes something every ${sayGap(r.normalGapH)}, so it has not simply gone ` +\n `quiet, it has stopped. Anything taken in Square since then has not reached your CRM.`,\n numbers: {\n quietForHours: Math.round(ageH * 10) / 10,\n lastRowAt: new Date(lastMs).toISOString(),\n normalGapHours: Math.round(r.normalGapH * 10) / 10,\n outOfCharacterAfterHours: Math.round(r.expectByH * 10) / 10,\n rowsWithATimestamp: stamped.length,\n },\n checkFirst:\n `Open the Square link's own page and check it answers. If it does, take one card payment in Square and see ` +\n `whether it appears against a customer in your CRM within a few minutes.`,\n });\n }\n }\n\n return result(findings);\n}\n\n// ---------------------------------------------------------------------------------------------\n// CHECK 5: A FIGURE THAT SHOULD ONLY EVER GROW HAS GONE BACKWARDS.\n//\n// Lifetime totals only go up. When one comes back smaller, the reading is being taken from\n// somewhere else: a source was swapped, a query was cut at a date, a page walk stopped early. Each\n// of those has produced a wrong number in front of this client already, and each was invisible at\n// the time because the smaller figure was perfectly plausible on its own.\n//\n// A FIGURE THAT STOPS BEING REPORTED IS THE SAME DISEASE. It hides exactly what a fall hides, and\n// it looks like nothing at all on a page that only prints what it has.\n// ---------------------------------------------------------------------------------------------\n\nconst BACKWARDS = \"backwards\";\nconst BACKWARDS_TITLE = \"Running totals that should only grow\";\nconst BACKWARDS_LABEL = \"running totals\";\n\nexport function backwardsFindings(snapshots: unknown, labels: unknown): CheckResult {\n const named = (labels ?? {}) as Record;\n const nameOf = (key: string) => String(named?.[key] ?? key);\n const list = (Array.isArray(snapshots) ? snapshots : []) as Snapshot[];\n\n if (list.length === 0) {\n return blindCheck(BACKWARDS, BACKWARDS_TITLE, BACKWARDS_LABEL,\n `This check has no readings of your running totals at all, so it cannot tell whether any of them has gone ` +\n `backwards. A check that inspects nothing is a blind spot, not a clean result, and it is being reported as one.`,\n `Check that the file this keeps its earlier readings in still exists and can be read. Until it can, a total ` +\n `that shrinks will pass unnoticed.`);\n }\n\n const previous = list[list.length - 2];\n const current = list[list.length - 1];\n\n if (list.length < 2) {\n // A FIRST RUN IS NOT A CLEAN RUN. It compared nothing, so it says it compared nothing. This is\n // a note rather than an alarm because there is nothing wrong here, but it is still a finding,\n // because \"nothing to compare\" printed as blank space reads as \"everything checks out\".\n return {\n check: BACKWARDS,\n title: BACKWARDS_TITLE,\n inspected: 0,\n inspectedLabel: BACKWARDS_LABEL,\n measured: { readings: list.length, compared: 0 },\n findings: [{\n check: BACKWARDS,\n severity: \"note\",\n sentence:\n `This is the first time these running totals have been written down, so there is nothing yet to compare ` +\n `them against. That is not a clean result, it is an empty one, and from the next run on any figure that ` +\n `goes backwards will be named here.`,\n numbers: { readings: list.length, compared: 0 },\n checkFirst: `Nothing to do today. Run this again tomorrow and it will have something to compare against.`,\n }],\n };\n }\n\n const prevCounters = (previous?.counters ?? {}) as Record;\n const curCounters = (current?.counters ?? {}) as Record;\n const keys = [...new Set([...Object.keys(prevCounters), ...Object.keys(curCounters)])];\n const inspected = keys.length;\n const prevAt = Date.parse(String(previous?.at ?? \"\"));\n\n if (inspected === 0) {\n return blindCheck(BACKWARDS, BACKWARDS_TITLE, BACKWARDS_LABEL,\n `The last two readings of your running totals carry no figures at all, so there was nothing to compare. ` +\n `A check that inspects nothing is a blind spot, not a clean result, and it is being reported as one.`,\n `Check that the file this keeps its earlier readings in has not been emptied or overwritten.`);\n }\n\n const findings: Finding[] = [];\n for (const key of keys) {\n const before = Number(prevCounters[key]);\n const after = curCounters[key] === undefined || curCounters[key] === null ? null : Number(curCounters[key]);\n if (!Number.isFinite(before)) continue; // nothing to fall FROM: not a finding, just no history\n if (after === null || !Number.isFinite(after as number)) {\n findings.push({\n check: BACKWARDS,\n severity: \"attention\",\n sentence:\n `${nameOf(key)} was being reported and now is not. It read ${commas(before)} on ${sayDate(prevAt)} and the ` +\n `latest reading does not carry it at all. A figure that stops being reported hides exactly what a figure ` +\n `going backwards hides, so it is raised the same way.`,\n numbers: { counter: key, label: nameOf(key), previous: before, current: null, previousAt: previous?.at ?? null },\n checkFirst:\n `Check whether whatever produces this figure answered at all on the last run. A reading that failed and a ` +\n `reading of nought look the same on a page and mean opposite things.`,\n });\n continue;\n }\n if ((after as number) >= before) continue;\n const fell = before - (after as number);\n findings.push({\n check: BACKWARDS,\n severity: \"urgent\",\n sentence:\n `${nameOf(key)} has gone backwards. It read ${commas(before)} on ${sayDate(prevAt)} and reads ` +\n `${commas(after as number)} now, a fall of ${commas(fell)}. Figures like this only ever go up, so a fall means ` +\n `it is being read from somewhere different: a source swapped, a list cut short, or a page walk that stopped ` +\n `early and reported what it had as the whole.`,\n numbers: {\n counter: key,\n label: nameOf(key),\n previous: before,\n current: after,\n fell,\n previousAt: previous?.at ?? null,\n currentAt: current?.at ?? null,\n },\n checkFirst:\n `Do not act on any figure derived from this one until it is explained. Send me this report and I will read ` +\n `the same total straight from the system that owns it.`,\n });\n }\n\n return {\n check: BACKWARDS,\n title: BACKWARDS_TITLE,\n inspected,\n inspectedLabel: BACKWARDS_LABEL,\n measured: { readings: list.length, compared: inspected, comparedAgainst: previous?.at ?? null },\n findings,\n };\n}\n\n// ---------------------------------------------------------------------------------------------\n// THE BUCKETING. Dates cut into windows, which is arithmetic and therefore testable.\n//\n// A RECORD WITH NO READABLE DATE IS NEVER INVENTED INTO A WINDOW. Dropping it understates a\n// window; guessing at it corrupts the baseline every later judgement is made against.\n// ---------------------------------------------------------------------------------------------\n\n/** Payments the bridge saw, cut into equal windows ending now, oldest window first. */\nexport function ratioBuckets(seen: unknown, nowMs: unknown, windowDays: number, windows: number): RatioPoint[] {\n const now = Number(nowMs);\n const spanMs = Math.max(1, Number(windowDays) || 1) * 24 * HOUR;\n const n = Math.max(1, Math.floor(Number(windows) || 1));\n const points = Array.from({ length: n }, (_, i) => {\n const endMs = now - (n - 1 - i) * spanMs;\n return { label: `the ${windowDays} days to ${sayDate(endMs)}`, endMs, total: 0, matched: 0 };\n });\n if (!Number.isFinite(now)) return points;\n for (const p of (Array.isArray(seen) ? seen : []) as any[]) {\n const at = Number(p?.atMs);\n if (!Number.isFinite(at)) continue;\n const back = Math.floor((now - at) / spanMs);\n if (back < 0 || back >= n) continue;\n const point = points[n - 1 - back];\n point.total += 1;\n if (p?.matched === true) point.matched += 1;\n }\n return points;\n}\n\n/** Records of work and the money against them, summed into equal windows, oldest window first. */\nexport function revenuePeriods(records: unknown, nowMs: unknown, windowDays: number, windows: number): RevenuePeriod[] {\n const now = Number(nowMs);\n const spanMs = Math.max(1, Number(windowDays) || 1) * 24 * HOUR;\n const n = Math.max(1, Math.floor(Number(windows) || 1));\n const periods = Array.from({ length: n }, (_, i) => {\n const endMs = now - (n - 1 - i) * spanMs;\n return { label: `the ${windowDays} days to ${sayDate(endMs)}`, endMs, activity: 0, dollars: 0 };\n });\n if (!Number.isFinite(now)) return periods;\n for (const rec of (Array.isArray(records) ? records : []) as any[]) {\n const at = Number(rec?.atMs);\n if (!Number.isFinite(at)) continue;\n const back = Math.floor((now - at) / spanMs);\n if (back < 0 || back >= n) continue;\n const period = periods[n - 1 - back];\n period.activity += 1;\n period.dollars += Number(rec?.dollars) || 0;\n }\n // Rounded to the cent at the end, not per addition: summing floats and rounding once is the only\n // version whose total matches what the CRM itself reports.\n for (const p of periods) p.dollars = Math.round(p.dollars * 100) / 100;\n return periods;\n}\n\n// ---------------------------------------------------------------------------------------------\n// THE WHOLE RUN.\n// ---------------------------------------------------------------------------------------------\n\nexport function runWatch(input: WatchInput): WatchReport {\n // A RUN THAT WAS NEVER TOLD THE TIME JUDGES NOTHING.\n //\n // The dangerous shape this refuses: a replay with a mistyped date silently reporting on today,\n // under a heading naming the date it was asked about, with every figure wrong and nothing in the\n // document able to see it. Inventing a clock here would be the one mistake this whole file could\n // make that nobody downstream could catch.\n const now = input?.nowMs;\n if (!Number.isFinite(now)) {\n return {\n generatedAt: \"not known\",\n headline: \"This check could not run, because it was not told what the time is.\",\n inspected: 0,\n checks: [],\n findings: [{\n check: \"clock\",\n severity: \"urgent\",\n sentence:\n `This run was not told what the time is, so it has judged nothing at all. Every figure in this report is ` +\n `measured against a moment, and inventing one would have produced a page of confident numbers about the ` +\n `wrong day. Nothing here is an all clear.`,\n numbers: { nowMs: String(now), inspected: 0 },\n checkFirst:\n `Run this again with the date it is meant to judge. If this was a replay of a past morning, check the date ` +\n `that was typed for it.`,\n }],\n };\n }\n const at = now as number;\n\n const checks: CheckResult[] = [\n silenceFindings(input?.streams, at),\n matchRatioFindings(input?.ratio?.points, input?.ratio?.subject ?? \"payments\"),\n revenueChannelFindings(input?.revenue?.periods, input?.revenue?.subject ?? \"your bookings\"),\n bridgeFindings(input?.journal, at),\n backwardsFindings(input?.snapshots, input?.counterLabels ?? {}),\n ];\n\n const inspected = checks.reduce((a, c) => a + (c.inspected ?? 0), 0);\n // MOST SEVERE FIRST, so the first thing she reads is the worst thing. A stable sort inside a\n // severity band keeps the checks in the order they ran, which is the order the report explains.\n const rank: Record = { urgent: 0, attention: 1, note: 2 };\n const findings = checks\n .flatMap((c) => c.findings.map((f) => ({ ...f, check: f.check ?? c.check })))\n .map((f, i) => ({ f, i }))\n .sort((a, b) => ((rank[a.f.severity] ?? 3) - (rank[b.f.severity] ?? 3)) || (a.i - b.i))\n .map((x) => x.f);\n\n return {\n generatedAt: new Date(at).toISOString(),\n headline: headlineFor(findings, checks, inspected),\n inspected,\n checks,\n findings,\n };\n}\n\n/**\n * The one line at the top. It leads with what has to happen today, and it never says a reassuring\n * thing about a run that could not see anything: \"nothing wrong\" and \"nothing looked at\" have to\n * be different sentences or the second one does the damage of the first.\n */\nexport function headlineFor(findings: Finding[], checks: CheckResult[], inspected: number): string {\n // A finding from a check that read NOTHING is a blind spot, never a problem with the business.\n // The owning check is the authority; a free-form number inside the finding cannot change class.\n const isBlind = (finding: Finding) => isBlindFindingForChecks(finding, checks);\n const n = (s: Severity) => findings.filter((f) => f.severity === s && !isBlind(f)).length;\n const urgent = n(\"urgent\");\n const attention = n(\"attention\");\n const notes = findings.filter((f) => f.severity === \"note\" || isBlind(f)).length;\n if (urgent) {\n return `${capitalise(countWord(urgent))} ${plural(urgent, \"thing needs\", \"things need\")} you to look at today` +\n `${attention ? `, and ${countWord(attention)} more ${plural(attention, \"is\", \"are\")} worth a look this week` : \"\"}.`;\n }\n if (attention) {\n return `${capitalise(countWord(attention))} ${plural(attention, \"thing is\", \"things are\")} worth a look this week.`;\n }\n if (notes) {\n // W42: when NOTHING could be read, \"nothing looks wrong\" is a reassuring sentence about a run\n // that judged nothing. Lead with the blindness instead. Only say the reassuring half when at\n // least one check actually read something and came back clean.\n const readSomething = checks.filter((c) => Number(c?.inspected) > 0).length;\n if (!readSomething) {\n return `Nothing could be checked. ${capitalise(countWord(notes))} ` +\n `${plural(notes, \"check\", \"checks\")} read no data at all, so this run judges nothing either way.`;\n }\n return `Nothing looks wrong in what could be checked, and ${countWord(notes)} ` +\n `${plural(notes, \"thing\", \"things\")} this monitor cannot see yet.`;\n }\n return `Nothing looks wrong. ${capitalise(countWord(checks.length))} checks ran and read ` +\n `${commas(inspected)} records between them.`;\n}\n\n// ---------------------------------------------------------------------------------------------\n// THE COPY SHE READS.\n//\n// TWO RULES, ENFORCED MECHANICALLY, and they run over the GENERATED report rather than over any\n// source file, because the sentences are built at run time and a rule that only reads source\n// cannot see them.\n// ---------------------------------------------------------------------------------------------\n\n/** One entry per rule broken, so an em dash and a spaced hyphen in one page are one problem, not two. */\nexport function copyProblems(text: unknown): string[] {\n const s = String(text ?? \"\");\n const out: string[] = [];\n // The name of a service this business does not offer. She asked for it never to appear.\n if (/\\bday\\s?care\\b/i.test(s)) out.push(\"names a service this business does not offer\");\n // A dash used as punctuation, in any of its forms. Hyphens INSIDE words are fine and common:\n // \"well known\" hyphenated, a phone number, a field name. Only a dash standing alone counts.\n if (/(^|\\s)[-–—](\\s|$)|[–—]/.test(s)) out.push(\"uses a dash as punctuation\");\n return out;\n}\n\n/**\n * THE ENGINE'S OWN VIEW of the report: every finding, the figures behind it, and what every check\n * read including the checks that found nothing.\n *\n * WHY THE CHECKS THAT FOUND NOTHING ARE PRINTED. A report that prints only problems gives the\n * reader no way to tell \"checked and clean\" from \"checked nothing\", and that exact confusion is\n * what let February run for five months.\n *\n * This is the workings, not the page for the owner. scripts/watch-run.mjs renders her page from\n * the same report object and keeps this one in the repo, so a queried figure can still be traced.\n */\nexport function watchReportMarkdown(report: WatchReport, title: unknown): string {\n const heading = String(title ?? \"Early warning check\");\n const findings = Array.isArray(report?.findings) ? report.findings : [];\n const checks = Array.isArray(report?.checks) ? report.checks : [];\n // v1.1 (16 Aug) — THE SPLIT IS \"DID IT READ ANYTHING\", NOT SEVERITY ALONE. A blind check keeps\n // severity \"urgent\" (six tests hold that, and it must never go quiet), but it is not a fault in\n // the business and it must not be filed as one. Before this, the report opened \"Two things need\n // you to look at today\" when both were checks that had never been wired up — the exact shape of\n // failure this page exists to prevent, pointed inward.\n const readNothing = (finding: Finding) => isBlindFindingForChecks(finding, checks);\n const loud = findings.filter((f) => f.severity !== \"note\" && !readNothing(f));\n const notes = findings.filter((f) => f.severity === \"note\" || readNothing(f));\n const band: Record = {\n urgent: \"Look at this today\",\n attention: \"Worth a look this week\",\n note: \"The monitor talking about itself\",\n };\n const figures = (o: Record) =>\n Object.entries(o ?? {})\n .filter(([, v]) => v !== undefined && (typeof v !== \"object\" || v === null))\n .map(([k, v]) => `${k}: ${v === null ? \"not known\" : String(v)}`)\n .join(\", \");\n\n const out: string[] = [];\n out.push(`# ${heading}`);\n out.push(\"\");\n out.push(report?.headline ?? \"\");\n out.push(\"\");\n out.push(`Read at ${report?.generatedAt ?? \"not known\"}. ${commas(report?.inspected ?? 0)} records inspected across ${checks.length} checks.`);\n out.push(\"\");\n\n const say = (f: Finding) => {\n out.push(`### ${band[f.severity] ?? f.severity}. ${f.check}`);\n out.push(\"\");\n out.push(f.sentence);\n out.push(\"\");\n const fig = figures(f.numbers);\n if (fig) { out.push(`The figures behind that: ${fig}`); out.push(\"\"); }\n if (f.checkFirst) { out.push(`Check first: ${f.checkFirst}`); out.push(\"\"); }\n };\n\n if (loud.length) {\n out.push(`## What needs your attention`);\n out.push(\"\");\n for (const f of loud) say(f);\n }\n if (notes.length) {\n out.push(`## What this monitor cannot see yet`);\n out.push(\"\");\n out.push(\n `These are not problems with the business. They are the monitor saying where it is unable to judge anything, ` +\n `which is worth knowing rather than reading as a clean result.`);\n out.push(\"\");\n for (const f of notes) say(f);\n }\n\n out.push(`## What every check read, including the ones that found nothing`);\n out.push(\"\");\n for (const c of checks) {\n out.push(`${c.title}: read ${commas(c.inspected ?? 0)} ${c.inspectedLabel}, and raised ` +\n `${commas(c.findings?.length ?? 0)} ${plural(c.findings?.length ?? 0, \"finding\", \"findings\")}.`);\n const fig = figures(c.measured);\n if (fig) out.push(`The figures behind that: ${fig}`);\n out.push(\"\");\n }\n\n const blind = blindSpots(checks);\n out.push(`## Whether this report can be believed`);\n out.push(\"\");\n out.push(blind.length\n ? `${capitalise(countWord(blind.length))} ${plural(blind.length, \"check\", \"checks\")} inspected nothing and said ` +\n `nothing about it, which means this report is not watching what it claims to. Do not read it as a clean result.`\n : `Every check above reported the size of what it read, and every check that read nothing said so in its own ` +\n `finding rather than passing silently. A check that inspects nothing is a blind spot, not an all clear, and ` +\n `that is the one rule this whole report rests on.`);\n out.push(\"\");\n\n return out.join(\"\\n\").replace(/\\n{3,}/g, \"\\n\\n\");\n}\n",[196],"5c3e5160-8a18-4ca4-9b52-47c0de7c9b06","watch-view.ts","d0159a5c-98c4-11f1-99c3-1607ee4eb77e",1232,["D",1787226716573],3,"http","// READING THE EARLY-WARNING MONITOR. v1.1, 18 Aug 2026.\n//\n// The scheduled monitor writes one receipt blob. This endpoint leads with receipt health so a\n// stale, degraded, failed, or never-successful monitor cannot look like a clean business result.\n\nimport { watchReportMarkdown } from \"./watch.ts\";\nimport {\n WATCH_BLOB,\n reportFindingSeverity,\n validateWatchBlob,\n validatedWatchFindingSummary,\n type ReportFindingSeverity,\n type WatchFindingSummary,\n} from \"./watch-cron.ts\";\n\nconst STALE_HOURS = 36;\nconst COVERAGE =\n \"Runs automatically: CRM revenue against activity, silence on CRM payments and new contacts, \" +\n \"running totals, Square match ratio, and bridge-journal health. Square checks run only when the \" +\n \"credentialled bridge journal validates; missing CRM contact or bridge evidence marks the run \" +\n \"degraded and names the blind checks instead of reporting full health.\";\n\nasync function sha256Hex(s: string): Promise {\n const b = await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(s));\n return [...new Uint8Array(b)].map((x) => x.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nasync function authorised(k: string): Promise {\n const configured = Deno.env.get(\"NURTURE_ADMIN_KEY_SHA256\");\n if (!k || !configured || !/^[0-9a-f]{64}$/i.test(configured)) return false;\n const got = await sha256Hex(k);\n const want = configured.toLowerCase();\n if (got.length !== want.length) return false;\n let d = 0;\n for (let i = 0; i < got.length; i++) d |= got.charCodeAt(i) ^ want.charCodeAt(i);\n return d === 0;\n}\n\nfunction invalidView(state: \"invalid\" | \"unreadable\", what: string, reason: string): any {\n return {\n ok: false,\n state,\n what,\n health: {\n reportAgeHours: null,\n stale: true,\n hasSuccessfulReport: false,\n lastRunOk: false,\n persistedLastRunOk: false,\n degraded: true,\n sourceDegraded: true,\n findingSeverity: \"none\",\n actionableFindingSeverity: \"none\",\n blind: false,\n blindFindingCount: 0,\n actionableFindingCount: 0,\n lastRunAt: null,\n lastRunError: reason,\n coverage: COVERAGE,\n schemaError: reason,\n },\n inspected: null,\n report: null,\n snapshots: [],\n };\n}\n\n/** Pure receipt classification, shared by the endpoint and executable tests. */\nexport function watchViewData(stored: unknown, nowMs = Date.now(), readError = \"\"): any {\n if (readError) {\n return invalidView(\n \"unreadable\",\n \"The stored early-warning receipt could not be read. This is not a first run or an all clear.\",\n readError,\n );\n }\n if (stored == null) {\n return {\n ok: false,\n state: \"never-run\",\n what: \"The early-warning monitor has not attempted a run yet.\",\n };\n }\n\n if (!Number.isFinite(nowMs)) {\n return invalidView(\"invalid\", \"The monitor receipt cannot be judged because the current clock is invalid.\",\n \"current time is invalid\");\n }\n let validated: ReturnType;\n try {\n validated = validateWatchBlob(stored, nowMs);\n stored = validated;\n } catch (error) {\n return invalidView(\n \"invalid\",\n \"The stored monitor receipt is malformed or future-dated and cannot be trusted.\",\n error instanceof Error ? error.message : \"stored receipt validation failed\",\n );\n }\n const emptySummary = (): WatchFindingSummary => ({\n findings: [], blind: [], actionable: [], severity: \"none\", actionableSeverity: \"none\",\n });\n const successful = validated.hasSuccessfulReport;\n const findingSummary = successful ? validatedWatchFindingSummary(validated.report) : emptySummary();\n const findingSeverity: ReportFindingSeverity = successful\n ? reportFindingSeverity(validated.report)\n : \"urgent\";\n const actionableFindingSeverity = findingSummary.actionableSeverity;\n const hasActionableFinding = findingSummary.actionable.length > 0;\n const hasBlindFinding = findingSummary.blind.length > 0;\n\n const reportMs = Date.parse(validated.report.generatedAt);\n const ageHours = (nowMs - reportMs) / 3_600_000;\n const stale = ageHours > STALE_HOURS;\n const persistedLastRunOk = validated.lastRun.ok;\n const sourceDegraded = validated.lastRun.degraded === true;\n const lastRunError = validated.lastRun.error;\n // Severity is authoritative even for a receipt written by the pre-repair cron with ok:true.\n // Keep that raw bit for diagnostics, but never expose it as effective health in JSON or prose.\n const lastRunOk = persistedLastRunOk && !sourceDegraded && !hasActionableFinding && !hasBlindFinding;\n const attemptFailed = !persistedLastRunOk && !sourceDegraded && !!lastRunError;\n const hasSuccessfulReport = successful;\n\n let state: \"not-yet-successful\" | \"degraded\" | \"urgent\" | \"failed\" | \"stale\" | \"healthy\";\n if (!hasSuccessfulReport) state = \"not-yet-successful\";\n else if (sourceDegraded) state = \"degraded\";\n else if (attemptFailed) state = \"failed\";\n else if (stale) state = \"stale\";\n else if (actionableFindingSeverity === \"urgent\") state = \"urgent\";\n else if (actionableFindingSeverity === \"attention\") state = \"degraded\";\n else if (hasBlindFinding) state = \"degraded\";\n else if (!lastRunOk) state = \"failed\";\n else state = \"healthy\";\n\n const what = state === \"not-yet-successful\"\n ? \"The early-warning monitor has not completed a successful run. Its failure is shown below.\"\n : state === \"degraded\"\n ? sourceDegraded\n ? \"The latest report contains usable evidence, but one or more monitoring sources could not be read.\" +\n (hasActionableFinding ? ` The available evidence also contains ${actionableFindingSeverity} findings.` : \"\")\n : hasActionableFinding\n ? \"The latest report contains findings that need attention. All configured evidence sources were read.\"\n : \"The latest report cannot judge one or more checks because they inspected no evidence. This is not a business alert or an all clear.\"\n : state === \"urgent\"\n ? \"The latest report contains urgent findings that need action. All configured evidence sources were read.\"\n : state === \"failed\"\n ? \"The latest attempt failed. The last completed report is retained below.\"\n : state === \"stale\"\n ? \"The latest completed report is stale; the monitor may have stopped.\" +\n (hasActionableFinding ? ` Its retained report contains ${actionableFindingSeverity} findings.` :\n hasBlindFinding ? \" Its retained report also contains checks that inspected no evidence.\" : \"\")\n : \"The latest automatic monitor run completed with all configured evidence sources.\";\n\n return {\n ok: state === \"healthy\",\n state,\n what,\n builtAt: validated.builtAt,\n health: {\n reportAgeHours: +ageHours.toFixed(1),\n stale,\n hasSuccessfulReport,\n lastRunOk,\n persistedLastRunOk,\n degraded: sourceDegraded,\n sourceDegraded,\n findingSeverity,\n actionableFindingSeverity,\n blind: hasBlindFinding,\n blindFindingCount: findingSummary.blind.length,\n actionableFindingCount: findingSummary.actionable.length,\n lastRunAt: validated.lastRun.at,\n lastRunError: lastRunError || null,\n coverage: COVERAGE,\n },\n inspected: validated.inspected,\n report: validated.report,\n snapshots: validated.snapshots,\n };\n}\n\n/** Render only detached, classified view data. The original blob value never crosses this API. */\nexport function watchViewText(data: any): string {\n if ([\"never-run\", \"invalid\", \"unreadable\"].includes(String(data?.state))) {\n const detail = data?.health?.schemaError ? `\\nReason: ${data.health.schemaError}\\n` : \"\\n\";\n return `${data?.what ?? \"The stored monitor receipt is unavailable.\"}${detail}`;\n }\n\n const h = data.health;\n const age = h.reportAgeHours === null ? \"an unreadable age\" : `${h.reportAgeHours}h ago`;\n const runLabel = data.state === \"not-yet-successful\" ? \"NOT YET SUCCESSFUL\"\n : data.state === \"urgent\" ? \"URGENT FINDINGS\"\n : data.state === \"degraded\" ? (h.sourceDegraded ? \"DEGRADED\" : h.blind ? \"CANNOT TELL\" : \"ATTENTION\")\n : data.state === \"failed\" ? \"FAILED\"\n : data.state === \"stale\" ? \"STALE\"\n : \"succeeded\";\n const inspected = data.inspected;\n const report = data.report;\n const head = [\n data.what,\n `Report generated ${report?.generatedAt ?? \"at an unreadable time\"} (${age})` +\n `; receipt stored ${data.builtAt ?? \"at an unreadable time\"}` +\n `${h.stale ? \" ***STALE OR UNREADABLE***\" : \"\"}`,\n `Last run ${runLabel}${h.lastRunError ? `: ${h.lastRunError}` : \"\"} at ${h.lastRunAt ?? \"an unreadable time\"}`,\n `Inspected ${inspected?.transactions ?? 0} payment records across ${inspected?.pages ?? 0} page(s)` +\n (inspected?.truncated ? \" — TRUNCATED\" : \"\"),\n h.coverage,\n \"\",\n ].join(\"\\n\");\n\n const reportText = report && Array.isArray(report.findings)\n ? watchReportMarkdown(report, \"The Dogs Spot — early warning\")\n : \"The stored monitor report is malformed and cannot be rendered.\\n\";\n return head + reportText;\n}\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n if (!(await authorised(u.searchParams.get(\"k\") ?? \"\"))) return new Response(\"Not found\", { status: 404 });\n\n let stored: unknown = null;\n let readError = \"\";\n try {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n stored = await blob.getJSON(WATCH_BLOB);\n } catch {\n readError = \"watch receipt storage read failed\";\n }\n\n const data = watchViewData(stored, Date.now(), readError);\n if (u.searchParams.get(\"f\") === \"json\") return Response.json(data, { status: 200 });\n return new Response(watchViewText(data), {\n headers: { \"Content-Type\": \"text/plain; charset=utf-8\" },\n });\n}\n",[204],"81b0edc8-3573-4196-8a6a-bb34c5b3b4ab","watch-cron.ts","cfa8812e-98c4-11f1-9f38-1607ee4eb77e",1231,["D",1787226711931],2,"interval","\nimport {\n headlineFor,\n isBlindFindingForChecks,\n REVENUE_ACTIVITY_HELD,\n REVENUE_DOLLAR_FALL,\n REVENUE_MIN_BASELINE_ACTIVITY,\n REVENUE_MIN_PERIODS,\n revenueChannelFindings,\n runWatch,\n ratioBuckets,\n revenuePeriods,\n type Finding,\n type WatchReport,\n} from \"./watch.ts\";\nimport { paymentLedger } from \"./facts.ts\";\nimport { fetchPayments, MIN_REAL_PAYMENT, toPayment } from \"./payments-source.ts\";\n\nconst LOC = \"BQHJ19uohldYe3eqA0bl\";\nconst GHL = \"https://services.leadconnectorhq.com\";\nconst PAYMENT_PATH = \"/payments/transactions\";\nconst CONTACT_PATH = \"/contacts/\";\nconst CONTACT_PAGE_SIZE = \"100\";\nconst CONTACT_QUERY_KEYS = new Set([\"locationId\", \"limit\", \"startAfter\", \"startAfterId\"]);\nexport const BRIDGE_URL = \"https://amir5--41ace24c7e2111f18c9d1607ee4eb77e.web.val.run\";\nconst UA =\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0 Safari/537.36\";\nconst DAY = 86_400_000;\nconst PAYMENT_CURRENCY = \"USD\";\nconst PAYMENT_AMOUNT_UNIT = \"major\";\nconst KNOWN_PAYMENT_STATUSES = new Set([\"succeeded\", \"failed\", \"pending\"]);\nconst CRM_REQUEST_TIMEOUT_MS = 15_000;\nconst BRIDGE_REQUEST_TIMEOUT_MS = 15_000;\n\nexport const WATCH_BLOB = \"watch_report\";\nexport const REVENUE_WINDOW_DAYS = 28;\nexport const REVENUE_WINDOWS = 7;\nexport const RATIO_WINDOW_DAYS = 7;\nexport const RATIO_WINDOWS = 6;\nexport const MONITORING_HORIZON_DAYS = REVENUE_WINDOW_DAYS * REVENUE_WINDOWS;\nexport const MAX_SNAPSHOTS = MONITORING_HORIZON_DAYS + 2;\nexport const REAL_MONEY = MIN_REAL_PAYMENT;\nexport const PAGE_CAP = 40;\nexport const BRIDGE_JOURNAL_CAP = 1_500;\nexport const MAX_TRANSACTION_DROP_SHARE = 0.10;\nexport const OVERALL_BUDGET_MS = 45_000;\n\nexport const LIFETIME_COUNTER_KEYS = [\n \"crmPaymentRecords\",\n \"crmPaymentDollarsLifetime\",\n] as const;\ntype LifetimeCounterKey = typeof LIFETIME_COUNTER_KEYS[number];\ntype LifetimeCounters = Record;\ntype Snapshot = { at: string; counters: LifetimeCounters };\ntype ResponseLike = { ok: boolean; status: number; json: () => Promise };\ntype RequestFn = (url: string, init?: RequestInit) => Promise;\ntype BlobLike = {\n getJSON: (key: string) => Promise;\n setJSON: (key: string, value: unknown) => Promise;\n};\n\nexport type ReportFindingSeverity = \"urgent\" | \"attention\" | \"note\" | \"none\";\n\nexport type WatchFindingSummary = {\n findings: Finding[];\n blind: Finding[];\n actionable: Finding[];\n severity: ReportFindingSeverity;\n actionableSeverity: ReportFindingSeverity;\n};\n\nexport type WatchInspected = {\n transactions: number;\n expectedTransactions: number;\n pages: number;\n truncated: boolean;\n validTransactionTimestamps: number;\n paymentStatuses: { succeeded: number; failed: number; pending: number };\n currency: \"USD\";\n amountUnit: \"major\";\n zeroOrTest: number;\n unknownSourceTypes: string[];\n contacts: number;\n contactPages: number;\n bridgeJournalRows: number;\n bridgePayments: number;\n bridgeAtCapacity: boolean;\n bridgeHorizonComplete: boolean;\n};\n\nexport type WatchBlob = {\n report: WatchReport;\n builtAt: string;\n hasSuccessfulReport: boolean;\n inspected: WatchInspected;\n lastRun: {\n at: string;\n ok: boolean;\n degraded?: boolean;\n findingSeverity?: ReportFindingSeverity;\n ms: number;\n error: string;\n };\n snapshots: Snapshot[];\n highWater?: Snapshot;\n};\n\nexport type BridgeEvidence = {\n journal: any[];\n payments: number;\n journalRows: number;\n atCapacity: boolean;\n horizonComplete: boolean;\n oldestAt: string;\n ratio: { subject: string; points: ReturnType };\n};\n\nexport type BridgeReadOptions = {\n admin?: string;\n bridgeUrl?: string;\n request?: RequestFn;\n timeoutMs?: number;\n};\n\nexport type TransactionEvidence = {\n rows: { atMs: number; dollars: number }[];\n count: number;\n expected: number;\n pages: number;\n truncated: false;\n validTimestamps: number;\n statuses: { succeeded: number; failed: number; pending: number };\n currency: \"USD\";\n amountUnit: \"major\";\n zeroOrTest: number;\n unknownSourceTypes: string[];\n};\n\nexport type ContactEvidence = { timestamps: number[]; rows: number; pages: number };\n\nexport type ScheduledWatchDeps = {\n blob?: BlobLike;\n env?: (name: string) => string | undefined;\n request?: RequestFn;\n now?: () => number;\n wallNow?: () => number;\n log?: (line: string) => void;\n runWatchFn?: typeof runWatch;\n};\n\nexport type ScheduledWatchResult = { published: boolean; degraded: boolean; error: string };\n\nconst envValue = (name: string): string | undefined => {\n try {\n return typeof Deno !== \"undefined\" ? Deno.env.get(name) : undefined;\n } catch {\n return undefined;\n }\n};\n\nconst errorText = (value: unknown): string => value instanceof Error ? value.message : String(value);\n\nexport function redactSecrets(value: unknown, known: string[] = []): string {\n let text = errorText(value);\n for (const secret of known.filter((x) => typeof x === \"string\" && x.length >= 4)) {\n text = text.split(secret).join(\"[REDACTED]\");\n }\n return text\n .replace(/Bearer\\s+[^\\s,;]+/gi, \"Bearer [REDACTED]\")\n .replace(/([?&](?:admin|token|api[_-]?key|secret)=)[^&\\s]+/gi, \"$1[REDACTED]\")\n .replace(/\\b((?:admin|token|api[_-]?key|secret)\\s*[:=]\\s*)[^\\s,;]+/gi, \"$1[REDACTED]\")\n .replace(/\\b(?:pit-|ghl_|admin_)[A-Za-z0-9._~-]{12,}/g, \"[REDACTED]\")\n .slice(0, 240);\n}\n\nfunction assertCrmUrl(raw: string, allowedPaths = new Set([PAYMENT_PATH, CONTACT_PATH])): URL {\n let target: URL;\n try {\n target = new URL(raw, GHL);\n } catch {\n throw new Error(\"CRM URL is invalid\");\n }\n if (target.protocol !== \"https:\" || target.origin !== GHL || target.username || target.password) {\n throw new Error(\"refusing a URL outside the CRM origin\");\n }\n if (!allowedPaths.has(target.pathname)) throw new Error(\"refusing an undocumented CRM endpoint\");\n return target;\n}\n\nfunction assertContactPageUrl(raw: string, continuation: boolean): URL {\n const target = assertCrmUrl(raw, new Set([CONTACT_PATH]));\n if (target.hash) throw new Error(\"contact pagination URL contains an unsafe fragment\");\n\n for (const key of target.searchParams.keys()) {\n if (!CONTACT_QUERY_KEYS.has(key)) {\n throw new Error(`contact pagination URL uses an unexpected query route: ${key || \"(empty)\"}`);\n }\n }\n const one = (key: string): string => {\n const values = target.searchParams.getAll(key);\n if (values.length !== 1) {\n throw new Error(`contact pagination URL must contain exactly one ${key}`);\n }\n return values[0];\n };\n\n const locationId = one(\"locationId\");\n if (!/^[A-Za-z0-9]{20}$/.test(locationId)) {\n throw new Error(\"contact pagination URL contains an unsafe locationId\");\n }\n if (locationId !== LOC) {\n throw new Error(\"contact pagination URL is not pinned to the Dogs Spot locationId\");\n }\n if (one(\"limit\") !== CONTACT_PAGE_SIZE) {\n throw new Error(`contact pagination URL changed the requested limit from ${CONTACT_PAGE_SIZE}`);\n }\n\n const startAfter = target.searchParams.getAll(\"startAfter\");\n const startAfterId = target.searchParams.getAll(\"startAfterId\");\n if (!continuation) {\n if (startAfter.length || startAfterId.length) {\n throw new Error(\"initial contact query unexpectedly contains a pagination cursor\");\n }\n return target;\n }\n if (startAfter.length !== 1 || startAfterId.length !== 1) {\n throw new Error(\"contact pagination URL must contain one complete cursor pair\");\n }\n if (!/^\\d{1,20}$/.test(startAfter[0]) || !/^[A-Za-z0-9_-]{1,128}$/.test(startAfterId[0])) {\n throw new Error(\"contact pagination URL contains an unsafe cursor\");\n }\n return target;\n}\n\nfunction bridgeTarget(configured: string): URL {\n let url: URL;\n try {\n url = new URL(configured || BRIDGE_URL);\n if (url.protocol !== \"https:\") throw new Error(\"HTTPS is required\");\n } catch {\n throw new Error(\"bridge journal unavailable: BRIDGE_URL is invalid\");\n }\n const allowed = new URL(BRIDGE_URL);\n if (url.origin !== allowed.origin || url.hostname !== allowed.hostname ||\n url.pathname !== allowed.pathname || url.username || url.password) {\n throw new Error(\"bridge journal unavailable: URL is outside the exact allowed origin\");\n }\n url.search = \"\";\n url.hash = \"\";\n return url;\n}\n\nexport async function readBridgeEvidence(\n nowMs: number,\n options: BridgeReadOptions = {},\n): Promise {\n if (!Number.isFinite(nowMs)) throw new Error(\"bridge journal unavailable: current time is invalid\");\n const admin = (options.admin ?? envValue(\"BRIDGE_ADMIN\") ?? \"\").trim();\n if (!admin) throw new Error(\"bridge journal unavailable: BRIDGE_ADMIN is not configured\");\n\n const configuredUrl = (options.bridgeUrl ?? envValue(\"BRIDGE_URL\") ?? \"\").trim();\n const url = bridgeTarget(configuredUrl);\n url.searchParams.set(\"dump\", \"1\");\n url.searchParams.set(\"admin\", admin);\n\n const timeoutMs = options.timeoutMs ?? BRIDGE_REQUEST_TIMEOUT_MS;\n if (!Number.isFinite(timeoutMs) || timeoutMs <= 0) throw new Error(\"bridge journal request budget is exhausted\");\n let response: ResponseLike;\n try {\n response = await (options.request ?? fetch)(url.toString(), {\n method: \"GET\",\n redirect: \"manual\",\n signal: AbortSignal.timeout(Math.max(1, Math.floor(timeoutMs))),\n }) as ResponseLike;\n } catch {\n throw new Error(\"bridge journal request failed\");\n }\n if (response.status >= 300 && response.status < 400) {\n throw new Error(`bridge journal refused redirect HTTP ${response.status}`);\n }\n if (!response.ok) throw new Error(`bridge journal request failed with HTTP ${response.status}`);\n\n let journal: unknown;\n try {\n journal = await response.json();\n } catch {\n throw new Error(\"bridge journal response was not valid JSON\");\n }\n if (!Array.isArray(journal)) throw new Error(\"bridge journal response was not an array\");\n if (journal.length === 0) {\n throw new Error(\"bridge journal returned zero rows; refusing to publish a zero-data watch report\");\n }\n if (journal.length > BRIDGE_JOURNAL_CAP) {\n throw new Error(`bridge journal exceeded its known ${BRIDGE_JOURNAL_CAP}-row cap`);\n }\n\n const times = journal.map((row, i) => {\n if (!row || typeof row !== \"object\" || Array.isArray(row)) {\n throw new Error(`bridge journal row ${i + 1} is malformed`);\n }\n const at = Date.parse(typeof row.ts === \"string\" ? row.ts : \"\");\n if (!Number.isFinite(at)) throw new Error(`bridge journal row ${i + 1} has an invalid timestamp`);\n if (at > nowMs + 5 * 60_000) throw new Error(`bridge journal row ${i + 1} has a future timestamp`);\n return at;\n });\n\n const ledger = paymentLedger(journal);\n if (ledger.length === 0) {\n throw new Error(\"bridge journal contained no Square payment records; refusing to publish a zero match ratio\");\n }\n if (ledger.some((row) => !Number.isFinite(row.atMs))) {\n throw new Error(\"bridge journal contains a Square payment with no readable timestamp\");\n }\n\n const oldestMs = Math.min(...times);\n const ratioStart = nowMs - RATIO_WINDOW_DAYS * RATIO_WINDOWS * DAY;\n const atCapacity = journal.length === BRIDGE_JOURNAL_CAP;\n const horizonComplete = !atCapacity || oldestMs <= ratioStart;\n if (!horizonComplete) {\n throw new Error(\"bridge journal history is truncated inside the match-ratio horizon\");\n }\n\n return {\n journal,\n payments: ledger.length,\n journalRows: journal.length,\n atCapacity,\n horizonComplete,\n oldestAt: new Date(oldestMs).toISOString(),\n ratio: {\n subject: \"Square payments\",\n points: ratioBuckets(ledger, nowMs, RATIO_WINDOW_DAYS, RATIO_WINDOWS),\n },\n };\n}\n\nexport async function readTransactions(\n get: (url: string) => Promise,\n nowMs = Date.now(),\n options: { pageSize?: number; pageCap?: number } = {},\n): Promise {\n const rawRows: any[] = [];\n const source = await fetchPayments(async (url) => {\n const body = await get(url);\n if (isRecord(body) && Array.isArray(body.data)) rawRows.push(...body.data);\n return body;\n }, {\n locationId: LOC,\n pageSize: options.pageSize,\n pageCap: options.pageCap ?? PAGE_CAP,\n now: nowMs,\n });\n\n const count = source.source.totalCount;\n if (count === 0) throw new Error(\"payment source returned zero transactions; refusing to publish\");\n if (rawRows.length !== count) throw new Error(`payment source read ${rawRows.length} of ${count}`);\n\n const statuses = { succeeded: 0, failed: 0, pending: 0 };\n let zeroOrTest = 0;\n const rows = rawRows.map((raw) => {\n const payment = toPayment(raw);\n if (!KNOWN_PAYMENT_STATUSES.has(payment.status)) {\n throw new Error(`unknown payment status for ${payment.id}: refusing to convert it to zero dollars`);\n }\n if (payment.status === \"succeeded\") statuses.succeeded++;\n else if (payment.status === \"failed\") statuses.failed++;\n else statuses.pending++;\n\n const statedCurrency = raw.currency ?? raw.currencyCode;\n if (statedCurrency != null &&\n (typeof statedCurrency !== \"string\" || statedCurrency.trim().toUpperCase() !== PAYMENT_CURRENCY)) {\n throw new Error(`payment ${payment.id} has an unsupported currency`);\n }\n if (!payment.at) throw new Error(`payment ${payment.id} has no createdAt timestamp`);\n const atMs = Date.parse(payment.at);\n if (!Number.isFinite(atMs)) throw new Error(`payment ${payment.id} has an invalid timestamp`);\n\n const isRevenue = payment.status === \"succeeded\" && payment.amount >= REAL_MONEY;\n if (payment.status === \"succeeded\" && !isRevenue) zeroOrTest++;\n return { atMs, dollars: isRevenue ? payment.amount : 0 };\n });\n\n return {\n rows,\n count,\n expected: source.source.totalCount,\n pages: source.source.pages,\n truncated: false,\n validTimestamps: rows.length,\n statuses,\n currency: PAYMENT_CURRENCY,\n amountUnit: PAYMENT_AMOUNT_UNIT,\n zeroOrTest,\n unknownSourceTypes: source.unknownTypes,\n };\n}\n\nexport async function readContactTimes(\n get: (url: string) => Promise,\n pageLimit = 3,\n nowMs = Date.now(),\n): Promise {\n if (!Number.isInteger(pageLimit) || pageLimit < 1 || pageLimit > 10) {\n throw new Error(\"invalid contact page limit\");\n }\n if (!Number.isFinite(nowMs)) throw new Error(\"contact source current time is invalid\");\n const timestamps: number[] = [];\n const seenUrls = new Set();\n let pages = 0;\n let url: URL | null = assertContactPageUrl(\n `${GHL}${CONTACT_PATH}?locationId=${LOC}&limit=${CONTACT_PAGE_SIZE}`,\n false,\n );\n while (url && pages < pageLimit) {\n const target = url;\n if (seenUrls.has(target.toString())) throw new Error(\"contact pagination repeated a page URL\");\n seenUrls.add(target.toString());\n\n const page = await get(target.toString());\n if (!isRecord(page)) {\n throw new Error(`contact page ${pages + 1} is malformed`);\n }\n if (!Array.isArray(page.contacts)) throw new Error(`contact page ${pages + 1} has no contacts array`);\n if (!isRecord(page.meta)) {\n throw new Error(`contact page ${pages + 1} has no metadata object`);\n }\n if (page.contacts.length > 100) throw new Error(`contact page ${pages + 1} exceeds its requested limit`);\n if (page.meta.nextPageUrl != null &&\n (typeof page.meta.nextPageUrl !== \"string\" || !page.meta.nextPageUrl.trim())) {\n throw new Error(`contact page ${pages + 1} has an invalid nextPageUrl`);\n }\n\n for (const contact of page.contacts) {\n if (!contact || typeof contact !== \"object\" || Array.isArray(contact)) {\n throw new Error(`contact page ${pages + 1} contains a malformed row`);\n }\n const at = Date.parse(String(contact.dateAdded ?? \"\"));\n if (!Number.isFinite(at)) throw new Error(\"contact row has an invalid dateAdded timestamp\");\n if (at > nowMs) throw new Error(\"contact row has a future dateAdded timestamp\");\n if (timestamps.length && at > timestamps[timestamps.length - 1]) {\n throw new Error(\"contact pages are not pinned newest-first\");\n }\n timestamps.push(at);\n }\n pages++;\n\n const next = page.meta.nextPageUrl ?? null;\n url = next ? assertContactPageUrl(next, true) : null;\n }\n if (timestamps.length === 0) throw new Error(\"contact source returned zero timestamps\");\n return { timestamps, rows: timestamps.length, pages };\n}\n\nconst CANONICAL_UTC_TIME = /^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}\\.\\d{3}Z$/;\nconst MAX_REPORT_PERSIST_LAG_MS = 5 * 60_000;\n\nconst isRecord = (value: unknown): value is Record => {\n try {\n return !!value && typeof value === \"object\" && !Array.isArray(value) &&\n Object.getPrototypeOf(value) === Object.prototype;\n } catch {\n return false;\n }\n};\n\nconst isNormalObjectDataDescriptor = (descriptor: PropertyDescriptor | undefined): boolean =>\n descriptor !== undefined && Object.prototype.hasOwnProperty.call(descriptor, \"value\") &&\n descriptor.enumerable === true && descriptor.writable === true && descriptor.configurable === true;\n\nfunction hasExactKeys(\n value: Record,\n required: readonly string[],\n optional: readonly string[] = [],\n): boolean {\n try {\n const allowed = new Set([...required, ...optional]);\n const keys = Reflect.ownKeys(value);\n return required.every((key) => keys.includes(key)) &&\n keys.every((key) => typeof key === \"string\" && allowed.has(key) &&\n isNormalObjectDataDescriptor(Object.getOwnPropertyDescriptor(value, key)));\n } catch {\n return false;\n }\n}\n\nfunction hasExactDataKeys(\n value: Record,\n required: readonly string[],\n optional: readonly string[] = [],\n): boolean {\n return hasExactKeys(value, required, optional);\n}\n\nfunction isExactArray(value: unknown): value is unknown[] {\n try {\n if (!Array.isArray(value) || Object.getPrototypeOf(value) !== Array.prototype) return false;\n const keys = Reflect.ownKeys(value);\n const lengthDescriptor = Object.getOwnPropertyDescriptor(value, \"length\");\n if (!lengthDescriptor || !Object.prototype.hasOwnProperty.call(lengthDescriptor, \"value\") ||\n typeof lengthDescriptor.value !== \"number\" || !Number.isSafeInteger(lengthDescriptor.value) ||\n lengthDescriptor.value < 0 || lengthDescriptor.enumerable !== false ||\n lengthDescriptor.writable !== true || lengthDescriptor.configurable !== false) return false;\n const length = lengthDescriptor.value;\n if (keys.length !== length + 1 || !keys.includes(\"length\")) return false;\n for (let i = 0; i < length; i++) {\n const key = String(i);\n if (!keys.includes(key) ||\n !isNormalObjectDataDescriptor(Object.getOwnPropertyDescriptor(value, key))) return false;\n }\n return keys.every((key) => key === \"length\" ||\n (typeof key === \"string\" && /^(?:0|[1-9]\\d*)$/.test(key) && Number(key) < length));\n } catch {\n return false;\n }\n}\n\nfunction isExactDataArray(value: unknown): value is unknown[] {\n return isExactArray(value);\n}\n\nfunction detachedExactData(\n value: unknown,\n fail: SchemaFailure,\n path: string,\n active: Set

Of the ${ptReadable ? pt.booked : \"unknown\"} Pup Talks: showed / no-show / never marked either way	${ptReadable ? `${pt.showed} / ${pt.noshow} / ${Math.max(0, pt.booked - pt.showed - pt.noshow)}` : \"Unknown\"}
Canceled (not counted above)	${ptReadable ? pt.cancelled : \"Unknown\"}
Show rate	${ptReadable ? `${pt.showed} of ${pt.booked} booked${pt.booked >= 5 ? ` (${pct(pt.showed, pt.booked)})` : \"\"}${Math.max(0, pt.booked - pt.showed - pt.noshow) > 0 && pt.showed + pt.noshow >= 5 ? `; of the ${pt.showed + pt.noshow} actually marked, ${pct(pt.showed, pt.showed + pt.noshow)}` : \"\"}` : \"Unknown\"}
Free Training Day booked / showed	${ftdReadable ? `${ftd.booked} / ${ftd.showed}${ftd.booked === 0 ? \" (none scheduled this week)\" : \"\"}` : \"Unknown\"}
Meta connection error	${esc(metaErr)}

Stage	People
${esc(STATUS_LABEL[s.k])}	${s.n}
Total in a sequence	${sum}

Segment	Count	Share	What can be done
Has an email	${c.emailable}	${pct(c.emailable, d.total)}	Address inventory only; not permission to release.
Email + consent snapshot clear	${c.releaseReady ?? 0}	${pct(c.releaseReady ?? 0, d.total)}	The only rows allowed into the dry-run batch plan.
Email, consent unknown	${c.consentUnknown ?? c.emailable}	${pct(c.consentUnknown ?? c.emailable, d.total)}	Held until each full contact DND snapshot is read.
Email blocked / DND	${c.emailBlocked ?? 0}	${pct(c.emailBlocked ?? 0, d.total)}	Excluded from the release.
Phone only	${c.phoneOnly}	${pct(c.phoneOnly, d.total)}	SMS — held until numbers are validated. Stale numbers get a business flagged by carriers.
Neither	${c.unreachable}	${pct(c.unreachable, d.total)}	Nothing by email or text. Reachable only inside Messenger, within Meta's window.
Excluded	${c.excluded}	${pct(c.excluded, d.total)}	Already customers, already on a path, flagged spam, or duplicates.

Campaign	Spent	Conversations	Cost each
Kims New Except4Ads#2	$180.64	47	$3.84
APRIL 10th Fresh February Leads - Copy	$170.89	44	$3.88
Email CSV AI Campaign	$116.49	22	$5.30
Training Tips-Messenger Leads-6/26	$86.96	14	$6.21
Free Training Day Website 6/19	$0.00	0	off
Total	$554.98	127	$4.37

Measure	This week	How it is worked out
Cost per click	$2.05	$164.00 divided by 80 clicks
Cost per conversion	$41.00	$164.00 divided by 4 conversions
Click through rate	8.25%	80 clicks divided by 970 impressions
Your share of available searches	32%	Google's figure, up from 29%
Rover's share of the same searches	24%	Google's figure, up from 22%

Channel	Messages in	Notes
Facebook	538	72% of everything that came in
Phone	71	120 calls in total, 24 unanswered
Text	71
Instagram	46
Email	4

Figure	Value	Source and method
Facebook spend	$554.98	Ads Manager, account 938090411743620, 31 Jul to 5 Aug, sum of the four live campaigns
Facebook conversations	127	Same view, sum of the Results column
Facebook cost per conversation	$4.37	554.98 divided by 127
Facebook consistency check	4 of 4	Each campaign's spend divided by its results matches Meta's own cost per result to the cent
Google spend, clicks, impressions, conversions	$164, 80, 970, 4	Google Ads overview, account 942-544-7945, 31 Jul to 6 Aug
New contacts, this week and last	175 and 197	CRM contact search on date added, converted to New York time before bucketing, two independent pulls agreed
Appointments	55 and 64	All 29 calendars queried one at a time, 197 raw events, bucketed on start time
Messages in and out	748 and 1,143	660 conversations pulled in full, 15,488 messages, system audit entries excluded
Calls	120, 96 answered	Call type messages, answered means completed
Opportunities won, all time	0	All 5,768 opportunities paginated: 5,594 open, 174 lost, 0 won, 0 abandoned. This is the pipeline view only, not a statement about money received
Payment records in the CRM	232 and 195	Transactions and orders. Three transactions fall inside this week, which is being checked before any return figure is quoted
Contacts with no source, 31 Jul to 5 Aug	120 of 149	Source field on each new contact record

Where the money went	Amount	How this page gets it
Facebook and Instagram3 August to 9 August 2026	$676.94	Read straight from the ad platform every time your card page loads. Read three times today, at 3:06 pm, 3:15 pm and 3:16 pm, and it said the same figure each time.
Google31 July to 6 August 2026	$164.00	Typed by hand. This is the figure in the message sent to you on 7 August. Google puts its own numbers behind a developer token, which Google quotes at about five business days. Google joins this page the same way Facebook has once that token lands, and until then every Google figure you see anywhere is one a person typed.

In the seven days 3 August to 9 August	Count
New people in your CRM	168
Of those, arrived through Facebook or Instagram	139
New cards on your Initial Lead Pipeline	166
Pup Talk appointments on your calendar	20
Of those, showed up	15
Cards that moved into your Customer column	2

Program price on the record	Records	Value
$3,295.00	39	$128,505.00
$2,395.00	11	$26,345.00
$3,795.00	3	$11,385.00
All valued records	53	$166,235.00

What happens to it	Payments	Value
Places itself. One booking open, so the money goes straight on it.	15	$7,880.00
Waits for one of your team to pick. More than one booking open.	0	$0.00
Booking already carries a value, so it is left exactly as it is.	15	$8,237.00
Stays where it is, and it is two separate causes. 3 worth $480.00 carry no name on the record. 3 worth $967.00 name a real customer whose booking sits on another board.	6	$1,447.00
All completed payments	36	$17,564.00

Read from the system itself at 3:12 pm today	Reading
Practice mode	On
Messages to real customers, all time	0
Records it is tracking	1
Practice messages produced	5
Version, and its last pass	1.7.1, 3:11 pm

Program price on the record	Records	Value
$3,295	39	$128,505.00
$2,395	11	$26,345.00
$3,795	3	$11,385.00
All valued records	53	$166,235.00

What happens to it	Payments	Value
Places itself. One booking open, so the money goes straight on it.	15	$7,880.00
Needs one of your team to pick. More than one booking open.	0	$0.00
Already has a value on the booking, so it is left alone.	15	$8,237.00
Cannot be placed, and it is two different problems. Three arrived against a record with no name on it at all. The other three name a real customer who has no card in your Customer column to put the money on.	6	$1,447.00
All completed payments	36	$17,564.00

Route	Payments	What it carries
Invoice raised in the CRM, paid by card	56	Arrives already attached to the customer. This is most of your real revenue.
Order form and manual charges	12	Same, attached to the customer.
Counter sale in Square with no name taken	8	Files against one nameless record. Nothing can ever place these.

What it finds	What it does
One open booking	Writes the amount on. No person involved.
More than one open booking	Puts it on an exception list for your team to pick. It never guesses.
No name on the payment	Reported separately as unplaceable. Never guessed at.
Booking already has a price on it	Left exactly as it is. It never overwrites anybody's number.

Outcome	Payments	Value
Places itself. One booking open.	15	$7,880.00
Goes to the exception list for your team to pick.	0	$0.00
Booking already priced, so left alone.	15	$8,237.00
Cannot be placed, reported separately.	6	$1,447.00
All completed payments	36	$17,564.00

Task	Who	How often
Take a name at the counter when somebody pays without one.	Front desk	Only fixes future payments, not past ones. Eight so far have no name.
Pick the right booking when a customer has more than one open.	Whoever you nominate	Zero times today. The list is empty.
Moving cards into Customer	Nobody	Already automated. Noted, and thank you for the correction.
Anything else	Nobody	The rest is automatic.

${esc(ch.name)}

Where your leads come from, and what goes back

Overall status

What this page deliberately does not claim

Did the ad leads actually land?

Did the ad leads actually land?

Did the ad leads actually land?

Some numbers could not be read

What last week's report said

What last week's report said

The Dogs Spot, the week in numbers

What happened, in words DRAFT until Amir reviews

New inquiries, last eight weeks

Where this week's inquiries came from

Why there is no revenue figure

Appendix, the fine print

This week's raw counts

How every number is computed

Nurture path registry

Holiday deposits

Holiday deposits

Holiday deposits

Holiday deposits

The Dogs Spot

Waiting on you

From first contact to paying customer

Is everything working?

Where the last 7 days of inquiries came from

Which ads they answered

New inquiries, week by week

What the advertising cost

What we have been doing

One thing worth fixing in the CRM

The follow-up system, in detail

What needs doing today

The Dogs Spot, Nurture Control Panel

Right now

Where those people are

Stop everything

${d.journalTotal <= entriesShown && groups.length <= RECENT_ROWS ? \"Everything it has done so far\" : \"What it has been doing\"}

Something went wrong in the last 24 hours

The dormant list — what is actually in it

Who can actually be contacted

How old it really is

The release plan

The Dogs Spot, week of 31 July to 6 August 2026

The thing worth two minutes

Facebook

Where the money went

Google

Your CRM

Where the 175 came from

The 175, since you asked what it counts

The gap between what the ads claim and what your CRM received

Appendix, every number and where it came from

What you spent, and what came back

1. What you spent, and what it brought

What your Square money is doing

What your bookings carry today

2. Where your people came from

3. What happened to those people

4. What your follow up system is doing

Your review pipeline, on one page for the first time

Where your money is, and what is missing

The money Square has sent across

The gap, in one sentence

What your bookings currently carry

What happens the moment the amount gets written

Two things worth knowing that nobody asked about

How Square money reaches your reports

1. What happens today

2. What happens once the reconciliation runs

3. What your staff actually have to do

The corrected unmatched figure you asked for

Diff · v1270