PHP album_build_tree Examples

Example #1

File: album_hierarchy_sql.php Project: GabrielAnca/icy_phoenix

function album_move_tree($cat_id, $move, $user_id = ALBUM_PUBLIC_GALLERY)
{
    global $db, $album_data;
    // if the album_tree is NOT filled then reload the data
    // this will ensure that the album IS populated with data
    if (sizeof($album_data['data']) == 0) {
        album_read_tree($user_id);
    }
    // 'search' the object
    $AH_this = isset($album_data['keys'][$cat_id]) ? $album_data['keys'][$cat_id] : ALBUM_ROOT_CATEGORY;
    // get the root or parent cat id
    $parent = $AH_this < 0 ? ALBUM_ROOT_CATEGORY : $album_data['parent'][$AH_this];
    // renum objects of the same level and regenerate all
    $order = 0;
    $cats = array();
    $parents = array();
    // for the nuber of rows read/categories do this loop
    for ($i = 0; $i < sizeof($album_data['data']); $i++) {
        // ------------------------------------------------------------------------
        // if the current itetorated parent id is equal to the selected category's parent id then
        // reorder the cat_order, the way that, if the found category is the selected category
        // then move the category by the sequentual order number + 'move direction value'
        // else give it the sequentual order number...this will ensure that the selected category
        // always is moved up or down compared to its siblings
        // ------------------------------------------------------------------------
        if ($album_data['parent'][$i] == $parent) {
            $order = $order + 10;
            $neworder = $i == $AH_this ? $order + $move : $order;
            $album_data['data'][$i]['cat_order'] = $neworder;
        }
        // ------------------------------------------------------------------------
        // fill these arrays which are going to be need in building the tree
        // (see album_read_tree for similiar code)
        // ------------------------------------------------------------------------
        $idx = sizeof($cats);
        $cats[$idx] = $album_data['data'][$i];
        $parents[$album_data['parent'][$i]][] = $idx;
    }
    // rebuild the tree
    $album_data = array();
    album_build_tree($cats, $parents);
    // ------------------------------------------------------------------------
    // re-order all categories...in the database acording to the album_tree
    // is really the same things as the reorder_cat in admin/album_cat.php
    // ------------------------------------------------------------------------
    $order = 0;
    for ($i = 0; $i < sizeof($album_data['data']); $i++) {
        $order = $order + 10;
        $sql = "UPDATE " . ALBUM_CAT_TABLE . " SET cat_order={$order} WHERE cat_id=" . $album_data['id'][$i];
        $db->sql_query($sql);
    }
}

Example #2

File: album_hierarchy_functions.php Project: GabrielAnca/icy_phoenix

function album_build_tree(&$cats, &$parents, $level = ALBUM_ROOT_CATEGORY, $parent = ALBUM_ROOT_CATEGORY)
{
    global $db, $album_data, $album_config;
    $album_data_level = array();
    // add the categories of this level
    for ($i = 0; $i < sizeof($parents[$parent]); $i++) {
        $idx = $parents[$parent][$i];
        $album_data_level['id'][] = $cats[$idx]['cat_id'];
        $album_data_level['sort'][] = $cats[$idx][$album_config['album_category_sorting']];
        $album_data_level['data'][] = $cats[$idx];
        $album_data_level['personal'][] = $cats[$idx]['cat_user_id'] == 0 ? 0 : 1;
    }
    // sort the tree level acordingly to the desired category sort
    if (!empty($album_data_level['data'])) {
        if ($album_config['album_category_sorting'] != 'cat_order') {
            if ($album_config['album_category_sorting_direction'] == 'ASC') {
                array_multisort($album_data_level['sort'], SORT_ASC, $album_data_level['id'], $album_data_level['data']);
            } else {
                array_multisort($album_data_level['sort'], SORT_DESC, $album_data_level['id'], $album_data_level['data']);
            }
        } else {
            array_multisort($album_data_level['sort'], SORT_ASC, $album_data_level['id'], $album_data_level['data']);
        }
    }
    // add the tree_level to the tree
    $level++;
    for ($i = 0; $i < sizeof($album_data_level['data']); $i++) {
        $AH_this = sizeof($album_data['data']);
        $key = $album_data_level['id'][$i];
        $album_data['sub'][$parent][] = $key;
        $album_data['keys'][$key] = $AH_this;
        $album_data['parent'][] = $parent;
        $album_data['id'][] = $album_data_level['id'][$i];
        $album_data['data'][] = $album_data_level['data'][$i];
        $album_data['personal'][$key] = $album_data_level['personal'][$i];
        // add sub levels
        album_build_tree($cats, $parents, $level, $key);
    }
    return;
}