mactrack_view_interfaces.php

<?php
/*
 +-------------------------------------------------------------------------+
 | Copyright (C) 2004-2026 The Cacti Group                                 |
 |                                                                         |
 | This program is free software; you can redistribute it and/or           |
 | modify it under the terms of the GNU General Public License             |
 | as published by the Free Software Foundation; either version 2          |
 | of the License, or (at your option) any later version.                  |
 |                                                                         |
 | This program is distributed in the hope that it will be useful,         |
 | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
 | GNU General Public License for more details.                            |
 +-------------------------------------------------------------------------+
 | Cacti: The Complete RRDTool-based Graphing Solution                     |
 +-------------------------------------------------------------------------+
 | This code is designed, written, and maintained by the Cacti Group. See  |
 | about.php and/or the AUTHORS file for specific developer information.   |
 +-------------------------------------------------------------------------+
 | http://www.cacti.net/                                                   |
 +-------------------------------------------------------------------------+
*/

$guest_account = true;
chdir('../../');
require('./include/auth.php');
require_once('./plugins/mactrack/lib/mactrack_functions.php');

$title = __('Mactrack - Network Interfaces View', 'mactrack');

// check actions
if (isset_request_var('export')) {
	mactrack_export_records();
} else {
	mactrack_view();
}

/**
 * Builds and executes the prepared SQL query for the interfaces list
 * view, applying the current issues/bandwidth-usage filter, text
 * filter, device/site/device-type request variables, sort order, and
 * optional row limits.
 *
 * @param string &$sql_where   Receives the generated SQL WHERE clause.
 * @param bool   $apply_limits Whether to apply a SQL LIMIT clause
 *                            (default true).
 * @param int    $rows         Number of rows per page, used to compute
 *                            the SQL LIMIT clause when $apply_limits
 *                            is true (default '30').
 * @param array  &$sql_params  Receives the bound parameter values for
 *                            the prepared statement.
 *
 * @return array The matching interface records, joined with their
 *               device and device type details.
 *
 * @global int   $timespan       Reserved/declared for parity with
 *                               other functions in this file; not used
 *                               directly here.
 * @global string $group_function Reserved/declared for parity with
 *                               other functions in this file; not used
 *                               directly here.
 * @global array $summary_stats  Reserved/declared for parity with
 *                               other functions in this file; not used
 *                               directly here.
 */
