Tawasol — تواصل حقيقي

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",32,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","e6518082-8147-4104-8912-edbedda94e71","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":26,"_40":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":26,"_40":41},"deleted",false,"deletedHere","path","index.html","latestPath","fileId","608c4024-af07-11f1-a552-1607ee4eb77e","name","fileType","content","\n\n\n\n\nTawasol — تواصل حقيقي\n\n\n\n

\n\n\n\n\n\n","\n\n\n\n\nTawasol — تواصل حقيقي\n\n\n\n

\n\n\n\n\n\n","createdAt",["D",1789261820999],"branchVersion","branchId","c97dbb80-fbf8-4a48-9647-3410a700ac93","id","ab9661db-3c34-42e6-a900-3856a3946454","tawasol",["D",1789258092781],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","تطبيق تواصل/محادثة مغربي بتصميم عربي RTL","imageUrl","f52a3ffd-7cd8-4a0b-b62e-0178b09263ef","pinnedFileId","6031f09c-af07-11f1-a552-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09816-8e78-7342-a79d-59883e8748fe","tursoName","ab9661db3c3442e6a9003856a3946454","tursoHostname","ab9661db3c3442e6a9003856a3946454-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789523429989],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",77,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kikof","handle","displayName","KIK OF","avatar","https://lh3.googleusercontent.com/a/ACg8ocIt5v5-z2FHhfGfe4g5cNbimrLEpPglDXo4Qh3O5cHHnrXXHcI=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":173,"_52":-5,"_53":31,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":174,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":175,"_89":176,"_91":177,"_93":31},"tree",[164,165],"files",[164,165],"counts",{"_153":68,"_154":155,"_156":68,"_157":158,"_159":160},"contents",[136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":149,"_38":34,"_36":37,"_140":-5,"_46":47,"_45":14,"_142":31,"_43":150,"_13":151,"_39":26,"_40":42,"_30":31,"_147":-5,"_33":152},{"_48":138,"_38":139,"_36":62,"_140":-5,"_46":47,"_45":141,"_142":31,"_43":143,"_13":144,"_39":145,"_40":146,"_30":31,"_147":-5,"_33":148},"0dc5b9fc-06db-4ddd-a696-edc4fea662b5","main.ts","parentId",29,"latest",["D",1789261803709],11,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// ----- الجداول -----\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n phone TEXT UNIQUE,\n name TEXT,\n color TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_user INTEGER,\n to_user INTEGER,\n text TEXT,\n audio TEXT,\n duration REAL,\n media TEXT,\n media_type TEXT,\n liked INTEGER DEFAULT 0,\n deleted INTEGER DEFAULT 0,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`\n);\n// أعمدة جديدة (باش ما نضيعو البيانات لو جدول كاين)\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN audio TEXT\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN duration REAL\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN media TEXT\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN media_type TEXT\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN liked INTEGER DEFAULT 0\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN deleted INTEGER DEFAULT 0\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE messages ADD COLUMN updated_at TEXT DEFAULT CURRENT_TIMESTAMP\"); } catch {}\ntry { await sqlite.execute(\"ALTER TABLE users ADD COLUMN color TEXT\"); } catch {}\n\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS calls (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n from_user INTEGER,\n to_user INTEGER,\n status TEXT DEFAULT 'ringing',\n offer TEXT,\n answer TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`\n);\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ice (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n call_id INTEGER,\n from_user INTEGER,\n candidate TEXT\n )`\n);\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\", \"access-control-allow-origin\": \"*\" },\n });\n}\n\nexport default async function handler(req: Request) {\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/+$/, \"\") || \"/\";\n const seg = path.split(\"/\").filter(Boolean); // e.g. [\"api\",\"call\",\"12\",\"answer\"]\n\n try {\n // ----- صفحة الويب -----\n if (path === \"/\") {\n const html = await readFile(\"./index.html\");\n return new Response(html, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n }\n\n // ===== المستخدمين =====\n if (req.method === \"POST\" && seg[0] === \"api\" && seg[1] === \"users\") {\n const b = await req.json();\n const name = String(b.name ?? \"\").trim();\n const phone = String(b.phone ?? \"\").trim();\n const color = String(b.color ?? \"\").trim();\n if (!name || !phone) return json({ error: \"الاسم والهاتف لازمين\" }, 400);\n\n const ex = await sqlite.execute({ sql: \"SELECT * FROM users WHERE phone = ?\", args: [phone] });\n if (ex.rows.length > 0) return json({ user: ex.rows[0], isNew: false });\n\n const ins = await sqlite.execute({\n sql: \"INSERT INTO users (name, phone, color) VALUES (?, ?, ?)\",\n args: [name, phone, color || null],\n });\n const user = { id: Number(ins.lastInsertRowid), name, phone, color: color || null };\n return json({ user, isNew: true });\n }\n\n if (req.method === \"GET\" && seg[0] === \"api\" && seg[1] === \"users\") {\n const res = await sqlite.execute(\"SELECT * FROM users ORDER BY name\");\n return json({ users: res.rows });\n }\n\n // ===== الرسائل =====\n if (req.method === \"POST\" && seg[0] === \"api\" && seg[1] === \"messages\" && seg.length === 2) {\n const b = await req.json();\n const from = Number(b.from);\n const to = Number(b.to);\n const text = String(b.text ?? \"\").trim();\n const audio = String(b.audio ?? \"\");\n const duration = Number(b.duration ?? 0) || 0;\n const media = String(b.media ?? \"\");\n const mediaType = String(b.mediaType ?? \"\");\n if (!from || !to) return json({ error: \"بيانات ناقصة\" }, 400);\n if (!text && !audio && !media) return json({ error: \"اكتب شي حاجة ولا سجّل صوت ولا ضيف ميديا\" }, 400);\n const ins = await sqlite.execute({\n sql: \"INSERT INTO messages (from_user, to_user, text, audio, duration, media, media_type) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n args: [from, to, text || null, audio || null, duration, media || null, mediaType || null],\n });\n return json({ ok: true, id: Number(ins.lastInsertRowid) });\n }\n\n if (req.method === \"GET\" && seg[0] === \"api\" && seg[1] === \"messages\" && seg.length === 2) {\n const a = Number(url.searchParams.get(\"a\"));\n const b = Number(url.searchParams.get(\"b\"));\n const after = Number(url.searchParams.get(\"after\") || 0);\n if (!a || !b) return json({ error: \"المعاملين a و b لازمين\" }, 400);\n const res = await sqlite.execute({\n sql: `SELECT * FROM messages\n WHERE ((from_user = ? AND to_user = ?) OR (from_user = ? AND to_user = ?))\n AND id > ? ORDER BY id ASC`,\n args: [a, b, b, a, after],\n });\n return json({ messages: res.rows });\n }\n\n // ===== آخر رسالة لكل محادثة (شعارات \"جديد\" ف اللائحة) =====\n if (req.method === \"GET\" && seg[0] === \"api\" && seg[1] === \"unread\") {\n const me = Number(url.searchParams.get(\"me\"));\n if (!me) return json({ error: \"me لازم\" }, 400);\n const res = await sqlite.execute({\n sql: `SELECT p.partner, m.id, m.from_user, m.to_user, m.text, m.created_at\n FROM messages m\n JOIN (SELECT (CASE WHEN from_user = ? THEN to_user ELSE from_user END) AS partner,\n MAX(id) AS maxid\n FROM messages WHERE from_user = ? OR to_user = ?\n GROUP BY partner) p\n ON m.id = p.maxid`,\n args: [me, me, me],\n });\n return json({ conversations: res.rows });\n }\n\n // ===== عاود جلب الرسائل لي تعدلات (like / مسح) =====\n if (req.method === \"GET\" && seg[0] === \"api\" && seg[1] === \"messages\" && seg[2] === \"updates\") {\n const a = Number(url.searchParams.get(\"a\"));\n const b = Number(url.searchParams.get(\"b\"));\n const since = url.searchParams.get(\"since\") || \"2000-01-01 00:00:00\";\n if (!a || !b) return json({ error: \"المعاملين a و b لازمين\" }, 400);\n const res = await sqlite.execute({\n sql: `SELECT * FROM messages\n WHERE ((from_user = ? AND to_user = ?) OR (from_user = ? AND to_user = ?))\n AND updated_at > ? ORDER BY id ASC`,\n args: [a, b, b, a, since],\n });\n return json({ messages: res.rows });\n }\n\n // ===== ليقر / مسح رسالة =====\n if (req.method === \"POST\" && seg[0] === \"api\" && seg[1] === \"messages\" && seg[3]) {\n const id = Number(seg[2]);\n const b = await req.json();\n if (!id) return json({ error: \"id غير صحيح\" }, 400);\n const row = await sqlite.execute({ sql: \"SELECT * FROM messages WHERE id = ?\", args: [id] });\n if (row.rows.length === 0) return json({ error: \"المسج ما كايناش\" }, 404);\n const m = row.rows[0];\n const user = Number(b.user);\n if (Number(m.from_user) !== user && Number(m.to_user) !== user) return json({ error: \"ماشي ديالك\" }, 403);\n\n if (seg[3] === \"like\") {\n await sqlite.execute({ sql: \"UPDATE messages SET liked = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?\", args: [b.liked ? 1 : 0, id] });\n return json({ ok: true, liked: b.liked ? 1 : 0 });\n }\n if (seg[3] === \"delete\") {\n await sqlite.execute({ sql: \"UPDATE messages SET text = NULL, audio = NULL, media = NULL, deleted = 1, updated_at = CURRENT_TIMESTAMP WHERE id = ?\", args: [id] });\n return json({ ok: true });\n }\n return json({ error: \"قول مي معروف\" }, 400);\n }\n\n // ===== المكالمات =====\n if (req.method === \"POST\" && seg[0] === \"api\" && seg[1] === \"calls\") {\n const b = await req.json();\n const from = Number(b.from);\n const to = Number(b.to);\n if (!from || !to) return json({ error: \"بيانات ناقصة\" }, 400);\n const ins = await sqlite.execute({\n sql: \"INSERT INTO calls (from_user, to_user) VALUES (?, ?)\",\n args: [from, to],\n });\n return json({ call: { id: Number(ins.lastInsertRowid), from_user: from, to_user: to, status: \"ringing\" } });\n }\n\n if (req.method === \"GET\" && seg[0] === \"api\" && seg[1] === \"calls\") {\n const me = Number(url.searchParams.get(\"me\"));\n const res = await sqlite.execute({\n sql: `SELECT * FROM calls\n WHERE status IN ('ringing','answered','offer') AND (from_user = ? OR to_user = ?)\n ORDER BY id DESC`,\n args: [me, me],\n });\n return json({ calls: res.rows });\n }\n\n // ----- /api/call/:id/... -----\n if (seg[0] === \"api\" && seg[1] === \"call\" && seg[2]) {\n const id = Number(seg[2]);\n if (!id) return json({ error: \"id غير صحيح\" }, 400);\n\n // تحديث offer / answer / status\n if (req.method === \"POST\") {\n const b = await req.json();\n if (seg[3] === \"offer\" && b.sdp) {\n await sqlite.execute({ sql: \"UPDATE calls SET offer = ?, status = 'offer' WHERE id = ?\", args: [b.sdp, id] });\n return json({ ok: true });\n }\n if (seg[3] === \"answer\" && b.sdp) {\n await sqlite.execute({ sql: \"UPDATE calls SET answer = ?, status = 'answered' WHERE id = ?\", args: [b.sdp, id] });\n return json({ ok: true });\n }\n if (seg[3] === \"status\" && b.status) {\n await sqlite.execute({ sql: \"UPDATE calls SET status = ? WHERE id = ?\", args: [b.status, id] });\n return json({ ok: true });\n }\n if (seg[3] === \"candidate\" && b.candidate) {\n await sqlite.execute({\n sql: \"INSERT INTO ice (call_id, from_user, candidate) VALUES (?, ?, ?)\",\n args: [id, Number(b.from), b.candidate],\n });\n return json({ ok: true });\n }\n return json({ error: \"قول رجى\" }, 400);\n }\n\n if (req.method === \"GET\") {\n if (seg[3] === \"candidates\") {\n const from = Number(url.searchParams.get(\"from\"));\n const after = Number(url.searchParams.get(\"after\") || 0);\n const res = await sqlite.execute({\n sql: \"SELECT * FROM ice WHERE call_id = ? AND from_user = ? AND id > ? ORDER BY id ASC\",\n args: [id, from, after],\n });\n return json({ candidates: res.rows });\n }\n // حالة المكالمة الكاملة\n const res = await sqlite.execute({ sql: \"SELECT * FROM calls WHERE id = ?\", args: [id] });\n if (res.rows.length === 0) return json({ error: \"المكالمة ما كايناش\" }, 404);\n return json({ call: res.rows[0] });\n }\n }\n\n return json({ error: \"مسار ما كاينش\" }, 404);\n } catch (e) {\n return json({ error: String(e) }, 500);\n }\n}\n","label",[139],"34a71293-3238-4bcd-9431-6391c29e82ee",["D",1789261820999],19,[34],"pulls","branches",1,"forks","envVars",{"_161":68,"_163":68},"connections",{"_161":68,"_162":68},"count","unfilledCount","emptyCount",{"_48":149,"_38":34,"_36":37,"_140":-5,"_46":47,"_45":14,"_142":31,"_43":170,"_13":151,"_39":26,"_40":42,"_30":31,"_147":-5,"_167":171,"_33":172},{"_48":138,"_38":139,"_36":62,"_140":-5,"_46":47,"_45":141,"_142":31,"_43":166,"_13":144,"_39":145,"_40":146,"_30":31,"_147":-5,"_167":168,"_33":169},["D",1789261803709],"children",[],[139],["D",1789261820999],[],[34],["D",1789258092781],["D",1789523429989],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":31},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":211,"_212":213,"_214":215,"_216":31,"_217":31,"_218":31,"_219":64,"_220":-5,"_221":-7,"_222":-7,"_223":68,"_224":31,"_225":31,"_226":-5,"_227":31,"_228":31,"_229":31,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":95,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"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 · v32