@extends('layouts.app')

@section('title', 'Reportes de Contratos')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center mb-4">
                <h1 class="h3 mb-0">
                    <i class="fas fa-chart-bar"></i> Reportes de Contratos
                </h1>
                <div>
                    <button class="btn btn-outline-primary" onclick="exportarPDF()">
                        <i class="fas fa-file-pdf"></i> Exportar PDF
                    </button>
                    <button class="btn btn-outline-success" onclick="exportarExcel()">
                        <i class="fas fa-file-excel"></i> Exportar Excel
                    </button>
                </div>
            </div>

            <!-- Resumen General -->
            <div class="row mb-4">
                <div class="col-md-3">
                    <div class="card bg-primary text-white">
                        <div class="card-body">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <h5 class="card-title">Total Contratos</h5>
                                    <h3 class="mb-0">{{ $totalContratos ?? 0 }}</h3>
                                </div>
                                <div class="align-self-center">
                                    <i class="fas fa-file-contract" style="font-size: 2rem;"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card bg-success text-white">
                        <div class="card-body">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <h5 class="card-title">Contratos Activos</h5>
                                    <h3 class="mb-0">{{ $contratosActivos ?? 0 }}</h3>
                                </div>
                                <div class="align-self-center">
                                    <i class="fas fa-check-circle" style="font-size: 2rem;"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card bg-warning text-white">
                        <div class="card-body">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <h5 class="card-title">En Mora</h5>
                                    <h3 class="mb-0">{{ $contratosEnMora ?? 0 }}</h3>
                                </div>
                                <div class="align-self-center">
                                    <i class="fas fa-exclamation-triangle" style="font-size: 2rem;"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card bg-info text-white">
                        <div class="card-body">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <h5 class="card-title">Ingresos Mensuales</h5>
                                    <h3 class="mb-0">Bs. {{ number_format($ingresosMensuales ?? 0, 2) }}</h3>
                                </div>
                                <div class="align-self-center">
                                    <i class="fas fa-dollar-sign" style="font-size: 2rem;"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Gráficos -->
            <div class="row mb-4">
                <div class="col-lg-6">
                    <div class="card shadow">
                        <div class="card-header">
                            <h5 class="mb-0">Distribución por Estado</h5>
                        </div>
                        <div class="card-body">
                            <canvas id="estadosChart" width="400" height="200"></canvas>
                        </div>
                    </div>
                </div>
                <div class="col-lg-6">
                    <div class="card shadow">
                        <div class="card-header">
                            <h5 class="mb-0">Contratos por Mes</h5>
                        </div>
                        <div class="card-body">
                            <canvas id="contratosChart" width="400" height="200"></canvas>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Filtros -->
            <div class="card shadow mb-4">
                <div class="card-header">
                    <h5 class="mb-0">Filtros de Reporte</h5>
                </div>
                <div class="card-body">
                    <form id="filtrosForm">
                        <div class="row">
                            <div class="col-md-3">
                                <label for="fechaDesde" class="form-label">Fecha Desde</label>
                                <input type="date" class="form-control" id="fechaDesde" name="fecha_desde">
                            </div>
                            <div class="col-md-3">
                                <label for="fechaHasta" class="form-label">Fecha Hasta</label>
                                <input type="date" class="form-control" id="fechaHasta" name="fecha_hasta">
                            </div>
                            <div class="col-md-3">
                                <label for="estado" class="form-label">Estado</label>
                                <select class="form-select" id="estado" name="estado">
                                    <option value="">Todos</option>
                                    <option value="activo">Activo</option>
                                    <option value="suspendido">Suspendido</option>
                                    <option value="terminado">Terminado</option>
                                    <option value="pendiente">Pendiente</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label for="plan" class="form-label">Plan</label>
                                <select class="form-select" id="plan" name="plan_id">
                                    <option value="">Todos</option>
                                    @if(isset($planes))
                                        @foreach($planes as $plan)
                                            <option value="{{ $plan->id }}">{{ $plan->nombre }}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>
                        <div class="row mt-3">
                            <div class="col-12">
                                <button type="button" class="btn btn-primary" onclick="aplicarFiltros()">
                                    <i class="fas fa-filter"></i> Aplicar Filtros
                                </button>
                                <button type="button" class="btn btn-secondary" onclick="limpiarFiltros()">
                                    <i class="fas fa-times"></i> Limpiar
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- Tabla Resumen -->
            <div class="card shadow">
                <div class="card-header">
                    <h5 class="mb-0">Resumen de Contratos por Plan</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-hover">
                            <thead class="table-dark">
                                <tr>
                                    <th>Plan</th>
                                    <th>Velocidad</th>
                                    <th>Precio</th>
                                    <th>Contratos Activos</th>
                                    <th>Ingresos</th>
                                    <th>% del Total</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if(isset($resumenPlanes))
                                    @foreach($resumenPlanes as $resumen)
                                    <tr>
                                        <td><strong>{{ $resumen['plan'] }}</strong></td>
                                        <td>{{ $resumen['velocidad'] }}</td>
                                        <td>Bs. {{ number_format($resumen['precio'], 2) }}</td>
                                        <td>
                                            <span class="badge bg-primary">{{ $resumen['contratos'] }}</span>
                                        </td>
                                        <td>Bs. {{ number_format($resumen['ingresos'], 2) }}</td>
                                        <td>{{ number_format($resumen['porcentaje'], 1) }}%</td>
                                    </tr>
                                    @endforeach
                                @else
                                    <tr>
                                        <td colspan="6" class="text-center text-muted">
                                            No hay datos disponibles
                                        </td>
                                    </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Análisis de Mora -->
            <div class="card shadow mt-4">
                <div class="card-header">
                    <h5 class="mb-0">Análisis de Mora</h5>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-6">
                            <h6>Deuda por Rangos de Días</h6>
                            <div class="table-responsive">
                                <table class="table table-sm">
                                    <thead>
                                        <tr>
                                            <th>Rango</th>
                                            <th>Contratos</th>
                                            <th>Monto Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>1-7 días</td>
                                            <td><span class="badge bg-warning">{{ $mora1_7 ?? 0 }}</span></td>
                                            <td>Bs. {{ number_format($monto1_7 ?? 0, 2) }}</td>
                                        </tr>
                                        <tr>
                                            <td>8-30 días</td>
                                            <td><span class="badge bg-warning">{{ $mora8_30 ?? 0 }}</span></td>
                                            <td>Bs. {{ number_format($monto8_30 ?? 0, 2) }}</td>
                                        </tr>
                                        <tr>
                                            <td>30+ días</td>
                                            <td><span class="badge bg-danger">{{ $mora30_mas ?? 0 }}</span></td>
                                            <td>Bs. {{ number_format($monto30_mas ?? 0, 2) }}</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <h6>Top 5 Clientes con Mayor Deuda</h6>
                            <div class="table-responsive">
                                <table class="table table-sm">
                                    <thead>
                                        <tr>
                                            <th>Cliente</th>
                                            <th>Días Mora</th>
                                            <th>Deuda</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(isset($topDeudores))
                                            @foreach($topDeudores as $deudor)
                                            <tr>
                                                <td>{{ $deudor['cliente'] }}</td>
                                                <td><span class="badge bg-danger">{{ $deudor['dias'] }}</span></td>
                                                <td>Bs. {{ number_format($deudor['deuda'], 2) }}</td>
                                            </tr>
                                            @endforeach
                                        @else
                                            <tr>
                                                <td colspan="3" class="text-center text-muted">Sin deudores</td>
                                            </tr>
                                        @endif
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
// Gráfico de Estados
const estadosCtx = document.getElementById('estadosChart').getContext('2d');
const estadosChart = new Chart(estadosCtx, {
    type: 'doughnut',
    data: {
        labels: ['Activos', 'Suspendidos', 'Terminados', 'Pendientes'],
        datasets: [{
            data: [
                {{ $contratosActivos ?? 0 }},
                {{ $contratosSuspendidos ?? 0 }},
                {{ $contratosTerminados ?? 0 }},
                {{ $contratosPendientes ?? 0 }}
            ],
            backgroundColor: [
                '#28a745',
                '#ffc107',
                '#dc3545',
                '#6c757d'
            ]
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false
    }
});

// Gráfico de Contratos por Mes
const contratosCtx = document.getElementById('contratosChart').getContext('2d');
const contratosChart = new Chart(contratosCtx, {
    type: 'line',
    data: {
        labels: ['Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun', 'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic'],
        datasets: [{
            label: 'Nuevos Contratos',
            data: [12, 19, 3, 5, 2, 3, 7, 8, 12, 15, 10, 8],
            borderColor: '#007bff',
            backgroundColor: 'rgba(0, 123, 255, 0.1)',
            tension: 0.4
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false,
        scales: {
            y: {
                beginAtZero: true
            }
        }
    }
});

function aplicarFiltros() {
    // Implementar lógica de filtros
    alert('Aplicando filtros...');
}

function limpiarFiltros() {
    document.getElementById('filtrosForm').reset();
}

function exportarPDF() {
    alert('Exportando a PDF...');
}

function exportarExcel() {
    alert('Exportando a Excel...');
}
</script>
@endsection