1 | <?php |
||
2 | |||
3 | if (Auth::user()->hasGlobalRead()) { |
||
4 | $data['count'] = ['query' => 'SELECT COUNT(*) FROM services']; |
||
5 | $data['up'] = ['query' => "SELECT COUNT(*) FROM services WHERE `service_ignore` = '0' AND `service_disabled` = '0' AND `service_status` = '0'"]; |
||
6 | $data['down'] = ['query' => "SELECT COUNT(*) FROM services WHERE `service_ignore` = '0' AND `service_disabled` = '0' AND `service_status` = '2'"]; |
||
7 | $data['ignored'] = ['query' => "SELECT COUNT(*) FROM services WHERE `service_ignore` = '1' AND `service_disabled` = '0'"]; |
||
8 | $data['disabled'] = ['query' => "SELECT COUNT(*) FROM services WHERE `service_disabled` = '1'"]; |
||
9 | } else { |
||
10 | $device_ids = Permissions::devicesForUser()->toArray() ?: [0]; |
||
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||
11 | $perms_sql = '`S`.`device_id` IN ' . dbGenPlaceholders(count($device_ids)); |
||
12 | |||
13 | $data['count'] = [ |
||
14 | 'query' => 'SELECT COUNT(*) FROM services AS S WHERE $perms_sql', |
||
15 | 'params' => $device_ids, |
||
16 | ]; |
||
17 | |||
18 | $data['up'] = [ |
||
19 | 'query' => "SELECT COUNT(*) FROM services AS S WHERE $perms_sql AND S.`service_ignore` = '0' AND S.`service_disabled` = '0' AND S.`service_status` = '0'", |
||
20 | 'params' => $device_ids, |
||
21 | ]; |
||
22 | |||
23 | $data['down'] = [ |
||
24 | 'query' => "SELECT COUNT(*) FROM services AS S WHERE $perms_sql AND S.`service_ignore` = '0' AND S.`service_disabled` = '0' AND S.`service_status` = '2'", |
||
25 | 'params' => $device_ids, |
||
26 | ]; |
||
27 | |||
28 | $data['ignored'] = [ |
||
29 | 'query' => "SELECT COUNT(*) FROM services AS S WHERE $perms_sql AND S.`service_ignore` = '1' AND S.`service_disabled` = '0'", |
||
30 | 'params' => $device_ids, |
||
31 | ]; |
||
32 | |||
33 | $data['disabled'] = [ |
||
34 | 'query' => "SELECT COUNT(*) FROM services AS S WHERE $perms_sql AND S.`service_disabled` = '1'", |
||
35 | 'params' => $device_ids, |
||
36 | ]; |
||
37 | }//end if |
||
38 |