@extends('layouts.master')

@section('title', 'Situation des Factures Payees par Opérateur')

@section('content')
<div class="container-fluid">
    <h2>Situation des factures payées {{ $annee }}</h2>

    <div class="table-responsive">
        <table class="table table-bordered table-striped table-sm">
            <thead class="thead-light">
                <tr>
                    <th>Opérateurs</th>
                    <th>Secteur/Zones</th>
                    <th>Prestations</th>
                    @foreach(['Janvier','Février','Mars','Avril','Mai','Juin','Juillet','Août','Septembre','Octobre','Novembre','Décembre'] as $mois)
                        <th class="text-right">{{ $mois }} {{ $annee }}</th>
                    @endforeach
                    <th class="text-right">TOTAL PAYEES {{ $annee }}</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $previousOperateurId = null;
                @endphp
                @forelse($factures as $facture)
                    <tr>
                        @if($previousOperateurId !== $facture->operateur_id)
                            <td rowspan="{{ $factures->where('operateur_id', $facture->operateur_id)->count() }}">
                                {{ $facture->operateur_nom }}
                            </td>
                            @php $previousOperateurId = $facture->operateur_id; @endphp
                        @endif
                        <td>{{ $facture->secteur }}</td>
                        <td>{{ $facture->prestation }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->janvier, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->fevrier, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->mars, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->avril, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->mai, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->juin, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->juillet, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->aout, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->septembre, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->octobre, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->novembre, 0, ',', ' ') }}</td>
                        <td class="text-right" style="font-size: 9px;">{{ number_format($facture->decembre, 0, ',', ' ') }}</td>
                        <td class="text-right font-weight-bold" style="font-size: 9px;">{{ number_format($facture->total, 0, ',', ' ') }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="16" class="text-center">Aucune facture payée en {{ $annee }}</td>
                    </tr>
                @endforelse
            </tbody>
            <tfoot class="font-weight-bold bg-light">
                <tr>
                    <th></th>
                    <th class="text-center" colspan="2">TOTAL</th>
                    @foreach(['janvier','fevrier','mars','avril','mai','juin','juillet','aout','septembre','octobre','novembre','decembre'] as $mois)
                        <th class="text-right" style="font-size: 9px;">{{ number_format($totauxMensuels[$mois] ?? 0, 0, ',', ' ') }}</th>
                    @endforeach
                    <th class="text-right" style="font-size: 9px;">{{ number_format($totalGeneral, 0, ',', ' ') }}</th>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endsection