1
|
|
|
<?php |
2
|
|
|
/* vim: set noexpandtab sw=2 ts=2 sts=2: */ |
3
|
|
|
namespace App\Controller; |
4
|
|
|
|
5
|
|
|
use App\Controller\AppController; |
6
|
|
|
use App\Utility\Sanitize; |
7
|
|
|
use Cake\Core\Configure; |
8
|
|
|
use Cake\Log\Log; |
9
|
|
|
use Cake\ORM\Table; |
10
|
|
|
use Cake\ORM\TableRegistry; |
11
|
|
|
use Cake\Network\Exception\NotFoundException; |
12
|
|
|
/** |
13
|
|
|
* Reports controller handling reports creation and rendering |
14
|
|
|
* |
15
|
|
|
* phpMyAdmin Error reporting server |
16
|
|
|
* Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net) |
17
|
|
|
* |
18
|
|
|
* Licensed under The MIT License |
19
|
|
|
* For full copyright and license information, please see the LICENSE.txt |
20
|
|
|
* Redistributions of files must retain the above copyright notice. |
21
|
|
|
* |
22
|
|
|
* @copyright Copyright (c) phpMyAdmin project (http://www.phpmyadmin.net) |
23
|
|
|
* @package Server.Controller |
24
|
|
|
* @link http://www.phpmyadmin.net |
25
|
|
|
* @license http://www.opensource.org/licenses/mit-license.php MIT License |
26
|
|
|
*/ |
27
|
|
|
|
28
|
|
|
/** |
29
|
|
|
* Reports controller handling reports modification and rendering |
30
|
|
|
* |
31
|
|
|
* @package Server.Controller |
32
|
|
|
*/ |
33
|
|
|
class ReportsController extends AppController { |
34
|
|
|
|
35
|
|
|
public $components = array('RequestHandler', 'OrderSearch'); |
36
|
|
|
|
37
|
|
|
public $helpers = array('Html', 'Form', 'Reports', 'Incidents'); |
38
|
|
|
public $uses = array('Incidents', 'Reports', 'Notifications', 'Developers'); |
39
|
|
|
|
40
|
1 |
|
public function index() { |
41
|
1 |
|
$this->Reports->recursive = -1; |
42
|
1 |
|
$this->set('distinct_statuses', |
43
|
1 |
|
$this->_findArrayList($this->Reports->find()->select(['status'])->distinct(['status']), |
44
|
1 |
|
'status') |
45
|
1 |
|
); |
46
|
1 |
|
$this->set('distinct_versions', |
47
|
1 |
|
$this->_findArrayList($this->Reports->find()->select(['pma_version'])->distinct(['pma_version']), 'pma_version') |
48
|
1 |
|
); |
49
|
1 |
|
$this->set('distinct_error_names', |
50
|
1 |
|
$this->_findArrayList($this->Reports->find('all', array( |
51
|
1 |
|
'fields' => array('error_name'), |
52
|
1 |
|
'conditions' => array('error_name !=' => ''), |
53
|
1 |
|
))->distinct(['error_name']), 'error_name') |
54
|
1 |
|
); |
55
|
1 |
|
$this->set('statuses', $this->Reports->status); |
56
|
1 |
|
$this->autoRender = true; |
57
|
1 |
|
} |
58
|
|
|
|
59
|
1 |
|
public function view($reportId) { |
60
|
1 |
|
if (!$reportId) { |
61
|
|
|
throw new NotFoundException(__('Invalid Report')); |
62
|
|
|
} |
63
|
1 |
|
$report = $this->Reports->findById($reportId)->toArray(); |
64
|
1 |
|
if (!$report) { |
65
|
1 |
|
throw new NotFoundException(__('Invalid Report')); |
66
|
|
|
} |
67
|
|
|
|
68
|
1 |
|
$this->set('report', $report); |
69
|
1 |
|
$this->set('project_name', Configure::read('GithubRepoPath')); |
70
|
1 |
|
$this->Reports->id = $reportId; |
71
|
1 |
|
$this->set('incidents', $this->Reports->getIncidents()->toArray()); |
72
|
1 |
|
$this->set('incidents_with_description', |
73
|
1 |
|
$this->Reports->getIncidentsWithDescription()); |
74
|
1 |
|
$this->set('incidents_with_stacktrace', |
75
|
1 |
|
$this->Reports->getIncidentsWithDifferentStacktrace()); |
76
|
1 |
|
$this->set('related_reports', $this->Reports->getRelatedReports()); |
77
|
1 |
|
$this->set('status', $this->Reports->status); |
78
|
1 |
|
$this->_setSimilarFields($reportId); |
79
|
|
|
|
80
|
|
|
// if there is an unread notification for this report, then mark it as read |
81
|
1 |
|
$current_developer = TableRegistry::get('Developers')-> |
|
|
|
|
82
|
1 |
|
findById($this->request->session()->read('Developer.id'))->all()->first(); |
83
|
|
|
//$current_developer = Sanitize::clean($current_developer); |
84
|
1 |
|
if ($current_developer) { |
85
|
1 |
|
TableRegistry::get('Notifications')->deleteAll( |
86
|
1 |
|
array('developer_id' => $current_developer['Developer']['id'], |
87
|
|
|
'report_id' => $reportId |
88
|
1 |
|
), |
89
|
|
|
false |
|
|
|
|
90
|
1 |
|
); |
91
|
1 |
|
} |
92
|
1 |
|
} |
93
|
|
|
|
94
|
1 |
|
public function data_tables() { |
95
|
|
|
$subquery_params = [ |
96
|
|
|
'fields' => [ |
97
|
1 |
|
'report_id' => 'report_id', |
98
|
|
|
'inci_count' => 'COUNT(id)' |
99
|
1 |
|
], |
100
|
|
|
'group' => 'report_id' |
101
|
1 |
|
]; |
102
|
1 |
|
$subquery = TableRegistry::get('incidents')->find('all', $subquery_params); |
103
|
|
|
|
104
|
|
|
// override automatic aliasing, for proper usage in joins |
105
|
|
|
$aColumns = [ |
106
|
1 |
|
'id' => 'id', |
107
|
1 |
|
'error_name' => 'error_name', |
108
|
1 |
|
'error_message' => 'error_message', |
109
|
1 |
|
'pma_version' => 'pma_version', |
110
|
1 |
|
'status' => 'status', |
111
|
1 |
|
'exception_type' => 'exception_type', |
112
|
|
|
'inci_count' => 'inci_count' |
113
|
1 |
|
]; |
114
|
|
|
|
115
|
1 |
|
$searchConditions = $this->OrderSearch->getSearchConditions($aColumns); |
116
|
1 |
|
$orderConditions = $this->OrderSearch->getOrder($aColumns); |
117
|
|
|
|
118
|
|
|
$params = [ |
119
|
1 |
|
'fields' => $aColumns, |
120
|
|
|
'conditions' => [ |
121
|
1 |
|
$searchConditions, |
122
|
|
|
'related_to is NULL' |
123
|
1 |
|
], |
124
|
1 |
|
'order' => $orderConditions, |
125
|
1 |
|
]; |
126
|
|
|
|
127
|
1 |
|
$pagedParams = $params; |
128
|
1 |
|
$pagedParams['limit'] = intval($this->request->query('iDisplayLength')); |
129
|
1 |
|
$pagedParams['offset'] = intval($this->request->query('iDisplayStart')); |
130
|
|
|
|
131
|
1 |
|
$rows = $this->_findAllDataTable( |
132
|
1 |
|
$this->Reports->find('all', $pagedParams)->innerJoin( |
133
|
1 |
|
['incidents' => $subquery], ['incidents.report_id = Reports.id'] |
134
|
1 |
|
) |
135
|
1 |
|
); |
136
|
|
|
//$rows = Sanitize::clean($rows); |
137
|
1 |
|
$totalFiltered = $this->Reports->find('all', $params)->count(); |
138
|
|
|
|
139
|
|
|
|
140
|
|
|
// change exception_type from boolean values to strings |
141
|
|
|
// add incident count for related reports |
142
|
1 |
|
$dispRows = array(); |
143
|
1 |
|
foreach($rows as $row) { |
144
|
1 |
|
$row[4] = $this->Reports->status[$row[4]]; |
145
|
1 |
|
$row[5] = (intval($row[5]))?('php'):('js'); |
146
|
|
|
$input_elem = "<input type='checkbox' name='reports[]' value='" |
147
|
1 |
|
. $row[0] |
148
|
1 |
|
. "'/>"; |
149
|
|
|
|
150
|
|
|
$subquery_params_count = [ |
151
|
|
|
'fields' => [ |
152
|
1 |
|
'report_id' => 'report_id', |
153
|
|
|
] |
154
|
1 |
|
]; |
155
|
1 |
|
$subquery_count = TableRegistry::get('incidents')->find( |
156
|
1 |
|
'all', $subquery_params_count |
157
|
1 |
|
); |
158
|
|
|
|
159
|
|
|
$params_count = [ |
160
|
1 |
|
'fields' => ['inci_count' => 'inci_count'], |
161
|
|
|
'conditions' => [ |
162
|
1 |
|
'related_to = ' . $row[0] |
163
|
1 |
|
] |
164
|
1 |
|
]; |
165
|
|
|
|
166
|
1 |
|
$inci_count_related = $this->Reports->find('all', $params_count)->innerJoin( |
167
|
1 |
|
['incidents' => $subquery_count], |
168
|
1 |
|
['incidents.report_id = Reports.related_to'] |
169
|
1 |
|
)->count(); |
170
|
|
|
|
171
|
1 |
|
$row[6] += $inci_count_related; |
172
|
|
|
|
173
|
1 |
|
array_unshift($row, $input_elem); |
174
|
1 |
|
array_push($dispRows, $row); |
175
|
1 |
|
} |
176
|
|
|
|
177
|
|
|
$response = array( |
178
|
1 |
|
'iTotalRecords' => $this->Reports->find('all')->count(), |
179
|
1 |
|
'iTotalDisplayRecords' => $totalFiltered, |
180
|
1 |
|
'sEcho' => intval($this->request->query('sEcho')), |
181
|
|
|
'aaData' => $dispRows |
182
|
1 |
|
); |
183
|
1 |
|
$this->autoRender = false; |
184
|
1 |
|
$this->response->body(json_encode($response)); |
185
|
1 |
|
return $this->response; |
186
|
|
|
} |
187
|
|
|
|
188
|
|
|
public function mark_related_to($reportId) { |
189
|
|
|
$relatedTo = $this->request->query("related_to"); |
190
|
|
|
if (!$reportId |
191
|
|
|
|| !$relatedTo |
192
|
|
|
|| $reportId == $relatedTo |
193
|
|
|
) { |
194
|
|
|
throw new NotFoundException(__('Invalid Report')); |
195
|
|
|
} |
196
|
|
|
|
197
|
|
|
$report = $this->Reports->get($reportId); |
198
|
|
|
if (!$report) { |
199
|
|
|
throw new NotFoundException(__('Invalid Report')); |
200
|
|
|
} |
201
|
|
|
|
202
|
|
|
$this->Reports->addToRelatedGroup($report, $relatedTo); |
203
|
|
|
|
204
|
|
|
$flash_class = "alert alert-success"; |
205
|
|
|
$this->Flash->default("This report has been marked the same as #" |
|
|
|
|
206
|
|
|
. $relatedTo, |
207
|
|
|
array("params" => array("class" => $flash_class))); |
208
|
|
|
$this->redirect("/reports/view/$reportId"); |
209
|
|
|
} |
210
|
|
|
|
211
|
|
|
public function unmark_related_to($reportId) { |
212
|
|
|
if (!$reportId) { |
213
|
|
|
throw new NotFoundException(__('Invalid Report')); |
214
|
|
|
} |
215
|
|
|
|
216
|
|
|
$report = $this->Reports->get($reportId); |
217
|
|
|
if (!$report) { |
218
|
|
|
throw new NotFoundException(__('Invalid Report')); |
219
|
|
|
} |
220
|
|
|
|
221
|
|
|
$this->Reports->removeFromRelatedGroup($report); |
222
|
|
|
|
223
|
|
|
$flash_class = "alert alert-success"; |
224
|
|
|
$this->Flash->default("This report has been marked as different.", |
|
|
|
|
225
|
|
|
array("params" => array("class" => $flash_class))); |
226
|
|
|
$this->redirect("/reports/view/$reportId"); |
227
|
|
|
} |
228
|
|
|
|
229
|
|
|
public function change_state($reportId) { |
230
|
|
|
if (!$reportId) { |
231
|
|
|
throw new NotFoundException(__('Invalid Report')); |
232
|
|
|
} |
233
|
|
|
|
234
|
|
|
$report = $this->Reports->get($reportId); |
235
|
|
|
if (!$report) { |
236
|
|
|
throw new NotFoundException(__('Invalid Report')); |
237
|
|
|
} |
238
|
|
|
|
239
|
|
|
$state = $this->request->data['state']; |
240
|
|
|
$newState = $this->Reports->status[$state]; |
241
|
|
|
if (!$newState) { |
242
|
|
|
throw new NotFoundException(__('Invalid State')); |
243
|
|
|
} |
244
|
|
|
$report->status = $state; |
245
|
|
|
$this->Reports->save($report); |
246
|
|
|
|
247
|
|
|
$flash_class = "alert alert-success"; |
248
|
|
|
$this->Flash->default("The state has been successfully changed.", |
|
|
|
|
249
|
|
|
array("params" => array("class" => $flash_class))); |
250
|
|
|
$this->redirect("/reports/view/$reportId"); |
251
|
|
|
} |
252
|
|
|
|
253
|
|
|
/** |
254
|
|
|
* To carry out mass actions on Reports |
255
|
|
|
* Currently only to change their statuses. |
256
|
|
|
* Can be Extended for other mass operations as well. |
257
|
|
|
* Expects an array of Report Ids as a POST parameter. |
258
|
|
|
* |
259
|
|
|
*/ |
260
|
1 |
|
public function mass_action() |
261
|
|
|
{ |
262
|
|
|
$flash_class = "alert alert-error"; |
263
|
|
|
$state = $this->request->data['state']; |
264
|
|
|
$newState = $this->Reports->status[$state]; |
265
|
|
|
if (!$newState) { |
266
|
|
|
Log::write( |
267
|
|
|
'error', |
268
|
|
|
'ERRORED: Invalid param "state" in ReportsController::mass_action()', |
269
|
|
|
'alert' |
270
|
|
|
); |
271
|
|
|
$msg = "ERROR: Invalid State!!"; |
272
|
|
|
} else if (count($this->request->data['reports']) == 0) { |
273
|
|
|
$msg = "No Reports Selected!! Please Select Reports and try again."; |
274
|
|
|
} else { |
275
|
|
|
$msg = "Status has been changed to '" |
276
|
|
|
. $this->request->data['state'] |
277
|
|
|
. "' for selected Reports!"; |
278
|
|
|
$flash_class = "alert alert-success"; |
279
|
|
|
foreach($this->request->data['reports'] as $report_id) |
280
|
|
|
{ |
281
|
|
|
$report = $this->Reports->get($report_id); |
282
|
|
|
if (!$report) { |
283
|
|
|
Log::write( |
284
|
|
|
'error', |
285
|
|
|
'ERRORED: Invalid report_id in ReportsController::mass_action()', |
286
|
|
|
'alert' |
287
|
|
|
); |
288
|
|
|
$msg = "ERROR:Invalid Report ID:" . $report_id; |
289
|
|
|
$flash_class = "alert alert-error"; |
290
|
1 |
|
break; |
291
|
|
|
} |
292
|
|
|
$report->status = $state; |
293
|
|
|
$this->Reports->save($report); |
294
|
|
|
} |
295
|
|
|
} |
296
|
|
|
|
297
|
|
|
$this->Flash->default($msg, |
|
|
|
|
298
|
|
|
array("params" => array("class" => $flash_class))); |
299
|
|
|
$this->redirect("/reports/"); |
300
|
|
|
} |
301
|
|
|
|
302
|
|
|
## HELPERS |
303
|
1 |
|
protected function _setSimilarFields($id) { |
304
|
1 |
|
$this->Reports->id = $id; |
305
|
|
|
|
306
|
1 |
|
$this->set('columns', TableRegistry::get('Incidents')->summarizableFields); |
307
|
1 |
|
$relatedEntries = array(); |
308
|
|
|
|
309
|
1 |
|
foreach (TableRegistry::get('Incidents')->summarizableFields as $field) { |
310
|
|
|
list($entriesWithCount, $totalEntries) = |
311
|
1 |
|
$this->Reports->getRelatedByField($field, 25, true); |
312
|
1 |
|
$relatedEntries[$field] = $entriesWithCount; |
313
|
1 |
|
$this->set("${field}_distinct_count", $totalEntries); |
314
|
1 |
|
} |
315
|
|
|
//error_log(json_encode($relatedEntries)); |
316
|
|
|
$this->set("related_entries", $relatedEntries); |
317
|
|
|
} |
318
|
|
|
|
319
|
|
|
protected function _findArrayList($results, $key) { |
320
|
1 |
|
$output = array(); |
321
|
1 |
|
foreach ($results as $row) { |
322
|
1 |
|
$output[] = $row[$key]; |
323
|
1 |
|
} |
324
|
1 |
|
return $output; |
325
|
|
|
} |
326
|
|
|
|
327
|
|
|
protected function _findAllDataTable($results) { |
328
|
1 |
|
$output = array(); |
329
|
1 |
|
foreach ($results as $row) { |
330
|
1 |
|
$output_row = array(); |
331
|
1 |
|
$row = $row->toArray(); |
332
|
1 |
|
foreach ($row as $key => $value) { |
333
|
1 |
|
$output_row[] = $value; |
334
|
1 |
|
} |
335
|
1 |
|
$output[] = $output_row; |
336
|
1 |
|
} |
337
|
1 |
|
return $output; |
338
|
|
|
} |
339
|
|
|
} |
340
|
|
|
|
If you implement
__call
and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class.This is often the case, when
__call
is implemented by a parent class and only the child class knows which methods exist: