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

namespace tool_brickfield;

use tool_brickfield\local\tool\filter;

use tool_brickfield\local\tool\tool;

/**

 * Provides the Brickfield Accessibility toolkit site data API.

 *

 * @package    tool_brickfield

 * @copyright  2020 onward Brickfield Education Labs Ltd, https://www.brickfield.ie

 * @author     Mike Churchward (mike@brickfieldlabs.ie)

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

 */

class sitedata {

    /** @var array An array of SQL parts to build an SQL statement. */

    private $sqlparts = ['SELECT' => [], 'FROM' => '', 'WHERE' => '', 'GROUPBY' => '', 'ORDERBY' => ''];

    /** @var array An array of SQL parameters. */

    private $sqlparams = [];

    /** @var array An array of labels to be displayed. */

    private $grouplabels = [];

    /** @var array An array of the used check group numbers. */

    private $groupnumbers = [];

    /** @var int The count of group labels. */

    private $groupcount = 0;

    /**

     * Return the total number of courses that have been checked.

     * @return int

     * @throws \dml_exception

     */

    public static function get_total_courses_checked(): int {

        global $DB;

        return $DB->count_records_select(manager::DB_AREAS, '', [], 'COUNT(DISTINCT courseid)');

    }

    /**

     * Get records of component per course summary data.

     * @param local\tool\filter $filter

     * @return array

     * @throws \coding_exception

     * @throws \dml_exception

     */

    public static function get_component_data(filter $filter): array {

        global $DB;

        $data = [];

        if ($filter->validate_filters()) {

            list($wheresql, $params) = $filter->get_course_sql('', true);

            $sql = 'SELECT component, SUM(errorcount) as errorsum, SUM(totalactivities) as total, ' .

                'SUM(failedactivities) as failed, SUM(passedactivities) as passed ' .

                'FROM {' . manager::DB_CACHEACTS . '} area ' .

                (empty($wheresql) ? '' : ('WHERE ' . $wheresql . ' ')) .

                'GROUP BY area.component ' .

                'ORDER BY area.component ASC';

            $data = $DB->get_records_sql($sql, $params);

            foreach ($data as $key => $componentsummary) {

                $data[$key]->componentlabel = tool::get_module_label($componentsummary->component);

            }

        }

        return $data;

    }

    /**

     * Get records of check group per course summary data.

     * @param local\tool\filter $filter

     * @return array

     * @throws \coding_exception

     * @throws \dml_exception

     */

    public function get_checkgroup_data(filter $filter): array {

        global $DB;

        $data = [];

        if ($filter->validate_filters()) {

            $this->get_base_checkgroup_sql($filter);

            $sql = $this->get_select_string() . ' ' .

                'FROM ' . $this->sqlparts['FROM'] . ' ' .

                (!empty($this->sqlparts['WHERE']) ? 'WHERE ' . $this->sqlparts['WHERE'] . ' ' : '') .

                (!empty($this->sqlparts['GROUPBY']) ? 'GROUP BY ' . $this->sqlparts['GROUPBY'] . ' ' : '') .

                (!empty($this->sqlparts['ORDERBY']) ? 'ORDER BY ' . $this->sqlparts['ORDERBY'] . ' ' : '');

            $data = array_values($DB->get_records_sql($sql, $this->sqlparams,

                ($filter->page * $filter->perpage), $filter->perpage));

            if (empty($data)) {

                $data[0] = (object)(array_values($this->grouplabels));

            } else {

                $data[0] = (object)(array_merge((array)$data[0], $this->grouplabels));

            }

            $data[0]->groupcount = $this->groupcount;

        }

        return $data;

    }

    /**

     * Get records of check group per course summary data.

     * @param local\tool\filter $filter

     * @return array

     * @throws \coding_exception

     * @throws \dml_exception

     */

    public function get_checkgroup_by_course_data(filter $filter): array {

        $this->sqlparts['GROUPBY'] = 'courseid';

        $this->add_select_item('courseid');

        return $this->get_checkgroup_data($filter);

    }

    /**

     * Get records of check group per course summary data.

     * @param local\tool\filter $filter

     * @return array

     * @throws \coding_exception

     * @throws \dml_exception

     */

    public function get_checkgroup_with_failed_data(filter $filter): array {

        $this->add_select_item('SUM(activitiesfailed) as failed');

        return $this->get_checkgroup_data($filter);

    }

    /**

     * Load up the base SQL parts.

     * @param filter $filter

     * @throws \coding_exception

     * @throws \dml_exception

     */

    private function get_base_checkgroup_sql(filter $filter) {

        if ($filter->validate_filters()) {

            $this->get_grouplabel_info();

            list($this->sqlparts['WHERE'], $this->sqlparams) = $filter->get_course_sql('summ', true);

            $this->add_select_item('SUM(activities) as activities');

            foreach ($this->groupnumbers as $lab) {

                $this->add_select_item("SUM(errorschecktype$lab) as errorsvalue$lab");

                $this->add_select_item("SUM(failedchecktype$lab) as failedvalue$lab");

                $this->add_select_item("AVG(percentchecktype$lab) as percentvalue$lab");

            }

            $this->sqlparts['FROM'] = '{' . manager::DB_SUMMARY . '} summ';

        }

    }

    /**

     * Load the group label information.

     * @throws \coding_exception

     * @throws \dml_exception

     */

    private function get_grouplabel_info() {

        global $DB;

        // Don't need to do this more than once.

        if (empty($this->grouplabels)) {

            // Determine the checkgroups being used by this site.

            $labelsql = 'SELECT DISTINCT checkgroup, checkgroup as cg2 FROM {' . manager::DB_CHECKS . '} ' .

                'WHERE status = ? ORDER BY checkgroup ASC';

            $groupvals = $DB->get_records_sql_menu($labelsql, [1]);

            $grouplabels = array_intersect_key(area_base::CHECKGROUP_NAMES, $groupvals);

            foreach ($grouplabels as $lab => $label) {

                $this->grouplabels['componentlabel' . $lab] = get_string('checktype:' . $label, manager::PLUGINNAME);

                $this->groupnumbers[] = $lab;

                $this->groupcount++;

            }

        }

    }

    /**

     * Add a select item to the sqlparts array.

     * @param string $item

     */

    private function add_select_item(string $item): void {

        $this->sqlparts['SELECT'][] = $item;

    }

    /**

     * Assemble and return the select portion of the sql.

     * @return string

     */

    private function get_select_string(): string {

        return 'SELECT ' . implode(', ', $this->sqlparts['SELECT']);

    }

}