[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_111":112,"_113":114},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22},"handle","tambovtsev007","name","ufin","path","frontend/src/pages_a.tsx","project",{"_23":49,"_11":12,"_36":50,"_51":-5,"_52":44,"_53":54,"_55":54,"_56":57,"_58":-5,"_59":60,"_61":62,"_63":35,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":44},"file",{"_23":24,"_11":25,"_26":27,"_28":29,"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":17,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/tambovtsev007/ufin/code/frontend/src/pages_a.tsx","extension","tsx","id","f144fc07-049d-4fa8-ac80-14c7061c208f","pages_a.tsx","fileId","165e7c84-9d40-11f1-b1b5-1607ee4eb77e","parentId","2ba02cd3-9593-4dc3-a930-7ca2c0361271","branchId","4e7c594c-7131-44af-85f7-c363fcbc85c7","branchVersion",56,"latest",true,"createdAt",["D",1787312380682],"version",3,"fileType","content","// Показатели и Показатели PRO\nimport {\n React, useEffect, useState, api, fmt, fmt0, fmtShort, fmtDate, todayStr, thisYear,\n monLabel, rootOfCat, TInput, TSelect, Tabs, YearSelect,\n ComboChart, ChartLegend, AreaChart, Donut, DONUT_COLORS, Pareto, CH,\n} from \"./lib.tsx\";\n\nconst MONTH_FULL = [\"января\",\"февраля\",\"марта\",\"апреля\",\"мая\",\"июня\",\"июля\",\"августа\",\"сентября\",\"октября\",\"ноября\",\"декабря\"];\nconst WEEKDAYS = [\"воскресенье\",\"понедельник\",\"вторник\",\"среда\",\"четверг\",\"пятница\",\"суббота\"];\nfunction todayWords() {\n const d = new Date();\n return `${d.getDate()} ${MONTH_FULL[d.getMonth()]} ${d.getFullYear()} года, ${WEEKDAYS[d.getDay()]}`;\n}\nconst monthsBetween = (from, to) => {\n const out = [];\n let [y, m] = from.split(\"-\").map(Number);\n const [ty, tm] = to.split(\"-\").map(Number);\n while (y < ty || (y === ty && m <= tm)) {\n out.push(`${y}-${String(m).padStart(2, \"0\")}`);\n m++; if (m > 12) { m = 1; y++; }\n }\n return out.slice(0, 24);\n};\n\n// метрика с «по плану» (как в референсе)\nfunction Metric({ label, value, plan, unit = \" ₽\", color }) {\n return (\n

{label}

{value}{unit === \"%\" ? \"%\" : \"\"}

{plan}{unit === \"%\" ? \"%\" : \"\"} - по плану

\n );\n}\n\n// ---------- Показатели ----------\nexport function PageIndicators({ meta }) {\n const nowM = todayStr().slice(0, 7);\n const [from, setFrom] = useState(thisYear() + \"-01\");\n const [to, setTo] = useState(nowM);\n const [basis, setBasis] = useState(\"cash\");\n const [flow, setFlow] = useState(\"all\");\n const [structTab, setStructTab] = useState(\"dr\");\n const [flt, setFlt] = useState({ account: \"\", project: \"\", deal: \"\" });\n const [deals, setDeals] = useState([]);\n const [data, setData] = useState(null);\n useEffect(() => { api(\"/deals\").then(setDeals); }, []);\n useEffect(() => {\n const p = new URLSearchParams({ from: from + \"-01\", to: to + \"-31\", basis });\n if (flt.account) p.set(\"account\", flt.account);\n if (flt.project) p.set(\"project\", flt.project);\n if (flt.deal) p.set(\"deal\", flt.deal);\n api(\"/dashboard2?\" + p.toString()).then(setData);\n }, [from, to, basis, JSON.stringify(flt)]);\n if (!data) return

Загрузка…

;\n\n const mlist = monthsBetween(from, to);\n const byM = {};\n for (const r of data.months) byM[r.m] = r;\n const isBS = (root) => root && [\"assets\", \"liabilities\", \"capital\"].includes(root.cat_class || \"\");\n // дивиденды, потоки и структура из struct (по корневым статьям, с учётом классов)\n const divByM = {};\n const flowByM = {}; // m -> {in_oper, out_oper, in_fin, out_fin}\n const rootsInc = {}, rootsExp = {};\n for (const r of data.struct) {\n const root = r.category_id ? rootOfCat(meta.categories, r.category_id) : null;\n const rname = root ? root.name : \"Нераспределенные\";\n const bs = isBS(root);\n const isFin = bs || rname.toLowerCase().includes(\"кредит\") || rname.toLowerCase().includes(\"овердрафт\");\n const f = (flowByM[r.m] = flowByM[r.m] || { in_oper: 0, out_oper: 0, in_fin: 0, out_fin: 0 });\n if (r.op_type === \"income\") { f[isFin ? \"in_fin\" : \"in_oper\"] += Number(r.s); const e = (rootsInc[rname] = rootsInc[rname] || { name: rname, value: 0, byM: {}, bs }); e.value += Number(r.s); e.byM[r.m] = (e.byM[r.m] || 0) + Number(r.s); }\n else { f[isFin ? \"out_fin\" : \"out_oper\"] += Number(r.s); const e = (rootsExp[rname] = rootsExp[rname] || { name: rname, value: 0, byM: {}, bs }); e.value += Number(r.s); e.byM[r.m] = (e.byM[r.m] || 0) + Number(r.s); }\n if (rname === \"Дивиденды\") divByM[r.m] = (divByM[r.m] || 0) + Number(r.s);\n }\n const inc = mlist.reduce((s, m) => s + Number(byM[m]?.income || 0), 0);\n const exp = mlist.reduce((s, m) => s + Number(byM[m]?.expense || 0), 0);\n const np = inc - exp;\n const rent = inc ? Math.round((np / inc) * 1000) / 10 : 0;\n const div = Object.values(divByM).reduce((s, v) => s + v, 0);\n // «по плану» = все операции периода, включая неподтверждённые (как в референсе)\n const planInc = mlist.reduce((s, m) => s + Number(byM[m]?.plan_income || 0), 0);\n const planExp = mlist.reduce((s, m) => s + Number(byM[m]?.plan_expense || 0), 0);\n const planNp = planInc - planExp;\n const planRent = planInc ? Math.round((planNp / planInc) * 1000) / 10 : 0;\n\n const hasData = (m) => !!byM[m];\n const profitChart = mlist.map((m) => ({\n label: monLabel(m),\n income: hasData(m) ? Number(byM[m].income || 0) : null,\n expense: hasData(m) ? Number(byM[m].expense || 0) : null,\n np: hasData(m) ? Number(byM[m].income || 0) - Number(byM[m].expense || 0) : null,\n div: hasData(m) ? (divByM[m] || 0) : null,\n }));\n\n const flowIn = (m) => { const f = flowByM[m] || {}; return flow === \"all\" ? (f.in_oper || 0) + (f.in_fin || 0) : flow === \"oper\" ? f.in_oper || 0 : flow === \"fin\" ? f.in_fin || 0 : 0; };\n const flowOut = (m) => { const f = flowByM[m] || {}; return flow === \"all\" ? (f.out_oper || 0) + (f.out_fin || 0) : flow === \"oper\" ? f.out_oper || 0 : flow === \"fin\" ? f.out_fin || 0 : 0; };\n const flowChart = mlist.map((m) => ({\n label: monLabel(m),\n inflow: flowByM[m] ? flowIn(m) : null,\n outflow: flowByM[m] ? flowOut(m) : null,\n net: flowByM[m] ? flowIn(m) - flowOut(m) : null,\n }));\n const totIn = mlist.reduce((s, m) => s + flowIn(m), 0);\n const totOut = mlist.reduce((s, m) => s + flowOut(m), 0);\n\n // «Доходы и расходы» — только П/У-статьи; «Поступления и выплаты» — все\n const puOnly = structTab === \"dr\";\n const incParts = Object.values(rootsInc).filter((p) => !puOnly || !p.bs).sort((a, b) => b.value - a.value);\n const expParts = Object.values(rootsExp).filter((p) => !puOnly || !p.bs).sort((a, b) => b.value - a.value);\n const incTotal = incParts.reduce((s, p) => s + p.value, 0) || 1;\n const expTotal = expParts.reduce((s, p) => s + p.value, 0) || 1;\n const incTotByM = {}, expTotByM = {};\n for (const p of incParts) for (const m in p.byM) incTotByM[m] = (incTotByM[m] || 0) + p.byM[m];\n for (const p of expParts) for (const m in p.byM) expTotByM[m] = (expTotByM[m] || 0) + p.byM[m];\n\n const StructBlock = ({ title, parts, total, totByM, barColor }) => (\n

{title}

\n ({ ...p, color: DONUT_COLORS[i % DONUT_COLORS.length] }))} />\n

