[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_221":222,"_223":224},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_168":-5,"_20":169,"_22":170,"_171":172,"_173":174,"_26":175,"_24":176,"_177":-5,"_178":-5,"_179":70,"_180":181,"_182":64,"_183":-5,"_184":-5,"_185":186},"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/Board.tsx","project",{"_33":110,"_13":14,"_47":111,"_112":-5,"_113":70,"_114":115,"_116":115,"_117":118,"_119":-5,"_120":121,"_122":61,"_123":64,"_124":-5,"_125":-5,"_126":96,"_127":128,"_129":130,"_131":132,"_133":134,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":146,"_147":148,"_149":150,"_151":70},"tree",[54,55,56,57,58],"file",{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_18":52},"contents",[],"upstream","pull","ahead","behind","envVars","id","db93d54a-de2b-4602-91f9-d7a4b91a969f","branchId","18e26ae8-2946-4bab-a3ee-f24a717f8d24","fileId","c429bc3e-a8b2-11f1-8263-1607ee4eb77e","Board.tsx","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","fileType","script",9,"parentId","8e9836ce-f383-4066-b4af-666b6341cba4","createdAt",["D",1788609208117],"branchVersion",20,"label",[53,39],"frontend",{"_33":100,"_13":53,"_37":46,"_45":-5,"_35":36,"_49":101,"_63":64,"_47":102,"_17":96,"_42":103,"_40":-5,"_69":70,"_51":-5,"_71":104,"_18":105},{"_33":92,"_13":93,"_37":94,"_45":-5,"_35":36,"_49":66,"_63":64,"_47":95,"_17":96,"_42":24,"_40":97,"_69":70,"_51":-5,"_71":98,"_18":99},{"_33":83,"_13":84,"_37":85,"_45":-5,"_35":36,"_49":86,"_63":64,"_47":87,"_17":88,"_42":43,"_40":89,"_69":70,"_51":-5,"_71":90,"_18":91},{"_33":74,"_13":75,"_37":76,"_45":-5,"_35":36,"_49":77,"_63":64,"_47":78,"_17":79,"_42":43,"_40":80,"_69":70,"_51":-5,"_71":81,"_18":82},{"_33":59,"_13":60,"_37":61,"_45":-5,"_35":36,"_49":62,"_63":64,"_47":65,"_17":66,"_42":67,"_40":68,"_69":70,"_51":-5,"_71":72,"_18":73},"94fb2d77-ba10-4ac4-b323-0e0cc7af3ce3","index.tsx","d7e46dbe-a8b2-11f1-b82c-1607ee4eb77e",11,"latest",true,["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","deleted",false,"children",[],[60],"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",[],[75],"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",[],[84],"00090a88-639b-4153-876c-9b3e26296640","README.md","82776818-a8b2-11f1-bb39-1607ee4eb77e",["D",1788562007161],0,"# موازين الشرق — عمود الالتزامات\n\nأول عمود من لوحة الشركة: كل موعد نظامي أو تعاقدي أو مالي في مكان واحد، مرتّباً بالإلحاح.\n",[],[93],"96ce0ae4-adef-454f-8186-40285905c5db",3,["D",1788562117380],"directory",[106],[53],{"_33":34,"_13":39,"_37":38,"_45":46,"_35":36,"_49":50,"_63":64,"_47":107,"_17":44,"_42":43,"_40":41,"_69":70,"_51":-5,"_71":108,"_18":109},["D",1788609208117],[],[53,39],"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,"_167":163},"org",{"_11":12,"_160":161,"_162":163,"_120":121,"_164":165,"_166":70},"branch",{"_17":86,"_13":16,"_33":36,"_152":110,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":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",{"_33":110,"_13":14,"_47":216,"_112":-5,"_113":70,"_114":115,"_116":115,"_117":118,"_119":-5,"_120":121,"_122":61,"_123":64,"_124":-5,"_125":-5,"_126":96,"_127":128,"_129":130,"_131":132,"_133":217,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":218,"_147":219,"_149":220,"_151":70},[198,200,201,202,203],"files",[198,199,200,201,202,203],"counts",{"_189":96,"_190":66,"_191":96,"_32":192,"_193":194},[],{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":43,"_17":44,"_45":46,"_47":187,"_49":50,"_51":-5,"_18":188},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1788609208117],[53,39],"pulls","branches","forks",{"_195":101,"_197":96},"connections",{"_195":96,"_196":96},"count","unfilledCount","emptyCount",{"_33":100,"_13":53,"_37":46,"_45":-5,"_35":36,"_49":101,"_63":64,"_47":102,"_17":96,"_42":103,"_40":-5,"_69":70,"_51":-5,"_71":214,"_18":215},{"_33":34,"_13":39,"_37":38,"_45":46,"_35":36,"_49":50,"_63":64,"_47":107,"_17":44,"_42":43,"_40":41,"_69":70,"_51":-5,"_71":212,"_18":213},{"_33":92,"_13":93,"_37":94,"_45":-5,"_35":36,"_49":66,"_63":64,"_47":95,"_17":96,"_42":24,"_40":97,"_69":70,"_51":-5,"_71":210,"_18":211},{"_33":83,"_13":84,"_37":85,"_45":-5,"_35":36,"_49":86,"_63":64,"_47":87,"_17":88,"_42":43,"_40":89,"_69":70,"_51":-5,"_71":208,"_18":209},{"_33":74,"_13":75,"_37":76,"_45":-5,"_35":36,"_49":77,"_63":64,"_47":78,"_17":79,"_42":43,"_40":80,"_69":70,"_51":-5,"_71":206,"_18":207},{"_33":59,"_13":60,"_37":61,"_45":-5,"_35":36,"_49":62,"_63":64,"_47":65,"_17":66,"_42":67,"_40":68,"_69":70,"_51":-5,"_71":204,"_18":205},[],[60],[],[75],[],[84],[],[93],[],[53,39],[199],[53],["D",1788562007108],["D",1789522252250],{"_11":12,"_167":163},{"_11":12,"_160":161,"_162":163,"_120":121,"_164":165,"_166":70},{"_17":86,"_13":16,"_33":36,"_152":110,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"ctx",{"_145":-5,"_184":254,"_255":256,"_257":258,"_259":70,"_260":70,"_261":70,"_262":64,"_263":-5,"_264":-7,"_265":-7,"_266":96,"_267":70,"_268":70,"_269":-5,"_270":70,"_271":70,"_272":70,"_273":-5},"ENV",{"_225":226,"_227":228,"_229":16,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253},"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"]