See Release Notes
Long Term Support Release
<?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/>. declare(strict_types=1); namespace core_reportbuilder\local\aggregation; use lang_string; use core_reportbuilder\local\report\column; /** * Column average aggregation type * * @package core_reportbuilder * @copyright 2021 Paul Holden <paulh@moodle.com> * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class avg extends base { /** * Return aggregation name * * @return lang_string */ public static function get_name(): lang_string { return new lang_string('aggregationavg', 'core_reportbuilder'); } /** * This aggregation can be performed on all numeric columns * * @param int $columntype * @return bool */ public static function compatible(int $columntype): bool { return in_array($columntype, [ column::TYPE_INTEGER, column::TYPE_FLOAT, column::TYPE_BOOLEAN, ]); } /** * Return the aggregated field SQL * * @param string $field * @param int $columntype * @return string */ public static function get_field_sql(string $field, int $columntype): string { return "AVG(1.0 * {$field})"; } /** * Return formatted value for column when applying aggregation *> * For boolean columns we return the average of the values (0..1), numeric columns execute original callbacks if present * @param mixed $value > ** @param array $values * @param array $callbacks> * @param int $columntype* @return mixed */< public static function format_value($value, array $values, array $callbacks) {> public static function format_value($value, array $values, array $callbacks, int $columntype) {if (reset($values) === null) { return null; }> if ($columntype === column::TYPE_BOOLEAN || empty($callbacks)) {return format_float((float) reset($values), 1);> } } > } > return parent::format_value($value, $values, $callbacks, $columntype);