⚡ 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}","deleted","label",[105],"permalink","https://www.val.town/x/ryanhowardmusic/flo-cron-emailserver/code/flo-cron.ts","extension","actionData","errors"]