[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_224":225,"_226":227},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_170":-5,"_20":171,"_22":172,"_173":174,"_175":176,"_26":177,"_24":178,"_179":-5,"_180":-5,"_181":55,"_182":183,"_184":46,"_185":-5,"_186":-5,"_187":188},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","asnfq50","name","mawazin","branchName","main","version","path","frontend","project",{"_34":112,"_13":14,"_47":113,"_114":-5,"_115":55,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":71,"_125":46,"_126":-5,"_127":-5,"_128":61,"_129":130,"_131":132,"_133":134,"_135":136,"_137":-5,"_138":139,"_140":139,"_141":142,"_143":142,"_144":142,"_145":139,"_146":139,"_147":148,"_149":150,"_151":152,"_153":55},"tree",[64,65,66,67,68],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":63},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","db93d54a-de2b-4602-91f9-d7a4b91a969f","Board.tsx","fileId","c429bc3e-a8b2-11f1-8263-1607ee4eb77e","parentId","8e9836ce-f383-4066-b4af-666b6341cba4","branchId","18e26ae8-2946-4bab-a3ee-f24a717f8d24","branchVersion",20,"latest",true,"createdAt",["D",1788609208117],9,"fileType","script","content","/** @jsxImportSource https://esm.sh/hono@4.5.6/jsx */\nimport {\n type Commitment,\n daysLeft,\n PEOPLE,\n type PersonId,\n type Severity,\n severity,\n sorted,\n} from \"../db.ts\";\n\n/* هوية موازين الشرق — مستخرجة من الموقع الحيّ، لا مقترحة */\nconst C = {\n ground: \"#F2F0EA\",\n surface: \"#FBFAF7\",\n sunk: \"#EAE7DD\",\n ink: \"#26231F\",\n ink2: \"#6A6357\",\n ink3: \"#8F887A\",\n rule: \"#D6D1C4\",\n ruleSoft: \"#E3DFD4\",\n olive: \"#5E6845\",\n oliveDeep: \"#48512F\",\n oliveTint: \"#DCE3CB\",\n alarm: \"#8C4A2F\",\n alarmTint: \"#F0E2DA\",\n alarmRule: \"#D9BFB0\",\n};\n\nconst SEV_STYLE: Record = {\n \"منتهٍ\": { bg: C.alarm, fg: \"#FBFAF7\", bd: C.alarm },\n \"عاجل\": { bg: C.alarmTint, fg: C.alarm, bd: C.alarmRule },\n \"ناقص تاريخ\": { bg: C.sunk, fg: C.ink2, bd: C.rule },\n \"قادم\": { bg: C.oliveTint, fg: C.oliveDeep, bd: \"transparent\" },\n \"مستقر\": { bg: \"transparent\", fg: C.ink3, bd: C.ruleSoft },\n};\n\nfunction arabicDate(iso: string) {\n const [y, m, d] = iso.split(\"-\");\n const months = [\n \"يناير\", \"فبراير\", \"مارس\", \"أبريل\", \"مايو\", \"يونيو\",\n \"يوليو\", \"أغسطس\", \"سبتمبر\", \"أكتوبر\", \"نوفمبر\", \"ديسمبر\",\n ];\n return `${Number(d)} ${months[Number(m) - 1]} ${y}`;\n}\n\n/** جمع التمييز العربي: ٣–١٠ «أيام»، وما فوقها «يوماً». */\nfunction days(n: number): string {\n if (n === 1) return \"يوم واحد\";\n if (n === 2) return \"يومان\";\n if (n <= 10) return `${n} أيام`;\n return `${n} يوماً`;\n}\n\nfunction countdown(c: Commitment): string {\n if (!c.due_date) return \"—\";\n const n = daysLeft(c.due_date);\n if (n === 0) return \"اليوم\";\n if (n === 1) return \"غداً\";\n if (n === 2) return \"بعد يومين\";\n if (n > 0) return `بعد ${days(n)}`;\n return `متأخر ${days(Math.abs(n))}`;\n}\n\nfunction Tally({ items }: { items: Commitment[] }) {\n const order: Severity[] = [\"منتهٍ\", \"عاجل\", \"ناقص تاريخ\", \"قادم\", \"مستقر\"];\n const counts = order.map((s) => ({ s, n: items.filter((i) => severity(i) === s).length }));\n return (\n

