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

$guest_account = true;

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

require_once($config['base_path'] . '/lib/rrd.php');
include_once($config['base_path'] . '/plugins/thold/includes/functions.php');
include_once($config['base_path'] . '/plugins/thold/setup.php');
include_once($config['base_path'] . '/plugins/thold/includes/database.php');
include($config['base_path'] . '/plugins/thold/includes/arrays.php');

thold_initialize_rusage();

plugin_thold_upgrade();

delete_old_thresholds();

set_default_action('thold');

switch(get_request_var('action')) {
	case 'ajax_hosts':
		get_allowed_ajax_hosts(true, false, 'h.id IN (SELECT host_id FROM thold_data)');

		break;
	case 'ajax_hosts_noany':
		get_allowed_ajax_hosts(false, false, 'h.id IN (SELECT host_id FROM thold_data)');

		break;
	case 'thold':
		general_header();
		thold_tabs();
		tholds();
		bottom_footer();

		break;
	case 'ack':
		thold_threshold_ack_prompt(get_filter_request_var('threshold_id'));

		break;
	case 'ack_confirm':
		thold_threshold_ack(get_filter_request_var('threshold_id'));
		raise_message('reset_ack', __('The Threshold has been Ascknowledged.', 'thold'), MESSAGE_LEVEL_INFO);

		header('Location: thold_graph.php');

		break;
	case 'reset_ack':
		thold_threshold_suspend_ack(get_filter_request_var('threshold_id'));
		raise_message('reset_ack', __('The Threshold will no longer generate Alerts, Notifications, or execute commands.', 'thold'), MESSAGE_LEVEL_INFO);

		header('Location: thold_graph.php');

		break;
	case 'resume_ack':
		thold_threshold_resume_ack(get_filter_request_var('threshold_id'));
		raise_message('reset_ack', __('The Threshold will restart generating Alerts.', 'thold'), MESSAGE_LEVEL_INFO);

		header('Location: thold_graph.php');

		break;
	case 'disable':
		thold_threshold_disable(get_filter_request_var('id'));

		header('Location: thold_graph.php');

		exit;
	case 'enable':
		thold_threshold_enable(get_filter_request_var('id'));

		header('Location: thold_graph.php');

		exit;
	case 'exportlog':
		thold_export_log();

		exit;
	case 'hoststat':
		general_header();
		thold_tabs();
		hosts();
		bottom_footer();

		break;
	default:
		if (api_plugin_hook_function('thold_graph_view', false) === false) {
			general_header();
			thold_tabs();
			thold_show_log();
			bottom_footer();
		}

		break;
}

// Clear the Nav Cache, so that it doesn't know we came from Thold
$_SESSION['sess_nav_level_cache'] = [];

/**
 * Renders the search/state/host/site/template filter form controls for
 * the thresholds list view.
 *
 * @return void
 *
 * @global array $item_rows Rows-per-page option list used to populate
 *                         the rows dropdown.
 * @global array $config    Cacti global configuration array (declared
 *                         but not used directly here).
 */
