<?php
// Debug via web - acesse http://localhost:8000/debug-compras.php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once __DIR__ . '/app/Core/Database.php';
require_once __DIR__ . '/app/Services/FirebirdService.php';
require_once __DIR__ . '/app/Core/Cache.php';
require_once __DIR__ . '/app/Repositories/ComprasRepository.php';

use App\Core\Database;
use App\Repositories\ComprasRepository;

header('Content-Type: text/plain; charset=utf-8');

try {
    $pdo = Database::conectar();
    echo "CONEXAO OK\n";
} catch (Exception $e) {
    echo "ERRO CONEXAO: " . $e->getMessage() . "\n";
    exit;
}

$repo = new ComprasRepository($pdo);

echo "\n=== anosDisponiveis() ===\n";
try {
    $anos = $repo->anosDisponiveis();
    print_r($anos);
} catch (Exception $e) {
    echo "ERRO: " . $e->getMessage() . "\n";
}

echo "\n=== ultimaData() ===\n";
try {
    echo $repo->ultimaData() . "\n";
} catch (Exception $e) {
    echo "ERRO: " . $e->getMessage() . "\n";
}

echo "\n=== kpis(2026-01-01, 2026-05-25) ===\n";
try {
    $k = $repo->kpis('2026-01-01', '2026-05-25');
    print_r($k);
} catch (Exception $e) {
    echo "ERRO: " . $e->getMessage() . "\n";
}

echo "\n=== notasEntrada (FIRST 3) ===\n";
try {
    $n = $repo->notasEntrada('2026-01-01', '2026-05-25', 3);
    print_r($n);
} catch (Exception $e) {
    echo "ERRO: " . $e->getMessage() . "\n";
}