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 form_save()
{
if ($_POST["action_post"] == "data_template_edit") {
$data_input_fields = array();
$data_template_item_fields = array();
$suggested_value_fields = array();
$rra_item_fields = array();
/* cache all post field values */
init_post_field_cache();
reset($_POST);
/* step #1: field parsing */
while (list($name, $value) = each($_POST)) {
if (substr($name, 0, 4) == "dsi|") {
$matches = explode("|", $name);
$data_template_item_fields[$matches[2]][$matches[1]] = $value;
} else {
if (substr($name, 0, 4) == "dif_") {
$field_name = substr($name, 4);
$data_input_fields[$field_name]["value"] = $value;
if (isset($_POST["t_dif_{$field_name}"])) {
$data_input_fields[$field_name]["t_value"] = html_boolean($_POST["t_dif_{$field_name}"]);
} else {
$data_input_fields[$field_name]["t_value"] = "0";
}
} else {
if (substr($name, 0, 3) == "sv|") {
$matches = explode("|", $name);
$suggested_value_fields[$matches[1]][] = array("id" => $matches[2], "value" => $value);
} else {
if (substr($name, 0, 5) == "rrai|") {
$matches = explode("|", $name);
$rra_item_fields[$matches[2]][$matches[1]] = $value;
}
}
}
}
}
/* step #2: field validation */
$form_data_template["template_name"] = $_POST["template_name"];
$form_data_source["data_input_type"] = $_POST["data_input_type"];
$form_data_source["t_name"] = html_boolean(isset($_POST["t_name"]) ? $_POST["t_name"] : "");
$form_data_source["active"] = html_boolean(isset($_POST["active"]) ? $_POST["active"] : "");
$form_data_source["t_active"] = html_boolean(isset($_POST["t_active"]) ? $_POST["t_active"] : "");
$form_data_source["polling_interval"] = isset($_POST["polling_interval"]) ? $_POST["polling_interval"] : "";
$form_data_source["t_polling_interval"] = html_boolean(isset($_POST["t_polling_interval"]) ? $_POST["t_polling_interval"] : "");
field_register_error(api_data_source_fields_validate($form_data_source, $suggested_value_fields, "|field|", "sv||field|||id|"));
field_register_error(api_data_source_input_fields_validate($data_input_fields, "|field|"));
field_register_error(api_data_template_fields_validate($form_data_template, "|field|"));
foreach ($data_template_item_fields as $data_template_item_id => $fields) {
$form_data_source_item[$data_template_item_id]["t_rrd_maximum"] = html_boolean(isset($fields["t_rrd_maximum"]) ? $fields["t_rrd_maximum"] : "");
$form_data_source_item[$data_template_item_id]["rrd_maximum"] = isset($fields["rrd_maximum"]) ? $fields["rrd_maximum"] : "";
$form_data_source_item[$data_template_item_id]["t_rrd_minimum"] = html_boolean(isset($fields["t_rrd_minimum"]) ? $fields["t_rrd_minimum"] : "");
$form_data_source_item[$data_template_item_id]["rrd_minimum"] = isset($fields["rrd_minimum"]) ? $fields["rrd_minimum"] : "";
$form_data_source_item[$data_template_item_id]["t_rrd_heartbeat"] = html_boolean(isset($fields["t_rrd_heartbeat"]) ? $fields["t_rrd_heartbeat"] : "");
$form_data_source_item[$data_template_item_id]["rrd_heartbeat"] = isset($fields["rrd_heartbeat"]) ? $fields["rrd_heartbeat"] : "";
$form_data_source_item[$data_template_item_id]["t_data_source_type"] = html_boolean(isset($fields["t_data_source_type"]) ? $fields["t_data_source_type"] : "");
$form_data_source_item[$data_template_item_id]["data_source_type"] = $fields["data_source_type"];
$form_data_source_item[$data_template_item_id]["data_source_name"] = $fields["data_source_name"];
$form_data_source_item[$data_template_item_id]["field_input_value"] = isset($fields["field_input_value"]) ? $fields["field_input_value"] : "";
api_data_source_item_fields_validate($form_data_source_item[$data_template_item_id], "dsi||field|||id|");
}
/* step #3: field save */
if (!is_error_message()) {
$data_template_id = api_data_template_save($_POST["data_template_id"], $form_data_template + $form_data_source);
if ($data_template_id) {
/* copy down the selected rra preset into the data template if a preset is selected */
api_data_template_rra_item_clear($data_template_id);
api_data_template_preset_rra_item_copy($data_template_id, $_POST["preset_rra_id"]);
/* save suggested values (for the 'name' field) */
api_data_template_suggested_values_save($data_template_id, $suggested_value_fields);
/* save custom data input data */
api_data_template_input_fields_save($data_template_id, $data_input_fields);
/* save each data template item on the form */
foreach (array_keys($data_template_item_fields) as $data_template_item_id) {
$form_data_source_item[$data_template_item_id]["data_template_id"] = $data_template_id;
$data_template_item_id = api_data_template_item_save($data_template_item_id, $form_data_source_item[$data_template_item_id]);
if (!$data_template_item_id) {
raise_message(2);
}
}
} else {
raise_message(2);
}
}
if (is_error_message()) {
if (isset($_POST["redirect_item_add"])) {
$action = "item_add";
} else {
$action = "edit";
}
header("Location: data_templates.php?action={$action}" . (empty($data_template_id) ? "&id=" . $_POST["data_template_id"] : "&id={$data_template_id}") . (isset($_POST["data_input_type"]) ? "&data_input_type=" . $_POST["data_input_type"] : "") . (isset($_POST["dif_script_id"]) ? "&script_id=" . $_POST["dif_script_id"] : "") . (isset($_POST["dif_data_query_id"]) ? "&data_query_id=" . $_POST["dif_data_query_id"] : ""));
} else {
raise_message(1);
header("Location: data_templates.php");
}
/* submit button on the actions area page */
} else {
if ($_POST["action_post"] == "box-1") {
$selected_rows = explode(":", $_POST["box-1-action-area-selected-rows"]);
if ($_POST["box-1-action-area-type"] == "remove") {
foreach ($selected_rows as $data_template_id) {
api_data_template_remove($data_template_id);
}
} else {
if ($_POST["box-1-action-area-type"] == "duplicate") {
// yet yet coded
}
}
header("Location: data_templates.php");
/* 'filter' area at the bottom of the box */
} else {
if ($_POST["action_post"] == "data_template_list") {
$get_string = "";
/* the 'clear' button wasn't pressed, so we should filter */
if (!isset($_POST["box-1-action-clear-button"])) {
if (trim($_POST["box-1-search_filter"]) != "") {
$get_string = ($get_string == "" ? "?" : "&") . "search_filter=" . urlencode($_POST["box-1-search_filter"]);
}
}
header("Location: data_templates.php{$get_string}");
}
}
}
}
