@extends('layouts.app')
@section('title', 'États & Rapports')
@section('breadcrumb', 'États')
@section('content')

@php
function fmtNum($v){ return number_format($v,3,',',' '); }
$statutColors = ['en_cours'=>'warning','pause'=>'muted','cloture'=>'success','sav'=>'info','demarrage'=>'muted'];
@endphp

<div class="page-header">
    <div><h1 class="page-title"><i class="fas fa-chart-bar" style="color:var(--info)"></i> États & Rapports</h1></div>
    <div class="page-actions">
        <button class="btn btn-secondary btn-sm" onclick="window.print()"><i class="fas fa-print"></i> Imprimer</button>
    </div>
</div>

{{-- Filtres globaux --}}
<div class="card" style="margin-bottom:12px">
    <div class="card-body" style="padding:12px 16px;">
        <form method="GET" action="{{ route('etats.index') }}" style="display:flex;gap:10px;flex-wrap:wrap;align-items:center;">
            <input type="hidden" name="tab" id="activeTabInput" value="{{ $tab }}">
            <span style="font-size:12px;color:var(--text-muted);white-space:nowrap;">Filtrer :</span>
            <input type="date" name="deb" class="form-control" value="{{ $deb }}" title="Date début" style="max-width:150px;">
            <input type="date" name="fin" class="form-control" value="{{ $fin }}" title="Date fin" style="max-width:150px;">
            <select name="mois" class="form-control" style="max-width:130px;" onchange="applyMoisFilter(this)">
                <option value="">— Mois —</option>
                @foreach(['janvier','février','mars','avril','mai','juin','juillet','août','septembre','octobre','novembre','décembre'] as $i => $m)
                    <option value="{{ $i+1 }}" {{ $mois==($i+1) ? 'selected' : '' }}>{{ ucfirst($m) }}</option>
                @endforeach
            </select>
            <input type="number" name="annee" class="form-control" placeholder="Année" min="2020" max="2035" value="{{ $annee }}" style="max-width:90px;">
            <button type="submit" class="btn btn-primary btn-sm"><i class="fas fa-filter"></i> Filtrer</button>
            <a href="{{ route('etats.index') }}" class="btn btn-secondary btn-sm"><i class="fas fa-xmark"></i> Réinitialiser</a>
        </form>
    </div>
</div>

{{-- Onglets --}}
<div x-data="{ activeTab: '{{ $tab }}' }" x-init="document.getElementById('activeTabInput').value = activeTab">

<div class="tabs">
    @foreach([
        ['journal_vente', 'Journal Vente'],
        ['journal_achat', 'Journal Achat'],
        ['balance_clients', 'Balances Clients'],
        ['balance_fournisseurs', 'Balances Fournisseurs'],
        ['recap_depenses', 'Récap Dépenses'],
        ['rentabilite', 'Rentabilité Chantiers'],
    ] as [$key, $label])
    <button class="tab-btn" :class="activeTab==='{{ $key }}' ? 'active' : ''"
        @click="activeTab='{{ $key }}'; document.getElementById('activeTabInput').value='{{ $key }}'">
        {{ $label }}
    </button>
    @endforeach
</div>

{{-- =================== JOURNAL VENTE =================== --}}
<div x-show="activeTab==='journal_vente'" x-cloak>
@php
    $totVHT  = $journalVente->sum('total_ht');
    $totVTVA = $journalVente->sum('total_tva');
    $totVTTC = $journalVente->sum('total_ttc');
    $exportParams = array_filter(['deb'=>$deb,'fin'=>$fin,'annee'=>$annee]);
