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

/**
 * Field definitions.
 *
 * @package    block_dash
 * @copyright  2019 bdecent gmbh <https://bdecent.de>
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

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

if (!defined('AJAX_SCRIPT')) {
    define('AJAX_SCRIPT', true);
}

require_login();

use block_dash\local\block_builder;

$download = optional_param('download', 'csv', PARAM_TEXT);
$instanceid = required_param('block_instance_id', PARAM_INT);
$filterformdata = optional_param('filter_form_data', '', PARAM_TEXT);
$currentpage = optional_param('page', 0, PARAM_INT);
$sortfield = optional_param('sort_field', '', PARAM_TEXT);
$sortdir = optional_param('sort_direction', '', PARAM_TEXT);

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

$renderer = $PAGE->get_renderer('block_dash');
$binstance = $DB->get_record('block_instances', ['id' => $instanceid]);
$block = block_instance($binstance->blockname, $binstance);
if ($sortfield) {
    $block->set_sort($sortfield, $sortdir);
}
$bbdownload = block_builder::create($block);
if (!$bbdownload->get_configuration()->get_data_source()->get_preferences('exportdata') ) {
    return false;
}
foreach (json_decode($filterformdata, true) as $filter) {
    $bbdownload->get_configuration()
        ->get_data_source()
        ->get_filter_collection()
        ->apply_filter($filter['name'], $filter['value']);
}
$bbdownload->get_configuration()->get_data_source()->get_paginator()->set_current_page($currentpage);
$bbdownloadsource = $bbdownload->get_configuration()->get_data_source();
$file = $bbdownload->get_configuration()->get_data_source()->get_name();
$filename = $file . "_" . get_string('strdatasource', 'block_dash');
if ($download == "xls") {
    require_once("$CFG->libdir/excellib.class.php");
    // Calculate file name.
    // Creating a workbook.
    $workbook = new \MoodleExcelWorkbook("-");
    // Send HTTP headers.
    $filename .= "_" . time();
    $workbook->send($filename);
    // Creating the first worksheet.
    $myxls = $workbook->add_worksheet('dash');
    // Print names of all the fields.
    $i = 0;
    foreach ($bbdownloadsource->export_for_template($renderer)['data']->first_child()['data'] as $col) {
        if ($col->is_visible()) {
            $myxls->write_string(0, $i++, $col->get_label());
        }
    }
    $rowdata = $bbdownloadsource->export_for_template($renderer)['data']['rows'];
    if ($rowdata) {
        // Generate the data for the body of the spreadsheet.
        $j = 1;
        foreach ($rowdata as $row) {
            $fields = [];
            $k = 0;
            foreach ($row['data'] as $data) {
                if ($data->is_visible()) {
                    $myxls->write_string($j, $k++, trim(strip_tags(format_text($data->get_value(), true))));
                }
            }
            $j++;
        }
    }
    // Close the workbook.
    $workbook->close();
} else if ($download == 'csv') {
    require_once("$CFG->libdir/csvlib.class.php");
    $csvexport = new \csv_export_writer("-");
    $csvexport->set_filename($filename);
    $headers = [];
    foreach ($bbdownloadsource->export_for_template($renderer)['data']->first_child()['data'] as $col) {
        if ($col->is_visible()) {
            $headers[] = $col->get_label();
        }
    }
    $csvexport->add_data($headers);
    $rowdata = $bbdownloadsource->export_for_template($renderer)['data']['rows'];
    if ($rowdata) {
        foreach ($rowdata as $row) {
            $cols = [];
            foreach ($row['data'] as $data) {
                if ($data->is_visible()) {
                    $cols[] = trim(strip_tags(format_text($data->get_value(), true)));
                }
            }
            $csvexport->add_data($cols);
        }
    }
    $csvexport->download_file();
}