Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

"usort" a Doctrine\Common\Collections\ArrayCollection?

In various cases I need to sort a Doctrine\Common\Collections\ArrayCollection according to a property in the object. Without finding a method doing that right away, I do this:

// $collection instanceof Doctrine\Common\Collections\ArrayCollection $array = $collection->getValues(); usort($array, function($a, $b){     return ($a->getProperty() < $b->getProperty()) ? -1 : 1 ; });  $collection->clear(); foreach ($array as $item) {     $collection->add($item); } 

I presume this is not the best way when you have to copy everything to native PHP array and back. I wonder if there is a better way to "usort" a Doctrine\Common\Collections\ArrayCollection. Do I miss any doc?

like image 932
luiges90 Avatar asked May 23 '13 03:05

luiges90


1 Answers

To sort an existing Collection you are looking for the ArrayCollection::getIterator() method which returns an ArrayIterator. example:

$iterator = $collection->getIterator(); $iterator->uasort(function ($a, $b) {     return ($a->getPropery() < $b->getProperty()) ? -1 : 1; }); $collection = new ArrayCollection(iterator_to_array($iterator)); 

The easiest way would be letting the query in the repository handle your sorting.

Imagine you have a SuperEntity with a ManyToMany relationship with Category entities.

Then for instance creating a repository method like this:

// Vendor/YourBundle/Entity/SuperEntityRepository.php  public function findByCategoryAndOrderByName($category) {     return $this->createQueryBuilder('e')         ->where('e.category = :category')         ->setParameter('category', $category)         ->orderBy('e.name', 'ASC')         ->getQuery()         ->getResult()     ; } 

... makes sorting pretty easy.

Hope that helps.

like image 75
Nicolai Fröhlich Avatar answered Sep 19 '22 21:09

Nicolai Fröhlich