Gecko [ admjudic.com.br ]

Name	Size	Permission
classes	[ DIR ]	drwxr-xr-x
db	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
tests	[ DIR ]	drwxr-xr-x
README-fr.md	5.04 KB	-rw-r--r--
README.md	4.06 KB	-rw-r--r--
cloud.php	25.87 KB	-rw-r--r--
dump.php	2.46 KB	-rw-r--r--
example.csv	1.42 KB	-rw-r--r--
export.php	2.61 KB	-rw-r--r--
grade_export_apogee.php	5.98 KB	-rw-r--r--
grade_export_apogee_form.php	6.13 KB	-rw-r--r--
index.php	2.13 KB	-rw-r--r--
lock.php	358.07 KB	-rw-r--r--
settings.php	2.59 KB	-rw-r--r--
version.php	1.23 KB	-rw-r--r--

Code Editor : grade_export_apogee.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/>.

/**
 * Function used in export process.
 *
 * @package    gradeexport_apogee
 * @author     Anthony Durif - Université Clermont Auvergne
 * @copyright  2019 Anthony Durif - Université Clermont Auvergne
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require_once($CFG->dirroot . '/grade/export/lib.php');
require_once($CFG->libdir . '/csvlib.class.php');
require_once('classes/custom_csv_export_writer.php');

/**
 * Privacy Subsystem implementation for gradeexport_apogee.
 *
 * @package    gradeexport_apogee
 * @copyright  2019 Anthony Durif - Université Clermont Auvergne
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
class grade_export_apogee extends grade_export {

/*
     * Plugin name.
     */
    public $plugin = 'apogee';

/*
     * Form datas.
     */
    public $datas;

/*
     * Array const variable with all differents dilimiters we can use.
     */
    const DELIMITERS = ['semicolon' => ';', 'comma' => ',', 'tab' => '/t'];

/**
     * Constructor should set up all the private variables ready to be pulled.
     * @param object $course The course.
     * @param stdClass $formdata The validated data from the grade export form.
     * @param stdClass $form The form.
     */
    public function __construct($course, $formdata) {
        parent::__construct($course, 0, $formdata);

// Overrides.
        $this->usercustomfields = true;
        $this->datas = $formdata;
    }

/**
     * Returns array of parameters used by dump.php and export.php.
     * @return array
     */
    public function get_export_params() {
        $params = parent::get_export_params();
        return $params;
    }

/**
     * Implemented by child class.
     */
    public function print_grades() {
        global $DB;

$content = $this->datas->content;
        $csv = str_getcsv($content, "\n");
        $process = false;

//$csvexport = new csv_export_writer($this->datas->delimiter);
        // We call our custom export_writer class and use a custom enclosure, we choose an enclosure (~) with low chances to be in the exported source file.
        // We add these custom export_writer and  enclosure uses because default enclose (") can cause a bug with composed names.
        $csvexport = new custom_csv_export_writer($this->datas->delimiter, "~");
        $shortname = format_string($this->course->shortname, true, array('context' => context_course::instance($this->course->id)));
        $downloadfilename = clean_filename($shortname . get_string('grades'));
        $csvexport->set_filename($downloadfilename);

$item = $DB->get_record('grade_items', array('id' => $this->datas->item));
        $bareme = ($item) ? $item->grademax : "";
        $startlistdelimiter = get_config('gradeexport_apogee', 'startlist_delimiter');

foreach ($csv as $key => $row) {
            $row = str_getcsv($row, $this::DELIMITERS[$this->datas->delimiter]);
            if (($row[0] == $startlistdelimiter && !$process) || $startlistdelimiter == null) {
                // Test if the line is the header of the users list. If it is we change the flag $process to start the use of this list with the next line.
                // We also start the process if the configuration variable $startlistdelimiter is not used/defined.
                $process = true;
            }
            if ($process && is_numeric($row[0])) {
                // Read the file content.
                // We check if the first column contains numeric because we use this code to match with idnumber user.
                $mapping = get_config('gradeexport_apogee', 'mapping_type');
                try {
                    $user = ($mapping == "idnumber") ? $DB->get_record('user', array('idnumber' => $row[0], 'confirmed' => 1))
                        : $DB->get_record('user', array('lastname' => $row[1], 'firstname' => $row[2], 'confirmed' => 1));
                }
                catch (Exception $e) { continue; }

if ($user) {
                    if (isset($this->datas->abi) && in_array($user->id, $this->datas->abi)) {
                        // Update of the content with no bareme and specific "ABI" note of this user.
                        $row[4] = "ABI";
                        $row[5] = "";
                    } elseif (isset($this->datas->abj) && in_array($user->id, $this->datas->abj)) {
                        // Update of the content with no bareme and specific "ABJ" note of this user.
                        $row[4] = "ABJ";
                        $row[5] = "";
                    } else {
                        $sql = 'SELECT *  FROM {grade_grades}
                                WHERE itemid = :item 
                                AND userid = :user 
                                AND finalgrade IS NOT NULL';
                        $grade = $DB->get_record_sql($sql, array('item' => $item->id, 'user' => $user->id));
                        if ($grade) {
                            // Update of the content with the item bareme and the item grade of this user.
                            $row[4] = round($grade->finalgrade, 3);
                            $row[5] = round($bareme);
                        }
                    }
                }
            }

$csvexport->add_data($row);
        }

$csvexport->download_file();
        exit;
    }
}

${this.title}

Code Editor : grade_export_apogee.php