Proyectos de Subversion Moodle

<?php
defined('MOODLE_INTERNAL') || die();

use core_completion\progress;

// Definición de la clase que extiende plugin_renderer_base
class block_cesa_lastcourse_renderer extends plugin_renderer_base
{
    public function procesar()
    {
        global $USER, $DB, $CFG, $PAGE;

        $userid = $USER->id;
        $url_noimage =  $CFG->wwwroot . '/theme/' . $PAGE->theme->name . '/pix/coursenoimage.jpg';

        $data = ['course' => ''];

        // Consulta SQL optimizada para obtener los cursos recientemente accedidos por el usuario
        $sql  = "SELECT DISTINCT(courseid) AS courseid FROM {logstore_standard_log} WHERE ";
        $sql .= "action = 'viewed' AND target IN ('course', 'course_module') AND userid = :userid ";
        $sql .= "GROUP BY courseid ORDER BY timecreated DESC";

        $lastcourses = $DB->get_records_sql($sql, ['userid' => $userid]);

        // Obtener los cursos visibles
        list($sql_in, $params) = $DB->get_in_or_equal(array_keys($lastcourses), SQL_PARAMS_NAMED);
        $sql = "SELECT id FROM {course} WHERE id $sql_in AND visible = 1";
        $courses = $DB->get_records_sql($sql, $params);
        
        $courseid = key($courses) ?? null;

        if ($courseid) {
            $course = get_course($courseid);
            if ($course instanceof stdClass) {
                $courseInList = new core_course_list_element($course);
            }

            // Obtener la imagen del curso o usar la imagen por defecto
            $image = $url_noimage;
            foreach ($courseInList->get_course_overviewfiles() as $file) {
                if ($file->is_valid_image()) {
                    $image = file_encode_url("{$CFG->wwwroot}/pluginfile.php", "/" . $file->get_contextid() . "/" . $file->get_component() . "/" . $file->get_filearea() . $file->get_filepath() . $file->get_filename());
                    break;
                }
            }

            // Obtener el último acceso al curso por el usuario
            $sql = "SELECT timecreated FROM {logstore_standard_log} WHERE courseid = :courseid AND userid = :userid ";
            $sql .= "AND eventname = '\\core\\event\\course_viewed' ORDER BY id DESC LIMIT 1";
            $timecreated = $DB->get_field_sql($sql, ['courseid' => $course->id, 'userid' => $userid]);
            $lastaccess = $timecreated ? date('d/m/Y h:i a', $timecreated) : null;

            $category = $DB->get_record('course_categories', ['id' => $course->category]);

            // Obtener el progreso del usuario en el curso
            $progress = progress::get_course_progress_percentage($course);
            $progress = $progress ? floatval($progress) : 0.0;
            $miProgreso = number_format($progress, 2);

            // Obtener la primera sección visible del curso
            $first_section = $DB->get_field_sql(
                "SELECT id FROM {course_sections} WHERE course = :course AND section > 0 AND visible = 1 ORDER BY section ASC LIMIT 1",
                ['course' => $course->id]
            );

            // Verificar roles del usuario en el curso
            $course_context = context_course::instance($course->id);
            $roles = get_user_roles($course_context, $USER->id, true);
            $completion_edit_curso = array_reduce($roles, fn($carry, $role) => $carry || in_array($role->shortname, ['companydepartmentmanager', 'companycoursenoneditor']), false);

            // Obtener el primer módulo visible del curso
            $modules = array_filter(
                get_fast_modinfo($course->id)->get_cms(),
                fn($module) => $module->uservisible && !$module->is_stealth() && !empty($module->url)
            );
            $linkurl = reset($modules)?->url ?? $CFG->wwwroot . '/course/view.php?id=' . $course->id;

            // Si el usuario tiene ciertos roles, forzar la URL al curso
            if ($completion_edit_curso) {
                $linkurl = $CFG->wwwroot . '/course/view.php?id=' . $course->id;
            }

            // Obtener un resumen del curso
            $summary = trim(strip_tags($course->summary));
            if (empty($summary)) {
                $summary = '&nbsp';
            } elseif (strlen($summary) > 80) {
                $summary = substr($summary, 0, 80) . '...';
            }

            // Asignar datos del curso al array de respuesta
            $data['course'] = [...];
        }

        // Renderizar la plantilla con los datos del curso
        return $this->render_from_template('block_cesa_lastcourse/full', $data);
    }
}