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","label",[110],"pulls","branches",1,"forks","envVars",{"_134":41,"_136":41},"connections",{"_134":41,"_135":41},"count","unfilledCount","emptyCount",{"_18":109,"_20":110,"_111":112,"_113":-5,"_114":67,"_115":65,"_116":103,"_22":138,"_64":118,"_119":120,"_121":122,"_123":26,"_124":-5,"_139":140,"_85":141},["D",1779203475005],"children",[],[110],["D",1779194712924],{"_16":17,"_83":79},{"_16":17,"_76":77,"_78":79,"_34":35,"_80":81,"_82":26},{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"ctx",{"_57":-5,"_105":179,"_180":181,"_182":183,"_184":26,"_185":26,"_186":26,"_187":103,"_188":-5,"_189":-7,"_190":-7,"_191":41,"_192":26,"_193":26,"_194":-5,"_195":26,"_196":26,"_197":26,"_198":-5},"ENV",{"_150":151,"_152":153,"_154":66,"_155":156,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Search