|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace smtech\GradingAnalytics; |
|
4
|
|
|
|
|
5
|
|
|
use smtech\LTI\Configuration\Option; |
|
6
|
|
|
use Battis\HierarchicalSimpleCache; |
|
7
|
|
|
|
|
8
|
|
|
class Toolbox extends \smtech\StMarksReflexiveCanvasLTI\Toolbox |
|
9
|
|
|
{ |
|
10
|
|
|
protected $courseHistory = []; |
|
11
|
|
|
|
|
12
|
|
|
const DEPT = 0; |
|
13
|
|
|
const SCHOOL = 1; |
|
14
|
|
|
|
|
15
|
|
|
protected $snapshots = [[], []]; |
|
16
|
|
|
|
|
17
|
|
|
const AVERAGE_TURN_AROUND = 0; |
|
18
|
|
|
const AVERAGE_ASSIGNMENT_COUNT = 1; |
|
19
|
|
|
|
|
20
|
|
|
protected $numbers = [[], []]; |
|
21
|
|
|
|
|
22
|
|
|
public function getGenerator() |
|
23
|
|
|
{ |
|
24
|
|
|
parent::getGenerator(); |
|
25
|
|
|
|
|
26
|
|
|
$this->generator->setOptionProperty( |
|
27
|
|
|
Option::COURSE_NAVIGATION(), |
|
28
|
|
|
'visibility', |
|
29
|
|
|
'admins' |
|
30
|
|
|
); |
|
31
|
|
|
$this->generator->setOptionProperty( |
|
32
|
|
|
Option::ACCOUNT_NAVIGATION(), |
|
33
|
|
|
'visibility', |
|
34
|
|
|
'admins' |
|
35
|
|
|
); |
|
36
|
|
|
|
|
37
|
|
|
return $this->generator; |
|
38
|
|
|
} |
|
39
|
|
|
|
|
40
|
|
|
private $GRAPH_DATA_COUNT = 0; |
|
41
|
|
|
public function graphWidth($dataCount = false) |
|
42
|
|
|
{ |
|
43
|
|
|
if ($dataCount) { |
|
44
|
|
|
$this->GRAPH_DATA_COUNT = $dataCount; |
|
|
|
|
|
|
45
|
|
|
} |
|
46
|
|
|
return max(GRAPH_MIN_WIDTH, $this->GRAPH_DATA_COUNT * GRAPH_BAR_WIDTH); |
|
47
|
|
|
} |
|
48
|
|
|
|
|
49
|
|
|
public function graphHeight($dataCount = false) |
|
50
|
|
|
{ |
|
51
|
|
|
if ($dataCount) { |
|
52
|
|
|
$this->GRAPH_DATA_COUNT = $dataCount; |
|
|
|
|
|
|
53
|
|
|
} |
|
54
|
|
|
return $this->graphWidth() * GRAPH_ASPECT_RATIO; |
|
55
|
|
|
} |
|
56
|
|
|
|
|
57
|
|
|
public function getMostCurrentCourseTimestamp($courseId) |
|
58
|
|
|
{ |
|
59
|
|
|
return substr($this->getCourseHistory($courseId)[0]['timestamp'], 0, 10); |
|
60
|
|
|
} |
|
61
|
|
|
|
|
62
|
|
|
public function getDepartmentId($courseId) |
|
63
|
|
|
{ |
|
64
|
|
|
return $this->getCourseHistory($courseId)[0]['course[account_id]']; |
|
65
|
|
|
} |
|
66
|
|
|
|
|
67
|
|
|
public function getCourseHistory($courseId) |
|
68
|
|
|
{ |
|
69
|
|
|
if (empty($this->courseHistory)) { |
|
70
|
|
|
$cache = new HierarchicalSimpleCache($this->getMySql(), $this->config(self::TOOL_ID)); |
|
71
|
|
|
$cache->pushKey('course'); |
|
72
|
|
|
$this->courseHistory = $cache->getCache($courseId); |
|
|
|
|
|
|
73
|
|
|
if (empty($this->courseHistory)) { |
|
74
|
|
|
if ($response = $this->mysql_query(" |
|
75
|
|
|
SELECT * FROM `course_statistics` |
|
76
|
|
|
WHERE |
|
77
|
|
|
`course[id]` = '$courseId' |
|
78
|
|
|
ORDER BY |
|
79
|
|
|
`timestamp` DESC |
|
80
|
|
|
")) { |
|
81
|
|
|
while ($row = $response->fetch_assoc()) { |
|
82
|
|
|
$this->courseHistory[] = $row; |
|
83
|
|
|
} |
|
84
|
|
|
$cache->setCache($courseId, $this->courseHistory); |
|
85
|
|
|
} |
|
86
|
|
|
} |
|
87
|
|
|
} |
|
88
|
|
|
return $this->courseHistory; |
|
89
|
|
|
} |
|
90
|
|
|
|
|
91
|
|
|
public function getCourseSnapshot($courseId) |
|
92
|
|
|
{ |
|
93
|
|
|
$history = $this->getCourseHistory($courseId); |
|
94
|
|
|
if (!empty($history)) { |
|
95
|
|
|
return $history[0]; |
|
96
|
|
|
} |
|
97
|
|
|
return false; |
|
98
|
|
|
} |
|
99
|
|
|
|
|
100
|
|
|
public function getDepartmentSnapshot($courseId) |
|
101
|
|
|
{ |
|
102
|
|
|
return $this->getSnapshot($courseId, self::DEPT); |
|
103
|
|
|
} |
|
104
|
|
|
|
|
105
|
|
|
public function getSchoolSnapshot($courseId) |
|
106
|
|
|
{ |
|
107
|
|
|
return $this->getSnapshot($courseId, self::SCHOOL); |
|
108
|
|
|
} |
|
109
|
|
|
|
|
110
|
|
|
public function getSnapshot($courseId, $domain = self::DEPT) |
|
111
|
|
|
{ |
|
112
|
|
|
if (empty($this->snapshots[$domain])) { |
|
113
|
|
|
$cache = new HierarchicalSimpleCache($this->getMySql(), $this->config(self::TOOL_ID)); |
|
114
|
|
|
$cache->pushKey('snapshot'); |
|
115
|
|
|
if ($domain === self::DEPT) { |
|
116
|
|
|
$cache->pushKey('account'); |
|
117
|
|
|
} |
|
118
|
|
|
$key = ($domain === self::DEPT ? $this->getDepartmentId($courseId) : 'school'); |
|
119
|
|
|
$this->snapshots[$domain] = $cache->getCache($key); |
|
120
|
|
|
$this->numbers[$domain] = $cache->getCache("$key-numbers"); |
|
121
|
|
|
if (empty($this->snapshots[$domain])) { |
|
122
|
|
|
if ($response = $this->mysql_query(" |
|
123
|
|
|
SELECT * FROM `course_statistics` |
|
124
|
|
|
WHERE |
|
125
|
|
|
" . ($domain === self::DEPT ? "`course[account_id]` = '" . $this->getDepartmentId($courseId) . "' AND" : '') . " |
|
126
|
|
|
`timestamp` LIKE '" . $this->getMostCurrentCourseTimestamp($courseId) . "%' |
|
127
|
|
|
GROUP BY |
|
128
|
|
|
`course[id]` |
|
129
|
|
|
ORDER BY |
|
130
|
|
|
`timestamp` DESC |
|
131
|
|
|
")) { |
|
132
|
|
|
$totalTurnAround = 0; |
|
133
|
|
|
$divisorTurnAround = 0; |
|
134
|
|
|
$totalAssignmentCount = 0; |
|
135
|
|
|
|
|
136
|
|
|
while ($row = $response->fetch_assoc()) { |
|
137
|
|
|
$this->snapshots[$domain][] = $row; |
|
138
|
|
|
|
|
139
|
|
|
/* average turn-around */ |
|
140
|
|
|
$totalTurnAround += $row['average_grading_turn_around'] * $row['student_count'] * $row['graded_assignment_count']; |
|
141
|
|
|
$divisorTurnAround += $row['student_count'] * $row['graded_assignment_count']; |
|
142
|
|
|
|
|
143
|
|
|
/* average assignment count */ |
|
144
|
|
|
$totalAssignmentCount += $row['assignments_due_count'] + $row['dateless_assignment_count']; |
|
145
|
|
|
} |
|
146
|
|
|
$this->numbers[$domain][self::AVERAGE_TURN_AROUND] = $totalTurnAround / $divisorTurnAround; |
|
147
|
|
|
$this->numbers[$domain][self::AVERAGE_ASSIGNMENT_COUNT] = $totalAssignmentCount / $response->num_rows; |
|
148
|
|
|
|
|
149
|
|
|
$cache->setCache($key, $this->snapshots[$domain]); |
|
150
|
|
|
$cache->setCache("$key-numbers", $this->numbers[$domain]); |
|
151
|
|
|
} |
|
152
|
|
|
} |
|
153
|
|
|
} |
|
154
|
|
|
return $this->snapshots[$domain]; |
|
155
|
|
|
} |
|
156
|
|
|
|
|
157
|
|
View Code Duplication |
public function averageTurnAround($courseId, $domain = self::DEPT) |
|
|
|
|
|
|
158
|
|
|
{ |
|
159
|
|
|
$this->getSnapshot($courseId, $domain); |
|
160
|
|
|
if (!empty($this->numbers[$domain][self::AVERAGE_TURN_AROUND])) { |
|
161
|
|
|
return $this->numbers[$domain][self::AVERAGE_TURN_AROUND]; |
|
162
|
|
|
} |
|
163
|
|
|
return false; |
|
164
|
|
|
} |
|
165
|
|
|
|
|
166
|
|
View Code Duplication |
public function averageAssignmentCount($courseId, $domain = self::DEPT) |
|
|
|
|
|
|
167
|
|
|
{ |
|
168
|
|
|
$this->getSnapshot($courseId, $domain); |
|
169
|
|
|
if (!empty($this->numbers[$domain][self::AVERAGE_ASSIGNMENT_COUNT])) { |
|
170
|
|
|
return $this->numbers[$domain][self::AVERAGE_ASSIGNMENT_COUNT]; |
|
171
|
|
|
} |
|
172
|
|
|
return false; |
|
173
|
|
|
} |
|
174
|
|
|
} |
|
175
|
|
|
|
This check looks for assignments to scalar types that may be of the wrong type.
To ensure the code behaves as expected, it may be a good idea to add an explicit type cast.