syslog_reports.php

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

chdir('../../');
include('./include/auth.php');
include_once('./lib/xml.php');
include_once(__DIR__ . '/setup.php');

syslog_connect();

set_default_action();

if (isset_request_var('import') && syslog_allow_rule_edits()) {
	set_request_var('action', 'import');
}

switch (get_request_var('action')) {
	case 'save':
		if (isset_request_var('save_component_import')) {
			report_import();
		} else {
			form_save();
		}

		break;
	case 'actions':
		form_actions();

		break;
	case 'import':
		if (!syslog_allow_rule_edits()) {
			die(__('Permission denied.', 'syslog'));
		}

		top_header();
		syslog_include_js();
		import();
		bottom_footer();

		break;
	case 'export':
		report_export();

		break;
	case 'edit':
		top_header();
		syslog_include_js();

		syslog_action_edit();

		bottom_footer();

		break;
	default:
		top_header();
		syslog_include_js();

		syslog_report();

		bottom_footer();

		break;
}

/**
 * Save a Syslog Report rule and redirect back to the edit screen.
 *
 * @return void
 */
function form_save(): void {
	if (!syslog_allow_rule_edits()) {
		die(__('Permission denied.', 'syslog'));
	}

	if ((isset_request_var('save_component_report')) && (isempty_request_var('add_dq_y'))) {
		$reportid = api_syslog_report_save(get_filter_request_var('id'), get_nfilter_request_var('name'),
			get_nfilter_request_var('type'), get_nfilter_request_var('message'),
			get_nfilter_request_var('timespan'), get_nfilter_request_var('timepart'),
			get_nfilter_request_var('body'), get_nfilter_request_var('email'),
			get_nfilter_request_var('notes'), get_nfilter_request_var('enabled'),
			get_nfilter_request_var('notify'));

		if ((is_error_message()) || (get_filter_request_var('id') != get_filter_request_var('_id')) || $reportid === false) {
			header('Location: syslog_reports.php?header=false&action=edit&id=' . (empty($reportid) ? get_request_var('id') : $reportid));
		} else {
			header('Location: syslog_reports.php?header=false');
		}
	}
}

/**
 * Display the bulk action confirmation form for the selected Syslog Reports.
 *
 * @return void
 */
