

<?php
session_start();
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once __DIR__ . '/../app/Support/helpers.php';
require_once __DIR__ . '/../app/Core/Database.php';
require_once __DIR__ . '/../app/Core/View.php';
require_once __DIR__ . '/../app/Repositories/InvoiceRepository.php';
require_once __DIR__ . '/../app/Services/VatCalculator.php';
require_once __DIR__ . '/../app/Services/InvoiceBuilder.php';
require_once __DIR__ . '/../app/Services/PdfService.php';
require_once __DIR__ . '/../app/Services/ExcelGenerator.php';
require_once __DIR__ . '/../app/Controllers/DashboardController.php';
require_once __DIR__ . '/../app/Controllers/InvoiceController.php';

use App\Core\Database;
use App\Repositories\InvoiceRepository;
use App\Services\VatCalculator;
use App\Services\InvoiceBuilder;
use App\Services\PdfService;
use App\Services\ExcelGenerator;
use App\Controllers\DashboardController;
use App\Controllers\InvoiceController;

$config = require __DIR__ . '/../config/database.php';
$pdo = Database::connect($config);

$repository = new InvoiceRepository($pdo);
$calculator = new VatCalculator(0.20);
$builder = new InvoiceBuilder($calculator);
$pdfService = new PdfService();
$excelService = new ExcelGenerator();
$dashboardController = new DashboardController($repository);
$invoiceController = new InvoiceController($repository, $calculator, $builder, $pdfService, $excelService);

$action = $_GET['action'] ?? 'dashboard';
$dashboardYear = isset($_GET['year']) ? (int)$_GET['year'] : (int)date('Y');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if ($action === 'store') $invoiceController->store();
    if ($action === 'update') $invoiceController->update();
    if ($action === 'form') {
    include __DIR__ . '/../app/Views/invoices/form.php';
    exit;
}

if ($action === 'edit') {
    $edit = $repository->find((int)($_GET['id'] ?? 0));
    include __DIR__ . '/../app/Views/invoices/form.php';
    exit;
}


    if ($action === 'delete') $invoiceController->delete();
    if ($action === 'tva') $invoiceController->selectedVat();
}

if ($action === 'pdf') {
    $invoiceController->pdf();
    exit;
}

if ($action === 'csv') {
    // Filtres liste
$listYear    = isset($_GET['year'])    ? (int)$_GET['year']    : (int)date('Y');
$listPage    = isset($_GET['page'])    ? max(1,(int)$_GET['page']) : 1;
$listSort    = isset($_GET['sort'])    ? $_GET['sort']    : 'date_desc';
$listQuarter = isset($_GET['quarter']) ? trim($_GET['quarter']) : '';
$listQ       = isset($_GET['q'])       ? trim($_GET['q'])       : '';
$perPage     = 20;
$totalInv    = $repository->countSearch($listYear, $listQuarter, $listQ);
$pages       = max(1, (int)ceil($totalInv / $perPage));
if ($listPage > $pages) $listPage = $pages;
$invoices    = $repository->search($listYear, $listPage, $perPage, $listSort, $listQuarter, $listQ);
$availYears  = $repository->availableYears();
    header('Content-Type: text/csv; charset=UTF-8');
    header('Content-Disposition: attachment; filename="factures.csv"');
    $out = fopen('php://output', 'w');
    fputcsv($out, ['FACTURE', 'NUMERO', 'DATE', 'TRIMESTRE', 'ANNEE'], ';');
    fputcsv($out, ['LIGNE', 'DESIGNATION', 'QTE', 'PU HT', 'TOTAL HT'], ';');
    fputcsv($out, [], ';');
    foreach ($invoices as $inv) {
        fputcsv($out, ['FACTURE', $inv['invoice_number'], $inv['invoice_date'], $inv['quarter'], $inv['year']], ';');
        $it = $pdo->prepare('SELECT * FROM invoice_items WHERE invoice_id=:id ORDER BY id ASC');
        $it->execute(['id' => $inv['id']]);
        foreach ($it->fetchAll() as $item) {
            fputcsv($out, ['LIGNE', $item['description'], $item['quantity'], $item['unit_price_ht'], $item['line_total_ht']], ';');
        }
        fputcsv($out, ['TOTAL HT', $inv['total_ht']], ';');
        fputcsv($out, ['TVA 20%', $inv['total_vat']], ';');
        fputcsv($out, ['TOTAL TTC', $inv['total_ttc']], ';');
        fputcsv($out, [], ';');
    }
    fclose($out);
    exit;
}

