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