1 |
efrain |
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 |
$string['pluginname'] = "Configurable Reports";
|
|
|
18 |
$string['blockname'] = "Configurable Reports";
|
|
|
19 |
$string['report_courses'] = "Courses report";
|
|
|
20 |
$string['report_users'] = "Users report";
|
|
|
21 |
$string['report_sql'] = "SQL Report";
|
|
|
22 |
$string['managereports'] = "Manage reports";
|
|
|
23 |
|
|
|
24 |
$string['report'] = "Report";
|
|
|
25 |
$string['reports'] = "Reports";
|
|
|
26 |
|
|
|
27 |
$string['columns'] = "Columns";
|
|
|
28 |
$string['conditions'] = "Conditions";
|
|
|
29 |
$string['permissions'] = "Permissions";
|
|
|
30 |
$string['plot'] = "Plot - Graphs";
|
|
|
31 |
$string['filters'] = "Filters ";
|
|
|
32 |
$string['calcs'] = "Calculations";
|
|
|
33 |
$string['ordering'] = "Ordering";
|
|
|
34 |
$string['customsql'] = "Custom SQL";
|
|
|
35 |
$string['addreport'] = "Add report";
|
|
|
36 |
$string['type'] = "Type of report";
|
|
|
37 |
$string['columncalculations'] = "Column Calculations";
|
|
|
38 |
$string['newreport'] = "New report";
|
|
|
39 |
$string['column'] = "Column";
|
|
|
40 |
$string['confirmdeletereport'] = "Are you sure you want to delete this report?";
|
|
|
41 |
$string['noreportsavailable'] = "No reports available";
|
|
|
42 |
$string['downloadreport'] = "Download report";
|
|
|
43 |
$string['reportlimit'] = "Report row limit";
|
|
|
44 |
$string['reportlimitinfo'] = "Limit the number of rows that are displayed in the report table (Default is 5000 rows. Better to have some limit, so users will not over load the DB engine)";
|
|
|
45 |
|
|
|
46 |
$string['configurable_reports:addinstance'] = 'Add a new configurable reports block';
|
|
|
47 |
$string['configurable_reports:myaddinstance'] = 'Add a new configurable reports block to MY HOME page';
|
|
|
48 |
$string['configurable_reports:manageownreports'] = "Manage own reports";
|
|
|
49 |
$string['configurable_reports:managereports'] = "Manage reports";
|
|
|
50 |
$string['configurable_reports:managesqlreports'] = "Manage SQL reports";
|
|
|
51 |
$string['configurable_reports:viewreports'] = "View reports";
|
|
|
52 |
|
|
|
53 |
$string['exportoptions'] = "Export options";
|
|
|
54 |
$string['field'] = "Field";
|
|
|
55 |
|
|
|
56 |
// Report form
|
|
|
57 |
$string['typeofreport'] = "Type of report";
|
|
|
58 |
$string['enablejsordering'] = "Enable JavaScript ordering";
|
|
|
59 |
$string['enablejspagination'] = "Enable JavaScript Pagination";
|
|
|
60 |
$string['export_csv'] = "Export in CSV format";
|
|
|
61 |
$string['export_ods'] = "Export in ODS format";
|
|
|
62 |
$string['export_xls'] = "Export in XLS format";
|
|
|
63 |
$string['export_json'] = "Export in JSON format";
|
|
|
64 |
$string['viewreport'] = "View report";
|
|
|
65 |
$string['norecordsfound'] = "No records found";
|
|
|
66 |
$string['jsordering'] = 'JavaScript Ordering';
|
|
|
67 |
$string['cron'] = 'Auto run daily';
|
|
|
68 |
$string['crondescription'] = 'Schedule this query to run each day (At night)';
|
|
|
69 |
$string['cron_help'] = 'Schedule this query to run each day (At night)';
|
|
|
70 |
$string['remote'] = 'Run on remote db';
|
|
|
71 |
$string['remotedescription'] = 'Do you want to run this query on the remote db';
|
|
|
72 |
$string['remote_help'] = 'Do you want to run this query on the remote db';
|
|
|
73 |
$string['setcourseid'] = 'Set courseid';
|
|
|
74 |
|
|
|
75 |
// Columns
|
|
|
76 |
$string['column'] = "Column";
|
|
|
77 |
$string['nocolumnsyet'] = "No columns yet";
|
|
|
78 |
$string['tablealign'] = "Table align";
|
|
|
79 |
$string['tablecellspacing'] = "Table cellspacing";
|
|
|
80 |
$string['tablecellpadding'] = "Table cellpadding";
|
|
|
81 |
$string['tableclass'] = "Table class";
|
|
|
82 |
$string['tablewidth'] = "Table width";
|
|
|
83 |
$string['cellalign'] = "Cell align";
|
|
|
84 |
$string['cellwrap'] = "Cell wrap";
|
|
|
85 |
$string['cellsize'] = "Cell size";
|
|
|
86 |
|
|
|
87 |
|
|
|
88 |
// Conditions
|
|
|
89 |
$string['conditionexpr'] = "Condition";
|
|
|
90 |
$string['conditionexprhelp'] = "Enter a valid condition i.e: (c1 and c2) or (c4 and c3)";
|
|
|
91 |
$string['noconditionsyet'] = "No conditions yet";
|
|
|
92 |
$string['operator'] = "Operator";
|
|
|
93 |
$string['value'] = "Value";
|
|
|
94 |
|
|
|
95 |
// Filter
|
|
|
96 |
$string['filter'] = "Filter";
|
|
|
97 |
$string['nofilteryet'] = "No filters yet";
|
|
|
98 |
$string['courses'] = "Courses";
|
|
|
99 |
$string['nofiltersyet'] = "No filters yet";
|
|
|
100 |
$string['filter_all'] = 'All';
|
|
|
101 |
$string['filter_apply'] = 'Apply';
|
|
|
102 |
$string['filter_searchtext'] = 'Search text';
|
|
|
103 |
$string['searchtext'] = 'Search text';
|
|
|
104 |
$string['filter_searchtext_summary'] = 'Free text filter';
|
|
|
105 |
$string['years'] = 'Year (Numeric)';
|
|
|
106 |
$string['filteryears'] = 'Year (Numeric)';
|
|
|
107 |
$string['filteryears_summary'] = 'Filter by years (numeric representation, 2012...)';
|
|
|
108 |
$string['filteryears_list'] = '2010,2011,2012,2013,2014,2015';
|
|
|
109 |
$string['semester'] = 'Semester (Hebrew)';
|
|
|
110 |
$string['filtersemester'] = 'Semester (Hebrew)';
|
|
|
111 |
$string['filtersemester_summary'] = 'מאפשר סינון לפני סמסטרים (בעברית, למשל: סמסטר א,סמסטר ב)';
|
|
|
112 |
$string['filtersemester_list'] = 'סמסטר א,סמסטר ב,סמסטר ג,סמינריון';
|
|
|
113 |
$string['subcategories'] = 'Category (Include sub categories)';
|
|
|
114 |
$string['filtersubcategories'] = 'Category (Include sub categories)';
|
|
|
115 |
$string['filtersubcategories_summary'] = 'Use: %%FILTER_SUBCATEGORIES:mdl_course_category.path%%';
|
|
|
116 |
$string['yearnumeric'] = 'Year (Numeric)';
|
|
|
117 |
$string['filteryearnumeric'] = 'Year (Numeric)';
|
|
|
118 |
$string['filteryearnumeric_summary'] = 'Filter is using numeric years (2013,...)';
|
|
|
119 |
$string['yearhebrew'] = 'Year (Hebrew)';
|
|
|
120 |
$string['filteryearhebrew'] = 'Year (Hebrew)';
|
|
|
121 |
$string['filteryearhebrew_list'] = 'תשע,תשעא,תשעב,תשעג,תשעד,תשעה';
|
|
|
122 |
$string['filteryearhebrew_summary'] = 'Filter is using Hebrew years (תשעג,...)';
|
|
|
123 |
$string['role'] = 'Role';
|
|
|
124 |
$string['filterrole'] = 'role';
|
|
|
125 |
$string['filterrole_summary'] = 'Filter system Roles (Teacher, Student, ...)';
|
|
|
126 |
$string['coursemodules'] = 'Course module';
|
|
|
127 |
$string['filtercoursemodules'] = 'Course module';
|
|
|
128 |
$string['filtercoursemodules_summary'] = 'Filter course modules';
|
|
|
129 |
$string['user'] = 'Course user (id)';
|
|
|
130 |
$string['filteruser'] = 'Current course user';
|
|
|
131 |
$string['filteruser_summary'] = 'Filter a user (id) from current course users';
|
|
|
132 |
$string['users'] = 'System user (id)';
|
|
|
133 |
$string['filterusers'] = 'System user';
|
|
|
134 |
$string['enrolledstudents'] = 'Enrolled students';
|
|
|
135 |
$string['filterusers_summary'] = 'Filter a user (by id) from system user list';
|
|
|
136 |
$string['filterenrolledstudents'] = 'Enrolled course students';
|
|
|
137 |
$string['filterenrolledstudents_summary'] = 'Filter a user (by id) from enrolled course students';
|
|
|
138 |
$string['competencyframeworks'] = 'Competency Frameworks';
|
|
|
139 |
$string['filtercompetencyframeworks'] = 'Competency Frameworks';
|
|
|
140 |
$string['filtercompetencyframeworks_summary'] = 'Use: %%FILTER_COMPETENCYFRAMEWORKS:prefix_competency_framework.id%%';
|
|
|
141 |
$string['competencytemplates'] = 'Competency Templates';
|
|
|
142 |
$string['filtercompetencytemplates'] = 'Competency templates';
|
|
|
143 |
$string['filtercompetencytemplates_summary'] = 'Use: %%FILTER_COMPETENCYTEMPLATES:prefix_competency_template.id%%';
|
|
|
144 |
$string['cohorts'] = 'Cohorts';
|
|
|
145 |
$string['filtercohorts'] = 'Cohorts';
|
|
|
146 |
$string['filtercohorts_summary'] = 'Use: %%FILTER_COHORTS:prefix_cohort.id%%';
|
|
|
147 |
$string['student'] = 'Student';
|
|
|
148 |
|
|
|
149 |
// Calcs
|
|
|
150 |
$string['nocalcsyet'] = "No calculations yet";
|
|
|
151 |
|
|
|
152 |
// Plot
|
|
|
153 |
$string['noplotyet'] = "No plots yet";
|
|
|
154 |
|
|
|
155 |
// Permissions
|
|
|
156 |
|
|
|
157 |
$string['nopermissionsyet'] = "No permissions yet";
|
|
|
158 |
|
|
|
159 |
// Ordering
|
|
|
160 |
|
|
|
161 |
$string['noorderingyet'] = "No ordering yet";
|
|
|
162 |
$string['userfieldorder'] = "User field order";
|
|
|
163 |
|
|
|
164 |
// Plugins
|
|
|
165 |
$string['coursefield'] = "Course field";
|
|
|
166 |
$string['ccoursefield'] = "Course field condition";
|
|
|
167 |
$string['roleusersn'] = "Number of users with role...";
|
|
|
168 |
$string['coursecategory'] = "Course in category";
|
|
|
169 |
$string['filtercourses'] = "Courses";
|
|
|
170 |
$string['filtercourses_summary'] = "This filter shows a list of courses. Only one course can be selected at the same time";
|
|
|
171 |
$string['roleincourse'] = "User with the selected role/s in the current report course";
|
|
|
172 |
$string['reportscapabilities'] = "Report Capabilities";
|
|
|
173 |
$string['reportscapabilities_summary'] = "Users with the capability moodle/site:viewreports enabled";
|
|
|
174 |
$string['sum'] = "Sum";
|
|
|
175 |
$string['max'] = "Maximum";
|
|
|
176 |
$string['min'] = "Minimum";
|
|
|
177 |
$string['percent'] = "Percentage";
|
|
|
178 |
$string['average'] = "Average";
|
|
|
179 |
$string['pie'] = "Pie";
|
|
|
180 |
$string['piesummary'] = "A pie graph";
|
|
|
181 |
$string['pieareaname'] = "Name";
|
|
|
182 |
$string['pieareavalue'] = "Value";
|
|
|
183 |
$string['piesummary'] = "A pie graph";
|
|
|
184 |
|
|
|
185 |
$string['bar'] = "Bar";
|
|
|
186 |
$string['barsummary'] = "A bar graph";
|
|
|
187 |
$string['label_field'] = "Label field";
|
|
|
188 |
$string['label_field_help'] = "The field that provides names for the things represented in the graph";
|
|
|
189 |
$string['value_fields'] = "Value fields";
|
|
|
190 |
$string['value_fields_help'] = "Fields that should be represented in the graph. Ctrl+click (Cmd+click on Mac) to select multiple. If you select the Label field or a field with non-numeric values it will be ignored";
|
|
|
191 |
$string['width'] = "Width";
|
|
|
192 |
$string['height'] = "Height";
|
|
|
193 |
$string['head_data'] = "Graph data";
|
|
|
194 |
$string['head_size'] = "Graph size";
|
|
|
195 |
$string['head_color'] = "Graph background color";
|
|
|
196 |
|
|
|
197 |
$string['anyone'] = "Anyone";
|
|
|
198 |
$string['anyone_summary'] = "Any user in the Campus will be able to view this report";
|
|
|
199 |
|
|
|
200 |
$string['currentuserfinalgrade'] = "Current user final grade in course";
|
|
|
201 |
|
|
|
202 |
$string['currentuserfinalgrade_summary'] = "This column shows the final grade of the current user in the row-course";
|
|
|
203 |
$string['userfield'] = "User profile field";
|
|
|
204 |
|
|
|
205 |
$string['cuserfield'] = "User field condition";
|
|
|
206 |
$string['direction'] = "Direction";
|
|
|
207 |
|
|
|
208 |
$string['courseparent'] = "Courses whose parent is";
|
|
|
209 |
$string['coursechild'] = "Courses that are children of";
|
|
|
210 |
|
|
|
211 |
$string['currentusercourses'] = "Current user enrolled courses";
|
|
|
212 |
$string['currentusercourses_summary'] = "A list of the current users courses (only visible courses)";
|
|
|
213 |
$string['currentreportcourse'] = "Current report course";
|
|
|
214 |
$string['currentreportcourse_summary'] = "The course where the report has been created";
|
|
|
215 |
|
|
|
216 |
$string['coursefieldorder'] = "Course field order";
|
|
|
217 |
|
|
|
218 |
$string['fcoursefield'] = "Course field filter";
|
|
|
219 |
$string['usersincoursereport'] = "Any user in the current report course";
|
|
|
220 |
|
|
|
221 |
$string['groupvalues'] = "Group same values (sum)";
|
|
|
222 |
$string['fuserfield'] = "User field filter";
|
|
|
223 |
$string['fsearchuserfield'] = "User field search box";
|
|
|
224 |
|
|
|
225 |
$string['module'] = "Module";
|
|
|
226 |
|
|
|
227 |
$string['usersincurrentcourse'] = "Users in current report course";
|
|
|
228 |
$string['usersincurrentcourse_summary'] = "Users with the role/s selected in the report course";
|
|
|
229 |
|
|
|
230 |
$string['usermodoutline'] = "User module outline stats";
|
|
|
231 |
$string['donotshowtime'] = "Do not show date information";
|
|
|
232 |
$string['usermodactions'] = "User module actions";
|
|
|
233 |
|
|
|
234 |
$string['currentuser'] = "Current user";
|
|
|
235 |
$string['currentuser_summary'] = "The user that is viewing the report";
|
|
|
236 |
|
|
|
237 |
$string['puserfield'] = "User field value";
|
|
|
238 |
$string['puserfield_summary'] = "User with the selected value in the selected field";
|
|
|
239 |
|
|
|
240 |
$string['startendtime'] = "Start / End date filter";
|
|
|
241 |
$string['starttime'] = "Start date";
|
|
|
242 |
$string['endtime'] = "End date";
|
|
|
243 |
|
|
|
244 |
$string['template'] = "Template";
|
|
|
245 |
$string['availablemarks'] = "Available marks";
|
|
|
246 |
$string['header'] = "Header";
|
|
|
247 |
$string['footer'] = "Footer";
|
|
|
248 |
$string['templaterecord'] = "Record template";
|
|
|
249 |
$string['querysql'] = "SQL Query";
|
|
|
250 |
$string['filterstartendtime_summary'] = "Start / End date filter";
|
|
|
251 |
|
|
|
252 |
$string['pagination'] = "Pagination";
|
|
|
253 |
$string['disabled'] = "Disabled";
|
|
|
254 |
$string['enabled'] = "Enabled";
|
|
|
255 |
|
|
|
256 |
$string['reportcolumn'] = "Other report column";
|
|
|
257 |
|
|
|
258 |
$string['reporttable'] = "Report table";
|
|
|
259 |
$string['columnandcellproperties'] = "Column and cell properties";
|
|
|
260 |
$string['componenthelp'] = "Component help";
|
|
|
261 |
|
|
|
262 |
$string['badsize'] = 'Incorrect size, it must be in % or px';
|
|
|
263 |
$string['badtablewidth'] = 'Incorrect width, it must be in % or absolute value';
|
|
|
264 |
$string['missingcolumn'] = "A column is required";
|
|
|
265 |
$string['error_operator'] = "Operator not allowed";
|
|
|
266 |
|
|
|
267 |
$string['error_field'] = "Field not allowed";
|
|
|
268 |
$string['error_value_expected_integer'] = "Expected integer value";
|
|
|
269 |
$string['badconditionexpr'] = "Incorrect condition expression";
|
|
|
270 |
|
|
|
271 |
$string['notallowedwords'] = "Not allowed words";
|
|
|
272 |
$string['nosemicolon'] = "No semicolon";
|
|
|
273 |
$string['noexplicitprefix'] = "No explicit prefix";
|
|
|
274 |
$string['queryfailed'] = 'Query failed <code><pre>{$a}</pre></code>';
|
|
|
275 |
$string['norowsreturned'] = "No rows returned";
|
|
|
276 |
|
|
|
277 |
$string['listofsqlreports'] = 'Press F11 when cursor is in the editor to toggle full screen editing. Esc can also be used to exit full screen editing.<br/><br/><a href="http://docs.moodle.org/en/ad-hoc_contributed_reports" target="_blank">List of SQL Contributed reports</a>';
|
|
|
278 |
|
|
|
279 |
$string['usersincoursereport_summary'] = "Any user in the current report course";
|
|
|
280 |
|
|
|
281 |
$string['printreport'] = 'Print report';
|
|
|
282 |
|
|
|
283 |
$string['importreport'] = "Import report";
|
|
|
284 |
$string['exportreport'] = "Export report";
|
|
|
285 |
|
|
|
286 |
$string['download'] = "Download";
|
|
|
287 |
|
|
|
288 |
$string['report_timeline'] = 'Timeline report';
|
|
|
289 |
$string['timeline'] = 'Timeline';
|
|
|
290 |
$string['timemode'] = 'Time mode';
|
|
|
291 |
$string['previousdays'] = 'Previous days';
|
|
|
292 |
$string['fixeddate'] = 'Fixed date';
|
|
|
293 |
$string['previousstart'] = 'Previous start';
|
|
|
294 |
$string['previousend'] = 'Previous end';
|
|
|
295 |
$string['forcemidnight'] = 'Force midnight';
|
|
|
296 |
$string['timeinterval'] = 'Time interval';
|
|
|
297 |
$string['date'] = 'Date';
|
|
|
298 |
$string['dateformat'] = 'Date format';
|
|
|
299 |
$string['customdateformat'] = 'Custom date format';
|
|
|
300 |
$string['custom'] = 'Custom';
|
|
|
301 |
|
|
|
302 |
$string['line'] = 'Line graph';
|
|
|
303 |
$string['userstats'] = 'User statistics';
|
|
|
304 |
$string['stat'] = 'Statistic';
|
|
|
305 |
$string['statslogins'] = 'Logins in the platform';
|
|
|
306 |
$string['activityview'] = 'Activity views';
|
|
|
307 |
$string['activitypost'] = 'Activity posts';
|
|
|
308 |
$string[''] = '';
|
|
|
309 |
$string['globalstatsshouldbeenabled'] = 'Site statistics must be enabled. Go to Admin -> Server -> Statistics';
|
|
|
310 |
|
|
|
311 |
$string['xaxis'] = 'X Axis';
|
|
|
312 |
$string['yaxis'] = 'Y Axis';
|
|
|
313 |
$string['serieid'] = 'Serie column';
|
|
|
314 |
$string['groupseries'] = 'Group series';
|
|
|
315 |
$string['linesummary'] = 'A line graph with multiple series of data';
|
|
|
316 |
$string['xandynotequal'] = 'X and Y axis need to be different';
|
|
|
317 |
|
|
|
318 |
$string['coursestats'] = 'Course stats';
|
|
|
319 |
$string['statstotalenrolments'] = 'Total enrolments';
|
|
|
320 |
$string['statsactiveenrolments'] = 'Active (last week) enrolments';
|
|
|
321 |
$string['youmustselectarole'] = 'At least a role is required';
|
|
|
322 |
|
|
|
323 |
$string['report_categories'] = 'Categories report';
|
|
|
324 |
$string['categoryfield'] = 'Category field';
|
|
|
325 |
$string['categoryfieldorder'] = 'Category field order';
|
|
|
326 |
$string['categories'] = 'Categories';
|
|
|
327 |
$string['parentcategory'] = 'Parent category';
|
|
|
328 |
$string['filtercategories'] = 'Filter categories';
|
|
|
329 |
$string['filtercategories_summary'] = 'To filter by category';
|
|
|
330 |
|
|
|
331 |
$string['includesubcats'] = 'Include subcategories';
|
|
|
332 |
|
|
|
333 |
$string['coursededicationtime'] = 'Course dedication time';
|
|
|
334 |
|
|
|
335 |
$string['jsordering_help'] = 'JavaScript Ordering allow you to order the report table without reloading the page';
|
|
|
336 |
$string['pagination_help'] = 'Number of records to show in each page. Zero means no pagination';
|
|
|
337 |
$string['typeofreport_help'] = 'Choose the type of report you want to create.
|
|
|
338 |
For security, SQL Report requires an additional capability';
|
|
|
339 |
$string['template_marks'] = 'Template marks';
|
|
|
340 |
$string['template_marks_help'] = '<p>You can use any of this replacement marks:</p>
|
|
|
341 |
|
|
|
342 |
<ul>
|
|
|
343 |
<li>##reportname## - For including the report name</li>
|
|
|
344 |
<li>##reportsummary## - For including the reports summary</li>
|
|
|
345 |
<li>##graphs## - For including the graphs</li>
|
|
|
346 |
<li>##exportoptions## - For including the export options</li>
|
|
|
347 |
<li>##calculationstable## - For including the calculations table</li>
|
|
|
348 |
<li>##pagination## - For including the pagination </li>
|
|
|
349 |
|
|
|
350 |
</ul>';
|
|
|
351 |
|
|
|
352 |
|
|
|
353 |
|
|
|
354 |
$string['conditionexpr_conditions'] = 'Condition';
|
|
|
355 |
$string['conditionexpr_conditions_help'] = '<p>You can combine conditions using a logic expression</p>
|
|
|
356 |
|
|
|
357 |
<p>Enter a valid logic expression with these operators: and, or.</p>';
|
|
|
358 |
|
|
|
359 |
$string['conditionexpr_permissions'] = 'Condition';
|
|
|
360 |
$string['conditionexpr_permissions_help'] = '<p>You can combine conditions using a logic expression</p>
|
|
|
361 |
|
|
|
362 |
<p>Enter a valid logic expression with these operators: and, or.</p>';
|
|
|
363 |
|
|
|
364 |
$string['reporttable_help'] = '<p>This is the width of the table that will display the report records.</p>
|
|
|
365 |
|
|
|
366 |
<p>If you use a Template this option has no effect</p>';
|
|
|
367 |
|
|
|
368 |
$string['comp_calcs'] = 'Calcs';
|
|
|
369 |
$string['comp_calcs_help'] = '<p>Here you can add calculations for columns, i.e: average of number of users enrolled in courses</p>
|
|
|
370 |
|
|
|
371 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
372 |
|
|
|
373 |
$string['comp_calculations'] = 'Calcs';
|
|
|
374 |
$string['comp_calculations_help'] = '<p>Here you can add calculations for columns, i.e: average of number of users enrolled in courses</p>';
|
|
|
375 |
$string['comp_conditions'] = 'Conditions';
|
|
|
376 |
$string['comp_conditions_help'] = '<p>Here you can define the conditions (i.e, only courses from this category, only users from Spain, etc.. </p>
|
|
|
377 |
|
|
|
378 |
<p>You can add a logical expression if you are using more than one condition.</p>
|
|
|
379 |
|
|
|
380 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
381 |
$string['comp_customsql'] = 'Custom SQL';
|
|
|
382 |
$string['comp_customsql_help'] = '<p>Add a working SQL query. Do no use the moodle database prefix $CFG->prefix instead use "prefix_" without quotes</p>
|
|
|
383 |
<p>Example: SELECT * FROM prefix_course</p>
|
|
|
384 |
|
|
|
385 |
<p>You can find a lot of SQL Reports here: <a href="http://docs.moodle.org/en/ad-hoc_contributed_reports" target="_blank">ad-hoc contributed reports</a></p>
|
|
|
386 |
|
|
|
387 |
<p>An updated layout of Moodle\'s tables and their interconnected relations: <a href="https://docs.moodle.org/dev/Database_Schema" target="_blank">Database schema</a></p>
|
|
|
388 |
|
|
|
389 |
<p>Since this block supports Tim Hunt\'s CustomSQL Queries Reports, you can use any query.</p>
|
|
|
390 |
|
|
|
391 |
<p>Remember to add a "Time filter" if you are going to use reports with time tokens. </p>
|
|
|
392 |
|
|
|
393 |
<p>For using filters see: <a href="http://docs.moodle.org/en/blocks/configurable_reports/#Creating_a_SQL_Report" target="_blank">Creating a SQL Report Tutorial</a></p>';
|
|
|
394 |
|
|
|
395 |
$string['comp_ordering'] = 'Ordering';
|
|
|
396 |
$string['comp_ordering_help'] = '<p>Here you can choose how to order the report using fields and directions</p>
|
|
|
397 |
|
|
|
398 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
399 |
$string['comp_permissions'] = 'Permissions';
|
|
|
400 |
$string['comp_permissions_help'] = '<p>Here you can choose who can view a report.</p>
|
|
|
401 |
|
|
|
402 |
<p>You can add a logical expression to calculate the final permission if you are using more than one condition.</p>
|
|
|
403 |
|
|
|
404 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
405 |
$string['comp_plot'] = 'Plot';
|
|
|
406 |
$string['comp_plot_help'] = '<p>Here you can add graphs to your report based on the report columns and values</p>
|
|
|
407 |
|
|
|
408 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
409 |
$string['comp_template'] = 'Template';
|
|
|
410 |
$string['comp_template_help'] = '<p>You can modify the report\'s layout by creating a template</p>
|
|
|
411 |
|
|
|
412 |
<p>For creating a template see the replacemnet marks you can use in header, footer and for each report record using the help buttons or the information displayed in the same page.</p>
|
|
|
413 |
|
|
|
414 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
415 |
$string['comp_filters'] = 'Filters';
|
|
|
416 |
$string['comp_filters_help'] = '<p>Here you can choose which filters will be displayed</p>
|
|
|
417 |
|
|
|
418 |
<p>A filter lets an user to choose columns from the report to filter the report results</p>
|
|
|
419 |
|
|
|
420 |
<p>For using filters if your report type is SQL see: <a href="http://docs.moodle.org/en/blocks/configurable_reports/#Creating_a_SQL_Report" target="_blank">Creating a SQL Report Tutorial</a></p>
|
|
|
421 |
|
|
|
422 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
423 |
$string['comp_columns'] = 'Columns';
|
|
|
424 |
$string['comp_columns_help'] = '<p>Here you can choose the different columns of your report depending on the type of report</p>
|
|
|
425 |
|
|
|
426 |
<p>More help: <a href="http://docs.moodle.org/en/blocks/configurable_reports/" target="_blank">Plugin documentation</a></p>';
|
|
|
427 |
|
|
|
428 |
$string['coursecategories'] = 'Category course filter';
|
|
|
429 |
$string['filtercoursecategories'] = 'Category course filter';
|
|
|
430 |
$string['filtercoursecategories_summary'] = 'Filter courses by their any parent category';
|
|
|
431 |
|
|
|
432 |
$string['dbhost'] = "DB Host";
|
|
|
433 |
$string['dbhostinfo'] = "Remote Database host name (on which, we will be executing our SQL queries)";
|
|
|
434 |
$string['dbname'] = "DB Name";
|
|
|
435 |
$string['dbnameinfo'] = "Remote Database name (on which, we will be executing our SQL queries)";
|
|
|
436 |
$string['dbuser'] = "DB Username";
|
|
|
437 |
$string['dbuserinfo'] = "Remote Database username (should have SELECT privileges on above DB)";
|
|
|
438 |
$string['dbpass'] = "DB Password";
|
|
|
439 |
$string['dbpassinfo'] = "Remote Database password (for above username)";
|
|
|
440 |
|
|
|
441 |
$string['totalrecords'] = 'Total record count = {$a->totalrecords}';
|
|
|
442 |
$string['lastexecutiontime'] = 'Execution time = {$a} (Sec)';
|
|
|
443 |
|
|
|
444 |
$string['reportcategories'] = '1) Choose a remote report categories';
|
|
|
445 |
$string['reportsincategory'] = '2) Choose a report form the list';
|
|
|
446 |
$string['remotequerysql'] = 'SQL query';
|
|
|
447 |
$string['executeat'] = 'Execute at';
|
|
|
448 |
$string['executeatinfo'] = 'Moodle CRON will run scheduled SQL queries after selected time. Once in 24h';
|
|
|
449 |
$string['sharedsqlrepository'] = 'Shared sql repository';
|
|
|
450 |
$string['sharedsqlrepositoryinfo'] = 'Name of GitHub account owner + slash + repository name';
|
|
|
451 |
$string['sqlsyntaxhighlight'] = 'Highlight SQL syntax';
|
|
|
452 |
$string['sqlsyntaxhighlightinfo'] = 'Highlight SQL syntax in code editor (CodeMirror JS library)';
|
|
|
453 |
$string['datatables'] = 'Enable DataTables JS library';
|
|
|
454 |
$string['datatablesinfo'] = 'DataTables JS library (Column sort, fixed header, search, paging...)';
|
|
|
455 |
$string['reporttableui'] = 'Report table UI';
|
|
|
456 |
$string['reporttableuiinfo'] = 'Display the report table as: Simple scrollable HTML table, jQuery with column sorting Or DataTables JS library (Column sort, fixed header, search, paging...)';
|
|
|
457 |
|
|
|
458 |
$string['email_subject'] = 'Subject';
|
|
|
459 |
$string['email_message'] = 'Message';
|
|
|
460 |
$string['email_send'] = 'Send';
|
|
|
461 |
|
|
|
462 |
$string['sqlsecurity'] = 'SQL Security';
|
|
|
463 |
$string['sqlsecurityinfo'] = 'Disable for executing SQL queries with statements for inserting data';
|
|
|
464 |
|
|
|
465 |
$string['global'] = 'Global report';
|
|
|
466 |
$string['enableglobal'] = 'This is a global report (accesible from any course)';
|
|
|
467 |
$string['global_help'] = 'Global report can be accessed from any course in the platform just appending &courseid=MY_COURSE_ID in the report URL';
|
|
|
468 |
|
|
|
469 |
$string['crrepository'] = 'Reports repository';
|
|
|
470 |
$string['crrepositoryinfo'] = 'Remote shared repository with sample reports fully functional (Name of GitHub account owner + slash + repository name)';
|
|
|
471 |
$string['importfromrepository'] = 'Import report from repository';
|
|
|
472 |
$string['repository'] = 'Reports repository';
|
|
|
473 |
$string['repository_help'] = 'You can import sample reports from a public shared repository.
|
|
|
474 |
|
|
|
475 |
Please, notice that there is a daily limit of calls to the repository.
|
|
|
476 |
|
|
|
477 |
If the connection to the repository is not working, you can download manually here <a href="https://github.com/jleyva/moodle-configurable_reports_repository" target="_blank">https://github.com/jleyva/moodle-configurable_reports_repository</a> a report and then import it using the "Import report" feature displayed bellow
|
|
|
478 |
';
|
|
|
479 |
$string['reportcreated'] = 'Report successfully created';
|
|
|
480 |
$string['usersincohorts'] = 'User who are member of a/several cohorts';
|
|
|
481 |
$string['usersincohorts_summary'] = 'Only the users who are members of the selected cohorts';
|
|
|
482 |
$string['displayglobalreports'] = 'Display global reports';
|
|
|
483 |
$string['displayreportslist'] = 'Display the reports list in the block body';
|
|
|
484 |
|
|
|
485 |
$string['usercompletion'] = 'User course completion status';
|
|
|
486 |
$string['usercompletionsummary'] = 'Course completion status';
|
|
|
487 |
|
|
|
488 |
$string['finalgradeincurrentcourse'] = 'Final grade in current course';
|
|
|
489 |
$string['legacylognotenabled'] = 'Legacy logs must be enabled.
|
|
|
490 |
Go to Site administration / Plugins / Logging Enable the Legacy log and inside the log settings check Log legacy data';
|
|
|
491 |
|
|
|
492 |
$string['datatables_sortascending'] = ': activate to sort column ascending';
|
|
|
493 |
$string['datatables_sortdescending'] = ': activate to sort column descending';
|
|
|
494 |
$string['datatables_first'] = 'First';
|
|
|
495 |
$string['datatables_last'] = 'Last';
|
|
|
496 |
$string['datatables_next'] = 'Next';
|
|
|
497 |
$string['datatables_previous'] = 'Previous';
|
|
|
498 |
$string['datatables_emptytable'] = 'No data available in table';
|
|
|
499 |
$string['datatables_info'] = 'Showing _START_ to _END_ of _TOTAL_ entries';
|
|
|
500 |
$string['datatables_infoempty'] = 'Showing 0 to 0 of 0 entries';
|
|
|
501 |
$string['datatables_infofiltered'] = '(filtered from _MAX_ total entries)';
|
|
|
502 |
$string['datatables_lengthmenu'] = 'Show _MENU_ entries';
|
|
|
503 |
$string['datatables_loadingrecords'] = 'Loading...';
|
|
|
504 |
$string['datatables_processing'] = 'Processing...';
|
|
|
505 |
$string['datatables_search'] = 'Search:';
|
|
|
506 |
$string['datatables_zerorecords'] = 'No matching records found';
|
|
|
507 |
// New features: Graph new column.
|
|
|
508 |
|
|
|
509 |
$string['others'] = 'Others';
|
|
|
510 |
$string['limitcategories'] = 'Limit categories in a graph';
|
|
|
511 |
$string['decimals'] = 'Number of decimals';
|
|
|
512 |
$string['sessionlimittime'] = 'Limit between clicks (in minutes)';
|
|
|
513 |
$string['sessionlimittime_help'] = 'The limit between clicks defines if two clicks are part of the same session or not';
|
|
|
514 |
|
|
|
515 |
$string['excludedeletedusers'] = 'Exclude deleted users (only for SQL reports)';
|
|
|
516 |
|
|
|
517 |
// Privacy provider.
|
|
|
518 |
$string['privacy:metadata:block_configurable_reports'] = 'The configurable reports block contains customizable course reports.';
|
|
|
519 |
$string['privacy:metadata:block_configurable_reports:courseid'] = 'Course ID';
|
|
|
520 |
$string['privacy:metadata:block_configurable_reports:ownerid'] = 'The ID of the user who created the report';
|
|
|
521 |
$string['privacy:metadata:block_configurable_reports:visible'] = 'Whether the report is visible or not';
|
|
|
522 |
$string['privacy:metadata:block_configurable_reports:global'] = 'Whether the report is accessible from all the courses or not';
|
|
|
523 |
$string['privacy:metadata:block_configurable_reports:name'] = 'The name of the report';
|
|
|
524 |
$string['privacy:metadata:block_configurable_reports:summary'] = 'The description of the report';
|
|
|
525 |
$string['privacy:metadata:block_configurable_reports:type'] = 'The type of the report';
|
|
|
526 |
$string['privacy:metadata:block_configurable_reports:components'] = 'The configuration of the report. It contains the query,
|
|
|
527 |
the filters...';
|
|
|
528 |
$string['privacy:metadata:block_configurable_reports:lastexecutiontime'] = 'Time this report took to run last time it was executed,
|
|
|
529 |
in milliseconds.';
|
|
|
530 |
// Filter forms.
|
|
|
531 |
$string['add'] = 'Add';
|
|
|
532 |
$string['description'] = 'Description';
|
|
|
533 |
$string['description_help'] = 'Text used to describe the filter that will be displayed in the summary on the filters page.';
|
|
|
534 |
$string['label'] = 'Label';
|
|
|
535 |
$string['label_help'] = 'Text describing the filter to be displayed on the report page.';
|
|
|
536 |
$string['idnumber'] = 'ID Number';
|
|
|
537 |
$string['idnumber_help'] = 'Used to differentiate between filters of the same type. Case-sensitive. Example usage: %%FILTER_SEARCHTEXT_username:u.username:~%%';
|
|
|
538 |
// Pie Chart Strings
|
|
|
539 |
$string['description'] = 'Description';
|
|
|
540 |
$string['legendheader'] = 'Mapped Palette';
|
|
|
541 |
$string['legendheaderdesc'] = 'Map color codes to specific keys in the pie chart legend.';
|
|
|
542 |
$string['piechart_label'] = 'Key - {$a}';
|
|
|
543 |
$string['piechart_label_color'] = 'Color - {$a}';
|
|
|
544 |
$string['piechart_add_colors'] = 'Add color';
|
|
|
545 |
$string['invalidcolorcode'] = 'Invalid color code';
|
|
|
546 |
$string['generalcolorpaletteheader'] = 'General color palette';
|
|
|
547 |
$string['generalcolorpalette'] = 'Unmapped Palette';
|
|
|
548 |
$string['generalcolorpalette_help'] = 'Hexadecimal color codes for general use in the pie chart. Codes should be separated by new lines in the order you wish them to be used in the pie chart.';
|
|
|
549 |
$string['checksql_execution'] = 'Block Configurable Reports SQL execution';
|
|
|
550 |
$string['checksql_execution_ok'] = 'SQL execution is disabled.';
|
|
|
551 |
$string['checksql_execution_warning'] = 'It is recommended to disable SQL execution to avoid execution of arbitrary SQL code in your server.';
|
|
|
552 |
$string['checksql_execution_details'] = 'By allowing SQL code execution there is a potential security issue with users adding arbitrary code. SQL code execution should be disable to only allow SQL queries for reading/retreaving data. SQL execution can be disabled in your config.php file by setting $CFG->block_configurable_reports_enable_sql_execution to 0';
|