details.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/>.

/**
 * This file is used to setting the block allover the site
 *
 * @package    block
 * @subpackage graph_stats
 * @copyright  2011 Éric Bugnet with help of Jean Fruitet
 * @copyright  2014 Wesley Ellis, Code Improvements.
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require_once("../../config.php");
global $CFG, $USER, $SESSION, $COURSE, $DB;

/*
 * Today's date
 * @var timestamp
 */
$today = mktime(0, 0, 0, date("m") , date("d") , date("Y"));

$url = new moodle_url('/block/graph_stats/details.php');

/*
 * course id to show in graph
 * @var integer
 */
$courseid = optional_param('course_id', 1, PARAM_INT);
require_course_login($courseid);

$context = context_course::instance($courseid);
$PAGE->set_pagelayout('standard');
$PAGE->set_url($url);
$PAGE->set_context($context);
$PAGE->set_title(get_string('connectedtoday', 'block_graph_stats'));
$PAGE->set_heading($COURSE->fullname);

echo $OUTPUT->header();

if (has_capability('report/log:view', $context)) {
     echo html_writer::start_tag('h2', array('class' => 'main'));
     echo get_string('connectedtoday', 'block_graph_stats');
     echo html_writer::end_tag('h2');
     echo html_writer::link(new moodle_url('/report/log/index.php?chooselog=1&showusers=1&showcourses=1&host_course=1%2F'
     . $courseid . '&user=&date=' . $today . '&modid=&modaction=&logformat=showashtml'),
       get_string('moredetails', 'block_graph_stats') ,
       array('title' => get_string('moredetails', 'block_graph_stats')));

    if (!empty($SESSION->fullnamedisplay)) {
        $CFG->fullnamedisplay = $SESSION->fullnamedisplay;
    }

    echo html_writer::start_tag('ul');
    $params = array(
        'time1' => mktime(0, 0, 0, date('m') , date('d'), date('Y')),
        'time2' => mktime(23, 59, 59, date('m') , date('d'), date('Y')) );
    $query = "
                SELECT DISTINCT
                        l.userid, u.firstname, u.lastname
                FROM
                        {log} l, {user} u
                WHERE
                        l.userid = u.id AND
                        time > :time1 AND
                        time < :time2 AND
                        action = 'login'
        ";

    if ($CFG->fullnamedisplay == 'lastname firstname') {
        $query = $query."
                ORDER BY
                u.lastname, u.firstname ASC
                ";
    } else {
        $query = $query."
                ORDER BY
                u.firstname, u.lastname  ASC
                ";
    }

    if ($connections = $DB->get_records_sql($query, $params)) {
        foreach ($connections as $connection) {
            if ($CFG->fullnamedisplay == 'firstname lastname') {
                $fullname = $connection->firstname.' '. $connection->lastname;
            } else if ($CFG->fullnamedisplay == 'lastname firstname') {
                          $fullname = $connection->lastname.' '. $connection->firstname;
            } else if ($CFG->fullnamedisplay == 'firstname') {
                          $fullname = $connection->firstname;
            } else {
                $fullname = $connection->lastname.' '. $connection->firstname;
            }
                echo html_writer::start_tag('li');
                echo $fullname;
                echo html_writer::end_tag('li');
        }
    }
    echo html_writer::end_tag('ul');
}
echo $OUTPUT->footer();