@endphp
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.journal_vente', $exportParams) }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr>
                <th>Date</th><th>N° Facture</th><th>Client</th><th>Chantier</th>
                <th style="text-align:right">HT</th><th style="text-align:right">TVA</th><th style="text-align:right">TTC</th>
            </tr></thead>
            <tbody>
            @forelse($journalVente as $d)
            <tr>
                <td>{{ \Carbon\Carbon::parse($d->date)->format('d/m/Y') }}</td>
                <td><strong>{{ $d->numero }}</strong></td>
                <td>{{ $d->client?->nom ?? '—' }}</td>
                <td>@if($d->chantier)<span class="badge badge-warning" style="font-size:10px">{{ $d->chantier->nom }}</span>@else —@endif</td>
                <td style="text-align:right">{{ fmtNum($d->total_ht) }}</td>
                <td style="text-align:right">{{ fmtNum($d->total_tva) }}</td>
                <td style="text-align:right;font-weight:700">{{ fmtNum($d->total_ttc) }}</td>
            </tr>
            @empty
            <tr><td colspan="7" class="empty-state"><i class="fas fa-book"></i> Aucune écriture</td></tr>
            @endforelse
            </tbody>
            @if($journalVente->count())
            <tfoot><tr style="background:var(--bg);font-weight:700">
                <td colspan="4">TOTAL ({{ $journalVente->count() }})</td>
                <td style="text-align:right">{{ fmtNum($totVHT) }}</td>
                <td style="text-align:right">{{ fmtNum($totVTVA) }}</td>
                <td style="text-align:right;color:var(--primary)">{{ fmtNum($totVTTC) }}</td>
            </tr></tfoot>
            @endif
        </table>
    </div>
</div>
</div>

{{-- =================== JOURNAL ACHAT =================== --}}
<div x-show="activeTab==='journal_achat'" x-cloak>
@php
    $totAHT  = $journalAchat->sum('total_ht');
    $totATVA = $journalAchat->sum('total_tva');
    $totATTC = $journalAchat->sum('total_ttc');
@endphp
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.journal_achat', $exportParams) }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr>
                <th>Date</th><th>N° Facture</th><th>Fournisseur</th><th>Chantier</th>
                <th style="text-align:right">HT</th><th style="text-align:right">TVA</th><th style="text-align:right">TTC</th>
            </tr></thead>
            <tbody>
            @forelse($journalAchat as $d)
            <tr>
                <td>{{ \Carbon\Carbon::parse($d->date)->format('d/m/Y') }}</td>
                <td><strong>{{ $d->numero }}</strong></td>
                <td>{{ $d->fournisseur?->nom ?? '—' }}</td>
                <td>@if($d->chantier)<span class="badge badge-warning" style="font-size:10px">{{ $d->chantier->nom }}</span>@else —@endif</td>
                <td style="text-align:right">{{ fmtNum($d->total_ht) }}</td>
                <td style="text-align:right">{{ fmtNum($d->total_tva) }}</td>
                <td style="text-align:right;font-weight:700">{{ fmtNum($d->total_ttc) }}</td>
            </tr>
            @empty
            <tr><td colspan="7" class="empty-state"><i class="fas fa-book"></i> Aucune écriture</td></tr>
            @endforelse
            </tbody>
            @if($journalAchat->count())
            <tfoot><tr style="background:var(--bg);font-weight:700">
                <td colspan="4">TOTAL ({{ $journalAchat->count() }})</td>
                <td style="text-align:right">{{ fmtNum($totAHT) }}</td>
                <td style="text-align:right">{{ fmtNum($totATVA) }}</td>
                <td style="text-align:right;color:var(--danger)">{{ fmtNum($totATTC) }}</td>
            </tr></tfoot>
            @endif
        </table>
    </div>
</div>
</div>

{{-- =================== BALANCE CLIENTS =================== --}}
<div x-show="activeTab==='balance_clients'" x-cloak>
@php
    $totBCFact=0; $totBCAvoir=0; $totBCRegle=0;
