function duplicate_graph($_local_graph_id, $_graph_template_id, $graph_title) {
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
if (!empty($_local_graph_id)) {
$graph_local = db_fetch_row("select * from graph_local where id=$_local_graph_id");
$graph_template_graph = db_fetch_row("select * from graph_templates_graph where local_graph_id=$_local_graph_id");
$graph_template_items = db_fetch_assoc("select * from graph_templates_item where local_graph_id=$_local_graph_id");
/* create new entry: graph_local */
$save["id"] = 0;
$save["graph_template_id"] = $graph_local["graph_template_id"];
$save["device_id"] = $graph_local["device_id"];
$save["snmp_query_id"] = $graph_local["snmp_query_id"];
$save["snmp_index"] = $graph_local["snmp_index"];
$local_graph_id = sql_save($save, "graph_local");
$graph_template_graph["title"] = str_replace(__("<graph_title>"), $graph_template_graph["title"], $graph_title);
}elseif (!empty($_graph_template_id)) {
$graph_template = db_fetch_row("select * from graph_templates where id=$_graph_template_id");
$graph_template_graph = db_fetch_row("select * from graph_templates_graph where graph_template_id=$_graph_template_id and local_graph_id=0");
$graph_template_items = db_fetch_assoc("select * from graph_templates_item where graph_template_id=$_graph_template_id and local_graph_id=0");
$graph_template_inputs = db_fetch_assoc("select * from graph_template_input where graph_template_id=$_graph_template_id");
/* create new entry: graph_templates */
$save["id"] = 0;
$save["hash"] = get_hash_graph_template(0);
$save["name"] = str_replace(__("<template_title>"), $graph_template["name"], $graph_title);
$graph_template_id = sql_save($save, "graph_templates");
}
unset($save);
$struct_graph = graph_form_list();
reset($struct_graph);
/* create new entry: graph_templates_graph */
$save["id"] = 0;
$save["local_graph_id"] = (isset($local_graph_id) ? $local_graph_id : 0);
$save["local_graph_template_graph_id"] = (isset($graph_template_graph["local_graph_template_graph_id"]) ? $graph_template_graph["local_graph_template_graph_id"] : 0);
$save["graph_template_id"] = (!empty($_local_graph_id) ? $graph_template_graph["graph_template_id"] : $graph_template_id);
$save["title_cache"] = $graph_template_graph["title_cache"];
reset($struct_graph);
while (list($field, $array) = each($struct_graph)) {
$save{$field} = $graph_template_graph{$field};
$save{"t_" . $field} = $graph_template_graph{"t_" . $field};
}
$graph_templates_graph_id = sql_save($save, "graph_templates_graph");
/* create new entry(s): graph_templates_item */
if (sizeof($graph_template_items) > 0) {
$struct_graph_item = graph_item_form_list();
foreach ($graph_template_items as $graph_template_item) {
unset($save);
reset($struct_graph_item);
$save["id"] = 0;
/* save a hash only for graph_template copy operations */
$save["hash"] = (!empty($_graph_template_id) ? get_hash_graph_template(0, "graph_template_item") : 0);
$save["local_graph_id"] = (isset($local_graph_id) ? $local_graph_id : 0);
$save["graph_template_id"] = (!empty($_local_graph_id) ? $graph_template_item["graph_template_id"] : $graph_template_id);
$save["local_graph_template_item_id"] = (isset($graph_template_item["local_graph_template_item_id"]) ? $graph_template_item["local_graph_template_item_id"] : 0);
while (list($field, $array) = each($struct_graph_item)) {
$save{$field} = $graph_template_item{$field};
}
$graph_item_mappings{$graph_template_item["id"]} = sql_save($save, "graph_templates_item");
}
}
if (!empty($_graph_template_id)) {
/* create new entry(s): graph_template_input (graph template only) */
if (sizeof($graph_template_inputs) > 0) {
foreach ($graph_template_inputs as $graph_template_input) {
unset($save);
$save["id"] = 0;
$save["graph_template_id"] = $graph_template_id;
$save["name"] = $graph_template_input["name"];
$save["description"] = $graph_template_input["description"];
$save["column_name"] = $graph_template_input["column_name"];
$save["hash"] = get_hash_graph_template(0, "graph_template_input");
$graph_template_input_id = sql_save($save, "graph_template_input");
$graph_template_input_defs = db_fetch_assoc("select * from graph_template_input_defs where graph_template_input_id=" . $graph_template_input["id"]);
/* create new entry(s): graph_template_input_defs (graph template only) */
if (sizeof($graph_template_input_defs) > 0) {
foreach ($graph_template_input_defs as $graph_template_input_def) {
db_execute("insert into graph_template_input_defs (graph_template_input_id,graph_template_item_id)
values ($graph_template_input_id," . $graph_item_mappings{$graph_template_input_def["graph_template_item_id"]} . ")");
}
}
}
}
}
if (!empty($_local_graph_id)) {
update_graph_title_cache($local_graph_id);
}
}
/** change_graph_template - changes the graph template for a particular graph to
$graph_template_id
@param int $local_graph_id - the id of the graph to change the graph template for
@param int $graph_template_id - id the of the graph template to change to. specify '0' for no graph template
@param bool $intrusive - if the target graph template has more or less graph items than
the current graph, remove or add the items from the current graph to make them equal.
(false) leave the graph item count alone */
function change_graph_template($local_graph_id, $graph_template_id, $intrusive) {
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
/* always update tables to new graph template (or no graph template) */
db_execute("update graph_local set graph_template_id=$graph_template_id where id=$local_graph_id");
/* get information about both the graph and the graph template we're using */
$graph_list = db_fetch_row("select * from graph_templates_graph where local_graph_id=$local_graph_id");
$template_graph_list = (($graph_template_id == "0") ? $graph_list : db_fetch_row("select * from graph_templates_graph where local_graph_id=0 and graph_template_id=$graph_template_id"));
/* determine if we are here for the first time, or coming back */
if ((db_fetch_cell("select local_graph_template_graph_id from graph_templates_graph where local_graph_id=$local_graph_id") == "0") ||
(db_fetch_cell("select local_graph_template_graph_id from graph_templates_graph where local_graph_id=$local_graph_id") == "")) {
$new_save = true;
}else{
$new_save = false;
}
/* some basic field values that ALL graphs should have */
$save["id"] = $graph_list["id"];
$save["local_graph_template_graph_id"] = $template_graph_list["id"];
$save["local_graph_id"] = $local_graph_id;
$save["graph_template_id"] = $graph_template_id;
/* loop through the "templated field names" to find to the rest... */
$struct_graph = graph_form_list();
reset($struct_graph);
while (list($field_name, $field_array) = each($struct_graph)) {
$value_type = "t_$field_name";
if ((!empty($template_graph_list[$value_type])) && ($new_save == false)) {
$save[$field_name] = $graph_list[$field_name];
}else{
$save[$field_name] = $template_graph_list[$field_name];
}
}
sql_save($save, "graph_templates_graph");
$graph_items_list = db_fetch_assoc("select * from graph_templates_item where local_graph_id=$local_graph_id order by sequence");
$template_items_list = (($graph_template_id == "0") ? $graph_items_list : db_fetch_assoc("select * from graph_templates_item where local_graph_id=0 and graph_template_id=$graph_template_id order by sequence"));
$graph_template_inputs = db_fetch_assoc("select
graph_template_input.column_name,
graph_template_input_defs.graph_template_item_id
from (graph_template_input,graph_template_input_defs)
where graph_template_input.id=graph_template_input_defs.graph_template_input_id
and graph_template_input.graph_template_id=$graph_template_id");
$k=0;
if (sizeof($template_items_list) > 0) {
$struct_graph_item = graph_item_form_list();
foreach ($template_items_list as $template_item) {
unset($save);
reset($struct_graph_item);
$save["local_graph_template_item_id"] = $template_item["id"];
$save["local_graph_id"] = $local_graph_id;
$save["graph_template_id"] = $template_item["graph_template_id"];
if (isset($graph_items_list[$k])) {
/* graph item at this position, "mesh" it in */
$save["id"] = $graph_items_list[$k]["id"];
/* make a first pass filling in ALL values from template */
while (list($field_name, $field_array) = each($struct_graph_item)) {
$save[$field_name] = $template_item[$field_name];
}
/* go back a second time and fill in the INPUT values from the graph */
for ($j=0; ($j < count($graph_template_inputs)); $j++) {
if ($graph_template_inputs[$j]["graph_template_item_id"] == $template_items_list[$k]["id"]) {
/* if we find out that there is an "input" covering this field/item, use the
value from the graph, not the template */
$graph_item_field_name = $graph_template_inputs[$j]["column_name"];
$save[$graph_item_field_name] = $graph_items_list[$k][$graph_item_field_name];
}
}
}else{
/* no graph item at this position, tack it on */
$save["id"] = 0;
$save["task_item_id"] = 0;
if ($intrusive == true) {
while (list($field_name, $field_array) = each($struct_graph_item)) {
$save[$field_name] = $template_item[$field_name];
}
}else{
unset($save);
}
}
if (isset($save)) {
sql_save($save, "graph_templates_item");
}
$k++;
}
}
/* if there are more graph items then there are items in the template, delete the difference */
if ((sizeof($graph_items_list) > sizeof($template_items_list)) && ($intrusive == true)) {
for ($i=(sizeof($graph_items_list) - (sizeof($graph_items_list) - sizeof($template_items_list))); ($i < count($graph_items_list)); $i++) {
db_execute("delete from graph_templates_item where id=" . $graph_items_list[$i]["id"]);
}
}
return true;
}
/** draw_nontemplated_fields_graph_item - draws a form that consists of all non-templated graph item fields
associated with a particular graph template
@param int $graph_template_id - the id of the graph template to base the form after
@param int $local_graph_id - specify the id of the associated graph if it exists
@param string $field_name_format - all fields on the form will be named using the following format, the following
variables can be used:
|field| - the current field name
|id| - the current graph input id
@param string $header_title - the title to use on the header for this form
@param bool $alternate_colors - whether to alternate colors for each row on the form or not */
function draw_nontemplated_fields_graph_item($graph_template_id, $local_graph_id, $field_name_format = "|field|_|id|", $header_title = "", $alternate_colors = true) {
global $colors;
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
$form_array = array();
$draw_any_items = false;
/* fetch information about the graph template */
$input_item_list = db_fetch_assoc("SELECT *
FROM graph_template_input
WHERE graph_template_id=$graph_template_id
ORDER BY column_name,name");
/* modifications to the default graph items array */
$struct_graph_item = graph_item_form_list();
if (!empty($local_graph_id)) {
$device_id = db_fetch_cell("SELECT device_id FROM graph_local WHERE id=$local_graph_id");
$struct_graph_item["task_item_id"]["sql"] = "SELECT
CONCAT_WS('',
CASE
WHEN device.description IS NULL THEN 'No Host - '
WHEN device.description IS NOT NULL THEN ''
end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') AS name,
data_template_rrd.id
FROM (data_template_data,data_template_rrd,data_local)
LEFT JOIN device ON (data_local.device_id=device.id)
WHERE data_template_rrd.local_data_id=data_local.id
AND data_template_data.local_data_id=data_local.id
" . (empty($device_id) ? "" : " AND data_local.device_id=$device_id") . "
ORDER BY name";
}
if (sizeof($input_item_list) > 0) {
foreach ($input_item_list as $item) {
if (!empty($local_graph_id)) {
$current_def_value = db_fetch_row("SELECT
graph_templates_item." . $item["column_name"] . ",
graph_templates_item.id
FROM (graph_templates_item,graph_template_input_defs)
WHERE graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id
AND graph_template_input_defs.graph_template_input_id=" . $item["id"] . "
AND graph_templates_item.local_graph_id=$local_graph_id
LIMIT 0,1");
}else{
$current_def_value = db_fetch_row("SELECT
graph_templates_item." . $item["column_name"] . ",
graph_templates_item.id
FROM (graph_templates_item,graph_template_input_defs)
WHERE graph_template_input_defs.graph_template_item_id=graph_templates_item.id
AND graph_template_input_defs.graph_template_input_id=" . $item["id"] . "
AND graph_templates_item.graph_template_id=" . $graph_template_id . "
LIMIT 0,1");
}
/* find our field name */
$form_field_name = str_replace("|field|", $item["column_name"], $field_name_format);
$form_field_name = str_replace("|id|", $item["id"], $form_field_name);
$form_array += array($form_field_name => $struct_graph_item{$item["column_name"]});
/* change drop_sql's to callbacks */
if ($form_array[$form_field_name]["method"] == "drop_sql") {
$form_array[$form_field_name]["method"] = "drop_sqlcb";
$form_array[$form_field_name]["text_value"] = $current_def_value[$item["column_name"]];
$form_array[$form_field_name]["sql_id"] = "data_template_rrd.id";
}
/* modifications to the default form array */
$form_array[$form_field_name]["friendly_name"] = $item["name"];
$form_array[$form_field_name]["value"] = $current_def_value{$item["column_name"]};
/* if we are drawing the graph input list in the pre-graph stage we should omit the data
source fields because they are basically meaningless at this point */
if ((empty($local_graph_id)) && ($item["column_name"] == "task_item_id")) {
unset($form_array[$form_field_name]);
}else{
if (($draw_any_items == false) && ($header_title != "")) {
$header_items = array($header_title, "");
print "<tr><td>";
html_header($header_items, 1, true, 'template_graph_item');
}
$draw_any_items = true;
}
}
}
/* setup form options */
if ($alternate_colors == true) {
$form_config_array = array("no_form_tag" => true);
}else{
$form_config_array = array("no_form_tag" => true, "force_row_color" => $colors["form_alternate1"]);
}
if (sizeof($input_item_list > 0)) {
draw_edit_form(
array(
"config" => $form_config_array,
"fields" => $form_array
)
);
}
if ($draw_any_items) print "</table></td></tr>"; /* end of html_header */
return (isset($form_array) ? sizeof($form_array) : 0);
}
function graph_template_to_xml($graph_template_id) {
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
require_once(CACTI_BASE_PATH . "/lib/graph_template/graph_template_info.php");
$hash["graph_template"] = get_hash_version("graph_template") . get_hash_graph_template($graph_template_id);
$xml_text = "";
$graph_template = db_fetch_row("select id,name,description,image from graph_templates where id=$graph_template_id");
$graph_template_graph = db_fetch_row("select * from graph_templates_graph where graph_template_id=$graph_template_id and local_graph_id=0");
$graph_template_items = db_fetch_assoc("select * from graph_templates_item where graph_template_id=$graph_template_id and local_graph_id=0 order by sequence");
$graph_template_inputs = db_fetch_assoc("select * from graph_template_input where graph_template_id=$graph_template_id");
if ((empty($graph_template["id"])) || (empty($graph_template_graph["id"]))) {
$err_msg = "Invalid graph template.";
return $err_msg;
}
$xml_text .= "<hash_" . $hash["graph_template"] . ">\n\t<name>" . xml_character_encode($graph_template["name"]) . "</name>\n";
$xml_text .= "\t\t<description>" . $graph_template["description"] . "</description>\n";
$xml_text .= "\t\t<image>" . $graph_template["image"] . "</image>\n\t<graph>\n";
/* XML Branch: <graph> */
$struct_graph = graph_form_list();
reset($struct_graph);
while (list($field_name, $field_array) = each($struct_graph)) {
$xml_text .= "\t\t<t_$field_name>" . xml_character_encode($graph_template_graph{"t_" . $field_name}) . "</t_$field_name>\n";
$xml_text .= "\t\t<$field_name>" . xml_character_encode($graph_template_graph{$field_name}) . "</$field_name>\n";
}
$xml_text .= "\t</graph>\n";
/* XML Branch: <items> */
$xml_text .= "\t<items>\n";
$i = 0;
if (sizeof($graph_template_items) > 0) {
$struct_graph_item = graph_item_form_list();
foreach ($graph_template_items as $item) {
$hash["graph_template_item"] = get_hash_version("graph_template_item") . get_hash_graph_template($item["id"], "graph_template_item");
$xml_text .= "\t\t<hash_" . $hash["graph_template_item"] . ">\n";
reset($struct_graph_item);
while (list($field_name, $field_array) = each($struct_graph_item)) {
if (($field_name == "task_item_id") && (!empty($item{$field_name}))) {
$xml_text .= "\t\t\t<$field_name>hash_" . get_hash_version("data_template_item") . get_hash_data_template($item{$field_name}, "data_template_item") . "</$field_name>\n";
}elseif (($field_name == "cdef_id") && (!empty($item{$field_name}))) {
$xml_text .= "\t\t\t<$field_name>hash_" . get_hash_version("cdef") . get_hash_cdef($item{$field_name}) . "</$field_name>\n";
}elseif (($field_name == "vdef_id") && (!empty($item{$field_name}))) {
$xml_text .= "\t\t\t<$field_name>hash_" . get_hash_version("vdef") . get_hash_vdef($item{$field_name}) . "</$field_name>\n";
}elseif (($field_name == "gprint_id") && (!empty($item{$field_name}))) {
$xml_text .= "\t\t\t<$field_name>hash_" . get_hash_version("gprint_preset") . get_hash_gprint($item{$field_name}) . "</$field_name>\n";
}elseif (($field_name == "color_id") && (!empty($item{$field_name}))) {
$xml_text .= "\t\t\t<$field_name>" . db_fetch_cell("select hex from colors where id=" . $item{$field_name}) . "</$field_name>\n";
}else{
$xml_text .= "\t\t\t<$field_name>" . xml_character_encode($item{$field_name}) . "</$field_name>\n";
}
}
$xml_text .= "\t\t</hash_" . $hash["graph_template_item"] . ">\n";
$i++;
}
}
$xml_text .= "\t</items>\n";
/* XML Branch: <inputs> */
$xml_text .= "\t<inputs>\n";
$i = 0;
if (sizeof($graph_template_inputs) > 0) {
$fields_graph_template_input_edit = graph_template_input_form_list();
foreach ($graph_template_inputs as $item) {
$hash["graph_template_input"] = get_hash_version("graph_template_input") . get_hash_graph_template($item["id"], "graph_template_input");
$xml_text .= "\t\t<hash_" . $hash["graph_template_input"] . ">\n";
reset($fields_graph_template_input_edit);
while (list($field_name, $field_array) = each($fields_graph_template_input_edit)) {
if (($field_array["method"] != "hidden_zero") && ($field_array["method"] != "hidden") && ($field_array["method"] != "spacer")) {
$xml_text .= "\t\t\t<$field_name>" . xml_character_encode($item{$field_name}) . "</$field_name>\n";
}
}
$graph_template_input_items = db_fetch_assoc("select graph_template_item_id from graph_template_input_defs where graph_template_input_id=" . $item["id"]);
$xml_text .= "\t\t\t<items>";
$j = 0;
if (sizeof($graph_template_input_items) > 0) {
foreach ($graph_template_input_items as $item2) {
$xml_text .= "hash_" . get_hash_version("graph_template") . get_hash_graph_template($item2["graph_template_item_id"], "graph_template_item");
if (($j+1) < sizeof($graph_template_input_items)) {
$xml_text .= "|";
}
$j++;
}
}
$xml_text .= "</items>\n";
$xml_text .= "\t\t</hash_" . $hash["graph_template_input"] . ">\n";
$i++;
}
}
$xml_text .= "\t</inputs>\n";
$xml_text .= "</hash_" . $hash["graph_template"] . ">";
return $xml_text;
}
function item_edit() {
global $colors;
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("id"));
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("graph_template_id"));
input_validate_input_number(get_request_var_request("local_graph_id"));
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("data_template_id"));
/* ==================================================== */
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("local_graph_id", "sess_local_graph_id", "");
load_current_session_value("device_id", "sess_ds_device_id", "-1");
load_current_session_value("data_template_id", "sess_data_template_id", "-1");
$id = (!empty($_REQUEST["id"]) ? "&id=" . get_request_var_request("id") : "");
$device = db_fetch_row("select hostname from device where id=" . get_request_var_request("device_id"));
html_start_box("<strong>" . __("Data Sources") . "</strong> " . __("[device: ") . (empty($device["hostname"]) ? __("No Host") : $device["hostname"]) . "]", "100", $colors["header"], "3", "center", "");
?>
<tr>
<td>
<form name="form_graph_items">
<table cellpadding="0" cellspacing="0">
<tr>
<td class="nw50">
<?php print __("Host");?>:
</td>
<td>
<select name="cbo_device_id" onChange="window.location=document.form_graph_items.cbo_device_id.options[document.form_graph_items.cbo_device_id.selectedIndex].value">
<option value="<?php print htmlspecialchars("graphs_items.php?action=item_edit" . $id . "&local_graph_id=" . get_request_var_request("local_graph_id") . "&device_id=-1&data_template_id=" . get_request_var_request("data_template_id"));?>"<?php if (get_request_var_request("device_id") == "-1") {?> selected<?php }?>>Any</option>
<option value="<?php print htmlspecialchars("graphs_items.php?action=item_edit" . $id . "&local_graph_id=" . get_request_var_request("local_graph_id") . "&device_id=0&data_template_id=" . get_request_var_request("data_template_id"));?>"<?php if (get_request_var_request("device_id") == "0") {?> selected<?php }?>>None</option>
<?php
$devices = db_fetch_assoc("select id,CONCAT_WS('',description,' (',hostname,')') as name from device order by description,hostname");
if (sizeof($devices) > 0) {
foreach ($devices as $device) {
print "<option value='" . htmlspecialchars("graphs_items.php?action=item_edit" . $id . "&local_graph_id=" . get_request_var_request("local_graph_id") . "&device_id=" . $device["id"] . "&data_template_id=" . get_request_var_request("data_template_id")) . "'"; if (get_request_var_request("device_id") == $device["id"]) { print " selected"; } print ">" . $device["name"] . "</option>\n";
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="nw100">
<?php print __("Data Source Template:");?>
</td>
<td>
<select name="cbo_data_template_id" onChange="window.location=document.form_graph_items.cbo_data_template_id.options[document.form_graph_items.cbo_data_template_id.selectedIndex].value">
<option value="graphs_items.php?action=item_edit<?php print $id; ?>&local_graph_id=<?php print get_request_var_request("local_graph_id");?>&data_template_id=-1&device_id=<?php print get_request_var_request("device_id");?>"<?php if (get_request_var_request("data_template_id") == "-1") {?> selected<?php }?>>Any</option>
<option value="graphs_items.php?action=item_edit<?php print $id; ?>&local_graph_id=<?php print get_request_var_request("local_graph_id");?>&data_template_id=0&device_id=<?php print get_request_var_request("device_id");?>"<?php if (get_request_var_request("data_template_id") == "0") {?> selected<?php }?>>None</option>
<?php
$data_templates = db_fetch_assoc("select id, name from data_template order by name");
if (sizeof($data_templates) > 0) {
foreach ($data_templates as $data_template) {
print "<option value='graphs_items.php?action=item_edit" . $id . "&local_graph_id=" . get_request_var_request("local_graph_id") . "&data_template_id=" . $data_template["id"]. "&device_id=" . get_request_var_request("device_id") . "'"; if (get_request_var_request("data_template_id") == $data_template["id"]) { print " selected"; } print ">" . $data_template["name"] . "</option>\n";
}
}
?>
</select>
</td>
</tr>
</table>
</form>
</td>
</tr>
<?php
html_end_box();
if (get_request_var_request("device_id") == "-1") {
$sql_where = "";
}elseif (get_request_var_request("device_id") == "0") {
$sql_where = " data_local.device_id=0 and ";
}elseif (!empty($_REQUEST["device_id"])) {
$sql_where = " data_local.device_id=" . get_request_var_request("device_id") . " and ";
}
if (get_request_var_request("data_template_id") == "-1") {
$sql_where .= "";
}elseif (get_request_var_request("data_template_id") == "0") {
$sql_where .= " data_local.data_template_id=0 and ";
}elseif (!empty($_REQUEST["data_template_id"])) {
$sql_where .= " data_local.data_template_id=" . get_request_var_request("data_template_id") . " and ";
}
if (!empty($_REQUEST["id"])) {
$template_item = db_fetch_row("select * from graph_templates_item where id=" . get_request_var_request("id"));
$device_id = db_fetch_cell("select device_id from graph_local where id=" . get_request_var_request("local_graph_id"));
}
/* by default, select the LAST DS chosen to make everyone's lives easier */
$struct_graph_item = graph_item_form_list();
if (!empty($_REQUEST["local_graph_id"])) {
$default = db_fetch_row("select task_item_id from graph_templates_item where local_graph_id=" . get_request_var_request("local_graph_id") . " order by sequence DESC");
if (sizeof($default) > 0) {
$struct_graph_item["task_item_id"]["default"] = $default["task_item_id"];
}else{
$struct_graph_item["task_item_id"]["default"] = 0;
}
/* modifications to the default graph items array */
$struct_graph_item["task_item_id"]["sql"] = "select
CONCAT_WS('',data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name,
data_template_rrd.id
from (data_template_data,data_template_rrd,data_local)
left join device on (data_local.device_id=device.id)
where data_template_rrd.local_data_id=data_local.id
and data_template_data.local_data_id=data_local.id ";
/* Make sure we don't limit the list so that the selected DS isn't in the list in edit mode */
if (strlen($sql_where) > 0) {
$sql_where = substr($sql_where,0,-5);
if (!empty($_REQUEST["id"])) {
$struct_graph_item["task_item_id"]["sql"] .= " and ((" . $sql_where . ") or (data_template_rrd.id = " . $template_item["task_item_id"] . "))";
} else {
$struct_graph_item["task_item_id"]["sql"] .= " and (" . $sql_where . ")";
}
}
$struct_graph_item["task_item_id"]["sql"] .= " order by name";
}
$form_array = array();
while (list($field_name, $field_array) = each($struct_graph_item)) {
$form_array += array($field_name => $struct_graph_item[$field_name]);
$form_array[$field_name]["value"] = (isset($template_item) ? $template_item[$field_name] : "");
$form_array[$field_name]["form_id"] = (isset($template_item) ? $template_item["id"] : "0");
}
if (!empty($_GET["local_graph_id"])) {
$header_label = __("[edit: ") . db_fetch_cell("select title_cache from graph_templates_graph where local_graph_id=" . get_request_var_request("local_graph_id")) . "]";
}else{
$header_label = __("[new]");
}
print "<form method='post' action='" . basename($_SERVER["PHP_SELF"]) . "' name='graph_item_edit'>\n";
html_start_box("<strong>" . __("Graph Items") . "</strong> $header_label", "100", $colors["header"], 0, "center", "", true);
$header_items = array(__("Field"), __("Value"));
print "<tr><td>";
html_header($header_items, 2, true, 'header_graph_item_edit');
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
form_hidden_box("local_graph_id", get_request_var_request("local_graph_id"), "0");
form_hidden_box("graph_template_item_id", (isset($template_item) ? $template_item["id"] : "0"), "");
form_hidden_box("local_graph_template_item_id", (isset($template_item) ? $template_item["local_graph_template_item_id"] : "0"), "");
form_hidden_box("graph_template_id", (isset($template_item) ? $template_item["graph_template_id"] : "0"), "");
# form_hidden_box("sequence", (isset($template_item) ? $template_item["sequence"] : "0"), "");
# form_hidden_box("_graph_type_id", (isset($template_item) ? $template_item["graph_type_id"] : "0"), "");
# form_hidden_box("hidden_task_item_id", (isset($template_item) ? $template_item["task_item_id"] : "0"), "");
form_hidden_box("save_component_item", "1", "");
form_hidden_box("hidden_rrdtool_version", read_config_option("rrdtool_version"), "");
print "</table></td></tr>"; /* end of html_header */
html_end_box();
form_save_button_alt("path!graphs.php|action!graph_edit|id!" . get_request_var_request("local_graph_id"));
include_once(CACTI_BASE_PATH . "/access/js/graph_item_dependencies.js"); # this one modifies attr("disabled")
include_once(CACTI_BASE_PATH . "/access/js/line_width.js");
include_once(CACTI_BASE_PATH . "/access/js/rrdtool_version.js"); # this one sets attr("disabled) and comes last!
}
function item_edit() {
global $colors;
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
/* ================= input validation ================= */
input_validate_input_number(get_request_var("id"));
input_validate_input_number(get_request_var("graph_template_id"));
/* ==================================================== */
if (!empty($_GET["id"])) {
$template_item = db_fetch_row("select * from graph_templates_item where id=" . get_request_var("id"));
}
/* by default, select the LAST DS chosen to make everyone's lives easier */
$struct_graph_item = graph_item_form_list();
if (!empty($_GET["graph_template_id"])) {
$default = db_fetch_row("select task_item_id from graph_templates_item where graph_template_id=" . get_request_var("graph_template_id") . " and local_graph_id=0 order by sequence DESC");
if (sizeof($default) > 0) {
$struct_graph_item["task_item_id"]["default"] = $default["task_item_id"];
}else{
$struct_graph_item["task_item_id"]["default"] = 0;
}
}
/* modifications to the default graph items array */
$struct_graph_item["task_item_id"]["sql"] = "select
CONCAT_WS('',data_template.name,' - ',' (',data_template_rrd.data_source_name,')') as name,
data_template_rrd.id
from (data_template_data,data_template_rrd,data_template)
where data_template_rrd.data_template_id=data_template.id
and data_template_data.data_template_id=data_template.id
and data_template_data.local_data_id=0
and data_template_rrd.local_data_id=0
order by data_template.name,data_template_rrd.data_source_name";
$form_array = array();
while (list($field_name, $field_array) = each($struct_graph_item)) {
$form_array += array($field_name => $struct_graph_item[$field_name]);
$form_array[$field_name]["value"] = (isset($template_item) ? $template_item[$field_name] : "");
$form_array[$field_name]["form_id"] = (isset($template_item) ? $template_item["id"] : "0");
}
if (!empty($_GET["id"])) {
/* we want to mark the fields that are associated with a graph item input */
$graph_item_input_fields = db_fetch_assoc("select
graph_template_input.id,
graph_template_input.column_name
from (graph_template_input,graph_template_input_defs)
where graph_template_input.id=graph_template_input_defs.graph_template_input_id
and graph_template_input.graph_template_id=" . get_request_var("graph_template_id") . "
and graph_template_input_defs.graph_template_item_id=" . get_request_var("id") . "
group by graph_template_input.column_name");
if (sizeof($graph_item_input_fields) > 0) {
foreach ($graph_item_input_fields as $field) {
$form_array{$field["column_name"]}["friendly_name"] .= " [<a href='" . htmlspecialchars("graph_templates_inputs.php?action=input_edit&id=" . $field["id"] . "&graph_template_id=" . get_request_var("graph_template_id")) . "'>Field Not Templated</a>]";
}
}
}
if (!empty($_GET["graph_template_id"])) {
$header_label = __("[edit graph: ") . db_fetch_cell("select name from graph_templates where id=" . get_request_var("graph_template_id")) . "]";
}else{
$header_label = __("[new]");
}
print "<form method='post' action='" . basename($_SERVER["PHP_SELF"]) . "' name='graph_template_item_edit'>\n";
html_start_box("<strong>" . __("Graph Template Items") . "</strong> $header_label", "100", $colors["header"], 0, "center", "", true);
$header_items = array(__("Field"), __("Value"));
print "<tr><td>";
html_header($header_items, 2, true, 'header_graph_template_item_edit');
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
print "</table></td></tr>"; /* end of html_header */
html_end_box();
form_hidden_box("graph_template_item_id", (isset($template_item) ? $template_item["id"] : "0"), "");
form_hidden_box("graph_template_id", get_request_var("graph_template_id"), "0");
# form_hidden_box("hidden_graph_type_id", (isset($template_item) ? $template_item["graph_type_id"] : "0"), "");
form_hidden_box("hidden_task_item_id", (isset($template_item) ? $template_item["task_item_id"] : "0"), "");
form_hidden_box("save_component_item", "1", "");
form_hidden_box("hidden_rrdtool_version", read_config_option("rrdtool_version"), "");
form_save_button_alt("url!" . (isset($_SERVER["HTTP_REFERER"]) ? $_SERVER["HTTP_REFERER"] : ""));
include_once(CACTI_BASE_PATH . "/access/js/graph_item_dependencies.js"); # this one modifies attr("disabled")
include_once(CACTI_BASE_PATH . "/access/js/line_width.js");
include_once(CACTI_BASE_PATH . "/access/js/rrdtool_version.js"); # this one sets attr("disabled) and comes last!
}
function graph_diff() {
global $colors;
require(CACTI_BASE_PATH . "/include/presets/preset_rra_arrays.php");
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
/* ================= input validation ================= */
input_validate_input_number(get_request_var("id"));
input_validate_input_number(get_request_var("graph_template_id"));
/* ==================================================== */
$template_query = "select
graph_templates_item.id,
graph_templates_item.text_format,
graph_templates_item.value,
graph_templates_item.hard_return,
graph_templates_item.consolidation_function_id,
graph_templates_item.graph_type_id,
CONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) as task_item_id,
cdef.name as cdef_id,
colors.hex as color_id
from graph_templates_item
left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)
left join data_local on (data_template_rrd.local_data_id=data_local.id)
left join data_template_data on (data_local.id=data_template_data.local_data_id)
left join cdef on (cdef_id=cdef.id)
left join colors on (color_id=colors.id)";
/* first, get information about the graph template as that's what we're going to model this
graph after */
$graph_template_items = db_fetch_assoc("
$template_query
where graph_templates_item.graph_template_id=" . get_request_var("graph_template_id") . "
and graph_templates_item.local_graph_id=0
order by graph_templates_item.sequence");
/* next, get information about the current graph so we can make the appropriate comparisons */
$graph_items = db_fetch_assoc("
$template_query
where graph_templates_item.local_graph_id=" . get_request_var("id") . "
order by graph_templates_item.sequence");
$graph_template_inputs = db_fetch_assoc("select
graph_template_input.column_name,
graph_template_input_defs.graph_template_item_id
from (graph_template_input,graph_template_input_defs)
where graph_template_input.id=graph_template_input_defs.graph_template_input_id
and graph_template_input.graph_template_id=" . get_request_var("graph_template_id"));
/* ok, we want to loop through the array with the GREATEST number of items so we don't have to worry
about tacking items on the end */
if (sizeof($graph_template_items) > sizeof($graph_items)) {
$items = $graph_template_items;
}else{
$items = $graph_items;
}
?>
<table class='topBoxAlt'>
<tr>
<td class="textArea">
<?php print __("The template you have selected requires some changes to be made to the structure of your graph. Below is a preview of your graph along with changes that need to be completed as shown in the left-hand column.");?>
</td>
</tr>
</table>
<br>
<?php
html_start_box("<strong>" . __("Graph Preview") . "</strong>", "100", $colors["header"], "3", "center", "");
$graph_item_actions = array("normal" => "", "add" => "+", "delete" => "-");
$group_counter = 0; $i = 0; $mode = "normal"; $_graph_type_name = "";
if (sizeof($items) > 0) {
$struct_graph_item = graph_item_form_list();
foreach ($items as $item) {
reset($struct_graph_item);
/* graph grouping display logic */
$bold_this_row = false; $use_custom_row_color = false; $action_css = ""; unset($graph_preview_item_values);
if ((sizeof($graph_template_items) > sizeof($graph_items)) && ($i >= sizeof($graph_items))) {
$mode = "add";
$user_message = __("When you click save, the items marked with a '<strong>+</strong>' will be added <strong>(Recommended)</strong>.");
}elseif ((sizeof($graph_template_items) < sizeof($graph_items)) && ($i >= sizeof($graph_template_items))) {
$mode = "delete";
$user_message = __("When you click save, the items marked with a '<strong>-</strong>' will be removed <strong>(Recommended)</strong>.");
}
/* here is the fun meshing part. first we check the graph template to see if there is an input
for each field of this row. if there is, we revert to the value stored in the graph, if not
we revert to the value stored in the template. got that? ;) */
for ($j=0; ($j < count($graph_template_inputs)); $j++) {
if ($graph_template_inputs[$j]["graph_template_item_id"] == (isset($graph_template_items[$i]["id"]) ? $graph_template_items[$i]["id"] : "")) {
/* if we find out that there is an "input" covering this field/item, use the
value from the graph, not the template */
$graph_item_field_name = (isset($graph_template_inputs[$j]["column_name"]) ? $graph_template_inputs[$j]["column_name"] : "");
$graph_preview_item_values[$graph_item_field_name] = (isset($graph_items[$i][$graph_item_field_name]) ? $graph_items[$i][$graph_item_field_name] : "");
}
}
/* go back through each graph field and find out which ones haven't been covered by the
"inputs" above. for each one, use the value from the template */
while (list($field_name, $field_array) = each($struct_graph_item)) {
if ($mode == "delete") {
$graph_preview_item_values[$field_name] = (isset($graph_items[$i][$field_name]) ? $graph_items[$i][$field_name] : "");
}elseif (!isset($graph_preview_item_values[$field_name])) {
$graph_preview_item_values[$field_name] = (isset($graph_template_items[$i][$field_name]) ? $graph_template_items[$i][$field_name] : "");
}
}
/* "prepare" array values */
$consolidation_function_id = $graph_preview_item_values["consolidation_function_id"];
$graph_type_id = $graph_preview_item_values["graph_type_id"];
/* color logic */
if (($graph_type_id != GRAPH_ITEM_TYPE_GPRINT) && ($graph_item_types[$graph_type_id] != $_graph_type_name)) {
$bold_this_row = true; $use_custom_row_color = true; $hard_return = "";
if ($group_counter % 2 == 0) {
$alternate_color_1 = "EEEEEE";
$alternate_color_2 = "EEEEEE";
$custom_row_color = "D5D5D5";
}else{
$alternate_color_1 = $colors["alternate"];
$alternate_color_2 = $colors["alternate"];
$custom_row_color = "D2D6E7";
}
$group_counter++;
}
$_graph_type_name = $graph_item_types[$graph_type_id];
/* alternating row colors */
if ($use_custom_row_color == false) {
if ($i % 2 == 0) {
$action_column_color = $alternate_color_1;
}else{
$action_column_color = $alternate_color_2;
}
}else{
$action_column_color = $custom_row_color;
}
print "<tr bgcolor='#$action_column_color'>"; $i++;
/* make the left-hand column blue or red depending on if "add"/"remove" mode is set */
if ($mode == "add") {
$action_column_color = $colors["header"];
$action_css = "";
}elseif ($mode == "delete") {
$action_column_color = "C63636";
$action_css = "text-decoration: line-through;";
}
if ($bold_this_row == true) {
$action_css .= " font-weight:bold;";
}
/* draw the TD that shows the user whether we are going to: KEEP, ADD, or DROP the item */
print "<td width='1%' bgcolor='#$action_column_color' style='font-weight: bold; color: white;'>" . $graph_item_actions[$mode] . "</td>";
print "<td style='$action_css'><strong>" . __("Item") . " # " . $i . "</strong></td>\n";
if (empty($graph_preview_item_values["task_item_id"])) { $graph_preview_item_values["task_item_id"] = "No Task"; }
switch ($graph_type_id) {
case GRAPH_ITEM_TYPE_AREA:
case GRAPH_ITEM_TYPE_AREASTACK:
case GRAPH_ITEM_TYPE_GPRINT:
case GRAPH_ITEM_TYPE_LINE1:
case GRAPH_ITEM_TYPE_LINE2:
case GRAPH_ITEM_TYPE_LINE3:
case GRAPH_ITEM_TYPE_LINESTACK:
$matrix_title = "(" . $graph_preview_item_values["task_item_id"] . "): " . $graph_preview_item_values["text_format"];
break;
case GRAPH_ITEM_TYPE_HRULE:
$matrix_title = "VRULE: " . $graph_preview_item_values["value"];
break;
case GRAPH_ITEM_TYPE_VRULE:
$matrix_title = "HRULE: " . $graph_preview_item_values["value"];
break;
case GRAPH_ITEM_TYPE_COMMENT:
$matrix_title = "COMMENT: " . $graph_preview_item_values["text_format"];
break;
}
/* use the cdef name (if in use) if all else fails */
if ($matrix_title == "") {
if ($graph_preview_item_values["cdef_id"] != "") {
$matrix_title .= "CDEF: " . $graph_preview_item_values["cdef_id"];
}
}
if ($graph_preview_item_values["hard_return"] == CHECKED) {
$hard_return = "<strong><font color=\"#FF0000\"><HR></font></strong>";
}
print "<td style='$action_css'>" . htmlspecialchars($matrix_title) . $hard_return . "</td>\n";
print "<td style='$action_css'>" . $graph_item_types{$graph_preview_item_values["graph_type_id"]} . "</td>\n";
print "<td style='$action_css'>" . $consolidation_functions{$graph_preview_item_values["consolidation_function_id"]} . "</td>\n";
print "<td" . ((!empty($graph_preview_item_values["color_id"])) ? " bgcolor='#" . $graph_preview_item_values["color_id"] . "'" : "") . " width='1%'> </td>\n";
print "<td style='$action_css'>" . $graph_preview_item_values["color_id"] . "</td>\n";
print "</tr>";
}
}else{
form_alternate_row_color();
?>
<td colspan="7">
<em><?php print __("No Items");?></em>
</td>
<?php
form_end_row();
}
html_end_box();
?>
<form action="graphs.php" method="post">
<table class='topBoxAlt'>
<tr>
<td class="textArea">
<input type='radio' name='type' value='1' checked> <?php print $user_message;?><br>
<input type='radio' name='type' value='2'> <?php print __("When you click save, the graph items will remain untouched (could cause inconsistencies).");?>
</td>
</tr>
</table>
<br>
<input type="hidden" name="action" value="save">
<input type="hidden" name="save_component_graph_diff" value="1">
<input type="hidden" name="local_graph_id" value="<?php print get_request_var("id");?>">
<input type="hidden" name="graph_template_id" value="<?php print get_request_var("graph_template_id");?>">
<?php
form_save_button_alt("action!graph_edit|id!" . get_request_var("id"));
}
