[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","sindorsuyarov","name","Telefonbaza","path","new-file-3175.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/sindorsuyarov/Telefonbaza/code/new-file-3175.ts","extension","id","7bba1a44-e71c-456c-aaf6-f6a074e3cfaf","fileId","f0705286-a04b-11f1-b6c3-1607ee4eb77e","parentId","branchId","17503bab-2fab-4c31-9a31-624c24325c05","branchVersion",117,"latest",true,"createdAt",["D",1788969616787],"version",31,"fileType","http","content","const 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 =\n \"$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\nimport { blob } from \"https://esm.town/v/std/blob\";\nconst XARAJAT_KEY = \"xarajat_bazasi\";\n\nconst SCAN_URL =\n \"https://telefonbaza.suyarovsindor200510.workers.dev/scan.html\";\n\nconst MODEL_OPTIONS = [\n \"Iphone 13pro/128\",\n \"Iphone 13pro/256\",\n \"Iphone 13pro/512\",\n \"Iphone 13promax/128\",\n \"Iphone 13promax/256\",\n \"Iphone 13promax/512\",\n \"Iphone 14pro/128\",\n \"Iphone 14pro/256\",\n \"Iphone 14pro/512\",\n \"Iphone 14promax/128\",\n \"Iphone 14promax/256\",\n \"Iphone 14promax/512\",\n \"Iphone 15pro/128\",\n \"Iphone 15pro/256\",\n \"Iphone 15pro/512\",\n \"Iphone 15promax/128\",\n \"Iphone 15promax/256\",\n \"Iphone 15promax/512\",\n \"Iphone 16pro/128\",\n \"Iphone 16pro/256\",\n \"Iphone 16pro/512\",\n \"Iphone 16promax/128\",\n \"Iphone 16promax/256\",\n \"Iphone 16promax/512\",\n \"Iphone 17pro/128\",\n \"Iphone 17pro/256\",\n \"Iphone 17pro/512\",\n \"Iphone 17promax/128\",\n \"Iphone 17promax/256\",\n \"Iphone 17promax/512\",\n \"Samsung S22/256\",\n \"Samsung S22/512\",\n \"Samsung S22ultra/256\",\n \"Samsung S22ultra/512\",\n \"Samsung S23/256\",\n \"Samsung S23/512\",\n \"Samsung S23ultra/256\",\n \"Samsung S23ultra/512\",\n \"Samsung S24/256\",\n \"Samsung S24/512\",\n \"Samsung S24ultra/256\",\n \"Samsung S24ultra/512\",\n \"Samsung S25/256\",\n \"Samsung S25/512\",\n \"Samsung S25ultra/256\",\n \"Samsung S25ultra/512\",\n \"Samsung S26/256\",\n \"Samsung S26/512\",\n \"Samsung S26ultra/256\",\n \"Samsung S26ultra/512\",\n];\n\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\", {\n chat_id: chatId,\n text,\n parse_mode: \"HTML\",\n ...extra,\n });\n}\n\nfunction answerCallback(id, text = \"\") {\n return tg(\"answerCallbackQuery\", { callback_query_id: id, text });\n}\n\nasync function sendDocument(\n chatId,\n filename,\n content,\n caption = \"\",\n mime = \"text/csv\",\n) {\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`, {\n method: \"POST\",\n body: form,\n });\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`, {\n method: \"POST\",\n body: form,\n });\n return res.json();\n}\n\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)\" }, { text: \"▣ QR yorliq\" }],\n ],\n resize_keyboard: true,\n};\n\nasync function loadState() {\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 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 for (let attempt = 0; attempt < 3; attempt++) {\n try {\n const res = await fetch(JSONBIN_URL, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"X-Master-Key\": JSONBIN_KEY,\n },\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) {\n await new Promise((r) => setTimeout(r, 400 * (attempt + 1)));\n }\n }\n return false;\n}\n\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\") + \"₩\";\nconst todayStr = () =>\n new Date(Date.now() + 9 * 3600 * 1000).toISOString().slice(0, 10);\nconst genId = () =>\n Date.now().toString(36) + Math.random().toString(36).slice(2, 8);\n\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}${\n p.addedBy ? \" · \" + p.addedBy : \"\"\n }\\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\nconst getDraft = (s, id) => s.tgDraft[id] || null;\nconst setDraft = (s, id, d) => {\n s.tgDraft[id] = d;\n};\nconst clearDraft = (s, id) => {\n delete s.tgDraft[id];\n};\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 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 = [{\n text: items[k].m.replace(/^(Iphone|Samsung) /, \"\"),\n callback_data: `model:${items[k].i}`,\n }];\n if (items[k + 1]) {\n row.push({\n text: items[k + 1].m.replace(/^(Iphone|Samsung) /, \"\"),\n callback_data: `model:${items[k + 1].i}`,\n });\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\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 \"▣ QR yorliq — qutilarga yopishtirish uchun chop etsa bo'ladigan yorliqlar\\n\\n\" +\n \"📷 Shtrix-kod: IMEI kodining rasmini yuborsangiz, bot raqamni o'zi o'qiydi.\\n\" +\n \"Har kuni 20:00 da avtomatik hisobot keladi.\\n/hisobot — hozir ko'rish\",\n { reply_markup: MAIN_KEYBOARD },\n );\n}\n\nconst IMEI_KEYBOARD = {\n keyboard: [\n [{ text: \"📷 Rasmga olish\", web_app: { url: SCAN_URL } }],\n [{ text: \"✖️ Bekor qilish\" }],\n ],\n resize_keyboard: true,\n};\n\nasync function cmdAdd(state, chatId) {\n setDraft(state, chatId, { step: \"imei\", data: {} });\n await saveState(state);\n await sendMessage(\n chatId,\n \"➕ Yangi telefon\\n\\n\" +\n \"📷 Rasmga olish — kamerani ochib shtrix-kodni o'qiydi\\n\" +\n \"⌨️ Yoki IMEI raqamini shunchaki yozib yuboring\\n\" +\n \"🖼 Yoki kodning rasmini yuboring\",\n { reply_markup: IMEI_KEYBOARD },\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: {\n inline_keyboard: [[{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]],\n },\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(\n chatId,\n `🔍 \"${query}\" bo'yicha hech narsa topilmadi.`,\n );\n return;\n }\n\n const shown = found.slice(0, 8);\n let msg = `🔍 ${found.length} ta topildi` +\n (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) {\n sold += p.sotildi;\n profit += c.foyda;\n } 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((\n a,\n b,\n ) => 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)} (~${\n fmtUsd(t.buyWon / rateForBatch(state, target))\n })\\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() +\n `...yana ${\n items.length - shown\n } 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) => {\n totalCost += compute(state, p).opshiy;\n });\n\n const byModel = {};\n stock.forEach((p) => {\n byModel[p.model] = (byModel[p.model] || 0) + 1;\n });\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() +\n 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,\n totalSold = 0,\n soldCount = 0,\n stockCount = 0,\n totalCost = 0;\n state.phones.forEach((p) => {\n const c = compute(state, p);\n totalCost += c.opshiy;\n if (c.sold) {\n totalProfit += c.foyda;\n totalSold += p.sotildi;\n soldCount++;\n } else stockCount++;\n });\n\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) {\n g.sold++;\n g.profit += c.foyda;\n }\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 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) =>\n `${i + 1}. ${m.model}\\n ${m.sold}/${m.count} sotilgan · foyda ${\n fmtUsd(m.profit)\n }`\n )\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 pickPhone(state, chatId, opts) {\n const { which, filter, prefix, title, icon, emptyMsg } = opts;\n const pool = filter ? state.phones.filter(filter) : state.phones;\n\n if (!pool.length) {\n await sendMessage(chatId, emptyMsg);\n return;\n }\n\n if (which === null || which === undefined) {\n const batches = [...new Set(pool.map((p) => p.batch || 1))].sort((a, b) =>\n b - a\n );\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n rows.push(\n batches.slice(i, i + 3).map((b) => {\n const n = pool.filter((p) => (p.batch || 1) === b).length;\n return {\n text: `Partiya ${b} (${n})`,\n callback_data: `${prefix}b:${b}`,\n };\n }),\n );\n }\n rows.push([{\n text: \"🕘 So'nggi qo'shilganlar\",\n callback_data: `${prefix}b:recent`,\n }]);\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n\n await sendMessage(chatId, `${icon} ${title}\\n\\nQaysi partiyadan?`, {\n reply_markup: { inline_keyboard: rows },\n });\n return;\n }\n\n const items = which === \"recent\"\n ? pool.slice(0, 20)\n : pool.filter((p) => String(p.batch || 1) === String(which));\n\n if (!items.length) {\n await sendMessage(chatId, `${icon} Partiya ${which} bo'sh.`);\n return;\n }\n\n const shown = items.slice(0, 30);\n const rows = shown.map((p) => {\n const mark = isSold(p) ? \"✅\" : \"📦\";\n return [{\n text: `${mark} ${p.model} — ${p.imei}`,\n callback_data: `${prefix}:${p.id}`,\n }];\n });\n\n const batches = [...new Set(pool.map((p) => p.batch || 1))].sort((a, b) =>\n b - a\n );\n for (let i = 0; i < batches.length; i += 4) {\n rows.push(\n batches.slice(i, i + 4).map((b) => ({\n text: String(b) === String(which) ? `▪️ P${b}` : `P${b}`,\n callback_data: `${prefix}b:${b}`,\n })),\n );\n }\n rows.push([{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }]);\n\n const label = which === \"recent\"\n ? \"So'nggi qo'shilganlar\"\n : `Partiya ${which}`;\n const more = items.length > shown.length\n ? `\\n(${items.length} tadan birinchi 30 tasi)`\n : \"\";\n\n await sendMessage(\n chatId,\n `${icon} ${label} — ${items.length} ta${more}\\n\\n${title}`,\n { reply_markup: { inline_keyboard: rows } },\n );\n}\n\nasync function cmdMarkSold(state, chatId, which = null) {\n await pickPhone(state, chatId, {\n which,\n filter: (p) => !isSold(p),\n prefix: \"sell\",\n icon: \"🏷\",\n title: \"Qaysi telefon sotildi?\",\n emptyMsg: \"📦 Omborda sotilmagan telefon yo'q.\",\n });\n}\n\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, which = null) {\n await pickPhone(state, chatId, {\n which,\n prefix: \"edit\",\n icon: \"✏️\",\n title: \"Qaysi telefonni tahrirlaysiz?\",\n emptyMsg: \"✏️ Tahrirlash uchun telefon yo'q.\",\n });\n}\n\nfunction editFieldKeyboard(id) {\n const rows = [];\n for (let i = 0; i < EDIT_FIELDS.length; i += 2) {\n const row = [{\n text: EDIT_FIELDS[i].label,\n callback_data: `ef:${id}:${EDIT_FIELDS[i].key}`,\n }];\n if (EDIT_FIELDS[i + 1]) {\n row.push({\n text: EDIT_FIELDS[i + 1].label,\n callback_data: `ef:${id}:${EDIT_FIELDS[i + 1].key}`,\n });\n }\n rows.push(row);\n }\n rows.push([{ text: \"✖️ Yopish\", callback_data: \"cancel\" }]);\n return { inline_keyboard: rows };\n}\n\nfunction batchPickRows(state, active) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((\n a,\n b,\n ) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n rows.push(\n batches.slice(i, i + 3).map((b) => ({\n text: String(b) === String(active) ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `batch:${b}`,\n })),\n );\n }\n rows.push([{\n text: active === \"all\" ? \"▪️ 📦 Hammasi\" : \"📦 Hammasi\",\n callback_data: \"batch:all\",\n }]);\n return rows;\n}\n\nasync function cmdBatch(state, chatId, which = null) {\n if (state.phones.length === 0) {\n await sendMessage(chatId, \"📁 Ro'yxat bo'sh.\");\n return;\n }\n\n const target = which !== null ? which : String(state.currentBatch);\n\n if (target === \"all\") {\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) {\n byBatch[b] = { count: 0, stock: 0, cost: 0, sold: 0, profit: 0 };\n }\n const c = compute(state, p);\n byBatch[b].count++;\n byBatch[b].cost += c.opshiy;\n if (c.sold) {\n byBatch[b].sold += Number(p.sotildi) || 0;\n byBatch[b].profit += c.foyda;\n } else byBatch[b].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 let msg = `📁 Barcha partiyalar` + divider();\n msg += rows.map((r) => {\n const mark = r.batch === state.currentBatch ? \" 🔹\" : \"\";\n return `Partiya ${r.batch}${mark}\\n` +\n `├ Telefon: ${r.count} ta · omborda ${r.stock}\\n` +\n `├ Tannarx: ${fmtUsd(r.cost)}\\n` +\n `├ Sotildi: ${fmtUsd(r.sold)}\\n` +\n `└ Foyda: ${fmtUsd(r.profit)} (kurs ${\n rateForBatch(state, r.batch)\n })`;\n }).join(\"\\n\\n\");\n\n const tCount = rows.reduce((s, r) => s + r.count, 0);\n const tStock = rows.reduce((s, r) => s + r.stock, 0);\n const tCost = rows.reduce((s, r) => s + r.cost, 0);\n const tSold = rows.reduce((s, r) => s + r.sold, 0);\n const tProfit = rows.reduce((s, r) => s + r.profit, 0);\n\n msg += divider() + `UMUMIY\\n`;\n msg += `📱 ${tCount} ta · 📦 omborda ${tStock}\\n`;\n msg += `💵 Tannarx: ${fmtUsd(tCost)}\\n`;\n msg += `💰 Sotildi: ${fmtUsd(tSold)}\\n`;\n msg += `📈 Foyda: ${fmtUsd(tProfit)}`;\n\n await sendMessage(chatId, msg, {\n reply_markup: { inline_keyboard: batchPickRows(state, \"all\") },\n });\n return;\n }\n\n const num = Number(target);\n const items = state.phones.filter((p) => (p.batch || 1) === num);\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) {\n sold += Number(p.sotildi) || 0;\n profit += c.foyda;\n } else stock++;\n });\n\n const isCurrent = num === state.currentBatch;\n\n let msg = `📁 Partiya ${num}${isCurrent ? \" 🔹 (joriy)\" : \"\"}` +\n 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, num)} ₩/$`;\n\n const rows = [];\n if (isCurrent) {\n rows.push([{\n text: \"✅ Partiyani yakunlash\",\n callback_data: \"closebatch\",\n }]);\n rows.push([{\n text: \"🔄 Kursni avtomatik olish\",\n callback_data: \"autorate\",\n }]);\n rows.push([{\n text: \"💱 Kursni qo'lda kiritish\",\n callback_data: \"setrate\",\n }]);\n } else {\n rows.push([{\n text: `💱 Partiya ${num} kursini o'zgartirish`,\n callback_data: `setrate:${num}`,\n }]);\n }\n rows.push(...batchPickRows(state, String(num)));\n\n await sendMessage(chatId, msg, { reply_markup: { inline_keyboard: rows } });\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 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 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\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((\n a,\n b,\n ) => 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\nfunction shippingTable(state, which) {\n if (which === \"all\") {\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) byBatch[b] = { count: 0, junat: 0 };\n byBatch[b].count++;\n byBatch[b].junat += Number(p.junat) || 0;\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 .map((r) => [`Partiya ${r.batch}`, `${r.count} ta`, r.junat.toFixed(2)]);\n\n const total = rows.reduce((s, r) => s + Number(r[2]), 0);\n const count = state.phones.length;\n rows.push([\"UMUMIY\", `${count} ta`, total.toFixed(2)]);\n\n return {\n title: `Junatish xarajatlari — hammasi`,\n headers: [\"Partiya\", \"Telefon\", \"Junatildi($)\"],\n rows,\n };\n }\n\n const items = state.phones.filter((p) =>\n String(p.batch || 1) === String(which)\n );\n const rows = items.map((\n p,\n ) => [p.sana, p.model, p.imei, (Number(p.junat) || 0).toFixed(2)]);\n const total = items.reduce((s, p) => s + (Number(p.junat) || 0), 0);\n rows.push([\"JAMI\", `${items.length} ta`, \"\", total.toFixed(2)]);\n\n return {\n title: `Junatish xarajatlari — Partiya ${which}`,\n headers: [\"Sana\", \"Model\", \"Imei\", \"Junatildi($)\"],\n rows,\n };\n}\n\nfunction shippingSelectorRows(state, active) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((\n a,\n b,\n ) => b - a);\n const rows = [];\n for (let i = 0; i < batches.length; i += 3) {\n rows.push(\n batches.slice(i, i + 3).map((b) => ({\n text: String(b) === String(active) ? `▪️ Partiya ${b}` : `Partiya ${b}`,\n callback_data: `ship:${b}`,\n })),\n );\n }\n rows.push([{\n text: active === \"all\" ? \"▪️ 📦 Umumiy\" : \"📦 Umumiy\",\n callback_data: \"ship:all\",\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 await sendMessage(\n chatId,\n \"🚚 Junatish xarajatlari\\n\\nQaysi partiya?\",\n {\n reply_markup: { inline_keyboard: shippingSelectorRows(state, null) },\n },\n );\n}\n\nasync function showShipping(state, chatId, which) {\n const rate = (b) => rateForBatch(state, b);\n\n if (which === \"all\") {\n const byBatch = {};\n state.phones.forEach((p) => {\n const b = p.batch || 1;\n if (!byBatch[b]) byBatch[b] = { count: 0, junat: 0 };\n byBatch[b].count++;\n byBatch[b].junat += Number(p.junat) || 0;\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 total = rows.reduce((s, r) => s + r.junat, 0);\n const count = state.phones.length;\n\n let msg = `🚚 Junatish — umumiy` + divider();\n msg += rows.map((r) => {\n const mark = r.batch === state.currentBatch ? \" 🔹\" : \"\";\n return `Partiya ${r.batch}${mark}\\n` +\n `├ Telefon: ${r.count} ta\\n` +\n `└ Junatildi: ${fmtUsd(r.junat)}`;\n }).join(\"\\n\\n\");\n\n msg += divider() + `UMUMIY\\n`;\n msg += `${rows.length} ta partiya · ${count} ta telefon\\n`;\n msg += `Jami junatish: ${fmtUsd(total)}`;\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [\n { text: \"📊 Excel\", callback_data: \"dl:ship:all:csv\" },\n { text: \"📄 PDF\", callback_data: \"dl:ship:all:pdf\" },\n { text: \"🖼 Rasm\", callback_data: \"dl:ship:all:png\" },\n ],\n ...shippingSelectorRows(state, \"all\"),\n ],\n },\n });\n return;\n }\n\n const items = state.phones.filter((p) =>\n String(p.batch || 1) === String(which)\n );\n if (!items.length) {\n await sendMessage(chatId, `🚚 Partiya ${which} bo'sh.`, {\n reply_markup: { inline_keyboard: shippingSelectorRows(state, which) },\n });\n return;\n }\n\n const total = items.reduce((s, p) => s + (Number(p.junat) || 0), 0);\n const shown = items.slice(0, 15);\n\n let msg = `🚚 Junatish — Partiya ${which}` + divider();\n msg += `📱 ${items.length} ta telefon\\n`;\n msg += `💵 Jami junatish: ${fmtUsd(total)}\\n`;\n msg += `(~${fmtWon(total * rate(Number(which)))})`;\n\n msg += divider();\n msg += shown.map((p, i) =>\n `${i + 1}. ${p.model}\\n ${p.imei} · ${\n fmtUsd(Number(p.junat) || 0)\n }`\n ).join(\"\\n\");\n\n if (items.length > shown.length) {\n msg += `\\n\\n...yana ${\n items.length - shown.length\n } ta. Faylda hammasi bor.`;\n }\n\n await sendMessage(chatId, msg, {\n reply_markup: {\n inline_keyboard: [\n [\n { text: \"📊 Excel\", callback_data: `dl:ship:${which}:csv` },\n { text: \"📄 PDF\", callback_data: `dl:ship:${which}:pdf` },\n { text: \"🖼 Rasm\", callback_data: `dl:ship:${which}:png` },\n ],\n ...shippingSelectorRows(state, which),\n ],\n },\n });\n}\n\nasync function cmdExport(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((\n a,\n b,\n ) => 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?\", {\n reply_markup: { inline_keyboard: rows },\n });\n}\n\nasync function cmdExportClient(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((\n a,\n b,\n ) => 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\nfunction modelFromImei(state, imei) {\n const digits = String(imei || \"\").replace(/\\D/g, \"\");\n if (digits.length < 8) return null;\n\n const tac = digits.slice(0, 8);\n const counts = {};\n\n state.phones.forEach((p) => {\n const d = String(p.imei || \"\").replace(/\\D/g, \"\");\n if (d.length < 8 || !p.model) return;\n if (d.slice(0, 8) !== tac) return;\n counts[p.model] = (counts[p.model] || 0) + 1;\n });\n\n const sorted = Object.entries(counts).sort((a, b) => b[1] - a[1]);\n if (!sorted.length) return null;\n return { model: sorted[0][0], count: sorted[0][1] };\n}\n\nfunction parseWiseRate(html) {\n let m = html.match(/1\\s*KRW\\s*=\\s*([\\d.]+)\\s*USD/i);\n if (m) {\n const perKrw = parseFloat(m[1]);\n if (perKrw > 0 && perKrw < 0.01) return Math.round(1 / perKrw);\n }\n m = html.match(/1\\s*USD[^|]*\\|\\s*([\\d,]+(?:\\.\\d+)?)\\s*KRW/i);\n if (m) {\n const v = parseFloat(m[1].replace(/,/g, \"\"));\n if (v > 500 && v < 5000) return Math.round(v);\n }\n return null;\n}\n\nasync function fetchFromWise() {\n const res = await fetch(\n \"https://wise.com/gb/currency-converter/krw-to-usd-rate\",\n {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 Chrome/120\",\n \"Accept-Language\": \"en-US,en;q=0.9\",\n },\n },\n );\n if (!res.ok) throw new Error(`Wise javob bermadi (HTTP ${res.status})`);\n\n const rate = parseWiseRate(await res.text());\n if (!rate) throw new Error(\"Wise sahifasidan kurs topilmadi\");\n\n return { rate, date: todayStr(), source: \"Wise\" };\n}\n\nasync function fetchFromEcb() {\n const res = await fetch(\n \"https://api.frankfurter.app/latest?from=USD&to=KRW\",\n {\n headers: { \"Accept\": \"application/json\" },\n },\n );\n if (!res.ok) {\n throw new Error(`Zaxira manba javob bermadi (HTTP ${res.status})`);\n }\n\n const j = await res.json();\n const rate = j && j.rates && j.rates.KRW;\n if (!rate) throw new Error(\"Kurs topilmadi\");\n\n return { rate: Math.round(rate), date: j.date, source: \"ECB\" };\n}\n\nasync function fetchKrwRate() {\n const errors = [];\n for (const fn of [fetchFromWise, fetchFromEcb]) {\n try {\n return await fn();\n } catch (e) {\n errors.push(e.message);\n console.error(\"kurs manbasi:\", e.message);\n }\n }\n throw new Error(\"Kurs olinmadi: \" + errors.join(\" | \"));\n}\n\nasync function syncPhoneIncome(state, phone, opts = {}) {\n const removeOnly = !!opts.remove;\n\n try {\n const data = (await blob.getJSON(XARAJAT_KEY)) || {};\n let incomes = Array.isArray(data.incomes) ? data.incomes : [];\n\n const existing = incomes.find((x) => x.srcId === phone.id);\n const c = removeOnly ? null : compute(state, phone);\n const shouldExist = !removeOnly && c.sold && c.foyda > 0;\n\n let action = null;\n let wonAmount = 0;\n\n if (shouldExist) {\n const rate = rateForBatch(state, phone.batch || 1);\n wonAmount = Math.round(c.foyda * rate);\n\n if (existing) {\n if (\n existing.amount !== wonAmount ||\n existing.note !== `Telefon: ${phone.model}`\n ) {\n existing.amount = wonAmount;\n existing.note = `Telefon: ${phone.model}`;\n action = \"updated\";\n }\n } else {\n incomes.unshift({\n id: \"tel_\" + phone.id,\n srcId: phone.id,\n date: todayStr(),\n amount: wonAmount,\n note: `Telefon: ${phone.model}`,\n });\n action = \"added\";\n }\n } else if (existing) {\n incomes = incomes.filter((x) => x.srcId !== phone.id);\n wonAmount = existing.amount;\n action = \"removed\";\n }\n\n if (!action) return false;\n\n await blob.setJSON(XARAJAT_KEY, {\n expenses: Array.isArray(data.expenses) ? data.expenses : [],\n incomes,\n categories: Array.isArray(data.categories) ? data.categories : [],\n rate: data.rate || rateForBatch(state, phone.batch || 1),\n draft: data.draft || {},\n });\n\n return { action, won: wonAmount, usd: c ? c.foyda : 0 };\n } catch (e) {\n console.error(\"daromad moslashtirilmadi:\", e.message);\n return false;\n }\n}\n\nfunction incomeNoteText(res) {\n if (!res) return \"\";\n if (res.action === \"added\") {\n return `\\n\\n💰 Foyda daromad bo'lib yozildi: ${fmtWon(res.won)}`;\n }\n if (res.action === \"updated\") {\n return `\\n\\n💰 Daromad yangilandi: ${fmtWon(res.won)}`;\n }\n if (res.action === \"removed\") {\n return `\\n\\n↩️ Daromad xarajat botidan olib tashlandi (${\n fmtWon(res.won)\n })`;\n }\n return \"\";\n}\n\nasync function buildQrLabels(items) {\n const [Z, pdfLib] = await Promise.all([\n import(\"https://esm.sh/@zxing/library@0.21.3\"),\n import(\"https://esm.sh/pdf-lib@1.17.1\"),\n ]);\n const { PDFDocument, StandardFonts, rgb } = pdfLib;\n\n const doc = await PDFDocument.create();\n const bold = await doc.embedFont(StandardFonts.HelveticaBold);\n const font = await doc.embedFont(StandardFonts.Helvetica);\n const writer = new Z.QRCodeWriter();\n\n const W = 595, H = 842, margin = 28;\n const cols = 3;\n const cellW = (W - margin * 2) / cols;\n const cellH = 150;\n const rowsPerPage = Math.floor((H - margin * 2) / cellH);\n const perPage = cols * rowsPerPage;\n\n let page = null;\n\n items.forEach((p, idx) => {\n const pos = idx % perPage;\n if (pos === 0) page = doc.addPage([W, H]);\n\n const col = pos % cols;\n const row = Math.floor(pos / cols);\n const x0 = margin + col * cellW;\n const y0 = H - margin - (row + 1) * cellH;\n\n page.drawRectangle({\n x: x0 + 4,\n y: y0 + 4,\n width: cellW - 8,\n height: cellH - 8,\n borderColor: rgb(0.8, 0.8, 0.85),\n borderWidth: 0.8,\n });\n\n const m = writer.encode(p.imei, Z.BarcodeFormat.QR_CODE, 33, 33, new Map());\n const qrSize = 88;\n const cell = qrSize / m.getWidth();\n const qx = x0 + (cellW - qrSize) / 2;\n const qy = y0 + cellH - qrSize - 14;\n\n for (let y = 0; y < m.getHeight(); y++) {\n for (let x = 0; x < m.getWidth(); x++) {\n if (m.get(x, y)) {\n page.drawRectangle({\n x: qx + x * cell,\n y: qy + (m.getHeight() - 1 - y) * cell,\n width: cell,\n height: cell,\n color: rgb(0, 0, 0),\n });\n }\n }\n }\n\n const safe = (s) => String(s ?? \"\").replace(/[^\\x20-\\x7E]/g, \"\");\n page.drawText(safe(p.model), {\n x: x0 + 8,\n y: y0 + 34,\n size: 8,\n font: bold,\n color: rgb(0.1, 0.1, 0.18),\n });\n page.drawText(safe(p.imei), {\n x: x0 + 8,\n y: y0 + 22,\n size: 7.5,\n font,\n color: rgb(0.35, 0.35, 0.4),\n });\n });\n\n return await doc.save();\n}\n\nasync function cmdQrLabels(state, chatId) {\n const batches = [...new Set(state.phones.map((p) => p.batch || 1))].sort((\n a,\n b,\n ) => b - a);\n if (!batches.length) {\n await sendMessage(chatId, \"▣ Yorliq uchun ma'lumot yo'q.\");\n return;\n }\n const rows = batches.slice(0, 12).map((b) => [\n { text: `Partiya ${b}`, callback_data: `qr:${b}` },\n ]);\n rows.push([{ text: \"📦 Hammasi\", callback_data: \"qr:all\" }]);\n\n await sendMessage(\n chatId,\n \"▣ QR yorliqlar\\n\\n\" +\n \"Chop etib, qutilarga yopishtiring. Keyin skaner bilan o'qisangiz — telefon darhol topiladi.\\n\\n\" +\n \"Qaysi partiya?\",\n { reply_markup: { inline_keyboard: rows } },\n );\n}\n\nasync function tgFileUrl(fileId) {\n const res = await fetch(`${TG_API}/getFile?file_id=${fileId}`);\n const data = await res.json();\n if (!data.ok) throw new Error(\"Faylni olishda xatolik\");\n return `https://api.telegram.org/file/bot${BOT_TOKEN}/${data.result.file_path}`;\n}\n\nfunction rotate90(raw) {\n const { width: w, height: h, data: d } = raw;\n const out = new Uint8Array(d.length);\n for (let y = 0; y < h; y++) {\n for (let x = 0; x < w; x++) {\n const s = (y * w + x) * 4;\n const t = (x * h + (h - 1 - y)) * 4;\n out[t] = d[s];\n out[t + 1] = d[s + 1];\n out[t + 2] = d[s + 2];\n out[t + 3] = d[s + 3];\n }\n }\n return { width: h, height: w, data: out };\n}\n\nasync function scanBarcode(fileId) {\n const [jpegMod, Z] = await Promise.all([\n import(\"https://esm.sh/jpeg-js@0.4.4\"),\n import(\"https://esm.sh/@zxing/library@0.21.3\"),\n ]);\n const jpeg = jpegMod.default || jpegMod;\n\n const url = await tgFileUrl(fileId);\n const buf = new Uint8Array(await (await fetch(url)).arrayBuffer());\n\n let raw = jpeg.decode(buf, { useTArray: true });\n\n const decodeOnce = (img) => {\n const lum = new Int32Array(img.width * img.height);\n for (let i = 0, j = 0; i < lum.length; i++, j += 4) {\n lum[i] = (img.data[j] << 16) | (img.data[j + 1] << 8) | img.data[j + 2];\n }\n const src = new Z.RGBLuminanceSource(lum, img.width, img.height);\n const bmp = new Z.BinaryBitmap(new Z.HybridBinarizer(src));\n const hints = new Map();\n hints.set(Z.DecodeHintType.TRY_HARDER, true);\n const reader = new Z.MultiFormatReader();\n reader.setHints(hints);\n return reader.decode(bmp).getText();\n };\n\n for (let i = 0; i < 4; i++) {\n try {\n return decodeOnce(raw);\n } catch {\n raw = rotate90(raw);\n }\n }\n return null;\n}\n\nfunction luhnOk(s) {\n if (!/^\\d{15}$/.test(s)) return false;\n let sum = 0;\n for (let i = 0; i < 15; i++) {\n let d = +s[14 - i];\n if (i % 2 === 1) {\n d *= 2;\n if (d > 9) d -= 9;\n }\n sum += d;\n }\n return sum % 10 === 0;\n}\n\nfunction cleanImei(text) {\n const digits = (text || \"\").replace(/\\D/g, \"\");\n if (digits.length < 15) return null;\n return digits.slice(0, 15);\n}\n\nasync function handlePhoto(state, chatId, photoSizes) {\n const best = photoSizes[photoSizes.length - 1];\n await sendMessage(chatId, \"🔍 Shtrix-kod o'qilmoqda...\");\n\n let code = null;\n try {\n code = await scanBarcode(best.file_id);\n } catch (e) {\n console.error(\"scan error\", e);\n }\n\n if (!code) {\n await sendMessage(\n chatId,\n \"❌ Shtrix-kod o'qilmadi.\\n\\nKodni yaqinroqdan, yorug'roq joyda va to'g'ri burchakdan suratga oling. Yoki IMEI'ni qo'lda yozing.\",\n );\n return;\n }\n\n const imei = cleanImei(code);\n if (!imei) {\n await sendMessage(\n chatId,\n \"\\u26a0\\ufe0f Kod to'liq o'qilmadi.\\n\\nKodni yaqinroqdan, yorug'roq joyda suratga oling.\",\n );\n return;\n }\n if (!luhnOk(imei)) {\n await sendMessage(\n chatId,\n `\\u26a0\\ufe0f O'qildi: ${imei}\\n\\n` +\n `Bu raqam IMEI tekshiruvidan o'tmadi \\u2014 noto'g'ri o'qilgan bo'lishi mumkin. Tekshirib ko'ring.`,\n );\n }\n const draft = getDraft(state, chatId);\n\n if (draft && draft.step === \"imei\") {\n await handleDraftText(state, chatId, imei);\n return;\n }\n\n await sendMessage(chatId, `✅ O'qildi: ${imei}`);\n await runSearch(state, chatId, imei);\n}\n\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 `${\n which === \"all\" ? \"Hammasi\" : \"Partiya \" + which\n } — ${count} ta telefon`;\n}\n\nfunction fullTable(state, which) {\n const items = exportItems(state, which);\n\n const rows = items.map((p) => {\n const c = compute(state, p);\n return [\n p.sana,\n p.imei,\n p.model,\n p.yomkost,\n p.sotib,\n c.sotibUsd.toFixed(2),\n (p.junat || 0).toFixed(2),\n c.opshiy.toFixed(2),\n c.sold ? p.sotildi.toFixed(2) : \"\",\n c.sold ? c.foyda.toFixed(2) : \"\",\n c.rate,\n c.sold ? \"Sotilgan\" : \"Omborda\",\n ];\n });\n\n let sotibW = 0, sotibUsd = 0, junat = 0, opshiy = 0, sotildi = 0, foyda = 0;\n let soldCount = 0;\n\n items.forEach((p) => {\n const c = compute(state, p);\n sotibW += Number(p.sotib) || 0;\n sotibUsd += c.sotibUsd;\n junat += Number(p.junat) || 0;\n opshiy += c.opshiy;\n if (c.sold) {\n sotildi += Number(p.sotildi) || 0;\n foyda += c.foyda;\n soldCount++;\n }\n });\n\n rows.push([\n \"JAMI\",\n `${items.length} ta`,\n `${soldCount} sotilgan`,\n \"\",\n Math.round(sotibW),\n sotibUsd.toFixed(2),\n junat.toFixed(2),\n opshiy.toFixed(2),\n sotildi.toFixed(2),\n foyda.toFixed(2),\n \"\",\n `${items.length - soldCount} omborda`,\n ]);\n\n return {\n title: exportTitle(which, items.length),\n headers: [\n \"Sana\",\n \"Imei\",\n \"Model\",\n \"Yomkost(%)\",\n \"Sotib olindi(W)\",\n \"Sotib olindi($)\",\n \"Junatildi($)\",\n \"Opshiy($)\",\n \"Sotildi($)\",\n \"Foyda($)\",\n \"Kurs\",\n \"Holat\",\n ],\n rows,\n };\n}\n\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\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(\n \"https://esm.sh/pdf-lib@1.17.1\"\n );\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 const weights = table.headers.map((h, i) => {\n let maxLen = String(h).length;\n table.rows.forEach((r) => {\n maxLen = Math.max(maxLen, String(r[i] ?? \"\").length);\n });\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, {\n x: margin,\n y: y - 18,\n size: 15,\n font: bold,\n color: rgb(0.12, 0.11, 0.25),\n });\n y -= titleH;\n page.drawRectangle({\n x: margin,\n y: y - headH,\n width: usableW,\n height: headH,\n color: rgb(0.31, 0.27, 0.9),\n });\n let x = margin;\n table.headers.forEach((h, i) => {\n page.drawText(String(h), {\n x: x + 6,\n y: y - headH + 8,\n size: 9,\n font: bold,\n color: rgb(1, 1, 1),\n });\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({\n x: margin,\n y: y - rowH,\n width: usableW,\n height: rowH,\n color: rgb(0.96, 0.96, 0.99),\n });\n }\n let x = margin;\n r.forEach((cell, i) => {\n page.drawText(String(cell ?? \"\"), {\n x: x + 6,\n y: y - rowH + 7,\n size: 9,\n font,\n color: rgb(0.1, 0.1, 0.18),\n });\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,\n 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) => {\n maxLen = Math.max(maxLen, String(r[i] ?? \"\").length);\n });\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) =>\n String(s ?? \"\")\n .replace(/&/g, \"&\").replace(//g, \">\");\n\n let svg =\n ``;\n return svg;\n}\n\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(\n fetch(\"https://unpkg.com/@resvg/resvg-wasm@2.6.2/index_bg.wasm\"),\n );\n const fr = await fetch(\n \"https://cdn.jsdelivr.net/npm/dejavu-fonts-ttf@2.37.3/ttf/DejaVuSans.ttf\",\n );\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: {\n mode: \"width\",\n value: Math.min(1600, Math.max(700, table.headers.length * 190)),\n },\n });\n return r.render().asPng();\n}\n\nasync function handleDraftText(state, chatId, text) {\n const draft = getDraft(state, chatId);\n if (!draft) return false;\n\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 if (draft.step === \"editvalue\") {\n const { id, field } = draft.data;\n const idx = state.phones.findIndex((p) => p.id === id);\n if (idx === -1) {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"❌ Telefon topilmadi.\");\n return true;\n }\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)) {\n await sendMessage(chatId, \"❌ Raqam kiriting:\");\n return true;\n }\n } else {\n value = text.trim();\n if (!value) {\n await sendMessage(chatId, \"❌ Bo'sh bo'lmasin:\");\n return true;\n }\n }\n\n state.phones[idx][field] = value;\n clearDraft(state, chatId);\n await saveState(state);\n\n const affectsProfit = [\"sotildi\", \"sotib\", \"junat\", \"batch\", \"model\"];\n let editNote = \"\";\n if (affectsProfit.includes(field)) {\n editNote = incomeNoteText(\n await syncPhoneIncome(state, state.phones[idx]),\n );\n }\n\n await sendMessage(\n chatId,\n `✅ ${meta.label} yangilandi.` + divider() +\n phoneCard(state, state.phones[idx]) + editNote,\n { reply_markup: editFieldKeyboard(id) },\n );\n return true;\n }\n\n if (draft.step === \"sellprice\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v) || v <= 0) {\n await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 480):\");\n return true;\n }\n const idx = state.phones.findIndex((p) => p.id === draft.data.id);\n if (idx === -1) {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"❌ Telefon topilmadi.\");\n return true;\n }\n state.phones[idx].sotildi = v;\n clearDraft(state, chatId);\n await saveState(state);\n const synced = await syncPhoneIncome(state, state.phones[idx]);\n const incomeNote = incomeNoteText(synced);\n await sendMessage(\n chatId,\n `✅ Sotildi deb belgilandi!\\n\\n` +\n phoneCard(state, state.phones[idx]) + incomeNote,\n );\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(\n chatId,\n \"❌ Kursni raqam bilan kiriting (masalan: 1430):\",\n );\n return true;\n }\n\n const target = draft.data && draft.data.batch\n ? draft.data.batch\n : state.currentBatch;\n state.batchRates[target] = v;\n if (target === state.currentBatch) state.lastRate = v;\n\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(\n chatId,\n `✅ Partiya ${target} kursi ${v} ₩/$ qilib belgilandi.`,\n );\n return true;\n }\n\n if (draft.step === \"imei\") {\n const imei = text.trim();\n if (!imei) {\n await sendMessage(chatId, \"❌ IMEI bo'sh bo'lmasin. Qayta yuboring:\");\n 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 const warn = dup\n ? `⚠️ Diqqat: bu IMEI allaqachon bor\\n(${dup.model}, Partiya ${\n dup.batch || 1\n }, ${dup.sana})\\n\\n`\n : \"\";\n await sendMessage(chatId, `✅ IMEI: ${imei}`, {\n reply_markup: MAIN_KEYBOARD,\n });\n\n const guess = modelFromImei(state, imei);\n if (guess) {\n const gi = MODEL_OPTIONS.indexOf(guess.model);\n if (gi !== -1) {\n await sendMessage(\n chatId,\n warn + `🔎 Bu IMEI ${guess.model} ga o'xshaydi\\n` +\n `(bazada shunday ${guess.count} ta telefon bor)`,\n {\n reply_markup: {\n inline_keyboard: [\n [{ text: `✅ ${guess.model}`, callback_data: `model:${gi}` }],\n [{\n text: \"📱 Boshqa modelni tanlash\",\n callback_data: \"backbrand\",\n }],\n [{ text: \"✖️ Bekor qilish\", callback_data: \"cancel\" }],\n ],\n },\n },\n );\n return true;\n }\n }\n\n await sendMessage(chatId, warn + \"📱 Markani tanlang:\", {\n reply_markup: brandKeyboard(),\n });\n return true;\n }\n\n if (draft.step === \"yomkost\") {\n const v = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(v)) {\n await sendMessage(chatId, \"❌ Raqam kiriting (masalan: 85):\");\n return true;\n }\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)) {\n await sendMessage(chatId, \"❌ Raqam kiriting:\");\n return true;\n }\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)) {\n await sendMessage(chatId, \"❌ Raqam kiriting:\");\n return true;\n }\n draft.data.junat = v;\n draft.step = \"sotildi\";\n setDraft(state, chatId, draft);\n await saveState(state);\n await sendMessage(\n chatId,\n \"🏷 Sotildi narxi ($):\\n\\nHali sotilmagan bo'lsa — 0 yuboring yoki tugmani bosing.\",\n {\n reply_markup: {\n inline_keyboard: [[{\n text: \"📦 Hali sotilmagan\",\n callback_data: \"notsold\",\n }]],\n },\n },\n );\n return true;\n }\n\n if (draft.step === \"sotildi\") {\n const v = parseFloat(text.replace(/[^\\d.]/g, \"\"));\n if (isNaN(v)) {\n await sendMessage(chatId, \"❌ Raqam kiriting (yoki 0):\");\n return true;\n }\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 =\n state.phones.filter((x) => (x.batch || 1) === state.currentBatch).length;\n\n const synced = await syncPhoneIncome(state, p);\n const incomeNote = incomeNoteText(synced);\n\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 incomeNote,\n { reply_markup: MAIN_KEYBOARD },\n );\n}\n\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.\", {\n reply_markup: MAIN_KEYBOARD,\n });\n return;\n }\n\n if (data.startsWith(\"ship:\")) {\n const which = data.split(\":\")[1];\n await answerCallback(cbId, which === \"all\" ? \"Umumiy\" : `Partiya ${which}`);\n await showShipping(state, chatId, which);\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:\", {\n reply_markup: modelKeyboard(brand),\n });\n return;\n }\n\n if (data === \"backbrand\") {\n await answerCallback(cbId, \"\");\n await sendMessage(chatId, \"📱 Markani tanlang:\", {\n reply_markup: brandKeyboard(),\n });\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 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(\n chatId,\n `✅ Model ${model} qilib o'zgartirildi.` + divider() +\n phoneCard(state, state.phones[idx]),\n {\n reply_markup: editFieldKeyboard(id),\n },\n );\n return;\n }\n\n if (!draft || draft.step !== \"model\") {\n await answerCallback(cbId, \"Bu amal eskirgan\");\n return;\n }\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) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n await answerCallback(cbId, \"Maydonni tanlang\");\n await sendMessage(\n chatId,\n \"✏️ Tahrirlash\" + divider() + phoneCard(state, p) +\n \"\\n\\nQaysi maydonni o'zgartirasiz?\",\n {\n reply_markup: editFieldKeyboard(id),\n },\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) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\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:\", {\n reply_markup: brandKeyboard(),\n });\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(\n chatId,\n `✏️ ${meta.label}\\n\\nHozirgi qiymat: ${\n p[field] ?? \"—\"\n }\\n\\nYangi qiymatni yuboring:`,\n );\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) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n setDraft(state, chatId, { step: \"sellprice\", data: { id } });\n await saveState(state);\n await answerCallback(cbId, \"Narxni kiriting\");\n await sendMessage(\n chatId,\n `🏷 ${p.model}\\n${p.imei}\\n\\nSotuv narxini kiriting ($):`,\n );\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) {\n await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n await answerCallback(cbId, \"Tasdiqlang\");\n await sendMessage(\n chatId,\n `🗑 ${p.model}\\n${p.imei}\\n\\nO'chirilsinmi?`,\n {\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 );\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\n const synced = await syncPhoneIncome(state, removed, { remove: true });\n\n await answerCallback(cbId, \"O'chirildi\");\n await sendMessage(\n chatId,\n `🗑 O'chirildi: ${removed.model} (${removed.imei})` +\n incomeNoteText(synced),\n );\n } else await answerCallback(cbId, \"Topilmadi\");\n return;\n }\n\n if (data === \"closebatch\") {\n state.currentBatch = (state.currentBatch || 1) + 1;\n\n let rateNote = \"\";\n try {\n const { rate, date, source } = await fetchKrwRate();\n state.batchRates[state.currentBatch] = rate;\n state.lastRate = rate;\n rateNote =\n `\\n💱 Kurs avtomatik qo'yildi: ${rate} ₩/$\\n(${source}, ${date})`;\n } catch (e) {\n console.error(\"kurs olinmadi:\", e.message);\n rateNote = `\\nKurs olinmadi — qo'lda kiriting.`;\n }\n\n await saveState(state);\n await answerCallback(cbId, \"Yakunlandi\");\n await sendMessage(\n chatId,\n `✅ Partiya yakunlandi.\\n\\n📁 Yangi joriy partiya: ${state.currentBatch}` +\n rateNote,\n );\n return;\n }\n\n if (data === \"autorate\") {\n await answerCallback(cbId, \"Kurs olinmoqda...\");\n try {\n const { rate, date, source } = await fetchKrwRate();\n const old = rateForBatch(state, state.currentBatch);\n state.batchRates[state.currentBatch] = rate;\n state.lastRate = rate;\n await saveState(state);\n\n await sendMessage(\n chatId,\n `🔄 Kurs yangilandi` + divider() +\n `Partiya ${state.currentBatch}\\n` +\n `Eski: ${old} ₩/$\\n` +\n `Yangi: ${rate} ₩/$\\n\\n` +\n `Manba: ${\n source === \"Wise\" ? \"Wise\" : \"Yevropa Markaziy banki (zaxira)\"\n }, ${date}.\\n` +\n `Bu o'rtacha bozor kursi — almashtirish punktidagi kurs biroz farq qilishi mumkin.`,\n );\n } catch (e) {\n await sendMessage(chatId, `❌ ${e.message}`);\n }\n return;\n }\n\n if (\n data.startsWith(\"editb:\") || data.startsWith(\"sellb:\") ||\n data.startsWith(\"delb:\")\n ) {\n const [kind, which] = data.split(\":\");\n await answerCallback(\n cbId,\n which === \"recent\" ? \"So'nggilar\" : `Partiya ${which}`,\n );\n\n if (kind === \"editb\") await cmdEdit(state, chatId, which);\n else if (kind === \"sellb\") await cmdMarkSold(state, chatId, which);\n else {\n await pickPhone(state, chatId, {\n which,\n prefix: \"del\",\n icon: \"🗑\",\n title: \"O'chiriladigan telefonni tanlang:\",\n emptyMsg: \"Ro'yxat bo'sh.\",\n });\n }\n return;\n }\n\n if (data.startsWith(\"batch:\")) {\n const which = data.split(\":\")[1];\n await answerCallback(\n cbId,\n which === \"all\" ? \"Hammasi\" : `Partiya ${which}`,\n );\n await cmdBatch(state, chatId, which);\n return;\n }\n\n if (data === \"setrate\" || data.startsWith(\"setrate:\")) {\n const parts = data.split(\":\");\n const target = parts[1] ? Number(parts[1]) : state.currentBatch;\n\n setDraft(state, chatId, { step: \"rate\", data: { batch: target } });\n await saveState(state);\n await answerCallback(cbId, \"Kursni kiriting\");\n await sendMessage(\n chatId,\n `💱 Partiya ${target} uchun yangi kursni kiriting (₩/$):`,\n );\n return;\n }\n\n if (data.startsWith(\"qr:\")) {\n const which = data.split(\":\")[1];\n const items = exportItems(state, which);\n if (!items.length) {\n await answerCallback(cbId, \"Bo'sh\");\n return;\n }\n\n await answerCallback(cbId, \"Yorliqlar tayyorlanmoqda...\");\n try {\n const bytes = await buildQrLabels(items);\n const name = which === \"all\"\n ? \"qr-yorliqlar.pdf\"\n : `partiya-${which}-qr.pdf`;\n await sendDocument(\n chatId,\n name,\n bytes,\n `▣ ${\n which === \"all\" ? \"Hammasi\" : \"Partiya \" + which\n } — ${items.length} ta yorliq`,\n \"application/pdf\",\n );\n } catch (e) {\n console.error(\"QR xato:\", e);\n await sendMessage(chatId, \"⚠️ Yorliqlarni tayyorlab bo'lmadi.\");\n }\n return;\n }\n\n if (data.startsWith(\"ccsv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) {\n await answerCallback(cbId, \"Bo'sh\");\n return;\n }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"📤 Qaysi formatda?\", {\n reply_markup: formatKeyboard(\"cli\", which),\n });\n return;\n }\n\n if (data.startsWith(\"csv:\")) {\n const which = data.split(\":\")[1];\n if (exportItems(state, which).length === 0) {\n await answerCallback(cbId, \"Bo'sh\");\n return;\n }\n await answerCallback(cbId, \"Formatni tanlang\");\n await sendMessage(chatId, \"💾 Qaysi formatda?\", {\n reply_markup: formatKeyboard(\"full\", which),\n });\n return;\n }\n\n if (data.startsWith(\"dl:\")) {\n const [, kind, which, fmt] = data.split(\":\");\n const table = kind === \"ship\"\n ? shippingTable(state, which)\n : kind === \"imei\"\n ? imeiTable(state, which)\n : kind === \"cli\"\n ? clientTable(state, which)\n : fullTable(state, which);\n if (table.rows.length === 0) {\n await answerCallback(cbId, \"Bo'sh\");\n return;\n }\n\n await answerCallback(cbId, \"Tayyorlanmoqda...\");\n\n const base = which === \"all\" ? \"telefonlar\" : `partiya-${which}`;\n const suffix = kind === \"cli\"\n ? \"-royxat\"\n : kind === \"imei\"\n ? \"-imei\"\n : kind === \"ship\"\n ? \"-junatish\"\n : \"\";\n const caption = table.title;\n\n try {\n if (fmt === \"csv\") {\n await sendDocument(\n chatId,\n `${base}${suffix}.csv`,\n tableToCsv(table),\n caption,\n \"text/csv\",\n );\n } else if (fmt === \"pdf\") {\n const bytes = await tableToPdf(table);\n await sendDocument(\n chatId,\n `${base}${suffix}.pdf`,\n bytes,\n caption,\n \"application/pdf\",\n );\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\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) {\n totalProfit += c.foyda;\n soldCount++;\n } else {\n stockCount++;\n stockCost += c.opshiy;\n }\n });\n\n const batchItems = state.phones.filter((p) =>\n (p.batch || 1) === state.currentBatch\n );\n let batchProfit = 0, batchStock = 0;\n batchItems.forEach((p) => {\n const c = compute(state, p);\n if (c.sold) batchProfit += c.foyda;\n 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) => {\n todayProfit += compute(state, p).foyda;\n });\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) {\n msg += `\\n • ...yana ${addedToday.length - 5} ta`;\n }\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 ${\n fmtUsd(batchProfit)\n }`;\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 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 }\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\n return new Response(\"report sent\");\n}\n\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 (!isAllowed(chatId)) {\n await sendMessage(\n chatId,\n \"⛔️ Bu bot faqat ruxsat berilgan foydalanuvchilar uchun.\",\n );\n return new Response(\"ok\");\n }\n\n if (msg.web_app_data && msg.web_app_data.data) {\n const state = await loadState();\n const raw = (msg.web_app_data.data || \"\").replace(/\\D/g, \"\");\n\n // Kod to'liq o'qilmagan bo'lsa qabul qilmaymiz\n if (raw.length < 15) {\n await sendMessage(\n chatId,\n `⚠️ Kod to'liq o'qilmadi${raw ? ` (${raw})` : \"\"}.\\n\\n` +\n `Kodni ramka ichiga to'liq sig'diring va qimirlatmasdan ushlang.`,\n { reply_markup: MAIN_KEYBOARD },\n );\n return new Response(\"ok\");\n }\n\n const imei = raw.slice(0, 15);\n await sendMessage(chatId, `📷 O'qildi: ${imei}`);\n\n // IMEI nazorat raqamidan o'tmasa — ogohlantiramiz\n if (!luhnOk(imei)) {\n await sendMessage(\n chatId,\n \"⚠️ Bu raqam IMEI tekshiruvidan o'tmadi — noto'g'ri o'qilgan bo'lishi mumkin. \" +\n \"Telefondagi raqam bilan solishtiring.\",\n );\n }\n const draft = getDraft(state, chatId);\n if (draft && draft.step === \"imei\") {\n await handleDraftText(state, chatId, imei);\n } else {\n await runSearch(state, chatId, imei);\n }\n return new Response(\"ok\");\n }\n\n if (msg.photo && msg.photo.length) {\n const state = await loadState();\n await handlePhoto(state, chatId, msg.photo);\n return new Response(\"ok\");\n }\n\n const text = (msg.text || \"\").trim();\n const state = await loadState();\n\n if (text === \"/start\" || text === \"/menu\") await cmdStart(chatId);\n else if (text === \"/qoshish\" || text === \"➕ Qo'shish\") {\n await cmdAdd(state, chatId);\n } else if (text === \"/qidirish\" || text === \"🔍 Qidirish\") {\n await cmdSearch(state, chatId);\n } else if (text === \"/royxat\" || text === \"📋 Ro'yxat\") {\n await cmdList(state, chatId);\n } else if (text === \"/omborda\" || text === \"📦 Omborda\") {\n await cmdStock(state, chatId);\n } else if (text === \"/statistika\" || text === \"📊 Statistika\") {\n await cmdStats(state, chatId);\n } else if (text === \"/sotildi\" || text === \"🏷 Sotildi\") {\n await cmdMarkSold(state, chatId);\n } else if (text === \"/partiya\" || text === \"📁 Partiya\") {\n await cmdBatch(state, chatId);\n } else if (text === \"/excel\" || text === \"💾 Excel\") {\n await cmdExport(state, chatId);\n } else if (text === \"/junatish\" || text === \"🚚 Junatish\") {\n await cmdShipping(state, chatId);\n } else if (text === \"/imei\" || text === \"🔢 IMEI ro'yxat\") {\n await cmdImeiList(state, chatId);\n } else if (text === \"/mijoz\" || text === \"📤 Mijozga (narxsiz)\") {\n await cmdExportClient(state, chatId);\n } else if (text === \"/qr\" || text === \"▣ QR yorliq\") {\n await cmdQrLabels(state, chatId);\n } else if (text === \"/tahrirlash\" || text === \"✏️ Tahrirlash\") {\n await cmdEdit(state, chatId);\n } else if (text === \"/hisobot\") await dailyReport();\n else if (text === \"/ochirish\" || text === \"🗑 O'chirish\") {\n await pickPhone(state, chatId, {\n which: null,\n prefix: \"del\",\n icon: \"🗑\",\n title: \"O'chiriladigan telefonni tanlang:\",\n emptyMsg: \"Ro'yxat bo'sh.\",\n });\n } else if (text === \"/bekor\" || text === \"✖️ Bekor qilish\") {\n clearDraft(state, chatId);\n await saveState(state);\n await sendMessage(chatId, \"✖️ Bekor qilindi.\", {\n reply_markup: MAIN_KEYBOARD,\n });\n } else {\n const handled = await handleDraftText(state, chatId, text);\n if (!handled) {\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)) {\n await answerCallback(cq.id, \"Ruxsat yo'q\");\n return new Response(\"ok\");\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}","deleted",false,"label",[14],"399375c7-b982-45db-ab5d-870b32bde5b8",["D",1787638223825],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","579d8fce-a99d-484f-a0ae-114d4a14bc32","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03785-ea79-7229-8499-966d99c58666","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_102":98},"org",{"_9":10,"_95":96,"_97":98,"_55":56,"_99":100,"_101":42},"branch",{"_35":85,"_11":86,"_22":28,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":12,"_94":10},"isOwned",126,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Sindor Suyarov","avatar","https://lh3.googleusercontent.com/a/ACg8ocJaHUSJVIZHoDaXtVDVAEsApROv3Z-ewH59Qp7VYg3H9f1jTlQE=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":62,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":86,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]