stats.php - master - codxplr/voprosovNET

stats.php
225 строк8 KB
codxplr
Create: style.css, formatting.php, howtopost.php, subscriptions.php, 3myP4ibv3tAib88QV-_auN8n6nSLC1NDYlcGaE9PQa4ek71BOJIY5S7YRUr5Ikqawb91hZTdoA-KvUE6harf8Ru_.jpg, default-avatar.png, favicon.png, admheader.php, footer.php, header.php, paidservice.php, privacy.php, tos.php, access_denied.php, admin.php, config.php, db_setup.sql, edit_profile.php, functions.php, index.php, login.php, logout.php, moderator.php, notifications.php, profile.php, register.php, set_admin_pass.php, stats.php, warn.php
04 авг 2026, 10:43
Верифицирован
04 авг 2026, 10:4303ec57b
<?php
require_once 'config.php';
session_start();
require_once 'functions.php';

if (!function_exists('formatTime')) {
    function formatTime($datetime, $timezoneName = 'Europe/Moscow') {
        $dt = new DateTime($datetime);
        $dt->setTimezone(new DateTimeZone($timezoneName));
        return $dt->format('d.m.Y H:i');
    }
}

if (!isset($_SESSION['user_id'])) {
    header('Location: index.php');
    exit;
}

$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([$_SESSION['user_id']]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$user || $user['role'] !== 'admin') {
    die('<h1>Доступ запрещён</h1>');
}

$timezone = 'Europe/Moscow';

// Получаем настройки часового пояса
$cfg = $pdo->query('SELECT `key`, value FROM site_config')->fetchAll(PDO::FETCH_KEY_PAIR);
if (isset($cfg['timezone'])) {
    $timezone = $cfg['timezone'];
}

// ---------------------------------------------------------
// Данные для дашборда
// ---------------------------------------------------------

// Новые пользователи за 7 дней
$sevenDaysAgo = (new DateTime())->modify('-7 days')->format('Y-m-d H:i:s');
$stmt = $pdo->prepare('SELECT COUNT(*) FROM users WHERE created_at >= ?');
$stmt->execute([$sevenDaysAgo]);
$newUsers7d = (int)$stmt->fetchColumn();

// Забанено пользователей за последние 24 часа
$yesterday = (new DateTime())->modify('-24 hours')->format('Y-m-d H:i:s');
$stmt = $pdo->prepare('
    SELECT COUNT(*)
    FROM users
    WHERE banned = 1
      AND ban_expires IS NOT NULL
      AND ban_expires >= ?
');
$stmt->execute([$yesterday]);
$bannedUsersToday = (int)$stmt->fetchColumn();

// Общее количество пользователей, тем, ответов
$stmt = $pdo->query('SELECT COUNT(*) FROM users');
$totalUsers = (int)$stmt->fetchColumn();

$stmt = $pdo->query('SELECT COUNT(*) FROM topics');
$totalTopics = (int)$stmt->fetchColumn();

$stmt = $pdo->query('SELECT COUNT(*) FROM replies');
$totalReplies = (int)$stmt->fetchColumn();

// Активность по дням за последние 14 дней (темы)
$stmt = $pdo->prepare('
    SELECT DATE(created_at) AS day, COUNT(*) AS cnt
    FROM topics
    WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 14 DAY)
    GROUP BY DATE(created_at)
    ORDER BY day
');
$stmt->execute();
$topicsByDay = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="ru">
<head>
    <meta charset="UTF-8">
    <title>Статистика и отчёты — <?= htmlspecialchars($cfg['site_name'] ?? 'Форум') ?></title>
    <link rel="stylesheet" href="css/style.css">
    <style>
        .stat-card {
            background: #fff;
            border: 1px solid #ddd;
            padding: 16px;
            border-radius: 8px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.05);
            text-align: center;
        }
        .stat-value {
            font-size: 2rem;
            font-weight: bold;
            color: #333;
        }
        .stat-label {
            color: #666;
            margin-top: 4px;
        }
        .grid-stats {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
            gap: 16px;
            margin-bottom: 24px;
        }
        #chart-container {
            width: 100%;
            height: 300px;
            background: #fff;
            border: 1px solid #eee;
            border-radius: 8px;
            padding: 12px;
        }
    </style>
</head>
<body>
    <?php require_once 'inc/admheader.php'; ?>

    <div class="forum-container">
        <h1>Статистика и отчёты</h1>

        <!-- Дашборд -->
        <section>
            <h2>Дашборд</h2>
            <div class="grid-stats">
                <div class="stat-card">
                    <div class="stat-value"><?= $newUsers7d ?></div>
                    <div class="stat-label">Новых пользователей за 7 дней</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value"><?= $totalTopics ?></div>
                    <div class="stat-label">Всего тем</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value"><?= $totalReplies ?></div>
                    <div class="stat-label">Всего ответов</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value"><?= $totalUsers ?></div>
                    <div class="stat-label">Всего пользователей</div>
                </div>
                <div class="stat-card">
                    <div class="stat-value"><?= $bannedUsersToday ?></div>
                    <div class="stat-label">Забанено (последние 24 ч)</div>
                </div>
                <div class="stat-card" style="opacity:0.6;">
                    <div class="stat-value">—</div>
                    <div class="stat-label">Удалённые посты (нужен audit_log)</div>
                </div>
            </div>
        </section>

        <!-- График: темы по дням -->
        <section>
            <h2>Активность: темы по дням (последние 14 дней)</h2>
            <div id="chart-container"></div>
        </section>

        <!-- Отчёт: топ активных пользователей (ИСПРАВЛЕНО: author_id вместо user_id) -->
        <section>
            <h2>Топ активных пользователей (по ответам)</h2>
            <?php
            $stmt = $pdo->query('
                SELECT u.id, u.username, u.display_name, COUNT(r.id) AS replies_count
                FROM users u
                LEFT JOIN replies r ON u.id = r.author_id
                GROUP BY u.id
                ORDER BY replies_count DESC
                LIMIT 10
            ');
            $topUsers = $stmt->fetchAll(PDO::FETCH_ASSOC);
            ?>
            <table class="topic-card" style="width:100%">
                <thead>
                    <tr>
                        <th>Пользователь</th>
                        <th>Количество ответов</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($topUsers as $u): ?>
                        <tr>
                            <td><?= htmlspecialchars($u['display_name'] ?? $u['username']) ?></td>
                            <td style="text-align:right;"><?= (int)$u['replies_count'] ?></td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </section>
    </div>

    <!-- Chart.js для простого столбчатого графика -->
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script>
        const ctx = document.getElementById('chart-container').getContext('2d');
        const labels = <?= json_encode(array_column($topicsByDay, 'day')) ?>;
        const data = <?= json_encode(array_column($topicsByDay, 'cnt')) ?>;

        new Chart(ctx, {
            type: 'bar',
            data: {
                labels: labels,
                datasets: [{
                    label: 'Тем за день',
                    data: data,
                    backgroundColor: '#17a2b8',
                    borderRadius: 4,
                    barThickness: 14
                }]
            },
            options: {
                responsive: true,
                plugins: {
                    legend: { display: false }
                },
                scales: {
                    y: { beginAtZero: true }
                }
            }
        });
    </script>
</body>
</html>