';
}
html_end_box();
}
form_save_button('automation_snmp.php', 'return');
?>
rows_label = __('Rules');
$pageFilter->has_import = true;
$pageFilter->render();
if (grv('rows') == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = grv('rows');
}
// form the 'where' clause for our main sql query
if (grv('filter') != '') {
$sql_where = 'WHERE asnmp.name LIKE ' . db_qstr('%' . grv('filter') . '%');
} else {
$sql_where = '';
}
$total_rows = db_fetch_cell("SELECT
COUNT(DISTINCT asnmp.id)
FROM automation_snmp AS asnmp
LEFT JOIN automation_networks AS anw
ON asnmp.id=anw.snmp_id
LEFT JOIN automation_snmp_items AS asnmpi
ON asnmp.id=asnmpi.snmp_id
$sql_where
GROUP BY asnmp.id");
$sql_order = get_order_string();
$sql_limit = ' LIMIT ' . ($rows * (grv('page') - 1)) . ',' . $rows;
$snmp_options = db_fetch_assoc("SELECT asnmp.*, COUNT(anw.id) AS networks,
COUNT(asnmpi.snmp_id) AS totals,
SUM(CASE WHEN asnmpi.snmp_version=1 THEN 1 ELSE 0 END) AS v1entries,
SUM(CASE WHEN asnmpi.snmp_version=2 THEN 1 ELSE 0 END) AS v2entries,
SUM(CASE WHEN asnmpi.snmp_version=3 THEN 1 ELSE 0 END) AS v3entries
FROM automation_snmp AS asnmp
LEFT JOIN automation_networks AS anw
ON asnmp.id=anw.snmp_id
LEFT JOIN automation_snmp_items AS asnmpi
ON asnmp.id=asnmpi.snmp_id
$sql_where
GROUP BY asnmp.id
$sql_order
$sql_limit");
$nav = html_nav_bar('automation_snmp.php?filter=' . grv('filter'), MAX_DISPLAY_PAGES, grv('page'), $rows, $total_rows, 12, __('SNMP Option Sets'), 'page', 'main');
form_start('automation_snmp.php', 'chk');
print $nav;
html_start_box('', '100%', false, 3, 'center', '');
$display_text = [
'name' => [
'display' => __('SNMP Option Set'),
'align' => 'left',
'sort' => 'ASC'
],
'networks' => [
'display' => __('Networks Using'),
'align' => 'right',
'sort' => 'DESC'
],
'totals' => [
'display' => __('SNMP Entries'),
'align' => 'right',
'sort' => 'DESC'
],
'v1entries' => [
'display' => __('V1 Entries'),
'align' => 'right',
'sort' => 'DESC'
],
'v2entries' => [
'display' => __('V2 Entries'),
'align' => 'right',
'sort' => 'DESC'
],
'v3entries' => [
'display' => __('V3 Entries'),
'align' => 'right',
'sort' => 'DESC'
]
];
html_header_sort_checkbox($display_text, grv('sort_column'), grv('sort_direction'), false);
if (cacti_sizeof($snmp_options)) {
foreach ($snmp_options as $snmp_option) {
form_alternate_row('line' . $snmp_option['id'], true);
form_selectable_cell(filter_value($snmp_option['name'], grv('filter'), 'automation_snmp.php?action=edit&id=' . $snmp_option['id'] . '&page=1'), $snmp_option['id']);
form_selectable_cell($snmp_option['networks'], $snmp_option['id'], '', 'right');
form_selectable_cell($snmp_option['totals'], $snmp_option['id'], '', 'right');
form_selectable_cell($snmp_option['v1entries'], $snmp_option['id'], '', 'right');
form_selectable_cell($snmp_option['v2entries'], $snmp_option['id'], '', 'right');
form_selectable_cell($snmp_option['v3entries'], $snmp_option['id'], '', 'right');
form_checkbox_cell($snmp_option['name'], $snmp_option['id']);
form_end_row();
}
} else {
print '
' . __('No SNMP Option Sets Found') . '
';
}
html_end_box(false);
if (cacti_sizeof($snmp_options)) {
print $nav;
}
// draw the dropdown containing a list of available actions for this form
draw_actions_dropdown($actions);
form_end();
}