mactrack_device_types.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 cacti base functions
require('./include/auth.php');
require_once('./lib/snmp.php');
require_once('./plugins/mactrack/lib/mactrack_functions.php');

// include base and vendor functions to obtain a list of registered scanning functions
require_once('./plugins/mactrack/lib/mactrack_functions.php');
require_once('./plugins/mactrack/lib/mactrack_vendors.php');

// store the list of registered mactrack scanning functions
db_execute('REPLACE INTO mac_track_scanning_functions
	(scanning_function, type)
	VALUES (' . db_qstr(__('Not Applicable - Router', 'mactrack')) . ', 1)');

if (isset($mactrack_scanning_functions)) {
	foreach ($mactrack_scanning_functions as $scanning_function) {
		db_execute_prepared('REPLACE INTO mac_track_scanning_functions
			(scanning_function, type)
			VALUES (?, 1)', [$scanning_function]);
	}
}

// store the list of registered mactrack scanning functions
db_execute('REPLACE INTO mac_track_scanning_functions
	(scanning_function, type)
	VALUES (' . db_qstr(__('Not Applicable - Switch/Hub', 'mactrack')) . ', 2)');

if (isset($mactrack_scanning_functions_ip)) {
	foreach ($mactrack_scanning_functions_ip as $scanning_function) {
		db_execute_prepared('REPLACE INTO mac_track_scanning_functions
			(scanning_function, type)
			VALUES (?, 2)', [$scanning_function]);
	}
}

if (isset($mactrack_scanning_functions_dot1x)) {
	foreach ($mactrack_scanning_functions_dot1x as $scanning_function) {
		db_execute_prepared('REPLACE INTO mac_track_scanning_functions
			(scanning_function, type)
			VALUES (?, 3)', [$scanning_function]);
	}
}

$device_types_actions = [
	1 => __('Delete', 'mactrack'),
	2 => __('Duplicate', 'mactrack')
];

// set default action
set_default_action();

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

		break;
	case 'actions':
		form_actions();

		break;
	case 'edit':
		top_header();
		mactrack_device_type_edit();
		bottom_footer();

		break;
	case 'import':
		top_header();
		mactrack_device_type_import();
		bottom_footer();

		break;
	default:
		if (isset_request_var('scan')) {
			mactrack_rescan_device_types();
			exit;
		}

		if (isset_request_var('import')) {
			header('Location: mactrack_device_types.php?header=false&action=import');
			exit;
		}

		if (isset_request_var('export')) {
			mactrack_device_type_export();
			exit;
		} else {
			top_header();
			mactrack_device_type();
			bottom_footer();
		}

		break;
}

/* --------------------------
	The Save Function
   -------------------------- */

/**
 * Validates and saves the device type edit form's submitted fields via
 * api_mactrack_device_type_save() (redirecting back to the edit form
 * for the saved/original device type id), or, when a CSV import file
 * was uploaded instead, processes it via
 * mactrack_device_type_import_processor() and stashes any resulting
 * debug info in the session. Called from this script's main
 * request-dispatch switch when action=save.
 *
 * @return void
 */
function form_save(): void {
	if ((isset_request_var('save_component_device_type')) && (isempty_request_var('add_dq_y'))) {
		$device_type_id = api_mactrack_device_type_save(get_nfilter_request_var('device_type_id'),
			get_nfilter_request_var('description'), get_nfilter_request_var('vendor'),
			get_nfilter_request_var('device_type'), get_nfilter_request_var('sysDescr_match'),
			get_nfilter_request_var('sysObjectID_match'), get_nfilter_request_var('scanning_function'),
			get_nfilter_request_var('ip_scanning_function'), get_nfilter_request_var('dot1x_scanning_function'),
			get_nfilter_request_var('serial_number_oid'), get_nfilter_request_var('lowPort'),
			get_nfilter_request_var('highPort'),
			(isset_request_var('disabled') ? get_nfilter_request_var('disabled') : ''));

		if ($device_type_id) {
			raise_message(1);
		} else {
			raise_message(2);
		}
		header('Location: mactrack_device_types.php?action=edit&header=false&device_type_id=' . (empty($device_type_id) ? get_nfilter_request_var('device_type_id') : $device_type_id));
	}

	if (isset_request_var('save_component_import')) {
		if (($_FILES['import_file']['tmp_name'] != 'none') && ($_FILES['import_file']['tmp_name'] != '')) {
			// file upload
			$csv_data = (array) file($_FILES['import_file']['tmp_name']);

			// obtain debug information if it's set
			$debug_data = mactrack_device_type_import_processor($csv_data);

			if (cacti_sizeof($debug_data) > 0) {
				$_SESSION['import_debug_info'] = $debug_data;
			}
		} else {
			header('Location: mactrack_device_types.php?action=import');
			exit;
		}

		header('Location: mactrack_device_types.php?action=import');
		exit;
	}
}

/**
 * Deletes a MacTrack device type record.
 *
 * @param int $device_type_id The device type id to remove.
 *
 * @return void
 */
function api_mactrack_device_type_remove($device_type_id): void {
	db_execute_prepared('DELETE FROM mac_track_device_types
		WHERE device_type_id = ?',
		[$device_type_id]);
}

/**
 * Validates and saves a MacTrack device type record's fields
 * (description, vendor, device type, sysDescr/sysObjectID detection
 * patterns, scanning function names, serial number OID, port range,
 * disabled flag).
 *
 * @param int    $device_type_id          The device type id (0 for a
 *                                       new record).
 * @param string $description             The device type's display
 *                                       description.
 * @param string $vendor                  The vendor name.
 * @param string $device_type             The vendor-specific device
 *                                       type identifier.
 * @param string $sysDescr_match          Regex pattern to match against
 *                                       a device's sysDescr for
 *                                       auto-detection.
 * @param string $sysObjectID_match       Regex pattern to match against
 *                                       a device's sysObjectID for
 *                                       auto-detection.
 * @param string $scanning_function       Name of the port-scanning
 *                                       function to use for this
 *                                       device type.
 * @param string $ip_scanning_function    Name of the ARP/IP-scanning
 *                                       function to use for this
 *                                       device type.
 * @param string $dot1x_scanning_function Name of the 802.1x-scanning
 *                                       function to use for this
 *                                       device type.
 * @param string $serial_number_oid       SNMP OID used to retrieve the
 *                                       device's serial number.
 * @param string $lowPort                 Lowest port number to include
 *                                       when scanning.
 * @param string $highPort                Highest port number to
 *                                       include when scanning.
 * @param string $disabled                Whether this device type is
 *                                       disabled.
 *
 * @return int The saved device_type_id, or 0 if validation/save
 *             failed.
 */
function api_mactrack_device_type_save($device_type_id, $description,
	$vendor, $device_type, $sysDescr_match, $sysObjectID_match, $scanning_function,
	$ip_scanning_function, $dot1x_scanning_function, $serial_number_oid, $lowPort, $highPort, $disabled): int {
	$save['device_type_id']          = $device_type_id;
	$save['description']             = form_input_validate($description, 'description', '', false, 3);
	$save['vendor']                  = $vendor;
	$save['device_type']             = $device_type;
	$save['sysDescr_match']          = form_input_validate($sysDescr_match, 'sysDescr_match', '', true, 3);
	$save['sysObjectID_match']       = form_input_validate($sysObjectID_match, 'sysObjectID_match', '', true, 3);
	$save['serial_number_oid']       = form_input_validate($serial_number_oid, 'serial_number_oid', '', true, 3);
	$save['scanning_function']       = form_input_validate($scanning_function, 'scanning_function', '', true, 3);
	$save['ip_scanning_function']    = form_input_validate($ip_scanning_function, 'ip_scanning_function', '', true, 3);
	$save['dot1x_scanning_function'] = form_input_validate($dot1x_scanning_function, 'dot1x_scanning_function', '', true, 3);
	$save['lowPort']                 = form_input_validate($lowPort, 'lowPort', '', true, 3);
	$save['highPort']                = form_input_validate($highPort, 'highPort', '', true, 3);
	$save['disabled']                = $disabled ? 'on' : '';

	$device_type_id = 0;

	if (!is_error_message()) {
		$device_type_id = sql_save($save, 'mac_track_device_types', 'device_type_id');

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

	return $device_type_id;
}

/**
 * Duplicates a device type record, prefixing its sysDescr/sysObjectID
 * match patterns with a '--dup--' marker (so the copy won't
 * auto-match devices until edited) and building a new description from
 * the given title template.
 *
 * @param int    $device_type_id     The device type id to duplicate; a
 *                                  no-op if empty.
 * @param int    $dup_id             A numeric suffix used to build the
 *                                  new description when
 *                                  $device_type_title doesn't contain
 *                                  the '<description>' token.
 * @param string $device_type_title  The new description, or a template
 *                                  containing the literal
 *                                  '<description>' token to be replaced
 *                                  with "{original description}(1)".
 *
 * @return void
 */
function api_mactrack_duplicate_device_type($device_type_id, $dup_id, $device_type_title): void {
	if (!empty($device_type_id)) {
		$device_type = (array) db_fetch_row_prepared('SELECT *
			FROM mac_track_device_types
			WHERE device_type_id = ?',
			[$device_type_id]);

		// create new entry: graph_local
		$save['device_type_id'] = 0;

		if (substr_count($device_type_title, '<description>')) {
			$save['description'] = $device_type['description'] . '(1)';
		} else {
			$save['description'] = $device_type_title . '(' . $dup_id . ')';
		}

		$save['vendor']                  = $device_type['vendor'];
		$save['device_type']             = $device_type['device_type'];
		$save['sysDescr_match']          = __('--dup--', 'mactrack') . $device_type['sysDescr_match'];
		$save['sysObjectID_match']       = __('--dup--', 'mactrack') . $device_type['sysObjectID_match'];
		$save['scanning_function']       = $device_type['scanning_function'];
		$save['ip_scanning_function']    = $device_type['ip_scanning_function'];
		$save['dot1x_scanning_function'] = $device_type['dot1x_scanning_function'];
		$save['lowPort']                 = $device_type['lowPort'];
		$save['highPort']                = $device_type['highPort'];
		$save['disabled']                = $device_type['disabled'];

		$device_type_id = sql_save($save, 'mac_track_device_types', ['device_type_id']);
	}
}

/* ------------------------
	The 'actions' function
   ------------------------ */

/**
 * Handles the bulk-action confirmation page/submission for the device
 * types list (delete and duplicate): on confirmed submission with
 * selected_items set, performs the requested action for each selected
 * device type; on first display, renders a confirmation box listing
 * the selected device types (with an optional description prefix
 * field for the duplicate action). Called from this script's main
 * request-dispatch switch when action=actions.
 *
 * @return void
 *
 * @global array $config                              Cacti global
 *                                                    configuration
 *                                                    array (declared
 *                                                    but not used
 *                                                    directly here).
 * @global array $device_types_actions                Map of drp_action
 *                                                    value => action
 *                                                    label, used for
 *                                                    the bulk-actions
 *                                                    confirmation
 *                                                    display.
 * @global array $fields_mactrack_device_types_edit   Reserved/declared
 *                                                    for parity with
 *                                                    other functions in
 *                                                    this file; not
 *                                                    used directly
 *                                                    here.
 */
function form_actions(): void {
	global $config, $device_types_actions, $fields_mactrack_device_types_edit;

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

	// 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) {
			if (get_request_var('drp_action') == '1') { // delete
				for ($i = 0; $i < cacti_sizeof($selected_items); $i++) {
					api_mactrack_device_type_remove($selected_items[$i]);
				}
			} elseif (get_nfilter_request_var('drp_action') == '2') { // duplicate
				for ($i = 0; ($i < cacti_sizeof($selected_items)); $i++) {
					api_mactrack_duplicate_device_type($selected_items[$i], $i, get_request_var('title_format'));
				}
			}

			header('Location: mactrack_device_types.php');
			exit;
		}
	}

	// setup some variables
	$device_types_list = '';
	$i                 = 0;

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

			$device_types_info = (array) db_fetch_row_prepared('SELECT description
				FROM mac_track_device_types
				WHERE device_type_id = ?',
				[$matches[1]]);

			$device_types_list .= '<li>' . $device_types_info['description'] . '</li>';
			$device_types_array[$i] = $matches[1];
			$i++;
		}
	}

	top_header();

	form_start('mactrack_device_types.php');

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

	if (!isset($device_types_array)) {
		print "<tr><td class='even'><span class='textError'>" . __('You must select at least one device type.', 'mactrack') . "</span></td></tr>\n";
		$save_html = '';
	} else {
		$save_html = "<button type='submit' name='save' class='ui-button ui-corner-all ui-widget ui-state-active'>" . __esc('Continue', 'mactrack') . '</button>';

		if (get_request_var('drp_action') == '1') { // delete
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to delete the following Device Type(s).', 'mactrack') . "</p>
					<ul>$device_types_list</ul>
				</td>
			</tr>";
		} elseif (get_request_var('drp_action') == '2') { // duplicate
			print "<tr>
				<td class='textArea'>
					<p>" . __('Click \'Continue\' to duplicate the following Device Type(s). You may optionally change the description for the new device types.  Otherwise, do not change value below and the original name will be replicated with a new suffix.', 'mactrack') . "</p>
					<ul>$device_types_list</ul>
					<p>" . __('Device Type Prefix:', 'mactrack') . '<br>';
			form_text_box('title_format', __('<description> (1)', 'mactrack'), '', '255', '30', 'text');
			print '</p>
				</td>
			</tr>';
		}
	}

	print "<tr>
		<td colspan='2' align='right' class='saveRow'>
			<input type='hidden' name='action' value='actions'>
			<input type='hidden' name='selected_items' value='" . (isset($device_types_array) ? serialize($device_types_array) : '') . "'>
			<input type='hidden' name='drp_action' value='" . get_nfilter_request_var('drp_action') . "'>" . ($save_html != '' ? "
			<button type='button' class='ui-button ui-corner-all ui-widget' onClick='cactiReturnTo()' name='cancel'>" . __esc('Cancel', 'mactrack') . "</button>
			$save_html" : "<button type='button' class='ui-button ui-corner-all ui-widget' onClick='cactiReturnTo()' name='cancel'>" . __esc('Return') . '</button>') . '
		</td>
	</tr>';

	html_end_box();

	form_end();

	bottom_footer();
}

/* ---------------------
	Mactrack Device Type Functions
   --------------------- */

/**
 * Validates and stores this view's filter request variables (rows,
 * page, scan type id, enabled flag, vendor, filter text, sort
 * column/direction) into the session for the device types list view.
 *
 * @return void
 */
function mactrack_device_type_request_validation(): void {
	// ================= input validation and session storage =================
	$filters = [
		'rows' => [
			'filter'  => FILTER_VALIDATE_INT,
			'pageset' => true,
			'default' => '-1'
			],
		'page' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '1'
			],
		'type_id' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-1',
			'pageset' => true
			],
		'enabled' => [
			'filter'  => FILTER_VALIDATE_INT,
			'default' => '-1',
			'pageset' => true
			],
		'vendor' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => 'All',
			'options' => ['options' => 'sanitize_search_string']
			],
		'filter' => [
			'filter'  => FILTER_CALLBACK,
			'pageset' => true,
			'default' => '',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_column' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'description',
			'options' => ['options' => 'sanitize_search_string']
			],
		'sort_direction' => [
			'filter'  => FILTER_CALLBACK,
			'default' => 'ASC',
			'options' => ['options' => 'sanitize_search_string']
			]
	];

	validate_store_request_vars($filters, 'sess_mt_devicet');
}