function form_actions(): void {
	if (!syslog_allow_rule_edits()) {
		die(__('Permission denied.', 'syslog'));
	}

	global $config, $syslog_actions, $fields_syslog_action_edit;
	global $syslogdb_default;

	get_filter_request_var('drp_action', FILTER_VALIDATE_REGEXP,
		['options' => ['regexp' => '/^([a-zA-Z0-9_]+)$/']]);

	// 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'));
		$drp_action     = get_request_var('drp_action');

		$action_map = [
			'1' => 'api_syslog_report_remove',
			'2' => 'api_syslog_report_disable',
			'3' => 'api_syslog_report_enable'
		];

		syslog_apply_selected_items_action(
			$selected_items,
			$drp_action,
			$action_map,
			'4',
			get_nfilter_request_var('selected_items')
		);

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

		exit;
	}

	top_header();

	form_start('syslog_reports.php');

	html_start_box($syslog_actions[get_request_var('drp_action')], '60%', '', '3', 'center', '');

	// setup some variables
	$report_array = [];
	$report_list  = '';
	$title        = '';

	// loop through each of the clusters 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]);
			// ====================================================

			$report_info = syslog_db_fetch_cell_prepared("SELECT name
				FROM `$syslogdb_default`.`syslog_reports`
				WHERE id = ?",
				[$matches[1]]);

			$report_list .= '<li>' . $report_info . '</li>';
			$report_array[] = $matches[1];
		}
	}

	if (cacti_sizeof($report_array)) {
		if (get_request_var('drp_action') == '1') { // delete
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to Delete the following Syslog Report(s).', 'syslog') . "</p>
					<div class='itemlist'><ul>$report_list</ul></div>";
			print "</td></tr>
				</td>
			</tr>\n";

			$title = __esc('Delete Syslog Report(s)', 'syslog');
		} elseif (get_request_var('drp_action') == '2') { // disable
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to Disable the following Syslog Report(s).', 'syslog') . "</p>
					<div class='itemlist'><ul>$report_list</ul></div>";
			print "</td></tr>
				</td>
			</tr>\n";

			$title = __esc('Disable Syslog Report(s)', 'syslog');
		} elseif (get_request_var('drp_action') == '3') { // enable
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to Enable the following Syslog Report(s).', 'syslog') . "</p>
					<div class='itemlist'><ul>$report_list</ul></div>";
			print "</td></tr>
				</td>
			</tr>\n";

			$title = __esc('Enable Syslog Report(s)', 'syslog');
		} elseif (get_request_var('drp_action') == '4') { // export
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to Export the following Syslog Report Rule(s).', 'syslog') . "</p>
					<div class='itemlist'><ul>$report_list</ul></div>";
			print "</td></tr>
				</td>
			</tr>\n";

			$title = __esc('Export Syslog Report Rule(s)', 'syslog');
		}

		$save_html = "<input type='button' value='" . __esc('Cancel', 'syslog') . "' class='cactiReturnTo'>&nbsp;<input type='submit' value='" . __esc('Continue', 'syslog') . "' title='$title'";
	} else {
		print "<tr><td class='odd'><span class='textError'>" . __('You must select at least one Syslog Report.', 'syslog') . "</span></td></tr>\n";
		$save_html = "<input type='button' value='" . __esc('Return', 'syslog') . "' class='cactiReturnTo'>";
	}

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

	html_end_box();

	form_end();

	bottom_footer();
}

/**
 * Export the selected Syslog Report rules as an XML download.
 *
 * @return void
 */
function report_export(): void {
	// 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'));

		if ($selected_items != false) {
			$output = '<templates>' . PHP_EOL;

			foreach ($selected_items as $id) {
				if ($id > 0) {
					$data = syslog_db_fetch_row_prepared('SELECT *
						FROM syslog_reports
						WHERE id = ?',
						[$id]);

					if (cacti_sizeof($data)) {
						unset($data['id']);
						$output .= syslog_array2xml($data);
					}
				}
			}

			$output .= '</templates>' . PHP_EOL;
			header('Content-type: application/xml');
			header('Content-Disposition: attachment; filename=syslog_reports_export.xml');
			print $output;
		}
	}
}

/**
 * Validate and save a Syslog Report rule.
 *
 * @param int|string $id        The id of the Report rule, '' for a new rule.
 * @param string $name     The name of the Report.
 * @param string $type     The match type of the Report.
 * @param string $message  The match string of the Report.
 * @param int    $timespan The frequency of the Report.
 * @param int    $timepart The time of day the Report is sent.
 * @param string $body     The email body text of the Report.
 * @param string $email    The comma delimited email addresses of the Report.
 * @param string $notes    The notes of the Report.
 * @param string $enabled  'on' when the Report is enabled, otherwise ''.
 * @param int|string $notify   The notification list id of the Report.
 *
 * @return int|false The id of the saved Report, or false when the save failed.
 */
