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
|
<?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/>.
/**
* This is a one-line short description of the file
*
* You can have a rather longer description of the file as well,
* if you like, and it can span multiple lines.
*
* @package mod
* @subpackage sqlbox
* @copyright 2012 Jan Klemkow, Benjamin Franzke
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
require_once(dirname(dirname(dirname(__FILE__))).'/config.php');
require_once(dirname(__FILE__).'/lib.php');
$id = required_param('id', PARAM_INT); // course
$course = $DB->get_record('course', array('id' => $id), '*', MUST_EXIST);
require_course_login($course);
add_to_log($course->id, 'sqlbox', 'view all', 'index.php?id='.$course->id, '');
$coursecontext = get_context_instance(CONTEXT_COURSE, $course->id);
$PAGE->set_url('/mod/sqlbox/index.php', array('id' => $id));
$PAGE->set_title(format_string($course->fullname));
$PAGE->set_heading(format_string($course->fullname));
$PAGE->set_context($coursecontext);
echo $OUTPUT->header();
if (! $sqlboxs = get_all_instances_in_course('sqlbox', $course)) {
notice(get_string('nosqlboxs', 'sqlbox'), new moodle_url('/course/view.php', array('id' => $course->id)));
}
$table = new html_table;
if ($course->format == 'weeks') {
$table->head = array(get_string('week'), get_string('name'));
$table->align = array('center', 'left');
} else if ($course->format == 'topics') {
$table->head = array(get_string('topic'), get_string('name'));
$table->align = array('center', 'left', 'left', 'left');
} else {
$table->head = array(get_string('name'));
$table->align = array('left', 'left', 'left');
}
foreach ($sqlboxs as $sqlbox) {
if (!$sqlbox->visible) {
$link = html_writer::link(
new moodle_url('/mod/sqlbox/view.php', array('id' => $sqlbox->coursemodule)),
format_string($sqlbox->name, true),
array('class' => 'dimmed'));
} else {
$link = html_writer::link(
new moodle_url('/mod/sqlbox/view.php', array('id' => $sqlbox->coursemodule)),
format_string($sqlbox->name, true));
}
if ($course->format == 'weeks' or $course->format == 'topics') {
$table->data[] = array($sqlbox->section, $link);
} else {
$table->data[] = array($link);
}
}
echo $OUTPUT->heading(get_string('modulenameplural', 'sqlbox'), 2);
echo html_writer::table($table);
echo $OUTPUT->footer();
|
