[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_233":234,"_235":236},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_107":90,"_27":53,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":59,"_124":-5,"_125":-5,"_126":127},"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":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",35,"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","db.ts","latestPath","fileId","d16f5734-9bd6-11f1-a384-1607ee4eb77e","name","fileType","script","content","import { sqlite as s } from \"https://esm.town/v/std/sqlite/main.ts\";\nlet u = !1;\nasync function m() {\n u ||\n (await s.batch([\n `create table if not exists employees ( id integer primary key autoincrement, name text not null, slug text not null unique, password_salt text not null, password_hash text not null, telegram_chat_id text, telegram_link_code text, last_active_date text, active integer not null default 1, created_at text not null default (datetime('now')) )`,\n `create table if not exists projects ( id integer primary key autoincrement, name text not null, description text, status text not null default 'active', created_at text not null default (datetime('now')) )`,\n `create table if not exists weeks ( id integer primary key autoincrement, employee_id integer not null references employees(id), week_start text not null, summary_done text, summary_blockers text, submitted_at text, created_at text not null default (datetime('now')), unique(employee_id, week_start) )`,\n `create table if not exists tasks ( id integer primary key autoincrement, week_id integer not null references weeks(id), project_id integer references projects(id), title text not null, planned_day text, status text not null default 'todo', note text, created_at text not null default (datetime('now')), updated_at text not null default (datetime('now')) )`,\n `create table if not exists sessions ( token text primary key, employee_id integer, is_manager integer not null default 0, expires_at text not null )`,\n `create table if not exists stages ( id integer primary key autoincrement, project_id integer not null references projects(id), name text not null, start_date text, end_date text, position integer not null default 0, created_at text not null default (datetime('now')) )`,\n ]),\n await l(\"tasks\", \"priority\", \"integer not null default 2\"),\n await l(\"tasks\", \"stage_id\", \"integer\"),\n u = !0);\n}\nasync function l(e, t, n) {\n (await s.execute(`pragma table_info(${e})`)).rows.some((o) =>\n String(o.name ?? o[1]) === t\n ) || await s.execute(`alter table ${e} add column ${t} ${n}`);\n}\nasync function w(e = !1) {\n const t = e\n ? \"select * from employees order by name\"\n : \"select * from employees where active = 1 order by name\";\n return (await s.execute(t)).rows;\n}\nasync function g(e) {\n return (await s.execute({\n sql: \"select * from employees where slug = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function p(e) {\n return (await s.execute({\n sql: \"select * from employees where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function _(e, t, n, r) {\n const a = await s.execute({\n sql:\n \"insert into employees (name, slug, password_salt, password_hash) values (?, ?, ?, ?)\",\n args: [e, t, n, r],\n });\n return Number(a.lastInsertRowid);\n}\nasync function y(e, t, n) {\n await s.execute({\n sql:\n \"update employees set password_salt = ?, password_hash = ? where id = ?\",\n args: [t, n, e],\n });\n}\nasync function b(e, t) {\n await s.execute({\n sql: \"update employees set active = ? where id = ?\",\n args: [t ? 1 : 0, e],\n });\n}\nasync function x(e, t) {\n await s.execute({\n sql: \"update employees set last_active_date = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function k(e, t) {\n await s.execute({\n sql: \"update employees set telegram_link_code = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function h(e, t) {\n const r =\n (await s.execute({\n sql: \"select * from employees where telegram_link_code = ?\",\n args: [e],\n })).rows[0];\n return r\n ? (await s.execute({\n sql:\n \"update employees set telegram_chat_id = ?, telegram_link_code = null where id = ?\",\n args: [t, r.id],\n }),\n r)\n : null;\n}\nasync function f(e = !0) {\n const t = e\n ? \"select * from projects order by (status = 'active') desc, name\"\n : \"select * from projects where status = 'active' order by name\";\n return (await s.execute(t)).rows;\n}\nasync function j(e) {\n return (await s.execute({\n sql: \"select * from projects where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function q(e, t) {\n const n = await s.execute({\n sql: \"insert into projects (name, description) values (?, ?)\",\n args: [e, t],\n });\n return Number(n.lastInsertRowid);\n}\nasync function P(e, t) {\n await s.execute({\n sql: \"update projects set status = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function S(e) {\n return (await s.execute({\n sql: \"select * from weeks where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function c(e, t) {\n return (await s.execute({\n sql: \"select * from weeks where employee_id = ? and week_start = ?\",\n args: [e, t],\n })).rows[0] ?? null;\n}\nasync function N(e, t) {\n const n = await c(e, t);\n return n ||\n (await s.execute({\n sql:\n `insert into weeks (employee_id, week_start) values (?, ?) on conflict(employee_id, week_start) do nothing`,\n args: [e, t],\n }),\n await c(e, t));\n}\nasync function T(e, t, n) {\n await s.execute({\n sql:\n \"update weeks set summary_done = ?, summary_blockers = ?, submitted_at = datetime('now') where id = ?\",\n args: [t, n, e],\n });\n}\nasync function W(e, t = 12) {\n return (await s.execute({\n sql:\n \"select * from weeks where employee_id = ? order by week_start desc limit ?\",\n args: [e, t],\n })).rows;\n}\nasync function v(e) {\n const t = {};\n if (e.length === 0) return t;\n const n = e.map(() => \"?\").join(\",\"),\n r = await s.execute({\n sql:\n `select w.week_start as week_start, count(t.id) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from weeks w left join tasks t on t.week_id = w.id where w.week_start in (${n}) group by w.week_start`,\n args: e,\n });\n for (const a of r.rows) {\n t[String(a.week_start)] = {\n total: Number(a.total) || 0,\n done: Number(a.done) || 0,\n };\n }\n return t;\n}\nasync function E(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select t.project_id as project_id, count(*) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from tasks t join weeks w on w.id = t.week_id where w.week_start = ? and t.project_id is not null group by t.project_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.project_id)] = {\n total: Number(r.total) || 0,\n done: Number(r.done) || 0,\n };\n }\n return t;\n}\nasync function R(e) {\n return (await s.execute({\n sql: \"select * from stages where project_id = ? order by position, id\",\n args: [e],\n })).rows;\n}\nasync function F() {\n return (await s.execute(\n `select s.*, p.name as project_name from stages s join projects p on p.id = s.project_id where p.status = 'active' order by p.name, s.position, s.id`,\n )).rows;\n}\nasync function $(e) {\n return (await s.execute({\n sql: \"select * from stages where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function A(e, t, n, r) {\n const a = await s.execute({\n sql:\n \"select coalesce(max(position), 0) + 1 as next from stages where project_id = ?\",\n args: [e],\n }),\n o = Number(a.rows[0]?.next ?? 1),\n i = await s.execute({\n sql:\n \"insert into stages (project_id, name, start_date, end_date, position) values (?, ?, ?, ?, ?)\",\n args: [e, t, n, r, o],\n });\n return Number(i.lastInsertRowid);\n}\nasync function O(e, t, n, r) {\n await s.execute({\n sql:\n \"update stages set name = ?, start_date = ?, end_date = ? where id = ?\",\n args: [t, n, r, e],\n });\n}\nasync function B(e) {\n await s.execute({\n sql: \"update tasks set stage_id = null where stage_id = ?\",\n args: [e],\n }), await s.execute({ sql: \"delete from stages where id = ?\", args: [e] });\n}\nasync function C(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select t.stage_id as stage_id, count(*) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from tasks t where t.project_id = ? and t.stage_id is not null group by t.stage_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.stage_id)] = {\n total: Number(r.total) || 0,\n done: Number(r.done) || 0,\n };\n }\n return t;\n}\nasync function I() {\n const e = {},\n t = await s.execute(\n `select project_id, count(*) as total, sum(case when status = 'done' then 1 else 0 end) as done, sum(case when status = 'blocked' then 1 else 0 end) as blocked from tasks where project_id is not null group by project_id`,\n );\n for (const n of t.rows) {\n e[Number(n.project_id)] = {\n total: Number(n.total) || 0,\n done: Number(n.done) || 0,\n blocked: Number(n.blocked) || 0,\n };\n }\n return e;\n}\nasync function L(e) {\n return (await s.execute({\n sql:\n `select t.*, e.name as employee_name, e.slug as employee_slug, w.week_start as week_start, s.name as stage_name from tasks t join weeks w on w.id = t.week_id join employees e on e.id = w.employee_id left join stages s on s.id = t.stage_id where t.project_id = ? order by case t.status when 'blocked' then 0 when 'in_progress' then 1 when 'todo' then 2 else 3 end, t.priority asc, w.week_start desc, t.id`,\n args: [e],\n })).rows;\n}\nasync function z(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select w.employee_id as employee_id, sum(case when t.status <> 'done' then 1 else 0 end) as open_count, sum(case when t.status <> 'done' then (case t.priority when 1 then 3 when 3 then 1 else 2 end) else 0 end) as weighted, sum(case when t.status <> 'done' and t.priority = 1 then 1 else 0 end) as high_count from weeks w join tasks t on t.week_id = w.id where w.week_start = ? group by w.employee_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.employee_id)] = {\n open: Number(r.open_count) || 0,\n weighted: Number(r.weighted) || 0,\n high: Number(r.high_count) || 0,\n };\n }\n return t;\n}\nasync function D(e) {\n return (await s.execute({\n sql:\n `select * from tasks where week_id = ? order by case status when 'blocked' then 0 when 'in_progress' then 1 when 'todo' then 2 else 3 end, priority asc, case planned_day when 'mon' then 0 when 'tue' then 1 when 'wed' then 2 when 'thu' then 3 when 'fri' then 4 when 'sat' then 5 when 'sun' then 6 else 7 end, id`,\n args: [e],\n })).rows;\n}\nasync function G(e, t, n, r, a = 2, o = null) {\n const i = await s.execute({\n sql:\n `insert into tasks (week_id, project_id, stage_id, title, planned_day, priority) values (?, ?, ?, ?, ?, ?)`,\n args: [e, t, o, n, r, a],\n });\n return Number(i.lastInsertRowid);\n}\nasync function H(e, t) {\n await s.execute({\n sql:\n \"update tasks set priority = ?, updated_at = datetime('now') where id = ?\",\n args: [t, e],\n });\n}\nasync function J(e) {\n return (await s.execute({\n sql: \"select * from tasks where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function K(e, t, n) {\n await s.execute({\n sql:\n \"update tasks set status = ?, note = ?, updated_at = datetime('now') where id = ?\",\n args: [t, n, e],\n });\n}\nasync function M(e) {\n await s.execute({ sql: \"delete from tasks where id = ?\", args: [e] });\n}\nasync function Q(e, t, n, r) {\n await s.execute({\n sql:\n \"insert into sessions (token, employee_id, is_manager, expires_at) values (?, ?, ?, ?)\",\n args: [e, t, n ? 1 : 0, r],\n });\n}\nasync function U(e) {\n return (await s.execute({\n sql:\n \"select * from sessions where token = ? and expires_at > datetime('now')\",\n args: [e],\n })).rows[0];\n}\nasync function V(e) {\n await s.execute({ sql: \"delete from sessions where token = ?\", args: [e] });\n}\nexport {\n $ as getStage,\n _ as createEmployee,\n A as createStage,\n B as deleteStage,\n b as setEmployeeActive,\n C as getStageTaskStats,\n c as getWeek,\n D as listTasksForWeek,\n E as getProjectTaskStatsForWeek,\n F as listAllStages,\n f as listProjects,\n G as createTask,\n g as getEmployeeBySlug,\n H as setTaskPriority,\n h as linkEmployeeTelegram,\n I as getAllProjectsProgress,\n J as getTask,\n j as getProject,\n K as updateTaskStatus,\n k as setEmployeeTelegramLinkCode,\n L as listTasksForProject,\n M as deleteTask,\n m as migrate,\n N as getOrCreateWeek,\n O as updateStage,\n P as setProjectStatus,\n p as getEmployeeById,\n Q as createSession,\n q as createProject,\n R as listStages,\n S as getWeekById,\n T as saveWeekSummary,\n U as getSession,\n V as deleteSession,\n v as getTeamWeeklyStats,\n W as listWeeksForEmployee,\n w as listEmployees,\n x as touchEmployeeActivity,\n y as setEmployeePassword,\n z as getWorkloadForWeek,\n};","import { sqlite as s } from \"https://esm.town/v/std/sqlite/main.ts\";\nlet m = !1;\nasync function p() {\n m ||\n (await s.batch([\n `create table if not exists employees ( id integer primary key autoincrement, name text not null, slug text not null unique, password_salt text not null, password_hash text not null, telegram_chat_id text, telegram_link_code text, last_active_date text, active integer not null default 1, created_at text not null default (datetime('now')) )`,\n `create table if not exists projects ( id integer primary key autoincrement, name text not null, description text, status text not null default 'active', created_at text not null default (datetime('now')) )`,\n `create table if not exists weeks ( id integer primary key autoincrement, employee_id integer not null references employees(id), week_start text not null, summary_done text, summary_blockers text, submitted_at text, created_at text not null default (datetime('now')), unique(employee_id, week_start) )`,\n `create table if not exists tasks ( id integer primary key autoincrement, week_id integer not null references weeks(id), project_id integer references projects(id), title text not null, planned_day text, status text not null default 'todo', note text, created_at text not null default (datetime('now')), updated_at text not null default (datetime('now')) )`,\n `create table if not exists sessions ( token text primary key, employee_id integer, is_manager integer not null default 0, expires_at text not null )`,\n `create table if not exists stages ( id integer primary key autoincrement, project_id integer not null references projects(id), name text not null, start_date text, end_date text, position integer not null default 0, created_at text not null default (datetime('now')) )`,\n `create table if not exists task_status_log ( id integer primary key autoincrement, task_id integer not null references tasks(id), status text not null, entered_at text not null default (datetime('now')) )`,\n ]),\n await u(\"tasks\", \"priority\", \"integer not null default 2\"),\n await u(\"tasks\", \"stage_id\", \"integer\"),\n await u(\"tasks\", \"parent_task_id\", \"integer\"),\n await u(\"tasks\", \"root_created_at\", \"text\"),\n await u(\"tasks\", \"closed_at\", \"text\"),\n await u(\"tasks\", \"carried_count\", \"integer not null default 0\"),\n await u(\"weeks\", \"carried_at\", \"text\"),\n m = !0);\n}\nasync function u(e, t, n) {\n (await s.execute(`pragma table_info(${e})`)).rows.some((o) =>\n String(o.name ?? o[1]) === t\n ) || await s.execute(`alter table ${e} add column ${t} ${n}`);\n}\nasync function _(e = !1) {\n const t = e\n ? \"select * from employees order by name\"\n : \"select * from employees where active = 1 order by name\";\n return (await s.execute(t)).rows;\n}\nasync function k(e) {\n return (await s.execute({\n sql: \"select * from employees where slug = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function y(e) {\n return (await s.execute({\n sql: \"select * from employees where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function x(e, t, n, r) {\n const a = await s.execute({\n sql:\n \"insert into employees (name, slug, password_salt, password_hash) values (?, ?, ?, ?)\",\n args: [e, t, n, r],\n });\n return Number(a.lastInsertRowid);\n}\nasync function b(e, t, n) {\n await s.execute({\n sql:\n \"update employees set password_salt = ?, password_hash = ? where id = ?\",\n args: [t, n, e],\n });\n}\nasync function f(e, t) {\n await s.execute({\n sql: \"update employees set active = ? where id = ?\",\n args: [t ? 1 : 0, e],\n });\n}\nasync function h(e, t) {\n await s.execute({\n sql: \"update employees set last_active_date = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function j(e, t) {\n await s.execute({\n sql: \"update employees set telegram_link_code = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function q(e, t) {\n const r =\n (await s.execute({\n sql: \"select * from employees where telegram_link_code = ?\",\n args: [e],\n })).rows[0];\n return r\n ? (await s.execute({\n sql:\n \"update employees set telegram_chat_id = ?, telegram_link_code = null where id = ?\",\n args: [t, r.id],\n }),\n r)\n : null;\n}\nasync function P(e = !0) {\n const t = e\n ? \"select * from projects order by (status = 'active') desc, name\"\n : \"select * from projects where status = 'active' order by name\";\n return (await s.execute(t)).rows;\n}\nasync function T(e) {\n return (await s.execute({\n sql: \"select * from projects where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function S(e, t) {\n const n = await s.execute({\n sql: \"insert into projects (name, description) values (?, ?)\",\n args: [e, t],\n });\n return Number(n.lastInsertRowid);\n}\nasync function N(e, t) {\n await s.execute({\n sql: \"update projects set status = ? where id = ?\",\n args: [t, e],\n });\n}\nasync function v(e) {\n return (await s.execute({\n sql: \"select * from weeks where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function w(e, t) {\n return (await s.execute({\n sql: \"select * from weeks where employee_id = ? and week_start = ?\",\n args: [e, t],\n })).rows[0] ?? null;\n}\nasync function E(e, t) {\n const n = await w(e, t);\n return n ||\n (await s.execute({\n sql:\n `insert into weeks (employee_id, week_start) values (?, ?) on conflict(employee_id, week_start) do nothing`,\n args: [e, t],\n }),\n await w(e, t));\n}\nasync function W(e, t, n) {\n await s.execute({\n sql:\n \"update weeks set summary_done = ?, summary_blockers = ?, submitted_at = datetime('now') where id = ?\",\n args: [t, n, e],\n });\n}\nasync function R(e, t = 12) {\n return (await s.execute({\n sql:\n \"select * from weeks where employee_id = ? order by week_start desc limit ?\",\n args: [e, t],\n })).rows;\n}\nasync function O(e) {\n const t = {};\n if (e.length === 0) return t;\n const n = e.map(() => \"?\").join(\",\"),\n r = await s.execute({\n sql:\n `select w.week_start as week_start, count(t.id) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from weeks w left join tasks t on t.week_id = w.id where w.week_start in (${n}) group by w.week_start`,\n args: e,\n });\n for (const a of r.rows) {\n t[String(a.week_start)] = {\n total: Number(a.total) || 0,\n done: Number(a.done) || 0,\n };\n }\n return t;\n}\nasync function $(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select t.project_id as project_id, count(*) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from tasks t join weeks w on w.id = t.week_id where w.week_start = ? and t.project_id is not null group by t.project_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.project_id)] = {\n total: Number(r.total) || 0,\n done: Number(r.done) || 0,\n };\n }\n return t;\n}\nasync function C(e) {\n return (await s.execute({\n sql: \"select * from stages where project_id = ? order by position, id\",\n args: [e],\n })).rows;\n}\nasync function F() {\n return (await s.execute(\n `select s.*, p.name as project_name from stages s join projects p on p.id = s.project_id where p.status = 'active' order by p.name, s.position, s.id`,\n )).rows;\n}\nasync function A(e) {\n return (await s.execute({\n sql: \"select * from stages where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function L(e, t, n, r) {\n const a = await s.execute({\n sql:\n \"select coalesce(max(position), 0) + 1 as next from stages where project_id = ?\",\n args: [e],\n }),\n o = Number(a.rows[0]?.next ?? 1),\n i = await s.execute({\n sql:\n \"insert into stages (project_id, name, start_date, end_date, position) values (?, ?, ?, ?, ?)\",\n args: [e, t, n, r, o],\n });\n return Number(i.lastInsertRowid);\n}\nasync function B(e, t, n, r) {\n await s.execute({\n sql:\n \"update stages set name = ?, start_date = ?, end_date = ? where id = ?\",\n args: [t, n, r, e],\n });\n}\nasync function I(e) {\n await s.execute({\n sql: \"update tasks set stage_id = null where stage_id = ?\",\n args: [e],\n }), await s.execute({ sql: \"delete from stages where id = ?\", args: [e] });\n}\nasync function U(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select t.stage_id as stage_id, count(*) as total, sum(case when t.status = 'done' then 1 else 0 end) as done from tasks t where t.project_id = ? and t.stage_id is not null and not exists (select 1 from tasks c where c.parent_task_id = t.id) group by t.stage_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.stage_id)] = {\n total: Number(r.total) || 0,\n done: Number(r.done) || 0,\n };\n }\n return t;\n}\nasync function z() {\n const e = {},\n t = await s.execute(\n `select project_id, count(*) as total, sum(case when status = 'done' then 1 else 0 end) as done, sum(case when status = 'blocked' then 1 else 0 end) as blocked from tasks t where project_id is not null and not exists (select 1 from tasks c where c.parent_task_id = t.id) group by project_id`,\n );\n for (const n of t.rows) {\n e[Number(n.project_id)] = {\n total: Number(n.total) || 0,\n done: Number(n.done) || 0,\n blocked: Number(n.blocked) || 0,\n };\n }\n return e;\n}\nasync function D(e) {\n return (await s.execute({\n sql:\n `select t.*, e.name as employee_name, e.slug as employee_slug, w.week_start as week_start, s.name as stage_name from tasks t join weeks w on w.id = t.week_id join employees e on e.id = w.employee_id left join stages s on s.id = t.stage_id where t.project_id = ? and not exists (select 1 from tasks c where c.parent_task_id = t.id) order by case t.status when 'blocked' then 0 when 'in_progress' then 1 when 'todo' then 2 else 3 end, t.priority asc, w.week_start desc, t.id`,\n args: [e],\n })).rows;\n}\nasync function G(e) {\n const t = {},\n n = await s.execute({\n sql:\n `select w.employee_id as employee_id, sum(case when t.status <> 'done' then 1 else 0 end) as open_count, sum(case when t.status <> 'done' then (case t.priority when 1 then 3 when 3 then 1 else 2 end) else 0 end) as weighted, sum(case when t.status <> 'done' and t.priority = 1 then 1 else 0 end) as high_count from weeks w join tasks t on t.week_id = w.id where w.week_start = ? group by w.employee_id`,\n args: [e],\n });\n for (const r of n.rows) {\n t[Number(r.employee_id)] = {\n open: Number(r.open_count) || 0,\n weighted: Number(r.weighted) || 0,\n high: Number(r.high_count) || 0,\n };\n }\n return t;\n}\nasync function H(e) {\n return (await s.execute({\n sql:\n `select * from tasks where week_id = ? order by case status when 'blocked' then 0 when 'in_progress' then 1 when 'todo' then 2 else 3 end, priority asc, case planned_day when 'mon' then 0 when 'tue' then 1 when 'wed' then 2 when 'thu' then 3 when 'fri' then 4 when 'sat' then 5 when 'sun' then 6 else 7 end, id`,\n args: [e],\n })).rows;\n}\nasync function J(e, t, n, r, a = 2, o = null) {\n const i = await s.execute({\n sql:\n `insert into tasks (week_id, project_id, stage_id, title, planned_day, priority, root_created_at) values (?, ?, ?, ?, ?, ?, datetime('now'))`,\n args: [e, t, o, n, r, a],\n }),\n d = Number(i.lastInsertRowid);\n return await c(d, \"todo\"), d;\n}\nasync function K(e, t) {\n await s.execute({\n sql:\n \"update tasks set priority = ?, updated_at = datetime('now') where id = ?\",\n args: [t, e],\n });\n}\nasync function l(e) {\n return (await s.execute({\n sql: \"select * from tasks where id = ?\",\n args: [e],\n })).rows[0] ?? null;\n}\nasync function M(e, t, n) {\n const r = await l(e);\n await s.execute({\n sql:\n `update tasks set status = ?, note = ?, updated_at = datetime('now'), closed_at = case when ? = 'done' then datetime('now') else null end where id = ?`,\n args: [t, n, t, e],\n }),\n (!r || r.status !== t) && await c(e, t);\n}\nasync function c(e, t) {\n await s.execute({\n sql: \"insert into task_status_log (task_id, status) values (?, ?)\",\n args: [e, t],\n });\n}\nasync function Q(e) {\n const t = await l(e);\n await s.execute({\n sql: \"update tasks set parent_task_id = ? where parent_task_id = ?\",\n args: [t?.parent_task_id ?? null, e],\n }),\n await s.execute({\n sql: \"delete from task_status_log where task_id = ?\",\n args: [e],\n }),\n await s.execute({ sql: \"delete from tasks where id = ?\", args: [e] });\n}\nasync function V(e, t) {\n if (t.carried_at) return 0;\n const r = (await s.execute({\n sql:\n `select t.* from tasks t join weeks w on w.id = t.week_id where w.employee_id = ? and w.week_start < ? and t.status <> 'done' and not exists (select 1 from tasks c where c.parent_task_id = t.id) order by t.priority asc, t.id`,\n args: [e, t.week_start],\n })).rows;\n for (const a of r) {\n const o = await s.execute({\n sql:\n `insert into tasks (week_id, project_id, stage_id, title, planned_day, status, note, priority, parent_task_id, root_created_at, carried_count) values (?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?)`,\n args: [\n t.id,\n a.project_id,\n a.stage_id,\n a.title,\n a.status,\n a.note,\n a.priority,\n a.id,\n a.root_created_at ?? a.created_at,\n (a.carried_count ?? 0) + 1,\n ],\n });\n await c(Number(o.lastInsertRowid), a.status);\n }\n return await s.execute({\n sql: \"update weeks set carried_at = datetime('now') where id = ?\",\n args: [t.id],\n }),\n r.length;\n}\nasync function X(e) {\n let t = await l(e);\n if (!t) return [];\n const n = new Set([t.id]);\n for (; t.parent_task_id && !n.has(t.parent_task_id);) {\n const i = await l(t.parent_task_id);\n if (!i) break;\n n.add(i.id), t = i;\n }\n const r = [];\n let a = t;\n const o = new Set();\n for (; a && !o.has(a.id);) {\n o.add(a.id),\n r.push(a),\n a =\n (await s.execute({\n sql:\n \"select * from tasks where parent_task_id = ? order by id limit 1\",\n args: [a.id],\n })).rows[0] ?? null;\n }\n return r;\n}\nasync function Y(e) {\n if (e.length === 0) return [];\n const t = e.map(() => \"?\").join(\",\");\n return (await s.execute({\n sql:\n `select task_id, status, entered_at from task_status_log where task_id in (${t}) order by entered_at, id`,\n args: e,\n })).rows;\n}\nasync function Z(e = 14) {\n const t = {},\n n = await s.execute({\n sql:\n `select w.employee_id as employee_id, count(*) as cnt from tasks t join weeks w on w.id = t.week_id where t.status <> 'done' and not exists (select 1 from tasks c where c.parent_task_id = t.id) and julianday('now') - julianday(coalesce(t.root_created_at, t.created_at)) > ? group by w.employee_id`,\n args: [e],\n });\n for (const r of n.rows) t[Number(r.employee_id)] = Number(r.cnt) || 0;\n return t;\n}\nasync function ee(e, t, n, r) {\n await s.execute({\n sql:\n \"insert into sessions (token, employee_id, is_manager, expires_at) values (?, ?, ?, ?)\",\n args: [e, t, n ? 1 : 0, r],\n });\n}\nasync function te(e) {\n return (await s.execute({\n sql:\n \"select * from sessions where token = ? and expires_at > datetime('now')\",\n args: [e],\n })).rows[0];\n}\nasync function se(e) {\n await s.execute({ sql: \"delete from sessions where token = ?\", args: [e] });\n}\nexport {\n $ as getProjectTaskStatsForWeek,\n _ as listEmployees,\n A as getStage,\n B as updateStage,\n b as setEmployeePassword,\n C as listStages,\n c as logTaskStatus,\n D as listTasksForProject,\n E as getOrCreateWeek,\n ee as createSession,\n F as listAllStages,\n f as setEmployeeActive,\n G as getWorkloadForWeek,\n H as listTasksForWeek,\n h as touchEmployeeActivity,\n I as deleteStage,\n J as createTask,\n j as setEmployeeTelegramLinkCode,\n K as setTaskPriority,\n k as getEmployeeBySlug,\n L as createStage,\n l as getTask,\n M as updateTaskStatus,\n N as setProjectStatus,\n O as getTeamWeeklyStats,\n P as listProjects,\n p as migrate,\n Q as deleteTask,\n q as linkEmployeeTelegram,\n R as listWeeksForEmployee,\n S as createProject,\n se as deleteSession,\n T as getProject,\n te as getSession,\n U as getStageTaskStats,\n V as carryOverOpenTasks,\n v as getWeekById,\n W as saveWeekSummary,\n w as getWeek,\n X as getTaskChain,\n x as createEmployee,\n Y as getStatusTimeline,\n y as getEmployeeById,\n Z as getStaleTaskCounts,\n z as getAllProjectsProgress,\n};","createdAt",["D",1787822063458],"branchVersion","branchId","09937878-fcd4-436d-8a10-a37b31f009c1","id","699d8c1c-1bf7-4c2e-b21c-0dfd048b1eab","it-dashboard",["D",1787147775378],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","56e724e1-fa2b-4ae1-8e78-c56aa6d5b550","pinnedFileId","bea5a9c4-9bd5-11f1-94a5-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0144b-5ab3-75ed-8bcf-2932d806687d","tursoName","699d8c1c1bf74c2eb21c0dfd048b1eab","tursoHostname","699d8c1c1bf74c2eb21c0dfd048b1eab-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_106":53},"org",{"_100":99,"_101":53,"_102":53,"_18":55,"_103":104,"_105":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",44,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","yaglebova","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":228,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":229,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":230,"_84":231,"_86":232,"_88":25},"tree",[199,200,201,202,203,204,205],"files",[199,200,201,202,203,204,205],"counts",{"_187":63,"_188":189,"_190":189,"_191":192,"_193":194},"contents",[128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":180,"_32":181,"_30":182,"_138":-5,"_41":42,"_40":183,"_140":59,"_38":184,"_13":151,"_33":34,"_35":185,"_24":25,"_144":-5,"_27":186},{"_43":173,"_32":174,"_30":175,"_138":-5,"_41":42,"_40":176,"_140":59,"_38":177,"_13":151,"_33":34,"_35":178,"_24":25,"_144":-5,"_27":179},{"_43":170,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":59,"_38":171,"_13":142,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":172},{"_43":163,"_32":164,"_30":57,"_138":-5,"_41":42,"_40":165,"_140":25,"_38":166,"_13":142,"_33":167,"_35":168,"_24":25,"_144":-5,"_27":169},{"_43":154,"_32":155,"_30":156,"_138":-5,"_41":42,"_40":157,"_140":59,"_38":158,"_13":159,"_33":160,"_35":161,"_24":25,"_144":-5,"_27":162},{"_43":146,"_32":147,"_30":148,"_138":-5,"_41":42,"_40":149,"_140":59,"_38":150,"_13":151,"_33":34,"_35":152,"_24":25,"_144":-5,"_27":153},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":141,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_27":145},"47d7eb69-732c-4e9e-b09a-8fe2d3b8afa6","views.ts","40bc9094-9bdb-11f1-9928-1607ee4eb77e","parentId",32,"latest",["D",1787732536392],5,"import {\n DAY_LABELS as h,\n formatRuDate as y,\n shiftWeek as $,\n weekDates as z,\n} from \"./dates.ts\";\nfunction t(e) {\n return e == null\n ? \"\"\n : e.replace(/&/g, \"&\").replace(//g, \">\")\n .replace(/\"/g, \""\").replace(/'/g, \"'\");\n}\nconst w = {\n todo: \"Запланировано\",\n in_progress: \"В работе\",\n done: \"Сделано\",\n blocked: \"Блокер\",\n },\n P = {\n todo: \"st-todo\",\n in_progress: \"st-progress\",\n done: \"st-done\",\n blocked: \"st-blocked\",\n },\n f = { 1: \"Высокий\", 2: \"Обычный\", 3: \"Низкий\" },\n T = { 1: \"pr-high\", 2: \"pr-normal\", 3: \"pr-low\" };\nfunction k(e) {\n return `${w[e] ?? e}`;\n}\nfunction j(e) {\n const r = e ?? 2;\n return `${\n f[r] ?? \"Обычный\"\n }`;\n}\nfunction R(e, r, o) {\n return e === r\n ? ' Сегодня'\n : e === o\n ? ' Вчера'\n : e\n ? ` ${y(e)}`\n : ' Нет данных';\n}\nfunction _(e) {\n if (!e) return \"—\";\n const [r, o, s] = e.split(\"-\");\n return !r || !o || !s ? e : `${s}.${o}.${r.slice(2)}`;\n}\nfunction x(e) {\n return `${e.slice(8, 10)}.${e.slice(5, 7)}`;\n}\nfunction E(e, r = 70) {\n if (!e) return \"\";\n const o = e.trim();\n if (!o) return \"\";\n const s = o.length > r ? `${o.slice(0, r)}…` : o;\n return `

