Best way to add relations to resultset

Question

Best way to add relations to resultset

dimhoLt Jul '13

Created Jul '13	Last Reply Jul '13	Replies 1	Views 933	Votes 1

dimhoLt 22.6k

Jul '13

Hello!

I have a number of groups of items I want to retrieve using AJAX (foreign key to the user owning the groups). This works perfectly:

    public function loadGroupsAction() {
        header("Content-Type: application/json; charset=utf-8");

        $data = array();
        $user = User::loadUserFromSession($this->session);
        if($user instanceof User) {
            $groups = $user->getGroup(array("order" => "id asc"));
            $data["groups"] = $groups->toArray();
        }

        $this->exitSuccessfully($data);
    }

Now, the problem is that in the front end requesting the AJAX, I also want to show the number of items each group contains. This is also solved with keys and relations set up in the model, but when I do $user->getGroups(), I obviously get a resultset, which I can't add data to. The only solution I see right now is either creating a specialized query instead, or looping over each resultset item and adding it to a separate array which I then relay back in the response, but both of these solutions are really poor.

Which would be the best way of retrieving the user's Groups, then including the count of the Items from the groups?

Hope I made sense .___.

Thanks for an awesome framework.

// dimhoLt

1

Karol Marcinkiewicz · Answer 1 · 2013-07-04T22:43:46-07:00

You can use new phacon model event: afterFetch(), this is not described in DOC, but you can find it on this forum. https://forum.phalcon.io/discussion/388/how-to-get-all-event-types-do-phalcon-has-onload-event-

In your case you can do something like this:

in model User:

public function afterFetch()
{
    $this->user_groups = Groups::find("user_id=".$this->user_id)->toArray(); //try to cache this in production
}

in your code you have user goups under $user->user_groups property.

dimhoLt · Answer 2 · 2013-07-05T03:38:31-07:00

dimhoLt
22.6k

Jul '13

THANK YOU! I was wondering why there were only update / save events.