requireLogin();
// Get reports data
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
$reports = [];
$query = "SELECT r.*, b.name as brand_name FROM seo_reports r
LEFT JOIN brands b ON r.brand_id = b.id
ORDER BY r.created_at DESC LIMIT 5";
$stmt = $db->prepare($query);
$stmt->execute();
$reports = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get brands for report generation
$brands_query = "SELECT * FROM brands ORDER BY name LIMIT 3";
$brands_stmt = $db->prepare($brands_query);
$brands_stmt->execute();
$brands = $brands_stmt->fetchAll(PDO::FETCH_ASSOC);
?>
SEO報告功能測試 - SEO AI 自動化系統