if ($action === 'excel') {
    $xid = isset($_GET['id']) ? (int)$_GET['id'] : 0;
    if ($xid > 0) {
        ob_end_clean();
        header('Location: /TV@/dlxls.php?id=' . $xid);
        exit;
    }
    if (!empty($_POST['invoice_ids'])) {
        ob_end_clean();
        require_once dirname(__DIR__) . '/dlxls.php';
        exit;
    }
    echo '<div class="container py-4"><div class="alert alert-warning">Selectionnez au moins une facture.</div></div>';
    exit;
}

$invoices = $repository->all();
$selectedTotals = $_SESSION['selected_totals'] ?? null;
unset($_SESSION['selected_totals']);

$edit = null;
if ($action === 'edit') {
    $edit = $repository->find((int)($_GET['id'] ?? 0));
}

$yearInvoices = array_values(array_filter($invoices, fn($inv) => (int)$inv['year'] === $dashboardYear));
$yearTotals = ['c' => count($yearInvoices), 'ht' => 0, 'vat' => 0, 'ttc' => 0];
foreach ($yearInvoices as $inv) {
    $yearTotals['ht'] += (float)$inv['total_ht'];
    $yearTotals['vat'] += (float)$inv['total_vat'];
    $yearTotals['ttc'] += (float)$inv['total_ttc'];
}
$quarters = $repository->quarterSummary($dashboardYear);
$latest = array_slice($yearInvoices, 0, 10);
$nextNumber = $repository->nextNumber();
?>
<!doctype html>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Facturation TVA</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="assets/css/style.css">
</head>
<body class="bg-light">
<div class="container py-4">
  <div class="card card-soft mb-4">
    <div class="card-body d-flex justify-content-between align-items-center flex-wrap gap-2">
      <div>
        <h1 class="h4 mb-1">Facturation TVA</h1>
        <div class="text-muted">Dashboard, factures, TVA, PDF, CSV, Excel</div>
      </div>
      <div class="d-flex gap-2 flex-wrap">
        <a href="?action=dashboard&year=<?= (int)$dashboardYear ?>" class="btn btn-outline-primary btn-sm">Dashboard</a>
        <a href="?action=list" class="btn btn-outline-primary btn-sm">Factures</a>
        <a href="?action=form" class="btn btn-primary btn-sm">Nouvelle facture</a>
        <a href="?action=csv" class="btn btn-outline-success btn-sm">Export CSV</a>
        <a href="?action=excel" class="btn btn-success btn-sm">Export Excel</a>
      </div>
    </div>
  </div>

  <?php if (!empty($_SESSION['success'])): ?>
    <div class="alert alert-success"><?= e($_SESSION['success']); unset($_SESSION['success']); ?></div>
  <?php endif; ?>

  <?php if (!empty($_SESSION['error'])): ?>
    <div class="alert alert-danger"><?= e($_SESSION['error']); unset($_SESSION['error']); ?></div>
  <?php endif; ?>

  <?php if ($action === 'dashboard'): ?>
    <div class="card card-soft mb-4">
      <div class="card-body">
        <div class="d-flex justify-content-between align-items-center flex-wrap gap-2 mb-3">
          <h2 class="h5 mb-0">Dashboard <?= (int)$dashboardYear ?></h2>
          <form method="get" class="d-flex gap-2 align-items-center">
            <input type="hidden" name="action" value="dashboard">
            <select name="year" class="form-select form-select-sm" style="width:auto">
              <?php for ($y = date('Y'); $y >= date('Y') - 5; $y--): ?>
                <option value="<?= (int)$y ?>" <?= $dashboardYear == $y ? 'selected' : '' ?>><?= (int)$y ?></option>
              <?php endfor; ?>
            </select>
            <button class="btn btn-sm btn-primary" type="submit">Voir</button>
          </form>
        </div>

        <div class="row g-3 mb-4">
          <div class="col-md-3"><div class="card card-soft"><div class="card-body"><div class="text-muted">Factures <?= (int)$dashboardYear ?></div><div class="fs-4 fw-bold"><?= (int)$yearTotals['c'] ?></div></div></div></div>
          <div class="col-md-3"><div class="card card-soft"><div class="card-body"><div class="text-muted">Total HT</div><div class="fs-4 fw-bold"><?= money($yearTotals['ht']) ?></div></div></div></div>
          <div class="col-md-3"><div class="card card-soft"><div class="card-body"><div class="text-muted">TVA</div><div class="fs-4 fw-bold"><?= money($yearTotals['vat']) ?></div></div></div></div>
          <div class="col-md-3"><div class="card card-soft"><div class="card-body"><div class="text-muted">TTC</div><div class="fs-4 fw-bold"><?= money($yearTotals['ttc']) ?></div></div></div></div>
        </div>

        <div class="table-responsive">
          <table class="table table-sm align-middle mb-0">
            <thead><tr><th>Trimestre</th><th>Factures</th><th>HT</th><th>TVA</th><th>TTC</th></tr></thead>
            <tbody>
              <?php foreach($quarters as $q): ?>
                <tr>
                  <td><?= e($q['quarter']) ?></td>
                  <td><?= (int)$q['c'] ?></td>
                  <td><?= money($q['ht']) ?></td>
                  <td><?= money($q['vat']) ?></td>
                  <td><?= money($q['ttc']) ?></td>
                </tr>
              <?php endforeach; ?>
            </tbody>
          </table>
        </div>
      </div>
    </div>

    <div class="card card-soft">
      <div class="card-body">
        <h2 class="h5 mb-3">Dernières factures de l’année <?= (int)$dashboardYear ?></h2>
        <div class="table-responsive">
          <table class="table table-sm align-middle">
            <thead><tr><th>N°</th><th>Date</th><th>Trimestre</th><th>TVA</th><th>TTC</th></tr></thead>
            <tbody>
              <?php foreach($latest as $inv): ?>
                <tr>
                  <td><?= e($inv['invoice_number']) ?></td>
                  <td><?= e($inv['invoice_date']) ?></td>
                  <td><?= e($inv['quarter']) ?></td>
                  <td><?= money($inv['total_vat']) ?></td>
                  <td><?= money($inv['total_ttc']) ?></td>
                </tr>
              <?php endforeach; ?>
            </tbody>
          </table>
        </div>
      </div>
    </div>

