webseer.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('../../');
require_once('./include/auth.php');
require_once($config['base_path'] . '/plugins/webseer/includes/functions.php');

global $refresh;

set_default_action();

switch (get_request_var('action')) {
	case 'save':
		form_save();

		break;
	case 'actions':
		form_actions();

		break;
	case 'enable':
		$id = get_filter_request_var('id');

		if ($id > 0) {
			db_execute_prepared('UPDATE plugin_webseer_urls SET enabled = "on" WHERE id = ?', [$id]);
			plugin_webseer_enable_remote_hosts($id, true);
		}

		header('Location: webseer.php?header=false');
		exit;
	case 'disable':
		$id = get_filter_request_var('id');

		if ($id > 0) {
			db_execute_prepared('UPDATE plugin_webseer_urls SET enabled = "" WHERE id = ?', [$id]);
			plugin_webseer_enable_remote_hosts($id, false);
		}

		header('Location: webseer.php?header=false');
		exit;
	case 'purge':
		$id = get_filter_request_var('id');

		if ($id > 0) {
			purge_log_events($id);
		}

		header('Location: webseer.php?header=false');
		exit;
	case 'edit':
		top_header();
		webseer_edit_url();
		bottom_footer();

		break;
	case 'history':
		webseer_show_history();

		break;
	default:
		list_urls();

		break;
}

exit;

/**
 * Handles the bulk-actions form for the Service Checks list (delete/
 * enable/disable/duplicate). On first display, renders the confirmation
 * dialog listing the selected URLs; once confirmed, applies the chosen
 * action to each selected row. Invoked from this file's dispatcher when
 * the request's 'action' is 'actions'.
 *
 * @return void Either redirects back to this page after applying the
 *              action, or prints the confirmation dialog and returns
 *              nothing.
 *
 * @global array $webseer_actions_url Map of bulk-action ids to their
 *                                    display labels, used for the
 *                                    confirmation dialog title.
 */
