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

if (!isset($_SESSION['admin_id']) || !in_array($_SESSION['admin_role'], ['manager','superadmin'])) {
    die("Access denied");
}
?>
<!DOCTYPE html>
<html>
<head>
    <title><?php echo SITE_TITLE . ' | Admin Dashboard'; ?></title>
    <link rel="stylesheet" href="css/admin.css">
</head>
<body>
<div class="container">
<?php
// Metrics
$affCount = $pdo->query("SELECT COUNT(*) FROM affiliates")->fetchColumn();
$offerCount = $pdo->query("SELECT COUNT(*) FROM offers")->fetchColumn();
$convToday = $pdo->query("SELECT COUNT(*) FROM conversions WHERE DATE(created_at) = CURDATE()")->fetchColumn();
$flaggedAffs = $pdo->query("SELECT COUNT(DISTINCT affiliate_id) FROM affiliate_flags")->fetchColumn();

// Recent admin actions
$logStmt = $pdo->query("
    SELECT l.*, u.username 
    FROM admin_action_logs l 
    JOIN admin_users u ON l.admin_id = u.id 
    ORDER BY l.created_at DESC LIMIT 10
");
$logs = $logStmt->fetchAll(PDO::FETCH_ASSOC);

// UI
echo "<h2>📊 Admin Dashboard</h2>
<table><tr><th>Metric</th><th>Value</th></tr>
<tr><td>Total Affiliates</td><td>$affCount</td></tr>
<tr><td>Total Offers</td><td>$offerCount</td></tr>
<tr><td>Conversions Today</td><td>$convToday</td></tr>
<tr><td>Flagged Affiliates</td><td>$flaggedAffs</td></tr>
</table>";

echo "<h3>🕵️ Recent Admin Actions</h3>
<table><tr>
    <th>Admin</th><th>Action</th><th>Details</th><th>Time</th>
</tr>";
foreach ($logs as $log) {
    echo "<tr>
        <td>" . htmlspecialchars($log['username']) . "</td>
        <td>" . htmlspecialchars($log['action_type']) . "</td>
        <td><textarea readonly style='width:300px;height:40px'>" . htmlspecialchars($log['action_detail']) . "</textarea></td>
        <td>{$log['created_at']}</td>
    </tr>";
}
echo "</table>";

echo "<h3>🔗 Quick Links</h3>
<ul>
    <li><a href='admin_affiliate_flags.php'>Affiliate Flags</a></li>
    <li><a href='admin_offer_insights.php'>Offer Insights</a></li>
    <li><a href='admin_logs.php'>Admin Logs</a></li>
    <li><a href='admin_conversion_lookup.php'>Conversion Lookup</a></li>
</ul>";
?>
</div>
</body>
</html>