php - How to sort a massive/object

Solution:

Do you read the data from a database? then simply add to your querySORT BY id DESC

else you may use usort() in PHP:

usort($events, function ($a, $b) { return $a->id - $b->id; });
Copy code

Solution:

adding anorder() to the query doesn't get you there?

$events[] =$this->_dbTable->fetchAll($this->_dbTable->select()
    ->from($this->_dbTable,
        array('id','resource_types','resource_ids','action','originator','event_date'))
    ->where('resource_types = ?', 'business')
    ->where('resource_ids',$bus->id)
    ->order('id DESC'));
$events[] =$this->_dbTable->fetchAll($this->_dbTable->select()
    ->from($this->_dbTable,
        array('id','resource_types','resource_ids','action','originator','event_date'))
    ->where('resource_types = ?', 'document-type')
    ->where('resource_ids',$dt->id)
    ->order('id DESC'));
return $events
Copy code

it looks to me like this is all coming from the same table, if so why not build a single query?

Maybe something like:

$events[] = $this->_dbTable->fetchAll($this->_dbTable->select()
              ->from($this->_dbTable,
                   array('id','resource_types','resource_ids','action','originator','event_date'))
              ->where('resource_types IN (?)', array('business', 'document-type'))
              ->where('resource_ids IN (?)', array($bus->id, $dt->id))
              ->order('id DESC'));
Copy code

Not real sure if this will help get you there, maybe.

Solution:

This sucks, since you have to go through the list twice, but you could...

$events_arr = array();
<?php foreach ($this->events as $usern): ?><?php foreach ($usern as $user): ?>
    $events_arr[$user_id][] = $usern; endforeach; endforeach;
ksort($events_arr);
Copy code

Now you can use events arr, which is sorted by user_id

foreach ($events_arr as $user_id => $usern) {
  foreach ($usern as $user) {
    echo $user_id . ": " . $user->action;
  }
}
Copy code

Solution:

Decided to denormolise my DB Table to make the process of selection data easier. Let's see if it get's better.