allcoursesreport.php

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 * Course trainingsessions report. Gives a transversal view of all courses for a user.
 * this script is used as inclusion of the index.php file.
 *
 * @package    report_trainingsessions
 * @category   report
 * @author     Valery Fremaux (valery.fremaux@gmail.com)
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
defined('MOODLE_INTERNAL') || die();

/*
 * direct log construction implementation
 *
 */
ob_start();

require_once($CFG->dirroot.'/blocks/use_stats/locallib.php');
require_once($CFG->dirroot.'/report/trainingsessions/locallib.php');
require_once($CFG->dirroot.'/report/trainingsessions/selector_form.php');

$rt = \report\trainingsessions\trainingsessions::instance();
$tsconfig = get_config('report_trainingsessions');

$id = required_param('id', PARAM_INT); // The course id.

// Calculate start time.
$selform = new SelectorForm($id, 'allcourses');

if (!$data = $selform->get_data()) {
    $data = new StdClass();
    $data->from = optional_param('from', -1, PARAM_NUMBER);
    $data->to = optional_param('to', -1, PARAM_NUMBER);
    $data->userid = optional_param('userid', $USER->id, PARAM_INT);
    $data->fromstart = optional_param('fromstart', 0, PARAM_BOOL);
    $data->tonow = optional_param('tonow', 0, PARAM_BOOL);
    $data->output = optional_param('output', 'html', PARAM_ALPHA);
}

$context = context_course::instance($id);
$canseeothers = has_capability('report/trainingsessions:viewother', $context);

if (!$canseeothers) {
    // Restrict to view yourself only.
    $userid = $USER->id;
} else {
    $userid = $data->userid;
}
$user = $DB->get_record('user', array('id' => $userid));

$rt->process_bounds($data, $course);

if ($data->output == 'html') {
    echo $OUTPUT->header();
    echo $OUTPUT->container_start();
    echo $rtrenderer->tabs($course, $view, $data->from, $data->to);
    echo $OUTPUT->container_end();

    echo $OUTPUT->box_start('block');
    $selform->set_data($data);
    $selform->display();
    echo $OUTPUT->box_end();

    echo get_string('from', 'report_trainingsessions')." : ".userdate($data->from);
    echo ' '.get_string('to', 'report_trainingsessions')."  : ".userdate($data->to);
}

// Get log data.
$logs = use_stats_extract_logs($data->from, $data->to, $userid, null);
$aggregate = use_stats_aggregate_logs($logs, $data->from, $data->to);

if (empty($aggregate['sessions'])) {
    $aggregate['sessions'] = array();
}

// Print result.
$cols = $rt->get_summary_cols('cols');

if ($data->output == 'html') {
    // Time period form.

    include_once($CFG->dirroot.'/report/trainingsessions/renderers/htmlrenderers.php');
    $renderer = new \report\trainingsessions\HtmlRenderer($rt);

    echo '<br/>';

    $str = $renderer->print_allcourses_html($aggregate, $dataobject);

    $dataobject->activityelapsed = @$aggregate['activities'][$COURSE->id]->elapsed;
    $dataobject->activityevents = @$aggregate['activities'][$COURSE->id]->events;
    $dataobject->otherelapsed = @$aggregate['other'][$COURSE->id]->elapsed;
    $dataobject->otherevents = @$aggregate['other'][$COURSE->id]->events;

    $dataobject->course = new StdClass();
    $dataobject->course->elapsed = 0;
    $dataobject->course->events = 0;

    if (!empty($aggregate['course'])) {
        $dataobject->course->elapsed = 0 + @$aggregate['course'][$course->id]->elapsed;
        $dataobject->course->events = 0 + @$aggregate['course'][$course->id]->events;
    }

    // Calculate everything.

    $dataobject->elapsed = $dataobject->activityelapsed + $dataobject->otherelapsed + $dataobject->course->elapsed;
    $dataobject->events = $dataobject->activityevents + $dataobject->otherevents + $dataobject->course->events;

    $dataobject->sessions = 0;
    if (!empty($aggregate['sessions'])) {
        $dataobject->sessions = $rt->count_sessions_in_course($aggregate['sessions'], 0);
    }

    if (array_key_exists('upload', $aggregate)) {
        $dataobject->elapsed += @$aggregate['upload'][0]->elapsed;
        $dataobject->upload = new StdClass;
        $dataobject->upload->elapsed = 0 + @$aggregate['upload'][0]->elapsed;
        $dataobject->upload->events = 0 + @$aggregate['upload'][0]->events;
    }

    $dataobject->gradecols = []; // Must be empty array in allcourses.

    $renderer->print_header_html($user, $course, $dataobject, $cols, true, false, false);

    echo $OUTPUT->heading(get_string('incourses', 'report_trainingsessions'));
    echo $str;

    echo $renderer->print_session_list(@$aggregate['sessions'], null, $userid);

    $params = array('id' => $course->id,
                    'userid' => $userid,
                    'from' => $data->from,
                    'to' => $data->to);
    echo '<br/><center>';

    $url = new moodle_url('/report/trainingsessions/tasks/userxlsreportallcourses_batch_task.php', $params);
    echo $OUTPUT->single_button($url, get_string('generatexls', 'report_trainingsessions'), 'get');

    if (report_trainingsessions_supports_feature('format/pdf')) {
        include_once($CFG->dirroot.'/report/trainingsessions/pro/renderer.php');
        $rendererext = new \report_trainingsessions\output\pro_renderer($PAGE, '');
        if (!empty($config->showmonthlyquickreports)) {
            echo '<br/>';
            echo $rendererext->user_session_reports_buttons($data->userid, 'allcourses');
        }
    }

    echo '</center>';
    echo '<br/>';

} else {

    require_once($CFG->dirroot.'/report/trainingsessions/renderers/xlsrenderers.php');
    $renderer = new \report\trainingsessions\XlsRenderer($rt);

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

    $filename = 'allcourses_sessions_report_'.date('d-M-Y', time()).'.xls';
    $workbook = new MoodleExcelWorkbook('-');

    // Sending HTTP headers.
    ob_end_clean();

    $workbook->send($filename);

    // Preparing some formats.
    $xlsformats = $renderer->xls_formats($workbook);
    $startrow = 15;

    $cols = $rt->get_summary_cols();
    $headdata = $rt->map_summary_cols($cols, $auser, $aggregate, $weekaggregate, $course->id, true /* associative */);
    $rt->add_graded_columns($cols, $titles);
    $rt->add_graded_data($gradedata, $auser->id, $aggregate);
    $headdata = (object) $headdata;
    $headdata->gradecols = $gradedata;
    $headdata->from = $input->from;
    $headdata->to = $input->to;

    $worksheet = $renderer->init_worksheet($userid, $startrow, $xlsformats, $workbook, 'allcourses');
    $overall = $renderer->print_allcourses_xls($worksheet, $aggregate, $startrow, $xlsformats);
    $headdata->elapsed = $overall->elapsed;
    $headdata->events = $overall->events;
    $renderer->print_header_xls($worksheet, $userid, 0, $headdata, $cols, $xlsformats);

    if (!empty($tsconfig->showsessions)) {
        $worksheet = $renderer->init_worksheet($userid, $startrow, $xlsformats, $workbook, 'sessions');
        $renderer->print_sessions_xls($worksheet, 15, @$aggregate['sessions'], null, $xlsformats);
        $renderer->print_header_xls($worksheet, $userid, 0, $headdata, $cols, $xlsformats);
    }

    $workbook->close();
}