[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_219":220,"_221":222},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":60,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/Board.tsx","latestPath","fileId","c429bc3e-a8b2-11f1-8263-1607ee4eb77e","name","Board.tsx","fileType","script","content","/** @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","/** @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 {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

\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","createdAt",["D",1788609150617],"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",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"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",{"_44":45,"_32":46,"_39":214,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":215,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":216,"_85":217,"_87":218,"_89":25},"tree",[187,189,190,191,192],"files",[187,188,189,190,191,192],"counts",{"_177":64,"_178":143,"_179":64,"_180":181,"_182":183},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":170,"_32":171,"_30":172,"_139":-5,"_42":43,"_41":173,"_141":60,"_39":174,"_13":64,"_34":175,"_36":-5,"_24":25,"_146":-5,"_27":176},{"_44":164,"_32":165,"_30":166,"_139":-5,"_42":43,"_41":143,"_141":60,"_39":167,"_13":64,"_34":20,"_36":168,"_24":25,"_146":-5,"_27":169},{"_44":156,"_32":157,"_30":158,"_139":-5,"_42":43,"_41":159,"_141":25,"_39":160,"_13":143,"_34":161,"_36":162,"_24":25,"_146":-5,"_27":163},{"_44":148,"_32":149,"_30":150,"_139":-5,"_42":43,"_41":151,"_141":60,"_39":152,"_13":153,"_34":35,"_36":154,"_24":25,"_146":-5,"_27":155},{"_44":137,"_32":138,"_30":58,"_139":-5,"_42":43,"_41":140,"_141":60,"_39":142,"_13":143,"_34":144,"_36":145,"_24":25,"_146":-5,"_27":147},"94fb2d77-ba10-4ac4-b323-0e0cc7af3ce3","index.tsx","parentId",11,"latest",["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","label",[138],"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",[149],"c4a03761-fe69-4a66-9f1f-15a79e192260","daily.ts","eb2ada52-a8b2-11f1-a688-1607ee4eb77e",12,["D",1788609137317],"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 // اللقطة من منظور عبدالله — أوسع نطاق، فتشمل كل شيء.\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",[157],"00090a88-639b-4153-876c-9b3e26296640","README.md","82776818-a8b2-11f1-bb39-1607ee4eb77e",["D",1788562007161],"# موازين الشرق — عمود الالتزامات\n\nأول عمود من لوحة الشركة: كل موعد نظامي أو تعاقدي أو مالي في مكان واحد، مرتّباً بالإلحاح.\n",[165],"96ce0ae4-adef-454f-8186-40285905c5db","frontend","8e9836ce-f383-4066-b4af-666b6341cba4",3,["D",1788562117380],"directory",[171],"pulls","branches","forks","envVars",{"_184":173,"_186":64},"connections",{"_184":64,"_185":64},"count","unfilledCount","emptyCount",{"_44":170,"_32":171,"_30":172,"_139":-5,"_42":43,"_41":173,"_141":60,"_39":211,"_13":64,"_34":175,"_36":-5,"_24":25,"_146":-5,"_194":212,"_27":213},{"_44":206,"_32":33,"_30":31,"_139":172,"_42":43,"_41":14,"_141":25,"_39":207,"_13":208,"_34":35,"_36":38,"_24":25,"_146":-5,"_194":209,"_27":210},{"_44":164,"_32":165,"_30":166,"_139":-5,"_42":43,"_41":143,"_141":60,"_39":203,"_13":64,"_34":20,"_36":168,"_24":25,"_146":-5,"_194":204,"_27":205},{"_44":156,"_32":157,"_30":158,"_139":-5,"_42":43,"_41":159,"_141":25,"_39":200,"_13":143,"_34":161,"_36":162,"_24":25,"_146":-5,"_194":201,"_27":202},{"_44":148,"_32":149,"_30":150,"_139":-5,"_42":43,"_41":151,"_141":60,"_39":197,"_13":153,"_34":35,"_36":154,"_24":25,"_146":-5,"_194":198,"_27":199},{"_44":137,"_32":138,"_30":58,"_139":-5,"_42":43,"_41":140,"_141":60,"_39":193,"_13":143,"_34":144,"_36":145,"_24":25,"_146":-5,"_194":195,"_27":196},["D",1788609136142],"children",[],[138],["D",1788609106426],[],[149],["D",1788609137317],[],[157],["D",1788562007161],[],[165],"231aa842-8116-485f-a7f5-e20458f9c579",["D",1788609150617],2,[],[171,33],["D",1788562117380],[188],[171],["D",1788562007108],["D",1789522252250],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_129":252,"_253":254,"_255":256,"_257":25,"_258":25,"_259":25,"_260":60,"_261":-5,"_262":-7,"_263":-7,"_264":64,"_265":25,"_266":25,"_267":-5,"_268":25,"_269":25,"_270":25,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":91,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"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"]

Diff · v13