\n {children}\n

\n Built in Val Town\n

\n \n \n );\n}\n\nfunction Button({ children }) {\n return (\n \n );\n}\n\nfunction MainPage({ partyName }) {\n return (\n \n

{partyName}

\n 📍 Val Town,{\" \"}\n \n 325 Gold St\n , Unit 503\n

\n \n \n );\n}\n\nfunction ErrorPage({ title, message, backLink = true }) {\n return (\n \n

{title}

{message}

\n {backLink && (\n

\n Back to Buzzer\n

\n )}\n \n );\n}\n\napp.get(\"/\", (c) => {\n const partyName = parties.at(0).name;\n return c.html();\n});\n\napp.post(\"/open-door\", async (c) => {\n const KEY = \"switchbot_party\";\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_buzz_requests_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp TEXT\n )\n `);\n\n const thirtySecondsAgo = Temporal.Now.zonedDateTimeISO(NYC_TIMEZONE).subtract({ seconds: 30 });\n const recentRequests = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${KEY}_buzz_requests_${SCHEMA_VERSION} WHERE timestamp > ?`,\n [thirtySecondsAgo.toString()],\n );\n\n if (recentRequests.rows[0].count > 0) {\n return c.html(\n \n You can only buzz in once every 30 seconds.
\n Please try again in a moment or email steve@val.town if it's urgent.\n \n }\n />,\n );\n }\n\n const partyStatus = getPartyStatus();\n if (!partyStatus.active) {\n email({ subject: \"Door tried to be opened outside party hours!\" });\n const now = Temporal.Now.zonedDateTimeISO(NYC_TIMEZONE);\n let message;\n if (partyStatus.type === \"before\") {\n const timeUntilStart = formatTimeDifference(partyStatus.party.start, now);\n message = `Cannot buzz you in until ${\n partyStatus.party.start.toLocaleString(\"en-US\", { timeZone: NYC_TIMEZONE, timeStyle: \"short\" })\n } ET (in ${timeUntilStart})`;\n } else if (partyStatus.type === \"after\") {\n message = `Sorry, the party ended at ${\n partyStatus.party.end.toLocaleString(\"en-US\", { timeZone: NYC_TIMEZONE, timeStyle: \"short\" })\n } ET`;\n } else {\n message = \"There is no active party at the moment.\";\n }\n return c.html();\n }\n\n try {\n const now = Temporal.Now.zonedDateTimeISO(NYC_TIMEZONE);\n await sqlite.execute(\n `INSERT INTO ${KEY}_buzz_requests_${SCHEMA_VERSION} (timestamp) VALUES (?)`,\n [now.toString()],\n );\n\n await botPress(ValTownGroundFloorDeviceId);\n email({ subject: \"Door opened successfully!\" });\n return c.html(\n \n

🎉 Buzzer Activated! 🎉

You've been buzzed in. Welcome!

\n Please no more than 5 people in the elevator. The stairs work too.\n

\n Back to Buzzer\n

\n ,\n );\n } catch (error) {\n email({ subject: \"Door open fail\" });\n return c.html();\n }\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/switchbot_party/code/main.tsx","extension","actionData","errors"]