function api_graph_tree_item_reparent($graph_tree_item_id, $new_parent_id) { require_once(CACTI_BASE_PATH . "/lib/graph_tree/graph_tree_info.php"); require_once(CACTI_BASE_PATH . "/lib/graph_tree/graph_tree_utility.php"); /* sanity checks */ validate_id_die($graph_tree_item_id, "graph_tree_item_id"); validate_id_die($new_parent_id, "new_parent_id", true); /* find out which tree this item belongs to */ $graph_tree_item = api_graph_tree_item_get($graph_tree_item_id); $parent_graph_tree_item = api_graph_tree_item_get($new_parent_id); /* make sure the parent id actually changed */ if (api_graph_tree_item_parent_get($graph_tree_item_id) == $new_parent_id) { return true; } /* get current key so we can do an sql select on it */ $old_order_key = $graph_tree_item["order_key"]; $new_order_key = api_graph_tree_item_available_order_key_get($graph_tree_item["graph_tree_id"], $parent_graph_tree_item["order_key"]); /* make sure nothing bad happens */ if ((!api_graph_tree_item_order_key_validate($old_order_key)) || (!api_graph_tree_item_order_key_validate($new_order_key))) { return false; } /* get the item depth of the source and destination branches */ $old_starting_depth = api_graph_tree_item_depth_get($old_order_key); $new_starting_depth = api_graph_tree_item_depth_get($new_order_key); /* get the parent order key prefix for the source and destination branches */ $old_base_prefix = substr($old_order_key, 0, ($old_starting_depth * CHARS_PER_TIER)); $new_base_prefix = substr($new_order_key, 0, ($new_starting_depth * CHARS_PER_TIER)); /* prevent possible collisions */ db_execute("UPDATE graph_tree_items SET order_key = CONCAT('x',order_key) WHERE order_key LIKE '" . sql_sanitize($old_base_prefix) . "%%' AND graph_tree_id = " . $graph_tree_item["graph_tree_id"]); /* truncate */ if ($new_starting_depth >= $old_starting_depth) { db_execute("UPDATE graph_tree_items SET order_key = SUBSTRING(REPLACE(order_key, 'x" . sql_sanitize($old_base_prefix) . "', '" . sql_sanitize($new_base_prefix) . "'), 1, " . (MAX_TREE_DEPTH * CHARS_PER_TIER) . ") WHERE order_key LIKE 'x" . sql_sanitize($old_base_prefix) . "%%' AND graph_tree_id = " . $graph_tree_item["graph_tree_id"]); /* append */ }else{ db_execute("UPDATE graph_tree_items SET order_key = CONCAT(REPLACE(order_key, 'x" . sql_sanitize($old_base_prefix) . "', '" . sql_sanitize($new_base_prefix) . "'), '" . str_repeat('0', (strlen($old_base_prefix) - strlen($new_base_prefix))) . "') WHERE order_key LIKE 'x" . sql_sanitize($old_base_prefix) . "%%' AND graph_tree_id = " . $graph_tree_item["graph_tree_id"]); } }
function api_tree_item_save($id, $tree_id, $type, $parent_tree_item_id, $title, $local_graph_id, $rra_id, $host_id, $host_grouping_type, $sort_children_type, $propagate_changes) { require_once(CACTI_BASE_PATH . "/lib/graph_tree/graph_tree_utility.php"); $parent_order_key = db_fetch_cell("select order_key from graph_tree_items where id=$parent_tree_item_id"); /* fetch some cache variables */ if (empty($id)) { /* new/save - generate new order key */ $order_key = api_graph_tree_item_available_order_key_get($parent_order_key, "graph_tree_items", "order_key", "graph_tree_id=$tree_id"); }else{ /* edit/save - use old order_key */ $order_key = db_fetch_cell("select order_key from graph_tree_items where id=$id"); } /* duplicate graph check */ $search_key = substr($parent_order_key, 0, (api_graph_tree_item_depth_get($parent_order_key) * CHARS_PER_TIER)); if (($type == TREE_ITEM_TYPE_GRAPH) && (sizeof(db_fetch_assoc("select id from graph_tree_items where local_graph_id='$local_graph_id' and graph_tree_id='$tree_id' and order_key like '$search_key" . str_repeat('_', CHARS_PER_TIER) . str_repeat('0', (MAX_TREE_DEPTH * CHARS_PER_TIER) - (strlen($search_key) + CHARS_PER_TIER)) . "'")) > 0)) { return 0; } $save["id"] = $id; $save["graph_tree_id"] = $tree_id; $save["title"] = form_input_validate($title, "title", "", ($type == TREE_ITEM_TYPE_HEADER ? false : true), 3); $save["order_key"] = $order_key; $save["local_graph_id"] = form_input_validate($local_graph_id, "local_graph_id", "", true, 3); $save["rra_id"] = form_input_validate($rra_id, "rra_id", "", true, 3); $save["host_id"] = form_input_validate($host_id, "host_id", "", true, 3); $save["host_grouping_type"] = form_input_validate($host_grouping_type, "host_grouping_type", "", true, 3); $save["sort_children_type"] = form_input_validate($sort_children_type, "sort_children_type", "", true, 3); $tree_item_id = 0; if (!is_error_message()) { $tree_item_id = sql_save($save, "graph_tree_items"); if ($tree_item_id) { raise_message(1); /* re-parent the branch if the parent item has changed */ if ($parent_tree_item_id != $tree_item_id) { reparent_branch($tree_item_id, $parent_tree_item_id); } $tree_sort_type = db_fetch_cell("select sort_type from graph_tree where id='$tree_id'"); /* tree item ordering */ if ($tree_sort_type == TREE_ORDERING_NONE) { /* resort our parent */ $parent_sorting_type = db_fetch_cell("select sort_children_type from graph_tree_items where id=$parent_tree_item_id"); if ((!empty($parent_tree_item_id)) && ($parent_sorting_type != TREE_ORDERING_NONE)) { sort_tree(SORT_TYPE_TREE_ITEM, $parent_tree_item_id, $parent_sorting_type); } /* if this is a header, sort direct children */ if (($type == TREE_ITEM_TYPE_HEADER) && ($sort_children_type != TREE_ORDERING_NONE)) { sort_tree(SORT_TYPE_TREE_ITEM, $tree_item_id, $sort_children_type); } /* tree ordering */ }else{ /* potential speed savings for large trees */ if (api_graph_tree_item_depth_get($save["order_key"]) == 1) { sort_tree(SORT_TYPE_TREE, $tree_id, $tree_sort_type); }else{ sort_tree(SORT_TYPE_TREE_ITEM, $parent_tree_item_id, $tree_sort_type); } } /* if the user checked the 'Propagate Changes' box */ if (($type == TREE_ITEM_TYPE_HEADER) && ($propagate_changes == true)) { $search_key = preg_replace("/0+$/", "", $order_key); $tree_items = db_fetch_assoc("select graph_tree_items.id from graph_tree_items where graph_tree_items.host_id = 0 and graph_tree_items.local_graph_id = 0 and graph_tree_items.title != '' and graph_tree_items.order_key like '$search_key%%' and graph_tree_items.graph_tree_id='$tree_id'"); if (sizeof($tree_items) > 0) { foreach ($tree_items as $item) { db_execute("update graph_tree_items set sort_children_type = '$sort_children_type' where id = '" . $item["id"] . "'"); if ($sort_children_type != TREE_ORDERING_NONE) { sort_tree(SORT_TYPE_TREE_ITEM, $item["id"], $sort_children_type); } } } } }else{ raise_message(2); } } return $tree_item_id; }