[{"_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","absences.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/absences.ts","extension","id","74c8d5cc-8c07-41bc-9386-57cc8ba1598d","fileId","10523d54-b009-11f1-8dc6-1607ee4eb77e","parentId","branchId","c052e08c-bc3b-4791-a404-c6c3b60839df","branchVersion",26,"latest",true,"createdAt",["D",1789481566489],"version",5,"fileType","script","content","import { sqlite as g } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { esc as c, layout as O } from \"./views.ts\";\nconst w = [\"vacation\", \"sick\", \"dayoff\", \"trip\"],\n b = {\n vacation: \"Отпуск\",\n sick: \"Больничный\",\n dayoff: \"Отгул\",\n trip: \"Командировка\",\n },\n u = {\n vacation: { fill: \"#5a5bd8\", ink: \"#4749c4\", soft: \"#eeeefc\" },\n sick: { fill: \"#cf3538\", ink: \"#b52c2f\", soft: \"#fdecec\" },\n dayoff: { fill: \"#b4720a\", ink: \"#946009\", soft: \"#fdf3e2\" },\n trip: { fill: \"#14915b\", ink: \"#11794c\", soft: \"#e6f6ee\" },\n },\n G = new Set([\"trip\"]);\nlet N = !1;\nasync function h() {\n N ||\n (await g.execute(\n `create table if not exists absences ( id integer primary key autoincrement, employee_id integer not null references employees(id), kind text not null default 'vacation', start_date text not null, end_date text not null, note text, created_by text not null default 'employee', created_at text not null default (datetime('now')) )`,\n ),\n N = !0);\n}\nasync function H(e) {\n await h();\n const s = e.startDate <= e.endDate ? e.startDate : e.endDate,\n a = e.startDate <= e.endDate ? e.endDate : e.startDate,\n t = await g.execute({\n sql:\n `insert into absences (employee_id, kind, start_date, end_date, note, created_by) values (?, ?, ?, ?, ?, ?)`,\n args: [e.employeeId, e.kind, s, a, e.note ?? null, e.createdBy],\n });\n return Number(t.lastInsertRowid);\n}\nasync function Y(e) {\n return await h(),\n (await g.execute({ sql: \"select * from absences where id = ?\", args: [e] }))\n .rows[0] ?? null;\n}\nasync function F(e) {\n await h(),\n await g.execute({ sql: \"delete from absences where id = ?\", args: [e] });\n}\nasync function J(e, s) {\n return await h(),\n (await g.execute({\n sql:\n `select a.*, e.name as employee_name from absences a left join employees e on e.id = a.employee_id where a.start_date <= ? and a.end_date >= ? order by a.start_date, a.id`,\n args: [s, e],\n })).rows;\n}\nasync function Q(e, s) {\n return await h(),\n (await g.execute({\n sql:\n `select * from absences where employee_id = ? and end_date >= ? order by start_date, id`,\n args: [e, s],\n })).rows;\n}\nasync function V(e) {\n await h();\n const s = {},\n a = await g.execute({\n sql:\n \"select * from absences where start_date <= ? and end_date >= ? order by id\",\n args: [e, e],\n });\n for (const t of a.rows) s[Number(t.employee_id)] = t;\n return s;\n}\nfunction v(e) {\n return e < 10 ? `0${e}` : String(e);\n}\nfunction S(e) {\n const [s, a] = e.split(\"-\"),\n t = Number(s),\n o = Number(a),\n l = new Date(Date.UTC(t, o, 0)).getUTCDate(),\n i = [];\n for (let r = 1; r <= l; r++) {\n const d = `${s}-${v(o)}-${v(r)}`,\n n = new Date(`${d}T00:00:00Z`).getUTCDay();\n i.push({ date: d, day: r, weekend: n === 0 || n === 6, dow: n });\n }\n return {\n year: t,\n mon: o,\n days: i,\n first: `${s}-${v(o)}-01`,\n last: `${s}-${v(o)}-${v(l)}`,\n };\n}\nfunction $(e, s) {\n const [a, t] = e.split(\"-\");\n let o = Number(a), l = Number(t) + s;\n for (; l > 12;) l -= 12, o++;\n for (; l < 1;) l += 12, o--;\n return `${o}-${v(l)}`;\n}\nconst z = [\n \"Январь\",\n \"Февраль\",\n \"Март\",\n \"Апрель\",\n \"Май\",\n \"Июнь\",\n \"Июль\",\n \"Август\",\n \"Сентябрь\",\n \"Октябрь\",\n \"Ноябрь\",\n \"Декабрь\",\n];\nfunction _(e) {\n const [s, a] = e.split(\"-\");\n return `${z[Number(a) - 1] ?? a} ${s}`;\n}\nfunction j(e) {\n return e.slice(0, 7);\n}\nfunction T(e) {\n const s = Date.parse(`${e.start_date}T00:00:00Z`),\n a = Date.parse(`${e.end_date}T00:00:00Z`);\n return isNaN(s) || isNaN(a) ? 0 : Math.round((a - s) / 864e5) + 1;\n}\nfunction f(e) {\n return `${e.slice(8, 10)}.${e.slice(5, 7)}`;\n}\nfunction k(e, s) {\n const a = new Date(`${e}T00:00:00Z`);\n return a.setUTCDate(a.getUTCDate() + s), a.toISOString().slice(0, 10);\n}\nfunction W(e) {\n return (e ?? \"\").split(\" \")[0] || \"—\";\n}\nconst I = [\"пн\", \"вт\", \"ср\", \"чт\", \"пт\", \"сб\", \"вс\"];\nfunction A(e) {\n return (e + 6) % 7;\n}\nfunction C() {\n return w.map((e) =>\n ` ${b[e]}`\n ).join(\"\");\n}\nfunction q(e) {\n const s = u[e] ?? u.vacation;\n return `${\n c(b[e] ?? e)\n }`;\n}\nfunction X(e) {\n const a = [{\n label: \"На этой неделе\",\n from: e.weekStart,\n to: k(e.weekStart, 6),\n }, {\n label: \"На следующей неделе\",\n from: k(e.weekStart, 7),\n to: k(e.weekStart, 13),\n }].map((t) => {\n const o = e.absences.filter((i) =>\n i.start_date <= t.to && i.end_date >= t.from\n ).sort((i, r) => i.start_date.localeCompare(r.start_date));\n if (o.length === 0) return null;\n const l = o.map((i) => {\n const r = u[i.kind] ?? u.vacation,\n d = i.start_date <= e.today && i.end_date >= e.today,\n n = i.start_date > t.from ? i.start_date : t.from,\n m = i.end_date < t.to ? i.end_date : t.to,\n y = n === m ? f(n) : `${f(n)} – ${f(m)}`,\n p = n === t.from && m === t.to ? \" · всю неделю\" : \"\";\n return `

${\n c(i.employee_name) || \"—\"\n } ${\n c(b[i.kind] ?? i.kind)\n } ${y}${p} ${\n d ? 'сейчас' : \"\"\n }

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

${t.label}

${l}

`;\n }).filter(Boolean);\n return a.length === 0\n ? \"\"\n : `

Кто не работает

Календарь отсутствий

${\n a.join(\"\")\n }

`;\n}\nfunction B(e) {\n const s = S(e.month), a = {};\n for (const r of e.absences) {\n for (const d of s.days) {\n d.date >= r.start_date && d.date <= r.end_date &&\n (a[d.date] ?? (a[d.date] = [])).push(r);\n }\n }\n const t = I.map((r, d) =>\n `

= 5 ? \"var(--bad)\" : \"var(--muted)\"\n }\">${r}

`\n ).join(\"\"),\n o = A(s.days[0].dow),\n l = Array.from({ length: o }, () => \"

\").join(\"\"),\n i = s.days.map((r) => {\n const d = a[r.date] ?? [],\n n = r.date === e.today,\n m = d.slice(0, 3).map((p) => {\n const x = u[p.kind] ?? u.vacation;\n return `

${\n c(W(p.employee_name))\n }

`;\n }).join(\"\"),\n y = d.length > 3\n ? `

ещё ${\n d.length - 3\n }

`\n : \"\";\n return `

${r.day}

${m}${y}

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

${t}${l}${i}

`;\n}\nfunction ee(e) {\n const s = $(e.month, -1),\n a = $(e.month, 1),\n t = e.absences.length === 0\n ? '

В этом месяце отсутствий нет

'\n : `

${\n e.absences.map((n) =>\n ` `\n ).join(\"\")\n }

Сотрудник	Вид	Даты	Дней	Комментарий
${\n c(n.employee_name) \|\| \"—\"\n }	${q(n.kind)}	${\n f(n.start_date)\n } – ${f(n.end_date)}	${\n T(n)\n }	${\n c(n.note) \|\| \"—\"\n }

`,\n o = e.employees.map((n) => ``)\n .join(\"\"),\n l = w.map((n) => ``).join(\"\"),\n i = e.absences.filter((n) =>\n n.start_date <= e.today && n.end_date >= e.today\n ),\n r = i.length === 0\n ? 'Сегодня все на месте'\n : i.map((n) =>\n `${c(n.employee_name)} — ${\n (b[n.kind] ?? n.kind).toLowerCase()\n } до ${f(n.end_date)}`\n ).join(\" · \"),\n d =\n `

Отпуска и отсутствия

Кто когда не работает — по всей команде

${\n c(_(e.month))\n }

← →

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

Сотрудников пока нет

'\n : B({ absences: e.absences, month: e.month, today: e.today })\n }

${C()}

${r}

Отсутствия за ${\n c(_(e.month).toLowerCase())\n }

${t}

Добавить отсутствие

`;\n return O({\n title: \"Отпуска\",\n bodyHtml: d,\n nav: { isManager: !0, activePath: \"/absences\" },\n });\n}\nfunction E(e, s, a) {\n const t = S(e),\n o = I.map((d, n) =>\n `

= 5 ? \"var(--bad)\" : \"var(--muted)\"\n }\">${d}

`\n ).join(\"\"),\n l = A(t.days[0].dow),\n i = Array.from({ length: l }, () => \"

\").join(\"\"),\n r = t.days.map((d, n) => {\n const m = s[d.date],\n y = d.date === a,\n p = A(d.dow),\n x = p > 0 && n > 0 && s[t.days[n - 1].date] === m,\n D = p < 6 && n < t.days.length - 1 && s[t.days[n + 1].date] === m;\n if (!m) {\n return `

${d.day}

`;\n }\n const R = u[m] ?? u.vacation,\n L = `${x ? \"0\" : \"8px\"} ${D ? \"0\" : \"8px\"} ${D ? \"0\" : \"8px\"} ${\n x ? \"0\" : \"8px\"\n }`;\n return `

${d.day}

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

${\n c(_(e))\n }

${o}${i}${r}

`;\n}\nfunction M(e) {\n const s = {};\n for (const i of e.absences) {\n let r = i.start_date;\n for (let d = 0; d < 400 && r <= i.end_date; d++) {\n s[r] = i.kind;\n const n = new Date(`${r}T00:00:00Z`);\n n.setUTCDate(n.getUTCDate() + 1), r = n.toISOString().slice(0, 10);\n }\n }\n const a = j(e.today);\n let t = $(a, 2);\n for (const i of e.absences) {\n const r = j(i.end_date);\n r > t && (t = r);\n }\n const o = [];\n let l = a;\n for (; l <= t && o.length < 6;) o.push(l), l = $(l, 1);\n return `

${\n o.map((i) => E(i, s, e.today)).join(\"\")\n }

${C()}

`;\n}\nfunction te(e) {\n const s = w.map((t) => ``).join(\"\"),\n a = e.absences.length === 0\n ? '

Ничего не запланировано

'\n : `

${\n e.absences.map((t) => {\n const o = t.start_date <= e.today && t.end_date >= e.today;\n return ` `;\n }).join(\"\")\n }

Вид	Даты	Дней	Комментарий
${q(t.kind)}${\n o ? ' идёт сейчас' : \"\"\n }	${f(t.start_date)} – ${\n f(t.end_date)\n }	${\n T(t)\n }	${\n c(t.note) \|\| \"—\"\n }

`;\n return `

Отпуска и отсутствия

видно руководителю в общем календаре

${\n M({ absences: e.absences, today: e.today })\n }

${a}

`;\n}\nexport {\n $ as shiftMonth,\n _ as monthLabel,\n b as KIND_LABELS,\n ee as absencesPage,\n F as deleteAbsence,\n G as WORKING_KINDS,\n H as createAbsence,\n h as ensureAbsences,\n J as listAbsencesInRange,\n j as monthOf,\n M as myAbsenceCalendar,\n Q as listMyAbsences,\n S as monthInfo,\n T as absenceLength,\n te as myAbsencesBlock,\n V as getAbsentToday,\n w as ABSENCE_KINDS,\n X as absenceSummaryBlock,\n Y as getAbsence,\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"]