\n {parts.slice(0, 8).map((p, i) => (\n

\n \n {p.name}\n {fmt0(p.value)}\n ({(p.value / total * 100).toFixed(2)}%)\n

\n ))}\n

\n ({ label: monLabel(m), v: totByM[m] || 0 }))} bars={[{ key: \"v\", color: barColor }]} lines={[]} height={190} />\n

\n );\n\n const selCls = \"border border-gray-200 rounded px-3 py-2 text-sm bg-white text-gray-600\";\n return (\n

\n {/* заголовок и фильтры */}\n

{meta.company_name}

{todayWords()}

\n Период
\n \n setFrom(e.target.value)} />\n —\n setTo(e.target.value)} />\n \n \n Отображение
\n \n \n Юрлица и счета
\n \n \n Проекты
\n \n \n Сделки
\n \n \n {(flt.account || flt.project || flt.deal) && (\n \n )}\n

\n\n {/* Прибыль */}\n

Прибыль, ₽

\n \n

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

\n \n \n

\n\n {/* Денежный поток */}\n

Денежный поток, ₽

\n \n

\n \n \n \n

\n \n \n

\n\n {/* Остатки на счетах */}\n

Остатки на счетах, ₽

\n \n \n

\n\n {/* Структура платежей */}\n

Структура платежей