@endphp
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.balance_clients', $exportParams) }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr>
                <th>Code</th><th>Client</th><th>Groupe</th>
                <th style="text-align:right">CA Facturé TTC</th>
                <th style="text-align:right">Avoirs TTC</th>
                <th style="text-align:right">Réglé</th>
                <th style="text-align:right">Solde</th>
                <th></th>
            </tr></thead>
            <tbody>
            @forelse($balanceClients as $c)
            @php
                $factures = $c->venteDocuments->where('type','facture_vente')->sum('total_ttc');
                $avoirs   = $c->venteDocuments->where('type','avoir_vente')->sum('total_ttc');
                $regle    = $reglClientsMap[$c->id] ?? 0;
                $solde    = $c->solde ?? ($factures - $avoirs - $regle);
                $totBCFact += $factures; $totBCAvoir += $avoirs; $totBCRegle += $regle;
            @endphp
            <tr>
                <td><code>{{ $c->code }}</code></td>
                <td style="font-weight:600"><a href="{{ route('clients.show', $c) }}" style="color:var(--primary)">{{ $c->nom }}</a></td>
                <td>{{ $c->groupe?->nom ?? '—' }}</td>
                <td style="text-align:right">{{ fmtNum($factures) }}</td>
                <td style="text-align:right;color:var(--warning)">{{ fmtNum($avoirs) }}</td>
                <td style="text-align:right;color:var(--success)">{{ fmtNum($regle) }}</td>
                <td style="text-align:right;font-weight:700;color:{{ $solde > 0 ? 'var(--danger)' : 'var(--success)' }}">{{ fmtNum($solde) }}</td>
                <td><a href="{{ route('clients.show', $c) }}" class="action-btn"><i class="fas fa-eye"></i></a></td>
            </tr>
            @empty
            <tr><td colspan="8" class="empty-state">Aucun client</td></tr>
            @endforelse
            </tbody>
            @if($balanceClients->count())
            <tfoot><tr style="background:var(--bg);font-weight:700">
                <td colspan="3">TOTAL ({{ $balanceClients->count() }})</td>
                <td style="text-align:right">{{ fmtNum($totBCFact) }}</td>
                <td style="text-align:right;color:var(--warning)">{{ fmtNum($totBCAvoir) }}</td>
                <td style="text-align:right;color:var(--success)">{{ fmtNum($totBCRegle) }}</td>
                <td style="text-align:right;color:{{ ($totBCFact-$totBCAvoir-$totBCRegle)>0?'var(--danger)':'var(--success)' }}">{{ fmtNum($totBCFact-$totBCAvoir-$totBCRegle) }}</td>
                <td></td>
            </tr></tfoot>
            @endif
        </table>
    </div>
</div>
</div>

{{-- =================== BALANCE FOURNISSEURS =================== --}}
<div x-show="activeTab==='balance_fournisseurs'" x-cloak>
@php
    $totBFAchat=0; $totBFAvoir=0; $totBFRegle=0;