\n {counts.map(({ s, n }) => {\n const st = SEV_STYLE[s];\n return (\n \n \n {n}\n

{s}

\n );\n })}\n \n );\n}\n\nfunction Row({ c }: { c: Commitment }) {\n const sev = severity(c);\n const st = SEV_STYLE[sev];\n const urgent = sev === \"منتهٍ\" || sev === \"عاجل\";\n return (\n \n

\n \n {sev}\n \n {c.kind}\n {c.ref && (\n {c.ref}\n )}\n · {PEOPLE[c.owner_id].name}\n

\n\n

\n {c.title}\n

\n\n {c.missing && (\n

\n ينقص: {c.missing}\n

\n )}\n {c.note && (\n

{c.note}

\n )}\n {c.source && (\n \n {c.source}\n

\n )}\n\n

\n \n \n \n احفظ التاريخ\n \n \n {c.done ? \"أعِدْه\" : \"أُنجِز\"}\n \n \n حوّلها لـ{PEOPLE[c.owner_id === \"abdullah\" ? \"shehab\" : \"abdullah\"].name}\n \n \n \n\n

\n \n {countdown(c)}\n

\n {c.due_date ? arabicDate(c.due_date) : \"بلا تاريخ\"}\n

\n {c.recurrence &&

{c.recurrence}

}\n \n \n );\n}\n\nexport function Board(\n { items, who, saved }: { items: Commitment[]; who: PersonId; saved?: boolean },\n) {\n const open = items.filter((i) => !i.done);\n const mine = sorted(open.filter((i) => i.owner_id === who));\n const theirs = sorted(open.filter((i) => i.owner_id !== who));\n const other: PersonId = who === \"abdullah\" ? \"shehab\" : \"abdullah\";\n const done = items.filter((i) => i.done);\n const today = new Date().toISOString().slice(0, 10);\n\n return (\n \n \n \n \n \n الالتزامات — موازين الشرق\n \n \n \n \n \n \n

\n \n موازين الشرق · {PEOPLE[who].name} — {PEOPLE[who].role}\n

\n الالتزامات والمواعيد\n

\n ما عليك أنت أولاً، مرتّباً بالإلحاح لا بالتاريخ.\n البنود بلا تاريخ ليست خطأً — إنها قائمة ما ينقص جلبه.\n

\n \n اليوم {today} · عليك {mine.length} · عند {PEOPLE[other].name} {theirs.length}\n \n \n\n {saved && (\n \n حُفِظ.\n \n )}\n\n \n\n

\n {mine.length === 0\n ? (\n

\n ما عليك شيء اليوم.\n

\n )\n : mine.map((c) => )}\n

\n\n {theirs.length > 0 && (\n

\n \n عند {PEOPLE[other].name} ({theirs.length}) — للاطّلاع\n \n

\n {theirs.map((c) => )}\n

\n )}\n\n {done.length > 0 && (\n

\n منجَز ({done.length})\n

\n {done.map((c) => )}\n

\n )}\n\n \n البذرة مستخرَجة من مستندات الشركة — راجِع «المصدر» تحت كل بند\n view source\n \n \n \n \n );\n}\n","deleted",false,"label",[19,36],"96ce0ae4-adef-454f-8186-40285905c5db",3,["D",1788562117380],0,"directory",[19],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":105,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":106,"_18":107},{"_34":98,"_13":99,"_37":100,"_39":-5,"_41":42,"_43":74,"_45":46,"_47":101,"_17":61,"_50":24,"_52":102,"_54":55,"_56":-5,"_77":103,"_18":104},{"_34":89,"_13":90,"_37":91,"_39":-5,"_41":42,"_43":92,"_45":46,"_47":93,"_17":94,"_50":51,"_52":95,"_54":55,"_56":-5,"_77":96,"_18":97},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":85,"_50":51,"_52":86,"_54":55,"_56":-5,"_77":87,"_18":88},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":78,"_18":79},"94fb2d77-ba10-4ac4-b323-0e0cc7af3ce3","index.tsx","d7e46dbe-a8b2-11f1-b82c-1607ee4eb77e",11,["D",1788609136142],1,"http","/** @jsxImportSource https://esm.sh/hono@4.5.6/jsx */\nimport { Hono } from \"https://esm.sh/hono@4.5.6\";\nimport { getCookie, setCookie } from \"https://esm.sh/hono@4.5.6/cookie\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { list, PEOPLE, type PersonId, setDate, setDone, setOwner } from \"./db.ts\";\nimport { Board } from \"./frontend/Board.tsx\";\n\nconst app = new Hono();\nconst COOKIE = \"mw\";\n\n/** يطابق المفتاح المعطى بمفاتيح الأشخاص، ويعيد صاحبه. */\nfunction identify(given: string | undefined): PersonId | null {\n if (!given) return null;\n for (const id of Object.keys(PEOPLE) as PersonId[]) {\n const key = Deno.env.get(PEOPLE[id].envKey);\n if (key && given === key) return id;\n }\n return null;\n}\n\napp.use(\"*\", async (c, next) => {\n if (c.req.path === \"/source\") return next();\n\n const given = c.req.query(\"k\") ?? getCookie(c, COOKIE);\n const who = identify(given);\n\n if (!who) {\n return c.html(\n `\n \n مغلق\n \n