\n \n

\n \n \n

\n\n {/* ABC-анализ клиентов */}\n

ABC-анализ клиентов

\n ({ name: r.name, value: Number(r.s) }))} height={320} />\n \n

\n\n {/* Прибыльность проектов */}\n

Прибыльность проектов

\n ({ name: r.name, value: Number(r.profit) }))} height={300} showLine={false} barColor=\"#66BB6A\" />\n \n

\n );\n}\n\n// ---------- Показатели PRO ----------\nexport function PagePro({ meta }) {\n const nowM = todayStr().slice(0, 7);\n const [tab, setTab] = useState(\"money\");\n const [from, setFrom] = useState(thisYear() + \"-01\");\n const [to, setTo] = useState(nowM);\n const [data, setData] = useState(null);\n const [projects, setProjects] = useState([]);\n useEffect(() => {\n api(`/dashboard2?from=${from}-01&to=${to}-31&basis=cash`).then(setData);\n api(\"/projects\").then(setProjects);\n }, [from, to]);\n if (!data) return

Загрузка…

;\n const mset = {};\n for (const r of data.months) mset[r.m] = r;\n const mlist = monthsBetween(from, to);\n const chart = mlist.map((m) => ({\n label: monLabel(m),\n income: Number(mset[m]?.income || 0),\n expense: Number(mset[m]?.expense || 0),\n np: Number(mset[m]?.income || 0) - Number(mset[m]?.expense || 0),\n }));\n return (\n

Показатели

\n \n

\n Период
\n \n setFrom(e.target.value)} />\n —\n setTo(e.target.value)} />\n \n \n

\n {tab === \"money\" && (\n

Остатки на счетах, ₽

\n \n \n

\n )}\n {tab === \"profit\" && (\n

Прибыль (кассовый метод), ₽

\n \n \n

\n )}\n {tab === \"projects\" && (\n

\n \n \n \n \n \n \n {projects.map((p) => {\n const profit = Number(p.income) - Number(p.expense);\n const r = Number(p.income) ? Math.round((profit / Number(p.income)) * 1000) / 10 : 0;\n return (\n \n \n \n \n \n \n \n );\n })}\n \n

Проект	Доходы, ₽	Расходы, ₽	Прибыль, ₽	Рентабельность
{p.name}	{Number(p.income) ? fmt0(p.income) : \"—\"}	{Number(p.expense) ? fmt0(p.expense) : \"—\"}	{profit ? fmt0(profit) : \"—\"}	{r ? r + \"%\" : \"—\"}

\n )}\n

\n );\n}\n","deleted",false,"label",[47,48,25],"frontend","src","6e904ebf-a254-4dd3-b3e8-cca1eea5f4a2",["D",1787239139778],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","U.fin — финансовая система агентства недвижимости","imageUrl","userId","caa5b6a0-dd4e-4cd6-a997-9389a6a43948","pinnedFileId","8193b528-9caa-11f1-a2f1-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019eff71-5749-76b5-abdd-e25a47b3deca","tursoName","6e904ebfa2544dd3b3e8cca1eea5f4a2","tursoHostname","6e904ebfa2544dd3b3e8cca1eea5f4a2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_110":106},"org",{"_9":10,"_103":104,"_105":106,"_59":60,"_107":108,"_109":44},"branch",{"_38":93,"_11":94,"_23":31,"_95":49,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":12,"_102":10},"isOwned",61,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Кирилл Тамбовцев","avatar","https://lh3.googleusercontent.com/a/ACg8ocKCNneTjcn307kcxhB_NS1R7_0SBhSKM-2hy73z0JvhXFipwkhs=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_86":-5,"_144":145,"_146":147,"_148":149,"_150":44,"_151":44,"_152":44,"_153":35,"_154":-5,"_155":-7,"_156":-7,"_157":67,"_158":44,"_159":44,"_160":-5,"_161":44,"_162":44,"_163":44,"_164":-5},"ENV",{"_115":116,"_117":118,"_119":94,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141,"_142":143},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]