function form_actions() {
	global $webseer_actions_url;

	// if we are to save this form, instead of display it
	if (isset_request_var('selected_items')) {
		$selected_items = sanitize_unserialize_selected_items(get_nfilter_request_var('selected_items'));
		$action         = get_nfilter_request_var('drp_action');

		if ($selected_items != false) {
			$urls = [];

			if (cacti_sizeof($selected_items)) {
				foreach ($selected_items as $url) {
					$urls[] = $url;
				}
			}

			if (cacti_sizeof($urls)) {
				if ($action == WEBSEER_ACTION_URL_DELETE) { // delete
					foreach ($urls as $id) {
						db_execute_prepared('DELETE FROM plugin_webseer_urls WHERE id = ?', [$id]);
						db_execute_prepared('DELETE FROM plugin_webseer_urls_log WHERE url_id = ?', [$id]);
						plugin_webseer_delete_remote_hosts($id);
					}
				} elseif ($action == WEBSEER_ACTION_URL_DISABLE) { // disable
					foreach ($urls as $id) {
						db_execute_prepared('UPDATE plugin_webseer_urls SET enabled = "" WHERE id = ?', [$id]);
						plugin_webseer_enable_remote_hosts($id, false);
					}
				} elseif ($action == WEBSEER_ACTION_URL_ENABLE) { // enable
					foreach ($urls as $id) {
						db_execute_prepared('UPDATE plugin_webseer_urls SET enabled = "on" WHERE id = ?', [$id]);
						plugin_webseer_enable_remote_hosts($id, true);
					}
				} elseif ($action == WEBSEER_ACTION_URL_DUPLICATE) { // duplicate
					foreach ($urls as $url) {
						$newid = 1;

						foreach ($urls as $id) {
							$save                    = db_fetch_row_prepared('SELECT * FROM plugin_webseer_urls WHERE id = ?', [$id]);
							$save                    = is_array($save) ? $save : [];
							$save['id']              = 0;
							$save['poller_id']       = 1;
							$save['display_name']    = 'New Service Check (' . $newid . ')';
							$save['lastcheck']       = '0000-00-00';
							$save['result']          = 0;
							$save['triggered']       = 0;
							$save['enabled']         = '';
							$save['failures']        = 0;
							$save['error']           = '';
							$save['http_code']       = 0;
							$save['total_time']      = 0;
							$save['namelookup_time'] = 0;
							$save['connect_time']    = 0;
							$save['redirect_time']   = 0;
							$save['speed_download']  = 0;
							$save['size_download']   = 0;
							$save['redirect_count']  = 0;
							$save['debug']           = '';

							$id = sql_save($save, 'plugin_webseer_urls');

							$newid++;
						}
					}
				}
			}
		}

		header('Location: webseer.php?header=false');

		exit;
	}

	// setup some variables
	$url_list  = '';
	$url_array = [];

	// loop through each of the graphs selected on the previous page and get more info about them
	foreach ($_POST as $var => $val) {
		if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) {
			// ================= input validation =================
			input_validate_input_number($matches[1]);
			// ====================================================

			$url_list .= '<li>' . html_escape(db_fetch_cell_prepared('SELECT display_name FROM plugin_webseer_urls WHERE id = ?', [$matches[1]])) . '</li>';
			$url_array[] = $matches[1];
		}
	}

	if (!array_key_exists((int) get_nfilter_request_var('drp_action'), $webseer_actions_url)) {
		header('Location: webseer.php');
		exit;
	}

	top_header();

	form_start('webseer.php');

	html_start_box($webseer_actions_url[(int) get_nfilter_request_var('drp_action')], '60%', false, 3, 'center', '');

	$action     = get_nfilter_request_var('drp_action');
	$save_html  = '';

	if (cacti_sizeof($url_array)) {
		if ($action == WEBSEER_ACTION_URL_DELETE) { // delete
			print "	<tr>
					<td class='topBoxAlt'>
						<p>" . __n('Click \'Continue\' to Delete the following URL.', 'Click \'Continue\' to Delete following URLs.', cacti_sizeof($url_array)) . "</p>
						<div class='itemlist'><ul>$url_list</ul></div>
					</td>
				</tr>\n";

			$save_html = "<input type='button' class='cactiReturnTo' value='" . __esc('Cancel') . "'>&nbsp;<input type='submit' value='" . __esc('Continue') . "' title='" . __esc_n('Delete URL', 'Delete URLs', cacti_sizeof($url_array)) . "'>";
		} elseif ($action == WEBSEER_ACTION_URL_DISABLE) {
			print "	<tr>
					<td class='topBoxAlt'>
						<p>" . __n('Click \'Continue\' to Disable the following URL.', 'Click \'Continue\' to Disable following URLs.', cacti_sizeof($url_array)) . "</p>
						<div class='itemlist'><ul>$url_list</ul></div>
					</td>
				</tr>\n";

			$save_html = "<input type='button' class='cactiReturnTo' value='" . __esc('Cancel') . "'>&nbsp;<input type='submit' value='" . __esc('Continue') . "' title='" . __esc_n('Disable URL', 'Disable URLs', cacti_sizeof($url_array)) . "'>";
		} elseif ($action == WEBSEER_ACTION_URL_ENABLE) {
			print "	<tr>
					<td class='topBoxAlt'>
						<p>" . __n('Click \'Continue\' to Enable the following URL.', 'Click \'Continue\' to Enable following URLs.', cacti_sizeof($url_array)) . "</p>
						<div class='itemlist'><ul>$url_list</ul></div>
					</td>
				</tr>\n";

			$save_html = "<input type='button' class='cactiReturnTo' value='" . __esc('Cancel') . "'>&nbsp;<input type='submit' value='" . __esc('Continue') . "' title='" . __esc_n('Enable URL', 'Enable URLs', cacti_sizeof($url_array)) . "'>";
		} elseif ($action == WEBSEER_ACTION_URL_DUPLICATE) {
			print "	<tr>
					<td class='topBoxAlt'>
						<p>" . __n('Click \'Continue\' to Duplicate the following URL.', 'Click \'Continue\' to Duplicate following URLs.', cacti_sizeof($url_array)) . "</p>
						<div class='itemlist'><ul>$url_list</ul></div>
					</td>
				</tr>\n";

			$save_html = "<input type='button' class='cactiReturnTo' value='" . __esc('Cancel') . "'>&nbsp;<input type='submit' value='" . __esc('Continue') . "' title='" . __esc_n('Duplicate URL', 'Duplicate URLs', cacti_sizeof($url_array)) . "'>";
		}
	} else {
		raise_message(40);
		header('Location: webseer.php');
		exit;
	}

	print "<tr>
		<td class='saveRow'>
			<input type='hidden' name='action' value='actions'>
			<input type='hidden' name='selected_items' value='" . serialize($url_array) . "'>
			<input type='hidden' name='drp_action' value='" . html_escape(get_nfilter_request_var('drp_action')) . "'>
			$save_html
		</td>
	</tr>\n";

	html_end_box();

	form_end();

	bottom_footer();
}

/**
 * Validates and saves a single service check URL configuration (target
 * URL/IP, search patterns, auth/cert options, proxy, notification
 * accounts/list, thresholds), registering or updating the corresponding
 * remote-poller host entries as needed. Invoked from this file's
 * dispatcher when the request's 'action' is 'save'.
 *
 * @return void Redirects back to the edit form for this URL; does not
 *              return a value.
 */
