Disney Schedule Override Manager

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_159":160,"_161":162},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":102,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":59,"_125":-5,"_126":-5,"_127":128},"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":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",25,"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","main.ts","latestPath","fileId","54988284-a09b-11f1-84c9-1607ee4eb77e","name","fileType","http","content","import {\n getDbClient,\n initTursoSchema,\n} from \"https://esm.town/v/amullinfit/tursoClient/\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n let statusMessage = \"\";\n let statusType = \"\";\n\n try {\n // Ensure table exists in Turso on incoming request\n await initTursoSchema();\n const db = getDbClient();\n\n // -------------------------------------------------------------------------\n // 1. HANDLE FORM SUBMISSIONS (ADD / DELETE) DIRECTLY VIA TURSO\n // -------------------------------------------------------------------------\n if (req.method === \"POST\") {\n const action = url.searchParams.get(\"action\");\n\n if (action === \"add\") {\n const formData = await req.formData();\n const date = String(formData.get(\"date\") || \"\").trim();\n const park_key = String(formData.get(\"park_key\") || \"\").trim();\n const type = String(formData.get(\"type\") || \"SPECIAL_EVENT\").trim();\n const description = String(formData.get(\"description\") || \"\").trim();\n const openTimeVal = String(formData.get(\"opening_time\") || \"\").trim();\n const closeTimeVal = String(formData.get(\"closing_time\") || \"\").trim();\n\n if (\n !date || !park_key || !description || !openTimeVal || !closeTimeVal\n ) {\n return Response.redirect(\n `${url.origin}?err=${\n encodeURIComponent(\"Missing required form fields\")\n }`,\n 303,\n );\n }\n\n const opening_time = `${date}T${openTimeVal}:00-04:00`;\n const closing_time = `${date}T${closeTimeVal}:00-04:00`;\n\n await db.execute(\n `INSERT INTO park_schedule_overrides (date, park_key, type, description, opening_time, closing_time)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n date,\n park_key.toLowerCase(),\n type,\n description,\n opening_time,\n closing_time,\n ],\n );\n\n return Response.redirect(`${url.origin}?msg=added`, 303);\n }\n\n if (action === \"delete\") {\n const formData = await req.formData();\n const id = formData.get(\"id\");\n\n if (!id) {\n return Response.redirect(\n `${url.origin}?err=${encodeURIComponent(\"Missing record ID\")}`,\n 303,\n );\n }\n\n await db.execute(\n \"DELETE FROM park_schedule_overrides WHERE id = ?\",\n [Number(id)],\n );\n\n return Response.redirect(`${url.origin}?msg=deleted`, 303);\n }\n }\n\n // -------------------------------------------------------------------------\n // 2. QUERY LATEST OVERRIDES FROM TURSO\n // -------------------------------------------------------------------------\n const result = await db.execute(\n \"SELECT id, date, park_key, type, description, opening_time, closing_time FROM park_schedule_overrides ORDER BY date ASC\",\n );\n\n const overrides = result.rows.map((row: any) => ({\n id: row.id,\n date: row.date,\n park_key: row.park_key,\n type: row.type,\n description: row.description,\n opening_time: row.opening_time,\n closing_time: row.closing_time,\n }));\n\n // -------------------------------------------------------------------------\n // 3. UI STATUS BANNERS\n // -------------------------------------------------------------------------\n const msgParam = url.searchParams.get(\"msg\");\n const errParam = url.searchParams.get(\"err\");\n\n if (msgParam === \"added\") {\n statusMessage = \"✓ Override successfully saved to Turso!\";\n statusType = \"success\";\n } else if (msgParam === \"deleted\") {\n statusMessage = \"✓ Override successfully deleted from Turso!\";\n statusType = \"success\";\n } else if (errParam) {\n statusMessage = `⚠ Error: ${errParam}`;\n statusType = \"error\";\n }\n\n // -------------------------------------------------------------------------\n // 4. RENDER HTML INTERFACE\n // -------------------------------------------------------------------------\n const html = `\n\n\n \n \n Disney Schedule Override Manager\n \n\n\n

