prepare(" SELECT user_id FROM user_sessions WHERE session_token = ? LIMIT 1 "); $stmt->bind_param("s", $token); $stmt->execute(); $result = $stmt->get_result(); $session = $result->fetch_assoc(); $stmt->close(); if ($session) { $_SESSION['user_id'] = $session['user_id']; $_SESSION['session_token'] = $token; } } // ================= SSO AUTO LOGIN ================= if (!isset($_SESSION['user_id'])) { if (!empty($_COOKIE['INPAY_SESSION'])) { $token = $_COOKIE['INPAY_SESSION']; $stmt = $conn->prepare(" SELECT user_id, ip_address, user_agent FROM user_sessions WHERE session_token = ? LIMIT 1 "); $stmt->bind_param("s", $token); $stmt->execute(); $result = $stmt->get_result(); $session = $result->fetch_assoc(); $stmt->close(); if ($session) { // optional security check $currentIp = $_SERVER['REMOTE_ADDR'] ?? ''; $currentUA = $_SERVER['HTTP_USER_AGENT'] ?? ''; if ( $session['ip_address'] === $currentIp && $session['user_agent'] === $currentUA ) { $_SESSION['user_id'] = $session['user_id']; $_SESSION['session_token'] = $token; } } } } // Mehmon foydalanuvchilar uchun marketing landing sahifa ko'rsatiladi if (!isset($_SESSION['user_id'])) { require $_SERVER['DOCUMENT_ROOT'] . '/landing.php'; exit; } $user_id = (int)$_SESSION['user_id']; // ================= DEVICE ================= function detect_device(string $ua): string { if (preg_match('/(iPhone|iPod|iPad|Android|BlackBerry|IEMobile|Opera Mini)/i', $ua)) { return 'Mobile'; } if (preg_match('/(Macintosh|Windows|Linux)/i', $ua)) { return 'Desktop'; } return 'Unknown'; } $ip = $_SERVER['REMOTE_ADDR'] ?? ''; $userAgent = $_SERVER['HTTP_USER_AGENT'] ?? ''; $device = detect_device($userAgent); // ================= SESSION TRACKING ================= if (!isset($_SESSION['session_token'])) { $sessionToken = bin2hex(random_bytes(32)); $_SESSION['session_token'] = $sessionToken; $stmt = $conn->prepare(" INSERT INTO user_sessions (user_id, device, user_agent, last_login, ip_address, session_token) VALUES (?, ?, ?, NOW(), ?, ?) "); $stmt->bind_param("issss", $user_id, $device, $userAgent, $ip, $sessionToken); $stmt->execute(); $stmt->close(); } else { $stmt = $conn->prepare(" SELECT COUNT(*) FROM user_sessions WHERE user_id = ? AND session_token = ? "); $stmt->bind_param("is", $user_id, $_SESSION['session_token']); $stmt->execute(); $stmt->bind_result($active); $stmt->fetch(); $stmt->close(); if ((int)$active === 0) { session_unset(); session_destroy(); header("Location: /login?reason=session_expired"); exit; } } // ================= USER CORE DATA ================= $stmt = $conn->prepare(" SELECT passport_status, passport_contract, phone, balance, pricing_plan, background FROM users WHERE id = ? LIMIT 1 "); $stmt->bind_param("i", $user_id); $stmt->execute(); $user = $stmt->get_result()->fetch_assoc(); $stmt->close(); // === PASSPORT STATUS (YAGONA MANBA) === $passportStatus = (int)($user['passport_status'] ?? 0); $passportContract = $user['passport_contract'] ?? null; // === PHONE === $hasPhone = !empty($user['phone']); // === BALANCE === $currentBalance = $user['balance'] ?? 0; $userPricing = strtoupper($user['pricing_plan'] ?? 'STANDART'); // ================= TRANSACTION COUNT ================= $stmt = $conn->prepare(" SELECT COUNT(*) AS total_count FROM transactions t INNER JOIN merchant_requests m ON t.merchant_id = m.merchant_id WHERE m.user_id = ? AND m.status = 'approved' AND t.status = 'success' "); $stmt->bind_param("i", $user_id); $stmt->execute(); $transactionCount = $stmt->get_result()->fetch_assoc()['total_count'] ?? 0; $stmt->close(); // === BACKGROUND === $userBackground = !empty($user['background']) ? "/uploads/" . htmlspecialchars($user['background']) : null; // ================= CSRF ================= //if ($_SERVER['REQUEST_METHOD'] === 'POST') { // if ( // empty($_POST['csrf_token']) || // $_POST['csrf_token'] !== ($_SESSION['csrf_token'] ?? '') // ) { // die("❗ CSRF token noto'g'ri!"); //} // $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); //} // ================= TRANSACTIONS ================= $stmt = $conn->prepare(" SELECT amount, created_at, order_id FROM transactions WHERE user_id = ? AND status = 'success' ORDER BY created_at ASC "); $stmt->bind_param("i", $user_id); $stmt->execute(); $balances = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); $stmt->close(); // ================= SHOPS ================= $stmt = $conn->prepare(" SELECT COUNT(*) AS total FROM merchant_requests WHERE user_id = ? AND status = 'approved' "); $stmt->bind_param("i", $user_id); $stmt->execute(); $shopStats = $stmt->get_result()->fetch_assoc(); $stmt->close(); $activeShops = (int)($shopStats['total'] ?? 0); // ================= TURNOVER ================= $stmt = $conn->prepare(" SELECT COALESCE(SUM(t.amount),0) AS total_sum FROM transactions t INNER JOIN merchant_requests m ON t.merchant_id = m.merchant_id WHERE m.user_id = ? AND m.status = 'approved' AND t.status = 'success' "); $stmt->bind_param("i", $user_id); $stmt->execute(); $totalTurnover = $stmt->get_result()->fetch_assoc()['total_sum'] ?? 0; $stmt->close(); // ================= TODAY ================= $stmt = $conn->prepare(" SELECT COALESCE(SUM(t.amount),0) AS today_sum FROM transactions t INNER JOIN merchant_requests m ON t.merchant_id = m.merchant_id WHERE m.user_id = ? AND m.status = 'approved' AND t.status = 'success' AND DATE(t.created_at) = CURDATE() "); $stmt->bind_param("i", $user_id); $stmt->execute(); $todayTurnover = $stmt->get_result()->fetch_assoc()['today_sum'] ?? 0; $stmt->close(); // ================= WITHDRAW ================= $stmt = $conn->prepare(" SELECT COUNT(*) AS cnt, COALESCE(SUM(amount),0) AS total FROM withdrawal_requests WHERE user_id = ? AND status = 'approved' "); $stmt->bind_param("i", $user_id); $stmt->execute(); $withdraw = $stmt->get_result()->fetch_assoc(); $stmt->close(); $withdrawCount = (int)($withdraw['cnt'] ?? 0); $withdrawSum = $withdraw['total'] ?? 0; // ================= BYOK kassalar + obuna ma'lumotlari ================= $byok_kassas = []; $byok_helper_path = $_SERVER['DOCUMENT_ROOT'] . '/includes/payment_credentials.php'; if (file_exists($byok_helper_path)) { require_once $byok_helper_path; $stmt = $conn->prepare(" SELECT id, merchant_id, business_name FROM merchant_requests WHERE user_id = ? AND kassa_mode = 'byok' AND is_active = 1 "); $stmt->bind_param("i", $user_id); $stmt->execute(); $res = $stmt->get_result(); while ($row = $res->fetch_assoc()) { $q = function_exists('inpay_get_active_byok_quota') ? inpay_get_active_byok_quota($conn, (string)$row['merchant_id']) : null; $byok_kassas[] = ['kassa' => $row, 'quota' => $q]; } $stmt->close(); } // Foydalanuvchi background rasmi $bg_stmt = $conn->prepare("SELECT background FROM users WHERE id = ? LIMIT 1"); $bg_stmt->bind_param("i", $user_id); $bg_stmt->execute(); $bgData = $bg_stmt->get_result()->fetch_assoc(); $bg_stmt->close(); $userBackground = !empty($bgData['background']) ? "/uploads/" . htmlspecialchars($bgData['background']) : null; // ================= USER DISPLAY NAME ================= $stmt = $conn->prepare("SELECT username, email FROM users WHERE id = ? LIMIT 1"); $stmt->bind_param("i", $user_id); $stmt->execute(); $userInfo = $stmt->get_result()->fetch_assoc(); $stmt->close(); $displayName = trim(($userInfo['username'] ?? '') . ' ' . ($userInfo['last_name'] ?? '')); $displayInitial = strtoupper(mb_substr($displayName ?: ($userInfo['email'] ?? 'U'), 0, 1)); ?>
AI tahlil qilmoqda... Biznes ma'lumotlaringiz qayta ishlanmoqda. Biroz sabr qiling.
Shaxsni tasdiqlash talab qilinadi To'lovlarni qabul qilish uchun identifikatsiyadan o'ting
Davom etish
Shaxsni tasdiqlash rad etildi Iltimos, qayta identifikatsiya qiling
Qayta urinish
Shaxsni tasdiqlash tekshirilmoqda Bu 1–3 ish kunini olishi mumkin
Kuting