/**
 * Exports the current filtered device types list (with detection
 * patterns, scanning functions, port range, and disabled flag) as a
 * downloaded CSV file. Called from this script's main
 * request-dispatch switch when action=export.
 *
 * @return void
 *
 * @global array $device_actions          Reserved/declared for parity
 *                                       with other functions in this
 *                                       file; not used directly here.
 * @global array $mactrack_device_types  Reserved/declared for parity
 *                                       with other functions in this
 *                                       file; not used directly here.
 * @global array $config                 Cacti global configuration
 *                                       array (declared but not used
 *                                       directly here).
 */
function mactrack_device_type_export(): void {
	global $device_actions, $mactrack_device_types, $config;

	mactrack_device_type_request_validation();

	$sql_where = '';

	$device_types = mactrack_get_device_types($sql_where, 0, false);

	$xport_array = [];
	array_push($xport_array, '"vendor","description","device_type",' .
		'"sysDescr_match","sysObjectID_match","scanning_function","ip_scanning_function",' .
		'"dot1x_scanning_function","serial_number_oid","lowPort","highPort","disabled"');

	if (cacti_sizeof($device_types)) {
		foreach ($device_types as $device_type) {
			array_push($xport_array,'"' . $device_type['vendor'] . '","' .
			$device_type['description'] . '","' .
			$device_type['device_type'] . '","' .
			$device_type['sysDescr_match'] . '","' .
			$device_type['sysObjectID_match'] . '","' .
			$device_type['scanning_function'] . '","' .
			$device_type['ip_scanning_function'] . '","' .
			$device_type['dot1x_scanning_function'] . '","' .
			$device_type['serial_number_oid'] . '","' .
			$device_type['lowPort'] . '","' .
			$device_type['highPort'] . '","' .
			$device_type['disabled'] . '"');
		}
	}

	header('Content-type: application/csv');
	header('Content-Disposition: attachment; filename=cacti_device_type_xport.csv');

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

/**
 * Scans all known devices' SNMP sysDescr/sysObjectID values for
 * combinations not matched by any existing device type, and creates
 * new (initially generic/"Unknown") device type records for each
 * distinct unmatched combination found, with basic Cisco-specific name
 * extraction when applicable. Prints a summary of how many new device
 * types were added.
 *
 * @return void
 */
function mactrack_rescan_device_types(): void {
	global $cnn_id;

	// let's allocate an array for results
	$insert_array = [];

	// get all the various device types from the database
	$device_types = db_fetch_assoc("SELECT DISTINCT snmp_sysObjectID, snmp_sysDescr, device_type_id
		FROM mac_track_devices
		WHERE snmp_sysObjectID!='' AND snmp_sysDescr!=''");

	// get all known devices types from the device type database
	$known_types = db_fetch_assoc('SELECT sysDescr_match, sysObjectID_match FROM mac_track_device_types');

	// loop through all device rows and look for a matching type
	if (cacti_sizeof($device_types)) {
		foreach ($device_types as $type) {
			$found = false;

			if (cacti_sizeof($known_types)) {
				foreach ($known_types as $known) {
					if ((substr_count($type['snmp_sysDescr'], $known['sysDescr_match'])) &&
						(substr_count($type['snmp_sysObjectID'], $known['sysObjectID_match']))) {
						$found = true;

						break;
					}
				}
			}

			if (!$found) {
				$insert_array[] = $type;
			}
		}
	}

	if (cacti_sizeof($insert_array)) {
		foreach ($insert_array as $item) {
			$desc = trim($item['snmp_sysDescr']);
			$name = __('New Type', 'mactrack');

			if (substr_count(strtolower($desc), 'cisco')) {
				$vendor    = __('Cisco', 'mactrack');
				$temp_name = str_replace('(tm)', '', $desc);
				$pos       = strpos($temp_name, '(');

				if ($pos > 0) {
					$pos2 = strpos($temp_name, ')');

					if ($pos2 > $pos) {
						$desc = substr($temp_name, $pos + 1, $pos2 - $pos - 1);

						$name = $desc . ' (' . $item['device_type_id'] . ')';
					}
				}
			} else {
				$vendor = __('Unknown', 'mactrack');
			}

			db_execute('REPLACE INTO mac_track_device_types
				(description, vendor, device_type, sysDescr_match, sysObjectID_match)
				VALUES (' .
					db_qstr($name) . ',' .
					db_qstr($vendor) . ',' .
					db_qstr($item['device_type']) . ',' .
					db_qstr($desc) . ',' .
					db_qstr($item['snmp_sysObjectID']) . ')');
		}

		print __('There were %d Device Types Added!', cacti_sizeof($insert_array), 'mactrack');
	} else {
		print __('No New Device Types Found!', 'mactrack');
	}
}

/**
 * Renders the device type CSV import page: displays results from a
 * previous import attempt (if any, stashed in the session by
 * form_save()), and the file upload form. Called from this script's
 * main request-dispatch switch when action=import.
 *
 * @return void
 *
 * @global array $config Cacti global configuration array (declared but
 *                       not used directly here).
 */
function mactrack_device_type_import(): void {
	global $config;

	?><form method='post' action='mactrack_device_types.php?action=import' enctype='multipart/form-data'><?php

	if ((isset($_SESSION['import_debug_info'])) && (is_array($_SESSION['import_debug_info']))) {
		html_start_box(__('Import Results', 'mactrack'), '100%', '', '3', 'center', '');

		print "<tr class='even'><td><p class='textArea'>" . __('Cacti has imported the following items:', 'mactrack') . '</p>';

		foreach ($_SESSION['import_debug_info'] as $import_result) {
			print "<tr class='even'><td>" . $import_result . '</td>';
			print '</tr>';
		}

		html_end_box();

		kill_session_var('import_debug_info');
	}

	html_start_box(__('Import Mactrack Device Types', 'mactrack'), '100%', '', '3', 'center', '');

	form_alternate_row(); ?>
		<td width='50%'><font class='textEditTitle'><?php print __('Import Device Types from Local File', 'mactrack'); ?></font><br>
			<?php print __('Please specify the location of the CSV file containing your device type information.', 'mactrack'); ?>
		</td>
		<td align='left'>
			<input type='file' name='import_file'>
		</td>
	</tr><?php
	form_alternate_row(); ?>
		<td width='50%'><font class='textEditTitle'><?php print __('Overwrite Existing Data?', 'mactrack'); ?></font><br>
			<?php print __('Should the import process be allowed to overwrite existing data?  Please note, this does not mean delete old row, only replace duplicate rows.', 'mactrack'); ?>
		</td>
		<td align='left'>
			<input type='checkbox' name='allow_update' id='allow_update'><?php print __('Allow Existing Rows to be Updated?', 'mactrack'); ?>
		</td><?php

	html_end_box(false);

	html_start_box(__('Required File Format Notes', 'mactrack'), '100%', '', '3', 'center', '');

	form_alternate_row(); ?>
		<td><strong><?php print __('The file must contain a header row with the following column headings.', 'mactrack'); ?></strong>
			<br><br>
			<strong>description</strong><?php print __(' - A common name for the device.  For example Cisco 6509 Switch', 'mactrack'); ?><br>
			<strong>vendor</strong><?php print __(' - The vendor who produces this device', 'mactrack'); ?><br>
			<strong>device_type</strong><?php print __(' - The type of device this is.  See the notes below for this integer value', 'mactrack'); ?><br>
			<strong>sysDescr_match</strong><?php print __(' - A unique set of characters from the snmp sysDescr that uniquely identify this device', 'mactrack'); ?><br>
			<strong>sysObjectID_match</strong><?php print __(' - The vendor specific snmp sysObjectID that distinguishes this device from the next', 'mactrack'); ?><br>
			<strong>scanning_function</strong><?php print __(' - The scanning function that will be used to scan this device type', 'mactrack'); ?><br>
			<strong>ip_scanning_function</strong><?php print __(' - The IP scanning function that will be used to scan this device type', 'mactrack'); ?><br>
			<strong>dot1x_scanning_function</strong><?php print __(' - The 802.1x scanning function that will be used to scan this device type', 'mactrack'); ?><br>
			<strong>serial_number_oid</strong><?php print __(' - If the Serial Number for this device type can be obtained via an SNMP Query, add it\'s OID here', 'mactrack'); ?><br>
			<strong>lowPort</strong><?php print __(' - If your scanning function does not have the ability to isolate trunk ports or link ports, this is the starting port number for user ports', 'mactrack'); ?><br>
			<strong>highPort</strong><?php print __(' - Same as the lowPort with the exception that this is the high numbered user port number', 'mactrack'); ?><br>
			<strong>disabled</strong><?php print __(' - Disabled type is not used', 'mactrack'); ?><br>
			<br>
			<strong><?php print __('The primary key for this table is a combination of the following three fields:', 'mactrack'); ?></strong>
			<br><br>
			device_type, sysDescr_match, sysObjectID_match
			<br><br>
			<strong><?php print __('Therefore, if you attempt to import duplicate device types, the existing data will be updated with the new information.', 'mactrack'); ?></strong>
			<br><br>
			<strong>device_type</strong><?php print __(' is an integer field and must be one of the following:', 'mactrack'); ?>
			<br><br>
			<?php print __('1 - Switch/Hub', 'mactrack'); ?><br>
			<?php print __('2 - Switch/Router', 'mactrack'); ?><br>
			<?php print __('3 - Router', 'mactrack'); ?><br>
			<br>
			<strong><?php print __('The devices device type is determined by scanning it\'s snmp agent for the sysObjectID and sysDescription and comparing it against values in the device types database.  The first match that is found in the database is used as to how to scan it.  Therefore, it is very important that you select valid sysObjectID_match, sysDescr_match, and scanning function for your devices.', 'mactrack'); ?></strong>
			<br>
		</td>
	</tr><?php

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

	html_end_box();

	form_save_button('return', 'import');
}

/**
 * Parses an uploaded CSV file's rows (vendor, description, device
 * type, detection patterns, scanning functions, port range, disabled
 * flag) and saves each as a MacTrack device type via
 * api_mactrack_device_type_save().
 *
 * @param array &$device_types The raw CSV file lines (first line is
 *                            the header row).
 *
 * @return array A list of human-readable per-row result messages
 *               describing what was imported.
 */
function mactrack_device_type_import_processor(&$device_types): array {
	$i              = 0;
	$return_array   = [];
	/** @var list<int> $insert_columns */
	$insert_columns = [];

	$save_order           = '(';
	$update_suffix        = '';
	/** @var int $device_type_id */
	$device_type_id       = -1;
	/** @var int $sysDescr_match_id */
	$sysDescr_match_id    = -1;
	/** @var int $sysObjectID_match_id */
	$sysObjectID_match_id = -1;
	/** @var int $save_vendor_id */
	$save_vendor_id       = -1;
	/** @var int $save_description_id */
	$save_description_id   = -1;

	$device_type_array[1] = __('Switch/Hub', 'mactrack');
	$device_type_array[2] = __('Switch/Router', 'mactrack');
	$device_type_array[3] = __('Router', 'mactrack');

	foreach ($device_types as $device_type) {
		// parse line
		$line_array = explode(',', $device_type);

		// header row
		if ($i == 0) {
			$save_order           = '(';
			$j                    = 0;
			$first_column         = true;
			$update_suffix        = '';
			$required             = 0;
			$sysDescr_match_id    = -1;
			$sysObjectID_match_id = -1;
			$device_type_id       = -1;
			$save_vendor_id       = -1;
			$save_description_id  = -1;

			foreach ($line_array as $line_item) {
				$line_item = trim(str_replace("'", '', $line_item));
				$line_item = trim(str_replace('"', '', $line_item));

				switch ($line_item) {
					case 'device_type':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$device_type_id = $j;
						$required++;

						$save_order .= $line_item;
						$insert_columns[] = $j;
						$first_column     = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					case 'sysDescr_match':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$sysDescr_match_id = $j;
						$required++;

						$save_order .= $line_item;
						$insert_columns[] = $j;
						$first_column     = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					case 'sysObjectID_match':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$sysObjectID_match_id = $j;
						$required++;

						$save_order .= $line_item;
						$insert_columns[] = $j;
						$first_column     = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					case 'scanning_function':
					case 'ip_scanning_function':
					case 'dot1x_scanning_function':
					case 'serial_number_oid':
					case 'lowPort':
					case 'highPort':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$save_order .= $line_item;
						$insert_columns[] = $j;
						$first_column     = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					case 'vendor':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$save_order .= $line_item;
						$insert_columns[] = $j;
						$save_vendor_id   = $j;
						$first_column     = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					case 'description':
						if (!$first_column) {
							$save_order .= ', ';
						}

						$save_order .= $line_item;
						$insert_columns[]    = $j;
						$save_description_id = $j;
						$first_column        = false;

						if ($update_suffix != '') {
							$update_suffix .= ", $line_item=VALUES($line_item)";
						} else {
							$update_suffix .= " ON DUPLICATE KEY UPDATE $line_item=VALUES($line_item)";
						}

						break;
					default:
						// ignore unknown columns
				}

				$j++;
			}

			$save_order .= ')';

			if ($required >= 3) {
				array_push($return_array, __('HEADER LINE PROCESSED OK:  <br>Columns found where: %s', $save_order, 'mactrack') . '<br>');
			} else {
				array_push($return_array, __('HEADER LINE PROCESSING ERROR: Missing required field <br>Columns found where: %s', $save_order, 'mactrack') . '<br>');

				break;
			}
		} else {
			$sysDescr_match    = '';
			$sysObjectID_match = '';
			$vendor            = '';
			$description       = '';
			$save_value   = '(';
			/** @var int $j */
			$j            = 0;
			$first_column = true;
			$sql_where    = '';

			foreach ($line_array as $line_item) {
				if (in_array($j, $insert_columns, true)) {
					$line_item = trim(str_replace('"', '', $line_item));

					if (!$first_column) {
						$save_value .= ',';
					} else {
						$first_column = false;
					}

					if ($j == $device_type_id || $j == $sysDescr_match_id || $j == $sysObjectID_match_id) {
						if ($sql_where != '') {
							switch($j) {
								case $device_type_id:
									$sql_where .= ' AND device_type=' . db_qstr($line_item);

									break;
								case $sysDescr_match_id:
									$sql_where .= ' AND sysDescr_match=' . db_qstr($line_item);

									break;
								case $sysObjectID_match_id:
									$sql_where .= ' AND sysObjectID_match=' . db_qstr($line_item);

									break;
								default:
									// do nothing
							}
						} else {
							switch($j) {
								case $device_type_id:
									$sql_where .= 'WHERE device_type=' . db_qstr($line_item);

									break;
								case $sysDescr_match_id:
									$sql_where .= 'WHERE sysDescr_match=' . db_qstr($line_item);

									break;
								case $sysObjectID_match_id:
									$sql_where .= 'WHERE sysObjectID_match=' . db_qstr($line_item);

									break;
								default:
									// do nothing
							}
						}
					}

					if ($j == $device_type_id) {
						if (isset($device_type_array[$line_item])) {
							$device_type = $device_type_array[$line_item];
						} else {
							$device_type = __('Unknown Assume "Switch/Hub"', 'mactrack');
							$line_item   = 1;
						}
					}

					if ($j == $sysDescr_match_id) {
						$sysDescr_match = $line_item;
					}

					if ($j == $sysObjectID_match_id) {
						$sysObjectID_match = $line_item;
					}

					if ($j == $save_vendor_id) {
						$vendor = $line_item;
					}

					if ($j == $save_description_id) {
						$description = $line_item;
					}

					$save_value .= db_qstr($line_item);
				}

				$j++;
			}

			$save_value .= ')';

			if ($j > 0) {
				if (isset_request_var('allow_update')) {
					$sql_execute = 'INSERT INTO mac_track_device_types ' . $save_order .
						' VALUES' . $save_value . $update_suffix;

					if (db_execute($sql_execute)) {
						array_push($return_array, __('INSERT SUCCEEDED: Vendor: %s, Description: %s, Type: %s, sysDescr: %s, sysObjectID: %s', $vendor, $description, $device_type, $sysDescr_match, $sysObjectID_match, 'mactrack'));
					} else {
						array_push($return_array, __('INSERT FAILED: Vendor: %s, Description: %s, Type: %s, sysDescr: %s, sysObjectID: %s', $vendor, $description, $device_type, $sysDescr_match, $sysObjectID_match, 'mactrack'));
					}
				} else {
					// perform check to see if the row exists
					$existing_row = db_fetch_row("SELECT * FROM mac_track_device_types $sql_where");

					if (cacti_sizeof($existing_row)) {
						array_push($return_array, __('INSERT SKIPPED, EXISTING: Vendor: %s, Description: %s, Type: %s, sysDescr: %s, sysObjectID: %s', $vendor, $description, $device_type, $sysDescr_match, $sysObjectID_match, 'mactrack'));
					} else {
						$sql_execute = 'INSERT INTO mac_track_device_types ' . $save_order .
							' VALUES' . $save_value;

						if (db_execute($sql_execute)) {
							array_push($return_array, __('INSERT SUCCEEDED: Vendor: %s, Description: %s, Type: %s, sysDescr: %s, sysObjectID: %s', $vendor, $description, $device_type, $sysDescr_match, $sysObjectID_match, 'mactrack'));
						} else {
							array_push($return_array, __('INSERT FAILED: Vendor: %s, Description: %s, Type: %s, sysDescr: %s, sysObjectID: %s', $vendor, $description, $device_type, $sysDescr_match, $sysObjectID_match, 'mactrack'));
						}
					}
				}
			}
		}

		$i++;
	}

	return $return_array;
}

/**
 * Renders the add/edit form for a device type (description, vendor,
 * detection patterns, scanning functions, port range, disabled flag).
 * Called from this script's main request-dispatch switch when
 * action=edit.
 *
 * @return void
 *
 * @global array $config                            Cacti global
 *                                                  configuration array
 *                                                  (declared but not
 *                                                  used directly here).
 * @global array $fields_mactrack_device_type_edit  The device type
 *                                                  edit form's field
 *                                                  definitions.
 */
function mactrack_device_type_edit(): void {
	global $config, $fields_mactrack_device_type_edit;

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

	if (!isempty_request_var('device_type_id')) {
		$device_type = (array) db_fetch_row_prepared('SELECT *
			FROM mac_track_device_types
			WHERE device_type_id = ?',
			[get_request_var('device_type_id')]);

		$header_label = __('Mactrack Device Types [edit: %s]', $device_type['description'], 'mactrack');
	} else {
		$header_label = __('Mactrack Device Types [new]', 'mactrack');
	}

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

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

	draw_edit_form(
		[
			'config' => ['no_form_tag' => 'true'],
			'fields' => inject_form_variables($fields_mactrack_device_type_edit, ($device_type ?? []))
		]
	);

	html_end_box();

	form_save_button('mactrack_device_types.php', 'return', 'device_type_id');
}

/**
 * Builds and executes the SQL query for the device types list view,
 * applying the current scan type, enabled flag, vendor, and filter
 * text request variables, sort order, and optional row limits.
 *
 * @param string &$sql_where   Receives the generated SQL WHERE clause.
 * @param int    $rows         Number of rows per page, used to compute
 *                            the SQL LIMIT clause when $apply_limits
 *                            is true.
 * @param bool   $apply_limits Whether to apply a SQL LIMIT clause
 *                            (default true).
 *
 * @return array The matching device type records.
 */
function mactrack_get_device_types(&$sql_where, $rows, $apply_limits = true): array {
	if (get_request_var('filter') != '') {
		$sql_where = ' WHERE (mtdt.vendor LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mtdt.description LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mtdt.sysDescr_match LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR
			mtdt.sysObjectID_match LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
	}

	if (get_request_var('vendor') == 'All') {
		// Show all items
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : ' WHERE ') . 'mtdt.vendor = ' . db_qstr(get_request_var('vendor'));
	}

	if (get_request_var('type_id') == '-1') {
		// Show all items
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : ' WHERE ') . '(mtdt.device_type=' . get_filter_request_var('type_id') . ')';
	}

	if (get_request_var('enabled') == '-1') {
		// Show all items
	} else {
		$sql_where .= ($sql_where != '' ? ' AND ' : ' WHERE ') . '(mtdt.disabled=' . (get_request_var('enabled') == 1 ? "''" : "'on'") . ')';
	}

	$sql_order = get_order_string();

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

	$query_string = "SELECT *
		FROM mac_track_device_types AS mtdt
		$sql_where
		$sql_order
		$sql_limit";

	return db_fetch_assoc($query_string);
}

/**
 * Renders the main device types list page: validates/stores this
 * view's filter request variables, displays the device type filter
 * form, then displays a filtered, sorted, paginated table of device
 * types with a bulk-actions dropdown. Called from this script's main
 * request-dispatch switch as the default view.
 *
 * @return void
 *
 * @global array $device_types_actions   Map of drp_action value =>
 *                                      action label, used for the
 *                                      bulk-actions dropdown.
 * @global array $mactrack_device_types  Reserved/declared for parity
 *                                      with other functions in this
 *                                      file; not used directly here.
 * @global array $config                 Cacti global configuration
 *                                      array (declared but not used
 *                                      directly here).
 * @global array $item_rows              Default number of rows per
 *                                      page from Cacti settings.
 */
function mactrack_device_type(): void {
	global $device_types_actions, $mactrack_device_types, $config, $item_rows;

	mactrack_device_type_request_validation();

	$rows = plugin_get_rows_per_page();

	html_start_box(__('Mactrack Device Type Filters', 'mactrack'), '100%', '', '3', 'center', 'mactrack_device_types.php?action=edit');
	mactrack_device_type_filter();
	html_end_box();

	$sql_where = '';

	$device_types = mactrack_get_device_types($sql_where, $rows);

	$total_rows = db_fetch_cell('SELECT
		COUNT(mtdt.device_type_id)
		FROM mac_track_device_types mtdt ' . $sql_where);

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

	$display_text = [
		'description'             => [__('Device Type Description', 'mactrack'), 'ASC'],
		'vendor'                  => [__('Devices', 'mactrack'), 'DESC'],
		'device_type'             => [__('Device Type', 'mactrack'), 'DESC'],
		'scanning_function'       => [__('Port Scanner', 'mactrack'), 'ASC'],
		'ip_scanning_function'    => [__('IP Scanner', 'mactrack'), 'ASC'],
		'dot1x_scanning_function' => [__('Dot1x Scanner', 'mactrack'), 'ASC'],
		'sysDescr_match'          => [__('sysDescription Match', 'mactrack'), 'DESC'],
		'sysObjectID_match'       => [__('Vendor OID Match', 'mactrack'), 'DESC'],
		'disabled'                => [__('Disabled', 'mactrack'), 'DESC']
	];

	$columns = cacti_sizeof($display_text) + 1;

	$nav = html_nav_bar('mactrack_device_types.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, $columns, __('Device Types', 'mactrack'), 'page', 'main');

	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($device_types)) {
		foreach ($device_types as $device_type) {
			form_alternate_row('line' . $device_type['device_type_id'], true);
			form_selectable_cell('<a class="linkEditMain" href="mactrack_device_types.php?action=edit&device_type_id=' . $device_type['device_type_id'] . '">' . $device_type['description'] . '</a>', $device_type['device_type_id']);
			form_selectable_cell($device_type['vendor'], $device_type['device_type_id']);
			form_selectable_cell($mactrack_device_types[$device_type['device_type']], $device_type['device_type_id']);

			if (!empty($device_type['scanning_function'])) {
				$function = $device_type['scanning_function'];
			} else {
				$function = __('N/A', 'mactrack');
			}
			form_selectable_cell($function, $device_type['device_type_id']);

			if (!empty($device_type['ip_scanning_function'])) {
				$function = $device_type['ip_scanning_function'];
			} else {
				$function = __('N/A', 'mactrack');
			}
			form_selectable_cell($function, $device_type['device_type_id']);

			if (!empty($device_type['dot1x_scanning_function'])) {
				$function = $device_type['dot1x_scanning_function'];
			} else {
				$function = __('N/A', 'mactrack');
			}
			form_selectable_cell($function, $device_type['device_type_id']);

			form_selectable_cell($device_type['sysDescr_match'], $device_type['device_type_id']);
			form_selectable_cell($device_type['sysObjectID_match'], $device_type['device_type_id']);
			form_selectable_cell($device_type['disabled'] != '' ? __('Yes') : __('No'), $device_type['device_type_id']);
			form_checkbox_cell($device_type['description'], $device_type['device_type_id']);
			form_end_row();
		}
	} else {
		print '<tr><td colspan="' . $columns . '"><em>' . __('No Mactrack Device Types Found', 'mactrack') . '</em></td></tr>';
	}

	html_end_box(false);

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

	draw_actions_dropdown($device_types_actions);

	form_end();
}

/**
 * Renders the search/vendor/scan-type/enabled filter form controls for
 * the device types list view.
 *
 * @return void
 *
 * @global array $item_rows Cacti's standard row-count option list,
 *                         used to populate the rows dropdown.
 */
function mactrack_device_type_filter(): void {
	global $item_rows;

	?>
	<tr class='even'>
		<td>
		<form id='mactrack'>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Search', 'mactrack'); ?>
					</td>
					<td>
						<input type='text' id='filter' size='25' value='<?php print html_escape_request_var('filter'); ?>'>
					</td>
					<td>
						<?php print __('Device Types', 'mactrack'); ?>
					</td>
					<td>
						<select id='rows' onChange='applyFilter()'>
							<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'mactrack'); ?></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 class='nowrap'>
							<button type='submit' id='go' class='ui-button ui-corner-all ui-widget ui-state-active' title='<?php print __esc('Submit Query'); ?>'><?php print __esc('Go'); ?></button>
							<button type='button' id='clear' class='ui-button ui-corner-all ui-widget' title='<?php print __esc('Clear Filtered Results'); ?>'><?php print __esc('Clear'); ?></button>
							<button type='button' id='scan' class='ui-button ui-corner-all ui-widget' title='<?php print __esc('Scan Active Devices for Unknown Device Types'); ?>'><?php print __esc('Rescan'); ?></button>
							<button type='button' id='import' class='ui-button ui-corner-all ui-widget' title='<?php print __esc('Import Device Types from a CSV File'); ?>'><?php print __esc('Import'); ?></button>
							<button type='button' id='export' class='ui-button ui-corner-all ui-widget' title='<?php print __esc('Export Device Types to Share with Others'); ?>'><?php print __esc('Export'); ?></button>
						</span>
					</td>
					<td>
						<span id="text" style="display:none;"></span>
					</td>
				</tr>
			</table>
			<table class='filterTable'>
				<tr>
					<td>
						<?php print __('Vendor', 'mactrack'); ?>
					</td>
					<td>
						<select id='vendor' onChange='applyFilter()'>
							<option value='All'<?php if (get_request_var('vendor') == 'All') {
								print ' selected';
							}?>><?php print __('All', 'mactrack'); ?></option>
							<?php
							$types = db_fetch_assoc('SELECT DISTINCT vendor from mac_track_device_types ORDER BY vendor');

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

			if (get_request_var('vendor') == $type['vendor']) {
				print ' selected';
			} print '>' . html_escape($type['vendor']) . '</option>';
		}
	}
	?>
						</select>
					</td>
					<td>
						<?php print __('Type', 'mactrack'); ?>
					</td>
					<td>
						<select id='type_id' onChange='applyFilter()'>
							<option value='-1'<?php if (get_request_var('type_id') == '-1') {
								print ' selected';
							}?>><?php print __('All', 'mactrack'); ?></option>
							<option value='1'<?php if (get_request_var('type_id') == '1') {
								print ' selected';
							}?>><?php print __('Switch/Hub', 'mactrack'); ?></option>
							<option value='2'<?php if (get_request_var('type_id') == '2') {
								print ' selected';
							}?>><?php print __('Switch/Router', 'mactrack'); ?></option>
							<option value='3'<?php if (get_request_var('type_id') == '3') {
								print ' selected';
							}?>><?php print __('Router', 'mactrack'); ?></option>
						</select>
					</td>
					<td>
						<?php print __('Enabled', 'mactrack'); ?>
					</td>
					<td>
						<select id='enabled' onChange='applyFilter()'>
							<option value='-1'<?php if (get_request_var('enabled') == '-1') {
								print ' selected';
							}?>><?php print __('All', 'mactrack'); ?></option>
							<option value='1'<?php if (get_request_var('enabled') == '1') {
								print ' selected';
							}?>><?php print __('Yes', 'mactrack'); ?></option>
							<option value='2'<?php if (get_request_var('enabled') == '2') {
								print ' selected';
							}?>><?php print __('No', 'mactrack'); ?></option>
						</select>
					</td>

				</tr>
			</table>
			<script type='text/javascript' <?php print plugin_mactrack_csp_nonce(); ?>>
			function applyFilter(myFunc) {
				strURL  = urlPath+'plugins/mactrack/mactrack_device_types.php?header=false';
				strURL += '&vendor=' + $('#vendor').val();
				strURL += '&type_id=' + $('#type_id').val();
				strURL += '&enabled=' + $('#enabled').val();
				strURL += '&filter=' + $('#filter').val();
				strURL += '&rows=' + $('#rows').val();
				loadPageNoHeader(strURL);
			}

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

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

			function importRows() {
				strURL  = urlPath+'plugins/mactrack/mactrack_device_types.php?import=true';
				loadPageNoHeader(strURL);
			}

			function scanDeviceType() {
				strURL  = urlPath+'plugins/mactrack/mactrack_device_types.php?scan=true';
				$.get(strURL, function(data) {
					var message = data;
					applyFilter();
				});
			}

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

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

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

				$('#import').on('click', function() {
					importRows();
				});

				$('#scan').on('click', function() {
					scanDeviceType();
				});
			});
			</script>
		</form>
		</td>
	</tr>
	<?php
}