@extends('layouts.app')

@section('title', 'Envejecimiento de Cuentas por Pagar')

@section('content')
<div class="container-fluid">
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <h2 class="mb-0">
                    <i class="fas fa-calendar-alt me-2"></i>Envejecimiento de Cuentas por Pagar
                </h2>
                <div>
                    <a href="{{ route('admin.accounting.dashboard') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left me-2"></i>Volver
                    </a>
                    <a href="{{ route('admin.accounting.reports.aging-payables', array_merge(request()->all(), ['export' => 'excel'])) }}" class="btn btn-success">
                        <i class="fas fa-file-excel me-2"></i>Exportar Excel
                    </a>
                    <button onclick="window.print()" class="btn btn-primary">
                        <i class="fas fa-print me-2"></i>Imprimir
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Filtros -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-filter me-2"></i>Filtros
            </h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('admin.accounting.reports.aging-payables') }}" class="row g-3">
                <div class="col-md-4">
                    <label for="as_of_date" class="form-label">Fecha de Corte</label>
                    <input type="date" name="as_of_date" id="as_of_date" class="form-control" value="{{ $asOfDate ?? now()->format('Y-m-d') }}" required>
                </div>
                <div class="col-md-8 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary me-2">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                    <a href="{{ route('admin.accounting.reports.aging-payables') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Resumen -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-warning text-dark">
            <h5 class="mb-0">
                <i class="fas fa-chart-pie me-2"></i>Resumen de Cuentas por Pagar
            </h5>
        </div>
        <div class="card-body">
            <div class="row text-center">
                <div class="col-md-2">
                    <h4 class="text-warning mb-0">${{ number_format($totals['total_balance'], 2) }}</h4>
                    <p class="text-muted mb-0 small">Total General</p>
                </div>
                <div class="col-md-2">
                    <h4 class="text-success mb-0">${{ number_format($totals['total_current'], 2) }}</h4>
                    <p class="text-muted mb-0 small">Al Día</p>
                </div>
                <div class="col-md-2">
                    <h4 class="text-info mb-0">${{ number_format($totals['total_days_30'], 2) }}</h4>
                    <p class="text-muted mb-0 small">1-30 Días</p>
                </div>
                <div class="col-md-2">
                    <h4 class="text-warning mb-0">${{ number_format($totals['total_days_60'], 2) }}</h4>
                    <p class="text-muted mb-0 small">31-60 Días</p>
                </div>
                <div class="col-md-2">
                    <h4 class="text-danger mb-0">${{ number_format($totals['total_days_90'], 2) }}</h4>
                    <p class="text-muted mb-0 small">61-90 Días</p>
                </div>
                <div class="col-md-2">
                    <h4 class="text-dark mb-0">${{ number_format($totals['total_over_90'], 2) }}</h4>
                    <p class="text-muted mb-0 small">+90 Días</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Envejecimiento -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Detalle de Cuentas por Pagar
                <span class="badge bg-warning ms-2">{{ count($agingReport) }} registros</span>
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover mb-0">
                    <thead class="table-dark">
                        <tr>
                            <th>Proveedor</th>
                            <th>Cuenta #</th>
                            <th>Factura #</th>
                            <th>Fecha Factura</th>
                            <th>Fecha Vencimiento</th>
                            <th class="text-end">Días Vencidos</th>
                            <th class="text-end">Saldo Total</th>
                            <th class="text-end">Al Día</th>
                            <th class="text-end">1-30 Días</th>
                            <th class="text-end">31-60 Días</th>
                            <th class="text-end">61-90 Días</th>
                            <th class="text-end">+90 Días</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($agingReport as $item)
                            <tr class="{{ $item['days_past_due'] > 90 ? 'table-danger' : ($item['days_past_due'] > 60 ? 'table-warning' : '') }}">
                                <td>
                                    <strong>{{ $item['supplier']->business_name ?? 'N/A' }}</strong>
                                    @if($item['supplier']->tax_id)
                                        <br><small class="text-muted">RIF: {{ $item['supplier']->tax_id }}</small>
                                    @endif
                                </td>
                                <td>{{ $item['account_number'] }}</td>
                                <td>{{ $item['invoice_number'] }}</td>
                                <td>{{ $item['invoice_date'] ? \Carbon\Carbon::parse($item['invoice_date'])->format('d/m/Y') : 'N/A' }}</td>
                                <td>{{ $item['due_date'] ? \Carbon\Carbon::parse($item['due_date'])->format('d/m/Y') : 'N/A' }}</td>
                                <td class="text-end">
                                    @if($item['days_past_due'] > 0)
                                        <span class="badge bg-{{ $item['days_past_due'] > 90 ? 'danger' : ($item['days_past_due'] > 60 ? 'warning' : 'info') }}">
                                            {{ number_format($item['days_past_due'], 0) }}
                                        </span>
                                    @else
                                        <span class="badge bg-success">Al día</span>
                                    @endif
                                </td>
                                <td class="text-end">
                                    <strong>${{ number_format($item['balance'], 2) }}</strong>
                                </td>
                                <td class="text-end">{{ $item['current'] > 0 ? '$' . number_format($item['current'], 2) : '-' }}</td>
                                <td class="text-end">{{ $item['days_30'] > 0 ? '$' . number_format($item['days_30'], 2) : '-' }}</td>
                                <td class="text-end">{{ $item['days_60'] > 0 ? '$' . number_format($item['days_60'], 2) : '-' }}</td>
                                <td class="text-end">{{ $item['days_90'] > 0 ? '$' . number_format($item['days_90'], 2) : '-' }}</td>
                                <td class="text-end">{{ $item['over_90'] > 0 ? '$' . number_format($item['over_90'], 2) : '-' }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="12" class="text-center py-4">
                                    <i class="fas fa-check-circle me-2 text-success"></i>
                                    No se encontraron cuentas por pagar pendientes.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($agingReport) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="6" class="text-end">Totales:</th>
                            <th class="text-end">${{ number_format($totals['total_balance'], 2) }}</th>
                            <th class="text-end">${{ number_format($totals['total_current'], 2) }}</th>
                            <th class="text-end">${{ number_format($totals['total_days_30'], 2) }}</th>
                            <th class="text-end">${{ number_format($totals['total_days_60'], 2) }}</th>
                            <th class="text-end">${{ number_format($totals['total_days_90'], 2) }}</th>
                            <th class="text-end">${{ number_format($totals['total_over_90'], 2) }}</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
</div>

<style>
    @media print {
        .btn, .card-header, .navbar, .sidebar {
            display: none !important;
        }
        .card {
            border: none !important;
            box-shadow: none !important;
        }
    }
</style>
@endsection