/** 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 - draws a form that consists of all non-templated graph fields associated
with a particular graph template
@param int $graph_template_id - the id of the graph template to base the form after
@param array $values_array - any values that should be included by default on the form
@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
@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
@param bool $include_hidden_fields - should elements that are not to be displayed be represented as hidden
html input elements or omitted altogether?
@param int $snmp_query_graph_id - if this graph template is part of a data query, specify the graph id here. this
will be used to determine if a given field is using suggested values */
function draw_nontemplated_fields_graph($graph_template_id, &$values_array, $field_name_format = "|field|", $header_title = "", $alternate_colors = true, $include_hidden_fields = true, $snmp_query_graph_id = 0) {
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 */
$graph_template = db_fetch_row("select * from graph_templates_graph where graph_template_id=$graph_template_id and local_graph_id=0");
$struct_graph = graph_form_list();
reset($struct_graph);
while (list($field_name, $field_array) = each($struct_graph)) {
/* find our field name */
$form_field_name = str_replace("|field|", $field_name, $field_name_format);
$form_array += array($form_field_name => $struct_graph[$field_name]);
/* modifications to the default form array */
$form_array[$form_field_name]["value"] = (isset($values_array[$field_name]) ? $values_array[$field_name] : "");
$form_array[$form_field_name]["form_id"] = (isset($values_array["id"]) ? $values_array["id"] : "0");
unset($form_array[$form_field_name]["default"]);
if ($graph_template{"t_" . $field_name} != CHECKED) {
if ($include_hidden_fields == true) {
$form_array[$form_field_name]["method"] = "hidden";
}else{
unset($form_array[$form_field_name]);
}
}elseif ((!empty($snmp_query_graph_id)) && (sizeof(db_fetch_assoc("select id from snmp_query_graph_sv where snmp_query_graph_id=$snmp_query_graph_id and field_name='$field_name'")) > 0)) {
if ($include_hidden_fields == true) {
$form_array[$form_field_name]["method"] = "hidden";
}else{
unset($form_array[$form_field_name]);
}
}else{
if (($draw_any_items == false) && ($header_title != "")) {
print "<tr><td>";
html_header(array($header_title, " "), 1, true, 'template_graph_' . $field_name);
}
$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"]);
}
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 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);
}
}
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;
}
