@extends('layouts.app')
@section('title', 'Balance clients')
@section('breadcrumb', 'États / Balance clients')
@section('content')
<div class="page-header">
    <div><h1 class="page-title"><i class="fas fa-scale-balanced" style="color:var(--info)"></i> Balance clients</h1></div>
    <a href="{{ route('etats.index') }}" class="btn btn-secondary">Retour</a>
</div>

<div class="card"><div class="table-wrap"><table class="table">
    <thead><tr><th>Client</th><th>Code</th><th>Factures TTC</th><th>Avoirs TTC</th><th>Solde</th></tr></thead>
    <tbody>
    @php $totFact=0; $totAvoir=0; @endphp
    @forelse($clients as $c)
    @php
        $factures = $c->venteDocuments->where('type','facture_vente')->sum('total_ttc');
        $avoirs   = $c->venteDocuments->where('type','avoir_vente')->sum('total_ttc');
        $solde    = $factures - $avoirs;
        $totFact += $factures; $totAvoir += $avoirs;
    @endphp
    <tr>
        <td style="font-weight:500;"><a href="{{ route('clients.show', $c) }}" style="color:var(--primary);">{{ $c->nom }}</a></td>
        <td><code>{{ $c->code }}</code></td>
        <td>{{ number_format($factures,3,',',' ') }}</td>
        <td style="color:#10b981;">{{ number_format($avoirs,3,',',' ') }}</td>
        <td style="font-weight:700;color:{{ $solde>0?'#ef4444':($solde<0?'#f59e0b':'#10b981') }};">
            {{ number_format($solde,3,',',' ') }}
        </td>
    </tr>
    @empty
        <tr><td colspan="5" class="empty-state">Aucun client</td></tr>
    @endforelse
    </tbody>
    @if(count($clients))
    <tfoot><tr style="font-weight:700;background:#f8fafc;">
        <td colspan="2">TOTAL</td>
        <td>{{ number_format($totFact,3,',',' ') }}</td>
        <td style="color:#10b981;">{{ number_format($totAvoir,3,',',' ') }}</td>
        <td style="color:{{ ($totFact-$totAvoir)>0?'#ef4444':'#10b981' }};">{{ number_format($totFact-$totAvoir,3,',',' ') }}</td>
    </tr></tfoot>
    @endif
</table></div></div>
@endsection