requireLogin();
// Get analytics data
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
// Get brands for dropdown
$brands_query = "SELECT id, name FROM brands ORDER BY name";
$brands_stmt = $db->prepare($brands_query);
$brands_stmt->execute();
$brands = $brands_stmt->fetchAll(PDO::FETCH_ASSOC);
// Get tracking data
$tracking_data = [];
$query = "SELECT st.*, b.name as brand_name FROM seo_tracking st
LEFT JOIN brands b ON st.brand_id = b.id
ORDER BY st.tracking_date DESC LIMIT 50";
$stmt = $db->prepare($query);
$stmt->execute();
$tracking_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get summary stats
$stats = [];
$stats['total_keywords'] = $db->query("SELECT COUNT(DISTINCT keyword) FROM seo_tracking")->fetchColumn() ?: 0;
$stats['total_brands'] = $db->query("SELECT COUNT(*) FROM brands")->fetchColumn() ?: 0;
$stats['avg_ranking'] = $db->query("SELECT AVG(current_ranking) FROM seo_tracking WHERE current_ranking > 0")->fetchColumn() ?: 0;
$stats['total_reports'] = $db->query("SELECT COUNT(*) FROM seo_reports")->fetchColumn() ?: 0;
?>
成效分析 - SEO AI 自動化系統