@endphp
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.balance_fournisseurs', $exportParams) }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr>
                <th>Code</th><th>Fournisseur</th><th>Groupe</th>
                <th style="text-align:right">Achats TTC</th>
                <th style="text-align:right">Avoirs TTC</th>
                <th style="text-align:right">Réglé</th>
                <th style="text-align:right">Solde</th>
                <th></th>
            </tr></thead>
            <tbody>
            @forelse($balanceFournisseurs as $f)
            @php
                $achats  = $f->achatDocuments->where('type','facture_achat')->sum('total_ttc');
                $avoirs  = $f->achatDocuments->where('type','avoir_achat')->sum('total_ttc');
                $regle   = $reglFouMap[$f->id] ?? 0;
                $solde   = $f->solde ?? ($achats - $avoirs - $regle);
                $totBFAchat += $achats; $totBFAvoir += $avoirs; $totBFRegle += $regle;
            @endphp
            <tr>
                <td><code>{{ $f->code }}</code></td>
                <td style="font-weight:600"><a href="{{ route('fournisseurs.show', $f) }}" style="color:var(--primary)">{{ $f->nom }}</a></td>
                <td>{{ $f->groupe?->nom ?? '—' }}</td>
                <td style="text-align:right">{{ fmtNum($achats) }}</td>
                <td style="text-align:right;color:var(--warning)">{{ fmtNum($avoirs) }}</td>
                <td style="text-align:right;color:var(--success)">{{ fmtNum($regle) }}</td>
                <td style="text-align:right;font-weight:700;color:{{ $solde > 0 ? 'var(--danger)' : 'var(--success)' }}">{{ fmtNum($solde) }}</td>
                <td><a href="{{ route('fournisseurs.show', $f) }}" class="action-btn"><i class="fas fa-eye"></i></a></td>
            </tr>
            @empty
            <tr><td colspan="8" class="empty-state">Aucun fournisseur</td></tr>
            @endforelse
            </tbody>
            @if($balanceFournisseurs->count())
            <tfoot><tr style="background:var(--bg);font-weight:700">
                <td colspan="3">TOTAL ({{ $balanceFournisseurs->count() }})</td>
                <td style="text-align:right">{{ fmtNum($totBFAchat) }}</td>
                <td style="text-align:right;color:var(--warning)">{{ fmtNum($totBFAvoir) }}</td>
                <td style="text-align:right;color:var(--success)">{{ fmtNum($totBFRegle) }}</td>
                <td style="text-align:right;color:{{ ($totBFAchat-$totBFAvoir-$totBFRegle)>0?'var(--danger)':'var(--success)' }}">{{ fmtNum($totBFAchat-$totBFAvoir-$totBFRegle) }}</td>
                <td></td>
            </tr></tfoot>
            @endif
        </table>
    </div>
</div>
</div>

{{-- =================== RÉCAP DÉPENSES =================== --}}
<div x-show="activeTab==='recap_depenses'" x-cloak>
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.recap_depenses', $exportParams) }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
@if($recapDepenses->isEmpty())
<div class="empty-state"><i class="fas fa-receipt"></i><h4>Aucune dépense</h4></div>
@else
<div class="grid-3" style="margin-bottom:16px">
    @foreach($recapDepenses as $cat => $montant)
    <div class="card" style="background:var(--bg)">
        <div class="card-body" style="display:flex;align-items:center;gap:14px;padding:16px">
            <div style="width:44px;height:44px;border-radius:12px;background:#fef2f2;display:flex;align-items:center;justify-content:center;flex-shrink:0">
                <i class="fas fa-receipt" style="color:#ef4444;font-size:18px"></i>
            </div>
            <div>
                <div style="font-size:18px;font-weight:700;color:#ef4444">{{ fmtNum($montant) }}</div>
                <div style="font-size:12px;color:var(--text-muted)">{{ $cat }}</div>
            </div>
        </div>
    </div>
    @endforeach
</div>
<div class="alert" style="background:#fef2f2;border:1px solid #fecaca;border-radius:8px;padding:12px 16px;margin-bottom:16px;color:#ef4444;font-weight:700">
    <i class="fas fa-receipt"></i> Total dépenses : {{ fmtNum($totalDepenses) }} TND
</div>
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr><th>Catégorie</th><th style="text-align:right">Montant TTC</th><th style="text-align:right">%</th></tr></thead>
            <tbody>
            @foreach($recapDepenses->sortDesc() as $cat => $montant)
            <tr>
                <td>{{ $cat }}</td>
                <td style="text-align:right;font-weight:600;color:#ef4444">{{ fmtNum($montant) }} TND</td>
                <td style="text-align:right">{{ $totalDepenses > 0 ? number_format($montant/$totalDepenses*100,1,',','') . '%' : '—' }}</td>
            </tr>
            @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif
</div>

{{-- =================== RENTABILITÉ CHANTIERS =================== --}}
<div x-show="activeTab==='rentabilite'" x-cloak>
<div style="display:flex;justify-content:flex-end;margin-bottom:8px">
    <a href="{{ route('etats.export.rentabilite') }}" class="btn btn-secondary btn-sm"><i class="fas fa-file-csv"></i> Exporter CSV</a>
