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}"); } } } }