function api_data_template_fields_validate(&$_fields_data_template, $data_template_field_name_format = "|field|") { require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_info.php"); if (sizeof($_fields_data_template) == 0) { return array(); } /* array containing errored fields */ $error_fields = array(); /* get a complete field list */ $fields_data_template = api_data_template_form_list(); /* base fields */ while (list($_field_name, $_field_array) = each($fields_data_template)) { $form_field_name = str_replace("|field|", $_field_name, $data_template_field_name_format); if ((isset($_fields_data_template[$_field_name])) && (isset($_field_array["validate_regexp"])) && (isset($_field_array["validate_empty"]))) { if (!form_input_validate($_fields_data_template[$_field_name], $form_field_name, $_field_array["validate_regexp"], $_field_array["validate_empty"])) { $error_fields[] = $form_field_name; } } } return $error_fields; }
function api_data_template_save($data_template_id, $_fields_data_source) { require_once(CACTI_BASE_PATH . "/lib/data_source/data_source_info.php"); require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_info.php"); require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_push.php"); /* sanity checks */ validate_id_die($data_template_id, "data_template_id", true); /* make sure that there is at least one field to save */ if (sizeof($_fields_data_source) == 0) { return false; } /* field: id */ $_fields["id"] = array("type" => DB_TYPE_INTEGER, "value" => $data_template_id); /* convert the input array into something that is compatible with db_replace() */ $_fields += sql_get_database_field_array($_fields_data_source, api_data_template_form_list()); $_fields += sql_get_database_field_array($_fields_data_source, api_data_source_form_list()); if (db_replace("data_template", $_fields, array("id"))) { if (empty($data_template_id)) { $data_template_id = db_fetch_insert_id(); }else{ /* push out data template fields */ api_data_template_propagate($data_template_id); } return $data_template_id; }else{ return false; } }
function api_data_template_list($filter_array = "", $current_page = 0, $rows_per_page = 0) { require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_form.php"); $sql_where = ""; /* validation and setup for the WHERE clause */ if ((is_array($filter_array)) && (sizeof($filter_array) > 0)) { /* validate each field against the known master field list */ $field_errors = api_data_template_fields_validate(sql_filter_array_to_field_array($filter_array)); /* if a field input error has occured, register the error in the session and return */ if (sizeof($field_errors) > 0) { field_register_error($field_errors); return false; /* otherwise, form an SQL WHERE string using the filter fields */ }else{ $sql_where = sql_filter_array_to_where_string($filter_array, api_data_template_form_list(), true); } } $sql_limit = ""; /* validation and setup for the LIMIT clause */ if ((is_numeric($current_page)) && (is_numeric($rows_per_page)) && (!empty($current_page)) && (!empty($rows_per_page))) { $sql_limit = "limit " . ($rows_per_page * ($current_page - 1)) . ",$rows_per_page"; } return db_fetch_assoc("select data_template.id, data_template.template_name, data_template.data_input_type, data_template.active from data_template $sql_where " . ($sql_where == "" ? "where" : "and") . " data_template.package_id = 0 order by template_name $sql_limit"); }
function package_data_template_import(&$xml_array, $package_id, $object_hash) { require_once(CACTI_BASE_PATH . "/lib/data_preset/data_preset_rra_info.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"); require_once(CACTI_BASE_PATH . "/lib/data_template/data_template_update.php"); $save_fields = array(); /* tag the graph template as a package member */ $save_fields["package_id"] = $package_id; /* * XML Tag: <template> */ /* obtain a list of all data template specific fields */ $data_template_fields = api_data_template_form_list(); if (isset($xml_array["template"])) { /* get the base fields from the xml */ foreach (array_keys($data_template_fields) as $field_name) { if (isset($xml_array["template"][$field_name])) { $save_fields[$field_name] = xml_character_decode($xml_array["template"][$field_name]); } } } /* * XML Tag: <data_source> */ /* obtain a list of all data source specific fields */ $data_source_fields = api_data_source_form_list(); if (isset($xml_array["data_source"])) { /* get the base fields from the xml */ foreach (array_keys($data_source_fields) as $field_name) { if (isset($xml_array["data_source"][$field_name])) { $save_fields[$field_name] = xml_character_decode($xml_array["data_source"][$field_name]); } } } /* make sure we got the required information before trying to save */ if ((isset($xml_array["template"])) && (isset($xml_array["data_source"]))) { /* save the data template field to the database and register its new id */ $data_template_id = package_hash_update($object_hash, api_data_template_save(0, $save_fields)); } /* make sure the save completed successfully */ if ($data_template_id === false) { return; } /* * XML Tag: <items> */ /* obtain a list of all data source item specific fields */ $data_source_item_fields = api_data_source_item_form_list(); if ((isset($xml_array["items"])) && (is_array($xml_array["items"]))) { $save_fields = array(); /* get the base fields from the xml */ foreach ($xml_array["items"] as $data_template_item_hash => $data_template_item) { $save_fields = array(); /* make sure that each field is associated with the new data template */ $save_fields["data_template_id"] = $data_template_id; /* get the base fields from the xml */ foreach (array_keys($data_source_item_fields) as $field_name) { if (isset($data_template_item[$field_name])) { $save_fields[$field_name] = xml_character_decode($data_template_item[$field_name]); } } /* save the data template item to the database and register its new id */ package_hash_update($data_template_item_hash, api_data_template_item_save(0, $save_fields)); } } /* * XML Tag: <fields> */ if (isset($xml_array["fields"])) { $save_fields = array(); /* get the base fields from the xml */ foreach ($xml_array["fields"] as $field_array) { if ((isset($field_array["name"])) && (isset($field_array["t_value"])) && (isset($field_array["value"]))) { /* build an array containing each data input field */ if ($field_array["name"] == "data_query_id") { $field_value = package_hash_resolve($field_array["value"]); }else if ($field_array["name"] == "script_id") { $field_value = package_hash_resolve($field_array["value"]); }else{ $field_value = xml_character_decode($field_array["value"]); } $save_fields{$field_array["name"]} = array("t_value" => $field_array["t_value"], "value" => $field_value); } } /* save the fields to the database */ api_data_template_input_fields_save($data_template_id, $save_fields); } /* * XML Tag: <rra_items> */ /* obtain a list of all rra item preset specific fields */ $rra_items_fields = api_data_preset_rra_item_form_list(); if ((isset($xml_array["rra_items"])) && (is_array($xml_array["rra_items"]))) { $save_fields = array(); /* get the base fields from the xml */ foreach ($xml_array["rra_items"] as $rra_item) { $save_fields = array(); /* make sure that each field is associated with the new data template */ $save_fields["data_template_id"] = $data_template_id; /* get the base fields from the xml */ foreach (array_keys($rra_items_fields) as $field_name) { if (isset($rra_item[$field_name])) { $save_fields[$field_name] = xml_character_decode($rra_item[$field_name]); } } /* save the rra item to the database and register its new id */ api_data_template_rra_item_save(0, $save_fields); } } /* * XML Tag: <suggested_values> */ if (isset($xml_array["suggested_values"])) { $save_fields = array(); /* get the base fields from the xml */ foreach ($xml_array["suggested_values"] as $field_array) { if ((isset($field_array["field_name"])) && (isset($field_array["sequence"])) && (isset($field_array["value"]))) { /* build an array containing each data input field */ $save_fields{$field_array["field_name"]}[] = array("id" => "0", "value" => xml_character_decode($field_array["value"])); } } /* save the suggested values to the database */ api_data_template_suggested_values_save($data_template_id, $save_fields); } }
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; }