function api_syslog_report_save(int|string $id, string $name, string $type, string $message, int $timespan, int $timepart, string $body,
	string $email, string $notes, string $enabled, int|string $notify = 0): int|false {
	global $config, $syslogdb_default;

	// get the username
	$username = get_username($_SESSION['sess_user_id']);

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

	$hour   = intval($timepart / 60);
	$minute = $timepart % 60;

	$save['hash']     = get_hash_syslog($save['id'], 'syslog_reports');
	$save['name']     = form_input_validate($name,     'name',     '', false, 3);
	$save['type']     = form_input_validate($type,     'type',     '', false, 3);
	$save['message']  = form_input_validate($message,  'message',  '', false, 3);
	$save['timespan'] = form_input_validate($timespan, 'timespan', '', false, 3);
	$save['timepart'] = form_input_validate($timepart, 'timepart', '', false, 3);
	$save['body']     = form_input_validate($body,     'body',     '', true, 3);
	$save['email']    = form_input_validate($email,    'email',    '', true, 3);
	$save['notes']    = form_input_validate($notes,    'notes',    '', true, 3);
	$save['enabled']  = ($enabled == 'on' ? 'on' : '');
	$save['date']     = time();
	$save['user']     = $username;
	$save['notify']   = $notify;

	$id = 0;

	if (!is_error_message()) {
		$sql = syslog_get_alert_sql($save, 100);

		if (cacti_sizeof($sql)) {
			$sql_sql    = is_string($sql['sql']) ? $sql['sql'] : '';
			$sql_params = is_array($sql['params']) ? $sql['params'] : [];

			$db_sql     = str_replace('%', '|||||', $sql_sql);
			$db_sql     = str_replace('?', '%s', $db_sql);
			$approx_sql = vsprintf($db_sql, $sql_params);
			$approx_sql = str_replace('|||||', '%', $approx_sql);

			$results = syslog_db_fetch_assoc_prepared($sql_sql, $sql_params, false);

			if ($results === false) {
				raise_message('sql_error', __('The SQL Syntax Entered is invalid.  Please correct your SQL.<br>', 'syslog'), MESSAGE_LEVEL_ERROR);
				raise_message('sql_detail', __('The Pre-processed SQL is:<br><br> %s', $approx_sql, 'syslog'), MESSAGE_LEVEL_INFO);

				return false;
			} else {
				// syslog_sync_save() does not return the saved id, so look it up
				syslog_sync_save($save, 'syslog_reports', 'id');

				$id = (int) syslog_db_fetch_cell_prepared("SELECT id
					FROM `$syslogdb_default`.`syslog_reports`
					WHERE hash = ?",
					[$save['hash']]);

				return $id;
			}
		} else {
			raise_message('sql_error', __('The processed SQL was invalid.  Please correct your SQL', 'syslog'), MESSAGE_LEVEL_ERROR);

			return false;
		}
	}

	return false;
}

/**
 * Delete a Syslog Report rule by id.
 *
 * @param int $id The id of the Report rule to delete.
 *
 * @return void
 */
function api_syslog_report_remove(int $id): void {
	global $syslogdb_default;
	syslog_db_execute_prepared("DELETE FROM `$syslogdb_default`.`syslog_reports` WHERE id = ?", [$id]);
}

/**
 * Disable a Syslog Report rule by id.
 *
 * @param int $id The id of the Report rule to disable.
 *
 * @return void
 */
function api_syslog_report_disable(int $id): void {
	global $syslogdb_default;
	syslog_db_execute_prepared("UPDATE `$syslogdb_default`.`syslog_reports` SET enabled = '' WHERE id = ?", [$id]);
}

/**
 * Enable a Syslog Report rule by id.
 *
 * @param int $id The id of the Report rule to enable.
 *
 * @return void
 */
function api_syslog_report_enable(int $id): void {
	global $syslogdb_default;
	syslog_db_execute_prepared("UPDATE `$syslogdb_default`.`syslog_reports` SET enabled = 'on' WHERE id = ?", [$id]);
}

/**
 * Fetch the Syslog Report rules matching the current filter, appending the
 * generated where clause and parameters to the given references.
 *
 * @param string              $sql_where The where clause, passed by reference.
 * @param array<int, mixed>   $sql_params The prepared SQL parameters, passed by reference.
 * @param int                 $rows      The number of rows to fetch.
 *
 * @return array<int, array<string, mixed>> The matching Report rules.
 */
