query("SELECT COUNT(*) c FROM orders WHERE user_id=$uid"); $smm_total = ($r && $row = $r->fetch_assoc()) ? intval($row['c']) : 0; if ($r) $r->free(); $r = $conn->query("SELECT COUNT(*) c FROM vtu_orders WHERE user_id=$uid"); $vtu_total = ($r && $row = $r->fetch_assoc()) ? intval($row['c']) : 0; if ($r) $r->free(); $total_orders = $smm_total + $vtu_total; // Pending orders $r = $conn->query("SELECT COUNT(*) c FROM vtu_orders WHERE user_id=$uid AND status='pending'"); $vtu_pending = ($r && $row = $r->fetch_assoc()) ? intval($row['c']) : 0; if ($r) $r->free(); $r = $conn->query("SELECT COUNT(*) c FROM orders WHERE user_id=$uid AND status IN('Pending','Processing','Inprogress')"); $smm_pending = ($r && $row = $r->fetch_assoc()) ? intval($row['c']) : 0; if ($r) $r->free(); $pending = $vtu_pending + $smm_pending; // Total spent — avoid number_format entirely, use plain floatval $total_spent = 0.0; $r = $conn->query("SELECT COALESCE(SUM(amount),0) t FROM vtu_orders WHERE user_id=$uid AND status='completed'"); if ($r && $row = $r->fetch_assoc()) { $total_spent += floatval($row['t']); $r->free(); } $r = $conn->query("SELECT COALESCE(SUM(charge),0) t FROM orders WHERE user_id=$uid AND status='Completed'"); if ($r && $row = $r->fetch_assoc()) { $total_spent += floatval($row['t']); $r->free(); } // Format all money values once here as strings — never pass raw DB values to number_format again $fmt_balance = number_format($balance, 2); $fmt_bonus = number_format($bonus, 2); $fmt_total_spent = number_format($total_spent, 2); // Referrals $r = $conn->query("SELECT COUNT(*) c FROM users WHERE referred_by=$uid"); $referrals = ($r && $row = $r->fetch_assoc()) ? intval($row['c']) : 0; if ($r) $r->free(); // Recent transactions — merge VTU + fund transactions ───────────────────── $recent_txns = []; // VTU orders $r = $conn->query("SELECT 'vtu' src, type, amount, status, created_at, CONCAT(UPPER(network), ' ', JSON_UNQUOTE(JSON_EXTRACT(details,'$.plan'))) desc_ FROM vtu_orders WHERE user_id=$uid ORDER BY created_at DESC LIMIT 8"); if ($r) { while ($row = $r->fetch_assoc()) $recent_txns[] = $row; $r->free(); } // Fund transactions $r = $conn->query("SELECT 'fund' src, type, amount, status, created_at, description desc_ FROM transactions WHERE user_id=$uid AND type IN('deposit','refund','bonus') ORDER BY created_at DESC LIMIT 4"); if ($r) { while ($row = $r->fetch_assoc()) $recent_txns[] = $row; $r->free(); } // Sort merged by date usort($recent_txns, fn($a,$b) => strtotime($b['created_at']) - strtotime($a['created_at'])); $recent_txns = array_slice($recent_txns, 0, 8); // Transaction type map $txn_styles = [ 'data' => ['bg'=>'rgba(79,142,247,.12)', 'color'=>'#4f8ef7', 'label'=>'Data', 'credit'=>false], 'airtime' => ['bg'=>'rgba(249,115,22,.12)', 'color'=>'#f97316', 'label'=>'Airtime', 'credit'=>false], 'cable' => ['bg'=>'rgba(167,139,250,.12)', 'color'=>'#a78bfa', 'label'=>'Cable TV', 'credit'=>false], 'electricity' => ['bg'=>'rgba(234,179,8,.12)', 'color'=>'#eab308', 'label'=>'Electricity','credit'=>false], 'education' => ['bg'=>'rgba(34,197,94,.12)', 'color'=>'#22c55e', 'label'=>'Education', 'credit'=>false], 'deposit' => ['bg'=>'rgba(34,197,94,.12)', 'color'=>'#22c55e', 'label'=>'Funded', 'credit'=>true], 'refund' => ['bg'=>'rgba(34,197,94,.12)', 'color'=>'#22c55e', 'label'=>'Refund', 'credit'=>true], 'bonus' => ['bg'=>'rgba(234,179,8,.12)', 'color'=>'#eab308', 'label'=>'Bonus', 'credit'=>true], 'order' => ['bg'=>'rgba(99,102,241,.12)', 'color'=>'#6366f1', 'label'=>'Order', 'credit'=>false], ]; $txn_icons = [ 'data' => '', 'airtime' => '', 'cable' => '', 'electricity' => '', 'deposit' => '', 'refund' => '', 'bonus' => '', 'order' => '', ]; function fmt_date(string $dt): string { $ts = strtotime($dt); $diff = time() - $ts; if ($diff < 3600) return round($diff/60) . 'm ago'; if ($diff < 86400) return round($diff/3600) . 'h ago'; if ($diff < 172800) return 'Yesterday'; return date('M d', $ts); } include '../includes/header.php'; ?>
Hello 👋
Smart Earner
Wallet Balance
₦
Bonus: ₦
Add Money
Transfer
History
Wallet Balance
₦
Bonus: ₦
Total Orders
Pending
₦
Total Spent
Referrals
✨ New

Own a Retailer Website

Retail all our services: DATA, Recharge cards, AIRTIME and BILLS Payment.

Get Started →
VTU Services
'], ['buy-airtime.php', 'Airtime', '#f97316', 'rgba(249,115,22,.1)', ''], ['electricity.php', 'Electricity', '#eab308', 'rgba(234,179,8,.1)', ''], ['cable-tv.php', 'Cable TV', '#a78bfa', 'rgba(167,139,250,.1)',''], ]; foreach ($vtu_links as [$href, $lbl, $color, $bg, $path]): ?>
Add Money Refer & Earn