@extends('layouts.master')

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

@section('content')
<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center">
        <h2>Situation des Factures Payées par Opérateur</h2>
        
        <form method="GET" action="{{ route('rapports.factures-payees') }}" class="form-inline">
            <div class="form-group mr-2">
                <label for="exercice_id" class="mr-2">Exercice:</label>
                <select name="exercice_id" id="exercice_id" class="form-control form-control-sm" onchange="this.form.submit()">
                    @if($exercices)
                        @foreach($exercices as $ex)
                            @if($ex !== null)
                                <option value="{{ $ex->id }}" {{ $ex->id == ($exercice->id ?? null) ? 'selected' : '' }}>
                                    {{ $ex->annee }}
                                </option>
                            @endif
                        @endforeach
                    @endif
                </select>
            </div>
            <button type="button" class="btn btn-sm btn-success" onclick="exportToExcel()">
                <i class="fas fa-file-excel"></i> Excel
            </button>
        </form>

    </div>
    
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="situation-table">
                <thead class="thead-dark">
                    <tr>
                        <th>Opérateur</th>
                        @foreach($mois as $nomMois)
                            <th class="text-center">{{ $nomMois }}</th>
                        @endforeach
                        <th class="text-center bg-primary text-white">Total</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($situation as $data)
                    <tr>
                        <td class="font-weight-bold">{{ $data['operateur']->denomination }}</td>
                        @foreach($data['factures_par_mois'] as $montant)
                            <td class="text-right {{ $montant > 0 ? 'text-success' : 'text-muted' }}">
                                {{ number_format($montant, 2, ',', ' ') }} FCFA
                            </td>
                        @endforeach
                        <td class="text-right font-weight-bold bg-light">
                            {{ number_format($data['total'], 2, ',', ' ') }} FCFA
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="font-weight-bold">
                    <tr>
                        <td class="bg-dark text-white">TOTAUX</td>
                        @foreach($totauxMois as $totalMois)
                            <td class="text-right bg-dark text-white">
                                {{ number_format($totalMois, 2, ',', ' ') }} FCFA
                            </td>
                        @endforeach
                        <td class="text-right bg-primary text-white">
                            {{ number_format($totalGeneral, 2, ',', ' ') }} FCFA
                        </td>
                    </tr>
                </tfoot>
            </table>
        </div>
        
        <div class="mt-4">
            <div class="alert alert-blue">
                <strong>Note:</strong> Ce rapport montre uniquement les factures "payees" pour l'exercice @if($exercice->annee !== null) {{ $exercice->annee }} @endif.
            </div>
        </div>
    </div>
</div>
@endsection

@push('styles')
<style>
    .table th {
        position: sticky;
        top: 0;
        background-color: #f8f9fa;
        z-index: 10;
    }
    .table td, .table th {
        vertical-align: middle;
        white-space: nowrap;
    }
</style>
@endpush

@push('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>
<script>
    function exportToExcel() {
        // Sélectionner le tableau
        const table = document.getElementById('situation-table');
        
        // Préparer les données pour l'export
        const data = [];
        const rows = table.querySelectorAll('tr');
        
        rows.forEach(row => {
            const rowData = [];
            const cells = row.querySelectorAll('th, td');
            
            cells.forEach(cell => {
                // Nettoyer le texte (supprimer " FCFA" et formater les nombres)
                let text = cell.textContent.trim();
                
                if (text.includes('FCFA')) {
                    text = text.replace(' FCFA', '');
                }
                
                // Convertir les nombres avec espaces de milliers
                if (text.includes(' ')) {
                    text = text.replace(/ /g, '');
                }
                
                // Remplacer la virgule décimale par un point
                if (text.includes(',')) {
                    text = text.replace(',', '.');
                }
                
                rowData.push(text);
            });
            
            data.push(rowData);
        });
        
        // Créer un classeur et une feuille
        const ws = XLSX.utils.aoa_to_sheet(data);
        const wb = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(wb, ws, 'Situation Factures');
        
        // Générer le fichier Excel
        const fileName = `situation-factures-{{ $exercice->annee }}-${new Date().toISOString().split('T')[0]}.xlsx`;
        XLSX.writeFile(wb, fileName);
    }
    
    // Optionnel: rendre le tableau fixe pour le défilement
    $(document).ready(function() {
        const table = $('#situation-table');
        table.wrap('<div style="overflow-x: auto; max-height: 70vh;"></div>');
    });
</script>
@endpush