-
Notifications
You must be signed in to change notification settings - Fork 0
/
block_simplequery.php
96 lines (78 loc) · 3.08 KB
/
block_simplequery.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<?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/>.
/**
* Strings for component 'block_simplequery', language 'en', branch 'MOODLE_20_STABLE'
*
* @package block_simplequery
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
defined('MOODLE_INTERNAL') || die();
class block_simplequery extends block_base {
function init() {
$this->title = get_string('pluginname', 'block_simplequery');
}
function get_content() {
global $DB;
if ($this->content !== NULL) {
return $this->content;
}
$this->content = new stdClass;
$sql="SELECT {user}.lastname AS UserLastname,
COUNT({user}.lastname) AS CountOfEnrolled,
{course}.fullname AS CourseName
FROM mdl_course
LEFT JOIN {enrol}
ON {course}.id={enrol}.courseid
LEFT JOIN {user_enrolments}
ON {user_enrolments}.enrolid = {enrol}.id
LEFT JOIN {user}
ON {user_enrolments}.userid = {user}.id
WHERE {course}.fullname='Example Course'
GROUP BY {user}.lastname
ORDER BY CountOfEnrolled DESC
LIMIT 5";
$result = $DB->get_records_sql($sql); //returns array of stdClass objects
$this->content->text = $this->get_table($result);
$this->content->footer = 'This is the footer section';
return $this->content;
}
function get_table( $sql_result = array()) {
$table_header = '<div class="table-responsive">
<caption>Table shows 5 users enrolled on Example Course that have the same last name</caption>
<table class="table table-striped table-hover">
<thead>
<tr>
<th scope="col">User Lastname</th>
<th scope="col">Course Name</th>
<th scope="col">Count of Enrolled</th>
</tr>
</thead>
<tbody>';
$table_footer = '</div>
</tbody>
</table>';
foreach($sql_result as $data) {
$table_header .= '
<tr>
<th scope="row">' . $data->userlastname . '</th>
<td>' . $data->coursename . '</td>
<td>' . $data->countofenrolled . '</td>
</tr>';
}
$table_header .= $table_footer;
return $table_header;
}
}