Proyectos de Subversion Moodle

<?php

ob_start();

require('../../config.php');

//require('autoload.php');

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

require_once($CFG->libdir . '/adminlib.php');

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

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

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

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

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

require_once(__DIR__ . '/locallib.php');

require_login();

require_capability('local/cesa_reportes:view', context_system::instance());

$classname = optional_param('classname', 'dashboard', PARAM_TEXT);

$page = optional_param('page', 0, PARAM_INT);

$PAGE->set_url(new moodle_url('/local/cesa_reportes'));

$PAGE->set_context(context_system::instance());

//$PAGE->set_pagetype('admin-setting');

$PAGE->set_pagelayout('plain');

$PAGE->set_title('Cesa Reportes');

$PAGE->set_heading('Cesa Reportes');

$filter_userids = [];

$filter_courseids = [];

$filter_by_company_active = false;

$PAGE->requires->jquery();

$PAGE->requires->css(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/pnotify.css'));

$PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/pnotify.js'));

$PAGE->requires->css(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/css/local_cesa_reportes.css'));

$PAGE->navbar->add(get_string('modulename', 'local_cesa_reportes'), new moodle_url('/local/cesa_reportes'));

$context = [

    'classname_dashboard' => $classname == 'dashboard' ? 1 : 0,

    'classname_one_course' => $classname == 'one_course'  ? 1 : 0,

    'classname_one_user' => $classname == 'one_user'  ? 1 : 0,

    'classname_all_course' => $classname == 'all_courses'  ? 1 : 0,

    'classname_all_course_with_activities' => $classname == 'all_courses_with_activities'  ? 1 : 0,

    'classname_custom' => $classname == 'custom'  ? 1 : 0,

    'classname_all_files' => $classname == 'all_files'  ? 1 : 0,

];

if($classname == 'dashboard')

{

    $context['graph_serie1_color'] = get_config('local_cesa_reportes', 'graph_serie1_color');

    $context['graph_serie2_color'] = get_config('local_cesa_reportes', 'graph_serie2_color');

   // $PAGE->requires->js('/local/cesa_reportes/assets/jquery-1.12.2.min.js');

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/Chart.min.js'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_charts.js'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_dashboard.js'));

    $data = local_cesa_reportes_get_week_days();

    $context['last_ten_user_activities'] = (array) local_cesa_reportes_get_last_ten_user_activities($filter_by_company_active, $filter_userids, $data->min, $data->max);

    $context['top_ten_user_activities'] = (array)  local_cesa_reportes_get_top_ten_user_activities($filter_by_company_active, $filter_userids, $data->min, $data->max);

    $context['last_ten_user_modules_completion'] =  (array) local_cesa_reportes_get_last_ten_user_modules_completion($filter_by_company_active, $filter_userids, $data->min, $data->max);

    $context['top_ten_user_modules_completion'] =  (array) local_cesa_reportes_get_top_ten_user_modules_completion($filter_by_company_active, $filter_userids, $data->min, $data->max);

    $context['chart'] = [];

    foreach($data->days as $day)

    {

        $data1 = local_cesa_reportes_get_count_activities($filter_by_company_active, $filter_userids, $day->min, $day->max);

        $data2 = local_cesa_reportes_get_count_modules_completion($filter_by_company_active, $filter_userids, $day->min, $day->max);

        array_push($context['chart'], [

            'label' => $day->day,

            'data1' => $data1,

            'data2' => $data2,

        ]);

    }

} else if($classname == 'one_course') {

    $PAGE->requires->css(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/select2.css'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_report_for_one_course.js'));

    $context['courses'] = [];

    $sql = 'SELECT  id, fullname FROM {course}  ';

    if($filter_by_company_active) {

        $filter_courseids = empty($filter_courseids) ? [-1] : $filter_courseids;

        $sql .= ' WHERE id IN (' . implode(',', $filter_courseids) . ')';

    }

    $sql .= ' ORDER BY fullname ';

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

    foreach($records as $record)

    {

        array_push($context['courses'], [

            'id' => $record->id,

            'name' => $record->fullname

        ]) ;

    }

} else if($classname == 'one_user') {

    $context['users'] = [];

    $PAGE->requires->css(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/select2.css'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_report_for_one_user.js'));

    $sql = 'SELECT  id, firstname, lastname, email FROM {user} WHERE id > 1 AND deleted = 0 ' .

        ' AND suspended = 0  ';

    if($filter_by_company_active) {

        $filter_userids = empty($filter_userids) ? [-1] : $filter_userids;

        $sql .= ' AND id IN (' . implode(',', $filter_userids) . ')';

    }

    $sql .= ' ORDER BY lastname, firstname, email ';

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

    foreach($records as $record)

    {

        array_push($context['users'], [

            'id' => $record->id,

            'name' => $record->lastname . ' ' . $record->firstname . ' (' . $record->email . ')'

        ]) ;

    }

} else if($classname == 'all_courses') {

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_all_courses.js'));

    $extra_fields = local_cesa_reportes_get_user_extra_field_names();

    $context['fields'] = [];

    array_push($context['fields'], ['field' => 'Apellido']);

    array_push($context['fields'], ['field' => 'Nombre']);

    array_push($context['fields'], ['field' => 'Email']);

    array_push($context['fields'], ['field' => 'Curso']);

    array_push($context['fields'], ['field' => 'Categoria']);

    array_push($context['fields'], ['field' => 'Matriculación']);

    array_push($context['fields'], ['field' => 'Fecha finalización']);

    array_push($context['fields'], ['field' => 'Actividades asignadas']);

    array_push($context['fields'], ['field' => 'Actividades completadas']);

    array_push($context['fields'], ['field' => 'Progreso %']);

    array_push($context['fields'], ['field' => 'Primera actividad']);

    array_push($context['fields'], ['field' => 'Ultima actividad']);

    foreach($extra_fields as $extra_field)

    {

        array_push($context['fields'], ['field' => $extra_field->name]);

    }

    $context['items']  = [];

    $page = $page ? $page : 1;

    $include_modules = true;

    $data = local_cesa_reportes_get_data_for_report_or_excel($filter_by_company_active, $filter_userids, $filter_courseids, $include_modules, $page);

    $records = $data['items'];

    $context['pagination'] = $data['pagination'];

    if($context['pagination']['page'] > 1) {

        $context['pagination']['previous_page'] = $context['pagination']['page'] - 1;

    }

    if($context['pagination']['page'] < $context['pagination']['max_pages']) {

        $context['pagination']['next_page'] = $context['pagination']['page'] + 1;

    }

    foreach($records as $record)

    {

        if(!$record->courses) {

            continue;

        }

        foreach($record->courses as $course)

        {

            $item = [];

            array_push($item, ['value' => $record->lastname ]);

            array_push($item, ['value' => $record->firstname ]);

            array_push($item, ['value' => $record->email ]);

            array_push($item, ['value' => $course->name ]);

            array_push($item, ['value' => $course->category ]);

            array_push($item, ['value' => empty($course->timeenrolled)  ? '' : date('d/m/Y h:i a', $course->timeenrolled)]);

            array_push($item, ['value' => empty($course->timecompleted)  ? '' : date('d/m/Y h:i a', $course->timecompleted)]);

            array_push($item, ['value' => $course->activities_assigned, 'align-right' => true ]);

            array_push($item, ['value' => $course->activities_completed, 'align-right' => true ]);

            array_push($item, ['value' => number_format($course->percentage, 2), 'align-right' => true ]);

            array_push($item, ['value' => empty($course->time_activities_first)  ? '' : date('d/m/Y h:i a', $course->time_activities_first) ]);

            array_push($item, ['value' => empty($course->time_activities_last)  ? '' : date('d/m/Y h:i a', $course->time_activities_last) ]);

            foreach($extra_fields as $extra_field)

            {

                $value = '';

                foreach($record->extras as $extra)

                {

                    if($extra->id == $extra_field->id) {

                        $value = $extra->value;

                    }

                }

                array_push($item, ['value' => $value ]);

            }

            array_push($context['items'], ['item' =>  $item]);

        }

    }

} else if($classname == 'all_courses_with_activities') {

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_all_courses_with_activites.js'));

    $extra_fields = local_cesa_reportes_get_user_extra_field_names();

    $context['fields'] = [];

    array_push($context['fields'], ['field' => 'Apellido']);

    array_push($context['fields'], ['field' => 'Nombre']);

    array_push($context['fields'], ['field' => 'Email']);

    array_push($context['fields'], ['field' => 'Curso']);

    array_push($context['fields'], ['field' => 'Categoria']);

    array_push($context['fields'], ['field' => 'Matriculación']);

    array_push($context['fields'], ['field' => 'Fecha finalización']);

    array_push($context['fields'], ['field' => 'Actividades asignadas']);

    array_push($context['fields'], ['field' => 'Actividades completadas']);

    array_push($context['fields'], ['field' => 'Progreso %']);

    array_push($context['fields'], ['field' => 'Primera actividad']);

    array_push($context['fields'], ['field' => 'Ultima actividad']);

    array_push($context['fields'], ['field' => 'Actividad']);

    array_push($context['fields'], ['field' => 'Completado']);

    foreach($extra_fields as $extra_field)

    {

        array_push($context['fields'], ['field' => $extra_field->name]);

    }

    $context['items']  = [];

    $page = $page ? $page : 1;

    $include_modules = true;

    $data = local_cesa_reportes_get_data_for_report_or_excel($filter_by_company_active, $filter_userids, $filter_courseids, $include_modules, $page);

    $records = $data['items'];

    $context['pagination'] = $data['pagination'];

    if($context['pagination']['page'] > 1) {

        $context['pagination']['previous_page'] = $context['pagination']['page'] - 1;

    }

    if($context['pagination']['page'] < $context['pagination']['max_pages']) {

        $context['pagination']['next_page'] = $context['pagination']['page'] + 1;

    }

    foreach($records as $record)

    {

        if(!$record->courses) {

            continue;

        }

        foreach($record->courses as $course)

        {

            foreach($course->activities as $activity)

            {

                $item = [];

                array_push($item, ['value' => $record->lastname ]);

                array_push($item, ['value' => $record->firstname ]);

                array_push($item, ['value' => $record->email ]);

                array_push($item, ['value' => $course->name ]);

                array_push($item, ['value' => $course->category ]);

                array_push($item, ['value' => empty($course->timeenrolled)  ? '' : date('d/m/Y h:i a', $course->timeenrolled)]);

                array_push($item, ['value' => empty($course->timecompleted)  ? '' : date('d/m/Y h:i a', $course->timecompleted)]);

                array_push($item, ['value' => $course->activities_assigned, 'align-right' => true ]);

                array_push($item, ['value' => $course->activities_completed, 'align-right' => true ]);

                array_push($item, ['value' => number_format($course->percentage, 2), 'align-right' => true ]);

                array_push($item, ['value' => empty($course->time_activities_first)  ? '' : date('d/m/Y h:i a', $course->time_activities_first) ]);

                array_push($item, ['value' => empty($course->time_activities_last)  ? '' : date('d/m/Y h:i a', $course->time_activities_last) ]);

                array_push($item, ['value' => $activity->module ]);

                array_push($item, ['value' => empty($activity->timecompleted)  ? '' : date('d/m/Y h:i a', $activity->timecompleted) ]);

                foreach($extra_fields as $extra_field)

                {

                    $value = '';

                    foreach($record->extras as $extra)

                    {

                        if($extra->id == $extra_field->id) {

                            $value = $extra->value;

                        }

                    }

                    array_push($item, ['value' => $value ]);

                }

                array_push($context['items'], ['item' =>  $item]);

            }

        }

    }

} else if($classname == 'all_files') {

    global $DB;

    //$PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/moment.min.js'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_all_files.js'));

    $context['items']  = [];

    $context['fields'] = [];

    array_push($context['fields'], ['field' => 'Solicitado el']);

    array_push($context['fields'], ['field' => 'Solictado por']);

    array_push($context['fields'], ['field' => 'Estado']);

    array_push($context['fields'], ['field' => 'Archivo']);

    array_push($context['fields'], ['field' => 'Generado el']);

} else if($classname == 'custom') {

    global $DB;

    $PAGE->requires->css(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/assets/select2.css'));

    $PAGE->requires->js(new moodle_url($CFG->wwwroot . '/local/cesa_reportes/js/local_cesa_reportes_report_custom.js'));

    $context['courses'] = [];

    $sql = 'SELECT  id, fullname FROM {course}  ';

    if($filter_by_company_active) {

        $filter_courseids = empty($filter_courseids) ? [-1] : $filter_courseids;

        $sql .= ' WHERE id IN (' . implode(',', $filter_courseids) . ')';

    }

    $sql .= ' ORDER BY fullname ';

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

    foreach($records as $record)

    {

        array_push($context['courses'], [

            'id' => $record->id,

            'name' => $record->fullname

        ]) ;

    }

    $context['filter_from'] = date('Y-m-d', strtotime('-1 Month'));

    $context['filter_to'] = date('Y-m-d', time());

}

echo $OUTPUT->header();

echo $OUTPUT->render_from_template('local_cesa_reportes/form', $context);

echo $OUTPUT->footer();