[{"_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":-5},"handle","yanaglebova137","name","it-dashboard","path","summary.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/yanaglebova137/it-dashboard/code/summary.ts","extension","id","a3a7aec2-cab9-4c31-ac4c-345e4b0fd7c6","fileId","3884ed30-adfc-11f1-91c2-1607ee4eb77e","parentId","branchId","c052e08c-bc3b-4791-a404-c6c3b60839df","branchVersion",21,"latest",true,"createdAt",["D",1789370405082],"version",3,"fileType","script","content","import { sqlite as k } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { esc as d, layout as g } from \"./views.ts\";\nimport { weekRangeLabel as h } from \"./dates.ts\";\nconst y = (e) => ({\n weekStart: e,\n total: 0,\n done: 0,\n blocked: 0,\n inProgress: 0,\n carried: 0,\n});\nasync function P(e, t) {\n const s = {};\n for (const i of t) s[i] = y(i);\n if (t.length === 0) return s;\n const a = t.map(() => \"?\").join(\",\"),\n r = await k.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, sum(case when t.status = 'blocked' then 1 else 0 end) as blocked, sum(case when t.status = 'in_progress' then 1 else 0 end) as in_prog, sum(case when coalesce(t.carried_count, 0) > 0 then 1 else 0 end) as carried from weeks w left join tasks t on t.week_id = w.id where w.employee_id = ? and w.week_start in (${a}) group by w.week_start`,\n args: [e, ...t],\n });\n for (const i of r.rows) {\n const n = String(i.week_start);\n s[n] = {\n weekStart: n,\n total: Number(i.total) || 0,\n done: Number(i.done) || 0,\n blocked: Number(i.blocked) || 0,\n inProgress: Number(i.in_prog) || 0,\n carried: Number(i.carried) || 0,\n };\n }\n return s;\n}\nasync function $(e) {\n const t = {},\n s = await k.execute({\n sql:\n `select w.week_start as week_start, sum(x.dur_ms) as ms from ( select t.week_id as week_id, l.status as status, (julianday(coalesce( lead(l.entered_at) over (partition by l.task_id order by l.entered_at, l.id), datetime('now') )) - julianday(l.entered_at)) * 86400000 as dur_ms from task_status_log l join tasks t on t.id = l.task_id join weeks wk on wk.id = t.week_id where wk.employee_id = ? ) x join weeks w on w.id = x.week_id where x.status = 'in_progress' group by w.week_start`,\n args: [e],\n });\n for (const a of s.rows) {\n const r = Number(a.ms);\n t[String(a.week_start)] = isFinite(r) && r > 0 ? r : 0;\n }\n return t;\n}\nasync function j(e, t = 52) {\n const s = await k.execute({\n sql:\n `select w.week_start as week_start, w.summary_done as summary_done, w.summary_blockers as summary_blockers, w.submitted_at as submitted_at, count(t.id) as total, sum(case when t.status = 'done' then 1 else 0 end) as done, sum(case when t.status = 'blocked' then 1 else 0 end) as blocked, sum(case when t.status = 'in_progress' then 1 else 0 end) as in_prog, sum(case when coalesce(t.carried_count, 0) > 0 then 1 else 0 end) as carried from weeks w left join tasks t on t.week_id = w.id where w.employee_id = ? group by w.id order by w.week_start desc limit ?`,\n args: [e, t],\n }),\n a = await $(e);\n return s.rows.map((r) => {\n const i = String(r.week_start);\n return {\n weekStart: i,\n total: Number(r.total) || 0,\n done: Number(r.done) || 0,\n blocked: Number(r.blocked) || 0,\n inProgress: Number(r.in_prog) || 0,\n carried: Number(r.carried) || 0,\n summaryDone: r.summary_done ?? null,\n summaryBlockers: r.summary_blockers ?? null,\n submittedAt: r.submitted_at ?? null,\n ms: a[i] ?? 0,\n };\n });\n}\nfunction u(e) {\n if (!isFinite(e) || e <= 0) return \"—\";\n const t = Math.floor(e / 6e4);\n if (t < 1) return \"< 1 мин\";\n const s = Math.floor(t / 1440), a = Math.floor(t % 1440 / 60), r = t % 60;\n return s > 0\n ? a > 0 ? `${s} дн. ${a} ч` : `${s} дн.`\n : a > 0\n ? r > 0 ? `${a} ч ${r} мин` : `${a} ч`\n : `${r} мин`;\n}\nfunction p(e) {\n return `${e.slice(8, 10)}.${e.slice(5, 7)}`;\n}\nfunction w(e, t) {\n const s = t ? Math.round(e / t * 100) : 0;\n return `

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

`;\n}\nfunction m(e) {\n return e.total ? Math.round(e.done / e.total * 100) : 0;\n}\nfunction v(e, t, s, a) {\n if (t == null) return \"\";\n const r = e - t;\n if (r === 0) {\n return '

как на прошлой неделе

';\n }\n const i = a ? r > 0 : r < 0, n = r > 0 ? \"+\" : \"−\";\n return `

${n}${Math.abs(r)}${s} к прошлой неделе

`;\n}\nfunction o(e, t, s = \"\", a = \"\") {\n return `

${e}

${t}

${s}

`;\n}\nfunction S(e) {\n const t = e.current,\n s = e.previous,\n a = m(t),\n r = s ? m(s) : null,\n i = [\n o(\n `${t.done}/${t.total}`,\n \"Задач сделано\",\n v(t.done, s ? s.done : null, \"\", !0),\n ),\n o(\n `${a}%`,\n \"Выполнение недели\",\n v(a, r, \" п.п.\", !0),\n a >= 70 ? \"ok\" : \"\",\n ),\n o(`${t.inProgress}`, \"Сейчас в работе\"),\n o(\n `${t.blocked}`,\n \"Блокеры\",\n v(t.blocked, s ? s.blocked : null, \"\", !1),\n t.blocked ? \"bad\" : \"\",\n ),\n o(u(e.currentMs), \"Времени в работе\"),\n t.carried\n ? o(\n `${t.carried}`,\n \"Перенесено с прошлых недель\",\n \"\",\n t.carried >= 3 ? \"bad\" : \"\",\n )\n : \"\",\n ].join(\"\"),\n n = e.trend.map((l) => {\n const c = m(l), b = Math.max(c, l.total ? 4 : 0);\n return `

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

${\n d(p(l.weekStart))\n }

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

${\n e.isCurrentWeek ? \"Моя неделя\" : \"Итоги этой недели\"\n }

${i}

${\n s\n ? `

Прошлая неделя: ${s.done}/${s.total} задач (${r}%), времени в работе ${\n u(e.previousMs ?? 0)\n }.

`\n : '

Данных за прошлую неделю нет — сравнивать пока не с чем.

'\n }

Последние недели

${n}

`;\n}\nfunction R(e) {\n const t = e.weeks.reduce(\n (n, l) => (n.total += l.total, n.done += l.done, n.ms += l.ms, n),\n { total: 0, done: 0, ms: 0 },\n ),\n s = t.total ? Math.round(t.done / t.total * 100) : 0,\n a = e.weeks.filter((n) => n.submittedAt).length,\n r = e.weeks.map((n) => {\n const l = m(n),\n c = n.weekStart === e.currentWeekStart,\n b = !!(n.summaryDone?.trim() || n.summaryBlockers?.trim());\n return `

${\n d(h(n.weekStart))\n }

${\n c ? 'текущая' : \"\"\n } ${\n w(n.done, n.total)\n }

${n.done}/${n.total} задач · ${l}%

${\n u(n.ms)\n } ${\n n.blocked\n ? `${n.blocked}`\n : '—'\n } ${\n n.carried\n ? `↻ ${n.carried}`\n : '—'\n } ${\n b\n ? `

Итоги недели

Сделано: ${\n d(n.summaryDone) || \"—\"\n }

Не сделано: ${\n d(n.summaryBlockers) || \"—\"\n }

`\n : 'итоги не заполнены'\n } `;\n }).join(\"\"),\n i =\n `

Мои недели

История по неделям: сколько было задач, сколько закрыто и что вы писали в итогах

${\n e.tabsHtml ?? \"\"\n }

${e.weeks.length}

Недель в истории

${t.done}/${t.total}

Задач закрыто за всё время

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

Среднее выполнение

${\n u(t.ms)\n }

Суммарно в работе

${a}/${e.weeks.length}

Недель с итогами

По неделям

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

Пока нет ни одной недели

'\n : `

${r}

Неделя	Прогресс	В работе	Блокеры	Переносы	Итоги

`\n }

`;\n return g({\n title: \"Мои недели\",\n bodyHtml: i,\n nav: { employeeName: e.employee.name },\n });\n}\nexport {\n $ as getInProgressMsByWeek,\n j as listMyWeeks,\n P as getMyWeeklyStats,\n R as myWeeksPage,\n S as mySummaryBlock,\n};","deleted",false,"label",[14],"5790c4c4-151f-4420-8cd3-d7d25d34b391",["D",1788532613285],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","f61cb239-8da1-4128-9a0b-7fd7bff5996d","pinnedFileId","01a06cd9-e0f4-745d-b9ff-cd434c777e85","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a01a4b-4067-766f-8505-64b03c2d1385","tursoName","5790c4c4151f44208cd3d7d25d34b391","tursoHostname","5790c4c4151f44208cd3d7d25d34b391-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789486866837],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_110":106},"org",{"_9":10,"_103":104,"_105":106,"_55":56,"_107":108,"_109":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":93,"_94":95,"_96":50,"_97":98,"_99":100,"_101":12,"_102":10},"isOwned",31,"main","projectId","forkedBranchId","09937878-fcd4-436d-8a10-a37b31f009c1","forkedBranchVersion",44,"forkedProjectPrivacy","forkedProjectId","699d8c1c-1bf7-4c2e-b21c-0dfd048b1eab","forkedProjectOrgId","01a0144b-5ab3-75ed-8bcf-2932d806687d","projectName","userHandle","displayName","Яна Глебова","avatar","https://lh3.googleusercontent.com/a/ACg8ocJSREj-E3LuuF17WqPNBBCoMhHEi5R71rAtzPevRqPPJBjUhwXl=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_144":145,"_146":147,"_148":149,"_150":42,"_151":42,"_152":42,"_153":32,"_154":-5,"_155":-7,"_156":-7,"_157":63,"_158":42,"_159":42,"_160":-5,"_161":42,"_162":42,"_163":42,"_164":-5},"ENV",{"_115":116,"_117":118,"_119":90,"_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"]