[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","asnfq50","name","mawazin","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/asnfq50/mawazin/code/db.ts","extension","id","7f386310-9497-4cea-89a0-5c8c0ea26b4e","fileId","a4259110-a8b2-11f1-a947-1607ee4eb77e","parentId","branchId","18e26ae8-2946-4bab-a3ee-f24a717f8d24","branchVersion",10,"latest",true,"createdAt",["D",1788609106426],"version",4,"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 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","deleted",false,"label",[14],"614ed2b5-bd41-4dc2-92fd-afd52c9feb5f",["D",1788562007108],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","موازين الشرق — عمود الالتزامات والمواعيد","imageUrl","userId","cca8102f-07bb-4295-b44a-38d66d1d3405","pinnedFileId","d7e46dbe-a8b2-11f1-b82c-1607ee4eb77e","pinPreview","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",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","mfcbr4krn8-hash","avatar","https://avatars.githubusercontent.com/u/294484094?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]