1<?php
2/*
3 * LibreNMS
4 *
5 * Copyright (c) 2015 Søren Friis Rosiak <sorenrosiak@gmail.com>
6 * Copyright (c) 2016 Jens Langhammer <jens@beryju.org>
7 * Copyright (c) 2016 Cercel Valentin <crc@nuamchefazi.ro>
8 * This program is free software: you can redistribute it and/or modify it
9 * under the terms of the GNU General Public License as published by the
10 * Free Software Foundation, either version 3 of the License, or (at your
11 * option) any later version.  Please see LICENSE.txt at the top level of
12 * the source code distribution for details.
13 */
14
15use LibreNMS\Alert\AlertUtil;
16use LibreNMS\Config;
17
18$mode = Session::get('map_view', 0);
19if (isset($settings['mode_select']) && $settings['mode_select'] !== '') {
20    $mode = $settings['mode_select'];
21}
22
23$select_modes = [
24    '0' => 'only devices',
25    '1' => 'only services',
26    '2' => 'devices and services',
27];
28
29if (Config::get('webui.availability_map_compact') == 1) {
30    $compact_tile = $settings['tile_size'];
31}
32
33$show_disabled_ignored = $settings['show_disabled_and_ignored'];
34
35if (defined('SHOW_SETTINGS')) {
36    $common_output[] = '
37    <form class="form" onsubmit="widget_settings(this); return false;">
38        ' . csrf_field() . '
39        <div class="form-group">
40            <div class="col-sm-4">
41                <label for="title" class="control-label availability-map-widget-header">Widget title</label>
42            </div>
43            <div class="col-sm-6">
44                <input type="text" class="form-control" name="title" placeholder="Custom title for widget" value="' . htmlspecialchars($settings['title']) . '">
45            </div>
46        </div>';
47
48    if (Config::get('webui.availability_map_compact') === false) {
49        $common_output[] = '
50    <div class="form-group">
51        <div class="col-sm-4">
52            <label for="color_only_select" class="control-label availability-map-widget-header">Uniform Tiles</label>
53        </div>
54        <div class="col-sm-6">
55            <select class="form-control" name="color_only_select">
56                <option value="1"' . ($settings['color_only_select'] == 1 ? ' selected' : '') . ' >yes</option>
57                <option value="0"' . ($settings['color_only_select'] == 1 ? '' : ' selected') . ' >no</option>
58            </select>
59        </div>
60    </div>
61';
62    }
63
64    if (Config::get('webui.availability_map_compact') == 1) {
65        $common_output[] = '
66        <div class="form-group">
67            <div class="col-sm-4">
68                <label for="tile_size" class="control-label availability-map-widget-header">Tile size</label>
69            </div>
70            <div class="col-sm-6">
71                <input type="text" class="form-control" name="tile_size" value="' . $compact_tile . '">
72            </div>
73        </div>';
74    }
75
76    if ($show_disabled_ignored == 1) {
77        $selected_yes = 'selected';
78        $selected_no = '';
79    } else {
80        $selected_yes = '';
81        $selected_no = 'selected';
82    }
83
84    $common_output[] = '
85    <div class="form-group">
86        <div class="col-sm-4">
87            <label for="show_disabled_and_ignored" class="control-label availability-map-widget-header">Disabled polling/alerting</label>
88        </div>
89        <div class="col-sm-6">
90            <select class="form-control" name="show_disabled_and_ignored">
91                <option value="1" ' . $selected_yes . '>yes</option>
92                <option value="0" ' . $selected_no . '>no</option>
93            </select>
94        </div>
95    </div>';
96
97    $common_output[] = '
98    <div class ="form-group">
99        <div class="col-sm-4">
100            <label for="mode_select" class="control-lable availability-map-widget-header">Mode</label>
101        </div>
102        <div class="col-sm-6">
103            <select name="mode_select" class="form-control">';
104
105    if (Config::get('show_services') == 0) {
106        $common_output[] = '<option value="0" selected>only devices</option>';
107    } else {
108        foreach ($select_modes as $mode_select => $option) {
109            if ($mode_select == $settings['mode_select']) {
110                $selected = 'selected';
111            } else {
112                $selected = '';
113            }
114            $common_output[] = '<option value="' . $mode_select . '" ' . $selected . '>' . $option . '</option>';
115        }
116    }
117    $common_output[] = '
118            </select>
119        </div>
120    </div>';
121
122    if (Config::get('webui.availability_map_compact') == 1) {
123        $common_outputp[] = '
124        <div class="form-group">
125            <div class="col-sm-4">
126                <label for="tile_size" class="control-label availability-map-widget-header">Tile width</label>
127            </div>
128            <div class="col-sm-6">
129                <input class="form-control" type="text" onkeypress="return (event.charCode == 8 || event.charCode == 0) ? null : event.charCode >= 48 && event.charCode <= 57" name="tile_size" placeholder="Tile side in px" value="' . $compact_tile . '">
130            </div>
131        </div>
132        ';
133    }
134
135    $common_output[] = '
136        <br style="clear:both;">
137        <div class="form-group">
138            <div class="col-sm-2">
139                <button type="submit" class="btn btn-default">Set</button>
140            </div>
141        </div>
142    </form>';
143} else {
144    require_once 'includes/html/object-cache.inc.php';
145
146    $host_up_count = 0;
147    $host_warn_count = 0;
148    $host_down_count = 0;
149    $host_maintenance_count = 0;
150    $host_disable_notify_count = 0;
151    $host_disabled_count = 0;
152    $service_up_count = 0;
153    $service_warn_count = 0;
154    $service_down_count = 0;
155    $service_ignored_count = 0;
156    $service_disabled_count = 0;
157
158    if (Config::get('webui.availability_map_sort_status') == 1) {
159        $deviceOrderBy = 'status';
160        $serviceOrderBy = '`S`.`service_status` DESC';
161    } else {
162        $deviceOrderBy = 'hostname';
163        $serviceOrderBy = '`D`.`hostname`';
164    }
165
166    if ($mode == 0 || $mode == 2) {
167        // Only show devices if mode is 0 or 2 (Only Devices or both)
168        if (Config::get('webui.availability_map_use_device_groups') != 0) {
169            $device_group = 'SELECT `D`.`device_id` FROM `device_group_device` AS `D` WHERE `device_group_id` = ?';
170            $in_devices = dbFetchColumn($device_group, [Session::get('group_view')]);
171        }
172
173        $sql = 'SELECT `D`.`hostname`, `D`.`sysName`, `D`.`device_id`, `D`.`status`, `D`.`uptime`, `D`.`last_polled`, `D`.`os`, `D`.`icon`, `D`.`disable_notify`, `D`.`disabled` FROM `devices` AS `D`';
174
175        if (! Auth::user()->hasGlobalRead()) {
176            $sql .= ' , `devices_perms` AS P WHERE D.`device_id` = P.`device_id` AND P.`user_id` = ? AND ';
177            $param = [Auth::id()];
178        } else {
179            $sql .= ' WHERE ';
180            $param = [];
181        }
182
183        if ($show_disabled_ignored != 1) {
184            $sql .= '`D`.`disable_notify` = 0 AND `D`.`disabled` = 0 ';
185        } else {
186            $sql .= '(`D`.`status` IN (0,1,2) OR `D`.`disable_notify` = 1 OR `D`.`disabled` = 1)';
187        }
188
189        if (Config::get('webui.availability_map_use_device_groups') != 0 && ! empty($in_devices)) {
190            $sql .= ' AND `D`.`device_id` IN ' . dbGenPlaceholders(count($in_devices));
191            $param = array_merge($param, $in_devices);
192        }
193
194        $sql .= ' ORDER BY `' . $deviceOrderBy . '`';
195
196        $temp_output = [];
197
198        foreach (dbFetchRows($sql, $param) as $device) {
199            $updowntime = '';
200            if ($device['disabled'] == '1') {
201                $deviceState = 'disabled';
202                $deviceLabel = 'blackbg';
203                $host_disabled_count++;
204            } elseif ($device['disable_notify'] == '1') {
205                $deviceState = 'alert-disabled';
206                $deviceLabel = 'label-default';
207                $host_disable_notify_count++;
208            } elseif ($device['status'] == '1') {
209                if (($device['uptime'] < Config::get('uptime_warning')) && ($device['uptime'] != 0)) {
210                    $deviceState = 'warn';
211                    $deviceLabel = 'label-warning';
212                    $deviceLabelOld = 'availability-map-oldview-box-warn';
213                    $host_warn_count++;
214                } else {
215                    $deviceState = 'up';
216                    $deviceLabel = 'label-success';
217                    $deviceLabelOld = 'availability-map-oldview-box-up';
218                    $host_up_count++;
219                }
220                $updowntime = ($device['uptime'] ? ' - ' : '') . \LibreNMS\Util\Time::formatInterval($device['uptime']);
221            } else {
222                $deviceState = 'down';
223                $deviceLabel = 'label-danger';
224                $deviceLabelOld = 'availability-map-oldview-box-down';
225                $host_down_count++;
226                $updowntime = ($device['last_polled'] ? ' - ' . \LibreNMS\Util\Time::formatInterval(time() - strtotime($device['last_polled'])) : '');
227            }
228
229            if (AlertUtil::isMaintenance($device['device_id'])) {
230                $deviceLabel = 'label-default';
231                $host_maintenance_count++;
232            }
233
234            $device_system_name = format_hostname($device);
235
236            if (Config::get('webui.availability_map_compact') == 0) {
237                if ($directpage == 'yes') {
238                    $deviceIcon = getIconTag($device);
239                    $temp_output[] = '
240                    <a href="' . \LibreNMS\Util\Url::deviceUrl((int) $device['device_id']) . '" title="' . $device_system_name . $updowntime . '">
241                    <div class="device-availability ' . $deviceState . '" style="width:' . Config::get('webui.availability_map_box_size') . 'px;">
242                        <span class="availability-label label ' . $deviceLabel . ' label-font-border">' . $deviceState . '</span>
243                        <span class="device-icon">' . $deviceIcon . '</span><br>
244                        <span class="small">' . shorthost($device_system_name) . '</span>
245                    </div>
246                    </a>';
247                } else {
248                    if ($settings['color_only_select'] == 1) {
249                        $deviceState = ' ';
250                        $deviceLabel .= ' widget-availability-fixed';
251                    }
252                    $temp_output[] = '
253                    <a href="' . \LibreNMS\Util\Url::deviceUrl((int) $device['device_id']) . '" title="' . $device_system_name . $updowntime . '">
254                        <span class="label ' . $deviceLabel . ' widget-availability label-font-border">' . $deviceState . '</span>
255                    </a>';
256                }
257            } else {
258                $temp_output[] = "<a href='" . \LibreNMS\Util\Url::deviceUrl((int) $device['device_id']) . "' title='" . $device_system_name . $updowntime . "'><div class='" . $deviceLabelOld . "' style='width:${compact_tile}px;height:${compact_tile}px;'></div></a>";
259            }
260        }
261    }
262
263    if (($mode == 1 || $mode == 2) && (Config::get('show_services') != 0)) {
264        if (Auth::user()->hasGlobalRead()) {
265            $service_query = 'select `S`.`service_type`, `S`.`service_id`, `S`.`service_desc`, `S`.`service_status`, `D`.`hostname`, `D`.`sysName`, `D`.`device_id`, `D`.`os`, `D`.`icon` from services S, devices D where `S`.`device_id` = `D`.`device_id` ORDER BY ' . $serviceOrderBy . ';';
266            $service_par = [];
267        } else {
268            $service_query = 'select `S`.`service_type`, `S`.`service_id`, `S`.`service_desc`, `S`.`service_status`, `D`.`hostname`, `D`.`sysName`, `D`.`device_id`, `D`.`os`, `D`.`icon` from services S, devices D, devices_perms P where `S`.`device_id` = `D`.`device_id` AND D.device_id = P.device_id AND P.user_id = ? ORDER BY ' . $serviceOrderBy . ';';
269            $service_par = [Auth::id()];
270        }
271        $services = dbFetchRows($service_query, $service_par);
272        if (count($services) > 0) {
273            foreach ($services as $service) {
274                if ($service['service_status'] == '0') {
275                    $serviceLabel = 'label-success';
276                    $serviceLabelOld = 'availability-map-oldview-box-up';
277                    $serviceState = 'up';
278                    $service_up_count++;
279                } elseif ($service['service_status'] == '1') {
280                    $serviceLabel = 'label-warning';
281                    $serviceLabelOld = 'availability-map-oldview-box-warn';
282                    $serviceState = 'warn';
283                    $service_warn_count++;
284                } else {
285                    $serviceLabel = 'label-danger';
286                    $serviceLabelOld = 'availability-map-oldview-box-down';
287                    $serviceState = 'down';
288                    $service_down_count++;
289                }
290                $service_system_name = format_hostname($service);
291
292                if (Config::get('webui.availability_map_compact') == 0) {
293                    if ($directpage == 'yes') {
294                        $deviceIcon = getIconTag($service);
295                        $temp_output[] = '
296                        <a href="' . \LibreNMS\Util\Url::generate(['page' => 'device', 'device' => $service['device_id'], 'tab' => 'services']) . '" title="' . $service_system_name . ' - ' . $service['service_type'] . ' - ' . $service['service_desc'] . '">
297                            <div class="service-availability ' . $serviceState . '" style="width:' . Config::get('webui.availability_map_box_size') . 'px;">
298                                <span class="service-name-label label ' . $serviceLabel . ' label-font-border">' . $service['service_type'] . '</span>
299                                <span class="availability-label label ' . $serviceLabel . ' label-font-border">' . $serviceState . '</span>
300                                <span class="device-icon">' . $deviceIcon . '</span><br>
301                                <span class="small">' . shorthost($service_system_name) . '</span>
302                            </div>
303                        </a>';
304                    } else {
305                        $serviceText = $service['service_type'] . ' - ' . $serviceState;
306                        if ($settings['color_only_select'] == 1) {
307                            $serviceText = ' ';
308                            $serviceLabel .= ' widget-availability-fixed';
309                        }
310                        $temp_output[] = '
311                        <a href="' . \LibreNMS\Util\Url::generate(['page' => 'device', 'device' => $service['device_id'], 'tab' => 'services']) . '" title="' . shorthost($service_system_name) . ' - ' . $service['service_type'] . ' - ' . $service['service_desc'] . '">
312                            <span class="label ' . $serviceLabel . ' widget-availability label-font-border">' . $serviceText . '</span>
313                        </a>';
314                    }
315                } else {
316                    $temp_output[] = "<a href='" . \LibreNMS\Util\Url::generate(['page' => 'device', 'device' => $service['device_id'], 'tab' => 'services']) . "' title='${service_system_name} - ${service['service_type']} - ${service['service_desc']}'><div class='" . $serviceLabelOld . "' style='width:${compact_tile}px;height:${compact_tile}px;'></div></a>";
317                }
318            }
319        } else {
320            $temp_output[] = '';
321        }
322    }
323
324    if ($directpage == 'yes') {
325        $temp_header[] = '
326        <div class="page-availability-title-left">
327            <span class="page-availability-title">Availability map for</span>
328            <select id="mode" class="page-availability-report-select" name="mode">';
329
330        if (Config::get('show_services') == 0) {
331            $temp_header[] = '<option value="0" selected>only devices</option>';
332        } else {
333            foreach ($select_modes as $mode_select => $option) {
334                if ($mode_select == $mode) {
335                    $selected = 'selected';
336                } else {
337                    $selected = '';
338                }
339                $temp_header[] = '<option value="' . $mode_select . '" ' . $selected . '>' . $option . '</option>';
340            }
341        }
342
343        $temp_header[] =
344            '</select>
345        </div>
346        <div class="page-availability-title-right">';
347
348        if ((Config::get('webui.availability_map_use_device_groups') != 0) && ($mode == 0 || $mode == 2)) {
349            $sql = 'SELECT `G`.`id`, `G`.`name` FROM `device_groups` AS `G`';
350            $dev_groups = dbFetchRows($sql);
351
352            if (Session::get('group_view') == 0) {
353                $selected = 'selected';
354            } else {
355                $selected = '';
356            }
357
358            $temp_header[] = '
359            <span class="page-availability-title">Device group</span>
360            <select id="group" class="page-availability-report-select" name="group">
361                <option value="0" ' . $selected . '>show all devices</option>';
362
363            foreach ($dev_groups as $dev_group) {
364                if (Session::get('group_view') == $dev_group['id']) {
365                    $selected = 'selected';
366                } else {
367                    $selected = '';
368                }
369                $temp_header[] = '<option value="' . $dev_group['id'] . '" ' . $selected . '>' . $dev_group['name'] . '</option>';
370            }
371            $temp_header[] = '</select>';
372        }
373    }
374
375    if ($directpage == 'yes') {
376        $deviceClass = 'page-availability-report-host';
377        $serviceClass = 'page-availability-report-host';
378    } else {
379        $deviceClass = 'widget-availability-host';
380        $serviceClass = 'widget-availability-service';
381    }
382
383    if ($show_disabled_ignored == 1) {
384        $disabled_ignored_header = '
385            <span class="label label-default label-font-border label-border">alert-disabled: ' . $host_disable_notify_count . '</span>
386            <span class="label blackbg label-font-border label-border">disabled: ' . $host_disabled_count . '</span>';
387    }
388
389    if ($mode == 0 || $mode == 2) {
390        $temp_header[] = '
391            <div class="' . $deviceClass . '">
392                <span>Total hosts</span>
393                <span class="label label-success label-font-border label-border">up: ' . $host_up_count . '</span>
394                <span class="label label-warning label-font-border label-border">warn: ' . $host_warn_count . '</span>
395                <span class="label label-danger label-font-border label-border">down: ' . $host_down_count . '</span>';
396        if ($host_maintenance_count) {
397            $temp_header[] = '<span class="label label-default label-font-border label-border">maintenance: ' . $host_maintenance_count . '</span>';
398        }
399        $temp_header[] = $disabled_ignored_header . '
400            </div>';
401    }
402
403    if (($mode == 1 || $mode == 2) && (Config::get('show_services') != 0)) {
404        $temp_header[] = '
405            <div class="' . $serviceClass . '">
406                <span>Total services</span>
407                <span class="label label-success label-font-border label-border">up: ' . $service_up_count . '</span>
408                <span class="label label-warning label-font-border label-border">warn: ' . $service_warn_count . '</span>
409                <span class="label label-danger label-font-border label-border">down: ' . $service_down_count . '</span>
410            </div>';
411    }
412
413    $temp_header[] = '</div>';
414    $temp_header[] = '<br style="clear:both;">';
415
416    $common_output = array_merge($temp_header, $temp_output);
417}
418