[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_218":219,"_220":221},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",45,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","new-file-3175.ts","latestPath","fileId","f0705286-a04b-11f1-b6c3-1607ee4eb77e","name","fileType","http","content","// ============ SOZLAMALAR ============\nconst BOT_TOKEN = \"8359132225:AAHFctPD4qhP9-mlXayGxN3Y5aWRj_xZDWA\";\nconst ALLOWED_CHAT_IDS = [5359145775, 6935143094];\nconst USER_NAMES = { 5359145775: \"Sindor\", 6935143094: \"Sherik\" };\nconst isAllowed = (id) => ALLOWED_CHAT_IDS.includes(id);\nconst userName = (id) => USER_NAMES[id] || String(id);\nconst JSONBIN_ID = \"6a8349dcf5f4af5e2921141f\";\nconst JSONBIN_KEY = \"$2a$10$WxP19K2dRJrM.w5MOR0bfuBCDyG9emlsNT7COstBxpQhfCoxGhuhS\";\nconst JSONBIN_URL = `https://api.jsonbin.io/v3/b/${JSONBIN_ID}`;\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\nconst MODEL_OPTIONS = [\n \"Iphone 13pro/128\", \"Iphone 13pro/256\", \"Iphone 13promax/128\", \"Iphone 13promax/256\",\n \"Iphone 14pro/128\", \"Iphone 14pro/256\", \"Iphone 14promax/128\", \"Iphone 14promax/256\",\n \"Iphone 15pro/128\", \"Iphone 15pro/256\", \"Iphone 15promax/128\", \"Iphone 15promax/256\",\n \"Iphone 16pro/128\", \"Iphone 16pro/256\", \"Iphone 16promax/128\", \"Iphone 16promax/256\",\n \"Iphone 17pro/128\", \"Iphone 17pro/256\", \"Iphone 17promax/128\", \"Iphone 17promax/256\",\n \"Samsung S22/256\", \"Samsung S22/512\", \"Samsung S22ultra/256\", \"Samsung S22ultra/512\",\n \"Samsung S23/256\", \"Samsung S23/512\", \"Samsung S23ultra/256\", \"Samsung S23ultra/512\",\n \"Samsung S24/256\", \"Samsung S24/512\", \"Samsung S24ultra/256\", \"Samsung S24ultra/512\",\n \"Samsung S25/256\", \"Samsung S25/512\", \"Samsung S25ultra/256\", \"Samsung S25ultra/512\",\n \"Samsung S26/256\", \"Samsung S26/512\", \"Samsung S26ultra/256\", \"Samsung S26ultra/512\"\n];\n\n// ============ TELEGRAM HELPERS ============\nasync function tg(method, payload) {\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 res.json();\n}\n\nfunction sendMessage(chatId, text, extra = {}) {\n return tg(\"sendMessage\", { chat_id: chatId, text, parse_mode: \"HTML\", ...extra });\n}\n\nfunction answerCallback(id, text = \"\") {\n return tg(\"answerCallbackQuery\", { callback_query_id: id, text });\n}\n\nasync function sendDocument(chatId, filename, content, caption = \"\", mime = \"text/csv\") {\n const form = new FormData();\n form.append(\"chat_id\", String(chatId));\n form.append(\"caption\", caption);\n form.append(\"parse_mode\", \"HTML\");\n form.append(\"document\", new Blob([content], { type: mime }), filename);\n const res = await fetch(`${TG_API}/sendDocument`, { method: \"POST\", body: form });\n return res.json();\n}\n\nasync function sendPhoto(chatId, filename, bytes, caption = \"\") {\n const form = new FormData();\n form.append(\"chat_id\", String(chatId));\n form.append(\"caption\", caption);\n form.append(\"parse_mode\", \"HTML\");\n form.append(\"photo\", new Blob([bytes], { type: \"image/png\" }), filename);\n const res = await fetch(`${TG_API}/sendPhoto`, { method: \"POST\", body: form });\n return res.json();\n}\n\n// Persistent menu shown under the text input\nconst MAIN_KEYBOARD = {\n keyboard: [\n [{ text: \"➕ Qo'shish\" }, { text: \"🔍 Qidirish\" }],\n [{ text: \"📋 Ro'yxat\" }, { text: \"📦 Omborda\" }],\n [{ text: \"📊 Statistika\" }, { text: \"🏷 Sotildi\" }],\n [{ text: \"📁 Partiya\" }, { text: \"💾 Excel\" }],\n [{ text: \"✏️ Tahrirlash\" }, { text: \"🗑 O'chirish\" }],\n [{ text: \"🚚 Junatish\" }, { text: \"🔢 IMEI ro'yxat\" }],\n [{ text: \"📤 Mijozga (narxsiz)\" }],\n ],\n resize_keyboard: true,\n};\n\n// ============ STORAGE ============\nasync function loadState() {\n // JSONBin (and intermediate CDNs) can serve a cached /latest response, which made a\n // just-added phone missing from the next command. The cache-buster plus no-cache\n // headers force a fresh read every time.\n const url = `${JSONBIN_URL}/latest?_=${Date.now()}`;\n const res = await fetch(url, {\n headers: {\n \"X-Master-Key\": JSONBIN_KEY,\n \"X-Bin-Meta\": \"false\",\n \"Cache-Control\": \"no-cache, no-store, max-age=0\",\n \"Pragma\": \"no-cache\",\n },\n });\n const data = await res.json();\n // With X-Bin-Meta:false the payload is the record itself, otherwise it's under .record\n const rec = (data && data.record) ? data.record : (data || {});\n return {\n phones: Array.isArray(rec.phones) ? rec.phones : [],\n currentBatch: rec.currentBatch || 1,\n batchRates: rec.batchRates || {},\n lastRate: rec.lastRate || 1430,\n tgDraft: rec.tgDraft || {},\n };\n}\n\nasync function saveState(state) {\n // Retry a couple of times: a silently failed write was leaving newly added phones unsaved\n for (let attempt = 0; attempt < 3; attempt++) {\n try {\n const res = await fetch(JSONBIN_URL, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\", \"X-Master-Key\": JSONBIN_KEY },\n body: JSON.stringify(state),\n });\n if (res.ok) return true;\n } catch (e) {\n console.error(\"saveState attempt \" + attempt + \" failed\", e);\n }\n if (attempt < 2) await new Promise((r) => setTimeout(r, 400 * (attempt + 1)));\n }\n return false;\n}\n\n// ============ CALCULATIONS ============\nfunction rateForBatch(state, batch) {\n const v = state.batchRates[batch];\n return v && v > 0 ? v : state.lastRate || 1430;\n}\n\nfunction isSold(p) {\n return Number(p.sotildi) > 0;\n}\n\nfunction compute(state, p) {\n const r = rateForBatch(state, p.batch || 1);\n const sotibUsd = p.sotib / r;\n const opshiy = sotibUsd + (p.junat || 0);\n const foyda = isSold(p) ? p.sotildi - opshiy : 0;\n return { sotibUsd, opshiy, foyda, sold: isSold(p), rate: r };\n}\n\nconst fmtUsd = (n) => \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\nconst fmtWon = (n) => Math.round(n).toLocaleString(\"en-US\") + \"₩\";\n// Koreya sanasi (UTC+9) — tunda qo'shilgan telefon kechagi kunga yozilib qolmasligi uchun\nconst todayStr = () => new Date(Date.now() + 9 * 3600 * 1000).toISOString().slice(0, 10);\nconst genId = () => Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\n\n// ============ FORMATTING ============\nfunction phoneCard(state, p, index = null) {\n const c = compute(state, p);\n const head = index !== null ? `${index}. ` : \"\";\n const status = c.sold ? \"✅ Sotilgan\" : \"📦 Omborda\";\n return (\n `${head}${p.model}\\n` +\n `${p.imei}\\n` +\n `├ Sana: ${p.sana} · Partiya ${p.batch || 1}${p.addedBy ? \" · \" + p.addedBy : \"\"}\\n` +\n `├ Yomkost: ${p.yomkost}%\\n` +\n `├ Sotib olindi: ${fmtWon(p.sotib)} (~${fmtUsd(c.sotibUsd)})\\n` +\n `├ Junatildi: ${fmtUsd(p.junat || 0)}\\n` +\n `├ Opshiy harajat: ${fmtUsd(c.opshiy)}\\n` +\n (c.sold\n ? `├ Sotildi: ${fmtUsd(p.sotildi)}\\n└ Foyda: ${fmtUsd(c.foyda)}`\n : `└ Holat: ${status}`)\n );\n}\n\nfunction divider() {\n return \"\\n━━━━━━━━━━━━━━━━━━\\n\";\n}\n\n// ============ DRAFT HELPERS ============\nconst getDraft = (s, id) => s.tgDraft[id] || null;\nconst setDraft = (s, id, d) => { s.tgDraft[id] = d; };\nconst clearDraft = (s, id) => { delete s.tgDraft[id]; };\n\nfunction brandKeyboard() {\n return {\n inline_keyboard: [\n [\n { text: \"🍎 iPhone\", callback_data: \"brand:iphone\" },\n { text: \"📱 Samsung\", callback_data: \"brand:samsung\" },\n ],\n [{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }],\n ],\n };\n}\n\nfunction modelKeyboard(brand) {\n // Global indexes are kept in callback_data so the existing model: handler still works\n const items = MODEL_OPTIONS\n .map((m, i) => ({ m, i }))\n .filter(({ m }) =>\n brand === \"samsung\" ? m.startsWith(\"Samsung\") : m.startsWith(\"Iphone\")\n );\n\n const rows = [];\n for (let k = 0; k < items.length; k += 2) {\n const row = [{ text: items[k].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k].i}` }];\n if (items[k + 1]) {\n row.push({ text: items[k + 1].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k + 1].i}` });\n }\n rows.push(row);\n }\n rows.push([{ text: \"◀️ Orqaga\", callback_data: \"backbrand\" }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\n// ============ COMMANDS ============\nasync function cmdStart(chatId) {\n await sendMessage(\n chatId,\n \"📱 Telefon Baza\\n\\n\" +\n \"Pastdagi tugmalar orqali boshqaring:\\n\\n\" +\n \"➕ Qo'shish — yangi telefon kiritish\\n\" +\n \"🔍 Qidirish — IMEI yoki model bo'yicha\\n\" +\n \"📋 Ro'yxat — so'nggi telefonlar\\n\" +\n \"📦 Omborda — sotilmagan telefonlar\\n\" +\n \"📊 Statistika — umumiy tahlil\\n\" +\n \"🏷 Sotildi — omborda turganini sotilgan deb belgilash\\n\" +\n \"📁 Partiya — partiya holati va yakunlash\\n\" +\n \"💾 Excel — partiyani fayl qilib olish\\n\" +\n \"✏️ Tahrirlash — kiritilgan ma'lumotni tuzatish\\n\" +\n \"🗑 O'chirish — telefonni ro'yxatdan olib tashlash\\n\" +\n \"🚚 Junatish — har partiyaning junatish summasi alohida\\n\" +\n \"🔢 IMEI ro'yxat — partiyaning model + IMEI ro'yxati\\n\" +\n \"📤 Mijozga — narxsiz ro'yxat fayli (xaridorga yuborish uchun)\\n\\n\" +\n \"Har kuni 20:00 da avtomatik hisobot keladi.\\n/hisobot — hozir ko'rish\",\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\nasync function cmdAdd(state, chatId) {\n setDraft(state, chatId, { step: \"imei\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"➕ Yangi telefon\\n\\nIMEI raqamini yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function cmdSearch(state, chatId) {\n setDraft(state, chatId, { step: \"search\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"🔍 IMEI, model yoki sana yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function runSearch(state, chatId, query) {\n const q = query.trim().toLowerCase();\n const found = state.phones.filter((p) =>\n `${p.imei || \"\"} ${p.model || \"\"} ${p.sana || \"\"}`.toLowerCase().includes(q)\n );\n\n if (found.length === 0) {\n await sendMessage(chatId, `🔍 \"${query}\" bo'yicha hech narsa topilmadi.`);\n return;\n }\n\n const shown = found.slice(0, 8);\n let msg = `🔍 ${found.length} ta topildi` + (found.length > 8 ? \" (birinchi 8 tasi)\" : \"\") + divider();\n msg += shown.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n await sendMessage(chatId, msg);\n}\n\nfunction batchStats(state, items) {\n let sold = 0, profit = 0, stock = 0, cost = 0, ship = 0, buyWon = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n ship += Number(p.junat) || 0;\n buyWon += Number(p.sotib) || 0;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n return { sold, profit, stock, cost, ship, buyWon };\n}\n\nfunction batchSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `list:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📋 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `📋 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n return;\n }\n\n const t = batchStats(state, items);\n const shown = Math.min(12, items.length);\n const list = items.slice(0, shown);\n\n let msg = `📋 Partiya ${target}` + divider();\n msg += `📱 ${items.length} ta · 📦 omborda ${t.stock}\\n`;\n msg += `💵 Sotib olindi: ${fmtWon(t.buyWon)} (~${fmtUsd(t.buyWon / rateForBatch(state, target))})\\n`;\n msg += `🚚 Junatish: ${fmtUsd(t.ship)}\\n`;\n msg += `📉 Opshiy harajat: ${fmtUsd(t.cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(t.sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(t.profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, target)} ₩/$`;\n\n msg += divider();\n msg += list.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n\n if (items.length > shown) {\n msg += divider() + `...yana ${items.length - shown} ta. Hammasini 💾 Excel orqali oling.`;\n }\n\n msg += divider() + `Bazada jami: ${state.phones.length} ta`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n}\n\nasync function cmdStock(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda telefon yo'q — hammasi sotilgan! ✅\");\n return;\n }\n\n let totalCost = 0;\n stock.forEach((p) => { totalCost += compute(state, p).opshiy; });\n\n const byModel = {};\n stock.forEach((p) => { byModel[p.model] = (byModel[p.model] || 0) + 1; });\n\n let msg = `📦 Omborda: ${stock.length} ta\\n`;\n msg += `Jami tannarx: ${fmtUsd(totalCost)}` + divider();\n msg += Object.entries(byModel)\n .sort((a, b) => b[1] - a[1])\n .map(([m, n]) => `• ${m} — ${n} ta`)\n .join(\"\\n\");\n\n if (stock.length <= 6) {\n msg += divider() + stock.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n }\n await sendMessage(chatId, msg);\n}\n\nasync function cmdStats(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📊 Hali ma'lumot yo'q.\");\n return;\n }\n\n let totalProfit = 0, totalSold = 0, soldCount = 0, stockCount = 0, totalCost = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n totalCost += c.opshiy;\n if (c.sold) { totalProfit += c.foyda; totalSold += p.sotildi; soldCount++; }\n else stockCount++;\n });\n\n // Per-model analysis\n const byModel = {};\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (!byModel[p.model]) byModel[p.model] = { count: 0, sold: 0, profit: 0 };\n const g = byModel[p.model];\n g.count++;\n if (c.sold) { g.sold++; g.profit += c.foyda; }\n });\n const topModels = Object.entries(byModel)\n .map(([m, g]) => ({ model: m, ...g, avg: g.sold ? g.profit / g.sold : 0 }))\n .sort((a, b) => b.profit - a.profit)\n .slice(0, 5);\n\n // Per-batch profit\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n byBatch[b] = (byBatch[b] || 0) + compute(state, p).foyda;\n });\n\n let msg = `📊 Umumiy statistika` + divider();\n msg += `📱 Jami telefon: ${state.phones.length}\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount}\\n`;\n msg += `💰 Jami sotildi: ${fmtUsd(totalSold)}\\n`;\n msg += `💵 Jami tannarx: ${fmtUsd(totalCost)}\\n`;\n msg += `📈 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n msg += divider() + `🏆 Eng foydali modellar\\n`;\n msg += topModels\n .map((m, i) => `${i + 1}. ${m.model}\\n ${m.sold}/${m.count} sotilgan · foyda ${fmtUsd(m.profit)}`)\n .join(\"\\n\");\n\n msg += divider() + `📁 Partiya bo'yicha foyda\\n`;\n msg += Object.entries(byBatch)\n .sort((a, b) => Number(a[0]) - Number(b[0]))\n .map(([b, v]) => `Partiya ${b}: ${fmtUsd(v)}`)\n .join(\"\\n\");\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdMarkSold(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda sotilmagan telefon yo'q.\");\n return;\n }\n const rows = stock.slice(0, 20).map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `sell:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🏷 Qaysi telefon sotildi?\", { reply_markup: { inline_keyboard: rows } });\n}\n\n// Field labels shown in the edit menu, mapped to the stored property\nconst EDIT_FIELDS = [\n { key: \"imei\", label: \"IMEI\", type: \"text\" },\n { key: \"model\", label: \"Model\", type: \"model\" },\n { key: \"yomkost\", label: \"Yomkost (%)\", type: \"number\" },\n { key: \"sotib\", label: \"Sotib olindi (₩)\", type: \"number\" },\n { key: \"junat\", label: \"Junatildi ($)\", type: \"number\" },\n { key: \"sotildi\", label: \"Sotildi ($)\", type: \"number\" },\n { key: \"sana\", label: \"Sana\", type: \"text\" },\n { key: \"batch\", label: \"Partiya\", type: \"number\" },\n];\n\nasync function cmdEdit(state, chatId) {\n const last = state.phones.slice(0, 20);\n if (last.length === 0) {\n await sendMessage(chatId, \"✏️ Tahrirlash uchun telefon yo'q.\");\n return;\n }\n const rows = last.map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `edit:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"✏️ Qaysi telefonni tahrirlaysiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nfunction editFieldKeyboard(id) {\n const rows = [];\n for (let i = 0; i < EDIT_FIELDS.length; i += 2) {\n const row = [{ text: EDIT_FIELDS[i].label, callback_data: `ef:${id}:${EDIT_FIELDS[i].key}` }];\n if (EDIT_FIELDS[i + 1]) row.push({ text: EDIT_FIELDS[i + 1].label, callback_data: `ef:${id}:${EDIT_FIELDS[i + 1].key}` });\n rows.push(row);\n }\n rows.push([{ text: \"✖️ Yopish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\nasync function cmdBatch(state, chatId) {\n const items = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let sold = 0, profit = 0, stock = 0, cost = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n\n let msg = `📁 Joriy partiya: ${state.currentBatch}` + divider();\n msg += `📱 Telefon: ${items.length} ta\\n`;\n msg += `📦 Omborda: ${stock} ta\\n`;\n msg += `💵 Tannarx: ${fmtUsd(cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, state.currentBatch)} ₩/$`;\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [{ text: \"✅ Partiyani yakunlash\", callback_data: \"closebatch\" }],\n [{ text: \"💱 Kursni o'zgartirish\", callback_data: \"setrate\" }],\n ],\n },\n });\n}\n\nasync function cmdImeiList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🔢 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `🔢 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: imeiSelectorRows(state, target) },\n });\n return;\n }\n\n // Plain lines so the whole block can be copied in one go\n const lines = items.map((p) => `${p.model} ${p.imei}`);\n\n let msg = `🔢 Partiya ${target} — IMEI ro'yxati\\n`;\n msg += `${items.length} ta` + divider();\n msg += `${lines.join(\"\\n\")}`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: imeiSelectorRows(state, target) },\n });\n}\n\nfunction imeiSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `imei:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdShipping(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🚚 Hali ma'lumot yo'q.\");\n return;\n }\n\n // Group shipping cost by batch so each batch is accounted for on its own\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) byBatch[b] = { count: 0, junat: 0, sold: 0, stock: 0 };\n const g = byBatch[b];\n g.count++;\n g.junat += Number(p.junat) || 0;\n if (isSold(p)) g.sold++; else g.stock++;\n });\n\n const rows = Object.entries(byBatch)\n .map(([b, g]) => ({ batch: Number(b), ...g }))\n .sort((a, b) => b.batch - a.batch);\n\n const grandTotal = rows.reduce((s, r) => s + r.junat, 0);\n const grandCount = rows.reduce((s, r) => s + r.count, 0);\n\n let msg = `🚚 Junatish xarajatlari` + divider();\n\n msg += rows\n .map((r) => {\n const avg = r.count ? r.junat / r.count : 0;\n const mark = r.batch === state.currentBatch ? \" 🔹\" : \"\";\n return (\n `Partiya ${r.batch}${mark}\\n` +\n `├ Telefon: ${r.count} ta\\n` +\n `├ O'rtacha: ${fmtUsd(avg)} / dona\\n` +\n `└ Jami junatish: ${fmtUsd(r.junat)}`\n );\n })\n .join(\"\\n\\n\");\n\n msg += divider();\n msg += `UMUMIY\\n`;\n msg += `${rows.length} ta partiya · ${grandCount} ta telefon\\n`;\n msg += `Jami junatish: ${fmtUsd(grandTotal)}`;\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdExport(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n if (batches.length === 0) {\n await sendMessage(chatId, \"💾 Eksport uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `csv:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"csv:all\" }]);\n await sendMessage(chatId, \"💾 Qaysi partiyani yuklab olasiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nasync function cmdExportClient(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n if (batches.length === 0) {\n await sendMessage(chatId, \"📤 Eksport uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `ccsv:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"ccsv:all\" }]);\n await sendMessage(\n chatId,\n \"📤 Mijozga yuborish uchun fayl\\n\\n\" +\n \"Faqat sana, IMEI, model va yomkost bo'ladi.\\nNarx, foyda va kurs ko'rinmaydi.\\n\\n\" +\n \"Qaysi partiya?\",\n { reply_markup: { inline_keyboard: rows } }\n );\n}\n\n// ============ EKSPORT MA'LUMOTLARI ============\nfunction exportItems(state, which) {\n return which === \"all\"\n ? state.phones\n : state.phones.filter((p) => String(p.batch || 1) === String(which));\n}\n\nfunction exportTitle(which, count) {\n return `${which === \"all\" ? \"Hammasi\" : \"Partiya \" + which} — ${count} ta telefon`;\n}\n\n// To'liq jadval — narx, foyda va kurs bilan (faqat o'zingiz uchun)\nfunction fullTable(state, which) {\n const items = exportItems(state, which);\n return {\n title: exportTitle(which, items.length),\n headers: [\"Sana\", \"Imei\", \"Model\", \"Yomkost(%)\", \"Sotib olindi(W)\", \"Sotib olindi($)\",\n \"Junatildi($)\", \"Opshiy($)\", \"Sotildi($)\", \"Foyda($)\", \"Kurs\", \"Holat\"],\n rows: items.map((p) => {\n const c = compute(state, p);\n return [\n p.sana, p.imei, p.model, p.yomkost, p.sotib,\n c.sotibUsd.toFixed(2), (p.junat || 0).toFixed(2), c.opshiy.toFixed(2),\n c.sold ? p.sotildi.toFixed(2) : \"\", c.sold ? c.foyda.toFixed(2) : \"\",\n c.rate, c.sold ? \"Sotilgan\" : \"Omborda\",\n ];\n }),\n };\n}\n\n// Mijozga yuboriladigan jadval — narxsiz\nfunction clientTable(state, which) {\n const items = exportItems(state, which);\n return {\n title: exportTitle(which, items.length),\n headers: [\"Sana\", \"Imei\", \"Model\", \"Yomkost(%)\"],\n rows: items.map((p) => [p.sana, p.imei, p.model, p.yomkost]),\n };\n}\n\nfunction formatKeyboard(kind, which) {\n return {\n inline_keyboard: [\n [\n { text: \"📊 Excel\", callback_data: `dl:${kind}:${which}:csv` },\n { text: \"📄 PDF\", callback_data: `dl:${kind}:${which}:pdf` },\n ],\n [{ text: \"🖼 Rasm\", callback_data: `dl:${kind}:${which}:png` }],\n ],\n };\n}\n\n// ============ JADVALNI TURLI FORMATLARDA CHIQARISH ============\n// Har bir eksport {title, headers, rows} ko'rinishida tayyorlanadi,\n// so'ng quyidagi uchta funksiya uni CSV / PDF / PNG ga aylantiradi.\n\nfunction tableToCsv(table) {\n const esc = (v) => {\n const s = String(v ?? \"\");\n return /[\",\\n]/.test(s) ? '\"' + s.replace(/\"/g, '\"\"') + '\"' : s;\n };\n const lines = [table.headers.map(esc).join(\",\")];\n table.rows.forEach((r) => lines.push(r.map(esc).join(\",\")));\n return \"\\uFEFF\" + lines.join(\"\\r\\n\");\n}\n\nasync function tableToPdf(table) {\n const { PDFDocument, StandardFonts, rgb } = await import(\"https://esm.sh/pdf-lib@1.17.1\");\n\n const doc = await PDFDocument.create();\n const font = await doc.embedFont(StandardFonts.Helvetica);\n const bold = await doc.embedFont(StandardFonts.HelveticaBold);\n\n const pageW = 842, pageH = 595; // A4 yotiq\n const margin = 32;\n const cols = table.headers.length;\n const usableW = pageW - margin * 2;\n\n // Ustun kengliklari — matn uzunligiga qarab taqsimlanadi\n const weights = table.headers.map((h, i) => {\n let maxLen = String(h).length;\n table.rows.forEach((r) => { maxLen = Math.max(maxLen, String(r[i] ?? \"\").length); });\n return maxLen;\n });\n const totalW = weights.reduce((a, b) => a + b, 0) || 1;\n const colW = weights.map((w) => (w / totalW) * usableW);\n\n const rowH = 22, headH = 26, titleH = 40;\n let page = null, y = 0;\n\n const newPage = () => {\n page = doc.addPage([pageW, pageH]);\n y = pageH - margin;\n page.drawText(table.title, { x: margin, y: y - 18, size: 15, font: bold, color: rgb(0.12, 0.11, 0.25) });\n y -= titleH;\n // sarlavha qatori\n page.drawRectangle({ x: margin, y: y - headH, width: usableW, height: headH, color: rgb(0.31, 0.27, 0.9) });\n let x = margin;\n table.headers.forEach((h, i) => {\n page.drawText(String(h), { x: x + 6, y: y - headH + 8, size: 9, font: bold, color: rgb(1, 1, 1) });\n x += colW[i];\n });\n y -= headH;\n };\n\n newPage();\n\n table.rows.forEach((r, idx) => {\n if (y - rowH < margin) newPage();\n if (idx % 2 === 1) {\n page.drawRectangle({ x: margin, y: y - rowH, width: usableW, height: rowH, color: rgb(0.96, 0.96, 0.99) });\n }\n let x = margin;\n r.forEach((cell, i) => {\n page.drawText(String(cell ?? \"\"), { x: x + 6, y: y - rowH + 7, size: 9, font, color: rgb(0.1, 0.1, 0.18) });\n x += colW[i];\n });\n page.drawLine({\n start: { x: margin, y: y - rowH },\n end: { x: margin + usableW, y: y - rowH },\n thickness: 0.5, color: rgb(0.85, 0.85, 0.92),\n });\n y -= rowH;\n });\n\n return await doc.save();\n}\n\nfunction tableToSvg(table) {\n const pad = 24, rowH = 34, headH = 40, titleH = 48;\n const cols = table.headers.length;\n\n const weights = table.headers.map((h, i) => {\n let maxLen = String(h).length;\n table.rows.forEach((r) => { maxLen = Math.max(maxLen, String(r[i] ?? \"\").length); });\n return Math.max(6, maxLen);\n });\n const colW = weights.map((w) => w * 9 + 24);\n const tableW = colW.reduce((a, b) => a + b, 0);\n const W = tableW + pad * 2;\n const H = titleH + headH + table.rows.length * rowH + pad * 2;\n\n const esc = (s) => String(s ?? \"\")\n .replace(/&/g, \"&\").replace(//g, \">\");\n\n let svg = ``;\n return svg;\n}\n\n// resvg wasm va shrift bir marta yuklanadi, keyin qayta ishlatiladi\nlet _resvgReady = null;\nlet _fontBuf = null;\n\nasync function initResvg() {\n if (_resvgReady) return _resvgReady;\n _resvgReady = (async () => {\n const mod = await import(\"https://esm.sh/@resvg/resvg-wasm@2.6.2\");\n await mod.initWasm(fetch(\"https://unpkg.com/@resvg/resvg-wasm@2.6.2/index_bg.wasm\"));\n // resvg'da tizim shriftlari yo'q — shriftni o'zimiz yuklaymiz\n const fr = await fetch(\"https://cdn.jsdelivr.net/npm/dejavu-fonts-ttf@2.37.3/ttf/DejaVuSans.ttf\");\n _fontBuf = new Uint8Array(await fr.arrayBuffer());\n return mod;\n })();\n return _resvgReady;\n}\n\nasync function tableToPng(table) {\n const mod = await initResvg();\n const svg = tableToSvg(table);\n const r = new mod.Resvg(svg, {\n font: { fontBuffers: [_fontBuf], defaultFontFamily: \"DejaVu Sans\" },\n fitTo: { mode: \"width\", value: Math.min(1600, Math.max(700, table.headers.length * 190)) },\n });\n return r.render().asPng();\n}\n\n// ============ DRAFT FLOW ============\nasync function handleDraftText(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\n // Search flow\n if (draft.step === \"search\") {\n clearDraft(state, chatId);\n await saveState(state);\n await runSearch(state, chatId, text);\n return true;\n }\n\n // Applying a new value to a field being edited\n if (draft.step === \"editvalue\") {\n const { id, field } = draft.data;\n const idx = state.phones.findIndex((p) => p.id === id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n let value;\n if (meta.type === \"number\") {\n value = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(value)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n } else {\n value = text.trim();\n if (!value) { await sendMessage(chatId, \"❌ Bo'sh bo'lmasin:\"); return true; }\n }\n\n state.phones[idx][field] = value;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(\n chatId,\n `✅ ${meta.label} yangilandi.` + divider() + phoneCard(state, state.phones[idx]),\n { reply_markup: editFieldKeyboard(id) }\n );\n return true;\n }\n\n // Setting a sale price for an existing stock phone\n if (draft.step === \"sellprice\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 480):\"); return true; }\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n state.phones[idx].sotildi = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Sotildi deb belgilandi!\\n\\n` + phoneCard(state, state.phones[idx]));\n return true;\n }\n\n // Changing the current batch rate\n if (draft.step === \"rate\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Kursni raqam bilan kiriting (masalan: 1430):\"); return true; }\n state.batchRates[state.currentBatch] = v;\n state.lastRate = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Partiya ${state.currentBatch} kursi ${v} ₩/$ qilib belgilandi.`);\n return true;\n }\n\n // --- Add-phone flow ---\n if (draft.step === \"imei\") {\n const imei = text.trim();\n if (!imei) { await sendMessage(chatId, \"❌ IMEI bo'sh bo'lmasin. Qayta yuboring:\"); return true; }\n const dup = state.phones.find((p) => (p.imei || \"\").trim() === imei);\n draft.data.imei = imei;\n draft.step = \"model\";\n setDraft(state, chatId, draft);\n await saveState(state);\n const warn = dup\n ? `⚠️ Diqqat: bu IMEI allaqachon bor\\n(${dup.model}, Partiya ${dup.batch || 1}, ${dup.sana})\\n\\n`\n : \"\";\n await sendMessage(chatId, warn + \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return true;\n }\n\n if (draft.step === \"yomkost\") {\n const v = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 85):\"); return true; }\n draft.data.yomkost = v;\n draft.step = \"sotib\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"💵 Sotib olindi narxi (₩):\");\n return true;\n }\n\n if (draft.step === \"sotib\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.sotib = v;\n draft.step = \"junat\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🚚 Junatildi narxi ($):\");\n return true;\n }\n\n if (draft.step === \"junat\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.junat = v;\n draft.step = \"sotildi\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🏷 Sotildi narxi ($):\\n\\nHali sotilmagan bo'lsa — 0 yuboring yoki tugmani bosing.\", {\n reply_markup: { inline_keyboard: [[{ text: \"📦 Hali sotilmagan\", callback_data: \"notsold\" }]] },\n });\n return true;\n }\n\n if (draft.step === \"sotildi\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (yoki 0):\"); return true; }\n await finalizeAdd(state, chatId, v);\n return true;\n }\n\n return false;\n}\n\nasync function finalizeAdd(state, chatId, sotildi) {\n const draft = getDraft(state, chatId);\n if (!draft) return;\n const p = {\n id: genId(),\n sana: todayStr(),\n imei: draft.data.imei,\n model: draft.data.model,\n yomkost: draft.data.yomkost,\n sotib: draft.data.sotib,\n junat: draft.data.junat,\n sotildi: sotildi,\n batch: state.currentBatch,\n addedBy: userName(chatId),\n };\n state.phones.unshift(p);\n clearDraft(state, chatId);\n const ok = await saveState(state);\n\n if (!ok) {\n await sendMessage(\n chatId,\n \"⚠️ Saqlanmadi!\\n\\nInternet yoki server muammosi bo'lishi mumkin. \" +\n \"Iltimos, telefonni qaytadan qo'shib ko'ring.\",\n { reply_markup: MAIN_KEYBOARD }\n );\n return;\n }\n\n const batchCount = state.phones.filter((x) => (x.batch || 1) === state.currentBatch).length;\n await sendMessage(\n chatId,\n \"✅ Qo'shildi!\" + divider() + phoneCard(state, p) + divider() +\n `Bazada jami: ${state.phones.length} ta · Partiya ${state.currentBatch}: ${batchCount} ta`,\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\n// ============ CALLBACKS ============\nasync function handleCallback(state, chatId, data, cbId) {\n if (data === \"cancel\") {\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, \"Bekor qilindi\");\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n return;\n }\n\n if (data.startsWith(\"imei:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdImeiList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"list:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"brand:\")) {\n const brand = data.split(\":\")[1];\n const draft = getDraft(state, chatId);\n if (!draft || (draft.step !== \"model\" && draft.step !== \"editmodel\")) {\n await answerCallback(cbId, \"Bu amal eskirgan\");\n return;\n }\n await answerCallback(cbId, brand === \"samsung\" ? \"Samsung\" : \"iPhone\");\n await sendMessage(chatId, \"📱 Modelni tanlang:\", { reply_markup: modelKeyboard(brand) });\n return;\n }\n\n if (data === \"backbrand\") {\n await answerCallback(cbId, \"\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n if (data.startsWith(\"model:\")) {\n const model = MODEL_OPTIONS[parseInt(data.split(\":\")[1])];\n const draft = getDraft(state, chatId);\n\n // Same picker is reused when editing an existing phone's model\n if (draft && draft.step === \"editmodel\") {\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx !== -1) state.phones[idx].model = model;\n const id = draft.data.id;\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `✅ Model ${model} qilib o'zgartirildi.` + divider() + phoneCard(state, state.phones[idx]), {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (!draft || draft.step !== \"model\") { await answerCallback(cbId, \"Bu amal eskirgan\"); return; }\n draft.data.model = model;\n draft.step = \"yomkost\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `📱 Model: ${model}\\n\\n🔋 Yomkost foizi:`);\n return;\n }\n\n if (data === \"notsold\") {\n await answerCallback(cbId, \"Omborda deb belgilandi\");\n await finalizeAdd(state, chatId, 0);\n return;\n }\n\n if (data.startsWith(\"edit:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Maydonni tanlang\");\n await sendMessage(chatId, \"✏️ Tahrirlash\" + divider() + phoneCard(state, p) + \"\\n\\nQaysi maydonni o'zgartirasiz?\", {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (data.startsWith(\"ef:\")) {\n const [, id, field] = data.split(\":\");\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n\n if (meta.type === \"model\") {\n setDraft(state, chatId, { step: \"editmodel\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Model tanlang\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n setDraft(state, chatId, { step: \"editvalue\", data: { id, field } });\n await saveState(state);\n await answerCallback(cbId, meta.label);\n await sendMessage(chatId, `✏️ ${meta.label}\\n\\nHozirgi qiymat: ${p[field] ?? \"—\"}\\n\\nYangi qiymatni yuboring:`);\n return;\n }\n\n if (data.startsWith(\"sell:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n setDraft(state, chatId, { step: \"sellprice\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Narxni kiriting\");\n await sendMessage(chatId, `🏷 ${p.model}\\n${p.imei}\\n\\nSotuv narxini kiriting ($):`);\n return;\n }\n\n if (data.startsWith(\"del:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Tasdiqlang\");\n await sendMessage(chatId, `🗑 ${p.model}\\n${p.imei}\\n\\nO'chirilsinmi?`, {\n reply_markup: {\n inline_keyboard: [[\n { text: \"✅ Ha, o'chirish\", callback_data: `delyes:${id}` },\n { text: \"✖️ Bekor\", callback_data: \"cancel\" },\n ]],\n },\n });\n return;\n }\n\n if (data.startsWith(\"delyes:\")) {\n const id = data.split(\":\")[1];\n const idx = state.phones.findIndex((x) => x.id === id);\n if (idx !== -1) {\n const removed = state.phones[idx];\n state.phones.splice(idx, 1);\n await saveState(state);\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(chatId, `🗑 O'chirildi: ${removed.model} (${removed.imei})`);\n } else await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n\n if (data === \"closebatch\") {\n state.currentBatch = (state.currentBatch || 1) + 1;\n await saveState(state);\n await answerCallback(cbId, \"Yakunlandi\");\n await sendMessage(chatId, `✅ Partiya yakunlandi.\\n\\n📁 Yangi joriy partiya: ${state.currentBatch}`);\n return;\n }\n\n if (data === \"setrate\") {\n setDraft(state, chatId, { step: \"rate\", data: {} });\n await saveState(state);\n await answerCallback(cbId, \"Kursni kiriting\");\n await sendMessage(chatId, `💱 Partiya ${state.currentBatch} uchun yangi kursni kiriting (₩/$):`);\n return;\n }\n\n // Mijozga: partiya tanlangach format so'raladi\n if (data.startsWith(\"ccsv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"📤 Qaysi formatda?\", { reply_markup: formatKeyboard(\"cli\", which) });\n return;\n }\n\n // To'liq eksport: partiya tanlangach format so'raladi\n if (data.startsWith(\"csv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"💾 Qaysi formatda?\", { reply_markup: formatKeyboard(\"full\", which) });\n return;\n }\n\n // Yagona yuklab olish nuqtasi: dl:{kind}:{which}:{format}\n if (data.startsWith(\"dl:\")) {\n const [, kind, which, fmt] = data.split(\":\");\n const table = kind === \"cli\" ? clientTable(state, which) : fullTable(state, which);\n if (table.rows.length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n\n await answerCallback(cbId, \"Tayyorlanmoqda...\");\n\n const base = which === \"all\" ? \"telefonlar\" : `partiya-${which}`;\n const suffix = kind === \"cli\" ? \"-royxat\" : \"\";\n const caption = table.title;\n\n try {\n if (fmt === \"csv\") {\n await sendDocument(chatId, `${base}${suffix}.csv`, tableToCsv(table), caption, \"text/csv\");\n } else if (fmt === \"pdf\") {\n const bytes = await tableToPdf(table);\n await sendDocument(chatId, `${base}${suffix}.pdf`, bytes, caption, \"application/pdf\");\n } else if (fmt === \"png\") {\n const bytes = await tableToPng(table);\n await sendPhoto(chatId, `${base}${suffix}.png`, bytes, caption);\n }\n } catch (e) {\n console.error(\"eksport xatosi\", fmt, e);\n await sendMessage(\n chatId,\n `⚠️ ${fmt.toUpperCase()} tayyorlashda xatolik bo'ldi.\\nExcel yoki PDF formatini sinab ko'ring.`\n );\n }\n return;\n }\n\n await answerCallback(cbId);\n}\n\n// ============ DAILY REPORT ============\n// Exported separately so a Val Town Cron trigger can call it on a schedule.\nexport async function dailyReport() {\n const state = await loadState();\n const today = todayStr();\n\n const addedToday = state.phones.filter((p) => p.sana === today);\n\n let totalProfit = 0, stockCount = 0, stockCost = 0, soldCount = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) { totalProfit += c.foyda; soldCount++; }\n else { stockCount++; stockCost += c.opshiy; }\n });\n\n // Current batch snapshot\n const batchItems = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let batchProfit = 0, batchStock = 0;\n batchItems.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) batchProfit += c.foyda; else batchStock++;\n });\n\n let msg = `🌙 Kunlik hisobot\\n${today}` + divider();\n\n if (addedToday.length > 0) {\n let todayProfit = 0;\n addedToday.forEach((p) => { todayProfit += compute(state, p).foyda; });\n msg += `📥 Bugun qo'shildi: ${addedToday.length} ta\\n`;\n msg += `📈 Bugungi foyda: ${fmtUsd(todayProfit)}\\n`;\n msg += addedToday.slice(0, 5).map((p) => ` • ${p.model}`).join(\"\\n\");\n if (addedToday.length > 5) msg += `\\n • ...yana ${addedToday.length - 5} ta`;\n } else {\n msg += `📥 Bugun yangi telefon qo'shilmadi.`;\n }\n\n msg += divider();\n msg += `📁 Partiya ${state.currentBatch}\\n`;\n msg += ` ${batchItems.length} ta · omborda ${batchStock} · foyda ${fmtUsd(batchProfit)}`;\n\n msg += divider();\n msg += `Umumiy holat\\n`;\n msg += `📱 Jami: ${state.phones.length} ta\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount} ta (${fmtUsd(stockCost)})\\n`;\n msg += `💰 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n // Phones sitting in stock for a long time are dead capital worth flagging\n const now = new Date();\n const stale = state.phones.filter((p) => {\n if (isSold(p)) return false;\n const d = new Date(p.sana);\n if (isNaN(d.getTime())) return false;\n return (now - d) / 86400000 > 60;\n });\n if (stale.length > 0) {\n msg += divider();\n msg += `⚠️ 60 kundan ko'p omborda: ${stale.length} ta\\n`;\n msg += stale.slice(0, 5).map((p) => ` • ${p.model} — ${p.sana}`).join(\"\\n\");\n }\n\n for (const id of ALLOWED_CHAT_IDS) {\n try { await sendMessage(id, msg); } catch (e) { console.error(\"report failed for\", id, e); }\n }\n\n return new Response(\"report sent\");\n}\n\n// ============ ENTRY POINT ============\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"Telefon baza boti ishlayapti.\", { status: 200 });\n }\n\n let update;\n try { update = await req.json(); } catch { return new Response(\"ok\"); }\n\n try {\n if (update.message) {\n const msg = update.message;\n const chatId = msg.chat.id;\n\n if (!isAllowed(chatId)) {\n await sendMessage(chatId, \"⛔️ Bu bot faqat ruxsat berilgan foydalanuvchilar uchun.\");\n return new Response(\"ok\");\n }\n\n const text = (msg.text || \"\").trim();\n const state = await loadState();\n\n // Menu buttons and slash commands both map to the same actions\n if (text === \"/start\" || text === \"/menu\") await cmdStart(chatId);\n else if (text === \"/qoshish\" || text === \"➕ Qo'shish\") await cmdAdd(state, chatId);\n else if (text === \"/qidirish\" || text === \"🔍 Qidirish\") await cmdSearch(state, chatId);\n else if (text === \"/royxat\" || text === \"📋 Ro'yxat\") await cmdList(state, chatId);\n else if (text === \"/omborda\" || text === \"📦 Omborda\") await cmdStock(state, chatId);\n else if (text === \"/statistika\" || text === \"📊 Statistika\") await cmdStats(state, chatId);\n else if (text === \"/sotildi\" || text === \"🏷 Sotildi\") await cmdMarkSold(state, chatId);\n else if (text === \"/partiya\" || text === \"📁 Partiya\") await cmdBatch(state, chatId);\n else if (text === \"/excel\" || text === \"💾 Excel\") await cmdExport(state, chatId);\n else if (text === \"/junatish\" || text === \"🚚 Junatish\") await cmdShipping(state, chatId);\n else if (text === \"/imei\" || text === \"🔢 IMEI ro'yxat\") await cmdImeiList(state, chatId);\n else if (text === \"/mijoz\" || text === \"📤 Mijozga (narxsiz)\") await cmdExportClient(state, chatId);\n else if (text === \"/tahrirlash\" || text === \"✏️ Tahrirlash\") await cmdEdit(state, chatId);\n else if (text === \"/hisobot\") await dailyReport();\n else if (text === \"/ochirish\" || text === \"🗑 O'chirish\") {\n const last = state.phones.slice(0, 15);\n if (last.length === 0) await sendMessage(chatId, \"Ro'yxat bo'sh.\");\n else {\n const rows = last.map((p) => [{ text: `${p.model} — ${p.imei}`, callback_data: `del:${p.id}` }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🗑 O'chiriladigan telefonni tanlang:\", { reply_markup: { inline_keyboard: rows } });\n }\n }\n else if (text === \"/bekor\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n }\n else {\n const handled = await handleDraftText(state, chatId, text);\n if (!handled) {\n // Anything else is treated as a quick search — fastest path when checking a phone\n await runSearch(state, chatId, text);\n }\n }\n } else if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n if (!isAllowed(chatId)) { await answerCallback(cq.id, \"Ruxsat yo'q\"); return new Response(\"ok\"); }\n const state = await loadState();\n await handleCallback(state, chatId, cq.data, cq.id);\n }\n } catch (err) {\n console.error(err);\n }\n\n return new Response(\"ok\");\n}","// ============ SOZLAMALAR ============\nconst BOT_TOKEN = \"8359132225:AAHFctPD4qhP9-mlXayGxN3Y5aWRj_xZDWA\";\nconst ALLOWED_CHAT_IDS = [5359145775, 6935143094];\nconst USER_NAMES = { 5359145775: \"Sindor\", 6935143094: \"Sherik\" };\nconst isAllowed = (id) => ALLOWED_CHAT_IDS.includes(id);\nconst userName = (id) => USER_NAMES[id] || String(id);\nconst JSONBIN_ID = \"6a8349dcf5f4af5e2921141f\";\nconst JSONBIN_KEY = \"$2a$10$WxP19K2dRJrM.w5MOR0bfuBCDyG9emlsNT7COstBxpQhfCoxGhuhS\";\nconst JSONBIN_URL = `https://api.jsonbin.io/v3/b/${JSONBIN_ID}`;\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\nconst MODEL_OPTIONS = [\n \"Iphone 13pro/128\", \"Iphone 13pro/256\", \"Iphone 13promax/128\", \"Iphone 13promax/256\",\n \"Iphone 14pro/128\", \"Iphone 14pro/256\", \"Iphone 14promax/128\", \"Iphone 14promax/256\",\n \"Iphone 15pro/128\", \"Iphone 15pro/256\", \"Iphone 15promax/128\", \"Iphone 15promax/256\",\n \"Iphone 16pro/128\", \"Iphone 16pro/256\", \"Iphone 16promax/128\", \"Iphone 16promax/256\",\n \"Iphone 17pro/128\", \"Iphone 17pro/256\", \"Iphone 17promax/128\", \"Iphone 17promax/256\",\n \"Samsung S22/256\", \"Samsung S22/512\", \"Samsung S22ultra/256\", \"Samsung S22ultra/512\",\n \"Samsung S23/256\", \"Samsung S23/512\", \"Samsung S23ultra/256\", \"Samsung S23ultra/512\",\n \"Samsung S24/256\", \"Samsung S24/512\", \"Samsung S24ultra/256\", \"Samsung S24ultra/512\",\n \"Samsung S25/256\", \"Samsung S25/512\", \"Samsung S25ultra/256\", \"Samsung S25ultra/512\",\n \"Samsung S26/256\", \"Samsung S26/512\", \"Samsung S26ultra/256\", \"Samsung S26ultra/512\"\n];\n\n// ============ TELEGRAM HELPERS ============\nasync function tg(method, payload) {\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 res.json();\n}\n\nfunction sendMessage(chatId, text, extra = {}) {\n return tg(\"sendMessage\", { chat_id: chatId, text, parse_mode: \"HTML\", ...extra });\n}\n\nfunction answerCallback(id, text = \"\") {\n return tg(\"answerCallbackQuery\", { callback_query_id: id, text });\n}\n\nasync function sendDocument(chatId, filename, content, caption = \"\", mime = \"text/csv\") {\n const form = new FormData();\n form.append(\"chat_id\", String(chatId));\n form.append(\"caption\", caption);\n form.append(\"parse_mode\", \"HTML\");\n form.append(\"document\", new Blob([content], { type: mime }), filename);\n const res = await fetch(`${TG_API}/sendDocument`, { method: \"POST\", body: form });\n return res.json();\n}\n\nasync function sendPhoto(chatId, filename, bytes, caption = \"\") {\n const form = new FormData();\n form.append(\"chat_id\", String(chatId));\n form.append(\"caption\", caption);\n form.append(\"parse_mode\", \"HTML\");\n form.append(\"photo\", new Blob([bytes], { type: \"image/png\" }), filename);\n const res = await fetch(`${TG_API}/sendPhoto`, { method: \"POST\", body: form });\n return res.json();\n}\n\n// Persistent menu shown under the text input\nconst MAIN_KEYBOARD = {\n keyboard: [\n [{ text: \"➕ Qo'shish\" }, { text: \"🔍 Qidirish\" }],\n [{ text: \"📋 Ro'yxat\" }, { text: \"📦 Omborda\" }],\n [{ text: \"📊 Statistika\" }, { text: \"🏷 Sotildi\" }],\n [{ text: \"📁 Partiya\" }, { text: \"💾 Excel\" }],\n [{ text: \"✏️ Tahrirlash\" }, { text: \"🗑 O'chirish\" }],\n [{ text: \"🚚 Junatish\" }, { text: \"🔢 IMEI ro'yxat\" }],\n [{ text: \"📤 Mijozga (narxsiz)\" }],\n ],\n resize_keyboard: true,\n};\n\n// ============ STORAGE ============\nasync function loadState() {\n // JSONBin (and intermediate CDNs) can serve a cached /latest response, which made a\n // just-added phone missing from the next command. The cache-buster plus no-cache\n // headers force a fresh read every time.\n const url = `${JSONBIN_URL}/latest?_=${Date.now()}`;\n const res = await fetch(url, {\n headers: {\n \"X-Master-Key\": JSONBIN_KEY,\n \"X-Bin-Meta\": \"false\",\n \"Cache-Control\": \"no-cache, no-store, max-age=0\",\n \"Pragma\": \"no-cache\",\n },\n });\n const data = await res.json();\n // With X-Bin-Meta:false the payload is the record itself, otherwise it's under .record\n const rec = (data && data.record) ? data.record : (data || {});\n return {\n phones: Array.isArray(rec.phones) ? rec.phones : [],\n currentBatch: rec.currentBatch || 1,\n batchRates: rec.batchRates || {},\n lastRate: rec.lastRate || 1430,\n tgDraft: rec.tgDraft || {},\n };\n}\n\nasync function saveState(state) {\n // Retry a couple of times: a silently failed write was leaving newly added phones unsaved\n for (let attempt = 0; attempt < 3; attempt++) {\n try {\n const res = await fetch(JSONBIN_URL, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\", \"X-Master-Key\": JSONBIN_KEY },\n body: JSON.stringify(state),\n });\n if (res.ok) return true;\n } catch (e) {\n console.error(\"saveState attempt \" + attempt + \" failed\", e);\n }\n if (attempt < 2) await new Promise((r) => setTimeout(r, 400 * (attempt + 1)));\n }\n return false;\n}\n\n// ============ CALCULATIONS ============\nfunction rateForBatch(state, batch) {\n const v = state.batchRates[batch];\n return v && v > 0 ? v : state.lastRate || 1430;\n}\n\nfunction isSold(p) {\n return Number(p.sotildi) > 0;\n}\n\nfunction compute(state, p) {\n const r = rateForBatch(state, p.batch || 1);\n const sotibUsd = p.sotib / r;\n const opshiy = sotibUsd + (p.junat || 0);\n const foyda = isSold(p) ? p.sotildi - opshiy : 0;\n return { sotibUsd, opshiy, foyda, sold: isSold(p), rate: r };\n}\n\nconst fmtUsd = (n) => \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\nconst fmtWon = (n) => Math.round(n).toLocaleString(\"en-US\") + \"₩\";\n// Koreya sanasi (UTC+9) — tunda qo'shilgan telefon kechagi kunga yozilib qolmasligi uchun\nconst todayStr = () => new Date(Date.now() + 9 * 3600 * 1000).toISOString().slice(0, 10);\nconst genId = () => Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\n\n// ============ FORMATTING ============\nfunction phoneCard(state, p, index = null) {\n const c = compute(state, p);\n const head = index !== null ? `${index}. ` : \"\";\n const status = c.sold ? \"✅ Sotilgan\" : \"📦 Omborda\";\n return (\n `${head}${p.model}\\n` +\n `${p.imei}\\n` +\n `├ Sana: ${p.sana} · Partiya ${p.batch || 1}${p.addedBy ? \" · \" + p.addedBy : \"\"}\\n` +\n `├ Yomkost: ${p.yomkost}%\\n` +\n `├ Sotib olindi: ${fmtWon(p.sotib)} (~${fmtUsd(c.sotibUsd)})\\n` +\n `├ Junatildi: ${fmtUsd(p.junat || 0)}\\n` +\n `├ Opshiy harajat: ${fmtUsd(c.opshiy)}\\n` +\n (c.sold\n ? `├ Sotildi: ${fmtUsd(p.sotildi)}\\n└ Foyda: ${fmtUsd(c.foyda)}`\n : `└ Holat: ${status}`)\n );\n}\n\nfunction divider() {\n return \"\\n━━━━━━━━━━━━━━━━━━\\n\";\n}\n\n// ============ DRAFT HELPERS ============\nconst getDraft = (s, id) => s.tgDraft[id] || null;\nconst setDraft = (s, id, d) => { s.tgDraft[id] = d; };\nconst clearDraft = (s, id) => { delete s.tgDraft[id]; };\n\nfunction brandKeyboard() {\n return {\n inline_keyboard: [\n [\n { text: \"🍎 iPhone\", callback_data: \"brand:iphone\" },\n { text: \"📱 Samsung\", callback_data: \"brand:samsung\" },\n ],\n [{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }],\n ],\n };\n}\n\nfunction modelKeyboard(brand) {\n // Global indexes are kept in callback_data so the existing model: handler still works\n const items = MODEL_OPTIONS\n .map((m, i) => ({ m, i }))\n .filter(({ m }) =>\n brand === \"samsung\" ? m.startsWith(\"Samsung\") : m.startsWith(\"Iphone\")\n );\n\n const rows = [];\n for (let k = 0; k < items.length; k += 2) {\n const row = [{ text: items[k].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k].i}` }];\n if (items[k + 1]) {\n row.push({ text: items[k + 1].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k + 1].i}` });\n }\n rows.push(row);\n }\n rows.push([{ text: \"◀️ Orqaga\", callback_data: \"backbrand\" }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\n// ============ COMMANDS ============\nasync function cmdStart(chatId) {\n await sendMessage(\n chatId,\n \"📱 Telefon Baza\\n\\n\" +\n \"Pastdagi tugmalar orqali boshqaring:\\n\\n\" +\n \"➕ Qo'shish — yangi telefon kiritish\\n\" +\n \"🔍 Qidirish — IMEI yoki model bo'yicha\\n\" +\n \"📋 Ro'yxat — so'nggi telefonlar\\n\" +\n \"📦 Omborda — sotilmagan telefonlar\\n\" +\n \"📊 Statistika — umumiy tahlil\\n\" +\n \"🏷 Sotildi — omborda turganini sotilgan deb belgilash\\n\" +\n \"📁 Partiya — partiya holati va yakunlash\\n\" +\n \"💾 Excel — partiyani fayl qilib olish\\n\" +\n \"✏️ Tahrirlash — kiritilgan ma'lumotni tuzatish\\n\" +\n \"🗑 O'chirish — telefonni ro'yxatdan olib tashlash\\n\" +\n \"🚚 Junatish — har partiyaning junatish summasi alohida\\n\" +\n \"🔢 IMEI ro'yxat — partiyaning model + IMEI ro'yxati\\n\" +\n \"📤 Mijozga — narxsiz ro'yxat fayli (xaridorga yuborish uchun)\\n\\n\" +\n \"Har kuni 20:00 da avtomatik hisobot keladi.\\n/hisobot — hozir ko'rish\",\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\nasync function cmdAdd(state, chatId) {\n setDraft(state, chatId, { step: \"imei\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"➕ Yangi telefon\\n\\nIMEI raqamini yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function cmdSearch(state, chatId) {\n setDraft(state, chatId, { step: \"search\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"🔍 IMEI, model yoki sana yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function runSearch(state, chatId, query) {\n const q = query.trim().toLowerCase();\n const found = state.phones.filter((p) =>\n `${p.imei || \"\"} ${p.model || \"\"} ${p.sana || \"\"}`.toLowerCase().includes(q)\n );\n\n if (found.length === 0) {\n await sendMessage(chatId, `🔍 \"${query}\" bo'yicha hech narsa topilmadi.`);\n return;\n }\n\n const shown = found.slice(0, 8);\n let msg = `🔍 ${found.length} ta topildi` + (found.length > 8 ? \" (birinchi 8 tasi)\" : \"\") + divider();\n msg += shown.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n await sendMessage(chatId, msg);\n}\n\nfunction batchStats(state, items) {\n let sold = 0, profit = 0, stock = 0, cost = 0, ship = 0, buyWon = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n ship += Number(p.junat) || 0;\n buyWon += Number(p.sotib) || 0;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n return { sold, profit, stock, cost, ship, buyWon };\n}\n\nfunction batchSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `list:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📋 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `📋 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n return;\n }\n\n const t = batchStats(state, items);\n const shown = Math.min(12, items.length);\n const list = items.slice(0, shown);\n\n let msg = `📋 Partiya ${target}` + divider();\n msg += `📱 ${items.length} ta · 📦 omborda ${t.stock}\\n`;\n msg += `💵 Sotib olindi: ${fmtWon(t.buyWon)} (~${fmtUsd(t.buyWon / rateForBatch(state, target))})\\n`;\n msg += `🚚 Junatish: ${fmtUsd(t.ship)}\\n`;\n msg += `📉 Opshiy harajat: ${fmtUsd(t.cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(t.sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(t.profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, target)} ₩/$`;\n\n msg += divider();\n msg += list.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n\n if (items.length > shown) {\n msg += divider() + `...yana ${items.length - shown} ta. Hammasini 💾 Excel orqali oling.`;\n }\n\n msg += divider() + `Bazada jami: ${state.phones.length} ta`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n}\n\nasync function cmdStock(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda telefon yo'q — hammasi sotilgan! ✅\");\n return;\n }\n\n let totalCost = 0;\n stock.forEach((p) => { totalCost += compute(state, p).opshiy; });\n\n const byModel = {};\n stock.forEach((p) => { byModel[p.model] = (byModel[p.model] || 0) + 1; });\n\n let msg = `📦 Omborda: ${stock.length} ta\\n`;\n msg += `Jami tannarx: ${fmtUsd(totalCost)}` + divider();\n msg += Object.entries(byModel)\n .sort((a, b) => b[1] - a[1])\n .map(([m, n]) => `• ${m} — ${n} ta`)\n .join(\"\\n\");\n\n if (stock.length <= 6) {\n msg += divider() + stock.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n }\n await sendMessage(chatId, msg);\n}\n\nasync function cmdStats(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📊 Hali ma'lumot yo'q.\");\n return;\n }\n\n let totalProfit = 0, totalSold = 0, soldCount = 0, stockCount = 0, totalCost = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n totalCost += c.opshiy;\n if (c.sold) { totalProfit += c.foyda; totalSold += p.sotildi; soldCount++; }\n else stockCount++;\n });\n\n // Per-model analysis\n const byModel = {};\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (!byModel[p.model]) byModel[p.model] = { count: 0, sold: 0, profit: 0 };\n const g = byModel[p.model];\n g.count++;\n if (c.sold) { g.sold++; g.profit += c.foyda; }\n });\n const topModels = Object.entries(byModel)\n .map(([m, g]) => ({ model: m, ...g, avg: g.sold ? g.profit / g.sold : 0 }))\n .sort((a, b) => b.profit - a.profit)\n .slice(0, 5);\n\n // Per-batch profit\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n byBatch[b] = (byBatch[b] || 0) + compute(state, p).foyda;\n });\n\n let msg = `📊 Umumiy statistika` + divider();\n msg += `📱 Jami telefon: ${state.phones.length}\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount}\\n`;\n msg += `💰 Jami sotildi: ${fmtUsd(totalSold)}\\n`;\n msg += `💵 Jami tannarx: ${fmtUsd(totalCost)}\\n`;\n msg += `📈 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n msg += divider() + `🏆 Eng foydali modellar\\n`;\n msg += topModels\n .map((m, i) => `${i + 1}. ${m.model}\\n ${m.sold}/${m.count} sotilgan · foyda ${fmtUsd(m.profit)}`)\n .join(\"\\n\");\n\n msg += divider() + `📁 Partiya bo'yicha foyda\\n`;\n msg += Object.entries(byBatch)\n .sort((a, b) => Number(a[0]) - Number(b[0]))\n .map(([b, v]) => `Partiya ${b}: ${fmtUsd(v)}`)\n .join(\"\\n\");\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdMarkSold(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda sotilmagan telefon yo'q.\");\n return;\n }\n const rows = stock.slice(0, 20).map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `sell:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🏷 Qaysi telefon sotildi?\", { reply_markup: { inline_keyboard: rows } });\n}\n\n// Field labels shown in the edit menu, mapped to the stored property\nconst EDIT_FIELDS = [\n { key: \"imei\", label: \"IMEI\", type: \"text\" },\n { key: \"model\", label: \"Model\", type: \"model\" },\n { key: \"yomkost\", label: \"Yomkost (%)\", type: \"number\" },\n { key: \"sotib\", label: \"Sotib olindi (₩)\", type: \"number\" },\n { key: \"junat\", label: \"Junatildi ($)\", type: \"number\" },\n { key: \"sotildi\", label: \"Sotildi ($)\", type: \"number\" },\n { key: \"sana\", label: \"Sana\", type: \"text\" },\n { key: \"batch\", label: \"Partiya\", type: \"number\" },\n];\n\nasync function cmdEdit(state, chatId) {\n const last = state.phones.slice(0, 20);\n if (last.length === 0) {\n await sendMessage(chatId, \"✏️ Tahrirlash uchun telefon yo'q.\");\n return;\n }\n const rows = last.map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `edit:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"✏️ Qaysi telefonni tahrirlaysiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nfunction editFieldKeyboard(id) {\n const rows = [];\n for (let i = 0; i < EDIT_FIELDS.length; i += 2) {\n const row = [{ text: EDIT_FIELDS[i].label, callback_data: `ef:${id}:${EDIT_FIELDS[i].key}` }];\n if (EDIT_FIELDS[i + 1]) row.push({ text: EDIT_FIELDS[i + 1].label, callback_data: `ef:${id}:${EDIT_FIELDS[i + 1].key}` });\n rows.push(row);\n }\n rows.push([{ text: \"✖️ Yopish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\nasync function cmdBatch(state, chatId) {\n const items = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let sold = 0, profit = 0, stock = 0, cost = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n\n let msg = `📁 Joriy partiya: ${state.currentBatch}` + divider();\n msg += `📱 Telefon: ${items.length} ta\\n`;\n msg += `📦 Omborda: ${stock} ta\\n`;\n msg += `💵 Tannarx: ${fmtUsd(cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, state.currentBatch)} ₩/$`;\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [{ text: \"✅ Partiyani yakunlash\", callback_data: \"closebatch\" }],\n [{ text: \"💱 Kursni o'zgartirish\", callback_data: \"setrate\" }],\n ],\n },\n });\n}\n\nasync function cmdImeiList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🔢 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `🔢 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: imeiSelectorRows(state, target) },\n });\n return;\n }\n\n // Plain lines so the whole block can be copied in one go\n const lines = items.map((p) => `${p.model} ${p.imei}`);\n\n let msg = `🔢 Partiya ${target} — IMEI ro'yxati\\n`;\n msg += `${items.length} ta` + divider();\n msg += `${lines.join(\"\\n\")}`;\n\n // Matnni o'qish/nusxalash uchun qoldiramiz, ostiga format tugmalarini qo'yamiz\n const rows = [\n [\n { text: \"📊 Excel\", callback_data: `dl:imei:${target}:csv` },\n { text: \"📄 PDF\", callback_data: `dl:imei:${target}:pdf` },\n { text: \"🖼 Rasm\", callback_data: `dl:imei:${target}:png` },\n ],\n ...imeiSelectorRows(state, target),\n ];\n\n await sendMessage(chatId, msg, { reply_markup: { inline_keyboard: rows } });\n}\n\n// IMEI ro'yxati uchun jadval — faqat model va IMEI\nfunction imeiTable(state, which) {\n const items = exportItems(state, which);\n return {\n title: exportTitle(which, items.length),\n headers: [\"Model\", \"Imei\"],\n rows: items.map((p) => [p.model, p.imei]),\n };\n}\n\nfunction imeiSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `imei:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdShipping(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🚚 Hali ma'lumot yo'q.\");\n return;\n }\n\n // Group shipping cost by batch so each batch is accounted for on its own\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) byBatch[b] = { count: 0, junat: 0, sold: 0, stock: 0 };\n const g = byBatch[b];\n g.count++;\n g.junat += Number(p.junat) || 0;\n if (isSold(p)) g.sold++; else g.stock++;\n });\n\n const rows = Object.entries(byBatch)\n .map(([b, g]) => ({ batch: Number(b), ...g }))\n .sort((a, b) => b.batch - a.batch);\n\n const grandTotal = rows.reduce((s, r) => s + r.junat, 0);\n const grandCount = rows.reduce((s, r) => s + r.count, 0);\n\n let msg = `🚚 Junatish xarajatlari` + divider();\n\n msg += rows\n .map((r) => {\n const avg = r.count ? r.junat / r.count : 0;\n const mark = r.batch === state.currentBatch ? \" 🔹\" : \"\";\n return (\n `Partiya ${r.batch}${mark}\\n` +\n `├ Telefon: ${r.count} ta\\n` +\n `├ O'rtacha: ${fmtUsd(avg)} / dona\\n` +\n `└ Jami junatish: ${fmtUsd(r.junat)}`\n );\n })\n .join(\"\\n\\n\");\n\n msg += divider();\n msg += `UMUMIY\\n`;\n msg += `${rows.length} ta partiya · ${grandCount} ta telefon\\n`;\n msg += `Jami junatish: ${fmtUsd(grandTotal)}`;\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdExport(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n if (batches.length === 0) {\n await sendMessage(chatId, \"💾 Eksport uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `csv:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"csv:all\" }]);\n await sendMessage(chatId, \"💾 Qaysi partiyani yuklab olasiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nasync function cmdExportClient(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n if (batches.length === 0) {\n await sendMessage(chatId, \"📤 Eksport uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `ccsv:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"ccsv:all\" }]);\n await sendMessage(\n chatId,\n \"📤 Mijozga yuborish uchun fayl\\n\\n\" +\n \"Faqat sana, IMEI, model va yomkost bo'ladi.\\nNarx, foyda va kurs ko'rinmaydi.\\n\\n\" +\n \"Qaysi partiya?\",\n { reply_markup: { inline_keyboard: rows } }\n );\n}\n\n// ============ EKSPORT MA'LUMOTLARI ============\nfunction exportItems(state, which) {\n return which === \"all\"\n ? state.phones\n : state.phones.filter((p) => String(p.batch || 1) === String(which));\n}\n\nfunction exportTitle(which, count) {\n return `${which === \"all\" ? \"Hammasi\" : \"Partiya \" + which} — ${count} ta telefon`;\n}\n\n// To'liq jadval — narx, foyda va kurs bilan (faqat o'zingiz uchun)\nfunction fullTable(state, which) {\n const items = exportItems(state, which);\n return {\n title: exportTitle(which, items.length),\n headers: [\"Sana\", \"Imei\", \"Model\", \"Yomkost(%)\", \"Sotib olindi(W)\", \"Sotib olindi($)\",\n \"Junatildi($)\", \"Opshiy($)\", \"Sotildi($)\", \"Foyda($)\", \"Kurs\", \"Holat\"],\n rows: items.map((p) => {\n const c = compute(state, p);\n return [\n p.sana, p.imei, p.model, p.yomkost, p.sotib,\n c.sotibUsd.toFixed(2), (p.junat || 0).toFixed(2), c.opshiy.toFixed(2),\n c.sold ? p.sotildi.toFixed(2) : \"\", c.sold ? c.foyda.toFixed(2) : \"\",\n c.rate, c.sold ? \"Sotilgan\" : \"Omborda\",\n ];\n }),\n };\n}\n\n// Mijozga yuboriladigan jadval — narxsiz\nfunction clientTable(state, which) {\n const items = exportItems(state, which);\n return {\n title: exportTitle(which, items.length),\n headers: [\"Sana\", \"Imei\", \"Model\", \"Yomkost(%)\"],\n rows: items.map((p) => [p.sana, p.imei, p.model, p.yomkost]),\n };\n}\n\nfunction formatKeyboard(kind, which) {\n return {\n inline_keyboard: [\n [\n { text: \"📊 Excel\", callback_data: `dl:${kind}:${which}:csv` },\n { text: \"📄 PDF\", callback_data: `dl:${kind}:${which}:pdf` },\n ],\n [{ text: \"🖼 Rasm\", callback_data: `dl:${kind}:${which}:png` }],\n ],\n };\n}\n\n// ============ JADVALNI TURLI FORMATLARDA CHIQARISH ============\n// Har bir eksport {title, headers, rows} ko'rinishida tayyorlanadi,\n// so'ng quyidagi uchta funksiya uni CSV / PDF / PNG ga aylantiradi.\n\nfunction tableToCsv(table) {\n const esc = (v) => {\n const s = String(v ?? \"\");\n return /[\",\\n]/.test(s) ? '\"' + s.replace(/\"/g, '\"\"') + '\"' : s;\n };\n const lines = [table.headers.map(esc).join(\",\")];\n table.rows.forEach((r) => lines.push(r.map(esc).join(\",\")));\n return \"\\uFEFF\" + lines.join(\"\\r\\n\");\n}\n\nasync function tableToPdf(table) {\n const { PDFDocument, StandardFonts, rgb } = await import(\"https://esm.sh/pdf-lib@1.17.1\");\n\n const doc = await PDFDocument.create();\n const font = await doc.embedFont(StandardFonts.Helvetica);\n const bold = await doc.embedFont(StandardFonts.HelveticaBold);\n\n const pageW = 842, pageH = 595; // A4 yotiq\n const margin = 32;\n const cols = table.headers.length;\n const usableW = pageW - margin * 2;\n\n // Ustun kengliklari — matn uzunligiga qarab taqsimlanadi\n const weights = table.headers.map((h, i) => {\n let maxLen = String(h).length;\n table.rows.forEach((r) => { maxLen = Math.max(maxLen, String(r[i] ?? \"\").length); });\n return maxLen;\n });\n const totalW = weights.reduce((a, b) => a + b, 0) || 1;\n const colW = weights.map((w) => (w / totalW) * usableW);\n\n const rowH = 22, headH = 26, titleH = 40;\n let page = null, y = 0;\n\n const newPage = () => {\n page = doc.addPage([pageW, pageH]);\n y = pageH - margin;\n page.drawText(table.title, { x: margin, y: y - 18, size: 15, font: bold, color: rgb(0.12, 0.11, 0.25) });\n y -= titleH;\n // sarlavha qatori\n page.drawRectangle({ x: margin, y: y - headH, width: usableW, height: headH, color: rgb(0.31, 0.27, 0.9) });\n let x = margin;\n table.headers.forEach((h, i) => {\n page.drawText(String(h), { x: x + 6, y: y - headH + 8, size: 9, font: bold, color: rgb(1, 1, 1) });\n x += colW[i];\n });\n y -= headH;\n };\n\n newPage();\n\n table.rows.forEach((r, idx) => {\n if (y - rowH < margin) newPage();\n if (idx % 2 === 1) {\n page.drawRectangle({ x: margin, y: y - rowH, width: usableW, height: rowH, color: rgb(0.96, 0.96, 0.99) });\n }\n let x = margin;\n r.forEach((cell, i) => {\n page.drawText(String(cell ?? \"\"), { x: x + 6, y: y - rowH + 7, size: 9, font, color: rgb(0.1, 0.1, 0.18) });\n x += colW[i];\n });\n page.drawLine({\n start: { x: margin, y: y - rowH },\n end: { x: margin + usableW, y: y - rowH },\n thickness: 0.5, color: rgb(0.85, 0.85, 0.92),\n });\n y -= rowH;\n });\n\n return await doc.save();\n}\n\nfunction tableToSvg(table) {\n const pad = 24, rowH = 34, headH = 40, titleH = 48;\n const cols = table.headers.length;\n\n const weights = table.headers.map((h, i) => {\n let maxLen = String(h).length;\n table.rows.forEach((r) => { maxLen = Math.max(maxLen, String(r[i] ?? \"\").length); });\n return Math.max(6, maxLen);\n });\n const colW = weights.map((w) => w * 9 + 24);\n const tableW = colW.reduce((a, b) => a + b, 0);\n const W = tableW + pad * 2;\n const H = titleH + headH + table.rows.length * rowH + pad * 2;\n\n const esc = (s) => String(s ?? \"\")\n .replace(/&/g, \"&\").replace(//g, \">\");\n\n let svg = ``;\n return svg;\n}\n\n// resvg wasm va shrift bir marta yuklanadi, keyin qayta ishlatiladi\nlet _resvgReady = null;\nlet _fontBuf = null;\n\nasync function initResvg() {\n if (_resvgReady) return _resvgReady;\n _resvgReady = (async () => {\n const mod = await import(\"https://esm.sh/@resvg/resvg-wasm@2.6.2\");\n await mod.initWasm(fetch(\"https://unpkg.com/@resvg/resvg-wasm@2.6.2/index_bg.wasm\"));\n // resvg'da tizim shriftlari yo'q — shriftni o'zimiz yuklaymiz\n const fr = await fetch(\"https://cdn.jsdelivr.net/npm/dejavu-fonts-ttf@2.37.3/ttf/DejaVuSans.ttf\");\n _fontBuf = new Uint8Array(await fr.arrayBuffer());\n return mod;\n })();\n return _resvgReady;\n}\n\nasync function tableToPng(table) {\n const mod = await initResvg();\n const svg = tableToSvg(table);\n const r = new mod.Resvg(svg, {\n font: { fontBuffers: [_fontBuf], defaultFontFamily: \"DejaVu Sans\" },\n fitTo: { mode: \"width\", value: Math.min(1600, Math.max(700, table.headers.length * 190)) },\n });\n return r.render().asPng();\n}\n\n// ============ DRAFT FLOW ============\nasync function handleDraftText(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\n // Search flow\n if (draft.step === \"search\") {\n clearDraft(state, chatId);\n await saveState(state);\n await runSearch(state, chatId, text);\n return true;\n }\n\n // Applying a new value to a field being edited\n if (draft.step === \"editvalue\") {\n const { id, field } = draft.data;\n const idx = state.phones.findIndex((p) => p.id === id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n let value;\n if (meta.type === \"number\") {\n value = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(value)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n } else {\n value = text.trim();\n if (!value) { await sendMessage(chatId, \"❌ Bo'sh bo'lmasin:\"); return true; }\n }\n\n state.phones[idx][field] = value;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(\n chatId,\n `✅ ${meta.label} yangilandi.` + divider() + phoneCard(state, state.phones[idx]),\n { reply_markup: editFieldKeyboard(id) }\n );\n return true;\n }\n\n // Setting a sale price for an existing stock phone\n if (draft.step === \"sellprice\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 480):\"); return true; }\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n state.phones[idx].sotildi = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Sotildi deb belgilandi!\\n\\n` + phoneCard(state, state.phones[idx]));\n return true;\n }\n\n // Changing the current batch rate\n if (draft.step === \"rate\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Kursni raqam bilan kiriting (masalan: 1430):\"); return true; }\n state.batchRates[state.currentBatch] = v;\n state.lastRate = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Partiya ${state.currentBatch} kursi ${v} ₩/$ qilib belgilandi.`);\n return true;\n }\n\n // --- Add-phone flow ---\n if (draft.step === \"imei\") {\n const imei = text.trim();\n if (!imei) { await sendMessage(chatId, \"❌ IMEI bo'sh bo'lmasin. Qayta yuboring:\"); return true; }\n const dup = state.phones.find((p) => (p.imei || \"\").trim() === imei);\n draft.data.imei = imei;\n draft.step = \"model\";\n setDraft(state, chatId, draft);\n await saveState(state);\n const warn = dup\n ? `⚠️ Diqqat: bu IMEI allaqachon bor\\n(${dup.model}, Partiya ${dup.batch || 1}, ${dup.sana})\\n\\n`\n : \"\";\n await sendMessage(chatId, warn + \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return true;\n }\n\n if (draft.step === \"yomkost\") {\n const v = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 85):\"); return true; }\n draft.data.yomkost = v;\n draft.step = \"sotib\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"💵 Sotib olindi narxi (₩):\");\n return true;\n }\n\n if (draft.step === \"sotib\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.sotib = v;\n draft.step = \"junat\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🚚 Junatildi narxi ($):\");\n return true;\n }\n\n if (draft.step === \"junat\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.junat = v;\n draft.step = \"sotildi\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🏷 Sotildi narxi ($):\\n\\nHali sotilmagan bo'lsa — 0 yuboring yoki tugmani bosing.\", {\n reply_markup: { inline_keyboard: [[{ text: \"📦 Hali sotilmagan\", callback_data: \"notsold\" }]] },\n });\n return true;\n }\n\n if (draft.step === \"sotildi\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (yoki 0):\"); return true; }\n await finalizeAdd(state, chatId, v);\n return true;\n }\n\n return false;\n}\n\nasync function finalizeAdd(state, chatId, sotildi) {\n const draft = getDraft(state, chatId);\n if (!draft) return;\n const p = {\n id: genId(),\n sana: todayStr(),\n imei: draft.data.imei,\n model: draft.data.model,\n yomkost: draft.data.yomkost,\n sotib: draft.data.sotib,\n junat: draft.data.junat,\n sotildi: sotildi,\n batch: state.currentBatch,\n addedBy: userName(chatId),\n };\n state.phones.unshift(p);\n clearDraft(state, chatId);\n const ok = await saveState(state);\n\n if (!ok) {\n await sendMessage(\n chatId,\n \"⚠️ Saqlanmadi!\\n\\nInternet yoki server muammosi bo'lishi mumkin. \" +\n \"Iltimos, telefonni qaytadan qo'shib ko'ring.\",\n { reply_markup: MAIN_KEYBOARD }\n );\n return;\n }\n\n const batchCount = state.phones.filter((x) => (x.batch || 1) === state.currentBatch).length;\n await sendMessage(\n chatId,\n \"✅ Qo'shildi!\" + divider() + phoneCard(state, p) + divider() +\n `Bazada jami: ${state.phones.length} ta · Partiya ${state.currentBatch}: ${batchCount} ta`,\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\n// ============ CALLBACKS ============\nasync function handleCallback(state, chatId, data, cbId) {\n if (data === \"cancel\") {\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, \"Bekor qilindi\");\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n return;\n }\n\n if (data.startsWith(\"imei:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdImeiList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"list:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"brand:\")) {\n const brand = data.split(\":\")[1];\n const draft = getDraft(state, chatId);\n if (!draft || (draft.step !== \"model\" && draft.step !== \"editmodel\")) {\n await answerCallback(cbId, \"Bu amal eskirgan\");\n return;\n }\n await answerCallback(cbId, brand === \"samsung\" ? \"Samsung\" : \"iPhone\");\n await sendMessage(chatId, \"📱 Modelni tanlang:\", { reply_markup: modelKeyboard(brand) });\n return;\n }\n\n if (data === \"backbrand\") {\n await answerCallback(cbId, \"\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n if (data.startsWith(\"model:\")) {\n const model = MODEL_OPTIONS[parseInt(data.split(\":\")[1])];\n const draft = getDraft(state, chatId);\n\n // Same picker is reused when editing an existing phone's model\n if (draft && draft.step === \"editmodel\") {\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx !== -1) state.phones[idx].model = model;\n const id = draft.data.id;\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `✅ Model ${model} qilib o'zgartirildi.` + divider() + phoneCard(state, state.phones[idx]), {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (!draft || draft.step !== \"model\") { await answerCallback(cbId, \"Bu amal eskirgan\"); return; }\n draft.data.model = model;\n draft.step = \"yomkost\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `📱 Model: ${model}\\n\\n🔋 Yomkost foizi:`);\n return;\n }\n\n if (data === \"notsold\") {\n await answerCallback(cbId, \"Omborda deb belgilandi\");\n await finalizeAdd(state, chatId, 0);\n return;\n }\n\n if (data.startsWith(\"edit:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Maydonni tanlang\");\n await sendMessage(chatId, \"✏️ Tahrirlash\" + divider() + phoneCard(state, p) + \"\\n\\nQaysi maydonni o'zgartirasiz?\", {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (data.startsWith(\"ef:\")) {\n const [, id, field] = data.split(\":\");\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n\n if (meta.type === \"model\") {\n setDraft(state, chatId, { step: \"editmodel\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Model tanlang\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n setDraft(state, chatId, { step: \"editvalue\", data: { id, field } });\n await saveState(state);\n await answerCallback(cbId, meta.label);\n await sendMessage(chatId, `✏️ ${meta.label}\\n\\nHozirgi qiymat: ${p[field] ?? \"—\"}\\n\\nYangi qiymatni yuboring:`);\n return;\n }\n\n if (data.startsWith(\"sell:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n setDraft(state, chatId, { step: \"sellprice\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Narxni kiriting\");\n await sendMessage(chatId, `🏷 ${p.model}\\n${p.imei}\\n\\nSotuv narxini kiriting ($):`);\n return;\n }\n\n if (data.startsWith(\"del:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Tasdiqlang\");\n await sendMessage(chatId, `🗑 ${p.model}\\n${p.imei}\\n\\nO'chirilsinmi?`, {\n reply_markup: {\n inline_keyboard: [[\n { text: \"✅ Ha, o'chirish\", callback_data: `delyes:${id}` },\n { text: \"✖️ Bekor\", callback_data: \"cancel\" },\n ]],\n },\n });\n return;\n }\n\n if (data.startsWith(\"delyes:\")) {\n const id = data.split(\":\")[1];\n const idx = state.phones.findIndex((x) => x.id === id);\n if (idx !== -1) {\n const removed = state.phones[idx];\n state.phones.splice(idx, 1);\n await saveState(state);\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(chatId, `🗑 O'chirildi: ${removed.model} (${removed.imei})`);\n } else await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n\n if (data === \"closebatch\") {\n state.currentBatch = (state.currentBatch || 1) + 1;\n await saveState(state);\n await answerCallback(cbId, \"Yakunlandi\");\n await sendMessage(chatId, `✅ Partiya yakunlandi.\\n\\n📁 Yangi joriy partiya: ${state.currentBatch}`);\n return;\n }\n\n if (data === \"setrate\") {\n setDraft(state, chatId, { step: \"rate\", data: {} });\n await saveState(state);\n await answerCallback(cbId, \"Kursni kiriting\");\n await sendMessage(chatId, `💱 Partiya ${state.currentBatch} uchun yangi kursni kiriting (₩/$):`);\n return;\n }\n\n // Mijozga: partiya tanlangach format so'raladi\n if (data.startsWith(\"ccsv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"📤 Qaysi formatda?\", { reply_markup: formatKeyboard(\"cli\", which) });\n return;\n }\n\n // To'liq eksport: partiya tanlangach format so'raladi\n if (data.startsWith(\"csv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"💾 Qaysi formatda?\", { reply_markup: formatKeyboard(\"full\", which) });\n return;\n }\n\n // Yagona yuklab olish nuqtasi: dl:{kind}:{which}:{format}\n if (data.startsWith(\"dl:\")) {\n const [, kind, which, fmt] = data.split(\":\");\n const table = kind === \"imei\"\n ? imeiTable(state, which)\n : kind === \"cli\"\n ? clientTable(state, which)\n : fullTable(state, which);\n if (table.rows.length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n\n await answerCallback(cbId, \"Tayyorlanmoqda...\");\n\n const base = which === \"all\" ? \"telefonlar\" : `partiya-${which}`;\n const suffix = kind === \"cli\" ? \"-royxat\" : kind === \"imei\" ? \"-imei\" : \"\";\n const caption = table.title;\n\n try {\n if (fmt === \"csv\") {\n await sendDocument(chatId, `${base}${suffix}.csv`, tableToCsv(table), caption, \"text/csv\");\n } else if (fmt === \"pdf\") {\n const bytes = await tableToPdf(table);\n await sendDocument(chatId, `${base}${suffix}.pdf`, bytes, caption, \"application/pdf\");\n } else if (fmt === \"png\") {\n const bytes = await tableToPng(table);\n await sendPhoto(chatId, `${base}${suffix}.png`, bytes, caption);\n }\n } catch (e) {\n console.error(\"eksport xatosi\", fmt, e);\n await sendMessage(\n chatId,\n `⚠️ ${fmt.toUpperCase()} tayyorlashda xatolik bo'ldi.\\nExcel yoki PDF formatini sinab ko'ring.`\n );\n }\n return;\n }\n\n await answerCallback(cbId);\n}\n\n// ============ DAILY REPORT ============\n// Exported separately so a Val Town Cron trigger can call it on a schedule.\nexport async function dailyReport() {\n const state = await loadState();\n const today = todayStr();\n\n const addedToday = state.phones.filter((p) => p.sana === today);\n\n let totalProfit = 0, stockCount = 0, stockCost = 0, soldCount = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) { totalProfit += c.foyda; soldCount++; }\n else { stockCount++; stockCost += c.opshiy; }\n });\n\n // Current batch snapshot\n const batchItems = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let batchProfit = 0, batchStock = 0;\n batchItems.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) batchProfit += c.foyda; else batchStock++;\n });\n\n let msg = `🌙 Kunlik hisobot\\n${today}` + divider();\n\n if (addedToday.length > 0) {\n let todayProfit = 0;\n addedToday.forEach((p) => { todayProfit += compute(state, p).foyda; });\n msg += `📥 Bugun qo'shildi: ${addedToday.length} ta\\n`;\n msg += `📈 Bugungi foyda: ${fmtUsd(todayProfit)}\\n`;\n msg += addedToday.slice(0, 5).map((p) => ` • ${p.model}`).join(\"\\n\");\n if (addedToday.length > 5) msg += `\\n • ...yana ${addedToday.length - 5} ta`;\n } else {\n msg += `📥 Bugun yangi telefon qo'shilmadi.`;\n }\n\n msg += divider();\n msg += `📁 Partiya ${state.currentBatch}\\n`;\n msg += ` ${batchItems.length} ta · omborda ${batchStock} · foyda ${fmtUsd(batchProfit)}`;\n\n msg += divider();\n msg += `Umumiy holat\\n`;\n msg += `📱 Jami: ${state.phones.length} ta\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount} ta (${fmtUsd(stockCost)})\\n`;\n msg += `💰 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n // Phones sitting in stock for a long time are dead capital worth flagging\n const now = new Date();\n const stale = state.phones.filter((p) => {\n if (isSold(p)) return false;\n const d = new Date(p.sana);\n if (isNaN(d.getTime())) return false;\n return (now - d) / 86400000 > 60;\n });\n if (stale.length > 0) {\n msg += divider();\n msg += `⚠️ 60 kundan ko'p omborda: ${stale.length} ta\\n`;\n msg += stale.slice(0, 5).map((p) => ` • ${p.model} — ${p.sana}`).join(\"\\n\");\n }\n\n for (const id of ALLOWED_CHAT_IDS) {\n try { await sendMessage(id, msg); } catch (e) { console.error(\"report failed for\", id, e); }\n }\n\n return new Response(\"report sent\");\n}\n\n// ============ ENTRY POINT ============\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"Telefon baza boti ishlayapti.\", { status: 200 });\n }\n\n let update;\n try { update = await req.json(); } catch { return new Response(\"ok\"); }\n\n try {\n if (update.message) {\n const msg = update.message;\n const chatId = msg.chat.id;\n\n if (!isAllowed(chatId)) {\n await sendMessage(chatId, \"⛔️ Bu bot faqat ruxsat berilgan foydalanuvchilar uchun.\");\n return new Response(\"ok\");\n }\n\n const text = (msg.text || \"\").trim();\n const state = await loadState();\n\n // Menu buttons and slash commands both map to the same actions\n if (text === \"/start\" || text === \"/menu\") await cmdStart(chatId);\n else if (text === \"/qoshish\" || text === \"➕ Qo'shish\") await cmdAdd(state, chatId);\n else if (text === \"/qidirish\" || text === \"🔍 Qidirish\") await cmdSearch(state, chatId);\n else if (text === \"/royxat\" || text === \"📋 Ro'yxat\") await cmdList(state, chatId);\n else if (text === \"/omborda\" || text === \"📦 Omborda\") await cmdStock(state, chatId);\n else if (text === \"/statistika\" || text === \"📊 Statistika\") await cmdStats(state, chatId);\n else if (text === \"/sotildi\" || text === \"🏷 Sotildi\") await cmdMarkSold(state, chatId);\n else if (text === \"/partiya\" || text === \"📁 Partiya\") await cmdBatch(state, chatId);\n else if (text === \"/excel\" || text === \"💾 Excel\") await cmdExport(state, chatId);\n else if (text === \"/junatish\" || text === \"🚚 Junatish\") await cmdShipping(state, chatId);\n else if (text === \"/imei\" || text === \"🔢 IMEI ro'yxat\") await cmdImeiList(state, chatId);\n else if (text === \"/mijoz\" || text === \"📤 Mijozga (narxsiz)\") await cmdExportClient(state, chatId);\n else if (text === \"/tahrirlash\" || text === \"✏️ Tahrirlash\") await cmdEdit(state, chatId);\n else if (text === \"/hisobot\") await dailyReport();\n else if (text === \"/ochirish\" || text === \"🗑 O'chirish\") {\n const last = state.phones.slice(0, 15);\n if (last.length === 0) await sendMessage(chatId, \"Ro'yxat bo'sh.\");\n else {\n const rows = last.map((p) => [{ text: `${p.model} — ${p.imei}`, callback_data: `del:${p.id}` }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🗑 O'chiriladigan telefonni tanlang:\", { reply_markup: { inline_keyboard: rows } });\n }\n }\n else if (text === \"/bekor\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n }\n else {\n const handled = await handleDraftText(state, chatId, text);\n if (!handled) {\n // Anything else is treated as a quick search — fastest path when checking a phone\n await runSearch(state, chatId, text);\n }\n }\n } else if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n if (!isAllowed(chatId)) { await answerCallback(cq.id, \"Ruxsat yo'q\"); return new Response(\"ok\"); }\n const state = await loadState();\n await handleCallback(state, chatId, cq.data, cq.id);\n }\n } catch (err) {\n console.error(err);\n }\n\n return new Response(\"ok\");\n}","createdAt",["D",1787997845604],"branchVersion","branchId","17503bab-2fab-4c31-9a31-624c24325c05","id","399375c7-b982-45db-ab5d-870b32bde5b8","Telefonbaza",["D",1787638223825],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","579d8fce-a99d-484f-a0ae-114d4a14bc32","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03785-ea79-7229-8499-966d99c58666","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"isOwned",128,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sindorsuyarov","handle","displayName","Sindor Suyarov","avatar","https://lh3.googleusercontent.com/a/ACg8ocJaHUSJVIZHoDaXtVDVAEsApROv3Z-ewH59Qp7VYg3H9f1jTlQE=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":214,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":215,"_80":216,"_82":217,"_84":25},"tree",[189,190,191,192,193,194],"files",[189,190,191,192,193,194],"counts",{"_179":62,"_180":168,"_181":62,"_182":183,"_184":185},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":172,"_32":173,"_30":174,"_135":-5,"_41":42,"_40":175,"_137":58,"_38":176,"_13":139,"_33":140,"_35":177,"_24":25,"_142":-5,"_27":178},{"_43":163,"_32":164,"_30":165,"_135":-5,"_41":42,"_40":166,"_137":58,"_38":167,"_13":168,"_33":169,"_35":170,"_24":25,"_142":-5,"_27":171},{"_43":159,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":160,"_13":161,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":162},{"_43":152,"_32":153,"_30":154,"_135":-5,"_41":42,"_40":155,"_137":58,"_38":156,"_13":139,"_33":140,"_35":157,"_24":25,"_142":-5,"_27":158},{"_43":144,"_32":145,"_30":146,"_135":-5,"_41":42,"_40":147,"_137":25,"_38":148,"_13":149,"_33":34,"_35":150,"_24":25,"_142":-5,"_27":151},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":58,"_38":138,"_13":139,"_33":140,"_35":141,"_24":25,"_142":-5,"_27":143},"8ed9ab79-91fb-4ffc-bc13-c46102c9b4fa","xarajat-kunlik.ts","480692dc-a2c0-11f1-8021-1607ee4eb77e","parentId",31,"latest",["D",1787908300632],3,"interval","// ============ KUNLIK XARAJAT HISOBOTI (CRON) ============\n// Alohida fayl — Val Town'da bitta faylga faqat bitta trigger qo'yiladi.\n// Cron: 0 15 * * * (UTC 15:00 = Koreya vaqti bilan 00:00)\n// Yarim tunda ishga tushadi va ENDIGINA TUGAGAN kun bo'yicha hisobot yuboradi.\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nconst BOT_TOKEN = \"8939644884:AAFQlvOOGDfdSoOfVxScQ9E49ybVG8QgUyE\";\nconst ALLOWED_CHAT_IDS = [5359145775];\nconst STORE_KEY = \"xarajat_bazasi\";\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\nasync function sendMessage(chatId, text) {\n const res = await fetch(`${TG_API}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, parse_mode: \"HTML\" }),\n });\n return res.json();\n}\n\nasync function loadState() {\n try {\n const data = await blob.getJSON(STORE_KEY);\n if (!data) throw new Error(\"empty\");\n return {\n expenses: Array.isArray(data.expenses) ? data.expenses : [],\n categories: Array.isArray(data.categories) ? data.categories : [],\n rate: data.rate || 1430,\n };\n } catch {\n return { expenses: [], categories: [], rate: 1430 };\n }\n}\n\nconst fmtWon = (n) => Math.round(n).toLocaleString(\"en-US\") + \"₩\";\nconst fmtUsd = (n) => \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\nconst divider = () => \"\\n━━━━━━━━━━━━━━━━━━\\n\";\n\n// Koreya sanasi (UTC+9)\nfunction koreaDate(offsetDays = 0) {\n const d = new Date(Date.now() + 9 * 3600 * 1000 + offsetDays * 86400000);\n return d.toISOString().slice(0, 10);\n}\n\nfunction bothCurrency(won, rate) {\n return `${fmtWon(won)} (~${fmtUsd(won / rate)})`;\n}\n\nexport default async function () {\n const state = await loadState();\n const rate = state.rate;\n\n // Yarim tunda ishlaydi, shuning uchun hisobot ENDIGINA TUGAGAN kun uchun\n const day = koreaDate(-1);\n const prevDay = koreaDate(-2);\n const monthPrefix = day.slice(0, 7);\n\n const todayItems = state.expenses.filter((e) => e.date === day);\n const prevItems = state.expenses.filter((e) => e.date === prevDay);\n const monthItems = state.expenses.filter((e) => (e.date || \"\").startsWith(monthPrefix));\n\n const total = todayItems.reduce((s, e) => s + e.amount, 0);\n const prevTotal = prevItems.reduce((s, e) => s + e.amount, 0);\n const monthTotal = monthItems.reduce((s, e) => s + e.amount, 0);\n\n let msg = `🌙 Kunlik hisobot\\n${day}` + divider();\n\n if (todayItems.length === 0) {\n msg += `✅ Bugun xarajat qilinmadi.`;\n } else {\n msg += `💸 Bugun ishlatilgan:\\n${bothCurrency(total, rate)}\\n`;\n msg += `📝 ${todayItems.length} ta xarajat`;\n\n // Kechagi kun bilan solishtirish\n if (prevTotal > 0) {\n const diff = total - prevTotal;\n const pct = Math.round((Math.abs(diff) / prevTotal) * 100);\n if (diff > 0) {\n msg += `\\n📈 Kechagidan ${pct}% ko'p (+${fmtWon(diff)})`;\n } else if (diff < 0) {\n msg += `\\n📉 Kechagidan ${pct}% kam (−${fmtWon(-diff)})`;\n } else {\n msg += `\\n➖ Kechagi bilan bir xil`;\n }\n }\n\n // Kategoriya bo'yicha\n const byCat = {};\n todayItems.forEach((e) => { byCat[e.category] = (byCat[e.category] || 0) + e.amount; });\n const cats = Object.entries(byCat).sort((a, b) => b[1] - a[1]);\n\n msg += divider() + `Nimalarga\\n`;\n msg += cats\n .map(([cat, sum]) => {\n const pct = Math.round((sum / total) * 100);\n return `${cat}\\n ${bothCurrency(sum, rate)} · ${pct}%`;\n })\n .join(\"\\n\");\n\n // Izohlar bo'lsa — eslab qolish oson bo'ladi\n const withNotes = todayItems.filter((e) => e.note);\n if (withNotes.length) {\n msg += divider() + `Izohlar\\n`;\n msg += withNotes.map((e) => `• ${e.note} — ${fmtWon(e.amount)}`).join(\"\\n\");\n }\n }\n\n // Oylik holat — kun yakunida umumiy manzarani ko'rsatadi\n const daysPassed = new Set(monthItems.map((e) => e.date)).size || 1;\n msg += divider();\n msg += `📅 Shu oy (${monthPrefix})\\n`;\n msg += `Jami: ${bothCurrency(monthTotal, rate)}\\n`;\n msg += `Kunlik o'rtacha: ${bothCurrency(monthTotal / daysPassed, rate)}`;\n\n for (const id of ALLOWED_CHAT_IDS) {\n try {\n await sendMessage(id, msg);\n } catch (e) {\n console.error(\"report failed for\", id, e);\n }\n }\n}","label",[133],"4a351298-ca67-459d-885e-27e6185e1149","xarajat-bot.ts","808ab42c-a279-11f1-a40c-1607ee4eb77e",21,["D",1787878794883],4,"// ============ SOZLAMALAR ============\nconst BOT_TOKEN = \"8939644884:AAFQlvOOGDfdSoOfVxScQ9E49ybVG8QgUyE\";\nconst ALLOWED_CHAT_IDS = [5359145775];\n\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\n// Val Town'ning o'z xotirasi — alohida baza sozlash shart emas\nimport { blob } from \"https://esm.town/v/std/blob\";\nconst STORE_KEY = \"xarajat_bazasi\";\n\nconst DEFAULT_CATEGORIES = [\n \"🏠 Uy ijara\",\n \"🚗 Transport\",\n \"🍔 Ovqat\",\n \"📱 Aloqa\",\n \"🛍 Shopping\",\n \"💻 PC\",\n \"🏪 CU / GS\",\n \"💊 Sog'liq\",\n \"✈️ UZB ga junatildi\",\n];\n\n// ============ TELEGRAM ============\nasync function tg(method, payload) {\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 res.json();\n}\n\nconst sendMessage = (chatId, text, extra = {}) =>\n tg(\"sendMessage\", { chat_id: chatId, text, parse_mode: \"HTML\", ...extra });\n\nconst answerCallback = (id, text = \"\") =>\n tg(\"answerCallbackQuery\", { callback_query_id: id, text });\n\nconst isAllowed = (id) => ALLOWED_CHAT_IDS.includes(id);\n\nconst MAIN_KEYBOARD = {\n keyboard: [\n [{ text: \"➕ Xarajat\" }],\n [{ text: \"📅 Bugun\" }, { text: \"📆 Hafta\" }],\n [{ text: \"🗓 Oy\" }, { text: \"📊 Yil\" }],\n [{ text: \"🏷 Kategoriyalar\" }, { text: \"💱 Kurs\" }],\n [{ text: \"🕘 So'nggilar\" }, { text: \"🗑 O'chirish\" }],\n ],\n resize_keyboard: true,\n};\n\n// ============ XOTIRA ============\nasync function loadState() {\n try {\n const data = await blob.getJSON(STORE_KEY);\n if (!data) throw new Error(\"empty\");\n return {\n expenses: Array.isArray(data.expenses) ? data.expenses : [],\n categories: Array.isArray(data.categories) && data.categories.length\n ? data.categories\n : [...DEFAULT_CATEGORIES],\n rate: data.rate || 1430,\n draft: data.draft || {},\n };\n } catch {\n return {\n expenses: [],\n categories: [...DEFAULT_CATEGORIES],\n rate: 1430,\n draft: {},\n };\n }\n}\n\nasync function saveState(state) {\n for (let i = 0; i < 3; i++) {\n try {\n await blob.setJSON(STORE_KEY, state);\n return true;\n } catch (e) {\n console.error(\"save attempt \" + i, e);\n if (i < 2) await new Promise((r) => setTimeout(r, 300 * (i + 1)));\n }\n }\n return false;\n}\n\n// ============ YORDAMCHILAR ============\nconst genId = () => Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\nconst fmtWon = (n) => Math.round(n).toLocaleString(\"en-US\") + \"₩\";\nconst fmtUsd = (n) => \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\nconst divider = () => \"\\n━━━━━━━━━━━━━━━━━━\\n\";\n\n// Local date (Korea) so \"bugun\" matches the user's actual day, not UTC\nfunction todayStr() {\n const d = new Date(Date.now() + 9 * 3600 * 1000);\n return d.toISOString().slice(0, 10);\n}\n\nfunction bothCurrency(won, rate) {\n return `${fmtWon(won)} (~${fmtUsd(won / rate)})`;\n}\n\nconst getDraft = (s, id) => s.draft[id] || null;\nconst setDraft = (s, id, d) => { s.draft[id] = d; };\nconst clearDraft = (s, id) => { delete s.draft[id]; };\n\n// ============ HISOBOT ============\nfunction filterByPeriod(expenses, period) {\n const today = todayStr();\n const now = new Date(today + \"T00:00:00Z\");\n\n if (period === \"day\") {\n return expenses.filter((e) => e.date === today);\n }\n if (period === \"week\") {\n const from = new Date(now);\n from.setUTCDate(from.getUTCDate() - 6); // bugun + oldingi 6 kun\n const fromStr = from.toISOString().slice(0, 10);\n return expenses.filter((e) => e.date >= fromStr && e.date <= today);\n }\n if (period === \"month\") {\n const prefix = today.slice(0, 7);\n return expenses.filter((e) => (e.date || \"\").startsWith(prefix));\n }\n if (period === \"year\") {\n const prefix = today.slice(0, 4);\n return expenses.filter((e) => (e.date || \"\").startsWith(prefix));\n }\n return expenses;\n}\n\nconst PERIOD_NAMES = {\n day: \"Bugungi\",\n week: \"Haftalik (7 kun)\",\n month: \"Oylik\",\n year: \"Yillik\",\n};\n\nasync function report(state, chatId, period) {\n const items = filterByPeriod(state.expenses, period);\n const title = PERIOD_NAMES[period];\n\n if (items.length === 0) {\n await sendMessage(chatId, `📊 ${title} hisobot\\n\\nBu davrda xarajat yo'q.`);\n return;\n }\n\n const total = items.reduce((s, e) => s + e.amount, 0);\n\n // Kategoriya bo'yicha guruhlash\n const byCat = {};\n items.forEach((e) => {\n byCat[e.category] = (byCat[e.category] || 0) + e.amount;\n });\n const cats = Object.entries(byCat).sort((a, b) => b[1] - a[1]);\n\n let msg = `📊 ${title} hisobot\\n${todayStr()}` + divider();\n msg += `Jami: ${bothCurrency(total, state.rate)}\\n`;\n msg += `Xarajatlar soni: ${items.length} ta\\n`;\n msg += `Kurs: ${state.rate} ₩/$`;\n\n msg += divider() + `Kategoriya bo'yicha\\n`;\n msg += cats\n .map(([cat, sum]) => {\n const pct = Math.round((sum / total) * 100);\n const bars = \"▰\".repeat(Math.max(1, Math.round(pct / 10))) +\n \"▱\".repeat(10 - Math.max(1, Math.round(pct / 10)));\n return `${cat}\\n${bars} ${pct}% ${bothCurrency(sum, state.rate)}`;\n })\n .join(\"\\n\\n\");\n\n // Kunlik o'rtacha — oylik va yillik uchun foydali\n if (period === \"month\" || period === \"year\") {\n const days = new Set(items.map((e) => e.date)).size || 1;\n msg += divider() + `Kunlik o'rtacha: ${bothCurrency(total / days, state.rate)}`;\n }\n\n await sendMessage(chatId, msg);\n}\n\n// ============ BUYRUQLAR ============\nasync function cmdStart(chatId) {\n await sendMessage(\n chatId,\n \"💰 Xarajat hisobi\\n\\n\" +\n \"➕ Xarajat — yangi xarajat qo'shish\\n\" +\n \"📅 Bugun · 📆 Hafta · 🗓 Oy · 📊 Yil — hisobotlar\\n\" +\n \"🏷 Kategoriyalar — o'z tugmalaringizni qo'shish/o'chirish\\n\" +\n \"💱 Kurs — ₩/$ kursini belgilash\\n\" +\n \"🕘 So'nggilar — oxirgi xarajatlar\\n\" +\n \"🗑 O'chirish — xato yozilganini olib tashlash\\n\\n\" +\n \"Xarajat won (₩) da kiritiladi, hisobotda dollarda ham ko'rsatiladi.\",\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\nfunction categoryKeyboard(state) {\n const rows = [];\n for (let i = 0; i < state.categories.length; i += 2) {\n const row = [{ text: state.categories[i], callback_data: `cat:${i}` }];\n if (state.categories[i + 1]) {\n row.push({ text: state.categories[i + 1], callback_data: `cat:${i + 1}` });\n }\n rows.push(row);\n }\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\nasync function cmdAdd(state, chatId) {\n if (state.categories.length === 0) {\n await sendMessage(chatId, \"🏷 Avval kategoriya qo'shing (🏷 Kategoriyalar tugmasi).\");\n return;\n }\n setDraft(state, chatId, { step: \"category\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"➕ Yangi xarajat\\n\\nKategoriyani tanlang:\", {\n reply_markup: categoryKeyboard(state),\n });\n}\n\nasync function cmdCategories(state, chatId) {\n let msg = `🏷 Kategoriyalar (${state.categories.length} ta)` + divider();\n msg += state.categories.map((c, i) => `${i + 1}. ${c}`).join(\"\\n\");\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [{ text: \"➕ Yangi qo'shish\", callback_data: \"catadd\" }],\n [{ text: \"🗑 O'chirish\", callback_data: \"catdel\" }],\n [{ text: \"♻️ Standart ro'yxatga qaytarish\", callback_data: \"catreset\" }],\n ],\n },\n });\n}\n\nasync function cmdRate(state, chatId) {\n setDraft(state, chatId, { step: \"rate\", data: {} });\n await saveState(state);\n await sendMessage(\n chatId,\n `💱 Kurs\\n\\nHozirgi: ${state.rate} ₩/$\\n\\nYangi kursni kiriting:`,\n { reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] } }\n );\n}\n\nasync function cmdRecent(state, chatId) {\n if (state.expenses.length === 0) {\n await sendMessage(chatId, \"🕘 Hali xarajat yo'q.\");\n return;\n }\n const last = state.expenses.slice(0, 10);\n let msg = `🕘 So'nggi ${last.length} ta xarajat\\n`;\n msg += `Bazada jami: ${state.expenses.length} ta` + divider();\n msg += last\n .map((e, i) =>\n `${i + 1}. ${e.category}\\n` +\n `├ ${bothCurrency(e.amount, state.rate)}\\n` +\n `└ ${e.date}${e.note ? \" · \" + e.note : \"\"}`\n )\n .join(\"\\n\\n\");\n await sendMessage(chatId, msg);\n}\n\nasync function cmdDelete(state, chatId) {\n if (state.expenses.length === 0) {\n await sendMessage(chatId, \"🗑 O'chirish uchun xarajat yo'q.\");\n return;\n }\n const last = state.expenses.slice(0, 12);\n const rows = last.map((e) => [\n {\n text: `${e.category} · ${fmtWon(e.amount)} · ${e.date}`,\n callback_data: `del:${e.id}`,\n },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🗑 Qaysi xarajatni o'chirasiz?\", {\n reply_markup: { inline_keyboard: rows },\n });\n}\n\n// ============ MATN BOSQICHLARI ============\nasync function handleDraftText(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\n if (draft.step === \"amount\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) {\n await sendMessage(chatId, \"❌ Summani raqam bilan kiriting (masalan: 15000):\");\n return true;\n }\n draft.data.amount = v;\n draft.step = \"note\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(\n chatId,\n `💵 ${bothCurrency(v, state.rate)}\\n\\nIzoh qo'shasizmi? (masalan: \"tushlik\")`,\n { reply_markup: { inline_keyboard: [[{ text: \"➡️ Izohsiz saqlash\", callback_data: \"nonote\" }]] } }\n );\n return true;\n }\n\n if (draft.step === \"note\") {\n await finalizeExpense(state, chatId, text.trim());\n return true;\n }\n\n if (draft.step === \"rate\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) {\n await sendMessage(chatId, \"❌ Kursni raqam bilan kiriting (masalan: 1430):\");\n return true;\n }\n state.rate = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Kurs ${v} ₩/$ qilib belgilandi.`, {\n reply_markup: MAIN_KEYBOARD,\n });\n return true;\n }\n\n if (draft.step === \"newcat\") {\n const name = text.trim();\n if (!name) {\n await sendMessage(chatId, \"❌ Nom bo'sh bo'lmasin:\");\n return true;\n }\n if (state.categories.includes(name)) {\n await sendMessage(chatId, \"⚠️ Bunday kategoriya allaqachon bor. Boshqa nom kiriting:\");\n return true;\n }\n state.categories.push(name);\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ ${name} kategoriyasi qo'shildi.`, {\n reply_markup: MAIN_KEYBOARD,\n });\n return true;\n }\n\n return false;\n}\n\nasync function finalizeExpense(state, chatId, note) {\n const draft = getDraft(state, chatId);\n if (!draft) return;\n\n const e = {\n id: genId(),\n date: todayStr(),\n category: draft.data.category,\n amount: draft.data.amount,\n note: note || \"\",\n rate: state.rate,\n };\n state.expenses.unshift(e);\n clearDraft(state, chatId);\n\n const ok = await saveState(state);\n if (!ok) {\n await sendMessage(chatId, \"⚠️ Saqlanmadi! Qaytadan urinib ko'ring.\", {\n reply_markup: MAIN_KEYBOARD,\n });\n return;\n }\n\n // Bugungi jami — darhol nazorat qilish uchun\n const todayTotal = filterByPeriod(state.expenses, \"day\")\n .reduce((s, x) => s + x.amount, 0);\n\n await sendMessage(\n chatId,\n `✅ Saqlandi` + divider() +\n `${e.category}\\n` +\n `├ ${bothCurrency(e.amount, state.rate)}\\n` +\n `├ ${e.date}\\n` +\n `└ ${e.note || \"izohsiz\"}` + divider() +\n `Bugungi jami: ${bothCurrency(todayTotal, state.rate)}`,\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\n// ============ CALLBACK ============\nasync function handleCallback(state, chatId, data, cbId) {\n if (data === \"cancel\") {\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, \"Bekor qilindi\");\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n return;\n }\n\n if (data.startsWith(\"cat:\")) {\n const idx = parseInt(data.split(\":\")[1]);\n const cat = state.categories[idx];\n const draft = getDraft(state, chatId);\n if (!draft || draft.step !== \"category\" || !cat) {\n await answerCallback(cbId, \"Bu amal eskirgan\");\n return;\n }\n draft.data.category = cat;\n draft.step = \"amount\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(cbId, cat);\n await sendMessage(chatId, `${cat}\\n\\n💵 Summani won (₩) da kiriting:`);\n return;\n }\n\n if (data === \"nonote\") {\n await answerCallback(cbId, \"Saqlanmoqda\");\n await finalizeExpense(state, chatId, \"\");\n return;\n }\n\n if (data === \"catreset\") {\n state.categories = [...DEFAULT_CATEGORIES];\n await saveState(state);\n await answerCallback(cbId, \"Tiklandi\");\n await sendMessage(\n chatId,\n `♻️ Kategoriyalar tiklandi` + divider() +\n state.categories.map((c, i) => `${i + 1}. ${c}`).join(\"\\n\") + divider() +\n `Eski xarajatlaringiz o'zgarmadi.`,\n { reply_markup: MAIN_KEYBOARD }\n );\n return;\n }\n\n if (data === \"catadd\") {\n setDraft(state, chatId, { step: \"newcat\", data: {} });\n await saveState(state);\n await answerCallback(cbId, \"Nom kiriting\");\n await sendMessage(\n chatId,\n \"🏷 Yangi kategoriya nomini yuboring.\\n\\nEmoji bilan yozsangiz chiroyli bo'ladi, masalan: ⛽️ Benzin\"\n );\n return;\n }\n\n if (data === \"catdel\") {\n if (state.categories.length === 0) {\n await answerCallback(cbId, \"Kategoriya yo'q\");\n return;\n }\n const rows = state.categories.map((c, i) => [\n { text: `🗑 ${c}`, callback_data: `catdelyes:${i}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await answerCallback(cbId, \"Tanlang\");\n await sendMessage(chatId, \"🗑 Qaysi kategoriyani o'chirasiz?\", {\n reply_markup: { inline_keyboard: rows },\n });\n return;\n }\n\n if (data.startsWith(\"catdelyes:\")) {\n const idx = parseInt(data.split(\":\")[1]);\n const removed = state.categories[idx];\n if (removed === undefined) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n state.categories.splice(idx, 1);\n await saveState(state);\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(\n chatId,\n `🗑 ${removed} kategoriyasi o'chirildi.\\n\\nEski xarajatlar hisobotda o'z joyida qoladi.`,\n { reply_markup: MAIN_KEYBOARD }\n );\n return;\n }\n\n if (data.startsWith(\"del:\")) {\n const id = data.split(\":\")[1];\n const e = state.expenses.find((x) => x.id === id);\n if (!e) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n await answerCallback(cbId, \"Tasdiqlang\");\n await sendMessage(\n chatId,\n `🗑 ${e.category}\\n${bothCurrency(e.amount, state.rate)} · ${e.date}\\n\\nO'chirilsinmi?`,\n {\n reply_markup: {\n inline_keyboard: [[\n { text: \"✅ Ha\", callback_data: `delyes:${id}` },\n { text: \"✖️ Bekor\", callback_data: \"cancel\" },\n ]],\n },\n }\n );\n return;\n }\n\n if (data.startsWith(\"delyes:\")) {\n const id = data.split(\":\")[1];\n const i = state.expenses.findIndex((x) => x.id === id);\n if (i !== -1) {\n const removed = state.expenses[i];\n state.expenses.splice(i, 1);\n await saveState(state);\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(\n chatId,\n `🗑 O'chirildi: ${removed.category} · ${fmtWon(removed.amount)}`,\n { reply_markup: MAIN_KEYBOARD }\n );\n } else {\n await answerCallback(cbId, \"Topilmadi\");\n }\n return;\n }\n\n await answerCallback(cbId);\n}\n\n// ============ KIRISH NUQTASI ============\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"Xarajat boti ishlayapti.\", { status: 200 });\n }\n\n let update;\n try {\n update = await req.json();\n } catch {\n return new Response(\"ok\");\n }\n\n try {\n if (update.message) {\n const chatId = update.message.chat.id;\n if (!isAllowed(chatId)) {\n await sendMessage(chatId, \"⛔️ Bu bot shaxsiy foydalanish uchun.\");\n return new Response(\"ok\");\n }\n\n const text = (update.message.text || \"\").trim();\n const state = await loadState();\n\n if (text === \"/start\" || text === \"/menu\") await cmdStart(chatId);\n else if (text === \"/xarajat\" || text === \"➕ Xarajat\") await cmdAdd(state, chatId);\n else if (text === \"/bugun\" || text === \"📅 Bugun\") await report(state, chatId, \"day\");\n else if (text === \"/hafta\" || text === \"📆 Hafta\") await report(state, chatId, \"week\");\n else if (text === \"/oy\" || text === \"🗓 Oy\") await report(state, chatId, \"month\");\n else if (text === \"/yil\" || text === \"📊 Yil\") await report(state, chatId, \"year\");\n else if (text === \"/kategoriya\" || text === \"🏷 Kategoriyalar\") await cmdCategories(state, chatId);\n else if (text === \"/kurs\" || text === \"💱 Kurs\") await cmdRate(state, chatId);\n else if (text === \"/sonngi\" || text === \"🕘 So'nggilar\") await cmdRecent(state, chatId);\n else if (text === \"/ochirish\" || text === \"🗑 O'chirish\") await cmdDelete(state, chatId);\n else if (text === \"/bekor\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n } else {\n const handled = await handleDraftText(state, chatId, text);\n if (!handled) {\n // Faqat raqam yuborilsa — tez qo'shish uchun kategoriya so'raladi\n const quick = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (!isNaN(quick) && quick > 0 && /^[\\d\\s.,]+$/.test(text)) {\n setDraft(state, chatId, { step: \"category\", data: { quickAmount: quick } });\n await saveState(state);\n await sendMessage(\n chatId,\n `💵 ${bothCurrency(quick, state.rate)}\\n\\nQaysi kategoriyaga?`,\n { reply_markup: categoryKeyboard(state) }\n );\n } else {\n await sendMessage(chatId, \"Tushunmadim. /start ni bosing.\", {\n reply_markup: MAIN_KEYBOARD,\n });\n }\n }\n }\n } else if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n if (!isAllowed(chatId)) {\n await answerCallback(cq.id, \"Ruxsat yo'q\");\n return new Response(\"ok\");\n }\n const state = await loadState();\n\n // Tez qo'shishda summa allaqachon ma'lum — to'g'ridan-to'g'ri izohga o'tamiz\n if (cq.data.startsWith(\"cat:\")) {\n const draft = getDraft(state, chatId);\n if (draft && draft.step === \"category\" && draft.data.quickAmount) {\n const idx = parseInt(cq.data.split(\":\")[1]);\n const cat = state.categories[idx];\n if (cat) {\n draft.data.category = cat;\n draft.data.amount = draft.data.quickAmount;\n draft.step = \"note\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(cq.id, cat);\n await sendMessage(\n chatId,\n `${cat} · ${bothCurrency(draft.data.amount, state.rate)}\\n\\nIzoh qo'shasizmi?`,\n { reply_markup: { inline_keyboard: [[{ text: \"➡️ Izohsiz saqlash\", callback_data: \"nonote\" }]] } }\n );\n return new Response(\"ok\");\n }\n }\n }\n\n await handleCallback(state, chatId, cq.data, cq.id);\n }\n } catch (err) {\n console.error(err);\n }\n\n return new Response(\"ok\");\n}",[145],"a307cc0b-c013-42fa-88ce-dbd05661d9be","sanoq.ts","12c9bd92-a30b-11f1-ad73-1607ee4eb77e",35,["D",1787940473182],"// ============ UZBEKISTONGA QOLGAN KUNLAR (CRON) ============\n// Har kuni Koreya vaqti bilan soat 12:00 da xabar yuboradi.\n// Cron: 0 3 * * * (UTC 03:00 = Koreya vaqti 12:00)\n\nconst BOT_TOKEN = \"8931700426:AAGk07OKsN520mQv0PC9Gf0oj66AaGOUtOs\";\nconst CHAT_IDS = [5359145775];\n\n// Ketish sanasi va sanoq boshlangan sana (progress chizig'i uchun)\nconst TARGET_DATE = \"2026-12-20\";\nconst START_DATE = \"2026-08-28\";\n\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\nasync function sendMessage(chatId, text) {\n const res = await fetch(`${TG_API}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, parse_mode: \"HTML\" }),\n });\n return res.json();\n}\n\n// Koreya sanasi (UTC+9)\nfunction koreaDate() {\n return new Date(Date.now() + 9 * 3600 * 1000).toISOString().slice(0, 10);\n}\n\nfunction daysBetween(fromStr, toStr) {\n const a = Date.parse(fromStr + \"T00:00:00Z\");\n const b = Date.parse(toStr + \"T00:00:00Z\");\n return Math.round((b - a) / 86400000);\n}\n\n// Sanani o'zbekcha ko'rinishda: \"20-dekabr\"\nconst MONTHS = [\n \"yanvar\", \"fevral\", \"mart\", \"aprel\", \"may\", \"iyun\",\n \"iyul\", \"avgust\", \"sentabr\", \"oktabr\", \"noyabr\", \"dekabr\",\n];\nfunction uzDate(str) {\n const [y, m, d] = str.split(\"-\").map(Number);\n return `${d}-${MONTHS[m - 1]}`;\n}\n\nfunction progressBar(done, total, width = 12) {\n if (total <= 0) return \"\";\n const filled = Math.max(0, Math.min(width, Math.round((done / total) * width)));\n return \"▰\".repeat(filled) + \"▱\".repeat(width - filled);\n}\n\nexport default async function () {\n const today = koreaDate();\n const left = daysBetween(today, TARGET_DATE);\n\n let msg;\n\n if (left > 0) {\n const total = daysBetween(START_DATE, TARGET_DATE);\n const passed = total - left;\n const pct = total > 0 ? Math.round((passed / total) * 100) : 0;\n\n // Hafta/oy ko'rinishida ham ayting — katta raqamni tasavvur qilish osonroq\n const weeks = Math.floor(left / 7);\n const extraDays = left % 7;\n let human = \"\";\n if (left >= 7) {\n human = `${weeks} hafta`;\n if (extraDays) human += ` ${extraDays} kun`;\n }\n\n msg = `🇺🇿 Uzbekistonga ketishingizga\\n\\n`;\n msg += `${left} kun qoldi`;\n if (human) msg += `\\n(${human})`;\n msg += `\\n\\n${progressBar(passed, total)} ${pct}%\\n`;\n msg += `\\n📅 Ketish sanasi: ${uzDate(TARGET_DATE)}\\n`;\n msg += `\\n☀️ Kuningiz yaxshi o'tsin!`;\n\n // Muhim bosqichlarda qo'shimcha eslatma\n if (left === 30) msg += `\\n\\n🎒 Bir oy qoldi — chiptani tekshirib qo'ying!`;\n else if (left === 7) msg += `\\n\\n🧳 Bir hafta qoldi — yig'ilishni boshlash vaqti!`;\n else if (left === 3) msg += `\\n\\n⏰ Uch kun qoldi!`;\n else if (left === 1) msg += `\\n\\n🎉 Ertaga ketasiz!`;\n } else if (left === 0) {\n msg = `🎉🇺🇿 BUGUN KETASIZ!\\n\\nYo'lingiz bexatar bo'lsin!\\nKuningiz yaxshi o'tsin! ☀️`;\n } else {\n msg = `🇺🇿 Uzbekistonga ketgansiz — xush kelibsiz!\\n\\nSanoq tugadi (${uzDate(TARGET_DATE)}).`;\n }\n\n for (const id of CHAT_IDS) {\n try {\n await sendMessage(id, msg);\n } catch (e) {\n console.error(\"yuborilmadi:\", id, e);\n }\n }\n}",[153],"ccf6e2c5-6850-461f-923b-44c1a3bd30e5",["D",1787997845604],16,[28],"c2c1128a-d1e9-48e5-a21e-5d24c0b64aac","main.ts","a8b56616-a04b-11f1-bf07-1607ee4eb77e",2,["D",1787638337583],1,"script","// ====== SOZLAMALAR ======\nconst BOT_TOKEN = \"8359132225:AAHFctPD4qhP9-mlXayGxN3Y5aWRj_xZDWA\";\nconst ALLOWED_CHAT_ID = 5359145775; // faqat shu foydalanuvchi ishlata oladi\nconst JSONBIN_ID = \"6a8349dcf5f4af5e2921141f\";\nconst JSONBIN_KEY = \"$2a$10$WxP19K2dRJrM.w5MOR0bfuBCDyG9emlsNT7COstBxpQhfCoxGhuhS\";\nconst JSONBIN_URL = `https://api.jsonbin.io/v3/b/${JSONBIN_ID}`;\n\nconst MODEL_OPTIONS = [\n \"Iphone 13pro/128\", \"Iphone 13pro/256\", \"Iphone 13promax/128\", \"Iphone 13promax/256\",\n \"Iphone 14pro/128\", \"Iphone 14pro/256\", \"Iphone 14promax/128\", \"Iphone 14promax/256\",\n \"Iphone 15pro/128\", \"Iphone 15pro/256\", \"Iphone 15promax/128\", \"Iphone 15promax/256\",\n \"Iphone 16pro/128\", \"Iphone 16pro/256\", \"Iphone 16promax/128\", \"Iphone 16promax/256\",\n \"Iphone 17pro/128\", \"Iphone 17pro/256\", \"Iphone 17promax/128\", \"Iphone 17promax/256\",\n \"Samsung S22/256\", \"Samsung S22ultra/256\", \"Samsung S22ultra/512\"\n];\n\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\n// ====== TELEGRAM HELPERS ======\nasync function tg(method, payload) {\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 res.json();\n}\n\nfunction sendMessage(chatId, text, extra = {}) {\n return tg(\"sendMessage\", { chat_id: chatId, text, parse_mode: \"HTML\", ...extra });\n}\n\nfunction answerCallback(callbackQueryId, text) {\n return tg(\"answerCallbackQuery\", { callback_query_id: callbackQueryId, text });\n}\n\n// ====== JSONBIN HELPERS ======\nasync function loadState() {\n const res = await fetch(`${JSONBIN_URL}/latest`, {\n headers: { \"X-Master-Key\": JSONBIN_KEY },\n });\n const data = await res.json();\n const rec = data.record || {};\n return {\n phones: Array.isArray(rec.phones) ? rec.phones : [],\n currentBatch: rec.currentBatch || 1,\n batchRates: rec.batchRates || {},\n lastRate: rec.lastRate || 1430,\n tgDraft: rec.tgDraft || {},\n };\n}\n\nasync function saveState(state) {\n const res = await fetch(JSONBIN_URL, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\", \"X-Master-Key\": JSONBIN_KEY },\n body: JSON.stringify(state),\n });\n return res.ok;\n}\n\nfunction rateForBatch(state, batch) {\n const v = state.batchRates[batch];\n return v && v > 0 ? v : state.lastRate || 1430;\n}\n\nfunction computeUsd(state, p) {\n const r = rateForBatch(state, p.batch || 1);\n const sotibUsd = p.sotib / r;\n const opshiy = sotibUsd + p.junat;\n const foyda = p.sotildi - opshiy;\n return { sotibUsd, opshiy, foyda };\n}\n\nfunction todayStr() {\n const d = new Date();\n return d.toISOString().slice(0, 10);\n}\n\nfunction genId() {\n return Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\n}\n\n// ====== DRAFT (step-by-step add flow) HELPERS ======\nfunction getDraft(state, chatId) {\n return state.tgDraft[chatId] || null;\n}\nfunction setDraft(state, chatId, draft) {\n state.tgDraft[chatId] = draft;\n}\nfunction clearDraft(state, chatId) {\n delete state.tgDraft[chatId];\n}\n\nfunction modelKeyboard() {\n const rows = [];\n for (let i = 0; i < MODEL_OPTIONS.length; i += 2) {\n const row = [{ text: MODEL_OPTIONS[i], callback_data: `model:${i}` }];\n if (MODEL_OPTIONS[i + 1]) row.push({ text: MODEL_OPTIONS[i + 1], callback_data: `model:${i + 1}` });\n rows.push(row);\n }\n return { inline_keyboard: rows };\n}\n\nfunction fmtUsd(n) {\n return \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\n}\nfunction fmtWon(n) {\n return Math.round(n).toLocaleString(\"en-US\") + \"\\u20a9\";\n}\n\n// ====== MAIN COMMAND HANDLERS ======\nasync function handleStart(chatId) {\n await sendMessage(\n chatId,\n \"Telefon baza boti\\n\\n\" +\n \"/qoshish — yangi telefon qo'shish\\n\" +\n \"/royxat — joriy partiya va so'nggi telefonlar\\n\" +\n \"/ochirish — telefonni o'chirish\\n\" +\n \"/partiya — joriy partiya holati / yakunlash\\n\" +\n \"/bekor — joriy amalni bekor qilish\"\n );\n}\n\nasync function startAddFlow(state, chatId) {\n setDraft(state, chatId, { step: \"imei\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"IMEI raqamini yuboring:\");\n}\n\nasync function handleTextDuringDraft(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\n if (draft.step === \"imei\") {\n const imei = text.trim();\n if (!imei) { await sendMessage(chatId, \"IMEI bo'sh bo'lmasin. Qayta yuboring:\"); return true; }\n\n const dup = state.phones.find((p) => (p.imei || \"\").trim() === imei);\n draft.data.imei = imei;\n draft.step = \"model\";\n setDraft(state, chatId, draft);\n await saveState(state);\n\n if (dup) {\n await sendMessage(\n chatId,\n `⚠️ Diqqat: bu IMEI allaqachon ro'yxatda bor (${dup.model}, Partiya ${dup.batch || 1}, ${dup.sana}).\\nBaribir davom etyapmiz — model tanlang:`,\n { reply_markup: modelKeyboard() }\n );\n } else {\n await sendMessage(chatId, \"Modelni tanlang:\", { reply_markup: modelKeyboard() });\n }\n return true;\n }\n\n if (draft.step === \"yomkost\") {\n const v = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(v)) { await sendMessage(chatId, \"Raqam kiriting (masalan: 85). Qayta yuboring:\"); return true; }\n draft.data.yomkost = v;\n draft.step = \"sotib\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"Sotib olindi narxini ₩ da kiriting (masalan: 400000):\");\n return true;\n }\n\n if (draft.step === \"sotib\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"Raqam kiriting. Qayta yuboring:\"); return true; }\n draft.data.sotib = v;\n draft.step = \"junat\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"Junatildi narxini $ da kiriting (masalan: 78):\");\n return true;\n }\n\n if (draft.step === \"junat\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"Raqam kiriting. Qayta yuboring:\"); return true; }\n draft.data.junat = v;\n draft.step = \"sotildi\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"Sotildi narxini $ da kiriting (masalan: 480):\");\n return true;\n }\n\n if (draft.step === \"sotildi\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"Raqam kiriting. Qayta yuboring:\"); return true; }\n draft.data.sotildi = v;\n\n const p = {\n id: genId(),\n sana: todayStr(),\n imei: draft.data.imei,\n model: draft.data.model,\n yomkost: draft.data.yomkost,\n sotib: draft.data.sotib,\n junat: draft.data.junat,\n sotildi: v,\n batch: state.currentBatch,\n };\n state.phones.unshift(p);\n clearDraft(state, chatId);\n await saveState(state);\n\n const { foyda } = computeUsd(state, p);\n await sendMessage(\n chatId,\n `✅ Qo'shildi!\\n\\n${p.model}\\nIMEI: ${p.imei}\\nYomkost: ${p.yomkost}%\\nSotib olindi: ${fmtWon(p.sotib)}\\nJunatildi: ${fmtUsd(p.junat)}\\nSotildi: ${fmtUsd(p.sotildi)}\\nFoyda: ${fmtUsd(foyda)}\\n\\nPartiya: ${p.batch}`\n );\n return true;\n }\n\n return false;\n}\n\nasync function handleCallback(state, chatId, data, callbackQueryId) {\n if (data.startsWith(\"model:\")) {\n const idx = parseInt(data.split(\":\")[1]);\n const model = MODEL_OPTIONS[idx];\n const draft = getDraft(state, chatId);\n if (!draft || draft.step !== \"model\") { await answerCallback(callbackQueryId, \"Bu amal eskirgan.\"); return; }\n draft.data.model = model;\n draft.step = \"yomkost\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(callbackQueryId, model);\n await sendMessage(chatId, `Model: ${model}\\n\\nYomkost foizini kiriting (masalan: 85):`);\n return;\n }\n\n if (data.startsWith(\"del:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(callbackQueryId, \"Topilmadi.\"); return; }\n await answerCallback(callbackQueryId, \"Tasdiqlang\");\n await sendMessage(chatId, `${p.model} (${p.imei}) o'chirilsinmi?`, {\n reply_markup: {\n inline_keyboard: [[\n { text: \"✅ Ha, o'chirish\", callback_data: `delyes:${id}` },\n { text: \"✗ Bekor\", callback_data: \"delno\" },\n ]],\n },\n });\n return;\n }\n\n if (data.startsWith(\"delyes:\")) {\n const id = data.split(\":\")[1];\n const idx = state.phones.findIndex((x) => x.id === id);\n if (idx !== -1) {\n const removed = state.phones[idx];\n state.phones.splice(idx, 1);\n await saveState(state);\n await answerCallback(callbackQueryId, \"O'chirildi\");\n await sendMessage(chatId, `🗑 O'chirildi: ${removed.model} (${removed.imei})`);\n } else {\n await answerCallback(callbackQueryId, \"Topilmadi.\");\n }\n return;\n }\n\n if (data === \"delno\") {\n await answerCallback(callbackQueryId, \"Bekor qilindi\");\n await sendMessage(chatId, \"Bekor qilindi.\");\n return;\n }\n\n if (data === \"closebatch\") {\n state.currentBatch = (state.currentBatch || 1) + 1;\n await saveState(state);\n await answerCallback(callbackQueryId, \"Partiya yakunlandi\");\n await sendMessage(chatId, `✅ Partiya yakunlandi. Yangi joriy partiya: ${state.currentBatch}`);\n return;\n }\n\n await answerCallback(callbackQueryId, \"\");\n}\n\nasync function handleRoyxat(state, chatId) {\n const items = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let sold = 0, profit = 0;\n items.forEach((p) => { const c = computeUsd(state, p); sold += p.sotildi; profit += c.foyda; });\n\n let msg = `Joriy partiya: ${state.currentBatch}\\n${items.length} ta · Sotildi ${fmtUsd(sold)} · Foyda ${fmtUsd(profit)}\\n\\n`;\n const last5 = state.phones.slice(0, 5);\n if (last5.length === 0) {\n msg += \"Hali telefon yo'q.\";\n } else {\n msg += \"So'nggi 5 ta:\\n\";\n last5.forEach((p) => {\n const c = computeUsd(state, p);\n msg += `• ${p.model} (${p.imei}) — Foyda ${fmtUsd(c.foyda)}\\n`;\n });\n }\n await sendMessage(chatId, msg);\n}\n\nasync function handleOchirish(state, chatId) {\n const last = state.phones.slice(0, 15);\n if (last.length === 0) { await sendMessage(chatId, \"Ro'yxat bo'sh.\"); return; }\n const rows = last.map((p) => [{ text: `${p.model} — ${p.imei}`, callback_data: `del:${p.id}` }]);\n await sendMessage(chatId, \"O'chirmoqchi bo'lgan telefonni tanlang:\", { reply_markup: { inline_keyboard: rows } });\n}\n\nasync function handlePartiya(state, chatId) {\n const items = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let sold = 0, profit = 0;\n items.forEach((p) => { const c = computeUsd(state, p); sold += p.sotildi; profit += c.foyda; });\n await sendMessage(\n chatId,\n `Joriy partiya: ${state.currentBatch}\\n${items.length} ta · Sotildi ${fmtUsd(sold)} · Foyda ${fmtUsd(profit)}`,\n { reply_markup: { inline_keyboard: [[{ text: \"Partiyani yakunlash\", callback_data: \"closebatch\" }]] } }\n );\n}\n\n// ====== ENTRY POINT (Val Town HTTP val) ======\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"Telefon baza boti ishlayapti.\", { status: 200 });\n }\n\n let update;\n try {\n update = await req.json();\n } catch {\n return new Response(\"ok\");\n }\n\n try {\n if (update.message) {\n const msg = update.message;\n const chatId = msg.chat.id;\n\n if (chatId !== ALLOWED_CHAT_ID) {\n await sendMessage(chatId, \"Kechirasiz, bu bot faqat egasi uchun.\");\n return new Response(\"ok\");\n }\n\n const text = (msg.text || \"\").trim();\n const state = await loadState();\n\n if (text === \"/start\") {\n await handleStart(chatId);\n } else if (text === \"/qoshish\") {\n await startAddFlow(state, chatId);\n } else if (text === \"/royxat\") {\n await handleRoyxat(state, chatId);\n } else if (text === \"/ochirish\") {\n await handleOchirish(state, chatId);\n } else if (text === \"/partiya\") {\n await handlePartiya(state, chatId);\n } else if (text === \"/bekor\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"Bekor qilindi.\");\n } else {\n const handled = await handleTextDuringDraft(state, chatId, text);\n if (!handled) {\n await sendMessage(chatId, \"Tushunmadim. /start ni bosing.\");\n }\n }\n } else if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n\n if (chatId !== ALLOWED_CHAT_ID) {\n await answerCallback(cq.id, \"Ruxsat yo'q.\");\n return new Response(\"ok\");\n }\n\n const state = await loadState();\n await handleCallback(state, chatId, cq.data, cq.id);\n }\n } catch (err) {\n console.error(err);\n }\n\n return new Response(\"ok\");\n}",[164],"34c6ceb9-793c-429f-9b08-178a5d56537a","kunlik-hisobot.ts","86c3d5e4-a38c-11f1-bfb9-1607ee4eb77e",39,["D",1787996061398],"// ============ SOZLAMALAR ============\nconst BOT_TOKEN = \"8359132225:AAHFctPD4qhP9-mlXayGxN3Y5aWRj_xZDWA\";\nconst ALLOWED_CHAT_IDS = [5359145775, 6935143094];\nconst USER_NAMES = { 5359145775: \"Sindor\", 6935143094: \"Sherik\" };\nconst isAllowed = (id) => ALLOWED_CHAT_IDS.includes(id);\nconst userName = (id) => USER_NAMES[id] || String(id);\nconst JSONBIN_ID = \"6a8349dcf5f4af5e2921141f\";\nconst JSONBIN_KEY = \"$2a$10$WxP19K2dRJrM.w5MOR0bfuBCDyG9emlsNT7COstBxpQhfCoxGhuhS\";\nconst JSONBIN_URL = `https://api.jsonbin.io/v3/b/${JSONBIN_ID}`;\nconst TG_API = `https://api.telegram.org/bot${BOT_TOKEN}`;\n\nconst MODEL_OPTIONS = [\n \"Iphone 13pro/128\", \"Iphone 13pro/256\", \"Iphone 13promax/128\", \"Iphone 13promax/256\",\n \"Iphone 14pro/128\", \"Iphone 14pro/256\", \"Iphone 14promax/128\", \"Iphone 14promax/256\",\n \"Iphone 15pro/128\", \"Iphone 15pro/256\", \"Iphone 15promax/128\", \"Iphone 15promax/256\",\n \"Iphone 16pro/128\", \"Iphone 16pro/256\", \"Iphone 16promax/128\", \"Iphone 16promax/256\",\n \"Iphone 17pro/128\", \"Iphone 17pro/256\", \"Iphone 17promax/128\", \"Iphone 17promax/256\",\n \"Samsung S22/256\", \"Samsung S22/512\", \"Samsung S22ultra/256\", \"Samsung S22ultra/512\",\n \"Samsung S23/256\", \"Samsung S23/512\", \"Samsung S23ultra/256\", \"Samsung S23ultra/512\",\n \"Samsung S24/256\", \"Samsung S24/512\", \"Samsung S24ultra/256\", \"Samsung S24ultra/512\",\n \"Samsung S25/256\", \"Samsung S25/512\", \"Samsung S25ultra/256\", \"Samsung S25ultra/512\",\n \"Samsung S26/256\", \"Samsung S26/512\", \"Samsung S26ultra/256\", \"Samsung S26ultra/512\"\n];\n\n// ============ TELEGRAM HELPERS ============\nasync function tg(method, payload) {\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 res.json();\n}\n\nfunction sendMessage(chatId, text, extra = {}) {\n return tg(\"sendMessage\", { chat_id: chatId, text, parse_mode: \"HTML\", ...extra });\n}\n\nfunction answerCallback(id, text = \"\") {\n return tg(\"answerCallbackQuery\", { callback_query_id: id, text });\n}\n\nasync function sendDocument(chatId, filename, content, caption = \"\") {\n const form = new FormData();\n form.append(\"chat_id\", String(chatId));\n form.append(\"caption\", caption);\n form.append(\"parse_mode\", \"HTML\");\n form.append(\"document\", new Blob([content], { type: \"text/csv\" }), filename);\n const res = await fetch(`${TG_API}/sendDocument`, { method: \"POST\", body: form });\n return res.json();\n}\n\n// Persistent menu shown under the text input\nconst MAIN_KEYBOARD = {\n keyboard: [\n [{ text: \"➕ Qo'shish\" }, { text: \"🔍 Qidirish\" }],\n [{ text: \"📋 Ro'yxat\" }, { text: \"📦 Omborda\" }],\n [{ text: \"📊 Statistika\" }, { text: \"🏷 Sotildi\" }],\n [{ text: \"📁 Partiya\" }, { text: \"💾 Excel\" }],\n [{ text: \"✏️ Tahrirlash\" }, { text: \"🗑 O'chirish\" }],\n [{ text: \"🚚 Junatish\" }, { text: \"🔢 IMEI ro'yxat\" }],\n ],\n resize_keyboard: true,\n};\n\n// ============ STORAGE ============\nasync function loadState() {\n // JSONBin (and intermediate CDNs) can serve a cached /latest response, which made a\n // just-added phone missing from the next command. The cache-buster plus no-cache\n // headers force a fresh read every time.\n const url = `${JSONBIN_URL}/latest?_=${Date.now()}`;\n const res = await fetch(url, {\n headers: {\n \"X-Master-Key\": JSONBIN_KEY,\n \"X-Bin-Meta\": \"false\",\n \"Cache-Control\": \"no-cache, no-store, max-age=0\",\n \"Pragma\": \"no-cache\",\n },\n });\n const data = await res.json();\n // With X-Bin-Meta:false the payload is the record itself, otherwise it's under .record\n const rec = (data && data.record) ? data.record : (data || {});\n return {\n phones: Array.isArray(rec.phones) ? rec.phones : [],\n currentBatch: rec.currentBatch || 1,\n batchRates: rec.batchRates || {},\n lastRate: rec.lastRate || 1430,\n tgDraft: rec.tgDraft || {},\n };\n}\n\nasync function saveState(state) {\n // Retry a couple of times: a silently failed write was leaving newly added phones unsaved\n for (let attempt = 0; attempt < 3; attempt++) {\n try {\n const res = await fetch(JSONBIN_URL, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\", \"X-Master-Key\": JSONBIN_KEY },\n body: JSON.stringify(state),\n });\n if (res.ok) return true;\n } catch (e) {\n console.error(\"saveState attempt \" + attempt + \" failed\", e);\n }\n if (attempt < 2) await new Promise((r) => setTimeout(r, 400 * (attempt + 1)));\n }\n return false;\n}\n\n// ============ CALCULATIONS ============\nfunction rateForBatch(state, batch) {\n const v = state.batchRates[batch];\n return v && v > 0 ? v : state.lastRate || 1430;\n}\n\nfunction isSold(p) {\n return Number(p.sotildi) > 0;\n}\n\nfunction compute(state, p) {\n const r = rateForBatch(state, p.batch || 1);\n const sotibUsd = p.sotib / r;\n const opshiy = sotibUsd + (p.junat || 0);\n const foyda = isSold(p) ? p.sotildi - opshiy : 0;\n return { sotibUsd, opshiy, foyda, sold: isSold(p), rate: r };\n}\n\nconst fmtUsd = (n) => \"$\" + (Math.round(n * 10) / 10).toLocaleString(\"en-US\");\nconst fmtWon = (n) => Math.round(n).toLocaleString(\"en-US\") + \"₩\";\n// Koreya sanasi (UTC+9) — tunda qo'shilgan telefon kechagi kunga yozilib qolmasligi uchun\nconst todayStr = () => new Date(Date.now() + 9 * 3600 * 1000).toISOString().slice(0, 10);\nconst genId = () => Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\n\n// ============ FORMATTING ============\nfunction phoneCard(state, p, index = null) {\n const c = compute(state, p);\n const head = index !== null ? `${index}. ` : \"\";\n const status = c.sold ? \"✅ Sotilgan\" : \"📦 Omborda\";\n return (\n `${head}${p.model}\\n` +\n `${p.imei}\\n` +\n `├ Sana: ${p.sana} · Partiya ${p.batch || 1}${p.addedBy ? \" · \" + p.addedBy : \"\"}\\n` +\n `├ Yomkost: ${p.yomkost}%\\n` +\n `├ Sotib olindi: ${fmtWon(p.sotib)} (~${fmtUsd(c.sotibUsd)})\\n` +\n `├ Junatildi: ${fmtUsd(p.junat || 0)}\\n` +\n `├ Opshiy harajat: ${fmtUsd(c.opshiy)}\\n` +\n (c.sold\n ? `├ Sotildi: ${fmtUsd(p.sotildi)}\\n└ Foyda: ${fmtUsd(c.foyda)}`\n : `└ Holat: ${status}`)\n );\n}\n\nfunction divider() {\n return \"\\n━━━━━━━━━━━━━━━━━━\\n\";\n}\n\n// ============ DRAFT HELPERS ============\nconst getDraft = (s, id) => s.tgDraft[id] || null;\nconst setDraft = (s, id, d) => { s.tgDraft[id] = d; };\nconst clearDraft = (s, id) => { delete s.tgDraft[id]; };\n\nfunction brandKeyboard() {\n return {\n inline_keyboard: [\n [\n { text: \"🍎 iPhone\", callback_data: \"brand:iphone\" },\n { text: \"📱 Samsung\", callback_data: \"brand:samsung\" },\n ],\n [{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }],\n ],\n };\n}\n\nfunction modelKeyboard(brand) {\n // Global indexes are kept in callback_data so the existing model: handler still works\n const items = MODEL_OPTIONS\n .map((m, i) => ({ m, i }))\n .filter(({ m }) =>\n brand === \"samsung\" ? m.startsWith(\"Samsung\") : m.startsWith(\"Iphone\")\n );\n\n const rows = [];\n for (let k = 0; k < items.length; k += 2) {\n const row = [{ text: items[k].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k].i}` }];\n if (items[k + 1]) {\n row.push({ text: items[k + 1].m.replace(/^(Iphone|Samsung) /, \"\"), callback_data: `model:${items[k + 1].i}` });\n }\n rows.push(row);\n }\n rows.push([{ text: \"◀️ Orqaga\", callback_data: \"backbrand\" }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\n// ============ COMMANDS ============\nasync function cmdStart(chatId) {\n await sendMessage(\n chatId,\n \"📱 Telefon Baza\\n\\n\" +\n \"Pastdagi tugmalar orqali boshqaring:\\n\\n\" +\n \"➕ Qo'shish — yangi telefon kiritish\\n\" +\n \"🔍 Qidirish — IMEI yoki model bo'yicha\\n\" +\n \"📋 Ro'yxat — so'nggi telefonlar\\n\" +\n \"📦 Omborda — sotilmagan telefonlar\\n\" +\n \"📊 Statistika — umumiy tahlil\\n\" +\n \"🏷 Sotildi — omborda turganini sotilgan deb belgilash\\n\" +\n \"📁 Partiya — partiya holati va yakunlash\\n\" +\n \"💾 Excel — partiyani fayl qilib olish\\n\" +\n \"✏️ Tahrirlash — kiritilgan ma'lumotni tuzatish\\n\" +\n \"🗑 O'chirish — telefonni ro'yxatdan olib tashlash\\n\" +\n \"🚚 Junatish — har partiyaning junatish summasi alohida\\n\" +\n \"🔢 IMEI ro'yxat — partiyaning model + IMEI ro'yxati\\n\\n\" +\n \"Har kuni 21:00 da avtomatik hisobot keladi.\\n/hisobot — hozir ko'rish\",\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\nasync function cmdAdd(state, chatId) {\n setDraft(state, chatId, { step: \"imei\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"➕ Yangi telefon\\n\\nIMEI raqamini yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function cmdSearch(state, chatId) {\n setDraft(state, chatId, { step: \"search\", data: {} });\n await saveState(state);\n await sendMessage(chatId, \"🔍 IMEI, model yoki sana yuboring:\", {\n reply_markup: { inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]] },\n });\n}\n\nasync function runSearch(state, chatId, query) {\n const q = query.trim().toLowerCase();\n const found = state.phones.filter((p) =>\n `${p.imei || \"\"} ${p.model || \"\"} ${p.sana || \"\"}`.toLowerCase().includes(q)\n );\n\n if (found.length === 0) {\n await sendMessage(chatId, `🔍 \"${query}\" bo'yicha hech narsa topilmadi.`);\n return;\n }\n\n const shown = found.slice(0, 8);\n let msg = `🔍 ${found.length} ta topildi` + (found.length > 8 ? \" (birinchi 8 tasi)\" : \"\") + divider();\n msg += shown.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n await sendMessage(chatId, msg);\n}\n\nfunction batchStats(state, items) {\n let sold = 0, profit = 0, stock = 0, cost = 0, ship = 0, buyWon = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n ship += Number(p.junat) || 0;\n buyWon += Number(p.sotib) || 0;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n return { sold, profit, stock, cost, ship, buyWon };\n}\n\nfunction batchSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `list:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📋 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `📋 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n return;\n }\n\n const t = batchStats(state, items);\n const shown = Math.min(12, items.length);\n const list = items.slice(0, shown);\n\n let msg = `📋 Partiya ${target}` + divider();\n msg += `📱 ${items.length} ta · 📦 omborda ${t.stock}\\n`;\n msg += `💵 Sotib olindi: ${fmtWon(t.buyWon)} (~${fmtUsd(t.buyWon / rateForBatch(state, target))})\\n`;\n msg += `🚚 Junatish: ${fmtUsd(t.ship)}\\n`;\n msg += `📉 Opshiy harajat: ${fmtUsd(t.cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(t.sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(t.profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, target)} ₩/$`;\n\n msg += divider();\n msg += list.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n\n if (items.length > shown) {\n msg += divider() + `...yana ${items.length - shown} ta. Hammasini 💾 Excel orqali oling.`;\n }\n\n msg += divider() + `Bazada jami: ${state.phones.length} ta`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: batchSelectorRows(state, target) },\n });\n}\n\nasync function cmdStock(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda telefon yo'q — hammasi sotilgan! ✅\");\n return;\n }\n\n let totalCost = 0;\n stock.forEach((p) => { totalCost += compute(state, p).opshiy; });\n\n const byModel = {};\n stock.forEach((p) => { byModel[p.model] = (byModel[p.model] || 0) + 1; });\n\n let msg = `📦 Omborda: ${stock.length} ta\\n`;\n msg += `Jami tannarx: ${fmtUsd(totalCost)}` + divider();\n msg += Object.entries(byModel)\n .sort((a, b) => b[1] - a[1])\n .map(([m, n]) => `• ${m} — ${n} ta`)\n .join(\"\\n\");\n\n if (stock.length <= 6) {\n msg += divider() + stock.map((p, i) => phoneCard(state, p, i + 1)).join(divider());\n }\n await sendMessage(chatId, msg);\n}\n\nasync function cmdStats(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📊 Hali ma'lumot yo'q.\");\n return;\n }\n\n let totalProfit = 0, totalSold = 0, soldCount = 0, stockCount = 0, totalCost = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n totalCost += c.opshiy;\n if (c.sold) { totalProfit += c.foyda; totalSold += p.sotildi; soldCount++; }\n else stockCount++;\n });\n\n // Per-model analysis\n const byModel = {};\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (!byModel[p.model]) byModel[p.model] = { count: 0, sold: 0, profit: 0 };\n const g = byModel[p.model];\n g.count++;\n if (c.sold) { g.sold++; g.profit += c.foyda; }\n });\n const topModels = Object.entries(byModel)\n .map(([m, g]) => ({ model: m, ...g, avg: g.sold ? g.profit / g.sold : 0 }))\n .sort((a, b) => b.profit - a.profit)\n .slice(0, 5);\n\n // Per-batch profit\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n byBatch[b] = (byBatch[b] || 0) + compute(state, p).foyda;\n });\n\n let msg = `📊 Umumiy statistika` + divider();\n msg += `📱 Jami telefon: ${state.phones.length}\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount}\\n`;\n msg += `💰 Jami sotildi: ${fmtUsd(totalSold)}\\n`;\n msg += `💵 Jami tannarx: ${fmtUsd(totalCost)}\\n`;\n msg += `📈 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n msg += divider() + `🏆 Eng foydali modellar\\n`;\n msg += topModels\n .map((m, i) => `${i + 1}. ${m.model}\\n ${m.sold}/${m.count} sotilgan · foyda ${fmtUsd(m.profit)}`)\n .join(\"\\n\");\n\n msg += divider() + `📁 Partiya bo'yicha foyda\\n`;\n msg += Object.entries(byBatch)\n .sort((a, b) => Number(a[0]) - Number(b[0]))\n .map(([b, v]) => `Partiya ${b}: ${fmtUsd(v)}`)\n .join(\"\\n\");\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdMarkSold(state, chatId) {\n const stock = state.phones.filter((p) => !isSold(p));\n if (stock.length === 0) {\n await sendMessage(chatId, \"📦 Omborda sotilmagan telefon yo'q.\");\n return;\n }\n const rows = stock.slice(0, 20).map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `sell:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🏷 Qaysi telefon sotildi?\", { reply_markup: { inline_keyboard: rows } });\n}\n\n// Field labels shown in the edit menu, mapped to the stored property\nconst EDIT_FIELDS = [\n { key: \"imei\", label: \"IMEI\", type: \"text\" },\n { key: \"model\", label: \"Model\", type: \"model\" },\n { key: \"yomkost\", label: \"Yomkost (%)\", type: \"number\" },\n { key: \"sotib\", label: \"Sotib olindi (₩)\", type: \"number\" },\n { key: \"junat\", label: \"Junatildi ($)\", type: \"number\" },\n { key: \"sotildi\", label: \"Sotildi ($)\", type: \"number\" },\n { key: \"sana\", label: \"Sana\", type: \"text\" },\n { key: \"batch\", label: \"Partiya\", type: \"number\" },\n];\n\nasync function cmdEdit(state, chatId) {\n const last = state.phones.slice(0, 20);\n if (last.length === 0) {\n await sendMessage(chatId, \"✏️ Tahrirlash uchun telefon yo'q.\");\n return;\n }\n const rows = last.map((p) => [\n { text: `${p.model} — ${p.imei}`, callback_data: `edit:${p.id}` },\n ]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"✏️ Qaysi telefonni tahrirlaysiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nfunction editFieldKeyboard(id) {\n const rows = [];\n for (let i = 0; i < EDIT_FIELDS.length; i += 2) {\n const row = [{ text: EDIT_FIELDS[i].label, callback_data: `ef:${id}:${EDIT_FIELDS[i].key}` }];\n if (EDIT_FIELDS[i + 1]) row.push({ text: EDIT_FIELDS[i + 1].label, callback_data: `ef:${id}:${EDIT_FIELDS[i + 1].key}` });\n rows.push(row);\n }\n rows.push([{ text: \"✖️ Yopish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\nasync function cmdBatch(state, chatId) {\n const items = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let sold = 0, profit = 0, stock = 0, cost = 0;\n items.forEach((p) => {\n const c = compute(state, p);\n cost += c.opshiy;\n if (c.sold) { sold += p.sotildi; profit += c.foyda; } else stock++;\n });\n\n let msg = `📁 Joriy partiya: ${state.currentBatch}` + divider();\n msg += `📱 Telefon: ${items.length} ta\\n`;\n msg += `📦 Omborda: ${stock} ta\\n`;\n msg += `💵 Tannarx: ${fmtUsd(cost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(sold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(profit)}\\n`;\n msg += `💱 Kurs: ${rateForBatch(state, state.currentBatch)} ₩/$`;\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [{ text: \"✅ Partiyani yakunlash\", callback_data: \"closebatch\" }],\n [{ text: \"💱 Kursni o'zgartirish\", callback_data: \"setrate\" }],\n ],\n },\n });\n}\n\nasync function cmdImeiList(state, chatId, batchNum = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🔢 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = batchNum !== null ? batchNum : state.currentBatch;\n const items = state.phones.filter((p) => (p.batch || 1) === target);\n\n if (items.length === 0) {\n await sendMessage(chatId, `🔢 Partiya ${target} bo'sh.`, {\n reply_markup: { inline_keyboard: imeiSelectorRows(state, target) },\n });\n return;\n }\n\n // Plain lines so the whole block can be copied in one go\n const lines = items.map((p) => `${p.model} ${p.imei}`);\n\n let msg = `🔢 Partiya ${target} — IMEI ro'yxati\\n`;\n msg += `${items.length} ta` + divider();\n msg += `${lines.join(\"\\n\")}`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: imeiSelectorRows(state, target) },\n });\n}\n\nfunction imeiSelectorRows(state, activeBatch) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n const row = batches.slice(i, i + 3).map((b) => ({\n text: b === activeBatch ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `imei:${b}`,\n }));\n rows.push(row);\n }\n return rows;\n}\n\nasync function cmdShipping(state, chatId) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"🚚 Hali ma'lumot yo'q.\");\n return;\n }\n\n // Group shipping cost by batch so each batch is accounted for on its own\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) byBatch[b] = { count: 0, junat: 0, sold: 0, stock: 0 };\n const g = byBatch[b];\n g.count++;\n g.junat += Number(p.junat) || 0;\n if (isSold(p)) g.sold++; else g.stock++;\n });\n\n const rows = Object.entries(byBatch)\n .map(([b, g]) => ({ batch: Number(b), ...g }))\n .sort((a, b) => b.batch - a.batch);\n\n const grandTotal = rows.reduce((s, r) => s + r.junat, 0);\n const grandCount = rows.reduce((s, r) => s + r.count, 0);\n\n let msg = `🚚 Junatish xarajatlari` + divider();\n\n msg += rows\n .map((r) => {\n const avg = r.count ? r.junat / r.count : 0;\n const mark = r.batch === state.currentBatch ? \" 🔹\" : \"\";\n return (\n `Partiya ${r.batch}${mark}\\n` +\n `├ Telefon: ${r.count} ta\\n` +\n `├ O'rtacha: ${fmtUsd(avg)} / dona\\n` +\n `└ Jami junatish: ${fmtUsd(r.junat)}`\n );\n })\n .join(\"\\n\\n\");\n\n msg += divider();\n msg += `UMUMIY\\n`;\n msg += `${rows.length} ta partiya · ${grandCount} ta telefon\\n`;\n msg += `Jami junatish: ${fmtUsd(grandTotal)}`;\n\n await sendMessage(chatId, msg);\n}\n\nasync function cmdExport(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((a, b) => b - a);\n if (batches.length === 0) {\n await sendMessage(chatId, \"💾 Eksport uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `csv:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"csv:all\" }]);\n await sendMessage(chatId, \"💾 Qaysi partiyani yuklab olasiz?\", { reply_markup: { inline_keyboard: rows } });\n}\n\nfunction buildCsv(state, items) {\n const headers = [\"Sana\", \"Imei\", \"Model\", \"Yomkost(%)\", \"Sotib olindi(W)\", \"Sotib olindi($)\", \"Junatildi($)\", \"Opshiy($)\", \"Sotildi($)\", \"Foyda($)\", \"Kurs\", \"Holat\"];\n const esc = (v) => {\n const s = String(v);\n return /[\",\\n]/.test(s) ? '\"' + s.replace(/\"/g, '\"\"') + '\"' : s;\n };\n const lines = [headers.map(esc).join(\",\")];\n items.forEach((p) => {\n const c = compute(state, p);\n lines.push([\n p.sana, p.imei, p.model, p.yomkost, p.sotib,\n c.sotibUsd.toFixed(2), (p.junat || 0).toFixed(2), c.opshiy.toFixed(2),\n c.sold ? p.sotildi.toFixed(2) : \"\", c.sold ? c.foyda.toFixed(2) : \"\",\n c.rate, c.sold ? \"Sotilgan\" : \"Omborda\",\n ].map(esc).join(\",\"));\n });\n return \"\\uFEFF\" + lines.join(\"\\r\\n\");\n}\n\n// ============ DRAFT FLOW ============\nasync function handleDraftText(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\n // Search flow\n if (draft.step === \"search\") {\n clearDraft(state, chatId);\n await saveState(state);\n await runSearch(state, chatId, text);\n return true;\n }\n\n // Applying a new value to a field being edited\n if (draft.step === \"editvalue\") {\n const { id, field } = draft.data;\n const idx = state.phones.findIndex((p) => p.id === id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n let value;\n if (meta.type === \"number\") {\n value = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(value)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n } else {\n value = text.trim();\n if (!value) { await sendMessage(chatId, \"❌ Bo'sh bo'lmasin:\"); return true; }\n }\n\n state.phones[idx][field] = value;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(\n chatId,\n `✅ ${meta.label} yangilandi.` + divider() + phoneCard(state, state.phones[idx]),\n { reply_markup: editFieldKeyboard(id) }\n );\n return true;\n }\n\n // Setting a sale price for an existing stock phone\n if (draft.step === \"sellprice\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 480):\"); return true; }\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx === -1) { clearDraft(state, chatId); await saveState(state); await sendMessage(chatId, \"❌ Telefon topilmadi.\"); return true; }\n state.phones[idx].sotildi = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Sotildi deb belgilandi!\\n\\n` + phoneCard(state, state.phones[idx]));\n return true;\n }\n\n // Changing the current batch rate\n if (draft.step === \"rate\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) { await sendMessage(chatId, \"❌ Kursni raqam bilan kiriting (masalan: 1430):\"); return true; }\n state.batchRates[state.currentBatch] = v;\n state.lastRate = v;\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, `✅ Partiya ${state.currentBatch} kursi ${v} ₩/$ qilib belgilandi.`);\n return true;\n }\n\n // --- Add-phone flow ---\n if (draft.step === \"imei\") {\n const imei = text.trim();\n if (!imei) { await sendMessage(chatId, \"❌ IMEI bo'sh bo'lmasin. Qayta yuboring:\"); return true; }\n const dup = state.phones.find((p) => (p.imei || \"\").trim() === imei);\n draft.data.imei = imei;\n draft.step = \"model\";\n setDraft(state, chatId, draft);\n await saveState(state);\n const warn = dup\n ? `⚠️ Diqqat: bu IMEI allaqachon bor\\n(${dup.model}, Partiya ${dup.batch || 1}, ${dup.sana})\\n\\n`\n : \"\";\n await sendMessage(chatId, warn + \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return true;\n }\n\n if (draft.step === \"yomkost\") {\n const v = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 85):\"); return true; }\n draft.data.yomkost = v;\n draft.step = \"sotib\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"💵 Sotib olindi narxi (₩):\");\n return true;\n }\n\n if (draft.step === \"sotib\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.sotib = v;\n draft.step = \"junat\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🚚 Junatildi narxi ($):\");\n return true;\n }\n\n if (draft.step === \"junat\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting:\"); return true; }\n draft.data.junat = v;\n draft.step = \"sotildi\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(chatId, \"🏷 Sotildi narxi ($):\\n\\nHali sotilmagan bo'lsa — 0 yuboring yoki tugmani bosing.\", {\n reply_markup: { inline_keyboard: [[{ text: \"📦 Hali sotilmagan\", callback_data: \"notsold\" }]] },\n });\n return true;\n }\n\n if (draft.step === \"sotildi\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) { await sendMessage(chatId, \"❌ Raqam kiriting (yoki 0):\"); return true; }\n await finalizeAdd(state, chatId, v);\n return true;\n }\n\n return false;\n}\n\nasync function finalizeAdd(state, chatId, sotildi) {\n const draft = getDraft(state, chatId);\n if (!draft) return;\n const p = {\n id: genId(),\n sana: todayStr(),\n imei: draft.data.imei,\n model: draft.data.model,\n yomkost: draft.data.yomkost,\n sotib: draft.data.sotib,\n junat: draft.data.junat,\n sotildi: sotildi,\n batch: state.currentBatch,\n addedBy: userName(chatId),\n };\n state.phones.unshift(p);\n clearDraft(state, chatId);\n const ok = await saveState(state);\n\n if (!ok) {\n await sendMessage(\n chatId,\n \"⚠️ Saqlanmadi!\\n\\nInternet yoki server muammosi bo'lishi mumkin. \" +\n \"Iltimos, telefonni qaytadan qo'shib ko'ring.\",\n { reply_markup: MAIN_KEYBOARD }\n );\n return;\n }\n\n const batchCount = state.phones.filter((x) => (x.batch || 1) === state.currentBatch).length;\n await sendMessage(\n chatId,\n \"✅ Qo'shildi!\" + divider() + phoneCard(state, p) + divider() +\n `Bazada jami: ${state.phones.length} ta · Partiya ${state.currentBatch}: ${batchCount} ta`,\n { reply_markup: MAIN_KEYBOARD }\n );\n}\n\n// ============ CALLBACKS ============\nasync function handleCallback(state, chatId, data, cbId) {\n if (data === \"cancel\") {\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, \"Bekor qilindi\");\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n return;\n }\n\n if (data.startsWith(\"imei:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdImeiList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"list:\")) {\n const b = parseInt(data.split(\":\")[1]);\n await answerCallback(cbId, `Partiya ${b}`);\n await cmdList(state, chatId, b);\n return;\n }\n\n if (data.startsWith(\"brand:\")) {\n const brand = data.split(\":\")[1];\n const draft = getDraft(state, chatId);\n if (!draft || (draft.step !== \"model\" && draft.step !== \"editmodel\")) {\n await answerCallback(cbId, \"Bu amal eskirgan\");\n return;\n }\n await answerCallback(cbId, brand === \"samsung\" ? \"Samsung\" : \"iPhone\");\n await sendMessage(chatId, \"📱 Modelni tanlang:\", { reply_markup: modelKeyboard(brand) });\n return;\n }\n\n if (data === \"backbrand\") {\n await answerCallback(cbId, \"\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n if (data.startsWith(\"model:\")) {\n const model = MODEL_OPTIONS[parseInt(data.split(\":\")[1])];\n const draft = getDraft(state, chatId);\n\n // Same picker is reused when editing an existing phone's model\n if (draft && draft.step === \"editmodel\") {\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx !== -1) state.phones[idx].model = model;\n const id = draft.data.id;\n clearDraft(state, chatId);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `✅ Model ${model} qilib o'zgartirildi.` + divider() + phoneCard(state, state.phones[idx]), {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (!draft || draft.step !== \"model\") { await answerCallback(cbId, \"Bu amal eskirgan\"); return; }\n draft.data.model = model;\n draft.step = \"yomkost\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await answerCallback(cbId, model);\n await sendMessage(chatId, `📱 Model: ${model}\\n\\n🔋 Yomkost foizi:`);\n return;\n }\n\n if (data === \"notsold\") {\n await answerCallback(cbId, \"Omborda deb belgilandi\");\n await finalizeAdd(state, chatId, 0);\n return;\n }\n\n if (data.startsWith(\"edit:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Maydonni tanlang\");\n await sendMessage(chatId, \"✏️ Tahrirlash\" + divider() + phoneCard(state, p) + \"\\n\\nQaysi maydonni o'zgartirasiz?\", {\n reply_markup: editFieldKeyboard(id),\n });\n return;\n }\n\n if (data.startsWith(\"ef:\")) {\n const [, id, field] = data.split(\":\");\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n const meta = EDIT_FIELDS.find((f) => f.key === field);\n\n if (meta.type === \"model\") {\n setDraft(state, chatId, { step: \"editmodel\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Model tanlang\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", { reply_markup: brandKeyboard() });\n return;\n }\n\n setDraft(state, chatId, { step: \"editvalue\", data: { id, field } });\n await saveState(state);\n await answerCallback(cbId, meta.label);\n await sendMessage(chatId, `✏️ ${meta.label}\\n\\nHozirgi qiymat: ${p[field] ?? \"—\"}\\n\\nYangi qiymatni yuboring:`);\n return;\n }\n\n if (data.startsWith(\"sell:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n setDraft(state, chatId, { step: \"sellprice\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Narxni kiriting\");\n await sendMessage(chatId, `🏷 ${p.model}\\n${p.imei}\\n\\nSotuv narxini kiriting ($):`);\n return;\n }\n\n if (data.startsWith(\"del:\")) {\n const id = data.split(\":\")[1];\n const p = state.phones.find((x) => x.id === id);\n if (!p) { await answerCallback(cbId, \"Topilmadi\"); return; }\n await answerCallback(cbId, \"Tasdiqlang\");\n await sendMessage(chatId, `🗑 ${p.model}\\n${p.imei}\\n\\nO'chirilsinmi?`, {\n reply_markup: {\n inline_keyboard: [[\n { text: \"✅ Ha, o'chirish\", callback_data: `delyes:${id}` },\n { text: \"✖️ Bekor\", callback_data: \"cancel\" },\n ]],\n },\n });\n return;\n }\n\n if (data.startsWith(\"delyes:\")) {\n const id = data.split(\":\")[1];\n const idx = state.phones.findIndex((x) => x.id === id);\n if (idx !== -1) {\n const removed = state.phones[idx];\n state.phones.splice(idx, 1);\n await saveState(state);\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(chatId, `🗑 O'chirildi: ${removed.model} (${removed.imei})`);\n } else await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n\n if (data === \"closebatch\") {\n state.currentBatch = (state.currentBatch || 1) + 1;\n await saveState(state);\n await answerCallback(cbId, \"Yakunlandi\");\n await sendMessage(chatId, `✅ Partiya yakunlandi.\\n\\n📁 Yangi joriy partiya: ${state.currentBatch}`);\n return;\n }\n\n if (data === \"setrate\") {\n setDraft(state, chatId, { step: \"rate\", data: {} });\n await saveState(state);\n await answerCallback(cbId, \"Kursni kiriting\");\n await sendMessage(chatId, `💱 Partiya ${state.currentBatch} uchun yangi kursni kiriting (₩/$):`);\n return;\n }\n\n if (data.startsWith(\"csv:\")) {\n const which = data.split(\":\")[1];\n const items = which === \"all\"\n ? state.phones\n : state.phones.filter((p) => String(p.batch || 1) === which);\n if (items.length === 0) { await answerCallback(cbId, \"Bo'sh\"); return; }\n await answerCallback(cbId, \"Tayyorlanmoqda...\");\n const csv = buildCsv(state, items);\n const name = which === \"all\" ? \"telefon-baza-hammasi.csv\" : `partiya-${which}.csv`;\n let profit = 0;\n items.forEach((p) => { profit += compute(state, p).foyda; });\n await sendDocument(chatId, name, csv,\n `💾 ${which === \"all\" ? \"Hammasi\" : \"Partiya \" + which}\\n${items.length} ta telefon · foyda ${fmtUsd(profit)}`);\n return;\n }\n\n await answerCallback(cbId);\n}\n\n// ============ DAILY REPORT ============\n// Exported separately so a Val Town Cron trigger can call it on a schedule.\nexport async function dailyReport() {\n const state = await loadState();\n const today = todayStr();\n\n const addedToday = state.phones.filter((p) => p.sana === today);\n\n let totalProfit = 0, stockCount = 0, stockCost = 0, soldCount = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) { totalProfit += c.foyda; soldCount++; }\n else { stockCount++; stockCost += c.opshiy; }\n });\n\n // Current batch snapshot\n const batchItems = state.phones.filter((p) => (p.batch || 1) === state.currentBatch);\n let batchProfit = 0, batchStock = 0;\n batchItems.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) batchProfit += c.foyda; else batchStock++;\n });\n\n let msg = `🌙 Kunlik hisobot\\n${today}` + divider();\n\n if (addedToday.length > 0) {\n let todayProfit = 0;\n addedToday.forEach((p) => { todayProfit += compute(state, p).foyda; });\n msg += `📥 Bugun qo'shildi: ${addedToday.length} ta\\n`;\n msg += `📈 Bugungi foyda: ${fmtUsd(todayProfit)}\\n`;\n msg += addedToday.slice(0, 5).map((p) => ` • ${p.model}`).join(\"\\n\");\n if (addedToday.length > 5) msg += `\\n • ...yana ${addedToday.length - 5} ta`;\n } else {\n msg += `📥 Bugun yangi telefon qo'shilmadi.`;\n }\n\n msg += divider();\n msg += `📁 Partiya ${state.currentBatch}\\n`;\n msg += ` ${batchItems.length} ta · omborda ${batchStock} · foyda ${fmtUsd(batchProfit)}`;\n\n msg += divider();\n msg += `Umumiy holat\\n`;\n msg += `📱 Jami: ${state.phones.length} ta\\n`;\n msg += `✅ Sotilgan: ${soldCount}\\n`;\n msg += `📦 Omborda: ${stockCount} ta (${fmtUsd(stockCost)})\\n`;\n msg += `💰 Jami foyda: ${fmtUsd(totalProfit)}`;\n\n // Phones sitting in stock for a long time are dead capital worth flagging\n const now = new Date();\n const stale = state.phones.filter((p) => {\n if (isSold(p)) return false;\n const d = new Date(p.sana);\n if (isNaN(d.getTime())) return false;\n return (now - d) / 86400000 > 60;\n });\n if (stale.length > 0) {\n msg += divider();\n msg += `⚠️ 60 kundan ko'p omborda: ${stale.length} ta\\n`;\n msg += stale.slice(0, 5).map((p) => ` • ${p.model} — ${p.sana}`).join(\"\\n\");\n }\n\n for (const id of ALLOWED_CHAT_IDS) {\n try { await sendMessage(id, msg); } catch (e) { console.error(\"report failed for\", id, e); }\n }\n\n return new Response(\"report sent\");\n}\n\n// ============ ENTRY POINT ============\nexport default async function (req) {\n if (req.method !== \"POST\") {\n return new Response(\"Telefon baza boti ishlayapti.\", { status: 200 });\n }\n\n let update;\n try { update = await req.json(); } catch { return new Response(\"ok\"); }\n\n try {\n if (update.message) {\n const msg = update.message;\n const chatId = msg.chat.id;\n\n if (!isAllowed(chatId)) {\n await sendMessage(chatId, \"⛔️ Bu bot faqat ruxsat berilgan foydalanuvchilar uchun.\");\n return new Response(\"ok\");\n }\n\n const text = (msg.text || \"\").trim();\n const state = await loadState();\n\n // Menu buttons and slash commands both map to the same actions\n if (text === \"/start\" || text === \"/menu\") await cmdStart(chatId);\n else if (text === \"/qoshish\" || text === \"➕ Qo'shish\") await cmdAdd(state, chatId);\n else if (text === \"/qidirish\" || text === \"🔍 Qidirish\") await cmdSearch(state, chatId);\n else if (text === \"/royxat\" || text === \"📋 Ro'yxat\") await cmdList(state, chatId);\n else if (text === \"/omborda\" || text === \"📦 Omborda\") await cmdStock(state, chatId);\n else if (text === \"/statistika\" || text === \"📊 Statistika\") await cmdStats(state, chatId);\n else if (text === \"/sotildi\" || text === \"🏷 Sotildi\") await cmdMarkSold(state, chatId);\n else if (text === \"/partiya\" || text === \"📁 Partiya\") await cmdBatch(state, chatId);\n else if (text === \"/excel\" || text === \"💾 Excel\") await cmdExport(state, chatId);\n else if (text === \"/junatish\" || text === \"🚚 Junatish\") await cmdShipping(state, chatId);\n else if (text === \"/imei\" || text === \"🔢 IMEI ro'yxat\") await cmdImeiList(state, chatId);\n else if (text === \"/tahrirlash\" || text === \"✏️ Tahrirlash\") await cmdEdit(state, chatId);\n else if (text === \"/hisobot\") await dailyReport();\n else if (text === \"/ochirish\" || text === \"🗑 O'chirish\") {\n const last = state.phones.slice(0, 15);\n if (last.length === 0) await sendMessage(chatId, \"Ro'yxat bo'sh.\");\n else {\n const rows = last.map((p) => [{ text: `${p.model} — ${p.imei}`, callback_data: `del:${p.id}` }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n await sendMessage(chatId, \"🗑 O'chiriladigan telefonni tanlang:\", { reply_markup: { inline_keyboard: rows } });\n }\n }\n else if (text === \"/bekor\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", { reply_markup: MAIN_KEYBOARD });\n }\n else {\n const handled = await handleDraftText(state, chatId, text);\n if (!handled) {\n // Anything else is treated as a quick search — fastest path when checking a phone\n await runSearch(state, chatId, text);\n }\n }\n } else if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n if (!isAllowed(chatId)) { await answerCallback(cq.id, \"Ruxsat yo'q\"); return new Response(\"ok\"); }\n const state = await loadState();\n await handleCallback(state, chatId, cq.data, cq.id);\n }\n } catch (err) {\n console.error(err);\n }\n\n return new Response(\"ok\");\n}",[173],"pulls","branches","forks","envVars",{"_186":62,"_188":62},"connections",{"_186":62,"_187":62},"count","unfilledCount","emptyCount",{"_43":172,"_32":173,"_30":174,"_135":-5,"_41":42,"_40":175,"_137":58,"_38":211,"_13":139,"_33":140,"_35":177,"_24":25,"_142":-5,"_196":212,"_27":213},{"_43":163,"_32":164,"_30":165,"_135":-5,"_41":42,"_40":166,"_137":58,"_38":208,"_13":168,"_33":169,"_35":170,"_24":25,"_142":-5,"_196":209,"_27":210},{"_43":159,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_137":25,"_38":205,"_13":161,"_33":34,"_35":37,"_24":25,"_142":-5,"_196":206,"_27":207},{"_43":152,"_32":153,"_30":154,"_135":-5,"_41":42,"_40":155,"_137":58,"_38":202,"_13":139,"_33":140,"_35":157,"_24":25,"_142":-5,"_196":203,"_27":204},{"_43":144,"_32":145,"_30":146,"_135":-5,"_41":42,"_40":147,"_137":25,"_38":199,"_13":149,"_33":34,"_35":150,"_24":25,"_142":-5,"_196":200,"_27":201},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":58,"_38":195,"_13":139,"_33":140,"_35":141,"_24":25,"_142":-5,"_196":197,"_27":198},["D",1787908300632],"children",[],[133],["D",1787878794883],[],[145],["D",1787940473182],[],[153],["D",1787997845604],[],[28],["D",1787638337583],[],[164],["D",1787996061398],[],[173],["D",1787638223825],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":251,"_252":253,"_254":255,"_256":25,"_257":25,"_258":25,"_259":58,"_260":-5,"_261":-7,"_262":-7,"_263":62,"_264":25,"_265":25,"_266":-5,"_267":25,"_268":25,"_269":25,"_270":-5},"ENV",{"_222":223,"_224":225,"_226":86,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v45