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

/**
 * View logs page for plagiarism_turnitin component
 *
 * @package   plagiarism_turnitin
 * @copyright 2019 Turnitin
 * @author    2019 David Winn <dwinn@turnitin.com>
 * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

// Require libs.
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
require_once($CFG->libdir.'/adminlib.php');
require_once($CFG->dirroot.'/plagiarism/turnitin/classes/turnitin_view.class.php');

$cssurl = new moodle_url('/plagiarism/turnitin/styles.css');
$PAGE->requires->css($cssurl);

// Restrict access to admins only.
require_login();
admin_externalpage_setup('plagiarismturnitin');
$context = context_system::instance();
require_capability('moodle/site:config', $context, $USER->id, true, "nopermissions");

// Get table and dataformat if passed in, otherwise show list of logs.
$table = optional_param('table', null, PARAM_ALPHANUMEXT);
$dataformat = optional_param('dataformat', null, PARAM_ALPHANUMEXT);

$turnitinview = new turnitin_view();

$exportfile = "export_".$table."_".date('Y-m-d_His');

// Use Moodle's dataformatting functions to display a form to download output in different formats.
$tables = array(
    'plagiarism_turnitin_files',
    'plagiarism_turnitin_config',
    'plagiarism_turnitin_users',
    'plagiarism_turnitin_courses',
    'plagiarism_turnitin_peermark'
);

// If a table has been passed in then export that table data.
if (!is_null($table)) {
    if (in_array($table, $tables)) {

        raise_memory_limit(MEMORY_EXTRA);

        $data = $DB->get_records($table, null, 'id ASC');

        // Use Moodle's dataformatting functions to output the data in the desired format.
        \core\dataformat::download_data($exportfile, $dataformat, array_keys($DB->get_columns($table)), $data);
        exit;

    } else {
        $output = html_writer::tag('div', get_string('invalidtablename', 'plagiarism_turnitin', $table));
    }

} else {
    $downloadoptions = "";
    foreach ($tables as $table) {
        $downloadoptions .= $OUTPUT->download_dataformat_selector(
            get_string('dbexporttable', 'plagiarism_turnitin', $table),
            'dbexport.php',
            'dataformat',
            array('table' => $table)
        );
    }

    $output = html_writer::tag('div', $downloadoptions, array('class' => 'turnitin_setup_download_links'));
}

echo $OUTPUT->header();
echo $OUTPUT->heading(get_string('pluginname', 'plagiarism_turnitin'), '2', 'main');
$turnitinview->draw_settings_tab_menu('dbexport');
echo $output;

echo $OUTPUT->footer();