function syslog_get_report_records(&$sql_where, &$sql_params, int $rows): array {
	global $syslogdb_default;

	if (get_request_var('filter') != '') {
		$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') .
			'(message LIKE ? OR email LIKE ? OR notes LIKE ? OR name LIKE ?)';

		$sql_params[] = '%' . get_request_var('filter') . '%';
		$sql_params[] = '%' . get_request_var('filter') . '%';
		$sql_params[] = '%' . get_request_var('filter') . '%';
		$sql_params[] = '%' . get_request_var('filter') . '%';
	}

	if (get_request_var('enabled') != '-1') {
		if (get_request_var('enabled') == '1') {
			$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . "enabled='on'";
		} else {
			$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . "enabled=''";
		}
	}

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

	$query_string = "SELECT *
		FROM `$syslogdb_default`.`syslog_reports`
		$sql_where
		$sql_order
		$sql_limit";

	return syslog_db_fetch_assoc_prepared($query_string, $sql_params);
}

/**
 * Display the Syslog Report rule edit form.
 *
 * @return void
 */
function syslog_action_edit(): void {
	global $message_types, $syslog_freqs, $syslog_times;
	global $syslogdb_default;

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

	if (isset_request_var('id')) {
		$report = syslog_db_fetch_row_prepared("SELECT *
			FROM `$syslogdb_default`.`syslog_reports`
			WHERE id = ?",
			[get_request_var('id')]);

		if (cacti_sizeof($report)) {
			$header_label = __esc('Report Edit [edit: %s]', $report['name'], 'syslog');
		} else {
			$header_label = __('Report Edit [new]', 'syslog');

			$report['name'] = __('New Report Record', 'syslog');
		}
	} else {
		$header_label = __('Report Edit [new]', 'syslog');

		$report['name'] = __('New Report Record', 'syslog');
	}

	if (db_table_exists('plugin_notification_lists')) {
		$lists = array_rekey(
			db_fetch_assoc('SELECT id, name
				FROM plugin_notification_lists
				ORDER BY name'),
			'id', 'name'
		);
	} else {
		$lists = ['0' => __('N/A', 'syslog')];
	}

	$fields_syslog_report_edit = [
		'spacer0' => [
			'method'        => 'spacer',
			'friendly_name' => __('Details', 'syslog')
		],
		'name' => [
			'method'        => 'textbox',
			'friendly_name' => __('Name', 'syslog'),
			'description'   => __('Please describe this Report.', 'syslog'),
			'value'         => '|arg1:name|',
			'max_length'    => '250'
		],
		'enabled' => [
			'method'        => 'drop_array',
			'friendly_name' => __('Enabled?', 'syslog'),
			'description'   => __('Is this Report Enabled?', 'syslog'),
			'value'         => '|arg1:enabled|',
			'array'         => ['on' => __('Enabled', 'syslog'), '' => __('Disabled', 'syslog')],
			'default'       => 'on'
		],
		'type' => [
			'method'        => 'drop_array',
			'friendly_name' => __('String Match Type', 'syslog'),
			'description'   => __('Define how you would like this string matched.', 'syslog'),
			'value'         => '|arg1:type|',
			'array'         => $message_types,
			'default'       => 'matchesc'
		],
		'timespan' => [
			'method'        => 'drop_array',
			'friendly_name' => __('Frequency', 'syslog'),
			'description'   => __('How often should this Report be sent to the distribution list?', 'syslog'),
			'value'         => '|arg1:timespan|',
			'array'         => $syslog_freqs,
			'default'       => 'del'
		],
		'timepart' => [
			'method'        => 'drop_array',
			'friendly_name' => __('Send Time', 'syslog'),
			'description'   => __('What time of day should this report be sent?', 'syslog'),
			'value'         => '|arg1:timepart|',
			'array'         => $syslog_times,
			'default'       => 'del'
		],
		'spacer1' => [
			'method'        => 'spacer',
			'friendly_name' => __('Report Format', 'syslog')
		],
		'message' => [
			'friendly_name' => __('Message Match String', 'syslog'),
			'description'   => __('The matching component of the syslog message.', 'syslog'),
			'method'        => 'textbox',
			'max_length'    => '255',
			'value'         => '|arg1:message|',
			'default'       => '',
		],
		'body' => [
			'friendly_name' => __('Email Body Text', 'syslog'),
			'textarea_rows' => '6',
			'textarea_cols' => '80',
			'description'   => __('The information that will be contained in the body of the Report.', 'syslog'),
			'method'        => 'textarea',
			'class'         => 'textAreaNotes',
			'value'         => '|arg1:body|',
			'default'       => '',
		],
		'notify' => [
			'method'        => 'drop_array',
			'friendly_name' => __('Notification List', 'syslog'),
			'description'   => __('Use the contents of this Notification List to dictate who should be notified and how.', 'syslog'),
			'value'         => '|arg1:notify|',
			'array'         => $lists,
			'none_value'    => __('None', 'syslog'),
			'default'       => '0'
		],
		'email' => [
			'friendly_name' => __('Email Addresses', 'syslog'),
			'textarea_rows' => '3',
			'textarea_cols' => '60',
			'description'   => __('Comma delimited list of Email addresses to send the report to.', 'syslog'),
			'method'        => 'textarea',
			'class'         => 'textAreaNotes',
			'value'         => '|arg1:email|',
			'default'       => '',
		],
		'notes' => [
			'friendly_name' => __('Notes', 'syslog'),
			'textarea_rows' => '3',
			'textarea_cols' => '60',
			'description'   => __('Space for Notes on the Report', 'syslog'),
			'method'        => 'textarea',
			'class'         => 'textAreaNotes',
			'value'         => '|arg1:notes|',
			'default'       => '',
		],
		'id' => [
			'method' => 'hidden_zero',
			'value'  => '|arg1:id|'
		],
		'_id' => [
			'method' => 'hidden_zero',
			'value'  => '|arg1:id|'
		],
		'save_component_report' => [
			'method' => 'hidden',
			'value'  => '1'
		]
	];

	form_start('syslog_reports.php', 'syslog_edit');

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

	draw_edit_form(
		[
			'config' => ['no_form_tag' => true],
			'fields' => inject_form_variables($fields_syslog_report_edit, (isset($report) ? $report : []))
		]
	);

	html_end_box();

	if (syslog_allow_rule_edits()) {
		form_save_button('syslog_reports.php', '', 'id');
	}

	?>
	<script type='text/javascript'>

	var allowEdits=<?php print syslog_allow_rule_edits() ? 'true' : 'false'; ?>;
	var notifyExists=<?php print db_table_exists('plugin_notification_lists') ? 'true' : 'false'; ?>;

	$(function() {
		if (!allowEdits) {
			$('#syslog_edit').find('select, input, textarea, submit').not(':button').prop('disabled', true);
			$('#syslog_edit').find('select').each(function() {
				if ($(this).selectmenu('instance')) {
					$(this).selectmenu('refresh');
				}
			});
		}

		if (!notifyExists) {
			$('#row_notify').hide();
		}
	});

	</script>
	<?php
}

/**
 * Display the Syslog Report filter row.
 *
 * @return void
 */
function syslog_reports_filter(): void {
	global $config, $item_rows;
	?>
	<tr class='even'>
		<td>
		<form id='reports'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'syslog'); ?>
					</td>
					<td>
						<input type='text' id='filter' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Enabled', 'syslog'); ?>
					</td>
					<td>
						<select id='enabled'>
							<option value='-1'<?php if (get_request_var('enabled') == '-1') {?> selected<?php }?>><?php print __('All', 'syslog'); ?></option>
							<option value='1'<?php if (get_request_var('enabled') == '1') {?> selected<?php }?>><?php print __('Yes', 'syslog'); ?></option>
							<option value='0'<?php if (get_request_var('enabled') == '0') {?> selected<?php }?>><?php print __('No', 'syslog'); ?></option>
						</select>
					</td>
					<td>
						<?php print __('Rows', 'syslog'); ?>
					</td>
					<td>
						<select id='rows'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'syslog'); ?></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>
					<td>
						<span>
							<input id='refresh' type='button' value='<?php print __esc('Go', 'syslog'); ?>'>
							<input id='clear' type='button' value='<?php print __esc('Clear', 'syslog'); ?>'>
							<?php if (syslog_allow_rule_edits()) {?><input id='import' type='button' value='<?php print __esc('Import', 'syslog'); ?>'><?php } ?>
						</span>
					</td>
				</tr>
			</table>
		</td>
		<input type='hidden' id='page' value='<?php print get_filter_request_var('page'); ?>'>
		</form>
		<script type='text/javascript'>
		initSyslogReports();
		</script>
	</tr>
	<?php
}

