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 type for the name of the question creator. 23 * 24 * @package qbank_viewcreator 25 * @copyright 2009 Tim Hunt 26 * @author 2021 Ghaly Marc-Alexandre <marc-alexandreghaly@catalyst-ca.net> 27 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later 28 */ 29 class creator_name_column extends column_base { 30 31 public function get_name(): string { 32 return 'creatorname'; 33 } 34 35 public function get_title(): string { 36 return get_string('createdby', 'question'); 37 } 38 39 protected function display_content($question, $rowclasses): void { 40 global $PAGE; 41 $displaydata = []; 42 43 if (!empty($question->creatorfirstname) && !empty($question->creatorlastname)) { 44 $u = new \stdClass(); 45 $u = username_load_fields_from_object($u, $question, 'creator'); 46 $displaydata['date'] = userdate($question->timecreated, get_string('strftimedatetime', 'langconfig')); 47 $displaydata['creator'] = fullname($u); 48 echo $PAGE->get_renderer('qbank_viewcreator')->render_creator_name($displaydata); 49 } 50 } 51 52 public function get_extra_joins(): array { 53 return ['uc' => 'LEFT JOIN {user} uc ON uc.id = q.createdby']; 54 } 55 56 public function get_required_fields(): array { 57 $allnames = \core_user\fields::get_name_fields(); 58 $requiredfields = []; 59 foreach ($allnames as $allname) { 60 $requiredfields[] = 'uc.' . $allname . ' AS creator' . $allname; 61 } 62 $requiredfields[] = 'q.timecreated'; 63 return $requiredfields; 64 } 65 66 public function is_sortable(): array { 67 return [ 68 'firstname' => ['field' => 'uc.firstname', 'title' => get_string('firstname')], 69 'lastname' => ['field' => 'uc.lastname', 'title' => get_string('lastname')], 70 'timecreated' => ['field' => 'q.timecreated', 'title' => get_string('date')] 71 ]; 72 } 73 74 public function get_extra_classes(): array { 75 return ['pr-3']; 76 } 77 78 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body