MDL-74741 javascript: A11y fix for dialogues visible from beginning
[moodle.git] / question / editlib.php
blob4f739c7499e2a1f01dbc094550e3ea098c364173
1 <?php
2 // This file is part of Moodle - http://moodle.org/
3 //
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
8 //
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
17 /**
18 * Functions used to show question editing interface
20 * @package moodlecore
21 * @subpackage questionbank
22 * @copyright 1999 onwards Martin Dougiamas and others {@link http://moodle.com}
23 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
27 use core_question\bank\search\category_condition;
29 defined('MOODLE_INTERNAL') || die();
31 require_once($CFG->libdir . '/questionlib.php');
33 define('DEFAULT_QUESTIONS_PER_PAGE', 100);
34 define('MAXIMUM_QUESTIONS_PER_PAGE', 4000);
36 function get_module_from_cmid($cmid) {
37 global $CFG, $DB;
38 if (!$cmrec = $DB->get_record_sql("SELECT cm.*, md.name as modname
39 FROM {course_modules} cm,
40 {modules} md
41 WHERE cm.id = ? AND
42 md.id = cm.module", array($cmid))){
43 print_error('invalidcoursemodule');
44 } elseif (!$modrec =$DB->get_record($cmrec->modname, array('id' => $cmrec->instance))) {
45 print_error('invalidcoursemodule');
47 $modrec->instance = $modrec->id;
48 $modrec->cmid = $cmrec->id;
49 $cmrec->name = $modrec->name;
51 return array($modrec, $cmrec);
54 /**
55 * Function to read all questions for category into big array
57 * @param object $category category number
58 * @param bool $noparent if true only questions with NO parent will be selected
59 * @param bool $recurse include subdirectories
60 * @param bool $export set true if this is called by questionbank export
61 * @param bool $latestversion if only the latest versions needed
62 * @return array
64 function get_questions_category(object $category, bool $noparent, bool $recurse = true, bool $export = true,
65 bool $latestversion = false): array {
66 global $DB;
68 // Build sql bit for $noparent.
69 $npsql = '';
70 if ($noparent) {
71 $npsql = " and q.parent='0' ";
74 // Get list of categories.
75 if ($recurse) {
76 $categorylist = question_categorylist($category->id);
77 } else {
78 $categorylist = [$category->id];
81 // Get the list of questions for the category.
82 list($usql, $params) = $DB->get_in_or_equal($categorylist);
84 // Get the latest version of a question.
85 $version = '';
86 if ($latestversion) {
87 $version = 'AND (qv.version = (SELECT MAX(v.version)
88 FROM {question_versions} v
89 JOIN {question_bank_entries} be
90 ON be.id = v.questionbankentryid
91 WHERE be.id = qbe.id) OR qv.version is null)';
93 $questions = $DB->get_records_sql("SELECT q.*, qv.status, qc.id AS category
94 FROM {question} q
95 JOIN {question_versions} qv ON qv.questionid = q.id
96 JOIN {question_bank_entries} qbe ON qbe.id = qv.questionbankentryid
97 JOIN {question_categories} qc ON qc.id = qbe.questioncategoryid
98 WHERE qc.id {$usql} {$npsql} {$version}
99 ORDER BY qc.id, q.qtype, q.name", $params);
101 // Iterate through questions, getting stuff we need.
102 $qresults = [];
103 foreach($questions as $key => $question) {
104 $question->export_process = $export;
105 $qtype = question_bank::get_qtype($question->qtype, false);
106 if ($export && $qtype->name() === 'missingtype') {
107 // Unrecognised question type. Skip this question when exporting.
108 continue;
110 $qtype->get_question_options($question);
111 $qresults[] = $question;
114 return $qresults;
118 * Checks whether this is the only child of a top category in a context.
120 * @param int $categoryid a category id.
121 * @return bool
122 * @deprecated since Moodle 4.0 MDL-71585
123 * @see qbank_managecategories\helper
124 * @todo Final deprecation on Moodle 4.4 MDL-72438
126 function question_is_only_child_of_top_category_in_context($categoryid) {
127 debugging('Function question_is_only_child_of_top_category_in_context()
128 has been deprecated and moved to qbank_managecategories plugin,
129 Please use qbank_managecategories\helper::question_is_only_child_of_top_category_in_context() instead.',
130 DEBUG_DEVELOPER);
131 return \qbank_managecategories\helper::question_is_only_child_of_top_category_in_context($categoryid);
135 * Checks whether the category is a "Top" category (with no parent).
137 * @param int $categoryid a category id.
138 * @return bool
139 * @deprecated since Moodle 4.0 MDL-71585
140 * @see qbank_managecategories\helper
141 * @todo Final deprecation on Moodle 4.4 MDL-72438
143 function question_is_top_category($categoryid) {
144 debugging('Function question_is_top_category() has been deprecated and moved to qbank_managecategories plugin,
145 Please use qbank_managecategories\helper::question_is_top_category() instead.', DEBUG_DEVELOPER);
146 return \qbank_managecategories\helper::question_is_top_category($categoryid);
150 * Ensures that this user is allowed to delete this category.
152 * @param int $todelete a category id.
153 * @deprecated since Moodle 4.0 MDL-71585
154 * @see qbank_managecategories\helper
155 * @todo Final deprecation on Moodle 4.4 MDL-72438
157 function question_can_delete_cat($todelete) {
158 debugging('Function question_can_delete_cat() has been deprecated and moved to qbank_managecategories plugin,
159 Please use qbank_managecategories\helper::question_can_delete_cat() instead.', DEBUG_DEVELOPER);
160 \qbank_managecategories\helper::question_can_delete_cat($todelete);
164 * Common setup for all pages for editing questions.
165 * @param string $baseurl the name of the script calling this funciton. For examle 'qusetion/edit.php'.
166 * @param string $edittab code for this edit tab
167 * @param bool $requirecmid require cmid? default false
168 * @param bool $unused no longer used, do no pass
169 * @return array $thispageurl, $contexts, $cmid, $cm, $module, $pagevars
171 function question_edit_setup($edittab, $baseurl, $requirecmid = false, $unused = null) {
172 global $PAGE;
174 if ($unused !== null) {
175 debugging('Deprecated argument passed to question_edit_setup()', DEBUG_DEVELOPER);
178 $params = [];
180 if ($requirecmid) {
181 $params['cmid'] = required_param('cmid', PARAM_INT);
182 } else {
183 $params['cmid'] = optional_param('cmid', null, PARAM_INT);
186 if (!$params['cmid']) {
187 $params['courseid'] = required_param('courseid', PARAM_INT);
190 $params['qpage'] = optional_param('qpage', null, PARAM_INT);
192 // Pass 'cat' from page to page and when 'category' comes from a drop down menu
193 // then we also reset the qpage so we go to page 1 of
194 // a new cat.
195 $params['cat'] = optional_param('cat', null, PARAM_SEQUENCE); // If empty will be set up later.
196 $params['category'] = optional_param('category', null, PARAM_SEQUENCE);
197 $params['qperpage'] = optional_param('qperpage', null, PARAM_INT);
199 // Question table sorting options.
200 for ($i = 1; $i <= core_question\local\bank\view::MAX_SORTS; $i++) {
201 $param = 'qbs' . $i;
202 if ($sort = optional_param($param, '', PARAM_TEXT)) {
203 $params[$param] = $sort;
204 } else {
205 break;
209 // Display options.
210 $params['recurse'] = optional_param('recurse', null, PARAM_BOOL);
211 $params['showhidden'] = optional_param('showhidden', null, PARAM_BOOL);
212 $params['qbshowtext'] = optional_param('qbshowtext', null, PARAM_BOOL);
213 // Category list page.
214 $params['cpage'] = optional_param('cpage', null, PARAM_INT);
215 $params['qtagids'] = optional_param_array('qtagids', null, PARAM_INT);
217 $PAGE->set_pagelayout('admin');
219 return question_build_edit_resources($edittab, $baseurl, $params);
223 * Common function for building the generic resources required by the
224 * editing questions pages.
226 * Either a cmid or a course id must be provided as keys in $params or
227 * an exception will be thrown. All other params are optional and will have
228 * sane default applied if not provided.
230 * The acceptable keys for $params are:
232 * 'cmid' => PARAM_INT,
233 * 'courseid' => PARAM_INT,
234 * 'qpage' => PARAM_INT,
235 * 'cat' => PARAM_SEQUENCE,
236 * 'category' => PARAM_SEQUENCE,
237 * 'qperpage' => PARAM_INT,
238 * 'recurse' => PARAM_INT,
239 * 'showhidden' => PARAM_INT,
240 * 'qbshowtext' => PARAM_INT,
241 * 'cpage' => PARAM_INT,
242 * 'recurse' => PARAM_BOOL,
243 * 'showhidden' => PARAM_BOOL,
244 * 'qbshowtext' => PARAM_BOOL,
245 * 'qtagids' => [PARAM_INT], (array of integers)
246 * 'qbs1' => PARAM_TEXT,
247 * 'qbs2' => PARAM_TEXT,
248 * 'qbs3' => PARAM_TEXT,
249 * ... and more qbs keys up to core_question\local\bank\view::MAX_SORTS ...
250 * ];
252 * @param string $edittab Code for this edit tab
253 * @param string $baseurl The name of the script calling this funciton. For examle 'qusetion/edit.php'.
254 * @param array $params The provided parameters to construct the resources with.
255 * @param int $defaultquestionsperpage number of questions per page, if not given in the URL.
256 * @return array $thispageurl, $contexts, $cmid, $cm, $module, $pagevars
258 function question_build_edit_resources($edittab, $baseurl, $params,
259 $defaultquestionsperpage = DEFAULT_QUESTIONS_PER_PAGE) {
260 global $DB;
262 $thispageurl = new moodle_url($baseurl);
263 $thispageurl->remove_all_params(); // We are going to explicity add back everything important - this avoids unwanted params from being retained.
265 $cleanparams = [
266 'qsorts' => [],
267 'qtagids' => []
269 $paramtypes = [
270 'cmid' => PARAM_INT,
271 'courseid' => PARAM_INT,
272 'qpage' => PARAM_INT,
273 'cat' => PARAM_SEQUENCE,
274 'category' => PARAM_SEQUENCE,
275 'qperpage' => PARAM_INT,
276 'recurse' => PARAM_INT,
277 'showhidden' => PARAM_INT,
278 'qbshowtext' => PARAM_INT,
279 'cpage' => PARAM_INT,
280 'recurse' => PARAM_BOOL,
281 'showhidden' => PARAM_BOOL,
282 'qbshowtext' => PARAM_BOOL
285 foreach ($paramtypes as $name => $type) {
286 if (isset($params[$name])) {
287 $cleanparams[$name] = clean_param($params[$name], $type);
288 } else {
289 $cleanparams[$name] = null;
293 if (!empty($params['qtagids'])) {
294 $cleanparams['qtagids'] = clean_param_array($params['qtagids'], PARAM_INT);
297 $cmid = $cleanparams['cmid'];
298 $courseid = $cleanparams['courseid'];
299 $qpage = $cleanparams['qpage'] ?: -1;
300 $cat = $cleanparams['cat'] ?: 0;
301 $category = $cleanparams['category'] ?: 0;
302 $qperpage = $cleanparams['qperpage'];
303 $recurse = $cleanparams['recurse'];
304 $showhidden = $cleanparams['showhidden'];
305 $qbshowtext = $cleanparams['qbshowtext'];
306 $cpage = $cleanparams['cpage'] ?: 1;
307 $recurse = $cleanparams['recurse'];
308 $showhidden = $cleanparams['showhidden'];
309 $qbshowtext = $cleanparams['qbshowtext'];
310 $qsorts = $cleanparams['qsorts'];
311 $qtagids = $cleanparams['qtagids'];
313 if (is_null($cmid) && is_null($courseid)) {
314 throw new \moodle_exception('Must provide a cmid or courseid');
317 if ($cmid) {
318 list($module, $cm) = get_module_from_cmid($cmid);
319 $courseid = $cm->course;
320 $thispageurl->params(compact('cmid'));
321 require_login($courseid, false, $cm);
322 $thiscontext = context_module::instance($cmid);
323 } else {
324 $module = null;
325 $cm = null;
326 $thispageurl->params(compact('courseid'));
327 require_login($courseid, false);
328 $thiscontext = context_course::instance($courseid);
331 if ($thiscontext){
332 $contexts = new core_question\local\bank\question_edit_contexts($thiscontext);
333 $contexts->require_one_edit_tab_cap($edittab);
334 } else {
335 $contexts = null;
338 $pagevars['qpage'] = $qpage;
340 // Pass 'cat' from page to page and when 'category' comes from a drop down menu
341 // then we also reset the qpage so we go to page 1 of
342 // a new cat.
343 if ($category && $category != $cat) { // Is this a move to a new category?
344 $pagevars['cat'] = $category;
345 $pagevars['qpage'] = 0;
346 } else {
347 $pagevars['cat'] = $cat; // If empty will be set up later.
350 if ($pagevars['cat']){
351 $thispageurl->param('cat', $pagevars['cat']);
354 if (strpos($baseurl, '/question/') === 0) {
355 navigation_node::override_active_url($thispageurl);
358 // This need to occur after the override_active_url call above because
359 // these values change on the page request causing the URLs to mismatch
360 // when trying to work out the active node.
361 for ($i = 1; $i <= core_question\local\bank\view::MAX_SORTS; $i++) {
362 $param = 'qbs' . $i;
363 if (isset($params[$param])) {
364 $value = clean_param($params[$param], PARAM_TEXT);
365 } else {
366 break;
368 $thispageurl->param($param, $value);
371 if ($pagevars['qpage'] > -1) {
372 $thispageurl->param('qpage', $pagevars['qpage']);
373 } else {
374 $pagevars['qpage'] = 0;
377 if ($defaultquestionsperpage == DEFAULT_QUESTIONS_PER_PAGE) {
378 $pagevars['qperpage'] = question_set_or_get_user_preference(
379 'qperpage', $qperpage, DEFAULT_QUESTIONS_PER_PAGE, $thispageurl);
380 } else {
381 $pagevars['qperpage'] = $qperpage ?? $defaultquestionsperpage;
384 $defaultcategory = question_make_default_categories($contexts->all());
386 $contextlistarr = [];
387 foreach ($contexts->having_one_edit_tab_cap($edittab) as $context){
388 $contextlistarr[] = "'{$context->id}'";
390 $contextlist = join(' ,', $contextlistarr);
391 if (!empty($pagevars['cat'])){
392 $catparts = explode(',', $pagevars['cat']);
393 if (!$catparts[0] || (false !== array_search($catparts[1], $contextlistarr)) ||
394 !$DB->count_records_select("question_categories", "id = ? AND contextid = ?", array($catparts[0], $catparts[1]))) {
395 print_error('invalidcategory', 'question');
397 } else {
398 $category = $defaultcategory;
399 $pagevars['cat'] = "{$category->id},{$category->contextid}";
402 // Display options.
403 $pagevars['recurse'] = question_set_or_get_user_preference('recurse', $recurse, 1, $thispageurl);
404 $pagevars['showhidden'] = question_set_or_get_user_preference('showhidden', $showhidden, 0, $thispageurl);
405 $pagevars['qbshowtext'] = question_set_or_get_user_preference('qbshowtext', $qbshowtext, 0, $thispageurl);
407 // Category list page.
408 $pagevars['cpage'] = $cpage;
409 if ($pagevars['cpage'] != 1){
410 $thispageurl->param('cpage', $pagevars['cpage']);
413 $pagevars['qtagids'] = $qtagids;
414 foreach ($pagevars['qtagids'] as $index => $qtagid) {
415 $thispageurl->param("qtagids[{$index}]", $qtagid);
418 return array($thispageurl, $contexts, $cmid, $cm, $module, $pagevars);
422 * Get the category id from $pagevars.
423 * @param array $pagevars from {@link question_edit_setup()}.
424 * @return int the category id.
426 function question_get_category_id_from_pagevars(array $pagevars) {
427 list($questioncategoryid) = explode(',', $pagevars['cat']);
428 return $questioncategoryid;
432 * Get a particular question preference that is also stored as a user preference.
433 * If the the value is given in the GET/POST request, then that value is used,
434 * and the user preference is updated to that value. Otherwise, the last set
435 * value of the user preference is used, or if it has never been set the default
436 * passed to this function.
438 * @param string $param the param name. The URL parameter set, and the GET/POST
439 * parameter read. The user_preference name is 'question_bank_' . $param.
440 * @param mixed $default The default value to use, if not otherwise set.
441 * @param int $type one of the PARAM_... constants.
442 * @param moodle_url $thispageurl if the value has been explicitly set, we add
443 * it to this URL.
444 * @return mixed the parameter value to use.
446 function question_get_display_preference($param, $default, $type, $thispageurl) {
447 $submittedvalue = optional_param($param, null, $type);
448 return question_set_or_get_user_preference($param, $submittedvalue, $default, $thispageurl);
452 * Get a user preference by name or set the user preference to a given value.
454 * If $value is null then the function will only attempt to retrieve the
455 * user preference requested by $name. If no user preference is found then the
456 * $default value will be returned. In this case the user preferences are not
457 * modified and nor are the params on $thispageurl.
459 * If $value is anything other than null then the function will set the user
460 * preference $name to the provided $value and will also set it as a param
461 * on $thispageurl.
463 * @param string $name The user_preference name is 'question_bank_' . $name.
464 * @param mixed $value The preference value.
465 * @param mixed $default The default value to use, if not otherwise set.
466 * @param moodle_url $thispageurl if the value has been explicitly set, we add
467 * it to this URL.
468 * @return mixed the parameter value to use.
470 function question_set_or_get_user_preference($name, $value, $default, $thispageurl) {
471 if (is_null($value)) {
472 return get_user_preferences('question_bank_' . $name, $default);
475 set_user_preference('question_bank_' . $name, $value);
476 $thispageurl->param($name, $value);
477 return $value;
481 * Make sure user is logged in as required in this context.
483 function require_login_in_context($contextorid = null){
484 global $DB, $CFG;
485 if (!is_object($contextorid)){
486 $context = context::instance_by_id($contextorid, IGNORE_MISSING);
487 } else {
488 $context = $contextorid;
490 if ($context && ($context->contextlevel == CONTEXT_COURSE)) {
491 require_login($context->instanceid);
492 } else if ($context && ($context->contextlevel == CONTEXT_MODULE)) {
493 if ($cm = $DB->get_record('course_modules',array('id' =>$context->instanceid))) {
494 if (!$course = $DB->get_record('course', array('id' => $cm->course))) {
495 print_error('invalidcourseid');
497 require_course_login($course, true, $cm);
499 } else {
500 print_error('invalidcoursemodule');
502 } else if ($context && ($context->contextlevel == CONTEXT_SYSTEM)) {
503 if (!empty($CFG->forcelogin)) {
504 require_login();
507 } else {
508 require_login();
513 * Print a form to let the user choose which question type to add.
514 * When the form is submitted, it goes to the question.php script.
515 * @param $hiddenparams hidden parameters to add to the form, in addition to
516 * the qtype radio buttons.
517 * @param $allowedqtypes optional list of qtypes that are allowed. If given, only
518 * those qtypes will be shown. Example value array('description', 'multichoice').
519 * @deprecated since Moodle 4.0
520 * @see \qbank_editquestion\editquestion_helper::print_choose_qtype_to_add_form()
521 * @todo Final deprecation of this class in moodle 4.4 MDL-72438
523 function print_choose_qtype_to_add_form($hiddenparams, array $allowedqtypes = null, $enablejs = true) {
524 debugging('Function print_choose_qtype_to_add_form() is deprecated,
525 please use \qbank_editquestion\editquestion_helper::print_choose_qtype_to_add_form() instead.', DEBUG_DEVELOPER);
526 global $CFG, $PAGE, $OUTPUT;
528 $chooser = \qbank_editquestion\qbank_chooser::get($PAGE->course, $hiddenparams, $allowedqtypes);
529 $renderer = $PAGE->get_renderer('question', 'bank');
531 return $renderer->render($chooser);
535 * Print a button for creating a new question. This will open question/addquestion.php,
536 * which in turn goes to question/question.php before getting back to $params['returnurl']
537 * (by default the question bank screen).
539 * @param int $categoryid The id of the category that the new question should be added to.
540 * @param array $params Other paramters to add to the URL. You need either $params['cmid'] or
541 * $params['courseid'], and you should probably set $params['returnurl']
542 * @param string $caption the text to display on the button.
543 * @param string $tooltip a tooltip to add to the button (optional).
544 * @param bool $disabled if true, the button will be disabled.
545 * @deprecated since Moodle 4.0
546 * @see \qbank_editquestion\editquestion_helper::create_new_question_button()
547 * @todo Final deprecation of this class in moodle 4.4 MDL-72438
549 function create_new_question_button($categoryid, $params, $caption, $tooltip = '', $disabled = false) {
550 debugging('Function create_new_question_button() has been deprecated and moved to bank/editquestion,
551 please use qbank_editquestion\editquestion_helper::create_new_question_button() instead.', DEBUG_DEVELOPER);
552 global $CFG, $PAGE, $OUTPUT;
553 static $choiceformprinted = false;
554 $params['category'] = $categoryid;
555 $url = new moodle_url('/question/bank/editquestion/addquestion.php', $params);
556 echo $OUTPUT->single_button($url, $caption, 'get', array('disabled'=>$disabled, 'title'=>$tooltip));
558 if (!$choiceformprinted) {
559 echo '<div id="qtypechoicecontainer">';
560 echo print_choose_qtype_to_add_form(array());
561 echo "</div>\n";
562 $choiceformprinted = true;