<?php elseif ($action === 'list'): ?>
<?php
$listYear    = isset($_GET['year'])    ? (int)$_GET['year']    : (int)date('Y');
$listPage    = isset($_GET['page'])    ? max(1,(int)$_GET['page']) : 1;
$listSort    = isset($_GET['sort'])    ? $_GET['sort']    : 'date_desc';
$listQuarter = isset($_GET['quarter']) ? trim($_GET['quarter']) : '';
$listQ       = isset($_GET['q'])       ? trim($_GET['q'])       : '';
$perPage     = 20;
$totalInv    = $repository->countSearch($listYear, $listQuarter, $listQ);
$pages       = max(1,(int)ceil($totalInv / $perPage));
if ($listPage > $pages) $listPage = $pages;
$invoices    = $repository->search($listYear, $listPage, $perPage, $listSort, $listQuarter, $listQ);
$availYears  = $repository->availableYears();
$baseParams  = http_build_query(array_filter(["action"=>"list","year"=>$listYear,"sort"=>$listSort,"quarter"=>$listQuarter,"q"=>$listQ],fn($v)=>$v!==" "&&$v!==null&&$v!==0));
?>

<div class="card card-soft mb-3">
  <div class="card-body py-2">
    <form method="get" id="filterForm" class="row g-2 align-items-end">
      <input type="hidden" name="action" value="list">
      <div class="col-auto">
        <label class="form-label mb-1 small text-muted">Ann&eacute;e</label>
        <select name="year" class="form-select form-select-sm" style="width:100px" onchange="document.getElementById(&apos;filterForm&apos;).submit()">
          <?php foreach ($availYears as $y): ?>
            <option value="<?= (int)$y ?>" <?= (int)$y===$listYear?"selected":"" ?>><?= (int)$y ?></option>
          <?php endforeach; ?>
        </select>
      </div>
      <div class="col-auto">
        <label class="form-label mb-1 small text-muted">Trimestre</label>
        <select name="quarter" class="form-select form-select-sm" style="width:120px" onchange="document.getElementById(&apos;filterForm&apos;).submit()">
          <option value="" <?= $listQuarter===""?"selected":"" ?>>Tous</option>
          <option value="Q1" <?= $listQuarter==="Q1"?"selected":"" ?>>T1 (Jan-Mar)</option>
          <option value="Q2" <?= $listQuarter==="Q2"?"selected":"" ?>>T2 (Avr-Jun)</option>
          <option value="Q3" <?= $listQuarter==="Q3"?"selected":"" ?>>T3 (Jul-Sep)</option>
          <option value="Q4" <?= $listQuarter==="Q4"?"selected":"" ?>>T4 (Oct-Dec)</option>
        </select>
      </div>
      <div class="col-auto">
        <label class="form-label mb-1 small text-muted">Trier</label>
        <select name="sort" class="form-select form-select-sm" style="width:150px" onchange="document.getElementById(&apos;filterForm&apos;).submit()">
          <option value="date_desc" <?= $listSort==="date_desc"?"selected":"" ?>>Date d&eacute;croissante</option>
          <option value="date_asc"  <?= $listSort==="date_asc"?"selected":"" ?>>Date croissante</option>
        </select>
      </div>
      <div class="col-auto">
        <label class="form-label mb-1 small text-muted">Recherche article</label>
        <div class="input-group input-group-sm">
          <input type="text" name="q" class="form-control" placeholder="Ex: b&eacute;ton, dalle..." value="<?= htmlspecialchars($listQ) ?>" style="width:180px">
          <button type="submit" class="btn btn-primary btn-sm">OK</button>
        </div>
      </div>
      <div class="col-auto">
        <label class="form-label mb-1 d-block">&nbsp;</label>
        <?php if ($listQuarter!==" "||$listQ!==" "||$listSort!=="date_desc"): ?>
          <a href="?action=list&amp;year=<?= $listYear ?>" class="btn btn-sm btn-outline-danger">Effacer</a>
        <?php endif; ?>
      </div>
      <div class="col-auto ms-auto">
        <label class="form-label mb-1 d-block">&nbsp;</label>
        <span class="text-muted small"><?= $totalInv ?> facture(s)</span>
      </div>
    </form>
  </div>
