[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_217":218,"_219":220},"routes/_app.x.$handle.$name",{"_101":100,"_37":49,"_110":91,"_32":57,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_26":-5,"_121":-5,"_122":-5,"_123":30,"_124":125,"_126":63,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":30},"version",9,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a400bc5c-2ec6-4349-901f-7139617d8bd3","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","telegram.ts","latestPath","fileId","4cc21bf4-ab65-11f1-a335-1607ee4eb77e","name","fileType","script","content","// ==========================================\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","createdAt",["D",1788858699291],"branchVersion","branchId","293f160b-03df-4621-8fc1-dfff3966c814","id","0678c3c6-6f72-4d9f-bfd3-6d8c885b60df","telegram-smart-bot",["D",1788790482273],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","0c10d4b3-a9b8-43e9-8be3-54116d58fe53","pinnedFileId","78439a22-aac6-11f1-adaa-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a07bcd-74fd-7086-a12b-f5d75098a171","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_19":59,"_106":107,"_108":30},"branch",{"_13":90,"_37":91,"_47":46,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","omid13841384","handle","displayName","omid13841384 omid1384138","avatar","https://lh3.googleusercontent.com/a/ACg8ocIXl3UwWZDaTFVGW5NJGINpBCP0DAKvx9qWWJBZSW5Q-F3gDA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_47":48,"_37":49,"_42":213,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":214,"_85":215,"_87":216,"_89":30},"tree",[188,189,190,191,192,193],"files",[188,189,190,191,192,193],"counts",{"_178":67,"_179":161,"_180":67,"_181":182,"_183":184},"contents",[131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":171,"_37":172,"_35":173,"_138":-5,"_45":46,"_44":174,"_139":30,"_42":175,"_13":67,"_38":39,"_40":176,"_29":30,"_141":-5,"_32":177},{"_47":164,"_37":165,"_35":166,"_138":-5,"_45":46,"_44":167,"_139":63,"_42":168,"_13":67,"_38":39,"_40":169,"_29":30,"_141":-5,"_32":170},{"_47":159,"_37":160,"_35":61,"_138":-5,"_45":46,"_44":161,"_139":30,"_42":162,"_13":67,"_38":39,"_40":57,"_29":30,"_141":49,"_32":163},{"_47":150,"_37":151,"_35":152,"_138":-5,"_45":46,"_44":153,"_139":30,"_42":154,"_13":155,"_38":156,"_40":157,"_29":30,"_141":-5,"_32":158},{"_47":143,"_37":144,"_35":145,"_138":-5,"_45":46,"_44":146,"_139":63,"_42":147,"_13":67,"_38":39,"_40":148,"_29":30,"_141":-5,"_32":149},{"_47":137,"_37":33,"_35":36,"_138":-5,"_45":46,"_44":14,"_139":63,"_42":140,"_13":67,"_38":39,"_40":41,"_29":30,"_141":-5,"_32":142},"190681c2-6b1e-4767-b8e5-600c4c6977b2","parentId","latest",["D",1788858699291],"label",[33],"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",[144],"1e596bc9-e0e9-4e11-8fe9-3718603b12ad","new-file-7403.ts","7bb68a8e-aac6-11f1-8a11-1607ee4eb77e",5,["D",1788793858743],3,"http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ==========================================\n// ۱. تنظیمات و متغیرهای اصلی\n// ==========================================\nconst getEnv = (key: string, fallback = \"\") => \n Deno.env.get(key) || (typeof process !== \"undefined\" ? process.env[key] : undefined) || fallback;\n\n// توکن ربات شما\nconst TELEGRAM_TOKEN = getEnv(\"TELEGRAM_TOKEN\", \"8326233308:AAGE4ooStvlfzgyv9o8-YIFZ24pVnZLC-P4\");\n\nconst ADMIN_ID = Number(getEnv(\"ADMIN_ID\", \"0\"));\n\nconst HOMAIS_CONFIG = {\n username: getEnv(\"HOMAIS_USERNAME\", \"fr41160\"),\n password: getEnv(\"HOMAIS_PASSWORD\", \"823212\"),\n portalCode: getEnv(\"HOMAIS_PORTAL_CODE\", \"10003692\"),\n serverType: getEnv(\"HOMAIS_SERVER_TYPE\", \"100\"),\n};\n\nconst TG_API = `https://api.telegram.org/bot${TELEGRAM_TOKEN}`;\nconst SINGLE_EMOJI_REGEX = /^(\\p{Extended_Pictographic}|\\p{Emoji_Presentation})$/u;\n\n// ==========================================\n// ۲. لایه دیتابیس هوشمند Val Town (SQLite Engine)\n// ==========================================\nasync 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\nasync 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\n// ==========================================\n// ۳. درایور پیامک شرکت همایس\n// ==========================================\nfunction 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\nasync 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 = `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\n// ==========================================\n// ۴. توابع ارتباط با تلگرام\n// ==========================================\nasync 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\nasync function sendMessage(chatId: number, text: string, extra: any = {}) {\n return callTelegram(\"sendMessage\", { chat_id: chatId, text, ...extra });\n}\n\nasync function answerCallbackQuery(callbackQueryId: string, text = \"\", showAlert = false) {\n return callTelegram(\"answerCallbackQuery\", { callback_query_id: callbackQueryId, text, show_alert: showAlert });\n}\n\nasync function editMessageText(chatId: number, messageId: number, text: string, replyMarkup: any = null) {\n return callTelegram(\"editMessageText\", {\n chat_id: chatId,\n message_id: messageId,\n text,\n reply_markup: replyMarkup || undefined\n });\n}\n\n// تابع جدید: حذف پیام ربات\nasync function deleteMessage(chatId: number, messageId: number) {\n return callTelegram(\"deleteMessage\", {\n chat_id: chatId,\n message_id: messageId\n });\n}\n\nasync function getChatMember(chatId: number, userId: number) {\n const res = await callTelegram(\"getChatMember\", { chat_id: chatId, user_id: userId });\n return res?.result;\n}\n\n// ==========================================\n// ۵. هندلر آپدیت‌های تلگرام\n// ==========================================\nasync function handleTelegramUpdate(update: any) {\n // الف) مدیریت دکمه‌های شیشه‌ای\n if (update.callback_query) {\n const queryData = update.callback_query;\n const { id, data, from, message } = queryData;\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\n if (!canDismiss) {\n return answerCallbackQuery(id, \"⛔️ تنها فرستنده پیام یا مدیران گروه مجاز به حذف هستند.\", true);\n }\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 // احراز دسترسی\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 // استخراج شماره اعضا\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 const excerpt = msgRecord.text.length > 80 ? msgRecord.text.substring(0, 77) + \"...\" : msgRecord.text;\n const smsText = `پیام جدید از ${msgRecord.sender_name} در [${msgRecord.chat_title}]:\\n${excerpt}`;\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 // دکمه بازگشت به منوی اصلی\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 // ۴. ذخیره برچسب\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 const isPrivate = msg.chat.type === 'private';\n\n // چت شخصی\n if (isPrivate) {\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 // ثبت کارت مخاطب\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 // تست مستقیم\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 rawText = msg.text || msg.caption || '';\n const trimmed = rawText.trim();\n\n if (!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 // ثبت فعالیت کاربر در تاپیک\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 // ذخیره در جدول ایندکس\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 msg.chat.title || \"گروه بدون نام\",\n threadId,\n msg.message_id,\n userId,\n `${msg.from.first_name || ''} ${msg.from.last_name || ''}`.trim(),\n trimmed,\n msg.photo || msg.video || msg.document ? 1 : 0\n ]);\n\n const recordId = insRes.rows[0]?.id || insRes.lastInsertRowid;\n\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\n// ==========================================\n// ۶. مدیریت APIهای پنل مدیریت مینی‌اپ\n// ==========================================\nasync function handleApiRequests(req: Request, url: URL): Promise {\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 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 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 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\n// ==========================================\n// ۷. فرانت‌اند مینی‌اپ ادمین (Glassmorphism SPA)\n// ==========================================\nfunction getMiniAppHtml(): string {\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

