Merge branch 'MDL-81472' of https://github.com/paulholden/moodle
[moodle.git] / badges / related_form.php
blob31d74f4cd409168a127f560ed02dcceaeb9e966a
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/>.
16 /**
17 * Form related badges.
19 * @package core
20 * @subpackage badges
21 * @copyright 2018 Tung Thai
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
23 * @author Tung Thai <Tung.ThaiDuc@nashtechglobal.com>
25 defined('MOODLE_INTERNAL') || die();
26 require_once($CFG->libdir . '/formslib.php');
27 require_once($CFG->libdir . '/badgeslib.php');
29 /**
30 * Form to edit badge details.
32 * @copyright 2018 Tung Thai
33 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
34 * @author Tung Thai <Tung.ThaiDuc@nashtechglobal.com>
36 class edit_relatedbadge_form extends moodleform {
38 /**
39 * Defines the form.
41 public function definition() {
42 $mform = $this->_form;
43 $badge = $this->_customdata['badge'];
44 $badgesarray = $this->get_badges_option($badge);
45 $mform->addElement('header', 'alignment', get_string('relatedbages', 'badges'));
46 if (!$badgesarray) {
47 $badgesarray = array(get_string('none'));
48 $attributes = array('size' => '3', 'disabled' => true, 'style' => 'min-width: 200px');
49 } else {
50 $attributes = array('size' => '10');
52 $mform->addElement('select', 'relatedbadgeids', get_string('relatedbages', 'badges'), $badgesarray, $attributes);
53 $mform->getElement('relatedbadgeids')->setMultiple(true);
54 $this->add_action_buttons();
56 // Freeze all elements if badge is active or locked.
57 if ($badge->is_active() || $badge->is_locked()) {
58 $mform->hardFreezeAllVisibleExcept(array());
62 /**
63 * Validates form data.
65 * @param array $data submitted data.
66 * @param array $files submitted files.
67 * @return array $errors An array of errors.
69 public function validation($data, $files) {
70 $errors = parent::validation($data, $files);
71 return $errors;
74 /**
75 * Return list badge of a course or list badge site.
77 * @param object $badge Badge object.
78 * @return array $options An array the badges.
80 public function get_badges_option($badge) {
81 global $DB;
82 $sql = "SELECT b.id, b.name, b.version, b.language, b.type
83 FROM {badge} b
84 WHERE b.id <> :badgeid
85 AND b.id NOT IN (
86 SELECT DISTINCT b.id
87 FROM {badge_related} br
88 JOIN {badge} b ON (br.relatedbadgeid = b.id OR br.badgeid = b.id)
89 WHERE (br.badgeid = :badgeid2 OR br.relatedbadgeid = :badgeid3) AND b.id != :badgeid4)";
90 $params = ['badgeid' => $badge->id, 'badgeid2' => $badge->id, 'badgeid3' => $badge->id, 'badgeid4' => $badge->id];
91 if ($badge->type == BADGE_TYPE_COURSE) {
92 $sql .= " AND (b.courseid = :courseid OR b.type = :badgetype)";
93 $params['courseid'] = $badge->courseid;
94 $params['badgetype'] = BADGE_TYPE_SITE;
97 $records = $DB->get_records_sql($sql, $params);
98 $languages = get_string_manager()->get_list_of_languages();
99 $options = array();
100 foreach ($records as $record) {
101 $language = isset($languages[$record->language]) ? $languages[$record->language] : '';
102 $options[$record->id] = $record->name .
103 ' (version: ' . $record->version . ', language: ' . $language . ', ' .
104 ($record->type == BADGE_TYPE_COURSE ? get_string('badgesview', 'badges') : get_string('sitebadges', 'badges')) .
105 ')';
107 return $options;