<?php
require_once '../includes/constants.php';
require_once '../includes/session.php';
require_once '../includes/functions.php';

if (!isset($_SESSION['admin_id']) || !in_array($_SESSION['admin_role'], ['manager','superadmin'])) {
    die("Access denied");
}

// Total affiliates
$affCount = $pdo->query("SELECT COUNT(*) FROM affiliates")->fetchColumn();

// Total offers
$offerCount = $pdo->query("SELECT COUNT(*) FROM offers")->fetchColumn();

// Total conversions
$convCount = $pdo->query("SELECT COUNT(*) FROM conversions")->fetchColumn();

// Total payouts
$payoutTotal = $pdo->query("SELECT SUM(amount) FROM affiliate_payouts")->fetchColumn();

// Active test links
$testCount = $pdo->query("SELECT COUNT(*) FROM affiliate_tests WHERE status = 'active'")->fetchColumn();
?>
<!DOCTYPE html>
<html>
<head>
    <title><?php echo SITE_TITLE . ' | Network Stats'; ?></title>
    <link rel="stylesheet" href="css/admin.css">
</head>
<body>
<div class="container">
<h2>📊 Network Stats</h2>
<table>
<tr><th>Metric</th><th>Value</th></tr>
<tr><td>Total Affiliates</td><td><?php echo htmlspecialchars($affCount); ?></td></tr>
<tr><td>Total Offers</td><td><?php echo htmlspecialchars($offerCount); ?></td></tr>
<tr><td>Total Conversions</td><td><?php echo htmlspecialchars($convCount); ?></td></tr>
<tr><td>Total Payouts</td><td>$<?php echo number_format($payoutTotal, 2); ?></td></tr>
<tr><td>Active Test Links</td><td><?php echo htmlspecialchars($testCount); ?></td></tr>
</table>
</div>
</body>
</html>