PAID'; if($s === 'created') return 'CREATED'; if($s === 'declined' || $s === 'failed') return 'DECLINED'; if($s === 'review') return 'REVIEW'; return ''.e(strtoupper($status ?: 'UNKNOWN')).''; } function cardDisplay($p){ $brand = strtoupper($p['card_brand'] ?? 'CARD'); $first6 = $p['card_first6'] ?? ''; $last4 = $p['card_last4'] ?? ''; if ($first6 && $last4) return $brand . ' ' . $first6 . '******' . $last4; if ($last4) return $brand . ' ****' . $last4; if (!empty($p['network_reference'])) return ($brand ?: 'CARD') . ' / Network Ref: ' . $p['network_reference']; return 'Not returned by processor'; } $status = $_GET['status'] ?? 'all'; $q = trim($_GET['q'] ?? ''); $dateFrom = trim($_GET['from'] ?? ''); $dateTo = trim($_GET['to'] ?? ''); $where = []; $params = []; if ($status !== 'all') { if ($status === 'declined') { $where[] = "status IN ('declined','failed')"; } else { $where[] = "status = :status"; $params[':status'] = $status; } } if ($q !== '') { $where[] = "( id LIKE :q OR telegram_id LIKE :q OR chat_id LIKE :q OR paypal_order_id LIKE :q OR capture_id LIKE :q OR card_last4 LIKE :q OR card_first6 LIKE :q OR network_reference LIKE :q )"; $params[':q'] = '%' . $q . '%'; } if ($dateFrom !== '') { $where[] = "created_at >= :date_from"; $params[':date_from'] = $dateFrom . ' 00:00:00'; } if ($dateTo !== '') { $where[] = "created_at <= :date_to"; $params[':date_to'] = $dateTo . ' 23:59:59'; } $whereSql = $where ? ('WHERE ' . implode(' AND ', $where)) : ''; try { $stats = [ 'total' => (int)$pdo->query("SELECT COUNT(*) FROM payment_requests")->fetchColumn(), 'paid' => (int)$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status='paid'")->fetchColumn(), 'created' => (int)$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status='created'")->fetchColumn(), 'declined' => (int)$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status IN ('declined','failed')")->fetchColumn(), 'paid_volume' => (float)$pdo->query("SELECT COALESCE(SUM(amount),0) FROM payment_requests WHERE status='paid'")->fetchColumn(), 'today_volume' => (float)$pdo->query("SELECT COALESCE(SUM(amount),0) FROM payment_requests WHERE status='paid' AND DATE(paid_at)=CURDATE()")->fetchColumn(), ]; $stmt = $pdo->prepare(" SELECT * FROM payment_requests $whereSql ORDER BY id DESC LIMIT 250 "); $stmt->execute($params); $payments = $stmt->fetchAll(PDO::FETCH_ASSOC); $filteredTotal = count($payments); } catch(Throwable $ex){ die("DB Error: " . e($ex->getMessage())); } function activeTab($current, $target){ return $current === $target ? 'active' : ''; } $baseUrl = 'admin_payments.php'; ?> query("SELECT COUNT(*) FROM payment_requests WHERE DATE(created_at)=CURDATE()")->fetchColumn(); $rf_paid=$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status IN ('PAID','COMPLETED')")->fetchColumn(); $rf_pending=$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status IN ('CREATED','PENDING','REVIEW')")->fetchColumn(); $rf_payout=$pdo->query("SELECT COUNT(*) FROM payment_requests WHERE status='PAID_OUT'")->fetchColumn(); }catch(Exception $e){ $rf_today=0;$rf_paid=0;$rf_pending=0;$rf_payout=0; } ?> RumboFacil Merchant Dashboard

FinoviaPay Merchant Dashboard

Live merchant payment monitoring, payout tracking and transaction overview.

Home Merchant Configuration Payout Merchant Keys

Today's Payments

Completed Payments

Pending Payout

Paid Out

Payments Dashboard

Monitor approved, created and declined card payments with order, capture, processor and network details.

Total

✓

Paid

•

Created

Declined

€

Paid Volume

Today Paid

All Paid Created Declined Review

Latest Payments

shown

No payments found
Try clearing filters or refreshing the dashboard.

Created:

Reason:

Telegram ID

Method

Order ID

Capture ID

Card

Network Ref

Processor

CVV / AVS

Paid At

Chat ID