mikrotik.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/                                                   |
 +-------------------------------------------------------------------------+
*/

chdir('../../');
include('./include/auth.php');

set_default_action('devices');

if (isset_request_var('action') && get_request_var('action') == 'ajax_hosts') {
	get_allowed_ajax_hosts();
	exit;
}

if (strpos(get_request_var('action'), 'export') === false) {
	general_header();
	mikrotik_tabs();
}

$mikrotik_hrDeviceStatus = [
	0 => __('Present', 'mikrotik'),
	1 => __('Unknown', 'mikrotik'),
	2 => __('Running', 'mikrotik'),
	3 => __('Warning', 'mikrotik'),
	4 => __('Testing', 'mikrotik'),
	5 => __('Down', 'mikrotik')
];

switch(get_request_var('action')) {
	case 'devices':
		mikrotik_devices();

		break;
	case 'trees':
		mikrotik_trees();

		break;
	case 'queues':
		mikrotik_queues();

		break;
	case 'interfaces':
		mikrotik_interfaces();

		break;
	case 'dhcp':
		mikrotik_dhcp();

		break;
	case 'dns':
		mikrotik_dns(false);

		break;
	case 'dnsexport':
		mikrotik_dns(true);

		break;
	case 'list':
		mikrotik_list(false);

		break;
	case 'listexport':
		mikrotik_list(true);

		break;
	case 'wireless_aps':
		mikrotik_wireless_aps();

		break;
	case 'wireless_regs':
		mikrotik_wireless_regs();

		break;
	case 'users':
		mikrotik_users();

		break;
	case 'graphs':
		mikrotik_view_graphs();

		break;
}

if (strpos(get_request_var('action'), 'export') === false) {
	bottom_footer();
}

/**
 * Converts a dotted-decimal subnet mask (e.g. '255.255.255.0') into its
 * CIDR prefix length. Called when rendering source/destination subnet
 * information in the queues view.
 *
 * @param string $mask The dotted-decimal subnet mask to convert.
 *
 * @return int|string The CIDR prefix length, or '0' if $mask is empty.
 */
function mikrotik_get_network(?string $mask): int|string {
	if (empty($mask)) {
		return '0';
	}

	$octets = explode('.', $mask);
	$output = '';

	if (cacti_sizeof($octets)) {
		foreach ($octets as $octet) {
			$output .= decbin((int) $octet);
		}

		return strlen(trim($output, '0'));
	}

	return '0';
}

/**
 * Reports whether any MikroTik user records have been collected.
 * Called from mikrotik_tabs() to decide whether to show the Users tab.
 *
 * @return int The number of rows in plugin_mikrotik_users.
 */
function mikrotik_users_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_users');
}

/**
 * Reports whether any MikroTik simple queue records have been
 * collected. Called from mikrotik_tabs() to decide whether to show the
 * Queues tab.
 *
 * @return int The number of rows in plugin_mikrotik_queues.
 */
function mikrotik_queues_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_queues');
}

/**
 * Reports whether any MikroTik queue tree records have been collected.
 * Called from mikrotik_tabs() to decide whether to show the Trees tab.
 *
 * @return int The number of rows in plugin_mikrotik_trees.
 */
function mikrotik_queue_trees_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_trees');
}

/**
 * Reports whether any MikroTik interface records have been collected.
 * Called from mikrotik_tabs() to decide whether to show the Interfaces
 * tab.
 *
 * @return int The number of rows in plugin_mikrotik_interfaces.
 */
function mikrotik_interfaces_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_interfaces');
}

/**
 * Reports whether any MikroTik firewall address-list records have been
 * collected. Called from mikrotik_tabs() to decide whether to show the
 * Lists tab.
 *
 * @return int The number of rows in plugin_mikrotik_lists.
 */
function mikrotik_lists_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_lists');
}

/**
 * Reports whether any MikroTik DNS cache records have been collected.
 * Called from mikrotik_tabs() to decide whether to show the DNS tab.
 *
 * @return int The number of rows in plugin_mikrotik_dns.
 */
function mikrotik_dns_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_dns');
}

/**
 * Reports whether any MikroTik DHCP lease records have been collected.
 * Called from mikrotik_tabs() to decide whether to show the DHCP tab.
 *
 * @return int The number of rows in plugin_mikrotik_dhcp.
 */
function mikrotik_dhcp_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_dhcp');
}

/**
 * Reports whether any MikroTik wireless access-point records have been
 * collected. Called from mikrotik_tabs() to decide whether to show the
 * Wireless APs tab.
 *
 * @return int The number of rows in plugin_mikrotik_wireless_aps.
 */
function mikrotik_wireless_aps_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_wireless_aps');
}

/**
 * Reports whether any MikroTik wireless client registration records
 * have been collected. Called from mikrotik_tabs() to decide whether
 * to show the Wireless Registrations tab.
 *
 * @return int The number of rows in
 *             plugin_mikrotik_wireless_registrations.
 */
function mikrotik_wregs_exist(): int {
	return db_fetch_cell('SELECT COUNT(*) FROM plugin_mikrotik_wireless_registrations');
}

/**
 * Renders the top tabbed navigation bar for this page's views,
 * conditionally showing tabs only for data types that have actually
 * been collected (users/queues/trees/interfaces/dhcp/dns/lists/
 * wireless), highlighting whichever tab corresponds to the current
 * action. Called from this script's main flow at the top of every
 * rendered view.
 *
 * @return void
 *
 * @global array $config Cacti global configuration array; used to
 *                       build each tab's URL.
 */
function mikrotik_tabs(): void {
	global $config;

	// present a tabbed interface
	$tabs['devices'] = __('Devices', 'mikrotik');

	if (mikrotik_users_exist()) {
		$tabs['users'] = __('Users', 'mikrotik');
	}

	if (mikrotik_queues_exist()) {
		$tabs['queues'] = __('Queues', 'mikrotik');
	}

	if (mikrotik_queue_trees_exist()) {
		$tabs['trees'] = __('Queue Trees', 'mikrotik');
	}

	if (mikrotik_interfaces_exist()) {
		$tabs['interfaces'] = __('Interfaces', 'mikrotik');
	}

	if (mikrotik_dhcp_exist()) {
		$tabs['dhcp'] = __('DHCP', 'mikrotik');
	}

	if (mikrotik_dns_exist()) {
		$tabs['dns'] = __('DNS Cache', 'mikrotik');
	}

	if (mikrotik_lists_exist()) {
		$tabs['list'] = __('Address Lists', 'mikrotik');
	}

	if (mikrotik_wireless_aps_exist()) {
		$tabs['wireless_aps'] = __('Wireless Aps', 'mikrotik');
	}

	if (mikrotik_wregs_exist()) {
		$tabs['wireless_regs'] = __('Wireless Registrations', 'mikrotik');
	}

	$tabs['graphs'] = __('Graphs', 'mikrotik');

	// set the default tab
	$current_tab = get_request_var('action');

	print "<div class='tabs'><nav><ul>\n";

	if (cacti_sizeof($tabs)) {
		foreach (array_keys($tabs) as $tab_short_name) {
			print "<li><a class='pic" . (($tab_short_name == $current_tab) ? ' selected' : '') . "' href='" . $config['url_path'] .
				'plugins/mikrotik/mikrotik.php?' .
				'action=' . $tab_short_name .
				(isset_request_var('host_id') ? '&host_id=' . get_filter_request_var('host_id') : '') .
				"'>" . $tabs[$tab_short_name] . "</a></li>\n";
		}
	}
	print "</ul></nav></div>\n";
}

/**
 * Renders the Interfaces view: validates/stores this view's filter
 * request variables, renders the filter box, then queries and displays
 * a sortable/paginated table of collected MikroTik interfaces matching
 * the selected filters, each with a link to its interface graphs.
 * Called from this script's main request-dispatch switch when
 * action=interfaces.
 *
 * @return void
 *
 * @global array $config           Cacti global configuration array;
 *                                used to build device edit links.
 * @global array $item_rows        Cacti's standard row-count option
 *                                list, used to populate the rows
 *                                dropdown.
 * @global array $interface_hashes The list of interface graph template
 *                                hashes, used to build each interface's
 *                                'view graphs' link.
 */
