JGA Schulden - Berkay

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_95":94,"_33":46,"_103":85,"_28":98,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":27,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":27},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","main.ts","latestPath","fileId","0e967c70-4149-11f1-8d8d-42b51c65c3df","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","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_v3 (\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_v3 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_v3 (id, data) VALUES (1, ?)`,\n [JSON.stringify(body.people)],\n );\n return new Response(\"OK\", { headers: cors });\n }\n\n return new Response(\n `\n\n\n\n\nJGA Schulden - Berkay\n\n\n\n\n

JGA - BERKAY

SCHULDEN

TRACKER

Gesamt

2.270 EUR

Pro Person

283,75 EUR

Eingenommen

0,00 EUR

Noch offen

2.270,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 { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n}","createdAt",["D",1777192426554],"branchVersion","branchId","0e92b838-4149-11f1-8d8d-42b51c65c3df","id","0e91b1ea-4149-11f1-8d8d-42b51c65c3df","untitled-4636",["D",1777191745804],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":27},"branch",{"_13":84,"_33":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"isOwned",32,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","berkaytirpan","handle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_33":46,"_39":148,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":149,"_79":150,"_81":151,"_83":27},"tree",[143],"files",[143],"counts",{"_132":61,"_133":134,"_135":61,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":125,"_33":29,"_31":32,"_126":-5,"_42":43,"_41":14,"_127":27,"_39":128,"_13":129,"_34":35,"_36":38,"_24":27,"_130":-5,"_28":131},"a45f0c8a-414a-11f1-a0c4-42b51c65c3df","parentId","latest",["D",1777192426554],3,"label",[29],"pulls","branches",1,"forks","envVars",{"_140":61,"_142":61},"connections",{"_140":61,"_141":61},"count","unfilledCount","emptyCount",{"_44":125,"_33":29,"_31":32,"_126":-5,"_42":43,"_41":14,"_127":27,"_39":144,"_13":129,"_34":35,"_36":38,"_24":27,"_130":-5,"_145":146,"_28":147},["D",1777192426554],"children",[],[29],["D",1777191745804],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":27},{"_13":84,"_33":85,"_44":43,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":46,"_93":94},"ctx",{"_77":-5,"_121":185,"_186":187,"_188":189,"_190":27,"_191":27,"_192":27,"_193":25,"_194":-5,"_195":-7,"_196":-7,"_197":61,"_198":27,"_199":27,"_200":-5,"_201":27,"_202":27,"_203":27,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":85,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"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 · v11