query("SELECT id, name FROM " . DB_PREFIX . "projects ORDER BY name"); $projects = $stmt->fetchAll(); $sql = "SELECT p.*, pr.name as project_name, COALESCE(SUM(a.likes), 0) as total_likes, COALESCE(SUM(a.comments), 0) as total_comments, COALESCE(SUM(a.shares), 0) as total_shares, COALESCE(SUM(a.views), 0) as total_views, COALESCE(SUM(a.clicks), 0) as total_clicks, COALESCE(SUM(a.reach), 0) as total_reach FROM " . DB_PREFIX . "posts p LEFT JOIN " . DB_PREFIX . "projects pr ON p.project_id = pr.id LEFT JOIN " . DB_PREFIX . "analytics a ON p.id = a.post_id AND a.date BETWEEN ? AND ? WHERE p.status = 'published'"; $params = [$dateFrom, $dateTo]; if ($projectFilter) { $sql .= " AND p.project_id = ?"; $params[] = $projectFilter; } if ($platformFilter) { $sql .= " AND p.platform = ?"; $params[] = $platformFilter; } $sql .= " GROUP BY p.id ORDER BY p.published_at DESC LIMIT 50"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $posts = $stmt->fetchAll(); $totalLikes = array_sum(array_column($posts, 'total_likes')); $totalComments = array_sum(array_column($posts, 'total_comments')); $totalShares = array_sum(array_column($posts, 'total_shares')); $totalViews = array_sum(array_column($posts, 'total_views')); $totalReach = array_sum(array_column($posts, 'total_reach')); $stmt = $pdo->prepare("SELECT p.platform, COUNT(*) as post_count, COALESCE(SUM(a.likes), 0) as likes, COALESCE(SUM(a.views), 0) as views FROM " . DB_PREFIX . "posts p LEFT JOIN " . DB_PREFIX . "analytics a ON p.id = a.post_id AND a.date BETWEEN ? AND ? WHERE p.status = 'published' GROUP BY p.platform"); $stmt->execute([$dateFrom, $dateTo]); $platformStats = $stmt->fetchAll(); $platforms = ['instagram', 'facebook', 'vk', 'telegram', 'tiktok', 'youtube', 'twitter', 'linkedin']; ?>
Лайков
Комментариев
Репостов
Просмотров
Охват
По платформам
ПлатформаПубликацийЛайковПросмотров
Нет данных
Фильтры
Детальная статистика по публикациям
ПубликацияПроектПлатформаЛайкиКомментыРепостыПросмотрыОхват
Нет опубликованных постов за выбранный период