</div>
@if($chantiers->isEmpty())
<div class="empty-state"><i class="fas fa-hard-hat"></i><h4>Aucun chantier</h4></div>
@else
<div class="card">
    <div class="table-wrap">
        <table class="table">
            <thead><tr>
                <th>Code</th><th>Chantier</th><th>Client</th>
                <th style="text-align:right">CA Facturé</th>
                <th style="text-align:right">Achats</th>
                <th style="text-align:right">Dépenses</th>
                <th style="text-align:right">RH</th>
                <th style="text-align:right">Coût Total</th>
                <th style="text-align:right">Marge</th>
                <th style="text-align:right">Taux %</th>
                <th>Statut</th>
            </tr></thead>
            <tbody>
            @foreach($chantiers as $ch)
            @php
                $ca    = $ch->venteDocuments->sum('total_ttc');
                $achats = $ch->achatDocuments->sum('total_ttc');
                $deps  = $ch->depenses->sum('montant_ttc');
                $rh = $ch->rhAffectations->sum(function($a) {
                    $emp = $a->employe;
                    if (!$emp) return 0;
                    if ($a->type_calc === 'horaire') return ($emp->taux_horaire ?? 0) * ($a->heures ?? 0);
                    return (($emp->salaire_brut ?? 0) / 26) * ($a->jours ?? 0);
                });
                $cout  = $achats + $deps + $rh;
                $marge = $ca - $cout;
                $taux  = $ca > 0 ? ($marge / $ca * 100) : 0;
                $tauxColor = $taux >= 20 ? 'var(--success)' : ($taux >= 0 ? 'var(--warning)' : 'var(--danger)');
                $statLabel = ['en_cours'=>'En cours','pause'=>'Pause','cloture'=>'Clôturé','sav'=>'SAV','demarrage'=>'Démarrage'][$ch->statut] ?? $ch->statut;
            @endphp
            <tr>
                <td><code>{{ $ch->code }}</code></td>
                <td style="font-weight:600"><a href="{{ route('chantiers.show', $ch) }}" style="color:var(--primary)">{{ $ch->nom }}</a></td>
                <td>{{ $ch->client?->nom ?? '—' }}</td>
                <td style="text-align:right;color:var(--success);font-weight:600">{{ fmtNum($ca) }}</td>
                <td style="text-align:right;color:var(--warning)">{{ fmtNum($achats) }}</td>
                <td style="text-align:right;color:var(--danger)">{{ fmtNum($deps) }}</td>
                <td style="text-align:right;color:var(--info)">{{ fmtNum($rh) }}</td>
                <td style="text-align:right;font-weight:600">{{ fmtNum($cout) }}</td>
                <td style="text-align:right;font-weight:700;color:{{ $marge >= 0 ? 'var(--success)' : 'var(--danger)' }}">{{ fmtNum($marge) }}</td>
                <td style="text-align:right;font-weight:700;color:{{ $tauxColor }}">{{ number_format($taux,1,',','') }}%</td>
                <td><span class="badge badge-{{ $statutColors[$ch->statut] ?? 'muted' }}">{{ $statLabel }}</span></td>
            </tr>
            @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif
</div>

</div>{{-- end x-data --}}

<script>
function applyMoisFilter(select) {
    const m = select.value;
    if (!m) return;
    const anneeEl = document.querySelector('input[name="annee"]');
    const yr = anneeEl?.value || new Date().getFullYear();
    const deb = `${yr}-${String(m).padStart(2,'0')}-01`;
    const lastDay = new Date(parseInt(yr), parseInt(m), 0).toISOString().split('T')[0];
    const debEl = document.querySelector('input[name="deb"]');
    const finEl = document.querySelector('input[name="fin"]');
    if (debEl) debEl.value = deb;
    if (finEl) finEl.value = lastDay;
}
</script>
@endsection