'MTN', 2=>'Airtel', 3=>'Glo', 4=>'9mobile']; // ── Load plans + apply margin ───────────────────────────────────────────── $plans_resp = tca_get('data_plans'); $plans_raw = tca_list($plans_resp); $plans_by_network = []; foreach ($plans_raw as $p) { if (!isset($p['network'], $p['plan_id'])) continue; $net_name = $p['network']; $api_cost = (float)($p['price'] ?? 0); $calc = vtu_calc_charge($api_cost, 'data', $net_name); $p['api_price'] = $api_cost; $p['price'] = ceil($calc['charge']); $p['profit'] = $calc['profit']; $p['margin_pct'] = $calc['margin_pct']; $plans_by_network[$net_name][] = $p; } // ── Classify plans into tabs: HOT / Daily / Weekly / Monthly ────────────── function classify_plan(array $p): string { $day = (int)($p['day'] ?? 0); $type = strtoupper($p['type'] ?? ''); $size_str = strtolower($p['datasize'] ?? ''); if ($day <= 1) return 'daily'; if ($day <= 7) return 'weekly'; if (str_contains($type, 'SME') || str_contains($type, 'SMB')) { $mb = 0; if (preg_match('/(\d+(?:\.\d+)?)\s*GB/i', $size_str, $m)) $mb = (float)$m[1] * 1024; elseif (preg_match('/(\d+(?:\.\d+)?)\s*MB/i', $size_str, $m)) $mb = (float)$m[1]; if ($mb > 0 && $mb <= 2048) return 'hot'; } return 'monthly'; } $classified = []; foreach ($plans_by_network as $net => $plans) { $classified[$net] = ['hot'=>[], 'daily'=>[], 'weekly'=>[], 'monthly'=>[]]; foreach ($plans as $p) { $tab = classify_plan($p); $classified[$net][$tab][] = $p; } if (empty($classified[$net]['hot']) && !empty($classified[$net]['monthly'])) { $sorted = $classified[$net]['monthly']; usort($sorted, fn($a,$b) => $a['price'] <=> $b['price']); $classified[$net]['hot'] = array_slice($sorted, 0, 4); } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $network_id = (int)($_POST['network_id'] ?? 0); $plan_id = (int)($_POST['plan_id'] ?? 0); $phone = sanitize($_POST['phone'] ?? ''); if (!$network_id || !$plan_id || !$phone) { $error = 'Please select a network, plan and enter a phone number.'; } elseif (!preg_match('/^0[789][01]\d{8}$/', $phone)) { $error = 'Enter a valid 11-digit Nigerian phone number.'; } else { $selected_plan = null; $selected_network = null; foreach ($plans_by_network as $net => $plans) { foreach ($plans as $p) { if ((int)$p['plan_id'] === $plan_id) { $selected_plan = $p; $selected_network = $net; break 2; } } } if (!$selected_plan) { $error = 'Invalid data plan selected.'; } else { $expected_net_id = array_search($selected_network, $networks); if ((int)$expected_net_id !== $network_id) { $error = 'Network mismatch detected.'; } else { $api_price = (float)$selected_plan['api_price']; $user_price = (float)$selected_plan['price']; $plan_label = $selected_plan['datasize'] . ' ' . $selected_plan['day'] . 'days ' . $selected_network; if ($user_price <= 0) { $error = 'Invalid plan price.'; } else { $conn->begin_transaction(); try { $stmt = $conn->prepare("SELECT balance FROM users WHERE id=? FOR UPDATE"); $stmt->bind_param('i', $uid); $stmt->execute(); $stmt->bind_result($balance); $stmt->fetch(); $stmt->close(); if ($user_price > (float)$balance) { throw new Exception('Insufficient balance.'); } // ── Call API ─────────────────────────────────────── $resp = tca_post('data', [ 'network' => $network_id, 'phone' => $phone, 'data_plan' => $plan_id, 'bypass' => false ]); $api_status = strtolower($resp['status'] ?? ''); // Hard failures → roll back, no charge if ($api_status === 'failed' || $api_status === 'error') { throw new Exception($resp['message'] ?? 'Data purchase failed. Please try again.'); } // Must be success or pending to continue if (!tca_ok($resp) && !tca_pending($resp)) { throw new Exception($resp['message'] ?? 'Unexpected API response.'); } // ── Deduct balance ───────────────────────────────── $stmt = $conn->prepare("UPDATE users SET balance = balance - ? WHERE id=?"); $stmt->bind_param('di', $user_price, $uid); $stmt->execute(); $stmt->close(); // ── Determine order status ───────────────────────── $order_status = tca_pending($resp) ? 'pending' : 'completed'; // ── Save order ───────────────────────────────────── $ref = sanitize($resp['request-id'] ?? ('DATA-' . time())); $profit = $user_price - $api_price; $dets = json_encode([ 'plan' => $plan_label, 'network' => $selected_network, 'phone' => $phone, 'data_size' => $resp['data_size'] ?? '', 'data_type' => $resp['data_type'] ?? '', 'api_price' => $api_price, 'profit' => $profit, 'response' => $resp['response'] ?? ($resp['message'] ?? ''), ]); $stmt = $conn->prepare( "INSERT INTO vtu_orders (user_id,type,network,phone,plan_id,amount,reference,details,status,created_at) VALUES (?,'data',?,?,?,?,?,?,?,NOW())" ); $stmt->bind_param('issidsss', $uid, $selected_network, $phone, $plan_id, $user_price, $ref, $dets, $order_status ); $stmt->execute(); $stmt->close(); // ── Transaction log ──────────────────────────────── addTransaction($uid, $user_price, 'order', "Data: {$plan_label} → {$phone}", $order_status); // ── Commit ───────────────────────────────────────── $conn->commit(); $user = getUser($uid); if (tca_pending($resp)) { $success = "⏳ {$plan_label} to {$phone} is being processed." . " Ref: {$ref}
" . "Your order will update automatically once confirmed — usually within a minute."; } else { $success = "✓ {$plan_label} sent to {$phone}! Ref: {$ref}"; } } catch (Exception $e) { $conn->rollback(); $error = $e->getMessage(); } } } } } } $active_net = $_GET['net'] ?? array_key_first($plans_by_network) ?? 'MTN'; if (!array_key_exists($active_net, $plans_by_network)) { $active_net = array_key_first($plans_by_network) ?? 'MTN'; } $net_colors = ['MTN'=>'#f9a825','Airtel'=>'#e53935','Glo'=>'#2e7d32','9mobile'=>'#00897b']; include '../includes/header.php'; ?>

