| " . __('No Graphs Found') . ' |
';
}
html_end_box(false);
if (cacti_sizeof($graph_list)) {
print $nav;
}
// add a list of tree names to the actions dropdown
add_tree_names_to_actions_array();
// draw the dropdown containing a list of available actions for this form
draw_actions_dropdown($actions);
form_end();
}
function create_graphs_filter(string $session_var) : array {
global $item_rows;
$all = ['-1' => __('All')];
$any = ['-1' => __('Any')];
$none = ['0' => __('None')];
$sites = array_rekey(
db_fetch_assoc('SELECT id, name
FROM sites
ORDER BY name'),
'id', 'name'
);
$sites = $any + $sites;
if (gfrv('host_id') == 0) {
$templates = get_allowed_graph_templates_normalized('gl.host_id=0', 'name', '', $total_rows);
} elseif (gfrv('host_id') > 0) {
$templates = get_allowed_graph_templates_normalized('gl.host_id=' . gfrv('host_id'), 'name', '', $total_rows);
} else {
$templates = get_allowed_graph_templates_normalized('', 'name', '', $total_rows);
}
$normalized_templates = [];
if (cacti_sizeof($templates)) {
foreach ($templates as $t) {
$normalized_templates[$t['id']] = $t['name'];
}
}
$normalized_templates = $any + $none + $normalized_templates;
$sources = [
'-1' => __('All'),
'0' => __('Non Templated'),
'1' => __('Graph Template'),
'2' => __('Data Query'),
];
$cdefs = array_rekey(
db_fetch_assoc('SELECT DISTINCT c.id, c.name
FROM cdef AS c
INNER JOIN (SELECT DISTINCT cdef_id FROM graph_templates_item WHERE cdef_id > 0) AS gti
ON c.id = gti.cdef_id
ORDER BY name'),
'id', 'name'
);
$cdefs = $all + $cdefs;
$vdefs = array_rekey(
db_fetch_assoc('SELECT v.id, v.name
FROM vdef AS v
INNER JOIN (SELECT DISTINCT vdef_id FROM graph_templates_item WHERE vdef_id > 0) AS gti
ON gti.vdef_id = v.id
ORDER BY name'),
'id', 'name'
);
$vdefs = $all + $vdefs;
$sql_where = '';
$sql_params = [];
if (isrv('host_id')) {
$host_id = grv('host_id');
} elseif (isset($_SESSION[$session_var . '_host_id'])) {
$host_id = $_SESSION[$session_var . '_host_id'];
} else {
$host_id = '-1';
}
if ($host_id > 0) {
// for the templates dropdown
$sql_where = 'AND h.id = ?';
$sql_params[] = $host_id;
$hostname = db_fetch_cell_prepared('SELECT description
FROM host
WHERE id = ?',
[$host_id]);
} elseif ($host_id == 0) {
$host_id = '0';
$hostname = __('None');
} else {
$host_id = '-1';
$hostname = __('Any');
}
return [
'rows' => [
[
'site_id' => [
'method' => 'drop_array',
'friendly_name' => __('Site'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'array' => $sites,
'value' => '-1'
],
'host_id' => [
'method' => 'drop_callback',
'friendly_name' => __('Device'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'sql' => 'SELECT DISTINCT id, description AS name FROM host ORDER BY description',
'action' => 'ajax_hosts',
'id' => $host_id,
'value' => $hostname,
'on_change' => 'applyFilter()'
],
'template_id' => [
'method' => 'drop_array',
'friendly_name' => __('Template'),
'filter' => FILTER_VALIDATE_REGEXP,
'filter_options' => ['options' => ['regexp' => '/^(cg_[0-9]+|dq_[0-9]+|-?[0-9]+)$/']],
'default' => '-1',
'pageset' => true,
'array' => $normalized_templates,
'value' => '-1'
],
'orphans' => [
'method' => 'filter_checkbox',
'friendly_name' => __('Orphaned'),
'filter' => FILTER_VALIDATE_REGEXP,
'filter_options' => ['options' => ['regexp' => '(true|false)']],
'default' => '',
'pageset' => true,
'value' => gnrv('orphans')
]
],
[
'source' => [
'method' => 'drop_array',
'friendly_name' => __('Source'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'array' => $sources,
'value' => '-1'
],
'cdef_id' => [
'method' => 'drop_array',
'friendly_name' => __('CDEFs'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'array' => $cdefs,
'value' => '-1'
],
'vdef_id' => [
'method' => 'drop_array',
'friendly_name' => __('VDEFs'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'array' => $vdefs,
'value' => '-1'
]
],
[
'rfilter' => [
'method' => 'textbox',
'friendly_name' => __('Search'),
'filter' => FILTER_VALIDATE_IS_REGEX,
'placeholder' => __('Enter a search term'),
'size' => '55',
'default' => '',
'pageset' => true,
'max_length' => '120',
'value' => ''
],
'rows' => [
'method' => 'drop_array',
'friendly_name' => __('Graphs'),
'filter' => FILTER_VALIDATE_INT,
'default' => '-1',
'pageset' => true,
'array' => $item_rows,
'value' => '-1'
]
]
],
'buttons' => [
'go' => [
'method' => 'submit',
'display' => __('Go'),
'title' => __('Apply filter to table'),
],
'clear' => [
'method' => 'button',
'display' => __('Clear'),
'title' => __('Reset filter to default values'),
]
],
'sort' => [
'sort_column' => 'title_cache',
'sort_direction' => 'DESC'
]
];
}
function process_sanifize_draw_graphs_filter(bool $render = false) : void {
$filters = create_graphs_filter('sess_graphs');
if (read_config_option('grds_creation_method') == 1) {
$add_url = htmle('graphs.php?action=graph_edit&host_id=' . grv('host_id'));
} else {
$add_url = '';
}
if (grv('local_graph_ids') != '') {
$header = __('Graph Management [ Custom Graphs List Applied - Clear to Reset ]');
} elseif (grv('host_id') == -1) {
$header = __('Graph Management [ All Devices ]');
} elseif (grv('host_id') == 0) {
$header = __('Graph Management [ Non Device Based ]');
} elseif (grv('host_id') > 0) {
$description = db_fetch_cell_prepared('SELECT description FROM host WHERE id = ?', [grv('host_id')]);
$header = __esc('Graph Management [ %s ]', $description);
} else {
$header = __esc('Graph Management [ All Devices ]');
}
// create the page filter
$pageFilter = new CactiTableFilter($header, 'graphs.php', 'form_graphs', 'sess_graphs', $add_url);
$pageFilter->rows_label = __('Data Sources');
$pageFilter->set_filter_array($filters);
if ($render) {
$pageFilter->render();
} else {
$pageFilter->sanitize();
}
}