-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmain.php
116 lines (93 loc) · 7.5 KB
/
main.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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<?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');
admin_externalpage_setup('reportcoursestats', '', null, '', array('pagelayout'=>'report'));
$category = optional_param('category', ALL_CATEGORIES, PARAM_INT);
if ($category == ALL_CATEGORIES) {
$only_forum_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {course} co JOIN {report_coursestats} cs ON co.id = cs.courseid WHERE cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>FORUM_USAGE_TYPE, 'visible'=>'1'));
$only_repository_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {course} co JOIN {report_coursestats} cs ON co.id = cs.courseid WHERE cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>REPOSITORY_USAGE_TYPE, 'visible'=>'1'));
$activity_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {course} co JOIN {report_coursestats} cs ON co.id = cs.courseid WHERE cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>ACTIVITY_USAGE_TYPE, 'visible'=>'1'));
$catname = get_string('lb_all_categories', 'report_coursestats');
// the minus 1 is necessary to exclude the default course, created by any new Moodle instance
$amount_of_created_courses = $DB->count_records(COURSE_TABLE_NAME, array('visible'=>'1')) - 1;
} else {
$only_forum_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {report_coursestats} cs JOIN {course} co ON co.id = cs.courseid WHERE co.category = :cat AND cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>FORUM_USAGE_TYPE, 'cat'=>$category, 'visible'=>'1'));
$only_repository_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {report_coursestats} cs JOIN {course} co ON co.id = cs.courseid WHERE co.category = :cat AND cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>REPOSITORY_USAGE_TYPE, 'cat'=>$category, 'visible'=>'1'));
$activity_courses = $DB->count_records_sql('SELECT COUNT(*) FROM {report_coursestats} cs JOIN {course} co ON co.id = cs.courseid WHERE co.category = :cat AND cs.curr_usage_type = :type AND co.visible = :visible',
array('type'=>ACTIVITY_USAGE_TYPE, 'cat'=>$category, 'visible'=>'1'));
$cat = $DB->get_record(COURSE_CATEGORIES_TABLE_NAME, array('id'=>$category));
$catname = $cat->name;
$amount_of_created_courses = $DB->count_records(COURSE_TABLE_NAME, array('visible'=>'1', 'category'=>$category));
}
$amount_of_courses = $only_forum_courses + $only_repository_courses + $activity_courses;
$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 ($amount_of_courses > 0) {
echo $OUTPUT->heading(get_string('lb_category', 'report_coursestats') . ': ' . $catname . ' - ' . $link);
if (class_exists('core\chart_pie')) {
// Types of usage chart
$data_types_of_use = new core\chart_series(get_string('lb_chart_series_types_of_use', 'report_coursestats'), [$only_forum_courses, $only_repository_courses, $activity_courses]);
$chart_types_of_use = new core\chart_pie();
$chart_types_of_use->add_series($data_types_of_use);
$chart_types_of_use->set_labels([get_string('lb_forum_usage', 'report_coursestats'), get_string('lb_repository_usage', 'report_coursestats'), get_string('lb_activity_usage', 'report_coursestats')]);
// Used courses chart
$data_used_courses = new core\chart_series(get_string('lb_chart_series_used_courses', 'report_coursestats'), [$amount_of_courses, ($amount_of_created_courses - $amount_of_courses)]);
$chart_used_courses = new core\chart_pie();
$chart_used_courses->add_series($data_used_courses);
$chart_used_courses->set_labels([get_string('lb_used_courses', 'report_coursestats'), get_string('lb_not_used_courses', 'report_coursestats')]);
echo $OUTPUT->render_chart($chart_types_of_use, false);
echo $OUTPUT->render_chart($chart_used_courses, false);
}
$summary_table = new html_table();
$summary_table->head = array(get_string('lb_courses_created_amount', 'report_coursestats'), get_string('lb_used_courses', 'report_coursestats'), get_string('lb_not_used_courses', 'report_coursestats'));
$summary_table->data = array(array($amount_of_created_courses, $amount_of_courses . ' (' . number_format(($amount_of_courses/$amount_of_created_courses)*100, 2) . '%)',
($amount_of_created_courses - $amount_of_courses) . ' (' . number_format((($amount_of_created_courses - $amount_of_courses)/$amount_of_created_courses)*100, 2) . '%)'));
echo html_writer::table($summary_table);
$table = new html_table();
$table->head = array(get_string('lb_usage_type_name', 'report_coursestats'),
get_string('lb_courses_amount', 'report_coursestats'),
get_string('lb_percent_of_used_courses', 'report_coursestats'),
get_string('lb_percent_of_created_courses', 'report_coursestats'),
get_string('lb_usage_type_desc', 'report_coursestats'));
$url_filter_forum_usage_type = new moodle_url($CFG->wwwroot . '/report/coursestats/details.php?usagetype=' . FORUM_USAGE_TYPE . '&category=' . $category);
$url_filter_repository_usage_type = new moodle_url($CFG->wwwroot . '/report/coursestats/details.php?usagetype=' . REPOSITORY_USAGE_TYPE . '&category=' . $category);
$url_filter_activities_usage_type = new moodle_url($CFG->wwwroot . '/report/coursestats/details.php?usagetype=' . ACTIVITY_USAGE_TYPE . '&category=' . $category);
$table->data = array(
array(html_writer::link($url_filter_forum_usage_type, get_string('lb_forum_usage', 'report_coursestats')), $only_forum_courses, number_format(($only_forum_courses/$amount_of_courses)*100, 2) . '%', number_format(($only_forum_courses/$amount_of_created_courses)*100, 2) . '%', get_string('lb_forum_usage_help', 'report_coursestats')),
array(html_writer::link($url_filter_repository_usage_type, get_string('lb_repository_usage', 'report_coursestats')), $only_repository_courses, number_format(($only_repository_courses/$amount_of_courses)*100, 2) . '%', number_format(($only_repository_courses/$amount_of_created_courses)*100, 2) . '%', get_string('lb_repository_usage_help', 'report_coursestats')),
array(html_writer::link($url_filter_activities_usage_type, get_string('lb_activity_usage', 'report_coursestats')), $activity_courses, number_format(($activity_courses/$amount_of_courses)*100, 2) . '%', number_format(($activity_courses/$amount_of_created_courses)*100, 2) . '%', get_string('lb_activity_usage_help', 'report_coursestats'))
);
echo html_writer::table($table);
} else {
echo html_writer::tag('p', get_string('lb_there_are_no_courses_stats', 'report_coursestats') . ' (' .$link . ')', array('align' => 'center'));
}
echo $OUTPUT->footer();