[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_202":203,"_204":205},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",18,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","082cc553-2880-446c-892f-e390eb87c15c","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":26,"_40":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":26,"_40":41},"deleted",false,"deletedHere","path","app.html","latestPath","fileId","201c958a-a259-11f1-9aae-1607ee4eb77e","name","fileType","content","\n\n\n\n\nThe Company – Kassenbuch\n\n\n\n

THE COMPANYKASSENBUCH · BELEGE

\n \n \n \n \n \n

\n\n

GESAMTUMSATZ

BELEGE

PAYOUT GRÜN

MULES VERKAUFT

\n\n

\n \n

Neuer Beleg

\n \n

\n\n \n

Belege

\n \n \n

Lade Belege…

\n \n \n

\n\n

\n\n\n\n\n","\n\n\n\n\nThe Company – Kassenbuch\n\n\n\n

THE COMPANYKASSENBUCH · BELEGE

\n \n \n \n \n

\n\n

GESAMTUMSATZ

BELEGE

PAYOUT GRÜN

MULES VERKAUFT

\n\n

\n \n

Neuer Beleg

\n \n

\n\n \n

Belege

\n \n \n

Lade Belege…

\n \n \n

\n\n

\n\n\n\n\n","createdAt",["D",1787864497292],"branchVersion","branchId","a68323b6-beb6-4c5d-8ce7-5d71a3a48dbc","id","c57dfe8f-8b1d-433c-b9a0-e7c4be00e073","company-system",["D",1787863752548],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","The Company Ankauf-Belege App mit Login, SQLite und Admin","imageUrl","e937950a-823f-4c01-b6cf-6491c1ee84ae","pinnedFileId","c959b444-a258-11f1-875a-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a044f9-9b41-7654-87d6-d1b3627f9347","tursoName","c57dfe8f8b1d433cb9a0e7c4be00e073","tursoHostname","c57dfe8f8b1d433cb9a0e7c4be00e073-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","juckendeeier","handle","displayName","Roman Hofmann","avatar","https://lh3.googleusercontent.com/a/ACg8ocL64ok-tOKSx6YTOehvyw-in7GidqLu1v8jjDOnRbxyL-DazK4=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":197,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":198,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":199,"_89":200,"_91":201,"_93":31},"tree",[180,181,182,183],"files",[180,181,182,183],"counts",{"_169":68,"_170":171,"_172":68,"_173":174,"_175":176},"contents",[136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":162,"_38":163,"_36":164,"_142":-5,"_46":47,"_45":165,"_144":31,"_43":166,"_13":68,"_39":26,"_40":167,"_30":31,"_149":-5,"_33":168},{"_48":159,"_38":34,"_36":37,"_142":-5,"_46":47,"_45":14,"_144":31,"_43":160,"_13":146,"_39":26,"_40":42,"_30":31,"_149":-5,"_33":161},{"_48":152,"_38":153,"_36":154,"_142":-5,"_46":47,"_45":155,"_144":64,"_43":156,"_13":68,"_39":26,"_40":157,"_30":31,"_149":-5,"_33":158},{"_48":140,"_38":141,"_36":62,"_142":-5,"_46":47,"_45":143,"_144":31,"_43":145,"_13":146,"_39":147,"_40":148,"_30":31,"_149":150,"_33":151},"cc037d3d-da05-4275-a836-e717f5c1f3e5","main.ts","parentId",14,"latest",["D",1787864273709],7,"http","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createHash } from \"node:crypto\";\n\n// ---------- Datenbank ----------\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS receipts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT, served TEXT, seller TEXT, phone TEXT,\n mules INTEGER, price INTEGER, total INTEGER, payment TEXT, note TEXT\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS config (\n key TEXT PRIMARY KEY, value TEXT\n)`);\n\n// ---------- Login ----------\n// Passwort aus Umgebungsvariable APP_PASSWORD, sonst Standard-Passwort.\nconst PASSWORD = Deno.env.get(\"APP_PASSWORD\") || \"gta\";\nconst SESSION = createHash(\"sha256\").update(\"company:\" + PASSWORD).digest(\"hex\");\nconst SESSION_COOKIE = `company_session=${SESSION}; Path=/; HttpOnly; SameSite=Lax; Max-Age=86400`;\n\nfunction authed(req: Request): boolean {\n return (req.headers.get(\"cookie\") || \"\").includes(\"company_session=\" + SESSION);\n}\n\n// ---------- Standard-Konfiguration (Admin) ----------\nconst DEFAULTS: Record = {\n buy: \"60000\", mules: \"1\", ironMule: \"800\", ratio: \"5\",\n g2b: \"0.70\", b2g: \"1.428571\", green: \"100000\", black: \"70000\",\n cap: \"3000\", hours: \"7\", npc: \"600\", dealer: \"650\", sell: \"600\",\n staff: \"25\", company: \"60\",\n};\n\n// ---------- Hilfsfunktionen ----------\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n\nfunction html(body: string): Response {\n return new Response(body, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}\n\nasync function getConfig(): Promise> {\n const res = await sqlite.execute(\"SELECT key, value FROM config\");\n const cfg = { ...DEFAULTS };\n for (const r of res.rows) cfg[r.key as string] = String(r.value ?? \"\");\n return cfg;\n}\n\nasync function allReceipts(): Promise[]> {\n const res = await sqlite.execute(\"SELECT * FROM receipts ORDER BY id DESC\");\n return res.rows as Record[];\n}\n\n// ---------- PDF-Export ----------\n// Erzeugt ein PDF mit den Standard-Schriften (Helvetica, WinAnsi → Umlaute ok).\nfunction pdfEsc(s: unknown): string {\n return String(s ?? \"\")\n .replace(/\\\\/g, \"\\\\\\\\\")\n .replace(/\$/g, \"\\\\(\")\n .replace(/\$/g, \"\\\\)\");\n}\n\nfunction pdfEscapeText(s: unknown): string {\n // WinAnsi-Encoding: Umlaute direkt als UTF-8-Bytes in die Zeichenketten schreiben\n // und als Hex-String kodieren, damit Umlaute korrekt erscheinen.\n const text = String(s ?? \"\");\n return \"<\" + Array.from(new TextEncoder().encode(text))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\") + \">\";\n}\n\nfunction buildPdf(rows: Record[]): Uint8Array {\n const cols = [60, 40, 40, 26, 32, 36, 30, 80]; // Breiten in pt\n const headers = [\"Datum\", \"Bedient\", \"Ankauf\", \"Mules\", \"Preis\", \"Gesamt\", \"Zahlung\", \"Notiz\"];\n const pageWidth = 595; // A4 quer? nein, hoch (595x842)\n const margin = 40;\n const tableWidth = cols.reduce((a, b) => a + b, 0);\n const lineHeight = 16;\n const headerH = 22;\n let y = 120;\n let sum = 0;\n\n const objs: string[] = []; // PDF-Objekte als Strings\n // Wir bauen das PDF ganz simpel mit einem einzigen Content-Stream pro Seite.\n\n // Einfacher Ansatz: ein Content-Stream über alle Seiten via Seitenwechsel.\n // Hier: generiere Content-Streams pro Seite.\n const pages: string[][] = [];\n let cur = new Array();\n pages.push(cur);\n\n const addLine = (txt: string, x: number, yy: number, size: number, bold = false, w = 0) => {\n if (yy > 800) {\n cur = new Array();\n pages.push(cur);\n yy = 60;\n }\n let cmd = \"BT /F\" + (bold ? \"2\" : \"1\") + \" \" + size + \" Tf \" +\n x + \" \" + yy + \" Td \" + w + \" TL \" + txt + \" Tj ET\";\n if (w > 0) cmd += \" BT \" + \"0\\n\" + \"0\\n\" + \"TD \" + w + \" TL ET\"; // mehrzeilig im nächsten Schritt\n cur.push(cmd);\n return yy;\n };\n\n // Kopfzeile\n cur.push(\"BT /F2 18 Tf 40 810 Td (THE COMPANY) Tj ET\");\n cur.push(\"BT /F1 10 Tf 40 794 Td (Kassenbuch - Belege) Tj ET\");\n cur.push(\"BT /F1 10 Tf 40 778 Td (Exportiert am \" +\n new Date().toLocaleString(\"de-DE\") + \") Tj ET\");\n y = 740;\n\n // Tabellenkopf\n let x = margin;\n for (let i = 0; i < headers.length; i++) {\n cur.push(\"BT /F2 9 Tf \" + x + \" \" + y + \" Td (\" + headers[i] + \") Tj ET\");\n x += cols[i];\n }\n y -= 20;\n\n for (const r of rows) {\n sum += Number(r.total) || 0;\n if (y < 60) { cur = new Array(); pages.push(cur); y = 800; }\n const cells = [\n String(r.date ?? \"\"),\n String(r.served ?? \"\"),\n String(r.seller ?? \"\"),\n String(r.mules ?? \"\"),\n String(r.price ?? \"\"),\n String(r.total ?? \"\"),\n String(r.payment ?? \"\"),\n String(r.note ?? \"\"),\n ];\n x = margin;\n for (let i = 0; i < cells.length; i++) {\n cur.push(\"BT /F1 9 Tf \" + x + \" \" + y + \" Td (\" + cells[i] + \") Tj ET\");\n x += cols[i];\n }\n y -= lineHeight;\n }\n\n // Summe\n y -= 20;\n cur.push(\"BT /F2 11 Tf \" + margin + \" \" + y + \" Td (Gesamt: \" + pdfEsc(sum) + \" $) Tj ET\");\n\n // PDF aufbauen\n const contentStreams = pages.map((p) => p.join(\"\\n\"));\n const pdf = [\"%PDF-1.4\"];\n const offsets: number[] = [];\n const objects: string[] = [];\n // Objekt 1: Catalog; 2: Pages; dann pro Seite Contents + Page\n objects.push(\"<< /Type /Catalog /Pages 2 0 R >>\");\n objects.push(\"<< /Type /Pages /Kids [\" +\n contentStreams.map((_, i) => `${i * 2 + 3} 0 R`).join(\" \") +\n \"] /Count \" + contentStreams.length + \" >>\");\n for (let i = 0; i < contentStreams.length; i++) {\n // Page (3,5,7,...) und Contents (4,6,8,...)\n objects.push(`<< /Type /Page /Parent 2 0 R /MediaBox [0 0 595 842] ` +\n `/Resources << /Font << /F1 ${4 + contentStreams.length * 2 + i + 1} 0 R /F2 ${4 + contentStreams.length * 2 + i + 2} 0 R >> >> ` +\n `/Contents ${4 + i} 0 R >>`);\n }\n let fontObj = objects.length;\n // Font1: Helvetica, Font2: Helvetica-Bold\n objects.push(\"<< /Type /Font /Subtype /Type1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >>\");\n objects.push(\"<< /Type /Font /Subtype /Type1 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >>\");\n\n pdf.push(\"1 0 obj\\n\" + objects[0] + \"\\nendobj\");\n pdf.push(\"2 0 obj\\n\" + objects[1] + \"\\nendobj\");\n // Nun die Content-Objekte: Nummern 3..(2+n)\n for (let i = 0; i < contentStreams.length; i++) {\n pdf.push(`${3 + i} 0 obj\\n<< /Length ${contentStreams[i].length} >>\\nstream\\n${contentStreams[i]}\\nendstream\\nendobj`);\n }\n // Font-Objekte: Nummern (3+n)..(4+n)\n // F1 = 3+n, F2 = 4+n\n pdf.push(`${3 + contentStreams.length} 0 obj\\n${objects[objects.length - 2]}\\nendobj`);\n pdf.push(`${4 + contentStreams.length} 0 obj\\n${objects[objects.length - 1]}\\nendobj`);\n\n const xrefOffset = pdf.join(\"\\n\").length + 1;\n const xref: string[] = [];\n xref.push(\"xref\");\n xref.push(`0 ${objects.length + 1}`);\n xref.push(\"0000000000 65535 f \");\n let ofs = 9; // Start nach Header\n // Wir müssen echte Offsets berechnen. Einfachheit: brauchen wir nicht exakt, aber Standard-Viewer mögen gültige xref.\n // Daher hier Offsets korrekt aufbauen.\n // Einfacher: Offsets weglassen und xref unreferenziert lassen geht nicht. Wir berechnen.\n\n // Neu bauen mit korrekten Offsets:\n let header = \"%PDF-1.4\\n\";\n const body: string[] = [];\n const offsetsArr: number[] = [];\n let total = header.length;\n const push = (s: string) => { offsetsArr.push(total); total += s.length + 1; body.push(s); };\n\n push(\"1 0 obj\\n\" + objects[0] + \"\\nendobj\");\n push(\"2 0 obj\\n\" + objects[1] + \"\\nendobj\");\n for (let i = 0; i < contentStreams.length; i++) {\n push(`${3 + i} 0 obj\\n<< /Length ${contentStreams[i].length} >>\\nstream\\n${contentStreams[i]}\\nendstream\\nendobj`);\n }\n push(`${3 + contentStreams.length} 0 obj\\n${objects[objects.length - 2]}\\nendobj`);\n push(`${4 + contentStreams.length} 0 obj\\n${objects[objects.length - 1]}\\nendobj`);\n\n const xrefStart = total;\n let xrefStr = \"xref\\n0 \" + (objects.length + 1) + \"\\n\";\n xrefStr += \"0000000000 65535 f \\n\";\n for (const o of offsetsArr) {\n xrefStr += String(o).padStart(10, \"0\") + \" 00000 n \\n\";\n }\n xrefStr += \"trailer\\n<< /Size \" + (objects.length + 1) + \" /Root 1 0 R >>\\nstartxref\\n\" + xrefStart + \"\\n%%EOF\";\n\n const full = header + body.join(\"\\n\") + \"\\n\" + xrefStr;\n return new TextEncoder().encode(full);\n}\n\n// ---------- Einzel-Beleg-PDF ----------\n// Baut ein einseitiges PDF für genau einen Beleg.\nfunction assemblePdf(content: string): Uint8Array {\n const header = \"%PDF-1.4\\n\";\n const objects = [\n \"<< /Type /Catalog /Pages 2 0 R >>\",\n \"<< /Type /Pages /Kids [3 0 R] /Count 1 >>\",\n \"<< /Type /Page /Parent 2 0 R /MediaBox [0 0 595 842] \" +\n \"/Resources << /Font << /F1 5 0 R /F2 6 0 R >> >> /Contents 4 0 R >>\",\n `<< /Length ${content.length} >>\\nstream\\n${content}\\nendstream`,\n \"<< /Type /Font /Subtype /Type1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >>\",\n \"<< /Type /Font /Subtype /Type1 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >>\",\n ];\n const body: string[] = [];\n const offsets: number[] = [];\n let total = header.length;\n for (let i = 0; i < objects.length; i++) {\n offsets.push(total);\n const s = `${i + 1} 0 obj\\n${objects[i]}\\nendobj`;\n body.push(s);\n total += s.length + 1;\n }\n const xrefStart = total;\n let xref = `xref\\n0 ${objects.length + 1}\\n0000000000 65535 f \\n`;\n for (const o of offsets) xref += String(o).padStart(10, \"0\") + \" 00000 n \\n\";\n xref += `trailer\\n<< /Size ${objects.length + 1} /Root 1 0 R >>\\nstartxref\\n${xrefStart}\\n%%EOF`;\n return new TextEncoder().encode(header + body.join(\"\\n\") + \"\\n\" + xref);\n}\n\nfunction buildSinglePdf(row: Record): Uint8Array {\n const lines: string[] = [];\n const add = (txt: string, x: number, y: number, size: number, bold = false) => {\n lines.push(`BT /F${bold ? 2 : 1} ${size} Tf ${x} ${y} Td ${pdfEscapeText(txt)} Tj ET`);\n };\n\n // Kopfzeile\n add(\"THE COMPANY\", 40, 800, 22, true);\n add(\"Kassenbuch - Beleg\", 40, 780, 11);\n add(\"Beleg-Nr. \" + String(row.id ?? \"\"), 40, 762, 10);\n add(\"Exportiert am \" + new Date().toLocaleString(\"de-DE\"), 40, 748, 9);\n\n // Datenfelder\n let y = 700;\n const field = (label: string, value: unknown) => {\n add(label, 40, y, 10, true);\n add(String(value ?? \"\"), 170, y, 10);\n y -= 24;\n };\n field(\"Datum\", row.date);\n field(\"Bedient von\", row.served);\n field(\"Angekauft von\", row.seller);\n field(\"Telefon\", row.phone);\n field(\"Mules\", row.mules);\n field(\"Preis / Mule\", row.price);\n field(\"Gesamt\", String(row.total) + \" $\");\n field(\"Zahlung\", row.payment);\n field(\"Notiz\", row.note);\n\n // Gesamtsumme hervorheben\n y += 24;\n add(\"Gesamtbetrag:\", 40, y, 12, true);\n add(String(row.total) + \" $\", 170, y, 12, true);\n\n return assemblePdf(lines.join(\"\\n\"));\n}\n\n// ---------- HTTP-Handler ----------\nexport default async function handler(req: Request): Promise {\n try {\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n\n // ---------- Login / Logout ----------\n if (path === \"/api/login\" && method === \"POST\") {\n const body = await req.json().catch(() => ({}));\n if (body.password === PASSWORD) {\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\", \"Set-Cookie\": SESSION_COOKIE },\n });\n }\n return json({ ok: false, error: \"Falsches Passwort.\" }, 401);\n }\n if (path === \"/api/logout\" && method === \"POST\") {\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Set-Cookie\": \"company_session=; Path=/; HttpOnly; Max-Age=0\",\n },\n });\n }\n\n // ---------- Auth-Gate ----------\n if (!authed(req)) {\n if (path.startsWith(\"/api/\")) return json({ ok: false, error: \"Nicht angemeldet.\" }, 401);\n return html(await readFile(\"login.html\"));\n }\n\n // ---------- Belege ----------\n if (path === \"/api/receipts\" && method === \"GET\") {\n return json(await allReceipts());\n }\n\n if (path === \"/api/receipts\" && method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n const served = String(b.served || \"\").trim();\n const seller = String(b.seller || \"\").trim();\n if (!served) return json({ ok: false, error: \"Bitte „Bedient von“ angeben.\" }, 400);\n if (!seller) return json({ ok: false, error: \"Bitte „Angekauft von“ angeben.\" }, 400);\n\n const mules = Math.max(0, Math.floor(Number(b.mules) || 0));\n const price = Math.max(0, Math.floor(Number(b.price) || 0));\n const total = mules * price;\n const date = new Date().toLocaleString(\"de-DE\");\n const payment = [\"Grün\", \"Schwarz\", \"Bar\"].includes(String(b.payment))\n ? String(b.payment)\n : \"Grün\";\n\n const res = await sqlite.execute({\n sql: \"INSERT INTO receipts (date,served,seller,phone,mules,price,total,payment,note) VALUES (?,?,?,?,?,?,?,?,?)\",\n args: [date, served, seller, String(b.phone || \"\").trim(), mules, price, total,\n payment, String(b.note || \"\").trim()],\n });\n return json({ ok: true, id: Number(res.lastInsertRowid) });\n }\n\n if (path === \"/api/receipts\" && method === \"DELETE\") {\n await sqlite.execute(\"DELETE FROM receipts\");\n return json({ ok: true });\n }\n\n if (path.startsWith(\"/api/receipts/\") && method === \"DELETE\") {\n const id = Number(path.split(\"/\").pop());\n await sqlite.execute({ sql: \"DELETE FROM receipts WHERE id=?\", args: [id] });\n return json({ ok: true });\n }\n\n // ---------- Einzel-Beleg-PDF ----------\n const pdfMatch = path.match(/^\\/api\\/receipts\\/(\\d+)\\/pdf$/);\n if (pdfMatch && method === \"GET\") {\n const id = Number(pdfMatch[1]);\n const res = await sqlite.execute({ sql: \"SELECT * FROM receipts WHERE id=?\", args: [id] });\n const row = (res.rows as Record[])[0];\n if (!row) return json({ ok: false, error: \"Beleg nicht gefunden.\" }, 404);\n const bytes = buildSinglePdf(row);\n return new Response(bytes, {\n status: 200,\n headers: {\n \"Content-Type\": \"application/pdf\",\n \"Content-Disposition\": `attachment; filename=\"Beleg_${id}.pdf\"`,\n },\n });\n }\n\n // ---------- CSV-Export ----------\n if (path === \"/api/csv\" && method === \"GET\") {\n const rows = await allReceipts();\n const head = [\"Datum\", \"Bedient von\", \"Angekauft von\", \"Telefon\",\n \"Mules\", \"Preis\", \"Gesamt\", \"Zahlung\", \"Notiz\"];\n const lines = [head, ...rows.map((r) =>\n [r.date, r.served, r.seller, r.phone, r.mules, r.price, r.total, r.payment, r.note])];\n const csv = lines\n .map((row) => row.map((v) => '\"' + String(v ?? \"\").replaceAll('\"', '\"\"') + '\"').join(\";\"))\n .join(\"\\n\");\n return new Response(\"\\ufeff\" + csv, {\n headers: {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\": 'attachment; filename=\"The_Company_Belege.csv\"',\n },\n });\n }\n\n // ---------- Admin-Konfiguration ----------\n if (path === \"/api/config\" && method === \"GET\") {\n return json(await getConfig());\n }\n if (path === \"/api/config\" && method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n for (const [k, v] of Object.entries(b)) {\n if (k in DEFAULTS) {\n await sqlite.execute(\n \"INSERT INTO config (key,value) VALUES (?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value\",\n [k, String(v ?? \"\")]\n );\n }\n }\n return json({ ok: true });\n }\n\n // ---------- App-Seite ----------\n return html(await readFile(\"app.html\"));\n } catch (err) {\n console.error(\"Fehler:\", err);\n return json({ ok: false, error: \"Interner Serverfehler.\" }, 500);\n }\n}\n","label","the-company-kassenbuch",[141],"0c2b3ae7-9d2c-4dfb-9dae-aae585281af5","login.html","ce6ab122-a258-11f1-97cb-1607ee4eb77e",2,["D",1787863772902],"\n\nThe Company – Login\n\n\n

