@extends('layouts.master')
 @section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header bg-primary text-white">
                    <h4 class="mb-0">
                        <i class="fas fa-calendar-alt"></i> Consultation des Bons par Période
                    </h4>
                </div>
                
                <div class="card-body">
                    <!-- Formulaire de recherche -->
                    <div class="card mb-4">
                        <div class="card-body">
                            <form method="GET" action="{{ route('consult.bons.periode') }}" class="row g-3">
                                <div class="col-md-3">
                                    <label for="date_debut" class="form-label">Date début</label>
                                    <input type="date" class="form-control" id="date_debut" name="date_debut" 
                                           value="{{ $date_debut ?? '' }}" required>
                                </div>
                                
                                <div class="col-md-3">
                                    <label for="date_fin" class="form-label">Date fin</label>
                                    <input type="date" class="form-control" id="date_fin" name="date_fin" 
                                           value="{{ $date_fin ?? '' }}" required>
                                </div>
                                
                                <div class="col-md-2">
                                    <label for="statut" class="form-label">Statut</label>
                                    <select class="form-select" id="statut" name="statut">
                                        <option value="">Tous les statuts</option>
                                        <option value="0" {{ request('statut') == '0' ? 'selected' : '' }}>Annulé</option>
                                        <option value="1" {{ request('statut') == '1' ? 'selected' : '' }}>Initier</option>
                                        <option value="2" {{ request('statut') == '2' ? 'selected' : '' }}>Autoriser</option>
                                        <option value="3" {{ request('statut') == '3' ? 'selected' : '' }}>Servi</option>
                                        <option value="4" {{ request('statut') == '4' ? 'selected' : '' }}>Payé</option>
                                        <option value="5" {{ request('statut') == '5' ? 'selected' : '' }}>Clôturé</option>
                                    </select>
                                </div>
                                
                                <div class="col-md-2">
                                    <label for="id_filiyale" class="form-label">Filiale</label>
                                    <select class="form-select" id="id_filiyale" name="id_filiyale">
                                        <option value="">Toutes les filiales</option>
                                        @foreach($filiales as $filiale)
                                            <option value="{{ $filiale->id_filiale }}" 
                                                    {{ request('id_filiyale') == $filiale->id_filiale ? 'selected' : '' }}>
                                                {{ $filiale->nom_filiale }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                
                                <div class="col-md-2">
                                    <label for="id_type_carburant" class="form-label">Type carburant</label>
                                    <select class="form-select" id="id_type_carburant" name="id_type_carburant">
                                        <option value="">Tous types</option>
                                        @foreach($type_carburant as $carburant)
                                            <option value="{{ $carburant->id_carburant }}" 
                                                    {{ request('id_type_carburant') == $carburant->id_carburant ? 'selected' : '' }}>
                                                {{ $carburant->type_carburant }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                
                                <div class="col-md-12 mt-3">
                                    <button type="submit" class="btn btn-primary">
                                        <i class="fas fa-search"></i> Rechercher
                                    </button>
                                    <a href="{{ route('consult.bons.periode') }}" class="btn btn-secondary">
                                        <i class="fas fa-redo"></i> Réinitialiser
                                    </a>
                                </div>
                            </form>
                        </div>
                    </div>
                    
                    <!-- Statistiques -->
                    @if(request()->has('date_debut'))
                    <div class="row mb-4">
                        <div class="col-md-12">
                            <div class="alert alert-info">
                                <h5 class="alert-heading">
                                    <i class="fas fa-chart-bar"></i> Statistiques pour la période 
                                    du {{ \Carbon\Carbon::parse($date_debut)->format('d/m/Y') }} 
                                    au {{ \Carbon\Carbon::parse($date_fin)->format('d/m/Y') }}
                                </h5>
                                <div class="row mt-3">
                                    <div class="col-md-2">
                                        <div class="card bg-light">
                                            <div class="card-body text-center">
                                                <h6 class="card-subtitle mb-2 text-muted">Nombre de bons</h6>
                                                <h3 class="card-title text-primary">{{ $stats['total_bons'] }}</h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="card bg-light">
                                            <div class="card-body text-center">
                                                <h6 class="card-subtitle mb-2 text-muted">Quantité totale (L)</h6>
                                                <h3 class="card-title text-success">{{ number_format($stats['total_quantite'], 2) }}</h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="card bg-light">
                                            <div class="card-body text-center">
                                                <h6 class="card-subtitle mb-2 text-muted">Montant total</h6>
                                                <h3 class="card-title text-danger">{{ number_format($stats['total_montant'], 0, ',', ' ') }} BIF</h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card bg-light">
                                            <div class="card-body text-center">
                                                <h6 class="card-subtitle mb-2 text-muted">Montant payé</h6>
                                                <h3 class="card-title text-success">{{ number_format($stats['total_montant_paye'], 0, ',', ' ') }} BIF</h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card bg-light">
                                            <div class="card-body text-center">
                                                <h6 class="card-subtitle mb-2 text-muted">Montant restant</h6>
                                                <h3 class="card-title text-warning">{{ number_format($stats['total_montant_restant'], 0, ',', ' ') }} BIF</h3>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif
                    
                    <!-- Tableau des résultats -->
                    @if(request()->has('date_debut'))
                    <div class="card">
                        <div class="card-header bg-light">
                            <h5 class="mb-0">
                                <i class="fas fa-list"></i> Liste des Bons 
                                ({{ $bons->total() }} résultat(s))
                            </h5>
                        </div>
                        
                        <div class="card-body">
                            @if($bons->count() > 0)
                            <div class="table-responsive">
                                <table class="table table-bordered table-hover">
                                    <thead class="table-dark">
                                        <tr>
                                            <th>N° Bon</th>
                                            <th>Date</th>
                                            <th>Véhicule</th>
                                            <th>Carburant</th>
                                            <th>Quantité (L)</th>
                                            <th>P.U (BIF)</th>
                                            <th>Montant (BIF)</th>
                                            <th>Montant payé</th>
                                            <th>Reste à payer</th>
                                            <th>Statut</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($bons as $bon)
                                        <tr>
                                            <td>
                                                <strong>{{ $bon->numero_bon_a_servir }}</strong>
                                                <br>
                                                <small class="text-muted">Sys: {{ $bon->num_bon_sys }}</small>
                                            </td>
                                            <td>
                                                {{ \Carbon\Carbon::parse($bon->serviele)->format('d/m/Y') }}
                                                <br>
                                                <small class="text-muted">Init: {{ \Carbon\Carbon::parse($bon->initierle)->format('d/m/Y') }}</small>
                                            </td>
                                            <td>
                                                {{ $bon->num_immatriculation }}
                                                <br>
                                                <small class="text-muted">{{ $bon->marque }} {{ $bon->modele }}</small>
                                            </td>
                                            <td>{{ $bon->type_carburant }}</td>
                                            <td class="text-end">
                                                {{ number_format($bon->quantite_servie, 2) }}
                                                @if($bon->quantite_a_servir > 0)
                                                <br>
                                                <small class="text-warning">
                                                    Reliquat: {{ number_format($bon->quantite_a_servir, 2) }}
                                                </small>
                                                @endif
                                            </td>
                                            <td class="text-end">{{ number_format($bon->pu, 0, ',', ' ') }}</td>
                                            <td class="text-end">{{ number_format($bon->montant_a_payer, 0, ',', ' ') }}</td>
                                            <td class="text-end text-success">{{ number_format($bon->montant_payer, 0, ',', ' ') }}</td>
                                            <td class="text-end text-danger">{{ number_format($bon->montant_restant_a_payer, 0, ',', ' ') }}</td>
                                            <td>
                                                @php
                                                    $statuts = [
                                                        0 => ['label' => 'Annulé', 'class' => 'danger'],
                                                        1 => ['label' => 'Initier', 'class' => 'secondary'],
                                                        2 => ['label' => 'Autoriser', 'class' => 'warning'],
                                                        3 => ['label' => 'Servi', 'class' => 'info'],
                                                        4 => ['label' => 'Payé', 'class' => 'success'],
                                                        5 => ['label' => 'Clôturé', 'class' => 'dark']
                                                    ];
                                                    $statut = $statuts[$bon->status_bon_a_servir] ?? $statuts[1];
                                                @endphp
                                                <span class="badge bg-{{ $statut['class'] }}">
                                                    {{ $statut['label'] }}
                                                </span>
                                            </td>
                                           <td>
                                            <a href="{{ url('/view_detail_bon_a_servir/' . $bon->id_bonaservir) }}" 
                                               class="btn btn-sm btn-info" title="Voir détails">
                                                <i class="fas fa-eye"></i>
                                            </a>
                                            @if($r >= 2)
                                            <a href="{{ url('/view_detail_bon_a_servir/' . $bon->id_bonaservir) }}" 
                                               class="btn btn-sm btn-warning" title="Imprimer">
                                                <i class="fas fa-print"></i>
                                            </a>
                                            @endif
                                        </td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot class="table-secondary">
                                        <tr>
                                            <th colspan="4" class="text-end">TOTAUX:</th>
                                            <th class="text-end">{{ number_format($stats['total_quantite'], 2) }}</th>
                                            <th></th>
                                            <th class="text-end">{{ number_format($stats['total_montant'], 0, ',', ' ') }}</th>
                                            <th class="text-end">{{ number_format($stats['total_montant_paye'], 0, ',', ' ') }}</th>
                                            <th class="text-end">{{ number_format($stats['total_montant_restant'], 0, ',', ' ') }}</th>
                                            <th colspan="2"></th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                            
                            <!-- Pagination -->
                            <div class="d-flex justify-content-center mt-3">
                                {{ $bons->links() }}
                            </div>
                            
                            <!-- Bouton d'export -->
                            <div class="mt-3">
                                <a href="#" class="btn btn-success" onclick="exportToExcel()">
                                    <i class="fas fa-file-excel"></i> Exporter en Excel
                                </a>
                                <a href="{{ route('export.bons.periode.pdf') . '?' . http_build_query(request()->query()) }}" 
                                   class="btn btn-danger" target="_blank">
                                    <i class="fas fa-file-pdf"></i> Exporter en PDF
                                </a>
                                <a href="#" class="btn btn-danger" onclick="printReport()">
                                    <i class="fas fa-print"></i> Imprimer Rapport
                                </a>
                            </div>
                            
                            @else
                            <div class="alert alert-warning">
                                <i class="fas fa-exclamation-triangle"></i> 
                                Aucun bon trouvé pour les critères de recherche sélectionnés.
                            </div>
                            @endif
                        </div>
                    </div>
                    @else
                    <div class="alert alert-light text-center">
                        <i class="fas fa-calendar-alt fa-3x text-muted mb-3"></i>
                        <h4>Veuillez sélectionner une période pour consulter les bons</h4>
                        <p class="text-muted">Utilisez le formulaire ci-dessus pour spécifier la période de consultation.</p>
                    </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Scripts pour l'export et l'impression -->
<script>
    function exportToExcel() {
        // Récupérer les paramètres de recherche
        const params = new URLSearchParams(window.location.search);
        
        // Créer l'URL d'export
        let exportUrl = "{{ route('export.bons.periode') }}?" + params.toString();
        
        // Ouvrir dans une nouvelle fenêtre pour déclencher le téléchargement
        window.open(exportUrl, '_blank');
    }
    
    function printReport() {
        window.print();
    }
    
    // Initialiser la date de fin à aujourd'hui
    document.addEventListener('DOMContentLoaded', function() {
        const dateFin = document.getElementById('date_fin');
        if (!dateFin.value) {
            const today = new Date().toISOString().split('T')[0];
            dateFin.value = today;
        }
        
        // Initialiser la date de début à il y a 30 jours
        const dateDebut = document.getElementById('date_debut');
        if (!dateDebut.value) {
            const thirtyDaysAgo = new Date();
            thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);
            dateDebut.value = thirtyDaysAgo.toISOString().split('T')[0];
        }
    });
</script>

<style>
    @media print {
        .card-header, .btn, .form-control, .form-select, .alert {
            display: none !important;
        }
        
        .table th {
            background-color: #f8f9fa !important;
            color: #000 !important;
        }
        
        .table td, .table th {
            border: 1px solid #dee2e6 !important;
        }
        
        .no-print {
            display: none !important;
        }
        
        .print-only {
            display: block !important;
        }
        
        body {
            font-size: 12px;
        }
    }
    
    .table td {
        vertical-align: middle;
    }
    
    .badge {
        font-size: 0.85em;
        padding: 0.4em 0.7em;
    }
</style>
@endsection