U.fin — финансы агентства

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_179":180,"_181":182},"routes/_app.x.$handle.$name",{"_104":103,"_32":49,"_113":94,"_27":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_21":-5,"_125":-5,"_126":-5,"_127":25,"_128":129,"_130":63,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_37":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":25},"version",2,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":21,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","822ee980-9caa-11f1-b817-1607ee4eb77e","name","index.html","fileType","content","\n\n\n \n \n U.fin — финансы агентства\n 💰\" />\n \n \n \n\n\n

\n \n\n\n","createdAt",["D",1787239156729],"branchVersion","branchId","4e7c594c-7131-44af-85f7-c363fcbc85c7",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","78bf61af-bb19-4b2c-900b-e43153ad4bbd","directory",["D",1787239156729],"id","6e904ebf-a254-4dd3-b3e8-cca1eea5f4a2","ufin",["D",1787239139778],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","U.fin — финансовая система агентства недвижимости","imageUrl","caa5b6a0-dd4e-4cd6-a997-9389a6a43948","pinnedFileId","8193b528-9caa-11f1-a2f1-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019eff71-5749-76b5-abdd-e25a47b3deca","tursoName","6e904ebfa2544dd3b3e8cca1eea5f4a2","tursoHostname","6e904ebfa2544dd3b3e8cca1eea5f4a2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_18":59,"_109":110,"_111":25},"branch",{"_13":93,"_32":94,"_47":41,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",61,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tambovtsev007","handle","displayName","Кирилл Тамбовцев","avatar","https://lh3.googleusercontent.com/a/ACg8ocKCNneTjcn307kcxhB_NS1R7_0SBhSKM-2hy73z0JvhXFipwkhs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_37":174,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":175,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":176,"_88":177,"_90":178,"_92":25},"tree",[160,162],"files",[160,161,162],"counts",{"_150":67,"_151":140,"_152":67,"_153":154,"_155":156},"contents",[135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":147,"_32":43,"_30":44,"_139":-5,"_40":41,"_39":14,"_141":63,"_37":148,"_13":67,"_34":45,"_35":-5,"_24":25,"_145":-5,"_27":149},{"_47":137,"_32":138,"_30":61,"_139":-5,"_40":41,"_39":140,"_141":25,"_37":142,"_13":67,"_34":143,"_35":144,"_24":25,"_145":-5,"_27":146},"2483dcfb-9b80-43a9-93b9-0531b30548c8","index.ts","parentId",1,"latest",["D",1787239155723],"http","// U.fin — финансовая система агентства недвижимости (скелет v1)\n// Backend: Hono + SQLite (val-scoped). Вход по PIN.\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ---------------- Схема БД ----------------\nawait sqlite.batch([\n `CREATE TABLE IF NOT EXISTS deals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n created_at TEXT DEFAULT (date('now')),\n client TEXT NOT NULL,\n object TEXT,\n developer TEXT,\n broker TEXT,\n object_price REAL DEFAULT 0,\n commission REAL DEFAULT 0,\n broker_fee REAL DEFAULT 0,\n zadatok_amount REAL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'bron',\n bron_date TEXT, zadatok_date TEXT, sdelka_date TEXT, razval_date TEXT,\n expected_pay_date TEXT,\n source TEXT DEFAULT 'manual',\n comment TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS operations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n type TEXT NOT NULL, -- income | expense\n status TEXT NOT NULL DEFAULT 'plan', -- plan | fact\n amount REAL NOT NULL,\n category TEXT DEFAULT 'other',\n counterparty TEXT,\n deal_id INTEGER,\n comment TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS credits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n monthly_payment REAL DEFAULT 0,\n remaining REAL DEFAULT 0,\n comment TEXT,\n active INTEGER DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS plans (\n period TEXT PRIMARY KEY, -- 'YYYY-MM' или 'YYYY'\n revenue_plan REAL DEFAULT 0,\n deals_plan INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS settings (key TEXT PRIMARY KEY, value TEXT)`,\n]);\nawait sqlite.execute(\n `INSERT INTO settings(key,value) SELECT 'pin','1111'\n WHERE NOT EXISTS (SELECT 1 FROM settings WHERE key='pin')`,\n);\n\nconst today = () => new Date().toISOString().slice(0, 10);\nconst num = (v: unknown) => (v === null || v === undefined || v === \"\" ? 0 : Number(v));\n\nasync function getPin(): Promise {\n const r = await sqlite.execute(`SELECT value FROM settings WHERE key='pin'`);\n return String(r.rows[0]?.value ?? \"1111\");\n}\n\n// ---------------- Авторизация ----------------\napp.use(\"/api/*\", async (c, next) => {\n if (c.req.path === \"/api/login\") return next();\n if ((c.req.header(\"x-pin\") || \"\") !== (await getPin())) {\n return c.json({ error: \"unauthorized\" }, 401);\n }\n await next();\n});\n\napp.post(\"/api/login\", async (c) => {\n const { pin } = await c.req.json();\n if (String(pin) === (await getPin())) return c.json({ ok: true });\n return c.json({ ok: false }, 401);\n});\n\napp.post(\"/api/settings/pin\", async (c) => {\n const { oldPin, newPin } = await c.req.json();\n if (String(oldPin) !== (await getPin())) return c.json({ error: \"Неверный текущий PIN\" }, 400);\n if (!/^\\d{4,8}$/.test(String(newPin))) return c.json({ error: \"PIN: 4–8 цифр\" }, 400);\n await sqlite.execute({ sql: `UPDATE settings SET value=? WHERE key='pin'`, args: [String(newPin)] });\n return c.json({ ok: true });\n});\n\n// ---------------- Сделки ----------------\nconst DEAL_FIELDS = [\n \"client\", \"object\", \"developer\", \"broker\", \"object_price\", \"commission\",\n \"broker_fee\", \"zadatok_amount\", \"expected_pay_date\", \"comment\",\n] as const;\n\napp.get(\"/api/deals\", async (c) => {\n const r = await sqlite.execute(`SELECT * FROM deals ORDER BY id DESC`);\n return c.json(r.rows);\n});\n\napp.post(\"/api/deals\", async (c) => {\n const b = await c.req.json();\n const status = [\"bron\", \"zadatok\", \"sdelka\", \"razval\"].includes(b.status) ? b.status : \"bron\";\n const dateCol = { bron: \"bron_date\", zadatok: \"zadatok_date\", sdelka: \"sdelka_date\", razval: \"razval_date\" }[status];\n const r = await sqlite.execute({\n sql: `INSERT INTO deals (client,object,developer,broker,object_price,commission,broker_fee,\n zadatok_amount,expected_pay_date,comment,status,${dateCol},source)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [\n b.client || \"Без имени\", b.object || \"\", b.developer || \"\", b.broker || \"\",\n num(b.object_price), num(b.commission), num(b.broker_fee), num(b.zadatok_amount),\n b.expected_pay_date || null, b.comment || \"\", status, b.status_date || today(),\n b.source || \"manual\",\n ],\n });\n const id = Number(r.lastInsertRowid);\n if (status === \"sdelka\") await ensureDealOps(id);\n return c.json({ ok: true, id });\n});\n\napp.put(\"/api/deals/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json();\n const sets: string[] = [];\n const args: unknown[] = [];\n for (const f of DEAL_FIELDS) {\n if (f in b) {\n sets.push(`${f}=?`);\n args.push([\"object_price\", \"commission\", \"broker_fee\", \"zadatok_amount\"].includes(f) ? num(b[f]) : (b[f] ?? \"\"));\n }\n }\n if (!sets.length) return c.json({ ok: true });\n args.push(id);\n await sqlite.execute({ sql: `UPDATE deals SET ${sets.join(\",\")} WHERE id=?`, args });\n return c.json({ ok: true });\n});\n\n// перевод статуса: бронь → задаток → сделка; развал из любого\napp.post(\"/api/deals/:id/status\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { status, date } = await c.req.json();\n const dateCol = { bron: \"bron_date\", zadatok: \"zadatok_date\", sdelka: \"sdelka_date\", razval: \"razval_date\" }[status as string];\n if (!dateCol) return c.json({ error: \"bad status\" }, 400);\n await sqlite.execute({\n sql: `UPDATE deals SET status=?, ${dateCol}=COALESCE(?, ${dateCol}, ?) WHERE id=?`,\n args: [status, date || null, today(), id],\n });\n if (status === \"sdelka\") await ensureDealOps(id);\n if (status === \"razval\") {\n // отменяем запланированные (но не фактические) деньги по этой сделке\n await sqlite.execute({ sql: `DELETE FROM operations WHERE deal_id=? AND status='plan'`, args: [id] });\n }\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/deals/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: `DELETE FROM operations WHERE deal_id=? AND status='plan'`, args: [id] },\n { sql: `DELETE FROM deals WHERE id=?`, args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\n// при закрытии сделки автоматически ставим деньги «на заход» и выплату брокеру\nasync function ensureDealOps(dealId: number) {\n const d = (await sqlite.execute({ sql: `SELECT * FROM deals WHERE id=?`, args: [dealId] })).rows[0] as any;\n if (!d) return;\n const ex = await sqlite.execute({ sql: `SELECT category FROM operations WHERE deal_id=?`, args: [dealId] });\n const cats = ex.rows.map((r: any) => r.category);\n const label = [d.object, d.client].filter(Boolean).join(\" / \");\n if (num(d.commission) > 0 && !cats.includes(\"dev_commission\") && !cats.includes(\"client_commission\")) {\n await sqlite.execute({\n sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,deal_id,comment)\n VALUES (?,?,?,?,?,?,?,?)`,\n args: [\n d.expected_pay_date || today(), \"income\", \"plan\", num(d.commission),\n d.developer ? \"dev_commission\" : \"client_commission\",\n d.developer || d.client, dealId, `Комиссия: ${label}`,\n ],\n });\n }\n if (num(d.broker_fee) > 0 && !cats.includes(\"broker_payout\")) {\n await sqlite.execute({\n sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,deal_id,comment)\n VALUES (?,?,?,?,?,?,?,?)`,\n args: [today(), \"expense\", \"plan\", num(d.broker_fee), \"broker_payout\", d.broker || \"Брокер\", dealId, `Выплата брокеру: ${label}`],\n });\n }\n}\n\n// ---------------- Деньги (операции) ----------------\napp.get(\"/api/operations\", async (c) => {\n const r = await sqlite.execute(\n `SELECT o.*, d.client AS deal_client, d.object AS deal_object\n FROM operations o LEFT JOIN deals d ON d.id = o.deal_id\n ORDER BY o.date DESC, o.id DESC`,\n );\n return c.json(r.rows);\n});\n\napp.post(\"/api/operations\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,deal_id,comment)\n VALUES (?,?,?,?,?,?,?,?)`,\n args: [\n b.date || today(), b.type === \"expense\" ? \"expense\" : \"income\",\n b.status === \"fact\" ? \"fact\" : \"plan\", num(b.amount),\n b.category || \"other\", b.counterparty || \"\", b.deal_id || null, b.comment || \"\",\n ],\n });\n return c.json({ ok: true });\n});\n\napp.put(\"/api/operations/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE operations SET date=?, type=?, status=?, amount=?, category=?, counterparty=?, comment=? WHERE id=?`,\n args: [\n b.date || today(), b.type === \"expense\" ? \"expense\" : \"income\",\n b.status === \"fact\" ? \"fact\" : \"plan\", num(b.amount),\n b.category || \"other\", b.counterparty || \"\", b.comment || \"\", id,\n ],\n });\n return c.json({ ok: true });\n});\n\n// «деньги зашли» / «оплачено»: план → факт\napp.post(\"/api/operations/:id/received\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json().catch(() => ({}));\n await sqlite.execute({\n sql: `UPDATE operations SET status='fact', date=? WHERE id=?`,\n args: [b.date || today(), id],\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/operations/:id\", async (c) => {\n await sqlite.execute({ sql: `DELETE FROM operations WHERE id=?`, args: [Number(c.req.param(\"id\"))] });\n return c.json({ ok: true });\n});\n\n// ---------------- Кредиты ----------------\napp.get(\"/api/credits\", async (c) => {\n const r = await sqlite.execute(`SELECT * FROM credits ORDER BY id`);\n return c.json(r.rows);\n});\napp.post(\"/api/credits\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO credits (name,monthly_payment,remaining,comment,active) VALUES (?,?,?,?,1)`,\n args: [b.name || \"Кредит\", num(b.monthly_payment), num(b.remaining), b.comment || \"\"],\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/credits/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE credits SET name=?, monthly_payment=?, remaining=?, comment=?, active=? WHERE id=?`,\n args: [b.name || \"Кредит\", num(b.monthly_payment), num(b.remaining), b.comment || \"\", b.active ? 1 : 0, Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/credits/:id\", async (c) => {\n await sqlite.execute({ sql: `DELETE FROM credits WHERE id=?`, args: [Number(c.req.param(\"id\"))] });\n return c.json({ ok: true });\n});\n\n// ---------------- Планы ----------------\napp.get(\"/api/plans\", async (c) => {\n const r = await sqlite.execute(`SELECT * FROM plans ORDER BY period`);\n return c.json(r.rows);\n});\napp.put(\"/api/plans/:period\", async (c) => {\n const period = c.req.param(\"period\");\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO plans (period, revenue_plan, deals_plan) VALUES (?,?,?)\n ON CONFLICT(period) DO UPDATE SET revenue_plan=excluded.revenue_plan, deals_plan=excluded.deals_plan`,\n args: [period, num(b.revenue_plan), num(b.deals_plan)],\n });\n return c.json({ ok: true });\n});\n\n// ---------------- Дашборд ----------------\napp.get(\"/api/dashboard\", async (c) => {\n const month = c.req.query(\"month\") || today().slice(0, 7);\n const year = month.slice(0, 4);\n const one = async (sql: string, args: unknown[] = []) =>\n (await sqlite.execute({ sql, args })).rows[0] as any;\n\n const incomeFactMonth = await one(\n `SELECT COALESCE(SUM(amount),0) s FROM operations WHERE type='income' AND status='fact' AND substr(date,1,7)=?`, [month]);\n const expenseFactMonth = await one(\n `SELECT COALESCE(SUM(amount),0) s FROM operations WHERE type='expense' AND status='fact' AND substr(date,1,7)=?`, [month]);\n const incomePending = await one(\n `SELECT COALESCE(SUM(amount),0) s, COUNT(*) n FROM operations WHERE type='income' AND status='plan'`);\n const devPending = await one(\n `SELECT COALESCE(SUM(amount),0) s, COUNT(*) n FROM operations WHERE type='income' AND status='plan' AND category='dev_commission'`);\n const brokerDue = await one(\n `SELECT COALESCE(SUM(amount),0) s, COUNT(*) n FROM operations WHERE type='expense' AND status='plan' AND category='broker_payout'`);\n const avgCheck = await one(\n `SELECT COALESCE(AVG(commission),0) s, COUNT(*) n FROM deals WHERE status='sdelka' AND commission>0 AND substr(sdelka_date,1,4)=?`, [year]);\n const counts = await one(\n `SELECT\n SUM(CASE WHEN substr(bron_date,1,7)=? THEN 1 ELSE 0 END) bron,\n SUM(CASE WHEN substr(zadatok_date,1,7)=? THEN 1 ELSE 0 END) zadatok,\n SUM(CASE WHEN substr(sdelka_date,1,7)=? THEN 1 ELSE 0 END) sdelka,\n SUM(CASE WHEN substr(razval_date,1,7)=? THEN 1 ELSE 0 END) razval\n FROM deals`, [month, month, month, month]);\n const credits = await one(\n `SELECT COALESCE(SUM(monthly_payment),0) mp, COALESCE(SUM(remaining),0) rem, COUNT(*) n FROM credits WHERE active=1`);\n const avgExpense = await one(\n `SELECT COALESCE(AVG(s),0) s FROM (\n SELECT substr(date,1,7) m, SUM(amount) s FROM operations\n WHERE type='expense' AND status='fact' GROUP BY substr(date,1,7))`);\n const planMonth = await one(`SELECT revenue_plan, deals_plan FROM plans WHERE period=?`, [month]);\n const planYear = await one(`SELECT revenue_plan, deals_plan FROM plans WHERE period=?`, [year]);\n const incomeFactYear = await one(\n `SELECT COALESCE(SUM(amount),0) s FROM operations WHERE type='income' AND status='fact' AND substr(date,1,4)=?`, [year]);\n const dealsYear = await one(\n `SELECT COUNT(*) n FROM deals WHERE status='sdelka' AND substr(sdelka_date,1,4)=?`, [year]);\n const dealsMonthSum = await one(\n `SELECT COALESCE(SUM(commission),0) s FROM deals WHERE status='sdelka' AND substr(sdelka_date,1,7)=?`, [month]);\n\n return c.json({\n month, year,\n income_fact_month: incomeFactMonth.s,\n expense_fact_month: expenseFactMonth.s,\n income_pending: incomePending.s, income_pending_n: incomePending.n,\n dev_pending: devPending.s, dev_pending_n: devPending.n,\n broker_due: brokerDue.s, broker_due_n: brokerDue.n,\n avg_check: avgCheck.s, avg_check_n: avgCheck.n,\n counts: {\n bron: counts.bron || 0, zadatok: counts.zadatok || 0,\n sdelka: counts.sdelka || 0, razval: counts.razval || 0,\n },\n credits_monthly: credits.mp, credits_remaining: credits.rem, credits_n: credits.n,\n avg_expense: avgExpense.s,\n plan_month: planMonth?.revenue_plan || 0, plan_month_deals: planMonth?.deals_plan || 0,\n plan_year: planYear?.revenue_plan || 0, plan_year_deals: planYear?.deals_plan || 0,\n income_fact_year: incomeFactYear.s,\n deals_year: dealsYear.n,\n deals_month_commission: dealsMonthSum.s,\n });\n});\n\n// ---------------- Демо-данные ----------------\napp.post(\"/api/demo\", async (c) => {\n const { action } = await c.req.json();\n if (action === \"clear\") {\n await sqlite.batch([`DELETE FROM deals`, `DELETE FROM operations`, `DELETE FROM credits`, `DELETE FROM plans`]);\n return c.json({ ok: true });\n }\n const m = today().slice(0, 7); // текущий месяц\n const y = m.slice(0, 4);\n const d = (day: number) => `${m}-${String(day).padStart(2, \"0\")}`;\n await sqlite.batch([\n { sql: `INSERT INTO deals (client,object,developer,broker,object_price,commission,broker_fee,zadatok_amount,status,bron_date,zadatok_date,sdelka_date,expected_pay_date) VALUES ('Иванов А.','ЖК Северный, кв. 45','ГК Столица','Мария',8500000,255000,76500,50000,'sdelka',?,?,?,?)`, args: [d(2), d(5), d(12), d(28)] },\n { sql: `INSERT INTO deals (client,object,developer,broker,object_price,commission,broker_fee,zadatok_amount,status,bron_date,zadatok_date,expected_pay_date) VALUES ('Петрова Е.','ЖК Река, кв. 12','Самолёт','Мария',6200000,186000,55800,50000,'zadatok',?,?,?)`, args: [d(8), d(14), null] },\n { sql: `INSERT INTO deals (client,object,developer,broker,object_price,commission,broker_fee,status,bron_date) VALUES ('Сидоров К.','ЖК Парковый, кв. 89','ПИК','Андрей',5400000,162000,48600,'bron',?)`, args: [d(16)] },\n { sql: `INSERT INTO deals (client,object,developer,broker,object_price,commission,status,bron_date,razval_date) VALUES ('Козлов Д.','Вторичка, ул. Ленина 5','','Андрей',4800000,144000,'razval',?,?)`, args: [d(3), d(10)] },\n ]);\n const dealIds = (await sqlite.execute(`SELECT id, client FROM deals ORDER BY id`)).rows as any[];\n const idByClient = Object.fromEntries(dealIds.map((r) => [r.client, r.id]));\n await sqlite.batch([\n { sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,deal_id,comment) VALUES (?,'income','fact',255000,'dev_commission','ГК Столица',?,'Комиссия: ЖК Северный / Иванов А.')`, args: [d(18), idByClient[\"Иванов А.\"]] },\n { sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,deal_id,comment) VALUES (?,'expense','plan',76500,'broker_payout','Мария',?,'Выплата брокеру: ЖК Северный')`, args: [d(20), idByClient[\"Иванов А.\"]] },\n { sql: `INSERT INTO operations (date,type,status,amount,category,counterparty,comment) VALUES (?,'income','plan',380000,'dev_commission','Брусника','Комиссия за июльскую сделку — ждём оплату')`, args: [`${y}-09-15`] },\n { sql: `INSERT INTO operations (date,type,status,amount,category,comment) VALUES (?,'expense','fact',180000,'salary','Оклады офиса')`, args: [d(5)] },\n { sql: `INSERT INTO operations (date,type,status,amount,category,comment) VALUES (?,'expense','fact',65000,'rent','Аренда офиса')`, args: [d(1)] },\n { sql: `INSERT INTO operations (date,type,status,amount,category,comment) VALUES (?,'expense','fact',45000,'marketing','Реклама Авито + таргет')`, args: [d(7)] },\n `INSERT INTO credits (name,monthly_payment,remaining,comment) VALUES ('Кредит на офис',85000,1450000,'до 12.2027')`,\n `INSERT INTO credits (name,monthly_payment,remaining,comment) VALUES ('Автокредит',42000,610000,'')`,\n { sql: `INSERT INTO plans (period,revenue_plan,deals_plan) VALUES (?,800000,4) ON CONFLICT(period) DO NOTHING`, args: [m] },\n { sql: `INSERT INTO plans (period,revenue_plan,deals_plan) VALUES (?,9000000,45) ON CONFLICT(period) DO NOTHING`, args: [y] },\n ]);\n return c.json({ ok: true });\n});\n\n// ---------------- Frontend ----------------\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n","label",[138],"1ca85b5c-d5d5-43a1-94d8-9ec8c1c79eb5",["D",1787239156729],[43],"pulls","branches","forks","envVars",{"_157":67,"_159":67},"connections",{"_157":67,"_158":67},"count","unfilledCount","emptyCount",{"_47":147,"_32":43,"_30":44,"_139":-5,"_40":41,"_39":14,"_141":63,"_37":171,"_13":67,"_34":45,"_35":-5,"_24":25,"_145":-5,"_164":172,"_27":173},{"_47":167,"_32":33,"_30":31,"_139":44,"_40":41,"_39":14,"_141":25,"_37":168,"_13":67,"_34":21,"_35":36,"_24":25,"_145":-5,"_164":169,"_27":170},{"_47":137,"_32":138,"_30":61,"_139":-5,"_40":41,"_39":140,"_141":25,"_37":163,"_13":67,"_34":143,"_35":144,"_24":25,"_145":-5,"_164":165,"_27":166},["D",1787239155723],"children",[],[138],"27ee0477-722e-483f-ae1b-4ec2ada34a30",["D",1787239156729],[],[43,33],["D",1787239156729],[161],[43],["D",1787239139778],["D",1789499469860],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_18":59,"_109":110,"_111":25},{"_13":93,"_32":94,"_47":41,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":212,"_213":214,"_215":216,"_217":25,"_218":25,"_219":25,"_220":63,"_221":-5,"_222":-7,"_223":-7,"_224":67,"_225":25,"_226":25,"_227":-5,"_228":25,"_229":25,"_230":25,"_231":-5},"ENV",{"_183":184,"_185":186,"_187":94,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211},"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 · v2