THE COMPANY

Bitte anmelden, um fortzufahren.

Falsches Passwort.

\n Passwort\n \n \n

\n\n\n",[153],"96930ac8-0f89-4d1c-98d1-cfe893bcc301",["D",1787864497292],[34],"cadc7ca4-5990-4944-b7af-a92afd83bc5a","README.md","6d1de91a-a259-11f1-9861-1607ee4eb77e",9,["D",1787864038737],"# The Company – Kassenbuch\n\nEine interne Web-App zur Verwaltung von Belegen (Kassenbuch) für **The Company** – eine RP-Wirtschaft im Spiel. Belege werden erfasst, gefiltert, summiert und als CSV exportiert.\n\n## Funktionen\n\n- 🔐 **Passwortgeschützter Login** (Session-Cookie)\n- 🧾 **Belege erfassen** – Bedient von, Angekauft von, Telefon, Zahlung (Grün/Schwarz/Bar), Mules × Preis = Gesamt, Notiz\n- 📊 **Dashboard** – Gesamtumsatz, Beleganzahl, Payout Grün, verkaufte Mules\n- 🔍 **Suchen & Filtern** nach Name, Telefon, Notiz und Zahlungsart\n- ⬇️ **CSV-Export** (deutsche Formatierung, UTF-8 mit BOM)\n- ⚙️ **Einstellungen** – anpassbare Wirtschaftswerte (Einkauf, Mules, Iron Mule, Ratio, Grün/Schwarz, Cap, NPC, Dealer, …)\n- 🗑️ Belege einzeln oder komplett löschen (mit Bestätigung)\n\n## Technik\n\n- **Backend:** `main.ts` – HTTP-Handler (Deno), SQLite-Datenbank (`std/sqlite`)\n- **Frontend:** `app.html` – SPA mit Vanilla JS, dunkles Design\n- **Login:** `login.html`\n\n## API\n\n| Methode | Pfad | Beschreibung |\n|---|---|---|\n| POST | `/api/login` | Anmelden (`{ \"password\": \"…\" }`) |\n| POST | `/api/logout` | Abmelden |\n| GET | `/api/receipts` | Alle Belege (neueste zuerst) |\n| POST | `/api/receipts` | Beleg anlegen |\n| DELETE | `/api/receipts` | Alle Belege löschen |\n| DELETE | `/api/receipts/:id` | Einzelnen Beleg löschen |\n| GET | `/api/csv` | CSV-Export |\n| GET | `/api/config` | Konfiguration lesen |\n| POST | `/api/config` | Konfiguration speichern |\n\n## Konfiguration\n\n- **Passwort:** wird über die Umgebungsvariable `APP_PASSWORD` gesetzt. Ist sie nicht gesetzt, gilt das Standard-Passwort `gta`.\n- **Wirtschaftswerte:** können direkt in der App unter „Einstellungen“ angepasst werden (werden in der Datenbank gespeichert).\n\n## Live\n\n[App öffnen](url:main.ts)\n",[163],"pulls","branches",1,"forks","envVars",{"_177":68,"_179":68},"connections",{"_177":68,"_178":68},"count","unfilledCount","emptyCount",{"_48":162,"_38":163,"_36":164,"_142":-5,"_46":47,"_45":165,"_144":31,"_43":194,"_13":68,"_39":26,"_40":167,"_30":31,"_149":-5,"_185":195,"_33":196},{"_48":159,"_38":34,"_36":37,"_142":-5,"_46":47,"_45":14,"_144":31,"_43":191,"_13":146,"_39":26,"_40":42,"_30":31,"_149":-5,"_185":192,"_33":193},{"_48":152,"_38":153,"_36":154,"_142":-5,"_46":47,"_45":155,"_144":64,"_43":188,"_13":68,"_39":26,"_40":157,"_30":31,"_149":-5,"_185":189,"_33":190},{"_48":140,"_38":141,"_36":62,"_142":-5,"_46":47,"_45":143,"_144":31,"_43":184,"_13":146,"_39":147,"_40":148,"_30":31,"_149":150,"_185":186,"_33":187},["D",1787864273709],"children",[],[141],["D",1787863772902],[],[153],["D",1787864497292],[],[34],["D",1787864038737],[],[163],["D",1787863752548],["D",1789526460011],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":235,"_236":237,"_238":239,"_240":31,"_241":31,"_242":31,"_243":64,"_244":-5,"_245":-7,"_246":-7,"_247":68,"_248":31,"_249":31,"_250":-5,"_251":31,"_252":31,"_253":31,"_254":-5},"ENV",{"_206":207,"_208":209,"_210":95,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234},"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 · v18