@extends('adminlte::page')

@section('title', 'Reporte de Pagos a Proveedores')
@section('plugins.Datatables', true)

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

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fas fa-money-check-alt mr-2"></i>Filtros de Búsqueda
            </h3>
        </div>
        <div class="card-body">
            <form action="{{ route('reportes.pagos-proveedor.search') }}" method="GET">
                <div class="row">
                    <!-- Fecha Inicio -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label for="fecha_inicio">Fecha Inicio <span class="text-danger">*</span></label>
                            <input type="date"
                                   name="fecha_inicio"
                                   id="fecha_inicio"
                                   class="form-control"
                                   value="{{ $request->fecha_inicio ?? date('Y-m-01') }}"
                                   required>
                        </div>
                    </div>

                    <!-- Fecha Fin -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label for="fecha_fin">Fecha Fin <span class="text-danger">*</span></label>
                            <input type="date"
                                   name="fecha_fin"
                                   id="fecha_fin"
                                   class="form-control"
                                   value="{{ $request->fecha_fin ?? date('Y-m-d') }}"
                                   required>
                        </div>
                    </div>

                    <!-- Proveedor -->
                    <div class="col-md-3">
                        <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($proveedores as $proveedor)
                                    <option value="{{ $proveedor->id }}"
                                        {{ isset($request) && $request->proveedor_id == $proveedor->id ? 'selected' : '' }}>
                                        {{ $proveedor->razon_social }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <!-- Empresa Compradora -->
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="empresa_compradora_id">Empresa Compradora</label>
                            <select name="empresa_compradora_id" id="empresa_compradora_id" class="form-control">
                                <option value="">Todas las empresas</option>
                                @foreach($empresasCompradoras as $empresa)
                                    <option value="{{ $empresa->id }}"
                                        {{ isset($request) && $request->empresa_compradora_id == $empresa->id ? 'selected' : '' }}>
                                        {{ $empresa->razon_social }} - {{ $empresa->ruc }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <!-- Método de Pago -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label for="metodo_pago">Método de Pago</label>
                            <select name="metodo_pago" id="metodo_pago" class="form-control">
                                <option value="">Todos</option>
                                <option value="efectivo" {{ isset($request) && $request->metodo_pago == 'efectivo' ? 'selected' : '' }}>Efectivo</option>
                                <option value="transferencia" {{ isset($request) && $request->metodo_pago == 'transferencia' ? 'selected' : '' }}>Transferencia</option>
                                <option value="deposito" {{ isset($request) && $request->metodo_pago == 'deposito' ? 'selected' : '' }}>Depósito</option>
                                <option value="cheque" {{ isset($request) && $request->metodo_pago == 'cheque' ? 'selected' : '' }}>Cheque</option>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <!-- Tipo de Vista -->
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="tipo_vista">Tipo de Vista</label>
                            <select name="tipo_vista" id="tipo_vista" class="form-control">
                                <option value="detallado" {{ isset($request) && $request->tipo_vista == 'detallado' ? 'selected' : '' }}>Detallado</option>
                                <option value="resumen" {{ isset($request) && $request->tipo_vista == 'resumen' ? 'selected' : '' }}>Resumen por Empresa</option>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <!-- Botones -->
                    <div class="col-md-12">
                        <div class="form-group">
                            <button type="submit" class="btn btn-primary">
                                <i class="fas fa-search mr-1"></i> Buscar
                            </button>
                            <a href="{{ route('reportes.pagos-proveedor.index') }}" class="btn btn-secondary">
                                <i class="fas fa-eraser mr-1"></i> Limpiar
                            </a>
                            @if(isset($pagos))
                                <a href="{{ route('reportes.pagos-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.pagos-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>
                </div>
            </form>
        </div>
    </div>

    @if(isset($pagos))
        <!-- Tarjetas de Totales -->
        <div class="row">
            <div class="col-md-3">
                <div class="small-box bg-info">
                    <div class="inner">
                        <h3>{{ $totales['cantidad'] }}</h3>
                        <p>Total Pagos</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-success">
                    <div class="inner">
                        <h3>S/ {{ number_format($totalesPorMetodo['efectivo'], 2) }}</h3>
                        <p>Efectivo</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-money-bill-wave"></i>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-primary">
                    <div class="inner">
                        <h3>S/ {{ number_format($totalesPorMetodo['transferencia'] + $totalesPorMetodo['deposito'], 2) }}</h3>
                        <p>Transferencias</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-exchange-alt"></i>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3>S/ {{ number_format($totalesPorMetodo['cheque'], 2) }}</h3>
                        <p>Cheques</p>
                    </div>
                    <div class="icon">
                        <i class="fas fa-money-check"></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>Resultados
                    @if(isset($request) && $request->tipo_vista === 'resumen')
                        <span class="badge badge-info ml-2">Vista Resumen</span>
                    @else
                        <span class="badge badge-primary ml-2">Vista Detallada</span>
                    @endif
                </h3>
            </div>
            <div class="card-body">
                @if(isset($request) && $request->tipo_vista === 'resumen' && isset($resumenPorEmpresa))
                    <!-- Vista Resumen por Empresa -->
                    <div class="table-responsive">
                        <table id="resumenTable" class="table table-striped table-hover table-sm">
                            <thead class="bg-light">
                                <tr>
                                    <th>Empresa</th>
                                    <th class="text-center">Cantidad Pagos</th>
                                    <th class="text-right">Total Monto</th>
                                    <th class="text-right">Efectivo</th>
                                    <th class="text-right">Transferencias</th>
                                    <th class="text-right">Depósitos</th>
                                    <th class="text-right">Cheques</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($resumenPorEmpresa as $resumen)
                                    <tr>
                                        <td>
                                            <strong>{{ $resumen['empresa_nombre'] }}</strong>
                                            @if($resumen['empresa_ruc'])
                                                <br><small class="text-muted">RUC: {{ $resumen['empresa_ruc'] }}</small>
                                            @endif
                                        </td>
                                        <td class="text-center">
                                            <span class="badge badge-primary">{{ $resumen['cantidad_pagos'] }}</span>
                                        </td>
                                        <td class="text-right">
                                            <strong>S/ {{ number_format($resumen['total_monto'], 2) }}</strong>
                                        </td>
                                        <td class="text-right">
                                            <span class="text-success">S/ {{ number_format($resumen['por_metodo']['efectivo'], 2) }}</span>
                                        </td>
                                        <td class="text-right">
                                            <span class="text-primary">S/ {{ number_format($resumen['por_metodo']['transferencia'], 2) }}</span>
                                        </td>
                                        <td class="text-right">
                                            <span class="text-info">S/ {{ number_format($resumen['por_metodo']['deposito'], 2) }}</span>
                                        </td>
                                        <td class="text-right">
                                            <span class="text-warning">S/ {{ number_format($resumen['por_metodo']['cheque'], 2) }}</span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="7" class="text-center">
                                            <i class="fas fa-info-circle mr-2"></i>No se encontraron pagos con los filtros seleccionados
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                            @if($resumenPorEmpresa->isNotEmpty())
                                <tfoot class="bg-light font-weight-bold">
                                    <tr>
                                        <td><strong>TOTAL GENERAL</strong></td>
                                        <td class="text-center"><strong>{{ $totales['cantidad'] }}</strong></td>
                                        <td class="text-right"><strong>S/ {{ number_format($totales['total'], 2) }}</strong></td>
                                        <td class="text-right"><strong>S/ {{ number_format($totalesPorMetodo['efectivo'], 2) }}</strong></td>
                                        <td class="text-right"><strong>S/ {{ number_format($totalesPorMetodo['transferencia'], 2) }}</strong></td>
                                        <td class="text-right"><strong>S/ {{ number_format($totalesPorMetodo['deposito'], 2) }}</strong></td>
                                        <td class="text-right"><strong>S/ {{ number_format($totalesPorMetodo['cheque'], 2) }}</strong></td>
                                    </tr>
                                </tfoot>
                            @endif
                        </table>
                    </div>
                @else
                    <!-- Vista Detallada -->
                    <div class="table-responsive">
                        <table id="pagosTable" class="table table-striped table-hover table-sm">
                        <thead class="bg-light">
                            <tr>
                                <th>ID</th>
                                <th>Fecha</th>
                                <th>Proveedor</th>
                                <th>Lote Pago</th>
                                <th>Método</th>
                                <th>Banco</th>
                                <th>Nº Operación</th>
                                <th class="text-right">Monto</th>
                                <th>Usuario</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($pagos as $pago)
                                <tr>
                                    <td><strong>#{{ $pago->id }}</strong></td>
                                    <td>{{ $pago->fecha_pago->format('d/m/Y') }}</td>
                                    <td>
                                        <strong>{{ $pago->proveedor->razon_social }}</strong>
                                        @if($pago->proveedor->ruc)
                                            <br><small class="text-muted">RUC: {{ $pago->proveedor->ruc }}</small>
                                        @endif
                                    </td>
                                    <td>
                                        @if($pago->lote_pago_id)
                                            <span class="badge badge-info">{{ $pago->lote_pago_id }}</span>
                                        @else
                                            <span class="badge badge-secondary">Individual</span>
                                        @endif
                                    </td>
                                    <td>
                                        @php
                                            $badgesMetodo = [
                                                'efectivo' => 'badge-success',
                                                'transferencia' => 'badge-primary',
                                                'deposito' => 'badge-info',
                                                'cheque' => 'badge-warning'
                                            ];
                                        @endphp
                                        <span class="badge {{ $badgesMetodo[$pago->metodo_pago] ?? 'badge-secondary' }}">
                                            {{ strtoupper($pago->metodo_pago) }}
                                        </span>
                                    </td>
                                    <td>
                                        @if($pago->banco)
                                            <strong>{{ $pago->banco->nombre }}</strong>
                                            @if($pago->banco->numero_cuenta)
                                                <br><small class="text-muted">{{ $pago->banco->numero_cuenta }}</small>
                                            @endif
                                        @else
                                            <span class="text-muted">-</span>
                                        @endif
                                    </td>
                                    <td>{{ $pago->numero_operacion ?? '-' }}</td>
                                    <td class="text-right"><strong>S/ {{ number_format($pago->monto_total, 2) }}</strong></td>
                                    <td>
                                        <small>{{ $pago->usuario->name ?? 'N/A' }}</small>
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="10" class="text-center">
                                        <i class="fas fa-info-circle mr-2"></i>No se encontraron pagos con los filtros seleccionados
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                        @if($pagos->isNotEmpty())
                            <tfoot class="bg-light font-weight-bold">
                                <tr>
                                    <td colspan="8" class="text-right"><strong>TOTAL GENERAL:</strong></td>
                                    <td class="text-right"><strong>S/ {{ number_format($totales['total'], 2) }}</strong></td>
                                    <td></td>
                                </tr>
                            </tfoot>
                        @endif
                        </table>
                    </div>
                @endif

                @if(isset($pagos) && $pagos->isNotEmpty())
                    <!-- Resumen por Método de Pago -->
                    <div class="row mt-4">
                        <div class="col-md-12">
                            <div class="card card-outline card-primary">
                                <div class="card-header">
                                    <h3 class="card-title">
                                        <i class="fas fa-chart-pie mr-2"></i>Totales por Método de Pago
                                    </h3>
                                </div>
                                <div class="card-body">
                                    <table class="table table-sm table-bordered">
                                        <thead class="bg-light">
                                            <tr>
                                                <th>Método de Pago</th>
                                                <th class="text-right">Monto</th>
                                                <th class="text-right">% del Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                <td><span class="badge badge-success">EFECTIVO</span></td>
                                                <td class="text-right">S/ {{ number_format($totalesPorMetodo['efectivo'], 2) }}</td>
                                                <td class="text-right">
                                                    {{ $totales['total'] > 0 ? number_format(($totalesPorMetodo['efectivo'] / $totales['total']) * 100, 2) : 0 }}%
                                                </td>
                                            </tr>
                                            <tr>
                                                <td><span class="badge badge-primary">TRANSFERENCIA</span></td>
                                                <td class="text-right">S/ {{ number_format($totalesPorMetodo['transferencia'], 2) }}</td>
                                                <td class="text-right">
                                                    {{ $totales['total'] > 0 ? number_format(($totalesPorMetodo['transferencia'] / $totales['total']) * 100, 2) : 0 }}%
                                                </td>
                                            </tr>
                                            <tr>
                                                <td><span class="badge badge-info">DEPÓSITO</span></td>
                                                <td class="text-right">S/ {{ number_format($totalesPorMetodo['deposito'], 2) }}</td>
                                                <td class="text-right">
                                                    {{ $totales['total'] > 0 ? number_format(($totalesPorMetodo['deposito'] / $totales['total']) * 100, 2) : 0 }}%
                                                </td>
                                            </tr>
                                            <tr>
                                                <td><span class="badge badge-warning">CHEQUE</span></td>
                                                <td class="text-right">S/ {{ number_format($totalesPorMetodo['cheque'], 2) }}</td>
                                                <td class="text-right">
                                                    {{ $totales['total'] > 0 ? number_format(($totalesPorMetodo['cheque'] / $totales['total']) * 100, 2) : 0 }}%
                                                </td>
                                            </tr>
                                        </tbody>
                                        <tfoot class="bg-light font-weight-bold">
                                            <tr>
                                                <td>TOTAL</td>
                                                <td class="text-right">S/ {{ number_format($totales['total'], 2) }}</td>
                                                <td class="text-right">100%</td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                @endif
            </div>
        </div>
    @endif
@stop

@section('js')
<script>
    $(document).ready(function() {
        @if(isset($pagos))
            // Inicializar tabla detallada
            $('#pagosTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                order: [[1, 'desc']],
                pageLength: 25,
                dom: 'Bfrtip',
                buttons: []
            });
        @endif

        @if(isset($resumenPorEmpresa) && $resumenPorEmpresa->isNotEmpty())
            // Inicializar tabla resumen
            $('#resumenTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                order: [[2, 'desc']], // Ordenar por total monto
                pageLength: 25,
                dom: 'Bfrtip',
                buttons: []
            });
        @endif
    });
</script>
@stop