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

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_197":198,"_199":200},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","8193b528-9caa-11f1-a2f1-1607ee4eb77e","name","fileType","http","content","// 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","// U.fin v2 — финансовая система агентства недвижимости по скелету ПланФакта\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\nconst today = () => new Date().toISOString().slice(0, 10);\nconst num = (v: unknown) => (v === null || v === undefined || v === \"\" ? 0 : Number(v));\n\n// ---------------- Схема БД ----------------\nawait sqlite.batch([\n `CREATE TABLE IF NOT EXISTS pf_accounts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n acc_type TEXT DEFAULT 'Безналичный', -- Наличный | Безналичный | Карта физлица | Электронный\n bank TEXT DEFAULT '',\n number TEXT DEFAULT '',\n grp TEXT DEFAULT '', -- группа: Основной счет, Депозиты, Налоговый...\n start_balance REAL DEFAULT 0,\n start_date TEXT,\n active INTEGER DEFAULT 1\n )`,\n `CREATE TABLE IF NOT EXISTS pf_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n kind TEXT NOT NULL, -- income | expense\n parent_id INTEGER,\n sort INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS pf_contractors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n grp TEXT DEFAULT '', -- Застройщик | Брокер (ИП) | Банк | Сотрудник | Прочее\n inn TEXT DEFAULT '',\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS pf_deals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL, -- «Брокер №J1207»\n client TEXT DEFAULT '',\n status TEXT DEFAULT 'work', -- work | nuance | done | fail\n amount REAL DEFAULT 0, -- сумма сделки (комиссия)\n created_at TEXT,\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS pf_ops (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n op_type TEXT NOT NULL, -- income | expense | transfer\n confirmed INTEGER DEFAULT 1, -- 1 = оплата подтверждена (факт), 0 = план\n amount REAL NOT NULL,\n account_id INTEGER, -- счёт (для transfer — со счёта)\n account2_id INTEGER, -- для transfer — на счёт\n category_id INTEGER,\n contractor_id INTEGER,\n deal_id INTEGER,\n purpose TEXT DEFAULT '' -- назначение платежа\n )`,\n `CREATE TABLE IF NOT EXISTS pf_settings (key TEXT PRIMARY KEY, value TEXT)`,\n]);\nawait sqlite.execute(\n `INSERT INTO pf_settings(key,value) SELECT 'pin','1111'\n WHERE NOT EXISTS (SELECT 1 FROM pf_settings WHERE key='pin')`,\n);\n\n// ---------------- Первичное наполнение справочников (как в ПланФакте клиента) ----------------\nasync function seedRefs() {\n const has = (await sqlite.execute(`SELECT COUNT(*) n FROM pf_accounts`)).rows[0] as any;\n if (num(has.n) > 0) return;\n const t = today();\n // Счета (остатки из ПланФакта на 20.08.2026)\n const accounts: [string, string, string, string, string, number][] = [\n [\"Основной расчетный счет\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810300001442713\", \"Основной счет\", 412987.78],\n [\"Касса (наличка)\", \"Наличный\", \"\", \"\", \"Основной счет\", 2288160],\n [\"АЛЬФА-БАНК 2996\", \"Безналичный\", \"АО АЛЬФА-БАНК\", \"40802810502120002996\", \"\", 3145000],\n [\"Т-Банк 5241\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810300009275241\", \"\", 169822.38],\n [\"Налог\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810600003834236\", \"Налоговый\", 241751.34],\n [\"Благотворительность\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810400003834245\", \"Благотворительный счет\", 3596.44],\n [\"ЗП АУП\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810700003834233\", \"Зарплатный\", 0],\n [\"Предоплата от застройщика\", \"Безналичный\", \"АО «Т-Банк»\", \"40802810200003834238\", \"Предоплаты\", 0],\n [\"ХОЗ НУЖДЫ\", \"Безналичный\", \"АО ТБанк\", \"40802810600009124445\", \"\", 0],\n [\"Депозит\", \"Безналичный\", \"АО ТБанк\", \"42110810000000213137\", \"Депозиты\", 0],\n ];\n for (const [name, tp, bank, numb, grp, bal] of accounts) {\n await sqlite.execute({\n sql: `INSERT INTO pf_accounts (name,acc_type,bank,number,grp,start_balance,start_date) VALUES (?,?,?,?,?,?,?)`,\n args: [name, tp, bank, numb, grp, bal, t],\n });\n }\n // Учетные статьи: kind, name, children\n const cat = async (name: string, kind: string, parent: number | null): Promise => {\n const r = await sqlite.execute({\n sql: `INSERT INTO pf_categories (name,kind,parent_id) VALUES (?,?,?)`,\n args: [name, kind, parent],\n });\n return Number(r.lastInsertRowid);\n };\n // Доходы\n await cat(\"Контрагентские\", \"income\", null);\n await cat(\"Страхование\", \"income\", null);\n await cat(\"Оказание услуг\", \"income\", null);\n await cat(\"Регистрация сделки\", \"income\", null);\n const kb = await cat(\"Комиссия от банка\", \"income\", null);\n await cat(\"Абсолют Банк\", \"income\", kb);\n await cat(\"Альфа Банк\", \"income\", kb);\n const pd = await cat(\"Прочие доходы\", \"income\", null);\n await cat(\"Проценты по вкладам\", \"income\", pd);\n await cat(\"Курсовая разница (+)\", \"income\", pd);\n // Расходы\n const perem = await cat(\"Переменные\", \"expense\", null);\n await cat(\"UNLOCK.CRM\", \"expense\", perem);\n await cat(\"Благотворительность\", \"expense\", perem);\n const proizv = await cat(\"Производители\", \"expense\", perem);\n await cat(\"Брокеры\", \"expense\", proizv);\n await cat(\"Контрагенты\", \"expense\", proizv);\n await cat(\"% руководителей\", \"expense\", proizv);\n await cat(\"Ипотека % от кв банка\", \"expense\", proizv);\n await cat(\"Реферальная программа\", \"expense\", proizv);\n const mark = await cat(\"Маркетинг\", \"expense\", perem);\n await cat(\"Рекламная компания\", \"expense\", mark);\n await cat(\"Авито\", \"expense\", mark);\n await cat(\"Циан\", \"expense\", mark);\n await cat(\"Баннер (Растяжка)\", \"expense\", mark);\n await cat(\"Фин.гарантия\", \"expense\", perem);\n await cat(\"Возврат покупателям\", \"expense\", perem);\n const post = await cat(\"Постоянные\", \"expense\", null);\n await cat(\"Супервайзер (коммерция)\", \"expense\", post);\n const fot = await cat(\"ФОТ\", \"expense\", post);\n const dir = await cat(\"Дирекция\", \"expense\", fot);\n await cat(\"CEO\", \"expense\", dir);\n await cat(\"COO\", \"expense\", dir);\n await cat(\"CMO\", \"expense\", dir);\n await cat(\"РОП\", \"expense\", dir);\n const adm = await cat(\"Административный\", \"expense\", fot);\n await cat(\"РОСФИН Юрист\", \"expense\", adm);\n await cat(\"Офис менеджер\", \"expense\", adm);\n await cat(\"Ипотечный специалист\", \"expense\", adm);\n await cat(\"Менеджер отдела Заботы\", \"expense\", adm);\n await cat(\"Куратор по новостройкам\", \"expense\", adm);\n const mrk2 = await cat(\"Маркетинговый\", \"expense\", fot);\n await cat(\"Оператор/монтажер\", \"expense\", mrk2);\n await cat(\"СММ\", \"expense\", mrk2);\n const bonus = await cat(\"Бонусная система\", \"expense\", fot);\n await cat(\"Ежемесячный бонус\", \"expense\", bonus);\n await cat(\"Ежеквартальный бонус\", \"expense\", bonus);\n await cat(\"Годовой бонус\", \"expense\", bonus);\n const ofs = await cat(\"Офис\", \"expense\", post);\n await cat(\"Аренда офиса\", \"expense\", ofs);\n await cat(\"Интерьер\", \"expense\", ofs);\n const po = await cat(\"Программное обеспечение\", \"expense\", post);\n for (const n of [\"U.team\", \"F-doc\", \"CRM\", \"Финучет\", \"Контур\", \"Услуги связи\", \"Яндекс.почта\"]) {\n await cat(n, \"expense\", po);\n }\n const sait = await cat(\"Сайт\", \"expense\", post);\n await cat(\"ФИД новостроек\", \"expense\", sait);\n await cat(\"Налоги\", \"expense\", null);\n await cat(\"Кредиты и овердрафт\", \"expense\", null);\n await cat(\"Нераспределенный расход\", \"expense\", null);\n await cat(\"Нераспределенный доход\", \"income\", null);\n // Контрагенты\n const contractors: [string, string][] = [\n [\"ООО СЗ БЦ АПСАЙД ОСТАНКИНО\", \"Застройщик\"],\n [\"ООО СЗ ПАРК РАЗВЛЕЧЕНИЙ\", \"Застройщик\"],\n [\"ГК Самолёт\", \"Застройщик\"],\n [\"ИП Мателевич Сергей Валерьевич\", \"Брокер (ИП)\"],\n [\"ИП Дедерер Евгения Владимировна\", \"Брокер (ИП)\"],\n [\"АО ТБанк\", \"Банк\"],\n [\"АО АЛЬФА-БАНК\", \"Банк\"],\n ];\n for (const [name, grp] of contractors) {\n await sqlite.execute({ sql: `INSERT INTO pf_contractors (name,grp) VALUES (?,?)`, args: [name, grp] });\n }\n}\nawait seedRefs();\n\nasync function getPin(): Promise {\n const r = await sqlite.execute(`SELECT value FROM pf_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 pf_settings SET value=? WHERE key='pin'`, args: [String(newPin)] });\n return c.json({ ok: true });\n});\n\n// ---------------- Остатки ----------------\n// эффект подтверждённых операций на каждый счёт\nconst BALANCE_SQL = `\n SELECT a.id,\n a.start_balance\n + COALESCE((SELECT SUM(CASE\n WHEN o.op_type='income' AND o.account_id=a.id THEN o.amount\n WHEN o.op_type='expense' AND o.account_id=a.id THEN -o.amount\n WHEN o.op_type='transfer' AND o.account_id=a.id THEN -o.amount\n WHEN o.op_type='transfer' AND o.account2_id=a.id THEN o.amount\n ELSE 0 END)\n FROM pf_ops o\n WHERE o.confirmed=1 AND (o.account_id=a.id OR o.account2_id=a.id)), 0) AS balance\n FROM pf_accounts a`;\n\nasync function accountBalances() {\n const r = await sqlite.execute(BALANCE_SQL);\n const map: Record = {};\n for (const row of r.rows as any[]) map[row.id] = num(row.balance);\n return map;\n}\n\n// ---------------- Справочники ----------------\napp.get(\"/api/meta\", async (c) => {\n const [acc, cats, contr] = await Promise.all([\n sqlite.execute(`SELECT * FROM pf_accounts ORDER BY active DESC, name`),\n sqlite.execute(`SELECT * FROM pf_categories ORDER BY kind, COALESCE(parent_id,0), sort, id`),\n sqlite.execute(`SELECT * FROM pf_contractors ORDER BY name`),\n ]);\n const bal = await accountBalances();\n const accounts = (acc.rows as any[]).map((a) => ({ ...a, balance: bal[a.id] ?? num(a.start_balance) }));\n const total = accounts.filter((a) => a.active).reduce((s, a) => s + a.balance, 0);\n return c.json({ accounts, categories: cats.rows, contractors: contr.rows, total_balance: total });\n});\n\napp.post(\"/api/accounts\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO pf_accounts (name,acc_type,bank,number,grp,start_balance,start_date) VALUES (?,?,?,?,?,?,?)`,\n args: [b.name || \"Счет\", b.acc_type || \"Безналичный\", b.bank || \"\", b.number || \"\", b.grp || \"\", num(b.start_balance), b.start_date || today()],\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/accounts/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE pf_accounts SET name=?, acc_type=?, bank=?, number=?, grp=?, start_balance=?, start_date=?, active=? WHERE id=?`,\n args: [b.name || \"Счет\", b.acc_type || \"Безналичный\", b.bank || \"\", b.number || \"\", b.grp || \"\", num(b.start_balance), b.start_date || today(), b.active === false ? 0 : 1, Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/accounts/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const used = (await sqlite.execute({ sql: `SELECT COUNT(*) n FROM pf_ops WHERE account_id=? OR account2_id=?`, args: [id, id] })).rows[0] as any;\n if (num(used.n) > 0) return c.json({ error: \"По счёту есть операции — сначала удалите их или переведите\" }, 400);\n await sqlite.execute({ sql: `DELETE FROM pf_accounts WHERE id=?`, args: [id] });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/categories\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO pf_categories (name,kind,parent_id) VALUES (?,?,?)`,\n args: [b.name || \"Статья\", b.kind === \"expense\" ? \"expense\" : \"income\", b.parent_id || null],\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/categories/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE pf_categories SET name=?, parent_id=? WHERE id=?`,\n args: [b.name || \"Статья\", b.parent_id || null, Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/categories/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const kids = (await sqlite.execute({ sql: `SELECT COUNT(*) n FROM pf_categories WHERE parent_id=?`, args: [id] })).rows[0] as any;\n if (num(kids.n) > 0) return c.json({ error: \"У статьи есть вложенные — сначала удалите их\" }, 400);\n await sqlite.batch([\n { sql: `UPDATE pf_ops SET category_id=NULL WHERE category_id=?`, args: [id] },\n { sql: `DELETE FROM pf_categories WHERE id=?`, args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/contractors\", async (c) => {\n const b = await c.req.json();\n const r = await sqlite.execute({\n sql: `INSERT INTO pf_contractors (name,grp,inn,comment) VALUES (?,?,?,?)`,\n args: [b.name || \"Контрагент\", b.grp || \"\", b.inn || \"\", b.comment || \"\"],\n });\n return c.json({ ok: true, id: Number(r.lastInsertRowid) });\n});\napp.put(\"/api/contractors/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE pf_contractors SET name=?, grp=?, inn=?, comment=? WHERE id=?`,\n args: [b.name || \"Контрагент\", b.grp || \"\", b.inn || \"\", b.comment || \"\", Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/contractors/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: `UPDATE pf_ops SET contractor_id=NULL WHERE contractor_id=?`, args: [id] },\n { sql: `DELETE FROM pf_contractors WHERE id=?`, args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\n// ---------------- Операции ----------------\napp.get(\"/api/ops\", async (c) => {\n const q = c.req.query();\n const where: string[] = [];\n const args: unknown[] = [];\n if (q.from) { where.push(\"o.date >= ?\"); args.push(q.from); }\n if (q.to) { where.push(\"o.date <= ?\"); args.push(q.to); }\n if (q.type) { where.push(\"o.op_type = ?\"); args.push(q.type); }\n if (q.confirmed === \"1\" || q.confirmed === \"0\") { where.push(\"o.confirmed = ?\"); args.push(Number(q.confirmed)); }\n if (q.account) { where.push(\"(o.account_id = ? OR o.account2_id = ?)\"); args.push(Number(q.account), Number(q.account)); }\n if (q.category) { where.push(\"o.category_id = ?\"); args.push(Number(q.category)); }\n if (q.contractor) { where.push(\"o.contractor_id = ?\"); args.push(Number(q.contractor)); }\n if (q.deal) { where.push(\"o.deal_id = ?\"); args.push(Number(q.deal)); }\n if (q.q) { where.push(\"(o.purpose LIKE ? OR ct.name LIKE ?)\"); args.push(`%${q.q}%`, `%${q.q}%`); }\n const w = where.length ? \"WHERE \" + where.join(\" AND \") : \"\";\n const r = await sqlite.execute({\n sql: `SELECT o.*, a.name account_name, a2.name account2_name, cat.name category_name,\n ct.name contractor_name, d.name deal_name\n FROM pf_ops o\n LEFT JOIN pf_accounts a ON a.id=o.account_id\n LEFT JOIN pf_accounts a2 ON a2.id=o.account2_id\n LEFT JOIN pf_categories cat ON cat.id=o.category_id\n LEFT JOIN pf_contractors ct ON ct.id=o.contractor_id\n LEFT JOIN pf_deals d ON d.id=o.deal_id\n ${w}\n ORDER BY o.date DESC, o.id DESC\n LIMIT 500`,\n args,\n });\n const rows = r.rows as any[];\n const totals = {\n n: rows.length,\n income: rows.filter((x) => x.op_type === \"income\").reduce((s, x) => s + num(x.amount), 0),\n expense: rows.filter((x) => x.op_type === \"expense\").reduce((s, x) => s + num(x.amount), 0),\n transfer: rows.filter((x) => x.op_type === \"transfer\").reduce((s, x) => s + num(x.amount), 0),\n };\n return c.json({ rows, totals });\n});\n\nfunction opArgs(b: any) {\n return [\n b.date || today(),\n [\"income\", \"expense\", \"transfer\"].includes(b.op_type) ? b.op_type : \"income\",\n b.confirmed ? 1 : 0,\n num(b.amount),\n b.account_id || null,\n b.op_type === \"transfer\" ? (b.account2_id || null) : null,\n b.op_type === \"transfer\" ? null : (b.category_id || null),\n b.op_type === \"transfer\" ? null : (b.contractor_id || null),\n b.deal_id || null,\n b.purpose || \"\",\n ];\n}\napp.post(\"/api/ops\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO pf_ops (date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,purpose)\n VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: opArgs(b),\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/ops/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE pf_ops SET date=?,op_type=?,confirmed=?,amount=?,account_id=?,account2_id=?,category_id=?,contractor_id=?,deal_id=?,purpose=? WHERE id=?`,\n args: [...opArgs(b), Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.post(\"/api/ops/:id/confirm\", async (c) => {\n const b = await c.req.json().catch(() => ({}));\n await sqlite.execute({\n sql: `UPDATE pf_ops SET confirmed=1, date=? WHERE id=?`,\n args: [b.date || today(), Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/ops/:id\", async (c) => {\n await sqlite.execute({ sql: `DELETE FROM pf_ops WHERE id=?`, args: [Number(c.req.param(\"id\"))] });\n return c.json({ ok: true });\n});\n\n// ---------------- Сделки ----------------\nconst DEAL_AGG = `\n SELECT d.*,\n COALESCE((SELECT SUM(amount) FROM pf_ops WHERE deal_id=d.id AND op_type='income' AND confirmed=1),0) AS received,\n COALESCE((SELECT SUM(amount) FROM pf_ops WHERE deal_id=d.id AND op_type='income'),0) AS income_all,\n COALESCE((SELECT SUM(amount) FROM pf_ops WHERE deal_id=d.id AND op_type='expense'),0) AS expense_all,\n COALESCE((SELECT SUM(amount) FROM pf_ops WHERE deal_id=d.id AND op_type='expense' AND confirmed=1),0) AS expense_paid\n FROM pf_deals d`;\n\napp.get(\"/api/deals\", async (c) => {\n const r = await sqlite.execute(`${DEAL_AGG} ORDER BY d.created_at DESC, d.id DESC`);\n return c.json(r.rows);\n});\napp.get(\"/api/deals/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const d = (await sqlite.execute({ sql: `${DEAL_AGG} WHERE d.id=?`, args: [id] })).rows[0];\n if (!d) return c.json({ error: \"not found\" }, 404);\n const ops = await sqlite.execute({\n sql: `SELECT o.*, a.name account_name, cat.name category_name, ct.name contractor_name\n FROM pf_ops o\n LEFT JOIN pf_accounts a ON a.id=o.account_id\n LEFT JOIN pf_categories cat ON cat.id=o.category_id\n LEFT JOIN pf_contractors ct ON ct.id=o.contractor_id\n WHERE o.deal_id=? ORDER BY o.date DESC, o.id DESC`,\n args: [id],\n });\n return c.json({ deal: d, ops: ops.rows });\n});\napp.post(\"/api/deals\", async (c) => {\n const b = await c.req.json();\n const r = await sqlite.execute({\n sql: `INSERT INTO pf_deals (name,client,status,amount,created_at,comment) VALUES (?,?,?,?,?,?)`,\n args: [b.name || \"Сделка\", b.client || \"\", b.status || \"work\", num(b.amount), b.created_at || today(), b.comment || \"\"],\n });\n return c.json({ ok: true, id: Number(r.lastInsertRowid) });\n});\napp.put(\"/api/deals/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE pf_deals SET name=?, client=?, status=?, amount=?, created_at=?, comment=? WHERE id=?`,\n args: [b.name || \"Сделка\", b.client || \"\", b.status || \"work\", num(b.amount), b.created_at || today(), b.comment || \"\", Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/deals/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: `UPDATE pf_ops SET deal_id=NULL WHERE deal_id=?`, args: [id] },\n { sql: `DELETE FROM pf_deals WHERE id=?`, args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\n// ---------------- Показатели ----------------\napp.get(\"/api/indicators\", async (c) => {\n const from = c.req.query(\"from\") || `${today().slice(0, 4)}-01-01`;\n const to = c.req.query(\"to\") || today();\n const months = await sqlite.execute({\n sql: `SELECT substr(date,1,7) m,\n SUM(CASE WHEN op_type='income' THEN amount ELSE 0 END) income,\n SUM(CASE WHEN op_type='expense' THEN amount ELSE 0 END) expense\n FROM pf_ops WHERE confirmed=1 AND op_type!='transfer' AND date>=? AND date<=?\n GROUP BY substr(date,1,7) ORDER BY m`,\n args: [from, to],\n });\n const bal = await accountBalances();\n const acc = await sqlite.execute(`SELECT id,name,active FROM pf_accounts WHERE active=1 ORDER BY name`);\n const accounts = (acc.rows as any[]).map((a) => ({ ...a, balance: bal[a.id] ?? 0 }));\n const planned = await sqlite.execute(\n `SELECT\n SUM(CASE WHEN op_type='income' THEN amount ELSE 0 END) inc,\n SUM(CASE WHEN op_type='expense' THEN amount ELSE 0 END) exp,\n COUNT(*) n\n FROM pf_ops WHERE confirmed=0`,\n );\n return c.json({\n from, to,\n months: months.rows,\n accounts,\n total_balance: accounts.reduce((s, a) => s + a.balance, 0),\n planned: planned.rows[0],\n });\n});\n\n// ---------------- Платёжный календарь ----------------\napp.get(\"/api/calendar\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({\n sql: `SELECT substr(date,1,7) m,\n SUM(CASE WHEN op_type='income' AND confirmed=1 THEN amount ELSE 0 END) income_fact,\n SUM(CASE WHEN op_type='expense' AND confirmed=1 THEN amount ELSE 0 END) expense_fact,\n SUM(CASE WHEN op_type='income' THEN amount ELSE 0 END) income_plan,\n SUM(CASE WHEN op_type='expense' THEN amount ELSE 0 END) expense_plan\n FROM pf_ops WHERE op_type!='transfer' AND substr(date,1,4)=?\n GROUP BY substr(date,1,7) ORDER BY m`,\n args: [year],\n });\n return c.json({ year, months: r.rows });\n});\n\n// ---------------- Отчёт ДДС ----------------\napp.get(\"/api/report/cashflow\", async (c) => {\n const from = c.req.query(\"from\") || `${today().slice(0, 4)}-01-01`;\n const to = c.req.query(\"to\") || today();\n const byCat = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m, o.op_type, o.category_id, SUM(o.amount) s\n FROM pf_ops o\n WHERE o.confirmed=1 AND o.date>=? AND o.date<=? AND o.op_type!='transfer'\n GROUP BY substr(o.date,1,7), o.op_type, o.category_id`,\n args: [from, to],\n });\n const transfers = await sqlite.execute({\n sql: `SELECT substr(date,1,7) m, SUM(amount) s FROM pf_ops\n WHERE confirmed=1 AND op_type='transfer' AND date>=? AND date<=?\n GROUP BY substr(date,1,7)`,\n args: [from, to],\n });\n // остаток на конец каждого месяца: старт + все подтверждённые движения до конца месяца\n const startTotal = (await sqlite.execute(`SELECT COALESCE(SUM(start_balance),0) s FROM pf_accounts WHERE active=1`)).rows[0] as any;\n const flows = await sqlite.execute(\n `SELECT substr(date,1,7) m,\n SUM(CASE WHEN op_type='income' THEN amount WHEN op_type='expense' THEN -amount ELSE 0 END) net\n FROM pf_ops WHERE confirmed=1 GROUP BY substr(date,1,7) ORDER BY m`,\n );\n return c.json({\n from, to,\n by_category: byCat.rows,\n transfers: transfers.rows,\n start_total: num(startTotal.s),\n net_by_month: flows.rows,\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 pf_ops`, `DELETE FROM pf_deals`]);\n return c.json({ ok: true });\n }\n const m = today().slice(0, 7);\n const d = (day: number) => `${m}-${String(day).padStart(2, \"0\")}`;\n const acc = async (name: string) => {\n const r = await sqlite.execute({ sql: `SELECT id FROM pf_accounts WHERE name=?`, args: [name] });\n return (r.rows[0] as any)?.id ?? null;\n };\n const cat = async (name: string) => {\n const r = await sqlite.execute({ sql: `SELECT id FROM pf_categories WHERE name=?`, args: [name] });\n return (r.rows[0] as any)?.id ?? null;\n };\n const ctr = async (name: string) => {\n const r = await sqlite.execute({ sql: `SELECT id FROM pf_contractors WHERE name LIKE ?`, args: [`%${name}%`] });\n return (r.rows[0] as any)?.id ?? null;\n };\n const main = await acc(\"Основной расчетный счет\"), tbank = await acc(\"Т-Банк 5241\"), nalog = await acc(\"Налог\");\n const kAgent = await cat(\"Контрагентские\"), kRuk = await cat(\"% руководителей\"), kBrok = await cat(\"Брокеры\"),\n kAvito = await cat(\"Авито\"), kCeo = await cat(\"CEO\"), kNal = await cat(\"Налоги\"), kArenda = await cat(\"Аренда офиса\");\n const upside = await ctr(\"АПСАЙД\"), park = await ctr(\"ПАРК\"), matel = await ctr(\"Мателевич\"), ded = await ctr(\"Дедерер\");\n const deal = async (name: string, client: string, status: string, amount: number, day: number) => {\n const r = await sqlite.execute({\n sql: `INSERT INTO pf_deals (name,client,status,amount,created_at) VALUES (?,?,?,?,?)`,\n args: [name, client, status, amount, d(day)],\n });\n return Number(r.lastInsertRowid);\n };\n const d1 = await deal(\"Мателевич №J1401\", \"Аужбикович Алла Михайловна\", \"done\", 662156, 2);\n const d2 = await deal(\"Дедерер №J1402\", \"Симонов Михаил Юрьевич\", \"work\", 549000, 8);\n const d3 = await deal(\"Тамбовцев (Екатерина)\", \"Зверева Екатерина Викторовна\", \"nuance\", 390000, 12);\n const op = (o: any) =>\n ({ sql: `INSERT INTO pf_ops (date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,purpose) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: [o.date, o.t, o.conf ? 1 : 0, o.sum, o.a ?? null, o.a2 ?? null, o.cat ?? null, o.ctr ?? null, o.deal ?? null, o.p ?? \"\"] });\n await sqlite.batch([\n op({ date: d(5), t: \"income\", conf: 1, sum: 662156, a: main, cat: kAgent, ctr: upside, deal: d1, p: \"Оплата по УПД, вознаграждение за привлечение покупателей\" }),\n op({ date: d(7), t: \"expense\", conf: 1, sum: 300000, a: main, cat: kRuk, ctr: matel, deal: d1, p: \"Агентское вознаграждение по договору\" }),\n op({ date: d(25), t: \"income\", conf: 0, sum: 549000, a: main, cat: kAgent, ctr: park, deal: d2, p: \"Ожидаем оплату комиссии от застройщика\" }),\n op({ date: d(28), t: \"expense\", conf: 0, sum: 164700, a: main, cat: kBrok, ctr: ded, deal: d2, p: \"Выплата брокеру после поступления\" }),\n op({ date: d(3), t: \"expense\", conf: 1, sum: 65000, a: main, cat: kArenda, p: \"Аренда офиса\" }),\n op({ date: d(4), t: \"expense\", conf: 1, sum: 45000, a: main, cat: kAvito, p: \"Реклама Авито\" }),\n op({ date: d(5), t: \"expense\", conf: 1, sum: 150000, a: main, cat: kCeo, p: \"ФОТ дирекция\" }),\n op({ date: d(10), t: \"transfer\", conf: 1, sum: 42000, a: main, a2: nalog, p: \"Перевод собственных средств (налоговая копилка)\" }),\n op({ date: d(15), t: \"expense\", conf: 0, sum: 101601, a: nalog, cat: kNal, p: \"УСН авансовый платёж\" }),\n op({ date: d(12), t: \"transfer\", conf: 1, sum: 30000, a: main, a2: tbank, p: \"Перевод собственных средств\" }),\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","createdAt",["D",1787242192097],"branchVersion","branchId","4e7c594c-7131-44af-85f7-c363fcbc85c7","id","6e904ebf-a254-4dd3-b3e8-cca1eea5f4a2","ufin",["D",1787239139778],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","U.fin — финансовая система агентства недвижимости","imageUrl","caa5b6a0-dd4e-4cd6-a997-9389a6a43948","pinnedFileId","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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"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",{"_43":44,"_32":45,"_38":192,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":193,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":194,"_83":195,"_85":196,"_87":25},"tree",[156,160],"files",[156,157,158,159,160],"counts",{"_146":62,"_147":136,"_148":62,"_149":150,"_151":152},"contents",[130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":58,"_38":143,"_13":62,"_33":144,"_35":-5,"_24":25,"_137":-5,"_27":145},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":135,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_27":138},"82b8cefe-581e-4a22-99f4-9bb2875905c5","parentId","latest",["D",1787242192097],1,"label",[28],"1ca85b5c-d5d5-43a1-94d8-9ec8c1c79eb5","frontend","78bf61af-bb19-4b2c-900b-e43153ad4bbd",2,["D",1787239156729],"directory",[140],"pulls","branches","forks","envVars",{"_153":62,"_155":62},"connections",{"_153":62,"_154":62},"count","unfilledCount","emptyCount",{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":58,"_38":189,"_13":62,"_33":144,"_35":-5,"_24":25,"_137":-5,"_162":190,"_27":191},{"_43":181,"_32":182,"_30":183,"_133":141,"_41":42,"_40":184,"_134":25,"_38":185,"_13":62,"_33":20,"_35":186,"_24":25,"_137":-5,"_162":187,"_27":188},{"_43":173,"_32":174,"_30":175,"_133":141,"_41":42,"_40":176,"_134":25,"_38":177,"_13":136,"_33":20,"_35":178,"_24":25,"_137":-5,"_162":179,"_27":180},{"_43":165,"_32":166,"_30":167,"_133":141,"_41":42,"_40":168,"_134":25,"_38":169,"_13":62,"_33":20,"_35":170,"_24":25,"_137":-5,"_162":171,"_27":172},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":161,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_162":163,"_27":164},["D",1787242192097],"children",[],[28],"6c95cee7-82b4-438a-a7df-ba8cbc7f7cd8","index.tsx","829c2c7a-9caa-11f1-ad94-1607ee4eb77e",3,["D",1787239157444],"// U.fin — фронтенд (React)\nimport React, { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// ---------- helpers ----------\nconst LS_KEY = \"ufin_pin\";\nconst getPin = () => { try { return localStorage.getItem(LS_KEY) || \"\"; } catch { return \"\"; } };\nconst setPinLS = (p: string) => { try { p ? localStorage.setItem(LS_KEY, p) : localStorage.removeItem(LS_KEY); } catch {} };\n\nlet onUnauthorized: () => void = () => {};\nasync function api(path: string, method = \"GET\", body?: unknown) {\n const res = await fetch(\"/api\" + path, {\n method,\n headers: { \"content-type\": \"application/json\", \"x-pin\": getPin() },\n body: body === undefined ? undefined : JSON.stringify(body),\n });\n if (res.status === 401 && path !== \"/login\") { onUnauthorized(); throw new Error(\"unauthorized\"); }\n return res.json();\n}\n\nconst fmt = (n: number) => new Intl.NumberFormat(\"ru-RU\", { maximumFractionDigits: 0 }).format(n || 0) + \" ₽\";\nconst fmtShort = (n: number) => {\n n = n || 0;\n if (Math.abs(n) >= 1_000_000) return (n / 1_000_000).toLocaleString(\"ru-RU\", { maximumFractionDigits: 2 }) + \" млн ₽\";\n return fmt(n);\n};\nconst thisMonth = () => new Date().toISOString().slice(0, 7);\nconst fmtDate = (s?: string) => (s ? s.split(\"-\").reverse().join(\".\") : \"—\");\n\nconst STATUS: Record = {\n bron: { label: \"Бронь\", cls: \"bg-sky-100 text-sky-700\" },\n zadatok: { label: \"Задаток\", cls: \"bg-amber-100 text-amber-700\" },\n sdelka: { label: \"Сделка\", cls: \"bg-emerald-100 text-emerald-700\" },\n razval: { label: \"Развал\", cls: \"bg-rose-100 text-rose-700\" },\n};\nconst CATS: Record = {\n dev_commission: \"Комиссия застройщика\",\n client_commission: \"Комиссия клиента\",\n broker_payout: \"Выплата брокеру\",\n salary: \"Зарплата\",\n rent: \"Офис / аренда\",\n marketing: \"Маркетинг\",\n credit: \"Платёж по кредиту\",\n other: \"Прочее\",\n};\nconst MONTHS = [\"Январь\",\"Февраль\",\"Март\",\"Апрель\",\"Май\",\"Июнь\",\"Июль\",\"Август\",\"Сентябрь\",\"Октябрь\",\"Ноябрь\",\"Декабрь\"];\n\n// ---------- UI primitives ----------\nfunction Modal({ title, onClose, children }: any) {\n return (\n

