<?php
require_once("/opt/wevads/config/credentials.php");
header('Content-Type: application/json');

try {
    $pdo = new PDO(
        "pgsql:host=localhost;dbname=adx_system",
        "admin",
        WEVADS_DB_PASS,
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
    
    // Tester différentes tables
    $tables = [
        'office_accounts' => "SELECT COUNT(*) as count FROM admin.office_accounts",
        'affiliate_offers' => "SELECT COUNT(*) as count FROM admin.affiliate_offers",
        'brain_configs' => "SELECT COUNT(*) as count FROM admin.brain_configs"
    ];
    
    $results = [];
    foreach ($tables as $table => $query) {
        $stmt = $pdo->query($query);
        $results[$table] = (int)$stmt->fetchColumn();
    }
    
    echo json_encode([
        'status' => 'success',
        'message' => 'Database connection successful',
        'data' => $results
    ]);
} catch (Exception $e) {
    echo json_encode([
        'status' => 'error',
        'message' => 'Database connection failed: ' . $e->getMessage()
    ]);
}
?>