requireLogin();
// Get dashboard statistics
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
// Get counts
$stats = [];
// Total brands
$query = "SELECT COUNT(*) as count FROM brands";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['brands'] = $stmt->fetch(PDO::FETCH_ASSOC)['count'];
// Total reports
$query = "SELECT COUNT(*) as count FROM seo_reports";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['reports'] = $stmt->fetch(PDO::FETCH_ASSOC)['count'];
// Total content plans
$query = "SELECT COUNT(*) as count FROM content_plans";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['content_plans'] = $stmt->fetch(PDO::FETCH_ASSOC)['count'];
// Total generated content
$query = "SELECT COUNT(*) as count FROM generated_content";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['generated_content'] = $stmt->fetch(PDO::FETCH_ASSOC)['count'];
// Recent activities
$query = "SELECT 'brand' as type, name as title, created_at FROM brands
UNION ALL
SELECT 'report' as type, title, created_at FROM seo_reports
UNION ALL
SELECT 'content' as type, title, created_at FROM content_plans
ORDER BY created_at DESC LIMIT 10";
$stmt = $db->prepare($query);
$stmt->execute();
$recent_activities = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
儀表板 - SEO AI 自動化系統