e.stopPropagation()}>\n

{title}

\n \n

{children}

\n );\n}\nconst inputCls = \"w-full border border-slate-200 rounded-lg px-3 py-2 text-sm focus:border-sky-400 bg-white\";\nfunction Field({ label, children }: any) {\n return

{label}

{children};\n}\nfunction Btn({ children, onClick, kind = \"primary\", small }: any) {\n const base = small ? \"px-2.5 py-1 text-xs rounded-md\" : \"px-4 py-2 text-sm rounded-lg\";\n const kinds: any = {\n primary: \"bg-slate-900 text-white hover:bg-slate-700\",\n green: \"bg-emerald-600 text-white hover:bg-emerald-500\",\n ghost: \"bg-slate-100 text-slate-700 hover:bg-slate-200\",\n danger: \"bg-rose-50 text-rose-600 hover:bg-rose-100\",\n };\n return ;\n}\n\n// ---------- Login ----------\nfunction Login({ onOk }: any) {\n const [pin, setPin] = useState(\"\");\n const [err, setErr] = useState(\"\");\n const submit = async () => {\n const r = await api(\"/login\", \"POST\", { pin });\n if (r.ok) { setPinLS(pin); onOk(); } else setErr(\"Неверный PIN\");\n };\n return (\n

💰

U.fin

Финансы агентства недвижимости

\n setPin(e.target.value)}\n onKeyDown={(e: any) => e.key === \"Enter\" && submit()}\n autoFocus\n />\n {err &&

{err}

}\n

Войти

\n );\n}\n\n// ---------- Dashboard ----------\nfunction Card({ title, value, sub, accent }: any) {\n return (\n

