File "DiplomaModelo.php"

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

<?php
// Modelos/DiplomaModelo.php

class DiplomaModelo {
    private $db;

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

    /** Obtiene la información necesaria para el diploma */
    public function obtenerDatosCertificado($usuario_id, $curso_id) {
        $query = "
            SELECT 
                u.name AS nombre_estudiante,
                u.cedula,
                c.title AS nombre_curso,
                qr.score AS puntaje,
                qr.completed_at AS fecha_finalizacion
            FROM quiz_results qr
            JOIN users u ON u.id = qr.user_id
            JOIN quizzes q ON q.id = qr.quiz_id
            JOIN courses c ON c.id = q.course_id
            WHERE u.id = ? AND c.id = ? AND qr.score >= 80
            ORDER BY qr.completed_at DESC LIMIT 1";
        
        $stmt = $this->db->prepare($query);
        $stmt->bind_param("ii", $usuario_id, $curso_id);
        $stmt->execute();
        return $stmt->get_result()->fetch_assoc();
    }
}