JGA Schulden - Berkay

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_169":170,"_171":172},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_128":-5,"_20":129,"_22":130,"_131":132,"_133":134,"_25":135,"_24":-5,"_136":-5,"_137":-5,"_138":54,"_139":140,"_141":45,"_142":-5,"_143":-5,"_144":145},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","berkaytirpan","name","untitled-4636","branchName","main","version","path","","project",{"_34":75,"_13":14,"_46":76,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":-5,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":99,"_100":99,"_101":102,"_103":102,"_104":102,"_105":99,"_106":99,"_107":108,"_109":110,"_111":112,"_113":54},"tree",[66,67],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":62,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_18":65},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_18":57},"id","69b0c1ee-414c-11f1-86f0-42b51c65c3df","new-file-7495.ts","fileId","56e27c06-414c-11f1-916a-42b51c65c3df","parentId","branchId","0e92b838-4149-11f1-8d8d-42b51c65c3df","branchVersion",32,"latest",true,"createdAt",["D",1777193187145],5,"fileType","http","content","export default async function handler(req: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS jga_berkay_v4 (\n id INTEGER PRIMARY KEY,\n data TEXT NOT NULL\n )\n `);\n\n const DEFAULT_PEOPLE = JSON.stringify([\n { id: 1, name: \"Kevin\", paid: false, amount: \"\" },\n { id: 2, name: \"Mikail\", paid: false, amount: \"\" },\n { id: 3, name: \"Alper\", paid: false, amount: \"\" },\n { id: 4, name: \"Emre\", paid: false, amount: \"\" },\n { id: 5, name: \"Kaan\", paid: false, amount: \"\" },\n { id: 6, name: \"Aykut Y\", paid: false, amount: \"\" },\n { id: 7, name: \"Aykut K\", paid: false, amount: \"\" },\n { id: 8, name: \"Muhi\", paid: false, amount: \"\" },\n ]);\n\n const url = new URL(req.url);\n const cors = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n };\n\n if (req.method === \"OPTIONS\") return new Response(null, { headers: cors });\n\n if (url.pathname === \"/api/state\" && req.method === \"GET\") {\n const rows = await sqlite.execute(\n \"SELECT data FROM jga_berkay_v4 WHERE id = 1\",\n );\n const data = rows.rows.length > 0\n ? (rows.rows[0][0] as string)\n : DEFAULT_PEOPLE;\n return new Response(data, {\n headers: { \"Content-Type\": \"application/json\", ...cors },\n });\n }\n\n if (url.pathname === \"/api/state\" && req.method === \"POST\") {\n const body = await req.json();\n if (body.password !== \"berkay2025\") {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n await sqlite.execute(\n `INSERT OR REPLACE INTO jga_berkay_v4 (id, data) VALUES (1, ?)`,\n [JSON.stringify(body.people)],\n );\n return new Response(\"OK\", { headers: cors });\n }\n\n const html = `\n\n\n\n\nJGA Schulden - Berkay\n\n\n\n\n

JGA - BERKAY

SCHULDEN

TRACKER

Gesamt

2.260 EUR

Pro Person

282,50 EUR

Eingenommen

0,00 EUR

Noch offen

2.260,00 EUR

\n FORTSCHRITT\n 0/8 bezahlt\n

\n Verbinde...\n

\n \n \n

\n \n

\n\n

\n \n

\n\n\n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label","123jga",[36],"fbcbc652-414a-11f1-99a6-42b51c65c3df","README.md","f29ae82e-414a-11f1-ac93-42b51c65c3df",13,["D",1777192573283],1,"berkay",[59],{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":72,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_69":73,"_18":74},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_69":70,"_18":71},["D",1777193187145],"children",[],[36],["D",1777192573283],[],[59],"0e91b1ea-4149-11f1-8d8d-42b51c65c3df",["D",1777191745804],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","d7eaf9d8-4dcf-4457-b38f-3a9136c659ae","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019dc8de-8c6a-7699-96e0-5e9dfaefae64","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_127":19},"org",{"_11":12,"_122":-5,"_123":19,"_84":85,"_124":125,"_126":54},"branch",{"_17":43,"_13":16,"_34":41,"_114":75,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":14,"_121":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":75,"_13":14,"_46":165,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":-5,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":99,"_100":99,"_101":102,"_103":102,"_104":102,"_105":99,"_106":99,"_107":166,"_109":167,"_111":168,"_113":54},[159,160],"files",[159,160],"counts",{"_150":91,"_151":63,"_152":91,"_31":153,"_154":155},[146,147],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":62,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_18":149},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_18":148},[36],[59],"pulls","branches","forks",{"_156":91,"_158":91},"connections",{"_156":91,"_157":91},"count","unfilledCount","emptyCount",{"_34":58,"_13":59,"_37":60,"_39":-5,"_40":41,"_42":61,"_44":45,"_46":72,"_17":63,"_49":24,"_51":64,"_53":54,"_55":-5,"_69":163,"_18":164},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":68,"_17":48,"_49":50,"_51":52,"_53":54,"_55":56,"_69":161,"_18":162},[],[36],[],[59],["D",1777191745804],{"_11":12,"_127":19},{"_11":12,"_122":-5,"_123":19,"_84":85,"_124":125,"_126":54},{"_17":43,"_13":16,"_34":41,"_114":75,"_115":-5,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":14,"_121":12},"ctx",{"_107":-5,"_143":202,"_203":204,"_205":206,"_207":54,"_208":54,"_209":54,"_210":45,"_211":-5,"_212":-7,"_213":-7,"_214":91,"_215":54,"_216":54,"_217":-5,"_218":54,"_219":54,"_220":54,"_221":-5},"ENV",{"_173":174,"_175":176,"_177":16,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201},"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"]

Code