function generate_device_popup_header($device, $vars = array()) { global $config; humanize_device($device); if ($device['os'] == "ios") { formatCiscoHardware($device, TRUE); } // FIXME or generic function for more than just IOS? [and/or do this at poll time] $contents = ' <table class="table table-striped table-bordered table-rounded table-condensed"> <tr class="' . $device['html_row_class'] . '" style="font-size: 10pt;"> <td class="state-marker"></td> <td width="40" style="padding: 10px; text-align: center; vertical-align: middle;">' . get_device_icon($device) . '</td> <td width="200"><a href="#" class="' . $class . '" style="font-size: 15px; font-weight: bold;">' . escape_html($device['hostname']) . '</a><br />' . escape_html(truncate($device['location'], 64, '')) . '</td> <td>' . escape_html($device['hardware']) . ' <br /> ' . $device['os_text'] . ' ' . escape_html($device['version']) . '</td> <td>' . deviceUptime($device, 'short') . '<br />' . escape_html($device['sysName']) . ' </tr> </table> '; return $contents; }
// Is there a POST/GET query string? if (isset($_REQUEST['queryString'])) { $queryString = mres($_REQUEST['queryString']); // Is the string length greater than 0? if (strlen($queryString) > 0) { $found = 0; /// SEARCH DEVICES $query_permitted_device = generate_query_permitted(array('device'), array('device_table' => 'devices')); $results = dbFetchRows("SELECT * FROM `devices`\n WHERE (`hostname` LIKE '%{$queryString}%' OR `location` LIKE '%{$queryString}%') {$query_permitted_device}\n ORDER BY `hostname` LIMIT 8"); if (count($results)) { $found = 1; echo '<li class="nav-header">Devices found: ' . count($results) . '</li>' . PHP_EOL; foreach ($results as $result) { echo '<li class="divider" style="margin: 0px;"></li>' . PHP_EOL; echo '<li style="margin: 0px;">' . PHP_EOL . ' <a href="' . generate_device_url($result) . '">' . PHP_EOL; humanize_device($result); $name = $result['hostname']; if (strlen($name) > 35) { $name = substr($name, 0, 35) . "..."; } $num_ports = dbFetchCell("SELECT COUNT(*) FROM `ports` WHERE device_id = ?", array($result['device_id'])); echo ' <dl style="border-left: 10px solid ' . $result['html_tab_colour'] . '; " class="dl-horizontal dl-search"> <dt style="padding-left: 10px; text-align: center;">' . getImage($result) . '</dt> <dd> <strong>' . highlight_search(htmlentities($name)) . ' <small>' . htmlentities($result['hardware']) . ' | ' . htmlentities($config['os'][$result['os']]['text']) . ' ' . htmlentities($result['version']) . ' <br /> ' . highlight_search(htmlentities($result['location'], 0, 'UTF-8')) . ' | ' . $num_ports . ' ports</small> </strong> </dd> </dl> </a>
<?php humanize_device($device); /// These should be summed at poller time $port_count = dbFetchCell("SELECT COUNT(*) FROM `ports` WHERE `device_id` = ?", array($device['device_id'])); $sensor_count = dbFetchCell("SELECT COUNT(*) FROM `sensors` WHERE `device_id` = ?", array($device['device_id'])); echo ' <tr class="' . $device['html_row_class'] . '" onclick="location.href=\'device/device=' . $device['device_id'] . '/\'" style="cursor: pointer;"> <td style="width: 1px; background-color: ' . $device['html_tab_colour'] . '; margin: 0px; padding: 0px"></td> <td width="40" style="padding: 10px; text-align: center; vertical-align: middle;">' . $device['icon'] . '</td> <td width="300" ><span class="entity-title">' . generate_device_link($device) . '</span> <br />' . truncate($device['location'], 32, '') . '</td>'; echo '<td>'; if (isset($config['os'][$device['os']]['over'])) { $graphs = $config['os'][$device['os']]['over']; } elseif (isset($device['os_group']) && isset($config['os'][$device['os_group']]['over'])) { $graphs = $config['os'][$device['os_group']]['over']; } else { $graphs = $config['os']['default']['over']; } $graph_array = array(); $graph_array['height'] = "100"; $graph_array['width'] = "310"; $graph_array['to'] = $config['time']['now']; $graph_array['device'] = $device['device_id']; $graph_array['type'] = "device_bits"; $graph_array['from'] = $config['time']['day']; $graph_array['legend'] = "no"; $graph_array['height'] = "45"; $graph_array['width'] = "175"; $graph_array['bg'] = "FFFFFF00"; foreach ($graphs as $entry) {
function device_by_id_cache($device_id, $refresh = '0') { global $cache; if (!$refresh && isset($cache['devices']['id'][$device_id]) && is_array($cache['devices']['id'][$device_id])) { $device = $cache['devices']['id'][$device_id]; } else { $device = dbFetchRow("SELECT * FROM `devices` WHERE `device_id` = ?", array($device_id)); humanize_device($device); $cache['devices']['id'][$device_id] = $device; } return $device; }
function generate_device_link_header($device, $vars = array()) { global $config; if (isset($device['humanized_device']) == FALSE) { humanize_device($device); } if ($device['os'] == "ios") { formatCiscoHardware($device, true); } # print_r($device); $contents = ' <table class="table table-striped table-bordered table-rounded table-condensed"> <tr class="' . $device['html_row_class'] . '" style="font-size: 10pt;"> <td style="width: 10px; background-color: ' . $device['html_tab_colour'] . '; margin: 0px; padding: 0px"></td> <td width="40" style="padding: 10px; text-align: center; vertical-align: middle;">' . getImage($device) . '</td> <td width="200"><a href="#" class="' . $class . '" style="font-size: 15px; font-weight: bold;">' . $device['hostname'] . '</a><br />' . truncate($device['location'], 64, '') . '</td> <td>' . $device['hardware'] . ' <br /> ' . $device['os_text'] . ' ' . $device['version'] . '</td> <td>' . deviceUptime($device, 'short') . '<br />' . $device['sysName'] . ' </tr> </table> '; return $contents; }
function print_device_hostbox($device, $mode = 'basic') { global $config; if (!is_array($device)) { print_error("Invalid device passed to print_device_hostbox()!"); } if ($device['os'] == "ios") { formatCiscoHardware($device, TRUE); } humanize_device($device); $hostbox_tags = array('html_row_class' => $device['html_row_class'], 'device_id' => $device['device_id'], 'device_link' => generate_device_link($device), 'hardware' => escape_html($device['hardware']), 'features' => escape_html($device['features']), 'os_text' => $device['os_text'], 'version' => escape_html($device['version']), 'sysName' => escape_html($device['sysName']), 'device_uptime' => deviceUptime($device, 'short'), 'location' => escape_html(truncate($device['location'], 32, ''))); switch ($mode) { case 'detail': case 'details': $hostbox_tags['device_image'] = get_device_icon($device); $hostbox_tags['ports_count'] = dbFetchCell("SELECT COUNT(*) FROM `ports` WHERE `device_id` = ?;", array($device['device_id'])); $hostbox_tags['sensors_count'] = dbFetchCell("SELECT COUNT(*) FROM `sensors` WHERE `device_id` = ?;", array($device['device_id'])); $hostbox = ' <tr class="' . $hostbox_tags['html_row_class'] . '" onclick="location.href=\'device/device=' . $hostbox_tags['device_id'] . '/\'" style="cursor: pointer;"> <td class="state-marker"></td> <td style="width: 64px; text-align: center; vertical-align: middle;">' . $hostbox_tags['device_image'] . '</td> <td style="width: 300px;"><span class="entity-title">' . $hostbox_tags['device_link'] . '</span><br />' . $hostbox_tags['location'] . '</td> <td style="width: 55px;">'; if ($hostbox_tags['ports_count']) { $hostbox .= '<i class="oicon-network-ethernet"></i> ' . $hostbox_tags['ports_count']; } $hostbox .= '<br />'; if ($hostbox_tags['sensors_count']) { $hostbox .= '<i class="oicon-dashboard"></i> ' . $hostbox_tags['sensors_count']; } $hostbox .= '</td> <td>' . $hostbox_tags['hardware'] . '<br />' . $hostbox_tags['features'] . '</td> <td>' . $hostbox_tags['os_text'] . '<br />' . $hostbox_tags['version'] . '</td> <td>' . $hostbox_tags['device_uptime'] . '<br />' . $hostbox_tags['sysName'] . '</td> </tr>'; break; case 'status': $hostbox_tags['device_image'] = get_device_icon($device); // Graphs $graph_array = array(); $graph_array['height'] = "100"; $graph_array['width'] = "310"; $graph_array['to'] = $config['time']['now']; $graph_array['device'] = $device['device_id']; $graph_array['type'] = "device_bits"; $graph_array['from'] = $config['time']['day']; $graph_array['legend'] = "no"; $graph_array['height'] = "45"; $graph_array['width'] = "175"; $graph_array['bg'] = "FFFFFF00"; if (isset($config['os'][$device['os']]['over'])) { $graphs = $config['os'][$device['os']]['over']; } else { if (isset($device['os_group']) && isset($config['os'][$device['os_group']]['over'])) { $graphs = $config['os'][$device['os_group']]['over']; } else { $graphs = $config['os']['default']['over']; } } // Preprocess device graphs array foreach ($GLOBALS['device_graphs'][$device['device_id']] as $graph) { $graphs_enabled[] = $graph['graph']; } foreach ($graphs as $entry) { if ($entry['graph'] && in_array(str_replace('device_', '', $entry['graph']), $graphs_enabled)) { $graph_array['type'] = $entry['graph']; $graph_array['popup_title'] = $entry['text']; $hostbox_tags['graphs'][] = generate_graph_popup($graph_array); } } $hostbox = ' <tr class="' . $hostbox_tags['html_row_class'] . '" onclick="location.href=\'device/device=' . $hostbox_tags['device_id'] . '/\'" style="cursor: pointer;"> <td class="state-marker"></td> <td style="width: 64px; text-align: center; vertical-align: middle;">' . $hostbox_tags['device_image'] . '</td> <td style="width: 300px;"><span class="entity-title">' . $hostbox_tags['device_link'] . '</span><br />' . $hostbox_tags['location'] . '</td> <td>'; if ($hostbox_tags['graphs']) { $hostbox .= '<div class="pull-right" style="height: 50px; padding: 2px; margin: 0;">' . implode($hostbox_tags['graphs']) . '</div>'; } $hostbox .= '</td> </tr>'; break; default: // basic $hostbox = ' <tr class="' . $hostbox_tags['html_row_class'] . '" onclick="location.href=\'device/device=' . $hostbox_tags['device_id'] . '/\'" style="cursor: pointer;"> <td style="width: 300;"><span class="entity-title">' . $hostbox_tags['device_link'] . '</span><br />' . $hostbox_tags['location'] . '</td> <td>' . $hostbox_tags['hardware'] . ' ' . $hostbox_tags['features'] . '</td> <td>' . $hostbox_tags['os_text'] . ' ' . $hostbox_tags['version'] . '</td> <td>' . $hostbox_tags['device_uptime'] . '</td> </tr>'; } echo $hostbox; }
function device_by_id_cache($device_id, $refresh = '0') { global $cache; if (!$refresh && isset($cache['devices']['id'][$device_id]) && is_array($cache['devices']['id'][$device_id])) { $device = $cache['devices']['id'][$device_id]; } else { $device = dbFetchRow("SELECT * FROM `devices` WHERE `device_id` = ?", array($device_id)); } if (!empty($device)) { humanize_device($device); if ($refresh || !isset($device['graphs'])) { // Fetch device graphs $device['graphs'] = dbFetchRows("SELECT * FROM `device_graphs` WHERE `device_id` = ?", array($device_id)); } $cache['devices']['id'][$device_id] = $device; return $device; } else { return FALSE; } }