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/>.< /** < * Contains class core_tag_manage_table < * < * @package core_tag < * @copyright 2015 Marina Glancy < * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later < */> use core\output\checkbox_toggleall;defined('MOODLE_INTERNAL') || die(); require_once($CFG->libdir . '/tablelib.php'); /** * Class core_tag_manage_table *< * @package core> * @package core_tag* @copyright 2015 Marina Glancy * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class core_tag_manage_table extends table_sql { /** @var int stores the total number of found tags */ public $totalcount = null; /** @var int */ protected $tagcollid; /** * Constructor * * @param int $tagcollid */ public function __construct($tagcollid) {< global $USER, $CFG, $PAGE;> global $USER, $PAGE, $OUTPUT; >parent::__construct('tag-management-list-'.$USER->id); $this->tagcollid = $tagcollid; $perpage = optional_param('perpage', DEFAULT_PAGE_SIZE, PARAM_INT); $page = optional_param('page', 0, PARAM_INT); $filter = optional_param('filter', '', PARAM_NOTAGS); $baseurl = new moodle_url('/tag/manage.php', array('tc' => $tagcollid, 'perpage' => $perpage, 'page' => $page, 'filter' => $filter));> $checkboxall = new checkbox_toggleall('tags-manage', true, [ $tablecolumns = array('select', 'name', 'fullname', 'count', 'flag', 'timemodified', 'isstandard', 'controls'); > 'id' => 'select-all-tags', $tableheaders = array(get_string('select', 'tag'), > 'name' => 'select-all-tags', get_string('name', 'tag'), > 'checked' => false, get_string('owner', 'tag'), > 'label' => get_string('selectall'), get_string('count', 'tag'), > 'labelclasses' => 'accesshide', get_string('flag', 'tag'), > ]); get_string('timemodified', 'tag'), >< $tableheaders = array(get_string('select', 'tag'),> $tableheaders = array($OUTPUT->render($checkboxall),''); $this->define_columns($tablecolumns); $this->define_headers($tableheaders); $this->define_baseurl($baseurl); $this->column_class('select', 'mdl-align col-select'); $this->column_class('name', 'col-name'); $this->column_class('owner', 'col-owner'); $this->column_class('count', 'mdl-align col-count'); $this->column_class('flag', 'mdl-align col-flag'); $this->column_class('timemodified', 'col-timemodified'); $this->column_class('isstandard', 'mdl-align col-isstandard'); $this->column_class('controls', 'mdl-align col-controls'); $this->sortable(true, 'flag', SORT_DESC); $this->no_sorting('select'); $this->no_sorting('controls'); $this->set_attribute('cellspacing', '0'); $this->set_attribute('id', 'tag-management-list'); $this->set_attribute('class', 'admintable generaltable tag-management-table'); $totalcount = "SELECT COUNT(tg.id) FROM {tag} tg WHERE tg.tagcollid = :tagcollid"; $params = array('tagcollid' => $this->tagcollid); $this->set_count_sql($totalcount, $params); $this->set_sql('', '', '', $params); $this->collapsible(true); $PAGE->requires->js_call_amd('core/tag', 'initManagePage', array()); } /** * @return string sql to add to where statement. */ function get_sql_where() { $filter = optional_param('filter', '', PARAM_NOTAGS); list($wsql, $wparams) = parent::get_sql_where(); if ($filter !== '') { $wsql .= ($wsql ? ' AND ' : '') . 'tg.name LIKE :tagfilter'; $wparams['tagfilter'] = '%' . $filter . '%'; } return array($wsql, $wparams); } /** * Query the db. Store results in the table object for use by build_table. * * @param int $pagesize size of page for paginated displayed table. * @param bool $useinitialsbar do you want to use the initials bar. Bar * will only be used if there is a fullname column defined for the table. */ public function query_db($pagesize, $useinitialsbar = true) { global $DB; $where = ''; if (!$this->is_downloading()) { $grandtotal = $DB->count_records_sql($this->countsql, $this->countparams); list($wsql, $wparams) = $this->get_sql_where(); if ($wsql) { $this->countsql .= ' AND '.$wsql; $this->countparams = array_merge($this->countparams, $wparams); $where .= ' AND '.$wsql; $this->sql->params = array_merge($this->sql->params, $wparams); $total = $DB->count_records_sql($this->countsql, $this->countparams); } else { $total = $grandtotal; } $this->pagesize(min($pagesize, $total), $total); $this->totalcount = $total; } // Fetch the attempts. $sort = $this->get_sql_sort(); if ($sort) { $sort .= ", tg.name"; } else { $sort = "tg.name"; } $userfieldsapi = \core_user\fields::for_name(); $allusernames = $userfieldsapi->get_sql('u', false, '', '', false)->selects; $sql = " SELECT tg.id, tg.name, tg.rawname, tg.isstandard, tg.flag, tg.timemodified, u.id AS owner, $allusernames, COUNT(ti.id) AS count, tg.tagcollid FROM {tag} tg LEFT JOIN {tag_instance} ti ON ti.tagid = tg.id LEFT JOIN {user} u ON u.id = tg.userid WHERE tagcollid = :tagcollid $where GROUP BY tg.id, tg.name, tg.rawname, tg.isstandard, tg.flag, tg.timemodified, u.id, $allusernames, tg.tagcollid ORDER BY $sort"; if (!$this->is_downloading()) { $this->rawdata = $DB->get_records_sql($sql, $this->sql->params, $this->get_page_start(), $this->get_page_size()); } else { $this->rawdata = $DB->get_records_sql($sql, $this->sql->params); } } /**> * Override the table show_hide_link to not show for select column. * Get any extra classes names to add to this row in the HTML > * * > * @param string $column the column name, index into various names * @param stdClass $row array the data for this row. > * @param int $index numerical index of the column * @return string added to the class="" attribute of the tr. > * @return string HTML fragment */ > */ public function get_row_class($row) { > protected function show_hide_link($column, $index) { return $row->flag ? 'table-warning' : ''; > if ($index > 0) { } > return parent::show_hide_link($column, $index); > } /** > return ''; * Column name > } * > * @param stdClass $tag > /*** @return string */ public function col_name($tag) { global $OUTPUT; $tagoutput = new core_tag\output\tagname($tag); return $tagoutput->render($OUTPUT); } /** * Column flag * * @param stdClass $tag * @return string */ public function col_flag($tag) { global $OUTPUT; $tagoutput = new core_tag\output\tagflag($tag); return $tagoutput->render($OUTPUT); } /** * Column fullname (user name) * * @param stdClass $tag * @return string */ public function col_fullname($tag) { $params = array('id' => $tag->owner); $ownerlink = new moodle_url('/user/view.php', $params); $owner = html_writer::link($ownerlink, fullname($tag)); return $owner; } /** * Column time modified * * @param stdClass $tag * @return string */ public function col_timemodified($tag) { return format_time(time() - $tag->timemodified); } /** * Column tag type * * @param stdClass $tag * @return string */ public function col_isstandard($tag) { global $OUTPUT; $tagoutput = new core_tag\output\tagisstandard($tag); return $tagoutput->render($OUTPUT); } /** * Column select * * @param stdClass $tag * @return string */ public function col_select($tag) {< $id = "tagselect" . $tag->id; < return html_writer::label(get_string('selecttag', 'tag', $tag->rawname), $id, < false, array('class' => 'accesshide')). < html_writer::empty_tag('input', array('type' => 'checkbox', < 'name' => 'tagschecked[]', 'value' => $tag->id, 'id' => $id));> global $OUTPUT; > > $checkbox = new checkbox_toggleall('tags-manage', false, [ > 'id' => 'tagselect' . $tag->id, > 'name' => 'tagschecked[]', > 'value' => $tag->id, > 'checked' => false, > 'label' => get_string('selecttag', 'tag', $tag->rawname), > 'labelclasses' => 'accesshide', > ]); > > return $OUTPUT->render($checkbox);} /** * Column controls * * @param stdClass $tag * @return string */ public function col_controls($tag) { global $OUTPUT, $PAGE; $o = ''; // Edit. $url = new moodle_url('/tag/edit.php', array('id' => $tag->id, 'returnurl' => $PAGE->url->out_as_local_url())); $o .= $OUTPUT->action_icon($url, new pix_icon('t/edit', get_string('edittag', 'tag'))); // Delete. $url = new moodle_url($this->baseurl, array('action' => 'delete', 'tagid' => $tag->id, 'sesskey' => sesskey())); $o .= $OUTPUT->action_icon($url, new pix_icon('t/delete', get_string('delete', 'tag')), null, array('class' => 'action-icon tagdelete')); return $o; } }