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 qbank_viewquestiontext;

use core\output\datafilter;
use core_question\local\bank\condition;

/**
 * Filter for question text and question feedback text.
 *
 * @package    qbank_viewquestiontext
 * @copyright  2025 onwards Catalyst IT {@link http://www.catalyst-eu.net/}
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 * @author     Conn Warwicker <conn.warwicker@catalyst-eu.net>
 */
class questiontext_condition extends condition {

    #[\Override]
    public function get_title(): string {
        return get_string('questiontext_condition', 'qbank_viewquestiontext');
    }

    #[\Override]
    public static function get_condition_key(): string {
        return 'questiontext';
    }

    #[\Override]
    public function get_filter_class() {
        return 'core/datafilter/filtertypes/keyword';
    }

    #[\Override]
    public static function build_query_from_filter(array $filter): array {

        global $DB;

        // Are we inverting the search to look for where NOT like?
        $notlike = ($filter['jointype'] === datafilter::JOINTYPE_NONE);

        [$params, $conditions] = [[], []];

        // Loop through the values we've sent from the filter.
        foreach ($filter['values'] as $key => $value) {

            $params['questiontext_' . $key] = '%' . $value . '%';
            $params['questiontext_f_' . $key] = '%' . $value . '%';

            $condition = $DB->sql_like(
                'q.questiontext', ':questiontext_' . $key, false, true, $notlike
            );
            $condition .= ($notlike) ? ' AND ' : ' OR ';
            $condition .= $DB->sql_like(
                'q.generalfeedback', ':questiontext_f_' . $key, false, true, $notlike
            );
            $conditions[] = '(' . $condition . ')';

        }

        $delimiter = ($filter['jointype'] === datafilter::JOINTYPE_ANY) ? ' OR ' : ' AND ';
        return [
            implode($delimiter, $conditions),
            $params,
        ];

    }
}