Proyectos de Subversion Moodle

<?php

defined('MOODLE_INTERNAL') || die();

use core_completion\progress;

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' => ''

        ];

        $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  ";

        $courseid =  null;

        $lastcourses = $DB->get_records_sql($sql);

        foreach ($lastcourses as $lastcourse) {

            //$course = get_course($lastcourse->courseid);

            $course =  $DB->get_record('course', array('id' => $lastcourse->courseid));

            if (!$course || !$course->visible) {

                continue;

            }

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

            if (!$category || !$category->visible) {

                continue;

            }

            $courseid = $course->id;

        }

        if ($courseid) {

            $course = get_course($courseid);

            if ($course instanceof stdClass) {

                $courseInList = new core_course_list_element($course);

            }

            $image = $url_noimage;

            foreach ($courseInList->get_course_overviewfiles() as $file) {

                $isimage = $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(), !$isimage);

                if (!$isimage) {

                    $image = $url_noimage;

                }

            }

            $lastaccess = null;

            $sql = "select timecreated  from {logstore_standard_log} where courseid  = :courseid and userid  = :userid " .

                "  and eventname  = '\\\\core\\\\event\\\\course_viewed' order by id desc limit 1 ";

            $timecreated = $DB->get_field_sql($sql,  array('courseid' => $course->id, 'userid' => $userid));

            if ($timecreated) {

                $lastaccess = date('d/m/Y h:i a', $timecreated);

            }

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

            $progress = progress::get_course_progress_percentage($course);

            $progress = $progress ? floatval($progress) : 0.0;

            $miProgreso = number_format($progress, 2); // Progreso por curso

            $first_section = 0;

            $sections = $DB->get_records('course_sections', ['course' => $course->id], 'section ASC', 'id,name,section,sequence,visible');

            foreach ($sections as $section) {

                if (!empty($section->section)) {

                    $first_section = $section->id;

                    break;

                }

            }

            $course_context = context_course::instance($course->id);

            $roles = get_user_roles($course_context, $USER->id, true);

            $completion_edit_curso = false;

            foreach ($roles as $role) {

                if ($role->shortname == 'companydepartmentmanager' || $role->shortname == 'companycoursenoneditor') {

                    $completion_edit_curso  = true;

                    break;

                }

            }

            $modules = get_fast_modinfo($course->id)->get_cms();

            $linkurl = '';

            foreach ($modules as $module) {

                //print "!".$module->uservisible ."||". $module->is_stealth() ."||". $module->url ."||". $module->section."<br>";

                if (!$module->uservisible || $module->is_stealth() || empty($module->url) || empty($module->section)) {

                    continue;

                }

                if ($module->section == $first_section || $completion_edit_curso) {

                    $linkurl =  new moodle_url($module->url, array('forceview' => 1));

                    break;

                }

            }

            if ($completion_edit_curso) {

                $linkurl = $CFG->wwwroot . '/course/view.php?id=' . $course->id;

            }

            $summary = trim(strip_tags($course->summary));

            if (empty($summary)) {

                $summary = '&nbsp';

            } else if (strlen($summary) > 80) {

                $summary =  substr($summary, 0, 80) . '...';

            }

            $data['course'] = [

                'courseid' => $course->id,

                'coursecategory' => $category->name,

                'courseimage' => $image,

                'enddate' => $course->enddate,

                'fullname' => $course->fullname,

                'fullnamedisplay' => get_course_display_name_for_list($course),

                'hasprogress' => true,

                'hidden' => false,

                'id' => $course->id,

                'idnumber' => $course->idnumber,

                'isfavourite' => false,

                'progress' => $miProgreso,

                'shortname' => $course->shortname,

                'showshortname' => false,

                'startdate' => $course->startdate,

                'summary' =>  $summary,

                'summaryformat' => $course->summaryformat,

                'timeaccess' => $lastaccess,

                'viewurl' => $CFG->wwwroot . '/course/view.php?id=' . $course->id,

                'viewurlnew' => $linkurl,

                'visible' => true,

            ];

        }

        return $this->render_from_template('block_cesa_lastcourse/full', $data);

    }

}