هذه الصفحة تحتاج مفتاح دخول.

`,\n 401,\n );\n }\n\n if (c.req.query(\"k\")) {\n setCookie(c, COOKIE, given!, {\n path: \"/\",\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 60 * 60 * 24 * 365,\n });\n }\n c.set(\"who\", who);\n return next();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/\", async (c) => {\n const who = c.get(\"who\") as PersonId;\n const items = await list(who);\n const page = ;\n return c.html(\"\" + (await Promise.resolve(page.toString())));\n});\n\napp.post(\"/save\", async (c) => {\n const who = c.get(\"who\") as PersonId;\n const body = await c.req.parseBody();\n const id = Number(body.id);\n if (!Number.isFinite(id)) return c.redirect(\"/\");\n\n // لا يعدّل أحد بنداً لا يراه.\n const items = await list(who);\n const cur = items.find((i) => i.id === id);\n if (!cur) return c.redirect(\"/\");\n\n if (body.action === \"toggle\") {\n await setDone(id, !cur.done);\n } else if (body.action === \"handoff\") {\n await setOwner(id, cur.owner_id === \"abdullah\" ? \"shehab\" : \"abdullah\");\n } else {\n const raw = String(body.due_date ?? \"\").trim();\n const due = /^\\d{4}-\\d{2}-\\d{2}$/.test(raw) ? raw : null;\n // إدخال التاريخ يُغلق سبب النقص، فيُمحى وصف النقص معه.\n await setDate(id, due, due ? null : \"التاريخ ما زال مجهولاً\");\n }\n return c.redirect(\"/?saved=1\");\n});\n\napp.get(\"/api/commitments\", async (c) => c.json(await list(c.get(\"who\") as PersonId)));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[70],"7f386310-9497-4cea-89a0-5c8c0ea26b4e","db.ts","a4259110-a8b2-11f1-a947-1607ee4eb77e",10,["D",1788609106426],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const TABLE = \"commitments_v2\";\n\nexport type Kind = \"ترخيص\" | \"ضريبة\" | \"عقد\" | \"مالي\" | \"قانوني\" | \"تقني\";\n\n/** المستخدمان. المفتاح لكل واحد في متغيّر بيئة مستقل. */\nexport type PersonId = \"abdullah\" | \"shehab\";\n\nexport const PEOPLE: Record = {\n abdullah: { name: \"عبدالله\", role: \"المدير العام\", envKey: \"KEY_ABDULLAH\" },\n shehab: { name: \"شهاب\", role: \"المدير المالي\", envKey: \"KEY_SHEHAB\" },\n};\n\n/**\n * نطاق البند. «الشركة» يراه الاثنان.\n * «شخصي» و«تقني» لعبدالله وحده — شهاب لا يراهما إطلاقاً.\n */\nexport type Scope = \"company\" | \"personal\" | \"tech\";\n\nexport function visibleScopes(who: PersonId): Scope[] {\n return who === \"abdullah\" ? [\"company\", \"personal\", \"tech\"] : [\"company\"];\n}\n\nexport interface Commitment {\n id: number;\n title: string;\n kind: Kind;\n ref: string | null;\n /** ISO YYYY-MM-DD, or null when the date is not known yet. */\n due_date: string | null;\n /** ما الذي ينقص لمعرفة التاريخ — يظهر في قائمة «ناقص تاريخ». */\n missing: string | null;\n recurrence: string | null;\n /** نصّ حرّ قديم — يبقى للعرض، والملكية الحقيقية في owner_id. */\n owner: string | null;\n owner_id: PersonId;\n scope: Scope;\n note: string | null;\n source: string | null;\n done: number;\n updated_at: string;\n}\n\nexport async function init() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n kind TEXT NOT NULL,\n ref TEXT,\n due_date TEXT,\n missing TEXT,\n recurrence TEXT,\n owner TEXT,\n note TEXT,\n source TEXT,\n done INTEGER NOT NULL DEFAULT 0,\n updated_at TEXT NOT NULL\n )`);\n\n // ترحيل: أعمدة الملكية والنطاق أُضيفت بعد أول إصدار.\n const { rows } = await sqlite.execute(`PRAGMA table_info(${TABLE})`);\n const cols = new Set(rows.map((r) => String((r as Record).name)));\n\n if (!cols.has(\"owner_id\")) {\n await sqlite.execute(`ALTER TABLE ${TABLE} ADD COLUMN owner_id TEXT`);\n // البذرة الأولى كتبت المالك نصّاً؛ نشتقّ منه المعرّف مرّة واحدة.\n await sqlite.execute(\n `UPDATE ${TABLE} SET owner_id =\n CASE WHEN owner = 'المحاسب' THEN 'shehab' ELSE 'abdullah' END\n WHERE owner_id IS NULL`,\n );\n }\n if (!cols.has(\"scope\")) {\n await sqlite.execute(`ALTER TABLE ${TABLE} ADD COLUMN scope TEXT`);\n await sqlite.execute(`UPDATE ${TABLE} SET scope = 'company' WHERE scope IS NULL`);\n }\n}\n\nexport async function setOwner(id: number, owner_id: PersonId) {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET owner_id = ?, owner = ?, updated_at = ? WHERE id = ?`,\n args: [owner_id, PEOPLE[owner_id].name, new Date().toISOString(), id],\n });\n}\n\n/**\n * البذرة الأولى — كل بند هنا مستخرَج من مستندات الشركة أو من فحص حيّ،\n * والمصدر مكتوب في العمود `source` حتى يُراجَع.\n */\nconst SEED: Omit[] = [\n {\n title: \"دومين mawazin-alsharq.com\",\n kind: \"تقني\",\n ref: \"GoDaddy\",\n due_date: \"2026-09-14\",\n missing: null,\n recurrence: \"سنوي\",\n owner: \"عبدالله\",\n note: \"عليه الموقع والبريد معاً. انتهاؤه يقطع بريد الشركة الذي تُرسل به عروض الأسعار.\",\n source: \"فحص هندسي · 2026-09-04\",\n },\n {\n title: \"عضوية الهيئة السعودية للمقاولين\",\n kind: \"ترخيص\",\n ref: \"171917193\",\n due_date: \"2026-04-21\",\n missing: null,\n recurrence: \"سنوي\",\n owner: \"المحاسب\",\n note: \"منتهية. شرط شكلي لدخول المنافسات — بدونها يُرفض العرض مهما كان سعره.\",\n source: \"نموذج المحتوى الموحّد · status: expired\",\n },\n {\n title: \"شهادة تصنيف مقدّمي خدمات المدن\",\n kind: \"ترخيص\",\n ref: \"2024004096\",\n due_date: \"2026-04-22\",\n missing: null,\n recurrence: \"سنتان\",\n owner: \"المحاسب\",\n note: \"منتهية. الدرجة الثانية · BBB- · 81.35 · التشييد والبناء + التشغيل والصيانة. صادرة من وزارة البلديات والإسكان.\",\n source: \"نموذج المحتوى الموحّد · status: expired\",\n },\n {\n title: \"الإقرار الربعي لضريبة القيمة المضافة\",\n kind: \"ضريبة\",\n ref: \"314237625200003\",\n due_date: null,\n missing: \"تاريخ الإقرار القادم — الدورة ربع سنوية والنفاذ من 2025-11-02\",\n recurrence: \"ربعي\",\n owner: \"المحاسب\",\n note: \"التسجيل ساري. الإقرار الربعي له موعد ثابت وغرامة تأخير نظامية.\",\n source: \"شهادة التسجيل الضريبي\",\n },\n {\n title: \"السجل التجاري — الرقم الوطني الموحّد\",\n kind: \"ترخيص\",\n ref: \"7021325860\",\n due_date: null,\n missing: \"تاريخ انتهاء السجل — المعروف فقط تاريخ الإصدار 2021-01-27\",\n recurrence: \"سنوي\",\n owner: \"المحاسب\",\n note: \"شركة موازين الشرق العقارية — شركة شخص واحد.\",\n source: \"نموذج المحتوى الموحّد\",\n },\n {\n title: \"شهادة الزكاة\",\n kind: \"ضريبة\",\n ref: null,\n due_date: null,\n missing: \"هل توجد شهادة سارية؟ وتاريخ الإقرار الزكوي القادم؟\",\n recurrence: \"سنوي\",\n owner: \"المحاسب\",\n note: \"تُطلب في المنافسات مع السجل وخطاب الآيبان.\",\n source: \"لم يُرصد لها ملف — سؤال مفتوح\",\n },\n {\n title: \"منافسة الصيانة والتشغيل\",\n kind: \"عقد\",\n ref: \"كرّاسة شروط + 12 ملحقاً\",\n due_date: null,\n missing: \"موعد إغلاق تقديم العروض\",\n recurrence: \"مرة واحدة\",\n owner: \"عبدالله\",\n note: \"الحزمة نزلت 2026-08-24. تقديم العرض يتطلب الشهادتين المنتهيتين أعلاه.\",\n source: \"~/Downloads/كراسة الشروط والمواصفات.pdf + ملاحق 1–12\",\n },\n {\n title: \"نزاع شركة ريفان للتطوير — مذكّرة الرد\",\n kind: \"قانوني\",\n ref: \"4870393702\",\n due_date: null,\n missing: \"الموعد النظامي للرد أو الجلسة\",\n recurrence: \"مرة واحدة\",\n owner: \"عبدالله\",\n note: \"عقد فلل سكنية بحي الشعلة، ثم ردّ ودّي على إنذار، ثم مذكّرة رد — خلال يومين. لا يُترك بلا موعد متابعة.\",\n source: \"~/Downloads · ثلاثة ملفات · 2026-09-02/03\",\n },\n {\n title: \"اعتراض على خصومات وغرامة تأخير — ماس كونستراكشن\",\n kind: \"مالي\",\n ref: null,\n due_date: null,\n missing: \"هل هناك مهلة اعتراض؟ وكم قيمة الخصم؟\",\n recurrence: \"مرة واحدة\",\n owner: \"المحاسب\",\n note: \"فاتورة ضريبية بكامل المبلغ يقابلها إشعار دائن بالخصومات وغرامة التأخير.\",\n source: \"~/Downloads · فاتورة + إشعار دائن + Deduction Format\",\n },\n {\n title: \"إيجار مكتب الخزامى — الرياض\",\n kind: \"عقد\",\n ref: \"عقد 3 أشهر\",\n due_date: null,\n missing: \"تاريخ بداية العقد — المدّة ثلاثة أشهر فقط\",\n recurrence: \"كل 3 أشهر\",\n owner: \"عبدالله\",\n note: \"مدّة قصيرة تعني تجديداً متكرّراً يسهل نسيانه.\",\n source: \"~/Downloads/إيجار مكتب موازين الخزامى ٣ شهور.pdf\",\n },\n {\n title: \"تحصيل فاتورة المعمار العربي رقم 8\",\n kind: \"مالي\",\n ref: \"invoice 8\",\n due_date: null,\n missing: \"تاريخ الاستحقاق وهل حُصِّلت\",\n recurrence: \"مرة واحدة\",\n owner: \"المحاسب\",\n note: null,\n source: \"~/Downloads/almimar_invoice8_clean.pdf\",\n },\n {\n title: \"تحصيل فاتورة المحيط الذهبي\",\n kind: \"مالي\",\n ref: null,\n due_date: null,\n missing: \"تاريخ الاستحقاق وهل حُصِّلت\",\n recurrence: \"مرة واحدة\",\n owner: \"المحاسب\",\n note: \"المحيط الذهبي هو أيضاً جهة مشروع فرسان 2.\",\n source: \"~/Downloads/فاتورة_المحيط_الذهبي_للمقاولات.pdf\",\n },\n {\n title: \"تفعيل DKIM لبريد الشركة\",\n kind: \"تقني\",\n ref: \"NETORGFT19614074\",\n due_date: null,\n missing: \"لا موعد — لكنه يعمل ضدّك كل يوم\",\n recurrence: \"مرة واحدة\",\n owner: \"عبدالله\",\n note: \"المحدّدان غير موجودَين، وDMARC على p=quarantine — أي أن عروض الأسعار والفواتير تُحجَز في المهملات عند العميل.\",\n source: \"~/mawazin-fixes/notes/dns-and-email.md · dig مقيس 2026-09-05\",\n },\n];\n\nexport async function seedIfEmpty() {\n const { rows } = await sqlite.execute(`SELECT COUNT(*) AS n FROM ${TABLE}`);\n const n = Number((rows[0] as Record).n ?? 0);\n if (n > 0) return n;\n const now = new Date().toISOString();\n for (const c of SEED) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE}\n (title, kind, ref, due_date, missing, recurrence, owner, note, source, done, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 0, ?)`,\n args: [c.title, c.kind, c.ref, c.due_date, c.missing, c.recurrence, c.owner, c.note, c.source, now],\n });\n }\n return SEED.length;\n}\n\n/** كل ما يحقّ لهذا الشخص أن يراه — لا أكثر. */\nexport async function list(who: PersonId): Promise {\n await init();\n await seedIfEmpty();\n const scopes = visibleScopes(who);\n const { rows } = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE}\n WHERE scope IN (${scopes.map(() => \"?\").join(\",\")})\n ORDER BY id`,\n args: scopes,\n });\n return rows as unknown as Commitment[];\n}\n\nexport async function setDate(id: number, due_date: string | null, missing: string | null) {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET due_date = ?, missing = ?, updated_at = ? WHERE id = ?`,\n args: [due_date, missing, new Date().toISOString(), id],\n });\n}\n\nexport async function setDone(id: number, done: boolean) {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET done = ?, updated_at = ? WHERE id = ?`,\n args: [done ? 1 : 0, new Date().toISOString(), id],\n });\n}\n\n/** أيام متبقّية حتى التاريخ — سالبة إذا مضى. */\nexport function daysLeft(due: string, today = new Date()): number {\n const d = new Date(due + \"T00:00:00Z\").getTime();\n const t = Date.UTC(today.getUTCFullYear(), today.getUTCMonth(), today.getUTCDate());\n return Math.round((d - t) / 86_400_000);\n}\n\nexport type Severity = \"منتهٍ\" | \"عاجل\" | \"قادم\" | \"مستقر\" | \"ناقص تاريخ\";\n\nexport function severity(c: Commitment): Severity {\n if (!c.due_date) return \"ناقص تاريخ\";\n const d = daysLeft(c.due_date);\n if (d < 0) return \"منتهٍ\";\n if (d <= 14) return \"عاجل\";\n if (d <= 60) return \"قادم\";\n return \"مستقر\";\n}\n\nconst ORDER: Record = {\n \"منتهٍ\": 0,\n \"عاجل\": 1,\n \"ناقص تاريخ\": 2,\n \"قادم\": 3,\n \"مستقر\": 4,\n};\n\nexport function sorted(items: Commitment[]): Commitment[] {\n return [...items].sort((a, b) => {\n const s = ORDER[severity(a)] - ORDER[severity(b)];\n if (s !== 0) return s;\n if (a.due_date && b.due_date) return a.due_date < b.due_date ? -1 : 1;\n return a.id - b.id;\n });\n}\n",[],[81],"d477d8ff-1960-48e7-bdbe-367ee4e3067b","daily.ts","eb2ada52-a8b2-11f1-a688-1607ee4eb77e",21,["D",1789510394690],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { daysLeft, list, severity } from \"./db.ts\";\n\n/**\n * لقطة يومية: تحسب ما يستحق الانتباه وتكتبه في جدول `digest`.\n * لا تُرسل شيئاً بعد — الإرسال (واتساب أو n8n أو بريد) خطوة تالية\n * تقرأ آخر صف من هذا الجدول. الكتابة أولاً حتى لا نفقد سجلّ ما كان مستحقاً متى.\n */\nexport default async function () {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS digest (\n day TEXT PRIMARY KEY,\n expired INTEGER NOT NULL,\n urgent INTEGER NOT NULL,\n undated INTEGER NOT NULL,\n lines TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n\n // اللقطة من منظور عبدالله — أوسع نطاق، فتشمل كل شيء.\n const items = (await list(\"abdullah\")).filter((i) => !i.done);\n const expired = items.filter((i) => severity(i) === \"منتهٍ\");\n const urgent = items.filter((i) => severity(i) === \"عاجل\");\n const undated = items.filter((i) => severity(i) === \"ناقص تاريخ\");\n\n const lines = [\n ...expired.map((i) => `منتهٍ منذ ${Math.abs(daysLeft(i.due_date!))} يوماً — ${i.title}`),\n ...urgent.map((i) => `بعد ${daysLeft(i.due_date!)} يوماً — ${i.title}`),\n ];\n\n const day = new Date().toISOString().slice(0, 10);\n await sqlite.execute({\n sql: `INSERT INTO digest (day, expired, urgent, undated, lines, created_at)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(day) DO UPDATE SET\n expired = excluded.expired,\n urgent = excluded.urgent,\n undated = excluded.undated,\n lines = excluded.lines,\n created_at = excluded.created_at`,\n args: [day, expired.length, urgent.length, undated.length, JSON.stringify(lines), new Date().toISOString()],\n });\n\n console.log(`[${day}] منتهٍ ${expired.length} · عاجل ${urgent.length} · ناقص تاريخ ${undated.length}`);\n for (const l of lines) console.log(\" · \" + l);\n}\n",[],[90],"00090a88-639b-4153-876c-9b3e26296640","README.md","82776818-a8b2-11f1-bb39-1607ee4eb77e",["D",1788562007161],"# موازين الشرق — عمود الالتزامات\n\nأول عمود من لوحة الشركة: كل موعد نظامي أو تعاقدي أو مالي في مكان واحد، مرتّباً بالإلحاح.\n",[],[99],["D",1788562117380],[108],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":109,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":110,"_18":111},["D",1788609208117],[],[19,36],"614ed2b5-bd41-4dc2-92fd-afd52c9feb5f",["D",1788562007108],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","موازين الشرق — عمود الالتزامات والمواعيد","imageUrl","userId","cca8102f-07bb-4295-b44a-38d66d1d3405","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f1d6e-b169-7628-a2c5-3fdc2bb2972f","tursoName","614ed2b5bd414dc292fdafd52c9feb5f","tursoHostname","614ed2b5bd414dc292fdafd52c9feb5f-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789522252250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_169":165},"org",{"_11":12,"_162":163,"_164":165,"_122":123,"_166":167,"_168":55},"branch",{"_17":92,"_13":16,"_34":42,"_154":112,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","mfcbr4krn8-hash","avatar","https://avatars.githubusercontent.com/u/294484094?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":112,"_13":14,"_47":219,"_114":-5,"_115":55,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":71,"_125":46,"_126":-5,"_127":-5,"_128":61,"_129":130,"_131":132,"_133":134,"_135":220,"_137":-5,"_138":139,"_140":139,"_141":142,"_143":142,"_144":142,"_145":139,"_146":139,"_147":221,"_149":222,"_151":223,"_153":55},[201,203,204,205,206],"files",[201,202,203,204,205,206],"counts",{"_192":61,"_193":74,"_194":61,"_32":195,"_196":197},[190],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":189},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":191},[19,36],"pulls","branches","forks",{"_198":59,"_200":61},"connections",{"_198":61,"_199":61},"count","unfilledCount","emptyCount",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":105,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_77":217,"_18":218},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":109,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_77":215,"_18":216},{"_34":98,"_13":99,"_37":100,"_39":-5,"_41":42,"_43":74,"_45":46,"_47":101,"_17":61,"_50":24,"_52":102,"_54":55,"_56":-5,"_77":213,"_18":214},{"_34":89,"_13":90,"_37":91,"_39":-5,"_41":42,"_43":92,"_45":46,"_47":93,"_17":94,"_50":51,"_52":95,"_54":55,"_56":-5,"_77":211,"_18":212},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":85,"_50":51,"_52":86,"_54":55,"_56":-5,"_77":209,"_18":210},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":-5,"_77":207,"_18":208},[],[70],[],[81],[],[90],[],[99],[],[19,36],[202],[19],["D",1788562007108],["D",1789522252250],{"_11":12,"_169":165},{"_11":12,"_162":163,"_164":165,"_122":123,"_166":167,"_168":55},{"_17":92,"_13":16,"_34":42,"_154":112,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"ctx",{"_147":-5,"_186":257,"_258":259,"_260":261,"_262":55,"_263":55,"_264":55,"_265":46,"_266":-5,"_267":-7,"_268":-7,"_269":61,"_270":55,"_271":55,"_272":-5,"_273":55,"_274":55,"_275":55,"_276":-5},"ENV",{"_228":229,"_230":231,"_232":16,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256},"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"]