function mikrotik_interfaces(): void {
	global $config, $item_rows, $interface_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'active' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => 'true',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sincereset' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=interfaces';
		strURL += '&filter='     + $('#filter').val();
		strURL += '&rows='       + $('#rows').val();
		strURL += '&active='     + $('#active').is(':checked');
		strURL += '&sincereset=' + $('#sincereset').is(':checked');
		strURL += '&device='     + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=interfaces&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change.mikrotikFilter').on('change.mikrotikFilter', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_interfaces').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('Interface Stats', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_interfaces' action='mikrotik.php?action=interfaces'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Interfaces', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='active' type='checkbox' <?php print(get_request_var('active') == 'true' ? 'checked' : ''); ?>>
							<label for='active'><?php print __('Active', 'mikrotik'); ?></label>
						</span>
					<td>
						<span>
							<input id='sincereset' type='checkbox' <?php print(get_request_var('sincereset') == 'true' ? 'checked' : ''); ?>>
							<label for='sincereset'><?php print __('Since Reset', 'mikrotik'); ?></label>
						</span>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = "WHERE mti.name!=''";

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mti.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sort_column = get_request_var('sort_column');

	if (get_request_var('sincereset') == 'true') {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (RxBytes>0 or TxBytes>0)';
		}

		$pref = '';

		if (strpos($sort_column, 'cur') !== false) {
			$sort_column = str_replace('cur', '', $sort_column);
		}
	} else {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (curRxBytes>0 or curTxBytes>0)';
		}

		$pref = 'cur';

		if (strpos($sort_column, 'cur') === false) {
			switch($sort_column) {
				case 'description':
				case 'name':
				case 'last_seen':
				case 'RxErrors':
				case 'RxErrors':
					break;
				default:
					$sort_column = $pref . $sort_column;
			}
		}
	}

	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ', ' . $rows;

	$sql = "SELECT mti.*, h.hostname, h.description, h.disabled,
		(${pref}RxTooShort+${pref}RxTooLong+${pref}RxFCFSError+${pref}RxAlignError+${pref}RxFragment+${pref}RxOverflow+${pref}RxUnknownOp+${pref}RxLengthError+${pref}RxCodeError+${pref}RxCarrierError+${pref}RxJabber+${pref}RxDrop) AS RxErrors,
		(${pref}TxTooShort+${pref}TxTooLong+${pref}TxUnderrun+${pref}TxCollision+${pref}TxExCollision+${pref}TxMultCollision+${pref}TxSingCollision+${pref}TxLateCollision+${pref}TxDrop+${pref}TxJabber+${pref}TxFCFSError) AS TxErrors
		FROM plugin_mikrotik_interfaces AS mti
		INNER JOIN host AS h
		ON h.id=mti.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_interfaces AS mti
		INNER JOIN host AS h
		ON h.id=mti.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'nosort'            => ['display' => __('Actions', 'mikrotik'),    'sort' => '',     'align' => 'left'],
		'description'       => ['display' => __('Hostname', 'mikrotik'),   'sort' => 'ASC',  'align' => 'left'],
		'name'              => ['display' => __('Name', 'mikrotik'),       'sort' => 'DESC', 'align' => 'left'],
		$pref . 'RxBytes'   => ['display' => __('Rx Bytes', 'mikrotik'),   'sort' => 'DESC', 'align' => 'right'],
		$pref . 'TxBytes'   => ['display' => __('Tx Bytes', 'mikrotik'),   'sort' => 'DESC', 'align' => 'right'],
		$pref . 'RxPackets' => ['display' => __('Rx Packets', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		$pref . 'TxPackets' => ['display' => __('Tx Packets', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'RxErrors'          => ['display' => __('Rx Errors', 'mikrotik'),  'sort' => 'DESC', 'align' => 'right'],
		'TxErrors'          => ['display' => __('Tx Errors', 'mikrotik'),  'sort' => 'DESC', 'align' => 'right'],
		'last_seen'         => ['display' => __('Last Seen', 'mikrotik'),  'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=interfaces', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, cacti_sizeof($display_text), __('Interfaces', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, $sort_column, get_request_var('sort_direction'), 1, 'mikrotik.php?action=interfaces');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($interface_hashes, $row['host_id'], $row['name']);

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url    = $row['description'];
			}

			print "<td class='nowrap'>$graphs</td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . filter_value($row['name'], get_request_var('filter')) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'RxBytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'TxBytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'RxPackets']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'TxPackets']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['RxErrors']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['TxErrors']) . '</td>';
			print "<td class='right'>" . filter_value($row['last_seen'], get_request_var('filter')) . '</td>';

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

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the Queues view: validates/stores this view's filter request
 * variables, renders the filter box, then queries and displays a
 * sortable/paginated table of collected MikroTik simple queues
 * matching the selected filters, each with a link to its queue graphs.
 * Called from this script's main request-dispatch switch when
 * action=queues.
 *
 * @return void
 *
 * @global array $config       Cacti global configuration array; used
 *                             to build device edit links.
 * @global array $item_rows    Cacti's standard row-count option list,
 *                             used to populate the rows dropdown.
 * @global array $queue_hashes The list of queue graph template hashes,
 *                             used to build each queue's 'view graphs'
 *                             link.
 */
function mikrotik_queues(): void {
	global $config, $item_rows, $queue_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'active' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => 'true',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sincereset' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=queues';
		strURL += '&filter='     + $('#filter').val();
		strURL += '&active='     + $('#active').is(':checked');
		strURL += '&sincereset=' + $('#sincereset').is(':checked');
		strURL += '&rows='       + $('#rows').val();
		strURL += '&device='     + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=queues&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_queues').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('Queue Status', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_queues' action='mikrotik.php?action=queues'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Queues', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='active' type='checkbox' <?php print(get_request_var('active') == 'true' ? 'checked' : ''); ?>>
							<label for='active'><?php print __('Active', 'mikrotik'); ?></label>
						</span>
					</td>
					<td>
						<span>
							<input id='sincereset' type='checkbox' <?php print(get_request_var('sincereset') == 'true' ? 'checked' : ''); ?>>
							<label for='sincereset'><?php print __('Since Reset', 'mikrotik'); ?></label>
						</span>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = "WHERE mtq.name!=''";

	$sort_column = get_request_var('sort_column');

	if (get_request_var('sincereset') == 'true') {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (BytesIn>0 or BytesOut>0)';
		}

		$pref = '';

		if (strpos($sort_column, 'cur') !== false) {
			$sort_column = str_replace('cur', '', $sort_column);
		}
	} else {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (curBytesIn>0 or curBytesOut>0)';
		}

		$pref = 'cur';

		if (strpos($sort_column, 'cur') === false) {
			switch($sort_column) {
				case 'description':
				case 'name':
				case 'last_seen':
				case 'srcAddr':
				case 'dstAddr':
					break;
				default:
					$sort_column = $pref . $sort_column;
			}
		}
	}

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mtq.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ', ' . $rows;

	$sql = "SELECT mtq.*, h.hostname, h.description, h.disabled
		FROM plugin_mikrotik_queues AS mtq
		INNER JOIN host AS h
		ON h.id=mtq.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_queues AS mtq
		INNER JOIN host AS h
		ON h.id=mtq.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'nosort'             => ['display' => __('Actions', 'mikrotik'),       'sort' => '',     'align' => 'left'],
		'description'        => ['display' => __('Hostname', 'mikrotik'),      'sort' => 'ASC',  'align' => 'left'],
		'name'               => ['display' => __('Name', 'mikrotik'),          'sort' => 'DESC', 'align' => 'left'],
		'srcAddr'            => ['display' => __('Src Addr/Mask', 'mikrotik'), 'sort' => 'DESC', 'align' => 'left'],
		'dstAddr'            => ['display' => __('Dst Addr/Mask', 'mikrotik'), 'sort' => 'DESC', 'align' => 'left'],
		$pref . 'BytesIn'    => ['display' => __('Bytes In', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		$pref . 'BytesOut'   => ['display' => __('Bytes Out', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		$pref . 'PacketsIn'  => ['display' => __('Pkts In', 'mikrotik'),        'sort' => 'DESC', 'align' => 'right'],
		$pref . 'PacketsOut' => ['display' => __('Pkts Out', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		$pref . 'QueuesIn'   => ['display' => __('Qs In', 'mikrotik'),          'sort' => 'DESC', 'align' => 'right'],
		$pref . 'QueuesOut'  => ['display' => __('Qs Out', 'mikrotik'),         'sort' => 'DESC', 'align' => 'right'],
		$pref . 'DroppedIn'  => ['display' => __('Drps In', 'mikrotik'),        'sort' => 'DESC', 'align' => 'right'],
		$pref . 'DroppedOut' => ['display' => __('Drps Out', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'last_seen'          => ['display' => __('Last Seen', 'mikrotik'),     'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=queues', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, cacti_sizeof($display_text), __('Queues', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, $sort_column, get_request_var('sort_direction'), 1, 'mikrotik.php?action=queues');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($queue_hashes, $row['host_id'], str_replace(' ', '%', $row['name']));

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url    = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url    = $row['description'];
			}
			$srcNet = mikrotik_get_network($row['srcMask']);
			$dstNet = mikrotik_get_network($row['dstMask']);
			$srcAM  = $row['srcAddr'] . ($srcNet != 32 ? '/' . $srcNet : '');
			$dstAM  = $row['dstAddr'] . ($dstNet != 32 ? '/' . $dstNet : '');

			print "<td class='nowrap'>$graphs</td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . filter_value($row['name'], get_request_var('filter')) . '</td>';
			print "<td class='left'>" . filter_value($srcAM, get_request_var('filter')) . '</td>';
			print "<td class='left'>" . filter_value($dstAM, get_request_var('filter')) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'BytesIn']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'BytesOut']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'PacketsIn']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'PacketsOut']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'QueuesIn']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'QueuesOut']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'DroppedIn']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'DroppedOut']) . '</td>';
			print "<td class='right'>" . filter_value($row['last_seen'], get_request_var('filter')) . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>' . __('No Simple Queues Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the Queue Trees view: validates/stores this view's filter
 * request variables, renders the filter box, then queries and displays
 * a sortable/paginated table of collected MikroTik queue trees matching
 * the selected filters, each with a link to its tree graphs. Called
 * from this script's main request-dispatch switch when action=trees.
 *
 * @return void
 *
 * @global array $config      Cacti global configuration array; used to
 *                            build device edit links.
 * @global array $item_rows   Cacti's standard row-count option list,
 *                            used to populate the rows dropdown.
 * @global array $tree_hashes The list of tree graph template hashes,
 *                            used to build each tree's 'view graphs'
 *                            link.
 */
function mikrotik_trees(): void {
	global $config, $item_rows, $tree_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=trees';
		strURL += '&filter='   + $('#filter').val();
		strURL += '&rows='     + $('#rows').val();
		strURL += '&device='   + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=trees&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_trees').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('Queue Tree Status', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_trees' action='mikrotik.php?action=trees'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Trees', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = "WHERE hrswls.name!=''";
	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ',' . $rows;

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			hrswls.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT hrswls.*, h.hostname, h.description, h.disabled
		FROM plugin_mikrotik_trees AS hrswls
		INNER JOIN host AS h
		ON h.id=hrswls.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_trees AS hrswls
		INNER JOIN host AS h
		ON h.id=hrswls.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'nosort'      => ['display' => __('Actions', 'mikrotik'),       'sort' => '',     'align' => 'left'],
		'description' => ['display' => __('Hostname', 'mikrotik'),      'sort' => 'ASC',  'align' => 'left'],
		'name'        => ['display' => __('Name', 'mikrotik'),          'sort' => 'DESC', 'align' => 'left'],
		'flow'        => ['display' => __('Flow', 'mikrotik'),          'sort' => 'DESC', 'align' => 'left'],
		'curBytes'    => ['display' => __('Cur Bytes', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right'],
		'curPackets'  => ['display' => __('Cur Packets', 'mikrotik'),   'sort' => 'DESC', 'align' => 'right'],
		'bytes'       => ['display' => __('Total Bytes', 'mikrotik'),   'sort' => 'DESC', 'align' => 'right'],
		'packets'     => ['display' => __('Total Packets', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'last_seen'   => ['display' => __('Last Seen', 'mikrotik'),     'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=trees', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Trees', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=trees');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($tree_hashes, $row['host_id'], str_replace(' ', '%', $row['name']));

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url = $row['description'];
			}

			print "<td class='nowrap'>$graphs</td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . filter_value($row['name'], get_request_var('filter')) . '</td>';
			print "<td class='left'>" . filter_value($row['flow'], get_request_var('filter')) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['curBytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['curPackets']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['bytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['packets']) . '</td>';
			print "<td class='right'>" . filter_value($row['last_seen'], get_request_var('filter')) . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>' . __('No Queue Trees Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the Wireless APs view: validates/stores this view's filter
 * request variables, renders the filter box, then queries and displays
 * a sortable/paginated table of collected MikroTik wireless access
 * points matching the selected filters. Called from this script's main
 * request-dispatch switch when action=wireless_aps.
 *
 * @return void
 *
 * @global array $config                   Cacti global configuration
 *                                         array; used to build device
 *                                         edit links.
 * @global array $item_rows                Cacti's standard row-count
 *                                         option list, used to
 *                                         populate the rows dropdown.
 * @global array $wireless_station_hashes  Reserved/declared for parity
 *                                         with other functions in this
 *                                         file; not used directly
 *                                         here.
 */
function mikrotik_wireless_aps(): void {
	global $config, $item_rows, $wireless_station_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'apSSID',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=wireless_aps';
		strURL += '&filter='   + $('#filter').val();
		strURL += '&rows='     + $('#rows').val();
		strURL += '&device='   + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=wireless_aps&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_wireless_aps').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('Wireless Aps Status', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_wireless_aps' action='mikrotik.php?action=wireless_aps'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Aps', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = '';
	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ',' . $rows;

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			hraps.apSSID LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			hraps.apBSSID LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			hraps.apBand LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT hraps.*, h.hostname, h.description, h.disabled
		FROM plugin_mikrotik_wireless_aps AS hraps
		INNER JOIN host AS h
		ON h.id=hraps.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_wireless_aps AS hraps
		INNER JOIN host AS h
		ON h.id=hraps.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'nosort'            => ['display' => __('Actions', 'mikrotik'),      'sort' => '',     'align' => 'left'],
		'description'       => ['display' => __('Hostname', 'mikrotik'),     'sort' => 'ASC',  'align' => 'left'],
		'apSSID'            => ['display' => __('SSID', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'apBSSID'           => ['display' => __('BSSID', 'mikrotik'),        'sort' => 'ASC',  'align' => 'left'],
		'apTxRate'          => ['display' => __('Tx Rate', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'apRxRate'          => ['display' => __('Rx Rate', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'apClientCount'     => ['display' => __('Clients', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'apAuthClientCount' => ['display' => __('Auth Clients', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'apFreq'            => ['display' => __('Frequency', 'mikrotik'),    'sort' => 'DESC', 'align' => 'right'],
		'apBand'            => ['display' => __('Band', 'mikrotik'),         'sort' => 'ASC',  'align' => 'right'],
		'apNoiseFloor'      => ['display' => __('Noise Floor', 'mikrotik'),  'sort' => 'ASC',  'align' => 'right'],
		'apOverallTxCCQ'    => ['display' => __('Tx CQQ', 'mikrotik'),       'sort' => 'ASC',  'align' => 'right'],
		'last_seen'         => ['display' => __('Last Seen', 'mikrotik'),    'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=wireless_aps', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Wireless Aps', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=wireless_aps');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($wireless_station_hashes, $row['host_id'], str_replace(' ', '%', $row['apSSID']));

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url = $row['description'];
			}

			print "<td class='nowrap'></td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . filter_value($row['apSSID'], get_request_var('filter')) . '</td>';
			print "<td class='left'>" . filter_value($row['apBSSID'], get_request_var('filter')) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['apTxRate'], 'b/s') . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['apRxRate'], 'b/s') . '</td>';
			print "<td class='right'>" . html_escape($row['apClientCount']) . '</td>';
			print "<td class='right'>" . html_escape($row['apAuthClientCount']) . '</td>';
			print "<td class='right'>" . round($row['apFreq'] / 1000,3) . ' GHz</td>';
			print "<td class='right'>" . filter_value($row['apBand'], get_request_var('filter')) . '</td>';
			print "<td class='right'>" . html_escape($row['apNoiseFloor']) . '</td>';
			print "<td class='right'>" . html_escape($row['apOverallTxCCQ']) . '</td>';
			print "<td class='right'>" . filter_value($row['last_seen'], get_request_var('filter')) . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>No Access Points Found</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Formats a duration in seconds as a 'days:hours:minutes' runtime
 * string. Called from mikrotik_users() to display each user's
 * connection/session duration.
 *
 * @param int $time The duration in seconds to format.
 *
 * @return string The formatted 'days:hours:minutes' string.
 */
function mikrotik_get_runtime(int $time): string {
	if ($time > 86400) {
		$days  = floor($time / 86400);
		$time %= 86400;
	} else {
		$days  = 0;
	}

	if ($time > 3600) {
		$hours = floor($time / 3600);
		$time %= 3600;
	} else {
		$hours = 0;
	}

	$minutes = floor($time / 60);

	return $days . ':' . $hours . ':' . $minutes;
}

/**
 * Renders the Users view: validates/stores this view's filter request
 * variables, renders the filter box, then queries and displays a
 * sortable/paginated table of collected MikroTik PPP/hotspot users
 * matching the selected filters, each with a link to its user graphs.
 * Called from this script's main request-dispatch switch when
 * action=users.
 *
 * @return void
 *
 * @global array $config                 Cacti global configuration
 *                                       array; used to build device
 *                                       edit links.
 * @global array $item_rows              Cacti's standard row-count
 *                                       option list, used to populate
 *                                       the rows dropdown.
 * @global array $mikrotik_hrSWTypes     Reserved/declared for parity
 *                                       with other functions in this
 *                                       file; not used directly here.
 * @global array $mikrotik_hrSWRunStatus Reserved/declared for parity
 *                                       with other functions in this
 *                                       file; not used directly here.
 * @global array $user_hashes            The list of user graph
 *                                       template hashes, used to build
 *                                       each user's 'view graphs'
 *                                       link.
 */
function mikrotik_users(): void {
	global $config, $item_rows, $mikrotik_hrSWTypes, $mikrotik_hrSWRunStatus, $user_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'type' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'active' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => 'true',
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=users';
		strURL += '&filter='   + $('#filter').val();
		strURL += '&type='     + $('#type').val();
		strURL += '&rows='     + $('#rows').val();
		strURL += '&active='   + $('#active').is(':checked');
		strURL += '&device='   + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=users&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_users').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('User Statistics', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_users' method='get' action='mikrotik.php?action=users'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT host.id, host.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host
								ON hrs.host_id=host.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Type', 'mikrotik'); ?>
					</td>
					<td>
						<select id='type'>
							<option value='-1'<?php if (get_request_var('type') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<option value='0'<?php if (get_request_var('type') == '0') {?> selected<?php }?>><?php print __('Hotspot', 'mikrotik'); ?></option>
							<option value='1'<?php if (get_request_var('type') == '1') {?> selected<?php }?>><?php print __('PPPoe', 'mikrotik'); ?></option>
						</select>
					</td>
					<td>
						<?php print __('Devices', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input type='checkbox' id='active' <?php print(get_request_var('active') == 'true' || get_request_var('active') == 'on' ? 'checked' : ''); ?>>
							<label for='active'><?php print __('Active Users', 'mikrotik'); ?></label>
						</span>
					</td>
					<td>
						<span>
							<input type='button' value='<?php print __esc('Go', 'mikrotik'); ?>' id='refresh'>
							<input type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>' id='clear'>
						</span>
					</td>
				</tr>
			</table>
			</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = "WHERE hrswr.name!=''";
	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ',' . $rows;

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('active') == 'true' || get_request_var('active') == 'on') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' present=1';
	}

	if (get_request_var('type') == '0') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' userType=0';
	} elseif (get_request_var('type') == '1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' userType=1';
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			hrswr.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT hrswr.*, h.hostname, h.description, h.disabled,
		bytesIn, bytesOut, curBytesIn, curBytesOut,
		bytesIn/connectTime AS avgBytesIn,
		bytesOut/connectTime AS avgBytesOut
		FROM plugin_mikrotik_users AS hrswr
		INNER JOIN host AS h
		ON h.id=hrswr.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_users AS hrswr
		INNER JOIN host AS h
		ON h.id=hrswr.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'nosort'       => ['display' => __('Actions', 'mikrotik'),      'sort' => '',     'align' => 'left'],
		'description'  => ['display' => __('Hostname', 'mikrotik'),     'sort' => 'ASC',  'align' => 'left'],
		'name'         => ['display' => __('User', 'mikrotik'),         'sort' => 'DESC', 'align' => 'left'],
		'userType'     => ['display' => __('Type', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'ip'           => ['display' => __('IP Address', 'mikrotik'),   'sort' => 'ASC',  'align' => 'left'],
		'mac'          => ['display' => __('MAC', 'mikrotik'),          'sort' => 'DESC', 'align' => 'left'],
		'connectTime'  => ['display' => __('Connect Time', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'curBytesIn'   => ['display' => __('Cur In', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'curBytesOut'  => ['display' => __('Cur Out', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'avgBytesIn'   => ['display' => __('Avg In', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'avgBytesOut'  => ['display' => __('Avg Out', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'bytesIn'      => ['display' => __('Total In', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right'],
		'bytesOut'     => ['display' => __('Total Out', 'mikrotik'),    'sort' => 'DESC', 'align' => 'right'],
		'last_seen'    => ['display' => __('Last Seen', 'mikrotik'),    'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=users', MAX_DISPLAY_PAGES, get_request_var('page'), get_request_var('rows'), $total_rows, sizeof($display_text), __('Users', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=users');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			$days    = 0;
			$hours   = 0;
			$minutes = 0;

			if ($row['present'] == 1) {
				$days      = intval($row['connectTime'] / (60 * 60 * 24));
				$remainder = $row['connectTime'] % (60 * 60 * 24);
				$hours     = intval($remainder / (60 * 60));
				$remainder = $remainder % (60 * 60);
				$minutes   = intval($remainder / (60));
			}

			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($user_hashes, $row['host_id'], str_replace(' ', '%', $row['name']));

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url = $row['description'];
			}

			print "<td class='nowrap'>$graphs</td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . filter_value($row['name'], get_request_var('filter')) . '</td>';
			print "<td class='left'>" . ($row['userType'] == 0 ? 'Hotspot' : 'PPPoe') . '</td>';

			if ($row['present'] == 1) {
				print "<td class='left'>" . filter_value($row['ip'], get_request_var('filter')) . '</td>';
				print "<td class='left'>" . filter_value($row['mac'], get_request_var('filter')) . '</td>';
				print "<td class='right'>" . mikrotik_format_uptime((int) $days, (int) $hours, (int) $minutes) . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['curBytesIn'] * 8, 'b/s') . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['curBytesOut'] * 8, 'b/s') . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['avgBytesIn'] * 8, 'b/s') . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['avgBytesOut'] * 8, 'b/s') . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['bytesIn'], 'B') . '</td>';
				print "<td class='right'>" . mikrotik_memory($row['bytesOut'], 'B') . '</td>';
				print "<td class='right'>" . html_escape($row['last_seen']) . '</td>';
			} else {
				print "<td class='left'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='left'>" . html_escape($row['mac']) . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . __('N/A', 'mikrotik') . '</td>';
				print "<td class='right'>" . html_escape($row['last_seen']) . '</td>';
			}

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>' . __('No Users Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the Devices view: validates/stores this view's filter
 * request variables, renders the filter box, then queries and displays
 * a sortable/paginated table of MikroTik-monitored devices matching
 * the selected filters. Called from this script's main request-
 * dispatch switch as the default view (action=devices or no action).
 *
 * @return void
 *
 * @global array $config    Cacti global configuration array; used to
 *                          build device edit links.
 * @global array $item_rows Cacti's standard row-count option list, used
 *                          to populate the rows dropdown.
 */
function mikrotik_devices(): void {
	global $config, $item_rows;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'status' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'description',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=devices';
		strURL += '&status='   + $('#status').val();
		strURL += '&filter='   + $('#filter').val();
		strURL += '&rows='     + $('#rows').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=devices&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('.changelog').click(function(event) {
			event.stopPropagation();
			window.open('https://mikrotik.com/download/changelogs', '<?php print __esc('MikroTik Changelog'); ?>');
		});

		$('#form_devices').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	$mikrotik_version_date = read_config_option('mikrotik_latestversion_date');

	if (empty($mikrotik_version_date) || intval($mikrotik_version_date) == 0) {
		$header = __('Device Filter (Latest MikroTik Version is: %s)', read_config_option('mikrotik_latestversion'), 'mikrotik');
	} else {
		$header = __('Device Filter (Latest MikroTik Version is: %s, Released: %s)', read_config_option('mikrotik_latestversion'), date('Y-m-d H:i:s', intval($mikrotik_version_date)), 'mikrotik');
	}

	$header .= "&nbsp;<a class='pic changelog' href='#'>" . __('ChangeLog', 'mikrotik', 'mikrotik') . '</a>';

	html_start_box($header, '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_devices' action='mikrotik.php?action=devices'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Status', 'mikrotik'); ?>
					</td>
					<td>
						<select id='status'>
							<option value='-1'<?php if (get_request_var('type') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$statuses = db_fetch_assoc('SELECT DISTINCT status
								FROM host
								INNER JOIN plugin_mikrotik_system
								ON host.id=plugin_mikrotik_system.host_id');

	$statuses = array_merge($statuses, ['-2' => ['status' => '-2']]);

	if (cacti_sizeof($statuses)) {
		foreach ($statuses as $s) {
			$status = '';

			switch($s['status']) {
				case '0':
					$status = __('Unknown', 'mikrotik');

					break;
				case '1':
					$status = __('Down', 'mikrotik');

					break;
				case '2':
					$status = __('Recovering', 'mikrotik');

					break;
				case '3':
					$status = __('Up', 'mikrotik');

					break;
				case '-2':
					$status = __('Disabled', 'mikrotik');

					break;
			}

			print "<option value='" . $s['status'] . "' " . (get_request_var('status') == $s['status'] ? 'selected' : '') . '>' . $status . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Devices', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
			</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = '';
	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ',' . $rows;

	if (get_request_var('status') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' hrs.host_status=' . get_request_var('status');
	}

	$sql_join = '';

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%');
	}

	$sql = "SELECT hrs.*, h.hostname, h.description, h.disabled, trees.trees, queues.queues, aps.aps
		FROM plugin_mikrotik_system AS hrs
		INNER JOIN host AS h
		ON h.id=hrs.host_id
		LEFT JOIN (SELECT host_id AS hid, count(*) AS trees FROM plugin_mikrotik_trees GROUP BY host_id) AS trees
		ON trees.hid=hrs.host_id
		LEFT JOIN (SELECT host_id AS hid, count(*) AS queues FROM plugin_mikrotik_queues GROUP BY host_id) AS queues
		ON queues.hid=hrs.host_id
		LEFT JOIN (SELECT host_id AS hid, count(*) AS aps FROM plugin_mikrotik_wireless_aps GROUP BY host_id) AS aps
		ON aps.hid=hrs.host_id
		$sql_join
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_system AS hrs
		INNER JOIN host AS h
		ON h.id=hrs.host_id
		$sql_join
		$sql_where");

	$display_text = [
		'nosort'          => ['display' => __('Actions', 'mikrotik'),       'sort' => 'ASC',  'align' => 'left'],
		'description'     => ['display' => __('Name', 'mikrotik'),          'sort' => 'ASC',  'align' => 'left'],
		'sysDescr'        => ['display' => __('Description', 'mikrotik'),   'sort' => 'ASC',  'align' => 'left'],
		'host_status'     => ['display' => __('Status', 'mikrotik'),        'sort' => 'DESC', 'align' => 'center'],
		'firmwareVersion' => ['display' => __('FW Ver', 'mikrotik'),        'sort' => 'DESC', 'align' => 'right'],
		'licVersion'      => ['display' => __('Lic Ver', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'uptime'          => ['display' => __('Uptime(d:h:m)', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'trees'           => ['display' => __('Trees', 'mikrotik'),         'sort' => 'DESC', 'align' => 'right'],
		'users'           => ['display' => __('Users', 'mikrotik'),         'sort' => 'DESC', 'align' => 'right'],
		'cpuPercent'      => ['display' => __('CPU %%%', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'numCpus'         => ['display' => __('CPUs', 'mikrotik'),          'sort' => 'DESC', 'align' => 'right'],
		'processes'       => ['display' => __('Processes', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right'],
		'memSize'         => ['display' => __('Total Mem', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right'],
		'memUsed'         => ['display' => __('Used Mem', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'diskSize'        => ['display' => __('Total Disk', 'mikrotik'),    'sort' => 'DESC', 'align' => 'right'],
		'diskUsed'        => ['display' => __('Used Disk', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=devices', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Devices', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=devices');

	// set some defaults
	$url        = $config['url_path'] . 'plugins/mikrotik/mikrotik.php';
	$users      = $config['url_path'] . 'plugins/mikrotik/images/view_users.gif';
	$usersn     = $config['url_path'] . 'plugins/mikrotik/images/view_users_none.gif';
	$host       = $config['url_path'] . 'plugins/mikrotik/images/view_hosts.gif';
	$trees      = $config['url_path'] . 'plugins/mikrotik/images/view_trees.gif';
	$treesn     = $config['url_path'] . 'plugins/mikrotik/images/view_trees_none.gif';
	$queues     = $config['url_path'] . 'plugins/mikrotik/images/view_queues.gif';
	$queuesn    = $config['url_path'] . 'plugins/mikrotik/images/view_queues_none.gif';
	$aps        = $config['url_path'] . 'plugins/mikrotik/images/view_aps.gif';
	$apsn       = $config['url_path'] . 'plugins/mikrotik/images/view_aps_none.gif';
	$interfaces = $config['url_path'] . 'plugins/mikrotik/images/view_interfaces.gif';
	$dashboard  = $config['url_path'] . 'plugins/mikrotik/images/view_dashboard.gif';
	$graphs     = $config['url_path'] . 'plugins/mikrotik/images/view_graphs.gif';
	$nographs   = $config['url_path'] . 'plugins/mikrotik/images/view_graphs_disabled.gif';

	$hcpudq            = read_config_option('mikrotik_dq_host_cpu');
	$licVersionLatest  = read_config_option('mikrotik_latestversion', true);

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			$days      = intval($row['uptime'] / (60 * 60 * 24 * 100));
			$remainder = $row['uptime'] % (60 * 60 * 24 * 100);
			$hours     = intval($remainder / (60 * 60 * 100));
			$remainder = $remainder % (60 * 60 * 100);
			$minutes   = intval($remainder / (60 * 100));

			$found = db_fetch_cell('SELECT COUNT(*) FROM graph_local WHERE host_id=' . $row['host_id']);

			form_alternate_row();

			print "<td class='nowrap left'>";

			// print "<a class='padding:1px;' href='" . htmlspecialchars("$url?action=dashboard&reset=1&device=" . $row["host_id"]) . "'><img src='$dashboard' title='View Dashboard'></a>";
			if ($row['users'] > 0) {
				print "<a class='pic' href='" . htmlspecialchars("$url?action=users&reset=1&device=" . $row['host_id']) . "'><i class='fas fa-users' style='color:lightblue;' title='" . __esc('View Users', 'mikrotik') . "'></i></a>";
			} elseif (read_config_option('mikrotik_users_freq') != '-1') {
				print "<a class='pic' href='#'><i class='fas fa-users' style='color:grey;' title='" . __esc('No Users Found', 'mikrotik') . "'></i></a>";
			}

			if ($row['queues'] > 0) {
				print "<a class='pic' style='padding:3px;' href='" . htmlspecialchars("$url?action=queues&reset=1&device=" . $row['host_id']) . "'><i class='fas fa-wave-square' style='padding:3px;color:blue;' title='" . __esc('View Simple Queue', 'mikrotik') . "'></i></a>";
			} elseif (read_config_option('mikrotik_queues_freq') != '-1') {
				print "<a class='pic' href='#'><i class='fas fa-wave-square' style='padding:3px;color:grey;' title='" . __esc('No Simple Queues Found', 'mikrotik') . "'></i></a>";
			}

			if ($row['trees'] > 0) {
				print "<a class='pic' href='" . htmlspecialchars("$url?action=trees&reset=1&device=" . $row['host_id']) . "'><i class='fas fa-tree' style='padding:3px;color:green;' title='" . __esc('View Queue Trees', 'mikrotik') . "'></i></a>";
			} elseif (read_config_option('mikrotik_trees_freq') != '-1') {
				print "<a class='pic' href='#'><i class='fas fa-tree' style='padding:3px;color:grey;' title='" . __esc('No Queue Trees Found', 'mikrotik') . "'></i></a>";
			}

			if ($row['aps'] > 0) {
				print "<a class='pic' href='" . htmlspecialchars("$url?action=wireless_aps&reset=1&device=" . $row['host_id']) . "'><i class='fas fa-wifi' style='padding:3px;color:lightblue;' title='" . __esc('View Wireless Aps', 'mikrotik') . "'></i></a>";
			} elseif (read_config_option('mikrotik_wireless_aps_freq') != '-1') {
				print "<a class='pic' href='#'><i class='fas fa-wifi' style='padding:3px;color:grey;' title='" . __esc('No Wireless Aps Found', 'mikrotik') . "'></i></a>";
			}

			print "<a class='pic' href='" . htmlspecialchars("$url?action=interfaces&reset=1&device=" . $row['host_id']) . "'><i class='fas fa-sitemap' style='padding:3px;color:#41A317;' title='" . __esc('View Interfaces', 'mikrotik') . "'></i></a>";

			if ($found) {
				print "<a class='pic' href='" . htmlspecialchars("$url?action=graphs&reset=1&host_id=" . $row['host_id'] . '&style=selective&graph_add=&graph_list=&graph_template_id=0&filter=') . "'><i class='fas fa-chart-line' style='padding:3px;color:orange;' title='" . __esc('View Graphs', 'mikrotik') . "'></i></a>";
			} else {
				print "<a class='pic' href='#'><i class='fas fa-chart-line' style='padding:3px;color:grey;' title='" . __esc('No Graphs Defined', 'mikrotik') . "'></i></a>";
			}

			$graph_cpu   = mikrotik_get_graph_url($hcpudq, $row['host_id'], '', $row['numCpus'], false);
			$graph_cpup  = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('7df474393f58bae8e8d6b85f10efad71'), $row['host_id'], (string) round($row['cpuPercent'],2), false);
			$graph_users = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('99e37ff13139f586d257ba9a637d7340'), $row['host_id'], (empty($row['users']) ? '-' : $row['users']), false);
			$graph_aproc = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('e797d967db24fd86341a8aa8c60fa9e0'), $row['host_id'], ($row['host_status'] < 2 ? 'N/A' : $row['processes']), false);
			$graph_disk  = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('0ece13b90785aa04d1f554a093685948'), $row['host_id'], ($row['host_status'] < 2 ? 'N/A' : (string) round($row['diskUsed'],2)), false);
			$graph_mem   = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('4396ae857c4f9bc5ed1f26b5361e42d9'), $row['host_id'], ($row['host_status'] < 2 ? 'N/A' : (string) round($row['memUsed'],2)), false);
			$graph_upt   = mikrotik_get_graph_template_url((int) mikrotik_template_by_hash('7d8dc3050621a2cb937cac3895bc5d5b'), $row['host_id'], ($row['host_status'] < 2 ? 'N/A' : mikrotik_format_uptime((int) $days, (int) $hours, (int) $minutes)), false);

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url    = "<a class='pic' href='" . htmlspecialchars($config['url_path'] . 'host.php?action=edit&id=' . $row['host_id']) . "' title='Edit Device'>" . (strlen(get_request_var('filter')) ? preg_replace('/(' . preg_quote(get_request_var('filter'), '/') . ')/i', "<span class='filteredValue'>\\1</span>",  $row['description']) : $row['description']) . '</a>';
			} else {
				$host_url    = $row['description'];
			}

			print '</td>';
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left'>" . html_escape($row['sysDescr']) . '</td>';
			print "<td class='center'>" . get_colored_device_status(($row['disabled'] == 'on' ? true : false), $row['host_status']) . '</td>';
			print "<td class='right'>" . ($row['firmwareVersionLatest'] != $row['firmwareVersion'] && $row['firmwareVersionLatest'] != '' ? '* ' : '') . html_escape($row['firmwareVersion']) . '</td>';
			print "<td class='right'>" . ($licVersionLatest > $row['licVersion'] && $licVersionLatest != '' ? '* ' : '') . html_escape($row['licVersion']) . '</td>';
			print "<td class='right'>" . $graph_upt . '</td>';
			print "<td class='right'>" . (!empty($row['trees']) ? html_escape($row['trees']) : '-') . '</td>';
			print "<td class='right'>" . $graph_users . '</td>';
			print "<td class='right'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpup) . '</td>';
			print "<td class='right'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpu) . '</td>';
			print "<td class='right'>" . $graph_aproc . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['memSize']) . '</td>';
			print "<td class='right'>" . ($graph_mem == '-' ? '-' : $graph_mem . ' %') . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['diskSize']) . '</td>';
			print "<td class='right'>" . ($graph_disk == '-' ? '-' : $graph_disk . ' %') . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>' . __('No Devices Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.pic, i").tooltip(); });</script>';
}

/**
 * Formats a days/hours/minutes uptime triple into a 'Nd Nh Nm' display
 * string, omitting the days segment entirely when zero. Called when
 * rendering a device's uptime in the MikroTik views.
 *
 * @param int $d Days.
 * @param int $h Hours.
 * @param int $m Minutes.
 *
 * @return string The formatted uptime string.
 */
function mikrotik_format_uptime(int $d, int $h, int $m): string {
	return ($d > 0 ? mikrotik_right('000' . $d, 3, true) . 'd ' : '') . mikrotik_right('000' . $h, 2) . 'h ' . mikrotik_right('000' . $m, 2) . 'm';
}

/**
 * Returns the rightmost $chars characters of a string, used to truncate
 * a zero-padded number to a fixed width, optionally stripping leading
 * zeros from the result. Called from mikrotik_format_uptime() to pad/
 * trim each uptime component.
 *
 * @param string $string The string to truncate.
 * @param int    $chars  The number of trailing characters to keep.
 * @param bool   $strip  Whether to strip leading zeros from the
 *                       truncated result.
 *
 * @return string The rightmost $chars characters of $string, with
 *                leading zeros optionally stripped.
 */
function mikrotik_right(string $string, int $chars, bool $strip = false): string {
	if ($strip) {
		return ltrim(strrev(substr(strrev($string), 0, $chars)),'0');
	} else {
		return strrev(substr(strrev($string), 0, $chars));
	}
}

/**
 * Formats a byte count as a human-readable, HTML-escaped size string
 * with the appropriate unit suffix (blank/K/M/G/T/P), appending an
 * optional caller-supplied suffix (e.g. 'bps'). Called when rendering
 * memory/storage/traffic sizes in the MikroTik views.
 *
 * @param float|null $mem    The size to format.
 * @param string $suffix An optional extra suffix to append after the
 *                       unit letter.
 *
 * @return string The formatted, HTML-escaped size string.
 */
function mikrotik_memory(?float $mem, string $suffix = ''): string {
	// Nullable DB rate columns (e.g. apTxRate/apRxRate DEFAULT NULL) normalize to 0 here.
	$mem = (float) $mem;

	// DB-sourced $mem/$suffix are only ever used for display; html_escape() here covers every call site at once.
	if ($mem < 1024) {
		return html_escape(round($mem,0) . "  $suffix");
	}
	$mem /= 1024;

	if ($mem < 1024) {
		return html_escape(round($mem,2) . " K$suffix");
	}
	$mem /= 1024;

	if ($mem < 1024) {
		return html_escape(round($mem,2) . " M$suffix");
	}
	$mem /= 1024;

	if ($mem < 1024) {
		return html_escape(round($mem,2) . " G$suffix");
	}
	$mem /= 1024;

	if ($mem < 1024) {
		return html_escape(round($mem,2) . " T$suffix");
	}
	$mem /= 1024;

	return html_escape(round($mem,2) . " P$suffix");
}

/**
 * Builds a link to the Devices view filtered by status, displaying a
 * count as its label (or the plain count if zero, with no link).
 * Called when rendering per-status device counts in the MikroTik
 * views.
 *
 * @param int $count  The device count to display as the link label.
 * @param int $status The device status to filter the Devices view by.
 *
 * @return string An HTML anchor linking to the filtered Devices view,
 *                or the plain $count if it is not greater than zero.
 *
 * @global array $config Cacti global configuration array; used to
 *                       build the link URL.
 */
function mikrotik_get_device_status_url(int $count, int $status): string {
	global $config;

	if ($count > 0) {
		return "<a href='" . htmlspecialchars($config['url_path'] . "plugins/mikrotik/mikrotik.php?action=devices&reset=1&status=$status") . "' title='View Hosts'>$count</a>";
	} else {
		return (string) $count;
	}
}

/**
 * Builds a link (icon or titled text) to the selective Graphs view for
 * all graphs using a given graph template, optionally restricted to a
 * specific device. Called from list views when rendering a 'view
 * graphs' action for a graph template.
 *
 * @param int    $graph_template The graph_templates id to find graphs
 *                               for.
 * @param int    $host_id        Optional host id to restrict the search
 *                               to a single device.
 * @param string $title          The link text to use when $image is
 *                               false.
 * @param bool   $image          Whether to render an icon link (true) or
 *                               a titled text link (false).
 *
 * @return string An HTML anchor linking to the matching graphs, a '-'
 *                placeholder if no matching graphs are found, an icon
 *                hint if no graph template is set, or $title unchanged
 *                (in text mode with no template).
 *
 * @global array $config Cacti global configuration array; used to
 *                       build the link URL and image paths.
 */
function mikrotik_get_graph_template_url(int $graph_template, int $host_id = 0, string $title = '', bool $image = true): string {
	global $config;

	$url     = $config['url_path'] . 'plugins/mikrotik/mikrotik.php';
	$nograph = $config['url_path'] . 'plugins/mikrotik/images/view_graphs_disabled.gif';
	$graph   = $config['url_path'] . 'plugins/mikrotik/images/view_graphs.gif';

	if (!empty($graph_template)) {
		if ($host_id > 0) {
			$sql_join  = '';
			$sql_where = "AND gl.host_id=$host_id";
		} else {
			$sql_join  = '';
			$sql_where = '';
		}

		$graphs = db_fetch_assoc("SELECT gl.* FROM graph_local AS gl
			$sql_join
			WHERE gl.graph_template_id=$graph_template
			$sql_where");

		$graph_add = '';

		if (cacti_sizeof($graphs)) {
			foreach ($graphs as $graph) {
				$graph_add .= (strlen($graph_add) ? ',' : '') . $graph['id'];
			}
		}

		if (cacti_sizeof($graphs)) {
			if ($image) {
				return "<a class='hyperLink' href='" . htmlspecialchars($url . "?action=graphs&reset=1&style=selective&graph_add=$graph_add&graph_list=&graph_template_id=0&filter=") . "' title='" . __esc('View Graphs', 'mikrotik') . "'><i class='fas fa-chart-line' style='padding:3px;color:orange;'></i></a>";
			} else {
				return "<a class='hyperLink' href='" . htmlspecialchars($url . "?action=graphs&reset=1&style=selective&graph_add=$graph_add&graph_list=&graph_template_id=0&filter=") . "' title='" . __esc('View Graphs', 'mikrotik') . "'>$title</a>";
			}
		} else {
			return '-';
		}
	} elseif ($image) {
		return "<i class='fas fa-chart-line' style='padding:3px;' title='" . __esc('Please Select Data Query First from Console -> Settings -> Host MIB First', 'mikrotik') . "'></i>";
	} else {
		return $title;
	}
}

/**
 * Builds a link (icon or titled text) to the selective Graphs view for
 * graphs from a given data query, optionally restricted to a specific
 * SNMP index and/or device. Called from list views when rendering a
 * 'view graphs' action for a data-query-driven metric (e.g. a specific
 * queue or interface entry).
 *
 * @param int    $data_query The snmp_query id to find graphs for. May be
 *                           null (e.g. an unset Host MIB data query
 *                           setting), which is treated the same as 0.
 * @param int    $host_id    Optional host id to restrict the search to
 *                           a single device.
 * @param string $index      Optional SNMP index to restrict the search
 *                           to a specific data query row.
 * @param string $title      The link text to use when $image is false.
 * @param bool   $image      Whether to render an icon link (true) or a
 *                           titled text link (false).
 *
 * @return string An HTML anchor linking to the matching graphs, an icon
 *                hint if none are found or no data query is set, or
 *                $title unchanged (in text mode with no data query).
 *
 * @global array $config Cacti global configuration array; used to
 *                       build the link URL and image paths.
 */
function mikrotik_get_graph_url(?int $data_query, int $host_id, string $index, string $title = '', bool $image = true): string {
	global $config;

	$url     = $config['url_path'] . 'plugins/mikrotik/mikrotik.php';
	$nograph = $config['url_path'] . 'plugins/mikrotik/images/view_graphs_disabled.gif';
	$graph   = $config['url_path'] . 'plugins/mikrotik/images/view_graphs.gif';

	$hsql = '';
	$hstr = '';

	if (!empty($data_query)) {
		$sql    = "SELECT DISTINCT gl.id
			FROM graph_local AS gl
			WHERE gl.snmp_query_id=$data_query " .
			($index!='' ? " AND gl.snmp_index IN ('$index')" : '') .
			($host_id!='' ? " AND gl.host_id=$host_id" : '') .
			($hstr!='' ? " AND gl.host_id IN $hstr" : '');

		$graphs = db_fetch_assoc($sql);

		$graph_add = '';

		if (cacti_sizeof($graphs)) {
			foreach ($graphs as $g) {
				$graph_add .= (strlen($graph_add) ? ',' : '') . $g['id'];
			}
		}

		if (cacti_sizeof($graphs)) {
			if ($image) {
				return "<a class='hyperLink' href='" . htmlspecialchars($url . "?action=graphs&reset=1&style=selective&graph_add=$graph_add&graph_list=&graph_template_id=0&filter=") . "' title='" . __esc('View Graphs', 'mikrotik') . "'><i class='fas fa-chart-line' style='padding:3px;color:orange;'></i></a>";
			} else {
				return "<a class='hyperLink' href='" . htmlspecialchars($url . "?action=graphs&reset=1&style=selective&graph_add=$graph_add&graph_list=&graph_template_id=0&filter=") . "' title='" . __esc('View Graphs', 'mikrotik') . "'>$title</a>";
			}
		} else {
			return "<i class='fas fa-chart-line' style='padding:3px;' title='" . __esc('Graphs skipped or not created yet', 'mikrotik') . "'></i>";
		}
	} elseif ($image) {
		return "<i class='fas fa-chart-line' style='padding:3px;' title='" . __esc('Please select Data Query first from Console->Settings->Host MIB First', 'mikrotik') . "'></i>";
	} else {
		return $title;
	}
}

/**
 * Resolves a list of graph template hashes into their corresponding
 * graph_templates ids. Called from mikrotik_view_graphs() and other
 * filtering code needing to constrain a query to this plugin's known
 * graph templates.
 *
 * @param array $hashes The list of graph template hashes to resolve.
 *
 * @return array The matching graph_templates ids, keyed by id.
 */
function mikrotik_graph_templates_from_hashes(array $hashes): array {
	return array_rekey(db_fetch_assoc('SELECT id
		FROM graph_templates
		WHERE hash IN ("' . implode('","', $hashes) . '")'), 'id', 'id');
}

/**
 * Resolves a list of host template hashes into the ids of devices using
 * any of those templates. Called from filtering code needing to
 * constrain a query to devices using this plugin's known host
 * templates.
 *
 * @param array $hashes The list of host template hashes to resolve.
 *
 * @return array The matching host ids, keyed by id.
 */
function mikrotik_host_ids_from_hashes(array $hashes): array {
	return array_rekey(db_fetch_assoc('SELECT h.id
		FROM host AS h
		INNER JOIN host_template AS ht
		ON h.host_template_id=ht.id
		WHERE hash IN ("' . implode('","', $hashes) . '")'), 'id', 'id');
}

/**
 * Renders the Graphs view: reuses Cacti's standard graph-preview
 * filter/rendering framework, pre-scoped to devices using this
 * plugin's known host templates and graphs using its known graph
 * templates (further narrowed by any selective graph list supplied via
 * a 'view graphs' link). Called from this script's main request-
 * dispatch switch when action=graphs.
 *
 * @return void
 *
 * @global object $current_user           Reserved/declared for parity
 *                                        with Cacti's graph-view
 *                                        rendering; not used directly
 *                                        here.
 * @global array  $config                 Cacti global configuration
 *                                        array; used throughout graph
 *                                        rendering.
 * @global array  $host_template_hashes   The list of this plugin's host
 *                                        template hashes, used to scope
 *                                        the device filter.
 * @global array  $graph_template_hashes  The list of this plugin's
 *                                        graph template hashes, used to
 *                                        scope the graph filter.
 */
function mikrotik_view_graphs(): void {
	global $current_user, $config, $host_template_hashes, $graph_template_hashes;

	include('./lib/timespan_settings.php');
	include('./lib/html_graph.php');

	html_graph_validate_preview_request_vars();

	// include graph view filter selector
	html_start_box(__('Graph Preview Filters', 'mikrotik') . (isset_request_var('style') && strlen(get_request_var('style')) ? ' [ ' . __('Custom Graph List Applied - Filtering from List', 'mikrotik') . ' ]' : ''), '100%', false, 3, 'center', '');

	html_graph_preview_filter('mikrotik.php', 'graphs', 'ht.hash IN ("' . implode('","', $host_template_hashes) . '")', 'gt.hash IN ("' . implode('","', $graph_template_hashes) . '")');

	html_end_box();

	// the user select a bunch of graphs of the 'list' view and wants them displayed here
	$sql_or = '';

	if (isset_request_var('style')) {
		if (get_request_var('style') == 'selective') {
			// process selected graphs
			if (!isempty_request_var('graph_list')) {
				foreach (explode(',',get_request_var('graph_list')) as $item) {
					$graph_list[$item] = 1;
				}
			} else {
				$graph_list = [];
			}

			if (!isempty_request_var('graph_add')) {
				foreach (explode(',',get_request_var('graph_add')) as $item) {
					$graph_list[$item] = 1;
				}
			}

			// remove items
			if (!isempty_request_var('graph_remove')) {
				foreach (explode(',',get_request_var('graph_remove')) as $item) {
					unset($graph_list[$item]);
				}
			}

			$i = 0;

			foreach ($graph_list as $item => $value) {
				$graph_array[$i] = $item;
				$i++;
			}

			if ((isset($graph_array)) && (cacti_sizeof($graph_array) > 0)) {
				// build sql string including each graph the user checked
				$sql_or = array_to_sql_or($graph_array, 'gtg.local_graph_id');

				$set_rra_id = empty($rra_id) ? read_user_setting('default_rra_id') : get_request_var('rra_id');
			}
		}
	}

	$total_graphs = 0;

	// Filter sql_where
	$sql_where  = (strlen(get_request_var('filter')) ? 'gtg.title_cache LIKE ' . db_qstr('%' . get_request_var('filter') . '%') : '');
	$sql_where .= (strlen($sql_or) && strlen($sql_where) ? ' AND ' : '') . $sql_or;

	// Host Id sql_where
	if (get_request_var('host_id') > 0) {
		$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' gl.host_id=' . get_request_var('host_id');
	} else {
		$host_ids = mikrotik_host_ids_from_hashes($host_template_hashes);

		if (cacti_sizeof($host_ids)) {
			$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' gl.host_id IN (' . implode(',', $host_ids) . ')';
		} else {
			$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' 1=0';
		}
	}

	// Graph Template Id sql_where
	if (get_request_var('graph_template_id') > 0) {
		$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' gl.graph_template_id IN(' . get_request_var('graph_template_id') . ')';
	} else {
		$graph_template_ids = mikrotik_graph_templates_from_hashes($graph_template_hashes);

		if (cacti_sizeof($graph_template_ids)) {
			$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' gl.graph_template_id IN (' . implode(',', $graph_template_ids) . ')';
		} else {
			$sql_where .= (strlen($sql_where) ? ' AND' : '') . ' 1=0';
		}
	}

	$limit  = (get_request_var('graphs') * (get_request_var('page') - 1)) . ',' . get_request_var('graphs');
	$order  = 'gtg.title_cache';

	$graphs = get_allowed_graphs($sql_where, $order, $limit, $total_graphs);

	// do some fancy navigation url construction so we don't have to try and rebuild the url string
	if (preg_match('/page=[0-9]+/',basename($_SERVER['QUERY_STRING']))) {
		$nav_url = str_replace('&page=' . get_request_var('page'), '', get_browser_query_string());
	} else {
		$nav_url = get_browser_query_string() . '&host_id=' . get_request_var('host_id');
	}

	$nav_url = preg_replace('/((\?|&)host_id=[0-9]+|(\?|&)filter=[a-zA-Z0-9]*)/', '', $nav_url) ?? '';

	$nav = html_nav_bar($nav_url, MAX_DISPLAY_PAGES, get_request_var('page'), get_request_var('graphs'), $total_graphs, get_request_var('columns'), __('Graphs', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	if (get_request_var('thumbnails') == 'true') {
		html_graph_thumbnail_area($graphs, '', 'graph_start=' . get_current_graph_start() . '&graph_end=' . get_current_graph_end(), '', get_request_var('columns'));
	} else {
		html_graph_area($graphs, '', 'graph_start=' . get_current_graph_start() . '&graph_end=' . get_current_graph_end(), '', get_request_var('columns'));
	}

	html_end_box();

	if ($total_graphs > 0) {
		print $nav;
	}

	bottom_footer();
}

/**
 * Renders the Wireless Registrations view: validates/stores this
 * view's filter request variables, renders the filter box, then
 * queries and displays a sortable/paginated table of collected
 * MikroTik wireless client registrations matching the selected
 * filters. Called from this script's main request-dispatch switch when
 * action=wireless_regs.
 *
 * @return void
 *
 * @global array $config              Cacti global configuration array;
 *                                    used to build device edit links.
 * @global array $item_rows           Cacti's standard row-count option
 *                                    list, used to populate the rows
 *                                    dropdown.
 * @global array $wireless_reg_hashes The list of wireless registration
 *                                    graph template hashes, used to
 *                                    build each row's 'view graphs'
 *                                    link.
 */
function mikrotik_wireless_regs(): void {
	global $config, $item_rows, $wireless_reg_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'active' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => 'true',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sincereset' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'index',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=wireless_regs';
		strURL += '&filter='     + $('#filter').val();
		strURL += '&rows='       + $('#rows').val();
		strURL += '&active='     + $('#active').is(':checked');
		strURL += '&sincereset=' + $('#sincereset').is(':checked');
		strURL += '&device='     + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=wireless_regs&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_wregs').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('Wireless Registration Stats', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_wregs' action='mikrotik.php?action=wireless_regs'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Registrations', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='active' type='checkbox' <?php print(get_request_var('active') == 'true' ? 'checked' : ''); ?>>
							<label for='active'><?php print __('Active', 'mikrotik'); ?></label>
						</span>
					<td>
						<span>
							<input id='sincereset' type='checkbox' <?php print(get_request_var('sincereset') == 'true' ? 'checked' : ''); ?>>
							<label for='sincereset'><?php print __('Since Reset', 'mikrotik'); ?></label>
						</span>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = "WHERE mtwr.index!=''";

	if (get_request_var('device') != '-1') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mtwr.index LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			h.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sort_column = get_request_var('sort_column');

	if (get_request_var('sincereset') == 'true') {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (RxBytes>0 or TxBytes>0)';
		}

		$pref = '';

		if (strpos($sort_column, 'cur') !== false) {
			$sort_column = str_replace('cur', '', $sort_column);
		}
	} else {
		if (get_request_var('active') == 'true') {
			$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' (curRxBytes>0 or curTxBytes>0)';
		}

		$pref = 'cur';

		if (strpos($sort_column, 'cur') === false) {
			switch($sort_column) {
				case 'description':
				case 'index':
				case 'last_seen':
				case 'Uptime':
				case 'TxRate':
				case 'RxRate':
				case 'SignalToNoise':
				case 'Strength':
					break;
				default:
					$sort_column = $pref . $sort_column;
			}
		}
	}

	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ', ' . $rows;

	$sql = "SELECT mtwr.*, h.hostname, dhcp.hostname AS client_name, h.description, h.disabled
		FROM plugin_mikrotik_wireless_registrations AS mtwr
		INNER JOIN host AS h
		ON h.id=mtwr.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		LEFT JOIN plugin_mikrotik_mac2hostname AS dhcp
		ON dhcp.mac_address=mtwr.index
		$sql_where
		$sql_order
		$sql_limit";

	$data_rows  = db_fetch_assoc($sql);
	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_wireless_registrations AS mtwr
		INNER JOIN host AS h
		ON h.id=mtwr.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		LEFT JOIN plugin_mikrotik_mac2hostname AS dhcp
		ON dhcp.mac_address=mtwr.index
		$sql_where");

	$display_text = [
		'nosort'            => ['display' => __('Actions', 'mikrotik'),         'sort' => '',     'align' => 'left'],
		'description'       => ['display' => __('Device', 'mikrotik'),          'sort' => 'ASC',  'align' => 'left'],
		'client_name'       => ['display' => __('Client Name', 'mikrotik'),     'sort' => 'ASC',  'align' => 'left'],
		'index'             => ['display' => __('MAC Address', 'mikrotik'),     'sort' => 'ASC',  'align' => 'left'],
		$pref . 'RxBytes'   => ['display' => __('Rx Bytes', 'mikrotik'),        'sort' => 'DESC', 'align' => 'right'],
		$pref . 'TxBytes'   => ['display' => __('Tx Bytes', 'mikrotik'),        'sort' => 'DESC', 'align' => 'right'],
		$pref . 'RxPackets' => ['display' => __('Rx Packets', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		$pref . 'TxPackets' => ['display' => __('Tx Packets', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'RxRate'            => ['display' => __('Rx Rate', 'mikrotik'),         'sort' => 'DESC', 'align' => 'right'],
		'TxRate'            => ['display' => __('Tx Rate', 'mikrotik'),         'sort' => 'DESC', 'align' => 'right'],
		'Uptime'            => ['display' => __('Uptime(d:h:m)', 'mikrotik'),   'sort' => 'DESC', 'align' => 'right'],
		'SignalToNoise'     => ['display' => __('Signal to Noise', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right'],
		'last_seen'         => ['display' => __('Last Seen', 'mikrotik'),       'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=wireless_regs', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Registrations', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, $sort_column, get_request_var('sort_direction'), 1, 'mikrotik.php?action=wireless_regs');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			if (strpos($row['Uptime'], ':') !== false) {
				[$days, $hours, $minutes, $seconds] = explode(':', $row['Uptime']);
			} else {
				$days      = intval($row['Uptime'] / (60 * 60 * 24 * 100));
				$remainder = $row['Uptime'] % (60 * 60 * 24 * 100);
				$hours     = intval($remainder / (60 * 60 * 100));
				$remainder = $remainder % (60 * 60 * 100);
				$minutes   = intval($remainder / (60 * 100));
			}

			form_alternate_row();

			$graphs = mikrotik_graphs_url_by_template_hashs($wireless_reg_hashes, $row['host_id'], $row['index']);

			if (api_plugin_user_realm_auth('host.php')) {
				$host_url = filter_value($row['description'], get_request_var('filter'), $config['url_path'] . 'host.php?action=edit&id=' . $row['host_id'], __('Edit Device', 'microtik'));
			} else {
				$host_url = $row['description'];
			}

			print "<td class='nowrap'>$graphs</td>";
			print "<td class='left nowrap'>" . $host_url . '</td>';
			print "<td class='left nowrap'>" . filter_value($row['client_name'], get_request_var('filter')) . '</td>';
			print "<td class='left nowrap'>" . filter_value($row['index'], get_request_var('filter')) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'RxBytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'TxBytes']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'RxPackets']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row[$pref . 'TxPackets']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['RxRate']) . '</td>';
			print "<td class='right'>" . mikrotik_memory($row['TxRate']) . '</td>';
			print "<td class='right'>" . mikrotik_format_uptime((int) $days, (int) $hours, (int) $minutes) . '</td>';
			print "<td class='right'>" . html_escape($row['SignalToNoise']) . '</td>';
			print "<td class='right'>" . filter_value($row['last_seen'], get_request_var('filter')) . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="5"><em>' . __('No Wireless Registrations Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the DHCP view: validates/stores this view's filter request
 * variables, renders the filter box, then queries and displays a
 * sortable/paginated table of collected MikroTik DHCP leases matching
 * the selected filters. Called from this script's main request-
 * dispatch switch when action=dhcp.
 *
 * @return void
 *
 * @global array $config      Cacti global configuration array; used to
 *                            build device edit links.
 * @global array $item_rows   Cacti's standard row-count option list,
 *                            used to populate the rows dropdown.
 * @global array $tree_hashes Reserved/declared for parity with other
 *                            functions in this file; not used directly
 *                            here.
 */
function mikrotik_dhcp(): void {
	global $config, $item_rows, $tree_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'dhcp.hostname',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	?>
	<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = '?action=dhcp';
		strURL += '&filter='   + $('#filter').val();
		strURL += '&rows='     + $('#rows').val();
		strURL += '&device='   + $('#device').val();
		strURL += '&header=false';
		loadPageNoHeader(strURL);
	}

	function clearFilter() {
		strURL  = '?action=dhcp&clear=&header=false';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
			applyFilter();
		});

		$('#refresh').off('click').on('click', function() {
			applyFilter();
		});

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

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

		$('#form_dhcp').submit(function(event) {
			event.preventDefault();
			applyFilter();
		});
	});
	</script>
	<?php

	html_start_box(__('DHCP Registrations', 'mikrotik'), '100%', false, 3, 'center', '');

	?>
	<tr class='even noprint'>
		<td>
		<form id='form_dhcp' action='mikrotik.php?action=dhcp'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mikrotik'); ?>
					</td>
					<td>
						<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device', 'mikrotik'); ?>
					</td>
					<td>
						<select id='device'>
							<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
							<?php
							$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
								FROM plugin_mikrotik_system AS hrs
								INNER JOIN host AS h
								ON hrs.host_id=h.id
								ORDER BY description');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $h) {
			print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Entries', 'mikrotik'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $name) {
			print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();

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

	$sql_where = '';
	$sql_order = get_order_string();
	$sql_limit = ' LIMIT ' . ($rows * (get_request_var('page') - 1)) . ',' . $rows;

	if (get_request_var('device') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('filter') != '') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' (h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			dhcp.hostname LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT dhcp.*, h.description
		FROM plugin_mikrotik_dhcp AS dhcp
		INNER JOIN host AS h
		ON h.id=dhcp.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);

	$total_rows = db_fetch_cell("SELECT COUNT(*)
		FROM plugin_mikrotik_dhcp AS dhcp
		INNER JOIN host AS h
		ON h.id=dhcp.host_id
		INNER JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where");

	$display_text = [
		'description'   => ['display' => __('Hostname', 'mikrotik'),      'sort' => 'ASC',  'align' => 'left'],
		'dhcp.hostname' => ['display' => __('Client Name', 'mikrotik'),   'sort' => 'ASC',  'align' => 'left'],
		'address'       => ['display' => __('IP Address', 'mikrotik'),    'sort' => 'ASC',  'align' => 'left'],
		'status'        => ['display' => __('Status', 'mikrotik'),        'sort' => 'ASC',  'align' => 'left'],
		'mac_address'   => ['display' => __('MAC Address', 'mikrotik'),   'sort' => 'ASC',  'align' => 'right'],
		'expires_after' => ['display' => __('Expires in', 'mikrotik'),    'sort' => 'DESC', 'align' => 'right'],
		'last_seen'     => ['display' => __('Last Seen', 'mikrotik'),     'sort' => 'DESC', 'align' => 'right'],
		'dynamic'       => ['display' => __('Type', 'mikrotik'),          'sort' => 'DESC', 'align' => 'right'],
		'blocked'       => ['display' => __('Blocked', 'mikrotik'),       'sort' => 'DESC', 'align' => 'right'],
		'disabled'      => ['display' => __('Disabled', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'last_updated'  => ['display' => __('Last Updated', 'mikrotik'),  'sort' => 'ASC',  'align' => 'right']
	];

	$nav = html_nav_bar('mikrotik.php?action=dhcp', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Entries', 'mikrotik'), 'page', 'main');

	print $nav;

	html_start_box('', '100%', false, 3, 'center', '');

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=dhcp');

	if (cacti_sizeof($data_rows)) {
		foreach ($data_rows as $row) {
			form_alternate_row();

			print "<td class='left nowrap'>" . html_escape($row['description']) . '</td>';
			print "<td class='left'>" . ($row['hostname'] != '' ? filter_value($row['hostname'], get_request_var('filter')) : __('Unknown', 'mikrotik')) . '</td>';
			print "<td class='left'>" . filter_value($row['address'], get_request_var('filter')) . '</td>';
			print "<td class='left'>" . ($row['status'] ? html_escape($row['status']) : __('N/A', 'mikrotik')) . '</td>';
			print "<td class='right'>" . filter_value($row['mac_address'], get_request_var('filter')) . '</td>';

			print "<td class='right'>" . ($row['expires_after'] ? __('%s Seconds', html_escape($row['expires_after']), 'mikrotik') : __('N/A', 'mikrotik')) . '</td>';
			print "<td class='right'>" . ($row['last_seen'] ? __('%s Seconds', html_escape($row['last_seen']), 'mikrotik') : __('N/A', 'mikrotik')) . '</td>';

			print "<td class='right'>" . ($row['dynamic'] ? __('Dynamic', 'mikrotik') : __('Static', 'mikrotik')) . '</td>';
			print "<td class='right'>" . ($row['blocked'] ? 'true' : 'false') . '</td>';
			print "<td class='right'>" . ($row['disabled'] ? 'true' : 'false') . '</td>';
			print "<td class='right'>" . html_escape($row['last_updated']) . '</td>';

			form_end_row();
		}
	} else {
		print '<tr><td colspan="' . sizeof($display_text) . '"><em>' . __('No DHCP Entries Found', 'mikrotik') . '</em></td></tr>';
	}

	html_end_box();

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

	print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
}

/**
 * Renders the DNS Cache view: validates/stores this view's filter
 * request variables, then either renders the filter box plus a
 * sortable/paginated table of collected MikroTik DNS cache entries
 * matching the selected filters, or (when $export is true) streams all
 * matching entries as a downloadable CSV file. Called from this
 * script's main request-dispatch switch when action=dns, with
 * $export=true when action=dnsexport.
 *
 * @param bool $export Whether to export matching entries as CSV
 *                     instead of rendering the HTML view.
 *
 * @return void
 *
 * @global array $config      Cacti global configuration array; used to
 *                            build device edit links.
 * @global array $item_rows   Cacti's standard row-count option list,
 *                            used to populate the rows dropdown.
 * @global array $tree_hashes Reserved/declared for parity with other
 *                            functions in this file; not used directly
 *                            here.
 */
function mikrotik_dns(bool $export = false): void {
	global $config, $item_rows, $tree_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'type' => [
			'filter'  => FILTER_CALLBACK,
			'default' => '-1',
			'pageset' => true,
			'options' => ['options' => 'sanitize_search_string']
			],
		'status' => [
			'filter'  => FILTER_CALLBACK,
			'default' => '-1',
			'pageset' => true,
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_DEFAULT,
			'pageset' => true,
			'default' => '',
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'dns.name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	if (!$export) {
		?>
		<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
		function applyFilter() {
			strURL  = '?action=dns';
			strURL += '&filter='   + $('#filter').val();
			strURL += '&rows='     + $('#rows').val();
			strURL += '&device='   + $('#device').val();
			strURL += '&status='   + $('#status').val();
			strURL += '&type='     + $('#type').val();
			strURL += '&header=false';
			loadPageNoHeader(strURL);
		}

		function clearFilter() {
			strURL  = '?action=dns&clear=&header=false';
			loadPageNoHeader(strURL);
		}

		function exportData() {
			strURL  = '?action=dnsexport';
			document.location = strURL;
		}

		$(function() {
			$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
				applyFilter();
			});

			$('#refresh').off('click').on('click', function() {
				applyFilter();
			});

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

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

			$('#form_dns').submit(function(event) {
				event.preventDefault();
				applyFilter();
			});
		});
		</script>
		<?php

		html_start_box(__('DNS Cache', 'mikrotik'), '100%', false, 3, 'center', '');

		?>
		<tr class='even noprint'>
			<td>
			<form id='form_dns' action='mikrotik.php?action=dns'>
				<table class='filterTable'>
					<tr>
						<td>
							<?php print __('Search', 'mikrotik'); ?>
						</td>
						<td>
							<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
						</td>
						<td>
							<?php print __('Device', 'mikrotik'); ?>
						</td>
						<td>
							<select id='device'>
								<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
								<?php
								$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
									FROM plugin_mikrotik_system AS hrs
									INNER JOIN host AS h
									ON hrs.host_id=h.id
									ORDER BY description');

		if (cacti_sizeof($hosts)) {
			foreach ($hosts as $h) {
				print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<?php print __('Type', 'mikrotik'); ?>
						</td>
						<td>
							<select id='type'>
								<option value='-1'<?php if (get_request_var('type') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
								<?php
		$types = db_fetch_assoc('SELECT DISTINCT type
									FROM plugin_mikrotik_dns AS dns
									INNER JOIN host AS h
									ON dns.host_id=h.id
									WHERE type != "-1"
									ORDER BY type');

		if (cacti_sizeof($types)) {
			foreach ($types as $t) {
				print "<option value='" . $t['type'] . "' " . (get_request_var('type') == $t['type'] ? 'selected' : '') . '>' . $t['type'] . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<?php print __('Status', 'mikrotik'); ?>
						</td>
						<td>
							<select id='status'>
								<option value='-1'<?php if (get_request_var('type') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
								<?php
		$status = [
			'active'  => __('Active', 'mikrotik'),
			'perm'    => __('Permanent', 'mikrotik'),
			'expired' => __('Expired', 'mikrotik')
		];

		if (cacti_sizeof($status)) {
			foreach ($status as $key => $name) {
				print "<option value='" . $key . "' " . (get_request_var('status') == $key ? 'selected' : '') . '>' . $name . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<?php print __('Entries', 'mikrotik'); ?>
						</td>
						<td>
							<select id='rows'>
								<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
								<?php
		if (cacti_sizeof($item_rows)) {
			foreach ($item_rows as $key => $name) {
				print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<span>
								<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
								<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
								<input id='export' type='button' value='<?php print __esc('Export', 'mikrotik'); ?>'>
							</span>
						</td>
					</tr>
				</table>
			</form>
			</td>
		</tr>
		<?php

		html_end_box();

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

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

	$sql_where = '';
	$sql_order = get_order_string();

	if (get_request_var('device') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('type') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' dns.type=' . db_qstr(get_request_var('type'));
	}

	if (get_request_var('status') == 'expired') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' dns.ttl = 0';
	} elseif (get_request_var('status') == 'perm') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' dns.static = "true"';
	} elseif (get_request_var('status') == 'active') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' dns.ttl > 0';
	}

	if (get_request_var('filter') != '') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' (
			h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			dns.type LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			dns.data LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			dns.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT dns.*, h.description, h.hostname
		FROM plugin_mikrotik_dns AS dns
		LEFT JOIN host AS h
		ON h.id=dns.host_id
		LEFT JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);

	$display_text = [
		'description'       => ['display' => __('Description', 'mikrotik'),  'sort' => 'ASC',  'align' => 'left'],
		'dns.type'          => ['display' => __('Type', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'dns.data'          => ['display' => __('Data', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'dns.name'          => ['display' => __('Name', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'dns.ttl'           => ['display' => __('TTL', 'mikrotik'),          'sort' => 'DESC', 'align' => 'right'],
		'dns.static'        => ['display' => __('Static', 'mikrotik'),       'sort' => 'ASC',  'align' => 'right'],
		'dns.last_updated'  => ['display' => __('Last Updated', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right']
	];

	if (!$export) {
		$total_rows = db_fetch_cell("SELECT COUNT(*)
			FROM plugin_mikrotik_dns AS dns
			LEFT JOIN host AS h
			ON h.id=dns.host_id
			LEFT JOIN plugin_mikrotik_system AS hrs
			ON hrs.host_id=h.id
			$sql_where");

		$nav = html_nav_bar('mikrotik.php?action=dns', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Entries', 'mikrotik'), 'page', 'main');

		print $nav;

		html_start_box('', '100%', false, 3, 'center', '');

		html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=dns');

		if (cacti_sizeof($data_rows)) {
			foreach ($data_rows as $row) {
				form_alternate_row();

				print "<td class='left nowrap'>" . filter_value($row['description'], get_request_var('filter')) . '</td>';
				print "<td class='left'>" . ($row['type'] != '' ? html_escape($row['type']) : __('Unknown', 'mikrotik')) . '</td>';

				if (strtoupper($row['type']) == 'TXT') {
					print "<td class='left'>" . __('N/A', 'mikrotik') . '</td>';
				} else {
					print "<td class='left'>" . filter_value($row['data'], get_request_var('filter')) . '</td>';
				}

				print "<td class='left'>" . filter_value($row['name'], get_request_var('filter')) . '</td>';

				if ($row['static'] == 'true') {
					print "<td class='right'>" . __('Permanent', 'mikrotik') . '</td>';
				} elseif ($row['ttl'] > 0) {
					print "<td class='right'>" . mikrotik_get_timeout($row['ttl']) . '</td>';
				} else {
					print "<td class='right'>" . __('Expired', 'mikrotik') . '</td>';
				}

				print "<td class='right'>" . html_escape($row['static']) . '</td>';
				print "<td class='right'>" . html_escape($row['last_updated']) . '</td>';

				form_end_row();
			}
		} else {
			print '<tr><td colspan="' . sizeof($display_text) . '"><em>' . __('No DNS Entries Found', 'mikrotik') . '</em></td></tr>';
		}

		html_end_box();

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

		print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
	} else {
		$output = '';

		foreach ($display_text as $id => $data) {
			$output .= ($output != '' ? ',' : '') . $data['display'];
		}

		$output .= PHP_EOL;

		if (cacti_sizeof($data_rows)) {
			foreach ($data_rows as $row) {
				$output .= '"' .
					$row['description'] . '","' .
					$row['type'] . '","' .
					$row['data'] . '","' .
					$row['name'] . '",' .
					$row['ttl'] . ',"' .
					$row['last_updated'] . '"' . PHP_EOL;
			}
		}

		header('Content-type: application/csv');
		header('Content-Disposition: attachment; filename=mikrotik_dns.csv');
		print $output;
	}
}

/**
 * Renders the Address Lists view: validates/stores this view's filter
 * request variables, then either renders the filter box plus a
 * sortable/paginated table of collected MikroTik firewall address-list
 * entries matching the selected filters, or (when $export is true)
 * streams all matching entries as a downloadable CSV file. Called from
 * this script's main request-dispatch switch when action=list, with
 * $export=true when action=listexport.
 *
 * @param bool $export Whether to export matching entries as CSV
 *                     instead of rendering the HTML view.
 *
 * @return void
 *
 * @global array $config      Cacti global configuration array; used to
 *                            build device edit links.
 * @global array $item_rows   Cacti's standard row-count option list,
 *                            used to populate the rows dropdown.
 * @global array $tree_hashes Reserved/declared for parity with other
 *                            functions in this file; not used directly
 *                            here.
 */
function mikrotik_list(bool $export = false): void {
	global $config, $item_rows, $tree_hashes;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => read_config_option('num_rows_table')
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'device' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'list' => [
			'filter'  => FILTER_CALLBACK,
			'default' => '-1',
			'pageset' => true,
			'options' => ['options' => 'sanitize_search_string']
			],
		'dynamic' => [
			'filter'  => FILTER_CALLBACK,
			'default' => '-1',
			'pageset' => true,
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_DEFAULT,
			'pageset' => true,
			'default' => '',
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'lists.address',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	if (!$export) {
		?>
		<script type='text/javascript' <?php print plugin_mikrotik_csp_nonce(); ?>>
		function applyFilter() {
			strURL  = '?action=list';
			strURL += '&filter='   + $('#filter').val();
			strURL += '&rows='     + $('#rows').val();
			strURL += '&device='   + $('#device').val();
			strURL += '&dynamic='  + $('#dynamic').val();
			strURL += '&list='     + $('#list').val();
			strURL += '&header=false';
			loadPageNoHeader(strURL);
		}

		function clearFilter() {
			strURL  = '?action=list&clear=&header=false';
			loadPageNoHeader(strURL);
		}

		function exportData() {
			strURL  = '?action=listexport';
			document.location = strURL;
		}

		$(function() {
			$('#device, #rows, #type, #status, #list, #active, #sincereset').off('change').on('change', function() {
				applyFilter();
			});

			$('#refresh').off('click').on('click', function() {
				applyFilter();
			});

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

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

			$('#form_list').submit(function(event) {
				event.preventDefault();
				applyFilter();
			});
		});
		</script>
		<?php

		html_start_box(__('Address Lists', 'mikrotik'), '100%', false, 3, 'center', '');

		?>
		<tr class='even noprint'>
			<td>
			<form id='form_list' action='mikrotik.php?action=list'>
				<table class='filterTable'>
					<tr>
						<td>
							<?php print __('Search', 'mikrotik'); ?>
						</td>
						<td>
							<input id='filter' type='text' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
						</td>
						<td>
							<?php print __('Device', 'mikrotik'); ?>
						</td>
						<td>
							<select id='device'>
								<option value='-1'<?php if (get_request_var('device') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
								<?php
								$hosts = db_fetch_assoc('SELECT DISTINCT h.id, h.description
									FROM plugin_mikrotik_system AS hrs
									INNER JOIN host AS h
									ON hrs.host_id=h.id
									ORDER BY description');

		if (cacti_sizeof($hosts)) {
			foreach ($hosts as $h) {
				print "<option value='" . $h['id'] . "' " . (get_request_var('device') == $h['id'] ? 'selected' : '') . '>' . $h['description'] . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<?php print __('List', 'mikrotik'); ?>
						</td>
						<td>
							<select id='list'>
								<option value='-1'<?php if (get_request_var('type') == '-1') {?> selected<?php }?>><?php print __('All', 'mikrotik'); ?></option>
								<?php
		$lists = db_fetch_assoc('SELECT DISTINCT list
									FROM plugin_mikrotik_lists AS lists
									INNER JOIN host AS h
									ON lists.host_id=h.id
									ORDER BY list');

		if (cacti_sizeof($lists)) {
			foreach ($lists as $l) {
				print "<option value='" . $l['list'] . "' " . (get_request_var('list') == $l['list'] ? 'selected' : '') . '>' . $l['list'] . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<?php print __('Entries', 'mikrotik'); ?>
						</td>
						<td>
							<select id='rows'>
								<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mikrotik'); ?></option>
								<?php
		if (cacti_sizeof($item_rows)) {
			foreach ($item_rows as $key => $name) {
				print "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
			}
		}
		?>
							</select>
						</td>
						<td>
							<span>
								<input id='refresh' type='button' value='<?php print __esc('Go', 'mikrotik'); ?>'>
								<input id='clear' type='button' value='<?php print __esc('Clear', 'mikrotik'); ?>'>
								<input id='export' type='button' value='<?php print __esc('Export', 'mikrotik'); ?>'>
							</span>
						</td>
					</tr>
				</table>
			</form>
			</td>
		</tr>
		<?php

		html_end_box();

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

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

	$sql_where = '';
	$sql_order = get_order_string();

	if (get_request_var('device') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' h.id=' . get_request_var('device');
	}

	if (get_request_var('list') != '-1') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' lists.list=' . db_qstr(get_request_var('list'));
	}

	if (get_request_var('filter') != '') {
		$sql_where .= ($sql_where != '' ? ' AND' : 'WHERE') . ' (
			h.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			lists.list LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			lists.dynamic LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			lists.disabled LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			lists.address LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	$sql = "SELECT lists.*, h.description, h.hostname
		FROM plugin_mikrotik_lists AS lists
		LEFT JOIN host AS h
		ON h.id=lists.host_id
		LEFT JOIN plugin_mikrotik_system AS hrs
		ON hrs.host_id=h.id
		$sql_where
		$sql_order
		$sql_limit";

	// print $sql;

	$data_rows  = db_fetch_assoc($sql);

	$display_text = [
		'description'         => ['display' => __('Description', 'mikrotik'),  'sort' => 'ASC',  'align' => 'left'],
		'lists.list'          => ['display' => __('List', 'mikrotik'),         'sort' => 'ASC',  'align' => 'left'],
		'lists.address'       => ['display' => __('Address', 'mikrotik'),      'sort' => 'ASC',  'align' => 'left'],
		'lists.dynamic'       => ['display' => __('Dynamic', 'mikrotik'),      'sort' => 'ASC',  'align' => 'right'],
		'lists.disabled'      => ['display' => __('Disabled', 'mikrotik'),     'sort' => 'ASC',  'align' => 'right'],
		'lists.timeout'       => ['display' => __('Timeout', 'mikrotik'),      'sort' => 'DESC', 'align' => 'right'],
		'lists.last_updated'  => ['display' => __('Last Updated', 'mikrotik'), 'sort' => 'DESC', 'align' => 'right']
	];

	if (!$export) {
		$total_rows = db_fetch_cell("SELECT COUNT(*)
			FROM plugin_mikrotik_lists AS lists
			LEFT JOIN host AS h
			ON h.id=lists.host_id
			LEFT JOIN plugin_mikrotik_system AS hrs
			ON hrs.host_id=h.id
			$sql_where");

		$nav = html_nav_bar('mikrotik.php?action=list', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, sizeof($display_text), __('Entries', 'mikrotik'), 'page', 'main');

		print $nav;

		html_start_box('', '100%', false, 3, 'center', '');

		html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'mikrotik.php?action=list');

		if (cacti_sizeof($data_rows)) {
			foreach ($data_rows as $row) {
				form_alternate_row();

				print "<td class='left nowrap'>" . filter_value($row['description'], get_request_var('filter')) . '</td>';
				print "<td class='left'>" . filter_value($row['list'], get_request_var('filter')) . '</td>';
				print "<td class='left'>" . filter_value($row['address'], get_request_var('filter')) . '</td>';

				print "<td class='right'>" . filter_value($row['dynamic'], get_request_var('filter')) . '</td>';
				print "<td class='right'>" . filter_value($row['disabled'], get_request_var('filter')) . '</td>';

				if ($row['timeout'] < 0 && $row['dynamic'] == 'false') {
					print "<td class='right'>" . __('Permanent', 'mikrotik') . '</td>';
				} elseif ($row['timeout'] <= 0) {
					print "<td class='right'>" . __('Expired', 'mikrotik') . '</td>';
				} else {
					print "<td class='right'>" . mikrotik_get_timeout($row['timeout']) . '</td>';
				}

				print "<td class='right'>" . html_escape($row['last_updated']) . '</td>';

				form_end_row();
			}
		} else {
			print '<tr><td colspan="' . sizeof($display_text) . '"><em>' . __('No Address List Entries Found', 'mikrotik') . '</em></td></tr>';
		}

		html_end_box();

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

		print '<script type="text/javascript" ' . plugin_mikrotik_csp_nonce() . '>$(function() { $("a.hyperLink, img").tooltip(); });</script>';
	} else {
		$output = '';

		foreach ($display_text as $id => $data) {
			$output .= ($output != '' ? ',' : '') . $data['display'];
		}

		$output .= PHP_EOL;

		if (cacti_sizeof($data_rows)) {
			foreach ($data_rows as $row) {
				$output .= '"' .
					$row['description'] . '","' .
					$row['list'] . '","' .
					$row['address'] . '","' .
					$row['dynamic'] . '","' .
					$row['disabled'] . '","' .
					$row['timeout'] . ',"' .
					$row['last_updated'] . '"' . PHP_EOL;
			}
		}

		header('Content-type: application/csv');
		header('Content-Disposition: attachment; filename=mikrotik_lists.csv');
		print $output;
	}
}

/**
 * Formats a timeout duration in seconds as a human-readable,
 * HTML-escaped 'Xd Xh Xm Xs'-style string (or plain seconds for values
 * under a minute). Called when rendering address-list/DHCP entry
 * timeouts in the MikroTik views.
 *
 * @param int $value The timeout duration in seconds to format.
 *
 * @return string The formatted, HTML-escaped timeout string.
 */
function mikrotik_get_timeout(int $value): string {
	// DB-sourced $value is only ever used for display; html_escape() here covers every call site at once.
	if ($value < 60) {
		return html_escape($value . 's');
	}

	$days = $hours = $minutes = $seconds = 0;

	if ($value > 86400) {
		$days  = floor($value / 86400);
		$value = $value - ($days * 86400);
	}

	if ($value > 3600) {
		$hours = floor($value / 3600);
		$value = $value - ($hours * 3600);
	}

	if ($value > 60) {
		$minutes = floor($value / 60);
		$value   = $value - ($minutes * 60);
	}

	if ($value > 0) {
		$seconds = $value;
	}

	return html_escape(
		($days > 0 ? $days . 'd' : '') .
		($hours > 0 ? $hours . 'h' : '') .
		($minutes > 0 ? $minutes . 'm' : '') .
		($seconds > 0 ? $seconds . 's' : '')
	);
}