<?php
session_start();
require_once __DIR__ . '/includes/db.php';
require_once __DIR__ . '/includes/functions.php';
function generateInvoiceNumber($id){ return 'AIB-INV-' . str_pad((string)max(0,(int)$id), 4, '0', STR_PAD_LEFT); }
$userId = $_SESSION['user_id'] ?? null;
$userRole = $_SESSION['user_role'] ?? null;
if (!$userId || !in_array($userRole, ['admin','super_admin','finance','estate_manager'])) { http_response_code(403); exit('Forbidden'); }
$companyId = function_exists('getCurrentCompanyId') ? getCurrentCompanyId() : null;
$invId = (int)($_GET['invoice_id'] ?? ($_GET['id'] ?? 0));
if ($invId <= 0) { http_response_code(400); exit('Invalid invoice id'); }
$inv = [];
try {
    $hasInv = $pdo->query("SHOW TABLES LIKE 'invoices'")->rowCount() > 0;
    if (!$hasInv) { http_response_code(404); exit('Invoices table not found'); }
    $cmpClause = ''; $cmpParams = [];
    if ($companyId && function_exists('tableHasColumn') && tableHasColumn('invoices','company_id')) { $cmpClause = " AND company_id = ?"; $cmpParams[] = $companyId; }
    $st = $pdo->prepare("SELECT * FROM invoices WHERE id = ?" . $cmpClause . " LIMIT 1");
    $st->execute(array_merge([$invId], $cmpParams));
    $inv = $st->fetch(PDO::FETCH_ASSOC) ?: [];
} catch (Throwable $e) {}
if (!$inv) { http_response_code(404); exit('Invoice not found'); }
$totalAmount = (float)($inv['amount'] ?? ($inv['total'] ?? 0));
$dueDate = (string)($inv['due_date'] ?? ($inv['created_at'] ?? ''));
$status = (string)($inv['status'] ?? 'unpaid');
$tenantId = (int)($inv['tenant_id'] ?? ($inv['user_id'] ?? 0));
$dealId = (int)($inv['deal_id'] ?? 0);
$clientName = '';
$propertyDesc = '';
$amountPaid = 0.0;
try {
    $hasDS = $pdo->query("SHOW TABLES LIKE 'deals_submit'")->rowCount() > 0;
    if ($hasDS) {
        $where = ''; $params = [];
        if ($dealId > 0 && function_exists('tableHasColumn') && tableHasColumn('deals_submit','id') && function_exists('tableHasColumn') && tableHasColumn('invoices','deal_id')) {
            $where = "id = ?"; $params[] = $dealId;
        } elseif ($tenantId > 0) {
            if (function_exists('tableHasColumn') && tableHasColumn('deals_submit','user_id')) { $where = "user_id = ?"; $params[] = $tenantId; }
            elseif (function_exists('tableHasColumn') && tableHasColumn('deals_submit','client_id')) { $where = "client_id = ?"; $params[] = $tenantId; }
        }
        if ($where !== '') {
            $cols = "client_name, project_desc, project_name, property_title, property_name"
                . (function_exists('tableHasColumn') && tableHasColumn('deals_submit','amount_paid_so_far') ? ", amount_paid_so_far" : "")
                . (function_exists('tableHasColumn') && tableHasColumn('deals_submit','meta_json') ? ", meta_json" : "");
            $q = "SELECT $cols FROM deals_submit WHERE $where ORDER BY id DESC LIMIT 1";
            $st = $pdo->prepare($q); $st->execute($params);
            $ds = $st->fetch(PDO::FETCH_ASSOC) ?: [];
            if ($ds) {
                $clientName = (string)($ds['client_name'] ?? '');
                $propertyDesc = (string)($ds['project_desc'] ?? ($ds['project_name'] ?? ($ds['property_title'] ?? ($ds['property_name'] ?? ''))));
                if (isset($ds['amount_paid_so_far'])) { $amountPaid = (float)$ds['amount_paid_so_far']; }
                if (($clientName === '' || $propertyDesc === '') && isset($ds['meta_json']) && $ds['meta_json']) {
                    $mj = json_decode($ds['meta_json'], true) ?: [];
                    if ($clientName === '') { $clientName = (string)($mj['client_name'] ?? ''); }
                    if ($propertyDesc === '') { $propertyDesc = (string)($mj['project_name'] ?? ($mj['project'] ?? ($mj['property'] ?? ''))); }
                }
            }
        }
    }
} catch (Throwable $e) {}
if ($clientName === '' && $tenantId > 0) {
    try {
        $st = $pdo->prepare("SELECT " . (function_exists('tableHasColumn') && tableHasColumn('users','name') ? "name" : "username") . " FROM users WHERE id = ? LIMIT 1");
        $st->execute([$tenantId]); $clientName = (string)($st->fetchColumn() ?: '');
    } catch (Throwable $e) {}
}
if ($propertyDesc === '' && isset($inv['lease_id'])) {
    try {
        $leaseId = (int)$inv['lease_id'];
        if ($leaseId > 0) {
            $q = "SELECT p.title FROM leases l JOIN properties p ON l.property_id = p.id WHERE l.id = ? LIMIT 1";
            $st = $pdo->prepare($q); $st->execute([$leaseId]); $propertyDesc = (string)($st->fetchColumn() ?: '');
        }
    } catch (Throwable $e) {}
}
$balance = max(0.0, $totalAmount - $amountPaid);
$invoiceNumber = generateInvoiceNumber($invId);
require_once __DIR__ . '/vendor/autoload.php';
use Dompdf\Dompdf;
use Dompdf\Options;
$options = new Options();
$options->set('isRemoteEnabled', true);
$dompdf = new Dompdf($options);
$logo = '';
$candidates = [
    __DIR__ . '/assets/logo.png',
    __DIR__ . '/assets/img/logo.png',
    __DIR__ . '/assets/images/logo.png',
    __DIR__ . '/images/logo.png'
];
foreach ($candidates as $p) { if (is_file($p)) { $logo = $p; break; } }
$logoTag = $logo !== '' ? '<img src="file://' . str_replace('\\','/',$logo) . '" style="height:60px;" />' : '<div style="font-weight:700;font-size:18px">Aiben Properties Ltd</div>';
$html = '
<html>
<head>
<meta charset="utf-8" />
<style>
body{font-family:DejaVu Sans,Arial,Helvetica,sans-serif;background:#fff;color:#111;font-size:12px}
.wrap{padding:24px}
.header{display:flex;align-items:center;justify-content:space-between;margin-bottom:18px}
.title{font-size:18px;font-weight:700}
table{width:100%;border-collapse:collapse}
th,td{border:1px solid #ddd;padding:8px}
th{background:#f7f7f7;text-align:left}
.footer{margin-top:24px;text-align:center;color:#555}
</style>
</head>
<body>
  <div class="wrap">
    <div class="header">
      <div>'.$logoTag.'</div>
      <div class="title">Invoice '.$invoiceNumber.'</div>
    </div>
    <table>
      <tbody>
        <tr><th>Company Name</th><td>Aiben Properties Ltd</td></tr>
        <tr><th>Invoice Number</th><td>'.$invoiceNumber.'</td></tr>
        <tr><th>Client Name</th><td>'.htmlspecialchars($clientName !== "" ? $clientName : "-").'</td></tr>
        <tr><th>Property</th><td>'.htmlspecialchars($propertyDesc !== "" ? $propertyDesc : "-").'</td></tr>
        <tr><th>Total Amount</th><td>₦'.number_format($totalAmount,2).'</td></tr>
        <tr><th>Amount Paid</th><td>₦'.number_format($amountPaid,2).'</td></tr>
        <tr><th>Balance</th><td>₦'.number_format($balance,2).'</td></tr>
        <tr><th>Due Date</th><td>'.($dueDate!==""?date("M d, Y", strtotime($dueDate)):"-").'</td></tr>
        <tr><th>Status</th><td>'.htmlspecialchars(ucfirst($status)).'</td></tr>
      </tbody>
    </table>
    <div class="footer">Thank you for your business</div>
  </div>
</body>
</html>';
$dompdf->loadHtml($html, 'UTF-8');
$dompdf->setPaper('A4', 'portrait');
$dompdf->render();
$dompdf->stream('Invoice_'.$invoiceNumber.'.pdf', ['Attachment' => true]);
exit;