function form_save() {
	// ================= input validation =================
	get_filter_request_var('id');
	get_filter_request_var('poller_id');
	get_filter_request_var('downtrigger');
	get_filter_request_var('timeout_trigger');
	get_filter_request_var('compression');
	// ====================================================

	if (isset_request_var('id')) {
		$save['id'] = get_request_var('id');
	} else {
		$save['id'] = 0;
	}

	if (isset_request_var('poller_id')) {
		$save['poller_id'] = get_request_var('poller_id');
	} else {
		$save['poller_id'] = 1;
	}

	if (isset_request_var('enabled')) {
		$save['enabled'] = 'on';
	} else {
		$save['enabled'] = '';
	}

	if (isset_request_var('requiresauth')) {
		$save['requiresauth'] = 'on';
	} else {
		$save['requiresauth'] = '';
	}

	if (isset_request_var('checkcert')) {
		$save['checkcert'] = 'on';
	} else {
		$save['checkcert'] = '';
	}

	if (isset_request_var('notify_accounts')) {
		if (is_array(get_nfilter_request_var('notify_accounts'))) {
			foreach (get_nfilter_request_var('notify_accounts') as $na) {
				input_validate_input_number($na);
			}
			$save['notify_accounts'] = implode(',', get_nfilter_request_var('notify_accounts'));
		} else {
			set_request_var('notify_accounts', '');
		}
	} else {
		$save['notify_accounts'] = '';
	}

	$save['proxy_server']    = get_nfilter_request_var('proxy_server');
	$save['display_name']    = get_nfilter_request_var('display_name');
	$save['url']             = get_nfilter_request_var('url');
	$save['ip']              = get_nfilter_request_var('ip');
	$save['search']          = get_nfilter_request_var('search');
	$save['search_maint']    = get_nfilter_request_var('search_maint');
	$save['search_failed']   = get_nfilter_request_var('search_failed');
	$save['compression']     = get_nfilter_request_var('compression');
	$save['notify_list']     = get_nfilter_request_var('notify_list');
	$save['notify_extra']    = get_nfilter_request_var('notify_extra');
	$save['downtrigger']     = get_filter_request_var('downtrigger');
	$save['timeout_trigger'] = get_filter_request_var('timeout_trigger');

	$id = sql_save($save, 'plugin_webseer_urls', 'id');

	plugin_webseer_remove_old_users();

	if (!is_error_message()) {
		if ($save['id'] == 0) {
			plugin_webseer_add_remote_hosts($id, $save);
		} else {
			plugin_webseer_update_remote_hosts($save);
		}

		if ($id) {
			raise_message(1);
		} else {
			raise_message(2);
		}
	}

	header('Location: webseer.php?action=edit&id=' . $id . '&header=false');
	exit;
}

/**
 * Deletes all recorded check-history log entries for a single service
 * check URL. Invoked from this file's dispatcher when the request's
 * 'action' is 'purge'.
 *
 * @param int $id The plugin_webseer_urls.id whose log history to purge.
 *
 * @return void
 */
function purge_log_events($id) {
	$name = db_fetch_cell_prepared('SELECT display_name
		FROM plugin_webseer_urls
		WHERE id = ?',
		[$id]);

	db_execute_prepared('DELETE FROM plugin_webseer_urls_log WHERE url_id = ?', [$id]);

	raise_message('url_log_purged', __('The Service Check history was purged for %s', $name, 'webseer'), MESSAGE_LEVEL_INFO);
}

/**
 * Renders the add/edit form for a single service check URL definition,
 * pre-populating its fields when editing an existing URL, hiding the
 * legacy notification fields when Thold's legacy notifications are
 * disabled, and initializing the notification-accounts multiselect
 * widget. Invoked from this file's dispatcher when the request's
 * 'action' is 'edit'.
 *
 * @return void Outputs the edit form HTML directly.
 *
 * @global array $webseer_url_fields The edit form's field definitions,
 *                                   filled in here with the URL's
 *                                   current values.
 */
