@extends('adminlte::page')

@section('title', 'Reporte General de Proveedores')
@section('plugins.Datatables', true)
@section('plugins.Select2', true)

@section('content_header')
    <h4>Reporte General de Proveedores</h4>
@stop

@section('css')
<style>
    .select2-container .select2-selection--single {
        height: 38px !important;
        border: 1px solid #ced4da !important;
    }
    .select2-container--default .select2-selection--single .select2-selection__rendered {
        line-height: 36px !important;
    }
    .select2-container--default .select2-selection--single .select2-selection__arrow {
        height: 36px !important;
    }
</style>
@stop

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fas fa-filter mr-2"></i>Filtros de Búsqueda
            </h3>
        </div>
        <div class="card-body">
            <form action="{{ route('reportes.general-proveedor.search') }}" method="GET">
                <div class="row">
                    <!-- Proveedor -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="proveedor_id">Proveedor</label>
                            <select name="proveedor_id" id="proveedor_id" class="form-control">
                                <option value="">Todos los proveedores</option>
                                @foreach($todosProveedores as $prov)
                                    <option value="{{ $prov->id }}" {{ isset($request) && $request->proveedor_id == $prov->id ? 'selected' : '' }}>
                                        {{ $prov->razon_social }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <!-- Estado -->
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="estado">Estado</label>
                            <select name="estado" id="estado" class="form-control">
                                <option value="">Todos</option>
                                <option value="1" {{ isset($request) && $request->estado === '1' ? 'selected' : '' }}>Activos</option>
                                <option value="0" {{ isset($request) && $request->estado === '0' ? 'selected' : '' }}>Inactivos</option>
                            </select>
                        </div>
                    </div>

                    <!-- Ordenar Por -->
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="ordenar_por">Ordenar Por</label>
                            <select name="ordenar_por" id="ordenar_por" class="form-control">
                                <option value="razon_social" {{ isset($request) && $request->ordenar_por == 'razon_social' ? 'selected' : '' }}>Nombre (A-Z)</option>
                                <option value="total_comprado" {{ isset($request) && $request->ordenar_por == 'total_comprado' ? 'selected' : '' }}>Total Comprado</option>
                                <option value="total_pagado" {{ isset($request) && $request->ordenar_por == 'total_pagado' ? 'selected' : '' }}>Total Pagado</option>
                                <option value="saldo" {{ isset($request) && $request->ordenar_por == 'saldo' ? 'selected' : '' }}>Saldo Pendiente</option>
                            </select>
                        </div>
                    </div>

                    <!-- Botones -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>&nbsp;</label>
                            <div>
                                <button type="submit" class="btn btn-primary btn-block">
                                    <i class="fas fa-search mr-1"></i> Buscar
                                </button>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-12">
                        <a href="{{ route('reportes.general-proveedor.index') }}" class="btn btn-secondary">
                            <i class="fas fa-eraser mr-1"></i> Limpiar
                        </a>
                        @if(isset($proveedores))
                            <a href="{{ route('reportes.general-proveedor.export', array_merge(['format' => 'pdf'], $request->all())) }}"
                               class="btn btn-danger"
                               target="_blank">
                                <i class="fas fa-file-pdf mr-1"></i> PDF
                            </a>
                            <a href="{{ route('reportes.general-proveedor.export', array_merge(['format' => 'excel'], $request->all())) }}"
                               class="btn btn-success">
                                <i class="fas fa-file-excel mr-1"></i> Excel
                            </a>
                        @endif
                    </div>
                </div>
            </form>
        </div>
    </div>

    @if(isset($proveedores))
        <!-- Tarjetas de Totales -->
        <div class="row">
            <div class="col-md-3">
                <div class="small-box bg-info">
                    <div class="inner">
                        <h3>{{ $totales['total_proveedores'] }}</h3>
                        <p>Total Proveedores</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-users"></i>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-primary">
                    <div class="inner">
                        <h3>S/ {{ number_format($totales['total_comprado'], 2) }}</h3>
                        <p>Total Comprado</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-shopping-cart"></i>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-success">
                    <div class="inner">
                        <h3>S/ {{ number_format($totales['total_pagado'], 2) }}</h3>
                        <p>Total Pagado</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-hand-holding-usd"></i>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3>S/ {{ number_format($totales['total_deuda'], 2) }}</h3>
                        <p>Total por Pagar</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-exclamation-triangle"></i>
                    </div>
                </div>
            </div>
        </div>

        <!-- Tabla de Resultados -->
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">
                    <i class="fas fa-list mr-2"></i>Listado de Proveedores con Estadísticas
                </h3>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table id="proveedoresTable" class="table table-striped table-hover table-sm">
                        <thead class="bg-light">
                            <tr>
                                <th>ID</th>
                                <th>Razón Social</th>
                                <th>RUC</th>
                                <th class="text-right">Total Comprado</th>
                                <th class="text-right">Total Pagado</th>
                                <th class="text-right">Saldo Actual</th>
                                <th class="text-center">Compras</th>
                                <th class="text-center">Pagos</th>
                                <th class="text-center">Estado</th>
                                <th class="text-center">Acciones</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($proveedores as $proveedor)
                                <tr>
                                    <td><strong>#{{ $proveedor->id }}</strong></td>
                                    <td><strong>{{ $proveedor->razon_social }}</strong></td>
                                    <td>{{ $proveedor->ruc ?? 'N/A' }}</td>
                                    <td class="text-right">S/ {{ number_format($proveedor->total_comprado, 2) }}</td>
                                    <td class="text-right">S/ {{ number_format($proveedor->total_pagado, 2) }}</td>
                                    <td class="text-right">
                                        @if($proveedor->saldo_actual > 0)
                                            <span class="badge badge-danger badge-lg">
                                                S/ {{ number_format($proveedor->saldo_actual, 2) }}
                                            </span>
                                        @elseif($proveedor->saldo_actual < 0)
                                            <span class="badge badge-success badge-lg">
                                                S/ {{ number_format($proveedor->saldo_actual, 2) }}
                                            </span>
                                        @else
                                            <span class="badge badge-secondary">S/ 0.00</span>
                                        @endif
                                    </td>
                                    <td class="text-center">
                                        <span class="badge badge-info">{{ $proveedor->cantidad_compras }}</span>
                                    </td>
                                    <td class="text-center">
                                        <span class="badge badge-success">{{ $proveedor->cantidad_pagos }}</span>
                                    </td>
                                    <td class="text-center">
                                        @if($proveedor->estado)
                                            <span class="badge badge-success">Activo</span>
                                        @else
                                            <span class="badge badge-secondary">Inactivo</span>
                                        @endif
                                    </td>
                                    <td class="text-center">
                                        <a href="{{ route('proveedores.show', $proveedor) }}"
                                           class="btn btn-sm btn-info"
                                           title="Ver Detalles">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="10" class="text-center">
                                        <i class="fas fa-info-circle mr-2"></i>No se encontraron proveedores
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif
@stop

@section('js')
<script>
    $(document).ready(function() {
        // Inicializar Select2
        $('#proveedor_id').select2({
            placeholder: 'Todos los proveedores',
            allowClear: true,
            width: '100%'
        });

        @if(isset($proveedores))
            $('#proveedoresTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                pageLength: 25,
                dom: 'Bfrtip',
                buttons: []
            });
        @endif
    });
</script>
@stop