@extends('adminlte::page')

@section('title', " $title ")

@section('content')
<div class="container-fluid">
    
    <div class="row pt-4 callout callout-warning">
        <div class="col-md-12">
            <h5 class='center'><i class="fas fa-info"></i> FILTRO - RELATÓRIO FATURAMENTO</h5>
        </div>
    </div> 

    <style>
        @media print {
            .search-section {
                display: none;
            }
            .btn-print {
                display: none;
            }
        }
    </style>
    
    <div class='row pt-4 search-section'>
        
        <h5><i class="fa fa-search"></i> Filtro por período...</h5>
        
        @include('app.includes.alerts')
        
        <div class="col-md-12 p-4 text-black rounded" style="background: #e0e0e0;">
            <form action="{{ route('financial.invoicing') }}" method="get">
                @csrf

                <div class="row mt-2">

                    <div class="col-md-2">
                        <label><i class="fas fa-calendar"></i> Data Inicial</label>
                        <input type='text' name='initial_date' class='form-control datepicker' value='' placeholder="Digite a data Inicial...">
                    </div>
                    
                    <div class="col-md-2">
                        <label><i class="fas fa-calendar"></i> Data Final</label>
                        <input type='text' name='final_date' class='form-control datepicker' value='' placeholder="Digite a data Final...">
                    </div>
                    
                </div>
               
                <div class="modal-footer">
                   <button type="submit" class="btn btn-success submit loading" title="Pesquisar"> <i class="fa fa-search"></i>
                       Pesquisar
                   </button>
               </div>
                    
            </form> 
        </div>
        
    </div>
    
    
    @if($hasFilters && $customers->isNotEmpty())
        <div class="row mt-3 callout callout-info">
            @if(isset($selectedInitialDate) && isset($selectedFinalDate))
                <div class="col-md-6">
                    <strong>Você selecionou o período:</strong> {{ $selectedInitialDate }} à {{ $selectedFinalDate }}
                </div>
            @endif
        </div>
    
        <div class="row mt-3 callout callout-success">
            <div class="col-md-12">
                <p><strong>RELATÓRIO GERAL NO PERÍODO</strong></p>
            </div>
        </div>
    
        <div class="table-responsive mt-3">
            <table class="table table-striped">
                <thead class="bg-secondary text-white">
                    <tr>
                        <th>CATEGORIA</th>
                        <th>QUANTIDADE</th>
                        <th>FATURAMENTO</th>
                        <th>MÉDIA</th>
                    </tr>
                </thead>

                <tbody>
                    @php
                        $qtdTotal = 0;
                        $valueInvoicing = 0;
                        $mediaTotal = 0;
                        $categoriesDisplayed = [];
                    @endphp

                    @foreach($customers as $customer)
                        <tr>
                            <td>{{ $customer->Categoria }}</td>
                            <td>{{ $customer->Quantidade }}</td>
                            <td>R$ {{ number_format($customer->Faturamento, 2, ',', '.') }}</td>
                            <td>R$ {{ number_format($customer->Media, 2, ',', '.') }}</td>
                        </tr>
                        @php
                            $qtdTotal += $customer->Quantidade;
                            $valueInvoicing += $customer->Faturamento;
                            $mediaTotal = $valueInvoicing / $qtdTotal;
                            $categoriesDisplayed[] = $customer->Categoria;
                        @endphp
                    @endforeach
                    <tr>
                        <td><strong>Total Geral das categorias</strong></td>
                        <td><strong>{{ number_format($qtdTotal, 3, '.', '.') }}</strong></td>
                        <td><strong>R$ {{ number_format($valueInvoicing, 2, ',', '.') }}</strong></td>
                        <!-- Correção: Usar a média total, não a média geral -->
                        <td><strong>R$ {{ number_format($mediaTotal, 2, ',', '.') }}</strong></td>
                    </tr>
                </tbody>

            </table>

        </div>
    
        @elseif($hasFilters)
            <div class="row mt-3">
                <div class="col-md-12 alert alert-danger text-center">
                    <p><i class="fa fa-exclamation"></i> Nenhum faturamento encontrado com o período aplicado.</p>
                </div>
            </div>
        @endif

         <!-- Print button added -->
         <div class="modal-footer">
            <button type="button" class="btn btn-default btn-print" title="Imprimir relatório" onclick="printPage()"><i class="fas fa-print"></i> Imprimir</button>
        </div>
    </div>

    <script>
        function printPage() {
            window.print();
        }
    </script>
@stop