</div>

<div class="card card-soft">
  <div class="card-body p-0">
    <form method="post" action="?action=tva" id="invForm">
      <div class="d-flex align-items-center gap-2 px-3 py-2 border-bottom bg-light rounded-top">
        <div class="form-check mb-0">
          <input class="form-check-input" type="checkbox" id="chkAll" onchange="toggleAll(this)">
          <label class="form-check-label small" for="chkAll">Tout s&eacute;lectionner</label>
        </div>
        <button type="button" class="btn btn-sm btn-outline-secondary" onclick="deselectAll()">D&eacute;s&eacute;lectionner tout</button>
        <span class="badge bg-secondary" id="selCount">0 s&eacute;lectionn&eacute;(s)</span>
        <div class="ms-auto d-flex gap-2">
          <button type="submit" formaction="?action=tva" class="btn btn-sm btn-outline-info">TVA</button>
          <button type="submit" formaction="/TV@/dlxls.php" class="btn btn-sm btn-success">Export Excel</button>
        </div>
      </div>
      <div class="table-responsive">
        <table class="table table-sm align-middle mb-0">
          <thead class="table-light">
            <tr>
              <th style="width:36px"></th>
              <th>N&deg;</th>
              <th>Client</th>
              <th>Date</th>
              <th>Trimestre</th>
              <th class="text-end">HT</th>
              <th class="text-end">TVA</th>
              <th class="text-end">TTC</th>
              <th class="text-center">Actions</th>
            </tr>
          </thead>
          <tbody>
          <?php if (empty($invoices)): ?>
            <tr><td colspan="9" class="text-center text-muted py-4">Aucune facture trouv&eacute;e</td></tr>
          <?php else: ?>
            <?php foreach ($invoices as $inv): ?>
            <tr>
              <td><input type="checkbox" name="invoice_ids[]" value="<?= $inv["id"] ?>" class="form-check-input chk" onchange="saveSelection();updateCount()"></td>
              <td><strong><?= e($inv["invoice_number"]) ?></strong></td>
              <td class="text-truncate" style="max-width:150px"><?= e($inv["client_name"]??"") ?></td>
              <td><?= e($inv["invoice_date"]) ?></td>
              <td><span class="badge bg-light text-dark border"><?= e($inv["quarter"]) ?></span></td>
              <td class="text-end"><?= money($inv["total_ht"]) ?></td>
              <td class="text-end"><?= money($inv["total_vat"]) ?></td>
              <td class="text-end fw-semibold"><?= money($inv["total_ttc"]) ?></td>
              <td class="text-center">
                <a href="?action=edit&amp;id=<?= $inv["id"] ?>" class="btn btn-sm btn-outline-primary py-0 px-1">Modifier</a>
                <a href="/TV@/genpdf.php?id=<?= $inv["id"] ?>" target="_blank" class="btn btn-sm btn-outline-danger py-0 px-1">PDF</a>
                <a href="/TV@/dlxls.php?id=<?= $inv["id"] ?>" class="btn btn-sm btn-outline-success py-0 px-1">XLS</a>
                <a href="?action=delete&amp;id=<?= $inv["id"] ?>" class="btn btn-sm btn-outline-secondary py-0 px-1" onclick="return confirm(&apos;Supprimer ?&apos;)">Suppr.</a>
              </td>
            </tr>
            <?php endforeach; ?>
          <?php endif; ?>
          </tbody>
        </table>
      </div>
      <?php if ($pages>1): ?>
      <nav class="d-flex justify-content-center align-items-center py-3 gap-1 flex-wrap">
        <?php if ($listPage>1): ?><a href="?<?= $baseParams ?>&amp;page=<?= $listPage-1 ?>" class="btn btn-sm btn-outline-secondary">&laquo;</a><?php endif; ?>
        <?php $ps=max(1,$listPage-3);$pe=min($pages,$listPage+3); ?>
        <?php if($ps>1): ?><a href="?<?= $baseParams ?>&amp;page=1" class="btn btn-sm btn-outline-secondary">1</a><?php if($ps>2): ?><span class="px-1 text-muted">...</span><?php endif; endif; ?>
        <?php for($p=$ps;$p<=$pe;$p++): ?>
          <a href="?<?= $baseParams ?>&amp;page=<?= $p ?>" class="btn btn-sm <?= $p===$listPage?"btn-primary":"btn-outline-secondary" ?>"><?= $p ?></a>
        <?php endfor; ?>
        <?php if($pe<$pages): ?><?php if($pe<$pages-1): ?><span class="px-1 text-muted">...</span><?php endif; ?><a href="?<?= $baseParams ?>&amp;page=<?= $pages ?>" class="btn btn-sm btn-outline-secondary"><?= $pages ?></a><?php endif; ?>
        <?php if($listPage<$pages): ?><a href="?<?= $baseParams ?>&amp;page=<?= $listPage+1 ?>" class="btn btn-sm btn-outline-secondary">&raquo;</a><?php endif; ?>
        <small class="text-muted ms-2">Page <?= $listPage ?>/<?= $pages ?></small>
      </nav>
      <?php endif; ?>
    </form>
  </div>
