-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcourses.php
85 lines (70 loc) · 4.22 KB
/
courses.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
<?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 'report_coursestats', language 'en'
*
* @package report
* @subpackage coursestats
* @copyright 2017 Paulo Jr.
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require(dirname(__FILE__).'/../../config.php');
require_once($CFG->libdir.'/adminlib.php');
require(__DIR__. '/constants.php');
$type = optional_param('type', CREATED_COURSES, PARAM_ALPHA); // usage type
$category = optional_param('category', ALL_CATEGORIES, PARAM_INT);
admin_externalpage_setup('reportcoursestats', '', null, '', array('pagelayout'=>'report'));
$url = new moodle_url($CFG->wwwroot . '/report/coursestats/index.php');
$link = html_writer::link($url, get_string('link_back', 'report_coursestats'));
echo $OUTPUT->header();
if ($type == CREATED_COURSES && $category == ALL_CATEGORIES) {
$catname = get_string('lb_all_categories', 'report_coursestats');
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {course} co WHERE co.visible = :visible ORDER BY co.shortname',
array('visible'=>'1'));
} else if ($type == CREATED_COURSES && $category != ALL_CATEGORIES) {
$cat = $DB->get_record(COURSE_CATEGORIES_TABLE_NAME, array('id'=>$category));
$catname = $cat->name;
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {course} co WHERE co.category = :cat AND co.visible = :visible ORDER BY co.shortname',
array('cat'=>$category, 'visible'=>'1'));
} else if ($type == USED_COURSES && $category == ALL_CATEGORIES) {
$catname = get_string('lb_all_categories', 'report_coursestats');
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {report_coursestats} cs JOIN {course} co ON co.id = cs.courseid WHERE co.visible = :visible ORDER BY co.shortname',
array('visible'=>'1'));
} else if ($type == USED_COURSES && $category != ALL_CATEGORIES) {
$cat = $DB->get_record(COURSE_CATEGORIES_TABLE_NAME, array('id'=>$category));
$catname = $cat->name;
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {report_coursestats} cs JOIN {course} co ON co.id = cs.courseid WHERE co.category = :cat AND co.visible = :visible ORDER BY co.shortname',
array('cat'=>$category, 'visible'=>'1'));
} else if ($type == NOTUSED_COURSES && $category == ALL_CATEGORIES) {
$catname = get_string('lb_all_categories', 'report_coursestats');
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {course} co LEFT JOIN {report_coursestats} cs ON co.id = cs.courseid WHERE co.visible = :visible AND cs.courseid IS NULL ORDER BY co.shortname',
array('visible'=>'1'));
} else { // ($type == NOTUSED_COURSES && $category != ALL_CATEGORIES)
$cat = $DB->get_record(COURSE_CATEGORIES_TABLE_NAME, array('id'=>$category));
$catname = $cat->name;
$rs = $DB->get_recordset_sql('SELECT co.id, co.shortname, co.fullname FROM {course} co LEFT JOIN {report_coursestats} cs ON co.id = cs.courseid WHERE co.category = :cat AND co.visible = :visible AND cs.courseid IS NULL ORDER BY co.shortname',
array('cat'=>$category, 'visible'=>'1'));
}
echo $OUTPUT->heading(get_string('lb_category', 'report_coursestats') . ': ' . $catname . ' - ' . $link);
$table = new html_table();
$table->head = array(get_string('lb_course_name', 'report_coursestats'), get_string('lb_course_fullname', 'report_coursestats'));
foreach ($rs as $cs) {
$row = array('<a href=' . $CFG->wwwroot . '/course/view.php?id=' . $cs->id . '>' . $cs->shortname . '</a>', $cs->fullname);
$table->data[] = $row;
}
$rs->close();
echo html_writer::table($table);
echo $OUTPUT->footer();