function copy_data_template_to_data_source($data_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/data_source/data_source_update.php");
require_once(CACTI_BASE_PATH . "/lib/data_source/data_source_info.php");
require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_info.php");
/* sanity check for $data_template_id */
if ((!is_numeric($data_template_id)) || (empty($data_template_id))) {
return false;
}
/* sanity check for $host_id */
if (!is_numeric($host_id)) {
return false;
}
/* fetch field lists */
$fields_data_source = api_data_source_form_list();
$fields_data_source_item = api_data_source_item_form_list();
/* fetch information from that data template */
$data_template = api_data_template_get($data_template_id);
$_data_template_input_fields = api_data_template_input_field_list($data_template_id);
if (sizeof($data_template) > 0) {
/* copy down per-data source only fields */
$_fields = array();
$_fields["id"] = "0";
$_fields["data_template_id"] = $data_template_id;
$_fields["host_id"] = $host_id;
/* evaluate suggested values: data query-based graphs */
if ((!empty($data_query_id)) && ($data_query_index != "")) {
$_fields["name"] = evaluate_data_query_suggested_values($host_id, $data_query_id, $data_query_index, "data_template_suggested_value", "data_template_id = " . sql_sanitize($data_template_id) . " and field_name = 'name'", 0);
/* evaluate suggested values: non-data query-based graphs */
}else{
$_fields["name"] = db_fetch_cell("select value from data_template_suggested_value where data_template_id = " . sql_sanitize($data_template_id) . " and field_name = 'name' order by sequence limit 1");
}
/* copy down all visible fields */
foreach (array_keys($fields_data_source) as $field_name) {
if (isset($data_template[$field_name])) {
$_fields[$field_name] = $data_template[$field_name];
}
}
$data_source_id = api_data_source_save(0, $_fields, true);
if ($data_source_id) {
log_save("Cloning data source [ID#$data_source_id] from template [ID#$data_template_id]", SEV_DEBUG);
/* reformat the $_data_template_input_fields to be more compatible with api_data_source_save() */
$data_template_input_fields = array();
foreach (array_keys($_data_template_input_fields) as $field_name) {
$data_template_input_fields[$field_name] = $_data_template_input_fields[$field_name]["value"];
}
/* handle data source custom fields */
api_data_source_fields_save($data_source_id, $data_template_input_fields);
/* handle associated rra items */
api_data_source_data_template_rra_item_copy($data_source_id, $data_template_id);
/* move onto the data source items */
$data_template_items = api_data_template_item_list($data_template_id);
if (sizeof($data_template_items) > 0) {
foreach ($data_template_items as $data_template_item) {
/* copy down per-data source only fields */
$_fields = array();
$_fields["id"] = "0";
$_fields["data_source_id"] = $data_source_id;
$_fields["data_template_item_id"] = $data_template_item["id"];
$_fields["field_input_value"] = $data_template_item["field_input_value"];
/* copy down all visible fields */
foreach (array_keys($fields_data_source_item) as $field_name) {
$_fields[$field_name] = $data_template_item[$field_name];
}
if (!api_data_source_item_save(0, $_fields)) {
log_save("Save error in api_data_source_item_save()", SEV_ERROR);
}
}
}
return $data_source_id;
}else{
log_save("Save error in api_data_source_save()", SEV_ERROR, FACIL_WEBUI);
return false;
}
}
return false;
}
function &package_data_template_export($data_template_id, $indent = 3) {
require_once(CACTI_BASE_PATH . "/lib/data_preset/data_preset_rra_info.php");
require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_info.php");
require_once(CACTI_BASE_PATH . "/lib/data_source/data_source_info.php");
$xml = "";
/*
* XML Tag: <template>
*/
/* obtain a list of all data template specific fields */
$data_template_fields = api_data_template_form_list();
/* obtain a copy of this specfic data template */
$data_template = api_data_template_get($data_template_id);
$_xml = "";
foreach (array_keys($data_template_fields) as $field_name) {
/* create an XML key for each data template field */
$_xml .= package_xml_tag_get($field_name, xml_character_encode($data_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: <data_source>
*/
/* obtain a list of all data source specific fields */
$data_source_fields = api_data_source_form_list();
$_xml = "";
foreach (array_keys($data_source_fields) as $field_name) {
/* check because the 'name' column does not exist */
if (isset($data_template[$field_name])) {
/* create an XML key for each data source field */
$_xml .= package_xml_tag_get($field_name, xml_character_encode($data_template[$field_name]), $indent + 2);
}
/* check because the 't_data_input_type' and 't_rrd_path' columns do not exist */
if (isset($data_template{"t_" . $field_name})) {
/* create an XML key for each "template" data source field */
$_xml .= package_xml_tag_get("t_" . $field_name, xml_character_encode($data_template{"t_" . $field_name}), $indent + 2);
}
}
/* append the result onto the final XML string */
$xml .= package_xml_tag_get("data_source", $_xml, $indent + 1, true);
/*
* XML Tag: <items>
*/
/* obtain a list of all data source item specific fields */
$data_source_items_fields = api_data_source_item_form_list();
/* obtain a list of all data template items associated with this data template */
$data_template_items = api_data_template_item_list($data_template_id);
$_xml = "";
if (sizeof($data_template_items) > 0) {
foreach ($data_template_items as $data_template_item) {
$__xml = "";
foreach (array_keys($data_source_items_fields) as $field_name) {
/* create an XML key for each data template item field */
$__xml .= package_xml_tag_get($field_name, xml_character_encode($data_template_item[$field_name]), $indent + 3);
}
/* append the result onto a temporary XML string */
$_xml .= package_xml_tag_get(package_hash_get($data_template_item["id"], "data_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: <fields>
*/
/* obtain a list of all data template input fields associated with this data template */
$data_template_input_fields = api_data_template_input_field_list($data_template_id);
$_xml = "";
if (sizeof($data_template_input_fields) > 0) {
$i = 0;
foreach ($data_template_input_fields as $data_template_input_field_name => $data_template_input_field) {
$__xml = "";
/* create an XML key for each suggested value field */
$__xml .= package_xml_tag_get("name", xml_character_encode($data_template_input_field_name), $indent + 3);
$__xml .= package_xml_tag_get("t_value", xml_character_encode($data_template_input_field["t_value"]), $indent + 3);
/* make sure to resolve internal ID's for specific fields */
if ($data_template_input_field_name == "data_query_id") {
$__xml .= package_xml_tag_get("value", xml_character_encode(package_hash_get($data_template_input_field["value"], "data_query")), $indent + 3);
}else if ($data_template_input_field_name == "script_id") {
$__xml .= package_xml_tag_get("value", xml_character_encode(package_hash_get($data_template_input_field["value"], "script")), $indent + 3);
}else{
$__xml .= package_xml_tag_get("value", xml_character_encode($data_template_input_field["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++;
}
}
/*
* XML Tag: <rra_items>
*/
/* obtain a list of all rra item preset specific fields */
$rra_items_fields = api_data_preset_rra_item_form_list();
/* obtain a list of all rra items associated with this data template */
$rra_items = api_data_template_rra_item_list($data_template_id);
$_xml = "";
if (is_array($rra_items)) {
$i = 0;
foreach ($rra_items as $rra_item) {
$__xml = "";
foreach (array_keys($rra_items_fields) as $field_name) {
/* create an XML key for each rra item field */
$__xml .= package_xml_tag_get($field_name, xml_character_encode($rra_item[$field_name]), $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("rra_items", $_xml, $indent + 1, true);
/*
* XML Tag: <suggested_values>
*/
/* obtain a list of all suggested values associated with this data template */
$data_template_suggested_values = api_data_template_suggested_values_list($data_template_id);
$_xml = "";
if (sizeof($data_template_suggested_values) > 0) {
$i = 0;
foreach ($data_template_suggested_values as $data_template_suggested_value) {
$__xml = "";
/* create an XML key for each suggested value field */
$__xml .= package_xml_tag_get("field_name", xml_character_encode($data_template_suggested_value["field_name"]), $indent + 3);
$__xml .= package_xml_tag_get("sequence", xml_character_encode($data_template_suggested_value["sequence"]), $indent + 3);
$__xml .= package_xml_tag_get("value", xml_character_encode($data_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 'data_template' tag and return it */
$xml = package_xml_tag_get(package_hash_get($data_template_id, "data_template"), $xml, $indent, true);
return $xml;
}