function webseer_edit_url() {
	global $webseer_url_fields;

	// ================= input validation =================
	get_filter_request_var('id');
	// ====================================================

	$url = [];

	if (!isempty_request_var('id')) {
		$url          = db_fetch_row_prepared('SELECT * FROM plugin_webseer_urls WHERE id = ?', [get_request_var('id')], false);
		$url          = is_array($url) ? $url : [];
		$header_label = __('Query [edit: %s]', $url['url'], 'webseer');
	} else {
		$header_label = __('Query [new]', 'webseer');
	}

	if (read_config_option('thold_disable_legacy', true) == 'on') {
		$webseer_url_fields['notify_accounts']['method'] = 'hidden';
		$webseer_url_fields['notify_extra']['method']    = 'hidden';
	}

	form_start('webseer.php');

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

	draw_edit_form(
		[
			'config' => ['form_name' => 'chk'],
			'fields' => inject_form_variables($webseer_url_fields, $url)
		]
	);

	html_end_box();

	form_save_button('webseer.php', 'return');

	?>
	<script type='text/javascript' <?php print plugin_webseer_csp_nonce(); ?>>

	$(function() {
		var msWidth = 100;
		$('#notify_accounts option').each(function() {
			if ($(this).textWidth() > msWidth) {
				msWidth = $(this).textWidth();
			}
			$('#notify_accounts').css('width', msWidth+80+'px');
		});

		$('#notify_accounts').hide().multiselect({
			noneSelectedText: '<?php print __('No Users Selected', 'webseer'); ?>',
			selectedText: function(numChecked, numTotal, checkedItems) {
				myReturn = numChecked + ' <?php print __('Users Selected', 'webseer'); ?>';
				$.each(checkedItems, function(index, value) {
					if (value.value == '0') {
						myReturn='<?php print __('All Users Selected', 'webseer'); ?>';
						return false;
					}
				});
				return myReturn;
			},
			checkAllText: '<?php print __('All', 'webseer'); ?>',
			uncheckAllText: '<?php print __('None', 'webseer'); ?>',
			uncheckall: function() {
				$(this).multiselect('widget').find(':checkbox:first').each(function() {
					$(this).prop('checked', true);
				});
			},
			open: function(event, ui) {
				$("input[type='search']:first").focus();
			},
			click: function(event, ui) {
				checked=$(this).multiselect('widget').find('input:checked').length;

				if (ui.value == 0) {
					if (ui.checked == true) {
						$('#notify_accounts').multiselect('uncheckAll');
						$(this).multiselect('widget').find(':checkbox:first').each(function() {
							$(this).prop('checked', true);
						});
					}
				} else if (checked == 0) {
					$(this).multiselect('widget').find(':checkbox:first').each(function() {
						$(this).click();
					});
				} else if ($(this).multiselect('widget').find('input:checked:first').val() == '0') {
					if (checked > 0) {
						$(this).multiselect('widget').find(':checkbox:first').each(function() {
							$(this).click();
							$(this).prop('disable', true);
						});
					}
				}
			}
		}).multiselectfilter({
			label: '<?php print __('Search', 'webseer'); ?>',
			width: msWidth
		});
	});

	</script>
	<?php
}

/**
 *  This is a generic function for this page that makes sure that
 *  we have a good request.  We want to protect against people who
 *  like to create issues with Cacti.
 *
 * Validates and normalizes the current request's filter/sort/pagination
 * variables for the Service Checks list, persisting them to the session.
 * Called from list_urls() before rendering the list.
 *
 * @return void
 */
function webseer_request_validation() {
	webseer_validate_list_request('sess_webseerurl', 'display_name', read_config_option('log_refresh_interval'), true, true);
}

/**
 * Validates and normalizes the current request's filter/sort/pagination
 * variables for the service check history log view, persisting them to
 * the session. Called from webseer_show_history() before rendering the
 * history list.
 *
 * @return void
 */
function webseer_log_request_validation() {
	webseer_validate_log_request('sess_webseer_log');
}

/**
 * Renders the check-history log for a single service check URL: a
 * filterable, sortable, paginated table of past check results (date,
 * URL, status, HTTP code, and DNS/connect/redirect/total timing,
 * color-coded by threshold). Invoked from this file's dispatcher when
 * the request's 'action' is 'history'.
 *
 * @return void Redirects back to the list if no 'id' was supplied;
 *              otherwise outputs the history table HTML directly.
 *
 * @global array $config            Cacti global configuration array
 *                                  (declared but not directly used
 *                                  here).
 * @global array $httperrors        Map of HTTP status codes to their
 *                                  descriptions, used to display each
 *                                  check's result code.
 * @global array $httpcompressions  Reserved/declared for parity with
 *                                  other functions in this file; not
 *                                  used directly here.
 */
