<?php
// modules/auxiliar/dashboard.php
require_once '../../includes/auth.php';
require_once __DIR__ . '/../../includes/database.php';
requireRole('auxiliar');

// Obtener datos del usuario desde la sesión
$nombreColegio = APP_NAME;
$usuarioNombre = $_SESSION['user_name'] ?? 'Auxiliar';
$usuarioId = $_SESSION['user_id'] ?? 0;
$usuarioRol = 'Auxiliar';

// Obtener estadísticas para el dashboard
global $db;
$asistenciasTomadas = $db->fetchOne("SELECT COUNT(*) AS total FROM asistencias_estudiantes")['total'] ?? 0;
$correosEnviados = $db->fetchOne("SELECT COUNT(*) AS total FROM correos_enviados")['total'] ?? 0;

// Obtener notificaciones no leídas
$notificaciones = $db->fetchAll("
    SELECT * 
    FROM notificaciones 
    WHERE usuario_id = ? AND leida = 0
    ORDER BY fecha_envio DESC
    LIMIT 5
", [$usuarioId]);

$notificacionesNoLeidas = count($notificaciones);

// Configurar título de página
$pageTitle = "Panel de Auxiliar";
?>

<!DOCTYPE html>
<html lang="es">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?= $pageTitle ?> - <?= $nombreColegio ?></title>

    <!-- Cargar Font Awesome desde CDN -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">

    <!-- Cargar Bootstrap CSS local -->
    <link href="<?= APP_URL ?>/assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Estilos personalizados -->
    <style>
        :root {
            --primary: #2c3e50;
            --secondary: #3498db;
            --accent: #e74c3c;
            --light: #ecf0f1;
            --dark: #34495e;
            --success: #2ecc71;
            --warning: #f39c12;
            --sidebar-width: 280px;
            --header-height: 70px;
        }

        body {
            background-color: #f5f7fa;
            color: #333;
            display: flex;
            min-height: 100vh;
            margin: 0;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
        }

        /* Sidebar */
        .sidebar {
            width: var(--sidebar-width);
            background: linear-gradient(to bottom, var(--primary), var(--dark));
            color: white;
            height: 100vh;
            position: fixed;
            overflow-y: auto;
            transition: all 0.3s ease;
            box-shadow: 3px 0 15px rgba(0, 0, 0, 0.1);
            z-index: 100;
        }

        .logo-container {
            padding: 20px 25px;
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
            background-color: rgba(0, 0, 0, 0.1);
        }

        .logo {
            display: flex;
            align-items: center;
            gap: 12px;
        }

        .logo i {
            font-size: 28px;
            color: var(--secondary);
        }

        .logo h1 {
            font-size: 22px;
            font-weight: 600;
        }

        .menu-section {
            padding: 25px 0;
        }

        .menu-title {
            padding: 0 25px 10px;
            font-size: 14px;
            text-transform: uppercase;
            letter-spacing: 1px;
            color: rgba(255, 255, 255, 0.6);
            font-weight: 500;
        }

        .menu-items {
            list-style: none;
            padding: 0;
            margin: 0;
        }

        .menu-item {
            padding: 12px 25px;
            display: flex;
            align-items: center;
            gap: 15px;
            cursor: pointer;
            transition: all 0.2s ease;
            border-left: 4px solid transparent;
            position: relative;
        }

        .menu-item:hover {
            background-color: rgba(255, 255, 255, 0.05);
            border-left-color: var(--secondary);
        }

        .menu-item.active {
            background-color: rgba(255, 255, 255, 0.1);
            border-left-color: var(--secondary);
        }

        .menu-item i {
            width: 24px;
            text-align: center;
            font-size: 18px;
            color: var(--secondary);
        }

        .menu-item span {
            font-size: 16px;
            font-weight: 500;
        }

        /* Main Content */
        .main-content {
            flex: 1;
            margin-left: var(--sidebar-width);
            padding-bottom: 30px;
        }

        /* Header */
        .header {
            height: var(--header-height);
            background-color: white;
            display: flex;
            align-items: center;
            justify-content: space-between;
            padding: 0 30px;
            box-shadow: 0 2px 10px rgba(0, 0, 0, 0.05);
            position: sticky;
            top: 0;
            z-index: 90;
        }

        .header-left {
            display: flex;
            align-items: center;
            gap: 15px;
        }

        .toggle-menu {
            display: none;
            font-size: 24px;
            cursor: pointer;
            color: var(--dark);
        }

        .search-bar {
            position: relative;
        }

        .search-bar input {
            padding: 10px 15px 10px 40px;
            border-radius: 30px;
            border: 1px solid #ddd;
            width: 300px;
            transition: all 0.3s ease;
        }

        .search-bar input:focus {
            outline: none;
            border-color: var(--secondary);
            box-shadow: 0 0 0 3px rgba(52, 152, 219, 0.2);
        }

        .search-bar i {
            position: absolute;
            left: 15px;
            top: 50%;
            transform: translateY(-50%);
            color: #95a5a6;
        }

        .header-right {
            display: flex;
            align-items: center;
            gap: 25px;
        }

        .user-profile {
            position: relative;
            cursor: pointer;
        }

        .user-info {
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .user-avatar {
            width: 40px;
            height: 40px;
            border-radius: 50%;
            background: linear-gradient(135deg, var(--secondary), var(--primary));
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-weight: bold;
            font-size: 18px;
        }

        .user-details {
            display: flex;
            flex-direction: column;
        }

        .user-name {
            font-weight: 600;
            font-size: 15px;
        }

        .user-role {
            font-size: 13px;
            color: #7f8c8d;
        }

        /* Content Area */
        .content {
            padding: 30px;
        }

        .welcome-section {
            background: linear-gradient(135deg, var(--secondary), var(--primary));
            border-radius: 15px;
            padding: 30px;
            color: white;
            margin-bottom: 30px;
            box-shadow: 0 10px 20px rgba(52, 152, 219, 0.2);
        }

        .welcome-section h1 {
            font-size: 28px;
            margin-bottom: 10px;
            font-weight: 600;
        }

        .welcome-section p {
            font-size: 16px;
            max-width: 700px;
            opacity: 0.9;
            line-height: 1.6;
        }

        .stats-container {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(240px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }

        .stat-card {
            background-color: white;
            border-radius: 12px;
            padding: 25px;
            box-shadow: 0 5px 15px rgba(0, 0, 0, 0.05);
            display: flex;
            align-items: center;
            gap: 20px;
            transition: transform 0.3s ease;
        }

        .stat-card:hover {
            transform: translateY(-5px);
        }

        .stat-icon {
            width: 60px;
            height: 60px;
            border-radius: 15px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 28px;
        }

        .stat-1 {
            background-color: rgba(231, 76, 60, 0.15);
            color: var(--accent);
        }

        .stat-2 {
            background-color: rgba(46, 204, 113, 0.15);
            color: var(--success);
        }

        .stat-3 {
            background-color: rgba(52, 152, 219, 0.15);
            color: var(--secondary);
        }

        .stat-4 {
            background-color: rgba(155, 89, 182, 0.15);
            color: #9b59b6;
        }

        .stat-info h3 {
            font-size: 24px;
            margin-bottom: 5px;
        }

        .stat-info p {
            color: #7f8c8d;
            font-size: 15px;
        }

        .section-title {
            font-size: 22px;
            margin: 30px 0 20px;
            color: var(--dark);
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .section-title i {
            color: var(--secondary);
        }

        .quick-actions {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }

        .action-card {
            background-color: white;
            border-radius: 12px;
            padding: 20px;
            text-align: center;
            box-shadow: 0 5px 15px rgba(0, 0, 0, 0.05);
            transition: all 0.3s ease;
            cursor: pointer;
        }

        .action-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 8px 20px rgba(0, 0, 0, 0.1);
            background-color: var(--secondary);
            color: white;
        }

        .action-card:hover i,
        .action-card:hover p {
            color: white;
        }

        .action-card i {
            font-size: 36px;
            margin-bottom: 15px;
            color: var(--secondary);
        }

        .action-card p {
            font-weight: 500;
            color: var(--dark);
        }

        /* Footer */
        .footer {
            padding: 20px 30px;
            text-align: center;
            color: #7f8c8d;
            font-size: 14px;
            border-top: 1px solid #eee;
            margin-top: 30px;
        }

        /* Responsive Design */
        @media (max-width: 992px) {
            .sidebar {
                transform: translateX(-100%);
            }

            .sidebar.active {
                transform: translateX(0);
            }

            .main-content {
                margin-left: 0;
            }

            .toggle-menu {
                display: block;
            }

            .search-bar input {
                width: 200px;
            }
        }

        @media (max-width: 768px) {
            .search-bar {
                display: none;
            }

            .stats-container {
                grid-template-columns: 1fr;
            }

            .welcome-section h1 {
                font-size: 24px;
            }

            .welcome-section p {
                font-size: 14px;
            }
        }

        /* ---------------------- */
        /* NOTIFICACIONES (NUEVO) */
        /* ---------------------- */
        .notification-container {
            position: relative;
        }

        .notification-trigger {
            position: relative;
            cursor: pointer;
        }

        .notification-trigger i {
            font-size: 20px;
            color: var(--dark);
        }

        .notification-badge {
            position: absolute;
            top: -5px;
            right: -5px;
            background-color: var(--accent);
            color: white;
            border-radius: 50%;
            width: 20px;
            height: 20px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 12px;
            font-weight: bold;
        }

        .notification-dropdown {
            position: absolute;
            top: 40px;
            right: 0;
            width: 400px;
            background: white;
            border-radius: 12px;
            box-shadow: 0 10px 30px rgba(0, 0, 0, 0.15);
            z-index: 1000;
            display: none;
            overflow: hidden;
            transform: translateY(10px);
            opacity: 0;
            transition: transform 0.3s ease, opacity 0.3s ease;
        }

        .notification-container.active .notification-dropdown {
            display: block;
            transform: translateY(0);
            opacity: 1;
        }

        .notification-header {
            padding: 15px 20px;
            border-bottom: 1px solid #eee;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .notification-header h4 {
            margin: 0;
            font-size: 16px;
        }

        .notification-header small {
            color: var(--secondary);
            cursor: pointer;
            font-weight: 500;
        }

        .notification-list {
            max-height: 400px;
            overflow-y: auto;
        }

        .notification-item {
            padding: 15px 20px;
            border-bottom: 1px solid #f8f9fa;
            display: flex;
            gap: 15px;
            cursor: pointer;
            transition: background 0.2s;
        }

        .notification-item:hover {
            background-color: #f8f9fa;
        }

        .notification-icon {
            width: 40px;
            height: 40px;
            border-radius: 50%;
            background: rgba(52, 152, 219, 0.1);
            display: flex;
            align-items: center;
            justify-content: center;
            color: var(--secondary);
            flex-shrink: 0;
        }

        .notification-content {
            flex: 1;
        }

        .notification-title {
            display: flex;
            justify-content: space-between;
            margin-bottom: 5px;
        }

        .notification-title strong {
            font-weight: 600;
            color: var(--dark);
        }

        .notification-title small {
            color: #95a5a6;
            font-size: 12px;
        }

        .notification-message {
            color: #7f8c8d;
            font-size: 14px;
            line-height: 1.4;
            margin-bottom: 10px;
        }

        .notification-actions {
            display: flex;
            gap: 10px;
        }

        .notification-actions a {
            padding: 5px 12px;
            background: rgba(52, 152, 219, 0.1);
            border-radius: 20px;
            color: var(--secondary);
            font-size: 13px;
            font-weight: 500;
            text-decoration: none;
            display: flex;
            align-items: center;
            gap: 5px;
        }

        .notification-actions a:hover {
            background: rgba(52, 152, 219, 0.2);
        }

        .notification-empty {
            padding: 30px 20px;
            text-align: center;
            color: #95a5a6;
        }

        .notification-empty i {
            font-size: 36px;
            margin-bottom: 10px;
        }

        .notification-footer {
            padding: 12px 20px;
            text-align: center;
            border-top: 1px solid #eee;
            background: #f8f9fa;
        }

        .notification-footer a {
            color: var(--secondary);
            text-decoration: none;
            font-size: 14px;
            font-weight: 500;
        }
    </style>
</head>

<body>
    <!-- Sidebar Menu -->
    <div class="sidebar">
        <div class="logo-container">
            <div class="logo">
                <i class="fas fa-graduation-cap"></i>
                <h1><?= $nombreColegio ?></h1>
            </div>
        </div>

        <div class="menu-section">
            <h3 class="menu-title">Principal</h3>
            <ul class="menu-items">
                <li class="menu-item active">
                    <i class="fas fa-home"></i>
                    <span>Menu</span>
                </li>
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/notificaciones.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-inbox"></i>
                        <span>Buzón de Mensajería</span>
                    </a>
                </li>
            </ul>
        </div>

        <div class="menu-section">
            <h3 class="menu-title">Funciones</h3>
            <ul class="menu-items">
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/asistencia.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-clipboard-check"></i>
                        <span>Tomar Asistencia</span>
                    </a>
                </li>
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/lista_alumnos.php?action=new" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-newspaper"></i>
                        <span>Lista de Alumnos</span>
                    </a>
                </li>
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/correos.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-envelope"></i>
                        <span>Enviar Comunicados</span>
                    </a>
                </li>
                <!-- Nuevo ítem para Historial de Correos -->
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/historial_de_correos.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-history"></i>
                        <span>Historial de Comunicados</span>
                    </a>
                </li>
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/correo_administrativo.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-users"></i>
                        <span>Correo Administrativo</span>
                    </a>
                </li>
            </ul>
        </div>
<div class="menu-section">
    <h3 class="menu-title">Recursos</h3>
    <ul class="menu-items">
        <li class="menu-item">
            <a href="<?= APP_URL ?>/modules/auxiliar/videos_tutoriales.php" style="color: inherit; text-decoration: none;">
                <i class="fas fa-video"></i>
                <span>Videos Tutoriales</span>
            </a>
        </li>
    </ul>
</div>
        <div class="menu-section">
            <h3 class="menu-title">Administración</h3>
            <ul class="menu-items">
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/modules/auxiliar/cambiar_contrasena.php" style="display: block; color: inherit; text-decoration: none;">
                        <i class="fas fa-key"></i>
                        <span>Cambiar Contraseña</span>
                    </a>
                </li>
                <li class="menu-item">
                    <a href="<?= APP_URL ?>/auth/logout.php" style="color: inherit; text-decoration: none;">
                        <i class="fas fa-sign-out-alt"></i>
                        <span>Cerrar Sesión</span>
                    </a>
                </li>
            </ul>
        </div>
    </div>

    <!-- Main Content -->
    <div class="main-content">
        <!-- Header -->
        <header class="header">
            <div class="header-left">
                <div class="toggle-menu">
                    <i class="fas fa-bars"></i>
                </div>

            </div>

            <div class="header-right">
                <!-- Sistema de notificaciones (nuevo) -->
                <div class="notification-container" id="notificationContainer">
                    <div class="notification-trigger" id="notificationTrigger">
                        <i class="fas fa-bell"></i>
                        <?php if ($notificacionesNoLeidas > 0): ?>
                            <div class="notification-badge"><?= $notificacionesNoLeidas ?></div>
                        <?php endif; ?>
                    </div>

                    <div class="notification-dropdown">
                        <div class="notification-list">
                            <?php if ($notificacionesNoLeidas > 0): ?>
                                <?php foreach ($notificaciones as $notif): ?>
                                    <div class="notification-item" data-id="<?= $notif['id'] ?>">
                                        <div class="notification-icon">
                                            <i class="fas fa-envelope"></i>
                                        </div>
                                        <div class="notification-content">
                                            <div class="notification-title">
                                                <strong><?= htmlspecialchars($notif['titulo']) ?></strong>
                                                <small><?= date('d M H:i', strtotime($notif['fecha_envio'])) ?></small>
                                            </div>
                                            <div class="notification-message">
                                                <?= htmlspecialchars($notif['mensaje']) ?>
                                            </div>
                                            <div class="notification-actions">
                                                <a href="<?= APP_URL ?>/modules/auxiliar/ver_correo.php?id=<?= $notif['id'] ?>" class="btn-view">
                                                    <i class="fas fa-eye"></i> Ver
                                                </a>
                                            </div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            <?php else: ?>
                                <div class="notification-empty">
                                    <i class="fas fa-inbox"></i>
                                    <p>No tienes notificaciones nuevas</p>
                                </div>
                            <?php endif; ?>
                        </div>
                        <div class="notification-footer">
                            <a href="notificaciones.php">Ver todas las notificaciones</a>
                        </div>
                    </div>
                </div>

                <div class="user-profile">
                    <div class="user-info">
                        <div class="user-avatar"><?= substr($usuarioNombre, 0, 1) . substr($usuarioNombre, strpos($usuarioNombre, ' ') + 1, 1) ?></div>
                        <div class="user-details">
                            <div class="user-name"><?= $usuarioNombre ?></div>
                            <div class="user-role"><?= $usuarioRol ?></div>
                        </div>
                    </div>
                </div>
            </div>
        </header>

        <!-- Content Area -->
        <div class="content">
            <div class="welcome-section">
                <h1>Bienvenido al Panel de Auxiliar</h1>
                <p>Desde aquí podrás tomar asistencias y enviar correos a la comunidad educativa.</p>
            </div>

            <div class="stats-container">
                <div class="stat-card">
                    <div class="stat-icon stat-1">
                        <i class="fas fa-clipboard-check"></i>
                    </div>
                    <div class="stat-info">
                        <h3><?= $asistenciasTomadas ?></h3>
                        <p>Asistencias Tomadas</p>
                    </div>
                </div>

                <div class="stat-card">
                    <div class="stat-icon stat-3">
                        <i class="fas fa-envelope"></i>
                    </div>
                    <div class="stat-info">
                        <h3><?= $correosEnviados ?></h3>
                        <p>Comunicados Enviados</p>
                    </div>
                </div>
            </div>

            <h2 class="section-title"><i class="fas fa-bolt"></i> Acciones Rápidas</h2>
            <div class="quick-actions">
                <a href="<?= APP_URL ?>/modules/auxiliar/asistencia.php" style="text-decoration: none; color: inherit;">
                    <div class="action-card">
                        <i class="fas fa-clipboard-check"></i>
                        <p>Tomar Asistencia</p>
                    </div>
                </a>

                <a href="<?= APP_URL ?>/modules/auxiliar/lista_alumnos.php?action=new" style="text-decoration: none; color: inherit;">
                    <div class="action-card">
                        <i class="fas fa-newspaper"></i>
                        <p>Lista de Alumnos</p>
                    </div>
                </a>

                <a href="<?= APP_URL ?>/modules/auxiliar/correos.php" style="text-decoration: none; color: inherit;">
                    <div class="action-card">
                        <i class="fas fa-envelope"></i>
                        <p>Enviar Comunicados</p>
                    </div>
                </a>
            </div>
        </div>

        <!-- Footer -->
        <footer class="footer">
            <p>Sistema Escolar Integrado v3.0 © <?= date('Y') ?> - Todos los derechos reservados</p>
        </footer>
    </div>

    <script src="<?= APP_URL ?>/assets/js/bootstrap.bundle.min.js"></script>
    <script>
        // Toggle sidebar on mobile
        document.querySelector('.toggle-menu')?.addEventListener('click', function() {
            document.querySelector('.sidebar').classList.toggle('active');
        });

        // Set active menu item
        const menuItems = document.querySelectorAll('.menu-item');
        menuItems.forEach(item => {
            item.addEventListener('click', function() {
                menuItems.forEach(i => i.classList.remove('active'));
                this.classList.add('active');
            });
        });

        // Sistema de notificaciones (nuevo)
        document.addEventListener('DOMContentLoaded', function() {
            const notificationContainer = document.getElementById('notificationContainer');
            const notificationTrigger = document.getElementById('notificationTrigger');
            const notificationDropdown = notificationContainer.querySelector('.notification-dropdown');

            // Abrir/cerrar menú de notificaciones
            notificationTrigger.addEventListener('click', function(e) {
                e.stopPropagation();
                notificationContainer.classList.toggle('active');
            });

            // Cerrar menú al hacer clic fuera
            document.addEventListener('click', function(e) {
                if (!notificationContainer.contains(e.target)) {
                    notificationContainer.classList.remove('active');
                }
            });

            // Prevenir cierre al hacer clic dentro del menú
            notificationDropdown.addEventListener('click', function(e) {
                e.stopPropagation();
            });

            // Marcar notificación como leída
            document.querySelectorAll('.notification-item').forEach(item => {
                item.addEventListener('click', function() {
                    const notifId = this.getAttribute('data-id');

                    // Enviar solicitud AJAX para marcar como leída
                    fetch('marcar_leida.php', {
                            method: 'POST',
                            headers: {
                                'Content-Type': 'application/json'
                            },
                            body: JSON.stringify({
                                id: notifId
                            })
                        }).then(response => response.json())
                        .then(data => {
                            if (data.success) {
                                this.style.opacity = '0.7';
                                // Actualizar contador
                                const badge = document.querySelector('.notification-badge');
                                if (badge) {
                                    badge.textContent = parseInt(badge.textContent) - 1;
                                    if (parseInt(badge.textContent) === 0) {
                                        badge.style.display = 'none';
                                    }
                                }
                            }
                        });
                });
            });

            // Marcar todas como leídas
            document.getElementById('markAllAsRead').addEventListener('click', function(e) {
                e.stopPropagation();

                // Enviar solicitud AJAX para marcar todas como leídas
                fetch('marcar_todas_leidas.php', {
                        method: 'POST',
                        headers: {
                            'Content-Type': 'application/json'
                        },
                        body: JSON.stringify({
                            usuario_id: <?= $usuarioId ?>
                        })
                    }).then(response => response.json())
                    .then(data => {
                        if (data.success) {
                            // Actualizar la interfaz
                            document.querySelectorAll('.notification-item').forEach(item => {
                                item.style.opacity = '0.7';
                            });

                            const badge = document.querySelector('.notification-badge');
                            if (badge) {
                                badge.style.display = 'none';
                            }
                        }
                    });
            });
        });
    </script>
</body>

</html>