1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* Application level Controller. |
5
|
|
|
* |
6
|
|
|
* This file is application-wide controller file. You can put all |
7
|
|
|
* application-wide controller-related methods here. |
8
|
|
|
* |
9
|
|
|
* phpMyAdmin Error reporting server |
10
|
|
|
* Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/) |
11
|
|
|
* |
12
|
|
|
* Licensed under The MIT License |
13
|
|
|
* For full copyright and license information, please see the LICENSE.txt |
14
|
|
|
* Redistributions of files must retain the above copyright notice. |
15
|
|
|
* |
16
|
|
|
* @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/) |
17
|
|
|
* @license https://opensource.org/licenses/mit-license.php MIT License |
18
|
|
|
* |
19
|
|
|
* @see https://www.phpmyadmin.net/ |
20
|
|
|
*/ |
21
|
|
|
|
22
|
|
|
namespace App\Controller; |
23
|
|
|
|
24
|
|
|
use Cake\Controller\Controller; |
25
|
|
|
use Cake\Event\Event; |
26
|
|
|
use Cake\Http\Response; |
27
|
|
|
use Cake\ORM\TableRegistry; |
28
|
|
|
use Cake\Routing\Router; |
29
|
|
|
use function in_array; |
30
|
|
|
|
31
|
|
|
/** |
32
|
|
|
* Application Controller. |
33
|
|
|
* |
34
|
|
|
* Add your application-wide methods in the class below, your controllers |
35
|
|
|
* will inherit them. |
36
|
|
|
* |
37
|
|
|
* @see http://book.cakephp.org/2.0/en/controllers.html#the-app-controller |
38
|
|
|
*/ |
39
|
|
|
class AppController extends Controller |
40
|
|
|
{ |
41
|
|
|
/** @var string[] */ |
42
|
|
|
public $uses = [ |
43
|
|
|
'Developer', |
44
|
|
|
'Notification', |
45
|
|
|
]; |
46
|
|
|
|
47
|
|
|
/** @var array */ |
48
|
|
|
public $whitelist = [ |
49
|
|
|
'Developers', |
50
|
|
|
'Pages', |
51
|
|
|
'Incidents' => ['create'], |
52
|
|
|
'Events', |
53
|
|
|
]; |
54
|
|
|
|
55
|
|
|
/** @var array */ |
56
|
|
|
public $readonly_whitelist = [ |
57
|
|
|
'Developers', |
58
|
|
|
'Pages', |
59
|
|
|
'Reports' => [ |
60
|
|
|
'index', |
61
|
|
|
'view', |
62
|
|
|
'data_tables', |
63
|
|
|
], |
64
|
|
|
'Incidents' => ['view'], |
65
|
|
|
]; |
66
|
|
|
|
67
|
|
|
/** @var string[] */ |
68
|
|
|
public $css_files = [ |
69
|
|
|
'jquery.dataTables', |
70
|
|
|
'jquery.dataTables_themeroller', |
71
|
|
|
'bootstrap.min', |
72
|
|
|
'bootstrap-responsive.min', |
73
|
|
|
'shCore', |
74
|
|
|
'shThemeDefault', |
75
|
|
|
'custom', |
76
|
|
|
]; |
77
|
|
|
|
78
|
|
|
/** @var string[] */ |
79
|
|
|
public $js_files = [ |
80
|
|
|
'jquery', |
81
|
|
|
'jquery.dataTables.min', |
82
|
|
|
'bootstrap', |
83
|
|
|
'shCore', |
84
|
|
|
'shBrushXml', |
85
|
|
|
'shBrushJScript', |
86
|
|
|
'shBrushPhp', |
87
|
|
|
'raphael-min', |
88
|
|
|
'g.raphael-min', |
89
|
|
|
'g.pie-min', |
90
|
|
|
'g.line-min', |
91
|
|
|
'g.bar-min', |
92
|
|
|
'g.dot-min', |
93
|
|
|
'jquery.jqplot.min', |
94
|
|
|
'jqplot.barRenderer.min', |
95
|
|
|
'jqplot.highlighter.min', |
96
|
|
|
'jqplot.dateAxisRenderer.min', |
97
|
|
|
'jqplot.categoryAxisRenderer.min', |
98
|
|
|
'jqplot.pointLabels.min', |
99
|
|
|
'jqplot.canvasTextRenderer.min', |
100
|
|
|
'jqplot.canvasAxisTickRenderer.min', |
101
|
|
|
'jqplot.cursor.min', |
102
|
|
|
'pie', |
103
|
|
|
'custom', |
104
|
|
|
]; |
105
|
|
|
|
106
|
|
|
/** |
107
|
|
|
* Initialization hook method. |
108
|
|
|
* |
109
|
|
|
* Use this method to add common initialization code like loading components. |
110
|
|
|
* |
111
|
|
|
* @return void Nothing |
112
|
|
|
*/ |
113
|
88 |
|
public function initialize(): void |
114
|
|
|
{ |
115
|
88 |
|
parent::initialize(); |
116
|
88 |
|
$this->loadComponent('Flash'); |
117
|
|
|
/* $this->loadComponent( |
118
|
|
|
'Auth', [ |
119
|
|
|
'loginAction' => [ |
120
|
|
|
'controller' => 'Developer', |
121
|
|
|
'action' => 'login' |
122
|
|
|
], |
123
|
|
|
'authError' => 'Did you really think you are allowed to see that?', |
124
|
|
|
'authenticate' => [ |
125
|
|
|
'Form' => [ |
126
|
|
|
'fields' => ['username' => 'email'] |
127
|
|
|
] |
128
|
|
|
] |
129
|
|
|
] |
130
|
|
|
); |
131
|
|
|
*/ |
132
|
88 |
|
} |
133
|
|
|
|
134
|
84 |
|
public function beforeFilter(Event $event): void |
135
|
|
|
{ |
136
|
84 |
|
$controller = $this->request->controller; |
137
|
84 |
|
$this->set('current_controller', $controller); |
138
|
84 |
|
$notif_count = 0; |
139
|
|
|
|
140
|
84 |
|
if ($this->request->getSession()->read('Developer.id')) { |
141
|
72 |
|
$this->checkReadonlyAccess(); |
142
|
|
|
|
143
|
72 |
|
$current_developer = TableRegistry::getTableLocator()->get('Developers')-> |
144
|
72 |
|
findById($this->request->getSession()->read('Developer.id'))->all()->first(); |
145
|
|
|
|
146
|
72 |
|
$notif_count = TableRegistry::getTableLocator()->get('Notifications')->find( |
147
|
72 |
|
'all', |
148
|
|
|
[ |
149
|
72 |
|
'conditions' => ['developer_id' => (int) isset($current_developer) ? $current_developer['id'] : null], |
150
|
|
|
] |
151
|
72 |
|
)->count(); |
152
|
72 |
|
$this->set('current_developer', $current_developer); |
153
|
72 |
|
$this->set('developer_signed_in', true); |
154
|
|
|
|
155
|
72 |
|
$read_only = false; |
156
|
72 |
|
if ($this->request->getSession()->read('read_only')) { |
157
|
|
|
$read_only = true; |
158
|
|
|
} |
159
|
72 |
|
$this->set('read_only', $read_only); |
160
|
|
|
} else { |
161
|
12 |
|
$this->set('developer_signed_in', false); |
162
|
12 |
|
$this->set('read_only', true); |
163
|
12 |
|
$this->checkAccess(); |
164
|
|
|
} |
165
|
84 |
|
$this->set('notif_count', $notif_count); |
166
|
84 |
|
$this->set('js_files', $this->js_files); |
167
|
84 |
|
$this->set('css_files', $this->css_files); |
168
|
84 |
|
$this->set('baseURL', Router::url('/', true)); |
169
|
84 |
|
} |
170
|
|
|
|
171
|
12 |
|
protected function checkAccess(): ?Response |
172
|
|
|
{ |
173
|
12 |
|
$controller = $this->request->controller; |
174
|
12 |
|
$action = $this->request->getParam('action'); |
175
|
|
|
|
176
|
12 |
|
if (in_array($controller, $this->whitelist)) { |
177
|
8 |
|
return null; |
178
|
|
|
} |
179
|
4 |
|
if (isset($this->whitelist[$controller]) |
180
|
4 |
|
&& in_array($action, $this->whitelist[$controller]) |
181
|
|
|
) { |
182
|
|
|
return null; |
183
|
|
|
} |
184
|
4 |
|
$flash_class = 'alert'; |
185
|
4 |
|
$this->Flash->default( |
186
|
4 |
|
'You need to be signed in to do this', |
187
|
4 |
|
['params' => ['class' => $flash_class]] |
188
|
|
|
); |
189
|
|
|
|
190
|
|
|
// save the return url |
191
|
4 |
|
$ret_url = Router::url($this->request->getRequestTarget(), true); |
192
|
4 |
|
$this->request->getSession()->write('last_page', $ret_url); |
193
|
|
|
|
194
|
4 |
|
return $this->redirect('/'); |
195
|
|
|
} |
196
|
|
|
|
197
|
72 |
|
protected function checkReadonlyAccess(): void |
198
|
|
|
{ |
199
|
72 |
|
$controller = $this->request->controller; |
200
|
72 |
|
$action = $this->request->getParam('action'); |
201
|
72 |
|
$read_only = $this->request->getSession()->read('read_only'); |
202
|
|
|
|
203
|
|
|
// If developer has commit access on phpmyadmin/phpmyadmin |
204
|
72 |
|
if (! $read_only) { |
205
|
68 |
|
return; |
206
|
|
|
} |
207
|
|
|
|
208
|
4 |
|
if (in_array($controller, $this->readonly_whitelist)) { |
209
|
|
|
return; |
210
|
|
|
} |
211
|
4 |
|
if (isset($this->readonly_whitelist[$controller]) |
212
|
4 |
|
&& in_array($action, $this->readonly_whitelist[$controller]) |
213
|
|
|
) { |
214
|
|
|
return; |
215
|
|
|
} |
216
|
|
|
|
217
|
4 |
|
$this->request->getSession()->destroy(); |
218
|
4 |
|
$this->request->getSession()->write('last_page', ''); |
219
|
|
|
|
220
|
4 |
|
$flash_class = 'alert'; |
221
|
4 |
|
$this->Flash->default( |
222
|
|
|
'You need to have commit access on phpmyadmin/phpmyadmin ' |
223
|
4 |
|
. 'repository on Github.com to do this', |
224
|
|
|
[ |
225
|
4 |
|
'params' => ['class' => $flash_class], |
226
|
|
|
] |
227
|
|
|
); |
228
|
|
|
|
229
|
4 |
|
$this->redirect('/'); |
230
|
4 |
|
} |
231
|
|
|
} |
232
|
|
|
|