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

use core_question\local\bank\question_edit_contexts;

use core_question\local\bank\view;

use moodle_url;

use stdClass;

/**

 * Custom view class for the history page.

 *

 * @package    qbank_history

 * @copyright  2022 Catalyst IT Australia Pty Ltd

 * @author     Safat Shahin <safatshahin@catalyst-au.net>

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

 */

class question_history_view extends view {

    /**

     * Entry id to get the versions

     *

     * @var int $entryid

     */

    protected $entryid;

    /**

     * Base url for the return.

     *

     * @var \moodle_url $basereturnurl

     */

    protected $basereturnurl;

    /**

     * Constructor for the history.

     * @param question_edit_contexts $contexts the contexts of api call

     * @param moodle_url $pageurl url of the page

     * @param stdClass $course course settings

     * @param stdClass|null $cm (optional) activity settings.

     * @param array $params the parameters required to initialize the api.

     * @param array $extraparams any extra parameters need to initialized if the api is extended, it will be passed to js.

     * @throws \moodle_exception

     */

    public function __construct(

        question_edit_contexts $contexts,

        moodle_url $pageurl,

        stdClass $course,

        stdClass $cm = null,

        array $params = [],

        array $extraparams = [],

    ) {

        $this->entryid = $extraparams['entryid'];

        $this->basereturnurl = new \moodle_url($extraparams['returnurl']);

        parent::__construct($contexts, $pageurl, $course, $cm, $params, $extraparams);

    }

    protected function init_question_actions(): void {

        parent::init_question_actions();

        unset($this->questionactions['qbank_history\history_action']);

    }

    protected function wanted_columns(): array {

        $this->requiredcolumns = [];

        $questionbankcolumns = $this->get_question_bank_plugins();

        foreach ($questionbankcolumns as $classobject) {

            if (empty($classobject)) {

                continue;

            }

            $this->requiredcolumns[$classobject->get_column_name()] = $classobject;

        }

        return $this->requiredcolumns;

    }

    protected function display_advanced_search_form($advancedsearch): void {

        foreach ($advancedsearch as $searchcondition) {

            echo $searchcondition->display_options_adv();

        }

    }

    public function allow_add_questions(): bool {

        // As we dont want to create questions in this page.

        return false;

    }

    /**

     * Default sort for question data.

     * @return array

     */

    protected function default_sort(): array {

        $defaultsort = [];

        if (class_exists('\\qbank_viewcreator\\creator_name_column')) {

            $sort = 'qbank_viewcreator\creator_name_column-timecreated';

        }

        $defaultsort[$sort] = 1;

        return $defaultsort;

    }

    protected function build_query(): void {

        // Get the required tables and fields.

        [$fields, $joins] = $this->get_component_requirements(array_merge($this->requiredcolumns, $this->questionactions));

        // Build the order by clause.

        $sorts = [];

        foreach ($this->sort as $sortname => $sortorder) {

            list($colname, $subsort) = $this->parse_subsort($sortname);

            $sorts[] = $this->requiredcolumns[$colname]->sort_expression($sortorder == SORT_DESC, $subsort);

        }

        // Build the where clause.

        $entryid = "qbe.id = $this->entryid";

        // Changes done here to get the questions only for the passed entryid.

        $tests = ['q.parent = 0', $entryid];

        $this->sqlparams = [];

        foreach ($this->searchconditions as $searchcondition) {

            if ($searchcondition->where()) {

                $tests[] = '((' . $searchcondition->where() .'))';

            }

            if ($searchcondition->params()) {

                $this->sqlparams = array_merge($this->sqlparams, $searchcondition->params());

            }

        }

        // Build the SQL.

        $sql = ' FROM {question} q ' . implode(' ', $joins);

        $sql .= ' WHERE ' . implode(' AND ', $tests);

        $this->countsql = 'SELECT count(1)' . $sql;

        $this->loadsql = 'SELECT ' . implode(', ', $fields) . $sql . ' ORDER BY ' . implode(', ', $sorts);

    }

    /**

     * Display the header for the question bank in the history page to include question name and type.

     */

    public function display_question_bank_header(): void {

        global $PAGE, $DB, $OUTPUT;

        $sql = 'SELECT q.*

                 FROM {question} q

                 JOIN {question_versions} qv ON qv.questionid = q.id

                 JOIN {question_bank_entries} qbe ON qbe.id = qv.questionbankentryid

                WHERE qv.version  = (SELECT MAX(v.version)

                                       FROM {question_versions} v

                                       JOIN {question_bank_entries} be

                                         ON be.id = v.questionbankentryid

                                      WHERE be.id = qbe.id)

                  AND qbe.id = ?';

        $latestquestiondata = $DB->get_record_sql($sql, [$this->entryid]);

        if ($latestquestiondata) {

            $historydata = [

                'questionname' => $latestquestiondata->name,

                'returnurl' => $this->basereturnurl,

                'questionicon' => print_question_icon($latestquestiondata)

            ];

            // Header for the page before the actual form from the api.

            echo $PAGE->get_renderer('qbank_history')->render_history_header($historydata);

        } else {

            // Continue when all the question versions are deleted.

            echo $OUTPUT->notification(get_string('allquestionversionsdeleted', 'qbank_history'), 'notifysuccess');

            echo $OUTPUT->continue_button($this->basereturnurl);

        }

    }

    public function is_listing_specific_versions(): bool {

        return true;

    }

    /**

     * Override wanted_filters so that we apply the filters provided by the URL, but don't display the filter UI.

     *

     * @return void

     */

    public function wanted_filters(): void {

        $this->display_question_bank_header();

        // Add search conditions.

        $this->add_standard_search_conditions();

    }

}