ERP System - Test de Conexión API"; try { // Test Database Connection $db = Database::getInstance()->getConnection(); echo "

✅ Conexión a base de datos exitosa

"; // Test Tables $tables = ['empresas', 'clientes', 'productos', 'facturas', 'usuarios']; foreach ($tables as $table) { $stmt = $db->prepare("SELECT COUNT(*) as count FROM $table LIMIT 1"); $stmt->execute(); echo "

✅ Tabla '$table' accesible

"; } // Test Sample Data $stmt = $db->prepare("SELECT COUNT(*) as empresas FROM empresas WHERE activa = TRUE"); $stmt->execute(); $empresas = $stmt->fetch(); echo "

📊 Empresas activas: " . $empresas['empresas'] . "

"; $stmt = $db->prepare("SELECT COUNT(*) as clientes FROM clientes WHERE activo = TRUE"); $stmt->execute(); $clientes = $stmt->fetch(); echo "

📊 Clientes activos: " . $clientes['clientes'] . "

"; $stmt = $db->prepare("SELECT COUNT(*) as productos FROM productos WHERE activo = TRUE"); $stmt->execute(); $productos = $stmt->fetch(); echo "

📊 Productos activos: " . $productos['productos'] . "

"; // Test API Endpoints echo "

Test de Endpoints API

"; $base_url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]/prub"; $endpoints = [ 'info' => 'GET', 'empresas' => 'GET', 'dashboard?empresa_id=1' => 'GET' ]; foreach ($endpoints as $endpoint => $method) { $url = "$base_url/$endpoint"; echo "

🔗 Testing: $method $url

"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_TIMEOUT, 10); if ($method === 'POST') { curl_setopt($ch, CURLOPT_POST, true); } $response = curl_exec($ch); $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); if ($http_code === 200) { echo "

✅ $endpoint - OK (HTTP $http_code)

"; } else { echo "

❌ $endpoint - Error (HTTP $http_code)

"; echo "

Response: " . substr($response, 0, 200) . "...

"; } } echo "

Configuración del Sistema

"; echo "

📁 Directorio API: " . __DIR__ . "

"; echo "

🗄️ Base de datos: " . DB_NAME . "

"; echo "

🌐 Charset: " . DB_CHARSET . "

"; echo "

⏰ Timezone: " . TIMEZONE . "

"; echo "

📅 Fecha actual: " . date('Y-m-d H:i:s') . "

"; echo "

Prueba de Login

"; echo ""; } catch (Exception $e) { echo "

❌ Error: " . $e->getMessage() . "

"; } echo "

"; echo "

← Volver al inicio

"; ?>