@extends('adminlte::page')

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

@section('content')
<div class="container-fluid">
    
    <div class="row pt-4">
        <div class="col-md-12">
            <div class="callout callout-warning">
                <h5 class='center'><i class="fas fa-info"></i> FILTRO - RELATÓRIO FINANCEIRO</h5>
            </div>
        </div>
    </div> 
    
    <div class='row pt-4'>
        
        <h5>FILTRO - financeiro</h5>
        
        @include('app.includes.alerts')
        
        <div class="col-md-12 p-4 text-black rounded" style="background: #e0e0e0;">
            <form action="{{ route('financial.report') }}" method="get">
                @csrf

                <div class="row mt-2">
                    
                    <div class="col-md-5">
                        <label><i class="fas fa-briefcase"></i> Categoria</label>
                        <select name="category_id" class="form-control">
                            <option value="">-- Selecione a categoria para o relatório --</option>
                            <option value="">-- Filtrar Todos --</option>
                            @foreach($categories as $category)
                                <option value="{{ $category->id }}" {{ (request('category_id') == $category->id || old('category_id') == $category->id) ? 'selected' : '' }}>{{ $category->category }}</option>
                            @endforeach
                        </select>
                        @error('category_id')
                            <div class="text-danger">{{ $message }}</div>
                        @enderror
                    </div>
                    
                    <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" title="Pesquisar"> <i class="fa fa-search"></i>
                       Pesquisar
                   </button>
               </div>
                    
            </form> 
        </div>
        
    </div>
    
    <div class="row mt-3">
        <div class="col-md-12 card">
            <p class="pt-2"><strong>1 - Categoria:</strong> <code>Ao selecionar somente a categoria, verá toda a distribuição dessa categoria</code><br> 
            <strong>2 - Categoria:</strong> <code>Ao selecionar categoria e periodo, verá toda a distribuição relativa ao periodo</code><br> 
            <strong>3 - Periodo:</strong> <code>Ao selecionar em categoria - Filtrar Todos - e selecionar o periodo, verá toda a distribuição independente de categoria, é necessario nesse caso, selecionar data inicial e final</code></p> 
        </div>
    </div>
    
    @if($hasFilters && $customers->isNotEmpty())
        <div class="row mt-5 callout callout-success">
            @if(isset($selectedCategory))
                <div class="col-md-6">
                    <strong>Categoria Selecionada:</strong> {{ $selectedCategory->category }}
                </div>
            @endif

            @if(isset($selectedInitialDate) && isset($selectedFinalDate))
                <div class="col-md-6">
                    <strong>Período Selecionado:</strong> {{ $selectedInitialDate }} à {{ $selectedFinalDate }}
                </div>
            @endif
        </div>
    
        <div class="table-responsive mt-3">
            <table class="table table-striped">
                <thead class="bg-secondary text-white">
                    <tr>
                        <th>O.S</th>
                        <th>Razão social</th>
                        <th>Fantasia</th>
                        <th>N/F</th>
                        <th>Boleto</th>
                        <th>Data</th>
                        <th>Material</th>
                        <th>Promoção</th>
                        <th>Qtd</th>
                        <th>Milheiro</th>
                        <th>Média</th>
                        <th>Total</th>
                    </tr>
                </thead>

                <tbody>
                    @php
                        $qtdTotal = 0;
                        $valueTotal = 0;
                    @endphp
                    
                    @foreach($customers as $customer)
                        @foreach($customer->autorizations as $autorization)
                            @if($autorization->payment_made === 'Sim')
                                <tr>
                                    <td>{{ $autorization->autorization }}</td>
                                    <td>{{ $customer->corporate_name }}</td>
                                    <td>{{ $customer->fantasy_name }}</td>
                                    <td>{{ $autorization->number_nf }}</td>
                                    <td>{{ $autorization->ticket }}</td>                              
                                    <td>{{ date('d/m/Y', strtotime($autorization->payment_date)) }}</td>
                                    <!-- Obtendo o nome do material usando material_customer_id -->
                                    @if($autorization->perspective->material_customer_id)
                                        @php
                                            $materialCustomer = \App\Models\MaterialCustomer::find($autorization->perspective->material_customer_id);
                                        @endphp
                                        <td>{{ $materialCustomer->material }}</td>
                                        <td>{{ $autorization->promotion->name }}</td>
                                        <td>{{ $autorization->perspective->qtd }}</td>
                                        <td>{{ number_format($materialCustomer->value_granted,2,',','.') }}</td>
                                        <td>{{ number_format($materialCustomer->thousand,2,',','.') }}</td>
                                        <td>
                                            @php
                                            $priceByMilheiro = $materialCustomer->value_granted;

                                            // Quantidade de milheiros
                                            $qtdPerspective = str_replace('.', '', $autorization->perspective->qtd);

                                            // Calcula o preço por unidade
                                            $priceForUnity = $priceByMilheiro / 1000;

                                            // Calcula o valor final
                                            $finalValue = $priceForUnity * $qtdPerspective;

                                            // Incrementa a quantidade total
                                            $qtdTotal += $qtdPerspective;

                                            //Valor total
                                            $valueTotal += $finalValue;

                                            @endphp
                                            <span class="badge badge-success" style="font-size:16px;">R$ {{ number_format($finalValue, 2, ',', '.') }}</span>
                                        </td>
                                    @endif
                                </tr>
                            @endif
                         @endforeach
                    @endforeach

                    <tr>
                        <td colspan="7"></td>
                        <td class="text-right"><strong>Total Distribuido</strong></td>
                        <td>{{ number_format($qtdTotal, 2, '.', '.') }}</td>
                        <td></td>
                        <td class="text-right"><strong>Totalizando</strong></td>
                        <td><span class="badge badge-success" style="font-size:16px;">R$ {{ number_format($valueTotal, 2, ',', '.') }}</span></td>
                    </tr>
                    
                </tbody>
            </table>
        </div>
    </div>
    
    @elseif($hasFilters)
        <div class="row mt-5">
            <p>Nenhum cliente encontrado com os filtros aplicados.</p>
        </div>
    @endif
    
</div>
@stop