/**
 * Display the Syslog Report list.
 *
 * @return void
 */
function syslog_report(): void {
	global $syslog_actions, $message_types, $syslog_freqs, $syslog_times, $config;
	global $syslogdb_default;

	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1',
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'enabled' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'filter' => [
			'filter'  => FILTER_DEFAULT,
			'pageset' => true,
			'default' => ''
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'name',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

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

	if (syslog_allow_rule_edits()) {
		$url = 'syslog_reports.php?action=edit&type=1';
	} else {
		$url = '';
	}

	html_start_box(__('Syslog Report Filters', 'syslog'), '100%', '', '3', 'center', $url);

	syslog_reports_filter();

	html_end_box();

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

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

	$reports = syslog_get_report_records($sql_where, $sql_params, $rows);

	$rows_query_string = "SELECT COUNT(*)
		FROM `$syslogdb_default`.`syslog_reports`
		$sql_where";

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

	$display_text = [
		'name'     => [__('Report Name', 'syslog'), 'ASC'],
		'enabled'  => [__('Enabled', 'syslog'), 'ASC'],
		'type'     => [__('Match Type', 'syslog'), 'ASC'],
		'message'  => [__('Search String', 'syslog'), 'ASC'],
		'timespan' => [__('Frequency', 'syslog'), 'ASC'],
		'timepart' => [__('Send Time', 'syslog'), 'ASC'],
		'lastsent' => [__('Last Sent', 'syslog'), 'ASC'],
		'date'     => [__('Last Modified', 'syslog'), 'ASC'],
		'user'     => [__('By User', 'syslog'), 'DESC']
	];

	$nav = html_nav_bar('syslog_reports.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, cacti_sizeof($display_text) + 1, __('Reports', 'syslog'), 'page', 'main');

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

	print $nav;

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

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

	if (cacti_sizeof($reports)) {
		foreach ($reports as $report) {
			form_alternate_row('line' . $report['id']);
			form_selectable_cell(filter_value(title_trim($report['name'], read_config_option('max_title_length')), get_request_var('filter'), $config['url_path'] . 'plugins/syslog/syslog_reports.php?action=edit&id=' . $report['id']), $report['id']);
			form_selectable_cell((($report['enabled'] == 'on') ? __('Yes', 'syslog') : __('No', 'syslog')), $report['id']);
			form_selectable_cell($message_types[$report['type']], $report['id']);
			form_selectable_cell($report['message'], $report['id']);
			form_selectable_cell($syslog_freqs[$report['timespan']], $report['id']);
			form_selectable_cell($syslog_times[$report['timepart']], $report['id']);
			form_selectable_cell(($report['lastsent'] == 0 ? __('Never', 'syslog') : date('Y-m-d H:i:s', $report['lastsent'])), $report['id']);
			form_selectable_cell(date('Y-m-d H:i:s', $report['date']), $report['id']);
			form_selectable_cell($report['user'], $report['id']);
			form_checkbox_cell($report['name'], $report['id']);
			form_end_row();
		}
	} else {
		print "<tr><td colspan='" . (cacti_sizeof($display_text) + 1) . "'><em>" . __('No Syslog Reports Defined', 'syslog') . '</em></td></tr>';
	}

	html_end_box(false);

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

	draw_actions_dropdown($syslog_actions);

	form_end();

	if (isset($_SESSION['exporter'])) {
		syslog_download_frame('syslog_reports.php?action=export&selected_items=' . $_SESSION['exporter']);

		kill_session_var('exporter');
		exit;
	}
}

/**
 * Display the Syslog Report import form.
 *
 * @return void
 */
function import(): void {
	$form_data = [
		'import_file' => [
			'friendly_name' => __('Import Report Rule from Local File', 'syslog'),
			'description'   => __('If the XML file containing the Report Rule definition data is located on your local machine, select it here.', 'syslog'),
			'method'        => 'file'
		],
		'import_text' => [
			'method'        => 'textarea',
			'friendly_name' => __('Import Report Rule from Text', 'syslog'),
			'description'   => __('If you have the XML file containing the Report Rule definition data as text, you can paste it into this box to import it.', 'syslog'),
			'value'         => '',
			'default'       => '',
			'textarea_rows' => '10',
			'textarea_cols' => '80',
			'class'         => 'textAreaNotes'
		]
	];

	print "<form method='post' action='syslog_reports.php' enctype='multipart/form-data'>";

	html_start_box(__('Import Report Data', 'syslog'), '100%', false, '3', 'center', '');

	draw_edit_form(
		[
			'config' => ['no_form_tag' => true],
			'fields' => $form_data
		]
	);

	html_end_box();

	form_hidden_box('save_component_import', '1', '');

	form_save_button('', 'import');
}

/**
 * Import Syslog Report rules from an uploaded file or pasted XML text.
 *
 * @return void
 */
function report_import(): void {
	if (!syslog_allow_rule_edits()) {
		die(__('Permission denied.', 'syslog'));
	}

	$xml_data = syslog_get_import_xml_payload('syslog_reports.php?header=false');

	// obtain debug information if it's set
	$xml_array = xml2array($xml_data);

	$debug_data = [];

	if (is_array($xml_array) && cacti_sizeof($xml_array)) {
		foreach ($xml_array as $template => $contents) {
			$tname = '';
			$save  = [];

			if (cacti_sizeof($contents)) {
				foreach ($contents as $name => $value) {
					switch($name) {
						case 'hash':
							// See if the hash exists, if it does, update the alert
							$found = db_fetch_cell_prepared('SELECT id
							FROM syslog_reports
							WHERE hash = ?',
								[$value]);

							if (!empty($found)) {
								$save['hash'] = $value;
								$save['id']   = $found;
							} else {
								$save['hash'] = $value;
								$save['id']   = 0;
							}

							break;
						case 'name':
							$tname        = $value;
							$save['name'] = $value;

							break;
						default:
							if (syslog_db_column_exists('syslog_reports', $name)) {
								$save[$name] = $value;
							}

							break;
					}
				}
			}

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

			if ($id) {
				raise_message('syslog_info' . $id, __('NOTE: Report Rule \'%s\' %s!', $tname, ($save['id'] > 0 ? __('Updated', 'syslog') : __('Imported', 'syslog')), 'syslog'), MESSAGE_LEVEL_INFO);
			} else {
				raise_message('syslog_info' . $id, __('ERROR: Report Rule \'%s\' %s Failed!', $tname, ($save['id'] > 0 ? __('Update', 'syslog') : __('Import', 'syslog')), 'syslog'), MESSAGE_LEVEL_ERROR);
			}
		}
	}

	header('Location: syslog_reports.php');
}