
<?php
header('Content-Type: application/json');
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123");
$action = $_GET['action'] ?? 'stats';
if ($action == 'stats') {
    $stats = [];
    $stats['claude_conversations'] = $pdo->query("SELECT COUNT(*) FROM admin.claude_conversations_kb")->fetchColumn();
    $stats['debug_commands'] = $pdo->query("SELECT COUNT(*) FROM admin.recurring_debug_commands")->fetchColumn();
    $stats['knowledge_base'] = $pdo->query("SELECT COUNT(*) FROM admin.knowledge_base")->fetchColumn();
    $stats['categories'] = $pdo->query("SELECT category, COUNT(*) as count FROM admin.claude_conversations_kb GROUP BY category")->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode(['success' => true, 'stats' => $stats]);
} elseif ($action == 'conversations') {
    $rows = $pdo->query("SELECT * FROM admin.claude_conversations_kb ORDER BY importance_score DESC LIMIT 50")->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode(['success' => true, 'conversations' => $rows]);
} elseif ($action == 'sync') {
    $output = shell_exec('/opt/wevads/scripts/sync/claude_to_kb.sh 2>&1');
    echo json_encode(['success' => true, 'output' => $output]);
} else {
    echo json_encode(['error' => 'Unknown action']);
}