@extends('layouts.master_pdf')

@section('content')
    <div class="container">
        <div class="header">
            <h2>{{ $title }}</h2>
            <p>Généré le : {{ date('d-m-Y H:i') }}</p>
        </div>
        
        <!-- ========== SYNTHESE DE MOUVEMENT DE STOCK ========== -->
        <div class="annexe-synthese">
            <h4>SYNTHESE DE MOUVEMENT DE STOCK DE CARBURANT DU {{ $formattedDate1 }} AU {{ $formattedDate2 }}</h4>
            <table class="table table-bordered table-synthese">
                <thead>
                    <tr>
                        <th rowspan="2">Type de carburant</th>
                        <th colspan="2">Stock Initial</th>
                        <th colspan="2">Entrees</th>
                        <th colspan="2">Sorties</th>
                        <th colspan="3">Solde/Stock</th>
                    </tr>
                    <tr>
                        <th>Qté</th>
                        <th>Valeur (BIF)</th>
                        <th>Qté (L)</th>
                        <th>Valeur (BIF)</th>
                        <th>Qté (L)</th>
                        <th>Valeur (BIF)</th>
                        <th>Qté (L)</th>
                        <th>PU</th>
                        <th>valeur (BIF)</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td><strong>Essence</strong></td>
                        <td class="text-right">{{ number_format($stockInitialData['essence']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($stockInitialData['essence']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($entreesParCarburant['essence']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($entreesParCarburant['essence']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($sortiesParCarburant['essence']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($sortiesParCarburant['essence']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($stockFinalData['essence']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($stockFinalData['essence']['pu'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($stockFinalData['essence']['valeur'], 0, ',', ' ') }}</td>
                    </tr>
                    <tr>
                        <td><strong>Gasoil</strong></td>
                        <td class="text-right">{{ number_format($stockInitialData['gasoil']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($stockInitialData['gasoil']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($entreesParCarburant['gasoil']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($entreesParCarburant['gasoil']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($sortiesParCarburant['gasoil']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($sortiesParCarburant['gasoil']['valeur'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($stockFinalData['gasoil']['qte'], 2) }} L</td>
                        <td class="text-right">{{ number_format($stockFinalData['gasoil']['pu'], 0, ',', ' ') }}</td>
                        <td class="text-right">{{ number_format($stockFinalData['gasoil']['valeur'], 0, ',', ' ') }}</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td><strong>Total général</strong></td>
                        <td class="text-right"><strong>{{ number_format($stockInitialData['essence']['qte'] + $stockInitialData['gasoil']['qte'], 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($stockInitialData['essence']['valeur'] + $stockInitialData['gasoil']['valeur'], 0, ',', ' ') }}</strong></td>
                        <td class="text-right"><strong>{{ number_format($entreesParCarburant['essence']['qte'] + $entreesParCarburant['gasoil']['qte'], 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($entreesParCarburant['essence']['valeur'] + $entreesParCarburant['gasoil']['valeur'], 0, ',', ' ') }}</strong></td>
                        <td class="text-right"><strong>{{ number_format($sortiesParCarburant['essence']['qte'] + $sortiesParCarburant['gasoil']['qte'], 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($sortiesParCarburant['essence']['valeur'] + $sortiesParCarburant['gasoil']['valeur'], 0, ',', ' ') }}</strong></td>
                        <td class="text-right"><strong>{{ number_format($stockFinalData['essence']['qte'] + $stockFinalData['gasoil']['qte'], 2) }} L</strong></td>
                        <td class="text-right"><strong>-</strong></td>
                        <td class="text-right"><strong>{{ number_format($stockFinalData['essence']['valeur'] + $stockFinalData['gasoil']['valeur'], 0, ',', ' ') }}</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <!-- ========== RÉCAPITULATIF DES ENTRÉES PAR DATE ========== -->
        <div class="recap-entrees">
            <h4>Récapitulatif des entrées par date et par carburant</h4>
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Type de carburant</th>
                        <th>Quantité (L)</th>
                        <th>Valeur (BIF)</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($entreesParDate as $date => $carburants)
                        @php
                            $first = true;
                            $totalDateQte = 0;
                            $totalDateValeur = 0;
                        @endphp
                        @foreach($carburants as $carburant => $data)
                            @php
                                $totalDateQte += $data['qte'];
                                $totalDateValeur += $data['valeur'];
                            @endphp
                            <tr>
                                @if($first)
                                    <td rowspan="{{ count($carburants) }}"><strong>{{ $date }}</strong></td>
                                    @php $first = false; @endphp
                                @endif
                                <td>{{ $carburant }}</td>
                                <td class="text-right">{{ number_format($data['qte'], 2) }} L</td>
                                <td class="text-right">{{ number_format($data['valeur'], 0, ',', ' ') }}</td>
                            </tr>
                        @endforeach
                        <tr class="date-total">
                            <td colspan="2" class="text-right"><strong>Total {{ $date }}</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalDateQte, 2) }} L</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalDateValeur, 0, ',', ' ') }}</strong></td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="4" class="text-center">Aucune entrée enregistrée pour cette période</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td colspan="2" class="text-right"><strong>TOTAL GÉNÉRAL DES ENTRÉES</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_entrees, 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_valeur_entrees, 0, ',', ' ') }}</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <!-- ========== RÉCAPITULATIF DES SORTIES PAR DATE ========== -->
        <div class="recap-sorties">
            <h4>Récapitulatif des sorties par date et par carburant</h4>
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Type de carburant</th>
                        <th>Quantité (L)</th>
                        <th>Valeur (BIF)</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($sortiesParDate as $date => $carburants)
                        @php
                            $first = true;
                            $totalDateQte = 0;
                            $totalDateValeur = 0;
                        @endphp
                        @foreach($carburants as $carburant => $data)
                            @php
                                $totalDateQte += $data['qte'];
                                $totalDateValeur += $data['valeur'];
                            @endphp
                            <tr>
                                @if($first)
                                    <td rowspan="{{ count($carburants) }}"><strong>{{ $date }}</strong></td>
                                    @php $first = false; @endphp
                                @endif
                                <td>{{ $carburant }}</td>
                                <td class="text-right">{{ number_format($data['qte'], 2) }} L</td>
                                <td class="text-right">{{ number_format($data['valeur'], 0, ',', ' ') }}</td>
                            </tr>
                        @endforeach
                        <tr class="date-total">
                            <td colspan="2" class="text-right"><strong>Total {{ $date }}</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalDateQte, 2) }} L</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalDateValeur, 0, ',', ' ') }}</strong></td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="4" class="text-center">Aucune sortie enregistrée pour cette période</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td colspan="2" class="text-right"><strong>TOTAL GÉNÉRAL DES SORTIES</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_sorties, 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_valeur_sorties, 0, ',', ' ') }}</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <!-- ========== SECTION: SORTIES PAR FILIALE ET CARBURANT ========== -->
        <div class="sorties-filiale">
            <h4>Récapitulatif des sorties par Filiale et par Carburant</h4>
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Filiale</th>
                        <th>Type de carburant</th>
                        <th>Quantité totale (L)</th>
                        <th>Valeur totale (BIF)</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($sortiesParFiliale as $filiale => $carburants)
                        @php
                            $first = true;
                            $totalFilialeQte = 0;
                            $totalFilialeValeur = 0;
                        @endphp
                        @foreach($carburants as $carburant => $data)
                            @php
                                $totalFilialeQte += $data['qte'];
                                $totalFilialeValeur += $data['valeur'];
                            @endphp
                            <tr>
                                @if($first)
                                    <td rowspan="{{ count($carburants) }}"><strong>{{ $filiale }}</strong></td>
                                    @php $first = false; @endphp
                                @endif
                                <td>{{ $carburant }}</td>
                                <td class="text-right">{{ number_format($data['qte'], 2) }} L</td>
                                <td class="text-right">{{ number_format($data['valeur'], 0, ',', ' ') }}</td>
                            </tr>
                        @endforeach
                        <tr class="filiale-total">
                            <td colspan="2" class="text-right"><strong>Total {{ $filiale }}</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalFilialeQte, 2) }} L</strong></td>
                            <td class="text-right"><strong>{{ number_format($totalFilialeValeur, 0, ',', ' ') }}</strong></td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="4" class="text-center">Aucune sortie enregistrée pour cette période</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td colspan="2" class="text-right"><strong>TOTAL GÉNÉRAL DES SORTIES</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_sorties, 2) }} L</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_valeur_sorties, 0, ',', ' ') }}</strong></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <!-- ========== SECTION: DÉTAIL DES MOUVEMENTS D'ENTRÉE ========== -->
        <div class="details-entrees">
            <h4>Détail des mouvements d'entrée</h4>
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Carburant</th>
                        <th>Quantité (L)</th>
                        <th>Prix unitaire</th>
                        <th>Valeur (BIF)</th>
                        <th>Référence</th>
                        <th>Type d'entrée</th>
                        <th>Motif</th>
                        <th>Utilisateur</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($entreesNettes as $entree)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($entree->date_mvt)->format('d-m-Y') }}</td>
                            <td>{{ $entree->type_carburant }}</td>
                            <td class="text-right">{{ number_format($entree->qte_mvt, 2) }} L</td>
                            <td class="text-right">{{ number_format($entree->prix_mvt, 0, ',', ' ') }}</td>
                            <td class="text-right">{{ number_format($entree->qte_mvt * $entree->prix_mvt, 0, ',', ' ') }}</td>
                            <td>{{ $entree->reference_mvt ?? '-' }}</td>
                            <td>{{ $entree->type_mvt_entree ?? ($entree->id_approvisionner ? 'Approvisionnement' : 'Autre') }}</td>
                            <td>{{ $entree->motif_mvt ?? '-' }}</td>
                            <td>{{ $entree->user_name ?? $entree->user_mvt ?? '-' }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center">Aucune entrée enregistrée pour cette période</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td colspan="2" class="text-right"><strong>TOTAL GÉNÉRAL</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_entrees, 2) }} L</strong></td>
                        <td colspan="2" class="text-right"><strong>{{ number_format($total_valeur_entrees, 0, ',', ' ') }}</strong></td>
                        <td colspan="4"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <!-- ========== SECTION: DÉTAIL DES MOUVEMENTS DE SORTIE ========== -->
        <div class="details-sorties">
            <h4>Détail des mouvements de sortie par Filiale</h4>
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th>Filiale</th>
                        <th>Date</th>
                        <th>Carburant</th>
                        <th>Quantité (L)</th>
                        <th>Prix unitaire</th>
                        <th>Valeur (BIF)</th>
                        <th>N° Bon à servir</th>
                        <th>Véhicule</th>
                        <th>Responsable</th>
                        <th>Motif</th>
                        <th>Utilisateur</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($sortiesNettes as $sortie)
                        <tr>
                            <td>{{ $sortie->nom_filiale ?? 'Sans filiale' }}</td>
                            <td>{{ \Carbon\Carbon::parse($sortie->date_mvt)->format('d-m-Y') }}</td>
                            <td>{{ $sortie->type_carburant }}</td>
                            <td class="text-right">{{ number_format($sortie->qte_mvt, 2) }} L</td>
                            <td class="text-right">{{ number_format($sortie->prix_mvt, 0, ',', ' ') }}</td>
                            <td class="text-right">{{ number_format($sortie->qte_mvt * $sortie->prix_mvt, 0, ',', ' ') }}</td>
                            <td>{{ $sortie->numero_bon_a_servir ?? '-' }}</td>
                            <td>{{ $sortie->num_immatriculation ?? '-' }}</td>
                            <td>{{ $sortie->responsable_commande ?? '-' }}</td>
                            <td>{{ $sortie->description ?? $sortie->motif_mvt ?? '-' }}</td>
                            <td>{{ $sortie->user_name ?? $sortie->user_mvt ?? '-' }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="11" class="text-center">Aucune sortie enregistrée pour cette période</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot>
                    <tr class="table-active">
                        <td colspan="3" class="text-right"><strong>TOTAL GÉNÉRAL</strong></td>
                        <td class="text-right"><strong>{{ number_format($total_sorties, 2) }} L</strong></td>
                        <td colspan="2" class="text-right"><strong>{{ number_format($total_valeur_sorties, 0, ',', ' ') }}</strong></td>
                        <td colspan="5"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <div class="footer">
            <p>Page 1/1</p>
        </div>
    </div>
@endsection

<style>
    .container { width: 100%; font-family: Arial, sans-serif; }
    .header { text-align: center; margin-bottom: 20px; }
    .header h2 { color: #2c3e50; }
    .recap-entrees, .recap-sorties, .sorties-filiale, .details-entrees, .details-sorties, .annexe-synthese { margin-bottom: 30px; }
    
    .table { width: 100%; border-collapse: collapse; margin-bottom: 10px; font-size: 8px; }
    .table th, .table td { border: 1px solid #ddd; padding: 4px; }
    .table th { background-color: #f2f2f2; text-align: center; }
    .table td { vertical-align: top; }
    
    .footer { margin-top: 30px; text-align: center; font-size: 12px; }
    
    .table-synthese th, 
    .table-synthese td { 
        text-align: center; 
        vertical-align: middle;
    }
    .table-synthese tfoot td { 
        background-color: #f9f9f9; 
        border-top: 2px solid #ddd; 
    }
    .text-right { text-align: right !important; }
    .text-center { text-align: center !important; }
    
    .annexe-synthese h4, .recap-entrees h4, .recap-sorties h4, .sorties-filiale h4, .details-entrees h4, .details-sorties h4 {
        color: #2c3e50;
        border-bottom: 1px solid #ddd;
        padding-bottom: 5px;
        margin-bottom: 15px;
        font-size: 12px;
    }
    
    .table-synthese tbody tr:nth-child(even),
    .recap-entrees tbody tr:nth-child(even),
    .recap-sorties tbody tr:nth-child(even),
    .sorties-filiale tbody tr:nth-child(even),
    .details-entrees tbody tr:nth-child(even),
    .details-sorties tbody tr:nth-child(even) {
        background-color: #f9f9f9;
    }
    
    .filiale-total, .date-total {
        background-color: #e8f4f8;
        font-weight: bold;
    }
    
    .table-active {
        background-color: #d9edf7;
    }
</style>