Proyectos de Subversion Moodle

<?php

use core_completion\progress;

class block_progreso_detalles_renderer extends plugin_renderer_base {

    public function procesar($instance_id) {

        global $USER, $CFG, $DB, $PAGE, $OUTPUT;

        require_once $CFG->libdir . '/completionlib.php';

        require_once $CFG->dirroot.'/completion/classes/progress.php';

        require_once $CFG->libdir . '/gradelib.php';

        require_once $CFG->dirroot . '/grade/querylib.php';

        require_once $CFG->libdir . '/coursecatlib.php';

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

        if (!file_exists($CFG->dirroot.'/cesa/progreso_detalles/')) {

            mkdir($CFG->dirroot.'/cesa/progreso_detalles/', 0755, true);

        }

        if (!file_exists($CFG->dirroot.'/cesa/progreso_detalles/'.$USER->id)) {

            mkdir($CFG->dirroot.'/cesa/progreso_detalles/'.$USER->id, 0755, true);

        }

        $oldfiles = glob($CFG->dirroot.'/cesa/progreso_detalles/'.$USER->id.'/*');

        foreach ($oldfiles as $file) {

            if (is_file($file)) {

                unlink($file);

            }

        }

        $user       = $DB->get_record('user',array('id'=> $USER->id));

        $mycourses  = enrol_get_users_courses($USER->id);

        $max_time   = time();

        $min_time   = strtotime('-1 YEAR');

        $limit      = 3600;

        $data = [

            'user_name'         => $user->firstname . ' ' . $user->lastname  ,

            'user_image'        => $OUTPUT->user_picture($user, array('size' => 100, 'link' => false, 'alttext' => false)),

            'user_email'        => $user->email,

            'graph_dedication'  => '',

            'completed'         => 0,

            'inprogress'        => 0,

            'total_dedication'  => '',

            'courses'           => []

        ];

        $graph_percentage = [];

        $graph_dedication = [];

        $graph_labels = [];

        $completed = 0;

        $inprogress = 0;

	$dedication = 0;

        $total_dedication = 0;

        foreach($mycourses as $key => $val) {

            $course = get_course($val->id);

            if ($course instanceof stdClass) {

                $courseInList = new course_in_list($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 = $DB->get_field('report_training_lastaccess', 'timeaccess', array('courseid' => $course->id, 'userid' => $userid));

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

            $completion = new \completion_info($course);

            if ($completion->is_enabled()) {

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

                $percentage = floatval(!$percentage ? 0 :  $percentage);

            } else {

                $percentage = 0;

            }

            if($percentage >= 100) {

                $completed++;

            } else {

                $inprogress++;

            }

            $resultkrb =  grade_get_course_grades($course->id, $USER->id);

            $grd = $resultkrb->grades[$USER->id];

            $dedication = $this->get_students_dedication($USER->id, $course->id, $min_time, $max_time, $limit);

            $total_dedication = $total_dedication + $dedication;

            $graph_percentage[] = number_format($percentage, 2);

            $graph_labels[] = $course->shortname;

            $data['courses'][] = [

                'coursecategory' => $category->name,

                'courseimage' => $image,

                'enddate' => $course->enddate,

                'shortname' => $course->shortname,

                'fullname' => $course->fullname,

                'fullnamedisplay' => get_course_display_name_for_list($course),

                'hasprogress' => $percentage > 0,

                'hidden' => false,

                'id' => $course->id,

                'idnumber' => $course->idnumber,

                'isfavourite' => false,

                'progress' => $percentage,

                'shortname' => $course->shortname,

                'showshortname' => false,

                'startdate' => $course->startdate,

                'summary' => $course->summary,

                'summaryformat' => $course->summaryformat,

                'timeaccess' => $lastaccess,

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

                'visible' => true,

                'grade' => $grd->str_grade,

                'dedication' => $dedication,

                'percentage' => number_format($percentage, 2),

            ];

        }

	$dedication = 0;

        for($i = 0, $max = count($data['courses']); $i < $max; $i++)

        {

            $dedication = ($data['courses'][$i][ 'dedication'] * 100) / $total_dedication;

            $data['courses'][$i][ 'dedication']  = $this->format_dedication($data['courses'][$i][ 'dedication']);

            array_push($graph_dedication, number_format($dedication, 2));

        }

        $serie_dedication = new core\chart_series('Dedicación', $graph_dedication);

        $serie_percentage = new core\chart_series('Progreso', $graph_percentage);

        $chart = new core\chart_bar();

        $chart->set_title('Dedicación/Progreso en %');

        $chart->set_horizontal(true); // Calling set_horizontal() passing true as parameter will display horizontal bar charts.

        $chart->add_series( $serie_dedication );

        $chart->add_series( $serie_percentage);

        $chart->set_labels($graph_labels);

        //Cambias las colores de las series

        //$CFG->chart_colorset = ['#001f3f', '#01ff70', '#F012BE', '#85144b', '#B10DC9'];

        //var_dump ($chart);

        //die();

        $data['graph_dedication'] = $OUTPUT->render_chart($chart, true); //true muesta tabla de datos, false no

        $data['completed']          = $completed;

        $data['inprogress']         = $inprogress;

        $data['total_dedication']   = $this->format_dedication($total_dedication);

        $content .= html_writer::start_tag('div', array('class' => 'container')); //'d-flex flex-row bd-highlight mb-3'));

        $content .= $this->render_from_template('block_progreso_detalles/full', $data);

        $content .= html_writer::end_tag('div');

        $content = str_replace('<!--USER-IMAGE-->', $data['user_image'], $content);

        $content = str_replace('<!--GRAPH-DEDICATION-->', $data['graph_dedication'], $content);

        return $content;

    }

    public static function format_dedication($totalsecs) {

        $totalsecs = abs($totalsecs);

        $str = new stdClass();

        $str->hour = get_string('hour');

        $str->hours = get_string('hours');

        $str->min = get_string('min');

        $str->mins = get_string('mins');

        $str->sec = get_string('sec');

        $str->secs = get_string('secs');

        $hours = floor($totalsecs / HOURSECS);

        $remainder = $totalsecs - ($hours * HOURSECS);

        $mins = floor($remainder / MINSECS);

        $secs = round($remainder - ($mins * MINSECS), 2);

        $ss = ($secs == 1) ? $str->sec : $str->secs;

        $sm = ($mins == 1) ? $str->min : $str->mins;

        $sh = ($hours == 1) ? $str->hour : $str->hours;

        $ohours = '';

        $omins = '';

        $osecs = '';

        if ($hours) {

            $ohours = $hours . ' ' . $sh;

        }

        if ($mins) {

            $omins = $mins . ' ' . $sm;

        }

        if ($secs) {

            $osecs = $secs . ' ' . $ss;

        }

        if ($hours) {

            return trim($ohours . ' ' . $omins);

        }

        if ($mins) {

            return trim($omins . ' ' . $osecs);

        }

        if ($secs) {

            return $osecs;

        }

        return get_string('none');

    }

    public function get_events_select($selectwhere, array $params)

    {

        $logstores  = ['logstore_standard', 'logstore_legacy'];

        $return     = [];

        static $allreaders = null;

        if (is_null($allreaders)) {

            $allreaders = get_log_manager()->get_readers();

        }

        $processedreaders = 0;

        foreach ($logstores as $name) {

            if (isset($allreaders[$name])) {

                $reader = $allreaders[$name];

                $events = $reader->get_events_select($selectwhere, $params, 'timecreated ASC', 0, 0);

                foreach ($events as $event) {

                    // Note: see \core\event\base to view base class of event.

                    $obj = new stdClass();

                    $obj->time = $event->timecreated;

                    $obj->ip = $event->get_logextra()['ip'];

                    $return[] = $obj;

                }

                if (!empty($events)) {

                    $processedreaders++;

                }

            }

        }

        // Sort mixed array by time ascending again only when more of a reader has added events to return array.

        if ($processedreaders > 1) {

            usort($return, function($a, $b) {

                return $a->time > $b->time;

            });

        }

        return $return;

    }

    public function get_students_dedication($user_id, $course_id, $min_time, $max_time, $limit)

    {

        $where = 'courseid = :courseid AND userid = :userid AND timecreated >= :mintime AND timecreated <= :maxtime';

        $params = array(

            'courseid'  => $course_id,

            'userid'    => $user_id,

            'mintime'   => $min_time,

            'maxtime'   => $max_time

        );

        $logs = $this->get_events_select($where, $params);

        if ($logs) {

            $previouslog = array_shift($logs);

            $previouslogtime = $previouslog->time;

            $sessionstart = $previouslog->time;

            $dedication = 0;

            foreach ($logs as $log) {

                if (($log->time - $previouslogtime) > $limit) {

                    $dedication += $previouslogtime - $sessionstart;

                    $sessionstart = $log->time;

                }

                $previouslogtime = $log->time;

            }

            $dedication += $previouslogtime - $sessionstart;

        } else {

            $dedication = 0;

        }

        return $dedication;

    }

}