[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_216":217,"_218":219},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"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",9,"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","a4259110-a8b2-11f1-a947-1607ee4eb77e","name","fileType","script","content","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/**\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\nexport async function list(): Promise {\n await init();\n await seedIfEmpty();\n const { rows } = await sqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id`);\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","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\nexport async function list(): Promise {\n await init();\n await seedIfEmpty();\n const { rows } = await sqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id`);\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","createdAt",["D",1788609103054],"branchVersion","branchId","18e26ae8-2946-4bab-a3ee-f24a717f8d24","id","614ed2b5-bd41-4dc2-92fd-afd52c9feb5f","mawazin",["D",1788562007108],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","موازين الشرق — عمود الالتزامات والمواعيد","imageUrl","cca8102f-07bb-4295-b44a-38d66d1d3405","pinnedFileId","d7e46dbe-a8b2-11f1-b82c-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":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",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","asnfq50","handle","displayName","mfcbr4krn8-hash","avatar","https://avatars.githubusercontent.com/u/294484094?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":211,"_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":212,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":213,"_84":214,"_86":215,"_88":25},"tree",[181,183,184,185,186],"files",[181,182,183,184,185,186],"counts",{"_171":63,"_172":161,"_173":63,"_174":175,"_176":177},"contents",[131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":165,"_32":166,"_30":167,"_138":-5,"_41":42,"_40":148,"_140":59,"_38":168,"_13":63,"_33":169,"_35":-5,"_24":25,"_144":-5,"_27":170},{"_43":158,"_32":159,"_30":160,"_138":-5,"_41":42,"_40":161,"_140":59,"_38":162,"_13":63,"_33":20,"_35":163,"_24":25,"_144":-5,"_27":164},{"_43":150,"_32":151,"_30":152,"_138":-5,"_41":42,"_40":153,"_140":25,"_38":154,"_13":63,"_33":155,"_35":156,"_24":25,"_144":-5,"_27":157},{"_43":146,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":147,"_13":148,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":149},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":141,"_13":63,"_33":142,"_35":143,"_24":25,"_144":-5,"_27":145},"7e304bf6-567d-4a34-95aa-1e531a80b7fd","index.tsx","parentId",4,"latest",["D",1788562150465],"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, setDate, setDone } from \"./db.ts\";\nimport { Board } from \"./frontend/Board.tsx\";\n\nconst app = new Hono();\nconst COOKIE = \"mk\";\n\n/** بوابة بمفتاح واحد: يُمرَّر مرة عبر ?k= ثم يُحفظ في كوكي لسنة. */\napp.use(\"*\", async (c, next) => {\n if (c.req.path === \"/source\") return next();\n const key = Deno.env.get(\"BOARD_KEY\");\n if (!key) return c.text(\"BOARD_KEY غير مضبوط\", 500);\n\n const given = c.req.query(\"k\") ?? getCookie(c, COOKIE);\n if (given !== key) {\n return c.html(\n `\n \n مغلق\n \n

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

`,\n 401,\n );\n }\n\n if (c.req.query(\"k\")) {\n setCookie(c, COOKIE, key, {\n path: \"/\",\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 60 * 60 * 24 * 365,\n });\n }\n return next();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/\", async (c) => {\n const items = await list();\n const page = ;\n return c.html(\"\" + (await Promise.resolve(page.toString())));\n});\n\napp.post(\"/save\", async (c) => {\n const body = await c.req.parseBody();\n const id = Number(body.id);\n if (!Number.isFinite(id)) return c.redirect(\"/\");\n\n if (body.toggle === \"1\") {\n const items = await list();\n const cur = items.find((i) => i.id === id);\n await setDone(id, !(cur && cur.done));\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\n/** JSON للوحات القادمة — نفس البوابة. */\napp.get(\"/api/commitments\", async (c) => c.json(await list()));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[137],"23f628aa-30e9-440a-81b1-bacf0a0404af",["D",1788609103054],3,[28],"e08299b5-d24d-49e7-b592-4bd2def836b9","daily.ts","eb2ada52-a8b2-11f1-a688-1607ee4eb77e",5,["D",1788562182805],"interval","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 const items = (await list()).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",[151],"00090a88-639b-4153-876c-9b3e26296640","README.md","82776818-a8b2-11f1-bb39-1607ee4eb77e",1,["D",1788562007161],"# موازين الشرق — عمود الالتزامات\n\nأول عمود من لوحة الشركة: كل موعد نظامي أو تعاقدي أو مالي في مكان واحد، مرتّباً بالإلحاح.\n",[159],"96ce0ae4-adef-454f-8186-40285905c5db","frontend","8e9836ce-f383-4066-b4af-666b6341cba4",["D",1788562117380],"directory",[166],"pulls","branches","forks","envVars",{"_178":148,"_180":63},"connections",{"_178":63,"_179":63},"count","unfilledCount","emptyCount",{"_43":165,"_32":166,"_30":167,"_138":-5,"_41":42,"_40":148,"_140":59,"_38":208,"_13":63,"_33":169,"_35":-5,"_24":25,"_144":-5,"_188":209,"_27":210},{"_43":200,"_32":201,"_30":202,"_138":167,"_41":42,"_40":203,"_140":25,"_38":204,"_13":161,"_33":34,"_35":205,"_24":25,"_144":-5,"_188":206,"_27":207},{"_43":158,"_32":159,"_30":160,"_138":-5,"_41":42,"_40":161,"_140":59,"_38":197,"_13":63,"_33":20,"_35":163,"_24":25,"_144":-5,"_188":198,"_27":199},{"_43":150,"_32":151,"_30":152,"_138":-5,"_41":42,"_40":153,"_140":25,"_38":194,"_13":63,"_33":155,"_35":156,"_24":25,"_144":-5,"_188":195,"_27":196},{"_43":146,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":191,"_13":148,"_33":34,"_35":37,"_24":25,"_144":-5,"_188":192,"_27":193},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":187,"_13":63,"_33":142,"_35":143,"_24":25,"_144":-5,"_188":189,"_27":190},["D",1788562150465],"children",[],[137],["D",1788609103054],[],[28],["D",1788562182805],[],[151],["D",1788562007161],[],[159],"ed5ad100-bbfa-4306-ad9a-527761010c3c","Board.tsx","c429bc3e-a8b2-11f1-8263-1607ee4eb77e",6,["D",1788562194251],"/** @jsxImportSource https://esm.sh/hono@4.5.6/jsx */\nimport { type Commitment, daysLeft, type Severity, severity, sorted } 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 {c.owner && · {c.owner}}\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 \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({ items, saved }: { items: Commitment[]; saved?: boolean }) {\n const list = sorted(items.filter((i) => !i.done));\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 موازين الشرق · العمود الأول\n

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

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

\n \n اليوم {today} · {items.length} بنداً\n \n \n\n {saved && (\n \n حُفِظ.\n \n )}\n\n \n\n

\n {list.map((c) => )}\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",[],[166,201],["D",1788562117380],[182],[166],["D",1788562007108],["D",1789522252250],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":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,"_128":249,"_250":251,"_252":253,"_254":25,"_255":25,"_256":25,"_257":59,"_258":-5,"_259":-7,"_260":-7,"_261":63,"_262":25,"_263":25,"_264":-5,"_265":25,"_266":25,"_267":25,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":90,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v9