real_escape_string(trim($_GET['search'])); } if (isset($_GET['status']) && in_array($_GET['status'], ['SUCCESS', 'PENDING', 'FAILED', 'REFUNDED'])) { $status_filter = $conn->real_escape_string($_GET['status']); } if (isset($_GET['date_from']) && !empty($_GET['date_from'])) { $date_from = date('Y-m-d', strtotime($_GET['date_from'])); } if (isset($_GET['date_to']) && !empty($_GET['date_to'])) { $date_to = date('Y-m-d', strtotime($_GET['date_to'])); } if (isset($_GET['payment_method']) && in_array($_GET['payment_method'], ['UPI', 'CARD', 'NETBANKING', 'WALLET'])) { $payment_method = $conn->real_escape_string($_GET['payment_method']); } // Build the base query $payments_query = " SELECT p.*, u.name as user_name, u.mobile, u.email, e.type_name as exam_name, pl.name as plan_name, pl.duration_days FROM payments p JOIN users u ON p.user_id = u.id JOIN ExaminationType e ON p.exam_id = e.type_id JOIN plans pl ON p.plan_id = pl.id WHERE 1=1 "; // Add search conditions if (!empty($search)) { $payments_query .= " AND ( p.merchant_order_id LIKE '%$search%' OR p.transaction_id LIKE '%$search%' OR u.name LIKE '%$search%' OR u.mobile LIKE '%$search%' OR u.email LIKE '%$search%' )"; } // Add filters if (!empty($status_filter)) { $payments_query .= " AND p.status = '$status_filter'"; } if (!empty($payment_method)) { $payments_query .= " AND p.payment_method = '$payment_method'"; } if (!empty($date_from)) { $payments_query .= " AND DATE(p.created_at) >= '$date_from'"; } if (!empty($date_to)) { $payments_query .= " AND DATE(p.created_at) <= '$date_to'"; } $payments_query .= " ORDER BY p.created_at DESC"; $payments = $conn->query($payments_query); // Get stats $stats_query = " SELECT SUM(CASE WHEN status = 'SUCCESS' THEN amount ELSE 0 END) as success_amount, SUM(CASE WHEN status = 'PENDING' THEN amount ELSE 0 END) as pending_amount, SUM(CASE WHEN status = 'FAILED' THEN amount ELSE 0 END) as failed_amount, SUM(CASE WHEN status = 'REFUNDED' THEN amount ELSE 0 END) as refunded_amount, COUNT(*) as total_count, COUNT(CASE WHEN status = 'SUCCESS' THEN 1 END) as success_count, COUNT(CASE WHEN status = 'PENDING' THEN 1 END) as pending_count, COUNT(CASE WHEN status = 'FAILED' THEN 1 END) as failed_count, COUNT(CASE WHEN status = 'REFUNDED' THEN 1 END) as refunded_count FROM payments "; $stats = $conn->query($stats_query)->fetch_assoc(); ?>

Payment Transactions

Successful

₹

Pending

₹

Failed

₹

Total

₹

fetch_assoc()): ?>

Order ID	User	Amount	Status	Method	Date	Actions
		₹