@extends('admin.layout.master')

@section('content')

<main>
    <!-- Welcome Area -->
    <div class="welcome-area">
        <div class="row m-0 align-items-center">
            <div class="col-lg-5 col-md-12 p-0">
                <div class="welcome-content">
                    <h1 class="mb-2">Bienvenido {{ Auth::user()->nombre }}¡¡ Ahora tienes el control de Turioni.com¡</h1>
                </div>
            </div>

            <div class="col-lg-7 col-md-12 p-0">
                <div class="welcome-img">
                    <img src="{{ asset('assets/img/Banner_Admin.png') }}" alt="image">
                </div>
            </div>
        </div>
    </div>
    <!-- End Welcome Area -->

    <!-- Stats Area -->
    <div class="ecommerce-stats-area">
        <div class="row">
            <div class="col-lg-4 col-sm-6 col-md-6">
                <div class="single-stats-card-box">
                    <div class="icon">
                        <i class='bx bxs-user-check'></i>
                    </div>
                    <span class="sub-title">Usuarios registrados</span>
                    <h3>{{ $cantidadUsuarios }}<span class="badge"><i class='bx bx-up-arrow-alt'></i> Vigentes</span></h3>
                </div>
            </div>

            <div class="col-lg-4 col-sm-6 col-md-6">
                <div class="single-stats-card-box">
                    <div class="icon">
                        <i class='bx bxs-badge-dollar'></i>
                    </div>
                    <span class="sub-title">Usuarios con compras</span>
                    <h3>{{$usuariosCompras}}<span class="badge"><i class='bx bx-up-arrow-alt'></i> Historial</span></h3>
                </div>
            </div>

            <div class="col-lg-4 col-sm-6 col-md-6">
                <div class="single-stats-card-box">
                    <div class="icon">
                        <i class='bx bx-purchase-tag'></i>
                    </div>
                    <span class="sub-title">Cursos registrados</span>
                    <h3>{{$cursosRegistrados}} <span class="badge"><i class='bx bx-up-arrow-alt'></i> Vigentes</span></h3>
                </div>
            </div>

        </div>
    </div>
    <div class="row">
        <div class="col-lg-6 col-md-12">
            <div class="card most-viewed-publications mb-30">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3>Top 5 Publicaciones Más Vistas</h3>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>Publicación</th>
                                    <th>Vistas Totales</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach ($publicacionesMasVistas as $publicacion)
                                <tr>
                                    <td>{{ $publicacion->nombre ?? 'Publicación no especificada' }}</td>
                                    <td>{{ $publicacion->vistas_count }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-lg-6 col-md-12">
            <div class="card most-viewed-sessions mb-30">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3>Top 5 Sesiones Más Vistas</h3>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>Sesión</th>
                                    <th>Vistas Totales</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach ($sesionesMasVistas as $sesion)
                                <tr>
                                    <td>{{ $sesion->nombre ?? 'Sesión no especificada' }}</td>
                                    <td>{{ $sesion->vistas_count }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

    </div>
    <div class="row">
        <div class="col-lg-12 col-md-12">
            <div class="card recent-users-box mb-30">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3>Últimos 5 Usuarios Registrados</h3>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>Nombre Completo</th>
                                    <th>Email</th>
                                    <th>Fecha de Registro</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach ($ultimosUsuarios as $usuario)
                                <tr>
                                    <td>{{ $usuario->nombreCompleto }}</td>
                                    <td>{{ $usuario->email }}</td>
                                    <td>{{ $usuario->created_at->format('d-m-Y') }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12 col-md-12">
            <div class="card browser-statistics-box mb-30">
                <div class="card-header">
                    <h3>Los 6 cursos más comprados</h3>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>Curso</th>
                                    <th>Compras Totales</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach ($cursosMasComprados as $curso)
                                <tr>
                                    <td>{{ $curso->nombre ?? 'Curso no especificado' }}</td>
                                    <td>{{ $curso->pagos_count }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12 col-md-12">
            <div class="card recent-orders-box mb-30">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3>Ultimas 6 Compras</h3>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table">
                            <thead>
                                <tr>
                                    <th>Usuario</th>
                                    <th>Curso</th>
                                    <th>Activaci&oacute;n</th>
                                    <th>Precio</th>
                                </tr>
                            </thead>

                            <tbody>
                                @foreach ($ultimasCompras as $compra)
                                <tr>
                                    <td class="name">
                                        {{ $compra->user->nombre}} {{ $compra->user->apellido_paterno}} {{ $compra->user->apellido_materno}}
                                    </td>
                                    <td>{{ $compra->publicacion->nombre ?? 'Curso no especificado'}}</td>
                                    <td>{{ $compra->created_at->format('d-m-Y') }}</td>
                                    <td>S/. {{ number_format($compra->monto, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- End -->
</main>

@endsection