function mactrack_get_records(&$sql_where, $apply_limits = true, $rows = 30, &$sql_params = []): array {
	global $timespan, $group_function, $summary_stats;

	$issues  = (string) get_request_var('issues');
	$bwusage = intval(get_filter_request_var('bwusage'));
	$ignore  = '';

	if (mactrack_interface_filter_needs_ignore($issues, $bwusage)) {
		$ignore = mactrack_get_ignore_ports_predicate($sql_params);
	}

	// issues sql where
	if ($issues == '-2') { // All Interfaces
		// do nothing all records
	} elseif ($issues == '-3') { // Non Ignored Interfaces
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . $ignore;
	} elseif ($issues == '-4') { // Ignored Interfaces
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' NOT ' . $ignore;
	} elseif ($issues == '-1') { // With Issues
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . "((int_errors_present=1 OR int_discards_present=1) AND $ignore)";
	} elseif ($issues == '0') { // Up Interfaces
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . "(ifOperStatus=1 AND $ignore)";
	} elseif ($issues == '1') { // Up w/o Alias
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . "(ifOperStatus=1 AND ifAlias='' AND $ignore)";
	} elseif ($issues == '2') { // Errors Up
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . "(int_errors_present=1 AND $ignore)";
	} elseif ($issues == '3') { // Discards Up
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . "(int_discards_present=1 AND $ignore)";
	} elseif ($issues == '7') { // Change < 24 Hours
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . '(mac_track_interfaces.sysUptime-ifLastChange < 8640000) AND ifLastChange > 0 AND (mac_track_interfaces.sysUptime-ifLastChange > 0)';
	} elseif ($issues == '9' && $bwusage != -1) { // In/Out over 70%
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . '((inBound>' . $bwusage . ' OR outBound>' . $bwusage . ") AND $ignore)";
	} elseif ($issues == '10' && $bwusage != -1) { // In over 70%
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . '(inBound>' . $bwusage . " AND $ignore)";
	} elseif ($issues == '11' && $bwusage != -1) { // Out over 70%
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . '(outBound>' . $bwusage . " AND $ignore)";
	} else {
	}

	// status legend sql where (multi-select Status filter / Issues pill drill-down)
	// Only honoured on the enhanced view (Cacti 1.2.32+); on older cores the
	// Status control and pills are hidden, so a persisted value must not filter.
	$statuses = mactrack_interfaces_show_issues()
		? mactrack_parse_status_tokens(get_request_var('statuses'))
		: [];

	if (cacti_sizeof($statuses)) {
		$status_clauses = [];

		foreach ($statuses as $status) {
			switch ($status) {
				case 'int_up':
					$status_clauses[] = 'mac_track_interfaces.ifOperStatus = 1';

					break;
				case 'int_down':
					$status_clauses[] = 'mac_track_interfaces.ifOperStatus <> 1';

					break;
				case 'int_up_wo_alias':
					$status_clauses[] = "(mac_track_interfaces.ifOperStatus = 1 AND mac_track_interfaces.ifAlias = '')";

					break;
				case 'int_errors':
					$status_clauses[] = 'mac_track_interfaces.int_errors_present = 1';

					break;
				case 'int_discards':
					$status_clauses[] = 'mac_track_interfaces.int_discards_present = 1';

					break;
				case 'int_no_graph':
					$status_clauses[] = 'NOT EXISTS (SELECT 1 FROM mac_track_interface_graphs AS mtig
						WHERE mtig.host_id = mac_track_devices.host_id
						AND mtig.ifIndex = mac_track_interfaces.ifIndex)';

					break;
			}
		}

		if (cacti_sizeof($status_clauses)) {
			$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . '(' . implode(' OR ', $status_clauses) . ')';
		}
	}

	// filter sql where
	$filter_where = mactrack_create_sql_filter(get_request_var('filter'), ['ifAlias', 'hostname', 'ifName', 'ifDescr']);

	if ($filter_where != '') {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . $filter_where;
	}

	// device_id sql where
	if (get_filter_request_var('device_id') == '-1') {
		// do nothing all states
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . 'mac_track_interfaces.device_id=' . intval(get_filter_request_var('device_id'));
	}

	// site sql where
	if (get_filter_request_var('site_id') == '-1') {
		// do nothing all sites
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . 'mac_track_interfaces.site_id=' . intval(get_filter_request_var('site_id'));
	}

	// type sql where
	if (get_filter_request_var('device_type_id') == '-1') {
		// do nothing all states
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . 'mac_track_devices.device_type_id=' . intval(get_filter_request_var('device_type_id'));
	}

	$sql_order = get_order_string();

	if ($apply_limits) {
		$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ', ' . $rows;
	} else {
		$sql_limit = '';
	}

	$sql_query = "SELECT mac_track_interfaces.*,
		mac_track_device_types.description AS device_type,
		mac_track_devices.device_name,
		mac_track_devices.host_id,
		mac_track_devices.disabled,
		mac_track_devices.last_rundate,
		EXISTS (SELECT 1 FROM mac_track_interface_graphs AS mtig
			WHERE mtig.host_id = mac_track_devices.host_id
			AND mtig.ifIndex = mac_track_interfaces.ifIndex) AS has_graphs
		FROM mac_track_interfaces
		INNER JOIN mac_track_devices
		ON mac_track_interfaces.device_id=mac_track_devices.device_id
		INNER JOIN mac_track_device_types
		ON mac_track_device_types.device_type_id=mac_track_devices.device_type_id
		$sql_where
		$sql_order
		$sql_limit";

	// echo $sql_query;

	return db_fetch_assoc_prepared($sql_query, $sql_params);
}

/**
 * Validates and stores this view's filter request variables (rows,
 * page, filter text, sort column/direction, site id, device id, device
 * type id, issues filter, period, bandwidth usage threshold, totals
 * flag) into the session for the interfaces list view.
 *
 * @return void
 */
