<?php
require_once __DIR__ . '/includes/db.php';
require_once __DIR__ . '/includes/functions.php';

$companyId = function_exists('getCurrentCompanyId') ? getCurrentCompanyId() : ($_SESSION['company_id'] ?? null);
$out = [];
$out['company_id'] = $companyId;
$out['has_finance_accounts'] = false;
$out['rows_total'] = 0;
$out['rows_in_scope'] = 0;
$out['sum_balance_all'] = 0.0;
$out['sum_balance_in_scope'] = 0.0;
$out['sample'] = [];

try {
    $out['has_finance_accounts'] = $pdo->query("SHOW TABLES LIKE 'finance_accounts'")->rowCount() > 0;
    if ($out['has_finance_accounts']) {
        $out['rows_total'] = (int)$pdo->query("SELECT COUNT(*) FROM finance_accounts")->fetchColumn();
        $out['sum_balance_all'] = (float)$pdo->query("SELECT COALESCE(SUM(balance),0) FROM finance_accounts")->fetchColumn();
        $hasCompany = function_exists('tableHasColumn') && tableHasColumn('finance_accounts','company_id');
        if ($companyId && $hasCompany) {
            $st = $pdo->prepare("SELECT COUNT(*) FROM finance_accounts WHERE company_id = ? OR company_id IS NULL");
            $st->execute([(int)$companyId]);
            $out['rows_in_scope'] = (int)$st->fetchColumn();
            $st = $pdo->prepare("SELECT COALESCE(SUM(balance),0) FROM finance_accounts WHERE company_id = ? OR company_id IS NULL");
            $st->execute([(int)$companyId]);
            $out['sum_balance_in_scope'] = (float)$st->fetchColumn();
        } else {
            $out['rows_in_scope'] = $out['rows_total'];
            $out['sum_balance_in_scope'] = $out['sum_balance_all'];
        }
        $nameCol = (function_exists('tableHasColumn') && tableHasColumn('finance_accounts','account_name')) ? 'account_name' : ((function_exists('tableHasColumn') && tableHasColumn('finance_accounts','name')) ? 'name' : null);
        $sel = "SELECT id, balance";
        if ($nameCol) { $sel .= ", $nameCol AS name"; }
        if ($hasCompany) { $sel .= ", company_id"; }
        $sel .= " FROM finance_accounts ORDER BY id DESC LIMIT 10";
        $out['sample'] = $pdo->query($sel)->fetchAll(PDO::FETCH_ASSOC) ?: [];
    }
} catch (Throwable $e) {
    $out['error'] = $e->getMessage();
}

header('Content-Type: application/json');
echo json_encode($out, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);