mirror of
https://github.com/Cacti/cacti.git
synced 2026-10-23 03:27:02 +09:00
Thomas Vincent
4d11070ced
* feat: expose RRDtool 1.11 graph axis controls Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * fix: constrain axis template inheritance checkboxes Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * test(rrd): exercise native aggregate validation and enforce coverage Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * ci: share changed-code coverage contracts and enforce shell policy Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * fix(ci): run request coverage with portable path matching Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * ci: retain bootstrap coverage and validate request dispatch Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * test: synchronize native coverage fixture dispatch Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> * test: measure coverage at the exact PR revision Signed-off-by: Thomas Vincent <thomasvincent@gmail.com> --------- Signed-off-by: Thomas Vincent <thomasvincent@gmail.com>
3348 lines
111 KiB
PHP
3348 lines
111 KiB
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/ |
|
|
+-------------------------------------------------------------------------+
|
|
*/
|
|
|
|
require('./include/auth.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/api_aggregate.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/api_automation.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/api_data_source.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/api_graph.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/api_tree.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/data_query.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/graphs.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/html_graph.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/html_form_template.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/html_tree.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/poller.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/reports.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/rrd.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/template.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/utility.php');
|
|
require_once(CACTI_PATH_LIBRARY . '/CactiValidator.php');
|
|
|
|
use Symfony\Component\Validator\Constraints as Assert;
|
|
|
|
// set default action
|
|
set_default_action();
|
|
|
|
$actions = [
|
|
1 => __('Delete')
|
|
];
|
|
|
|
if ((gnrv('template_id') != '' &&
|
|
gnrv('template_id') != '-1' &&
|
|
gnrv('template_id') != '0') || gnrv('drp_action') == 2) {
|
|
$actions += [
|
|
2 => __('Change Graph Template')
|
|
];
|
|
}
|
|
|
|
if (read_config_option('grds_creation_method') == 1) {
|
|
$actions += [
|
|
3 => __('Duplicate'),
|
|
4 => __('Convert to Graph Template')
|
|
];
|
|
}
|
|
|
|
$actions += [
|
|
5 => __('Change Device'),
|
|
6 => __('Reapply Suggested Names'),
|
|
8 => __('Apply Automation Rules'),
|
|
9 => __('Create Aggregate Graph'),
|
|
10 => __('Create Aggregate from Template'),
|
|
];
|
|
|
|
$reports = db_fetch_cell_prepared('SELECT COUNT(*)
|
|
FROM reports
|
|
WHERE user_id = ?
|
|
ORDER BY name',
|
|
[$_SESSION[SESS_USER_ID]]
|
|
);
|
|
|
|
if ($reports > 0) {
|
|
$actions += [
|
|
11 => __('Place Graphs on Report')
|
|
];
|
|
}
|
|
|
|
$actions = api_plugin_hook_function('graphs_action_array', $actions);
|
|
|
|
switch (grv('action')) {
|
|
case 'save':
|
|
form_save();
|
|
|
|
break;
|
|
case 'actions':
|
|
form_actions();
|
|
|
|
break;
|
|
case 'view':
|
|
html_graph_single_view();
|
|
|
|
break;
|
|
case 'update_timespan':
|
|
html_graph_update_timespan();
|
|
|
|
break;
|
|
case 'item':
|
|
top_header();
|
|
item();
|
|
bottom_footer();
|
|
|
|
break;
|
|
case 'ajax_graph_items':
|
|
get_ajax_graph_items();
|
|
|
|
break;
|
|
case 'ajax_hosts':
|
|
$sql_where = '';
|
|
|
|
if (grv('site_id') > 0) {
|
|
$sql_where = 'site_id = ' . gfrv('site_id');
|
|
}
|
|
|
|
get_allowed_ajax_hosts(true, true, $sql_where);
|
|
|
|
break;
|
|
case 'ajax_hosts_noany':
|
|
$sql_where = '';
|
|
|
|
if (grv('site_id') > 0) {
|
|
$sql_where = 'site_id = ' . gfrv('site_id');
|
|
}
|
|
|
|
get_allowed_ajax_hosts(false, true, $sql_where);
|
|
|
|
break;
|
|
case 'ajax_graph_items':
|
|
$sql_where = '';
|
|
|
|
if (!ierv('host_id')) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : '') . 'dl.host_id=' . gfrv('host_id');
|
|
}
|
|
|
|
if (!ierv('data_template_id')) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : '') . 'dtd.data_template_id=' . gfrv('data_template_id');
|
|
}
|
|
|
|
get_allowed_ajax_graph_items(true, $sql_where);
|
|
|
|
break;
|
|
case 'ajax_dnd':
|
|
$local_graph_id = gfrv('id');
|
|
$sequences = gnrv('item_ids');
|
|
|
|
if (cacti_sizeof($sequences)) {
|
|
foreach ($sequences as $index => $s) {
|
|
$new_seq = $index++;
|
|
|
|
db_execute_prepared('UPDATE graph_templates_item
|
|
SET sequence = ?
|
|
WHERE id = ?
|
|
AND local_graph_id = ?
|
|
AND graph_template_id = 0',
|
|
[$new_seq, $s, $local_graph_id]);
|
|
}
|
|
}
|
|
|
|
header('Location: graphs.php?action=graph_edit&id=' . gfrv('id'));
|
|
|
|
break;
|
|
case 'item_remove':
|
|
gfrv('local_graph_id');
|
|
|
|
item_remove();
|
|
|
|
header('Location: graphs.php?action=graph_edit&id=' . grv('local_graph_id'));
|
|
|
|
break;
|
|
case 'item_edit':
|
|
top_header();
|
|
|
|
item_edit();
|
|
|
|
bottom_footer();
|
|
|
|
break;
|
|
case 'item_movedown':
|
|
gfrv('local_graph_id');
|
|
|
|
item_movedown();
|
|
|
|
header('Location: graphs.php?action=graph_edit&id=' . grv('local_graph_id'));
|
|
|
|
break;
|
|
case 'item_moveup':
|
|
gfrv('local_graph_id');
|
|
|
|
item_moveup();
|
|
|
|
header('Location: graphs.php?action=graph_edit&id=' . grv('local_graph_id'));
|
|
|
|
break;
|
|
case 'lock':
|
|
case 'unlock':
|
|
$_SESSION['sess_graph_lock_id'] = gfrv('id');
|
|
$_SESSION['sess_graph_locked'] = (grv('action') == 'lock' ? true : false);
|
|
// Fall through: show the editor with the new lock state.
|
|
case 'graph_edit':
|
|
top_header();
|
|
graph_edit();
|
|
bottom_footer();
|
|
|
|
break;
|
|
default:
|
|
top_header();
|
|
graphs();
|
|
bottom_footer();
|
|
|
|
break;
|
|
}
|
|
|
|
function get_ajax_graph_items() : void {
|
|
$rrd_id = gfrv('rrd_id');
|
|
$host_id = gfrv('host_id');
|
|
|
|
$sql_where = '';
|
|
$sql_params = [];
|
|
$sql_params[] = $rrd_id;
|
|
|
|
if ($host_id > 0) {
|
|
$sql_where = ' AND data_local.host_id = ?';
|
|
$sql_params[] = $host_id;
|
|
}
|
|
|
|
if (gnrv('term') != '') {
|
|
$sql_where .= ' HAVING name LIKE ?';
|
|
$sql_params[] = '%' . gnrv('term') . '%';
|
|
}
|
|
|
|
$items = db_fetch_assoc_prepared("SELECT *
|
|
FROM (SELECT data_template_rrd.id AS id,
|
|
CONCAT_WS('',
|
|
CASE
|
|
WHEN host.description IS NULL THEN '" . __esc('No Device - ') . "'
|
|
WHEN host.description IS NOT NULL THEN ''
|
|
END,
|
|
data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') AS name
|
|
FROM (data_template_data,data_template_rrd,data_local)
|
|
LEFT JOIN host ON (data_local.host_id=host.id)
|
|
WHERE data_template_rrd.local_data_id=data_local.id
|
|
AND data_template_data.local_data_id=data_local.id
|
|
AND data_template_rrd.id = ?
|
|
) AS a
|
|
UNION
|
|
SELECT *
|
|
FROM (SELECT data_template_rrd.id AS id,
|
|
CONCAT_WS('',
|
|
CASE
|
|
WHEN host.description IS NULL THEN '" . __esc('No Device - ') . "'
|
|
WHEN host.description IS NOT NULL THEN ''
|
|
END,
|
|
data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') AS name
|
|
FROM (data_template_data,data_template_rrd,data_local)
|
|
LEFT JOIN host ON (data_local.host_id=host.id)
|
|
WHERE data_template_rrd.local_data_id=data_local.id
|
|
AND data_template_data.local_data_id=data_local.id
|
|
$sql_where
|
|
ORDER BY name
|
|
) AS b
|
|
LIMIT " . read_config_option('autocomplete_rows'),
|
|
$sql_params);
|
|
|
|
foreach ($items as $key => $item) {
|
|
$items[$key]['label'] = $item['name'];
|
|
}
|
|
|
|
print json_encode($items);
|
|
}
|
|
|
|
function add_tree_names_to_actions_array() : void {
|
|
global $actions;
|
|
|
|
// add a list of tree names to the actions dropdown
|
|
$trees = db_fetch_assoc('SELECT id, name
|
|
FROM graph_tree
|
|
ORDER BY name');
|
|
|
|
if (cacti_sizeof($trees)) {
|
|
foreach ($trees as $tree) {
|
|
$actions['tr_' . $tree['id']] = __esc('Place on a Tree (%s)', $tree['name']);
|
|
}
|
|
}
|
|
}
|
|
|
|
function parse_validate_graph_template_id(string $variable) : string {
|
|
$output_type_id = 0;
|
|
|
|
if (str_contains(gnrv($variable), '_')) {
|
|
$template_parts = explode('_', gnrv($variable));
|
|
|
|
if (is_numeric($template_parts[0]) && is_numeric($template_parts[1])) {
|
|
srv('graph_template_id', $template_parts[0]);
|
|
$output_type_id = $template_parts[1];
|
|
} else {
|
|
cacti_log('ERROR: Unable to parse graph_template_id with value ' . gnrv($variable), false, 'WEBUI');
|
|
|
|
exit;
|
|
}
|
|
} else {
|
|
gfrv($variable);
|
|
}
|
|
|
|
return $output_type_id;
|
|
}
|
|
|
|
function form_save() : void {
|
|
if (isrv('save_component_graph_new') || isrv('save_component_graph') || isrv('save_component_input')) {
|
|
// ================= input validation =================
|
|
gfrv('local_graph_id');
|
|
gfrv('host_id_prev');
|
|
gfrv('graph_template_graph_id');
|
|
gfrv('local_graph_template_graph_id');
|
|
// ====================================================
|
|
|
|
// handle special case of callback on host_id
|
|
if (!is_numeric(gnrv('host_id'))) {
|
|
srv('host_id', grv('host_id_prev'));
|
|
} else {
|
|
gfrv('host_id');
|
|
}
|
|
|
|
$gt_id_unparsed = gnrv('graph_template_id');
|
|
$gt_id_prev_unparsed = gnrv('graph_template_id_prev');
|
|
parse_validate_graph_template_id('graph_template_id');
|
|
|
|
if (isrv('save_component_graph_new') && !ierv('graph_template_id')) {
|
|
$snmp_query_array = [];
|
|
$suggested_values = [];
|
|
$graph_template_id = grv('graph_template_id');
|
|
$host_id = grv('host_id');
|
|
|
|
if ($host_id > 0) {
|
|
object_cache_get_totals('device_state', $host_id);
|
|
}
|
|
|
|
$return_array = create_complete_graph_from_template($graph_template_id, $host_id, $snmp_query_array, $suggested_values);
|
|
|
|
if ($return_array !== false) {
|
|
debug_log_insert('new_graphs', __esc('Created graph: %s', get_graph_title($return_array['local_graph_id'])));
|
|
|
|
// lastly push host-specific information to our data sources
|
|
if (cacti_sizeof($return_array['local_data_id'])) { // we expect at least one data source associated
|
|
foreach ($return_array['local_data_id'] as $item) {
|
|
push_out_host($host_id, $item);
|
|
}
|
|
} else {
|
|
debug_log_insert('new_graphs', __esc('ERROR: No Data Source associated. Check Template'));
|
|
}
|
|
}
|
|
|
|
if ($host_id > 0) {
|
|
object_cache_get_totals('device_state', $host_id, true);
|
|
object_cache_update_totals('diff');
|
|
}
|
|
|
|
if (isset($return_array['local_graph_id'])) {
|
|
$local_graph_id = $return_array['local_graph_id'];
|
|
cacti_redirect('graphs.php', [
|
|
'action' => 'graph_edit',
|
|
'id' => $local_graph_id,
|
|
]);
|
|
} else {
|
|
cacti_redirect('graphs.php');
|
|
}
|
|
}
|
|
|
|
if (isrv('save_component_graph')) {
|
|
if (gfrv('host_id') == '-1') {
|
|
srv('host_id', '0');
|
|
}
|
|
|
|
if (grv('host_id') > 0) {
|
|
object_cache_get_totals('device_state', grv('host_id'));
|
|
}
|
|
|
|
$save1['id'] = gnrv('local_graph_id');
|
|
$save1['host_id'] = grv('host_id');
|
|
$save1['graph_template_id'] = gnrv('graph_template_id');
|
|
|
|
$save2['id'] = gnrv('graph_template_graph_id');
|
|
$save2['local_graph_template_graph_id'] = gnrv('local_graph_template_graph_id');
|
|
$save2['graph_template_id'] = gnrv('graph_template_id');
|
|
$save2['image_format_id'] = CactiValidator::validateInput(gnrv('image_format_id'), 'image_format_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['title'] = CactiValidator::validateInput(gnrv('title'), 'title', [new Assert\NotBlank()], 3);
|
|
$save2['height'] = CactiValidator::validateInput(gnrv('height'), 'height', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['width'] = CactiValidator::validateInput(gnrv('width'), 'width', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['upper_limit'] = CactiValidator::validateInput(gnrv('upper_limit'), 'upper_limit', [new Assert\Regex('/^(-?([0-9]+(\.[0-9]*)?|[0-9]*\.[0-9]+)([eE][+\-]?[0-9]+)?|U)\z/')], 3);
|
|
$save2['lower_limit'] = CactiValidator::validateInput(gnrv('lower_limit'), 'lower_limit', [new Assert\Regex('/^(-?([0-9]+(\.[0-9]*)?|[0-9]*\.[0-9]+)([eE][+\-]?[0-9]+)?|U)\z/')], 3);
|
|
$save2['vertical_label'] = CactiValidator::validateInput(gnrv('vertical_label'), 'vertical_label', [], 3);
|
|
$save2['vertical_label_angle'] = CactiValidator::validateRrdGraphAxisInput((isrv('vertical_label_angle') ? gnrv('vertical_label_angle') : ''), 'vertical_label_angle');
|
|
$save2['right_axis_label_angle'] = CactiValidator::validateRrdGraphAxisInput((isrv('right_axis_label_angle') ? gnrv('right_axis_label_angle') : ''), 'right_axis_label_angle');
|
|
$save2['right_axis_range'] = CactiValidator::validateRrdGraphAxisInput((isrv('right_axis_range') ? gnrv('right_axis_range') : ''), 'right_axis_range');
|
|
$save2['slope_mode'] = CactiValidator::validateInput((isrv('slope_mode') ? gnrv('slope_mode') : ''), 'slope_mode', [], 3);
|
|
$save2['auto_scale'] = CactiValidator::validateInput((isrv('auto_scale') ? gnrv('auto_scale') : ''), 'auto_scale', [], 3);
|
|
$save2['auto_scale_opts'] = CactiValidator::validateInput(gnrv('auto_scale_opts'), 'auto_scale_opts', [], 3);
|
|
$save2['auto_scale_log'] = CactiValidator::validateInput((isrv('auto_scale_log') ? gnrv('auto_scale_log') : ''), 'auto_scale_log', [], 3);
|
|
$save2['scale_log_units'] = CactiValidator::validateInput((isrv('scale_log_units') ? gnrv('scale_log_units') : ''), 'scale_log_units', [], 3);
|
|
$save2['auto_scale_rigid'] = CactiValidator::validateInput((isrv('auto_scale_rigid') ? gnrv('auto_scale_rigid') : ''), 'auto_scale_rigid', [], 3);
|
|
$save2['auto_padding'] = CactiValidator::validateInput((isrv('auto_padding') ? gnrv('auto_padding') : ''), 'auto_padding', [], 3);
|
|
$save2['base_value'] = CactiValidator::validateInput(gnrv('base_value'), 'base_value', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['unit_value'] = CactiValidator::validateInput(gnrv('unit_value'), 'unit_value', [], 3);
|
|
$save2['unit_exponent_value'] = CactiValidator::validateInput(gnrv('unit_exponent_value'), 'unit_exponent_value', [new Assert\Regex('/^-?[0-9]+$/')], 3);
|
|
$save2['alt_y_grid'] = CactiValidator::validateInput((isrv('alt_y_grid') ? gnrv('alt_y_grid') : ''), 'alt_y_grid', [], 3);
|
|
$save2['right_axis'] = CactiValidator::validateInput((isrv('right_axis') ? gnrv('right_axis') : ''), 'right_axis', [new Assert\Regex('/^-?([0-9]+(\.[0-9]*)?|\.[0-9]+):-?([0-9]+(\.[0-9]*)?|\.[0-9]+)$/')], 3);
|
|
$save2['right_axis_label'] = CactiValidator::validateInput((isrv('right_axis_label') ? gnrv('right_axis_label') : ''), 'right_axis_label', [], 3);
|
|
$save2['right_axis_format'] = CactiValidator::validateInput((isrv('right_axis_format') ? gnrv('right_axis_format') : ''), 'right_axis_format', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['no_gridfit'] = CactiValidator::validateInput((isrv('no_gridfit') ? gnrv('no_gridfit') : ''), 'no_gridfit', [], 3);
|
|
$save2['unit_length'] = CactiValidator::validateInput((isrv('unit_length') ? gnrv('unit_length') : ''), 'unit_length', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['tab_width'] = CactiValidator::validateInput((isrv('tab_width') ? gnrv('tab_width') : ''), 'tab_width', [new Assert\Regex('/^[0-9]*$/')], 3);
|
|
$save2['dynamic_labels'] = CactiValidator::validateInput((isrv('dynamic_labels') ? gnrv('dynamic_labels') : ''), 'dynamic_labels', [], 3);
|
|
$save2['force_rules_legend'] = CactiValidator::validateInput((isrv('force_rules_legend') ? gnrv('force_rules_legend') : ''), 'force_rules_legend', [], 3);
|
|
$save2['legend_position'] = CactiValidator::validateInput((isrv('legend_position') ? gnrv('legend_position') : ''), 'legend_position', [], 3);
|
|
$save2['legend_direction'] = CactiValidator::validateInput((isrv('legend_direction') ? gnrv('legend_direction') : ''), 'legend_direction', [], 3);
|
|
$save2['right_axis_formatter'] = CactiValidator::validateInput((isrv('right_axis_formatter') ? gnrv('right_axis_formatter') : ''), 'right_axis_formatter', [], 3);
|
|
$save2['left_axis_format'] = CactiValidator::validateInput((isrv('left_axis_format') ? gnrv('left_axis_format') : ''), 'left_axis_format', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save2['left_axis_formatter'] = form_input_validate((isrv('left_axis_formatter') ? gnrv('left_axis_formatter') : ''), 'left_axis_formatter', '', true, 3);
|
|
|
|
if (!is_error_message()) {
|
|
$local_graph_id = sql_save($save1, 'graph_local');
|
|
|
|
/**
|
|
* Save the last time a graph was created/updated
|
|
* for Caching.
|
|
*/
|
|
set_config_option('time_last_change_graph', time());
|
|
}
|
|
|
|
if (!is_error_message()) {
|
|
$save2['local_graph_id'] = $local_graph_id;
|
|
$graph_templates_graph_id = sql_save($save2, 'graph_templates_graph');
|
|
|
|
if ($graph_templates_graph_id) {
|
|
raise_message(1);
|
|
} else {
|
|
raise_message(2);
|
|
}
|
|
|
|
// update the title cache
|
|
update_graph_title_cache($local_graph_id);
|
|
|
|
// if the host id changes, then update the graph items association too
|
|
if (grv('host_id') != grv('host_id_prev')) {
|
|
if (!api_graph_change_device($local_graph_id, grv('host_id'))) {
|
|
raise_message(34);
|
|
}
|
|
}
|
|
}
|
|
|
|
if (!is_error_message()) {
|
|
$lg_template_id = db_fetch_cell_prepared('SELECT graph_template_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[$local_graph_id]
|
|
);
|
|
|
|
if ($lg_template_id > 0) {
|
|
change_graph_template($local_graph_id, $gt_id_unparsed, true);
|
|
|
|
$lg_dq_id = db_fetch_cell_prepared('SELECT snmp_query_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[$local_graph_id]
|
|
);
|
|
|
|
if ($lg_dq_id > 0) {
|
|
update_graph_data_query_cache($local_graph_id);
|
|
}
|
|
}
|
|
}
|
|
|
|
if (grv('host_id') > 0) {
|
|
object_cache_get_totals('device_state', grv('host_id'), true);
|
|
object_cache_update_totals('diff');
|
|
}
|
|
}
|
|
|
|
if (isrv('save_component_input')) {
|
|
// ================= input validation =================
|
|
gfrv('local_graph_id');
|
|
// ====================================================
|
|
|
|
// first; get the current graph template id
|
|
$graph_template_id = db_fetch_cell_prepared('SELECT graph_template_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[gnrv('local_graph_id')]);
|
|
|
|
// get all inputs that go along with this graph template, if templated
|
|
if ($graph_template_id > 0) {
|
|
$input_list = db_fetch_assoc_prepared('SELECT id, column_name
|
|
FROM graph_template_input
|
|
WHERE graph_template_id = ?',
|
|
[$graph_template_id]);
|
|
|
|
if (cacti_sizeof($input_list)) {
|
|
foreach ($input_list as $input) {
|
|
$input_var = $input['column_name'] . '_' . $input['id'];
|
|
|
|
if (!graph_template_input_column_is_allowed($input['column_name']) ||
|
|
(isrv($input_var) && !graph_template_input_value_is_allowed($input['column_name'], gnrv($input_var)))) {
|
|
cacti_log('ERROR: Graph save refused an invalid graph input field', false, 'SECURITY');
|
|
raise_message('graph_input_invalid', __('A Graph Item Input contains an invalid field or value.'), MESSAGE_LEVEL_ERROR);
|
|
|
|
$input_list = [];
|
|
|
|
break;
|
|
}
|
|
}
|
|
|
|
$transaction_started = cacti_sizeof($input_list) ? db_begin_transaction() : false;
|
|
$mutation_failed = cacti_sizeof($input_list) && !$transaction_started;
|
|
|
|
if ($mutation_failed) {
|
|
raise_message('graph_input_update_failed', __('Graph Item Input changes could not be saved.'), MESSAGE_LEVEL_ERROR);
|
|
}
|
|
|
|
foreach ($input_list as $input) {
|
|
if ($mutation_failed) {
|
|
break;
|
|
}
|
|
|
|
// we need to find out which graph items will be affected by saving this particular item
|
|
$item_list = db_fetch_assoc_prepared('SELECT gti.id
|
|
FROM graph_template_input_defs AS gtid
|
|
INNER JOIN graph_templates_item AS gti
|
|
ON gtid.graph_template_item_id=gti.local_graph_template_item_id
|
|
WHERE gti.local_graph_id = ?
|
|
AND gtid.graph_template_input_id = ?',
|
|
[gnrv('local_graph_id'), $input['id']]);
|
|
|
|
// loop through each item affected and update column data
|
|
if (cacti_sizeof($item_list)) {
|
|
foreach ($item_list as $item) {
|
|
/* if we are changing templates, the POST vars we are searching for here will not exist.
|
|
this is because the db and form are out of sync here, but it is ok to just skip over saving
|
|
the inputs in this case. */
|
|
if (isrv($input['column_name'] . '_' . $input['id'])) {
|
|
$input_value = gnrv($input['column_name'] . '_' . $input['id']);
|
|
|
|
if (!graph_template_input_value_is_allowed($input['column_name'], $input_value)) {
|
|
cacti_log('ERROR: Graph save refused an invalid graph input value', false, 'SECURITY');
|
|
raise_message('column_value_invalid', __('A Graph Item Input contains an invalid value.'), MESSAGE_LEVEL_ERROR);
|
|
|
|
continue;
|
|
}
|
|
|
|
if (!db_execute_prepared('UPDATE graph_templates_item
|
|
SET ' . $input['column_name'] . ' = ?
|
|
WHERE id = ?',
|
|
[$input_value, $item['id']])) {
|
|
$mutation_failed = true;
|
|
|
|
break 2;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
if ($transaction_started) {
|
|
if ($mutation_failed) {
|
|
db_rollback_transaction();
|
|
raise_message('graph_input_update_failed', __('Graph Item Input changes could not be saved.'), MESSAGE_LEVEL_ERROR);
|
|
} else {
|
|
db_commit_transaction();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
} elseif (isrv('save_component_item')) {
|
|
global $graph_item_types;
|
|
|
|
// ================= input validation =================
|
|
gfrv('sequence');
|
|
gfrv('graph_type_id');
|
|
gfrv('local_graph_id');
|
|
gfrv('graph_template_item_id');
|
|
gfrv('graph_template_id');
|
|
gfrv('local_graph_template_item_id');
|
|
// ====================================================
|
|
|
|
$items[0] = [];
|
|
|
|
if ($graph_item_types[gnrv('graph_type_id')] == 'LEGEND') {
|
|
/**
|
|
* this can be a major time saver when creating lots of
|
|
* graphs with the typical
|
|
* GPRINT LAST/AVERAGE/MAX legends
|
|
*/
|
|
$items = [
|
|
0 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '4',
|
|
'text_format' => 'Cur:',
|
|
'hard_return' => ''
|
|
],
|
|
1 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '1',
|
|
'text_format' => 'Avg:',
|
|
'hard_return' => ''
|
|
],
|
|
2 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '3',
|
|
'text_format' => 'Max:',
|
|
'hard_return' => 'on'
|
|
]
|
|
];
|
|
} elseif ($graph_item_types[gnrv('graph_type_id')] == 'LEGEND_CAMM') {
|
|
/**
|
|
* this can be a major time saver when creating lots of
|
|
* graphs with the typical
|
|
* GPRINT LAST/AVERAGE/MAX legends
|
|
*/
|
|
$items = [
|
|
0 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '4',
|
|
'text_format' => __('Cur:'),
|
|
'hard_return' => ''
|
|
],
|
|
1 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '1',
|
|
'text_format' => __('Avg:'),
|
|
'hard_return' => ''
|
|
],
|
|
2 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '2',
|
|
'text_format' => __('Min:'),
|
|
'hard_return' => ''
|
|
],
|
|
3 => [
|
|
'color_id' => '0',
|
|
'color2_id' => '0',
|
|
'alpha' => '0',
|
|
'alpha2' => '0',
|
|
'graph_type_id' => '9',
|
|
'consolidation_function_id' => '3',
|
|
'text_format' => __('Max:'),
|
|
'hard_return' => 'on'
|
|
]
|
|
];
|
|
}
|
|
|
|
$sequence = gnrv('sequence');
|
|
|
|
$graph_template_item_id = null;
|
|
|
|
if (empty($sequence) || !is_numeric($sequence)) {
|
|
$sequence = 1;
|
|
}
|
|
|
|
foreach ($items as $item) {
|
|
// generate a new sequence if needed
|
|
if (empty($sequence)) {
|
|
$sequence = get_sequence($sequence, 'sequence', 'graph_templates_item', 'local_graph_id=' . gnrv('local_graph_id'));
|
|
}
|
|
|
|
$save['id'] = gnrv('graph_template_item_id');
|
|
$save['graph_template_id'] = gnrv('graph_template_id');
|
|
$save['local_graph_template_item_id'] = gnrv('local_graph_template_item_id');
|
|
$save['local_graph_id'] = gnrv('local_graph_id');
|
|
$save['task_item_id'] = CactiValidator::validateInput(gnrv('task_item_id'), 'task_item_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['color_id'] = CactiValidator::validateInput((isset($item['color_id']) ? $item['color_id'] : gnrv('color_id')), 'color_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['color2_id'] = CactiValidator::validateInput((isset($item['color2_id']) ? $item['color2_id'] : gnrv('color2_id')), 'color2_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
|
|
// if alpha is disabled, use invisible_alpha instead
|
|
if (!isrv('alpha')) {
|
|
srv('alpha', gnrv('invisible_alpha'));
|
|
}
|
|
|
|
if (!isrv('alpha2')) {
|
|
srv('alpha2', gnrv('invisible_alpha'));
|
|
}
|
|
|
|
$save['alpha'] = CactiValidator::validateInput((isset($item['alpha']) ? $item['alpha'] : gnrv('alpha')), 'alpha', [], 3);
|
|
$save['alpha2'] = CactiValidator::validateInput((isset($item['alpha2']) ? $item['alpha2'] : gnrv('alpha2')), 'alpha2', [], 3);
|
|
$save['gradheight'] = CactiValidator::validateInput(gnrv('gradheight'), 'gradheight', [], 3);
|
|
|
|
$save['graph_type_id'] = CactiValidator::validateInput((isset($item['graph_type_id']) ? $item['graph_type_id'] : gnrv('graph_type_id')), 'graph_type_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
|
|
if (isrv('line_width')) {
|
|
$save['line_width'] = CactiValidator::validateInput(gnrv('line_width'), 'line_width', [new Assert\Regex('/(^[0-9]+[\.,0-9]+$|^[0-9]+$)/')], 3);
|
|
} else { // make sure to transfer old LINEx style into line_width on save
|
|
switch ($save['graph_type_id']) {
|
|
case GRAPH_ITEM_TYPE_LINE1:
|
|
$save['line_width'] = 1;
|
|
|
|
break;
|
|
case GRAPH_ITEM_TYPE_LINE2:
|
|
$save['line_width'] = 2;
|
|
|
|
break;
|
|
case GRAPH_ITEM_TYPE_LINE3:
|
|
$save['line_width'] = 3;
|
|
|
|
break;
|
|
default:
|
|
$save['line_width'] = 0;
|
|
}
|
|
}
|
|
|
|
$save['dashes'] = CactiValidator::validateInput((isrv('dashes') ? gnrv('dashes') : ''), 'dashes', [], 3);
|
|
$save['dash_offset'] = CactiValidator::validateInput((isrv('dash_offset') ? gnrv('dash_offset') : ''), 'dash_offset', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['cdef_id'] = CactiValidator::validateInput(gnrv('cdef_id'), 'cdef_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['vdef_id'] = CactiValidator::validateInput(gnrv('vdef_id'), 'vdef_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['shift'] = CactiValidator::validateInput((isrv('shift') ? gnrv('shift') : ''), 'shift', [new Assert\Regex('/^((on)|)$/')], 3);
|
|
$save['consolidation_function_id'] = CactiValidator::validateInput((isset($item['consolidation_function_id']) ? $item['consolidation_function_id'] : gnrv('consolidation_function_id')), 'consolidation_function_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['textalign'] = CactiValidator::validateInput((isrv('textalign') ? gnrv('textalign') : ''), 'textalign', [new Assert\Regex('/^[a-z]+$/')], 3);
|
|
$save['text_format'] = CactiValidator::validateInput((isset($item['text_format']) ? $item['text_format'] : gnrv('text_format')), 'text_format', [], 3);
|
|
$save['legend'] = CactiValidator::validateInput(gnrv('legend'), 'legend', [], 3);
|
|
|
|
$save['value'] = CactiValidator::validateInput(gnrv('value'), 'value', [], 3);
|
|
$save['hard_return'] = CactiValidator::validateInput(((isset($item['hard_return']) ? $item['hard_return'] : (isrv('hard_return') ? gnrv('hard_return') : ''))), 'hard_return', [], 3);
|
|
$save['gprint_id'] = CactiValidator::validateInput(gnrv('gprint_id'), 'gprint_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$save['sequence'] = $sequence;
|
|
|
|
if (!is_error_message()) {
|
|
$graph_template_item_id = sql_save($save, 'graph_templates_item');
|
|
|
|
if ($graph_template_item_id) {
|
|
raise_message(1);
|
|
} else {
|
|
raise_message(2);
|
|
}
|
|
}
|
|
|
|
$sequence = 0;
|
|
}
|
|
|
|
if (is_error_message()) {
|
|
cacti_redirect('graphs.php', [
|
|
'action' => 'item_edit',
|
|
'graph_template_item_id' => $graph_template_item_id === null ? gnrv('graph_template_item_id') : $graph_template_item_id,
|
|
'id' => gnrv('local_graph_id'),
|
|
]);
|
|
} else {
|
|
cacti_redirect('graphs.php', [
|
|
'action' => 'graph_edit',
|
|
'id' => gnrv('local_graph_id'),
|
|
]);
|
|
}
|
|
}
|
|
|
|
if ((isrv('save_component_graph_new')) && (ierv('graph_template_id'))) {
|
|
cacti_redirect('graphs.php', [
|
|
'action' => 'graph_edit',
|
|
'host_id' => gnrv('host_id'),
|
|
'new' => 1,
|
|
]);
|
|
} elseif ((is_error_message()) || (ierv('local_graph_id')) || (gnrv('graph_template_id') != gnrv('graph_template_id_prev')) || (gnrv('host_id') != gnrv('host_id_prev'))) {
|
|
$redirect_params = [
|
|
'action' => 'graph_edit',
|
|
'id' => empty($local_graph_id) ? gnrv('local_graph_id') : $local_graph_id,
|
|
];
|
|
|
|
if (isrv('host_id')) {
|
|
$redirect_params['host_id'] = gnrv('host_id');
|
|
}
|
|
|
|
cacti_redirect('graphs.php', $redirect_params);
|
|
} elseif (!empty($local_graph_id)) {
|
|
cacti_redirect('graphs.php', [
|
|
'action' => 'graph_edit',
|
|
'id' => $local_graph_id,
|
|
]);
|
|
} else {
|
|
cacti_redirect('graphs.php');
|
|
}
|
|
}
|
|
|
|
function item_movedown() : void {
|
|
global $graph_item_types;
|
|
|
|
// ================= input validation =================
|
|
gfrv('id');
|
|
gfrv('local_graph_id');
|
|
// ====================================================
|
|
|
|
$arr = get_graph_group(grv('id'));
|
|
$next_id = get_graph_parent(grv('id'), 'next');
|
|
|
|
if ((!empty($next_id)) && (isset($arr[grv('id')]))) {
|
|
move_graph_group(grv('id'), $arr, $next_id, 'next');
|
|
} elseif (preg_match('/(GPRINT|VRULE|HRULE|COMMENT)/', $graph_item_types[db_fetch_cell_prepared('SELECT graph_type_id FROM graph_templates_item WHERE id = ?', [grv('id')])])) {
|
|
move_item_down('graph_templates_item', grv('id'), 'local_graph_id=' . grv('local_graph_id'));
|
|
}
|
|
}
|
|
|
|
function item_moveup() : void {
|
|
global $graph_item_types;
|
|
|
|
// ================= input validation =================
|
|
gfrv('id');
|
|
gfrv('local_graph_id');
|
|
// ====================================================
|
|
|
|
$arr = get_graph_group(grv('id'));
|
|
$previous_id = get_graph_parent(grv('id'), 'previous');
|
|
|
|
if ((!empty($previous_id)) && (isset($arr[grv('id')]))) {
|
|
move_graph_group(grv('id'), $arr, $previous_id, 'previous');
|
|
} elseif (preg_match('/(GPRINT|VRULE|HRULE|COMMENT)/', $graph_item_types[db_fetch_cell_prepared('SELECT graph_type_id FROM graph_templates_item WHERE id = ?', [grv('id')])])) {
|
|
move_item_up('graph_templates_item', grv('id'), 'local_graph_id=' . grv('local_graph_id'));
|
|
}
|
|
}
|
|
|
|
function item_remove() : void {
|
|
// ================= input validation =================
|
|
gfrv('id');
|
|
// ====================================================
|
|
|
|
db_execute_prepared('DELETE FROM graph_templates_item WHERE id = ?', [grv('id')]);
|
|
}
|
|
|
|
function validate_item_vars() : void {
|
|
// ================= input validation and session storage =================
|
|
$filters = [
|
|
'host_id' => [
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '0'
|
|
],
|
|
'local_graph_id' => [
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '0'
|
|
],
|
|
'data_template_id' => [
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '0'
|
|
]
|
|
];
|
|
|
|
validate_store_request_vars($filters, 'sess_gitems');
|
|
// ================= input validation =================
|
|
}
|
|
|
|
function create_item_filter(string $session_var) : array {
|
|
global $item_rows;
|
|
|
|
$all = ['-1' => __('All')];
|
|
$any = ['-1' => __('Any')];
|
|
$none = ['0' => __('None')];
|
|
|
|
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');
|
|
}
|
|
|
|
if (grv('host_id') <= 0) {
|
|
$data_templates = array_rekey(
|
|
db_fetch_assoc('SELECT id, name
|
|
FROM data_template
|
|
ORDER BY name'),
|
|
'id', 'name'
|
|
);
|
|
} else {
|
|
$data_templates = array_rekey(
|
|
db_fetch_assoc_prepared('SELECT DISTINCT dt.id, dt.name
|
|
FROM data_template AS dt
|
|
INNER JOIN data_local AS dl
|
|
ON dl.data_template_id=dt.id
|
|
WHERE dl.host_id = ?
|
|
ORDER BY name',
|
|
[grv('host_id')]),
|
|
'id', 'name'
|
|
);
|
|
}
|
|
|
|
$data_templates = $any + $none + $data_templates;
|
|
|
|
return [
|
|
'rows' => [
|
|
[
|
|
'host_id' => [
|
|
'method' => 'drop_callback',
|
|
'friendly_name' => __('Device'),
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '-1',
|
|
'sql' => 'SELECT DISTINCT id, description AS name FROM host ORDER BY description',
|
|
'action' => 'ajax_hosts',
|
|
'id' => $host_id,
|
|
'value' => $hostname,
|
|
'on_change' => 'applyFilter()'
|
|
],
|
|
],
|
|
[
|
|
'data_template_id' => [
|
|
'method' => 'drop_array',
|
|
'friendly_name' => __('Template'),
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '-1',
|
|
'array' => $data_templates,
|
|
'value' => '-1'
|
|
],
|
|
'id' => [
|
|
'method' => 'validate',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '',
|
|
'value' => gfrv('id')
|
|
],
|
|
'local_graph_id' => [
|
|
'method' => 'validate',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '',
|
|
'value' => gfrv('host_id')
|
|
]
|
|
]
|
|
]
|
|
];
|
|
}
|
|
|
|
function draw_item_filter(bool $render = false, array $host = []) : void {
|
|
$filters = create_item_filter('sess_graphs');
|
|
|
|
if (empty($host['hostname'])) {
|
|
$header = __('Data Sources [No Device]');
|
|
} else {
|
|
$header = __esc('Data Sources [%s]', $host['hostname']);
|
|
}
|
|
|
|
// create the page filter
|
|
$pageFilter = new CactiTableFilter($header, 'graphs.php?action=item_edit&local_graph_id=' . grv('local_graph_id'), 'form_graphs', 'sess_graphs', '', '', false);
|
|
|
|
$pageFilter->set_filter_array($filters);
|
|
|
|
if ($render) {
|
|
$pageFilter->render();
|
|
} else {
|
|
$pageFilter->sanitize();
|
|
}
|
|
}
|
|
|
|
function item_edit() : void {
|
|
global $struct_graph_item, $graph_item_types, $consolidation_functions;
|
|
|
|
$id = (!ierv('id') ? '&id=' . (int) gfrv('id') : '');
|
|
|
|
$host = db_fetch_row_prepared('SELECT hostname
|
|
FROM host
|
|
WHERE id = ?',
|
|
[grv('host_id')]
|
|
);
|
|
|
|
draw_item_filter(true, $host);
|
|
|
|
// This column is for Graph Templates
|
|
unset($struct_graph_item['data_template_id']);
|
|
|
|
validate_item_vars();
|
|
|
|
if (empty($host['hostname'])) {
|
|
$header = __('Data Sources [No Device]');
|
|
} else {
|
|
$header = __esc('Data Sources [%s]', $host['hostname']);
|
|
}
|
|
|
|
load_current_session_value('host_id', 'sess_graph_items_hi', '-1');
|
|
load_current_session_value('data_template_id', 'sess_graph_items_dti', '-1');
|
|
|
|
$sql_where = '';
|
|
|
|
if (grv('host_id') > 0) {
|
|
$sql_where = 'h.id = ' . grv('host_id');
|
|
} elseif (grv('host_id') == 0) {
|
|
$sql_where = 'h.id IS NULL';
|
|
}
|
|
|
|
if (grv('data_template_id') == '0') {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : '') . 'dl.data_template_id=0';
|
|
} elseif (grv('data_template_id') > 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : '') . 'dl.data_template_id = ' . grv('data_template_id');
|
|
}
|
|
|
|
if (!ierv('id')) {
|
|
$template_item = db_fetch_row_prepared('SELECT *
|
|
FROM graph_templates_item
|
|
WHERE id = ?',
|
|
[grv('id')]
|
|
);
|
|
} else {
|
|
$template_item = [];
|
|
|
|
kill_session_var('sess_graph_items_dti');
|
|
}
|
|
|
|
$title = db_fetch_cell_prepared('SELECT title_cache
|
|
FROM graph_templates_graph
|
|
WHERE local_graph_id = ?',
|
|
[grv('local_graph_id')]
|
|
);
|
|
|
|
$header_label = __esc('Graph Items [graph: %s]', $title);
|
|
|
|
form_start('graphs.php', 'graph_edit');
|
|
|
|
html_start_box($header_label, '100%', true, 3, 'center', '');
|
|
|
|
// by default, select the LAST DS chosen to make everyone's lives easier
|
|
if (!ierv('local_graph_id')) {
|
|
$struct_graph_item['task_item_id']['default'] = 0;
|
|
|
|
if (isset($template_item['task_item_id'])) {
|
|
$task_item_id = $template_item['task_item_id'];
|
|
|
|
$value = db_fetch_cell_prepared("SELECT CONCAT_WS('', dtd.name_cache,' (', dtr.data_source_name, ')') as name
|
|
FROM data_local AS dl
|
|
INNER JOIN data_template_data AS dtd
|
|
ON dtd.local_data_id=dl.id
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.local_data_id=dl.id
|
|
LEFT JOIN host AS h
|
|
ON dl.host_id=h.id
|
|
WHERE dtr.id = ?",
|
|
[$task_item_id]
|
|
);
|
|
} else {
|
|
$task_item_id = 0;
|
|
|
|
$value = '';
|
|
}
|
|
|
|
$action = 'ajax_graph_items';
|
|
|
|
if (grv('host_id') > 0) {
|
|
$action .= '&host_id=' . gfrv('host_id');
|
|
}
|
|
|
|
if (grv('data_template_id') > 0) {
|
|
$action .= '&data_template_id=' . gfrv('data_template_id');
|
|
}
|
|
|
|
$struct_graph_item['task_item_id'] = [
|
|
'method' => 'drop_callback',
|
|
'friendly_name' => __('Data Source'),
|
|
'description' => __('Choose the Data Source to associate with this Graph Item.'),
|
|
'sql' => '',
|
|
'action' => $action,
|
|
'none_value' => __('None'),
|
|
'id' => $task_item_id,
|
|
'value' => $value
|
|
];
|
|
|
|
// modifications to the default graph items array
|
|
$struct_graph_item['task_item_id']['sql'] = "SELECT
|
|
CONCAT_WS('', dtd.name_cache,' (', dtr.data_source_name, ')') as name, dtr.id
|
|
FROM data_local AS dl
|
|
INNER JOIN data_template_data AS dtd
|
|
ON dtd.local_data_id=dl.id
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.local_data_id=dl.id
|
|
LEFT JOIN host AS h
|
|
ON dl.host_id=h.id";
|
|
|
|
// Make sure we don't limit the list so that the selected DS isn't in the list in edit mode
|
|
if ($sql_where != '') {
|
|
if (!ierv('id')) {
|
|
$struct_graph_item['task_item_id']['sql'] .= " WHERE ($sql_where) OR (dtr.id=" . $template_item['task_item_id'] . ')';
|
|
} else {
|
|
$struct_graph_item['task_item_id']['sql'] .= " WHERE $sql_where";
|
|
}
|
|
}
|
|
|
|
$struct_graph_item['task_item_id']['sql'] .= ' ORDER BY name';
|
|
}
|
|
|
|
$form_array = [];
|
|
|
|
foreach ($struct_graph_item as $field_name => $field_array) {
|
|
$form_array += [$field_name => $struct_graph_item[$field_name]];
|
|
|
|
if ($field_name != 'task_item_id') {
|
|
$form_array[$field_name]['value'] = (isset($template_item[$field_name]) ? $template_item[$field_name] : '');
|
|
}
|
|
|
|
$form_array[$field_name]['form_id'] = (isset($template_item['id']) ? $template_item['id'] : '0');
|
|
}
|
|
|
|
draw_edit_form(
|
|
[
|
|
'config' => ['no_form_tag' => true],
|
|
'fields' => $form_array
|
|
]
|
|
);
|
|
|
|
form_hidden_box('local_graph_id', grv('local_graph_id'), '0');
|
|
form_hidden_box('graph_template_item_id', (!empty($template_item) ? $template_item['id'] : '0'), '');
|
|
form_hidden_box('local_graph_template_item_id', (!empty($template_item) ? $template_item['local_graph_template_item_id'] : '0'), '');
|
|
form_hidden_box('graph_template_id', (!empty($template_item) ? $template_item['graph_template_id'] : '0'), '');
|
|
form_hidden_box('_graph_type_id', (!empty($template_item) ? $template_item['graph_type_id'] : '0'), '');
|
|
form_hidden_box('save_component_item', '1', '');
|
|
form_hidden_box('invisible_alpha', $form_array['alpha']['value'], 'FF');
|
|
form_hidden_box('rrdtool_version', get_rrdtool_version(), '');
|
|
|
|
html_end_box(true, true);
|
|
|
|
form_save_button('graphs.php?action=graph_edit&id=' . grv('local_graph_id'));
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
$(function() {
|
|
$('#shift').click(function(data) {
|
|
toggleFields({
|
|
value: $('#shift').is(':checked'),
|
|
});
|
|
});
|
|
|
|
setRowVisibility();
|
|
cdefAlignment();
|
|
|
|
if ($('#cdef_id').selectmenu('instance') !== undefined) {
|
|
$('#cdef_id').selectmenu('destroy');
|
|
$('#cdef_id').selectmenu({
|
|
open: function() {
|
|
cdefAlignment();
|
|
}
|
|
});
|
|
} else {
|
|
$('#cdef_id').click(function() {
|
|
cdefAlignment();
|
|
});
|
|
}
|
|
|
|
$('#graph_type_id').change(function(data) {
|
|
setRowVisibility();
|
|
});
|
|
});
|
|
|
|
/**
|
|
* columns - task_item_id color_id alpha graph_type_id consolidation_function_id cdef_id value gprint_id text_format hard_return
|
|
*
|
|
* graph_type_ids
|
|
* 1 - Comment
|
|
* 2 - HRule
|
|
* 3 - Vrule
|
|
* 4 - Line1
|
|
* 5 - Line2
|
|
* 6 - Line3
|
|
* 7 - Area
|
|
* 8 - Stack
|
|
* 9 - Gprint
|
|
* 10 - Legend
|
|
*
|
|
*/
|
|
|
|
function changeColorId() {
|
|
$('#alpha').prop('disabled', true);
|
|
|
|
if ($('#color_id').val() != 0) {
|
|
$('#alpha').prop('disabled', false);
|
|
}
|
|
|
|
switch ($('#graph_type_id').val()) {
|
|
case '4':
|
|
case '5':
|
|
case '6':
|
|
case '7':
|
|
case '8':
|
|
$('#alpha').prop('disabled', false);
|
|
}
|
|
}
|
|
|
|
function changeColor2Id() {
|
|
$('#alpha2').prop('disabled', true);
|
|
|
|
if ($('#color2_id').val() != 0) {
|
|
$('#alpha2').prop('disabled', false);
|
|
}
|
|
|
|
switch ($('#graph_type_id').val()) {
|
|
case '7':
|
|
case '8':
|
|
$('#alpha2').prop('disabled', false);
|
|
}
|
|
}
|
|
|
|
function cdefAlignment() {
|
|
if ($('#task_item_id').val() == '0') {
|
|
$('#cdef_id option').each(function() {
|
|
if ($(this).text().indexOf('_AGGREGATE') >= 0) {
|
|
$(this).prop('disabled', true);
|
|
}
|
|
});
|
|
} else {
|
|
$('#cdef_id option').each(function() {
|
|
if ($(this).text().indexOf('_AGGREGATE') >= 0) {
|
|
$(this).prop('disabled', false);
|
|
$(this).removeAttr('disabled');
|
|
}
|
|
});
|
|
}
|
|
|
|
if ($('#cdef_id').selectmenu('instance') !== undefined) {
|
|
$('#cdef_id').selectmenu('refresh');
|
|
}
|
|
}
|
|
|
|
function applyFilter() {
|
|
strURL = 'graphs.php?action=item_edit<?php print $id; ?>' +
|
|
'&local_graph_id=<?php print (int) gfrv('local_graph_id'); ?>' +
|
|
'&data_template_id=' + $('#data_template_id').val() +
|
|
'&host_id=' + $('#host_id').val();
|
|
|
|
loadUrl({
|
|
url: strURL
|
|
})
|
|
}
|
|
|
|
var graphType = $('#graph_type_id').val();
|
|
function setRowVisibility() {
|
|
toggleFields({
|
|
data_template_id: graphType != 3 && graphType != 40,
|
|
task_item_id: graphType != 3 && graphType != 40,
|
|
color_id: (graphType > 1 && graphType < 9) || graphType == 20 || graphType == 30,
|
|
color2_id: graphType == 7 || graphType == 8,
|
|
line_width: (graphType > 3 && graphType < 7) || graphType == 20,
|
|
dashes: (graphType > 1 && graphType < 7) || graphType == 20,
|
|
dash_offset: (graphType > 1 && graphType < 7) || graphType == 20,
|
|
textalign: graphType == 40,
|
|
shift: (graphType > 3 && graphType < 9) || graphType == 20,
|
|
alpha: (graphType > 3 && graphType < 9) || graphType == 20 || graphType == 40,
|
|
alpha2: graphType == 7 || graphType == 8,
|
|
gradheight: graphType == 7 || graphType == 8,
|
|
consolidation_function_id: graphType == 1 || (graphType > 3 && graphType != 10 && graphType != 15 && graphType != 30 && graphType != 40),
|
|
cdef_id: graphType > 3 && graphType != 40,
|
|
vdef_id: graphType > 3 && graphType != 40,
|
|
value: graphType == 2 || graphType == 3 || graphType == 30,
|
|
gprint_id: graphType > 8 && graphType < 16,
|
|
text_format: graphType >= 1 && graphType != 10 && graphType != 15 && graphType != 40,
|
|
legend: (graphType > 1 && graphType < 9) || graphType == 20 || graphType == 30,
|
|
hard_return: graphType >= 1 && graphType != 10 && graphType != 15 && graphType != 40,
|
|
});
|
|
|
|
changeColorId();
|
|
changeColor2Id();
|
|
cdefAlignment();
|
|
}
|
|
</script>
|
|
<?php
|
|
}
|
|
|
|
function get_current_graph_template(int $local_graph_id) : string {
|
|
$graph_local = db_fetch_row_prepared('SELECT *
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[$local_graph_id]);
|
|
|
|
$task_items = db_fetch_cell_prepared('SELECT GROUP_CONCAT(DISTINCT task_item_id) AS items
|
|
FROM graph_templates_item
|
|
WHERE local_graph_id = ?',
|
|
[$local_graph_id]);
|
|
|
|
if ($task_items != '') {
|
|
$local_data_id = db_fetch_cell("SELECT DISTINCT local_data_id
|
|
FROM data_template_rrd
|
|
WHERE id IN($task_items)");
|
|
} else {
|
|
$local_data_id = 0;
|
|
}
|
|
|
|
if ($local_data_id > 0) {
|
|
$data = db_fetch_row_prepared('SELECT id, data_input_id, data_template_id, name, local_data_id
|
|
FROM data_template_data
|
|
WHERE local_data_id = ?',
|
|
[$local_data_id]);
|
|
|
|
// get each INPUT field for this data input source
|
|
$output_type_field_id = db_fetch_cell_prepared('SELECT id
|
|
FROM data_input_fields
|
|
WHERE data_input_id = ?
|
|
AND input_output="in"
|
|
AND type_code="output_type"
|
|
ORDER BY sequence',
|
|
[$data['data_input_id']]);
|
|
|
|
$snmp_query_graph_id = db_fetch_cell_prepared('SELECT value
|
|
FROM data_input_data
|
|
WHERE data_template_data_id = ?
|
|
AND data_input_field_id = ?',
|
|
[$data['id'], $output_type_field_id]);
|
|
|
|
if (!empty($snmp_query_graph_id)) {
|
|
return $graph_local['graph_template_id'] . '_' . $snmp_query_graph_id;
|
|
} else {
|
|
return $graph_local['graph_template_id'];
|
|
}
|
|
} else {
|
|
return $graph_local['graph_template_id'];
|
|
}
|
|
}
|
|
|
|
function get_common_graph_templates(array &$graph) : string {
|
|
$dqid = 0;
|
|
|
|
if (cacti_sizeof($graph)) {
|
|
$dqid = db_fetch_cell_prepared('SELECT snmp_query_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[$graph['local_graph_id']]);
|
|
}
|
|
|
|
// Default in worst case
|
|
$gtsql = 'SELECT gt.id, gt.name FROM graph_templates AS gt ORDER BY name';
|
|
|
|
if ($dqid > 0) {
|
|
$sqgi = db_fetch_cell_prepared('SELECT GROUP_CONCAT(id) AS id
|
|
FROM snmp_query_graph
|
|
WHERE snmp_query_id = ?
|
|
AND graph_template_id = ?',
|
|
[$dqid, $graph['graph_template_id']]);
|
|
|
|
if ($sqgi != '') {
|
|
$query_fields = array_rekey(db_fetch_assoc_prepared('SELECT snmp_query_graph_id,
|
|
GROUP_CONCAT(snmp_field_name ORDER BY snmp_field_name) AS columns
|
|
FROM snmp_query_graph_rrd
|
|
WHERE snmp_query_graph_id IN (' . $sqgi . ')
|
|
GROUP BY snmp_query_graph_id'), 'snmp_query_graph_id', 'columns');
|
|
|
|
if (cacti_sizeof($query_fields)) {
|
|
$ids = array_to_sql_or(array_values($query_fields), 'columns');
|
|
|
|
$common_graph_ids = array_rekey(db_fetch_assoc_prepared('SELECT
|
|
snmp_query_graph_id, GROUP_CONCAT(snmp_field_name ORDER BY snmp_field_name) AS columns
|
|
FROM snmp_query_graph_rrd
|
|
GROUP BY snmp_query_graph_id
|
|
HAVING ' . $ids), 'snmp_query_graph_id', 'columns');
|
|
|
|
if (cacti_sizeof($common_graph_ids)) {
|
|
$ids = implode(',', array_keys($common_graph_ids));
|
|
|
|
$gtids = db_fetch_cell_prepared('SELECT GROUP_CONCAT(DISTINCT graph_template_id) AS gtids
|
|
FROM snmp_query_graph
|
|
WHERE snmp_query_id = ?
|
|
AND id IN (' . $ids . ')',
|
|
[$dqid]);
|
|
|
|
if ($gtids != '') {
|
|
$gtsql = "SELECT CONCAT_WS('', graph_template_id, '_', id, '') AS id, name
|
|
FROM snmp_query_graph
|
|
WHERE (snmp_query_id = $dqid AND id IN ($ids))
|
|
OR graph_template_id IN ($gtids) ORDER BY name";
|
|
} else {
|
|
$gtsql = "SELECT CONCAT_WS('', graph_template_id, '_', id, '') AS id, name
|
|
FROM snmp_query_graph
|
|
WHERE (snmp_query_id = $dqid AND id IN ($ids))
|
|
ORDER BY name";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
return $gtsql;
|
|
}
|
|
|
|
function form_actions() : void {
|
|
global $actions, $struct_aggregate;
|
|
global $alignment, $graph_timespans;
|
|
|
|
// ================= input validation =================
|
|
gfrv('drp_action', FILTER_VALIDATE_REGEXP, ['options' => ['regexp' => '/^([a-zA-Z0-9_]+)$/']]);
|
|
// ====================================================
|
|
|
|
// if we are to save this form, instead of display it
|
|
if (isrv('selected_items')) {
|
|
$selected_items = sanitize_unserialize_selected_items(gnrv('selected_items'));
|
|
|
|
if ($selected_items != false) {
|
|
if (grv('drp_action') == '1') { // delete
|
|
if (!isrv('delete_type')) {
|
|
srv('delete_type', 2);
|
|
}
|
|
|
|
api_delete_graphs($selected_items, gfrv('delete_type'));
|
|
} elseif (grv('drp_action') == '2') { // change graph template
|
|
$gt_id_unparsed = gnrv('graph_template_id');
|
|
$gt_id_prev_unparsed = gnrv('graph_template_id_prev');
|
|
parse_validate_graph_template_id('graph_template_id');
|
|
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
change_graph_template($selected_items[$i], $gt_id_unparsed, true);
|
|
}
|
|
} elseif (grv('drp_action') == '3') { // duplicate
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
api_duplicate_graph($selected_items[$i], 0, gnrv('title_format'));
|
|
}
|
|
} elseif (grv('drp_action') == '4') { // graph -> graph template
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
graph_to_graph_template($selected_items[$i], gnrv('title_format'));
|
|
}
|
|
} elseif (preg_match('/^tr_([0-9]+)$/', grv('drp_action'), $matches)) { // place on tree
|
|
gfrv('tree_id');
|
|
gfrv('tree_item_id');
|
|
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
api_tree_item_save(0, gnrv('tree_id'), TREE_ITEM_TYPE_GRAPH, gnrv('tree_item_id'), '', $selected_items[$i], 0, 0, 0, 0, false);
|
|
}
|
|
} elseif (grv('drp_action') == '5') { // change host
|
|
$failures = 0;
|
|
$success = 0;
|
|
$host_id = gfrv('host_id');
|
|
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
$local_graph_id = $selected_items[$i];
|
|
|
|
$title = db_fetch_cell_prepared('SELECT title_cache
|
|
FROM graph_templates_graph
|
|
WHERE local_graph_id = ?',
|
|
[$local_graph_id]);
|
|
|
|
if (api_graph_change_device($local_graph_id, $host_id)) {
|
|
raise_message('moved_' . $local_graph_id, __esc('Graph %s Moved to new Device', $title), MESSAGE_LEVEL_INFO);
|
|
$success++;
|
|
} else {
|
|
raise_message('notmoved_' . $local_graph_id, __esc('Graph %s not Moved. Device missing Data Query', $title), MESSAGE_LEVEL_WARN);
|
|
$failures++;
|
|
}
|
|
}
|
|
} elseif (grv('drp_action') == '6') { // reapply suggested naming
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
api_reapply_suggested_graph_title($selected_items[$i]);
|
|
update_graph_title_cache($selected_items[$i]);
|
|
}
|
|
} elseif (grv('drp_action') == '9' || grv('drp_action') == '10') {
|
|
// get common info - not dependent on template/no template
|
|
$local_graph_id = 0; // this will be a new graph
|
|
$member_graphs = $selected_items;
|
|
$graph_title = CactiValidator::validateInput(gnrv('title_format'), 'title_format', [], 3);
|
|
|
|
// future aggregate_graphs entry
|
|
$ag_data = [];
|
|
$ag_data['id'] = 0;
|
|
$ag_data['title_format'] = $graph_title;
|
|
$ag_data['user_id'] = $_SESSION[SESS_USER_ID];
|
|
|
|
if (grv('drp_action') == '9') {
|
|
if (!isrv('aggregate_total_type')) {
|
|
srv('aggregate_total_type', 0);
|
|
}
|
|
|
|
if (!isrv('aggregate_total')) {
|
|
srv('aggregate_total', 0);
|
|
}
|
|
|
|
if (!isrv('aggregate_total_prefix')) {
|
|
srv('aggregate_total_prefix', '');
|
|
}
|
|
|
|
if (!isrv('aggregate_order_type')) {
|
|
srv('aggregate_order_type', 0);
|
|
}
|
|
|
|
$item_no = CactiValidator::validateInput(gnrv('item_no'), 'item_no', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
|
|
$ag_data['aggregate_template_id'] = 0;
|
|
$ag_data['template_propogation'] = '';
|
|
$ag_data['graph_template_id'] = CactiValidator::validateInput(gnrv('graph_template_id'), 'graph_template_id', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$ag_data['gprint_prefix'] = CactiValidator::validateInput(gnrv('gprint_prefix'), 'gprint_prefix', [], 3);
|
|
$ag_data['gprint_format'] = isset_request_var('gprint_format') ? 'on' : '';
|
|
$ag_data['graph_type'] = CactiValidator::validateInput(gnrv('aggregate_graph_type'), 'aggregate_graph_type', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$ag_data['total'] = CactiValidator::validateInput(gnrv('aggregate_total'), 'aggregate_total', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$ag_data['total_type'] = CactiValidator::validateInput(gnrv('aggregate_total_type'), 'aggregate_total_type', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
$ag_data['total_prefix'] = CactiValidator::validateInput(gnrv('aggregate_total_prefix'), 'aggregate_total_prefix', [], 3);
|
|
$ag_data['order_type'] = CactiValidator::validateInput(gnrv('aggregate_order_type'), 'aggregate_order_type', [new Assert\Regex('/^[0-9]+$/')], 3);
|
|
} else {
|
|
$template_data = db_fetch_row_prepared('SELECT *
|
|
FROM aggregate_graph_templates
|
|
WHERE id = ?',
|
|
[gnrv('aggregate_template_id')]);
|
|
|
|
$item_no = db_fetch_cell_prepared('SELECT COUNT(*)
|
|
FROM aggregate_graph_templates_item
|
|
WHERE aggregate_template_id = ?',
|
|
[gnrv('aggregate_template_id')]);
|
|
|
|
$ag_data['aggregate_template_id'] = gnrv('aggregate_template_id');
|
|
$ag_data['template_propogation'] = 'on';
|
|
$ag_data['graph_template_id'] = $template_data['graph_template_id'];
|
|
$ag_data['gprint_prefix'] = $template_data['gprint_prefix'];
|
|
$ag_data['gprint_format'] = $template_data['gprint_format'];
|
|
$ag_data['graph_type'] = $template_data['graph_type'];
|
|
$ag_data['total'] = $template_data['total'];
|
|
$ag_data['total_type'] = $template_data['total_type'];
|
|
$ag_data['total_prefix'] = $template_data['total_prefix'];
|
|
$ag_data['order_type'] = $template_data['order_type'];
|
|
}
|
|
|
|
$original_local_graph_id = $local_graph_id;
|
|
|
|
if (!db_begin_transaction()) {
|
|
raise_message('aggregate_transaction_failed', __('Unable to start the aggregate graph update.'), MESSAGE_LEVEL_ERROR);
|
|
header('Location: aggregate_graphs.php');
|
|
|
|
exit;
|
|
}
|
|
|
|
// create graph in cacti tables
|
|
$local_graph_id = aggregate_graph_save(
|
|
$local_graph_id,
|
|
$ag_data['graph_template_id'],
|
|
$graph_title,
|
|
$ag_data['aggregate_template_id']
|
|
);
|
|
|
|
$ag_data['local_graph_id'] = $local_graph_id;
|
|
$aggregate_graph_id = sql_save($ag_data, 'aggregate_graphs');
|
|
$ag_data['aggregate_graph_id'] = $aggregate_graph_id;
|
|
|
|
// /* save member graph info */
|
|
// $i = 1;
|
|
// foreach($member_graphs as $graph_id) {
|
|
// db_execute("INSERT INTO aggregate_graphs_items
|
|
// (aggregate_graph_id, local_graph_id, sequence)
|
|
// VALUES
|
|
// ($aggregate_graph_id, $graph_id, $i)"
|
|
// );
|
|
// $i++;
|
|
// }
|
|
|
|
// save aggregate graph - graph items
|
|
if (grv('drp_action') == '9') {
|
|
// get existing item ids and sequences from graph template
|
|
$graph_templates_items = array_rekey(
|
|
db_fetch_assoc_prepared('SELECT id, sequence
|
|
FROM graph_templates_item
|
|
WHERE local_graph_id=0
|
|
AND graph_template_id = ?',
|
|
[$ag_data['graph_template_id']]),
|
|
'id', ['sequence']
|
|
);
|
|
|
|
// update graph template item values with posted values
|
|
aggregate_validate_graph_items($_POST, $graph_templates_items);
|
|
|
|
$aggregate_graph_items = [];
|
|
|
|
foreach ($graph_templates_items as $item_id => $data) {
|
|
$item_new = [];
|
|
$item_new['aggregate_graph_id'] = $aggregate_graph_id;
|
|
$item_new['graph_templates_item_id'] = $item_id;
|
|
|
|
$item_new['color_template'] = isset($data['color_template']) ? $data['color_template'] : 0;
|
|
$item_new['item_skip'] = isset($data['item_skip']) ? 'on' : '';
|
|
$item_new['item_total'] = isset($data['item_total']) ? 'on' : '';
|
|
$item_new['sequence'] = isset($data['sequence']) ? $data['sequence'] : 0;
|
|
|
|
$aggregate_graph_items[] = $item_new;
|
|
}
|
|
|
|
aggregate_graph_items_save($aggregate_graph_items, 'aggregate_graphs_graph_item');
|
|
} else {
|
|
$aggregate_graph_items = db_fetch_assoc_prepared('SELECT *
|
|
FROM aggregate_graph_templates_item
|
|
WHERE aggregate_template_id = ?',
|
|
[$ag_data['aggregate_template_id']]);
|
|
}
|
|
|
|
$attribs = $ag_data;
|
|
$attribs['graph_title'] = $ag_data['title_format'];
|
|
$attribs['reorder'] = $ag_data['order_type'];
|
|
$attribs['item_no'] = $item_no;
|
|
$attribs['color_templates'] = [];
|
|
$attribs['skipped_items'] = [];
|
|
$attribs['total_items'] = [];
|
|
$attribs['graph_item_types'] = [];
|
|
$attribs['cdefs'] = [];
|
|
|
|
foreach ($aggregate_graph_items as $item) {
|
|
if (isset($item['color_template']) && $item['color_template'] > 0) {
|
|
$attribs['color_templates'][$item['sequence']] = $item['color_template'];
|
|
}
|
|
|
|
if (isset($item['item_skip']) && $item['item_skip'] == 'on') {
|
|
$attribs['skipped_items'][$item['sequence']] = $item['sequence'];
|
|
}
|
|
|
|
if (isset($item['item_total']) && $item['item_total'] == 'on') {
|
|
$attribs['total_items'][$item['sequence']] = $item['sequence'];
|
|
}
|
|
|
|
if (isset($item['cdef_id']) && isset($item['t_cdef_id']) && $item['t_cdef_id'] == 'on') {
|
|
$attribs['cdefs'][$item['sequence']] = $item['cdef_id'];
|
|
}
|
|
|
|
if (isset($item['graph_type_id']) && isset($item['t_graph_type_id']) && $item['t_graph_type_id'] == 'on') {
|
|
$attribs['graph_item_types'][$item['sequence']] = $item['graph_type_id'];
|
|
}
|
|
}
|
|
|
|
// create actual graph items
|
|
if (!aggregate_create_update($local_graph_id, $member_graphs, $attribs, false)) {
|
|
db_rollback_transaction();
|
|
$local_graph_id = $original_local_graph_id;
|
|
header('Location: aggregate_graphs.php');
|
|
|
|
exit;
|
|
}
|
|
|
|
if (!db_commit_transaction()) {
|
|
db_rollback_transaction();
|
|
$local_graph_id = $original_local_graph_id;
|
|
raise_message('aggregate_commit_failed', __('Unable to commit the aggregate graph update.'), MESSAGE_LEVEL_ERROR);
|
|
header('Location: aggregate_graphs.php');
|
|
|
|
exit;
|
|
}
|
|
|
|
header("Location: aggregate_graphs.php?action=edit&tab=details&id=$local_graph_id");
|
|
|
|
exit;
|
|
} elseif (grv('drp_action') == '8') { // automation
|
|
cacti_log('automation_graph_action_execute called: ' . grv('drp_action'), true, 'AUTM8 TRACE', POLLER_VERBOSITY_MEDIUM);
|
|
|
|
// work on all selected graphs
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
automation_execute_graph_create_tree($selected_items[$i]);
|
|
}
|
|
} elseif (grv('drp_action') == '11') {
|
|
// Add to a report
|
|
$good = true;
|
|
|
|
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
|
|
if (!reports_add_graphs(gfrv('report_id'), $selected_items[$i], grv('timespan'), grv('align'))) {
|
|
raise_message('reports_add_error');
|
|
$good = false;
|
|
|
|
break;
|
|
}
|
|
}
|
|
|
|
if ($good) {
|
|
raise_message('reports_graphs_added');
|
|
}
|
|
} else {
|
|
api_plugin_hook_function('graphs_action_execute', grv('drp_action'));
|
|
}
|
|
|
|
// update snmpcache
|
|
snmpagent_graphs_action_bottom([grv('drp_action'), $selected_items]);
|
|
api_plugin_hook_function('graphs_action_bottom', [grv('drp_action'), $selected_items]);
|
|
}
|
|
|
|
if (grv('drp_action') == '2') { // change graph template
|
|
header('Location: graphs.php?template_id=-1');
|
|
} else {
|
|
header('Location: graphs.php');
|
|
}
|
|
|
|
exit;
|
|
} else {
|
|
$ilist = '';
|
|
$iarray = [];
|
|
$i = 0;
|
|
|
|
// global variables
|
|
$flist = '';
|
|
$footer = '';
|
|
$rbutton1 = '';
|
|
$rbutton2 = '';
|
|
$return = false;
|
|
$rmessage = '';
|
|
|
|
$garray = [];
|
|
$devices = [];
|
|
$atemplates = [];
|
|
$reports = [];
|
|
$data_sources = [];
|
|
$gtarray = [];
|
|
$iarray = [];
|
|
|
|
// loop through each of the graphs 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], 'chk[1]');
|
|
// ====================================================
|
|
|
|
$local_graph_id = intval($matches[1]);
|
|
|
|
$ilist .= '<li>' . htmle(get_graph_title($local_graph_id)) . '</li>';
|
|
|
|
$iarray[] = $matches[1];
|
|
|
|
if ($i == 0) {
|
|
$graph = db_fetch_row_prepared('SELECT id AS local_graph_id, graph_template_id
|
|
FROM graph_local
|
|
WHERE id = ?
|
|
LIMIT 1',
|
|
[$matches[1]]);
|
|
|
|
$gtsql = db_fetch_assoc(get_common_graph_templates($graph));
|
|
|
|
if (cacti_sizeof($gtsql)) {
|
|
$gtarray = array_rekey($gtsql, 'id', 'name');
|
|
}
|
|
|
|
$i++;
|
|
}
|
|
}
|
|
}
|
|
|
|
if (cacti_sizeof($iarray)) {
|
|
if (grv('drp_action') == '1') { // delete
|
|
$ds_preselected_delete = read_config_option('ds_preselected_delete');
|
|
|
|
if ($ds_preselected_delete == 'on') {
|
|
$rbutton1 = '2';
|
|
$rbutton2 = '1';
|
|
} else {
|
|
$rbutton1 = '1';
|
|
$rbutton2 = '2';
|
|
}
|
|
|
|
// find out which (if any) data sources are being used by this graph, so we can tell the user
|
|
if (cacti_sizeof($iarray)) {
|
|
$data_sources = array_rekey(
|
|
db_fetch_assoc('SELECT DISTINCT dtd.local_data_id, dtd.name_cache
|
|
FROM data_template_data AS dtd
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.local_data_id=dtd.local_data_id
|
|
INNER JOIN graph_templates_item AS gti
|
|
ON dtr.id=gti.task_item_id
|
|
WHERE ' . array_to_sql_or($iarray, 'gti.local_graph_id') . '
|
|
AND dtd.local_data_id > 0'),
|
|
'local_data_id', ['local_data_id', 'name_cache']);
|
|
|
|
// data sources to delete
|
|
$data_array = array_keys($data_sources);
|
|
|
|
if (cacti_sizeof($data_array)) {
|
|
$not_deletable = array_rekey(
|
|
db_fetch_assoc('SELECT DISTINCT dtd.local_data_id
|
|
FROM data_template_data AS dtd
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.local_data_id=dtd.local_data_id
|
|
INNER JOIN graph_templates_item AS gti
|
|
ON dtr.id=gti.task_item_id
|
|
WHERE gti.local_graph_id NOT IN(' . implode(',', $iarray) . ')
|
|
AND gti.local_graph_id NOT IN(SELECT local_graph_id FROM aggregate_graphs)
|
|
AND dtr.local_data_id IN(' . implode(',', $data_array) . ')
|
|
AND dtd.local_data_id > 0'),
|
|
'local_data_id', 'local_data_id');
|
|
} else {
|
|
$not_deletable = [];
|
|
}
|
|
|
|
if (cacti_sizeof($not_deletable)) {
|
|
$data_sources = array_rekey(
|
|
db_fetch_assoc('SELECT DISTINCT dtd.local_data_id, dtd.name_cache
|
|
FROM data_template_data AS dtd
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.local_data_id=dtd.local_data_id
|
|
INNER JOIN graph_templates_item AS gti
|
|
ON dtr.id=gti.task_item_id
|
|
WHERE gti.local_graph_id IN (' . implode(',', $iarray) . ')
|
|
AND gti.local_graph_id NOT IN(SELECT local_graph_id FROM aggregate_graphs)
|
|
AND dtr.local_data_id NOT IN (' . implode(',', $not_deletable) . ')
|
|
AND dtd.local_data_id > 0'),
|
|
'local_data_id', ['local_data_id', 'name_cache']);
|
|
}
|
|
}
|
|
|
|
if (cacti_sizeof($data_sources)) {
|
|
foreach ($data_sources as $id => $data) {
|
|
$flist .= '<li>' . htmle($data['name_cache']) . '</li>';
|
|
}
|
|
}
|
|
} elseif (grv('drp_action') == '5') {
|
|
$devices = array_rekey(
|
|
db_fetch_assoc("SELECT id, CONCAT_WS('', description, ' (',hostname,')') AS name
|
|
FROM host
|
|
ORDER BY description, hostname"),
|
|
'id', 'name'
|
|
);
|
|
} elseif (grv('drp_action') == '9') {
|
|
$return_code = false;
|
|
$data_sources = [];
|
|
$graph_template = '';
|
|
$message = '';
|
|
|
|
if (aggregate_get_data_sources($iarray, $data_sources, $graph_template, $message)) {
|
|
foreach ($data_sources as $ds) {
|
|
$flist .= '<li>' . htmle($ds['name_cache']) . '</li>';
|
|
}
|
|
|
|
$gprint_prefix = '|host_description|';
|
|
$ttitle = $iarray[0];
|
|
|
|
// aggregate form
|
|
$_aggregate_defaults = [
|
|
'title_format' => auto_title($ttitle),
|
|
'graph_template_id' => $graph_template,
|
|
'gprint_prefix' => $gprint_prefix
|
|
];
|
|
|
|
$helper_string = '|host_description|';
|
|
|
|
if ($graph_template > 0) {
|
|
$data_query = db_fetch_cell_prepared('SELECT snmp_query_id
|
|
FROM snmp_query_graph
|
|
WHERE graph_template_id = ?',
|
|
[$graph_template]);
|
|
|
|
if ($data_query > 0) {
|
|
$data_query_info = get_data_query_array($data_query);
|
|
|
|
foreach ($data_query_info['fields'] as $field_name => $field_array) {
|
|
if ($field_array['direction'] == 'input' || $field_array['direction'] == 'input-output') {
|
|
$helper_string .= ($helper_string != '' ? ', ' : '') . '|query_' . $field_name . '|';
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// Append the helper string
|
|
$struct_aggregate['suggestions'] = [
|
|
'method' => 'other',
|
|
'friendly_name' => __('Prefix Replacement Values'),
|
|
'description' => __('You may use these replacement values for the Prefix in the Aggregate Graph'),
|
|
'value' => $helper_string
|
|
];
|
|
|
|
// We are storing the stdout to a variable here
|
|
ob_start();
|
|
|
|
draw_edit_form(
|
|
[
|
|
'config' => ['no_form_tag' => true],
|
|
'fields' => inject_form_variables($struct_aggregate, $_aggregate_defaults)
|
|
]
|
|
);
|
|
|
|
// draw all graph items of first graph, including a html_start_box
|
|
draw_aggregate_graph_items_list(0, $graph_template);
|
|
|
|
graph_aggregate_javascript();
|
|
|
|
$footer = ob_get_clean();
|
|
} else {
|
|
$return = true;
|
|
$rmessage = $message;
|
|
}
|
|
} elseif (grv('drp_action') == '10') { // aggregate template
|
|
// initialize return code and graphs array
|
|
$data_sources = [];
|
|
$graph_template = '';
|
|
$message = '';
|
|
|
|
// find out which (if any) data sources are being used by this graph, so we can tell the user
|
|
if (aggregate_get_data_sources($iarray, $data_sources, $graph_template, $message)) {
|
|
$atemplates = db_fetch_assoc_prepared('SELECT id, name
|
|
FROM aggregate_graph_templates
|
|
WHERE graph_template_id = ?
|
|
ORDER BY name', [$graph_template]);
|
|
|
|
if (cacti_sizeof($atemplates)) {
|
|
$atemplates = array_rekey($atemplates, 'id', 'name');
|
|
} else {
|
|
$return = true;
|
|
$rmessage = __('There were not Aggregate Templates found for the selected Graphs');
|
|
}
|
|
} else {
|
|
$return = true;
|
|
$rmessage = $message;
|
|
}
|
|
} elseif (grv('drp_action') == '11') { // add to report
|
|
$reports = db_fetch_assoc_prepared('SELECT id, name
|
|
FROM reports
|
|
WHERE user_id = ?
|
|
ORDER BY name',
|
|
[$_SESSION[SESS_USER_ID]]);
|
|
|
|
if (cacti_sizeof($reports)) {
|
|
$reports = array_rekey($reports, 'id', 'name');
|
|
}
|
|
}
|
|
}
|
|
|
|
// for use by plugins
|
|
$save['drp_action'] = gnrv('drp_action');
|
|
$save['graph_list'] = $ilist;
|
|
$save['graph_array'] = $iarray;
|
|
|
|
$form_data = [
|
|
'general' => [
|
|
'page' => 'graphs.php',
|
|
'actions' => $actions,
|
|
'optvar' => 'drp_action',
|
|
'item_array' => $iarray,
|
|
'item_list' => $ilist
|
|
],
|
|
'options' => [
|
|
1 => [
|
|
'smessage' => __('Click \'Continue\' to Delete the following Graph.'),
|
|
'pmessage' => __('Click \'Continue\' to Delete following Graphs.'),
|
|
'scont' => __('Delete Graph'),
|
|
'pcont' => __('Delete Graphs'),
|
|
'flist' => $flist,
|
|
'sfmessage' => __n('The following Data Source is used by this Graph.', 'The following Data Sources are used by this Graph.', cacti_sizeof($data_sources)),
|
|
'pfmessage' => __n('The following Data Source is used by these Graphs.', 'The following Data Sources are used by these Graphs.', cacti_sizeof($iarray)),
|
|
'extra' => [
|
|
'delete_type' => [
|
|
'method' => 'radio',
|
|
'title' => __('Delete Method'),
|
|
'default' => read_config_option('ds_preselected_delete') == 'on' ? 2 : 1,
|
|
'items' => [
|
|
0 => [
|
|
'radio_value' => '2',
|
|
'radio_caption' => __n('Delete the Data Sources referenced by this Graph', 'Delete the Data Sources reference by these Graphs', cacti_sizeof($iarray))
|
|
],
|
|
1 => [
|
|
'radio_value' => '1',
|
|
'radio_caption' => __n('Leave the Data Source Untouched', 'Leave the Data Sources Untouched', cacti_sizeof($data_sources))
|
|
]
|
|
]
|
|
]
|
|
]
|
|
],
|
|
2 => [
|
|
'smessage' => __('Choose a Graph Template and click \'Continue\' to Change the Graph Template for the following Graph. Note that only compatible Graph Templates will be displayed. Compatible is identified by those having identical Data Sources.'),
|
|
'pmessage' => __('Choose a Graph Template and click \'Continue\' to Change the Graph Template for the following Graphs. Note that only compatible Graph Templates will be displayed. Compatible is identified by those having identical Data Sources.'),
|
|
'cont' => __('Change Graph Template'),
|
|
'extra' => [
|
|
'graph_template_id' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('New Graph Template'),
|
|
'default' => '',
|
|
'array' => $gtarray
|
|
]
|
|
]
|
|
],
|
|
3 => [
|
|
'smessage' => __('Click \'Continue\' to Duplicate the following Graph.'),
|
|
'pmessage' => __('Click \'Continue\' to Duplicate following Graphs.'),
|
|
'scont' => __('Duplicate Graph'),
|
|
'pcont' => __('Duplicate Graphs'),
|
|
'extra' => [
|
|
'title_format' => [
|
|
'method' => 'textbox',
|
|
'title' => __('Title Format'),
|
|
'default' => '<graph_title> (1)',
|
|
'width' => 255,
|
|
'size' => 30
|
|
]
|
|
]
|
|
],
|
|
4 => [
|
|
'smessage' => __('Click \'Continue\' to Convert the following Graph to a Graph Template.'),
|
|
'pmessage' => __('Click \'Continue\' to Convert the following Graphs to Graph Templates.'),
|
|
'scont' => __('Convert Graph to Template'),
|
|
'pcont' => __('Convert Graphs to Templates'),
|
|
'extra' => [
|
|
'title_format' => [
|
|
'method' => 'textbox',
|
|
'title' => __('Title Format'),
|
|
'default' => '<graph_title> Template',
|
|
'width' => 255,
|
|
'size' => 30
|
|
]
|
|
]
|
|
],
|
|
5 => [
|
|
'smessage' => __('Choose a Device and click \'Continue\' to Change the Graph to the new Device.'),
|
|
'pmessage' => __('Choose a Device and click \'Continue\' to Change the Graphs to the new Device.'),
|
|
'scont' => __('Change Graph to new Device'),
|
|
'pcont' => __('Change Graphs to new Device'),
|
|
'extra' => [
|
|
'host_id' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('New Device'),
|
|
'default' => '',
|
|
'array' => $devices
|
|
]
|
|
]
|
|
],
|
|
6 => [
|
|
'smessage' => __('Click \'Continue\' to Reapply Suggested Names the following Graph.'),
|
|
'pmessage' => __('Click \'Continue\' to Reapply Suggested Names for the following Graphs.'),
|
|
'scont' => __('Reapply Suggested Names for Graph'),
|
|
'pcont' => __('Reapply Suggested Names for Graphs')
|
|
],
|
|
8 => [
|
|
'smessage' => __('Click \'Continue\' to apply Automation Rules to the following Graph.'),
|
|
'pmessage' => __('Click \'Continue\' to apply Automation Rules to the following Graphs.'),
|
|
'scont' => __('Apply Automation Rules to Graph'),
|
|
'pcont' => __('Apply Automation Rules to Graphs')
|
|
],
|
|
9 => [
|
|
'smessage' => __('Click \'Continue\' to Create an Aggregate Graph from the selected Graph.'),
|
|
'pmessage' => __('Click \'Continue\' to Create an Aggregate Graph from the selected Graphs.'),
|
|
'cont' => __('Create Aggregate Graph'),
|
|
'return' => $return,
|
|
'rmessage' => $rmessage,
|
|
'footer' => $footer,
|
|
'flist' => $flist,
|
|
'sfmessage' => __n('The following Data Source is in use by this Graph.', 'The following Data Sources are in use by these Graphs.', cacti_sizeof($data_sources)),
|
|
'pfmessage' => __n('The following Data Source is in use by these Graphs.', 'The following Data Sources are in use by these Graphs.', cacti_sizeof($data_sources)),
|
|
],
|
|
10 => [
|
|
'smessage' => __('Choose an Aggregate Template and click \'Continue\' to Create the Aggregate Graph from the following Graph.'),
|
|
'pmessage' => __('Choose an Aggregate Template and click \'Continue\' to Create the Aggregate Graph from the following Graphs.'),
|
|
'cont' => __('Create Aggregate Graph'),
|
|
'return' => $return,
|
|
'rmessage' => $rmessage,
|
|
'extra' => [
|
|
'aggregate_template_id' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('Aggregate Template'),
|
|
'default' => '',
|
|
'array' => $atemplates,
|
|
]
|
|
]
|
|
],
|
|
11 => [
|
|
'smessage' => __('Click \'Continue\' to Place the following Graph on a Report.'),
|
|
'pmessage' => __('Click \'Continue\' to Place the following Graphs on a Report.'),
|
|
'scont' => __('Place Graph on Report'),
|
|
'pcont' => __('Place Graphs on Report'),
|
|
'extra' => [
|
|
'report_id' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('Report Name'),
|
|
'array' => $reports,
|
|
'default' => array_key_first($reports)
|
|
],
|
|
'timespan' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('Timespan'),
|
|
'array' => $graph_timespans,
|
|
'default' => read_user_setting('default_timespan')
|
|
],
|
|
'align' => [
|
|
'method' => 'drop_array',
|
|
'title' => __('Align'),
|
|
'array' => $alignment,
|
|
'default' => REPORTS_ALIGN_CENTER
|
|
]
|
|
]
|
|
],
|
|
]
|
|
];
|
|
|
|
$trees = db_fetch_assoc('SELECT id, name FROM graph_tree ORDER BY name');
|
|
|
|
if (cacti_sizeof($trees)) {
|
|
foreach ($trees as $tree) {
|
|
$form_data['options']['tr_' . $tree['id']] = [
|
|
'smessage' => __esc('Click \'Continue\' to Place the following Graph on Tree %s.', $tree['name']),
|
|
'pmessage' => __esc('Click \'Continue\' to Duplicate following Graphs on Tree %s.', $tree['name']),
|
|
'scont' => __('Place Graph on Tree'),
|
|
'pcont' => __('Place Graphs on Tree'),
|
|
'extra' => [
|
|
'tree_item_id' => [
|
|
'method' => 'drop_branch',
|
|
'title' => __('Destination Branch'),
|
|
'id' => $tree['id']
|
|
]
|
|
],
|
|
'eaction' => 'tree_id',
|
|
'eactionid' => $tree['id'],
|
|
];
|
|
}
|
|
}
|
|
|
|
$form_data = api_plugin_hook_function('graphs_confirmation_form', $form_data);
|
|
|
|
form_continue_confirmation($form_data, 'graphs_action_prepare', $save);
|
|
}
|
|
}
|
|
|
|
function graph_aggregate_javascript() : void {
|
|
?>
|
|
<script type='text/javascript'>
|
|
function changeTotals() {
|
|
switch ($('#aggregate_total').val()) {
|
|
case '<?php print AGGREGATE_TOTAL_NONE; ?>':
|
|
$('#aggregate_total_type').prop('disabled', true);
|
|
if ($('#aggregate_total_type').selectmenu('instance')) {
|
|
$('#aggregate_total_type').selectmenu('disable');
|
|
}
|
|
|
|
$('#aggregate_total_prefix').prop('disabled', true);
|
|
if ($('#aggregate_total_prefix').selectmenu('instance')) {
|
|
$('#aggregate_total_prefix').selectmenu('disable');
|
|
}
|
|
|
|
$('#aggregate_order_type').prop('disabled', false);
|
|
if ($('#aggregate_order_type').selectmenu('instance')) {
|
|
$('#aggregate_order_type').selectmenu('enable');
|
|
}
|
|
|
|
break;
|
|
case '<?php print AGGREGATE_TOTAL_ALL; ?>':
|
|
$('#aggregate_total_type').prop('disabled', false);
|
|
if ($('#aggregate_total_type').selectmenu('instance')) {
|
|
$('#aggregate_total_type').selectmenu('enable');
|
|
}
|
|
|
|
$('#aggregate_total_prefix').prop('disabled', false);
|
|
if ($('#aggregate_total_prefix').selectmenu('instance')) {
|
|
$('#aggregate_total_prefix').selectmenu('enable');
|
|
}
|
|
|
|
$('#aggregate_order_type').prop('disabled', false);
|
|
if ($('#aggregate_order_type').selectmenu('instance')) {
|
|
$('#aggregate_order_type').selectmenu('enable');
|
|
}
|
|
|
|
changeTotalsType();
|
|
break;
|
|
case '<?php print AGGREGATE_TOTAL_ONLY; ?>':
|
|
$('#aggregate_total_type').prop('disabled', false);
|
|
if ($('#aggregate_total_type').selectmenu('instance')) {
|
|
$('#aggregate_total_type').selectmenu('enable');
|
|
}
|
|
|
|
$('#aggregate_total_prefix').prop('disabled', false);
|
|
if ($('#aggregate_total_prefix').selectmenu('instance')) {
|
|
$('#aggregate_total_prefix').selectmenu('enable');
|
|
}
|
|
|
|
$('#aggregate_order_type').prop('disabled', true);
|
|
if ($('#aggregate_order_type').selectmenu('instance')) {
|
|
$('#aggregate_order_type').selectmenu('disable');
|
|
}
|
|
|
|
changeTotalsType();
|
|
break;
|
|
}
|
|
}
|
|
|
|
function changeTotalsType() {
|
|
if (($('#aggregate_total_type').val() == <?php print AGGREGATE_TOTAL_TYPE_SIMILAR; ?>)) {
|
|
$('#aggregate_total_prefix').attr('value', '<?php print __('Total'); ?>');
|
|
} else if (($('#aggregate_total_type').val() == <?php print AGGREGATE_TOTAL_TYPE_ALL; ?>)) {
|
|
$('#aggregate_total_prefix').attr('value', '<?php print __('All Items'); ?>');
|
|
}
|
|
}
|
|
|
|
function checkSubmit() {
|
|
if ($('input[id^="agg_total"]:checked').length == 0) {
|
|
$('button[type="submit"]').prop('disable', true).addClass('ui-state-disabled');;
|
|
} else {
|
|
$('button[type="submit"]').prop('disable', true).removeClass('ui-state-disabled');;
|
|
}
|
|
}
|
|
|
|
$(function() {
|
|
$('#aggregate_total').change(function() {
|
|
changeTotals();
|
|
});
|
|
|
|
$('#aggregate_total_type').change(function() {
|
|
changeTotalsType();
|
|
});
|
|
|
|
$('input[id^="agg_total"], input[id^="agg_skip"]').click(function() {
|
|
id = $(this).attr('id');
|
|
|
|
if (id.indexOf('skip') > 0) {
|
|
altId = id.replace('skip', 'total');
|
|
} else {
|
|
altId = id.replace('total', 'skip');
|
|
}
|
|
|
|
if ($('#'+id).is(':checked')) {
|
|
$('#'+altId).prop('checked', false);
|
|
} else {
|
|
$('#'+altId).prop('checked', true);
|
|
}
|
|
|
|
checkSubmit();
|
|
});
|
|
|
|
$('input[id^="agg_skip"]').each(function() {
|
|
$(this).prop('checked', true);
|
|
});
|
|
|
|
changeTotals();
|
|
checkSubmit();
|
|
});
|
|
</script>
|
|
<?php
|
|
}
|
|
|
|
function item() : void {
|
|
global $consolidation_functions, $graph_item_types, $struct_graph_item;
|
|
|
|
// ================= input validation =================
|
|
gfrv('id');
|
|
// ====================================================
|
|
|
|
if (ierv('id')) {
|
|
$template_item_list = [];
|
|
|
|
$header_label = __('Graph Items [new]');
|
|
$add_text = '';
|
|
$anchor_link = '';
|
|
} else {
|
|
$template_item_list = db_fetch_assoc_prepared("SELECT
|
|
gti.id, gti.text_format, gti.value, gti.hard_return, gti.graph_type_id, gti.alpha, gti.alpha2, gti.textalign,
|
|
gti.consolidation_function_id, gti.sequence,
|
|
CONCAT(dtd.name_cache, ' (', dtr.data_source_name, ')') AS data_source_name,
|
|
cd.name AS cdef_name, c.hex, c2.hex AS hex2, gti.legend,
|
|
vd.name AS vdef_name, gtgp.name AS gprint_name
|
|
FROM graph_templates_item AS gti
|
|
LEFT JOIN data_template_rrd AS dtr
|
|
ON gti.task_item_id = dtr.id
|
|
LEFT JOIN data_local AS dl
|
|
ON dtr.local_data_id = dl.id
|
|
LEFT JOIN data_template_data AS dtd
|
|
ON dl.id = dtd.local_data_id
|
|
LEFT JOIN graph_templates_gprint AS gtgp
|
|
ON gprint_id = gtgp.id
|
|
LEFT JOIN cdef AS cd
|
|
ON cdef_id = cd.id
|
|
LEFT JOIN vdef AS vd
|
|
ON vdef_id = vd.id
|
|
LEFT JOIN colors AS c
|
|
ON color_id = c.id
|
|
LEFT JOIN colors AS c2
|
|
ON color_id = c2.id
|
|
WHERE gti.local_graph_id = ?
|
|
ORDER BY gti.sequence", [grv('id')]);
|
|
|
|
$template_item_list = api_plugin_hook_function('graphs_item_array', $template_item_list);
|
|
|
|
$host_id = db_fetch_cell_prepared('SELECT host_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[grv('id')]);
|
|
|
|
$graph_template_id = db_fetch_cell_prepared('SELECT graph_template_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[grv('id')]);
|
|
|
|
$header_label = __esc('Graph Items [edit: %s]', get_graph_title(grv('id')));
|
|
$add_text = 'graphs.php?action=item_edit' . (!empty($host_id) ? '&host_id=' . $host_id : '') . '&local_graph_id=' . grv('id');
|
|
$anchor_link = 'host_id=' . $host_id . '&local_graph_id=' . grv('id');
|
|
}
|
|
|
|
html_start_box($header_label, '100%', false, 3, 'center', $add_text);
|
|
|
|
draw_graph_items_list($template_item_list, 'graphs.php', $anchor_link, (empty($graph_template_id) || empty($host_id) ? false : true));
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
$(function() {
|
|
$('.deleteMarker, .moveArrow').unbind().click(function(event) {
|
|
event.preventDefault();
|
|
loadUrl({url:$(this).attr('href')})
|
|
});
|
|
|
|
$('#graphs_graph_edit2_child').attr('id', 'item_ids');
|
|
$('#item_ids').find('tr:first').addClass('nodrag').addClass('nodrop');
|
|
$('#item_ids').tableDnD({
|
|
onDrop: function(table, row) {
|
|
loadUrl({url:'graphs.php?action=ajax_dnd&id=<?php isrv('id') ? print grv('id') : print 0; ?>&'+$.tableDnD.serialize()});
|
|
}
|
|
});
|
|
});
|
|
</script>
|
|
<?php
|
|
|
|
html_end_box();
|
|
}
|
|
|
|
function is_multi_device_graph(int $local_graph_id) : bool {
|
|
$devices = db_fetch_cell_prepared('SELECT COUNT(DISTINCT host_id)
|
|
FROM data_template_rrd AS dtr
|
|
INNER JOIN graph_templates_item AS gti
|
|
ON gti.task_item_id = dtr.id
|
|
INNER JOIN data_local AS dl
|
|
ON dl.id = dtr.local_data_id
|
|
WHERE gti.local_graph_id = ?',
|
|
[$local_graph_id]);
|
|
|
|
return $devices > 1 ? true : false;
|
|
}
|
|
|
|
function graph_edit() : void {
|
|
global $struct_graph, $image_types, $consolidation_functions, $graph_item_types, $struct_graph_item;
|
|
|
|
// ================= input validation =================
|
|
gfrv('id');
|
|
// ====================================================
|
|
|
|
$use_graph_template = true;
|
|
|
|
$locked = 'false';
|
|
$graph = [];
|
|
|
|
if (!ierv('id')) {
|
|
$_SESSION['sess_graph_lock_id'] = grv('id');
|
|
|
|
$local_graph_template_graph_id = db_fetch_cell_prepared('SELECT local_graph_template_graph_id
|
|
FROM graph_templates_graph
|
|
WHERE local_graph_id = ?',
|
|
[grv('id')]);
|
|
|
|
$auto_unlock = read_config_option('graphs_auto_unlock');
|
|
|
|
if (grv('id') != $_SESSION['sess_graph_lock_id'] && !empty($local_graph_template_graph_id)) {
|
|
if ($auto_unlock == 'on') {
|
|
$locked = false;
|
|
} else {
|
|
$locked = true;
|
|
}
|
|
$_SESSION['sess_graph_locked'] = $locked;
|
|
} elseif (empty($local_graph_template_graph_id)) {
|
|
$locked = false;
|
|
|
|
$_SESSION['sess_graph_locked'] = $locked;
|
|
} elseif (isset($_SESSION['sess_graph_locked'])) {
|
|
$locked = $_SESSION['sess_graph_locked'];
|
|
} else {
|
|
if ($auto_unlock == 'on') {
|
|
$locked = false;
|
|
} else {
|
|
$locked = true;
|
|
}
|
|
|
|
$_SESSION['sess_graph_locked'] = $locked;
|
|
}
|
|
|
|
$graph = db_fetch_row_prepared('SELECT *
|
|
FROM graph_templates_graph
|
|
WHERE local_graph_id = ?',
|
|
[grv('id')]);
|
|
|
|
$graph_template = db_fetch_row_prepared('SELECT *
|
|
FROM graph_templates_graph
|
|
WHERE id = ?',
|
|
[$local_graph_template_graph_id]);
|
|
|
|
$host_id = db_fetch_cell_prepared('SELECT host_id
|
|
FROM graph_local
|
|
WHERE id = ?',
|
|
[grv('id')]);
|
|
|
|
// case of a deleted graph
|
|
if (!cacti_sizeof($graph)) {
|
|
raise_message(31);
|
|
header('Location: graphs.php');
|
|
|
|
exit;
|
|
}
|
|
|
|
$header_label = __esc('Graph [edit: %s]', get_graph_title(grv('id')));
|
|
|
|
if ($graph['graph_template_id'] == '0') {
|
|
$use_graph_template = 'false';
|
|
}
|
|
} else {
|
|
$header_label = __('Graph [new]');
|
|
$use_graph_template = false;
|
|
|
|
if (isrv('host_id') && gfrv('host_id') > 0) {
|
|
$host_id = grv('host_id');
|
|
} else {
|
|
$host_id = 0;
|
|
}
|
|
|
|
if (ierv('graph_template_id')) {
|
|
$locked = false;
|
|
}
|
|
}
|
|
|
|
// handle debug mode
|
|
if (isrv('debug')) {
|
|
if (gnrv('debug') == '0') {
|
|
kill_session_var('graph_debug_mode');
|
|
} elseif (gnrv('debug') == '1') {
|
|
$_SESSION['graph_debug_mode'] = true;
|
|
}
|
|
}
|
|
|
|
if (!ierv('id')) {
|
|
if (isset($_SESSION['graph_debug_mode'])) {
|
|
$message = __('Turn Off Graph Debug Mode.');
|
|
$debug = true;
|
|
} else {
|
|
$message = __('Turn On Graph Debug Mode.');
|
|
$debug = false;
|
|
}
|
|
|
|
$data_sources = db_fetch_assoc_prepared('SELECT DISTINCT local_data_id
|
|
FROM graph_templates_item AS gti
|
|
INNER JOIN data_template_rrd AS dtr
|
|
ON dtr.id = gti.task_item_id
|
|
WHERE local_graph_id = ?',
|
|
[grv('id')]);
|
|
} else {
|
|
$debug = false;
|
|
$message = '';
|
|
|
|
$data_sources = [];
|
|
}
|
|
|
|
if (!empty($graph['local_graph_id'])) {
|
|
$graph_template_id = get_current_graph_template($graph['local_graph_id']);
|
|
|
|
$gtsql = get_common_graph_templates($graph);
|
|
} else {
|
|
$graph_template_id = 0;
|
|
|
|
$gtsql = 'SELECT gt.id, gt.name
|
|
FROM graph_templates AS gt
|
|
WHERE id NOT IN (SELECT graph_template_id FROM snmp_query_graph)
|
|
ORDER BY name';
|
|
}
|
|
|
|
$ins_buttons = [];
|
|
|
|
if (cacti_sizeof($data_sources)) {
|
|
foreach ($data_sources as $ds) {
|
|
$name = db_fetch_cell_prepared('SELECT name_cache
|
|
FROM data_template_data
|
|
WHERE local_data_id = ?',
|
|
[$ds['local_data_id']]);
|
|
|
|
$ins_buttons[] = [
|
|
'display' => __esc('Edit Data Source: \'%s\'.', $name),
|
|
'url' => 'data_sources.php?action=ds_edit&id=' . $ds['local_data_id'],
|
|
'class' => 'ti ti-affiliate newDevice'
|
|
];
|
|
}
|
|
}
|
|
|
|
if (!ierv('host_id') || !empty($host_id)) {
|
|
$ins_buttons[] = [
|
|
'display' => __('Edit Device'),
|
|
'url' => 'host.php?action=edit&id=' . ($host_id > 0 ? $host_id : grv('host_id')),
|
|
'class' => 'ti ti-server editDevice'
|
|
];
|
|
}
|
|
|
|
$filters = [
|
|
'rows' => [
|
|
[
|
|
'graph_template_id' => [
|
|
'method' => 'drop_sql',
|
|
'friendly_name' => __('Selected Graph Template'),
|
|
'description' => __('Choose a Graph Template to apply to this Graph. Please note that you may only change Graph Templates to a 100%% compatible Graph Template, which means that it includes identical Data Sources.'),
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => $graph_template_id,
|
|
'none_value' => (!isset($graph['graph_template_id']) || $graph['graph_template_id'] == 0 ? __('None') : ''),
|
|
'sql' => $gtsql
|
|
],
|
|
'host_id' => [
|
|
'method' => 'drop_callback',
|
|
'friendly_name' => __('Device'),
|
|
'description' => __('Choose the Device that this Graph belongs to.'),
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'sql' => 'SELECT id, description as name FROM host ORDER BY name',
|
|
'action' => 'ajax_hosts_noany',
|
|
'none_value' => __('None'),
|
|
'id' => $host_id,
|
|
'value' => db_fetch_cell_prepared('SELECT description FROM host WHERE id = ?', [$host_id]),
|
|
],
|
|
'graph_template_graph_id' => [
|
|
'method' => 'hidden',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => (isset($graph['id']) ? $graph['id'] : '0')
|
|
],
|
|
'local_graph_id' => [
|
|
'method' => 'hidden',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => (isset($graph['local_graph_id']) ? $graph['local_graph_id'] : '0')
|
|
],
|
|
'local_graph_template_graph_id' => [
|
|
'method' => 'hidden',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => (isset($graph['local_graph_template_graph_id']) ? $graph['local_graph_template_graph_id'] : '0')
|
|
],
|
|
'graph_template_id_prev' => [
|
|
'method' => 'hidden',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => $graph_template_id
|
|
],
|
|
'host_id_prev' => [
|
|
'method' => 'hidden',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'value' => (isset($host_id) ? $host_id : '0')
|
|
],
|
|
'id' => [
|
|
'method' => 'validate',
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '',
|
|
]
|
|
]
|
|
],
|
|
'links' => [
|
|
[
|
|
'display' => $message,
|
|
'url' => 'graphs.php?action=graph_edit&id=' . (isrv('id') ? grv('id') : '0') . '&debug=' . (isset($_SESSION['graph_debug_mode']) ? '0' : '1'),
|
|
'class' => ($debug ? 'ti ti-bug disableDebug' : 'ti ti-bug enableDebug')
|
|
],
|
|
[
|
|
'display' => __('Edit Graph Template'),
|
|
'url' => 'graph_templates.php?action=template_edit&id=' . (isset($graph['graph_template_id']) ? $graph['graph_template_id'] : '0'),
|
|
'class' => 'ti ti-edit editTemplate'
|
|
],
|
|
]
|
|
];
|
|
|
|
if (cacti_sizeof($ins_buttons)) {
|
|
foreach ($ins_buttons as $button) {
|
|
$filters['links'][] = $button;
|
|
}
|
|
}
|
|
|
|
$filters['links'][] = [
|
|
'display' => ($locked ? __('Unlock Graph') : __('Lock Graph')),
|
|
'url' => 'graphs.php?action=' . ($locked ? 'unlock' : 'lock') . '&id=' . grv('id'),
|
|
'class' => ($locked ? 'ti ti-lock-off' : 'ti ti-lock')
|
|
];
|
|
|
|
$filters['links'][] = [
|
|
'display' => __('View Timespan Graphs'),
|
|
'url' => 'graphs.php?action=view&rra_id=0&local_graph_id=' . grv('id'),
|
|
'class' => 'ti ti-chart-area-line-filled threeBars'
|
|
];
|
|
|
|
if (cacti_sizeof($graph)) {
|
|
if ($graph['graph_template_id'] == 0) {
|
|
$filters['rows'][0]['graph_template_id']['method'] = 'validate';
|
|
$filters['rows'][0]['graph_template_id']['value'] = '0';
|
|
}
|
|
|
|
if ($graph['graph_template_id'] > 0 && $host_id > 0) {
|
|
$filters['rows'][0]['graph_template_id']['method'] = 'validate';
|
|
$filters['rows'][0]['host_id']['method'] = 'validate';
|
|
}
|
|
|
|
if (is_multi_device_graph($graph['local_graph_id'])) {
|
|
$filters['rows'][0]['host_id']['method'] = 'validate';
|
|
}
|
|
}
|
|
|
|
// process plugin links
|
|
form_start('graphs.php');
|
|
|
|
$pageFilter = new CactiTableFilter($header_label, 'graphs.php?action=edit&id=' . grv('id'), 'graphs', 'sess_graph_edit', '', '', false);
|
|
$pageFilter->set_filter_array($filters);
|
|
$pageFilter->render();
|
|
|
|
// only display the "inputs" area if we are using a graph template for this graph
|
|
if (!empty($graph['graph_template_id'])) {
|
|
html_start_box(__('Supplemental Graph Template Data'), '100%', true, 3, 'center', '');
|
|
|
|
draw_nontemplated_fields_graph($graph['graph_template_id'], $graph, '|field|', __('Graph Fields'), true, true, 0);
|
|
draw_nontemplated_fields_graph_item($graph['graph_template_id'], grv('id'), '|field|_|id|', __('Graph Item Fields'), true, $locked);
|
|
|
|
html_end_box(true, true);
|
|
}
|
|
|
|
// graph item list goes here
|
|
if ((!ierv('id')) && (empty($graph['graph_template_id']))) {
|
|
item();
|
|
}
|
|
|
|
$graph_start = -14400;
|
|
$graph_end = '-' . read_config_option('poller_interval');
|
|
|
|
$graph['src'] = CACTI_PATH_URL . 'graph_json.php?local_graph_id=' . grv('id') . '&rra_id=0&graph_start=' . $graph_start . '&graph_end=' . $graph_end . '&v=' . mt_rand();
|
|
|
|
if (!ierv('id')) {
|
|
?>
|
|
<div class='cactiTable'>
|
|
<div id='graphLocation' class='center'></div>
|
|
<?php
|
|
if ((isset($_SESSION['graph_debug_mode'])) && (isrv('id'))) {
|
|
$graph_data_array['output_flag'] = RRDTOOL_OUTPUT_STDERR;
|
|
$graph_data_array['print_source'] = 1;
|
|
$graph_data_array['graph_end'] = $graph_end;
|
|
$graph_data_array['graph_start'] = $graph_start;
|
|
|
|
$null_param = [];
|
|
?>
|
|
</div>
|
|
<div class='cactiTable'>
|
|
<div style='float:left'>
|
|
<span class='textInfo'><?php print __('RRDtool Command:'); ?></span><br>
|
|
<pre><?php print htmle(rrdtool_function_graph(grv('id'), 1, $graph_data_array, null, $null_param, $_SESSION[SESS_USER_ID])); ?></pre>
|
|
<span class='textInfo'><?php print __('RRDtool Says:'); ?></span><br>
|
|
<?php unset($graph_data_array['print_source']); ?>
|
|
<pre><?php print(POLLER_ID == 1 ? htmle(rrdtool_function_graph(grv('id'), 1, $graph_data_array, null, $null_param, $_SESSION[SESS_USER_ID])) : __esc('Not Checked')); ?></pre>
|
|
</div>
|
|
<?php
|
|
}
|
|
?>
|
|
</div>
|
|
<br>
|
|
<?php
|
|
}
|
|
|
|
if (((isrv('id')) || (isrv('new'))) && (empty($graph['graph_template_id']))) {
|
|
html_start_box(__('Graph Configuration'), '100%', true, 3, 'center', '');
|
|
|
|
$form_array = [];
|
|
|
|
foreach ($struct_graph as $field_name => $field_array) {
|
|
$form_array += [$field_name => $struct_graph[$field_name]];
|
|
|
|
if (($field_array['method'] != 'header') && ($field_array['method'] != 'spacer')) {
|
|
$form_array[$field_name]['value'] = (isset($graph[$field_name]) ? $graph[$field_name] : '');
|
|
$form_array[$field_name]['form_id'] = (isset($graph[$field_name]) ? $graph['id'] : '0');
|
|
|
|
if ($use_graph_template == true && isset($graph_template['t_' . $field_name]) && ($graph_template['t_' . $field_name] == 'on')) {
|
|
$form_array[$field_name]['method'] = 'template_' . $form_array[$field_name]['method'];
|
|
$form_array[$field_name]['description'] = '';
|
|
}
|
|
}
|
|
}
|
|
|
|
draw_edit_form(
|
|
[
|
|
'config' => ['no_form_tag' => true],
|
|
'fields' => $form_array
|
|
]
|
|
);
|
|
|
|
html_end_box(true, true);
|
|
}
|
|
|
|
if ((isrv('id')) || (isrv('new'))) {
|
|
form_hidden_box('save_component_graph','1','');
|
|
form_hidden_box('save_component_input','1','');
|
|
} else {
|
|
form_hidden_box('save_component_graph_new','1','');
|
|
}
|
|
|
|
form_hidden_box('rrdtool_version', get_rrdtool_version(), '');
|
|
|
|
form_save_button('graphs.php', 'return');
|
|
|
|
// Now we need some javascript to make it dynamic
|
|
?>
|
|
<script type='text/javascript'>
|
|
|
|
var locked = <?php print($locked ? 'true' : 'false'); ?>;
|
|
var imageSource = <?php print json_encode($graph['src'], JSON_HEX_TAG | JSON_HEX_AMP | JSON_HEX_APOS | JSON_HEX_QUOT); ?>;
|
|
var originalWidth = null;
|
|
var originalHeight = null;
|
|
|
|
function dynamic() {
|
|
if ($('#scale_log_units').is(':checked')) {
|
|
$('#scale_log_units').prop('disabled', true);
|
|
if ($('#auto_scale_log').is(':checked')) {
|
|
$('#scale_log_units').prop('disabled', false);
|
|
}
|
|
}
|
|
}
|
|
|
|
function changeScaleLog() {
|
|
if ($('#scale_log_units').is(':checked')) {
|
|
$('#scale_log_units').prop('disabled', true);
|
|
if ($('#auto_scale_log').is(':checked')) {
|
|
$('#scale_log_units').prop('disabled', false);
|
|
}
|
|
}
|
|
}
|
|
|
|
$(function() {
|
|
dynamic();
|
|
|
|
$.getJSON(imageSource)
|
|
.done(function(data) {
|
|
$('#graphLocation').html("<img class='cactiGraphImage' src='data:image/"+data.type+";base64,"+data.image+"' graph_start='"+data.graph_start+"' graph_end='"+data.graph_end+"' graph_left='"+data.graph_left+"' graph_top='"+data.graph_top+"' graph_width='"+data.graph_width+"' graph_height='"+data.graph_height+"' width='"+data.image_width+"' height='"+data.image_height+"' image_width='"+data.image_width+"' image_height='"+data.image_height+"' value_min='"+data.value_min+"' value_max='"+data.value_max+"'>");
|
|
$(window).trigger('resize');
|
|
})
|
|
.fail(function(data) {
|
|
getPresentHTTPError(data);
|
|
});
|
|
|
|
$(window).resize(function() {
|
|
var imageWidth = $('.cactiGraphImage').width();
|
|
var imageHeight = $('.cactiGraphImage').height();
|
|
var aspectRatio = imageWidth/imageHeight;
|
|
|
|
if (imageWidth > 0 && originalWidth == null) {
|
|
originalWidth = imageWidth;
|
|
originalHeight = imageHeight;
|
|
}
|
|
|
|
$('.cactiGraphImage').hide();
|
|
|
|
var mainSize = $('#main').width();
|
|
|
|
if (imageWidth > mainSize || mainSize < originalWidth) {
|
|
var newWidth = mainSize - 40;
|
|
|
|
aspectRatio = imageWidth / imageHeight;
|
|
imageWidth = newWidth;
|
|
imageHeight = newWidth / aspectRatio;
|
|
$('.cactiGraphImage').css({ width: imageWidth, height: imageHeight });
|
|
} else if (mainSize > originalWidth) {
|
|
$('.cactiGraphImage').css({ width: originalWidth, height: originalHeight });
|
|
}
|
|
|
|
$('.cactiGraphImage').show();
|
|
}).trigger('resize');
|
|
|
|
$('.ui-selectmenu-button').css('width', '360px');
|
|
$('.ui-autocomplete-input').css('width', '340px');
|
|
});
|
|
|
|
if (locked) {
|
|
$('input').not('input[value="cancel"]').not('input[value="return"]').prop('disabled', true);
|
|
$('.moveArrow, .deleteMarker, .linkOverDark, .linkEditMain').attr('href', '#').removeClass('moveArrow').removeClass('deleteMarker');
|
|
if ($('#submit').button('instance')) {
|
|
$('#submit').button('disable');
|
|
} else {
|
|
$('#submit').prop('disabled', true);
|
|
}
|
|
$('#host_id_wrap').addClass('ui-selectmenu-disabled ui-state-disabled');
|
|
$('#host_id_input').addClass('ui-state-disabled');
|
|
}
|
|
</script>
|
|
<?php
|
|
if (isrv('id')) {
|
|
api_plugin_hook_function('graph_edit_after', grv('id'));
|
|
} else {
|
|
api_plugin_hook_function('graph_edit_after');
|
|
}
|
|
}
|
|
|
|
function validate_graph_request_vars() : void {
|
|
// ================= input validation and session storage =================
|
|
$filters = [
|
|
'custom' => [
|
|
'filter' => FILTER_VALIDATE_REGEXP,
|
|
'options' => ['options' => ['regexp' => '(true|false)']],
|
|
'pageset' => true,
|
|
'default' => ''
|
|
],
|
|
'local_graph_ids' => [
|
|
'filter' => FILTER_VALIDATE_IS_NUMERIC_LIST,
|
|
'pageset' => true,
|
|
'default' => ''
|
|
]
|
|
];
|
|
|
|
validate_store_request_vars($filters, 'sess_graph_custom');
|
|
// ================= input validation =================
|
|
}
|
|
|
|
function graphs() : void {
|
|
global $actions, $graph_sources, $item_rows, $image_types;
|
|
|
|
// for custom non-stored request vars
|
|
validate_graph_request_vars();
|
|
|
|
// for main filter variables
|
|
process_sanifize_draw_graphs_filter(true);
|
|
|
|
if (grv('rows') == -1) {
|
|
$rows = read_config_option('num_rows_table');
|
|
} else {
|
|
$rows = grv('rows');
|
|
}
|
|
|
|
// form the 'where' clause for our main sql query
|
|
$sql_where = '';
|
|
$sql_where2 = '';
|
|
$sql_params = [];
|
|
$sql_params2 = [];
|
|
|
|
if (grv('rfilter') != '') {
|
|
$sql_where = ' WHERE
|
|
(
|
|
gtg.title_cache RLIKE ? OR
|
|
gt.name RLIKE ? OR
|
|
gl.id = ?
|
|
)';
|
|
|
|
$sql_params[] = grv('rfilter');
|
|
$sql_params[] = grv('rfilter');
|
|
$sql_params[] = grv('rfilter');
|
|
|
|
$sql_where2 = ' AND (gl.id = ?)';
|
|
$sql_params2[] = grv('rfilter');
|
|
}
|
|
|
|
if (ierv('host_id')) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' IFNULL(gl.host_id, 0) = 0';
|
|
$sql_where2 .= ' AND gl.host_id = 0';
|
|
} elseif (grv('host_id') > 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.host_id = ?';
|
|
$sql_params[] = grv('host_id');
|
|
$sql_where2 .= ' AND gl.host_id = ?';
|
|
$sql_params2[] = grv('host_id');
|
|
}
|
|
|
|
if (grv('vdef_id') > 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gti.vdef_id = ?';
|
|
$sql_params[] = grv('vdef_id');
|
|
$sql_where2 .= ' AND gti.vdef_id = ?';
|
|
$sql_params2[] = grv('vdef_id');
|
|
}
|
|
|
|
if (grv('cdef_id') > 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gti.cdef_id = ?';
|
|
$sql_params[] = grv('cdef_id');
|
|
$sql_where2 .= ' AND gti.cdef_id = ?';
|
|
$sql_params2[] = grv('cdef_id');
|
|
}
|
|
|
|
if (ierv('site_id')) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' IFNULL(h.site_id, 0) = 0';
|
|
$sql_where2 .= ' AND h.site_id = 0';
|
|
} elseif (grv('site_id') > 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' h.site_id = ?';
|
|
$sql_params[] = grv('site_id');
|
|
$sql_where2 .= ' AND h.site_id = ?';
|
|
$sql_params2[] = grv('site_id');
|
|
}
|
|
|
|
if (grv('template_id') == '0') {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' IFNULL(gtg.graph_template_id, 0) = 0';
|
|
$sql_where2 .= ' AND gtg.graph_template_id = 0';
|
|
} elseif (!ierv('template_id') && grv('template_id') != '-1') {
|
|
$parts = explode('_', grv('template_id'));
|
|
|
|
input_validate_input_number($parts[1], 'template_id[1]');
|
|
|
|
if ($parts[0] == 'cg') {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.graph_template_id = ?';
|
|
$sql_params[] = $parts[1];
|
|
$sql_where2 .= ' AND gl.graph_template_id = ?';
|
|
$sql_params2[] = $parts[1];
|
|
} else {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.snmp_query_graph_id = ?';
|
|
$sql_params[] = $parts[1];
|
|
$sql_where2 .= ' AND gl.snmp_query_graph_id = ?';
|
|
$sql_params2[] = $parts[1];
|
|
}
|
|
}
|
|
|
|
if (grv('local_graph_ids') != '') {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.id IN(' . grv('local_graph_ids') . ')';
|
|
$sql_where2 .= ' AND gl.id IN(' . grv('local_graph_ids') . ')';
|
|
}
|
|
|
|
if (grv('source') >= 0) {
|
|
if (grv('source') == 0) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.graph_template_id = 0';
|
|
} elseif (grv('source') == 1) {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' (gl.graph_template_id > 0 AND gl.snmp_query_id = 0)';
|
|
} else {
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' gl.snmp_query_id > 0';
|
|
}
|
|
}
|
|
|
|
if (grv('orphans') == 'true') {
|
|
$orphan_join = "INNER JOIN (
|
|
SELECT DISTINCT gti.local_graph_id, dtr.local_data_id
|
|
FROM graph_templates_item AS gti
|
|
INNER JOIN graph_local AS gl
|
|
ON gl.id = gti.local_graph_id
|
|
LEFT JOIN data_template_rrd AS dtr
|
|
ON dtr.id = gti.task_item_id
|
|
INNER JOIN data_local AS dl
|
|
ON dl.id = dtr.local_data_id
|
|
LEFT JOIN host AS h
|
|
ON h.id = gl.host_id
|
|
WHERE graph_type_id IN (4,5,6,7,8,20)
|
|
AND cdef_id NOT IN (
|
|
SELECT c.id
|
|
FROM cdef AS c
|
|
INNER JOIN cdef_items AS ci
|
|
ON c.id = ci.cdef_id
|
|
WHERE (ci.type = 4 OR (ci.type = 6 AND value LIKE '%DATA_SOURCE%'))
|
|
)
|
|
AND (dl.orphan = 1 OR dtr.id IS NULL OR (gl.snmp_query_id > 0 AND gl.snmp_index = ''))
|
|
$sql_where2
|
|
) AS dtr
|
|
ON gl.id = dtr.local_graph_id";
|
|
} else {
|
|
$orphan_join = '';
|
|
$sql_params2 = [];
|
|
}
|
|
|
|
// don't allow aggregates to be view here
|
|
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' ag.local_graph_id IS NULL';
|
|
|
|
// allow plugins to modify sql_where
|
|
$sql_where = api_plugin_hook_function('graphs_sql_where', $sql_where);
|
|
|
|
$rows_sql = "SELECT
|
|
COUNT(DISTINCT gtg.id)
|
|
FROM graph_local AS gl
|
|
INNER JOIN graph_templates_graph AS gtg
|
|
ON gl.id = gtg.local_graph_id
|
|
LEFT JOIN graph_templates_item AS gti
|
|
ON gl.graph_template_id = gti.id
|
|
LEFT JOIN graph_templates AS gt
|
|
ON gl.graph_template_id = gt.id
|
|
LEFT JOIN aggregate_graphs AS ag
|
|
ON ag.local_graph_id = gl.id
|
|
LEFT JOIN host AS h
|
|
ON h.id=gl.host_id
|
|
LEFT JOIN sites AS s
|
|
ON h.site_id=s.id
|
|
$orphan_join
|
|
$sql_where";
|
|
|
|
if (cacti_sizeof($sql_params2)) {
|
|
$merged_params = array_merge($sql_params2, $sql_params);
|
|
} else {
|
|
$merged_params = $sql_params;
|
|
}
|
|
|
|
$total_rows = get_total_row_data($_SESSION[SESS_USER_ID], $rows_sql, $merged_params, 'graph');
|
|
|
|
$sql_order = get_order_string();
|
|
$sql_limit = ' LIMIT ' . ($rows * (grv('page') - 1)) . ',' . $rows;
|
|
|
|
$sql = "SELECT gtg.id, gl.id AS local_graph_id,
|
|
gtg.height, gtg.width, gtg.title_cache, gtg.image_format_id, gt.name, gl.host_id,
|
|
IF(gl.graph_template_id = 0, 0, IF(gl.snmp_query_id = 0, 2, 1)) AS graph_source
|
|
FROM graph_local AS gl
|
|
INNER JOIN graph_templates_graph AS gtg
|
|
ON gl.id = gtg.local_graph_id
|
|
LEFT JOIN graph_templates_item AS gti
|
|
ON gl.graph_template_id = gti.id
|
|
LEFT JOIN graph_templates AS gt
|
|
ON gl.graph_template_id = gt.id
|
|
LEFT JOIN aggregate_graphs AS ag
|
|
ON ag.local_graph_id = gl.id
|
|
LEFT JOIN host AS h
|
|
ON h.id = gl.host_id
|
|
LEFT JOIN sites AS s
|
|
ON h.site_id = s.id
|
|
LEFT JOIN snmp_query_graph AS sqg
|
|
ON gl.snmp_query_id = sqg.snmp_query_id
|
|
AND gl.graph_template_id = sqg.graph_template_id
|
|
AND gl.snmp_query_graph_id = sqg.id
|
|
$orphan_join
|
|
$sql_where
|
|
$sql_order
|
|
$sql_limit";
|
|
|
|
$graph_list = db_fetch_assoc_prepared($sql, $merged_params);
|
|
|
|
$nav = html_nav_bar('graphs.php', MAX_DISPLAY_PAGES, (int) grv('page'), $rows, $total_rows, 5, __('Graphs'), 'page', 'main');
|
|
|
|
form_start('graphs.php', 'chk');
|
|
|
|
print $nav;
|
|
|
|
html_start_box('', '100%', false, 3, 'center', '');
|
|
|
|
$display_text = [
|
|
'title_cache' => [
|
|
'display' => __('Graph Name'),
|
|
'align' => 'left',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The Title of this Graph. Generally programmatically generated from the Graph Template definition or Suggested Naming rules. The max length of the Title is controlled under Settings->Visual.')
|
|
],
|
|
'local_graph_id' => [
|
|
'display' => __('ID'),
|
|
'align' => 'right',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The internal database ID for this Graph. Useful when performing automation or debugging.')
|
|
],
|
|
'graph_source' => [
|
|
'display' => __('Source Type'),
|
|
'align' => 'center',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The underlying source that this Graph was based upon.')
|
|
],
|
|
'source_name' => [
|
|
'display' => __('Source Name'),
|
|
'align' => 'left',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The Graph Template or Data Query that this Graph was based upon.')
|
|
],
|
|
'image_format_id' => [
|
|
'display' => __('Image Format'),
|
|
'align' => 'right',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The image format of the Graph.')
|
|
],
|
|
'height' => [
|
|
'display' => __('Size'),
|
|
'align' => 'right',
|
|
'sort' => 'ASC',
|
|
'tip' => __('The size of this Graph when not in Preview mode.')
|
|
]
|
|
];
|
|
|
|
html_header_sort_checkbox($display_text, grv('sort_column'), grv('sort_direction'), false);
|
|
|
|
$i = 0;
|
|
|
|
if (cacti_sizeof($graph_list)) {
|
|
foreach ($graph_list as $graph) {
|
|
$template_details = get_graph_template_details($graph['local_graph_id']);
|
|
|
|
if ($graph['graph_source'] == '0') { // Not Templated, customize graph source and template details.
|
|
$template_details = api_plugin_hook_function('customize_template_details', $template_details);
|
|
$graph = api_plugin_hook_function('customize_graph', $graph);
|
|
}
|
|
|
|
if (isset($template_details['graph_name'])) {
|
|
$graph['name'] = $template_details['graph_name'];
|
|
}
|
|
|
|
if (isset($template_details['graph_description'])) {
|
|
$graph['description'] = $template_details['graph_description'];
|
|
}
|
|
|
|
if (empty($graph['title_cache'])) {
|
|
$graph['title_cache'] = __('Empty Graph');
|
|
}
|
|
|
|
form_alternate_row('line' . $graph['local_graph_id'], true);
|
|
|
|
form_selectable_cell(filter_value(title_trim($graph['title_cache'], read_config_option('max_title_length')), grv('rfilter'), 'graphs.php?action=graph_edit&id=' . $graph['local_graph_id']), $graph['local_graph_id']);
|
|
form_selectable_cell($graph['local_graph_id'], $graph['local_graph_id'], '', 'right');
|
|
form_selectable_cell(filter_value($graph_sources[$graph['graph_source']], grv('rfilter')), $graph['local_graph_id'], '', 'center');
|
|
form_selectable_cell(filter_value($template_details['name'], grv('rfilter'), $template_details['url']), $graph['local_graph_id'], '', 'left');
|
|
form_selectable_ecell($image_types[$graph['image_format_id']], $graph['local_graph_id'], '', 'right');
|
|
form_selectable_ecell($graph['height'] . 'x' . $graph['width'], $graph['local_graph_id'], '', 'right');
|
|
|
|
form_checkbox_cell($graph['title_cache'], $graph['local_graph_id']);
|
|
|
|
form_end_row();
|
|
}
|
|
} else {
|
|
print "<tr class='tableRow odd'><td colspan='" . (cacti_sizeof($display_text) + 1) . "'><em>" . __('No Graphs Found') . '</em></td></tr>';
|
|
}
|
|
|
|
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();
|
|
}
|
|
}
|