JGA Schulden - Berkay

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_182":183,"_184":185},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_64":144,"_16":-7,"_149":-5,"_17":150,"_151":152,"_29":153,"_21":154,"_23":155,"_72":-5,"_156":-5,"_157":-5,"_158":35,"_159":160,"_161":38,"_162":-5,"_163":-5,"_164":165},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":-5,"_28":-5,"_29":30,"_31":-5,"_32":-5,"_33":-5,"_34":35,"_36":35,"_37":38},"handle","berkaytirpan","name","untitled-4636","branchName","version","project",{"_41":95,"_13":14,"_52":96,"_97":-5,"_98":35,"_99":100,"_101":100,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":35,"_108":-5,"_109":-5,"_110":85,"_111":112,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":127,"_128":129,"_130":131,"_132":35},"tags",[],"counts",{"_84":85,"_86":71,"_87":85,"_88":89,"_90":91},"contents",[78,79],"readme",{"_41":66,"_13":67,"_44":68,"_46":-5,"_47":48,"_49":69,"_51":38,"_52":76,"_16":71,"_55":72,"_57":73,"_59":35,"_60":-5,"_64":77},"upstream","pull","files",[39,40],"preview","ahead","behind","showHomeCustomizationHint",false,"showHTTPPreviewSettingsHint","hasHTTPFiles",true,{"_41":66,"_13":67,"_44":68,"_46":-5,"_47":48,"_49":69,"_51":38,"_52":70,"_16":71,"_55":72,"_57":73,"_59":35,"_60":-5,"_62":74,"_64":75},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":38,"_52":53,"_16":54,"_55":56,"_57":58,"_59":35,"_60":61,"_62":63,"_64":65},"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","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","label","123jga","children",[],"path",[43],"fbcbc652-414a-11f1-99a6-42b51c65c3df","README.md","f29ae82e-414a-11f1-ac93-42b51c65c3df",13,["D",1777192573283],1,"file","berkay",[],[67],["D",1777192573283],[67],{"_41":66,"_13":67,"_44":68,"_46":-5,"_47":48,"_49":69,"_51":38,"_52":82,"_16":71,"_55":72,"_57":73,"_59":35,"_60":-5,"_64":83},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":38,"_52":80,"_16":54,"_55":56,"_57":58,"_59":35,"_60":61,"_64":81},["D",1777193187145],[43],["D",1777192573283],[67],"pulls",0,"branches","forks","envVars",{"_92":85,"_94":85},"connections",{"_92":85,"_93":85},"count","unfilledCount","emptyCount","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","orgId","019dc8de-8c6a-7699-96e0-5e9dfaefae64","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_148":144},"org",{"_11":12,"_142":-5,"_143":144,"_104":105,"_145":146,"_147":35},"branch",{"_16":50,"_13":133,"_41":48,"_134":95,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":14,"_141":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_41":95,"_13":14,"_52":178,"_97":-5,"_98":35,"_99":100,"_101":100,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":35,"_108":-5,"_109":-5,"_110":85,"_111":112,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":179,"_128":180,"_130":181,"_132":35},"tree",[172,173],[172,173],{"_84":85,"_86":71,"_87":85,"_88":170,"_90":171},[166,167],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":66,"_13":67,"_44":68,"_46":-5,"_47":48,"_49":69,"_51":38,"_52":82,"_16":71,"_55":72,"_57":73,"_59":35,"_60":-5,"_64":169},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":38,"_52":80,"_16":54,"_55":56,"_57":58,"_59":35,"_60":61,"_64":168},[43],[67],{"_92":85,"_94":85},{"_92":85,"_93":85},{"_41":66,"_13":67,"_44":68,"_46":-5,"_47":48,"_49":69,"_51":38,"_52":70,"_16":71,"_55":72,"_57":73,"_59":35,"_60":-5,"_62":176,"_64":177},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":38,"_52":53,"_16":54,"_55":56,"_57":58,"_59":35,"_60":61,"_62":174,"_64":175},[],[43],[],[67],["D",1777191745804],{"_11":12,"_148":144},{"_11":12,"_142":-5,"_143":144,"_104":105,"_145":146,"_147":35},{"_16":50,"_13":133,"_41":48,"_134":95,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":14,"_141":12},"ctx",{"_126":-5,"_163":215,"_216":217,"_218":219,"_220":35,"_221":35,"_222":35,"_223":38,"_224":-5,"_225":-7,"_226":-7,"_227":85,"_228":35,"_229":35,"_230":-5,"_231":35,"_232":35,"_233":35,"_234":-5},"ENV",{"_186":187,"_188":189,"_190":133,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214},"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"]