Jelly

Good job, Alexander!
I was scheduled to make mptt library for Jelly for the upcoming project, but you're way ahead of me... :)

I would propose to take off some of the methods out of the model, using the extending of the query builder to make your model code more jellyfied. :)

Thanks for reply, Sergei! I'll try to apply your advice as soon as possible. For me it was like a training but I'm going to look some real applications to try this code.

Thanks for this Alexander.

We have eventual plans to include MPTT and other tree algorithms as behaviors in Jelly however judging by our current workload and amount of time we have available it could be some time so this port could be very useful.

Just thought I'd let you know the plans!

Thanks for reply, Paul. Really I've read you mentioned about some 'native' MPTT implementation for Jelly, but I have little experience with Jelly extension yet and could not invent anything more intellectual. If you share some thoughts about how that should be done, maybe I'll try to do something.

Wow this is what I've been waiting for. Even if the code base is not yet so clean, as long as it works, I'll use it. :) Thanks Alexander!

Works perfectly. Thanks all for this.

I begin with MPTT and wondering how to retreive an array (for json encoding) in place of a list.
What would be the best (less consumption) recursion method to put in place or is there another way?

Hello,
I don't know if this will support a big collection.
Some opinion ?

    // retrieve all descendants of the $root node
    $nodes = Jelly::select('collection', 1)->descendants(TRUE)->as_array();

    $stack = array();
    for($x =0; $x < count($nodes); $x++) {
        $node = &$nodes[$x];
        $node['children'] = array();
        while(count($stack) > 0 && $stack[count($stack) - 1]['rgt'] < $node['rgt']) {
                array_pop($stack);
        }

        if(count($stack) > 0) {
                $stack[count($stack) - 1]['children'][] = &$node; 
        }        
        $stack[] = &$node;
    }
    return json_encode($stack[0]);

I don't know if this will support a big collection. Some opinion ?

I don't know how to answer. Firstly, what are you trying to do?

Secondly, what do you mean by 'support' and what do you mean by 'big'?

Anything that works with a small collection will work equally well with a big collection given enough RAM and processing time. Whether it is quick/efficient enough for your particular application on your server(s) we can't possibly comment on.

I am sorry Paul. I don't receive email notification on the posts from this forum. Don't know why!
I will stress test MPTT/Jelly with a lot of different queries.
I keep in mind to come back with timing/processing results.
Thanks for your answer.