\n \n\n ${\n statusMessage\n ? `

${statusMessage}

`\n : \"\"\n }\n\n

Add New Override

\n \n\n

Active Database Overrides (${overrides.length})

\n \n \n \n \n \n \n \n \n \n \n \n ${\n overrides.length === 0\n ? ''\n : overrides.map((row: any) => `\n \n \n \n \n \n \n \n `).join(\"\")\n }\n \n

Date	Park	Type	Description	Action
No overrides stored in database.
${row.date}	${row.park_key}	`${row.type}`	${row.description}	\n \n \n \n \n

\n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n } catch (error) {\n const message = error instanceof Error ? error.message : String(error);\n return new Response(`

⚠️ Admin Error

${message}

`, {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n}","import {\n getDbClient,\n initTursoSchema,\n} from \"https://esm.town/v/amullinfit/tursoClient\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n let statusMessage = \"\";\n let statusType = \"\";\n\n try {\n // Ensure table exists in Turso on incoming request\n await initTursoSchema();\n const db = getDbClient();\n\n // -------------------------------------------------------------------------\n // 1. HANDLE FORM SUBMISSIONS (ADD / DELETE) DIRECTLY VIA TURSO\n // -------------------------------------------------------------------------\n if (req.method === \"POST\") {\n const action = url.searchParams.get(\"action\");\n\n if (action === \"add\") {\n const formData = await req.formData();\n const date = String(formData.get(\"date\") || \"\").trim();\n const park_key = String(formData.get(\"park_key\") || \"\").trim();\n const type = String(formData.get(\"type\") || \"SPECIAL_EVENT\").trim();\n const description = String(formData.get(\"description\") || \"\").trim();\n const openTimeVal = String(formData.get(\"opening_time\") || \"\").trim();\n const closeTimeVal = String(formData.get(\"closing_time\") || \"\").trim();\n\n if (\n !date || !park_key || !description || !openTimeVal || !closeTimeVal\n ) {\n return Response.redirect(\n `${url.origin}?err=${\n encodeURIComponent(\"Missing required form fields\")\n }`,\n 303,\n );\n }\n\n const opening_time = `${date}T${openTimeVal}:00-04:00`;\n const closing_time = `${date}T${closeTimeVal}:00-04:00`;\n\n await db.execute(\n `INSERT INTO park_schedule_overrides (date, park_key, type, description, opening_time, closing_time)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n date,\n park_key.toLowerCase(),\n type,\n description,\n opening_time,\n closing_time,\n ],\n );\n\n return Response.redirect(`${url.origin}?msg=added`, 303);\n }\n\n if (action === \"delete\") {\n const formData = await req.formData();\n const id = formData.get(\"id\");\n\n if (!id) {\n return Response.redirect(\n `${url.origin}?err=${encodeURIComponent(\"Missing record ID\")}`,\n 303,\n );\n }\n\n await db.execute(\n \"DELETE FROM park_schedule_overrides WHERE id = ?\",\n [Number(id)],\n );\n\n return Response.redirect(`${url.origin}?msg=deleted`, 303);\n }\n }\n\n // -------------------------------------------------------------------------\n // 2. QUERY LATEST OVERRIDES FROM TURSO\n // -------------------------------------------------------------------------\n const result = await db.execute(\n \"SELECT id, date, park_key, type, description, opening_time, closing_time FROM park_schedule_overrides ORDER BY date ASC\",\n );\n\n const overrides = result.rows.map((row: any) => ({\n id: row.id,\n date: row.date,\n park_key: row.park_key,\n type: row.type,\n description: row.description,\n opening_time: row.opening_time,\n closing_time: row.closing_time,\n }));\n\n // -------------------------------------------------------------------------\n // 3. UI STATUS BANNERS\n // -------------------------------------------------------------------------\n const msgParam = url.searchParams.get(\"msg\");\n const errParam = url.searchParams.get(\"err\");\n\n if (msgParam === \"added\") {\n statusMessage = \"✓ Override successfully saved to Turso!\";\n statusType = \"success\";\n } else if (msgParam === \"deleted\") {\n statusMessage = \"✓ Override successfully deleted from Turso!\";\n statusType = \"success\";\n } else if (errParam) {\n statusMessage = `⚠ Error: ${errParam}`;\n statusType = \"error\";\n }\n\n // -------------------------------------------------------------------------\n // 4. RENDER HTML INTERFACE\n // -------------------------------------------------------------------------\n const html = `\n\n\n \n \n Disney Schedule Override Manager\n \n\n\n

\n \n\n ${\n statusMessage\n ? `

${statusMessage}

`\n : \"\"\n }\n\n

Add New Override

\n \n\n

Active Database Overrides (${overrides.length})

\n \n \n \n \n \n \n \n \n \n \n \n ${\n overrides.length === 0\n ? ''\n : overrides.map((row: any) => `\n \n \n \n \n \n \n \n `).join(\"\")\n }\n \n

Date	Park	Type	Description	Action
No overrides stored in database.
${row.date}	${row.park_key}	`${row.type}`	${row.description}	\n \n \n \n \n

⚠️ Admin Error

${message}

`, {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n}","createdAt",["D",1787678889484],"branchVersion","branchId","b3cfcb5f-8170-4dab-b11d-5d0a20265078","id","61be9af0-b34a-4ff2-b1a3-cbd1db4000a6","disney-schedule-admin",["D",1787672442437],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Admin screen to add special events to the Disney calendar","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/d7484393-d73b-4be9-879e-0800d5fedc01/square512?exp=1789549199&sig=a290abd35e4bca776da07c294d4d9315095ccea395387d3c16afa49177dff507","220866a3-597a-4bec-a556-1a2c85dfb54e","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f6b11-94c8-70c3-89b7-689b544f6677","tursoName","61be9af0b34a4ff2b1a3cbd1db4000a6","tursoHostname","61be9af0b34a4ff2b1a3cbd1db4000a6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":102},"org",{"_100":99,"_101":102,"_103":102,"_18":56,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","amullinfit","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":154,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":155,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":156,"_84":157,"_86":158,"_88":25},"tree",[149],"files",[149],"counts",{"_137":63,"_138":139,"_140":63,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"ef058d7b-c5e6-4e98-9c8e-d81979e5e6cc","parentId","latest",["D",1787678889484],24,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":147,"_148":63},"connections",{"_145":63,"_146":63},"count","unfilledCount",3,"emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":150,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_151":152,"_27":153},["D",1787678889484],"children",[],[28],["D",1787672442437],["D",1789497078049],{"_100":99,"_107":102},{"_100":99,"_101":102,"_103":102,"_18":56,"_104":105,"_106":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_126":192,"_193":194,"_195":196,"_197":25,"_198":25,"_199":25,"_200":59,"_201":-5,"_202":-7,"_203":-7,"_204":63,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":90,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"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"]

Diff · v25