✓ ${t(s)}

`;\n}\nfunction g(e, r, o = \"\") {\n const s = r ? Math.round(e / r * 100) : 0;\n return `

= 100 ? \"pb-done\" : s >= 50 ? \"pb-mid\" : \"pb-low\"\n } ${o}\">

`;\n}\nfunction M(e) {\n const r = e?.weighted ?? 0, o = e?.open ?? 0;\n let s = \"Свободен\", c = \"wl-free\", l = 4;\n r > 18\n ? (s = \"Перегрузка\", c = \"wl-over\", l = 100)\n : r > 12\n ? (s = \"Высокая\", c = \"wl-high\", l = 82)\n : r > 6\n ? (s = \"Нормальная\", c = \"wl-normal\", l = 58)\n : r > 0 && (s = \"Низкая\", c = \"wl-low\", l = 30);\n const d = `${o} откр. задач${\n e?.high ? `, из них ${e.high} с высоким приоритетом` : \"\"\n }`;\n return `

${s} ${o}

`;\n}\nconst B =\n ` :root { --bg: #f5f6f9; --surface: #ffffff; --surface-2: #f2f4f8; --surface-3: #e9edf4; --border: #e2e6ee; --border-strong: #ccd3e0; --text: #171a21; --text-2: #414753; --muted: #737b8c; --accent: #5a5bd8; --accent-2: #4749c4; --accent-soft: #eeeefc; --ok: #14915b; --ok-soft: #e6f6ee; --warn: #b4720a; --warn-soft: #fdf3e2; --bad: #cf3538; --bad-soft: #fdecec; --radius: 14px; --radius-sm: 9px; --shadow: 0 1px 2px rgba(20,25,40,.05), 0 4px 14px rgba(20,25,40,.05); --shadow-lg: 0 2px 6px rgba(20,25,40,.06), 0 16px 40px rgba(20,25,40,.09); } * { box-sizing: border-box; } html, body { margin: 0; padding: 0; } body { background: var(--bg); background-image: radial-gradient(1100px 460px at 12% -10%, #eceefe 0%, rgba(236,238,254,0) 62%); background-repeat: no-repeat; color: var(--text); font-family: -apple-system, BlinkMacSystemFont, \"Inter\", \"Segoe UI\", Roboto, sans-serif; font-size: 15px; line-height: 1.55; -webkit-font-smoothing: antialiased; } a { color: var(--accent); text-decoration: none; } a:hover { text-decoration: underline; } .container { max-width: 1120px; margin: 0 auto; padding: 0 24px 72px; } header.topbar { background: rgba(255,255,255,.82); backdrop-filter: saturate(180%) blur(10px); border-bottom: 1px solid var(--border); margin-bottom: 30px; position: sticky; top: 0; z-index: 10; } .topbar-inner { max-width: 1120px; margin: 0 auto; padding: 13px 24px; display: flex; align-items: center; justify-content: space-between; gap: 16px; } .brand { font-weight: 650; font-size: 15px; letter-spacing: -0.015em; color: var(--text); display: flex; align-items: center; gap: 9px; } .brand-dot { width: 9px; height: 9px; border-radius: 3px; background: linear-gradient(140deg, var(--accent), #8b7bf5); display: inline-block; } nav.topnav { display: flex; gap: 3px; align-items: center; } nav.topnav a { color: var(--text-2); padding: 6px 13px; border-radius: 8px; font-size: 14px; font-weight: 500; } nav.topnav a:hover { color: var(--text); background: var(--surface-2); text-decoration: none; } nav.topnav a.active { color: var(--accent); background: var(--accent-soft); } .who { color: var(--muted); font-size: 13px; margin-left: 10px; } h1 { font-size: 25px; font-weight: 660; letter-spacing: -0.022em; margin: 0 0 5px; } h2 { font-size: 15px; font-weight: 620; margin: 0 0 14px; letter-spacing: -0.01em; } .subtitle { color: var(--muted); font-size: 14px; margin: 0 0 26px; } .card { background: var(--surface); border: 1px solid var(--border); border-radius: var(--radius); padding: 22px; margin-bottom: 18px; box-shadow: var(--shadow); } .card-head { display: flex; align-items: baseline; justify-content: space-between; gap: 12px; margin-bottom: 14px; } .card-head h2 { margin: 0; } .grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(240px, 1fr)); gap: 12px; } table { width: 100%; border-collapse: collapse; } th, td { text-align: left; padding: 12px 12px; border-bottom: 1px solid var(--border); font-size: 14px; vertical-align: middle; } th { color: var(--muted); font-weight: 550; font-size: 11px; text-transform: uppercase; letter-spacing: 0.06em; } tr:last-child td { border-bottom: none; } tr.row-link { cursor: pointer; transition: background .12s ease; } tr.row-link:hover { background: var(--surface-2); } .badge { display: inline-block; padding: 3px 10px; border-radius: 999px; font-size: 12px; font-weight: 550; background: var(--surface-2); color: var(--text-2); border: 1px solid var(--border); white-space: nowrap; } .st-todo { color: var(--text-2); } .st-progress { color: var(--accent); border-color: #d6d6f7; background: var(--accent-soft); } .st-done { color: var(--ok); border-color: #c4e8d6; background: var(--ok-soft); } .st-blocked { color: var(--bad); border-color: #f6cdcd; background: var(--bad-soft); } .pr-high { color: var(--bad); border-color: #f6cdcd; background: var(--bad-soft); } .pr-normal { color: var(--text-2); } .pr-low { color: var(--muted); background: transparent; } .dot { display: inline-block; width: 7px; height: 7px; border-radius: 50%; margin-right: 5px; vertical-align: 1px; } .dot-ok { background: var(--ok); } .dot-warn { background: var(--warn); } .dot-bad { background: var(--bad); } .btn { display: inline-flex; align-items: center; gap: 6px; padding: 8px 15px; border-radius: var(--radius-sm); border: 1px solid var(--border-strong); background: var(--surface); color: var(--text); font-size: 14px; font-weight: 530; cursor: pointer; font-family: inherit; transition: background .12s ease, border-color .12s ease; } .btn:hover { background: var(--surface-2); border-color: #b9c2d4; text-decoration: none; } .btn-primary { background: var(--accent); border-color: var(--accent); color: #fff; box-shadow: 0 1px 2px rgba(90,91,216,.3); } .btn-primary:hover { background: var(--accent-2); border-color: var(--accent-2); } .btn-danger { color: var(--bad); border-color: #f0d3d3; } .btn-danger:hover { background: var(--bad-soft); border-color: #e6b9b9; } .btn-sm { padding: 5px 11px; font-size: 13px; } input, select, textarea { background: var(--surface); border: 1px solid var(--border-strong); color: var(--text); border-radius: var(--radius-sm); padding: 9px 11px; font-size: 14px; font-family: inherit; width: 100%; transition: border-color .12s ease, box-shadow .12s ease; } input:focus, select:focus, textarea:focus { outline: none; border-color: var(--accent); box-shadow: 0 0 0 3px rgba(90,91,216,.14); } label { display: block; font-size: 12.5px; color: var(--muted); margin-bottom: 6px; font-weight: 500; } .field { margin-bottom: 14px; } .row { display: flex; gap: 11px; flex-wrap: wrap; } .row > * { flex: 1; min-width: 150px; } form.inline { display: inline; } select.mini { padding: 5px 8px; font-size: 13px; width: auto; min-width: 116px; } .progress-bar { height: 7px; border-radius: 999px; background: var(--surface-3); overflow: hidden; } .progress-bar > div { height: 100%; border-radius: 999px; background: var(--accent); transition: width .2s ease; } .pb-low > div { background: #8b8ff0; } .pb-mid > div { background: var(--accent); } .pb-done > div { background: var(--ok); } .day-tag { color: var(--muted); font-size: 12.5px; } .empty { color: var(--muted); font-size: 14px; padding: 30px 0; text-align: center; } .week-nav { display: flex; align-items: center; gap: 12px; margin-bottom: 20px; flex-wrap: wrap; } .week-nav .label { font-weight: 560; } .flash { background: var(--ok-soft); border: 1px solid #c4e8d6; color: #0f7048; padding: 11px 15px; border-radius: var(--radius-sm); margin-bottom: 16px; font-size: 14px; } .flash-bad { background: var(--bad-soft); border-color: #f6cdcd; color: var(--bad); } .center-page { min-height: 100vh; display: flex; align-items: center; justify-content: center; padding: 24px; } .login-card { width: 100%; max-width: 380px; box-shadow: var(--shadow-lg); } code.pw { background: var(--surface-2); border: 1px solid var(--border); padding: 2px 8px; border-radius: 6px; font-size: 14px; font-family: ui-monospace, SFMono-Regular, Menlo, monospace; } .muted { color: var(--muted); } .small { font-size: 13px; } hr.sep { border: none; border-top: 1px solid var(--border); margin: 18px 0; } .kpi-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(158px, 1fr)); gap: 13px; margin-bottom: 18px; } .kpi-tile { background: var(--surface); border: 1px solid var(--border); border-radius: var(--radius); padding: 17px 19px; box-shadow: var(--shadow); } .kpi-tile .num { font-size: 27px; font-weight: 640; letter-spacing: -0.03em; } .kpi-tile .num.bad { color: var(--bad); } .kpi-tile .num.ok { color: var(--ok); } .kpi-tile .lbl { color: var(--muted); font-size: 12.5px; margin-top: 3px; } .trend { display: flex; align-items: flex-end; gap: 10px; height: 104px; padding-top: 8px; } .trend-col { flex: 1; display: flex; flex-direction: column; align-items: center; justify-content: flex-end; height: 100%; } .trend-bar { width: 100%; max-width: 40px; background: var(--surface-3); border-radius: 6px; overflow: hidden; display: flex; align-items: flex-end; flex: 1; } .trend-bar > div { width: 100%; background: linear-gradient(180deg, #7b7cea, var(--accent)); border-radius: 6px; } .trend-pct { font-size: 11.5px; color: var(--text-2); margin-top: 7px; font-weight: 550; } .trend-label { font-size: 11px; color: var(--muted); margin-top: 1px; } .summary-preview { color: var(--muted); font-size: 12px; margin-top: 3px; max-width: 320px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; } .workload { min-width: 132px; } .wl-track { height: 6px; border-radius: 999px; background: var(--surface-3); overflow: hidden; } .wl-fill { height: 100%; border-radius: 999px; background: var(--muted); } .wl-label { font-size: 12.5px; margin-top: 5px; color: var(--text-2); font-weight: 520; } .wl-num { color: var(--muted); font-weight: 400; } .wl-free .wl-fill { background: var(--border-strong); } .wl-low .wl-fill { background: #6fbf95; } .wl-normal .wl-fill { background: var(--accent); } .wl-high .wl-fill { background: #e0942a; } .wl-high .wl-label { color: var(--warn); } .wl-over .wl-fill { background: var(--bad); } .wl-over .wl-label { color: var(--bad); } .proj-head { display: flex; align-items: flex-start; justify-content: space-between; gap: 20px; flex-wrap: wrap; } .proj-progress { min-width: 260px; flex: 1; } .proj-progress .meta { display: flex; justify-content: space-between; font-size: 13px; color: var(--muted); margin-bottom: 7px; } .proj-progress .meta b { color: var(--text); font-weight: 600; } .stage { border: 1px solid var(--border); border-radius: var(--radius-sm); padding: 14px 16px; margin-bottom: 11px; background: var(--surface-2); } .stage-top { display: flex; align-items: baseline; justify-content: space-between; gap: 12px; flex-wrap: wrap; margin-bottom: 9px; } .stage-name { font-weight: 580; font-size: 14.5px; } .stage-dates { font-size: 12.5px; color: var(--muted); font-variant-numeric: tabular-nums; } .stage-foot { display: flex; align-items: center; gap: 12px; margin-top: 8px; } .stage-foot .progress-bar { flex: 1; } .stage-foot .cnt { font-size: 12.5px; color: var(--muted); white-space: nowrap; } details.stage-edit { margin-top: 10px; } details.stage-edit > summary { cursor: pointer; font-size: 12.5px; color: var(--muted); list-style: none; } details.stage-edit > summary::-webkit-details-marker { display: none; } details.stage-edit > summary:hover { color: var(--accent); } details.stage-edit[open] > summary { margin-bottom: 11px; } @media (max-width: 720px) { .container { padding: 0 15px 56px; } .topbar-inner { padding: 11px 15px; } th, td { padding: 10px 8px; } h1 { font-size: 21px; } } `;\nfunction b(e) {\n const r = e.nav;\n let o = \"\";\n if (r?.isManager) {\n const s = r.activePath ?? \"\";\n o = ` `;\n } else {r?.employeeName &&\n (o = ``);}\n return ` ${\n t(e.title)\n } · IT-дашборд ${\n r\n ? ``\n : \"\"\n }

${e.bodyHtml}

`;\n}\nfunction D(e) {\n const r = e.isManager ? \"/manager/login\" : `/u/${t(e.slug ?? \"\")}/login`,\n o = e.isManager ? \"Вход руководителя\" : \"Личный кабинет\",\n s =\n `

${o}

${\n e.isManager\n ? \"Введите пароль руководителя\"\n : `Введите пароль, чтобы открыть страницу ${\n e.slug ? `«${t(e.slug)}»` : \"\"\n }`\n }

${\n e.error ? `

${t(e.error)}

` : \"\"\n }

`;\n return b({ title: o, bodyHtml: s });\n}\nfunction Y(e) {\n const r = e.employees.map((n) => {\n const i = e.statsByEmployee[n.id] ??\n {\n total: 0,\n done: 0,\n blocked: 0,\n inProgress: 0,\n todo: 0,\n summaryDone: null,\n submittedAt: null,\n },\n a = i.total ? Math.round(i.done / i.total * 100) : 0;\n return `

${\n t(n.name)\n }

${E(i.summaryDone)} ${\n R(n.last_active_date, e.today, e.yesterday)\n } ${\n g(i.done, i.total)\n }

${i.done}/${i.total} задач · ${a}%

${\n M(e.workload[n.id])\n } ${\n i.blocked\n ? `${i.blocked} блок.`\n : '—'\n } ${i.inProgress} в работе · ${i.todo} в плане `;\n }).join(\"\"),\n o = e.employees.reduce((n, i) => {\n const a = e.statsByEmployee[i.id];\n return a &&\n (n.total += a.total, n.done += a.done, n.blocked += a.blocked),\n n;\n }, { total: 0, done: 0, blocked: 0 }),\n s = o.total ? Math.round(o.done / o.total * 100) : 0,\n c = e.employees.filter((n) => !e.statsByEmployee[n.id]?.submittedAt).length,\n l =\n e.employees.filter((n) => (e.workload[n.id]?.weighted ?? 0) > 12).length,\n d =\n `

${e.employees.length}

Активных сотрудников

${o.done}/${o.total}

Задач сделано за неделю

= 70 ? \"ok\" : \"\"\n }\">${s}%

Выполнение за неделю

${o.blocked}

Заблокированных задач

${l}

Перегруженных сотрудников

${c}

Не подвели итоги недели

`,\n m = `

${\n e.trend.map((n) => {\n const i = n.total ? Math.round(n.done / n.total * 100) : 0,\n a = Math.max(i, n.total ? 4 : 0);\n return `

${\n n.total ? `${i}%` : \"—\"\n }

${\n t(x(n.weekStart))\n }

`;\n }).join(\"\")\n }

`,\n u = e.projects.map((n) => {\n const i = e.projectStats[n.id] ?? { total: 0, done: 0 },\n a = e.projectProgress[n.id] ?? { total: 0, done: 0, blocked: 0 },\n p = a.total ? Math.round(a.done / a.total * 100) : 0;\n return `

${\n t(n.name)\n }

${\n n.description\n ? `

${t(n.description)}

`\n : \"\"\n } ${\n t(n.status)\n } ${\n g(a.done, a.total)\n }

${a.done}/${a.total} · ${p}%

${\n i.total ? `${i.done}/${i.total} на этой неделе` : \"—\"\n } ${\n a.blocked\n ? `${a.blocked}`\n : '—'\n } `;\n }).join(\"\"),\n v = `

Общий дашборд

Неделя: ${\n t(e.weekLabel)\n } · активных сотрудников: ${e.employees.length}

${d}

Динамика выполнения по неделям

${m}

Сотрудники и загрузка

${\n e.employees.length === 0\n ? '

Пока нет сотрудников. Добавьте первого в разделе «Сотрудники и проекты».

'\n : ` ${r}

Сотрудник	Обновление	Прогресс за неделю	Загрузка	Блокеры	Статусы

`\n }

Проекты

${\n e.projects.length === 0\n ? '

Проектов ещё нет.

'\n : ` ${u}

Проект	Статус	Прогресс	На этой неделе	Блокеры

`\n }

`;\n return b({\n title: \"Дашборд\",\n bodyHtml: v,\n nav: { isManager: !0, activePath: \"/\" },\n });\n}\nfunction L(e, r, o) {\n return r.total > 0 && r.done === r.total\n ? { label: \"Завершён\", cls: \"st-done\" }\n : e.end_date && o > e.end_date\n ? { label: \"Срок прошёл\", cls: \"st-blocked\" }\n : e.start_date && o < e.start_date\n ? { label: \"Предстоит\", cls: \"\" }\n : { label: \"Идёт\", cls: \"st-progress\" };\n}\nfunction F(e) {\n const r = e.progress.total\n ? Math.round(e.progress.done / e.progress.total * 100)\n : 0,\n o = e.progress.total - e.progress.done,\n s = e.stages.map((d) => {\n const m = e.stageStats[d.id] ?? { total: 0, done: 0 },\n u = L(d, m, e.today);\n return `

${\n t(d.name)\n } ${u.label}

Начало: ${\n _(d.start_date)\n } · Конец: ${\n _(d.end_date)\n }

${\n g(m.done, m.total)\n } ${m.done}/${m.total} задач

Изменить этап

`;\n }).join(\"\"),\n c = e.tasks.map((d) =>\n `

${t(d.title)}

${\n d.note ? `

${t(d.note)}

` : \"\"\n } ${\n d.stage_name ? t(d.stage_name) : '—'\n } ${t(d.employee_name)} ${\n t(x(d.week_start))\n }${d.planned_day ? ` · ${h[d.planned_day] ?? \"\"}` : \"\"} ${\n j(d.priority)\n } ${k(d.status)} `\n ).join(\"\"),\n l =\n `

← к дашборду

${\n t(e.project.name)\n }

${\n e.project.description ? t(e.project.description) : \"Без описания\"\n } · статус: ${\n t(e.project.status)\n }

Прогресс проекта${r}%

${\n g(e.progress.done, e.progress.total)\n }

${e.progress.done} сделано · ${o} в работе ${\n e.progress.blocked\n ? `${e.progress.blocked} блок.`\n : \"\"\n }

${\n e.flash ? `

${t(e.flash)}

` : \"\"\n }

Этапы

${\n e.stages.length === 0\n ? '

Этапов пока нет — добавьте первый ниже.

'\n : s\n }

Задачи проекта

всего ${e.tasks.length}

${\n e.tasks.length === 0\n ? '

По этому проекту ещё нет задач. Они появятся, когда сотрудники привяжут к нему свои задачи.

'\n : ` ${c}

Задача	Этап	Исполнитель	Неделя	Приоритет	Статус

`\n }

`;\n return b({ title: e.project.name, bodyHtml: l, nav: { isManager: !0 } });\n}\nfunction G(e) {\n const r = H(e.tasks, e.projectsById, !0),\n o = `

← ко всем сотрудникам

${\n t(e.employee.name)\n }

Просмотр без права редактирования

${\n S(`/employee/${e.employee.slug}`, e.weekStart, e.weekLabel)\n }

Задачи на неделю

${r}

Итоги недели

${\n e.week?.submitted_at\n ? `

Что сделано:

${\n t(e.week.summary_done) || \"—\"\n }

Что не сделано / почему:

${\n t(e.week.summary_blockers) || \"—\"\n }

`\n : '

Итоги ещё не подведены

'\n }

`;\n return b({ title: e.employee.name, bodyHtml: o, nav: { isManager: !0 } });\n}\nfunction S(e, r, o) {\n const s = $(r, -1), c = $(r, 1);\n return `

← пред. неделя ${\n t(o)\n } след. неделя →

`;\n}\nfunction H(e, r, o) {\n return e.length === 0\n ? '

Задач пока нет

'\n : `${\n o ? \"\" : \"\"\n } ${\n e.map((s) =>\n ` ${o ? \"\" : \"\"} `\n ).join(\"\")\n }

Задача	Проект	День	Приоритет	Статус
${t(s.title)}${\n s.note ? ` ${t(s.note)} ` : \"\"\n }	${\n s.project_id && r[s.project_id]\n ? `${\n t(r[s.project_id].name)\n }`\n : '—'\n }	${\n s.planned_day ? h[s.planned_day] ?? s.planned_day : \"—\"\n }	${j(s.priority)}	${\n k(s.status)\n }

`;\n}\nfunction J(e) {\n const r = Object.fromEntries(e.projects.map((a) => [a.id, a])),\n o = '' +\n e.projects.filter((a) => a.status === \"active\").map((a) =>\n ``\n ).join(\"\"),\n s = [];\n let c = -1;\n for (const a of e.stages) {\n a.project_id !== c &&\n (c !== -1 && s.push(\"\"),\n s.push(``),\n c = a.project_id),\n s.push(``);\n }\n c !== -1 && s.push(\"\");\n const l = '' + s.join(\"\"),\n d = [1, 2, 3].map((a) =>\n ``\n ).join(\"\"),\n m = '' +\n z(e.weekStart).map((a) =>\n ``\n ).join(\"\"),\n u = e.tasks.filter((a) => a.status !== \"done\").reduce(\n (a, p) => a + (p.priority === 1 ? 3 : p.priority === 3 ? 1 : 2),\n 0,\n ),\n v = e.tasks.filter((a) => a.status !== \"done\").length,\n n = e.tasks.length === 0\n ? '

Пока нет задач на эту неделю — добавьте первую ниже

'\n : ` ${\n e.tasks.map((a) =>\n ` `\n ).join(\"\")\n }

Задача	Проект / этап	День	Приоритет	Статус
${\n t(a.title)\n }	${\n a.project_id && r[a.project_id] ? t(r[a.project_id].name) : \"—\"\n }	${\n a.planned_day ? h[a.planned_day] ?? a.planned_day : \"—\"\n }

`,\n i = `

Привет, ${\n t(e.employee.name.split(\" \")[0])\n }

Личный чек-лист задач по неделям

${\n e.flash ? `

${t(e.flash)}

` : \"\"\n } ${\n S(`/u/${e.employee.slug}`, e.weekStart, e.weekLabel)\n }

Задачи

${v} открытых · вес загрузки ${u}

${n}

Итоги недели

Заполните в конце недели: что сделано, что не сделано и почему.

Telegram-напоминания

${\n e.employee.telegram_chat_id\n ? '

Telegram подключён — напоминания приходят в бот.

'\n : `

Чтобы получать ежедневные напоминания, подключите Telegram-бота.

`\n }

`;\n return b({\n title: \"Личный кабинет\",\n bodyHtml: i,\n nav: { employeeName: e.employee.name },\n });\n}\nfunction K(e) {\n const r = `

← назад

Подключение Telegram

Откройте бота и отправьте команду ниже

1. Откройте @${\n t(e.botUsername)\n }

2. Отправьте боту сообщение:

/start ${\n t(e.code)\n }

Код одноразовый и действует до использования.

`;\n return b({\n title: \"Telegram\",\n bodyHtml: r,\n nav: { employeeName: e.employee.name },\n });\n}\nfunction Q(e) {\n const r = e.employees.map((l) =>\n ` ${\n t(l.name)\n } /u/${t(l.slug)} ${\n l.active\n ? 'активен'\n : 'отключён'\n } ${\n l.telegram_chat_id\n ? 'подключён'\n : '—'\n } `\n ).join(\"\"),\n o = e.projects.map((l) =>\n ` ${\n t(l.name)\n } ${\n t(l.description) || \"—\"\n } `\n ).join(\"\"),\n s = e.newEmployee\n ? `

Сотрудник ${\n t(e.newEmployee.name)\n } добавлен.
Ссылка: ${\n t(e.newEmployee.link)\n }
Пароль: ${\n t(e.newEmployee.password)\n }
Сохраните пароль сейчас — повторно он не показывается. Передайте оба значения сотруднику лично.

`\n : \"\",\n c =\n `

Сотрудники и проекты

Управление доступом и списком проектов

${\n e.error ? `

${t(e.error)}

` : \"\"\n } ${s}

Сотрудники

${\n e.employees.length === 0\n ? '

Пока никого нет

'\n : ` ${r}

Имя	Ссылка	Статус	Telegram

`\n }

Проекты

${\n e.projects.length === 0\n ? '

Пока нет проектов

'\n : ` ${o}

Название	Описание	Статус

`\n }

`;\n return b({\n title: \"Сотрудники и проекты\",\n bodyHtml: c,\n nav: { isManager: !0, activePath: \"/admin\" },\n });\n}\nexport {\n b as layout,\n D as loginPage,\n F as projectPage,\n G as employeeReadonlyPage,\n J as employeePage,\n j as priorityBadge,\n K as telegramCodePage,\n k as statusBadge,\n Q as adminPage,\n R as freshnessBadge,\n t as esc,\n Y as managerDashboardPage,\n};","label",[136],"374f2988-8b4c-4671-9c92-b041d28c30c0","telegram.ts","cd2ec746-9bd5-11f1-94a5-1607ee4eb77e",7,["D",1787148687844],2,"async function o(t, n) {\n const r = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n if (!r) {\n return console.warn(\n \"TELEGRAM_BOT_TOKEN не задан — напоминание не отправлено\",\n ),\n !1;\n }\n try {\n const e = await fetch(`https://api.telegram.org/bot${r}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: t, text: n, parse_mode: \"HTML\" }),\n });\n return e.ok\n ? !0\n : (console.error(\"Telegram API error\", e.status, await e.text()), !1);\n } catch (e) {\n return console.error(\"Telegram send failed\", e), !1;\n }\n}\nexport { o as sendTelegramMessage };",[147],"277bdfb2-438d-4628-bd32-29b5e8358e62","reminders.cron.ts","f28b3cb8-9c93-11f1-8b30-1607ee4eb77e",28,["D",1787230178801],3,"interval","import*as s from\"./db.ts\";import{currentWeekStart as u,todayMoscow as g,weekdayMoscow as p}from\"./dates.ts\";import{sendTelegramMessage as k}from\"./telegram.ts\";async function w(_){await s.migrate();const n=p();if(n>5){console.log(\"Выходной по МСК — напоминания не отправляются\");return}const c=g(),m=u(),a=Deno.env.get(\"APP_URL\"),i=await s.listEmployees(!1);let l=0;for(const t of i){if(!t.telegram_chat_id||t.last_active_date===c)continue;const o=await s.getWeek(t.id,m),f=o?await s.listTasksForWeek(o.id):[],r=a?` ${a}/u/${t.slug}`:\"\",e=[];n===1&&f.length===0?e.push(\"Доброе утро! Начинается новая неделя — запланируйте задачи в чек-листе.\"):e.push(\"Не забудьте актуализировать чек-лист задач за сегодня.\"),n===5&&(!o||!o.submitted_at)&&e.push(\"И не забудьте подвести итоги недели: что сделано, что нет и почему.\"),e.push(r?`Открыть: ${r.trim()}`:\"\");const d=e.filter(Boolean).join(` `);await k(t.telegram_chat_id,d)&&l++}console.log(`Напоминания отправлены: ${l} из ${i.length} сотрудников`)}export{w as default};",[155],"8e4b489f-c8fb-41c9-817f-875c35f975c3","index.http.ts",34,["D",1787732694960],"http","import { Hono as O } from \"npm:hono@4\";\nimport * as s from \"./db.ts\";\nimport {\n cookieHeader as D,\n expireCookieHeader as R,\n generateLinkCode as F,\n generateTempPassword as T,\n hashPassword as W,\n newSessionToken as M,\n parseCookies as L,\n slugify as x,\n verifyPassword as U,\n} from \"./auth.ts\";\nimport {\n addDays as G,\n currentWeekStart as y,\n mondayOf as q,\n shiftWeek as H,\n todayMoscow as f,\n weekRangeLabel as P,\n} from \"./dates.ts\";\nimport {\n adminPage as j,\n employeePage as K,\n employeeReadonlyPage as Y,\n loginPage as d,\n managerDashboardPage as z,\n projectPage as J,\n telegramCodePage as Q,\n} from \"./views.ts\";\nimport { sendTelegramMessage as $ } from \"./telegram.ts\";\nconst l = new O(), B = \"vt_session\", A = 30;\nl.use(\"*\", async (e, t) => {\n await s.migrate(), await t();\n});\nfunction I(e) {\n return L(e.req.header(\"Cookie\") ?? null)[B] ?? null;\n}\nasync function N(e) {\n const t = I(e);\n return t ? await s.getSession(t) ?? null : null;\n}\nasync function g(e) {\n const t = await N(e);\n return !!t && t.is_manager === 1;\n}\nasync function v(e, t, a) {\n const r = M(), o = new Date(Date.now() + A * 24 * 3600 * 1e3).toISOString();\n await s.createSession(r, t, a, o),\n e.header(\"Set-Cookie\", D(B, r, A * 24 * 3600));\n}\nasync function V(e) {\n const t = x(e);\n let a = t, r = 2;\n for (; await s.getEmployeeBySlug(a);) a = `${t}-${r}`, r++;\n return a;\n}\nfunction C(e) {\n const t = e.req.query(\"week\");\n return t && /^\\d{4}-\\d{2}-\\d{2}$/.test(t) ? q(t) : y();\n}\nl.get(\"/\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = await s.listEmployees(!1),\n a = await s.listProjects(!0),\n r = y(),\n o = {};\n for (const w of t) {\n const h = await s.getWeek(w.id, r);\n let b = [];\n h && (b = await s.listTasksForWeek(h.id)),\n o[w.id] = {\n total: b.length,\n done: b.filter((k) => k.status === \"done\").length,\n blocked: b.filter((k) => k.status === \"blocked\").length,\n inProgress: b.filter((k) => k.status === \"in_progress\").length,\n todo: b.filter((k) => k.status === \"todo\").length,\n summaryDone: h?.summary_done ?? null,\n submittedAt: h?.submitted_at ?? null,\n };\n }\n const n = f(),\n i = G(n, -1),\n u = Array.from({ length: 6 }, (w, h) => H(r, -(5 - h))),\n m = await s.getTeamWeeklyStats(u),\n c = u.map((w) => ({\n weekStart: w,\n total: m[w]?.total ?? 0,\n done: m[w]?.done ?? 0,\n })),\n p = await s.getProjectTaskStatsForWeek(r),\n _ = await s.getAllProjectsProgress(),\n E = await s.getWorkloadForWeek(r);\n return e.html(\n z({\n employees: t,\n statsByEmployee: o,\n today: n,\n yesterday: i,\n projects: a,\n projectStats: p,\n projectProgress: _,\n workload: E,\n trend: c,\n weekLabel: P(r),\n }),\n );\n}),\n l.get(\"/project/:id\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")), a = await s.getProject(t);\n if (!a) return e.notFound();\n const r = await s.listStages(t),\n o = await s.getStageTaskStats(t),\n n = await s.listTasksForProject(t),\n i = (await s.getAllProjectsProgress())[t] ??\n { total: 0, done: 0, blocked: 0 };\n return e.html(\n J({\n project: a,\n stages: r,\n stageStats: o,\n tasks: n,\n progress: i,\n today: f(),\n flash: e.req.query(\"flash\") ?? void 0,\n }),\n );\n }),\n l.post(\"/project/:id/stages\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")),\n a = await e.req.parseBody(),\n r = String(a.name ?? \"\").trim(),\n o = String(a.start_date ?? \"\").trim() || null,\n n = String(a.end_date ?? \"\").trim() || null;\n return r && await s.createStage(t, r, o, n),\n e.redirect(`/project/${t}`, 303);\n }),\n l.post(\"/project/:id/stages/:stageId\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")),\n a = Number(e.req.param(\"stageId\")),\n r = await e.req.parseBody();\n if (String(r.action ?? \"save\") === \"delete\") await s.deleteStage(a);\n else {\n const n = String(r.name ?? \"\").trim(),\n i = String(r.start_date ?? \"\").trim() || null,\n u = String(r.end_date ?? \"\").trim() || null;\n n && await s.updateStage(a, n, i, u);\n }\n return e.redirect(`/project/${t}`, 303);\n }),\n l.get(\"/employee/:slug\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = await s.getEmployeeBySlug(e.req.param(\"slug\"));\n if (!t) return e.notFound();\n const a = C(e),\n r = await s.getWeek(t.id, a),\n o = r ? await s.listTasksForWeek(r.id) : [],\n n = await s.listProjects(!0),\n i = Object.fromEntries(n.map((u) => [u.id, u]));\n return e.html(\n Y({\n employee: t,\n week: r,\n tasks: o,\n projectsById: i,\n weekStart: a,\n weekLabel: P(a),\n }),\n );\n }),\n l.get(\"/manager/login\", async (e) => e.html(d({ isManager: !0 }))),\n l.post(\"/manager/login\", async (e) => {\n const t = await e.req.parseBody(),\n a = String(t.password ?? \"\"),\n r = Deno.env.get(\"MANAGER_PASSWORD\");\n return r\n ? a !== r\n ? e.html(d({ isManager: !0, error: \"Неверный пароль\" }), 401)\n : (await v(e, null, !0), e.redirect(\"/\", 303))\n : e.html(\n d({\n isManager: !0,\n error:\n \"Переменная окружения MANAGER_PASSWORD не задана. Задайте её в настройках вала.\",\n }),\n 500,\n );\n }),\n l.get(\"/admin\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = await s.listEmployees(!0), a = await s.listProjects(!0);\n return e.html(j({ employees: t, projects: a }));\n }),\n l.post(\"/admin/employees\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = await e.req.parseBody(), a = String(t.name ?? \"\").trim();\n if (!a) {\n const _ = await s.listEmployees(!0), E = await s.listProjects(!0);\n return e.html(\n j({ employees: _, projects: E, error: \"Укажите имя сотрудника\" }),\n 400,\n );\n }\n const r = await V(a), o = T(), { salt: n, hash: i } = await W(o);\n await s.createEmployee(a, r, n, i);\n const u = await s.listEmployees(!0),\n m = await s.listProjects(!0),\n p = `${new URL(e.req.url).origin}/u/${r}`;\n return e.html(\n j({\n employees: u,\n projects: m,\n newEmployee: { name: a, slug: r, password: o, link: p },\n }),\n );\n }),\n l.post(\"/admin/employees/:id/reset-password\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")), a = await s.getEmployeeById(t);\n if (!a) return e.notFound();\n const r = T(), { salt: o, hash: n } = await W(r);\n await s.setEmployeePassword(t, o, n);\n const i = await s.listEmployees(!0),\n u = await s.listProjects(!0),\n c = `${new URL(e.req.url).origin}/u/${a.slug}`;\n return e.html(\n j({\n employees: i,\n projects: u,\n newEmployee: { name: a.name, slug: a.slug, password: r, link: c },\n }),\n );\n }),\n l.post(\"/admin/employees/:id/toggle-active\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")), a = await s.getEmployeeById(t);\n return a\n ? (await s.setEmployeeActive(t, a.active !== 1),\n e.redirect(\"/admin\", 303))\n : e.notFound();\n }),\n l.post(\"/admin/projects\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = await e.req.parseBody(),\n a = String(t.name ?? \"\").trim(),\n r = String(t.description ?? \"\").trim();\n return a && await s.createProject(a, r), e.redirect(\"/admin\", 303);\n }),\n l.post(\"/admin/projects/:id/status\", async (e) => {\n if (!await g(e)) return e.redirect(\"/manager/login\", 303);\n const t = Number(e.req.param(\"id\")),\n a = await e.req.parseBody(),\n r = String(a.status ?? \"active\");\n return await s.setProjectStatus(t, r), e.redirect(\"/admin\", 303);\n }),\n l.get(\"/u/:slug/login\", async (e) => {\n const t = e.req.param(\"slug\");\n return await s.getEmployeeBySlug(t) ? e.html(d({ slug: t })) : e.notFound();\n }),\n l.post(\"/u/:slug/login\", async (e) => {\n const t = e.req.param(\"slug\"), a = await s.getEmployeeBySlug(t);\n if (!a || !a.active) {\n return e.html(\n d({ slug: t, error: \"Страница не найдена или отключена\" }),\n 404,\n );\n }\n const r = await e.req.parseBody(), o = String(r.password ?? \"\");\n return await U(o, a.password_salt, a.password_hash)\n ? (await v(e, a.id, !1), e.redirect(`/u/${t}`, 303))\n : e.html(d({ slug: t, error: \"Неверный пароль\" }), 401);\n });\nasync function S(e, t) {\n const a = await N(e);\n if (!a || a.is_manager === 1 || a.employee_id == null) return null;\n const r = await s.getEmployeeById(a.employee_id);\n return !r || r.slug !== t || !r.active ? null : r;\n}\nl.get(\"/u/:slug\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }));\n const r = C(e),\n o = await s.getOrCreateWeek(a.id, r),\n n = await s.listTasksForWeek(o.id),\n i = await s.listProjects(!0),\n u = await s.listAllStages(),\n m = e.req.query(\"flash\") ?? void 0;\n return e.html(\n K({\n employee: a,\n week: o,\n tasks: n,\n projects: i,\n stages: u,\n weekStart: r,\n weekLabel: P(r),\n isCurrentWeek: r === y(),\n flash: m,\n }),\n );\n}),\n l.post(\"/u/:slug/tasks\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = await e.req.parseBody(),\n o = q(String(r.week ?? y())),\n n = String(r.title ?? \"\").trim();\n let i = r.project_id ? Number(r.project_id) : null;\n const u = r.planned_day ? String(r.planned_day) : null,\n m = r.priority ? Number(r.priority) : 2,\n c = r.stage_id ? Number(r.stage_id) : null;\n if (c) {\n const p = await s.getStage(c);\n p && (i = p.project_id);\n }\n if (n) {\n const p = await s.getOrCreateWeek(a.id, o);\n await s.createTask(p.id, i, n, u, m, c),\n await s.touchEmployeeActivity(a.id, f());\n }\n return e.redirect(`/u/${t}?week=${o}`, 303);\n }),\n l.post(\"/u/:slug/tasks/:id/priority\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = Number(e.req.param(\"id\")),\n o = await e.req.parseBody(),\n n = q(String(o.week ?? y())),\n i = await s.getTask(r);\n if (i) {\n const u = await s.getWeekById(i.week_id);\n u && u.employee_id === a.id &&\n (await s.setTaskPriority(r, Number(o.priority ?? 2)),\n await s.touchEmployeeActivity(a.id, f()));\n }\n return e.redirect(`/u/${t}?week=${n}`, 303);\n }),\n l.post(\"/u/:slug/tasks/:id/status\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = Number(e.req.param(\"id\")),\n o = await e.req.parseBody(),\n n = q(String(o.week ?? y())),\n i = await s.getTask(r);\n if (i) {\n const u = await s.getWeekById(i.week_id);\n if (u && u.employee_id === a.id) {\n const m = String(o.status ?? i.status);\n await s.updateTaskStatus(r, m, i.note ?? \"\"),\n await s.touchEmployeeActivity(a.id, f());\n }\n }\n return e.redirect(`/u/${t}?week=${n}`, 303);\n }),\n l.post(\"/u/:slug/tasks/:id/delete\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = Number(e.req.param(\"id\")),\n o = await e.req.parseBody(),\n n = q(String(o.week ?? y())),\n i = await s.getTask(r);\n if (i) {\n const u = await s.getWeekById(i.week_id);\n u && u.employee_id === a.id &&\n (await s.deleteTask(r), await s.touchEmployeeActivity(a.id, f()));\n }\n return e.redirect(`/u/${t}?week=${n}`, 303);\n }),\n l.post(\"/u/:slug/summary\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = await e.req.parseBody(),\n o = q(String(r.week ?? y())),\n n = await s.getOrCreateWeek(a.id, o);\n return await s.saveWeekSummary(\n n.id,\n String(r.summary_done ?? \"\"),\n String(r.summary_blockers ?? \"\"),\n ),\n await s.touchEmployeeActivity(a.id, f()),\n e.redirect(\n `/u/${t}?week=${o}&flash=${\n encodeURIComponent(\"Итоги недели сохранены\")\n }`,\n 303,\n );\n }),\n l.post(\"/u/:slug/telegram/code\", async (e) => {\n const t = e.req.param(\"slug\"), a = await S(e, t);\n if (!a) return e.html(d({ slug: t }), 401);\n const r = F();\n await s.setEmployeeTelegramLinkCode(a.id, r);\n const o = Deno.env.get(\"TELEGRAM_BOT_USERNAME\") ?? \"your_bot\";\n return e.html(Q({ employee: a, botUsername: o, code: r }));\n }),\n l.post(\"/telegram/webhook\", async (e) => {\n try {\n const a = (await e.req.json()).message;\n if (a?.text && a?.chat?.id) {\n const r = String(a.text).trim();\n if (r.startsWith(\"/start\")) {\n const o = r.replace(\"/start\", \"\").trim().toUpperCase();\n if (o) {\n const n = await s.linkEmployeeTelegram(o, String(a.chat.id));\n n\n ? await $(\n String(a.chat.id),\n `Готово! Буду присылать напоминания сюда, ${n.name}.`,\n )\n : await $(\n String(a.chat.id),\n \"Код не найден или уже использован. Получите новый код в личном кабинете.\",\n );\n }\n }\n }\n } catch (t) {\n console.error(\"telegram webhook error\", t);\n }\n return e.json({ ok: !0 });\n }),\n l.get(\"/logout\", async (e) => {\n const t = I(e);\n let a = \"/manager/login\";\n if (t) {\n const r = await s.getSession(t);\n if (r && !r.is_manager && r.employee_id != null) {\n const o = await s.getEmployeeById(r.employee_id);\n o && (a = `/u/${o.slug}/login`);\n }\n await s.deleteSession(t);\n }\n return e.header(\"Set-Cookie\", R(B)), e.redirect(a, 303);\n });\nvar re = l.fetch;\nexport { re as default };",[164],"4dd1cb4f-cd11-4823-a1a9-a4d59436505f",["D",1787822063458],[28],"5ea58f63-7d23-49ef-85e0-c0037877d29d","dates.ts","00dd36e2-9bd9-11f1-82db-1607ee4eb77e",16,["D",1787149248449],"const s = \"Europe/Moscow\";\nfunction c() {\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: s,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(new Date());\n}\nfunction D() {\n const n = new Intl.DateTimeFormat(\"en-US\", { timeZone: s, weekday: \"short\" })\n .format(new Date());\n return { Mon: 1, Tue: 2, Wed: 3, Thu: 4, Fri: 5, Sat: 6, Sun: 7 }[n] ?? 1;\n}\nfunction o(n) {\n const [t, e, r] = n.split(\"-\").map(Number);\n return new Date(Date.UTC(t, e - 1, r));\n}\nfunction i(n) {\n const t = n.getUTCFullYear(),\n e = String(n.getUTCMonth() + 1).padStart(2, \"0\"),\n r = String(n.getUTCDate()).padStart(2, \"0\");\n return `${t}-${e}-${r}`;\n}\nfunction g(n) {\n const t = o(n), e = t.getUTCDay() === 0 ? 7 : t.getUTCDay();\n return t.setUTCDate(t.getUTCDate() - (e - 1)), i(t);\n}\nfunction p() {\n return g(c());\n}\nfunction a(n, t) {\n const e = o(n);\n return e.setUTCDate(e.getUTCDate() + t), i(e);\n}\nfunction f(n, t) {\n return a(n, t * 7);\n}\nconst m = [\"mon\", \"tue\", \"wed\", \"thu\", \"fri\", \"sat\", \"sun\"],\n d = {\n mon: \"Пн\",\n tue: \"Вт\",\n wed: \"Ср\",\n thu: \"Чт\",\n fri: \"Пт\",\n sat: \"Сб\",\n sun: \"Вс\",\n };\nfunction T(n) {\n return m.map((t, e) => ({ key: t, date: a(n, e), label: d[t] }));\n}\nfunction u(n) {\n const t = o(n);\n return new Intl.DateTimeFormat(\"ru-RU\", {\n timeZone: \"UTC\",\n day: \"numeric\",\n month: \"long\",\n }).format(t);\n}\nfunction w(n) {\n const t = a(n, 6);\n return `${u(n)} – ${u(t)}`;\n}\nexport {\n a as addDays,\n c as todayMoscow,\n D as weekdayMoscow,\n d as DAY_LABELS,\n f as shiftWeek,\n g as mondayOf,\n m as DAY_KEYS,\n p as currentWeekStart,\n T as weekDates,\n u as formatRuDate,\n w as weekRangeLabel,\n};",[174],"17ceb2cb-8d06-4262-ae71-eeed99bd5339","auth.ts","23cd9346-9bd8-11f1-9c49-1607ee4eb77e",13,["D",1787149139587],"function a(t) {\n return [...new Uint8Array(t)].map((r) => r.toString(16).padStart(2, \"0\"))\n .join(\"\");\n}\nfunction c(t) {\n const r = new Uint8Array(t.length / 2);\n for (let n = 0; n < r.length; n++) {\n r[n] = parseInt(t.slice(n * 2, n * 2 + 2), 16);\n }\n return r;\n}\nfunction u(t) {\n const r = new Uint8Array(t);\n return crypto.getRandomValues(r), a(r.buffer);\n}\nasync function g(t, r) {\n const n = new TextEncoder(),\n e = await crypto.subtle.importKey(\"raw\", n.encode(t), \"PBKDF2\", !1, [\n \"deriveBits\",\n ]);\n return crypto.subtle.deriveBits(\n {\n name: \"PBKDF2\",\n salt: r.slice().buffer,\n iterations: 1e5,\n hash: \"SHA-256\",\n },\n e,\n 256,\n );\n}\nasync function f(t) {\n const r = u(16), n = await g(t, c(r));\n return { salt: r, hash: a(n) };\n}\nasync function l(t, r, n) {\n const e = await g(t, c(r)), o = a(e);\n if (o.length !== n.length) return !1;\n let s = 0;\n for (let i = 0; i < o.length; i++) s |= o.charCodeAt(i) ^ n.charCodeAt(i);\n return s === 0;\n}\nfunction p() {\n return u(32);\n}\nfunction y() {\n const t = \"23456789ABCDEFGHJKMNPQRSTUVWXYZabcdefghjkmnpqrstuvwxyz\",\n r = new Uint8Array(10);\n return crypto.getRandomValues(r), [...r].map((n) => t[n % t.length]).join(\"\");\n}\nfunction d() {\n const t = new Uint8Array(4);\n return crypto.getRandomValues(t), a(t.buffer).toUpperCase();\n}\nfunction h(t) {\n const r = {\n а: \"a\",\n б: \"b\",\n в: \"v\",\n г: \"g\",\n д: \"d\",\n е: \"e\",\n ё: \"e\",\n ж: \"zh\",\n з: \"z\",\n и: \"i\",\n й: \"y\",\n к: \"k\",\n л: \"l\",\n м: \"m\",\n н: \"n\",\n о: \"o\",\n п: \"p\",\n р: \"r\",\n с: \"s\",\n т: \"t\",\n у: \"u\",\n ф: \"f\",\n х: \"h\",\n ц: \"ts\",\n ч: \"ch\",\n ш: \"sh\",\n щ: \"sch\",\n ъ: \"\",\n ы: \"y\",\n ь: \"\",\n э: \"e\",\n ю: \"yu\",\n я: \"ya\",\n },\n n = t.toLowerCase();\n let e = \"\";\n for (const o of n) e += r[o] ?? o;\n return e.replace(/[^a-z0-9]+/g, \"-\").replace(/^-+|-+$/g, \"\").slice(0, 40) ||\n \"user\";\n}\nfunction m(t, r, n) {\n return `${t}=${r}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=${n}`;\n}\nfunction x(t) {\n return `${t}=; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=0`;\n}\nfunction w(t) {\n const r = {};\n if (!t) return r;\n for (const n of t.split(\";\")) {\n const e = n.indexOf(\"=\");\n if (e === -1) continue;\n const o = n.slice(0, e).trim(), s = n.slice(e + 1).trim();\n r[o] = decodeURIComponent(s);\n }\n return r;\n}\nexport {\n d as generateLinkCode,\n f as hashPassword,\n h as slugify,\n l as verifyPassword,\n m as cookieHeader,\n p as newSessionToken,\n w as parseCookies,\n x as expireCookieHeader,\n y as generateTempPassword,\n};",[181],"pulls","branches",1,"forks","envVars",{"_195":197,"_198":63},"connections",{"_195":63,"_196":63},"count","unfilledCount",4,"emptyCount",{"_43":180,"_32":181,"_30":182,"_138":-5,"_41":42,"_40":183,"_140":59,"_38":225,"_13":151,"_33":34,"_35":185,"_24":25,"_144":-5,"_207":226,"_27":227},{"_43":173,"_32":174,"_30":175,"_138":-5,"_41":42,"_40":176,"_140":59,"_38":222,"_13":151,"_33":34,"_35":178,"_24":25,"_144":-5,"_207":223,"_27":224},{"_43":170,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":59,"_38":219,"_13":142,"_33":34,"_35":37,"_24":25,"_144":-5,"_207":220,"_27":221},{"_43":163,"_32":164,"_30":57,"_138":-5,"_41":42,"_40":165,"_140":25,"_38":216,"_13":142,"_33":167,"_35":168,"_24":25,"_144":-5,"_207":217,"_27":218},{"_43":154,"_32":155,"_30":156,"_138":-5,"_41":42,"_40":157,"_140":59,"_38":213,"_13":159,"_33":160,"_35":161,"_24":25,"_144":-5,"_207":214,"_27":215},{"_43":146,"_32":147,"_30":148,"_138":-5,"_41":42,"_40":149,"_140":59,"_38":210,"_13":151,"_33":34,"_35":152,"_24":25,"_144":-5,"_207":211,"_27":212},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":206,"_13":142,"_33":34,"_35":143,"_24":25,"_144":-5,"_207":208,"_27":209},["D",1787732536392],"children",[],[136],["D",1787148687844],[],[147],["D",1787230178801],[],[155],["D",1787732694960],[],[164],["D",1787822063458],[],[28],["D",1787149248449],[],[174],["D",1787149139587],[],[181],["D",1787147775378],["D",1789484509295],{"_100":99,"_106":53},{"_100":99,"_101":53,"_102":53,"_18":55,"_103":104,"_105":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_125":266,"_267":268,"_269":270,"_271":25,"_272":25,"_273":25,"_274":59,"_275":-5,"_276":-7,"_277":-7,"_278":63,"_279":25,"_280":25,"_281":-5,"_282":25,"_283":25,"_284":25,"_285":-5},"ENV",{"_237":238,"_239":240,"_241":90,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265},"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 · v35