// Add this after line 253 in data/purchase.php (after $amount = floatval($plan['amount']);)

// Apply service fee and discount
$serviceFee = calculateServiceFee($amount, 'data');
$serviceDiscount = calculateServiceDiscount($amount, 'data');
$chargeAmount = $amount + $serviceFee - $serviceDiscount;

// Then replace $amount with $chargeAmount in:
// 1. Wallet balance check (line 262)
// 2. Wallet debit calculation (line 278)
// 3. Transaction insert (line 285) - add fee column

// Update line 262:
if ($wallet['balance'] < $chargeAmount) {

// Update line 278:
$balanceAfter = $balanceBefore - $chargeAmount;

// Update line 285 transaction insert to include fee:
$db->query(
    "INSERT INTO transactions (
        user_id, reference, type, category, amount, fee,
        balance_before, balance_after, status, description, metadata
    ) VALUES (?, ?, 'debit', 'data', ?, ?, ?, ?, 'pending', ?, ?)",
    [
        $user['id'],
        $reference,
        $chargeAmount,
        $serviceFee,
        $balanceBefore,
        $balanceAfter,
        $description,
        $initialMetadata
    ]
);