As in Kohana 3.3 sort the list of users, the number of orders?

Question

Suppose we have two ORM model:

class Model_User extends ORM
{
    protected $_has_many = array(
        'orders' => array(
            'model' => 'Order',
            'foreign_key' => 'order_id',
            ),
        );
}

class Model_Order extends ORM
{
    protected $_belongs_to = array(
        'author' => array(
            'model' => 'User',
            'foreign_key' => 'author_id',
            ),
        );
}

ORM::factory('User')->find_all(); //Displays a list of all users

As you can see a list of all users, sorted by the number of orders? Is it possible?

can you please provide more detailed description? – Jayson Apr 29 '15 at 13:09 — Jayson, Apr 29 '15 at 13:09

score 1 · Accepted Answer · answered Apr 30 '15 at 05:12

I type this straight out my head, so sorry for eventual mistakes

ORM::factory('user')->join('orders', 'left')
                    ->on('orders.id', '=', 'user.order_id')
                    ->order_by(DB::expr('COUNT("orders.id")')
                    ->find_all();

score 0 · Answer 2 · answered Apr 29 '15 at 13:45

0

you can sort records using order_by

ORM::factory('User')->order_by('order_id', 'desc')->find_all(); //Displays a list of all users

answered Apr 29 '15 at 13:45

Jayson

1,105
7
25

This sort of order ID, and you need their number – entermix Apr 29 '15 at 14:03
what do you mean by this sort of order ID, and you need their number?@entermix – Jayson Apr 30 '15 at 04:54

As in Kohana 3.3 sort the list of users, the number of orders?

2 Answers2