Biznes kassa yarating

Birinchi to'lovingizni qabul qilish uchun yangi biznes kassangizni yarating.

Yangi kassa
Kassalar
ta
Tranzaksiyalar
ta
Bugungi tushum
UZS
BYOK kassalaringiz va obuna ta kassa
#
= 90 ? 'crit' : ($pct >= 70 ? 'warn' : ''); $days_left = max(0, (int)round((strtotime($q['period_end']) - time()) / 86400)); ?>
/ tranzaksiya qoldi
kun qoldi · gacha Tarif almashtirish →
Faol obuna yo'q — yangi tranzaksiyalar bloklangan Tarif sotib olish
AI Tahlil
AI endi siz bilan ishlaydi
Premium olish
Tarif rejangiz
Business'ga o'tish Daraja ko'tarish
Tranzaksiyalar statistikasi
Barcha muvaffaqiyatli to'lovlar grafigi
Cheklangan

Statistika yuqori tariflarda mavjud

Batafsil grafik va tahlillarni ko'rish uchun Premium yoki Business tarifiga o'ting.

Premiumga o'tish
t('ai.js.growth_pos'), 'growth_neg' => t('ai.js.growth_neg'), 'activity_high' => t('ai.js.activity_high'), 'activity_mid' => t('ai.js.activity_mid'), 'activity_low' => t('ai.js.activity_low'), 'day_unit' => t('ai.js.day_unit'), 'rank' => t('ai.js.ctx.rank'), 'rank_top' => t('ai.js.ctx.rank_top'), 'merchants_active' => t('ai.js.ctx.merchants_active'), 'unique_payers' => t('ai.js.ctx.unique_payers'), 'success_rate' => t('ai.js.ctx.success_rate'), 'avg_check' => t('ai.js.ctx.avg_check'), 'platform_avg' => t('ai.js.ctx.platform_avg'), 'peak' => t('ai.js.ctx.peak'), 'no_data_title' => t('ai.js.no_data_title'), 'no_data_text' => t('ai.js.no_data_text'), 'error_title' => t('ai.js.error_title'), 'error_text' => t('ai.js.error_text'), 'chart_no_period' => t('chart.no_data_period'), 'chart_no_tx' => t('chart.no_tx_yet'), 'chart_payments' => t('chart.label_payments'), ]; ?>