{title}

{value}

\n {sub &&

{sub}

}\n

\n );\n}\nfunction Progress({ label, fact, plan, factLabel, planLabel }: any) {\n const pct = plan > 0 ? Math.min(100, Math.round((fact / plan) * 100)) : 0;\n const color = pct >= 100 ? \"bg-emerald-500\" : pct >= 60 ? \"bg-sky-500\" : \"bg-amber-400\";\n return (\n

{label}

{plan > 0 ? pct + \"%\" : \"план не задан\"}

\n {factLabel ?? fmtShort(fact)}\n {planLabel ?? (\"план \" + fmtShort(plan))}\n

\n );\n}\nfunction Dashboard({ month, refresh }: any) {\n const [d, setD] = useState(null);\n useEffect(() => { api(`/dashboard?month=${month}`).then(setD).catch(() => {}); }, [month, refresh]);\n if (!d) return

Загрузка…

;\n const c = d.counts;\n return (\n

\n \n \n \n \n

Показатели месяца

\n {[[\"Брони\", c.bron, \"text-sky-600\"], [\"Задатки\", c.zadatok, \"text-amber-600\"],\n [\"Сделки\", c.sdelka, \"text-emerald-600\"], [\"Развалы\", c.razval, \"text-rose-500\"]].map(([l, v, cl]: any) => (\n

{v}

{l}

\n ))}\n

\n \n \n \n

\n \n \n

\n );\n}\n\n// ---------- Deals ----------\nconst emptyDeal = { client: \"\", object: \"\", developer: \"\", broker: \"\", object_price: \"\", commission: \"\", broker_fee: \"\", zadatok_amount: \"\", expected_pay_date: \"\", comment: \"\", status: \"bron\" };\nfunction DealModal({ deal, onClose, onSaved }: any) {\n const [f, setF] = useState(deal ? { ...deal } : { ...emptyDeal });\n const set = (k: string) => (e: any) => setF({ ...f, [k]: e.target.value });\n const save = async () => {\n if (deal?.id) await api(`/deals/${deal.id}`, \"PUT\", f);\n else await api(\"/deals\", \"POST\", f);\n onSaved(); onClose();\n };\n return (\n \n

\n \n \n

\n \n \n \n \n \n \n {!deal?.id && (\n \n \n \n )}\n

\n Отмена\n Сохранить\n

\n \n );\n}\nfunction Deals({ refresh, bump }: any) {\n const [rows, setRows] = useState([]);\n const [filter, setFilter] = useState(\"active\");\n const [modal, setModal] = useState(null);\n const load = () => api(\"/deals\").then(setRows).catch(() => {});\n useEffect(() => { load(); }, [refresh]);\n const setStatus = async (id: number, status: string) => {\n if (status === \"razval\" && !confirm(\"Отметить развал? Запланированные деньги по сделке будут сняты.\")) return;\n await api(`/deals/${id}/status`, \"POST\", { status }); load(); bump();\n };\n const del = async (id: number) => {\n if (!confirm(\"Удалить сделку полностью?\")) return;\n await api(`/deals/${id}`, \"DELETE\"); load(); bump();\n };\n const filtered = rows.filter((r) =>\n filter === \"all\" ? true : filter === \"active\" ? r.status !== \"razval\" : r.status === filter,\n );\n const chips = [[\"active\", \"Активные\"], [\"bron\", \"Брони\"], [\"zadatok\", \"Задатки\"], [\"sdelka\", \"Сделки\"], [\"razval\", \"Развалы\"], [\"all\", \"Все\"]];\n return (\n

\n {chips.map(([k, l]) => (\n \n ))}\n

\n setModal({})}>+ Бронь / сделка\n

\n \n \n \n {[\"Клиент / объект\", \"Застройщик\", \"Брокер\", \"Комиссия\", \"Задаток\", \"Статус\", \"\"].map((h) => (\n \n ))}\n \n \n \n {filtered.map((r) => (\n \n \n \n \n \n \n \n \n \n ))}\n {!filtered.length && }\n \n

{h}
\n {r.client} \n {r.object \|\| \"—\"} \n	{r.developer \|\| вторичка}	{r.broker \|\| \"—\"}	{fmt(r.commission)}	{r.zadatok_amount ? fmt(r.zadatok_amount) : \"—\"}	\n {STATUS[r.status].label}\n \n {fmtDate(r[r.status + \"_date\"])}\n \n	\n \n {r.status === \"bron\" && setStatus(r.id, \"zadatok\")}>→ Задаток}\n {r.status === \"zadatok\" && setStatus(r.id, \"sdelka\")}>→ Сделка}\n {(r.status === \"bron\" \|\| r.status === \"zadatok\") && setStatus(r.id, \"razval\")}>Развал}\n {r.status === \"razval\" && setStatus(r.id, \"bron\")}>Вернуть}\n setModal(r)}>✎\n del(r.id)}>🗑\n \n
Пока пусто — добавьте первую бронь

\n {modal && setModal(null)} onSaved={() => { load(); bump(); }} />}\n

\n );\n}\n\n// ---------- Money ----------\nconst emptyOp = { date: \"\", type: \"income\", status: \"fact\", amount: \"\", category: \"other\", counterparty: \"\", comment: \"\" };\nfunction OpModal({ op, onClose, onSaved }: any) {\n const [f, setF] = useState(op ? { ...op } : { ...emptyOp, date: new Date().toISOString().slice(0, 10) });\n const set = (k: string) => (e: any) => setF({ ...f, [k]: e.target.value });\n const save = async () => {\n if (op?.id) await api(`/operations/${op.id}`, \"PUT\", f);\n else await api(\"/operations\", \"POST\", f);\n onSaved(); onClose();\n };\n return (\n \n

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

\n Отмена\n Сохранить\n

\n \n );\n}\nfunction Money({ month, refresh, bump }: any) {\n const [rows, setRows] = useState([]);\n const [filter, setFilter] = useState(\"month\");\n const [modal, setModal] = useState(null);\n const load = () => api(\"/operations\").then(setRows).catch(() => {});\n useEffect(() => { load(); }, [refresh]);\n const received = async (id: number) => { await api(`/operations/${id}/received`, \"POST\", {}); load(); bump(); };\n const del = async (id: number) => { if (confirm(\"Удалить операцию?\")) { await api(`/operations/${id}`, \"DELETE\"); load(); bump(); } };\n const filtered = rows.filter((r) => {\n if (filter === \"month\") return r.date?.slice(0, 7) === month || r.status === \"plan\";\n if (filter === \"pending\") return r.status === \"plan\" && r.type === \"income\";\n if (filter === \"due\") return r.status === \"plan\" && r.type === \"expense\";\n if (filter === \"income\") return r.type === \"income\" && r.status === \"fact\";\n if (filter === \"expense\") return r.type === \"expense\" && r.status === \"fact\";\n return true;\n });\n const chips = [[\"month\", \"Текущий месяц + план\"], [\"pending\", \"На заходе\"], [\"due\", \"К оплате\"], [\"income\", \"Приходы (факт)\"], [\"expense\", \"Расходы (факт)\"], [\"all\", \"Все\"]];\n return (\n

\n {chips.map(([k, l]) => (\n \n ))}\n

\n setModal({})}>+ Операция\n

\n \n \n \n {[\"Дата\", \"Сумма\", \"Категория\", \"Контрагент / сделка\", \"Статус\", \"\"].map((h) => (\n \n ))}\n \n \n \n {filtered.map((r) => (\n \n \n \n \n \n \n \n \n ))}\n {!filtered.length && }\n \n

{h}
{fmtDate(r.date)}	\n {r.type === \"income\" ? \"+\" : \"−\"}{fmt(r.amount)}\n	{CATS[r.category] \|\| r.category}	\n {r.counterparty \|\| \"—\"} \n {r.deal_id && {r.deal_object \|\| \"\"} {r.deal_client ? \"· \" + r.deal_client : \"\"} }\n	\n {r.status === \"fact\"\n ? факт\n : план}\n	\n \n {r.status === \"plan\" && (\n received(r.id)}>\n {r.type === \"income\" ? \"Зашло ✓\" : \"Оплачено ✓\"}\n \n )}\n setModal(r)}>✎\n del(r.id)}>🗑\n \n
Операций нет

\n {modal && setModal(null)} onSaved={() => { load(); bump(); }} />}\n

\n );\n}\n\n// ---------- Credits ----------\nfunction Credits({ bump }: any) {\n const [rows, setRows] = useState([]);\n const [modal, setModal] = useState(null);\n const [f, setF] = useState({});\n const load = () => api(\"/credits\").then(setRows).catch(() => {});\n useEffect(() => { load(); }, []);\n const open = (r?: any) => { setF(r ? { ...r } : { name: \"\", monthly_payment: \"\", remaining: \"\", comment: \"\", active: 1 }); setModal(true); };\n const save = async () => {\n if (f.id) await api(`/credits/${f.id}`, \"PUT\", f);\n else await api(\"/credits\", \"POST\", f);\n setModal(false); load(); bump();\n };\n const del = async (id: number) => { if (confirm(\"Удалить кредит?\")) { await api(`/credits/${id}`, \"DELETE\"); load(); bump(); } };\n const set = (k: string) => (e: any) => setF({ ...f, [k]: e.target.value });\n const totalM = rows.filter((r) => r.active).reduce((s, r) => s + r.monthly_payment, 0);\n const totalR = rows.filter((r) => r.active).reduce((s, r) => s + r.remaining, 0);\n return (\n

Платёж в месяц: {fmt(totalM)} · Осталось всего: {fmtShort(totalR)}

\n open()}>+ Кредит\n