</div>
<script>
const _SK="inv_sel";
function _getS(){try{return JSON.parse(sessionStorage.getItem(_SK)||"[]")}catch(e){return[]}}
function saveSelection(){const s=_getS();document.querySelectorAll(".chk").forEach(c=>{const id=c.value;if(c.checked&&!s.includes(id))s.push(id);else if(!c.checked){const i=s.indexOf(id);if(i>-1)s.splice(i,1);}});sessionStorage.setItem(_SK,JSON.stringify(s));updateCount();}
function restoreSelection(){const s=_getS();document.querySelectorAll(".chk").forEach(c=>c.checked=s.includes(c.value));updateCount();syncChkAll();}
function updateCount(){document.getElementById("selCount").textContent=_getS().length+" sélectionné(s)";}
function toggleAll(m){document.querySelectorAll(".chk").forEach(c=>c.checked=m.checked);saveSelection();}
function deselectAll(){sessionStorage.removeItem(_SK);document.querySelectorAll(".chk").forEach(c=>c.checked=false);document.getElementById("chkAll").checked=false;updateCount();}
function syncChkAll(){const a=document.querySelectorAll(".chk").length,c=document.querySelectorAll(".chk:checked").length;const el=document.getElementById("chkAll");el.checked=a>0&&c===a;el.indeterminate=c>0&&c<a;}
document.getElementById("invForm").addEventListener("submit",function(e){const btn=e.submitter;const s=_getS();this.querySelectorAll("input[name=\"invoice_ids[]\"]").forEach(e=>e.remove());s.forEach(id=>{const i=document.createElement("input");i.type="hidden";i.name="invoice_ids[]";i.value=id;this.appendChild(i);});if(btn&&btn.getAttribute("formaction")){this.action=btn.getAttribute("formaction");}});
document.addEventListener("DOMContentLoaded",()=>restoreSelection());
</script>
<?php endif; ?>
</div>
</body>
</html>