if ($port['ifAdminStatus'] == "down") { $status = "<span class='grey'>Disabled</span>"; } else { if ($port['ifAdminStatus'] == "up") { if ($port['ifOperStatus'] == "down" || $port['ifOperStatus'] == "lowerLayerDown") { $status = "<span class='red'>Enabled / Disconnected</span>"; } else { $status = "<span class='green'>Enabled / Connected</span>"; } } } $i = 1; $show_all = 1; echo generate_box_open(); echo '<table class="table table-hover table-striped table-condensed">'; print_port_row($port, array_merge($vars, array('view' => 'details'))); echo '</table>'; echo generate_box_close(); // Start Navbar $link_array = array('page' => 'device', 'device' => $device['device_id'], 'tab' => 'port', 'port' => $port['port_id']); $navbar['options']['graphs']['text'] = 'Graphs'; $navbar['options']['alerts']['text'] = 'Alerts'; $navbar['options']['alertlog']['text'] = 'Alert Log'; if (dbFetchCell("SELECT COUNT(*) FROM `sensors` WHERE `measured_class` = 'port' AND `measured_entity` = ? and `device_id` = ?", array($port['port_id'], $device['device_id']))) { $navbar['options']['sensors']['text'] = 'Sensors'; } $navbar['options']['realtime']['text'] = 'Real time'; // FIXME CONDITIONAL if (dbFetchCell('SELECT COUNT(*) FROM `ip_mac` WHERE `port_id` = ?', array($port['port_id']))) { $navbar['options']['arp']['text'] = 'ARP/NDP Table'; }
} //$where = ' IN ('.implode(',', array_keys($port_cache)).')'; $where = generate_query_values(array_keys($port_cache), 'port_id'); foreach ($ext_tables as $table) { // Here stored port_id! $cache['ports_option'][$table] = dbFetchColumn("SELECT DISTINCT `port_id` FROM `{$table}` WHERE 1 " . $where); } $cache['ports_vlan'] = array(); // Cache port vlans foreach (dbFetchRows('SELECT * FROM `ports_vlans` AS PV LEFT JOIN vlans AS V ON PV.`vlan` = V.`vlan_vlan` AND PV.`device_id` = V.`device_id` WHERE PV.`device_id` = ? ORDER BY PV.`vlan`', array($device['device_id'])) as $entry) { $cache['ports_vlan'][$entry['port_id']][$entry['vlan']] = $entry; } echo generate_box_open(); echo '<table class="' . $table_class . ' table-hover">' . PHP_EOL; $cols = array(array(NULL, 'class="state-marker"'), array(NULL), 'port' => array('Port'), array(NULL), 'traffic' => array('Traffic'), 'speed' => array('Speed'), 'mac' => array('MAC Address'), array(NULL)); echo get_table_header($cols, $vars); echo '<tbody>' . PHP_EOL; foreach ($ports as $port) { if (is_filtered()) { continue; } print_port_row($port, $vars); } echo '</tbody></table>'; echo generate_box_close(); } } register_html_title("Ports"); unset($where, $ext_tables, $cache['ports_option'], $cache['ports_vlan']); // EOF
// Print single VRF echo generate_box_open(); echo '<table class="table table-striped">'; $vrf = dbFetchRow("SELECT * FROM `vrfs` WHERE `mplsVpnVrfRouteDistinguisher` = ? " . $GLOBALS['cache']['where']['devices_permitted'], array($vars['vrf'])); echo '<tr>'; echo '<td style="width: 200px;" class="entity-title"><a href="' . generate_url($link_array, array('vrf' => $vrf['mplsVpnVrfRouteDistinguisher'])) . '">' . $vrf['vrf_name'] . '</a></td>'; echo '<td style="width: 100px;" class="small">' . $vrf['mplsVpnVrfRouteDistinguisher'] . '</td>'; echo '<td style="width: 200px;" class="small">' . $vrf['mplsVpnVrfDescription'] . '</td>'; echo '</table>'; echo generate_box_close(); $vrf_devices = dbFetchRows("SELECT * FROM `vrfs` LEFT JOIN `devices` USING (`device_id`) WHERE `mplsVpnVrfRouteDistinguisher` = ? " . $GLOBALS['cache']['where']['devices_permitted'], array($vrf['mplsVpnVrfRouteDistinguisher'])); foreach ($vrf_devices as $device) { $hostname = $device['hostname']; echo generate_box_open(); echo '<table cellpadding="10" cellspacing="0" class="table table-striped" width="100%">'; print_device_row($device); echo '</table>'; echo generate_box_close(); unset($seperator); echo '<div style="margin: 10px;"><table class="table table-striped">'; $i = 1; foreach (dbFetchRows("SELECT * FROM `ports` WHERE `ifVrf` = ? AND `device_id` = ?" . $GLOBALS['cache']['where']['ports_permitted'], array($device['vrf_id'], $device['device_id'])) as $port) { print_port_row($port); $i++; } $x++; echo '</table></div>'; echo '<div style="height: 10px;"></div>'; } } // EOF