prepare("INSERT INTO report_views (report_key, last_viewed_at) VALUES (?, NOW()) ON DUPLICATE KEY UPDATE last_viewed_at = NOW()");
$stmtMark->execute([$type]);
}
// --- DEFINIRE QUERY-URI STANDARD ---
$sql_zombie = "SELECT * FROM seo_audit WHERE is_indexed = 0 AND coverage_state LIKE '%CRAWLED%' AND is_ignored = 0 ORDER BY last_crawl DESC";
$sql_discovered = "SELECT * FROM seo_audit WHERE is_indexed = 0 AND coverage_state LIKE '%DISCOVERED%' AND is_ignored = 0";
$sql_dusty = "SELECT * FROM seo_audit WHERE last_crawl < DATE_SUB(NOW(), INTERVAL 6 MONTH) AND is_ignored = 0 AND last_crawl IS NOT NULL ORDER BY last_crawl ASC";
$sql_unstable = "SELECT t1.url, t1.last_crawl, t1.verdict FROM seo_audit t1 JOIN seo_history t2 ON t1.id = t2.url_id WHERE t1.is_ignored = 0 GROUP BY t1.id HAVING COUNT(DISTINCT t2.is_indexed) > 1";
$sql_errors = "SELECT coverage_state, COUNT(*) as nr FROM seo_audit WHERE is_indexed = 0 AND is_ignored = 0 AND coverage_state NOT LIKE '%CRAWLED%' AND coverage_state NOT LIKE '%DISCOVERED%' GROUP BY coverage_state ORDER BY nr DESC";
// --- QUERY SPECIAL PENTRU HOT (ENTERPRISE) ---
$sql_hot_list = "SELECT * FROM seo_audit WHERE last_crawl IS NOT NULL AND is_ignored = 0 ORDER BY last_crawl DESC";
// Date pentru Grafic (Agregare pe zile - ultimele 30 zile)
$sql_hot_chart = "
SELECT DATE(last_crawl) as crawl_date, COUNT(*) as count
FROM seo_audit
WHERE last_crawl IS NOT NULL
AND last_crawl >= DATE_SUB(NOW(), INTERVAL 30 DAY)
GROUP BY DATE(last_crawl)
ORDER BY crawl_date ASC";
// --- SELECTARE DATE ---
$data = [];
$chartData = [];
$stats = [];
$title = "Toate Rapoartele";
$desc = "";
$template = "list";
$showChart = false;
switch ($type) {
case 'zombie':
$data = $pdo->query($sql_zombie)->fetchAll();
$title = "🧟 Zombie Pages";
$desc = "Pagini vizitate de Google dar neindexate.";
break;
case 'discovered':
$data = $pdo->query($sql_discovered)->fetchAll();
$title = "⏳ Coada de Așteptare";
$desc = "Pagini descoperite dar nevizitate încă.";
break;
case 'dusty':
$data = $pdo->query($sql_dusty)->fetchAll();
$title = "🕸️ Pagini Prăfuite";
$desc = "Google nu a mai trecut pe aici de peste 6 luni.";
break;
case 'hot':
// --- LOGICA ENTERPRISE EXTINSA ---
$data = $pdo->query($sql_hot_list)->fetchAll();
$rawChart = $pdo->query($sql_hot_chart)->fetchAll();
// Statistici suplimentare
$countYesterday = $pdo->query("SELECT COUNT(*) FROM seo_audit WHERE last_crawl >= DATE_SUB(NOW(), INTERVAL 24 HOUR)")->fetchColumn();
$countLast7 = $pdo->query("SELECT COUNT(*) FROM seo_audit WHERE last_crawl >= DATE_SUB(NOW(), INTERVAL 7 DAY)")->fetchColumn();
// Procesare date grafic
$labels = [];
$values = [];
$maxCrawl = 0;
$peakDay = '-';
foreach($rawChart as $r) {
$formattedDate = date('d.m', strtotime($r['crawl_date']));
$labels[] = $formattedDate;
$values[] = $r['count'];
if($r['count'] > $maxCrawl) {
$maxCrawl = $r['count'];
$peakDay = $formattedDate;
}
}
$chartData = ['labels' => $labels, 'values' => $values];
$stats = [
'total_items' => count($data),
'yesterday' => $countYesterday,
'last_7_days' => $countLast7,
'peak_day' => $peakDay . " ($maxCrawl)"
];
$title = "🔥 Activitate Googlebot (Live)";
$desc = "Monitorizare detaliată a vizitelor Googlebot.";
$showChart = true;
break;
case 'unstable':
$data = $pdo->query($sql_unstable)->fetchAll();
$title = "📉 Pagini Instabile";
$desc = "Pagini care intră și ies din index frecvent.";
break;
case 'tech':
// LOGICA NOUĂ: DRILL-DOWN
if (isset($_GET['detail'])) {
// Daca userul a dat click pe o cifra, afisam lista de URL-uri
$errorType = $_GET['detail'];
$stmt = $pdo->prepare("SELECT * FROM seo_audit WHERE coverage_state = ? AND is_indexed = 0 AND is_ignored = 0");
$stmt->execute([$errorType]);
$data = $stmt->fetchAll();
$title = "🛠️ Detalii: " . htmlspecialchars($errorType);
$desc = "Lista paginilor care au această eroare specifică.";
$template = "list"; // Refolosim tabelul standard cu lista de URL-uri!
} else {
// Altfel, afisam tabelul sumar (ca in screenshot)
$data = $pdo->query($sql_errors)->fetchAll();
$title = "🛠️ Erori Tehnice";
$desc = "Sumar al problemelor tehnice (click pe cifre pentru detalii).";
$template = "tech_table";
}
break;
}
?>
<?php echo $title; ?> - Raport Enterprise