function mactrack_interfaces_request_validation(): void {
	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'device_name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			],
		'site_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-1',
			'pageset' => true
			],
		'device_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-1',
			'pageset' => true
			],
		'device_type_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-1',
			'pageset' => true
			],
		'issues' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-2',
			'pageset' => true
			],
		'statuses' => [
			'filter'  => FILTER_VALIDATE_REGEXP,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => ['regexp' => '/^((int_up|int_down|int_up_wo_alias|int_errors|int_discards|int_no_graph)(,(int_up|int_down|int_up_wo_alias|int_errors|int_discards|int_no_graph))*)?$/']]
			],
		'period' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-2',
			'pageset' => true
			],
		'bwusage' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => read_config_option('mt_interface_high'),
			'pageset' => true
			],
		'totals' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'true',
			'options' => ['options' => 'sanitize_search_string']
			],
	];

	validate_store_request_vars($filters, 'sess_mtv_int');
	// ================= input validation =================
}

/**
 * Exports the current filtered interfaces list (with SNMP interface
 * counters and status details, up to 10000 rows) as a downloaded CSV
 * file. Called from this script's main request-dispatch switch when
 * action=export.
 *
 * @return void
 */
function mactrack_export_records(): void {
	mactrack_interfaces_request_validation();

	$sql_where  = '';
	$sql_params = [];

	$stats = mactrack_get_records($sql_where, true, 10000, $sql_params);

	$xport_array = [];

	array_push($xport_array, '"device_name","device_type",' .
		'"sysUptime",' .
		'"ifIndex","ifName",' .
		'"ifAlias","ifDescr",' .
		'"ifType","ifMtu",' .
		'"ifSpeed","ifHighSpeed",' .
		'"ifPhysAddress","ifAdminStatus",' .
		'"ifOperStatus","ifLastChange",' .
		'"ifHCInOctets","ifHCOutOctets",' .
		'"ifInDiscards","ifInErrors",' .
		'"ifInUnknownProtos","ifOutDiscards",' .
		'"ifOutErrors","last_up_time",' .
		'"last_down_time","stateChanges",');

	if (cacti_sizeof($stats)) {
		foreach ($stats as $stat) {
			array_push($xport_array,'"' .
				$stat['device_name'] . '","' . $stat['device_type'] . '","' .
				$stat['sysUptime'] . '","' . $stat['ifIndex'] . '","' .
				$stat['ifName'] . '","' . $stat['ifAlias'] . '","' .
				$stat['ifDescr'] . '","' . $stat['ifType'] . '","' .
				$stat['ifMtu'] . '","' . $stat['ifSpeed'] . '","' .
				$stat['ifHighSpeed'] . '","' . $stat['ifPhysAddress'] . '","' .
				$stat['ifAdminStatus'] . '","' . $stat['ifOperStatus'] . '","' .
				$stat['ifLastChange'] . '","' . $stat['ifHCInOctets'] . '","' .
				$stat['ifHCOutOctets'] . '","' . $stat['ifInDiscards'] . '","' .
				$stat['ifInErrors'] . '","' . $stat['ifInUnknownProtos'] . '","' .
				$stat['ifOutDiscards'] . '","' . $stat['ifOutErrors'] . '","' .
				$stat['last_up_time'] . '","' . $stat['last_down_time'] . '","' .
				$stat['stateChanges'] . '"');
		}
	}

	header('Content-type: application/csv');
	header('Cache-Control: max-age=15');
	header('Content-Disposition: attachment; filename=device_mactrack_xport.csv');

	foreach ($xport_array as $xport_line) {
		print $xport_line . "\n";
	}
}

/**
 * Renders the main interfaces list page: validates/stores this view's
 * filter request variables, displays the interfaces filter form, then
 * displays a filtered, sorted, paginated table of interfaces with a
 * modal response area for scan actions. Called from this script's main
 * request-dispatch switch as the default view.
 *
 * @return void
 *
 * @global string $title         The page title, set for the
 *                               surrounding page chrome.
 * @global array  $mactrack_rows Reserved/declared for parity with
 *                               other functions in this file; not used
 *                               directly here.
 * @global array  $config        Cacti global configuration array.
 */
