⚡ FLO — Washington Heights

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_96":95,"_32":44,"_104":86,"_27":99,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":25,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","d0bcae8a-38db-11f1-a4d6-42b51c65c3df","name","fileType","http","content","// ============================================================\n// FLO Charger Checker — Val.town HTTP Val\n// Washington Heights — 115 Fort Washington Ave\n// SQLite session tracking + 7hr email alerts\n// ============================================================\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst FLO_API = \"https://emobility.servicesflo.com/v3.0\";\nconst ALERT_EMAIL = \"ryan.howard.music@gmail.com\";\nconst ALERT_HOURS = 7;\n\nconst STATIONS = [\n { id: \"d38878b4-0a95-455f-9bdd-eee4233a96d1\", name: \"AUA-10259\" },\n { id: \"0c469a93-ecf8-4935-bb03-6343810793c9\", name: \"AUA-10295\" },\n];\n\n// Setup tables\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS flo_sessions (\n station_id TEXT PRIMARY KEY,\n session_start TEXT,\n last_status TEXT\n )\n`);\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS flo_alerts (\n station_id TEXT PRIMARY KEY,\n alert_sent_at TEXT\n )\n`);\n\nasync function getStationData() {\n const results = await Promise.all(\n STATIONS.map(async (s) => {\n const r = await fetch(`${FLO_API}/parks/station/${s.id}`, {\n headers: {\n Origin: \"https://www.flo.com\",\n Referer: \"https://www.flo.com/\",\n },\n });\n const d = await r.json();\n const st = (d.stations || [])[0] || {};\n const status = st.status || \"Unknown\";\n const lastCheckIn = st.lastCheckIn || null;\n\n // Load existing session record\n const existing = await sqlite.execute(\n `SELECT session_start, last_status FROM flo_sessions WHERE station_id = ?`,\n [s.id],\n );\n const row = existing.rows?.[0];\n const prevStatus = row?.[1] as string | null;\n const sessionStart = row?.[0] as string | null;\n\n let newSessionStart = sessionStart;\n\n if (status === \"InUse\") {\n if (prevStatus !== \"InUse\") {\n // Fresh session — record start time\n newSessionStart = new Date().toISOString();\n await sqlite.execute(\n `INSERT OR REPLACE INTO flo_sessions (station_id, session_start, last_status) VALUES (?, ?, ?)`,\n [s.id, newSessionStart, status],\n );\n // Clear any previous alert so new session can trigger its own\n await sqlite.execute(\n `DELETE FROM flo_alerts WHERE station_id = ?`,\n [s.id],\n );\n } else {\n // Still in use — keep existing session_start\n await sqlite.execute(\n `INSERT OR REPLACE INTO flo_sessions (station_id, session_start, last_status) VALUES (?, ?, ?)`,\n [s.id, sessionStart, status],\n );\n }\n\n // Check if session has exceeded 7 hours and we haven't alerted yet\n if (newSessionStart) {\n const sessionMs = Date.now() - new Date(newSessionStart).getTime();\n const sessionHours = sessionMs / (1000 * 60 * 60);\n\n if (sessionHours >= ALERT_HOURS) {\n const alertRecord = await sqlite.execute(\n `SELECT alert_sent_at FROM flo_alerts WHERE station_id = ?`,\n [s.id],\n );\n const alreadySent = alertRecord.rows?.[0];\n\n if (!alreadySent) {\n // Send email alert\n const hrs = Math.floor(sessionHours);\n const mins = Math.floor((sessionHours % 1) * 60);\n await email({\n to: ALERT_EMAIL,\n subject: `⚡ FLO Alert — ${s.name} in use for ${hrs}h ${mins}m`,\n text:\n `Charger ${s.name} at 115 Fort Washington Ave has been in use for ${hrs} hours and ${mins} minutes.\\n\\nSession started: ${\n new Date(newSessionStart).toLocaleString(\"en-US\", {\n timeZone: \"America/New_York\",\n })\n }\\n\\nCheck status: https://your-val-url.web.val.run`,\n html:\n `

Charger ${s.name} at 115 Fort Washington Ave has been in use for ${hrs}h ${mins}m.

Session started: ${\n new Date(newSessionStart).toLocaleString(\"en-US\", {\n timeZone: \"America/New_York\",\n })\n }

`,\n });\n // Record that alert was sent\n await sqlite.execute(\n `INSERT OR REPLACE INTO flo_alerts (station_id, alert_sent_at) VALUES (?, ?)`,\n [s.id, new Date().toISOString()],\n );\n }\n }\n }\n } else {\n // No longer in use — clear session and alert\n newSessionStart = null;\n await sqlite.execute(\n `INSERT OR REPLACE INTO flo_sessions (station_id, session_start, last_status) VALUES (?, ?, ?)`,\n [s.id, null, status],\n );\n await sqlite.execute(\n `DELETE FROM flo_alerts WHERE station_id = ?`,\n [s.id],\n );\n }\n\n return {\n id: s.id,\n name: s.name,\n status,\n lastCheckIn,\n sessionStart: newSessionStart,\n };\n }),\n );\n return results;\n}\n\nconst HTML = `\n\n\n\n\n⚡ FLO — Washington Heights\n\n\n\n\n

\n \n

\n ⚡\n

Checking chargers...

\n\n\n`;\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname === \"/api/stations\") {\n try {\n const data = await getStationData();\n return new Response(JSON.stringify(data), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Cache-Control\": \"no-store\",\n },\n });\n } catch (e: any) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n return new Response(HTML, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","createdAt",["D",1776277045624],"branchVersion","branchId","d0b3b0dc-38db-11f1-a4d6-42b51c65c3df","id","d0b2b218-38db-11f1-a4d6-42b51c65c3df","floUI",["D",1776265217555],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","37f688ba-0714-4ed2-aa7f-f2b2d9955904","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d91a6-1ac4-772a-b440-6d84c49b2ad2","tursoName","d0b2b21838db11f1a4d642b51c65c3df","tursoHostname","d0b2b21838db11f1a4d642b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509672838],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":25},"branch",{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ryanhowardmusic","handle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":151,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":25,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":152,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":153,"_80":154,"_82":155,"_84":25},"tree",[146],"files",[146],"counts",{"_135":59,"_136":137,"_138":59,"_139":140,"_141":142},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":127,"_32":28,"_30":31,"_128":-5,"_40":41,"_39":14,"_129":25,"_37":130,"_13":131,"_33":34,"_35":36,"_24":25,"_132":133,"_27":134},"5ac8f67c-38f7-11f1-be1a-42b51c65c3df","parentId","latest",["D",1776277045624],10,"label","washingtonheightsflo",[28],"pulls","branches",1,"forks","envVars",{"_143":59,"_145":59},"connections",{"_143":59,"_144":59},"count","unfilledCount","emptyCount",{"_42":127,"_32":28,"_30":31,"_128":-5,"_40":41,"_39":14,"_129":25,"_37":147,"_13":131,"_33":34,"_35":36,"_24":25,"_132":133,"_148":149,"_27":150},["D",1776277045624],"children",[],[28],["D",1776265217555],["D",1789509672838],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":25},{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":189,"_190":191,"_192":193,"_194":25,"_195":25,"_196":25,"_197":121,"_198":-5,"_199":-7,"_200":-7,"_201":59,"_202":25,"_203":25,"_204":-5,"_205":25,"_206":25,"_207":25,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":86,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Diff · v11