95 lines
3.8 KiB
PHP
95 lines
3.8 KiB
PHP
<?php
|
|
include 'includes/config.php';
|
|
redirect_if_not_logged_in();
|
|
|
|
$profesor = $_SESSION['profesor'];
|
|
$profesor_id = $profesor['id'];
|
|
|
|
function getCount($pdo, $sql, $params = []) {
|
|
$stmt = $pdo->prepare($sql);
|
|
$stmt->execute($params);
|
|
return $stmt->fetch()['total'] ?? 0;
|
|
}
|
|
|
|
// Estadísticas
|
|
$total_cursos = getCount($pdo, "SELECT COUNT(*) as total FROM cursos WHERE profesor_id = ?", [$profesor_id]);
|
|
$cursos_activos = getCount($pdo, "SELECT COUNT(*) as total FROM cursos WHERE profesor_id = ? AND estado = 'activo'", [$profesor_id]);
|
|
$cursos_inyeccion = getCount($pdo, "SELECT COUNT(*) as total FROM cursos WHERE profesor_id = ? AND tipo = 'inyeccion'", [$profesor_id]);
|
|
$cursos_pildora = getCount($pdo, "SELECT COUNT(*) as total FROM cursos WHERE profesor_id = ? AND tipo = 'pildora'", [$profesor_id]);
|
|
$cursos_tratamiento = getCount($pdo, "SELECT COUNT(*) as total FROM cursos WHERE profesor_id = ? AND tipo = 'tratamiento'", [$profesor_id]);
|
|
$alumnos_registrados = getCount($pdo, "
|
|
SELECT COUNT(DISTINCT a.id) as total
|
|
FROM alumnos a
|
|
JOIN alumnos_cursos ac ON a.id = ac.alumno_id
|
|
JOIN cursos c ON ac.curso_id = c.id
|
|
WHERE c.profesor_id = ?", [$profesor_id]);
|
|
$diplomas_emitidos = getCount($pdo, "
|
|
SELECT COUNT(*) as total
|
|
FROM diplomas d
|
|
JOIN alumnos_cursos ac ON d.alumno_curso_id = ac.id
|
|
JOIN cursos c ON ac.curso_id = c.id
|
|
WHERE c.profesor_id = ?", [$profesor_id]);
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="es">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>DiploMaster - Panel</title>
|
|
<link rel="stylesheet" href="assets/css/styles.css">
|
|
</head>
|
|
<body class="admin">
|
|
<div id="app-content">
|
|
<header>
|
|
<h1>DiploMaster</h1>
|
|
<div id="profesor-info">
|
|
<div id="current-profesor" data-id="<?= $profesor['id'] ?>"></div>
|
|
<span><?= htmlspecialchars($profesor['nombre']) ?></span>
|
|
</div>
|
|
</header>
|
|
|
|
<div class="main-container">
|
|
<div class="sidebar" id="sidebar">
|
|
<ul class="sidebar-menu">
|
|
<li class="active" data-section="dashboard"><span>🏠 Inicio</span></li>
|
|
<li data-section="courses"><span>📚 Gestión de Cursos</span></li>
|
|
<li data-section="students"><span>👨🎓 Gestión de Alumnos</span></li>
|
|
<li data-section="diplomas"><span>🎓 Gestión de Diplomas</span></li>
|
|
<li><a href="api/logout.php" class="logout-link">Cerrar sesión</a></li>
|
|
</ul>
|
|
</div>
|
|
|
|
<div class="content" id="main-content">
|
|
<div id="dashboard-content" class="content-section active">
|
|
<div class="card">
|
|
<h2>Bienvenido <?= htmlspecialchars($profesor['nombre']) ?></h2>
|
|
<p>Este es tu panel de gestión de DiploMaster</p>
|
|
<div class="stats">
|
|
<p><strong>Resumen:</strong></p>
|
|
<p>• Total de cursos: <strong><?= $total_cursos ?></strong></p>
|
|
<p>• Cursos activos: <strong id="active-courses-count"><?= $cursos_activos ?></strong></p>
|
|
<p>• Tipo Inyección: <strong><?= $cursos_inyeccion ?></strong></p>
|
|
<p>• Tipo Píldora: <strong><?= $cursos_pildora ?></strong></p>
|
|
<p>• Tipo Tratamiento: <strong><?= $cursos_tratamiento ?></strong></p>
|
|
<p>• Alumnos registrados: <strong id="students-count"><?= $alumnos_registrados ?></strong></p>
|
|
<p>• Diplomas emitidos: <strong id="diplomas-count"><?= $diplomas_emitidos ?></strong></p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div id="courses-content" class="content-section">
|
|
</div>
|
|
|
|
<div id="students-content" class="content-section">
|
|
</div>
|
|
|
|
<div id="diplomas-content" class="content-section">
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<script src="assets/js/main.js"></script>
|
|
</body>
|
|
</html>
|