mirror of
https://github.com/Cacti/cacti.git
synced 2026-10-28 15:47:39 +09:00
767 lines
25 KiB
PHP
767 lines
25 KiB
PHP
<?php
|
|
/*
|
|
+-------------------------------------------------------------------------+
|
|
| Copyright (C) 2004-2023 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/ |
|
|
+-------------------------------------------------------------------------+
|
|
*/
|
|
|
|
include_once('./include/auth.php');
|
|
include_once('./lib/api_aggregate.php');
|
|
include_once('./lib/data_query.php');
|
|
|
|
$aggregate_actions = array(
|
|
1 => __('Delete')
|
|
);
|
|
|
|
/* set default action */
|
|
set_default_action();
|
|
|
|
if (get_request_var('action') == 'save') {
|
|
if (isset_request_var('id') && get_filter_request_var('id') == 0 && isset_request_var('graph_template_id_prev') && get_filter_request_var('graph_template_id_prev') == 0) {
|
|
set_request_var('action', 'edit');
|
|
}
|
|
}
|
|
|
|
switch (get_request_var('action')) {
|
|
case 'save':
|
|
aggregate_form_save();
|
|
break;
|
|
case 'actions':
|
|
aggregate_form_actions();
|
|
break;
|
|
case 'edit':
|
|
top_header();
|
|
aggregate_template_edit();
|
|
bottom_footer();
|
|
break;
|
|
default:
|
|
top_header();
|
|
aggregate_template();
|
|
bottom_footer();
|
|
break;
|
|
}
|
|
|
|
/* --------------------------
|
|
The Save Function
|
|
-------------------------- */
|
|
/**
|
|
* aggregate_form_save the save function
|
|
*/
|
|
function aggregate_form_save() {
|
|
/* make sure we are saving aggregate template */
|
|
if (!isset_request_var('save_component_template')) {
|
|
header('Location: aggregate_templates.php?header=false&action=edit&id=' . get_nfilter_request_var('id'));
|
|
return null;
|
|
}
|
|
|
|
$save1 = array();
|
|
|
|
/* updating existing template or creating a new one? */
|
|
if (isset_request_var('id') && get_request_var('id') > 0) {
|
|
$is_new = false;
|
|
$save1['id'] = get_nfilter_request_var('id');
|
|
} else {
|
|
$is_new = true;
|
|
$save1['id'] = 0;
|
|
}
|
|
|
|
/* set some defaults for possibly disabled values */
|
|
if (!isset_request_var('total')) set_request_var('total', 0);
|
|
if (!isset_request_var('total_type')) set_request_var('total_type', 0);
|
|
if (!isset_request_var('order_type')) set_request_var('order_type', 0);
|
|
if (!isset_request_var('total_prefix')) set_request_var('total_prefix', '');
|
|
|
|
/* populate aggregate template save array and validate posted values*/
|
|
$save1['name'] = form_input_validate(get_nfilter_request_var('name'), 'name', '', false, 3);
|
|
$save1['graph_template_id'] = get_filter_request_var('graph_template_id_prev');
|
|
$save1['gprint_prefix'] = form_input_validate(get_nfilter_request_var('gprint_prefix'), 'gprint_prefix', '', true, 3);
|
|
$save1['gprint_format'] = isset_request_var('gprint_format') ? 'on':'';
|
|
$save1['graph_type'] = form_input_validate(get_nfilter_request_var('graph_type'), 'graph_type', '', false, 3);
|
|
$save1['total'] = form_input_validate(get_nfilter_request_var('total'), 'total', '', false, 3);
|
|
$save1['total_type'] = form_input_validate(get_nfilter_request_var('total_type'), 'total_type', '', false, 3);
|
|
$save1['total_prefix'] = form_input_validate(get_nfilter_request_var('total_prefix'), 'total_prefix', '', true, 3);
|
|
$save1['order_type'] = form_input_validate(get_nfilter_request_var('order_type'), 'order_type', '', false, 3);
|
|
$save1['user_id'] = $_SESSION['sess_user_id'];
|
|
|
|
/* form validation failed */
|
|
if (is_error_message()) {
|
|
header('Location: aggregate_templates.php?header=false&action=edit&id=' . get_nfilter_request_var('id'));
|
|
return null;
|
|
}
|
|
|
|
cacti_log('AGGREGATE GRAPH TEMPLATE Saved ID: ' . $save1['id'] . ' Name: ' . $save1['name'], false, 'AGGREGATE', POLLER_VERBOSITY_DEBUG);
|
|
|
|
/* do a quick comparison to see if anything changed */
|
|
if ($is_new == false) {
|
|
$old = db_fetch_row_prepared('SELECT *
|
|
FROM aggregate_graph_templates
|
|
WHERE id = ?',
|
|
array($save1['id']));
|
|
|
|
$save_me = 0;
|
|
|
|
$save_me += ($old['name'] != $save1['name']);
|
|
$save_me += ($old['gprint_prefix'] != $save1['gprint_prefix']);
|
|
$save_me += ($old['gprint_format'] != $save1['gprint_format']);
|
|
$save_me += ($old['graph_type'] != $save1['graph_type']);
|
|
$save_me += ($old['total'] != $save1['total']);
|
|
$save_me += ($old['total_type'] != $save1['total_type']);
|
|
$save_me += ($old['total_prefix'] != $save1['total_prefix']);
|
|
$save_me += ($old['order_type'] != $save1['order_type']);
|
|
} else {
|
|
$save_me = 1;
|
|
}
|
|
|
|
if ($save_me) {
|
|
$id = sql_save($save1, 'aggregate_graph_templates', 'id');
|
|
|
|
/* update children of the template */
|
|
db_execute_prepared("UPDATE aggregate_graphs
|
|
SET gprint_prefix = ?, gprint_format = ?, graph_type = ?, total = ?, total_prefix = ?, order_type = ?
|
|
WHERE aggregate_template_id = ?
|
|
AND template_propogation='on'",
|
|
array($save1['gprint_prefix'], $save1['gprint_format'], $save1['graph_type'],
|
|
$save1['total'], $save1['total_prefix'], $save1['order_type'], $id));
|
|
|
|
cacti_log('AGGREGATE GRAPH TEMPLATE Saved ID: ' . $id, false, 'AGGREGATE', POLLER_VERBOSITY_DEBUG);
|
|
} else {
|
|
$id = $save1['id'];
|
|
}
|
|
|
|
if (!$id) {
|
|
raise_message(2);
|
|
header('Location: aggregate_templates.php?header=false&action=edit&id=' . get_nfilter_request_var('id'));
|
|
return null;
|
|
}
|
|
|
|
/* save extra graph parameters */
|
|
/* validate posted graph params */
|
|
$params_new = aggregate_validate_graph_params($_POST, true);
|
|
$params_new['aggregate_template_id'] = $id;
|
|
|
|
/* compare new graph param values with existing in DB.
|
|
* We need to know if there were changes so we only
|
|
* rebuild existing graphs if needed. */
|
|
$params_changed = false;
|
|
|
|
$params_old = db_fetch_row_prepared('SELECT *
|
|
FROM aggregate_graph_templates_graph
|
|
WHERE aggregate_template_id = ?',
|
|
array($id));
|
|
|
|
if (!empty($params_old)) {
|
|
foreach ($params_old as $field => $value_old) {
|
|
if (isset($params_new[$field]) && $params_new[$field] != $value_old) {
|
|
$params_changed = true;
|
|
break;
|
|
}
|
|
}
|
|
} else {
|
|
$params_changed = true;
|
|
}
|
|
|
|
|
|
/* save only if all posted form fields passed validation */
|
|
if ($params_changed && !is_error_message()) {
|
|
sql_save($params_new, 'aggregate_graph_templates_graph', 'aggregate_template_id', false);
|
|
}
|
|
|
|
/* save the template items now */
|
|
/* 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 = ?',
|
|
array($save1['graph_template_id'])),
|
|
'id', array('sequence')
|
|
);
|
|
|
|
/* get existing aggregate template items */
|
|
$aggregate_template_items_old = array_rekey(
|
|
db_fetch_assoc_prepared('SELECT *
|
|
FROM aggregate_graph_templates_item
|
|
WHERE aggregate_template_id = ?', array($id)),
|
|
'graph_templates_item_id', array('sequence', 'color_template', 't_graph_type_id', 'graph_type_id', 't_cdef_id', 'cdef_id', 'item_skip', 'item_total')
|
|
);
|
|
|
|
/* update graph template item values with posted values */
|
|
aggregate_validate_graph_items($_POST, $graph_templates_items);
|
|
|
|
$items_changed = false;
|
|
$items_to_save = array();
|
|
|
|
foreach($graph_templates_items as $item_id => $data) {
|
|
$item_new = array();
|
|
$item_new['aggregate_template_id'] = $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;
|
|
|
|
/* compare with old item to see if we need to push out. */
|
|
if (!isset($aggregate_template_items_old[$item_id])) {
|
|
/* this item does not yet exist */
|
|
$items_changed = true;
|
|
} else {
|
|
// fill in missing fields with db values
|
|
$item_new = array_merge($aggregate_template_items_old[$item_id], $item_new);
|
|
/* compare data from user to data from DB */
|
|
foreach ($data as $field => $new_value) {
|
|
if ($aggregate_template_items_old[$item_id][$field] != $new_value)
|
|
$items_changed = true;
|
|
}
|
|
}
|
|
$items_to_save[] = $item_new;
|
|
}
|
|
|
|
if ($items_changed) {
|
|
aggregate_graph_items_save($items_to_save, 'aggregate_graph_templates_item');
|
|
}
|
|
|
|
if ($save_me || $params_changed || $items_changed) {
|
|
push_out_aggregates($id);
|
|
}
|
|
|
|
raise_message(1);
|
|
|
|
header('Location: aggregate_templates.php?header=false&action=edit&id=' . (empty($id) ? get_nfilter_request_var('id') : $id));
|
|
}
|
|
|
|
|
|
function aggregate_get_graph_items($table, $id) {
|
|
|
|
}
|
|
|
|
/* ------------------------
|
|
The 'actions' function
|
|
------------------------ */
|
|
/**
|
|
* aggregate_form_actions the action function
|
|
*/
|
|
function aggregate_form_actions() {
|
|
global $aggregate_actions, $config;
|
|
|
|
/* ================= input validation ================= */
|
|
get_filter_request_var('drp_action');
|
|
/* ==================================================== */
|
|
|
|
/* if we are to save this form, instead of display it */
|
|
if (isset_request_var('selected_items')) {
|
|
$selected_items = sanitize_unserialize_selected_items(get_nfilter_request_var('selected_items'));
|
|
|
|
if ($selected_items != false) {
|
|
if (get_nfilter_request_var('drp_action') == '1') { /* delete */
|
|
db_execute('DELETE FROM aggregate_graph_templates WHERE ' . array_to_sql_or($selected_items, 'id'));
|
|
db_execute('DELETE FROM aggregate_graph_templates_item WHERE ' . array_to_sql_or($selected_items, 'aggregate_template_id'));
|
|
db_execute('DELETE FROM aggregate_graph_templates_graph WHERE ' . array_to_sql_or($selected_items, 'aggregate_template_id'));
|
|
db_execute("UPDATE aggregate_graphs SET aggregate_template_id=0, template_propogation='' WHERE " . array_to_sql_or($selected_items, 'aggregate_template_id'));
|
|
}
|
|
} else {
|
|
}
|
|
|
|
header('Location: aggregate_templates.php?header=false');
|
|
exit;
|
|
}
|
|
|
|
/* setup some variables */
|
|
$aggregate_list = ''; $i = 0;
|
|
|
|
/* loop through each of the color templates 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]);
|
|
/* ==================================================== */
|
|
$aggregate_list .= '<li>' . html_escape(db_fetch_cell_prepared('SELECT name FROM aggregate_graph_templates WHERE id = ?', array($matches[1]))) . '</li>';
|
|
$aggregate_array[] = $matches[1];
|
|
}
|
|
}
|
|
|
|
top_header();
|
|
|
|
form_start('aggregate_templates.php');
|
|
|
|
html_start_box($aggregate_actions[get_nfilter_request_var('drp_action')], '60%', '', '3', 'center', '');
|
|
|
|
if (isset($aggregate_array) && cacti_sizeof($aggregate_array)) {
|
|
if (get_nfilter_request_var('drp_action') == '1') { /* delete */
|
|
print "<tr>
|
|
<td class='textArea'>
|
|
<p>" . __('Click \'Continue\' to Delete the following Aggregate Graph Template(s).') . "</p>
|
|
<div class='itemlist'><ul>$aggregate_list</ul></div>
|
|
</td>
|
|
</tr>\n";
|
|
|
|
$save_html = "<input type='button' class='ui-button ui-corner-all ui-widget' value='" . __esc('Cancel') . "' onClick='cactiReturnTo()'> <input type='submit' class='ui-button ui-corner-all ui-widget' value='" . __esc('Continue') . "' title='" . __esc('Delete Color Template(s)') . "'>";
|
|
}
|
|
} else {
|
|
raise_message(40);
|
|
header('Location: aggregate_templates.php?header=false');
|
|
exit;
|
|
}
|
|
|
|
print "<tr>
|
|
<td class='saveRow'>
|
|
<input type='hidden' name='action' value='actions'>
|
|
<input type='hidden' name='selected_items' value='" . (isset($aggregate_array) ? serialize($aggregate_array) : '') . "'>
|
|
<input type='hidden' name='drp_action' value='" . html_escape(get_nfilter_request_var('drp_action')) . "'>
|
|
$save_html
|
|
</td>
|
|
</tr>\n";
|
|
|
|
html_end_box();
|
|
|
|
form_end();
|
|
|
|
bottom_footer();
|
|
}
|
|
|
|
/**
|
|
* aggregate_template_edit edit the color template
|
|
*/
|
|
function aggregate_template_edit() {
|
|
global $image_types, $struct_aggregate_template;
|
|
|
|
/* ================= input validation ================= */
|
|
get_filter_request_var('id');
|
|
/* ==================================================== */
|
|
|
|
if (!isempty_request_var('id')) {
|
|
$template = db_fetch_row_prepared('SELECT *
|
|
FROM aggregate_graph_templates
|
|
WHERE id = ?',
|
|
array(get_request_var('id')));
|
|
|
|
$header_label = __esc('Aggregate Template [edit: %s]', $template['name']);
|
|
} else {
|
|
$header_label = __('Aggregate Template [new]');
|
|
}
|
|
|
|
/* populate the graph template id if it's set */
|
|
if (isset_request_var('graph_template_id') && !isset($template)) {
|
|
/* ================= input validation ================= */
|
|
get_filter_request_var('graph_template_id');
|
|
/* ==================================================== */
|
|
$template['graph_template_id'] = get_nfilter_request_var('graph_template_id');
|
|
$template['id'] = 0;
|
|
}
|
|
|
|
form_start('aggregate_templates.php', 'template_edit');
|
|
|
|
html_start_box($header_label, '100%', true, '3', 'center', '');
|
|
|
|
$helper_string = '|host_description|';
|
|
|
|
if (isset($template)) {
|
|
$data_query = db_fetch_cell_prepared('SELECT snmp_query_id
|
|
FROM snmp_query_graph
|
|
WHERE graph_template_id = ?',
|
|
array($template['graph_template_id']));
|
|
|
|
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_template['suggestions'] = array(
|
|
'method' => 'other',
|
|
'friendly_name' => __('Prefix Replacement Values'),
|
|
'description' => __('You may use these replacement values for the Prefix in the Aggregate Graph'),
|
|
'value' => $helper_string
|
|
);
|
|
|
|
draw_edit_form(
|
|
array(
|
|
'config' => array('no_form_tag' => true),
|
|
'fields' => inject_form_variables($struct_aggregate_template, (isset($template) ? $template : array()))
|
|
)
|
|
);
|
|
|
|
html_end_box(true, true);
|
|
|
|
if (isset($template)) {
|
|
draw_aggregate_graph_items_list(0, $template['graph_template_id'], $template);
|
|
|
|
/* Draw Graph Configuration form, so user can override some parameters from graph template */
|
|
draw_aggregate_template_graph_config($template['id'], $template['graph_template_id']);
|
|
}
|
|
|
|
form_hidden_box('id', (isset($template['id']) ? $template['id'] : '0'), '0');
|
|
form_hidden_box('save_component_template', '1', '');
|
|
form_save_button('aggregate_templates.php', 'return', 'id');
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
|
|
$(function() {
|
|
if ($('#id').val() == 0) {
|
|
$('[id^="agg_total_"]').prop('checked', true);
|
|
}
|
|
|
|
if ($('#graph_template_id').val() == 0) {
|
|
$('#row_name').hide();
|
|
$('#row_spacer1').hide();
|
|
$('#row_gprint_prefix').hide();
|
|
$('#row_gprint_format').hide();
|
|
$('#row_graph_type').hide();
|
|
$('#row_total').hide();
|
|
$('#row_total_type').hide();
|
|
$('#row_total_prefix').hide();
|
|
$('#row_order_type').hide();
|
|
|
|
$('#graph_template_id').change(function() {
|
|
$('#template_edit').submit();
|
|
});
|
|
|
|
$('#save_component_template').parent().next('table').css('display', 'none');
|
|
} else {
|
|
$('#graph_template_id').prop('disabled', true);
|
|
if ($('#graph_template_id').selectmenu('instance') !== undefined) {
|
|
$('#graph_template_id').selectmenu('disable');
|
|
}
|
|
}
|
|
|
|
$('#total').change(function() {
|
|
changeTotals();
|
|
});
|
|
|
|
$('#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);
|
|
}
|
|
|
|
updateSaveButton();
|
|
});
|
|
|
|
changeTotals();
|
|
|
|
updateSaveButton();
|
|
});
|
|
|
|
function updateSaveButton() {
|
|
if ($('input[id^="agg_total"]').is(':checked')) {
|
|
$('#submit').prop('disabled', false);
|
|
|
|
if ($('#submit').button('instance')) {
|
|
$('#submit').button('enable');
|
|
}
|
|
} else {
|
|
$('#submit').prop('disabled', true);
|
|
|
|
if ($('#submit').button('instance')) {
|
|
$('#submit').button('disable');
|
|
}
|
|
}
|
|
}
|
|
|
|
function changeTotals() {
|
|
switch ($('#total').val()) {
|
|
case '<?php print AGGREGATE_TOTAL_NONE;?>':
|
|
$('#row_total_type').hide();
|
|
$('#row_total_prefix').hide();
|
|
$('#row_order_type').show();
|
|
break;
|
|
case '<?php print AGGREGATE_TOTAL_ALL;?>':
|
|
$('#row_total_type').show();
|
|
$('#row_total_prefix').show();
|
|
$('#row_order_type').show();
|
|
changeTotalsType();
|
|
break;
|
|
case '<?php print AGGREGATE_TOTAL_ONLY;?>':
|
|
$('#row_total_type').show();
|
|
$('#row_total_prefix').show();
|
|
//$('#order_type').prop('disabled', true);
|
|
changeTotalsType();
|
|
break;
|
|
}
|
|
}
|
|
|
|
function changeTotalsType() {
|
|
if ($('#total_type').val() == <?php print AGGREGATE_TOTAL_TYPE_SIMILAR;?>) {
|
|
if ($('#total_prefix').val() == '') {
|
|
$('#total_prefix').attr('value', '<?php print __('Total');?>');
|
|
}
|
|
} else if ($('#total_type').val() == <?php print AGGREGATE_TOTAL_TYPE_ALL;?>) {
|
|
if ($('#total_prefix').val() == '') {
|
|
$('#total_prefix').attr('value', '<?php print __('All Items');?>');
|
|
}
|
|
}
|
|
}
|
|
</script>
|
|
<?php
|
|
}
|
|
|
|
/**
|
|
* aggregate_template
|
|
*/
|
|
function aggregate_template() {
|
|
global $aggregate_actions, $item_rows, $config;
|
|
|
|
/* ================= input validation and session storage ================= */
|
|
$filters = array(
|
|
'rows' => array(
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'pageset' => true,
|
|
'default' => '-1'
|
|
),
|
|
'page' => array(
|
|
'filter' => FILTER_VALIDATE_INT,
|
|
'default' => '1'
|
|
),
|
|
'filter' => array(
|
|
'filter' => FILTER_DEFAULT,
|
|
'pageset' => true,
|
|
'default' => ''
|
|
),
|
|
'sort_column' => array(
|
|
'filter' => FILTER_CALLBACK,
|
|
'default' => 'pgt.name',
|
|
'options' => array('options' => 'sanitize_search_string')
|
|
),
|
|
'sort_direction' => array(
|
|
'filter' => FILTER_CALLBACK,
|
|
'default' => 'ASC',
|
|
'options' => array('options' => 'sanitize_search_string')
|
|
),
|
|
'has_graphs' => array(
|
|
'filter' => FILTER_VALIDATE_REGEXP,
|
|
'options' => array('options' => array('regexp' => '(true|false)')),
|
|
'pageset' => true,
|
|
'default' => read_config_option('default_has') == 'on' ? 'true':'false'
|
|
)
|
|
);
|
|
|
|
validate_store_request_vars($filters, 'sess_agg_tmp');
|
|
/* ================= input validation ================= */
|
|
|
|
if (get_request_var('rows') == '-1') {
|
|
$rows = read_config_option('num_rows_table');
|
|
} else {
|
|
$rows = get_request_var('rows');
|
|
}
|
|
|
|
html_start_box(__('Aggregate Templates'), '100%', '', '3', 'center', 'aggregate_templates.php?action=edit');
|
|
|
|
$filter_html = '<tr class="even">
|
|
<td>
|
|
<form id="forms">
|
|
<table class="filterTable">
|
|
<tr>
|
|
<td>
|
|
' . __('Search') . '
|
|
</td>
|
|
<td>
|
|
<input type="text" class="ui-state-default ui-corner-all" id="filter" size="25" value="' . html_escape_request_var('filter') . '">
|
|
</td>
|
|
<td>
|
|
' . __('Templates') . '
|
|
</td>
|
|
<td>
|
|
<select id="rows" onChange="applyFilter()">
|
|
<option value="-1" ';
|
|
|
|
if (get_request_var("rows") == "-1") {
|
|
$filter_html .= 'selected';
|
|
}
|
|
|
|
$filter_html .= '>' . __('Default') . '</option>';
|
|
if (cacti_sizeof($item_rows)) {
|
|
foreach ($item_rows as $key => $value) {
|
|
$filter_html .= "<option value='" . $key . "'";
|
|
if (get_request_var("rows") == $key) {
|
|
$filter_html .= " selected";
|
|
}
|
|
$filter_html .= ">" . $value . "</option>\n";
|
|
}
|
|
}
|
|
|
|
$filter_html .= '</select>
|
|
</td>
|
|
<td>
|
|
<span>
|
|
<input type="checkbox" id="has_graphs" ' . (get_request_var('has_graphs') == 'true' ? 'checked':'') . ' onChange="applyFilter()">
|
|
<label for="has_graphs">' . __('Has Graphs') . '</label>
|
|
</span>
|
|
</td>
|
|
<td>
|
|
<span>
|
|
<input type="submit" class="ui-button ui-corner-all ui-widget" value="' . __esc('Go') . '" id="go">
|
|
<input type="button" class="ui-button ui-corner-all ui-widget" value="' . __esc('Clear') . '" id="clear">
|
|
</span>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
</td>
|
|
</tr>';
|
|
|
|
print $filter_html;
|
|
|
|
html_end_box();
|
|
|
|
/* form the 'where' clause for our main sql query */
|
|
$sql_where = '';
|
|
if (get_request_var('filter') != '') {
|
|
$sql_where = 'WHERE (pgt.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ' OR gt.name LIKE ' . db_qstr('%' . get_request_var('filter') . '%') . ')';
|
|
}
|
|
|
|
if (get_request_var('has_graphs') == 'true') {
|
|
$sql_where .= ($sql_where != '' ? ' AND ':'WHERE ') . 'graphs.graphs>0';
|
|
}
|
|
|
|
$total_rows = db_fetch_cell("SELECT
|
|
COUNT(pgt.id)
|
|
FROM aggregate_graph_templates AS pgt
|
|
LEFT JOIN (
|
|
SELECT aggregate_template_id, COUNT(*) AS graphs
|
|
FROM aggregate_graphs
|
|
GROUP BY aggregate_template_id
|
|
) AS graphs
|
|
ON pgt.id=graphs.aggregate_template_id
|
|
LEFT JOIN graph_templates AS gt
|
|
ON gt.id=pgt.graph_template_id
|
|
$sql_where");
|
|
|
|
$sql_order = get_order_string();
|
|
$sql_limit = ' LIMIT ' . ($rows*(get_request_var('page')-1)) . ',' . $rows;
|
|
|
|
$template_list = db_fetch_assoc("SELECT pgt.*, graphs.graphs, gt.name AS graph_template_name
|
|
FROM aggregate_graph_templates AS pgt
|
|
LEFT JOIN (
|
|
SELECT aggregate_template_id, COUNT(*) AS graphs
|
|
FROM aggregate_graphs
|
|
GROUP BY aggregate_template_id
|
|
) AS graphs
|
|
ON pgt.id=graphs.aggregate_template_id
|
|
LEFT JOIN graph_templates AS gt
|
|
ON gt.id=pgt.graph_template_id
|
|
$sql_where
|
|
$sql_order
|
|
$sql_limit");
|
|
|
|
$nav = html_nav_bar('aggregate_templates.php', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 5, __('Aggregate Templates'), 'page', 'main');
|
|
|
|
form_start('aggregate_templates.php', 'chk');
|
|
|
|
print $nav;
|
|
|
|
html_start_box('', '100%', '', '3', 'center', '');
|
|
|
|
$display_text = array(
|
|
'pgt.name' => array('display' => __('Template Title'), 'align' => 'left', 'sort' => 'ASC'),
|
|
'nosort' => array('display' => __('Deletable'), 'align' => 'right', 'tip' => __('Aggregate Templates that are in use can not be Deleted. In use is defined as being referenced by an Aggregate.')),
|
|
'graphs.graphs' => array('display' => __('Graphs Using'), 'align' => 'right', 'sort' => 'DESC'),
|
|
'graph_template_name' => array('display' => __('Graph Template'), 'align' => 'left', 'sort' => 'ASC')
|
|
);
|
|
|
|
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false);
|
|
|
|
if (cacti_sizeof($template_list)) {
|
|
foreach ($template_list as $template) {
|
|
if ($template['graphs'] > 0) {
|
|
$disabled = true;
|
|
} else {
|
|
$disabled = false;
|
|
}
|
|
|
|
form_alternate_row('line' . $template['id'], true, $disabled);
|
|
form_selectable_cell(filter_value($template['name'], get_request_var('filter'), 'aggregate_templates.php?action=edit&id=' . $template['id'] . '&page=1'), $template['id']);
|
|
form_selectable_cell($disabled ? __('No'):__('Yes'), $template['id'], '', 'right');
|
|
form_selectable_cell('<a class="linkEditMain" href="' . html_escape('aggregate_graphs.php?reset=true&template_id=' . $template['id']) . '">' . number_format_i18n($template['graphs'], '-1') . '</a>', $template['id'], '', 'right');
|
|
form_selectable_cell(filter_value($template['graph_template_name'], get_request_var('filter')), $template['id']);
|
|
form_checkbox_cell($template['graph_template_name'], $template['id'], $disabled);
|
|
form_end_row();
|
|
}
|
|
} else {
|
|
print "<tr class='tableRow'><td colspan='" . (cacti_sizeof($display_text)+1) . "'><em>" . __('No Aggregate Templates Found') . "</em></td></tr>\n";
|
|
}
|
|
|
|
html_end_box(false);
|
|
|
|
if (cacti_sizeof($template_list)) {
|
|
/* put the nav bar on the bottom as well */
|
|
print $nav;
|
|
}
|
|
|
|
/* draw the dropdown containing a list of available actions for this form */
|
|
draw_actions_dropdown($aggregate_actions);
|
|
|
|
form_end();
|
|
|
|
?>
|
|
<script type='text/javascript'>
|
|
|
|
function applyFilter() {
|
|
strURL = 'aggregate_templates.php';
|
|
strURL += '?rows=' + $('#rows').val();
|
|
strURL += '&has_graphs=' + $('#has_graphs').is(':checked');
|
|
strURL += '&filter=' + $('#filter').val();
|
|
strURL += '&header=false';
|
|
loadPageNoHeader(strURL);
|
|
}
|
|
|
|
function clearFilter() {
|
|
strURL = 'aggregate_templates.php?clear=1&header=false';
|
|
loadPageNoHeader(strURL);
|
|
}
|
|
|
|
$(function() {
|
|
$('#clear').click(function() {
|
|
clearFilter();
|
|
});
|
|
|
|
$('#template').submit(function(event) {
|
|
event.preventDefault();
|
|
applyFilter();
|
|
});
|
|
|
|
$('#forms').submit(function(event) {
|
|
event.preventDefault();
|
|
applyFilter();
|
|
});
|
|
});
|
|
</script>
|
|
<?php
|
|
}
|
|
|