\n {rows.map((r) => (\n

{r.name}

\n open(r)}>✎\n del(r.id)}>🗑\n

Платёж: {fmt(r.monthly_payment)} / мес

Осталось: {fmt(r.remaining)}

\n {r.comment &&

{r.comment}

}\n

\n ))}\n {!rows.length &&

Кредитов нет

}\n

\n {modal && (\n setModal(false)}>\n

\n \n \n

\n {f.id ? (\n \n \n \n ) : null}\n

\n setModal(false)}>Отмена\n Сохранить\n

\n \n )}\n

\n );\n}\n\n// ---------- Plans ----------\nfunction Plans({ bump }: any) {\n const [year, setYear] = useState(new Date().getFullYear());\n const [plans, setPlans] = useState([]);\n const [ops, setOps] = useState([]);\n const [edit, setEdit] = useState({});\n const load = () => {\n api(\"/plans\").then(setPlans).catch(() => {});\n api(\"/operations\").then(setOps).catch(() => {});\n };\n useEffect(() => { load(); }, []);\n const planFor = (p: string) => plans.find((x) => x.period === p);\n const factFor = (p: string) =>\n ops.filter((o) => o.type === \"income\" && o.status === \"fact\" && o.date?.startsWith(p)).reduce((s, o) => s + o.amount, 0);\n const save = async (period: string) => {\n const e = edit[period] || {};\n const cur = planFor(period) || {};\n await api(`/plans/${period}`, \"PUT\", {\n revenue_plan: e.revenue_plan ?? cur.revenue_plan ?? 0,\n deals_plan: e.deals_plan ?? cur.deals_plan ?? 0,\n });\n setEdit((s: any) => ({ ...s, [period]: undefined }));\n load(); bump();\n };\n const row = (period: string, label: string) => {\n const p = planFor(period);\n const e = edit[period];\n const fact = factFor(period);\n const plan = e?.revenue_plan ?? p?.revenue_plan ?? \"\";\n const dealsPlan = e?.deals_plan ?? p?.deals_plan ?? \"\";\n const pct = p?.revenue_plan > 0 ? Math.round((fact / p.revenue_plan) * 100) : null;\n return (\n \n {label}\n \n setEdit((s: any) => ({ ...s, [period]: { ...s[period], revenue_plan: ev.target.value } }))} />\n \n \n setEdit((s: any) => ({ ...s, [period]: { ...s[period], deals_plan: ev.target.value } }))} />\n \n {fmtShort(fact)}\n \n {pct === null ? — : (\n = 100 ? \"text-emerald-600 font-semibold\" : pct >= 60 ? \"text-sky-600\" : \"text-amber-600\"}>{pct}%\n )}\n \n \n {e && save(period)}>Сохранить}\n \n \n );\n };\n return (\n

\n setYear(year - 1)}>←\n

{year} год

\n setYear(year + 1)}>→\n

План выручки задаётся заранее — дашборд покажет, как идём

\n \n \n \n {[\"Период\", \"План выручки, ₽\", \"План сделок, шт\", \"Факт выручки\", \"Выполнение\", \"\"].map((h) => (\n \n ))}\n \n \n \n {row(String(year), `Весь ${year} год`)}\n {MONTHS.map((mn, i) => row(`${year}-${String(i + 1).padStart(2, \"0\")}`, mn))}\n \n

{h}

\n );\n}\n\n// ---------- Settings ----------\nfunction Settings({ onClose, onLogout, bump }: any) {\n const [oldPin, setOld] = useState(\"\");\n const [newPin, setNew] = useState(\"\");\n const [msg, setMsg] = useState(\"\");\n const changePin = async () => {\n const r = await api(\"/settings/pin\", \"POST\", { oldPin, newPin });\n if (r.ok) { setPinLS(newPin); setMsg(\"PIN изменён ✓\"); } else setMsg(r.error || \"Ошибка\");\n };\n const demo = async (action: string) => {\n if (action === \"clear\" && !confirm(\"Удалить ВСЕ данные системы?\")) return;\n await api(\"/demo\", \"POST\", { action });\n setMsg(action === \"clear\" ? \"Данные очищены\" : \"Демо-данные загружены\");\n bump();\n };\n return (\n \n

Сменить PIN

\n setOld(e.target.value)} />\n setNew(e.target.value)} />\n

Изменить PIN

Данные

\n demo(\"load\")}>Загрузить демо-данные\n demo(\"clear\")}>Очистить всё\n

Демо-данные помогают посмотреть, как выглядит система с цифрами. Перед реальной работой — «Очистить всё».

\n Выйти\n view source\n

\n {msg &&

{msg}

}\n

\n \n );\n}\n\n// ---------- App ----------\nconst TABS = [[\"dash\", \"Дашборд\"], [\"deals\", \"Сделки\"], [\"money\", \"Деньги\"], [\"credits\", \"Кредиты\"], [\"plans\", \"Планы\"]];\nfunction App() {\n const [authed, setAuthed] = useState(!!getPin());\n const [tab, setTab] = useState(\"dash\");\n const [month, setMonth] = useState(thisMonth());\n const [refresh, setRefresh] = useState(0);\n const [settings, setSettings] = useState(false);\n const bump = () => setRefresh((x) => x + 1);\n onUnauthorized = () => { setPinLS(\"\"); setAuthed(false); };\n if (!authed) return setAuthed(true)} />;\n return (\n

💰 U.fin

\n {TABS.map(([k, l]) => (\n \n ))}\n

