Alter Default Model::find() behavior?

Question

Alter Default Model::find() behavior?

ImmortalFirefly21 Aug '13

Created Aug '13	Last Reply Aug '13	Replies 1	Views 1010	Votes 1

ImmortalFirefly21 18.6k

Aug '13

Is there a way to alter the default Model::find() query? With something such as making it order by a certain field by default or do we have to use afterFetch() and sort it through PHP commands?

1

ImmortalFirefly21
18.6k

Accepted
answer

Aug '13

Perfect! Just what I needed.

ImmortalFirefly21 · Answer 1 · 2013-08-17T13:21:27-07:00

I guess I should have posted more detail.....

The reason why is because I have for instance a countries table and I know that anytime I need the countries I'm going to sort it by the weight column and then the name column on every single drop down I do for countries.

I could do Countries::find(array(“order” => “weight DESC, name ASC”)), but doing that on everything...... :(

Phalcon · Answer 2 · 2013-08-19T07:46:31-07:00

You can intercept the find action and change its behavior:

class Countries extends Phalcon\Mvc\Model
{
    public static function find($params=null)
    {
        if (is_array($params)) {
            if (!isset($params['order'])) {
                $params['order'] = 'weight DESC, name ASC';
            }
        }
        return parent::find($params);
    }   
}