[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":100,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":25,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","flo-cron.ts","latestPath","fileId","ed6b77fe-38f5-11f1-b293-42b51c65c3df","name","fileType","interval","content","// ============================================================\n// FLO Background Checker — Val.town Cron Val\n// Create this as a SEPARATE val on val.town (type: Cron)\n// Set the schedule to: */30 * * * * (every 30 minutes)\n// ============================================================\n\nimport { sqlite } from \"https://esm.town/v/std/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\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`);\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS flo_session_history (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n station_id TEXT,\n station_name TEXT,\n session_start TEXT,\n session_end TEXT,\n duration_minutes INTEGER\n )\n`);\n// Trim history older than 90 days\nawait sqlite.execute(`\n DELETE FROM flo_session_history\n WHERE session_end < datetime('now', '-90 days')\n`);\n\nexport default async function () {\n console.log(\"FLO background check running at\", new Date().toISOString());\n\n await Promise.all(\n STATIONS.map(async (s) => {\n try {\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\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\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 await sqlite.execute(\n `DELETE FROM flo_alerts WHERE station_id = ?`,\n [s.id],\n );\n console.log(`${s.name} session started at ${newSessionStart}`);\n } else {\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 7hr alert\n if (newSessionStart) {\n const sessionHours =\n (Date.now() - new Date(newSessionStart).getTime()) /\n (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 const hrs = Math.floor(sessionHours);\n const mins = Math.floor((sessionHours % 1) * 60);\n const startedAt = new Date(newSessionStart).toLocaleString(\n \"en-US\",\n {\n timeZone: \"America/New_York\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n month: \"short\",\n day: \"numeric\",\n },\n );\n\n await email({\n to: ALERT_EMAIL,\n subject:\n `⚡ 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: ${startedAt} (ET)\\n\\nThis alert was triggered automatically by the background checker.`,\n html: `\n

⚡ FLO Charger Alert

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

\n \n \n \n \n

Station	${s.name}
Session started	${startedAt} ET
Duration	${hrs}h ${mins}m

Sent automatically every 30 minutes by FLO Checker.

\n `,\n });\n\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 console.log(`Alert sent for ${s.name} after ${hrs}h ${mins}m`);\n }\n }\n }\n } else {\n // Available — clear session\n // If it was InUse, log the completed session to history\n if (prevStatus === \"InUse\" && sessionStart) {\n const sessionEnd = new Date().toISOString();\n const durationMinutes = Math.round(\n (new Date(sessionEnd).getTime() -\n new Date(sessionStart).getTime()) / (1000 * 60),\n );\n await sqlite.execute(\n `INSERT INTO flo_session_history (station_id, station_name, session_start, session_end, duration_minutes) VALUES (?, ?, ?, ?, ?)`,\n [s.id, s.name, sessionStart, sessionEnd, durationMinutes],\n );\n console.log(\n `${s.name} session ended. Duration: ${durationMinutes} minutes`,\n );\n }\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 } catch (e) {\n console.error(`Error checking ${s.name}:`, e);\n }\n }),\n );\n\n console.log(\"FLO background check complete\");\n}","// ============================================================\n// FLO Background Checker — Val.town Cron Val\n// Runs every 15 minutes to keep blob state in sync\n// ============================================================\n\nimport { blob } from \"https://esm.town/v/std/blob\";\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\nexport default async function () {\n console.log(\"FLO background check running at\", new Date().toISOString());\n\n // Load shared blob state (same key as HTTP val)\n let state: Record = {};\n try {\n const stored = await blob.getJSON(\"flo_status\");\n if (stored) state = stored as any;\n } catch { /* no state yet */ }\n\n await Promise.all(\n STATIONS.map(async (s) => {\n try {\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\n const prev = state[s.id];\n const prevStatus = prev?.last_status || null;\n const rawChangedAt = prev?.status_changed_at || null;\n const changedAtAge = rawChangedAt\n ? Date.now() - new Date(rawChangedAt).getTime()\n : Infinity;\n let statusChangedAt = changedAtAge < 30 * 24 * 60 * 60 * 1000\n ? rawChangedAt\n : null;\n let alertSent = prev?.alert_sent || false;\n\n if (status !== prevStatus) {\n // Status changed — record new time, reset alert\n statusChangedAt = new Date().toISOString();\n alertSent = false;\n console.log(\n `${s.name}: ${prevStatus} → ${status} at ${statusChangedAt}`,\n );\n }\n\n // Check 7hr alert for InUse sessions\n if (status === \"InUse\" && statusChangedAt && !alertSent) {\n const sessionHours =\n (Date.now() - new Date(statusChangedAt).getTime()) /\n (1000 * 60 * 60);\n if (sessionHours >= ALERT_HOURS) {\n const hrs = Math.floor(sessionHours);\n const mins = Math.floor((sessionHours % 1) * 60);\n const startedAt = new Date(statusChangedAt).toLocaleString(\n \"en-US\",\n {\n timeZone: \"America/New_York\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n month: \"short\",\n day: \"numeric\",\n },\n );\n\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: ${startedAt} (ET)`,\n html: `\n

⚡ FLO Charger Alert

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

\n \n \n \n \n

Station	${s.name}
In use since	${startedAt} ET
Duration	${hrs}h ${mins}m

Checked automatically every 15 minutes by FLO Checker.

\n `,\n });\n\n alertSent = true;\n console.log(`Alert sent for ${s.name} after ${hrs}h ${mins}m`);\n }\n }\n\n // Update state\n state[s.id] = {\n last_status: status,\n status_changed_at: statusChangedAt || new Date().toISOString(),\n alert_sent: alertSent,\n };\n } catch (e) {\n console.error(`Error checking ${s.name}:`, e);\n }\n }),\n );\n\n // Save updated state back to blob (shared with HTTP val)\n await blob.setJSON(\"flo_status\", state);\n console.log(\"FLO background check complete\");\n}","createdAt",["D",1778527505185],"branchVersion","branchId","ed61b2d2-38f5-11f1-b293-42b51c65c3df","id","ed600252-38f5-11f1-b293-42b51c65c3df","flo-cron-emailserver",["D",1776276432582],"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","ed60025238f511f1b29342b51c65c3df","tursoHostname","ed60025238f511f1b29342b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509672838],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",11,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ryanhowardmusic","handle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":151,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":152,"_81":153,"_83":154,"_85":25},"tree",[145],"files",[145],"counts",{"_134":60,"_135":136,"_137":60,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"1d36cc80-4d6f-11f1-8235-ee650bb23af1","parentId","latest",["D",1778527505185],9,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":60,"_144":60},"connections",{"_142":60,"_143":60},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1778527505185],"children",[],[28],["D",1776276432582],["D",1789509672838],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_123":188,"_189":190,"_191":192,"_193":25,"_194":25,"_195":25,"_196":197,"_198":-5,"_199":-7,"_200":-7,"_201":60,"_202":25,"_203":25,"_204":-5,"_205":25,"_206":25,"_207":25,"_208":-5},"ENV",{"_159":160,"_161":162,"_163":87,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v10