@extends('adminlte::page')

@section('title', 'Estado de Cuenta - Proveedor')
@section('plugins.Datatables', true)

@section('content_header')
    <h4>Estado de Cuenta por Proveedor</h4>
@stop

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">
                <i class="fas fa-search mr-2"></i>Seleccionar Proveedor
            </h3>
        </div>
        <div class="card-body">
            <form action="{{ route('reportes.estado-cuenta-proveedor.search') }}" method="GET">
                <div class="row">
                    <!-- Proveedor -->
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="proveedor_id">Proveedor <span class="text-danger">*</span></label>
                            <select name="proveedor_id" id="proveedor_id" class="form-control" required>
                                <option value="">Seleccione un proveedor</option>
                                @foreach($proveedores as $prov)
                                    <option value="{{ $prov->id }}"
                                        {{ isset($request) && $request->proveedor_id == $prov->id ? 'selected' : '' }}>
                                        {{ $prov->razon_social }} - Saldo: S/ {{ number_format($prov->saldo_actual, 2) }}
                                    </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 }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <!-- Fecha Inicio -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label for="fecha_inicio">Fecha Inicio</label>
                            <input type="date" name="fecha_inicio" id="fecha_inicio" class="form-control"
                                   value="{{ $request->fecha_inicio ?? '' }}">
                        </div>
                    </div>
                    <!-- Fecha Fin -->
                    <div class="col-md-2">
                        <div class="form-group">
                            <label for="fecha_fin">Fecha Fin</label>
                            <input type="date" name="fecha_fin" id="fecha_fin" class="form-control"
                                   value="{{ $request->fecha_fin ?? '' }}">
                        </div>
                    </div>

                    <!-- Tipo de Vista -->
                    <div class="col-md-2">
                        <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" {{ ($request->tipo_vista ?? 'detallado') == 'detallado' ? 'selected' : '' }}>
                                    Detallado
                                </option>
                                <option value="resumido" {{ ($request->tipo_vista ?? '') == 'resumido' ? 'selected' : '' }}>
                                    Resumido
                                </option>
                            </select>
                        </div>
                    </div>

                    <div class="col-md-2">
                        <div class="form-group">
                            <label>&nbsp;</label>
                            <button type="submit" class="btn btn-primary btn-block">
                                <i class="fas fa-search mr-1"></i> Buscar
                            </button>
                        </div>
                    </div>
                </div>
                @if(isset($proveedor))
                    <div class="row">
                        <div class="col-md-12">
                            <a href="{{ route('reportes.estado-cuenta-proveedor.index') }}" class="btn btn-secondary">
                                <i class="fas fa-eraser mr-1"></i> Limpiar
                            </a>
                            <a href="{{ route('reportes.estado-cuenta-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.estado-cuenta-proveedor.export', array_merge(['format' => 'excel'], $request->all())) }}"
                               class="btn btn-success">
                                <i class="fas fa-file-excel mr-1"></i> Excel
                            </a>
                        </div>
                    </div>
                @endif
            </form>
        </div>
    </div>

    @if(isset($proveedor))
        <!-- Información del Proveedor -->
        <div class="card card-primary card-outline">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-6">
                        <h5><i class="fas fa-building mr-2"></i>{{ $proveedor->razon_social }}</h5>
                        <p class="mb-1"><strong>RUC:</strong> {{ $proveedor->ruc ?? 'N/A' }}</p>
                        <p class="mb-1"><strong>Teléfono:</strong> {{ $proveedor->telefono ?? 'N/A' }}</p>
                        <p class="mb-1"><strong>Email:</strong> {{ $proveedor->email ?? 'N/A' }}</p>
                    </div>
                    <div class="col-md-6">
                        @if($estadisticas['saldo_actual'] > 0)
                            <div class="info-box bg-danger">
                                <div class="info-box-content">
                                    <span class="info-box-text">Saldo Pendiente</span>
                                    <span class="info-box-number">S/ {{ number_format($estadisticas['saldo_actual'], 2) }}</span>
                                </div>
                            </div>
                        @elseif($estadisticas['saldo_actual'] < 0)
                            <div class="info-box bg-success">
                                <div class="info-box-content">
                                    <span class="info-box-text">Saldo a Favor</span>
                                    <span class="info-box-number">S/ {{ number_format(abs($estadisticas['saldo_actual']), 2) }}</span>
                                </div>
                            </div>
                        @else
                            <div class="info-box bg-info">
                                <div class="info-box-content">
                                    <span class="info-box-text">Saldo en Cero</span>
                                    <span class="info-box-number">S/ 0.00</span>
                                </div>
                            </div>
                        @endif

                        @if(isset($estadisticas['total_pagado_automatico']) && $estadisticas['total_pagado_automatico'] > 0)
                            <div class="info-box bg-warning mt-2">
                                <div class="info-box-content">
                                    <span class="info-box-text">Pagos Automáticos</span>
                                    <span class="info-box-number">S/ {{ number_format($estadisticas['total_pagado_automatico'], 2) }}</span>
                                </div>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>

        <!-- Estadísticas -->
        <div class="row">
            <div class="col-md-3">
                <div class="small-box bg-primary">
                    <div class="inner">
                        <h3>S/ {{ number_format($estadisticas['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($estadisticas['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-info">
                    <div class="inner">
                        <h3>{{ $estadisticas['cantidad_compras'] }}</h3>
                        <p>Total Compras</p>
                    </div>
                    <div class="icon"><i class="fas fa-file-invoice"></i></div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3>{{ $estadisticas['cantidad_pagos'] }}</h3>
                        <p>Total Pagos</p>
                        @if(isset($estadisticas['cantidad_pagos_automaticos']) && $estadisticas['cantidad_pagos_automaticos'] > 0)
                            <small>({{ $estadisticas['cantidad_pagos_automaticos'] }} automáticos)</small>
                        @endif
                    </div>
                    <div class="icon"><i class="fas fa-money-check-alt"></i></div>
                </div>
            </div>
        </div>

        @if(($request->tipo_vista ?? 'detallado') == 'resumido')
        <!-- Vista Resumido: Resumen Diario -->
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">
                    <i class="fas fa-calendar-day mr-2"></i>Resumen Diario por Empresa
                </h3>
            </div>
            <div class="card-body">
                @if(isset($resumenDiario) && $resumenDiario)
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped table-sm">
                            <thead class="bg-light">
                                <tr>
                                    <th style="width: 15%;">Día</th>
                                    @foreach($resumenDiario['empresas'] as $empresa)
                                        <th class="text-center" style="width: {{ 85 / count($resumenDiario['empresas']) }}%;">
                                            {{ $empresa->razon_social }}
                                        </th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($resumenDiario['dias'] as $dia)
                                    <tr>
                                        <td class="font-weight-bold">
                                            {{ strtoupper($dia['nombre_dia']) }}<br>
                                            <small class="text-muted">{{ $dia['fecha']->format('d/m/Y') }}</small>
                                        </td>
                                        @foreach($resumenDiario['empresas'] as $empresa)
                                            @php
                                                $saldoData = $dia['empresas'][$empresa->id] ?? null;
                                                $saldo = $saldoData ? $saldoData['saldo'] : 0;
                                                $esPositivo = $saldo >= 0;
                                            @endphp
                                            <td class="text-right font-weight-bold
                                                {{ $esPositivo ? 'text-primary' : 'text-danger' }}">
                                                @if($saldoData)
                                                    S/ {{ number_format($saldo, 2) }}
                                                @else
                                                    -
                                                @endif
                                            </td>
                                        @endforeach
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                @else
                    <div class="alert alert-info text-center">
                        <i class="fas fa-info-circle mr-2"></i>
                        Selecciona un rango de fechas de más de un día para ver el resumen diario.
                    </div>
                @endif
            </div>
        </div>
        @endif

        @if(($request->tipo_vista ?? 'detallado') == 'detallado')
        <!-- Pestañas de Información -->
        <div class="card">
            <div class="card-header p-0 pt-1">
                <ul class="nav nav-tabs" id="estadoCuentaTabs" role="tablist">
                    <li class="nav-item">
                        <a class="nav-link active" id="historial-tab" data-toggle="tab" href="#historial" role="tab">
                            <i class="fas fa-history mr-1"></i> Historial de Movimientos
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" id="compras-tab" data-toggle="tab" href="#compras" role="tab">
                            <i class="fas fa-shopping-cart mr-1"></i> Compras ({{ $compras->count() }})
                        </a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" id="pagos-tab" data-toggle="tab" href="#pagos" role="tab">
                            <i class="fas fa-hand-holding-usd mr-1"></i> Pagos ({{ $pagos->count() }})
                        </a>
                    </li>
                    @if(!isset($request->empresa_compradora_id) || empty($request->empresa_compradora_id))
                    <li class="nav-item">
                        <a class="nav-link" id="empresas-tab" data-toggle="tab" href="#empresas" role="tab">
                            <i class="fas fa-building mr-1"></i> Por Empresa Compradora
                        </a>
                    </li>
                    @endif
                </ul>
            </div>
            <div class="card-body">
                <div class="tab-content" id="estadoCuentaTabContent">
                    <!-- Tab Historial -->
                    <div class="tab-pane fade show active" id="historial" role="tabpanel">
                        <div class="table-responsive">
                            <table id="movimientosTable" class="table table-striped table-hover table-sm">
                                <thead class="bg-light">
                                    <tr>
                                        <th>Fecha</th>
                                        <th>Tipo</th>
                                        <th>Descripción</th>
                                        <th>Empresa Compradora</th>
                                        <th class="text-right">Monto</th>
                                        <th class="text-right">Saldo Anterior</th>
                                        <th class="text-right">Saldo Nuevo</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($movimientos as $mov)
                                        <tr>
                                            <td>{{ $mov->fecha_movimiento->format('d/m/Y') }}</td>
                                            <td>
                                                @php
                                                    $badges = [
                                                        'compra' => 'badge-danger',
                                                        'pago' => 'badge-success',
                                                        'nota_credito' => 'badge-info',
                                                        'nota_debito' => 'badge-warning',
                                                        'ajuste' => 'badge-secondary',
                                                        'anulacion_compra' => 'badge-dark'
                                                    ];
                                                @endphp
                                                <span class="badge {{ $badges[$mov->tipo_movimiento] ?? 'badge-secondary' }}">
                                                    {{ strtoupper(str_replace('_', ' ', $mov->tipo_movimiento)) }}
                                                </span>
                                            </td>
                                            <td>
                                                @if($mov->pagoProveedor && $mov->pagoProveedor->metodo_pago == 'saldo_a_favor')
                                                    <span class="text-warning">
                                                        <i class="fas fa-robot mr-1"></i>{{ $mov->descripcion }}
                                                    </span>
                                                @else
                                                    {{ $mov->descripcion }}
                                                @endif
                                            </td>
                                            <td>
                                                @if($mov->compra && $mov->compra->empresaCompradora)
                                                    <small>{{ $mov->compra->empresaCompradora->razon_social }}</small>
                                                @elseif($mov->pagoProveedor && $mov->pagoProveedor->empresaCompradora)
                                                    <small>{{ $mov->pagoProveedor->empresaCompradora->razon_social }}</small>
                                                @elseif($mov->pagoMaestro && $mov->pagoMaestro->empresaCompradora)
                                                    <small>{{ $mov->pagoMaestro->empresaCompradora->razon_social }}</small>
                                                @elseif($mov->empresa_compradora_id && $mov->empresaCompradora)
                                                    <small>{{ $mov->empresaCompradora->razon_social }}</small>
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td class="text-right">
                                                @if(in_array($mov->tipo_movimiento, ['compra', 'nota_debito', 'ajuste']))
                                                    <span class="text-danger">+S/ {{ number_format($mov->monto, 2) }}</span>
                                                @else
                                                    <span class="text-success">-S/ {{ number_format($mov->monto, 2) }}</span>
                                                @endif
                                            </td>
                                            <td class="text-right">S/ {{ number_format($mov->saldo_anterior, 2) }}</td>
                                            <td class="text-right"><strong>S/ {{ number_format($mov->saldo_nuevo, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="7" class="text-center">
                                                <i class="fas fa-info-circle mr-2"></i>No hay movimientos registrados
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>

                    <!-- Tab Compras -->
                    <div class="tab-pane fade" id="compras" role="tabpanel">
                        <div class="table-responsive">
                            <table id="comprasTable" class="table table-striped table-hover table-sm">
                                <thead class="bg-light">
                                    <tr>
                                        <th>ID</th>
                                        <th>Fecha</th>
                                        <th>Nº Factura</th>
                                        <th>Tipo Documento</th>
                                        <th>Empresa Compradora</th>
                                        <th class="text-right">Subtotal</th>
                                        <th class="text-right">IGV</th>
                                        <th class="text-right">Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($compras as $compra)
                                        <tr>
                                            <td><strong>#{{ $compra->id }}</strong></td>
                                            <td>{{ $compra->fecha_compra->format('d/m/Y') }}</td>
                                            <td>{{ $compra->numero_factura }}</td>
                                            <td>
                                                @php
                                                    $badges = [
                                                        'factura' => 'badge-primary',
                                                        'boleta' => 'badge-info',
                                                        'nota_credito' => 'badge-success',
                                                        'nota_debito' => 'badge-warning'
                                                    ];
                                                @endphp
                                                <span class="badge {{ $badges[$compra->tipo_documento] ?? 'badge-secondary' }}">
                                                    {{ strtoupper(str_replace('_', ' ', $compra->tipo_documento)) }}
                                                </span>
                                            </td>
                                            <td>
                                                @if($compra->empresaCompradora)
                                                    <strong>{{ $compra->empresaCompradora->razon_social }}</strong>
                                                    <br><small class="text-muted">{{ $compra->empresaCompradora->ruc }}</small>
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td class="text-right">S/ {{ number_format($compra->subtotal, 2) }}</td>
                                            <td class="text-right">S/ {{ number_format($compra->igv, 2) }}</td>
                                            <td class="text-right"><strong>S/ {{ number_format($compra->total, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="8" class="text-center">
                                                <i class="fas fa-info-circle mr-2"></i>No hay compras registradas
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                @if($compras->isNotEmpty())
                                    <tfoot class="bg-light font-weight-bold">
                                        <tr>
                                            <td colspan="5" class="text-right"><strong>TOTALES:</strong></td>
                                            <td class="text-right"><strong>S/ {{ number_format($compras->sum('subtotal'), 2) }}</strong></td>
                                            <td class="text-right"><strong>S/ {{ number_format($compras->sum('igv'), 2) }}</strong></td>
                                            <td class="text-right"><strong>S/ {{ number_format($compras->sum('total'), 2) }}</strong></td>
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>

                    <!-- Tab Pagos -->
                    <div class="tab-pane fade" id="pagos" role="tabpanel">
                        <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>Compra Asociada</th>
                                        <th>Método</th>
                                        <th>Empresa Compradora</th>
                                        <th>Nº Operación</th>
                                        <th class="text-right">Monto</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>
                                                @if($pago->compra)
                                                    {{ $pago->compra->numero_factura }}
                                                @else
                                                    <span class="badge badge-secondary">A cuenta</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->empresaCompradora)
                                                    <strong>{{ $pago->empresaCompradora->razon_social }}</strong>
                                                    <br><small class="text-muted">{{ $pago->empresaCompradora->ruc }}</small>
                                                @else
                                                    -
                                                @endif
                                            </td>
                                            <td>{{ $pago->numero_operacion ?? '-' }}</td>
                                            <td class="text-right"><strong>S/ {{ number_format($pago->monto, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="7" class="text-center">
                                                <i class="fas fa-info-circle mr-2"></i>No hay pagos registrados
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                @if($pagos->isNotEmpty())
                                    <tfoot class="bg-light font-weight-bold">
                                        <tr>
                                            <td colspan="6" class="text-right"><strong>TOTAL PAGADO:</strong></td>
                                            <td class="text-right"><strong>S/ {{ number_format($pagos->sum('monto'), 2) }}</strong></td>
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>

                    <!-- Tab Por Empresa Compradora -->
                    @if(!isset($request->empresa_compradora_id) || empty($request->empresa_compradora_id))
                    <div class="tab-pane fade" id="empresas" role="tabpanel">
                        @if(isset($saldosPorEmpresa) && count($saldosPorEmpresa) > 0)
                            <!-- Tabla Resumen por Empresa -->
                            <div class="card mb-4">
                                <div class="card-header bg-success text-white">
                                    <h5 class="mb-0">
                                        <i class="fas fa-chart-pie mr-2"></i>Resumen por Empresa Compradora
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table table-striped table-hover">
                                            <thead class="bg-light">
                                                <tr>
                                                    <th class="text-center">#</th>
                                                    <th>Empresa Compradora</th>
                                                    <th class="text-right">Saldo Actual</th>
                                                    <th class="text-center">Estado</th>
                                                    <th class="text-right">Total Comprado</th>
                                                    <th class="text-right">Total Pagado</th>
                                                    <th class="text-center">Movimientos</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($saldosPorEmpresa as $empresaNombre => $datos)
                                                    <tr>
                                                        <td class="text-center">{{ $loop->iteration }}</td>
                                                        <td>
                                                            <strong>{{ $datos['empresa'] ?? 'Movimientos Generales' }}</strong>
                                                            @if(!isset($datos['empresa']))
                                                                <br><small class="text-muted">(Ajustes, saldos iniciales y otros)</small>
                                                            @endif
                                                        </td>
                                                        <td class="text-right">
                                                            @if($datos['saldo_final'] > 0)
                                                                <span class="text-danger font-weight-bold">
                                                                    S/ {{ number_format($datos['saldo_final'], 2) }}
                                                                </span>
                                                            @elseif($datos['saldo_final'] < 0)
                                                                <span class="text-success font-weight-bold">
                                                                    S/ {{ number_format(abs($datos['saldo_final']), 2) }}
                                                                </span>
                                                            @else
                                                                <span class="text-muted font-weight-bold">
                                                                    S/ 0.00
                                                                </span>
                                                            @endif
                                                        </td>
                                                        <td class="text-center">
                                                            @if($datos['saldo_final'] > 0)
                                                                <span class="badge badge-danger">
                                                                    <i class="fas fa-exclamation-triangle mr-1"></i>Pendiente
                                                                </span>
                                                            @elseif($datos['saldo_final'] < 0)
                                                                <span class="badge badge-success">
                                                                    <i class="fas fa-check-circle mr-1"></i>A Favor
                                                                </span>
                                                            @else
                                                                <span class="badge badge-info">
                                                                    <i class="fas fa-balance-scale mr-1"></i>Al Día
                                                                </span>
                                                            @endif
                                                        </td>
                                                        <td class="text-right">
                                                            <span class="text-primary">
                                                                S/ {{ number_format($datos['total_compras'], 2) }}
                                                            </span>
                                                        </td>
                                                        <td class="text-right">
                                                            <span class="text-success">
                                                                S/ {{ number_format($datos['total_pagos'], 2) }}
                                                            </span>
                                                        </td>
                                                        <td class="text-center">
                                                            <span class="badge badge-secondary">
                                                                {{ $datos['movimientos']->count() }}
                                                            </span>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                            <tfoot class="bg-light font-weight-bold">
                                                <tr>
                                                    <td colspan="2" class="text-right"><strong>TOTALES:</strong></td>
                                                    <td class="text-right">
                                                        @php
                                                            $saldoTotal = collect($saldosPorEmpresa)->sum('saldo_final');
                                                        @endphp
                                                        @if($saldoTotal > 0)
                                                            <span class="text-danger">
                                                                S/ {{ number_format($saldoTotal, 2) }}
                                                            </span>
                                                        @elseif($saldoTotal < 0)
                                                            <span class="text-success">
                                                                S/ {{ number_format(abs($saldoTotal), 2) }}
                                                            </span>
                                                        @else
                                                            <span class="text-muted">
                                                                S/ 0.00
                                                            </span>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        @if($saldoTotal > 0)
                                                            <span class="badge badge-danger">Pendiente</span>
                                                        @elseif($saldoTotal < 0)
                                                            <span class="badge badge-success">A Favor</span>
                                                        @else
                                                            <span class="badge badge-info">Al Día</span>
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        <strong>S/ {{ number_format(collect($saldosPorEmpresa)->sum('total_compras'), 2) }}</strong>
                                                    </td>
                                                    <td class="text-right">
                                                        <strong>S/ {{ number_format(collect($saldosPorEmpresa)->sum('total_pagos'), 2) }}</strong>
                                                    </td>
                                                    <td class="text-center">
                                                        <strong>{{ collect($saldosPorEmpresa)->sum(function($datos) { return $datos['movimientos']->count(); }) }}</strong>
                                                    </td>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            @foreach($saldosPorEmpresa as $empresa => $datos)
                                <div class="card mb-4">
                                    <div class="card-header bg-primary text-white">
                                        <h5 class="mb-0">
                                            <i class="fas fa-building mr-2"></i>{{ $empresa }}
                                        </h5>
                                    </div>
                                    <div class="card-body">
                                        <!-- Resumen de la empresa -->
                                        <div class="row mb-3">
                                            <div class="col-md-3">
                                                <div class="info-box bg-info">
                                                    <span class="info-box-icon"><i class="fas fa-shopping-cart"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text">Total Comprado</span>
                                                        <span class="info-box-number">S/ {{ number_format($datos['total_compras'], 2) }}</span>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="info-box bg-success">
                                                    <span class="info-box-icon"><i class="fas fa-money-bill-wave"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text">Total Pagado</span>
                                                        <span class="info-box-number">S/ {{ number_format($datos['total_pagos'], 2) }}</span>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="info-box {{ $datos['saldo_final'] >= 0 ? 'bg-warning' : 'bg-danger' }}">
                                                    <span class="info-box-icon"><i class="fas fa-balance-scale"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text">Saldo Final</span>
                                                        <span class="info-box-number">S/ {{ number_format($datos['saldo_final'], 2) }}</span>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="info-box bg-secondary">
                                                    <span class="info-box-icon"><i class="fas fa-list"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text">Movimientos</span>
                                                        <span class="info-box-number">{{ $datos['movimientos']->count() }}</span>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                        <!-- Tabla de movimientos de la empresa -->
                                        <div class="table-responsive">
                                            <table class="table table-striped table-sm">
                                                <thead class="bg-light">
                                                    <tr>
                                                        <th>Fecha</th>
                                                        <th>Tipo</th>
                                                        <th>Descripción</th>
                                                        <th class="text-right">Monto</th>
                                                        <th class="text-right">Saldo Anterior</th>
                                                        <th class="text-right">Saldo Nuevo</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach($datos['movimientos'] as $mov)
                                                        <tr>
                                                            <td>{{ $mov->fecha_movimiento->format('d/m/Y') }}</td>
                                                            <td>
                                                                @php
                                                                    $badges = [
                                                                        'compra' => 'badge-primary',
                                                                        'pago' => 'badge-success',
                                                                        'nota_credito' => 'badge-info',
                                                                        'nota_debito' => 'badge-warning',
                                                                        'ajuste' => 'badge-secondary',
                                                                        'anulacion_compra' => 'badge-danger'
                                                                    ];
                                                                @endphp
                                                                <span class="badge {{ $badges[$mov->tipo_movimiento] ?? 'badge-secondary' }}">
                                                                    {{ strtoupper($mov->tipo_movimiento) }}
                                                                </span>
                                                            </td>
                                                            <td>{{ $mov->descripcion }}</td>
                                                            <td class="text-right">
                                                                <span class="{{ $mov->tipo_movimiento == 'pago' ? 'text-success' : 'text-primary' }}">
                                                                    {{ $mov->tipo_movimiento == 'pago' ? '-' : '+' }} S/ {{ number_format($mov->monto, 2) }}
                                                                </span>
                                                            </td>
                                                            <td class="text-right">S/ {{ number_format($mov->saldo_anterior, 2) }}</td>
                                                            <td class="text-right">
                                                                <strong class="{{ $mov->saldo_nuevo >= 0 ? 'text-success' : 'text-danger' }}">
                                                                    S/ {{ number_format($mov->saldo_nuevo, 2) }}
                                                                </strong>
                                                            </td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            @endforeach
                        @else
                            <div class="alert alert-info">
                                <i class="fas fa-info-circle mr-2"></i>No hay movimientos registrados para este proveedor.
                            </div>
                        @endif
                    </div>
                    @endif
                    @endif
                </div>
            </div>
        </div>
    @endif
@stop

@section('js')
<script>
    $(document).ready(function() {
        @if(isset($movimientos))
            $('#movimientosTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                order: [[0, 'desc']],
                pageLength: 25
            });

            $('#comprasTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                order: [[1, 'desc']],
                pageLength: 25
            });

            $('#pagosTable').DataTable({
                language: {
                    url: '{{ asset('Spanish.json') }}'
                },
                responsive: true,
                order: [[1, 'desc']],
                pageLength: 25
            });
        @else
        <!-- VISTA RESUMIDA -->
        <div class="card">
            <div class="card-header bg-success text-white">
                <h5 class="mb-0">
                    <i class="fas fa-chart-pie mr-2"></i>Resumen por Empresa Compradora
                </h5>
            </div>
            <div class="card-body">
                @if(isset($saldosPorEmpresa) && count($saldosPorEmpresa) > 0)
                    <div class="table-responsive">
                        <table class="table table-striped table-hover">
                            <thead class="bg-light">
                                <tr>
                                    <th class="text-center">#</th>
                                    <th>Empresa Compradora</th>
                                    <th class="text-right">Saldo Actual</th>
                                    <th class="text-center">Estado</th>
                                    <th class="text-right">Total Comprado</th>
                                    <th class="text-right">Total Pagado</th>
                                    <th class="text-center">Movimientos</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($saldosPorEmpresa as $empresaNombre => $datos)
                                    <tr>
                                        <td class="text-center">{{ $loop->iteration }}</td>
                                        <td>
                                            <strong>{{ $datos['empresa'] ?? 'Movimientos Generales' }}</strong>
                                            @if(!isset($datos['empresa']))
                                                <br><small class="text-muted">(Ajustes, saldos iniciales y otros)</small>
                                            @endif
                                        </td>
                                        <td class="text-right">
                                            @if($datos['saldo_final'] > 0)
                                                <span class="text-danger font-weight-bold">
                                                    S/ {{ number_format($datos['saldo_final'], 2) }}
                                                </span>
                                            @elseif($datos['saldo_final'] < 0)
                                                <span class="text-success font-weight-bold">
                                                    S/ {{ number_format(abs($datos['saldo_final']), 2) }}
                                                </span>
                                            @else
                                                <span class="text-muted font-weight-bold">
                                                    S/ 0.00
                                                </span>
                                            @endif
                                        </td>
                                        <td class="text-center">
                                            @if($datos['saldo_final'] > 0)
                                                <span class="badge badge-danger">
                                                    <i class="fas fa-exclamation-triangle mr-1"></i>Pendiente
                                                </span>
                                            @elseif($datos['saldo_final'] < 0)
                                                <span class="badge badge-success">
                                                    <i class="fas fa-check-circle mr-1"></i>A Favor
                                                </span>
                                            @else
                                                <span class="badge badge-info">
                                                    <i class="fas fa-balance-scale mr-1"></i>Al Día
                                                </span>
                                            @endif
                                        </td>
                                        <td class="text-right">
                                            <span class="text-primary">
                                                S/ {{ number_format($datos['total_compras'], 2) }}
                                            </span>
                                        </td>
                                        <td class="text-right">
                                            <span class="text-success">
                                                S/ {{ number_format($datos['total_pagos'], 2) }}
                                            </span>
                                        </td>
                                        <td class="text-center">
                                            <span class="badge badge-secondary">
                                                {{ $datos['movimientos']->count() }}
                                            </span>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot class="bg-light font-weight-bold">
                                <tr>
                                    <td colspan="2" class="text-right"><strong>TOTALES:</strong></td>
                                    <td class="text-right">
                                        @php
                                            $saldoTotal = collect($saldosPorEmpresa)->sum('saldo_final');
                                        @endphp
                                        @if($saldoTotal > 0)
                                            <span class="text-danger">
                                                S/ {{ number_format($saldoTotal, 2) }}
                                            </span>
                                        @elseif($saldoTotal < 0)
                                            <span class="text-success">
                                                S/ {{ number_format(abs($saldoTotal), 2) }}
                                            </span>
                                        @else
                                            <span class="text-muted">
                                                S/ 0.00
                                            </span>
                                        @endif
                                    </td>
                                    <td class="text-center">
                                        @if($saldoTotal > 0)
                                            <span class="badge badge-danger">Pendiente</span>
                                        @elseif($saldoTotal < 0)
                                            <span class="badge badge-success">A Favor</span>
                                        @else
                                            <span class="badge badge-info">Al Día</span>
                                        @endif
                                    </td>
                                    <td class="text-right">
                                        <strong>S/ {{ number_format(collect($saldosPorEmpresa)->sum('total_compras'), 2) }}</strong>
                                    </td>
                                    <td class="text-right">
                                        <strong>S/ {{ number_format(collect($saldosPorEmpresa)->sum('total_pagos'), 2) }}</strong>
                                    </td>
                                    <td class="text-center">
                                        <strong>{{ collect($saldosPorEmpresa)->sum(function($datos) { return $datos['movimientos']->count(); }) }}</strong>
                                    </td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                @else
                    <div class="alert alert-info text-center">
                        <i class="fas fa-info-circle mr-2"></i>No hay datos para mostrar
                    </div>
                @endif
            </div>
        </div>
        @endif
    });
</script>
@stop