function mactrack_view(): void {
	global $title, $mactrack_rows, $config;

	mactrack_interfaces_request_validation();

	general_header();

	$sql_where  = '';

	if (get_request_var('rows') == -1) {
		$rows = read_config_option('num_rows_table');
	} elseif (get_request_var('rows') == -2) {
		$rows = 99999999;
	} else {
		$rows = get_request_var('rows');
	}

	$sql_params = [];
	$stats      = mactrack_get_records($sql_where, true, $rows, $sql_params);

	mactrack_tabs();

	html_start_box($title, '100%', '', '3', 'center', '');
	mactrack_filter_table();
	html_end_box();

	$rows_query_string = "SELECT COUNT(*)
		FROM mac_track_interfaces
		INNER JOIN mac_track_devices
		ON mac_track_interfaces.device_id=mac_track_devices.device_id
		INNER JOIN mac_track_device_types
		ON mac_track_device_types.device_type_id=mac_track_devices.device_type_id
		$sql_where";

	$total_rows = db_fetch_cell_prepared($rows_query_string, $sql_params);

	$display_text = mactrack_display_array();

	$columns = cacti_sizeof($display_text);

	$nav = html_nav_bar('mactrack_view_interfaces.php?report=interfaces', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, $columns, __('Interfaces', 'mactrack'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', '', '3', 'left', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));

	$i = 0;

	if (cacti_sizeof($stats)) {
		$show_issues = mactrack_interfaces_show_issues();

		foreach ($stats as $stat) {
			if ($show_issues) {
				// zebra striped rows, status is conveyed by the Issues pills
				$class = (($i % 2) == 1) ? 'odd' : 'even';

				print "<tr id='line_" . $stat['device_id'] . '_' . $stat['ifName'] . "' class='tableRow selectable $class'>";
			} else {
				// find the background color and enclose it
				$class = mactrack_int_row_class($stat);

				if ($class) {
					print "<tr id='line_" . $stat['device_id'] . '_' . $stat['ifName'] . "' class='tableRow selectable $class'>";
				} else {
					$class = (($i % 2) == 1) ? 'odd' : 'even';

					print "<tr id='line_" . $stat['device_id'] . "' class='tableRow selectable $class'>";
				}
			}

			$i++;

			print mactrack_format_interface_row($stat);

			form_end_row();
		}
	} else {
		print '<tr><td colspan="7"><em>' . __('No Mactrack Interfaces Found', 'mactrack') . '</em></td></tr>';
	}

	html_end_box(false);

	if (cacti_sizeof($stats)) {
		print $nav;
	}

	print '<div class="center mactrackLegendFooter">';

	mactrack_legend([
		'int_up'          => __('Up', 'mactrack'),
		'int_up_wo_alias' => __('Unaliased', 'mactrack'),
		'int_errors'      => __('Errors', 'mactrack'),
		'int_discards'    => __('Discards', 'mactrack'),
		'int_no_graph'    => __('Graphless', 'mactrack'),
		'int_down'        => __('Down', 'mactrack'),
	]);

	print '</div>';

	if (cacti_sizeof($stats)) {
		mactrack_display_stats();
	}

	print '<div id="response" title="' . __esc('Interface Scan Results', 'mactrack') . '"></div>';

	bottom_footer();
}

/**
 * Builds the column display-text/sort-order definition array for the
 * interfaces list table, switching between per-second rate columns and
 * running-total columns depending on the current 'totals' filter
 * setting.
 *
 * @return array The column definitions, keyed by column name, each
 *               with 'display', optional 'align', and 'sort' entries.
 */
function mactrack_display_array(): array {
	$display_text = [
		'nosort' => [
			'display' => __('Actions', 'mactrack'),
			'sort'    => 'ASC'
		],
		'hostname' => [
			'display' => __('Hostname', 'mactrack'),
			'sort'    => 'ASC'
		],
		'device_type' => [
			'display' => __('Type', 'mactrack'),
			'sort'    => 'ASC'
		],
		'ifName' => [
			'display' => __('Name', 'mactrack'),
			'sort'    => 'ASC'
		],
		'ifDescr' => [
			'display' => __('Description', 'mactrack'),
			'sort'    => 'ASC'
		],
	];

	if (mactrack_interfaces_show_issues()) {
		$display_text += [
			'issues_nosort' => [
				'display' => __('Issues', 'mactrack'),
				'align'   => 'left',
				'sort'    => ''
			],
		];
	}

	$display_text += [
		'ifAlias' => [
			'display' => __('Alias', 'mactrack'),
			'sort'    => 'ASC'
		],
		'inBound' => [
			'display' => __('InBound %%%', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'outBound' => [
			'display' => __('OutBound %%%', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'int_ifHCInOctets' => [
			'display' => __('In (B/S)', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'int_ifHCOutOctets' => [
			'display' => __('Out (B/S)', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'DESC'
		]
	];

	if (get_request_var('totals') == 'true') {
		$display_text += [
			'ifInErrors' => [
				'display' => __('In Err Total', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'ifInDiscards' => [
				'display' => __('In Disc Total', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'ifInUnknownProtos' => [
				'display' => __('UProto Total', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'ifOutErrors' => [
				'display' => __('Out Err Total', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'ifOutDiscards' => [
				'display' => __('Out Disc Total', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			]
		];
	} else {
		$display_text += [
			'int_ifInErrors' => [
				'display' => __('In Err (E/S)', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'int_ifInDiscards' => [
				'display' => __('In Disc (D/S)', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'int_ifInUnknownProtos' => [
				'display' => __('UProto (UP/S)', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'int_ifOutErrors' => [
				'display' => __('Out Err (OE/S)', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			],
			'int_ifOutDiscards' => [
				'display' => __('Out Disc (OD/S)', 'mactrack'),
				'align'   => 'right',
				'sort'    => 'DESC'
			]
		];
	}

	$display_text += [
		'ifOperStatus' => [
			'display' => __('Status', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'ASC'
		],
		'ifLastChange' => [
			'display' => __('Last Change', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'ASC'
		],
		'last_rundate' => [
			'display' => __('Last Scanned', 'mactrack'),
			'align'   => 'right',
			'sort'    => 'ASC'
		]
	];

	return $display_text;
}

/**
 * Renders the site/device/device-type/issues/bandwidth-usage filter
 * form controls for the interfaces list view.
 *
 * @return void
 *
 * @global array $config        Cacti global configuration array
 *                              (declared but not used directly here).
 * @global array $rows_selector Reserved/declared for parity with other
 *                              functions in this file; not used
 *                              directly here.
 */
function mactrack_filter_table(): void {
	global $config, $rows_selector;

	?>
	<tr class='even'>
		<td>
		<form id='mactrack'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Site', 'mactrack'); ?>
					</td>
					<td>
						<select id='site_id'>
							<option value='-1'<?php if (get_request_var('site_id') == '-1') {?> selected<?php }?>><?php print __('All', 'mactrack'); ?></option>
							<?php
							$sites = db_fetch_assoc('SELECT site_id, site_name FROM mac_track_sites ORDER BY site_name');

	if (cacti_sizeof($sites)) {
		foreach ($sites as $site) {
			print '<option value="' . $site['site_id'] . '"';

			if (get_request_var('site_id') == $site['site_id']) {
				print ' selected';
			} print '>' . html_escape($site['site_name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Filters', 'mactrack'); ?>
					</td>
					<td>
						<select id='issues'>
							<option value='-2'<?php if (get_request_var('issues') == '-2') {?> selected<?php }?>><?php print __('All Interfaces', 'mactrack'); ?></option>
							<option value='-3'<?php if (get_request_var('issues') == '-3') {?> selected<?php }?>><?php print __('All Non-Ignored Interfaces', 'mactrack'); ?></option>
							<option value='-4'<?php if (get_request_var('issues') == '-4') {?> selected<?php }?>><?php print __('All Ignored Interfaces', 'mactrack'); ?></option>
							<?php if (get_request_var('bwusage') != '-1') {?><option value='9'<?php if (get_request_var('issues') == '9' && get_request_var('bwusage') != '-1') {?> selected<?php }?>><?php print __('High In/Out Utilization > %d &#37;', get_request_var('bwusage'), 'mactrack'); ?></option><?php }?>
							<?php if (get_request_var('bwusage') != '-1') {?><option value='10'<?php if (get_request_var('issues') == '10' && get_request_var('bwusage') != '-1') {?> selected<?php }?>><?php print __('High In Utilization > %d &#37;', get_request_var('bwusage'), 'mactrack'); ?></option><?php }?>
							<?php if (get_request_var('bwusage') != '-1') {?><option value='11'<?php if (get_request_var('issues') == '11' && get_request_var('bwusage') != '-1') {?> selected<?php }?>><?php print __('High Out Utilization > %d &#37;', get_request_var('bwusage'), 'mactrack'); ?></option><?php }?>
							<option value='-1'<?php if (get_request_var('issues') == '-1') {?> selected<?php }?>><?php print __('With Issues', 'mactrack'); ?></option>
							<option value='0'<?php if (get_request_var('issues') == '0') {?> selected<?php }?>><?php print __('Up Interfaces', 'mactrack'); ?></option>
							<option value='1'<?php if (get_request_var('issues') == '1') {?> selected<?php }?>><?php print __('Up Interfaces No Alias', 'mactrack'); ?></option>
							<option value='2'<?php if (get_request_var('issues') == '2') {?> selected<?php }?>><?php print __('Errors Accumulating', 'mactrack'); ?></option>
							<option value='3'<?php if (get_request_var('issues') == '3') {?> selected<?php }?>><?php print __('Discards Accumulating', 'mactrack'); ?></option>
							<option value='7'<?php if (get_request_var('issues') == '7') {?> selected<?php }?>><?php print __('Changed in Last Day', 'mactrack'); ?></option>
						</select><BR>
					<td>
						<?php print __('Bandwidth', 'mactrack'); ?>
					</td>
					<td>
						<select id='bwusage'>
							<option value='-1'<?php if (get_request_var('bwusage') == '-1') {?> selected<?php }?>><?php print __('N/A', 'mactrack'); ?></option>
							<?php
	for ($bwpercent = 10; $bwpercent < 100; $bwpercent += 10) {
		?><option value='<?php print $bwpercent; ?>' <?php if (isset_request_var('bwusage') && (get_request_var('bwusage') == $bwpercent)) {?> selected<?php }?>> >=<?php print $bwpercent; ?>%</option><?php
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<button type='submit' id='go' class='ui-button ui-corner-all ui-widget ui-state-active'><?php print __esc('Go', 'mactrack'); ?></button>
							<button type='button' id='clear' class='ui-button ui-corner-all ui-widget'><?php print __esc('Clear', 'mactrack'); ?></button>
							<button type='button' id='export' class='ui-button ui-corner-all ui-widget'><?php print __esc('Export', 'mactrack'); ?></button>
						</span>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Type', 'mactrack'); ?>
					</td>
					<td>
						<select id='device_type_id'>
							<option value='-1'<?php if (get_request_var('device_type_id') == '-1') {?> selected<?php }?>><?php print __('All', 'mactrack'); ?></option>
							<?php
	$sql_where = '';

	if (get_request_var('site_id') != -1) {
		$sql_where .= ' WHERE mac_track_devices.site_id=' . get_filter_request_var('site_id');
	} else {
		$sql_where  = '';
	}

	$types = db_fetch_assoc("SELECT DISTINCT mac_track_device_types.device_type_id,
								mac_track_device_types.description AS device_type
								FROM mac_track_device_types
								INNER JOIN mac_track_devices
								ON mac_track_device_types.device_type_id=mac_track_devices.device_type_id
								$sql_where
								ORDER BY device_type");

	if (cacti_sizeof($types)) {
		foreach ($types as $type) {
			print '<option value="' . $type['device_type_id'] . '"';

			if (get_request_var('device_type_id') == $type['device_type_id']) {
				print ' selected';
			} print '>' . html_escape($type['device_type']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Device', 'mactrack'); ?>
					</td>
					<td>
						<select id='device_id'>
							<option value='-1'<?php if (get_request_var('device_id') == '-1') {?> selected<?php }?>><?php print __('All', 'mactrack'); ?></option>
							<?php
	$sql_where = '';

	if (get_request_var('site_id') != -1) {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . 'site_id=' . get_filter_request_var('site_id');
	}

	if (get_request_var('device_type_id') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . 'device_type_id=' . get_filter_request_var('device_type_id');
	}

	$devices = array_rekey(db_fetch_assoc("SELECT device_id, device_name FROM mac_track_devices $sql_where ORDER BY device_name"), 'device_id', 'device_name');

	if (cacti_sizeof($devices)) {
		foreach ($devices as $device_id => $device_name) {
			print '<option value="' . $device_id . '"';

			if (get_request_var('device_id') == $device_id) {
				print ' selected';
			} print '>' . html_escape($device_name) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Interfaces', 'mactrack'); ?>
					</td>
					<td>
						<select id='rows'>
							<?php
	if (cacti_sizeof($rows_selector)) {
		foreach ($rows_selector as $key => $value) {
			print '<option value="' . $key . '"';

			if (get_request_var('rows') == $key) {
				print 'selected';
			} print '>' . $value . '</option>';
		}
	}
	?>
						</select>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mactrack'); ?>
					</td>
					<td>
						<input type='text' id='filter' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<input type='checkbox' id='totals' <?php print(get_request_var('totals') == 'true' ? 'checked' : ''); ?>>
					</td>
					<td>
						<label for='totals'><?php print __('Show Totals', 'mactrack'); ?></label>
					</td>
					<?php if (mactrack_interfaces_show_issues()) {
						$selected_statuses = mactrack_parse_status_tokens(get_request_var('statuses'));
					?>
					<td>
						<?php print __('Status', 'mactrack'); ?>
					</td>
					<td>
						<select id='statuses' multiple class='select2-multi-count' data-select-all-text='<?php print html_escape(__('All Statuses', 'mactrack')); ?>' data-select-count-text='<?php print html_escape(__('Statuses Selected', 'mactrack')); ?>'>
							<?php
						foreach (mactrack_interface_status_legend() as $status_class => $status_label) {
							print '<option value="' . html_escape($status_class) . '"' . (in_array($status_class, $selected_statuses, true) ? ' selected' : '') . '>' . html_escape($status_label) . '</option>';
						}
							?>
						</select>
					</td>
					<?php } ?>
				</tr>
			</table>
			</form>
			<script type='text/javascript' <?php print plugin_mactrack_csp_nonce(); ?>>

			function applyFilter() {
				strURL  = urlPath+'plugins/mactrack/mactrack_view_interfaces.php?report=interfaces&header=false';
				strURL += '&filter=' + $('#filter').val();
				strURL += '&rows=' + $('#rows').val();
				strURL += '&site_id=' + $('#site_id').val();
				strURL += '&device_id=' + $('#device_id').val();
				strURL += '&issues=' + $('#issues').val();
				strURL += '&bwusage=' + $('#bwusage').val();
				strURL += '&device_type_id=' + $('#device_type_id').val();
				strURL += '&totals=' + $('#totals').is(':checked');

				var mtStatuses = $('#statuses').length ? ($('#statuses').val() || []) : [];
				strURL += '&statuses=' + mtStatuses.join(',');

				loadPageNoHeader(strURL);
			}

			function clearFilter() {
				strURL  = urlPath+'plugins/mactrack/mactrack_view_interfaces.php?header=false&clear=true';
				loadPageNoHeader(strURL);
			}

			function exportRows() {
				strURL  = urlPath+'plugins/mactrack/mactrack_view_interfaces.php?export=true';
				document.location = strURL;
			}

			$(function() {
				$('#site_id, #issues, #bwusage, #device_type_id, #device_id, #rows, #totals').on('change', function() {
					applyFilter();
				});

				$('#mactrack').on('submit', function(event) {
					event.preventDefault();
					applyFilter();
				});

				$('#clear').on('click', function() {
					clearFilter();
				});

				$('#export').on('click', function() {
					exportRows();
				});

				$('.rescan').off('click').on('click', function(event) {
					event.preventDefault();

					var parts = $(this).attr('id').split('_');

					scan_device_interface(parts[1], parts[2]);
				});

				// Issues pill drill-down: toggle the clicked status in the
				// multi-select Status filter, then re-apply the filter.
				$('.mactrackPill').off('click').on('click', function() {
					var status = $(this).attr('data-status');
					var $sel   = $('#statuses');

					if (status === undefined || !$sel.length) {
						return;
					}

					var vals = $sel.val() || [];
					var idx  = $.inArray(status, vals);

					if (idx > -1) {
						vals.splice(idx, 1);
					} else {
						vals.push(status);
					}

					$sel.val(vals).trigger('change');

					applyFilter();
				});
			});

			</script>
		</td>
	</tr><?php
}