__('Delete'),
2 => __('Duplicate')
];
// set default action
set_default_action();
switch (grv('action')) {
case 'save':
form_save();
break;
case 'actions':
form_actions();
break;
case 'item_remove_confirm':
cdef_item_remove_confirm();
break;
case 'item_remove':
cdef_item_remove();
header('Location: cdef.php?action=edit&id=' . grv('cdef_id'));
break;
case 'item_movedown':
gfrv('cdef_id');
item_movedown();
header('Location: cdef.php?action=edit&id=' . grv('cdef_id'));
break;
case 'item_moveup':
gfrv('cdef_id');
item_moveup();
header('Location: cdef.php?action=edit&id=' . grv('cdef_id'));
break;
case 'item_edit':
top_header();
item_edit();
bottom_footer();
break;
case 'edit':
top_header();
cdef_edit();
bottom_footer();
break;
case 'ajax_dnd':
cdef_item_dnd();
break;
default:
top_header();
cdef();
bottom_footer();
break;
}
function draw_cdef_preview(int $cdef_id) : void {
?>
cdef=
', $cdef['name'], $cdef_title);
// create new entry: host_template
$save['id'] = 0;
$save['hash'] = get_hash_cdef(0);
foreach ($fields_cdef_edit as $field => $array) {
if (!preg_match('/^hidden/', $array['method'])) {
$save[$field] = $cdef[$field];
}
}
$cdef_id = sql_save($save, 'cdef');
// create new entry(s): cdef_items
if (cacti_sizeof($cdef_items) > 0) {
foreach ($cdef_items as $cdef_item) {
unset($save);
$save['id'] = 0;
$save['hash'] = get_hash_cdef(0, 'cdef_item');
$save['cdef_id'] = $cdef_id;
$save['sequence'] = $cdef_item['sequence'];
$save['type'] = $cdef_item['type'];
$save['value'] = $cdef_item['value'];
sql_save($save, 'cdef_items');
}
}
}
function form_actions() : void {
global $actions;
// ================= 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 (gnrv('drp_action') == '1') { // delete
$selected_items = array_values(array_map('intval', $selected_items));
$in_use = false;
foreach ($selected_items as $cdef_id) {
if (cdef_is_in_use($cdef_id, $selected_items)) {
$in_use = true;
break;
}
}
if ($in_use) {
raise_message('cdef_in_use', __('One or more CDEFs are in use and cannot be deleted.'), MESSAGE_LEVEL_ERROR);
} else {
$placeholders = implode(', ', array_fill(0, cacti_count($selected_items), '?'));
db_execute_prepared('DELETE FROM cdef WHERE id IN (' . $placeholders . ')', $selected_items);
db_execute_prepared('DELETE FROM cdef_items WHERE cdef_id IN (' . $placeholders . ')', $selected_items);
}
} elseif (gnrv('drp_action') == '2') { // duplicate
for ($i = 0; ($i < cacti_count($selected_items)); $i++) {
duplicate_cdef($selected_items[$i], gnrv('title_format'));
}
}
}
header('Location: cdef.php');
exit;
} else {
$ilist = '';
$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]');
// ====================================================
$ilist .= '
' . htmle(db_fetch_cell_prepared('SELECT name FROM cdef WHERE id = ?', [$matches[1]])) . '
';
$iarray[] = $matches[1];
}
}
$form_data = [
'general' => [
'page' => 'cdef.php',
'actions' => $actions,
'optvar' => 'drp_action',
'item_array' => $iarray,
'item_list' => $ilist
],
'options' => [
1 => [
'smessage' => __('Click \'Continue\' to Delete the following CDEF.'),
'pmessage' => __('Click \'Continue\' to Delete following CDEFs.'),
'scont' => __('Delete CDEF'),
'pcont' => __('Delete CDEFs')
],
2 => [
'smessage' => __('Click \'Continue\' to Duplicate the following CDEF.'),
'pmessage' => __('Click \'Continue\' to Duplicate following CDEFs.'),
'scont' => __('Duplicate CDEF'),
'pcont' => __('Duplicate CDEFs'),
'extra' => [
'title_format' => [
'method' => 'textbox',
'title' => __('Title Format'),
'default' => '',
'width' => 25
]
]
]
]
];
form_continue_confirmation($form_data);
}
}
function cdef_item_remove_confirm() : void {
global $cdef_functions, $cdef_item_types, $custom_cdef_data_source_types;
// ================= input validation =================
gfrv('id');
gfrv('cdef_id');
// ====================================================
// sort the cdef functions
asort($cdef_functions);
form_start('cdef.php');
html_start_box('', '100%', false, 3, 'center', '');
$cdef = db_fetch_row_prepared('SELECT * FROM cdef WHERE id = ?', [grv('id')]);
$cdef_item = db_fetch_row_prepared('SELECT * FROM cdef_items WHERE id = ?', [grv('cdef_id')]);
?>
:
'>
'>
[
'method' => 'drop_array',
'friendly_name' => __('CDEF Item Type'),
'description' => __('Choose what type of CDEF item this is.'),
'value' => $current_type,
'array' => $cdef_item_types
],
'value' => [
'method' => 'drop_array',
'friendly_name' => __('CDEF Item Value'),
'description' => __('Enter a value for this CDEF item.'),
'value' => (isset($cdef['value']) ? $cdef['value'] : '')
],
'id' => [
'method' => 'hidden',
'value' => isrv('id') ? grv('id') : '0',
],
'type' => [
'method' => 'hidden',
'value' => $current_type
],
'cdef_id' => [
'method' => 'hidden',
'value' => grv('cdef_id')
],
'save_component_item' => [
'method' => 'hidden',
'value' => '1'
]
];
switch ($current_type) {
case '1':
$form_cdef['value']['array'] = $cdef_functions;
break;
case '2':
$form_cdef['value']['array'] = $cdef_operators;
break;
case '4':
$form_cdef['value']['array'] = $custom_data_source_types;
break;
case '5':
$form_cdef['value']['method'] = 'drop_sql';
$form_cdef['value']['sql'] = 'SELECT name, id FROM cdef WHERE `system` = 0 ORDER BY name';
break;
case '6':
$form_cdef['value']['method'] = 'textbox';
$form_cdef['value']['max_length'] = '255';
$form_cdef['value']['size'] = '30';
break;
}
draw_edit_form(
[
'config' => ['no_form_tag' => true],
'fields' => inject_form_variables($form_cdef, $cdef)
]
);
?>
['no_form_tag' => true],
'fields' => inject_form_variables($fields_cdef_edit, $cdef)
]
);
html_end_box(true, true);
if (!ierv('id') && cacti_sizeof($cdef)) {
html_start_box('', '100%', false, 3, 'center', '');
draw_cdef_preview(grv('id'));
html_end_box();
html_start_box(__('CDEF Items'), '100%', false, 3, 'center', 'cdef.php?action=item_edit&cdef_id=' . $cdef['id'], false, false);
$display_text = [
['display' => __('Item'), 'align' => 'left'],
['display' => __('Item Value'), 'align' => 'left']
];
html_header($display_text, 2);
$cdef_items = db_fetch_assoc_prepared('SELECT *
FROM cdef_items
WHERE cdef_id = ?
ORDER BY sequence',
[grv('id')]);
$i = 1;
$total_items = cacti_sizeof($cdef_items);
if (cacti_sizeof($cdef_items)) {
foreach ($cdef_items as $cdef_item) {
form_alternate_row('line' . $cdef_item['id'], true);
form_selectable_cell(filter_value(__('Item # %d', $i), '', 'cdef.php?action=item_edit&id=' . $cdef_item['id'] . '&cdef_id=' . $cdef['id']), $cdef_item['id']);
$item_value = '' . htmle($cdef_item_types[$cdef_item['type']] ?? __('Unknown')) . '' . htmle(get_cdef_item_name($cdef_item['id']) ?? __('Invalid'));
form_selectable_cell($item_value, $cdef_item['id']);
$actions = '';
if (read_config_option('drag_and_drop') == '') {
if ($i < $total_items) {
$actions .= '';
} else {
$actions .= '';
}
if ($i > 1 && $i <= $total_items) {
$actions .= '';
} else {
$actions .= '';
}
}
$actions .= "";
form_selectable_cell($actions, $cdef_item['id'], '', 'right');
form_end_row();
$i++;
}
}
html_end_box();
}
form_save_button('cdef.php', 'return');
?>
rows_label = __('CDEFs');
$pageFilter->has_graphs = true;
$pageFilter->render();
if (grv('rows') == '-1') {
$rows = read_config_option('num_rows_table');
} else {
$rows = grv('rows');
}
// form the 'where' clause for our main sql query
if (grv('filter') != '') {
$sql_where = 'WHERE (name LIKE ' . db_qstr('%' . grv('filter') . '%') . ' AND `system` = 0)';
} else {
$sql_where = 'WHERE `system` = 0';
}
if (grv('has_graphs') == 'true') {
$sql_where .= ($sql_where != '' ? ' AND ' : 'WHERE ') . ' graphs > 0';
}
$total_rows = db_fetch_cell("SELECT COUNT(*)
FROM cdef
$sql_where");
$sql_order = get_order_string();
$sql_limit = ' LIMIT ' . ($rows * (grv('page') - 1)) . ',' . $rows;
$cdef_list = db_fetch_assoc("SELECT *
FROM cdef
$sql_where
$sql_order
$sql_limit");
$nav = html_nav_bar('cdef.php?filter=' . grv('filter'), MAX_DISPLAY_PAGES, grv('page'), $rows, $total_rows, 5, __('CDEFs'), 'page', 'main');
form_start('cdef.php', 'chk');
print $nav;
html_start_box('', '100%', false, 3, 'center', '');
$display_text = [
'name' => [
'display' => __('CDEF Name'),
'align' => 'left',
'sort' => 'ASC',
'tip' => __('The name of this CDEF.')
],
'nosort' => [
'display' => __('Deletable'),
'align' => 'right',
'tip' => __('CDEFs that are in use cannot be Deleted. In use is defined as being referenced by a Graph or a Graph Template.')
],
'graphs' => [
'display' => __('Graphs Using'),
'align' => 'right',
'sort' => 'DESC',
'tip' => __('The number of Graphs using this CDEF.')
],
'templates' => [
'display' => __('Templates Using'),
'align' => 'right',
'sort' => 'DESC',
'tip' => __('The number of Graphs Templates using this CDEF.')
]
];
html_header_sort_checkbox($display_text, grv('sort_column'), grv('sort_direction'), false);
if (cacti_sizeof($cdef_list)) {
foreach ($cdef_list as $cdef) {
if ($cdef['graphs'] == 0 && $cdef['templates'] == 0) {
$disabled = false;
} else {
$disabled = true;
}
$graphs_url = 'graphs.php?reset=1&cdef_id=' . $cdef['id'];
$templates_url = 'graph_templates.php?reset=1&cdef_id=' . $cdef['id'];
form_alternate_row('line' . $cdef['id'], false, $disabled);
form_selectable_cell(filter_value($cdef['name'], grv('filter'), 'cdef.php?action=edit&id=' . $cdef['id']), $cdef['id']);
form_selectable_cell($disabled ? __('No') : __('Yes'), $cdef['id'], '', 'right');
form_selectable_cell(filter_value(number_format_i18n($cdef['graphs'], -1), '', $graphs_url), $cdef['id'], '', 'right');
form_selectable_cell(filter_value(number_format_i18n($cdef['templates'], -1), '', $templates_url), $cdef['id'], '', 'right');
form_checkbox_cell($cdef['name'], $cdef['id'], $disabled);
form_end_row();
}
} else {
print "
" . __('No CDEFs') . '
';
}
html_end_box(false);
if (cacti_sizeof($cdef_list)) {
print $nav;
}
// draw the dropdown containing a list of available actions for this form
draw_actions_dropdown($actions);
form_end();
}