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.