\n {(tab === \"dash\" || tab === \"money\") && (\n setMonth(e.target.value || thisMonth())} />\n )}\n \n

\n {tab === \"dash\" && }\n {tab === \"deals\" && }\n {tab === \"money\" && }\n {tab === \"credits\" && }\n {tab === \"plans\" && }\n {settings && (\n setSettings(false)} bump={bump}\n onLogout={() => { setPinLS(\"\"); setAuthed(false); setSettings(false); }} />\n )}\n

\n );\n}\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[140,166],"1b523b4d-0f70-4905-a3d5-c5bc5bbba0ec","index.html","822ee980-9caa-11f1-b817-1607ee4eb77e",5,["D",1787239923527],"\n\n\n \n \n U.fin — финансы агентства\n 💰\" />\n \n \n \n\n\n

\n \n\n\n",[],[140,174],"3192b725-ff21-496b-9b42-7f9bd2e6a666","app.js","4acd4e12-9cac-11f1-a1bf-1607ee4eb77e",4,["D",1787239922832],"import React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nconst LS_KEY = \"ufin_pin\";\nconst getPin = () => {\n try {\n return localStorage.getItem(LS_KEY) || \"\";\n } catch {\n return \"\";\n }\n};\nconst setPinLS = (p) => {\n try {\n p ? localStorage.setItem(LS_KEY, p) : localStorage.removeItem(LS_KEY);\n } catch {\n }\n};\nlet onUnauthorized = () => {\n};\nasync function api(path, method = \"GET\", body) {\n const res = await fetch(\"/api\" + path, {\n method,\n headers: { \"content-type\": \"application/json\", \"x-pin\": getPin() },\n body: body === void 0 ? void 0 : JSON.stringify(body)\n });\n if (res.status === 401 && path !== \"/login\") {\n onUnauthorized();\n throw new Error(\"unauthorized\");\n }\n return res.json();\n}\nconst fmt = (n) => new Intl.NumberFormat(\"ru-RU\", { maximumFractionDigits: 0 }).format(n || 0) + \" \\u20BD\";\nconst fmtShort = (n) => {\n n = n || 0;\n if (Math.abs(n) >= 1e6) return (n / 1e6).toLocaleString(\"ru-RU\", { maximumFractionDigits: 2 }) + \" \\u043C\\u043B\\u043D \\u20BD\";\n return fmt(n);\n};\nconst thisMonth = () => (/* @__PURE__ */ new Date()).toISOString().slice(0, 7);\nconst fmtDate = (s) => s ? s.split(\"-\").reverse().join(\".\") : \"\\u2014\";\nconst STATUS = {\n bron: { label: \"\\u0411\\u0440\\u043E\\u043D\\u044C\", cls: \"bg-sky-100 text-sky-700\" },\n zadatok: { label: \"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A\", cls: \"bg-amber-100 text-amber-700\" },\n sdelka: { label: \"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\", cls: \"bg-emerald-100 text-emerald-700\" },\n razval: { label: \"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\", cls: \"bg-rose-100 text-rose-700\" }\n};\nconst CATS = {\n dev_commission: \"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F \\u0437\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\\u0430\",\n client_commission: \"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F \\u043A\\u043B\\u0438\\u0435\\u043D\\u0442\\u0430\",\n broker_payout: \"\\u0412\\u044B\\u043F\\u043B\\u0430\\u0442\\u0430 \\u0431\\u0440\\u043E\\u043A\\u0435\\u0440\\u0443\",\n salary: \"\\u0417\\u0430\\u0440\\u043F\\u043B\\u0430\\u0442\\u0430\",\n rent: \"\\u041E\\u0444\\u0438\\u0441 / \\u0430\\u0440\\u0435\\u043D\\u0434\\u0430\",\n marketing: \"\\u041C\\u0430\\u0440\\u043A\\u0435\\u0442\\u0438\\u043D\\u0433\",\n credit: \"\\u041F\\u043B\\u0430\\u0442\\u0451\\u0436 \\u043F\\u043E \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u0443\",\n other: \"\\u041F\\u0440\\u043E\\u0447\\u0435\\u0435\"\n};\nconst MONTHS = [\"\\u042F\\u043D\\u0432\\u0430\\u0440\\u044C\", \"\\u0424\\u0435\\u0432\\u0440\\u0430\\u043B\\u044C\", \"\\u041C\\u0430\\u0440\\u0442\", \"\\u0410\\u043F\\u0440\\u0435\\u043B\\u044C\", \"\\u041C\\u0430\\u0439\", \"\\u0418\\u044E\\u043D\\u044C\", \"\\u0418\\u044E\\u043B\\u044C\", \"\\u0410\\u0432\\u0433\\u0443\\u0441\\u0442\", \"\\u0421\\u0435\\u043D\\u0442\\u044F\\u0431\\u0440\\u044C\", \"\\u041E\\u043A\\u0442\\u044F\\u0431\\u0440\\u044C\", \"\\u041D\\u043E\\u044F\\u0431\\u0440\\u044C\", \"\\u0414\\u0435\\u043A\\u0430\\u0431\\u0440\\u044C\"];\nfunction Modal({ title, onClose, children }) {\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"fixed inset-0 bg-black/40 flex items-start justify-center z-50 p-4 overflow-auto\", onClick: onClose }, /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-2xl shadow-xl w-full max-w-lg mt-10\", onClick: (e) => e.stopPropagation() }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex items-center justify-between px-5 py-4 border-b border-slate-100\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"font-semibold text-slate-800\" }, title), /* @__PURE__ */ React.createElement(\"button\", { className: \"text-slate-400 hover:text-slate-600 text-xl leading-none\", onClick: onClose }, \"\\xD7\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"p-5\" }, children)));\n}\nconst inputCls = \"w-full border border-slate-200 rounded-lg px-3 py-2 text-sm focus:border-sky-400 bg-white\";\nfunction Field({ label, children }) {\n return /* @__PURE__ */ React.createElement(\"label\", { className: \"block\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-500 mb-1\" }, label), children);\n}\nfunction Btn({ children, onClick, kind = \"primary\", small }) {\n const base = small ? \"px-2.5 py-1 text-xs rounded-md\" : \"px-4 py-2 text-sm rounded-lg\";\n const kinds = {\n primary: \"bg-slate-900 text-white hover:bg-slate-700\",\n green: \"bg-emerald-600 text-white hover:bg-emerald-500\",\n ghost: \"bg-slate-100 text-slate-700 hover:bg-slate-200\",\n danger: \"bg-rose-50 text-rose-600 hover:bg-rose-100\"\n };\n return /* @__PURE__ */ React.createElement(\"button\", { onClick, className: `${base} font-medium transition ${kinds[kind]}` }, children);\n}\nfunction Login({ onOk }) {\n const [pin, setPin] = useState(\"\");\n const [err, setErr] = useState(\"\");\n const submit = async () => {\n const r = await api(\"/login\", \"POST\", { pin });\n if (r.ok) {\n setPinLS(pin);\n onOk();\n } else setErr(\"\\u041D\\u0435\\u0432\\u0435\\u0440\\u043D\\u044B\\u0439 PIN\");\n };\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"min-h-screen flex items-center justify-center\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-2xl shadow p-8 w-80 text-center\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-3xl mb-1\" }, \"\\u{1F4B0}\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"font-bold text-lg text-slate-800 mb-1\" }, \"U.fin\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm text-slate-500 mb-5\" }, \"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u044B \\u0430\\u0433\\u0435\\u043D\\u0442\\u0441\\u0442\\u0432\\u0430 \\u043D\\u0435\\u0434\\u0432\\u0438\\u0436\\u0438\\u043C\\u043E\\u0441\\u0442\\u0438\"), /* @__PURE__ */ React.createElement(\n \"input\",\n {\n className: inputCls + \" text-center text-lg tracking-widest\",\n type: \"password\",\n inputMode: \"numeric\",\n placeholder: \"PIN-\\u043A\\u043E\\u0434\",\n value: pin,\n onChange: (e) => setPin(e.target.value),\n onKeyDown: (e) => e.key === \"Enter\" && submit(),\n autoFocus: true\n }\n ), err && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-rose-500 text-sm mt-2\" }, err), /* @__PURE__ */ React.createElement(\"div\", { className: \"mt-4\" }, /* @__PURE__ */ React.createElement(Btn, { onClick: submit }, \"\\u0412\\u043E\\u0439\\u0442\\u0438\"))));\n}\nfunction Card({ title, value, sub, accent }) {\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm p-4 border border-slate-100\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-500 mb-1\" }, title), /* @__PURE__ */ React.createElement(\"div\", { className: `text-xl font-bold ${accent || \"text-slate-800\"}` }, value), sub && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-400 mt-1\" }, sub));\n}\nfunction Progress({ label, fact, plan, factLabel, planLabel }) {\n const pct = plan > 0 ? Math.min(100, Math.round(fact / plan * 100)) : 0;\n const color = pct >= 100 ? \"bg-emerald-500\" : pct >= 60 ? \"bg-sky-500\" : \"bg-amber-400\";\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm p-4 border border-slate-100\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-between items-baseline mb-1\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm font-semibold text-slate-700\" }, label), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-500\" }, plan > 0 ? pct + \"%\" : \"\\u043F\\u043B\\u0430\\u043D \\u043D\\u0435 \\u0437\\u0430\\u0434\\u0430\\u043D\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"h-2.5 bg-slate-100 rounded-full overflow-hidden mb-2\" }, /* @__PURE__ */ React.createElement(\"div\", { className: `h-full ${color} rounded-full transition-all`, style: { width: pct + \"%\" } })), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-between text-xs text-slate-500\" }, /* @__PURE__ */ React.createElement(\"span\", null, factLabel ?? fmtShort(fact)), /* @__PURE__ */ React.createElement(\"span\", null, planLabel ?? \"\\u043F\\u043B\\u0430\\u043D \" + fmtShort(plan))));\n}\nfunction Dashboard({ month, refresh }) {\n const [d, setD] = useState(null);\n useEffect(() => {\n api(`/dashboard?month=${month}`).then(setD).catch(() => {\n });\n }, [month, refresh]);\n if (!d) return /* @__PURE__ */ React.createElement(\"div\", { className: \"text-slate-400 text-sm p-8 text-center\" }, \"\\u0417\\u0430\\u0433\\u0440\\u0443\\u0437\\u043A\\u0430\\u2026\");\n const c = d.counts;\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"space-y-3\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 lg:grid-cols-4 gap-3\" }, /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u0417\\u0430\\u0448\\u043B\\u043E \\u0432 \\u044D\\u0442\\u043E\\u043C \\u043C\\u0435\\u0441\\u044F\\u0446\\u0435\",\n value: fmtShort(d.income_fact_month),\n accent: \"text-emerald-600\",\n sub: `\\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B: ${fmtShort(d.expense_fact_month)}`\n }\n ), /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u0414\\u0435\\u043D\\u044C\\u0433\\u0438 \\u043D\\u0430 \\u0437\\u0430\\u0445\\u043E\\u0434\\u0435\",\n value: fmtShort(d.income_pending),\n accent: \"text-sky-600\",\n sub: `${d.income_pending_n} \\u043F\\u043B\\u0430\\u0442\\u0435\\u0436(\\u0435\\u0439) \\u043E\\u0436\\u0438\\u0434\\u0430\\u0435\\u043C`\n }\n ), /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u041E\\u0442 \\u0437\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\\u043E\\u0432\",\n value: fmtShort(d.dev_pending),\n accent: \"text-violet-600\",\n sub: `${d.dev_pending_n} \\u043A\\u043E\\u043C\\u0438\\u0441\\u0441. \\u0432 \\u043E\\u0436\\u0438\\u0434\\u0430\\u043D\\u0438\\u0438`\n }\n ), /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\\u0430\\u043C \\u043A \\u0432\\u044B\\u043F\\u043B\\u0430\\u0442\\u0435\",\n value: fmtShort(d.broker_due),\n accent: \"text-amber-600\",\n sub: `${d.broker_due_n} \\u0432\\u044B\\u043F\\u043B\\u0430\\u0442(\\u044B)`\n }\n )), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 lg:grid-cols-4 gap-3\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm p-4 border border-slate-100\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-500 mb-2\" }, \"\\u041F\\u043E\\u043A\\u0430\\u0437\\u0430\\u0442\\u0435\\u043B\\u0438 \\u043C\\u0435\\u0441\\u044F\\u0446\\u0430\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-4 text-center\" }, [\n [\"\\u0411\\u0440\\u043E\\u043D\\u0438\", c.bron, \"text-sky-600\"],\n [\"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043A\\u0438\", c.zadatok, \"text-amber-600\"],\n [\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\", c.sdelka, \"text-emerald-600\"],\n [\"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\\u044B\", c.razval, \"text-rose-500\"]\n ].map(([l, v, cl]) => /* @__PURE__ */ React.createElement(\"div\", { key: l }, /* @__PURE__ */ React.createElement(\"div\", { className: `text-lg font-bold ${cl}` }, v), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-[10px] text-slate-400\" }, l))))), /* @__PURE__ */ React.createElement(Card, { title: \"\\u0421\\u0440\\u0435\\u0434\\u043D\\u0438\\u0439 \\u0447\\u0435\\u043A (\\u0433\\u043E\\u0434)\", value: fmtShort(d.avg_check), sub: `\\u043F\\u043E ${d.avg_check_n} \\u0437\\u0430\\u043A\\u0440\\u044B\\u0442\\u044B\\u043C \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\\u043C` }), /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B\",\n value: fmt(d.credits_monthly) + \" / \\u043C\\u0435\\u0441\",\n accent: \"text-rose-600\",\n sub: `\\u043E\\u0441\\u0442\\u0430\\u043B\\u043E\\u0441\\u044C \\u0432\\u0441\\u0435\\u0433\\u043E: ${fmtShort(d.credits_remaining)}`\n }\n ), /* @__PURE__ */ React.createElement(\n Card,\n {\n title: \"\\u0421\\u0440\\u0435\\u0434\\u043D\\u0438\\u0439 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434 / \\u043C\\u0435\\u0441\",\n value: fmtShort(d.avg_expense),\n sub: `\\u0432 \\u044D\\u0442\\u043E\\u043C \\u043C\\u0435\\u0441\\u044F\\u0446\\u0435: ${fmtShort(d.expense_fact_month)}`\n }\n )), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-1 lg:grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(Progress, { label: `\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 ${MONTHS[+month.slice(5) - 1].toLowerCase()}`, fact: d.income_fact_month, plan: d.plan_month }), /* @__PURE__ */ React.createElement(Progress, { label: `\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 ${d.year} \\u0433\\u043E\\u0434`, fact: d.income_fact_year, plan: d.plan_year })), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-1 lg:grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(\n Progress,\n {\n label: \"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438 \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446 (\\u0448\\u0442.)\",\n fact: c.sdelka,\n plan: d.plan_month_deals,\n factLabel: `${c.sdelka} \\u0441\\u0434\\u0435\\u043B.`,\n planLabel: `\\u043F\\u043B\\u0430\\u043D ${d.plan_month_deals || \"\\u2014\"} \\u0441\\u0434\\u0435\\u043B.`\n }\n ), /* @__PURE__ */ React.createElement(\n Progress,\n {\n label: `\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438 \\u0437\\u0430 ${d.year} \\u0433\\u043E\\u0434 (\\u0448\\u0442.)`,\n fact: d.deals_year,\n plan: d.plan_year_deals,\n factLabel: `${d.deals_year} \\u0441\\u0434\\u0435\\u043B.`,\n planLabel: `\\u043F\\u043B\\u0430\\u043D ${d.plan_year_deals || \"\\u2014\"} \\u0441\\u0434\\u0435\\u043B.`\n }\n )));\n}\nconst emptyDeal = { client: \"\", object: \"\", developer: \"\", broker: \"\", object_price: \"\", commission: \"\", broker_fee: \"\", zadatok_amount: \"\", expected_pay_date: \"\", comment: \"\", status: \"bron\" };\nfunction DealModal({ deal, onClose, onSaved }) {\n const [f, setF] = useState(deal ? { ...deal } : { ...emptyDeal });\n const set = (k) => (e) => setF({ ...f, [k]: e.target.value });\n const save = async () => {\n if (deal?.id) await api(`/deals/${deal.id}`, \"PUT\", f);\n else await api(\"/deals\", \"POST\", f);\n onSaved();\n onClose();\n };\n return /* @__PURE__ */ React.createElement(Modal, { title: deal?.id ? \"\\u0420\\u0435\\u0434\\u0430\\u043A\\u0442\\u0438\\u0440\\u043E\\u0432\\u0430\\u0442\\u044C \\u0441\\u0434\\u0435\\u043B\\u043A\\u0443\" : \"\\u041D\\u043E\\u0432\\u0430\\u044F \\u0431\\u0440\\u043E\\u043D\\u044C / \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\", onClose }, /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442 *\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.client, onChange: set(\"client\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.broker, onChange: set(\"broker\") })), /* @__PURE__ */ React.createElement(\"div\", { className: \"col-span-2\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041E\\u0431\\u044A\\u0435\\u043A\\u0442 (\\u0416\\u041A, \\u043A\\u0432\\u0430\\u0440\\u0442\\u0438\\u0440\\u0430)\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.object, onChange: set(\"object\") }))), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0417\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A (\\u043F\\u0443\\u0441\\u0442\\u043E = \\u0432\\u0442\\u043E\\u0440\\u0438\\u0447\\u043A\\u0430)\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.developer, onChange: set(\"developer\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0421\\u0442\\u043E\\u0438\\u043C\\u043E\\u0441\\u0442\\u044C \\u043E\\u0431\\u044A\\u0435\\u043A\\u0442\\u0430\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.object_price, onChange: set(\"object_price\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F \\u0430\\u0433\\u0435\\u043D\\u0442\\u0441\\u0442\\u0432\\u0430\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.commission, onChange: set(\"commission\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0412\\u043E\\u0437\\u043D\\u0430\\u0433\\u0440\\u0430\\u0436\\u0434\\u0435\\u043D\\u0438\\u0435 \\u0431\\u0440\\u043E\\u043A\\u0435\\u0440\\u0430\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.broker_fee, onChange: set(\"broker_fee\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0421\\u0443\\u043C\\u043C\\u0430 \\u0437\\u0430\\u0434\\u0430\\u0442\\u043A\\u0430\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.zadatok_amount, onChange: set(\"zadatok_amount\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041E\\u0436\\u0438\\u0434\\u0430\\u0435\\u043C \\u043E\\u043F\\u043B\\u0430\\u0442\\u0443 \\u043A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u0438\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"date\", value: f.expected_pay_date || \"\", onChange: set(\"expected_pay_date\") })), !deal?.id && /* @__PURE__ */ React.createElement(Field, { label: \"\\u0421\\u0442\\u0430\\u0440\\u0442\\u043E\\u0432\\u044B\\u0439 \\u0441\\u0442\\u0430\\u0442\\u0443\\u0441\" }, /* @__PURE__ */ React.createElement(\"select\", { className: inputCls, value: f.status, onChange: set(\"status\") }, /* @__PURE__ */ React.createElement(\"option\", { value: \"bron\" }, \"\\u0411\\u0440\\u043E\\u043D\\u044C\"), /* @__PURE__ */ React.createElement(\"option\", { value: \"zadatok\" }, \"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A\"), /* @__PURE__ */ React.createElement(\"option\", { value: \"sdelka\" }, \"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\"))), /* @__PURE__ */ React.createElement(\"div\", { className: \"col-span-2\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.comment || \"\", onChange: set(\"comment\") })))), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-end gap-2 mt-5\" }, /* @__PURE__ */ React.createElement(Btn, { kind: \"ghost\", onClick: onClose }, \"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"), /* @__PURE__ */ React.createElement(Btn, { onClick: save }, \"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\")));\n}\nfunction Deals({ refresh, bump }) {\n const [rows, setRows] = useState([]);\n const [filter, setFilter] = useState(\"active\");\n const [modal, setModal] = useState(null);\n const load = () => api(\"/deals\").then(setRows).catch(() => {\n });\n useEffect(() => {\n load();\n }, [refresh]);\n const setStatus = async (id, status) => {\n if (status === \"razval\" && !confirm(\"\\u041E\\u0442\\u043C\\u0435\\u0442\\u0438\\u0442\\u044C \\u0440\\u0430\\u0437\\u0432\\u0430\\u043B? \\u0417\\u0430\\u043F\\u043B\\u0430\\u043D\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u043D\\u044B\\u0435 \\u0434\\u0435\\u043D\\u044C\\u0433\\u0438 \\u043F\\u043E \\u0441\\u0434\\u0435\\u043B\\u043A\\u0435 \\u0431\\u0443\\u0434\\u0443\\u0442 \\u0441\\u043D\\u044F\\u0442\\u044B.\")) return;\n await api(`/deals/${id}/status`, \"POST\", { status });\n load();\n bump();\n };\n const del = async (id) => {\n if (!confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C \\u0441\\u0434\\u0435\\u043B\\u043A\\u0443 \\u043F\\u043E\\u043B\\u043D\\u043E\\u0441\\u0442\\u044C\\u044E?\")) return;\n await api(`/deals/${id}`, \"DELETE\");\n load();\n bump();\n };\n const filtered = rows.filter(\n (r) => filter === \"all\" ? true : filter === \"active\" ? r.status !== \"razval\" : r.status === filter\n );\n const chips = [[\"active\", \"\\u0410\\u043A\\u0442\\u0438\\u0432\\u043D\\u044B\\u0435\"], [\"bron\", \"\\u0411\\u0440\\u043E\\u043D\\u0438\"], [\"zadatok\", \"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043A\\u0438\"], [\"sdelka\", \"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\"], [\"razval\", \"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\\u044B\"], [\"all\", \"\\u0412\\u0441\\u0435\"]];\n return /* @__PURE__ */ React.createElement(\"div\", null, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex flex-wrap items-center gap-2 mb-3\" }, chips.map(([k, l]) => /* @__PURE__ */ React.createElement(\n \"button\",\n {\n key: k,\n onClick: () => setFilter(k),\n className: `px-3 py-1.5 rounded-full text-xs font-medium ${filter === k ? \"bg-slate-900 text-white\" : \"bg-white text-slate-600 border border-slate-200\"}`\n },\n l\n )), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex-1\" }), /* @__PURE__ */ React.createElement(Btn, { kind: \"green\", onClick: () => setModal({}) }, \"+ \\u0411\\u0440\\u043E\\u043D\\u044C / \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm border border-slate-100 overflow-x-auto\" }, /* @__PURE__ */ React.createElement(\"table\", { className: \"w-full text-sm min-w-[760px]\" }, /* @__PURE__ */ React.createElement(\"thead\", null, /* @__PURE__ */ React.createElement(\"tr\", { className: \"text-left text-xs text-slate-400 border-b border-slate-100\" }, [\"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442 / \\u043E\\u0431\\u044A\\u0435\\u043A\\u0442\", \"\\u0417\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\", \"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\", \"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F\", \"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A\", \"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\", \"\"].map((h) => /* @__PURE__ */ React.createElement(\"th\", { key: h, className: \"px-3 py-2.5 font-medium\" }, h)))), /* @__PURE__ */ React.createElement(\"tbody\", null, filtered.map((r) => /* @__PURE__ */ React.createElement(\"tr\", { key: r.id, className: \"border-b border-slate-50 hover:bg-slate-50/60\" }, /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"font-medium text-slate-800\" }, r.client), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-400\" }, r.object || \"\\u2014\")), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 text-slate-600\" }, r.developer || /* @__PURE__ */ React.createElement(\"span\", { className: \"text-slate-300\" }, \"\\u0432\\u0442\\u043E\\u0440\\u0438\\u0447\\u043A\\u0430\")), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 text-slate-600\" }, r.broker || \"\\u2014\"), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 font-medium\" }, fmt(r.commission)), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 text-slate-600\" }, r.zadatok_amount ? fmt(r.zadatok_amount) : \"\\u2014\"), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, /* @__PURE__ */ React.createElement(\"span\", { className: `px-2 py-0.5 rounded-full text-xs font-medium ${STATUS[r.status].cls}` }, STATUS[r.status].label), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-[10px] text-slate-400 mt-0.5\" }, fmtDate(r[r.status + \"_date\"]))), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex gap-1 justify-end flex-wrap\" }, r.status === \"bron\" && /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setStatus(r.id, \"zadatok\") }, \"\\u2192 \\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A\"), r.status === \"zadatok\" && /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"green\", onClick: () => setStatus(r.id, \"sdelka\") }, \"\\u2192 \\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\"), (r.status === \"bron\" || r.status === \"zadatok\") && /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"danger\", onClick: () => setStatus(r.id, \"razval\") }, \"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\"), r.status === \"razval\" && /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setStatus(r.id, \"bron\") }, \"\\u0412\\u0435\\u0440\\u043D\\u0443\\u0442\\u044C\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setModal(r) }, \"\\u270E\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"danger\", onClick: () => del(r.id) }, \"\\u{1F5D1}\"))))), !filtered.length && /* @__PURE__ */ React.createElement(\"tr\", null, /* @__PURE__ */ React.createElement(\"td\", { colSpan: 7, className: \"px-3 py-8 text-center text-slate-400 text-sm\" }, \"\\u041F\\u043E\\u043A\\u0430 \\u043F\\u0443\\u0441\\u0442\\u043E \\u2014 \\u0434\\u043E\\u0431\\u0430\\u0432\\u044C\\u0442\\u0435 \\u043F\\u0435\\u0440\\u0432\\u0443\\u044E \\u0431\\u0440\\u043E\\u043D\\u044C\"))))), modal && /* @__PURE__ */ React.createElement(DealModal, { deal: modal.id ? modal : null, onClose: () => setModal(null), onSaved: () => {\n load();\n bump();\n } }));\n}\nconst emptyOp = { date: \"\", type: \"income\", status: \"fact\", amount: \"\", category: \"other\", counterparty: \"\", comment: \"\" };\nfunction OpModal({ op, onClose, onSaved }) {\n const [f, setF] = useState(op ? { ...op } : { ...emptyOp, date: (/* @__PURE__ */ new Date()).toISOString().slice(0, 10) });\n const set = (k) => (e) => setF({ ...f, [k]: e.target.value });\n const save = async () => {\n if (op?.id) await api(`/operations/${op.id}`, \"PUT\", f);\n else await api(\"/operations\", \"POST\", f);\n onSaved();\n onClose();\n };\n return /* @__PURE__ */ React.createElement(Modal, { title: op?.id ? \"\\u0420\\u0435\\u0434\\u0430\\u043A\\u0442\\u0438\\u0440\\u043E\\u0432\\u0430\\u0442\\u044C \\u043E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044E\" : \"\\u041D\\u043E\\u0432\\u0430\\u044F \\u043E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044F\", onClose }, /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u0422\\u0438\\u043F\" }, /* @__PURE__ */ React.createElement(\"select\", { className: inputCls, value: f.type, onChange: set(\"type\") }, /* @__PURE__ */ React.createElement(\"option\", { value: \"income\" }, \"\\u041F\\u0440\\u0438\\u0445\\u043E\\u0434\"), /* @__PURE__ */ React.createElement(\"option\", { value: \"expense\" }, \"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\"))), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\" }, /* @__PURE__ */ React.createElement(\"select\", { className: inputCls, value: f.status, onChange: set(\"status\") }, /* @__PURE__ */ React.createElement(\"option\", { value: \"fact\" }, \"\\u0424\\u0430\\u043A\\u0442 (\\u0434\\u0435\\u043D\\u044C\\u0433\\u0438 \\u043F\\u0440\\u043E\\u0448\\u043B\\u0438)\"), /* @__PURE__ */ React.createElement(\"option\", { value: \"plan\" }, \"\\u041F\\u043B\\u0430\\u043D (\\u043D\\u0430 \\u0437\\u0430\\u0445\\u043E\\u0434\\u0435 / \\u043A \\u043E\\u043F\\u043B\\u0430\\u0442\\u0435)\"))), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0421\\u0443\\u043C\\u043C\\u0430 *\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.amount, onChange: set(\"amount\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u0414\\u0430\\u0442\\u0430\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"date\", value: f.date, onChange: set(\"date\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u0430\\u0442\\u0435\\u0433\\u043E\\u0440\\u0438\\u044F\" }, /* @__PURE__ */ React.createElement(\"select\", { className: inputCls, value: f.category, onChange: set(\"category\") }, Object.entries(CATS).map(([k, v]) => /* @__PURE__ */ React.createElement(\"option\", { key: k, value: k }, v)))), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.counterparty || \"\", onChange: set(\"counterparty\") })), /* @__PURE__ */ React.createElement(\"div\", { className: \"col-span-2\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.comment || \"\", onChange: set(\"comment\") })))), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-end gap-2 mt-5\" }, /* @__PURE__ */ React.createElement(Btn, { kind: \"ghost\", onClick: onClose }, \"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"), /* @__PURE__ */ React.createElement(Btn, { onClick: save }, \"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\")));\n}\nfunction Money({ month, refresh, bump }) {\n const [rows, setRows] = useState([]);\n const [filter, setFilter] = useState(\"month\");\n const [modal, setModal] = useState(null);\n const load = () => api(\"/operations\").then(setRows).catch(() => {\n });\n useEffect(() => {\n load();\n }, [refresh]);\n const received = async (id) => {\n await api(`/operations/${id}/received`, \"POST\", {});\n load();\n bump();\n };\n const del = async (id) => {\n if (confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C \\u043E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044E?\")) {\n await api(`/operations/${id}`, \"DELETE\");\n load();\n bump();\n }\n };\n const filtered = rows.filter((r) => {\n if (filter === \"month\") return r.date?.slice(0, 7) === month || r.status === \"plan\";\n if (filter === \"pending\") return r.status === \"plan\" && r.type === \"income\";\n if (filter === \"due\") return r.status === \"plan\" && r.type === \"expense\";\n if (filter === \"income\") return r.type === \"income\" && r.status === \"fact\";\n if (filter === \"expense\") return r.type === \"expense\" && r.status === \"fact\";\n return true;\n });\n const chips = [[\"month\", \"\\u0422\\u0435\\u043A\\u0443\\u0449\\u0438\\u0439 \\u043C\\u0435\\u0441\\u044F\\u0446 + \\u043F\\u043B\\u0430\\u043D\"], [\"pending\", \"\\u041D\\u0430 \\u0437\\u0430\\u0445\\u043E\\u0434\\u0435\"], [\"due\", \"\\u041A \\u043E\\u043F\\u043B\\u0430\\u0442\\u0435\"], [\"income\", \"\\u041F\\u0440\\u0438\\u0445\\u043E\\u0434\\u044B (\\u0444\\u0430\\u043A\\u0442)\"], [\"expense\", \"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B (\\u0444\\u0430\\u043A\\u0442)\"], [\"all\", \"\\u0412\\u0441\\u0435\"]];\n return /* @__PURE__ */ React.createElement(\"div\", null, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex flex-wrap items-center gap-2 mb-3\" }, chips.map(([k, l]) => /* @__PURE__ */ React.createElement(\n \"button\",\n {\n key: k,\n onClick: () => setFilter(k),\n className: `px-3 py-1.5 rounded-full text-xs font-medium ${filter === k ? \"bg-slate-900 text-white\" : \"bg-white text-slate-600 border border-slate-200\"}`\n },\n l\n )), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex-1\" }), /* @__PURE__ */ React.createElement(Btn, { kind: \"green\", onClick: () => setModal({}) }, \"+ \\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044F\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm border border-slate-100 overflow-x-auto\" }, /* @__PURE__ */ React.createElement(\"table\", { className: \"w-full text-sm min-w-[720px]\" }, /* @__PURE__ */ React.createElement(\"thead\", null, /* @__PURE__ */ React.createElement(\"tr\", { className: \"text-left text-xs text-slate-400 border-b border-slate-100\" }, [\"\\u0414\\u0430\\u0442\\u0430\", \"\\u0421\\u0443\\u043C\\u043C\\u0430\", \"\\u041A\\u0430\\u0442\\u0435\\u0433\\u043E\\u0440\\u0438\\u044F\", \"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442 / \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\", \"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\", \"\"].map((h) => /* @__PURE__ */ React.createElement(\"th\", { key: h, className: \"px-3 py-2.5 font-medium\" }, h)))), /* @__PURE__ */ React.createElement(\"tbody\", null, filtered.map((r) => /* @__PURE__ */ React.createElement(\"tr\", { key: r.id, className: \"border-b border-slate-50 hover:bg-slate-50/60\" }, /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 text-slate-500\" }, fmtDate(r.date)), /* @__PURE__ */ React.createElement(\"td\", { className: `px-3 py-2.5 font-semibold ${r.type === \"income\" ? \"text-emerald-600\" : \"text-rose-600\"}` }, r.type === \"income\" ? \"+\" : \"\\u2212\", fmt(r.amount)), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5 text-slate-600\" }, CATS[r.category] || r.category), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-slate-700\" }, r.counterparty || \"\\u2014\"), r.deal_id && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-[10px] text-slate-400\" }, r.deal_object || \"\", \" \", r.deal_client ? \"\\xB7 \" + r.deal_client : \"\")), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, r.status === \"fact\" ? /* @__PURE__ */ React.createElement(\"span\", { className: \"px-2 py-0.5 rounded-full text-xs bg-emerald-100 text-emerald-700\" }, \"\\u0444\\u0430\\u043A\\u0442\") : /* @__PURE__ */ React.createElement(\"span\", { className: \"px-2 py-0.5 rounded-full text-xs bg-slate-100 text-slate-500\" }, \"\\u043F\\u043B\\u0430\\u043D\")), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2.5\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex gap-1 justify-end\" }, r.status === \"plan\" && /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"green\", onClick: () => received(r.id) }, r.type === \"income\" ? \"\\u0417\\u0430\\u0448\\u043B\\u043E \\u2713\" : \"\\u041E\\u043F\\u043B\\u0430\\u0447\\u0435\\u043D\\u043E \\u2713\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setModal(r) }, \"\\u270E\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"danger\", onClick: () => del(r.id) }, \"\\u{1F5D1}\"))))), !filtered.length && /* @__PURE__ */ React.createElement(\"tr\", null, /* @__PURE__ */ React.createElement(\"td\", { colSpan: 6, className: \"px-3 py-8 text-center text-slate-400 text-sm\" }, \"\\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u0439 \\u043D\\u0435\\u0442\"))))), modal && /* @__PURE__ */ React.createElement(OpModal, { op: modal.id ? modal : null, onClose: () => setModal(null), onSaved: () => {\n load();\n bump();\n } }));\n}\nfunction Credits({ bump }) {\n const [rows, setRows] = useState([]);\n const [modal, setModal] = useState(null);\n const [f, setF] = useState({});\n const load = () => api(\"/credits\").then(setRows).catch(() => {\n });\n useEffect(() => {\n load();\n }, []);\n const open = (r) => {\n setF(r ? { ...r } : { name: \"\", monthly_payment: \"\", remaining: \"\", comment: \"\", active: 1 });\n setModal(true);\n };\n const save = async () => {\n if (f.id) await api(`/credits/${f.id}`, \"PUT\", f);\n else await api(\"/credits\", \"POST\", f);\n setModal(false);\n load();\n bump();\n };\n const del = async (id) => {\n if (confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442?\")) {\n await api(`/credits/${id}`, \"DELETE\");\n load();\n bump();\n }\n };\n const set = (k) => (e) => setF({ ...f, [k]: e.target.value });\n const totalM = rows.filter((r) => r.active).reduce((s, r) => s + r.monthly_payment, 0);\n const totalR = rows.filter((r) => r.active).reduce((s, r) => s + r.remaining, 0);\n return /* @__PURE__ */ React.createElement(\"div\", null, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex items-center gap-3 mb-3\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm text-slate-500\" }, \"\\u041F\\u043B\\u0430\\u0442\\u0451\\u0436 \\u0432 \\u043C\\u0435\\u0441\\u044F\\u0446: \", /* @__PURE__ */ React.createElement(\"b\", { className: \"text-rose-600\" }, fmt(totalM)), \" \\xB7 \\u041E\\u0441\\u0442\\u0430\\u043B\\u043E\\u0441\\u044C \\u0432\\u0441\\u0435\\u0433\\u043E: \", /* @__PURE__ */ React.createElement(\"b\", { className: \"text-slate-800\" }, fmtShort(totalR))), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex-1\" }), /* @__PURE__ */ React.createElement(Btn, { kind: \"green\", onClick: () => open() }, \"+ \\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-3\" }, rows.map((r) => /* @__PURE__ */ React.createElement(\"div\", { key: r.id, className: `bg-white rounded-xl shadow-sm border border-slate-100 p-4 ${r.active ? \"\" : \"opacity-50\"}` }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-between items-start\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"font-semibold text-slate-800\" }, r.name), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex gap-1\" }, /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => open(r) }, \"\\u270E\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"danger\", onClick: () => del(r.id) }, \"\\u{1F5D1}\"))), /* @__PURE__ */ React.createElement(\"div\", { className: \"mt-2 text-sm text-slate-600\" }, \"\\u041F\\u043B\\u0430\\u0442\\u0451\\u0436: \", /* @__PURE__ */ React.createElement(\"b\", null, fmt(r.monthly_payment)), \" / \\u043C\\u0435\\u0441\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm text-slate-600\" }, \"\\u041E\\u0441\\u0442\\u0430\\u043B\\u043E\\u0441\\u044C: \", /* @__PURE__ */ React.createElement(\"b\", null, fmt(r.remaining))), r.comment && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-400 mt-1\" }, r.comment))), !rows.length && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-slate-400 text-sm p-6\" }, \"\\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\\u043E\\u0432 \\u043D\\u0435\\u0442\")), modal && /* @__PURE__ */ React.createElement(Modal, { title: f.id ? \"\\u0420\\u0435\\u0434\\u0430\\u043A\\u0442\\u0438\\u0440\\u043E\\u0432\\u0430\\u0442\\u044C \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\" : \"\\u041D\\u043E\\u0432\\u044B\\u0439 \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\", onClose: () => setModal(false) }, /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"col-span-2\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.name, onChange: set(\"name\") }))), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041F\\u043B\\u0430\\u0442\\u0451\\u0436 \\u0432 \\u043C\\u0435\\u0441\\u044F\\u0446\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.monthly_payment, onChange: set(\"monthly_payment\") })), /* @__PURE__ */ React.createElement(Field, { label: \"\\u041E\\u0441\\u0442\\u0430\\u043B\\u043E\\u0441\\u044C \\u0432\\u044B\\u043F\\u043B\\u0430\\u0442\\u0438\\u0442\\u044C\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"number\", value: f.remaining, onChange: set(\"remaining\") })), /* @__PURE__ */ React.createElement(\"div\", { className: \"col-span-2\" }, /* @__PURE__ */ React.createElement(Field, { label: \"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, value: f.comment || \"\", onChange: set(\"comment\") }))), f.id ? /* @__PURE__ */ React.createElement(Field, { label: \"\\u0410\\u043A\\u0442\\u0438\\u0432\\u0435\\u043D\" }, /* @__PURE__ */ React.createElement(\"select\", { className: inputCls, value: f.active ? \"1\" : \"0\", onChange: (e) => setF({ ...f, active: e.target.value === \"1\" ? 1 : 0 }) }, /* @__PURE__ */ React.createElement(\"option\", { value: \"1\" }, \"\\u0414\\u0430\"), /* @__PURE__ */ React.createElement(\"option\", { value: \"0\" }, \"\\u041D\\u0435\\u0442 (\\u0437\\u0430\\u043A\\u0440\\u044B\\u0442)\"))) : null), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex justify-end gap-2 mt-5\" }, /* @__PURE__ */ React.createElement(Btn, { kind: \"ghost\", onClick: () => setModal(false) }, \"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"), /* @__PURE__ */ React.createElement(Btn, { onClick: save }, \"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\"))));\n}\nfunction Plans({ bump }) {\n const [year, setYear] = useState((/* @__PURE__ */ new Date()).getFullYear());\n const [plans, setPlans] = useState([]);\n const [ops, setOps] = useState([]);\n const [edit, setEdit] = useState({});\n const load = () => {\n api(\"/plans\").then(setPlans).catch(() => {\n });\n api(\"/operations\").then(setOps).catch(() => {\n });\n };\n useEffect(() => {\n load();\n }, []);\n const planFor = (p) => plans.find((x) => x.period === p);\n const factFor = (p) => ops.filter((o) => o.type === \"income\" && o.status === \"fact\" && o.date?.startsWith(p)).reduce((s, o) => s + o.amount, 0);\n const save = async (period) => {\n const e = edit[period] || {};\n const cur = planFor(period) || {};\n await api(`/plans/${period}`, \"PUT\", {\n revenue_plan: e.revenue_plan ?? cur.revenue_plan ?? 0,\n deals_plan: e.deals_plan ?? cur.deals_plan ?? 0\n });\n setEdit((s) => ({ ...s, [period]: void 0 }));\n load();\n bump();\n };\n const row = (period, label) => {\n const p = planFor(period);\n const e = edit[period];\n const fact = factFor(period);\n const plan = e?.revenue_plan ?? p?.revenue_plan ?? \"\";\n const dealsPlan = e?.deals_plan ?? p?.deals_plan ?? \"\";\n const pct = p?.revenue_plan > 0 ? Math.round(fact / p.revenue_plan * 100) : null;\n return /* @__PURE__ */ React.createElement(\"tr\", { key: period, className: \"border-b border-slate-50\" }, /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2 font-medium text-slate-700\" }, label), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2\" }, /* @__PURE__ */ React.createElement(\n \"input\",\n {\n className: inputCls + \" max-w-[140px]\",\n type: \"number\",\n placeholder: \"0\",\n value: plan,\n onChange: (ev) => setEdit((s) => ({ ...s, [period]: { ...s[period], revenue_plan: ev.target.value } }))\n }\n )), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2\" }, /* @__PURE__ */ React.createElement(\n \"input\",\n {\n className: inputCls + \" max-w-[90px]\",\n type: \"number\",\n placeholder: \"0\",\n value: dealsPlan,\n onChange: (ev) => setEdit((s) => ({ ...s, [period]: { ...s[period], deals_plan: ev.target.value } }))\n }\n )), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2 text-slate-600\" }, fmtShort(fact)), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2\" }, pct === null ? /* @__PURE__ */ React.createElement(\"span\", { className: \"text-slate-300\" }, \"\\u2014\") : /* @__PURE__ */ React.createElement(\"span\", { className: pct >= 100 ? \"text-emerald-600 font-semibold\" : pct >= 60 ? \"text-sky-600\" : \"text-amber-600\" }, pct, \"%\")), /* @__PURE__ */ React.createElement(\"td\", { className: \"px-3 py-2 text-right\" }, e && /* @__PURE__ */ React.createElement(Btn, { small: true, onClick: () => save(period) }, \"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\")));\n };\n return /* @__PURE__ */ React.createElement(\"div\", null, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex items-center gap-2 mb-3\" }, /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setYear(year - 1) }, \"\\u2190\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"font-semibold text-slate-800\" }, year, \" \\u0433\\u043E\\u0434\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => setYear(year + 1) }, \"\\u2192\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-400 ml-3\" }, \"\\u041F\\u043B\\u0430\\u043D \\u0432\\u044B\\u0440\\u0443\\u0447\\u043A\\u0438 \\u0437\\u0430\\u0434\\u0430\\u0451\\u0442\\u0441\\u044F \\u0437\\u0430\\u0440\\u0430\\u043D\\u0435\\u0435 \\u2014 \\u0434\\u0430\\u0448\\u0431\\u043E\\u0440\\u0434 \\u043F\\u043E\\u043A\\u0430\\u0436\\u0435\\u0442, \\u043A\\u0430\\u043A \\u0438\\u0434\\u0451\\u043C\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"bg-white rounded-xl shadow-sm border border-slate-100 overflow-x-auto\" }, /* @__PURE__ */ React.createElement(\"table\", { className: \"w-full text-sm min-w-[640px]\" }, /* @__PURE__ */ React.createElement(\"thead\", null, /* @__PURE__ */ React.createElement(\"tr\", { className: \"text-left text-xs text-slate-400 border-b border-slate-100\" }, [\"\\u041F\\u0435\\u0440\\u0438\\u043E\\u0434\", \"\\u041F\\u043B\\u0430\\u043D \\u0432\\u044B\\u0440\\u0443\\u0447\\u043A\\u0438, \\u20BD\", \"\\u041F\\u043B\\u0430\\u043D \\u0441\\u0434\\u0435\\u043B\\u043E\\u043A, \\u0448\\u0442\", \"\\u0424\\u0430\\u043A\\u0442 \\u0432\\u044B\\u0440\\u0443\\u0447\\u043A\\u0438\", \"\\u0412\\u044B\\u043F\\u043E\\u043B\\u043D\\u0435\\u043D\\u0438\\u0435\", \"\"].map((h) => /* @__PURE__ */ React.createElement(\"th\", { key: h, className: \"px-3 py-2.5 font-medium\" }, h)))), /* @__PURE__ */ React.createElement(\"tbody\", null, row(String(year), `\\u0412\\u0435\\u0441\\u044C ${year} \\u0433\\u043E\\u0434`), MONTHS.map((mn, i) => row(`${year}-${String(i + 1).padStart(2, \"0\")}`, mn))))));\n}\nfunction Settings({ onClose, onLogout, bump }) {\n const [oldPin, setOld] = useState(\"\");\n const [newPin, setNew] = useState(\"\");\n const [msg, setMsg] = useState(\"\");\n const changePin = async () => {\n const r = await api(\"/settings/pin\", \"POST\", { oldPin, newPin });\n if (r.ok) {\n setPinLS(newPin);\n setMsg(\"PIN \\u0438\\u0437\\u043C\\u0435\\u043D\\u0451\\u043D \\u2713\");\n } else setMsg(r.error || \"\\u041E\\u0448\\u0438\\u0431\\u043A\\u0430\");\n };\n const demo = async (action) => {\n if (action === \"clear\" && !confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C \\u0412\\u0421\\u0415 \\u0434\\u0430\\u043D\\u043D\\u044B\\u0435 \\u0441\\u0438\\u0441\\u0442\\u0435\\u043C\\u044B?\")) return;\n await api(\"/demo\", \"POST\", { action });\n setMsg(action === \"clear\" ? \"\\u0414\\u0430\\u043D\\u043D\\u044B\\u0435 \\u043E\\u0447\\u0438\\u0449\\u0435\\u043D\\u044B\" : \"\\u0414\\u0435\\u043C\\u043E-\\u0434\\u0430\\u043D\\u043D\\u044B\\u0435 \\u0437\\u0430\\u0433\\u0440\\u0443\\u0436\\u0435\\u043D\\u044B\");\n bump();\n };\n return /* @__PURE__ */ React.createElement(Modal, { title: \"\\u041D\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u043A\\u0438\", onClose }, /* @__PURE__ */ React.createElement(\"div\", { className: \"space-y-4\" }, /* @__PURE__ */ React.createElement(\"div\", null, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm font-semibold text-slate-700 mb-2\" }, \"\\u0421\\u043C\\u0435\\u043D\\u0438\\u0442\\u044C PIN\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"grid grid-cols-2 gap-3\" }, /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"password\", placeholder: \"\\u0422\\u0435\\u043A\\u0443\\u0449\\u0438\\u0439 PIN\", value: oldPin, onChange: (e) => setOld(e.target.value) }), /* @__PURE__ */ React.createElement(\"input\", { className: inputCls, type: \"password\", placeholder: \"\\u041D\\u043E\\u0432\\u044B\\u0439 PIN (4\\u20138 \\u0446\\u0438\\u0444\\u0440)\", value: newPin, onChange: (e) => setNew(e.target.value) })), /* @__PURE__ */ React.createElement(\"div\", { className: \"mt-2\" }, /* @__PURE__ */ React.createElement(Btn, { small: true, onClick: changePin }, \"\\u0418\\u0437\\u043C\\u0435\\u043D\\u0438\\u0442\\u044C PIN\"))), /* @__PURE__ */ React.createElement(\"div\", { className: \"border-t border-slate-100 pt-4\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm font-semibold text-slate-700 mb-2\" }, \"\\u0414\\u0430\\u043D\\u043D\\u044B\\u0435\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex gap-2\" }, /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: () => demo(\"load\") }, \"\\u0417\\u0430\\u0433\\u0440\\u0443\\u0437\\u0438\\u0442\\u044C \\u0434\\u0435\\u043C\\u043E-\\u0434\\u0430\\u043D\\u043D\\u044B\\u0435\"), /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"danger\", onClick: () => demo(\"clear\") }, \"\\u041E\\u0447\\u0438\\u0441\\u0442\\u0438\\u0442\\u044C \\u0432\\u0441\\u0451\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"text-xs text-slate-400 mt-2\" }, \"\\u0414\\u0435\\u043C\\u043E-\\u0434\\u0430\\u043D\\u043D\\u044B\\u0435 \\u043F\\u043E\\u043C\\u043E\\u0433\\u0430\\u044E\\u0442 \\u043F\\u043E\\u0441\\u043C\\u043E\\u0442\\u0440\\u0435\\u0442\\u044C, \\u043A\\u0430\\u043A \\u0432\\u044B\\u0433\\u043B\\u044F\\u0434\\u0438\\u0442 \\u0441\\u0438\\u0441\\u0442\\u0435\\u043C\\u0430 \\u0441 \\u0446\\u0438\\u0444\\u0440\\u0430\\u043C\\u0438. \\u041F\\u0435\\u0440\\u0435\\u0434 \\u0440\\u0435\\u0430\\u043B\\u044C\\u043D\\u043E\\u0439 \\u0440\\u0430\\u0431\\u043E\\u0442\\u043E\\u0439 \\u2014 \\xAB\\u041E\\u0447\\u0438\\u0441\\u0442\\u0438\\u0442\\u044C \\u0432\\u0441\\u0451\\xBB.\")), /* @__PURE__ */ React.createElement(\"div\", { className: \"border-t border-slate-100 pt-4 flex justify-between items-center\" }, /* @__PURE__ */ React.createElement(Btn, { small: true, kind: \"ghost\", onClick: onLogout }, \"\\u0412\\u044B\\u0439\\u0442\\u0438\"), /* @__PURE__ */ React.createElement(\"a\", { href: \"/source\", className: \"text-xs text-slate-300 hover:text-slate-400\" }, \"view source\")), msg && /* @__PURE__ */ React.createElement(\"div\", { className: \"text-sm text-sky-600\" }, msg)));\n}\nconst TABS = [[\"dash\", \"\\u0414\\u0430\\u0448\\u0431\\u043E\\u0440\\u0434\"], [\"deals\", \"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\"], [\"money\", \"\\u0414\\u0435\\u043D\\u044C\\u0433\\u0438\"], [\"credits\", \"\\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B\"], [\"plans\", \"\\u041F\\u043B\\u0430\\u043D\\u044B\"]];\nfunction App() {\n const [authed, setAuthed] = useState(!!getPin());\n const [tab, setTab] = useState(\"dash\");\n const [month, setMonth] = useState(thisMonth());\n const [refresh, setRefresh] = useState(0);\n const [settings, setSettings] = useState(false);\n const bump = () => setRefresh((x) => x + 1);\n onUnauthorized = () => {\n setPinLS(\"\");\n setAuthed(false);\n };\n if (!authed) return /* @__PURE__ */ React.createElement(Login, { onOk: () => setAuthed(true) });\n return /* @__PURE__ */ React.createElement(\"div\", { className: \"max-w-6xl mx-auto px-3 py-4\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"flex flex-wrap items-center gap-2 mb-4\" }, /* @__PURE__ */ React.createElement(\"div\", { className: \"font-bold text-lg text-slate-900 mr-2\" }, \"\\u{1F4B0} U.fin\"), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex gap-1 bg-white rounded-full p-1 border border-slate-200 flex-wrap\" }, TABS.map(([k, l]) => /* @__PURE__ */ React.createElement(\n \"button\",\n {\n key: k,\n onClick: () => setTab(k),\n className: `px-3.5 py-1.5 rounded-full text-sm font-medium transition ${tab === k ? \"bg-slate-900 text-white\" : \"text-slate-600 hover:bg-slate-100\"}`\n },\n l\n ))), /* @__PURE__ */ React.createElement(\"div\", { className: \"flex-1\" }), (tab === \"dash\" || tab === \"money\") && /* @__PURE__ */ React.createElement(\n \"input\",\n {\n type: \"month\",\n className: \"border border-slate-200 rounded-lg px-2 py-1.5 text-sm bg-white\",\n value: month,\n onChange: (e) => setMonth(e.target.value || thisMonth())\n }\n ), /* @__PURE__ */ React.createElement(\"button\", { onClick: () => setSettings(true), className: \"text-slate-400 hover:text-slate-600 text-lg px-1\" }, \"\\u2699\\uFE0F\")), tab === \"dash\" && /* @__PURE__ */ React.createElement(Dashboard, { month, refresh }), tab === \"deals\" && /* @__PURE__ */ React.createElement(Deals, { refresh, bump }), tab === \"money\" && /* @__PURE__ */ React.createElement(Money, { month, refresh, bump }), tab === \"credits\" && /* @__PURE__ */ React.createElement(Credits, { bump }), tab === \"plans\" && /* @__PURE__ */ React.createElement(Plans, { bump }), settings && /* @__PURE__ */ React.createElement(\n Settings,\n {\n onClose: () => setSettings(false),\n bump,\n onLogout: () => {\n setPinLS(\"\");\n setAuthed(false);\n setSettings(false);\n }\n }\n ));\n}\ncreateRoot(document.getElementById(\"root\")).render(/* @__PURE__ */ React.createElement(App, null));\n",[],[140,182],["D",1787239156729],[157,158,159],[140],["D",1787239139778],["D",1789499469860],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_127":230,"_231":232,"_233":234,"_235":25,"_236":25,"_237":25,"_238":58,"_239":-5,"_240":-7,"_241":-7,"_242":62,"_243":25,"_244":25,"_245":-5,"_246":25,"_247":25,"_248":25,"_249":-5},"ENV",{"_201":202,"_203":204,"_205":89,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v6