function form_thold_filter() {
	global $item_rows, $config;

	?>
	<tr class='even'>
		<td>
		<form id='thold' action='thold_graph.php'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'thold'); ?>
					</td>
					<td>
						<input type='text' id='rfilter' size='30' value='<?php print html_escape_request_var('rfilter'); ?>'>
					</td>
					<td>
						<?php print __('Site', 'thold'); ?>
					</td>
					<td>
						<select id='site_id'>
							<option value='-1'<?php if (get_request_var('site_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('site_id') == '0') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
							$sites = db_fetch_assoc('SELECT id, name
								FROM sites
								ORDER BY name');

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

			if (get_request_var('site_id') == $site['id']) {
				print ' selected';
			} print '>' . html_escape($site['name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<?php print html_host_filter(get_request_var('host_id')); ?>
					<td>
						<span>
							<input id='refresh' type='submit' value='<?php print __esc('Go', 'thold'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'thold'); ?>'>
						</span>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Template', 'thold'); ?>
					</td>
					<td>
						<select id='thold_template_id'>
							<option value='-1'<?php if (get_request_var('thold_template_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='-2'<?php if (get_request_var('thold_template_id') == '-2') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
	$thold_templates = db_fetch_assoc('SELECT DISTINCT tt.id, tt.name
								FROM thold_template as tt
								ORDER BY tt.name');

	foreach ($thold_templates as $row) {
		print "<option value='" . $row['id'] . "'" . (isset_request_var('thold_template_id') && $row['id'] == get_request_var('thold_template_id') ? ' selected' : '') . '>' . html_escape($row['name']) . '</option>';
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Data Template', 'thold'); ?>
					</td>
					<td>
						<select id='data_template_id'>
							<option value='-1'<?php if (get_request_var('data_template_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('data_template_id') == '0') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
	$data_templates = db_fetch_assoc('SELECT DISTINCT data_template.id, data_template.name
								FROM thold_data
								INNER JOIN data_template
								ON thold_data.data_template_id=data_template.id ' .
		(get_request_var('host_id') > 0 ? 'WHERE thold_data.host_id=' . get_request_var('host_id') : '') .
		' ORDER by data_template.name');

	if (cacti_sizeof($data_templates)) {
		foreach ($data_templates as $data_template) {
			print "<option value='" . $data_template['id'] . "'";

			if (get_request_var('data_template_id') == $data_template['id']) {
				print ' selected';
			} print '>' . html_escape($data_template['name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Status', 'thold'); ?>
					</td>
					<td>
						<select id='state'>
							<option value='-1'<?php if (get_request_var('state') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('state') == '0') {?> selected<?php }?>><?php print __('Breached or Triggered', 'thold'); ?></option>
							<option value='1'<?php if (get_request_var('state') == '1') {?> selected<?php }?>><?php print __('Breached', 'thold'); ?></option>
							<option value='3'<?php if (get_request_var('state') == '3') {?> selected<?php }?>><?php print __('Triggered', 'thold'); ?></option>
							<option value='2'<?php if (get_request_var('state') == '2') {?> selected<?php }?>><?php print __('Enabled', 'thold'); ?></option>
							<option value='6'<?php if (get_request_var('state') == '6') {?> selected<?php }?>><?php print __('Disabled', 'thold'); ?></option>
							<option value='7'<?php if (get_request_var('state') == '7') {?> selected<?php }?>><?php print __('Disabled at Template', 'thold'); ?></option>
							<option value='5'<?php if (get_request_var('state') == '5') {?> selected<?php }?>><?php print __('Disabled at Threshold', 'thold'); ?></option>
							<option value='4'<?php if (get_request_var('state') == '4') {?> selected<?php }?>><?php print __('Ack Required', 'thold'); ?></option>
							<optgroup label='<?php print html_escape(__('By Status', 'thold')); ?>'>
							<?php foreach ([101 => __('Alert', 'thold'), 102 => __('Baseline Alert', 'thold'), 103 => __('Warning', 'thold'), 104 => __('Notice', 'thold'), 105 => __('Ok', 'thold'), 106 => __('Acknowledgment', 'thold'), 107 => __('Disabled', 'thold')] as $sev_value => $sev_label) { ?>
								<option value='<?php print $sev_value; ?>'<?php if (get_request_var('state') == $sev_value) {?> selected<?php }?>><?php print html_escape($sev_label); ?></option>
							<?php } ?>
							</optgroup>
						</select>
					</td>
					<td>
						<?php print __('Thresholds', 'thold'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'thold'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('rows') == $key) {
				print ' selected';
			} print '>' . $value . '</option>';
		}
	}
	?>
						</select>
					</td>
				</tr>
			</table>
			<input type='hidden' id='page' value='<?php print html_escape(get_request_var('page')); ?>'>
			<input type='hidden' id='tab' value='thold'>
		</form>
		<script type='text/javascript' <?php print plugin_thold_csp_nonce(); ?>>

		function applyFilter() {
			strURL  = 'thold_graph.php?header=false&action=thold';
			strURL += '&state=' + encodeURIComponent($('#state').val());
			strURL += '&thold_template_id=' + encodeURIComponent($('#thold_template_id').val());
			strURL += '&data_template_id=' + encodeURIComponent($('#data_template_id').val());
			strURL += '&host_id=' + encodeURIComponent($('#host_id').val());
			strURL += '&site_id=' + encodeURIComponent($('#site_id').val());
			strURL += '&rows=' + encodeURIComponent($('#rows').val());
			strURL += '&rfilter=' + encodeURIComponent(base64_encode($('#rfilter').val()));
			loadPageNoHeader(strURL);
		}

		function clearFilter() {
			strURL  = 'thold_graph.php?header=false&action=thold&clear=1';
			loadPageNoHeader(strURL);
		}

		$(function() {
			$('#thold').submit(function(event) {
				event.preventDefault();
				applyFilter();
			});

			$('#site_id, #thold_template_id, #data_template_id, #state, #rows').change(function() {
				applyFilter();
			});

			$('.thold-pill').on('click keydown', function(e) {
				if (e.type === 'keydown' && e.which !== 13 && e.which !== 32) {
					return;
				}

				e.preventDefault();
				var state = $(this).attr('data-state');
				$('#state').val($('#state').val() === state ? '-1' : state);
				applyFilter();
			});

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

			$('.ackMessage').tooltip({
				items: '.ackMessage',
				track: false,
				position: { my: 'left', of: event, at: 'right+10', collision: 'fit' },
				content: function() {
					var text = atob($(this).attr('data-ack'));
					return text;
				},
				open: function(event, ui) {
					if (typeof(event.originalEvent) === 'undefined') {
						return false;
					}

					var id = $(ui.tooltip).attr('id');

					$('div.ui-tooltip').not('#' + id).remove();

					ui.tooltip.css('width', '800px');
					ui.tooltip.css('max-width', '800px');
				},
				close: function(event, ui) {
					ui.tooltip.hover(
						function() {
							$(this).stop(true).fadeTo(400, 1);
						},
						function() {
							$(this).fadeOut('400', function() {
								$(this).remove();
							});
						}
					);
				}
			});
		});

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

/**
 * Renders the main thresholds list page (the plugin's primary
 * dashboard view): validates/stores this view's filter request
 * variables, displays the threshold filter form, then displays a
 * filtered, sorted, paginated table of thresholds with a bulk-actions
 * dropdown and status legend. Called from this script's main
 * request-dispatch switch as the default 'thold' view.
 *
 * @return void
 *
 * @global array $config          Cacti global configuration array.
 * @global array $device_actions  Map of drp_action value => action
 *                                label, used for the bulk-actions
 *                                dropdown.
 * @global array $item_rows       Default number of rows per page from
 *                                Cacti settings.
 * @global array $thold_classes   Reserved/declared for parity with
 *                                other functions in this file; not used
 *                                directly here.
 * @global array $thold_states    Threshold state option list used by
 *                                the filter form.
 */
function tholds() {
	global $config, $device_actions, $item_rows, $thold_classes, $thold_states;

	$default_status = read_config_option('thold_filter_default');

	if (!is_numeric($default_status)) {
		set_config_option('thold_filter_default', '-1');
		$default_status = '-1';
	}

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
		],
		'rfilter' => [
			'filter'  => FILTER_VALIDATE_IS_REGEX,
			'pageset' => true,
			'default' => ''
		],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name_cache',
			'options' => ['options' => 'sanitize_thold_sort_string']
		],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
		],
		'data_template_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'thold_template_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'host_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'site_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'state' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => $default_status
		]
	];

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

	// if the number of rows is -1, set it to the default
	if (get_request_var('rows') == -1) {
		$rows = intval(read_config_option('num_rows_table'));
	} else {
		$rows = intval(get_request_var('rows'));
	}

	html_start_box(__('Threshold Status', 'thold'), '100%', false, '3', 'center', '');
	form_thold_filter();
	html_end_box();

	$sql_order   = get_order_string();
	$sql_limit   = ($rows * (intval(get_request_var('page')) - 1)) . ',' . $rows;
	$sql_order   = str_replace('ORDER BY ', '', $sql_order);

	if (get_request_var('sort_column') == 'severity') {
		$sql_order = thold_severity_sql() . ' ' . (get_request_var('sort_direction') == 'DESC' ? 'DESC' : 'ASC');
	}

	$sql_where   = '(h.status = 3';
	$statefilter = thold_get_state_filter(get_request_var('state'));

	if (get_request_var('rfilter') != '') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'td.name_cache ' . thold_rlike_clause(get_request_var('rfilter'));
	}

	if (get_request_var('data_template_id') != '-1') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND') . ' td.data_template_id = ' . get_request_var('data_template_id');
	}

	if (!isempty_request_var('thold_template_id')) {
		if (get_request_var('thold_template_id') > 0) {
			$sql_where .= ($sql_where == '' ? '(' : ' AND ') . '(td.thold_template_id = ' . get_request_var('thold_template_id') . ' AND td.template_enabled = "on")';
		} elseif (get_request_var('thold_template_id') == '-2') {
			$sql_where .= ($sql_where == '' ? '(' : ' AND ') . '(td.template_enabled != "on")';
		}
	}

	if (get_request_var('host_id') != '-1') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND') . ' td.host_id = ' . get_request_var('host_id');
	}

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

	if (get_request_var('site_id') == '-1') {
		// Show all items
	} elseif (get_request_var('site_id') == '0') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.site_id IS NULL';
	} elseif (!isempty_request_var('site_id')) {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.site_id = ' . get_request_var('site_id');
	}

	if ($sql_where != '') {
		$sql_where .= ')';
	}

	$tholds = get_allowed_thresholds($sql_where, $sql_order, $sql_limit, $total_rows);

	$nav = html_nav_bar('thold_graph.php?action=thold', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 13, 'Thresholds', 'page', 'main');

	print $nav;

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

	$display_text = [
		'nosort' => [
			'display' => __('Actions', 'thold'),
			'sort'    => '',
			'align'   => 'left'
		],
		'name_cache' => [
			'display' => __('Name', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'severity' => [
			'display' => __('Status', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left',
			'tip'     => __('The current threshold status. Click a status pill to filter the list to that status.', 'thold')
		],
		'external_id' => [
			'display' => __('External ID', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'nosort99' => [
			'display' => __('Enabled', 'thold'),
			'align'   => 'right'
		],
		'id' => [
			'display' => __('ID', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'nosort6' => [
			'display' => __('Ack Detail', 'thold'),
			'align'   => 'center'
		],
		'thold_type' => [
			'display' => __('Type', 'thold'),
			'sort'    => 'ASC',
			'tip'     => __('The Threshold Type.  For Baseline Types: [TIP] refers to the Time In the Past with MIN, MAX, AVG, and LAST from no more than a day in time from that period.  [AOT] refers to the Average over the entire Time period.  If there is a colon followed by MIN, MAX, AVG, LAST, the Value came from that Consolidation Function.', 'thold'),
			'align'   => 'right'
		],
		'flastread' => [
			'display' => __('Current', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right',
			'tip'     => __('The last measured value for the Data Source', 'thold')
		],
		'nosort4' => [
			'display' => __('High', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right',
			'tip'     => __('The High Warning / Alert values.  NOTE: Baseline values are a percent, all other values are display values that may be modified by a cdef.', 'thold')
		],
		'nosort5' => [
			'display' => __('Low', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right',
			'tip'     => __('The Low Warning / Alert values.  NOTE: Baseline values are a percent, all other values are display values that may be modified by a cdef.', 'thold')
		],
		'nosort2' => [
			'display' => __('Trigger', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'nosort3' => [
			'display' => __('Duration', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'repeat_alert' => [
			'display' => __('Repeat', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'thold_alert' => [
			'display' => __('Triggered', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'instate' => [
			'display' => __('In State', 'thold'),
			'sort'    => 'DESC',
			'align'   => 'right',
			'tip'     => __('The amount of time that has passed since the Threshold either Breached or was Triggered', 'thold')
		],
		'acknowledgment' => [
			'display' => __('Ack Required', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right',
			'tip'     => __('Acknowledgment required for this Threshold', 'thold')
		]
	];

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'thold_graph.php?action=thold');

	$c = 0;

	if (cacti_sizeof($tholds)) {
		foreach ($tholds as $thold_data) {
			$step = db_fetch_cell_prepared('SELECT rrd_step
				FROM data_template_data
				WHERE local_data_id = ?',
				[$thold_data['local_data_id']]);

			include($config['base_path'] . '/plugins/thold/includes/arrays.php');

			$c++;
			$alertstat = __('No', 'thold');
			$bgcolor   = 'green';

			$severity = get_thold_severity($thold_data);

			switch($severity) {
				case THOLD_SEVERITY_DISABLED:
					$bgcolor = 'grey';

					break;
				case THOLD_SEVERITY_NORMAL:
					$bgcolor = 'green';

					break;
				case THOLD_SEVERITY_ALERT:
					$bgcolor = 'red';

					break;
				case THOLD_SEVERITY_WARNING:
					$bgcolor = 'warning';

					break;
				case THOLD_SEVERITY_BASELINE:
					$bgcolor = 'orange';

					break;
				case THOLD_SEVERITY_NOTICE:
					$bgcolor = 'yellow';

					break;
				case THOLD_SEVERITY_ACKREQ:
					$bgcolor = 'purple';

					break;
			}

			if ($thold_data['thold_type'] == 0) {
				if ($thold_data['thold_alert'] != 0) {
					$alertstat = __('Yes', 'thold');
				}
			} elseif ($thold_data['thold_type'] == 2) {
				if ($thold_data['thold_alert'] != 0) {
					$alertstat = __('Yes', 'thold');
				}
			} else {
				if ($thold_data['bl_alert'] == 1) {
					$alertstat = __('baseline-LOW', 'thold');
				} elseif ($thold_data['bl_alert'] == 2) {
					$alertstat = __('baseline-HIGH', 'thold');
				}
			}

			print "<tr class='tableRow selectable' id='line" . $thold_data['id'] . "'>";

			$baseu = db_fetch_cell_prepared('SELECT base_value
				FROM graph_templates_graph
				WHERE local_graph_id = ?',
				[$thold_data['local_graph_id']]);

			if ($thold_data['data_type'] == 2) {
				$suffix = false;
			} else {
				$suffix = true;
			}

			$show_units   = ($thold_data['show_units'] ? true : false);
			$units_suffix = $thold_data['units_suffix'];
			$decimals     = $thold_data['decimals'];

			if (empty($baseu)) {
				cacti_log('WARNING: Graph Template for local_graph_id ' . $thold_data['local_graph_id'] . ' has been removed!');
				$baseu = 1024;
			}

			// Check is the graph item has a cdef and modify the output
			thold_modify_values_by_cdef($thold_data);

			$actions_url = '';

			if (api_user_realm_auth('thold.php')) {
				$actions_url .= '<a class="pic" href="' . html_escape($config['url_path'] . 'plugins/thold/thold.php?action=edit&id=' . $thold_data['id']) . '" title="' . __esc('Edit Threshold', 'thold') . '"><i class="tholdGlyphEdit fas fa-wrench"></i></a>';
			}

			if (api_user_realm_auth('thold.php')) {
				if ($thold_data['thold_per_enabled'] == 'on') {
					$actions_url .= '<a class="pic" href="' . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=disable&id=' . $thold_data['id']) . '" title="' . __esc('Disable Threshold', 'thold') . '"><i class="tholdGlyphDisable fas fa-stop-circle"></i></a>';
				} elseif ((($thold_data['template_enabled'] == 'on' && $thold_data['thold_enabled'] == 'on') || $thold_data['template_enabled'] != 'on') &&
					$thold_data['thold_per_enabled'] == '') {
					$actions_url .= '<a class="pic" href="' . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=enable&id=' . $thold_data['id']) . '" title="' . __esc('Enable Threshold', 'thold') . '"><i class="tholdGlyphEnable fas fa-play-circle"></i></a>';
				} else {
					$actions_url .= '<a class="pic" href="#" title="' . __esc('To enable the Threshold, enable the Template first', 'thold') . '"><i class="deviceDisabled fas fa-play-circle"></i></a>';
				}
			}

			thold_get_cached_name($thold_data);

			$actions_url .= "<a href='" . html_escape($config['url_path'] . 'graph.php?local_graph_id=' . $thold_data['local_graph_id'] . '&rra_id=all') . "' title='" . __esc('View Graph', 'thold') . "'><i class='tholdGlyphChart fas fa-chart-area'></i></a>";

			$actions_url .= "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=log&reset=1&threshold_id=' . $thold_data['id'] . '&host_id=' . $thold_data['host_id'] . '&status=-1') . "' title='" . __esc('View Threshold History', 'thold') . "'><i class='tholdGlyphLog fas fa-exclamation-triangle'></i></a>";

			if (api_user_realm_auth('thold.php')) {
				if ($thold_data['acknowledgment'] == 'on') {
					$actions_url .= "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=ack&threshold_id=' . $thold_data['id']) . "' title='" . __esc('Acknowledge Threshold', 'thold') . "'><i class='tholdGlyphAcknowledge fas fa-clipboard-check'></i></a>";

					if ($thold_data['reset_ack'] == 'on') {
						$actions_url .= "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=reset_ack&threshold_id=' . $thold_data['id']) . "' title='" . __esc('Suspend Notifications until the Threshold clears', 'thold') . "'><i class='tholdGlyphAcknowledgeSuspend fas fa-clipboard-check'></i></a>";
					}
				} elseif ($thold_data['thold_alert'] > 0 && $thold_data['reset_ack'] == 'on') {
					$actions_url .= "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/thold/thold_graph.php?action=resume_ack&threshold_id=' . $thold_data['id']) . "' title='" . __esc('Resume Notifications for this breached Threshold', 'thold') . "'><i class='tholdGlyphAcknowledgeResume fas fa-clipboard-check'></i></a>";
				}
			}

			$data = [
				'thold_data'  => $thold_data,
				'actions_url' => $actions_url
			];

			$data = api_plugin_hook_function('thold_graph_actions_url', $data);

			if (isset($data['actions_url'])) {
				$actions_url = $data['actions_url'];
			}

			if ($thold_data['reset_ack'] == 'on' || $thold_data['persist_ack'] == 'on') {
				$acks = db_fetch_assoc_prepared('SELECT *
					FROM plugin_thold_log
					WHERE type = 99
					AND threshold_id = ?
					LIMIT 5',
					[$thold_data['id']]);

				if (cacti_sizeof($acks)) {
					$table = '<table class="cactiTable">
						<tr class="tableHeader">
							<th>' . __('Acknowledgement Message', 'thold') . '</th>
							<th>' . __('Date', 'thold') . '</th>
						</tr>';

					foreach ($acks as $a) {
						$parts = explode('Additional Comments:', $a['description']);

						if (isset($parts[1])) {
							$comment = trim($parts[1], '" ');
						} else {
							$comment = __('Comment Not Found', 'thold');
						}

						$table .= '<tr>
							<td>' . $comment . '</td>
							<td>' . date('Y-m-d H:i:s', $a['time']) . '</td>
						</tr>';
					}

					$details = '<a class="ackMessage" href="#" data-ack="' . base64_encode($table) . '">' . __('Ack History', 'thold') . '</a>';
				} else {
					$details = '';
				}
			} else {
				$details = '';
			}

			form_selectable_cell($actions_url, $thold_data['id'], '', 'left');

			form_selectable_cell($thold_data['name_cache'] != '' ? filter_value($thold_data['name_cache'], get_request_var('rfilter')) : __('No name set', 'thold'), $thold_data['id'], '', 'left');

			form_selectable_cell("<span class='thold-pill " . $thold_states[$bgcolor]['class'] . "' data-state='" . ['red' => 101, 'orange' => 102, 'warning' => 103, 'yellow' => 104, 'green' => 105, 'purple' => 106, 'grey' => 107][$bgcolor] . "' tabindex='0' role='button'>" . html_escape($thold_states[$bgcolor]['display']) . '</span>', $thold_data['id'], '', 'left');
			form_selectable_cell($thold_data['external_id'], $thold_data['id'], '', 'left');

			if ((($thold_data['template_enabled'] == 'on' && $thold_data['thold_enabled'] == 'on') || $thold_data['template_enabled'] != 'on') && $thold_data['thold_per_enabled'] == 'on') {
				$enabled = __('Yes', 'thold');
			} elseif ($thold_data['template_enabled'] == 'on' && $thold_data['thold_enabled'] == 'off' && $thold_data['thold_per_enabled'] == '') {
				$enabled = __('No [Template:Thold]', 'thold');
			} elseif ($thold_data['template_enabled'] == 'on' && $thold_data['thold_enabled'] == 'off') {
				$enabled = __('No [Template]', 'thold');
			} else {
				$enabled = __('No [Thold]', 'thold');
			}

			form_selectable_cell($enabled, $thold_data['id'], '', 'right');

			form_selectable_cell($thold_data['id'], $thold_data['id'], '', 'right');

			form_selectable_cell($details, $thold_data['id'], '', 'center');

			if ($thold_data['thold_type'] != 1) {
				form_selectable_cell($thold_types[$thold_data['thold_type']], $thold_data['id'], '', 'right');
			} else {
				$bl_type = get_bl_type($thold_data['bl_type'], $thold_data['bl_cf']);
				form_selectable_cell($bl_type, $thold_data['id'], '', 'right');
			}

			form_selectable_cell(thold_format_number($thold_data['lastread'], $decimals, $baseu, $suffix, $show_units, $units_suffix), $thold_data['id'], '', 'right');

			switch($thold_data['thold_type']) {
				case 0:
					form_selectable_cell(thold_format_number($thold_data['thold_warning_hi'], $decimals, $baseu, $suffix, $show_units, $units_suffix) . ' / ' . thold_format_number($thold_data['thold_hi'], $decimals, $baseu, $suffix, $show_units, $units_suffix), $thold_data['id'], '', 'right');
					form_selectable_cell(thold_format_number($thold_data['thold_warning_low'], $decimals, $baseu, $suffix, $show_units, $units_suffix) . ' / ' . thold_format_number($thold_data['thold_low'], $decimals, $baseu, $suffix, $show_units, $units_suffix), $thold_data['id'], '', 'right');
					form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['thold_fail_trigger'], 'alert') . '</i>', $thold_data['id'], '', 'right');
					form_selectable_cell(__('N/A', 'thold'),  $thold_data['id'], '', 'right');

					break;
				case 1:
					$hi      = thold_format_number($thold_data['thold_hi'], $decimals, $baseu, $suffix, $show_units, $units_suffix);
					$hi_var  = thold_format_number($thold_data['bl_pct_up'], $decimals, $baseu, $suffix, $show_units, $units_suffix);
					$low     = thold_format_number($thold_data['thold_low'], $decimals, $baseu, $suffix, $show_units, $units_suffix);
					$low_var = thold_format_number($thold_data['bl_pct_down'], $decimals, $baseu, $suffix, $show_units, $units_suffix);

					if ($thold_data['bl_type'] == 0 || $thold_data['bl_type'] == 2) {
						$suffix = ' %';
					} else {
						$suffix = '';
					}

					form_selectable_cell($hi != '' ? $hi . ' [ ' . $hi_var . " $suffix ]" : '-', $thold_data['id'], '', 'right');
					form_selectable_cell($low != '' ? $low . ' [ ' . $low_var . " $suffix ]" : '-', $thold_data['id'], '', 'right');

					form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['bl_fail_trigger'], 'alert') . '</i>', $thold_data['id'], '', 'right');
					form_selectable_cell($timearray[$thold_data['bl_ref_time_range'] / $thold_data['rrd_step']], $thold_data['id'], '', 'right');

					break;
				case 2:
					form_selectable_cell(thold_format_number($thold_data['time_warning_hi'], $decimals, $baseu, $suffix, $show_units, $units_suffix) . ' / ' . thold_format_number($thold_data['time_hi'], $decimals, $baseu, $suffix, $show_units, $units_suffix), $thold_data['id'], '', 'right');
					form_selectable_cell(thold_format_number($thold_data['time_warning_low'], $decimals, $baseu, $suffix, $show_units, $units_suffix) . ' / ' . thold_format_number($thold_data['time_low'], $decimals, $baseu, $suffix, $show_units, $units_suffix), $thold_data['id'], '', 'right');
					form_selectable_cell('<i>' . __('%d Triggers', $thold_data['time_fail_trigger'], 'thold') . '</i>',  $thold_data['id'], '', 'right');
					form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['time_fail_length'], 'time') . '</i>', $thold_data['id'], '', 'right');

					break;
				default:
					form_selectable_cell('- / -',  $thold_data['id'], '', 'right');
					form_selectable_cell('- / -',  $thold_data['id'], '', 'right');
					form_selectable_cell(__('N/A', 'thold'),  $thold_data['id'], '', 'right');
					form_selectable_cell(__('N/A', 'thold'),  $thold_data['id'], '', 'right');
			}

			form_selectable_cell(($thold_data['repeat_alert'] == '' ? '' : plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['repeat_alert'], 'repeat')), $thold_data['id'], '', 'right');

			form_selectable_cell($alertstat, $thold_data['id'], '', 'right');

			// The time since this threshold was triggered
			form_selectable_cell('<i>' . get_time_since_last_event($thold_data) . '</i>',  $thold_data['id'], '', 'right');

			form_selectable_cell(($thold_data['acknowledgment'] == '' ? __('No', 'thold') : __('Yes', 'thold')), $thold_data['id'], '', 'right ' . ($thold_data['acknowledgment'] == '' ? '' : 'tholdAckCol'));

			form_end_row();
		}
	} else {
		print '<tr class="tableRow"><td class="center" colspan="' . cacti_sizeof($display_text) . '">' . __('No Thresholds', 'thold') . '</td></tr>';
	}

	html_end_box(false);

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

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

	thold_legend();

	print '</div>';

	// thold_display_rusage();
}

/**
 * Builds a clickable status "pill" for a device-status-list row, using a
 * CSS class derived from the host's disabled flag, current status, and
 * (when a per-host failure-count override is set) whether its
 * consecutive down-event count has reached that threshold. The pill's
 * data-state maps to the Device Status filter so clicking it filters the
 * list to that status.
 *
 * @param array &$host The host record to build the status pill for.
 *
 * @return string The status pill markup.
 *
 * @global array $thold_host_states Map of status/state key => display
 *                                 info (including 'class') used to pick
 *                                 the pill's colour class.
 */
function thold_device_status_pill(&$host) {
	global $thold_host_states;

	$status = $host['status'];

	if ($host['disabled']) {
		$key = 'disabled';
	} elseif ($host['thold_failure_count'] > 0 && $status != HOST_RECOVERING && $host['status_event_count'] >= $host['thold_failure_count']) {
		$key = HOST_DOWN;
	} elseif (isset($thold_host_states[$status])) {
		$key = $status;
	} else {
		$key = HOST_UNKNOWN;
	}

	// Each state maps to its matching Device Status filter (host_status) value.
	$state_map = [
		HOST_DOWN       => '1',
		HOST_RECOVERING => '2',
		HOST_UP         => '3',
		HOST_UNKNOWN    => '0',
		HOST_ERROR      => '4',
		'disabled'      => '-2'
	];

	$state = isset($state_map[$key]) ? $state_map[$key] : '-1';

	return "<span class='thold-pill " . $thold_host_states[$key]['class'] . "' data-state='" . $state . "' tabindex='0' role='button'>" . html_escape(get_uncolored_device_status($host)) . '</span>';
}

/**
 * Determines a human-readable status label for a host (Disabled, Down,
 * Recovering, Up, Error, or Unknown), applying the same per-host
 * failure-count override logic as thold_device_status_pill() but
 * without any HTML/color output.
 *
 * @param array &$host The host record to determine the status label
 *                     for.
 *
 * @return string The human-readable, translated status label.
 */
function get_uncolored_device_status(&$host) {
	$disabled = $host['disabled'];
	$status   = $host['status'];

	if ($disabled) {
		return __('Disabled', 'thold');
	} else {
		if ($host['thold_failure_count'] > 0 && $host['status'] != HOST_RECOVERING) {
			if ($host['status_event_count'] >= $host['thold_failure_count']) {
				return __('Down', 'thold');
			}
		}

		switch ($status) {
			case HOST_DOWN:
				return __('Down', 'thold');

				break;
			case HOST_RECOVERING:
				return __('Recovering', 'thold');

				break;
			case HOST_UP:
				return __('Up', 'thold');

				break;
			case HOST_ERROR:
				return __('Error', 'thold');

				break;
			default:
				return __('Unknown', 'thold');

				break;
		}
	}
}

/**
 * Renders the device status list view: validates/stores this view's
 * filter request variables, displays the host filter form, then
 * displays a filtered, sorted, paginated table of hosts with their
 * current up/down/recovering status. Called from this script's main
 * request-dispatch switch when action=hoststat.
 *
 * @return void
 *
 * @global array $config          Cacti global configuration array.
 * @global array $device_actions  Map of drp_action value => action
 *                                label, used for the bulk-actions
 *                                dropdown.
 * @global array $item_rows       Default number of rows per page from
 *                                Cacti settings.
 */
function hosts() {
	global $config, $device_actions, $item_rows;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'rfilter' => [
			'filter'  => FILTER_VALIDATE_IS_REGEX,
			'pageset' => true,
			'default' => ''
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'description',
			'options' => ['options' => 'sanitize_thold_sort_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			],
		'site_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'host_template_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'host_status' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-4'
			]
	];

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

	// if the number of rows is -1, set it to the default
	if (get_request_var('rows') == -1) {
		$rows = read_config_option('num_rows_table');
	} else {
		$rows = get_request_var('rows');
	}

	html_start_box(__('Device Status', 'thold'), '100%', false, '3', 'center', '');
	form_host_filter();
	html_end_box();

	// form the 'where' clause for our main sql query
	$sql_where = '';

	if (get_request_var('rfilter') != '') {
		$sql_where .= " (h.deleted = ''
			AND (h.hostname " . thold_rlike_clause(get_request_var('rfilter')) . '
			OR h.description ' . thold_rlike_clause(get_request_var('rfilter')) . ')';
	}

	if (get_request_var('host_status') == '-1') {
		// Show all items
	} elseif (get_request_var('host_status') == '-2') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . "h.disabled = 'on'";
	} elseif (get_request_var('host_status') == '-3') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . "h.disabled = ''";
	} elseif (get_request_var('host_status') == '-4') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . "(h.status != '3' OR h.disabled = 'on')";
	} elseif (get_request_var('host_status') == '-5') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . '(h.availability_method = 0)';
	} else {
		// Match the exact state-classification rules used by thold_device_status_pill():
		// a per-host failure-count override (status_event_count >= thold_failure_count, excluding
		// Recovering) reclassifies the device as Down, so the Down filter includes those hosts and
		// the Up/Unknown/Error filters exclude them.
		$override_down = 'h.thold_failure_count > 0 AND h.status != ' . HOST_RECOVERING . ' AND h.status_event_count >= h.thold_failure_count';

		if (get_request_var('host_status') == HOST_DOWN) {
			$status_clause = '(h.status = ' . HOST_DOWN . " OR ($override_down))";
		} elseif (get_request_var('host_status') == HOST_RECOVERING) {
			$status_clause = 'h.status = ' . HOST_RECOVERING;
		} else {
			$status_clause = 'h.status = ' . get_request_var('host_status') . " AND NOT ($override_down)";
		}

		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . "(h.availability_method != 0 AND h.disabled = '' AND $status_clause)";
	}

	if (get_request_var('host_template_id') == '-1') {
		// Show all items
	} elseif (get_request_var('host_template_id') == '0') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.host_template_id = 0';
	} elseif (!isempty_request_var('host_template_id')) {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.host_template_id = ' . get_request_var('host_template_id');
	}

	if (get_request_var('site_id') == '-1') {
		// Show all items
	} elseif (get_request_var('site_id') == '0') {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.site_id = 0';
	} elseif (!isempty_request_var('site_id')) {
		$sql_where .= ($sql_where == '' ? '(' : ' AND ') . 'h.site_id = ' . get_request_var('site_id');
	}

	$sql_where .= ($sql_where != '' ? ')' : '');

	$sql_order = get_order_string();
	$sql_limit = ($rows * (intval(get_request_var('page')) - 1)) . ',' . $rows;
	$sql_order = str_replace('ORDER BY ', '', $sql_order);

	$hosts = thold_get_allowed_devices($sql_where, $sql_order, $sql_limit, $total_rows);

	$nav = html_nav_bar('thold_graph.php?action=hoststat', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 12, __('Devices', 'thold'), 'page', 'main');

	print $nav;

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

	$display_text = [
		'nosort' => [
			'display' => __('Actions', 'thold'),
			'align'   => 'left',
			'sort'    => '',
			'tip'     => __('Hover over icons for help', 'thold')
		],
		'description' => [
			'display' => __('Description', 'thold'),
			'align'   => 'left',
			'sort'    => 'ASC',
			'tip'     => __('A description for the Device', 'thold')
		],
		'id' => [
			'display' => __('ID', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('A Cacti unique identifier for the Device', 'thold')
		],
		'graphs' => [
			'display' => __('Graphs', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The number of Graphs for this Device', 'thold')
		],
		'data_sources' => [
			'display' => __('Data Sources', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The number of Data Sources for this Device', 'thold')
		],
		'status' => [
			'display' => __('Status', 'thold'),
			'align'   => 'center',
			'sort'    => 'ASC',
			'tip'     => __('The status for this Device as of the last time it was polled', 'thold')
		],
		'instate' => [
			'display' => __('In State', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The last time Cacti found an issue with this Device.  It can be higher than the Uptime for the Device, if it was rebooted between Cacti polling cycles', 'thold')
		],
		'snmp_sysUpTimeInstance' => [
			'display' => __('Uptime', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The official uptime of the Device as reported by SNMP', 'thold')
		],
		'hostname' => [
			'display' => __('Hostname', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The official hostname for this Device', 'thold')
		],
		'cur_time' => [
			'display' => __('Current (ms)', 'thold'),
			'align'   => 'right',
			'sort'    => 'DESC',
			'tip'     => __('The current response time for the Cacti Availability check', 'thold')
		],
		'avg_time' => [
			'display' => __('Average (ms)', 'thold'),
			'align'   => 'right',
			'sort'    => 'DESC',
			'tip'     => __('The average response time for the Cacti Availability check', 'thold')
		],
		'availability' => [
			'display' => __('Availability', 'thold'),
			'align'   => 'right',
			'sort'    => 'ASC',
			'tip'     => __('The overall Availability of this Device since the last counter reset in Cacti', 'thold')
		]
	];

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'thold_graph.php?action=hoststat');

	if (cacti_sizeof($hosts)) {
		foreach ($hosts as $host) {
			if ($host['disabled'] == '' &&
				($host['status'] == HOST_RECOVERING || $host['status'] == HOST_UP) &&
				($host['availability_method'] != AVAIL_NONE && $host['availability_method'] != AVAIL_PING)) {
				$snmp_uptime = $host['snmp_sysUpTimeInstance'];
				$days        = intval($snmp_uptime / (60 * 60 * 24 * 100));
				$remainder   = $snmp_uptime % (60 * 60 * 24 * 100);
				$hours       = intval($remainder / (60 * 60 * 100));
				$remainder   = $remainder % (60 * 60 * 100);
				$minutes     = intval($remainder / (60 * 100));
				$uptime      = $days . 'd:' . substr('00' . $hours, -2) . 'h:' . substr('00' . $minutes, -2) . 'm';
			} else {
				$uptime    = __('N/A', 'thold');
			}

			if ($host['availability_method'] != 0) {
				print "<tr class='tableRow selectable' id='line" . $host['id'] . "'>";

				$actions_url = '';

				if (api_user_realm_auth('host.php')) {
					$actions_url .= '<a href="' . html_escape($config['url_path'] . 'host.php?action=edit&id=' . $host['id']) . '" title="' . __esc('Edit Device', 'thold') . '"><i class="tholdGlyphEdit fas fa-wrench"></i></a>';
				}
				$actions_url .= "<a href='" . html_escape($config['url_path'] . 'graph_view.php?action=preview&reset=true&host_id=' . $host['id']) . "' title='" . __esc('View Graphs', 'thold') . "'><i class='tholdGlyphChart fas fa-chart-area'></i></a>";

				form_selectable_cell($actions_url, $host['id'], '', 'left');

				form_selectable_cell(filter_value($host['description'], get_request_var('rfilter')), $host['id'], '', 'left');

				form_selectable_cell(number_format_i18n($host['id'], -1), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n($host['graphs'], -1), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n($host['data_sources'], -1), $host['id'], '', 'right');

				form_selectable_cell(thold_device_status_pill($host), $host['id'], '', 'center');

				form_selectable_cell(get_timeinstate($host), $host['id'], '', 'right');
				form_selectable_cell($uptime, $host['id'], '', 'right');
				form_selectable_cell(filter_value($host['hostname'], get_request_var('rfilter')), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n(($host['cur_time']), 2), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n(($host['avg_time']), 2), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n($host['availability'], 2), $host['id'], '', 'right');
			} else {
				print "<tr class='tableRow selectable' id='line" . $host['id'] . "'>";

				$actions_url = '';

				if (api_user_realm_auth('host.php')) {
					$actions_url .= '<a href="' . html_escape($config['url_path'] . 'host.php?action=edit&id=' . $host['id']) . '" title="' . __esc('Edit Device', 'thold') . '"><i class="tholdGlyphEdit fas fa-wrench"></i></a>';
				}
				$actions_url .= "<a href='" . html_escape($config['url_path'] . 'graph_view.php?action=preview&reset=true&host_id=' . $host['id']) . "' title='" . __esc('View Graphs', 'thold') . "'><i class='tholdGlyphChart fas fa-chart-area'></i></a>";

				form_selectable_cell($actions_url, $host['id'], '', 'left');

				form_selectable_cell(filter_value($host['description'], get_request_var('rfilter')), $host['id'], '', 'left');

				form_selectable_cell(number_format_i18n($host['id'], -1), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n($host['graphs'], -1), $host['id'], '', 'right');
				form_selectable_cell(number_format_i18n($host['data_sources'], -1), $host['id'], '', 'right');

				form_selectable_cell("<span class='thold-pill deviceNotMonFull' data-state='-5' tabindex='0' role='button'>" . __esc('Not Monitored', 'thold') . '</span>', $host['id'], '', 'center');

				form_selectable_cell(__('N/A', 'thold'), $host['id'], '', 'right');
				form_selectable_cell($uptime, $host['id'], '', 'right');
				form_selectable_cell(filter_value($host['hostname'], get_request_var('rfilter')), $host['id'], '', 'right');
				form_selectable_cell(__('N/A', 'thold'), $host['id'], '', 'right');
				form_selectable_cell(__('N/A', 'thold'), $host['id'], '', 'right');
				form_selectable_cell(__('N/A', 'thold'), $host['id'], '', 'right');
			}

			form_end_row();
		}
	} else {
		print '<tr class="tableRow"><td class="center" colspan="12">' . __('No Devices', 'thold') . '</td></tr>';
	}

	html_end_box(false);

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

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

	host_legend();

	print '</div>';

	// thold_display_rusage();
}

/**
 * Renders the search/site filter form controls for the device status
 * list view.
 *
 * @return void
 *
 * @global array $item_rows Rows-per-page option list used to populate
 *                         the rows dropdown.
 * @global array $config    Cacti global configuration array (declared
 *                         but not used directly here).
 */
function form_host_filter() {
	global $item_rows, $config;

	?>
	<tr class='even'>
		<td>
		<form id='form_devices' action='thold_graph.php?action=hoststat'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'thold'); ?>
					</td>
					<td>
						<input type='text' id='rfilter' size='30' value='<?php print html_escape_request_var('rfilter'); ?>'>
					</td>
					<td>
						<?php print __('Site', 'thold'); ?>
					</td>
					<td>
						<select id='site_id'>
							<option value='-1'<?php if (get_request_var('site_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('site_id') == '0') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
							$sites = db_fetch_assoc('SELECT id, name
								FROM sites
								ORDER BY name');

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

			if (get_request_var('site_id') == $site['id']) {
				print ' selected';
			} print '>' . html_escape($site['name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Status', 'thold'); ?>
					</td>
					<td>
						<select id='host_status'>
							<option value='-1'<?php if (get_request_var('host_status') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='-3'<?php if (get_request_var('host_status') == '-3') {?> selected<?php }?>><?php print __('Enabled', 'thold'); ?></option>
							<?php print(read_user_setting('hide_disabled') == '' ? "<option value='-2'" . (get_request_var('host_status') == '-2' ? ' selected' : '') . "'>" . __('Disabled', 'thold') . '</option>' : ''); ?>
							<option value='-4'<?php if (get_request_var('host_status') == '-4') {?> selected<?php }?>><?php print __('Not Up', 'thold'); ?></option>
							<option value='-5'<?php if (get_request_var('host_status') == '-5') {?> selected<?php }?>><?php print __('Not Monitored', 'thold'); ?></option>
							<option value='3'<?php if (get_request_var('host_status') == '3') {?> selected<?php }?>><?php print __('Up', 'thold'); ?></option>
							<option value='1'<?php if (get_request_var('host_status') == '1') {?> selected<?php }?>><?php print __('Down', 'thold'); ?></option>
							<option value='2'<?php if (get_request_var('host_status') == '2') {?> selected<?php }?>><?php print __('Recovering', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('host_status') == '0') {?> selected<?php }?>><?php print __('Unknown', 'thold'); ?></option>
							<option value='4'<?php if (get_request_var('host_status') == '4') {?> selected<?php }?>><?php print __('Error', 'thold'); ?></option>
						</select>
					</td>
					<td>
						<span>
							<input id='refresh' type='submit' value='<?php print __esc('Go', 'thold'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'thold'); ?>'>
						</span>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Type', 'thold'); ?>
					</td>
					<td>
						<select id='host_template_id'>
							<option value='-1'<?php if (get_request_var('host_template_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('host_template_id') == '0') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
	$host_templates = db_fetch_assoc('SELECT id, name
								FROM host_template
								ORDER BY name');

	if (cacti_sizeof($host_templates)) {
		foreach ($host_templates as $host_template) {
			print "<option value='" . $host_template['id'] . "'";

			if (get_request_var('host_template_id') == $host_template['id']) {
				print ' selected';
			} print '>' . html_escape($host_template['name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Devices', 'thold'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'thold'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('rows') == $key) {
				print ' selected';
			} print '>' . $value . '</option>';
		}
	}
	?>
						</select>
					</td>
				</tr>
			</table>
			<input type='hidden' name='page' value='<?php print html_escape(get_request_var('page')); ?>'>
			<input type='hidden' name='tab' value='hoststat'>
		</form>
		<script type='text/javascript' <?php print plugin_thold_csp_nonce(); ?>>

		function applyFilter() {
			strURL  = 'thold_graph.php?header=false&action=hoststat';
			strURL += '&host_status=' + encodeURIComponent($('#host_status').val());
			strURL += '&host_template_id=' + encodeURIComponent($('#host_template_id').val());
			strURL += '&site_id=' + encodeURIComponent($('#site_id').val());
			strURL += '&rows=' + encodeURIComponent($('#rows').val());
			strURL += '&rfilter=' + encodeURIComponent(base64_encode($('#rfilter').val()));
			loadPageNoHeader(strURL);
		}

		function clearFilter() {
			strURL  = 'thold_graph.php?header=false&action=hoststat&clear=1';
			loadPageNoHeader(strURL);
		}

		$(function() {
			$('#form_devices').submit(function(event) {
				event.preventDefault();
				applyFilter();
			});

			$('#site_id, #host_status, #host_template_id, #rows').change(function() {
				applyFilter();
			});

			$('.thold-pill').on('click keydown', function(e) {
				if (e.type === 'keydown' && e.which !== 13 && e.which !== 32) {
					return;
				}

				e.preventDefault();
				var state = $(this).attr('data-state');
				$('#host_status').val($('#host_status').val() === state ? '-1' : state);
				applyFilter();
			});

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

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

/**
 * Validates and stores this view's filter request variables (rows,
 * page, filter text, sort column/direction, threshold id, threshold
 * template id, host id, site id, status) into the session for the
 * threshold log list view.
 *
 * @return void
 */
function thold_validate_log_vars() {
	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
		],
		'rfilter' => [
			'filter'  => FILTER_VALIDATE_IS_REGEX,
			'pageset' => true,
			'default' => ''
		],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'time',
			'options' => ['options' => 'sanitize_thold_sort_string']
		],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'DESC',
			'options' => ['options' => 'sanitize_search_string']
		],
		'threshold_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'thold_template_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'host_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'site_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		],
		'status' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
		]
	];

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

/**
 * Exports the current filtered threshold log entries (up to 100000
 * rows) as a downloaded CSV file. Called from this script's main
 * request-dispatch switch when action=logexport.
 *
 * @return void
 */
function thold_export_log() {
	$sql_where = '';

	thold_validate_log_vars();

	if (get_request_var('host_id') == '-1') {
		// Show all items
	} elseif (get_request_var('host_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.id IS NULL';
	} elseif (!isempty_request_var('host_id')) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.host_id=' . get_request_var('host_id');
	}

	if (get_request_var('site_id') == '-1') {
		// Show all items
	} elseif (get_request_var('site_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.site_id IS NULL';
	} elseif (!isempty_request_var('site_id')) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.site_id=' . get_request_var('site_id');
	}

	if (get_request_var('threshold_id') == '-1') {
		// Show all items
	} elseif (get_request_var('threshold_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' td.id IS NULL';
	} elseif (get_request_var('threshold_id') > 0) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' td.id=' . get_request_var('threshold_id');
	}

	// thold template id filter
	if (!isempty_request_var('thold_template_id')) {
		if (get_request_var('thold_template_id') > 0) {
			$sql_where .= ($sql_where == '' ? '' : ' AND ') . '(td.thold_template_id = ' . get_request_var('thold_template_id') . ' AND td.template_enabled = "on")';
		} elseif (get_request_var('thold_template_id') == '-2') {
			$sql_where .= ($sql_where == '' ? '' : ' AND ') . '(td.template_enabled != "on")';
		}
	}

	if (get_request_var('status') != '-1') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.status=' . get_request_var('status');
	}

	if (get_request_var('rfilter') != '') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.description ' . thold_rlike_clause(get_request_var('rfilter'));
	}

	$sql_order  = '';
	$total_rows = 0;

	$logs = get_allowed_threshold_logs($sql_where, $sql_order, 100000, $total_rows);

	if (sizeof($logs)) {
		$columns = array_keys($logs[0]);
		header('Content-type: application/csv');
		header('Content-Disposition: attachment; filename=thold_log_export.csv');

		print implode(',', $columns) . PHP_EOL;

		foreach ($logs as $log) {
			print implode(',', array_values($log)) . PHP_EOL;
		}
	} else {
		raise_message('norows', __('No Export Rows Found.', 'thold'), MESSAGE_LEVEL_ERROR);
		header('Location: thold_graph.php?action=log');
		exit;
	}
}

/**
 * Renders the main threshold log list page: validates/stores this
 * view's filter request variables, displays the log filter form, then
 * displays a filtered, sorted, paginated table of threshold log
 * entries. Called from this script's main request-dispatch switch when
 * action=log.
 *
 * @return void
 *
 * @global array $config               Cacti global configuration
 *                                     array.
 * @global array $item_rows            Default number of rows per page
 *                                     from Cacti settings.
 * @global array $thold_log_states     Log status option list used by
 *                                     the filter form.
 * @global array $thold_status         Reserved/declared for parity with
 *                                     other functions in this file; not
 *                                     used directly here.
 * @global array $thold_types          Map of log entry type id => label,
 *                                     used to render each log row's
 *                                     type column ('Acknowledgment'
 *                                     added here for type 99).
 * @global int   $thold_log_retention  Reserved/declared for parity with
 *                                     other functions in this file; not
 *                                     used directly here.
 */
function thold_show_log() {
	global $config, $item_rows, $thold_log_states, $thold_status, $thold_types, $thold_log_retention;

	thold_validate_log_vars();

	// if the number of rows is -1, set it to the default
	if (get_request_var('rows') == -1) {
		$rows = read_config_option('num_rows_table');
	} else {
		$rows = get_request_var('rows');
	}

	$days = read_config_option('thold_log_storage');

	if (empty($days)) {
		set_config_option('thold_log_storage', '31');

		$days = 31;
	}

	$days = __('%d Days', $days, 'thold');

	html_start_box(__('Threshold Log for [ %s ]', $days, 'thold'), '100%', false, '3', 'center', '');
	form_thold_log_filter();
	html_end_box();

	$sql_where = '';

	if (get_request_var('host_id') == '-1') {
		// Show all items
	} elseif (get_request_var('host_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.id IS NULL';
	} elseif (!isempty_request_var('host_id')) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.host_id = ' . get_request_var('host_id');
	}

	if (get_request_var('site_id') == '-1') {
		// Show all items
	} elseif (get_request_var('site_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.site_id IS NULL';
	} elseif (!isempty_request_var('site_id')) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' h.site_id = ' . get_request_var('site_id');
	}

	if (get_request_var('threshold_id') == '-1') {
		// Show all items
	} elseif (get_request_var('threshold_id') == '0') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' td.id IS NULL';
	} elseif (get_request_var('threshold_id') > 0) {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' td.id = ' . get_request_var('threshold_id');
	}

	// thold template id filter
	if (!isempty_request_var('thold_template_id')) {
		if (get_request_var('thold_template_id') > 0) {
			$sql_where .= ($sql_where == '' ? '' : ' AND ') . '(td.thold_template_id = ' . get_request_var('thold_template_id') . ' AND td.template_enabled = "on")';
		} elseif (get_request_var('thold_template_id') == '-2') {
			$sql_where .= ($sql_where == '' ? '' : ' AND ') . '(td.template_enabled != "on")';
		}
	}

	if (get_request_var('status') != '-1') {
		if (get_request_var('status') == 2) {
			$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.status IN (2,8)';
		} else {
			$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.status = ' . get_request_var('status');
		}
	}

	if (get_request_var('rfilter') != '') {
		$sql_where .= ($sql_where == '' ? '' : ' AND') . ' tl.description ' . thold_rlike_clause(get_request_var('rfilter'));
	}

	$sql_order = get_order_string();
	$sql_limit = ($rows * (intval(get_request_var('page')) - 1)) . ',' . $rows;
	$sql_order = str_replace('ORDER BY ', '', $sql_order);

	$logs = get_allowed_threshold_logs($sql_where, $sql_order, $sql_limit, $total_rows);

	$nav = html_nav_bar('thold_graph.php?action=log', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 9, __('Log Entries', 'thold'), 'page', 'main');

	print $nav;

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

	$display_text = [
		'hdescription' => [
			'display' => __('Device', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'time' => [
			'display' => __('Time', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'type' => [
			'display' => __('Type', 'thold'),
			'sort'    => 'DESC',
			'align'   => 'left'
		],
		'status' => [
			'display' => __('Status', 'thold'),
			'sort'    => '',
			'align'   => 'left'
		],
		'description' => [
			'display' => __('Event Description', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'threshold_value' => [
			'display' => __('Alert Value', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'current' => [
			'display' => __('Measured Value', 'thold'),
			'sort'    => 'ASC',
			'align'   => 'right'
		]
	];

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'thold_graph.php?action=log');

	$thold_types[99] = __('Acknowledgment', 'thold');

	if (cacti_sizeof($logs)) {
		foreach ($logs as $l) {
			if ($l['status'] == 8) {
				$l['status'] = 2;
			}

			$baseu = db_fetch_cell_prepared('SELECT base_value
				FROM graph_templates_graph
				WHERE local_graph_id = ?',
				[$l['local_graph_id']]);

			$data_type = db_fetch_cell_prepared('SELECT data_type FROM thold_data WHERE id = ?', [$l['threshold_id']]);

			if ($data_type == 2) {
				$suffix = false;
			} else {
				$suffix = true;
			}

			$show_units   = (db_fetch_cell_prepared('SELECT show_units FROM thold_data WHERE id = ?', [$l['threshold_id']]) ? true : false);
			$units_suffix = db_fetch_cell_prepared('SELECT units_suffix FROM thold_data WHERE id = ?', [$l['threshold_id']]);
			$decimals     = db_fetch_cell_prepared('SELECT decimals FROM thold_data WHERE id = ?', [$l['threshold_id']]);

			if (empty($baseu)) {
				cacti_log('WARNING: Graph Template for local_graph_id ' . $l['local_graph_id'] . ' has been removed!');
				$baseu = 1024;
			}

			print "<tr class='tableRow selectable' id='line" . $l['id'] . "'>";

			form_selectable_cell($l['hdescription'], $l['id'], '', 'left');
			form_selectable_cell(date('Y-m-d H:i:s', $l['time']), $l['id'], '', 'left');
			form_selectable_cell($thold_types[$l['type']], $l['id'], '', 'left');
			form_selectable_cell("<span class='thold-pill " . $thold_log_states[$l['status']]['class'] . "' data-state='" . $l['status'] . "' tabindex='0' role='button'>" . html_escape($thold_log_states[$l['status']]['display_short']) . '</span>', $l['id'], '', 'left');
			form_selectable_cell((strlen($l['description']) ? filter_value($l['description'], get_request_var('rfilter')) : __('Restoral Event', 'thold')), $l['id'], '', 'left tholdLog');
			form_selectable_cell($l['threshold_value'] != '' ? thold_format_number($l['threshold_value'], $decimals, $baseu, $suffix, $show_units, $units_suffix) : __('N/A', 'thold'), $l['id'], '', 'right');
			form_selectable_cell($l['current'] != '' ? thold_format_number($l['current'], $decimals, $baseu, $suffix, $show_units, $units_suffix) : __('N/A', 'thold'), $l['id'], '', 'right');
			form_end_row();
		}
	} else {
		print '<tr class="tableRow"><td class="center" colspan="9">' . __('No Threshold Logs Found', 'thold') . '</td></tr>';
	}

	html_end_box(false);

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

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

	log_legend();

	print '</div>';
}

/**
 * Renders the search/site/status/host/template filter form controls for
 * the threshold log list view.
 *
 * @return void
 *
 * @global array $item_rows          Rows-per-page option list used to
 *                                   populate the rows dropdown.
 * @global array $thold_log_states   Log status option list used to
 *                                   populate the status dropdown.
 * @global array $config             Cacti global configuration array
 *                                   (declared but not used directly
 *                                   here).
 */
function form_thold_log_filter() {
	global $item_rows, $thold_log_states, $config;

	?>
	<tr class='even'>
		<td>
		<form id='form_log' action='thold_graph.php?action=log'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'thold'); ?>
					</td>
					<td>
						<input type='text' id='rfilter' size='30' value='<?php print html_escape_request_var('rfilter'); ?>'>
					</td>
					<td>
						<?php print __('Site', 'thold'); ?>
					</td>
					<td>
						<select id='site_id'>
							<option value='-1'<?php if (get_request_var('site_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='0'<?php if (get_request_var('site_id') == '0') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
							$sites = db_fetch_assoc('SELECT id, name
								FROM sites
								ORDER BY name');

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

			if (get_request_var('site_id') == $site['id']) {
				print ' selected';
			} print '>' . html_escape($site['name']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<?php print html_host_filter(get_request_var('host_id')); ?>
					<td>
						<span>
							<input id='refresh' type='submit' value='<?php print __esc('Go', 'thold'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'thold'); ?>'>
							<input id='export' type='button' value='<?php print __esc('Export', 'thold'); ?>'>
						</span>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Template', 'thold'); ?>
					</td>
					<td>
						<select id='thold_template_id'>
							<option value='-1'<?php if (get_request_var('thold_template_id') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<option value='-2'<?php if (get_request_var('thold_template_id') == '-2') {?> selected<?php }?>><?php print __('None', 'thold'); ?></option>
							<?php
	$thold_templates = db_fetch_assoc('SELECT DISTINCT tt.id, tt.name
								FROM thold_template as tt
								ORDER BY tt.name');

	foreach ($thold_templates as $row) {
		print "<option value='" . $row['id'] . "'" . (isset_request_var('thold_template_id') && $row['id'] == get_request_var('thold_template_id') ? ' selected' : '') . '>' . html_escape($row['name']) . '</option>';
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Threshold', 'thold'); ?>
					</td>
					<td>
						<select id='threshold_id'>
							<option value='-1'<?php if (get_request_var('threshold_id') == '-1') {?> selected<?php }?>><?php print __('All'); ?></option>
							<?php
	$tholds = db_fetch_assoc('SELECT DISTINCT td.id, td.name_cache
								FROM thold_data AS td
								INNER JOIN plugin_thold_log AS tl
								ON td.id = tl.threshold_id ' .
		(get_request_var('host_id') > 0 ? 'WHERE td.host_id=' . get_request_var('host_id') : '') .
		' ORDER by td.name_cache');

	if (cacti_sizeof($tholds)) {
		foreach ($tholds as $thold) {
			print "<option value='" . $thold['id'] . "'";

			if (get_request_var('threshold_id') == $thold['id']) {
				print ' selected';
			} print '>' . html_escape($thold['name_cache']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Status', 'thold'); ?>
					</td>
					<td>
						<select id='status'>
							<option value='-1'<?php if (get_request_var('status') == '-1') {?> selected<?php }?>><?php print __('All', 'thold'); ?></option>
							<?php
	if (cacti_sizeof($thold_log_states)) {
		foreach ($thold_log_states as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('status') == $key) {
				print ' selected';
			} print '>' . html_escape($value['display']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Entries', 'thold'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'thold'); ?></option>
							<?php
	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('rows') == $key) {
				print ' selected';
			} print '>' . $value . '</option>';
		}
	}
	?>
						</select>
					</td>
				</tr>
			</table>
			<input type='hidden' name='tab' value='log'>
		</form>
		<script type='text/javascript' <?php print plugin_thold_csp_nonce(); ?>>

		function applyFilter() {
			strURL  = 'thold_graph.php?header=false&action=log';
			strURL += '&status=' + encodeURIComponent($('#status').val());
			strURL += '&threshold_id=' + encodeURIComponent($('#threshold_id').val());
			strURL += '&thold_template_id=' + encodeURIComponent($('#thold_template_id').val());
			strURL += '&host_id=' + encodeURIComponent($('#host_id').val());
			strURL += '&site_id=' + encodeURIComponent($('#site_id').val());
			strURL += '&rows=' + encodeURIComponent($('#rows').val());
			strURL += '&rfilter=' + encodeURIComponent(base64_encode($('#rfilter').val()));
			loadPageNoHeader(strURL);
		}

		function clearFilter() {
			strURL  = 'thold_graph.php?header=false&action=log&clear=1';
			loadPageNoHeader(strURL);
		}

		function exportLog() {
			strURL  = 'thold_graph.php?action=exportlog';
			strURL += '&status=' + encodeURIComponent($('#status').val());
			strURL += '&threshold_id=' + encodeURIComponent($('#threshold_id').val());
			strURL += '&thold_template_id=' + encodeURIComponent($('#thold_template_id').val());
			strURL += '&host_id=' + encodeURIComponent($('#host_id').val());
			strURL += '&site_id=' + encodeURIComponent($('#site_id').val());
			strURL += '&rows=' + encodeURIComponent($('#rows').val());
			strURL += '&rfilter=' + encodeURIComponent(base64_encode($('#rfilter').val()));
			document.location = strURL;
			Pace.stop();
		}

		$(function() {
			$('#form_log').submit(function(event) {
				event.preventDefault();
				applyFilter();
			});

			$('#site_id, #thold_template_id, #threshold_id, #status, #rows').change(function() {
				applyFilter();
			});

			$('.thold-pill').on('click keydown', function(e) {
				if (e.type === 'keydown' && e.which !== 13 && e.which !== 32) {
					return;
				}

				e.preventDefault();
				var state = $(this).attr('data-state');
				$('#status').val($('#status').val() === state ? '-1' : state);
				applyFilter();
			});

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

			$('#export').click(function() {
				exportLog();
			});
		});

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