[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_110":111,"_112":113},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","asnfq50","name","najla-makeup","path","lib/db.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/asnfq50/najla-makeup/code/lib/db.ts","extension","id","57889cb5-1d57-4dc8-a1db-65d0bae254d1","db.ts","fileId","e994cc74-afbb-11f1-9eba-1607ee4eb77e","parentId","200fe74d-8ef8-4343-a5a1-297a2da2eb49","branchId","2fb3b93c-3153-49cc-928f-ccd798836746","branchVersion",42,"latest",true,"createdAt",["D",1789376376520],"version",2,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport type Service = {\n id: number;\n name: string;\n description: string;\n category: string;\n duration_min: number;\n /** Price per person for one person (SAR). */\n price: number | null;\n /** Price per person when two people book together. */\n price_pair: number | null;\n /** Price per person for a group of three or more. */\n price_group: number | null;\n price_note: string;\n active: number;\n sort: number;\n};\nexport type ServiceInput = Omit;\n\nexport const STATUSES = [\"pending\", \"confirmed\", \"done\", \"cancelled\"] as const;\nexport type Status = (typeof STATUSES)[number];\n\nexport type Booking = {\n id: number;\n code: string;\n service_id: number;\n service_name: string;\n duration_min: number;\n price: number | null;\n date: string;\n time: string;\n start_min: number;\n name: string;\n phone: string;\n location_type: string;\n city: string;\n people: number;\n notes: string;\n status: Status;\n created_at: string;\n};\nexport type NewBooking = Omit;\nexport type BookingView = \"upcoming\" | \"pending\" | \"past\" | \"all\";\n\nexport type GalleryItem = {\n id: number;\n blob_key: string;\n mime: string;\n caption: string;\n sort: number;\n visible: number;\n};\n\nexport type Settings = {\n workDays: number[];\n open: string;\n close: string;\n slotStep: number;\n bufferMin: number;\n minNoticeHours: number;\n maxDaysAhead: number;\n allowStudio: boolean;\n whatsapp: string;\n snapchat: string;\n instagram: string;\n followers: string;\n tagline: string;\n about: string;\n policy: string;\n pricingNote: string;\n /** Cities where the listed prices apply; elsewhere the price is agreed on WhatsApp. */\n priceCities: string[];\n announcement: string;\n indexable: boolean;\n};\n\nexport const DEFAULT_SETTINGS: Settings = {\n workDays: [0, 1, 2, 3, 4, 5, 6],\n open: \"11:00\",\n close: \"22:00\",\n slotStep: 30,\n bufferMin: 30,\n minNoticeHours: 336,\n maxDaysAhead: 120,\n allowStudio: false,\n whatsapp: \"966506859518\",\n snapchat: \"najlamakeup11\",\n instagram: \"najla_makeupartist\",\n followers: \"٦٨ ألف\",\n tagline: \"خبيرة مكياج بخبرة تزيد عن ١٠ سنوات في مكياج العرائس والسهرات.\",\n about:\n \"خبيرة مكياج محترفة تتمتع بخبرة تزيد عن 10 سنوات في مجال التجميل.\\nمتخصصة في مكياج العرائس، والمكياج الناعم (Soft Glam)، والمكياج الكامل (Full Glam)، ومكياج جلسات التصوير (Editorial)، ومكياج التجميل الفاخر.\\nشغوفة بالابتكار في عالم الجمال، واختبار المنتجات، ومشاركة تجارب حقيقية وصادقة مع العلامات التجارية والجمهور.\\nلقد اكتسبتُ -على مدار سنوات خبرتي- كفاءة عالية في مجال مستحضرات التجميل الفاخرة، ومنتجات العناية بالبشرة، واتجاهات الجمال، وصناعة المحتوى المتعلق بالتجميل.\",\n policy:\n \"لا يتم تأكيد الحجز إلا بدفع العربون وتصوير الإيصال:\\n• الملكة والعروس: ٥٠٠ ر.س\\n• المرافقات: ١٠٠ ر.س عن كل مرافقة\\n🔴 علماً بأن العربون لا يُسترد ولا يؤجَّل ولا يُستبدل مع زبونة أخرى 🔴\",\n pricingNote: \"الأسعار داخل الخبر والدمام، وتختلف في باقي المناطق.\",\n priceCities: [\"الخبر\", \"الدمام\"],\n announcement: \"\",\n indexable: false,\n};\n\n// name, description, category, duration, price, price_pair, price_group\nconst SEED_SERVICES: [string, string, string, number, number | null, number | null, number | null][] = [\n [\"ميك اب عروس\", \"خطوات تهيئة البشرة + مكياج كامل + رموش + مكياج وهايلايت للجسم\", \"عرايس\", 40, 2000, null, null],\n [\"ميك اب السهرة\", \"مكياج كامل + الرموش\", \"سهرات\", 25, 800, 700, 600],\n];\n\ntype Arg = string | number | null;\nconst q = (sql: string, args: Arg[] = []) => sqlite.execute({ sql, args });\nconst all = (r: { rows: unknown[] }) => r.rows as T[];\nconst one = (r: { rows: unknown[] }) => (r.rows[0] as T | undefined) ?? null;\n\nlet ready: Promise | null = null;\nexport function ensureSchema(): Promise {\n ready ??= migrate().catch((e) => {\n ready = null;\n throw e;\n });\n return ready;\n}\n\nasync function migrate() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS services (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL DEFAULT '',\n category TEXT NOT NULL DEFAULT '',\n duration_min INTEGER NOT NULL DEFAULT 60,\n price INTEGER,\n price_pair INTEGER,\n price_group INTEGER,\n price_note TEXT NOT NULL DEFAULT '',\n active INTEGER NOT NULL DEFAULT 1,\n sort INTEGER NOT NULL DEFAULT 0)`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS bookings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n code TEXT NOT NULL UNIQUE,\n service_id INTEGER NOT NULL,\n service_name TEXT NOT NULL,\n duration_min INTEGER NOT NULL,\n price INTEGER,\n date TEXT NOT NULL,\n time TEXT NOT NULL,\n start_min INTEGER NOT NULL,\n name TEXT NOT NULL,\n phone TEXT NOT NULL,\n location_type TEXT NOT NULL,\n city TEXT NOT NULL DEFAULT '',\n people INTEGER NOT NULL DEFAULT 1,\n notes TEXT NOT NULL DEFAULT '',\n status TEXT NOT NULL DEFAULT 'pending',\n created_at TEXT NOT NULL DEFAULT (datetime('now')))`,\n args: [],\n },\n { sql: \"CREATE INDEX IF NOT EXISTS idx_bookings_date ON bookings(date, status)\", args: [] },\n { sql: \"CREATE INDEX IF NOT EXISTS idx_bookings_phone ON bookings(phone)\", args: [] },\n {\n sql: `CREATE TABLE IF NOT EXISTS gallery (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n blob_key TEXT NOT NULL UNIQUE,\n mime TEXT NOT NULL,\n caption TEXT NOT NULL DEFAULT '',\n sort INTEGER NOT NULL DEFAULT 0,\n visible INTEGER NOT NULL DEFAULT 1)`,\n args: [],\n },\n { sql: \"CREATE TABLE IF NOT EXISTS settings (key TEXT PRIMARY KEY, value TEXT NOT NULL)\", args: [] },\n {\n sql: \"CREATE TABLE IF NOT EXISTS blocked_dates (date TEXT PRIMARY KEY, reason TEXT NOT NULL DEFAULT '')\",\n args: [],\n },\n {\n sql: \"CREATE TABLE IF NOT EXISTS login_failures (id INTEGER PRIMARY KEY AUTOINCREMENT, ip TEXT NOT NULL, at INTEGER NOT NULL)\",\n args: [],\n },\n ]);\n\n // Columns added after the first release; harmless if they already exist.\n for (const sql of [\n \"ALTER TABLE services ADD COLUMN price_pair INTEGER\",\n \"ALTER TABLE services ADD COLUMN price_group INTEGER\",\n ]) {\n try {\n await q(sql);\n } catch {\n // column exists\n }\n }\n\n if (one(await q(\"SELECT value FROM settings WHERE key = 'seeded'\"))) return;\n\n const n = one<{ n: number }>(await q(\"SELECT COUNT(*) AS n FROM services\"));\n if (Number(n?.n ?? 0) === 0) {\n await sqlite.batch(\n SEED_SERVICES.map(([name, description, category, duration, price, pair, group], i) => ({\n sql:\n \"INSERT INTO services (name, description, category, duration_min, price, price_pair, price_group, price_note, active, sort) VALUES (?, ?, ?, ?, ?, ?, ?, '', 1, ?)\",\n args: [name, description, category, duration, price, pair, group, i],\n })),\n );\n }\n if (await seedGallery()) {\n await q(\"INSERT OR REPLACE INTO settings (key, value) VALUES ('seeded', ?)\", [new Date().toISOString()]);\n }\n}\n\nconst b64ToBytes = (b64: string) => Uint8Array.from(atob(b64), (ch) => ch.charCodeAt(0));\n\nasync function seedGallery(): Promise {\n const n = one<{ n: number }>(await q(\"SELECT COUNT(*) AS n FROM gallery\"));\n if (Number(n?.n ?? 0) > 0) return true;\n let data: { logo?: string; items: { name: string; b64: string }[] };\n try {\n data = JSON.parse(await readFile(\"/data/gallery.json\"));\n } catch (e) {\n console.error(\"gallery seed skipped:\", e);\n return false;\n }\n if (data.logo) await blob.set(\"brand/logo\", b64ToBytes(data.logo));\n let sort = 0;\n for (const item of data.items) {\n const key = `gallery/${item.name}`;\n await blob.set(key, b64ToBytes(item.b64));\n await q(\"INSERT OR IGNORE INTO gallery (blob_key, mime, sort) VALUES (?, 'image/jpeg', ?)\", [key, sort++]);\n }\n return true;\n}\n\n// ── Settings ────────────────────────────────────────────────\nexport async function getSettings(): Promise {\n const row = one<{ value: string }>(await q(\"SELECT value FROM settings WHERE key = 'app'\"));\n if (!row) return { ...DEFAULT_SETTINGS };\n try {\n return { ...DEFAULT_SETTINGS, ...JSON.parse(row.value) };\n } catch {\n return { ...DEFAULT_SETTINGS };\n }\n}\n\nexport async function saveSettings(s: Settings) {\n await q(\n \"INSERT INTO settings (key, value) VALUES ('app', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value\",\n [JSON.stringify(s)],\n );\n}\n\n// ── Services ────────────────────────────────────────────────\nexport async function listServices(activeOnly: boolean) {\n return all(\n await q(`SELECT * FROM services ${activeOnly ? \"WHERE active = 1\" : \"\"} ORDER BY sort, id`),\n );\n}\n\nexport async function getService(id: number) {\n if (!Number.isInteger(id)) return null;\n return one(await q(\"SELECT * FROM services WHERE id = ?\", [id]));\n}\n\nexport async function createService(s: ServiceInput) {\n await q(\n \"INSERT INTO services (name, description, category, duration_min, price, price_pair, price_group, price_note, active, sort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\",\n [s.name, s.description, s.category, s.duration_min, s.price, s.price_pair, s.price_group, s.price_note, s.active, s.sort],\n );\n}\n\nexport async function updateService(id: number, s: ServiceInput) {\n await q(\n \"UPDATE services SET name = ?, description = ?, category = ?, duration_min = ?, price = ?, price_pair = ?, price_group = ?, price_note = ?, active = ?, sort = ? WHERE id = ?\",\n [s.name, s.description, s.category, s.duration_min, s.price, s.price_pair, s.price_group, s.price_note, s.active, s.sort, id],\n );\n}\n\nexport async function deleteService(id: number) {\n await q(\"DELETE FROM services WHERE id = ?\", [id]);\n}\n\n// ── Bookings ────────────────────────────────────────────────\nconst CODE_ALPHABET = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\nfunction makeCode() {\n const bytes = crypto.getRandomValues(new Uint8Array(8));\n return Array.from(bytes, (b) => CODE_ALPHABET[b % CODE_ALPHABET.length]).join(\"\");\n}\n\n/** Atomic insert: fails if the slot overlaps an open booking (incl. buffer) or the day is blocked. */\nexport async function createBooking(\n b: NewBooking,\n bufferMin: number,\n): Promise<{ ok: true; code: string } | { ok: false }> {\n const code = makeCode();\n const r = await q(\n `INSERT INTO bookings (code, service_id, service_name, duration_min, price, date, time, start_min, name, phone, location_type, city, people, notes, status)\n SELECT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?\n WHERE NOT EXISTS (\n SELECT 1 FROM bookings\n WHERE date = ? AND status IN ('pending', 'confirmed')\n AND start_min < ? AND ? < start_min + duration_min + ?)\n AND NOT EXISTS (SELECT 1 FROM blocked_dates WHERE date = ?)`,\n [\n code, b.service_id, b.service_name, b.duration_min, b.price, b.date, b.time, b.start_min,\n b.name, b.phone, b.location_type, b.city, b.people, b.notes, b.status,\n b.date, b.start_min + b.duration_min + bufferMin, b.start_min, bufferMin, b.date,\n ],\n );\n return r.rowsAffected > 0 ? { ok: true, code } : { ok: false };\n}\n\nexport async function openBookingsOnDate(date: string) {\n return all>(\n await q(\n \"SELECT start_min, duration_min FROM bookings WHERE date = ? AND status IN ('pending', 'confirmed')\",\n [date],\n ),\n );\n}\n\nexport async function getBookingByCode(code: string) {\n if (!/^[A-Z0-9]{8}$/.test(code)) return null;\n return one(await q(\"SELECT * FROM bookings WHERE code = ?\", [code]));\n}\n\nexport async function listBookings(view: BookingView, today: string) {\n const queries: Record = {\n upcoming: [\n \"SELECT * FROM bookings WHERE date >= ? AND status IN ('pending', 'confirmed') ORDER BY date, start_min\",\n [today],\n ],\n pending: [\"SELECT * FROM bookings WHERE date >= ? AND status = 'pending' ORDER BY date, start_min\", [today]],\n past: [\n \"SELECT * FROM bookings WHERE date < ? OR status IN ('done', 'cancelled') ORDER BY date DESC, start_min DESC LIMIT 200\",\n [today],\n ],\n all: [\"SELECT * FROM bookings ORDER BY date DESC, start_min DESC LIMIT 300\", []],\n };\n const [sql, args] = queries[view];\n return all(await q(sql, args));\n}\n\nexport async function bookingStats(today: string, weekEnd: string) {\n const r = one>(\n await q(\n `SELECT\n SUM(CASE WHEN status = 'pending' AND date >= ? THEN 1 ELSE 0 END) AS pending,\n SUM(CASE WHEN status = 'confirmed' AND date >= ? THEN 1 ELSE 0 END) AS confirmed,\n SUM(CASE WHEN status IN ('pending', 'confirmed') AND date = ? THEN 1 ELSE 0 END) AS today,\n SUM(CASE WHEN status IN ('pending', 'confirmed') AND date >= ? AND date <= ? THEN 1 ELSE 0 END) AS week\n FROM bookings`,\n [today, today, today, today, weekEnd],\n ),\n );\n return {\n pending: Number(r?.pending ?? 0),\n confirmed: Number(r?.confirmed ?? 0),\n today: Number(r?.today ?? 0),\n week: Number(r?.week ?? 0),\n };\n}\n\nexport async function setBookingStatus(id: number, status: Status) {\n await q(\"UPDATE bookings SET status = ? WHERE id = ?\", [status, id]);\n}\n\nexport async function countOpenBookingsByPhone(phone: string, today: string) {\n const r = one<{ n: number }>(\n await q(\"SELECT COUNT(*) AS n FROM bookings WHERE phone = ? AND status = 'pending' AND date >= ?\", [phone, today]),\n );\n return Number(r?.n ?? 0);\n}\n\n// ── Blocked dates ───────────────────────────────────────────\nexport async function listBlocked(from: string) {\n return all<{ date: string; reason: string }>(\n await q(\"SELECT * FROM blocked_dates WHERE date >= ? ORDER BY date\", [from]),\n );\n}\n\nexport async function isBlocked(date: string) {\n return !!one(await q(\"SELECT 1 FROM blocked_dates WHERE date = ?\", [date]));\n}\n\nexport async function addBlocked(date: string, reason: string) {\n await q(\"INSERT OR REPLACE INTO blocked_dates (date, reason) VALUES (?, ?)\", [date, reason]);\n}\n\nexport async function removeBlocked(date: string) {\n await q(\"DELETE FROM blocked_dates WHERE date = ?\", [date]);\n}\n\n// ── Gallery ─────────────────────────────────────────────────\nexport async function listGallery(visibleOnly: boolean) {\n return all(\n await q(`SELECT * FROM gallery ${visibleOnly ? \"WHERE visible = 1\" : \"\"} ORDER BY sort, id`),\n );\n}\n\nexport async function getGalleryItem(id: number) {\n if (!Number.isInteger(id)) return null;\n return one(await q(\"SELECT * FROM gallery WHERE id = ?\", [id]));\n}\n\nexport async function addGalleryItem(key: string, mime: string) {\n await q(\n \"INSERT INTO gallery (blob_key, mime, sort) VALUES (?, ?, (SELECT COALESCE(MAX(sort), 0) + 1 FROM gallery))\",\n [key, mime],\n );\n}\n\nexport async function toggleGalleryItem(id: number) {\n await q(\"UPDATE gallery SET visible = 1 - visible WHERE id = ?\", [id]);\n}\n\nexport async function makeGalleryHero(id: number) {\n await q(\n \"UPDATE gallery SET sort = (SELECT COALESCE(MIN(sort), 0) - 1 FROM gallery), visible = 1 WHERE id = ?\",\n [id],\n );\n}\n\nexport async function deleteGalleryItem(id: number) {\n await q(\"DELETE FROM gallery WHERE id = ?\", [id]);\n}\n\n// ── Login throttling ────────────────────────────────────────\nconst WINDOW_MS = 15 * 60 * 1000;\n\nexport async function recentLoginFailures(ip: string) {\n const r = one<{ n: number }>(\n await q(\"SELECT COUNT(*) AS n FROM login_failures WHERE ip = ? AND at > ?\", [ip, Date.now() - WINDOW_MS]),\n );\n return Number(r?.n ?? 0);\n}\n\nexport async function recordLoginFailure(ip: string) {\n await sqlite.batch([\n { sql: \"DELETE FROM login_failures WHERE at < ?\", args: [Date.now() - WINDOW_MS] },\n { sql: \"INSERT INTO login_failures (ip, at) VALUES (?, ?)\", args: [ip, Date.now()] },\n ]);\n}\n","deleted",false,"label",[47,24],"lib","d8f07974-33ec-460f-a8b5-8a56ac73d9bd",["D",1789334949320],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","موقع نجلاء الغفيلي ميك اب ارتست — خدمات ونظام حجوزات","imageUrl","userId","cca8102f-07bb-4295-b44a-38d66d1d3405","pinnedFileId","01a09cac-8e2f-7716-b801-b7ea38740c6d","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f1d6e-b169-7628-a2c5-3fdc2bb2972f","tursoName","d8f0797433ec460fa8b58a56ac73d9bd","tursoHostname","d8f0797433ec460fa8b58a56ac73d9bd-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_109":105},"org",{"_9":10,"_102":103,"_104":105,"_58":59,"_106":107,"_108":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",52,"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",{"_85":-5,"_143":144,"_145":146,"_147":148,"_149":44,"_150":44,"_151":44,"_152":34,"_153":-5,"_154":-7,"_155":-7,"_156":66,"_157":44,"_158":44,"_159":-5,"_160":44,"_161":44,"_162":44,"_163":-5},"ENV",{"_114":115,"_116":117,"_118":93,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140,"_141":142},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]