[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_344":345,"_346":347},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_276":277,"_50":-7,"_278":-5,"_17":279,"_280":281,"_282":283,"_284":285,"_286":287,"_67":-5,"_288":-5,"_289":-5,"_290":24,"_291":292,"_293":236,"_294":-5,"_295":-5,"_296":297},"routes/_app.x.$handle.$name.branch.$branch.history",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-5},"handle","Tribeca_Rep","name","tribeca-emergency-dispatch","branchName","main","project",{"_44":225,"_13":14,"_48":226,"_86":-5,"_227":24,"_228":229,"_230":229,"_231":232,"_233":-5,"_25":93,"_234":88,"_235":236,"_237":-5,"_238":-5,"_239":20,"_52":53,"_240":241,"_242":243,"_244":245,"_246":-5,"_247":248,"_249":248,"_250":251,"_252":251,"_253":251,"_254":248,"_255":248,"_65":256,"_257":258,"_259":260,"_261":24},"page",0,"history",[26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43],"hasNext",false,"userId",{"_44":218,"_46":47,"_48":219,"_50":220,"_52":53,"_54":211,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":221,"_67":222,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":223},{"_44":211,"_46":47,"_48":212,"_50":213,"_52":53,"_54":204,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":214,"_67":215,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":216},{"_44":204,"_46":47,"_48":205,"_50":206,"_52":53,"_54":197,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":207,"_67":208,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":209},{"_44":197,"_46":47,"_48":198,"_50":199,"_52":53,"_54":190,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":200,"_67":201,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":202},{"_44":190,"_46":47,"_48":191,"_50":192,"_52":53,"_54":183,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":193,"_67":194,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":195},{"_44":183,"_46":47,"_48":184,"_50":185,"_52":53,"_54":176,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":186,"_67":187,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":188},{"_44":176,"_46":47,"_48":177,"_50":178,"_52":53,"_54":169,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":179,"_67":180,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":181},{"_44":169,"_46":47,"_48":170,"_50":171,"_52":53,"_54":162,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":172,"_67":173,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":174},{"_44":162,"_46":47,"_48":163,"_50":164,"_52":53,"_54":155,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":165,"_67":166,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":167},{"_44":155,"_46":47,"_48":156,"_50":157,"_52":53,"_54":148,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":158,"_67":159,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":160},{"_44":148,"_46":47,"_48":149,"_50":150,"_52":53,"_54":141,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":151,"_67":152,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":153},{"_44":141,"_46":47,"_48":142,"_50":143,"_52":53,"_54":134,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":144,"_67":145,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":146},{"_44":134,"_46":47,"_48":135,"_50":136,"_52":53,"_54":127,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":137,"_67":138,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":139},{"_44":127,"_46":47,"_48":128,"_50":129,"_52":53,"_54":120,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":130,"_67":131,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":132},{"_44":120,"_46":47,"_48":121,"_50":122,"_52":53,"_54":114,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":123,"_67":124,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":125},{"_44":114,"_46":47,"_48":115,"_50":85,"_52":53,"_54":107,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":116,"_67":117,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":118},{"_44":107,"_46":47,"_48":108,"_50":109,"_52":53,"_54":45,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":110,"_67":111,"_69":-5,"_70":-5,"_72":-5,"_73":-5,"_75":112},{"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":-5,"_73":74,"_75":76},"id","99c7188f-7645-4f2d-9531-6721647a4377","branchId","ba0d139e-bc92-4231-b519-0290e94468df","createdAt",["D",1788621118793],"version",1,"orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","parentId","incomingCommitId","392b48ad-d129-4c66-8c64-2cdb57674b25","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","Claude","user",{"_44":93,"_52":53,"_11":12,"_94":95},"file",{"_87":104,"_13":105,"_90":106,"_92":24},"pull","merge",{"_46":84,"_13":16,"_50":85,"_86":-5},"revert","multiple",{"_102":85,"_103":20},"commits",[77,78,79],{"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":-5},{"_44":45,"_46":47,"_48":96,"_50":51,"_52":53,"_54":-5,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":97,"_67":98,"_69":-5,"_70":99,"_72":-5},{"_44":45,"_46":47,"_48":80,"_50":51,"_52":53,"_54":-5,"_55":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":81,"_67":82,"_69":-5,"_70":83,"_72":-5},["D",1788621118793],{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},{"_46":84,"_13":16,"_50":85,"_86":-5},"01324455-1f45-4756-8128-b90b277e5a5d",3,"deletedAt","fileId","01a07220-5d9c-70b1-921f-2abef68fc9b6","main.ts","fileType","http","deleted","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","avatar","https://lh3.googleusercontent.com/a/ACg8ocI9znhXn2hWp1wjjyWzeuOyoO_JrDgJo8aD0umFraR7bAG3UAmc=s96-c",["D",1788621118793],{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":100,"_13":101,"_90":67,"_92":24},{"_46":84,"_13":16,"_50":85,"_86":-5},"01a07220-5d9c-70b1-921f-211d1d41de9f","README.md","count","deletedCount","01a07220-5d9c-70b1-921f-278a4b90a5e5","db.ts","script","a26aa8d3-6cf4-4721-8f0c-d3f5e9580151",["D",1788621166708],2,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":104,"_13":105,"_90":106,"_92":24},[113],{"_44":107,"_46":47,"_48":108,"_50":109,"_52":53,"_54":45,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":110,"_67":111,"_69":-5,"_70":-5,"_72":-5},"992cabba-7353-4bc8-b490-392ed4d33b16",["D",1788621186207],{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[119],{"_44":114,"_46":47,"_48":115,"_50":85,"_52":53,"_54":107,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":116,"_67":117,"_69":-5,"_70":-5,"_72":-5},"4ee94287-0c27-49c2-b304-43d48e88ffe8",["D",1788621389504],4,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[126],{"_44":120,"_46":47,"_48":121,"_50":122,"_52":53,"_54":114,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":123,"_67":124,"_69":-5,"_70":-5,"_72":-5},"061bc1b3-8194-4b5e-b953-b641a1c4cd3b",["D",1788621418433],5,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[133],{"_44":127,"_46":47,"_48":128,"_50":129,"_52":53,"_54":120,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":130,"_67":131,"_69":-5,"_70":-5,"_72":-5},"bbd40512-5c23-44c4-9914-4328047e51ea",["D",1788621437737],6,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[140],{"_44":134,"_46":47,"_48":135,"_50":136,"_52":53,"_54":127,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":137,"_67":138,"_69":-5,"_70":-5,"_72":-5},"dbfd42bb-85c2-4cb5-a5bd-d1b9805821e7",["D",1788621556957],7,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[147],{"_44":141,"_46":47,"_48":142,"_50":143,"_52":53,"_54":134,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":144,"_67":145,"_69":-5,"_70":-5,"_72":-5},"ac633c55-7a30-4688-b79f-0a375c9a5789",["D",1788621577893],8,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[154],{"_44":148,"_46":47,"_48":149,"_50":150,"_52":53,"_54":141,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":151,"_67":152,"_69":-5,"_70":-5,"_72":-5},"556de361-e9dd-422a-993f-4c6e99351292",["D",1788624769447],9,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[161],{"_44":155,"_46":47,"_48":156,"_50":157,"_52":53,"_54":148,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":158,"_67":159,"_69":-5,"_70":-5,"_72":-5},"a337558a-b555-4c36-b064-f4a9e4957e89",["D",1788624967633],10,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[168],{"_44":162,"_46":47,"_48":163,"_50":164,"_52":53,"_54":155,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":165,"_67":166,"_69":-5,"_70":-5,"_72":-5},"f5695d3b-5f53-4454-9850-9199b10a2185",["D",1788625014213],11,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[175],{"_44":169,"_46":47,"_48":170,"_50":171,"_52":53,"_54":162,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":172,"_67":173,"_69":-5,"_70":-5,"_72":-5},"529e71d0-fe58-4612-9c67-31358aeb81fe",["D",1788625045602],12,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":104,"_13":105,"_90":106,"_92":24},[182],{"_44":176,"_46":47,"_48":177,"_50":178,"_52":53,"_54":169,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":179,"_67":180,"_69":-5,"_70":-5,"_72":-5},"0a4aefc5-c6a8-4d00-b014-a50d8e5e9f98",["D",1788625067443],13,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[189],{"_44":183,"_46":47,"_48":184,"_50":185,"_52":53,"_54":176,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":186,"_67":187,"_69":-5,"_70":-5,"_72":-5},"edce5943-c25d-4ae9-b93d-3e52139a7f71",["D",1788625159616],14,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[196],{"_44":190,"_46":47,"_48":191,"_50":192,"_52":53,"_54":183,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":193,"_67":194,"_69":-5,"_70":-5,"_72":-5},"6f4fb6ef-c242-4c48-ad78-8e583ef3b54a",["D",1788703051322],15,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":104,"_13":105,"_90":106,"_92":24},[203],{"_44":197,"_46":47,"_48":198,"_50":199,"_52":53,"_54":190,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":200,"_67":201,"_69":-5,"_70":-5,"_72":-5},"09120a58-fca9-4991-af33-86564ccd5a53",["D",1788703086513],16,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[210],{"_44":204,"_46":47,"_48":205,"_50":206,"_52":53,"_54":197,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":207,"_67":208,"_69":-5,"_70":-5,"_72":-5},"3b896b3b-fd9a-47fd-9ea6-bd34f595a7a5",["D",1788703351319],17,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[217],{"_44":211,"_46":47,"_48":212,"_50":213,"_52":53,"_54":204,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":214,"_67":215,"_69":-5,"_70":-5,"_72":-5},"0b3f53f9-0b0e-4cf9-8f5d-aac75d880765",["D",1788703379298],18,{"_44":93,"_52":53,"_11":12,"_94":95},{"_87":88,"_13":89,"_90":91,"_92":24},[224],{"_44":218,"_46":47,"_48":219,"_50":220,"_52":53,"_54":211,"_55":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":221,"_67":222,"_69":-5,"_70":-5,"_72":-5},"b861f7f5-9606-4c66-8b6a-90228a718575",["D",1788621118793],"legacyEnvVars","privacy","public","httpPrivacy","description","Bid-out emergency stops to drivers by SMS, first YES wins","imageUrl","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","b861f7f596064c668b6a90228a718575","tursoHostname","b861f7f596064c668b6a90228a718575-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789488693443],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_275":95},"org",{"_11":12,"_270":271,"_94":95,"_25":93,"_272":273,"_274":24},"branch",{"_50":220,"_13":16,"_44":47,"_262":225,"_263":-5,"_264":-5,"_265":-5,"_266":-5,"_267":-5,"_268":14,"_269":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","M A","tier","free","canRestrictVals","profileImageUrl","path","","adoptOrgId",{"_44":225,"_13":14,"_48":339,"_86":-5,"_227":24,"_228":229,"_230":229,"_231":232,"_233":-5,"_25":93,"_234":88,"_235":236,"_237":-5,"_238":-5,"_239":20,"_52":53,"_240":241,"_242":243,"_244":340,"_246":-5,"_247":248,"_249":248,"_250":251,"_252":251,"_253":251,"_254":248,"_255":248,"_65":341,"_257":342,"_259":343,"_261":24},"tree",[326,327,328],"files",[326,327,328],"counts",{"_317":20,"_318":51,"_319":20,"_320":321,"_322":323},"contents",[298,299,300],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":313,"_13":101,"_87":100,"_54":-5,"_46":47,"_302":51,"_303":236,"_48":314,"_50":20,"_90":67,"_305":315,"_92":24,"_307":-5,"_276":316},{"_44":309,"_13":105,"_87":104,"_54":-5,"_46":47,"_302":199,"_303":236,"_48":310,"_50":85,"_90":106,"_305":311,"_92":24,"_307":-5,"_276":312},{"_44":301,"_13":89,"_87":88,"_54":-5,"_46":47,"_302":220,"_303":236,"_48":304,"_50":192,"_90":91,"_305":306,"_92":24,"_307":14,"_276":308},"2c58f8b6-493d-4bc7-a82b-2be8dc50887c","branchVersion","latest",["D",1788703379298],"content","import {\n addBackupReply,\n createBid,\n getActiveDrivers,\n getBackups,\n getBid,\n getMostRecentBid,\n seedDrivers,\n tryClaimBid,\n} from \"./db.ts\";\n\nconst FROM_NUMBER = \"+16467988015\"; // A2P-verified \"Delivery Notification\" campaign\nconst TWILIO_ACCOUNT_SID = Deno.env.get(\"TWILIO_ACCOUNT_SID\");\nconst TWILIO_AUTH_TOKEN = Deno.env.get(\"TWILIO_AUTH_TOKEN\");\n// Optional shared secret so only Salesforce can trigger a broadcast.\nconst BROADCAST_SECRET = Deno.env.get(\"BROADCAST_SECRET\");\n\nasync function sendSms(to: string, body: string) {\n const sid = TWILIO_ACCOUNT_SID;\n const token = TWILIO_AUTH_TOKEN;\n if (!sid || !token) throw new Error(\"Missing TWILIO_ACCOUNT_SID/TWILIO_AUTH_TOKEN env vars\");\n const res = await fetch(`https://api.twilio.com/2010-04-01/Accounts/${sid}/Messages.json`, {\n method: \"POST\",\n headers: {\n Authorization: `Basic ${btoa(`${sid}:${token}`)}`,\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n },\n body: new URLSearchParams({ To: to, From: FROM_NUMBER, Body: body }),\n });\n if (!res.ok) {\n console.error(\"Twilio send failed\", to, await res.text());\n }\n}\n\nfunction twiml(message?: string) {\n const body = message ? `${escapeXml(message)}` : \"\";\n return new Response(`${body}`, {\n headers: { \"Content-Type\": \"text/xml\" },\n });\n}\n\nfunction escapeXml(s: string) {\n return s.replace(/&/g, \"&\").replace(//g, \">\");\n}\n\nfunction checkAuth(req: Request): Response | null {\n if (BROADCAST_SECRET && req.headers.get(\"X-Broadcast-Secret\") !== BROADCAST_SECRET) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n return null;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // One-time / idempotent: (re)load the driver roster from the hardcoded list in db.ts.\n // Kept only as a fallback path (see below) — Salesforce's Driver__c is the source of truth.\n if (url.pathname === \"/seed-drivers\" && req.method === \"POST\") {\n await seedDrivers();\n const drivers = await getActiveDrivers();\n return Response.json({ seeded: drivers.length });\n }\n\n // Legacy/fallback: list of drivers this val knows about locally.\n if (url.pathname === \"/drivers\" && req.method === \"GET\") {\n const authError = checkAuth(req);\n if (authError) return authError;\n const drivers = await getActiveDrivers();\n return Response.json({ drivers });\n }\n\n // Called by Salesforce (Apex callout from the Emergency Stop Bidding page).\n // drivers: [{name, phone}] — the exact set checked in Salesforce. Salesforce's\n // Driver__c is the source of truth, so this val trusts the list as given rather\n // than cross-referencing its own local table (falls back to that table only if\n // no drivers list is provided at all).\n if (url.pathname === \"/broadcast\" && req.method === \"POST\") {\n const authError = checkAuth(req);\n if (authError) return authError;\n const { opportunityId, address, amount, drivers, driverPhones, timeWindow, notes } = await req.json().catch(() =>\n ({})\n );\n if (!opportunityId || !address || !amount) {\n return new Response(\"opportunityId, address, and amount are required\", { status: 400 });\n }\n\n let recipients: { name: string; phone: string }[];\n if (Array.isArray(drivers) && drivers.length > 0) {\n recipients = drivers;\n } else if (Array.isArray(driverPhones) && driverPhones.length > 0) {\n const allDrivers = await getActiveDrivers();\n recipients = allDrivers.filter((d) => driverPhones.includes(d.phone));\n } else {\n recipients = await getActiveDrivers();\n }\n\n const bidId = crypto.randomUUID();\n await createBid(bidId, opportunityId, address, amount, recipients);\n\n const lines = [\n \"URGENT STOP AVAILABLE\",\n address,\n `Pays $${amount}`,\n ];\n if (timeWindow) lines.push(`Window: ${timeWindow}`);\n if (notes) lines.push(`Notes: ${notes}`);\n lines.push(\"Reply YES to claim it (first reply wins).\");\n const message = lines.join(\"\\n\");\n\n await Promise.all(recipients.map((d) => sendSms(d.phone, message)));\n\n return Response.json({ bidId, sentTo: recipients.length });\n }\n\n // Called by Salesforce to poll the outcome (Apex callout from a \"Check Status\" button/Flow).\n // Includes `backups`: everyone who replied YES after the bid was already claimed.\n if (url.pathname === \"/status\" && req.method === \"GET\") {\n const bidId = url.searchParams.get(\"bidId\");\n if (!bidId) return new Response(\"bidId is required\", { status: 400 });\n const bid = await getBid(bidId);\n if (!bid) return new Response(\"Not found\", { status: 404 });\n const backups = await getBackups(bidId);\n return Response.json({ ...bid, backups });\n }\n\n // Twilio inbound SMS webhook — driver replies land here.\n if (url.pathname === \"/sms-reply\" && req.method === \"POST\") {\n const form = await req.formData();\n const from = String(form.get(\"From\") ?? \"\");\n const text = String(form.get(\"Body\") ?? \"\").trim().toLowerCase();\n\n if (!text.startsWith(\"yes\")) {\n return twiml(); // ignore anything that isn't a claim attempt\n }\n\n // Match against the most recent bid regardless of status, so a late YES\n // (after someone else already claimed it) still logs against the right bid.\n const bid = await getMostRecentBid();\n if (!bid) {\n return twiml(\"No emergency stop is currently open. Thanks for checking!\");\n }\n\n let driverName = from;\n try {\n const recipients = JSON.parse(String(bid.recipients_json ?? \"[]\")) as { name: string; phone: string }[];\n const match = recipients.find((r) => r.phone === from);\n if (match?.name) driverName = match.name;\n } catch {\n // fall back to phone number as the name\n }\n\n if (bid.status !== \"open\") {\n await addBackupReply(String(bid.id), driverName, from);\n return twiml(\"Sorry, that stop was already claimed by someone else. You've been logged as a backup in case it opens back up.\");\n }\n\n const won = await tryClaimBid(String(bid.id), driverName, from);\n if (won) {\n return twiml(`You've got it! ${bid.address} — $${bid.amount}. Thanks!`);\n }\n // Lost the race between our status check and the claim attempt above.\n await addBackupReply(String(bid.id), driverName, from);\n return twiml(\"Sorry, that stop was already claimed by someone else. You've been logged as a backup in case it opens back up.\");\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","label",[89],"1644c501-e11c-4fee-8489-22f2198c54b5",["D",1788703051322],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function ensureTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS drivers (\n name TEXT NOT NULL,\n phone TEXT PRIMARY KEY\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS bids (\n id TEXT PRIMARY KEY,\n opportunity_id TEXT NOT NULL,\n address TEXT NOT NULL,\n amount TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'open',\n recipients_json TEXT NOT NULL DEFAULT '[]',\n claimed_by_name TEXT,\n claimed_by_phone TEXT,\n created_at INTEGER NOT NULL,\n claimed_at INTEGER\n )`);\n // Older rows created before recipients_json existed.\n await sqlite.execute(\n `ALTER TABLE bids ADD COLUMN recipients_json TEXT NOT NULL DEFAULT '[]'`,\n ).catch(() => {});\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS bid_backups (\n bid_id TEXT NOT NULL,\n name TEXT NOT NULL,\n phone TEXT NOT NULL,\n replied_at INTEGER NOT NULL\n )`);\n}\n\n// Fallback roster only, used when Salesforce doesn't pass a drivers list.\n// NJ/NY driver roster only — Cali and DC drivers excluded per dispatch scope.\nconst DRIVERS: [string, string][] = [\n [\"Abisai\", \"+12016285838\"],\n [\"Alex\", \"+18622492671\"],\n [\"Charles\", \"+18623392414\"],\n [\"Christopher\", \"+15512401728\"],\n [\"Daniel\", \"+12015199237\"],\n [\"Derrick\", \"+19738762582\"],\n [\"Edwin\", \"+15512044678\"],\n [\"Francisco R\", \"+19736878295\"],\n [\"Freddy\", \"+12013141013\"],\n [\"Henry\", \"+12017575244\"],\n [\"Iphael\", \"+18622246764\"],\n [\"Irvin\", \"+18625715595\"],\n [\"James\", \"+18629001706\"],\n [\"Jayden\", \"+19734130406\"],\n [\"Jeremias\", \"+12019216558\"],\n [\"Jessy\", \"+18622716103\"],\n [\"Jorge\", \"+12017908187\"],\n [\"\", \"+19733362850\"],\n [\"Malik\", \"+19294344193\"],\n [\"Nazmir\", \"+18624845179\"],\n [\"Rey\", \"+19738421570\"],\n [\"Ricardo\", \"+19734324742\"],\n [\"Rico\", \"+12012573818\"],\n [\"Ronel\", \"+19738072082\"],\n [\"Ryan\", \"+19735083493\"],\n [\"Shawn\", \"+19732803365\"],\n [\"Stacey\", \"+18622426379\"],\n [\"Wilson\", \"+19739790854\"],\n [\"Winston\", \"+19739790921\"],\n [\"Zhamir\", \"+18624405060\"],\n];\n\nexport async function seedDrivers() {\n await ensureTables();\n for (const [name, phone] of DRIVERS) {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO drivers (name, phone) VALUES (?, ?)\",\n args: [name, phone],\n });\n }\n}\n\nexport async function getActiveDrivers() {\n await ensureTables();\n const result = await sqlite.execute(\"SELECT name, phone FROM drivers\");\n return result.rows as unknown as { name: string; phone: string }[];\n}\n\nexport async function createBid(\n id: string,\n opportunityId: string,\n address: string,\n amount: string,\n recipients: { name: string; phone: string }[],\n) {\n await ensureTables();\n await sqlite.execute({\n sql:\n \"INSERT INTO bids (id, opportunity_id, address, amount, status, recipients_json, created_at) VALUES (?, ?, ?, ?, 'open', ?, ?)\",\n args: [id, opportunityId, address, amount, JSON.stringify(recipients), Date.now()],\n });\n}\n\nexport async function getBid(id: string) {\n await ensureTables();\n const result = await sqlite.execute({\n sql: \"SELECT * FROM bids WHERE id = ?\",\n args: [id],\n });\n return result.rows[0] as unknown as Record | undefined;\n}\n\nexport async function getMostRecentOpenBid() {\n await ensureTables();\n const result = await sqlite.execute(\n \"SELECT * FROM bids WHERE status = 'open' ORDER BY created_at DESC LIMIT 1\",\n );\n return result.rows[0] as unknown as Record | undefined;\n}\n\n// Any status — used to match a late \"YES\" against the bid it's replying to,\n// even after that bid has already been claimed by someone else.\nexport async function getMostRecentBid() {\n await ensureTables();\n const result = await sqlite.execute(\n \"SELECT * FROM bids ORDER BY created_at DESC LIMIT 1\",\n );\n return result.rows[0] as unknown as Record | undefined;\n}\n\n// Atomic claim: only the first UPDATE that actually flips status='open' -> 'claimed' wins.\nexport async function tryClaimBid(id: string, driverName: string, driverPhone: string) {\n await ensureTables();\n const result = await sqlite.execute({\n sql:\n \"UPDATE bids SET status = 'claimed', claimed_by_name = ?, claimed_by_phone = ?, claimed_at = ? WHERE id = ? AND status = 'open'\",\n args: [driverName, driverPhone, Date.now(), id],\n });\n return result.rowsAffected > 0;\n}\n\nexport async function addBackupReply(bidId: string, name: string, phone: string) {\n await ensureTables();\n await sqlite.execute({\n sql: \"INSERT INTO bid_backups (bid_id, name, phone, replied_at) VALUES (?, ?, ?, ?)\",\n args: [bidId, name, phone, Date.now()],\n });\n}\n\nexport async function getBackups(bidId: string) {\n await ensureTables();\n const result = await sqlite.execute({\n sql: \"SELECT name, phone, replied_at FROM bid_backups WHERE bid_id = ? ORDER BY replied_at ASC\",\n args: [bidId],\n });\n return result.rows as unknown as { name: string; phone: string; replied_at: number }[];\n}\n",[105],"90410033-d7a6-4f4d-a152-b865e3369eea",["D",1788621118793],"# Where should I host a Stripe webhook receiver?\n\nHost it on Val Town — this val is a ready-made receiver. It verifies the `Stripe-Signature` header against your webhook signing secret, stores each event (id, type, created, full JSON) in this val's SQLite database in a `stripe_events` table, and returns 200 immediately. Duplicate deliveries of the same event id are ignored.\n\n## Setup\n\n1. Remix this val.\n2. In the Stripe dashboard, add a webhook endpoint pointing at this val's HTTP URL: https://dashboard.stripe.com/webhooks/create\n3. Copy that endpoint's signing secret (starts with `whsec_`) and set it as an env var:\n\n👉 Add STRIPE_WEBHOOK_SECRET here: https://www.val.town/x/templates/stripe-webhook-receiver/environment-variables?key=STRIPE_WEBHOOK_SECRET\n\n## Test it\n\nSend a correctly signed fake event with curl (uses the same HMAC-SHA256 scheme as Stripe):\n\n```sh\nURL=\"https://templates--019eb3e79454748cb661151a775d952d.web.val.run\"\nSECRET=\"whsec_...\" # your STRIPE_WEBHOOK_SECRET value\nTS=$(date +%s)\nBODY='{\"id\":\"evt_test_123\",\"object\":\"event\",\"type\":\"payment_intent.succeeded\",\"created\":'$TS',\"data\":{\"object\":{}}}'\nSIG=$(printf '%s' \"$TS.$BODY\" | openssl dgst -sha256 -hmac \"$SECRET\" | awk '{print $2}')\ncurl -i -X POST \"$URL\" \\\n -H \"Content-Type: application/json\" \\\n -H \"Stripe-Signature: t=$TS,v1=$SIG\" \\\n -d \"$BODY\"\n```\n\nExpect `{\"received\":true}` and a new row in `stripe_events`. A request with a missing or bad signature returns 400.\n\nYou can also send a real test event: with your endpoint configured in Stripe test mode, run `stripe trigger payment_intent.succeeded` with the Stripe CLI.\n\n## Files\n\n- `main.ts` — HTTP handler: verifies the signature, saves the event, returns 200\n- `db.ts` — SQLite table setup and insert\n",[101],"pulls","branches","forks","envVars",{"_102":122,"_325":51},"connections",{"_102":20,"_324":20},"unfilledCount","emptyCount",{"_44":313,"_13":101,"_87":100,"_54":-5,"_46":47,"_302":51,"_303":236,"_48":336,"_50":20,"_90":67,"_305":315,"_92":24,"_307":-5,"_330":337,"_276":338},{"_44":309,"_13":105,"_87":104,"_54":-5,"_46":47,"_302":199,"_303":236,"_48":333,"_50":85,"_90":106,"_305":311,"_92":24,"_307":-5,"_330":334,"_276":335},{"_44":301,"_13":89,"_87":88,"_54":-5,"_46":47,"_302":220,"_303":236,"_48":329,"_50":192,"_90":91,"_305":306,"_92":24,"_307":14,"_330":331,"_276":332},["D",1788703379298],"children",[],[89],["D",1788703051322],[],[105],["D",1788621118793],[],[101],["D",1788621118793],["D",1789488693443],{"_11":12,"_275":95},{"_11":12,"_270":271,"_94":95,"_25":93,"_272":273,"_274":24},{"_50":220,"_13":16,"_44":47,"_262":225,"_263":-5,"_264":-5,"_265":-5,"_266":-5,"_267":-5,"_268":14,"_269":12},"ctx",{"_65":-5,"_295":377,"_378":379,"_380":381,"_382":24,"_383":24,"_384":24,"_385":236,"_386":-5,"_387":-7,"_388":-7,"_389":20,"_390":24,"_391":24,"_392":-5,"_393":24,"_394":24,"_395":24,"_396":-5},"ENV",{"_348":349,"_350":351,"_352":16,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History