Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
<?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/>.

/**
 * Display user activity reports for a course (totals)
 *
 * @package    report
 * @subpackage outline
 * @copyright  1999 onwards Martin Dougiamas (http://dougiamas.com)
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

use core\report_helper;

require('../../config.php');
require_once($CFG->dirroot.'/report/outline/locallib.php');

$id = required_param('id',PARAM_INT);       // course id
$startdate = optional_param('startdate', null, PARAM_INT);
$enddate = optional_param('enddate', null, PARAM_INT);

$course = $DB->get_record('course', array('id'=>$id), '*', MUST_EXIST);

$pageparams = array('id' => $id);
if ($startdate) {
    $pageparams['startdate'] = $startdate;
}
if ($enddate) {
    $pageparams['enddate'] = $enddate;
}

$PAGE->set_url('/report/outline/index.php', $pageparams);
$PAGE->set_pagelayout('report');

require_login($course);
$context = context_course::instance($course->id);
require_capability('report/outline:view', $context);

< $url = new moodle_url('/report/outline/index.php', ['id' => $id]); < report_helper::save_selected_report($id, $url); <
// Handle form to filter access logs by date. $filterform = new \report_outline\filter_form(); $filterform->set_data(['id' => $course->id, 'filterstartdate' => $startdate, 'filterenddate' => $enddate]); if ($filterform->is_cancelled()) { $redir = $PAGE->url; $redir->remove_params(['startdate', 'enddate']); redirect($redir); } if ($filter = $filterform->get_data()) { $redir = $PAGE->url; if ($filter->filterstartdate) { $redir->param('startdate', $filter->filterstartdate); } if ($filter->filterenddate) { $redir->param('enddate', $filter->filterenddate); } redirect($redir); } // Trigger an activity report viewed event. $event = \report_outline\event\activity_report_viewed::create(array('context' => $context)); $event->trigger(); $showlastaccess = true; $hiddenfields = explode(',', $CFG->hiddenuserfields); if (array_search('lastaccess', $hiddenfields) !== false and !has_capability('moodle/user:viewhiddendetails', $context)) { $showlastaccess = false; } $stractivityreport = get_string('pluginname', 'report_outline'); $stractivity = get_string('activity'); $strlast = get_string('lastaccess'); $strreports = get_string('reports'); $strviews = get_string('views'); $strrelatedblogentries = get_string('relatedblogentries', 'blog'); $PAGE->set_title($course->shortname .': '. $stractivityreport); $PAGE->set_heading($course->fullname); echo $OUTPUT->header(); // Print selector drop down. $pluginname = get_string('pluginname', 'report_outline'); report_helper::print_report_selector($pluginname);
< echo $OUTPUT->heading(format_string($course->fullname));
list($uselegacyreader, $useinternalreader, $minloginternalreader, $logtable) = report_outline_get_common_log_variables(); // If no legacy and no internal log then don't proceed. if (!$uselegacyreader && !$useinternalreader) { echo $OUTPUT->box_start('generalbox', 'notice'); echo $OUTPUT->notification(get_string('nologreaderenabled', 'report_outline')); echo $OUTPUT->box_end(); echo $OUTPUT->footer(); die(); } // We want to display the time we are beginning to get logs from in the heading. // If we are using the legacy reader check the minimum time in that log table. if ($uselegacyreader) { $minlog = $DB->get_field_sql('SELECT min(time) FROM {log}'); } // If we are using the internal reader check the minimum time in that table. if ($useinternalreader) { // If new log table has older data then don't use the minimum time obtained from the legacy table. if (empty($minlog) || ($minloginternalreader <= $minlog)) { $minlog = $minloginternalreader; } } $filterform->display(); echo $OUTPUT->container(get_string('computedfromlogs', 'admin', userdate($minlog)), 'loginfo'); $outlinetable = new html_table(); $outlinetable->attributes['class'] = 'generaltable boxaligncenter'; $outlinetable->cellpadding = 5; $outlinetable->id = 'outlinetable'; $outlinetable->head = array($stractivity, $strviews); if (!empty($CFG->enableblogs) && $CFG->useblogassociations) { $outlinetable->head[] = $strrelatedblogentries; } if ($showlastaccess) { $outlinetable->head[] = $strlast; } $modinfo = get_fast_modinfo($course); // If using legacy log then get users from old table. if ($uselegacyreader) { // If we are going to use the internal (not legacy) log table, we should only get records // from the legacy table that exist before we started adding logs to the new table. $params = array('courseid' => $course->id, 'action' => 'view%', 'visible' => 1); $limittime = ''; if (!empty($minloginternalreader)) { $limittime = ' AND time < :timeto '; $params['timeto'] = $minloginternalreader; } if ($startdate) { $limittime .= ' AND time >= :startdate '; $params['startdate'] = $startdate; } if ($enddate) { $limittime .= ' AND time < :enddate '; $params['enddate'] = $enddate; } // Check if we need to show the last access. $sqllasttime = ''; if ($showlastaccess) { $sqllasttime = ", MAX(time) AS lasttime"; } $logactionlike = $DB->sql_like('l.action', ':action'); $sql = "SELECT cm.id, COUNT('x') AS numviews, COUNT(DISTINCT userid) AS distinctusers $sqllasttime FROM {course_modules} cm JOIN {modules} m ON m.id = cm.module JOIN {log} l ON l.cmid = cm.id WHERE cm.course = :courseid AND $logactionlike AND m.visible = :visible $limittime GROUP BY cm.id"; $views = $DB->get_records_sql($sql, $params); } // Get record from sql_internal_table_reader and merge with records obtained from legacy log (if needed). if ($useinternalreader) { // Check if we need to show the last access. $sqllasttime = ''; if ($showlastaccess) { $sqllasttime = ", MAX(timecreated) AS lasttime"; } $params = array('courseid' => $course->id, 'contextmodule' => CONTEXT_MODULE); $limittime = ''; if ($startdate) { $limittime .= ' AND timecreated >= :startdate '; $params['startdate'] = $startdate; } if ($enddate) { $limittime .= ' AND timecreated < :enddate '; $params['enddate'] = $enddate; } $sql = "SELECT contextinstanceid as cmid, COUNT('x') AS numviews, COUNT(DISTINCT userid) AS distinctusers $sqllasttime FROM {" . $logtable . "} l WHERE courseid = :courseid AND anonymous = 0 AND crud = 'r' AND contextlevel = :contextmodule $limittime GROUP BY contextinstanceid"; $v = $DB->get_records_sql($sql, $params); if (empty($views)) { $views = $v; } else { // Merge two view arrays. foreach ($v as $key => $value) { if (isset($views[$key]) && !empty($views[$key]->numviews)) { $views[$key]->numviews += $value->numviews; if ($value->lasttime > $views[$key]->lasttime) { $views[$key]->lasttime = $value->lasttime; } } else { $views[$key] = $value; } } } } $prevsecctionnum = 0; foreach ($modinfo->sections as $sectionnum=>$section) { foreach ($section as $cmid) { $cm = $modinfo->cms[$cmid]; if (!$cm->has_view()) { continue; } if (!$cm->uservisible) { continue; } if ($prevsecctionnum != $sectionnum) { $sectionrow = new html_table_row(); $sectionrow->attributes['class'] = 'section'; $sectioncell = new html_table_cell(); $sectioncell->colspan = count($outlinetable->head); $sectiontitle = get_section_name($course, $sectionnum); $sectioncell->text = $OUTPUT->heading($sectiontitle, 3); $sectionrow->cells[] = $sectioncell; $outlinetable->data[] = $sectionrow; $prevsecctionnum = $sectionnum; } $dimmed = $cm->visible ? '' : 'class="dimmed"'; $modulename = get_string('modulename', $cm->modname); $reportrow = new html_table_row(); $activitycell = new html_table_cell(); $activitycell->attributes['class'] = 'activity';
< $activityicon = $OUTPUT->pix_icon('icon', $modulename, $cm->modname, array('class'=>'icon'));
> $activityicon = $OUTPUT->pix_icon('monologo', $modulename, $cm->modname, array('class'=>'icon'));
$attributes = array(); if (!$cm->visible) { $attributes['class'] = 'dimmed'; } $activitycell->text = $activityicon . html_writer::link("$CFG->wwwroot/mod/$cm->modname/view.php?id=$cm->id", format_string($cm->name), $attributes); $reportrow->cells[] = $activitycell; $numviewscell = new html_table_cell(); $numviewscell->attributes['class'] = 'numviews'; if (!empty($views[$cm->id]->numviews)) { $numviewscell->text = get_string('numviews', 'report_outline', $views[$cm->id]); } else { $numviewscell->text = '-'; } $reportrow->cells[] = $numviewscell; if (!empty($CFG->enableblogs) && $CFG->useblogassociations) { require_once($CFG->dirroot.'/blog/lib.php'); $blogcell = new html_table_cell(); $blogcell->attributes['class'] = 'blog'; if ($blogcount = blog_get_associated_count($course->id, $cm->id)) { $blogurl = new moodle_url('/blog/index.php', array('modid' => $cm->id)); $blogcell->text = html_writer::link($blogurl, $blogcount); } else { $blogcell->text = '-'; } $reportrow->cells[] = $blogcell; } if ($showlastaccess) { $lastaccesscell = new html_table_cell(); $lastaccesscell->attributes['class'] = 'lastaccess'; if (isset($views[$cm->id]->lasttime)) { $timeago = format_time(time() - $views[$cm->id]->lasttime); $lastaccesscell->text = userdate($views[$cm->id]->lasttime)." ($timeago)"; } $reportrow->cells[] = $lastaccesscell; } $outlinetable->data[] = $reportrow; } } echo html_writer::table($outlinetable); echo $OUTPUT->footer();