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

/**

 * Page to import grades directly from a spreadsheet (Excel or Libre Office):

 *

 * @package   gradeimport

 * @copyright 2007 Moodle Pty Ltd (http://moodle.com)

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

 */

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

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

require_once($CFG->dirroot . '/grade/lib.php');

require_once($CFG->dirroot . '/grade/import/grade_import_form.php');

require_once($CFG->dirroot . '/grade/import/lib.php');

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

$id            = required_param('id', PARAM_INT); // Course id.

$verbosescales = optional_param('verbosescales', 1, PARAM_BOOL);

$iid           = optional_param('iid', null, PARAM_INT);

$importcode    = optional_param('importcode', '', PARAM_FILE);

$forceimport   = optional_param('forceimport', false, PARAM_BOOL);

$url = new moodle_url('/grade/import/direct/index.php', array('id' => $id));

if ($verbosescales !== 1) {

    $url->param('verbosescales', $verbosescales);

}

$PAGE->set_url($url);

if (!$course = $DB->get_record('course', array('id' => $id))) {

    throw new \moodle_exception('invalidcourseid');

}

require_login($course);

$context = context_course::instance($id);

require_capability('moodle/grade:import', $context);

require_capability('gradeimport/direct:view', $context);

$separatemode = (groups_get_course_groupmode($COURSE) == SEPARATEGROUPS and

        !has_capability('moodle/site:accessallgroups', $context));

$currentgroup = groups_get_course_group($course);

$actionbar = new \core_grades\output\import_action_bar($context, null, 'direct');

print_grade_page_head($course->id, 'import', 'direct', get_string('pluginname', 'gradeimport_direct'), false, false, true,

    'userdata', 'gradeimport_direct', null, $actionbar);

$renderer = $PAGE->get_renderer('gradeimport_csv');

// Get the grade items to be matched with the import mapping columns.

$gradeitems = gradeimport_csv_load_data::fetch_grade_items($course->id);

// If the csv file hasn't been imported yet then look for a form submission or

// show the initial submission form.

if (!$iid) {

    // Set up the import form.

    $mform = new gradeimport_direct_import_form(null, array('includeseparator' => true, 'verbosescales' => true, 'acceptedtypes' =>

        array('.csv', '.txt')));

    // If the import form has been submitted.

    if ($formdata = $mform->get_data()) {

        $text = $formdata->userdata;

        $csvimport = new gradeimport_csv_load_data();

        $csvimport->load_csv_content($text, $formdata->encoding, 'tab', $formdata->previewrows);

        $csvimporterror = $csvimport->get_error();

        if (!empty($csvimporterror)) {

            echo $renderer->errors(array($csvimport->get_error()));

            echo $OUTPUT->footer();

            die();

        }

        $iid = $csvimport->get_iid();

        echo $renderer->import_preview_page($csvimport->get_headers(), $csvimport->get_previewdata());

    } else {

        // Display the standard upload file form.

        echo $renderer->standard_upload_file_form($course, $mform);

        echo $OUTPUT->footer();

        die();

    }

}

// Data has already been submitted so we can use the $iid to retrieve it.

$csvimport = new csv_import_reader($iid, 'grade');

$header = $csvimport->get_columns();

// Get a new import code for updating to the grade book.

if (empty($importcode)) {

    $importcode = get_new_importcode();

}

$mappingformdata = array(

    'gradeitems' => $gradeitems,

    'header' => $header,

    'iid' => $iid,

    'id' => $id,

    'forceimport' => $forceimport,

    'importcode' => $importcode,

    'verbosescales' => $verbosescales

);

// We create a form to handle mapping data from the file to the database.

$mform2 = new gradeimport_direct_mapping_form(null, $mappingformdata);

// Here, if we have data, we process the fields and enter the information into the database.

if ($formdata = $mform2->get_data()) {

    $gradeimport = new gradeimport_csv_load_data();

    $status = $gradeimport->prepare_import_grade_data($header, $formdata, $csvimport, $course->id, $separatemode, $currentgroup,

            $verbosescales);

    // At this stage if things are all ok, we commit the changes from temp table.

    if ($status) {

        grade_import_commit($course->id, $importcode);

    } else {

        $errors = $gradeimport->get_gradebookerrors();

        $errors[] = get_string('importfailed', 'grades');

        echo $renderer->errors($errors);

    }

    echo $OUTPUT->footer();

} else {

    // If data hasn't been submitted then display the data mapping form.

    $mform2->display();

    echo $OUTPUT->footer();

}