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

[{"_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",11,"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","aded32d8-9d5a-11f1-8da2-1607ee4eb77e","name","fileType","http","content","// U.fin v2 — финансовая система агентства недвижимости Unlock.\n// Спроектирована с нуля под логику агентства: сделки с задатками, брокеры,\n// застройщики, план месяц/год. Финансовое ядро: счета, операции, статьи с классами.\n// Backend: Hono + SQLite (val-scoped). Вход по PIN.\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile, 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));\nconst rows = (r: any) => r.rows as any[][];\n\n// ---------------- Схема ----------------\nawait sqlite.batch([\n `CREATE TABLE IF NOT EXISTS uf_settings (key TEXT PRIMARY KEY, value TEXT)`,\n `CREATE TABLE IF NOT EXISTS uf_accounts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n acc_type TEXT DEFAULT 'Безналичный',\n bank 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 uf_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n kind TEXT NOT NULL, -- income | expense\n cls TEXT DEFAULT 'pl', -- pl | assets | liabilities | capital (не-pl не попадает в прибыль)\n parent_id INTEGER,\n sort INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS uf_contractors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n role TEXT DEFAULT 'other', -- developer | broker | client | bank | staff | other\n inn TEXT DEFAULT '',\n phone TEXT DEFAULT '',\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n grp TEXT DEFAULT '',\n status TEXT DEFAULT 'work',\n date_start TEXT, date_end TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS uf_deals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n client TEXT DEFAULT '',\n object_name TEXT DEFAULT '', -- ЖК / объект\n developer_id INTEGER, -- застройщик (контрагент)\n broker_id INTEGER, -- брокер (контрагент)\n status TEXT DEFAULT 'deposit', -- deposit | booked | deal | paid | failed\n price REAL DEFAULT 0, -- стоимость объекта\n commission REAL DEFAULT 0, -- комиссия агентства (наш доход)\n broker_fee REAL DEFAULT 0, -- вознаграждение брокера\n deposit_amount REAL DEFAULT 0, -- задаток\n d_deposit TEXT, d_booked TEXT, d_deal TEXT, d_closed TEXT,\n created_at TEXT,\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_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,\n amount REAL NOT NULL,\n account_id INTEGER,\n account2_id INTEGER,\n category_id INTEGER,\n contractor_id INTEGER,\n deal_id INTEGER,\n project_id INTEGER,\n purpose TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_plans (\n period TEXT PRIMARY KEY, -- YYYY-MM\n income REAL DEFAULT 0,\n expense REAL DEFAULT 0,\n deals INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS uf_deal_notes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n deal_id INTEGER NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT\n )`,\n `CREATE INDEX IF NOT EXISTS uf_ops_date ON uf_ops(date)`,\n `CREATE INDEX IF NOT EXISTS uf_ops_deal ON uf_ops(deal_id)`,\n]);\n// fin_type: пометка статей финансирования (не доход и не расход)\n// own — вложения учредителей собственными деньгами\n// debt — привлечение кредитов/займов/овердрафта\n// repay — погашение кредитов/займов/овердрафта и возврат вложений\ntry { await sqlite.execute(`ALTER TABLE uf_categories ADD COLUMN fin_type TEXT DEFAULT ''`); } catch (_e) { /* есть */ }\n\nasync function setting(key: string, def = \"\"): Promise {\n const r = await sqlite.execute({ sql: `SELECT value FROM uf_settings WHERE key=?`, args: [key] });\n return rows(r).length ? String(rows(r)[0][0]) : def;\n}\nasync function setSetting(key: string, value: string) {\n await sqlite.execute({ sql: `INSERT INTO uf_settings(key,value) VALUES(?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value`, args: [key, value] });\n}\nif (!(await setting(\"pin\"))) await setSetting(\"pin\", \"1111\");\nif (!(await setting(\"company\"))) await setSetting(\"company\", \"Unlock\");\n\n// ---------------- Auth ----------------\napp.post(\"/api/login\", async (c) => {\n const b = await c.req.json();\n const pin = await setting(\"pin\", \"1111\");\n return c.json({ ok: String(b.pin) === pin });\n});\napp.use(\"/api/*\", async (c, next) => {\n if (c.req.path === \"/api/login\") return next();\n const pin = await setting(\"pin\", \"1111\");\n if (c.req.header(\"x-pin\") !== pin) return c.json({ error: \"unauthorized\" }, 401);\n await next();\n});\n\n// Класс-фильтр: только pl-статьи попадают в доходы/расходы (прибыль).\nconst PL = `COALESCE(cat.cls,'pl')='pl' AND COALESCE(cat.fin_type,'')=''`;\n// Финансирование: вложения учредителей, кредиты, займы, овердрафт и их погашение.\n// Это движение капитала, а не выручка и не расход — в доходной части не участвует.\nconst FIN = `COALESCE(cat.fin_type,'')<>''`;\nconst NOT_FIN = `COALESCE(cat.fin_type,'')=''`;\n\n// ---------------- Реклассификация: кредиты → финансирование ----------------\napp.post(\"/api/admin/reclass-financing\", async (c) => {\n const log: string[] = [];\n const one = async (sql: string, args: any[] = []) => {\n const r = await sqlite.execute({ sql, args });\n return rows(r).length ? rows(r)[0] : null;\n };\n const catId = async (name: string, kind: string) => {\n const r = await one(`SELECT id FROM uf_categories WHERE TRIM(name)=? AND kind=? LIMIT 1`, [name, kind]);\n return r ? Number(r[0]) : null;\n };\n const ensure = async (name: string, kind: string, cls: string, fin: string, parent: number | null) => {\n let id = await catId(name, kind);\n if (!id) {\n await sqlite.execute({\n sql: `INSERT INTO uf_categories(name,kind,cls,fin_type,parent_id) VALUES(?,?,?,?,?)`,\n args: [name, kind, cls, fin, parent],\n });\n id = await catId(name, kind);\n log.push(`создана статья «${name}»`);\n } else {\n await sqlite.execute({\n sql: `UPDATE uf_categories SET cls=?, fin_type=?, parent_id=? WHERE id=?`,\n args: [cls, fin, parent, id],\n });\n }\n return id!;\n };\n // корни\n const rootIn = await ensure(\"Вложения учредителей\", \"income\", \"capital\", \"own\", null);\n const rootOut = await ensure(\"Возврат финансирования\", \"expense\", \"capital\", \"repay\", null);\n // приток: собственные средства учредителей — отдельная подстатья, туда уходят старые операции корня\n const own = await ensure(\"Собственные средства учредителей\", \"income\", \"capital\", \"own\", rootIn);\n await sqlite.execute({ sql: `UPDATE uf_ops SET category_id=? WHERE category_id=?`, args: [own, rootIn] });\n\n // переносим существующие кредитные статьи под нужный корень, сохраняя детализацию\n const MAP: [string, string, string, string, number][] = [\n // старое имя, kind, новое имя, fin_type, parent\n [\"Овердрафт\", \"income\", \"Кредитные средства (овердрафт)\", \"debt\", rootIn],\n [\"Полученные займы (до 1 года)\", \"income\", \"Заёмные средства (до 1 года)\", \"debt\", rootIn],\n [\"Полученные займы (от 1 года)\", \"income\", \"Заёмные средства (от 1 года)\", \"debt\", rootIn],\n [\"Кредиты\", \"income\", \"Кредитные средства (кредиты)\", \"debt\", rootIn],\n [\"Овердрафт\", \"expense\", \"Погашение овердрафта\", \"repay\", rootOut],\n [\"Полученные займы (до 1 года)\", \"expense\", \"Возврат займов (до 1 года)\", \"repay\", rootOut],\n [\"Полученные займы (от 1 года)\", \"expense\", \"Возврат займов (от 1 года)\", \"repay\", rootOut],\n [\"Кредиты\", \"expense\", \"Погашение кредитов\", \"repay\", rootOut],\n [\"Кредиты и овердрафт\", \"expense\", \"Погашение кредитов и овердрафта\", \"repay\", rootOut],\n ];\n for (const [oldName, kind, newName, fin, parent] of MAP) {\n const id = await catId(oldName, kind);\n if (!id) continue;\n const cnt = await one(`SELECT COUNT(*) FROM uf_ops WHERE category_id=?`, [id]);\n // если статья с новым именем уже есть — сливаем операции в неё\n const exist = await catId(newName, kind);\n if (exist && exist !== id) {\n await sqlite.execute({ sql: `UPDATE uf_ops SET category_id=? WHERE category_id=?`, args: [exist, id] });\n await sqlite.execute({ sql: `DELETE FROM uf_categories WHERE id=?`, args: [id] });\n } else {\n await sqlite.execute({\n sql: `UPDATE uf_categories SET name=?, cls='capital', fin_type=?, parent_id=? WHERE id=?`,\n args: [newName, fin, parent, id],\n });\n }\n log.push(`${oldName} (${kind}) → ${newName}: ${cnt ? Number(cnt[0]) : 0} операций`);\n }\n // подчищаем: статьи без операций и без детей, оставшиеся после слияния\n await sqlite.execute(\n `DELETE FROM uf_categories WHERE fin_type<>'' AND id NOT IN (SELECT DISTINCT COALESCE(category_id,-1) FROM uf_ops)\n AND id NOT IN (SELECT DISTINCT COALESCE(parent_id,-1) FROM uf_categories)`,\n );\n const tot = await one(\n `SELECT SUM(CASE WHEN o.op_type='income' THEN o.amount ELSE 0 END), SUM(CASE WHEN o.op_type='expense' THEN o.amount ELSE 0 END)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id WHERE ${FIN}`,\n );\n return c.json({ ok: true, log, financing_in: num(tot?.[0]), financing_out: num(tot?.[1]) });\n});\n\n// ---------------- Загрузка сырых данных старой системы (pf_*) ----------------\napp.post(\"/api/admin/load\", async (c) => {\n const b = await c.req.json();\n const table = String(b.table || \"\");\n if (!/^pf_[a-z_]+$/.test(table)) return c.json({ error: \"bad table\" }, 400);\n const cols: string[] = (b.columns || []).filter((x: string) => /^[a-z0-9_]+$/i.test(x));\n if (!cols.length) return c.json({ error: \"no columns\" }, 400);\n if (b.reset) {\n await sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\n await sqlite.execute(`CREATE TABLE ${table} (${cols.join(\",\")})`);\n }\n const rws: any[][] = b.rows || [];\n if (rws.length) {\n const lit = (v: any) =>\n v === null || v === undefined\n ? \"NULL\"\n : typeof v === \"number\"\n ? String(v)\n : \"'\" + String(v).replace(/'/g, \"''\") + \"'\";\n // вставка литералами по 50 строк на statement (обходим баг биндинга параметров)\n const stmts: string[] = [];\n for (let i = 0; i < rws.length; i += 50) {\n const chunk = rws.slice(i, i + 50);\n stmts.push(`INSERT INTO ${table}(${cols.join(\",\")}) VALUES ` + chunk.map((r) => `(${r.map(lit).join(\",\")})`).join(\",\"));\n }\n await sqlite.batch(stmts);\n }\n return c.json({ ok: true, inserted: rws.length });\n});\n\n// ---------------- Миграция из старой базы (pf_*) ----------------\napp.post(\"/api/admin/migrate\", async (c) => {\n const log: string[] = [];\n const t = (await sqlite.execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name LIKE 'pf_%'`,\n )).rows.map((r: any) => String(r[0]));\n if (!t.includes(\"pf_ops\")) return c.json({ error: \"старые таблицы pf_* не найдены\" }, 400);\n\n // чистим целевые таблицы (идемпотентно)\n for (const tbl of [\"uf_ops\", \"uf_deals\", \"uf_contractors\", \"uf_accounts\", \"uf_categories\", \"uf_projects\", \"uf_plans\", \"uf_deal_notes\"]) {\n await sqlite.execute(`DELETE FROM ${tbl}`);\n }\n\n // Счета (id сохраняем)\n await sqlite.execute(`INSERT INTO uf_accounts(id,name,acc_type,bank,grp,start_balance,start_date,active)\n SELECT id,TRIM(name),acc_type,bank,grp,start_balance,start_date,active FROM pf_accounts`);\n log.push(`accounts: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_accounts`)).rows[0][0])}`);\n\n // Статьи: cat_class → cls ('' | income | outcome → pl)\n await sqlite.execute(`INSERT INTO uf_categories(id,name,kind,cls,parent_id,sort)\n SELECT id,TRIM(name),kind,\n CASE LOWER(COALESCE(cat_class,'')) WHEN 'assets' THEN 'assets' WHEN 'liabilities' THEN 'liabilities' WHEN 'capital' THEN 'capital' ELSE 'pl' END,\n parent_id,sort FROM pf_categories`);\n log.push(`categories: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_categories`)).rows[0][0])}`);\n\n // Контрагенты: роль эвристикой по группе/имени; уточняется вручную в справочнике\n await sqlite.execute(`INSERT INTO uf_contractors(id,name,role,inn,comment)\n SELECT id,TRIM(name),\n CASE\n WHEN LOWER(COALESCE(grp,'')) LIKE '%застройщик%' OR LOWER(name) LIKE '%застройщик%' OR LOWER(name) LIKE '%сз %' OR LOWER(name) LIKE '%сз«%' OR LOWER(name) LIKE '%спецзастройщик%' THEN 'developer'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%брокер%' OR LOWER(name) LIKE '%брокер%' THEN 'broker'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%банк%' OR LOWER(name) LIKE '%банк%' THEN 'bank'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%сотрудник%' THEN 'staff'\n ELSE 'other'\n END, inn, COALESCE(comment,'') FROM pf_contractors`);\n log.push(`contractors: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_contractors`)).rows[0][0])}`);\n\n // Проекты\n await sqlite.execute(`INSERT INTO uf_projects(id,name,grp,status,date_start,date_end)\n SELECT id,TRIM(name),COALESCE(grp,''),COALESCE(status,'work'),date_start,date_end FROM pf_projects`);\n log.push(`projects: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_projects`)).rows[0][0])}`);\n\n // Сделки: статусы done→paid, fail→failed, work/nuance→deal; комиссия = amount\n await sqlite.execute(`INSERT INTO uf_deals(id,name,client,status,commission,d_deal,d_closed,created_at,comment)\n SELECT id,TRIM(name),COALESCE(client,''),\n CASE status WHEN 'done' THEN 'paid' WHEN 'fail' THEN 'failed' ELSE 'deal' END,\n amount,\n created_at,\n CASE WHEN status IN ('done','fail') THEN created_at ELSE NULL END,\n created_at,COALESCE(comment,'') FROM pf_deals`);\n log.push(`deals: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_deals`)).rows[0][0])}`);\n\n // Привязка брокера к сделке по имени сделки = имени контрагента-брокера (если совпало)\n await sqlite.execute(`UPDATE uf_deals SET broker_id=(SELECT c.id FROM uf_contractors c WHERE TRIM(c.name)=TRIM(uf_deals.name) LIMIT 1)`);\n\n // Операции (id и все связи сохраняем)\n await sqlite.execute(`INSERT INTO uf_ops(id,date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,purpose)\n SELECT id,date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,COALESCE(purpose,'') FROM pf_ops`);\n log.push(`ops: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_ops`)).rows[0][0])}`);\n\n // Планы: из БДР-бюджетов (сумма по всем бюджетам за период)\n if (t.includes(\"pf_budget_values\")) {\n await sqlite.execute(`INSERT INTO uf_plans(period,income,expense,deals)\n SELECT period,\n SUM(CASE WHEN row_key LIKE 'inc_%' OR row_key='oi' THEN amount ELSE 0 END),\n SUM(CASE WHEN row_key IN ('var','fix','oe','dep','int','tax') THEN amount ELSE 0 END),\n 0\n FROM pf_budget_values GROUP BY period`);\n log.push(`plans: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_plans`)).rows[0][0])}`);\n }\n\n // Роль developer контрагентам, платившим нам по сделкам (доход, привязанный к сделке)\n await sqlite.execute(`UPDATE uf_contractors SET role='developer' WHERE role='other' AND id IN (\n SELECT DISTINCT o.contractor_id FROM uf_ops o WHERE o.op_type='income' AND o.deal_id IS NOT NULL AND o.contractor_id IS NOT NULL)`);\n\n return c.json({ ok: true, log });\n});\n\n// ---------------- Meta ----------------\napp.get(\"/api/meta\", async (c) => {\n const [acc, cats, contr, proj] = await Promise.all([\n sqlite.execute(`SELECT id,name,acc_type,bank,grp,start_balance,start_date,active FROM uf_accounts ORDER BY name`),\n sqlite.execute(`SELECT id,name,kind,cls,parent_id,sort,COALESCE(fin_type,'') FROM uf_categories ORDER BY kind,sort,name`),\n sqlite.execute(`SELECT id,name,role,inn,phone,comment FROM uf_contractors ORDER BY name`),\n sqlite.execute(`SELECT id,name,grp,status,date_start,date_end FROM uf_projects ORDER BY name`),\n ]);\n // балансы по счетам\n const bal = await sqlite.execute(`\n SELECT a.id, a.start_balance\n + COALESCE((SELECT SUM(CASE o.op_type WHEN 'income' THEN o.amount WHEN 'expense' THEN -o.amount\n WHEN 'transfer' THEN CASE WHEN o.account_id=a.id THEN -o.amount ELSE 0 END END)\n FROM uf_ops o WHERE o.confirmed=1 AND (o.account_id=a.id OR (o.op_type='transfer' AND o.account2_id=a.id))),0)\n + COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.confirmed=1 AND o.op_type='transfer' AND o.account2_id=a.id),0)\n FROM uf_accounts a`);\n const balMap: Record = {};\n for (const r of rows(bal)) balMap[String(r[0])] = num(r[1]);\n const company = await setting(\"company\", \"Unlock\");\n return c.json({\n company,\n accounts: rows(acc).map((r) => ({ id: r[0], name: r[1], acc_type: r[2], bank: r[3], grp: r[4], start_balance: num(r[5]), start_date: r[6], active: num(r[7]), balance: balMap[String(r[0])] ?? num(r[5]) })),\n categories: rows(cats).map((r) => ({ id: r[0], name: r[1], kind: r[2], cls: r[3], parent_id: r[4], sort: num(r[5]), fin_type: r[6] })),\n contractors: rows(contr).map((r) => ({ id: r[0], name: r[1], role: r[2], inn: r[3], phone: r[4], comment: r[5] })),\n projects: rows(proj).map((r) => ({ id: r[0], name: r[1], grp: r[2], status: r[3], date_start: r[4], date_end: r[5] })),\n });\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\n // помесячные факт-суммы за 12 месяцев года (только pl-классы)\n const months = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE substr(o.date,1,4)=? GROUP BY m ORDER BY m`,\n args: [year],\n });\n const byM: Record = {};\n for (const r of rows(months)) byM[String(r[0])] = { income: num(r[1]), expense: num(r[2]) };\n\n const mi = byM[month]?.income || 0, me = byM[month]?.expense || 0;\n let yi = 0, ye = 0;\n for (const k in byM) { yi += byM[k].income; ye += byM[k].expense; }\n\n // на заходе: незакрытые сделки, комиссия минус уже полученное\n const pipe = await sqlite.execute(`\n SELECT COALESCE(SUM(d.commission - COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='income' AND o.confirmed=1),0)),0),\n COUNT(*)\n FROM uf_deals d WHERE d.status IN ('deposit','booked','deal')`);\n const pipeline = Math.max(0, num(rows(pipe)[0][0])), pipeCount = num(rows(pipe)[0][1]);\n\n // от застройщиков за месяц: доход по сделкам или от контрагентов-застройщиков\n const dev = await sqlite.execute({\n sql: `SELECT COALESCE(SUM(o.amount),0) FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n WHERE o.op_type='income' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7)=?\n AND (o.deal_id IS NOT NULL OR ct.role='developer')`,\n args: [month],\n });\n // брокерам за месяц: расход контрагентам-брокерам или по статье с «брокер»\n const brok = await sqlite.execute({\n sql: `SELECT COALESCE(SUM(o.amount),0) FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n WHERE o.op_type='expense' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7)=?\n AND (ct.role='broker' OR COALESCE(cat.name,'') LIKE '%рокер%' OR o.deal_id IS NOT NULL)`,\n args: [month],\n });\n\n // средний чек: средняя комиссия сделок, прошедших в месяце\n const avgCheck = await sqlite.execute({\n sql: `SELECT COALESCE(AVG(commission),0), COUNT(*) FROM uf_deals\n WHERE commission>0 AND status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,7)=?`,\n args: [month],\n });\n\n // воронка месяца\n const f = async (sql: string) => num(rows(await sqlite.execute({ sql, args: [month] }))[0][0]);\n const funnel = {\n deposits: await f(`SELECT COUNT(*) FROM uf_deals WHERE substr(COALESCE(d_deposit,created_at),1,7)=?`),\n booked: await f(`SELECT COUNT(*) FROM uf_deals WHERE d_booked IS NOT NULL AND substr(d_booked,1,7)=?`),\n deals: await f(`SELECT COUNT(*) FROM uf_deals WHERE status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,7)=?`),\n failed: await f(`SELECT COUNT(*) FROM uf_deals WHERE status='failed' AND substr(COALESCE(d_closed,created_at),1,7)=?`),\n };\n\n // кредиты/овердрафт: непогашенный долг = привлечено − погашено (по всей истории)\n const credit = await sqlite.execute(`\n SELECT COALESCE(SUM(CASE WHEN cat.fin_type='debt' THEN o.amount WHEN cat.fin_type='repay' THEN -o.amount ELSE 0 END),0)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id WHERE o.confirmed=1`);\n\n // финансирование за месяц и за год: вложения учредителей, привлечение и погашение кредитов\n const finRow = async (period: string, like: boolean) => {\n const r = await sqlite.execute({\n sql: `SELECT\n COALESCE(SUM(CASE WHEN cat.fin_type='own' AND o.op_type='income' THEN o.amount ELSE 0 END),0),\n COALESCE(SUM(CASE WHEN cat.fin_type='debt' THEN o.amount ELSE 0 END),0),\n COALESCE(SUM(CASE WHEN cat.fin_type='repay' THEN o.amount ELSE 0 END),0)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.confirmed=1 AND substr(o.date,1,${like ? 4 : 7})=?`,\n args: [period],\n });\n const x = rows(r)[0];\n return { own: num(x[0]), debt: num(x[1]), repay: num(x[2]) };\n };\n const finM = await finRow(month, false);\n const finY = await finRow(year, true);\n\n // средний расход/мес: по последним 6 завершённым месяцам с операциями\n const avgExp = await sqlite.execute({\n sql: `SELECT COALESCE(AVG(s),0) FROM (\n SELECT SUM(o.amount) s FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.op_type='expense' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7) = {};\n for (const r of rows(dealsByM)) dealsMap[String(r[0])] = num(r[1]);\n\n return c.json({\n month, year,\n month_income: mi, month_expense: me, month_np: mi - me,\n year_income: yi, year_expense: ye, year_np: yi - ye,\n months: byM,\n deals_by_month: dealsMap,\n pipeline, pipeline_count: pipeCount,\n from_developers: num(rows(dev)[0][0]),\n to_brokers: num(rows(brok)[0][0]),\n avg_check: num(rows(avgCheck)[0][0]), avg_check_count: num(rows(avgCheck)[0][1]),\n funnel,\n credit_debt: num(rows(credit)[0][0]),\n fin_month: finM, fin_year: finY,\n avg_expense: num(rows(avgExp)[0][0]),\n plan_month: pm ? { income: num(pm[0]), expense: num(pm[1]), deals: num(pm[2]) } : null,\n plan_year: { income: num(py[0]), expense: num(py[1]), deals: num(py[2]) },\n struct: rows(struct).map((r) => ({ name: r[0], value: num(r[1]) })),\n });\n});\n\n// ---------------- Операции ----------------\napp.get(\"/api/ops\", async (c) => {\n const q = c.req.query();\n const cond: string[] = []; const args: any[] = [];\n if (q.from) { cond.push(`o.date>=?`); args.push(q.from); }\n if (q.to) { cond.push(`o.date<=?`); args.push(q.to); }\n if (q.type) { cond.push(`o.op_type=?`); args.push(q.type); }\n if (q.account) { cond.push(`(o.account_id=? OR o.account2_id=?)`); args.push(q.account, q.account); }\n if (q.category) { cond.push(`o.category_id=?`); args.push(q.category); }\n if (q.contractor) { cond.push(`o.contractor_id=?`); args.push(q.contractor); }\n if (q.deal) { cond.push(`o.deal_id=?`); args.push(q.deal); }\n if (q.search) { cond.push(`(o.purpose LIKE ? OR ct.name LIKE ? OR cat.name LIKE ?)`); const s = `%${q.search}%`; args.push(s, s, s); }\n const where = cond.length ? `WHERE ` + cond.join(\" AND \") : \"\";\n const lim = Math.min(num(q.limit) || 100, 500), off = num(q.offset) || 0;\n const r = await sqlite.execute({\n sql: `SELECT o.id,o.date,o.op_type,o.confirmed,o.amount,o.account_id,o.account2_id,o.category_id,o.contractor_id,o.deal_id,o.project_id,o.purpose,\n a.name,a2.name,cat.name,ct.name,d.name\n FROM uf_ops o\n LEFT JOIN uf_accounts a ON a.id=o.account_id LEFT JOIN uf_accounts a2 ON a2.id=o.account2_id\n LEFT JOIN uf_categories cat ON cat.id=o.category_id LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n LEFT JOIN uf_deals d ON d.id=o.deal_id\n ${where} ORDER BY o.date DESC, o.id DESC LIMIT ${lim} OFFSET ${off}`,\n args,\n });\n const tot = await sqlite.execute({\n sql: `SELECT COUNT(*),\n COALESCE(SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${NOT_FIN} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${NOT_FIN} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${FIN} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${FIN} THEN o.amount END),0)\n FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n ${where}`,\n args,\n });\n return c.json({\n total: num(rows(tot)[0][0]), sum_income: num(rows(tot)[0][1]), sum_expense: num(rows(tot)[0][2]),\n sum_fin_in: num(rows(tot)[0][3]), sum_fin_out: num(rows(tot)[0][4]),\n items: rows(r).map((x) => ({\n id: x[0], date: x[1], op_type: x[2], confirmed: num(x[3]), amount: num(x[4]),\n account_id: x[5], account2_id: x[6], category_id: x[7], contractor_id: x[8], deal_id: x[9], project_id: x[10], purpose: x[11],\n account: x[12], account2: x[13], category: x[14], contractor: x[15], deal: x[16],\n })),\n });\n});\napp.post(\"/api/ops\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_ops(date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,purpose)\n VALUES(?,?,?,?,?,?,?,?,?,?,?)`,\n args: [b.date || today(), b.op_type, b.confirmed ? 1 : 0, num(b.amount), b.account_id || null, b.account2_id || null, b.category_id || null, b.contractor_id || null, b.deal_id || null, b.project_id || null, b.purpose || \"\"],\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 uf_ops SET date=?,op_type=?,confirmed=?,amount=?,account_id=?,account2_id=?,category_id=?,contractor_id=?,deal_id=?,project_id=?,purpose=? WHERE id=?`,\n args: [b.date, b.op_type, b.confirmed ? 1 : 0, num(b.amount), b.account_id || null, b.account2_id || null, b.category_id || null, b.contractor_id || null, b.deal_id || null, b.project_id || null, b.purpose || \"\", 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 uf_ops WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n});\n\n// ---------------- Сделки ----------------\napp.get(\"/api/deals\", async (c) => {\n const q = c.req.query();\n const cond: string[] = []; const args: any[] = [];\n if (q.status) { cond.push(`d.status=?`); args.push(q.status); }\n if (q.search) { cond.push(`(d.name LIKE ? OR d.client LIKE ? OR d.object_name LIKE ?)`); const s = `%${q.search}%`; args.push(s, s, s); }\n const where = cond.length ? `WHERE ` + cond.join(\" AND \") : \"\";\n const r = await sqlite.execute({\n sql: `SELECT d.id,d.name,d.client,d.object_name,d.developer_id,d.broker_id,d.status,d.price,d.commission,d.broker_fee,d.deposit_amount,\n d.d_deposit,d.d_booked,d.d_deal,d.d_closed,d.created_at,d.comment,\n dev.name,br.name,\n COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='income' AND o.confirmed=1),0) received,\n COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='expense' AND o.confirmed=1),0) spent\n FROM uf_deals d\n LEFT JOIN uf_contractors dev ON dev.id=d.developer_id LEFT JOIN uf_contractors br ON br.id=d.broker_id\n ${where} ORDER BY COALESCE(d.d_deal,d.created_at) DESC, d.id DESC`,\n args,\n });\n return c.json({\n items: rows(r).map((x) => ({\n id: x[0], name: x[1], client: x[2], object_name: x[3], developer_id: x[4], broker_id: x[5], status: x[6],\n price: num(x[7]), commission: num(x[8]), broker_fee: num(x[9]), deposit_amount: num(x[10]),\n d_deposit: x[11], d_booked: x[12], d_deal: x[13], d_closed: x[14], created_at: x[15], comment: x[16],\n developer: x[17], broker: x[18], received: num(x[19]), spent: num(x[20]),\n })),\n });\n});\nconst dealArgs = (b: any) => [b.name || \"\", b.client || \"\", b.object_name || \"\", b.developer_id || null, b.broker_id || null, b.status || \"deposit\", num(b.price), num(b.commission), num(b.broker_fee), num(b.deposit_amount), b.d_deposit || null, b.d_booked || null, b.d_deal || null, b.d_closed || null, b.comment || \"\"];\napp.post(\"/api/deals\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_deals(name,client,object_name,developer_id,broker_id,status,price,commission,broker_fee,deposit_amount,d_deposit,d_booked,d_deal,d_closed,comment,created_at)\n VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [...dealArgs(b), today()],\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/deals/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE uf_deals SET name=?,client=?,object_name=?,developer_id=?,broker_id=?,status=?,price=?,commission=?,broker_fee=?,deposit_amount=?,d_deposit=?,d_booked=?,d_deal=?,d_closed=?,comment=? WHERE id=?`,\n args: [...dealArgs(b), c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/deals/:id\", async (c) => {\n await sqlite.execute({ sql: `DELETE FROM uf_deals WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n});\napp.get(\"/api/deals/:id/notes\", async (c) => {\n const r = await sqlite.execute({ sql: `SELECT id,text,created_at FROM uf_deal_notes WHERE deal_id=? ORDER BY id DESC`, args: [c.req.param(\"id\")] });\n return c.json({ items: rows(r).map((x) => ({ id: x[0], text: x[1], created_at: x[2] })) });\n});\napp.post(\"/api/deals/:id/notes\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({ sql: `INSERT INTO uf_deal_notes(deal_id,text,created_at) VALUES(?,?,?)`, args: [c.req.param(\"id\"), b.text || \"\", new Date().toISOString()] });\n return c.json({ ok: true });\n});\n\n// ---------------- Справочники CRUD ----------------\nfunction crud(name: string, table: string, cols: string[]) {\n app.post(`/api/${name}`, async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO ${table}(${cols.join(\",\")}) VALUES(${cols.map(() => \"?\").join(\",\")})`,\n args: cols.map((k) => b[k] ?? null),\n });\n return c.json({ ok: true });\n });\n app.put(`/api/${name}/:id`, async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE ${table} SET ${cols.map((k) => `${k}=?`).join(\",\")} WHERE id=?`,\n args: [...cols.map((k) => b[k] ?? null), c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n });\n app.delete(`/api/${name}/:id`, async (c) => {\n await sqlite.execute({ sql: `DELETE FROM ${table} WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n });\n}\ncrud(\"accounts\", \"uf_accounts\", [\"name\", \"acc_type\", \"bank\", \"grp\", \"start_balance\", \"start_date\", \"active\"]);\ncrud(\"categories\", \"uf_categories\", [\"name\", \"kind\", \"cls\", \"fin_type\", \"parent_id\", \"sort\"]);\ncrud(\"contractors\", \"uf_contractors\", [\"name\", \"role\", \"inn\", \"phone\", \"comment\"]);\ncrud(\"projects\", \"uf_projects\", [\"name\", \"grp\", \"status\", \"date_start\", \"date_end\"]);\n\n// ---------------- План ----------------\napp.get(\"/api/plans\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({ sql: `SELECT period,income,expense,deals FROM uf_plans WHERE period LIKE ? ORDER BY period`, args: [year + \"-%\"] });\n // факт для сравнения\n const fact = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE substr(o.date,1,4)=? GROUP BY m`,\n args: [year],\n });\n const factMap: Record = {};\n for (const x of rows(fact)) factMap[String(x[0])] = { income: num(x[1]), expense: num(x[2]) };\n const dealsFact = await sqlite.execute({\n sql: `SELECT substr(COALESCE(d_deal,created_at),1,7) m, COUNT(*) FROM uf_deals WHERE status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,4)=? GROUP BY m`,\n args: [year],\n });\n for (const x of rows(dealsFact)) { factMap[String(x[0])] = { ...(factMap[String(x[0])] || {}), deals: num(x[1]) }; }\n return c.json({\n items: rows(r).map((x) => ({ period: x[0], income: num(x[1]), expense: num(x[2]), deals: num(x[3]) })),\n fact: factMap,\n });\n});\napp.put(\"/api/plans/:period\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_plans(period,income,expense,deals) VALUES(?,?,?,?)\n ON CONFLICT(period) DO UPDATE SET income=excluded.income,expense=excluded.expense,deals=excluded.deals`,\n args: [c.req.param(\"period\"), num(b.income), num(b.expense), num(b.deals)],\n });\n return c.json({ ok: true });\n});\n\n// ---------------- Отчёты ----------------\napp.get(\"/api/report/cashflow\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({\n sql: `SELECT COALESCE(root.id,cat.id) rid, COALESCE(root.name,cat.name,'Без статьи') rname,\n COALESCE(root.kind,cat.kind,o.op_type) rkind, COALESCE(root.cls,cat.cls,'pl') rcls,\n substr(o.date,1,7) m, SUM(o.amount), COALESCE(root.fin_type,cat.fin_type,'') rfin\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_categories root ON root.id=cat.parent_id\n WHERE o.confirmed=1 AND o.op_type IN ('income','expense') AND substr(o.date,1,4)=?\n GROUP BY rid, m`,\n args: [year],\n });\n return c.json({ rows: rows(r).map((x) => ({ id: x[0], name: x[1], kind: x[2], cls: x[3], month: x[4], value: num(x[5]), fin_type: x[6] })) });\n});\napp.get(\"/api/report/pl\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.confirmed=1 AND substr(o.date,1,4)=? GROUP BY m ORDER BY m`,\n args: [year],\n });\n return c.json({ rows: rows(r).map((x) => ({ month: x[0], income: num(x[1]), expense: num(x[2]) })) });\n});\n\n// ---------------- Настройки ----------------\napp.get(\"/api/settings\", async (c) => c.json({ company: await setting(\"company\", \"Unlock\") }));\napp.post(\"/api/settings\", async (c) => {\n const b = await c.req.json();\n if (b.company !== undefined) await setSetting(\"company\", String(b.company));\n if (b.pin) await setSetting(\"pin\", String(b.pin));\n return c.json({ ok: true });\n});\n\n// ---------------- Статика ----------------\napp.get(\"/frontend/app.js\", async () => {\n let out = \"\";\n for (let i = 1; i <= 9; i++) {\n try { out += await readFile(`/frontend/app.part${i}.txt`, import.meta.url); } catch (_e) { break; }\n }\n return new Response(out, { headers: { \"content-type\": \"text/javascript;charset=UTF-8\" } });\n});\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\nexport default app.fetch;\n","// U.fin v2 — финансовая система агентства недвижимости Unlock.\n// Спроектирована с нуля под логику агентства: сделки с задатками, брокеры,\n// застройщики, план месяц/год. Финансовое ядро: счета, операции, статьи с классами.\n// Backend: Hono + SQLite (val-scoped). Вход по PIN.\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile, 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));\nconst rows = (r: any) => r.rows as any[][];\n\n// ---------------- Схема ----------------\nawait sqlite.batch([\n `CREATE TABLE IF NOT EXISTS uf_settings (key TEXT PRIMARY KEY, value TEXT)`,\n `CREATE TABLE IF NOT EXISTS uf_accounts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n acc_type TEXT DEFAULT 'Безналичный',\n bank 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 uf_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n kind TEXT NOT NULL, -- income | expense\n cls TEXT DEFAULT 'pl', -- pl | assets | liabilities | capital (не-pl не попадает в прибыль)\n parent_id INTEGER,\n sort INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS uf_contractors (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n role TEXT DEFAULT 'other', -- developer | broker | client | bank | staff | other\n inn TEXT DEFAULT '',\n phone TEXT DEFAULT '',\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n grp TEXT DEFAULT '',\n status TEXT DEFAULT 'work',\n date_start TEXT, date_end TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS uf_deals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n client TEXT DEFAULT '',\n object_name TEXT DEFAULT '', -- ЖК / объект\n developer_id INTEGER, -- застройщик (контрагент)\n broker_id INTEGER, -- брокер (контрагент)\n status TEXT DEFAULT 'deposit', -- deposit | booked | deal | paid | failed\n price REAL DEFAULT 0, -- стоимость объекта\n commission REAL DEFAULT 0, -- комиссия агентства (наш доход)\n broker_fee REAL DEFAULT 0, -- вознаграждение брокера\n deposit_amount REAL DEFAULT 0, -- задаток\n d_deposit TEXT, d_booked TEXT, d_deal TEXT, d_closed TEXT,\n created_at TEXT,\n comment TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_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,\n amount REAL NOT NULL,\n account_id INTEGER,\n account2_id INTEGER,\n category_id INTEGER,\n contractor_id INTEGER,\n deal_id INTEGER,\n project_id INTEGER,\n purpose TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS uf_plans (\n period TEXT PRIMARY KEY, -- YYYY-MM\n income REAL DEFAULT 0,\n expense REAL DEFAULT 0,\n deals INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS uf_deal_notes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n deal_id INTEGER NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT\n )`,\n `CREATE INDEX IF NOT EXISTS uf_ops_date ON uf_ops(date)`,\n `CREATE INDEX IF NOT EXISTS uf_ops_deal ON uf_ops(deal_id)`,\n]);\n// fin_type: пометка статей финансирования (не доход и не расход)\n// own — вложения учредителей собственными деньгами\n// debt — привлечение кредитов/займов/овердрафта\n// repay — погашение кредитов/займов/овердрафта и возврат вложений\ntry { await sqlite.execute(`ALTER TABLE uf_categories ADD COLUMN fin_type TEXT DEFAULT ''`); } catch (_e) { /* есть */ }\n\nasync function setting(key: string, def = \"\"): Promise {\n const r = await sqlite.execute({ sql: `SELECT value FROM uf_settings WHERE key=?`, args: [key] });\n return rows(r).length ? String(rows(r)[0][0]) : def;\n}\nasync function setSetting(key: string, value: string) {\n await sqlite.execute({ sql: `INSERT INTO uf_settings(key,value) VALUES(?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value`, args: [key, value] });\n}\nif (!(await setting(\"pin\"))) await setSetting(\"pin\", \"1111\");\nif (!(await setting(\"company\"))) await setSetting(\"company\", \"Unlock\");\n\n// ---------------- Auth ----------------\napp.post(\"/api/login\", async (c) => {\n const b = await c.req.json();\n const pin = await setting(\"pin\", \"1111\");\n return c.json({ ok: String(b.pin) === pin });\n});\napp.use(\"/api/*\", async (c, next) => {\n if (c.req.path === \"/api/login\") return next();\n const pin = await setting(\"pin\", \"1111\");\n if (c.req.header(\"x-pin\") !== pin) return c.json({ error: \"unauthorized\" }, 401);\n await next();\n});\n\n// Класс-фильтр: только pl-статьи попадают в доходы/расходы (прибыль).\nconst PL = `COALESCE(cat.cls,'pl')='pl' AND COALESCE(cat.fin_type,'')=''`;\n// Финансирование: вложения учредителей, кредиты, займы, овердрафт и их погашение.\n// Это движение капитала, а не выручка и не расход — в доходной части не участвует.\nconst FIN = `COALESCE(cat.fin_type,'')<>''`;\nconst NOT_FIN = `COALESCE(cat.fin_type,'')=''`;\n\n// ---------------- Реклассификация: кредиты → финансирование ----------------\napp.post(\"/api/admin/reclass-financing\", async (c) => {\n const log: string[] = [];\n const one = async (sql: string, args: any[] = []) => {\n const r = await sqlite.execute({ sql, args });\n return rows(r).length ? rows(r)[0] : null;\n };\n const catId = async (name: string, kind: string) => {\n const r = await one(`SELECT id FROM uf_categories WHERE TRIM(name)=? AND kind=? LIMIT 1`, [name, kind]);\n return r ? Number(r[0]) : null;\n };\n const ensure = async (name: string, kind: string, cls: string, fin: string, parent: number | null) => {\n let id = await catId(name, kind);\n if (!id) {\n await sqlite.execute({\n sql: `INSERT INTO uf_categories(name,kind,cls,fin_type,parent_id) VALUES(?,?,?,?,?)`,\n args: [name, kind, cls, fin, parent],\n });\n id = await catId(name, kind);\n log.push(`создана статья «${name}»`);\n } else {\n await sqlite.execute({\n sql: `UPDATE uf_categories SET cls=?, fin_type=?, parent_id=? WHERE id=?`,\n args: [cls, fin, parent, id],\n });\n }\n return id!;\n };\n // корни\n const rootIn = await ensure(\"Вложения учредителей\", \"income\", \"capital\", \"own\", null);\n const rootOut = await ensure(\"Возврат финансирования\", \"expense\", \"capital\", \"repay\", null);\n // приток: собственные средства учредителей — отдельная подстатья, туда уходят старые операции корня\n const own = await ensure(\"Собственные средства учредителей\", \"income\", \"capital\", \"own\", rootIn);\n await sqlite.execute({ sql: `UPDATE uf_ops SET category_id=? WHERE category_id=?`, args: [own, rootIn] });\n\n // переносим существующие кредитные статьи под нужный корень, сохраняя детализацию\n const MAP: [string, string, string, string, number][] = [\n // старое имя, kind, новое имя, fin_type, parent\n [\"Овердрафт\", \"income\", \"Кредитные средства (овердрафт)\", \"debt\", rootIn],\n [\"Полученные займы (до 1 года)\", \"income\", \"Заёмные средства (до 1 года)\", \"debt\", rootIn],\n [\"Полученные займы (от 1 года)\", \"income\", \"Заёмные средства (от 1 года)\", \"debt\", rootIn],\n [\"Кредиты\", \"income\", \"Кредитные средства (кредиты)\", \"debt\", rootIn],\n [\"Овердрафт\", \"expense\", \"Погашение овердрафта\", \"repay\", rootOut],\n [\"Полученные займы (до 1 года)\", \"expense\", \"Возврат займов (до 1 года)\", \"repay\", rootOut],\n [\"Полученные займы (от 1 года)\", \"expense\", \"Возврат займов (от 1 года)\", \"repay\", rootOut],\n [\"Кредиты\", \"expense\", \"Погашение кредитов\", \"repay\", rootOut],\n [\"Кредиты и овердрафт\", \"expense\", \"Погашение кредитов и овердрафта\", \"repay\", rootOut],\n ];\n for (const [oldName, kind, newName, fin, parent] of MAP) {\n const id = await catId(oldName, kind);\n if (!id) continue;\n const cnt = await one(`SELECT COUNT(*) FROM uf_ops WHERE category_id=?`, [id]);\n // если статья с новым именем уже есть — сливаем операции в неё\n const exist = await catId(newName, kind);\n if (exist && exist !== id) {\n await sqlite.execute({ sql: `UPDATE uf_ops SET category_id=? WHERE category_id=?`, args: [exist, id] });\n await sqlite.execute({ sql: `DELETE FROM uf_categories WHERE id=?`, args: [id] });\n } else {\n await sqlite.execute({\n sql: `UPDATE uf_categories SET name=?, cls='capital', fin_type=?, parent_id=? WHERE id=?`,\n args: [newName, fin, parent, id],\n });\n }\n log.push(`${oldName} (${kind}) → ${newName}: ${cnt ? Number(cnt[0]) : 0} операций`);\n }\n // подчищаем: статьи без операций и без детей, оставшиеся после слияния\n await sqlite.execute(\n `DELETE FROM uf_categories WHERE fin_type<>'' AND id NOT IN (SELECT DISTINCT COALESCE(category_id,-1) FROM uf_ops)\n AND id NOT IN (SELECT DISTINCT COALESCE(parent_id,-1) FROM uf_categories)`,\n );\n const tot = await one(\n `SELECT SUM(CASE WHEN o.op_type='income' THEN o.amount ELSE 0 END), SUM(CASE WHEN o.op_type='expense' THEN o.amount ELSE 0 END)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id WHERE ${FIN}`,\n );\n return c.json({ ok: true, log, financing_in: num(tot?.[0]), financing_out: num(tot?.[1]) });\n});\n\n// ---------------- Загрузка сырых данных старой системы (pf_*) ----------------\napp.post(\"/api/admin/load\", async (c) => {\n const b = await c.req.json();\n const table = String(b.table || \"\");\n if (!/^pf_[a-z_]+$/.test(table)) return c.json({ error: \"bad table\" }, 400);\n const cols: string[] = (b.columns || []).filter((x: string) => /^[a-z0-9_]+$/i.test(x));\n if (!cols.length) return c.json({ error: \"no columns\" }, 400);\n if (b.reset) {\n await sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\n await sqlite.execute(`CREATE TABLE ${table} (${cols.join(\",\")})`);\n }\n const rws: any[][] = b.rows || [];\n if (rws.length) {\n const lit = (v: any) =>\n v === null || v === undefined\n ? \"NULL\"\n : typeof v === \"number\"\n ? String(v)\n : \"'\" + String(v).replace(/'/g, \"''\") + \"'\";\n // вставка литералами по 50 строк на statement (обходим баг биндинга параметров)\n const stmts: string[] = [];\n for (let i = 0; i < rws.length; i += 50) {\n const chunk = rws.slice(i, i + 50);\n stmts.push(`INSERT INTO ${table}(${cols.join(\",\")}) VALUES ` + chunk.map((r) => `(${r.map(lit).join(\",\")})`).join(\",\"));\n }\n await sqlite.batch(stmts);\n }\n return c.json({ ok: true, inserted: rws.length });\n});\n\n// ---------------- Миграция из старой базы (pf_*) ----------------\napp.post(\"/api/admin/migrate\", async (c) => {\n const log: string[] = [];\n const t = (await sqlite.execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name LIKE 'pf_%'`,\n )).rows.map((r: any) => String(r[0]));\n if (!t.includes(\"pf_ops\")) return c.json({ error: \"старые таблицы pf_* не найдены\" }, 400);\n\n // чистим целевые таблицы (идемпотентно)\n for (const tbl of [\"uf_ops\", \"uf_deals\", \"uf_contractors\", \"uf_accounts\", \"uf_categories\", \"uf_projects\", \"uf_plans\", \"uf_deal_notes\"]) {\n await sqlite.execute(`DELETE FROM ${tbl}`);\n }\n\n // Счета (id сохраняем)\n await sqlite.execute(`INSERT INTO uf_accounts(id,name,acc_type,bank,grp,start_balance,start_date,active)\n SELECT id,TRIM(name),acc_type,bank,grp,start_balance,start_date,active FROM pf_accounts`);\n log.push(`accounts: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_accounts`)).rows[0][0])}`);\n\n // Статьи: cat_class → cls ('' | income | outcome → pl)\n await sqlite.execute(`INSERT INTO uf_categories(id,name,kind,cls,parent_id,sort)\n SELECT id,TRIM(name),kind,\n CASE LOWER(COALESCE(cat_class,'')) WHEN 'assets' THEN 'assets' WHEN 'liabilities' THEN 'liabilities' WHEN 'capital' THEN 'capital' ELSE 'pl' END,\n parent_id,sort FROM pf_categories`);\n log.push(`categories: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_categories`)).rows[0][0])}`);\n\n // Контрагенты: роль эвристикой по группе/имени; уточняется вручную в справочнике\n await sqlite.execute(`INSERT INTO uf_contractors(id,name,role,inn,comment)\n SELECT id,TRIM(name),\n CASE\n WHEN LOWER(COALESCE(grp,'')) LIKE '%застройщик%' OR LOWER(name) LIKE '%застройщик%' OR LOWER(name) LIKE '%сз %' OR LOWER(name) LIKE '%сз«%' OR LOWER(name) LIKE '%спецзастройщик%' THEN 'developer'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%брокер%' OR LOWER(name) LIKE '%брокер%' THEN 'broker'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%банк%' OR LOWER(name) LIKE '%банк%' THEN 'bank'\n WHEN LOWER(COALESCE(grp,'')) LIKE '%сотрудник%' THEN 'staff'\n ELSE 'other'\n END, inn, COALESCE(comment,'') FROM pf_contractors`);\n log.push(`contractors: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_contractors`)).rows[0][0])}`);\n\n // Проекты\n await sqlite.execute(`INSERT INTO uf_projects(id,name,grp,status,date_start,date_end)\n SELECT id,TRIM(name),COALESCE(grp,''),COALESCE(status,'work'),date_start,date_end FROM pf_projects`);\n log.push(`projects: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_projects`)).rows[0][0])}`);\n\n // Сделки: статусы done→paid, fail→failed, work/nuance→deal; комиссия = amount\n await sqlite.execute(`INSERT INTO uf_deals(id,name,client,status,commission,d_deal,d_closed,created_at,comment)\n SELECT id,TRIM(name),COALESCE(client,''),\n CASE status WHEN 'done' THEN 'paid' WHEN 'fail' THEN 'failed' ELSE 'deal' END,\n amount,\n created_at,\n CASE WHEN status IN ('done','fail') THEN created_at ELSE NULL END,\n created_at,COALESCE(comment,'') FROM pf_deals`);\n log.push(`deals: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_deals`)).rows[0][0])}`);\n\n // Привязка брокера к сделке по имени сделки = имени контрагента-брокера (если совпало)\n await sqlite.execute(`UPDATE uf_deals SET broker_id=(SELECT c.id FROM uf_contractors c WHERE TRIM(c.name)=TRIM(uf_deals.name) LIMIT 1)`);\n\n // Операции (id и все связи сохраняем)\n await sqlite.execute(`INSERT INTO uf_ops(id,date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,purpose)\n SELECT id,date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,COALESCE(purpose,'') FROM pf_ops`);\n log.push(`ops: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_ops`)).rows[0][0])}`);\n\n // Планы: из БДР-бюджетов (сумма по всем бюджетам за период)\n if (t.includes(\"pf_budget_values\")) {\n await sqlite.execute(`INSERT INTO uf_plans(period,income,expense,deals)\n SELECT period,\n SUM(CASE WHEN row_key LIKE 'inc_%' OR row_key='oi' THEN amount ELSE 0 END),\n SUM(CASE WHEN row_key IN ('var','fix','oe','dep','int','tax') THEN amount ELSE 0 END),\n 0\n FROM pf_budget_values GROUP BY period`);\n log.push(`plans: ${num((await sqlite.execute(`SELECT COUNT(*) FROM uf_plans`)).rows[0][0])}`);\n }\n\n // Роль developer контрагентам, платившим нам по сделкам (доход, привязанный к сделке)\n await sqlite.execute(`UPDATE uf_contractors SET role='developer' WHERE role='other' AND id IN (\n SELECT DISTINCT o.contractor_id FROM uf_ops o WHERE o.op_type='income' AND o.deal_id IS NOT NULL AND o.contractor_id IS NOT NULL)`);\n\n return c.json({ ok: true, log });\n});\n\n// ---------------- Meta ----------------\napp.get(\"/api/meta\", async (c) => {\n const [acc, cats, contr, proj] = await Promise.all([\n sqlite.execute(`SELECT id,name,acc_type,bank,grp,start_balance,start_date,active FROM uf_accounts ORDER BY name`),\n sqlite.execute(`SELECT id,name,kind,cls,parent_id,sort,COALESCE(fin_type,'') FROM uf_categories ORDER BY kind,sort,name`),\n sqlite.execute(`SELECT id,name,role,inn,phone,comment FROM uf_contractors ORDER BY name`),\n sqlite.execute(`SELECT id,name,grp,status,date_start,date_end FROM uf_projects ORDER BY name`),\n ]);\n // балансы по счетам\n const bal = await sqlite.execute(`\n SELECT a.id, a.start_balance\n + COALESCE((SELECT SUM(CASE o.op_type WHEN 'income' THEN o.amount WHEN 'expense' THEN -o.amount\n WHEN 'transfer' THEN CASE WHEN o.account_id=a.id THEN -o.amount ELSE 0 END END)\n FROM uf_ops o WHERE o.confirmed=1 AND (o.account_id=a.id OR (o.op_type='transfer' AND o.account2_id=a.id))),0)\n + COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.confirmed=1 AND o.op_type='transfer' AND o.account2_id=a.id),0)\n FROM uf_accounts a`);\n const balMap: Record = {};\n for (const r of rows(bal)) balMap[String(r[0])] = num(r[1]);\n const company = await setting(\"company\", \"Unlock\");\n return c.json({\n company,\n accounts: rows(acc).map((r) => ({ id: r[0], name: r[1], acc_type: r[2], bank: r[3], grp: r[4], start_balance: num(r[5]), start_date: r[6], active: num(r[7]), balance: balMap[String(r[0])] ?? num(r[5]) })),\n categories: rows(cats).map((r) => ({ id: r[0], name: r[1], kind: r[2], cls: r[3], parent_id: r[4], sort: num(r[5]), fin_type: r[6] })),\n contractors: rows(contr).map((r) => ({ id: r[0], name: r[1], role: r[2], inn: r[3], phone: r[4], comment: r[5] })),\n projects: rows(proj).map((r) => ({ id: r[0], name: r[1], grp: r[2], status: r[3], date_start: r[4], date_end: r[5] })),\n });\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\n // помесячные факт-суммы за 12 месяцев года (только pl-классы)\n const months = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE substr(o.date,1,4)=? GROUP BY m ORDER BY m`,\n args: [year],\n });\n const byM: Record = {};\n for (const r of rows(months)) byM[String(r[0])] = { income: num(r[1]), expense: num(r[2]) };\n\n const mi = byM[month]?.income || 0, me = byM[month]?.expense || 0;\n let yi = 0, ye = 0;\n for (const k in byM) { yi += byM[k].income; ye += byM[k].expense; }\n\n // на заходе: незакрытые сделки, комиссия минус уже полученное\n const pipe = await sqlite.execute(`\n SELECT COALESCE(SUM(d.commission - COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='income' AND o.confirmed=1),0)),0),\n COUNT(*)\n FROM uf_deals d WHERE d.status IN ('deposit','booked','deal')`);\n const pipeline = Math.max(0, num(rows(pipe)[0][0])), pipeCount = num(rows(pipe)[0][1]);\n\n // от застройщиков за месяц: доход по сделкам или от контрагентов-застройщиков\n const dev = await sqlite.execute({\n sql: `SELECT COALESCE(SUM(o.amount),0) FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n WHERE o.op_type='income' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7)=?\n AND (o.deal_id IS NOT NULL OR ct.role='developer')`,\n args: [month],\n });\n // брокерам за месяц: расход контрагентам-брокерам или по статье с «брокер»\n const brok = await sqlite.execute({\n sql: `SELECT COALESCE(SUM(o.amount),0) FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n WHERE o.op_type='expense' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7)=?\n AND (ct.role='broker' OR COALESCE(cat.name,'') LIKE '%рокер%' OR o.deal_id IS NOT NULL)`,\n args: [month],\n });\n\n // средний чек: средняя комиссия сделок, прошедших в месяце\n const avgCheck = await sqlite.execute({\n sql: `SELECT COALESCE(AVG(commission),0), COUNT(*) FROM uf_deals\n WHERE commission>0 AND status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,7)=?`,\n args: [month],\n });\n\n // воронка месяца\n const f = async (sql: string) => num(rows(await sqlite.execute({ sql, args: [month] }))[0][0]);\n const funnel = {\n deposits: await f(`SELECT COUNT(*) FROM uf_deals WHERE substr(COALESCE(d_deposit,created_at),1,7)=?`),\n booked: await f(`SELECT COUNT(*) FROM uf_deals WHERE d_booked IS NOT NULL AND substr(d_booked,1,7)=?`),\n deals: await f(`SELECT COUNT(*) FROM uf_deals WHERE status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,7)=?`),\n failed: await f(`SELECT COUNT(*) FROM uf_deals WHERE status='failed' AND substr(COALESCE(d_closed,created_at),1,7)=?`),\n };\n\n // кредиты/овердрафт: непогашенный долг = привлечено − погашено (по всей истории)\n const credit = await sqlite.execute(`\n SELECT COALESCE(SUM(CASE WHEN cat.fin_type='debt' THEN o.amount WHEN cat.fin_type='repay' THEN -o.amount ELSE 0 END),0)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id WHERE o.confirmed=1`);\n\n // финансирование за месяц и за год: вложения учредителей, привлечение и погашение кредитов\n const finRow = async (period: string, like: boolean) => {\n const r = await sqlite.execute({\n sql: `SELECT\n COALESCE(SUM(CASE WHEN cat.fin_type='own' AND o.op_type='income' THEN o.amount ELSE 0 END),0),\n COALESCE(SUM(CASE WHEN cat.fin_type='debt' THEN o.amount ELSE 0 END),0),\n COALESCE(SUM(CASE WHEN cat.fin_type='repay' THEN o.amount ELSE 0 END),0)\n FROM uf_ops o JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.confirmed=1 AND substr(o.date,1,${like ? 4 : 7})=?`,\n args: [period],\n });\n const x = rows(r)[0];\n return { own: num(x[0]), debt: num(x[1]), repay: num(x[2]) };\n };\n const finM = await finRow(month, false);\n const finY = await finRow(year, true);\n\n // средний расход/мес: по последним 6 завершённым месяцам с операциями\n const avgExp = await sqlite.execute({\n sql: `SELECT COALESCE(AVG(s),0) FROM (\n SELECT SUM(o.amount) s FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.op_type='expense' AND o.confirmed=1 AND ${PL} AND substr(o.date,1,7) = {};\n for (const r of rows(dealsByM)) dealsMap[String(r[0])] = num(r[1]);\n\n return c.json({\n month, year,\n month_income: mi, month_expense: me, month_np: mi - me,\n year_income: yi, year_expense: ye, year_np: yi - ye,\n months: byM,\n deals_by_month: dealsMap,\n pipeline, pipeline_count: pipeCount,\n from_developers: num(rows(dev)[0][0]),\n to_brokers: num(rows(brok)[0][0]),\n avg_check: num(rows(avgCheck)[0][0]), avg_check_count: num(rows(avgCheck)[0][1]),\n funnel,\n credit_debt: num(rows(credit)[0][0]),\n fin_month: finM, fin_year: finY,\n avg_expense: num(rows(avgExp)[0][0]),\n plan_month: pm ? { income: num(pm[0]), expense: num(pm[1]), deals: num(pm[2]) } : null,\n plan_year: { income: num(py[0]), expense: num(py[1]), deals: num(py[2]) },\n struct: rows(struct).map((r) => ({ name: r[0], value: num(r[1]) })),\n });\n});\n\n// ---------------- Операции ----------------\napp.get(\"/api/ops\", async (c) => {\n const q = c.req.query();\n const cond: string[] = []; const args: any[] = [];\n if (q.from) { cond.push(`o.date>=?`); args.push(q.from); }\n if (q.to) { cond.push(`o.date<=?`); args.push(q.to); }\n if (q.type) { cond.push(`o.op_type=?`); args.push(q.type); }\n if (q.account) { cond.push(`(o.account_id=? OR o.account2_id=?)`); args.push(q.account, q.account); }\n if (q.category) { cond.push(`o.category_id=?`); args.push(q.category); }\n if (q.contractor) { cond.push(`o.contractor_id=?`); args.push(q.contractor); }\n if (q.deal) { cond.push(`o.deal_id=?`); args.push(q.deal); }\n if (q.search) { cond.push(`(o.purpose LIKE ? OR ct.name LIKE ? OR cat.name LIKE ?)`); const s = `%${q.search}%`; args.push(s, s, s); }\n const where = cond.length ? `WHERE ` + cond.join(\" AND \") : \"\";\n const lim = Math.min(num(q.limit) || 100, 500), off = num(q.offset) || 0;\n const r = await sqlite.execute({\n sql: `SELECT o.id,o.date,o.op_type,o.confirmed,o.amount,o.account_id,o.account2_id,o.category_id,o.contractor_id,o.deal_id,o.project_id,o.purpose,\n a.name,a2.name,cat.name,ct.name,d.name\n FROM uf_ops o\n LEFT JOIN uf_accounts a ON a.id=o.account_id LEFT JOIN uf_accounts a2 ON a2.id=o.account2_id\n LEFT JOIN uf_categories cat ON cat.id=o.category_id LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n LEFT JOIN uf_deals d ON d.id=o.deal_id\n ${where} ORDER BY o.date DESC, o.id DESC LIMIT ${lim} OFFSET ${off}`,\n args,\n });\n const tot = await sqlite.execute({\n sql: `SELECT COUNT(*),\n COALESCE(SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${PL} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${PL} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${FIN} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${FIN} THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${NOT_FIN} AND COALESCE(cat.cls,'pl')<>'pl' THEN o.amount END),0),\n COALESCE(SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${NOT_FIN} AND COALESCE(cat.cls,'pl')<>'pl' THEN o.amount END),0)\n FROM uf_ops o\n LEFT JOIN uf_categories cat ON cat.id=o.category_id LEFT JOIN uf_contractors ct ON ct.id=o.contractor_id\n ${where}`,\n args,\n });\n return c.json({\n total: num(rows(tot)[0][0]), sum_income: num(rows(tot)[0][1]), sum_expense: num(rows(tot)[0][2]),\n sum_fin_in: num(rows(tot)[0][3]), sum_fin_out: num(rows(tot)[0][4]),\n sum_other_in: num(rows(tot)[0][5]), sum_other_out: num(rows(tot)[0][6]),\n items: rows(r).map((x) => ({\n id: x[0], date: x[1], op_type: x[2], confirmed: num(x[3]), amount: num(x[4]),\n account_id: x[5], account2_id: x[6], category_id: x[7], contractor_id: x[8], deal_id: x[9], project_id: x[10], purpose: x[11],\n account: x[12], account2: x[13], category: x[14], contractor: x[15], deal: x[16],\n })),\n });\n});\napp.post(\"/api/ops\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_ops(date,op_type,confirmed,amount,account_id,account2_id,category_id,contractor_id,deal_id,project_id,purpose)\n VALUES(?,?,?,?,?,?,?,?,?,?,?)`,\n args: [b.date || today(), b.op_type, b.confirmed ? 1 : 0, num(b.amount), b.account_id || null, b.account2_id || null, b.category_id || null, b.contractor_id || null, b.deal_id || null, b.project_id || null, b.purpose || \"\"],\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 uf_ops SET date=?,op_type=?,confirmed=?,amount=?,account_id=?,account2_id=?,category_id=?,contractor_id=?,deal_id=?,project_id=?,purpose=? WHERE id=?`,\n args: [b.date, b.op_type, b.confirmed ? 1 : 0, num(b.amount), b.account_id || null, b.account2_id || null, b.category_id || null, b.contractor_id || null, b.deal_id || null, b.project_id || null, b.purpose || \"\", 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 uf_ops WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n});\n\n// ---------------- Сделки ----------------\napp.get(\"/api/deals\", async (c) => {\n const q = c.req.query();\n const cond: string[] = []; const args: any[] = [];\n if (q.status) { cond.push(`d.status=?`); args.push(q.status); }\n if (q.search) { cond.push(`(d.name LIKE ? OR d.client LIKE ? OR d.object_name LIKE ?)`); const s = `%${q.search}%`; args.push(s, s, s); }\n const where = cond.length ? `WHERE ` + cond.join(\" AND \") : \"\";\n const r = await sqlite.execute({\n sql: `SELECT d.id,d.name,d.client,d.object_name,d.developer_id,d.broker_id,d.status,d.price,d.commission,d.broker_fee,d.deposit_amount,\n d.d_deposit,d.d_booked,d.d_deal,d.d_closed,d.created_at,d.comment,\n dev.name,br.name,\n COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='income' AND o.confirmed=1),0) received,\n COALESCE((SELECT SUM(o.amount) FROM uf_ops o WHERE o.deal_id=d.id AND o.op_type='expense' AND o.confirmed=1),0) spent\n FROM uf_deals d\n LEFT JOIN uf_contractors dev ON dev.id=d.developer_id LEFT JOIN uf_contractors br ON br.id=d.broker_id\n ${where} ORDER BY COALESCE(d.d_deal,d.created_at) DESC, d.id DESC`,\n args,\n });\n return c.json({\n items: rows(r).map((x) => ({\n id: x[0], name: x[1], client: x[2], object_name: x[3], developer_id: x[4], broker_id: x[5], status: x[6],\n price: num(x[7]), commission: num(x[8]), broker_fee: num(x[9]), deposit_amount: num(x[10]),\n d_deposit: x[11], d_booked: x[12], d_deal: x[13], d_closed: x[14], created_at: x[15], comment: x[16],\n developer: x[17], broker: x[18], received: num(x[19]), spent: num(x[20]),\n })),\n });\n});\nconst dealArgs = (b: any) => [b.name || \"\", b.client || \"\", b.object_name || \"\", b.developer_id || null, b.broker_id || null, b.status || \"deposit\", num(b.price), num(b.commission), num(b.broker_fee), num(b.deposit_amount), b.d_deposit || null, b.d_booked || null, b.d_deal || null, b.d_closed || null, b.comment || \"\"];\napp.post(\"/api/deals\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_deals(name,client,object_name,developer_id,broker_id,status,price,commission,broker_fee,deposit_amount,d_deposit,d_booked,d_deal,d_closed,comment,created_at)\n VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [...dealArgs(b), today()],\n });\n return c.json({ ok: true });\n});\napp.put(\"/api/deals/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE uf_deals SET name=?,client=?,object_name=?,developer_id=?,broker_id=?,status=?,price=?,commission=?,broker_fee=?,deposit_amount=?,d_deposit=?,d_booked=?,d_deal=?,d_closed=?,comment=? WHERE id=?`,\n args: [...dealArgs(b), c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/deals/:id\", async (c) => {\n await sqlite.execute({ sql: `DELETE FROM uf_deals WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n});\napp.get(\"/api/deals/:id/notes\", async (c) => {\n const r = await sqlite.execute({ sql: `SELECT id,text,created_at FROM uf_deal_notes WHERE deal_id=? ORDER BY id DESC`, args: [c.req.param(\"id\")] });\n return c.json({ items: rows(r).map((x) => ({ id: x[0], text: x[1], created_at: x[2] })) });\n});\napp.post(\"/api/deals/:id/notes\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({ sql: `INSERT INTO uf_deal_notes(deal_id,text,created_at) VALUES(?,?,?)`, args: [c.req.param(\"id\"), b.text || \"\", new Date().toISOString()] });\n return c.json({ ok: true });\n});\n\n// ---------------- Справочники CRUD ----------------\nfunction crud(name: string, table: string, cols: string[]) {\n app.post(`/api/${name}`, async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO ${table}(${cols.join(\",\")}) VALUES(${cols.map(() => \"?\").join(\",\")})`,\n args: cols.map((k) => b[k] ?? null),\n });\n return c.json({ ok: true });\n });\n app.put(`/api/${name}/:id`, async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE ${table} SET ${cols.map((k) => `${k}=?`).join(\",\")} WHERE id=?`,\n args: [...cols.map((k) => b[k] ?? null), c.req.param(\"id\")],\n });\n return c.json({ ok: true });\n });\n app.delete(`/api/${name}/:id`, async (c) => {\n await sqlite.execute({ sql: `DELETE FROM ${table} WHERE id=?`, args: [c.req.param(\"id\")] });\n return c.json({ ok: true });\n });\n}\ncrud(\"accounts\", \"uf_accounts\", [\"name\", \"acc_type\", \"bank\", \"grp\", \"start_balance\", \"start_date\", \"active\"]);\ncrud(\"categories\", \"uf_categories\", [\"name\", \"kind\", \"cls\", \"fin_type\", \"parent_id\", \"sort\"]);\ncrud(\"contractors\", \"uf_contractors\", [\"name\", \"role\", \"inn\", \"phone\", \"comment\"]);\ncrud(\"projects\", \"uf_projects\", [\"name\", \"grp\", \"status\", \"date_start\", \"date_end\"]);\n\n// ---------------- План ----------------\napp.get(\"/api/plans\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({ sql: `SELECT period,income,expense,deals FROM uf_plans WHERE period LIKE ? ORDER BY period`, args: [year + \"-%\"] });\n // факт для сравнения\n const fact = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND o.confirmed=1 AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE substr(o.date,1,4)=? GROUP BY m`,\n args: [year],\n });\n const factMap: Record = {};\n for (const x of rows(fact)) factMap[String(x[0])] = { income: num(x[1]), expense: num(x[2]) };\n const dealsFact = await sqlite.execute({\n sql: `SELECT substr(COALESCE(d_deal,created_at),1,7) m, COUNT(*) FROM uf_deals WHERE status IN ('deal','paid') AND substr(COALESCE(d_deal,created_at),1,4)=? GROUP BY m`,\n args: [year],\n });\n for (const x of rows(dealsFact)) { factMap[String(x[0])] = { ...(factMap[String(x[0])] || {}), deals: num(x[1]) }; }\n return c.json({\n items: rows(r).map((x) => ({ period: x[0], income: num(x[1]), expense: num(x[2]), deals: num(x[3]) })),\n fact: factMap,\n });\n});\napp.put(\"/api/plans/:period\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO uf_plans(period,income,expense,deals) VALUES(?,?,?,?)\n ON CONFLICT(period) DO UPDATE SET income=excluded.income,expense=excluded.expense,deals=excluded.deals`,\n args: [c.req.param(\"period\"), num(b.income), num(b.expense), num(b.deals)],\n });\n return c.json({ ok: true });\n});\n\n// ---------------- Отчёты ----------------\napp.get(\"/api/report/cashflow\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({\n sql: `SELECT COALESCE(root.id,cat.id) rid, COALESCE(root.name,cat.name,'Без статьи') rname,\n COALESCE(root.kind,cat.kind,o.op_type) rkind, COALESCE(root.cls,cat.cls,'pl') rcls,\n substr(o.date,1,7) m, SUM(o.amount), COALESCE(root.fin_type,cat.fin_type,'') rfin\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n LEFT JOIN uf_categories root ON root.id=cat.parent_id\n WHERE o.confirmed=1 AND o.op_type IN ('income','expense') AND substr(o.date,1,4)=?\n GROUP BY rid, m`,\n args: [year],\n });\n return c.json({ rows: rows(r).map((x) => ({ id: x[0], name: x[1], kind: x[2], cls: x[3], month: x[4], value: num(x[5]), fin_type: x[6] })) });\n});\napp.get(\"/api/report/pl\", async (c) => {\n const year = c.req.query(\"year\") || today().slice(0, 4);\n const r = await sqlite.execute({\n sql: `SELECT substr(o.date,1,7) m,\n SUM(CASE WHEN o.op_type='income' AND ${PL} THEN o.amount ELSE 0 END),\n SUM(CASE WHEN o.op_type='expense' AND ${PL} THEN o.amount ELSE 0 END)\n FROM uf_ops o LEFT JOIN uf_categories cat ON cat.id=o.category_id\n WHERE o.confirmed=1 AND substr(o.date,1,4)=? GROUP BY m ORDER BY m`,\n args: [year],\n });\n return c.json({ rows: rows(r).map((x) => ({ month: x[0], income: num(x[1]), expense: num(x[2]) })) });\n});\n\n// ---------------- Настройки ----------------\napp.get(\"/api/settings\", async (c) => c.json({ company: await setting(\"company\", \"Unlock\") }));\napp.post(\"/api/settings\", async (c) => {\n const b = await c.req.json();\n if (b.company !== undefined) await setSetting(\"company\", String(b.company));\n if (b.pin) await setSetting(\"pin\", String(b.pin));\n return c.json({ ok: true });\n});\n\n// ---------------- Статика ----------------\napp.get(\"/frontend/app.js\", async () => {\n let out = \"\";\n for (let i = 1; i <= 9; i++) {\n try { out += await readFile(`/frontend/app.part${i}.txt`, import.meta.url); } catch (_e) { break; }\n }\n return new Response(out, { headers: { \"content-type\": \"text/javascript;charset=UTF-8\" } });\n});\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\", import.meta.url));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\nexport default app.fetch;\n","createdAt",["D",1787661044229],"branchVersion","branchId","b8e0918e-f674-49d7-9108-412c36e6cc77","id","d38ab4c8-7c2c-436f-9fef-9b1d67be3d19","ufin2",["D",1787314298248],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","U.fin v2","imageUrl","caa5b6a0-dd4e-4cd6-a997-9389a6a43948","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019eff71-5749-76b5-abdd-e25a47b3deca","tursoName","d38ab4c87c2c436f9fef9b1d67be3d19","tursoHostname","d38ab4c87c2c436f9fef9b1d67be3d19-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"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",13,"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",[157,161],"files",[157,158,159,160,161],"counts",{"_146":62,"_147":148,"_149":62,"_150":151,"_152":153},"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":58,"_38":135,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_27":138},"57438cde-2f06-4724-9e6e-3c29f4267cf4","parentId","latest",["D",1787661044229],5,"label",[28],"af943855-9598-4b6c-974d-b40c098081dd","frontend","d6425b9f-9139-4189-8273-fccd35c26d0e",2,["D",1787314822204],"directory",[140],"pulls","branches",1,"forks","envVars",{"_154":62,"_156":62},"connections",{"_154":62,"_155":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,"_163":190,"_27":191},{"_43":181,"_32":182,"_30":183,"_133":141,"_41":42,"_40":184,"_134":25,"_38":185,"_13":148,"_33":20,"_35":186,"_24":25,"_137":-5,"_163":187,"_27":188},{"_43":173,"_32":174,"_30":175,"_133":141,"_41":42,"_40":176,"_134":25,"_38":177,"_13":148,"_33":20,"_35":178,"_24":25,"_137":-5,"_163":179,"_27":180},{"_43":166,"_32":167,"_30":168,"_133":141,"_41":42,"_40":142,"_134":58,"_38":169,"_13":62,"_33":20,"_35":170,"_24":25,"_137":-5,"_163":171,"_27":172},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":58,"_38":162,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_163":164,"_27":165},["D",1787661044229],"children",[],[28],"33ecea45-688f-420c-a1a3-84b5cb5fe6a6","index.html","ae509a26-9d5a-11f1-9d07-1607ee4eb77e",["D",1787314822204],"\n\n\n \n \n U.fin — финансы агентства Unlock\n \n \n \n \n\n\n

\n \n\n\n",[],[140,167],"dc3c8ac7-5e03-4deb-b849-c566cafd897f","app.part2.txt","af746482-9d5a-11f1-b9bf-1607ee4eb77e",10,["D",1787660645522],"D\"]]],[\"date_start\",\"\\u041D\\u0430\\u0447\\u0430\\u043B\\u043E\",\"date\"],[\"date_end\",\"\\u041E\\u043A\\u043E\\u043D\\u0447\\u0430\\u043D\\u0438\\u0435\",\"date\"]]}))}function xe({meta:s,reload:d}){let[r,l]=f(s.company||\"\"),[a,b]=f(\"\"),[p,g]=f(\"\");return e.createElement(\"div\",{className:\"p-6 max-w-lg mx-auto\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800 mb-4\"},\"\\u041D\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u043A\\u0438\"),e.createElement(k,{className:\"p-5 space-y-4\"},e.createElement(C,{label:\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435 \\u043A\\u043E\\u043C\\u043F\\u0430\\u043D\\u0438\\u0438\"},e.createElement(S,{value:r,onChange:v=>l(v.target.value)})),e.createElement(C,{label:\"\\u041D\\u043E\\u0432\\u044B\\u0439 PIN (\\u043F\\u0443\\u0441\\u0442\\u043E \\u2014 \\u043D\\u0435 \\u043C\\u0435\\u043D\\u044F\\u0442\\u044C)\"},e.createElement(S,{value:a,onChange:v=>b(v.target.value)})),e.createElement(_,{onClick:async()=>{await M(\"/api/settings\",{method:\"POST\",body:{company:r,...a?{pin:a}:{}}}),a&&localStorage.setItem(\"uf2_pin\",a),g(\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0435\\u043D\\u043E\"),d()}},\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\"),p&&e.createElement(\"div\",{className:\"text-sm text-emerald-600\"},p)))}ve({presets:[fe(),ce()]});var he=[[\"dash\",\"\\u0414\\u0430\\u0448\\u0431\\u043E\\u0440\\u0434\",P.home],[\"ops\",\"\\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u0438\",P.ops],[\"deals\",\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\",P.deals],[\"plan\",\"\\u041F\\u043B\\u0430\\u043D\",P.plan],[\"reports\",\"\\u041E\\u0442\\u0447\\u0451\\u0442\\u044B\",P.report],[\"refs\",\"\\u0421\\u043F\\u0440\\u0430\\u0432\\u043E\\u0447\\u043D\\u0438\\u043A\\u0438\",P.refs],[\"settings\",\"\\u041D\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u043A\\u0438\",P.gear]];function ge({onOk:s}){let[d,r]=f(\"\"),[l,a]=f(!1),b=async()=>{(await fetch(\"/api/login\",{method:\"POST\",headers:{\"content-type\":\"application/json\"},body:JSON.stringify({pin:d})}).then(g=>g.json())).ok?(R(d),s()):a(!0)};return N.createElement(\"div\",{className:\"min-h-screen flex items-center justify-center bg-slate-900\"},N.createElement(\"div\",{className:\"bg-white rounded-3xl shadow-2xl p-8 w-80 text-center\"},N.createElement(\"div\",{className:\"w-14 h-14 rounded-2xl bg-emerald-500 text-white text-2xl font-black flex items-center justify-center mx-auto mb-3\"},\"U\"),N.createElement(\"div\",{className:\"font-bold text-slate-800 text-lg mb-1\"},\"U.fin\"),N.createElement(\"div\",{className:\"text-sm text-slate-400 mb-5\"},\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u044B \\u0430\\u0433\\u0435\\u043D\\u0442\\u0441\\u0442\\u0432\\u0430 Unlock\"),N.createElement(\"input\",{type:\"password\",autoFocus:!0,placeholder:\"PIN\",className:\"w-full border border-slate-200 rounded-xl px-4 py-3 text-center text-lg tracking-widest focus:outline-none focus:ring-2 focus:ring-emerald-300 mb-3\",value:d,onChange:p=>{r(p.target.value),a(!1)},onKeyDown:p=>p.key===\"Enter\"&&b()}),l&&N.createElement(\"div\",{className:\"text-sm text-rose-500 mb-2\"},\"\\u041D\\u0435\\u0432\\u0435\\u0440\\u043D\\u044B\\u0439 PIN\"),N.createElement(_,{className:\"w-full\",onClick:b},\"\\u0412\\u043E\\u0439\\u0442\\u0438\")))}function ye(){let[s,d]=f(!!q()),[r,l]=f(\"dash\"),[a,b]=f(null),[p,g]=f(!1),v=()=>{M(\"/api/meta\").then(b).catch(()=>{})};if(O(()=>{s&&v()},[s]),!s)return N.createElement(ge,{onOk:()=>d(!0)});if(!a)return N.createElement(\"div\",{className:\"min-h-screen flex items-center justify-center text-slate-400 bg-slate-50\"},\"\\u0417\\u0430\\u0433\\u0440\\u0443\\u0437\\u043A\\u0430\\u2026\");let t=a.accounts.filter(n=>n.active).reduce((n,h)=>n+h.balance,0);return N.createElement(\"div\",{className:\"min-h-screen bg-slate-100 flex\",style:{fontFamily:\"'Inter','Segoe UI',sans-serif\"}},N.createElement(\"aside\",{className:\"w-56 shrink-0 bg-slate-900 text-slate-300 flex flex-col min-h-screen sticky top-0 max-h-screen\"},N.createElement(\"div\",{className:\"flex items-center gap-2.5 px-5 py-5\"},N.createElement(\"div\",{className:\"w-9 h-9 rounded-xl bg-emerald-500 text-white font-black flex items-center justify-center\"},\"U\"),N.createElement(\"div\",null,N.createElement(\"div\",{className:\"text-white font-bold leading-tight\"},\"U.fin\"),N.createElement(\"div\",{className:\"text-[11px] text-slate-500 leading-tight\"},a.company))),N.createElement(\"nav\",{className:\"flex-1 px-3 space-y-1\"},he.map(([n,h,o])=>N.createElement(\"button\",{key:n,className:\"w-full flex items-center gap-3 px-3 py-2.5 rounded-xl text-sm transition-colors \"+(r===n?\"bg-emerald-500/15 text-emerald-400 font-medium\":\"hover:bg-white/5 hover:text-white\"),onClick:()=>l(n)},N.createElement(o,{size:18}),\" \",h))),N.createElement(\"button\",{className:\"px-6 py-4 text-left text-sm text-slate-500 hover:text-white\",onClick:G},\"\\u0412\\u044B\\u0439\\u0442\\u0438\")),N.createElement(\"main\",{className:\"flex-1 min-w-0\"},N.createElement(\"header\",{className:\"flex items-center justify-end gap-4 px-6 py-3 bg-white border-b border-slate-200 sticky top-0 z-40\"},N.createElement(\"div\",{className:\"relative\"},N.createElement(\"button\",{className:\"text-sm text-slate-600 hover:text-slate-900\",onClick:()=>g(!p)},\"\\u041D\\u0430 \\u0441\\u0447\\u0435\\u0442\\u0430\\u0445: \",N.createElement(\"b\",{className:t<0?\"text-rose-600\":\"text-emerald-600\"},B(t),\" \\u20BD\"),\" \\u25BE\"),p&&N.createElement(k,{className:\"absolute right-0 top-8 w-72 p-3 z-50 max-h-80 overflow-y-auto\"},a.accounts.filter(n=>n.active).sort((n,h)=>h.balance-n.balance).map(n=>N.createElement(\"div\",{key:n.id,className:\"flex justify-between text-sm py-1.5 border-b border-slate-50 last:border-0\"},N.createElement(\"span\",{className:\"text-slate-500 truncate mr-2\"},n.name),N.createElement(\"span\",{className:\"font-medium whitespace-nowrap \"+(n.balance<0?\"text-rose-600\":\"text-slate-800\")},B(n.balance),\" \\u20BD\")))))),N.createElement(\"div\",{onClick:()=>p&&g(!1)},r===\"dash\"&&N.createElement(le,{meta:a}),r===\"ops\"&&N.createElement(oe,{meta:a}),r===\"deals\"&&N.createElement(re,{meta:a}),r===\"plan\"&&N.createElement(de,null),r===\"reports\"&&N.createElement(me,null),r===\"refs\"&&N.createElement(pe,{meta:a,reload:v}),r===\"settings\"&&N.createElement(xe,{meta:a,reload:v}))))}be(document.getElementById(\"root\")).render(N.createElement(ye,null));\n",[],[140,174],"487b4856-449b-473f-8826-cc7cc8f2c0a6","app.part1.txt","af1b58e2-9d5a-11f1-a2c6-1607ee4eb77e",9,["D",1787660644814],"import N from\"https://esm.sh/react@18.2.0\";import{createRoot as be}from\"https://esm.sh/react-dom@18.2.0/client\";import{install as ve}from\"https://esm.sh/@twind/core@1.1.3\";import ce from\"https://esm.sh/@twind/preset-tailwind@1.1.4\";import fe from\"https://esm.sh/@twind/preset-autoprefix@1.0.7\";import e,{useEffect as O,useMemo as we,useRef as ke,useState as f}from\"https://esm.sh/react@18.2.0\";function q(){return localStorage.getItem(\"uf2_pin\")||\"\"}function R(s){localStorage.setItem(\"uf2_pin\",s)}function G(){localStorage.removeItem(\"uf2_pin\"),location.reload()}async function M(s,d={}){let r=await fetch(s,{...d,headers:{\"content-type\":\"application/json\",\"x-pin\":q(),...d.headers||{}},body:d.body?JSON.stringify(d.body):void 0});if(r.status===401)throw G(),new Error(\"unauthorized\");return r.json()}var B=(s,d=2)=>new Intl.NumberFormat(\"ru-RU\",{minimumFractionDigits:d,maximumFractionDigits:d}).format(s||0),T=s=>new Intl.NumberFormat(\"ru-RU\",{maximumFractionDigits:0}).format(Math.round(s||0)),c=s=>T(s)+\" \\u20BD\",Y=s=>{let d=Math.abs(s);return d>=1e6?(s/1e6).toLocaleString(\"ru-RU\",{maximumFractionDigits:1})+\" \\u043C\\u043B\\u043D\":d>=1e3?(s/1e3).toLocaleString(\"ru-RU\",{maximumFractionDigits:0})+\" \\u0442\\u044B\\u0441\":T(s)},Q=[\"\\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\"],Z=[\"\\u044F\\u043D\\u0432\",\"\\u0444\\u0435\\u0432\",\"\\u043C\\u0430\\u0440\",\"\\u0430\\u043F\\u0440\",\"\\u043C\\u0430\\u0439\",\"\\u0438\\u044E\\u043D\",\"\\u0438\\u044E\\u043B\",\"\\u0430\\u0432\\u0433\",\"\\u0441\\u0435\\u043D\",\"\\u043E\\u043A\\u0442\",\"\\u043D\\u043E\\u044F\",\"\\u0434\\u0435\\u043A\"],W=s=>{let[d,r]=s.split(\"-\");return Q[+r-1]+\" \"+d},E=s=>s?s.slice(0,10).split(\"-\").reverse().join(\".\"):\"\\u2014\",ee=()=>new Date().toISOString().slice(0,7),y={green:\"#10b981\",greenD:\"#059669\",red:\"#f43f5e\",blue:\"#3b82f6\",amber:\"#f59e0b\",violet:\"#8b5cf6\",slate:\"#64748b\",ink:\"#0f172a\",donut:[\"#10b981\",\"#3b82f6\",\"#f59e0b\",\"#8b5cf6\",\"#f43f5e\",\"#14b8a6\",\"#f97316\",\"#64748b\"]};function k({children:s,className:d=\"\",...r}){return e.createElement(\"div\",{className:\"bg-white rounded-2xl shadow-sm border border-slate-100 \"+d,...r},s)}function _({children:s,kind:d=\"primary\",className:r=\"\",...l}){return e.createElement(\"button\",{className:\"px-4 py-2 rounded-xl text-sm font-medium transition-colors disabled:opacity-40 \"+(d===\"primary\"?\"bg-emerald-500 hover:bg-emerald-600 text-white\":d===\"danger\"?\"bg-rose-50 hover:bg-rose-100 text-rose-600\":\"bg-slate-100 hover:bg-slate-200 text-slate-700\")+\" \"+r,...l},s)}function C({label:s,children:d,className:r=\"\"}){return e.createElement(\"label\",{className:\"block text-xs text-slate-500 \"+r},e.createElement(\"span\",{className:\"block mb-1\"},s),d)}var te=\"w-full border border-slate-200 rounded-xl px-3 py-2 text-sm text-slate-800 bg-white focus:outline-none focus:ring-2 focus:ring-emerald-200\";function S(s){return e.createElement(\"input\",{className:te,...s})}function $({children:s,...d}){return e.createElement(\"select\",{className:te,...d},s)}function V({title:s,onClose:d,children:r,wide:l=!1}){return e.createElement(\"div\",{className:\"fixed inset-0 z-50 flex items-start justify-center bg-slate-900/40 p-4 overflow-y-auto\",onClick:d},e.createElement(\"div\",{className:\"bg-white rounded-2xl shadow-xl w-full mt-8 \"+(l?\"max-w-3xl\":\"max-w-lg\"),onClick:a=>a.stopPropagation()},e.createElement(\"div\",{className:\"flex items-center justify-between px-5 py-4 border-b border-slate-100\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800\"},s),e.createElement(\"button\",{className:\"text-slate-400 hover:text-slate-600 text-xl leading-none\",onClick:d},\"\\xD7\")),e.createElement(\"div\",{className:\"p-5\"},r)))}function L({items:s,value:d,onChange:r}){return e.createElement(\"div\",{className:\"flex flex-wrap gap-2\"},s.map(([l,a,b])=>e.createElement(\"button\",{key:l,className:\"px-3 py-1.5 rounded-full text-sm transition-colors \"+(d===l?\"bg-slate-800 text-white\":\"bg-white border border-slate-200 text-slate-600 hover:bg-slate-50\"),onClick:()=>r(l)},a,b!==void 0&&e.createElement(\"span\",{className:\"opacity-60\"},\" \\xB7 \",b))))}function se({value:s,onChange:d}){let[r,l]=s.split(\"-\").map(Number),a=b=>{let p=new Date(r,l-1+b,1);d(p.getFullYear()+\"-\"+String(p.getMonth()+1).padStart(2,\"0\"))};return e.createElement(\"div\",{className:\"flex items-center gap-1 bg-white border border-slate-200 rounded-xl px-1 py-1\"},e.createElement(\"button\",{className:\"px-2 py-1 rounded-lg hover:bg-slate-100 text-slate-500\",onClick:()=>a(-1)},\"\\u2039\"),e.createElement(\"div\",{className:\"px-2 text-sm font-medium text-slate-700 w-32 text-center\"},W(s)),e.createElement(\"button\",{className:\"px-2 py-1 rounded-lg hover:bg-slate-100 text-slate-500\",onClick:()=>a(1)},\"\\u203A\"))}function I({value:s,max:d,color:r=y.green}){let l=d>0?Math.min(100,s/d*100):0;return e.createElement(\"div\",{className:\"h-2 rounded-full bg-slate-100 overflow-hidden\"},e.createElement(\"div\",{className:\"h-full rounded-full transition-all\",style:{width:l+\"%\",background:r}}))}function ae({data:s,height:d=260}){let l=d,a=56,b=26,p=12,g=s.flatMap(m=>[m.income??0,m.expense??0,m.np??0]),v=Math.max(1,...g),t=Math.min(0,...g),n=v-t||1,h=m=>p+(l-p-b)*(1-(m-t)/n),o=(900-a-16)/s.length,x=[0,.25,.5,.75,1].map(m=>t+n*m),u=s.map((m,j)=>m.np===null||m.np===void 0?null:[a+o*j+o/2,h(m.np)]),w=[],i=[];for(let m of u)m?i.push(m):(i.length&&w.push(i),i=[]);return i.length&&w.push(i),e.createElement(\"svg\",{viewBox:`0 0 900 ${l}`,className:\"w-full\",style:{height:d}},x.map((m,j)=>e.createElement(\"g\",{key:j},e.createElement(\"line\",{x1:a,x2:892,y1:h(m),y2:h(m),stroke:\"#eef2f7\"}),e.createElement(\"text\",{x:a-8,y:h(m)+4,textAnchor:\"end\",fontSize:\"11\",fill:\"#94a3b8\"},Y(m)))),s.map((m,j)=>{let D=a+o*j,K=Math.min(26,o/3-2);return e.createElement(\"g\",{key:j},m.income!==null&&m.income!==void 0&&m.income!==0&&e.createElement(\"rect\",{x:D+o/2-K-2,width:K,y:h(Math.max(0,m.income)),height:Math.abs(h(m.income)-h(0)),rx:4,fill:y.green,opacity:.9}),m.expense!==null&&m.expense!==void 0&&m.expense!==0&&e.createElement(\"rect\",{x:D+o/2+2,width:K,y:h(Math.max(0,m.expense)),height:Math.abs(h(m.expense)-h(0)),rx:4,fill:y.red,opacity:.75}),e.createElement(\"text\",{x:D+o/2,y:l-8,textAnchor:\"middle\",fontSize:\"11\",fill:\"#94a3b8\"},m.label))}),w.map((m,j)=>e.createElement(\"polyline\",{key:j,points:m.map(D=>D.join(\",\")).join(\" \"),fill:\"none\",stroke:y.ink,strokeWidth:2})),u.filter(Boolean).map((m,j)=>e.createElement(\"circle\",{key:j,cx:m[0],cy:m[1],r:3,fill:y.ink})))}function ne({items:s,size:d=168}){let r=s.reduce((g,v)=>g+v.value,0)||1,l=d/2,a=l-16,b=0,p=s.map((g,v)=>{let t=b/r*2*Math.PI-Math.PI/2;b+=g.value;let n=b/r*2*Math.PI-Math.PI/2;n-t>=2*Math.PI&&(n=t+2*Math.PI*.99985);let h=n-t>Math.PI?1:0,o=[l+a*Math.cos(t),l+a*Math.sin(t)],x=[l+a*Math.cos(n),l+a*Math.sin(n)];return e.createElement(\"path\",{key:v,d:`M ${o[0]} ${o[1]} A ${a} ${a} 0 ${h} 1 ${x[0]} ${x[1]}`,fill:\"none\",stroke:y.donut[v%y.donut.length],strokeWidth:22,strokeLinecap:\"butt\"})});return e.createElement(\"svg\",{width:d,height:d,viewBox:`0 0 ${d} ${d}`},p)}var F=s=>({size:d=18,color:r=\"currentColor\"})=>e.createElement(\"svg\",{width:d,height:d,viewBox:\"0 0 24 24\",fill:\"none\",stroke:r,strokeWidth:\"1.8\",strokeLinecap:\"round\",strokeLinejoin:\"round\"},e.createElement(\"path\",{d:s})),P={home:F(\"M3 10.5 12 3l9 7.5M5 9.5V21h14V9.5M9 21v-6h6v6\"),ops:F(\"M4 7h16M4 12h16M4 17h10\"),deals:F(\"M3 21h18M5 21V8l7-5 7 5v13M9 21v-6h6v6M9 11h.01M15 11h.01\"),plan:F(\"M8 3v3M16 3v3M4 8h16M5 5h14a1 1 0 0 1 1 1v14a1 1 0 0 1-1 1H5a1 1 0 0 1-1-1V6a1 1 0 0 1 1-1ZM8 13l2.5 2.5L16 10\"),report:F(\"M5 21V9m7 12V3m7 18v-8\"),refs:F(\"M4 19.5A2.5 2.5 0 0 1 6.5 17H20M4 19.5A2.5 2.5 0 0 0 6.5 22H20V2H6.5A2.5 2.5 0 0 0 4 4.5v15Z\"),gear:F(\"M12 15a3 3 0 1 0 0-6 3 3 0 0 0 0 6Zm8-3a8 8 0 0 1-.2 1.8l2 1.5-2 3.4-2.3-.9a8 8 0 0 1-3.1 1.8L14 22h-4l-.4-2.4a8 8 0 0 1-3.1-1.8l-2.3.9-2-3.4 2-1.5A8 8 0 0 1 4 12a8 8 0 0 1 .2-1.8l-2-1.5 2-3.4 2.3.9a8 8 0 0 1 3.1-1.8L10 2h4l.4 2.4a8 8 0 0 1 3.1 1.8l2.3-.9 2 3.4-2 1.5A8 8 0 0 1 20 12Z\"),in:F(\"M12 3v12m0 0 4-4m-4 4-4-4M4 21h16\"),out:F(\"M12 21V9m0 0 4 4m-4-4-4 4M4 3h16\"),wallet:F(\"M3 7a2 2 0 0 1 2-2h14a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V7Zm0 3h18M16 14h.01\"),building:F(\"M3 21h18M6 21V5a1 1 0 0 1 1-1h10a1 1 0 0 1 1 1v16M9 8h.01M12 8h.01M15 8h.01M9 12h.01M12 12h.01M15 12h.01M10 21v-4h4v4\"),person:F(\"M20 21a8 8 0 1 0-16 0M12 11a4 4 0 1 0 0-8 4 4 0 0 0 0 8Z\"),trend:F(\"M3 17l6-6 4 4 8-8M15 7h6v6\"),fire:F(\"M12 22a7 7 0 0 0 7-7c0-2-1-3.9-2.5-5.5S13.5 6 13 3c-3 2-5 4.5-5.5 7C6 11.5 5 13.3 5 15a7 7 0 0 0 7 7Z\"),bank:F(\"M3 21h18M4 10h16M12 3 3 8h18l-9-5ZM6 10v8m4-8v8m4-8v8m4-8v8\")};function A({icon:s,tint:d,label:r,value:l,sub:a}){return e.createElement(k,{className:\"p-4 flex items-start gap-3\"},e.createElement(\"div\",{className:\"w-10 h-10 rounded-xl flex items-center justify-center shrink-0\",style:{background:d+\"18\",color:d}},e.createElement(s,{size:20,color:d})),e.createElement(\"div\",{className:\"min-w-0\"},e.createElement(\"div\",{className:\"text-xs text-slate-500\"},r),e.createElement(\"div\",{className:\"text-xl font-bold text-slate-800 whitespace-nowrap\"},l),a&&e.createElement(\"div\",{className:\"text-xs text-slate-400 mt-0.5\"},a)))}function z({label:s,count:d,color:r,last:l=!1}){return e.createElement(\"div\",{className:\"flex items-center gap-2\"},e.createElement(\"div\",{className:\"text-center\"},e.createElement(\"div\",{className:\"w-16 h-16 rounded-2xl flex items-center justify-center text-2xl font-bold text-white\",style:{background:r}},d),e.createElement(\"div\",{className:\"text-xs text-slate-500 mt-1\"},s)),!l&&e.createElement(\"div\",{className:\"text-slate-300 text-xl pb-5\"},\"\\u2192\"))}function le({meta:s}){let[d,r]=f(ee()),[l,a]=f(null);if(O(()=>{M(`/api/dashboard?month=${d}`).then(a)},[d]),!l)return e.createElement(\"div\",{className:\"p-8 text-slate-400\"},\"\\u0417\\u0430\\u0433\\u0440\\u0443\\u0437\\u043A\\u0430\\u2026\");let b=d.slice(0,4),p=Array.from({length:12},(u,w)=>{let i=`${b}-${String(w+1).padStart(2,\"0\")}`,m=l.months[i]!==void 0;return{label:Z[w],income:m?l.months[i].income:null,expense:m?l.months[i].expense:null,np:m?l.months[i].income-l.months[i].expense:null}}),g=l.month_np,v=l.year_np,t=l.plan_month,n=l.plan_year,h=l.struct.reduce((u,w)=>u+w.value,0),o=(s?.accounts||[]).filter(u=>u.active),x=o.reduce((u,w)=>u+w.balance,0);return e.createElement(\"div\",{className:\"p-6 max-w-[1280px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-5\"},e.createElement(\"div\",null,e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u0414\\u0430\\u0448\\u0431\\u043E\\u0440\\u0434\"),e.createElement(\"div\",{className:\"text-sm text-slate-500\"},W(d),\" \\xB7 \\u0441\\u0432\\u043E\\u0434\\u043A\\u0430 \\u043F\\u043E \\u0430\\u0433\\u0435\\u043D\\u0442\\u0441\\u0442\\u0432\\u0443\")),e.createElement(se,{value:d,onChange:r})),e.createElement(\"div\",{className:\"grid grid-cols-2 lg:grid-cols-4 gap-3 mb-3\"},e.createElement(A,{icon:P.in,tint:y.green,label:\"\\u0417\\u0430\\u0448\\u043B\\u043E \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\",value:c(l.month_income),sub:`\\u0437\\u0430 \\u0433\\u043E\\u0434: ${c(l.year_income)}`}),e.createElement(A,{icon:P.out,tint:y.red,label:\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\",value:c(l.month_expense),sub:`\\u0437\\u0430 \\u0433\\u043E\\u0434: ${c(l.year_expense)}`}),e.createElement(A,{icon:P.trend,tint:g>=0?y.green:y.red,label:\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\",value:c(g),sub:`\\u0437\\u0430 \\u0433\\u043E\\u0434: ${c(v)}`}),e.createElement(A,{icon:P.fire,tint:y.amber,label:\"\\u041D\\u0430 \\u0437\\u0430\\u0445\\u043E\\u0434\\u0435\",value:c(l.pipeline),sub:`${l.pipeline_count} \\u043D\\u0435\\u0437\\u0430\\u043A\\u0440\\u044B\\u0442\\u044B\\u0445 \\u0441\\u0434\\u0435\\u043B\\u043E\\u043A`})),e.createElement(\"div\",{className:\"grid grid-cols-2 lg:grid-cols-5 gap-3 mb-6\"},e.createElement(A,{icon:P.building,tint:y.blue,label:\"\\u041E\\u0442 \\u0437\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\\u043E\\u0432\",value:c(l.from_developers),sub:\"\\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\"}),e.createElement(A,{icon:P.person,tint:y.violet,label:\"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\\u0430\\u043C\",value:c(l.to_brokers),sub:\"\\u0432\\u044B\\u043F\\u043B\\u0430\\u0442\\u044B \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\"}),e.createElement(A,{icon:P.deals,tint:y.green,label:\"\\u0421\\u0440\\u0435\\u0434\\u043D\\u0438\\u0439 \\u0447\\u0435\\u043A\",value:c(l.avg_check),sub:`${l.avg_check_count} \\u0441\\u0434\\u0435\\u043B\\u043E\\u043A \\u0432 \\u043C\\u0435\\u0441\\u044F\\u0446\\u0435`}),e.createElement(A,{icon:P.out,tint:y.slate,label:\"\\u0421\\u0440\\u0435\\u0434\\u043D\\u0438\\u0439 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\",value:c(l.avg_expense),sub:\"\\u0432 \\u043C\\u0435\\u0441\\u044F\\u0446 (6 \\u043C\\u0435\\u0441)\"}),e.createElement(A,{icon:P.bank,tint:y.violet,label:\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435\",value:c(l.fin_month.own+l.fin_month.debt),sub:`\\u043F\\u0440\\u0438\\u0432\\u043B\\u0435\\u0447\\u0435\\u043D\\u043E \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446 \\xB7 \\u043F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u043E ${Y(l.fin_month.repay)}`})),e.createElement(\"div\",{className:\"grid lg:grid-cols-3 gap-4 mb-6\"},e.createElement(k,{className:\"p-5\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-4\"},\"\\u041F\\u043E\\u043A\\u0430\\u0437\\u0430\\u0442\\u0435\\u043B\\u0438 \\u043C\\u0435\\u0441\\u044F\\u0446\\u0430\"),e.createElement(\"div\",{className:\"flex items-center justify-between\"},e.createElement(z,{label:\"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043A\\u0438\",count:l.funnel.deposits,color:y.amber}),e.createElement(z,{label:\"\\u0411\\u0440\\u043E\\u043D\\u0438\",count:l.funnel.booked,color:y.blue}),e.createElement(z,{label:\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\",count:l.funnel.deals,color:y.green}),e.createElement(z,{label:\"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\\u044B\",count:l.funnel.failed,color:y.red,last:!0}))),e.createElement(k,{className:\"p-5\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-3\"},\"\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\"),t?e.createElement(\"div\",{className:\"space-y-4\"},e.createElement(\"div\",null,e.createElement(\"div\",{className:\"flex justify-between text-sm mb-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0414\\u043E\\u0445\\u043E\\u0434\"),e.createElement(\"span\",{className:\"font-medium text-slate-700\"},c(l.month_income),\" / \",c(t.income))),e.createElement(I,{value:l.month_income,max:t.income})),e.createElement(\"div\",null,e.createElement(\"div\",{className:\"flex justify-between text-sm mb-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\"),e.createElement(\"span\",{className:\"font-medium text-slate-700\"},c(l.month_expense),\" / \",c(t.expense))),e.createElement(I,{value:l.month_expense,max:t.expense,color:y.red})),t.deals>0&&e.createElement(\"div\",null,e.createElement(\"div\",{className:\"flex justify-between text-sm mb-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\"),e.createElement(\"span\",{className:\"font-medium text-slate-700\"},l.funnel.deals,\" / \",t.deals)),e.createElement(I,{value:l.funnel.deals,max:t.deals,color:y.blue}))):e.createElement(\"div\",{className:\"text-sm text-slate-400\"},\"\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 \",W(d).toLowerCase(),\" \\u043D\\u0435 \\u0437\\u0430\\u0434\\u0430\\u043D \\u2014 \\u0440\\u0430\\u0437\\u0434\\u0435\\u043B \\xAB\\u041F\\u043B\\u0430\\u043D\\xBB\")),e.createElement(k,{className:\"p-5\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-3\"},\"\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 \",b,\" \\u0433\\u043E\\u0434\"),e.createElement(\"div\",{className:\"space-y-4\"},e.createElement(\"div\",null,e.createElement(\"div\",{className:\"flex justify-between text-sm mb-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0414\\u043E\\u0445\\u043E\\u0434\"),e.createElement(\"span\",{className:\"font-medium text-slate-700\"},c(l.year_income),\" / \",c(n.income))),e.createElement(I,{value:l.year_income,max:n.income})),e.createElement(\"div\",null,e.createElement(\"div\",{className:\"flex justify-between text-sm mb-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\"),e.createElement(\"span\",{className:\"font-medium text-slate-700\"},c(l.year_expense),\" / \",c(n.expense))),e.createElement(I,{value:l.year_expense,max:n.expense,color:y.red})),e.createElement(\"div\",{className:\"pt-1 border-t border-slate-100 flex justify-between text-sm\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C \\u0437\\u0430 \\u0433\\u043E\\u0434\"),e.createElement(\"span\",{className:\"font-bold \"+(v>=0?\"text-emerald-600\":\"text-rose-600\")},c(v)))))),e.createElement(k,{className:\"p-5 mb-6\"},e.createElement(\"div\",{className:\"flex items-center justify-between mb-2\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800\"},\"\\u0414\\u043E\\u0445\\u043E\\u0434\\u044B \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B \\xB7 \",b),e.createElement(\"div\",{className:\"flex items-center gap-4 text-xs text-slate-500\"},e.createElement(\"span\",{className:\"flex items-center gap-1.5\"},e.createElement(\"i\",{className:\"w-3 h-3 rounded-sm inline-block\",style:{background:y.green}}),\"\\u0414\\u043E\\u0445\\u043E\\u0434\\u044B\"),e.createElement(\"span\",{className:\"flex items-center gap-1.5\"},e.createElement(\"i\",{className:\"w-3 h-3 rounded-sm inline-block\",style:{background:y.red}}),\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B\"),e.createElement(\"span\",{className:\"flex items-center gap-1.5\"},e.createElement(\"i\",{className:\"w-4 h-0.5 inline-block\",style:{background:y.ink}}),\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C\"))),e.createElement(ae,{data:p,height:280})),e.createElement(k,{className:\"p-5 mb-6\"},e.createElement(\"div\",{className:\"flex items-baseline justify-between mb-1\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800\"},\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435\"),e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u043D\\u0435 \\u0432\\u0445\\u043E\\u0434\\u0438\\u0442 \\u0432 \\u0434\\u043E\\u0445\\u043E\\u0434\\u044B \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B \\u2014 \\u044D\\u0442\\u043E \\u0434\\u0432\\u0438\\u0436\\u0435\\u043D\\u0438\\u0435 \\u043A\\u0430\\u043F\\u0438\\u0442\\u0430\\u043B\\u0430\")),e.createElement(\"div\",{className:\"grid grid-cols-2 lg:grid-cols-4 gap-4 mt-3\"},e.createElement(\"div\",null,e.createElement(\"div\",{className:\"text-xs text-slate-500\"},\"\\u0412\\u043B\\u043E\\u0436\\u0435\\u043D\\u0438\\u044F \\u0443\\u0447\\u0440\\u0435\\u0434\\u0438\\u0442\\u0435\\u043B\\u0435\\u0439\"),e.createElement(\"div\",{className:\"text-lg font-bold text-violet-600\"},c(l.fin_year.own)),e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446: \",c(l.fin_month.own))),e.createElement(\"div\",null,e.createElement(\"div\",{className:\"text-xs text-slate-500\"},\"\\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B \\u0438 \\u0437\\u0430\\u0439\\u043C\\u044B \\u043F\\u0440\\u0438\\u0432\\u043B\\u0435\\u0447\\u0435\\u043D\\u043E\"),e.createElement(\"div\",{className:\"text-lg font-bold text-amber-600\"},c(l.fin_year.debt)),e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446: \",c(l.fin_month.debt))),e.createElement(\"div\",null,e.createElement(\"div\",{className:\"text-xs text-slate-500\"},\"\\u041F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u043E\"),e.createElement(\"div\",{className:\"text-lg font-bold text-slate-700\"},c(l.fin_year.repay)),e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446: \",c(l.fin_month.repay))),e.createElement(\"div\",null,e.createElement(\"div\",{className:\"text-xs text-slate-500\"},\"\\u0421\\u0430\\u043B\\u044C\\u0434\\u043E \\u043F\\u043E \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u0430\\u043C\"),e.createElement(\"div\",{className:\"text-lg font-bold \"+(l.credit_debt>0?\"text-rose-600\":\"text-emerald-600\")},c(Math.abs(l.credit_debt))),e.createElement(\"div\",{className:\"text-xs text-slate-400\"},l.credit_debt>0?\"\\u043D\\u0435\\u043F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u043D\\u044B\\u0439 \\u0434\\u043E\\u043B\\u0433\":\"\\u043F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u043E \\u0441\\u0432\\u0435\\u0440\\u0445 \\u043F\\u0440\\u0438\\u0432\\u043B\\u0435\\u0447\\u0451\\u043D\\u043D\\u043E\\u0433\\u043E\")))),e.createElement(\"div\",{className:\"grid lg:grid-cols-2 gap-4\"},e.createElement(k,{className:\"p-5\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-3\"},\"\\u0421\\u0442\\u0440\\u0443\\u043A\\u0442\\u0443\\u0440\\u0430 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u043E\\u0432 \\xB7 \",W(d)),h?e.createElement(\"div\",{className:\"flex items-center gap-5\"},e.createElement(ne,{items:l.struct}),e.createElement(\"div\",{className:\"flex-1 space-y-1.5 min-w-0\"},l.struct.map((u,w)=>e.createElement(\"div\",{key:w,className:\"flex items-center gap-2 text-sm\"},e.createElement(\"i\",{className:\"w-2.5 h-2.5 rounded-full shrink-0\",style:{background:y.donut[w%y.donut.length]}}),e.createElement(\"span\",{className:\"text-slate-600 truncate flex-1\"},u.name),e.createElement(\"span\",{className:\"text-slate-800 font-medium whitespace-nowrap\"},Y(u.value)),e.createElement(\"span\",{className:\"text-slate-400 w-10 text-right\"},Math.round(u.value/h*100),\"%\"))))):e.createElement(\"div\",{className:\"text-sm text-slate-400\"},\"\\u041D\\u0435\\u0442 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u043E\\u0432 \\u0437\\u0430 \\u043C\\u0435\\u0441\\u044F\\u0446\")),e.createElement(k,{className:\"p-5\"},e.createElement(\"div\",{className:\"flex justify-between items-center mb-3\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800\"},\"\\u0414\\u0435\\u043D\\u044C\\u0433\\u0438 \\u043D\\u0430 \\u0441\\u0447\\u0435\\u0442\\u0430\\u0445\"),e.createElement(\"div\",{className:\"font-bold text-emerald-600\"},B(x),\" \\u20BD\")),e.createElement(\"div\",{className:\"space-y-1 max-h-64 overflow-y-auto pr-1\"},o.sort((u,w)=>w.balance-u.balance).map(u=>e.createElement(\"div\",{key:u.id,className:\"flex justify-between items-center text-sm py-1.5 border-b border-slate-50 last:border-0\"},e.createElement(\"span\",{className:\"text-slate-600 truncate\"},u.name),e.createElement(\"span\",{className:\"font-medium whitespace-nowrap \"+(u.balance<0?\"text-rose-600\":\"text-slate-800\")},B(u.balance),\" \\u20BD\")))))))}function X({op:s,meta:d,onClose:r,onSaved:l}){let[a,b]=f(s||{date:new Date().toISOString().slice(0,10),op_type:\"income\",confirmed:1,amount:\"\"}),p=(t,n)=>b({...a,[t]:n}),g=(d.categories||[]).filter(t=>a.op_type===\"transfer\"?!1:t.kind===(a.op_type===\"income\"?\"income\":\"expense\")),v=async()=>{let t={...a,amount:Number(a.amount)||0};s?.id?await M(`/api/ops/${s.id}`,{method:\"PUT\",body:t}):await M(\"/api/ops\",{method:\"POST\",body:t}),l()};return e.createElement(V,{title:s?.id?\"\\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044F\":\"\\u041D\\u043E\\u0432\\u0430\\u044F \\u043E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044F\",onClose:r},e.createElement(\"div\",{className:\"grid grid-cols-2 gap-3\"},e.createElement(C,{label:\"\\u0422\\u0438\\u043F\"},e.createElement($,{value:a.op_type,onChange:t=>p(\"op_type\",t.target.value)},e.createElement(\"option\",{value:\"income\"},\"\\u041F\\u043E\\u0441\\u0442\\u0443\\u043F\\u043B\\u0435\\u043D\\u0438\\u0435\"),e.createElement(\"option\",{value:\"expense\"},\"\\u0412\\u044B\\u043F\\u043B\\u0430\\u0442\\u0430\"),e.createElement(\"option\",{value:\"transfer\"},\"\\u041F\\u0435\\u0440\\u0435\\u0432\\u043E\\u0434 \\u043C\\u0435\\u0436\\u0434\\u0443 \\u0441\\u0447\\u0435\\u0442\\u0430\\u043C\\u0438\"))),e.createElement(C,{label:\"\\u0414\\u0430\\u0442\\u0430\"},e.createElement(S,{type:\"date\",value:a.date||\"\",onChange:t=>p(\"date\",t.target.value)})),e.createElement(C,{label:\"\\u0421\\u0443\\u043C\\u043C\\u0430, \\u20BD\"},e.createElement(S,{type:\"number\",value:a.amount,onChange:t=>p(\"amount\",t.target.value)})),e.createElement(C,{label:a.op_type===\"transfer\"?\"\\u0421\\u043E \\u0441\\u0447\\u0451\\u0442\\u0430\":\"\\u0421\\u0447\\u0451\\u0442\"},e.createElement($,{value:a.account_id||\"\",onChange:t=>p(\"account_id\",t.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),d.accounts.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name)))),a.op_type===\"transfer\"&&e.createElement(C,{label:\"\\u041D\\u0430 \\u0441\\u0447\\u0451\\u0442\"},e.createElement($,{value:a.account2_id||\"\",onChange:t=>p(\"account2_id\",t.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),d.accounts.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name)))),a.op_type!==\"transfer\"&&e.createElement(e.Fragment,null,e.createElement(C,{label:\"\\u0421\\u0442\\u0430\\u0442\\u044C\\u044F\"},e.createElement($,{value:a.category_id||\"\",onChange:t=>p(\"category_id\",t.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),g.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name)))),e.createElement(C,{label:\"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\"},e.createElement($,{value:a.contractor_id||\"\",onChange:t=>p(\"contractor_id\",t.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),d.contractors.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name)))),e.createElement(C,{label:\"\\u041F\\u0440\\u043E\\u0435\\u043A\\u0442\"},e.createElement($,{value:a.project_id||\"\",onChange:t=>p(\"project_id\",t.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),d.projects.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name))))),e.createElement(C,{label:\"\\u041D\\u0430\\u0437\\u043D\\u0430\\u0447\\u0435\\u043D\\u0438\\u0435\",className:\"col-span-2\"},e.createElement(S,{value:a.purpose||\"\",onChange:t=>p(\"purpose\",t.target.value)})),e.createElement(\"label\",{className:\"col-span-2 flex items-center gap-2 text-sm text-slate-600\"},e.createElement(\"input\",{type:\"checkbox\",checked:!!a.confirmed,onChange:t=>p(\"confirmed\",t.target.checked?1:0)}),\"\\u041E\\u043F\\u043B\\u0430\\u0442\\u0430 \\u043F\\u043E\\u0434\\u0442\\u0432\\u0435\\u0440\\u0436\\u0434\\u0435\\u043D\\u0430 (\\u0444\\u0430\\u043A\\u0442)\")),e.createElement(\"div\",{className:\"flex justify-between mt-5\"},s?.id?e.createElement(_,{kind:\"danger\",onClick:async()=>{await M(`/api/ops/${s.id}`,{method:\"DELETE\"}),l()}},\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C\"):e.createElement(\"span\",null),e.createElement(\"div\",{className:\"flex gap-2\"},e.createElement(_,{kind:\"ghost\",onClick:r},\"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"),e.createElement(_,{onClick:v},\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\"))))}function oe({meta:s}){let d=new Date().toISOString().slice(0,7),[r,l]=f({from:d+\"-01\",to:\"\",type:\"\",account:\"\",search:\"\"}),[a,b]=f(null),[p,g]=f(null),v=()=>{let t=new URLSearchParams;for(let n in r)r[n]&&t.set(n,r[n]);t.set(\"limit\",\"200\"),M(\"/api/ops?\"+t.toString()).then(b)};return O(()=>{v()},[JSON.stringify(r)]),e.createElement(\"div\",{className:\"p-6 max-w-[1280px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-4\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u0438\"),e.createElement(_,{onClick:()=>g({})},\"+ \\u041E\\u043F\\u0435\\u0440\\u0430\\u0446\\u0438\\u044F\")),e.createElement(k,{className:\"p-4 mb-4 flex flex-wrap items-end gap-3\"},e.createElement(C,{label:\"\\u0421\"},e.createElement(S,{type:\"date\",value:r.from,onChange:t=>l({...r,from:t.target.value})})),e.createElement(C,{label:\"\\u041F\\u043E\"},e.createElement(S,{type:\"date\",value:r.to,onChange:t=>l({...r,to:t.target.value})})),e.createElement(C,{label:\"\\u0421\\u0447\\u0451\\u0442\"},e.createElement($,{value:r.account,onChange:t=>l({...r,account:t.target.value})},e.createElement(\"option\",{value:\"\"},\"\\u0412\\u0441\\u0435 \\u0441\\u0447\\u0435\\u0442\\u0430\"),s.accounts.map(t=>e.createElement(\"option\",{key:t.id,value:t.id},t.name)))),e.createElement(C,{label:\"\\u041F\\u043E\\u0438\\u0441\\u043A\",className:\"flex-1 min-w-40\"},e.createElement(S,{placeholder:\"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442, \\u0441\\u0442\\u0430\\u0442\\u044C\\u044F, \\u043D\\u0430\\u0437\\u043D\\u0430\\u0447\\u0435\\u043D\\u0438\\u0435\\u2026\",value:r.search,onChange:t=>l({...r,search:t.target.value})})),e.createElement(L,{items:[[\"\",\"\\u0412\\u0441\\u0435\"],[\"income\",\"\\u041F\\u043E\\u0441\\u0442\\u0443\\u043F\\u043B\\u0435\\u043D\\u0438\\u044F\"],[\"expense\",\"\\u0412\\u044B\\u043F\\u043B\\u0430\\u0442\\u044B\"],[\"transfer\",\"\\u041F\\u0435\\u0440\\u0435\\u0432\\u043E\\u0434\\u044B\"]],value:r.type,onChange:t=>l({...r,type:t})})),a&&e.createElement(e.Fragment,null,e.createElement(\"div\",{className:\"flex flex-wrap gap-x-6 gap-y-1 text-sm mb-3 px-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0412\\u0441\\u0435\\u0433\\u043E: \",e.createElement(\"b\",{className:\"text-slate-700\"},a.total)),e.createElement(\"span\",{className:\"text-emerald-600\"},\"\\u041F\\u043E\\u0441\\u0442\\u0443\\u043F\\u043B\\u0435\\u043D\\u0438\\u044F: \",e.createElement(\"b\",null,c(a.sum_income))),e.createElement(\"span\",{className:\"text-rose-600\"},\"\\u0412\\u044B\\u043F\\u043B\\u0430\\u0442\\u044B: \",e.createElement(\"b\",null,c(a.sum_expense))),(a.sum_fin_in>0||a.sum_fin_out>0)&&e.createElement(\"span\",{className:\"text-violet-600\",title:\"\\u0412\\u043B\\u043E\\u0436\\u0435\\u043D\\u0438\\u044F \\u0443\\u0447\\u0440\\u0435\\u0434\\u0438\\u0442\\u0435\\u043B\\u0435\\u0439, \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B \\u0438 \\u0437\\u0430\\u0439\\u043C\\u044B \\u2014 \\u0432\\u043D\\u0435 \\u0434\\u043E\\u0445\\u043E\\u0434\\u043E\\u0432 \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u043E\\u0432\"},\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435: \",e.createElement(\"b\",null,\"+\",c(a.sum_fin_in)),\" / \",e.createElement(\"b\",null,\"\\u2212\",c(a.sum_fin_out)))),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u0414\\u0430\\u0442\\u0430\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0443\\u043C\\u043C\\u0430\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0447\\u0451\\u0442\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0442\\u0430\\u0442\\u044C\\u044F\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442 / \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u041D\\u0430\\u0437\\u043D\\u0430\\u0447\\u0435\\u043D\\u0438\\u0435\"))),e.createElement(\"tbody\",null,a.items.map(t=>e.createElement(\"tr\",{key:t.id,className:\"border-b border-slate-50 hover:bg-slate-50 cursor-pointer\",onClick:()=>g(t)},e.createElement(\"td\",{className:\"p-3 whitespace-nowrap text-slate-500\"},E(t.date),!t.confirmed&&e.createElement(\"span\",{className:\"ml-1 text-amber-500\",title:\"\\u041F\\u043B\\u0430\\u043D\"},\"\\u25F7\")),e.createElement(\"td\",{className:\"p-3 whitespace-nowrap font-medium \"+(t.op_type===\"income\"?\"text-emerald-600\":t.op_type===\"expense\"?\"text-rose-600\":\"text-slate-500\")},t.op_type===\"income\"?\"+\":t.op_type===\"expense\"?\"\\u2212\":\"\\u21C4\",\" \",B(t.amount)),e.createElement(\"td\",{className:\"p-3 text-slate-600 whitespace-nowrap\"},t.account,t.op_type===\"transfer\"&&t.account2?\" \\u2192 \"+t.account2:\"\"),e.createElement(\"td\",{className:\"p-3 text-slate-600\"},t.category||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-slate-600\"},t.contractor||\"\\u2014\",t.deal?e.createElement(\"span\",{className:\"text-slate-400\"},\" \\xB7 \",t.deal):\"\"),e.createElement(\"td\",{className:\"p-3 text-slate-400 max-w-64 truncate\"},t.purpose))))))),p&&e.createElement(X,{op:p.id?p:null,meta:s,onClose:()=>g(null),onSaved:()=>{g(null),v()}}))}var U={deposit:{label:\"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A\",color:y.amber,bg:\"bg-amber-50 text-amber-600\"},booked:{label:\"\\u0411\\u0440\\u043E\\u043D\\u044C\",color:y.blue,bg:\"bg-blue-50 text-blue-600\"},deal:{label:\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\",color:y.green,bg:\"bg-emerald-50 text-emerald-600\"},paid:{label:\"\\u041E\\u043F\\u043B\\u0430\\u0447\\u0435\\u043D\\u0430\",color:y.greenD,bg:\"bg-emerald-100 text-emerald-700\"},failed:{label:\"\\u0420\\u0430\\u0437\\u0432\\u0430\\u043B\",color:y.red,bg:\"bg-rose-50 text-rose-600\"}};function ie({deal:s,meta:d,onClose:r,onSaved:l}){let[a,b]=f(s||{status:\"deposit\",d_deposit:new Date().toISOString().slice(0,10)}),p=(n,h)=>b({...a,[n]:h}),g=d.contractors.filter(n=>n.role===\"developer\"),v=d.contractors.filter(n=>n.role===\"broker\"),t=async()=>{let n={...a,price:Number(a.price)||0,commission:Number(a.commission)||0,broker_fee:Number(a.broker_fee)||0,deposit_amount:Number(a.deposit_amount)||0};s?.id?await M(`/api/deals/${s.id}`,{method:\"PUT\",body:n}):await M(\"/api/deals\",{method:\"POST\",body:n}),l()};return e.createElement(V,{title:s?.id?\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\":\"\\u041D\\u043E\\u0432\\u0430\\u044F \\u0441\\u0434\\u0435\\u043B\\u043A\\u0430\",onClose:r,wide:!0},e.createElement(\"div\",{className:\"grid grid-cols-2 lg:grid-cols-3 gap-3\"},e.createElement(C,{label:\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435 / \\u2116 \\u0441\\u0434\\u0435\\u043B\\u043A\\u0438\"},e.createElement(S,{value:a.name||\"\",onChange:n=>p(\"name\",n.target.value)})),e.createElement(C,{label:\"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442\"},e.createElement(S,{value:a.client||\"\",onChange:n=>p(\"client\",n.target.value)})),e.createElement(C,{label:\"\\u041E\\u0431\\u044A\\u0435\\u043A\\u0442 (\\u0416\\u041A, \\u043A\\u0432\\u0430\\u0440\\u0442\\u0438\\u0440\\u0430)\"},e.createElement(S,{value:a.object_name||\"\",onChange:n=>p(\"object_name\",n.target.value)})),e.createElement(C,{label:\"\\u0417\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\"},e.createElement($,{value:a.developer_id||\"\",onChange:n=>p(\"developer_id\",n.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),g.map(n=>e.createElement(\"option\",{key:n.id,value:n.id},n.name)))),e.createElement(C,{label:\"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\"},e.createElement($,{value:a.broker_id||\"\",onChange:n=>p(\"broker_id\",n.target.value||null)},e.createElement(\"option\",{value:\"\"},\"\\u2014\"),v.map(n=>e.createElement(\"option\",{key:n.id,value:n.id},n.name)))),e.createElement(C,{label:\"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\"},e.createElement($,{value:a.status,onChange:n=>p(\"status\",n.target.value)},Object.keys(U).map(n=>e.createElement(\"option\",{key:n,value:n},U[n].label)))),e.createElement(C,{label:\"\\u0421\\u0442\\u043E\\u0438\\u043C\\u043E\\u0441\\u0442\\u044C \\u043E\\u0431\\u044A\\u0435\\u043A\\u0442\\u0430, \\u20BD\"},e.createElement(S,{type:\"number\",value:a.price||\"\",onChange:n=>p(\"price\",n.target.value)})),e.createElement(C,{label:\"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F \\u0430\\u0433\\u0435\\u043D\\u0442\\u0441\\u0442\\u0432\\u0430, \\u20BD\"},e.createElement(S,{type:\"number\",value:a.commission||\"\",onChange:n=>p(\"commission\",n.target.value)})),e.createElement(C,{label:\"\\u0412\\u043E\\u0437\\u043D\\u0430\\u0433\\u0440\\u0430\\u0436\\u0434\\u0435\\u043D\\u0438\\u0435 \\u0431\\u0440\\u043E\\u043A\\u0435\\u0440\\u0430, \\u20BD\"},e.createElement(S,{type:\"number\",value:a.broker_fee||\"\",onChange:n=>p(\"broker_fee\",n.target.value)})),e.createElement(C,{label:\"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A, \\u20BD\"},e.createElement(S,{type:\"number\",value:a.deposit_amount||\"\",onChange:n=>p(\"deposit_amount\",n.target.value)})),e.createElement(C,{label:\"\\u0414\\u0430\\u0442\\u0430 \\u0437\\u0430\\u0434\\u0430\\u0442\\u043A\\u0430\"},e.createElement(S,{type:\"date\",value:a.d_deposit||\"\",onChange:n=>p(\"d_deposit\",n.target.value)})),e.createElement(C,{label:\"\\u0414\\u0430\\u0442\\u0430 \\u0431\\u0440\\u043E\\u043D\\u0438\"},e.createElement(S,{type:\"date\",value:a.d_booked||\"\",onChange:n=>p(\"d_booked\",n.target.value)})),e.createElement(C,{label:\"\\u0414\\u0430\\u0442\\u0430 \\u0441\\u0434\\u0435\\u043B\\u043A\\u0438\"},e.createElement(S,{type:\"date\",value:a.d_deal||\"\",onChange:n=>p(\"d_deal\",n.target.value)})),e.createElement(C,{label:\"\\u0414\\u0430\\u0442\\u0430 \\u0437\\u0430\\u043A\\u0440\\u044B\\u0442\\u0438\\u044F\"},e.createElement(S,{type:\"date\",value:a.d_closed||\"\",onChange:n=>p(\"d_closed\",n.target.value)})),e.createElement(C,{label:\"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\",className:\"col-span-2\"},e.createElement(S,{value:a.comment||\"\",onChange:n=>p(\"comment\",n.target.value)}))),e.createElement(\"div\",{className:\"flex justify-between mt-5\"},s?.id?e.createElement(_,{kind:\"danger\",onClick:async()=>{confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C \\u0441\\u0434\\u0435\\u043B\\u043A\\u0443?\")&&(await M(`/api/deals/${s.id}`,{method:\"DELETE\"}),l())}},\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C\"):e.createElement(\"span\",null),e.createElement(\"div\",{className:\"flex gap-2\"},e.createElement(_,{kind:\"ghost\",onClick:r},\"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"),e.createElement(_,{onClick:t},\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\"))))}function ue({deal:s,meta:d,onClose:r,onChanged:l}){let[a,b]=f(null),[p,g]=f([]),[v,t]=f(\"\"),[n,h]=f(!1),[o,x]=f(null),u=()=>{M(`/api/ops?deal=${s.id}&limit=300`).then(b),M(`/api/deals/${s.id}/notes`).then(i=>g(i.items))};O(()=>{u()},[s.id]);let w=U[s.status]||U.deal;return e.createElement(V,{title:e.createElement(\"span\",null,s.name,\" \",e.createElement(\"span\",{className:\"ml-2 text-xs px-2 py-0.5 rounded-full \"+w.bg},w.label)),onClose:r,wide:!0},e.createElement(\"div\",{className:\"grid grid-cols-2 lg:grid-cols-4 gap-3 mb-4\"},e.createElement(k,{className:\"p-3\"},e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F\"),e.createElement(\"div\",{className:\"font-bold text-slate-800\"},c(s.commission))),e.createElement(k,{className:\"p-3\"},e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u041F\\u043E\\u043B\\u0443\\u0447\\u0435\\u043D\\u043E\"),e.createElement(\"div\",{className:\"font-bold text-emerald-600\"},c(s.received)),e.createElement(I,{value:s.received,max:s.commission||1})),e.createElement(k,{className:\"p-3\"},e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B \\u043F\\u043E \\u0441\\u0434\\u0435\\u043B\\u043A\\u0435\"),e.createElement(\"div\",{className:\"font-bold text-rose-600\"},c(s.spent))),e.createElement(k,{className:\"p-3\"},e.createElement(\"div\",{className:\"text-xs text-slate-400\"},\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C\"),e.createElement(\"div\",{className:\"font-bold \"+(s.received-s.spent>=0?\"text-emerald-600\":\"text-rose-600\")},c(s.received-s.spent)))),e.createElement(\"div\",{className:\"text-sm text-slate-500 mb-4 space-y-0.5\"},s.client&&e.createElement(\"div\",null,\"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442: \",e.createElement(\"b\",{className:\"text-slate-700\"},s.client)),s.object_name&&e.createElement(\"div\",null,\"\\u041E\\u0431\\u044A\\u0435\\u043A\\u0442: \",e.createElement(\"b\",{className:\"text-slate-700\"},s.object_name)),s.developer&&e.createElement(\"div\",null,\"\\u0417\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A: \",e.createElement(\"b\",{className:\"text-slate-700\"},s.developer)),s.broker&&e.createElement(\"div\",null,\"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440: \",e.createElement(\"b\",{className:\"text-slate-700\"},s.broker),\" \",s.broker_fee?`(${c(s.broker_fee)})`:\"\"),e.createElement(\"div\",null,\"\\u0417\\u0430\\u0434\\u0430\\u0442\\u043E\\u043A: \",E(s.d_deposit),s.deposit_amount?` \\xB7 ${c(s.deposit_amount)}`:\"\",\" \\xB7 \\u0411\\u0440\\u043E\\u043D\\u044C: \",E(s.d_booked),\" \\xB7 \\u0421\\u0434\\u0435\\u043B\\u043A\\u0430: \",E(s.d_deal))),e.createElement(\"div\",{className:\"flex items-center justify-between mb-2\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800\"},\"\\u041F\\u043B\\u0430\\u0442\\u0435\\u0436\\u0438 \\u043F\\u043E \\u0441\\u0434\\u0435\\u043B\\u043A\\u0435\"),e.createElement(\"div\",{className:\"flex gap-2\"},e.createElement(_,{kind:\"ghost\",onClick:()=>h(!0)},\"\\u0420\\u0435\\u0434\\u0430\\u043A\\u0442\\u0438\\u0440\\u043E\\u0432\\u0430\\u0442\\u044C\"),e.createElement(_,{onClick:()=>x({op_type:\"income\",deal_id:s.id,confirmed:1,date:new Date().toISOString().slice(0,10)})},\"+ \\u041F\\u043B\\u0430\\u0442\\u0451\\u0436\"))),e.createElement(\"div\",{className:\"max-h-52 overflow-y-auto mb-4 border border-slate-100 rounded-xl\"},a?.items?.length?a.items.map(i=>e.createElement(\"div\",{key:i.id,className:\"flex justify-between items-center px-3 py-2 border-b border-slate-50 text-sm hover:bg-slate-50 cursor-pointer\",onClick:()=>x(i)},e.createElement(\"span\",{className:\"text-slate-500\"},E(i.date),\" \\xB7 \",i.category||i.purpose||\"\\u2014\"),e.createElement(\"span\",{className:i.op_type===\"income\"?\"text-emerald-600 font-medium\":\"text-rose-600 font-medium\"},i.op_type===\"income\"?\"+\":\"\\u2212\",B(i.amount)))):e.createElement(\"div\",{className:\"p-3 text-sm text-slate-400\"},\"\\u041F\\u043B\\u0430\\u0442\\u0435\\u0436\\u0435\\u0439 \\u043D\\u0435\\u0442\")),e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-2\"},\"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0438\"),e.createElement(\"div\",{className:\"flex gap-2 mb-2\"},e.createElement(S,{placeholder:\"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\\u2026\",value:v,onChange:i=>t(i.target.value)}),e.createElement(_,{onClick:async()=>{v.trim()&&(await M(`/api/deals/${s.id}/notes`,{method:\"POST\",body:{text:v}}),t(\"\"),u())}},\"OK\")),e.createElement(\"div\",{className:\"space-y-1 max-h-36 overflow-y-auto\"},p.map(i=>e.createElement(\"div\",{key:i.id,className:\"text-sm bg-slate-50 rounded-lg px-3 py-2\"},e.createElement(\"span\",{className:\"text-slate-400 text-xs mr-2\"},E(i.created_at)),e.createElement(\"span\",{className:\"text-slate-700\"},i.text)))),n&&e.createElement(ie,{deal:s,meta:d,onClose:()=>h(!1),onSaved:()=>{h(!1),l(),r()}}),o&&e.createElement(X,{op:(o.id,o),meta:d,onClose:()=>x(null),onSaved:()=>{x(null),u(),l()}}))}function re({meta:s}){let[d,r]=f(\"\"),[l,a]=f(\"\"),[b,p]=f(null),[g,v]=f(null),[t,n]=f(null),h=()=>{let i=new URLSearchParams;d&&i.set(\"status\",d),l&&i.set(\"search\",l),M(\"/api/deals?\"+i.toString()).then(p)};O(()=>{h()},[d,l]);let o=b?.items||[],x={};for(let i of o)x[i.status]=(x[i.status]||0)+1;let u=o.reduce((i,m)=>i+m.commission,0),w=o.reduce((i,m)=>i+m.received,0);return e.createElement(\"div\",{className:\"p-6 max-w-[1280px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-4\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438\"),e.createElement(_,{onClick:()=>v({})},\"+ \\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\")),e.createElement(\"div\",{className:\"flex flex-wrap items-center gap-3 mb-4\"},e.createElement(L,{items:[[\"\",\"\\u0412\\u0441\\u0435\",o.length],...Object.keys(U).map(i=>[i,U[i].label])],value:d,onChange:r}),e.createElement(\"input\",{className:\"border border-slate-200 rounded-full px-4 py-1.5 text-sm bg-white focus:outline-none focus:ring-2 focus:ring-emerald-200\",placeholder:\"\\u041F\\u043E\\u0438\\u0441\\u043A\\u2026\",value:l,onChange:i=>a(i.target.value)})),e.createElement(\"div\",{className:\"flex gap-6 text-sm mb-3 px-1\"},e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u0421\\u0434\\u0435\\u043B\\u043E\\u043A: \",e.createElement(\"b\",{className:\"text-slate-700\"},o.length)),e.createElement(\"span\",{className:\"text-slate-500\"},\"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u0438: \",e.createElement(\"b\",{className:\"text-slate-700\"},c(u))),e.createElement(\"span\",{className:\"text-emerald-600\"},\"\\u041F\\u043E\\u043B\\u0443\\u0447\\u0435\\u043D\\u043E: \",e.createElement(\"b\",null,c(w)))),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0430\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442 / \\u043E\\u0431\\u044A\\u0435\\u043A\\u0442\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u041A\\u043E\\u043C\\u0438\\u0441\\u0441\\u0438\\u044F\"),e.createElement(\"th\",{className:\"p-3 w-40\"},\"\\u041F\\u043E\\u043B\\u0443\\u0447\\u0435\\u043D\\u043E\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0414\\u0430\\u0442\\u0430\"))),e.createElement(\"tbody\",null,o.map(i=>{let m=U[i.status]||U.deal;return e.createElement(\"tr\",{key:i.id,className:\"border-b border-slate-50 hover:bg-slate-50 cursor-pointer\",onClick:()=>n(i)},e.createElement(\"td\",{className:\"p-3 font-medium text-slate-700 whitespace-nowrap\"},i.name),e.createElement(\"td\",{className:\"p-3\"},e.createElement(\"span\",{className:\"text-xs px-2 py-1 rounded-full whitespace-nowrap \"+m.bg},m.label)),e.createElement(\"td\",{className:\"p-3 text-slate-500 max-w-56 truncate\"},[i.client,i.object_name].filter(Boolean).join(\" \\xB7 \")||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-right font-medium text-slate-800 whitespace-nowrap\"},B(i.commission)),e.createElement(\"td\",{className:\"p-3\"},e.createElement(\"div\",{className:\"text-xs text-slate-500 mb-1\"},B(i.received)),e.createElement(I,{value:i.received,max:i.commission||1})),e.createElement(\"td\",{className:\"p-3 text-slate-400 whitespace-nowrap\"},E(i.d_deal||i.created_at)))})))),g&&e.createElement(ie,{deal:null,meta:s,onClose:()=>v(null),onSaved:()=>{v(null),h()}}),t&&e.createElement(ue,{deal:t,meta:s,onClose:()=>n(null),onChanged:h}))}function de(){let[s,d]=f(new Date().getFullYear()),[r,l]=f(null),[a,b]=f({}),p=()=>M(`/api/plans?year=${s}`).then(i=>{l(i),b({})});if(O(()=>{p()},[s]),!r)return e.createElement(\"div\",{className:\"p-8 text-slate-400\"},\"\\u0417\\u0430\\u0433\\u0440\\u0443\\u0437\\u043A\\u0430\\u2026\");let g={};for(let i of r.items)g[i.period]=i;let v=Array.from({length:12},(i,m)=>`${s}-${String(m+1).padStart(2,\"0\")}`),t=(i,m)=>a[i]?.[m]!==void 0?a[i][m]:g[i]?.[m]??\"\",n=(i,m,j)=>b({...a,[i]:{...a[i]||{},[m]:j}}),h=Object.keys(a).length>0,o=async()=>{for(let i of Object.keys(a))await M(`/api/plans/${i}`,{method:\"PUT\",body:{income:Number(t(i,\"income\"))||0,expense:Number(t(i,\"expense\"))||0,deals:Number(t(i,\"deals\"))||0}});p()},x={income:0,expense:0,deals:0},u={income:0,expense:0,deals:0};for(let i of v){x.income+=Number(t(i,\"income\"))||0,x.expense+=Number(t(i,\"expense\"))||0,x.deals+=Number(t(i,\"deals\"))||0;let m=r.fact[i]||{};u.income+=m.income||0,u.expense+=m.expense||0,u.deals+=m.deals||0}let w=\"w-28 border border-slate-200 rounded-lg px-2 py-1 text-sm text-right focus:outline-none focus:ring-2 focus:ring-emerald-200\";return e.createElement(\"div\",{className:\"p-6 max-w-[1100px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-4\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u041F\\u043B\\u0430\\u043D \\u043D\\u0430 \",s,\" \\u0433\\u043E\\u0434\"),e.createElement(\"div\",{className:\"flex items-center gap-2\"},e.createElement(_,{kind:\"ghost\",onClick:()=>d(s-1)},\"\\u2039 \",s-1),e.createElement(_,{kind:\"ghost\",onClick:()=>d(s+1)},s+1,\" \\u203A\"),h&&e.createElement(_,{onClick:o},\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C \\u043F\\u043B\\u0430\\u043D\"))),e.createElement(\"div\",{className:\"grid lg:grid-cols-3 gap-3 mb-5\"},e.createElement(k,{className:\"p-4\"},e.createElement(\"div\",{className:\"text-xs text-slate-500 mb-1\"},\"\\u0414\\u043E\\u0445\\u043E\\u0434: \\u043F\\u043B\\u0430\\u043D \",c(x.income)),e.createElement(\"div\",{className:\"font-bold text-slate-800 mb-2\"},\"\\u0444\\u0430\\u043A\\u0442 \",c(u.income)),e.createElement(I,{value:u.income,max:x.income})),e.createElement(k,{className:\"p-4\"},e.createElement(\"div\",{className:\"text-xs text-slate-500 mb-1\"},\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434: \\u043F\\u043B\\u0430\\u043D \",c(x.expense)),e.createElement(\"div\",{className:\"font-bold text-slate-800 mb-2\"},\"\\u0444\\u0430\\u043A\\u0442 \",c(u.expense)),e.createElement(I,{value:u.expense,max:x.expense,color:y.red})),e.createElement(k,{className:\"p-4\"},e.createElement(\"div\",{className:\"text-xs text-slate-500 mb-1\"},\"\\u0421\\u0434\\u0435\\u043B\\u043A\\u0438: \\u043F\\u043B\\u0430\\u043D \",x.deals||\"\\u2014\"),e.createElement(\"div\",{className:\"font-bold text-slate-800 mb-2\"},\"\\u0444\\u0430\\u043A\\u0442 \",u.deals),e.createElement(I,{value:u.deals,max:x.deals||1,color:y.blue}))),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u041C\\u0435\\u0441\\u044F\\u0446\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u041F\\u043B\\u0430\\u043D: \\u0434\\u043E\\u0445\\u043E\\u0434\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u0424\\u0430\\u043A\\u0442: \\u0434\\u043E\\u0445\\u043E\\u0434\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u041F\\u043B\\u0430\\u043D: \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u0424\\u0430\\u043A\\u0442: \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u041F\\u043B\\u0430\\u043D: \\u0441\\u0434\\u0435\\u043B\\u043A\\u0438\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u0424\\u0430\\u043A\\u0442: \\u0441\\u0434\\u0435\\u043B\\u043A\\u0438\"))),e.createElement(\"tbody\",null,v.map((i,m)=>{let j=r.fact[i]||{};return e.createElement(\"tr\",{key:i,className:\"border-b border-slate-50\"},e.createElement(\"td\",{className:\"p-3 text-slate-600\"},Q[m]),e.createElement(\"td\",{className:\"p-2 text-right\"},e.createElement(\"input\",{className:w,value:t(i,\"income\"),onChange:D=>n(i,\"income\",D.target.value)})),e.createElement(\"td\",{className:\"p-3 text-right text-emerald-600 font-medium whitespace-nowrap\"},j.income?T(j.income):\"\\u2014\"),e.createElement(\"td\",{className:\"p-2 text-right\"},e.createElement(\"input\",{className:w,value:t(i,\"expense\"),onChange:D=>n(i,\"expense\",D.target.value)})),e.createElement(\"td\",{className:\"p-3 text-right text-rose-600 font-medium whitespace-nowrap\"},j.expense?T(j.expense):\"\\u2014\"),e.createElement(\"td\",{className:\"p-2 text-right\"},e.createElement(\"input\",{className:w+\" w-16\",value:t(i,\"deals\"),onChange:D=>n(i,\"deals\",D.target.value)})),e.createElement(\"td\",{className:\"p-3 text-right text-slate-700 font-medium\"},j.deals||\"\\u2014\"))}),e.createElement(\"tr\",{className:\"font-bold text-slate-800\"},e.createElement(\"td\",{className:\"p-3\"},\"\\u0418\\u0442\\u043E\\u0433\\u043E\"),e.createElement(\"td\",{className:\"p-3 text-right\"},T(x.income)),e.createElement(\"td\",{className:\"p-3 text-right text-emerald-600\"},T(u.income)),e.createElement(\"td\",{className:\"p-3 text-right\"},T(x.expense)),e.createElement(\"td\",{className:\"p-3 text-right text-rose-600\"},T(u.expense)),e.createElement(\"td\",{className:\"p-3 text-right\"},x.deals||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-right\"},u.deals))))),e.createElement(\"div\",{className:\"text-xs text-slate-400 mt-3\"},\"\\u041F\\u043B\\u0430\\u043D \\u0440\\u0435\\u0434\\u0430\\u043A\\u0442\\u0438\\u0440\\u0443\\u0435\\u0442\\u0441\\u044F \\u043F\\u0440\\u044F\\u043C\\u043E \\u0432 \\u0442\\u0430\\u0431\\u043B\\u0438\\u0446\\u0435 \\u2014 \\u0438\\u0437\\u043C\\u0435\\u043D\\u0435\\u043D\\u0438\\u044F \\u0441\\u043E\\u0445\\u0440\\u0430\\u043D\\u044F\\u044E\\u0442\\u0441\\u044F \\u043A\\u043D\\u043E\\u043F\\u043A\\u043E\\u0439 \\xAB\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C \\u043F\\u043B\\u0430\\u043D\\xBB. \\u041D\\u0430\\u0447\\u0430\\u043B\\u044C\\u043D\\u044B\\u0435 \\u0437\\u043D\\u0430\\u0447\\u0435\\u043D\\u0438\\u044F \\u043F\\u0435\\u0440\\u0435\\u043D\\u0435\\u0441\\u0435\\u043D\\u044B \\u0438\\u0437 \\u0432\\u0430\\u0448\\u0438\\u0445 \\u0411\\u0414\\u0420-\\u0431\\u044E\\u0434\\u0436\\u0435\\u0442\\u043E\\u0432.\"))}function me(){let[s,d]=f(\"dds\"),[r,l]=f(new Date().getFullYear()),[a,b]=f(null),[p,g]=f(null);O(()=>{M(`/api/report/cashflow?year=${r}`).then(b),M(`/api/report/pl?year=${r}`).then(g)},[r]);let v=Array.from({length:12},(o,x)=>`${r}-${String(x+1).padStart(2,\"0\")}`),t={};if(a)for(let o of a.rows){let x=o.kind+\"|\"+o.name+\"|\"+o.cls;t[x]||(t[x]={name:o.name,kind:o.kind,cls:o.cls,fin:o.fin_type||\"\",byM:{},total:0}),t[x].byM[o.month]=(t[x].byM[o.month]||0)+o.value,t[x].total+=o.value}let n=(o,x)=>Object.values(t).filter(u=>o===\"income\"?u.kind===\"income\":u.kind!==\"income\").filter(u=>x===\"fin\"?u.fin!==\"\":x===\"other\"?u.fin===\"\"&&u.cls!==\"pl\":u.fin===\"\"&&u.cls===\"pl\").sort((u,w)=>w.total-u.total),h=({title:o,list:x,sign:u})=>e.createElement(e.Fragment,null,e.createElement(\"tr\",{className:\"bg-slate-50 font-semibold text-slate-700\"},e.createElement(\"td\",{className:\"p-2 sticky left-0 bg-slate-50\"},o),v.map(w=>e.createElement(\"td\",{key:w,className:\"p-2 text-right\"},Y(x.reduce((i,m)=>i+(m.byM[w]||0),0)*u))),e.createElement(\"td\",{className:\"p-2 text-right\"},T(x.reduce((w,i)=>w+i.total,0)*u))),x.map((w,i)=>e.createElement(\"tr\",{key:i,className:\"border-b border-slate-50 text-slate-600\"},e.createElement(\"td\",{className:\"p-2 pl-5 sticky left-0 bg-white\"},w.name),v.map(m=>e.createElement(\"td\",{key:m,className:\"p-2 text-right text-xs\"},w.byM[m]?T(w.byM[m]*u):\"\")),e.createElement(\"td\",{className:\"p-2 text-right text-xs font-medium\"},T(w.total*u)))));return e.createElement(\"div\",{className:\"p-6 max-w-[1280px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-4\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u041E\\u0442\\u0447\\u0451\\u0442\\u044B \\xB7 \",r),e.createElement(\"div\",{className:\"flex items-center gap-2\"},e.createElement(L,{items:[[\"dds\",\"\\u0414\\u0432\\u0438\\u0436\\u0435\\u043D\\u0438\\u0435 \\u0434\\u0435\\u043D\\u0435\\u0433\"],[\"pl\",\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C\"]],value:s,onChange:d}),e.createElement(_,{kind:\"ghost\",onClick:()=>l(r-1)},\"\\u2039\"),e.createElement(_,{kind:\"ghost\",onClick:()=>l(r+1)},\"\\u203A\"))),s===\"dds\"&&a&&e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"text-sm min-w-[1100px] w-full\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-2 text-left sticky left-0 bg-white\"},\"\\u0421\\u0442\\u0430\\u0442\\u044C\\u044F\"),v.map((o,x)=>e.createElement(\"th\",{key:o,className:\"p-2 text-right\"},Z[x])),e.createElement(\"th\",{className:\"p-2 text-right\"},\"\\u0418\\u0442\\u043E\\u0433\\u043E\"))),e.createElement(\"tbody\",null,e.createElement(h,{title:\"\\u041F\\u043E\\u0441\\u0442\\u0443\\u043F\\u043B\\u0435\\u043D\\u0438\\u044F\",list:n(\"income\",\"op\"),sign:1}),e.createElement(h,{title:\"\\u0412\\u044B\\u043F\\u043B\\u0430\\u0442\\u044B\",list:n(\"expense\",\"op\"),sign:1}),(n(\"income\",\"fin\").length>0||n(\"expense\",\"fin\").length>0)&&e.createElement(h,{title:\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435 (\\u0432\\u043D\\u0435 \\u0434\\u043E\\u0445\\u043E\\u0434\\u043E\\u0432 \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u043E\\u0432)\",list:[...n(\"income\",\"fin\"),...n(\"expense\",\"fin\")],sign:1}),(n(\"income\",\"other\").length>0||n(\"expense\",\"other\").length>0)&&e.createElement(h,{title:\"\\u041F\\u0440\\u043E\\u0447\\u0438\\u0435 \\u0434\\u0432\\u0438\\u0436\\u0435\\u043D\\u0438\\u044F\",list:[...n(\"income\",\"other\"),...n(\"expense\",\"other\")],sign:1}))),e.createElement(\"div\",{className:\"text-xs text-slate-400 p-3\"},\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435 \\u2014 \\u0432\\u043B\\u043E\\u0436\\u0435\\u043D\\u0438\\u044F \\u0443\\u0447\\u0440\\u0435\\u0434\\u0438\\u0442\\u0435\\u043B\\u0435\\u0439, \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B, \\u0437\\u0430\\u0439\\u043C\\u044B \\u0438 \\u043E\\u0432\\u0435\\u0440\\u0434\\u0440\\u0430\\u0444\\u0442 \\u0441 \\u0438\\u0445 \\u043F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u0438\\u0435\\u043C. \\u042D\\u0442\\u043E \\u0434\\u0432\\u0438\\u0436\\u0435\\u043D\\u0438\\u0435 \\u043A\\u0430\\u043F\\u0438\\u0442\\u0430\\u043B\\u0430: \\u0432 \\u0434\\u043E\\u0445\\u043E\\u0434\\u044B \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B \\u043D\\u0435 \\u0432\\u0445\\u043E\\u0434\\u0438\\u0442 \\u0438 \\u043D\\u0430 \\u043F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C \\u043D\\u0435 \\u0432\\u043B\\u0438\\u044F\\u0435\\u0442.\")),s===\"pl\"&&p&&e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"text-sm min-w-[900px] w-full\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3 text-left\"},\"\\u041F\\u043E\\u043A\\u0430\\u0437\\u0430\\u0442\\u0435\\u043B\\u044C\"),v.map((o,x)=>e.createElement(\"th\",{key:o,className:\"p-2 text-right\"},Z[x])),e.createElement(\"th\",{className:\"p-2 text-right\"},\"\\u0418\\u0442\\u043E\\u0433\\u043E\"))),e.createElement(\"tbody\",null,[\"income\",\"expense\",\"np\"].map(o=>{let x={},u=0;for(let m of p.rows){let j=o===\"np\"?m.income-m.expense:m[o];x[m.month]=j,u+=j}let w=o===\"income\"?\"\\u0414\\u043E\\u0445\\u043E\\u0434\\u044B\":o===\"expense\"?\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B\":\"\\u0427\\u0438\\u0441\\u0442\\u0430\\u044F \\u043F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C\",i=o===\"income\"?\"text-emerald-600\":o===\"expense\"?\"text-rose-600\":\"font-bold text-slate-800\";return e.createElement(\"tr\",{key:o,className:\"border-b border-slate-50 \"+(o===\"np\"?\"bg-slate-50\":\"\")},e.createElement(\"td\",{className:\"p-3 font-medium text-slate-700\"},w),v.map(m=>e.createElement(\"td\",{key:m,className:\"p-2 text-right text-xs \"+i},x[m]!==void 0?T(x[m]):\"\")),e.createElement(\"td\",{className:\"p-2 text-right font-medium \"+i},T(u)))}))),e.createElement(\"div\",{className:\"text-xs text-slate-400 p-3\"},\"\\u041A\\u0440\\u0435\\u0434\\u0438\\u0442\\u044B, \\u043E\\u0432\\u0435\\u0440\\u0434\\u0440\\u0430\\u0444\\u0442\\u044B \\u0438 \\u043F\\u0440\\u043E\\u0447\\u0438\\u0435 \\u0434\\u0432\\u0438\\u0436\\u0435\\u043D\\u0438\\u044F \\u043F\\u043E \\u0431\\u0430\\u043B\\u0430\\u043D\\u0441\\u043E\\u0432\\u044B\\u043C \\u0441\\u0442\\u0430\\u0442\\u044C\\u044F\\u043C \\u0432 \\u043F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C \\u043D\\u0435 \\u0432\\u0445\\u043E\\u0434\\u044F\\u0442.\")))}var H={developer:{label:\"\\u0417\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\",bg:\"bg-blue-50 text-blue-600\"},broker:{label:\"\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\",bg:\"bg-violet-50 text-violet-600\"},client:{label:\"\\u041A\\u043B\\u0438\\u0435\\u043D\\u0442\",bg:\"bg-emerald-50 text-emerald-600\"},bank:{label:\"\\u0411\\u0430\\u043D\\u043A\",bg:\"bg-amber-50 text-amber-600\"},staff:{label:\"\\u0421\\u043E\\u0442\\u0440\\u0443\\u0434\\u043D\\u0438\\u043A\",bg:\"bg-slate-100 text-slate-600\"},other:{label:\"\\u041F\\u0440\\u043E\\u0447\\u0435\\u0435\",bg:\"bg-slate-50 text-slate-500\"}};function J({title:s,fields:d,obj:r,path:l,onClose:a,onSaved:b}){let[p,g]=f(r||{}),v=async()=>{r?.id?await M(`${l}/${r.id}`,{method:\"PUT\",body:p}):await M(l,{method:\"POST\",body:p}),b()};return e.createElement(V,{title:s,onClose:a},e.createElement(\"div\",{className:\"grid grid-cols-2 gap-3\"},d.map(([t,n,h,o])=>e.createElement(C,{key:t,label:n,className:h===\"wide\"?\"col-span-2\":\"\"},o?e.createElement($,{value:p[t]??\"\",onChange:x=>g({...p,[t]:x.target.value})},o.map(x=>e.createElement(\"option\",{key:x[0],value:x[0]},x[1]))):e.createElement(S,{type:h===\"num\"?\"number\":h===\"date\"?\"date\":\"text\",value:p[t]??\"\",onChange:x=>g({...p,[t]:x.target.value})})))),e.createElement(\"div\",{className:\"flex justify-between mt-5\"},r?.id?e.createElement(_,{kind:\"danger\",onClick:async()=>{confirm(\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C?\")&&(await M(`${l}/${r.id}`,{method:\"DELETE\"}),b())}},\"\\u0423\\u0434\\u0430\\u043B\\u0438\\u0442\\u044C\"):e.createElement(\"span\",null),e.createElement(\"div\",{className:\"flex gap-2\"},e.createElement(_,{kind:\"ghost\",onClick:a},\"\\u041E\\u0442\\u043C\\u0435\\u043D\\u0430\"),e.createElement(_,{onClick:v},\"\\u0421\\u043E\\u0445\\u0440\\u0430\\u043D\\u0438\\u0442\\u044C\"))))}function pe({meta:s,reload:d}){let[r,l]=f(\"contractors\"),[a,b]=f(null),[p,g]=f(\"\"),[v,t]=f(\"\"),n=()=>{b(null),d()},h=(s.contractors||[]).filter(o=>!p||o.name.toLowerCase().includes(p.toLowerCase())).filter(o=>!v||o.role===v);return e.createElement(\"div\",{className:\"p-6 max-w-[1100px] mx-auto\"},e.createElement(\"div\",{className:\"flex flex-wrap items-center justify-between gap-3 mb-4\"},e.createElement(\"h1\",{className:\"text-2xl font-bold text-slate-800\"},\"\\u0421\\u043F\\u0440\\u0430\\u0432\\u043E\\u0447\\u043D\\u0438\\u043A\\u0438\"),e.createElement(L,{items:[[\"contractors\",\"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\\u044B\"],[\"categories\",\"\\u0421\\u0442\\u0430\\u0442\\u044C\\u0438\"],[\"accounts\",\"\\u0421\\u0447\\u0435\\u0442\\u0430\"],[\"projects\",\"\\u041F\\u0440\\u043E\\u0435\\u043A\\u0442\\u044B\"]],value:r,onChange:l})),r===\"contractors\"&&e.createElement(e.Fragment,null,e.createElement(\"div\",{className:\"flex flex-wrap items-center gap-3 mb-3\"},e.createElement(_,{onClick:()=>b({type:\"contractor\"})},\"+ \\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\"),e.createElement(\"input\",{className:\"border border-slate-200 rounded-full px-4 py-1.5 text-sm bg-white\",placeholder:\"\\u041F\\u043E\\u0438\\u0441\\u043A\\u2026\",value:p,onChange:o=>g(o.target.value)}),e.createElement(L,{items:[[\"\",\"\\u0412\\u0441\\u0435\"],...Object.keys(H).map(o=>[o,H[o].label])],value:v,onChange:t})),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0420\\u043E\\u043B\\u044C\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0418\\u041D\\u041D\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\"))),e.createElement(\"tbody\",null,h.map(o=>e.createElement(\"tr\",{key:o.id,className:\"border-b border-slate-50 hover:bg-slate-50 cursor-pointer\",onClick:()=>b({type:\"contractor\",obj:o})},e.createElement(\"td\",{className:\"p-3 font-medium text-slate-700\"},o.name),e.createElement(\"td\",{className:\"p-3\"},e.createElement(\"span\",{className:\"text-xs px-2 py-1 rounded-full \"+(H[o.role]?.bg||H.other.bg)},H[o.role]?.label||o.role)),e.createElement(\"td\",{className:\"p-3 text-slate-500\"},o.inn||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-slate-400 max-w-56 truncate\"},o.comment)))))),e.createElement(\"div\",{className:\"text-xs text-slate-400 mt-2\"},\"\\u0420\\u043E\\u043B\\u044C \\u043A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\\u0430 \\u0432\\u043B\\u0438\\u044F\\u0435\\u0442 \\u043D\\u0430 \\u043C\\u0435\\u0442\\u0440\\u0438\\u043A\\u0438 \\u0434\\u0430\\u0448\\u0431\\u043E\\u0440\\u0434\\u0430 \\xAB\\u041E\\u0442 \\u0437\\u0430\\u0441\\u0442\\u0440\\u043E\\u0439\\u0449\\u0438\\u043A\\u043E\\u0432\\xBB \\u0438 \\xAB\\u0411\\u0440\\u043E\\u043A\\u0435\\u0440\\u0430\\u043C\\xBB \\u2014 \\u043F\\u0440\\u043E\\u0432\\u0435\\u0440\\u044C\\u0442\\u0435 \\u0435\\u0451 \\u0443 \\u043A\\u043B\\u044E\\u0447\\u0435\\u0432\\u044B\\u0445 \\u043A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\\u043E\\u0432.\")),r===\"categories\"&&e.createElement(e.Fragment,null,e.createElement(_,{className:\"mb-3\",onClick:()=>b({type:\"category\"})},\"+ \\u0421\\u0442\\u0430\\u0442\\u044C\\u044F\"),e.createElement(\"div\",{className:\"grid lg:grid-cols-2 gap-4\"},[\"income\",\"expense\"].map(o=>e.createElement(k,{key:o,className:\"p-4\"},e.createElement(\"div\",{className:\"font-semibold text-slate-800 mb-2\"},o===\"income\"?\"\\u0414\\u043E\\u0445\\u043E\\u0434\\u044B\":\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\\u044B\"),(s.categories||[]).filter(x=>x.kind===o&&!x.parent_id).map(x=>e.createElement(\"div\",{key:x.id},e.createElement(\"div\",{className:\"py-1.5 text-sm font-medium text-slate-700 hover:bg-slate-50 rounded px-2 cursor-pointer flex justify-between\",onClick:()=>b({type:\"category\",obj:x})},e.createElement(\"span\",null,x.name),x.fin_type?e.createElement(\"span\",{className:\"text-xs text-violet-500\",title:\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435 \\u2014 \\u0432\\u043D\\u0435 \\u0434\\u043E\\u0445\\u043E\\u0434\\u043E\\u0432 \\u0438 \\u0440\\u0430\\u0441\\u0445\\u043E\\u0434\\u043E\\u0432\"},\"\\u0444\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435\"):x.cls!==\"pl\"?e.createElement(\"span\",{className:\"text-xs text-amber-500\",title:\"\\u041D\\u0435 \\u0432\\u0445\\u043E\\u0434\\u0438\\u0442 \\u0432 \\u043F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C\"},\"\\u0431\\u0430\\u043B\\u0430\\u043D\\u0441\"):null),(s.categories||[]).filter(u=>u.parent_id===x.id).map(u=>e.createElement(\"div\",{key:u.id,className:\"py-1 pl-6 text-sm text-slate-500 hover:bg-slate-50 rounded px-2 cursor-pointer\",onClick:()=>b({type:\"category\",obj:u})},u.name)))))))),r===\"accounts\"&&e.createElement(e.Fragment,null,e.createElement(_,{className:\"mb-3\",onClick:()=>b({type:\"account\"})},\"+ \\u0421\\u0447\\u0451\\u0442\"),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0422\\u0438\\u043F\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0411\\u0430\\u043D\\u043A\"),e.createElement(\"th\",{className:\"p-3 text-right\"},\"\\u041E\\u0441\\u0442\\u0430\\u0442\\u043E\\u043A\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0410\\u043A\\u0442\\u0438\\u0432\\u0435\\u043D\"))),e.createElement(\"tbody\",null,(s.accounts||[]).map(o=>e.createElement(\"tr\",{key:o.id,className:\"border-b border-slate-50 hover:bg-slate-50 cursor-pointer\",onClick:()=>b({type:\"account\",obj:o})},e.createElement(\"td\",{className:\"p-3 font-medium text-slate-700\"},o.name),e.createElement(\"td\",{className:\"p-3 text-slate-500\"},o.acc_type),e.createElement(\"td\",{className:\"p-3 text-slate-500\"},o.bank||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-right font-medium \"+(o.balance<0?\"text-rose-600\":\"text-slate-800\")},B(o.balance),\" \\u20BD\"),e.createElement(\"td\",{className:\"p-3\"},o.active?\"\\u2713\":\"\\u2014\"))))))),r===\"projects\"&&e.createElement(e.Fragment,null,e.createElement(_,{className:\"mb-3\",onClick:()=>b({type:\"project\"})},\"+ \\u041F\\u0440\\u043E\\u0435\\u043A\\u0442\"),e.createElement(k,{className:\"overflow-x-auto\"},e.createElement(\"table\",{className:\"w-full text-sm\"},e.createElement(\"thead\",null,e.createElement(\"tr\",{className:\"text-left text-xs text-slate-400 border-b border-slate-100\"},e.createElement(\"th\",{className:\"p-3\"},\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0413\\u0440\\u0443\\u043F\\u043F\\u0430\"),e.createElement(\"th\",{className:\"p-3\"},\"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\"))),e.createElement(\"tbody\",null,(s.projects||[]).map(o=>e.createElement(\"tr\",{key:o.id,className:\"border-b border-slate-50 hover:bg-slate-50 cursor-pointer\",onClick:()=>b({type:\"project\",obj:o})},e.createElement(\"td\",{className:\"p-3 font-medium text-slate-700\"},o.name),e.createElement(\"td\",{className:\"p-3 text-slate-500\"},o.grp||\"\\u2014\"),e.createElement(\"td\",{className:\"p-3 text-slate-500\"},o.status===\"done\"?\"\\u0417\\u0430\\u0432\\u0435\\u0440\\u0448\\u0451\\u043D\":o.status===\"plan\"?\"\\u041F\\u043B\\u0430\\u043D\\u043E\\u0432\\u044B\\u0439\":\"\\u0412 \\u0440\\u0430\\u0431\\u043E\\u0442\\u0435\"))))))),a?.type===\"contractor\"&&e.createElement(J,{title:\"\\u041A\\u043E\\u043D\\u0442\\u0440\\u0430\\u0433\\u0435\\u043D\\u0442\",obj:a.obj,path:\"/api/contractors\",onClose:()=>b(null),onSaved:n,fields:[[\"name\",\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\",\"wide\"],[\"role\",\"\\u0420\\u043E\\u043B\\u044C\",\"\",Object.keys(H).map(o=>[o,H[o].label])],[\"inn\",\"\\u0418\\u041D\\u041D\"],[\"phone\",\"\\u0422\\u0435\\u043B\\u0435\\u0444\\u043E\\u043D\"],[\"comment\",\"\\u041A\\u043E\\u043C\\u043C\\u0435\\u043D\\u0442\\u0430\\u0440\\u0438\\u0439\",\"wide\"]]}),a?.type===\"category\"&&e.createElement(J,{title:\"\\u0421\\u0442\\u0430\\u0442\\u044C\\u044F\",obj:a.obj,path:\"/api/categories\",onClose:()=>b(null),onSaved:n,fields:[[\"name\",\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\",\"wide\"],[\"kind\",\"\\u0422\\u0438\\u043F\",\"\",[[\"income\",\"\\u0414\\u043E\\u0445\\u043E\\u0434\"],[\"expense\",\"\\u0420\\u0430\\u0441\\u0445\\u043E\\u0434\"]]],[\"cls\",\"\\u041A\\u043B\\u0430\\u0441\\u0441\",\"\",[[\"pl\",\"\\u041F\\u0440\\u0438\\u0431\\u044B\\u043B\\u044C (P&L)\"],[\"assets\",\"\\u0410\\u043A\\u0442\\u0438\\u0432\\u044B\"],[\"liabilities\",\"\\u041E\\u0431\\u044F\\u0437\\u0430\\u0442\\u0435\\u043B\\u044C\\u0441\\u0442\\u0432\\u0430\"],[\"capital\",\"\\u041A\\u0430\\u043F\\u0438\\u0442\\u0430\\u043B\"]]],[\"fin_type\",\"\\u0424\\u0438\\u043D\\u0430\\u043D\\u0441\\u0438\\u0440\\u043E\\u0432\\u0430\\u043D\\u0438\\u0435\",\"\",[[\"\",\"\\u041D\\u0435\\u0442 \\u2014 \\u043E\\u0431\\u044B\\u0447\\u043D\\u0430\\u044F \\u0441\\u0442\\u0430\\u0442\\u044C\\u044F\"],[\"own\",\"\\u0412\\u043B\\u043E\\u0436\\u0435\\u043D\\u0438\\u044F \\u0443\\u0447\\u0440\\u0435\\u0434\\u0438\\u0442\\u0435\\u043B\\u0435\\u0439\"],[\"debt\",\"\\u041F\\u0440\\u0438\\u0432\\u043B\\u0435\\u0447\\u0435\\u043D\\u0438\\u0435 \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u0430 / \\u0437\\u0430\\u0439\\u043C\\u0430\"],[\"repay\",\"\\u041F\\u043E\\u0433\\u0430\\u0448\\u0435\\u043D\\u0438\\u0435 \\u043A\\u0440\\u0435\\u0434\\u0438\\u0442\\u0430 / \\u0437\\u0430\\u0439\\u043C\\u0430\"]]],[\"parent_id\",\"\\u0420\\u043E\\u0434\\u0438\\u0442\\u0435\\u043B\\u044C\",\"\",[[\"\",\"\\u2014\"],...(s.categories||[]).filter(o=>!o.parent_id).map(o=>[o.id,o.name])]]]}),a?.type===\"account\"&&e.createElement(J,{title:\"\\u0421\\u0447\\u0451\\u0442\",obj:a.obj,path:\"/api/accounts\",onClose:()=>b(null),onSaved:n,fields:[[\"name\",\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\",\"wide\"],[\"acc_type\",\"\\u0422\\u0438\\u043F\",\"\",[[\"\\u0411\\u0435\\u0437\\u043D\\u0430\\u043B\\u0438\\u0447\\u043D\\u044B\\u0439\",\"\\u0411\\u0435\\u0437\\u043D\\u0430\\u043B\\u0438\\u0447\\u043D\\u044B\\u0439\"],[\"\\u041D\\u0430\\u043B\\u0438\\u0447\\u043D\\u044B\\u0439\",\"\\u041D\\u0430\\u043B\\u0438\\u0447\\u043D\\u044B\\u0439\"],[\"\\u041A\\u0430\\u0440\\u0442\\u0430 \\u0444\\u0438\\u0437\\u043B\\u0438\\u0446\\u0430\",\"\\u041A\\u0430\\u0440\\u0442\\u0430 \\u0444\\u0438\\u0437\\u043B\\u0438\\u0446\\u0430\"],[\"\\u042D\\u043B\\u0435\\u043A\\u0442\\u0440\\u043E\\u043D\\u043D\\u044B\\u0439\",\"\\u042D\\u043B\\u0435\\u043A\\u0442\\u0440\\u043E\\u043D\\u043D\\u044B\\u0439\"]]],[\"bank\",\"\\u0411\\u0430\\u043D\\u043A\"],[\"grp\",\"\\u0413\\u0440\\u0443\\u043F\\u043F\\u0430\"],[\"start_balance\",\"\\u041D\\u0430\\u0447\\u0430\\u043B\\u044C\\u043D\\u044B\\u0439 \\u043E\\u0441\\u0442\\u0430\\u0442\\u043E\\u043A\",\"num\"],[\"start_date\",\"\\u0414\\u0430\\u0442\\u0430 \\u043E\\u0441\\u0442\\u0430\\u0442\\u043A\\u0430\",\"date\"],[\"active\",\"\\u0410\\u043A\\u0442\\u0438\\u0432\\u0435\\u043D\",\"\",[[1,\"\\u0414\\u0430\"],[0,\"\\u041D\\u0435\\u0442\"]]]]}),a?.type===\"project\"&&e.createElement(J,{title:\"\\u041F\\u0440\\u043E\\u0435\\u043A\\u0442\",obj:a.obj,path:\"/api/projects\",onClose:()=>b(null),onSaved:n,fields:[[\"name\",\"\\u041D\\u0430\\u0437\\u0432\\u0430\\u043D\\u0438\\u0435\",\"wide\"],[\"grp\",\"\\u0413\\u0440\\u0443\\u043F\\u043F\\u0430\"],[\"status\",\"\\u0421\\u0442\\u0430\\u0442\\u0443\\u0441\",\"\",[[\"work\",\"\\u0412 \\u0440\\u0430\\u0431\\u043E\\u0442\\u0435\"],[\"plan\",\"\\u041F\\u043B\\u0430\\u043D\\u043E\\u0432\\u044B\\u0439\"],[\"done\",\"\\u0417\\u0430\\u0432\\u0435\\u0440\\u0448\\u0451\\u043",[],[140,182],["D",1787314822204],[158,159,160],[140],["D",1787314298248],["D",1789484509295],{"_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","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11