Stanje racuna

${\n fmtRsd(d.novo_stanje)\n }

`;\n h += `

Anomalije

0 ? \"r\" : \"g\"\n }\">${an}

`;\n if (d.dug != null) {\n h +=\n `

Dug prema vlasnici

${\n fmtRsd(d.dug)\n }

`;\n }\n if (d.iz) {\n h +=\n `

Poslednji izvod #${d.iz.broj} ${d.iz.datum}

`;\n }\n if (an > 0) {\n h += `

⚠ ${an} neidentifikovanih transakcija.

`;\n }\n return h;\n}\nasync function injectDashboard(html) {\n try {\n const d = await getDashboardData();\n return html.replace(\n '

',\n `

${renderDashboardInner(d)}

`,\n );\n } catch (_) {\n return html;\n }\n}\n\nasync function apiDashboard() {\n return Response.json(await getDashboardData());\n}\n\nasync function apiIzvodi() {\n const r = await sqlite.execute(\"SELECT * FROM izvodi ORDER BY id DESC\");\n return Response.json(\n r.rows.map((x) => ({\n id: x[0],\n broj: x[1],\n datum: x[2],\n prev: x[3],\n zad: x[4],\n od: x[5],\n novo: x[6],\n })),\n );\n}\n\nasync function apiTxn(url) {\n const mes = url.searchParams.get(\"mesec\") || \"\";\n const kat = url.searchParams.get(\"kategorija\") || \"\";\n let sql = \"SELECT * FROM transakcije WHERE 1=1\";\n const p = [];\n if (mes) {\n sql += \" AND mesec_placanja=?\";\n p.push(mes);\n }\n if (kat) {\n sql += \" AND kategorija=?\";\n p.push(kat);\n }\n sql += \" ORDER BY datum DESC, id DESC\";\n const r = await sqlite.execute({ sql, args: p });\n return Response.json(\n r.rows.map((x) => ({\n id: x[0],\n tip: x[3],\n iznos: x[4],\n platilac: x[5],\n svrha: x[6],\n datum: x[7],\n kategorija: x[8],\n mesec: x[9],\n kartica: x[11],\n })),\n );\n}\n\nasync function apiPL(url) {\n const mes = url.searchParams.get(\"mesec\") || \"\";\n if (!mes) return Response.json({ error: \"mesec obavezan\" }, { status: 400 });\n const r = await sqlite.execute({\n sql:\n \"SELECT kategorija, tip, SUM(iznos) FROM transakcije WHERE mesec_placanja=? GROUP BY kategorija, tip\",\n args: [mes],\n });\n const ru = await sqlite.execute({\n sql: \"SELECT tip, SUM(iznos) FROM rucni_unosi WHERE mesec=? GROUP BY tip\",\n args: [mes],\n });\n return Response.json({ t: r.rows, r: ru.rows });\n}\n\nasync function apiKat(id, body) {\n await sqlite.execute({\n sql: \"UPDATE transakcije SET kategorija=? WHERE id=?\",\n args: [body.kategorija, id],\n });\n return Response.json({ ok: true });\n}\n\nasync function apiRucni(body) {\n const datum = new Date().toISOString().split(\"T\")[0];\n await sqlite.execute({\n sql:\n \"INSERT INTO rucni_unosi(mesec,tip,iznos,opis,datum) VALUES(?,?,?,?,?)\",\n args: [body.mesec, body.tip, body.iznos, body.opis || \"\", datum],\n });\n return Response.json({ ok: true });\n}\n\nasync function apiRoditelji(url) {\n const mes = url.searchParams.get(\"mesec\") || \"\";\n const all = await sqlite.execute(\n \"SELECT * FROM roditelji WHERE status='AKTIVAN' ORDER BY ime_deteta\",\n );\n const result = [];\n for (const rod of all.rows) {\n const [id, ime_rod, ime_det, mesecni] = rod;\n let placeno = 0;\n if (mes) {\n const q = ime_det.toUpperCase().substring(0, 4);\n const txn = await sqlite.execute({\n sql:\n \"SELECT SUM(iznos) FROM transakcije WHERE kategorija='SKOLARINA' AND mesec_placanja=? AND (UPPER(platilac) LIKE ? OR UPPER(svrha) LIKE ? OR UPPER(ime_deteta) LIKE ?)\",\n args: [mes, \"%\" + q + \"%\", \"%\" + q + \"%\", \"%\" + q + \"%\"],\n });\n placeno = txn.rows[0][0] || 0;\n }\n result.push({\n id,\n rod: ime_rod,\n det: ime_det,\n mesecni,\n placeno,\n razlika: placeno - mesecni,\n sp: !mes\n ? \"N/A\"\n : placeno >= mesecni && mesecni > 0\n ? \"PLACENO\"\n : placeno > 0\n ? \"DELIMICNO\"\n : \"NIJE_PLATILO\",\n });\n }\n return Response.json(result);\n}\n\nasync function apiRoditeljSave(body) {\n await sqlite.execute({\n sql:\n \"INSERT OR REPLACE INTO roditelji(ime_roditelja,ime_deteta,mesecni_iznos,status) VALUES(?,?,?,?)\",\n args: [\n body.ime_roditelja,\n body.ime_deteta,\n body.mesecni_iznos || 0,\n body.status || \"AKTIVAN\",\n ],\n });\n return Response.json({ ok: true });\n}\n\nasync function apiDug(url) {\n const mes = url.searchParams.get(\"mesec\") || \"\";\n const all = await sqlite.execute(\n \"SELECT * FROM dug_vlasnici ORDER BY mesec DESC\",\n );\n const serv = await sqlite.execute({\n sql:\n \"SELECT SUM(iznos) FROM transakcije WHERE kategorija='SERVISIRANJE_DUGA' AND mesec_placanja=?\",\n args: [mes],\n });\n const row = all.rows.find((r) => r[1] === mes);\n return Response.json({\n row: row\n ? { prev: row[2], serv: row[3], licni: row[4], uv: row[6], novi: row[7] }\n : null,\n sa: serv.rows[0][0] || 0,\n });\n}\n\nasync function apiDugSave(body) {\n const neto = body.serv - body.lic;\n const novi = body.prev - neto + body.uv;\n if (novi < 0) {\n return Response.json({ error: \"Dug ne moze biti negativan!\" }, {\n status: 400,\n });\n }\n const datum = new Date().toISOString().split(\"T\")[0];\n await sqlite.execute({\n sql:\n \"INSERT OR REPLACE INTO dug_vlasnici(mesec,prev,serv,lic,neto,uv,novi,datum,nap) VALUES(?,?,?,?,?,?,?,?,?)\",\n args: [\n body.mesec,\n body.prev,\n body.serv,\n body.lic,\n neto,\n body.uv,\n novi,\n datum,\n body.nap || \"\",\n ],\n });\n return Response.json({ ok: true, novi });\n}\n\nasync function apiZatvaranje(url) {\n const mes = url.searchParams.get(\"mesec\") || \"\";\n const neident = await sqlite.execute({\n sql:\n \"SELECT COUNT(*) FROM transakcije WHERE kategorija='NEIDENTIFIKOVANO' AND mesec_placanja=?\",\n args: [mes],\n });\n const zk = await sqlite.execute({\n sql: \"SELECT SUM(iznos) FROM rucni_unosi WHERE mesec=? AND tip='ZAKUP_KES'\",\n args: [mes],\n });\n const li = await sqlite.execute({\n sql:\n \"SELECT SUM(iznos) FROM rucni_unosi WHERE mesec=? AND tip='LICNI_TROSKOVI'\",\n args: [mes],\n });\n const dug = await sqlite.execute({\n sql: \"SELECT id FROM dug_vlasnici WHERE mesec=?\",\n args: [mes],\n });\n const zat = await sqlite.execute({\n sql: \"SELECT datum FROM zatvoreni WHERE mesec=?\",\n args: [mes],\n });\n const checks = [\n {\n label: \"Nema NEIDENTIFIKOVANIH transakcija\",\n ok: neident.rows[0][0] === 0,\n },\n { label: \"Zakup (kes) unesen\", ok: (zk.rows[0][0] || 0) > 0 },\n { label: \"Licni troskovi potvrdjeni\", ok: (li.rows[0][0] || 0) > 0 },\n { label: \"Obracun duga uradjen\", ok: dug.rows.length > 0 },\n ];\n return Response.json({\n checks,\n moze: checks.every((c) => c.ok),\n zatvoren: zat.rows.length > 0,\n datum: zat.rows.length ? zat.rows[0][0] : null,\n });\n}\n\nasync function apiZatvori(body) {\n const datum = new Date().toISOString().split(\"T\")[0];\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO zatvoreni(mesec,datum) VALUES(?,?)\",\n args: [body.mesec, datum],\n });\n return Response.json({ ok: true });\n}\n\nasync function apiUpload(body) {\n const { pdf_base64, naziv } = body;\n const inst = \"Analiziraj bankarski izvod i vrati ISKLJUCIVO JSON.\\n\" +\n \"IZNOSI: srpski format 1.208.106,13 = 1208106.13.\\n\" +\n \"DATUM: DD.MM.YYYY -> YYYY-MM-DD. MESEC_PLACANJA: MM/YY -> MM/YYYY.\\n\" +\n \"KATEGORIJE: SUBVENCIJA_GRADA(SEKRETARIJAT/GRAD BEOGRAD), SKOLARINA(vrtice/dete+ime), PLATE(plata/zarada/porez), STIPENDIJA, KETERING(GSB), ZAKUP, STRUJA(EPS), KOMUNALIJE(JKP/Infostan), TELEFON(Yettel/MTS/A1), RACUNOVODSTVO(Divac Trade), NAKNADE_BANKE, KARTICA_VLASNICE(debitna kartica), SERVISIRANJE_DUGA, NEIDENTIFIKOVANO.\\n\" +\n \"JSON: {izvod:{broj,datum,prethodno_stanje,ukupno_zaduzenje,ukupno_odobrenje,novo_stanje},transakcije:[{redni_broj,tip(CREDIT/DEBIT),iznos,platilac,svrha,datum,kategorija,mesec_placanja,ime_deteta,is_kartica,is_anomalija}]}\";\n const cr = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"x-api-key\": API_KEY,\n \"anthropic-version\": \"2023-06-01\",\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify({\n model: \"claude-sonnet-4-6\",\n max_tokens: 4096,\n messages: [{\n role: \"user\",\n content: [{\n type: \"document\",\n source: {\n type: \"base64\",\n media_type: \"application/pdf\",\n data: pdf_base64,\n },\n }, { type: \"text\", text: inst }],\n }],\n }),\n });\n const cd = await cr.json();\n if (cd.error) {\n return Response.json({ error: cd.error.message }, { status: 400 });\n }\n let parsed;\n try {\n parsed = JSON.parse(cd.content[0].text.replace(/```json|```/g, \"\").trim());\n } catch (e) {\n return Response.json({ error: \"Parser greska: \" + e.message }, {\n status: 400,\n });\n }\n const iz = parsed.izvod;\n const obrada = new Date().toISOString().split(\"T\")[0];\n const ir = await sqlite.execute({\n sql:\n \"INSERT OR IGNORE INTO izvodi(broj,datum,prethodno_stanje,ukupno_zaduzenje,ukupno_odobrenje,novo_stanje,pdf_naziv,datum_obrade) VALUES(?,?,?,?,?,?,?,?)\",\n args: [\n iz.broj,\n iz.datum,\n iz.prethodno_stanje || 0,\n iz.ukupno_zaduzenje || 0,\n iz.ukupno_odobrenje || 0,\n iz.novo_stanje || 0,\n naziv,\n obrada,\n ],\n });\n const izvod_id = ir.lastInsertRowid;\n let upisano = 0;\n for (const t of (parsed.transakcije || [])) {\n await sqlite.execute({\n sql:\n \"INSERT INTO transakcije(izvod_id,redni_broj,tip,iznos,platilac,svrha,datum,kategorija,mesec_placanja,ime_deteta,is_kartica,is_anomalija) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)\",\n args: [\n izvod_id,\n t.redni_broj || 0,\n t.tip || \"\",\n t.iznos || 0,\n t.platilac || \"\",\n t.svrha || \"\",\n t.datum || \"\",\n t.kategorija || \"NEIDENTIFIKOVANO\",\n t.mesec_placanja || null,\n t.ime_deteta || null,\n t.is_kartica ? 1 : 0,\n t.is_anomalija ? 1 : 0,\n ],\n });\n upisano++;\n }\n return Response.json({ ok: true, broj: iz.broj, n: upisano });\n}\n\nfunction normalizePath(p) {\n let path = (p || \"/\").replace(/\\/+$/, \"\") || \"/\";\n const i = path.indexOf(\"/api/\");\n if (i > 0) path = path.slice(i);\n return path;\n}\n\nexport default async function (req) {\n await initDB();\n const url = new URL(req.url);\n const path = normalizePath(url.pathname);\n const cookies = parseCookies(req.headers.get(\"cookie\") || \"\");\n const loggedIn = await checkSession(cookies.zb_session);\n\n // LOGIN FORM\n if (path === \"/login\" && req.method === \"POST\") {\n const form = await req.formData();\n const pin = form.get(\"pin\") || \"\";\n if (pin.trim() === APP_PIN) {\n const token = makeToken();\n await sqlite.execute({\n sql: \"INSERT INTO sessions(token,created_at) VALUES(?,?)\",\n args: [token, new Date().toISOString()],\n });\n return redirect(\n \"/\",\n \"zb_session=\" + token +\n \"; Path=/; Max-Age=2592000; HttpOnly; SameSite=Lax\",\n );\n }\n const errHtml = decode(LOGIN_B64).replace(\n \"\",\n \"

Pogresan PIN. Pokusaj ponovo.

\",\n );\n return htmlRes(errHtml);\n }\n\n // LOGOUT\n if (path === \"/logout\") {\n return redirect(\"/login\", \"zb_session=; Path=/; Max-Age=0\");\n }\n\n // MAIN PAGE\n if (path === \"/\" && req.method === \"GET\") {\n if (!loggedIn) return redirect(\"/login\");\n let page = decode(APP_B64);\n try {\n page = await injectDashboard(page);\n } catch (e) {\n console.error(\"injectDashboard\", e);\n }\n return htmlRes(page);\n }\n\n // LOGIN PAGE (GET)\n if (path === \"/login\" && req.method === \"GET\") {\n if (loggedIn) return redirect(\"/\");\n return htmlRes(decode(LOGIN_B64));\n }\n\n if (req.method === \"GET\" && path === \"/api/dashboard\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiDashboard();\n }\n if (req.method === \"GET\" && path === \"/api/izvodi\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiIzvodi();\n }\n if (req.method === \"GET\" && path === \"/api/transakcije\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiTxn(url);\n }\n if (req.method === \"GET\" && path === \"/api/pl\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiPL(url);\n }\n if (req.method === \"GET\" && path === \"/api/roditelji\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiRoditelji(url);\n }\n if (req.method === \"POST\" && path === \"/api/roditelj\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiRoditeljSave(await req.json());\n }\n if (req.method === \"GET\" && path === \"/api/dug\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiDug(url);\n }\n if (req.method === \"POST\" && path === \"/api/dug\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiDugSave(await req.json());\n }\n if (req.method === \"GET\" && path === \"/api/zatvaranje\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiZatvaranje(url);\n }\n if (req.method === \"POST\" && path === \"/api/zatvori\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiZatvori(await req.json());\n }\n if (req.method === \"POST\" && path.startsWith(\"/api/kategorija/\")) {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n const id = parseInt(path.split(\"/\").pop());\n return apiKat(id, await req.json());\n }\n if (req.method === \"POST\" && path === \"/api/rucni\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiRucni(await req.json());\n }\n if (req.method === \"POST\" && path === \"/api/upload\") {\n const e = await requireAuth(loggedIn);\n if (e) return e;\n return apiUpload(await req.json());\n }\n return new Response(\"Not found\", { status: 404 });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1779203475005],"children",[],[35],"9401af80-5380-11f1-8458-ee650bb23af1",["D",1779194712924],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Analiza bankarskih izvoda","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/822e2945-ccc3-4218-abff-9d70f252d300/square512?exp=1789549199&sig=e4dc6261a4a799d153b45318794e6b114a523b38d4f409479ab11cebc8eb8d4e","userId","665f634b-b37b-4000-ae03-0761717d4bf8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e3f0d-6866-72ed-a85b-2bbc1dfa1779","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_117":113},"org",{"_11":12,"_110":111,"_112":113,"_72":73,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_102":61,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":14,"_109":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Danijel Alivojvodić","avatar","https://lh3.googleusercontent.com/a/ACg8ocLk14QTI8T-BIXiNjfPYQMceZJgObTfyo6TMs1mAN-MvzTDq9Ob=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":151,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":53,"_76":-5,"_77":-5,"_78":79,"_80":81,"_82":-5,"_83":-5,"_84":-5,"_85":-5,"_86":87,"_88":87,"_89":90,"_91":90,"_92":90,"_93":87,"_94":87,"_95":152,"_97":153,"_99":154,"_101":53},[148],"files",[148],"counts",{"_138":79,"_139":140,"_141":79,"_31":142,"_143":144},[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":137},[35],"pulls","branches",1,"forks",{"_145":79,"_147":79},"connections",{"_145":79,"_146":79},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":149,"_18":150},[],[35],["D",1779194712924],{"_11":12,"_117":113},{"_11":12,"_110":111,"_112":113,"_72":73,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_102":61,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":14,"_109":12},"ctx",{"_95":-5,"_133":188,"_189":190,"_191":192,"_193":53,"_194":53,"_195":53,"_196":44,"_197":-5,"_198":-7,"_199":-7,"_200":79,"_201":53,"_202":53,"_203":-5,"_204":53,"_205":53,"_206":53,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":16,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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