Proyectos de Subversion Moodle

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

/**

 * Version information

 *

 * @package    report_coursesize

 * @copyright  2014 Catalyst IT {@link http://www.catalyst.net.nz}

 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

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

require_once($CFG->dirroot.'/report/coursesize/locallib.php');

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

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

admin_externalpage_setup('reportcoursesize');

$coursecategory = optional_param('category', 0, PARAM_INT);

$download = optional_param('download', '', PARAM_INT);

$viewtab = optional_param('view', 'coursesize', PARAM_ALPHA);

$reportconfig = get_config('report_coursesize');

// If we should show or hide empty courses.

if (!defined('REPORT_COURSESIZE_SHOWEMPTYCOURSES')) {

    define('REPORT_COURSESIZE_SHOWEMPTYCOURSES', false);

}

// Data for the tabs in the report.

$tabdata = ['coursesize' => '', 'userstopnum' => $reportconfig->numberofusers];

if (!array_key_exists($viewtab, $tabdata)) {

    // For invalid parameter value use 'coursesize'.

    $viewtab = array_keys($tabdata)[0];

}

$tabs = [];

foreach ($tabdata as $tabname => $param) {

    $tabs[] = new tabobject($tabname, new moodle_url($PAGE->url, ['view' => $tabname]),

        get_string($tabname, 'report_coursesize', $param));

}

if (empty($download)) {

    print $OUTPUT->header();

    echo $OUTPUT->tabtree($tabs, $viewtab);

}

if ($viewtab == 'userstopnum') {

    $usersizes = report_coursesize_get_usersizes();

    if (!empty($usersizes)) {

        $usertable = new html_table();

        $usertable->align = array('right', 'right');

        $usertable->head = array(get_string('user'), get_string('diskusage', 'report_coursesize'));

        $usertable->data = array();

        $usercount = 0;

        foreach ($usersizes as $userid => $size) {

            $usercount++;

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

            $row = array();

            $row[] = '<a href="' . $CFG->wwwroot . '/user/view.php?id=' . $userid . '">' . fullname($user) . '</a>';

            $row[] = display_size($size->totalsize);

            $usertable->data[] = $row;

            if ($usercount >= $reportconfig->numberofusers) {

                break;

            }

        }

        unset($users);

        print $OUTPUT->heading(get_string('userstopnum', 'report_coursesize', $reportconfig->numberofusers));

        if (!isset($usertable)) {

            print get_string('nouserfiles', 'report_coursesize');

        } else {

            print html_writer::table($usertable);

        }

    }

} else if ($viewtab == 'coursesize') {

    if (!empty($reportconfig->filessize) && !empty($reportconfig->filessizeupdated)) {

        // Total files usage has stored by scheduled task.

        $totalusage = $reportconfig->filessize;

        $totaldate = date("Y-m-d H:i", $reportconfig->filessizeupdated);

    } else {

        $totaldate = get_string('never');

        $totalusage = 0;

    }

    $totalusagereadable = display_size($totalusage);

    $systemsize = $systembackupsize = 0;

    $coursesql = 'SELECT cx.id, c.id as courseid ' .

        'FROM {course} c ' .

        ' INNER JOIN {context} cx ON cx.instanceid=c.id AND cx.contextlevel = ' . CONTEXT_COURSE;

    $params = array();

    $courseparams = array();

    $extracoursesql = '';

    if (!empty($coursecategory)) {

        $context = context_coursecat::instance($coursecategory);

        $coursecat = core_course_category::get($coursecategory);

        $courses = $coursecat->get_courses(array('recursive' => true, 'idonly' => true));

        if (!empty($courses)) {

            list($insql, $courseparams) = $DB->get_in_or_equal($courses, SQL_PARAMS_NAMED);

            $extracoursesql = ' WHERE c.id ' . $insql;

        } else {

            // Don't show any courses if category is selected but category has no courses.

            // This stuff really needs a rewrite!

            $extracoursesql = ' WHERE c.id is null';

        }

    }

    $coursesql .= $extracoursesql;

    $params = array_merge($params, $courseparams);

    $courselookup = $DB->get_records_sql($coursesql, $params);

    $live = false;

    $backupsizes = [];

    if (isset($reportconfig->calcmethod) && ($reportconfig->calcmethod) == 'live') {

        $live = true;

    }

    if ($live) {

        $filesql = report_coursesize_filesize_sql();

        $sql = "SELECT c.id, c.shortname, c.category, ca.name, rc.filesize

          FROM {course} c

          JOIN ($filesql) rc on rc.course = c.id ";

        // Generate table of backup filesizes too.

        $backupsql = report_coursesize_backupsize_sql();

        $backupsizes = $DB->get_records_sql($backupsql);

    } else {

        $sql = "SELECT c.id, c.shortname, c.category, ca.name, rc.filesize, rc.backupsize

          FROM {course} c

          JOIN {report_coursesize} rc on rc.course = c.id ";

    }

    $sql .= "JOIN {course_categories} ca on c.category = ca.id

         $extracoursesql

     ORDER BY rc.filesize DESC";

    $courses = $DB->get_records_sql($sql, $courseparams);

    $coursetable = new html_table();

    $coursetable->align = array('right', 'right', 'left');

    $coursetable->head = array(get_string('course'),

        get_string('category'),

        get_string('diskusage', 'report_coursesize'),

        get_string('backupsize', 'report_coursesize'));

    $coursetable->data = array();

    $totalsize = 0;

    $totalbackupsize = 0;

    $downloaddata = array();

    $downloaddata[] = array(get_string('course'),

        get_string('category'),

        get_string('diskusage', 'report_coursesize'),

        get_string('backupsize', 'report_coursesize'));;

    $coursesizes = $DB->get_records('report_coursesize');

    foreach ($courses as $courseid => $course) {

        if ($live) {

            if (isset($backupsizes[$course->id])) {

                $course->backupsize = $backupsizes[$course->id]->filesize;

            } else {

                $course->backupsize = 0;

            }

        }

        $totalsize = $totalsize + $course->filesize;

        $totalbackupsize = $totalbackupsize + $course->backupsize;

        $coursecontext = context_course::instance($course->id);

        $course->shortname = format_string($course->shortname, true, ['context' => $coursecontext]);

        $course->name = format_string($course->name, true, ['context' => $coursecontext]);

        $row = array();

        $row[] = '<a href="' . $CFG->wwwroot . '/course/view.php?id=' . $course->id . '">' . $course->shortname . '</a>';

        $row[] = '<a href="' . $CFG->wwwroot . '/course/index.php?categoryid=' . $course->category . '">' . $course->name . '</a>';

        $readablesize = display_size($course->filesize);

        $a = new stdClass;

        $a->bytes = $course->filesize;

        $a->shortname = $course->shortname;

        $a->backupbytes = $course->backupsize;

        $bytesused = get_string('coursebytes', 'report_coursesize', $a);

        $backupbytesused = get_string('coursebackupbytes', 'report_coursesize', $a);

        $summarylink = new moodle_url('/report/coursesize/course.php', array('id' => $course->id));

        $summary = html_writer::link($summarylink, ' ' . get_string('coursesummary', 'report_coursesize'));

        $row[] = "<span id=\"coursesize_" . $course->shortname . "\" title=\"$bytesused\">$readablesize</span>" . $summary;

        $row[] = "<span title=\"$backupbytesused\">" . display_size($course->backupsize) . "</span>";

        $coursetable->data[] = $row;

        $downloaddata[] = array($course->shortname, $course->name, str_replace(',', '', $readablesize),

            str_replace(',', '', display_size($course->backupsize)));

    }

    // Now add the courses that had no sitedata into the table.

    if (REPORT_COURSESIZE_SHOWEMPTYCOURSES) {

        $a = new stdClass;

        $a->bytes = 0;

        $a->backupbytes = 0;

        foreach ($courses as $cid => $course) {

            $course->shortname = format_string($course->shortname, true, context_course::instance($course->id));

            $a->shortname = $course->shortname;

            $bytesused = get_string('coursebytes', 'report_coursesize', $a);

            $bytesused = get_string('coursebackupbytes', 'report_coursesize', $a);

            $row = array();

            $row[] = '<a href="' . $CFG->wwwroot . '/course/view.php?id=' . $course->id . '">' . $course->shortname . '</a>';

            $row[] = "<span title=\"$bytesused\">0</span>";

            $row[] = "<span title=\"$bytesused\">0</span>";

            $coursetable->data[] = $row;

        }

    }

    // Now add the totals to the bottom of the table.

    $coursetable->data[] = array(); // Add empty row before total.

    $downloaddata[] = array();

    $row = array();

    $row[] = get_string('total');

    $row[] = '';

    $row[] = display_size($totalsize);

    $row[] = display_size($totalbackupsize);

    $coursetable->data[] = $row;

    $downloaddata[] = [get_string('total'), '', display_size($totalsize), display_size($totalbackupsize)];

    unset($courses);

    $systemsizereadable = display_size($systemsize);

    $systembackupreadable = display_size($systembackupsize);

    // Add in Course Cat including dropdown to filter.

    $url = '';

    $catlookup = $DB->get_records_sql('select id,name from {course_categories}');

    $options = ['0' => get_string('allcourses', 'report_coursesize')];

    foreach ($catlookup as $cat) {

        $options[$cat->id] = format_string($cat->name, true, context_system::instance());

    }

    // Add in download option. Exports CSV.

    if ($download == 1) {

        $downloadfilename = clean_filename("export_csv");

        $csvexport = new csv_export_writer ('commer');

        $csvexport->set_filename($downloadfilename);

        foreach ($downloaddata as $data) {

            $csvexport->add_data($data);

        }

        $csvexport->download_file();

        exit;

    }

    if (empty($coursecat)) {

        $updatestring = !empty($reportconfig->filessizeupdated) ? userdate($reportconfig->filessizeupdated) : get_string('never');

        print $OUTPUT->heading(get_string("sitefilesusage", 'report_coursesize'));

        print '<strong>' . get_string("totalsitedata", 'report_coursesize', $totalusagereadable) . '</strong> ';

        print get_string('lastupdate', 'report_coursesize', $updatestring) . "<br/><br/>\n";

        print get_string('catsystemuse', 'report_coursesize', $systemsizereadable) . "<br/>";

        print get_string('catsystembackupuse', 'report_coursesize', $systembackupreadable) . "<br/>";

        if (!empty($CFG->filessizelimit)) {

            print get_string("sizepermitted", 'report_coursesize', number_format($CFG->filessizelimit)) . "<br/>\n";

        }

    }

    $lastupdate = '';

    if (!$live) {

        if (empty($reportconfig->coursesizeupdated)) {

            $lastupdate = get_string('lastupdatenever', 'report_coursesize');

        } else {

            $lastupdate = get_string('lastupdate', 'report_coursesize', userdate($reportconfig->coursesizeupdated));

        }

        $lastupdate = html_writer::span($lastupdate, 'lastupdate');

    }

    $heading = get_string('coursesize', 'report_coursesize');

    if (!empty($coursecat)) {

        $heading .= " - " . $coursecat->name;

    }

    print $OUTPUT->heading($heading . ' ' . $lastupdate);

    $desc = get_string('coursesize_desc', 'report_coursesize');

    if (!REPORT_COURSESIZE_SHOWEMPTYCOURSES) {

        $desc .= ' ' . get_string('emptycourseshidden', 'report_coursesize');

    }

    print $OUTPUT->box($desc);

    $filter = $OUTPUT->single_select($url, 'category', $options, $coursecategory, []);

    $filter .= $OUTPUT->single_button(new moodle_url('index.php', array('download' => 1, 'category' => $coursecategory)),

        get_string('exportcsv', 'report_coursesize'), 'post', ['class' => 'coursesizedownload']);

    print $OUTPUT->box($filter) . "<br/>";

    print html_writer::table($coursetable);

}

print $OUTPUT->footer();