Lithium - Find tree based on relationships

Question

I have created a RESTful PHP web service using Lithium which contains comments, each comment can have a parent comment allowing comments to be infinitely recursive.

I have set up the relationship within my model using the correct key.

My data is currently formatted list this (using Model::()):

Array
(
    [1C19FA9D-0432-A382-5236-2C59E0967F58] => Array
        (
            [id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
            [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
            [parent_id] => 
            [user_id] => 4
            [comment] => This is a test
            [created] => 2012-03-16 16:41:33
            [updated] => 
        )

    [3B2350BA-9BA7-D7D4-2ED4-42BD40BC1AF0] => Array
        (
            [id] => 3B2350BA-9BA7-D7D4-2ED4-42BD40BC1AF0
            [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
            [parent_id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
            [user_id] => 543
            [comment] => Testing
            [created] => 2012-03-16 17:25:47
            [updated] => 
        )

    [4CFD2D8B-D05F-7C8A-E2A9-38D5677280A9] => Array
        (
            [id] => 4CFD2D8B-D05F-7C8A-E2A9-38D5677280A9
            [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
            [parent_id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
            [user_id] => 53
            [comment] => A Test
            [created] => 2012-03-16 17:25:38
            [updated] => 
        )
)

And I would prefer it was formatted like this

Array
(
    [0] => Array
        (
            [id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
            [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
            [parent_id] => 
            [user_id] => 4
            [comment] => This is a test
            [created] => 2012-03-16 16:41:33
            [updated] =>
            [comment] => Array(
                [0] => Array
                (
                    [id] => 3B2350BA-9BA7-D7D4-2ED4-42BD40BC1AF0
                    [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
                    [parent_id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
                    [user_id] => 543
                    [comment] => Testing
                    [created] => 2012-03-16 17:25:47
                    [updated] => 
                )
                [1] => Array
                (
                    [id] => 3B2350BA-9BA7-D7D4-2ED4-42BD40BC1AF0
                    [page_id] => 0384F94C-8B99-F692-62D0-7B24B0885257
                    [parent_id] => 1C19FA9D-0432-A382-5236-2C59E0967F58
                    [user_id] => 543
                    [comment] => A Test
                    [created] => 2012-03-16 17:25:47
                    [updated] => 
                )
            )
        )
)

Is there a recursing function built in to Lithium or is this something I would have to create myself? Please also note the changes in Keys.

score 0 · Accepted Answer · answered Apr 03 '12 at 08:27

To fix this I actually ended up generating my own array from the results as follows:

       public function index($page_id) {
            $page = Pages::first($page_id);
            $site = Sites::first($page->site_id);
            $comments = Comments::all(array('conditions' => array('page_id' => $page->id, 'comment_id' => NULL)));

            if ($this->request->type == 'JSON')
                $comments = $this->_recursiveComments($comments, $page);

            return compact('comments', 'page', 'site');
        }

        protected function _recursiveComments($comments, $page) {
            foreach($comments as $c) {
                $children = Comments::all(array('conditions' => array('comment_id' => $c->id)));
                $c->children = $children;

                $this->_recursiveComments($children, $page);
            }

            return $comments;
        }

That way I could just do a foreach($comments as $key => $value) loop and avoid the random keys.

Lithium - Find tree based on relationships

1 Answers1