Buy Data Bundle

Instant delivery to any Nigerian network

balance
View Order History →

Select Network & Plan

$_): $slug = ($net_name==='9mobile') ? 'nine' : $net_name; $cls = ($net_name===$active_net) ? "active {$slug}" : $slug; ?>
[],'daily'=>[],'weekly'=>[],'monthly'=>[]]; $cur_net_id = 0; foreach ($networks as $id => $name) { if (strcasecmp($name, $active_net)===0) { $cur_net_id=$id; break; } } $tab_defs = [ 'hot' => ['label'=>'🔥 HOT', 'cls'=>'plan-tab-hot'], 'daily' => ['label'=>'Daily', 'cls'=>''], 'weekly' => ['label'=>'Weekly', 'cls'=>''], 'monthly' => ['label'=>'Monthly', 'cls'=>''], ]; $first_tab = null; foreach ($tab_defs as $tkey => $_) { if (!empty($cur_plans[$tkey])) { $first_tab = $tkey; break; } } ?>
$tdef): $count = count($cur_plans[$tkey]); if ($count === 0) continue; $active = ($tkey === $first_tab) ? 'active' : ''; ?>
$tdef): $plans_in_tab = $cur_plans[$tkey] ?? []; $active = ($tkey === $first_tab) ? 'active' : ''; $is_hot = ($tkey === 'hot'); ?>
No plans available
🔥 HOT
day
₦
Select a plan first

Confirm Purchase

🇳🇬
Must match the selected network
⚠ Enter a valid 11-digit Nigerian phone number.
Wallet Balance

Data Order History

query("SELECT * FROM vtu_orders WHERE user_id={$uid} AND type='data' ORDER BY created_at DESC LIMIT 10"); if ($rows && $rows->num_rows > 0): while ($r=$rows->fetch_assoc()): $d = !empty($r['details']) ? (json_decode($r['details'],true)??[]) : []; $sc = $r['status']==='completed'?'badge-success':($r['status']==='failed'?'badge-danger':'badge-warning'); ?>
NetworkPhonePlanPaidRefStatusDate
₦
No data orders yet