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. 13 // 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 namespace qbank_viewcreator; 18 19 use core_question\local\bank\column_base; 20 21 /** 22 * A column for info of the question modifier. 23 * 24 * @package qbank_viewcreator 25 * @copyright 2022 Catalyst IT Australia Pty Ltd 26 * @author Safat Shahin <safatshahin@catalyst-au.net> 27 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later 28 */ 29 class modifier_name_column extends column_base { 30 31 public function get_name(): string { 32 return 'modifiername'; 33 } 34 35 public function get_title(): string { 36 return get_string('modifiedby', 'qbank_viewcreator'); 37 } 38 39 protected function display_content($question, $rowclasses): void { 40 global $PAGE; 41 $displaydata = []; 42 if (!empty($question->modifierfirstname) && !empty($question->modifierlastname)) { 43 $u = new \stdClass(); 44 $u = username_load_fields_from_object($u, $question, 'modifier'); 45 $displaydata['date'] = userdate($question->timemodified, get_string('strftimedatetime', 'langconfig')); 46 $displaydata['creator'] = fullname($u); 47 echo $PAGE->get_renderer('qbank_viewcreator')->render_creator_name($displaydata); 48 } 49 } 50 51 public function get_extra_joins(): array { 52 return ['um' => 'LEFT JOIN {user} um ON um.id = q.modifiedby']; 53 } 54 55 public function get_required_fields(): array { 56 $allnames = \core_user\fields::get_name_fields(); 57 $requiredfields = []; 58 foreach ($allnames as $allname) { 59 $requiredfields[] = 'um.' . $allname . ' AS modifier' . $allname; 60 } 61 $requiredfields[] = 'q.timemodified'; 62 return $requiredfields; 63 } 64 65 public function is_sortable(): array { 66 return [ 67 'firstname' => ['field' => 'um.firstname', 'title' => get_string('firstname')], 68 'lastname' => ['field' => 'um.lastname', 'title' => get_string('lastname')], 69 'timemodified' => ['field' => 'q.timemodified', 'title' => get_string('date')] 70 ]; 71 } 72 73 public function get_extra_classes(): array { 74 return ['pr-3']; 75 } 76 77 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body