function webseer_show_history() {
	global $config, $httperrors, $httpcompressions;

	webseer_log_request_validation();

	if (isset_request_var('id')) {
		$id = get_filter_request_var('id');
	} else {
		header('Location: webseer.php?header=false');
		exit;
	}

	$refresh['seconds'] = 9999999;
	$refresh['page']    = 'webseer.php?action=history&id=' . get_filter_request_var('id') . '&header=false';
	$refresh['logout']  = 'false';

	set_page_refresh($refresh);

	top_header();

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

	$sql_where    = '';
	$sql_params[] = get_filter_request_var('id');

	if (get_request_var('filter') != '') {
		$sql_where .= 'AND wl.lastcheck LIKE ?';
		$sql_params[] = '%' . get_request_var('filter') . '%';
	}

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

	$result = db_fetch_assoc_prepared("SELECT wl.*, wu.url
		FROM plugin_webseer_urls_log AS wl
		INNER JOIN plugin_webseer_urls wu
		ON wl.url_id = wu.id
		WHERE wl.url_id = ?
		$sql_where
		$sql_order
		$sql_limit",
		$sql_params);

	$total_rows = db_fetch_cell_prepared("SELECT COUNT(*)
		FROM plugin_webseer_urls_log AS wl
		WHERE wl.url_id = ?
		$sql_where",
		$sql_params);

	$display_text = [
		'lastcheck' => [
			'display' => __('Date', 'webseer')
		],
		'url' => [
			'display' => __('URL', 'webseer'),
		],
		'result' => [
			'display' => __('Error', 'webseer'),
		],
		'http_code' => [
			'display' => __('HTTP Code', 'webseer'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'namelookup_time' => [
			'display' => __('DNS', 'webseer'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'connect_time' => [
			'display' => __('Connect', 'webseer'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'redirect_time' => [
			'display' => __('Redirect', 'webseer'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
		'total_time' => [
			'display' => __('Total', 'webseer'),
			'align'   => 'right',
			'sort'    => 'DESC'
		],
	];

	$nav = html_nav_bar('webseer.php?action=history', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, cacti_sizeof($display_text), __('Urls', 'webseer'), 'page', 'main');

	webseer_show_tab('webseer.php');

	webseer_log_filter();

	print $nav;

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

	html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), 1, 'webseer_servers.php?action=history&id=' . get_request_var('id'), 'main');

	if (count($result)) {
		foreach ($result as $row) {
			if ($row['result'] == 1) {
				$style = 'color:rgba(10,10,10,0.8);background-color:rgba(204, 255, 204, 0.6)';
			} else {
				$style = 'color:rgba(10,10,10,0.8);background-color:rgba(242, 25, 36, 0.6);';
			}

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

			form_selectable_cell($row['lastcheck'], $row['id']);
			form_selectable_cell(preg_match('#^https?://#i', $row['url']) ? "<a class='linkEditMain' href='" . html_escape($row['url']) . "' target=_new>" . html_escape($row['url']) . '</a>' : html_escape($row['url']), $row['id']);
			form_selectable_cell(($row['result'] == 1 ? __('Service Restored', 'webseer') : __('Service Down', 'webseer')), $row['id']);
			form_selectable_cell($httperrors[$row['http_code']], $row['id'], '', 'right');
			form_selectable_cell(round($row['namelookup_time'], 4), $row['id'], '', ($row['namelookup_time'] > 4 ? 'background-color: red;text-align:right' : ($row['namelookup_time'] > 1 ? 'background-color: yellow;text-align:right' : 'text-align:right')));
			form_selectable_cell(round($row['connect_time'], 4), $row['id'], '', ($row['connect_time'] > 4 ? 'background-color: red;text-align:right' : ($row['connect_time'] > 1 ? 'background-color: yellow;text-align:right' : 'text-align:right')));
			form_selectable_cell(round($row['redirect_time'], 4), $row['id'], '', ($row['redirect_time'] > 4 ? 'background-color: red;text-align:right' : ($row['redirect_time'] > 1 ? 'background-color: yellow;text-align:right' : 'text-align:right')));
			form_selectable_cell(round($row['total_time'], 4), $row['id'], '', ($row['total_time'] > 4 ? 'background-color: red;text-align:right' : ($row['total_time'] > 1 ? 'background-color: yellow;text-align:right' : 'text-align:right')));

			form_end_row();
		}
	} else {
		form_alternate_row();
		print '<td colspan="' . (cacti_sizeof($display_text)) . '"><i>' . __('No Service Check Events in History', 'webseer') . '</i></td></tr>';
	}

	html_end_box(false);

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

/**
 * Renders the main Service Checks list page: validates the request,
 * draws the filter toolbar, and prints the paginated, sortable table of
 * configured service check URLs with their current status. Invoked from
 * this file's dispatcher for the default (no 'action') request.
 *
 * @return void Outputs the list page HTML directly.
 *
 * @global array $webseer_actions_url Map of bulk-action ids to their
 *                                    display labels, used to populate
 *                                    the actions dropdown.
 * @global array $httperrors          Map of HTTP status codes to their
 *                                    descriptions, used to display each
 *                                    URL's last result code.
 * @global array $config              Cacti global configuration array.
 * @global int   $hostid               Reserved/declared for parity with
 *                                    other functions in this file; not
 *                                    used directly here.
 * @global array $refresh              Set with the page auto-refresh
 *                                    configuration for set_page_refresh().
 * @global array $httpcompressions    Reserved/declared for parity with
 *                                    other functions in this file; not
 *                                    used directly here.
 */
function list_urls() {
	global $webseer_actions_url, $httperrors, $config, $hostid, $refresh, $httpcompressions;

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

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

	webseer_request_validation();

	$statefilter = '';

	if (isset_request_var('state')) {
		if (get_request_var('state') == '-1') {
			$statefilter = '';
		} elseif (get_request_var('state') == '2') {
			$statefilter = "plugin_webseer_urls.enabled = ''";
		} elseif (get_request_var('state') == '1') {
			$statefilter = "plugin_webseer_urls.enabled = 'on'";
		} elseif (get_request_var('state') == '3') {
			$statefilter = 'plugin_webseer_urls.result != 1';
		}
	}

	top_header();

	webseer_show_tab('webseer.php');

	webseer_filter();

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

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

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

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

	if (get_request_var('rfilter') != '') {
		$rfilter     = get_request_var('rfilter');
		$sql_where .= ($sql_where == '' ? 'WHERE ' : ' AND ') .
			'(display_name RLIKE ? OR ' .
			'url RLIKE ? OR ' .
			'search RLIKE ? OR ' .
			'search_maint RLIKE ? OR ' .
			'search_failed RLIKE ?)';
		$sql_params = array_fill(0, 5, $rfilter);
	}

	$result = db_fetch_assoc_prepared("SELECT *
		FROM plugin_webseer_urls
		$sql_where
		$sql_order
		$sql_limit",
		$sql_params);

	$total_rows = db_fetch_cell_prepared("SELECT COUNT(id)
		FROM plugin_webseer_urls
		$sql_where",
		$sql_params);

	$display_text = [
		'nosort' => [
			'display' => __('Actions', 'webseer'),
			'sort'    => '',
			'align'   => 'left'
		],
		'display_name' => [
			'display' => __('Name', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'left'
		],
		'result' => [
			'display' => __('Status', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'enabled' => [
			'display' => __('Enabled', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'compression' => [
			'display' => __('Compression', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'http_code' => [
			'display' => __('HTTP Code', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'requireauth' => [
			'display' => __('Auth', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'namelookup_time' => [
			'display' => __('DNS', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'connect_time' => [
			'display' => __('Connect', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'redirect_time' => [
			'display' => __('Redirect', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'total_time' => [
			'display' => __('Total', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'timeout_trigger' => [
			'display' => __('Timeout', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		],
		'lastcheck' => [
			'display' => __('Last Check', 'webseer'),
			'sort'    => 'ASC',
			'align'   => 'right'
		]
	];

	$columns = cacti_sizeof($display_text);

	$nav = html_nav_bar('webseer.php', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, $columns, __('Checks', 'webseer'), 'page', 'main');

	form_start('webseer.php', 'chk');

	print $nav;

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

	html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false);

	if (cacti_sizeof($result)) {
		foreach ($result as $row) {
			if ($row['enabled'] == '') {
				$style = 'color:rgba(10,10,10,0.8);background-color:rgba(205, 207, 196, 0.6)';
			} elseif ($row['result'] == 0 && strtotime($row['lastcheck']) > 0) {
				$style = 'color:rgba(10,10,10,0.8);background-color:rgba(242, 25, 36, 0.6);';
			} else {
				$style = 'color:rgba(10,10,10,0.8);background-color:rgba(204, 255, 204, 0.6)';
			}

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

			print "<td width='1%' style='padding:0px;white-space:nowrap'>
				<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/webseer/webseer.php?action=edit&id=' . $row['id']) . "' title='" . __esc('Edit Service Check', 'webseer') . "'>
					<i class='tholdGlyphEdit fas fa-wrench'></i>
				</a>";

			if ($row['enabled'] == '') {
				print "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/webseer/webseer.php?action=enable&id=' . $row['id']) . "' title='" . __esc('Enable Service Check', 'webseer') . "'>
					<i class='tholdGlyphEnable fas fa-play-circle'></i>
				</a>";
			} else {
				print "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/webseer/webseer.php?action=disable&id=' . $row['id']) . "' title='" . __esc('Disable Service Check', 'webseer') . "'>
					<i class='tholdGlyphDisable fas fa-stop-circle'></i>
				</a>";
			}

			print "<a class='pic' href='" . html_escape($config['url_path'] . 'plugins/webseer/webseer.php?action=history&id=' . $row['id']) . "' title='" . __esc('View Service Check History', 'webseer') . "'>
					<i class='tholdGlyphLog fas fa-exclamation-triangle'></i>
				</a>
			</td>";

			$url = '';

			if ($row['type'] == 'http') {
				$url = $row['url'];
			} elseif ($row['type'] == 'dns') {
				$url = __('DNS: Server %s - A Record for %s', $row['url'], $row['search'], 'webseer');
			}

			if (trim($url) == '') {
				form_selectable_cell(html_escape($row['display_name']), $row['id']);
			} else {
				form_selectable_cell(html_escape($row['display_name']), $row['id'], '', '', html_escape($url));
			}

			if ($row['lastcheck'] == '0000-00-00 00:00:00') {
				form_selectable_cell(__('N/A', 'webseer'), $row['id'], '', 'right');
			} else {
				form_selectable_cell(($row['result'] == 1 ? __('Up', 'webseer') : __('Down', 'webseer')), $row['id'], '', 'right');
			}

			form_selectable_cell(($row['enabled'] == 'on' ? __('Enabled', 'webseer') : __('Disabled', 'webseer')), $row['id'], '', 'right');
			form_selectable_cell($httpcompressions[$row['compression']], $row['id'], '', 'right');
			form_selectable_cell(!empty($row['http_code']) ? $httperrors[$row['http_code']] : __('Error', 'webseer'), $row['id'], '', $row['error'] != '' ? 'deviceDown right' : 'right', html_escape($row['error']));
			form_selectable_cell($row['requiresauth'] == '' ? __('Disabled', 'webseer') : __('Enabled', 'webseer'), $row['id'], '', 'right');

			form_selectable_cell(round(webseer_checknull($row['namelookup_time']), 4), $row['id'], '', ($row['namelookup_time'] > 4 ? 'deviceDown right' : ($row['namelookup_time'] > 1 ? 'deviceRecovering right' : 'right')));
			form_selectable_cell(round(webseer_checknull($row['connect_time']), 4), $row['id'], '', ($row['connect_time'] > 4 ? 'deviceDown right' : ($row['connect_time'] > 1 ? 'deviceRecovering right' : 'right')));
			form_selectable_cell(round(webseer_checknull($row['redirect_time']), 4), $row['id'], '', ($row['redirect_time'] > 4 ? 'deviceDown right' : ($row['redirect_time'] > 1 ? 'deviceRecovering right' : 'right')));
			form_selectable_cell(round(webseer_checknull($row['total_time']), 4), $row['id'], '', ($row['total_time'] > 4 ? 'deviceDown right' : ($row['total_time'] > 1 ? 'deviceRecovering right' : 'right')));
			form_selectable_cell($row['timeout_trigger'], $row['id'], '', 'right');
			form_selectable_cell((strtotime($row['lastcheck']) > 0 ? substr($row['lastcheck'],5) : ''), $row['id'], '', 'right');

			form_checkbox_cell($row['url'], $row['id']);
			form_end_row();
		}
	} else {
		form_alternate_row();
		print '<td colspan="' . (cacti_sizeof($display_text) + 1) . '"><center>' . __('No Servers Found', 'webseer') . '</center></td></tr>';
	}

	html_end_box(false);

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

	draw_actions_dropdown($webseer_actions_url);

	form_end();

	?>
	<script type='text/javascript' <?php print plugin_webseer_csp_nonce(); ?>>
	$(function() {
		$('#webseer2_child').find('.cactiTooltipHint').each(function() {
			var title = $(this).attr('title');

			if (title != undefined && title.indexOf('/') >= 0) {
				$(this).click(function() {
					window.open(title, 'webseer');
				});
			}
		});
	});

	</script>
	<?php

	bottom_footer();
}

/**
 * Normalizes a null value to the string '0', leaving any other value
 * unchanged. Called from list_urls() when rendering each URL row's
 * timing columns (namelookup/connect/redirect/total time).
 *
 * @param mixed $value The value to check.
 *
 * @return mixed '0' if $value is null, otherwise $value unchanged.
 */
function webseer_checknull($value) {
	if ($value == null) {
		return '0';
	} else {
		return $value;
	}
}

/**
 * Renders the Service Checks list's filter toolbar (state, refresh
 * interval, rows-per-page, free-text filter) and its client-side
 * JavaScript, and configures the page's auto-refresh. Called from
 * list_urls() before the URLs table itself is rendered.
 *
 * @return void Outputs HTML and JavaScript directly.
 *
 * @global array $item_rows             Rows-per-page options offered by
 *                                     Cacti core, used to populate the
 *                                     'rows' select list.
 * @global int   $page_refresh_interval Reserved/declared for parity with
 *                                     other functions in this file; not
 *                                     used directly here.
 */
function webseer_filter() {
	global $item_rows, $page_refresh_interval;

	$refresh['page']    = 'webseer.php?header=false';
	$refresh['seconds'] = get_request_var('refresh');
	$refresh['logout']  = 'false';

	set_page_refresh($refresh);

	?>
	<script type='text/javascript' <?php print plugin_webseer_csp_nonce(); ?>>
	function applyFilter() {
		strURL  = 'webseer.php?header=false&state=' + $('#state').val();
		strURL += '&refresh=' + $('#refresh').val();
		strURL += '&rfilter=' + base64_encode($('#rfilter').val());
		strURL += '&rows=' + $('#rows').val();
		loadPageNoHeader(strURL);
	}

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

	$(function() {
		$('#refresh, #state, #rows, #rfilter').change(function() {
			applyFilter();
		});

		$('#go').click(function() {
			applyFilter();
		});

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

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

	html_start_box(__('Webseer Service Checks', 'webseer') , '100%', false, 3, 'center', 'webseer.php?action=edit');
	?>
	<tr class='even noprint'>
		<td class='noprint'>
			<form id='form_webseer' action='webseer.php'>
			<input type='hidden' name='search' value='search'>
			<table class='filterTable'>
				<tr class='noprint'>
					<td>
						<?php print __('Search', 'webseer'); ?>
					</td>
					<td>
						<input type='text' class='ui-state-default ui-corner-all' id='rfilter' size='30' value='<?php print html_escape_request_var('rfilter'); ?>'>
					</td>
					<td>
						<?php print __('State', 'webseer'); ?>
					</td>
					<td>
						<select id='state'>
							<option value='-1'><?php print __('Any', 'webseer'); ?></option>
							<?php
							foreach (['2' => 'Disabled', '1' => 'Enabled', '3' => 'Triggered'] as $key => $row) {
								print "<option value='" . $key . "'" . (isset_request_var('state') && $key == get_request_var('state') ? ' selected' : '') . '>' . $row . '</option>';
							}
	?>
						</select>
					</td>
					<td>
						<?php print __('Refresh', 'webseer'); ?>
					</td>
					<td>
						<select id='refresh'>
							<?php
	foreach ($page_refresh_interval as $seconds => $display_text) {
		print "<option value='" . $seconds . "'";

		if (get_request_var('refresh') == $seconds) {
			print ' selected';
		}
		print '>' . $display_text . "</option>\n";
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Checks', 'webseer'); ?>
					</td>
					<td>
						<select id='rows'>
							<?php
	print "<option value='-1'" . (get_request_var('rows') == $key ? ' selected' : '') . '>' . __('Default', 'webseer') . "</option>\n";

	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('rows') == $key) {
				print ' selected';
			} print '>' . htmlspecialchars($value) . "</option>\n";
		}
	}
	?>
						</select>
					</td>
					<td>
						<span class='nowrap'>
							<input type='button' id='go' value='<?php print __esc('Go', 'webseer'); ?>'>
							<input type='button' id='clear' value='<?php print __esc('Clear', 'webseer'); ?>'>
						</span>
					</td>
				</tr>
			</table>
		</form>
		</td>
	</tr>
	<?php

	html_end_box();
}

/**
 * Renders the check-history log's filter toolbar (rows-per-page,
 * free-text filter, purge-history button) and its client-side
 * JavaScript. Called from webseer_show_history() before the history
 * table itself is rendered.
 *
 * @return void Outputs HTML and JavaScript directly.
 *
 * @global array $item_rows Rows-per-page options offered by Cacti core,
 *                          used to populate the 'rows' select list.
 */
function webseer_log_filter() {
	global $item_rows;

	?>
	<script type='text/javascript' <?php print plugin_webseer_csp_nonce(); ?>>

	refreshMSeconds=99999999;

	function applyFilter() {
		strURL  = 'webseer.php?action=history&header=false&id=<?php print get_request_var('id'); ?>';
		strURL += '&filter=' + $('#filter').val();
		strURL += '&rows=' + $('#rows').val();
		refreshMSeconds=99999999;
		loadPageNoHeader(strURL);
	}

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

	function purgeEvents() {
		strURL = 'webseer.php?action=purge&id=<?php print get_request_var('id'); ?>';
		loadPageNoHeader(strURL);
	}

	$(function() {
		$('#rows').change(function() {
			applyFilter();
		});

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

		$('#purge').click(function() {
			purgeEvents();
		});

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

	</script>
	<?php

	html_start_box(__('Webseer Service Check History', 'webseer') , '100%', false, 3, 'center', '');
	?>
	<tr class='even noprint'>
		<td class='noprint'>
			<form id='webseer' action='webseer.php?action=history'>
			<table class='filterTable'>
				<tr class='noprint'>
					<td>
						<?php print __('Date Search', 'webseer'); ?>
					</td>
					<td>
						<input type='text' class='ui-state-default ui-corner-all' id='filter' size='30' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Entries', 'webseer'); ?>
					</td>
					<td>
						<select id='rows'>
							<?php
							print "<option value='-1'" . (get_request_var('rows') == '-1' ? ' selected' : '') . '>' . __('Default', 'webseer') . '</option>';

	if (cacti_sizeof($item_rows)) {
		foreach ($item_rows as $key => $value) {
			print "<option value='" . $key . "'";

			if (get_request_var('rows') == $key) {
				print ' selected';
			} print '>' . htmlspecialchars($value) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<span class='nowrap'>
							<input type='submit' id='go' alt='' value='<?php print __esc('Go', 'webseer'); ?>'>
							<input type='button' id='clear' alt='' value='<?php print __esc('Clear', 'webseer'); ?>'>
							<input type='button' id='purge' alt='' value='<?php print __esc('Purge Events', 'webseer'); ?>'>
						</span>
					</td>
				</tr>
			</table>
			</form>
		</td>
	</tr>
	<?php
	html_end_box();
}