How to sort CakePHP multidimensional arrays?

Question

Find statements in CakePHP produce an array structured as below. I've already ordered my search to produce the result set shown (ordered by combined_score). Now, I'd like to apply a sorting function on the data to sort by "average_votes". See "from this:"/"to this:" below.

I'd really appreciate any suggestions.

From this:
Array
(
[0] => Array
    (
        [Vehicle] => Array
            (
                [id] => 52
                [user_id] => 101
                [name] => Ford
                [total_votes] => 5
                [average_votes] => 3.8
                [combined_score] => 19
            )

    )

[1] => Array
    (
        [Vehicle] => Array
            (
                [id] => 48
                [user_id] => 101
                [name] => Nissan
                [total_votes] => 6
                [average_votes] => 5
                [combined_score] => 2
            )
    )
)

To this:
Array
(
[0] => Array
    (
        [Vehicle] => Array
            (
                [id] => 48
                [user_id] => 101
                [name] => Nissan
                [total_votes] => 6
                [average_votes] => 5
                [combined_score] => 2
            )
    )   

[1] => Array
    (
        [Vehicle] => Array
            (
                [id] => 52
                [user_id] => 101
                [name] => Ford
                [total_votes] => 5
                [average_votes] => 3.8
                [combined_score] => 19
            )

    )

)

Jon, which of these related links show how to sort by data 3 levels deep as shown above? — stevenmc
– stevenmc, Commented May 2, 2012 at 9:59
Ori, I have asked the database to sort by combined_score, and then with that result set, I need to sort by average_votes. Do you have any suggestions on how to do what you say? — stevenmc
– stevenmc, Commented May 2, 2012 at 10:00
Now you should have enough rep to self-answer your question. — Rizier123
– Rizier123, Commented Mar 1, 2016 at 23:14

Adam Brett · Accepted Answer · 2012-05-02 10:28:47Z

2

Depending on what you're actually trying to achieve you can still do this at the database level in cake, like so:

$this->Vehicle->find('all',array('order' => array('Vehicle.combined_score' => 'asc', 'Vehicle.average_votes' => 'desc')));

Which will first sort by combined score, and then sort by average votes

The second option is to use the cakephp Set class, like so:

$results = Set::sort($results, '{n}.Vehicle.average_votes', 'desc');

answered May 2, 2012 at 10:28

Adam Brett

1615 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saanch · Accepted Answer · 2012-05-02 10:02:02Z

2

In your controller the find function you can add option for sorting.

$this->Vehicle->find('all',array('order' => array('Vehicle.average_votes DESC')));

answered May 2, 2012 at 10:02

Saanch

1,8541 gold badge24 silver badges38 bronze badges

1 Comment

stevenmc Over a year ago

Thanks gvLearner, but as I mentioned in my post, I need it first sorted by combined_score, and then I need to take that result set and resort it by average votes.

Collectives™ on Stack Overflow

How to sort CakePHP multidimensional arrays?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related