function api_graph_template_remove($graph_template_id) { require_once(CACTI_BASE_PATH . "/lib/graph_template/graph_template_info.php"); /* sanity checks */ validate_id_die($graph_template_id, "graph_template_id"); /* delete all graph template items */ $graph_template_items = api_graph_template_item_list($graph_template_id); if (is_array($graph_template_items) > 0) { foreach ($graph_template_items as $item) { api_graph_template_item_remove($item["id"], false); } } /* base tables */ db_delete("graph_template_suggested_value", array( "graph_template_id" => array("type" => DB_TYPE_INTEGER, "value" => $graph_template_id) )); db_delete("graph_template_item_input", array( "graph_template_id" => array("type" => DB_TYPE_INTEGER, "value" => $graph_template_id) )); db_delete("graph_template_item", array( "graph_template_id" => array("type" => DB_TYPE_INTEGER, "value" => $graph_template_id) )); db_delete("graph_template", array( "graph_template_id" => array("type" => DB_TYPE_INTEGER, "value" => $graph_template_id) )); /* host templates */ db_delete("host_template_graph", array( "graph_template_id" => array("type" => DB_TYPE_INTEGER, "value" => $graph_template_id) )); /* attached graphs */ db_execute("UPDATE graph SET graph_template_id = 0 WHERE graph_template_id = " . sql_sanitize($graph_template_id)); }
function copy_graph_template_to_graph($graph_template_id, $host_id = 0, $data_query_id = 0, $data_query_index = "") { require_once(CACTI_BASE_PATH . "/lib/sys/variable.php"); require_once(CACTI_BASE_PATH . "/lib/graph/graph_update.php"); require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php"); require_once(CACTI_BASE_PATH . "/lib/graph_template/graph_template_info.php"); /* sanity check for $graph_template_id */ if ((!is_numeric($graph_template_id)) || (empty($graph_template_id))) { return false; } /* sanity check for $host_id */ if (!is_numeric($host_id)) { return false; } /* fetch field lists */ $fields_graph = api_graph_form_list(); $fields_graph_item = api_graph_item_form_list(); $graph_template = api_graph_template_get($graph_template_id); if (sizeof($graph_template) > 0) { /* copy down per-graph only fields */ $_fields = array(); $_fields["id"] = "0"; $_fields["graph_template_id"] = $graph_template_id; $_fields["host_id"] = $host_id; /* evaluate suggested values: data query-based graphs */ if ((!empty($data_query_id)) && ($data_query_index != "")) { $_fields["title"] = evaluate_data_query_suggested_values($host_id, $data_query_id, $data_query_index, "graph_template_suggested_value", "graph_template_id = " . sql_sanitize($graph_template_id) . " and field_name = 'title'", 0); /* evaluate suggested values: non-data query-based graphs */ }else{ $_fields["title"] = db_fetch_cell("select value from graph_template_suggested_value where graph_template_id = " . sql_sanitize($graph_template_id) . " and field_name = 'title' order by sequence limit 1"); } /* copy down all visible fields */ foreach (array_keys($fields_graph) as $field_name) { if (isset($graph_template[$field_name])) { $_fields[$field_name] = $graph_template[$field_name]; } } if (api_graph_save(0, $_fields, true)) { $graph_id = db_fetch_insert_id(); log_save("Cloning graph [ID#$graph_id] from template [ID#$graph_template_id]", SEV_DEBUG); /* move onto the graph items */ $graph_template_items = api_graph_template_item_list($graph_template_id); if (sizeof($graph_template_items) > 0) { foreach ($graph_template_items as $graph_template_item) { /* copy down per-graph only fields */ $_fields = array(); $_fields["id"] = "0"; $_fields["graph_id"] = $graph_id; $_fields["graph_template_item_id"] = $graph_template_item["id"]; /* this allows us to connect the dots later */ foreach (array_keys($fields_graph_item) as $field_name) { if (isset($graph_template_item[$field_name])) { $_fields[$field_name] = $graph_template_item[$field_name]; } } if (!api_graph_item_save(0, $_fields)) { log_save("Save error in api_graph_item_save()", SEV_ERROR); } } } return $graph_id; }else{ log_save("Save error in api_graph_save()", SEV_ERROR); return false; } } return false; }
function &package_graph_template_export($graph_template_id, $indent = 3) { require_once(CACTI_BASE_PATH . "/lib/graph_template/graph_template_info.php"); require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php"); $xml = ""; /* * XML Tag: <template> */ /* obtain a list of all graph template specific fields */ $graph_template_fields = api_graph_template_form_list(); /* obtain a copy of this specfic graph template */ $graph_template = api_graph_template_get($graph_template_id); $_xml = ""; foreach (array_keys($graph_template_fields) as $field_name) { /* create an XML key for each graph template field */ $_xml .= package_xml_tag_get($field_name, xml_character_encode($graph_template[$field_name]), $indent + 2); } /* append the result onto the final XML string */ $xml .= package_xml_tag_get("template", $_xml, $indent + 1, true); /* * XML Tag: <graph> */ /* obtain a list of all graph specific fields */ $graph_fields = api_graph_form_list(); $_xml = ""; foreach (array_keys($graph_fields) as $field_name) { /* check because the 'title' column does not exist */ if (isset($graph_template[$field_name])) { /* create an XML key for each graph field */ $_xml .= package_xml_tag_get($field_name, xml_character_encode($graph_template[$field_name]), $indent + 2); } /* create an XML key for each "template" graph field */ $_xml .= package_xml_tag_get("t_" . $field_name, xml_character_encode($graph_template{"t_" . $field_name}), $indent + 2); } /* append the result onto the final XML string */ $xml .= package_xml_tag_get("graph", $_xml, $indent + 1, true); /* * XML Tag: <items> */ /* obtain a list of all graph template item specific fields */ $graph_template_items_fields = api_graph_template_item_form_list(); /* obtain a list of all graph template items associated with this graph template */ $graph_template_items = api_graph_template_item_list($graph_template_id); $_xml = ""; if (sizeof($graph_template_items) > 0) { foreach ($graph_template_items as $graph_template_item) { $__xml = ""; foreach (array_keys($graph_template_items_fields) as $field_name) { if ($field_name == "data_template_item_id") { /* create an XML key for the 'data_template_item_id' field, making sure to resolve internal ID's */ $__xml .= package_xml_tag_get($field_name, xml_character_encode(package_hash_get($graph_template_item[$field_name], "data_template_item")), $indent + 3); }else{ /* create an XML key for each graph template item field */ $__xml .= package_xml_tag_get($field_name, xml_character_encode($graph_template_item[$field_name]), $indent + 3); } } /* append the result onto a temporary XML string */ $_xml .= package_xml_tag_get(package_hash_get($graph_template_item["id"], "graph_template_item"), $__xml, $indent + 2, true); } } /* append the result onto the final XML string */ $xml .= package_xml_tag_get("items", $_xml, $indent + 1, true); /* * XML Tag: <inputs> */ /* obtain a list of all graph template item input specific fields */ $graph_template_inputs_fields = api_graph_template_item_input_form_list(); /* obtain a list of all graph template item inputs associated with this graph template */ $graph_template_inputs = api_graph_template_item_input_list($graph_template_id); $_xml = ""; if (sizeof($graph_template_inputs) > 0) { foreach ($graph_template_inputs as $graph_template_input) { $__xml = ""; foreach (array_keys($graph_template_inputs_fields) as $field_name) { /* create an XML key for each graph template item input field */ $__xml .= package_xml_tag_get($field_name, xml_character_encode($graph_template_input[$field_name]), $indent + 3); } /* obtain a list of each item associated with this graph template item input */ $graph_template_input_items = api_graph_template_item_input_item_list($graph_template_id); if (sizeof($graph_template_input_items) > 0) { $i = 0; $items_list = ""; foreach ($graph_template_input_items as $graph_template_item_id) { /* create a delimited list of each item, making sure to resolve internal ID's */ $items_list .= package_hash_get($graph_template_item_id, "graph_template_item") . (($i + 1) < sizeof($graph_template_input_items) ? "|" : ""); $i++; } } /* add the items list that we created above */ $__xml .= package_xml_tag_get("items", $items_list, $indent + 3); /* append the result onto a temporary XML string */ $_xml .= package_xml_tag_get(package_hash_get($graph_template_input["id"], "graph_template_input"), $__xml, $indent + 2, true); } } /* append the result onto the final XML string */ $xml .= package_xml_tag_get("inputs", $_xml, $indent + 1, true); /* * XML Tag: <suggested_values> */ /* obtain a list of all suggested values associated with this graph template */ $graph_template_suggested_values = api_graph_template_suggested_values_list($graph_template_id); $_xml = ""; if (sizeof($graph_template_suggested_values) > 0) { $i = 0; foreach ($graph_template_suggested_values as $graph_template_suggested_value) { $__xml = ""; /* create an XML key for each suggested value field */ $__xml .= package_xml_tag_get("field_name", xml_character_encode($graph_template_suggested_value["field_name"]), $indent + 3); $__xml .= package_xml_tag_get("sequence", xml_character_encode($graph_template_suggested_value["sequence"]), $indent + 3); $__xml .= package_xml_tag_get("value", xml_character_encode($graph_template_suggested_value["value"]), $indent + 3); /* break out each row into its own key */ $_xml .= package_xml_tag_get("item_" . str_pad($i, 5, "0", STR_PAD_LEFT), $__xml, $indent + 2, true); $i++; } } /* append the result onto the final XML string */ $xml .= package_xml_tag_get("suggested_values", $_xml, $indent + 1, true); /* wrap the whole XML string into a 'graph_template' tag and return it */ $xml = package_xml_tag_get(package_hash_get($graph_template_id, "graph_template"), $xml, $indent, true); return $xml; }