394 lines
12 KiB
PHP
394 lines
12 KiB
PHP
<?php
|
|
/**
|
|
* Observium
|
|
*
|
|
* This file is part of Observium.
|
|
*
|
|
* @package observium
|
|
* @subpackage web
|
|
* @copyright (C) Adam Armstrong
|
|
*
|
|
*/
|
|
|
|
register_html_title('Ports');
|
|
|
|
// Set Defaults here
|
|
|
|
if (!isset($vars['format']) || !is_alpha($vars['format']) || !is_file($config['html_dir'] . '/pages/ports/' . $vars['format'] . '.inc.php')) {
|
|
$vars['format'] = 'list';
|
|
}
|
|
|
|
print_debug_vars($vars, 1);
|
|
|
|
$param = [];
|
|
|
|
if (!isset($vars['sort'])) {
|
|
$vars['sort'] = 'device';
|
|
}
|
|
//if (!isset($vars['ignore'])) { $vars['ignore'] = "0"; }
|
|
if (!isset($vars['disabled'])) {
|
|
$vars['disabled'] = "0";
|
|
}
|
|
if (!isset($vars['deleted'])) {
|
|
$vars['deleted'] = "0";
|
|
}
|
|
|
|
$select = "`ports`.`port_id` AS `port_id`, `devices`.`device_id` AS `device_id`";
|
|
|
|
$where_array = build_ports_where_array_ng($vars);
|
|
|
|
/*
|
|
if (!$config['web_show_disabled'] && safe_count($cache['devices']['disabled']) > 0) {
|
|
$where_array[] = generate_query_values($cache['devices']['disabled'], 'ports.device_id', '!=');
|
|
}
|
|
$where .= implode('', $where_array);
|
|
*/
|
|
//r($where_array);
|
|
|
|
$form_items = [];
|
|
|
|
foreach (get_locations() as $entry) {
|
|
if ($entry === '') {
|
|
$entry = OBS_VAR_UNSET;
|
|
}
|
|
$form_items['location'][$entry] = $entry;
|
|
}
|
|
|
|
foreach (get_type_groups('port') as $entry) {
|
|
$form_items['group'][$entry['group_id']] = $entry['group_name'];
|
|
}
|
|
|
|
foreach (['ifType', 'ifSpeed', 'port_descr_type'] as $entry) {
|
|
$query = "SELECT `$entry` FROM `ports`";
|
|
$query .= " LEFT JOIN `devices` USING (`device_id`)";
|
|
|
|
$form_where = [];
|
|
foreach ($where_array as $where_entry) {
|
|
if (!str_contains($where_entry, "`$entry`")) {
|
|
$form_where[] .= $where_entry;
|
|
}
|
|
}
|
|
$form_where[] = "`$entry` != ''";
|
|
|
|
//r($form_where);
|
|
$query .= generate_where_clause($form_where, $cache['where']['ports_permitted']);
|
|
$query .= " GROUP BY `$entry`";
|
|
|
|
$sort_order = $entry === 'ifSpeed' ? 'DESC' : '';
|
|
$query .= generate_query_sort($entry, $sort_order);
|
|
|
|
$form_items[$entry] = [];
|
|
foreach (dbFetchRows($query) as $data) {
|
|
if ($entry === "ifType") {
|
|
$form_items[$entry][$data['ifType']] = rewrite_iftype($data['ifType']) . ' (' . $data['ifType'] . ')';
|
|
} elseif ($entry === "ifSpeed") {
|
|
$form_items[$entry][$data[$entry]] = format_bps($data[$entry]);
|
|
} else {
|
|
$form_items[$entry][$data[$entry]] = nicecase($data[$entry]);
|
|
}
|
|
}
|
|
}
|
|
|
|
if (isset($form_items['ifType'])) {
|
|
asort($form_items['ifType']);
|
|
}
|
|
|
|
$form_items['devices'] = generate_form_values('device'); // Always all devices
|
|
|
|
$form_items['sort'] = [
|
|
'device' => 'Device',
|
|
'port' => 'Port',
|
|
'speed' => 'Speed',
|
|
'traffic' => 'Traffic In+Out',
|
|
'traffic_in' => 'Traffic In',
|
|
'traffic_out' => 'Traffic Out',
|
|
'traffic_perc' => 'Traffic Percentage In+Out',
|
|
'traffic_perc_in' => 'Traffic Percentage In',
|
|
'traffic_perc_out' => 'Traffic Percentage Out',
|
|
'packets' => 'Packets In+Out',
|
|
'packets_in' => 'Packets In',
|
|
'packets_out' => 'Packets Out',
|
|
'errors' => 'Errors',
|
|
'mac' => 'MAC Address',
|
|
'media' => 'Media',
|
|
'descr' => 'Description'
|
|
];
|
|
|
|
$form = [
|
|
'type' => 'rows',
|
|
'space' => '10px',
|
|
//'brand' => NULL,
|
|
//'class' => 'well',
|
|
'submit_by_key' => TRUE,
|
|
'url' => generate_url($vars)
|
|
];
|
|
|
|
// First row
|
|
$form['row'][0]['device_id'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Device',
|
|
'value' => $vars['device_id'],
|
|
'width' => '100%', //'180px',
|
|
'values' => $form_items['devices']
|
|
];
|
|
|
|
foreach (get_locations() as $entry) {
|
|
if ($entry === '') {
|
|
$entry = OBS_VAR_UNSET;
|
|
}
|
|
$form_items['location'][$entry] = $entry;
|
|
}
|
|
|
|
$form['row'][0]['location'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Device Location',
|
|
'width' => '100%', //'180px',
|
|
//'encode' => TRUE,
|
|
'value' => $vars['location'],
|
|
'values' => $form_items['location']
|
|
];
|
|
|
|
$form['row'][0]['mac'] = [
|
|
'type' => 'text',
|
|
'name' => 'Port Mac Address',
|
|
'value' => $vars['mac'],
|
|
'width' => '100%', //'180px',
|
|
'placeholder' => TRUE
|
|
];
|
|
|
|
$form['row'][0]['state'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Port State',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['state'],
|
|
'values' => [ 'up' => 'Up', 'down' => ' Down', 'admindown' => 'Shutdown']
|
|
];
|
|
|
|
$form['row'][0]['ifType'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Port Media',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['ifType'],
|
|
'values' => $form_items['ifType']
|
|
];
|
|
|
|
$form['row'][0]['group'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Select Groups',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['group'],
|
|
'values' => $form_items['group']
|
|
];
|
|
|
|
$form['row'][1]['hostname'] = [
|
|
'type' => 'text',
|
|
'name' => 'Device Hostname',
|
|
'value' => $vars['hostname'],
|
|
'width' => '100%', //'180px',
|
|
'placeholder' => TRUE
|
|
];
|
|
|
|
$form['row'][1]['label'] = [
|
|
'type' => 'text',
|
|
'name' => 'Port Name',
|
|
'value' => $vars['label'],
|
|
'width' => '100%', //'180px',
|
|
'placeholder' => TRUE
|
|
];
|
|
|
|
$form['row'][1]['ifAlias'] = [
|
|
'type' => 'text',
|
|
'name' => 'Port Description (ifAlias)',
|
|
'value' => $vars['ifAlias'],
|
|
'width' => '100%', //'180px',
|
|
'placeholder' => TRUE
|
|
];
|
|
|
|
$form['row'][1]['ifSpeed'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Port Speed',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['ifSpeed'],
|
|
'values' => $form_items['ifSpeed']
|
|
];
|
|
|
|
$form['row'][1]['port_descr_type'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Port Parsed Type',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['port_descr_type'],
|
|
'values' => $form_items['port_descr_type']
|
|
];
|
|
|
|
// Select sort pull-right
|
|
$form['row'][1]['sort'] = [
|
|
'type' => 'select',
|
|
'icon' => $config['icon']['sort'],
|
|
'grid' => 1,
|
|
//'right' => TRUE,
|
|
'width' => '100%', //'150px',
|
|
'value' => $vars['sort'],
|
|
'values' => $form_items['sort']
|
|
];
|
|
|
|
$form['row'][1]['search'] = [
|
|
'type' => 'submit',
|
|
'grid' => 1,
|
|
//'name' => 'Search',
|
|
//'icon' => 'icon-search',
|
|
'right' => TRUE,
|
|
];
|
|
|
|
$panel_form = [
|
|
'type' => 'rows',
|
|
'title' => 'Search Ports',
|
|
'space' => '10px',
|
|
//'brand' => NULL,
|
|
//'class' => '',
|
|
'submit_by_key' => TRUE,
|
|
'url' => generate_url($vars)
|
|
];
|
|
|
|
$panel_form['row'][0]['device_id'] = $form['row'][0]['device_id'];
|
|
$panel_form['row'][0]['hostname'] = $form['row'][1]['hostname'];
|
|
//$panel_form['row'][0]['location'] = $form['row'][0]['location'];
|
|
|
|
$panel_form['row'][1]['label'] = $form['row'][1]['label'];
|
|
$panel_form['row'][1]['ifAlias'] = $form['row'][1]['ifAlias'];
|
|
$panel_form['row'][1]['mac'] = $form['row'][0]['mac'];
|
|
|
|
$panel_form['row'][2]['state'] = $form['row'][0]['state'];
|
|
$panel_form['row'][2]['ifSpeed'] = $form['row'][1]['ifSpeed'];
|
|
|
|
$panel_form['row'][3]['ifType'] = $form['row'][0]['ifType'];
|
|
$panel_form['row'][3]['port_descr_type'] = $form['row'][1]['port_descr_type'];
|
|
|
|
$panel_form['row'][4]['group'] = $form['row'][0]['group'];
|
|
$panel_form['row'][4]['group']['grid'] = 4;
|
|
$panel_form['row'][4]['location'] = $form['row'][0]['location'];
|
|
$panel_form['row'][4]['location']['grid'] = 4;
|
|
|
|
$panel_form['row'][4]['sort'] = $form['row'][1]['sort'];
|
|
$panel_form['row'][4]['sort']['grid'] = 2;
|
|
$panel_form['row'][4]['search'] = $form['row'][1]['search'];
|
|
$panel_form['row'][4]['search']['grid'] = 2;
|
|
|
|
// Register custom panel
|
|
register_html_panel(generate_form($panel_form));
|
|
|
|
if ($vars['searchbar'] !== "hide") {
|
|
echo '<div class="hidden-xl">';
|
|
print_form($form);
|
|
echo '</div>';
|
|
}
|
|
unset($form, $panel_form, $form_items);
|
|
|
|
$navbar = ['brand' => "Ports", 'class' => "navbar-narrow"];
|
|
|
|
$navbar['options']['basic']['text'] = 'Basic';
|
|
// There is no detailed view for this yet.
|
|
//$navbar['options']['detail']['text'] = 'Details';
|
|
|
|
$navbar['options']['graphs'] = ['text' => 'Graphs'];
|
|
|
|
foreach ($navbar['options'] as $option => $array) {
|
|
if ($vars['format'] === 'list' && !isset($vars['view'])) {
|
|
$vars['view'] = 'basic';
|
|
}
|
|
if ($vars['format'] === 'list' && $vars['view'] == $option) {
|
|
$navbar['options'][$option]['class'] .= " active";
|
|
}
|
|
$navbar['options'][$option]['url'] = generate_url(['page' => 'ports', 'format' => 'list', 'view' => $option]);
|
|
}
|
|
|
|
foreach (['graphs'] as $type) {
|
|
foreach ($config['graph_types']['port'] as $option => $data) {
|
|
if ($vars['view'] == $type && $vars['graph'] == $option) {
|
|
$navbar['options'][$type]['suboptions'][$option]['class'] = 'active';
|
|
$navbar['options'][$type]['text'] .= " (" . $data['name'] . ')';
|
|
}
|
|
$navbar['options'][$type]['suboptions'][$option]['text'] = $data['name'];
|
|
$navbar['options'][$type]['suboptions'][$option]['url'] = generate_url($vars, ['view' => $type, 'graph' => $option]);
|
|
}
|
|
}
|
|
|
|
if (is_array($config['entities']['port']['agg_graphs'])) {
|
|
$navbar['options']['agg_graphs'] = ['text' => 'Aggregate Graphs'];
|
|
foreach ($config['entities']['port']['agg_graphs'] as $option => $data) {
|
|
if ($vars['agg_graph'] == $option) {
|
|
$navbar['options']['agg_graphs']['class'] = 'active';
|
|
$navbar['options']['agg_graphs']['suboptions'][$option]['class'] = 'active';
|
|
$navbar['options']['agg_graphs']['text'] .= " (" . $data['name'] . ')';
|
|
}
|
|
$navbar['options']['agg_graphs']['suboptions'][$option]['text'] = $data['name'];
|
|
$navbar['options']['agg_graphs']['suboptions'][$option]['url'] = generate_url($vars, ['agg_graph' => $option]);
|
|
}
|
|
}
|
|
|
|
|
|
if ($vars['searchbar'] === "hide") {
|
|
$navbar['options_right']['searchbar'] = ['text' => 'Show Search', 'url' => generate_url($vars, ['searchbar' => NULL])];
|
|
} else {
|
|
$navbar['options_right']['searchbar'] = ['text' => 'Hide Search', 'url' => generate_url($vars, ['searchbar' => 'hide'])];
|
|
}
|
|
|
|
if (get_var_true($vars['bare'])) {
|
|
$navbar['options_right']['header'] = ['text' => 'Show Header', 'url' => generate_url($vars, ['bare' => NULL])];
|
|
} else {
|
|
$navbar['options_right']['header'] = ['text' => 'Hide Header', 'url' => generate_url($vars, ['bare' => 'yes'])];
|
|
}
|
|
|
|
$navbar['options_right']['reset'] = ['text' => 'Reset', 'url' => generate_url(['page' => 'ports', 'section' => $vars['section']])];
|
|
|
|
print_navbar($navbar);
|
|
unset($navbar);
|
|
|
|
/* not required array, because permissions array already in select query
|
|
include($config['html_dir'] . '/includes/port-sort-select.inc.php');
|
|
|
|
$sql = "SELECT " . $select;
|
|
$sql .= " FROM `ports`";
|
|
$sql .= " INNER JOIN `devices` USING (`device_id`)";
|
|
$sql .= generate_where_clause($where_array);
|
|
|
|
//r($sql);
|
|
|
|
$ports = dbFetchRows($sql, $param);
|
|
port_permitted_array($ports);
|
|
$ports_count = count($ports);
|
|
|
|
$port_ids = array_value_recursive('port_id', $ports);
|
|
*/
|
|
|
|
$sql = "SELECT `port_id`";
|
|
$sql .= " FROM `ports`";
|
|
$sql .= " INNER JOIN `devices` USING (`device_id`)";
|
|
$sql .= generate_where_clause($where_array, $cache['where']['ports_permitted']);
|
|
|
|
$ports_ids = dbFetchColumn($sql, $param);
|
|
$ports_count = safe_count($ports_ids);
|
|
//r($port_ids);
|
|
if ($vars['agg_graph']) {
|
|
|
|
$graph_vars = [
|
|
'type' => 'multi-port_' . $vars['agg_graph'],
|
|
'legend' => 'no',
|
|
'id' => implode(',', $ports_ids)
|
|
];
|
|
|
|
if ($ports_count < 350) {
|
|
print generate_box_open();
|
|
print_graph_row($graph_vars);
|
|
print generate_box_close();
|
|
} else {
|
|
print_error("Search matches too many ports. Aggregate graphs are limited to 349 ports.");
|
|
}
|
|
}
|
|
|
|
$row = 1; // FIXME. not know for what..
|
|
|
|
//include($config['html_dir'] . '/includes/port-sort.inc.php');
|
|
include($config['html_dir'] . '/pages/ports/' . $vars['format'] . '.inc.php');
|
|
|
|
// EOF
|