\n سامانه هوشمند مانیتورینگ و پیامک همایس\n

پنل مدیریت سرورلس

\n\n \n

\n \n \n \n \n

\n\n \n

\n پیام‌های ذخیره\n 0\n

\n مخاطبان پیامک\n 0\n

\n گروه‌های فعال\n 0\n

\n\n \n

\n \n

➕ ثبت یا ویرایش دستی شماره عضو

\n \n \n \n

\n \n

\n\n \n

لیست مخاطبان فعال

\n \n

در حال دریافت لیست مخاطبان...

\n\n \n

\n \n

\n \n \n

\n \n

پیامی مطابق جستجو یافت نشد.

\n\n \n

افزودن برچسب جدید

\n \n \n

\n در حال بارگذاری...\n

\n\n \n\n`;\n}\n",1,["D",1788858936625],"branchVersion","label",[18],"pulls","branches","forks","envVars",{"_169":171,"_172":26},"connections",{"_169":26,"_170":26},"count","unfilledCount",3,"emptyCount",{"_33":154,"_13":18,"_64":65,"_43":-5,"_35":36,"_159":74,"_185":95,"_37":239,"_39":157,"_66":67,"_155":156,"_68":24,"_160":-5,"_188":240,"_17":241},{"_33":231,"_13":232,"_64":233,"_43":-5,"_35":36,"_159":234,"_185":95,"_37":235,"_39":157,"_66":67,"_155":236,"_68":24,"_160":-5,"_188":237,"_17":238},{"_33":223,"_13":224,"_64":225,"_43":-5,"_35":36,"_159":226,"_185":95,"_37":227,"_39":157,"_66":67,"_155":228,"_68":24,"_160":-5,"_188":229,"_17":230},{"_33":215,"_13":216,"_64":217,"_43":-5,"_35":36,"_159":118,"_185":95,"_37":218,"_39":219,"_66":67,"_155":220,"_68":24,"_160":-5,"_188":221,"_17":222},{"_33":207,"_13":208,"_64":209,"_43":-5,"_35":36,"_159":210,"_185":95,"_37":211,"_39":26,"_66":67,"_155":212,"_68":24,"_160":-5,"_188":213,"_17":214},{"_33":199,"_13":200,"_64":93,"_43":-5,"_35":36,"_159":201,"_185":95,"_37":202,"_39":171,"_66":203,"_155":204,"_68":24,"_160":14,"_188":205,"_17":206},{"_33":191,"_13":192,"_64":193,"_43":-5,"_35":36,"_159":194,"_185":95,"_37":195,"_39":26,"_66":67,"_155":196,"_68":24,"_160":-5,"_188":197,"_17":198},{"_33":181,"_13":182,"_64":183,"_43":-5,"_35":36,"_159":184,"_185":95,"_37":186,"_39":26,"_66":67,"_155":187,"_68":24,"_160":-5,"_188":189,"_17":190},"190681c2-6b1e-4767-b8e5-600c4c6977b2","telegram.ts","4cc21bf4-ab65-11f1-a335-1607ee4eb77e",9,"latest",["D",1788858699291],"// ==========================================\n// توابع ارسال و حذف پیام در تلگرام\n// ==========================================\nimport { TG_API } from \"./config.ts\";\n\nexport async function callTelegram(method: string, payload: any) {\n try {\n const res = await fetch(`${TG_API}/${method}`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n return await res.json();\n } catch (err) {\n console.error(`Telegram API Error [${method}]:`, err);\n return null;\n }\n}\n\nexport async function sendMessage(chatId: number, text: string, extra: any = {}) {\n return callTelegram(\"sendMessage\", { chat_id: chatId, text, ...extra });\n}\n\nexport async function answerCallbackQuery(\n callbackQueryId: string,\n text = \"\",\n showAlert = false,\n) {\n return callTelegram(\"answerCallbackQuery\", {\n callback_query_id: callbackQueryId,\n text,\n show_alert: showAlert,\n });\n}\n\nexport async function editMessageText(\n chatId: number,\n messageId: number,\n text: string,\n replyMarkup: any = null,\n) {\n return callTelegram(\"editMessageText\", {\n chat_id: chatId,\n message_id: messageId,\n text,\n reply_markup: replyMarkup || undefined,\n });\n}\n\nexport async function deleteMessage(chatId: number, messageId: number) {\n return callTelegram(\"deleteMessage\", {\n chat_id: chatId,\n message_id: messageId,\n });\n}\n\nexport async function getChatMember(chatId: number, userId: number) {\n const res = await callTelegram(\"getChatMember\", {\n chat_id: chatId,\n user_id: userId,\n });\n return res?.result;\n}\n","children",[],[182],"f6d6c1a3-52bd-43f5-a84f-eb5fefee47f0","sms.ts","4cba3aa6-ab65-11f1-a335-1607ee4eb77e",8,["D",1788858699238],"// ==========================================\n// وب‌سرویس پیامک شرکت همایس\n// ==========================================\nimport { HOMAIS_CONFIG } from \"./config.ts\";\n\nexport function normalizeIranianPhone(rawPhone: string): string {\n let cleaned = rawPhone.replace(/[^0-9]/g, \"\");\n if (cleaned.startsWith(\"98\")) {\n cleaned = \"0\" + cleaned.substring(2);\n } else if (cleaned.startsWith(\"9\") && cleaned.length === 10) {\n cleaned = \"0\" + cleaned;\n }\n return cleaned;\n}\n\nexport async function sendHomaisSms(mobile: string, text: string) {\n const targetMobile = normalizeIranianPhone(mobile);\n const params = new URLSearchParams({\n username: HOMAIS_CONFIG.username,\n password: HOMAIS_CONFIG.password,\n PortalCode: HOMAIS_CONFIG.portalCode,\n mobile: targetMobile,\n message: text,\n ServerType: HOMAIS_CONFIG.serverType,\n });\n\n const url =\n `http://api.homais.com/services/messaging/sms/api/sendMessage/direct/?${params.toString()}`;\n\n try {\n const res = await fetch(url, { method: \"GET\" });\n const rawText = await res.text();\n return {\n status: res.status,\n ok: res.ok && !rawText.toLowerCase().includes(\"error\"),\n body: rawText.trim(),\n };\n } catch (err: any) {\n return { status: 0, ok: false, body: `خطا در اتصال: ${err.message}` };\n }\n}\n",[],[192],"90fd19a5-5b63-4903-afed-f86b95cb2193","main.ts",18,["D",1788858919399],"http","// ==========================================\n// ورودی اصلی سرورلس (Entrypoint)\n// ==========================================\nimport { initDatabase } from \"./db.ts\";\nimport { handleApiRequests } from \"./api.ts\";\nimport { getMiniAppHtml } from \"./adminHtml.ts\";\nimport { handleTelegramUpdate } from \"./bot.ts\";\n\nexport default async function (req: Request): Promise {\n await initDatabase();\n\n const url = new URL(req.url);\n\n if (url.pathname.startsWith(\"/api/\")) {\n return handleApiRequests(req, url);\n }\n\n if (url.pathname === \"/admin\" || url.pathname === \"/miniapp\") {\n return new Response(getMiniAppHtml(), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n if (req.method === \"POST\") {\n try {\n const update = await req.json();\n await handleTelegramUpdate(update);\n return new Response(\"OK\", { status: 200 });\n } catch (e: any) {\n console.error(\"Error processing Telegram Update:\", e);\n return new Response(\"Error\", { status: 500 });\n }\n }\n\n return new Response(\"✅ پروژه ماژولار تلگرام و همایس با موفقیت آنلاین است!\", {\n headers: { \"Content-Type\": \"text/plain; charset=utf-8\" },\n });\n}\n",[],[200],"d9f88a75-327c-4c23-bd68-8dae951ea675","db.ts","4cb32388-ab65-11f1-a335-1607ee4eb77e",7,["D",1788858699194],"// ==========================================\n// راه‌اندازی دیتابیس SQLite\n// ==========================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport async function query(sql: string, args: any[] = []) {\n const res = await sqlite.execute({ sql, args });\n const rows = (res.rows || []).map((row: any) => {\n if (!Array.isArray(row)) return row;\n const obj: Record = {};\n (res.columns || []).forEach((col: string, idx: number) => {\n obj[col] = row[idx];\n });\n return obj;\n });\n return {\n rows,\n lastInsertRowid: res.lastInsertRowid,\n rowsAffected: res.rowsAffected,\n };\n}\n\nexport async function initDatabase() {\n await query(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tg_id INTEGER UNIQUE,\n first_name TEXT,\n username TEXT,\n phone TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n );\n `);\n await query(`\n CREATE TABLE IF NOT EXISTS topic_members (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id INTEGER,\n thread_id INTEGER DEFAULT 0,\n tg_id INTEGER,\n last_active DATETIME DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(chat_id, thread_id, tg_id)\n );\n `);\n await query(`\n CREATE TABLE IF NOT EXISTS messages_index (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id INTEGER,\n chat_title TEXT,\n message_thread_id INTEGER DEFAULT 0,\n message_id INTEGER,\n sender_id INTEGER,\n sender_name TEXT,\n text TEXT,\n has_media INTEGER DEFAULT 0,\n tag TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n );\n `);\n await query(`\n CREATE TABLE IF NOT EXISTS predefined_tags (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE\n );\n `);\n}\n",[],[208],"3ed50a00-5e4c-4ecb-bc01-b86576b18917","config.ts","4cac036e-ab65-11f1-a335-1607ee4eb77e",["D",1788866899652],2,"// ==========================================\n// تنظیمات توکن‌ها، ادمین و همایس\n// ==========================================\nconst getEnv = (key: string, fallback = \"\") =>\n Deno.env.get(key) || (typeof process !== \"undefined\" ? process.env[key] : undefined) || fallback;\n\n\n\nexport const ADMIN_ID = Number(getEnv(\"ADMIN_ID\", \"0\"));\n\nexport const HOMAIS_CONFIG = {\n username: getEnv(\"HOMAIS_USERNAME\", \"fr41160\"),\n password: getEnv(\"HOMAIS_PASSWORD\", \"X823212\"),\n portalCode: getEnv(\"HOMAIS_PORTAL_CODE\", \"10003692\"),\n serverType: getEnv(\"HOMAIS_SERVER_TYPE\", \"100\"),\n};\nconst TELEGRAM_TOKEN = getEnv(\"TELEGRAM_TOKEN\");\n\nexport const TG_API = `https://api.telegram.org/bot${TELEGRAM_TOKEN}`;\nexport const SINGLE_EMOJI_REGEX = /^(\\p{Extended_Pictographic}|\\p{Emoji_Presentation})$/u;",[],[216],"8e8639d8-ca0c-448e-b92d-1972ab11433f","bot.ts","5821f028-ab65-11f1-80c0-1607ee4eb77e",16,["D",1788858919260],"// ==========================================\n// پردازش پیام‌های گروه، عکس‌ها و دکمه‌ها\n// ==========================================\nimport { ADMIN_ID, SINGLE_EMOJI_REGEX } from \"./config.ts\";\nimport { query } from \"./db.ts\";\nimport { sendHomaisSms } from \"./sms.ts\";\nimport {\n sendMessage,\n answerCallbackQuery,\n editMessageText,\n deleteMessage,\n getChatMember,\n} from \"./telegram.ts\";\n\nexport async function handleTelegramUpdate(update: any) {\n // ۱. دکمه‌های شیشه‌ای\n if (update.callback_query) {\n const { id, data, from, message } = update.callback_query;\n if (!data) return;\n\n const [action, targetId, extra] = data.split(\":\");\n const recordId = Number(targetId);\n\n // حذف پیام و انصراف از پیامک\n if (action === \"dismiss\") {\n const res = await query(\"SELECT * FROM messages_index WHERE id = ? LIMIT 1\", [recordId]);\n const msgRecord = res.rows[0];\n\n if (msgRecord) {\n let canDismiss = from.id === msgRecord.sender_id || from.id === ADMIN_ID;\n if (!canDismiss) {\n const member = await getChatMember(msgRecord.chat_id, from.id);\n canDismiss = [\"creator\", \"administrator\"].includes(member?.status);\n }\n if (!canDismiss) {\n return answerCallbackQuery(id, \"⛔️ تنها فرستنده پیام یا مدیران گروه مجاز به حذف هستند.\", true);\n }\n }\n\n await deleteMessage(message.chat.id, message.message_id);\n await answerCallbackQuery(id, \"پیام حذف شد.\");\n return;\n }\n\n // ارسال پیامک گروهی\n if (action === \"sms\") {\n const res = await query(\"SELECT * FROM messages_index WHERE id = ? LIMIT 1\", [recordId]);\n const msgRecord = res.rows[0];\n\n if (!msgRecord) {\n return answerCallbackQuery(id, \"پیام در سیستم یافت نشد.\", true);\n }\n\n let canDispatch = from.id === msgRecord.sender_id || from.id === ADMIN_ID;\n if (!canDispatch) {\n const member = await getChatMember(msgRecord.chat_id, from.id);\n canDispatch = [\"creator\", \"administrator\"].includes(member?.status);\n }\n\n if (!canDispatch) {\n return answerCallbackQuery(id, \"⛔️ تنها نویسنده پیام یا مدیر گروه مجاز به ارسال پیامک هستند.\", true);\n }\n\n const membersRes = await query(`\n SELECT DISTINCT u.phone \n FROM topic_members tm\n INNER JOIN users u ON tm.tg_id = u.tg_id\n WHERE tm.chat_id = ? AND tm.thread_id = ? AND tm.tg_id != ? AND u.phone IS NOT NULL AND u.phone != ''\n `, [msgRecord.chat_id, msgRecord.message_thread_id, from.id]);\n\n const phones = membersRes.rows.map((r) => r.phone).filter(Boolean);\n\n if (phones.length === 0) {\n return answerCallbackQuery(id, \"⚠️ هیچ مخاطبی با شماره در این تاپیک ثبت نشده است.\", true);\n }\n\n await answerCallbackQuery(id, `در حال ارسال پیامک به ${phones.length} مخاطب...`);\n\n let smsText = \"\";\n if (msgRecord.has_media && msgRecord.text.includes(\"بارگذاری شده\")) {\n smsText =\n `یک عکس در گروه [${msgRecord.chat_title}] بارگذاری شده که جالب توجه شما می باشد. (ارسال‌کننده: ${msgRecord.sender_name})`;\n } else {\n const excerpt = msgRecord.text.length > 70 ? msgRecord.text.substring(0, 67) + \"...\" : msgRecord.text;\n smsText =\n `پیام جدید از ${msgRecord.sender_name} در گروه [${msgRecord.chat_title}]:\\n${excerpt}`;\n }\n\n await Promise.allSettled(phones.map((phone) => sendHomaisSms(phone, smsText)));\n\n await editMessageText(\n message.chat.id,\n message.message_id,\n `✅ پیامک این پیام با موفقیت به سرور همایس تحویل و برای ${phones.length} نفر ارسال شد.`,\n );\n return;\n }\n\n // منوی برچسب‌ها\n if (action === \"tag_menu\") {\n const tagsRes = await query(\"SELECT * FROM predefined_tags ORDER BY id DESC LIMIT 10\");\n if (tagsRes.rows.length === 0) {\n return answerCallbackQuery(id, \"هنوز برچسبی در پنل ادمین ثبت نشده است.\", true);\n }\n\n const keyboard = tagsRes.rows.map((t) => [\n { text: `#${t.name}`, callback_data: `set_tag:${recordId}:${t.name}` },\n ]);\n keyboard.push([{ text: \"🔙 بازگشت\", callback_data: `back_main:${recordId}` }]);\n\n await editMessageText(message.chat.id, message.message_id, \"یک برچسب برای این پیام انتخاب کنید:\", {\n inline_keyboard: keyboard,\n });\n return;\n }\n\n if (action === \"back_main\") {\n await editMessageText(message.chat.id, message.message_id, \"عملیات اطلاع‌رسانی پیامک:\", {\n inline_keyboard: [\n [\n { text: \"📩 بله، پیامک هم بشود\", callback_data: `sms:${recordId}` },\n { text: \"🏷 برچسب‌گذاری\", callback_data: `tag_menu:${recordId}` },\n ],\n [\n { text: \"❌ خیر، پیامک نشود (حذف)\", callback_data: `dismiss:${recordId}` },\n ],\n ],\n });\n return;\n }\n\n if (action === \"set_tag\") {\n const tagName = extra;\n await query(\"UPDATE messages_index SET tag = ? WHERE id = ?\", [tagName, recordId]);\n await answerCallbackQuery(id, `برچسب #${tagName} اعمال شد.`);\n await editMessageText(message.chat.id, message.message_id, `برچسب #${tagName} ثبت گردید ✅`);\n return;\n }\n\n return;\n }\n\n // ۲. پیام‌های ورودی\n const msg = update.message;\n if (!msg) return;\n\n const chatId = msg.chat.id;\n\n // پی‌وی (احراز شماره)\n if (msg.chat.type === \"private\") {\n if (msg.text === \"/start\") {\n const userRes = await query(\"SELECT phone FROM users WHERE tg_id = ? LIMIT 1\", [msg.from.id]);\n\n if (userRes.rows[0]?.phone) {\n return sendMessage(chatId, `سلام ${msg.from.first_name}! شماره شما (${userRes.rows[0].phone}) در سامانه ثبت است.`);\n }\n\n return sendMessage(chatId, `سلام ${msg.from.first_name}!\\nجهت دریافت پیامک‌های جلسات، لطفاً دکمه زیر را لمس کرده و شماره خود را به اشتراک بگذارید:`, {\n reply_markup: {\n keyboard: [[{ text: \"📱 اشتراک‌گذاری شماره برای دریافت پیامک‌ها\", request_contact: true }]],\n resize_keyboard: true,\n one_time_keyboard: true,\n },\n });\n }\n\n if (msg.contact) {\n if (msg.contact.user_id !== msg.from.id) {\n return sendMessage(chatId, \"❌ لطفاً شماره مربوط به اکانت خودتان را بفرستید.\");\n }\n const rawPhone = msg.contact.phone_number;\n await query(`\n INSERT INTO users (tg_id, first_name, username, phone) \n VALUES (?, ?, ?, ?)\n ON CONFLICT(tg_id) DO UPDATE SET phone = excluded.phone, first_name = excluded.first_name, username = excluded.username;\n `, [msg.from.id, msg.from.first_name, msg.from.username || \"\", rawPhone]);\n\n return sendMessage(chatId, \"✅ شماره شما با موفقیت در سامانه همایس ثبت گردید.\", {\n reply_markup: { remove_keyboard: true },\n });\n }\n\n if (msg.text?.startsWith(\"/testsms\") && msg.from.id === ADMIN_ID) {\n const parts = msg.text.replace(\"/testsms\", \"\").trim().split(\" \");\n const mobile = parts[0];\n const smsText = parts.slice(1).join(\" \");\n\n if (!mobile || !smsText) {\n return sendMessage(chatId, \"❌ فرمت:\\n`/testsms 09121111111 متن پیامک`\", { parse_mode: \"Markdown\" });\n }\n\n await sendMessage(chatId, \"⏳ در حال ارسال پیامک به همایس...\");\n const res = await sendHomaisSms(mobile, smsText);\n return sendMessage(chatId, `📡 وضعیت: ${res.ok ? \"✅ موفق\" : \"❌ خطا\"}\\nپاسخ: \\`${res.body}\\``, { parse_mode: \"Markdown\" });\n }\n\n return;\n }\n\n // گروه‌ها و تاپیک‌ها\n if ([\"group\", \"supergroup\"].includes(msg.chat.type)) {\n if (msg.new_chat_members || msg.left_chat_member || msg.pinned_message) return;\n\n const groupTitle = msg.chat.title || \"گروه\";\n const hasMedia = Boolean(msg.photo || msg.video || msg.document);\n let trimmed = (msg.text || msg.caption || \"\").trim();\n\n if (hasMedia && !trimmed) {\n trimmed = `یک عکس در گروه ${groupTitle} بارگذاری شده که جالب توجه شما می باشد`;\n }\n\n if (!hasMedia && (!trimmed || trimmed.length < 4 || SINGLE_EMOJI_REGEX.test(trimmed))) {\n return;\n }\n\n const threadId = msg.message_thread_id || 0;\n const userId = msg.from.id;\n\n await query(`\n INSERT INTO topic_members (chat_id, thread_id, tg_id) VALUES (?, ?, ?)\n ON CONFLICT(chat_id, thread_id, tg_id) DO UPDATE SET last_active = CURRENT_TIMESTAMP;\n `, [chatId, threadId, userId]);\n\n const insRes = await query(`\n INSERT INTO messages_index (chat_id, chat_title, message_thread_id, message_id, sender_id, sender_name, text, has_media)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING id;\n `, [\n chatId,\n groupTitle,\n threadId,\n msg.message_id,\n userId,\n `${msg.from.first_name || \"\"} ${msg.from.last_name || \"\"}`.trim(),\n trimmed,\n hasMedia ? 1 : 0,\n ]);\n\n const recordId = insRes.rows[0]?.id || insRes.lastInsertRowid;\n\n await sendMessage(chatId, \"عملیات اطلاع‌رسانی پیامک:\", {\n reply_to_message_id: msg.message_id,\n message_thread_id: threadId || undefined,\n reply_markup: {\n inline_keyboard: [\n [\n { text: \"📩 بله، پیامک هم بشود\", callback_data: `sms:${recordId}` },\n { text: \"🏷 برچسب‌گذاری\", callback_data: `tag_menu:${recordId}` },\n ],\n [\n { text: \"❌ خیر، پیامک نشود (حذف)\", callback_data: `dismiss:${recordId}` },\n ],\n ],\n },\n });\n }\n}\n",[],[224],"8f9b91ec-ed3a-48ee-b442-68a28915410b","api.ts","585efcfc-ab65-11f1-80c0-1607ee4eb77e",17,["D",1788858919339],"// ==========================================\n// سرویس‌های API پنل مینی‌اپ و مدیریت مخاطبان\n// ==========================================\nimport { query } from \"./db.ts\";\n\nexport async function handleApiRequests(req: Request, url: URL): Promise {\n // ۱. آمار داشبورد\n if (url.pathname === \"/api/stats\") {\n const msgCount = await query(\"SELECT COUNT(*) as count FROM messages_index\");\n const userCount = await query(\"SELECT COUNT(*) as count FROM users WHERE phone IS NOT NULL AND phone != ''\");\n const groupCount = await query(\"SELECT COUNT(DISTINCT chat_id) as count FROM messages_index\");\n\n return Response.json({\n totalMessages: msgCount.rows[0]?.count || 0,\n usersWithPhone: userCount.rows[0]?.count || 0,\n connectedGroups: groupCount.rows[0]?.count || 0,\n });\n }\n\n // ۲. مدیریت شماره‌ها و اعضا (جدید)\n if (url.pathname === \"/api/users\") {\n if (req.method === \"GET\") {\n const usersList = await query(\"SELECT * FROM users ORDER BY id DESC\");\n return Response.json(usersList.rows);\n }\n // ثبت یا ویرایش دستی شماره\n if (req.method === \"POST\") {\n const { tg_id, first_name, username, phone } = await req.json();\n if (!tg_id || !phone) {\n return Response.json({ error: \"آیدی عددی تلگرام و شماره الزامی است\" }, { status: 400 });\n }\n\n await query(`\n INSERT INTO users (tg_id, first_name, username, phone)\n VALUES (?, ?, ?, ?)\n ON CONFLICT(tg_id) DO UPDATE SET\n phone = excluded.phone,\n first_name = COALESCE(NULLIF(excluded.first_name, ''), users.first_name),\n username = COALESCE(NULLIF(excluded.username, ''), users.username);\n `, [Number(tg_id), first_name || \"کاربر ثبت دستی\", username || \"\", phone]);\n\n return Response.json({ success: true });\n }\n // حذف شماره کاربر\n if (req.method === \"DELETE\") {\n const tgId = Number(url.searchParams.get(\"tg_id\"));\n await query(\"DELETE FROM users WHERE tg_id = ?\", [tgId]);\n return Response.json({ success: true });\n }\n }\n\n // ۳. لیست گروه‌ها\n if (url.pathname === \"/api/groups\") {\n const groups = await query(\"SELECT DISTINCT chat_id, chat_title FROM messages_index\");\n return Response.json(groups.rows);\n }\n\n // ۴. مدیریت برچسب‌ها\n if (url.pathname === \"/api/tags\") {\n if (req.method === \"GET\") {\n const tags = await query(\"SELECT * FROM predefined_tags ORDER BY id DESC\");\n return Response.json(tags.rows);\n }\n if (req.method === \"POST\") {\n const { name } = await req.json();\n if (!name) return Response.json({ error: \"Name is required\" }, { status: 400 });\n const clean = name.replace(/^#/, \"\").trim();\n await query(\"INSERT OR IGNORE INTO predefined_tags (name) VALUES (?)\", [clean]);\n return Response.json({ success: true, name: clean });\n }\n if (req.method === \"DELETE\") {\n const id = Number(url.searchParams.get(\"id\"));\n await query(\"DELETE FROM predefined_tags WHERE id = ?\", [id]);\n return Response.json({ success: true });\n }\n }\n\n // ۵. جستجوی سراسری\n if (url.pathname === \"/api/search\") {\n const q = url.searchParams.get(\"q\") || \"\";\n const chatId = url.searchParams.get(\"chat_id\");\n const tag = url.searchParams.get(\"tag\");\n\n let sqlQuery = \"SELECT * FROM messages_index WHERE 1=1\";\n const args: any[] = [];\n\n if (q) {\n sqlQuery += \" AND text LIKE ?\";\n args.push(`%${q}%`);\n }\n if (chatId) {\n sqlQuery += \" AND chat_id = ?\";\n args.push(Number(chatId));\n }\n if (tag) {\n sqlQuery += \" AND tag = ?\";\n args.push(tag);\n }\n\n sqlQuery += \" ORDER BY id DESC LIMIT 50\";\n const results = await query(sqlQuery, args);\n return Response.json(results.rows);\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}\n",[],[232],["D",1788858936625],[],[18],["D",1788790482273],{"_11":12,"_132":71},{"_11":12,"_127":128,"_70":71,"_30":69,"_129":130,"_131":24},{"_39":118,"_13":16,"_33":36,"_119":82,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":14,"_126":12},"ctx",{"_54":-5,"_151":279,"_280":281,"_282":283,"_284":24,"_285":24,"_286":24,"_287":95,"_288":-5,"_289":-7,"_290":-7,"_291":26,"_292":24,"_293":24,"_294":-5,"_295":24,"_296":24,"_297":24,"_298":-5},"ENV",{"_250":251,"_252":253,"_254":16,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278},"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"]

History · adminHtml.ts