@extends('adminlte::page')

@section('title', 'Reporte de Clientes con Saldo a Favor')
@section('plugins.Select2', true)

@section('content_header')
    <h4><i class="fas fa-hand-holding-usd text-success"></i> Reporte de Clientes con Saldo a Favor</h4>
@stop

@section('content')
    <div class="card">
        <div class="card-body">

            <div class="row mb-4">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header bg-light">
                            <h3 class="card-title">Filtros de búsqueda</h3>
                        </div>
                        <div class="card-body">
                            <form action="{{ route('reportes.clientes-saldo-favor.search') }}" method="GET" class="mb-0">
                                @csrf
                                <div class="row align-items-end">
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="cliente_id">Cliente</label>
                                            <select name="cliente_id" id="cliente_id" class="form-control select2"
                                                style="width: 100%">
                                                <option value="">Todos los clientes</option>
                                                @php
                                                    $todosClientes = \App\Models\Cliente::where('estado', 1)
                                                        ->whereNotIn('razon_social', ['STOCK MACHO', 'STOCK HEMBRA', 'STOCK TIPO', 'STOCK ESPECIAL'])
                                                        ->orderBy('razon_social')
                                                        ->get();
                                                @endphp
                                                @foreach ($todosClientes as $cliente)
                                                    <option value="{{ $cliente->id }}"
                                                        {{ request('cliente_id') == $cliente->id ? 'selected' : '' }}>
                                                        {{ $cliente->razon_social }} - {{ $cliente->documento }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="tipo_cliente">Tipo de Cliente</label>
                                            <select name="tipo_cliente" id="tipo_cliente" class="form-control">
                                                <option value="">Todos los tipos</option>
                                                <option value="despacho" {{ request('tipo_cliente') == 'despacho' ? 'selected' : '' }}>Clientes de Despacho</option>
                                                <option value="stock" {{ request('tipo_cliente') == 'stock' ? 'selected' : '' }}>Clientes STOCK</option>
                                                <option value="perdida" {{ request('tipo_cliente') == 'perdida' ? 'selected' : '' }}>Clientes Pérdida</option>
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="btn-group float-right">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="fas fa-search mr-1"></i>
                                                Buscar
                                            </button>

                                            <a href="{{ route('reportes.clientes-saldo-favor.index') }}" class="btn btn-secondary">
                                                <i class="fas fa-broom mr-1"></i>
                                                Limpiar
                                            </a>

                                            <a href="{{ route('reportes.clientes-saldo-favor.export', ['format' => 'excel']) }}?{{ http_build_query(request()->all()) }}"
                                                class="btn btn-success" target="_blank">
                                                <i class="fas fa-file-excel mr-1"></i>
                                                Excel
                                            </a>

                                            <a href="{{ route('reportes.clientes-saldo-favor.export', ['format' => 'pdf']) }}?{{ http_build_query(request()->all()) }}"
                                                class="btn btn-danger" target="_blank">
                                                <i class="fas fa-file-pdf mr-1"></i>
                                                PDF
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            <hr>

            <!-- Resumen -->
            <div class="row mb-3">
                <div class="col-md-4">
                    <div class="info-box bg-success">
                        <span class="info-box-icon"><i class="fas fa-users"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Total Clientes con Saldo</span>
                            <span class="info-box-number">{{ $clientes->count() }}</span>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="info-box bg-info">
                        <span class="info-box-icon"><i class="fas fa-money-bill-wave"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Saldo Total a Favor</span>
                            <span class="info-box-number">S/ {{ number_format($clientes->sum('saldo_a_favor'), 2) }}</span>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="info-box bg-primary">
                        <span class="info-box-icon"><i class="fas fa-file-invoice"></i></span>
                        <div class="info-box-content">
                            <span class="info-box-text">Ventas con Saldo</span>
                            <span class="info-box-number">{{ $clientes->sum('ventas_con_saldo') }}</span>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Tabla de resultados -->
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>#</th>
                            <th>N° Documento</th>
                            <th>Cliente</th>
                            <th>Ubicación</th>
                            <th>Celular</th>
                            <th class="text-right">Saldo a Favor</th>
                            <th class="text-center">Ventas con Saldo</th>
                            <th class="text-center">Días desde Saldo</th>
                            <th class="text-center">Fecha Venta Más Antigua</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ($clientes as $index => $cliente)
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>{{ $cliente->documento }}</td>
                                <td><strong>{{ $cliente->razon_social }}</strong></td>
                                <td>{{ $cliente->direccion ?? '—' }}</td>
                                <td>{{ $cliente->celular ?? '—' }}</td>
                                <td class="text-right">
                                    <span class="badge badge-success" style="font-size: 1em;">
                                        S/ {{ number_format($cliente->saldo_a_favor, 2) }}
                                    </span>
                                </td>
                                <td class="text-center">
                                    <span class="badge badge-info">{{ $cliente->ventas_con_saldo }}</span>
                                </td>
                                <td class="text-center">
                                    @if($cliente->dias_desde_saldo)
                                        <span class="badge badge-secondary">
                                            {{ $cliente->dias_desde_saldo }} días
                                        </span>
                                    @else
                                        —
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if($cliente->fecha_venta_mas_antigua)
                                        {{ \Carbon\Carbon::parse($cliente->fecha_venta_mas_antigua)->format('d/m/Y') }}
                                    @else
                                        —
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="9" class="text-center">
                                    <div class="alert alert-info">
                                        <i class="fas fa-info-circle mr-2"></i>
                                        No se encontraron clientes con saldo a favor con los filtros seleccionados.
                                    </div>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if($clientes->count() > 0)
                        <tfoot>
                            <tr class="bg-light">
                                <th colspan="5" class="text-right"><strong>TOTALES:</strong></th>
                                <th class="text-right">
                                    <strong>S/ {{ number_format($clientes->sum('saldo_a_favor'), 2) }}</strong>
                                </th>
                                <th class="text-center">
                                    <strong>{{ $clientes->sum('ventas_con_saldo') }}</strong>
                                </th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    @endif
                </table>
            </div>

        </div>
    </div>
@endsection

@section('css')
    <style>
        .select2-selection {
            height: 40px !important;
        }
        .info-box {
            box-shadow: 0 0 1px rgba(0,0,0,.125), 0 1px 3px rgba(0,0,0,.2);
        }
    </style>
@endsection

@section('js')
    <script>
        // Iniciar Select2 para el filtro de cliente
        $('.select2').select2();
    </script>
@stop