File "EstudianteModelo.php"

Full Path: C:/wamp64/www/Formaciones/Modelos/EstudianteModelo.php
File size: 1.01 KB
MIME-type: text/x-php
Charset: utf-8

<?php
// Modelos/EstudianteModelo.php

class EstudianteModelo {
    private $db;

    public function __construct($db) {
        $this->db = $db;
    }

    /** Obtiene todos los cursos asignados al estudiante con su mejor puntaje */
    public function obtenerMisCursos($usuario_id) {
        $query = "
            SELECT 
                c.id AS curso_id,
                c.title AS titulo_curso,
                c.description,
                ca.assigned_at,
                (SELECT MAX(score) FROM quiz_results qr 
                 JOIN quizzes q ON q.id = qr.quiz_id 
                 WHERE q.course_id = c.id AND qr.user_id = ?) AS mejor_puntaje
            FROM course_assignments ca
            JOIN courses c ON c.id = ca.course_id
            WHERE ca.user_id = ?
            ORDER BY ca.assigned_at DESC";
        
        $stmt = $this->db->prepare($query);
        $stmt->bind_param("ii", $usuario_id, $usuario_id);
        $stmt->execute();
        return $stmt->get_result();
    }
}