function mactrack_site()
{
global $site_actions, $config, $item_rows;
mactrack_site_validate_req_vars();
if (get_request_var('rows') == -1) {
$row_limit = read_config_option('num_rows_table');
} elseif (get_request_var('rows') == -2) {
$row_limit = 999999;
} else {
$row_limit = get_request_var('rows');
}
html_start_box(__('MacTrack Site Filters'), '100%', '', '3', 'center', 'mactrack_sites.php?action=edit');
mactrack_site_filter();
html_end_box();
$sql_where = '';
$sites = mactrack_site_get_site_records($sql_where, $row_limit);
if (get_request_var('detail') == 'false') {
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(mac_track_sites.site_id)\n\t\t\tFROM mac_track_sites\n\t\t\t{$sql_where}");
} else {
$total_rows = db_fetch_cell("SELECT count(*)\n\t\t\tFROM (mac_track_device_types\n\t\t\tRIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id))\n\t\t\tRIGHT JOIN mac_track_sites ON (mac_track_devices.site_id = mac_track_sites.site_id)\n\t\t\t{$sql_where}\n\t\t\tGROUP BY mac_track_sites.site_name, mac_track_device_types.device_type_id");
}
if (get_request_var('detail') == 'false') {
$nav = html_nav_bar('mactrack_sites.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_filter_request_var('page'), $row_limit, $total_rows, 9, __('Sites'));
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('site_name' => array(__('Site Name'), 'ASC'), 'total_devices' => array(__('Devices'), 'DESC'), 'total_ips' => array(__('Total IP\'s'), 'DESC'), 'total_user_ports' => array(__('User Ports'), 'DESC'), 'total_oper_ports' => array(__('User Ports Up'), 'DESC'), 'total_macs' => array(__('MACS Found'), 'DESC'), 'total_device_errors' => array(__('Device Errors'), 'DESC'));
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));
$i = 0;
if (sizeof($sites)) {
foreach ($sites as $site) {
form_alternate_row('line' . $site['site_id'], true);
form_selectable_cell("<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=" . $site['site_id'] . "'>" . (get_request_var('filter') != '' ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", $site['site_name']) : $site['site_name']) . '</a>', $site['site_id']);
form_selectable_cell(number_format_i18n($site['total_devices']), $site['site_id']);
form_selectable_cell(number_format_i18n($site['total_ips']), $site['site_id']);
form_selectable_cell(number_format_i18n($site['total_user_ports']), $site['site_id']);
form_selectable_cell(number_format_i18n($site['total_oper_ports']), $site['site_id']);
form_selectable_cell(number_format_i18n($site['total_macs']), $site['site_id']);
form_selectable_cell($site['total_device_errors'], $site['site_id']);
form_checkbox_cell($site['site_name'], $site['site_id']);
form_end_row();
}
} else {
print '<tr><td><em>' . __('No MacTrack Sites') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($sites)) {
print $nav;
}
} else {
$nav = html_nav_bar('mactrack_sites.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_filter_request_var('page'), $row_limit, $total_rows, 10, __('Sites'));
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('site_name' => array(__('Site Name'), 'ASC'), 'vendor' => array(__('Vendor'), 'ASC'), 'description' => array(__('Device Type'), 'DESC'), 'total_devices' => array(__('Total Devices'), 'DESC'), 'sum_ips_total' => array(__('Total IP\'s'), 'DESC'), 'sum_ports_total' => array(__('Total User Ports'), 'DESC'), 'sum_ports_active' => array(__('Total Oper Ports'), 'DESC'), 'sum_ports_trunk' => array(__('Total Trunks'), 'DESC'), 'sum_macs_active' => array(__('MACS Found'), 'DESC'));
html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));
if (sizeof($sites)) {
foreach ($sites as $site) {
form_alternate_row();
?>
<td width=200>
<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=<?php
print $site['site_id'];
?>
'><?php
print get_request_var('filter') != '' ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", $site['site_name']) : $site['site_name'];
?>
</a>
</td>
<td><?php
print get_request_var('filter') != '' ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", $site['vendor']) : $site['vendor'];
?>
</td>
<td><?php
print get_request_var('filter') != '' ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", $site['description']) : $site['description'];
?>
</td>
<td><?php
print number_format_i18n($site['total_devices']);
?>
</td>
<td><?php
print number_format_i18n($site['sum_ips_total']);
?>
</td>
<td><?php
print number_format_i18n($site['sum_ports_total']);
?>
</td>
<td><?php
print number_format_i18n($site['sum_ports_active']);
?>
</td>
<td><?php
print number_format_i18n($site['sum_ports_trunk']);
?>
</td>
<td><?php
print number_format_i18n($site['sum_macs_active']);
?>
</td>
</tr>
<?php
}
} else {
print '<tr><td><em>' . __('No MacTrack Sites') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($sites)) {
print $nav;
}
}
/* draw the dropdown containing a list of available actions for this form */
if (get_request_var('detail') == 'false') {
draw_actions_dropdown($site_actions);
}
}
function mactrack_site() {
global $colors, $site_actions, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["detail"])) {
$_REQUEST["detail"] = sanitize_search_string(get_request_var("detail"));
}
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_mactrack_sites_current_page");
kill_session_var("sess_mactrack_sites_detail");
kill_session_var("sess_mactrack_sites_device_type_id");
kill_session_var("sess_mactrack_sites_site_id");
kill_session_var("sess_mactrack_sites_rows");
kill_session_var("sess_mactrack_sites_filter");
kill_session_var("sess_mactrack_sites_sort_column");
kill_session_var("sess_mactrack_sites_sort_direction");
$_REQUEST["page"] = 1;
unset($_REQUEST["filter"]);
unset($_REQUEST["device_type_id"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["detail"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}else{
/* if any of the settings changed, reset the page number */
$changed = 0;
$changed += mactrack_check_changed("device_type_id", "sess_mactrack_sites_device_type_id");
$changed += mactrack_check_changed("site_id", "sess_mactrack_sites_site_id");
$changed += mactrack_check_changed("rows", "sess_mactrack_sites_rows");
$changed += mactrack_check_changed("filter", "sess_mactrack_sites_filter");
$changed += mactrack_check_changed("detail", "sess_mactrack_sites_detail");
if ($changed) {
$_REQUEST["page"] = "1";
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_mactrack_sites_current_page", "1");
load_current_session_value("detail", "sess_mactrack_sites_detail", "false");
load_current_session_value("device_type_id", "sess_mactrack_sites_device_type_id", "-1");
load_current_session_value("site_id", "sess_mactrack_sites_site_id", "-1");
load_current_session_value("rows", "sess_mactrack_sites_rows", "-1");
load_current_session_value("filter", "sess_mactrack_sites_filter", "");
load_current_session_value("sort_column", "sess_mactrack_sites_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_sites_sort_direction", "ASC");
if ($_REQUEST["rows"] == -1) {
$row_limit = read_config_option("num_rows_mactrack");
}elseif ($_REQUEST["rows"] == -2) {
$row_limit = 999999;
}else{
$row_limit = $_REQUEST["rows"];
}
html_start_box("<strong>MacTrack Site Filters</strong>", "100%", $colors["header"], "3", "center", "mactrack_sites.php?action=edit");
mactrack_site_filter();
html_end_box();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$sites = mactrack_site_get_site_records($sql_where, $row_limit);
if ($_REQUEST["detail"] == "false") {
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_sites.site_id)
FROM mac_track_sites
$sql_where");
}else{
$total_rows = db_fetch_cell("SELECT count(*)
FROM (mac_track_device_types
RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id))
RIGHT JOIN mac_track_sites ON (mac_track_devices.site_id = mac_track_sites.site_id)
$sql_where
GROUP BY mac_track_sites.site_name, mac_track_device_types.device_type_id");
}
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_sites.php"));
if ($_REQUEST["detail"] == "false") {
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 9, "mactrack_sites.php?filter=" . $_REQUEST["filter"]);
}else{
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='9'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='left' class='textHeaderDark'>
<strong><< "; if ($_REQUEST["page"] > 1) { $nav .= "<a class='linkOverDark' href='mactrack_sites.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($row_limit*($_REQUEST["page"]-1))+1) . " to " . ((($total_rows < $row_limit) || ($total_rows < ($row_limit*$_REQUEST["page"]))) ? $total_rows : ($row_limit*$_REQUEST["page"])) . " of $total_rows [$url_page_select]
</td>\n
<td align='right' class='textHeaderDark'>
<strong>"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "<a class='linkOverDark' href='mactrack_sites.php?page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}else{
$nav = "<tr bgcolor='#" . $colors["header"] . "' class='noprint'>
<td colspan='22'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='center' class='textHeaderDark'>
No Rows Found
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
}
print $nav;
$display_text = array(
"site_name" => array("Site Name", "ASC"),
"total_devices" => array("Devices", "DESC"),
"total_ips" => array("Total IP's", "DESC"),
"total_user_ports" => array("User Ports", "DESC"),
"total_oper_ports" => array("User Ports Up", "DESC"),
"total_macs" => array("MACS Found", "DESC"),
"total_device_errors" => array("Device Errors", "DESC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i, 'line' . $site["site_id"]); $i++;
form_selectable_cell("<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=" . $site["site_id"] . "'>". (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]) . "</a>", $site["site_id"]);
form_selectable_cell(number_format($site["total_devices"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_ips"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_user_ports"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_oper_ports"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_macs"]), $site["site_id"]);
form_selectable_cell($site["total_device_errors"], $site["site_id"]);
form_checkbox_cell($site["site_name"], $site["site_id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No MacTrack Sites</em></td></tr>";
}
html_end_box(false);
}else{
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 10, "mactrack_sites.php?filter=" . $_REQUEST["filter"]);
}else{
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='10'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='left' class='textHeaderDark'>
<strong><< "; if ($_REQUEST["page"] > 1) { $nav .= "<a class='linkOverDark' href='mactrack_sites.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($row_limit*($_REQUEST["page"]-1))+1) . " to " . ((($total_rows < $row_limit) || ($total_rows < ($row_limit*$_REQUEST["page"]))) ? $total_rows : ($row_limit*$_REQUEST["page"])) . " of $total_rows [$url_page_select]
</td>\n
<td align='right' class='textHeaderDark'>
<strong>"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "<a class='linkOverDark' href='mactrack_sites.php?page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}else{
$nav = "<tr bgcolor='#" . $colors["header"] . "' class='noprint'>
<td colspan='22'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='center' class='textHeaderDark'>
No Rows Found
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
}
print $nav;
$display_text = array(
"site_name" => array("Site Name", "ASC"),
"vendor" => array("Vendor", "ASC"),
"description" => array("Device Type", "DESC"),
"total_devices" => array("Total Devices", "DESC"),
"sum_ips_total" => array("Total IP's", "DESC"),
"sum_ports_total" => array("Total User Ports", "DESC"),
"sum_ports_active" => array("Total Oper Ports", "DESC"),
"sum_ports_trunk" => array("Total Trunks", "DESC"),
"sum_macs_active" => array("MACS Found", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=200>
<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=<?php print $site["site_id"];?>'><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]);?></a>
</td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["vendor"]) : $site["vendor"]);?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["description"]) : $site["description"]);?></td>
<td><?php print number_format($site["total_devices"]);?></td>
<td><?php print number_format($site["sum_ips_total"]);?></td>
<td><?php print number_format($site["sum_ports_total"]);?></td>
<td><?php print number_format($site["sum_ports_active"]);?></td>
<td><?php print number_format($site["sum_ports_trunk"]);?></td>
<td><?php print number_format($site["sum_macs_active"]);?></td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No MacTrack Sites</em></td></tr>";
}
html_end_box(false);
}
/* draw the dropdown containing a list of available actions for this form */
if ($_REQUEST["detail"] == "false") {
mactrack_draw_actions_dropdown($site_actions);
}
}
