1 | <?php |
||
2 | |||
3 | if (Auth::user()->hasGlobalRead()) { |
||
4 | $data['count'] = ['query' => "SELECT COUNT(*) FROM ports WHERE `deleted` = '0'"]; |
||
5 | |||
6 | $data['up'] = ['query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifOperStatus` = 'up'"]; |
||
7 | |||
8 | $data['down'] = ['query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifOperStatus` <> 'up' AND I.`ifAdminStatus` = 'up'"]; |
||
9 | |||
10 | $data['shutdown'] = ['query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifAdminStatus` = 'down'"]; |
||
11 | |||
12 | $data['errored'] = ['query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND (I.`ifInErrors_delta` > '0' OR I.`ifOutErrors_delta` > '0')"]; |
||
13 | |||
14 | $data['ignored'] = ['query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE I.`deleted` = '0' AND D.`device_id` = I.`device_id` AND (I.`ignore` = '1' OR D.`ignore` = '1')"]; |
||
15 | } else { |
||
16 | $device_ids = Permissions::portsForUser()->toArray() ?: [0]; |
||
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||
17 | $perms_sql = '`I`.`port_id` IN ' . dbGenPlaceholders(count($device_ids)); |
||
18 | |||
19 | $data['count'] = [ |
||
20 | 'query' => "SELECT COUNT(*) FROM ports AS I WHERE $perms_sql AND I.`deleted` = '0'", |
||
21 | 'params' => $device_ids, |
||
22 | ]; |
||
23 | |||
24 | $data['up'] = [ |
||
25 | 'query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE $perms_sql AND I.`deleted` = '0' AND I.`device_id` = D.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifOperStatus` = 'up'", |
||
26 | 'params' => $device_ids, |
||
27 | ]; |
||
28 | |||
29 | $data['down'] = [ |
||
30 | 'query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE $perms_sql AND I.`deleted` = '0' AND I.`device_id` = D.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifOperStatus` <> 'up' AND I.`ifAdminStatus` = 'up'", |
||
31 | 'params' => $device_ids, |
||
32 | ]; |
||
33 | |||
34 | $data['shutdown'] = [ |
||
35 | 'query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE $perms_sql AND I.`deleted` = '0' AND I.`device_id` = D.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND I.`ifAdminStatus` = 'down'", |
||
36 | 'params' => $device_ids, |
||
37 | ]; |
||
38 | |||
39 | $data['errored'] = [ |
||
40 | 'query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE $perms_sql AND I.`deleted` = '0' AND I.`device_id` = D.`device_id` AND I.`ignore` = '0' AND D.`ignore` = '0' AND (I.`ifInErrors_delta` > '0' OR I.`ifOutErrors_delta` > '0')", |
||
41 | 'params' => $device_ids, |
||
42 | ]; |
||
43 | |||
44 | $data['ignored'] = [ |
||
45 | 'query' => "SELECT COUNT(*) FROM ports AS I, devices AS D WHERE $perms_sql AND I.`deleted` = '0' AND I.`device_id` = D.`device_id` AND (I.`ignore` = '1' OR D.`ignore` = '1')", |
||
46 | 'params' => $device_ids, |
||
47 | ]; |
||
48 | }//end if |
||
49 |