\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// ۸. نقطه ورود اصلی سرورلس (Entrypoint)\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(\"✅ ربات تلگرام، دیتابیس SQLite و سامانه پیامک همایس فعال و آنلاین هستند!\", {\n headers: { \"Content-Type\": \"text/plain; charset=utf-8\" }\n });\n}",[151],"647f9b12-93e6-4ad0-aba5-4a4388657c67","main.ts",1,["D",1788790482300],[160],"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",[165],"5717be8d-6265-45de-ae96-1091702caf63","config.ts","4cac036e-ab65-11f1-a335-1607ee4eb77e",6,["D",1788858699133],"// ==========================================\n// تنظیمات توکن‌ها، ادمین و همایس\n// ==========================================\nconst getEnv = (key: string, fallback = \"\") =>\n Deno.env.get(key) || (typeof process !== \"undefined\" ? process.env[key] : undefined) || fallback;\n\nexport const TELEGRAM_TOKEN = getEnv(\n \"TELEGRAM_TOKEN\",\n \"8326233308:AAGE4ooStvlfzgyv9o8-YIFZ24pVnZLC-P4\",\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\", \"823212\"),\n portalCode: getEnv(\"HOMAIS_PORTAL_CODE\", \"10003692\"),\n serverType: getEnv(\"HOMAIS_SERVER_TYPE\", \"100\"),\n};\n\nexport const TG_API = `https://api.telegram.org/bot${TELEGRAM_TOKEN}`;\nexport const SINGLE_EMOJI_REGEX = /^(\\p{Extended_Pictographic}|\\p{Emoji_Presentation})$/u;\n",[172],"pulls","branches","forks","envVars",{"_185":155,"_187":67},"connections",{"_185":67,"_186":67},"count","unfilledCount","emptyCount",{"_47":171,"_37":172,"_35":173,"_138":-5,"_45":46,"_44":174,"_139":30,"_42":210,"_13":67,"_38":39,"_40":176,"_29":30,"_141":-5,"_195":211,"_32":212},{"_47":164,"_37":165,"_35":166,"_138":-5,"_45":46,"_44":167,"_139":63,"_42":207,"_13":67,"_38":39,"_40":169,"_29":30,"_141":-5,"_195":208,"_32":209},{"_47":159,"_37":160,"_35":61,"_138":-5,"_45":46,"_44":161,"_139":30,"_42":204,"_13":67,"_38":39,"_40":57,"_29":30,"_141":49,"_195":205,"_32":206},{"_47":150,"_37":151,"_35":152,"_138":-5,"_45":46,"_44":153,"_139":30,"_42":201,"_13":155,"_38":156,"_40":157,"_29":30,"_141":-5,"_195":202,"_32":203},{"_47":143,"_37":144,"_35":145,"_138":-5,"_45":46,"_44":146,"_139":63,"_42":198,"_13":67,"_38":39,"_40":148,"_29":30,"_141":-5,"_195":199,"_32":200},{"_47":137,"_37":33,"_35":36,"_138":-5,"_45":46,"_44":14,"_139":63,"_42":194,"_13":67,"_38":39,"_40":41,"_29":30,"_141":-5,"_195":196,"_32":197},["D",1788858699291],"children",[],[33],["D",1788858699238],[],[144],["D",1788793858743],[],[151],["D",1788790482300],[],[160],["D",1788858699194],[],[165],["D",1788858699133],[],[172],["D",1788790482273],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_19":59,"_106":107,"_108":30},{"_13":90,"_37":91,"_47":46,"_92":48,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":49,"_99":100},"ctx",{"_83":-5,"_128":250,"_251":252,"_253":254,"_255":30,"_256":30,"_257":30,"_258":63,"_259":-5,"_260":-7,"_261":-7,"_262":67,"_263":30,"_264":30,"_265":-5,"_266":30,"_267":30,"_268":30,"_269":-5},"ENV",{"_221":222,"_223":224,"_225":91,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249},"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 · v9