[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","russambrose","name","Rallyemail2","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","882bc1b7-b2ac-44de-a254-72416723f847","main.ts","fileId","ea187bd8-674e-11f1-b5ed-1607ee4eb77e","parentId","branchId","c1cd1dd6-ed81-488c-9112-d30465d20857","branchVersion",18,"latest",true,"createdAt",["D",1781784640921],17,"fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\n\ninterface WaypointPing {\n id: string;\n teamName: string;\n carNumber: string;\n waypointName: string;\n waypointId: string;\n detectionTime: string;\n correctedTime: string;\n speed: number | null;\n latitude: number;\n longitude: number;\n distance: number;\n phoneNumber?: string;\n receivedAt: string;\n}\n\ninterface BatchHistory {\n sentAt: string;\n waypointCount: number;\n pingCount: number;\n emailsSent: number;\n}\n\nconst PINGS_KEY = \"rally_batch_pings\";\nconst HISTORY_KEY = \"rally_batch_history\";\nconst LAST_BATCH_KEY = \"rally_last_batch_time\";\n\nfunction stripNonLatin1(str: string): string {\n return str\n .replace(/\\u{1F3C1}/gu, \"[FLAG]\")\n .replace(/\\u{1F4CD}/gu, \"[MAP]\")\n .replace(/\\u{1F4E7}/gu, \"[EMAIL]\")\n .replace(/\\u{1F4F1}/gu, \"[PHONE]\")\n .replace(/\\u{1F4E1}/gu, \"[SAT]\")\n .replace(/\\u{2705}/gu, \"[OK]\")\n .replace(/\\u{23F1}/gu, \"[TIMER]\")\n .replace(/\\u2014/g, \"-\")\n .replace(/\\u2013/g, \"-\")\n .replace(/\\u2018/g, \"'\")\n .replace(/\\u2019/g, \"'\")\n .replace(/\\u201C/g, '\"')\n .replace(/\\u201D/g, '\"')\n .replace(/\\u2026/g, \"...\")\n .replace(/\\u00B0/g, \" deg\")\n .replace(/[^\\x00-\\xFF]/g, \"\");\n}\n\nasync function getPings(): Promise {\n try {\n const data = await blob.getJSON(PINGS_KEY);\n return (data as WaypointPing[]) || [];\n } catch {\n return [];\n }\n}\n\nasync function savePings(pings: WaypointPing[]): Promise {\n await blob.setJSON(PINGS_KEY, pings);\n}\n\nasync function getHistory(): Promise {\n try {\n const data = await blob.getJSON(HISTORY_KEY);\n return (data as BatchHistory[]) || [];\n } catch {\n return [];\n }\n}\n\nasync function saveHistory(history: BatchHistory[]): Promise {\n await blob.setJSON(HISTORY_KEY, history.slice(0, 50));\n}\n\nfunction jsonResponse(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization\",\n },\n });\n}\n\nasync function sendMailjetEmail(\n to: string[],\n subject: string,\n html: string,\n bcc?: string[],\n): Promise<{ success: boolean; error?: string }> {\n const apiKey = \"ecaac5dc21694a51da97097f10700b2f\";\n const secretKey = \"30f3f63367d81c21763633a7d33bef86\";\n\n const safeSubject = stripNonLatin1(subject);\n const safeHtml = stripNonLatin1(html);\n\n const toList = to.map((email) => ({ Email: email.trim() }));\n const message: Record = {\n From: { Email: \"waypointtracker@gmail.com\", Name: \"Rally Batch Report\" },\n To: toList,\n Subject: safeSubject,\n HTMLPart: safeHtml,\n };\n\n if (bcc && bcc.length > 0) {\n message.Bcc = bcc.map((email) => ({ Email: email.trim() }));\n }\n\n const authHeader = btoa(\n `

{apiKey}:

{secretKey}`,\n );\n\n try {\n const response = await fetch(\"https://api.mailjet.com/v3.1/send\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: `Basic ${authHeader}`,\n },\n body: JSON.stringify({ Messages: [message] }),\n });\n\n if (response.ok) {\n return { success: true };\n }\n\n const data = await response.json();\n return {\n success: false,\n error: data.ErrorMessage || `Mailjet HTTP ${response.status}`,\n };\n } catch (err: any) {\n return { success: false, error: err.message };\n }\n}\n\nfunction buildBatchEmailHtml(\n waypointName: string,\n pings: WaypointPing[],\n batchStart: string,\n batchEnd: string,\n): string {\n const sorted = [...pings].sort(\n (a, b) =>\n new Date(a.correctedTime).getTime() - new Date(b.correctedTime).getTime(),\n );\n\n const rows = sorted\n .map((ping, index) => {\n const corrTime = new Date(ping.correctedTime).toLocaleTimeString(\n \"en-AU\",\n {\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n hour12: true,\n },\n );\n const speedStr = ping.speed != null\n ? `${ping.speed.toFixed(1)} km/h`\n : \"N/A\";\n const mapsLink =\n `https://maps.google.com/?q=

{ping.latitude},

{ping.longitude}`;\n const bgColor = index % 2 === 0 ? \"#f9fafb\" : \"#ffffff\";\n\n return `\n \n ${\n stripNonLatin1(ping.teamName)\n }\n #${\n stripNonLatin1(ping.carNumber)\n }\n ${corrTime}\n ${speedStr}\n ${\n ping.distance.toFixed(0)\n }m\n Map\n \n `;\n })\n .join(\"\");\n\n const startTime = new Date(batchStart).toLocaleTimeString(\"en-AU\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: true,\n });\n const endTime = new Date(batchEnd).toLocaleTimeString(\"en-AU\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: true,\n });\n\n return `\n

\n [WAYPOINT] ${stripNonLatin1(waypointName)}\n

\n Batch Report: ${startTime} -$ {endTime} | ${sorted.length} team(s) passed\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n ${rows}\n \n

Team	Car#	Time	Speed	Dist	Map

\n \n

\n Generated by Rally Batch Reporter - ${\n new Date().toLocaleString(\"en-AU\")\n }\n

\n `;\n}\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n status: 204,\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization\",\n },\n });\n }\n\n const url = new URL(req.url);\n const path = url.pathname;\n\n if (\n req.method === \"POST\" && (path === \"/ping\" || path === \"/\" || path === \"\")\n ) {\n try {\n const body = await req.json();\n\n if (body.to && body.subject && body.html) {\n const recipients = Array.isArray(body.to) ? body.to : [body.to];\n const bccList = body.bcc\n ? (Array.isArray(body.bcc) ? body.bcc : [body.bcc])\n : undefined;\n\n const result = await sendMailjetEmail(\n recipients,\n body.subject,\n body.html,\n bccList,\n );\n\n if (result.success) {\n return jsonResponse({\n success: true,\n message: \"Email sent successfully\",\n });\n } else {\n return jsonResponse({ success: false, error: result.error }, 500);\n }\n }\n\n if (!body.waypointName || !body.teamName) {\n return jsonResponse(\n { error: \"Missing required fields: waypointName, teamName\" },\n 400,\n );\n }\n\n const ping: WaypointPing = {\n id: crypto.randomUUID(),\n teamName: body.teamName || \"Unknown\",\n carNumber: body.carNumber || \"N/A\",\n waypointName: body.waypointName,\n waypointId: body.waypointId || \"\",\n detectionTime: body.detectionTime || new Date().toISOString(),\n correctedTime: body.correctedTime || body.detectionTime ||\n new Date().toISOString(),\n speed: body.speed ?? null,\n latitude: body.latitude || 0,\n longitude: body.longitude || 0,\n distance: body.distance || 0,\n phoneNumber: body.phoneNumber || \"\",\n receivedAt: new Date().toISOString(),\n };\n\n const pings = await getPings();\n pings.push(ping);\n await savePings(pings);\n\n return jsonResponse({\n success: true,\n message:\n `Ping received for

{ping.teamName} at

{ping.waypointName}`,\n pendingCount: pings.length,\n });\n } catch (err: any) {\n return jsonResponse({ error: \"Invalid request: \" + err.message }, 400);\n }\n }\n\n if (req.method === \"GET\" && path === \"/batch\") {\n const secret = Deno.env.get(\"BATCH_SECRET\");\n if (secret) {\n const authParam = url.searchParams.get(\"secret\");\n const authHeader = req.headers.get(\"Authorization\");\n if (authParam !== secret && authHeader !== `Bearer ${secret}`) {\n return jsonResponse({ error: \"Unauthorized\" }, 401);\n }\n }\n\n const rallyBossEmail = \"waypointtracker@gmail.com\";\n const pings = await getPings();\n\n if (pings.length === 0) {\n return jsonResponse({\n success: true,\n message: \"No pending pings to send\",\n emailsSent: 0,\n });\n }\n\n const grouped: Record = {};\n for (const ping of pings) {\n const key = ping.waypointName;\n if (!grouped[key]) grouped[key] = [];\n grouped[key].push(ping);\n }\n\n const allTimes = pings.map((p) => p.receivedAt);\n const batchStart = allTimes.sort()[0];\n const batchEnd = new Date().toISOString();\n\n let emailsSent = 0;\n const errors: string[] = [];\n\n const recipients = rallyBossEmail\n .split(\",\")\n .map((e) => e.trim())\n .filter((e) => e.includes(\"@\"));\n\n for (const [waypointName, waypointPings] of Object.entries(grouped)) {\n const subject =\n `[WAYPOINT]

{waypointName} -

{waypointPings.length} team(s) | Batch Report`;\n const html = buildBatchEmailHtml(\n waypointName,\n waypointPings,\n batchStart,\n batchEnd,\n );\n\n const result = await sendMailjetEmail(recipients, subject, html);\n\n if (result.success) {\n emailsSent++;\n } else {\n errors.push(\n `

{waypointName}:

{result.error}`,\n );\n }\n }\n\n if (emailsSent > 0) {\n await savePings([]);\n await blob.setJSON(LAST_BATCH_KEY, { time: batchEnd });\n\n const history = await getHistory();\n history.unshift({\n sentAt: batchEnd,\n waypointCount: Object.keys(grouped).length,\n pingCount: pings.length,\n emailsSent,\n });\n await saveHistory(history);\n }\n\n return jsonResponse({\n success: emailsSent > 0,\n message:\n `Batch complete:

{emailsSent} email(s) sent for

{Object.keys(grouped).length} waypoint(s), ${pings.length} total pings`,\n emailsSent,\n waypointCount: Object.keys(grouped).length,\n pingCount: pings.length,\n errors: errors.length > 0 ? errors : undefined,\n });\n }\n\n if (req.method === \"GET\" && path === \"/status\") {\n const pings = await getPings();\n let lastBatchTime = null;\n try {\n const lastBatch = await blob.getJSON(LAST_BATCH_KEY);\n lastBatchTime = (lastBatch as { time: string })?.time || null;\n } catch {}\n\n const byWaypoint: Record = {};\n for (const ping of pings) {\n byWaypoint[ping.waypointName] = (byWaypoint[ping.waypointName] || 0) + 1;\n }\n\n return jsonResponse({\n pendingPings: pings.length,\n byWaypoint,\n lastBatchSent: lastBatchTime,\n serverTime: new Date().toISOString(),\n });\n }\n\n if (req.method === \"GET\" && path === \"/history\") {\n const history = await getHistory();\n return jsonResponse({ history });\n }\n\n if (req.method === \"POST\" && path === \"/clear\") {\n await savePings([]);\n return jsonResponse({\n success: true,\n message: \"All pending pings cleared\",\n });\n }\n\n return jsonResponse({\n error: \"Unknown endpoint\",\n endpoints: {\n \"POST /ping\": \"Submit a waypoint detection\",\n \"GET /batch\": \"Trigger batch email send\",\n \"GET /status\": \"Show pending pings and last batch time\",\n \"GET /history\": \"Show batch send history\",\n \"POST /clear\": \"Clear all pending pings\",\n },\n }, 404);\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1781784640921],"children",[],[35],"58f488b0-533b-4f2e-b72e-a2517823c994",["D",1781372405754],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","f8a29058-df4c-4b85-8594-e9e33deb5b45","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ead5e-018f-70ef-a409-1483114ff40b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Russ Ambrose","avatar","https://lh3.googleusercontent.com/a/ACg8ocI8_le-MlWLX4XX0K4vh6CF-A6utDumAmpkBz9WWBsqC7N_QQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":151,"_95":152,"_97":153,"_99":53},[147],"files",[147],"counts",{"_136":77,"_137":138,"_139":77,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":135},[35],"pulls","branches",1,"forks",{"_143":145,"_146":77},"connections",{"_143":77,"_144":77},"count","unfilledCount",2,"emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":148,"_18":149},[],[35],["D",1781372405754],{"_11":12,"_115":111},{"_11":12,"_108":109,"_110":111,"_70":71,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_131":187,"_188":189,"_190":191,"_192":53,"_193":53,"_194":53,"_195":44,"_196":-5,"_197":-7,"_198":-7,"_199":77,"_200":53,"_201":53,"_202":-5,"_203":53,"_204":53,"_205":53,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]

Code